Feature #237
openGDS Unreported Report
Start date:
07/09/2023
Due date:
% Done:
90%
Estimated time:
Owner(Agency):
Travvise
Time Taken(HH):
Module:
GDS Unreported Tickets
Tested By:
unnikannan S
Code Reviewed By:
Subtasks
Related issues
Updated by Anil KV over 1 year ago
Solutions:-
1) General
-Popup the report from Ticket Stock List
*Need a View Details Icon in ticket Stock list - each records
2) GUI Changes
-Remove GDS
-List Group by add 'Action'
-List Columns - Date(Ticket Stock/Issue Date), Airline(Numeric Code), Ticket No, GDS, Current Status, Action(Reported/Unreported/Reported But GDS Changed), Branch
3) SQL
SELECT supd.vhr_supp_doc_no,
supd.sin_gds_company,
COALESCE(supd.dat_issue, supd.dat_cancel, NULL) AS dat_date,
(jsn_related_data->'AIR_NUM_CODE')::VARCHAR AS vhr_airline_num_code,
'Reported' AS vhr_action
FROM service.tbl_supp_doc_no AS supd
WHERE supd.vhr_supp_doc_no SIMILAR TO '[0-9]*'
AND supd.vhr_supp_doc_no::BIGINT BETWEEN 233444 AND 233695
AND supd.sin_supp_doc_category = 1
AND supd.sin_last_action != 0
- In .cs
* Input start and end based all tickets(Model) keep a list - Ticket No, Status()
* loop the sql and change the LIST item(ticket no base find and change)
Updated by unnikannan S about 1 year ago
ISSUE FOUNDED
1.CORRECT THE ALLIGMENT OF UP/DOWN SCROLL OPTION IN UI WHILE SEARCH
2.SHOW ITEMS ON GRID UNRPORTED,REPORTED,TOTAL (COUNT OF TICKET NO)
Updated by Arathy PS 7 months ago
- Status changed from Testing Started to Reopen Bugs
- % Done changed from 60 to 50
- Tested By set to Arathy PS
ISSUE FOUNDED
1)IN MANUAL TYPE TICKET STOCK SHOW THE CORRESPONDING AIRLINE
2)DISABLE THE SUPPLIER CODE FIELD ON GDS STOCK SEARCH POP UP UPON SEARCHING
3)THE NUMBER RANGE FIELD GETS DISABLED AFTER SEARCHING AND THEN CLICKING THE PRINT BUTTON, it becomes enabled
4)MAKE THE COLUMN CHOOSER NUMBER CORRECT
5)VALIDATE IF THE DATE FIELD IS EMPTY