Project

General

Profile

Edit Copy Actions

Feature #245

open

Airline Classwise Report

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

Status:
Reopen Bugs Coding Done
Priority:
Normal
Assignee:
Target version:
Start date:
07/09/2023
Due date:
% Done:

70%

Estimated time:
Owner(Agency):
Travvise
Time Taken(HH):
Module:
Airline Classwise Report
Tested By:
Code Reviewed By:

Description

Coding Airline Classwise Report


Add

Subtasks


Add

Related issues

Actions #1

Updated by Junaid M over 1 year ago

  • Status changed from New to Open
  • Assignee changed from travvise Admin to Karthika V Anand
  • % Done changed from 0 to 10
Actions #2

Updated by Karthika V Anand over 1 year ago

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

Updated by Junaid M over 1 year ago

SELECT   vhr_sector,
                                                pk_ticket_fare_id,
                                                vhr_airline_code,
                                                vhr_airline_name,
                                                vhr_display_name,
                                                pk_airline_master_id,
                                                other,first,second,third,fourth

                                        FROM crosstab( $$ SELECT   ARRAY[vhr_sector,vhr_airline_code] as sector_airline,
                                                                   MIN(pk_supp_doc_fare_id) AS pk_supp_doc_fare_id,
                                                                   vhr_sector,
                                                                   vhr_airline_code,    
                                                                   vhr_airline_name,
                                                                   vhr_display_name,
                                                                   pk_airline_master_id,
                                                                   sin_class,
                                                                   SUM(dbl_supplier_amount)
                                                FROM (    
---------------------------------------------------------------------
SELECT
MIN(tf.pk_supp_doc_fare_id) AS pk_supp_doc_fare_id,
vhr_sector,
vhr_airline_code,    
airln.vhr_airline_name,
airln.vhr_display_name,
airln.pk_airline_master_id,
sin_class,
SUM(tf.dbl_supplier_amount) AS dbl_supplier_amount
FROM airticket.tbl_ticket AS tkt
LEFT JOIN service.tbl_supp_doc_fare AS tf
    ON tkt.fk_ticket_base_fare_id = tf.pk_supp_doc_fare_id
LEFT JOIN service.tbl_supp_doc_no AS supp
    ON supp.pk_supp_doc_no_id = tkt.fk_supp_doc_no_id
LEFT JOIN airticket.tbl_ticket_gen_data AS tkgen
    ON supp.pk_supp_doc_no_id = tkgen.fk_supp_doc_no_id
LEFT JOIN airticket.tbl_airline_master AS airln
    ON tkgen.fk_airline_master_id = airln.pk_airline_master_id
WHERE 
supp.sin_last_action != 0 AND tkt.sin_record_type = 1
--AND supp.dat_issue BETWEEN '%s' AND '%s'                                                    
--AND supp.fk_ba_branch_id = ANY('{}')
-->strCurrency = BASE1 -> tkt.fk_ticket_base_fare_id/ tkt.fk_ticket_sup_fare_id    
--AND supp.sin_sys_sale_side_status = ANY('{STATUS}')                                                
GROUP BY tkt.sin_class, airln.vhr_airline_name, airln.vhr_airline_code, airln.vhr_display_name, airln.pk_airline_master_id, tkt.vhr_sector
---------------------

--UNION ALL 
-- REFUND QUERY
-------------------------------------------------                                                    
) AS data
GROUP BY vhr_sector,vhr_airline_code,vhr_airline_name,vhr_display_name,pk_airline_master_id,sin_class    
ORDER  BY 1 $$ ,$$ SELECT sin_class FROM generate_series(0,4) AS sin_class $$) 
AS ct (arrYearLedger text[], pk_ticket_fare_id INT, vhr_sector text, vhr_airline_code text, vhr_airline_name text, vhr_display_name text, pk_airline_master_id bigint, other text, first text, second text, third text, fourth text);

Actions #4

Updated by Karthika V Anand over 1 year ago

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

Updated by unnikannan S over 1 year ago

ISSUE FOUNDED

1.ERROR SHOWING WHILE NOT SEARCH WIYHOUT BRANCH FILTER

Actions #6

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

Updated by Karthika V Anand over 1 year ago

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

Updated by unnikannan S over 1 year ago

TESTING DONE

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.CHANGE IN DATA THAT ADDED TO PREMIUM ECONOMY CLASS TO ECONOMY CLASS

Actions #10

Updated by Karthika V Anand over 1 year ago

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

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 CURLY BRACKET NULL {} SEARCH WITH PAST DATE

Updated by unnikannan S over 1 year ago

unnikannan S wrote in #note-11:

ISSUE FOUNDED

1.SHOWING ERROR CURLY BRACKET NULL {} SEARCH WITH PAST DATE
2.ISSUING STAFF WISE FILTERING NOT WORKING

Updated by unnikannan S over 1 year ago

unnikannan S wrote in #note-12:

unnikannan S wrote in #note-11:

ISSUE FOUNDED

1.ISSUING STAFF WISE FILTERING NOT WORKING

Actions #14

Updated by Junaid M over 1 year ago

  • Assignee changed from Karthika V Anand to Vivekp V

Updated by Vivekp V over 1 year ago

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

fixed issues
1.ISSUING STAFF WISE FILTERING NOT WORKING
2.ISSUING STAFF NOT APPEARING ON PRINT

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.NOT SHOWING SECTOR WHILE ADDING TICKED REMARKS
2.CORRECT AIRLINE NAME IN HEADING

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.NOT SHOWING SECTOR WHILE ADDING TICKED REMARKS
2.CORRECT AIRLINE NAME IN HEADING

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.REMOVE LEDGER CURRENCY FROM CURRENCY FILTER
2.CHANGE VOID NAME SALE & REFUND TO VOID FROM CANCEL GUI IN CONSIDER FILTER
3.SHOWING DATA ONLY FROM VOID FROM CANCEL GUI AND ISSUED VOUCHERS ONLY
4.CHANGE FILTER OPTION NAME STATUS TO CONSIDER

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.REMOVE LEDGER CURRENCY FROM CURRENCY FILTER : removed
2.CHANGE VOID NAME SALE & REFUND TO VOID FROM CANCEL GUI IN CONSIDER FILTER : its in document so changes are withheld for future reference
3.SHOWING DATA ONLY FROM VOID FROM CANCEL GUI AND ISSUED VOUCHERS ONLY : fixed
4.NO DATA WHILE SEARCH WITH INDIVIDUAL CURRENCY : already working
5.CHANGE FILTER OPTION NAME STATUS TO CONSIDER : changed

Updated by unnikannan S about 1 year ago

TESTING DONE

Updated by unnikannan S about 1 year ago

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

UI CHANGES

1.REMOVE DR,CR LABELS AND SHOW AMOUNTS ON BASIS OF POSITIVE,NEGATIVE VALUE
2.SHOW DATA ON THE BASIS OF AIRLINE WISE GROUPING
Split Grid into two

1 -> Source-Destination wise List (No Airline, 1 row per source,destination)
2 -> Airlinewise List (Airline as group head, source,destinations as child)

3.SHOW AIRLINE NAME IN LIST LIKE (NUM CODE,::,NAME,(CHAR CODE)
4.SHOW GRID NAME AS AIRLINE CLASS WISE SUMMARY LIST

Updated by Vivekp V about 1 year ago

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

UI DONE

1.REMOVE DR,CR LABELS AND SHOW AMOUNTS ON BASIS OF POSITIVE,NEGATIVE VALUE
2.SHOW DATA ON THE BASIS OF AIRLINE WISE GROUPING
Split Grid into two

1 -> Source-Destination wise List (No Airline, 1 row per source,destination)
2 -> Airlinewise List (Airline as group head, source,destinations as child)

3.SHOW AIRLINE NAME IN LIST LIKE (NUM CODE,::,NAME,(CHAR CODE)
4.SHOW GRID NAME AS AIRLINE CLASS WISE SUMMARY LIST

Updated by unnikannan S about 1 year ago

TESTING DONE

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 AMOUNT FROM LIST AFTER CANCELLING A VOUCHER

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 AMOUNT FROM LIST AFTER CANCELLING A VOUCHER

Actions #26

Updated by unnikannan S 6 months ago

  • Status changed from Reopen Bugs Coding Done to Testing Done
  • % Done changed from 70 to 90
Actions #27

Updated by Arathy PS 24 days ago

  • Assignee changed from Vivekp V to Nawal Sidique

Updated by Arathy PS 24 days ago

  • Status changed from Testing Done to New Changes
  • % Done changed from 90 to 50

NEW CHANGES - DONE
-------------------------------
1. Add these new filters : customer, supplier, Airline, showing value
2. Showing value should be select box with price, count, cost, profit
3. In the filter section only 1st row should be visible other rows should be expandable.

ISSUE FOUND - FIXED
-----------------------
Data in summary tab and details tab should be swapped.

Actions #29

Updated by Nawal Sidique 20 days ago

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

Updated by Arathy PS 12 days ago

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

ISSUE FOUND - NOT NEEDED
---------------------------
1. While searching using a customer which has done AR sharing, amount is not showing based on AR sharing.

Actions #31

Updated by Nawal Sidique 5 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