Project

General

Profile

Edit Copy Actions
Copy link

Feature #237

open

GDS Unreported Report

Added by Anil KV over 1 year ago. Updated 4 months ago.

Status:
Reopen Bugs Testing Done
Priority:
Normal
Assignee:
Sreeranjini T
Target version:
22.12
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:
Quote

Description

Coding GDS Unreported Tickets

Add

Subtasks

Add

Related issues

QuoteActions
Copy link
 #1

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)

Actions
Copy link
 #2

Updated by Anil KV over 1 year ago

  • Status changed from New to Open
  • % Done changed from 0 to 10
Actions
Copy link
 #3

Updated by Anil KV over 1 year ago

  • Assignee changed from travvise Admin to Shahil Haris
Actions
Copy link
 #4

Updated by Anil KV about 1 year ago

  • Assignee changed from Shahil Haris to travvise Admin
QuoteActions
Copy link
 #5

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)

Actions
Copy link
 #6

Updated by Anil KV about 1 year ago

  • Assignee changed from travvise Admin to Vivekp V
Actions
Copy link
 #7

Updated by Anil KV about 1 year ago

  • Status changed from Open to Ready for Coding
  • % Done changed from 10 to 20
Actions
Copy link
 #8

Updated by Junaid M 8 months ago

  • Assignee changed from Vivekp V to Meljo Sunny
Actions
Copy link
 #9

Updated by Meljo Sunny 8 months ago

  • Status changed from Ready for Coding to Coding Started
  • % Done changed from 20 to 30
Actions
Copy link
 #10

Updated by Junaid M 8 months ago

  • Subject changed from GDS Unreported Tickets to GDS Unreported Report
Actions
Copy link
 #11

Updated by Meljo Sunny 8 months ago

  • Status changed from Coding Started to Coding Done
  • % Done changed from 30 to 60
Actions
Copy link
 #12

Updated by Arathy PS 7 months ago

  • Status changed from Coding Done to Testing Started
QuoteActions
Copy link
 #13

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

Actions
Copy link
 #14

Updated by Meljo Sunny 7 months ago

  • Status changed from Reopen Bugs to Reopen Bugs Coding Done
  • % Done changed from 50 to 70
QuoteActions
Copy link
 #15

Updated by unnikannan S 7 months ago

  • Status changed from Reopen Bugs Coding Done to Reopen Bugs
  • % Done changed from 70 to 50
  • Tested By changed from Arathy PS to unnikannan S

ISSUE FOUNDED

1.Fix The Error While Adding Letters Directly And Search

Actions
Copy link
 #16

Updated by Meljo Sunny 7 months ago

  • Status changed from Reopen Bugs to Reopen Bugs Coding Done
  • % Done changed from 50 to 70
Actions
Copy link
 #17

Updated by Arathy PS 6 months ago

  • File clipboard-202409061250-nmsjq.png added
  • Status changed from Reopen Bugs Coding Done to Reopen Bugs
  • % Done changed from 70 to 50
Actions
Copy link
 #18

Updated by Arathy PS 6 months ago

  • File deleted (clipboard-202409061250-nmsjq.png)
QuoteActions
Copy link
 #19

Updated by Arathy PS 6 months ago

ISSUE FOUND
-------------
Action type not showing in the print

Actions
Copy link
 #20

Updated by Meljo Sunny 6 months ago

  • Status changed from Reopen Bugs to Reopen Bugs Coding Done
  • % Done changed from 50 to 70
QuoteActions
Copy link
 #21

Updated by Avinash MS 6 months ago

  • Status changed from Reopen Bugs Coding Done to Reopen Bugs
  • % Done changed from 70 to 50

Issue Found
--------------------------------------
Partially range data not found

Actions
Copy link
 #22

Updated by Anonymous 6 months ago

  • Assignee changed from Meljo Sunny to Sreeranjini T
Actions
Copy link
 #23

Updated by Sreeranjini T 5 months ago

  • Status changed from Reopen Bugs to Reopen Bugs Coding Done
  • % Done changed from 50 to 70
QuoteActions
Copy link
 #24

Updated by Arathy PS 5 months ago

  • Status changed from Reopen Bugs Coding Done to Reopen Bugs
  • % Done changed from 70 to 50

ISSUE FOUND
--------------------------------
1. Data appearing in two pages with repeated ticket numbers.

Actions
Copy link
 #25

Updated by Sreeranjini T 5 months ago

  • Status changed from Reopen Bugs to Reopen Bugs Coding Done
  • % Done changed from 50 to 70
Actions
Copy link
 #26

Updated by Theja Ponon 4 months ago

  • Status changed from Reopen Bugs Coding Done to Reopen Bugs Testing Done
  • % Done changed from 70 to 90
Edit Copy Actions
Copy link

Also available in: Atom PDF