TAAS

Solutions:-

1) GUI Changes
-GDS Multi selection
-Status Label change to Consider(Data Service)
*Untick only Booking, Void(Direct)
-Tick all GDS
-Add Exclude MultiSelectBox - Re-Issue Ticket
-Add Issuing Staff/Booking Staff Dropdown input
-Currency Items Empty - Default, Base1(***), all currency code
-Summary List Title part - Add Sub Grouping 2 Selectbox - 
* No Grouping-Default, Airline, Supplier, Issuing Staff, Booking Staff, Issuing Office ID, Ticketing Office ID, PNR First Owner Office ID, PNR Current Owner Office ID, Sector, Class, Ticket Type
-Summary Code Column Rename - GDS
-Details List Default(first) grouping - GDS wise
-Details List Title part - Add Sub Grouping a Selectbox -> 2nd Grouping
*No Grouping-Default, Airline, Supplier, Issuing Staff, Booking Staff, Issuing Office ID, Ticketing Office ID, Sector, Class, Ticket Type
-Each summary section - Supplier Amount, No Of Tickets, No Of Pax, No Of Segment, Total Segment
*Not Mandatory
2) SQL
SELECT spd.vhr_supp_doc_no,
    CASE WHEN sin_record_type = 1 THEN spd.dat_issue ELSE spd.dat_cancel END AS dat_issue_or_cancel,
    spd.fk_service_id,
    tkt.sin_no_of_segments,
    tkt.sin_record_type,
    CASE WHEN sin_record_type = 1 THEN spd.sin_sys_sale_side_status ELSE spd.sin_sys_refund_side_status END AS sin_sys_status,
    COALESCE(tkt.vhr_pax_name, pxp.vhr_pax_name, '') AS vhr_pax_name,
    (tkt.sin_no_of_adult + tkt.sin_no_of_child + tkt.sin_no_of_infant) AS sin_no_pax,
    sfr.vhr_currency,
    sfr.dbl_supplier_amount
FROM airticket.tbl_ticket tkt
    LEFT JOIN service.tbl_supp_doc_no spd
        ON tkt.fk_supp_doc_no_id = spd.pk_supp_doc_no_id
    LEFT JOIN airticket.tbl_ticket_gen_data tktg
        ON tktg.fk_supp_doc_no_id = spd.pk_supp_doc_no_id
    LEFT JOIN service.tbl_supp_doc_fare sfr
        ON tkt.fk_ticket_cus_ledg_fare_id = sfr.pk_supp_doc_fare_id -- Currecy inputbase Choose the field
    LEFT JOIN pax.tbl_pax_profile pxp
        ON tkt.fk_pax_profile_id = pxp.pk_pax_profile_id
WHERE tkt.int_sys_action_id != -1
    AND ((sin_record_type = 1 AND  spd.dat_issue BETWEEN '2023-07-01' AND '2023-07-31' --Sales side
            AND  spd.sin_sys_sale_side_status = 1
              ...) 
       OR (sin_record_type = 2 AND spd.dat_cancel BETWEEN '2023-07-01' AND '2023-07-31' --Refund side where
            AND spd.sin_sys_refund_side_status IN (1,2)
               ...))
ORDER BY dat_issue_or_cancel
-- Travel date then use spd.dat_from >='%s' AND spd.dat_to
-- tkt.sin_gds_company
-- spd.fk_ba_branch_id
-- Refund(sin_record_type==2) Recotd then all feres and counts(Pax count, Segment count) are -Ve in Details Section
-- Total Segmant = sin_no_of_segments * sin_no_pax

TESTING DONE

ISSUE FOUNDED

1.ADD VALIDATION FOR DATE
2.SHOW BASE1 CURRENCY DEFAULT ON CURRENCY FIELD (FIXED)
3.SHOWING STATUS OF VOID VOUCHERS AS BOOKING
4.NO DATA WHILE SEARCH WITH TRAVEL DATE (FIXED)
5.CORRECT THE SPELL OF ISSUING OFFICE ID IN GRID (FIXED)

TESTING DONE

TESTING DONE

TESTING DONE

ISSUE FIXED

1.CONSIDER NORMAL PROFIT
2.CONSIDER ALL DATA WHILE CLEARING ALL OPTIONS FROM CONSIDER MULTY SELECT
3.COUNT VALUES SHOWING AS MINUS ON NET COLUMN minus is needed

TESTING DONE