Project

General

Custom queries

Profile

Edit Copy Actions

Feature #214

open

Ticket/Voucher Query

Added by Junaid M over 1 year ago. Updated about 1 month ago.

Status:
Reopen Bugs Testing Done
Priority:
Normal
Target version:
Start date:
06/27/2023
Due date:
% Done:

90%

Estimated time:
Owner(Agency):
Travvise
Time Taken(HH):
Module:
Ticket/Voucher Query
Tested By:
unnikannan S
Code Reviewed By:

Description

Coding Ticket/Voucher Query


Files


Add

Subtasks


Add

Related issues

Actions #1

Updated by Junaid M about 1 year ago

  • Status changed from New to Ready for Coding
  • Assignee changed from travvise Admin to Nithin Raj
  • % Done changed from 0 to 20

Updated by Junaid M about 1 year ago

Controller:- AirticketController

Genaral Table Query -> Refer Ticket/Voucher Search Report Module Query
Issue Tab  :- 

SELECT sd.pk_supp_doc_no_id,
                sd.vhr_supp_doc_no,
                sd.dat_issue,
                sd.dat_cancel,                                                                                               
                sd.vhr_pnr_number,
                sd.vhr_pax_name,
                sd.fk_pax_profile_id,
                sd.dat_refund,
                sd.sin_sys_current_status,
                sd.fk_branch_id,
                sd.dat_from,
                sd.dat_to,
                sd.sin_no_of_pax,
                sd.sin_sys_sale_side_status,
                sd.sin_sys_refund_side_status,

                tkt.vhr_last_conjuction_ticket_no,
                tkt.fk_ticket_type_id,
                tkt.vhr_class_chr,
                tkt.sin_class,
                tkt.vhr_sector,
                tkt.txt_remarks,
                tkt.sin_feeding_channel,
                tkt.sin_gds_company,

                tktgen.fk_airline_master_id,
                tktgen.vhr_tour_code,
                tktgen.vhr_original_issue_ticket,
                tktgen.vhr_re_issue_ticket,
                tktgen.vhr_fare_basis,
                tktgen.fk_ticketing_counter_staff_id,
                tktgen.fk_booking_counter_staff_id,
                tktgen.vhr_booking_agency_office_id,
                tktgen.vhr_air_ticketing_agency_office_id,

                tfd.dbl_fare,
                tfd.dbl_tax,
                tfd.dbl_supplier_amount,
                tfd.dbl_normal_profit,
                tfd.dbl_customer_price

            FROM service.tbl_supp_doc_no AS sd  
            LEFT JOIN airticket.tbl_ticket_gen_data AS tktgen
                ON sd.pk_supp_doc_no_id = tktgen.fk_supp_doc_no_id
            LEFT JOIN airticket.tbl_ticket AS tkt
                ON sd.pk_supp_doc_no_id = tkt.fk_supp_doc_no_id
            LEFT JOIN service.tbl_supp_doc_fare AS tfd
                ON tkt.fk_ticket_cus_ledg_fare_id=tfd.pk_supp_doc_fare_id
            WHERE sd.sin_last_action != -1 AND sd.vhr_supp_doc_no = '?';                                                                                                             

Query -> Original Issue Re-Issue Ticket List
-------------------------------------
SELECT   sd.pk_supp_doc_no_id,
                sd.vhr_supp_doc_no,
                sd.dat_issue,
                sd.dat_cancel,       

                tfd.dbl_fare,
                tfd.dbl_tax,
                tfd.dbl_supplier_amount,
                tfd.dbl_normal_profit,
                tfd.dbl_customer_price

FROM airticket.tbl_ticket_gen_data tgen
LEFT JOIN service.tbl_supp_doc_no sd
    ON sd.pk_supp_doc_no_id = tgen.fk_supp_doc_no_id
LEFT JOIN service.tbl_supp_doc_fare AS tfd
    ON sd.fk_issue_cus_ledg_fare_id = tfd.pk_supp_doc_fare_id 
WHERE tgen.vhr_original_issue_ticket = '?'

Query - Invoice Posting
----------------------------------
SELECT
    tr.pk_transaction_id,
    tr.dat_transaction,

    tr.fk_ledger_id,
    ac.vhr_account_code,
    ac.vhr_account_name,

    tr.vhr_ledg_currency,
    tr.vhr_base_currency,
    tr.dbl_ledg_cur_debit,
    tr.dbl_ledg_cur_credit,

    tr.dbl_ledg_cur_outstanding,
    tr.dbl_base_cur_outstanding,
    tr.fk_branch_id,
    tr.vhr_reference,
    tr.txt_narration

FROM service.tbl_supp_doc_no AS supp 
LEFT JOIN transaction.tbl_transaction AS tr
    ON tr.fk_supp_doc_no_id = supp.pk_supp_doc_no_id
LEFT JOIN accounts.tbl_account AS ac
     ON tr.fk_ledger_id = ac.pk_account_id
WHERE supp.vhr_supp_doc_no = '?' --ticket/voucher no
AND tr.sin_transaction_status = 1
AND tr.vhr_sys_module_name = 'SALE'

Query Refund Posting
-----------------------
SELECT
    tr.pk_transaction_id,
    tr.dat_transaction,

    tr.fk_ledger_id,
    ac.vhr_account_code,
    ac.vhr_account_name,

    tr.vhr_ledg_currency,
    tr.vhr_base_currency,
    tr.dbl_ledg_cur_debit,
    tr.dbl_ledg_cur_credit,

    tr.dbl_ledg_cur_outstanding,
    tr.dbl_base_cur_outstanding,
    tr.fk_branch_id,
    tr.vhr_reference,
    tr.txt_narration

FROM service.tbl_supp_doc_no AS supp 
LEFT JOIN transaction.tbl_transaction AS tr
    ON tr.fk_supp_doc_no_id = supp.pk_supp_doc_no_id
LEFT JOIN accounts.tbl_account AS ac
     ON tr.fk_ledger_id = ac.pk_account_id
WHERE supp.vhr_supp_doc_no = '?' --ticket/voucher no
AND tr.sin_transaction_status = 1
AND tr.vhr_sys_module_name = 'REFUND'

Query - Log
----------------
SELECT 
    dtm_last_update,
    sin_last_action, --0=>Created, Above 0=> Modified, -1=>Deleted
    fk_last_action_user_id --Join to User table for name
    FROM log.tbl_supp_doc_no_log
WHERE supp.vhr_supp_doc_no = '?'

Actions #3

Updated by Anil KV 9 months ago

  • Assignee changed from Nithin Raj to Greeshma S
Actions #4

Updated by Junaid M 8 months ago

  • Assignee changed from Greeshma S to Augustin Jose
Actions #5

Updated by Augustin Jose 8 months ago

  • Status changed from Ready for Coding to Coding Started
  • % Done changed from 20 to 30
Actions #6

Updated by Augustin Jose 8 months ago

  • Status changed from Coding Started to Coding Done
  • % Done changed from 30 to 60
Actions #7

Updated by Arathy PS 7 months ago

  • Status changed from Coding Done to Testing Started

Updated by Arathy PS 7 months ago

  • Status changed from Testing Started to Reopen Bugs
  • % Done changed from 60 to 50
  • Tested By set to Arathy PS

ISSUE FOUND:

1)Check in and check out date not showing for hotel issue.
2)Doc. sub no: date without doc. sub no:
3)Wrong channel data in other issue.
4)Hotel issue current status not showing for issue/cancel

Actions #9

Updated by Augustin Jose 7 months ago

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

Updated by unnikannan S 5 months ago

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

ISSUE FOUNDED

1.Missing Outstanding,AP Sharing Amounts From Fare Fields Of Vouchers

Actions #11

Updated by Augustin Jose 5 months ago

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

Updated by Theja Ponon 4 months ago

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

ISSUE FOUND
---------------

1)LPO date and LPO number are not updating

Actions #13

Updated by Theja Ponon 4 months ago

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

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 Arathy PS 4 months ago

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

NEW CHANGES
----------------------------------------------
1. Add a new tab for note.
2. Add attachment as a tab.
3. The print for each tab should appear in separate tabs with option.

Actions #16

Updated by Augustin Jose 4 months ago

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

Updated by Theja Ponon 4 months ago

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

ISSUE FOUND
------------------
1)NOTE IS NOT CLEARED ON CLICKING NEW AND RESET
2)NOTE IS NOT GET ON SEARCH WITHOUT SHIFTING TAB FROM ANOTHER TAB TO NOTE TAB
3)ATTACHMENT IS NOT GET ON SEARCH WITHOUT SHIFTING TAB FROM ANOTHER TAB TO ATTACHMENT TAB
4)ATTACHMENT IS NOT CLEAR ON RESET
5)EXPIRY DATE CAN SET BEFORE THE DATE OF NOTE

Actions #18

Updated by Augustin Jose 3 months ago

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

Updated by Theja Ponon 3 months ago

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

Updated by Arathy PS 2 months ago

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

Changes
----------------------------------------------
1. Add redirection to the document and voucher numbers.

Actions #21

Updated by Augustin Jose 2 months ago

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

Updated by Theja Ponon 2 months ago

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

ISSUE FOUND
---------------
1)Value in input field is not clearing with changing dropdown value
2)Data is not load in sale on redirecting

Actions #23

Updated by Augustin Jose 2 months ago

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

Updated by Theja Ponon 2 months ago

Actions #25

Updated by Augustin Jose 2 months ago

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

Updated by Theja Ponon 2 months ago

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

Updated by Arathy PS about 1 month ago

ISSUE FOUND
---------------------------

Actions #28

Updated by Augustin Jose about 1 month ago

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

Updated by Theja Ponon about 1 month ago

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

ISSUE FOUND
------------
1)Ticketing Office ID,Booking Office ID values are not showing
2)Data in attachment and note tab is not showing in print
3)Data in issue tab showing in print of cancel tab

Actions #30

Updated by Augustin Jose about 1 month ago

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

Updated by Theja Ponon about 1 month ago

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

Also available in: Atom PDF