Local data snapshot: bookings 21 · vehicles 16 · customers 28 · companies 19 · airports 58 · categories 8 · coupons 7 · payments 0 · drivers table 0 (driver users 23)
| ID | Severity | Module | Issue / Evidence | Impact |
|---|---|---|---|---|
| C1 | Critical | Online Booking / Pricing | getVechicles omits threshold_km → wrong fares
Bookingsystem.php selects id,category,price,start_fee,day_rate,seats,status,image but not threshold_km. Cast-before-?? makes threshold always 0, so any distance uses day_rate (e.g. 13,500+) instead of per-km. |
Public booking quotes incorrect prices; client sees booking as broken. |
| C2 | Critical | Driver Portal | Sidebar links to nonexistent routes
views/drivers/common/navigation.php → executive, settings/searchBookings, settings/bookings. Settings.php has no those methods. |
Drivers cannot navigate bookings from menu. |
| C3 | Critical | Car Owner Portal | Dashboard JS calls missing methods; salary AJAX joins bad table
Calls CarOwners/get_bookings, verify_booking (missing). Profile posts to carowners/profile (missing). ajax_driver_salaries joins bare drivers table (does not exist; only vbs_drivers). |
Car-owner dashboard / salaries unusable. |
| C4 | Critical | Stripe Payment Return | stripe_return() debug exit + invalid status value
Welcome.php stripe_return has print_r/exit; sets is_conformed='confirmed' but DB enum is pending|confirm|cancelled|… (no 'confirmed'). |
Card payments cannot complete successfully. |
| C5 | Critical | Airport Locations / Cars | CRUD against missing tables
Settings::airportLocations/airportCars use vbs_airport_locations & vbs_airport_cars — absent from live txn DB. |
Those settings pages throw DB errors if opened. |
| C6 | Critical | BookingSystem index | Empty stub route
Bookingsystem::index() is empty; /en/bookingsystem returns blank 200. |
Dead endpoint; harmless unless linked. |
| M1 | Major | Customers | No Edit/Update in CRUD
Only add_customer + list/delete/status. No edit_customer; list has no edit link; addedit view posts only to add. |
Cannot update customer details from admin. |
| M2 | Major | Driver Bookings | Wrong AJAX endpoint / filters
Driver::my_bookings uses users/ajax_get_bookings (filters user_id, not driver_id). booking_details redirects to drivers/my_bookings (plural mismatch). |
Driver booking history empty or wrong. |
| M3 | Major | Car Owner Salaries | Delete/create table naming + GET vs POST mismatch
Mixed vbs_driver_salaries vs driver_salaries; delete expects POST id but view uses GET /delete_driver_salary/{id}. |
Salary delete/add unreliable. |
| M4 | Major | Corporate Branches | No Update (Create+Delete only)
add_branch / delete_branch exist; no update_branch; UI is add+delete only. |
Cannot edit branch details. |
| M5 | Major | Driver complete_ride | Sets confirm instead of completed
complete_ride() sets is_conformed='confirm' rather than 'completed'. |
Ride completion status incorrect in ops/reporting. |
| M6 | Major | Legacy Settings Booking Views | Stale views still point at settings/bookings*
admin/settings/bookings.php and related still target moved Bookings controller URLs. |
404 if any leftover links hit them. |
| N1 | Minor | Frontend Assets | Hardcoded production CDN URLs
views/site/index.php and related → https://swsserver.online/taxitur/assets/... |
Local/offline broken images/CSS; depends on remote host. |
| N2 | Minor | Backup Controllers | Duplicate classes risk collisions
Welcomebackup*, Bookingsystembackup*, Vehicle_categoriesbackup* share live class names. |
Risk on case-sensitive hosts / accidental routing. |
| N3 | Minor | Payments Report | Zero payment rows in DB
vbs_payments count = 0 on local txn. |
Reports look empty (data, not code defect). |
| Module | Area | C | R | U | D | Health | Notes | Rows |
|---|---|---|---|---|---|---|---|---|
| Bookings | Admin | Yes | Yes | Yes | Yes | OK | Full CRUD in Bookings.php | 21 |
| Vehicles | Admin | Yes | Yes | Yes | Yes | Minor | Split: list/delete Vehicles; add/edit Vehicle_settings | 16 |
| Main Categories | Admin | Yes | Yes | Yes | Yes | OK | vehicle_categories/main_category* | 3 |
| Vehicle Categories | Admin | Yes | Yes | Yes | Yes | OK | Pricing fields live here | 8 |
| Vehicle Features | Admin | Yes | Yes | Yes | Yes | OK | Standard addedit pattern | 4 |
| Locations (Airports) | Admin | Yes | Yes | Yes | Yes | OK | vbs_airports | 58 |
| Companies | Admin | Yes | Yes | Yes | Yes | OK | Includes assign helpers | 19 |
| Customers | Admin | Yes | Yes | No | Yes | Major | Edit missing (M1) | 28 |
| Executives | Admin | Yes | Yes | Yes | Yes | OK | add/edit_executive present | 9 |
| Drivers (Admin) | Admin | Yes | Yes | Yes | Yes | OK | vbs_drivers empty; driver users=23 | 0 / 23 |
| Coupons | Admin | Yes | Yes | Yes | Yes | OK | addedit + toggle | 7 |
| Dynamic Pages | Admin | Yes | Yes | Yes | Yes | OK | vbs_aboutus | 5 |
| FAQs | Admin | Yes | Yes | Yes | Yes | OK | Standard CRUD | 8 |
| Master Settings | Admin | Partial | Yes | Yes | Partial | Major | airport_* broken (C5) | mixed |
| Packages / Waitings / Testimonials | Admin | Yes | Yes | Yes | Yes | OK | Under Settings controller | 10/19/3 |
| Reports | Admin | n/a | Yes | n/a | n/a | Minor | Payments report empty | 0 |
| Online Booking Funnel | Public | Broken | Yes | n/a | n/a | Critical | Pricing wrong (C1); CDN (N1) | — |
| Packages Frontend | Public | Partial | Yes | n/a | n/a | OK | /en/packages loads | 10 |
| Corporate | Portal | Partial | Yes | No | Partial | Major | Branches no edit | 2 |
| Driver Portal | Portal | n/a | Broken | Broken | n/a | Critical | Dead nav (C2); wrong AJAX (M2) | — |
| Car Owner Portal | Portal | Partial | Broken | Partial | Broken | Critical | Missing methods + salary (C3/M3) | — |
| Executive Portal | Portal | n/a | Yes | Partial | n/a | OK | Executive + shared bookings | — |
| Stripe / PayPal / PayU | Payments | n/a | Partial | n/a | n/a | Critical | Stripe return broken (C4) | 0 |