Feature #244
openAirline Sales Analysis Report
70%
Subtasks
Related issues
Updated by Anonymous over 1 year ago
- Assignee changed from travvise Admin to Amal Pious
Updated by Amal Pious over 1 year ago
- Status changed from New to Coding Started
- Start date changed from 07/09/2023 to 08/07/2023
- % Done changed from 0 to 40
Updated by Anil KV over 1 year ago
Solution
-Issue Date to Issue/Cancel Date* -Grouping Default Monthly -SQL Tables check ->Airline Sales and Refund and Customer #243 and Style check = Customer Sales Analysis Report #229 -SQL Group by - sin_record_type also -Amount consider dbl_supplier_amount
Updated by Junaid M over 1 year ago
SELECT spd.fk_service_id, CASE WHEN tkt.sin_record_type = 1 THEN TO_CHAR(spd.dat_issue , 'Month YYYY') ELSE TO_CHAR(spd.dat_cancel , 'Month YYYY') END AS str_month, spd.fk_branch_id, spd.fk_department_id, spd.fk_sub_customer_id, tkt.sin_record_type, spd.sin_sys_sale_side_status, spd.sin_sys_refund_side_status, sfr.dbl_customer_price, sfr.dbl_normal_profit FROM airticket.tbl_ticket tkt LEFT JOIN service.tbl_supp_doc_no AS spd ON tkt.fk_supp_doc_no_id = spd.pk_supp_doc_no_id LEFT JOIN airticket.tbl_ticket_gen_data AS tkg ON spd.pk_supp_doc_no_id = tkg.fk_supp_doc_no_id LEFT JOIN service.tbl_supp_doc_fare AS sfr ON tkt.fk_ticket_cus_ledg_fare_id = sfr.pk_supp_doc_fare_id --*1 WHERE tkt.int_sys_action_id != -1 AND (spd.sin_sys_sale_side_status IN (1, 2) OR spd.sin_sys_refund_side_status IN (1,3)) AND spd.dat_issue BETWEEN '2023-08-08' AND '2023-08-08' AND (spd.vhr_pax_name ILIKE '*' OR spd.vhr_pax_name ILIKE '*') -- Other Filters
Updated by Amal Pious over 1 year ago
- Status changed from Coding Started to Coding Done
- % Done changed from 40 to 60
Updated by Seema Mathew over 1 year ago
- Status changed from Coding Done to Reopen Bugs
- % Done changed from 60 to 50
- Tested By set to Seema Mathew
ISSUE FOUNDED **
1.MISSING DATA WHILE CHANGING GROUPING .
Updated by Amal Pious over 1 year ago
1.MISSING DATA WHILE CHANGING GROUPING . - Fixed
Updated by Amal Pious 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
- Tested By changed from Seema Mathew to unnikannan S
ISSUE FOUNDED
1.BASE 1 QAR WISE CHANGE IN AMOUNT FIELD
Updated by Amal Pious over 1 year ago
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 60
1.BASE 1 QAR WISE CHANGE IN AMOUNT FIELD - Fixed
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 PRINT FORMAT TO NORMAL FIELD WHILE THERE IS ONLY ONE LIST ITEM
Updated by Junaid M over 1 year ago
- Assignee changed from Amal Pious to Sibin Babu
Updated by Sibin Babu 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
- GUI CHANGES
Done 1.CHANGE GRID FORMAT (REFFER CUSTOMER SALES ANALYSIS REPORT)
ISSUE FOUNDED
Fixed 1.NOT SHOWING DATAS FROM REFUNDED DOCUMENTS AND VOID VOUCHERS
Done 2.ADD TRANSACTION/DOCUMENT DATES IN PERIOD DROP DOWN AND SHOW TRANSACTION DATE AS DEFAULT DATE
Fixed 3.DATA NOT CLEARING WHILE CHOOSING NEW BUTTON FROM GRID GROUPING ITEMS
Fxed 4.NO DATA WHILE SEARCH WITH INDIVIDUAL CURRENCY
Updated by Anonymous about 1 year ago
- Assignee changed from Sibin Babu to Amal Siby
Updated by Amal Siby about 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.FALSE AMOUNT SHOWING IN REFUND COLUMN AFTER ISSUING TO CANCEL
Updated by Junaid M about 1 year ago
- Assignee changed from Amal Siby to Baseem Shan
Updated by Junaid M about 1 year ago
- Assignee changed from Baseem Shan to Vivekp V
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.FALSE AMOUNT SHOWING IN REFUND COLUMN AFTER ISSUING TO CANCEL
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.SHOW SUPPLIER SIDE COST WHILE CHANGING CURRENCY
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.SHOW SUPPLIER SIDE COST WHILE CHANGING CURRENCY
Updated by Arathy PS 5 months ago
- Status changed from Testing Done to Reopen Bugs
- % Done changed from 90 to 50
ISSUE FOUND
-------------------------------------
1. Data not showing for issue, cancel, void options in the consider field. use drop down of data to issue date
2. Number of items in the refund column gets doubled after each update. from refund tbl_mod_of_refund_supp_doc data Duplication in this table causes this data to be added again when refund is fixed automatically this will be fixed
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
Updated by Augustin Jose 9 days ago
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 70