CodeIgniter project

1 - Need to create a new menu: -- Dashboard --- Total of goup, Nbr student absent (current day), Driver on ride, Alert to show if all student are in the group or every group are in the ride -- Map (will use a API to track all car on the map) -- School --- School name, address, City, Zip code, contact number, email, website, price for ride -- Student --- First name, Last name, age, sex, address, City, Zip code, contact number, parent contact number, School name -- Driver --- First name, Last name, age, sex, address, City, Zip code, contact number, date of contract -- Car --- Model, color, year, number imei, phone number, track (will use a API to track the car on the map) -- Group (Student group) --- Reference ID, zip code, Time, Nbr of seat (student), Select school, Select student *** A ***, Price, option price *** B *** WHEN WE CREATE A GROUP THE STUDENT NOT DISPLAY ANY MORE TO MAKE A NEW GROUP -- Book a ride --- Reference ID, Select client, Select school, select a group, *** C ***, make it reccurent or specfic day, send (mean send to driver app) WHEN WE CREATE A RIDE THE GROUP NOT DISPLAY ANY MORE TO MAKE A NEW RIDE -- Invoice --- Refence ID, select client, select group, Date, send -- Expense --- Salary (to assign a driver) --- Petrol (to assign a car) --- Rent (to assign a car) --- Option to add new and assign to any field *** A *** Here we need to make a button "Calculate" That mean the system need to calculate the navigation. To understand the navigation is between from Start point to End point. Start point mean school address End point mean student address But we need system calculate which student are closest from the school. Then to the next closest student from the first student address. Then next and next up to the limiting number of seat *** B *** Mean when we make a bill system calcul it with price trip + option Also when the driver go to pick up the student and one of them are absent, inside the bill system need to calcule how many absent have For exemple: Base ride price is $40 (include the first student) Each other student cost is $5 If this group have 5 students that mean the total price is $65 But if when the driver go to pick up a student and are absent I mean 2 of 5 are absent the total will be $55 *** C *** Here system need to find what is it the best driver of the this ride (by closest driver address to the last student address)