We are seeking a designer that can create a database system for our business. We are in the rental business. The system needs two parts.
1. First, the user end
The user needs to be able to submit information through a form into the database. This information needs to include: name, email, password, contact phone number, contact mobile phone, how they found the website (ie. Google, Yahoo), home address, city, state, zip, delivery address, delivery city, delivery state, delivery zip code (only if their delivery information differs), date of the event, time of the event, preferred flavors, number of guests expected, and obstacles to delivery.
A calendar by the date field would be nice so the user can select the date on a calendar and it would be entered into the field.
On top of this we want to be able to gather credit card information (this needs to be encrypted). We are also interested in finding a way to automatically bill the credit card instantly, but this isn't required.
2. Admin Functions
When the form is submitted we would like certain fields to be sent to email addresses we specify.
There needs to be a password-protected admin panel. In the admin panel there needs to be the following features:
We need a mass email system where we can email all former customers.
We are a rental company that rents Margarita Machines. We want a database of machines where we can enter from the admin panel any new rental machines (which will represented by numbers), as well as assign machines to a given rental order.
A calendar in the admin panel should show the time of the event, the machine number (which was assigned by us), the name of the customer, the delivery address, the mobile phone, and the home phone number.
We need a secondary calendar that just shows what machines are available for each date according to the database. When a machine is designated to a specific date by us, it should not be available for delivery for that date, and the day following.
All new orders should be shown in the admin panel. For each new order, in the admin panel should be a map from our corporate office to the delivery address. I know that Google offers a service to utilize their Google Maps technology to easily do this.
There should be a 'Completed Rentals' section also that automatically displays all rentals in which their date has passed. There should be an option to enter a final price for these completed rentals, and when that price is entered, it will email the customer a final receipt with that amount. Also in the Completed Rentals should be a 'Notes' section where we can save a note about the customer and retrieve it later.
There should be a search function where you can search by name, date, city, or any other fields to find a past order.
There should also be a place to view the credit card information.
We do understand this is a lot to explain. Basically, if you are a programmer who knows PHP and MySQL very well, and can work with form data, you can do this project for us. If you feel confident with your skills in these areas, please place a bid.
For any clarification, please don't hestiate to ask.