Find Jobs
Hire Freelancers

Business Database Project

$300-1500 USD

Cerrado
Publicado hace más de 17 años

$300-1500 USD

Pagado a la entrega
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.
ID del proyecto: 88070

Información sobre el proyecto

51 propuestas
Proyecto remoto
Activo hace 17 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos

Sobre este cliente

Bandera de UNITED STATES
Burbank, United States
5,0
17
Miembro desde ene 5, 2006

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.