{panel:bgColor=#deebff}
Assume user has permission to any module for a site, therefore only checks the {{rcra_industry_site}} table.
Note the query is setup to allow someone to enter the user_id (e.g. johndoe) for convenience in SQL Developer - these can be altered to use synthetic key by removing
{{site.user_id = (SELECT id FROM rcra_user_profile prof WHERE prof.user_id = upper(:userid))}}
and replacing with
{{site.user_id = :userId}}
Returns a row for each ready for payment bill that a user has site permission to.
{panel}
Acceptance Criteria This ticket is considered complete when the following changes have been made to the e-Manifest pill - found within the Outstanding Actions panel of the Overview tab:
(x) This panel will only include data from Invoice Due records that have outstanding actions that need to be completed by industry users {color:#4c9aff}(industry statuses of: Ready for Payment{color})
{color:#4c9aff}Users will be able to view Invoice Due submissions for all sites that the user has in their my sites list{color}
Invoice Due Panel:
(x) Show X Entries: dropdown allowing users to select how many entries to display per page. Options include 5, 10, 20, and 50 with a default value of 10
Columns:
(x) Site ID: read-only display of the site ID
Note: if the user requests a new site and an ID has not yet been assigned, this field will display “Not Yet Assigned” and the hyperlink for the Site Name will take the user to the Outstanding Site ID Requests tab instead of the module tab
(x) Site Name: displays the site name as a hyperlink that will launch the user to the e-Manifest tab for the specific site that was selected if they have the permissions to that module
Note: if the user does not have permissions to that module, the site name should not be a hyperlink.
(x) Updated: read-only display of the date the submission was last updated
(x) Action Item: read-only display of the submission status of the e-manifest submission for that specific site {color:#4c9aff}(industry statuses of: Ready for Payment{color})
(x) Showing X to X of X Entries: read-only field displaying the number of entries shown, and the total number of entries
(x) Previous/Next: enabled buttons; allows users to toggle between different pages
(x) If the user has site manager permission, all Site Names should have a hyperlink that directs the user to the Billing tab (industry only)
(x) If user has preparer, certifier, or viewer permissions the Site Names will be read-only
Note: If there are no Outstanding Actions for a Module, display “No Outstanding Actions” within the table for the module.
{panel:bgColor=#deebff} Assume user has permission to any module for a site, therefore only checks the {{rcra_industry_site}} table.
Note the query is setup to allow someone to enter the user_id (e.g. johndoe) for convenience in SQL Developer - these can be altered to use synthetic key by removing {{site.user_id = (SELECT id FROM rcra_user_profile prof WHERE prof.user_id = upper(:userid))}} and replacing with
{{site.user_id = :userId}}
!Web capture_16-3-2023_145421_rcrainfodev.com.jpeg|width=999,height=1937!
Acceptance Criteria
This ticket is considered complete when the following changes have been made to the e-Manifest pill - found within the Outstanding Actions panel of the Overview tab:
(x) This panel will only include data from Invoice Due records that have outstanding actions that need to be completed by industry users {color:#4c9aff}(industry statuses of: Ready for Payment{color})
Invoice Due Panel: (x) Show X Entries: dropdown allowing users to select how many entries to display per page. Options include 5, 10, 20, and 50 with a default value of 10
Columns: (x) Site ID: read-only display of the site ID
(x) Site Name: displays the site name as a hyperlink that will launch the user to the e-Manifest tab for the specific site that was selected if they have the permissions to that module
(x) Updated: read-only display of the date the submission was last updated
(x) Action Item: read-only display of the submission status of the e-manifest submission for that specific site {color:#4c9aff}(industry statuses of: Ready for Payment{color})
(x) Showing X to X of X Entries: read-only field displaying the number of entries shown, and the total number of entries
(x) Previous/Next: enabled buttons; allows users to toggle between different pages
(x) If the user has site manager permission, all Site Names should have a hyperlink that directs the user to the Billing tab (industry only)
(x) If user has preparer, certifier, or viewer permissions the Site Names will be read-only