Differences

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

--- todo [2019/11/07 10:59] – marco
+++ todo [2024/01/11 10:01] (current) – marco
@@ Line 3: / Line 3: @@
 ====== HotelDruid TODO ======
 <file>
-version 3.0.1 (people types completion)
--for extra costs as extra beds select if the discount of person type must be applied to the cost or not
+version 3.0.7 (version 3 completion)
--possibility to multiply extra costs by a person type (or multiple types, or exclude selected types) instead of total people
+-possibility to add a fixed price and a % price when importing rate prices, instead of only one of them (like extra costs)
--possibility for certain extra costs (that ask only by how much multiply, not associated to rates) to be shown as person type when inserting reservations (from hoteldruid and webpages) (only when person types enabled?) (modify fast insertion of "number of children" in "number of infants", with maximum number to be asked and price instead of discount)
+-possibility to import the fixed price from per person (and viceversa) when importing rate prices (insert discounts separately?)
--possibility to insert a reservation of the same type (and client) from the "modify reservation" page, also for deleted reservations
+-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 --)
--possibility to modify money paid by reservations not permanently deleted
+-when searching reservation number search also deleted reservations (if no reservation found?)
--save documents with names longer than 255 characters with a tag "extra" in the filename and insert reservation and client numbers in another file with same name and .dat extension (when document created or renamed in new year)
+-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 use a variable of the document as the name of the file when the document is downloaded (once the document is created store it in .dat file in case the document is opened from documents table)
+-possibility to view deleted reservations from documents API
--possibility to set taxes in cashbox payments (import taxes of extra cost from POS) (set a default for each cashbox?)
+-in documents API, when requesting reservation numbers, possibility (with modifier like &last_year_numbers=1? or add year before numbers 2022+3-5?) to view also reservations that had the requested number in previous year, before being imported (like done in top menu search)
--try to store taxes for each payment (if payment is partial pay before rate/discount and after extra costs, check previous payments to calculate already paid taxes) (or store for wich rate/extra costs have been used to create document?) (?)
+-fix bug: not possible to insert a reservation with multi-rooms rate with (not nearby) rooms with different max capacity (sometimes with number of people > minimum capacity x n. of rooms), also in check availability and templates (only 2nd step works)
--possibility to add taxes to extraordinary extra cost
+-in webpages, when asking number of people, calculate people of all rooms with multi-rooms rates in drop-down menus
--add an 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)
+-when inserting a reservation with a multiple rooms rate and number of people over the capacity, use "$diff_aggiungi_letti" like done in availability webpage to add extra beds only for exceeding number of people, not to all rooms (when insering a request of this type from availability webpage there is a price difference warning)
--in action 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?)
+-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)
--button to add predefined phrases in email documents where cursor is placed in the text (phrases added to all email documents or only current document from "modify document" page)
+-percentage deposit also on "rate + discount" and "rate + discount + extra costs non calculated on deposit" instead of only rate
--for agreements in webpages possibility to only show them (without having to be accepted) and to be already checked when needed
+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
+-possibility to choose (exclude?) pages where each document can appear
+-link the titular client with guests of the reservation even if he's not a guest himself
+-possibility to select "all rooms" or "all rooms from rate X" (or select rooms like rule 2) when inserting rule 1
+-possibility to select multiple rates when inserting rule 1 for rates
+-in rules 1 table possibility to group lines with rules that have same dates, type (room or rate) and/or motivation, with the link to modify all the rules in a group (if selected group has different motivations then omit motivation in modification, same with dates)
+-for availability page possibility to show available types at second step
+-show grouped (but not combined) costs also in webpages (possibility?)
+-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?)
+-in availability webpage possibility to select a separate dates list for departure dates (also possibility to select users for dates list)
+-for availability page for periods with multiple days add the option to display the first period of dates by separate days if the period has begun (also inside hoteldruid?)
+-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 add taxes to extraordinary extra cost (defaults to same taxes as reservation rate?)
+-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)
+-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 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.?)
+-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 sort payments history table and cashbox table by transaction and modification dates (besides insertion date)
+-button to add predefined phrases in email documents where cursor is placed in the text (javascript?) (phrases added to all email documents or only current document from "modify document" page)
+-for agreements in webpages possibility to only show them (without having to be accepted) and to be already checked when needed, also possibility to save them in a comment (to store cancellation policy at moment of booking for example)
 -for availability page add a line "other requests" between price and deposit when there are extra costs checked with 0 price
+-for web pages set a maximum height for logo in default themes css (keeping the proportions of the logo)
+-for web pages embed images in default themes (dates-picker, credit cards, etc.) in html with base64
 -for availability page enclose prices lines in a contaier with max-width and make it float right in default themes (add a button "modify dates" that sends back to first step?)
--for availability page add the minimum days (second date) that must be selected by default in the form (and also in javascript when changing dates?)
--for availability page for periods with multiple days add the option to display the first period of dates by separate days if the period has begun (also inside hoteldruid?)
 -possibility for webpages to change page to another language if the page in that language exists (store other languages filenames when page created) (only default themes? remove options with non-existing pages in html parts?)
 -possibility for predefined themes in webpages to set a link to background image (centered and adapted) for the page, make form semi-transparent in this case
--possibility to include (framed) internet pages with a javascript function (sample code when pages are generated, as for iframe) (wordpress plugin?)
+-in month table (also in modify reservation), when passing over a room name, show the maximum capacity of the room, comment and rates associated with rule 2
--check that there are no 2 same directories in directories where webpages are created (?)
+-in page to modify a reservation, when there are more reservations of the same client but not all with the exact same dates, show "all with same dates" (as current reservation) next to "all" in top line with links to other reservations
--when a directory for webpages is eliminated, delete all existing webpages in it (warning?)
+-deposit date as a limit to pay it (remove confirmation if date is past)
+-don't apply minimum stay from daily extra costs when applicable days are outside the selected periods for the cost (for ex. minimum stay only on arrival day with a cost 1 day yes and 10000 no, applicable on 1 day) (already works for weekdays)
+-in single rate table show correctly minimum stay from daily extra costs applied only to some weekdays
+-calendar to choose rooms also for lists of rooms when inserting or modifying a reservation
+-javasctipt in default themes to add a + and a - near numeric fields (class=inptunum), don't go below 1
 version 3.1 (multi-hotels enhancements)
+-privilege to view only some rooms (replaces current one based on assignment rule 2, with rule 1 still useful to select only some periods)
+-possibility to select only one group (also if user doesn't belog to it?) instead of all users' groups for each privilege in user privileges
+-with mysql/mariadb by default use aria storage engine (instead of myisam) if available when creating database (use "ALTER TABLE xxxx ENGINE=Aria" when upgrading?) (add "BEGIN" before lock tables and "COMMIT" after unlock)
 -possibility to select "always" as the period for rule 1
--possibility to select "all rooms" or "all rooms from rate X" (or select rooms like rule 2) when inserting rule 1
+-possibility to set rules 1 for units closures (currently not imported) as "recurring" (imported from year to year when adding periods) or as "once in a time"
 -in single rate table when clicking on availability select first date and last date to insert a new rule 1 (popup with motivation?) or if already grey offer to delete or modify (popup?) selected rule 1
--when periods are added also import assignment rules 1, dates in menus and periods of imported rates
+-possibility to change rate name in single rate table
--new privilege to make newly inserted motivations for rule 1 for conditional availability available to user or all his groups (check that user can't insert a motivation not allowed to him) (line below "insert rule 1" privilege) (if enabled allow user with not all rules 1 allowed to insert conditional rules 1, currently can't)
+-new privilege to make newly inserted motivations for rule 1 for conditional availability available to user or all his groups or one group (check that user can't insert a motivation not allowed to him) (line below "insert rule 1" privilege) (if enabled allow user with not all rules 1 allowed to insert conditional rules 1, currently can't)
--privilege to view only some rooms (replaces current one based on assignment rule 2, with rule 1 still useful to select only some periods)
 -privilege for users to add periods (show button at months end, 4 months missing in main menu, etc.)
--possibility to select only one group (also if user doesn't belog to it?) instead of all users' groups for each privilege in user privileges
+-possibility to set person types in rule 3 (if the user insering the reservations doesn't have that type, then insert as adult)
--minimum number of people for each rate (added to rule 3?)
+-possibility to make a rate incompatible with a person type (in rule 3?)
 -privilege to see only alredy inserted extra costs permitted to user (instead of all) when modifying a reservation (new line below extra costs privilege line with 2 options)
+-privilege to view in all reservations table only profiles from one group or none (instead of all groups of user)
 -show room as grey in rooms table if it's currently closed with rule 1
 -add interface for a module for gender guessing (gender.c --> gender executable, path in a costant?), select if enable only for secure matches or also "mostly X" in "conf and cust" (use it for default selection when inserting client/guest and also in interconnections and webpages if gender not asked)
--add global privileges to modify sections for year, reservations table, cashbox tables (totals?) and property data (add buttons "modify fo all" like done for people types and currencies)
+-add global privileges to modify "configure and customize" sections for year, reservations table, cashbox tables (totals?) and property data (add buttons "modify for all" like done for people types and currencies)
 -in privileges possibility to modify also remaining customizations "for his groups" or "for all" (in this case possibility to select customizations user from his groups or all users when creating webpages)
--guided insertion of a new rate: name - seasonal periods, prices, deposit, taxes and commissions (or import) - rule 2 - rule 3 - rule 1 (also import) - extra costs - users and rule 4 (?) - webpages - place in rates order
+-add "email2" (certified or PEC) to structure data and corresponding document variable
--possibility to use external smtp server instead of php mail() function in configure and customize (possible with imap functions? or only in php.ini with mail function?) (?)
+-for email documents possibility to send them to "email", "email2" and/or "email3" (also structure emails or custom/variable email and update "fattura elettronica"?)
--add a costant to limit the number of emails sent in last 24h if not using external smtp (?)
+-possibility to download an html document as a pdf with dompdf (if path is set in preferences or costanti.php) (possibility to enable [nome_documento_scaricato])
--for email documents possibility to send them to "email", "email2" and/or "email3" (also structure emails or custom email and update "fattura elettronica"?)
+-possibility (in "modify document" page) to check if another (saved) document exists and eventually create it when viewing/saving the document (xml invoice checks if html invoice exists? if multiple html exist use the last?) (?)
--email documents can be considered as API too and send email automatically when they are called (if not already sent?)
+-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)
--add a default API document with xml from OpenTravel Alliance to export reservations data
+-possibility to use a variable of the document as subject for email documents
+-possibility to use a custom smtp server for email documents, instead of default one (send from PEC for "send fattura elettronica" Italian document)
-version 3.1.1 (client data enhancements)
+version 3.2 (revenue management)
--possibility (in "modify document" page) to check if another (saved) document exists and eventually create it when viewing/saving the document (?)
+-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")
--add region of the province in default Italian regions code 3 (?)
+-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)
+-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.2.1 (client data enhancements)
+-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?)
 -upload a file (document photo, etc.: jpeg, jpg, gif, png, pdf, doc, docx, odt, rtf, txt,...) as document connected to a client or reservation, as it is already done from the documents table
 -possibility to show all client's documents in the page to modify client and all reservation documents in the page to modify reservations
 -possibility to overwrite a document with one uploaded from the documents table (or reservation/client page)
--client number in documents variables and do not show doubles in "export clients data" document
 -show client name in documents table (if client number is present)
--add "email2" (certified or PEC) to structure data and corresponding document variable
+-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
+-possibility to insert also issuing date for ID documents in clients data (also document variable)
--link the titular client with guests of the reservation even if he's not a guest himself (?)
+-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.2 (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 add an inventory item directly from the stockroom inventory (text box instead of drop-down menu)
@@ Line 73: / Line 140: @@
 -warning when an inventory item is added and there is already an existing item with the same name
 -possibility to import inventory from a stockroom or room to another stockroom or room or all rooms or rooms from a rate
+-when modifying inventory in a stockroom show categories on buttons (float left if enough screen space) to show only items in that category like done in pos, arrows to go at top or bottom of page (float right if enough space)
 -privileges to insert incomes and expenses but without deleting them
+-buy price per unit for inventory items, with possibility to change it and to subtract the amount from a cashbox when items added to inventory
 -check that default invoice documents work when called from point of sale: when inserting on reservation give the possibility (drop-down menu?) to show document only for inserted costs (default?), instead of all extra costs of reservation
 -add a "point of sale" receipt or invoice(?) with the list of extra costs and prices to default documents (error if reservation number is present)
@@ Line 82: / Line 151: @@
 -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?)
--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) (?)
--for users privileges possibility to select costs by category instead of single costs
+-when importing extra cost offer the possibility to add the new extra cost to existing webpages
--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)
--possibility to delete/add an inventory item from rooms at checkin, checkout or every day/week at a selected hour
--in rooms table possibility to assign a room to a (housekeeping) user (add also document variable and show in cleaning report)
--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
--document variable with comma separated list of items in unit inventory (and another with missing items) in units repetitions
 -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?)
+-amounts divided by payment methods and/or dates in cashboxes (pass selected dates also to document and also select dates in document API)
-version 3.2 (revenue management)
+-add categories to inventory items (each item one category, select by default this category if adding extra cost from inventory)
--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
+-possibility for extra costs to add inventory goods instead of only removing them (drop-down with "Delete items from" (current) and "Add items to" in modify cost page)
--add a "periodic actions" page, where you can set some actions (calling a document though the API and eventually sending the email, batch rate update, 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 to translate inventory items and categories in available languages
--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 icons (max LxH) and photos (both uploaded like rooms photos) to inventoty items
--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)
+-possibility in website pages to show items in categories selected when creating the page (for example "bedding") (show icon if present)
--add "checked-in" reservations to be selected from documents API
--possibility to import the fixed price from per person (and viceversa) and insert discounts separately on both when importing rate prices (also possibility to import a % and a fixed price)
--possibility to insert separately both a fixed and % value when importing rate prices
--optional "transaction date" for reservation payments, inserted by operator, different from "insertion date" (add document variable)
--optional "note" when inserting reservation payments (add document variable) (when viewing a document from cashboxes insert the payment name in the note variable)
--possibility to insert a payment id when inserting a reservation payment (add document variable)
--possibility to insert the number of people to be divided casually in selected rates when adding new types while inserting a reservation
@@ Line 112: / Line 167: @@
 -multicurrency: possibility to store prices of selected rates in a secundary currency (main currency calculated with current exchange rate). When a reservation is inserted using these rates use by default that currency for the reservation. Also interconnections.
 -multicurrency: possibility for reservations with secondary currency to convert to main currency at current exchage rate, deleting values in other currencies. Also from reservations table for all selected reservations that have different currency. (or only for payments?)
--encode email subjects with utf-8
+-possibility to show payments in default invoices (with exchange rate if payment in another currency)
--multilingual subjects in email documents
--possibility to modify subject before sending email
--possibility to attach a different file for each language to email documents in multi-language mode
--possibility to attach an html or txt document to email documents
 version 3.3.x
--alternative priority of units when there is an extra bed (order by priorita_lettoagg, priorita and use second letter in assegnazioneapp)
+-possibility to have incompatible rooms with combined extra costs (previously check if the cost will be affected by permitted periods and incompatible rates)
--link person types to specific guests and possibility to enforce requested age depending on person type (or give a warning)
+-when making check-in and the room has not been checked-out, if the reservation has multiple rooms then offer the possibility to try to move the reservation in a free room (move same day reservations that has not been checed-in yet?)
+-add age limits for person types and link person types to specific guests with possibility to enforce requested age depending on person type (or give a warning)
 -possibility to make costs as extra beds compatible only with some person types, so they are added automatically when searching availability only if that person type is requested
+-add possibility to make some person types incompatible with other person types (check also if there is alerady this person type in all "beds" in a "dorm" for assignment, modify liberasettimane or make these reservations fixed?) (for example for only male/female reservations in dorms)
 -add person types to statistics
--possibility to select years older than 5 in statistics (still limit to 5-7 years to be shown simultaneously)
--possibility to use "X days from current date" for "last available date" (and first date?) in periods when extra costs can be inserted (cancel possibility to assign cost when > or < days missing?) (?)
 -possibility for daily extra costs with specific days for not being applied to the last X days
 -possibility for daily extra costs with specific days for being applied only on day X of the reservation
@@ Line 132: / Line 183: @@
 -in check availability webpage (and instant and confirm) possibility to add custom html different for each step, just before the second part of custom html
 -check if normal user has privileges to manage password when viewing credit card and password has expired
+-multiple credit cards for each client (add cards from interconnections if number not present)
 -by default (or when not activated) subordination should import only current and future years
 -enable possibility to don't use password in download of email messages (ask it each time they are downloaded)
 -show exceptions to rule 2 in indicative availability overviews (main menu check, calendar and  availability webpage, single rate page)
--in single rate table show correctly minimum stay from daily extra costs applied only to some weekdays
 -possibility to modify rate name from single rate page (above rule 2?)
 -show week days when not grouping dates in single rate page
@@ Line 142: / Line 193: @@
 -add a line that explains how multiple selections work when clicking on a cell below the reservations table (and colors legend?) (before "back to main menu")
 -add a line in year section of "configure and customize" that explains that all dates can be shown by clicking the small apostrophes found near the drop-down menus (if not all dates selected and user being modified has privileges to modify customization)
--possibility to insert rule 1 for closure in periods where a rule 1 not for closure already exists
+-add a default API document with xml from OpenTravel Alliance to export reservations data
+-for each hoteldruid user give the possibility to delete privileges (or convert them to read-only) on previous year when a new year is created (this setting is imported between users with privileges or groups?)
+-cancellation policy for each rate: date of free cancellation (stored as deposit/commissions, also in reservation) (also document variable)
+-possibility to order reservations table by client surname
+-possibility to merge 2 clients, choosing wich one will overwrite the other when there are 2 different values (all past and current reservations will be assigned to the remaining client)
+-privilege to disable last active year of a user (if any) when a new year is created
+-when a reservation is moved from month table to one of its assigned units, offer also the possibility to remove previously occupied unit from assigned units list (between options to keep current list and fixed new unit)
+-possibility to show different colors for rows in month table depending on rates associated to room (only rates selected in "configure and customize") (combine colors if a room has more rates). Also possibility to group rooms by colors
+-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
+-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)
 version 3.4
 -if there is no availability for a minimum stay, then possibility to lower it to the maximum available period (consider periods when all rooms from rule 2 are occupied as limits for available periods)
+-possibility to block a day after or before the reservation (with extra cost or some rates?) (also useful for early check-in and late check-out?) (add the day before or after when using "tab_a_var" function)
 -late check-in and check-out option, blocking availability to normal check-in, also shown in month table (?) (configuration with 2 rooms, day and night, for each real room? --> assignment rule to book 1 room the first day and the other the last day of reservation)
--transition to html 5 from html 4.1
--optimize all pages for mobile view (viewport tag), also documents headers
 -leave first (and last?) column of month table (rooms column) fixed, letting the rest of the table move with x-overflow if the table is larger than the screen (also in mobile)
 -more space to click replicated buttons in mobile view
 -possibility to add directories where webpages are created form the first page of webpages creation
+-new graphical theme with lateral menu and dashboard in main menu
+-possibility for each user to use 2 different themes, one for mobile and one for desktop
+-when adding periods popssibility to import prices based on Easter (carnival, Chinese new year, etc.) dates (also for extra costs applied in periods?) (or for extra costs possibility to apply "them X days before/after Easter" or "X weekdays before Easter)
+-for rates, extra costs and extra costs categories possibility to set their name in each available language module, use these names as defaults when creating webpages
 version 3.4.1
 -truncate too long (old?) messages, with button to show the rest of the message
+-search messages with a string in their text or sender
 -when inserting prices daily or weekly, for rates with rule 2 that assigns multiple rooms, show the multiplied price with javascript
 -for blue and colors themes add icons when modifying a document, in users privileges and in interconnections
@@ Line 165: / Line 231: @@
 -when a room is added ask which extra costs (already incompatible with other rooms) it must be incompatible with, which rates it must be associated with rule2
 -when a rate is added ask which extra costs (already automatically assigned to some rates) it must be assigned automatically (with days and type), default deposit/commissions, rooms for rule2, which users (with only selected rates) enable, and if assignment rules 1 must be imported from another rate
--possibility to have incompatible rooms with combined extra costs (previously check if the cost will be affected by permitted periods and incompatible rates)
--when a webpage of the same kind is present in another language, give the possibility to change language
 version 3.4.2
--css/js to keep the first row on top when scrolling down the rates table (and first columns with horizontal scroll?) in simple theme (or possibility to show header row each X rows)
 -possibility to show pop-up with dates (between 2 different rows) and price when modifying prices in rates table (redirects to insert prices table)
 -css/js for colored box where prices have been modified when modifying prices in rates table
+-when modifying prices in rates table possibility to move between cells with arrows (set text box in cell where you move)
 -set unique ID for default documents (even across languages) and add the possibility to restore them. After upgrade offer the possibility to upgrade unmodified new ones (also all at once)
 -possibility to don't show past dates (months?) in availability calendar page
@@ Line 178: / Line 242: @@
 -possibility to save the bill for later payment in point of sale (associating it to a "POS unit": restaurant table)
 -possibility to view last X insertions in point of sale
--amounts divided by payment methods and/or dates in cashboxes (pass selected dates also to document and also select dates in document API)
 -option to don't import remaining amounts in cashboxes when creating new years
 -last row in cashbox tables to insert a new income or expense
 -possibility to subtract a cashbox income from another cashbox (as expense) when inserting it
+-when inserting in cashbox an income from reservation payments check that rest in reservations payments table doesn't go below zero
+-possibility to show documents from below the reservation payments history table
 -possibility to automatically insert the payment in a selected cashbox when a payment method is selected (overwrites user privilege if existing, so add a "if payment method has no cashbox" in privileges page)
 -possibility to automatically insert point of sale paid money in a specific cashbox in user privileges (already done for reservation payments, also extra costs?)
@@ Line 187: / Line 252: @@
 -add 3 letters nation codes to default values (at least in English for code 2 or 3?)
 -global privilege to don't allow to insert payments without payment method (when available, default on first inserted method?)
--possibility to delete a single payment in reservarions history table (with privileges)
+-possibility to delete a single payment in reservarions history table (with privileges) (remove the amount also from "transferred in cashbox" value if present? ask?)
 version 3.4.x
--view totals of selected reservations when modifying a group of reservations
 -fix values (tariffesettimanali, etc.) of reservations that begin in previous year in documents generated from month table or other pages that only pass reservations numbers
 -possibility for normal users to move other begun (not checkedin) reservations on "try again" if the initial date corresponds to current date
 -possibility to select dates for rule 1 in a calendar that also shows already inserted rules ("x" to delete them): blue color for motivations, red color for closures, red/blue stripes for both (with multiple rooms)
--possibility to select "all rates" when inserting deposits and commissions
 -possibility to use dates from a user instead of specific dates in website pages (?)
 -possibility to translate also the dates with "modify phrases" in website pages
@@ Line 205: / Line 268: @@
 -in rates webpage possibility to don't show costs with a value of 0 (minimum stay automatically added)
 -possibility to calculate extra costs on rate price without taxes
+-try to store taxes for each payment (if payment is partial pay before rate/discount and after extra costs, check previous payments to calculate already paid taxes) (or store for wich rate/extra costs have been used to create document?) (?)
 -in extra costs when options 5 (rates association), 6 (early booking/last miute) and 7 (multiple reservations) are selected choose if "or" or "and" should be user to combine these options (currently only "or") (also in special offer fast insertion)
 -possibility to sort extra costs (custom or alphabetically with categories?), also in web pages (already in point of sale)
--deposit date as a limit to pay it (remove confirmation if date is past?)
 -import also theme and language when customizations are imported from one user to another
 -mark the message as answered when sending email from messages table (or from check availability when the origin is messages table) (also on imap server?)
 -move documents selection from year privileges to global privileges
 -highlight current date in calendar to pick dates (when in current month) and in month table
--translate page titles in administrator language
 -better recognition of email data when downloading emails in messages: add language, origin (in conf&cust near each subject line), rate(?)
 -create reservation codes that don't change between years (create new progressive numbers for each year? when a first reservation for a future year new series starting from 1 is created)
--search also with reservation code when searching reservation number
 -call reservations also with reservation code (instead of number) from documents api
 -in api docuemnts check if with javascript history.replaceState() in page header (only when custom headers are not used?) it's possible to remove the password from browser history
@@ Line 222: / Line 283: @@
 -categories for incomes or expenses
 -show insertion date for items in inventory
--buy price per unit for inventory items, with possibility to subtract the amount from a cashbox when items added to inventory
 -possibility to merge 2 stockrooms, or overwrite one stockroom with another
 -possibility to compare 2 stockrooms
@@ Line 235: / Line 295: @@
 -average lenght of reservations in statistics
 -when inserting prices on daily basis, or in other series of dates, select next date in next row
--buttons in modify privileges that stay on top-right, but only in their year section (same with user selection in "configure ad customize")
 -use javascript also for costs that have inventory items in point of sale (js_array[stockroom][item_name] = items_number)
--new document fortmat: html to pdf (with dompdf, setting path in preferences?) (wkhtmltopdf from command line?) (?)
 -customization to automatically purge messages older than x months
 -possibility to sort payments table by surname, res. number, arrival or departure date
 -when typing 3 letters or more for nations, regions or cities in textboxs, offer to complete the word with xmlhttprequest
 -reservation comments to be shown only to some users or guests
--possibility to show payments in default invoices
 -possibility to show daily prices in default invoices
 -possibility to show totals of prices at a % of taxes (if [show_subtotal_invo]=1) in default invoices and do not show sub-total if only one item
 -for default invoices add a variable at the beginning of conditions to show/don't show only costs with a given % of taxes
 -possibility for taxes with decimals
+-possibility to show prices without taxes in webpages
+-possibility to calculate and add taxes when inserting prices in insertion page and tables
 -number of periods in first column of rates table
 -possibility to import photos and descriptions from one rate to another (checkbox added in import prices)
@@ Line 254: / Line 313: @@
 -privilege for deleting clients
 -use javascript (if available) when clicking on small link to show all dates in menus
--possibility to customize fields asked for guests when inserting a reservation
+-possibility to customize fields asked for guests (differentiate between principal and other guests) when inserting/modifying a reservation
+-possibility to use already inserted clients for guests (currently you have to make existsing guest titular, leaving original titular as guest, to link 2 existing clients)
+-add client comment, guests comments (in r2) and unit_comment (in r6) to document variables
 -show name (and/or value) of extra costs in group columns in reservations table
 -possibility for administrator to delete messages for all users
 -scoll the availability calendar website page also by day or week
--checked-in and checked-out in document variables
 -if a reservation that begins in the future is checked-in, show it in the main menu table (with error sign?)
 -warning when saving a document and there is a repetion variable outside its repetition
--possibility to choose pages where each document can appear
 -option to center the month table to today in month table by default (with javascript?)
 -option to disable (temporarily?) the capitalization of words in name, surname, street
@@ Line 267: / Line 326: @@
 -possibility to insert client from messages table (also a button to insert all clients)
 -when a reservation is inserted from a downloaded email, leave a link to the reservation in the message (like interconnections)
--as admin 2 options when no availability inserting a reservation: don't consider requested rooms or divide it between them (only 2nd for normal users)
 -in user privileges add "already ended" besides "already begun" to "possibility to modify reservations" (can't modify past days in extra costs if selected)
 -possibility to modify the receiving email with a document variable in documents in eamil format
@@ Line 274: / Line 332: @@
 -when creating availability webpage possibility to choose to show each extra cost at first or sencond step (if enabled)
 -in mobile view, when inserting/modifying a reservation, hide extra costs that can be added behind a button (javascript)
--button to delete all guests without a future reservation in the clients table
 -possibility to group beds (same name when removing suffix letter or number) in rooms table when inserting assignment rule 2
 -when creating new year automatically, before importing, extend the periods to the end of the new year if not already present
 -store backup file as compressed if gzwrite functions available (custom functions for fopen, fread, fwrite, fclose)
 -possibility to add "indicative availability overview" below month table (grouped wit rule 2 or number of people)
--move table background color from html to css in themes (css in header to keep color varible?) and set a blank backgrond for print media
+-move table background color from html to css in themes (css in header to keep color variable?) and set a blank backgrond for print media
 -possibility to give a name to periods in rates table (also custom color?)
 -when administrator modifies the name of a document offer the possibility to modify it for all users if only admin selected
@@ Line 286: / Line 343: @@
 -half hours in server offset time
 -manual page in html (in doc folder) about editing documents: document types, default variables description, repetitons description, custom variables and conditions
--explanation of rules in rules table
 -if a rate has no prices in any period then show also the "per person" input when clicking on rates table and single rate table
 -before modifying the comment in multiple reservations add the phrase "comments in all selected reservations will be replaced with new comment"
--calendar to choose rooms also for lists of rooms when inserting or modifying a reservation
--possibility to show grouped costs (insetad of only combined) also in webpages
--with mysql/mariadb by default use aria storage engine (instead of myisam) if available when creating database (use "ALTER TABLE xxxx ENGINE=Aria" when upgrading?) (add "BEGIN" before lock tables and "COMMIT" after unlock)
 -possibility to merge 2 different clients (one client will be the principal and only his empty fileds will be overwritten by the other)
 -new default document that shows selected resevations as they are shown in default reservations table
--show the room comment when passing over the room name in month table and "modify reservation" page
+-show client data when passing over the client surname in reservations table (with xhttp?)
--add client comment to document variables
+-possibility to search by insertion date instead of arrival/departure in reservations table
 -from docuemnts table possibility to download a batch of saved documents from number to number (zipped together?)
 -in availability page possibility for a discount for clients with past reservations (check email/telephone for existing client)
+-in availability page possibility to show name before surname (or choose all fields order)
+-possibility to define a default (selected or first in list) nation, region, city, document type, relatedness (or possibility to change their order)
+-when a city (or region, nation, etc.) is added and it already exists in another region, show a warning with the current region
+-add a list of default titles when database is created (Mr,Mrs,Company Name) like default nations list (and make default documents use these titles)
+-possibility to insert client title when inserting a reservation and a client
+-if available use phpmailer also for emails downloaded in messages page
@@ Line 314: / Line 373: @@
 -when possible assign automatically the extra cost if rate price (or rate - discount?) is > or < of X
 -possibility to select a combined extra cost in website pages as the extra beds cost
--customize fields to be asked for titular client, first guest and other guests
+-button to delete all guests without a future reservation in the clients table
--possibility to define a default (selected or first in list) nation, region, city, document type, relatedness (or possibility to change their order)
 -optimize reservations distribution when a reservation is deleted (?)
 -say if there are unconfirmed reservations when checking and there is no availability
@@ Line 338: / Line 396: @@
 -possibility to auto-refresh month table
 -auto select (or suggest) the amount of paid money - trasferred in cashbox as default when inserting entrances (?)
--show also the page from where the query was made in logs
+-show also the page from where the query was made and user IP address in logs
 -possibility to reserve a "POS unit" (restaurant table) with day and hour
 -show reserved "POS units" (restaurant tables) for a specific day/hour in a table
 -document variable with the sum of all taxes (and sum of all prices without taxes?) (calculate it only if these variables are in document text or coditions)
--room description when passing over room name in month table
 -cash given (with return to be given back) in point of sale
 -numerical keyboard for the cahbox (usable in touch sceen)
@@ Line 351: / Line 408: @@
 -possibility to import reservations from a csv or xml file (use a document for format? or fixed format?) (use functions used in interconnections downloads)
 -possibility to import (again) prices/restrictions from past periods also when the periods have already been added
+.0
+-new Italian default documents for regional statistics (E. Romagna, Sardegna, Lombardia, Piemonte, Marche, Abruzzo, Basilicata, Calabria?)
@@ Line 368: / Line 429: @@
 -client data in all reservations table
 -possibility to set an ip access list for login
--possibility to generate javascript dates menus in website pages
 -if room(s) requested and rate with rule 2, use rule 2 in second try when inserting reservations(?)
 -test speed of changing switch/case with array in mex function
@@ Line 374: / Line 434: @@
 -other tables customization
 -pass settings stored in website pages in the database
--possibility to use already inserted clients for guests
 -rates priority
 -possibility to change the order of columns in all reservations table
@@ Line 382: / Line 441: @@
 -day table with graphical layout of rooms, showing occupied ones
 -possibility for administrator user to change inserting user when inserting a reservation
--possibility for extra costs to add inventory goods instead of only removing them (or moving them from a room/stockroom to another one)
--search clients also by fiscal code
 -help on line
 </file>