I have a database that has routes (e.g. Boston - New York) and rates for each route for each vehicle.
rate_id dropoff pickup rate1 rate2 rate3 rate4 rate5 rate6 rate7 rate8
I have another database that lists the vehicles, with their description and other attributes.
id type rate_class vehicle_thumb vehicle_large_image vehicle_trunk vehicle_interior vehicle_lifestyle vehicle_brand vehicle_logo vehicle_copy bags passengers
I need a control panel, written in pure PHP / mySQL (No framework, no objects) that will:
Allow me to add new vehicles and their rate structure for each route
Allow me to change the rates for any existing route / Vehicle combination
Allow me to add new routes
I need this fast.
I am just looking for the code, no site design. I'll integrate it. Format must be less than 900 pixels wide. Needs to be user friendly and intuitive.