
--
-- Table structure for table `imagenes_elastografia`
--

CREATE TABLE `imagenes_elastografia` (
  `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 'IMAGENES ELASTOGRAFIA',
  `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_imagenes_usuario_fecha` (`usuario_id`,`fecha`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `imagenes_elastografia`
--

INSERT INTO `imagenes_elastografia` VALUES (1,9,'IMAGENES ELASTOGRAFIA','2025-11-27','[\"FECHA\",\"TIPO DE ESTUDIO\",\"RIGIDEZ HEPÁTICA (kPa)\",\"CAP\\/GRADO DE ESTEATOSIS (F0-F4)\",\"HALLAZGO PRINCIPAL\",\"CONCLUSION DE INFORME\",\"RECOMENDACION DEL MEDICO\",\"CENTRO DONDE SE REALIZO\",\"MEDICO RADIOLOGO \\/ ESPECIALISTA\",\"ENLACE \\/ UBICACION DEL ARCHIVO\"]','[[\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\"],[\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\"]]','[115,195,251,336,232,262,301,280,345,333]','2025-11-27 03:27:31','2025-11-27 03:31:13'),(2,11,'IMAGENES ELASTOGRAFIA','2025-11-27','[\"FECHA\",\"TIPO DE ESTUDIO\",\"RIGIDEZ HEPÁTICA (kPa)\",\"CAP\\/GRADO DE ESTEATOSIS (F0-F4)\",\"HALLAZGO PRINCIPAL\",\"CONCLUSION DE INFORME\",\"RECOMENDACION DEL MEDICO\",\"CENTRO DONDE SE REALIZO\",\"MEDICO RADIOLOGO \\/ ESPECIALISTA\",\"ENLACE \\/ UBICACION DEL ARCHIVO\"]','[[\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\"],[\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\"]]','[115,195,251,336,232,262,301,280,345,333]','2025-11-27 08:27:31','2025-11-27 08:31:13');

--
-- Table structure for table `instalaciones`
--

CREATE TABLE `instalaciones` (
  `instalacion_id` int NOT NULL AUTO_INCREMENT,
  `dispositivo_id` int NOT NULL,
  `software_id` int NOT NULL,
  `version_instalada` varchar(80) DEFAULT NULL,
  `licencia_id` int DEFAULT NULL,
  `fecha_instalacion` datetime DEFAULT CURRENT_TIMESTAMP,
  `estado` enum('INSTALADO','DESINSTALADO') DEFAULT 'INSTALADO',
  PRIMARY KEY (`instalacion_id`),
  UNIQUE KEY `uniq_activo` (`dispositivo_id`,`software_id`,`estado`),
  KEY `dispositivo_id` (`dispositivo_id`),
  KEY `software_id` (`software_id`),
  KEY `licencia_id` (`licencia_id`),
  CONSTRAINT `fk_ins_disp` FOREIGN KEY (`dispositivo_id`) REFERENCES `dispositivos` (`dispositivo_id`),
  CONSTRAINT `fk_ins_lic` FOREIGN KEY (`licencia_id`) REFERENCES `licencias` (`licencia_id`),
  CONSTRAINT `fk_ins_sw` FOREIGN KEY (`software_id`) REFERENCES `software` (`software_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `instalaciones`
--


--
-- Table structure for table `licencias`
--

CREATE TABLE `licencias` (
  `licencia_id` int NOT NULL AUTO_INCREMENT,
  `software_id` int NOT NULL,
  `tipo` enum('OEM','RETAIL','VOLUMEN','SUSCRIPCION') NOT NULL,
  `clave` varchar(200) DEFAULT NULL,
  `qty_total` int DEFAULT '1',
  `qty_usada` int DEFAULT '0',
  `fecha_inicio` date DEFAULT NULL,
  `fecha_fin` date DEFAULT NULL,
  `proveedor` varchar(120) DEFAULT NULL,
  `costo` decimal(12,2) DEFAULT '0.00',
  `notas` text,
  PRIMARY KEY (`licencia_id`),
  KEY `software_id` (`software_id`),
  KEY `fecha_fin` (`fecha_fin`),
  CONSTRAINT `fk_lic_sw` FOREIGN KEY (`software_id`) REFERENCES `software` (`software_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `licencias`
--


--
-- Table structure for table `liquidaciones`
--

CREATE TABLE `liquidaciones` (
  `id` int NOT NULL AUTO_INCREMENT,
  `unidad_id` int NOT NULL,
  `periodo` char(7) NOT NULL,
  `ingresos` decimal(10,2) NOT NULL DEFAULT '0.00',
  `gastos` decimal(10,2) NOT NULL DEFAULT '0.00',
  `neto` decimal(10,2) NOT NULL DEFAULT '0.00',
  `pdf_path` varchar(255) DEFAULT NULL,
  `drive_file_id` varchar(128) DEFAULT NULL,
  `drive_view_url` text,
  `drive_download_url` text,
  `estado` enum('GENERADA','ENVIADA') DEFAULT 'GENERADA',
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_liq` (`unidad_id`,`periodo`),
  UNIQUE KEY `uniq_liq` (`unidad_id`,`periodo`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `liquidaciones`
--

INSERT INTO `liquidaciones` VALUES (1,29,'2025-10',2400.00,0.00,2400.00,'pdf/liquidaciones/2025/10/liq_un29_2025-10_162418.pdf','1Yms8AAET72JO-e8ip_N9OpR3T2lZKG_y','https://drive.google.com/file/d/1Yms8AAET72JO-e8ip_N9OpR3T2lZKG_y/view?usp=drivesdk',NULL,'GENERADA','2025-10-14 11:24:21');

--
-- Table structure for table `metas_progreso`
--

CREATE TABLE `metas_progreso` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `usuario_id` int unsigned NOT NULL,
  `nombre` varchar(100) NOT NULL DEFAULT 'METAS_PROGRESO',
  `fecha` date NOT NULL,
  `columnas` longtext NOT NULL,
  `filas` longtext NOT NULL,
  `anchos` longtext NOT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_usuario` (`usuario_id`),
  KEY `idx_usuario_nombre` (`usuario_id`,`nombre`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `metas_progreso`
--

INSERT INTO `metas_progreso` VALUES (1,9,'METAS_PROGRESO','2025-11-27','[\"FECHA DE INICIO DEL PLAN\",\"PESA INICIAL (Kg)\",\"PESO META (Kg)\",\"CINTURA INICIAL (cm)\",\"CINTURA META (cm)\",\"ALT INICIAL (U\\/L)\",\"ALT META (U\\/L)\",\"AST INICIAL (U\\/L)\",\"AST META (U\\/L)\",\"OTRO INDICADOR CLAVE (EJ: GGT, CAP, kPa)\",\"META DE PASOS \\/ DÍA O MINUTOS DE EJERCICIO\",\"FECHA OBJETIVO\",\"COMENTARIO DE COMO VOY\"]','[[\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\"],[\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\"]]','[277,200,182,226,215,190,179,198,188,398,432,195,278]'),(2,11,'METAS_PROGRESO','2025-11-27','[\"FECHA DE INICIO DEL PLAN\",\"PESA INICIAL (Kg)\",\"PESO META (Kg)\",\"CINTURA INICIAL (cm)\",\"CINTURA META (cm)\",\"ALT INICIAL (U\\/L)\",\"ALT META (U\\/L)\",\"AST INICIAL (U\\/L)\",\"AST META (U\\/L)\",\"OTRO INDICADOR CLAVE (EJ: GGT, CAP, kPa)\",\"META DE PASOS \\/ DÍA O MINUTOS DE EJERCICIO\",\"FECHA OBJETIVO\",\"COMENTARIO DE COMO VOY\"]','[[\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\"],[\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\"]]','[277,200,182,226,215,190,179,198,188,398,432,195,278]');

--
-- Table structure for table `movimiento`
--

CREATE TABLE `movimiento` (
  `mov_id` bigint NOT NULL AUTO_INCREMENT,
  `fecha` datetime NOT NULL,
  `producto_id` int NOT NULL,
  `sede_id` int NOT NULL,
  `tipo` enum('ENTRADA','SALIDA','TRANSF-OUT','TRANSF-IN') NOT NULL,
  `cantidad` decimal(12,3) NOT NULL,
  `usuario_id` int NOT NULL,
  `nota` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`mov_id`),
  KEY `fk_mov_sede` (`sede_id`),
  KEY `ix_mov_producto_sede_fecha` (`producto_id`,`sede_id`,`fecha`),
  KEY `ix_mov_tipo_fecha` (`tipo`,`fecha`),
  CONSTRAINT `fk_mov_producto` FOREIGN KEY (`producto_id`) REFERENCES `producto` (`producto_id`) ON DELETE RESTRICT ON UPDATE CASCADE,
  CONSTRAINT `fk_mov_sede` FOREIGN KEY (`sede_id`) REFERENCES `sedes` (`sede_id`) ON DELETE RESTRICT ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `movimiento`
--

INSERT INTO `movimiento` VALUES (1,'2025-10-22 06:16:58',4,3,'ENTRADA',1.000,9,''),(2,'2025-10-23 20:03:01',3,2,'ENTRADA',1.000,1,'Reparto desde Cant.'),(3,'2025-10-23 20:03:27',18,1,'ENTRADA',1.000,1,'Reparto desde Cant.'),(4,'2025-10-23 20:16:43',6,3,'ENTRADA',5.000,1,'Ajuste total por Cant.'),(5,'2025-10-23 20:16:58',6,3,'SALIDA',5.000,1,'Ajuste directo de celda'),(6,'2025-10-23 20:34:33',22,3,'ENTRADA',2.000,1,'Ajuste total por Cant.'),(7,'2025-10-23 20:34:36',22,1,'ENTRADA',2.000,1,'Ajuste directo de celda'),(8,'2025-10-23 20:34:42',22,3,'SALIDA',2.000,1,'Ajuste total por Cant.'),(9,'2025-10-23 21:38:05',6,3,'ENTRADA',1.000,1,'Ajuste total por Cant.'),(10,'2025-10-24 06:08:40',6,3,'ENTRADA',4.000,1,'Ajuste total por Cant.'),(11,'2025-10-24 06:08:43',6,3,'SALIDA',4.000,1,'Ajuste directo de celda'),(12,'2025-10-24 06:08:49',6,5,'ENTRADA',2.000,1,'Ajuste directo de celda');

--
-- Table structure for table `notifications`
--

CREATE TABLE `notifications` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `title` varchar(160) NOT NULL,
  `body` text,
  `url` varchar(255) DEFAULT NULL,
  `read_at` datetime DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `user_id_idx` (`user_id`,`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `notifications`
--


--
-- Table structure for table `novedades`
--

CREATE TABLE `novedades` (
  `novedad_id` int NOT NULL AUTO_INCREMENT,
  `empresa_id` int NOT NULL,
  `trabajador_id` int NOT NULL,
  `periodo` char(7) NOT NULL,
  `concepto_id` int NOT NULL,
  `monto` decimal(10,2) NOT NULL DEFAULT '0.00',
  `descripcion` varchar(255) DEFAULT NULL,
  `fecha` date DEFAULT NULL,
  `estado` enum('PENDIENTE','APLICADO','ANULADO') NOT NULL DEFAULT 'PENDIENTE',
  `creado_por` int DEFAULT NULL,
  `creado_en` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`novedad_id`),
  KEY `idx_periodo` (`periodo`),
  KEY `idx_trabajador_periodo` (`trabajador_id`,`periodo`),
  KEY `idx_empresa_periodo` (`empresa_id`,`periodo`),
  KEY `fk_nov_concepto` (`concepto_id`),
  CONSTRAINT `fk_nov_concepto` FOREIGN KEY (`concepto_id`) REFERENCES `conceptos` (`concepto_id`),
  CONSTRAINT `fk_nov_trabajador` FOREIGN KEY (`trabajador_id`) REFERENCES `trabajadores` (`id_trabajador`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `novedades`
--

INSERT INTO `novedades` VALUES (1,16,12,'2025-12',5,120.00,'12/12/2025',NULL,'ANULADO',1,'2025-12-18 06:02:14'),(2,16,12,'2025-12',11,80.00,'12/12/2025',NULL,'PENDIENTE',1,'2025-12-18 06:02:14'),(3,16,12,'2025-12',16,100.00,NULL,NULL,'PENDIENTE',1,'2025-12-18 06:16:35'),(4,16,12,'2025-12',9,150.00,NULL,NULL,'PENDIENTE',1,'2025-12-18 06:29:40');

--
-- Table structure for table `obligaciones_planilla`
--

CREATE TABLE `obligaciones_planilla` (
  `id_obligacion` int NOT NULL AUTO_INCREMENT,
  `id_planilla` int NOT NULL,
  `tipo` enum('PLAME','ESSALUD','ONP_AFP','SUELDOS','CTS_MAYO','CTS_NOVIEMBRE','GRATI_JULIO','GRATI_DICIEMBRE','OTRO') NOT NULL,
  `descripcion` varchar(255) DEFAULT NULL,
  `fecha_vencimiento` date DEFAULT NULL,
  `fecha_cumplimiento` date DEFAULT NULL,
  `monto` decimal(12,2) DEFAULT '0.00',
  `numero_constancia` varchar(100) DEFAULT NULL,
  `archivo_constancia` varchar(255) DEFAULT NULL,
  `estado` enum('PENDIENTE','CUMPLIDO','VENCIDO') DEFAULT 'PENDIENTE',
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id_obligacion`),
  KEY `fk_obligaciones_planilla` (`id_planilla`),
  CONSTRAINT `fk_obligaciones_planilla` FOREIGN KEY (`id_planilla`) REFERENCES `planilla_mensual` (`id_planilla`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `obligaciones_planilla`
--


--
-- Table structure for table `pagos`
--

CREATE TABLE `pagos` (
  `id` int NOT NULL AUTO_INCREMENT,
  `renta_id` int NOT NULL,
  `fecha_pago` date NOT NULL,
  `monto` decimal(10,2) NOT NULL,
  `medio` varchar(30) DEFAULT NULL,
  `referencia` varchar(100) DEFAULT NULL,
  `notas` text,
  `voucher_path` varchar(255) DEFAULT NULL,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `recibo_drive_id` varchar(128) DEFAULT NULL,
  `recibo_drive_url` varchar(500) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_pagos_renta` (`renta_id`),
  CONSTRAINT `fk_pago_renta` FOREIGN KEY (`renta_id`) REFERENCES `rentas` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `pagos`
--

INSERT INTO `pagos` VALUES (1,51,'2024-11-13',2250.00,'DEPOSITO BCP','','','https://drive.google.com/file/d/1fvhHbiUvk8qbNU2FhYUN_t81lDmj2Dje/view?usp=drivesdk','2025-10-17 07:07:48',NULL,NULL),(2,52,'2025-01-02',2250.00,'DEPOSITO BCP','','','https://drive.google.com/file/d/1u6pm6Th_7zlCEmSVSLj8Dlw7mmcXt-4j/view?usp=drivesdk','2025-10-17 07:09:06',NULL,NULL),(3,53,'2025-02-01',2250.00,'DEPOSITO BCP','','','https://drive.google.com/file/d/1fwWE00h_EfBlxkdx2doXYh1f-WYbkDbL/view?usp=drivesdk','2025-10-17 07:09:30',NULL,NULL),(4,54,'2025-03-01',2250.00,'DEPOSITO BCP','','','https://drive.google.com/file/d/19DGJFcS8mnWzXylnQz4BKWqTxQitI4cX/view?usp=drivesdk','2025-10-17 07:10:07',NULL,NULL),(5,55,'2025-04-01',2250.00,'DEPOSITO BCP','','','https://drive.google.com/file/d/1PBbEOEoU-eSi-u4ZC5pMJ3B4p-LouOjr/view?usp=drivesdk','2025-10-17 07:11:47',NULL,NULL),(6,56,'2025-05-02',2250.00,'DEPOSITO BCP','','','https://drive.google.com/file/d/114y2G2Roh-KRxLtF4fv-HXOUmVEIazKj/view?usp=drivesdk','2025-10-17 07:12:07',NULL,NULL),(7,57,'2025-06-02',2250.00,'DEPOSITO BCP','','','https://drive.google.com/file/d/1QDbzKUQm_3G9zzohQCt6HK9jpY6YGxpg/view?usp=drivesdk','2025-10-17 07:13:14',NULL,NULL),(8,58,'2025-07-01',2250.00,'DEPOSITO BCP','','','https://drive.google.com/file/d/1VpL0Z5Ql3S0GYaMqFKA89iYqfQZQUcMa/view?usp=drivesdk','2025-10-17 07:13:36',NULL,NULL),(9,59,'2025-08-01',2250.00,'DEPOSITO BCP','','','https://drive.google.com/file/d/1OWwIy0W8P7_YRHfbexLOTme7j613B5ms/view?usp=drivesdk','2025-10-17 07:13:54',NULL,NULL),(10,60,'2025-09-01',2250.00,'DEPOSITO BCP','','','https://drive.google.com/file/d/1DUDKJ8bjXrHiis_kp_5dWLwcsF8kYGSJ/view?usp=drivesdk','2025-10-17 07:14:12',NULL,NULL),(11,61,'2025-10-01',2250.00,'DEPOSITO BCP','','','https://drive.google.com/file/d/1MEa4yCan-LxAg2B7U4Yorx-sLGH9ai56/view?usp=drivesdk','2025-10-17 07:14:43',NULL,NULL),(12,63,'2025-02-01',1500.00,'TRANSF','','','https://drive.google.com/file/d/10YK9aM5k6B9oNlEuFvPOZEVPumAVvAqc/view?usp=drivesdk','2025-10-17 08:21:28','1JDakdDlGB61ZA60YPeuoMJM3pVbRaMFD','https://drive.google.com/file/d/1JDakdDlGB61ZA60YPeuoMJM3pVbRaMFD/view?usp=drivesdk'),(13,64,'2025-03-01',1500.00,'TRANSF','','','https://drive.google.com/file/d/1JG6gtlLcN0_wT3Z7x-A6GSt-m4zjXlAV/view?usp=drivesdk','2025-10-17 08:24:44',NULL,NULL),(14,65,'2025-04-01',1500.00,'TRANSF','','','https://drive.google.com/file/d/1l2LwrIOt1Jok6HQ17tge3pUnJ8MvfYcw/view?usp=drivesdk','2025-10-17 08:25:03',NULL,NULL),(15,66,'2025-05-02',1500.00,'TRANSF','','','https://drive.google.com/file/d/14s4h31aA0_DeWtWWM4lNrH4u7Cyd9xUy/view?usp=drivesdk','2025-10-17 08:25:23',NULL,NULL),(16,67,'2025-06-02',1500.00,'TRANSF','','','https://drive.google.com/file/d/1IhdevgFsARiZhZ9z9tuc0KseYWFxAbAN/view?usp=drivesdk','2025-10-17 08:25:39',NULL,NULL),(17,68,'2025-07-01',1500.00,'TRANSF','','','https://drive.google.com/file/d/1doe6SUiWkFf3zGFs-t9EE3O5K6fnmXqz/view?usp=drivesdk','2025-10-17 08:25:55',NULL,NULL),(18,69,'2025-08-01',1500.00,'TRANSF','','','https://drive.google.com/file/d/1ddeJgFv20UqmYDATszthiyi8zwHhiUHo/view?usp=drivesdk','2025-10-17 08:26:19',NULL,NULL),(19,70,'2025-09-01',1500.00,'TRANSF','','','https://drive.google.com/file/d/1s73Z76tZ3TwWtzVoN0BGF53-CEKUcQv-/view?usp=drivesdk','2025-10-17 08:26:45',NULL,NULL),(20,71,'2025-10-01',1500.00,'TRANSF','','','https://drive.google.com/file/d/1SpLA5O5F7sTNWYW2t4vNGtIQ_1n5iRLi/view?usp=drivesdk','2025-10-17 08:27:02',NULL,NULL);

--
-- Table structure for table `papelera`
--

CREATE TABLE `papelera` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `empresa_id` int NOT NULL,
  `objeto_tipo` enum('contenedor','documento') NOT NULL,
  `objeto_id` bigint NOT NULL,
  `motivo` varchar(255) DEFAULT NULL,
  `eliminado_en` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `expira_en` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ix_pap_empresa` (`empresa_id`),
  KEY `ix_pap_obj` (`objeto_tipo`,`objeto_id`),
  CONSTRAINT `fk_pap_empresa` FOREIGN KEY (`empresa_id`) REFERENCES `empresas` (`empresa_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `papelera`
--


--
-- Table structure for table `plan`
--

CREATE TABLE `plan` (
  `plan_id` int NOT NULL AUTO_INCREMENT,
  `usuario_id` int DEFAULT NULL,
  `nombre` varchar(150) NOT NULL,
  `periodicidad` enum('MENSUAL','SEMESTRAL','ANUAL','CUSTOM') NOT NULL DEFAULT 'MENSUAL',
  `anio` smallint DEFAULT NULL,
  `mes` tinyint DEFAULT NULL,
  `activo` tinyint(1) NOT NULL DEFAULT '1',
  `creado_en` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`plan_id`),
  UNIQUE KEY `uq_plan_periodo` (`nombre`,`anio`,`mes`),
  KEY `idx_plan_usuario_periodo` (`usuario_id`,`anio`,`mes`),
  KEY `idx_plan_activo` (`activo`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `plan`
--

INSERT INTO `plan` VALUES (1,1,'Plan usuario 1 2025/11','MENSUAL',2025,11,1,'2025-11-04 02:10:38'),(2,21,'Plan usuario 21 2025/11','MENSUAL',2025,11,1,'2025-11-04 02:16:05'),(3,21,'Plan usuario 21 2025/12','MENSUAL',2025,12,1,'2025-11-04 02:56:39'),(4,9,'Plan usuario 9 2025/11','MENSUAL',2025,11,1,'2025-11-04 03:53:28'),(5,11,'Plan usuario 11 2025/11','MENSUAL',2025,11,1,'2025-11-04 14:30:48'),(6,12,'Plan usuario 12 2025/11','MENSUAL',2025,11,1,'2025-11-04 16:06:52'),(7,13,'Plan usuario 13 2025/11','MENSUAL',2025,11,1,'2025-11-10 11:38:21'),(8,16,'Plan usuario 16 2025/11','MENSUAL',2025,11,1,'2025-11-14 11:01:32'),(9,9,'Plan usuario 9 2025/12','MENSUAL',2025,12,1,'2025-12-07 17:51:26'),(10,29,'Plan usuario 29 2026/1','MENSUAL',2026,1,1,'2026-01-06 12:03:18');

--
-- Table structure for table `plan_cargo`
--

CREATE TABLE `plan_cargo` (
  `plan_id` int NOT NULL,
  `cargo_id` int NOT NULL,
  PRIMARY KEY (`plan_id`,`cargo_id`),
  KEY `fk_pc_cargo` (`cargo_id`),
  CONSTRAINT `fk_pc_cargo` FOREIGN KEY (`cargo_id`) REFERENCES `cargos` (`cargo_id`) ON DELETE RESTRICT ON UPDATE CASCADE,
  CONSTRAINT `fk_pc_plan` FOREIGN KEY (`plan_id`) REFERENCES `plan` (`plan_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `plan_cargo`
--


--
-- Table structure for table `plan_categoria`
--

CREATE TABLE `plan_categoria` (
  `categoria_id` int NOT NULL AUTO_INCREMENT,
  `plan_id` int NOT NULL,
  `nombre` varchar(200) NOT NULL,
  `orden` int NOT NULL DEFAULT '1',
  `creado_por` int DEFAULT NULL,
  `creado_en` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `activo` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`categoria_id`),
  UNIQUE KEY `uq_plan_cat_orden` (`plan_id`,`orden`),
  CONSTRAINT `fk_pcat_plan` FOREIGN KEY (`plan_id`) REFERENCES `plan` (`plan_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `plan_categoria`
--

INSERT INTO `plan_categoria` VALUES (1,1,'CALENDARIO',999,NULL,'2025-11-04 03:43:41',1),(2,2,'Fundamentos legales del cargo',999,NULL,'2025-11-04 03:43:41',1),(5,2,'Conceptos de Lavado de Activos y Financiamiento del Terrorismo (LA/FT)',1000,NULL,'2025-11-04 03:43:56',1),(6,5,'Marco legal básico y obligaciones frente a la SBS',1,NULL,'2025-11-04 14:31:39',1),(7,5,'Gobierno corporativo y roles dentro de la empresa',2,NULL,'2025-11-04 14:45:45',1),(8,5,'Gestión operativa y comercial en una casa de cambio virtual',3,NULL,'2025-11-04 14:46:19',1),(9,5,'Gestión del equipo y liderazgo',4,NULL,'2025-11-04 14:46:58',1),(10,5,'Relación con bancos y autoridade',5,NULL,'2025-11-04 14:47:40',1),(11,5,'Control de indicadores y supervisión de operaciones',6,NULL,'2025-11-04 14:48:16',1),(12,5,'Gestión de riesgos y seguridad virtual',7,NULL,'2025-11-04 14:48:49',1),(13,6,'Contables',1,NULL,'2025-11-04 16:07:09',1),(14,6,'Tributarias',2,NULL,'2025-11-04 16:07:15',1),(15,6,'Financieras',3,NULL,'2025-11-04 16:07:22',1),(16,6,'Administrativas y legales',4,NULL,'2025-11-04 16:07:28',1),(17,6,'Operativas / digitales',5,NULL,'2025-11-04 16:09:34',1),(18,6,'De control y apoyo a cumplimiento',6,NULL,'2025-11-04 16:09:38',1),(19,2,'Conocimiento del Cliente (KYC – Know Your Customer)',1001,NULL,'2025-11-05 10:42:29',1),(20,2,'Diseño e implementación del SPLAFT',1002,NULL,'2025-11-05 10:42:57',1),(21,2,'Monitoreo y detección de operaciones inusuales o sospechosas',1003,NULL,'2025-11-05 10:43:28',1),(22,2,'Reportes obligatorios ante la UIF y conservación de la información',1004,NULL,'2025-11-05 10:44:01',1),(23,2,'Capacitación interna y cultura de cumplimiento',1005,NULL,'2025-11-05 10:44:43',1),(24,2,'Fiscalización y coordinación con la SBS, UIF y SUNAT',1006,NULL,'2025-11-05 10:45:13',1),(25,1,'SBS',1000,NULL,'2025-11-14 11:30:28',1),(26,4,'CALENDARIO CONTABLE',1,NULL,'2025-11-25 11:33:38',1);

--
-- Table structure for table `plan_columna`
--

CREATE TABLE `plan_columna` (
  `col_id` int NOT NULL AUTO_INCREMENT,
  `plan_id` int NOT NULL,
  `nombre` varchar(120) NOT NULL,
  `tipo` enum('CHECK','NUMERO','TEXTO','FECHA','USUARIO','CHECKLIST') CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `orden` int NOT NULL DEFAULT '1',
  `ancho_px` smallint DEFAULT NULL,
  `activo` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`col_id`),
  UNIQUE KEY `uq_plan_col_orden` (`plan_id`,`orden`),
  CONSTRAINT `fk_pcol_plan` FOREIGN KEY (`plan_id`) REFERENCES `plan` (`plan_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `plan_columna`
--

INSERT INTO `plan_columna` VALUES (4,2,'QUIEN LO VA HACER','CHECKLIST',1,NULL,1),(5,2,'OBSERVACIONES','TEXTO',2,NULL,1),(6,2,'INICIO','FECHA',3,NULL,1),(7,2,'FIN','FECHA',4,NULL,1),(18,5,'QUIEN LO VA HACER','CHECKLIST',1,NULL,1),(19,5,'OBSERVACIONES','TEXTO',2,NULL,1),(20,5,'INICIO','FECHA',3,NULL,1),(21,5,'FIN','FECHA',4,NULL,1),(24,6,'INICIO','FECHA',3,NULL,1),(25,6,'FIN','FECHA',4,NULL,1),(26,1,'QUE SE VA HACER','CHECKLIST',1,NULL,1),(27,1,'QUIEN LO VA HACER','TEXTO',2,NULL,1),(28,1,'OBSERVACIONES','TEXTO',3,NULL,1),(30,1,'INICIO','FECHA',4,NULL,1),(31,1,'FIN','FECHA',5,NULL,1);

--
-- Table structure for table `plan_comentario`
--

CREATE TABLE `plan_comentario` (
  `id` int NOT NULL AUTO_INCREMENT,
  `item_id` int NOT NULL,
  `col_id` int NOT NULL,
  `texto` varchar(1000) NOT NULL,
  `creado_por` int DEFAULT NULL,
  `creado_en` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `fk_pcom_col` (`col_id`),
  KEY `fk_pcom_user` (`creado_por`),
  KEY `ix_item_col_fecha` (`item_id`,`col_id`,`creado_en`),
  CONSTRAINT `fk_pcom_col` FOREIGN KEY (`col_id`) REFERENCES `plan_columna` (`col_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `fk_pcom_item` FOREIGN KEY (`item_id`) REFERENCES `plan_item` (`item_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `fk_pcom_user` FOREIGN KEY (`creado_por`) REFERENCES `usuarios` (`id`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `plan_comentario`
--


--
-- Table structure for table `plan_item`
--

CREATE TABLE `plan_item` (
  `item_id` int NOT NULL AUTO_INCREMENT,
  `categoria_id` int NOT NULL,
  `parent_item_id` int DEFAULT NULL,
  `nombre` varchar(300) NOT NULL,
  `tipo` enum('CHECKLIST','TEXTO','NUMERO') NOT NULL DEFAULT 'CHECKLIST',
  `orden` int NOT NULL DEFAULT '1',
  `activo` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`item_id`),
  UNIQUE KEY `uq_cat_parent_orden` (`categoria_id`,(coalesce(`parent_item_id`,0)),`orden`),
  KEY `idx_plan_item_parent` (`parent_item_id`),
  KEY `idx_plan_item_categoria` (`categoria_id`),
  CONSTRAINT `fk_pitem_cat` FOREIGN KEY (`categoria_id`) REFERENCES `plan_categoria` (`categoria_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=111 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `plan_item`
--

INSERT INTO `plan_item` VALUES (9,5,NULL,'Qué es lavado de activos.','CHECKLIST',1,1),(10,5,NULL,'Qué es financiamiento del terrorismo','CHECKLIST',2,1),(11,5,NULL,'Etapas del LA: colocación, estratificación y reintegración.','CHECKLIST',3,1),(12,5,NULL,'Tipologías comunes en casas de cambio virtuales.','CHECKLIST',4,1),(13,2,NULL,'Ley Nº 27693 – UIF Perú.','CHECKLIST',1,1),(14,2,NULL,'Resolución SBS Nº 3274-2017.','CHECKLIST',2,1),(15,2,NULL,'Requisitos de idoneidad técnica y moral.','CHECKLIST',3,1),(16,2,NULL,'Funciones exclusivas del OC según norma.','CHECKLIST',4,1),(21,6,NULL,'Qué es una casa de cambio y su regulación','CHECKLIST',1,1),(22,6,NULL,'Qué es la Resolución SBS N.º 3274-2017.','CHECKLIST',2,1),(23,6,NULL,'Qué es el REPOF y por qué la empresa debe estar inscrita.','CHECKLIST',3,1),(24,6,NULL,'Qué leyes rigen el cumplimiento contra el lavado de activos y financiamiento del terrorismo (LA/FT).','CHECKLIST',4,1),(25,6,NULL,'Diferencias entre las funciones del Gerente General y el Oficial de Cumplimiento','CHECKLIST',5,1),(26,6,21,'Casa de Cambio','CHECKLIST',1,1),(27,6,21,'Regulacion','CHECKLIST',2,1),(28,7,NULL,'Qué es una Junta de Accionistas y qué decisiones toma.','CHECKLIST',1,1),(29,7,NULL,'Qué son los estatutos sociales y cómo se deben respetar.','CHECKLIST',2,1),(30,7,NULL,'Cuáles son sus facultades como representante legal inscrito en SUNARP.','CHECKLIST',3,1),(31,7,NULL,'Cuáles son sus límites (por ejemplo, no puede interferir en reportes a la UIF).','CHECKLIST',4,1),(32,8,NULL,'Cómo funciona la plataforma virtual: flujo de compra y venta de divisas.','CHECKLIST',1,1),(33,8,NULL,'Cómo se atiende a un cliente virtual: validación, cotización, transferencia, cierre.','CHECKLIST',2,1),(34,8,NULL,'Control del sistema interno (plataforma, CRM, cuentas bancarias, etc.).','CHECKLIST',3,1),(35,8,NULL,'Conocimiento general de los canales digitales: WhatsApp, correo, formularios, etc.','CHECKLIST',4,1),(36,9,NULL,'Habilidades para delegar funciones correctamente.','CHECKLIST',1,1),(37,9,NULL,'Capacidad para evaluar el rendimiento del equipo.','CHECKLIST',2,1),(38,9,NULL,'Conocimiento sobre contratos de trabajo, pagos, y normativas laborales básicas.','CHECKLIST',3,1),(39,9,NULL,'Resolución de conflictos y toma de decisiones rápidas.','CHECKLIST',4,1),(40,10,NULL,'Comunicarse con bancos comerciales (BBVA, BCP, Interbank, etc.).','CHECKLIST',1,1),(41,10,NULL,'Responder a fiscalizaciones o requerimientos de SUNAT, SBS o UIF.','CHECKLIST',2,1),(42,10,NULL,'Entender las condiciones para ser una empresa bank-friendly y evitar bloqueos.','CHECKLIST',3,1),(43,11,NULL,'Revisar reportes de operaciones diarias, cierres de caja, márgenes de ganancia.','CHECKLIST',1,1),(44,11,NULL,'Detectar irregularidades operativas o administrativas.','CHECKLIST',2,1),(45,11,NULL,'Pedir informes al área comercial, técnica, de atención al cliente y contabilidad.','CHECKLIST',3,1),(46,12,NULL,'Qué hacer si hay hackeos, estafas virtuales o intentos de suplantación.','CHECKLIST',1,1),(47,12,NULL,'Qué medidas de seguridad debe exigir (contraseñas, backups, doble verificación).','CHECKLIST',2,1),(48,12,NULL,'Cuándo reportar incidentes y cómo actuar en emergencias.','CHECKLIST',3,1),(49,6,22,'N° 3274-2017','CHECKLIST',1,1),(50,13,NULL,'Diseñar el plan contable para actividades cambiarias','CHECKLIST',1,1),(51,13,NULL,'Configurar libros contables obligatorios','CHECKLIST',2,1),(52,13,NULL,'Implementar el sistema contable (software) con los bancos, monedas y tipo de cambio','CHECKLIST',3,1),(53,13,NULL,'Establecer criterios de registro para márgenes de ganancia por operación','CHECKLIST',4,1),(54,14,NULL,'Verificar que el RUC esté correcto (CIIU 6612)','CHECKLIST',1,1),(55,14,NULL,'Asesorar sobre el régimen tributario más conveniente (Régimen General, MYPE)','CHECKLIST',2,1),(56,14,NULL,'Gestionar autorización para emitir facturas y boletas electrónicas','CHECKLIST',3,1),(57,14,NULL,'Configurar el PLE para libros electrónicos desde el inicio','CHECKLIST',4,1),(58,15,NULL,'Elaborar el flujo de caja inicial','CHECKLIST',1,1),(59,15,NULL,'Estimar costos fijos (personal, servidores, cuentas bancarias, etc.)','CHECKLIST',2,1),(60,15,NULL,'Calcular el punto de equilibrio del negocio','CHECKLIST',3,1),(61,15,NULL,'Definir márgenes operativos sostenibles','CHECKLIST',4,1),(62,16,NULL,'Apoyar al gerente en la validación de contratos, pagos y documentos','CHECKLIST',1,1),(63,16,NULL,'Participar en la redacción de políticas contables internas','CHECKLIST',2,1),(64,16,NULL,'Coordinar la formalización de proveedores y trabajadores','CHECKLIST',3,1),(65,17,NULL,'Entender cómo se registran las operaciones desde la plataforma virtual','CHECKLIST',1,1),(66,17,NULL,'Validar integridad de la data entre el sistema de cambio y el sistema contable','CHECKLIST',2,1),(67,17,NULL,'Proponer automatizaciones contables para evitar errores manuales','CHECKLIST',3,1),(68,18,NULL,'Proveer información financiera confiable al Oficial de Cumplimiento','CHECKLIST',1,1),(69,18,NULL,'Detectar incoherencias contables que puedan alertar sobre lavado de activos o evasión','CHECKLIST',2,1),(70,18,NULL,'Conservar soportes contables organizados ante posibles fiscalizaciones de la SBS o UIF','CHECKLIST',3,1),(71,2,NULL,'Deber de autonomía e independencia.','CHECKLIST',5,1),(72,19,NULL,'Proceso de identificación y verificación de clientes.','CHECKLIST',1,1),(73,19,NULL,'Cómo analizar el perfil transaccional esperado.','CHECKLIST',2,1),(74,19,NULL,'Qué documentos solicitar y cómo validarlos virtualmente.','CHECKLIST',3,1),(75,19,NULL,'Cómo identificar Personas Expuestas Políticamente (PEP).','CHECKLIST',4,1),(76,20,NULL,'Elaborar el Manual SPLAFT.','CHECKLIST',1,1),(77,20,NULL,'Aplicar políticas y procedimientos internos.','CHECKLIST',2,1),(78,20,NULL,'Diseñar matrices de riesgo.','CHECKLIST',3,1),(79,20,NULL,'Establecer métodos de monitoreo transaccional.','CHECKLIST',4,1),(80,21,NULL,'La diferencia entre operación inusual y sospechosa.','CHECKLIST',1,1),(81,21,NULL,'Cuándo investigar, documentar y reportar.','CHECKLIST',2,1),(82,21,NULL,'Cómo llenar el ROS (Reporte de Operación Sospechosa).','CHECKLIST',3,1),(83,21,NULL,'Cómo llevar el registro de alertas internas.','CHECKLIST',4,1),(84,22,NULL,'Cómo presentar el ROS.','CHECKLIST',1,1),(85,22,NULL,'Cómo llevar el registro de operaciones.','CHECKLIST',2,1),(86,22,NULL,'Plazos y formatos de conservación (mínimo 5 años).','CHECKLIST',3,1),(87,22,NULL,'Uso de sistemas tecnológicos para conservación digital segura.','CHECKLIST',4,1),(88,23,NULL,'Organizar y brindar capacitación básica a todo el equipo.','CHECKLIST',1,1),(89,23,NULL,'Fomentar la cultura del cumplimiento.','CHECKLIST',2,1),(90,23,NULL,'Ser un canal de consultas para otros trabajadores.','CHECKLIST',3,1),(91,24,NULL,'Atender requerimientos de información.','CHECKLIST',1,1),(92,24,NULL,'Coordinar con otras entidades de control.','CHECKLIST',2,1),(93,24,NULL,'Llevar documentación ordenada y actualizada.','CHECKLIST',3,1),(94,2,13,'QUE ES','CHECKLIST',1,1),(95,2,13,'DHDHDH','CHECKLIST',2,1),(96,13,50,'ssss','CHECKLIST',1,1),(97,1,NULL,'CORRECCIÓN DE ORTOGRAFIA','CHECKLIST',1000,1),(98,1,NULL,'REALIZAR UN CALENDARIO EDICIÓN DE LOS MESES','CHECKLIST',1001,1),(99,1,NULL,'EDICIÓN DE IMÁGENES','CHECKLIST',1002,1),(100,1,NULL,'EDICIÓN DE MARCA','CHECKLIST',1003,1),(101,1,NULL,'VERIFICAR NUMEROS TELEFONICOS','CHECKLIST',1004,1),(102,1,NULL,'DOMINIO','CHECKLIST',1005,1),(103,1,NULL,'TIPO DE PAPEL','CHECKLIST',1006,1),(104,1,NULL,'MEDIDAS DEL CALENDARIO','CHECKLIST',1007,1),(105,1,NULL,'CONTRATO','CHECKLIST',1008,1),(106,1,NULL,'PRECIO POR MILLAR MAS EL IGV','CHECKLIST',1009,1),(107,1,NULL,'DEFINIR FECHA DE IMPRESIÓN (OCTUBRE 2026)','CHECKLIST',1010,1),(108,1,NULL,'BUSCAR PROVEEDRES (GUARDAR UN CALENDARIO)','CHECKLIST',1011,1),(109,25,NULL,'HUMANI','CHECKLIST',1,1),(110,25,NULL,'INGREO Y SALIDA DE MISMO TITULAR​','CHECKLIST',2,1);

--
-- Table structure for table `plan_valor`
--

CREATE TABLE `plan_valor` (
  `valor_id` int NOT NULL AUTO_INCREMENT,
  `item_id` int NOT NULL,
  `col_id` int NOT NULL,
  `val_check` tinyint(1) DEFAULT NULL,
  `val_num` decimal(14,2) DEFAULT NULL,
  `val_txt` varchar(1000) DEFAULT NULL,
  `val_fecha` date DEFAULT NULL,
  `val_usuario_id` int DEFAULT NULL,
  `actualizado_en` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`valor_id`),
  UNIQUE KEY `uq_item_col` (`item_id`,`col_id`),
  KEY `fk_pval_col` (`col_id`),
  KEY `fk_pval_usuario` (`val_usuario_id`),
  CONSTRAINT `fk_pval_col` FOREIGN KEY (`col_id`) REFERENCES `plan_columna` (`col_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `fk_pval_item` FOREIGN KEY (`item_id`) REFERENCES `plan_item` (`item_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `fk_pval_usuario` FOREIGN KEY (`val_usuario_id`) REFERENCES `usuarios` (`id`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=152 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `plan_valor`
--

INSERT INTO `plan_valor` VALUES (70,21,18,0,NULL,NULL,NULL,NULL,'2025-11-04 16:24:27'),(73,26,18,0,NULL,NULL,NULL,NULL,'2025-11-04 16:19:46'),(84,49,18,1,NULL,NULL,NULL,NULL,'2025-11-04 16:58:18'),(86,23,18,0,NULL,NULL,NULL,NULL,'2025-11-04 16:24:37'),(94,13,4,0,NULL,NULL,NULL,NULL,'2025-11-05 11:08:18'),(102,106,26,NULL,NULL,'<ul>\n<li>1 MILLAR&nbsp; &nbsp; --&gt; 5000 SOLES</li>\n<li>2 MILLARES --&gt; 9500 SOLES</li>\n<li>3 MILLARES --&gt; 13000 SOLES</li>\n</ul>',NULL,NULL,'2025-11-14 12:41:30'),(103,104,26,NULL,NULL,'<ul>\n<li><strong>Parte frontal</strong> (donde va el calendario):\n<ul>\n<li>21 cm de ancho x 15 cm de alto</li>\n</ul>\n</li>\n<li data-start=\"&lt;/body\"><strong data-start=\"302\" data-end=\"311\">Base:</strong> ancho igual (21 cm) y <strong data-start=\"334\" data-end=\"355\">fondo de 9 cm</strong>.</li>\n</ul>',NULL,NULL,'2025-11-14 16:11:54'),(104,97,26,NULL,NULL,'<ul>\n<li>BREVE DESCRIPCION DE DIAS FEXTIVOS DE CADA MES</li>\n<li>LEMAS O FRASES</li>\n<li>NOMBRE DE LOS MESES DEL A&Ntilde;O</li>\n</ul>',NULL,NULL,'2025-11-14 11:32:43'),(110,103,26,NULL,NULL,'<ul>\n<li>Papel para las hojas del calendario\n<ul>\n<li>Hojas Interiores\n<ul>\n<li>Gramaje: Wire-O blanco</li>\n<li>Impreso en couch&eacute; mate 200 g, full color, con barniz de protecci&oacute;n</li>\n</ul>\n</li>\n<li>Material para la tapa dura y la base (tri&aacute;ngulo)\n<ul>\n<li>Cart&oacute;n gris de 1.75 mm forrado con couch&eacute; 200 g impreso a color laca Mate</li>\n</ul>\n</li>\n</ul>\n</li>\n</ul>',NULL,NULL,'2025-11-14 12:54:26'),(111,102,26,NULL,NULL,'<ul>\n<li>BDIVSAS.COM</li>\n<li>NUEVO DOMINIO:&nbsp; MARCA NUEVA ?????</li>\n</ul>',NULL,NULL,'2025-11-14 11:35:03'),(112,101,26,NULL,NULL,'<ul>\n<li>999 49 2526</li>\n<li>999 49 2324</li>\n</ul>',NULL,NULL,'2025-11-14 11:29:08'),(114,98,26,NULL,NULL,'<ul>\n<li>MODIFICAR LA ENUMERACION DE LOS MESES</li>\n<li>MODIFICAR Y REVISAR LOS DIAS FESTIVOS (FERIADOS)</li>\n</ul>',NULL,NULL,'2025-11-14 11:33:28'),(115,99,26,NULL,NULL,'<ul>\n<li>ANVERSO:&nbsp; LUGARES TURISTICOS DE CADA PAIS&nbsp;</li>\n<li>INVERSO: COTENIDO DIGITAL, REALIZANDO CAMBIO O COTIZACION EN DISPOSITIVOS MOVILES</li>\n</ul>',NULL,NULL,'2025-11-14 11:34:28'),(116,100,26,NULL,NULL,'<ul>\n<li>BUSINESS DIVISAS</li>\n<li>GRUPO BISNES</li>\n</ul>',NULL,NULL,'2025-11-14 11:34:41'),(119,97,27,NULL,NULL,'<ul>\n<li>PUBLICIDAD (AREA)</li>\n</ul>',NULL,NULL,'2025-11-14 11:35:45'),(120,98,27,NULL,NULL,'<ul>\n<li>PUBLICIDAD (AREA)</li>\n</ul>',NULL,NULL,'2025-11-14 11:35:48'),(121,99,27,NULL,NULL,'<ul>\n<li>PUBLICIDAD (AREA)</li>\n</ul>',NULL,NULL,'2025-11-14 11:35:52'),(122,100,27,NULL,NULL,'<ul>\n<li>PUBLICIDAD (AREA)</li>\n</ul>',NULL,NULL,'2025-11-14 11:35:56'),(123,101,27,NULL,NULL,'<ul>\n<li>PUBLICIDAD (AREA)</li>\n</ul>',NULL,NULL,'2025-11-14 11:35:59'),(124,102,27,NULL,NULL,'<ul>\n<li>PUBLICIDAD (AREA)</li>\n</ul>',NULL,NULL,'2025-11-14 11:36:02'),(125,103,27,NULL,NULL,'<ul>\n<li>PUBLICIDAD (AREA)</li>\n</ul>',NULL,NULL,'2025-11-14 11:36:10'),(128,107,26,NULL,NULL,'<ul>\n<li>2025\n<ul>\n<li>FECHA DE IMPRESION: 13/11/2025</li>\n</ul>\n</li>\n<li>2026\n<ul>\n<li>FEHCA DE IMPRESION: 03/11/2025</li>\n</ul>\n</li>\n</ul>',NULL,NULL,'2025-11-14 12:40:09'),(132,108,26,NULL,NULL,'<ul>\n<li>Guardar siempre un calendario</li>\n</ul>',NULL,NULL,'2025-11-14 12:57:26'),(133,105,26,NULL,NULL,'<ul>\n<li>&nbsp;</li>\n</ul>',NULL,NULL,'2025-11-14 12:40:24'),(147,104,27,NULL,NULL,'<ul>\n<li>PUBLICIDAD (AREA)</li>\n</ul>',NULL,NULL,'2025-11-14 12:57:38'),(148,107,27,NULL,NULL,'<ul>\n<li>PUBLICIDAD (AREA)</li>\n</ul>',NULL,NULL,'2025-11-14 12:57:47'),(149,108,27,NULL,NULL,'<ul>\n<li>PUBLICIDAD (AREA)</li>\n</ul>',NULL,NULL,'2025-11-14 12:57:52');

--
-- Table structure for table `planilla_archivos`
--

CREATE TABLE `planilla_archivos` (
  `id` int NOT NULL AUTO_INCREMENT,
  `proceso_id` int NOT NULL,
  `tipo` varchar(30) NOT NULL,
  `nombre_archivo` varchar(200) NOT NULL,
  `ruta_publica` varchar(255) NOT NULL,
  `creado_por` int DEFAULT NULL,
  `creado_en` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `proceso_id` (`proceso_id`),
  CONSTRAINT `fk_pa_proceso` FOREIGN KEY (`proceso_id`) REFERENCES `planilla_proceso` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `planilla_archivos`
--


--
-- Table structure for table `planilla_cierre`
--

CREATE TABLE `planilla_cierre` (
  `id_cierre` bigint unsigned NOT NULL AUTO_INCREMENT,
  `empresa_id` int NOT NULL,
  `id_trabajador` int NOT NULL,
  `periodo` char(7) NOT NULL,
  `sueldo_base` decimal(10,2) NOT NULL DEFAULT '0.00',
  `total_ingresos` decimal(10,2) NOT NULL DEFAULT '0.00',
  `total_descuentos` decimal(10,2) NOT NULL DEFAULT '0.00',
  `neto` decimal(10,2) NOT NULL DEFAULT '0.00',
  `estado` enum('ABIERTA','CERRADA') NOT NULL DEFAULT 'CERRADA',
  `generado_en` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `generado_por` int DEFAULT NULL,
  PRIMARY KEY (`id_cierre`),
  UNIQUE KEY `uq_planilla` (`empresa_id`,`id_trabajador`,`periodo`),
  KEY `idx_periodo` (`periodo`),
  KEY `idx_trabajador` (`id_trabajador`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `planilla_cierre`
--


--
-- Table structure for table `planilla_cierre_detalle`
--

CREATE TABLE `planilla_cierre_detalle` (
  `id_detalle` bigint unsigned NOT NULL AUTO_INCREMENT,
  `id_cierre` bigint unsigned NOT NULL,
  `id_concepto` int NOT NULL,
  `tipo` enum('INGRESO','DESCUENTO') NOT NULL,
  `concepto` varchar(150) NOT NULL,
  `monto` decimal(10,2) NOT NULL DEFAULT '0.00',
  PRIMARY KEY (`id_detalle`),
  KEY `idx_cierre` (`id_cierre`),
  CONSTRAINT `fk_planilla_detalle_cierre` FOREIGN KEY (`id_cierre`) REFERENCES `planilla_cierre` (`id_cierre`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `planilla_cierre_detalle`
--


--
-- Table structure for table `planilla_detalle`
--

CREATE TABLE `planilla_detalle` (
  `id` int NOT NULL AUTO_INCREMENT,
  `proceso_id` int NOT NULL,
  `trabajador_id` int NOT NULL,
  `sueldo_base` decimal(12,2) NOT NULL DEFAULT '0.00',
  `total_ingresos` decimal(12,2) NOT NULL DEFAULT '0.00',
  `total_descuentos` decimal(12,2) NOT NULL DEFAULT '0.00',
  `neto` decimal(12,2) NOT NULL DEFAULT '0.00',
  `creado_en` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `actualizado_en` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  `total_empleador` decimal(12,2) NOT NULL DEFAULT '0.00',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_proceso_trab` (`proceso_id`,`trabajador_id`),
  KEY `idx_proceso` (`proceso_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `planilla_detalle`
--


--
-- Table structure for table `planilla_detalle_conceptos`
--

CREATE TABLE `planilla_detalle_conceptos` (
  `id` int NOT NULL AUTO_INCREMENT,
  `detalle_id` int NOT NULL,
  `concepto_id` int NOT NULL,
  `monto` decimal(12,2) NOT NULL DEFAULT '0.00',
  `origen` enum('MANUAL','AUTO') NOT NULL DEFAULT 'MANUAL',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_det_con` (`detalle_id`,`concepto_id`),
  KEY `idx_detalle` (`detalle_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `planilla_detalle_conceptos`
--


--
-- Table structure for table `planilla_export_files`
--

CREATE TABLE `planilla_export_files` (
  `id` int NOT NULL AUTO_INCREMENT,
  `proceso_id` int NOT NULL,
  `tipo` varchar(30) NOT NULL,
  `file_name` varchar(255) NOT NULL,
  `file_path` varchar(500) NOT NULL,
  `creado_por` int NOT NULL,
  `creado_en` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `idx_proc` (`proceso_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `planilla_export_files`
--


--
-- Table structure for table `planilla_mensual`
--

CREATE TABLE `planilla_mensual` (
  `id_planilla` int NOT NULL AUTO_INCREMENT,
  `anio` int NOT NULL,
  `mes` tinyint NOT NULL,
  `estado` enum('ABIERTO','CERRADO') DEFAULT 'ABIERTO',
  `fecha_cierre` date DEFAULT NULL,
  `observacion` text,
  PRIMARY KEY (`id_planilla`),
  UNIQUE KEY `uq_planilla_mes` (`anio`,`mes`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `planilla_mensual`
--


--
-- Table structure for table `planilla_parametros`
--

CREATE TABLE `planilla_parametros` (
  `id` int NOT NULL AUTO_INCREMENT,
  `vigencia_desde` date NOT NULL,
  `vigencia_hasta` date DEFAULT NULL,
  `uit` decimal(10,2) NOT NULL DEFAULT '0.00',
  `essalud_pct` decimal(6,4) NOT NULL DEFAULT '0.0900',
  `onp_pct` decimal(6,4) NOT NULL DEFAULT '0.1300',
  `essalud_registra_empleador` tinyint(1) NOT NULL DEFAULT '1',
  `essalud_descuenta_trab` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp 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 `planilla_parametros`
--


--
-- Table structure for table `planilla_proceso`
--

CREATE TABLE `planilla_proceso` (
  `id` int NOT NULL AUTO_INCREMENT,
  `empresa_id` int NOT NULL,
  `periodo` char(7) NOT NULL,
  `fecha_pago` date DEFAULT NULL,
  `estado` enum('INICIADO','REVISION','PAGADO') NOT NULL DEFAULT 'INICIADO',
  `creado_en` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `actualizado_en` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  `cerrado` tinyint(1) NOT NULL DEFAULT '0',
  `fecha_cierre` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_empresa_periodo` (`empresa_id`,`periodo`),
  KEY `idx_estado` (`estado`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `planilla_proceso`
--


--
-- Table structure for table `presupuesto_categoria`
--

CREATE TABLE `presupuesto_categoria` (
  `categoria_id` int NOT NULL AUTO_INCREMENT,
  `nombre` varchar(120) NOT NULL,
  `orden` int NOT NULL DEFAULT '1',
  `tipo` enum('I','E') NOT NULL DEFAULT 'I',
  `activo` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`categoria_id`),
  UNIQUE KEY `uk_pres_cat_nombre` (`nombre`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `presupuesto_categoria`
--

INSERT INTO `presupuesto_categoria` VALUES (1,'1RA CATEGORÍA',1,'I',1),(2,'2DA CATEGORÍA',2,'I',1),(3,'3RA CATEGORÍA',3,'I',1),(4,'4TA CATEGORÍA',4,'I',1),(5,'5TA CATEGORIA',999,'I',1),(6,'PRESTAMOS',999,'E',1),(7,'AUTO',999,'E',1),(8,'TARJETAS DE CREDITO',999,'E',1),(10,'TELEFONO',999,'E',1),(11,'DEPARTAMENTO',999,'E',1),(12,'COMPRAS 3RA CATEGORIA',999,'E',1),(14,'COMPRA INMUEBLE',999,'E',1),(15,'MUNICIPALIDAD',999,'E',1),(16,'SERVICIOS',999,'E',1);

--
-- Table structure for table `presupuesto_item`
--

CREATE TABLE `presupuesto_item` (
  `item_id` int NOT NULL AUTO_INCREMENT,
  `categoria_id` int NOT NULL,
  `nombre` varchar(160) NOT NULL,
  `orden` int NOT NULL DEFAULT '1',
  `activo` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`item_id`),
  KEY `fk_pi_cat` (`categoria_id`),
  CONSTRAINT `fk_pi_cat` FOREIGN KEY (`categoria_id`) REFERENCES `presupuesto_categoria` (`categoria_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=44 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `presupuesto_item`
--

INSERT INTO `presupuesto_item` VALUES (1,1,'1ER PISO BREÑA',1,1),(2,1,'2DO PISO BREÑA',2,1),(3,1,'1ER PISO SJM',3,1),(4,1,'2DO PISO SJM',4,1),(7,1,'3ER PISO SJM',999,1),(8,1,'4TO PISO SJM',999,1),(9,1,'5TO A SJM',999,1),(10,1,'5TO B SJM',999,1),(11,1,'5TO C SJM',999,1),(12,1,'AUTO A1K-049',999,1),(13,1,'AUTO CTB-590',999,1),(14,2,'MARCA BUSINESS DIVISAS',999,1),(15,2,'MARCA 3TMI',999,1),(16,2,'MARCA BOLSA',999,1),(17,2,'MARCA KAIVARA',999,1),(18,2,'CUOTA PRESTAMOS',999,1),(19,3,'VENTAS',999,1),(20,4,'RECIBO POR HONORARIO',999,1),(21,5,'PLANILLA',999,1),(22,6,'PRESTAMO PICHINCHA',999,1),(23,6,'PRESTAMO BANBIF',999,1),(24,6,'PRESTAMO SCOTIABANK',999,1),(25,6,'PRESTAMO INTERBANK',999,1),(26,6,'PRESTAMO SRA YESSICA',999,1),(27,7,'CUOTAS DEL AUTO',999,1),(28,8,'BANBIF',999,1),(29,8,'BBVA',999,1),(30,8,'IMPUESTOS',999,1),(31,10,'924545452',999,1),(32,11,'FLOR DPTO 212',999,1),(33,11,'SRA AKI DPTO 304',999,1),(34,12,'COMPRAS PDT',999,1),(35,14,'BREÑA',999,1),(36,15,'ARBITRIOS SJM',999,1),(37,15,'PREDIAL SJM',999,1),(38,16,'AGUA SJM',999,1),(39,16,'1ER PISO SJM',999,1),(40,16,'2DO PISO SJM',999,1),(41,16,'3ER PISO SJM',999,1),(42,16,'4TO PISO SJM',999,1);

--
-- Table structure for table `presupuesto_monto`
--

CREATE TABLE `presupuesto_monto` (
  `item_id` int NOT NULL,
  `anio` int NOT NULL,
  `mes` tinyint unsigned NOT NULL COMMENT '1–12 = meses reales, 13 = columna adicional/vouchers',
  `monto` decimal(14,2) NOT NULL DEFAULT '0.00',
  PRIMARY KEY (`item_id`,`anio`,`mes`),
  CONSTRAINT `fk_pm_item` FOREIGN KEY (`item_id`) REFERENCES `presupuesto_item` (`item_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `presupuesto_monto`
--

INSERT INTO `presupuesto_monto` VALUES (1,2025,1,0.00),(1,2025,6,15000.00),(1,2025,7,15000.00),(1,2025,8,15000.00),(1,2025,9,15000.00),(1,2025,10,15000.00),(1,2025,11,15000.00),(1,2025,12,0.00),(1,2025,13,0.00),(2,2025,1,0.00),(2,2025,2,0.00),(2,2025,6,10000.00),(2,2025,7,10000.00),(2,2025,8,10000.00),(2,2025,9,10000.00),(2,2025,10,10000.00),(2,2025,11,10000.00),(2,2025,12,0.00),(2,2025,13,0.00),(3,2025,1,10000.00),(3,2025,2,0.00),(3,2025,5,10000.00),(3,2025,6,0.00),(3,2025,7,950.00),(3,2025,8,950.00),(3,2025,9,950.00),(3,2025,10,950.00),(3,2025,11,950.00),(3,2025,12,0.00),(4,2025,1,0.00),(4,2025,4,0.00),(4,2025,5,6000.00),(4,2025,10,0.00),(7,2025,1,6000.00),(7,2025,5,0.00),(8,2025,1,0.00),(9,2025,1,350.00),(10,2025,1,350.00),(11,2025,1,3000.00),(11,2025,5,3000.00),(11,2025,6,3000.00),(11,2025,7,3000.00),(11,2025,8,3000.00),(11,2025,9,3000.00),(11,2025,10,3000.00),(11,2025,11,3000.00),(12,2025,1,2000.00),(12,2025,5,2000.00),(12,2025,6,2000.00),(12,2025,7,2000.00),(12,2025,8,2000.00),(12,2025,9,2000.00),(12,2025,10,2000.00),(12,2025,11,2000.00),(13,2025,6,4000.00),(13,2025,7,4000.00),(13,2025,8,4000.00),(13,2025,9,4000.00),(13,2025,10,4000.00),(13,2025,11,4000.00),(14,2025,1,2000.00),(14,2025,5,2000.00),(14,2025,6,2000.00),(14,2025,7,2000.00),(14,2025,8,2000.00),(14,2025,9,2000.00),(14,2025,10,2000.00),(14,2025,11,2000.00),(15,2025,1,1000.00),(15,2025,5,1000.00),(15,2025,6,1000.00),(15,2025,7,1000.00),(15,2025,8,1000.00),(15,2025,9,1000.00),(15,2025,10,1000.00),(15,2025,11,1000.00),(16,2025,1,1000.00),(16,2025,5,1000.00),(16,2025,6,1000.00),(16,2025,7,1000.00),(16,2025,8,1000.00),(16,2025,9,1000.00),(16,2025,10,1000.00),(16,2025,11,1000.00),(17,2025,1,1000.00),(17,2025,5,1000.00),(17,2025,6,1000.00),(17,2025,7,1000.00),(17,2025,8,1000.00),(17,2025,9,1000.00),(17,2025,10,1000.00),(17,2025,11,10000.00),(18,2025,1,13859.76),(18,2025,5,13869.48),(18,2025,6,13871.17),(18,2025,7,13876.26),(18,2025,8,13876.67),(18,2025,9,13881.81),(18,2025,10,13886.87),(18,2025,11,13881.31),(21,2025,5,3400.00),(21,2025,6,3400.00),(21,2025,7,3400.00),(21,2025,8,3400.00),(21,2025,9,3400.00),(21,2025,10,3400.00),(21,2025,11,3400.00),(22,2025,1,1300.02),(22,2025,2,0.00),(22,2025,5,1300.02),(22,2025,6,1300.02),(22,2025,7,1300.02),(22,2025,8,1300.02),(22,2025,9,1300.02),(22,2025,10,1300.02),(23,2025,1,2008.40),(23,2025,2,0.00),(23,2025,5,2008.40),(23,2025,6,2008.40),(23,2025,7,2008.40),(23,2025,8,2008.40),(23,2025,9,2008.40),(23,2025,10,2008.40),(24,2025,1,1603.25),(24,2025,5,1603.25),(24,2025,6,1603.25),(24,2025,7,1603.25),(24,2025,8,1603.25),(24,2025,9,1603.25),(24,2025,10,1603.25),(25,2025,1,1771.44),(25,2025,2,0.00),(25,2025,5,1771.44),(25,2025,6,1771.44),(25,2025,7,1771.44),(25,2025,8,1771.44),(25,2025,9,1771.44),(25,2025,10,1771.44),(26,2025,5,2000.00),(26,2025,6,2000.00),(26,2025,7,2000.00),(26,2025,8,2000.00),(26,2025,9,2000.00),(26,2025,10,2000.00),(27,2025,5,1621.58),(27,2025,6,1621.58),(27,2025,7,1621.58),(27,2025,8,1621.58),(27,2025,9,1621.58),(27,2025,10,1621.58),(28,2025,1,1860.00),(28,2025,5,0.00),(28,2025,6,840.00),(28,2025,7,2490.00),(28,2025,8,1515.00),(28,2025,9,1780.00),(28,2025,10,2055.00),(28,2025,11,0.00),(29,2025,1,3420.00),(29,2025,5,1610.00),(29,2025,6,1090.00),(29,2025,7,1910.00),(29,2025,8,4535.00),(29,2025,9,520.00),(29,2025,10,1965.00),(29,2025,11,0.00),(30,2025,1,1336.00),(30,2025,3,0.00),(30,2025,5,1350.00),(30,2025,6,1350.00),(30,2025,7,2271.00),(30,2025,8,2271.00),(30,2025,9,2271.00),(30,2025,10,2271.00),(31,2025,1,45.90),(31,2025,2,0.00),(31,2025,5,45.90),(31,2025,6,45.90),(31,2025,7,44.90),(31,2025,8,44.90),(31,2025,9,52.32),(31,2025,10,45.38),(31,2025,11,0.00),(32,2025,1,1400.00),(32,2025,2,0.00),(32,2025,5,1400.00),(32,2025,6,1400.00),(32,2025,7,1400.00),(32,2025,8,1400.00),(32,2025,9,1400.00),(32,2025,10,1400.00),(33,2025,1,2250.00),(33,2025,2,0.00),(33,2025,5,2250.00),(33,2025,6,2250.00),(33,2025,7,2250.00),(33,2025,8,2250.00),(33,2025,9,2250.00),(33,2025,10,2250.00),(34,2025,5,60955.00),(34,2025,6,2914.00),(34,2025,7,1828.00),(34,2025,8,2281.00),(34,2025,9,825.00),(38,2025,1,96.60),(38,2025,2,0.00),(38,2025,5,52.00),(38,2025,6,34.20),(38,2025,7,31.20),(38,2025,8,66.80),(38,2025,9,37.20),(38,2025,10,31.20),(38,2025,11,0.00),(39,2025,1,7.20),(39,2025,2,0.00),(39,2025,5,7.20),(39,2025,6,7.20),(39,2025,7,21.90),(39,2025,8,32.80),(39,2025,9,40.60),(39,2025,10,45.80),(39,2025,11,0.00),(40,2025,1,43.70),(40,2025,2,0.00),(40,2025,5,48.50),(40,2025,6,48.20),(40,2025,7,55.30),(40,2025,8,48.60),(40,2025,9,43.90),(40,2025,10,42.90),(40,2025,11,0.00),(41,2025,1,5.20),(41,2025,2,0.00),(41,2025,5,5.30),(41,2025,6,5.20),(41,2025,7,5.30),(41,2025,8,5.30),(41,2025,9,5.20),(41,2025,10,5.30),(41,2025,11,0.00),(42,2025,1,82.20),(42,2025,2,0.00),(42,2025,5,8.90),(42,2025,6,6.80),(42,2025,7,6.80),(42,2025,8,8.60),(42,2025,9,8.80),(42,2025,10,6.90);

--
-- Table structure for table `producto`
--

CREATE TABLE `producto` (
  `producto_id` int NOT NULL AUTO_INCREMENT,
  `nombre` varchar(120) NOT NULL,
  `unidad_base` varchar(20) NOT NULL DEFAULT 'unid',
  `presentacion` varchar(30) DEFAULT NULL,
  `factor_presentacion` decimal(12,3) NOT NULL DEFAULT '1.000',
  `estado` enum('ACTIVO','INACTIVO') NOT NULL DEFAULT 'ACTIVO',
  `creado_en` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `costo_unit` decimal(12,2) NOT NULL DEFAULT '0.00',
  `venta_unit` decimal(12,2) NOT NULL DEFAULT '0.00',
  `igv_pct` decimal(5,4) NOT NULL DEFAULT '0.1800',
  `orden` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`producto_id`),
  UNIQUE KEY `uk_producto_nombre` (`nombre`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `producto`
--

INSERT INTO `producto` VALUES (1,'Papel higiénico jumbo 550 m','metro','',1.000,'ACTIVO','2025-10-21 15:21:12',0.00,50.85,0.1800,18),(2,'Dispensador master para papel','unid','',1.000,'ACTIVO','2025-10-21 15:21:12',0.00,38.14,0.1800,6),(3,'Dispensador de jabón (pared)','unid','',1.000,'ACTIVO','2025-10-21 15:21:12',0.00,38.14,0.1800,4),(4,'Alcohol gel (galón)','lt','',1.000,'ACTIVO','2025-10-21 15:21:12',45.00,27.12,0.1800,5),(5,'Trapeador microfibra','unid','',1.000,'ACTIVO','2025-10-21 15:21:12',0.00,3.81,0.1800,23),(6,'Detergente en polvo saco 15 kg','kg','',1.000,'ACTIVO','2025-10-21 15:21:12',0.00,60.00,0.1800,1),(7,'Gatillo cloro (limpieza suelos)','unid','',1.000,'ACTIVO','2025-10-21 15:21:12',0.00,10.17,0.1800,10),(8,'Gatillo aroma para ropa','unid','',1.000,'ACTIVO','2025-10-21 15:21:12',0.00,22.88,0.1800,9),(9,'Jabón líquido (galón) Elite','lt','',1.000,'ACTIVO','2025-10-21 15:21:12',0.00,38.14,0.1800,12),(10,'Sal de baño 1 kg','kg','',1.000,'ACTIVO','2025-10-21 15:21:12',0.00,4.24,0.1800,21),(11,'Toallitas/palitos húmedos','unid','',1.000,'ACTIVO','2025-10-21 15:21:12',0.00,5.93,0.1800,22),(12,'CIF crema','lt','',1.000,'ACTIVO','2025-10-21 15:21:12',0.00,12.71,0.1800,3),(13,'Esponja de colores con alambre','unid','',1.000,'ACTIVO','2025-10-21 15:21:12',0.00,1.27,0.1800,8),(14,'Maquinita (limpieza/accesorio)','unid','',1.000,'ACTIVO','2025-10-21 15:21:12',0.00,2.97,0.1800,15),(15,'Lavavajilla LAVA (líquido 1 L)','lt','',1.000,'ACTIVO','2025-10-21 15:21:12',0.00,5.93,0.1800,13),(16,'Limpia todo (galón)','lt','',1.000,'ACTIVO','2025-10-21 15:21:12',0.00,8.47,0.1800,14),(17,'Quitamanchas (galón)','lt','',1.000,'ACTIVO','2025-10-21 15:21:12',0.00,16.95,0.1800,20),(18,'Aroma spray vainilla','unid','',1.000,'ACTIVO','2025-10-21 15:21:12',0.00,5.08,0.1800,2),(19,'Pastilla azul para baño','unid','',1.000,'ACTIVO','2025-10-21 15:21:12',0.00,3.39,0.1800,19),(20,'Paño amarillo Virutex x20','unid','',1.000,'ACTIVO','2025-10-21 15:21:12',0.00,13.56,0.1800,16),(21,'Paño/toalla nevado blanco','unid','',1.000,'ACTIVO','2025-10-21 15:21:12',0.00,38.14,0.1800,17),(22,'Colgador de ropa','unid','',1.000,'ACTIVO','2025-10-21 15:21:12',0.00,12.71,0.1800,7),(23,'Jabón de tocador','unid','',1.000,'ACTIVO','2025-10-21 15:21:12',0.00,2.12,0.1800,11);

--
-- Table structure for table `producto_stock`
--

CREATE TABLE `producto_stock` (
  `producto_id` int NOT NULL,
  `sede_id` int NOT NULL,
  `stock` decimal(12,3) NOT NULL DEFAULT '0.000',
  PRIMARY KEY (`producto_id`,`sede_id`),
  KEY `fk_ps_sede` (`sede_id`),
  CONSTRAINT `fk_ps_producto` FOREIGN KEY (`producto_id`) REFERENCES `producto` (`producto_id`) ON DELETE RESTRICT ON UPDATE CASCADE,
  CONSTRAINT `fk_ps_sede` FOREIGN KEY (`sede_id`) REFERENCES `sedes` (`sede_id`) ON DELETE RESTRICT ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `producto_stock`
--

INSERT INTO `producto_stock` VALUES (3,2,1.000),(4,3,1.000),(6,3,1.000),(6,5,2.000),(18,1,1.000),(22,1,2.000),(22,3,0.000);
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER `trg_no_stock_negativo` AFTER UPDATE ON `producto_stock` FOR EACH ROW BEGIN
  IF NEW.stock < 0 THEN
    SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'Stock negativo no permitido';
  END IF;
END */;;
DELIMITER ;

--
-- Table structure for table `propiedades`
--

CREATE TABLE `propiedades` (
  `id` int NOT NULL AUTO_INCREMENT,
  `nombre` varchar(120) NOT NULL,
  `direccion` varchar(200) NOT NULL,
  `distrito` varchar(80) DEFAULT NULL,
  `provincia` varchar(80) DEFAULT NULL,
  `referencia` varchar(200) 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`),
  UNIQUE KEY `uk_prop_dir` (`direccion`,`distrito`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `propiedades`
--

INSERT INTO `propiedades` VALUES (13,'Local Comercial','Jr. Mariscal Luzuriaga 315','Jesús María','Lima','Local comercial',1,'2025-10-11 16:45:18','2025-10-17 11:46:34'),(14,'Dpto Arnaldo Márquez','Av. Arnaldo Márquez 1372','Jesús María','Lima','',1,'2025-10-11 16:45:18','2025-10-15 10:51:26'),(15,'SJM','Calle Las Palmeras Mz W Lt 6A','San Juan de Miraflores','Lima','Torres',1,'2025-10-11 16:45:18','2025-10-15 23:20:36'),(16,'Casa/Local Breña','Jr. Castrovirreyna 287','Breña','Lima','Casa funcionando como local',1,'2025-10-11 16:45:18','2025-10-11 16:45:18'),(17,'Dpto Loreto','Jr. Loreto 1612','Breña','Lima',NULL,1,'2025-10-11 16:45:18','2025-10-11 16:45:18');

--
-- Table structure for table `publicidad_archivos`
--

CREATE TABLE `publicidad_archivos` (
  `id` int NOT NULL AUTO_INCREMENT,
  `usuario_id` int NOT NULL,
  `anio` int NOT NULL,
  `bucket` varchar(50) NOT NULL,
  `temporada` varchar(100) NOT NULL DEFAULT '',
  `dispositivo` varchar(100) NOT NULL DEFAULT '',
  `tipo` varchar(50) NOT NULL DEFAULT '',
  `archivo` varchar(255) NOT NULL DEFAULT '',
  `nombre` varchar(255) NOT NULL,
  `mime` varchar(255) NOT NULL,
  `size` bigint NOT NULL,
  `drive_file_id` varchar(255) DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uniq_pub_arch` (`usuario_id`,`anio`,`bucket`,`nombre`)
) ENGINE=InnoDB AUTO_INCREMENT=127 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `publicidad_archivos`
--

INSERT INTO `publicidad_archivos` VALUES (13,1,2025,'archivos','Navidad-2025-2','Redes Sociales','video','Navidad1 (1).mp4','Navidad1 (1).mp4','video/mp4',9092084,'1V1xdVgDIN2HQVfvTz7-MKHMw-4nvIyFe','2025-12-04 06:14:44','2025-12-04 06:16:16'),(17,1,2025,'archivos','Navidad-2025-1','Redes Sociales','video','navidad2 (1).mp4','navidad2 (1).mp4','video/mp4',4832761,'17ZQAS-lWJe5tHVDaFmJpAnUtLyyyCcqP','2025-12-04 06:15:03','2025-12-04 06:16:13'),(26,1,2025,'archivos','Navidad-2025-3','Redes Sociales','video','navidad 3 (1).mp4','navidad 3 (1).mp4','video/mp4',5011653,'191xxn_vgBiuR6bPPVDyi-811_0WZB4La','2025-12-04 06:16:31','2025-12-04 06:16:51'),(34,1,2025,'archivos','Navidad-Dia-1','Redes Sociales','video','Naviadad-1 (1).mp4','Naviadad-1 (1).mp4','video/mp4',16840679,'13_oylpa1CLPqwqbP7SMX4oYe-72WZKtL','2025-12-04 06:19:56','2025-12-04 06:20:12'),(39,1,2025,'archivos','Navidad-Dia-2','Redes Sociales','video','Naviadad-2.mp4','Naviadad-2.mp4','video/mp4',11319480,'1gbwph7o7IObkIyZT0kFawQJZZ8vi7KCB','2025-12-04 06:20:28','2025-12-04 06:21:01'),(44,1,2025,'archivos','Navidad-Dia-3','Redes Sociales','video','Naviadad-3.mp4','Naviadad-3.mp4','video/mp4',9538974,'16jaTf50wbXs9cATTLjDOaea_GfLGY16Y','2025-12-04 06:21:15','2025-12-04 06:23:11'),(51,1,2025,'archivos','Año-Nuevo-1','Redes Sociales','video','Año nuevo-1.mp4','Año nuevo-1.mp4','video/mp4',9778314,'1hJse3WJpMCXGvR0NfIgPaf8VYLOsnFDe','2025-12-04 06:22:00','2025-12-04 06:22:53'),(57,1,2025,'archivos','Año-Nuevo-2','Redes Sociales','video','Año nuevo-2.mp4','Año nuevo-2.mp4','video/mp4',7745827,'1RQks0rLkHd_NnvZMa18PdeDDQUmpIWyV','2025-12-04 06:22:19','2025-12-04 06:22:34'),(69,1,2025,'archivos','Navidad-Dia-TV-1','TV','video','NavidadTV-1.mp4','NavidadTV-1.mp4','video/mp4',21601929,'10qB6qBIUNW0bygD1dGsfa3ubKgzCVbQh','2025-12-04 06:24:05','2025-12-04 06:25:09'),(74,1,2025,'archivos','Navidad-Dia-TV-2','TV','video','NavidadTV-2.mp4','NavidadTV-2.mp4','video/mp4',17580478,'1Tl0X85_r1kM5dYxV952XsSG-_bH2fImO','2025-12-04 06:24:24','2025-12-04 06:24:40'),(79,1,2025,'archivos','Navidad-Dia-TV-3','TV','video','NavidadTV-3.mp4','NavidadTV-3.mp4','video/mp4',25319012,'1fqrWGRIcuwUiNC6wRVFVXNsmpsaPaYyl','2025-12-04 06:25:26','2025-12-04 06:26:12'),(89,1,2025,'archivos','Año-Nuevo-TV-1','TV','video','AñoNuevo-1.mp4','AñoNuevo-1.mp4','video/mp4',18496961,'1FLf8G7I2Dew2-cwJgmkRS-0CMQKMbPsk','2025-12-04 06:25:56','2025-12-04 06:26:48'),(100,1,2025,'archivos','Billete2-1','Redes Sociales','video','Billete2Dolares-1.mp4','Billete2Dolares-1.mp4','video/mp4',10530308,'1qLiWSxz6CQMYhp9YjN_dsgYHkWjbJGzS','2025-12-05 05:50:50','2025-12-05 05:51:14'),(102,1,2025,'archivos','Billete2-2','Redes Sociales','video','Billete2Dolares-2.mp4','Billete2Dolares-2.mp4','video/mp4',11405333,'1s8pyzBzl_LizYEoq-ms-MAMMrvGt3Xw6','2025-12-05 05:50:51','2025-12-05 05:51:21'),(103,1,2025,'archivos','Billete2TV-2','TV','video','Billete2TV-2.mp4','Billete2TV-2.mp4','video/mp4',17857062,'1w4ymZj1lm-WpqaB-mRlbk0ZFUuRewIJE','2025-12-05 05:51:29','2025-12-05 05:52:30'),(113,1,2025,'archivos','Billete2TV-1','TV','video','Billete2TV-1.mp4','Billete2TV-1.mp4','video/mp4',18573690,'1JV3VBC3HonjUOLG2OxM3YZFPbdHmUNSV','2025-12-05 05:51:52','2025-12-05 05:52:22'),(114,1,2025,'archivos','Divisas-2','Redes Sociales','video','Divisas-2.mp4','Divisas-2.mp4','video/mp4',9030069,'1N8DbFK4uBibEej-6CiZ6QJKjS4uw3JNJ','2025-12-10 06:01:18','2025-12-10 06:02:20'),(119,1,2025,'archivos','Divisas-1','Redes Sociales','video','Divisas-1.mp4','Divisas-1.mp4','video/mp4',8130654,'1DWsiU-TLc6ZlrIUD-vXkduJoByV8_jZb','2025-12-10 06:01:42','2025-12-10 06:02:12'),(120,1,2025,'archivos','DivisasTV-2','Redes Sociales','video','DivisasTV-2.mp4','DivisasTV-2.mp4','video/mp4',12090954,'1OBpGnEXlwchcOPdsw3mL9jhFyFJu-etp','2025-12-10 06:02:28','2025-12-10 06:03:17'),(126,1,2025,'archivos','DivisasTV-1','Redes Sociales','video','DivisasTV-1.mp4','DivisasTV-1.mp4','video/mp4',12090954,'1lkeAi04PYFCzcPKktbmM0HnCvQTL78AA','2025-12-10 06:02:50','2025-12-10 06:03:08');

--
-- Table structure for table `publicidad_tabla`
--

CREATE TABLE `publicidad_tabla` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `usuario_id` int unsigned NOT NULL DEFAULT '0',
  `anio` int NOT NULL,
  `bucket` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'principal',
  `schema_json` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `rows_json` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uniq_publi` (`anio`,`bucket`)
) ENGINE=InnoDB AUTO_INCREMENT=793 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `publicidad_tabla`
--

INSERT INTO `publicidad_tabla` VALUES (1,0,2025,'principal','[{\"key\":\"nro\",\"tipo\":\"text\",\"label\":\"N / I\",\"orden\":1},{\"key\":\"campana\",\"tipo\":\"text\",\"label\":\"MARCA\",\"orden\":2},{\"key\":\"canal\",\"tipo\":\"text\",\"label\":\"RAZON SOCIAL\",\"orden\":3},{\"key\":\"formato\",\"tipo\":\"text\",\"label\":\"RUC\",\"orden\":4},{\"key\":\"objetivo\",\"tipo\":\"text\",\"label\":\"DATOS INFORMATIVOS\",\"orden\":5},{\"key\":\"presupuesto\",\"tipo\":\"text\",\"label\":\"DIRECCIÓN\",\"orden\":6},{\"key\":\"fecha_inicio\",\"tipo\":\"text\",\"label\":\"NRO CONTACTO\",\"orden\":7},{\"key\":\"fecha_fin\",\"tipo\":\"text\",\"label\":\"PAGINA WEB\",\"orden\":8},{\"key\":\"estado\",\"tipo\":\"text\",\"label\":\"REDES SOCIALES\",\"orden\":9}]','[{\"nro\":\"Nacionales (full days Paracas, Huancaya, etc.)\",\"col1\":\"Pack “Cierre Anticipado”: al emitir boleto, Indiana envía link BIDEX con tasa bloqueada 48 h.\\n\\n\\nVale físico: Indiana entrega cupón con QR a WhatsApp (código INDIANA10).\\n\\n\\nCharlas express (15 min) en su oficina: “Cómo evitar sobrecostos al cambiar en aeropuerto”.\",\"canal\":\"INDIANA TRAVEL PERU S.A.C.\",\"estado\":\"Facebook: https://www.facebook.com/indianatravelperu\",\"campana\":\"Indiana Travel Perú\",\"formato\":\"20604165173\",\"objetivo\":\"Agencia de viajes en Jesús María (autorizada por MINCETUR).\",\"fecha_fin\":\"https://indianatravelperu.com\",\"presupuesto\":\"Av. Talara 259, Jesús María, Lima\",\"fecha_inicio\":\"923 066 552 (Tel/WhatsApp)\"},{\"nro\":\"Ambos (vuelos/paquetes dentro y fuera del país).\",\"canal\":\"PROMOTORA DE TURISMO NUEVO MUNDO S.A.C.\",\"estado\":\"Facebook: https://www.facebook.com/nmviajes | Instagram: https://www.instagram.com/nmviajes/\",\"campana\":\"NM Viajes (tienda Jesús María)\",\"formato\":\"20106785288\",\"objetivo\":\"Sucursal Nuevo Mundo Viajes en Jesús María.\",\"fecha_fin\":\"https://www.nmviajes.com\",\"presupuesto\":\"Av. Faustino Sánchez Carrión 1029 (Ex Av. Pershing), Jesús María, Lima\",\"fecha_inicio\":\"610 9200 (Opción 2) | WhatsApp: 993 561 865\"},{\"nro\":\"Ambos, con foco fuerte en internacionales (“alrededor del mundo”)\",\"canal\":\"VIAJES NANI Y BESSYTOURS ASOCIADAS S.A.C.\",\"estado\":\"Instagram: https://www.instagram.com/escapemundial_/ | Facebook: https://www.facebook.com/escapemundial/\",\"campana\":\"Escape Mundial\",\"formato\":\"20535955027\",\"objetivo\":\"Agencia de viajes en Breña.\",\"fecha_fin\":\"https://escapemundial.com\",\"presupuesto\":\"Av. España 632, Breña, Lima\",\"fecha_inicio\":\"993 465 595\"},{\"nro\":\"Ambos (venta de pasajes y paquetes; atienden diversos destinos)\",\"canal\":\"AEROWORLD S.A.\",\"estado\":\"Facebook: https://www.facebook.com/aeroworldviajes/ | Instagram: https://www.instagram.com/aeroworldviajes/\",\"campana\":\"Aeroworld Viajes\",\"formato\":\"20433206372\",\"objetivo\":\"Agencia con más de 25 años (Breña).\",\"fecha_fin\":\"\",\"presupuesto\":\"Av. España 680, Breña, Lima\",\"fecha_inicio\":\"(01) 433 0395 | WhatsApp: 993 684 580\"},{\"nro\":\"Ambos (vuelos nacionales e internacionales)\",\"canal\":\"DYNASTY BUSINESS ENTERPRISE E.I.R.L.\",\"estado\":\"\",\"campana\":\"Socios Dynasty Travel\",\"formato\":\"20611551496\",\"objetivo\":\"Agencia de viajes en Jesús María.\",\"fecha_fin\":\"https://www.sociosdynasty.com\",\"presupuesto\":\"Av. Gral. Eugenio Garzón 1599, Int. 23, Jesús María, Lima\",\"fecha_inicio\":\"997 189 514 | Email: atencionalcliente@sociosdynasty.com\"},{\"nro\":\"Ambos, con énfasis en experiencias y aventura; opera para público local y foráneo\",\"canal\":\"SURVIVAL & ADVENTURE S.A.C.\",\"estado\":\"\",\"campana\":\"Survival & Adventure\",\"formato\":\"20518910311\",\"objetivo\":\"Agencia de viajes (Lince).\",\"fecha_fin\":\"https://www.iperu.org/buscar/agencias-de-viajes-en-lima/survival-adventure\",\"presupuesto\":\"Av. Arenales 2586, Lince, Lima\",\"fecha_inicio\":\"\"},{\"nro\":\"Ambos, con fuerte oferta internacional (tiene categorías por Europa, etc.).\",\"canal\":\"TRAVEL INDUSTRY REPS E.I.R.L.\",\"estado\":\"Facebook: https://www.facebook.com/TRAVELINDUSTRYREPS/\",\"campana\":\"Travel Industry Reps (agencia)\",\"formato\":\"20609532026\",\"objetivo\":\"Agencia/representaciones en Lince.\",\"fecha_fin\":\"\",\"presupuesto\":\"Av. Arenales 2201, Lince, Lima\",\"fecha_inicio\":\"908 802 349 | Email: travelindustryreps.peru@gmail.com\"}]','2025-09-22 10:30:48','2025-12-10 06:01:18'),(209,0,2025,'secundario','[{\"key\":\"col1\",\"tipo\":\"text\",\"label\":\"MARCA\",\"orden\":1},{\"key\":\"col2\",\"tipo\":\"text\",\"label\":\"ESTRATEGIA\",\"orden\":2}]','[{\"col1\":\"Indiana Travel Perú\",\"col2\":\"1) “Cierre Anticipado” (tasa por 48 h)\\n\\n\\nQué es: Cuando Indiana emite el boleto, manda tu link para que el cliente “asegure” su tipo de cambio por 2 días.\\n\\n\\nCómo se hace:\\n\\n\\nLes das un link con tu WhatsApp y el código INDIANA10.\\n\\n\\nEllos lo envían junto con el correo o WhatsApp del pasaje.\\n\\n\\nEl cliente te escribe y tú le respetas esa tasa hasta 48 h.                                                                                                      2) Vale con QR (INDIANA10)\\n\\n\\nQué es: Un cupón en papel con un QR que lleva directo a tu WhatsApp con el mensaje listo.\\n\\n\\nCómo se hace:\\n\\n\\nImprimes cupones con QR y el código INDIANA10.\\n\\n\\nEllos los dan a sus clientes.\\n\\n\\nEl cliente escanea y te escribe; tú aplicas la tasa preferente.                                                                                                                                                                                                                    3) Charlas express (15 min)\\n\\n\\nQué es: Una mini charla simple en su oficina: “Cómo no pagar de más en el aeropuerto”.\\n\\n\\nCómo se hace:\\n\\n\\nLleva 3 consejos claros (ej.: evita cambiar en aeropuerto, compara tasas, cuánto llevar en efectivo).\\n\\n\\nAl final, entregas el cupón/QR.\"},{\"col1\":\"NM\\nViajes\",\"col2\":\"1) “Bundle” familia o grupos\\n\\n\\n Qué\\n     es: Si\\n     viajan varios juntos, mejor tasa por cada persona extra.\\n Cómo\\n     se hace:\\n \\n  Definir:\\n      1 pasajero = tasa base; 2 pasajeros = mejor; 3 o más = aún mejor.\\n  NM\\n      pregunta si viajan en grupo y te deriva.\\n \\n\\n\\n2) “Calcula tu cambio” en su web\\n\\n\\n Qué\\n     es: Un\\n     cuadrito que convierte USD/EUR a soles y un botón a tu WhatsApp.\\n Cómo\\n     se hace:\\n \\n  Les\\n      pasas un pequeño cuadro (iframe) con tu convertidor.\\n  Abajo,\\n      un botón “Hablar por WhatsApp”.\\n \\n\\n\\n3) Pop-up days (2 mañanas/mes)\\n\\n\\n Qué\\n     es: Tú\\n     te vas a su local y haces cambios ahí mismo.\\n Cómo\\n     se hace:\\n \\n  Acordar\\n      2 fechas al mes.\\n  Pones\\n      un cartel “Hoy cambio especial con BIDEX”.\\n  Clientes\\n      pagan por transferencia o POS.\"},{\"col1\":\"Escape\\nMundial\",\"col2\":\"1) “Último minuto”\\n\\n\\n Qué\\n     es: Si\\n     el cliente va a viajar mañana o pasado, le guardas una buena tasa y\\n     entregas rápido.\\n Cómo\\n     se hace:\\n \\n  Mensaje\\n      claro: “Si faltan ≤24 h, te respetamos esta tasa”.\\n  Indica\\n      cómo pagar y dónde recoger.\\n \\n\\n\\n2) Sticker con tiempo promedio\\n\\n\\n Qué\\n     es: Un\\n     sticker en su vitrina: “Transferencia confirmada en 9–12 min aprox.”\\n Cómo\\n     se hace:\\n \\n  Imprime\\n      un sticker simple.\\n  Lo\\n      pegan cerca a la puerta/mostrador.\\n \\n\\n\\n3) Reto al equipo\\n\\n\\n Qué\\n     es:\\n     Premio mensual a los asesores que más te deriven clientes.\\n Cómo\\n     se hace:\\n \\n  Llevar\\n      un conteo simple.\\n  Regalar\\n      giftcard a los 3 primeros.\"},{\"col1\":\"Aeroworld\\nViajes\",\"col2\":\"1) Empresas (pyme)\\n\\n\\n Qué\\n     es:\\n     Ofrecer tasa especial para sus clientes empresa.\\n Cómo\\n     se hace:\\n \\n  Reunión\\n      corta con su asesor corporativo.\\n  Tasa\\n      fija “empresa” y proceso claro.\\n \\n\\n\\n2) “Chequeo” antes del viaje\\n\\n\\n Qué\\n     es: En\\n     su correo de “documentos del viaje” agregan tus consejos y tu link.\\n Cómo\\n     se hace:\\n \\n  3\\n      tips y un botón a tu WhatsApp.\\n  Aseguras\\n      tasa si te contactan.\\n \\n\\n\\n3) Caso de éxito trimestral\\n\\n\\n Qué\\n     es: Un\\n     PDF de 1 página con un ejemplo real de ahorro.\\n Cómo\\n     se hace:\\n \\n  Pones\\n      un ejemplo (sin datos personales).\\n  Lo\\n      envían a sus clientes frecuentes.\"},{\"col1\":\"Socios\\nDynasty Travel\",\"col2\":\"1) Pagos en partes → cambio en partes\\n\\n\\n Qué\\n     es: Si\\n     el cliente paga su viaje por cuotas, también puede cambiar su dinero por\\n     partes.\\n Cómo\\n     se hace:\\n \\n  Ofrecer\\n      “programar” cambios (hoy una parte, luego otra).\\n  En\\n      cada fecha, te escribe y aplicas la tasa acordada.\\n \\n\\n\\n2) PDF de confianza\\n\\n\\n Qué\\n     es: Un\\n     PDF simple con tu forma de trabajo: seguridad, comprobantes, verificación.\\n Cómo\\n     se hace:\\n \\n  1\\n      página con puntos claros.\\n  Lo\\n      envían a sus clientes VIP.\\n \\n\\n\\n3) Lista VIP\\n\\n\\n Qué\\n     es:\\n     Quien use tu servicio varias veces, mantiene una buena tasa por 6 meses.\\n Cómo\\n     se hace:\\n \\n  Guardas\\n      su nombre en una lista.\\n  Le\\n      aplicas siempre la tasa VIP.\"},{\"col1\":\"Agencia\\nRuiz Travel\",\"col2\":\"1) Kit de mostrador\\n\\n\\n Qué\\n     es:\\n     Porta-folletos + QR + una tablita que muestra cuánto ahorra el cliente.\\n Cómo\\n     se hace:\\n \\n  Imprimir\\n      folleto y tabla “monto → ahorro”.\\n  Ponerlo\\n      en su mostrador.\\n \\n\\n\\n2) Guion para llamada\\n\\n\\n Qué\\n     es: Al\\n     final de su llamada de cotización, dicen: “¿Desea fijar su tipo de cambio\\n     hoy?”\\n Cómo\\n     se hace:\\n \\n  Les\\n      das 3 líneas exactas.\\n  Lo\\n      repiten siempre.\\n \\n\\n\\n3) Mensaje listo para reenviar (WhatsApp)\\n\\n\\n Qué\\n     es: Un\\n     texto corto con tu link y el código.\\n Cómo\\n     se hace:\\n \\n  Les\\n      pasas el texto.\\n  Solo\\n      reenvían al cliente.\"},{\"col1\":\"\",\"col2\":\"\"}]','2025-09-22 12:28:40','2025-09-25 06:15:26'),(429,0,2025,'manual','[]','[{\"contenido\":\"<table style=\\\"border-collapse: collapse; width: 73.7277%; height: 134.344px;\\\" border=\\\"1\\\"><colgroup><col style=\\\"width: 26.9929%;\\\"><col style=\\\"width: 73.0071%;\\\"><\\/colgroup>\\n<tbody>\\n<tr style=\\\"height: 22.3906px;\\\">\\n<td style=\\\"height: 22.3906px;\\\"><strong>MARCA<\\/strong><\\/td>\\n<td style=\\\"height: 22.3906px;\\\"><strong>ESTRATEGIA<\\/strong><\\/td>\\n<\\/tr>\\n<tr style=\\\"height: 22.3906px;\\\">\\n<td style=\\\"height: 22.3906px;\\\"><span>Indiana Travel Per&uacute;<\\/span><\\/td>\\n<td style=\\\"height: 22.3906px;\\\">PAQUETES EN PROMOCION (REGALAR A CLIENTES)<\\/td>\\n<\\/tr>\\n<tr style=\\\"height: 22.3906px;\\\">\\n<td style=\\\"height: 22.3906px;\\\"><span>NM Viajes<\\/span><\\/td>\\n<td style=\\\"height: 22.3906px;\\\">TIPO DE CAMBIO PREFERENCIALES \\/ PAQUETES DE PROMOCIONES (REGALAR A CLIENTES)<\\/td>\\n<\\/tr>\\n<tr style=\\\"height: 22.3906px;\\\">\\n<td style=\\\"height: 22.3906px;\\\"><span>Escape Mundial<\\/span><\\/td>\\n<td style=\\\"height: 22.3906px;\\\">TIPO DE CAMBIO PREFERENCIALES \\/ PAQUETES DE PROMOCIONES (REGALAR A CLIENTES)<\\/td>\\n<\\/tr>\\n<tr style=\\\"height: 22.3906px;\\\">\\n<td style=\\\"height: 22.3906px;\\\"><span>Aeroworld Viajes<\\/span><\\/td>\\n<td style=\\\"height: 22.3906px;\\\">TIPO DE CAMBIO PREFERENCIALES<\\/td>\\n<\\/tr>\\n<tr style=\\\"height: 22.3906px;\\\">\\n<td style=\\\"height: 22.3906px;\\\"><span>Socios Dynasty Travel<\\/span><\\/td>\\n<td style=\\\"height: 22.3906px;\\\">TIPO DE CAMBIO PREFERENCIALES \\/ PAQUETES DE PROMOCIONES (REGALAR A CLIENTES)<\\/td>\\n<\\/tr>\\n<tr>\\n<td><span>Survival &amp; Adventure<\\/span><\\/td>\\n<td>TIPO DE CAMBIO PREFERENCIALES \\/ PAQUETES DE PROMOCIONES (REGALAR A CLIENTES)<\\/td>\\n<\\/tr>\\n<tr>\\n<td><span>Travel Industry Reps (agencia)<\\/span><\\/td>\\n<td>TIPO DE CAMBIO PREFERENCIALES \\/ PAQUETES DE PROMOCIONES (REGALAR A CLIENTES)<\\/td>\\n<\\/tr>\\n<\\/tbody>\\n<\\/table>\\n<p style=\\\"text-align: center;\\\">&nbsp;<\\/p>\\n<p style=\\\"text-align: center;\\\"><span style=\\\"text-decoration: underline;\\\"><strong>AGENCIAS INTERNACIONALES<\\/strong><\\/span><\\/p>\\n<ul class=\\\"todo-list\\\">\\n<li style=\\\"text-align: left;\\\" data-checked=\\\"false\\\"><span class=\\\"cb\\\" contenteditable=\\\"false\\\" data-mce-noneditable=\\\"1\\\"><\\/span>Ofrecer divisas<\\/li>\\n<li style=\\\"text-align: left;\\\" data-checked=\\\"false\\\"><span class=\\\"cb\\\" contenteditable=\\\"false\\\" data-mce-noneditable=\\\"1\\\"><\\/span>Promociones<\\/li>\\n<li style=\\\"text-align: left;\\\" data-checked=\\\"false\\\">&nbsp;<\\/li>\\n<\\/ul>\\n<table style=\\\"border-collapse: collapse; width: 100.017%; height: 243.89px;\\\" border=\\\"1\\\"><colgroup><col style=\\\"width: 15.4856%;\\\"><col style=\\\"width: 9.00522%;\\\"><col style=\\\"width: 9.17354%;\\\"><col style=\\\"width: 8.41609%;\\\"><col style=\\\"width: 9.00522%;\\\"><col style=\\\"width: 9.34186%;\\\"><col style=\\\"width: 12.7083%;\\\"><col style=\\\"width: 11.3617%;\\\"><col style=\\\"width: 15.4856%;\\\"><\\/colgroup>\\n<tbody>\\n<tr style=\\\"height: 44.7812px;\\\">\\n<td class=\\\"xl65\\\" style=\\\"height: 44.7812px; width: 149pt;\\\" width=\\\"199\\\" height=\\\"20\\\"><strong>Agencia<\\/strong><\\/td>\\n<td class=\\\"xl65\\\" style=\\\"height: 44.7812px; width: 48pt;\\\" width=\\\"64\\\" height=\\\"20\\\">Egipto (EGP)<\\/td>\\n<td class=\\\"xl65\\\" style=\\\"border-left: none; width: 48pt; height: 44.7812px;\\\" width=\\\"64\\\">M&eacute;xico (MXN)<\\/td>\\n<td class=\\\"xl65\\\" style=\\\"border-left: none; width: 48pt; height: 44.7812px;\\\" width=\\\"64\\\">Europa (EUR)<\\/td>\\n<td class=\\\"xl65\\\" style=\\\"border-left: none; width: 48pt; height: 44.7812px;\\\" width=\\\"64\\\">Chile (CLP)<\\/td>\\n<td class=\\\"xl65\\\" style=\\\"border-left: none; width: 48pt; height: 44.7812px;\\\" width=\\\"64\\\">Brasil (BRL)<\\/td>\\n<td class=\\\"xl65\\\" style=\\\"border-left: none; width: 48pt; height: 44.7812px;\\\" width=\\\"64\\\">Colombia (COP)<\\/td>\\n<td class=\\\"xl65\\\" style=\\\"border-left: none; width: 48pt; height: 44.7812px;\\\" width=\\\"64\\\">Panam&aacute; (USD)<\\/td>\\n<td class=\\\"xl65\\\" style=\\\"border-left: none; width: 48pt; height: 44.7812px;\\\" width=\\\"64\\\">R. Dominicana (DOP)<\\/td>\\n<\\/tr>\\n<tr style=\\\"height: 64.7656px;\\\">\\n<td style=\\\"height: 64.7656px;\\\" height=\\\"20\\\"><strong>NM Viajes (tienda Jes&uacute;s Mar&iacute;a)<\\/strong><\\/td>\\n<td style=\\\"height: 64.7656px;\\\">\\n<h1 style=\\\"text-align: center;\\\"><span style=\\\"font-family: arial, helvetica, sans-serif; font-size: 24pt;\\\"><strong><span style=\\\"color: rgb(53, 152, 219);\\\">x<\\/span><\\/strong><\\/span><\\/h1>\\n<\\/td>\\n<td style=\\\"height: 64.7656px;\\\">\\n<h1 style=\\\"text-align: center;\\\"><span style=\\\"font-family: arial, helvetica, sans-serif; font-size: 24pt;\\\"><strong><span style=\\\"color: rgb(53, 152, 219);\\\">-<\\/span><\\/strong><\\/span><\\/h1>\\n<\\/td>\\n<td style=\\\"height: 64.7656px;\\\">\\n<h1 style=\\\"text-align: center;\\\"><span style=\\\"font-family: arial, helvetica, sans-serif; font-size: 24pt;\\\"><strong><span style=\\\"color: rgb(53, 152, 219);\\\">x<\\/span><\\/strong><\\/span><\\/h1>\\n<\\/td>\\n<td style=\\\"height: 64.7656px;\\\">\\n<h1 style=\\\"text-align: center;\\\"><span style=\\\"font-family: arial, helvetica, sans-serif; font-size: 24pt;\\\"><strong><span style=\\\"color: rgb(53, 152, 219);\\\">x<\\/span><\\/strong><\\/span><\\/h1>\\n<\\/td>\\n<td style=\\\"height: 64.7656px;\\\">\\n<h1 style=\\\"text-align: center;\\\"><span style=\\\"font-family: arial, helvetica, sans-serif; font-size: 24pt;\\\"><strong><span style=\\\"color: rgb(53, 152, 219);\\\">x<\\/span><\\/strong><\\/span><\\/h1>\\n<\\/td>\\n<td style=\\\"height: 64.7656px;\\\">\\n<h1 style=\\\"text-align: center;\\\"><span style=\\\"font-family: arial, helvetica, sans-serif; font-size: 24pt;\\\"><strong><span style=\\\"color: rgb(53, 152, 219);\\\">x<\\/span><\\/strong><\\/span><\\/h1>\\n<\\/td>\\n<td style=\\\"height: 64.7656px;\\\">\\n<h1 style=\\\"text-align: center;\\\"><span style=\\\"font-family: arial, helvetica, sans-serif; font-size: 24pt;\\\"><strong><span style=\\\"color: rgb(53, 152, 219);\\\">x<\\/span><\\/strong><\\/span><\\/h1>\\n<\\/td>\\n<td style=\\\"height: 64.7656px;\\\">\\n<h1 style=\\\"text-align: center;\\\"><span style=\\\"font-family: arial, helvetica, sans-serif; font-size: 24pt;\\\"><strong><span style=\\\"color: rgb(53, 152, 219);\\\">x<\\/span><\\/strong><\\/span><\\/h1>\\n<\\/td>\\n<\\/tr>\\n<tr style=\\\"height: 22.3906px;\\\">\\n<td style=\\\"height: 22.3906px;\\\" height=\\\"20\\\"><strong>Escape Mundial<\\/strong><\\/td>\\n<td style=\\\"height: 22.3906px;\\\">\\n<h1 style=\\\"text-align: center;\\\"><span style=\\\"font-family: arial, helvetica, sans-serif; font-size: 24pt;\\\"><strong><span style=\\\"color: rgb(53, 152, 219);\\\">-<\\/span><\\/strong><\\/span><\\/h1>\\n<\\/td>\\n<td style=\\\"height: 22.3906px;\\\">\\n<h1 style=\\\"text-align: center;\\\"><span style=\\\"font-family: arial, helvetica, sans-serif; font-size: 24pt;\\\"><strong><span style=\\\"color: rgb(53, 152, 219);\\\">-<\\/span><\\/strong><\\/span><\\/h1>\\n<\\/td>\\n<td style=\\\"height: 22.3906px;\\\">\\n<h1 style=\\\"text-align: center;\\\"><span style=\\\"font-family: arial, helvetica, sans-serif; font-size: 24pt;\\\"><strong><span style=\\\"color: rgb(53, 152, 219);\\\">x<\\/span><\\/strong><\\/span><\\/h1>\\n<\\/td>\\n<td style=\\\"height: 22.3906px;\\\">\\n<h1 style=\\\"text-align: center;\\\"><span style=\\\"font-family: arial, helvetica, sans-serif; font-size: 24pt;\\\"><strong><span style=\\\"color: rgb(53, 152, 219);\\\">-<\\/span><\\/strong><\\/span><\\/h1>\\n<\\/td>\\n<td style=\\\"height: 22.3906px;\\\">\\n<h1 style=\\\"text-align: center;\\\"><span style=\\\"font-family: arial, helvetica, sans-serif; font-size: 24pt;\\\"><strong><span style=\\\"color: rgb(53, 152, 219);\\\">-<\\/span><\\/strong><\\/span><\\/h1>\\n<\\/td>\\n<td style=\\\"height: 22.3906px;\\\">\\n<h1 style=\\\"text-align: center;\\\"><span style=\\\"font-family: arial, helvetica, sans-serif; font-size: 24pt;\\\"><strong><span style=\\\"color: rgb(53, 152, 219);\\\">x<\\/span><\\/strong><\\/span><\\/h1>\\n<\\/td>\\n<td style=\\\"height: 22.3906px;\\\">\\n<h1 style=\\\"text-align: center;\\\"><span style=\\\"font-family: arial, helvetica, sans-serif; font-size: 24pt;\\\"><strong><span style=\\\"color: rgb(53, 152, 219);\\\">-<\\/span><\\/strong><\\/span><\\/h1>\\n<\\/td>\\n<td style=\\\"height: 22.3906px;\\\">\\n<h1 style=\\\"text-align: center;\\\"><span style=\\\"font-family: arial, helvetica, sans-serif; font-size: 24pt;\\\"><strong><span style=\\\"color: rgb(53, 152, 219);\\\">x<\\/span><\\/strong><\\/span><\\/h1>\\n<\\/td>\\n<\\/tr>\\n<tr style=\\\"height: 22.3906px;\\\">\\n<td style=\\\"height: 22.3906px;\\\" height=\\\"20\\\"><strong>Aeroworld Viajes<\\/strong><\\/td>\\n<td style=\\\"height: 22.3906px;\\\">\\n<h1 style=\\\"text-align: center;\\\"><span style=\\\"font-family: arial, helvetica, sans-serif; font-size: 24pt;\\\"><strong><span style=\\\"color: rgb(53, 152, 219);\\\">-<\\/span><\\/strong><\\/span><\\/h1>\\n<\\/td>\\n<td style=\\\"height: 22.3906px;\\\">\\n<h1 style=\\\"text-align: center;\\\"><span style=\\\"font-family: arial, helvetica, sans-serif; font-size: 24pt;\\\"><strong><span style=\\\"color: rgb(53, 152, 219);\\\">x<\\/span><\\/strong><\\/span><\\/h1>\\n<\\/td>\\n<td style=\\\"height: 22.3906px;\\\">\\n<h1 style=\\\"text-align: center;\\\"><span style=\\\"font-family: arial, helvetica, sans-serif; font-size: 24pt;\\\"><strong><span style=\\\"color: rgb(53, 152, 219);\\\">x<\\/span><\\/strong><\\/span><\\/h1>\\n<\\/td>\\n<td style=\\\"height: 22.3906px;\\\">\\n<h1 style=\\\"text-align: center;\\\"><span style=\\\"font-family: arial, helvetica, sans-serif; font-size: 24pt;\\\"><strong><span style=\\\"color: rgb(53, 152, 219);\\\">-<\\/span><\\/strong><\\/span><\\/h1>\\n<\\/td>\\n<td style=\\\"height: 22.3906px;\\\">\\n<h1 style=\\\"text-align: center;\\\"><span style=\\\"font-family: arial, helvetica, sans-serif; font-size: 24pt;\\\"><strong><span style=\\\"color: rgb(53, 152, 219);\\\">-<\\/span><\\/strong><\\/span><\\/h1>\\n<\\/td>\\n<td style=\\\"height: 22.3906px;\\\">\\n<h1 style=\\\"text-align: center;\\\"><span style=\\\"font-family: arial, helvetica, sans-serif; font-size: 24pt;\\\"><strong><span style=\\\"color: rgb(53, 152, 219);\\\">-<\\/span><\\/strong><\\/span><\\/h1>\\n<\\/td>\\n<td style=\\\"height: 22.3906px;\\\">\\n<h1 style=\\\"text-align: center;\\\"><span style=\\\"font-family: arial, helvetica, sans-serif; font-size: 24pt;\\\"><strong><span style=\\\"color: rgb(53, 152, 219);\\\">-<\\/span><\\/strong><\\/span><\\/h1>\\n<\\/td>\\n<td style=\\\"height: 22.3906px;\\\">\\n<h1 style=\\\"text-align: center;\\\"><span style=\\\"font-family: arial, helvetica, sans-serif; font-size: 24pt;\\\"><strong><span style=\\\"color: rgb(53, 152, 219);\\\">-<\\/span><\\/strong><\\/span><\\/h1>\\n<\\/td>\\n<\\/tr>\\n<\\/tbody>\\n<\\/table>\\n<p style=\\\"text-align: center;\\\">&nbsp;<\\/p>\\n<p style=\\\"text-align: center;\\\"><span style=\\\"text-decoration: underline;\\\"><strong>AGENCIAS NACIONALES<\\/strong><\\/span><\\/p>\\n<table style=\\\"border-collapse: collapse; width: 100.017%; height: 156.475px;\\\" border=\\\"1\\\"><colgroup><col style=\\\"width: 9.34186%;\\\"><col style=\\\"width: 6.39623%;\\\"><col style=\\\"width: 9.08938%;\\\"><col style=\\\"width: 10.0151%;\\\"><col style=\\\"width: 9.59434%;\\\"><col style=\\\"width: 9.59434%;\\\"><col style=\\\"width: 8.16361%;\\\"><col style=\\\"width: 9.51018%;\\\"><col style=\\\"width: 10.1835%;\\\"><col style=\\\"width: 8.07945%;\\\"><col style=\\\"width: 8.50025%;\\\"><col style=\\\"width: 1.5149%;\\\"><\\/colgroup>\\n<tbody>\\n<tr style=\\\"height: 22.4px;\\\">\\n<td class=\\\"xl65\\\" style=\\\"height: 22.4px; width: 104pt;\\\" width=\\\"139\\\" height=\\\"20\\\"><strong>Agencia<\\/strong><\\/td>\\n<td class=\\\"xl63\\\" style=\\\"height: 22.4px; width: 13.5pt;\\\" width=\\\"36\\\" height=\\\"20\\\"><strong>CHURIN<\\/strong><\\/td>\\n<td class=\\\"xl63\\\" style=\\\"border-left: none; width: 32pt; height: 22.4px;\\\" width=\\\"43\\\"><strong>CUSCO<\\/strong><\\/td>\\n<td class=\\\"xl63\\\" style=\\\"border-left: none; width: 48pt; height: 22.4px;\\\" width=\\\"64\\\"><strong>AREQUIPA<\\/strong><\\/td>\\n<td class=\\\"xl63\\\" style=\\\"border-left: none; width: 40pt; height: 22.4px;\\\" width=\\\"53\\\"><strong>PARACAS<\\/strong><\\/td>\\n<td class=\\\"xl63\\\" style=\\\"border-left: none; width: 48pt; height: 22.4px;\\\" width=\\\"64\\\"><strong>CA&Ntilde;ATE<\\/strong><\\/td>\\n<td class=\\\"xl63\\\" style=\\\"border-left: none; width: 48pt; height: 22.4px;\\\" width=\\\"64\\\"><strong>ICA<\\/strong><\\/td>\\n<td class=\\\"xl63\\\" style=\\\"border-left: none; width: 48pt; height: 22.4px;\\\" width=\\\"64\\\"><strong>HUARAZ<\\/strong><\\/td>\\n<td class=\\\"xl63\\\" style=\\\"border-left: none; width: 48pt; height: 22.4px;\\\" width=\\\"64\\\"><strong>TARAPOTO<\\/strong><\\/td>\\n<td class=\\\"xl63\\\" style=\\\"border-left: none; width: 12pt; height: 22.4px;\\\" width=\\\"64\\\"><strong>MANCORA<\\/strong><\\/td>\\n<td style=\\\"border-left: none; width: 6pt;\\\"><strong>HUANCAYA<\\/strong><\\/td>\\n<td style=\\\"border-left: none; width: 6pt;\\\"><strong>SAN MATEO DE OTAO<\\/strong><\\/td>\\n<\\/tr>\\n<tr style=\\\"height: 89.275px;\\\">\\n<td style=\\\"height: 89.275px;\\\" height=\\\"20\\\"><strong>Indiana Travel Per&uacute;<\\/strong><\\/td>\\n<td style=\\\"width: 13.5pt; height: 89.275px;\\\">\\n<h1 style=\\\"text-align: center;\\\"><span style=\\\"font-family: arial, helvetica, sans-serif; font-size: 24pt;\\\"><strong><span style=\\\"color: rgb(53, 152, 219);\\\">x<\\/span><\\/strong><\\/span><\\/h1>\\n<\\/td>\\n<td style=\\\"border-left: none; width: 32pt; height: 89.275px;\\\">&nbsp;\\n<h1 style=\\\"text-align: center;\\\"><span style=\\\"font-family: arial, helvetica, sans-serif; font-size: 24pt;\\\"><strong><span style=\\\"color: rgb(53, 152, 219);\\\">-<\\/span><\\/strong><\\/span><\\/h1>\\n<\\/td>\\n<td style=\\\"border-left: none; width: 48pt; height: 89.275px;\\\">&nbsp;\\n<h1 style=\\\"text-align: center;\\\"><span style=\\\"font-family: arial, helvetica, sans-serif; font-size: 24pt;\\\"><strong><span style=\\\"color: rgb(53, 152, 219);\\\">-<\\/span><\\/strong><\\/span><\\/h1>\\n<\\/td>\\n<td style=\\\"border-left: none; width: 40pt; height: 89.275px;\\\">\\n<h1 style=\\\"text-align: center;\\\"><span style=\\\"font-family: arial, helvetica, sans-serif; font-size: 24pt;\\\"><strong><span style=\\\"color: rgb(53, 152, 219);\\\">x<\\/span><\\/strong><\\/span><\\/h1>\\n<\\/td>\\n<td style=\\\"border-left: none; width: 48pt; height: 89.275px;\\\">\\n<h1 style=\\\"text-align: center;\\\"><span style=\\\"font-family: arial, helvetica, sans-serif; font-size: 24pt;\\\"><strong><span style=\\\"color: rgb(53, 152, 219);\\\">x<\\/span><\\/strong><\\/span><\\/h1>\\n<\\/td>\\n<td style=\\\"border-left: none; width: 48pt; height: 89.275px;\\\">\\n<h1 style=\\\"text-align: center;\\\"><span style=\\\"font-family: arial, helvetica, sans-serif; font-size: 24pt;\\\"><strong><span style=\\\"color: rgb(53, 152, 219);\\\">x<\\/span><\\/strong><\\/span><\\/h1>\\n<\\/td>\\n<td style=\\\"border-left: none; width: 48pt; height: 89.275px;\\\">&nbsp;\\n<h1 style=\\\"text-align: center;\\\"><span style=\\\"font-family: arial, helvetica, sans-serif; font-size: 24pt;\\\"><strong><span style=\\\"color: rgb(53, 152, 219);\\\">-<\\/span><\\/strong><\\/span><\\/h1>\\n<\\/td>\\n<td style=\\\"border-left: none; width: 48pt; height: 89.275px;\\\">\\n<h1 style=\\\"text-align: center;\\\"><span style=\\\"font-family: arial, helvetica, sans-serif; font-size: 24pt;\\\"><strong><span style=\\\"color: rgb(53, 152, 219);\\\">x<\\/span><\\/strong><\\/span><\\/h1>\\n<\\/td>\\n<td style=\\\"border-left: none; width: 12pt; height: 89.275px;\\\">&nbsp;\\n<h1 style=\\\"text-align: center;\\\"><span style=\\\"font-family: arial, helvetica, sans-serif; font-size: 24pt;\\\"><strong><span style=\\\"color: rgb(53, 152, 219);\\\">-<\\/span><\\/strong><\\/span><\\/h1>\\n<\\/td>\\n<td style=\\\"border-left: none; width: 6pt;\\\">\\n<h1 style=\\\"text-align: center;\\\"><span style=\\\"font-family: arial, helvetica, sans-serif; font-size: 24pt;\\\"><strong><span style=\\\"color: rgb(53, 152, 219);\\\">x<\\/span><\\/strong><\\/span><\\/h1>\\n<\\/td>\\n<td style=\\\"border-left: none; width: 6pt;\\\">\\n<h1 style=\\\"text-align: center;\\\"><span style=\\\"font-family: arial, helvetica, sans-serif; font-size: 24pt;\\\"><strong><span style=\\\"color: rgb(53, 152, 219);\\\">x<\\/span><\\/strong><\\/span><span style=\\\"font-family: arial, helvetica, sans-serif; font-size: 24pt;\\\"><span style=\\\"color: rgb(53, 152, 219);\\\"><\\/span><\\/span><\\/h1>\\n<\\/td>\\n<\\/tr>\\n<tr style=\\\"height: 44.8px;\\\">\\n<td style=\\\"height: 44.8px;\\\" height=\\\"20\\\"><strong>Survival &amp; Adventure<\\/strong><\\/td>\\n<td style=\\\"height: 44.8px;\\\">\\n<h1 style=\\\"text-align: center;\\\"><span style=\\\"font-family: arial, helvetica, sans-serif; font-size: 24pt;\\\"><strong><span style=\\\"color: rgb(53, 152, 219);\\\">x<\\/span><\\/strong><\\/span><\\/h1>\\n<\\/td>\\n<td style=\\\"height: 44.8px;\\\">\\n<h1 style=\\\"text-align: center;\\\"><span style=\\\"font-family: arial, helvetica, sans-serif; font-size: 24pt;\\\"><strong><span style=\\\"color: rgb(53, 152, 219);\\\">-<\\/span><\\/strong><\\/span><\\/h1>\\n<\\/td>\\n<td style=\\\"height: 44.8px;\\\">&nbsp;\\n<h1 style=\\\"text-align: center;\\\"><span style=\\\"font-family: arial, helvetica, sans-serif; font-size: 24pt;\\\"><strong><span style=\\\"color: rgb(53, 152, 219);\\\">-<\\/span><\\/strong><\\/span><\\/h1>\\n<\\/td>\\n<td style=\\\"height: 44.8px;\\\">&nbsp;\\n<h1 style=\\\"text-align: center;\\\"><span style=\\\"font-family: arial, helvetica, sans-serif; font-size: 24pt;\\\"><strong><span style=\\\"color: rgb(53, 152, 219);\\\">-<\\/span><\\/strong><\\/span><\\/h1>\\n<\\/td>\\n<td style=\\\"height: 44.8px;\\\">\\n<h1 style=\\\"text-align: center;\\\"><span style=\\\"font-family: arial, helvetica, sans-serif; font-size: 24pt;\\\"><strong><span style=\\\"color: rgb(53, 152, 219);\\\">x<\\/span><\\/strong><\\/span><\\/h1>\\n<\\/td>\\n<td style=\\\"height: 44.8px;\\\">\\n<h1 style=\\\"text-align: center;\\\"><span style=\\\"font-family: arial, helvetica, sans-serif; font-size: 24pt;\\\"><strong><span style=\\\"color: rgb(53, 152, 219);\\\">x<\\/span><\\/strong><\\/span><\\/h1>\\n<\\/td>\\n<td style=\\\"height: 44.8px;\\\">&nbsp;\\n<h1 style=\\\"text-align: center;\\\"><span style=\\\"font-family: arial, helvetica, sans-serif; font-size: 24pt;\\\"><strong><span style=\\\"color: rgb(53, 152, 219);\\\">-<\\/span><\\/strong><\\/span><\\/h1>\\n<\\/td>\\n<td style=\\\"height: 44.8px;\\\">&nbsp;\\n<h1 style=\\\"text-align: center;\\\"><span style=\\\"font-family: arial, helvetica, sans-serif; font-size: 24pt;\\\"><strong><span style=\\\"color: rgb(53, 152, 219);\\\">-<\\/span><\\/strong><\\/span><\\/h1>\\n<\\/td>\\n<td style=\\\"height: 44.8px;\\\">&nbsp;\\n<h1 style=\\\"text-align: center;\\\"><span style=\\\"font-family: arial, helvetica, sans-serif; font-size: 24pt;\\\"><strong><span style=\\\"color: rgb(53, 152, 219);\\\">-<\\/span><\\/strong><\\/span><\\/h1>\\n<\\/td>\\n<td>\\n<h1 style=\\\"text-align: center;\\\"><span style=\\\"font-family: arial, helvetica, sans-serif; font-size: 24pt;\\\"><strong><span style=\\\"color: rgb(53, 152, 219);\\\">x<\\/span><\\/strong><\\/span><\\/h1>\\n<\\/td>\\n<td>&nbsp;\\n<h1 style=\\\"text-align: center;\\\"><span style=\\\"font-family: arial, helvetica, sans-serif; font-size: 24pt;\\\"><strong><span style=\\\"color: rgb(53, 152, 219);\\\">-<\\/span><\\/strong><\\/span><\\/h1>\\n<\\/td>\\n<\\/tr>\\n<\\/tbody>\\n<\\/table>\\n<ul class=\\\"todo-list\\\">\\n<li data-checked=\\\"false\\\"><span class=\\\"cb\\\" contenteditable=\\\"false\\\" data-mce-noneditable=\\\"1\\\"><\\/span>CALENDARIO<\\/li>\\n<li data-checked=\\\"false\\\"><span class=\\\"cb\\\" contenteditable=\\\"false\\\" data-mce-noneditable=\\\"1\\\"><\\/span>VINIL DE PUBLICIDAD (QR WHATSAPP API ) DOS NUMEROS<\\/li>\\n<li data-checked=\\\"false\\\"><span class=\\\"cb\\\" contenteditable=\\\"false\\\" data-mce-noneditable=\\\"1\\\"><\\/span>IDENTIFICAR LAS AGENCIAS&nbsp; ADQUISICION DE PROMOCIONES \\/ DIVISAS MEJORAR TIPO DE CAMBIO<\\/li>\\n<li data-checked=\\\"false\\\"><span class=\\\"cb\\\" contenteditable=\\\"false\\\" data-mce-noneditable=\\\"1\\\"><\\/span>TIPS VIAJEROS (COMPRAR CON TIEMPO SU DIVISA, NO COMPRAR MAS 10 MIL DOLARES POR LA RETENCION EN EL AEROPUERTO )<\\/li>\\n<li data-checked=\\\"false\\\"><span class=\\\"cb\\\" contenteditable=\\\"false\\\" data-mce-noneditable=\\\"1\\\"><\\/span>POLTICA DE DELIVERY (RECOJO EN OFICINA \\/ LLEVAR A LA AGENCIA DE VIAJE)<\\/li>\\n<li data-checked=\\\"false\\\"><span class=\\\"cb\\\" contenteditable=\\\"false\\\" data-mce-noneditable=\\\"1\\\"><\\/span>CONDICIONES ( oPERATVIVA)<\\/li>\\n<li data-checked=\\\"false\\\">&nbsp;<\\/li>\\n<\\/ul>\\n<p><span>PROPUESTA DE VALOR<\\/span><\\/p>\\n<p><span style=\\\"text-decoration: underline;\\\"><strong>NM Viajes (Pasajes Internacionales)<\\/strong><\\/span><\\/p>\\n<ul>\\n<li><span>Cierre precios por la venta y \\/ o compra de Divisas (Politica, terminos y condiciones) Ejemplo \\\"El cliente se va de viaje a Europa Cerramos una operacion de venta por el monto de 12.000 Euros.&nbsp;<br>- El precio deberan respetar ambos ( BIdex-Cliente)<\\/span><\\/li>\\n<\\/ul>\\n<p><span>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; - No podra Variar el monto ( ES deir que el cliente&nbsp; al dia siguiente se entera que bajo el euro y solo desea compra 2000 Euros)<\\/span><\\/p>\\n<p><span>&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;<\\/span><\\/p>\\n<ul>\\n<li><span>DESTINOS<\\/span><\\/li>\\n<\\/ul>\\n<p><span>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;-&nbsp;<\\/span><\\/p>\\n<ul>\\n<li>&nbsp;<\\/li>\\n<\\/ul>\\n<p><strong><span style=\\\"text-decoration: underline;\\\">Indiana Travel Per&uacute; (Pasajes Nacionales<\\/span><\\/strong><\\/p>\\n<p><img src=\\\"data:image\\/png;base64,iVBORw0KGgoAAAANSUhEUgAAAYoAAAEFCAYAAAD9mKAdAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAAD\\/+SURBVHhe7d1ZbyNZ2uD3P3eKi0RRIiVSoqTUksq1cu\\/qfutt40W3PTbQsIEBDHsA+2YAwx4b8NSFjXkHxmC6P4i\\/wFz52le+qKquqs7MqszKRZmpJSVRpLjvpLgESV+QkoJBMkQplVnV3c8PiAvFOYw4cSJ4nohzTlCGP\\/7xj22EEEKIIYzaFUIIIYSaBAohhBC6JFAIIYTQJYFCCCGELgkUQgghdEmgEEIIocvw5ZdfyvRYIYQQQxn+4z\\/\\/ewkUQgghhpKuJyGEELokUAghhNAlgUIIIYQuCRRCCCF0SaAQQgihSwKFEEIIXRIohBBC6JJAIYQQQpcECiGEELokUAghhNAlgUIIIYQuCRRCCCF0SaAQQgihS349VgjxC9ckufOOtxlFm3DK7Gbl5hIBizZBXAZ5ohBC\\/MLliGcUjDYH3gl3zzJuM3SyNItsv9zhsKH9rLgMhv\\/l33zZnnSPYVWFjFajTr2lztZhtloxd8\\/LMaVeRxn4TGLEajP3R6LWEckcTHnH+tMA2k2q9aZ2LRjN2C0DP3HqKE+y7cbnGJ6vXsxQNHuZGlOvbVEvFkhWGoCJMfc4Hke37M06VZ0bmY7+Y60WclTtHjxW1Uo9g\\/ZjMGG3mjQrO85d7wzZB2C0WHvOP7So1xQGXAKqMinkMlUcXhcDD7FdI52DqUlbd8Xgbfbvu6tdI51u4J4+3v7gz8MFyzSkLnp167KlUG0M3DOYrdgHn6JPo92k2mDodXJpGiXiJQszJ+fzU0rz8kmUqn+FhwuOnpTC\\/lt+SlhYuWYn8jZN1ehk5dayPFlcMsO\\/+C\\/+0FbaJlwzC3w278LIEdsvtjhsmDCrv8CtJkrbhGduhVuz3YulEuXJ6zR1s2lAw2Rj7voKIc11ldvd4GUKfGvXWZ\\/oTQMgtcvXu0WMPdtsoShtjGOTrF+dZ2rIRXD47gXbBPnHq1PapK4K2y+2yU6oLrhGjo2NMOmGAbOps8dWs0nLZCewdIW5oz2exWunm2g3UZpoyqc5ViXJT89jFBwz\\/Oq6f3Cj1WNQnXeOGaMV79wC12ZUgfUC9Q4Q33zBZuH0OKF7PC0Trtkl7s5162TgOegyuln7LMRUOcqTjTQM+PICkNzh6z1YebhMgMHbbDWbtNpgdk2xthxkSl1RI3z+xAXKNHm4PfJ5te4PqLcu48Qcv7oy6EL+NEr7b3mWgMD1dVac2tRLpD0fn9QIgeLhMoFSlCdv01TNk9y6M4+nJ6f4EIb\\/+M\\/\\/rl3JRHlz0GbxsxBTgxpTAFqUotv8FG0TuHWVK3agHOXJRpHJUS9SJclPz1O0xqBknObX13yYtXmGXZD1PBtv98mOhfiH1cGXwPkDRY29V++IGH18tj6L67gdaDcpxPZ4V53iobYRGFY+ldzuBi\\/LZhxVBffaddbGtTm0tOXqajcpJMK8OShi9KnSzlvvXcPqp5rd4+V2EefyLa57RzvGThnSVDEPDvrabWj\\/7mpVc7zfOeCw5ui9E9Tm1\\/49yHnLNGLasHr7RTjrCf2y6NTPx3dWoKj3rAPnz1TOv11GMOLwznP\\/sxD6XwMjruAsU+Ya2bT2xIymEstSsHm4uuzBUcoSrmpz6LBOsOaz0yrkSWrTLqqWJX1kYiqoChJ0ujLGA8v9QWIU7RzRTBPv7AqhiSbJRE6bY3QGE+MzS9wNOagn9tgsaDNcDvvkPDPONvl8UZt0BiueCSPJnYv3DRvtHlauLzNjLrO9neTM3qAzfXiZ\\/qoYx\\/B97CDxCzbu8xHwDhizEJfqQteX0XSR\\/tASkXSN8Wk\\/DrufGVeNZKykzXQ2o5GL7H24Fs0Pb51OKPE0GZOH4JQRn9+DOZ8m8oHbt\\/r9TJkVstmKNumSmDAboNUaMDZ0hrHgCivOCttbCS52+wAYHFzx2aFUIDlw3OV8LqVMn1IhypOfwiSP0my82uDPT1\\/w52dveZ1QdY1RYvvlBm8zNQ433\\/LdDy94dqicfDYNUInx7Kc94trrTcmw8dM24VpnnCa+v8sPP73u7meDn\\/bzvfXUPt3H1z9s8MNOmkrfeWlRiu\\/y5NlLvn76ku9+esdGT3k\\/kTEvK8tL3FjrLEsTQ\\/qlxQc5R6BoUYrGSDdtTHrUTXULpV6nWtMs2sG\\/dIpk001gxgSYmPO5UdLx0RvRep7NZBWj241Xm3ZRNh9zE5DZ3eD1QY7csMHSkdUIpyo4pnyd\\/tFxHz5bhcjBBQJiDzfjdqjXjlTrRqz3UdQTxMvgcrpVK9so2m3X6lT7YomZwHIQbzXOT\\/sXD2Rm1xhWFCq6m\\/i0ZerRavbvtzZsQsE51apU63k2N3PY55e4f2udGwEbpfA7nsWOvyA1jqoK6b0d4hYvV6+tc2vW3P1so9PQj9mxKgUisd4GuxJLkW7bcNuAfIJwxczM4hXu31rn\\/sokrdQ+b2LHlVhj7\\/U7tis2QmvrPLy5xJI1x8tIbz0W9jd5Fm0wubDCw1tXuRa0UQ6\\/46eT8n4sJfY2d3ndt8T4gGd3cQbD737\\/h8u41IUQ4sQXD25hMFxWN5B6jKLK66cRMtpWy+Bm7cESY+rBbU0WcXEDXrjrDKymXQt8FuzMIa0WE+we5Gh5l7mvHkwadVC1cMBf3lXwHQ+Cdymxbb6L23pnKCR3+HqvzeLtED6AZo1k5IBweYwrZ7xQc\\/ag45BB42PtJtWjCulEjHC6CpMhfr2sGTgfOqjXJPLmNXtm7WB7ic3n7zmaucFns8M6zc4oF03CG6\\/ZM3WPbdR61zh894Ltig2vszu9yGTF7bRgd3nxOVVlG3qMKgPKUNh\\/y09pS2dQOnfOweh8mO82K\\/iOt6fNr\\/17kPOWSU1n+2dfV\\/2U1B4\\/HJRVT6gWAlfXWBx0eoftO7PHn3cUrjxYIWDoNJYs3uaWT5VH+9nqIT+8zOG+2p1Ekd7lz3strny2TKA7c6TVKJHOHFFHoVSoUS4XqTg6x6fENvkuZufG3VDvk3tim6\\/3DZ395MN8t1ll7u4aIfVslNIBf3lTZurGOiuDjvPChg9ma\\/XMgtImigsb2vVkNFmw26zYbVY80\\/PcvTKBcsEB1WQiR50akZcv+PrJ6fLdQQUaOQ6S2r4DA+buvu0ON6G1NUK24iUNduowmLA73MwtrXE\\/aEfJ5ohr8wxTTRAvQSsX7jnGr5+8J96AQjLOBaquo12keASOnq6hC3JMnfTn3lgOEprx9QaJDzC+cPGxgUrxCMVoZ\\/wcgW8UH1KmD2H2zvHZ9VXuniyLzPW8uzMCkxEjLRTt10OP3U9g\\/HgSRZNIsojZ6z8JEpXoJn\\/+KUykogBmXONOnKrGXmm2wWjon42ofjpotmhhxKy9bAzGToOivdu\\/VBleP+1tR75+8oKvn+6O\\/l0V53YSKFqtM\\/q2JwIEnArxyDm\\/cNUY4byJqeV1Ht7uX9a9JnLxBPo9yWZCQQ\\/WUortvDbtQ7QYdtjWAXPm9SQjaSpOH3cHHOPDGz5c9QwHae2nRlPYj5NpO5iZOfuNjJ+Xamwgdo4pR400W4kaVu9U5ynyUl2wTB\\/KaD650TpetC+r9qpR0txJdIKnFXtfq63HRGC2O4milCBesuGbdXXTjjhMV7FOL3L3SoC5GR9zM14cqgbfPmbDWD8ir6mqTEk1RdFpw06NnOa7qBTLVA02XJcc7HtZcY73vp3tnXDjHbcz4NUhcUmM9UqR8OYGf\\/5x\\/4yIbCa0MIW9nGA7o16vP6iai2Wp2Dwsenu\\/NMeLL+jBUc0ROet2eyJIaLxJ8iCmH1TOM+iY3ufPP27w+rBI6fht8HaTSv6QnyIVjB4PM9rPDKIkOcyB1z+La8Ax2h2znUHzpP4TUavZ6ClzKZ9kc+M1P6WaeBcWmetpMPTr\\/cONOnCsYfZyY20K6oNuJ7TbLJE82OUvP0UpWKe4tnjcoA2j\\/fxllGlE57muLkQhvn9Arnv6WpUEW8kLBs\\/uJIq9zTQV1yShk+7eMRw2qFdKVLvlrucOiJdVn\\/VO4bNUCW8nKB2XpXjATkZVyTYfcxMt0uEwJzPl62neHFaxeqdG+85cmIvF4yfinmVWXrD7iExWt\\/9PRYOTpasLBCwGoE0xlaZimyKonWpmdWM5ShDOt5j1uTC1yySSJXKZNNGEZonnaU5ayB1kscwsMd\\/zooKK2UGrECdasxOatEOtwEHOwFTQQ2+zYcTtbJE6TFF2+PGpxjqO1fNJUvlSf1kSaVLNcYIT5t5jc4zjNR0RjycIHybZjybYP0xymK1hmw5xa8nTfxd4lGc\\/b2BaVb56LMpO1c3KlXEGFAsAp7lO7LBEyzdFz6Qx6NR5Ok22kO8pcyx\\/RNM2ydr6Movjqvo7s96nmRwwllPNJUkzzkLv75f0axQ4yJTIabedSBONHzEW9OBsl4klatj903i1+7K6cSk54kdW\\/AEPzmHbTObJ12E8eIV7y17s6rrWXgeDPv+hZVIbcF6P6V1XBxUbC1PDzvqIKln281YWQ7D3JsxeLMF+okx7PMitZQ8WA0CddKyAwTODT91Nr60nAMy4WyXCeYWp+SvMqE63e9xGOR5lO5IkmkhweDSOz3lE8eS6sDI1YaaYjPH+IMFBLMF+wcpKwEq6ZOzWnRGX10U7m2A7HOMglmAvXgLPHLevDPjOfLAjEtEiitPb3yZp1PJp4mUT3uAkl9BRK7oM\\/+Gf\\/327rwlvtWgZu\\/2NfVq0WkaMgxP7tVqMlLkNdC8w3Y\\/oJo5g6LF1f0tohN+U6i\\/CiHWiOsafRbvTt2y8pDK0Wi2Megf9gcfbX89n+5AyXWR\\/l0IzIK3U62AZ0FV1zgLq1kWzTpXu71QNuy7UeYbtvt2kWm8P\\/32xS9EZzC7YHHjO+GEtpVqiUHPIYPYl6zvv0Fk7cD0AIzSIaqNmVl2kuh\\/RTRzB0GMzYrVZzwwSDCzCiHWi\\/SJ+aoYBjcEHGNoIHfvAfZ21+UE+pExnffRTGfTjm3D+AurWhUn1Y4bDrgt1nmG7N5iwf9QgAeBhxmumVauQyRd1l0KtjdXrPX93ndA1YHqsEOKTyu3x5+02aw+WpIETv0gf90ZACHE2zyL\\/IEFC\\/IJJoBBCCKFLAoUQQghdEiiEEELokkAhhBBClwQKIYQQuiRQCCGE0CWBQgghhC4JFEIIIXRJoBBCCKFLAoUQQghdEiiEEELokkAhhBBClwQKIYQQuiRQCCGE0CWBQgghhC7Dv\\/03\\/6v84yIhhBBDGf74xz9KoBBCCDGUdD0JIYTQJYFCCCGELgkUQgghdEmgEEIIoUsChRBCCF0SKIQQQuiSQCGEEEKXBAohhBC6JFAIIYTQJYFCCCGELgkUQgghdEmgEEIIoUsChRBCCF3y67FCiL9CZfaevWO\\/1NQmnBrzc\\/f+Am6DNkGclzxRCCH++hTTJEpNzM4JvJO9i8MCGIBqgmdP9ynKrfAHM33x69\\/8qaE0UbRL04DZrIojzQa5dIp0vkyx3MRks2E1DQnVI+dt08hniWUKFItVmkYLNquJvpyVLOnGWOcCGKCRz1A0jWE3dVcoNar1M45nmGaFZLrBmNPSX45B2lXSqTr2UfKPXC+MXjdDtSknszTsY1gHHXa7SbXW6D\\/vbRPmoWWCVqNIKp4jVyxz1DBis1owqbbfyKfItRw650qTXskSr5hx2U39aYM0iiRLRpwnJ5tz15VSyZNM5skXy9RaFmw2M8ZhmQeo5jKUDGPYzdqUrvNef6o6gM4xxrNtXI4hO6hkSdbsOK2dQvdd\\/xqVVJbG2BgWhpxzzdI2mFXn9NPW7cjqeaLxMo7F29xansLvP10MuSgZ\\/NxYMpNNZogmFLyBCWwfoxx\\/Jwy\\/+\\/0f2kaLqf\\/RwjjB1UfLTAGNxDY\\/bGapG0yYTQAtlEYbs8vP1ZsLTJ18sRukN9\\/yJlGldZy33UJR2phdM1y\\/HcJzfDEXIvz4+pCS6gvUUpq0zG6Wbq8TchxvEw5fPmGr6Gb14TqBvkakzPaTDTKT13m04gQqbD95TbR+XNbTMmC04V1a4XrQ0X+8XbnN57yIg\\/\\/mHdYntakDxN7y1Ras\\/uM6AW2aSnHvNS8PKijaevHMcedmAIf6Im5k2Hi2Q6quqRuTg+DaGiunFT5cbpfvX6bAv8bnVye0qRDf5KvNPL3nvnNejc5prt1aUp1XoJFl8+UOsXIbo9nU+fI3O4HFNbfKnSU3xr5z0e\\/w5RO2WOC3t\\/x9fx++fMJWM8Rv7swwuIlsEnn+Izuo8pzjOqJdZu95p7vi5LibTZS2Be\\/yOjcDdlXmIZQ4z78PU3DO8eu7AfrPxPmvv+L2C55lJ7j7cAE3Z19TvXXYqfMofu4+GNTNkuDF1\\/uw+pDbnkOeP49ROUnrnG9MJtQxzBG8wZ2Q7dPX7XkU93n8PIF99SG3Z3uTDl8+Yavq5+7DBeyxTZ5s51FceteVOIvpyvKDP638wy2uzwcIqZe5SRwARxGevUphDt3g0a0FFuYDhOaDLAYnIBMjb51hunvBJDeesZEy4Vu\\/wf31+e62goR8dmqpOCXbbCfvUYSnzw+pTYS4d3eN5VBnnwtzHoyZKLsHRayz07i7X7RSIkrmqE4mbyA466b3xqlBNpriaMzHnNcK1MlGUzSmr\\/H57YWTMiyGZvCai0TeHxBrTHTzaihx3r4rYXFBtmBgbtY1NKCcKKXZz4B3YbrzJR+gsveSHw\\/qeK7c5P6N0EkdhrwGsuEI+3kzAb+ze1xV9n56S9wU4N6D9dO6Cc3gJUe4YGFuaky7C40mkbc7FKwOyJUwBH2Maw+klGI\\/Y6P33AdZnBmjHIsQLtpZ8HX3086w8ZcdEgYvN+7dZH2pmz8UwDdWIxktY5+bxNF3LvqVElEyTLDo7wQS9d9ua53YQY6mz89kfwsMRxE2dytMXFljxnn+6yj55gXbtQlu3LvF+qL6GKrE4g28M+4zG5Lc9jbhth1HpcjR+CxTfe3f+a+\\/ejZBrGpnNjiBjbOvqd467NR5sVomU3My31egMon9PHiDzHjczPZ8z80U9vPYVx7w4Nrp+tkJ889St+fSfaIwe4PMuHqTSokomVKZ2H6Ug0yNFoDRzvRx\\/Ypz0zYffaqJLBXzJEsLmrtws5PQrdusT3X\\/Pgqzn4bx5WusT\\/eeDuOYl7V7d07yJt\\/HqNj83Lo5g0Pd6pschD5bxW8qsrOZUSUArgm8RxGebZd714\\/KYMIdXOP+spP64RabOW0GqBwkKYx5WV\\/34igmCR9pc1xAO8P7SBX77FVuBu09dWh0BbhzzYs5F+ZdoruymiZVNjG9OIdTXTcGE+7QOo+ujvCYcxQlVrTjX1\\/GP1YmdlDV5hjONsnarINWLkuyu6qyFyXVdrJ6Z5mpnlNrwOFb4kH3yfODeWbxO6okwnltCgC5gwwVh59FX+fv811HGVLZNq7ZpcHH8FkAbRPbp50hklTwzl1nYVIhEdVco3pGuP4+hN0zgTG5xYtYQ5t0IZ+8bi\\/RdGgOv3bMQnyQMwMFHD9Calf2Kh\\/mqBg9BPv7hjRSJLJtHL6ZgXdLGCYI+e09DRUA5glu3vRDbIu3WXXC+VgCQaYtDTIpbcApEklUGZ8J4hgLMuuukjgoavJcQCJNpmXHPze4K4bJIH5Hm1xa3ei0UD7g+547yFBx+wiN2QnNOKkkYpy7XTIZuneAFQ5TVYyTMwO6\\/S5bp7z1ZJSIoklqZ4gkG53zAxe+jlofULFKNE7GPMWc34AvOIU5G+8v5xmGX38faCzI3RUXhe1Nwhc\\/xK5PX7eXyTIRYP3mGje7S3DIV0+MzggtlGqNqnbpfgHsc7N4DXnePNnkfbJItTE4YhQqNRizD76w1IoVKm0DDsfwh0CH3QKtCgXtd2l8gWsBI4k3bzm88DU5wfgY1KuajSdiJJQJgkETYGIuMIGSODh3Q6BVLFXBOIZj6C2VHbsVWuUSZQD7LPOTkNl8zqvdDLlqo\\/PoPKrju95Apz\\/WHJzBq6TYi+hMI1SrZdmMVTCOe+g8u5SoVMHuGP3b1mrW+6+n7qKcUQxzcIZpY\\/9TkBKNk+H4\\/FzkOvIyP2ujEtngx8042XLtzJufXlXC8TIO\\/yweuk8\\/Y2UO3p\\/3ZmLI9XcJLLOrrHqO2H3+gTN9PnndfqBqis1Xm7zSLpspzvEsLXQYfvf7P3zKUyqE+Ds0MeHms9vr2tUXpx7Mdu\\/z+MdEf1Cw+7n\\/cIGCanD7zBtZMZDhd7\\/\\/V+1hsysGUmqUCzmi+1FiZZi+eo\\/rPoi\\/esK7oxFORrlzUh1rD7k5o03sir3lq60mS7++QcisneUBKClePd6l4r\\/OoxU0M23OmnnTJPzsR3bNqu3ldvn+ZQn\\/g1tcUY0TK5ENvo2McftXS527yEHOmKFS3nnBD4d2rn6xxrDDPXz5hC1ljt\\/cDfQP+LWbVCsl0tEI+4kKTC3zm2teba6uIpt\\/eUvBf4sHS6pHGCXO8+9jOG7eYe34QGJv+WqrxdLDZXwAzSrJ3V32Sw6W76+puplSvPpml8rssPpUO6vu+8+l9m84Lu8B5rUH3PQD2R2+f11j\\/vPrzB1X0AWuo15tGtUSuViMnUieujPAg7tz3W4trc5sq13LMl\\/cUNd9p74rc\\/e4M3fckX9WHfRff5cx66lnf8V9Hv+UxL7yGbdns6eznjSzg3pmRKnTPmndXpDOrCct9Swo3bZJDDXaGIWa2YbTO8Pa3VssOZukEikAJlx2qJbIndVV43ThMkKpMPyRPVuogN2Fp+8C7DJPX3y8op2nUAGH+3TKaDKapk6Vg6dP+Orr0+Xb92WopwnHzugv0eF0OzC2KxSGDhLkKZTB7h7vDxJ0BkHtzgnm1m7wcMGBkk4T1+Y5loiRqEPl4GXPcXz1XZhCu0HiIEHv6TFittuw223YnROEbt5gwZZn63Vclc+NywHVYkHz2Y\\/IPENwEjKHcRSaRPYzKJMzp0GCy7iODFjsbnxLa3x+bRJzKcPhsN6goyixIrQyO731+vVbYnUoHEYYXgqNAddfH4MRaMHAZ\\/0minKcZwj3woeNV3zKur0M5X0e95yX7vJkv9OdKz6YztXW1WwP6SO39My9ts\\/5GDdUiO0OOTUn2\\/ES8FmoJw8GjzM0Euynmjh8fv3ofzJesUPmHO14cTtCpu1kdq7b\\/3oUYT9rZnr9No8e9i\\/Xps3kolHV3PNz8vnxWxsk9hMMPNzDKCnFjv9kxK1Na8jxWMx9k+RVquxF8pinl\\/uO4dHD2zxan8ScS5wxk8tCaNGLtRhj+yQA25jzO6GU4n2hN\\/exVnNgi\\/ZBfCEf9mKM97EosaIFf1D7FHX+62hYvTLoPSKV5G6CiivAfW2dPrzNo3sBXLUk+8ez1s7Qd\\/0BSlMBk+n0nYwpFy7KxCIDDqyRIFWGcY\\/+7LfT8Yp4f5fMmT5d3V4KkwOP5u1s7+QE3gmHZiq9uKgzB7OTb57yzeNNwpnKyTqUKtndDXYKBqb905115hlurLipxzb4\\/tUh2XJnELbVqJANb\\/L9d0\\/Z6N4Ke1ZXCVrLbD3d4H2m2hn4ajepJPf58ek+BaufqwtDR39PuJevsequUx1wMWsHVMuZOJvPfuRZXMG7snpyd5o7SFEZ87Lo695ZaxbfohdHJUNk6BMBnVlK2vo7qUM3a9f8WIv7PPkpTLbS\\/UYpVZLbr3myU8Y6e4XF4y6vxBbffPecV+E85Vo3b7tJJRPm+W4Zo3dqcBdWLkasbMe\\/6O07Brvdht0315l6etZMrslFFjwKid3ISXA0z62y6qkTe9EtV6Pd6V4o5wm\\/es43320Nf8q5KPccQXeD2HacisvP0oC+v3NdR5UwT7\\/7kR83U6oJAm0a+RQb71LUnV4Cg3qKlDjRDHiDczi1dWq3YXfOdSYfHKqfwka9\\/to08hF2U02srvHTKaTmAPNTBkp7r3kVLdJoHueN8+rHCCXj5Omg\\/lAmZm5cI0jtAoHiE9XtZbFPs6aa5XSyrE1\\/0mm5f8sM\\/\\/nv\\/9Ae+MRgmODaF2v4mhUimzscZKrU1RktToIry6xo3plopMO8eZ8gV1XdZZpseBc1b6S2qxy+3mQnV6N1nNVgwuELdU6w6uY5ufGUN61FfnuzG5TUuuMV1eBtHizagBp7z16wX9LkM5mwu6dZXgup5npn2fh2m\\/qCuo9Zq9s\\/bVvhi2sD7uLS23yzkR381NUdTHMCVBK82giTOVLVi8WOf2mN9Rl1HbYpR3d4c5CjUlflNZgYn11ifXmyp26Opd885XVtXvftUyWywbf7Vm78ZoWp5DbfvGuxOmjs5CjC0x9iOK494PrJCxIN0rs77ESLVFUHaxybYGl9lTmXoVP3P74gMXGDR8uDe6Tjr56wZVzmi+udJwTdc5vc5pu3ObzrD7jefXeizzmuo2oqzOZegpz6HBgM2D3z3Lg20\\/veSldj\\/zXfxRz641S5Xb5\\/WWH2VzdYtI54\\/VXCPP4hTtVgwO4JcfOGv\\/ftfBqkt7d4Fyv3zCAyu\\/1cvaH+NYQz6rw7XuG6OqgOO+NPrA4Zi\\/jIdftBZIzikzrfr8c2G1QbLUwWG5azTny7SbWmjJRXqdVQjFbslgEtIEC7TQvD8N+MadP5EbCLaLZB57eNTnzIPtTOUS+dQcE6TZNO3Rw7q46OqY6j1QTjsDLo1YtSo6oYsdot\\/d0KzTYtk6F\\/\\/TFtObV\\/a7SabYzDyqFx5nWkotRqKJix24ZVwLE2raZheD0du6zrY4BWo0a9OaS+GaXOdcqmd55VPk7dfoBuoFCcE4wP\\/hGAE9VSnopJAsWHOF+gEEKIX4QRfmb8mMGEK3SVewsfs\\/\\/rb5sECiGEELqGPq0KIYQQSKAQQghxFgkUQgghdEmgEEIIoUsChRBCCF0SKIQQQuiSQCGEEEKXBAohhBC6JFAIIYTQJYFCCCGELgkUQgghdEmgEEIIoUsChRBCCF0SKIQQQuiSQCGEEEKXBAohhBC6DF9++aX84yIhhBBDyX+4E0IIoUu6noQQQuiSQCGEEEKXBAohhBC6JFAIIYTQJYFCCCGELgkUQgghdEmgEEIIoUsChRBCCF0SKIQQQuiSQCGEEEKXBAohhBC6JFAIIYTQJYFCCCGELvn12J9DJcf\\/Gz8i3NImnPKPT\\/Df+Bza1UII8cnJE8XPoFisEm4ZCNotrPcsJtwABkgU8vw\\/8Yr2o0II8cmZfv3r3\\/xJUZq0DWZMg8KGUiWbSJMplClW21htNsyD8gFKJU8ymSdfLFNrWbDZzBgNmkztKum0gsNh1iR0NYokS0acdlPP6jO3XckSr5hx2U008ilyLQcOiypdS72fZoNqXUFRmv0L5qHHe1H1colXdTP\\/sDjN7XEHiydLk2S2gdE1zn9mrPOiUmWvYeK6S+9AhBDi4zI53d4\\/xQ5j7IfjZNrjBDzWk8Ti3mt+2IgQy5cpFovkMykO9qPEima8PieW44a6kWHjh1e8O8iQLZUpFIqkYjHCBxnqjkmmHKpGP77N03cRClYfM67eYABQ3H3Hy0gDb3ACG0C7zN7zV7zaS51sOxOPsR9OUrJ48Ls7Aefw7Ss2CzYW\\/U4SW695mzIxN+sa8sjUJPLyJZs5K3OzLpIbP\\/LifZJEMkUsnuxZElU781Nj2g18kE6gMLLqdTDRk1JjN9ugah3j84AL39ERLypVMoyxPDb4SIQQ4mMz\\/Y\\/\\/w7\\/6UygUZMZRIbZzQGEsiM8JJLd5slNn8toNHqzPE5oPEJoPEvLZqcaTNCZ9TJiBdoaNv+yQMvu59fA6VxcChOYDLISmcFXTvN9PoXhm8Nq6eyyl2c\\/UqGaLGAM+JjSxop5NEKvame0GiuSbF2zXJrhx7xbri51th0IBfGNVYvEG3hk3ZqCUiJJhgkW\\/E7e1TuwgR9PnZ3LQzfhRhM3dChNX1phxQjERJWNf4Iv7q93jPF0uO0gwQqCI1Kv8kK2wrXTWmsxWeaoQQvxsTm5T7dNLzLra5LJ5AJKpHC3XNGvTxy18h3HMy9q964Tsnb8re1FSbTerdxaYVPcmGWxMXb3GkrNGdCtMb2+7A6\\/niN3n+xR1h9IzpLJtXLNLTPUUw4DDt8SDzwJ0i9HLM4vfUSUR7hyLVu4gQ8XhZ9GnTfm5jXHPY+0fsxBCiJ+Rqj\\/DhNkIrWbzdFVLoX761wAVDlNVjJM+AgOHHCyEghMYK3mSVfV6E94b1wiS4PXm4MZcraU0tKvOYCc046SejBLp3pWfaGeIJBuMzwT55c0psuCZmuK3c9PdxY5fm0UIIT6x00BROyRWBNd4pzPEN+\\/DfhTn+bNdIpkKVW2DC0CJShXsDqc24dSYDStVStp4YHCysu7HmNziRWxYIPAyP2ujEtngx8042XINRfcJ5JQ5OMO0sUzsoCdCoUTjZJggGNT0eTWbVKu1vmXU\\/V3UUS7DV5FU3\\/Ispx+ihRDiUzH87vd\\/+MhN4V+\\/1ZUFAoHLu7cvxmP8p5KZ\\/3JlGk8yzn8q9L9QMTU+yb\\/01fn\\/tsvkXB7+5czlj5UIIcQoDP\\/tf\\/+v2+PjNuzuaXzu\\/llIx1qNGoVcgshunEzdwcL9GyyOpXj1zS6VwA0eLQ\\/pyCnu8\\/h5mvGb91ifBGJv+WoLVv9xnQAATeKvnvHuyMfdBwuw84Jn2QnuPlwY0D\\/fplEtkYvF2InkqTsDPLg7hwM4fPmELRb47S1Vg67Eef79Aea1B9z0A9kdvn9dY\\/7z68ypusoGfvYjUgeKkDaxR0EChRDiZ2e8eW2BUHBGN0gAGC02PL4QNx+uMG2ukDisAG5cDqgWiwzsmQKUfImqwcG4R5tyzMTMyOMVBix2N76lNT6\\/Nom5lOGwrM2jYp4hOAmZwzgKTSL7GZTJmZ4g8XMrJuP839uHfcv\\/0zuoI4QQP5vhk\\/ObQ3qkDFbVC2g25vxOKCZ4X+jNBp13IN7HKhi9PgLaF+\\/UVOMVb7K9IaelGlvvYTHpFP6UL+TDXozxPhYlVrTgD3q1WX5WZov27ezOcsUyytEJIcTHN6Q1qvL+2VO+fbZLPF+j0W2sW40i8Y0dYnU7\\/kCnq8k8t8qqp07sxQs2YsVu3jaNfJxXTzaINdwsr47QOLsXuLviol5VRYZKmKff\\/ciPmyly1Qadnvw2jXyKjXcp6k4vAZ1xdADccwTdDWLbcSouP0vDnmx+psHsMY9XNcvpdLmrevFRCCF+TsN\\/FLCW5f3mAdF8jZYqh9E+wdK1VeZc6keEBuntLbbiZerH47IGA\\/aJIGvXA3jUvVrJbb5512L1izVmVKs7uuMV9Vke3ZvDDlRTYTb3EuSOVIUwGLB75rlxbQZnd9vJjae8aS3y25vTp\\/mOJbf55m0O7\\/oDrg94dyL95imvU4OrgcllfntzhEB3DjJGIYT4azI8UKgpNaoKmG02zHpdSN1B73rLjN02fMyj1QTj8GRod34YT0up1VAYsu12mxaG\\/t+W6mo12xhNQxI\\/sU6ggKDdPGDAXq1FtNrEKoFCCPEzGi1QiMs1ws+MnzCa+O2Mn\\/Uhk8qEEOJjk0AhhBBC15DBbCGEEKJDAoUQQghdEiiEEELokkAhhBBClwQKIYQQuiRQCCGE0CWBQgghhC4JFEIIIXRJoBBCCKFLAoUQQghdEiiEEELokkAhhBBClwQKIYQQuiRQCCGE0CWBQgghhC4JFEIIIXQZvvzyS\\/nHRUIIIYaS\\/3AnhBBCl3Q9CSGE0CWBQgghhC4JFEIIIXRJoBBCCKFLAoUQQghdEiiEEELokkAhhBBClwQKIYQQuiRQCCGE0CWBQgghhC4JFEIIIXRJoBBCCKFLAoUQQghd8uuxQvytK0b48dUhJUWbcMoevM6jZad2tRAgTxRC\\/O0rJjKUFBOOyQm8PYsdM4ABqtENHm+XtR8VAgDTF\\/\\/0T38yadeqVbKkG2M4LJ0\\/G\\/kUuZbj5G9tulYjn6FoGsM+cCdtysksDfsY1rNCVrNBLp0inS9TLDcx2WxYTYbT9EqWeMWMa8COlEqeZDJPvlim1rJgs5kxqj7a0SCXrGBy2ujfAtCukk4rOBxmbUpXm0a1TkNpoqiWtsGMaeCxDc6vKE2UpgGzeeCHTuvf3KRaa\\/R\\/dsj+lVqN+oB0RWljNJswDDq3Aw2pp7POzzAn9WoaXh\\/qBTM9VdOskEw3GHNaGLi39pB6apswa8vXbFCtK\\/15B+23q5rLUDKMYR92WXB23TTyRWo2G5aBB\\/Dh6tkEsZKdxYdXWfZP4T9ZILefh8AKS5YCiWSCRGOCOa9Vuwnxd87w3\\/1vf2xf92lXd7XzvH28ScKxwG9v+YEy2082yExe59FK5zH18OUTtopuVh+uE+hrYPrz98jt8v3LFPjX+PzqhDa1q0F68y1vElVaBhNmE9BuoShtzK4Zrt8O4TF1y8FxOY8\\/mmHj2Q6pGhgtJoxAS2nSMtiZXV9nbUpV4OI+j58nIDCkrLG3fLUFq\\/+4TkCbBhDf5KvN\\/Ml+ON5XG8xuP1evLTBl089\\/wjjB1UfLTGnXq+tzrsDz5zEqJ2ktlEYbTKaeBs0RvMEdb5zHPyaom00DAqSd+TvXCdm7ddgI8ODeHA5ttq7GwWu+220SvHObFXd3XWKbHzaz1I\\/PT7csZpefqzcXUFezVmX3JU+zkzy652Dv8S6Z1mla51wdb7PDOLnE51cnT\\/7ObT7nRRz8N++wfrr61MB67pTP6Jzm2q2lk\\/LFXz3hXW5wkNbuFwAlzvPvwxScc\\/z6boBBh3l23TSJPP+RA8c6n691K\\/SSFbdf8OzQOuDaTfDi632qges8WrFy+OolW9km41fucWdu4O2S+Dtl+N0f\\/nX77sMFBl2ilb2XPA1XwXNGoMgBrkFflv78p7pfkLYDygbmP7\\/O3IC7suTGU95krPjXr7I+fdrSto4ybL8J01q4w\\/rUgEDRzrDx3Q4pq59bdxaYPN52u0Z68x2vkxC8fZuV8e76bqCoYhnc6JwVKIakt44yvH\\/7nuiRqzeYDsmvT68+O196Vh9ye1aTVNzn8fM8XlXjPkjnXBrwrN7l9uyAhuK4Tpu200BxFOHpDzGMoevcWXCcNsZKmfCbHSqB26z3R7yuIpt\\/eUspeI9789r96R1rlxLn+fcxWk4oGWb5zZ2ZTleK2rB6rmXZeLFNxrHMFze8cHz82psNHbnN57woWXBUGozfvMOaR5Nh1LqJveWrHSPXfrOGry+Qf7izAkWuZx3Yh90sib9bRmsryW6sqV0P7QzvI02sozyFuibwHkV4dp4+zqMosaId\\/\\/oy\\/rEysYOqNgcchdlPw\\/jytZ4gAWAc87J2rxMkBqnsRUm13ayqgwSAwcbU1WssOWtEt8KqO3IAG55JI4k3bzls9CRcmHHMy8qda8xaimy9jqMznviLYLaayR1EKGoTjuvUZOlpjKuJLBXzJEvqhhDA7CR0Sy9IANkkqbod77Q2SIymcpCkMOZlfd2Lo5gkfKTNocM2ydqsg1YuS1KbNop2hkhSwTt3nYVJhUQ0o80xet1Mj+Nq5YnF1Zk+hUlCi97+MQshNIzBBReF\\/T2ymrlPxZ0IGecswWF9EGrmCW7e9ENsi7dZbeJguYMMFbeP0Jid0IyTSiLWd2dTPsxRMXoI9vdpnaHCYaqKcdJHYOCVbyEUnMBYyZPUxCfHwjVW3SW2Xh1ySbECDE6uzDqgmCH5C59jZp4KECTB1oHm6JUE29Ems3OT\\/Y1Js4lygeMqZsooNhdeuzZlFEUiiSrjM0EcY0Fm3VUSB4PC2xlMhv7jGYESjZMxTzHnN+ALTmHOxokMugsYpW7MXrxOKBXy2pSPzIIntMzNm2vdxY9Lm0UIwGieXSRozrAbUTUMSpydGASXBzzKDzO+wLXAiHfjx3djgc72zcEZvEqKvUjvk02hUoMx+8BuMX0lKlWwO3Qen8dsWKlS6vtuWghcWzz\\/E9IZzOMOrChUSuq1LZRqjap2GdTgfLAWSm3AvhraVszJysIElWi45+Yh9\\/6QwniAK8dddV32uVm8hjxvnmzyPlkcsL3hSuUajDkucH6BRIyEMkEwaAJMzAUmUBIHgxvrQWpZNmMVjOMeenoZm83+OqrWNI19lXC8jMM\\/iwfAM4t\\/rMzB+95ANXrd2HDYDSjlEgOeqy9VNbbLq1ebfctmrKbNKsQJw+9+\\/4dhV68Q4mdwZWme+XntQNPFqccoxnde8EO0PyjYgzd4tFxSDW7r3GSJvzuG\\/\\/mPf2wHaBB+9pyY+zqPgjme\\/pBl+v4tFse0A3z9A4x9A4BKilePd6n4r\\/Nohb78xwOYBf8tHiyp+hy6A5MO1aBg\\/NUT3h35GTbYrtZbjhSvvtmlErjBo+UhfWfFfR4\\/TzN+815n4HrAgG9x5wXP4tbOIHR6yKDosWGDpseyO3z7qoz\\/ePtn5R+ov\\/5PXc5g9sFYd9vZHb7faLDwq3XMm095xxW+uO49e1tKjXIhR3Q\\/SqwM01fvMXhWnd6xnJGe2+X7lyX8D25xZex0tRLZ4NvIGLd\\/tdS50+e4nlssPVzGB9CsktzdZb\\/kYPn+Ws9Mvb5reaDOJIxdy+kgeEfnuq7M6cwY0qmb4QPOH270batnQQ06J+LvVXeMzUJoxQ\\/xfTa2Yyi+EIuqL+C5mKf1xysSMRJ1qBy85Kuvn5wu34UptBskDhInA74TLjtUS+RG7U444cblgGqxOHTwWMmXqBocjGtnqqi4ly9vvKKSr6AYHYwPalx\\/iSYXWRgvcfBum\\/3MGAur6kZRh9mG0zvD2t1bLDmbpBIpbY4PloymqVPl4Knq+vn6Cd++L0M9TbhvcoYRs92G3W7D7pwgdPMGC7b8xSYXHEWJFaGV2em9fr9+S6wOhcPBEwFghLoxmkfv6r2g8s4LTbk7y+Od3mkdQqidTsZwzzE\\/XiGVdzC\\/POydhhGdjFfskOn5zlbZi+QxTy\\/z6OHt\\/mV9EnMucTJ7xT7nY9xQIbY7ZKyg2UY17V7FxpzfCcUE7wvaNKBd5n2sgtHrI6A7HVE1XnFQ1yaOrpFgM1rF6vN37mr\\/KpgILPogk0XxhwgNm08w9BxYBr6gdqpT8dXqeaYqdaac7mfNTK8PuH4e3ubatJlcNKqZzaZlIbToxVqMsT3oZkZHcjdBxRXg\\/oB9P7oXwFVLsp\\/oZj5v3VgtXGhc\\/xxMDrfm7ezO4nEMeQoSovcnPEwE1q9y7dbqwPcZzqtzN16nqr4Vz8WIle34F72duzvt4pvD71DNXjHPcGPFTT22wfevDsmWG7SAVqNCNrzJ9989ZWPIlELz3CqrnjqxFy\\/YiBVpNOm8DZ2P8+rJBrGGm+VR7pKPn5Bq\\/f26\\/bSD00WSu5t8\\/5d9CjY\\/N1a1jxPa\\/L+EwWwV9wI3r61wu6\\/cp5JvnvLN403CmcppuZUq2d0NdgoGpv3Tmk8cc+AaA+q1cw3g5g5SVMa8LPoGXD92G75FL45Khoh2Cp3W5CILHoXEbqQ3qOgNZitxohnwBudwDti33TnH\\/CRkDjtPKuepm9JRDawXmbhxPvbZJdUsp9NlbbZ3+rkQaqZH\\/\\/RPfzqZEmey4dT8BEY1fUjGOMWCbwxoU4wnKNv9zE12bjGr6UNSTLLo144FmHB7rZQOczQnAgQ9ZtK728RMAW7Ou\\/rfRgbAjLuVZ++wiivkxQGYXNMEnE3yyRj7BzHC+1HCkSSJEkwsrXM90Pnphv5ymHD7fbgaOQ4PDtkLR9nfP+QgWaTtmuP63SV86oDYLhGLHmEPztD3Cwa2CcaVNLGyDX\\/Iy8De21qeg1SBbDRB9Hg5zJCrwcTCVe6tT2NXP70Myn+8RMo4FqYG7Ke\\/\\/k8dkQrnMEwF8WvnOLZLJA7zZFOD9pWhNT3DpAVKiSgFa++2LY6x3p+WaJeIRau4Qn48ZnBOeTCXUkTCh4TDUfb3o+wfJEgcWQlcXedqTyX3stdzHKRhfGCdKmSjSY4c6vJkef8uhXnuKqHxwVcQFhftbIRIdYyF6TE4ynOQgamFKc3UTyNud5vUfoyKM4jPAfXMIclcob+OogkOSnaC9STbRxOsXvUMvfN3WurEDgq0Z30E\\/aPWTZnYXgrFMzfgvH64zk94mPAuTJ8RiMok9vMobp\\/8jIfocfavx7bbtDCc\\/vRDs03LZDht6LXpWu2TXoaz8x5Tf6ZnfZNqTcFksWHRPimfse1Wo0a9ZcZu037wVKvZxqj9\\/R+1YeX6lLT1r9Zsg175z6K3bZWh9dRsUG20Bp+fQaoRnj5J4DqeUKA1qDyjHqPqXLWaYBxWnlG3B0CbVtMwfFvHBl0nenVzFObp0wzjtwa83X0JOoPZCo5J19AA11GjkK1ilsFsoXFWmwAGTeOr\\/eJq07XUaWflPTYsj8GE3T7gi8bZ2zZabLpBAhjc+KmdkfxJaOtf7azyn0Vv2ypD68lkGX5+BrHPMutukkn2vczSMag8w\\/atpcqm27CPuj0ARggSDLlOdOqmEs9TcXiZ+whBAsDt9+IyN6lk82R0lyqK2YHfL0FC9Dr7iUKIjym7w\\/fbZm49XBjQ\\/fT3oEH42UsKgc+4OTMgigjxCyCBQgghhK6+J3shhBBCTQKFEEIIXRIohBBC6JJAIYQQQpcECiGEELokUAghhNAlgUIIIYQuCRRCCCF0SaAQQgihSwKFEEIIXRIohBBC6JJAIYQQQpcECiGEELokUAghhNAlgUIIIYQuw5dffin\\/j0IIIcRQhj\\/+h\\/9DAoUQQoihpOtJCCGELgkUQgghdEmgEEIIoUsChRBCCF0SKIQQQuiSQCGEEEKXBAohhBC6JFAIIYTQJYFCCCGELgkUQgghdEmgEEIIoUsChRBCCF0SKIQQQuiSX48Vl+iIvRdh9kstbcIp+yR3787gNmgThBC\\/VPJEIS5PqUCi1MLscOKd7F0cFsAA1LI8+zFOUW5PhPirYfjn\\/\\/PftrFYsJsAWjSqTZqaTCarBcugkNKukU4qjPudmBoN6toPahmM2G0m1YoW5VQJvOM4B21\\/SHn6tzPIkM+i\\/rxCLnGE1efGoXeH2yiTPLLhGzd3\\/m43qdYG3DWbTNjVFTVqPoCWQrU+pPU8OT9dzRrZdJlKE7DYmJp09qZrVPMFqvZxPDZtyiUrxXn8Iot9+Rq3Z3qTDl+\\/Yas6yY25Ou\\/el1Gsk9y9J08WQvw1MPyL\\/+q\\/bhs9AT5fdUMyzFdbZYwW48mjRktp0WqD2T3J1bUZptSNTXyfr3Zg9TcLWLe2eJdTNYrNFkrbgNmsagmMLq7eDzJ1\\/Hf+kO9f58E3z+errtN8xypxHj\\/PUjcbMao201JatMwOlm4sEHKoP6Ay4FhOnJQjy4tv49TnrvBgYVgrqhB+scVuY5K792dwM2zbbZRGG7Nrilu3fJ0GUCef0THBtRsBpiydtfE3b3iX09RX18n5AYr773kZraEYjZiNQLuNorSxTs5we32yP+ApGZ4\\/SVBwTvPr29N0d\\/dxjBAo7t6fwR4P8+R9GcXl5ze3vHTDrxDiF6p3jELV8AdUmVpHBd5vHhKtjrF6b4HAcWszJD9A8f02z7Ku08a1T5PIy00OWjaoGJl\\/uMictsUoxXn8ooT39gor6jjSqrL3ao\\/95iQP7voZGCt0ynaqEyhyRgerDxYIaPcPkIrwzWaRlk0VKIZtu1Zk41WEjDPIF+vjZ+dzBPni2jgcN6TM8Nsbk+qcvVIRvtms4r26wPXjCNM9P9vvstjXFwnZez5BbnuLFyUTjqMm49dXWZvoTb9UZwWKfO861HUqhPjF6rvZHsQ4Ns7K7QVmzRW23mZQtBku4ihNrGjFvxbEbz8iFqlpcwxntLMYcmM+KpGsahPPy4jVXOEgfKRNAGq8Pyhito5UTWBzszZjo1UskdWmqR3nyxdJatN0JNMlWq4J1lRBgu75WbvTHyRoF4ikmniDiyx4miQOC5oMn870\\/DR+7ZiFEOKvwogtIGAY48qMDYpFkkO60s8jFy1QcXsIjdkI+ceopDLktJnOZMA46CngXExMz09CPEa40ZuixONEmxPMe3UGADTMJiM026MFU5Ph\\/N0uzRZ17bohlMMsGfM4cz4jvsA45lyWyEgFu3yW8WnWr4W42V2CAx8DhRC\\/RMZqtYEyYsNvHrdjRaFS1qac0\\/Gd7kynf9ocmMSr5NmLDhx67teqshcuojhcTOm2tG2UaoOqdtHuxjnDkqdOdK+kWlnm\\/cER4\\/N+Op1DI2g3CCePwDmGTgcS1IpsxmsY3a7efK1mf1lV58c358FezfD8xSGRbLX\\/OHrUCCeOcEx78QBMePHbjzjY+9CTN6Jqjs03YV5pl+0cH\\/wQKIT4pAy\\/+\\/0fRgwT4m+Nd9LFzWvz2tUXpx6jcHcmIvQFBdsk9+\\/PUFANbssYhRC\\/bCMNZp\\/IRfl24wj\\/8eCyTv7hg9llNp+GKUxf4cGiaqaRkuH5kwwO9YBrKc7jF0XGry6y6ASok48k2Em18d9YZkWvhdEp26ksL77N4OgeT3Zri9f1KT6\\/bmLz8SEsr3N9esCxxPf5aqeKY3KMzrCAEbtrDLt9jJmpMU4mLsX3+WqnzdK9ID6AVo3kfoz9ko3lO6HTSQGjDmZrtBoNCvkskf0MmbqNhTtXWBzjZKLArvl0sLyjU\\/eVwBp3gqN3p41MZzBbSz0LSu80CiF+fqOPUQCVfBXFaGd8wEzWkSUzJOpQib7nq2\\/fnC6PExTaColIVtO\\/b8Bss2C3W7DbncysXOHaVIvou8MLjGnom1yaYryY4e27FKmxKVantTnU7ARP+tznWJn3MjetChInDJjt3fI7XISuLbFgK1\\/KpACjxYJn2s\\/Ne3NMm2sk4t3796M0sSK0stHeOv42TKwOhViKonZjl60S53HPvrvLD3E+UeeXEOKSjB4oGlk2Y3Ws057O3fGF1NiLljFPBXl0b6V\\/WXNjzmcZOAFJZXLRg6uR5\\/1lj8yaJ1nyQybTYnbhY71zYCYUGsdazLB93kjXGvDyHoDB3Hmnoiu5n6XimuK+tn7vrfDozhSueo7980y3ugijDY\\/m7WzvpBPvhI2P8CwjhPiIBgxmaweAyyT3wnz\\/NE7BOsmNZac68\\/nkM8QqVvyh8e4TgmaZnsY\\/VicRPeOe0zLN6oyFUiR+xgws7bEMGcxWcS\\/Nc+Nq6OO+b+CZYWGiSWIvSUW9Xncwu8b75+\\/49sUh8UKDRjdmtBpl4m+jxOpW\\/DN2UDJEs+Cd9eHU1q\\/dgt3hY94DmfiHP9HosntYU81yOllWPN3uOiHEXwvj4x+3+fZtd369xYSRI3Z\\/3Obx8fLsgK10g\\/HFJb7Q\\/uSCyYTRYBj4WHL8JrU6LR0vUHd7CI2pVvboTJWtp3OkAczdN5oH7MC95GOaIgcHQ5q7QcdyvDwO976\\/oN6+wcZUz+vnYDEZwGQ8fcLQOe4eQ\\/OZCFzx4jjKsJfprLGaDVBM9Zf15PzYuHJjjllTha3X23z3facr55snYbbKVpZvL7E4Bo3DPAXLOHM6j32+wDjWYp7IqPNshRB\\/1z7412NbLTD2t4RAi1bL2JvWbtGi9+c4Bmp3f0AOaLVaGAfvAFotWsYBP9FxDrrbP9F\\/LMOPu5duPt3EMzQbVBtgtlk04yL9ZR1IVceXpjuYrTicjA\\/7RZSuaqlMxSiD2UL8NTirOTnT8AZpQGNlGCFI0NuA6TbiHxgkOGv7J\\/qPRfv3MLr5dBPPYOp0JfUPnveXdaC+z10C1zh+lxGlUiaT1V8qihGXb1yChBB\\/BT74iUIIIcTftlHuPYUQQvwdk0AhhBBClwQKIYQQuiRQCCGE0CWBQgghhC4JFEIIIXRJoBBCCKFLAoUQQghdEiiEEELokkAhhBBClwQKIYQQuiRQCCGE0CWBQgghhC4JFEIIIXRJoBBCCKFLAoUQQghdhi\\/\\/9\\/9J\\/nGREEKIoQz\\/7v\\/6owQKIYQQQ0nXkxBCCF0SKIQQQuiSQCGEEEKXBAohhBC6JFAIIYTQJYFCCCGELgkUQgghdEmgEEIIoUsChRBCCF0SKIQQQuiSQCGEEEKXBAohhBC6\\/n9P\\/Fw\\/8MS26AAAAABJRU5ErkJggg==\\\"><\\/p>\\n<p>&nbsp;<\\/p>\\n<p>&nbsp;<\\/p>\"}]','2025-09-24 07:52:50','2025-12-03 23:19:17'),(788,0,2025,'archivos','[]','[{\"temporada\":\"\",\"dispositivo\":\"\",\"tipo\":\"\",\"archivo\":\"bolsaded@gmail.com\"},{\"temporada\":\"\",\"dispositivo\":\"\",\"tipo\":\"\",\"archivo\":\"\"},{\"temporada\":\"\",\"dispositivo\":\"\",\"tipo\":\"\",\"archivo\":\"\"}]','2025-12-03 21:40:22','2025-12-03 21:40:22');

--
-- Table structure for table `realtime_counters`
--

CREATE TABLE `realtime_counters` (
  `channel` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ver` bigint unsigned NOT NULL DEFAULT '1',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`channel`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `realtime_counters`
--

INSERT INTO `realtime_counters` VALUES ('listas',12123,'2026-01-07 17:19:47');

--
-- Table structure for table `renta_cargos`
--

CREATE TABLE `renta_cargos` (
  `id` int NOT NULL AUTO_INCREMENT,
  `contrato_id` int NOT NULL,
  `periodo` char(7) NOT NULL,
  `tipo` enum('CARGO','DESCUENTO') NOT NULL DEFAULT 'CARGO',
  `concepto` varchar(160) NOT NULL,
  `monto` decimal(10,2) NOT NULL,
  `fuente` enum('MANUAL','GASTO') NOT NULL DEFAULT 'MANUAL',
  `gasto_id` int DEFAULT NULL,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_cargo` (`contrato_id`,`periodo`,`fuente`,`gasto_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `renta_cargos`
--

INSERT INTO `renta_cargos` VALUES (4,5,'2025-10','CARGO','LUZ 2025-10',450.00,'GASTO',6,'2025-10-13 07:48:48');

--
-- Table structure for table `rentas`
--

CREATE TABLE `rentas` (
  `id` int NOT NULL AUTO_INCREMENT,
  `contrato_id` int NOT NULL,
  `periodo` char(7) NOT NULL,
  `fecha_venc` date NOT NULL,
  `monto` decimal(10,2) NOT NULL,
  `pagado` decimal(10,2) NOT NULL DEFAULT '0.00',
  `estado` enum('PENDIENTE','PAGADA','VENCIDA','ANULADA') DEFAULT 'PENDIENTE',
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_ctr_periodo` (`contrato_id`,`periodo`),
  KEY `idx_rentas_estado` (`estado`),
  CONSTRAINT `fk_renta_ctr` FOREIGN KEY (`contrato_id`) REFERENCES `contratos` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=76 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `rentas`
--

INSERT INTO `rentas` VALUES (51,8,'2024-12','2024-12-02',2250.00,0.00,'PENDIENTE','2025-10-17 06:58:49','2025-10-17 06:58:49'),(52,8,'2025-01','2025-01-02',2250.00,0.00,'PENDIENTE','2025-10-17 06:58:49','2025-10-17 06:58:49'),(53,8,'2025-02','2025-02-02',2250.00,0.00,'PENDIENTE','2025-10-17 06:58:49','2025-10-17 06:58:49'),(54,8,'2025-03','2025-03-02',2250.00,0.00,'PENDIENTE','2025-10-17 06:58:49','2025-10-17 06:58:49'),(55,8,'2025-04','2025-04-02',2250.00,0.00,'PENDIENTE','2025-10-17 06:58:49','2025-10-17 06:58:49'),(56,8,'2025-05','2025-05-02',2250.00,0.00,'PENDIENTE','2025-10-17 06:58:49','2025-10-17 06:58:49'),(57,8,'2025-06','2025-06-02',2250.00,0.00,'PENDIENTE','2025-10-17 06:58:49','2025-10-17 06:58:49'),(58,8,'2025-07','2025-07-02',2250.00,0.00,'PENDIENTE','2025-10-17 06:58:49','2025-10-17 06:58:49'),(59,8,'2025-08','2025-08-02',2250.00,0.00,'PENDIENTE','2025-10-17 06:58:49','2025-10-17 06:58:49'),(60,8,'2025-09','2025-09-02',2250.00,0.00,'PENDIENTE','2025-10-17 06:58:49','2025-10-17 06:58:49'),(61,8,'2025-10','2025-10-02',2250.00,0.00,'PENDIENTE','2025-10-17 06:58:49','2025-10-17 06:58:49'),(62,8,'2025-11','2025-11-02',2250.00,0.00,'PENDIENTE','2025-10-17 06:58:49','2025-10-17 06:58:49'),(63,9,'2025-02','2025-02-02',1500.00,0.00,'PENDIENTE','2025-10-17 08:20:14','2025-10-17 08:20:14'),(64,9,'2025-03','2025-03-02',1500.00,0.00,'PENDIENTE','2025-10-17 08:20:14','2025-10-17 08:20:14'),(65,9,'2025-04','2025-04-02',1500.00,0.00,'PENDIENTE','2025-10-17 08:20:14','2025-10-17 08:20:14'),(66,9,'2025-05','2025-05-02',1500.00,0.00,'PENDIENTE','2025-10-17 08:20:14','2025-10-17 08:20:14'),(67,9,'2025-06','2025-06-02',1500.00,0.00,'PENDIENTE','2025-10-17 08:20:14','2025-10-17 08:20:14'),(68,9,'2025-07','2025-07-02',1500.00,0.00,'PENDIENTE','2025-10-17 08:20:14','2025-10-17 08:20:14'),(69,9,'2025-08','2025-08-02',1500.00,0.00,'PENDIENTE','2025-10-17 08:20:14','2025-10-17 08:20:14'),(70,9,'2025-09','2025-09-02',1500.00,0.00,'PENDIENTE','2025-10-17 08:20:14','2025-10-17 08:20:14'),(71,9,'2025-10','2025-10-02',1500.00,0.00,'PENDIENTE','2025-10-17 08:20:14','2025-10-17 08:20:14'),(72,9,'2025-11','2025-11-02',1500.00,0.00,'PENDIENTE','2025-10-17 08:20:14','2025-10-17 08:20:14'),(73,9,'2025-12','2025-12-02',1500.00,0.00,'PENDIENTE','2025-10-17 08:20:14','2025-10-17 08:20:14'),(74,9,'2026-01','2026-01-02',1500.00,0.00,'PENDIENTE','2025-10-17 08:20:14','2025-10-17 08:20:14'),(75,9,'2026-02','2026-02-02',1500.00,0.00,'PENDIENTE','2025-10-17 08:20:14','2025-10-17 08:20:14');

--
-- Table structure for table `sedes`
--

CREATE TABLE `sedes` (
  `sede_id` int NOT NULL AUTO_INCREMENT,
  `nombre` varchar(120) NOT NULL,
  `direccion` varchar(180) DEFAULT NULL,
  `estado` enum('ACTIVO','INACTIVO') NOT NULL DEFAULT 'ACTIVO',
  `creado_en` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`sede_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sedes`
--

INSERT INTO `sedes` VALUES (1,'SIN SEDE',NULL,'ACTIVO','2025-10-15 11:09:38'),(2,'JESÚS MARÍA 212','Av Arnaldo Marquez 1372','ACTIVO','2025-10-15 11:09:38'),(3,'BREÑA','Jr Castrovireyna 287','ACTIVO','2025-10-15 11:09:38'),(5,'JESUS MARIA 315','Jr Mariscal Luzuriaga 315','ACTIVO','2025-10-15 11:31:32');

--
-- Table structure for table `sjm`
--

CREATE TABLE `sjm` (
  `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_sjm_usuario_anio` (`usuario_id`,`anio`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sjm`
--

INSERT INTO `sjm` 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\":\"SJM\",\"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 08:52:54','2025-09-19 08:53:03'),(2,9,2025,'Empresa 1',125.00,225.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,350.00,NULL,'2025-09-19 08:53:03','2025-09-19 08:53:06'),(3,9,2025,'Empresa 2',58.00,54.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,112.00,NULL,'2025-09-19 08:53:10','2025-09-19 08:53:11'),(4,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,'<ul class=\"todo\">\n<li style=\"font-weight: bold;\" data-done=\"1\"><strong>DADSSAD23SDgdfgfgdADS</strong></li>\n<li style=\"font-weight: bold;\" data-done=\"1\"><strong>dgA</strong></li>\n<li data-done=\"0\">D</li>\n<li data-done=\"0\">g</li>\n<li data-done=\"0\">df</li>\n<li data-done=\"0\">fgfdfgdgf</li>\n</ul>\n<p>gfdgdgfdggddggd</p>\n<p>D<img src=\"data:image/png;base64,[BLOB]\"></p>\n<p>ASD</p>\n<p>A</p>\n<p>DA</p>\n<p>SD</p>','2025-09-19 08:53:15','2025-09-24 11:55:17');

--
-- Table structure for table `sjm_dep`
--

CREATE TABLE `sjm_dep` (
  `id` int NOT NULL AUTO_INCREMENT,
  `usuario_id` int DEFAULT NULL,
  `anio` smallint NOT NULL,
  `nombre` varchar(180) COLLATE utf8mb4_general_ci 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 COLLATE utf8mb4_general_ci,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `sjm_dep_uq_anio_nombre` (`anio`,`nombre`),
  KEY `sjm_dep_idx_anio` (`anio`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `sjm_dep`
--

INSERT INTO `sjm_dep` VALUES (1,NULL,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\":\"EMPRESA\",\"enero\":\"ENERO\",\"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-10-09 12:00:30','2025-10-09 12:08:04'),(2,NULL,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,'<p>PRUEBAA 0002&nbsp;</p>\n<p><img src=\"data:image/png;base64,[BLOB]\"></p>','2025-10-09 12:00:30','2025-10-09 12:08:19');

--
-- Table structure for table `software`
--

CREATE TABLE `software` (
  `software_id` int NOT NULL AUTO_INCREMENT,
  `nombre` varchar(150) NOT NULL,
  `fabricante` varchar(120) DEFAULT NULL,
  `categoria` varchar(80) DEFAULT NULL,
  `critico` tinyint(1) DEFAULT '0',
  `notas` text,
  `creado_en` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`software_id`),
  UNIQUE KEY `uniq_nombre` (`nombre`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `software`
--

INSERT INTO `software` VALUES (1,'ESET HOME Security Premium','ESET','ANTIVIRUS',0,'','2025-10-14 11:56:28');

--
-- Table structure for table `solicitudes_info`
--

CREATE TABLE `solicitudes_info` (
  `id` int NOT NULL AUTO_INCREMENT,
  `tipo_solicitante` varchar(50) NOT NULL,
  `entidad` varchar(255) NOT NULL,
  `contacto` varchar(255) DEFAULT NULL,
  `canal` varchar(50) NOT NULL,
  `recibido_en` varchar(255) DEFAULT NULL,
  `asunto` varchar(255) NOT NULL,
  `descripcion` text,
  `fecha_recepcion` date NOT NULL,
  `fecha_limite` date DEFAULT NULL,
  `responsable_id` int NOT NULL,
  `estado` enum('PENDIENTE','ENVIADO','OBSERVADO','ACEPTADO','CERRADO') NOT NULL DEFAULT 'PENDIENTE',
  `fecha_envio` datetime DEFAULT NULL,
  `medio_envio` varchar(100) DEFAULT NULL,
  `referencia_envio` varchar(255) DEFAULT NULL,
  `mensaje_envio` text,
  `fecha_respuesta` datetime DEFAULT NULL,
  `respuesta_resumen` text,
  `observaciones_internas` text,
  `creado_en` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `fk_solicitud_responsable` (`responsable_id`),
  CONSTRAINT `fk_solicitud_responsable` FOREIGN KEY (`responsable_id`) REFERENCES `usuarios` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `solicitudes_info`
--

INSERT INTO `solicitudes_info` VALUES (1,'BANCO','SCOTIABANK','987447116','CORREO','e.varapillaca@gmail.com','EVP - EDUARDO VARA PILLACA',NULL,'2025-11-21',NULL,1,'PENDIENTE',NULL,NULL,NULL,NULL,'2025-11-22 11:00:00',NULL,NULL,'2025-11-27 11:00:53');

--
-- Table structure for table `solicitudes_info_docs`
--

CREATE TABLE `solicitudes_info_docs` (
  `id` int NOT NULL AUTO_INCREMENT,
  `solicitud_id` int NOT NULL,
  `tipo` enum('DOCUMENTO_SOLICITADO','DOCUMENTO_ENVIADO','EVIDENCIA_ENVIO','RESPUESTA_ENTIDAD','OTRO') NOT NULL,
  `titulo` varchar(255) NOT NULL,
  `descripcion` text,
  `drive_file_id` varchar(200) DEFAULT NULL,
  `drive_link` varchar(500) NOT NULL,
  `path` varchar(500) DEFAULT NULL,
  `mime` varchar(100) DEFAULT NULL,
  `size_bytes` int DEFAULT NULL,
  `creado_por` int NOT NULL,
  `creado_en` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `fk_doc_solicitud` (`solicitud_id`),
  KEY `fk_doc_creado_por` (`creado_por`),
  CONSTRAINT `fk_doc_creado_por` FOREIGN KEY (`creado_por`) REFERENCES `usuarios` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE,
  CONSTRAINT `fk_doc_solicitud` FOREIGN KEY (`solicitud_id`) REFERENCES `solicitudes_info` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `solicitudes_info_docs`
--

INSERT INTO `solicitudes_info_docs` VALUES (1,1,'DOCUMENTO_SOLICITADO','CONTRATOS PRESTAMOS IN (4)',NULL,'11RvPfQfcbqmAetsp38HSTFpjxv9lLA7T','https://docs.google.com/spreadsheets/d/11RvPfQfcbqmAetsp38HSTFpjxv9lLA7T/edit?usp=drivesdk&ouid=113865892943474118622&rtpof=true&sd=true','uploads/solicitudes_docs/2025/11/sdoc_6928816e7bae02.17565300.xlsx','application/vnd.openxmlformats-officedocument.spreadsheetml.sheet',12689,1,'2025-11-27 11:50:54');

--
-- Table structure for table `suscripcion`
--

CREATE TABLE `suscripcion` (
  `suscripcion_id` int NOT NULL AUTO_INCREMENT,
  `servicio_id` int NOT NULL,
  `empresa_id` int NOT NULL,
  `area_id` int DEFAULT NULL,
  `sede_id` int DEFAULT NULL,
  `nombre` varchar(120) NOT NULL,
  `proveedor` varchar(120) DEFAULT NULL,
  `plan` varchar(120) DEFAULT NULL,
  `cantidad` int DEFAULT '1',
  `costo_mensual` decimal(12,2) DEFAULT '0.00',
  `moneda_costo` enum('PEN','USD') NOT NULL DEFAULT 'PEN',
  `banco_tarjeta` varchar(80) DEFAULT NULL,
  `tarjeta_ult4` char(4) DEFAULT NULL,
  `ciclo` enum('MENSUAL','ANUAL','UNICO') NOT NULL DEFAULT 'ANUAL',
  `fecha_inicio` date DEFAULT NULL,
  `fecha_fin` date DEFAULT NULL,
  `estado` enum('ACTIVA','PAUSADA','VENCIDA') NOT NULL DEFAULT 'ACTIVA',
  `notas` text,
  `creado_en` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `actualizado_en` datetime DEFAULT NULL,
  PRIMARY KEY (`suscripcion_id`),
  KEY `fk_suscripcion_servicio` (`servicio_id`),
  KEY `idx_suscripcion_estado` (`estado`),
  KEY `idx_suscripcion_fechafin` (`fecha_fin`),
  KEY `idx_suscripcion_empresa` (`empresa_id`,`servicio_id`),
  KEY `idx_suscr_area` (`area_id`),
  KEY `idx_suscr_sede` (`sede_id`),
  CONSTRAINT `fk_suscr_area` FOREIGN KEY (`area_id`) REFERENCES `areas` (`area_id`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `fk_suscr_sede` FOREIGN KEY (`sede_id`) REFERENCES `sedes` (`sede_id`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `fk_suscripcion_empresa` FOREIGN KEY (`empresa_id`) REFERENCES `empresas` (`empresa_id`),
  CONSTRAINT `fk_suscripcion_servicio` FOREIGN KEY (`servicio_id`) REFERENCES `cat_servicio` (`servicio_id`)
) ENGINE=InnoDB AUTO_INCREMENT=71 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `suscripcion`
--

INSERT INTO `suscripcion` VALUES (1,1,1,NULL,NULL,'3TMI.PE','DIGITAL OCEAM',NULL,1,10.48,'USD','BANBIF','8173','MENSUAL','2025-12-01','2026-02-01','ACTIVA','MENSUAL - RECIBO NRO: 536195593','2025-11-22 11:55:36','2026-01-02 06:47:59'),(2,1,1,NULL,NULL,'BDIVISAS.COM','DIGITAL OCEAM',NULL,1,18.00,'USD','BANBIF','8173','MENSUAL','2025-12-01','2026-02-01','ACTIVA','MENSUAL - RECIBO NRO: 536195593','2025-11-22 12:01:16','2026-01-02 06:26:06'),(3,1,1,NULL,NULL,'BOLSADEDIVISAS.COM','DIGITAL OCEAM',NULL,1,6.00,'USD','BANBIF','8173','MENSUAL','2025-12-01','2026-02-01','ACTIVA','MENSUAL - RECIBO NRO: 536195593','2025-11-22 12:02:19','2026-01-02 06:46:37'),(4,1,1,NULL,NULL,'PACO.PE','DIGITAL OCEAM',NULL,1,28.00,'USD','BANBIF','8173','MENSUAL','2025-12-01','2026-02-01','ACTIVA','MENSUAL - RECIBO NRO: 536195593','2025-11-22 12:03:50','2026-01-02 06:46:18'),(5,1,1,NULL,NULL,'PACOSMONEY.PE','DIGITAL OCEAM',NULL,1,56.00,'USD','BANBIF','8173','MENSUAL','2025-12-01','2026-02-01','ACTIVA','MENSUAL - RECIBO NRO: 536195593','2025-11-22 12:04:52','2026-01-02 06:45:58'),(6,1,1,NULL,NULL,'YOYISS.PE','DIGITAL OCEAM',NULL,1,8.00,'USD','BANBIF','8173','MENSUAL','2025-12-01','2026-02-01','ACTIVA','MENSUAL - RECIBO NRO: 536195593','2025-11-22 12:07:06','2026-01-02 06:45:16'),(7,1,1,NULL,NULL,'SOLUCIONES-BD.COM','DIGITAL OCEAM',NULL,1,56.00,'USD','BANBIF','8173','MENSUAL','2025-12-01','2026-02-01','ACTIVA','MENSUAL - RECIBO NRO: 536195593','2025-11-22 12:09:31','2026-01-02 06:26:53'),(8,1,1,NULL,NULL,'SISTEMASBUSINESS.COM','HOSTING SSD',NULL,1,194.70,'PEN','TRANSF. BCP','','ANUAL','2025-09-08','2026-09-07','ACTIVA','Cuadre General - Sistemas Gastos','2025-11-22 12:12:01',NULL),(9,2,1,NULL,NULL,'3TMI.PE','HOSTING SSD',NULL,1,141.60,'PEN','TRANSF. BCP','','ANUAL','2025-05-12','2026-05-11','ACTIVA','Página Web / Sistemas (Hotel, tienda, casa de cambio)','2025-11-22 12:14:40','2025-11-22 12:16:05'),(10,1,1,NULL,NULL,'TECNOLOGICAS-BD.COM','NINJA HOSTING ',NULL,1,116.82,'PEN','TRANSF. BCP','','ANUAL','2025-05-14','2026-05-14','ACTIVA','Página Web / Facturación','2025-11-22 12:15:49','2025-11-22 12:18:30'),(11,1,1,NULL,NULL,'BSDIVISAS.COM','NINJA HOSTING ',NULL,1,105.02,'PEN','TRANSF. BCP','','ANUAL','2025-05-14','2026-05-14','ACTIVA','Facturación','2025-11-22 12:18:20',NULL),(12,1,1,NULL,NULL,'PAGOEFECTY.COM','NINJA HOSTING ',NULL,1,46.02,'PEN','TRANSF. BCP','','ANUAL','2025-05-14','2026-05-14','ACTIVA','Página Web / Facturación','2025-11-22 12:19:25',NULL),(13,1,1,NULL,NULL,'INNOVADORAS-BD.COM','NINJA HOSTING ',NULL,1,151.35,'PEN','TRANSF. BCP','','ANUAL','2025-05-14','2026-05-14','ACTIVA','Página Web / Facturación / Datadivisas','2025-11-22 12:20:31',NULL),(14,2,1,NULL,NULL,'CUANTOESTALOSPESOSCHILENOS.COM','GODDADY',NULL,1,284.79,'PEN','BANBIF','0623','ANUAL','2022-10-06','2027-10-06','ACTIVA','Redirige a BDivisas','2025-11-22 12:22:39',NULL),(15,2,1,NULL,NULL,'CUANTOESTALOSPESOSARGENTINOS.COM','GODDADY',NULL,1,284.79,'PEN','BANBIF','0623','ANUAL','2022-10-06','2027-10-06','ACTIVA','Redirige a BDivisas','2025-11-22 12:22:39',NULL),(16,2,1,NULL,NULL,'CUANTOESTALOSPESOSURUGUAYOS.COM','GODDADY',NULL,1,284.79,'PEN','BANBIF','0623','ANUAL','2022-10-06','2027-10-06','ACTIVA','Redirige a BDivisas','2025-11-22 12:22:39',NULL),(17,2,1,NULL,NULL,'CUANTOESTALOSPESOSMEXICANOS.COM','GODDADY',NULL,1,284.79,'PEN','BANBIF','0623','ANUAL','2022-10-06','2027-10-06','ACTIVA','Redirige a BDivisas','2025-11-22 12:22:39',NULL),(18,2,1,NULL,NULL,'CUANTOESTALOSREALES.COM','GODDADY',NULL,1,284.79,'PEN','BANBIF','0623','ANUAL','2022-10-06','2027-10-06','ACTIVA','Redirige a BDivisas','2025-11-22 12:22:39',NULL),(19,2,1,NULL,NULL,'CUANTOESTAELPESOBOLIVIANO.COM','GODDADY',NULL,1,284.79,'PEN','BANBIF','0623','ANUAL','2022-10-06','2027-10-06','ACTIVA','Redirige a BDivisas','2025-11-22 12:22:39',NULL),(20,2,1,NULL,NULL,'CUANTOESTAELDOLARCANADIENSE.COM','GODDADY',NULL,1,284.79,'PEN','BANBIF','0623','ANUAL','2022-10-06','2027-10-06','ACTIVA','Redirige a BDivisas','2025-11-22 12:22:39',NULL),(21,2,1,NULL,NULL,'CUANTOESTALOSPESOSCOLOMBIANOS.COM','GODDADY',NULL,1,284.79,'PEN','BANBIF','0623','ANUAL','2022-10-06','2027-10-06','ACTIVA','Redirige a BDivisas','2025-11-22 12:22:39',NULL),(22,2,1,NULL,NULL,'CUANTOESTALOSYENES.COM','GODDADY',NULL,1,284.79,'PEN','BANBIF','0623','ANUAL','2022-10-06','2027-10-06','ACTIVA','Redirige a BDivisas','2025-11-22 12:22:39',NULL),(23,2,1,NULL,NULL,'CUANTOESTALOSFRANCOSUIZOS.COM','GODDADY',NULL,1,284.79,'PEN','BANBIF','0623','ANUAL','2022-10-06','2027-10-06','ACTIVA','Redirige a BDivisas','2025-11-22 12:22:39',NULL),(24,2,1,NULL,NULL,'CUANTOESTAELDOLARAUSTRALIANO.COM','GODDADY',NULL,1,284.79,'PEN','BANBIF','0623','ANUAL','2022-10-06','2027-10-06','ACTIVA','Redirige a BDivisas','2025-11-22 12:22:39',NULL),(25,2,1,NULL,NULL,'CUANTOESTAELEURO.COM','GODDADY',NULL,1,284.79,'PEN','BANBIF','0623','ANUAL','2022-10-06','2027-10-06','ACTIVA','Redirige a BDivisas','2025-11-22 12:22:39',NULL),(26,2,1,NULL,NULL,'CUANTOESTALALIBRAESTERLINA.COM','GODDADY',NULL,1,231.12,'PEN','BANBIF','0623','ANUAL','2022-10-06','2027-10-05','ACTIVA','Redirige a BDivisas','2025-11-22 12:47:42',NULL),(27,2,1,NULL,NULL,'TIPODECAMBIODELDOLAR.COM','GODDADY',NULL,1,253.53,'PEN','BANBIF','0623','ANUAL','2022-10-15','2027-10-14','ACTIVA','Redirige a BDivisas','2025-11-22 12:48:50',NULL),(28,2,1,NULL,NULL,'TIPODECAMBIODELDOLAR.PE','GODDADY',NULL,1,974.75,'PEN','BANBIF','0623','ANUAL','2022-10-15','2027-10-14','ACTIVA','Redirige a BDivisas','2025-11-22 12:49:35','2025-11-22 12:49:48'),(29,2,1,NULL,NULL,'CUANTOESTAELDOLARHOY.COM','GODDADY',NULL,1,235.40,'PEN','BANBIF','0623','ANUAL','2022-10-31','2027-10-30','ACTIVA','Redirige a Bolsa de divisas','2025-11-22 12:51:02',NULL),(30,2,1,NULL,NULL,'CUANTOESTALALIBRAESTERLINAHOY.COM','GODDADY',NULL,1,290.95,'PEN','BANBIF','0623','ANUAL','2022-10-31','2027-10-30','ACTIVA','Redirige a BDivisas','2025-11-22 12:52:41',NULL),(31,2,1,NULL,NULL,'CUANTOESTALOSPESOSCHILENOSHOY.COM','GODDADY',NULL,1,290.95,'PEN','BANBIF','0623','ANUAL','2022-10-31','2027-10-30','ACTIVA','Redirige a BDivisas','2025-11-22 12:52:41',NULL),(32,2,1,NULL,NULL,'CUANTOESTALOSPESOSARGENTINOSHOY.COM','GODDADY',NULL,1,290.95,'PEN','BANBIF','0623','ANUAL','2022-10-31','2027-10-30','ACTIVA','Redirige a BDivisas','2025-11-22 12:52:41',NULL),(33,2,1,NULL,NULL,'CUANTOESTALOSPESOSURUGUAYOSHOY.COM','GODDADY',NULL,1,290.95,'PEN','BANBIF','0623','ANUAL','2022-10-31','2027-10-30','ACTIVA','Redirige a BDivisas','2025-11-22 12:52:41',NULL),(34,2,1,NULL,NULL,'CUANTOESTALOSPESOSMEXICANOSHOY.COM','GODDADY',NULL,1,290.95,'PEN','BANBIF','0623','ANUAL','2022-10-31','2027-10-30','ACTIVA','Redirige a BDivisas','2025-11-22 12:52:41',NULL),(35,2,1,NULL,NULL,'CUANTOESTALOSREALESHOY.COM','GODDADY',NULL,1,248.46,'PEN','BANBIF','0623','ANUAL','2022-10-31','2027-11-30','ACTIVA','Redirige a BDivisas','2025-11-22 12:56:10',NULL),(36,2,1,NULL,NULL,'CUANTOESTALOSPESOSBOLIVIANOSHOY.COM','GODDADY',NULL,1,248.46,'PEN','BANBIF','0623','ANUAL','2022-10-31','2027-11-30','ACTIVA','Redirige a BDivisas','2025-11-22 12:56:10',NULL),(37,2,1,NULL,NULL,'CUANTOESTAELDOLARCANADIENSEHOY.COM','GODDADY',NULL,1,248.46,'PEN','BANBIF','0623','ANUAL','2022-10-31','2027-11-30','ACTIVA','Redirige a BDivisas','2025-11-22 12:56:10',NULL),(38,2,1,NULL,NULL,'CUANTOESTALOSPESOSCOLOMBIANOSHOY.COM','GODDADY',NULL,1,248.46,'PEN','BANBIF','0623','ANUAL','2022-10-31','2027-11-30','ACTIVA','Redirige a BDivisas','2025-11-22 12:56:10',NULL),(39,2,1,NULL,NULL,'CUANTOESTALOSYENESHOY.COM','GODDADY',NULL,1,248.46,'PEN','BANBIF','0623','ANUAL','2022-10-31','2027-11-30','ACTIVA','Redirige a BDivisas','2025-11-22 12:56:10',NULL),(40,2,1,NULL,NULL,'CUANTOESTALOSFRANCOSUIZOSHOY.COM','GODDADY',NULL,1,248.46,'PEN','BANBIF','0623','ANUAL','2022-10-31','2027-11-30','ACTIVA','Redirige a BDivisas','2025-11-22 12:56:10',NULL),(41,2,1,NULL,NULL,'CUANTOESTAELDOLARAUSTRALIANOHOY.COM','GODDADY',NULL,1,248.46,'PEN','BANBIF','0623','ANUAL','2022-10-31','2027-11-30','ACTIVA','Redirige a BDivisas','2025-11-22 12:56:10',NULL),(42,2,1,NULL,NULL,'CUANTOESTAELEUROHOY.COM','GODDADY',NULL,1,248.46,'PEN','BANBIF','0623','ANUAL','2022-10-31','2027-11-30','ACTIVA','Redirige a BDivisas','2025-11-22 12:56:10',NULL),(43,2,1,NULL,NULL,'BOLSADEDIVISAS.COM','GODDADY',NULL,1,151.38,'PEN','BANBIF','0623','ANUAL','2025-01-28','2027-01-27','ACTIVA','Página Web','2025-11-22 12:59:53',NULL),(44,2,1,NULL,NULL,'BDIVISAS.COM','GODDADY',NULL,1,75.67,'PEN','BANBIF','0623','ANUAL','2025-01-05','2027-01-02','ACTIVA','RENOVACION ANUAL - RECIBO NRO: 3959510106','2025-11-22 13:00:42','2026-01-02 06:22:51'),(45,2,1,NULL,NULL,'BIDEXPERU.COM','GODDADY',NULL,1,75.69,'PEN','BANBIF','0623','ANUAL','2025-01-05','2026-01-04','ACTIVA','Página Web','2025-11-22 13:05:58',NULL),(47,2,1,NULL,NULL,'PAGOEFECTY.COM','GODDADY',NULL,1,75.69,'PEN','BANBIF','0623','ANUAL','2025-10-15','2026-10-16','ACTIVA','Página Web / facturación','2025-11-22 13:09:32',NULL),(48,2,1,NULL,NULL,'PACOSMONEY.COM','GODDADY',NULL,1,104.98,'PEN','BANBIF','0623','ANUAL','2024-08-16','2026-08-15','ACTIVA','Redirige a BDivisas','2025-11-22 13:10:51',NULL),(49,2,1,NULL,NULL,'PACOSMONEY.PE','GODDADY',NULL,1,328.99,'PEN','BANBIF','0623','ANUAL','2024-08-15','2026-08-16','ACTIVA','Api WhatsApp 2324','2025-11-22 13:11:42',NULL),(50,2,1,NULL,NULL,'PACOS.PE','GODDADY',NULL,1,328.99,'PEN','BANBIF','0623','ANUAL','2024-08-16','2026-08-15','ACTIVA','Redirige a BDivisas','2025-11-22 13:12:20',NULL),(51,2,1,NULL,NULL,'PACO.PE','GODDADY',NULL,1,328.99,'PEN','BANBIF','0623','ANUAL','2024-08-16','2026-08-15','ACTIVA','Api WhatsApp 2526','2025-11-22 13:13:00',NULL),(52,2,1,NULL,NULL,'PACOSMONEYEXCHANGE.COM','GODDADY',NULL,1,104.98,'PEN','BANBIF','0623','ANUAL','2024-08-16','2026-08-15','ACTIVA','Redirige a BDivisas','2025-11-22 13:13:59',NULL),(53,2,1,NULL,NULL,'PACOSMONEYEXCHANGE.PE','GODDADY',NULL,1,331.79,'PEN','BANBIF','0623','ANUAL','2024-08-16','2026-08-15','ACTIVA','Redirige a BDivisas','2025-11-22 13:14:41',NULL),(54,2,1,NULL,NULL,'SOLUCIONES-BD.COM','GODDADY',NULL,1,149.99,'PEN','BANBIF','0623','ANUAL','2024-03-15','2027-03-15','ACTIVA','Página Web / facturación','2025-11-22 13:15:23',NULL),(55,2,1,NULL,NULL,'TECNOLOGICAS-BD.COM','GODDADY',NULL,1,149.99,'PEN','BANBIF','0623','ANUAL','2024-03-15','2027-03-14','ACTIVA','Página Web / facturación','2025-11-22 13:15:55',NULL),(56,2,1,NULL,NULL,'INNOVADORAS-BD.COM','GODDADY',NULL,1,149.99,'PEN','BANBIF','0623','ANUAL','2024-03-15','2027-03-14','ACTIVA','Página Web / facturación','2025-11-22 13:16:34',NULL),(57,2,1,NULL,NULL,'CAMBIOSVARA.COM','GODDADY',NULL,1,303.47,'PEN','BANBIF','0623','ANUAL','2023-06-16','2028-06-15','ACTIVA','','2025-11-22 13:17:30',NULL),(58,2,1,NULL,NULL,'DATADIVISAS.PE','GODDADY',NULL,1,979.96,'PEN','BANBIF','0623','ANUAL','2022-12-03','2027-12-02','ACTIVA','Redirecciona a datadivisas (Innovadoras','2025-11-22 13:18:17',NULL),(59,5,1,NULL,NULL,'INFO@3TMI.PE','GODDADY',NULL,1,59.88,'PEN','BANBIF','0623','ANUAL','2025-04-19','2026-04-18','ACTIVA','Correo: 3tmi','2025-11-22 13:19:02',NULL),(60,5,1,NULL,NULL,'INFO@BOLSADEDIVISAS.COM','GODDADY',NULL,1,83.88,'PEN','BANBIF','0623','ANUAL','2025-01-26','2026-01-25','ACTIVA','Correo: bolsadedivisas','2025-11-22 13:19:53',NULL),(61,3,1,NULL,NULL,'ESET HOME SECURITY PREMIUM (10 EQUIPOS)','ESET',NULL,1,893.00,'PEN','BANBIF','0623','ANUAL','2024-03-19','2026-03-18','ACTIVA','','2025-11-22 13:21:12',NULL),(62,3,1,NULL,NULL,'ESET HOME SECURITY PREMIUM (5 EQUIPOS)','ESET',NULL,1,653.00,'PEN','BANBIF','0623','ANUAL','2024-03-19','2026-03-19','ACTIVA','','2025-11-22 13:22:11',NULL),(63,3,1,NULL,NULL,'ESET HOME SECURITY PREMIUM (10 EQUIPOS)','ESET',NULL,1,893.00,'PEN','BANBIF','0623','ANUAL','2024-03-16','2026-03-15','ACTIVA','','2025-11-22 13:22:52',NULL),(64,3,1,NULL,NULL,'ESET HOME SECURITY PREMIUM (10 EQUIPOS)','ESET',NULL,1,893.00,'PEN','BANBIF','0623','ANUAL','2024-03-15','2026-03-14','ACTIVA','','2025-11-22 13:23:22',NULL),(65,4,1,NULL,NULL,'CANVA PRO','CANVA',NULL,1,239.90,'PEN','BANBIF','0623','ANUAL','2025-10-17','2026-10-17','ACTIVA','','2025-11-22 13:24:05',NULL),(66,5,1,NULL,NULL,'GOOGLE ONE BUSINESS DIVISAS','GOOGLE',NULL,1,74.99,'PEN','BANBIF','0623','ANUAL','2025-11-22','2026-11-22','ACTIVA','','2025-11-22 13:25:09','2025-11-22 13:26:32'),(67,4,1,NULL,NULL,'GOOGLE ONE BOLSA DE DIVISAS','GOOGLE',NULL,1,74.99,'PEN','BANBIF','8173','ANUAL','2025-11-18','2026-11-18','ACTIVA','','2025-11-22 13:26:19','2025-11-24 06:07:37'),(68,4,1,NULL,NULL,'CHAT GPT PRO','CHAT GPT',NULL,1,20.00,'USD','BANBIF','8173','MENSUAL','2025-11-01','2026-12-01','ACTIVA','','2025-11-22 13:27:21',NULL),(69,6,1,NULL,NULL,'FACEBOOK 2324','META',NULL,1,11.76,'USD','BANBIF','8173','MENSUAL','2025-12-01','2026-02-01','ACTIVA','MENSUAL - RECIBO NRO: 25314250171593046','2025-11-22 13:28:11','2026-01-02 06:42:53'),(70,6,1,NULL,NULL,'FACEBOOK 2526','',NULL,1,10.00,'USD','BANBIF','8173','MENSUAL','2026-01-01','2026-02-01','ACTIVA','','2026-01-02 06:44:39',NULL);

--
-- Table structure for table `tabla_dinamica_videos`
--

CREATE TABLE `tabla_dinamica_videos` (
  `id` int NOT NULL AUTO_INCREMENT,
  `slug` varchar(60) NOT NULL,
  `fecha` date DEFAULT NULL,
  `titulo` varchar(200) DEFAULT NULL,
  `cols_rows` json NOT NULL,
  `drive_folder_id` varchar(128) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ux_tdv_slug` (`slug`),
  UNIQUE KEY `uniq_slug_fecha` (`slug`,`fecha`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `tabla_dinamica_videos`
--

INSERT INTO `tabla_dinamica_videos` VALUES (1,'videos',NULL,'Tabla dinámica de videos','{\"cols\": [\"EMPRESA\", \"OC\", \"INICIO\", \"USUARIO\", \"CONTRASEÑA\"], \"rows\": [[\"BUSINESS DIVISAS E INVERSIONES SC\", \"MITSU PACO PILLACA\", \"3/03/2022\", \"business.divisas@gmail.com\", \"business2020\"], [\"INVERSIONES Y NEGOCIOS BD SAC\", \"BRENDA BAZALAR MUÑOZ\", \"6/06/2023\", \"inversolbd@gmail.com\", \"business2020\"], [\"INVERSIONES Y SOLUCIONES B & D S.A.C.\", \"GENOBEBA PILLACA GARRIAZO\", \"1/08/2025\", \"inversolucionesbd@gmail.com\", \"business2020\"], [\"INVERSIONES TECNOLOGICAS BD SAC\", \"SOFIA CAJAHUAMAN MENDOZA\", \"9/08/2024\", \"invertecno23@gmail.com\", \"business2020\"], [\"INVERSIONES INNOVADORAS BD SAC\", \"ENMA ALAN PUYCAN\", \"14/03/2025\", \"innovadorasbd22@gmail.com\", \"business2020\"]]}',NULL,'2025-10-25 14:14:06','2025-10-31 18:10:33'),(2,'agenda_sbs',NULL,'Agenda SBS','{\"cols\": [\"HORA\", \"TEMA\", \"REPRESENTACIONES CARGO - FUNCIONES\", \"FECHA\", \"MODALIDAD\", \"VIDEO\"], \"rows\": [[\"09:00 - 09:20\", \"Inauguración de la Semana de Prevención del Lavado de Activos 2025\", \"- Sergio Espinosa Chiroque, Superintendente de Banca, Seguros y AFP- Massimo Bloch, Director de la Cooperación Económica Suiza- SECO en el Perú\", \"27/10/2025\", \"VIRTUAL\", {\"file\": {\"id\": 95, \"url\": \"https://drive.google.com/file/d/152wpuT8qsGupDIvOPvRdEeFXqdLFQaLW/view\", \"mime\": \"video/mp4\", \"name\": \"2025-10-27 09-40-11.mp4\", \"size\": 568072930}}], [\"09:20 - 10:00\", \"La ruta del dinero: Estrategia clave en la lucha contra la criminalidad\", \"- Expositor: Fernanda García-Yrigoyen, Superintendenta Adjunta de la Unidad de Inteligencia Financiera- Presentadora: Milagros Saldarriaga, SBS\", \"27/10/2025\", \"VIRTUAL\", {\"file\": {\"id\": 96, \"url\": \"https://drive.google.com/file/d/1gwiTgcQEyOGKeTNJfPbllj5_D6tgyXQT/view\", \"mime\": \"video/mp4\", \"name\": \"2025-10-27 18-03-32.remuxed.mp4\", \"size\": 140506648}}], [\"10:00 - 10:30\", \"Panel: Rol y desafíos de los principales actores en la lucha contra el Lavado de Activos\", \"- Fernanda García Yrigoyen, Superintendente Adjunta de la Unidad de Inteligencia Financiera (SAUIF)- Bárbara Castro, Asociación de Bancos del Perú (ASBANC)- Jhony Contreras, Poder Judicial del Perú (PJ)- Eugenio Paúcar, Policía Nacional del Perú (PNP)\", \"27/10/2025\", \"VIRTUAL\", {\"file\": {\"id\": 99, \"url\": \"https://drive.google.com/file/d/152wpuT8qsGupDIvOPvRdEeFXqdLFQaLW/view\", \"mime\": \"video/mp4\", \"name\": \"2025-10-27 09-40-11 (2).mp4\", \"size\": 568072930}}], [\"16:00 - 17:00\", \"Los sujetos obligados: La primera línea de defensa para combatir el Lavado de Activos\", \"- Expositora: Diana Yon, Grupo de Acción Financiera de Latinoamérica (GAFILAT)Moderadora: Luisa Córdova, SBS\", \"27/10/2025\", \"VIRTUAL\", {\"file\": {\"id\": 101, \"url\": \"https://drive.google.com/file/d/1u1mDFya62N2wcnDFgsP6zpvKShZwMpO1/view\", \"mime\": \"video/mp4\", \"name\": \"2025-10-27 15-59-50.remuxed (2).mp4\", \"size\": 352781421}}], [\"17:30 - 18:30\", \"Sancionar o prevenir:  el rol de los organismos supervisores\", \"- Luz Chiong, SBS- Daniela Tang, SBS\", \"27/10/2025\", \"VIRTUAL\", {\"file\": {\"id\": 97, \"url\": \"https://drive.google.com/file/d/1o98pvsKf-VhxXH0MrbQIhVCWBprKebCW/view\", \"mime\": \"video/mp4\", \"name\": \"2025-10-27 17-52-55.remuxed.mp4\", \"size\": 89487072}}], [\"09:00 - 10:00\", \"Radiografía de los delitos de extorsión y corrupción en el Perú y Latinoamérica\", \"Expositor:  Pablo Zeballos, consultor internacional y experto en crimen organizadoModerador: Marcos Soto, SBS\", \"28/10/2025\", \"VIRTUAL\", {\"file\": {\"id\": 93, \"url\": \"https://drive.google.com/file/d/1Q7CPPgKwbLFhNuV9T5iWE_hXrWgIwedI/view\", \"mime\": \"video/mp4\", \"name\": \"2025-10-28 08-59-58.mp4\", \"size\": 563814857}}], [\"10:30 - 11:30\", \"Tipologías del lavado de activos provenientes del delito de la extorsión\", \"Expositora:  Karla Camacho, SBSModeradora: Katia Pasco, SBS\", \"28/10/2025\", \"VIRTUAL\", {\"file\": {\"id\": 92, \"url\": \"https://drive.google.com/file/d/1yDUIqMNWnkrpyq-Mg8Tj2AEiarIjnQhp/view\", \"mime\": \"video/mp4\", \"name\": \"2025-10-28 10-30-42.mp4\", \"size\": 147158418}}], [\"12:00 - 13:00\", \"Corrupción y lavado de activos: Dos delitos que socaban la gobernabilidad\", \"Expositores: Martha Monterrosa, Organización para la Cooperación y el Desarrollo Económicos (OCDE)Comentarista: Carlos Villena, Comisión de Alto Nivel Anticorrupción (CAN)Presentadora: Ana Navas, SBS\", \"28/10/2025\", \"VIRTUAL\", {\"file\": {\"id\": 91, \"url\": \"https://drive.google.com/file/d/12aojPCSvCSqmoVKo4zVANubQdSbdSYeJ/view\", \"mime\": \"video/mp4\", \"name\": \"2025-10-28 12-00-42.mp4\", \"size\": 560137070}}], [\"16:00 - 17:00\", \"Congelamiento de activos: Herramienta clave contra el crimen organizado\", \"Expositores: Tomasita Pazos,SBS , Lorena Terrones, SBSComentarista: Silvia de la Cruz, Ministerio del Interior del Perú (Mininter)Presentadora: Katia Pasco, SBS\", \"28/10/2025\", \"VIRTUAL\", {\"file\": {\"id\": 105, \"url\": \"https://drive.google.com/file/d/1TooiicQoVm0uMREucq8yv7z8-gvo8-c7/view\", \"mime\": \"video/mp4\", \"name\": \"2025-10-28 16-00-59.mp4\", \"size\": 370833235}}], [\"17:30 - 18:30\", \"Tipologías relacionadas a Lavado de Activos provenientes de Delitos Contra la Administración Pública\", \"Expositora: Sally Paredes, SBS /  Comentarista: Alicia Arévalo, Contraloría General de la República del Perú  /  Presentadora: Ana Navas, SBS\", \"28/10/2025\", \"VIRTUAL\", {\"file\": {\"id\": 107, \"url\": \"https://drive.google.com/file/d/1RN_m7cYDVpBvQ44y6Bv3-dqYMSaF927m/view\", \"mime\": \"video/mp4\", \"name\": \"2025-10-28 17-30-37.mp4\", \"size\": 289092513}}], [\"09:00 - 10:00\", \"Uso de las nuevas tecnologías en la criminalidad organizada\", \"Expositor:  Guillermo García, Estudio García Orué de Paraguay   /  Moderadora: Fanny Acevedo, SBS\", \"29/10/2025\", \"VIRTUAL\", {\"file\": {\"id\": 109, \"url\": \"https://drive.google.com/file/d/1JVJbWp1FUKNkflwbbPY4qvpnzGms4K5h/view\", \"mime\": \"video/mp4\", \"name\": \"2025-10-29 09-05-29.mp4\", \"size\": 484150462}}], [\"10:30 - 11:30\", \"Riesgos de lavado de activos provenientes de los delitos de trata de personas en el Perú y sus tipologías\", \"Expositores:  Mauro Rojas, Capital Humano y Social Alternativo (CHS Alternativo),  /   Sally Paredes, SBS  /  Moderadora: Luis Marticorena, SBS\", \"29/10/2025\", \"VIRTUAL\", {\"file\": {\"id\": 111, \"url\": \"https://drive.google.com/file/d/1d4bgtiwWFSi5XhasyiXwh_AgJbJH5yy9/view\", \"mime\": \"video/mp4\", \"name\": \"2025-10-29 10-31-26.mp4\", \"size\": 262943422}}], [\"12:00 - 13:00\", \"Big data y machine learning en la detección del lavado de activos\", \"Expositora: Louredes Galarza, SBS  /  Moderador: Roger Lazo, SBS\", \"29/10/2025\", \"VIRTUAL\", {\"file\": {\"id\": 116, \"url\": \"https://drive.google.com/file/d/1oA3OM5I2kv9BfIDeVUWqcIjSK_qg77vk/view\", \"mime\": \"video/mp4\", \"name\": \"2025-10-29 12-04-10 (2).mp4\", \"size\": 273612908}}], [\"16:00 - 17:00\", \"Criptoactivos: Definición, riesgos y medidas de control\", \"Expositor: Luis Daza, Consultor internacional en materia del LAFT  /  Moderadora: Jimenez, SBS\", \"29/10/2025\", \"VIRTUAL\", {\"file\": {\"id\": 117, \"url\": \"https://drive.google.com/file/d/1lPIBwzWJJ0U9C-pAEybOjcp8Rxq5oS4b/view\", \"mime\": \"video/mp4\", \"name\": \"2025-10-29 16-01-18.mp4\", \"size\": 437112640}}], [\"17:30 - 18:30\", \"Casos reales de Lavado de Activos provenientes del ciberdelito \", \"Expositor: Alfonso Martel, Experto cripto de Argentina  /  Comentarista: Denis Banchero, Fiscalía de Ciberdelitos de Argentina  /  Presentadora: Paola Torres, SBS\", \"29/10/2025\", \"VIRTUAL\", {\"file\": {\"id\": 124, \"url\": \"https://drive.google.com/file/d/1RX8Bdyp-3AwGT6MjkgAnkBftE89f3aow/view\", \"mime\": \"video/mp4\", \"name\": \"2025-10-29 17-36-29 (2).mp4\", \"size\": 408686511}}], [\"09:00 - 10:00\", \"Trata de personas y corrupción en el marco de un crimen organizado\", \"Expositora: Jennifer Flores, Oficina de las Nacionenidas contra la Droga y el Delito (UNODC)  /  Presentadora: Katia Pasco, SBS\", \"30/10/2025\", \"VIRTUAL\", {\"file\": {\"id\": 122, \"url\": \"https://drive.google.com/file/d/156x-0aT0o3kw66iGoDF_aNEoPEpCsXn2/view\", \"mime\": \"video/mp4\", \"name\": \"2025-10-30 09-21-59.mp4\", \"size\": 422819991}}], [\"10:30 - 11:30\", \"Riesgos de lavado de activos provenientes de los delitos ambientales y sus tipologías\", \"Expositores:  Luis Marticorena, SBS; Diego Ulloa, SBS  /  Comentarista: Miguel Sanchez, Procuraduría General del Estado de Perú (PGE)  /  Presentadora: Karen Lezma, SBS\", \"30/10/2025\", \"VIRTUAL\", {\"file\": {\"id\": 126, \"url\": \"https://drive.google.com/file/d/1OglOZk-61MWS-MsyXCejO_sdut1pDDXK/view\", \"mime\": \"video/mp4\", \"name\": \"2025-10-30 11-00-29.mp4\", \"size\": 229866909}}], [\"12:00 - 13:00\", \"Tipologías de lavado de activos provenientes del cibercrimen\", \"Expositora: Mariana Kieffer, Oficina de las Naciones Unidas contra la Droga y el Delito (UNODC)  /  Moderador: Diego Gonzales, SBS\", \"30/10/2025\", \"VIRTUAL\", {\"file\": {\"id\": 127, \"url\": \"https://drive.google.com/file/d/1zFa_J03oNBTh22vzFbFPOw-Fisapfroe/view\", \"mime\": \"video/mp4\", \"name\": \"2025-10-30 12-01-02.mp4\", \"size\": 456427093}}], [\"16:00 - 17:00\", \"La importancia de las investigaciones financieras paralelas \", \"Expositor: Juan Cruz, Grupo de Acción Financiera de Latinoamérica (GAFILAT)  /  Comentarista: Mirko Cano, Ministerio Público  /  Presentadora: Katia Pasco, SBS\", \"30/10/2025\", \"VIRTUAL\", {\"file\": {\"id\": 132, \"url\": \"https://drive.google.com/file/d/1lLUtbYCRliBedyjcymN__khLbCYuXV71/view\", \"mime\": \"video/mp4\", \"name\": \"2025-10-30 16-02-05 (2).mp4\", \"size\": 332095531}}], [\"17:30 - 18:30\", \"El desarrollo de la prueba en los procesos de lavado de activos\", \"Expositor: María Guillén, Poder Judicial del Perú  /  Moderadora: Ana Navas, SBS\", \"30/10/2025\", \"VIRTUAL\", {\"file\": {\"id\": 134, \"url\": \"https://drive.google.com/file/d/101-HXe2CClwjXVBFZ61AcGDNCZIRN9yC/view\", \"mime\": \"video/mp4\", \"name\": \"2025-10-30 17-33-56.mp4\", \"size\": 436109428}}], [\"09:00 - 10:00\", \"Construyendo confianza en el Sistema de Prevención de Lavado de Activos y Financiamiento del Terrorismo - SPLAFT:  Debida diligencia del conocimiento del cliente   \", \"Expositora:  Victoria Prada, SBS  /  Moderadora: Fanny Acevedo, SBS\", \"31/10/2025\", \"VIRTUAL\", {\"file\": {\"id\": 135, \"url\": \"https://drive.google.com/file/d/1tz9958Dv3MWuybLTHpVT5aMLUebhXng1/view\", \"mime\": \"video/mp4\", \"name\": \"2025-10-31 09-00-46.mp4\", \"size\": 393360149}}], [\"10:30 - 11:30\", \"ROS de calidad: El pilar fundamental para la detección de delitos de lavado de activos\", \"Expositora:  Juan Suarez, SBS  /  Moderadora: Wilber Mayca, SBS\", \"31/10/2025\", \"VIRTUAL\", {\"file\": {\"id\": 137, \"url\": \"https://drive.google.com/file/d/1yTjWqsf863z95OvAzRvA3ySbNn20wTWG/view\", \"mime\": \"video/mp4\", \"name\": \"2025-10-31 10-30-59.mp4\", \"size\": 218939146}}], [\"12:00 - 13:00\", \"Una mirada al futuro del Perú en su lucha contra el lavado de activos: Autodiagnóstico del sistema y Política Nacional contra el Lavado de Activos al 2030 \", \"Expositora: Alejandra Quevedo, consultora internacional en materia del LA/FT  /  Moderador: Enzo Paredes, SBS\", \"31/10/2025\", \"VIRTUAL\", {\"file\": {\"id\": 139, \"url\": \"https://drive.google.com/file/d/1PTcLUSCWcONawgm_kbayw6lmHkGDcq-b/view\", \"mime\": \"video/mp4\", \"name\": \"2025-10-31 12-02-02.mp4\", \"size\": 294066551}}]]}',NULL,'2025-10-25 16:00:06','2026-01-07 15:40:08');

--
-- Table structure for table `tablas_dinamicas`
--

CREATE TABLE `tablas_dinamicas` (
  `id` int NOT NULL AUTO_INCREMENT,
  `slug` varchar(120) NOT NULL,
  `fecha` date NOT NULL,
  `titulo` varchar(200) DEFAULT NULL,
  `json_data` longtext NOT NULL,
  `prov_ruc` varchar(20) DEFAULT NULL,
  `prov_razon_social` varchar(200) DEFAULT NULL,
  `prov_direccion` varchar(250) DEFAULT NULL,
  `prov_nro` varchar(50) DEFAULT NULL,
  `usuario_id` int DEFAULT NULL,
  `creado_en` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `actualizado_en` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uniq_fecha` (`fecha`)
) ENGINE=InnoDB AUTO_INCREMENT=66 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `tablas_dinamicas`
--

INSERT INTO `tablas_dinamicas` VALUES (1,'productos_limpieza','2025-06-25','Productos de Limpieza','{\"cols\":[\"CANT.\",\"PRODUCTO\",\"UNI\",\"V. UNI\",\"IGV\",\"P. UNI\",\"BR - YOYISS\",\"JM - 212 BD\",\"JM - 315\",\"JM - 304\",\"BR - DPT\",\"SJM\",\"STOCK\"],\"rows\":[[\"2\",\"PAPEL HIGENICO JUMBO 550 MT LEXA\",\"ROLLOS\",\"50.85\",\"9.15\",\"60.00\",\"1\",\"\",\"\",\"\",\"\",\"\",\"1\"],[\"2\",\"DISPENSADOR DE PAPEL HIGENICO MASTER\",\"UNID\",\"38.14\",\"6.87\",\"45.01\",\"\",\"\",\"\",\"\",\"\",\"\",\"2\"],[\"4\",\"TRAPEADOR MICROFIBRA\",\"UNID\",\"3.81\",\"0.69\",\"4.50\",\"\",\"\",\"\",\"\",\"\",\"\",\"4\"],[\"1\",\"SACO DETERGENTE DOFI - 15 KILOS\",\"KILO\",\"53.39\",\"9.61\",\"63.00\",\"\",\"\",\"\",\"\",\"\",\"\",\"1\"],[\"3\",\"DISPENSADOR DE JABON LIQUIDO EBRIEL\",\"UNID\",\"38.14\",\"6.87\",\"45.01\",\"\",\"\",\"\",\"\",\"\",\"\",\"3\"],[\"1\",\"GATILLO DE CUEÑOS Y PUÑOS\",\"UNID\",\"10.17\",\"1.83\",\"12.00\",\"\",\"\",\"\",\"\",\"\",\"\",\"1\"],[\"1\",\"GATILLO AROMA PARA PARA ROPA\",\"UNID\",\"22.88\",\"4.12\",\"27.00\",\"\",\"\",\"\",\"\",\"\",\"\",\"1\"],[\"1\",\"GALON DE ALCOHOL EN GEL\",\"GALON\",\"27.12\",\"4.88\",\"32.00\",\"\",\"\",\"\",\"\",\"\",\"\",\"1\"],[\"1\",\"GALON JABOL LIQUIDO ELITE\",\"GALON\",\"38.14\",\"6.87\",\"45.01\",\"\",\"\",\"\",\"\",\"\",\"\",\"1\"],[\"1\",\"SAL DE SODA\",\"KILO\",\"4.24\",\"0.76\",\"5.00\",\"\",\"\",\"\",\"\",\"\",\"\",\"1\"],[\"2\",\"PAÑOS HUMEDOS\",\"UNID\",\"5.93\",\"1.07\",\"7.00\",\"\",\"\",\"\",\"\",\"\",\"\",\"2\"],[\"1\",\"CIF CREMA\",\"UNID\",\"12.71\",\"2.29\",\"15.00\",\"\",\"\",\"\",\"\",\"\",\"\",\"1\"],[\"5\",\"ESPONJA DE COLORES CON ALAMBRE\",\"UNID\",\"1.27\",\"0.23\",\"1.50\",\"\",\"\",\"\",\"\",\"\",\"\",\"5\"],[\"1\",\"MAQUINITA\",\"UNID\",\"2.97\",\"0.53\",\"3.50\",\"\",\"\",\"\",\"\",\"\",\"\",\"1\"],[\"3\",\"LAVAVAJILLAS \",\"UNID\",\"5.93\",\"1.07\",\"7.00\",\"\",\"\",\"\",\"\",\"\",\"\",\"3\"],[\"1\",\"GALON LIMPIATODO\",\"GALON\",\"8.47\",\"1.52\",\"9.99\",\"\",\"\",\"\",\"\",\"\",\"\",\"1\"],[\"1\",\"GALON QUITAMANCHAS\",\"GALON\",\"16.95\",\"3.05\",\"20.00\",\"\",\"\",\"\",\"\",\"\",\"\",\"1\"],[\"1\",\"AROMATIZANTE  DE VAINILLA EN SPRAY SAPOLIO\",\"UNID\",\"5.08\",\"0.91\",\"5.99\",\"\",\"\",\"\",\"\",\"\",\"\",\"1\"],[\"4\",\"PASTILLA AZUL DE BAÑO\",\"UNID\",\"3.39\",\"0.61\",\"4.00\",\"\",\"\",\"\",\"\",\"\",\"\",\"4\"],[\"1\",\"PAÑO AMARILLO VITUREX X 20\",\"UNID\",\"13.56\",\"2.44\",\"16.00\",\"\",\"\",\"\",\"\",\"\",\"\",\"1\"],[\"1\",\"PLANCHA DE PAPEL TOALLA BEVADO BLANCO\",\"UNID\",\"38.14\",\"6.87\",\"45.01\",\"\",\"\",\"\",\"\",\"\",\"\",\"1\"],[\"2\",\"COLGADOS DE ROPAS\",\"UNID\",\"12.71\",\"2.29\",\"15.00\",\"\",\"\",\"\",\"\",\"\",\"\",\"2\"],[\"3\",\"JABON TROMEN\",\"UNID\",\"2.12\",\"0.38\",\"2.50\",\"\",\"\",\"\",\"\",\"\",\"\",\"3\"],[\"3\",\"GLADE EN GEL\",\"UNID\",\"5.93\",\"1.07\",\"7.00\",\"\",\"\",\"\",\"\",\"\",\"\",\"3\"],[\"2\",\"GLADE AUTO\",\"UNID\",\"21.19\",\"3.81\",\"25.00\",\"\",\"\",\"\",\"\",\"\",\"\",\"2\"],[\"1\",\"FRASCO DE LIMPIEZA PARA MELAMINE\",\"UNID\",\"10.17\",\"1.83\",\"12.00\",\"\",\"\",\"\",\"\",\"\",\"\",\"1\"]],\"_drive\":{\"folderId\":\"1EyEJvE4fTZD2KP1wyOjEva7zHdcgA61v\",\"files\":[{\"id\":\"1QuNvUsiQZMcD6GP2izs7OBlvqCP6jD5y\",\"name\":\"1198920448720772.pdf\",\"mime\":\"application\\/pdf\",\"size\":21452,\"url\":\"https:\\/\\/drive.google.com\\/file\\/d\\/1QuNvUsiQZMcD6GP2izs7OBlvqCP6jD5y\\/view?usp=drivesdk\",\"download\":\"https:\\/\\/drive.google.com\\/uc?id=1QuNvUsiQZMcD6GP2izs7OBlvqCP6jD5y&export=download\"},{\"id\":\"1dVOMLhXmVj158b--a8WqDg9yRVZ7_JyS\",\"name\":\"827821399832583.pdf\",\"mime\":\"application\\/pdf\",\"size\":19280,\"url\":\"https:\\/\\/drive.google.com\\/file\\/d\\/1dVOMLhXmVj158b--a8WqDg9yRVZ7_JyS\\/view?usp=drivesdk\",\"download\":\"https:\\/\\/drive.google.com\\/uc?id=1dVOMLhXmVj158b--a8WqDg9yRVZ7_JyS&export=download\"}]}}','20608537016','SHUMAC CLEAN S.A.C.','AV. ALEJANDRO TIRADO NRO. 724 URB. SANTA BEATRIZ LIMA','951 911 002',NULL,'2025-06-25 08:15:54','2025-10-24 11:59:58'),(64,'productos_limpieza','2025-10-24','Productos de Limpieza','{\"cols\":[\"CANT.\",\"PRODUCTO\",\"UNI\",\"V. UNI\",\"IGV\",\"P. UNI\",\"BR - YOYISS\",\"JM - 212 BD\",\"JM - 315\",\"JM - 304\",\"BR - DPT\",\"SJM\",\"STOCK\"],\"rows\":[[\"2\",\"DISPENSADOR DE PAPEL HIGENICO MASTER\",\"UNID\",\"38.14\",\"6.87\",\"45.01\",\"\",\"\",\"\",\"\",\"\",\"\",\"2\"],[\"2\",\"PAPEL HIGENICO JUMBO 550 MT LEXA\",\"ROLLOS\",\"50.85\",\"9.15\",\"60.00\",\"1\",\"\",\"\",\"\",\"\",\"\",\"1\"],[\"4\",\"TRAPEADOR MICROFIBRA\",\"UNID\",\"3.81\",\"0.69\",\"4.50\",\"\",\"\",\"\",\"\",\"\",\"\",\"4\"],[\"1\",\"SACO DETERGENTE DOFI - 15 KILOS\",\"KILO\",\"53.39\",\"9.61\",\"63.00\",\"\",\"\",\"\",\"\",\"\",\"\",\"1\"],[\"3\",\"DISPENSADOR DE JABON LIQUIDO EBRIEL\",\"UNID\",\"38.14\",\"6.87\",\"45.01\",\"\",\"\",\"\",\"\",\"\",\"\",\"3\"],[\"1\",\"GATILLO DE CUEÑOS Y PUÑOS\",\"UNID\",\"10.17\",\"1.83\",\"12.00\",\"\",\"\",\"\",\"\",\"\",\"\",\"1\"],[\"1\",\"GATILLO AROMA PARA PARA ROPA\",\"UNID\",\"22.88\",\"4.12\",\"27.00\",\"\",\"\",\"\",\"\",\"\",\"\",\"1\"],[\"1\",\"GALON DE ALCOHOL EN GEL\",\"GALON\",\"27.12\",\"4.88\",\"32.00\",\"\",\"\",\"\",\"\",\"\",\"\",\"1\"],[\"1\",\"GALON JABOL LIQUIDO ELITE\",\"GALON\",\"38.14\",\"6.87\",\"45.01\",\"\",\"\",\"\",\"\",\"\",\"\",\"1\"],[\"1\",\"SAL DE SODA\",\"KILO\",\"4.24\",\"0.76\",\"5.00\",\"\",\"\",\"\",\"\",\"\",\"\",\"1\"]]}','00000000000','PRUEBA SAC','------','987456321',NULL,'2025-10-24 11:11:18','2025-10-24 12:50:40'),(65,'productos_limpieza','2025-11-07','Productos de Limpieza (2025-11-07)','{\"cols\":[\"CANT.\",\"PRODUCTO\",\"UNI\",\"V. UNI\",\"IGV\",\"P. UNI\",\"BR - YOYISS\",\"JM - 212 BD\",\"JM - 315\",\"JM - 304\",\"BR - DPT\",\"SJM\",\"STOCK\"],\"rows\":[[\"2\",\"DISPENSADOR DE PAPEL HIGENICO MASTER\",\"UNID\",\"38.14\",\"6.87\",\"45.01\",\"\",\"\",\"\",\"\",\"\",\"\",\"2\"],[\"2\",\"PAPEL HIGENICO JUMBO 550 MT LEXA\",\"ROLLOS\",\"50.85\",\"9.15\",\"60.00\",\"1\",\"\",\"\",\"\",\"\",\"\",\"1\"],[\"4\",\"TRAPEADOR MICROFIBRA\",\"UNID\",\"3.81\",\"0.69\",\"4.50\",\"\",\"\",\"\",\"\",\"\",\"\",\"4\"],[\"1\",\"SACO DETERGENTE DOFI - 15 KILOS\",\"KILO\",\"53.39\",\"9.61\",\"63.00\",\"\",\"\",\"\",\"\",\"\",\"\",\"1\"],[\"3\",\"DISPENSADOR DE JABON LIQUIDO EBRIEL\",\"UNID\",\"38.14\",\"6.87\",\"45.01\",\"\",\"\",\"\",\"\",\"\",\"\",\"3\"],[\"1\",\"GATILLO DE CUEÑOS Y PUÑOS\",\"UNID\",\"10.17\",\"1.83\",\"12.00\",\"\",\"\",\"\",\"\",\"\",\"\",\"1\"],[\"1\",\"GATILLO AROMA PARA PARA ROPA\",\"UNID\",\"22.88\",\"4.12\",\"27.00\",\"\",\"\",\"\",\"\",\"\",\"\",\"1\"],[\"1\",\"GALON DE ALCOHOL EN GEL\",\"GALON\",\"27.12\",\"4.88\",\"32.00\",\"\",\"\",\"\",\"\",\"\",\"\",\"1\"],[\"1\",\"GALON JABOL LIQUIDO ELITE\",\"GALON\",\"38.14\",\"6.87\",\"45.01\",\"\",\"\",\"\",\"\",\"\",\"\",\"1\"],[\"1\",\"SAL DE SODA\",\"KILO\",\"4.24\",\"0.76\",\"5.00\",\"\",\"\",\"\",\"\",\"\",\"\",\"1\"]]}','00000000000','PRUEBA SAC','------','987456321',NULL,'2025-11-07 11:59:09','2025-11-07 11:59:09');

--
-- Table structure for table `tablas_dinamicas_adjuntos`
--

CREATE TABLE `tablas_dinamicas_adjuntos` (
  `id` int NOT NULL AUTO_INCREMENT,
  `tabla_id` int NOT NULL,
  `filename` varchar(255) NOT NULL,
  `original_name` varchar(255) NOT NULL,
  `mime` varchar(100) NOT NULL,
  `size` int NOT NULL,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `tabla_id` (`tabla_id`),
  CONSTRAINT `fk_tda_tabla` FOREIGN KEY (`tabla_id`) REFERENCES `tablas_dinamicas` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `tablas_dinamicas_adjuntos`
--


--
-- Table structure for table `tarea_categoria`
--

CREATE TABLE `tarea_categoria` (
  `categoria_id` int NOT NULL AUTO_INCREMENT,
  `nombre` varchar(200) NOT NULL,
  `orden` int NOT NULL DEFAULT '1',
  `activo` tinyint(1) NOT NULL DEFAULT '1',
  `anio` smallint NOT NULL DEFAULT '2025',
  `mes` tinyint NOT NULL DEFAULT '1',
  `usuario_id` int NOT NULL,
  PRIMARY KEY (`categoria_id`),
  KEY `idx_cat_periodo` (`anio`,`mes`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
