Feature #246
openPLB Report
Added by Anil KV over 1 year ago. Updated 8 days ago.
70%
Files
clipboard-202502201215-j8kwn.png (80.3 KB) clipboard-202502201215-j8kwn.png | Theja Ponon, 02/20/2025 12:15 PM |
Subtasks
Related issues
Updated by Anil KV over 1 year ago
Solutions
1) GUI Changes -Period need MM/YYYY only -Add Currency - Base1(***) default, Not need BASE2 -Summary List to PLB Report -List Column - Issue Date change to Fortnight 2) SQL SELECT dat_period_start, dat_period_end, SUM(dbl_fare_sale) AS dbl_fare_sale, SUM(dbl_tax_sale) AS dbl_tax_sale, SUM(dbl_fare_refund) AS dbl_fare_refund, SUM(dbl_tax_refund) AS dbl_tax_refund FROM ( SELECT sudn.dat_issue AS dat_issue_or_cancel, CASE WHEN TO_CHAR(sudn.dat_issue, 'DD')::INT <= 15 THEN DATE_TRUNC('month', sudn.dat_issue)::date ELSE (DATE_TRUNC('month', sudn.dat_issue) + interval '15 day')::date END AS dat_period_start, CASE WHEN TO_CHAR(sudn.dat_issue, 'DD')::INT <= 15 THEN (DATE_TRUNC('month', sudn.dat_issue) + interval '14 day')::date ELSE (DATE_TRUNC('month', sudn.dat_issue) + interval '1 month - 1 day')::date END AS dat_period_end, sudf.dbl_fare AS dbl_fare_sale, sudf.dbl_tax AS dbl_tax_sale, 0.00 AS dbl_fare_refund, 0.00 AS dbl_tax_refund FROM service.tbl_supp_doc_no sudn LEFT JOIN service.tbl_supp_doc_fare sudf ON sudn.fk_issue_base_fare_id = sudf.pk_supp_doc_fare_id --*1 WHERE sudn.sin_last_action != 0 AND sudn.sin_sys_sale_side_status > 0 UNION ALL SELECT sudn.dat_cancel AS dat_issue_or_cancel, CASE WHEN TO_CHAR(sudn.dat_issue, 'DD')::INT <= 15 THEN DATE_TRUNC('month', sudn.dat_cancel)::date ELSE (DATE_TRUNC('month', sudn.dat_cancel) + interval '15 day')::date END AS dat_period_start, CASE WHEN TO_CHAR(sudn.dat_issue, 'DD')::INT <= 15 THEN (DATE_TRUNC('month', sudn.dat_cancel) + interval '14 day')::date ELSE (DATE_TRUNC('month', sudn.dat_cancel) + interval '1 month - 1 day')::date END AS dat_period_end, 0.00 AS dbl_fare_sale, 0.00 AS dbl_tax_sale, sudf.dbl_fare AS dbl_fare_refund, sudf.dbl_tax AS dbl_tax_refund FROM service.tbl_supp_doc_no sudn LEFT JOIN service.tbl_supp_doc_fare sudf ON sudn.fk_cancel_base_fare_id = sudf.pk_supp_doc_fare_id --*2 WHERE sudn.sin_last_action != 0 AND sin_sys_refund_side_status > 0) AS tmp GROUP BY dat_period_start, dat_period_end *Fortnight Column value is dat_period_start - dat_period_end -> Format date
Updated by Anil KV over 1 year ago
- Status changed from New to Open
- % Done changed from 0 to 10
Updated by Junaid M over 1 year ago
- Assignee changed from travvise Admin to Vivekp V
Updated by Vivekp V over 1 year ago
- Status changed from Open to Coding Started
- Start date changed from 07/09/2023 to 09/26/2023
- % Done changed from 10 to 40
Updated by Vivekp V over 1 year ago
- Status changed from Coding Started to Coding Done
- % Done changed from 40 to 60
Updated by unnikannan S 12 months ago
- Status changed from Coding Done to Reopen Bugs
- % Done changed from 60 to 50
- Tested By set to unnikannan S
ISSUE FOUNDED
1.ADJUST GAP BETWEEN FIELDS IN UI
2.MISSING PRECISION FROM LIST
3.SHOW DATA AS PER GIVEN CONSIDER OPTIONS IN UI
4.SHOW DATA WHILE CHOOISNG INDIVIDUAL CURRENCY (SUPPLIER CURRENCY)
Updated by Vivekp V 12 months ago
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 70
ISSUE FIXED
1.ADJUST GAP BETWEEN FIELDS IN UI
2.MISSING PRECISION FROM LIST
3.SHOW DATA AS PER GIVEN CONSIDER OPTIONS IN UI
4.SHOW DATA WHILE CHOOISNG INDIVIDUAL CURRENCY (SUPPLIER CURRENCY)
Updated by Theja Ponon 26 days ago
- File clipboard-202502201215-j8kwn.png clipboard-202502201215-j8kwn.png added
- Status changed from Testing Done to Reopen Bugs
- % Done changed from 90 to 50
ISSUE FOUND
---------
1)airline get filled on the field on reloading the page and clicking on anywhere
Updated by Arathy PS 12 days ago
- Status changed from Reopen Bugs Coding Done to Reopen Bugs
- % Done changed from 70 to 50
ISSUE FOUND
-----------------------
1. Amount not showing based on AR sharing done in sale, while searching using two customers.
2. One time after 'no data found' message data is not showing with reload or reset button.