Another day, another challenge
More than anything, I seeking a confirmation before I start changing anything
I have a fullcalender where I aim to schedule equipment rentals. eache rental can be one or more days, and I can have several rentals in the same day with different types of equipment, or the same type, depending what I have in stock each day.
I have several types of equipment with different quantitys in stock. So I have to check their availability before submitting the rental\event.
I have to mysql tables.
event (event_id, equipment_id, equipment_type_id, ... )
equipment_type (type_id, type, quantity, description, ....)
conectet by equipment_type_id ->type_id
Ideally I would like to have a dropdown\databasejoin of the types of equipment available for the date interval loaded by default with the form creation and when\if those dates are changed by the user, the types of equipment available are updated in the dropdown.
From what I've tried and researched I'm thinking the best (maybe only way) for me to do this would be to have a dropdown element (not a databasejoin) populated by some query, and in the date elements get some javascript code for the event "change" to somehow update the dropdown..
my thanks for any tips
More than anything, I seeking a confirmation before I start changing anything
I have a fullcalender where I aim to schedule equipment rentals. eache rental can be one or more days, and I can have several rentals in the same day with different types of equipment, or the same type, depending what I have in stock each day.
I have several types of equipment with different quantitys in stock. So I have to check their availability before submitting the rental\event.
I have to mysql tables.
event (event_id, equipment_id, equipment_type_id, ... )
equipment_type (type_id, type, quantity, description, ....)
conectet by equipment_type_id ->type_id
Ideally I would like to have a dropdown\databasejoin of the types of equipment available for the date interval loaded by default with the form creation and when\if those dates are changed by the user, the types of equipment available are updated in the dropdown.
From what I've tried and researched I'm thinking the best (maybe only way) for me to do this would be to have a dropdown element (not a databasejoin) populated by some query, and in the date elements get some javascript code for the event "change" to somehow update the dropdown..
my thanks for any tips