Difference between revisions of "Reports"
(Created page with "TODO") |
|||
| (7 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| − | + | ||
| + | ==Report 09 - “Room occupancy"== | ||
| + | |||
| + | Taking data from the database for reservations | ||
| + | |||
| + | Data returned is '''all reservations except''' the ones with status | ||
| + | |||
| + | (2) "New From Channel", (7) "Cancelled Confirmed", (8) "Cancelled Tentative", (9) "No Show" & (11) "Cancelled Confirmed" | ||
| + | |||
| + | Also from the data are excluded reservations with room types that are marked as '''excluded from occupancy''' (e.g. parking room type) and reservations with rooms that have maintenance status different than 0. | ||
| + | |||
| + | ---- | ||
| + | |||
| + | |||
| + | == Report 55 - “Booking agencies share for period” == | ||
| + | |||
| + | |||
| + | Choosing on which dates should the report to based on (arrival date, departure date, reservation date) | ||
| + | Taking data from the database | ||
| + | Data returned is all reservations based on the condition chosen from the 1st step | ||
| + | |||
| + | '''arrival''' - the date from to be between chosen dates | ||
| + | |||
| + | '''departure''' - the date to to be between chosen dates | ||
| + | |||
| + | '''reservation''' - the actual reservation date to to be between chosen dates | ||
| + | |||
| + | ---- | ||
| + | |||
| + | |||
| + | == Report 72 - “Reservations per booking agency for period” == | ||
| + | |||
| + | |||
| + | Choosing on which dates should the report to based on (arrival date, departure date, reservation date) | ||
| + | Taking data from the database | ||
| + | Data returned is '''all reservations''' ((includes the cancelled reservations) there is flag sent to take all comparing with report 101 which excludes the cancelled ones) based on the condition chosen from the 1st step | ||
| + | |||
| + | '''arrival''' - the date from to be between chosen dates | ||
| + | |||
| + | '''departure''' - the date to to be between chosen dates | ||
| + | |||
| + | '''reservation''' - the actual reservation date to to be between chosen dates | ||
| + | |||
| + | ---- | ||
| + | |||
| + | |||
| + | == Report 101 - “Reservations per booking agency for period v.2” == | ||
| + | |||
| + | |||
| + | Choosing on which dates should the report to based on (arrival date, departure date, reservation date) | ||
| + | Taking data from the database | ||
| + | Data returned is '''all reservations''' (excludes the cancelled ones) based on the condition chosen from the 1st step | ||
| + | |||
| + | '''arrival''' - the date from to be between chosen dates | ||
| + | |||
| + | '''departure''' - the date to to be between chosen dates | ||
| + | |||
| + | '''reservation''' - the actual reservation date to to be between chosen dates | ||
Latest revision as of 17:20, 14 August 2020
Contents
Report 09 - “Room occupancy"
Taking data from the database for reservations
Data returned is all reservations except the ones with status
(2) "New From Channel", (7) "Cancelled Confirmed", (8) "Cancelled Tentative", (9) "No Show" & (11) "Cancelled Confirmed"
Also from the data are excluded reservations with room types that are marked as excluded from occupancy (e.g. parking room type) and reservations with rooms that have maintenance status different than 0.
Choosing on which dates should the report to based on (arrival date, departure date, reservation date) Taking data from the database Data returned is all reservations based on the condition chosen from the 1st step
arrival - the date from to be between chosen dates
departure - the date to to be between chosen dates
reservation - the actual reservation date to to be between chosen dates
Report 72 - “Reservations per booking agency for period”
Choosing on which dates should the report to based on (arrival date, departure date, reservation date) Taking data from the database Data returned is all reservations ((includes the cancelled reservations) there is flag sent to take all comparing with report 101 which excludes the cancelled ones) based on the condition chosen from the 1st step
arrival - the date from to be between chosen dates
departure - the date to to be between chosen dates
reservation - the actual reservation date to to be between chosen dates
Report 101 - “Reservations per booking agency for period v.2”
Choosing on which dates should the report to based on (arrival date, departure date, reservation date) Taking data from the database Data returned is all reservations (excludes the cancelled ones) based on the condition chosen from the 1st step
arrival - the date from to be between chosen dates
departure - the date to to be between chosen dates
reservation - the actual reservation date to to be between chosen dates
