TAAS

SELECT   vhr_sector,
                                                pk_ticket_fare_id,
                                                vhr_airline_code,
                                                vhr_airline_name,
                                                vhr_display_name,
                                                pk_airline_master_id,
                                                other,first,second,third,fourth

                                        FROM crosstab( $$ SELECT   ARRAY[vhr_sector,vhr_airline_code] as sector_airline,
                                                                   MIN(pk_supp_doc_fare_id) AS pk_supp_doc_fare_id,
                                                                   vhr_sector,
                                                                   vhr_airline_code,    
                                                                   vhr_airline_name,
                                                                   vhr_display_name,
                                                                   pk_airline_master_id,
                                                                   sin_class,
                                                                   SUM(dbl_supplier_amount)
                                                FROM (    
---------------------------------------------------------------------
SELECT
MIN(tf.pk_supp_doc_fare_id) AS pk_supp_doc_fare_id,
vhr_sector,
vhr_airline_code,    
airln.vhr_airline_name,
airln.vhr_display_name,
airln.pk_airline_master_id,
sin_class,
SUM(tf.dbl_supplier_amount) AS dbl_supplier_amount
FROM airticket.tbl_ticket AS tkt
LEFT JOIN service.tbl_supp_doc_fare AS tf
    ON tkt.fk_ticket_base_fare_id = tf.pk_supp_doc_fare_id
LEFT JOIN service.tbl_supp_doc_no AS supp
    ON supp.pk_supp_doc_no_id = tkt.fk_supp_doc_no_id
LEFT JOIN airticket.tbl_ticket_gen_data AS tkgen
    ON supp.pk_supp_doc_no_id = tkgen.fk_supp_doc_no_id
LEFT JOIN airticket.tbl_airline_master AS airln
    ON tkgen.fk_airline_master_id = airln.pk_airline_master_id
WHERE 
supp.sin_last_action != 0 AND tkt.sin_record_type = 1
--AND supp.dat_issue BETWEEN '%s' AND '%s'                                                    
--AND supp.fk_ba_branch_id = ANY('{}')
-->strCurrency = BASE1 -> tkt.fk_ticket_base_fare_id/ tkt.fk_ticket_sup_fare_id    
--AND supp.sin_sys_sale_side_status = ANY('{STATUS}')                                                
GROUP BY tkt.sin_class, airln.vhr_airline_name, airln.vhr_airline_code, airln.vhr_display_name, airln.pk_airline_master_id, tkt.vhr_sector
---------------------

--UNION ALL 
-- REFUND QUERY
-------------------------------------------------                                                    
) AS data
GROUP BY vhr_sector,vhr_airline_code,vhr_airline_name,vhr_display_name,pk_airline_master_id,sin_class    
ORDER  BY 1 $$ ,$$ SELECT sin_class FROM generate_series(0,4) AS sin_class $$) 
AS ct (arrYearLedger text[], pk_ticket_fare_id INT, vhr_sector text, vhr_airline_code text, vhr_airline_name text, vhr_display_name text, pk_airline_master_id bigint, other text, first text, second text, third text, fourth text);

ISSUE FOUNDED

1.ERROR SHOWING WHILE NOT SEARCH WIYHOUT BRANCH FILTER

TESTING DONE

unnikannan S wrote in #note-11:

ISSUE FOUNDED

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

unnikannan S wrote in #note-12:

unnikannan S wrote in #note-11:

ISSUE FOUNDED

1.ISSUING STAFF WISE FILTERING NOT WORKING

TESTING DONE

TESTING DONE