Feature #244: Airline Sales Analysis 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 (10)

Amal Pious Delete
Anil KV Delete
Junaid M Delete
unnikannan S Delete
Sibin Babu Delete
Amal Siby Delete
Vivekp V Delete
Arathy PS Delete
Theja Ponon Delete
Augustin Jose Delete

Edit Copy Actions

Copy link

Feature #244

open

« Previous | 259 of 497 | Next »

Airline Sales Analysis Report

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

Status:

Reopen Bugs Coding Done

Priority:

Normal

Assignee:

Augustin Jose

Target version:

22.12

Start date:

08/07/2023

Due date:

% Done:

70%

Estimated time:

Owner(Agency):

Travvise

Time Taken(HH):

Module:

Airline Sales Analysis Report

Tested By:

unnikannan S

Code Reviewed By:

Quote

Description

Coding Airline Sales Analysis Report

Add

Subtasks

Add

Related issues

Issue # Delay: days Cancel

History
Notes
Property changes

Actions

Copy link

Updated by Anonymous over 1 year ago

Assignee changed from travvise Admin to Amal Pious

Actions

Copy link

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

QuoteActions

Copy link

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

QuoteActions

Copy link

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

Actions

Copy link

Updated by Amal Pious over 1 year ago

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

QuoteActions

Copy link

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 .

QuoteActions

Copy link

Updated by Amal Pious over 1 year ago

1.MISSING DATA WHILE CHANGING GROUPING . - Fixed

Actions

Copy link

Updated by Amal Pious over 1 year ago

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

QuoteActions

Copy link

Updated by Seema Mathew over 1 year ago

TESTING DONE

QuoteActions

Copy link

#10

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

QuoteActions

Copy link

#11

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

QuoteActions

Copy link

#12

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

Actions

Copy link

#13

Updated by Junaid M over 1 year ago

Assignee changed from Amal Pious to Sibin Babu

Actions

Copy link

#14

Updated by Sibin Babu over 1 year ago

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

QuoteActions

Copy link

#15

Updated by unnikannan S over 1 year ago

TESTING DONE

QuoteActions

Copy link

#16

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

Actions

Copy link

#17

Updated by Anonymous about 1 year ago

Assignee changed from Sibin Babu to Amal Siby

Actions

Copy link

#18

Updated by Amal Siby about 1 year ago

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

QuoteActions

Copy link

#19

Updated by unnikannan S about 1 year ago

TESTING DONE

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.FALSE AMOUNT SHOWING IN REFUND COLUMN AFTER ISSUING TO CANCEL

Actions

Copy link

#21

Updated by Junaid M about 1 year ago

Assignee changed from Amal Siby to Baseem Shan

Actions

Copy link

#22

Updated by Junaid M about 1 year ago

Assignee changed from Baseem Shan to Vivekp V

QuoteActions

Copy link

#23

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

QuoteActions

Copy link

#24

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

QuoteActions

Copy link

#25

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

Actions

Copy link

#26

Updated by unnikannan S 6 months ago

Status changed from Reopen Bugs Coding Done to Testing Done
% Done changed from 70 to 90

QuoteActions

Copy link

#27

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

Actions

Copy link

#28

Updated by Vivekp V 5 months ago

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

QuoteActions

Copy link

#29

Updated by unnikannan S 4 months ago

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

ISSUE FOUNDED

1.Error While Search With Issued,Cancel,Void Items From Consider Options

QuoteActions

Copy link

#30

Updated by Vivekp V 4 months ago

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

ISSUE FIXED

1.Error While Search With Issued,Cancel,Void Items From Consider Options

QuoteActions

Copy link

#31

Updated by unnikannan S 4 months ago

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

ISSUE FOUNDED

1.Not Re-Loading To Default Transaction Date Drop Down After Changing The Drop Down Date Item And Selecting New Button

QuoteActions

Copy link

#32

Updated by Vivekp V 4 months ago

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

ISSUE FIXED

1.Not Re-Loading To Default Transaction Date Drop Down After Changing The Drop Down Date Item And Selecting New Button

Actions

Copy link

#33

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

QuoteActions

Copy link

#34

Updated by Arathy PS 13 days ago

Status changed from Reopen Bugs Testing Done to Reopen Bugs
Assignee changed from Vivekp V to Augustin Jose
% Done changed from 90 to 50

ISSUE FOUND
-----------------------------
1. Reset button missing.
2. Data/Amount shared through AR sharing is missing.

Actions

Copy link

#35

Updated by Augustin Jose 9 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 (10)

Feature #244

Airline Sales Analysis Report

Updated by Anonymous over 1 year ago

Updated by Amal Pious over 1 year ago

Updated by Anil KV over 1 year ago

Updated by Junaid M over 1 year ago

Updated by Amal Pious over 1 year ago

Updated by Seema Mathew over 1 year ago

Updated by Amal Pious over 1 year ago

Updated by Amal Pious over 1 year ago

Updated by Seema Mathew over 1 year ago

Updated by unnikannan S over 1 year ago

Updated by Amal Pious over 1 year ago

Updated by unnikannan S over 1 year ago

Updated by Junaid M over 1 year ago

Updated by Sibin Babu over 1 year ago

Updated by unnikannan S over 1 year ago

Updated by unnikannan S about 1 year ago

Updated by Anonymous about 1 year ago

Updated by Amal Siby about 1 year ago

Updated by unnikannan S about 1 year ago

Updated by unnikannan S about 1 year ago

Updated by Junaid M about 1 year ago

Updated by Junaid M about 1 year ago

Updated by Vivekp V about 1 year ago

Updated by unnikannan S about 1 year ago

Updated by Vivekp V about 1 year ago

Updated by unnikannan S 6 months ago

Updated by Arathy PS 5 months ago

Updated by Vivekp V 5 months ago

Updated by unnikannan S 4 months ago

Updated by Vivekp V 4 months ago

Updated by unnikannan S 4 months ago

Updated by Vivekp V 4 months ago

Updated by Theja Ponon 4 months ago

Updated by Arathy PS 13 days ago

Updated by Augustin Jose 9 days ago

Edit