Feature #252
openGDS Productivity Report
Added by Anil KV over 1 year ago. Updated about 6 hours ago.
50%
Files
clipboard-202503181523-axe66.png (57 KB) clipboard-202503181523-axe66.png | Arathy PS, 03/18/2025 03:23 PM |
Subtasks
Related issues
Updated by Anonymous over 1 year ago
- Assignee changed from travvise Admin to Karthika V Anand
Updated by Karthika V Anand over 1 year ago
- Status changed from New to Coding Started
- % Done changed from 0 to 40
Updated by Anil KV over 1 year ago
Solutions:-
1) GUI Changes -GDS Multi selection -Status Label change to Consider(Data Service) *Untick only Booking, Void(Direct) -Tick all GDS -Add Exclude MultiSelectBox - Re-Issue Ticket -Add Issuing Staff/Booking Staff Dropdown input -Currency Items Empty - Default, Base1(***), all currency code -Summary List Title part - Add Sub Grouping 2 Selectbox - * No Grouping-Default, Airline, Supplier, Issuing Staff, Booking Staff, Issuing Office ID, Ticketing Office ID, PNR First Owner Office ID, PNR Current Owner Office ID, Sector, Class, Ticket Type -Summary Code Column Rename - GDS -Details List Default(first) grouping - GDS wise -Details List Title part - Add Sub Grouping a Selectbox -> 2nd Grouping *No Grouping-Default, Airline, Supplier, Issuing Staff, Booking Staff, Issuing Office ID, Ticketing Office ID, Sector, Class, Ticket Type -Each summary section - Supplier Amount, No Of Tickets, No Of Pax, No Of Segment, Total Segment *Not Mandatory 2) SQL SELECT spd.vhr_supp_doc_no, CASE WHEN sin_record_type = 1 THEN spd.dat_issue ELSE spd.dat_cancel END AS dat_issue_or_cancel, spd.fk_service_id, tkt.sin_no_of_segments, tkt.sin_record_type, CASE WHEN sin_record_type = 1 THEN spd.sin_sys_sale_side_status ELSE spd.sin_sys_refund_side_status END AS sin_sys_status, COALESCE(tkt.vhr_pax_name, pxp.vhr_pax_name, '') AS vhr_pax_name, (tkt.sin_no_of_adult + tkt.sin_no_of_child + tkt.sin_no_of_infant) AS sin_no_pax, sfr.vhr_currency, sfr.dbl_supplier_amount 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 pax.tbl_pax_profile pxp ON tkt.fk_pax_profile_id = pxp.pk_pax_profile_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) ...)) ORDER BY dat_issue_or_cancel -- Travel date then use spd.dat_from >='%s' AND spd.dat_to -- tkt.sin_gds_company -- spd.fk_ba_branch_id -- Refund(sin_record_type==2) Recotd then all feres and counts(Pax count, Segment count) are -Ve in Details Section -- Total Segmant = sin_no_of_segments * sin_no_pax
Updated by Karthika V Anand over 1 year ago
- Status changed from Coding Started to Coding Done
- % Done changed from 40 to 60
Updated by Seema Mathew over 1 year ago
- Status changed from Coding Done to Reopen Bugs
- % Done changed from 60 to 50
- Tested By set to Seema Mathew
ISSUE FOUNDED****
1.TOTAL AMOUNT MUST BE BOLD IN PRINT
2.ERASER FILTER NOT WORKING
Updated by Karthika V Anand over 1 year ago
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 60
Updated by unnikannan S over 1 year ago
- Status changed from Reopen Bugs Coding Done to Reopen Bugs
- % Done changed from 60 to 50
- Tested By changed from Seema Mathew to unnikannan S
ISSUE FOUNDED
1.CORRECT ALLIGMENT PERIOD ISSUE
2.NOT SHOWING DATA AS PER TRAVEL DATE
3.ERROR WHILE ADDING BLANK OPTION IN TICKETING OFFICE ID
4.CORRECT ALLIGMENT TICKETING OFFICE
5.BUG WHILE CHOOSING BOOKING FROM CONSIDER
6.CORRECT NO OF SEGMENTS
7.SHOWINFG FALSE GDS NAME IN PRINT
8.ADD REFUNDING STAFF
Updated by Karthika V Anand over 1 year ago
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 60
Updated by unnikannan S over 1 year ago
- Status changed from Reopen Bugs Coding Done to Reopen Bugs
- % Done changed from 60 to 50
ISSUE FOUNDED
1.ID WISE FILTERING NOT WORKING
2.COUNT ISSUE IN TOTAL SEGMENT
3.ISSUING STAFF WISE FILTERING NOT WORKING DATE
4.TRAVEL DATE WISE SEARCH NOT WORKING
Updated by Junaid M over 1 year ago
- Assignee changed from Karthika V Anand to Vivekp V
Updated by Vivekp V over 1 year ago
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 60
ISSUE FIXED
1.ID WISE FILTERING NOT WORKING
2.COUNT ISSUE IN TOTAL SEGMENT
3.ISSUING STAFF WISE FILTERING NOT WORKING DATE
4.TRAVEL DATE WISE SEARCH NOT WORKING
Updated by unnikannan S about 1 year ago
ISSUE FOUNDED
1.ADD VALIDATION FOR DATE
2.SHOW BASE1 CURRENCY DEFAULT ON CURRENCY FIELD (FIXED)
3.SHOWING STATUS OF VOID VOUCHERS AS BOOKING
4.NO DATA WHILE SEARCH WITH TRAVEL DATE (FIXED)
5.CORRECT THE SPELL OF ISSUING OFFICE ID IN GRID (FIXED)
Updated by unnikannan S about 1 year ago
- Status changed from Reopen Bugs Coding Done to Reopen Bugs
- % Done changed from 60 to 50
ISSUE FOUNDED
1.CORRECT THE WORK FLOW OF CONSIDER OPTION WISE SEARCHING
2.SHOWING WRONG STATUS OF VOUCHERS THOSE CANCELED/VOID
Updated by Vivekp V about 1 year ago
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 60
ISSUE FIXED
1.CORRECT THE WORK FLOW OF CONSIDER OPTION WISE SEARCHING
2.SHOWING WRONG STATUS OF VOUCHERS THOSE CANCELED/VOID
Updated by unnikannan S about 1 year ago
- Status changed from Reopen Bugs Coding Done to Reopen Bugs
- % Done changed from 60 to 50
ISSUE FOUNDED
1.ADD VALIDATION FOR PERIOD
2.SHOW DATA AS PER SELECTDED FILTER FIELDS IN UI
3.CONSIDER NEW FILTER FIELD USED IN ISSUE/SALE. OFFICE/BOOKING ID FOR FILTERING PURPOSES
4.CLEAR DELETED ACCOUNTS SHOWING IN FILTERING FIELDS
5.CLEAR DATAS FROM LIST THAT NOT RELATED WITH ANY GDS
Updated by Vivekp V about 1 year ago
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 60
ISSUE FIXED
1.ADD VALIDATION FOR PERIOD
2.SHOW DATA AS PER SELECTDED FILTER FIELDS IN UI
3.CONSIDER NEW FILTER FIELD USED IN ISSUE/SALE. OFFICE/BOOKING ID FOR FILTERING PURPOSES
4.CLEAR DELETED ACCOUNTS SHOWING IN FILTERING FIELDS
5.CLEAR DATAS FROM LIST THAT NOT RELATED WITH ANY GDS
Updated by unnikannan S about 1 year ago
- Status changed from Reopen Bugs Coding Done to Reopen Bugs
- % Done changed from 60 to 50
ISSUE FOUNDED
1.MISSING PAX PROFILE NAME FROM LIST
2.FALSE SEGMENT COUNT IN LSIT WHILE ADDING PAX COUNT
Updated by Vivekp V about 1 year ago
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 60
ISSUE FIXED
1.MISSING PAX PROFILE NAME FROM LIST
2.FALSE SEGMENT COUNT IN LSIT WHILE ADDING PAX COUNT
Updated by unnikannan S about 1 year ago
- Status changed from Reopen Bugs Coding Done to Reopen Bugs
- % Done changed from 70 to 50
ISSUE FOUNDED
1.CONSIDER NORMAL PROFIT
2.CONSIDER ALL DATA WHILE CLEARING ALL OPTIONS FROM CONSIDER MULTY SELECT
3.COUNT VALUES SHOWING AS MINUS ON NET COLUMN
Updated by Vivekp V about 1 year ago
ISSUE FIXED
1.CONSIDER NORMAL PROFIT
2.CONSIDER ALL DATA WHILE CLEARING ALL OPTIONS FROM CONSIDER MULTY SELECT
3.COUNT VALUES SHOWING AS MINUS ON NET COLUMN minus is needed
Updated by Vivekp V about 1 year ago
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 70
Updated by Nawal Sidique 7 days ago
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 70
Updated by Arathy PS about 6 hours ago
- File clipboard-202503181523-axe66.png clipboard-202503181523-axe66.png added
- Status changed from Reopen Bugs Coding Done to Reopen Bugs
- % Done changed from 70 to 50
ISSUE FOUND
--------------------------
1. Not showing GDS grouping in the print of details tab
2. Add redirection to the ticket no: