Project

General

Profile

Edit Copy Actions

Feature #247

open

Air Deal Report

Added by Anil KV over 1 year ago. Updated 25 days ago.

Status:
Reopen Bugs Coding Done
Priority:
Normal
Assignee:
Target version:
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:

Description

Coding Deal Report


Files

clipboard-202502141449-r6dpx.png (127 KB) clipboard-202502141449-r6dpx.png Arathy PS, 02/14/2025 02:49 PM

Add

Subtasks


Add

Related issues

Actions #1

Updated by Anil KV over 1 year ago

  • Assignee set to travvise Admin

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

Updated by Anil KV over 1 year ago

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

Updated by Junaid M over 1 year ago

  • Assignee changed from travvise Admin to Abhiram Venu
Actions #5

Updated by Abhiram Venu over 1 year ago

  • Status changed from Open to Coding Started
  • % Done changed from 10 to 40
Actions #6

Updated by Abhiram Venu over 1 year ago

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

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

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

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

Updated by Abhiram Venu over 1 year ago

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

Actions #11

Updated by Junaid M over 1 year ago

  • Assignee changed from Abhiram Venu to Shahil Haris
Actions #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 #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

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

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

Updated by Junaid M about 1 year ago

  • Assignee changed from Shahil Haris to Vivekp V

Updated by Junaid M about 1 year ago

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

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

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

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

Updated by unnikannan S about 1 year ago

TESTING DONE

Updated by Anil KV 7 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 #24

Updated by Vivekp V 7 months ago

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

Updated by unnikannan S 7 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

Updated by Vivekp V 7 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

Updated by unnikannan S 6 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

Updated by Vivekp V 6 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 #29

Updated by Arathy PS about 1 month ago

  • Subject changed from Deal Report to Air Deal Report
Actions #30

Updated by Arathy PS about 1 month ago

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

Updated by Arathy PS about 1 month ago

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

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

Actions #32

Updated by Nawal Sidique 28 days ago

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

Updated by Theja Ponon 25 days 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 #34

Updated by Nawal Sidique 25 days ago

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

Also available in: Atom PDF