Create 'Cash drawer reconciliation report' in PDF format

Purpose:  Generate Cash drawer reconciliation report in PDF format based on criteria entered by user, and then make the report available for download.  This report is used by staff members who have been assigned a register to cash out their register drawer at the end of their shift.

SCENARIOS

Scenario 1

• Given report criteria saved on Cash drawer reconciliation report modal (see UIU-1960)
• When Report format = PDF or BOTH and one or more payment fee/fine actions not found for criteria
• Then display the red "no success toast" with error message:  No items found

Scenario 2

• Given report criteria saved on Cash drawer reconciliation report modal (see UIU-1060)
• When Report format = PDF or BOTH and one or more payment fee/fine actions found for criteria
• Then...
  • Generate the Cash drawer reconciliation report per the instructions below (as shown in attached sample Cash-Drawer-Reconciliation-Report-format.xlsx
  • Make report available for download (as shown in attached screen mock-up 4-cash-drawer-downloaded.png) in the Report format of PDF

INSTRUCTIONS FOR GENERATING REPORT

Produce the title of the report -

• Cash Drawer Reconciliation Report for <Service Point>, Source(s) <Source 1, Source 2, Source X> - <Start-date> to <End-date>
  • Insert Service Point from Cash drawer reconciliation report modal (will only have one)
  • Insert Source(s) from Cash drawer reconciliation report modal (will have zero to many)
  • Insert Start date from Cash drawer reconciliation report modal (will have one)
  • Insert End date from Cash drawer reconciliation report modal (if not provided from modal, use system date)
  • Examples:
    • Cash Drawer Reconciliation Report for Main Circ Desk - 3/8/2021 to 3/10/2021
    • Cash Drawer Reconciliation Report for Main Circ Desk, Source(s) Holly Mistlebauer - 3/8/2021 to 3/10/2021
    • Cash Drawer Reconciliation Report for Main Circ Desk, Source(s) Holly Mistlebauer, Minnie Mouse, Jane Doe - 3/8/2021 to 3/10/2021

Produce the columns of the report -

• Source:  Source from Fee/Fine Action record (aka Fee/Fine Details table of "actions")
• Payment method:  Payment method (displayed as part of Action) from Fee/Fine Action record (aka Fee/Fine Details table of "actions")
• Payment amount:  Amount from Fee/Fine Action record (aka Fee/Fine Details table of "actions")
• Fee/fine owner:  Fee/fine owner from Fee/Fine record (aka Fee/Fine Details upper part)
• Fee/fine type:  Fee/fine type from Fee/Fine record (aka Fee/Fine Details upper part)
• Payment date/time:  Action date from Fee/Fine Action record (aka Fee/Fine Details table of "actions")
• Payment status:  Action from Fee/Fine Action record (aka Fee/Fine Details table of "actions")
• Transaction information:  Transaction information from Fee/Fine Action record (aka Fee/Fine Details table of "actions")
• Payment additional staff information:  Additional staff information from Fee/Fine Action record (aka Fee/Fine Details table of "actions")
• Payment additional patron information:  Additional patron information from Fee/Fine Action record (aka Fee/Fine Details table of "actions")
• Fee/fine details:  FOLIO internal id for Fee/Fine Details page as a link to that page

Sort the report by -

• Source, within Fee/fine owner

Produce the report totals -

• Source:  Provide a total of Payment amount and a count by Source, with a grand total for all Sources (as shown at bottom of attached report mock-up Cash-Drawer-Reconciliation-Report-format.xlsx)
• Payment method:  Provide a total of Payment amount and a count by Payment method, with a grand total for all Payment methods (as shown at bottom of attached report mock-up Cash-Drawer-Reconciliation-Report-format.xlsx)
• Fee/fine type:  Provide a total of Payment amount and a count by Fee/fine type, with a grand total for all Fee/fine types (as shown at bottom of attached report mock-up Cash-Drawer-Reconciliation-Report-format.xlsx)
• Fee/fine owner:  Provide a total of Payment amount and a count by Fee/fine owner, with a grand total for all Fee/fine owners (as shown at bottom of attached report mock-up Cash-Drawer-Reconciliation-Report-format.xlsx)