TAAS

Note **
Ancillary Column Dynamic Service or Ancillary Service based on Grouping Selection

Solutions

1) GUI Change
-Status label change to Consider, Default Tick all
-Add Currency - Default Base1(***), 
-Summary:-
*Group By Default Ancillary Service
*Columns-> Ancillary Service/Service(Based on Broup by), Sale->Count, Cost, Price, Profit(Sub Columns), Refund(Count, Cost, Price, Profit(Sub Columns), Net(Count, Cost, Price, Profit(Sub Columns)
-Details
-Add No Grouping(default) item in Group By 
-Ticket/Voucher, Issue/Cancel Date, Doc No, Doc Date, Service, Ancillary Service, Cost, Price, Profit
2) SQL
SELECT 'Issue/Sale' AS str_type,
    supd.vhr_supp_doc_no,
    supd.sin_supp_doc_category,
    supd.fk_service_id,
    supd.sin_sys_sale_side_status,
    supd.sin_sys_refund_side_status,
    sups.sin_record_type,
    sups.fk_ancillary_service_id,
    COALESCE(supf.dbl_supplier_amount, 0.00) AS dbl_supplier_amount,
    COALESCE(supf.dbl_customer_price, 0.00) AS dbl_customer_price,
    COALESCE(supf.dbl_actual_profit, 0.00) AS dbl_actual_profit
    --...
FROM service.tbl_supp_doc_no supd
    LEFT JOIN service.tbl_supp_doc_ap_sup_sharing sups
        ON supd.pk_supp_doc_no_id = sups.fk_supp_doc_no_id
    LEFT JOIN service.tbl_supp_doc_fare supf
        ON sups.fk_supp_doc_sup_ledg_fare_id = supf.pk_supp_doc_fare_id -- sups.fk_supp_doc_sup_base_fare_id Based on input currency
    LEFT JOIN service.tbl_service srv
        ON supd.fk_service_id = srv.pk_service_id
    LEFT JOIN service.tbl_ancillary_service ancs
        ON sups.fk_ancillary_service_id = ancs.pk_ancillary_service_id
WHERE supd.sin_last_action != 0 
    AND supd.sin_sys_sale_side_status > 0
    AND sups.fk_ancillary_service_id IS NOT NULL
    --...
UNION ALL

SELECT 'Cancel/Refund' AS str_type,
    supd.vhr_supp_doc_no,
    supd.sin_supp_doc_category,
    supd.fk_service_id,
    supd.sin_sys_sale_side_status,
    supd.sin_sys_refund_side_status,
    sups.sin_record_type,
    sups.fk_ancillary_service_id,
    COALESCE(supf.dbl_supplier_amount, 0.00) AS dbl_supplier_amount,
    COALESCE(supf.dbl_customer_price, 0.00) AS dbl_customer_price,
    COALESCE(supf.dbl_actual_profit, 0.00) AS dbl_actual_profit
    --...
FROM service.tbl_supp_doc_no supd
    LEFT JOIN service.tbl_supp_doc_ap_sup_sharing sups
        ON supd.pk_supp_doc_no_id = sups.fk_supp_doc_no_id
    LEFT JOIN service.tbl_supp_doc_fare supf
        ON sups.fk_supp_doc_sup_ledg_fare_id = supf.pk_supp_doc_fare_id -- sups.fk_supp_doc_sup_base_fare_id Based on input currency
    LEFT JOIN service.tbl_service srv
        ON supd.fk_service_id = srv.pk_service_id
    LEFT JOIN service.tbl_ancillary_service ancs
        ON sups.fk_ancillary_service_id = ancs.pk_ancillary_service_id
WHERE supd.sin_last_action != 0 
    AND supd.sin_sys_refund_side_status > 0
    AND sups.fk_ancillary_service_id IS NOT NULL
    --...
* Refund Fare showing -ve

grid width issue in multiple tab ui (refer: #277 (5))