-- Table structure for table `tm_celda`
--

CREATE TABLE `tm_celda` (
  `id` int NOT NULL AUTO_INCREMENT,
  `fila_id` int NOT NULL,
  `columna_id` int NOT NULL,
  `texto` text,
  `archivo_id` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uniq_fc` (`fila_id`,`columna_id`),
  KEY `columna_id` (`columna_id`),
  CONSTRAINT `tm_celda_ibfk_1` FOREIGN KEY (`fila_id`) REFERENCES `tm_fila` (`id`) ON DELETE CASCADE,
  CONSTRAINT `tm_celda_ibfk_2` FOREIGN KEY (`columna_id`) REFERENCES `tm_columna` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=243 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `tm_celda`
--

INSERT INTO `tm_celda` VALUES (1,1,3,'HOLA PRUEBAAAA',NULL,'2025-10-17 21:07:43','2025-10-17 22:06:21'),(2,1,2,'hola',1,'2025-10-17 21:07:47','2025-10-17 22:06:19'),(6,1,1,'ssasassdad',NULL,'2025-10-17 21:15:38','2025-10-17 22:06:18'),(9,2,1,'',NULL,'2025-10-17 21:36:03','2025-10-17 21:59:02'),(39,2,2,'',NULL,'2025-10-17 21:59:02','2025-10-17 21:59:02'),(50,2,3,'',NULL,'2025-10-17 22:06:22','2025-10-17 22:06:22'),(51,5,8,'MOMENTO DE LA FIRMA',2,'2025-10-18 21:15:14','2025-10-19 02:14:46'),(52,5,5,'2025-10-16',NULL,'2025-10-18 21:24:35','2025-10-19 02:07:47'),(53,5,6,'CASO PEDRO',NULL,'2025-10-18 21:24:36','2025-11-24 16:12:11'),(58,5,9,'DOCUMENTOS SOLICITADOS',NULL,'2025-10-18 21:52:00','2025-10-19 02:08:10'),(63,6,7,'',NULL,'2025-10-18 22:57:44','2025-10-19 02:18:22'),(66,5,7,'',NULL,'2025-10-18 22:57:58','2025-10-19 00:25:17'),(69,6,6,'CASO DYANIRE',NULL,'2025-10-18 22:59:05','2025-10-19 02:18:21'),(72,6,5,'2025-07-24',NULL,'2025-10-18 22:59:36','2025-10-19 02:22:05'),(102,6,9,'',NULL,'2025-10-19 00:08:06','2025-10-19 00:23:04'),(108,5,10,'    ',NULL,'2025-10-19 00:13:22','2025-10-19 00:13:22'),(110,6,10,'    ',NULL,'2025-10-19 00:13:28','2025-10-19 00:13:28'),(111,6,8,'',NULL,'2025-10-19 00:13:30','2025-10-19 02:19:33'),(165,5,12,'',NULL,'2025-10-19 00:26:38','2025-10-19 00:26:40'),(187,10,6,'CASO SR RENAN',NULL,'2025-11-21 18:24:03','2025-11-24 16:11:56'),(188,10,7,'',NULL,'2025-11-21 18:24:07','2025-11-21 18:24:07'),(189,10,9,'',NULL,'2025-11-21 18:24:08','2025-11-21 18:24:08'),(190,10,5,'2025-08-21',NULL,'2025-11-21 18:27:34','2025-11-21 18:27:35'),(195,11,6,'CASO VANESSA',NULL,'2025-11-22 17:56:55','2025-11-24 16:16:24'),(196,11,7,'',NULL,'2025-11-22 17:56:58','2025-11-22 17:56:58'),(197,11,5,'2025-11-10',NULL,'2025-11-22 17:57:05','2025-11-22 17:58:42'),(216,12,6,'TICKETS VENTANILLA',NULL,'2025-11-22 18:03:05','2025-11-22 18:03:05'),(217,12,7,'',NULL,'2025-11-22 18:03:07','2025-11-22 18:03:09'),(219,12,5,'2025-11-14',NULL,'2025-11-22 18:03:25','2025-11-22 18:03:26'),(227,13,5,'2025-10-29',NULL,'2025-11-29 21:31:23','2025-11-29 21:31:29'),(242,13,6,'INCIDENTE ESTEFANI',NULL,'2025-11-29 21:31:39','2025-11-29 21:31:39');

--
-- Table structure for table `tm_celda_archivo`
--

CREATE TABLE `tm_celda_archivo` (
  `id` int NOT NULL AUTO_INCREMENT,
  `fila_id` int NOT NULL,
  `columna_id` int NOT NULL,
  `archivo_id` int NOT NULL,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `ix_fc` (`fila_id`,`columna_id`),
  KEY `fk_celda_archivo_arch` (`archivo_id`),
  CONSTRAINT `fk_celda_archivo_arch` FOREIGN KEY (`archivo_id`) REFERENCES `archivos_video_incidentes` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=45 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `tm_celda_archivo`
--

INSERT INTO `tm_celda_archivo` VALUES (5,5,9,7,'2025-10-18 16:14:19'),(6,5,9,8,'2025-10-18 16:14:27'),(7,5,9,9,'2025-10-18 16:14:33'),(8,5,9,10,'2025-10-18 16:14:39'),(9,5,8,11,'2025-10-18 16:15:21'),(10,5,8,12,'2025-10-18 16:15:29'),(11,6,8,13,'2025-10-18 16:20:47'),(12,6,9,14,'2025-10-18 16:20:55'),(13,6,9,15,'2025-10-18 16:21:01'),(14,6,9,16,'2025-10-18 16:21:10'),(15,6,9,17,'2025-10-18 16:21:17'),(16,6,9,18,'2025-10-18 16:21:28'),(17,6,9,19,'2025-10-18 16:21:34'),(18,6,9,20,'2025-10-18 16:21:39'),(19,6,9,21,'2025-10-18 16:21:45'),(20,6,9,22,'2025-10-18 16:21:49'),(21,6,9,23,'2025-10-18 16:21:55'),(22,6,9,24,'2025-10-18 16:22:00'),(23,10,9,25,'2025-11-21 08:24:13'),(24,10,9,26,'2025-11-21 08:24:15'),(25,10,9,27,'2025-11-21 08:24:16'),(26,10,9,28,'2025-11-21 08:24:19'),(27,10,9,29,'2025-11-21 08:25:53'),(28,10,9,30,'2025-11-21 08:25:55'),(29,10,9,31,'2025-11-21 08:26:06'),(30,10,9,32,'2025-11-21 08:27:41'),(31,11,9,33,'2025-11-22 07:58:22'),(32,11,9,34,'2025-11-22 07:58:24'),(33,11,9,35,'2025-11-22 07:58:25'),(34,11,9,36,'2025-11-22 07:58:26'),(35,11,9,37,'2025-11-22 07:58:28'),(36,11,9,38,'2025-11-22 07:58:52'),(37,11,9,39,'2025-11-22 07:59:05'),(38,11,9,40,'2025-11-22 07:59:06'),(39,12,9,41,'2025-11-22 08:03:14'),(40,11,9,42,'2025-11-26 05:49:58'),(41,11,9,43,'2025-11-26 05:50:53'),(42,6,9,44,'2025-11-26 10:58:43'),(43,13,8,45,'2025-11-29 11:32:22'),(44,13,9,46,'2025-11-29 11:33:16');

--
-- Table structure for table `tm_columna`
--

CREATE TABLE `tm_columna` (
  `id` int NOT NULL AUTO_INCREMENT,
  `tabla_id` int NOT NULL,
  `titulo` varchar(120) NOT NULL,
  `orden` int NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `tabla_id` (`tabla_id`),
  CONSTRAINT `tm_columna_ibfk_1` FOREIGN KEY (`tabla_id`) REFERENCES `tm_tabla` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `tm_columna`
--

INSERT INTO `tm_columna` VALUES (1,1,'INCIDENTES',0,'2025-10-17 16:06:04'),(2,1,'VIDEO',1,'2025-10-17 16:06:42'),(3,1,'DOCUMENTO',2,'2025-10-17 16:06:52'),(4,1,'CHATS',3,'2025-10-17 16:15:00'),(5,2,'FECHA',0,'2025-10-18 15:50:45'),(6,2,'NOMBRE',1,'2025-10-18 16:09:16'),(7,2,'ALIAS',2,'2025-10-18 16:09:23'),(8,2,'VIDEOS',3,'2025-10-18 16:09:44'),(9,2,'DOCUMENTOS',4,'2025-10-18 16:10:16'),(10,2,'CHATS',5,'2025-10-18 16:10:22'),(12,2,'Nueva columna',6,'2025-10-18 19:26:14'),(13,2,'PRUEBA',7,'2025-10-20 11:35:12');

--
-- Table structure for table `tm_fila`
--

CREATE TABLE `tm_fila` (
  `id` int NOT NULL AUTO_INCREMENT,
  `tabla_id` int NOT NULL,
  `orden` int NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `tabla_id` (`tabla_id`),
  CONSTRAINT `tm_fila_ibfk_1` FOREIGN KEY (`tabla_id`) REFERENCES `tm_tabla` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `tm_fila`
--

INSERT INTO `tm_fila` VALUES (1,1,0,'2025-10-17 16:06:04'),(2,1,1,'2025-10-17 16:06:54'),(3,1,2,'2025-10-17 16:06:54'),(4,1,3,'2025-10-17 16:06:55'),(5,2,0,'2025-10-18 15:50:45'),(6,2,1,'2025-10-18 16:10:37'),(10,2,2,'2025-11-21 13:23:50'),(11,2,3,'2025-11-22 12:56:49'),(12,2,4,'2025-11-22 13:02:54'),(13,2,5,'2025-11-29 16:31:18');

--
-- Table structure for table `tm_tabla`
--

CREATE TABLE `tm_tabla` (
  `id` int NOT NULL AUTO_INCREMENT,
  `usuario_id` int NOT NULL,
  `titulo` varchar(150) NOT NULL DEFAULT 'Matriz',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `tm_tabla`
--

INSERT INTO `tm_tabla` VALUES (1,1,'','2025-10-17 16:06:04'),(2,1,'','2025-10-18 15:50:45');

--
-- Table structure for table `tmi3`
--

CREATE TABLE `tmi3` (
  `id` int NOT NULL AUTO_INCREMENT,
  `usuario_id` int NOT NULL,
  `anio` smallint NOT NULL,
  `nombre` varchar(180) NOT NULL,
  `enero` decimal(14,2) NOT NULL DEFAULT '0.00',
  `febrero` decimal(14,2) NOT NULL DEFAULT '0.00',
  `marzo` decimal(14,2) NOT NULL DEFAULT '0.00',
  `abril` decimal(14,2) NOT NULL DEFAULT '0.00',
  `mayo` decimal(14,2) NOT NULL DEFAULT '0.00',
  `junio` decimal(14,2) NOT NULL DEFAULT '0.00',
  `julio` decimal(14,2) NOT NULL DEFAULT '0.00',
  `agosto` decimal(14,2) NOT NULL DEFAULT '0.00',
  `septiembre` decimal(14,2) NOT NULL DEFAULT '0.00',
  `octubre` decimal(14,2) NOT NULL DEFAULT '0.00',
  `noviembre` decimal(14,2) NOT NULL DEFAULT '0.00',
  `diciembre` decimal(14,2) NOT NULL DEFAULT '0.00',
  `total` decimal(16,2) NOT NULL DEFAULT '0.00',
  `manual_html` longtext,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `idx_tmi3_usuario_anio` (`usuario_id`,`anio`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `tmi3`
--

INSERT INTO `tmi3` VALUES (1,9,2025,'__LABELS__',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'{\"empresa\":\"3TMi\",\"enero\":\"LUZ\",\"febrero\":\"FEBRERO\",\"marzo\":\"MARZO\",\"abril\":\"ABRIL\",\"mayo\":\"MAYO\",\"junio\":\"JUNIO\",\"julio\":\"JULIO\",\"agosto\":\"AGOSTO\",\"septiembre\":\"SEPTIEMBRE\",\"octubre\":\"OCTUBRE\",\"noviembre\":\"NOVIEMBRE\",\"diciembre\":\"DICIEMBRE\",\"total\":\"TOTAL\"}','2025-09-19 07:54:09','2025-09-24 11:34:21'),(2,9,2025,'LIBRO DE RECLAMACIONES - VIRTUAL',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,NULL,'2025-09-19 07:54:35','2025-09-25 18:51:00'),(3,9,2025,'UTILIDAD',52.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,52.00,NULL,'2025-09-19 07:54:36','2025-09-25 18:50:32'),(4,9,2025,'PRUEBA 2',520.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,520.00,NULL,'2025-09-19 07:54:40','2025-09-24 11:30:59'),(5,9,2025,'__MANUAL__',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'<table style=\"border-collapse: collapse; width: 49.2317%; height: 89.5624px;\" border=\"1\"><colgroup><col style=\"width: 29.75%;\"><col style=\"width: 34.0941%;\"><col style=\"width: 36.1559%;\"></colgroup>\n<tbody>\n<tr style=\"height: 22.3906px;\">\n<td style=\"height: 22.3906px;\"><strong>REDES SOCIALES</strong></td>\n<td style=\"height: 22.3906px;\"><strong>CORREO / USUARIO</strong></td>\n<td style=\"height: 22.3906px;\"><strong>CONTRASE&Ntilde;A</strong></td>\n</tr>\n<tr style=\"height: 22.3906px;\">\n<td style=\"height: 22.3906px;\"><strong>FACEBOOK</strong></td>\n<td style=\"height: 22.3906px;\">3tmioficial@gmail.com</td>\n<td style=\"height: 22.3906px;\">Tecnologica2025@3TMi</td>\n</tr>\n<tr style=\"height: 22.3906px;\">\n<td style=\"height: 22.3906px;\"><strong>INSTAGRAM</strong></td>\n<td style=\"height: 22.3906px;\">3tmioficial</td>\n<td style=\"height: 22.3906px;\">Tecnologica2025@3TMi</td>\n</tr>\n<tr style=\"height: 22.3906px;\">\n<td style=\"height: 22.3906px;\"><strong>TIKTOK</strong></td>\n<td style=\"height: 22.3906px;\">3tmioficial@gmail.com</td>\n<td style=\"height: 22.3906px;\">Tecnologica2025@3TMi</td>\n</tr>\n</tbody>\n</table>','2025-09-19 07:54:57','2025-09-29 06:24:26'),(6,1,2025,'__SHEET__',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'{\"cols\":[{\"name\":\"NORMAS\",\"w\":250},{\"name\":\"TIEMPO\",\"w\":160},{\"name\":\"COSTO\",\"w\":160},{\"name\":\"REQUISITOS\",\"w\":160}],\"rows\":[[\"LIBRO DE RECLAMACIONES - VIRTUAL\",\"1\",\"\",\"Copia literal de la empresa \\/ Copia de DNI de gerente \\/ Copia de administrador\"],[\"TERMINOS Y CONDICIONES ADAPTADOS AL CODIGO DE PROTECCION AL CONSUMIDOR\",\"1\",\"\",\"Información sobre todo el servicio\"],[\"REGISTRO EN EL SISTEMA DE ARBITRAJE DE CONSUMO\",\"\",\"\",\"Copia literal de la empresa \\/ Copia de DNI de gerente \\/ Copia de administrador\"],[\"PROTECCION DE SECRETOS EMPRESARIALES\",\"\",\"\",\"Lista de colaboradores \\/ Conocimientos del giro denegocio\"],[\"REVISION DE PUBLICIDAD EN PAGINA WEB Y REDES SOCIALES\",\"\",\"\",\"Links de página web \\/ Links de redes sociales\"],[\"REGISTRO DE BANC DE DATOS Y CODIGO DE CONDUCTA\",\"\",\"\",\"Lista de datos en formato Excel\"],[\"POLITICAS DE PROTECCION DE DATOS\",\"\",\"\",\"Copia literal de la empresa \\/ Copia de DNI de gerente \\/ Copia de administrador\"]]}','2025-09-24 11:32:17','2025-10-18 12:50:37');

--
-- Table structure for table `trabajador_conceptos`
--

CREATE TABLE `trabajador_conceptos` (
  `id` int NOT NULL AUTO_INCREMENT,
  `empresa_id` int NOT NULL,
  `trabajador_id` int NOT NULL,
  `concepto_id` int NOT NULL,
  `monto` decimal(10,2) NOT NULL,
  `fecha_inicio` date DEFAULT NULL,
  `fecha_fin` date DEFAULT NULL,
  `estado` enum('ACTIVO','INACTIVO') NOT NULL DEFAULT 'ACTIVO',
  `creado_en` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `idx_tc_worker` (`empresa_id`,`trabajador_id`),
  KEY `idx_tc_concept` (`concepto_id`),
  KEY `idx_tc_vigencia` (`fecha_inicio`,`fecha_fin`,`estado`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `trabajador_conceptos`
--


--
-- Table structure for table `trabajador_contacto_emergencia`
--

CREATE TABLE `trabajador_contacto_emergencia` (
  `id` int NOT NULL AUTO_INCREMENT,
  `trabajador_id` int NOT NULL,
  `nombre` varchar(120) NOT NULL,
  `parentesco` varchar(60) DEFAULT NULL,
  `telefono` varchar(30) NOT NULL,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_contacto_trabajador` (`trabajador_id`),
  CONSTRAINT `fk_emerg_trabajador` FOREIGN KEY (`trabajador_id`) REFERENCES `trabajadores` (`id_trabajador`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `trabajador_contacto_emergencia`
--

INSERT INTO `trabajador_contacto_emergencia` VALUES (1,1,'HAYDEE MENDOZA','MADRE','957377502','2025-12-18 20:56:04','2025-12-18 20:56:04');

--
-- Table structure for table `trabajador_cuentas_bancarias`
--

CREATE TABLE `trabajador_cuentas_bancarias` (
  `id` int NOT NULL AUTO_INCREMENT,
  `trabajador_id` int NOT NULL,
  `banco` varchar(80) NOT NULL,
  `tipo_cuenta` enum('AHORROS','CORRIENTE','OTRA') DEFAULT NULL,
  `moneda` enum('PEN','USD','EUR','OTRA') NOT NULL DEFAULT 'PEN',
  `numero_cuenta` varchar(50) DEFAULT NULL,
  `cci` varchar(50) DEFAULT NULL,
  `es_principal` tinyint(1) NOT NULL DEFAULT '1',
  `estado` enum('ACTIVA','INACTIVA') NOT NULL DEFAULT 'ACTIVA',
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `trabajador_id` (`trabajador_id`),
  CONSTRAINT `fk_cuenta_trabajador` FOREIGN KEY (`trabajador_id`) REFERENCES `trabajadores` (`id_trabajador`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `trabajador_cuentas_bancarias`
--


--
-- Table structure for table `trabajador_documentos`
--

CREATE TABLE `trabajador_documentos` (
  `id` int NOT NULL AUTO_INCREMENT,
  `trabajador_id` int NOT NULL,
  `tipo` enum('DNI','CE','PASAPORTE','CONTRATO','ANEXO','CCI','CV','CERTIFICADO','DESCANSO_MEDICO','MEMORANDUM','RENUNCIA','LIQUIDACION','OTRO') NOT NULL,
  `nombre` varchar(150) DEFAULT NULL,
  `archivo` varchar(255) NOT NULL,
  `fecha_emision` date DEFAULT NULL,
  `fecha_vencimiento` date DEFAULT NULL,
  `estado` enum('VIGENTE','VENCIDO','ANULADO') NOT NULL DEFAULT 'VIGENTE',
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `trabajador_id` (`trabajador_id`),
  CONSTRAINT `fk_doc_trabajador` FOREIGN KEY (`trabajador_id`) REFERENCES `trabajadores` (`id_trabajador`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `trabajador_documentos`
--


--
-- Table structure for table `trabajador_horario`
--

CREATE TABLE `trabajador_horario` (
  `id` int NOT NULL AUTO_INCREMENT,
  `trabajador_id` int NOT NULL,
  `dia` enum('LUN','MAR','MIE','JUE','VIE','SAB','DOM') NOT NULL,
  `trabaja` tinyint(1) NOT NULL DEFAULT '1',
  `h_in` time DEFAULT NULL,
  `h_out` time DEFAULT NULL,
  `h_in2` time DEFAULT NULL,
  `h_out2` time DEFAULT NULL,
  `actualizado_en` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_trab_dia` (`trabajador_id`,`dia`),
  KEY `idx_trabajador` (`trabajador_id`)
) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `trabajador_horario`
--

INSERT INTO `trabajador_horario` VALUES (8,13,'LUN',1,'06:30:00','02:00:00',NULL,NULL,'2025-12-19 01:45:20'),(9,13,'MAR',1,'06:30:00','02:00:00',NULL,NULL,'2025-12-19 01:45:20'),(10,13,'MIE',1,'06:30:00','02:00:00',NULL,NULL,'2025-12-19 01:45:20'),(11,13,'JUE',1,'06:30:00','02:00:00',NULL,NULL,'2025-12-19 01:45:20'),(12,13,'VIE',1,'06:30:00','02:00:00',NULL,NULL,'2025-12-19 01:45:20'),(13,13,'SAB',1,'06:30:00','02:00:00',NULL,NULL,'2025-12-19 01:45:20'),(14,13,'DOM',1,NULL,NULL,NULL,NULL,'2025-12-19 01:45:20'),(15,9,'LUN',1,'10:30:00',NULL,NULL,NULL,'2025-12-19 01:45:28'),(16,9,'MAR',1,'10:30:00',NULL,NULL,NULL,'2025-12-19 01:45:28'),(17,9,'MIE',1,'10:30:00',NULL,NULL,NULL,'2025-12-19 01:45:28'),(18,9,'JUE',1,'10:30:00',NULL,NULL,NULL,'2025-12-19 01:45:28'),(19,9,'VIE',1,'10:30:00',NULL,NULL,NULL,'2025-12-19 01:45:28'),(20,9,'SAB',1,'10:30:00',NULL,NULL,NULL,'2025-12-19 01:45:28'),(21,9,'DOM',1,NULL,NULL,NULL,NULL,'2025-12-19 01:45:28'),(22,1,'LUN',1,'06:00:00','13:00:00',NULL,NULL,'2025-12-19 01:46:18'),(23,1,'MAR',1,'06:00:00','13:00:00',NULL,NULL,'2025-12-19 01:46:18'),(24,1,'MIE',1,'06:00:00','13:00:00',NULL,NULL,'2025-12-19 01:46:18'),(25,1,'JUE',1,'06:00:00','13:00:00',NULL,NULL,'2025-12-19 01:46:18'),(26,1,'VIE',1,'06:00:00','13:00:00',NULL,NULL,'2025-12-19 01:46:18'),(27,1,'SAB',1,'08:00:00','17:00:00',NULL,NULL,'2025-12-19 01:46:18'),(28,1,'DOM',1,NULL,NULL,NULL,NULL,'2025-12-19 01:46:18'),(29,8,'LUN',1,'08:00:00','18:00:00',NULL,NULL,'2025-12-19 01:48:00'),(30,8,'MAR',1,'08:00:00','18:00:00',NULL,NULL,'2025-12-19 01:48:00'),(31,8,'MIE',1,'08:00:00','18:00:00',NULL,NULL,'2025-12-19 01:48:00'),(32,8,'JUE',1,'08:00:00','18:00:00',NULL,NULL,'2025-12-19 01:48:00'),(33,8,'VIE',1,'08:00:00','18:00:00',NULL,NULL,'2025-12-19 01:48:00'),(34,8,'SAB',1,'08:00:00','17:00:00',NULL,NULL,'2025-12-19 01:48:00'),(35,8,'DOM',1,NULL,NULL,NULL,NULL,'2025-12-19 01:48:00'),(36,6,'LUN',1,'08:00:00','18:30:00',NULL,NULL,'2025-12-19 03:18:39'),(37,6,'MAR',1,'08:00:00','18:30:00',NULL,NULL,'2025-12-19 03:18:39'),(38,6,'MIE',1,'08:00:00','18:30:00',NULL,NULL,'2025-12-19 03:18:39'),(39,6,'JUE',1,'08:00:00','18:30:00',NULL,NULL,'2025-12-19 03:18:39'),(40,6,'VIE',1,'08:00:00','18:30:00',NULL,NULL,'2025-12-19 03:18:39'),(41,6,'SAB',1,'08:00:00','17:00:00',NULL,NULL,'2025-12-19 03:18:39'),(42,6,'DOM',1,NULL,NULL,NULL,NULL,'2025-12-19 03:18:39'),(43,5,'LUN',1,'07:50:00','17:50:00',NULL,NULL,'2025-12-19 03:19:35'),(44,5,'MAR',1,'07:50:00','17:50:00',NULL,NULL,'2025-12-19 03:19:35'),(45,5,'MIE',1,'07:50:00','17:50:00',NULL,NULL,'2025-12-19 03:19:35'),(46,5,'JUE',1,'07:50:00','17:50:00',NULL,NULL,'2025-12-19 03:19:35'),(47,5,'VIE',1,'07:50:00','17:50:00',NULL,NULL,'2025-12-19 03:19:35'),(48,5,'SAB',1,'07:50:00','16:50:00',NULL,NULL,'2025-12-19 03:19:35'),(49,5,'DOM',1,NULL,NULL,NULL,NULL,'2025-12-19 03:19:35');

--
-- Table structure for table `trabajadores`
--

CREATE TABLE `trabajadores` (
  `id_trabajador` int NOT NULL AUTO_INCREMENT,
  `usuario_id` int DEFAULT NULL,
  `codigo_legajo` varchar(20) DEFAULT NULL,
  `nombres` varchar(100) NOT NULL,
  `apellidos` varchar(120) NOT NULL,
  `tipo_documento` enum('DNI','CE','PASAPORTE','OTRO') DEFAULT NULL,
  `dni` varchar(15) NOT NULL,
  `direccion` varchar(255) DEFAULT NULL,
  `departamento` varchar(80) DEFAULT NULL,
  `provincia` varchar(80) DEFAULT NULL,
  `distrito` varchar(80) DEFAULT NULL,
  `celular` varchar(20) DEFAULT NULL,
  `correo` varchar(120) DEFAULT NULL,
  `cargo` varchar(100) DEFAULT NULL,
  `area` varchar(100) DEFAULT NULL,
  `jefe_id` int DEFAULT NULL,
  `sede` varchar(100) DEFAULT NULL,
  `fecha_nacimiento` date DEFAULT NULL,
  `empresa_id` int NOT NULL,
  `fecha_ingreso` date NOT NULL,
  `estado` enum('ACTIVO','CESADO') DEFAULT 'ACTIVO',
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `banco` varchar(50) DEFAULT NULL,
  `cuenta_banco` varchar(50) DEFAULT NULL,
  `cci` varchar(50) DEFAULT NULL,
  `metodo_pago` enum('EFECTIVO','BANCO') NOT NULL DEFAULT 'BANCO',
  `tipo_pension` varchar(10) DEFAULT NULL,
  `afp_nombre` varchar(50) DEFAULT NULL,
  `cuspp` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`id_trabajador`),
  UNIQUE KEY `uq_trabajadores_dni` (`dni`),
  UNIQUE KEY `uq_trab_dni_empresa` (`dni`,`empresa_id`),
  KEY `idx_trab_usuario` (`usuario_id`),
  KEY `idx_trab_empresa` (`empresa_id`),
  KEY `idx_trabajadores_empresa` (`empresa_id`),
  KEY `idx_trabajadores_usuario` (`usuario_id`),
  KEY `idx_trabajadores_jefe` (`jefe_id`),
  KEY `idx_trabajadores_dni` (`dni`),
  CONSTRAINT `fk_trab_empresa` FOREIGN KEY (`empresa_id`) REFERENCES `empresas` (`empresa_id`),
  CONSTRAINT `fk_trab_usuario` FOREIGN KEY (`usuario_id`) REFERENCES `usuarios` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `trabajadores`
--

INSERT INTO `trabajadores` VALUES (1,1,NULL,'SOFIA JOSELIN','CAJAHUAMAN MENDOZA',NULL,'71618217','MZ. F LT. 02 COOP. DE VIV. VILLA RESIDENCIAL, LIMA - LIMA - SAN JUAN DE MIRAFLORES',NULL,NULL,NULL,'984249222','sofia.joselin0830@gmail.com','JEFE DE PROYECTOS','SISTEMA',NULL,NULL,'1997-08-30',18,'2020-11-16','ACTIVO','2025-12-10 22:03:53','2025-12-17 08:21:55',NULL,NULL,NULL,'EFECTIVO','AFP','INTEGRA','0000000000000000'),(4,9,NULL,'EDUARDO GRIMALDO','VARA PILLACA',NULL,'40510789','AV. JOSE ARNALDO MARQUEZ 1372 DPTO. 212 FUNDO OYAGUE',NULL,NULL,NULL,'','e.varapillaca@gmail.com','','',NULL,NULL,'1986-04-03',2,'0001-01-01','ACTIVO','2025-12-11 06:35:21','2025-12-16 12:16:55',NULL,NULL,NULL,'BANCO',NULL,NULL,NULL),(5,15,NULL,'ANTUANET YASURI','MOZO ALBAREZ',NULL,'74913643','Asent. H. Néstor Gambetta Alta Mz. J Lt. 22, Callao',NULL,NULL,NULL,'933677019','antuanetyasuri18@gmail.com','WHATSAPP 1','WHATSAPP',NULL,NULL,'2001-01-10',2,'2022-04-02','ACTIVO','2025-12-11 08:13:14','2025-12-16 12:17:24',NULL,NULL,NULL,'BANCO',NULL,NULL,NULL),(6,18,NULL,'THANIA ALEXANDRA','ESCALANTE CARDENAS',NULL,'72922088','P. Joven Raúl Porras Barrenechea Comité 54 Mz. M Lt. 3, Carabayllo',NULL,NULL,NULL,'961224488','alexandraescalante85@gmail.com','TRANSFERENCIA','TRANSFERENCIA',NULL,NULL,'2001-02-27',3,'2020-06-01','ACTIVO','2025-12-11 08:14:52','2025-12-16 12:17:30',NULL,NULL,NULL,'BANCO',NULL,NULL,NULL),(7,23,NULL,'GENOBEBA','PILLACA GARRIAZO',NULL,'21570127','AV ARNALDO MARQUEZ N° 1372 DPTO 210',NULL,NULL,NULL,'924990130','genopillaca@gmail.com','CAJA','CAJA PRINCIPAL',NULL,NULL,'0001-04-14',3,'0001-01-01','ACTIVO','2025-12-11 08:15:55','2025-12-16 12:17:34',NULL,NULL,NULL,'BANCO',NULL,NULL,NULL),(8,19,NULL,'NATIVIDAD EMILIA','OCHOA RUMICHE',NULL,'70372113','Av. A Praderas 225 Las Lomas del Rímac, Rimac',NULL,NULL,NULL,'931341597','natividademiliaochoarumiche@gmail.com','WHATSAPP 2','WHATSAPP',NULL,NULL,'2000-09-09',3,'2024-11-08','ACTIVO','2025-12-11 08:17:05','2025-12-16 12:17:39',NULL,NULL,NULL,'BANCO',NULL,NULL,NULL),(9,16,NULL,'ENMA ZORAIDA','ALAN PUYCAN',NULL,'10735062','Jr. Tumbes Mz. 2C Lt. 5, Callao',NULL,NULL,NULL,'996601031','scenmaa@gmail.com','FACTURACION','FACTURACION',NULL,NULL,'1978-03-30',20,'2023-03-13','ACTIVO','2025-12-11 08:18:58','2025-12-16 12:17:49',NULL,NULL,NULL,'BANCO',NULL,NULL,NULL),(10,11,NULL,'NAYUMI GENOBEBA','VARA ATUNCA','DNI','74076031','AV ARNALDO MARQUEZ N° 1372 DPTO 212','LIMA','LIMA','JESUS MARIA','923547014','Nayumivara2@gmail.com','MULTIFUNCIONAL','MULTIFUNCIONAL',NULL,NULL,'2005-01-14',20,'2023-04-01','ACTIVO','2025-12-11 08:20:36','2025-12-19 05:54:03',NULL,NULL,NULL,'EFECTIVO','AFP','INTEGRA','0000000000000'),(11,21,NULL,'STEPHANY DYANIRE','ORTIZ BRAN',NULL,'48495794','Jr. Bernardo Alcedo N° 599, Lince',NULL,NULL,NULL,'944801860','dyanire29@gmail.com','JEFA DE VENTANILLA','VENTANILLA',NULL,NULL,'1994-07-12',20,'2024-06-13','ACTIVO','2025-12-11 08:21:43','2025-12-16 12:18:04',NULL,NULL,NULL,'BANCO',NULL,NULL,NULL),(12,13,NULL,'CARLOS KENNEDY','SILVA RODRIGUEZ',NULL,'76634714','Mz. B lote 12 Urb San Diego, Carabayllo',NULL,NULL,NULL,'968824885','carlossilvarodriguez8@gmail.com','ING. SISTEMAS','SISTEMAS',NULL,NULL,'1996-09-14',16,'2022-05-23','ACTIVO','2025-12-11 08:23:58','2025-12-16 12:18:09',NULL,NULL,NULL,'BANCO',NULL,NULL,NULL),(13,12,NULL,'BRENDA XIOMARA','BAZALAR MUÑOZ',NULL,'75066334','JR AREQUIPA 3042, SMP',NULL,NULL,NULL,'912234770','brenda2802a@gmail.com','ASISTENTE CONTABLE','CONTABILIDAD',NULL,NULL,'2000-02-28',22,'2020-10-15','ACTIVO','2025-12-11 08:39:40','2025-12-16 12:18:14',NULL,NULL,NULL,'BANCO',NULL,NULL,NULL),(14,14,NULL,'ARIANA DE LOS ANGELES','SIESQUEN CHAVESTA',NULL,'75769769','Calle Moyobamba N° 687 Mz. 64 Lt. 9, SMP',NULL,NULL,NULL,'993160138','arianasch2025@gmail.com','VENTANILLA 2','VENTANILLA',NULL,NULL,'2003-09-22',23,'2025-07-15','ACTIVO','2025-12-11 08:40:29','2025-12-16 12:18:19',NULL,NULL,NULL,'BANCO',NULL,NULL,NULL),(15,22,NULL,'MARIA ALVINA ROSARIO','SANGAMA CACHIQUE',NULL,'47542691','Calle Oeste Mz. B Lt. 7 Urb. Virgen de Guadalupe, Ate',NULL,NULL,NULL,'989911048','masangama127@gmail.com','APOYO','APOYO ADMINISTRATIVO',NULL,NULL,'1994-01-11',14,'2025-03-01','ACTIVO','2025-12-11 08:41:24','2025-12-16 12:18:25',NULL,NULL,NULL,'BANCO',NULL,NULL,NULL);

--
-- Table structure for table `tratamiento`
--

CREATE TABLE `tratamiento` (
  `id` int NOT NULL AUTO_INCREMENT,
  `usuario_id` int NOT NULL,
  `nombre` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT 'TRATAMIENTO',
  `fecha` date NOT NULL,
  `columnas` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `filas` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `anchos` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `creado_en` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `actualizado_en` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `idx_tratamiento_usuario_fecha` (`usuario_id`,`fecha`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `tratamiento`
--

INSERT INTO `tratamiento` VALUES (1,9,'TRATAMIENTO','2025-11-27','[\"OBJETIVO\",\"QUE SE VA HACER\",\"QUIEN LO VA HACER\",\"OBSERVACIONES\",\"INICIO (AAAA-MM-DD)\",\"FIN (AAAA-MM-DD)\",\"TIPO (Medicamento, suplemento, dieta, ejercicio, otro)\",\"NOMBRE DEL MEDICAMENTO \\/ SUPLEMENTO \\/ PLAN\",\"DOSIS Y FRECUENCIA (o descripcion del hábito)\",\"OBJETIVO (hígado, peso, glucosa, presión, etc)\",\"MÉDICO O PROFESIONAL QUE LO INDICÓ\",\"EFECTOS PERCIBIDOS POSITIVOS\",\"EFECTOS SECUNDARIOS \\/ MOLESTIAS\",\"¿SIGUES USÁNDOLO? (S\\/N)\",\"COMENTARIOS\"]','[[\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\"],[\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\"]]','[150,217,222,192,236,214,454,458,419,397,380,321,354,267,181]','2025-11-27 03:54:18','2025-11-27 03:59:44'),(2,11,'TRATAMIENTO','2025-11-27','[\"OBJETIVO\",\"QUE SE VA HACER\",\"QUIEN LO VA HACER\",\"OBSERVACIONES\",\"INICIO (AAAA-MM-DD)\",\"FIN (AAAA-MM-DD)\",\"TIPO (Medicamento, suplemento, dieta, ejercicio, otro)\",\"NOMBRE DEL MEDICAMENTO \\/ SUPLEMENTO \\/ PLAN\",\"DOSIS Y FRECUENCIA (o descripcion del hábito)\",\"OBJETIVO (hígado, peso, glucosa, presión, etc)\",\"MÉDICO O PROFESIONAL QUE LO INDICÓ\",\"EFECTOS PERCIBIDOS POSITIVOS\",\"EFECTOS SECUNDARIOS \\/ MOLESTIAS\",\"¿SIGUES USÁNDOLO? (S\\/N)\",\"COMENTARIOS\"]','[[\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\"],[\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\"]]','[150,217,222,192,236,214,454,458,419,397,380,321,354,267,181]','2025-11-27 08:54:18','2025-11-27 08:59:44');

--
-- Table structure for table `turno_catalogo`
--

CREATE TABLE `turno_catalogo` (
  `id` int NOT NULL AUTO_INCREMENT,
  `area_id` int DEFAULT NULL,
  `usuario_id` int DEFAULT NULL,
  `codigo` varchar(20) NOT NULL,
  `nombre` varchar(80) NOT NULL,
  `hora_inicio` time NOT NULL,
  `hora_fin` time NOT NULL,
  `color` varchar(7) NOT NULL DEFAULT '#0d6efd',
  `descanso` tinyint(1) NOT NULL DEFAULT '0',
  `refrigerio_minutos` int NOT NULL DEFAULT '60',
  `refrigerio_flexible` tinyint(1) NOT NULL DEFAULT '1',
  `activo` tinyint(1) NOT NULL DEFAULT '1',
  `creado_en` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `actualizado_en` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_turno_codigo_area_user` (`codigo`,`area_id`,`usuario_id`),
  KEY `idx_turno_area` (`area_id`),
  KEY `idx_turno_usuario` (`usuario_id`),
  CONSTRAINT `fk_turno_area` FOREIGN KEY (`area_id`) REFERENCES `areas` (`area_id`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `fk_turno_usuario` FOREIGN KEY (`usuario_id`) REFERENCES `usuarios` (`id`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `turno_catalogo`
--

INSERT INTO `turno_catalogo` VALUES (48,NULL,NULL,'MAN','Bloque manual','00:00:00','23:59:59','#64748b',0,60,1,1,'2025-09-02 21:31:30',NULL);

--
-- Table structure for table `unidad_docs`
--

CREATE TABLE `unidad_docs` (
  `id` int NOT NULL AUTO_INCREMENT,
  `unidad_id` int NOT NULL,
  `categoria` varchar(40) NOT NULL,
  `nombre` varchar(160) NOT NULL,
  `descripcion` varchar(500) DEFAULT NULL,
  `path` varchar(255) NOT NULL,
  `mime` varchar(80) NOT NULL,
  `size_bytes` bigint unsigned NOT NULL DEFAULT '0',
  `visible_tenant` tinyint(1) NOT NULL DEFAULT '0',
  `periodicidad` enum('ANUAL','MENSUAL') NOT NULL DEFAULT 'ANUAL',
  `fecha_doc` date DEFAULT NULL,
  `vencimiento` date DEFAULT NULL,
  `uploaded_by` int DEFAULT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `unidad_id` (`unidad_id`),
  KEY `categoria` (`categoria`)
) ENGINE=InnoDB AUTO_INCREMENT=95 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `unidad_docs`
--

INSERT INTO `unidad_docs` VALUES (7,29,'TITULO','COPIA LITERAL','','https://drive.google.com/file/d/10UqU8HNzaAvcuyMP3q-BhV-CkVTLqgOc/view?usp=drivesdk','application/pdf',972906,0,'ANUAL','2025-04-19',NULL,NULL,'2025-10-14 09:58:28'),(10,29,'TITULO','CRI','','https://drive.google.com/file/d/1F4LSoFG2mSfY4-Q5ucGYmbxmuKq1aDUW/view?usp=drivesdk','application/pdf',338051,0,'ANUAL','2024-05-18',NULL,NULL,'2025-10-14 10:00:34'),(11,29,'TITULO','CERTIFICADO PARAMETROS','','https://drive.google.com/file/d/1lYR33FE2qZmywZtrQ3i5JQ6pSTCP_1gM/view?usp=drivesdk','application/pdf',1723711,0,'ANUAL','2024-05-28',NULL,NULL,'2025-10-14 10:01:19'),(12,29,'TITULO','INFORME TASACION','','https://drive.google.com/file/d/1zOLzqojJjGdLfgzI1HI77quLiL7WJxxj/view?usp=drivesdk','application/pdf',5455403,0,'ANUAL','2024-04-12',NULL,NULL,'2025-10-14 10:02:16'),(13,29,'TITULO','PREDIO URBANO - PU','','https://drive.google.com/file/d/1Xx9SUJ18iH0I-x7CPyHCDmLzFIRNVz0n/view?usp=drivesdk','application/pdf',698235,0,'ANUAL','2025-05-16',NULL,NULL,'2025-10-14 10:05:59'),(14,29,'TITULO','HOJA RESUMEN - HR','','https://drive.google.com/file/d/1xV643P_th1KwQUSWbdvx3nziE58LekZ1/view?usp=drivesdk','application/pdf',637174,0,'ANUAL','2025-05-16',NULL,NULL,'2025-10-14 10:06:18'),(15,29,'TITULO','LICENCIA DE FUNCIONAMIENTO','','https://drive.google.com/file/d/1H01wc63D2LsnehddfJOSq0yTjA1coHyT/view?usp=drivesdk','application/pdf',1351393,0,'ANUAL','2023-10-25',NULL,NULL,'2025-10-14 10:11:01'),(18,29,'TITULO','RECIBO LUZ','','https://drive.google.com/file/d/1lqU3FrnlZKK3w3zTEXN3hKIM3QjPEpWF/view?usp=drivesdk','application/pdf',870123,0,'MENSUAL','2025-08-21','2025-11-05',NULL,'2025-10-14 10:21:39'),(19,29,'TITULO','RECIBO AGUA','','https://drive.google.com/file/d/14mbuQFQq9nm7EMFvVIs3j12j8G7SsHt_/view?usp=drivesdk','application/pdf',922080,0,'MENSUAL','2025-09-09','2025-11-23',NULL,'2025-10-14 10:21:54'),(20,17,'TITULO','COPIA LITERAL','','https://drive.google.com/file/d/13yqago4D9zH9-668gmmZ5X_PBh-0l5uw/view?usp=drivesdk','application/pdf',1181920,0,'ANUAL','2024-04-02',NULL,NULL,'2025-10-14 10:31:27'),(23,17,'TITULO','LUZ','','https://drive.google.com/file/d/1d6AXxnFwajZnAOxSq6Nq-DraAXSrvcW2/view?usp=drivesdk','application/pdf',98772,0,'ANUAL','2025-09-20',NULL,NULL,'2025-10-14 10:40:25'),(25,17,'TITULO','AGUA','','https://drive.google.com/file/d/1GwhIoHuuFvxNkkDV-103WbN3VIV-ZoCb/view?usp=drivesdk','application/pdf',1416440,0,'ANUAL','2025-09-15',NULL,NULL,'2025-10-14 10:44:38'),(26,17,'TITULO','PREDIO URBANO - PU','','https://drive.google.com/file/d/1bML6pU1PUF9NIxOyfWkAMfjcx8tcRbzf/view?usp=drivesdk','application/pdf',300267,0,'ANUAL',NULL,NULL,NULL,'2025-10-14 10:45:00'),(27,17,'TITULO','HOJA RESUMEN','','https://drive.google.com/file/d/1DGWfutXjfpuy1cVDNeYCp9SjcUUCuHQA/view?usp=drivesdk','application/pdf',309894,0,'ANUAL','2025-01-02',NULL,NULL,'2025-10-14 10:45:44'),(29,17,'TITULO','PARAMETROS','','https://drive.google.com/file/d/1uQVvJo1UIkV6Noi9K64Dd14iRAhO5M5G/view?usp=drivesdk','application/pdf',958347,0,'ANUAL','2024-05-28',NULL,NULL,'2025-10-14 10:48:28'),(31,17,'TITULO','CONTRATO ARRENDAMIENTO','','https://drive.google.com/file/d/1IYkD84-FfgUnk83ASJK4XAcUL_meOL42/view?usp=drivesdk','application/pdf',134722,0,'MENSUAL','2025-06-01','2025-10-01',NULL,'2025-10-14 10:49:34'),(32,18,'TITULO','COPIA LITERAL','','https://drive.google.com/file/d/1Zu1NoPczMDE_UBX1kiJCwGhXicnoVoTu/view?usp=drivesdk','application/pdf',1196143,0,'ANUAL','2024-04-02',NULL,NULL,'2025-10-14 10:51:32'),(33,18,'TITULO','LUZ','','https://drive.google.com/file/d/1cpBSt3oJMKmJF0gAlSnAdDgiZcP3G842/view?usp=drivesdk','application/pdf',98720,0,'ANUAL','2025-09-20',NULL,NULL,'2025-10-14 10:58:14'),(34,18,'TITULO','AGUA','','https://drive.google.com/file/d/1BShPzRI4b8MviO_tAFFfu39JcXRgtpHQ/view?usp=drivesdk','application/pdf',1416440,0,'ANUAL','2025-09-15',NULL,NULL,'2025-10-14 10:58:43'),(35,18,'TITULO','PREDIO URBANO - PU','','https://drive.google.com/file/d/1gQuNt5BzH-LmzMWExzUjDqMXXU7EEazY/view?usp=drivesdk','application/pdf',300256,0,'ANUAL','2025-01-02',NULL,NULL,'2025-10-14 11:01:19'),(36,18,'TITULO','HOJA DE RESUMEN - HR','','https://drive.google.com/file/d/1j6oATOfnH9zGL8QkrCnPk1ptaD4s1z2B/view?usp=drivesdk','application/pdf',309894,0,'ANUAL','2025-01-02',NULL,NULL,'2025-10-14 11:01:44'),(38,19,'TITULO','COPIA LITERAL','','https://drive.google.com/file/d/1kbaGX3SuABvBF-_ePOKKgJzvtrrZ7lRI/view?usp=drivesdk','application/pdf',1193254,0,'ANUAL','2024-04-02',NULL,NULL,'2025-10-14 11:14:54'),(39,19,'TITULO','LUZ','','https://drive.google.com/file/d/1boCNtINF2PfFAjJzInwHZawFG_p1bNsy/view?usp=drivesdk','application/pdf',98193,0,'ANUAL','2025-09-20',NULL,NULL,'2025-10-14 11:16:13'),(40,19,'TITULO','AGUA','','https://drive.google.com/file/d/1tm3jIz55kzA4xpSiAryYBXkUXE-f0PGC/view?usp=drivesdk','application/pdf',1416440,0,'ANUAL','2025-09-15',NULL,NULL,'2025-10-14 11:16:59'),(42,19,'TITULO','PREDIO URBANO','','https://drive.google.com/file/d/1VVPrJ62A9Bmuea9aiv9Vh6QTW6E-4H9t/view?usp=drivesdk','application/pdf',300300,0,'ANUAL','2025-01-02',NULL,NULL,'2025-10-14 11:17:58'),(43,19,'TITULO','HOJA RESUMEN - HR','','https://drive.google.com/file/d/1Se9Keg4r8MiAuZoVJ_pFFrVFGYBmw6VR/view?usp=drivesdk','application/pdf',309894,0,'ANUAL','2025-01-02',NULL,NULL,'2025-10-14 11:18:18'),(44,20,'TITULO','COPIA LITERAL','','https://drive.google.com/file/d/1cvrSELxy-boihSEMuit6TTFMROBXzmOL/view?usp=drivesdk','application/pdf',1193744,0,'ANUAL','2024-04-02',NULL,NULL,'2025-10-14 11:25:19'),(45,20,'TITULO','LUZ','','https://drive.google.com/file/d/1inPPk7Dq-dkqCYX-ij1wf28pn24Kj7Ac/view?usp=drivesdk','application/pdf',98694,0,'ANUAL','2025-09-20',NULL,NULL,'2025-10-14 11:26:08'),(46,20,'TITULO','AGUA','','https://drive.google.com/file/d/1q4hcIsaIEg0VuRczzIktzduUTz1qwpPc/view?usp=drivesdk','application/pdf',1416440,0,'ANUAL','2025-09-15',NULL,NULL,'2025-10-14 11:26:39'),(47,20,'TITULO','PREDIO URBANO - PU','','https://drive.google.com/file/d/1QfcBehYuqAAzHvCMkX1AzYfjwR2k5o0a/view?usp=drivesdk','application/pdf',300264,0,'ANUAL','2025-01-02',NULL,NULL,'2025-10-14 11:27:58'),(48,20,'TITULO','HOJA RESUMEN - HR','','https://drive.google.com/file/d/1upguzfhQzWUjBr1hzlVuNDGeRnwVfFAq/view?usp=drivesdk','application/pdf',309894,0,'ANUAL','2025-01-02',NULL,NULL,'2025-10-14 11:28:16'),(49,22,'TITULO','PREDIO URBANO - PU','','https://drive.google.com/file/d/1ld7QTENLq_d9mQiAsrNHoCkPJiLfB06t/view?usp=drivesdk','application/pdf',300256,0,'ANUAL','2025-01-02',NULL,NULL,'2025-10-14 11:29:41'),(50,22,'TITULO','HOJA RESUMEN - HR','','https://drive.google.com/file/d/18JytW7v-eYsq90NndJIJVZ_VStfC3y5v/view?usp=drivesdk','application/pdf',309894,0,'ANUAL','2025-01-02',NULL,NULL,'2025-10-14 11:30:14'),(51,23,'TITULO','PREDIO URBANO - PU','','https://drive.google.com/file/d/1hoNUeb6UZlWsMR5dIh4laAS7HlFXIIww/view?usp=drivesdk','application/pdf',300256,0,'ANUAL','2025-01-02',NULL,NULL,'2025-10-14 11:30:45'),(52,23,'TITULO','HOJA RESUMEN - HR','','https://drive.google.com/file/d/1Be-K0tOH9k39MerD3hEOyfScEs2ds41X/view?usp=drivesdk','application/pdf',309894,0,'ANUAL','2025-01-02',NULL,NULL,'2025-10-14 11:31:01'),(53,23,'TITULO','HOJA RESUMEN - HR','','https://drive.google.com/file/d/1MJ71gw7j2JC92-CDhqrqgh_u9AxlQmCO/view?usp=drivesdk','application/pdf',309894,0,'ANUAL','2025-01-02',NULL,NULL,'2025-10-14 11:31:04'),(54,24,'TITULO','PREDIO URBANO - PU','','https://drive.google.com/file/d/16qT_J3yrdUeRd-C57Hxay4ewPTjAI62r/view?usp=drivesdk','application/pdf',300256,0,'ANUAL','2025-01-02',NULL,NULL,'2025-10-14 11:31:27'),(55,24,'TITULO','HOJA RESUMEN - HR','','https://drive.google.com/file/d/1hS1adW1F1XJSHxHUxOElPa90uPRgO6wW/view?usp=drivesdk','application/pdf',309894,0,'ANUAL','2025-01-02',NULL,NULL,'2025-10-14 11:31:45'),(56,30,'TITULO','COPIA LITERAL','','https://drive.google.com/file/d/1WnKh-pZdDZc8nIT0G8a3AXAY8K1awshq/view?usp=drivesdk','application/pdf',900090,0,'ANUAL','2025-01-02',NULL,NULL,'2025-10-14 11:36:13'),(57,30,'TITULO','PREDIO URBANO - PU','','https://drive.google.com/file/d/12Ii6Qxiosg4ppA5duKjat3Zq5FTOpedt/view?usp=drivesdk','application/pdf',301666,0,'ANUAL','2025-01-02',NULL,NULL,'2025-10-14 11:37:07'),(58,30,'TITULO','HOJA RESUMEN','','https://drive.google.com/file/d/1EGg-OVm6nNc5iP3Bl7u1NQ-XispJXfxU/view?usp=drivesdk','application/pdf',309894,0,'ANUAL','2025-01-02',NULL,NULL,'2025-10-14 11:37:36'),(59,30,'TITULO','LUZ','','https://drive.google.com/file/d/1Tq2AcIF8xMJopytO89ju2neTOIE3QdaN/view?usp=drivesdk','application/pdf',98800,0,'ANUAL','2025-09-20',NULL,NULL,'2025-10-14 11:39:36'),(60,30,'TITULO','AGUA','','https://drive.google.com/file/d/1GtwJQG2lQ33Afo1Q-GesNbCt-vcDvlyr/view?usp=drivesdk','application/pdf',1416867,0,'ANUAL','2025-09-15',NULL,NULL,'2025-10-14 11:40:09'),(61,26,'TITULO','CERTIFICADO GARANTIA','','https://drive.google.com/file/d/1U_iAKyyfc27v9ayxxLISFx61BUcc47wu/view?usp=drivesdk','application/pdf',609802,0,'ANUAL',NULL,NULL,NULL,'2025-10-14 11:42:11'),(62,26,'TITULO','DECLARACION JURADA','','https://drive.google.com/file/d/18EIs7g_PGAihDscveuXqYwhf8IAhn4Oe/view?usp=drivesdk','application/pdf',468010,0,'ANUAL',NULL,NULL,NULL,'2025-10-14 11:42:24'),(63,26,'TITULO','MANUAL DE CONVIVENCIA','','https://drive.google.com/file/d/1sHjQPkKHTbIxBX2x6loQelBuBJcslAlk/view?usp=drivesdk','application/pdf',583369,0,'ANUAL',NULL,NULL,NULL,'2025-10-14 11:42:39'),(64,26,'TITULO','MANUAL DEL PROPIETARIO','','https://drive.google.com/file/d/19GoMhB64kSl-Lv_f2zN48BvW7GmyGEwp/view?usp=drivesdk','application/pdf',66322969,0,'ANUAL',NULL,NULL,NULL,'2025-10-14 11:43:20'),(65,26,'TITULO','PLANO DE ARQUITECTURA','','https://drive.google.com/file/d/10f_xrv6vFXAuzwyktKM-7vCZEVAbJkMv/view?usp=drivesdk','application/pdf',455768,0,'ANUAL',NULL,NULL,NULL,'2025-10-14 11:43:37'),(66,26,'TITULO','PLANO DE GAS','','https://drive.google.com/file/d/1decOHpjv_b82KW7vge4QOj6n3wOxn06Z/view?usp=drivesdk','application/pdf',822640,0,'ANUAL',NULL,NULL,NULL,'2025-10-14 11:43:57'),(67,26,'TITULO','PLANO ALUMBRADO','','https://drive.google.com/file/d/1PFonjSFWnjnUm5CpQyInPXG_1IY5HKtr/view?usp=drivesdk','application/pdf',553071,0,'ANUAL',NULL,NULL,NULL,'2025-10-14 11:44:11'),(68,26,'TITULO','PLANO COMUNICACIONES','','https://drive.google.com/file/d/1B6epPgZoBfvTUgF9SK3WA6lnW_YO6vPi/view?usp=drivesdk','application/pdf',657259,0,'ANUAL',NULL,NULL,NULL,'2025-10-14 11:44:31'),(69,26,'TITULO','PLANO TOMACORRIENTE','','https://drive.google.com/file/d/1UtwIaV39hUYiOPi7EfXurNrNVvmcNJSL/view?usp=drivesdk','application/pdf',701836,0,'ANUAL',NULL,NULL,NULL,'2025-10-14 11:44:47'),(70,26,'TITULO','PLANO AGUA','','https://drive.google.com/file/d/1MSpwYesg0-CdBDGXWu1VeZTGjIeGywm5/view?usp=drivesdk','application/pdf',642257,0,'ANUAL',NULL,NULL,NULL,'2025-10-14 11:45:10'),(71,26,'TITULO','PLANO DESAGUE','','https://drive.google.com/file/d/1f2Z3KU1kvPgMk08eqitm4HdvY4XJFbA8/view?usp=drivesdk','application/pdf',805949,0,'ANUAL',NULL,NULL,NULL,'2025-10-14 11:45:21'),(72,26,'TITULO','LUZ','','https://drive.google.com/file/d/1dvrQpRxHOmvC6FUbTsCmrzSk1KimHEle/view?usp=drivesdk','application/pdf',758737,0,'MENSUAL','2025-10-09','2025-10-09',NULL,'2025-10-14 11:48:14'),(73,26,'TITULO','MINUTA COMPRA-VENTA','','https://drive.google.com/file/d/1XDFebo6sKx-mxEHsLMGTYG4Oc8qx_68A/view?usp=drivesdk','application/pdf',26795187,0,'ANUAL',NULL,NULL,NULL,'2025-10-14 11:50:37'),(74,22,'TITULO','TECHO PLANO','','https://drive.google.com/file/d/1rkdXEFXlCOhr11eJANW41J8QW-WSaFwt/view?usp=drivesdk','application/pdf',513116,0,'ANUAL',NULL,NULL,NULL,'2025-10-14 11:52:49'),(75,22,'TITULO','TECHO PLANO 2','','https://drive.google.com/file/d/17C1eZob0zuxzk8dOtpZ29R9MFldCgP4K/view?usp=drivesdk','application/pdf',613773,0,'ANUAL',NULL,NULL,NULL,'2025-10-14 11:53:02'),(78,27,'TITULO','HOJA RESUMEN - HR','','https://drive.google.com/file/d/1oDJeqt7Raf82AJiRk6Ugu2kgnf4yRB4N/view?usp=drivesdk','0',771903,0,'MENSUAL','2025-01-02','2025-10-02',NULL,'2025-10-17 08:32:22'),(79,27,'TITULO','PU - PREDIO URBANO','','https://drive.google.com/file/d/1GTnoVGpXsJXiytEyaSO8QgVEMrJBQZt_/view?usp=drivesdk','0',925788,0,'ANUAL','2025-01-02','2026-01-02',NULL,'2025-10-17 08:34:12'),(80,27,'TITULO','PAGO ARBITRIO - CODIGO','','https://drive.google.com/file/d/1tb34x6Crcp0vdrXbPjGpagzBWnDp5X_Q/view?usp=drivesdk','0',213121,0,'MENSUAL','2025-09-11','2025-10-11',NULL,'2025-10-17 08:41:15'),(81,27,'TITULO','RECIBO LUZ','','https://drive.google.com/file/d/1Z4YQu3CdIN2T3Xw2O9dpcGW-O8r3oRUv/view?usp=drivesdk','0',216768,0,'MENSUAL','2025-09-19','2025-10-04',NULL,'2025-10-17 09:26:03'),(82,27,'TITULO','RECIBO AGUA','','https://drive.google.com/file/d/1lf5x2-pA4zU-riGnzlL0iNjarVEnneCP/view?usp=drivesdk','0',232493,0,'MENSUAL','2025-09-11','2025-10-26',NULL,'2025-10-17 09:27:05'),(83,28,'TITULO','RECIBO LUZ','','https://drive.google.com/file/d/1i16uOLquxTf1aDwFx_SaSWMtmz--YDgw/view?usp=drivesdk','0',171614,0,'MENSUAL','2025-06-23','2025-10-08',NULL,'2025-10-17 09:42:49'),(84,28,'TITULO','RECIBO AGUA','','https://drive.google.com/file/d/1FMceJFLKYvLj1qIPR4-rwAAjbUn0J2n_/view?usp=drivesdk','0',166861,0,'MENSUAL','2025-06-12','2025-10-27',NULL,'2025-10-17 09:43:40'),(87,25,'TITULO','CERTIFICADO DE OPERATIVIDAD','','https://drive.google.com/file/d/1WubUF5xxLUvggynxQ5R1-U3VMRuW9t4Z/view?usp=drivesdk','image/jpeg',153552,0,'ANUAL','2025-09-15','2026-09-15',NULL,'2025-10-22 08:06:57'),(88,25,'TITULO','CERTIFICADO DE INSTALACIÓN DE LAMINA','','https://drive.google.com/file/d/1wlJfH-AUoefaXZDPXcGR7eI7lwBZb5OR/view?usp=drivesdk','image/jpeg',185798,0,'ANUAL',NULL,NULL,NULL,'2025-10-22 08:07:43'),(89,25,'TITULO','CERTIFICADO DE SISTEMA DE PUESTA A  TIERRA','','https://drive.google.com/file/d/1itjMze6iudDRSe4bn1jMRyO-IeSj6E2q/view?usp=drivesdk','image/jpeg',96553,0,'ANUAL','2025-08-19','2026-08-19',NULL,'2025-10-22 08:08:47'),(90,25,'TITULO','PROTOCOLO DE POZO A TIERRA','','https://drive.google.com/file/d/1rbD-6fL0u1GS4WzKTU6Eep8th9PfNax5/view?usp=drivesdk','image/jpeg',159498,0,'ANUAL','2025-09-01','2026-09-01',NULL,'2025-10-22 08:10:23'),(91,25,'TITULO','EXTINGUIDOR','','https://drive.google.com/file/d/1XUvjdWVQLmqwyK6uWI7ORVXFwXCXqDbi/view?usp=drivesdk','image/jpeg',132490,0,'ANUAL','2025-09-01','2026-09-01',NULL,'2025-10-22 08:12:19'),(92,25,'TITULO','CERTIFICADO SANEAMIENTO AMBIENTAL','','https://drive.google.com/file/d/1HGVUQD1GvoQ61Szv_DZmX-JqDhmvEZX8/view?usp=drivesdk','image/jpeg',202804,0,'ANUAL','2025-07-15','2026-07-15',NULL,'2025-10-22 10:00:51'),(93,25,'TITULO','CERTIFICADO DE INSPECCION TECNICA DE SEGURIDAD','','https://drive.google.com/file/d/17z1eL37H3y40-Udh0AqcPwdjk_Nt9jot/view?usp=drivesdk','image/jpeg',119912,0,'ANUAL','2025-09-18','2027-09-17',NULL,'2025-10-22 10:01:58'),(94,26,'TITULO','SOLICITUD INSCRIPCION MUNICIPALIDAD','','https://drive.google.com/file/d/1auXyHLFTYeHBuof8R0lqqIMNXlWwEthM/view?usp=drivesdk','application/pdf',1024410,0,'ANUAL','2025-12-02',NULL,NULL,'2025-12-03 11:29:05');

--
-- Table structure for table `unidades`
--

CREATE TABLE `unidades` (
  `id` int NOT NULL AUTO_INCREMENT,
  `propiedad_id` int NOT NULL,
  `tipo` enum('DEPARTAMENTO','LOCAL','HABITACION','CASA') NOT NULL,
  `codigo_ref` varchar(60) DEFAULT NULL,
  `piso` varchar(20) DEFAULT NULL,
  `area_m2` decimal(10,2) DEFAULT NULL,
  `activo` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `fk_unid_prop` (`propiedad_id`),
  CONSTRAINT `fk_unid_prop` FOREIGN KEY (`propiedad_id`) REFERENCES `propiedades` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `unidades`
--

INSERT INTO `unidades` VALUES (17,15,'DEPARTAMENTO','Departamento 1','1',93.77,1,'2025-10-11 16:48:58','2025-10-14 15:50:11'),(18,15,'DEPARTAMENTO','Departamento 2','2',90.66,1,'2025-10-11 16:48:58','2025-10-14 16:02:21'),(19,15,'DEPARTAMENTO','Departamento 3','3',88.98,1,'2025-10-11 16:48:58','2025-10-14 16:03:46'),(20,15,'DEPARTAMENTO','Departamento 4','4',88.98,1,'2025-10-11 16:48:58','2025-10-14 16:24:10'),(22,15,'HABITACION','5TO A','5',NULL,1,'2025-10-11 16:48:58','2025-10-14 16:28:58'),(23,15,'HABITACION','5TO B','5',NULL,1,'2025-10-11 16:48:58','2025-10-14 16:28:53'),(24,15,'HABITACION','5TO C','5',NULL,1,'2025-10-11 16:48:58','2025-10-14 16:29:07'),(25,13,'LOCAL','JR MARISCAL LUZURIAGA 315 - BD','1',45.00,1,'2025-10-11 20:31:16','2025-10-23 11:18:51'),(26,17,'DEPARTAMENTO','DEP BREÑA NUE','3',65.33,1,'2025-10-11 20:50:52','2025-10-14 16:50:06'),(27,14,'DEPARTAMENTO','212','2',NULL,1,'2025-10-13 12:37:34','2025-10-13 12:37:50'),(28,14,'DEPARTAMENTO','303','3',NULL,1,'2025-10-13 12:37:45','2025-10-16 12:46:36'),(29,16,'LOCAL','JR CASTRO VIRREYNA 287 - YOYISS','1',NULL,1,'2025-10-13 12:38:14','2025-10-23 11:17:07'),(30,15,'DEPARTAMENTO','TORRE 2 301','3',88.12,1,'2025-10-14 12:20:22','2025-10-14 16:35:48');

--
-- Table structure for table `usuario_cargo`
--

CREATE TABLE `usuario_cargo` (
  `id` int NOT NULL AUTO_INCREMENT,
  `usuario_id` int NOT NULL,
  `cargo_id` int NOT NULL,
  `desde` date NOT NULL,
  `hasta` date DEFAULT NULL,
  `es_principal` tinyint(1) NOT NULL DEFAULT '0',
  `estado` enum('ACTIVO','INACTIVO') NOT NULL DEFAULT 'ACTIVO',
  `creado_en` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `vigente` tinyint(1) GENERATED ALWAYS AS (if((`hasta` is null),1,0)) STORED,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_uc_unico_vigente` (`usuario_id`,`cargo_id`,`vigente`),
  UNIQUE KEY `uq_uc_principal_vigente` (`usuario_id`,`es_principal`,`vigente`),
  KEY `ix_uc_usuario_actual` (`usuario_id`,`hasta`),
  KEY `ix_uc_cargo_actual` (`cargo_id`,`hasta`),
  CONSTRAINT `fk_uc_cargo` FOREIGN KEY (`cargo_id`) REFERENCES `cargos` (`cargo_id`) ON DELETE RESTRICT ON UPDATE CASCADE,
  CONSTRAINT `fk_uc_usuario` FOREIGN KEY (`usuario_id`) REFERENCES `usuarios` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `usuario_cargo`
--

INSERT INTO `usuario_cargo` (`id`, `usuario_id`, `cargo_id`, `desde`, `hasta`, `es_principal`, `estado`, `creado_en`) VALUES (1,11,1,'2025-11-03',NULL,1,'ACTIVO','2025-11-03 17:39:23'),(2,12,2,'2025-11-03',NULL,1,'ACTIVO','2025-11-03 17:39:23'),(3,21,3,'2025-11-03',NULL,1,'ACTIVO','2025-11-03 17:39:23'),(4,1,13,'2025-11-06',NULL,1,'ACTIVO','2025-11-06 14:02:29'),(5,9,14,'2025-11-06',NULL,1,'ACTIVO','2025-11-06 14:02:29'),(6,13,12,'2025-11-06',NULL,1,'ACTIVO','2025-11-06 14:02:29'),(7,14,8,'2025-11-06',NULL,1,'ACTIVO','2025-11-06 14:02:29'),(8,15,5,'2025-11-06',NULL,1,'ACTIVO','2025-11-06 14:02:29'),(9,18,4,'2025-11-06',NULL,1,'ACTIVO','2025-11-06 14:02:29'),(10,19,6,'2025-11-06',NULL,1,'ACTIVO','2025-11-06 14:02:29'),(11,23,7,'2025-11-06',NULL,1,'ACTIVO','2025-11-06 14:02:29');

--
-- Table structure for table `usuarios`
--

CREATE TABLE `usuarios` (
  `id` int NOT NULL AUTO_INCREMENT,
  `nombres` varchar(100) NOT NULL,
  `apellidos` varchar(100) NOT NULL,
  `fecha_nacimiento` date DEFAULT NULL,
  `celular` varchar(15) NOT NULL,
  `correo` varchar(100) NOT NULL,
  `password` varchar(255) NOT NULL,
  `area_id` int DEFAULT NULL,
  `rol` enum('ADMIN','USUARIO') DEFAULT 'USUARIO',
  `estado` enum('ACTIVO','INACTIVO') NOT NULL DEFAULT 'ACTIVO',
  `creado_en` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `correo` (`correo`),
  KEY `idx_usuarios_area_id` (`area_id`),
  KEY `idx_id_nombres` (`id`,`nombres`(50),`apellidos`(50)),
  KEY `idx_usuarios_nombres` (`id`,`nombres`,`apellidos`),
  CONSTRAINT `fk_usuarios_areas` FOREIGN KEY (`area_id`) REFERENCES `areas` (`area_id`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `usuarios`
--

INSERT INTO `usuarios` VALUES (1,'SOFIA JOSELIN','CAJAHUAMAN MENDOZA','1997-08-30','984249222','joselin.demo@gmail.com','$2y$10$n5Hp.1qUjJkItizHW5vuAOwWlwJazaxW1kAutl0MYQOLTkKLABEHe',2,'ADMIN','ACTIVO','2025-07-22 02:55:18'),(9,'GRIMALDO','VARA','2000-08-08','987456321','bolsaded@gmail.com','$2y$10$sHHm6/sp1sn60PgCT41R6OD/y9AA6j.GTtVj1HeZCbp6N8GBgXLoi',25,'ADMIN','ACTIVO','2025-08-08 11:18:52'),(11,'NAYUMI GENOBEBA','VARA ATUNCA','2005-01-14','923547014','nayumivara2@gmail.com','$2y$10$5ygoVrrqTvz4tfDynjUMZuS5EzoQS4ahy.rMwryDGjeckGxgfjH4q',24,'ADMIN','ACTIVO','2025-08-12 11:58:52'),(12,'BRENDA XIOMARA','BAZALAR MUÑOZ','2000-02-28','981272323','admbusiness.2020@gmail.com','$2y$10$HKTv6d3SJtxVtxgaZZTgsOn0LZM3BiAShvU3YDjy3BPZvNRdxtpCy',3,'ADMIN','ACTIVO','2025-08-12 12:24:18'),(13,'CARLOS KENNEDY','SILVA RODRIGUEZ','1996-09-14','968824885','carlossilvarodriguez8@gmail.com','$2y$10$uDoGEBYbEKKOHqKr2dhFu.EuMB5OlmjQdseaDpK.mTMIDQ.RKewvG',1,'USUARIO','ACTIVO','2025-08-18 16:20:52'),(14,'ARIANA DE LOS ANGELES','SIESQUEN CHAVESTA','2003-09-22','908871277','ventanillabd1@gmail.com','$2y$10$/rng5oOGscX1QRa9eyuesu1o3N.Ti9395jUm.aAcsUxKl6rrTpPXO',14,'USUARIO','ACTIVO','2025-08-19 16:34:34'),(15,'ANTUANET YASURI','MOZO ALBAREZ','2001-01-10','999492526','innovadorasbd22@gmail.com','$2y$10$.zg/Xku22rLZH0LKKW.In.rRr7wrG9lEhm3VYfrnqX1hxBZMpgPnO',19,'USUARIO','ACTIVO','2025-08-19 16:36:26'),(16,'ENMA ZORAIDA','ALAN PUYCAN','1978-03-30','000000000','invernegofacturacion@gmail.com','$2y$10$7bX8dFTzDxwisbBuI0IdRObHbQSIqgozHJHqt69e.uZsMPR8nPooK',16,'USUARIO','ACTIVO','2025-08-19 16:38:22'),(17,'Anthony Rick','Matazoglio Anton','1992-01-10','970357929','inversolbd@gmail.com','$2y$10$liLtgfjq5ZkhpaAgF8HJSuZ.qwDW8TpsEsi7z4hql.Q/diHzBFPCS',NULL,'USUARIO','INACTIVO','2025-08-19 16:40:45'),(18,'THANIA ALEXANDRA','ESCALANTE CARDENAS','2001-02-27','999492324','business.divisas@gmail.com','$2y$10$zngEZb4ivcDzOIU5dLaEPOWieA.73smc6h6G0pfP7k9.sTciOS2vm',21,'USUARIO','ACTIVO','2025-08-19 16:42:56'),(19,'NATIVIDAD EMILIA','OCHOA RUMICHE','2000-09-09','999492526','inversiones.bd2022@gmail.com','$2y$10$YgAVXHmTnnd1zhbFsicjO.XvbX.cnBeKDXYzZva81BDY3kF36ZLMW',15,'USUARIO','ACTIVO','2025-08-19 16:44:09'),(21,'STEPHANY D\'YANIRE','ORTIZ BRAN','1994-07-12','000000000','ventanillabd2@gmail.com','$2y$10$Denr90oAWm86Y.dQOYxmkOxiGBU8HxI2/jDh5H8TCXhptgKWyWGFy',6,'USUARIO','ACTIVO','2025-08-19 16:49:22'),(22,'MARIA ALVINA ROSARIO','SANGAMA CACHIQUE','1994-07-19','000000000','apoyobd@gmail.com','$2y$10$rX3yeY72mljZFHYIUFaxGOz.gwArW3lI9iOpJ2HOJM7aKc1kKslzq',18,'USUARIO','ACTIVO','2025-08-19 16:50:37'),(23,'GENOBEBA','PILLACA GARRIAZO','1959-04-14','924990130','GENOBEBAPILLACA2@GMAIL.COM','$2y$10$fCT1ZDgHcmSKyaWJyRzXy.oCO/x1IKzI72FDHqzqPM8Oo2Jmv5Uwa',13,'USUARIO','ACTIVO','2025-08-30 16:53:36'),(28,'DIEGO','PACO PILLACA','1994-02-03','970128542','confialexpyp@gmail.com','$2y$10$VpnEGbUE/vpVBVhNrmF4iu49tqS4qRzMMsUg8wr4khjHWR/SXbQzm',NULL,'USUARIO','ACTIVO','2025-09-27 15:32:01'),(29,'FABIANO','MORALES PACO','2000-12-20','999999999','multifuncionalbd@gmail.com','$2y$10$lVbD.Z5rmqMJwQOkLK05je71t2SoW2O7CWh8ey2cXgt3opM7Ni212',29,'USUARIO','ACTIVO','2026-01-06 11:59:39');

--
-- Temporary view structure for view `v_kardex_simple`
--

/*!50001 DROP VIEW IF EXISTS `v_kardex_simple`*/;
/*!50001 CREATE VIEW `v_kardex_simple` AS SELECT 
 1 AS `producto_id`,
 1 AS `sede_id`,
 1 AS `fecha`,
 1 AS `tipo`,
 1 AS `cantidad`,
 1 AS `nota`*/;

--
-- Temporary view structure for view `v_stock_total_producto`
--

/*!50001 DROP VIEW IF EXISTS `v_stock_total_producto`*/;
/*!50001 CREATE VIEW `v_stock_total_producto` AS SELECT 
 1 AS `producto_id`,
 1 AS `nombre`,
 1 AS `stock_total`*/;

--
-- Table structure for table `vacaciones`
--

CREATE TABLE `vacaciones` (
  `id` int NOT NULL AUTO_INCREMENT,
  `usuario_id` int NOT NULL,
  `fecha_inicio` date NOT NULL,
  `fecha_fin` date NOT NULL,
  `medio_dia_inicio` tinyint(1) DEFAULT '0',
  `medio_dia_fin` tinyint(1) DEFAULT '0',
  `tipo` enum('VACACIONES','PERMISO_CON_GOCE','PERMISO_SIN_GOCE','LICENCIA','OTRO') DEFAULT 'VACACIONES',
  `estado` enum('PENDIENTE','APROBADO','RECHAZADO') DEFAULT 'PENDIENTE',
  `motivo` varchar(500) DEFAULT NULL,
  `reemplazo_usuario_id` int DEFAULT NULL,
  `archivo` varchar(255) DEFAULT NULL,
  `color` varchar(7) DEFAULT '#28a745',
  `notificar` tinyint(1) DEFAULT '1',
  `excluir_fines` tinyint(1) DEFAULT '1',
  `excluir_feriados` tinyint(1) DEFAULT '1',
  `dias_habiles` decimal(5,1) DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `usuario_id` (`usuario_id`),
  KEY `estado` (`estado`),
  CONSTRAINT `chk_rango` CHECK ((`fecha_fin` >= `fecha_inicio`))
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `vacaciones`
--

INSERT INTO `vacaciones` VALUES (7,15,'2025-08-18','2025-08-24',0,0,'VACACIONES','APROBADO','',NULL,NULL,'#1055f4',1,1,1,5.0,9,'2025-08-19 11:38:02','2025-08-23 12:33:09'),(8,16,'2025-08-23','2025-08-30',0,0,'VACACIONES','APROBADO','s',1,NULL,'#d77f04',1,1,1,5.0,9,'2025-08-19 11:39:54','2025-08-23 12:32:10'),(10,20,'2025-09-13','2025-09-17',0,0,'VACACIONES','APROBADO','',NULL,NULL,'#d32752',1,0,0,5.0,9,'2025-08-19 12:25:11','2025-09-06 07:42:38'),(11,11,'2025-09-13','2025-09-17',0,0,'VACACIONES','APROBADO','',NULL,NULL,'#09b331',1,1,1,3.0,9,'2025-08-19 12:25:45','2025-09-06 07:42:45'),(13,19,'2025-10-27','2025-11-02',0,0,'VACACIONES','PENDIENTE','',NULL,NULL,'#d309fb',1,1,1,5.0,9,'2025-08-19 12:26:54','2025-09-02 17:40:04'),(16,12,'2025-08-25','2025-08-30',0,0,'OTRO','APROBADO','Enviar saldos\r\nEstar en transferencia hasta que ingrese Alexandra 8:00 - 8:15 Am aprox\r\nreaunion Avances 8:30 - 9:00 Am L-S\r\nAlmuerzo reeplazo alexandra - Transferencia 12:00 Am - 1:00 Pm',17,NULL,'#11acee',1,1,1,5.0,9,'2025-08-22 21:36:03','2025-09-02 17:40:57'),(17,12,'2025-01-11','2025-01-18',0,0,'VACACIONES','APROBADO','',NULL,NULL,'#11acee',1,1,1,5.0,12,'2025-08-23 12:15:40','2025-09-02 17:52:03'),(18,12,'2025-03-15','2025-03-17',0,0,'VACACIONES','APROBADO','',NULL,NULL,'#11acee',1,1,1,1.0,12,'2025-08-23 12:18:02','2025-09-02 17:52:00'),(19,12,'2025-03-21','2025-03-24',0,0,'VACACIONES','APROBADO','',NULL,NULL,'#11acee',1,1,1,2.0,12,'2025-08-23 12:18:43','2025-09-02 17:50:59'),(20,14,'2025-02-03','2025-02-09',0,0,'VACACIONES','APROBADO','',NULL,NULL,'#fd2bcf',1,1,1,5.0,12,'2025-08-23 12:22:05','2025-08-23 12:31:15'),(21,14,'2025-03-28','2025-03-30',0,0,'VACACIONES','APROBADO','',NULL,NULL,'#fd2bcf',1,1,1,1.0,12,'2025-08-23 12:22:43','2025-08-23 12:31:54'),(22,14,'2024-11-23','2024-11-27',0,0,'VACACIONES','APROBADO','',NULL,NULL,'#fd2bcf',1,1,1,3.0,12,'2025-08-23 12:23:44','2025-08-23 12:31:03'),(23,11,'2025-02-10','2025-02-11',0,0,'VACACIONES','APROBADO','',NULL,NULL,'#09b331',1,1,1,2.0,12,'2025-08-23 12:26:06','2025-08-23 12:31:26'),(24,11,'2025-02-24','2025-03-01',0,0,'VACACIONES','APROBADO','',NULL,NULL,'#09b331',1,1,1,5.0,12,'2025-08-23 12:26:35','2025-08-23 12:31:29'),(26,16,'2025-03-25','2025-03-31',0,0,'VACACIONES','APROBADO','',NULL,NULL,'#d77f04',1,1,1,5.0,12,'2025-08-23 12:29:31','2025-08-23 12:31:43'),(27,15,'2025-03-03','2025-03-10',0,0,'VACACIONES','APROBADO','',NULL,NULL,'#1055f4',1,1,1,6.0,12,'2025-08-23 12:32:58','2025-08-23 12:32:58'),(28,21,'2025-06-23','2025-06-29',0,0,'VACACIONES','APROBADO','',NULL,NULL,'#ae2929',1,1,1,5.0,12,'2025-08-23 12:33:53','2025-09-02 17:53:00'),(30,13,'2025-09-01','2025-09-08',0,0,'VACACIONES','PENDIENTE','',NULL,NULL,'#000fe6',1,1,1,6.0,12,'2025-08-23 12:38:59','2025-08-23 12:39:29'),(31,1,'2025-07-29','2025-08-05',0,0,'VACACIONES','APROBADO','',NULL,NULL,'#6424db',1,0,0,8.0,1,'2025-09-02 16:06:05','2025-09-02 16:06:58'),(34,23,'2025-09-13','2025-09-17',0,0,'VACACIONES','APROBADO','',NULL,NULL,'#007bff',0,1,1,3.0,1,'2025-09-16 07:18:07','2025-09-16 07:18:07'),(35,18,'2025-09-20','2025-09-30',0,0,'VACACIONES','APROBADO','VACACIONES PAGADAS',NULL,NULL,'#cd6155',1,1,1,7.0,12,'2025-10-01 07:00:10','2025-10-01 07:00:15');

--
-- Table structure for table `vacaciones_adjuntos`
--

CREATE TABLE `vacaciones_adjuntos` (
  `id` int NOT NULL AUTO_INCREMENT,
  `vacacion_id` int NOT NULL,
  `ruta` varchar(255) NOT NULL,
  `nombre_original` varchar(255) NOT NULL,
  `mime` varchar(150) DEFAULT NULL,
  `tam_bytes` bigint DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `vacacion_id` (`vacacion_id`),
  CONSTRAINT `fk_vac_adj_vac` FOREIGN KEY (`vacacion_id`) REFERENCES `vacaciones` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `vacaciones_adjuntos`
--


--
-- Table structure for table `vacaciones_anio`
--

CREATE TABLE `vacaciones_anio` (
  `id` int NOT NULL AUTO_INCREMENT,
  `usuario_id` int NOT NULL,
  `fecha_inicio` date NOT NULL,
  `fecha_fin` date NOT NULL,
  `medio_dia_inicio` tinyint(1) NOT NULL DEFAULT '0',
  `medio_dia_fin` tinyint(1) NOT NULL DEFAULT '0',
  `dias_habiles` decimal(5,2) DEFAULT NULL,
  `tipo` enum('VACACIONES','PERMISO_CON_GOCE','PERMISO_SIN_GOCE','LICENCIA','OTRO') NOT NULL DEFAULT 'VACACIONES',
  `estado` enum('PENDIENTE','APROBADO','RECHAZADO') NOT NULL DEFAULT 'PENDIENTE',
  `color` char(7) NOT NULL DEFAULT '#28a745',
  `motivo` text,
  `reemplazo_usuario_id` int DEFAULT NULL,
  `excluir_fines` tinyint(1) NOT NULL DEFAULT '1',
  `excluir_feriados` tinyint(1) NOT NULL DEFAULT '1',
  `notificar` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `fk_vanio_reemplazo` (`reemplazo_usuario_id`),
  KEY `idx_vanio_usuario_fecha` (`usuario_id`,`fecha_inicio`,`fecha_fin`),
  KEY `idx_vanio_estado` (`estado`),
  CONSTRAINT `fk_vanio_reemplazo` FOREIGN KEY (`reemplazo_usuario_id`) REFERENCES `usuarios` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `fk_vanio_usuario` FOREIGN KEY (`usuario_id`) REFERENCES `usuarios` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `vacaciones_anio`
--

INSERT INTO `vacaciones_anio` VALUES (3,11,'2024-02-10','2024-02-11',0,0,2.00,'VACACIONES','PENDIENTE','#c4ffbd','',NULL,0,0,1,'2025-12-02 08:51:44','2025-12-02 08:51:56');

--
-- Table structure for table `vacaciones_anio_adjuntos`
--

CREATE TABLE `vacaciones_anio_adjuntos` (
  `id` int NOT NULL AUTO_INCREMENT,
  `vacacion_id` int NOT NULL,
  `nombre_archivo` varchar(255) NOT NULL,
  `ruta_archivo` varchar(500) NOT NULL,
  `tamano_bytes` int DEFAULT NULL,
  `mime_type` varchar(100) DEFAULT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `idx_vanioadj_vac` (`vacacion_id`),
  CONSTRAINT `fk_vanioadj_vac` FOREIGN KEY (`vacacion_id`) REFERENCES `vacaciones_anio` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `vacaciones_anio_adjuntos`
--


--
-- Table structure for table `vacaciones_anio_resumen`
--

CREATE TABLE `vacaciones_anio_resumen` (
  `id` int NOT NULL AUTO_INCREMENT,
  `usuario_id` int DEFAULT NULL,
  `personal` varchar(255) DEFAULT NULL,
  `periodo_texto` varchar(255) DEFAULT NULL,
  `cumpleanos_dm` varchar(5) DEFAULT NULL COMMENT 'Fecha de cumpleaños en formato dd/mm',
  `anio` year NOT NULL,
  `anio_periodo` int DEFAULT NULL,
  `s1_del` date DEFAULT NULL,
  `s1_hasta` date DEFAULT NULL,
  `s2_del` date DEFAULT NULL,
  `s2_hasta` date DEFAULT NULL,
  `s3_del` date DEFAULT NULL,
  `s3_hasta` date DEFAULT NULL,
  `s4_del` date DEFAULT NULL,
  `s4_hasta` date DEFAULT NULL,
  `dias_totales` decimal(5,2) DEFAULT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `idx_vaniores_usuario_anio` (`usuario_id`,`anio`),
  KEY `idx_cumpleanos_dm` (`cumpleanos_dm`),
  CONSTRAINT `fk_vaniores_usuario` FOREIGN KEY (`usuario_id`) REFERENCES `usuarios` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=87 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `vacaciones_anio_resumen`
--

INSERT INTO `vacaciones_anio_resumen` VALUES (13,1,'SOFIA CAJAHUAMAN','30/08','30/08',2025,2025,'2025-07-29','2025-08-05',NULL,NULL,NULL,NULL,NULL,NULL,8.00,'2025-12-02 10:23:27','2025-12-27 11:47:35'),(14,12,'BRENDA BAZALAR','02/01/2024 al 01/01/2025',NULL,2025,2025,'2025-01-11','2025-01-18','2025-03-15','2025-03-17','2025-03-21','2025-03-24',NULL,NULL,15.00,'2025-12-02 21:15:37','2025-12-12 06:57:49'),(15,11,'NAYUMI VARA','14/01','14/01',2025,2025,'2025-02-10','2025-02-11','2025-02-24','2025-03-01','2025-09-11','2025-09-15',NULL,NULL,13.00,'2025-12-03 06:05:20','2025-12-27 13:27:52'),(17,23,'GENOBEBA PILLACA','',NULL,2025,2025,'2025-03-06','2025-03-09','2025-09-11','2025-09-15',NULL,NULL,NULL,NULL,9.00,'2025-12-11 11:47:50','2025-12-27 12:30:30'),(18,16,'ENMA ALAN','13/03/2024 al 13/03/2025','30/03',2025,2025,'2025-03-25','2025-03-31','2025-08-23','2025-08-30',NULL,NULL,NULL,NULL,15.00,'2025-12-11 11:52:14','2026-01-05 06:44:44'),(19,15,'ANTUANET MOZO','02/04/2024 al 02/04/2025','10/01',2025,2025,'2025-03-03','2025-03-10','2025-08-18','2025-08-24',NULL,NULL,NULL,NULL,15.00,'2025-12-11 11:56:36','2026-01-05 06:44:42'),(20,21,'STEPHANY ORTIZ','29/06','29/06',0000,0,'2025-06-23','2025-06-29','2025-09-21','2025-09-21',NULL,NULL,NULL,NULL,8.00,'2025-12-11 11:56:36','2025-12-13 13:19:08'),(21,13,'CARLOS SILVA','23/05/2024 al 23/05/2025',NULL,2025,2025,'2025-11-21','2025-11-27','2025-09-01','2025-09-08',NULL,NULL,NULL,NULL,15.00,'2025-12-11 12:01:59','2025-12-12 06:56:41'),(22,18,'THANIA ESCALANTE','27/02','27/02',2025,2025,'2025-11-21','2025-11-24','2025-11-15','2025-11-25',NULL,NULL,NULL,NULL,15.00,'2025-12-11 12:01:59','2025-12-27 11:46:16'),(23,19,'NATIVIDAD OCHOA','09/09','09/09',2025,2025,'2025-10-27','2025-11-02',NULL,NULL,NULL,'2025-12-30','2025-01-06',NULL,7.00,'2025-12-11 12:05:25','2025-12-27 12:38:05'),(24,1,'SOFIA CAJAHUAMAN','2026','30/08',2026,2026,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,'2025-12-15 09:10:28','2025-12-15 10:28:23'),(25,15,'ANTUANET MOZO','2026','10/01',2026,2026,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,'2025-12-15 09:18:14','2025-12-15 10:26:01'),(26,12,'BRENDA BAZALAR','2026','28/02',2026,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,'2025-12-15 09:23:31','2025-12-15 09:25:59'),(27,14,'ARIANA SIESQUEN','2026','22/09',2026,2026,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,'2025-12-15 09:26:11','2025-12-15 09:26:11'),(28,13,'CARLOS SILVA','2026','14/09',2026,2026,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,'2025-12-15 09:30:03','2025-12-15 09:30:03'),(29,21,'STEPHANY ORTIZ','2026','29/06',2026,2026,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,'2025-12-15 10:27:50','2025-12-15 10:28:19'),(30,16,'ENMA ALAN','2026','30/03',2026,2026,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,'2025-12-15 10:28:48','2025-12-15 10:28:48'),(31,23,'GENOBEBA PILLACA','2026',NULL,2026,2026,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,'2025-12-15 10:28:55','2025-12-15 10:28:55'),(32,9,'GRIMALDO VARA','2026','03/04',2026,2026,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,'2025-12-15 10:29:02','2025-12-15 10:29:02'),(33,22,'MARIA SANGAMA','2026','11/01',2026,2026,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,'2025-12-15 10:29:10','2025-12-15 10:29:10'),(34,19,'NATIVIDAD OCHOA','2026','09/09',2026,2026,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,'2025-12-15 10:29:16','2025-12-15 10:29:16'),(35,11,'NAYUMI VARA','2026','14/01',2026,2026,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,'2025-12-15 10:29:26','2025-12-15 10:29:26'),(36,18,'THANIA ESCALANTE','2026','27/02',2026,2026,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,'2025-12-15 10:29:32','2025-12-15 10:29:32'),(37,15,'ANTUANET MOZO','2027','10/01',2027,2027,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,'2025-12-15 10:31:30','2025-12-15 10:32:10'),(38,14,'ARIANA SIESQUEN','2027','22/09',2027,2027,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,'2025-12-15 10:32:20','2025-12-15 10:32:20'),(39,12,'BRENDA BAZALAR','2027','28/02',2027,2027,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,'2025-12-15 10:32:22','2025-12-15 10:32:22'),(40,13,'CARLOS SILVA','2027','14/09',2027,2027,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,'2025-12-15 10:32:24','2025-12-15 10:32:24'),(41,16,'ENMA ALAN','2027','30/03',2027,2027,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,'2025-12-15 10:32:26','2025-12-15 10:32:34'),(42,23,'GENOBEBA PILLACA','2027',NULL,2027,2027,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,'2025-12-15 10:32:39','2025-12-15 10:32:39'),(43,22,'MARIA SANGAMA','2027','11/01',2027,2027,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,'2025-12-15 10:32:44','2025-12-15 10:32:44'),(44,19,'NATIVIDAD OCHOA','2027','09/09',2027,2027,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,'2025-12-15 10:32:48','2025-12-15 10:32:48'),(45,11,'NAYUMI VARA','2027','14/01',2027,2027,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,'2025-12-15 10:32:56','2025-12-15 10:32:56'),(46,1,'SOFIA CAJAHUAMAN','2027','30/08',2027,2027,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,'2025-12-15 10:33:00','2025-12-15 10:33:00'),(47,21,'STEPHANY ORTIZ','2027','29/06',2027,2027,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,'2025-12-15 10:33:12','2025-12-15 10:33:12'),(48,18,'THANIA ESCALANTE','2027','27/02',2027,2027,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,'2025-12-15 10:33:15','2025-12-15 10:33:15'),(49,15,'ANTUANET MOZO','2028','10/01',2028,2028,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,'2025-12-15 10:34:18','2025-12-15 10:35:58'),(50,14,'ARIANA SIESQUEN','2028','22/09',2028,2028,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,'2025-12-15 10:34:19','2025-12-15 10:34:19'),(51,12,'BRENDA BAZALAR','2028','28/02',2028,2028,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,'2025-12-15 10:34:21','2025-12-15 10:34:21'),(52,13,'CARLOS SILVA','2028','14/09',2028,2028,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,'2025-12-15 10:34:24','2025-12-15 10:34:24'),(53,16,'ENMA ALAN','2028','30/03',2028,2028,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,'2025-12-15 10:34:28','2025-12-15 10:34:28'),(54,23,'GENOBEBA PILLACA','2028',NULL,2028,2028,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,'2025-12-15 10:34:30','2025-12-15 10:34:30'),(55,22,'MARIA SANGAMA','2028','11/01',2028,2028,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,'2025-12-15 10:34:35','2025-12-15 10:34:35'),(56,19,'NATIVIDAD OCHOA','2028','09/09',2028,2028,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,'2025-12-15 10:34:39','2025-12-15 10:34:39'),(57,11,'NAYUMI VARA','2028','14/01',2028,2028,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,'2025-12-15 10:34:41','2025-12-15 10:34:41'),(58,1,'SOFIA CAJAHUAMAN','2028','30/08',2028,2028,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,'2025-12-15 10:34:47','2025-12-15 10:34:47'),(59,21,'STEPHANY ORTIZ','2028','29/06',2028,2028,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,'2025-12-15 10:34:51','2025-12-15 10:34:51'),(60,18,'THANIA ESCALANTE','2028','27/02',2028,2028,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,'2025-12-15 10:34:54','2025-12-15 10:34:54'),(61,15,'ANTUANET MOZO','2023','10/01',2023,2023,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,'2025-12-15 10:38:26','2025-12-15 10:40:28'),(62,14,'ARIANA SIESQUEN','2023','22/09',2023,2023,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,'2025-12-15 10:38:55','2025-12-15 10:38:55'),(63,12,'BRENDA BAZALAR','2023','28/02',2023,2023,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,'2025-12-15 10:38:58','2025-12-15 10:38:58'),(64,13,'CARLOS SILVA','2023','14/09',2023,2023,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,'2025-12-15 10:38:59','2025-12-15 10:38:59'),(65,16,'ENMA ALAN','2023','30/03',2023,2023,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,'2025-12-15 10:39:01','2025-12-15 10:39:09'),(66,23,'GENOBEBA PILLACA','2023',NULL,2023,2023,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,'2025-12-15 10:39:11','2025-12-15 10:39:11'),(67,22,'MARIA SANGAMA','2023','11/01',2023,2023,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,'2025-12-15 10:39:21','2025-12-15 10:39:21'),(68,19,'NATIVIDAD OCHOA','2023','09/09',2023,2023,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,'2025-12-15 10:39:24','2025-12-15 10:39:24'),(69,11,'NAYUMI VARA','2023','14/01',2023,2023,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,'2025-12-15 10:39:34','2025-12-15 10:39:34'),(70,1,'SOFIA CAJAHUAMAN','2023','30/08',2023,2023,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,'2025-12-15 10:39:37','2025-12-15 10:39:37'),(71,21,'STEPHANY ORTIZ','2023','29/06',2023,2023,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,'2025-12-15 10:39:39','2025-12-15 10:39:39'),(72,18,'THANIA ESCALANTE','2023','27/02',2023,2023,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,'2025-12-15 10:39:53','2025-12-15 10:39:53'),(74,15,'ANTUANET MOZO','2024','10/01',2024,2024,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,'2025-12-15 10:51:49','2025-12-15 10:52:48'),(75,14,'ARIANA SIESQUEN','2024','22/09',2024,2024,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,'2025-12-15 10:51:50','2025-12-15 10:51:50'),(76,12,'BRENDA BAZALAR','2024','28/02',2024,2024,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,'2025-12-15 10:51:52','2025-12-15 10:51:52'),(77,13,'CARLOS SILVA','2024','14/09',2024,2024,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,'2025-12-15 10:51:55','2025-12-15 10:51:55'),(78,16,'ENMA ALAN','2024','30/03',2024,2024,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,'2025-12-15 10:51:58','2025-12-15 10:51:58'),(79,23,'GENOBEBA PILLACA','2024',NULL,2024,2024,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,'2025-12-15 10:52:03','2025-12-15 10:52:03'),(80,22,'MARIA SANGAMA','2024','11/01',2024,2024,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,'2025-12-15 10:52:06','2025-12-15 10:52:06'),(81,19,'NATIVIDAD OCHOA','2024','09/09',2024,2024,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,'2025-12-15 10:52:10','2025-12-15 10:52:10'),(82,11,'NAYUMI VARA','2024','14/01',2024,2024,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,'2025-12-15 10:52:16','2025-12-15 10:52:16'),(83,1,'SOFIA CAJAHUAMAN','2024','30/08',2024,2024,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,'2025-12-15 10:52:19','2025-12-15 10:52:19'),(84,21,'STEPHANY ORTIZ','2024','29/06',2024,2024,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,'2025-12-15 10:52:23','2025-12-15 10:52:23'),(85,18,'THANIA ESCALANTE','2024','27/02',2024,2024,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,'2025-12-15 10:52:26','2025-12-15 10:52:26'),(86,21,'STEPHANY ORTIZ','29/06','29/06',2025,2025,'2025-06-23','2025-06-29','2025-09-21','2025-09-21','2025-12-23','2025-12-29',NULL,NULL,15.00,'2025-12-26 08:45:03','2025-12-27 11:47:22');

--
-- Table structure for table `vacaciones_notas`
--

CREATE TABLE `vacaciones_notas` (
  `id` int NOT NULL AUTO_INCREMENT,
  `anio` int NOT NULL,
  `usuario_id` int NOT NULL,
  `tipo` enum('NOTA','REQUERIMIENTO') NOT NULL DEFAULT 'NOTA',
  `texto` text NOT NULL,
  `creado_en` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `actualizado_en` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `vacaciones_notas`
--


--
-- Table structure for table `vacaciones_notas_anio`
--

CREATE TABLE `vacaciones_notas_anio` (
  `id` int NOT NULL AUTO_INCREMENT,
  `anio` int NOT NULL,
  `tipo` enum('NOTA','REQUERIMIENTO') DEFAULT 'NOTA',
  `texto` text NOT NULL,
  `created_by` int DEFAULT NULL,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `idx_anio` (`anio`),
  KEY `idx_created_by` (`created_by`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `vacaciones_notas_anio`
--

INSERT INTO `vacaciones_notas_anio` VALUES (1,2023,'NOTA','Primera condicion es que el personal salga de vacaciones el dia de su cumpleaños ',NULL,'2025-12-02 21:03:01'),(2,2023,'NOTA','Segunda condicion la empresa elegi la fecha que saldra de vacaciones ',NULL,'2025-12-02 21:03:27'),(3,2023,'NOTA','Tercera condicion es que las vacaciones se dan al cumpli el año de laborar ',NULL,'2025-12-02 21:03:40'),(4,2024,'NOTA','Primera condicion es que el personal salga de vacaciones el dia de su cumpleaños ',NULL,'2025-12-02 21:03:01'),(5,2024,'NOTA','Segunda condicion la empresa elegi la fecha que saldra de vacaciones ',NULL,'2025-12-02 21:03:27'),(6,2024,'NOTA','Tercera condicion es que las vacaciones se dan al cumpli el año de laborar ',NULL,'2025-12-02 21:03:40'),(7,2025,'NOTA','Primera condicion es que el personal salga de vacaciones el dia de su cumpleaños ',NULL,'2025-12-02 21:03:01'),(8,2025,'NOTA','Segunda condicion la empresa elegi la fecha que saldra de vacaciones ',NULL,'2025-12-02 21:03:27'),(9,2025,'NOTA','Tercera condicion es que las vacaciones se dan al cumpli el año de laborar ',NULL,'2025-12-02 21:03:40'),(10,2026,'NOTA','Primera condicion es que el personal salga de vacaciones el dia de su cumpleaños ',NULL,'2025-12-02 21:03:01'),(11,2026,'NOTA','Segunda condicion la empresa elegi la fecha que saldra de vacaciones ',NULL,'2025-12-02 21:03:27'),(12,2026,'NOTA','Tercera condicion es que las vacaciones se dan al cumpli el año de laborar ',NULL,'2025-12-02 21:03:40'),(13,2027,'NOTA','Primera condicion es que el personal salga de vacaciones el dia de su cumpleaños ',NULL,'2025-12-02 21:03:01'),(14,2027,'NOTA','Segunda condicion la empresa elegi la fecha que saldra de vacaciones ',NULL,'2025-12-02 21:03:27'),(15,2027,'NOTA','Tercera condicion es que las vacaciones se dan al cumpli el año de laborar ',NULL,'2025-12-02 21:03:40'),(16,2028,'NOTA','Primera condicion es que el personal salga de vacaciones el dia de su cumpleaños ',NULL,'2025-12-02 21:03:01'),(17,2028,'NOTA','Segunda condicion la empresa elegi la fecha que saldra de vacaciones ',NULL,'2025-12-02 21:03:27'),(18,2028,'NOTA','Tercera condicion es que las vacaciones se dan al cumpli el año de laborar ',NULL,'2025-12-02 21:03:40');

--
-- Table structure for table `vacaciones_resumen_notas`
--

CREATE TABLE `vacaciones_resumen_notas` (
  `id` int NOT NULL AUTO_INCREMENT,
  `resumen_id` int NOT NULL,
  `columna_index` int NOT NULL COMMENT '2=S1_DEL, 3=S1_HASTA, 4=S2_DEL, ... 9=S4_HASTA',
  `columna_nombre` varchar(50) DEFAULT NULL,
  `nota` text,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_resumen_columna` (`resumen_id`,`columna_index`),
  KEY `idx_resumen_id` (`resumen_id`),
  KEY `idx_created_at` (`created_at`),
  CONSTRAINT `vacaciones_resumen_notas_ibfk_1` FOREIGN KEY (`resumen_id`) REFERENCES `vacaciones_anio_resumen` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `vacaciones_resumen_notas`
--

INSERT INTO `vacaciones_resumen_notas` VALUES (3,22,3,'S1_HASTA','ALEXANDRA TOMO EL AÑO PASADO UNA PARTE DE SUS VACACIONES 21/11/2024 - 24/11/2024 (4 dias)','2025-12-12 11:24:49','2025-12-12 11:24:49'),(4,21,3,'S1_HASTA','CARLOS TOMO EL AÑO PASADO UNA PARTE DE SUS VACACIONES 21/11/2024 - 27/11/2024 (7 dias)','2025-12-12 11:24:58','2025-12-12 11:24:58'),(5,22,5,'S2_HASTA','VACACIONES VENDIDAS','2025-12-12 11:25:11','2025-12-12 11:25:11');

--
-- Table structure for table `vehiculo_tabla_mant`
--

CREATE TABLE `vehiculo_tabla_mant` (
  `vehiculo_id` int NOT NULL,
  `tabla_json` longtext NOT NULL,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`vehiculo_id`),
  CONSTRAINT `fk_vtm_veh` FOREIGN KEY (`vehiculo_id`) REFERENCES `flota_vehiculos` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `vehiculo_tabla_mant`
--

INSERT INTO `vehiculo_tabla_mant` VALUES (1,'{\"cols\":[\"CAN.\",\"KILOMETRO\",\"PIEZA\",\"FEC. INICIO\",\"FEC. FIN\",\"COMPROBANTE\",\"SERVICIO / PRODUCTO\",\"V. UNI\",\"IGV\",\"COSTO\",\"MANO DE OBRA\",\"TOTAL\"],\"rows\":[[\"1\",\"\",\"2\",\"\",\"\",[],\"AMORTIGUADORES DELANTEROS \",\"190.00\",\"34.20\",\"224.20\",\"0.00\",\"224.20\"],[\"1\",\"\",\"1\",\"\",\"\",\"\",\"AMORTIGUADORES POSTERIORES \",\"110.00\",\"19.80\",\"129.80\",\"0.00\",\"129.80\"],[\"2\",\"\",\"2\",\"\",\"\",\"\",\"TORRETAS\",\"0.00\",\"0.00\",\"0.00\",\"0.00\",\"0.00\"],[\"2\",\"\",\"2\",\"\",\"\",\"\",\"RACK DE DIRECCION \",\"52.80\",\"9.50\",\"62.30\",\"0.00\",\"62.30\"],[\"1\",\"\",\"1\",\"\",\"\",\"\",\"TRAPECIOS DELANTEROS\",\"190.00\",\"34.20\",\"224.20\",\"0.00\",\"224.20\"],[\"2\",\"\",\"2\",\"\",\"\",\"\",\"BIELETAS DELANTERAS\",\"0.00\",\"0.00\",\"0.00\",\"0.00\",\"0.00\"],[\"2\",\"\",\"2\",\"\",\"\",\"\",\"RETENES DE COPA\",\"4.66\",\"0.84\",\"5.50\",\"0.00\",\"5.50\"],[\"4\",\"\",\"4\",\"\",\"\",\"\",\"SOPORTES DE MOTOR\",\"0.00\",\"0.00\",\"0.00\",\"0.00\",\"0.00\"],[\"1\",\"\",\"1\",\"\",\"\",\"\",\"CABLES DE BOBINA\",\"0.00\",\"0.00\",\"0.00\",\"0.00\",\"0.00\"],[\"2\",\"\",\"2\",\"\",\"\",\"\",\"PALIERES\",\"48.00\",\"8.64\",\"56.64\",\"0.00\",\"56.64\"],[\"1\",\"\",\"1\",\"\",\"\",\"\",\"RETEN DE CIGUEÑAL\",\"10.00\",\"1.80\",\"11.80\",\"0.00\",\"11.80\"],[\"3\",\"\",\"3\",\"\",\"\",\"\",\"RETEN DE EJE DE LEVAS\",\"18.00\",\"3.24\",\"21.24\",\"0.00\",\"21.24\"],[\"2\",\"\",\"2\",\"\",\"\",\"\",\"RETEN DE LEVAS POSTERIOR\",\"0.00\",\"0.00\",\"0.00\",\"0.00\",\"0.00\"],[\"1\",\"\",\"1\",\"\",\"\",\"\",\"EMPAQUE DE BALANCINES\",\"0.00\",\"0.00\",\"0.00\",\"0.00\",\"0.00\"],[\"1\",\"\",\"1\",\"\",\"\",\"\",\"RETENES DE BUJIAS \",\"0.00\",\"0.00\",\"0.00\",\"0.00\",\"0.00\"],[\"1\",\"\",\"1\",\"\",\"\",\"\",\"CREMALLERA NUEVA\",\"248.00\",\"44.64\",\"292.64\",\"0.00\",\"292.64\"],[\"1\",\"\",\"1\",\"\",\"\",\"\",\"JUEGO DE BUJIAS DE CARBON\",\"0.00\",\"0.00\",\"0.00\",\"0.00\",\"0.00\"],[\"1\",\"\",\"1\",\"\",\"\",\"\",\"ALINEAMIENTO\",\"0.00\",\"0.00\",\"0.00\",\"0.00\",\"0.00\"],[\"1\",\"\",\"1\",\"\",\"\",\"\",\"CAMBIO DE REFRIGERANTE \",\"0.00\",\"0.00\",\"0.00\",\"0.00\",\"0.00\"],[\"1\",\"\",\"1\",\"\",\"\",\"\",\"FOCO DE ALTA\",\"0.00\",\"0.00\",\"0.00\",\"0.00\",\"0.00\"],[\"1\",\"\",\"1\",\"\",\"\",\"\",\"MANTENIMIENTO GAS\",\"0.00\",\"0.00\",\"0.00\",\"0.00\",\"0.00\"],[\"1\",\"\",\"1\",\"\",\"\",\"\",\"MANO DE OBRA\",\"0.00\",\"0.00\",\"0.00\",\"0.00\",\"0.00\"],[\"\",\"\",\"\",\"\",\"\",\"\",\"ARAÑA \",\"292.00\",\"52.56\",\"344.56\",\"0.00\",\"344.56\"],[\"1\",\"\",\"1\",\"\",\"\",\"\",\"CREMELLERA DIRECCION ASISTIDA - IPS\",\"210.17\",\"37.83\",\"248.00\",\"0.00\",\"248.00\"],[\"\",\"\",\"\",\"\",\"\",\"\",\"TERMINAL EXT\",\"48.00\",\"8.64\",\"56.64\",\"0.00\",\"56.64\"],[\"\",\"\",\"\",\"\",\"\",\"\",\"ROTULA \",\"21.00\",\"3.78\",\"24.78\",\"0.00\",\"24.78\"]],\"cmt\":[\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\"],\"si\":[[{\"v\":95,\"m\":0,\"cmt\":\"<p><img src=\\\"data:image/jpeg;base64,[encoded data, 188388 characters]\\\" width=\\\"165\\\" height=\\\"367\\\"></p>\",\"files\":[],\"igv\":17.1,\"costo\":112.1,\"desc\":\"AMORTIGUADOR DELANTERO LH 2006 - 2010\",\"can\":1,\"km\":0,\"fini\":\"\",\"ffin\":\"\",\"emp\":\"LUMAXSA AREQUIPA\",\"marca\":\"GOLD\"},{\"vals\":[\"\",\"\",\"\",\"\",\"\",\"\",\"AMORTIGUADOR DELANTERO RH 2006 - 2010 GOLD\",\"80.51\",\"14.49\",\"95\",\"\",\"\"],\"cmt\":\"\",\"can\":0,\"km\":0,\"fini\":\"\",\"ffin\":\"\",\"emp\":\"LUMAXSA AREQUIPA\",\"marca\":\"GOLD\",\"desc\":\"AMORTIGUADOR DELANTERO RH 2006 - 2010\",\"v\":95,\"igv\":17.1,\"costo\":112.1,\"m\":0,\"files\":[]},{\"can\":1,\"km\":0,\"fini\":\"\",\"ffin\":\"\",\"emp\":\"\",\"marca\":\"\",\"desc\":\"\",\"v\":0,\"igv\":0,\"costo\":0,\"m\":0,\"files\":[],\"cmt\":\"\"},{\"v\":0,\"m\":0,\"can\":1,\"km\":0,\"fini\":\"\",\"ffin\":\"\",\"emp\":\"\",\"marca\":\"\",\"desc\":\"\",\"files\":[],\"cmt\":\"\",\"igv\":0,\"costo\":0},{\"v\":0,\"m\":0,\"can\":1,\"km\":0,\"fini\":\"\",\"ffin\":\"\",\"emp\":\"\",\"marca\":\"\",\"desc\":\"\",\"files\":[],\"cmt\":\"\",\"igv\":0,\"costo\":0},{\"v\":0,\"m\":0,\"can\":1,\"km\":0,\"fini\":\"\",\"ffin\":\"\",\"emp\":\"\",\"marca\":\"\",\"desc\":\"\",\"files\":[],\"cmt\":\"\",\"igv\":0,\"costo\":0}],[{\"vals\":[\"\",\"\",\"\",\"\",\"\",\"\",\"AMORTIGUADORPOSTERIOR 2006-2010 - MANDO\",\"93.20\",\"16.78\",\"110\",\"\",\"\"],\"cmt\":\"\",\"can\":0,\"km\":0,\"fini\":\"\",\"ffin\":\"\",\"emp\":\"LUMAXSA AREQUIPA\",\"marca\":\"MANDO\",\"desc\":\"AMORTIGUADOR POSTERIOR 2006-2010 - MANDO\",\"v\":110,\"igv\":19.8,\"costo\":129.8,\"m\":0,\"files\":[]},{\"vals\":[\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\"],\"cmt\":\"\",\"can\":0,\"km\":0,\"fini\":\"\",\"ffin\":\"\",\"emp\":\"\",\"marca\":\"\",\"desc\":\"\",\"v\":0,\"igv\":0,\"costo\":0,\"m\":0,\"files\":[]},{\"v\":0,\"m\":0,\"can\":1,\"km\":0,\"fini\":\"\",\"ffin\":\"\",\"emp\":\"\",\"marca\":\"\",\"desc\":\"\",\"files\":[],\"cmt\":\"\",\"igv\":0,\"costo\":0},{\"v\":0,\"m\":0,\"can\":1,\"km\":0,\"fini\":\"\",\"ffin\":\"\",\"emp\":\"\",\"marca\":\"\",\"desc\":\"\",\"files\":[],\"cmt\":\"\",\"igv\":0,\"costo\":0},{\"v\":0,\"m\":0,\"can\":1,\"km\":0,\"fini\":\"\",\"ffin\":\"\",\"emp\":\"\",\"marca\":\"\",\"desc\":\"\",\"files\":[],\"cmt\":\"\",\"igv\":0,\"costo\":0}],[{\"can\":1,\"km\":0,\"fini\":\"\",\"ffin\":\"\",\"emp\":\"\",\"marca\":\"\",\"desc\":\"\",\"v\":0,\"igv\":0,\"costo\":0,\"m\":0,\"files\":[],\"cmt\":\"\"},{\"v\":0,\"m\":0,\"can\":1,\"km\":0,\"fini\":\"\",\"ffin\":\"\",\"emp\":\"\",\"marca\":\"\",\"desc\":\"\",\"files\":[],\"cmt\":\"\",\"igv\":0,\"costo\":0},{\"v\":0,\"m\":0,\"can\":1,\"km\":0,\"fini\":\"\",\"ffin\":\"\",\"emp\":\"\",\"marca\":\"\",\"desc\":\"\",\"files\":[],\"cmt\":\"\",\"igv\":0,\"costo\":0},{\"v\":0,\"m\":0,\"can\":1,\"km\":0,\"fini\":\"\",\"ffin\":\"\",\"emp\":\"\",\"marca\":\"\",\"desc\":\"\",\"files\":[],\"cmt\":\"\",\"igv\":0,\"costo\":0}],[{\"vals\":[\"\",\"\",\"\",\"\",\"\",\"\",\"AMORTIGUADOR DELANTERO LH -2006 2010 GAS GOLD\",\"52.8\",\"42.2\",\"95\",\"\",\"\"],\"cmt\":\"\",\"can\":0,\"km\":0,\"fini\":\"\",\"ffin\":\"\",\"emp\":\"\",\"marca\":\"\",\"desc\":\"AMORTIGUADOR DELANTERO LH -2006 2010 GAS GOLD\",\"v\":52.8,\"igv\":9.5,\"costo\":62.3,\"m\":0,\"files\":[]},{\"v\":0,\"m\":0,\"can\":1,\"km\":0,\"fini\":\"\",\"ffin\":\"\",\"emp\":\"\",\"marca\":\"\",\"desc\":\"\",\"files\":[],\"cmt\":\"\",\"igv\":0,\"costo\":0},{\"v\":0,\"m\":0,\"can\":1,\"km\":0,\"fini\":\"\",\"ffin\":\"\",\"emp\":\"\",\"marca\":\"\",\"desc\":\"\",\"files\":[],\"cmt\":\"\",\"igv\":0,\"costo\":0},{\"v\":0,\"m\":0,\"can\":1,\"km\":0,\"fini\":\"\",\"ffin\":\"\",\"emp\":\"\",\"marca\":\"\",\"desc\":\"\",\"files\":[],\"cmt\":\"\",\"igv\":0,\"costo\":0}],[{\"v\":95,\"m\":0,\"can\":1,\"km\":0,\"fini\":\"\",\"ffin\":\"\",\"emp\":\"LUMAXSA AREQUIPA\",\"marca\":\"DONGNAMKAP\",\"desc\":\"TRAPECIO DELANTERO LH\",\"files\":[],\"cmt\":\"\",\"igv\":17.1,\"costo\":112.1},{\"v\":95,\"m\":0,\"can\":1,\"km\":0,\"fini\":\"\",\"ffin\":\"\",\"emp\":\"LUMAXSA AREQUIPA\",\"marca\":\"DONGNAMKAP\",\"desc\":\"TRAPECIO DELANTERO RH\",\"files\":[],\"cmt\":\"\",\"igv\":17.1,\"costo\":112.1},{\"v\":0,\"m\":0,\"can\":1,\"km\":0,\"fini\":\"\",\"ffin\":\"\",\"emp\":\"\",\"marca\":\"\",\"desc\":\"\",\"files\":[],\"cmt\":\"\",\"igv\":0,\"costo\":0},{\"v\":0,\"m\":0,\"can\":1,\"km\":0,\"fini\":\"\",\"ffin\":\"\",\"emp\":\"\",\"marca\":\"\",\"desc\":\"\",\"files\":[],\"cmt\":\"\",\"igv\":0,\"costo\":0},{\"v\":0,\"m\":0,\"can\":1,\"km\":0,\"fini\":\"\",\"ffin\":\"\",\"emp\":\"\",\"marca\":\"\",\"desc\":\"\",\"files\":[],\"cmt\":\"\",\"igv\":0,\"costo\":0},{\"v\":0,\"m\":0,\"can\":1,\"km\":0,\"fini\":\"\",\"ffin\":\"\",\"emp\":\"\",\"marca\":\"\",\"desc\":\"\",\"files\":[],\"cmt\":\"\",\"igv\":0,\"costo\":0},{\"v\":0,\"m\":0,\"can\":1,\"km\":0,\"fini\":\"\",\"ffin\":\"\",\"emp\":\"\",\"marca\":\"\",\"desc\":\"\",\"files\":[],\"cmt\":\"\",\"igv\":0,\"costo\":0}],[{\"v\":0,\"m\":0,\"can\":1,\"km\":0,\"fini\":\"\",\"ffin\":\"\",\"emp\":\"\",\"marca\":\"\",\"desc\":\"\",\"files\":[],\"cmt\":\"\",\"igv\":0,\"costo\":0}],[{\"vals\":[\"\",\"\",\"\",\"\",\"\",\"\",\"RETEN DE  CAJA LADO PALIER - POSPH\",\"4.66\",\"0.84\",\"5.5\",\"\",\"\"],\"cmt\":\"\",\"can\":1,\"km\":0,\"fini\":\"\",\"ffin\":\"\",\"emp\":\"LUMAXSA AREQUIPA\",\"marca\":\"POSH\",\"desc\":\"RETEN DE  CAJA LADO PALIER - POSPH\",\"v\":4.66,\"m\":0,\"files\":[],\"igv\":0.84,\"costo\":5.5},{\"v\":0,\"m\":0,\"can\":1,\"km\":0,\"fini\":\"\",\"ffin\":\"\",\"emp\":\"\",\"marca\":\"\",\"desc\":\"\",\"files\":[],\"cmt\":\"\",\"igv\":0,\"costo\":0},{\"v\":0,\"m\":0,\"can\":1,\"km\":0,\"fini\":\"\",\"ffin\":\"\",\"emp\":\"\",\"marca\":\"\",\"desc\":\"\",\"files\":[],\"cmt\":\"\",\"igv\":0,\"costo\":0},{\"v\":0,\"m\":0,\"can\":1,\"km\":0,\"fini\":\"\",\"ffin\":\"\",\"emp\":\"\",\"marca\":\"\",\"desc\":\"\",\"files\":[],\"cmt\":\"\",\"igv\":0,\"costo\":0}],[{\"v\":0,\"m\":0,\"can\":1,\"km\":0,\"fini\":\"\",\"ffin\":\"\",\"emp\":\"\",\"marca\":\"\",\"desc\":\"\",\"files\":[],\"cmt\":\"\",\"igv\":0,\"costo\":0},{\"v\":0,\"m\":0,\"can\":1,\"km\":0,\"fini\":\"\",\"ffin\":\"\",\"emp\":\"\",\"marca\":\"\",\"desc\":\"\",\"files\":[],\"cmt\":\"\",\"igv\":0,\"costo\":0},{\"v\":0,\"m\":0,\"can\":1,\"km\":0,\"fini\":\"\",\"ffin\":\"\",\"emp\":\"\",\"marca\":\"\",\"desc\":\"\",\"files\":[],\"cmt\":\"\",\"igv\":0,\"costo\":0},{\"v\":0,\"m\":0,\"can\":1,\"km\":0,\"fini\":\"\",\"ffin\":\"\",\"emp\":\"\",\"marca\":\"\",\"desc\":\"\",\"files\":[],\"cmt\":\"\",\"igv\":0,\"costo\":0}],[{\"v\":0,\"m\":0,\"can\":1,\"km\":0,\"fini\":\"\",\"ffin\":\"\",\"emp\":\"\",\"marca\":\"\",\"desc\":\"\",\"files\":[],\"cmt\":\"\",\"igv\":0,\"costo\":0},{\"v\":0,\"m\":0,\"can\":1,\"km\":0,\"fini\":\"\",\"ffin\":\"\",\"emp\":\"\",\"marca\":\"\",\"desc\":\"\",\"files\":[],\"cmt\":\"\",\"igv\":0,\"costo\":0},{\"v\":0,\"m\":0,\"can\":1,\"km\":0,\"fini\":\"\",\"ffin\":\"\",\"emp\":\"\",\"marca\":\"\",\"desc\":\"\",\"files\":[],\"cmt\":\"\",\"igv\":0,\"costo\":0},{\"v\":0,\"m\":0,\"can\":1,\"km\":0,\"fini\":\"\",\"ffin\":\"\",\"emp\":\"\",\"marca\":\"\",\"desc\":\"\",\"files\":[],\"cmt\":\"\",\"igv\":0,\"costo\":0}],[{\"vals\":[\"\",\"\",\"\",\"\",\"\",\"\",\"PAILER\",\"40.68\",\"7.32\",\"48\",\"\",\"\"],\"cmt\":\"\",\"can\":1,\"km\":0,\"fini\":\"\",\"ffin\":\"\",\"emp\":\"LUMAXSA AREQUIPA\",\"marca\":\"WURTEX\",\"desc\":\"PAILER\",\"v\":48,\"m\":0,\"files\":[],\"igv\":8.64,\"costo\":56.64},{\"v\":0,\"m\":0,\"can\":1,\"km\":0,\"fini\":\"\",\"ffin\":\"\",\"emp\":\"\",\"marca\":\"\",\"desc\":\"\",\"files\":[],\"cmt\":\"\",\"igv\":0,\"costo\":0},{\"v\":0,\"m\":0,\"can\":1,\"km\":0,\"fini\":\"\",\"ffin\":\"\",\"emp\":\"\",\"marca\":\"\",\"desc\":\"\",\"files\":[],\"cmt\":\"\",\"igv\":0,\"costo\":0},{\"v\":0,\"m\":0,\"can\":1,\"km\":0,\"fini\":\"\",\"ffin\":\"\",\"emp\":\"\",\"marca\":\"\",\"desc\":\"\",\"files\":[],\"cmt\":\"\",\"igv\":0,\"costo\":0},{\"v\":0,\"m\":0,\"can\":1,\"km\":0,\"fini\":\"\",\"ffin\":\"\",\"emp\":\"\",\"marca\":\"\",\"desc\":\"\",\"files\":[],\"cmt\":\"\",\"igv\":0,\"costo\":0}],[{\"vals\":[\"\",\"\",\"\",\"\",\"\",\"\",\"RETEN CIGUEÑAL DELANTERO  MODELO1  - POS\",\"8.50\",\"1.53\",\"10\",\"\",\"\"],\"cmt\":\"\",\"can\":1,\"km\":0,\"fini\":\"\",\"ffin\":\"\",\"emp\":\"LUMAXSA AREQUIPA\",\"marca\":\"POS\",\"desc\":\"RETEN CIGUEÑAL DELANTERO  MODELO1  - POS\",\"v\":10,\"m\":0,\"files\":[],\"igv\":1.8,\"costo\":11.8},{\"v\":0,\"m\":0,\"can\":1,\"km\":0,\"fini\":\"\",\"ffin\":\"\",\"emp\":\"\",\"marca\":\"\",\"desc\":\"\",\"files\":[],\"cmt\":\"\",\"igv\":0,\"costo\":0},{\"v\":0,\"m\":0,\"can\":1,\"km\":0,\"fini\":\"\",\"ffin\":\"\",\"emp\":\"\",\"marca\":\"\",\"desc\":\"\",\"files\":[],\"cmt\":\"\",\"igv\":0,\"costo\":0},{\"v\":0,\"m\":0,\"can\":1,\"km\":0,\"fini\":\"\",\"ffin\":\"\",\"emp\":\"\",\"marca\":\"\",\"desc\":\"\",\"files\":[],\"cmt\":\"\",\"igv\":0,\"costo\":0},{\"v\":0,\"m\":0,\"can\":1,\"km\":0,\"fini\":\"\",\"ffin\":\"\",\"emp\":\"\",\"marca\":\"\",\"desc\":\"\",\"files\":[],\"cmt\":\"\",\"igv\":0,\"costo\":0}],[{\"vals\":[\"\",\"\",\"\",\"\",\"\",\"\",\"RETEN DE EJES DELANTEROS - HYUNDAI / KIA\",\"15.25\",\"2.75\",\"18\",\"\",\"\"],\"cmt\":\"\",\"can\":1,\"km\":0,\"fini\":\"\",\"ffin\":\"\",\"emp\":\"LUMAXSA AREQUIPA\",\"marca\":\"HYUNDAI/KIA\",\"desc\":\"RETEN DE EJES DELANTEROS - HYUNDAI / KIA\",\"v\":18,\"m\":0,\"files\":[],\"igv\":3.24,\"costo\":21.24},{\"v\":0,\"m\":0,\"can\":1,\"km\":0,\"fini\":\"\",\"ffin\":\"\",\"emp\":\"\",\"marca\":\"\",\"desc\":\"\",\"files\":[],\"cmt\":\"\",\"igv\":0,\"costo\":0},{\"v\":0,\"m\":0,\"can\":1,\"km\":0,\"fini\":\"\",\"ffin\":\"\",\"emp\":\"\",\"marca\":\"\",\"desc\":\"\",\"files\":[],\"cmt\":\"\",\"igv\":0,\"costo\":0},{\"v\":0,\"m\":0,\"can\":1,\"km\":0,\"fini\":\"\",\"ffin\":\"\",\"emp\":\"\",\"marca\":\"\",\"desc\":\"\",\"files\":[],\"cmt\":\"\",\"igv\":0,\"costo\":0},{\"v\":0,\"m\":0,\"can\":1,\"km\":0,\"fini\":\"\",\"ffin\":\"\",\"emp\":\"\",\"marca\":\"\",\"desc\":\"\",\"files\":[],\"cmt\":\"\",\"igv\":0,\"costo\":0}],[{\"v\":0,\"m\":0,\"can\":1,\"km\":0,\"fini\":\"\",\"ffin\":\"\",\"emp\":\"\",\"marca\":\"\",\"desc\":\"\",\"files\":[],\"cmt\":\"\",\"igv\":0,\"costo\":0},{\"v\":0,\"m\":0,\"can\":1,\"km\":0,\"fini\":\"\",\"ffin\":\"\",\"emp\":\"\",\"marca\":\"\",\"desc\":\"\",\"files\":[],\"cmt\":\"\",\"igv\":0,\"costo\":0},{\"v\":0,\"m\":0,\"can\":1,\"km\":0,\"fini\":\"\",\"ffin\":\"\",\"emp\":\"\",\"marca\":\"\",\"desc\":\"\",\"files\":[],\"cmt\":\"\",\"igv\":0,\"costo\":0},{\"v\":0,\"m\":0,\"can\":1,\"km\":0,\"fini\":\"\",\"ffin\":\"\",\"emp\":\"\",\"marca\":\"\",\"desc\":\"\",\"files\":[],\"cmt\":\"\",\"igv\":0,\"costo\":0}],[{\"v\":0,\"m\":0,\"can\":1,\"km\":0,\"fini\":\"\",\"ffin\":\"\",\"emp\":\"\",\"marca\":\"\",\"desc\":\"\",\"files\":[],\"cmt\":\"\",\"igv\":0,\"costo\":0},{\"v\":0,\"m\":0,\"can\":1,\"km\":0,\"fini\":\"\",\"ffin\":\"\",\"emp\":\"\",\"marca\":\"\",\"desc\":\"\",\"files\":[],\"cmt\":\"\",\"igv\":0,\"costo\":0},{\"v\":0,\"m\":0,\"can\":1,\"km\":0,\"fini\":\"\",\"ffin\":\"\",\"emp\":\"\",\"marca\":\"\",\"desc\":\"\",\"files\":[],\"cmt\":\"\",\"igv\":0,\"costo\":0},{\"v\":0,\"m\":0,\"can\":1,\"km\":0,\"fini\":\"\",\"ffin\":\"\",\"emp\":\"\",\"marca\":\"\",\"desc\":\"\",\"files\":[],\"cmt\":\"\",\"igv\":0,\"costo\":0},{\"v\":0,\"m\":0,\"can\":1,\"km\":0,\"fini\":\"\",\"ffin\":\"\",\"emp\":\"\",\"marca\":\"\",\"desc\":\"\",\"files\":[],\"cmt\":\"\",\"igv\":0,\"costo\":0}],[{\"v\":0,\"m\":0,\"can\":1,\"km\":0,\"fini\":\"\",\"ffin\":\"\",\"emp\":\"\",\"marca\":\"\",\"desc\":\"\",\"files\":[],\"cmt\":\"\",\"igv\":0,\"costo\":0},{\"v\":0,\"m\":0,\"can\":1,\"km\":0,\"fini\":\"\",\"ffin\":\"\",\"emp\":\"\",\"marca\":\"\",\"desc\":\"\",\"files\":[],\"cmt\":\"\",\"igv\":0,\"costo\":0},{\"v\":0,\"m\":0,\"can\":1,\"km\":0,\"fini\":\"\",\"ffin\":\"\",\"emp\":\"\",\"marca\":\"\",\"desc\":\"\",\"files\":[],\"cmt\":\"\",\"igv\":0,\"costo\":0},{\"v\":0,\"m\":0,\"can\":1,\"km\":0,\"fini\":\"\",\"ffin\":\"\",\"emp\":\"\",\"marca\":\"\",\"desc\":\"\",\"files\":[],\"cmt\":\"\",\"igv\":0,\"costo\":0}],[{\"v\":248,\"m\":0,\"igv\":44.64,\"costo\":292.64,\"desc\":\"\",\"can\":1,\"km\":0,\"fini\":\"\",\"ffin\":\"\",\"emp\":\"\",\"marca\":\"\",\"files\":[],\"cmt\":\"\"},{\"can\":1,\"km\":0,\"fini\":\"\",\"ffin\":\"\",\"emp\":\"\",\"marca\":\"\",\"desc\":\"\",\"v\":0,\"igv\":0,\"costo\":0,\"m\":0,\"files\":[],\"cmt\":\"\"},{\"can\":1,\"km\":0,\"fini\":\"\",\"ffin\":\"\",\"emp\":\"\",\"marca\":\"\",\"desc\":\"\",\"v\":0,\"igv\":0,\"costo\":0,\"m\":0,\"files\":[],\"cmt\":\"\"},{\"v\":0,\"m\":0,\"can\":1,\"km\":0,\"fini\":\"\",\"ffin\":\"\",\"emp\":\"\",\"marca\":\"\",\"desc\":\"\",\"files\":[],\"cmt\":\"\",\"igv\":0,\"costo\":0},{\"v\":0,\"m\":0,\"can\":1,\"km\":0,\"fini\":\"\",\"ffin\":\"\",\"emp\":\"\",\"marca\":\"\",\"desc\":\"\",\"files\":[],\"cmt\":\"\",\"igv\":0,\"costo\":0}],[{\"v\":0,\"m\":0,\"can\":1,\"km\":0,\"fini\":\"\",\"ffin\":\"\",\"emp\":\"\",\"marca\":\"\",\"desc\":\"\",\"files\":[],\"cmt\":\"\",\"igv\":0,\"costo\":0},{\"v\":0,\"m\":0,\"can\":1,\"km\":0,\"fini\":\"\",\"ffin\":\"\",\"emp\":\"\",\"marca\":\"\",\"desc\":\"\",\"files\":[],\"cmt\":\"\",\"igv\":0,\"costo\":0},{\"v\":0,\"m\":0,\"can\":1,\"km\":0,\"fini\":\"\",\"ffin\":\"\",\"emp\":\"\",\"marca\":\"\",\"desc\":\"\",\"files\":[],\"cmt\":\"\",\"igv\":0,\"costo\":0},{\"v\":0,\"m\":0,\"can\":1,\"km\":0,\"fini\":\"\",\"ffin\":\"\",\"emp\":\"\",\"marca\":\"\",\"desc\":\"\",\"files\":[],\"cmt\":\"\",\"igv\":0,\"costo\":0},{\"v\":0,\"m\":0,\"can\":1,\"km\":0,\"fini\":\"\",\"ffin\":\"\",\"emp\":\"\",\"marca\":\"\",\"desc\":\"\",\"files\":[],\"cmt\":\"\",\"igv\":0,\"costo\":0}],[{\"v\":0,\"m\":0,\"can\":1,\"km\":0,\"fini\":\"\",\"ffin\":\"\",\"emp\":\"\",\"marca\":\"\",\"desc\":\"\",\"files\":[],\"cmt\":\"\",\"igv\":0,\"costo\":0},{\"v\":0,\"m\":0,\"can\":1,\"km\":0,\"fini\":\"\",\"ffin\":\"\",\"emp\":\"\",\"marca\":\"\",\"desc\":\"\",\"files\":[],\"cmt\":\"\",\"igv\":0,\"costo\":0},{\"v\":0,\"m\":0,\"can\":1,\"km\":0,\"fini\":\"\",\"ffin\":\"\",\"emp\":\"\",\"marca\":\"\",\"desc\":\"\",\"files\":[],\"cmt\":\"\",\"igv\":0,\"costo\":0},{\"v\":0,\"m\":0,\"can\":1,\"km\":0,\"fini\":\"\",\"ffin\":\"\",\"emp\":\"\",\"marca\":\"\",\"desc\":\"\",\"files\":[],\"cmt\":\"\",\"igv\":0,\"costo\":0}],[{\"v\":0,\"m\":0,\"can\":1,\"km\":0,\"fini\":\"\",\"ffin\":\"\",\"emp\":\"\",\"marca\":\"\",\"desc\":\"\",\"files\":[],\"cmt\":\"\",\"igv\":0,\"costo\":0},{\"v\":0,\"m\":0,\"can\":1,\"km\":0,\"fini\":\"\",\"ffin\":\"\",\"emp\":\"\",\"marca\":\"\",\"desc\":\"\",\"files\":[],\"cmt\":\"\",\"igv\":0,\"costo\":0},{\"v\":0,\"m\":0,\"can\":1,\"km\":0,\"fini\":\"\",\"ffin\":\"\",\"emp\":\"\",\"marca\":\"\",\"desc\":\"\",\"files\":[],\"cmt\":\"\",\"igv\":0,\"costo\":0},{\"v\":0,\"m\":0,\"can\":1,\"km\":0,\"fini\":\"\",\"ffin\":\"\",\"emp\":\"\",\"marca\":\"\",\"desc\":\"\",\"files\":[],\"cmt\":\"\",\"igv\":0,\"costo\":0}],[{\"v\":0,\"m\":0,\"can\":1,\"km\":0,\"fini\":\"\",\"ffin\":\"\",\"emp\":\"\",\"marca\":\"\",\"desc\":\"\",\"files\":[],\"cmt\":\"\",\"igv\":0,\"costo\":0},{\"v\":0,\"m\":0,\"can\":1,\"km\":0,\"fini\":\"\",\"ffin\":\"\",\"emp\":\"\",\"marca\":\"\",\"desc\":\"\",\"files\":[],\"cmt\":\"\",\"igv\":0,\"costo\":0},{\"v\":0,\"m\":0,\"can\":1,\"km\":0,\"fini\":\"\",\"ffin\":\"\",\"emp\":\"\",\"marca\":\"\",\"desc\":\"\",\"files\":[],\"cmt\":\"\",\"igv\":0,\"costo\":0},{\"v\":0,\"m\":0,\"can\":1,\"km\":0,\"fini\":\"\",\"ffin\":\"\",\"emp\":\"\",\"marca\":\"\",\"desc\":\"\",\"files\":[],\"cmt\":\"\",\"igv\":0,\"costo\":0}],[{\"v\":0,\"m\":0,\"can\":1,\"km\":0,\"fini\":\"\",\"ffin\":\"\",\"emp\":\"\",\"marca\":\"\",\"desc\":\"\",\"files\":[],\"cmt\":\"\",\"igv\":0,\"costo\":0},{\"v\":0,\"m\":0,\"can\":1,\"km\":0,\"fini\":\"\",\"ffin\":\"\",\"emp\":\"\",\"marca\":\"\",\"desc\":\"\",\"files\":[],\"cmt\":\"\",\"igv\":0,\"costo\":0},{\"v\":0,\"m\":0,\"can\":1,\"km\":0,\"fini\":\"\",\"ffin\":\"\",\"emp\":\"\",\"marca\":\"\",\"desc\":\"\",\"files\":[],\"cmt\":\"\",\"igv\":0,\"costo\":0},{\"v\":0,\"m\":0,\"can\":1,\"km\":0,\"fini\":\"\",\"ffin\":\"\",\"emp\":\"\",\"marca\":\"\",\"desc\":\"\",\"files\":[],\"cmt\":\"\",\"igv\":0,\"costo\":0}],[{\"v\":0,\"m\":0,\"can\":1,\"km\":0,\"fini\":\"\",\"ffin\":\"\",\"emp\":\"\",\"marca\":\"\",\"desc\":\"\",\"files\":[],\"cmt\":\"\",\"igv\":0,\"costo\":0},{\"v\":0,\"m\":0,\"can\":1,\"km\":0,\"fini\":\"\",\"ffin\":\"\",\"emp\":\"\",\"marca\":\"\",\"desc\":\"\",\"files\":[],\"cmt\":\"\",\"igv\":0,\"costo\":0},{\"v\":0,\"m\":0,\"can\":1,\"km\":0,\"fini\":\"\",\"ffin\":\"\",\"emp\":\"\",\"marca\":\"\",\"desc\":\"\",\"files\":[],\"cmt\":\"\",\"igv\":0,\"costo\":0},{\"v\":0,\"m\":0,\"can\":1,\"km\":0,\"fini\":\"\",\"ffin\":\"\",\"emp\":\"\",\"marca\":\"\",\"desc\":\"\",\"files\":[],\"cmt\":\"\",\"igv\":0,\"costo\":0}],[{\"v\":146,\"m\":0,\"can\":1,\"km\":0,\"fini\":\"\",\"ffin\":\"\",\"emp\":\"IPS\",\"marca\":\"\",\"desc\":\"ARAÑA LH ACCENT RIO 06-11\",\"files\":[],\"cmt\":\"<p><img src=\\\"data:image/png;base64,[encoded data, 227388 characters]