Project

General

Profile

Edit Copy Actions

Feature #256

open

Hotel Productivity Report

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

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

90%

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

Description

Coding Hotel Productivity Report


Add

Subtasks


Add

Related issues

Actions #1

Updated by Anil KV over 1 year ago

  • Assignee set to travvise Admin
Actions #2

Updated by Anonymous over 1 year ago

  • Assignee changed from travvise Admin to Karthika V Anand
Actions #3

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

Actions #5

Updated by Karthika V Anand over 1 year ago

  • Status changed from Coding Started to Particialy Coding Done
Actions #6

Updated by Karthika V Anand over 1 year ago

  • Status changed from Particialy Coding Done to Coding Done
  • % Done changed from 40 to 60
Actions #7

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

Updated by unnikannan S about 1 year ago

TESTING DONE

Updated by unnikannan S 12 months ago

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

ISSUE FOUNDED

1.FIX BUGS ON CONSIDER WISE SEARCHING
2.SHOWING ITEM COUNT AS 1 IN LIST WHILE SAVING A COPY OF A SAVED VOUCHER

Updated by Vivekp V 12 months ago

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

ISSUE FIXED

1.FIX BUGS ON CONSIDER WISE SEARCHING
2.SHOWING ITEM COUNT AS 1 IN LIST WHILE SAVING A COPY OF A SAVED VOUCHER

Actions #21

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