Feature #256
openHotel Productivity Report
Added by Anil KV over 1 year ago. Updated 6 months ago.
90%
Subtasks
Related issues
Updated by Anonymous over 1 year ago
- Assignee changed from travvise Admin to Karthika V Anand
Updated by Karthika V Anand over 1 year ago
- Status changed from New to Coding Started
- % Done changed from 0 to 40
Updated by Junaid M over 1 year ago
SELECT spd.pk_supp_doc_no_id, htlm.vhr_hotel_code, htlm.vhr_hotel_name, htlm.vhr_display_name, htl.sin_record_type, hfd.dbl_supplier_amount, hfd.dbl_normal_profit FROM service.tbl_supp_doc_no AS spd LEFT JOIN hotel.tbl_hotel_gen_data hotgen ON spd.pk_supp_doc_no_id = hotgen.fk_supp_doc_no_id LEFT JOIN hotel.tbl_hotel AS htl ON spd.pk_supp_doc_no_id = htl.fk_supp_doc_no_id LEFT JOIN service.tbl_supp_doc_fare AS hfd ON spd.fk_issue_base_fare_id = hfd.pk_supp_doc_fare_id -- Currecy inputbase Choose the field LEFT JOIN hotel.tbl_hotel_master AS htlm ON hotgen.fk_hotel_master_id = htlm.pk_hotel_master_id WHERE spd.sin_supp_doc_category = 2 AND spd.sin_last_action != -1 AND ((sin_record_type = 1 AND spd.dat_issue BETWEEN '2023-07-01' AND '2023-07-31' --Sales side AND spd.sin_sys_sale_side_status = 1 -- ... ) OR (sin_record_type = 2 AND spd.dat_cancel BETWEEN '2023-07-01' AND '2023-07-31' --Refund side where AND spd.sin_sys_refund_side_status IN (1,2) -- ... )) AND htl.fk_branch_id = ANY('{1,2}'::BIGINT[]) AND htl.fk_department_id = ANY('{1,2}'::BIGINT[]) AND hfd.vhr_currency = 'QAR' AND htl.fk_supplier_ac_id = ?
Consider where condition Refer -> Any SaleAndRefund Cs query code
Updated by Karthika V Anand over 1 year ago
- Status changed from Coding Started to Particialy Coding Done
Updated by Karthika V Anand over 1 year ago
- Status changed from Particialy Coding Done to Coding Done
- % Done changed from 40 to 60
Updated by Junaid M over 1 year ago
- Assignee changed from Karthika V Anand to Vivekp V
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 BASE 1 QAR WISE CHANGE IN AMOUNT FIELDS
Updated by Vivekp V over 1 year ago
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 60
ISSUE FIXED
1.SHOW BASE 1 QAR WISE CHANGE IN AMOUNT FIELDS
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 ONLY DATA FROM ISSUE MODULES NO DATA FROM OTHER HOTE SALE,CANCEL,REFUND,VOID MODULES
Updated by Vivekp V over 1 year ago
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 60
ISSUE FIXED
1.SHOWING ONLY DATA FROM ISSUE MODULES NO DATA FROM OTHER HOTE SALE,CANCEL,REFUND,VOID MODULES
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.ERROR WHILE SEARCHING CONSIDER OPTIONS WITH CANCEL/REFUND (ERROR SHOWING {})
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.ERROR WHILE SEARCHING CONSIDER OPTIONS WITH CANCEL/REFUND (ERROR SHOWING {})
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.MISSING AMOUNT IN LIST WHILE DIRECT CANCELLING A VOUCHER SHOWING COUNT ONLY
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.MISSING AMOUNT IN LIST WHILE DIRECT CANCELLING A VOUCHER SHOWING COUNT ONLY
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.CLEAR DELETED ACCOUNTS SHOWING IN UI FILTER FIELDS (SUPPLIER)
2.DISABLE RESET BUTTON IN CASE THERE IS NO DATA IS FOUND
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.CLEAR DELETED ACCOUNTS SHOWING IN UI FILTER FIELDS (SUPPLIER)
2.DISABLE RESET BUTTON IN CASE THERE IS NO DATA IS FOUND