Project

General

Profile

Edit Copy Actions

Feature #236

open

Enquiry Report

Added by Anil KV over 1 year ago. Updated 6 months ago.

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

90%

Estimated time:
Owner(Agency):
Travvise
Time Taken(HH):
Module:
Enquiry Report
Tested By:
unnikannan S
Code Reviewed By:

Description

Coding Enquiry Report


Add

Subtasks


Add

Related issues

Actions #1

Updated by Anonymous over 1 year ago

  • Assignee changed from travvise Admin to Amal Pious
Actions #2

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 Junaid M over 1 year ago

SELECT 
    MIN(doc.vhr_document_no) AS vhr_document_no,
    MIN(doc.dat_document) AS dat_document,
    MIN(doc.vhr_reference) AS vhr_reference,
    MIN(doc.txt_remarks) AS txt_remarks,
    MIN(doc.fk_branch_id) AS fk_branch_id,
    MIN(br.vhr_branch_code) AS vhr_branch_code,
    MIN(br.vhr_branch_name) AS vhr_branch_name,
    MIN(qm.dat_valid_up_to) AS dat_valid_up_to,
    MIN(doc.fk_ledger_id) AS fk_ledger_id,
    MIN(qm.vhr_phone) AS vhr_phone,
    MIN(qm.vhr_email) AS vhr_email,
    MIN(qm.vhr_address) AS vhr_address,
    MIN(qm.sin_quotation_status) AS sin_quotation_status,
    MIN(qm.txt_cancel_reason) AS txt_cancel_reason,
    SUM(qd.dbl_price) AS dbl_price
FROM quotation.tbl_quotation_details AS qd
LEFT JOIN quotation.tbl_quotation_master AS qm
    ON qd.fk_quotation_master_id = qm.pk_quotation_master_id
LEFT JOIN document.tbl_documents AS doc
    ON qm.fk_documents_id = doc.pk_documents_id
LEFT JOIN organization.tbl_branch AS br
    ON doc.fk_branch_id = br.pk_branch_id
WHERE doc.int_sys_action_id != -1 
    AND vhr_sys_module_name = 'QUOTATION'
    AND doc.dat_document BETWEEN '?' AND '?'
    AND doc.fk_branch_id = ?
    AND doc.fk_department_id = ?
    AND qm.sin_quotation_status = ANY('.?.')
    AND doc.fk_ledger_id = ?
    AND qm.vhr_phone ILIKE '%%' || '?' || '%%' 
    AND doc.vhr_email ILIKE '%%' || '?' || '%%' 
    AND doc.vhr_address ILIKE '%%' || '?' || '%%' 
    AND doc.dat_document ILIKE '%%' || '?' || '%%' 
    AND doc.fk_sub_customer_id = ? / doc.fk_sub_ledger_id = ?
    AND doc.fk_responsible_user_id = ? / doc.fk_responsible_emp_id = ?
GROUP BY qd.fk_quotation_master_id
Actions #4

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.LOADING ERROR IN PRINT.

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.LOADING ERROR IN PRINT. - Fixed

Updated by Seema Mathew over 1 year ago

TESTING DONE

Actions #8

Updated by Anonymous 9 months ago

  • Assignee changed from Amal Pious to Greeshma S
Actions #9

Updated by Junaid M 9 months ago

  • Assignee changed from Greeshma S to Junaid M
Actions #10

Updated by Junaid M 9 months ago

  • Assignee changed from Junaid M to Greeshma S

Updated by unnikannan S 9 months ago

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

ISSUE FOUNDED

1.Fix Re-Direction

Actions #12

Updated by Greeshma S 9 months ago

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

Updated by unnikannan S 9 months ago

TESTING DONE

Actions #14

Updated by unnikannan S 6 months ago

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

Also available in: Atom PDF