camper/verify/set_campsite_type_cost.sql

-- Verify camper:set_campsite_type_cost on pg

begin;

select has_function_privilege('camper.set_campsite_type_cost(uuid, integer, text, text, text, text)', 'execute');

rollback;
Add the campsite type cost per season 2023-10-01 19:14:39 +00:00			`-- Verify camper:set_campsite_type_cost on pg`

			`begin;`

Compute and show the “cart” for the booking form I have to ask number and age ranges of hosts of guests for all campsite types, not only those that have price options for adults, children, etc. because i must compute the tourist tax for adults. These numbers will be used to generate de rows for guests when actually creating the booking, which is not done already. To satisfy the campsite types that do have a price per guest, not only per night, i had to add the prices for each range in the campsite_type_cost relation. If a campsite type does not have price per person, then that should be zero; the website then does not display the price. The minimal price for any campsite type is one adult for one night, thus to compute the price i need at least the campsite type, the dates, and the number of adults, that has a minimum of one. I changed the order of the form to ask for these values first, so i can compute the initial price as soon as possible. To help further, i show the <fieldset>s progressively when visitors select options. 2024-02-04 05:37:25 +00:00			`select has_function_privilege('camper.set_campsite_type_cost(uuid, integer, text, text, text, text)', 'execute');`
Add the campsite type cost per season 2023-10-01 19:14:39 +00:00
			`rollback;`