Feature #236
openEnquiry Report
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:
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 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
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 Greeshma S 9 months ago
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 70