TAAS

Solutions

1) GUI Changes
-Add Consider like GDS productivity
-Add Exclude like GDS productivity
- Add GDS like GDS productivity
-Add Issuing Staff/Booking Staff like GDS productivity
-Add Ticketing Office ID like GDS productivity
-List Title part - Add Sub Grouping a Selectbox
*No Grouping-Default, Sector, Class
--Airline Column Value = vhr_numeric_code :: vhr_airline_name(vhr_chr_code)
2) SQL
SELECT COUNT(spd.vhr_supp_doc_no) int_count,
    tkt.sin_record_type,
    tkt.sin_class,
    tkt.vhr_sector,
    SUM(sfr.dbl_supplier_amount) AS dbl_supplier_amount,
    MAX(air.vhr_airline_name) AS vhr_airline_name,
    MAX(air.vhr_display_name) AS vhr_display_name,
    MAX(air.vhr_chr_code) AS vhr_chr_code,
    MAX(air.vhr_numeric_code) AS vhr_numeric_code
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 airticket.tbl_airline_master AS air
        ON tktg.fk_airline_master_id = air.pk_airline_master_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)
               ...))
GROUP BY tktg.fk_airline_master_id, tkt.sin_record_type, tkt.sin_class, tkt.vhr_sector
ORDER BY vhr_airline_name

ISSUE FOUNDED****

1.CHANGE TOTAL AMOUNT ALIGNMENT IN PRINT LEFT TO RIGHT
2.ERASER FILTER NOT WORKING

TESTING DONE

TESTING DONE

unnikannan S wrote in #note-13:

ISSUE FOUNDED

1.ISSUING STAFF WISE SEARCH NOT WORKING
2.SHOWING ERROR {} SEARCH WITH PAST DATE

TESTING DONE

TESTING DONE

TESTING DONE

TESTING DONE