SQL: [url removed, login to view]
I have an active site running Drupal 6.15. I require a new custom Drupal module be built. It should be completely custom, and not built using any existing modules.
On the back end, I want to be able to create a meeting (these will be a content type of "tour"), with the following fields: unit code (dropdown with all unit codes of active pages with content type of "listing"), date, start time, # of attendees, a checkbox for recurring tour, recurring end date, agent name, agent email, agent phone number. Tours can be made active, inactive, or be deleted. If the recurring tour checkbox is checked, the tour will repeat on the same day of the week at the same time every week until the recurring end date.
On the front end, anonymous users will be able to sign up for the tour. I currently have a content type called "listing". When the user is viewing one of these listings, they will be presented with a "Take a Tour" button. When they click on the "Take a Tour" button, an inline pop-up box will appear with a form. On the inline pop-up should be a small calendar with all of the tours where the tour's "unit code" field matches the listing's "unit code" field. There will also be form fields for full name, email address, phone number, move-in date, and a checkbox that says "Notify me when other new apartments become available." If the user checks the checkbox, they will be subscribed to my mailing list using Drupal's Mail Chimp module.
The user will fill out all form fields, and choose a tour from the calendar. Once the user submits the form, their information will be placed into the database and be associated with that particular tour. If the tour has the recurring box checked, they will only be signed up for the specific instance of the tour that they chose. Once the number of people who sign up for a tour have exceeded the # of attendees set in the tour, the tour will no longer be available for additional people to sign up.
When a sign up is submitted, an email will be sent immediately to the agent with an [url removed, login to view] file that will place the tour into the agent's Google, Outlook or other calendar in this format: Subject: Full Name (unit code), Location: phone number, Description: Full Name, phone number, email address. It will also immediately send an email to the user with a subject and content that can be configured by the admin, and that has replacement tokens for all of the front end and back end fields. It will then send a second email at a later time also that can be configured by the admin with tokens. The admin can choose how many hours before the tour time the second email is sent. Each email has a link to cancel the appointment. If the appointment is cancelled, the agent will get another email with an [url removed, login to view] attachment which will cancel the appointment in their calendar.
Additionally, certain authenticated roles will be able to see the list of tours online that can be sorted by unit code, date & time, or fullname. The roles that are allowed to see the list can be chosen by admin. If the user with such a role clicks on one of the tours, they will be able to see all sign ups associated with that tour.
Send me a message if you have any questions regarding my requirements at all.
In addition to the your bid, please let me know how long it will be to complete the work, and what type(s) of access you require to the server.
Thank you for your interest in this project!