TAAS

• Solutions:- *
  

  1) GUI Changes
  -Invoice Date to Issue Date
  -Add Booking Staff/... filter like not reported sales
  -Add Pax Profile/Pax Name~ filter like not reported sales
  -Add Service Column after Issue Date
  -Add Provider Column before Sector - DEFAULT HIDE [Ticket=Airline, Hotel=Hotel NAme, ]
  -Sector Column DEFAULT HIDE [Only ticket, other items empty]
  2) SQL
       SELECT spd.pk_supp_doc_no_id,
          spd.sin_supp_doc_category,
          spd.vhr_supp_doc_no,
          spd.sin_sys_current_status,
          spd.dat_issue,
          spd.dat_sale,
          spd.vhr_invoice_doc_no,
          spd.fk_service_id,
          COALESCE(spd.vhr_pax_name, pxp.vhr_pax_name, '') AS vhr_pax_name,
          spd.sin_no_of_pax,
          tkt.vhr_sector,
          tkt.txt_remarks,
          sfr.vhr_currency,
          sfr.dbl_fare,
          sfr.dbl_tax,
          sfr.dbl_actual_cost,
          sfr.dbl_supplier_amount,
          sfr.dbl_customer_price,
          sfr.dbl_actual_profit
      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 tkg 
              ON spd.pk_supp_doc_no_id = tkg.fk_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
          LEFT JOIN pax.tbl_pax_profile pxp
              ON spd.fk_pax_profile_id = pxp.pk_pax_profile_id
          LEFT JOIN accounts.tbl_account ac 
              ON spd.fk_customer_ac_id = ac.pk_account_id
          LEFT JOIN service.tbl_service srv
              ON spd.fk_service_id = srv.pk_service_id
          LEFT JOIN airticket.tbl_airline_master air 
              ON air.pk_airline_master_id = tkg.fk_airline_master_id  
      WHERE tkt.int_sys_action_id != -1
          AND spd.sin_lpo_required = 1
          AND spd.vhr_lpo_number = ''
          AND spd.sin_sys_current_status IN (1,2)
          AND spd.dat_issue BETWEEN '2023-08-08' AND '2023-08-08'
          AND (spd.vhr_pax_name ILIKE '*' OR pxp.vhr_pax_name ILIKE '*')
                  ...
          UNION ALL
          [Hotel]
          UNION ALL
          [TRANSFER]
          UNION ALL
          [VISA]
          UNION ALL
          [OTHER]
  

ISSUE FOUNDED

1.ERROR WHILE ADDING ISSUING STAFF
2.ERROR WHILE CHOOSING NOT REQUIRED TAB
3.NO DATA FOR DIRECT CANCEL
4.LPO SAVING WITHOUT MANDATORY FIELD DATE
5.CHANGE PAX NAME INTO PAX~
6.ADD DATA OF ENQUIRY NO WHILE FILTERING IN PRINT

1.ERROR WHILE ADDING ISSUING STAFF - Error Fixed
2.ERROR WHILE CHOOSING NOT REQUIRED TAB - Error Fixed
3.LPO SAVING WITHOUT MANDATORY FIELD DATE - Added
4.CHANGE PAX NAME INTO PAX~ - Renamed
5.ADD DATA OF ENQUIRY NO WHILE FILTERING IN PRINT - Added in Print

TESTING DONE

ISSUE FOUNDED

1.DUPLICATION OF VOUCHERS WHILE CHOOSING CONSIDER OPTIONS
2.CHANGE NAME STATUS TO CONSIDER

ISSUE FOUNDED

Fxed 1.MISSING DATAS FROM UI

ISSUE FOUNDED

1.SHOW DATA ON EXCLUDE MULTY SELECTION IN UI

ISSUE FOUNDED

1.ERROR WHILE SEARCH WITH DOC REVERSAL ON EXCLUDE MULTY SELECTION (42601: syntax error at or near ")"

ISSUE FOUNDED

1.ADD VALIDATION FOR SET,NOT REQUIRED BUTTONS IN CASE OF NOT SELECTED ANY ITEMS

ISSUE FOUNDED

1.Show Data From Ticket Cancel

ISSUE FOUNDED

1.Missing Data From Direct Ticket Cancel

ISSUE FOUND
-------------------------------------------
1. Not redirecting to sale document on clicking document no:
2. Data on the grid disappears after setting LPO no: for any selected item.
3. Not showing package issue, cancel or sold items.
4. Showing invoice date without having invoice for the vouchers.
5. Transfer vouchers are not showing.

ISSUE FOUND
-------------------------------------------
1. Not redirecting to sale document and voucher no: on clicking them.
2. Change consider to status.
3. Duplicate is showing when selecting status as refund.
4. Package issue is also showing when selecting status as refund.

ISSUE FOUND
---------------------------------------------
1. Cost field is empty for ticket/vouchers from booking module.

ISSUE FOUND
------------
1)Xo data generate on giving the customer after updating the xo document by removing the customer name
2)On edit button click data is not load in xo document
3Redirection is not working on xo ticket/voucher number click
4)Issue date and lpo date filteration is not working

ISSUE FOUND
-------------
1)Issue date and lpo date ,INVOICE DATE filteration is not working