HotelDruid Wiki

User Tools

Site Tools

Trace:
todo

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
todo [2023/11/04 06:12] – marcotodo [2024/01/11 10:01] (current) – marco
Line 5: Line 5:
  
 version 3.0.7 (version 3 completion) version 3.0.7 (version 3 completion)
--possibility to modify money paid by reservations not permanently deleted 
 -possibility to add a fixed price and a % price when importing rate prices, instead of only one of them (like extra costs) -possibility to add a fixed price and a % price when importing rate prices, instead of only one of them (like extra costs)
 -possibility to import the fixed price from per person (and viceversa) when importing rate prices (insert discounts separately?) -possibility to import the fixed price from per person (and viceversa) when importing rate prices (insert discounts separately?)
 +-for email documents in HTML format possibility to have also "HTML multipart" format (new field "boundary" with default random value of 26 characters a-zA-Z0-9 (at least 12), below show "boudaries in email body" with opening -- and "closing boundary" with opening and closing --)
 -when searching reservation number search also deleted reservations (if no reservation found?) -when searching reservation number search also deleted reservations (if no reservation found?)
 -possibility to delete also clients with deleted reservations in past years (deleting also these reservations) from table with all clients (at second step checkbox with "Delete also XXX clients (and their reservations) that have only deleted reservations in past years") -possibility to delete also clients with deleted reservations in past years (deleting also these reservations) from table with all clients (at second step checkbox with "Delete also XXX clients (and their reservations) that have only deleted reservations in past years")
Line 17: Line 17:
 -add query with prepared statements to database functions and begin to transfer queries (at least the ones before login) with parameters to prepared statements (if prepared statements funcions not available, use normal query in new functions) (remove aggslashdb from parameters) -add query with prepared statements to database functions and begin to transfer queries (at least the ones before login) with parameters to prepared statements (if prepared statements funcions not available, use normal query in new functions) (remove aggslashdb from parameters)
 -percentage deposit also on "rate + discount" and "rate + discount + extra costs non calculated on deposit" instead of only rate -percentage deposit also on "rate + discount" and "rate + discount + extra costs non calculated on deposit" instead of only rate
 +
 +
 +version 3.0.8 (version 3 completion)
 -for documents (not email) possibility to call an external URL at check-in or check-out (even if not saved), send document text as value of (default) parameter "checkin_text" or "checkout_text" (option to choose GET or POST connection). Save page respone OK/FAIL (set a string that response must contain or not contain for OK?) and show it near checkin date, so checkin/checkout can be cancelled and done again if connection fails -for documents (not email) possibility to call an external URL at check-in or check-out (even if not saved), send document text as value of (default) parameter "checkin_text" or "checkout_text" (option to choose GET or POST connection). Save page respone OK/FAIL (set a string that response must contain or not contain for OK?) and show it near checkin date, so checkin/checkout can be cancelled and done again if connection fails
 -possibility to choose (exclude?) pages where each document can appear -possibility to choose (exclude?) pages where each document can appear
Line 25: Line 28:
 -for availability page possibility to show available types at second step -for availability page possibility to show available types at second step
 -show grouped (but not combined) costs also in webpages (possibility?) -show grouped (but not combined) costs also in webpages (possibility?)
--in webpages possibility to use a combined cost as extra bed+-in webpages possibility to use a combined cost as extra bed (if all combined costs are extra beds?)
 -possibility to include (framed) internet pages with a javascript function (sample code when pages are generated, as for iframe). In framed mode add html (without head and foot) to js variable instead of echo it, then set that variable as innerHTML of div with id "first_step", so example will be that div followed by js script tag that calls framed+js page (wordpress plugin?) -possibility to include (framed) internet pages with a javascript function (sample code when pages are generated, as for iframe). In framed mode add html (without head and foot) to js variable instead of echo it, then set that variable as innerHTML of div with id "first_step", so example will be that div followed by js script tag that calls framed+js page (wordpress plugin?)
 -in availability webpage possibility to select a separate dates list for departure dates (also possibility to select users for dates list) -in availability webpage possibility to select a separate dates list for departure dates (also possibility to select users for dates list)
Line 31: Line 34:
 -possibility to use "X days from current date" for first date and/or last date in periods when extra costs can be inserted (don't consider the period if first date bigger than last date, use first or last database date if current date before or after available dates) (for example, minimum stay not applied in first X days from now) -possibility to use "X days from current date" for first date and/or last date in periods when extra costs can be inserted (don't consider the period if first date bigger than last date, use first or last database date if current date before or after available dates) (for example, minimum stay not applied in first X days from now)
 -possibility to make an extra cost incompatible with other extra costs (modify also the other extra cost to add/remove incompatibility) (same restrictions as rate incopatibilities) -possibility to make an extra cost incompatible with other extra costs (modify also the other extra cost to add/remove incompatibility) (same restrictions as rate incopatibilities)
- 
- 
-version 3.0.8 (version 3 completion) 
 -possibility to add taxes to extraordinary extra cost (defaults to same taxes as reservation rate?) -possibility to add taxes to extraordinary extra cost (defaults to same taxes as reservation rate?)
 -privilege to add extraordinary extra cost when modifying a reservation -privilege to add extraordinary extra cost when modifying a reservation
 +-possibility to set taxes in cashbox payments (import taxes of extra cost from POS, set a default for each cashbox) (add document variables for [r5], defined only from cashbox?)
 +
 +
 +version 3.0.9 (version 3 completion)
 -add an "actions API" section in interconnections page, where you can enable the API to receive calls to add an extraordinary extra cost to a currently checked-in (or present) reservation (example of URL with cost data, room number and passphrase) -add an "actions API" section in interconnections page, where you can enable the API to receive calls to add an extraordinary extra cost to a currently checked-in (or present) reservation (example of URL with cost data, room number and passphrase)
 -in actions API possibility to modify quantity of an existing item in stockroom or room: send room number, item code (multiple updates if multiple items with same code, error if code not found) and new quantity (show old quantity in response?) -in actions API possibility to modify quantity of an existing item in stockroom or room: send room number, item code (multiple updates if multiple items with same code, error if code not found) and new quantity (show old quantity in response?)
 -in actions API possibility to set check-in and check-out for a reservation in a given room or with a given number (possibility to activate "sposta_per_checkin" when needed? do all steps in one in this case?) -in actions API possibility to set check-in and check-out for a reservation in a given room or with a given number (possibility to activate "sposta_per_checkin" when needed? do all steps in one in this case?)
 +-in actions API possibility to modify price of a (not imported) rate: send rate number, start and end date and new price (update imported rates) (possibility to show in messages table)
 -document variable with comma separated list of items in unit inventory (and another with missing items) in units repetitions (and the list for current room in reservations repetition? and also occupied_unit_floor, occupied_unity_capacity, etc.?) -document variable with comma separated list of items in unit inventory (and another with missing items) in units repetitions (and the list for current room in reservations repetition? and also occupied_unit_floor, occupied_unity_capacity, etc.?)
--possibility to set taxes in cashbox payments (import taxes of extra cost from POS, set a default for each cashbox) (add document variables for [r5], defined only from cashbox?) 
 -modify notes, payment method (?) and transaction date in payments history table and payment method, transaction date in cashbox table -modify notes, payment method (?) and transaction date in payments history table and payment method, transaction date in cashbox table
 -possibility to choose columns of payments history table and cashbox table in "configure and customize" -possibility to choose columns of payments history table and cashbox table in "configure and customize"
Line 85: Line 89:
 -possibility to attach one or more saved documents to email documents with condition "[add_saved_document_as_attachment] = 1" inside document repetitions (if present use download name as name of attached file) -possibility to attach one or more saved documents to email documents with condition "[add_saved_document_as_attachment] = 1" inside document repetitions (if present use download name as name of attached file)
 -possibility to use a variable of the document as subject for email documents -possibility to use a variable of the document as subject for email documents
--email documents can be considered as API too and send email automatically when they are called (use manda_mail() instead of displaying textarea) (add new Italian document to send "fattura elettronica" from cron job, attached filename in subject and repetition_error if file older than few days or "email_already_sent") 
 -possibility to use a custom smtp server for email documents, instead of default one (send from PEC for "send fattura elettronica" Italian document) -possibility to use a custom smtp server for email documents, instead of default one (send from PEC for "send fattura elettronica" Italian document)
--add a "periodic actions API" page, where you can set some actions (calling a document though the API and eventually sending the email, update subordination, etc.) to be carried out when the page is called, for example from a cron job (constant to show the times when page is called) 
  
  
-version 3.1.1 (housekeeping) +version 3.2 (revenue management) 
--in rooms table possibility to assign a room to a (housekeeping) user with days schema (all days, only some week-days or manually selected days with today selected by default) (add also default document variable or dates array and show in cleaning report) +-email documents can be considered as API too and send email automatically when they are called (use manda_mail() instead of displaying textarea) (add new Italian document to send "fattura elettronica" from cron job, attached filename in subject and repetition_error if file older than few days or "email_already_sent") 
--in rooms table set a mantainace list, each task can be assigend to a user (add a variable with the list in units repetitions in documents)  +-add a "periodic actions API" page, where you can set some actions (calling a document though the API and eventually sending the email, update subordination, etc.) to be carried out when the page is called, for example from a cron job (constant to show the times when page is called) 
--possibility for extra costs to be added automatically at check-in and/or check-out (instead of associated rates at insertion or modification) (like done for "sposta_per_checkin" add a step in the modification block)+-rates batch update: add x ($ or %) to prices (also from other rates) daily or weekly, based on dates and availability, with possibility to save it 
 +-add batch update to periodic actions API 
 +-possibility to delete/add an inventory item from rooms every day/week at a selected hour, or everyday and only perform the action if a selected daily cost is present on that day in the reservation for each room 
 +-add "checked-in" reservations to be selected from documents API 
 +-possibility to insert the number of people to be divided casually in selected rates when adding new types while inserting a reservation 
 +-when a new year is created store the number of units of previous year (and their names? each room double, so the first one can be updated when room name changed) (in years table?), so afterwards statistics (occupancy percentages) can be calculated on that number (when statistics are generated check the number of different rooms of reservations in that year, use higher number between this one and stored one) and show old room name in reservations of that year: "new name" (ex "old name") 
 +-new table in statistics with daily average price of all selected rates per month 
 +-alternative priority of units when there is an extra bed (order by priorita_lettoagg, priorita and use second letter in assegnazioneapp) 
 +-view total of all reservations (price before, after, balance) when modifying a group of reservations 
 +-guided insertion of a new rate: name - place in rates order - seasonal periods, prices, deposit, taxes and commissions (or import) - rule 2 - rule 3 - rule 1 (also import) - extra costs - users and rule 4 (?) - webpages (or see all these steps from single rate table, redirect to it when adding a new rate)
  
  
-version 3.1.2 (client data enhancements)+version 3.2.1 (client data enhancements)
 -add region of the province in code 3 of default Italian regions -add region of the province in code 3 of default Italian regions
 -possibility to save documents linked to clients, as it's done for reservations (add client number also to documents saved for reservations?) -possibility to save documents linked to clients, as it's done for reservations (add client number also to documents saved for reservations?)
Line 105: Line 116:
 -possibility to select documents between dates in documents table and possibility to download a compressed zip with all documents shown in table -possibility to select documents between dates in documents table and possibility to download a compressed zip with all documents shown in table
 -possibility to insert also issuing date for ID documents in clients data (also document variable) -possibility to insert also issuing date for ID documents in clients data (also document variable)
 +-show custom client fields when showing data of client when inserting or modifying a reservation
 +-possibility to use autocomplete when inserting cities, regions, contries, etc of guests (first field of drop-down menu with text to search?)
 +
 +
 +version 3.2.2 (housekeeping)
 +-in rooms table possibility to assign a room to a (housekeeping) user with days schema (all days, only some week-days or manually selected days with today selected by default) (add also default document variable or dates array and show in cleaning report)
 +-in rooms table set a mantainace list, each task can be assigend to a user (add a variable with the list in units repetitions in documents) 
 +-possibility for extra costs to be added automatically at check-in and/or check-out (instead of associated rates at insertion or modification) (like done for "sposta_per_checkin" add a step in the modification block)
 +-possibility to delete/add an inventory item from rooms at checkin, checkout or every day/week at a selected hour
 +-possibility to add (and remove?) existing extra costs, room inventory goods and client/guests data (scanned documents) to current reservations from the interconnections API (called with room name for currently present or checked-in reservation)
 +-for users privileges possibility to select costs by category instead of single costs
 +-new privilege to show only reservations and/or rooms that are assigned as "housekeeping" to the user (similar to rooms shown only in rule 1)
 +-fast insertion of a "housekeeping" user (can only modify housekeeping category costs and change "clean" inventory in rooms, show user to be associated to rooms in rooms table)
 +-add comment to default cleaning report (first condition of the report to enable it, with text on which condition must be modified to replace the reservation comment with a custom comment)
 +-add past arrival date and future departure date to cleaning report (and rename it to "housekeeping report")
  
  
-version 3.1.3 (point of sale functionalities)+version 3.2.3 (point of sale functionalities)
 -possibility to delete the associated extra cost(s) when deleting an item from a stockroom inventory -possibility to delete the associated extra cost(s) when deleting an item from a stockroom inventory
 -possibility to add an inventory item directly from the stockroom inventory (text box instead of drop-down menu) -possibility to add an inventory item directly from the stockroom inventory (text box instead of drop-down menu)
Line 125: Line 151:
 -for mobile select alternative lenght for names in month table -for mobile select alternative lenght for names in month table
 -for mobile select initial zoom in point of sale and month table (initial-scale from 0.5 to 1.5, default 0.8) (value saved in dati/temi.php?) -for mobile select initial zoom in point of sale and month table (initial-scale from 0.5 to 1.5, default 0.8) (value saved in dati/temi.php?)
--show custom client fields when showing data of client when inserting or modifying a reservation 
 -fast extra cost insertion for "housekeeping" (cleaning) costs (insert also inventory items in rooms needed for checkin) (?) -fast extra cost insertion for "housekeeping" (cleaning) costs (insert also inventory items in rooms needed for checkin) (?)
 -when importing extra cost offer the possibility to add the new extra cost to existing webpages -when importing extra cost offer the possibility to add the new extra cost to existing webpages
--for users privileges possibility to select costs by category instead of single costs 
--possibility to delete/add an inventory item from rooms at checkin, checkout or every day/week at a selected hour 
--new privilege to show only reservations and/or rooms that are assigned as "housekeeping" to the user (similar to rooms shown only in rule 1) 
--fast insertion of a "housekeeping" user (can only modify housekeeping category costs and change "clean" inventory in rooms, show user to be associated to rooms in rooms table) 
--add comment to default cleaning report (first condition of the report to enable it, with text on which condition must be modified to replace the reservation comment with a custom comment) 
--add past arrival date and future departure date to cleaning report (and rename it to "housekeeping report") 
 -when showing numer of days in "all reservations" table, show the sum in the "total" line -when showing numer of days in "all reservations" table, show the sum in the "total" line
 -when a cost has been added in cashbox from pos, hitting reload should not insert it again (show warning?) -when a cost has been added in cashbox from pos, hitting reload should not insert it again (show warning?)
Line 142: Line 161:
 -possibility to add icons (max LxH) and photos (both uploaded like rooms photos) to inventoty items -possibility to add icons (max LxH) and photos (both uploaded like rooms photos) to inventoty items
 -possibility in website pages to show items in categories selected when creating the page (for example "bedding") (show icon if present) -possibility in website pages to show items in categories selected when creating the page (for example "bedding") (show icon if present)
- 
- 
-version 3.2 (revenue management) 
--rates batch update: add x ($ or %) to prices (also from other rates) daily or weekly, based on dates and availability, with possibility to save it 
--add batch update to periodic actions API 
--possibility to delete/add an inventory item from rooms every day/week at a selected hour, or everyday and only perform the action if a selected daily cost is present on that day in the reservation for each room 
--possibility to add (and remove?) existing extra costs, room inventory goods and client/guests data (scanned documents) to reservations from the interconnections API (called with room name for currently present or checked-in reservation) 
--add "checked-in" reservations to be selected from documents API 
--possibility to insert the number of people to be divided casually in selected rates when adding new types while inserting a reservation 
--when a new year is created store the number of units of previous year (and their names? each room double, so the first one can be updated when room name changed) (in years table?), so afterwards statistics (occupancy percentages) can be calculated on that number (when statistics are generated check the number of different rooms of reservations in that year, use higher number between this one and stored one) and show old room name in reservations of that year: "new name" (ex "old name") 
--new table in statistics with daily average price of all selected rates per month 
--alternative priority of units when there is an extra bed (order by priorita_lettoagg, priorita and use second letter in assegnazioneapp) 
--view total of all reservations (price before, after, balance) when modifying a group of reservations 
--guided insertion of a new rate: name - place in rates order - seasonal periods, prices, deposit, taxes and commissions (or import) - rule 2 - rule 3 - rule 1 (also import) - extra costs - users and rule 4 (?) - webpages 
  
  
Line 198: Line 203:
 -for documents as API possibility to send them, besides check-in and check-out, also at reservation insertion (also interconnections and webpages), modification or cancellation (also for documents automatically created) -for documents as API possibility to send them, besides check-in and check-out, also at reservation insertion (also interconnections and webpages), modification or cancellation (also for documents automatically created)
 -new variable C_FILE_JS_PERS (and C_FILE_MOB_JS_PERS?) in includes/costanti.php to load a custom javascript file in the foot.php of the theme -new variable C_FILE_JS_PERS (and C_FILE_MOB_JS_PERS?) in includes/costanti.php to load a custom javascript file in the foot.php of the theme
 +-in actions API possibility to insert a new reservation: send rate number, start and end date, client data and (optional, if authorized) total price (show if reservation inserted correctly) (show in messages table)
 +-in actions API possibility to cancel a reservation: send reservation number (show if reservation deleted correctly) (show in messages table)
  
  
todo.txt · Last modified: 2024/01/11 10:01 by marco