TAAS

Solutions

1) Ticket Query
SELECT spd.pk_supp_doc_no_id,
    spd.vhr_supp_doc_no,
        spd.dat_cancel,
        spd.dat_refund,
    spd.fk_service_id,
    tkt.fk_branch_id,
    tkt.fk_department_id,
    tkt.fk_supplier_ac_id,
    tkt.fk_ticket_type_id,
    tkt.vhr_class_chr,
    tkt.sin_class,
    tkt.vhr_return_class_chr,
    tkt.sin_return_class,
    tkt.fk_sector_remarks_id,
    tkt.vhr_sector,
    tkt.sin_no_of_segments,
    tkt.fk_customer_ac_id,
    tkt.fk_actual_customer_ac_id,
    tkt.fk_sub_customer_id,
    tkt.fk_pax_profile_id,
    tkt.vhr_pax_name,
    tkt.sin_no_of_adult,
    tkt.sin_no_of_child,
    tkt.sin_no_of_infant,
    tkg.fk_airline_master_id,
    tkg.fk_refunding_counter_staff_id,
    spdf.vhr_currency,
    spdf.dbl_fare,
    spdf.dbl_tax,
    spdf.dbl_sup_fee,
    spdf.dbl_sup_rfd_charge,
    spdf.dbl_supplier_amount,
    spdf.dbl_customer_price,
    spdf.dbl_actual_profit
FROM  airticket.tbl_ticket tkt 
    INNER JOIN service.tbl_supp_doc_no spd
        ON tkt.fk_supp_doc_no_id = spd.pk_supp_doc_no_id AND tkt.sin_record_type = 2 AND tkt.int_sys_action_id != -1
    INNER JOIN airticket.tbl_ticket_gen_data tkg 
        ON tkg.fk_supp_doc_no_id = tkg.fk_supp_doc_no_id
    LEFT JOIN service.tbl_supp_doc_fare spdf 
        ON tkt.fk_ticket_sup_ledg_fare_id = spdf.pk_supp_doc_fare_id
-If Need(Not in filter) Join Service, Airline, Service, Account etc...

2) Hotel - SQL
3) Transfer
4) Visa
5) Hotel
6) Other
7) Summary
-Creat a dctSummary - key service, Values a model - Summary grid columns

TESTING DONE