I need a custom database with a simple front end to be developed for us to offer certain trips to our drivers (taxi company). OUR CURRENT SITE IS BUILT IN JOOMLA. I will need to have three different types of users: 1. Drivers 2. Operator 3. Administrator. I will create the Operator and administrator logins, but want to have the ability for Drivers to submit a request for a login (by filling out a form with the info for DRIVER below) and it will submit to me for be able to approve sot they can log in and see the trips we will add and also be able to have a simple "disable user" and "delete" button for all users in the system.
Here are the database fields:
Username (email address)
Password (with forgot password reset option to email)
Permission Level (Driver, Operator, Administrator, this is set by an administrator)
Zone (numeric field)
Accept button (a driver will click this button to choose to accept this order)
HOW THE SITE WILL WORK
A Operator will log into the system and fill out possible trips available, this will have them fill out the ORDER INFO fields and submit them one by one. A driver can log into the system and see two tabs: "Available Runs" and "Accepted Runs". In Available Runs, all available trips that have not been accepted by someone else will be displayed and will be sorted by DATE by default but can be restored by any field you may choose. Drivers can only see what is still available and what they have accepted, not any other drivers accepted orders. When the driver chooses to accept an order, it is removed from the list and placed in their "Accepted Runs" tab, this tab is sorted the same way.
Once a ride is accepted a driver can not choose to decline it, however an Operator can log in and remove the driver from being "assigned" to that order. An Operator can also choose to Delete the order, however I want the order to be moved to a Trash bin with Date and time stamps from any user (driver or Operator) on any changes that are done to orders (entered, changed, accepted, unassigned, deleted). An operator can also choose to assign a driver to an order from their log in screen through a drop down of driver numbers that are in the system.
Every night at midnight, an email will be generated to an an email address that I will determine, and will have information for how many assigned and unassigned trips are in the system for each date coming up (anything that has been entered for a date that has passed will be ignored).
Unassigned Trips: 12
Assigned Trips: 5
Unassigned Trips: 6
Assigned Trips: 3
As an operator or administrator i want to be able to run reports on trips by date range with the options to sort by driver, type (assigned or unassigned), or zone.
This site will be a sub-domain site using MYSQL which is already installed on our web server hosted at 1and1. I don't know if you want to use the existing JOOMLA (v3.2) and build it in there, or build application that runs on a sub-domain and is build in an entirely different language. That will be your call.