Project

General

Profile

Edit Copy Actions

Feature #246

open

PLB Report

Added by Anil KV over 1 year ago. Updated 8 days ago.

Status:
Reopen Bugs Coding Done
Priority:
Normal
Assignee:
Target version:
Start date:
09/26/2023
Due date:
% Done:

70%

Estimated time:
Owner(Agency):
Travvise
Time Taken(HH):
Module:
PLB Report
Tested By:
unnikannan S
Code Reviewed By:

Description

Coding PLB Report


Files

clipboard-202502201215-j8kwn.png (80.3 KB) clipboard-202502201215-j8kwn.png Theja Ponon, 02/20/2025 12:15 PM

Add

Subtasks


Add

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

Actions #2

Updated by Anil KV over 1 year ago

  • Status changed from New to Open
  • % Done changed from 0 to 10
Actions #3

Updated by Junaid M over 1 year ago

  • Assignee changed from travvise Admin to Vivekp V
Actions #4

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
Actions #5

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)

Actions #8

Updated by unnikannan S 6 months ago

  • Status changed from Reopen Bugs Coding Done to Testing Done
  • % Done changed from 70 to 90

Updated by Theja Ponon 26 days ago

ISSUE FOUND
---------
1)airline get filled on the field on reloading the page and clicking on anywhere

Actions #10

Updated by Theja Ponon 26 days ago

  • Assignee changed from Vivekp V to Athira KK
Actions #11

Updated by Athira KK 26 days ago

  • Status changed from Reopen Bugs to Reopen Bugs Coding Done
  • % Done changed from 50 to 70

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.

Actions #13

Updated by Athira KK 8 days ago

  • Status changed from Reopen Bugs to Reopen Bugs Coding Done
  • % Done changed from 50 to 70
Edit Copy Actions

Also available in: Atom PDF