TAXITUR Module CRUD Audit Report

Project: TAXITUR / DVBS (CodeIgniter) · Local: http://localhost/txn · DB: txn
Generated: 1 Aug 2026 · Method: static controller/view review + live schema checks + public HTTP probes
Client claim validated. Core public booking pricing and several role portals are broken or incomplete. Admin list modules mostly have CRUD code, but Customers edit is missing and airport/payment paths fail against the live schema.
6
Critical
6
Major
3
Minor
11 / 23
Modules Critical/Major

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)

1. Defect register — what is not working

ID Severity Module Issue / Evidence Impact
C1CriticalOnline 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.
C2CriticalDriver 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.
C3CriticalCar 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.
C4CriticalStripe 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.
C5CriticalAirport 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.
C6CriticalBookingSystem index Empty stub route
Bookingsystem::index() is empty; /en/bookingsystem returns blank 200.
Dead endpoint; harmless unless linked.
M1MajorCustomers 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.
M2MajorDriver 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.
M3MajorCar 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.
M4MajorCorporate Branches No Update (Create+Delete only)
add_branch / delete_branch exist; no update_branch; UI is add+delete only.
Cannot edit branch details.
M5MajorDriver complete_ride Sets confirm instead of completed
complete_ride() sets is_conformed='confirm' rather than 'completed'.
Ride completion status incorrect in ops/reporting.
M6MajorLegacy 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.
N1MinorFrontend 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.
N2MinorBackup Controllers Duplicate classes risk collisions
Welcomebackup*, Bookingsystembackup*, Vehicle_categoriesbackup* share live class names.
Risk on case-sensitive hosts / accidental routing.
N3MinorPayments Report Zero payment rows in DB
vbs_payments count = 0 on local txn.
Reports look empty (data, not code defect).

2. Module CRUD matrix

Create / Read / Update / Delete assessed from controllers + views + schema. Critical/Major rows are code/schema-proven.

ModuleAreaCRUDHealthNotesRows
BookingsAdminYesYesYesYesOKFull CRUD in Bookings.php21
VehiclesAdminYesYesYesYesMinorSplit: list/delete Vehicles; add/edit Vehicle_settings16
Main CategoriesAdminYesYesYesYesOKvehicle_categories/main_category*3
Vehicle CategoriesAdminYesYesYesYesOKPricing fields live here8
Vehicle FeaturesAdminYesYesYesYesOKStandard addedit pattern4
Locations (Airports)AdminYesYesYesYesOKvbs_airports58
CompaniesAdminYesYesYesYesOKIncludes assign helpers19
CustomersAdminYesYesNoYesMajorEdit missing (M1)28
ExecutivesAdminYesYesYesYesOKadd/edit_executive present9
Drivers (Admin)AdminYesYesYesYesOKvbs_drivers empty; driver users=230 / 23
CouponsAdminYesYesYesYesOKaddedit + toggle7
Dynamic PagesAdminYesYesYesYesOKvbs_aboutus5
FAQsAdminYesYesYesYesOKStandard CRUD8
Master SettingsAdminPartialYesYesPartialMajorairport_* broken (C5)mixed
Packages / Waitings / TestimonialsAdminYesYesYesYesOKUnder Settings controller10/19/3
ReportsAdminn/aYesn/an/aMinorPayments report empty0
Online Booking FunnelPublicBrokenYesn/an/aCriticalPricing wrong (C1); CDN (N1)—
Packages FrontendPublicPartialYesn/an/aOK/en/packages loads10
CorporatePortalPartialYesNoPartialMajorBranches no edit2
Driver PortalPortaln/aBrokenBrokenn/aCriticalDead nav (C2); wrong AJAX (M2)—
Car Owner PortalPortalPartialBrokenPartialBrokenCriticalMissing methods + salary (C3/M3)—
Executive PortalPortaln/aYesPartialn/aOKExecutive + shared bookings—
Stripe / PayPal / PayUPaymentsn/aPartialn/an/aCriticalStripe return broken (C4)0

3. Recommended fix workflow

  1. Phase 0 — Stabilize local (done): confirm http://localhost/txn + DB txn; remove backup controllers from deploy path; replace CDN URLs with local assets.
  2. Phase 1 — Critical booking pricing: add threshold_km to getVechicles SELECT; fix (float)$x ?? fallback precedence; verify quotes vs category rows.
  3. Phase 2 — Driver portal: rewrite drivers/common/navigation.php to Driver routes; fix my_bookings AJAX to filter driver_id; fix complete_ride status.
  4. Phase 3 — Car owner portal: implement/wire get_bookings, verify_booking, profile; fix salary SQL join + delete GET/POST; unify table names.
  5. Phase 4 — Payments: remove stripe_return debug exit; map status to enum confirm; smoke-test PayPal/PayU cancel/success paths.
  6. Phase 5 — Admin CRUD gaps: implement customers edit; corporate branch update; hide or migrate airport_* settings until tables exist.
  7. Phase 6 — Regression pass: admin sidebar CRUD smoke (list/add/edit/delete/status) per module; record pass/fail sheet for client.

4. Acceptance checklist (per module)

  1. List page loads without DB/PHP error
  2. Add form saves and appears in list
  3. Edit form loads existing row and updates
  4. Delete / status toggle works
  5. Role portal menus only link to existing actions