--
-- Host: 127.0.0.1    Database: panel_bordo
-- ------------------------------------------------------


--
-- Table structure for table `costos`
--

CREATE TABLE `costos` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `empresa_id` int unsigned NOT NULL,
  `periodo_id` int unsigned NOT NULL,
  `fecha` date NOT NULL,
  `unidad_negocio` varchar(80) NOT NULL DEFAULT '',
  `tipo_costo` varchar(100) NOT NULL DEFAULT '',
  `importe` decimal(14,2) NOT NULL DEFAULT '0.00',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `idx_costos_empresa_periodo` (`empresa_id`,`periodo_id`)
) ENGINE=InnoDB AUTO_INCREMENT=201 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `costos`
--

INSERT INTO `costos` VALUES (1,1,1,'2025-06-01','Combustible','Costo combustible',686000.00,'2026-05-19 22:57:49'),(2,1,1,'2025-06-01','Administración','Arrendamiento',47250.00,'2026-05-19 22:57:49'),(3,1,1,'2025-06-01','Administración','Sueldos y cargas',167400.00,'2026-05-19 22:57:49'),(4,1,1,'2025-06-01','Administración','Energía eléctrica',23980.00,'2026-05-19 22:57:49'),(5,1,1,'2025-06-01','Combustible','Comisiones',32550.00,'2026-05-19 22:57:49'),(6,1,1,'2025-06-01','Administración','Mantenimiento',18900.00,'2026-05-19 22:57:49'),(7,1,1,'2025-06-01','Administración','Seguros',12600.00,'2026-05-19 22:57:49'),(8,1,1,'2025-06-01','Administración','Gastos generales',8320.00,'2026-05-19 22:57:49'),(9,1,2,'2025-07-01','Combustible','Costo combustible',644000.00,'2026-05-19 22:57:49'),(10,1,2,'2025-07-01','Administración','Arrendamiento',43200.00,'2026-05-19 22:57:49'),(11,1,2,'2025-07-01','Administración','Sueldos y cargas',190800.00,'2026-05-19 22:57:49'),(12,1,2,'2025-07-01','Administración','Energía eléctrica',22440.00,'2026-05-19 22:57:49'),(13,1,2,'2025-07-01','Combustible','Comisiones',36400.00,'2026-05-19 22:57:49'),(14,1,2,'2025-07-01','Administración','Mantenimiento',18900.00,'2026-05-19 22:57:49'),(15,1,2,'2025-07-01','Administración','Seguros',13080.00,'2026-05-19 22:57:49'),(16,1,2,'2025-07-01','Administración','Gastos generales',8480.00,'2026-05-19 22:57:49'),(17,1,3,'2025-08-01','Combustible','Costo combustible',714000.00,'2026-05-19 22:57:49'),(18,1,3,'2025-08-01','Administración','Arrendamiento',45000.00,'2026-05-19 22:57:49'),(19,1,3,'2025-08-01','Administración','Sueldos y cargas',190800.00,'2026-05-19 22:57:49'),(20,1,3,'2025-08-01','Administración','Energía eléctrica',21780.00,'2026-05-19 22:57:49'),(21,1,3,'2025-08-01','Combustible','Comisiones',37100.00,'2026-05-19 22:57:49'),(22,1,3,'2025-08-01','Administración','Mantenimiento',16740.00,'2026-05-19 22:57:49'),(23,1,3,'2025-08-01','Administración','Seguros',12240.00,'2026-05-19 22:57:49'),(24,1,3,'2025-08-01','Administración','Gastos generales',7760.00,'2026-05-19 22:57:49'),(25,1,4,'2025-09-01','Combustible','Costo combustible',714000.00,'2026-05-19 22:57:49'),(26,1,4,'2025-09-01','Administración','Arrendamiento',40950.00,'2026-05-19 22:57:49'),(27,1,4,'2025-09-01','Administración','Sueldos y cargas',169200.00,'2026-05-19 22:57:49'),(28,1,4,'2025-09-01','Administración','Energía eléctrica',21120.00,'2026-05-19 22:57:49'),(29,1,4,'2025-09-01','Combustible','Comisiones',37100.00,'2026-05-19 22:57:49'),(30,1,4,'2025-09-01','Administración','Mantenimiento',18540.00,'2026-05-19 22:57:49'),(31,1,4,'2025-09-01','Administración','Seguros',12360.00,'2026-05-19 22:57:49'),(32,1,4,'2025-09-01','Administración','Gastos generales',8400.00,'2026-05-19 22:57:49'),(33,1,5,'2025-10-01','Combustible','Costo combustible',700000.00,'2026-05-19 22:57:49'),(34,1,5,'2025-10-01','Administración','Arrendamiento',47700.00,'2026-05-19 22:57:49'),(35,1,5,'2025-10-01','Administración','Sueldos y cargas',196200.00,'2026-05-19 22:57:49'),(36,1,5,'2025-10-01','Administración','Energía eléctrica',20900.00,'2026-05-19 22:57:49'),(37,1,5,'2025-10-01','Combustible','Comisiones',35700.00,'2026-05-19 22:57:49'),(38,1,5,'2025-10-01','Administración','Mantenimiento',19440.00,'2026-05-19 22:57:49'),(39,1,5,'2025-10-01','Administración','Seguros',13200.00,'2026-05-19 22:57:49'),(40,1,5,'2025-10-01','Administración','Gastos generales',8320.00,'2026-05-19 22:57:49'),(41,1,6,'2025-11-01','Combustible','Costo combustible',728000.00,'2026-05-19 22:57:49'),(42,1,6,'2025-11-01','Administración','Arrendamiento',48150.00,'2026-05-19 22:57:49'),(43,1,6,'2025-11-01','Administración','Sueldos y cargas',194400.00,'2026-05-19 22:57:49'),(44,1,6,'2025-11-01','Administración','Energía eléctrica',20020.00,'2026-05-19 22:57:49'),(45,1,6,'2025-11-01','Combustible','Comisiones',33950.00,'2026-05-19 22:57:49'),(46,1,6,'2025-11-01','Administración','Mantenimiento',19800.00,'2026-05-19 22:57:49'),(47,1,6,'2025-11-01','Administración','Seguros',11640.00,'2026-05-19 22:57:49'),(48,1,6,'2025-11-01','Administración','Gastos generales',8400.00,'2026-05-19 22:57:49'),(49,1,7,'2025-12-01','Combustible','Costo combustible',658000.00,'2026-05-19 22:57:49'),(50,1,7,'2025-12-01','Administración','Arrendamiento',42300.00,'2026-05-19 22:57:49'),(51,1,7,'2025-12-01','Administración','Sueldos y cargas',194400.00,'2026-05-19 22:57:49'),(52,1,7,'2025-12-01','Administración','Energía eléctrica',22000.00,'2026-05-19 22:57:49'),(53,1,7,'2025-12-01','Combustible','Comisiones',37800.00,'2026-05-19 22:57:49'),(54,1,7,'2025-12-01','Administración','Mantenimiento',17640.00,'2026-05-19 22:57:49'),(55,1,7,'2025-12-01','Administración','Seguros',12000.00,'2026-05-19 22:57:49'),(56,1,7,'2025-12-01','Administración','Gastos generales',8400.00,'2026-05-19 22:57:49'),(57,1,8,'2026-01-01','Combustible','Costo combustible',665000.00,'2026-05-19 22:57:49'),(58,1,8,'2026-01-01','Administración','Arrendamiento',42300.00,'2026-05-19 22:57:49'),(59,1,8,'2026-01-01','Administración','Sueldos y cargas',190800.00,'2026-05-19 22:57:49'),(60,1,8,'2026-01-01','Administración','Energía eléctrica',22880.00,'2026-05-19 22:57:49'),(61,1,8,'2026-01-01','Combustible','Comisiones',36750.00,'2026-05-19 22:57:49'),(62,1,8,'2026-01-01','Administración','Mantenimiento',18000.00,'2026-05-19 22:57:49'),(63,1,8,'2026-01-01','Administración','Seguros',12600.00,'2026-05-19 22:57:49'),(64,1,8,'2026-01-01','Administración','Gastos generales',7920.00,'2026-05-19 22:57:49'),(65,1,9,'2026-02-01','Combustible','Costo combustible',700000.00,'2026-05-19 22:57:49'),(66,1,9,'2026-02-01','Administración','Arrendamiento',47250.00,'2026-05-19 22:57:49'),(67,1,9,'2026-02-01','Administración','Sueldos y cargas',185400.00,'2026-05-19 22:57:49'),(68,1,9,'2026-02-01','Administración','Energía eléctrica',20680.00,'2026-05-19 22:57:49'),(69,1,9,'2026-02-01','Combustible','Comisiones',35000.00,'2026-05-19 22:57:49'),(70,1,9,'2026-02-01','Administración','Mantenimiento',19260.00,'2026-05-19 22:57:49'),(71,1,9,'2026-02-01','Administración','Seguros',12000.00,'2026-05-19 22:57:49'),(72,1,9,'2026-02-01','Administración','Gastos generales',7440.00,'2026-05-19 22:57:49'),(73,1,10,'2026-03-01','Combustible','Costo combustible',637000.00,'2026-05-19 22:57:49'),(74,1,10,'2026-03-01','Administración','Arrendamiento',49050.00,'2026-05-19 22:57:49'),(75,1,10,'2026-03-01','Administración','Sueldos y cargas',163800.00,'2026-05-19 22:57:49'),(76,1,10,'2026-03-01','Administración','Energía eléctrica',23540.00,'2026-05-19 22:57:49'),(77,1,10,'2026-03-01','Combustible','Comisiones',36400.00,'2026-05-19 22:57:49'),(78,1,10,'2026-03-01','Administración','Mantenimiento',16740.00,'2026-05-19 22:57:49'),(79,1,10,'2026-03-01','Administración','Seguros',11280.00,'2026-05-19 22:57:49'),(80,1,10,'2026-03-01','Administración','Gastos generales',7600.00,'2026-05-19 22:57:49'),(81,1,11,'2026-04-01','Combustible','Costo combustible',693000.00,'2026-05-19 22:57:49'),(82,1,11,'2026-04-01','Administración','Arrendamiento',46800.00,'2026-05-19 22:57:49'),(83,1,11,'2026-04-01','Administración','Sueldos y cargas',181800.00,'2026-05-19 22:57:49'),(84,1,11,'2026-04-01','Administración','Energía eléctrica',23980.00,'2026-05-19 22:57:49'),(85,1,11,'2026-04-01','Combustible','Comisiones',32900.00,'2026-05-19 22:57:49'),(86,1,11,'2026-04-01','Administración','Mantenimiento',16200.00,'2026-05-19 22:57:49'),(87,1,11,'2026-04-01','Administración','Seguros',10800.00,'2026-05-19 22:57:49'),(88,1,11,'2026-04-01','Administración','Gastos generales',8160.00,'2026-05-19 22:57:49'),(89,1,12,'2026-05-01','Combustible','Costo combustible',665000.00,'2026-05-19 22:57:49'),(90,1,12,'2026-05-01','Administración','Arrendamiento',44100.00,'2026-05-19 22:57:49'),(91,1,12,'2026-05-01','Administración','Sueldos y cargas',180000.00,'2026-05-19 22:57:49'),(92,1,12,'2026-05-01','Administración','Energía eléctrica',20240.00,'2026-05-19 22:57:49'),(93,1,12,'2026-05-01','Combustible','Comisiones',35350.00,'2026-05-19 22:57:49'),(94,1,12,'2026-05-01','Administración','Mantenimiento',16200.00,'2026-05-19 22:57:49'),(95,1,12,'2026-05-01','Administración','Seguros',13200.00,'2026-05-19 22:57:49'),(96,1,12,'2026-05-01','Administración','Gastos generales',7440.00,'2026-05-19 22:57:49'),(97,2,13,'2025-06-01','Combustible','Costo combustible',707000.00,'2026-05-19 22:57:49'),(98,2,13,'2025-06-01','Administración','Arrendamiento',44550.00,'2026-05-19 22:57:49'),(99,2,13,'2025-06-01','Administración','Sueldos y cargas',198000.00,'2026-05-19 22:57:49'),(100,2,13,'2025-06-01','Administración','Energía eléctrica',22220.00,'2026-05-19 22:57:49'),(101,2,13,'2025-06-01','Combustible','Comisiones',36750.00,'2026-05-19 22:57:49'),(102,2,13,'2025-06-01','Administración','Mantenimiento',19440.00,'2026-05-19 22:57:49'),(103,2,13,'2025-06-01','Administración','Seguros',13200.00,'2026-05-19 22:57:49'),(104,2,13,'2025-06-01','Administración','Gastos generales',8320.00,'2026-05-19 22:57:49'),(105,2,14,'2025-07-01','Combustible','Costo combustible',763000.00,'2026-05-19 22:57:49'),(106,2,14,'2025-07-01','Administración','Arrendamiento',40950.00,'2026-05-19 22:57:49'),(107,2,14,'2025-07-01','Administración','Sueldos y cargas',178200.00,'2026-05-19 22:57:49'),(108,2,14,'2025-07-01','Administración','Energía eléctrica',22000.00,'2026-05-19 22:57:49'),(109,2,14,'2025-07-01','Combustible','Comisiones',31500.00,'2026-05-19 22:57:49'),(110,2,14,'2025-07-01','Administración','Mantenimiento',18900.00,'2026-05-19 22:57:49'),(111,2,14,'2025-07-01','Administración','Seguros',11760.00,'2026-05-19 22:57:49'),(112,2,14,'2025-07-01','Administración','Gastos generales',8080.00,'2026-05-19 22:57:49'),(113,2,15,'2025-08-01','Combustible','Costo combustible',679000.00,'2026-05-19 22:57:49'),(114,2,15,'2025-08-01','Administración','Arrendamiento',44550.00,'2026-05-19 22:57:49'),(115,2,15,'2025-08-01','Administración','Sueldos y cargas',194400.00,'2026-05-19 22:57:49'),(116,2,15,'2025-08-01','Administración','Energía eléctrica',23540.00,'2026-05-19 22:57:49'),(117,2,15,'2025-08-01','Combustible','Comisiones',32900.00,'2026-05-19 22:57:49'),(118,2,15,'2025-08-01','Administración','Mantenimiento',17640.00,'2026-05-19 22:57:49'),(119,2,15,'2025-08-01','Administración','Seguros',12600.00,'2026-05-19 22:57:49'),(120,2,15,'2025-08-01','Administración','Gastos generales',8400.00,'2026-05-19 22:57:49'),(121,2,16,'2025-09-01','Combustible','Costo combustible',658000.00,'2026-05-19 22:57:49'),(122,2,16,'2025-09-01','Administración','Arrendamiento',46800.00,'2026-05-19 22:57:49'),(123,2,16,'2025-09-01','Administración','Sueldos y cargas',176400.00,'2026-05-19 22:57:49'),(124,2,16,'2025-09-01','Administración','Energía eléctrica',19800.00,'2026-05-19 22:57:49'),(125,2,16,'2025-09-01','Combustible','Comisiones',37100.00,'2026-05-19 22:57:49'),(126,2,16,'2025-09-01','Administración','Mantenimiento',16380.00,'2026-05-19 22:57:49'),(127,2,16,'2025-09-01','Administración','Seguros',10800.00,'2026-05-19 22:57:49'),(128,2,16,'2025-09-01','Administración','Gastos generales',8240.00,'2026-05-19 22:57:49'),(129,2,17,'2025-10-01','Combustible','Costo combustible',637000.00,'2026-05-19 22:57:49'),(130,2,17,'2025-10-01','Administración','Arrendamiento',43650.00,'2026-05-19 22:57:49'),(131,2,17,'2025-10-01','Administración','Sueldos y cargas',180000.00,'2026-05-19 22:57:49'),(132,2,17,'2025-10-01','Administración','Energía eléctrica',21560.00,'2026-05-19 22:57:49'),(133,2,17,'2025-10-01','Combustible','Comisiones',35700.00,'2026-05-19 22:57:49'),(134,2,17,'2025-10-01','Administración','Mantenimiento',18180.00,'2026-05-19 22:57:49'),(135,2,17,'2025-10-01','Administración','Seguros',12000.00,'2026-05-19 22:57:49'),(136,2,17,'2025-10-01','Administración','Gastos generales',7840.00,'2026-05-19 22:57:49'),(137,2,18,'2025-11-01','Combustible','Costo combustible',749000.00,'2026-05-19 22:57:49'),(138,2,18,'2025-11-01','Administración','Arrendamiento',43650.00,'2026-05-19 22:57:49'),(139,2,18,'2025-11-01','Administración','Sueldos y cargas',183600.00,'2026-05-19 22:57:49'),(140,2,18,'2025-11-01','Administración','Energía eléctrica',20900.00,'2026-05-19 22:57:49'),(141,2,18,'2025-11-01','Combustible','Comisiones',38150.00,'2026-05-19 22:57:49'),(142,2,18,'2025-11-01','Administración','Mantenimiento',17820.00,'2026-05-19 22:57:49'),(143,2,18,'2025-11-01','Administración','Seguros',11760.00,'2026-05-19 22:57:49'),(144,2,18,'2025-11-01','Administración','Gastos generales',7840.00,'2026-05-19 22:57:49'),(145,2,19,'2025-12-01','Combustible','Costo combustible',644000.00,'2026-05-19 22:57:49'),(146,2,19,'2025-12-01','Administración','Arrendamiento',40500.00,'2026-05-19 22:57:49'),(147,2,19,'2025-12-01','Administración','Sueldos y cargas',192600.00,'2026-05-19 22:57:49'),(148,2,19,'2025-12-01','Administración','Energía eléctrica',22440.00,'2026-05-19 22:57:49'),(149,2,19,'2025-12-01','Combustible','Comisiones',32900.00,'2026-05-19 22:57:49'),(150,2,19,'2025-12-01','Administración','Mantenimiento',17280.00,'2026-05-19 22:57:49'),(151,2,19,'2025-12-01','Administración','Seguros',11160.00,'2026-05-19 22:57:49'),(152,2,19,'2025-12-01','Administración','Gastos generales',8000.00,'2026-05-19 22:57:49'),(153,2,20,'2026-01-01','Combustible','Costo combustible',637000.00,'2026-05-19 22:57:49'),(154,2,20,'2026-01-01','Administración','Arrendamiento',44550.00,'2026-05-19 22:57:49'),(155,2,20,'2026-01-01','Administración','Sueldos y cargas',181800.00,'2026-05-19 22:57:49'),(156,2,20,'2026-01-01','Administración','Energía eléctrica',20900.00,'2026-05-19 22:57:49'),(157,2,20,'2026-01-01','Combustible','Comisiones',31850.00,'2026-05-19 22:57:49'),(158,2,20,'2026-01-01','Administración','Mantenimiento',18540.00,'2026-05-19 22:57:49'),(159,2,20,'2026-01-01','Administración','Seguros',12960.00,'2026-05-19 22:57:49'),(160,2,20,'2026-01-01','Administración','Gastos generales',8640.00,'2026-05-19 22:57:49'),(161,2,21,'2026-02-01','Combustible','Costo combustible',665000.00,'2026-05-19 22:57:49'),(162,2,21,'2026-02-01','Administración','Arrendamiento',47250.00,'2026-05-19 22:57:49'),(163,2,21,'2026-02-01','Administración','Sueldos y cargas',187200.00,'2026-05-19 22:57:49'),(164,2,21,'2026-02-01','Administración','Energía eléctrica',24200.00,'2026-05-19 22:57:49'),(165,2,21,'2026-02-01','Combustible','Comisiones',38500.00,'2026-05-19 22:57:49'),(166,2,21,'2026-02-01','Administración','Mantenimiento',17280.00,'2026-05-19 22:57:49'),(167,2,21,'2026-02-01','Administración','Seguros',12120.00,'2026-05-19 22:57:49'),(168,2,21,'2026-02-01','Administración','Gastos generales',8400.00,'2026-05-19 22:57:49'),(169,2,22,'2026-03-01','Combustible','Costo combustible',770000.00,'2026-05-19 22:57:49'),(170,2,22,'2026-03-01','Administración','Arrendamiento',41400.00,'2026-05-19 22:57:49'),(171,2,22,'2026-03-01','Administración','Sueldos y cargas',169200.00,'2026-05-19 22:57:49'),(172,2,22,'2026-03-01','Administración','Energía eléctrica',20680.00,'2026-05-19 22:57:49'),(173,2,22,'2026-03-01','Combustible','Comisiones',35000.00,'2026-05-19 22:57:49'),(174,2,22,'2026-03-01','Administración','Mantenimiento',16740.00,'2026-05-19 22:57:49'),(175,2,22,'2026-03-01','Administración','Seguros',13080.00,'2026-05-19 22:57:49'),(176,2,22,'2026-03-01','Administración','Gastos generales',7200.00,'2026-05-19 22:57:49'),(177,2,23,'2026-04-01','Combustible','Costo combustible',770000.00,'2026-05-19 22:57:49'),(178,2,23,'2026-04-01','Administración','Arrendamiento',45000.00,'2026-05-19 22:57:49'),(179,2,23,'2026-04-01','Administración','Sueldos y cargas',196200.00,'2026-05-19 22:57:49'),(180,2,23,'2026-04-01','Administración','Energía eléctrica',21340.00,'2026-05-19 22:57:49'),(181,2,23,'2026-04-01','Combustible','Comisiones',37100.00,'2026-05-19 22:57:49'),(182,2,23,'2026-04-01','Administración','Mantenimiento',16200.00,'2026-05-19 22:57:49'),(183,2,23,'2026-04-01','Administración','Seguros',12840.00,'2026-05-19 22:57:49'),(184,2,23,'2026-04-01','Administración','Gastos generales',8480.00,'2026-05-19 22:57:49'),(185,2,24,'2026-05-01','Combustible','Costo combustible',637000.00,'2026-05-19 22:57:49'),(186,2,24,'2026-05-01','Administración','Arrendamiento',49500.00,'2026-05-19 22:57:49'),(187,2,24,'2026-05-01','Administración','Sueldos y cargas',165600.00,'2026-05-19 22:57:49'),(188,2,24,'2026-05-01','Administración','Energía eléctrica',22000.00,'2026-05-19 22:57:49'),(189,2,24,'2026-05-01','Combustible','Comisiones',33600.00,'2026-05-19 22:57:49'),(190,2,24,'2026-05-01','Administración','Mantenimiento',18180.00,'2026-05-19 22:57:49'),(191,2,24,'2026-05-01','Administración','Seguros',11400.00,'2026-05-19 22:57:49'),(192,2,24,'2026-05-01','Administración','Gastos generales',7600.00,'2026-05-19 22:57:49'),(193,3,25,'2026-03-31','Pista','Costo mercadería',39950384.98,'2026-05-19 23:19:24'),(194,3,25,'2026-03-31','Minimercado','Costo mercadería',2407766.00,'2026-05-19 23:19:24'),(195,3,25,'2026-03-31','Redpagos','Costo servicio',119730.88,'2026-05-19 23:19:24'),(196,3,25,'2026-03-31','Otros pista','Costo mercadería',606159.83,'2026-05-19 23:19:24'),(197,3,25,'2026-03-31','General','IVA no deducible',160226.00,'2026-05-19 23:19:24'),(198,3,25,'2026-03-31','General','Arrendamiento',1653617.00,'2026-05-19 23:19:24'),(199,3,25,'2026-03-31','General','Comisiones tarjetas',483674.00,'2026-05-19 23:19:24'),(200,3,25,'2026-03-31','General','Costo de luz',91672.00,'2026-05-19 23:19:24');

--
-- Table structure for table `custom_widget_valores`
--

CREATE TABLE `custom_widget_valores` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `widget_id` int unsigned NOT NULL,
  `periodo_id` int unsigned NOT NULL,
  `valor` varchar(500) NOT NULL DEFAULT '',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_widget_periodo` (`widget_id`,`periodo_id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `custom_widget_valores`
--

INSERT INTO `custom_widget_valores` 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 `custom_widgets`
--

CREATE TABLE `custom_widgets` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `empresa_id` int 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,
  `orden` int unsigned NOT NULL DEFAULT '0',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `idx_empresa` (`empresa_id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `custom_widgets`
--

INSERT INTO `custom_widgets` 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 `empresas`
--

CREATE TABLE `empresas` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `empresas`
--

INSERT INTO `empresas` 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 unsigned NOT NULL AUTO_INCREMENT,
  `empresa_id` int unsigned NOT NULL,
  `periodo_id` int 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,
  PRIMARY KEY (`id`),
  KEY `idx_finanzas_empresa_periodo` (`empresa_id`,`periodo_id`)
) ENGINE=InnoDB AUTO_INCREMENT=101 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `finanzas`
--

INSERT INTO `finanzas` VALUES (1,1,1,'2025-06-01','Banco',210600.00,'2026-05-19 22:57:49'),(2,1,1,'2025-06-01','Deudores comerciales',45150.00,'2026-05-19 22:57:49'),(3,1,1,'2025-06-01','Proveedores',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','Deudores comerciales',24850.00,'2026-05-19 22:57:49'),(7,1,2,'2025-07-01','Proveedores',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','Deudores comerciales',28000.00,'2026-05-19 22:57:49'),(11,1,3,'2025-08-01','Proveedores',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','Deudores comerciales',43050.00,'2026-05-19 22:57:49'),(15,1,4,'2025-09-01','Proveedores',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','Deudores comerciales',36750.00,'2026-05-19 22:57:49'),(19,1,5,'2025-10-01','Proveedores',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','Deudores comerciales',25550.00,'2026-05-19 22:57:49'),(23,1,6,'2025-11-01','Proveedores',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','Deudores comerciales',27650.00,'2026-05-19 22:57:49'),(27,1,7,'2025-12-01','Proveedores',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','Deudores comerciales',35000.00,'2026-05-19 22:57:49'),(31,1,8,'2026-01-01','Proveedores',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','Deudores comerciales',35700.00,'2026-05-19 22:57:49'),(35,1,9,'2026-02-01','Proveedores',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','Deudores comerciales',40250.00,'2026-05-19 22:57:49'),(39,1,10,'2026-03-01','Proveedores',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','Deudores comerciales',41300.00,'2026-05-19 22:57:49'),(43,1,11,'2026-04-01','Proveedores',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','Deudores comerciales',37100.00,'2026-05-19 22:57:49'),(47,1,12,'2026-05-01','Proveedores',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','Deudores comerciales',43050.00,'2026-05-19 22:57:49'),(51,2,13,'2025-06-01','Proveedores',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','Deudores comerciales',40950.00,'2026-05-19 22:57:49'),(55,2,14,'2025-07-01','Proveedores',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','Deudores comerciales',37800.00,'2026-05-19 22:57:49'),(59,2,15,'2025-08-01','Proveedores',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','Deudores comerciales',44100.00,'2026-05-19 22:57:49'),(63,2,16,'2025-09-01','Proveedores',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','Deudores comerciales',28000.00,'2026-05-19 22:57:49'),(67,2,17,'2025-10-01','Proveedores',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','Deudores comerciales',25550.00,'2026-05-19 22:57:49'),(71,2,18,'2025-11-01','Proveedores',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','Deudores comerciales',37800.00,'2026-05-19 22:57:49'),(75,2,19,'2025-12-01','Proveedores',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','Deudores comerciales',32900.00,'2026-05-19 22:57:49'),(79,2,20,'2026-01-01','Proveedores',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','Deudores comerciales',43750.00,'2026-05-19 22:57:49'),(83,2,21,'2026-02-01','Proveedores',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','Deudores comerciales',42350.00,'2026-05-19 22:57:49'),(87,2,22,'2026-03-01','Proveedores',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','Deudores comerciales',39550.00,'2026-05-19 22:57:49'),(91,2,23,'2026-04-01','Proveedores',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','Deudores comerciales',25200.00,'2026-05-19 22:57:49'),(95,2,24,'2026-05-01','Proveedores',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');

--
-- Table structure for table `mermas`
--

CREATE TABLE `mermas` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `empresa_id` int unsigned NOT NULL,
  `periodo_id` int 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,
  PRIMARY KEY (`id`),
  KEY `idx_mermas_empresa_periodo` (`empresa_id`,`periodo_id`)
) ENGINE=InnoDB AUTO_INCREMENT=101 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `mermas`
--

INSERT INTO `mermas` 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'),(97,3,25,'2026-03-31','Gasoil',3.000,'2026-05-19 23:19:24'),(98,3,25,'2026-03-31','Súper',925.000,'2026-05-19 23:19:24'),(99,3,25,'2026-03-31','Premium',176.000,'2026-05-19 23:19:24'),(100,3,25,'2026-03-31','Gasoil Especial',30.000,'2026-05-19 23:19:24');

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) NOT NULL,
  `applied_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` 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 unsigned NOT NULL AUTO_INCREMENT,
  `empresa_id` int unsigned NOT NULL,
  `periodo_id` int unsigned NOT NULL,
  `parametro` varchar(100) NOT NULL,
  `valor` varchar(255) NOT NULL DEFAULT '',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_parametros` (`empresa_id`,`periodo_id`,`parametro`),
  KEY `idx_parametros_empresa_periodo` (`empresa_id`,`periodo_id`)
) ENGINE=InnoDB AUTO_INCREMENT=105 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `parametros`
--

INSERT INTO `parametros` 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');

--
-- Table structure for table `periodos`
--

CREATE TABLE `periodos` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `empresa_id` int unsigned NOT NULL,
  `fecha` date NOT NULL COMMENT 'Primer día del mes',
  `mes` tinyint NOT NULL COMMENT '1-12',
  `anio` smallint 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,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_periodos_empresa_fecha` (`empresa_id`,`fecha`),
  KEY `idx_periodos_empresa` (`empresa_id`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `periodos`
--

INSERT INTO `periodos` 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');

--
-- Table structure for table `personal`
--

CREATE TABLE `personal` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `empresa_id` int unsigned NOT NULL,
  `periodo_id` int unsigned NOT NULL,
  `fecha` date NOT NULL,
  `area` varchar(80) NOT NULL DEFAULT '',
  `personal_total` int NOT NULL DEFAULT '0',
  `altas_mes` int NOT NULL DEFAULT '0',
  `bajas_mes` int NOT NULL DEFAULT '0',
  `altas_acum` int NOT NULL DEFAULT '0',
  `bajas_acum` int NOT NULL DEFAULT '0',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `idx_personal_empresa_periodo` (`empresa_id`,`periodo_id`)
) ENGINE=InnoDB AUTO_INCREMENT=79 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `personal`
--

INSERT INTO `personal` 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'),(76,3,25,'2026-03-31','Pista',10,3,5,6,7,'2026-05-22 00:16:58'),(77,3,25,'2026-03-31','Tienda/Minimercado',19,0,0,1,2,'2026-05-22 00:16:58'),(78,3,25,'2026-03-31','Administración',2,0,0,0,0,'2026-05-22 00:16:58');

--
-- Table structure for table `stock`
--

CREATE TABLE `stock` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `empresa_id` int unsigned NOT NULL,
  `periodo_id` int 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,
  PRIMARY KEY (`id`),
  KEY `idx_stock_empresa_periodo` (`empresa_id`,`periodo_id`)
) ENGINE=InnoDB AUTO_INCREMENT=103 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `stock`
--

INSERT INTO `stock` 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');

--
-- Table structure for table `ventas`
--

CREATE TABLE `ventas` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `empresa_id` int unsigned NOT NULL,
  `periodo_id` int 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,
  PRIMARY KEY (`id`),
  KEY `idx_ventas_empresa_periodo` (`empresa_id`,`periodo_id`),
  KEY `idx_ventas_fecha` (`fecha`)
) ENGINE=InnoDB AUTO_INCREMENT=320 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `ventas`
--

INSERT INTO `ventas` 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'),(313,3,25,'2026-03-31','Combustible','Gasoil','',51691.000,2004711.00,'2026-05-19 23:19:24'),(314,3,25,'2026-03-31','Combustible','Súper','',457834.000,35198194.00,'2026-05-19 23:19:24'),(315,3,25,'2026-03-31','Combustible','Premium','',108363.000,8604129.00,'2026-05-19 23:19:24'),(316,3,25,'2026-03-31','Combustible','Gasoil Especial','',16703.000,743344.00,'2026-05-19 23:19:24'),(317,3,25,'2026-03-31','Minimercado','Mini mercado','',0.000,3256100.00,'2026-05-19 23:19:24'),(318,3,25,'2026-03-31','Redpagos','Redpagos','',0.000,94840.00,'2026-05-19 23:19:24'),(319,3,25,'2026-03-31','OTROS PISTA','pista','',0.000,717182.00,'2026-05-19 23:19:24');


