-- Sample trip logs referencing demo vehicles
INSERT INTO vehicle_trips (
  id, vehicle_id, driver_id, trip_date, start_time, end_time,
  start_location, start_latitude, start_longitude,
  end_location, end_latitude, end_longitude,
  distance_km, status,
  start_mileage, end_mileage, tenant_id, branch_id
) VALUES
  (1, 1, 2, '2025-06-01', '2025-06-01 08:00:00', '2025-06-01 10:00:00',
   'Suva HQ', -18.1398, 178.4266,
   'Nadi Office', -17.7533, 177.4435,
   200, 'completed', 12000, 12200, 1, 1),
  (2, 2, 3, '2025-06-02', '2025-06-02 07:45:00', '2025-06-02 09:30:00',
   'Nadi Office', -17.7533, 177.4435,
   'Lautoka', -17.6167, 177.4667,
   150, 'in_progress', 8000, 8150, 1, 1),
  (3, 3, 4, '2025-06-03', '2025-06-03 09:00:00', NULL,
   'Lautoka', -17.6167, 177.4667,
   'Suva HQ', -18.1398, 178.4266,
   0, 'scheduled', 15000, NULL, 1, 1),
  (4, 4, 5, '2025-06-04', '2025-06-04 13:00:00', '2025-06-04 15:30:00',
   'Suva HQ', -18.1398, 178.4266,
   'Labasa', -16.4302, 179.3822,
   220, 'cancelled', 5000, 5000, 1, 1),
  (5, 5, 1, '2025-06-05', '2025-06-05 07:30:00', '2025-06-05 09:00:00',
   'Labasa', -16.4302, 179.3822,
   'Savusavu', -16.7794, 179.3314,
   90, 'completed', 22000, 22090, 1, 1);
