-- phpMyAdmin SQL Dump -- version 5.2.0 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Jun 08, 2026 at 06:25 PM -- Server version: 10.4.27-MariaDB -- PHP Version: 7.4.33 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `panel_bordo` -- -- -------------------------------------------------------- -- -- Table structure for table `configuraciones` -- CREATE TABLE `configuraciones` ( `id` int(10) UNSIGNED NOT NULL, `usuario_id` int(10) UNSIGNED NOT NULL, `empresa_id` int(10) UNSIGNED NOT NULL, `clave` varchar(100) NOT NULL, `valor` mediumtext DEFAULT NULL, `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `configuraciones` -- INSERT INTO `configuraciones` (`id`, `usuario_id`, `empresa_id`, `clave`, `valor`, `updated_at`) VALUES (45, 1, 4, 'dashboard_layout', '[{\"id\":\"ec-kpi-ingresos\",\"x\":0,\"y\":0,\"w\":3,\"h\":6},{\"id\":\"ec-kpi-resultado\",\"x\":3,\"y\":0,\"w\":3,\"h\":6},{\"id\":\"ec-kpi-stock\",\"x\":6,\"y\":0,\"w\":3,\"h\":6},{\"id\":\"ec-kpi-vientres\",\"x\":9,\"y\":0,\"w\":3,\"h\":6},{\"id\":\"ec-kpi-carga\",\"x\":12,\"y\":0,\"w\":3,\"h\":6},{\"id\":\"ec-kpi-superficie\",\"x\":15,\"y\":0,\"w\":3,\"h\":6},{\"id\":\"ec-kpi-mortandad\",\"x\":18,\"y\":0,\"w\":3,\"h\":6},{\"id\":\"ec-kpi-liquidez\",\"x\":21,\"y\":0,\"w\":3,\"h\":6},{\"id\":\"ec-superficie\",\"x\":0,\"y\":6,\"w\":4,\"h\":14},{\"id\":\"ec-indicadores\",\"x\":4,\"y\":6,\"w\":6,\"h\":14},{\"id\":\"ec-evolucion\",\"x\":10,\"y\":6,\"w\":6,\"h\":14},{\"id\":\"ec-rodeo\",\"x\":16,\"y\":6,\"w\":4,\"h\":14},{\"id\":\"ec-gauges\",\"x\":20,\"y\":6,\"w\":4,\"h\":14},{\"id\":\"ec-ingegr\",\"x\":0,\"y\":20,\"w\":7,\"h\":13},{\"id\":\"ec-resultado\",\"x\":7,\"y\":20,\"w\":7,\"h\":13},{\"id\":\"ec-flujo\",\"x\":14,\"y\":20,\"w\":5,\"h\":13},{\"id\":\"ec-ratios\",\"x\":19,\"y\":20,\"w\":5,\"h\":13},{\"id\":\"ec-potreros\",\"x\":0,\"y\":33,\"w\":8,\"h\":16},{\"id\":\"ec-alertas\",\"x\":8,\"y\":33,\"w\":4,\"h\":16},{\"id\":\"custom-10\",\"x\":12,\"y\":33,\"w\":3,\"h\":16},{\"id\":\"custom-9\",\"x\":15,\"y\":33,\"w\":3,\"h\":16},{\"id\":\"ec-mejoras\",\"x\":18,\"y\":33,\"w\":6,\"h\":16},{\"id\":\"ec-movimientos\",\"x\":0,\"y\":49,\"w\":10,\"h\":11},{\"id\":\"ec-acciones\",\"x\":10,\"y\":49,\"w\":7,\"h\":11},{\"id\":\"ec-stk-movim\",\"x\":17,\"y\":49,\"w\":7,\"h\":11},{\"id\":\"custom-1\",\"x\":0,\"y\":60,\"w\":4,\"h\":6},{\"id\":\"custom-2\",\"x\":4,\"y\":60,\"w\":4,\"h\":6},{\"id\":\"custom-3\",\"x\":8,\"y\":60,\"w\":4,\"h\":6},{\"id\":\"custom-4\",\"x\":12,\"y\":60,\"w\":4,\"h\":6},{\"id\":\"custom-5\",\"x\":16,\"y\":60,\"w\":4,\"h\":6},{\"id\":\"custom-6\",\"x\":20,\"y\":60,\"w\":4,\"h\":6},{\"id\":\"custom-7\",\"x\":0,\"y\":66,\"w\":6,\"h\":14},{\"id\":\"custom-8\",\"x\":6,\"y\":66,\"w\":6,\"h\":14},{\"id\":\"custom-11\",\"x\":12,\"y\":66,\"w\":12,\"h\":14},{\"id\":\"custom-12\",\"x\":0,\"y\":80,\"w\":11,\"h\":18},{\"id\":\"custom-13\",\"x\":11,\"y\":80,\"w\":13,\"h\":18},{\"id\":\"custom-14\",\"x\":0,\"y\":98,\"w\":24,\"h\":9},{\"id\":\"ec-quote\",\"x\":0,\"y\":107,\"w\":24,\"h\":10}]', '2026-05-28 22:32:23'), (61, 1, 3, 'dashboard_hidden', '[\"ventas-turno\"]', '2026-06-04 20:41:12'), (62, 1, 3, 'dashboard_layout', '[{\"id\":\"kpi-ventas\",\"x\":0,\"y\":0,\"w\":4,\"h\":4},{\"id\":\"kpi-litros\",\"x\":4,\"y\":0,\"w\":4,\"h\":4},{\"id\":\"kpi-margen\",\"x\":8,\"y\":0,\"w\":4,\"h\":4},{\"id\":\"kpi-banco\",\"x\":12,\"y\":0,\"w\":4,\"h\":4},{\"id\":\"kpi-caja\",\"x\":16,\"y\":0,\"w\":4,\"h\":4},{\"id\":\"kpi-contrato\",\"x\":20,\"y\":0,\"w\":4,\"h\":4},{\"id\":\"litros-combustible\",\"x\":0,\"y\":4,\"w\":6,\"h\":15},{\"id\":\"evolucion-litros\",\"x\":6,\"y\":4,\"w\":7,\"h\":15},{\"id\":\"resultados-unidad\",\"x\":13,\"y\":4,\"w\":11,\"h\":15},{\"id\":\"inventario\",\"x\":0,\"y\":19,\"w\":5,\"h\":15},{\"id\":\"personal\",\"x\":5,\"y\":19,\"w\":6,\"h\":15},{\"id\":\"evolucion-retiros\",\"x\":11,\"y\":19,\"w\":8,\"h\":15},{\"id\":\"saldos\",\"x\":19,\"y\":19,\"w\":5,\"h\":15},{\"id\":\"stock-mermas\",\"x\":0,\"y\":34,\"w\":10,\"h\":25},{\"id\":\"costos-fijos\",\"x\":10,\"y\":34,\"w\":5,\"h\":25},{\"id\":\"gauge-retiros\",\"x\":15,\"y\":34,\"w\":5,\"h\":16},{\"id\":\"indicadores\",\"x\":20,\"y\":34,\"w\":4,\"h\":16},{\"id\":\"lectura\",\"x\":15,\"y\":50,\"w\":9,\"h\":9},{\"id\":\"alertas\",\"x\":0,\"y\":59,\"w\":24,\"h\":8}]', '2026-06-04 22:14:37'); -- -------------------------------------------------------- -- -- Table structure for table `costos` -- CREATE TABLE `costos` ( `id` int(10) UNSIGNED NOT NULL, `empresa_id` int(10) UNSIGNED NOT NULL, `periodo_id` int(10) UNSIGNED NOT NULL, `fecha` date NOT NULL, `unidad_negocio` varchar(80) NOT NULL DEFAULT '', `tipo_costo` varchar(100) NOT NULL DEFAULT '', `categoria` varchar(50) NOT NULL DEFAULT 'Costos Indirectos', `importe` decimal(14,2) NOT NULL DEFAULT 0.00, `created_at` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `costos` -- INSERT INTO `costos` (`id`, `empresa_id`, `periodo_id`, `fecha`, `unidad_negocio`, `tipo_costo`, `categoria`, `importe`, `created_at`) VALUES (1, 1, 1, '2025-06-01', 'Combustible', 'Costo combustible', 'Costos Indirectos', '686000.00', '2026-05-19 22:57:49'), (2, 1, 1, '2025-06-01', 'Red Pagos', 'Arrendamiento', 'Costos Indirectos', '47250.00', '2026-05-19 22:57:49'), (3, 1, 1, '2025-06-01', 'Red Pagos', 'Sueldos y cargas', 'Costos Indirectos', '167400.00', '2026-05-19 22:57:49'), (4, 1, 1, '2025-06-01', 'Red Pagos', 'Energía eléctrica', 'Costos Indirectos', '23980.00', '2026-05-19 22:57:49'), (5, 1, 1, '2025-06-01', 'Combustible', 'Comisiones', 'Costos Indirectos', '32550.00', '2026-05-19 22:57:49'), (6, 1, 1, '2025-06-01', 'Red Pagos', 'Mantenimiento', 'Costos Indirectos', '18900.00', '2026-05-19 22:57:49'), (7, 1, 1, '2025-06-01', 'Red Pagos', 'Seguros', 'Costos Indirectos', '12600.00', '2026-05-19 22:57:49'), (8, 1, 1, '2025-06-01', 'Red Pagos', 'Gastos generales', 'Costos Indirectos', '8320.00', '2026-05-19 22:57:49'), (9, 1, 2, '2025-07-01', 'Combustible', 'Costo combustible', 'Costos Indirectos', '644000.00', '2026-05-19 22:57:49'), (10, 1, 2, '2025-07-01', 'Red Pagos', 'Arrendamiento', 'Costos Indirectos', '43200.00', '2026-05-19 22:57:49'), (11, 1, 2, '2025-07-01', 'Red Pagos', 'Sueldos y cargas', 'Costos Indirectos', '190800.00', '2026-05-19 22:57:49'), (12, 1, 2, '2025-07-01', 'Red Pagos', 'Energía eléctrica', 'Costos Indirectos', '22440.00', '2026-05-19 22:57:49'), (13, 1, 2, '2025-07-01', 'Combustible', 'Comisiones', 'Costos Indirectos', '36400.00', '2026-05-19 22:57:49'), (14, 1, 2, '2025-07-01', 'Red Pagos', 'Mantenimiento', 'Costos Indirectos', '18900.00', '2026-05-19 22:57:49'), (15, 1, 2, '2025-07-01', 'Red Pagos', 'Seguros', 'Costos Indirectos', '13080.00', '2026-05-19 22:57:49'), (16, 1, 2, '2025-07-01', 'Red Pagos', 'Gastos generales', 'Costos Indirectos', '8480.00', '2026-05-19 22:57:49'), (17, 1, 3, '2025-08-01', 'Combustible', 'Costo combustible', 'Costos Indirectos', '714000.00', '2026-05-19 22:57:49'), (18, 1, 3, '2025-08-01', 'Red Pagos', 'Arrendamiento', 'Costos Indirectos', '45000.00', '2026-05-19 22:57:49'), (19, 1, 3, '2025-08-01', 'Red Pagos', 'Sueldos y cargas', 'Costos Indirectos', '190800.00', '2026-05-19 22:57:49'), (20, 1, 3, '2025-08-01', 'Red Pagos', 'Energía eléctrica', 'Costos Indirectos', '21780.00', '2026-05-19 22:57:49'), (21, 1, 3, '2025-08-01', 'Combustible', 'Comisiones', 'Costos Indirectos', '37100.00', '2026-05-19 22:57:49'), (22, 1, 3, '2025-08-01', 'Red Pagos', 'Mantenimiento', 'Costos Indirectos', '16740.00', '2026-05-19 22:57:49'), (23, 1, 3, '2025-08-01', 'Red Pagos', 'Seguros', 'Costos Indirectos', '12240.00', '2026-05-19 22:57:49'), (24, 1, 3, '2025-08-01', 'Red Pagos', 'Gastos generales', 'Costos Indirectos', '7760.00', '2026-05-19 22:57:49'), (25, 1, 4, '2025-09-01', 'Combustible', 'Costo combustible', 'Costos Indirectos', '714000.00', '2026-05-19 22:57:49'), (26, 1, 4, '2025-09-01', 'Red Pagos', 'Arrendamiento', 'Costos Indirectos', '40950.00', '2026-05-19 22:57:49'), (27, 1, 4, '2025-09-01', 'Red Pagos', 'Sueldos y cargas', 'Costos Indirectos', '169200.00', '2026-05-19 22:57:49'), (28, 1, 4, '2025-09-01', 'Red Pagos', 'Energía eléctrica', 'Costos Indirectos', '21120.00', '2026-05-19 22:57:49'), (29, 1, 4, '2025-09-01', 'Combustible', 'Comisiones', 'Costos Indirectos', '37100.00', '2026-05-19 22:57:49'), (30, 1, 4, '2025-09-01', 'Red Pagos', 'Mantenimiento', 'Costos Indirectos', '18540.00', '2026-05-19 22:57:49'), (31, 1, 4, '2025-09-01', 'Red Pagos', 'Seguros', 'Costos Indirectos', '12360.00', '2026-05-19 22:57:49'), (32, 1, 4, '2025-09-01', 'Red Pagos', 'Gastos generales', 'Costos Indirectos', '8400.00', '2026-05-19 22:57:49'), (33, 1, 5, '2025-10-01', 'Combustible', 'Costo combustible', 'Costos Indirectos', '700000.00', '2026-05-19 22:57:49'), (34, 1, 5, '2025-10-01', 'Red Pagos', 'Arrendamiento', 'Costos Indirectos', '47700.00', '2026-05-19 22:57:49'), (35, 1, 5, '2025-10-01', 'Red Pagos', 'Sueldos y cargas', 'Costos Indirectos', '196200.00', '2026-05-19 22:57:49'), (36, 1, 5, '2025-10-01', 'Red Pagos', 'Energía eléctrica', 'Costos Indirectos', '20900.00', '2026-05-19 22:57:49'), (37, 1, 5, '2025-10-01', 'Combustible', 'Comisiones', 'Costos Indirectos', '35700.00', '2026-05-19 22:57:49'), (38, 1, 5, '2025-10-01', 'Red Pagos', 'Mantenimiento', 'Costos Indirectos', '19440.00', '2026-05-19 22:57:49'), (39, 1, 5, '2025-10-01', 'Red Pagos', 'Seguros', 'Costos Indirectos', '13200.00', '2026-05-19 22:57:49'), (40, 1, 5, '2025-10-01', 'Red Pagos', 'Gastos generales', 'Costos Indirectos', '8320.00', '2026-05-19 22:57:49'), (41, 1, 6, '2025-11-01', 'Combustible', 'Costo combustible', 'Costos Indirectos', '728000.00', '2026-05-19 22:57:49'), (42, 1, 6, '2025-11-01', 'Red Pagos', 'Arrendamiento', 'Costos Indirectos', '48150.00', '2026-05-19 22:57:49'), (43, 1, 6, '2025-11-01', 'Red Pagos', 'Sueldos y cargas', 'Costos Indirectos', '194400.00', '2026-05-19 22:57:49'), (44, 1, 6, '2025-11-01', 'Red Pagos', 'Energía eléctrica', 'Costos Indirectos', '20020.00', '2026-05-19 22:57:49'), (45, 1, 6, '2025-11-01', 'Combustible', 'Comisiones', 'Costos Indirectos', '33950.00', '2026-05-19 22:57:49'), (46, 1, 6, '2025-11-01', 'Red Pagos', 'Mantenimiento', 'Costos Indirectos', '19800.00', '2026-05-19 22:57:49'), (47, 1, 6, '2025-11-01', 'Red Pagos', 'Seguros', 'Costos Indirectos', '11640.00', '2026-05-19 22:57:49'), (48, 1, 6, '2025-11-01', 'Red Pagos', 'Gastos generales', 'Costos Indirectos', '8400.00', '2026-05-19 22:57:49'), (49, 1, 7, '2025-12-01', 'Combustible', 'Costo combustible', 'Costos Indirectos', '658000.00', '2026-05-19 22:57:49'), (50, 1, 7, '2025-12-01', 'Red Pagos', 'Arrendamiento', 'Costos Indirectos', '42300.00', '2026-05-19 22:57:49'), (51, 1, 7, '2025-12-01', 'Red Pagos', 'Sueldos y cargas', 'Costos Indirectos', '194400.00', '2026-05-19 22:57:49'), (52, 1, 7, '2025-12-01', 'Red Pagos', 'Energía eléctrica', 'Costos Indirectos', '22000.00', '2026-05-19 22:57:49'), (53, 1, 7, '2025-12-01', 'Combustible', 'Comisiones', 'Costos Indirectos', '37800.00', '2026-05-19 22:57:49'), (54, 1, 7, '2025-12-01', 'Red Pagos', 'Mantenimiento', 'Costos Indirectos', '17640.00', '2026-05-19 22:57:49'), (55, 1, 7, '2025-12-01', 'Red Pagos', 'Seguros', 'Costos Indirectos', '12000.00', '2026-05-19 22:57:49'), (56, 1, 7, '2025-12-01', 'Red Pagos', 'Gastos generales', 'Costos Indirectos', '8400.00', '2026-05-19 22:57:49'), (57, 1, 8, '2026-01-01', 'Combustible', 'Costo combustible', 'Costos Indirectos', '665000.00', '2026-05-19 22:57:49'), (58, 1, 8, '2026-01-01', 'Red Pagos', 'Arrendamiento', 'Costos Indirectos', '42300.00', '2026-05-19 22:57:49'), (59, 1, 8, '2026-01-01', 'Red Pagos', 'Sueldos y cargas', 'Costos Indirectos', '190800.00', '2026-05-19 22:57:49'), (60, 1, 8, '2026-01-01', 'Red Pagos', 'Energía eléctrica', 'Costos Indirectos', '22880.00', '2026-05-19 22:57:49'), (61, 1, 8, '2026-01-01', 'Combustible', 'Comisiones', 'Costos Indirectos', '36750.00', '2026-05-19 22:57:49'), (62, 1, 8, '2026-01-01', 'Red Pagos', 'Mantenimiento', 'Costos Indirectos', '18000.00', '2026-05-19 22:57:49'), (63, 1, 8, '2026-01-01', 'Red Pagos', 'Seguros', 'Costos Indirectos', '12600.00', '2026-05-19 22:57:49'), (64, 1, 8, '2026-01-01', 'Red Pagos', 'Gastos generales', 'Costos Indirectos', '7920.00', '2026-05-19 22:57:49'), (65, 1, 9, '2026-02-01', 'Combustible', 'Costo combustible', 'Costos Indirectos', '700000.00', '2026-05-19 22:57:49'), (66, 1, 9, '2026-02-01', 'Red Pagos', 'Arrendamiento', 'Costos Indirectos', '47250.00', '2026-05-19 22:57:49'), (67, 1, 9, '2026-02-01', 'Red Pagos', 'Sueldos y cargas', 'Costos Indirectos', '185400.00', '2026-05-19 22:57:49'), (68, 1, 9, '2026-02-01', 'Red Pagos', 'Energía eléctrica', 'Costos Indirectos', '20680.00', '2026-05-19 22:57:49'), (69, 1, 9, '2026-02-01', 'Combustible', 'Comisiones', 'Costos Indirectos', '35000.00', '2026-05-19 22:57:49'), (70, 1, 9, '2026-02-01', 'Red Pagos', 'Mantenimiento', 'Costos Indirectos', '19260.00', '2026-05-19 22:57:49'), (71, 1, 9, '2026-02-01', 'Red Pagos', 'Seguros', 'Costos Indirectos', '12000.00', '2026-05-19 22:57:49'), (72, 1, 9, '2026-02-01', 'Red Pagos', 'Gastos generales', 'Costos Indirectos', '7440.00', '2026-05-19 22:57:49'), (73, 1, 10, '2026-03-01', 'Combustible', 'Costo combustible', 'Costos Indirectos', '637000.00', '2026-05-19 22:57:49'), (74, 1, 10, '2026-03-01', 'Red Pagos', 'Arrendamiento', 'Costos Indirectos', '49050.00', '2026-05-19 22:57:49'), (75, 1, 10, '2026-03-01', 'Red Pagos', 'Sueldos y cargas', 'Costos Indirectos', '163800.00', '2026-05-19 22:57:49'), (76, 1, 10, '2026-03-01', 'Red Pagos', 'Energía eléctrica', 'Costos Indirectos', '23540.00', '2026-05-19 22:57:49'), (77, 1, 10, '2026-03-01', 'Combustible', 'Comisiones', 'Costos Indirectos', '36400.00', '2026-05-19 22:57:49'), (78, 1, 10, '2026-03-01', 'Red Pagos', 'Mantenimiento', 'Costos Indirectos', '16740.00', '2026-05-19 22:57:49'), (79, 1, 10, '2026-03-01', 'Red Pagos', 'Seguros', 'Costos Indirectos', '11280.00', '2026-05-19 22:57:49'), (80, 1, 10, '2026-03-01', 'Red Pagos', 'Gastos generales', 'Costos Indirectos', '7600.00', '2026-05-19 22:57:49'), (81, 1, 11, '2026-04-01', 'Combustible', 'Costo combustible', 'Costos Indirectos', '693000.00', '2026-05-19 22:57:49'), (82, 1, 11, '2026-04-01', 'Red Pagos', 'Arrendamiento', 'Costos Indirectos', '46800.00', '2026-05-19 22:57:49'), (83, 1, 11, '2026-04-01', 'Red Pagos', 'Sueldos y cargas', 'Costos Indirectos', '181800.00', '2026-05-19 22:57:49'), (84, 1, 11, '2026-04-01', 'Red Pagos', 'Energía eléctrica', 'Costos Indirectos', '23980.00', '2026-05-19 22:57:49'), (85, 1, 11, '2026-04-01', 'Combustible', 'Comisiones', 'Costos Indirectos', '32900.00', '2026-05-19 22:57:49'), (86, 1, 11, '2026-04-01', 'Red Pagos', 'Mantenimiento', 'Costos Indirectos', '16200.00', '2026-05-19 22:57:49'), (87, 1, 11, '2026-04-01', 'Red Pagos', 'Seguros', 'Costos Indirectos', '10800.00', '2026-05-19 22:57:49'), (88, 1, 11, '2026-04-01', 'Red Pagos', 'Gastos generales', 'Costos Indirectos', '8160.00', '2026-05-19 22:57:49'), (89, 1, 12, '2026-05-01', 'Combustible', 'Costo combustible', 'Costos Indirectos', '665000.00', '2026-05-19 22:57:49'), (90, 1, 12, '2026-05-01', 'Red Pagos', 'Arrendamiento', 'Costos Indirectos', '44100.00', '2026-05-19 22:57:49'), (91, 1, 12, '2026-05-01', 'Red Pagos', 'Sueldos y cargas', 'Costos Indirectos', '180000.00', '2026-05-19 22:57:49'), (92, 1, 12, '2026-05-01', 'Red Pagos', 'Energía eléctrica', 'Costos Indirectos', '20240.00', '2026-05-19 22:57:49'), (93, 1, 12, '2026-05-01', 'Combustible', 'Comisiones', 'Costos Indirectos', '35350.00', '2026-05-19 22:57:49'), (94, 1, 12, '2026-05-01', 'Red Pagos', 'Mantenimiento', 'Costos Indirectos', '16200.00', '2026-05-19 22:57:49'), (95, 1, 12, '2026-05-01', 'Red Pagos', 'Seguros', 'Costos Indirectos', '13200.00', '2026-05-19 22:57:49'), (96, 1, 12, '2026-05-01', 'Red Pagos', 'Gastos generales', 'Costos Indirectos', '7440.00', '2026-05-19 22:57:49'), (97, 2, 13, '2025-06-01', 'Combustible', 'Costo combustible', 'Costos Indirectos', '707000.00', '2026-05-19 22:57:49'), (98, 2, 13, '2025-06-01', 'Red Pagos', 'Arrendamiento', 'Costos Indirectos', '44550.00', '2026-05-19 22:57:49'), (99, 2, 13, '2025-06-01', 'Red Pagos', 'Sueldos y cargas', 'Costos Indirectos', '198000.00', '2026-05-19 22:57:49'), (100, 2, 13, '2025-06-01', 'Red Pagos', 'Energía eléctrica', 'Costos Indirectos', '22220.00', '2026-05-19 22:57:49'), (101, 2, 13, '2025-06-01', 'Combustible', 'Comisiones', 'Costos Indirectos', '36750.00', '2026-05-19 22:57:49'), (102, 2, 13, '2025-06-01', 'Red Pagos', 'Mantenimiento', 'Costos Indirectos', '19440.00', '2026-05-19 22:57:49'), (103, 2, 13, '2025-06-01', 'Red Pagos', 'Seguros', 'Costos Indirectos', '13200.00', '2026-05-19 22:57:49'), (104, 2, 13, '2025-06-01', 'Red Pagos', 'Gastos generales', 'Costos Indirectos', '8320.00', '2026-05-19 22:57:49'), (105, 2, 14, '2025-07-01', 'Combustible', 'Costo combustible', 'Costos Indirectos', '763000.00', '2026-05-19 22:57:49'), (106, 2, 14, '2025-07-01', 'Red Pagos', 'Arrendamiento', 'Costos Indirectos', '40950.00', '2026-05-19 22:57:49'), (107, 2, 14, '2025-07-01', 'Red Pagos', 'Sueldos y cargas', 'Costos Indirectos', '178200.00', '2026-05-19 22:57:49'), (108, 2, 14, '2025-07-01', 'Red Pagos', 'Energía eléctrica', 'Costos Indirectos', '22000.00', '2026-05-19 22:57:49'), (109, 2, 14, '2025-07-01', 'Combustible', 'Comisiones', 'Costos Indirectos', '31500.00', '2026-05-19 22:57:49'), (110, 2, 14, '2025-07-01', 'Red Pagos', 'Mantenimiento', 'Costos Indirectos', '18900.00', '2026-05-19 22:57:49'), (111, 2, 14, '2025-07-01', 'Red Pagos', 'Seguros', 'Costos Indirectos', '11760.00', '2026-05-19 22:57:49'), (112, 2, 14, '2025-07-01', 'Red Pagos', 'Gastos generales', 'Costos Indirectos', '8080.00', '2026-05-19 22:57:49'), (113, 2, 15, '2025-08-01', 'Combustible', 'Costo combustible', 'Costos Indirectos', '679000.00', '2026-05-19 22:57:49'), (114, 2, 15, '2025-08-01', 'Red Pagos', 'Arrendamiento', 'Costos Indirectos', '44550.00', '2026-05-19 22:57:49'), (115, 2, 15, '2025-08-01', 'Red Pagos', 'Sueldos y cargas', 'Costos Indirectos', '194400.00', '2026-05-19 22:57:49'), (116, 2, 15, '2025-08-01', 'Red Pagos', 'Energía eléctrica', 'Costos Indirectos', '23540.00', '2026-05-19 22:57:49'), (117, 2, 15, '2025-08-01', 'Combustible', 'Comisiones', 'Costos Indirectos', '32900.00', '2026-05-19 22:57:49'), (118, 2, 15, '2025-08-01', 'Red Pagos', 'Mantenimiento', 'Costos Indirectos', '17640.00', '2026-05-19 22:57:49'), (119, 2, 15, '2025-08-01', 'Red Pagos', 'Seguros', 'Costos Indirectos', '12600.00', '2026-05-19 22:57:49'), (120, 2, 15, '2025-08-01', 'Red Pagos', 'Gastos generales', 'Costos Indirectos', '8400.00', '2026-05-19 22:57:49'), (121, 2, 16, '2025-09-01', 'Combustible', 'Costo combustible', 'Costos Indirectos', '658000.00', '2026-05-19 22:57:49'), (122, 2, 16, '2025-09-01', 'Red Pagos', 'Arrendamiento', 'Costos Indirectos', '46800.00', '2026-05-19 22:57:49'), (123, 2, 16, '2025-09-01', 'Red Pagos', 'Sueldos y cargas', 'Costos Indirectos', '176400.00', '2026-05-19 22:57:49'), (124, 2, 16, '2025-09-01', 'Red Pagos', 'Energía eléctrica', 'Costos Indirectos', '19800.00', '2026-05-19 22:57:49'), (125, 2, 16, '2025-09-01', 'Combustible', 'Comisiones', 'Costos Indirectos', '37100.00', '2026-05-19 22:57:49'), (126, 2, 16, '2025-09-01', 'Red Pagos', 'Mantenimiento', 'Costos Indirectos', '16380.00', '2026-05-19 22:57:49'), (127, 2, 16, '2025-09-01', 'Red Pagos', 'Seguros', 'Costos Indirectos', '10800.00', '2026-05-19 22:57:49'), (128, 2, 16, '2025-09-01', 'Red Pagos', 'Gastos generales', 'Costos Indirectos', '8240.00', '2026-05-19 22:57:49'), (129, 2, 17, '2025-10-01', 'Combustible', 'Costo combustible', 'Costos Indirectos', '637000.00', '2026-05-19 22:57:49'), (130, 2, 17, '2025-10-01', 'Red Pagos', 'Arrendamiento', 'Costos Indirectos', '43650.00', '2026-05-19 22:57:49'), (131, 2, 17, '2025-10-01', 'Red Pagos', 'Sueldos y cargas', 'Costos Indirectos', '180000.00', '2026-05-19 22:57:49'), (132, 2, 17, '2025-10-01', 'Red Pagos', 'Energía eléctrica', 'Costos Indirectos', '21560.00', '2026-05-19 22:57:49'), (133, 2, 17, '2025-10-01', 'Combustible', 'Comisiones', 'Costos Indirectos', '35700.00', '2026-05-19 22:57:49'), (134, 2, 17, '2025-10-01', 'Red Pagos', 'Mantenimiento', 'Costos Indirectos', '18180.00', '2026-05-19 22:57:49'), (135, 2, 17, '2025-10-01', 'Red Pagos', 'Seguros', 'Costos Indirectos', '12000.00', '2026-05-19 22:57:49'), (136, 2, 17, '2025-10-01', 'Red Pagos', 'Gastos generales', 'Costos Indirectos', '7840.00', '2026-05-19 22:57:49'), (137, 2, 18, '2025-11-01', 'Combustible', 'Costo combustible', 'Costos Indirectos', '749000.00', '2026-05-19 22:57:49'), (138, 2, 18, '2025-11-01', 'Red Pagos', 'Arrendamiento', 'Costos Indirectos', '43650.00', '2026-05-19 22:57:49'), (139, 2, 18, '2025-11-01', 'Red Pagos', 'Sueldos y cargas', 'Costos Indirectos', '183600.00', '2026-05-19 22:57:49'), (140, 2, 18, '2025-11-01', 'Red Pagos', 'Energía eléctrica', 'Costos Indirectos', '20900.00', '2026-05-19 22:57:49'), (141, 2, 18, '2025-11-01', 'Combustible', 'Comisiones', 'Costos Indirectos', '38150.00', '2026-05-19 22:57:49'), (142, 2, 18, '2025-11-01', 'Red Pagos', 'Mantenimiento', 'Costos Indirectos', '17820.00', '2026-05-19 22:57:49'), (143, 2, 18, '2025-11-01', 'Red Pagos', 'Seguros', 'Costos Indirectos', '11760.00', '2026-05-19 22:57:49'), (144, 2, 18, '2025-11-01', 'Red Pagos', 'Gastos generales', 'Costos Indirectos', '7840.00', '2026-05-19 22:57:49'), (145, 2, 19, '2025-12-01', 'Combustible', 'Costo combustible', 'Costos Indirectos', '644000.00', '2026-05-19 22:57:49'), (146, 2, 19, '2025-12-01', 'Red Pagos', 'Arrendamiento', 'Costos Indirectos', '40500.00', '2026-05-19 22:57:49'), (147, 2, 19, '2025-12-01', 'Red Pagos', 'Sueldos y cargas', 'Costos Indirectos', '192600.00', '2026-05-19 22:57:49'), (148, 2, 19, '2025-12-01', 'Red Pagos', 'Energía eléctrica', 'Costos Indirectos', '22440.00', '2026-05-19 22:57:49'), (149, 2, 19, '2025-12-01', 'Combustible', 'Comisiones', 'Costos Indirectos', '32900.00', '2026-05-19 22:57:49'), (150, 2, 19, '2025-12-01', 'Red Pagos', 'Mantenimiento', 'Costos Indirectos', '17280.00', '2026-05-19 22:57:49'), (151, 2, 19, '2025-12-01', 'Red Pagos', 'Seguros', 'Costos Indirectos', '11160.00', '2026-05-19 22:57:49'), (152, 2, 19, '2025-12-01', 'Red Pagos', 'Gastos generales', 'Costos Indirectos', '8000.00', '2026-05-19 22:57:49'), (153, 2, 20, '2026-01-01', 'Combustible', 'Costo combustible', 'Costos Indirectos', '637000.00', '2026-05-19 22:57:49'), (154, 2, 20, '2026-01-01', 'Red Pagos', 'Arrendamiento', 'Costos Indirectos', '44550.00', '2026-05-19 22:57:49'), (155, 2, 20, '2026-01-01', 'Red Pagos', 'Sueldos y cargas', 'Costos Indirectos', '181800.00', '2026-05-19 22:57:49'), (156, 2, 20, '2026-01-01', 'Red Pagos', 'Energía eléctrica', 'Costos Indirectos', '20900.00', '2026-05-19 22:57:49'), (157, 2, 20, '2026-01-01', 'Combustible', 'Comisiones', 'Costos Indirectos', '31850.00', '2026-05-19 22:57:49'), (158, 2, 20, '2026-01-01', 'Red Pagos', 'Mantenimiento', 'Costos Indirectos', '18540.00', '2026-05-19 22:57:49'), (159, 2, 20, '2026-01-01', 'Red Pagos', 'Seguros', 'Costos Indirectos', '12960.00', '2026-05-19 22:57:49'), (160, 2, 20, '2026-01-01', 'Red Pagos', 'Gastos generales', 'Costos Indirectos', '8640.00', '2026-05-19 22:57:49'), (161, 2, 21, '2026-02-01', 'Combustible', 'Costo combustible', 'Costos Indirectos', '665000.00', '2026-05-19 22:57:49'), (162, 2, 21, '2026-02-01', 'Red Pagos', 'Arrendamiento', 'Costos Indirectos', '47250.00', '2026-05-19 22:57:49'), (163, 2, 21, '2026-02-01', 'Red Pagos', 'Sueldos y cargas', 'Costos Indirectos', '187200.00', '2026-05-19 22:57:49'), (164, 2, 21, '2026-02-01', 'Red Pagos', 'Energía eléctrica', 'Costos Indirectos', '24200.00', '2026-05-19 22:57:49'), (165, 2, 21, '2026-02-01', 'Combustible', 'Comisiones', 'Costos Indirectos', '38500.00', '2026-05-19 22:57:49'), (166, 2, 21, '2026-02-01', 'Red Pagos', 'Mantenimiento', 'Costos Indirectos', '17280.00', '2026-05-19 22:57:49'), (167, 2, 21, '2026-02-01', 'Red Pagos', 'Seguros', 'Costos Indirectos', '12120.00', '2026-05-19 22:57:49'), (168, 2, 21, '2026-02-01', 'Red Pagos', 'Gastos generales', 'Costos Indirectos', '8400.00', '2026-05-19 22:57:49'), (169, 2, 22, '2026-03-01', 'Combustible', 'Costo combustible', 'Costos Indirectos', '770000.00', '2026-05-19 22:57:49'), (170, 2, 22, '2026-03-01', 'Red Pagos', 'Arrendamiento', 'Costos Indirectos', '41400.00', '2026-05-19 22:57:49'), (171, 2, 22, '2026-03-01', 'Red Pagos', 'Sueldos y cargas', 'Costos Indirectos', '169200.00', '2026-05-19 22:57:49'), (172, 2, 22, '2026-03-01', 'Red Pagos', 'Energía eléctrica', 'Costos Indirectos', '20680.00', '2026-05-19 22:57:49'), (173, 2, 22, '2026-03-01', 'Combustible', 'Comisiones', 'Costos Indirectos', '35000.00', '2026-05-19 22:57:49'), (174, 2, 22, '2026-03-01', 'Red Pagos', 'Mantenimiento', 'Costos Indirectos', '16740.00', '2026-05-19 22:57:49'), (175, 2, 22, '2026-03-01', 'Red Pagos', 'Seguros', 'Costos Indirectos', '13080.00', '2026-05-19 22:57:49'), (176, 2, 22, '2026-03-01', 'Red Pagos', 'Gastos generales', 'Costos Indirectos', '7200.00', '2026-05-19 22:57:49'), (177, 2, 23, '2026-04-01', 'Combustible', 'Costo combustible', 'Costos Indirectos', '770000.00', '2026-05-19 22:57:49'), (178, 2, 23, '2026-04-01', 'Red Pagos', 'Arrendamiento', 'Costos Indirectos', '45000.00', '2026-05-19 22:57:49'), (179, 2, 23, '2026-04-01', 'Red Pagos', 'Sueldos y cargas', 'Costos Indirectos', '196200.00', '2026-05-19 22:57:49'), (180, 2, 23, '2026-04-01', 'Red Pagos', 'Energía eléctrica', 'Costos Indirectos', '21340.00', '2026-05-19 22:57:49'), (181, 2, 23, '2026-04-01', 'Combustible', 'Comisiones', 'Costos Indirectos', '37100.00', '2026-05-19 22:57:49'), (182, 2, 23, '2026-04-01', 'Red Pagos', 'Mantenimiento', 'Costos Indirectos', '16200.00', '2026-05-19 22:57:49'), (183, 2, 23, '2026-04-01', 'Red Pagos', 'Seguros', 'Costos Indirectos', '12840.00', '2026-05-19 22:57:49'), (184, 2, 23, '2026-04-01', 'Red Pagos', 'Gastos generales', 'Costos Indirectos', '8480.00', '2026-05-19 22:57:49'), (185, 2, 24, '2026-05-01', 'Combustible', 'Costo combustible', 'Costos Indirectos', '637000.00', '2026-05-19 22:57:49'), (186, 2, 24, '2026-05-01', 'Red Pagos', 'Arrendamiento', 'Costos Indirectos', '49500.00', '2026-05-19 22:57:49'), (187, 2, 24, '2026-05-01', 'Red Pagos', 'Sueldos y cargas', 'Costos Indirectos', '165600.00', '2026-05-19 22:57:49'), (188, 2, 24, '2026-05-01', 'Red Pagos', 'Energía eléctrica', 'Costos Indirectos', '22000.00', '2026-05-19 22:57:49'), (189, 2, 24, '2026-05-01', 'Combustible', 'Comisiones', 'Costos Indirectos', '33600.00', '2026-05-19 22:57:49'), (190, 2, 24, '2026-05-01', 'Red Pagos', 'Mantenimiento', 'Costos Indirectos', '18180.00', '2026-05-19 22:57:49'), (191, 2, 24, '2026-05-01', 'Red Pagos', 'Seguros', 'Costos Indirectos', '11400.00', '2026-05-19 22:57:49'), (192, 2, 24, '2026-05-01', 'Red Pagos', 'Gastos generales', 'Costos Indirectos', '7600.00', '2026-05-19 22:57:49'), (1145, 3, 47, '2026-04-30', 'Combustible', 'Arrendamiento', 'Costos Indirectos', '1510864.20', '2026-06-05 14:55:50'), (1146, 3, 47, '2026-04-30', 'Combustible', 'Comisiones', 'Costos Indirectos', '411458.97', '2026-06-05 14:55:50'), (1147, 3, 47, '2026-04-30', 'Combustible', 'Comisiones', 'Costos Indirectos', '26431.55', '2026-06-05 14:55:50'), (1148, 3, 47, '2026-04-30', 'Combustible', 'Costo Mercaderia', 'Costos Directos', '37444714.00', '2026-06-05 14:55:50'), (1149, 3, 47, '2026-04-30', 'Pista', 'Costo Mercaderia', 'Costos Directos', '626267.62', '2026-06-05 14:55:50'), (1150, 3, 47, '2026-04-30', 'Minimercado', 'Costo Mercaderia', 'Costos Directos', '1905003.81', '2026-06-05 14:55:50'), (1151, 3, 47, '2026-04-30', 'Combustible', 'Energía eléctrica', 'Costos Indirectos', '91410.37', '2026-06-05 14:55:50'), (1152, 3, 47, '2026-04-30', 'Minimercado', 'Gastos generales', 'Costos Indirectos', '52120.01', '2026-06-05 14:55:50'), (1153, 3, 47, '2026-04-30', 'Pista', 'Gastos generales', 'Costos Indirectos', '61809.74', '2026-06-05 14:55:50'), (1154, 3, 47, '2026-04-30', 'Combustible', 'Gastos generales', 'Costos Indirectos', '52139.52', '2026-06-05 14:55:50'), (1155, 3, 47, '2026-04-30', 'Combustible', 'Gastos generales', 'Costos Indirectos', '-61809.74', '2026-06-05 14:55:50'), (1156, 3, 47, '2026-04-30', 'Combustible', 'Gastos generales', 'Costos Indirectos', '-143.55', '2026-06-05 14:55:50'), (1157, 3, 47, '2026-04-30', 'Minimercado', 'Gastos generales', 'Costos Indirectos', '-1252.91', '2026-06-05 14:55:50'), (1158, 3, 47, '2026-04-30', 'Minimercado', 'Honorarios Profesionales', 'Costos Indirectos', '104034.00', '2026-06-05 14:55:50'), (1159, 3, 47, '2026-04-30', 'Combustible', 'IVA no deducible', 'Costos Indirectos', '173133.00', '2026-06-05 14:55:50'), (1160, 3, 47, '2026-04-30', 'Combustible', 'Mantenimiento', 'Costos Indirectos', '63977.79', '2026-06-05 14:55:50'), (1161, 3, 47, '2026-04-30', 'Minimercado', 'Mantenimiento', 'Costos Indirectos', '65308.55', '2026-06-05 14:55:50'), (1162, 3, 47, '2026-04-30', 'Combustible', 'Persepcion de Ursea', 'Costos Indirectos', '10859.83', '2026-06-05 14:55:50'), (1163, 3, 47, '2026-04-30', 'Combustible', 'Seguros', 'Costos Indirectos', '16692.62', '2026-06-05 14:55:50'), (1164, 3, 47, '2026-04-30', 'Minimercado', 'Seguros', 'Costos Indirectos', '26421.60', '2026-06-05 14:55:50'), (1165, 3, 47, '2026-04-30', 'Minimercado', 'Servicios Contratados', 'Costos Indirectos', '73623.44', '2026-06-05 14:55:50'), (1166, 3, 47, '2026-04-30', 'Red Pagos', 'Servicios Contratados', 'Costos Indirectos', '10000.00', '2026-06-05 14:55:50'), (1167, 3, 47, '2026-04-30', 'Combustible', 'Servicios Contratados', 'Costos Indirectos', '174860.90', '2026-06-05 14:55:50'), (1168, 3, 47, '2026-04-30', 'Red Pagos', 'Sueldos y cargas', 'Costos Indirectos', '109731.00', '2026-06-05 14:55:50'), (1169, 3, 47, '2026-04-30', 'Combustible', 'Sueldos y cargas', 'Costos Indirectos', '1426707.00', '2026-06-05 14:55:50'), (1170, 3, 47, '2026-04-30', 'Minimercado', 'Sueldos y cargas', 'Costos Indirectos', '472162.00', '2026-06-05 14:55:50'), (1171, 3, 47, '2026-04-30', 'Combustible', 'Uniformes', 'Costos Indirectos', '129658.20', '2026-06-05 14:55:50'), (1172, 3, 47, '2026-04-30', 'Minimercado', 'Uniformes', 'Costos Indirectos', '36759.67', '2026-06-05 14:55:50'), (1245, 3, 25, '2026-03-31', 'Combustible', 'Arrendamiento', 'Costos Indirectos', '1653617.20', '2026-06-05 15:08:03'), (1246, 3, 25, '2026-03-31', 'Combustible', 'Comisiones', 'Costos Indirectos', '449029.34', '2026-06-05 15:08:03'), (1247, 3, 25, '2026-03-31', 'Minimercado', 'Comisiones', 'Costos Indirectos', '34645.27', '2026-06-05 15:08:03'), (1248, 3, 25, '2026-03-31', 'Combustible', 'Costo Mercaderia', 'Costos Directos', '39343138.35', '2026-06-05 15:08:03'), (1249, 3, 25, '2026-03-31', 'Pista', 'Costo Mercaderia', 'Costos Directos', '607245.80', '2026-06-05 15:08:03'), (1250, 3, 25, '2026-03-31', 'Minimercado', 'Costo Mercaderia', 'Costos Directos', '2407766.19', '2026-06-05 15:08:03'), (1251, 3, 25, '2026-03-31', 'Combustible', 'Energía eléctrica', 'Costos Indirectos', '91672.13', '2026-06-05 15:08:03'), (1252, 3, 25, '2026-03-31', 'Combustible', 'Gastos generales', 'Costos Indirectos', '52249.78', '2026-06-05 15:08:03'), (1253, 3, 25, '2026-03-31', 'Combustible', 'Gastos generales', 'Costos Indirectos', '-61693.00', '2026-06-05 15:08:03'), (1254, 3, 25, '2026-03-31', 'Pista', 'Gastos generales', 'Costos Indirectos', '61693.00', '2026-06-05 15:08:03'), (1255, 3, 25, '2026-03-31', 'Minimercado', 'Gastos generales', 'Costos Indirectos', '24007.47', '2026-06-05 15:08:03'), (1256, 3, 25, '2026-03-31', 'Combustible', 'Gastos generales', 'Costos Indirectos', '-54534.59', '2026-06-05 15:08:03'), (1257, 3, 25, '2026-03-31', 'Minimercado', 'Honorarios Profesionales', 'Costos Indirectos', '93284.00', '2026-06-05 15:08:03'), (1258, 3, 25, '2026-03-31', 'Combustible', 'IVA no deducible', 'Costos Indirectos', '160226.00', '2026-06-05 15:08:03'), (1259, 3, 25, '2026-03-31', 'Combustible', 'Mantenimiento', 'Costos Indirectos', '62979.80', '2026-06-05 15:08:03'), (1260, 3, 25, '2026-03-31', 'Combustible', 'Persepcion de Ursea', 'Costos Indirectos', '12422.37', '2026-06-05 15:08:03'), (1261, 3, 25, '2026-03-31', 'Combustible', 'Seguros', 'Costos Indirectos', '16368.85', '2026-06-05 15:08:03'), (1262, 3, 25, '2026-03-31', 'Minimercado', 'Seguros', 'Costos Indirectos', '5824.59', '2026-06-05 15:08:03'), (1263, 3, 25, '2026-03-31', 'Red Pagos', 'Servicios Contratados', 'Costos Indirectos', '10000.00', '2026-06-05 15:08:03'), (1264, 3, 25, '2026-03-31', 'Combustible', 'Servicios Contratados', 'Costos Indirectos', '125291.04', '2026-06-05 15:08:03'), (1265, 3, 25, '2026-03-31', 'Minimercado', 'Servicios Contratados', 'Costos Indirectos', '71583.16', '2026-06-05 15:08:03'), (1266, 3, 25, '2026-03-31', 'Combustible', 'Sueldos y cargas', 'Costos Indirectos', '1434899.00', '2026-06-05 15:08:03'), (1267, 3, 25, '2026-03-31', 'Red Pagos', 'Sueldos y cargas', 'Costos Indirectos', '109731.00', '2026-06-05 15:08:03'), (1268, 3, 25, '2026-03-31', 'Minimercado', 'Sueldos y cargas', 'Costos Indirectos', '525714.00', '2026-06-05 15:08:03'), (1618, 3, 31, '2026-01-31', 'Combustible', 'Arrendamiento', 'Costos Indirectos', '1466498.54', '2026-06-07 00:18:44'), (1619, 3, 31, '2026-01-31', 'Minimercado', 'Comisiones', 'Costos Indirectos', '39323.52', '2026-06-07 00:18:44'), (1620, 3, 31, '2026-01-31', 'Combustible', 'Comisiones', 'Costos Indirectos', '425104.93', '2026-06-07 00:18:44'), (1621, 3, 31, '2026-01-31', 'Minimercado', 'Costo Mercaderia', 'Costos Directos', '2758249.28', '2026-06-07 00:18:44'), (1622, 3, 31, '2026-01-31', 'Combustible', 'Costo Mercaderia', 'Costos Directos', '36490883.00', '2026-06-07 00:18:44'), (1623, 3, 31, '2026-01-31', 'Pista', 'Costo Mercaderia', 'Costos Directos', '431998.13', '2026-06-07 00:18:44'), (1624, 3, 31, '2026-01-31', 'Combustible', 'Energía eléctrica', 'Costos Indirectos', '101059.22', '2026-06-07 00:18:44'), (1625, 3, 31, '2026-01-31', 'Minimercado', 'Gastos generales', 'Costos Indirectos', '59075.40', '2026-06-07 00:18:44'), (1626, 3, 31, '2026-01-31', 'Combustible', 'Gastos generales', 'Costos Indirectos', '78130.21', '2026-06-07 00:18:44'), (1627, 3, 31, '2026-01-31', 'Minimercado', 'Honorarios Profesionales', 'Costos Indirectos', '126250.00', '2026-06-07 00:18:44'), (1628, 3, 31, '2026-01-31', 'Combustible', 'IVA no deducible', 'Costos Indirectos', '179036.00', '2026-06-07 00:18:44'), (1629, 3, 31, '2026-01-31', 'Minimercado', 'Mantenimiento', 'Costos Indirectos', '-54884.52', '2026-06-07 00:18:44'), (1630, 3, 31, '0021-07-08', 'Combustible', 'Mantenimiento', 'Costos Indirectos', '129021.73', '2026-06-07 00:18:44'), (1631, 3, 31, '2026-01-31', 'Combustible', 'Persepcion de Ursea', 'Costos Indirectos', '10549.31', '2026-06-07 00:18:44'), (1632, 3, 31, '2026-01-31', 'Minimercado', 'Seguros', 'Costos Indirectos', '8618.85', '2026-06-07 00:18:44'), (1633, 3, 31, '2026-01-31', 'Combustible', 'Seguros', 'Costos Indirectos', '44186.54', '2026-06-07 00:18:44'), (1634, 3, 31, '2026-01-31', 'Minimercado', 'Servicios Contratados', 'Costos Indirectos', '50862.28', '2026-06-07 00:18:44'), (1635, 3, 31, '2026-01-31', 'Red Pagos', 'Servicios Contratados', 'Costos Indirectos', '10000.00', '2026-06-07 00:18:44'), (1636, 3, 31, '2026-01-31', 'Combustible', 'Servicios Contratados', 'Costos Indirectos', '128979.88', '2026-06-07 00:18:44'), (1637, 3, 31, '2026-01-31', 'Minimercado', 'Sueldos y cargas', 'Costos Indirectos', '475622.19', '2026-06-07 00:18:44'), (1638, 3, 31, '2026-01-31', 'Red Pagos', 'Sueldos y cargas', 'Costos Indirectos', '109731.00', '2026-06-07 00:18:44'), (1639, 3, 31, '2026-01-31', 'Combustible', 'Sueldos y cargas', 'Costos Indirectos', '1554656.00', '2026-06-07 00:18:44'), (1640, 3, 31, '2026-01-31', 'Combustible', 'Uniformes', 'Costos Indirectos', '2475.41', '2026-06-07 00:18:44'), (1641, 3, 31, '2026-01-31', 'Combustible', 'Gastos generales', 'Costos Indirectos', '-44402.00', '2026-06-07 00:18:44'), (1642, 3, 31, '2026-01-31', 'Pista', 'Gastos generales', 'Costos Indirectos', '44402.00', '2026-06-07 00:18:44'), (2085, 3, 30, '2026-02-28', 'Combustible', 'Arrendamiento', 'Costos Indirectos', '1559684.56', '2026-06-08 13:49:09'), (2086, 3, 30, '2026-02-28', 'Combustible', 'Comisiones', 'Costos Indirectos', '417662.67', '2026-06-08 13:49:09'), (2087, 3, 30, '2026-02-28', 'Minimercado', 'Comisiones', 'Costos Indirectos', '36490.60', '2026-06-08 13:49:09'), (2088, 3, 30, '2026-02-28', 'Combustible', 'Costo Mercaderia', 'Costos Directos', '36902835.96', '2026-06-08 13:49:09'), (2089, 3, 30, '2026-02-28', 'Pista', 'Costo Mercaderia', 'Costos Directos', '380287.00', '2026-06-08 13:49:09'), (2090, 3, 30, '2026-02-28', 'Minimercado', 'Costo Mercaderia', 'Costos Directos', '2707178.62', '2026-06-08 13:49:09'), (2091, 3, 30, '2026-02-28', 'Combustible', 'Energía eléctrica', 'Costos Indirectos', '96148.80', '2026-06-08 13:49:09'), (2092, 3, 30, '2026-02-28', 'Pista', 'Gastos generales', 'Costos Indirectos', '40762.00', '2026-06-08 13:49:09'), (2093, 3, 30, '2026-02-28', 'Minimercado', 'Gastos generales', 'Costos Indirectos', '53299.58', '2026-06-08 13:49:09'), (2094, 3, 30, '2026-02-28', 'Combustible', 'Gastos generales', 'Costos Indirectos', '30055.00', '2026-06-08 13:49:09'), (2095, 3, 30, '2026-02-28', 'Combustible', 'Gastos generales', 'Costos Indirectos', '-40762.00', '2026-06-08 13:49:09'), (2096, 3, 30, '2026-02-28', 'Minimercado', 'Honorarios Profesionales', 'Costos Indirectos', '22283.61', '2026-06-08 13:49:09'), (2097, 3, 30, '2026-02-28', 'Combustible', 'IVA no deducible', 'Costos Indirectos', '221145.00', '2026-06-08 13:49:09'), (2098, 3, 30, '2026-02-28', 'Combustible', 'Mantenimiento', 'Costos Indirectos', '116264.49', '2026-06-08 13:49:09'), (2099, 3, 30, '2026-02-28', 'Combustible', 'Persepcion de Ursea', 'Costos Indirectos', '11291.92', '2026-06-08 13:49:09'), (2100, 3, 30, '2026-02-28', 'Combustible', 'Seguros', 'Costos Indirectos', '259538.88', '2026-06-08 13:49:09'), (2101, 3, 30, '2026-02-28', 'Minimercado', 'Seguros', 'Costos Indirectos', '6817.60', '2026-06-08 13:49:09'), (2102, 3, 30, '2026-02-28', 'Red Pagos', 'Servicios Contratados', 'Costos Indirectos', '10000.00', '2026-06-08 13:49:09'), (2103, 3, 30, '2026-02-28', 'Combustible', 'Servicios Contratados', 'Costos Indirectos', '162102.30', '2026-06-08 13:49:09'), (2104, 3, 30, '2026-02-28', 'Minimercado', 'Servicios Contratados', 'Costos Indirectos', '56219.61', '2026-06-08 13:49:09'), (2105, 3, 30, '2026-02-28', 'Red Pagos', 'Sueldos y cargas', 'Costos Indirectos', '109731.00', '2026-06-08 13:49:09'), (2106, 3, 30, '2026-02-28', 'Combustible', 'Sueldos y cargas', 'Costos Indirectos', '1427717.00', '2026-06-08 13:49:09'), (2107, 3, 30, '2026-02-28', 'Minimercado', 'Sueldos y cargas', 'Costos Indirectos', '445988.00', '2026-06-08 13:49:09'), (2108, 3, 30, '2026-02-28', 'Minimercado', 'Mantenimiento', 'Costos Indirectos', '27307.34', '2026-06-08 13:49:09'); -- -------------------------------------------------------- -- -- Table structure for table `custom_widgets` -- CREATE TABLE `custom_widgets` ( `id` int(10) UNSIGNED NOT NULL, `empresa_id` int(10) UNSIGNED NOT NULL, `tipo` varchar(20) NOT NULL DEFAULT 'kpi', `titulo` varchar(200) NOT NULL, `subtitulo` varchar(200) NOT NULL DEFAULT '', `icono` varchar(100) NOT NULL DEFAULT 'bi-bar-chart', `color` varchar(20) NOT NULL DEFAULT '#64748b', `unidad` varchar(50) NOT NULL DEFAULT '', `configuracion` text DEFAULT NULL, `orden` int(10) UNSIGNED NOT NULL DEFAULT 0, `created_at` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `custom_widgets` -- INSERT INTO `custom_widgets` (`id`, `empresa_id`, `tipo`, `titulo`, `subtitulo`, `icono`, `color`, `unidad`, `configuracion`, `orden`, `created_at`) VALUES (1, 4, 'kpi', 'Stock Total', 'Rodeo actual', 'bi-boxes', '#1a3a5c', 'cab', NULL, 1, '2026-05-20 23:56:58'), (2, 4, 'kpi', 'EV Totales', 'Equivalentes vaca', 'bi-bar-chart', '#16a34a', 'EV', NULL, 2, '2026-05-20 23:56:58'), (3, 4, 'kpi', 'Carga Animal', 'Meta: ≤0,22 EV/ha', 'bi-speedometer', '#7c3aed', 'EV/ha', NULL, 3, '2026-05-20 23:56:58'), (4, 4, 'kpi', 'Liquidez Corriente', 'Meta: ≥1,5 — OK', 'bi-bank', '#0369a1', 'x', NULL, 4, '2026-05-20 23:56:58'), (5, 4, 'kpi', 'Rentabilidad', 'Meta: >10% — OK', 'bi-graph-up-arrow', '#059669', '%', NULL, 5, '2026-05-20 23:56:58'), (6, 4, 'kpi', 'Superficie Total', '5.100 ha útiles', 'bi-house-fill', '#ea580c', 'ha', NULL, 6, '2026-05-20 23:56:58'), (7, 4, 'grafico', 'Composición del Rodeo', 'Stock final por categoría', 'bi-bar-chart-fill', '#1a3a5c', '', '{\"chart_type\":\"bar\",\"eje_x\":[\"Vacas\",\"Vaquillonas\",\"Terneros\\/as\",\"Toros\"],\"series\":[{\"nombre\":\"Cabezas\",\"color\":\"#1a3a5c\",\"valores\":[724,43,103,545]}]}', 7, '2026-05-20 23:56:58'), (8, 4, 'grafico', 'Evolución Stock', 'Principales categorías 2026', 'bi-graph-up', '#16a34a', '', '{\"chart_type\":\"line\",\"eje_x\":[\"Ini\",\"Ene\",\"Feb\",\"Mar\",\"Abr\",\"May\",\"Jun\",\"Jul\",\"Ago\",\"Sep\",\"Oct\",\"Nov\"],\"series\":[{\"nombre\":\"Vacas\",\"color\":\"#1a3a5c\",\"valores\":[96,96,96,93,634,724,724,724,830,830,936,936]},{\"nombre\":\"Toros\",\"color\":\"#f0b429\",\"valores\":[925,841,798,797,545,545,445,345,245,100,0,0]},{\"nombre\":\"Terneros\",\"color\":\"#22c55e\",\"valores\":[12,12,12,42,103,163,223,283,343,403,463,523]}]}', 8, '2026-05-20 23:56:58'), (9, 4, 'gauge', 'Rentabilidad Anual', '', 'bi-graph-up-arrow', '#059669', '', '{\"min\":0,\"max\":50,\"meta\":10,\"unidad\":\"%\"}', 9, '2026-05-20 23:56:58'), (10, 4, 'gauge', 'Liquidez Corriente', '', 'bi-bank', '#0369a1', '', '{\"min\":0,\"max\":40,\"meta\":1.5,\"unidad\":\"x\"}', 10, '2026-05-20 23:56:58'), (11, 4, 'tabla', 'Stock Ganadero', 'Movimientos del período', 'bi-table', '#16a34a', '', '{\"columnas\":[\"Categoría\",\"Stock ini.\",\"Nacim.\",\"Compras\",\"Ventas\",\"Muertes\",\"Ajuste\",\"Stock fin.\",\"EV fin.\"],\"filas\":[[\"Vacas\",\"96\",\"-\",\"196\",\"-\",\"4\",\"+436\",\"724\",\"724,0\"],[\"Vaquillonas\",\"480\",\"-\",\"-\",\"-\",\"1\",\"-436\",\"43\",\"34,4\"],[\"Terneros\\/as\",\"12\",\"80\",\"21\",\"-\",\"10\",\"-\",\"103\",\"46,4\"],[\"Toros\",\"925\",\"-\",\"-\",\"378\",\"2\",\"-\",\"545\",\"681,3\"],[\"TOTAL\",\"1.513\",\"80\",\"217\",\"378\",\"17\",\"0\",\"1.415\",\"1.486\"]]}', 11, '2026-05-20 23:56:58'), (12, 4, 'tabla', 'Ratios Financieros', '', 'bi-receipt', '#1a3a5c', '', '{\"columnas\":[\"Indicador\",\"Valor\",\"Meta\",\"Estado\"],\"filas\":[[\"Activo corriente\",\"Gs 8.431.000.562\",\"-\",\"Dato\"],[\"Pasivo corriente\",\"Gs 270.769.071\",\"-\",\"Dato\"],[\"Liquidez corriente\",\"31,1 x\",\">= 1,5\",\"OK\"],[\"Ingresos anuales\",\"Gs 7.590.618.842\",\"-\",\"Dato\"],[\"Resultado anual\",\"Gs 2.397.089.104\",\"Positivo\",\"OK\"],[\"Rentabilidad\",\"31,6%\",\"> 10%\",\"OK\"],[\"Ingreso por ha util\",\"Gs 1.488.357\",\"> 35\",\"OK\"],[\"Resultado por ha util\",\"Gs 470.017\",\"> 0\",\"OK\"]]}', 12, '2026-05-20 23:56:58'), (13, 4, 'tabla', 'Control de Potreros', '', 'bi-table', '#0891b2', '', '{\"columnas\":[\"Potrero\",\"Sup. (ha)\",\"Agua\",\"Estado\",\"EV cap.\",\"EV actual\",\"D. desc.\",\"Observacion\"],\"filas\":[[\"P-1 Norte\",\"650\",\"2\",\"Bueno\",\"145\",\"130\",\"28\",\"Monte abierto\"],[\"P-2 Norte\",\"580\",\"1\",\"Regular\",\"120\",\"118\",\"22\",\"Reparar bebedero\"],[\"P-3 Centro\",\"720\",\"2\",\"Bueno\",\"165\",\"150\",\"30\",\"Buen forraje\"],[\"P-4 Centro\",\"510\",\"1\",\"Malo\",\"90\",\"88\",\"35\",\"Recuperacion\"],[\"P-5 Loma\",\"430\",\"1\",\"Regular\",\"82\",\"79\",\"25\",\"Rotacion corta\"],[\"P-6 Bajo\",\"760\",\"2\",\"Bueno\",\"170\",\"160\",\"29\",\"Buen acceso\"],[\"P-7 Oeste\",\"490\",\"1\",\"Regular\",\"96\",\"92\",\"21\",\"Agregar sombra\"],[\"P-8 Oeste\",\"610\",\"2\",\"Bueno\",\"138\",\"125\",\"31\",\"Sin novedades\"],[\"TOTAL\",\"4.750\",\"12\",\"-\",\"1.006\",\"942\",\"-\",\"-\"]]}', 13, '2026-05-20 23:56:58'), (14, 4, 'texto', 'Observaciones Operativas', '', 'bi-chat-square-text', '#64748b', '', '{\"estilo\":\"lista\",\"contenido\":\"Revisar aguadas y sombra en potreros de uso intensivo (P-2, P-7)\\nAjustar carga si la condicion de pasto cae por debajo de 30% Buena\\nLa carga objetivo del modelo se ubica cerca de 0,22 EV\\/ha (actual: 0,29)\\nP-4 Centro en recuperacion - evitar sobrecarga hasta nuevo estado\\nMonitorear mortandad: 1,1% actual, objetivo mantener por debajo de 2%\"}', 14, '2026-05-20 23:56:58'); -- -------------------------------------------------------- -- -- Table structure for table `custom_widget_valores` -- CREATE TABLE `custom_widget_valores` ( `id` int(10) UNSIGNED NOT NULL, `widget_id` int(10) UNSIGNED NOT NULL, `periodo_id` int(10) UNSIGNED NOT NULL, `valor` varchar(500) NOT NULL DEFAULT '', `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `custom_widget_valores` -- INSERT INTO `custom_widget_valores` (`id`, `widget_id`, `periodo_id`, `valor`, `updated_at`) VALUES (1, 1, 27, '1.415', '2026-05-20 23:56:58'), (2, 2, 27, '1.486', '2026-05-20 23:56:58'), (3, 3, 27, '0,29', '2026-05-20 23:56:58'), (4, 4, 27, '31,1', '2026-05-20 23:56:58'), (5, 5, 27, '31,6', '2026-05-20 23:56:58'), (6, 6, 27, '6.000', '2026-05-20 23:56:58'), (7, 9, 27, '31.58', '2026-05-20 23:56:58'), (8, 10, 27, '31.14', '2026-05-20 23:56:58'); -- -------------------------------------------------------- -- -- Table structure for table `empresas` -- CREATE TABLE `empresas` ( `id` int(10) UNSIGNED NOT NULL, `nombre` varchar(150) NOT NULL, `tipo` varchar(30) NOT NULL DEFAULT 'generic', `ruc` varchar(20) NOT NULL DEFAULT '', `logo_path` varchar(255) DEFAULT NULL, `moneda` varchar(5) NOT NULL DEFAULT 'UYU', `activo` tinyint(1) NOT NULL DEFAULT 1, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `empresas` -- INSERT INTO `empresas` (`id`, `nombre`, `tipo`, `ruc`, `logo_path`, `moneda`, `activo`, `created_at`, `updated_at`) VALUES (3, 'Isla de Flores', 'gasolinera', '', NULL, 'UYU', 1, '2026-05-19 23:19:24', '2026-05-21 00:10:25'), (4, 'Estancia Charrúa S.A.', 'estancia', '', NULL, 'PYG', 1, '2026-05-20 23:56:58', '2026-05-21 00:10:25'), (5, 'Prueba', 'generic', '', NULL, 'UYU', 0, '2026-05-26 14:23:36', '2026-05-26 14:31:51'); -- -------------------------------------------------------- -- -- Table structure for table `finanzas` -- CREATE TABLE `finanzas` ( `id` int(10) UNSIGNED NOT NULL, `empresa_id` int(10) UNSIGNED NOT NULL, `periodo_id` int(10) UNSIGNED NOT NULL, `fecha` date NOT NULL, `concepto` varchar(150) NOT NULL DEFAULT '', `importe` decimal(14,2) NOT NULL DEFAULT 0.00, `created_at` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `finanzas` -- INSERT INTO `finanzas` (`id`, `empresa_id`, `periodo_id`, `fecha`, `concepto`, `importe`, `created_at`) VALUES (1, 1, 1, '2025-06-01', 'Banco', '210600.00', '2026-05-19 22:57:49'), (2, 1, 1, '2025-06-01', 'Creditos comerciales', '45150.00', '2026-05-19 22:57:49'), (3, 1, 1, '2025-06-01', 'Deudas comerciales', '98400.00', '2026-05-19 22:57:49'), (4, 1, 1, '2025-06-01', 'Retiros socios', '34000.00', '2026-05-19 22:57:49'), (5, 1, 2, '2025-07-01', 'Banco', '162000.00', '2026-05-19 22:57:49'), (6, 1, 2, '2025-07-01', 'Creditos comerciales', '24850.00', '2026-05-19 22:57:49'), (7, 1, 2, '2025-07-01', 'Deudas comerciales', '139200.00', '2026-05-19 22:57:49'), (8, 1, 2, '2025-07-01', 'Retiros socios', '48000.00', '2026-05-19 22:57:49'), (9, 1, 3, '2025-08-01', 'Banco', '163800.00', '2026-05-19 22:57:49'), (10, 1, 3, '2025-08-01', 'Creditos comerciales', '28000.00', '2026-05-19 22:57:49'), (11, 1, 3, '2025-08-01', 'Deudas comerciales', '128400.00', '2026-05-19 22:57:49'), (12, 1, 3, '2025-08-01', 'Retiros socios', '43600.00', '2026-05-19 22:57:49'), (13, 1, 4, '2025-09-01', 'Banco', '203400.00', '2026-05-19 22:57:49'), (14, 1, 4, '2025-09-01', 'Creditos comerciales', '43050.00', '2026-05-19 22:57:49'), (15, 1, 4, '2025-09-01', 'Deudas comerciales', '134400.00', '2026-05-19 22:57:49'), (16, 1, 4, '2025-09-01', 'Retiros socios', '43600.00', '2026-05-19 22:57:49'), (17, 1, 5, '2025-10-01', 'Banco', '199800.00', '2026-05-19 22:57:49'), (18, 1, 5, '2025-10-01', 'Creditos comerciales', '36750.00', '2026-05-19 22:57:49'), (19, 1, 5, '2025-10-01', 'Deudas comerciales', '130800.00', '2026-05-19 22:57:49'), (20, 1, 5, '2025-10-01', 'Retiros socios', '40800.00', '2026-05-19 22:57:49'), (21, 1, 6, '2025-11-01', 'Banco', '201600.00', '2026-05-19 22:57:49'), (22, 1, 6, '2025-11-01', 'Creditos comerciales', '25550.00', '2026-05-19 22:57:49'), (23, 1, 6, '2025-11-01', 'Deudas comerciales', '133200.00', '2026-05-19 22:57:49'), (24, 1, 6, '2025-11-01', 'Retiros socios', '22000.00', '2026-05-19 22:57:49'), (25, 1, 7, '2025-12-01', 'Banco', '214200.00', '2026-05-19 22:57:49'), (26, 1, 7, '2025-12-01', 'Creditos comerciales', '27650.00', '2026-05-19 22:57:49'), (27, 1, 7, '2025-12-01', 'Deudas comerciales', '140400.00', '2026-05-19 22:57:49'), (28, 1, 7, '2025-12-01', 'Retiros socios', '50400.00', '2026-05-19 22:57:49'), (29, 1, 8, '2026-01-01', 'Banco', '144000.00', '2026-05-19 22:57:49'), (30, 1, 8, '2026-01-01', 'Creditos comerciales', '35000.00', '2026-05-19 22:57:49'), (31, 1, 8, '2026-01-01', 'Deudas comerciales', '106800.00', '2026-05-19 22:57:49'), (32, 1, 8, '2026-01-01', 'Retiros socios', '34800.00', '2026-05-19 22:57:49'), (33, 1, 9, '2026-02-01', 'Banco', '172800.00', '2026-05-19 22:57:49'), (34, 1, 9, '2026-02-01', 'Creditos comerciales', '35700.00', '2026-05-19 22:57:49'), (35, 1, 9, '2026-02-01', 'Deudas comerciales', '135600.00', '2026-05-19 22:57:49'), (36, 1, 9, '2026-02-01', 'Retiros socios', '21200.00', '2026-05-19 22:57:49'), (37, 1, 10, '2026-03-01', 'Banco', '153000.00', '2026-05-19 22:57:49'), (38, 1, 10, '2026-03-01', 'Creditos comerciales', '40250.00', '2026-05-19 22:57:49'), (39, 1, 10, '2026-03-01', 'Deudas comerciales', '142800.00', '2026-05-19 22:57:49'), (40, 1, 10, '2026-03-01', 'Retiros socios', '56800.00', '2026-05-19 22:57:49'), (41, 1, 11, '2026-04-01', 'Banco', '176400.00', '2026-05-19 22:57:49'), (42, 1, 11, '2026-04-01', 'Creditos comerciales', '41300.00', '2026-05-19 22:57:49'), (43, 1, 11, '2026-04-01', 'Deudas comerciales', '124800.00', '2026-05-19 22:57:49'), (44, 1, 11, '2026-04-01', 'Retiros socios', '44000.00', '2026-05-19 22:57:49'), (45, 1, 12, '2026-05-01', 'Banco', '153000.00', '2026-05-19 22:57:49'), (46, 1, 12, '2026-05-01', 'Creditos comerciales', '37100.00', '2026-05-19 22:57:49'), (47, 1, 12, '2026-05-01', 'Deudas comerciales', '122400.00', '2026-05-19 22:57:49'), (48, 1, 12, '2026-05-01', 'Retiros socios', '20000.00', '2026-05-19 22:57:49'), (49, 2, 13, '2025-06-01', 'Banco', '156600.00', '2026-05-19 22:57:49'), (50, 2, 13, '2025-06-01', 'Creditos comerciales', '43050.00', '2026-05-19 22:57:49'), (51, 2, 13, '2025-06-01', 'Deudas comerciales', '100800.00', '2026-05-19 22:57:49'), (52, 2, 13, '2025-06-01', 'Retiros socios', '24800.00', '2026-05-19 22:57:49'), (53, 2, 14, '2025-07-01', 'Banco', '172800.00', '2026-05-19 22:57:49'), (54, 2, 14, '2025-07-01', 'Creditos comerciales', '40950.00', '2026-05-19 22:57:49'), (55, 2, 14, '2025-07-01', 'Deudas comerciales', '103200.00', '2026-05-19 22:57:49'), (56, 2, 14, '2025-07-01', 'Retiros socios', '58000.00', '2026-05-19 22:57:49'), (57, 2, 15, '2025-08-01', 'Banco', '183600.00', '2026-05-19 22:57:49'), (58, 2, 15, '2025-08-01', 'Creditos comerciales', '37800.00', '2026-05-19 22:57:49'), (59, 2, 15, '2025-08-01', 'Deudas comerciales', '126000.00', '2026-05-19 22:57:49'), (60, 2, 15, '2025-08-01', 'Retiros socios', '50000.00', '2026-05-19 22:57:49'), (61, 2, 16, '2025-09-01', 'Banco', '160200.00', '2026-05-19 22:57:49'), (62, 2, 16, '2025-09-01', 'Creditos comerciales', '44100.00', '2026-05-19 22:57:49'), (63, 2, 16, '2025-09-01', 'Deudas comerciales', '99600.00', '2026-05-19 22:57:49'), (64, 2, 16, '2025-09-01', 'Retiros socios', '54800.00', '2026-05-19 22:57:49'), (65, 2, 17, '2025-10-01', 'Banco', '187200.00', '2026-05-19 22:57:49'), (66, 2, 17, '2025-10-01', 'Creditos comerciales', '28000.00', '2026-05-19 22:57:49'), (67, 2, 17, '2025-10-01', 'Deudas comerciales', '97200.00', '2026-05-19 22:57:49'), (68, 2, 17, '2025-10-01', 'Retiros socios', '44000.00', '2026-05-19 22:57:49'), (69, 2, 18, '2025-11-01', 'Banco', '167400.00', '2026-05-19 22:57:49'), (70, 2, 18, '2025-11-01', 'Creditos comerciales', '25550.00', '2026-05-19 22:57:49'), (71, 2, 18, '2025-11-01', 'Deudas comerciales', '100800.00', '2026-05-19 22:57:49'), (72, 2, 18, '2025-11-01', 'Retiros socios', '22400.00', '2026-05-19 22:57:49'), (73, 2, 19, '2025-12-01', 'Banco', '158400.00', '2026-05-19 22:57:49'), (74, 2, 19, '2025-12-01', 'Creditos comerciales', '37800.00', '2026-05-19 22:57:49'), (75, 2, 19, '2025-12-01', 'Deudas comerciales', '116400.00', '2026-05-19 22:57:49'), (76, 2, 19, '2025-12-01', 'Retiros socios', '30000.00', '2026-05-19 22:57:49'), (77, 2, 20, '2026-01-01', 'Banco', '176400.00', '2026-05-19 22:57:49'), (78, 2, 20, '2026-01-01', 'Creditos comerciales', '32900.00', '2026-05-19 22:57:49'), (79, 2, 20, '2026-01-01', 'Deudas comerciales', '112800.00', '2026-05-19 22:57:49'), (80, 2, 20, '2026-01-01', 'Retiros socios', '48800.00', '2026-05-19 22:57:49'), (81, 2, 21, '2026-02-01', 'Banco', '212400.00', '2026-05-19 22:57:49'), (82, 2, 21, '2026-02-01', 'Creditos comerciales', '43750.00', '2026-05-19 22:57:49'), (83, 2, 21, '2026-02-01', 'Deudas comerciales', '134400.00', '2026-05-19 22:57:49'), (84, 2, 21, '2026-02-01', 'Retiros socios', '52800.00', '2026-05-19 22:57:49'), (85, 2, 22, '2026-03-01', 'Banco', '145800.00', '2026-05-19 22:57:49'), (86, 2, 22, '2026-03-01', 'Creditos comerciales', '42350.00', '2026-05-19 22:57:49'), (87, 2, 22, '2026-03-01', 'Deudas comerciales', '105600.00', '2026-05-19 22:57:49'), (88, 2, 22, '2026-03-01', 'Retiros socios', '27200.00', '2026-05-19 22:57:49'), (89, 2, 23, '2026-04-01', 'Banco', '178200.00', '2026-05-19 22:57:49'), (90, 2, 23, '2026-04-01', 'Creditos comerciales', '39550.00', '2026-05-19 22:57:49'), (91, 2, 23, '2026-04-01', 'Deudas comerciales', '103200.00', '2026-05-19 22:57:49'), (92, 2, 23, '2026-04-01', 'Retiros socios', '33200.00', '2026-05-19 22:57:49'), (93, 2, 24, '2026-05-01', 'Banco', '160200.00', '2026-05-19 22:57:49'), (94, 2, 24, '2026-05-01', 'Creditos comerciales', '25200.00', '2026-05-19 22:57:49'), (95, 2, 24, '2026-05-01', 'Deudas comerciales', '135600.00', '2026-05-19 22:57:49'), (96, 2, 24, '2026-05-01', 'Retiros socios', '28400.00', '2026-05-19 22:57:49'), (97, 3, 25, '2026-03-31', 'Banco', '9445510.00', '2026-05-19 23:19:24'), (98, 3, 25, '2026-03-31', 'Creditos comerciales', '2876747.00', '2026-05-19 23:19:24'), (99, 3, 25, '2026-03-31', 'Deudas comerciales', '8537383.00', '2026-05-19 23:19:24'), (100, 3, 25, '2026-03-31', 'Retiros utilidades', '1100000.00', '2026-05-19 23:19:24'), (119, 3, 30, '2026-02-28', 'Banco', '9070017.56', '2026-05-30 17:41:51'), (120, 3, 30, '2026-02-28', 'Creditos comerciales', '2851885.02', '2026-05-30 17:41:51'), (121, 3, 30, '2026-02-28', 'Deudas comerciales', '11699746.49', '2026-05-30 17:41:51'), (122, 3, 30, '2026-02-28', 'Retiros socios', '1184600.00', '2026-05-30 17:41:51'), (131, 3, 47, '2026-04-30', 'Banco', '5909458.00', '2026-06-04 13:56:57'), (132, 3, 47, '2026-04-30', 'Creditos comerciales', '2948352.00', '2026-06-04 13:56:57'), (133, 3, 47, '2026-04-30', 'Deudas comerciales', '6381885.00', '2026-06-04 13:56:57'), (134, 3, 47, '2026-04-30', 'Retiros socios', '1419000.00', '2026-06-04 13:56:57'), (135, 3, 31, '2026-01-31', 'Banco', '6211128.45', '2026-06-06 22:37:11'), (136, 3, 31, '2026-01-31', 'Creditos comerciales', '2935924.00', '2026-06-06 22:37:11'), (137, 3, 31, '2026-01-31', 'Deudas comerciales', '9008483.00', '2026-06-06 22:37:11'), (138, 3, 31, '2026-01-31', 'Retiros socios', '1100000.00', '2026-06-06 22:37:11'); -- -------------------------------------------------------- -- -- Table structure for table `mermas` -- CREATE TABLE `mermas` ( `id` int(10) UNSIGNED NOT NULL, `empresa_id` int(10) UNSIGNED NOT NULL, `periodo_id` int(10) UNSIGNED NOT NULL, `fecha` date NOT NULL, `producto` varchar(80) NOT NULL DEFAULT '', `litros_merma` decimal(14,3) NOT NULL DEFAULT 0.000, `created_at` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `mermas` -- INSERT INTO `mermas` (`id`, `empresa_id`, `periodo_id`, `fecha`, `producto`, `litros_merma`, `created_at`) VALUES (1, 1, 1, '2025-06-01', 'Gasoil', '145.900', '2026-05-19 22:57:49'), (2, 1, 1, '2025-06-01', 'Súper', '157.600', '2026-05-19 22:57:49'), (3, 1, 1, '2025-06-01', 'Premium', '91.500', '2026-05-19 22:57:49'), (4, 1, 1, '2025-06-01', 'Gasoil Especial', '195.300', '2026-05-19 22:57:49'), (5, 1, 2, '2025-07-01', 'Gasoil', '200.000', '2026-05-19 22:57:49'), (6, 1, 2, '2025-07-01', 'Súper', '74.700', '2026-05-19 22:57:49'), (7, 1, 2, '2025-07-01', 'Premium', '170.800', '2026-05-19 22:57:49'), (8, 1, 2, '2025-07-01', 'Gasoil Especial', '119.100', '2026-05-19 22:57:49'), (9, 1, 3, '2025-08-01', 'Gasoil', '162.300', '2026-05-19 22:57:49'), (10, 1, 3, '2025-08-01', 'Súper', '180.100', '2026-05-19 22:57:49'), (11, 1, 3, '2025-08-01', 'Premium', '168.400', '2026-05-19 22:57:49'), (12, 1, 3, '2025-08-01', 'Gasoil Especial', '194.800', '2026-05-19 22:57:49'), (13, 1, 4, '2025-09-01', 'Gasoil', '93.800', '2026-05-19 22:57:49'), (14, 1, 4, '2025-09-01', 'Súper', '195.500', '2026-05-19 22:57:49'), (15, 1, 4, '2025-09-01', 'Premium', '79.200', '2026-05-19 22:57:49'), (16, 1, 4, '2025-09-01', 'Gasoil Especial', '71.100', '2026-05-19 22:57:49'), (17, 1, 5, '2025-10-01', 'Gasoil', '196.200', '2026-05-19 22:57:49'), (18, 1, 5, '2025-10-01', 'Súper', '188.300', '2026-05-19 22:57:49'), (19, 1, 5, '2025-10-01', 'Premium', '185.100', '2026-05-19 22:57:49'), (20, 1, 5, '2025-10-01', 'Gasoil Especial', '139.300', '2026-05-19 22:57:49'), (21, 1, 6, '2025-11-01', 'Gasoil', '122.500', '2026-05-19 22:57:49'), (22, 1, 6, '2025-11-01', 'Súper', '189.700', '2026-05-19 22:57:49'), (23, 1, 6, '2025-11-01', 'Premium', '116.100', '2026-05-19 22:57:49'), (24, 1, 6, '2025-11-01', 'Gasoil Especial', '69.700', '2026-05-19 22:57:49'), (25, 1, 7, '2025-12-01', 'Gasoil', '118.300', '2026-05-19 22:57:49'), (26, 1, 7, '2025-12-01', 'Súper', '197.700', '2026-05-19 22:57:49'), (27, 1, 7, '2025-12-01', 'Premium', '73.600', '2026-05-19 22:57:49'), (28, 1, 7, '2025-12-01', 'Gasoil Especial', '138.600', '2026-05-19 22:57:49'), (29, 1, 8, '2026-01-01', 'Gasoil', '89.200', '2026-05-19 22:57:49'), (30, 1, 8, '2026-01-01', 'Súper', '192.000', '2026-05-19 22:57:49'), (31, 1, 8, '2026-01-01', 'Premium', '50.000', '2026-05-19 22:57:49'), (32, 1, 8, '2026-01-01', 'Gasoil Especial', '193.900', '2026-05-19 22:57:49'), (33, 1, 9, '2026-02-01', 'Gasoil', '55.000', '2026-05-19 22:57:49'), (34, 1, 9, '2026-02-01', 'Súper', '96.000', '2026-05-19 22:57:49'), (35, 1, 9, '2026-02-01', 'Premium', '177.500', '2026-05-19 22:57:49'), (36, 1, 9, '2026-02-01', 'Gasoil Especial', '150.500', '2026-05-19 22:57:49'), (37, 1, 10, '2026-03-01', 'Gasoil', '200.200', '2026-05-19 22:57:49'), (38, 1, 10, '2026-03-01', 'Súper', '75.600', '2026-05-19 22:57:49'), (39, 1, 10, '2026-03-01', 'Premium', '135.000', '2026-05-19 22:57:49'), (40, 1, 10, '2026-03-01', 'Gasoil Especial', '111.000', '2026-05-19 22:57:49'), (41, 1, 11, '2026-04-01', 'Gasoil', '74.800', '2026-05-19 22:57:49'), (42, 1, 11, '2026-04-01', 'Súper', '51.100', '2026-05-19 22:57:49'), (43, 1, 11, '2026-04-01', 'Premium', '100.100', '2026-05-19 22:57:49'), (44, 1, 11, '2026-04-01', 'Gasoil Especial', '89.600', '2026-05-19 22:57:49'), (45, 1, 12, '2026-05-01', 'Gasoil', '151.200', '2026-05-19 22:57:49'), (46, 1, 12, '2026-05-01', 'Súper', '60.700', '2026-05-19 22:57:49'), (47, 1, 12, '2026-05-01', 'Premium', '140.900', '2026-05-19 22:57:49'), (48, 1, 12, '2026-05-01', 'Gasoil Especial', '109.100', '2026-05-19 22:57:49'), (49, 2, 13, '2025-06-01', 'Gasoil', '104.900', '2026-05-19 22:57:49'), (50, 2, 13, '2025-06-01', 'Súper', '162.100', '2026-05-19 22:57:49'), (51, 2, 13, '2025-06-01', 'Premium', '65.200', '2026-05-19 22:57:49'), (52, 2, 13, '2025-06-01', 'Gasoil Especial', '142.200', '2026-05-19 22:57:49'), (53, 2, 14, '2025-07-01', 'Gasoil', '137.800', '2026-05-19 22:57:49'), (54, 2, 14, '2025-07-01', 'Súper', '164.800', '2026-05-19 22:57:49'), (55, 2, 14, '2025-07-01', 'Premium', '154.300', '2026-05-19 22:57:49'), (56, 2, 14, '2025-07-01', 'Gasoil Especial', '167.000', '2026-05-19 22:57:49'), (57, 2, 15, '2025-08-01', 'Gasoil', '197.800', '2026-05-19 22:57:49'), (58, 2, 15, '2025-08-01', 'Súper', '71.900', '2026-05-19 22:57:49'), (59, 2, 15, '2025-08-01', 'Premium', '154.200', '2026-05-19 22:57:49'), (60, 2, 15, '2025-08-01', 'Gasoil Especial', '154.300', '2026-05-19 22:57:49'), (61, 2, 16, '2025-09-01', 'Gasoil', '66.100', '2026-05-19 22:57:49'), (62, 2, 16, '2025-09-01', 'Súper', '69.000', '2026-05-19 22:57:49'), (63, 2, 16, '2025-09-01', 'Premium', '111.400', '2026-05-19 22:57:49'), (64, 2, 16, '2025-09-01', 'Gasoil Especial', '124.000', '2026-05-19 22:57:49'), (65, 2, 17, '2025-10-01', 'Gasoil', '102.300', '2026-05-19 22:57:49'), (66, 2, 17, '2025-10-01', 'Súper', '73.400', '2026-05-19 22:57:49'), (67, 2, 17, '2025-10-01', 'Premium', '174.300', '2026-05-19 22:57:49'), (68, 2, 17, '2025-10-01', 'Gasoil Especial', '111.100', '2026-05-19 22:57:49'), (69, 2, 18, '2025-11-01', 'Gasoil', '159.000', '2026-05-19 22:57:49'), (70, 2, 18, '2025-11-01', 'Súper', '71.600', '2026-05-19 22:57:49'), (71, 2, 18, '2025-11-01', 'Premium', '137.000', '2026-05-19 22:57:49'), (72, 2, 18, '2025-11-01', 'Gasoil Especial', '57.400', '2026-05-19 22:57:49'), (73, 2, 19, '2025-12-01', 'Gasoil', '71.700', '2026-05-19 22:57:49'), (74, 2, 19, '2025-12-01', 'Súper', '65.900', '2026-05-19 22:57:49'), (75, 2, 19, '2025-12-01', 'Premium', '59.700', '2026-05-19 22:57:49'), (76, 2, 19, '2025-12-01', 'Gasoil Especial', '153.100', '2026-05-19 22:57:49'), (77, 2, 20, '2026-01-01', 'Gasoil', '132.400', '2026-05-19 22:57:49'), (78, 2, 20, '2026-01-01', 'Súper', '63.400', '2026-05-19 22:57:49'), (79, 2, 20, '2026-01-01', 'Premium', '152.400', '2026-05-19 22:57:49'), (80, 2, 20, '2026-01-01', 'Gasoil Especial', '115.400', '2026-05-19 22:57:49'), (81, 2, 21, '2026-02-01', 'Gasoil', '193.600', '2026-05-19 22:57:49'), (82, 2, 21, '2026-02-01', 'Súper', '180.900', '2026-05-19 22:57:49'), (83, 2, 21, '2026-02-01', 'Premium', '134.900', '2026-05-19 22:57:49'), (84, 2, 21, '2026-02-01', 'Gasoil Especial', '94.400', '2026-05-19 22:57:49'), (85, 2, 22, '2026-03-01', 'Gasoil', '132.100', '2026-05-19 22:57:49'), (86, 2, 22, '2026-03-01', 'Súper', '70.900', '2026-05-19 22:57:49'), (87, 2, 22, '2026-03-01', 'Premium', '92.400', '2026-05-19 22:57:49'), (88, 2, 22, '2026-03-01', 'Gasoil Especial', '57.300', '2026-05-19 22:57:49'), (89, 2, 23, '2026-04-01', 'Gasoil', '82.200', '2026-05-19 22:57:49'), (90, 2, 23, '2026-04-01', 'Súper', '196.900', '2026-05-19 22:57:49'), (91, 2, 23, '2026-04-01', 'Premium', '97.800', '2026-05-19 22:57:49'), (92, 2, 23, '2026-04-01', 'Gasoil Especial', '100.400', '2026-05-19 22:57:49'), (93, 2, 24, '2026-05-01', 'Gasoil', '58.400', '2026-05-19 22:57:49'), (94, 2, 24, '2026-05-01', 'Súper', '191.300', '2026-05-19 22:57:49'), (95, 2, 24, '2026-05-01', 'Premium', '109.800', '2026-05-19 22:57:49'), (96, 2, 24, '2026-05-01', 'Gasoil Especial', '123.100', '2026-05-19 22:57:49'), (101, 3, 25, '2026-03-31', 'Gasoil', '-3.000', '2026-06-03 16:26:12'), (102, 3, 25, '2026-03-31', 'Gasoil Especial', '-30.000', '2026-06-03 16:26:12'), (103, 3, 25, '2026-03-31', 'Premium', '-176.000', '2026-06-03 16:26:12'), (104, 3, 25, '2026-03-31', 'Súper', '925.000', '2026-06-03 16:26:12'), (116, 3, 47, '2026-04-30', 'Gasoil', '-35.000', '2026-06-04 16:34:00'), (117, 3, 47, '2026-04-30', 'Gasoil Especial', '-11.000', '2026-06-04 16:34:00'), (118, 3, 47, '2026-04-30', 'Premium', '-24.000', '2026-06-04 16:34:01'), (119, 3, 47, '2026-04-30', 'Súper', '-138.000', '2026-06-04 16:34:01'), (120, 3, 30, '2026-02-28', 'Súper', '-154.000', '2026-06-08 16:17:03'), (121, 3, 30, '2026-02-28', 'Premium', '-111.000', '2026-06-08 16:17:03'), (122, 3, 30, '2026-02-28', 'Gasoil', '-79.000', '2026-06-08 16:17:03'), (123, 3, 30, '2026-02-28', 'Gasoil Especial', '-18.000', '2026-06-08 16:17:03'); -- -------------------------------------------------------- -- -- Table structure for table `migrations` -- CREATE TABLE `migrations` ( `id` int(11) NOT NULL, `migration` varchar(255) NOT NULL, `applied_at` timestamp NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `migrations` -- INSERT INTO `migrations` (`id`, `migration`, `applied_at`) VALUES (1, '20260519_000001_CreateEmpresasTable.php', '2026-05-19 22:57:29'), (2, '20260519_000002_CreateUsuariosTable.php', '2026-05-19 22:57:29'), (3, '20260519_000003_CreatePeriodosTable.php', '2026-05-19 22:57:29'), (4, '20260519_000004_CreateVentasTable.php', '2026-05-19 22:57:29'), (5, '20260519_000005_CreateCostosTable.php', '2026-05-19 22:57:29'), (6, '20260519_000006_CreateStockTable.php', '2026-05-19 22:57:29'), (7, '20260519_000007_CreateMermasTable.php', '2026-05-19 22:57:29'), (8, '20260519_000008_CreateFinanzasTable.php', '2026-05-19 22:57:29'), (9, '20260519_000009_CreatePersonalTable.php', '2026-05-19 22:57:29'), (10, '20260519_000010_CreateParametrosTable.php', '2026-05-19 22:57:29'), (11, '20260520_000011_CreateConfiguracionesTable.php', '2026-05-20 13:19:45'), (12, '20260520_000012_CreateCustomWidgetsTable.php', '2026-05-20 22:12:32'); -- -------------------------------------------------------- -- -- Table structure for table `parametros` -- CREATE TABLE `parametros` ( `id` int(10) UNSIGNED NOT NULL, `empresa_id` int(10) UNSIGNED NOT NULL, `periodo_id` int(10) UNSIGNED NOT NULL, `parametro` varchar(100) NOT NULL, `valor` varchar(255) NOT NULL DEFAULT '', `created_at` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `parametros` -- INSERT INTO `parametros` (`id`, `empresa_id`, `periodo_id`, `parametro`, `valor`, `created_at`) VALUES (1, 1, 1, 'objetivo_margen_litro', '2.50', '2026-05-19 22:57:49'), (2, 1, 1, 'objetivo_retiros_resultado', '50', '2026-05-19 22:57:49'), (3, 1, 1, 'fecha_vencimiento_contrato', '2027-11-20', '2026-05-19 22:57:49'), (4, 1, 1, 'moneda', 'UYU', '2026-05-19 22:57:49'), (5, 1, 2, 'objetivo_margen_litro', '2.50', '2026-05-19 22:57:49'), (6, 1, 2, 'objetivo_retiros_resultado', '50', '2026-05-19 22:57:49'), (7, 1, 2, 'fecha_vencimiento_contrato', '2027-11-20', '2026-05-19 22:57:49'), (8, 1, 2, 'moneda', 'UYU', '2026-05-19 22:57:49'), (9, 1, 3, 'objetivo_margen_litro', '2.50', '2026-05-19 22:57:49'), (10, 1, 3, 'objetivo_retiros_resultado', '50', '2026-05-19 22:57:49'), (11, 1, 3, 'fecha_vencimiento_contrato', '2027-11-20', '2026-05-19 22:57:49'), (12, 1, 3, 'moneda', 'UYU', '2026-05-19 22:57:49'), (13, 1, 4, 'objetivo_margen_litro', '2.50', '2026-05-19 22:57:49'), (14, 1, 4, 'objetivo_retiros_resultado', '50', '2026-05-19 22:57:49'), (15, 1, 4, 'fecha_vencimiento_contrato', '2027-11-20', '2026-05-19 22:57:49'), (16, 1, 4, 'moneda', 'UYU', '2026-05-19 22:57:49'), (17, 1, 5, 'objetivo_margen_litro', '2.50', '2026-05-19 22:57:49'), (18, 1, 5, 'objetivo_retiros_resultado', '50', '2026-05-19 22:57:49'), (19, 1, 5, 'fecha_vencimiento_contrato', '2027-11-20', '2026-05-19 22:57:49'), (20, 1, 5, 'moneda', 'UYU', '2026-05-19 22:57:49'), (21, 1, 6, 'objetivo_margen_litro', '2.50', '2026-05-19 22:57:49'), (22, 1, 6, 'objetivo_retiros_resultado', '50', '2026-05-19 22:57:49'), (23, 1, 6, 'fecha_vencimiento_contrato', '2027-11-20', '2026-05-19 22:57:49'), (24, 1, 6, 'moneda', 'UYU', '2026-05-19 22:57:49'), (25, 1, 7, 'objetivo_margen_litro', '2.50', '2026-05-19 22:57:49'), (26, 1, 7, 'objetivo_retiros_resultado', '50', '2026-05-19 22:57:49'), (27, 1, 7, 'fecha_vencimiento_contrato', '2027-11-20', '2026-05-19 22:57:49'), (28, 1, 7, 'moneda', 'UYU', '2026-05-19 22:57:49'), (29, 1, 8, 'objetivo_margen_litro', '2.50', '2026-05-19 22:57:49'), (30, 1, 8, 'objetivo_retiros_resultado', '50', '2026-05-19 22:57:49'), (31, 1, 8, 'fecha_vencimiento_contrato', '2027-11-20', '2026-05-19 22:57:49'), (32, 1, 8, 'moneda', 'UYU', '2026-05-19 22:57:49'), (33, 1, 9, 'objetivo_margen_litro', '2.50', '2026-05-19 22:57:49'), (34, 1, 9, 'objetivo_retiros_resultado', '50', '2026-05-19 22:57:49'), (35, 1, 9, 'fecha_vencimiento_contrato', '2027-11-20', '2026-05-19 22:57:49'), (36, 1, 9, 'moneda', 'UYU', '2026-05-19 22:57:49'), (37, 1, 10, 'objetivo_margen_litro', '2.50', '2026-05-19 22:57:49'), (38, 1, 10, 'objetivo_retiros_resultado', '50', '2026-05-19 22:57:49'), (39, 1, 10, 'fecha_vencimiento_contrato', '2027-11-20', '2026-05-19 22:57:49'), (40, 1, 10, 'moneda', 'UYU', '2026-05-19 22:57:49'), (41, 1, 11, 'objetivo_margen_litro', '2.50', '2026-05-19 22:57:49'), (42, 1, 11, 'objetivo_retiros_resultado', '50', '2026-05-19 22:57:49'), (43, 1, 11, 'fecha_vencimiento_contrato', '2027-11-20', '2026-05-19 22:57:49'), (44, 1, 11, 'moneda', 'UYU', '2026-05-19 22:57:49'), (45, 1, 12, 'objetivo_margen_litro', '2.50', '2026-05-19 22:57:49'), (46, 1, 12, 'objetivo_retiros_resultado', '50', '2026-05-19 22:57:49'), (47, 1, 12, 'fecha_vencimiento_contrato', '2027-11-20', '2026-05-19 22:57:49'), (48, 1, 12, 'moneda', 'UYU', '2026-05-19 22:57:49'), (49, 2, 13, 'objetivo_margen_litro', '2.50', '2026-05-19 22:57:49'), (50, 2, 13, 'objetivo_retiros_resultado', '50', '2026-05-19 22:57:49'), (51, 2, 13, 'fecha_vencimiento_contrato', '2027-11-20', '2026-05-19 22:57:49'), (52, 2, 13, 'moneda', 'UYU', '2026-05-19 22:57:49'), (53, 2, 14, 'objetivo_margen_litro', '2.50', '2026-05-19 22:57:49'), (54, 2, 14, 'objetivo_retiros_resultado', '50', '2026-05-19 22:57:49'), (55, 2, 14, 'fecha_vencimiento_contrato', '2027-11-20', '2026-05-19 22:57:49'), (56, 2, 14, 'moneda', 'UYU', '2026-05-19 22:57:49'), (57, 2, 15, 'objetivo_margen_litro', '2.50', '2026-05-19 22:57:49'), (58, 2, 15, 'objetivo_retiros_resultado', '50', '2026-05-19 22:57:49'), (59, 2, 15, 'fecha_vencimiento_contrato', '2027-11-20', '2026-05-19 22:57:49'), (60, 2, 15, 'moneda', 'UYU', '2026-05-19 22:57:49'), (61, 2, 16, 'objetivo_margen_litro', '2.50', '2026-05-19 22:57:49'), (62, 2, 16, 'objetivo_retiros_resultado', '50', '2026-05-19 22:57:49'), (63, 2, 16, 'fecha_vencimiento_contrato', '2027-11-20', '2026-05-19 22:57:49'), (64, 2, 16, 'moneda', 'UYU', '2026-05-19 22:57:49'), (65, 2, 17, 'objetivo_margen_litro', '2.50', '2026-05-19 22:57:49'), (66, 2, 17, 'objetivo_retiros_resultado', '50', '2026-05-19 22:57:49'), (67, 2, 17, 'fecha_vencimiento_contrato', '2027-11-20', '2026-05-19 22:57:49'), (68, 2, 17, 'moneda', 'UYU', '2026-05-19 22:57:49'), (69, 2, 18, 'objetivo_margen_litro', '2.50', '2026-05-19 22:57:49'), (70, 2, 18, 'objetivo_retiros_resultado', '50', '2026-05-19 22:57:49'), (71, 2, 18, 'fecha_vencimiento_contrato', '2027-11-20', '2026-05-19 22:57:49'), (72, 2, 18, 'moneda', 'UYU', '2026-05-19 22:57:49'), (73, 2, 19, 'objetivo_margen_litro', '2.50', '2026-05-19 22:57:49'), (74, 2, 19, 'objetivo_retiros_resultado', '50', '2026-05-19 22:57:49'), (75, 2, 19, 'fecha_vencimiento_contrato', '2027-11-20', '2026-05-19 22:57:49'), (76, 2, 19, 'moneda', 'UYU', '2026-05-19 22:57:49'), (77, 2, 20, 'objetivo_margen_litro', '2.50', '2026-05-19 22:57:49'), (78, 2, 20, 'objetivo_retiros_resultado', '50', '2026-05-19 22:57:49'), (79, 2, 20, 'fecha_vencimiento_contrato', '2027-11-20', '2026-05-19 22:57:49'), (80, 2, 20, 'moneda', 'UYU', '2026-05-19 22:57:49'), (81, 2, 21, 'objetivo_margen_litro', '2.50', '2026-05-19 22:57:49'), (82, 2, 21, 'objetivo_retiros_resultado', '50', '2026-05-19 22:57:49'), (83, 2, 21, 'fecha_vencimiento_contrato', '2027-11-20', '2026-05-19 22:57:49'), (84, 2, 21, 'moneda', 'UYU', '2026-05-19 22:57:49'), (85, 2, 22, 'objetivo_margen_litro', '2.50', '2026-05-19 22:57:49'), (86, 2, 22, 'objetivo_retiros_resultado', '50', '2026-05-19 22:57:49'), (87, 2, 22, 'fecha_vencimiento_contrato', '2027-11-20', '2026-05-19 22:57:49'), (88, 2, 22, 'moneda', 'UYU', '2026-05-19 22:57:49'), (89, 2, 23, 'objetivo_margen_litro', '2.50', '2026-05-19 22:57:49'), (90, 2, 23, 'objetivo_retiros_resultado', '50', '2026-05-19 22:57:49'), (91, 2, 23, 'fecha_vencimiento_contrato', '2027-11-20', '2026-05-19 22:57:49'), (92, 2, 23, 'moneda', 'UYU', '2026-05-19 22:57:49'), (93, 2, 24, 'objetivo_margen_litro', '2.50', '2026-05-19 22:57:49'), (94, 2, 24, 'objetivo_retiros_resultado', '50', '2026-05-19 22:57:49'), (95, 2, 24, 'fecha_vencimiento_contrato', '2027-11-20', '2026-05-19 22:57:49'), (96, 2, 24, 'moneda', 'UYU', '2026-05-19 22:57:49'), (97, 3, 25, 'fecha panel', '46112', '2026-05-19 23:19:24'), (98, 3, 25, 'mes_label', '46082', '2026-05-19 23:19:24'), (99, 3, 25, 'moneda', 'UYU', '2026-05-19 23:19:24'), (100, 3, 25, 'objetivo_margen_litro', '0.12', '2026-05-19 23:19:24'), (101, 3, 25, 'objetivo_retiros_resultado', '0.5', '2026-05-19 23:19:24'), (102, 3, 25, 'objetivo_costos_fijos_ventas', '0.1', '2026-05-19 23:19:24'), (103, 3, 25, 'fecha_vencimiento_contrato', '2032-02-14', '2026-05-19 23:19:24'), (104, 3, 25, 'dias_contrato', '', '2026-05-19 23:34:02'), (105, 3, 47, 'objetivo_margen_litro', '2.50', '2026-06-04 13:58:37'), (106, 3, 47, 'objetivo_retiros_resultado', '50', '2026-06-04 13:58:37'), (107, 3, 47, 'dias_contrato', '', '2026-06-04 13:58:37'), (108, 3, 47, 'fecha_vencimiento_contrato', '2032-02-14', '2026-06-04 13:58:37'), (109, 3, 47, 'moneda', 'UYU', '2026-06-04 13:58:37'), (110, 3, 31, 'objetivo_margen_litro', '1.20', '2026-06-04 18:28:37'), (111, 3, 31, 'objetivo_retiros_resultado', '50', '2026-06-04 18:28:37'), (112, 3, 31, 'dias_contrato', '', '2026-06-04 18:28:37'), (113, 3, 31, 'fecha_vencimiento_contrato', '2032-12-02', '2026-06-04 18:28:37'), (114, 3, 31, 'moneda', 'UYU', '2026-06-04 18:28:37'), (115, 3, 30, 'objetivo_margen_litro', '1.20', '2026-06-04 19:47:11'), (116, 3, 30, 'objetivo_retiros_resultado', '50', '2026-06-04 19:47:11'), (117, 3, 30, 'dias_contrato', '', '2026-06-04 19:47:11'), (118, 3, 30, 'fecha_vencimiento_contrato', '2032-12-02', '2026-06-04 19:47:11'), (119, 3, 30, 'moneda', 'UYU', '2026-06-04 19:47:11'); -- -------------------------------------------------------- -- -- Table structure for table `periodos` -- CREATE TABLE `periodos` ( `id` int(10) UNSIGNED NOT NULL, `empresa_id` int(10) UNSIGNED NOT NULL, `fecha` date NOT NULL COMMENT 'Primer día del mes', `mes` tinyint(4) NOT NULL COMMENT '1-12', `anio` smallint(6) NOT NULL, `moneda` varchar(5) NOT NULL DEFAULT 'UYU', `estado` enum('borrador','publicado') NOT NULL DEFAULT 'borrador', `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `periodos` -- INSERT INTO `periodos` (`id`, `empresa_id`, `fecha`, `mes`, `anio`, `moneda`, `estado`, `created_at`, `updated_at`) VALUES (1, 1, '2025-06-01', 6, 2025, 'UYU', 'publicado', '2026-05-19 22:57:48', '2026-05-19 22:57:48'), (2, 1, '2025-07-01', 7, 2025, 'UYU', 'publicado', '2026-05-19 22:57:49', '2026-05-19 22:57:49'), (3, 1, '2025-08-01', 8, 2025, 'UYU', 'publicado', '2026-05-19 22:57:49', '2026-05-19 22:57:49'), (4, 1, '2025-09-01', 9, 2025, 'UYU', 'publicado', '2026-05-19 22:57:49', '2026-05-19 22:57:49'), (5, 1, '2025-10-01', 10, 2025, 'UYU', 'publicado', '2026-05-19 22:57:49', '2026-05-19 22:57:49'), (6, 1, '2025-11-01', 11, 2025, 'UYU', 'publicado', '2026-05-19 22:57:49', '2026-05-19 22:57:49'), (7, 1, '2025-12-01', 12, 2025, 'UYU', 'publicado', '2026-05-19 22:57:49', '2026-05-19 22:57:49'), (8, 1, '2026-01-01', 1, 2026, 'UYU', 'publicado', '2026-05-19 22:57:49', '2026-05-19 22:57:49'), (9, 1, '2026-02-01', 2, 2026, 'UYU', 'publicado', '2026-05-19 22:57:49', '2026-05-19 22:57:49'), (10, 1, '2026-03-01', 3, 2026, 'UYU', 'publicado', '2026-05-19 22:57:49', '2026-05-19 22:57:49'), (11, 1, '2026-04-01', 4, 2026, 'UYU', 'publicado', '2026-05-19 22:57:49', '2026-05-19 22:57:49'), (12, 1, '2026-05-01', 5, 2026, 'UYU', 'publicado', '2026-05-19 22:57:49', '2026-05-19 22:57:49'), (13, 2, '2025-06-01', 6, 2025, 'UYU', 'publicado', '2026-05-19 22:57:49', '2026-05-19 22:57:49'), (14, 2, '2025-07-01', 7, 2025, 'UYU', 'publicado', '2026-05-19 22:57:49', '2026-05-19 22:57:49'), (15, 2, '2025-08-01', 8, 2025, 'UYU', 'publicado', '2026-05-19 22:57:49', '2026-05-19 22:57:49'), (16, 2, '2025-09-01', 9, 2025, 'UYU', 'publicado', '2026-05-19 22:57:49', '2026-05-19 22:57:49'), (17, 2, '2025-10-01', 10, 2025, 'UYU', 'publicado', '2026-05-19 22:57:49', '2026-05-19 22:57:49'), (18, 2, '2025-11-01', 11, 2025, 'UYU', 'publicado', '2026-05-19 22:57:49', '2026-05-19 22:57:49'), (19, 2, '2025-12-01', 12, 2025, 'UYU', 'publicado', '2026-05-19 22:57:49', '2026-05-19 22:57:49'), (20, 2, '2026-01-01', 1, 2026, 'UYU', 'publicado', '2026-05-19 22:57:49', '2026-05-19 22:57:49'), (21, 2, '2026-02-01', 2, 2026, 'UYU', 'publicado', '2026-05-19 22:57:49', '2026-05-19 22:57:49'), (22, 2, '2026-03-01', 3, 2026, 'UYU', 'publicado', '2026-05-19 22:57:49', '2026-05-19 22:57:49'), (23, 2, '2026-04-01', 4, 2026, 'UYU', 'publicado', '2026-05-19 22:57:49', '2026-05-19 22:57:49'), (24, 2, '2026-05-01', 5, 2026, 'UYU', 'publicado', '2026-05-19 22:57:49', '2026-05-19 22:57:49'), (25, 3, '2026-03-01', 3, 2026, 'UYU', 'publicado', '2026-05-19 23:19:24', '2026-05-19 23:19:24'), (27, 4, '2026-04-01', 4, 2026, 'PYG', 'publicado', '2026-05-20 23:56:58', '2026-05-20 23:56:58'), (28, 5, '2026-05-01', 5, 2026, 'UYU', 'borrador', '2026-05-26 14:23:51', '2026-05-26 14:23:51'), (30, 3, '2026-02-01', 2, 2026, 'UYU', 'publicado', '2026-05-29 14:16:49', '2026-06-08 16:15:01'), (31, 3, '2026-01-01', 1, 2026, 'UYU', 'publicado', '2026-05-29 14:17:00', '2026-06-07 19:27:42'), (32, 3, '2025-01-01', 1, 2025, 'UYU', 'publicado', '2026-05-29 14:17:10', '2026-05-29 16:56:34'), (33, 3, '2025-02-01', 2, 2025, 'UYU', 'publicado', '2026-05-29 14:17:31', '2026-05-29 17:27:52'), (34, 3, '2025-03-01', 3, 2025, 'UYU', 'publicado', '2026-05-29 14:17:40', '2026-05-29 17:35:30'), (35, 3, '2025-04-01', 4, 2025, 'UYU', 'publicado', '2026-05-29 14:17:47', '2026-05-29 17:53:48'), (36, 3, '2025-05-01', 5, 2025, 'UYU', 'publicado', '2026-05-29 14:17:53', '2026-05-29 19:39:44'), (37, 3, '2025-06-01', 6, 2025, 'UYU', 'publicado', '2026-05-29 14:18:04', '2026-05-29 19:39:47'), (38, 3, '2025-07-01', 7, 2025, 'UYU', 'publicado', '2026-05-29 14:19:38', '2026-05-29 19:52:17'), (40, 3, '2025-09-01', 9, 2025, 'UYU', 'publicado', '2026-05-29 14:20:14', '2026-05-29 20:10:58'), (41, 3, '2025-10-01', 10, 2025, 'UYU', 'publicado', '2026-05-29 14:20:29', '2026-05-29 20:17:48'), (42, 3, '2025-11-01', 11, 2025, 'UYU', 'publicado', '2026-05-29 14:20:40', '2026-05-29 20:32:01'), (44, 3, '2025-08-01', 8, 2025, 'UYU', 'publicado', '2026-05-29 19:54:25', '2026-05-29 20:04:11'), (45, 3, '2025-12-01', 12, 2025, 'UYU', 'publicado', '2026-05-30 14:27:04', '2026-05-30 14:35:08'), (47, 3, '2026-04-01', 4, 2026, 'UYU', 'publicado', '2026-05-30 14:35:25', '2026-06-04 19:46:15'); -- -------------------------------------------------------- -- -- Table structure for table `personal` -- CREATE TABLE `personal` ( `id` int(10) UNSIGNED NOT NULL, `empresa_id` int(10) UNSIGNED NOT NULL, `periodo_id` int(10) UNSIGNED NOT NULL, `fecha` date NOT NULL, `area` varchar(80) NOT NULL DEFAULT '', `personal_total` int(11) NOT NULL DEFAULT 0, `altas_mes` int(11) NOT NULL DEFAULT 0, `bajas_mes` int(11) NOT NULL DEFAULT 0, `altas_acum` int(11) NOT NULL DEFAULT 0, `bajas_acum` int(11) NOT NULL DEFAULT 0, `created_at` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `personal` -- INSERT INTO `personal` (`id`, `empresa_id`, `periodo_id`, `fecha`, `area`, `personal_total`, `altas_mes`, `bajas_mes`, `altas_acum`, `bajas_acum`, `created_at`) VALUES (1, 1, 1, '2025-06-01', 'Pista', 12, 1, 0, 3, 0, '2026-05-19 22:57:49'), (2, 1, 1, '2025-06-01', 'Tienda/Minimercado', 4, 0, 1, 0, 2, '2026-05-19 22:57:49'), (3, 1, 1, '2025-06-01', 'Administración', 3, 0, 0, 0, 0, '2026-05-19 22:57:49'), (4, 1, 2, '2025-07-01', 'Pista', 12, 1, 0, 3, 0, '2026-05-19 22:57:49'), (5, 1, 2, '2025-07-01', 'Tienda/Minimercado', 4, 0, 1, 0, 2, '2026-05-19 22:57:49'), (6, 1, 2, '2025-07-01', 'Administración', 3, 0, 0, 0, 0, '2026-05-19 22:57:49'), (7, 1, 3, '2025-08-01', 'Pista', 12, 1, 0, 3, 0, '2026-05-19 22:57:49'), (8, 1, 3, '2025-08-01', 'Tienda/Minimercado', 4, 0, 1, 0, 2, '2026-05-19 22:57:49'), (9, 1, 3, '2025-08-01', 'Administración', 3, 0, 0, 0, 0, '2026-05-19 22:57:49'), (10, 1, 4, '2025-09-01', 'Pista', 12, 1, 0, 3, 0, '2026-05-19 22:57:49'), (11, 1, 4, '2025-09-01', 'Tienda/Minimercado', 4, 0, 1, 0, 2, '2026-05-19 22:57:49'), (12, 1, 4, '2025-09-01', 'Administración', 3, 0, 0, 0, 0, '2026-05-19 22:57:49'), (13, 1, 5, '2025-10-01', 'Pista', 12, 1, 0, 3, 0, '2026-05-19 22:57:49'), (14, 1, 5, '2025-10-01', 'Tienda/Minimercado', 4, 0, 1, 0, 2, '2026-05-19 22:57:49'), (15, 1, 5, '2025-10-01', 'Administración', 3, 0, 0, 0, 0, '2026-05-19 22:57:49'), (16, 1, 6, '2025-11-01', 'Pista', 12, 1, 0, 3, 0, '2026-05-19 22:57:49'), (17, 1, 6, '2025-11-01', 'Tienda/Minimercado', 4, 0, 1, 0, 2, '2026-05-19 22:57:49'), (18, 1, 6, '2025-11-01', 'Administración', 3, 0, 0, 0, 0, '2026-05-19 22:57:49'), (19, 1, 7, '2025-12-01', 'Pista', 12, 1, 0, 3, 0, '2026-05-19 22:57:49'), (20, 1, 7, '2025-12-01', 'Tienda/Minimercado', 4, 0, 1, 0, 2, '2026-05-19 22:57:49'), (21, 1, 7, '2025-12-01', 'Administración', 3, 0, 0, 0, 0, '2026-05-19 22:57:49'), (22, 1, 8, '2026-01-01', 'Pista', 12, 1, 0, 3, 0, '2026-05-19 22:57:49'), (23, 1, 8, '2026-01-01', 'Tienda/Minimercado', 4, 0, 1, 0, 2, '2026-05-19 22:57:49'), (24, 1, 8, '2026-01-01', 'Administración', 3, 0, 0, 0, 0, '2026-05-19 22:57:49'), (25, 1, 9, '2026-02-01', 'Pista', 12, 1, 0, 3, 0, '2026-05-19 22:57:49'), (26, 1, 9, '2026-02-01', 'Tienda/Minimercado', 4, 0, 1, 0, 2, '2026-05-19 22:57:49'), (27, 1, 9, '2026-02-01', 'Administración', 3, 0, 0, 0, 0, '2026-05-19 22:57:49'), (28, 1, 10, '2026-03-01', 'Pista', 12, 1, 0, 3, 0, '2026-05-19 22:57:49'), (29, 1, 10, '2026-03-01', 'Tienda/Minimercado', 4, 0, 1, 0, 2, '2026-05-19 22:57:49'), (30, 1, 10, '2026-03-01', 'Administración', 3, 0, 0, 0, 0, '2026-05-19 22:57:49'), (31, 1, 11, '2026-04-01', 'Pista', 12, 1, 0, 3, 0, '2026-05-19 22:57:49'), (32, 1, 11, '2026-04-01', 'Tienda/Minimercado', 4, 0, 1, 0, 2, '2026-05-19 22:57:49'), (33, 1, 11, '2026-04-01', 'Administración', 3, 0, 0, 0, 0, '2026-05-19 22:57:49'), (34, 1, 12, '2026-05-01', 'Pista', 12, 1, 0, 3, 0, '2026-05-19 22:57:49'), (35, 1, 12, '2026-05-01', 'Tienda/Minimercado', 4, 0, 1, 0, 2, '2026-05-19 22:57:49'), (36, 1, 12, '2026-05-01', 'Administración', 3, 0, 0, 0, 0, '2026-05-19 22:57:49'), (37, 2, 13, '2025-06-01', 'Pista', 12, 1, 0, 3, 0, '2026-05-19 22:57:49'), (38, 2, 13, '2025-06-01', 'Tienda/Minimercado', 4, 0, 1, 0, 2, '2026-05-19 22:57:49'), (39, 2, 13, '2025-06-01', 'Administración', 3, 0, 0, 0, 0, '2026-05-19 22:57:49'), (40, 2, 14, '2025-07-01', 'Pista', 12, 1, 0, 3, 0, '2026-05-19 22:57:49'), (41, 2, 14, '2025-07-01', 'Tienda/Minimercado', 4, 0, 1, 0, 2, '2026-05-19 22:57:49'), (42, 2, 14, '2025-07-01', 'Administración', 3, 0, 0, 0, 0, '2026-05-19 22:57:49'), (43, 2, 15, '2025-08-01', 'Pista', 12, 1, 0, 3, 0, '2026-05-19 22:57:49'), (44, 2, 15, '2025-08-01', 'Tienda/Minimercado', 4, 0, 1, 0, 2, '2026-05-19 22:57:49'), (45, 2, 15, '2025-08-01', 'Administración', 3, 0, 0, 0, 0, '2026-05-19 22:57:49'), (46, 2, 16, '2025-09-01', 'Pista', 12, 1, 0, 3, 0, '2026-05-19 22:57:49'), (47, 2, 16, '2025-09-01', 'Tienda/Minimercado', 4, 0, 1, 0, 2, '2026-05-19 22:57:49'), (48, 2, 16, '2025-09-01', 'Administración', 3, 0, 0, 0, 0, '2026-05-19 22:57:49'), (49, 2, 17, '2025-10-01', 'Pista', 12, 1, 0, 3, 0, '2026-05-19 22:57:49'), (50, 2, 17, '2025-10-01', 'Tienda/Minimercado', 4, 0, 1, 0, 2, '2026-05-19 22:57:49'), (51, 2, 17, '2025-10-01', 'Administración', 3, 0, 0, 0, 0, '2026-05-19 22:57:49'), (52, 2, 18, '2025-11-01', 'Pista', 12, 1, 0, 3, 0, '2026-05-19 22:57:49'), (53, 2, 18, '2025-11-01', 'Tienda/Minimercado', 4, 0, 1, 0, 2, '2026-05-19 22:57:49'), (54, 2, 18, '2025-11-01', 'Administración', 3, 0, 0, 0, 0, '2026-05-19 22:57:49'), (55, 2, 19, '2025-12-01', 'Pista', 12, 1, 0, 3, 0, '2026-05-19 22:57:49'), (56, 2, 19, '2025-12-01', 'Tienda/Minimercado', 4, 0, 1, 0, 2, '2026-05-19 22:57:49'), (57, 2, 19, '2025-12-01', 'Administración', 3, 0, 0, 0, 0, '2026-05-19 22:57:49'), (58, 2, 20, '2026-01-01', 'Pista', 12, 1, 0, 3, 0, '2026-05-19 22:57:49'), (59, 2, 20, '2026-01-01', 'Tienda/Minimercado', 4, 0, 1, 0, 2, '2026-05-19 22:57:49'), (60, 2, 20, '2026-01-01', 'Administración', 3, 0, 0, 0, 0, '2026-05-19 22:57:49'), (61, 2, 21, '2026-02-01', 'Pista', 12, 1, 0, 3, 0, '2026-05-19 22:57:49'), (62, 2, 21, '2026-02-01', 'Tienda/Minimercado', 4, 0, 1, 0, 2, '2026-05-19 22:57:49'), (63, 2, 21, '2026-02-01', 'Administración', 3, 0, 0, 0, 0, '2026-05-19 22:57:49'), (64, 2, 22, '2026-03-01', 'Pista', 12, 1, 0, 3, 0, '2026-05-19 22:57:49'), (65, 2, 22, '2026-03-01', 'Tienda/Minimercado', 4, 0, 1, 0, 2, '2026-05-19 22:57:49'), (66, 2, 22, '2026-03-01', 'Administración', 3, 0, 0, 0, 0, '2026-05-19 22:57:49'), (67, 2, 23, '2026-04-01', 'Pista', 12, 1, 0, 3, 0, '2026-05-19 22:57:49'), (68, 2, 23, '2026-04-01', 'Tienda/Minimercado', 4, 0, 1, 0, 2, '2026-05-19 22:57:49'), (69, 2, 23, '2026-04-01', 'Administración', 3, 0, 0, 0, 0, '2026-05-19 22:57:49'), (70, 2, 24, '2026-05-01', 'Pista', 12, 1, 0, 3, 0, '2026-05-19 22:57:49'), (71, 2, 24, '2026-05-01', 'Tienda/Minimercado', 4, 0, 1, 0, 2, '2026-05-19 22:57:49'), (72, 2, 24, '2026-05-01', 'Administración', 3, 0, 0, 0, 0, '2026-05-19 22:57:49'), (88, 3, 25, '2026-03-31', 'Administración', 2, 0, 0, 0, 0, '2026-06-04 14:03:37'), (89, 3, 25, '2026-03-31', 'Pista', 10, 3, 5, 6, 7, '2026-06-04 14:03:37'), (90, 3, 25, '2026-03-31', 'Tienda/Minimercado', 19, 0, 0, 1, 2, '2026-06-04 14:03:37'), (94, 3, 47, '2026-06-04', 'Administración', 2, 0, 0, 0, 0, '2026-06-04 14:04:20'), (95, 3, 47, '2026-04-30', 'Pista', 19, 0, 0, 1, 2, '2026-06-04 14:04:20'), (96, 3, 47, '2026-04-30', 'Tienda/Minimercado', 9, 2, 2, 8, 9, '2026-06-04 14:04:20'); -- -------------------------------------------------------- -- -- Table structure for table `stock` -- CREATE TABLE `stock` ( `id` int(10) UNSIGNED NOT NULL, `empresa_id` int(10) UNSIGNED NOT NULL, `periodo_id` int(10) UNSIGNED NOT NULL, `fecha` date NOT NULL, `unidad_negocio` varchar(80) NOT NULL DEFAULT '', `producto` varchar(80) NOT NULL DEFAULT '', `cantidad` decimal(14,3) NOT NULL DEFAULT 0.000, `unidad` varchar(20) NOT NULL DEFAULT 'lts', `costo_unitario` decimal(14,4) NOT NULL DEFAULT 0.0000, `inventario_valorizado` decimal(14,2) NOT NULL DEFAULT 0.00, `created_at` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `stock` -- INSERT INTO `stock` (`id`, `empresa_id`, `periodo_id`, `fecha`, `unidad_negocio`, `producto`, `cantidad`, `unidad`, `costo_unitario`, `inventario_valorizado`, `created_at`) VALUES (1, 1, 1, '2025-06-01', 'Combustible', 'Gasoil', '35100.000', 'lts', '38.5000', '1351350.00', '2026-05-19 22:57:49'), (2, 1, 1, '2025-06-01', 'Combustible', 'Súper', '12300.000', 'lts', '44.2000', '543660.00', '2026-05-19 22:57:49'), (3, 1, 1, '2025-06-01', 'Combustible', 'Premium', '7680.000', 'lts', '50.1000', '384768.00', '2026-05-19 22:57:49'), (4, 1, 1, '2025-06-01', 'Combustible', 'Gasoil Especial', '14040.000', 'lts', '40.0000', '561600.00', '2026-05-19 22:57:49'), (5, 1, 2, '2025-07-01', 'Combustible', 'Gasoil', '28800.000', 'lts', '38.5000', '1108800.00', '2026-05-19 22:57:49'), (6, 1, 2, '2025-07-01', 'Combustible', 'Súper', '16650.000', 'lts', '44.2000', '735930.00', '2026-05-19 22:57:49'), (7, 1, 2, '2025-07-01', 'Combustible', 'Premium', '9280.000', 'lts', '50.1000', '464928.00', '2026-05-19 22:57:49'), (8, 1, 2, '2025-07-01', 'Combustible', 'Gasoil Especial', '12240.000', 'lts', '40.0000', '489600.00', '2026-05-19 22:57:49'), (9, 1, 3, '2025-08-01', 'Combustible', 'Gasoil', '31800.000', 'lts', '38.5000', '1224300.00', '2026-05-19 22:57:49'), (10, 1, 3, '2025-08-01', 'Combustible', 'Súper', '15000.000', 'lts', '44.2000', '663000.00', '2026-05-19 22:57:49'), (11, 1, 3, '2025-08-01', 'Combustible', 'Premium', '7280.000', 'lts', '50.1000', '364728.00', '2026-05-19 22:57:49'), (12, 1, 3, '2025-08-01', 'Combustible', 'Gasoil Especial', '14160.000', 'lts', '40.0000', '566400.00', '2026-05-19 22:57:49'), (13, 1, 4, '2025-09-01', 'Combustible', 'Gasoil', '34500.000', 'lts', '38.5000', '1328250.00', '2026-05-19 22:57:49'), (14, 1, 4, '2025-09-01', 'Combustible', 'Súper', '12600.000', 'lts', '44.2000', '556920.00', '2026-05-19 22:57:49'), (15, 1, 4, '2025-09-01', 'Combustible', 'Premium', '7200.000', 'lts', '50.1000', '360720.00', '2026-05-19 22:57:49'), (16, 1, 4, '2025-09-01', 'Combustible', 'Gasoil Especial', '11280.000', 'lts', '40.0000', '451200.00', '2026-05-19 22:57:49'), (17, 1, 5, '2025-10-01', 'Combustible', 'Gasoil', '35100.000', 'lts', '38.5000', '1351350.00', '2026-05-19 22:57:49'), (18, 1, 5, '2025-10-01', 'Combustible', 'Súper', '13500.000', 'lts', '44.2000', '596700.00', '2026-05-19 22:57:49'), (19, 1, 5, '2025-10-01', 'Combustible', 'Premium', '7360.000', 'lts', '50.1000', '368736.00', '2026-05-19 22:57:49'), (20, 1, 5, '2025-10-01', 'Combustible', 'Gasoil Especial', '13320.000', 'lts', '40.0000', '532800.00', '2026-05-19 22:57:49'), (21, 1, 6, '2025-11-01', 'Combustible', 'Gasoil', '32100.000', 'lts', '38.5000', '1235850.00', '2026-05-19 22:57:49'), (22, 1, 6, '2025-11-01', 'Combustible', 'Súper', '17850.000', 'lts', '44.2000', '788970.00', '2026-05-19 22:57:49'), (23, 1, 6, '2025-11-01', 'Combustible', 'Premium', '7440.000', 'lts', '50.1000', '372744.00', '2026-05-19 22:57:49'), (24, 1, 6, '2025-11-01', 'Combustible', 'Gasoil Especial', '11520.000', 'lts', '40.0000', '460800.00', '2026-05-19 22:57:49'), (25, 1, 7, '2025-12-01', 'Combustible', 'Gasoil', '29100.000', 'lts', '38.5000', '1120350.00', '2026-05-19 22:57:49'), (26, 1, 7, '2025-12-01', 'Combustible', 'Súper', '13650.000', 'lts', '44.2000', '603330.00', '2026-05-19 22:57:49'), (27, 1, 7, '2025-12-01', 'Combustible', 'Premium', '8560.000', 'lts', '50.1000', '428856.00', '2026-05-19 22:57:49'), (28, 1, 7, '2025-12-01', 'Combustible', 'Gasoil Especial', '13560.000', 'lts', '40.0000', '542400.00', '2026-05-19 22:57:49'), (29, 1, 8, '2026-01-01', 'Combustible', 'Gasoil', '26400.000', 'lts', '38.5000', '1016400.00', '2026-05-19 22:57:49'), (30, 1, 8, '2026-01-01', 'Combustible', 'Súper', '13050.000', 'lts', '44.2000', '576810.00', '2026-05-19 22:57:49'), (31, 1, 8, '2026-01-01', 'Combustible', 'Premium', '8880.000', 'lts', '50.1000', '444888.00', '2026-05-19 22:57:49'), (32, 1, 8, '2026-01-01', 'Combustible', 'Gasoil Especial', '13440.000', 'lts', '40.0000', '537600.00', '2026-05-19 22:57:49'), (33, 1, 9, '2026-02-01', 'Combustible', 'Gasoil', '26700.000', 'lts', '38.5000', '1027950.00', '2026-05-19 22:57:49'), (34, 1, 9, '2026-02-01', 'Combustible', 'Súper', '14550.000', 'lts', '44.2000', '643110.00', '2026-05-19 22:57:49'), (35, 1, 9, '2026-02-01', 'Combustible', 'Premium', '8000.000', 'lts', '50.1000', '400800.00', '2026-05-19 22:57:49'), (36, 1, 9, '2026-02-01', 'Combustible', 'Gasoil Especial', '11520.000', 'lts', '40.0000', '460800.00', '2026-05-19 22:57:49'), (37, 1, 10, '2026-03-01', 'Combustible', 'Gasoil', '31500.000', 'lts', '38.5000', '1212750.00', '2026-05-19 22:57:49'), (38, 1, 10, '2026-03-01', 'Combustible', 'Súper', '14700.000', 'lts', '44.2000', '649740.00', '2026-05-19 22:57:49'), (39, 1, 10, '2026-03-01', 'Combustible', 'Premium', '7280.000', 'lts', '50.1000', '364728.00', '2026-05-19 22:57:49'), (40, 1, 10, '2026-03-01', 'Combustible', 'Gasoil Especial', '14040.000', 'lts', '40.0000', '561600.00', '2026-05-19 22:57:49'), (41, 1, 11, '2026-04-01', 'Combustible', 'Gasoil', '34200.000', 'lts', '38.5000', '1316700.00', '2026-05-19 22:57:49'), (42, 1, 11, '2026-04-01', 'Combustible', 'Súper', '14400.000', 'lts', '44.2000', '636480.00', '2026-05-19 22:57:49'), (43, 1, 11, '2026-04-01', 'Combustible', 'Premium', '8160.000', 'lts', '50.1000', '408816.00', '2026-05-19 22:57:49'), (44, 1, 11, '2026-04-01', 'Combustible', 'Gasoil Especial', '9720.000', 'lts', '40.0000', '388800.00', '2026-05-19 22:57:49'), (45, 1, 12, '2026-05-01', 'Combustible', 'Gasoil', '36000.000', 'lts', '38.5000', '1386000.00', '2026-05-19 22:57:49'), (46, 1, 12, '2026-05-01', 'Combustible', 'Súper', '13050.000', 'lts', '44.2000', '576810.00', '2026-05-19 22:57:49'), (47, 1, 12, '2026-05-01', 'Combustible', 'Premium', '9280.000', 'lts', '50.1000', '464928.00', '2026-05-19 22:57:49'), (48, 1, 12, '2026-05-01', 'Combustible', 'Gasoil Especial', '13800.000', 'lts', '40.0000', '552000.00', '2026-05-19 22:57:49'), (49, 2, 13, '2025-06-01', 'Combustible', 'Gasoil', '28200.000', 'lts', '38.5000', '1085700.00', '2026-05-19 22:57:49'), (50, 2, 13, '2025-06-01', 'Combustible', 'Súper', '12900.000', 'lts', '44.2000', '570180.00', '2026-05-19 22:57:49'), (51, 2, 13, '2025-06-01', 'Combustible', 'Premium', '8560.000', 'lts', '50.1000', '428856.00', '2026-05-19 22:57:49'), (52, 2, 13, '2025-06-01', 'Combustible', 'Gasoil Especial', '10200.000', 'lts', '40.0000', '408000.00', '2026-05-19 22:57:49'), (53, 2, 14, '2025-07-01', 'Combustible', 'Gasoil', '26100.000', 'lts', '38.5000', '1004850.00', '2026-05-19 22:57:49'), (54, 2, 14, '2025-07-01', 'Combustible', 'Súper', '14250.000', 'lts', '44.2000', '629850.00', '2026-05-19 22:57:49'), (55, 2, 14, '2025-07-01', 'Combustible', 'Premium', '7920.000', 'lts', '50.1000', '396792.00', '2026-05-19 22:57:49'), (56, 2, 14, '2025-07-01', 'Combustible', 'Gasoil Especial', '12720.000', 'lts', '40.0000', '508800.00', '2026-05-19 22:57:49'), (57, 2, 15, '2025-08-01', 'Combustible', 'Gasoil', '26700.000', 'lts', '38.5000', '1027950.00', '2026-05-19 22:57:49'), (58, 2, 15, '2025-08-01', 'Combustible', 'Súper', '16350.000', 'lts', '44.2000', '722670.00', '2026-05-19 22:57:49'), (59, 2, 15, '2025-08-01', 'Combustible', 'Premium', '6560.000', 'lts', '50.1000', '328656.00', '2026-05-19 22:57:49'), (60, 2, 15, '2025-08-01', 'Combustible', 'Gasoil Especial', '13200.000', 'lts', '40.0000', '528000.00', '2026-05-19 22:57:49'), (61, 2, 16, '2025-09-01', 'Combustible', 'Gasoil', '25200.000', 'lts', '38.5000', '970200.00', '2026-05-19 22:57:49'), (62, 2, 16, '2025-09-01', 'Combustible', 'Súper', '17700.000', 'lts', '44.2000', '782340.00', '2026-05-19 22:57:49'), (63, 2, 16, '2025-09-01', 'Combustible', 'Premium', '8480.000', 'lts', '50.1000', '424848.00', '2026-05-19 22:57:49'), (64, 2, 16, '2025-09-01', 'Combustible', 'Gasoil Especial', '10200.000', 'lts', '40.0000', '408000.00', '2026-05-19 22:57:49'), (65, 2, 17, '2025-10-01', 'Combustible', 'Gasoil', '28500.000', 'lts', '38.5000', '1097250.00', '2026-05-19 22:57:49'), (66, 2, 17, '2025-10-01', 'Combustible', 'Súper', '17400.000', 'lts', '44.2000', '769080.00', '2026-05-19 22:57:49'), (67, 2, 17, '2025-10-01', 'Combustible', 'Premium', '8880.000', 'lts', '50.1000', '444888.00', '2026-05-19 22:57:49'), (68, 2, 17, '2025-10-01', 'Combustible', 'Gasoil Especial', '10200.000', 'lts', '40.0000', '408000.00', '2026-05-19 22:57:49'), (69, 2, 18, '2025-11-01', 'Combustible', 'Gasoil', '29400.000', 'lts', '38.5000', '1131900.00', '2026-05-19 22:57:49'), (70, 2, 18, '2025-11-01', 'Combustible', 'Súper', '13350.000', 'lts', '44.2000', '590070.00', '2026-05-19 22:57:49'), (71, 2, 18, '2025-11-01', 'Combustible', 'Premium', '9280.000', 'lts', '50.1000', '464928.00', '2026-05-19 22:57:49'), (72, 2, 18, '2025-11-01', 'Combustible', 'Gasoil Especial', '14400.000', 'lts', '40.0000', '576000.00', '2026-05-19 22:57:49'), (73, 2, 19, '2025-12-01', 'Combustible', 'Gasoil', '27000.000', 'lts', '38.5000', '1039500.00', '2026-05-19 22:57:49'), (74, 2, 19, '2025-12-01', 'Combustible', 'Súper', '12300.000', 'lts', '44.2000', '543660.00', '2026-05-19 22:57:49'), (75, 2, 19, '2025-12-01', 'Combustible', 'Premium', '7360.000', 'lts', '50.1000', '368736.00', '2026-05-19 22:57:49'), (76, 2, 19, '2025-12-01', 'Combustible', 'Gasoil Especial', '9960.000', 'lts', '40.0000', '398400.00', '2026-05-19 22:57:49'), (77, 2, 20, '2026-01-01', 'Combustible', 'Gasoil', '31200.000', 'lts', '38.5000', '1201200.00', '2026-05-19 22:57:49'), (78, 2, 20, '2026-01-01', 'Combustible', 'Súper', '15750.000', 'lts', '44.2000', '696150.00', '2026-05-19 22:57:49'), (79, 2, 20, '2026-01-01', 'Combustible', 'Premium', '7040.000', 'lts', '50.1000', '352704.00', '2026-05-19 22:57:49'), (80, 2, 20, '2026-01-01', 'Combustible', 'Gasoil Especial', '11760.000', 'lts', '40.0000', '470400.00', '2026-05-19 22:57:49'), (81, 2, 21, '2026-02-01', 'Combustible', 'Gasoil', '32100.000', 'lts', '38.5000', '1235850.00', '2026-05-19 22:57:49'), (82, 2, 21, '2026-02-01', 'Combustible', 'Súper', '15150.000', 'lts', '44.2000', '669630.00', '2026-05-19 22:57:49'), (83, 2, 21, '2026-02-01', 'Combustible', 'Premium', '8320.000', 'lts', '50.1000', '416832.00', '2026-05-19 22:57:49'), (84, 2, 21, '2026-02-01', 'Combustible', 'Gasoil Especial', '10920.000', 'lts', '40.0000', '436800.00', '2026-05-19 22:57:49'), (85, 2, 22, '2026-03-01', 'Combustible', 'Gasoil', '30300.000', 'lts', '38.5000', '1166550.00', '2026-05-19 22:57:49'), (86, 2, 22, '2026-03-01', 'Combustible', 'Súper', '15750.000', 'lts', '44.2000', '696150.00', '2026-05-19 22:57:49'), (87, 2, 22, '2026-03-01', 'Combustible', 'Premium', '8720.000', 'lts', '50.1000', '436872.00', '2026-05-19 22:57:49'), (88, 2, 22, '2026-03-01', 'Combustible', 'Gasoil Especial', '10080.000', 'lts', '40.0000', '403200.00', '2026-05-19 22:57:49'), (89, 2, 23, '2026-04-01', 'Combustible', 'Gasoil', '31200.000', 'lts', '38.5000', '1201200.00', '2026-05-19 22:57:49'), (90, 2, 23, '2026-04-01', 'Combustible', 'Súper', '17700.000', 'lts', '44.2000', '782340.00', '2026-05-19 22:57:49'), (91, 2, 23, '2026-04-01', 'Combustible', 'Premium', '6880.000', 'lts', '50.1000', '344688.00', '2026-05-19 22:57:49'), (92, 2, 23, '2026-04-01', 'Combustible', 'Gasoil Especial', '12480.000', 'lts', '40.0000', '499200.00', '2026-05-19 22:57:49'), (93, 2, 24, '2026-05-01', 'Combustible', 'Gasoil', '27600.000', 'lts', '38.5000', '1062600.00', '2026-05-19 22:57:49'), (94, 2, 24, '2026-05-01', 'Combustible', 'Súper', '13650.000', 'lts', '44.2000', '603330.00', '2026-05-19 22:57:49'), (95, 2, 24, '2026-05-01', 'Combustible', 'Premium', '6720.000', 'lts', '50.1000', '336672.00', '2026-05-19 22:57:49'), (96, 2, 24, '2026-05-01', 'Combustible', 'Gasoil Especial', '12000.000', 'lts', '40.0000', '480000.00', '2026-05-19 22:57:49'), (97, 3, 25, '2026-03-31', 'Combustible', 'Gasoil', '6621.000', 'L', '31.8012', '210556.00', '2026-05-19 23:19:24'), (98, 3, 25, '2026-03-31', 'Combustible', 'Súper', '58000.000', 'L', '66.9301', '3881946.00', '2026-05-19 23:19:24'), (99, 3, 25, '2026-03-31', 'Combustible', 'Premium', '8998.000', 'L', '69.4515', '624925.00', '2026-05-19 23:19:24'), (100, 3, 25, '2026-03-31', 'Combustible', 'Gasoil Especial', '1807.000', 'L', '34.5866', '62498.00', '2026-05-19 23:19:24'), (101, 3, 25, '2026-03-31', 'Minimercado', 'Stock minimercado', '0.000', 'L', '0.0000', '6098627.00', '2026-05-19 23:19:24'), (102, 3, 25, '2026-03-31', 'Otros', 'Otros pista', '0.000', 'L', '0.0000', '1010346.00', '2026-05-19 23:19:24'), (143, 3, 47, '2026-04-30', 'Combustible', 'Gasoil ', '14467.000', 'lts', '34.3506', '496950.13', '2026-06-04 18:00:17'), (144, 3, 47, '2026-04-30', 'Combustible', 'Gasoil especial ', '5734.000', 'lts', '37.4824', '214924.08', '2026-06-04 18:00:17'), (145, 3, 47, '2026-04-30', 'Otros', 'Otros pista', '1.000', 'lts', '739932.0000', '739932.00', '2026-06-04 18:00:17'), (146, 3, 47, '2026-04-30', 'Combustible', 'Premium', '8851.000', 'lts', '74.7866', '661936.20', '2026-06-04 18:00:17'), (147, 3, 47, '2026-04-30', 'Minimercado', 'Stock minimercado', '1.000', 'lts', '6600086.0000', '6600086.00', '2026-06-04 18:00:17'), (148, 3, 47, '2026-04-30', 'Combustible', 'Super', '44541.000', 'lts', '72.1107', '3211882.69', '2026-06-04 18:00:17'), (254, 3, 31, '2026-01-31', 'Combustible', 'Gasoil', '12530.251', 'lts', '33.0900', '414626.01', '2026-06-07 19:41:13'), (255, 3, 31, '2026-01-31', 'Combustible', 'Gasoil Especial', '3110.580', 'lts', '35.8699', '111576.19', '2026-06-07 19:41:13'), (256, 3, 31, '2026-01-31', 'Minimercado', 'Minimercado (general)', '1.000', 'lts', '5908893.1400', '5908893.14', '2026-06-07 19:41:13'), (257, 3, 31, '2026-01-31', 'Otros', 'Otros', '1.000', 'lts', '1052677.7200', '1052677.72', '2026-06-07 19:41:13'), (258, 3, 31, '2026-01-31', 'Combustible', 'Premium', '8886.761', 'lts', '70.3500', '625183.64', '2026-06-07 19:41:13'), (259, 3, 31, '2026-01-31', 'Combustible', 'Súper', '41876.977', 'lts', '67.8400', '2840934.12', '2026-06-07 19:41:13'), (266, 3, 30, '2026-02-28', 'Combustible', 'Gasoil', '13205.788', 'lts', '33.0899', '436978.20', '2026-06-07 19:44:13'), (267, 3, 30, '0000-00-00', 'Combustible', 'Gasoil Especial', '4766.938', 'lts', '35.8700', '170990.07', '2026-06-07 19:44:13'), (268, 3, 30, '2026-02-28', 'Minimercado', 'Minimercado (general)', '1.000', 'lts', '5835027.5900', '5835027.59', '2026-06-07 19:44:13'), (269, 3, 30, '2026-02-28', 'Otros', 'Otros', '1.000', 'lts', '1260431.2900', '1260431.29', '2026-06-07 19:44:13'), (270, 3, 30, '2026-02-28', 'Combustible', 'Premium', '8126.871', 'lts', '70.3499', '571724.56', '2026-06-07 19:44:13'), (271, 3, 30, '2026-02-28', 'Combustible', 'Súper', '50425.017', 'lts', '67.8399', '3420828.11', '2026-06-07 19:44:13'); -- -------------------------------------------------------- -- -- Table structure for table `usuarios` -- CREATE TABLE `usuarios` ( `id` int(10) UNSIGNED NOT NULL, `empresa_id` int(10) UNSIGNED DEFAULT NULL COMMENT 'NULL = superadmin', `nombre` varchar(100) NOT NULL, `email` varchar(150) NOT NULL, `password_hash` varchar(255) NOT NULL, `rol` enum('superadmin','admin','viewer') NOT NULL DEFAULT 'viewer', `activo` tinyint(1) NOT NULL DEFAULT 1, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `usuarios` -- INSERT INTO `usuarios` (`id`, `empresa_id`, `nombre`, `email`, `password_hash`, `rol`, `activo`, `created_at`, `updated_at`) VALUES (1, NULL, 'Administrador', 'admin@panelbordo.uy', '$2y$10$bB3ufgQ0ang1/L9Xo42ZR.FlSCbyDAKR2WrZWYzL0nax6CW4Phup.', 'superadmin', 1, '2026-05-19 22:57:36', '2026-05-19 22:57:36'), (2, 1, 'Gerente Atlántica', 'gerente@atlantica.uy', '$2y$10$7yqUhc0LFfFR/Fa00mPa0uMrxYFOeJrvnOABZMI3r4aA8k/xi9FPm', 'admin', 1, '2026-05-19 22:57:36', '2026-05-19 22:57:36'), (3, 1, 'Visualizador', 'viewer@atlantica.uy', '$2y$10$d3FWJM4Oq2MLlxfBvODGee4EQJlDpCSI7LqSLnWk1qxiMefSTs3.6', 'viewer', 1, '2026-05-19 22:57:36', '2026-05-19 22:57:36'), (4, 3, 'Admin Isla de Flores', 'admin@isladeflores.uy', '$2y$10$yLHBsBc5SZpxoWPe3MgBMeJzpOp69LpJUO2Wrfq0gRZk2lmCJlJwG', 'admin', 1, '2026-05-19 23:19:25', '2026-05-19 23:19:25'); -- -------------------------------------------------------- -- -- Table structure for table `ventas` -- CREATE TABLE `ventas` ( `id` int(10) UNSIGNED NOT NULL, `empresa_id` int(10) UNSIGNED NOT NULL, `periodo_id` int(10) UNSIGNED NOT NULL, `fecha` date NOT NULL, `unidad_negocio` varchar(80) NOT NULL DEFAULT 'Combustible', `producto` varchar(80) NOT NULL DEFAULT '', `turno` varchar(20) NOT NULL DEFAULT '', `litros` decimal(14,3) NOT NULL DEFAULT 0.000, `importe` decimal(14,2) NOT NULL DEFAULT 0.00, `created_at` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `ventas` -- INSERT INTO `ventas` (`id`, `empresa_id`, `periodo_id`, `fecha`, `unidad_negocio`, `producto`, `turno`, `litros`, `importe`, `created_at`) VALUES (1, 1, 1, '2025-06-01', 'Combustible', 'Gasoil', 'Mañana', '188.000', '8375.40', '2026-05-19 22:57:48'), (2, 1, 1, '2025-06-01', 'Combustible', 'Gasoil', 'Tarde', '161.000', '7172.55', '2026-05-19 22:57:48'), (3, 1, 1, '2025-06-01', 'Combustible', 'Gasoil', 'Noche', '137.500', '6125.63', '2026-05-19 22:57:48'), (4, 1, 1, '2025-06-01', 'Combustible', 'Súper', 'Mañana', '114.100', '5873.87', '2026-05-19 22:57:48'), (5, 1, 1, '2025-06-01', 'Combustible', 'Súper', 'Tarde', '89.600', '4612.61', '2026-05-19 22:57:48'), (6, 1, 1, '2025-06-01', 'Combustible', 'Súper', 'Noche', '62.000', '3288.48', '2026-05-19 22:57:48'), (7, 1, 1, '2025-06-01', 'Combustible', 'Premium', 'Mañana', '44.000', '2577.52', '2026-05-19 22:57:48'), (8, 1, 1, '2025-06-01', 'Combustible', 'Premium', 'Tarde', '35.400', '2012.14', '2026-05-19 22:57:49'), (9, 1, 1, '2025-06-01', 'Combustible', 'Premium', 'Noche', '27.500', '1579.05', '2026-05-19 22:57:49'), (10, 1, 1, '2025-06-01', 'Combustible', 'Gasoil Especial', 'Mañana', '50.700', '2482.27', '2026-05-19 22:57:49'), (11, 1, 1, '2025-06-01', 'Combustible', 'Gasoil Especial', 'Tarde', '50.400', '2419.20', '2026-05-19 22:57:49'), (12, 1, 1, '2025-06-01', 'Combustible', 'Gasoil Especial', 'Noche', '34.700', '1665.60', '2026-05-19 22:57:49'), (13, 1, 1, '2025-06-01', 'Minimercado', 'Varios', '', '0.000', '176400.00', '2026-05-19 22:57:49'), (14, 1, 2, '2025-07-01', 'Combustible', 'Gasoil', 'Mañana', '205.200', '9141.66', '2026-05-19 22:57:49'), (15, 1, 2, '2025-07-01', 'Combustible', 'Gasoil', 'Tarde', '152.400', '6926.58', '2026-05-19 22:57:49'), (16, 1, 2, '2025-07-01', 'Combustible', 'Gasoil', 'Noche', '119.800', '5444.91', '2026-05-19 22:57:49'), (17, 1, 2, '2025-07-01', 'Combustible', 'Súper', 'Mañana', '107.400', '5473.10', '2026-05-19 22:57:49'), (18, 1, 2, '2025-07-01', 'Combustible', 'Súper', 'Tarde', '87.600', '4555.20', '2026-05-19 22:57:49'), (19, 1, 2, '2025-07-01', 'Combustible', 'Súper', 'Noche', '58.100', '2990.99', '2026-05-19 22:57:49'), (20, 1, 2, '2025-07-01', 'Combustible', 'Premium', 'Mañana', '41.800', '2448.64', '2026-05-19 22:57:49'), (21, 1, 2, '2025-07-01', 'Combustible', 'Premium', 'Tarde', '33.500', '1904.14', '2026-05-19 22:57:49'), (22, 1, 2, '2025-07-01', 'Combustible', 'Premium', 'Noche', '21.800', '1289.69', '2026-05-19 22:57:49'), (23, 1, 2, '2025-07-01', 'Combustible', 'Gasoil Especial', 'Mañana', '46.500', '2254.32', '2026-05-19 22:57:49'), (24, 1, 2, '2025-07-01', 'Combustible', 'Gasoil Especial', 'Tarde', '42.000', '2016.00', '2026-05-19 22:57:49'), (25, 1, 2, '2025-07-01', 'Combustible', 'Gasoil Especial', 'Noche', '30.000', '1440.00', '2026-05-19 22:57:49'), (26, 1, 2, '2025-07-01', 'Minimercado', 'Varios', '', '0.000', '169200.00', '2026-05-19 22:57:49'), (27, 1, 3, '2025-08-01', 'Combustible', 'Gasoil', 'Mañana', '199.400', '9062.73', '2026-05-19 22:57:49'), (28, 1, 3, '2025-08-01', 'Combustible', 'Gasoil', 'Tarde', '184.600', '8307.00', '2026-05-19 22:57:49'), (29, 1, 3, '2025-08-01', 'Combustible', 'Gasoil', 'Noche', '118.500', '5225.85', '2026-05-19 22:57:49'), (30, 1, 3, '2025-08-01', 'Combustible', 'Súper', 'Mañana', '100.100', '5309.30', '2026-05-19 22:57:49'), (31, 1, 3, '2025-08-01', 'Combustible', 'Súper', 'Tarde', '97.500', '5120.70', '2026-05-19 22:57:49'), (32, 1, 3, '2025-08-01', 'Combustible', 'Súper', 'Noche', '60.600', '3182.71', '2026-05-19 22:57:49'), (33, 1, 3, '2025-08-01', 'Combustible', 'Premium', 'Mañana', '41.400', '2401.20', '2026-05-19 22:57:49'), (34, 1, 3, '2025-08-01', 'Combustible', 'Premium', 'Tarde', '30.500', '1804.38', '2026-05-19 22:57:49'), (35, 1, 3, '2025-08-01', 'Combustible', 'Premium', 'Noche', '23.200', '1332.14', '2026-05-19 22:57:49'), (36, 1, 3, '2025-08-01', 'Combustible', 'Gasoil Especial', 'Mañana', '49.500', '2376.00', '2026-05-19 22:57:49'), (37, 1, 3, '2025-08-01', 'Combustible', 'Gasoil Especial', 'Tarde', '42.900', '2100.38', '2026-05-19 22:57:49'), (38, 1, 3, '2025-08-01', 'Combustible', 'Gasoil Especial', 'Noche', '31.600', '1516.80', '2026-05-19 22:57:49'), (39, 1, 3, '2025-08-01', 'Minimercado', 'Varios', '', '0.000', '162000.00', '2026-05-19 22:57:49'), (40, 1, 4, '2025-09-01', 'Combustible', 'Gasoil', 'Mañana', '220.000', '9702.00', '2026-05-19 22:57:49'), (41, 1, 4, '2025-09-01', 'Combustible', 'Gasoil', 'Tarde', '189.000', '8505.00', '2026-05-19 22:57:49'), (42, 1, 4, '2025-09-01', 'Combustible', 'Gasoil', 'Noche', '137.500', '6187.50', '2026-05-19 22:57:49'), (43, 1, 4, '2025-09-01', 'Combustible', 'Súper', 'Mañana', '110.900', '5651.46', '2026-05-19 22:57:49'), (44, 1, 4, '2025-09-01', 'Combustible', 'Súper', 'Tarde', '87.700', '4514.80', '2026-05-19 22:57:49'), (45, 1, 4, '2025-09-01', 'Combustible', 'Súper', 'Noche', '64.700', '3364.40', '2026-05-19 22:57:49'), (46, 1, 4, '2025-09-01', 'Combustible', 'Premium', 'Mañana', '38.000', '2181.96', '2026-05-19 22:57:49'), (47, 1, 4, '2025-09-01', 'Combustible', 'Premium', 'Tarde', '35.400', '2094.26', '2026-05-19 22:57:49'), (48, 1, 4, '2025-09-01', 'Combustible', 'Premium', 'Noche', '26.000', '1523.08', '2026-05-19 22:57:49'), (49, 1, 4, '2025-09-01', 'Combustible', 'Gasoil Especial', 'Mañana', '53.900', '2638.94', '2026-05-19 22:57:49'), (50, 1, 4, '2025-09-01', 'Combustible', 'Gasoil Especial', 'Tarde', '49.000', '2399.04', '2026-05-19 22:57:49'), (51, 1, 4, '2025-09-01', 'Combustible', 'Gasoil Especial', 'Noche', '34.000', '1599.36', '2026-05-19 22:57:49'), (52, 1, 4, '2025-09-01', 'Minimercado', 'Varios', '', '0.000', '187200.00', '2026-05-19 22:57:49'), (53, 1, 5, '2025-10-01', 'Combustible', 'Gasoil', 'Mañana', '174.200', '7760.61', '2026-05-19 22:57:49'), (54, 1, 5, '2025-10-01', 'Combustible', 'Gasoil', 'Tarde', '186.300', '8299.67', '2026-05-19 22:57:49'), (55, 1, 5, '2025-10-01', 'Combustible', 'Gasoil', 'Noche', '118.500', '5225.85', '2026-05-19 22:57:49'), (56, 1, 5, '2025-10-01', 'Combustible', 'Súper', 'Mañana', '99.100', '5153.20', '2026-05-19 22:57:49'), (57, 1, 5, '2025-10-01', 'Combustible', 'Súper', 'Tarde', '98.500', '5224.44', '2026-05-19 22:57:49'), (58, 1, 5, '2025-10-01', 'Combustible', 'Súper', 'Noche', '58.700', '3021.88', '2026-05-19 22:57:49'), (59, 1, 5, '2025-10-01', 'Combustible', 'Premium', 'Mañana', '39.500', '2313.91', '2026-05-19 22:57:49'), (60, 1, 5, '2025-10-01', 'Combustible', 'Premium', 'Tarde', '31.800', '1825.96', '2026-05-19 22:57:49'), (61, 1, 5, '2025-10-01', 'Combustible', 'Premium', 'Noche', '26.400', '1531.20', '2026-05-19 22:57:49'), (62, 1, 5, '2025-10-01', 'Combustible', 'Gasoil Especial', 'Mañana', '52.600', '2550.05', '2026-05-19 22:57:49'), (63, 1, 5, '2025-10-01', 'Combustible', 'Gasoil Especial', 'Tarde', '44.300', '2126.40', '2026-05-19 22:57:49'), (64, 1, 5, '2025-10-01', 'Combustible', 'Gasoil Especial', 'Noche', '30.300', '1468.94', '2026-05-19 22:57:49'), (65, 1, 5, '2025-10-01', 'Minimercado', 'Varios', '', '0.000', '185400.00', '2026-05-19 22:57:49'), (66, 1, 6, '2025-11-01', 'Combustible', 'Gasoil', 'Mañana', '216.000', '9914.40', '2026-05-19 22:57:49'), (67, 1, 6, '2025-11-01', 'Combustible', 'Gasoil', 'Tarde', '168.000', '7484.40', '2026-05-19 22:57:49'), (68, 1, 6, '2025-11-01', 'Combustible', 'Gasoil', 'Noche', '135.000', '6014.25', '2026-05-19 22:57:49'), (69, 1, 6, '2025-11-01', 'Combustible', 'Súper', 'Mañana', '96.000', '4992.00', '2026-05-19 22:57:49'), (70, 1, 6, '2025-11-01', 'Combustible', 'Súper', 'Tarde', '94.300', '4805.53', '2026-05-19 22:57:49'), (71, 1, 6, '2025-11-01', 'Combustible', 'Súper', 'Noche', '65.300', '3463.51', '2026-05-19 22:57:49'), (72, 1, 6, '2025-11-01', 'Combustible', 'Premium', 'Mañana', '40.000', '2273.60', '2026-05-19 22:57:49'), (73, 1, 6, '2025-11-01', 'Combustible', 'Premium', 'Tarde', '31.500', '1790.46', '2026-05-19 22:57:49'), (74, 1, 6, '2025-11-01', 'Combustible', 'Premium', 'Noche', '23.500', '1363.00', '2026-05-19 22:57:49'), (75, 1, 6, '2025-11-01', 'Combustible', 'Gasoil Especial', 'Mañana', '57.100', '2768.21', '2026-05-19 22:57:49'), (76, 1, 6, '2025-11-01', 'Combustible', 'Gasoil Especial', 'Tarde', '47.600', '2239.10', '2026-05-19 22:57:49'), (77, 1, 6, '2025-11-01', 'Combustible', 'Gasoil Especial', 'Noche', '35.700', '1713.60', '2026-05-19 22:57:49'), (78, 1, 6, '2025-11-01', 'Minimercado', 'Varios', '', '0.000', '165600.00', '2026-05-19 22:57:49'), (79, 1, 7, '2025-12-01', 'Combustible', 'Gasoil', 'Mañana', '195.500', '8797.50', '2026-05-19 22:57:49'), (80, 1, 7, '2025-12-01', 'Combustible', 'Gasoil', 'Tarde', '186.300', '8215.83', '2026-05-19 22:57:49'), (81, 1, 7, '2025-12-01', 'Combustible', 'Gasoil', 'Noche', '116.100', '5276.75', '2026-05-19 22:57:49'), (82, 1, 7, '2025-12-01', 'Combustible', 'Súper', 'Mañana', '106.300', '5472.32', '2026-05-19 22:57:49'), (83, 1, 7, '2025-12-01', 'Combustible', 'Súper', 'Tarde', '84.000', '4411.68', '2026-05-19 22:57:49'), (84, 1, 7, '2025-12-01', 'Combustible', 'Súper', 'Noche', '65.800', '3387.38', '2026-05-19 22:57:49'), (85, 1, 7, '2025-12-01', 'Combustible', 'Premium', 'Mañana', '37.500', '2218.50', '2026-05-19 22:57:49'), (86, 1, 7, '2025-12-01', 'Combustible', 'Premium', 'Tarde', '37.300', '2185.03', '2026-05-19 22:57:49'), (87, 1, 7, '2025-12-01', 'Combustible', 'Premium', 'Noche', '26.400', '1515.89', '2026-05-19 22:57:49'), (88, 1, 7, '2025-12-01', 'Combustible', 'Gasoil Especial', 'Mañana', '51.600', '2501.57', '2026-05-19 22:57:49'), (89, 1, 7, '2025-12-01', 'Combustible', 'Gasoil Especial', 'Tarde', '45.200', '2191.30', '2026-05-19 22:57:49'), (90, 1, 7, '2025-12-01', 'Combustible', 'Gasoil Especial', 'Noche', '32.900', '1610.78', '2026-05-19 22:57:49'), (91, 1, 7, '2025-12-01', 'Minimercado', 'Varios', '', '0.000', '196200.00', '2026-05-19 22:57:49'), (92, 1, 8, '2026-01-01', 'Combustible', 'Gasoil', 'Mañana', '180.000', '8262.00', '2026-05-19 22:57:49'), (93, 1, 8, '2026-01-01', 'Combustible', 'Gasoil', 'Tarde', '171.000', '7618.05', '2026-05-19 22:57:49'), (94, 1, 8, '2026-01-01', 'Combustible', 'Gasoil', 'Noche', '125.800', '5604.39', '2026-05-19 22:57:49'), (95, 1, 8, '2026-01-01', 'Combustible', 'Súper', 'Mañana', '102.200', '5314.40', '2026-05-19 22:57:49'), (96, 1, 8, '2026-01-01', 'Combustible', 'Súper', 'Tarde', '87.600', '4555.20', '2026-05-19 22:57:49'), (97, 1, 8, '2026-01-01', 'Combustible', 'Súper', 'Noche', '59.400', '3119.69', '2026-05-19 22:57:49'), (98, 1, 8, '2026-01-01', 'Combustible', 'Premium', 'Mañana', '41.400', '2377.19', '2026-05-19 22:57:49'), (99, 1, 8, '2026-01-01', 'Combustible', 'Premium', 'Tarde', '31.800', '1881.29', '2026-05-19 22:57:49'), (100, 1, 8, '2026-01-01', 'Combustible', 'Premium', 'Noche', '22.500', '1318.05', '2026-05-19 22:57:49'), (101, 1, 8, '2026-01-01', 'Combustible', 'Gasoil Especial', 'Mañana', '56.300', '2675.38', '2026-05-19 22:57:49'), (102, 1, 8, '2026-01-01', 'Combustible', 'Gasoil Especial', 'Tarde', '41.500', '1972.08', '2026-05-19 22:57:49'), (103, 1, 8, '2026-01-01', 'Combustible', 'Gasoil Especial', 'Noche', '30.000', '1440.00', '2026-05-19 22:57:49'), (104, 1, 8, '2026-01-01', 'Minimercado', 'Varios', '', '0.000', '169200.00', '2026-05-19 22:57:49'), (105, 1, 9, '2026-02-01', 'Combustible', 'Gasoil', 'Mañana', '207.900', '9542.61', '2026-05-19 22:57:49'), (106, 1, 9, '2026-02-01', 'Combustible', 'Gasoil', 'Tarde', '196.900', '8949.11', '2026-05-19 22:57:49'), (107, 1, 9, '2026-02-01', 'Combustible', 'Gasoil', 'Noche', '132.600', '5847.66', '2026-05-19 22:57:49'), (108, 1, 9, '2026-02-01', 'Combustible', 'Súper', 'Mañana', '116.600', '6123.83', '2026-05-19 22:57:49'), (109, 1, 9, '2026-02-01', 'Combustible', 'Súper', 'Tarde', '98.000', '5197.92', '2026-05-19 22:57:49'), (110, 1, 9, '2026-02-01', 'Combustible', 'Súper', 'Noche', '66.400', '3418.27', '2026-05-19 22:57:49'), (111, 1, 9, '2026-02-01', 'Combustible', 'Premium', 'Mañana', '45.900', '2715.44', '2026-05-19 22:57:49'), (112, 1, 9, '2026-02-01', 'Combustible', 'Premium', 'Tarde', '36.400', '2068.98', '2026-05-19 22:57:49'), (113, 1, 9, '2026-02-01', 'Combustible', 'Premium', 'Noche', '26.300', '1510.15', '2026-05-19 22:57:49'), (114, 1, 9, '2026-02-01', 'Combustible', 'Gasoil Especial', 'Mañana', '52.000', '2496.00', '2026-05-19 22:57:49'), (115, 1, 9, '2026-02-01', 'Combustible', 'Gasoil Especial', 'Tarde', '51.500', '2447.28', '2026-05-19 22:57:49'), (116, 1, 9, '2026-02-01', 'Combustible', 'Gasoil Especial', 'Noche', '32.500', '1528.80', '2026-05-19 22:57:49'), (117, 1, 9, '2026-02-01', 'Minimercado', 'Varios', '', '0.000', '187200.00', '2026-05-19 22:57:49'), (118, 1, 10, '2026-03-01', 'Combustible', 'Gasoil', 'Mañana', '209.000', '9499.05', '2026-05-19 22:57:49'), (119, 1, 10, '2026-03-01', 'Combustible', 'Gasoil', 'Tarde', '169.400', '7470.54', '2026-05-19 22:57:49'), (120, 1, 10, '2026-03-01', 'Combustible', 'Gasoil', 'Noche', '127.000', '5715.00', '2026-05-19 22:57:49'), (121, 1, 10, '2026-03-01', 'Combustible', 'Súper', 'Mañana', '95.000', '5038.80', '2026-05-19 22:57:49'), (122, 1, 10, '2026-03-01', 'Combustible', 'Súper', 'Tarde', '98.500', '5070.78', '2026-05-19 22:57:49'), (123, 1, 10, '2026-03-01', 'Combustible', 'Súper', 'Noche', '65.800', '3455.82', '2026-05-19 22:57:49'), (124, 1, 10, '2026-03-01', 'Combustible', 'Premium', 'Mañana', '37.900', '2154.24', '2026-05-19 22:57:49'), (125, 1, 10, '2026-03-01', 'Combustible', 'Premium', 'Tarde', '30.500', '1733.62', '2026-05-19 22:57:49'), (126, 1, 10, '2026-03-01', 'Combustible', 'Premium', 'Noche', '23.200', '1318.69', '2026-05-19 22:57:49'), (127, 1, 10, '2026-03-01', 'Combustible', 'Gasoil Especial', 'Mañana', '50.100', '2380.75', '2026-05-19 22:57:49'), (128, 1, 10, '2026-03-01', 'Combustible', 'Gasoil Especial', 'Tarde', '47.400', '2252.45', '2026-05-19 22:57:49'), (129, 1, 10, '2026-03-01', 'Combustible', 'Gasoil Especial', 'Noche', '30.600', '1498.18', '2026-05-19 22:57:49'), (130, 1, 10, '2026-03-01', 'Minimercado', 'Varios', '', '0.000', '165600.00', '2026-05-19 22:57:49'), (131, 1, 11, '2026-04-01', 'Combustible', 'Gasoil', 'Mañana', '194.000', '8555.40', '2026-05-19 22:57:49'), (132, 1, 11, '2026-04-01', 'Combustible', 'Gasoil', 'Tarde', '180.300', '7951.23', '2026-05-19 22:57:49'), (133, 1, 11, '2026-04-01', 'Combustible', 'Gasoil', 'Noche', '132.500', '5902.88', '2026-05-19 22:57:49'), (134, 1, 11, '2026-04-01', 'Combustible', 'Súper', 'Mañana', '97.100', '5150.18', '2026-05-19 22:57:49'), (135, 1, 11, '2026-04-01', 'Combustible', 'Súper', 'Tarde', '84.000', '4324.32', '2026-05-19 22:57:49'), (136, 1, 11, '2026-04-01', 'Combustible', 'Súper', 'Noche', '64.700', '3431.69', '2026-05-19 22:57:49'), (137, 1, 11, '2026-04-01', 'Combustible', 'Premium', 'Mañana', '40.800', '2319.07', '2026-05-19 22:57:49'), (138, 1, 11, '2026-04-01', 'Combustible', 'Premium', 'Tarde', '31.500', '1808.73', '2026-05-19 22:57:49'), (139, 1, 11, '2026-04-01', 'Combustible', 'Premium', 'Noche', '25.500', '1464.21', '2026-05-19 22:57:49'), (140, 1, 11, '2026-04-01', 'Combustible', 'Gasoil Especial', 'Mañana', '58.100', '2733.02', '2026-05-19 22:57:49'), (141, 1, 11, '2026-04-01', 'Combustible', 'Gasoil Especial', 'Tarde', '43.400', '2104.03', '2026-05-19 22:57:49'), (142, 1, 11, '2026-04-01', 'Combustible', 'Gasoil Especial', 'Noche', '31.300', '1487.38', '2026-05-19 22:57:49'), (143, 1, 11, '2026-04-01', 'Minimercado', 'Varios', '', '0.000', '196200.00', '2026-05-19 22:57:49'), (144, 1, 12, '2026-05-01', 'Combustible', 'Gasoil', 'Mañana', '199.400', '9062.73', '2026-05-19 22:57:49'), (145, 1, 12, '2026-05-01', 'Combustible', 'Gasoil', 'Tarde', '154.100', '6795.81', '2026-05-19 22:57:49'), (146, 1, 12, '2026-05-01', 'Combustible', 'Gasoil', 'Noche', '121.000', '5499.45', '2026-05-19 22:57:49'), (147, 1, 12, '2026-05-01', 'Combustible', 'Súper', 'Mañana', '105.300', '5366.09', '2026-05-19 22:57:49'), (148, 1, 12, '2026-05-01', 'Combustible', 'Súper', 'Tarde', '85.800', '4372.37', '2026-05-19 22:57:49'), (149, 1, 12, '2026-05-01', 'Combustible', 'Súper', 'Noche', '61.300', '3219.48', '2026-05-19 22:57:49'), (150, 1, 12, '2026-05-01', 'Combustible', 'Premium', 'Mañana', '42.600', '2520.22', '2026-05-19 22:57:49'), (151, 1, 12, '2026-05-01', 'Combustible', 'Premium', 'Tarde', '34.200', '2023.27', '2026-05-19 22:57:49'), (152, 1, 12, '2026-05-01', 'Combustible', 'Premium', 'Noche', '25.400', '1473.20', '2026-05-19 22:57:49'), (153, 1, 12, '2026-05-01', 'Combustible', 'Gasoil Especial', 'Mañana', '55.700', '2620.13', '2026-05-19 22:57:49'), (154, 1, 12, '2026-05-01', 'Combustible', 'Gasoil Especial', 'Tarde', '49.200', '2314.37', '2026-05-19 22:57:49'), (155, 1, 12, '2026-05-01', 'Combustible', 'Gasoil Especial', 'Noche', '33.200', '1609.54', '2026-05-19 22:57:49'), (156, 1, 12, '2026-05-01', 'Minimercado', 'Varios', '', '0.000', '181800.00', '2026-05-19 22:57:49'), (157, 2, 13, '2025-06-01', 'Combustible', 'Gasoil', 'Mañana', '188.000', '8629.20', '2026-05-19 22:57:49'), (158, 2, 13, '2025-06-01', 'Combustible', 'Gasoil', 'Tarde', '192.500', '8489.25', '2026-05-19 22:57:49'), (159, 2, 13, '2025-06-01', 'Combustible', 'Gasoil', 'Noche', '125.000', '5737.50', '2026-05-19 22:57:49'), (160, 2, 13, '2025-06-01', 'Combustible', 'Súper', 'Mañana', '117.300', '6221.59', '2026-05-19 22:57:49'), (161, 2, 13, '2025-06-01', 'Combustible', 'Súper', 'Tarde', '95.200', '4900.90', '2026-05-19 22:57:49'), (162, 2, 13, '2025-06-01', 'Combustible', 'Súper', 'Noche', '69.300', '3675.67', '2026-05-19 22:57:49'), (163, 2, 13, '2025-06-01', 'Combustible', 'Premium', 'Mañana', '42.400', '2508.38', '2026-05-19 22:57:49'), (164, 2, 13, '2025-06-01', 'Combustible', 'Premium', 'Tarde', '33.600', '1968.29', '2026-05-19 22:57:49'), (165, 2, 13, '2025-06-01', 'Combustible', 'Premium', 'Noche', '27.300', '1567.57', '2026-05-19 22:57:49'), (166, 2, 13, '2025-06-01', 'Combustible', 'Gasoil Especial', 'Mañana', '52.300', '2560.61', '2026-05-19 22:57:49'), (167, 2, 13, '2025-06-01', 'Combustible', 'Gasoil Especial', 'Tarde', '49.500', '2423.52', '2026-05-19 22:57:49'), (168, 2, 13, '2025-06-01', 'Combustible', 'Gasoil Especial', 'Noche', '35.000', '1696.80', '2026-05-19 22:57:49'), (169, 2, 13, '2025-06-01', 'Minimercado', 'Varios', '', '0.000', '187200.00', '2026-05-19 22:57:49'), (170, 2, 14, '2025-07-01', 'Combustible', 'Gasoil', 'Mañana', '174.200', '7760.61', '2026-05-19 22:57:49'), (171, 2, 14, '2025-07-01', 'Combustible', 'Gasoil', 'Tarde', '152.400', '6926.58', '2026-05-19 22:57:49'), (172, 2, 14, '2025-07-01', 'Combustible', 'Gasoil', 'Noche', '114.900', '5273.91', '2026-05-19 22:57:49'), (173, 2, 14, '2025-07-01', 'Combustible', 'Súper', 'Mañana', '96.000', '4942.08', '2026-05-19 22:57:49'), (174, 2, 14, '2025-07-01', 'Combustible', 'Súper', 'Tarde', '83.100', '4364.41', '2026-05-19 22:57:49'), (175, 2, 14, '2025-07-01', 'Combustible', 'Súper', 'Noche', '62.600', '3287.75', '2026-05-19 22:57:49'), (176, 2, 14, '2025-07-01', 'Combustible', 'Premium', 'Mañana', '41.000', '2401.78', '2026-05-19 22:57:49'), (177, 2, 14, '2025-07-01', 'Combustible', 'Premium', 'Tarde', '36.200', '2120.60', '2026-05-19 22:57:49'), (178, 2, 14, '2025-07-01', 'Combustible', 'Premium', 'Noche', '25.400', '1502.66', '2026-05-19 22:57:49'), (179, 2, 14, '2025-07-01', 'Combustible', 'Gasoil Especial', 'Mañana', '53.200', '2528.06', '2026-05-19 22:57:49'), (180, 2, 14, '2025-07-01', 'Combustible', 'Gasoil Especial', 'Tarde', '47.000', '2256.00', '2026-05-19 22:57:49'), (181, 2, 14, '2025-07-01', 'Combustible', 'Gasoil Especial', 'Noche', '34.800', '1687.10', '2026-05-19 22:57:49'), (182, 2, 14, '2025-07-01', 'Minimercado', 'Varios', '', '0.000', '194400.00', '2026-05-19 22:57:49'), (183, 2, 15, '2025-08-01', 'Combustible', 'Gasoil', 'Mañana', '209.000', '9310.95', '2026-05-19 22:57:49'), (184, 2, 15, '2025-08-01', 'Combustible', 'Gasoil', 'Tarde', '184.600', '8390.07', '2026-05-19 22:57:49'), (185, 2, 15, '2025-08-01', 'Combustible', 'Gasoil', 'Noche', '133.100', '5869.71', '2026-05-19 22:57:49'), (186, 2, 15, '2025-08-01', 'Combustible', 'Súper', 'Mañana', '95.000', '4841.20', '2026-05-19 22:57:49'), (187, 2, 15, '2025-08-01', 'Combustible', 'Súper', 'Tarde', '97.500', '5120.70', '2026-05-19 22:57:49'), (188, 2, 15, '2025-08-01', 'Combustible', 'Súper', 'Noche', '64.500', '3421.08', '2026-05-19 22:57:49'), (189, 2, 15, '2025-08-01', 'Combustible', 'Premium', 'Mañana', '40.300', '2360.77', '2026-05-19 22:57:49'), (190, 2, 15, '2025-08-01', 'Combustible', 'Premium', 'Tarde', '36.900', '2161.60', '2026-05-19 22:57:49'), (191, 2, 15, '2025-08-01', 'Combustible', 'Premium', 'Noche', '21.800', '1251.76', '2026-05-19 22:57:49'), (192, 2, 15, '2025-08-01', 'Combustible', 'Gasoil Especial', 'Mañana', '55.700', '2727.07', '2026-05-19 22:57:49'), (193, 2, 15, '2025-08-01', 'Combustible', 'Gasoil Especial', 'Tarde', '47.000', '2233.44', '2026-05-19 22:57:49'), (194, 2, 15, '2025-08-01', 'Combustible', 'Gasoil Especial', 'Noche', '34.800', '1636.99', '2026-05-19 22:57:49'), (195, 2, 15, '2025-08-01', 'Minimercado', 'Varios', '', '0.000', '181800.00', '2026-05-19 22:57:49'), (196, 2, 16, '2025-09-01', 'Combustible', 'Gasoil', 'Mañana', '198.000', '8910.00', '2026-05-19 22:57:49'), (197, 2, 16, '2025-09-01', 'Combustible', 'Gasoil', 'Tarde', '166.300', '7483.50', '2026-05-19 22:57:49'), (198, 2, 16, '2025-09-01', 'Combustible', 'Gasoil', 'Noche', '116.300', '5338.17', '2026-05-19 22:57:49'), (199, 2, 16, '2025-09-01', 'Combustible', 'Súper', 'Mañana', '117.300', '6221.59', '2026-05-19 22:57:49'), (200, 2, 16, '2025-09-01', 'Combustible', 'Súper', 'Tarde', '102.700', '5393.80', '2026-05-19 22:57:49'), (201, 2, 16, '2025-09-01', 'Combustible', 'Súper', 'Noche', '61.300', '3155.72', '2026-05-19 22:57:49'), (202, 2, 16, '2025-09-01', 'Combustible', 'Premium', 'Mañana', '41.200', '2413.50', '2026-05-19 22:57:49'), (203, 2, 16, '2025-09-01', 'Combustible', 'Premium', 'Tarde', '32.900', '1946.36', '2026-05-19 22:57:49'), (204, 2, 16, '2025-09-01', 'Combustible', 'Premium', 'Noche', '24.500', '1392.58', '2026-05-19 22:57:49'), (205, 2, 16, '2025-09-01', 'Combustible', 'Gasoil Especial', 'Mañana', '50.700', '2384.93', '2026-05-19 22:57:49'), (206, 2, 16, '2025-09-01', 'Combustible', 'Gasoil Especial', 'Tarde', '50.400', '2395.01', '2026-05-19 22:57:49'), (207, 2, 16, '2025-09-01', 'Combustible', 'Gasoil Especial', 'Noche', '31.000', '1502.88', '2026-05-19 22:57:49'), (208, 2, 16, '2025-09-01', 'Minimercado', 'Varios', '', '0.000', '169200.00', '2026-05-19 22:57:49'), (209, 2, 17, '2025-10-01', 'Combustible', 'Gasoil', 'Mañana', '195.500', '8885.48', '2026-05-19 22:57:49'), (210, 2, 17, '2025-10-01', 'Combustible', 'Gasoil', 'Tarde', '164.300', '7245.63', '2026-05-19 22:57:49'), (211, 2, 17, '2025-10-01', 'Combustible', 'Gasoil', 'Noche', '118.500', '5385.83', '2026-05-19 22:57:49'), (212, 2, 17, '2025-10-01', 'Combustible', 'Súper', 'Mañana', '99.100', '5256.26', '2026-05-19 22:57:49'), (213, 2, 17, '2025-10-01', 'Combustible', 'Súper', 'Tarde', '97.500', '5120.70', '2026-05-19 22:57:49'), (214, 2, 17, '2025-10-01', 'Combustible', 'Súper', 'Noche', '69.000', '3552.12', '2026-05-19 22:57:49'), (215, 2, 17, '2025-10-01', 'Combustible', 'Premium', 'Mañana', '36.000', '2067.12', '2026-05-19 22:57:49'), (216, 2, 17, '2025-10-01', 'Combustible', 'Premium', 'Tarde', '31.500', '1845.27', '2026-05-19 22:57:49'), (217, 2, 17, '2025-10-01', 'Combustible', 'Premium', 'Noche', '24.700', '1446.93', '2026-05-19 22:57:49'), (218, 2, 17, '2025-10-01', 'Combustible', 'Gasoil Especial', 'Mañana', '54.200', '2653.63', '2026-05-19 22:57:49'), (219, 2, 17, '2025-10-01', 'Combustible', 'Gasoil Especial', 'Tarde', '43.400', '2104.03', '2026-05-19 22:57:49'), (220, 2, 17, '2025-10-01', 'Combustible', 'Gasoil Especial', 'Noche', '29.000', '1378.08', '2026-05-19 22:57:49'), (221, 2, 17, '2025-10-01', 'Minimercado', 'Varios', '', '0.000', '198000.00', '2026-05-19 22:57:49'), (222, 2, 18, '2025-11-01', 'Combustible', 'Gasoil', 'Mañana', '218.000', '10006.20', '2026-05-19 22:57:49'), (223, 2, 18, '2025-11-01', 'Combustible', 'Gasoil', 'Tarde', '166.300', '7408.67', '2026-05-19 22:57:49'), (224, 2, 18, '2025-11-01', 'Combustible', 'Gasoil', 'Noche', '118.800', '5452.92', '2026-05-19 22:57:49'), (225, 2, 18, '2025-11-01', 'Combustible', 'Súper', 'Mañana', '117.300', '5977.61', '2026-05-19 22:57:49'), (226, 2, 18, '2025-11-01', 'Combustible', 'Súper', 'Tarde', '90.500', '4611.88', '2026-05-19 22:57:49'), (227, 2, 18, '2025-11-01', 'Combustible', 'Súper', 'Noche', '63.300', '3324.52', '2026-05-19 22:57:49'), (228, 2, 18, '2025-11-01', 'Combustible', 'Premium', 'Mañana', '42.000', '2387.28', '2026-05-19 22:57:49'), (229, 2, 18, '2025-11-01', 'Combustible', 'Premium', 'Tarde', '32.200', '1904.95', '2026-05-19 22:57:49'), (230, 2, 18, '2025-11-01', 'Combustible', 'Premium', 'Noche', '23.000', '1347.34', '2026-05-19 22:57:49'), (231, 2, 18, '2025-11-01', 'Combustible', 'Gasoil Especial', 'Mañana', '54.400', '2663.42', '2026-05-19 22:57:49'), (232, 2, 18, '2025-11-01', 'Combustible', 'Gasoil Especial', 'Tarde', '43.900', '2149.34', '2026-05-19 22:57:49'), (233, 2, 18, '2025-11-01', 'Combustible', 'Gasoil Especial', 'Noche', '36.700', '1779.22', '2026-05-19 22:57:49'), (234, 2, 18, '2025-11-01', 'Minimercado', 'Varios', '', '0.000', '187200.00', '2026-05-19 22:57:49'), (235, 2, 19, '2025-12-01', 'Combustible', 'Gasoil', 'Mañana', '191.600', '8535.78', '2026-05-19 22:57:49'), (236, 2, 19, '2025-12-01', 'Combustible', 'Gasoil', 'Tarde', '172.700', '7693.79', '2026-05-19 22:57:49'), (237, 2, 19, '2025-12-01', 'Combustible', 'Gasoil', 'Noche', '121.000', '5553.90', '2026-05-19 22:57:49'), (238, 2, 19, '2025-12-01', 'Combustible', 'Súper', 'Mañana', '104.300', '5369.36', '2026-05-19 22:57:49'), (239, 2, 19, '2025-12-01', 'Combustible', 'Súper', 'Tarde', '95.700', '4876.87', '2026-05-19 22:57:49'), (240, 2, 19, '2025-12-01', 'Combustible', 'Súper', 'Noche', '63.900', '3289.57', '2026-05-19 22:57:49'), (241, 2, 19, '2025-12-01', 'Combustible', 'Premium', 'Mañana', '36.800', '2134.40', '2026-05-19 22:57:49'), (242, 2, 19, '2025-12-01', 'Combustible', 'Premium', 'Tarde', '35.600', '2085.45', '2026-05-19 22:57:49'), (243, 2, 19, '2025-12-01', 'Combustible', 'Premium', 'Noche', '24.200', '1431.67', '2026-05-19 22:57:49'), (244, 2, 19, '2025-12-01', 'Combustible', 'Gasoil Especial', 'Mañana', '55.700', '2700.34', '2026-05-19 22:57:49'), (245, 2, 19, '2025-12-01', 'Combustible', 'Gasoil Especial', 'Tarde', '49.200', '2337.98', '2026-05-19 22:57:49'), (246, 2, 19, '2025-12-01', 'Combustible', 'Gasoil Especial', 'Noche', '34.800', '1653.70', '2026-05-19 22:57:49'), (247, 2, 19, '2025-12-01', 'Minimercado', 'Varios', '', '0.000', '163800.00', '2026-05-19 22:57:49'), (248, 2, 20, '2026-01-01', 'Combustible', 'Gasoil', 'Mañana', '209.000', '9310.95', '2026-05-19 22:57:49'), (249, 2, 20, '2026-01-01', 'Combustible', 'Gasoil', 'Tarde', '167.700', '7621.97', '2026-05-19 22:57:49'), (250, 2, 20, '2026-01-01', 'Combustible', 'Gasoil', 'Noche', '112.500', '5011.88', '2026-05-19 22:57:49'), (251, 2, 20, '2026-01-01', 'Combustible', 'Súper', 'Mañana', '113.500', '6020.04', '2026-05-19 22:57:49'), (252, 2, 20, '2026-01-01', 'Combustible', 'Súper', 'Tarde', '91.200', '4742.40', '2026-05-19 22:57:49'), (253, 2, 20, '2026-01-01', 'Combustible', 'Súper', 'Noche', '60.000', '3182.40', '2026-05-19 22:57:49'), (254, 2, 20, '2026-01-01', 'Combustible', 'Premium', 'Mañana', '35.200', '2082.43', '2026-05-19 22:57:49'), (255, 2, 20, '2026-01-01', 'Combustible', 'Premium', 'Tarde', '33.900', '1966.20', '2026-05-19 22:57:49'), (256, 2, 20, '2026-01-01', 'Combustible', 'Premium', 'Noche', '22.300', '1280.47', '2026-05-19 22:57:49'), (257, 2, 20, '2026-01-01', 'Combustible', 'Gasoil Especial', 'Mañana', '49.000', '2375.52', '2026-05-19 22:57:49'), (258, 2, 20, '2026-01-01', 'Combustible', 'Gasoil Especial', 'Tarde', '46.500', '2187.36', '2026-05-19 22:57:49'), (259, 2, 20, '2026-01-01', 'Combustible', 'Gasoil Especial', 'Noche', '29.700', '1425.60', '2026-05-19 22:57:49'), (260, 2, 20, '2026-01-01', 'Minimercado', 'Varios', '', '0.000', '172800.00', '2026-05-19 22:57:49'), (261, 2, 21, '2026-02-01', 'Combustible', 'Gasoil', 'Mañana', '229.300', '10112.13', '2026-05-19 22:57:49'), (262, 2, 21, '2026-02-01', 'Combustible', 'Gasoil', 'Tarde', '191.300', '8436.33', '2026-05-19 22:57:49'), (263, 2, 21, '2026-02-01', 'Combustible', 'Gasoil', 'Noche', '143.300', '6319.53', '2026-05-19 22:57:49'), (264, 2, 21, '2026-02-01', 'Combustible', 'Súper', 'Mañana', '120.000', '6177.60', '2026-05-19 22:57:49'), (265, 2, 21, '2026-02-01', 'Combustible', 'Súper', 'Tarde', '108.000', '5616.00', '2026-05-19 22:57:49'), (266, 2, 21, '2026-02-01', 'Combustible', 'Súper', 'Noche', '66.400', '3383.74', '2026-05-19 22:57:49'), (267, 2, 21, '2026-02-01', 'Combustible', 'Premium', 'Mañana', '45.400', '2580.54', '2026-05-19 22:57:49'), (268, 2, 21, '2026-02-01', 'Combustible', 'Premium', 'Tarde', '38.300', '2176.97', '2026-05-19 22:57:49'), (269, 2, 21, '2026-02-01', 'Combustible', 'Premium', 'Noche', '26.800', '1585.49', '2026-05-19 22:57:49'), (270, 2, 21, '2026-02-01', 'Combustible', 'Gasoil Especial', 'Mañana', '60.000', '2851.20', '2026-05-19 22:57:49'), (271, 2, 21, '2026-02-01', 'Combustible', 'Gasoil Especial', 'Tarde', '50.000', '2352.00', '2026-05-19 22:57:49'), (272, 2, 21, '2026-02-01', 'Combustible', 'Gasoil Especial', 'Noche', '37.900', '1801.01', '2026-05-19 22:57:49'), (273, 2, 21, '2026-02-01', 'Minimercado', 'Varios', '', '0.000', '169200.00', '2026-05-19 22:57:49'), (274, 2, 22, '2026-03-01', 'Combustible', 'Gasoil', 'Mañana', '201.300', '9149.09', '2026-05-19 22:57:49'), (275, 2, 22, '2026-03-01', 'Combustible', 'Gasoil', 'Tarde', '179.500', '7996.73', '2026-05-19 22:57:49'), (276, 2, 22, '2026-03-01', 'Combustible', 'Gasoil', 'Noche', '117.300', '5384.07', '2026-05-19 22:57:49'), (277, 2, 22, '2026-03-01', 'Combustible', 'Súper', 'Mañana', '100.100', '5205.20', '2026-05-19 22:57:49'), (278, 2, 22, '2026-03-01', 'Combustible', 'Súper', 'Tarde', '84.000', '4455.36', '2026-05-19 22:57:49'), (279, 2, 22, '2026-03-01', 'Combustible', 'Súper', 'Noche', '67.700', '3449.99', '2026-05-19 22:57:49'), (280, 2, 22, '2026-03-01', 'Combustible', 'Premium', 'Mañana', '37.200', '2200.75', '2026-05-19 22:57:49'), (281, 2, 22, '2026-03-01', 'Combustible', 'Premium', 'Tarde', '31.800', '1862.84', '2026-05-19 22:57:49'), (282, 2, 22, '2026-03-01', 'Combustible', 'Premium', 'Noche', '25.600', '1499.65', '2026-05-19 22:57:49'), (283, 2, 22, '2026-03-01', 'Combustible', 'Gasoil Especial', 'Mañana', '56.300', '2729.42', '2026-05-19 22:57:49'), (284, 2, 22, '2026-03-01', 'Combustible', 'Gasoil Especial', 'Tarde', '41.500', '2011.92', '2026-05-19 22:57:49'), (285, 2, 22, '2026-03-01', 'Combustible', 'Gasoil Especial', 'Noche', '29.000', '1364.16', '2026-05-19 22:57:49'), (286, 2, 22, '2026-03-01', 'Minimercado', 'Varios', '', '0.000', '178200.00', '2026-05-19 22:57:49'), (287, 2, 23, '2026-04-01', 'Combustible', 'Gasoil', 'Mañana', '188.000', '8544.60', '2026-05-19 22:57:49'), (288, 2, 23, '2026-04-01', 'Combustible', 'Gasoil', 'Tarde', '173.300', '7798.50', '2026-05-19 22:57:49'), (289, 2, 23, '2026-04-01', 'Combustible', 'Gasoil', 'Noche', '112.500', '5011.88', '2026-05-19 22:57:49'), (290, 2, 23, '2026-04-01', 'Combustible', 'Súper', 'Mañana', '112.000', '5765.76', '2026-05-19 22:57:49'), (291, 2, 23, '2026-04-01', 'Combustible', 'Súper', 'Tarde', '92.400', '4708.70', '2026-05-19 22:57:49'), (292, 2, 23, '2026-04-01', 'Combustible', 'Súper', 'Noche', '65.300', '3429.56', '2026-05-19 22:57:49'), (293, 2, 23, '2026-04-01', 'Combustible', 'Premium', 'Mañana', '39.600', '2250.86', '2026-05-19 22:57:49'), (294, 2, 23, '2026-04-01', 'Combustible', 'Premium', 'Tarde', '33.600', '1909.82', '2026-05-19 22:57:49'), (295, 2, 23, '2026-04-01', 'Combustible', 'Premium', 'Noche', '23.000', '1320.66', '2026-05-19 22:57:49'), (296, 2, 23, '2026-04-01', 'Combustible', 'Gasoil Especial', 'Mañana', '51.700', '2431.97', '2026-05-19 22:57:49'), (297, 2, 23, '2026-04-01', 'Combustible', 'Gasoil Especial', 'Tarde', '44.300', '2126.40', '2026-05-19 22:57:49'), (298, 2, 23, '2026-04-01', 'Combustible', 'Gasoil Especial', 'Noche', '33.000', '1615.68', '2026-05-19 22:57:49'), (299, 2, 23, '2026-04-01', 'Minimercado', 'Varios', '', '0.000', '174600.00', '2026-05-19 22:57:49'), (300, 2, 24, '2026-05-01', 'Combustible', 'Gasoil', 'Mañana', '195.500', '8709.53', '2026-05-19 22:57:49'), (301, 2, 24, '2026-05-01', 'Combustible', 'Gasoil', 'Tarde', '177.800', '8081.01', '2026-05-19 22:57:49'), (302, 2, 24, '2026-05-01', 'Combustible', 'Gasoil', 'Noche', '128.200', '5769.00', '2026-05-19 22:57:49'), (303, 2, 24, '2026-05-01', 'Combustible', 'Súper', 'Mañana', '95.000', '4989.40', '2026-05-19 22:57:49'), (304, 2, 24, '2026-05-01', 'Combustible', 'Súper', 'Tarde', '82.200', '4274.40', '2026-05-19 22:57:49'), (305, 2, 24, '2026-05-01', 'Combustible', 'Súper', 'Noche', '71.000', '3692.00', '2026-05-19 22:57:49'), (306, 2, 24, '2026-05-01', 'Combustible', 'Premium', 'Mañana', '37.900', '2198.20', '2026-05-19 22:57:49'), (307, 2, 24, '2026-05-01', 'Combustible', 'Premium', 'Tarde', '34.200', '1983.60', '2026-05-19 22:57:49'), (308, 2, 24, '2026-05-01', 'Combustible', 'Premium', 'Noche', '25.600', '1514.50', '2026-05-19 22:57:49'), (309, 2, 24, '2026-05-01', 'Combustible', 'Gasoil Especial', 'Mañana', '50.600', '2428.80', '2026-05-19 22:57:49'), (310, 2, 24, '2026-05-01', 'Combustible', 'Gasoil Especial', 'Tarde', '49.700', '2385.60', '2026-05-19 22:57:49'), (311, 2, 24, '2026-05-01', 'Combustible', 'Gasoil Especial', 'Noche', '32.600', '1549.15', '2026-05-19 22:57:49'), (312, 2, 24, '2026-05-01', 'Minimercado', 'Varios', '', '0.000', '176400.00', '2026-05-19 22:57:49'), (352, 3, 33, '2025-02-28', 'Combustible', 'Gasoil', '', '32334.350', '1349118.79', '2026-05-29 17:27:21'), (353, 3, 33, '2025-02-28', 'Combustible', 'Gasoil Especial', '', '14076.960', '670386.65', '2026-05-29 17:27:21'), (354, 3, 33, '2025-02-28', 'Combustible', 'Premium', '', '94798.280', '7686202.70', '2026-05-29 17:27:21'), (355, 3, 33, '2025-02-28', 'Combustible', 'Súper', '', '439288.310', '34500321.42', '2026-05-29 17:27:21'), (362, 3, 34, '2025-03-31', 'Combustible', 'Gasoil', '', '33385.010', '1393277.00', '2026-05-29 17:35:17'), (363, 3, 34, '2025-03-31', 'Combustible', 'Gasoil Especial', '', '12376.080', '589385.31', '2026-05-29 17:35:17'), (364, 3, 34, '2025-03-31', 'Combustible', 'Premium', '', '98439.910', '7981538.16', '2026-05-29 17:35:17'), (365, 3, 34, '2025-03-31', 'Combustible', 'Súper', '', '456496.140', '35858575.28', '2026-05-29 17:35:17'), (376, 3, 35, '2025-04-30', 'Combustible', 'Gasoil', '', '31505.090', '1295617.06', '2026-05-29 17:53:34'), (377, 3, 35, '2025-04-30', 'Combustible', 'Gasoil Especial', '', '11973.680', '570221.70', '2026-05-29 17:53:34'), (378, 3, 35, '2025-04-30', 'Combustible', 'Premium', '', '92000.410', '7459419.84', '2026-05-29 17:53:34'), (379, 3, 35, '2025-04-30', 'Combustible', 'Súper', '', '423499.000', '33261675.74', '2026-05-29 17:53:34'), (385, 3, 36, '2025-05-31', 'Combustible', 'Gasoil', '', '36388.380', '1474029.41', '2026-05-29 18:35:56'), (386, 3, 36, '2025-05-31', 'Combustible', 'Gasoil Especial', '', '12652.050', '593506.46', '2026-05-29 18:35:56'), (387, 3, 36, '2025-05-31', 'Combustible', 'Premium', '', '92479.220', '7498244.84', '2026-05-29 18:35:56'), (388, 3, 36, '2025-05-31', 'Combustible', 'Súper', '', '436427.060', '34277052.49', '2026-05-29 18:35:56'), (397, 3, 37, '2025-06-30', 'Combustible', 'Gasoil', '', '42138.460', '1623758.47', '2026-05-29 19:39:32'), (398, 3, 37, '2025-06-30', 'Combustible', 'Gasoil Especial', '', '12868.170', '569891.97', '2026-05-29 19:39:32'), (399, 3, 37, '2025-06-30', 'Combustible', 'Premium', '', '89056.850', '7202008.69', '2026-05-29 19:39:32'), (400, 3, 37, '2025-06-30', 'Combustible', 'Súper', '', '405282.850', '31802487.84', '2026-05-29 19:39:32'), (413, 3, 38, '2025-07-31', 'Combustible', 'Gasoil', '', '44547.150', '1873609.09', '2026-05-29 19:51:51'), (414, 3, 38, '2025-07-31', 'Combustible', 'Gasoil Especial', '', '12136.990', '547955.36', '2026-05-29 19:51:51'), (415, 3, 38, '2025-07-31', 'Combustible', 'Premium', '', '96170.840', '7802321.32', '2026-05-29 19:51:51'), (416, 3, 38, '2025-07-31', 'Combustible', 'Súper', '', '407447.210', '32074180.81', '2026-05-29 19:51:51'), (417, 3, 44, '2025-08-31', 'Combustible', 'Súper', '', '430331.590', '33875559.72', '2026-05-29 20:04:01'), (418, 3, 44, '2025-08-31', 'Combustible', 'Premium', '', '99290.260', '8055398.12', '2026-05-29 20:04:01'), (419, 3, 44, '2025-08-31', 'Combustible', 'Gasoil Especial', '', '15519.000', '700645.08', '2026-05-29 20:04:01'), (420, 3, 44, '2025-08-31', 'Combustible', 'Gasoil', '', '52060.780', '2051706.45', '2026-05-29 20:04:01'), (441, 3, 40, '2025-09-30', 'Combustible', 'Gasoil', '', '53127.430', '2182735.72', '2026-05-29 20:10:52'), (442, 3, 40, '2025-09-30', 'Combustible', 'Gasoil Especial', '', '12099.210', '566678.11', '2026-05-29 20:10:52'), (443, 3, 40, '2025-09-30', 'Combustible', 'Premium', '', '95609.750', '7707202.56', '2026-05-29 20:10:52'), (444, 3, 40, '2025-09-30', 'Combustible', 'Súper', '', '416267.950', '32552219.00', '2026-05-29 20:10:52'), (453, 3, 41, '2025-10-31', 'Combustible', 'Gasoil', '', '48175.790', '1979950.39', '2026-05-29 20:17:40'), (454, 3, 41, '2025-10-31', 'Combustible', 'Gasoil Especial', '', '15728.460', '736658.53', '2026-05-29 20:17:40'), (455, 3, 41, '2025-10-31', 'Combustible', 'Premium', '', '107771.640', '8687482.73', '2026-05-29 20:17:40'), (456, 3, 41, '2025-10-31', 'Combustible', 'Súper', '', '461215.570', '36066976.40', '2026-05-29 20:17:40'), (465, 3, 42, '2025-11-30', 'Combustible', 'Gasoil', '', '43348.380', '1768149.27', '2026-05-29 20:31:51'), (466, 3, 42, '2025-11-30', 'Combustible', 'Gasoil Especial', '', '15156.980', '705296.12', '2026-05-29 20:31:51'), (467, 3, 42, '2025-11-30', 'Combustible', 'Premium', '', '111457.770', '8970145.44', '2026-05-29 20:31:51'), (468, 3, 42, '2025-11-30', 'Combustible', 'Súper', '', '453387.680', '35373405.20', '2026-05-29 20:31:51'), (469, 3, 43, '2025-01-31', 'Combustible', 'Gasoil', '', '34279.110', '1402401.67', '2026-05-29 20:36:44'), (470, 3, 43, '2025-01-31', 'Combustible', 'Gasoil Especial', '', '12516.700', '596082.05', '2026-05-29 20:36:44'), (471, 3, 43, '2025-01-31', 'Combustible', 'Premium', '', '91948.870', '7455243.53', '2026-05-29 20:36:44'), (472, 3, 43, '2025-01-31', 'Combustible', 'Súper', '', '420136.450', '32997570.12', '2026-05-29 20:36:44'), (493, 3, 45, '2025-12-31', 'Combustible', 'Gasoil', '', '45765.430', '1867007.57', '2026-05-30 14:35:01'), (494, 3, 45, '2025-12-31', 'Combustible', 'Gasoil Especial', '', '17362.540', '807928.36', '2026-05-30 14:35:01'), (495, 3, 45, '2025-12-31', 'Combustible', 'Premium', '', '120406.080', '9690300.74', '2026-05-30 14:35:01'), (496, 3, 45, '2025-12-31', 'Combustible', 'Súper', '', '512224.530', '39963646.97', '2026-05-30 14:35:01'), (613, 3, 30, '2026-02-28', 'Combustible', 'Gasoil', '', '41995.460', '1682793.02', '2026-05-30 17:21:16'), (614, 3, 30, '2026-02-28', 'Combustible', 'Gasoil Especial', '', '16220.640', '743224.20', '2026-05-30 17:21:16'), (615, 3, 30, '2026-02-28', 'Minimercado', 'Otros', '', '0.000', '3590903.11', '2026-05-30 17:21:16'), (616, 3, 30, '2026-02-28', 'Otros pista', 'Otros', '', '0.000', '435262.33', '2026-05-30 17:21:16'), (617, 3, 30, '2026-02-28', 'Red pago', 'Otros', '', '0.000', '84393.36', '2026-05-30 17:21:16'), (618, 3, 30, '2026-02-28', 'Combustible', 'Premium', '', '98772.890', '7931456.54', '2026-05-30 17:21:16'), (619, 3, 30, '2026-02-28', 'Combustible', 'Súper', '', '412967.190', '32124695.25', '2026-05-30 17:21:16'), (620, 3, 25, '2026-03-31', 'Combustible', 'Gasoil', '', '51691.000', '2004711.00', '2026-05-30 17:47:24'), (621, 3, 25, '2026-03-31', 'Combustible', 'Gasoil Especial', '', '16703.000', '743344.00', '2026-05-30 17:47:24'), (622, 3, 25, '2026-03-31', 'Minimercado', 'Otros', '', '0.000', '3256100.00', '2026-05-30 17:47:24'), (623, 3, 25, '2026-03-31', 'Otros pista', 'Otros', '', '0.000', '717182.00', '2026-05-30 17:47:24'), (624, 3, 25, '2026-03-31', 'Combustible', 'Premium', '', '108363.000', '8604129.00', '2026-05-30 17:47:24'), (625, 3, 25, '2026-03-31', 'Red pago', 'Otros', '', '0.000', '94840.00', '2026-05-30 17:47:24'), (626, 3, 25, '2026-03-31', 'Combustible', 'Súper', '', '457834.000', '35198194.00', '2026-05-30 17:47:24'), (651, 3, 47, '2026-04-30', 'Combustible', 'Gasoil', '', '38762.030', '1861005.56', '2026-06-04 12:20:13'), (652, 3, 47, '2026-04-30', 'Combustible', 'Gasoil Especial', '', '14993.490', '714402.20', '2026-06-04 12:20:13'), (653, 3, 47, '2026-04-30', 'Otros pista', 'Otros', '', '0.000', '723871.37', '2026-06-04 12:20:13'), (654, 3, 47, '2026-04-30', 'Red pago', 'Otros', '', '0.000', '82179.89', '2026-06-04 12:20:13'), (655, 3, 47, '2026-04-30', 'Minimercado', 'Otros', '', '0.000', '2788023.54', '2026-06-04 12:20:13'), (656, 3, 47, '2026-04-30', 'Combustible', 'Premium', '', '93976.600', '7983309.55', '2026-06-04 12:20:13'), (657, 3, 47, '2026-04-30', 'Combustible', 'Súper', '', '394396.960', '32711403.57', '2026-06-04 12:20:13'), (686, 3, 31, '2026-01-31', 'Combustible', 'Gasoil', '', '31610.940', '1266985.80', '2026-06-06 22:14:18'), (687, 3, 31, '2026-01-31', 'Combustible', 'Gasoil Especial', '', '15026.920', '688529.17', '2026-06-06 22:14:18'), (688, 3, 31, '2026-01-31', 'Minimercado', 'Otros', '', '0.000', '3953619.03', '2026-06-06 22:14:18'), (689, 3, 31, '2026-01-31', 'Otros pista', 'Otros', '', '0.000', '494941.73', '2026-06-06 22:14:18'), (690, 3, 31, '2026-01-31', 'Red pago', 'Otros', '', '0.000', '119384.85', '2026-06-06 22:14:18'), (691, 3, 31, '2026-01-31', 'Combustible', 'Premium', '', '99873.980', '8019877.74', '2026-06-06 22:14:18'), (692, 3, 31, '2026-01-31', 'Combustible', 'Súper', '', '410817.450', '31957473.22', '2026-06-06 22:14:18'); -- -- Indexes for dumped tables -- -- -- Indexes for table `configuraciones` -- ALTER TABLE `configuraciones` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `uq_config` (`usuario_id`,`empresa_id`,`clave`); -- -- Indexes for table `costos` -- ALTER TABLE `costos` ADD PRIMARY KEY (`id`), ADD KEY `idx_costos_empresa_periodo` (`empresa_id`,`periodo_id`); -- -- Indexes for table `custom_widgets` -- ALTER TABLE `custom_widgets` ADD PRIMARY KEY (`id`), ADD KEY `idx_empresa` (`empresa_id`); -- -- Indexes for table `custom_widget_valores` -- ALTER TABLE `custom_widget_valores` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `uq_widget_periodo` (`widget_id`,`periodo_id`); -- -- Indexes for table `empresas` -- ALTER TABLE `empresas` ADD PRIMARY KEY (`id`); -- -- Indexes for table `finanzas` -- ALTER TABLE `finanzas` ADD PRIMARY KEY (`id`), ADD KEY `idx_finanzas_empresa_periodo` (`empresa_id`,`periodo_id`); -- -- Indexes for table `mermas` -- ALTER TABLE `mermas` ADD PRIMARY KEY (`id`), ADD KEY `idx_mermas_empresa_periodo` (`empresa_id`,`periodo_id`); -- -- Indexes for table `migrations` -- ALTER TABLE `migrations` ADD PRIMARY KEY (`id`); -- -- Indexes for table `parametros` -- ALTER TABLE `parametros` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `uq_parametros` (`empresa_id`,`periodo_id`,`parametro`), ADD KEY `idx_parametros_empresa_periodo` (`empresa_id`,`periodo_id`); -- -- Indexes for table `periodos` -- ALTER TABLE `periodos` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `uq_periodos_empresa_fecha` (`empresa_id`,`fecha`), ADD KEY `idx_periodos_empresa` (`empresa_id`); -- -- Indexes for table `personal` -- ALTER TABLE `personal` ADD PRIMARY KEY (`id`), ADD KEY `idx_personal_empresa_periodo` (`empresa_id`,`periodo_id`); -- -- Indexes for table `stock` -- ALTER TABLE `stock` ADD PRIMARY KEY (`id`), ADD KEY `idx_stock_empresa_periodo` (`empresa_id`,`periodo_id`); -- -- Indexes for table `usuarios` -- ALTER TABLE `usuarios` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `uq_usuarios_email` (`email`), ADD KEY `idx_usuarios_empresa` (`empresa_id`); -- -- Indexes for table `ventas` -- ALTER TABLE `ventas` ADD PRIMARY KEY (`id`), ADD KEY `idx_ventas_empresa_periodo` (`empresa_id`,`periodo_id`), ADD KEY `idx_ventas_fecha` (`fecha`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `configuraciones` -- ALTER TABLE `configuraciones` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=68; -- -- AUTO_INCREMENT for table `costos` -- ALTER TABLE `costos` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2109; -- -- AUTO_INCREMENT for table `custom_widgets` -- ALTER TABLE `custom_widgets` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15; -- -- AUTO_INCREMENT for table `custom_widget_valores` -- ALTER TABLE `custom_widget_valores` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9; -- -- AUTO_INCREMENT for table `empresas` -- ALTER TABLE `empresas` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `finanzas` -- ALTER TABLE `finanzas` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=139; -- -- AUTO_INCREMENT for table `mermas` -- ALTER TABLE `mermas` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=124; -- -- AUTO_INCREMENT for table `migrations` -- ALTER TABLE `migrations` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13; -- -- AUTO_INCREMENT for table `parametros` -- ALTER TABLE `parametros` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=120; -- -- AUTO_INCREMENT for table `periodos` -- ALTER TABLE `periodos` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=48; -- -- AUTO_INCREMENT for table `personal` -- ALTER TABLE `personal` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=97; -- -- AUTO_INCREMENT for table `stock` -- ALTER TABLE `stock` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=272; -- -- AUTO_INCREMENT for table `usuarios` -- ALTER TABLE `usuarios` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `ventas` -- ALTER TABLE `ventas` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=693; COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;