Feature #247: Air Deal Report - TAAS - Redmine

Custom queries

All Works In Current Sprint
Issues assigned to me
My Works In Current Sprint
Reported issues
Updated issues
Watched issues

Add

Watchers (9)

Anil KV Delete
Junaid M Delete
Abhiram Venu Delete
Shahil Haris Delete
unnikannan S Delete
Vivekp V Delete
Arathy PS Delete
Nawal Sidique Delete
Theja Ponon Delete

Edit Copy Actions

Copy link

Feature #247

open

Air Deal Report

Added by Anil KV almost 2 years ago. Updated 29 days ago.

Status:

Reopen Bugs Coding Done

Priority:

Normal

Assignee:

Nawal Sidique

Target version:

22.12

Start date:

09/26/2023

Due date:

% Done:

70%

Estimated time:

Owner(Agency):

Travvise

Time Taken(HH):

Module:

Deal Report

Tested By:

unnikannan S

Code Reviewed By:

Quote

Description

Coding Deal Report

Files

Download all files

clipboard-202502141449-r6dpx.png (127 KB) clipboard-202502141449-r6dpx.png		Arathy PS, 02/14/2025 02:49 PM
clipboard-202503291515-xkebs.png (116 KB) clipboard-202503291515-xkebs.png		Arathy PS, 03/29/2025 03:15 PM

Add

Subtasks

Add

Related issues

Issue # Delay: days Cancel

History
Notes
Property changes

Actions

Copy link

Updated by Anil KV almost 2 years ago

Assignee set to travvise Admin

QuoteActions

Copy link

Updated by Anil KV over 1 year ago

Solutions:-

1) GUI Changes
-Currency - Not need base2 item and Add all currency
-Status - Tick only ISSUED and SOLD
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,
        COALESCE(spd.vhr_pax_name, pxp.vhr_pax_name, '') AS vhr_pax_name,
        spd.sin_no_of_pax,
        tkg.vhr_deal_no,
        tkt.sin_record_type, --*2
        tkt.vhr_sector,
        tkt.vhr_class_chr,
        tkt.sin_class,
        tkt.txt_remarks,
        sfr.vhr_currency,
        sfr.dbl_fare,
        sfr.dbl_tax,
        sfr.dbl_commission,
        sfr.dbl_actual_cost,
        sfr.dbl_supplier_amount,
        sfr.dbl_customer_price,
        sfr.dbl_normal_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 --*1
        LEFT JOIN pax.tbl_pax_profile pxp
            ON spd.fk_pax_profile_id = pxp.pk_pax_profile_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_sys_current_status IN (1,2)
        --AND spd.dat_issue BETWEEN '2023-08-08' AND '2023-08-08'
        --...

Actions

Copy link

Updated by Anil KV over 1 year ago

Status changed from New to Open
% Done changed from 0 to 10

Actions

Copy link

Updated by Junaid M over 1 year ago

Assignee changed from travvise Admin to Abhiram Venu

Actions

Copy link

Updated by Abhiram Venu over 1 year ago

Status changed from Open to Coding Started
% Done changed from 10 to 40

Actions

Copy link

Updated by Abhiram Venu over 1 year ago

Start date changed from 07/09/2023 to 09/26/2023

QuoteActions

Copy link

Updated by Abhiram Venu over 1 year ago

Status changed from Coding Started to Coding Done
% Done changed from 40 to 60

Deal Report Done
Ready For Checking

QuoteActions

Copy link

Updated by unnikannan S over 1 year ago

Status changed from Coding Done to Reopen Bugs
% Done changed from 60 to 50
Tested By set to unnikannan S

ISSUE FOUNDED

1.FREEZE FILTERS WHILE LOADING DATA
2.BOOKING STAFF ISSUING STAFF WISE FILTER NOT WORKING
3.ERROR WHILE CLEAR DATE AND SEARCH
4.ERROR WHILE ADD DEAL CODE AND SEARCH
5.CHANGE PRINT HEADING TO (DEAL REPORT LIST)
6.CORRECT GRID,PRINT LABEL AIR TO AIRLINE
7.ISSUE IN CHANGING STATUS WISE SEARCH
8.ERASE & SEARCH (SECTOR/CLASS ) TOOL BAR NOT WORKING
9.REMOVE EDIT OPTION FROM PRINT
10.MISSING STATUS WHILE CHOOSING NEW

QuoteActions

Copy link

Updated by unnikannan S over 1 year ago

unnikannan S wrote in #note-8:

ISSUE FOUNDED

1.FREEZE FILTERS WHILE LOADING DATA
2.BOOKING STAFF ISSUING STAFF WISE FILTER NOT WORKING
3.ERROR WHILE CLEAR DATE AND SEARCH
4.ERROR WHILE ADD DEAL CODE AND SEARCH
5.CHANGE PRINT HEADING TO (DEAL REPORT LIST)
6.CORRECT GRID,PRINT LABEL AIR TO AIRLINE
7.ISSUE IN CHANGING STATUS WISE SEARCH
8.ERASE & SEARCH (SECTOR/CLASS ) TOOL BAR NOT WORKING
9.REMOVE EDIT OPTION FROM PRINT
10.MISSING STATUS WHILE CHOOSING NEW
11.ADD SPACE BETWEEN HEADING IN PAGE
12.CORRECT THE ISSUE DATE FORMAT TO DD/MM/YYYY

QuoteActions

Copy link

#10

Updated by Abhiram Venu over 1 year ago

Reported issues 1,3,5,6,11 solved.

Actions

Copy link

#11

Updated by Junaid M over 1 year ago

Assignee changed from Abhiram Venu to Shahil Haris

Actions

Copy link

#12

Updated by Shahil Haris over 1 year ago

Status changed from Reopen Bugs to Reopen Bugs Coding Done
% Done changed from 50 to 60

Actions

Copy link

#13

Updated by unnikannan S over 1 year ago

Status changed from Reopen Bugs Coding Done to Reopen Bugs
% Done changed from 60 to 50

QuoteActions

Copy link

#14

Updated by unnikannan S over 1 year ago

ISSUE FOUNDED

1.DUPLICATION OF VOUCHERS IN LIST
2.SHOW CANCEL/REFUNDABLE AMOUNT AS NEGATIVE IN LIST
3.SHOW BOOKING STAFF/ISSUING STAFF WISE FILTER SEARCH
4.NO DATA WHILE SEARCH WITH DEAL NO

Actions

Copy link

#15

Updated by Shahil Haris over 1 year ago

Status changed from Reopen Bugs to Reopen Bugs Coding Done
% Done changed from 50 to 60

QuoteActions

Copy link

#16

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.SHOWING ERROR {} WHILE SEARCH FIXED
2.SHOW DATA AS PER ADDED CUSTOMER IN CUSTOMER FILTER FIELD fIXED
3.ADD NO DATA FOUND POP UP FIXED
4.CORRECT THE ALLIGMENT OF GRID

Actions

Copy link

#17

Updated by Junaid M over 1 year ago

Assignee changed from Shahil Haris to Vivekp V

QuoteActions

Copy link

#18

Updated by Junaid M over 1 year ago

GUI CHANGE
---------------
1. Add grouping in Grid. Deal code wise group

QuoteActions

Copy link

#19

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.SHOWING ERROR {} WHILE SEARCH FIXED
2.SHOW DATA AS PER ADDED CUSTOMER IN CUSTOMER FILTER FIELD fIXED
3.ADD NO DATA FOUND POP UP FIXED
4.CORRECT THE ALLIGMENT OF GRID
GUI CHANGE DONE
---------------
1. Add grouping in Grid. Deal code wise group

QuoteActions

Copy link

#20

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 FROM LIST
2.NO DATA WHILE SEARCH WITH BOOKING,ISSUING STAFF FIELDS

QuoteActions

Copy link

#21

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 FROM LIST FIXED
2.NO DATA WHILE SEARCH WITH BOOKING,ISSUING STAFF FIELDS is working correctly

QuoteActions

Copy link

#22

Updated by unnikannan S about 1 year ago

TESTING DONE

QuoteActions

Copy link

#23

Updated by Anil KV 9 months ago

Status changed from Reopen Bugs Coding Done to New Changes
% Done changed from 70 to 50

New Changes DONE

-> Rename 'Deal Report' to 'Air Deal Report' (GUI Heading and Menu)
-> Add 'Deal Code'(Applied Deal Code) and 'Deal Type'(Applied Deal Code Type) columns after ticket
-> 'Applicable Deal Code' Column value -> More than one case:-
-Deal Code:XXX, Tour Code:XXX, Corporate Code:XXX, Military Code:XXX
*If 'Deal Code' value not in the column then the record showing red(or pls discus with anil)
-> Add 'Deal Type'(Check set air deal module) filter - Multi-select
-> Check Column width 
*** PLS  DISCUS WITH JUNIDE - Deal realted tables changes and workflow

Actions

Copy link

#24

Updated by Vivekp V 8 months ago

Status changed from New Changes to New Changes Coding Done
% Done changed from 50 to 70

QuoteActions

Copy link

#25

Updated by unnikannan S 8 months ago

Status changed from New Changes Coding Done to Reopen Bugs
% Done changed from 70 to 50

ISSUE FOUNDED

1.Add Expand/Collapse Tool On Grid
2.Change Grid Name To Air Deal Report
3.Fix The Error While Unticking All Deal Type Items

QuoteActions

Copy link

#26

Updated by Vivekp V 8 months ago

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

ISSUE FIXES

1.Add Expand/Collapse Tool On Grid
2.Change Grid Name To Air Deal Report
3.Fix The Error While Unticking All Deal Type Items

QuoteActions

Copy link

#27

Updated by unnikannan S 7 months ago

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

ISSUE FOUNDED

1.Fix Translation Mistakes In Grid

QuoteActions

Copy link

#28

Updated by Vivekp V 7 months ago

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

ISSUE FIXED

1.Fix Translation Mistakes In Grid

Actions

Copy link

#29

Updated by Arathy PS 3 months ago

Subject changed from Deal Report to Air Deal Report

Actions

Copy link

#30

Updated by Arathy PS 3 months ago

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

QuoteActions

Copy link

#31

Updated by Arathy PS 3 months ago

File clipboard-202502141449-r6dpx.png clipboard-202502141449-r6dpx.png added
Assignee changed from Vivekp V to Nawal Sidique

ISSUE FOUND - FIXED
--------------------------------
1. Not showing applicable deal code for tickets with cancel status.

CHANGE - DONE
------------------
1. Remove booking (xo) from status filter.

Actions

Copy link

#32

Updated by Nawal Sidique 2 months ago

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

QuoteActions

Copy link

#33

Updated by Theja Ponon 2 months ago

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

ISSUE FOUND - FIXED
---------
1)Airline is loading when focus out from airline field

Actions

Copy link

#34

Updated by Nawal Sidique 2 months ago

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

QuoteActions

Copy link

#35

Updated by Arathy PS about 1 month ago

File clipboard-202503291515-xkebs.png clipboard-202503291515-xkebs.png added
Status changed from Reopen Bugs Coding Done to Reopen Bugs
% Done changed from 70 to 50

ISSUE FOUND
---------------------------------
1. Not showing deal code in the grouping. - FIXED

Actions

Copy link

#36

Updated by Nawal Sidique 29 days ago

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

Edit Copy Actions

Copy link

Edit

Notes

Files

(Maximum size: 5 MB)

Cancel

Also available in: Atom PDF

Project

General

Profile

TAAS

Custom queries

Watchers (9)

Feature #247

Air Deal Report

Updated by Anil KV almost 2 years ago

Updated by Anil KV over 1 year ago

Updated by Anil KV over 1 year ago

Updated by Junaid M over 1 year ago

Updated by Abhiram Venu over 1 year ago

Updated by Abhiram Venu over 1 year ago

Updated by Abhiram Venu over 1 year ago

Updated by unnikannan S over 1 year ago

Updated by unnikannan S over 1 year ago

Updated by Abhiram Venu over 1 year ago

Updated by Junaid M over 1 year ago

Updated by Shahil Haris over 1 year ago

Updated by unnikannan S over 1 year ago

Updated by unnikannan S over 1 year ago

Updated by Shahil Haris over 1 year ago

Updated by unnikannan S over 1 year ago

Updated by Junaid M over 1 year ago

Updated by Junaid M over 1 year ago

Updated by Vivekp V over 1 year ago

Updated by unnikannan S about 1 year ago

Updated by Vivekp V about 1 year ago

Updated by unnikannan S about 1 year ago

Updated by Anil KV 9 months ago

Updated by Vivekp V 8 months ago

Updated by unnikannan S 8 months ago

Updated by Vivekp V 8 months ago

Updated by unnikannan S 7 months ago

Updated by Vivekp V 7 months ago

Updated by Arathy PS 3 months ago

Updated by Arathy PS 3 months ago

Updated by Arathy PS 3 months ago

Updated by Nawal Sidique 2 months ago

Updated by Theja Ponon 2 months ago

Updated by Nawal Sidique 2 months ago

Updated by Arathy PS about 1 month ago

Updated by Nawal Sidique 29 days ago

Edit