I just started messing around with the built-in web2cal component, have it working with the auto-generated tables (mssql) but I am a little confused about how to best set up my table structures and all and have a few questions...
I am trying to build a reservation system for a company that manages vacation rental homes, so each property will need a calendar to manage its reservations. Properties can be blocked out for periods of time for use by the owners, it seems web2cal has an extension to help with this but my question is can I then generate a report showing occupied nights vs available nights (periods blocked by owner should not count as available)? Or would I need to do it as 2 different types of events, one for available nights and one for occupied nights (reservations)?
Next, each reservation has an associated move-in clean, move-out clean, and weekly maid service if the stay is longer than a week. Each of those cleans can be assigned to one or mutliple housekeepers.
From the property calendar I need to be able to see the reservations and cleans for that property, but I also want to be able to view and edit the cleaning appointments grouped by employee so their daily schedules can be managed.
Sounds like I need a join table or maybe a way to turn the group field into a dynamic calculated result or even a combination of the two but I am not sure how to wire up a join table to work with the calendar and event tables. I am thinking the event ID would then be the group field and the join records would join the event id with employee IDs and property ID. All my IDs are UUIDs so I don't think it is a problem mixing two of my tables and the events table into a single join table but I am thinking the calendar probably needs the real group field.
Anyone tackle this or am I going about this all wrong?
I am trying to build a reservation system for a company that manages vacation rental homes, so each property will need a calendar to manage its reservations. Properties can be blocked out for periods of time for use by the owners, it seems web2cal has an extension to help with this but my question is can I then generate a report showing occupied nights vs available nights (periods blocked by owner should not count as available)? Or would I need to do it as 2 different types of events, one for available nights and one for occupied nights (reservations)?
Next, each reservation has an associated move-in clean, move-out clean, and weekly maid service if the stay is longer than a week. Each of those cleans can be assigned to one or mutliple housekeepers.
From the property calendar I need to be able to see the reservations and cleans for that property, but I also want to be able to view and edit the cleaning appointments grouped by employee so their daily schedules can be managed.
Sounds like I need a join table or maybe a way to turn the group field into a dynamic calculated result or even a combination of the two but I am not sure how to wire up a join table to work with the calendar and event tables. I am thinking the event ID would then be the group field and the join records would join the event id with employee IDs and property ID. All my IDs are UUIDs so I don't think it is a problem mixing two of my tables and the events table into a single join table but I am thinking the calendar probably needs the real group field.
Anyone tackle this or am I going about this all wrong?
Comment