Project

General

Profile

Edit Copy Actions

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:
Target version:
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:

Description

Coding GDS Unreported Tickets


Add

Subtasks


Add

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)

Actions #2

Updated by Anil KV over 1 year ago

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

Updated by Anil KV over 1 year ago

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

Updated by Anil KV about 1 year ago

  • Assignee changed from Shahil Haris to travvise Admin

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 #6

Updated by Anil KV about 1 year ago

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

Updated by Anil KV about 1 year ago

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

Updated by Junaid M 8 months ago

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

Updated by Meljo Sunny 8 months ago

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

Updated by Junaid M 8 months ago

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

Updated by Meljo Sunny 8 months ago

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

Updated by Arathy PS 7 months ago

  • Status changed from Coding Done to Testing Started

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 #14

Updated by Meljo Sunny 7 months ago

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

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 #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 #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 #18

Updated by Arathy PS 6 months ago

  • File deleted (clipboard-202409061250-nmsjq.png)

Updated by Arathy PS 6 months ago

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

Actions #20

Updated by Meljo Sunny 6 months ago

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

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 #22

Updated by Anonymous 6 months ago

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

Updated by Sreeranjini T 5 months ago

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

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 #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 #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

Also available in: Atom PDF