In Progress

Online Database, calculations, reports, online logon levels for Taxis / Limo\'s

Need an invoice scheet converted into a database where I can record on a daily basis the total charges for cab (limo) fares charged, I have attached an excel file and layout text files for your information, database needs to be online and have different level of access (Password Levels).

*A table to contain drivers and vehicle details.

*Subform to contain actual transaction for the day.

*Queries to search for transactions

*Report on multiple criteria (date, driver, vehicle etc,,)

and a subform to store information about the actual transactions.

*Need the ability to add booking engine in time.

*MYSQL Driven

*May be done in a CMS

Any questions, please contact me.

Thank you,

Albin

About Project: Proposed a PHP, mysql based web app for Cab owners to keep track of per day vehicle earning and driver commission payment.

It will be Password protected app for two kind of user, Admin(owner) and Driver. Owner can Add/edit/view records and Driver only can see Records.

Admin Area:

Setings- here admin can change settings like their login, GST etc.
Drivers- add/edit/view drivers
Cars- add/edit/view cars
Bookkeeping-
Add New Record- select car, select Driver and enter trip details fair details, some calculation and Commission calculation. These record will be saved in db
View/search- Record can be search by date, driver, cars.


Driver Area:
Driver can view their own record and commission date wise.

-

Tables

User(UserID, Password, Role)
This table will be used for storing user credentials. Role can have two value i.e. Admin and Driver


FareType(FareTypeID, Name, Description)
This table will be used for storing different fare types i.e. CASH, EFT, ACC, Docket etc.

Car(CarID, Type, RegNo)
This table will be used for storing different cars available

Driver(DriverID, Name, Contact, Email, ABN Number, UserID)
This table will be used for storing driver details. UserID will be mapped to user table.

Booking(BookingID, CarID, DriverID, BookingDate, PaymentDate)
This table will be used for storing booking details.

Place(PlaceID, PlaceName)
This table will be used for storing Places.

Transaction(TransactionID, BookingID, FromPlaceID, ToPlaceID)
This table will be used to store trip informationper booking.

TransactionFare(TransactionID, FareID, FareTypeID, Fare)
This table will be used to store fare details per transaction
------------------------------------------------------------------------------------------
User Interface


MasterPage(Layout of every page)

1. Header (100px height, Screen width) (Having Login/Logout button on right bottom).
2. Content.(This will be refreshed for each page.) Divided into two part.
a. Menu on Left Side(Available screen height, 150px)
b. Content on Right side(Available screen height, Available Width)

3. Footer (100px height, Screen width) (Having Copy right information in center)

Login Page.
This will be the landing page who ever will visit application.
Textboxes and button for login functionality

Home Page.
(For Admin)
a. Menu on left will display menu list of "Home", "NewBooking" "SearchByDrivers", "SearchByDate", "SearchByCar".
b. Content page will show a grid(table) of recent bookings with pagination. Columns of grid will be BookingID(hyperlink), Car Name, Driver Name, BookingDate, Edit(Button), Delete(Button).


c. Clicking on Booking id will lead to View page.
d. Clicking on Edit button will lead to Add page.
e. Clicking on Delete button will lead to confirmation box for deletion. If clicked yes, then delete booking.

(For Driver)
a. Menu on left will display menu list of "Home", "SearchByDate", "SearchByCar".
b. Content page will show a grid(table) of recent bookings (in which he is driver) with pagination. Columns of grid will be BookingID(hyperlink), Car Name, Driver Name, BookingDate.
c. Clicking on Booking id will lead to View page.

View Page
This will display same screen as in attached spread sheet with read only mode

Edit Page
This will display same screen as in attached spread sheet with edit mode and save, reset button at the bottom

New Booking Page
This will display same screen as in attached spreadsheet with each field blank.

Search Page(Admin)
This will display a grid(table) on the basis of search criteria i.e. Car, Driver, Date. Table details will contain bookings with pagination. Columns of grid will be BookingID(hyperlink), Car Name, Driver Name, BookingDate, Edit button and delete button.

Search Page(Driver)
This will display a grid(table) on the basis of search criteria i.e. Car, Date. Table details will contain bookings with pagination. Columns of grid will be BookingID(hyperlink), Car Name, Driver Name, BookingDate etc.

----

Skills: Graphic Design, HTML, MySQL, PHP, Website Design

See more: transaction charges, total website design charges, the levels, store layout design online, online database php, limo driver, design your vehicle, design logon online, charges for a website design, online database, access subform, layout design online, vehicle booking, limo website, fares, excel reports, database calculations, calculations, cab website, database design php mysql report, database cab booking, database design record, php invoice calculations, php add record mysql table, table report design

About the Employer:
( 17 reviews ) Bridgeman Downs, Australia

Project ID: #4363141

Awarded to:

netinfinity

Certified IT Professionals with 10+ years of experience in delivering enterprise class web solutions, intranets, portals and business workflow solutions to clients worldwide. Please review the PMB for more information.

$1250 AUD in 21 days
(24 Reviews)
5.5

18 freelancers are bidding on average $584 for this job

buraqtech

Check your PMB for details!!!

$585 AUD in 15 days
(109 Reviews)
8.2
neoconcepts

i'm bidding again, let's talk.

$500 AUD in 14 days
(162 Reviews)
7.5
itssabya

Will provide you Quality Development with your Perfect Satisfaction! Please allow me to take care of it. Thanks Saby

$700 AUD in 18 days
(153 Reviews)
6.9
johnflash

hi, i see you need a web based platform to manage your cars,drivers, transactions, fares, etc i can get this done for you in good time...would deliever a perfectly working system in less than 5 days i got over 5y More

$450 AUD in 4 days
(20 Reviews)
6.8
shihan033010

Hi please check my proposal.

$700 AUD in 30 days
(308 Reviews)
6.8
solution4you

I will be happy to create this app for you. I have a great experience with PHP, MySQL, CSS, Javascript and jQuery. Hope to do business with you. Thx !

$580 AUD in 21 days
(156 Reviews)
6.4
gasoved

Hello, for the design part, is there any site you want this app look similar? I'll build the project using symfony2, so it'll be robust and easy to maintain. Please check my PM. Thanks!

$750 AUD in 25 days
(30 Reviews)
6.0
adibr70

I have experience working with PHP, JavaScript, AJAX, MySQL and integration into a site. Check your Private Message to see some examples of sites that I made using PHP. Adrian

$699 AUD in 25 days
(31 Reviews)
5.6
neoarty

Ready to Start, Will Try to Give You Our 100% Effort for Your Satisfaction with our Service. Please check your PMB.

$500 AUD in 14 days
(30 Reviews)
5.7
flybot

I propose application based on Twitter Bootstrap & YII framework. I have experience with these frameworks. But I am confused by the requirement of ability to add booking engine in time. What do you mean by that require More

$550 AUD in 21 days
(17 Reviews)
5.3
ForeignTree

Consider it done

$500 AUD in 25 days
(25 Reviews)
5.7
robindersingh

Ready to Start! *** 7+ years experience *** Constant Updates, Top Quality, Support. Will provide daily updates via skype or email. The bid includes design , development, testing ,deployment and support.

$499 AUD in 30 days
(19 Reviews)
5.1
mihaialexandru90

I've been programming since the 9-th grade and my first computer was at the age of 6.I'm 23 now. Romania is on top 3 freelancing markets in Europe now and is very popular and accepted as the country where talented p More

$300 AUD in 10 days
(2 Reviews)
1.6
dipakdhola09

I apply for this project.

$250 AUD in 1 day
(0 Reviews)
0.0
ibholanath

I have understood your requirement. we have team of very energetic folks who can finish your work on time with highest level of satisfactory result. our designed website in this area Please check PMB

$500 AUD in 30 days
(0 Reviews)
0.0
beltechnology

Hi We have read your project requirement in detail. Our team has the required expertise and knowledge to accomplish this requirement in the given time frame. Please let us know the best time to discuss the opportu More

$500 AUD in 3 days
(0 Reviews)
0.0
dariopm

Good morning: We have send to you a PM. Thanks for your interest.

$700 AUD in 25 days
(0 Reviews)
0.0