cedCab

Create a Web Application using PHP, MySql, HTML, CSS & JS (PHP OOP's concept)

User Group 1(Customer)- 1- Can signup / login 2- Can Book Taxi 3- Can check previous ride with proper date & price & Other information 4. Can check how much he spent on cab & total rides covered 5. Can filter data like month wise , week wise, CabWise 6. Can sort data(by ride date , by fare)(Asc, Desc Both) 7. Only unblocked user can login 8. Can update personal information like mobile number, Password, Name, username can't change

Group 2 (Admin)

Can check new ride request Can approve and cancel request Can see Detailed information of rides Can block & unblock user Can check total earnings & total no. of rides. Can filter data like month wise , week wise, CabWise & Can sort data(by ride date , by fare)(Asc, Desc Both) There will be default account with login id password for admin Can view, add location & distance from charbagh , can edit, delete the available route

Note:- Maintain Session, Cookies (for back to user like facebook)

Schema - ------------------ tbl_user ----------------- user_id int PK AI, email_id unique name varchar, dateofsignup varchar / datetime, mobile varchar, status boolean, // 0 for blocked 1 for unblocked password varchar md5(), is_admin Boolean ------------------
default user :- username- admin@gmail.com , password- Password123$

tbl_ride -------------- ride_id int PK AI, ride_date date, from varchar, to varchar, total_distance varchar, luggage varchar, total_fare varchar, status int, // 1 for pending , 2 for complete & 0 for cancelled customer_user_id varchar FK,

--------------- tbl_location ---------------
id int PK AI, name varchar, distance varchar, is_available boolean ---------------

Note: - Customer will have two area: Front-end for cab booking backend for data interpretation & login page is common for admin & user admin will have only backend area Can book cab only after signing in. Anonymous user can't book Cab but can calculate fare. For booking user must login!