Project

General

Profile

Edit Copy Actions

Feature #172

open

ADM/ACM Tracker

Added by Anil KV about 2 years ago. Updated 3 months ago.

Status:
Testing Done
Priority:
Normal
Assignee:
Target version:
Start date:
07/27/2023
Due date:
% Done:

90%

Estimated time:
Owner(Agency):
Travvise
Time Taken(HH):
Module:
ADM/ACM Tracker
Tested By:
unnikannan S
Code Reviewed By:

Description

Coding ADM/ACM Tracker


Add

Subtasks


Add

Related issues

Actions #1

Updated by Anil KV about 2 years ago

  • Assignee set to Junaid M
Actions #2

Updated by Anil KV over 1 year ago

  • Assignee changed from Junaid M to travvise Admin
Actions #3

Updated by Junaid M over 1 year ago

  • Status changed from New to Open
  • Assignee changed from travvise Admin to Aparna Mathew
  • % Done changed from 0 to 10

Updated by Junaid M over 1 year ago

Search Query

 SELECT master.pk_adm_or_acm_id, 
    master.sin_type, 
    master.fk_documents_id, 
    doc.vhr_document_no, 

    master.fk_supplier_id, 
    ac.vhr_account_code AS vhr_supplier_code,
    ac.vhr_account_name AS vhr_supplier_name,

    doc.dat_document, 

    master.fk_airline_master_id, 
    air.vhr_airline_code,
    air.vhr_airline_name,

    trans.vhr_ledg_currency, 
    trans.dbl_ledg_cur_debit, 
    trans.dbl_ledg_cur_credit, 
    trans.dbl_ledg_cur_outstanding,

    master.vhr_supplier_currency,
    master.dbl_supplier_cur_roe,
    master.dbl_supplier_cur_amount,
    master.dbl_supplier_base_amount

FROM admacm.tbl_adm_or_acm as master 
LEFT JOIN document.tbl_documents AS doc 
    ON doc.pk_documents_id = master.fk_documents_id 
LEFT JOIN transaction.tbl_transaction as trans 
    ON master.fk_documents_id = trans.fk_documents_id AND trans.sin_record_type IN (42, 43)
LEFT JOIN airticket.tbl_airline_master  AS air
    ON air.pk_airline_master_id = master.fk_airline_master_id
LEFT JOIN accounts.tbl_account  AS ac
    ON ac.pk_account_id = master.fk_supplier_id
WHERE  doc.int_sys_action_id != -1
AND doc.dat_document BETWEEN ? AND ?
AND doc.fk_branch_id = ? 
AND doc.fk_department_id = ?
AND master.fk_supplier_id = ?
AND doc.vhr_document_no = '?'
AND master.fk_airline_master_id = ?
AND doc.vhr_reference = '?'
AND (master.arj_tickets_data = '{}' OR EXISTS ( SELECT 1 FROM unnest(master.arj_tickets_data) AS json_data WHERE json_data->>'TICKET_NO' = '?'))
AND master.sin_type = ?

Actions #5

Updated by Aparna Mathew over 1 year ago

  • Status changed from Open to Coding Started
  • Start date changed from 02/25/2023 to 07/27/2023
  • % Done changed from 10 to 40
Actions #6

Updated by Aparna Mathew 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

  • Status changed from Coding Done to Reopen Bugs
  • % Done changed from 60 to 50
  • Tested By set to unnikannan S

ISSUE FOUNDED

1.SHOW DEPARTMENT COLUMN US BLANK
2.CONNECT MODULE WITH PRINT
3.INCREASE THE LENGTH OF GROUP BY CHOOSE BOX

Actions #8

Updated by Aparna Mathew 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.SHOWING AMOUNT US MATCHED IN GRID LIST

Actions #11

Updated by Aparna Mathew 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 70 to 50

ISSUE FOUNDED

1.SHOW MATCHED AMOUNT IN LIST
2.CORRECT SUPPLIER,AIRLINE DATAS IN PRINT

Actions #13

Updated by Aparna Mathew about 1 year ago

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

Updated by unnikannan S about 1 year ago

TESTING DONE

Updated by Avinash MS 8 months ago

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

GUI Change
------------------------------------------------------------------------------------
1) Add Customer filter (Under Airline Filter)
2) Apply LIKE query on Reference Number and Ticket No filter (Add ~ this symbol on to the filter)

ISSUE FOUNDED

1.Error While Unticking ADM/ACM Check Boxes And Search

Actions #16

Updated by Aparna Mathew 7 months ago

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

Updated by unnikannan S 5 months ago

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

ISSUE FOUNDED

1.Invalid Message While Selecting Period Directly After Clearing The Current Date

Actions #18

Updated by Aparna Mathew 5 months ago

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

Updated by unnikannan S 5 months ago

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

Updated by Arathy PS 3 months ago

  • Assignee changed from Aparna Mathew to Greeshma S
Edit Copy Actions

Also available in: Atom PDF