-
-
Module:
BenAdmin
- Report
-
-
Item State:
Production Complete
- Closed
To provide facility for users(Partner/Broker/CA) at same hierarchy or at higher hierarchy to access the Invoice Templates and Invoices created by each other. This will only happen for companies that are assigned to respective users(Partner/Broker/CA). SA user will be able access all Invoices for all companies with all rights.
Example:
Company C1 has 2 Partners (P1, P2) and 1 Broker (B1)
Invoice Template T1 is created by Partner P1. Invoices against this template are also generated. Template T1 and the generated Invoices can be accessed by SA(higher hierarchy) and Partner P2(same hierarchy). Broker B1 cannot access the template or invoices generated.
{"report":{"apdex":0.5,"isInitial":true,"journeyId":"2a6295f8-8531-4480-80da-8b4e870a2985","key":"jira.project.issue.view-issue","navigationType":0,"readyForUser":1062.5999999046326,"redirectCount":0,"resourceLoadedEnd":852.0999999046326,"resourceLoadedStart":292.2999997138977,"resourceTiming":[{"duration":19.100000381469727,"initiatorType":"link","name":"https://jira.workterra.net/s/3003653444a1e1a85555cab7dcfb3a21-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/2e46d90b5cae895c9c38649c9d510130/_/download/contextbatch/css/_super/batch.css","startTime":292.2999997138977,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":292.2999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":311.40000009536743,"responseStart":0,"secureConnectionStart":0},{"duration":19.40000009536743,"initiatorType":"link","name":"https://jira.workterra.net/s/dd6a0911920485696ac20493290df627-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/3abe50d469404b639745df44b51476b6/_/download/contextbatch/css/jira.browse.project,jira.view.issue,project.issue.navigator,jira.global,atl.general,-_super/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&richediton=true","startTime":292.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":292.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":311.90000009536743,"responseStart":0,"secureConnectionStart":0},{"duration":19.799999713897705,"initiatorType":"link","name":"https://jira.workterra.net/s/d41d8cd98f00b204e9800998ecf8427e-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/8.5.0/_/download/batch/com.atlassian.auiplugin:split_aui.pattern.label/com.atlassian.auiplugin:split_aui.pattern.label.css","startTime":292.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":292.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":312.2999997138977,"responseStart":0,"secureConnectionStart":0},{"duration":22,"initiatorType":"link","name":"https://jira.workterra.net/s/bd548f27bbf8f278bd83b60dd3284ed8-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/1.0/_/download/batch/jira.webresources:global-static-adgs/jira.webresources:global-static-adgs.css","startTime":292.69999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":292.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":314.69999980926514,"responseStart":0,"secureConnectionStart":0},{"duration":22.300000190734863,"initiatorType":"link","name":"https://jira.workterra.net/s/70725731a158a7140f19ddbd4201ba27-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/1.0/_/download/batch/jira.webresources:global-static/jira.webresources:global-static.css","startTime":292.7999997138977,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":292.7999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":315.09999990463257,"responseStart":0,"secureConnectionStart":0},{"duration":380.5,"initiatorType":"script","name":"https://jira.workterra.net/s/f2623af22c15df767ec6ff268ae0b8bd-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/2e46d90b5cae895c9c38649c9d510130/_/download/contextbatch/js/_super/batch.js?locale=en-US","startTime":292.90000009536743,"connectEnd":292.90000009536743,"connectStart":292.90000009536743,"domainLookupEnd":292.90000009536743,"domainLookupStart":292.90000009536743,"fetchStart":292.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":316.90000009536743,"responseEnd":673.4000000953674,"responseStart":437.5,"secureConnectionStart":292.90000009536743},{"duration":559.1999998092651,"initiatorType":"script","name":"https://jira.workterra.net/s/6ce676f2a5bcc9651cef6e7956f05def-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/3abe50d469404b639745df44b51476b6/_/download/contextbatch/js/jira.browse.project,jira.view.issue,project.issue.navigator,jira.global,atl.general,-_super/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&locale=en-US&richediton=true","startTime":292.90000009536743,"connectEnd":292.90000009536743,"connectStart":292.90000009536743,"domainLookupEnd":292.90000009536743,"domainLookupStart":292.90000009536743,"fetchStart":292.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":318.2999997138977,"responseEnd":852.0999999046326,"responseStart":433,"secureConnectionStart":292.90000009536743},{"duration":91.59999990463257,"initiatorType":"script","name":"https://jira.workterra.net/s/ecf7ec549751ae117b778f0525d6d371-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/4.1.5/_/download/resources/com.atlassian.plugins.atlassian-chaperone:hotspot-tour/hotspot-tour.js?batch=false&locale=en-US","startTime":293.09999990463257,"connectEnd":293.09999990463257,"connectStart":293.09999990463257,"domainLookupEnd":293.09999990463257,"domainLookupStart":293.09999990463257,"fetchStart":293.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":319.7999997138977,"responseEnd":384.69999980926514,"responseStart":382.2999997138977,"secureConnectionStart":293.09999990463257},{"duration":92.7000002861023,"initiatorType":"script","name":"https://jira.workterra.net/s/6aa3fcf1fac5fd551eee0b69077524e6-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/aae1242f5fc81cc6a5bb8bc963ccda29/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en-US","startTime":293.19999980926514,"connectEnd":293.19999980926514,"connectStart":293.19999980926514,"domainLookupEnd":293.19999980926514,"domainLookupStart":293.19999980926514,"fetchStart":293.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":319.90000009536743,"responseEnd":385.90000009536743,"responseStart":385.40000009536743,"secureConnectionStart":293.19999980926514},{"duration":93.2000002861023,"initiatorType":"script","name":"https://jira.workterra.net/s/d41d8cd98f00b204e9800998ecf8427e-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":293.2999997138977,"connectEnd":293.2999997138977,"connectStart":293.2999997138977,"domainLookupEnd":293.2999997138977,"domainLookupStart":293.2999997138977,"fetchStart":293.2999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":320.69999980926514,"responseEnd":386.5,"responseStart":386,"secureConnectionStart":293.2999997138977},{"duration":93.69999980926514,"initiatorType":"script","name":"https://jira.workterra.net/s/d41d8cd98f00b204e9800998ecf8427e-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":293.40000009536743,"connectEnd":293.40000009536743,"connectStart":293.40000009536743,"domainLookupEnd":293.40000009536743,"domainLookupStart":293.40000009536743,"fetchStart":293.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":322,"responseEnd":387.09999990463257,"responseStart":386.59999990463257,"secureConnectionStart":293.40000009536743},{"duration":94,"initiatorType":"script","name":"https://jira.workterra.net/s/ecf7ec549751ae117b778f0525d6d371-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/8.5.0/_/download/batch/com.atlassian.auiplugin:split_aui.pattern.label/com.atlassian.auiplugin:split_aui.pattern.label.js?locale=en-US","startTime":293.59999990463257,"connectEnd":293.59999990463257,"connectStart":293.59999990463257,"domainLookupEnd":293.59999990463257,"domainLookupStart":293.59999990463257,"fetchStart":293.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":324.09999990463257,"responseEnd":387.59999990463257,"responseStart":387.09999990463257,"secureConnectionStart":293.59999990463257},{"duration":28.200000286102295,"initiatorType":"link","name":"https://jira.workterra.net/s/05c862146699bb029ceb0a489075e63b-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/bcd66e9a133a1b9f5fd14b56841e1c5b/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":293.69999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":293.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":321.90000009536743,"responseStart":0,"secureConnectionStart":0},{"duration":94.5,"initiatorType":"script","name":"https://jira.workterra.net/rest/api/1.0/shortcuts/805012/ea6f30d2bfdc99578bb23f4a5bac3ecd/shortcuts.js?context=issuenavigation&context=issueaction","startTime":293.7999997138977,"connectEnd":293.7999997138977,"connectStart":293.7999997138977,"domainLookupEnd":293.7999997138977,"domainLookupStart":293.7999997138977,"fetchStart":293.7999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":326.09999990463257,"responseEnd":388.2999997138977,"responseStart":387.69999980926514,"secureConnectionStart":293.7999997138977},{"duration":30,"initiatorType":"link","name":"https://jira.workterra.net/s/9095228fa10daa2d3e3d7d5760c95e91-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/72477c22780abda5f51fe696920d843f/_/download/contextbatch/css/com.atlassian.jira.projects.sidebar.init,-_super,-jira.view.issue,-project.issue.navigator/batch.css?jira.create.linked.issue=true&richediton=true","startTime":293.90000009536743,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":293.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":323.90000009536743,"responseStart":0,"secureConnectionStart":0},{"duration":110.40000009536743,"initiatorType":"script","name":"https://jira.workterra.net/s/c19a1b46e985d7fb85efaf27c8febfdd-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/72477c22780abda5f51fe696920d843f/_/download/contextbatch/js/com.atlassian.jira.projects.sidebar.init,-_super,-jira.view.issue,-project.issue.navigator/batch.js?jira.create.linked.issue=true&locale=en-US&richediton=true","startTime":294,"connectEnd":294,"connectStart":294,"domainLookupEnd":294,"domainLookupStart":294,"fetchStart":294,"redirectEnd":0,"redirectStart":0,"requestStart":326.5,"responseEnd":404.40000009536743,"responseStart":403.69999980926514,"secureConnectionStart":294},{"duration":115.80000019073486,"initiatorType":"script","name":"https://jira.workterra.net/s/d41d8cd98f00b204e9800998ecf8427e-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":295.09999990463257,"connectEnd":295.09999990463257,"connectStart":295.09999990463257,"domainLookupEnd":295.09999990463257,"domainLookupStart":295.09999990463257,"fetchStart":295.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":347.09999990463257,"responseEnd":410.90000009536743,"responseStart":410.40000009536743,"secureConnectionStart":295.09999990463257},{"duration":94.2000002861023,"initiatorType":"script","name":"https://jira.workterra.net/s/d41d8cd98f00b204e9800998ecf8427e-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":317.19999980926514,"connectEnd":317.19999980926514,"connectStart":317.19999980926514,"domainLookupEnd":317.19999980926514,"domainLookupStart":317.19999980926514,"fetchStart":317.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":349.90000009536743,"responseEnd":411.40000009536743,"responseStart":411,"secureConnectionStart":317.19999980926514},{"duration":98,"initiatorType":"xmlhttprequest","name":"https://jira.workterra.net/rest/webResources/1.0/resources","startTime":817.9000000953674,"connectEnd":817.9000000953674,"connectStart":817.9000000953674,"domainLookupEnd":817.9000000953674,"domainLookupStart":817.9000000953674,"fetchStart":817.9000000953674,"redirectEnd":0,"redirectStart":0,"requestStart":862.6999998092651,"responseEnd":915.9000000953674,"responseStart":915.1999998092651,"secureConnectionStart":817.9000000953674}],"threshold":1000,"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":33,"connectEnd":120,"secureConnectionStart":85,"requestStart":120,"responseStart":286,"responseEnd":316,"domLoading":290,"domInteractive":1131,"domContentLoadedEventStart":1131,"domContentLoadedEventEnd":1205,"domComplete":1324,"loadEventStart":1324,"loadEventEnd":1326,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[],"measures":[],"correlationId":"9a9d8fe337e449","effectiveType":"4g","downlink":9.5,"rtt":0,"serverDuration":78,"dbReadsTimeInMs":15,"dbConnsTimeInMs":18,"applicationHash":"156decd7d2b4272533aa6cefc8294af635e1da97","experiments":[]}}
Below are 3C's :-
Concern :- Invoice not accessible to any other user except creator user
Cause :- Invoice accessibility was blocked to user other than who created the template
Correction :- Given access to users whose role is same or greater than template creator user
Example: Template created by CA. Earlier accessible to only that CA. Now will be accessible to Partner as well as SA.
They can Edit or delete invoice templates / generated invoices. Also can generate invoice
Affected Areas :- Select Invoice Page
Create Invoice Page
Generate Invoice Page
InvoiceDetails_History Table
InvoiceList_History Table
Affected Files :-
MasterCompanyDB/04_Stored Procedures/dbo.OES_SP_Invoice_DeleteInvoiceRecords.StoredProcedure.sql
MasterCompanyDB/04_Stored Procedures/OES_SP_Invoice_CAEligibleTemplates.sql
MasterCompanyDB/05_Triggers/dbo.trgDelInVoiceDetails_History.sql
MasterCompanyDB/05_Triggers/dbo.[trgDelInvoiceList_History.sql
MasterCompanyDB/05_Triggers/dbo.trgInsInVoiceDetails_History.sql
MasterCompanyDB/05_Triggers/dbo.trgInsInvoiceList_History.sql
MasterCompanyDB/05_Triggers/dbo.trgUpdInVoiceDetails_History.sql
MasterCompanyDB/05_Triggers/dbo.trgUpdInvoiceList_History.sql
MasterCompanyDB/01_DDL/566_
WT-9588_WTB_Report_NewTable_InVoiceDetails_History.sqlMasterCompanyDB/01_DDL/567_
WT-9588_WTB_Report_NewTable_InvoiceList_History.sqlApp/BusinessLogic/InvoiceManagement/InvoiceDetails.cs
App/BusinessLogic/InvoiceManagement/InvoiceManagement.dll.config
Shared Library/ValueObjects/ValueObjects/AddInvoiceDetails.cs
BenAdmin/Areas/Report/Models/InvoiceManagement/CreateInvoiceModel.cs
BenAdmin/Areas/Report/Models/InvoiceManagement/SelectInvoiceModel.cs
Tested Scenarios:-
User acces policy
1) User with role greater or equal to creator role should be able to edit,delete and generate invoice.
2) User with role smaller than creator role should not be able to edit,delete and generate invoice.
Note :- 1) If a user has created template and generated invoice then anyone cannot delete or modify template as per feature of system.
2) Consider, CA has created a template and SA has generated respective invoice. Though the invoice is generated by SA, all the users(Partner/Broker/CA) who have access to it can update / delete the generated invoice.
Triggers
1) History should be tracked when Invoice template is created / updated / deleted.
2) History should be tracked when Invoice is created / finalized / due date is updated / deleted.
Note :-
For now we are tracking changes made by user only on two tables InvoiceDetails and InvoiceList by maintaining history table
For detailed tracking of users we need to maintain history tables of below tables :-
InvoiceEmployeeStatus
InvoiceDetails_LocalizeFields
InvoiceBenefitwiseBilling
InvoiceHeaderFields
InvoiceMappingFields
InvoiceDocumentList
InvoicePlandesign
InvoiceProvider
InvoiceBenefits
InvoiceDetailClass1
InvoiceDetailClass2
InvoiceDetailClass3
InvoiceDetailClass4
These will be covered in ticket
WT-7762