Find Jobs
Hire Freelancers

Business Database Project

$300-1500 USD

Closed
Posted over 17 years ago

$300-1500 USD

Paid on delivery
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.
Project ID: 88070

About the project

51 proposals
Remote project
Active 17 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs

About the client

Flag of UNITED STATES
Burbank, United States
5.0
17
Member since Jan 5, 2006

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.