A requirement exists for an existing site being developed using PHP/MySQL to include the functionality to allow a user to manage seating plans for events. The functionality should be similar to that found at [url removed, login to view] and [url removed, login to view] GoJs has not been used since the cost is beyond our budget and we only require the seating chart which is not available independently.
Each Guest is currently stored in a guests table which contains a guestID and GuestName. The tables table is still to be built as well as the seating arrangement table. A users requires the ability to add tables to the floor plan specifying shape (Round, Rectangle or Square) and count of seats available at the table. Users are then able to drag guests from the guest list (Displaying guest name) onto an open seat on the floor plan. Users need to be able to drag and rotate tables around the floor plan and guest allocated need to remain assigned to the table.
Each table needs to have a name (editable) by clicking either a small edit button or just double clicking on the table.
Ajax needs to be applied to the floor plan to ensure that as guests are assigned to tables, tables are created or positions changed needs to save directly to a floorplan MySQL table. A theme has been purchased from Envato from which the site is currently being developed (Available if required).
Only the floor planner functionality is required but needs to fit within the theme and allow for mobile responsiveness.
A user needs to be able to create more than one Seating Plan (Each with its own name) and toggle between these.
Additional Functionality: Specify rate for each separately please:
1. The Guest table currently holds a column for an Attending with GuestID (If Possible when this is the case and the user drags the one guest, the system needs to pull over the attending with guest as well.)
2. Apply basic styling to elements (Chair element, different to Table Element, Different to Guest Element etc, see [url removed, login to view] or weddingwire for idea’s)
3. Allow the floor plan to be printable (Format flexible, either image file or pdf) Would allow for event co-ordinator to be provided with the floor plan.
A fixed cost estimate is required please. If additional information is required please ask.