-- Demo: conductor 14 (Jose Suazo) — 5 camiones en junio 2026
-- HND-3001 y HND-3002 con consumo alto. Ejecutar en logica_combustible.

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;

DELETE FROM `fotos_ordenes_combustible`;
DELETE FROM `ordenes_combustible`;
ALTER TABLE `ordenes_combustible` AUTO_INCREMENT = 1;

INSERT INTO `ordenes_combustible` (
  `numero_orden`, `fecha_autorizacion`, `hora_autorizacion`,
  `id_gasolinera`, `id_empresa_cliente`, `id_vehiculo`, `id_conductor`,
  `id_ruta`, `id_zona`, `id_tipo_combustible`, `id_usuario`,
  `kilometraje_actual`, `cantidad_galones`, `valor_total_factura`,
  `confirmacion`, `estado`, `fecha_creacion`
) VALUES
-- HND-1001 (id 1) — normal ~0.15 gal/km
('OC-2026-0001', '2026-06-02', '08:30:00', 11, 2, 1, 14, 6, 1, 3, 8, 120000, 45.00, 1305.00, 1, 'registrada', '2026-06-02 08:30:00'),
('OC-2026-0002', '2026-06-08', '09:15:00', 11, 2, 1, 14, 6, 1, 3, 8, 120320, 48.00, 1392.00, 1, 'registrada', '2026-06-08 09:15:00'),
('OC-2026-0003', '2026-06-15', '10:00:00', 12, 2, 1, 14, 6, 1, 3, 8, 120650, 50.00, 1450.00, 1, 'registrada', '2026-06-15 10:00:00'),
('OC-2026-0004', '2026-06-22', '11:30:00', 12, 2, 1, 14, 6, 1, 3, 8, 120980, 49.00, 1421.00, 1, 'registrada', '2026-06-22 11:30:00'),
-- HND-1002 (id 2) — normal ~0.14 gal/km
('OC-2026-0005', '2026-06-03', '07:45:00', 11, 2, 2, 14, 6, 1, 3, 8, 98500, 42.00, 1218.00, 1, 'registrada', '2026-06-03 07:45:00'),
('OC-2026-0006', '2026-06-10', '08:20:00', 11, 2, 2, 14, 6, 1, 3, 8, 98810, 44.00, 1276.00, 1, 'registrada', '2026-06-10 08:20:00'),
('OC-2026-0007', '2026-06-17', '09:00:00', 12, 2, 2, 14, 6, 1, 3, 8, 99120, 43.00, 1247.00, 1, 'registrada', '2026-06-17 09:00:00'),
('OC-2026-0008', '2026-06-24', '10:15:00', 12, 2, 2, 14, 6, 1, 3, 8, 99430, 44.00, 1276.00, 1, 'registrada', '2026-06-24 10:15:00'),
-- HND-3001 (id 6) — consumo ALTO ~0.25–0.29 gal/km
('OC-2026-0009', '2026-06-04', '11:00:00', 12, 2, 6, 14, 6, 1, 3, 8, 45000, 40.00, 1160.00, 1, 'registrada', '2026-06-04 11:00:00'),
('OC-2026-0010', '2026-06-11', '11:45:00', 11, 2, 6, 14, 6, 1, 3, 8, 45220, 55.00, 1595.00, 1, 'registrada', '2026-06-11 11:45:00'),
('OC-2026-0011', '2026-06-18', '12:30:00', 12, 2, 6, 14, 6, 1, 3, 8, 45420, 58.00, 1682.00, 1, 'registrada', '2026-06-18 12:30:00'),
('OC-2026-0012', '2026-06-25', '13:00:00', 11, 2, 6, 14, 6, 1, 3, 8, 45600, 52.00, 1508.00, 1, 'registrada', '2026-06-25 13:00:00'),
-- HND-3002 (id 7) — consumo ALTO ~0.27–0.31 gal/km
('OC-2026-0013', '2026-06-05', '14:00:00', 11, 2, 7, 14, 6, 3, 3, 8, 62000, 35.00, 1015.00, 1, 'registrada', '2026-06-05 14:00:00'),
('OC-2026-0014', '2026-06-12', '14:30:00', 12, 2, 7, 14, 6, 2, 3, 8, 62180, 48.00, 1392.00, 1, 'registrada', '2026-06-12 14:30:00'),
('OC-2026-0015', '2026-06-19', '15:00:00', 11, 2, 7, 14, 6, 5, 3, 8, 62350, 50.00, 1450.00, 1, 'registrada', '2026-06-19 15:00:00'),
('OC-2026-0016', '2026-06-26', '15:45:00', 12, 2, 7, 14, 6, 6, 3, 8, 62500, 47.00, 1363.00, 1, 'registrada', '2026-06-26 15:45:00'),
-- HND-4001 (id 9) pickup — normal ~0.045 gal/km
('OC-2026-0017', '2026-06-06', '16:00:00', 11, 2, 9, 14, 6, 8, 3, 8, 15000, 12.00, 348.00, 1, 'registrada', '2026-06-06 16:00:00'),
('OC-2026-0018', '2026-06-13', '16:30:00', 12, 2, 9, 14, 6, 8, 3, 8, 15280, 13.00, 377.00, 1, 'registrada', '2026-06-13 16:30:00'),
('OC-2026-0019', '2026-06-20', '17:00:00', 11, 2, 9, 14, 6, 1, 3, 8, 15560, 12.00, 348.00, 1, 'registrada', '2026-06-20 17:00:00'),
('OC-2026-0020', '2026-06-27', '17:30:00', 12, 2, 9, 14, 6, 8, 3, 8, 15840, 13.00, 377.00, 1, 'registrada', '2026-06-27 17:30:00');

COMMIT;
