30 lines
726 B
HTML
30 lines
726 B
HTML
{{* Vérifier la date de réservation
|
|
- loan_date
|
|
*}}
|
|
{{:assign loan_date=$loan_date|parse_date}}
|
|
{{#select
|
|
count(td_web.key) AS CNT
|
|
FROM !table AS td_web
|
|
WHERE ((:date BETWEEN $$.loan_date AND $$.return_date) AND $$.equipment={$equipment_key|strval})
|
|
;
|
|
!table=module_data_web
|
|
:date=$loan_date
|
|
}}
|
|
|
|
{{if $CNT>=1}}
|
|
{{:error message="La date indiquée est déjà réservée !"}}
|
|
{{/if}}
|
|
{{/select}}
|
|
{{#select
|
|
count(td_equ.key) AS CNT
|
|
FROM !table AS td_equ
|
|
WHERE ((:date BETWEEN $$.loan_date AND $$.return_date) AND $$.equipment={$equipment_key|strval})
|
|
;
|
|
!table=module_data_equipment
|
|
:date=$loan_date
|
|
}}
|
|
|
|
{{if $CNT>=1}}
|
|
{{:error message="La date indiquée est déjà réservée !"}}
|
|
{{/if}}
|
|
{{/select}} |