[BLOB]\"></li>\n<li data-done=\"0\">Termino y condiciones&nbsp; (Operaciones presenciales - Virtuales) definir</li>\n<li data-done=\"0\">&nbsp;</li>\n</ul>\n<p style=\"text-align: center;\"><span style=\"text-decoration: underline; font-size: 18pt;\"><strong>2025</strong></span></p>\n<table style=\"border-collapse: collapse; width: 100%;\" border=\"1\"><colgroup><col style=\"width: 65.5831%;\"><col style=\"width: 7.97368%;\"><col style=\"width: 7.75916%;\"><col style=\"width: 9.62135%;\"><col style=\"width: 9.00062%;\"></colgroup>\n<tbody>\n<tr>\n<td>\n<h3 data-start=\"142\" data-end=\"172\"><span style=\"font-size: 12pt;\">1. <strong data-start=\"149\" data-end=\"172\">Visi&oacute;n y Estrategia</strong></span></h3>\n</td>\n<td>SEPTIEMBRE</td>\n<td>OCTUBRE</td>\n<td>NOVIEMBRE</td>\n<td>DICIEMBRE</td>\n</tr>\n<tr>\n<td>\n<ul>\n<li>Definir la misi&oacute;n, visi&oacute;n y objetivos del negocio.</li>\n</ul>\n</td>\n<td>&nbsp;</td>\n<td>&nbsp;</td>\n<td>&nbsp;</td>\n<td>&nbsp;</td>\n</tr>\n<tr>\n<td>\n<ul>\n<li>Establecer estrategias a corto, mediano y largo plazo.</li>\n</ul>\n</td>\n<td>&nbsp;</td>\n<td>&nbsp;</td>\n<td>&nbsp;</td>\n<td>&nbsp;</td>\n</tr>\n<tr>\n<td>\n<ul>\n<li>Identificar oportunidades de crecimiento y expansi&oacute;n.</li>\n</ul>\n</td>\n<td>&nbsp;</td>\n<td>&nbsp;</td>\n<td>&nbsp;</td>\n<td>&nbsp;</td>\n</tr>\n<tr>\n<td>&nbsp;</td>\n<td>&nbsp;</td>\n<td>&nbsp;</td>\n<td>&nbsp;</td>\n<td>&nbsp;</td>\n</tr>\n</tbody>\n</table>\n<p><span style=\"text-decoration: underline;\"><strong>T&eacute;rminos y Condiciones del Servicio Digital de Cambio de Divisas de DIBEX | Aviso Legal</strong></span></p>\n<p>&nbsp;</p>\n<p>&Eacute;RMINOS Y CONDICIONES APLICABLES PARA EL SERVICIO CAMBIO DE MONEDA POR MEDIOS DIGITALES<br>AVISO LEGAL<br>EL CLIENTE, acepta que los servicios contratados con KALLPA SAB por este medio no permiten efectuar operaciones de<br>intermediaci&oacute;n de valores en mecanismos centralizados de negociaci&oacute;n que operen en Bolsas autorizadas o fuera de ellas.<br>Asimismo, en ning&uacute;n caso, deber&aacute; entregar dinero en efectivo a KALLPA SAB o a sus Representantes para la realizaci&oacute;n de sus<br>operaciones. EL CLIENTE debe efectuar sus pagos &uacute;nicamente a trav&eacute;s de las cuentas operativas de KALLPA SAB.<br>Cl&aacute;usula Primera.- Introducci&oacute;n<br>KALLPA SECURITIES SOCIEDAD AGENTE DE BOLSA S.A. (en adelante, &ldquo;KALLPA SAB&rdquo;) es una sociedad an&oacute;nima autorizada<br>para funcionar como sociedad agente de bolsa mediante Resoluci&oacute;n CONASEV N&deg; 049-2008-EF/94.01.1 de fecha 14 de agosto de<br>2008. Asimismo, KALLPA SAB est&aacute; inscrita en el Registro de Casas de Cambio, Pr&eacute;stamos y Empe&ntilde;o de la Superintendencia de<br>Banca, Seguros y AFP (SBS) y autorizada para realizar operaciones de cambio de moneda, conforme a lo establecido en la<br>Resoluci&oacute;n SBS N&deg; 01413-2019.<br>Cl&aacute;usula Segunda.- Objeto<br>KALLPA SAB comunica a EL CLIENTE los siguientes t&eacute;rminos y condiciones a efectos de brindar el servicio de compra y venta de<br>moneda extranjera a trav&eacute;s de medios digitales de conformidad con las operaciones detalladas en el art&iacute;culo 194 de la Ley del<br>Mercado de Valores (LMV), y bajo las normas relacionadas con la prevenci&oacute;n de lavado de activos y financiamiento del terrorismo<br>dictadas por la Superintendencia del Mercado de Valores y la Unidad de Inteligencia Financiera UIF &ndash; PERU. El servicio de cambio<br>de moneda es ofrecido a trav&eacute;s de la p&aacute;gina web &ldquo;www.kallpacambios.com&rdquo; (en adelante, &ldquo;LA PLATAFORMA&rdquo;) y la aplicaci&oacute;n para<br>equipos m&oacute;viles &ldquo;KALLPA CAMBIOS&rdquo; (en adelante &ldquo;LA APLICACI&Oacute;N&rdquo;) disponible para los sistemas operativos IOS y Android.<br>Cl&aacute;usula Tercera.- Registro de EL CLIENTE<br>3.1 El servicio de cambio de moneda a trav&eacute;s de LA PLATAFORMA y LA APLICACI&Oacute;N est&aacute; dirigido a personas naturales<br>mayores de 18 de a&ntilde;os de edad.<br>3.2 El usuario adquiere la condici&oacute;n de CLIENTE luego del registro de su informaci&oacute;n personal en LA PLATAFORMA o LA<br>APLICACI&Oacute;N. KALLPA SAB podr&aacute; realizar las acciones que considere necesarias para verificar la autenticidad de la identidad de EL<br>CLIENTE. En ese sentido, KALLPA SAB podr&aacute; requerir a EL CLIENTE informaci&oacute;n de identificaci&oacute;n adicional. Asimismo, KALLPA<br>SAB podr&aacute; solicitar informaci&oacute;n a las entidades estatales y privadas que correspondan, a fin de validar la informaci&oacute;n recibida de<br>parte de EL CLIENTE.<br>3.4 EL CLIENTE deber&aacute; registrar dos (02) cuentas bancarias (una en Soles y otra en D&oacute;lares de los Estados Unidos de<br>Am&eacute;rica) en las cuales KALLPA SAB abonar&aacute; el monto correspondiente a la operaci&oacute;n de cambio de moneda. Dichas cuentas<br>deber&aacute;n estar constituidas en alguno de los siguientes bancos: Banco de Cr&eacute;dito del Per&uacute; (BCP), Interbank, Scotiabank Per&uacute;, Banco<br>Pichincha o BBVA Per&uacute;. Las cuentas registradas deber&aacute;n ser de titularidad de EL CLIENTE.<br>3.5 La cuenta constituida por EL CLIENTE en KALLPA SAB es de uso personal e intransferible.<br>3.6 EL CLIENTE deber&aacute; seleccionar una contrase&ntilde;a para el acceso a su cuenta en LA PLATAFORMA o LA APLICACI&Oacute;N. EL<br>CLIENTE es responsable de la adecuada custodia de la contrase&ntilde;a personal.<br>3.7 En caso se detecten registros de clientes duplicados (por correo electr&oacute;nico, documento de identidad, o cualquier otro<br>criterio), KALLPA SAB podr&aacute; cerrar o fusionar las mismas, sin previo aviso al titular.<br>Cl&aacute;usula Cuarta.- Servicio ofrecido a trav&eacute;s de LA PLATAFORMA y LA APLICACI&Oacute;N.<br>4.1 KALLPA SAB pone a disposici&oacute;n de EL CLIENTE el servicio de cambio de moneda extranjera a trav&eacute;s de LA<br>PLATAFORMA y LA APLICACI&Oacute;N. El uso y navegaci&oacute;n en LA PLATAFORMA y LA APLICACI&Oacute;N tienen car&aacute;cter libre, no obstante,<br>KALLPA SAB se reserva el derecho de negar o restringir en cualquier momento el acceso total o parcial a LA PLATAFORMA y LA<br>APLICACI&Oacute;N cuando exista una causa relacionada a la seguridad, operaciones fraudulentas y/o delictivas, privacidad, libertad de<br>contratar, identificaciones falsas, o cualquier otra que considere razonable para ello.<br>4.2 La prestaci&oacute;n del servicio de cambio de moneda se realizar&aacute; en horario corrido de lunes a viernes de 9:30 horas a 17:00<br>horas. El horario comprende s&oacute;lo los d&iacute;as h&aacute;biles. Las solicitudes de cambio de moneda registradas fuera del horario de atenci&oacute;n<br>podr&aacute;n ser procesadas al siguiente d&iacute;a h&aacute;bil bajo las condiciones que rijan al momento de su ejecuci&oacute;n.<br>4.3 El servicio de cambio de moneda se brindar&aacute; bajo los siguientes procedimientos:<br>4.3.1 KALLPA SAB publicar&aacute; en LA PLATAFORMA y LA APLICACION el tipo de cambio al que se realizar&aacute; la operaci&oacute;n.<br>4.3.2 EL CLIENTE deber&aacute; registrar en LA PLATAFORMA o LA APLICACION la solicitud de operaci&oacute;n de cambio de moneda<br>(compra o venta), indicando el monto y moneda requerida.<br>4.3.3 EL CLIENTE abonar&aacute; el monto equivalente al tipo de cambio que figure al momento del ingreso de la solicitud, en alguna de<br>las cuentas bancarias de titularidad de KALLPA SAB previamente informadas. El abono deber&aacute; realizarse en un plazo no<br>mayor de los cinco (05) minutos posteriores al registro de la solicitud.<br>4.3.4 EL CLIENTE deber&aacute; remitir la constancia de abono a KALLPA SAB adjuntando la imagen de la misma en LA<br>PLATAFORMA o LA APLICACI&Oacute;N seg&uacute;n corresponda.<br>4.3.5 En cumplimiento de la normativa de prevenci&oacute;n de lavado de activos y financiamiento del terrorismo, KALLPA SAB podr&aacute;<br>solicitar a EL CLIENTE informaci&oacute;n sobre el origen de los fondos depositados. Kallpa SAB se reserva el derecho de<br>rechazar la solicitud de cambio de moneda ante la sospecha de utilizaci&oacute;n de LA PLATAFORMA y/o LA APLICACI&Oacute;N para<br>operaciones delictivas o fraudulentas. Asimismo, KALLPA SAB podr&aacute; limitar el monto de la operaci&oacute;n de cambio de</p>\n<p>Vigente desde el 27 de setiembre de 2021 P&aacute;gina 2 de 5<br>moneda a trav&eacute;s de LA PLATAFORMA o LA APLICACI&Oacute;N. EL CLIENTE se compromete a respetar los par&aacute;metros del<br>servicio evitando utilizar cuentas bancarias diferentes, ingresando informaci&oacute;n falsa o a trav&eacute;s de medios que puedan<br>vulnerar los l&iacute;mites establecidos por KALLPA SAB.<br>4.3.6 KALLPA SAB confirmar&aacute; el abono realizado por EL CLIENTE. Luego de la confirmaci&oacute;n, KALLPA SAB se obliga a depositar<br>los fondos en la cuenta bancaria en Soles o D&oacute;lares de titularidad de EL CLIENTE, en un plazo aproximado de 20 minutos.<br>Este plazo podr&aacute; ampliarse en caso KALLPA SAB haya acordado un plazo diferente con EL CLIENTE para una operaci&oacute;n<br>en particular o cuando considere necesario realizar verificaciones adicionales de seguridad. Asimismo, el plazo podr&aacute; variar<br>de presentarse problemas por lentitud de la banca en l&iacute;nea o se produzca una suspensi&oacute;n en los servicios de pago de la<br>entidad financiera de la cuenta de destino.<br>4.3.7 KALLPA SAB podr&aacute; anular la solicitud de cambio de moneda de no comprobarse el abono de EL CLIENTE dentro del plazo<br>establecido. Asimismo, en caso EL CLIENTE abone un monto inferior al originalmente pactado, KALLPA SAB se reserva el<br>derecho de anular la operaci&oacute;n o comunicarse con EL CLIENTE para actualizar el monto negociado en base a la suma<br>transferida. Ante cancelaci&oacute;n unilateral o cancelaci&oacute;n por pedido del cliente, KALLPA SAB proceder&aacute; a devolver los fondos<br>recibidos, descontando los impuestos y comisiones que la entidad financiera de pago haya aplicado a la operaci&oacute;n.<br>4.3.8 KALLPA SAB solo realizar&aacute; el abono de fondos a cuentas bancarias que se encuentren bajo la titularidad de EL CLIENTE.<br>KALLPA SAB anular&aacute; la solicitud de cambio de moneda si la cuenta bancaria de destino no es de titularidad de EL<br>CLIENTE.<br>4.3.9 Una vez que KALLPA SAB haya realizado la transferencia de los fondos negociados, la operaci&oacute;n de cambio de moneda no<br>podr&aacute; revertirse. KALLPA SAB no se responsabilizar&aacute; en ning&uacute;n caso por cualquier da&ntilde;o o p&eacute;rdida sufrida por EL CLIENTE<br>como consecuencia de la negligencia de este durante el registro de datos en la solicitud de cambio de moneda.<br>Cl&aacute;usula Quinta.- Declaraciones de las Partes<br>5.1 EL CLIENTE declara lo siguiente:<br>5.1.1 Es una persona natural mayor de 18 a&ntilde;os de edad con capacidad legal para celebrar contratos.<br>5.1.2 No est&aacute; actuando a nombre de una tercera persona.<br>5.1.3 Brinda consentimiento para el uso de sus datos personales en los servicios contratados con KALLPA SAB.<br>5.1.4 Bajo car&aacute;cter de declaraci&oacute;n jurada se&ntilde;ala que los fondos que utilizar&aacute; en las operaciones que realice a trav&eacute;s de KALLPA<br>SAB no provienen de actividades il&iacute;citas, ni ser&aacute;n utilizados para el lavado de activos ni del financiamiento del terrorismo.<br>5.1.5 Conoce que las transferencias interbancarias e interplaza podr&aacute;n generarle costos y comisiones cobradas por la entidad<br>financiera que procesa los pagos.<br>5.1.6 Es responsable de verificar que los n&uacute;meros de cuenta bancaria proporcionados a KALLPA SAB para el abono de los<br>fondos son correctos.<br>5.1.7 Conoce y acepta que el tipo de cambio inicialmente pactado podr&aacute; variar en caso exceda el tiempo m&aacute;ximo de abono de<br>fondos para la operaci&oacute;n de cambio de moneda.<br>5.1.8 Acepta que su solicitud de operaci&oacute;n de cambio podr&aacute; ser anulada en caso no realice el abono dentro del plazo establecido.<br>5.1.9 Acepta que KALLPA SAB podr&aacute; suspender, cancelar o anular cualquier solicitud que considere fraudulenta, que presente<br>indicios de informaci&oacute;n no veraz; o, que no cumpla con los T&eacute;rminos y Condiciones del presente documento. Dicha facultad<br>podr&aacute; ser ejecutada en cualquier momento del proceso de cambio de moneda, incluso si la solicitud ya fue confirmada y se<br>encuentra pr&oacute;xima a ser atendida.<br>5.1.10 Conoce y acepta que podr&iacute;a incurrir en gastos y comisiones generados por las entidades bancarias encargadas de los<br>pagos.<br>5.1.11 Acepta que KALLPA SAB no tiene ninguna responsabilidad ni obligaci&oacute;n de informarle y/o asesorarle con respecto al<br>tratamiento tributario de sus operaciones, siendo EL CLIENTE el &uacute;nico responsable de informarse sobre el tratamiento<br>tributario aplicable, as&iacute; como efectuar el pago de los tributos que le correspondan en su debida oportunidad.<br>5.1.12 Reconoce que KALLPA SAB no asumir&aacute; responsabilidad frente al mismo o terceros si por un caso fortuito o de fuerza<br>mayor no pudiera cumplir con cualquiera de sus obligaciones y/o con las instrucciones de EL CLIENTE que tengan relaci&oacute;n<br>con los servicios que brinda. Se consideran como causas de fuerza mayor o caso fortuito, las siguientes: Interrupci&oacute;n del<br>sistema de c&oacute;mputo, red de teleproceso local o de telecomunicaciones, falta de fluido el&eacute;ctrico, terremotos, incendios,<br>inundaciones y otros similares, actos y consecuencias de vandalismo, terrorismo y conmoci&oacute;n civil, huelgas y paros, actos y<br>consecuencias imprevisibles debidamente justificadas por KALLPA SAB.<br>5.1.13 Se compromete a no usar LA PLATAFORMA y LA APLICACI&Oacute;N para fines il&iacute;citos o contrarios al contenido de los<br>presentes T&eacute;rminos y Condiciones, que puedan vulnerar derechos, o que de cualquier forma pueda resultar en un da&ntilde;o a<br>LA PLATAFORMA y LA APLICACI&Oacute;N que impidan su normal funcionamiento.<br>5.1.14 Se compromete a no intentar penetrar o probar la vulnerabilidad de los sistemas y/o red propia vinculada a LA<br>PLATAFORMA y LA APLICACI&Oacute;N. Asimismo, no intentar&aacute; quebrantar las medidas de seguridad o de autenticaci&oacute;n de<br>estas.<br>5.1.15 Se compromete a no utilizar LA PLATAFORMA y LA APLICACI&Oacute;N para enviar correos electr&oacute;nicos masivos (spam) o<br>correos electr&oacute;nicos con contenido amenazante, abusivo, hostil, ultrajante, difamatorio, vulgar, obsceno o injurioso.<br>5.1.16 Se compromete a informar a KALLPA SAB sobre alg&uacute;n error o inexactitud que advierta respecto a alguna comunicaci&oacute;n de<br>KALLPA SAB.<br>5.1.17 Conoce y acepta que la contrase&ntilde;a de acceso a LA PLATAFORMA y LA APLICACI&Oacute;N es personal e intransferible. Es<br>responsable de mantener la contrase&ntilde;a bajo absoluta reserva y confidencialidad, sin revelarla o compartirla, en ning&uacute;n<br>caso, con terceros. Acepta que es responsable de todas las acciones realizadas mediante el uso de su contrase&ntilde;a en LA</p>\n<p>Vigente desde el 27 de setiembre de 2021 P&aacute;gina 3 de 5<br>PLATAFORMA y LA APLICACI&Oacute;N.<br>5.1.18 Se compromete a notificar inmediatamente a KALLPA SAB en caso identificara que un tercero conociera y/o usara su<br>contrase&ntilde;a y por tanto su cuenta personal en LA PLATAFORMA y/o LA APLICACI&Oacute;N. Ante ello, KALLPA SAB proceder&aacute; a<br>bloquear la contrase&ntilde;a de EL CLIENTE.<br>5.1.19 Reconoce y autoriza a KALLPA SAB a interactuar y compartir con terceros los datos proporcionados a fin de brindarle<br>servicios de manera id&oacute;nea.<br>5.2 KALLPA SAB declara lo siguiente:<br>5.2.1 No ser&aacute; responsable por los errores que pudieran originarse por la falta de comunicaci&oacute;n oportuna de EL CLIENTE sobre<br>cualquier cambio en la informaci&oacute;n declarada durante su registro.<br>5.2.2 Se reserva el derecho de efectuar validaciones sobre la informaci&oacute;n declarada por EL CLIENTE en cualquier documento<br>presentado por &eacute;ste.<br>5.2.3 No ser&aacute; responsable por retrasos en el procesamiento de transferencias y abonos causados por las entidades bancarias<br>que ejecutan los pagos.<br>5.2.4 KALLPA SAB podr&aacute; rechazar una solicitud de cambio de moneda si no puede validar que los datos asociados a la cuenta<br>que recibir&aacute; el dep&oacute;sito corresponden a EL CLIENTE. En este caso, EL CLIENTE ser&aacute; responsable de asumir los cargos<br>bancarios y administrativos asociados.<br>5.2.5 No cuenta con la facultad para de adelantar o cancelar una transferencia interbancaria en proceso, as&iacute; como de resolver<br>probables errores en los sistemas de las entidades bancarias que impliquen retrasos en los abonos.<br>5.2.6 No garantiza que LA PLATAFORMA y LA APLICACION sean siempre seguras o est&eacute;n libre de errores, ni que funcione<br>siempre sin interrupciones, retrasos o imperfecciones.<br>5.2.7 No se hace responsable por los posibles da&ntilde;os o perjuicios en LA PLATAFORMA y/o LA APLICACION, que se puedan<br>derivar de interferencias, omisiones, interrupciones, virus inform&aacute;ticos, aver&iacute;as o desconexiones en el funcionamiento<br>operativo de este sistema electr&oacute;nico, motivado por causas ajenas a KALLPA SAB. Tampoco es responsable de retrasos o<br>bloqueos en el uso de LA PLATAFORMA y LA APLICACI&Oacute;N causados por deficiencias o sobrecargas en el sistema de<br>Internet o en otros sistemas electr&oacute;nicos, as&iacute; como tambi&eacute;n que puedan ser causados por terceras personas mediante<br>intromisiones ileg&iacute;timas fuera del control de KALLPA SAB que pudieran afectar el procesamiento del servicio.<br>5.2.8 No ser&aacute; responsable por cualquier da&ntilde;o que sufra EL CLIENTE debido a errores o inexactitudes cometidos por este &uacute;ltimo<br>en la lectura o ingreso de informaci&oacute;n a LA PLATAFORMA y LA APLICACI&Oacute;N. KALLPA SAB se limita a realizar la<br>transacci&oacute;n de acuerdo con las instrucciones y datos brindados por EL CLIENTE.<br>Cl&aacute;usula Sexta.- Comisi&oacute;n por el servicio<br>KALLPA SAB no aplica comisi&oacute;n por uso de LA PLATAFORMA y LA APLICACI&Oacute;N, as&iacute; como cobro alguno por el servicio de cambio<br>de divisas. El servicio es gratuito.<br>Cl&aacute;usula S&eacute;ptima.- Obligaciones de las Partes<br>7.1 KALLPA SAB se encuentra obligada a:<br>7.1.1 Mantener actualizada la publicaci&oacute;n del horario de prestaci&oacute;n del servicio de cambio de moneda.<br>7.1.2 Recibir y dar respuesta a los reclamos presentados por EL CLIENTE a trav&eacute;s del Libro de Reclamaciones.<br>7.1.3 Informar inmediatamente a EL CLIENTE sobre cambios que puedan producirse en los t&eacute;rminos y condiciones del servicio.<br>7.2 EL CLIENTE se encuentra obligado a:<br>7.2.1 Remitir la informaci&oacute;n que solicite KALLPA SAB con el fin de verificar su identidad, procedencia de recursos, entre otros, as&iacute;<br>como permitir que KALLPA SAB remita cualquier informaci&oacute;n que se requiera con fines de supervisi&oacute;n a cualquier otra<br>autoridad nacional con la competencia correspondiente.<br>7.2.2 Operar personalmente su cuenta en LA PLATAFORMA y LA APLICACI&Oacute;N. En caso de efectuar operaciones sobre sus<br>cuentas por intermedio de terceros, estas operaciones se considerar&aacute;n realizadas por EL CLIENTE, pudiendo KALLPA<br>SAB suspender o terminar toda relaci&oacute;n comercial cuando a su solo criterio, la cuenta de EL CLIENTE no est&eacute; siendo<br>utilizada personalmente por &eacute;ste, o cuando sin previo consentimiento de KALLPA SAB se utilice la cuenta para fines<br>diferentes a los pactados en el presente documento, sin asumir por ello ninguna responsabilidad frente al mismo.<br>7.2.3 Abonar a KALLPA SAB el monto &iacute;ntegro por la operaci&oacute;n de cambio pactada. En caso KALLPA SAB no logre detectar<br>inicialmente que EL CLIENTE hab&iacute;a transferido un monto inferior y realice la operaci&oacute;n con el monto inicial acordado, EL<br>CLIENTE se obliga a reintegrar el monto diferencial a las cuentas que mantiene KALLPA SAB en un plazo no mayor a 12<br>horas contadas a partir de la realizaci&oacute;n de la operaci&oacute;n. De incumplir con lo anterior, KALLPA SAB se encontrar&aacute; facultada<br>a tomar las medidas que sean necesarias para recuperar el saldo a favor suyo. Mientras EL CLIENTE no observe esta<br>disposici&oacute;n este saldo ser&aacute; considerado y tratado como una deuda a favor de KALLPA SAB.<br>7.2.4 EL CLIENTE es responsable de asegurarse que los detalles brindados para la realizaci&oacute;n de la transacci&oacute;n sean precisos.<br>Una vez que KALLPA SAB haya realizado la transacci&oacute;n, esta no puede revertirse y KALLPA SAB no ser&aacute; responsable<br>bajo ninguna circunstancia por cualquier p&eacute;rdida sufrida por EL CLIENTE como consecuencia de realizar la transacci&oacute;n de<br>acuerdo con las instrucciones y datos brindados por el mismo.<br>7.2.5 Cumplir las condiciones pactadas para las operaciones de la compra y venta de moneda, caso contrario EL CLIENTE<br>asumir&aacute; los da&ntilde;os y perjuicios econ&oacute;micos ocasionados a KALLPA SAB.</p>\n<p>Vigente desde el 27 de setiembre de 2021 P&aacute;gina 4 de 5<br>Cl&aacute;usula Octava.- Autorizaciones especiales<br>EL CLIENTE autoriza a KALLPA SAB para que pueda informar a las autoridades respectivas, la realizaci&oacute;n de operaciones, cuando<br>habi&eacute;ndose identificado previamente una operaci&oacute;n inusual, luego del an&aacute;lisis y evaluaci&oacute;n realizados por el Oficial de Cumplimiento,<br>&eacute;sta constituya una transacci&oacute;n sospechosa, de acuerdo con las Normas para la Prevenci&oacute;n del Lavado de Activos y Financiamiento<br>del Terrorismo. En tal caso, EL CLIENTE libera a KALLPA SAB, sus directores, funcionarios y personal en general, de toda<br>responsabilidad y/o reclamo de orden penal, civil o administrativo; as&iacute; como de toda reserva que les imponen las normas de reserva<br>burs&aacute;til.<br>Cl&aacute;usula Novena.- Propiedad Intelectual<br>Son de propiedad de KALLPA SAB todos los derechos de propiedad intelectual de LA PLATAFORMA y LA APLICACI&Oacute;N respecto a<br>su contenido y dise&ntilde;o. Quedan expresamente prohibidas la reproducci&oacute;n, distribuci&oacute;n, transformaci&oacute;n, comunicaci&oacute;n p&uacute;blica y<br>puesta a disposici&oacute;n, de la totalidad o parte de los contenidos de LA PLATAFORMA y LA APLICACI&Oacute;N, en cualquier soporte y por<br>cualquier medio t&eacute;cnico, sin la autorizaci&oacute;n expresa de KALLPA SAB. EL CLIENTE se compromete a respetar los derechos de<br>propiedad industrial e intelectual de titularidad de KALLPA SAB.<br>Asimismo, queda expresamente prohibida la utilizaci&oacute;n o reproducci&oacute;n de cualquier marca registrada, nombre o logotipo que figure<br>en LA PLATAFORMA y LA APLICACI&Oacute;N sin la autorizaci&oacute;n de KALLPA SAB as&iacute; como la utilizaci&oacute;n del software bajo el cual operan<br>LA PLATAFORMA y LA APLICACI&Oacute;N<br>Cl&aacute;usula D&eacute;cima.- Resoluci&oacute;n del servicio contratado<br>A efectos que las Partes puedan ejercer su derecho a resolver los servicios contratados se deber&aacute;n considerar las siguientes<br>condiciones:<br>10.1 Ante el incumplimiento de las obligaciones y declaraciones de parte de EL CLIENTE detalladas en el presente documento,<br>KALLPA SAB podr&aacute; notificar por escrito a EL CLIENTE su decisi&oacute;n de no continuar brind&aacute;ndole servicios.<br>10.2 La prestaci&oacute;n de servicios podr&aacute; ser suspendida autom&aacute;ticamente por KALLPA SAB si EL CLIENTE resulta sancionado por<br>la Superintendencia del Mercado de Valores o la Superintendencia de Banca, Seguros y AFP, por una infracci&oacute;n que regula el<br>mercado de valores, y/o los mercados financieros, o se le inicia alg&uacute;n proceso judicial por el delito de lavado de activos,<br>financiamiento del terrorismo y/o tr&aacute;fico il&iacute;cito de drogas.<br>Cl&aacute;usula D&eacute;cimo Primera.- Datos Personales<br>11.1 EL CLIENTE deber&aacute; actualizar la informaci&oacute;n consignada en LA PLATAFORMA ante modificaciones en el contenido<br>originalmente registrado. Asimismo, KALLPA SAB podr&aacute; solicitar la actualizaci&oacute;n por lo menos una vez al a&ntilde;o de la informaci&oacute;n<br>consignada.<br>11.2 La informaci&oacute;n que EL CLIENTE ha proporcionado conforme con la Ley de Protecci&oacute;n de Datos Personales y su respectivo<br>Reglamento, es considerada como Datos Personales, en ese sentido, EL CLIENTE otorga su consentimiento libre, previo, expreso e<br>informado para que sus Datos Personales sean tratados por KALLPA SAB, es decir, que puedan ser: recopilados, registrados,<br>organizados, almacenados, conservados, elaborados modificados, bloqueados, suprimidos, extra&iacute;dos, consultados, utilizados,<br>transferidos o procesados de cualquier otra forma prevista por la Ley o su Reglamento, as&iacute; como por lo establecido en la Resoluci&oacute;n<br>SMV N&deg;33-2011 y sus modificatorias y dem&aacute;s Normas para la Prevenci&oacute;n del Lavado de Activos y Financiamiento del Terrorismo.<br>Asimismo, para ejercer cualquier otro derecho en virtud a Ley de Protecci&oacute;n de Datos Personales, EL CLIENTE reconoce que deber&aacute;<br>presentar una solicitud escrita en las oficinas de KALLPA SAB.<br>11.3 Esta autorizaci&oacute;n es indefinida y se mantendr&aacute; inclusive despu&eacute;s de terminada las actividades de cambio de moneda. En<br>ese sentido, sus Datos Personales ser&aacute;n almacenados (guardados) en el Banco de Datos de Clientes del cual KALLPA SAB es<br>titular o en cualquier otro que en el futuro pueda establecer.<br>11.4 KALLPA SAB ha adoptado las medidas necesarias para mantener segura la informaci&oacute;n. Al dar esta autorizaci&oacute;n EL<br>CLIENTE permite que KALLPA SAB: (i) pueda decidir si otorga el(los) producto(s) y/o servicio(s) que EL CLIENTE solicite, (ii) le<br>ofrezca otros productos y/o servicios ofrecidos por KALLPA SAB y/o de terceros vinculados, incluso a trav&eacute;s de terceras personas<br>(iii) le env&iacute;e ofertas comerciales, publicidad e informaci&oacute;n en general de los productos y/o servicios de KALLPA SAB y, (iv) use y/o<br>transfiera esta informaci&oacute;n a terceras personas (dentro o fuera del pa&iacute;s), vinculadas o no a KALLPA SAB, nacionales o extranjeros,<br>p&uacute;blicos o privados. Se entiende por terceros a bancos, nacionales y extranjeros, imprentas, empresas de mensajer&iacute;a, reguladores,<br>empresas consultoras, de auditor&iacute;a y empresas del grupo econ&oacute;mico de KALLPA SAB.<br>11.5 Adicionalmente a la tipolog&iacute;a de entidades descritas en el numeral anterior, se podr&aacute; usar y/o transferir informaci&oacute;n de<br>KALLPA SAB a cualquier contratista y/o tercera persona con las cuales se establezcan relaciones comerciales, legales,<br>contractuales, de prestaci&oacute;n de servicio o de otro tipo que permitan el desarrollo de su objeto social.<br>Cl&aacute;usula D&eacute;cimo Segunda.- Procedimientos de reclamos y/o soluci&oacute;n de conflictos.<br>El plazo m&aacute;ximo para la atenci&oacute;n de consultas y/o reclamos ser&aacute; de 30 d&iacute;as calendario desde la fecha de presentaci&oacute;n del reclamo,<br>prorrogable hasta por 30 d&iacute;as calendario adicionales, cuando la naturaleza del reclamo lo amerite, seg&uacute;n lo dispuesto por la<br>Resoluci&oacute;n SMV N&deg; 006-2012-SMV/01. En caso EL CLIENTE no estuviera conforme con la respuesta obtenida de KALLPA SAB,<br>tiene el derecho a presentar su reclamo a las autoridades administrativas pertinentes.<br>Cl&aacute;usula D&eacute;cimo Tercera.- Jurisdicci&oacute;n Arbitral<br>En el supuesto que se generase alguna controversia, discrepancia, reclamaci&oacute;n o conflicto de intereses como consecuencia de la<br>celebraci&oacute;n y/o interpretaci&oacute;n de los presentes t&eacute;rminos y condiciones o con relaci&oacute;n al mismo, incluyendo aquellas que se refieran a<br>su posible nulidad, tanto KALLPA SAB como EL CLIENTE dejan establecido que los mismos ser&aacute;n solucionados de buena fe</p>\n<p>Vigente desde el 27 de setiembre de 2021 P&aacute;gina 5 de 5<br>mediante trato directo, aplicando los procedimientos establecidos para la atenci&oacute;n de reclamos. Sin embargo, si la controversia,<br>discrepancia, reclamaci&oacute;n o conflicto de intereses suscitada entre las Partes, no pudiera ser resuelta por las mismas, podr&aacute; ser<br>sometida al conocimiento y decisi&oacute;n de tres (3) &aacute;rbitros, ante el Centro de Arbitraje Internacional de la C&aacute;mara de Comercio<br>Americana en el Per&uacute; (AmCham Peru), siendo uno de ellos designado por cada Parte y el tercero por los &aacute;rbitros designados por las<br>Partes, quien presidir&aacute; el tribunal arbitral respectivo (el &ldquo;Tribunal Arbitral&rdquo;).<br>Cl&aacute;usula D&eacute;cimo Cuarta.- Marco Normativo<br>En todo lo no previsto en estos t&eacute;rminos y condiciones, ser&aacute;n de aplicaci&oacute;n las disposiciones establecidas en la Ley del Mercado de<br>Valores, el Reglamento de Agentes de Intermediaci&oacute;n y las dem&aacute;s normas peruanas que regulen o complementen estas<br>disposiciones. En caso de discrepancia entre lo estipulado en el presente documento y las normas legales que lo rigen, primar&aacute;n&nbsp;</p>','2025-09-19 08:08:59','2025-10-03 06:20:03');
INSERT INTO `bidexv` VALUES (2,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\":\"Business Divisas VIRTUAL\",\"enero\":\"PLAZO\",\"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:09:13','2025-10-01 05:31:57'),(3,9,2025,'UTILIDAD',3.00,4114.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,4117.00,NULL,'2025-09-19 08:09:23','2025-10-01 05:26:14'),(5,1,2025,'__SHEET__',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'{\"cols\":[{\"name\":\"NORMAS\",\"w\":232},{\"name\":\"TIEMPO\",\"w\":160},{\"name\":\"COSTO\",\"w\":160},{\"name\":\"REQUISITOS\",\"w\":160}],\"rows\":[[\"LIBRO DE RECLAMACIONES - VIRTUAL\",\"COMPLETADO\",\"\",\"Copia literal de la empresa \\/ Copia de DNI de gerente \\/ Copia de administrador\"],[\"TERMINOS Y CONDICIONES ADAPTADOS AL CODIGO DE PROTECCION AL CONSUMIDOR\",\"\",\"\",\"Información sobre todo el servicio\"],[\"REGISTRO EN EL SISTEMA DE ARBITRAJE DE CONSUMO\",\"\",\"\",\"Copia literal de la empresa \\/ Copia de DNI de gerente \\/ Copia de administrador\"],[\"PROTECCION DE SECRETOS EMPRESARIALES\",\"\",\"\",\"Lista de colaboradores \\/ Conocimientos del giro denegocio\"],[\"REVISION DE PUBLICIDAD EN PAGINA WEB Y REDES SOCIALES\",\"\",\"\",\"Links de página web \\/ Links de redes sociales\"],[\"REGISTRO DE BANC DE DATOS Y CODIGO DE CONDUCTA\",\"\",\"\",\"Lista de datos en formato Excel\"],[\"POLITICAS DE PROTECCION DE DATOS\",\"\",\"\",\"Copia literal de la empresa \\/ Copia de DNI de gerente \\/ Copia de administrador\"]]}','2025-09-24 12:09:23','2025-10-01 06:42:40');

--
-- Table structure for table `bolsa`
--

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

--
-- Dumping data for table `bolsa`
--

INSERT INTO `bolsa` 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\":\"BOLSA DE DIVISAS\",\"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-09-19 08:36:01','2025-09-19 08:36:01'),(2,9,2025,'Empresa 1',452.00,1552.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,2004.00,NULL,'2025-09-19 08:36:05','2025-09-19 08:36:05'),(3,9,2025,'Empresa 2',63.00,8555.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,8618.00,NULL,'2025-09-19 08:36:10','2025-09-19 08:36:30'),(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,'<table style=\"border-collapse: collapse; width: 49.2317%; height: 89.5624px;\" border=\"1\"><colgroup><col style=\"width: 29.7506%;\"><col style=\"width: 34.1257%;\"><col style=\"width: 36.1257%;\"></colgroup>\n<tbody>\n<tr style=\"height: 22.3906px;\">\n<td style=\"height: 22.3906px;\"><strong>REDES SOCIALES</strong></td>\n<td style=\"height: 22.3906px;\"><strong>CORREO / USUARIO</strong></td>\n<td style=\"height: 22.3906px;\"><strong>CONTRASE&Ntilde;A</strong></td>\n</tr>\n<tr style=\"height: 22.3906px;\">\n<td style=\"height: 22.3906px;\"><strong>FACEBOOK</strong></td>\n<td style=\"height: 22.3906px;\">bolsasded@gmail.com</td>\n<td style=\"height: 22.3906px;\">Bolsa#Divisas#2024@</td>\n</tr>\n<tr style=\"height: 22.3906px;\">\n<td style=\"height: 22.3906px;\"><strong>INSTAGRAM</strong></td>\n<td style=\"height: 22.3906px;\">bolsasded@gmail.com</td>\n<td style=\"height: 22.3906px;\">Bolsa#Divisas#2024@</td>\n</tr>\n<tr style=\"height: 22.3906px;\">\n<td style=\"height: 22.3906px;\"><strong>TIKTOK</strong></td>\n<td style=\"height: 22.3906px;\">bolsasded@gmail.com</td>\n<td style=\"height: 22.3906px;\">Bolsa#Divisas#2024@</td>\n</tr>\n</tbody>\n</table>','2025-09-19 08:36:19','2025-09-29 06:11:54'),(5,1,2025,'__SHEET__',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'{\"cols\":[{\"name\":\"NORMA\",\"w\":252},{\"name\":\"TIEMPO\",\"w\":160},{\"name\":\"COSTO\",\"w\":160},{\"name\":\"REQUISITOS\",\"w\":160}],\"rows\":[[\"LIBRO DE RECLAMACIONES - VIRTUAL\",\"\",\"\",\"Copia literal de la empresa \\/ Copia de DNI de gerente \\/ Copia de administrador\"],[\"TERMINOS Y CONDICIONES ADAPTADOS AL CODIGO DE PROTECCION AL CONSUMIDOR\",\"\",\"\",\"Información sobre todo el servicio\"],[\"REGISTRO EN EL SISTEMA DE ARBITRAJE DE CONSUMO\",\"\",\"\",\"Copia literal de la empresa \\/ Copia de DNI de gerente \\/ Copia de administrador\"],[\"PROTECCION DE SECRETOS EMPRESARIALES\",\"\",\"\",\"Lista de colaboradores \\/ Conocimientos del giro denegocio\"],[\"REVISION DE PUBLICIDAD EN PAGINA WEB Y REDES SOCIALES\",\"\",\"\",\"Links de página web \\/ Links de redes sociales\"],[\"REGISTRO DE BANC DE DATOS Y CODIGO DE CONDUCTA\",\"\",\"\",\"Lista de datos en formato Excel\"],[\"POLITICAS DE PROTECCION DE DATOS\",\"\",\"\",\"Copia literal de la empresa \\/ Copia de DNI de gerente \\/ Copia de administrador\"]]}','2025-09-24 12:29:13','2025-10-18 12:50:30');

--
-- Table structure for table `canasta`
--

CREATE TABLE `canasta` (
  `canasta_id` int NOT NULL AUTO_INCREMENT,
  `usuario_id` int NOT NULL,
  `anio` int NOT NULL,
  `mes` tinyint NOT NULL,
  `nombre` varchar(200) NOT NULL,
  `activo` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`canasta_id`),
  KEY `idx_canasta_usuario_periodo` (`usuario_id`,`anio`,`mes`),
  KEY `idx_canasta_activo` (`activo`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `canasta`
--

INSERT INTO `canasta` VALUES (1,1,2025,11,'Canasta usuario 1 2025/11',1,'2025-11-08 13:21:25',NULL);

--
-- Table structure for table `canasta_categoria`
--

CREATE TABLE `canasta_categoria` (
  `categoria_id` int NOT NULL AUTO_INCREMENT,
  `canasta_id` int NOT NULL,
  `nombre` varchar(200) NOT NULL,
  `orden` int NOT NULL DEFAULT '1',
  `activo` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`categoria_id`),
  KEY `idx_cat_canasta_orden` (`canasta_id`,`orden`),
  KEY `idx_cat_activo` (`activo`),
  CONSTRAINT `fk_cat_canasta` FOREIGN KEY (`canasta_id`) REFERENCES `canasta` (`canasta_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `canasta_categoria`
--

INSERT INTO `canasta_categoria` VALUES (1,1,'CANASTA GRANDE REY',1,1),(2,1,'VINO SQ',2,1),(3,1,'TAMPICO X 3 LITROS',3,1),(4,1,'VINO VIÑA',4,1),(5,1,'GASEOSA KR X 3 LITROS',5,1),(6,1,'ARROZ ARO X  750 GR',6,1),(8,1,'AZUCAR MK X 1 KG',8,1),(9,1,'ARO DURAZNO 1 KG',9,1),(10,1,'JABOL LIQUIDO X 1 LITRO',10,1),(11,1,'JABON LIQUIDO GALON X 4 LITROS',11,1),(12,1,'CRACKNEL',12,1),(13,1,'LECHE BONLE',13,1),(14,1,'AVENA SCAT',14,1),(15,1,'TE FRUTOS ROJOS X 50 UNI',15,1),(16,1,'ACEITE 900 ML',16,1),(17,1,'MERMELADA 300 GR',17,1),(18,1,'ATUN FILETE FLORIDA',18,1),(19,1,'SAL 1 KG',19,1),(20,1,'POP CORN COSTEÑO X 500 GR',20,1),(21,1,'FIDEOS CIELO X 250 GR',21,1),(22,1,'TALLARINES',22,1);

--
-- Table structure for table `canasta_columna`
--

CREATE TABLE `canasta_columna` (
  `col_id` int NOT NULL AUTO_INCREMENT,
  `canasta_id` int NOT NULL,
  `nombre` varchar(120) NOT NULL,
  `tipo` varchar(20) NOT NULL DEFAULT 'TEXTO',
  `orden` int NOT NULL DEFAULT '999',
  `activo` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`col_id`),
  KEY `idx_cc_canasta_orden` (`canasta_id`,`orden`),
  KEY `idx_cc_activo` (`activo`),
  CONSTRAINT `fk_cc_canasta` FOREIGN KEY (`canasta_id`) REFERENCES `canasta` (`canasta_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `canasta_columna`
--

INSERT INTO `canasta_columna` VALUES (11,1,'CANTIDAD','NUMERO',3,1),(12,1,'PRECIO','NUMERO',4,1),(15,1,'PROVEEDOR','INPUT',5,1);

--
-- Table structure for table `canasta_item`
--

CREATE TABLE `canasta_item` (
  `item_id` int NOT NULL AUTO_INCREMENT,
  `categoria_id` int NOT NULL,
  `parent_item_id` int DEFAULT NULL,
  `nombre` varchar(250) NOT NULL,
  `tipo` varchar(20) NOT NULL DEFAULT 'CHECKLIST',
  `orden` int NOT NULL DEFAULT '1',
  `activo` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`item_id`),
  KEY `idx_item_cat_orden` (`categoria_id`,`orden`),
  KEY `idx_item_parent` (`parent_item_id`),
  KEY `idx_item_activo` (`activo`),
  CONSTRAINT `fk_item_cat` FOREIGN KEY (`categoria_id`) REFERENCES `canasta_categoria` (`categoria_id`) ON DELETE CASCADE,
  CONSTRAINT `fk_item_parent` FOREIGN KEY (`parent_item_id`) REFERENCES `canasta_item` (`item_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=152 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `canasta_item`
--

INSERT INTO `canasta_item` VALUES (44,2,NULL,'DLA Cruz','CHECKLIST',1,1),(53,22,NULL,'Spaghetti Anita Amarillo','CHECKLIST',3,1),(54,22,NULL,'Spaghetti Grano de Oro','CHECKLIST',4,1),(55,22,NULL,'Spaghetti Nicolini','CHECKLIST',5,1),(56,22,NULL,'Spaghetti Anita Rojo','CHECKLIST',6,1),(57,22,NULL,'Spaghetti Don  Victorio','CHECKLIST',7,1),(58,22,NULL,'Spaghetti Molitalia','CHECKLIST',8,1),(59,22,NULL,'Spaghetti Lavaggi','CHECKLIST',9,1),(60,22,NULL,'Spaghetti Anita Amarillo','CHECKLIST',10,1),(61,22,NULL,'Spaghetti Anita Rojo','CHECKLIST',11,1),(62,22,NULL,'Spaghetti San Jorge','CHECKLIST',12,1),(63,22,NULL,'Spaghetti Lavaggi','CHECKLIST',13,1),(64,22,NULL,'Spaghetti Don Victorio','CHECKLIST',14,1),(65,22,NULL,'Spaghetti Molitalia','CHECKLIST',15,1),(66,22,NULL,'Spaghetti Grano de Oro','CHECKLIST',16,1),(67,22,NULL,'Spaghetti Cielo','CHECKLIST',17,1),(68,18,NULL,'Campomar Trozos','CHECKLIST',1,1),(69,18,NULL,'Campomar Filete','CHECKLIST',2,1),(71,18,NULL,'Primor Trozos','CHECKLIST',3,1),(72,18,NULL,'Primor Filete','CHECKLIST',4,1),(73,18,NULL,'Fanny Trozos','CHECKLIST',5,1),(74,18,NULL,'Fanny Filete','CHECKLIST',6,1),(75,18,NULL,'Florida Trozos','CHECKLIST',7,1),(76,18,NULL,'Florida Filete','CHECKLIST',8,1),(77,14,NULL,'Ositos 135 GR','CHECKLIST',1,1),(78,14,NULL,'Santa Catalina 150 GR','CHECKLIST',2,1),(79,14,NULL,'El Abuelo 150 GR','CHECKLIST',3,1),(80,16,NULL,'Tondero 1LT','CHECKLIST',1,1),(81,16,NULL,'Sao 900 ML','CHECKLIST',2,1),(82,16,NULL,'A Tria 900 ML','CHECKLIST',3,1),(83,16,NULL,'Valle del Sol 900 ML','CHECKLIST',4,1),(84,16,NULL,'Cielo 900 ML','CHECKLIST',5,1),(85,16,NULL,'Mirasol 900 ML','CHECKLIST',6,1),(86,16,NULL,'Cocinero  1 LT','CHECKLIST',7,1),(87,16,NULL,'Beltran 1 LT','CHECKLIST',8,1),(88,16,NULL,'Deleite 1 LT','CHECKLIST',9,1),(89,16,NULL,'Primor Clasico 1 LT','CHECKLIST',10,1),(90,16,NULL,'Primor Premium 1 LT','CHECKLIST',11,1),(91,21,NULL,'Fideos Sopa Anita Amarillo','CHECKLIST',1,1),(92,21,NULL,'Fideos Sopa Anita Rojo','CHECKLIST',2,1),(93,21,NULL,'Fideos Sopa San Jorge','CHECKLIST',3,1),(94,21,NULL,'Fideos Sopa Grano de Oro','CHECKLIST',4,1),(95,21,NULL,'Fideos Sopa Cielo','CHECKLIST',5,1),(96,19,NULL,'Sal Marina','CHECKLIST',1,1),(97,19,NULL,'Nor Sal','CHECKLIST',2,1),(98,19,NULL,'Sal de Mar','CHECKLIST',3,1),(99,19,NULL,'Yamisal','CHECKLIST',4,1),(100,19,NULL,'Norteña','CHECKLIST',5,1),(101,19,NULL,'Sal Marimar','CHECKLIST',6,1),(102,13,NULL,'Leche Gloria Azul Caja','CHECKLIST',1,1),(103,13,NULL,'Leche Gloria Roja Caja','CHECKLIST',2,1),(104,15,NULL,'Infusiòn Herbi','CHECKLIST',1,1),(105,17,NULL,'Mermelada Dely Fanny 950 GR','CHECKLIST',1,1),(106,9,NULL,'Durazno Arica','CHECKLIST',1,1),(107,9,NULL,'Durazno Cielo','CHECKLIST',2,1),(108,9,NULL,'Durazno Valle Norte','CHECKLIST',3,1),(109,9,NULL,'Durazno Rio','CHECKLIST',4,1),(110,9,NULL,'Durazno dos Caballos','CHECKLIST',5,1),(112,6,NULL,'Arroz Costeño 20 bolsas de 750 gramos','CHECKLIST',2,1),(113,16,NULL,'Aceite Beltrán Premium 1 LT','CHECKLIST',12,1),(114,16,NULL,'Aceite Cil Caja 900 ML','CHECKLIST',13,1),(115,16,NULL,'Aceite L a Patrona','CHECKLIST',14,1),(116,16,NULL,'Aceite Deleite Premium 1 LT','CHECKLIST',15,1),(117,16,NULL,'Aceite Primor Clásico 900 ML','CHECKLIST',16,1),(118,14,NULL,'Avena 3 Ositos 135 GR','CHECKLIST',4,1),(119,14,NULL,'Avena Quaker 200 GR','CHECKLIST',5,1),(120,5,NULL,'Big Cola 3.3 litros','CHECKLIST',1,1),(121,21,NULL,'Fideo Anita Rojo 250g','CHECKLIST',6,1),(123,13,NULL,'Leche Gloria Entera Azul UHT Caja 1LT','CHECKLIST',3,1),(124,13,NULL,'Leche Gloria Descremada UHT Light Caja 1 LT','CHECKLIST',4,1),(125,13,NULL,'Bonle Familiar Caja  500 ML','CHECKLIST',5,1),(126,15,NULL,'Manzanilla Herbi','CHECKLIST',2,1),(127,18,NULL,'Filete de Atún Campomar','CHECKLIST',9,1),(128,18,NULL,'Filete de Bonito Beltrán','CHECKLIST',10,1),(129,18,NULL,'Filete de Caballa El Capo del Mar','CHECKLIST',11,1),(130,18,NULL,'Trozos Atún Florida','CHECKLIST',12,1),(131,18,NULL,'Trozos de Atún Primor','CHECKLIST',13,1),(132,18,NULL,'Filete de Atún Beltrán','CHECKLIST',14,1),(133,18,NULL,'Filete de Atún Florida','CHECKLIST',15,1),(134,18,NULL,'Filete de Atún Primor','CHECKLIST',16,1),(135,19,NULL,'Sal de Cocina Emsal','CHECKLIST',7,1),(136,19,NULL,'Sal de Cocina Marimar','CHECKLIST',8,1),(137,19,NULL,'Sal de Mesa Emsal','CHECKLIST',9,1),(138,19,NULL,'Sal de Mesa JJD’Mar','CHECKLIST',10,1),(139,1,NULL,'CANASTA REY GRANDE','CHECKLIST',1,1),(140,2,NULL,'VINO SQ','CHECKLIST',2,1),(141,3,NULL,'TAMPICO 3 LT','CHECKLIST',1,1),(142,4,NULL,'VINO VIÑA PACK 2','CHECKLIST',1,1),(143,5,NULL,'GASEOSA KR 3 LT','CHECKLIST',2,1),(144,6,NULL,'Arroz Aro x 750 GR','CHECKLIST',3,1),(145,6,NULL,'Arroz Faraon 1KG','CHECKLIST',4,1),(146,8,NULL,'Azucar MK  1 KG','CHECKLIST',1,1),(147,9,NULL,'Aro Durazno 1 KG','CHECKLIST',6,1),(148,12,NULL,'Craknel UNI','CHECKLIST',1,1),(149,17,NULL,'Mermelada Compas 300 GR','CHECKLIST',2,1),(150,20,NULL,'Pop Corn Costeño 250 GR','CHECKLIST',1,1),(151,1,NULL,'Cesto Margarito Q PLAST 60 cm Altura','CHECKLIST',2,1);

--
-- Table structure for table `canasta_valor`
--

CREATE TABLE `canasta_valor` (
  `item_id` int NOT NULL,
  `col_id` int NOT NULL,
  `val_check` tinyint(1) DEFAULT NULL,
  `val_num` decimal(18,6) DEFAULT NULL,
  `val_txt` text,
  `val_fecha` date DEFAULT NULL,
  `val_usuario_id` int DEFAULT NULL,
  PRIMARY KEY (`item_id`,`col_id`),
  KEY `fk_val_col` (`col_id`),
  KEY `idx_val_usuario` (`val_usuario_id`),
  CONSTRAINT `fk_val_col` FOREIGN KEY (`col_id`) REFERENCES `canasta_columna` (`col_id`) ON DELETE CASCADE,
  CONSTRAINT `fk_val_item` FOREIGN KEY (`item_id`) REFERENCES `canasta_item` (`item_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `canasta_valor`
--

INSERT INTO `canasta_valor` VALUES (53,11,NULL,20.000000,NULL,NULL,NULL),(53,12,NULL,47.000000,NULL,NULL,NULL),(53,15,NULL,NULL,'MUNDO ABARROTES',NULL,NULL),(54,11,NULL,20.000000,NULL,NULL,NULL),(54,12,NULL,46.000000,NULL,NULL,NULL),(54,15,NULL,NULL,'MUNDO ABARROTES',NULL,NULL),(55,11,NULL,20.000000,NULL,NULL,NULL),(55,12,NULL,51.000000,NULL,NULL,NULL),(55,15,NULL,NULL,'MUNDO ABARROTES',NULL,NULL),(56,11,NULL,20.000000,NULL,NULL,NULL),(56,12,NULL,55.000000,NULL,NULL,NULL),(56,15,NULL,NULL,'MUNDO ABARROTES',NULL,NULL),(57,11,NULL,20.000000,NULL,NULL,NULL),(57,12,NULL,70.000000,NULL,NULL,NULL),(57,15,NULL,NULL,'MUNDO ABARROTES',NULL,NULL),(58,11,NULL,20.000000,NULL,NULL,NULL),(58,12,NULL,58.500000,NULL,NULL,NULL),(58,15,NULL,NULL,'MUNDO ABARROTES',NULL,NULL),(59,11,NULL,20.000000,NULL,NULL,NULL),(59,12,NULL,61.000000,NULL,NULL,NULL),(59,15,NULL,NULL,'MUNDO ABARROTES',NULL,NULL),(60,11,NULL,20.000000,NULL,NULL,NULL),(60,12,NULL,45.000000,NULL,NULL,NULL),(60,15,NULL,NULL,'ANADIS',NULL,NULL),(61,11,NULL,20.000000,NULL,NULL,NULL),(61,12,NULL,58.000000,NULL,NULL,NULL),(61,15,NULL,NULL,'ANADIS',NULL,NULL),(62,11,NULL,20.000000,NULL,NULL,NULL),(62,12,NULL,47.000000,NULL,NULL,NULL),(62,15,NULL,NULL,'ANADIS',NULL,NULL),(63,11,NULL,20.000000,NULL,NULL,NULL),(63,12,NULL,67.000000,NULL,NULL,NULL),(63,15,NULL,NULL,'ANADIS',NULL,NULL),(64,11,NULL,20.000000,NULL,NULL,NULL),(64,12,NULL,74.000000,NULL,NULL,NULL),(64,15,NULL,NULL,'ANADIS',NULL,NULL),(65,11,NULL,20.000000,NULL,NULL,NULL),(65,12,NULL,67.000000,NULL,NULL,NULL),(65,15,NULL,NULL,'ANADIS',NULL,NULL),(66,11,NULL,20.000000,NULL,NULL,NULL),(66,12,NULL,44.000000,NULL,NULL,NULL),(66,15,NULL,NULL,'ANADIS',NULL,NULL),(67,11,NULL,20.000000,NULL,NULL,NULL),(67,12,NULL,46.000000,NULL,NULL,NULL),(67,15,NULL,NULL,'ANADIS',NULL,NULL),(68,11,NULL,24.000000,NULL,NULL,NULL),(68,12,NULL,125.000000,NULL,NULL,NULL),(68,15,NULL,NULL,'ANADIS',NULL,NULL),(69,11,NULL,24.000000,NULL,NULL,NULL),(69,12,NULL,132.000000,NULL,NULL,NULL),(69,15,NULL,NULL,'ANADIS',NULL,NULL),(71,11,NULL,24.000000,NULL,NULL,NULL),(71,12,NULL,126.000000,NULL,NULL,NULL),(71,15,NULL,NULL,'ANADIS',NULL,NULL),(72,11,NULL,24.000000,NULL,NULL,NULL),(72,12,NULL,135.000000,NULL,NULL,NULL),(72,15,NULL,NULL,'ANADIS',NULL,NULL),(73,11,NULL,24.000000,NULL,NULL,NULL),(73,12,NULL,126.000000,NULL,NULL,NULL),(73,15,NULL,NULL,'ANADIS',NULL,NULL),(74,11,NULL,24.000000,NULL,NULL,NULL),(74,12,NULL,136.000000,NULL,NULL,NULL),(74,15,NULL,NULL,'ANADIS',NULL,NULL),(75,11,NULL,24.000000,NULL,NULL,NULL),(75,12,NULL,126.000000,NULL,NULL,NULL),(75,15,NULL,NULL,'ANADIS',NULL,NULL),(76,11,NULL,24.000000,NULL,NULL,NULL),(76,12,NULL,136.000000,NULL,NULL,NULL),(76,15,NULL,NULL,'ANADIS',NULL,NULL),(77,11,NULL,24.000000,NULL,NULL,NULL),(77,12,NULL,29.000000,NULL,NULL,NULL),(77,15,NULL,NULL,'ANADIS',NULL,NULL),(78,11,NULL,24.000000,NULL,NULL,NULL),(78,12,NULL,36.000000,NULL,NULL,NULL),(78,15,NULL,NULL,'ANADIS',NULL,NULL),(79,11,NULL,24.000000,NULL,NULL,NULL),(79,12,NULL,27.000000,NULL,NULL,NULL),(79,15,NULL,NULL,'ANADIS',NULL,NULL),(80,11,NULL,12.000000,NULL,NULL,NULL),(80,12,NULL,86.000000,NULL,NULL,NULL),(80,15,NULL,NULL,'ANADIS',NULL,NULL),(81,11,NULL,12.000000,NULL,NULL,NULL),(81,12,NULL,89.000000,NULL,NULL,NULL),(81,15,NULL,NULL,'ANADIS',NULL,NULL),(82,11,NULL,12.000000,NULL,NULL,NULL),(82,12,NULL,86.000000,NULL,NULL,NULL),(82,15,NULL,NULL,'ANADIS',NULL,NULL),(83,11,NULL,12.000000,NULL,NULL,NULL),(83,12,NULL,92.000000,NULL,NULL,NULL),(83,15,NULL,NULL,'ANADIS',NULL,NULL),(84,11,NULL,12.000000,NULL,NULL,NULL),(84,12,NULL,82.000000,NULL,NULL,NULL),(84,15,NULL,NULL,'ANADIS',NULL,NULL),(85,11,NULL,12.000000,NULL,NULL,NULL),(85,12,NULL,82.000000,NULL,NULL,NULL),(85,15,NULL,NULL,'ANADIS',NULL,NULL),(86,11,NULL,12.000000,NULL,NULL,NULL),(86,12,NULL,108.000000,NULL,NULL,NULL),(86,15,NULL,NULL,'ANADIS',NULL,NULL),(87,11,NULL,12.000000,NULL,NULL,NULL),(87,12,NULL,92.000000,NULL,NULL,NULL),(87,15,NULL,NULL,'ANADIS',NULL,NULL),(88,11,NULL,12.000000,NULL,NULL,NULL),(88,12,NULL,96.000000,NULL,NULL,NULL),(88,15,NULL,NULL,'ANADIS',NULL,NULL),(89,11,NULL,12.000000,NULL,NULL,NULL),(89,12,NULL,115.000000,NULL,NULL,NULL),(89,15,NULL,NULL,'ANADIS',NULL,NULL),(90,11,NULL,12.000000,NULL,NULL,NULL),(90,12,NULL,130.000000,NULL,NULL,NULL),(90,15,NULL,NULL,'ANADIS',NULL,NULL),(91,11,NULL,20.000000,NULL,NULL,NULL),(91,12,NULL,26.000000,NULL,NULL,NULL),(91,15,NULL,NULL,'ANADIS',NULL,NULL),(92,11,NULL,20.000000,NULL,NULL,NULL),(92,12,NULL,35.000000,NULL,NULL,NULL),(92,15,NULL,NULL,'ANADIS',NULL,NULL),(93,11,NULL,20.000000,NULL,NULL,NULL),(93,12,NULL,24.000000,NULL,NULL,NULL),(93,15,NULL,NULL,'ANADIS',NULL,NULL),(94,11,NULL,20.000000,NULL,NULL,NULL),(94,12,NULL,23.000000,NULL,NULL,NULL),(94,15,NULL,NULL,'ANADIS',NULL,NULL),(95,11,NULL,20.000000,NULL,NULL,NULL),(95,12,NULL,23.000000,NULL,NULL,NULL),(95,15,NULL,NULL,'ANADIS',NULL,NULL),(96,11,NULL,25.000000,NULL,NULL,NULL),(96,12,NULL,38.000000,NULL,NULL,NULL),(96,15,NULL,NULL,'ANADIS',NULL,NULL),(97,11,NULL,25.000000,NULL,NULL,NULL),(97,12,NULL,29.000000,NULL,NULL,NULL),(97,15,NULL,NULL,'ANADIS',NULL,NULL),(98,11,NULL,25.000000,NULL,NULL,NULL),(98,12,NULL,28.000000,NULL,NULL,NULL),(98,15,NULL,NULL,'ANADIS',NULL,NULL),(99,11,NULL,25.000000,NULL,NULL,NULL),(99,12,NULL,26.000000,NULL,NULL,NULL),(99,15,NULL,NULL,'ANADIS',NULL,NULL),(100,11,NULL,25.000000,NULL,NULL,NULL),(100,12,NULL,25.000000,NULL,NULL,NULL),(100,15,NULL,NULL,'ANADIS',NULL,NULL),(101,11,NULL,25.000000,NULL,NULL,NULL),(101,12,NULL,24.000000,NULL,NULL,NULL),(101,15,NULL,NULL,'ANADIS',NULL,NULL),(102,11,NULL,12.000000,NULL,NULL,NULL),(102,12,NULL,67.000000,NULL,NULL,NULL),(102,15,NULL,NULL,'ANADIS',NULL,NULL),(103,11,NULL,12.000000,NULL,NULL,NULL),(103,12,NULL,68.000000,NULL,NULL,NULL),(103,15,NULL,NULL,'ANADIS',NULL,NULL),(104,11,NULL,32.000000,NULL,NULL,NULL),(104,12,NULL,33.000000,NULL,NULL,NULL),(104,15,NULL,NULL,'ANADIS',NULL,NULL),(105,11,NULL,6.000000,NULL,NULL,NULL),(105,12,NULL,89.000000,NULL,NULL,NULL),(105,15,NULL,NULL,'ANADIS',NULL,NULL),(106,11,NULL,12.000000,NULL,NULL,NULL),(106,12,NULL,96.000000,NULL,NULL,NULL),(106,15,NULL,NULL,'ANADIS',NULL,NULL),(107,11,NULL,12.000000,NULL,NULL,NULL),(107,12,NULL,94.000000,NULL,NULL,NULL),(107,15,NULL,NULL,'ANADIS',NULL,NULL),(108,11,NULL,12.000000,NULL,NULL,NULL),(108,12,NULL,92.000000,NULL,NULL,NULL),(108,15,NULL,NULL,'ANADIS',NULL,NULL),(109,11,NULL,12.000000,NULL,NULL,NULL),(109,12,NULL,105.000000,NULL,NULL,NULL),(109,15,NULL,NULL,'ANADIS',NULL,NULL),(110,11,NULL,12.000000,NULL,NULL,NULL),(110,12,NULL,115.000000,NULL,NULL,NULL),(110,15,NULL,NULL,'ANADIS',NULL,NULL),(112,11,NULL,20.000000,NULL,NULL,NULL),(112,12,NULL,82.000000,NULL,NULL,NULL),(112,15,NULL,NULL,'MUNDO ABARROTES',NULL,NULL),(113,11,NULL,12.000000,NULL,NULL,NULL),(113,12,NULL,99.000000,NULL,NULL,NULL),(113,15,NULL,NULL,'MUNDO ABARROTE',NULL,NULL),(114,11,NULL,12.000000,NULL,NULL,NULL),(114,12,NULL,115.000000,NULL,NULL,NULL),(114,15,NULL,NULL,'MUNDO ABARROTE',NULL,NULL),(115,11,NULL,12.000000,NULL,NULL,NULL),(115,12,NULL,100.000000,NULL,NULL,NULL),(115,15,NULL,NULL,'MUNDO ABARROTE',NULL,NULL),(116,11,NULL,12.000000,NULL,NULL,NULL),(116,12,NULL,100.000000,NULL,NULL,NULL),(116,15,NULL,NULL,'MUNDO ABARROTE',NULL,NULL),(117,11,NULL,12.000000,NULL,NULL,NULL),(117,12,NULL,112.000000,NULL,NULL,NULL),(117,15,NULL,NULL,'MUNDO ABARROTE',NULL,NULL),(118,11,NULL,24.000000,NULL,NULL,NULL),(118,12,NULL,29.000000,NULL,NULL,NULL),(118,15,NULL,NULL,'MUNDO ABARROTE',NULL,NULL),(119,11,NULL,12.000000,NULL,NULL,NULL),(119,12,NULL,35.000000,NULL,NULL,NULL),(119,15,NULL,NULL,'MUNDO ABARROTE',NULL,NULL),(120,11,NULL,6.000000,NULL,NULL,NULL),(120,12,NULL,40.000000,NULL,NULL,NULL),(120,15,NULL,NULL,'MUNDO ABARROTES',NULL,NULL),(121,11,NULL,20.000000,NULL,NULL,NULL),(121,12,NULL,31.000000,NULL,NULL,NULL),(121,15,NULL,NULL,'MUNDO ABARROTES',NULL,NULL),(123,11,NULL,12.000000,NULL,NULL,NULL),(123,12,NULL,65.000000,NULL,NULL,NULL),(123,15,NULL,NULL,'MUNDO ABARROTES',NULL,NULL),(124,11,NULL,12.000000,NULL,NULL,NULL),(124,12,NULL,65.000000,NULL,NULL,NULL),(124,15,NULL,NULL,'MUNDO ABARROTES',NULL,NULL),(125,11,NULL,24.000000,NULL,NULL,NULL),(125,12,NULL,79.000000,NULL,NULL,NULL),(125,15,NULL,NULL,'MUNDO ABARROTES',NULL,NULL),(126,11,NULL,32.000000,NULL,NULL,NULL),(126,12,NULL,35.000000,NULL,NULL,NULL),(126,15,NULL,NULL,'MUNDO ABARROTES',NULL,NULL),(127,11,NULL,24.000000,NULL,NULL,NULL),(127,12,NULL,158.000000,NULL,NULL,NULL),(127,15,NULL,NULL,'MUNDO ABARROTES',NULL,NULL),(128,11,NULL,24.000000,NULL,NULL,NULL),(128,12,NULL,91.000000,NULL,NULL,NULL),(128,15,NULL,NULL,'MUNDO ABARROTES',NULL,NULL),(129,11,NULL,24.000000,NULL,NULL,NULL),(129,12,NULL,90.000000,NULL,NULL,NULL),(129,15,NULL,NULL,'MUNDO ABARROTES',NULL,NULL),(130,11,NULL,24.000000,NULL,NULL,NULL),(130,12,NULL,124.000000,NULL,NULL,NULL),(130,15,NULL,NULL,'MUNDO ABARROTES',NULL,NULL),(131,11,NULL,24.000000,NULL,NULL,NULL),(131,12,NULL,124.000000,NULL,NULL,NULL),(131,15,NULL,NULL,'MUNDO ABARROTES',NULL,NULL),(132,11,NULL,24.000000,NULL,NULL,NULL),(132,12,NULL,121.000000,NULL,NULL,NULL),(132,15,NULL,NULL,'MUNDO ABARROTES',NULL,NULL),(133,11,NULL,24.000000,NULL,NULL,NULL),(133,12,NULL,140.000000,NULL,NULL,NULL),(133,15,NULL,NULL,'MUNDO ABARROTES',NULL,NULL),(134,11,NULL,24.000000,NULL,NULL,NULL),(134,12,NULL,128.000000,NULL,NULL,NULL),(134,15,NULL,NULL,'MUNDO ABARROTES',NULL,NULL),(135,11,NULL,25.000000,NULL,NULL,NULL),(135,12,NULL,37.000000,NULL,NULL,NULL),(135,15,NULL,NULL,'MUNDO ABARROTES',NULL,NULL),(136,11,NULL,24.000000,NULL,NULL,NULL),(136,12,NULL,28.000000,NULL,NULL,NULL),(136,15,NULL,NULL,'MUNDO ABARROTES',NULL,NULL),(137,11,NULL,25.000000,NULL,NULL,NULL),(137,12,NULL,40.000000,NULL,NULL,NULL),(137,15,NULL,NULL,'MUNDO ABARROTES',NULL,NULL),(138,11,NULL,25.000000,NULL,NULL,NULL),(138,12,NULL,30.000000,NULL,NULL,NULL),(138,15,NULL,NULL,'MUNDO ABARROTES',NULL,NULL),(139,11,NULL,1.000000,NULL,NULL,NULL),(139,12,NULL,97.000000,NULL,NULL,NULL),(139,15,NULL,NULL,'MAKRO',NULL,NULL),(140,11,NULL,12.000000,NULL,NULL,NULL),(140,12,NULL,142.800000,NULL,NULL,NULL),(140,15,NULL,NULL,'MAKRO',NULL,NULL),(141,11,NULL,1.000000,NULL,NULL,NULL),(141,12,NULL,6.600000,NULL,NULL,NULL),(141,15,NULL,NULL,'MAKRO',NULL,NULL),(142,11,NULL,1.000000,NULL,NULL,NULL),(142,12,NULL,22.300000,NULL,NULL,NULL),(142,15,NULL,NULL,'MAKRO',NULL,NULL),(143,11,NULL,1.000000,NULL,NULL,NULL),(143,12,NULL,5.500000,NULL,NULL,NULL),(143,15,NULL,NULL,'MAKRO',NULL,NULL),(144,11,NULL,12.000000,NULL,NULL,NULL),(144,12,NULL,37.080000,NULL,NULL,NULL),(144,15,NULL,NULL,'MAKRO',NULL,NULL),(145,11,NULL,10.000000,NULL,NULL,NULL),(145,12,NULL,40.000000,NULL,NULL,NULL),(145,15,NULL,NULL,'MAKRO',NULL,NULL),(146,11,NULL,25.000000,NULL,NULL,NULL),(146,12,NULL,103.500000,NULL,NULL,NULL),(146,15,NULL,NULL,'MAKRO',NULL,NULL),(147,11,NULL,1.000000,NULL,NULL,NULL),(147,12,NULL,10.000000,NULL,NULL,NULL),(147,15,NULL,NULL,'MAKRO',NULL,NULL),(148,11,NULL,1.000000,NULL,NULL,NULL),(148,12,NULL,2.700000,NULL,NULL,NULL),(148,15,NULL,NULL,'MAKRO',NULL,NULL),(149,11,NULL,1.000000,NULL,NULL,NULL),(149,12,NULL,5.800000,NULL,NULL,NULL),(149,15,NULL,NULL,'MAKRO',NULL,NULL),(150,11,NULL,1.000000,NULL,NULL,NULL),(150,12,NULL,3.500000,NULL,NULL,NULL),(150,15,NULL,NULL,'MAKRO',NULL,NULL),(151,11,NULL,1.000000,NULL,NULL,NULL),(151,12,NULL,9.000000,NULL,NULL,NULL),(151,15,NULL,NULL,'CASALINDA',NULL,NULL);

--
-- Table structure for table `capacitacion_archivos`
--

CREATE TABLE `capacitacion_archivos` (
  `id` int NOT NULL AUTO_INCREMENT,
  `capacitacion_id` int NOT NULL,
  `nombre_original` varchar(255) NOT NULL,
  `ruta_relativa` varchar(500) NOT NULL,
  `mime` varchar(120) DEFAULT NULL,
  `size_bytes` int DEFAULT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `fk_cap_file_cap` (`capacitacion_id`),
  CONSTRAINT `fk_cap_file_cap` FOREIGN KEY (`capacitacion_id`) REFERENCES `capacitaciones` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `capacitacion_archivos`
--

INSERT INTO `capacitacion_archivos` VALUES (2,1,'SBS.pptx','uploads/capacitaciones/1/SBS.pptx','application/vnd.openxmlformats-officedocument.presentationml.presentation',9635782,'2025-08-20 12:05:59'),(4,2,'CUADRE.docx','uploads/capacitaciones/2/CUADRE.docx','application/vnd.openxmlformats-officedocument.wordprocessingml.document',15388,'2025-08-21 12:19:30'),(5,2,'FACTURACION_FINAL.pdf','uploads/capacitaciones/2/FACTURACION_FINAL.pdf','application/pdf',23574121,'2025-08-22 06:21:38');

--
-- Table structure for table `capacitacion_areas`
--

CREATE TABLE `capacitacion_areas` (
  `capacitacion_id` int NOT NULL,
  `area_id` int NOT NULL,
  PRIMARY KEY (`capacitacion_id`,`area_id`),
  KEY `fk_cap_area_area` (`area_id`),
  CONSTRAINT `fk_cap_area_area` FOREIGN KEY (`area_id`) REFERENCES `areas` (`area_id`),
  CONSTRAINT `fk_cap_area_cap` FOREIGN KEY (`capacitacion_id`) REFERENCES `capacitaciones` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `capacitacion_areas`
--


--
-- Table structure for table `capacitacion_usuarios`
--

CREATE TABLE `capacitacion_usuarios` (
  `capacitacion_id` int NOT NULL,
  `usuario_id` int NOT NULL,
  PRIMARY KEY (`capacitacion_id`,`usuario_id`),
  KEY `fk_cap_usr_usr` (`usuario_id`),
  CONSTRAINT `fk_cap_usr_cap` FOREIGN KEY (`capacitacion_id`) REFERENCES `capacitaciones` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_cap_usr_usr` FOREIGN KEY (`usuario_id`) REFERENCES `usuarios` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `capacitacion_usuarios`
--

INSERT INTO `capacitacion_usuarios` VALUES (2,9),(1,12),(2,12),(1,16),(2,16);

--
-- Table structure for table `capacitaciones`
--

CREATE TABLE `capacitaciones` (
  `id` int NOT NULL AUTO_INCREMENT,
  `tema` varchar(200) NOT NULL,
  `modalidad` enum('PRESENCIAL','VIRTUAL','MIXTA') DEFAULT 'PRESENCIAL',
  `fecha` date NOT NULL,
  `hora_inicio` time DEFAULT NULL,
  `hora_fin` time DEFAULT NULL,
  `duracion_horas` decimal(5,2) DEFAULT NULL,
  `lugar` varchar(150) DEFAULT NULL,
  `estado` enum('PLANIFICADA','EN_CURSO','FINALIZADA','CANCELADA') DEFAULT 'PLANIFICADA',
  `url_material` varchar(500) DEFAULT NULL,
  `notas_html` mediumtext,
  `creado_por` int 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`),
  KEY `fk_cap_creadopor` (`creado_por`),
  CONSTRAINT `fk_cap_creadopor` FOREIGN KEY (`creado_por`) REFERENCES `usuarios` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `capacitaciones`
--

INSERT INTO `capacitaciones` VALUES (1,'SBS','VIRTUAL','2025-08-20','10:00:00','12:00:00',2.00,'SALA','PLANIFICADA',NULL,NULL,1,'2025-08-20 09:47:16','2025-08-21 06:24:20'),(2,'FACTURACION','PRESENCIAL','2025-08-21','08:30:00','11:00:00',2.50,'SALA','PLANIFICADA',NULL,'<ul>\r\n<li>Facturacion y Boletas de diferentes empresas</li>\r\n<li>Facturacion de Divisas (Euros y otros)</li>\r\n<li>Facturacion de transferencia de banco a bancos</li>\r\n<li>Cuadre de sistemas&nbsp;</li>\r\n<li>Concilaciones Bancarias</li>\r\n<li>Subir captura al sisteme los depositos / cheques / declaracion jurada (LAVADO)</li>\r\n<li>SIRE Empresas</li>\r\n<li>Revisi&oacute;n de RO</li>\r\n<li>Validaci&oacute;n de comprobantes - Sistema</li>\r\n<li>Caso Marcos, Dante, Valencia, Zurich</li>\r\n<li>Lavado Presencial Preguntas\r\n<ul>\r\n<li>Ocupacion (Independiente o Dependiente)</li>\r\n<li>De donde proviene el dinero</li>\r\n</ul>\r\n</li>\r\n</ul>',1,'2025-08-20 12:41:06','2025-08-21 12:19:30'),(4,'TRANSFERENCIA','PRESENCIAL','2025-09-01','08:00:00','09:00:00',1.00,'OFICINA 212','PLANIFICADA',NULL,'<ol>\r\n<li>&nbsp;1 Dia, 2,3,4..... que se marque</li>\r\n<li>editar color por dia o los dias como vacaciones ya que puede ser un plan varios dias o meses</li>\r\n<li>&nbsp;</li>\r\n</ol>',9,'2025-09-01 05:57:56','2025-09-01 05:57:56'),(5,'TRANSFERENCIA','PRESENCIAL','2025-09-01','08:00:00','09:00:00',1.00,'OFICINA 212','PLANIFICADA',NULL,'<ol>\r\n<li>&nbsp;1 Dia, 2,3,4..... que se marque</li>\r\n<li>editar color por dia o los dias como vacaciones ya que puede ser un plan varios dias o meses</li>\r\n<li>&nbsp;</li>\r\n</ol>',9,'2025-09-01 05:58:49','2025-09-01 05:58:49'),(6,'TRANSFERENCIA','PRESENCIAL','2025-09-01','08:00:00','09:00:00',1.00,'OFICINA 212','PLANIFICADA',NULL,'<ol>\r\n<li>&nbsp;1 Dia, 2,3,4..... que se marque</li>\r\n<li>editar color por dia o los dias como vacaciones ya que puede ser un plan varios dias o meses</li>\r\n<li>&nbsp;</li>\r\n</ol>',9,'2025-09-01 06:08:16','2025-09-01 06:08:16');

--
-- Table structure for table `cargos`
--

CREATE TABLE `cargos` (
  `cargo_id` int NOT NULL AUTO_INCREMENT,
  `nombre` varchar(80) NOT NULL,
  `descripcion` varchar(255) DEFAULT NULL,
  `area_id` int DEFAULT NULL,
  `estado` enum('ACTIVO','INACTIVO') NOT NULL DEFAULT 'ACTIVO',
  `creado_en` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`cargo_id`),
  UNIQUE KEY `nombre` (`nombre`),
  KEY `fk_cargo_area` (`area_id`),
  CONSTRAINT `fk_cargo_area` FOREIGN KEY (`area_id`) REFERENCES `areas` (`area_id`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `cargos`
--

INSERT INTO `cargos` VALUES (1,'GERENCIA GENERAL','Máxima autoridad de la empresa',24,'ACTIVO','2025-11-03 17:37:13'),(2,'CONTABILIDAD','Responsable contable y tributaria',3,'ACTIVO','2025-11-03 17:37:13'),(3,'OFICIAL DE CUMPLIMIENTO','Gestión SPLAFT/AML y reportes a UIF',6,'ACTIVO','2025-11-03 17:37:13'),(4,'WASAP 1','Atiende clientes por WhatsApp Business: recepción de solicitudes de cambio, validación KYC básica, registro en el sistema, envío de cotizaciones y seguimiento hasta el cierre. Coordina con Transferencia y Ventanilla. Turno A.',19,'ACTIVO','2025-11-06 13:41:11'),(5,'WASAP 2','Mismas funciones que WhatsApp 1. Prioriza tiempos de respuesta, actualización de estado en el sistema y escalamiento de casos observados. Turno B.',15,'ACTIVO','2025-11-06 13:41:11'),(6,'WASAP 3','Mismas funciones que WhatsApp 1. Refuerzo en horas pico y soporte de fin de día para cierre de pendientes y confirmación de operaciones. Turno C.',17,'ACTIVO','2025-11-06 13:41:11'),(7,'VENTANILLA 1','Atención presencial en el local: verificación y conteo de efectivo, detección de billetes falsos, registro de la operación en el sistema y emisión de comprobantes. Responsable del cuadre de su caja. Turno A.',13,'ACTIVO','2025-11-06 13:41:11'),(8,'VENTANILLA 2','Atención presencial en el local: verificación y conteo de efectivo, detección de billetes falsos, registro de la operación en el sistema y emisión de comprobantes. Apoya control de límites por cliente y custodia de valores. Turno B.',14,'ACTIVO','2025-11-06 13:41:11'),(9,'VENTANILLA 3','Atención presencial en el local: verificación y conteo de efectivo, detección de billetes falsos, registro de la operación en el sistema y emisión de comprobantes. Refuerzo en horas pico y apoyo al cierre diario. Turno C.',NULL,'ACTIVO','2025-11-06 13:41:11'),(10,'TRANSFERENCIA 1','Verifica ingresos y salidas en entidades bancarias en tiempo real, adjunta constancias, concilia con el sistema y libera/observa operaciones según políticas SPLAFT. Coordina con WhatsApp y Ventanilla. Turno A.',NULL,'ACTIVO','2025-11-06 13:41:11'),(11,'TRANSFERENCIA 2','Mismas funciones que Transferencia 1. Control de colas de transferencias diferidas, resoluciones con bancos y soporte de cierre bancario diario. Turno B.',21,'ACTIVO','2025-11-06 13:41:11'),(12,'SISTEMA','Encargado de plataforma y procesos: mantenimiento y mejora del sistema (PHP/MySQL), integraciones (SUNAT, WhatsApp API), automatización, seguridad y respaldos. Monitorea desempeño, disponibilidad y maneja incidencias.',1,'ACTIVO','2025-11-06 13:41:11'),(13,'PUBLICIDAD','Planifica y ejecuta marketing digital: contenido, diseño de piezas, campañas pagadas, redes sociales y medición de resultados. Alinea mensajes con promociones y objetivos comerciales de la casa de cambio.',2,'ACTIVO','2025-11-06 13:41:11'),(14,'SUPERVISOR','Supervisa operaciones diarias y cumplimiento de políticas: prioriza casos, resuelve incidencias, autoriza excepciones, entrena al equipo y verifica cuadre de caja/bancos. Enlace con Gerencia y Cumplimiento.',25,'ACTIVO','2025-11-06 13:41:11');

--
-- Table structure for table `carpetas`
--

CREATE TABLE `carpetas` (
  `carpeta_id` int NOT NULL AUTO_INCREMENT,
  `usuario_id` int NOT NULL,
  `nombre` varchar(80) NOT NULL,
  `creado_en` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`carpeta_id`),
  KEY `idx_carpetas_usuario` (`usuario_id`),
  CONSTRAINT `fk_carpetas_usuario` FOREIGN KEY (`usuario_id`) REFERENCES `usuarios` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `carpetas`
--

INSERT INTO `carpetas` VALUES (5,1,'Carpeta 1','2025-08-11 06:59:38'),(6,1,'Carpeta 2','2025-08-11 07:09:01'),(7,1,'Carpeta 3','2025-08-11 07:09:11'),(8,1,'AREA 1','2025-08-12 05:57:09'),(9,9,'local Mariscal 315 JM','2025-08-12 05:58:30'),(10,1,'Carpeta 4','2025-08-12 06:25:44'),(11,9,'PRUEBA','2025-09-08 06:51:55'),(12,11,'BORRADOR','2025-09-09 06:38:15'),(13,11,'TRANSFERENCIA BANCARIA','2025-09-09 06:39:32'),(14,11,'COTEJO','2025-09-20 16:22:41'),(15,9,'ENTIDADES DEL ESTADOS','2025-12-07 12:32:00');

--
-- Table structure for table `carpetas_video`
--

CREATE TABLE `carpetas_video` (
  `id` int NOT NULL AUTO_INCREMENT,
  `usuario_id` int NOT NULL,
  `parent_id` int DEFAULT NULL,
  `nombre` varchar(180) NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `drive_folder_id` varchar(128) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_carpetas_parent` (`parent_id`),
  KEY `idx_carpetas_usuario` (`usuario_id`),
  KEY `idx_cv_parent` (`parent_id`),
  KEY `idx_cv_usuario` (`usuario_id`),
  CONSTRAINT `fk_carpetas_parent` FOREIGN KEY (`parent_id`) REFERENCES `carpetas_video` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `carpetas_video`
--

INSERT INTO `carpetas_video` VALUES (1,1,NULL,'Raíz','2025-09-11 15:34:46','2025-09-16 16:07:33','15qr-S-ya_GnaKJmPTy8rxBfbLwl-Xtu-'),(13,1,1,'TRANSFERENCIA','2025-09-16 16:07:33','2025-09-16 16:07:33','15DLexcu7i_nYM9OBwv74v4P7F_R-t2UH'),(15,1,1,'10-09','2025-09-16 17:38:40','2025-09-16 17:38:40','1wiJy6SEiTQVWWKdmyJLFMA_vtEfO1HEZ'),(16,1,1,'Dyanire','2025-09-16 17:57:37','2025-09-16 17:57:37','1xUPf84mMWZQ1O8ovTbKAqrdtqLulrOLs'),(17,9,NULL,'Raíz','2025-09-17 12:43:06','2025-09-17 12:43:06',NULL),(18,11,NULL,'Raíz','2025-10-11 20:39:12','2025-10-11 20:39:12',NULL),(19,1,1,'CASO PEDRO','2025-10-17 11:23:34','2025-10-17 12:38:16','16-lj6beH5j_rnvsMPDW_pAMvriw1OZLL'),(20,1,1,'Martes-14-10','2025-10-17 11:52:49','2025-10-17 11:52:49','1uGrZNsY7691KlrheRuAOx7TIRIUg6uTj'),(21,1,1,'Viernes-10-10','2025-10-17 11:58:50','2025-10-17 11:58:50','1aflDXP59k23k0uw6a7dVpWdGXqFy3ZIE'),(22,12,NULL,'Raíz','2025-10-17 14:59:34','2025-11-26 15:58:41','11bPke9sqGx7AaoDjrDfyZp6AMKS9ORVX'),(23,1,1,'TDV - agenda_sbs','2025-10-25 18:09:41','2025-10-25 18:09:41','15SL_xB_4QorCPd89KN3ZWGADLk4sv6xr'),(25,21,NULL,'Raíz','2025-11-04 02:03:38','2025-11-04 02:03:38',NULL),(26,13,NULL,'Raíz','2025-11-04 17:04:46','2025-11-04 17:04:46',NULL),(27,29,NULL,'Raíz','2026-01-06 12:03:20','2026-01-06 12:03:20',NULL);

--
-- Table structure for table `cat_servicio`
--

CREATE TABLE `cat_servicio` (
  `servicio_id` int NOT NULL AUTO_INCREMENT,
  `nombre` varchar(80) NOT NULL,
  `slug` varchar(60) NOT NULL,
  PRIMARY KEY (`servicio_id`),
  UNIQUE KEY `slug` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `cat_servicio`
--

INSERT INTO `cat_servicio` VALUES (1,'HOSTING / SERVIDOR','hosting-servidor'),(2,'DOMINIO','dominio'),(3,'ANTIVIRUS','antivirus'),(4,'SUSCRIPCIÓN SAAS','suscripcion-saas'),(5,'CORREO','correo'),(6,'API WHATSAPP','api-whatsapp');

--
-- Table structure for table `cissac_dep`
--

CREATE TABLE `cissac_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=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `cissac_dep`
--

INSERT INTO `cissac_dep` VALUES (1,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>CUADRO:&nbsp;<br>PAGO DE SERVICIO POR MES&nbsp; DE TODOS LOS INMUEBLES</p>\n<p>LLEVAR UN CONTROL&nbsp;</p>\n<p>GESTION&nbsp;</p>','2025-10-10 05:54:00','2025-10-10 06:22:57');

--
-- Table structure for table `cita_acuerdos`
--

CREATE TABLE `cita_acuerdos` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `usuario_id` int unsigned NOT NULL,
  `nombre` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'CITA_ACUERDOS',
  `fecha` date NOT NULL,
  `columnas` json NOT NULL,
  `filas` json NOT NULL,
  `anchos` json NOT NULL,
  `creado_en` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `actualizado_en` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `idx_usuario_nombre` (`usuario_id`,`nombre`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cita_acuerdos`
--

INSERT INTO `cita_acuerdos` VALUES (1,9,'CITA_ACUERDOS','2025-11-27','[\"FECHA DE CITA (AAAA/MM/DD)\", \"ESPECIALIDAD (hepatología, nutrición, cardio, etc)\", \"NOMBRE DEL PROFECIONAL\", \"MOTIVO DE LA CONSULTA\", \"PUNTOS CLAVE QUE COMENTO\", \"INDICACIONES PRINCIPALES (resumidas)\", \"EXAMENES PEDIDOS\", \"FECHA DEL PROXIMO CONTROL\", \"¿QUE DEBO TENER LISTO PARA LA PRÓXIMA CITA\"]','[[\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]]','[302, 436, 280, 259, 304, 367, 220, 306, 449]','2025-11-27 04:09:35','2025-11-27 04:12:41'),(2,11,'CITA_ACUERDOS','2025-11-27','[\"FECHA DE CITA (AAAA/MM/DD)\", \"ESPECIALIDAD (hepatología, nutrición, cardio, etc)\", \"NOMBRE DEL PROFECIONAL\", \"MOTIVO DE LA CONSULTA\", \"PUNTOS CLAVE QUE COMENTO\", \"INDICACIONES PRINCIPALES (resumidas)\", \"EXAMENES PEDIDOS\", \"FECHA DEL PROXIMO CONTROL\", \"¿QUE DEBO TENER LISTO PARA LA PRÓXIMA CITA\"]','[[\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]]','[302, 436, 280, 259, 304, 367, 220, 306, 449]','2025-11-27 09:09:35','2025-11-27 09:12:41');

--
-- Table structure for table `compra_lista`
--

CREATE TABLE `compra_lista` (
  `lista_id` int NOT NULL AUTO_INCREMENT,
  `fecha` date NOT NULL,
  `creado_por` int NOT NULL,
  `creado_en` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`lista_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `compra_lista`
--

INSERT INTO `compra_lista` VALUES (1,'2025-10-15',1,'2025-10-24 02:34:11'),(2,'2025-11-01',1,'2025-10-24 02:34:25'),(3,'2025-10-23',1,'2025-10-24 11:06:49'),(4,'2025-11-24',1,'2025-10-24 11:08:01');

--
-- Table structure for table `compra_lista_item`
--

CREATE TABLE `compra_lista_item` (
  `lista_id` int NOT NULL,
  `producto_id` int NOT NULL,
  `cantidad` decimal(12,3) NOT NULL,
  `venta_unit_override` decimal(12,2) DEFAULT NULL,
  `igv_pct_override` decimal(5,4) DEFAULT NULL,
  PRIMARY KEY (`lista_id`,`producto_id`),
  KEY `producto_id` (`producto_id`),
  CONSTRAINT `compra_lista_item_ibfk_1` FOREIGN KEY (`lista_id`) REFERENCES `compra_lista` (`lista_id`),
  CONSTRAINT `compra_lista_item_ibfk_2` FOREIGN KEY (`producto_id`) REFERENCES `producto` (`producto_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `compra_lista_item`
--

INSERT INTO `compra_lista_item` VALUES (1,1,0.000,NULL,NULL),(1,2,0.000,NULL,NULL),(1,3,1.000,NULL,NULL),(1,4,1.000,NULL,NULL),(1,5,0.000,NULL,NULL),(1,6,0.000,NULL,NULL),(1,7,0.000,NULL,NULL),(1,8,0.000,NULL,NULL),(1,9,0.000,NULL,NULL),(1,10,0.000,NULL,NULL),(1,11,0.000,NULL,NULL),(1,12,0.000,NULL,NULL),(1,13,0.000,NULL,NULL),(1,14,0.000,NULL,NULL),(1,15,0.000,NULL,NULL),(1,16,0.000,NULL,NULL),(1,17,0.000,NULL,NULL),(1,18,1.000,NULL,NULL),(1,19,0.000,NULL,NULL),(1,20,0.000,NULL,NULL),(1,21,0.000,NULL,NULL),(1,22,2.000,NULL,NULL),(1,23,0.000,NULL,NULL),(2,1,0.000,NULL,NULL),(2,2,0.000,NULL,NULL),(2,3,1.000,NULL,NULL),(2,4,1.000,NULL,NULL),(2,5,0.000,NULL,NULL),(2,6,0.000,NULL,NULL),(2,7,0.000,NULL,NULL),(2,8,0.000,NULL,NULL),(2,9,0.000,NULL,NULL),(2,10,0.000,NULL,NULL),(2,11,0.000,NULL,NULL),(2,12,0.000,NULL,NULL),(2,13,0.000,NULL,NULL),(2,14,0.000,NULL,NULL),(2,15,0.000,NULL,NULL),(2,16,0.000,NULL,NULL),(2,17,0.000,NULL,NULL),(2,18,1.000,NULL,NULL),(2,19,0.000,NULL,NULL),(2,20,0.000,NULL,NULL),(2,21,0.000,NULL,NULL),(2,22,2.000,NULL,NULL),(2,23,0.000,NULL,NULL),(3,1,0.000,NULL,NULL),(3,2,0.000,NULL,NULL),(3,3,1.000,NULL,NULL),(3,4,1.000,NULL,NULL),(3,5,0.000,NULL,NULL),(3,6,1.000,NULL,NULL),(3,7,0.000,NULL,NULL),(3,8,0.000,NULL,NULL),(3,9,0.000,NULL,NULL),(3,10,0.000,NULL,NULL),(3,11,0.000,NULL,NULL),(3,12,0.000,NULL,NULL),(3,13,0.000,NULL,NULL),(3,14,0.000,NULL,NULL),(3,15,0.000,NULL,NULL),(3,16,0.000,NULL,NULL),(3,17,0.000,NULL,NULL),(3,18,1.000,NULL,NULL),(3,19,0.000,NULL,NULL),(3,20,0.000,NULL,NULL),(3,21,0.000,NULL,NULL),(3,22,2.000,NULL,NULL),(3,23,0.000,NULL,NULL),(4,1,0.000,NULL,NULL),(4,2,0.000,NULL,NULL),(4,3,1.000,NULL,NULL),(4,4,1.000,NULL,NULL),(4,5,0.000,NULL,NULL),(4,6,1.000,NULL,NULL),(4,7,0.000,NULL,NULL),(4,8,0.000,NULL,NULL),(4,9,0.000,NULL,NULL),(4,10,0.000,NULL,NULL),(4,11,0.000,NULL,NULL),(4,12,0.000,NULL,NULL),(4,13,0.000,NULL,NULL),(4,14,0.000,NULL,NULL),(4,15,0.000,NULL,NULL),(4,16,0.000,NULL,NULL),(4,17,0.000,NULL,NULL),(4,18,1.000,NULL,NULL),(4,19,0.000,NULL,NULL),(4,20,0.000,NULL,NULL),(4,21,0.000,NULL,NULL),(4,22,2.000,NULL,NULL),(4,23,0.000,NULL,NULL);

--
-- Table structure for table `compra_lista_item_sede`
--

CREATE TABLE `compra_lista_item_sede` (
  `lista_id` int NOT NULL,
  `producto_id` int NOT NULL,
  `sede_id` int NOT NULL,
  `stock` decimal(12,3) NOT NULL,
  PRIMARY KEY (`lista_id`,`producto_id`,`sede_id`),
  KEY `producto_id` (`producto_id`),
  KEY `sede_id` (`sede_id`),
  CONSTRAINT `compra_lista_item_sede_ibfk_1` FOREIGN KEY (`lista_id`) REFERENCES `compra_lista` (`lista_id`),
  CONSTRAINT `compra_lista_item_sede_ibfk_2` FOREIGN KEY (`producto_id`) REFERENCES `producto` (`producto_id`),
  CONSTRAINT `compra_lista_item_sede_ibfk_3` FOREIGN KEY (`sede_id`) REFERENCES `sedes` (`sede_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `compra_lista_item_sede`
--

INSERT INTO `compra_lista_item_sede` VALUES (1,1,1,0.000),(1,1,2,0.000),(1,1,3,0.000),(1,1,5,0.000),(1,2,1,0.000),(1,2,2,0.000),(1,2,3,0.000),(1,2,5,0.000),(1,3,1,0.000),(1,3,2,1.000),(1,3,3,0.000),(1,3,5,0.000),(1,4,1,0.000),(1,4,2,0.000),(1,4,3,1.000),(1,4,5,0.000),(1,5,1,0.000),(1,5,2,0.000),(1,5,3,0.000),(1,5,5,0.000),(1,6,1,0.000),(1,6,2,0.000),(1,6,3,0.000),(1,6,5,0.000),(1,7,1,0.000),(1,7,2,0.000),(1,7,3,0.000),(1,7,5,0.000),(1,8,1,0.000),(1,8,2,0.000),(1,8,3,0.000),(1,8,5,0.000),(1,9,1,0.000),(1,9,2,0.000),(1,9,3,0.000),(1,9,5,0.000),(1,10,1,0.000),(1,10,2,0.000),(1,10,3,0.000),(1,10,5,0.000),(1,11,1,0.000),(1,11,2,0.000),(1,11,3,0.000),(1,11,5,0.000),(1,12,1,0.000),(1,12,2,0.000),(1,12,3,0.000),(1,12,5,0.000),(1,13,1,0.000),(1,13,2,0.000),(1,13,3,0.000),(1,13,5,0.000),(1,14,1,0.000),(1,14,2,0.000),(1,14,3,0.000),(1,14,5,0.000),(1,15,1,0.000),(1,15,2,0.000),(1,15,3,0.000),(1,15,5,0.000),(1,16,1,0.000),(1,16,2,0.000),(1,16,3,0.000),(1,16,5,0.000),(1,17,1,0.000),(1,17,2,0.000),(1,17,3,0.000),(1,17,5,0.000),(1,18,1,1.000),(1,18,2,0.000),(1,18,3,0.000),(1,18,5,0.000),(1,19,1,0.000),(1,19,2,0.000),(1,19,3,0.000),(1,19,5,0.000),(1,20,1,0.000),(1,20,2,0.000),(1,20,3,0.000),(1,20,5,0.000),(1,21,1,0.000),(1,21,2,0.000),(1,21,3,0.000),(1,21,5,0.000),(1,22,1,2.000),(1,22,2,0.000),(1,22,3,0.000),(1,22,5,0.000),(1,23,1,0.000),(1,23,2,0.000),(1,23,3,0.000),(1,23,5,0.000),(2,1,1,0.000),(2,1,2,0.000),(2,1,3,0.000),(2,1,5,0.000),(2,2,1,0.000),(2,2,2,0.000),(2,2,3,0.000),(2,2,5,0.000),(2,3,1,0.000),(2,3,2,1.000),(2,3,3,0.000),(2,3,5,0.000),(2,4,1,0.000),(2,4,2,0.000),(2,4,3,1.000),(2,4,5,0.000),(2,5,1,0.000),(2,5,2,0.000),(2,5,3,0.000),(2,5,5,0.000),(2,6,1,0.000),(2,6,2,0.000),(2,6,3,0.000),(2,6,5,0.000),(2,7,1,0.000),(2,7,2,0.000),(2,7,3,0.000),(2,7,5,0.000),(2,8,1,0.000),(2,8,2,0.000),(2,8,3,0.000),(2,8,5,0.000),(2,9,1,0.000),(2,9,2,0.000),(2,9,3,0.000),(2,9,5,0.000),(2,10,1,0.000),(2,10,2,0.000),(2,10,3,0.000),(2,10,5,0.000),(2,11,1,0.000),(2,11,2,0.000),(2,11,3,0.000),(2,11,5,0.000),(2,12,1,0.000),(2,12,2,0.000),(2,12,3,0.000),(2,12,5,0.000),(2,13,1,0.000),(2,13,2,0.000),(2,13,3,0.000),(2,13,5,0.000),(2,14,1,0.000),(2,14,2,0.000),(2,14,3,0.000),(2,14,5,0.000),(2,15,1,0.000),(2,15,2,0.000),(2,15,3,0.000),(2,15,5,0.000),(2,16,1,0.000),(2,16,2,0.000),(2,16,3,0.000),(2,16,5,0.000),(2,17,1,0.000),(2,17,2,0.000),(2,17,3,0.000),(2,17,5,0.000),(2,18,1,1.000),(2,18,2,0.000),(2,18,3,0.000),(2,18,5,0.000),(2,19,1,0.000),(2,19,2,0.000),(2,19,3,0.000),(2,19,5,0.000),(2,20,1,0.000),(2,20,2,0.000),(2,20,3,0.000),(2,20,5,0.000),(2,21,1,0.000),(2,21,2,0.000),(2,21,3,0.000),(2,21,5,0.000),(2,22,1,2.000),(2,22,2,0.000),(2,22,3,0.000),(2,22,5,0.000),(2,23,1,0.000),(2,23,2,0.000),(2,23,3,0.000),(2,23,5,0.000),(3,1,1,0.000),(3,1,2,0.000),(3,1,3,0.000),(3,1,5,0.000),(3,2,1,0.000),(3,2,2,0.000),(3,2,3,0.000),(3,2,5,0.000),(3,3,1,0.000),(3,3,2,1.000),(3,3,3,0.000),(3,3,5,0.000),(3,4,1,0.000),(3,4,2,0.000),(3,4,3,1.000),(3,4,5,0.000),(3,5,1,0.000),(3,5,2,0.000),(3,5,3,0.000),(3,5,5,0.000),(3,6,1,0.000),(3,6,2,0.000),(3,6,3,1.000),(3,6,5,0.000),(3,7,1,0.000),(3,7,2,0.000),(3,7,3,0.000),(3,7,5,0.000),(3,8,1,0.000),(3,8,2,0.000),(3,8,3,0.000),(3,8,5,0.000),(3,9,1,0.000),(3,9,2,0.000),(3,9,3,0.000),(3,9,5,0.000),(3,10,1,0.000),(3,10,2,0.000),(3,10,3,0.000),(3,10,5,0.000),(3,11,1,0.000),(3,11,2,0.000),(3,11,3,0.000),(3,11,5,0.000),(3,12,1,0.000),(3,12,2,0.000),(3,12,3,0.000),(3,12,5,0.000),(3,13,1,0.000),(3,13,2,0.000),(3,13,3,0.000),(3,13,5,0.000),(3,14,1,0.000),(3,14,2,0.000),(3,14,3,0.000),(3,14,5,0.000),(3,15,1,0.000),(3,15,2,0.000),(3,15,3,0.000),(3,15,5,0.000),(3,16,1,0.000),(3,16,2,0.000),(3,16,3,0.000),(3,16,5,0.000),(3,17,1,0.000),(3,17,2,0.000),(3,17,3,0.000),(3,17,5,0.000),(3,18,1,1.000),(3,18,2,0.000),(3,18,3,0.000),(3,18,5,0.000),(3,19,1,0.000),(3,19,2,0.000),(3,19,3,0.000),(3,19,5,0.000),(3,20,1,0.000),(3,20,2,0.000),(3,20,3,0.000),(3,20,5,0.000),(3,21,1,0.000),(3,21,2,0.000),(3,21,3,0.000),(3,21,5,0.000),(3,22,1,2.000),(3,22,2,0.000),(3,22,3,0.000),(3,22,5,0.000),(3,23,1,0.000),(3,23,2,0.000),(3,23,3,0.000),(3,23,5,0.000),(4,1,1,0.000),(4,1,2,0.000),(4,1,3,0.000),(4,1,5,0.000),(4,2,1,0.000),(4,2,2,0.000),(4,2,3,0.000),(4,2,5,0.000),(4,3,1,0.000),(4,3,2,1.000),(4,3,3,0.000),(4,3,5,0.000),(4,4,1,0.000),(4,4,2,0.000),(4,4,3,1.000),(4,4,5,0.000),(4,5,1,0.000),(4,5,2,0.000),(4,5,3,0.000),(4,5,5,0.000),(4,6,1,0.000),(4,6,2,0.000),(4,6,3,1.000),(4,6,5,0.000),(4,7,1,0.000),(4,7,2,0.000),(4,7,3,0.000),(4,7,5,0.000),(4,8,1,0.000),(4,8,2,0.000),(4,8,3,0.000),(4,8,5,0.000),(4,9,1,0.000),(4,9,2,0.000),(4,9,3,0.000),(4,9,5,0.000),(4,10,1,0.000),(4,10,2,0.000),(4,10,3,0.000),(4,10,5,0.000),(4,11,1,0.000),(4,11,2,0.000),(4,11,3,0.000),(4,11,5,0.000),(4,12,1,0.000),(4,12,2,0.000),(4,12,3,0.000),(4,12,5,0.000),(4,13,1,0.000),(4,13,2,0.000),(4,13,3,0.000),(4,13,5,0.000),(4,14,1,0.000),(4,14,2,0.000),(4,14,3,0.000),(4,14,5,0.000),(4,15,1,0.000),(4,15,2,0.000),(4,15,3,0.000),(4,15,5,0.000),(4,16,1,0.000),(4,16,2,0.000),(4,16,3,0.000),(4,16,5,0.000),(4,17,1,0.000),(4,17,2,0.000),(4,17,3,0.000),(4,17,5,0.000),(4,18,1,1.000),(4,18,2,0.000),(4,18,3,0.000),(4,18,5,0.000),(4,19,1,0.000),(4,19,2,0.000),(4,19,3,0.000),(4,19,5,0.000),(4,20,1,0.000),(4,20,2,0.000),(4,20,3,0.000),(4,20,5,0.000),(4,21,1,0.000),(4,21,2,0.000),(4,21,3,0.000),(4,21,5,0.000),(4,22,1,2.000),(4,22,2,0.000),(4,22,3,0.000),(4,22,5,0.000),(4,23,1,0.000),(4,23,2,0.000),(4,23,3,0.000),(4,23,5,0.000);

--
-- Table structure for table `comprobante_compra`
--

CREATE TABLE `comprobante_compra` (
  `comprobante_id` int NOT NULL AUTO_INCREMENT,
  `empresa_id` int NOT NULL,
  `tipo` enum('FACTURA','BOLETA','RECIBO','OTRO') NOT NULL,
  `serie` varchar(10) NOT NULL,
  `numero` varchar(20) NOT NULL,
  `fecha_emision` date NOT NULL,
  `moneda` enum('PEN','USD','EUR') NOT NULL DEFAULT 'PEN',
  `total` decimal(12,2) DEFAULT NULL,
  `proveedor` varchar(160) DEFAULT NULL,
  `drive_file_id` varchar(128) DEFAULT NULL,
  `drive_web_link` varchar(255) DEFAULT NULL,
  `notas` varchar(255) DEFAULT NULL,
  `creado_por` int DEFAULT NULL,
  `creado_en` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`comprobante_id`),
  UNIQUE KEY `uq_comp` (`tipo`,`serie`,`numero`),
  KEY `idx_cc_empresa` (`empresa_id`),
  CONSTRAINT `fk_cc_empresa` FOREIGN KEY (`empresa_id`) REFERENCES `empresas` (`empresa_id`) ON DELETE RESTRICT ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `comprobante_compra`
--


--
-- Table structure for table `conceptos`
--

CREATE TABLE `conceptos` (
  `concepto_id` int NOT NULL AUTO_INCREMENT,
  `codigo` varchar(30) NOT NULL,
  `nombre` varchar(120) NOT NULL,
  `tipo` enum('INGRESO','DESCUENTO') NOT NULL,
  `es_fijo` tinyint(1) NOT NULL DEFAULT '0',
  `editable_monto` tinyint(1) NOT NULL DEFAULT '1',
  `estado` enum('ACTIVO','INACTIVO') NOT NULL DEFAULT 'ACTIVO',
  `creado_en` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `afecta_neto` tinyint(1) NOT NULL DEFAULT '1',
  `afecta_onp` tinyint(1) NOT NULL DEFAULT '1',
  `afecta_afp` tinyint(1) NOT NULL DEFAULT '1',
  `afecta_essalud` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`concepto_id`),
  UNIQUE KEY `codigo` (`codigo`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `conceptos`
--

INSERT INTO `conceptos` VALUES (1,'ASIG_FAM','Asignación familiar','INGRESO',1,0,'ACTIVO','2025-12-17 10:04:22',1,1,1,1),(2,'BONO_MOV','Bono de movilidad (fijo)','INGRESO',1,1,'ACTIVO','2025-12-17 10:04:22',1,0,0,0),(3,'BONO_ALIM','Bono de alimentación (fijo)','INGRESO',1,1,'ACTIVO','2025-12-17 10:04:22',1,0,0,0),(4,'BONO_REFRI','Bono refrigerio (fijo)','INGRESO',1,1,'ACTIVO','2025-12-17 10:04:22',1,0,0,0),(5,'BONO_RESP','Bono por responsabilidad (fijo)','INGRESO',1,1,'ACTIVO','2025-12-17 10:04:22',1,1,1,1),(6,'BONO_PROD_FIJO','Bono de productividad (fijo)','INGRESO',1,1,'ACTIVO','2025-12-17 10:04:22',1,1,1,1),(7,'ASIG_ESCOLAR','Asignación escolar (fijo)','INGRESO',1,1,'ACTIVO','2025-12-17 10:04:22',1,0,0,0),(8,'COMISION_FIJA','Comisión fija mensual','INGRESO',1,1,'ACTIVO','2025-12-17 10:04:22',1,1,1,1),(9,'DSCT_PRESTAMO','Descuento por préstamo (cuota fija)','DESCUENTO',1,1,'ACTIVO','2025-12-17 10:04:22',1,0,0,0),(10,'DSCT_ADELANTO','Descuento por adelanto (cuota fija)','DESCUENTO',1,1,'ACTIVO','2025-12-17 10:04:22',1,0,0,0),(11,'DSCT_TARD_FIJO','Descuento fijo por tardanza (monto fijo)','DESCUENTO',1,1,'ACTIVO','2025-12-17 10:04:22',1,0,0,0),(12,'DSCT_PENAL','Penalidad / Descuento fijo','DESCUENTO',1,1,'ACTIVO','2025-12-17 10:04:22',1,0,0,0),(13,'DSCT_SEGURO','Seguro / descuento fijo (si aplica)','DESCUENTO',1,1,'ACTIVO','2025-12-17 10:04:22',1,0,0,0),(14,'DSCT_SINDICATO','Cuota sindical (si aplica)','DESCUENTO',1,1,'ACTIVO','2025-12-17 10:04:22',1,0,0,0),(15,'DSCT_OTROS_FIJOS','Otros descuentos fijos','DESCUENTO',1,1,'ACTIVO','2025-12-17 10:04:22',1,0,0,0),(16,'BONO_CUMPLE','Bono de cumpleaños','INGRESO',1,1,'ACTIVO','2025-12-17 10:07:45',1,0,0,0);

--
-- Table structure for table `consumo_plan`
--

CREATE TABLE `consumo_plan` (
  `plan_id` int NOT NULL AUTO_INCREMENT,
  `sede_id` int NOT NULL,
  `producto_id` int NOT NULL,
  `cant_diaria` decimal(12,3) NOT NULL,
  `activo` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`plan_id`),
  UNIQUE KEY `uk_plan` (`sede_id`,`producto_id`),
  KEY `fk_plan_producto` (`producto_id`),
  CONSTRAINT `fk_plan_producto` FOREIGN KEY (`producto_id`) REFERENCES `producto` (`producto_id`) ON DELETE RESTRICT ON UPDATE CASCADE,
  CONSTRAINT `fk_plan_sede` FOREIGN KEY (`sede_id`) REFERENCES `sedes` (`sede_id`) ON DELETE RESTRICT ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `consumo_plan`
--

INSERT INTO `consumo_plan` VALUES (1,3,4,0.000,0),(2,2,4,500.000,1);

--
-- Table structure for table `contenedores`
--

CREATE TABLE `contenedores` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `empresa_id` int NOT NULL,
  `padre_id` bigint DEFAULT NULL,
  `titulo` varchar(255) NOT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `ruta_indexada` text,
  `hereda_acceso` tinyint(1) NOT NULL DEFAULT '1',
  `orden` int NOT NULL DEFAULT '0',
  `creado_en` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `actualizado_en` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  `eliminado_en` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ix_cont_empresa` (`empresa_id`),
  KEY `ix_cont_padre` (`padre_id`),
  KEY `ix_cont_titulo` (`titulo`),
  CONSTRAINT `fk_contenedores_empresa` FOREIGN KEY (`empresa_id`) REFERENCES `empresas` (`empresa_id`) ON DELETE CASCADE,
  CONSTRAINT `fk_contenedores_padre` FOREIGN KEY (`padre_id`) REFERENCES `contenedores` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `contenedores`
--

INSERT INTO `contenedores` VALUES (1,2,NULL,'Legal','legal','/Legal',1,1,'2025-10-31 16:32:32','2025-10-31 17:01:54',NULL),(2,2,NULL,'Contabilidad-Finanzas','contabilidad-finanzas','/Contabilidad-Finanzas',1,2,'2025-10-31 16:32:32','2025-10-31 17:01:58',NULL),(3,2,NULL,'Operaciones','operaciones','/Operaciones',1,3,'2025-10-31 16:32:32','2025-10-31 17:02:02',NULL),(4,2,NULL,'RRHH','rrhh','/RRHH',1,4,'2025-10-31 16:32:32','2025-10-31 17:02:05',NULL),(5,2,NULL,'SPLAFT','splaft','/SPLAFT',1,5,'2025-10-31 16:32:32','2025-10-31 17:02:08',NULL),(6,3,NULL,'Legal','legal',NULL,1,999,'2025-10-31 17:22:50',NULL,NULL);

--
-- Table structure for table `contrato_archivos`
--

CREATE TABLE `contrato_archivos` (
  `id` int NOT NULL AUTO_INCREMENT,
  `contrato_id` int NOT NULL,
  `tipo` enum('CONTRATO','ANEXO','RENOVACION','OTRO') NOT NULL DEFAULT 'ANEXO',
  `archivo` varchar(255) NOT NULL,
  `orden` int NOT NULL DEFAULT '1',
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `contrato_id` (`contrato_id`),
  CONSTRAINT `fk_archivo_contrato` FOREIGN KEY (`contrato_id`) REFERENCES `contratos_trabajador` (`id_contrato`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `contrato_archivos`
--


--
-- Table structure for table `contratos`
--

CREATE TABLE `contratos` (
  `id` int NOT NULL AUTO_INCREMENT,
  `unidad_id` int NOT NULL,
  `alias_inquilino` varchar(120) DEFAULT NULL,
  `contacto_tel` varchar(50) DEFAULT NULL,
  `fecha_inicio` date NOT NULL,
  `fecha_fin` date DEFAULT NULL,
  `monto` decimal(10,2) NOT NULL,
  `moneda` char(3) NOT NULL DEFAULT 'PEN',
  `dia_vencimiento` tinyint unsigned NOT NULL DEFAULT '5',
  `deposito_monto` decimal(10,2) DEFAULT '0.00',
  `estado` enum('VIGENTE','VENCIDO','RESUELTO') DEFAULT 'VIGENTE',
  `notas` text,
  `archivo_contrato` varchar(255) DEFAULT NULL,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `idx_contratos_unidad` (`unidad_id`),
  KEY `idx_contratos_estado` (`estado`),
  CONSTRAINT `fk_ctr_uni` FOREIGN KEY (`unidad_id`) REFERENCES `unidades` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `contratos`
--

INSERT INTO `contratos` VALUES (5,17,'CORPORACION INDUSTRIAL TRADING SAC','924806875','2025-06-01','2025-12-01',950.00,'PEN',2,0.00,'VIGENTE','','https://drive.google.com/file/d/199BkGc3d7CpoUlCr4-G0eKrYkWWRLhDa/view?usp=drivesdk','2025-10-13 07:10:14','2025-10-14 11:35:24'),(8,28,'AQUILINA ANDRADE VDA DE NAKAMURA','956479712','2024-12-01','2025-11-30',2250.00,'PEN',2,0.00,'VIGENTE','','https://drive.google.com/file/d/1We51ZWt493K1lxqpX4m39d0NqDfRmxF-/view?usp=drivesdk','2025-10-17 06:58:08','2025-10-17 06:58:08'),(9,27,'FLOR NUÑEZ SALAS','992733643','2026-02-01','2026-02-01',1500.00,'PEN',2,0.00,'VIGENTE','','https://drive.google.com/file/d/13WN6aMLnypT7--bDZvR2VvUTC4cZcStz/view?usp=drivesdk','2025-10-17 08:19:53','2025-10-17 08:19:53');

--
-- Table structure for table `contratos_trabajador`
--

CREATE TABLE `contratos_trabajador` (
  `id_contrato` int NOT NULL AUTO_INCREMENT,
  `id_trabajador` int NOT NULL,
  `empresa_id` int NOT NULL,
  `tipo_contrato` varchar(80) NOT NULL,
  `fecha_inicio` date NOT NULL,
  `fecha_fin` date DEFAULT NULL,
  `fecha_alerta` date DEFAULT NULL,
  `jornada` varchar(50) DEFAULT NULL,
  `sueldo` decimal(10,2) DEFAULT NULL,
  `estado` enum('VIGENTE','POR_VENCER','VENCIDO','RENOVADO') DEFAULT 'VIGENTE',
  `archivo_pdf` varchar(255) DEFAULT NULL,
  `archivo_anexo1` varchar(255) DEFAULT NULL,
  `archivo_anexo2` varchar(255) DEFAULT NULL,
  `archivo_anexo3` varchar(255) DEFAULT NULL,
  `archivo_anexo4` varchar(255) DEFAULT NULL,
  `archivo_anexo5` varchar(255) DEFAULT NULL,
  `archivo_anexo6` varchar(255) DEFAULT NULL,
  `archivo_anexo7` varchar(255) DEFAULT NULL,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id_contrato`),
  KEY `idx_ct_emp` (`empresa_id`),
  KEY `idx_ct_trab` (`id_trabajador`),
  CONSTRAINT `fk_contratos_trabajador` FOREIGN KEY (`id_trabajador`) REFERENCES `trabajadores` (`id_trabajador`) ON DELETE CASCADE,
  CONSTRAINT `fk_ct_emp` FOREIGN KEY (`empresa_id`) REFERENCES `empresas` (`empresa_id`),
  CONSTRAINT `fk_ct_trab` FOREIGN KEY (`id_trabajador`) REFERENCES `trabajadores` (`id_trabajador`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `contratos_trabajador`
--

INSERT INTO `contratos_trabajador` VALUES (2,12,16,'PLAZO_FIJO','2025-12-01','2026-06-01','2026-05-25','COMPLETA',2700.00,'VIGENTE','https://drive.google.com/file/d/12dCWofLHnauJshNm1X7v1a4xgVNIDICR/view?usp=drivesdk','','','','','','','','2025-12-11 11:02:10','2025-12-16 11:35:05'),(3,14,23,'PLAZO_FIJO','2025-11-15','2026-02-15','2026-02-10','COMPLETA',1500.00,'VIGENTE','https://drive.google.com/file/d/1tHdC3rT10kBzioNTyNzY-fxis06ALPM-/view?usp=drivesdk','','','','','','','','2025-12-11 11:05:36','2025-12-16 11:35:05'),(4,15,14,'PLAZO_FIJO','2025-12-01','2026-03-01','2026-02-25','COMPLETA',1130.00,'VIGENTE','https://drive.google.com/file/d/1MBYSNTe97SZLIsMZGY0mi_AXc82kpeeK/view?usp=drivesdk','','','','','','','','2025-12-11 11:08:51','2025-12-16 11:35:05'),(5,10,20,'PLAZO_FIJO','2025-12-01','2025-06-01','2026-05-25','COMPLETA',1500.00,'VENCIDO','https://drive.google.com/file/d/1XvU0MoWAUWGj6Pb6Qn7uby4wEBrLBicf/view?usp=drivesdk','','','','','','','','2025-12-11 11:11:17','2025-12-22 10:32:14'),(6,9,20,'PLAZO_FIJO','2025-12-01','2026-06-01','2026-05-25','COMPLETA',1500.00,'VIGENTE','https://drive.google.com/file/d/1WjOdsN4rBhq2dBmni68VyjOdcUxUN-sT/view?usp=drivesdk','','','','','','','','2025-12-11 11:13:38','2025-12-16 11:35:05'),(7,11,20,'PLAZO_FIJO','2025-10-13','2026-04-13','2026-04-05','COMPLETA',1900.00,'VIGENTE','https://drive.google.com/file/d/1xxXpzruR94rnJEcEVxYYGdsgCPFa6EwL/view?usp=drivesdk','','','','','','','','2025-12-11 11:19:37','2025-12-16 11:35:05'),(9,8,3,'PLAZO_FIJO','2025-08-08','2026-02-08','2026-02-02','COMPLETA',1300.00,'VIGENTE','https://drive.google.com/file/d/1TodTq9Bxwq0Pd2kowU68Rjy8dF-8nnXm/view?usp=drivesdk','','','','','','','','2025-12-11 11:24:03','2025-12-16 11:35:05'),(10,5,2,'PLAZO_FIJO','2025-08-01','2026-02-01','2026-01-25','COMPLETA',1700.00,'VIGENTE','https://drive.google.com/file/d/1hIKQkU2X_fzaFPtvLkNg4Cjk64sSk8ad/view?usp=drivesdk','','','','','','','','2025-12-11 11:31:13','2025-12-16 11:35:05'),(11,1,18,'PLAZO_FIJO','2025-10-01','2026-04-01','2026-03-27','COMPLETA',1600.00,'VIGENTE','https://drive.google.com/file/d/1kcJ3Sm4qbiGC1SoDwF3TlDdjItl9F-DE/view?usp=drivesdk','','','','','','','','2025-12-11 11:33:20','2025-12-16 11:35:05'),(12,13,22,'PLAZO_FIJO','2025-10-01','2026-04-01','2026-03-27','COMPLETA',2100.00,'VIGENTE','https://drive.google.com/file/d/1BP3kIFIBI7VvJ7z8pmOtlVEVNXpxt6ug/view?usp=drivesdk','','','','','','','','2025-12-11 11:37:49','2025-12-16 11:35:05'),(13,6,3,'PLAZO_FIJO','2025-07-01','2026-01-01','2025-12-27','COMPLETA',2200.00,'VIGENTE','https://drive.google.com/file/d/10OcULm1NHm9Dp3SdFs_3q5pIMmSigjqT/view?usp=drivesdk','','','','','','','','2025-12-11 11:39:36','2025-12-16 11:35:05');

--
-- Table structure for table `control_diario`
--

CREATE TABLE `control_diario` (
  `id` int NOT NULL AUTO_INCREMENT,
  `usuario_id` int NOT NULL,
  `nombre` varchar(100) NOT NULL DEFAULT 'CONTROL DIARIO',
  `fecha` date NOT NULL,
  `columnas` longtext NOT NULL,
  `filas` longtext NOT NULL,
  `anchos` text,
  `creado_en` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `actualizado_en` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `idx_control_usuario_fecha` (`usuario_id`,`fecha`),
  CONSTRAINT `fk_control_diario_usuario` FOREIGN KEY (`usuario_id`) REFERENCES `usuarios` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `control_diario`
--

INSERT INTO `control_diario` VALUES (1,1,'CONTROL DIARIO','2025-11-27','[\"Columna 12222\",\"Columna 2\",\"Columna 3\",\"Columna 4\",\"Columna 5\",\"Columna 6\",\"Columna 7\",\"Columna 8\",\"Columna 9\",\"Columna 10\",\"Columna 11\",\"Columna 12\",\"Columna 13\",\"Columna 14\",\"Columna 15\",\"Columna 16\"]','[[\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\"],[\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\"],[\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\"],[\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\"],[\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\"],[\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\"],[\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\"],[\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\"],[\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\"],[\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\"],[\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\"],[\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\"],[\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\"],[\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\"],[\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\"],[\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\"]]','[150,150,72,150,150,150,150,150,150,150,150,150,150,150,150,150]','2025-11-26 15:08:23','2025-11-27 11:50:43'),(2,9,'CONTROL DIARIO','2025-11-27','[\"FECHA\",\"PESO (kg)\",\"CINTURA (cm)\",\"IMC (si lo calculas)\",\"PRESIÓN SISTÓLICA (mmHg)\",\"PRESIÓN DIASTÓLICA (mmHg)\",\"GRECUENCIA CARDIACA (lpm)\",\"GLUCOSA EN AYUNAS (mg\\/dL)\",\"DOLOR ZONA HÍGADO 0-10\",\"HINCHAZON ABDOMEN (S\\/N)\",\"NÁUSEAS \\/ MALESTAR DIGESTIVO (S\\/N)\",\"CONSUMO ALCOHOL (S\\/N)\",\"DIETA RESPETADA HOY (1-5)\",\"ACTIVIDAD FÍSICA (TIPO Y MINUTOS)\",\"HORAS DE SUEÑO\",\"ÁNIMO \\/ ENERGÍA (1-5)\",\"OBSERVACIONES\"]','[[\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\"]]','[114,138,175,195,282,292,297,290,279,283,362,267,285,348,202,237,193]','2025-11-27 03:01:37','2025-11-27 03:08:59'),(3,11,'CONTROL DIARIO','2025-11-27','[\"FECHA\",\"PESO (kg)\",\"CINTURA (cm)\",\"IMC (si lo calculas)\",\"PRESIÓN SISTÓLICA (mmHg)\",\"PRESIÓN DIASTÓLICA (mmHg)\",\"GRECUENCIA CARDIACA (lpm)\",\"GLUCOSA EN AYUNAS (mg\\/dL)\",\"DOLOR ZONA HÍGADO 0-10\",\"HINCHAZON ABDOMEN (S\\/N)\",\"NÁUSEAS \\/ MALESTAR DIGESTIVO (S\\/N)\",\"CONSUMO ALCOHOL (S\\/N)\",\"DIETA RESPETADA HOY (1-5)\",\"ACTIVIDAD FÍSICA (TIPO Y MINUTOS)\",\"HORAS DE SUEÑO\",\"ÁNIMO \\/ ENERGÍA (1-5)\",\"OBSERVACIONES\"]','[[\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\"]]','[114,138,175,195,282,292,297,290,279,283,362,267,285,348,202,237,193]','2025-11-27 08:01:37','2025-11-27 08:08:59');

--
-- Table structure for table `control_laboratorios`
--

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

--
-- Dumping data for table `control_laboratorios`
--

INSERT INTO `control_laboratorios` VALUES (1,9,'LABORATORIOS','2025-11-27','[\"FECHA (AAAA-MM-DD)\",\"TIPO DE EXAMEN\",\"ALT \\/ TGP (U\\/L)\",\"AST \\/ TGO (U\\/L)\",\"GGT (U\\/L)\",\"FOSFATASA ALCALINA (U\\/L)\",\"BILIRRUBINA TOTAL (MG\\/DL)\",\"BILIRRUBINA DIRECTA (MG\\/DL)\",\"GLUCOSA (MG\\/DL)\",\"HbA1c (%)\",\"ISULINA (uU\\/mL)\",\"COLESTEROL TOTAL (mg\\/dL)\",\"HDL (mg\\/dL)\",\"LDL (mg\\/dL)\",\"TRIGLICÉRIDOS (mg\\/dL)\",\"ÁCIDO ÚRICO (mg\\/dL)\",\"CREATININA (mg\\/dL)\",\"OTROS RESULTADOS RELEVANTES\",\"MÉDICO QUE LO SOLICITO\",\"ENLACE \\/ UBICACION DEL ARCHIVO\"]','[[\"\\n\",\"\\n\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\"]]','[239,198,178,185,150,273,282,296,215,145,192,278,150,150,237,229,224,334,260,337]','2025-11-27 02:27:05','2025-11-27 02:51:59'),(2,11,'LABORATORIOS','2025-11-27','[\"FECHA (AAAA-MM-DD)\",\"TIPO DE EXAMEN\",\"ALT \\/ TGP (U\\/L)\",\"AST \\/ TGO (U\\/L)\",\"GGT (U\\/L)\",\"FOSFATASA ALCALINA (U\\/L)\",\"BILIRRUBINA TOTAL (MG\\/DL)\",\"BILIRRUBINA DIRECTA (MG\\/DL)\",\"GLUCOSA (MG\\/DL)\",\"HbA1c (%)\",\"ISULINA (uU\\/mL)\",\"COLESTEROL TOTAL (mg\\/dL)\",\"HDL (mg\\/dL)\",\"LDL (mg\\/dL)\",\"TRIGLICÉRIDOS (mg\\/dL)\",\"ÁCIDO ÚRICO (mg\\/dL)\",\"CREATININA (mg\\/dL)\",\"OTROS RESULTADOS RELEVANTES\",\"MÉDICO QUE LO SOLICITO\",\"ENLACE \\/ UBICACION DEL ARCHIVO\"]','[[\"\\n\",\"\\n\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\"]]','[239,198,178,185,150,273,282,296,215,145,192,278,150,150,237,229,224,334,260,337]','2025-11-27 07:27:05','2025-11-27 07:51:59');

--
-- Table structure for table `correo_cuenta`
--

CREATE TABLE `correo_cuenta` (
  `id` int NOT NULL AUTO_INCREMENT,
  `suscripcion_id` int NOT NULL,
  `email` varchar(190) NOT NULL,
  `nombre` varchar(150) DEFAULT NULL,
  `estado` enum('ACTIVO','SUSPENDIDO','ELIMINADO') DEFAULT 'ACTIVO',
  `alias_json` json DEFAULT NULL,
  `creado_en` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_correo_email` (`email`),
  KEY `fk_cor_sus` (`suscripcion_id`),
  CONSTRAINT `fk_cor_sus` FOREIGN KEY (`suscripcion_id`) REFERENCES `suscripcion` (`suscripcion_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `correo_cuenta`
--


--
-- Table structure for table `cumpleanos`
--

CREATE TABLE `cumpleanos` (
  `id` int NOT NULL AUTO_INCREMENT,
  `usuario_id` int DEFAULT NULL,
  `nombre` varchar(120) NOT NULL,
  `fecha_nac` date NOT NULL,
  `color` varchar(20) DEFAULT '#17a2b8',
  `notas` varchar(255) DEFAULT NULL,
  `created_by` int NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `usuario_id` (`usuario_id`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `cumpleanos`
--

INSERT INTO `cumpleanos` VALUES (3,1,'SOFIA CAJAHUAMAN','2000-08-30','#f6c23e','',9,'2025-08-19 17:47:27'),(4,19,'Natividad Ochoa','2000-09-09','#f6c23e','',9,'2025-08-19 17:47:47'),(5,13,'Carlos Silva','2000-09-14','#f6c23e','',9,'2025-08-19 17:48:09'),(6,14,'ARIANA SIESQUEN','2000-09-22','#f6c23e','',9,'2025-08-19 17:48:25'),(7,15,'Antuanet Mozo','2000-01-10','#f6c23e','',9,'2025-08-19 17:49:54'),(8,11,'Nayumi Vara','2000-01-14','#f6c23e','',9,'2025-08-19 17:50:08'),(9,22,'MARIA ROSARIO','2000-01-11','#f6c23e','',9,'2025-08-19 18:00:07'),(10,18,'Thania Escalante','2000-02-27','#f6c23e','',9,'2025-08-19 18:00:32'),(11,12,'BRENDA BAZALAR','2000-02-28','#f6c23e','',9,'2025-08-19 18:00:45'),(12,16,'Enma Alan','2000-03-30','#f6c23e','',9,'2025-08-20 11:06:06'),(13,9,'GRIMALDO VARA','2000-04-03','#f6c23e','',9,'2025-08-20 11:06:43'),(14,20,'Genobeba Pillaca','2000-04-14','#f6c23e','',9,'2025-08-20 11:07:01'),(15,21,'STEPHANY ORTIZ','2000-06-29','#f6c23e','',9,'2025-08-20 11:07:23');

--
-- Table structure for table `dispositivo_area_hist`
--

CREATE TABLE `dispositivo_area_hist` (
  `mov_id` int NOT NULL AUTO_INCREMENT,
  `dispositivo_id` int NOT NULL,
  `area_id_anterior` int DEFAULT NULL,
  `area_id_nueva` int DEFAULT NULL,
  `motivo` varchar(120) DEFAULT NULL,
  `notas` varchar(255) DEFAULT NULL,
  `fecha_mov` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `usuario_id` int DEFAULT NULL,
  PRIMARY KEY (`mov_id`),
  KEY `dispositivo_id` (`dispositivo_id`),
  KEY `area_id_nueva` (`area_id_nueva`),
  KEY `fecha_mov` (`fecha_mov`),
  KEY `fk_mov_area1` (`area_id_anterior`),
  CONSTRAINT `fk_mov_area1` FOREIGN KEY (`area_id_anterior`) REFERENCES `areas` (`area_id`),
  CONSTRAINT `fk_mov_area2` FOREIGN KEY (`area_id_nueva`) REFERENCES `areas` (`area_id`),
  CONSTRAINT `fk_mov_disp` FOREIGN KEY (`dispositivo_id`) REFERENCES `dispositivos` (`dispositivo_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `dispositivo_area_hist`
--

INSERT INTO `dispositivo_area_hist` VALUES (1,2,NULL,19,'REORGANIZACION','','2025-10-13 09:59:07',1),(2,2,19,17,'','','2025-10-14 07:36:34',1);

--
-- Table structure for table `dispositivo_comprobante`
--

CREATE TABLE `dispositivo_comprobante` (
  `id` int NOT NULL AUTO_INCREMENT,
  `dispositivo_id` int NOT NULL,
  `costo_item` decimal(12,2) DEFAULT NULL,
  `notas` varchar(160) DEFAULT NULL,
  `archivo_path` varchar(255) NOT NULL,
  `creado_por` int DEFAULT NULL,
  `creado_en` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `idx_disp` (`dispositivo_id`),
  CONSTRAINT `fk_dc_disp` FOREIGN KEY (`dispositivo_id`) REFERENCES `dispositivos` (`dispositivo_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `dispositivo_comprobante`
--

INSERT INTO `dispositivo_comprobante` VALUES (5,5,73.50,'P','uploads/disp/5/20251015_170404_FI39-31151.pdf',1,'2025-10-15 12:04:04');

--
-- Table structure for table `dispositivo_sede_hist`
--

CREATE TABLE `dispositivo_sede_hist` (
  `mov_id` int NOT NULL AUTO_INCREMENT,
  `dispositivo_id` int NOT NULL,
  `sede_id_anterior` int DEFAULT NULL,
  `sede_id_nueva` int NOT NULL,
  `motivo` varchar(120) DEFAULT NULL,
  `notas` varchar(255) DEFAULT NULL,
  `fecha_mov` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `usuario_id` int DEFAULT NULL,
  PRIMARY KEY (`mov_id`),
  KEY `idx_dsh_disp` (`dispositivo_id`),
  KEY `fk_dsh_sede_new` (`sede_id_nueva`),
  KEY `fk_dsh_sede_old` (`sede_id_anterior`),
  CONSTRAINT `fk_dsh_disp` FOREIGN KEY (`dispositivo_id`) REFERENCES `dispositivos` (`dispositivo_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `fk_dsh_sede_new` FOREIGN KEY (`sede_id_nueva`) REFERENCES `sedes` (`sede_id`) ON DELETE RESTRICT ON UPDATE CASCADE,
  CONSTRAINT `fk_dsh_sede_old` FOREIGN KEY (`sede_id_anterior`) REFERENCES `sedes` (`sede_id`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `dispositivo_sede_hist`
--

INSERT INTO `dispositivo_sede_hist` VALUES (1,4,2,5,'REORGANIZACION','','2025-10-15 09:22:03',1),(2,4,5,2,'REORGANIZACION','','2025-10-15 09:22:30',1),(3,5,2,5,'','P','2025-10-16 08:09:00',1),(4,5,5,2,'','','2025-10-16 08:09:37',1);

--
-- Table structure for table `dispositivos`
--

CREATE TABLE `dispositivos` (
  `dispositivo_id` int NOT NULL AUTO_INCREMENT,
  `codigo_interno` varchar(50) NOT NULL,
  `hostname` varchar(100) DEFAULT NULL,
  `tipo` enum('PC','LAPTOP','SERVIDOR','IMPRESORA','MONITOR','TECLADO','MOUSE','OTRO') CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT 'PC',
  `marca` varchar(80) DEFAULT NULL,
  `modelo` varchar(80) DEFAULT NULL,
  `numero_serie` varchar(120) DEFAULT NULL,
  `estado` enum('OPERATIVO','REPARACION','RESERVA','BAJA') NOT NULL DEFAULT 'OPERATIVO',
  `area_id` int DEFAULT NULL,
  `sede_id` int DEFAULT NULL,
  `empresa_id` int DEFAULT NULL,
  `so` varchar(120) DEFAULT NULL,
  `so_version` varchar(60) DEFAULT NULL,
  `cpu_modelo` varchar(120) DEFAULT NULL,
  `ram_gb` decimal(6,2) DEFAULT NULL,
  `almacenamiento` varchar(120) DEFAULT NULL,
  `ip` varchar(45) DEFAULT NULL,
  `mac` varchar(50) DEFAULT NULL,
  `fecha_compra` date DEFAULT NULL,
  `proveedor` varchar(120) DEFAULT NULL,
  `costo` decimal(12,2) DEFAULT NULL,
  `garantia_fin` date DEFAULT NULL,
  `notas` text,
  `fecha_alta` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `fecha_baja` datetime DEFAULT NULL,
  PRIMARY KEY (`dispositivo_id`),
  UNIQUE KEY `codigo_interno` (`codigo_interno`),
  UNIQUE KEY `uk_codigo_interno` (`codigo_interno`),
  KEY `area_id` (`area_id`),
  KEY `estado` (`estado`),
  KEY `tipo` (`tipo`),
  KEY `idx_disp_sede` (`sede_id`),
  KEY `idx_disp_empresa` (`empresa_id`),
  CONSTRAINT `fk_disp_empresa` FOREIGN KEY (`empresa_id`) REFERENCES `empresas` (`empresa_id`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `fk_disp_sede` FOREIGN KEY (`sede_id`) REFERENCES `sedes` (`sede_id`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `fk_dispo_area` FOREIGN KEY (`area_id`) REFERENCES `areas` (`area_id`)
) ENGINE=InnoDB AUTO_INCREMENT=90 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `dispositivos`
--

INSERT INTO `dispositivos` VALUES (2,'JM2-W1-PC-0001','DESKTOP-JHLN457','PC','HP','PRO DESK 600 G3 MINI','8CG75239CP','OPERATIVO',19,2,1,'WINDOWS 10 PRO','22H2','COREi7-6700T',16.00,'477 SSD','192.168.1.38','AC-E2-D3-14-6B-E6','2025-10-07','0',800.00,'2026-04-07','','2025-10-13 09:57:47',NULL),(3,'JM2-P-LAPTOP-0001','LAPTOP-HPV65LP3','LAPTOP','HP','15-DY2503LA','5CD223DJ55','OPERATIVO',2,2,1,'Windows 11 Home Single Language','24H2','COREi5-11',8.00,'477','192.168.1.100','3C-55-76-86-97-D3','2025-03-05','',2000.00,'2026-03-13','','2025-10-13 10:15:48',NULL),(4,'JM2-W1-TECLADO-0001','','TECLADO','LOGITECH','K235','-','OPERATIVO',19,2,1,'','','',NULL,'','','','2025-10-07','0',73.50,'2026-10-07','','2025-10-15 08:56:55',NULL),(5,'JM2-W1-MOUSE-0001','','MOUSE','LOGITECH','M170','2516ZEHRKD8','OPERATIVO',19,2,1,'','','',NULL,'','','','2025-10-07','0',73.50,'2026-10-07','','2025-10-15 09:09:23',NULL),(6,'JM2-W1-MONITOR-0001','','MONITOR','LENOVO 22\"','THINVISION T22i - 10','V5HP9479','OPERATIVO',19,2,NULL,'','','',NULL,'','','',NULL,'0',NULL,NULL,'','2025-11-17 08:00:20',NULL),(7,'JM2-W1-MONITOR-0002','','MONITOR','LENOVO 22\"','THINVISION T22i - 10','V5HR0662','OPERATIVO',19,2,NULL,'','','',NULL,'','','',NULL,'0',NULL,NULL,'','2025-11-17 08:01:29',NULL),(8,'JM2-W2-MOUSE-0001','','MOUSE','LOGITECH','M170','2503ZE1764V8','OPERATIVO',15,2,NULL,'','','',NULL,'','','',NULL,'',NULL,NULL,'','2025-11-17 09:06:19',NULL),(9,'JM2-W2-TECLADO-0001','','TECLADO','LOGITECH','K235','-','OPERATIVO',15,2,NULL,'','','',NULL,'','','',NULL,'',NULL,NULL,'','2025-11-17 09:07:32',NULL),(10,'JM2-W2-PC-0001','DESKTOP-M30AIS4','PC','HP','PRO DESK 600 G3 MINI','8CG75239Z5','OPERATIVO',15,2,NULL,'WINDOWS 10 PRO','22H2','COREi7-6700T',16.00,'477 SSD','192.168.1.40','AC-E2-D3-14-6D-07',NULL,'',NULL,NULL,'','2025-11-17 09:12:49',NULL),(11,'JM2-W2-MONITOR-0001','','MONITOR','LENOVO 22\"','THINVISION T22i - 10','V5HH1929','OPERATIVO',15,2,NULL,'','','',NULL,'','','',NULL,'',NULL,NULL,'','2025-11-17 09:19:32',NULL),(12,'JM2-W2-MONITOR-0002','','MONITOR','LENOVO 22\"','THINVISION T22i - 10','V5FX2320','OPERATIVO',15,2,NULL,'','','',NULL,'','','',NULL,'',NULL,NULL,'','2025-11-17 09:20:41',NULL),(13,'JM2-W3-PC-0001','DESKTOP-T0SRSFC','PC','HP','PRO DESK 600 G3 MINI','8CG752394L','OPERATIVO',28,2,NULL,'WINDOWS 10 PRO','2009','COREi7-6700T',16.00,'477 SSD','192.168.1.42','AC-E2-D3-14-6C-1A',NULL,'',NULL,NULL,'','2025-11-17 09:29:39',NULL),(14,'JM2-W3-MONITOR-0001','','MONITOR','LENOVO 22\"','THINKVISION T22i - 10','V5HR1057','OPERATIVO',28,2,NULL,'','','',NULL,'','','',NULL,'',NULL,NULL,'','2025-11-17 09:34:02',NULL),(15,'JM2-W3-MONITOR-0002','','MONITOR','LENOVO 22\"','THINKVISION T22i - 10','V5FX2373','OPERATIVO',28,2,NULL,'','','',NULL,'','','',NULL,'',NULL,NULL,'','2025-11-17 09:34:57',NULL),(16,'JM2-W3-TECLADO-0001','','TECLADO','LOGITECH','K235','-','OPERATIVO',28,2,NULL,'','','',NULL,'','','',NULL,'',NULL,NULL,'','2025-11-17 09:38:13',NULL),(17,'JM2-W3-MOUSE-0001','','MOUSE','LOGITECH','M170','2347LZX1MSE8','OPERATIVO',28,2,NULL,'','','',NULL,'','','',NULL,'',NULL,NULL,'','2025-11-17 09:38:59',NULL),(18,'JM2-T1-PC-0001','DESKTOP-L7GLJ4L','PC','HP','PRO DESK 600 G3 MINI','8CG750541R','OPERATIVO',21,2,NULL,'WINDOWS 10 PRO','22H2','COREi7-6700T',16.00,'477 SSD','192.168.1.13','AC-E2-D3-11-8D-14',NULL,'',NULL,NULL,'','2025-11-17 12:00:24',NULL),(19,'JM2-T1-MONITOR-0001','','MONITOR','LENOVO 22\"','THINKVISION T22i - 10','V5HH2274','OPERATIVO',21,2,NULL,'','','',NULL,'','','',NULL,'',NULL,NULL,'','2025-11-17 12:02:19',NULL),(20,'JM2-T1-MONITOR-0002','','MONITOR','LENOVO 22\"','THINKVISION T22i - 10','V5GW1080','OPERATIVO',21,2,NULL,'','','',NULL,'','','',NULL,'',NULL,NULL,'','2025-11-17 12:03:14',NULL),(21,'JM2-T1-TECLADO-0001','','TECLADO','LOGITECH','K235','-','OPERATIVO',21,2,NULL,'','','',NULL,'','','',NULL,'',NULL,NULL,'','2025-11-17 12:04:17',NULL),(22,'JM2-T1-MOUSE-0001','','MOUSE','LOGITECH','M170','2503ZE776VG82','OPERATIVO',21,2,NULL,'','','',NULL,'','','',NULL,'',NULL,NULL,'','2025-11-17 12:07:26',NULL),(23,'JM2-S-PC-0001','DESKTOP-HVQV6M1','PC','HP','PRO DESK 600 G3 MINI','8CG7523B9Y','OPERATIVO',25,2,NULL,'WINDOWS 10 PRO','22H2','COREi7-6700T',16.00,'477 SSD','192.168.1.41','AC-E2-D3-14-6B-F5',NULL,'',NULL,NULL,'','2025-11-17 12:46:43',NULL),(24,'JM2-S-MONITOR-0001','','MONITOR','HP','Z22 G2','6CM83129DJ','OPERATIVO',25,2,NULL,'','','',NULL,'','','',NULL,'',NULL,NULL,'','2025-11-17 12:51:45',NULL),(25,'JM2-S-MONITOR-0002','','MONITOR','HP','Z22 G2','6CM92600VJ','OPERATIVO',25,2,NULL,'','','',NULL,'','','',NULL,'',NULL,NULL,'','2025-11-17 12:52:52',NULL),(26,'JM2-S-TECLADO-0001','','TECLADO','LOGITECH','K235','-','OPERATIVO',25,2,NULL,'','','',NULL,'','','',NULL,'',NULL,NULL,'','2025-11-17 12:54:09',NULL),(27,'JM2-S-MOUSE-0001','','MOUSE','LOGITECH','M170','2516ZE7RJ208','OPERATIVO',25,2,NULL,'','','',NULL,'','','',NULL,'',NULL,NULL,'','2025-11-17 12:54:53',NULL),(28,'JM2-S-LAPTOP-0001','LAPTOP-4HDHGHCG','LAPTOP','HP','15-FD02571A','5CD53094TC','OPERATIVO',25,2,NULL,'WINDOWS 11 HOME SINGLE LANGUAJE','25H2','COREI5-12U',16.00,'447 SSD','192.168.0.103','50-BB-B5-AE-D8-D8',NULL,'0',NULL,NULL,'','2025-11-17 12:59:23',NULL),(29,'JM2-C-LAPTOP-0001','DESKTOP-VV2007N','LAPTOP','ACER','V3-472','NXMMZAA005422AFE7600','REPARACION',3,2,NULL,'WINDOWS 10 HOME','22H2','COREi3-4030U',8.00,'224 SSD','192.168.0.106','B0-10-41-94-CB-A9',NULL,'',NULL,NULL,'','2025-11-18 06:40:31',NULL),(30,'JM3-W1-PC-0001','DESKTOP-JIPGN8G','PC','HP','PRO DESK 600 G3 MINI','','OPERATIVO',19,5,1,'WINDOWS 10 PRO','22H2','COREI7-9700T',32.00,'477 SSD','192.168.18.236','38-22-E2-1A-7C-5E',NULL,'0',NULL,NULL,'','2025-11-18 07:13:40',NULL),(31,'JM3-W1-TECLADO-0001','','TECLADO','LOGITECH','K235','-','OPERATIVO',19,5,NULL,'','','',NULL,'','','',NULL,'0',NULL,NULL,'','2025-11-18 07:14:32',NULL),(32,'JM3-W1-MOUSE-0001','','MOUSE','LOGITECH','M170','2516ZE6RJ1Q8','OPERATIVO',19,5,NULL,'','','',NULL,'','','',NULL,'',NULL,NULL,'','2025-11-18 07:17:35',NULL),(33,'JM3-W1-MONITOR-0001','','MONITOR','LENOVO 22\"','THINKVISION T22i - 10','-','OPERATIVO',19,5,NULL,'','','',NULL,'','','',NULL,'',NULL,NULL,'','2025-11-18 07:18:21',NULL),(34,'JM3-W1-MONITOR-0002','','MONITOR','LENOVO 22\"','THINKVISION T22i - 10','-','OPERATIVO',19,5,NULL,'','','',NULL,'','','',NULL,'',NULL,NULL,'','2025-11-18 07:18:53',NULL),(35,'JM3-W1-MONITOR-0003','','MONITOR','LENOVO','T 1714PA','-','OPERATIVO',19,5,NULL,'','','',NULL,'','','',NULL,'',NULL,NULL,'','2025-11-18 07:20:14',NULL),(36,'JM3-W2-PC-0001','DESKTOP-JIPGN8G','PC','HP','RO DESK 600 G5 MINI','-','OPERATIVO',15,5,NULL,'WINDOWS 11 PRO','25H2','COREI7-9700T',32.00,'477 SSD','192.168.18.235','38-22-E2-1A-8B-62',NULL,'',NULL,NULL,'','2025-11-18 07:28:55',NULL),(37,'JM3-W2-TECLADO-0001','','TECLADO','LOGITECH','K235','-','OPERATIVO',15,5,NULL,'','','',NULL,'','','',NULL,'',NULL,NULL,'','2025-11-18 07:29:35',NULL),(38,'JM3-W2-MOUSE-0001','','MOUSE','LOGITECH','M170','2347LZX1P1G8','OPERATIVO',15,5,NULL,'','','',NULL,'','','',NULL,'',NULL,NULL,'','2025-11-18 07:30:11',NULL),(39,'JM3-W2-MONITOR-0001','','MONITOR','VIEWSONIC','VA1716WSERIES','-','OPERATIVO',15,5,NULL,'','','',NULL,'','','',NULL,'',NULL,NULL,'','2025-11-18 07:31:04',NULL),(40,'JM3-W2-MONITOR-0002','','MONITOR','HYUNDAI','L197 WIDE','-','OPERATIVO',15,5,NULL,'','','',NULL,'','','',NULL,'',NULL,NULL,'','2025-11-18 07:31:38',NULL),(41,'JM3-W2-MONITOR-0003','','MONITOR','LENOVO','THINKVISION','-','OPERATIVO',15,5,NULL,'','','',NULL,'','','',NULL,'',NULL,NULL,'','2025-11-18 07:32:09',NULL),(42,'JM3-V2-PC-0001','DESKTOP-3NEV905','PC','ANTRYX','H110','-','OPERATIVO',14,5,NULL,'WINDOWS 10 PRO','22H2','COREI3-7100',12.00,'466 HDD','192.168.18.165','00-E0-4C-A3-06-53',NULL,'',NULL,NULL,'','2025-11-18 07:41:06',NULL),(43,'JM3-V2-MONITOR-0001','','MONITOR','LENOVO 22\"','THINKVISION T22i - 10','-','OPERATIVO',14,5,NULL,'','','',NULL,'','','',NULL,'',NULL,NULL,'','2025-11-18 07:41:40',NULL),(44,'JM3-V2-TECLADO-0001','','TECLADO','LOGITECH','K235','-','OPERATIVO',14,5,NULL,'','','',NULL,'','','',NULL,'',NULL,NULL,'','2025-11-18 07:42:04',NULL),(45,'JM3-V2-MOUSE-0001','','MOUSE','LOGITECH','M170','2146LZD06MM8','OPERATIVO',14,5,NULL,'','','',NULL,'','','',NULL,'',NULL,NULL,'','2025-11-18 07:42:37',NULL),(46,'JM3-V1-PC-0001','KAIZEN2','PC','ANTRYX','-','-','OPERATIVO',13,5,NULL,'WINDOWS 10 PRO','22H2','COREI3-4150',8.00,'112 SSD','192.168.18.13','14-DD-A9-DC-80-27',NULL,'',NULL,NULL,'','2025-11-18 07:50:03',NULL),(47,'JM3-V1-MONITOR-0001','','MONITOR','LENOVO 22\"','THINKVISION T22i - 10','-','OPERATIVO',13,5,NULL,'','','',NULL,'','','',NULL,'',NULL,NULL,'','2025-11-18 07:50:31',NULL),(48,'JM3-V1-TECLADO-0001','','TECLADO','LOGITECH','K235','-','OPERATIVO',13,5,NULL,'','','',NULL,'','','',NULL,'',NULL,NULL,'','2025-11-18 07:51:18',NULL),(49,'JM3-V1-MOUSE-0001','','MOUSE','LOGITECH','M170','2327LZXEK4K8','OPERATIVO',13,5,NULL,'','','',NULL,'','','',NULL,'',NULL,NULL,'','2025-11-18 07:51:51',NULL),(50,'JM3-A-PC-0001','DESKTOP-OB5B9K5','PC','AZUS','B85M-D3H','-','OPERATIVO',18,5,NULL,'WINDOWS 10 HOME','22H2','COREI5-4460',4.00,'224 SSD','192.168.18.10','74-D4-35-8D-69-AE',NULL,'',NULL,NULL,'','2025-11-18 07:56:54',NULL),(51,'JM3-A-MONITOR-0001','','MONITOR','HP','S1933','-','OPERATIVO',18,5,NULL,'','','',NULL,'','','',NULL,'',NULL,NULL,'','2025-11-18 07:57:43',NULL),(52,'JM3-A-MONITOR-0002','','MONITOR','LENOVO','THINKVISION','-','OPERATIVO',18,5,NULL,'','','',NULL,'','','',NULL,'',NULL,NULL,'','2025-11-18 07:58:15',NULL),(53,'JM3-A-MONITOR-0003','','MONITOR','SAMSUNG','S19D300','-','OPERATIVO',18,5,NULL,'','','',NULL,'','','',NULL,'',NULL,NULL,'','2025-11-18 07:58:43',NULL),(54,'JM3-A-TECLADO-0001','','TECLADO','LOGITECH','K235','-','OPERATIVO',18,5,NULL,'','','',NULL,'','','',NULL,'',NULL,NULL,'','2025-11-18 07:59:02',NULL),(55,'JM3-A-MOUSE-0001','','MOUSE','LOGITECH','M170','2347LZX1R088','OPERATIVO',18,5,NULL,'','','',NULL,'','','',NULL,'',NULL,NULL,'','2025-11-18 07:59:30',NULL),(56,'JM3-V3-PC-0001','DESKTOP-3LMMO3A','PC','DVD','-','-','OPERATIVO',26,5,NULL,'WINDOWS 10 HOME','22H2','AMD A8-9600',12.00,'447 SSD','192.168.18.14','88-D7-F6-C6-15-73',NULL,'',NULL,NULL,'','2025-11-18 08:05:09',NULL),(57,'JM3-V3-MONITOR-0001','','MONITOR','HP','Z22 G2','-','OPERATIVO',26,5,NULL,'','','',NULL,'','','',NULL,'',NULL,NULL,'','2025-11-18 08:06:05',NULL),(58,'JM3-V3-MONITOR-0002','','MONITOR','HP','Z22 G2','-','OPERATIVO',26,5,NULL,'','','',NULL,'','','',NULL,'',NULL,NULL,'','2025-11-18 08:06:23',NULL),(59,'JM3-V3-MONITOR-0003','','MONITOR','BENQ','L1753T','-','OPERATIVO',26,5,NULL,'','','',NULL,'','','',NULL,'',NULL,NULL,'','2025-11-18 08:06:45',NULL),(60,'JM3-V3-TECLADO-0001','','TECLADO','LOGITECH','K235','-','OPERATIVO',26,5,NULL,'','','',NULL,'','','',NULL,'',NULL,NULL,'','2025-11-18 08:07:09',NULL),(61,'JM3-V3-MOUSE-0001','','MOUSE','LOGITECH','M170','2149LZD67VK8','OPERATIVO',26,5,NULL,'','','',NULL,'','','',NULL,'',NULL,NULL,'','2025-11-18 08:07:41',NULL),(62,'JM3-F-PC-0001','DESKTOP-UBA0MO2','PC','DELUXE','TOBE FILLED BY OEM','-','OPERATIVO',16,5,NULL,'WINDOWS 10 PRO','22H2','CORE2 QUAD Q8200',6.00,'116 SSD','192.168.18.83','0-E0-4D-6C-57-C1',NULL,'',NULL,NULL,'','2025-11-18 08:13:06',NULL),(63,'JM3-F-MONITOR-0001','','MONITOR','LG','LED','-','OPERATIVO',16,5,NULL,'','','',NULL,'','','',NULL,'',NULL,NULL,'','2025-11-18 08:13:47',NULL),(64,'JM3-F-MONITOR-0002','','MONITOR','SAMSUNG','S19D300','-','OPERATIVO',16,5,NULL,'','','',NULL,'','','',NULL,'',NULL,NULL,'','2025-11-18 08:14:15',NULL),(65,'JM3-F-MONITOR-0003','','MONITOR','SAMSUNG','S17','-','OPERATIVO',16,5,NULL,'','','',NULL,'','','',NULL,'',NULL,NULL,'','2025-11-18 08:14:52',NULL),(66,'JM3-F-TECLADO-0001','','TECLADO','LOGITECH','K235','-','OPERATIVO',16,5,NULL,'','','',NULL,'','','',NULL,'',NULL,NULL,'','2025-11-18 08:15:14',NULL),(67,'JM3-F-MOUSE-0001','','MOUSE','LOGITECH','M170','2149LZD68HL8','OPERATIVO',16,5,NULL,'','','',NULL,'','','',NULL,'',NULL,NULL,'','2025-11-18 08:15:54',NULL),(68,'JM3-C-PC-0001','DESKTOP-Q1O4JP8','PC','AZUS','','-','OPERATIVO',3,5,NULL,'WINDOWS 10 HOME','22H2','COREI5-3470',8.00,'224 SSD','192.168.18.40','4C-72-B9-21-5E-A2',NULL,'',NULL,NULL,'','2025-11-18 08:21:56',NULL),(69,'JM3-C-MONITOR-0001','','MONITOR','LG','FLATRON W1943SB','-','OPERATIVO',3,5,NULL,'','','',NULL,'','','',NULL,'',NULL,NULL,'','2025-11-18 08:22:57',NULL),(70,'JM3-C-TECLADO-0001','','TECLADO','LOGITECH','K235','-','OPERATIVO',3,5,NULL,'','','',NULL,'','','',NULL,'',NULL,NULL,'','2025-11-18 08:23:15',NULL),(71,'JM3-C-MOUSE-0001','','MOUSE','LOGITECH','M170','2149LZD67V58','OPERATIVO',3,5,NULL,'','','',NULL,'','','',NULL,'',NULL,NULL,'','2025-11-18 08:23:54',NULL),(72,'JM3-S-PC-0001','DESKTOP-CDB66RC','PC','HP','PRODESK 400 G4 DM','-','OPERATIVO',25,5,NULL,'WINDOWS 10 PRO','22H2','COREI7-8700T',16.00,'238 SSD','192.168.18.215','20-79-18-74-E0-BF',NULL,'0',NULL,NULL,'','2025-11-18 08:37:36',NULL),(73,'JM3-S-MONITOR-0001','','MONITOR','LENOVO 22\"','THINKVISION T22i - 10','-','OPERATIVO',25,5,NULL,'','','',NULL,'','','',NULL,'',NULL,NULL,'','2025-11-18 08:39:31',NULL),(74,'JM3-S-MONITOR-0002','','MONITOR','LENOVO 22\"','THINKVISION T22i - 10','-','OPERATIVO',25,5,NULL,'','','',NULL,'','','',NULL,'',NULL,NULL,'','2025-11-18 08:39:47',NULL),(75,'JM3-S-TECLADO-0001','','TECLADO','LOGITECH','K235','-','OPERATIVO',25,5,NULL,'','','',NULL,'','','',NULL,'',NULL,NULL,'','2025-11-18 08:40:11',NULL),(76,'JM3-S-MOUSE-0001','','MOUSE','LOGITECH','M170','2149LZ68JE8','OPERATIVO',25,5,NULL,'','','',NULL,'','','',NULL,'',NULL,NULL,'','2025-11-18 08:40:49',NULL),(77,'JM3-T1-PC-0001','DESKTOP-DCAEFET','PC','HP','PRO DESK 10RRS19D08','-','OPERATIVO',21,5,NULL,'WINDOWS 11 PRO','24H2','COREI7-9700T',16.00,'954 SSD','192.168.18234','98-FA-9B-51-8B-33',NULL,'0',NULL,NULL,'','2025-11-18 08:56:24',NULL),(78,'JM3-T1-MONITOR-0001','','MONITOR','HP','Z22 G2','-','OPERATIVO',21,5,NULL,'','','',NULL,'','','',NULL,'',NULL,NULL,'','2025-11-18 08:56:54',NULL),(79,'JM3-T1-MONITOR-0002','','MONITOR','LENOVO 22\"','THINKVISION T22i - 10','-','OPERATIVO',21,5,NULL,'','','',NULL,'','','',NULL,'',NULL,NULL,'','2025-11-18 08:57:32',NULL),(80,'JM3-T1-TECLADO-0001','','TECLADO','LOGITECH','K235','-','OPERATIVO',21,5,NULL,'','','',NULL,'','','',NULL,'',NULL,NULL,'','2025-11-18 08:57:49',NULL),(81,'JM3-T1-MOUSE-0001','','MOUSE','LOGITECH','M170','2327LZXEK4E8','OPERATIVO',21,5,NULL,'','','',NULL,'','','',NULL,'',NULL,NULL,'','2025-11-18 08:58:12',NULL),(85,'JM2-S-OTRO-0001','','OTRO','ACER','ASPIRE A315-57G','N18Q13','OPERATIVO',1,2,NULL,'','','',NULL,'','','',NULL,'',NULL,NULL,'','2025-11-18 10:07:13',NULL),(86,'JM2-S-MOUSE-0002','','MOUSE','LOGITECH','M170','2522ZEG44PO8','OPERATIVO',25,2,NULL,'','','',NULL,'','','',NULL,'',NULL,NULL,'','2025-11-18 10:13:37',NULL),(87,'JM2-GG-LAPTOP-0001','LAPTOP-49GT1P5P','LAPTOP','HP','15-DY2503LA','5CD223DJ73','OPERATIVO',24,2,NULL,'WINDOWS 11 HOME SINGLE LANGUAJE','24H2','COREI5-1135GT',8.00,'477 SSD','192.168.1.34','3C-55-76-86-94-F9',NULL,'',NULL,NULL,'','2025-11-18 10:19:00',NULL),(88,'JM2-GG-MOUSE-0001','','MOUSE','LOGITECH','M150','M-R0037','OPERATIVO',24,2,NULL,'','','',NULL,'','','',NULL,'',NULL,NULL,'','2025-11-18 10:19:50',NULL),(89,'JM2-P-PC-0001','DESKTOP-KLRM9JE','PC','DELL','61DPRW1','13144197745','OPERATIVO',2,2,1,'WINDOWS 10 PRO','22H2','COREI5-2400',4.00,'224 SSS','','',NULL,'',NULL,NULL,'','2025-11-19 05:51:54',NULL);

--
-- Table structure for table `documentos`
--

CREATE TABLE `documentos` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `empresa_id` int NOT NULL,
  `contenedor_id` bigint NOT NULL,
  `titulo` varchar(255) NOT NULL,
  `extension` varchar(20) DEFAULT NULL,
  `mime` varchar(150) DEFAULT NULL,
  `tamanio_bytes` bigint NOT NULL DEFAULT '0',
  `hash_sha256` char(64) DEFAULT NULL,
  `origen_storage` enum('LOCAL','S3','DRIVE') NOT NULL DEFAULT 'LOCAL',
  `storage_key` varchar(500) NOT NULL,
  `drive_file_id` varchar(128) DEFAULT NULL,
  `webview_link` varchar(500) DEFAULT NULL,
  `webcontent_link` varchar(500) DEFAULT NULL,
  `estado` enum('VIGENTE','BLOQUEADO') NOT NULL DEFAULT 'VIGENTE',
  `creado_en` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `actualizado_en` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  `eliminado_en` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ix_doc_empresa` (`empresa_id`),
  KEY `ix_doc_contenedor` (`contenedor_id`),
  KEY `ix_doc_titulo` (`titulo`),
  KEY `ix_doc_hash` (`hash_sha256`),
  CONSTRAINT `fk_documentos_contenedor` FOREIGN KEY (`contenedor_id`) REFERENCES `contenedores` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_documentos_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 `documentos`
--


--
-- Table structure for table `dominio`
--

CREATE TABLE `dominio` (
  `dominio_id` int NOT NULL AUTO_INCREMENT,
  `suscripcion_id` int NOT NULL,
  `nombre` varchar(253) NOT NULL,
  `registrador` varchar(120) DEFAULT NULL,
  `fecha_reg` date DEFAULT NULL,
  `fecha_exp` date DEFAULT NULL,
  `privacidad` tinyint(1) NOT NULL DEFAULT '0',
  `dns_provider` varchar(120) DEFAULT NULL,
  `creado_en` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`dominio_id`),
  UNIQUE KEY `nombre` (`nombre`),
  KEY `fk_dom_sus` (`suscripcion_id`),
  KEY `idx_dominio_exp` (`fecha_exp`),
  CONSTRAINT `fk_dom_sus` FOREIGN KEY (`suscripcion_id`) REFERENCES `suscripcion` (`suscripcion_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `dominio`
--


--
-- Table structure for table `dominio_dns`
--

CREATE TABLE `dominio_dns` (
  `id` int NOT NULL AUTO_INCREMENT,
  `dominio_id` int NOT NULL,
  `tipo` enum('A','AAAA','CNAME','MX','TXT','SRV','NS') NOT NULL,
  `nombre` varchar(255) NOT NULL,
  `valor` varchar(1024) NOT NULL,
  `prioridad` int DEFAULT NULL,
  `ttl` int DEFAULT NULL,
  `creado_en` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `fk_dn_dom` (`dominio_id`),
  CONSTRAINT `fk_dn_dom` FOREIGN KEY (`dominio_id`) REFERENCES `dominio` (`dominio_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `dominio_dns`
--


--
-- Table structure for table `eecc_cat`
--

CREATE TABLE `eecc_cat` (
  `id` int NOT NULL AUTO_INCREMENT,
  `tipo` enum('I','E') NOT NULL,
  `nombre` varchar(80) NOT NULL,
  `orden` int DEFAULT '0',
  `activo` tinyint(1) DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `eecc_cat`
--

INSERT INTO `eecc_cat` VALUES (1,'I','INGRESOS',1,1),(2,'E','EGRESOS',2,1);

--
-- Table structure for table `eecc_item`
--

CREATE TABLE `eecc_item` (
  `id` int NOT NULL AUTO_INCREMENT,
  `cat_id` int NOT NULL,
  `nombre` varchar(100) NOT NULL,
  `orden` int DEFAULT '0',
  `activo` tinyint(1) DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `fk_eecc_item_cat` (`cat_id`),
  CONSTRAINT `fk_eecc_item_cat` FOREIGN KEY (`cat_id`) REFERENCES `eecc_cat` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `eecc_item`
--

INSERT INTO `eecc_item` VALUES (1,1,'BBVA',1,1),(2,1,'INTERBANK',2,1),(3,1,'SCOTIABANK',3,1),(4,1,'BANBIF SOLES',4,1),(5,1,'BANBIF DÓLAR',5,1),(6,2,'TELECREDITO',1,1),(7,2,'BANBIF',2,1),(8,2,'BBVA',999,1),(9,2,'SALUD',999,1);

--
-- Table structure for table `eecc_monto`
--

CREATE TABLE `eecc_monto` (
  `item_id` int NOT NULL,
  `anio` int NOT NULL,
  `mes` tinyint NOT NULL,
  `monto` decimal(14,2) NOT NULL DEFAULT '0.00',
  PRIMARY KEY (`item_id`,`anio`,`mes`),
  CONSTRAINT `fk_eecc_monto_item` FOREIGN KEY (`item_id`) REFERENCES `eecc_item` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `eecc_monto`
--

INSERT INTO `eecc_monto` VALUES (1,2025,1,35316.54),(1,2025,2,5660.91),(1,2025,3,31450.81),(1,2025,4,160.63),(1,2025,5,0.00),(1,2025,6,2556.05),(1,2025,7,696.20),(1,2025,8,6851.93),(1,2025,9,1960.78),(1,2025,10,5021.35),(2,2025,1,0.00),(3,2025,1,0.00),(3,2025,6,0.00),(9,2025,11,630.00);

--
-- Table structure for table `eecc_voucher`
--

CREATE TABLE `eecc_voucher` (
  `id` int NOT NULL AUTO_INCREMENT,
  `item_id` int NOT NULL,
  `anio` int NOT NULL,
  `mes` tinyint NOT NULL,
  `fecha` date DEFAULT NULL,
  `saldo` decimal(14,2) DEFAULT '0.00',
  `descripcion` text,
  `notas` text,
  `archivo` varchar(255) 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`),
  KEY `item_id` (`item_id`,`anio`,`mes`),
  CONSTRAINT `fk_v_item` FOREIGN KEY (`item_id`) REFERENCES `eecc_item` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `eecc_voucher`
--

INSERT INTO `eecc_voucher` VALUES (4,1,2025,1,'2025-01-31',35316.54,'EECC ENERO 2025 - CTA AHORROS 0011-0814-0239128608','','gdrv:1gmBbO5wMvsJayDKCEN9gDFAmKixdQd7p','2025-11-07 11:23:17','2025-11-07 11:32:07'),(6,1,2025,6,'2025-06-30',2556.05,'EECC JUNIO 2025 - CTA AHORROS 0011-0814-0239128608','','gdrv:1WmJbppyUWRm6CeAY2P0e0301vGo4f3WG','2025-11-07 11:30:41','2025-11-07 11:32:02'),(7,1,2025,7,'2025-07-31',696.20,'EECC JULIO 2025 - CTA AHORROS 0011-0814-0239128608','','gdrv:11pIRt0uzJp-7r0AIWG7pLHcC7_xpxV9w','2025-11-07 11:31:24','2025-11-07 11:32:18'),(8,1,2025,8,'2025-08-31',6851.93,'EECC AGOSTO 2025 - CTA AHORROS 0011-0814-0239128608','','gdrv:1N-O7Z6HXpzo6c4-D3DKlyJqKlllScpqG','2025-11-07 11:33:31','2025-11-07 11:33:48'),(9,1,2025,9,'2025-09-30',1960.78,'EECC SETIEMBRE 2025 - CTA AHORROS 0011-0814-0239128608','','gdrv:1FNFltnwCSn-6S2WgK8SJFYTv6esgu2zc','2025-11-07 11:36:38','2025-11-07 11:37:02'),(10,1,2025,10,'2025-10-31',5021.35,'EECC OCTUBRE 2025 - CTA AHORROS 0011-0814-0239128608','','gdrv:108cAs-a4WMHcc5_FWHBDc2FIp6jbKx1Q','2025-11-07 11:37:45','2025-11-07 11:37:58'),(11,1,2025,3,'2025-03-31',31450.81,'EECC MARZO 2025 - CTA AHORROS 0011-0814-0239128608','','gdrv:19sYHR4pq69FHauzqqQDEumHIaae9Wvox','2025-11-07 11:40:21','2025-11-07 11:44:53'),(12,1,2025,2,'2025-02-28',5660.91,'EECC FEBRERO 2025 - CTA AHORROS 0011-0814-0239128608','','gdrv:19jaoyzlpDrG9Z9OUlumATxzAYN-z-rXB','2025-11-07 11:41:26','2025-11-07 11:42:18'),(13,1,2025,4,'2025-04-30',160.63,'EECC ABRIL 2025 - CTA AHORROS 0011-0814-0239128608','','gdrv:1kgwAmpV0TLC1Cmc7Iq311ZWqzupIc7x3','2025-11-07 11:44:31','2025-11-07 11:44:42'),(14,9,2025,11,'2025-11-10',0.00,'SALUD GASTROHEPATICA','EXAMEN ELASTOGRAFIA HEPATICA --> 500  (250 --> 07/11/2025 SCOTIABANK ) (250 --> 10/11/2025 BBVA)\r\nNUEVO EXAMEN --> 130\r\n\r\nINFORMACION: \r\nGASTRO HEPATICA - +51 992 182 957 - 📍 Av. Arnaldo Márquez 1900, Jesús María. horario de atención: 7:00 am a 7:00 pm','gdrv:1QelN6KyyNairnoxl1nedO-Qt_N_133rI','2025-11-10 11:49:13','2025-11-10 11:52:03');

--
-- Table structure for table `empresas`
--

CREATE TABLE `empresas` (
  `empresa_id` int NOT NULL AUTO_INCREMENT,
  `ruc` varchar(15) NOT NULL,
  `razon_social` varchar(160) NOT NULL,
  `nombre_comercial` varchar(120) DEFAULT NULL,
  `estado` enum('ACTIVO','INACTIVO') NOT NULL DEFAULT 'ACTIVO',
  `creado_en` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `regimen_empresa` enum('REMYPE_MICRO','REMYPE_PEQUENA','GENERAL') NOT NULL DEFAULT 'REMYPE_MICRO',
  PRIMARY KEY (`empresa_id`),
  UNIQUE KEY `uq_empresas_ruc` (`ruc`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

INSERT INTO `empresas` VALUES (1,'00000000000','SIN EMPRESA','SIN EMPRESA','INACTIVO','2025-10-15 11:09:38','REMYPE_MICRO'),(2,'20611726792','INVERSIONES TECNOLOGICAS BD S.A.C.','INVERSIONES TECNOLOGICAS BD','ACTIVO','2025-10-15 11:37:01','REMYPE_MICRO'),(3,'20612233234','INVERSIONES INNOVADORAS BD S.A.C.','INVERSIONES INNOVADORAS BD','ACTIVO','2025-10-15 11:37:38','REMYPE_MICRO'),(14,'20602294332','BUSINESS DIVISAS E INVERSIONES SAC','BUSINESS DIVISAS E INVERSIONES SAC','ACTIVO','2025-12-11 11:24:47','REMYPE_MICRO'),(15,'20602263747','SERVI PAY E INVERSIONES SAC','SERVI PAY E INVERSIONES SAC','ACTIVO','2025-12-11 11:24:47','REMYPE_MICRO'),(16,'20609409674','BOLSA DE DIVISAS EIRL','BOLSA DE DIVISAS EIRL','ACTIVO','2025-12-11 11:24:47','REMYPE_MICRO'),(17,'20609582431','YOYISS SALON & SPA SAC','YOYISS SALON & SPA SAC','ACTIVO','2025-12-11 11:24:47','REMYPE_MICRO'),(18,'20610248234','SOLUCIONES TECNOLOGICAS EVP SAC','SOLUCIONES TECNOLOGICAS EVP SAC','ACTIVO','2025-12-11 11:24:47','REMYPE_MICRO'),(19,'20610389393','PAGO EFECTY EIRL','PAGO EFECTY EIRL','ACTIVO','2025-12-11 11:24:47','REMYPE_MICRO'),(20,'20610801456','INVERSIONES Y SOLUCIONES B & D S.A.C.','INVERSIONES Y SOLUCIONES B & D S.A.C.','ACTIVO','2025-12-11 11:24:47','REMYPE_MICRO'),(21,'10405107894','EDUARDO VARA PILLACA','EDUARDO VARA PILLACA','ACTIVO','2025-12-11 11:24:47','REMYPE_MICRO'),(22,'20609239965','INVERSIONES Y NEGOCIOS BD SAC','INVERSIONES Y NEGOCIOS BD SAC','ACTIVO','2025-12-11 13:29:59','REMYPE_MICRO'),(23,'20606748974','KAIZEN DIVISAS SAC','KAIZEN DIVISAS SAC','ACTIVO','2025-12-11 13:29:59','REMYPE_MICRO');

--
-- Table structure for table `equipo_grupo`
--

CREATE TABLE `equipo_grupo` (
  `grupo_id` int NOT NULL AUTO_INCREMENT,
  `nombre` varchar(120) NOT NULL,
  `area_id` int NOT NULL,
  `sede_id` int NOT NULL,
  `empresa_id` int NOT NULL,
  `estado` enum('ACTIVO','INACTIVO') NOT NULL DEFAULT 'ACTIVO',
  `notas` varchar(255) DEFAULT NULL,
  `creado_en` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `actualizado_en` datetime DEFAULT NULL,
  PRIMARY KEY (`grupo_id`),
  KEY `fk_eg_area` (`area_id`),
  KEY `fk_eg_sede` (`sede_id`),
  KEY `fk_eg_emp` (`empresa_id`),
  CONSTRAINT `fk_eg_area` FOREIGN KEY (`area_id`) REFERENCES `areas` (`area_id`),
  CONSTRAINT `fk_eg_emp` FOREIGN KEY (`empresa_id`) REFERENCES `empresas` (`empresa_id`),
  CONSTRAINT `fk_eg_sede` FOREIGN KEY (`sede_id`) REFERENCES `sedes` (`sede_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `equipo_grupo`
--

INSERT INTO `equipo_grupo` VALUES (2,'PC W1 - W2',28,2,1,'ACTIVO','','2025-11-17 08:04:18',NULL);

--
-- Table structure for table `equipo_grupo_item`
--

CREATE TABLE `equipo_grupo_item` (
  `id` int NOT NULL AUTO_INCREMENT,
  `grupo_id` int NOT NULL,
  `dispositivo_id` int NOT NULL,
  `rol` enum('PC','LAPTOP','SERVIDOR','MONITOR','IMPRESORA','TECLADO','MOUSE','UPS','OTRO') DEFAULT NULL,
  `es_principal` tinyint(1) NOT NULL DEFAULT '0',
  `agregado_en` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_egi_disp` (`dispositivo_id`),
  UNIQUE KEY `uq_grupo_disp` (`grupo_id`,`dispositivo_id`),
  KEY `idx_grupo` (`grupo_id`),
  KEY `idx_disp` (`dispositivo_id`),
  CONSTRAINT `fk_egi_disp` FOREIGN KEY (`dispositivo_id`) REFERENCES `dispositivos` (`dispositivo_id`) ON DELETE RESTRICT,
  CONSTRAINT `fk_egi_grupo` FOREIGN KEY (`grupo_id`) REFERENCES `equipo_grupo` (`grupo_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `equipo_grupo_item`
--

INSERT INTO `equipo_grupo_item` VALUES (9,2,17,NULL,0,'2025-11-18 06:33:31'),(10,2,15,NULL,0,'2025-11-18 06:33:46'),(11,2,14,NULL,0,'2025-11-18 06:33:49'),(12,2,13,NULL,1,'2025-11-18 06:33:54'),(13,2,16,NULL,0,'2025-11-18 06:34:14');

--
-- Table structure for table `etiqueta_objetos`
--

CREATE TABLE `etiqueta_objetos` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `empresa_id` int NOT NULL,
  `etiqueta_id` bigint NOT NULL,
  `objeto_tipo` enum('documento','contenedor') NOT NULL,
  `objeto_id` bigint NOT NULL,
  `creado_en` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ux_eo` (`empresa_id`,`etiqueta_id`,`objeto_tipo`,`objeto_id`),
  KEY `ix_eo_etiqueta` (`etiqueta_id`),
  KEY `ix_eo_objeto` (`objeto_tipo`,`objeto_id`),
  CONSTRAINT `fk_eo_empresa` FOREIGN KEY (`empresa_id`) REFERENCES `empresas` (`empresa_id`) ON DELETE CASCADE,
  CONSTRAINT `fk_eo_etiqueta` FOREIGN KEY (`etiqueta_id`) REFERENCES `etiquetas` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `etiqueta_objetos`
--


--
-- Table structure for table `etiquetas`
--

CREATE TABLE `etiquetas` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `empresa_id` int NOT NULL,
  `parent_id` bigint DEFAULT NULL,
  `nombre` varchar(120) NOT NULL,
  `slug` varchar(140) DEFAULT NULL,
  `color_hex` char(7) DEFAULT NULL,
  `descripcion` varchar(300) DEFAULT NULL,
  `tipo` enum('LIBRE','SERIE','SPLAFT','AREA','OTRO') NOT NULL DEFAULT 'LIBRE',
  `estado` enum('ACTIVO','INACTIVO') NOT NULL DEFAULT 'ACTIVO',
  `creado_en` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `actualizado_en` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ux_etq_empresa_nombre` (`empresa_id`,`nombre`),
  KEY `ix_etq_empresa` (`empresa_id`),
  KEY `ix_etq_parent` (`parent_id`),
  KEY `ix_etq_tipo` (`empresa_id`,`tipo`,`estado`),
  CONSTRAINT `fk_etq_empresa` FOREIGN KEY (`empresa_id`) REFERENCES `empresas` (`empresa_id`) ON DELETE CASCADE,
  CONSTRAINT `fk_etq_parent` FOREIGN KEY (`parent_id`) REFERENCES `etiquetas` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `etiquetas`
--

INSERT INTO `etiquetas` VALUES (1,1,NULL,'LEGAL','legal','#1E88E5',NULL,'SERIE','ACTIVO','2025-10-31 16:32:32',NULL),(2,1,NULL,'CONTRATOS','contratos','#3949AB',NULL,'SERIE','ACTIVO','2025-10-31 16:32:32',NULL),(3,1,NULL,'SPLAFT','splaft','#00897B',NULL,'SERIE','ACTIVO','2025-10-31 16:32:32',NULL),(4,1,NULL,'RRHH','rrhh','#6D4C41',NULL,'SERIE','ACTIVO','2025-10-31 16:32:32',NULL),(5,1,NULL,'Urgente','urgente','#E53935',NULL,'LIBRE','ACTIVO','2025-10-31 16:32:32',NULL);

--
-- Table structure for table `evento_archivos`
--

CREATE TABLE `evento_archivos` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `evento_id` bigint unsigned NOT NULL,
  `original_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `stored_name` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
  `mime_type` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `size_bytes` bigint unsigned NOT NULL,
  `storage` enum('local','drive') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'local',
  `drive_file_id` varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `drive_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` int NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `idx_evento_id` (`evento_id`),
  KEY `idx_evento_archivos_drive_id` (`drive_file_id`),
  CONSTRAINT `fk_ea_evento` FOREIGN KEY (`evento_id`) REFERENCES `eventos` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `evento_archivos`
--

INSERT INTO `evento_archivos` VALUES (3,73,'FC01-000350.pdf','ev73_68c176a8b7dfd4.30389525.pdf','application/pdf',35520,'local',NULL,NULL,9,'2025-09-10 13:01:28'),(10,98,'8_de_octubre__Combate_de_Angamos.png','ev98_68cad32de7810','image/png',640332,'drive','1IJvuZVh1LKDtaFyKOGR_45c2wTfGiBXg','8_de_octubre__Combate_de_Angamos.png',1,'2025-09-17 15:26:37'),(11,98,'___8_de_octubre__Combate_de_Angamos.mp4','ev98_68cc18bd078e5','video/mp4',16570214,'drive','1tc3XKrdVqHH3lnB4_jCAVgR7UpItWxtF','___8_de_octubre__Combate_de_Angamos.mp4',1,'2025-09-18 14:35:41');

--
-- Table structure for table `eventos`
--

CREATE TABLE `eventos` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `usuario_id` int NOT NULL,
  `responsable_id` int DEFAULT NULL,
  `area_id` int DEFAULT NULL,
  `titulo` varchar(200) NOT NULL,
  `inicio` datetime NOT NULL,
  `fin` datetime DEFAULT NULL,
  `all_day` tinyint(1) NOT NULL DEFAULT '0',
  `empresa` varchar(50) NOT NULL,
  `color` varchar(20) DEFAULT '#4285f4',
  `ubicacion` varchar(255) DEFAULT NULL,
  `contenido` text,
  `notif_tipo` enum('whatsapp','notificacion','correo') DEFAULT 'notificacion',
  `notif_tiempo` int DEFAULT '30',
  `notif_unidad` enum('minutos','horas','dias') DEFAULT 'minutos',
  `notif_enviado` tinyint(1) NOT NULL DEFAULT '0',
  `notif_enviado_en` datetime DEFAULT NULL,
  `invitados` text,
  `creado_en` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `actualizado_en` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `tasks_json` json DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_evt_usuario_inicio` (`usuario_id`,`inicio`),
  KEY `idx_evt_inicio` (`inicio`),
  KEY `idx_evt_responsable` (`responsable_id`),
  KEY `idx_evt_area` (`area_id`),
  CONSTRAINT `fk_evt_area` FOREIGN KEY (`area_id`) REFERENCES `areas` (`area_id`) ON DELETE SET NULL,
  CONSTRAINT `fk_evt_resp` FOREIGN KEY (`responsable_id`) REFERENCES `usuarios` (`id`) ON DELETE SET NULL,
  CONSTRAINT `fk_evt_usuario` FOREIGN KEY (`usuario_id`) REFERENCES `usuarios` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=178 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `eventos`
--

INSERT INTO `eventos` VALUES (3,1,NULL,3,'PRUEBA EVENTO 002','2025-08-18 08:00:00','2025-08-18 08:30:00',0,'3TMI','#0d6efd','Institución Educativa Emblemática Elvira García y García, 155, Avenida Del Río, Pueblo Libre, Lima, Lima Metropolitana, Lima, 15081, Perú','<p>Pruebaaa</p>','whatsapp',30,'minutos',0,NULL,'[{\"id\":17},{\"id\":15},{\"id\":12}]','2025-08-18 12:33:51','2025-09-03 13:04:33',NULL),(4,9,NULL,NULL,'REUNION LECTURA CONTRATO CISSAC','2025-08-19 08:30:00','2025-08-19 09:00:00',0,'BUSINESS DIVISAS','#4285f4','Av. Cayetano Heredia Nro 494, Jesús María','<p>Reuni&oacute;n para que den lectura a contrato CISSAC</p>','whatsapp',30,'minutos',0,NULL,'[]','2025-08-18 16:54:05','2025-08-22 15:17:08',NULL),(7,9,NULL,NULL,'Capacitacion cuadre caja Nayumi Geno','2025-08-21 18:30:00','2025-08-21 19:00:00',0,'BUSINESS DIVISAS','#fdc220','Oficina 212','<p>Antes de emprezar a cuadrar que puntos se debe de tomar en cuenta</p>','whatsapp',30,'minutos',0,NULL,'[]','2025-08-19 00:11:17','2025-08-22 15:15:58',NULL),(8,9,NULL,NULL,'CARLOS PEDIR ESCALERA 5PM el sábado 23 de Agosto de la GALERIA','2025-08-23 08:00:00','2025-08-23 08:30:00',0,'BUSINESS DIVISAS','#4285f4','LOCAL 315','','whatsapp',30,'minutos',0,NULL,'[]','2025-08-19 01:57:26','2025-08-22 15:15:17',NULL),(9,9,NULL,NULL,'PUBLICIDAD - SOFIA','2025-08-19 06:00:00','2025-08-19 06:20:00',0,'3TMI','#003399','212','','whatsapp',30,'minutos',0,NULL,'[]','2025-08-19 02:15:47','2025-08-19 02:15:47',NULL),(10,9,NULL,NULL,'SISTEMAS - CARLOS','2025-08-19 09:15:00','2025-08-19 09:45:00',0,'3TMI','#003399','Oficina 212','','whatsapp',30,'minutos',0,NULL,'[]','2025-08-19 02:18:07','2025-08-22 15:16:47',NULL),(11,9,NULL,15,'VACACIONES ANTUANET','2025-08-18 00:00:00','2025-08-24 00:00:00',0,'BUSINESS DIVISAS','#4285f4','','','whatsapp',30,'minutos',0,NULL,'[]','2025-08-19 16:31:41','2025-08-19 16:31:41',NULL),(12,9,NULL,NULL,'ANTONY','2025-08-20 08:00:00','2025-08-20 08:30:00',0,'BUSINESS DIVISAS','#fdc220','oficina 212','Dinero de la empresa (devolucion Inmediata)\nPeriodo de contrato','whatsapp',30,'minutos',0,NULL,'[]','2025-08-20 11:45:10','2025-08-20 11:45:10',NULL),(13,1,NULL,NULL,'BUSINESS DIVISAS - Reunion','2025-08-20 08:00:00','2025-08-20 08:45:00',0,'BUSINESS DIVISAS','#fdc220','Institución educativa inicial El Mundo De Los Niños Felices, 330, Jirón Pedro Donofrio, Batievski, Breña, Lima, Lima Metropolitana, Lima, 15081, Perú','<ul>\n<li>Pruebaaaaaa</li>\n</ul>','whatsapp',30,'minutos',0,NULL,'[]','2025-08-20 11:48:07','2025-08-22 13:45:37',NULL),(14,1,NULL,NULL,'YOYISS - Reunion','2025-08-20 09:00:00','2025-08-20 09:45:00',0,'YOYISS','#7000a2','Institución educativa inicial El Mundo De Los Niños Felices, 330, Jirón Pedro Donofrio, Batievski, Breña, Lima, Lima Metropolitana, Lima, 15081, Perú','','whatsapp',30,'minutos',0,NULL,'[]','2025-08-20 11:49:22','2025-08-22 13:45:44',NULL),(15,9,NULL,NULL,'CISAC','2025-08-20 11:15:00','2025-08-20 07:00:00',0,'PERSONAL','#ff6d13','oficina 212','Desembolso pichincha\nCoordinar para la Visita y Disponibilidad del Dpto \nfecha de  entrega del  Dpto','whatsapp',30,'minutos',0,NULL,'[]','2025-08-20 11:56:17','2025-08-20 11:56:17',NULL),(16,9,NULL,NULL,'Denuncia POLICIAL POR PERDIDA','2025-08-23 08:30:00','2025-08-23 09:00:00',0,'PERSONAL','#ff6d13','COMISARIA DE JESUS MARIA','<p><span style=\"text-decoration-line: underline;\">&nbsp;Denuncia POLICIAL POR PERDIDA</span></p>\n<p>&nbsp;</p>\n<ol>\n<li>brevete Digital</li>\n<li>tarjeta de propiedad Digital</li>\n</ol>','whatsapp',30,'minutos',0,NULL,'[{\"id\":9}]','2025-08-21 11:58:29','2025-08-22 15:15:27',NULL),(17,1,NULL,3,'PRUEBA DE EVENTO','2025-08-22 09:00:00','2025-08-22 09:45:00',0,'3TMI','#0d6efd','EDIFICIO','<p>pRUEBAAAA</p>','whatsapp',30,'minutos',0,NULL,'[{\"id\":12}]','2025-08-22 13:45:06','2025-08-22 14:33:56',NULL),(18,9,NULL,3,'TRANSFERENCIA - BRENDA','2025-08-26 07:45:00','2025-08-26 08:30:00',0,'BUSINESS DIVISAS','#fdc220','315 jm','<ol>\n<li>Enviar saldos</li>\n<li>Estar en transferencia hasta que ingrese Alexandra 8:00 - 8:15 Am aprox</li>\n<li>reaunion Avances 8:30 - 9:00 Am L-S</li>\n<li>Almuerzo reeplazo alexandra - Transferencia 12:00 Am - 1:00 Pm</li>\n</ol>','whatsapp',30,'minutos',0,NULL,'[{\"id\":12}]','2025-08-23 02:25:36','2025-08-23 02:39:49',NULL),(22,9,NULL,NULL,'TRANSFERENCIA - BRENDA','2025-08-25 07:45:00','2025-08-25 08:15:00',0,'BUSINESS DIVISAS','#fdc220','315 jm','<ol>\n<li>Enviar saldos 7:45 Am&nbsp;</li>\n<li>Estar en transferencia hasta que ingrese Alexandra 8:00 - 8:15 Am aprox</li>\n<li>reaunion Avances 8:30 - 9:00 Am L-S</li>\n<li>Almuerzo reeplazo alexandra - Transferencia 12:00 Am - 1:00 Pm</li>\n</ol>','whatsapp',30,'minutos',0,NULL,'[{\"id\":12}]','2025-08-23 02:41:18','2025-08-23 02:41:18',NULL),(23,9,NULL,3,'TRANSFERENCIA - BRENDA','2025-08-27 07:45:00','2025-08-27 08:15:00',0,'BUSINESS DIVISAS','#fdc220','315 jm','<ol>\n<li>Enviar saldos 7:45 Am&nbsp;</li>\n<li>Estar en transferencia hasta que ingrese Alexandra 8:00 - 8:15 Am aprox</li>\n<li>reaunion Avances 8:30 - 9:00 Am L-S</li>\n<li>Almuerzo reeplazo alexandra - Transferencia 12:00 Am - 1:00 Pm</li>\n<li>&nbsp;</li>\n</ol>','whatsapp',30,'minutos',0,NULL,'[{\"id\":12}]','2025-08-23 02:42:02','2025-08-23 11:52:02',NULL),(24,9,NULL,3,'TRANSFERENCIA - BRENDA','2025-08-29 07:45:00','2025-08-29 08:15:00',0,'BUSINESS DIVISAS','#fdc220','1563, Jirón Sinchi Roca, Oyague, Jesús María, Lima, Lima Metropolitana, Lima, 15072, Perú','<ol>\n<li>Enviar saldos 7:45 Am&nbsp;</li>\n<li>Estar en transferencia hasta que ingrese Alexandra 8:00 - 8:15 Am aprox</li>\n<li>reaunion Avances 8:30 - 9:00 Am L-S</li>\n<li>Almuerzo reeplazo alexandra - Transferencia 12:00 Am - 1:00 Pm</li>\n<li>&nbsp;</li>\n</ol>','whatsapp',30,'minutos',0,NULL,'[{\"id\":12}]','2025-08-28 14:01:46','2025-08-28 14:01:46',NULL),(25,9,NULL,3,'TRANSFERENCIA - BRENDA','2025-08-28 07:45:00','2025-08-28 08:15:00',0,'BUSINESS DIVISAS','#fdc220','1563, Jirón Sinchi Roca, Oyague, Jesús María, Lima, Lima Metropolitana, Lima, 15072, Perú','<ol>\n<li>Enviar saldos 7:45 Am&nbsp;</li>\n<li>Estar en transferencia hasta que ingrese Alexandra 8:00 - 8:15 Am aprox</li>\n<li>reaunion Avances 8:30 - 9:00 Am L-S</li>\n<li>Almuerzo reeplazo alexandra - Transferencia 12:00 Am - 1:00 Pm</li>\n</ol>','whatsapp',30,'minutos',0,NULL,'[{\"id\":12}]','2025-08-28 14:02:04','2025-08-28 14:02:14',NULL),(26,9,NULL,3,'TRANSFERENCIA - BRENDA','2025-08-25 11:45:00','2025-08-25 13:45:00',0,'BUSINESS DIVISAS','#fdc220','1563, Jirón Sinchi Roca, Oyague, Jesús María, Lima, Lima Metropolitana, Lima, 15072, Perú','','whatsapp',30,'minutos',0,NULL,'[{\"id\":12}]','2025-08-28 14:02:56','2025-08-28 14:02:56',NULL),(27,9,NULL,3,'TRANSFERENCIA - BRENDA','2025-08-29 11:45:00','2025-08-29 13:45:00',0,'BUSINESS DIVISAS','#fdc220','1563, Jirón Sinchi Roca, Oyague, Jesús María, Lima, Lima Metropolitana, Lima, 15072, Perú','<ol>\n<li>Enviar saldos 7:45 Am&nbsp;</li>\n<li>Estar en transferencia hasta que ingrese Alexandra 8:00 - 8:15 Am aprox</li>\n<li>reaunion Avances 8:30 - 9:00 Am L-S</li>\n<li>Almuerzo reeplazo alexandra - Transferencia 12:00 Am - 1:00 Pm</li>\n</ol>','whatsapp',30,'minutos',0,NULL,'[{\"id\":12}]','2025-08-28 14:03:13','2025-08-28 14:03:22',NULL),(28,9,NULL,3,'TRANSFERENCIA - BRENDA','2025-08-28 11:45:00','2025-08-28 13:45:00',0,'BUSINESS DIVISAS','#fdc220','1563, Jirón Sinchi Roca, Oyague, Jesús María, Lima, Lima Metropolitana, Lima, 15072, Perú','<ol>\n<li>Enviar saldos 7:45 Am&nbsp;</li>\n<li>Estar en transferencia hasta que ingrese Alexandra 8:00 - 8:15 Am aprox</li>\n<li>reaunion Avances 8:30 - 9:00 Am L-S</li>\n<li>Almuerzo reeplazo alexandra - Transferencia 12:00 Am - 1:00 Pm</li>\n</ol>','whatsapp',30,'minutos',0,NULL,'[{\"id\":12}]','2025-08-28 14:03:38','2025-08-28 14:03:46',NULL),(29,9,NULL,NULL,'BREÑA','2025-08-30 06:30:00','2025-08-30 07:00:00',0,'YOYISS','#7000a2','1563, Jirón Sinchi Roca, Oyague, Jesús María, Lima, Lima Metropolitana, Lima, 15072, Perú','<ol>\n<li>Orgizar DVR</li>\n<li>Poner en funcionamiento las camar</li>\n<li>otros bre&ntilde;a</li>\n</ol>','whatsapp',30,'minutos',0,NULL,'[]','2025-08-28 14:09:52','2025-08-28 14:22:54',NULL),(30,9,NULL,NULL,'QUIRO PRACTICO','2025-08-28 18:00:00','2025-08-28 18:30:00',0,'PERSONAL','#ff6d13','1563, Jirón Sinchi Roca, Oyague, Jesús María, Lima, Lima Metropolitana, Lima, 15072, Perú','<ol>\n<li>Ir quiro practico</li>\n</ol>','whatsapp',30,'minutos',0,NULL,'[]','2025-08-28 14:15:02','2025-08-28 14:16:48',NULL),(31,9,NULL,NULL,'CINE RAMBLA','2025-08-28 19:15:00','2025-08-28 19:45:00',0,'PERSONAL','#ff6d13','1563, Jirón Sinchi Roca, Oyague, Jesús María, Lima, Lima Metropolitana, Lima, 15072, Perú','<ol>\n<li>Nayumi v.</li>\n<li>Genobeba p.</li>\n<li>Diego p.</li>\n<li>EVP</li>\n</ol>','whatsapp',30,'minutos',0,NULL,'[{\"id\":11},{\"id\":20}]','2025-08-28 14:16:06','2025-08-28 14:18:01',NULL),(32,9,NULL,NULL,'BREÑA MATENIEMINTO','2025-08-29 20:00:00','2025-08-29 21:00:00',0,'YOYISS','#7000a2','1563, Jirón Sinchi Roca, Oyague, Jesús María, Lima, Lima Metropolitana, Lima, 15072, Perú','<ol>\n<li>Ordenar herramientas</li>\n<li>Eliminar cosas en deshuso</li>\n<li>&nbsp;</li>\n</ol>','whatsapp',30,'minutos',0,NULL,'[]','2025-08-28 14:20:00','2025-08-28 14:20:00',NULL),(33,9,NULL,NULL,'CAPACITACION NAYUMI','2025-08-30 06:00:00','2025-08-30 06:30:00',0,'PERSONAL','#ff6d13','1563, Jirón Sinchi Roca, Oyague, Jesús María, Lima, Lima Metropolitana, Lima, 15072, Perú','<ol>\n<li>pLANIFICAR CAPACITACION</li>\n<li>&nbsp;</li>\n</ol>','whatsapp',30,'minutos',0,NULL,'[{\"id\":11},{\"id\":20}]','2025-08-28 14:23:44','2025-08-28 14:23:44',NULL),(34,9,NULL,3,'CAPACITACION - TRANSFERENCIA - NAYUMI','2025-09-01 08:00:00','2025-09-01 09:00:00',0,'BUSINESS DIVISAS','#fdc220','212','<p><strong><span style=\"text-decoration: underline;\">ACCESO A LAS CUENTAS DE BUSINESS</span></strong></p>\n<p>1. Aceso&nbsp; a las cuentas</p>\n<p>* Usuario y contrase&ntilde;a</p>\n<p>*&nbsp;</p>','whatsapp',30,'minutos',0,NULL,'[{\"id\":12},{\"id\":11}]','2025-08-30 17:06:15','2025-08-30 17:18:12',NULL),(35,9,NULL,3,'ENVIAR SALDOS','2025-09-02 08:00:00','2025-09-02 09:00:00',0,'BUSINESS DIVISAS','#fdc220','Viale, Avenida Arnaldo Márquez, Oyague, Jesús María, Lima, Lima Metropolitana, Lima, 15081, Perú','<p>ENVIAR SALDOS</p>\n<p>1. En excel</p>\n<p>2. wasap api</p>\n<p>3. exportar en las distintas versiones</p>','whatsapp',30,'minutos',0,NULL,'[{\"id\":12},{\"id\":11}]','2025-08-30 17:08:44','2025-08-30 17:08:44',NULL),(36,9,NULL,3,'REALIZAR TRANSFERENCIAS ENTRE CUENTAS','2025-09-03 08:00:00','2025-09-03 09:00:00',0,'BUSINESS DIVISAS','#fdc220','Viale, Avenida Arnaldo Márquez, Oyague, Jesús María, Lima, Lima Metropolitana, Lima, 15081, Perú','<p>1.&nbsp; TRANSFERENCIA DE IT-IN</p>\n<p>2. Transferencia de PN - PJ IT&nbsp;</p>\n<p>3. RETORN DE DINERO PJ IT - PN NAYUMI</p>','whatsapp',30,'minutos',0,NULL,'[{\"id\":12},{\"id\":11}]','2025-08-30 17:11:40','2025-08-30 17:11:40',NULL),(37,9,NULL,3,'COTIZACION OPERACION','2025-09-01 08:00:00','2025-09-01 08:30:00',0,'BUSINESS DIVISAS','#0d6efd','212','<p><img src=\"data:image/png;base64,[BLOB]\" alt=\"\" /></p>\n<p>1. COMPRA y Venta dolar y euro</p>\n<p>2. Nick</p>\n<p>3. Nota</p>\n<p>4. Documnetos</p>\n<p>5. Recibido</p>\n<p>6. Cantidad</p>\n<p>7. Tipo De cambio Soles y dolares</p>\n<p>8. Vuelto</p>\n<p>9. Descuento</p>\n<p>10. Total</p>\n<p>&nbsp;</p>','whatsapp',30,'minutos',0,NULL,'[{\"id\":12},{\"id\":11},{\"id\":1},{\"id\":20}]','2025-08-30 17:23:39','2025-08-30 17:23:56',NULL),(38,9,NULL,3,'COTIZACION - IMPRESION','2025-09-02 08:00:00','2025-09-02 09:00:00',0,'BUSINESS DIVISAS','#4285f4','Centro Comercial Plaza Jesús María, 237, Jirón Mariscal Toribio Luzuriaga, Oyague, Jesús María, Lima, Lima Metropolitana, Lima, 15081, Perú','<p>1. 1</p>\n<p>2. 2</p>\n<p>3. 3</p>\n<p>4. COPIAR</p>\n<p>5. Prueba de varias operacion por impresion</p>','whatsapp',30,'minutos',0,NULL,'[{\"id\":12},{\"id\":11},{\"id\":1},{\"id\":20}]','2025-08-30 17:29:30','2025-08-30 17:29:30',NULL),(39,9,NULL,3,'COTIZACION - PRECIOS','2025-09-03 08:00:00','2025-09-03 09:00:00',0,'BUSINESS DIVISAS','#4285f4','212Comercial Plaza Jesús María, 237, Jirón Mariscal Toribio Luzuriaga, Oyague, Jesús María, Lima, Lima Metropolitana, Lima, 15081, Perú','<ol>\n<li>&nbsp;C omo cambiar el precio proveedores</li>\n<li>Precios clientes</li>\n<li>* p. normal</li>\n<li>* p mejorado</li>\n<li>*p proveedor</li>\n</ol>','whatsapp',30,'minutos',0,NULL,'[{\"id\":12},{\"id\":11},{\"id\":1},{\"id\":20}]','2025-08-30 17:32:04','2025-08-30 17:32:04',NULL),(40,9,NULL,NULL,'SUELDO + COMISION TRANSFERENCIA','2025-09-01 06:00:00','2025-09-01 06:45:00',0,'PERSONAL','#ff6d13','Oficina 212','<p>1. REGIMEN LABORAL</p>\n<p>2. SUELDO</p>\n<p>3. COMISIONES</p>\n<p>4. CONTRATO</p>\n<p>5. RIT</p>\n<p>6. SBS</p>\n<p>7. CONTACTAR PROFESIONAL</p>\n<p>* Asesoria Costo</p>\n<p>8.&nbsp;</p>','whatsapp',30,'minutos',0,NULL,'[{\"id\":12}]','2025-08-31 01:15:12','2025-08-31 01:16:13',NULL),(41,9,NULL,3,'CONTABILIDAD','2025-09-04 07:00:00','2025-09-04 07:15:00',0,'BUSINESS DIVISAS','#4285f4','Oficina 212','<p><span style=\"color: #ea4335;\">Reunion abogado financiero (IT) -&nbsp;</span><strong><span style=\"color: #ea4335;\">Caso Renan&nbsp;</span></strong></p>\n<p>* Que hacer en caso ingrese dinero de desconocidos , no sabemos de la procedencia,</p>\n<p><span style=\"color: #ea4335;\">Defensa Civil</span></p>\n<p><span style=\"color: #ea4335;\">Cotejar tkes ( 1 Solo Excel por mes, 4 Bancos, 2 monedas)</span></p>\n<p><span style=\"color: #ea4335;\">&nbsp;Prestamo de auto</span></p>\n<p><span style=\"color: #ea4335;\">Cisac ( Como va el desmbolso), Visita el Dpto</span></p>\n<p>&nbsp;</p>\n<p>&nbsp;</p>\n<p>&nbsp;</p>','whatsapp',30,'minutos',0,NULL,'[{\"id\":12}]','2025-09-04 10:58:20','2025-09-04 11:14:08',NULL),(47,11,NULL,NULL,'AVANZE','2025-09-05 12:45:00','2025-09-05 13:15:00',0,'BUSINESS DIVISAS','#4285f4','','<p>1) Cotejo del dia 04/09/2025</p>\n<p>2) Cotejo estados bancarios&nbsp;</p>\n<p>3)</p>\n<p>4)</p>\n<p>5)</p>\n<p>6)</p>\n<p>&nbsp;</p>','whatsapp',30,'minutos',0,NULL,'[]','2025-09-05 17:50:00','2025-09-05 17:53:32',NULL),(48,9,NULL,19,'CUADRE INGRESOS','2025-09-06 07:15:00','2025-09-06 07:45:00',0,'BUSINESS DIVISAS','#fdc220','315 jm','','whatsapp',30,'minutos',0,NULL,'[{\"id\":15},{\"id\":18}]','2025-09-06 10:56:15','2025-09-06 10:56:15',NULL),(52,9,NULL,NULL,'CAPACITACION BANCOS','2025-09-08 07:00:00','2025-09-08 07:45:00',0,'PERSONAL','#ff6d13','','<p><strong><span style=\"text-decoration: underline;\">BANCOS BCP, BBVA, IBK, PCH</span></strong></p>\n<ul class=\"todo-list\">\n<li data-checked=\"false\">1. Link por banco</li>\n<li data-checked=\"false\">2. Ususario</li>\n<li data-checked=\"false\">3. Claves&nbsp;</li>\n<li data-checked=\"false\">4 .ENVIAR SALDOS</li>\n<li data-checked=\"false\">5. ENVIAR ESTADOS DE CUENTAS</li>\n</ul>\n<p>&nbsp;</p>\n<p>NOTA</p>\n<ul class=\"todo-list\">\n<li data-checked=\"false\">&nbsp;- PPT</li>\n<li data-checked=\"false\">- Video</li>\n<li data-checked=\"false\">&nbsp;-&nbsp; Impreso en una Hoja&nbsp; (1,2,3)</li>\n<li data-checked=\"false\">- Participantes (Nayumi, Eduardo, Brenda)</li>\n</ul>','whatsapp',30,'minutos',0,NULL,'[]','2025-09-08 10:21:58','2025-09-08 10:38:04',NULL),(53,9,NULL,NULL,'SEÑORA  JUANA','2025-09-08 09:00:00','2025-09-08 09:30:00',0,'BUSINESS DIVISAS','#4285f4','','<ol>\n<li>Comunicarle a la Se&ntilde;ora JUANA Banco Bcp por que la congelacion del efectivo del bCP</li>\n<li>Comunicar que en 15 a 30 Dias van Termina la investigacion</li>\n<li>No nos dan una informacion presisa</li>\n</ol>','whatsapp',30,'minutos',0,NULL,'[]','2025-09-08 10:36:17','2025-09-08 10:58:13',NULL),(54,9,NULL,NULL,'CARTA DE RESPUESTA IT BCP','2025-09-08 05:30:00','2025-09-08 06:00:00',0,'BUSINESS DIVISAS','#4285f4','','<p class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; line-height: normal;\"><span style=\"font-size: 12.0pt; font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-fareast-language: ES-PE;\">BCP IT</span></p>\n<p class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; line-height: normal;\"><span style=\"font-size: 12.0pt; font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-fareast-language: ES-PE;\">Toda la documentaci&oacute;n guardar provisionalmente hasta que el caso se soluciones en la agenda. Una vez solucionado Crear Una Carpeta Por empresa / o Casos) se deber&aacute; guardar en el sistema de Carlos.</span></p>\n<ul>\n<li><span style=\"font-size: 12.0pt; font-family: Symbol; mso-fareast-font-family: Symbol; mso-bidi-font-family: Symbol; mso-fareast-language: ES-PE;\"><span style=\"mso-list: Ignore;\"><span style=\"font: 7.0pt \'Times New Roman\';\">&nbsp;</span></span></span><!--[endif]--><span style=\"font-size: 12.0pt; font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-fareast-language: ES-PE;\">Envi&oacute; de la Carta Notarial al BCP Estudio (<strong>Flores Ley</strong>)</span></li>\n<li><span style=\"font-size: 12.0pt; font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-fareast-language: ES-PE;\">Respuesta del BCP</span></li>\n</ul>','whatsapp',30,'minutos',0,NULL,'[]','2025-09-08 10:57:32','2025-09-08 10:57:32',NULL),(55,9,NULL,NULL,'ACCIONES COMPLETADAS','2025-09-08 07:00:00','2025-09-08 07:30:00',0,'PERSONAL','#4285f4','Oficina 212','<p>1.&nbsp; Capacitacion bancos</p>\n<p>2. 9:00 Sra Geno dejar saldo1500 soles y 700 dolares</p>\n<p>3. Lllamar a la seora JUANA Y Enviar la carat del banco BCP</p>\n<p>4.&nbsp; Defensa civil</p>','whatsapp',30,'minutos',0,NULL,'[]','2025-09-08 11:28:50','2025-09-08 11:28:50',NULL),(73,9,NULL,NULL,'CAPACITACION TRANSFERENCIA - WASAP','2025-09-10 08:15:00','2025-09-10 09:00:00',0,'BUSINESS DIVISAS','#4285f4','','<p>INTREGRANTES</p>\n<ul class=\"todo-list\">\n<li data-checked=\"false\" data-due=\"2025-09-10T19:30\">1. EDUARDO&nbsp; (cliente)</li>\n<li data-checked=\"false\" data-due=\"2025-09-10T19:30\">&nbsp;2. ALEXANDRA (transferencia)</li>\n<li data-checked=\"false\" data-due=\"2025-09-10T19:30\">&nbsp;3. NATY (Wasap)</li>\n<li data-checked=\"false\" data-due=\"2025-09-10T19:30\">&nbsp;4. NAYUMI (Caja -Cotejo)</li>\n<li data-checked=\"false\" data-due=\"2025-09-10T19:30\">&nbsp;5. CARLOS (Sistemas)</li>\n<li data-checked=\"false\" data-due=\"2025-09-10T19:30\">&nbsp;6. SOFIA (Publicidad)</li>\n</ul>\n<p style=\"text-align: center;\"><strong><span style=\"text-decoration: underline;\">OPERACIONES DE CAMBIO</span></strong></p>\n<ul class=\"todo-list\">\n<li data-checked=\"false\" data-due=\"2025-09-10T08:15\">1. COMPRA 80.000 DOLARES 3.505<span class=\"task-meta\" contenteditable=\"false\"> <span class=\"tag-due\">📅 2025-09-10 08:15</span></span></li>\n<li data-checked=\"false\" data-due=\"2025-09-10T08:15\">&nbsp;2. VENTA 80.000 DOLARES&nbsp; &nbsp;3.525<span class=\"task-meta\" contenteditable=\"false\"> <span class=\"tag-due\">📅 2025-09-10 08:15</span></span></li>\n<li data-checked=\"false\" data-due=\"2025-09-10T08:15\">&nbsp;3. VENTA 8000 REALES ( Deja a cuenta 200 soles)<span class=\"task-meta\" contenteditable=\"false\"> <span class=\"tag-due\">📅 2025-09-10 08:15</span></span></li>\n</ul>\n<p>OBJETIVO</p>\n<ol>\n<li>Dinamizar los procesos</li>\n<li>Reducir costos en papeleria</li>\n<li>Recargarnos de tanta papeleia en el almacen</li>\n</ol>\n<p><span class=\"tag-user\" contenteditable=\"false\" data-uid=\"1\">@SOFIA JOSELIN CAJAHUAMAN</span>&nbsp;</p>\n<ul class=\"todo-list\">\n<li data-checked=\"false\" data-due=\"2025-09-10T08:15\">grabar la reunion<span class=\"task-meta\" contenteditable=\"false\"> <span class=\"tag-due\">📅 2025-09-10 08:15</span></span></li>\n</ul>','whatsapp',30,'minutos',0,NULL,'[{\"id\":1},{\"id\":11}]','2025-09-10 00:39:01','2025-09-10 11:34:17',NULL),(74,9,NULL,NULL,'DESAYUNO','2025-09-10 07:00:00','2025-09-10 07:45:00',0,'PERSONAL','#ff6d13','','<p>DESAYUNO</p>\n<ul class=\"todo-list\">\n<li data-checked=\"false\" data-due=\"2025-09-10T07:00\">&nbsp;1.&nbsp; NAYUMI<span class=\"task-meta\" contenteditable=\"false\"> <span class=\"tag-due\">📅 2025-09-10 07:00</span></span></li>\n<li data-checked=\"false\" data-due=\"2025-09-10T07:00\">&nbsp;2.&nbsp; EDUARDO<span class=\"task-meta\" contenteditable=\"false\"> <span class=\"tag-due\">📅 2025-09-10 07:00</span></span></li>\n</ul>','whatsapp',30,'minutos',0,NULL,'[]','2025-09-10 00:45:38','2025-09-10 00:45:38',NULL),(75,9,NULL,NULL,'NAYUMI AVANCE','2025-09-10 06:00:00','2025-09-10 06:45:00',0,'BUSINESS DIVISAS','#fdc220','','<p style=\"text-align: center;\"><span style=\"text-decoration: underline;\"><strong>MOSTRAR AVANCE</strong></span></p>\n<p>ENVIAR&nbsp;</p>\n<ul class=\"todo-list\">\n<li data-checked=\"false\" data-due=\"2025-09-11T19:45\">&nbsp;1. SALDOS<span class=\"task-meta\" contenteditable=\"false\"> <span class=\"tag-due\">📅 2025-09-11 19:45</span></span></li>\n<li data-checked=\"false\" data-due=\"2025-09-11T19:45\">&nbsp;2. ESTADOS DE CUENTA POR DIA<span class=\"task-meta\" contenteditable=\"false\"> <span class=\"tag-due\">📅 2025-09-11 19:45</span></span></li>\n<li data-checked=\"false\" data-due=\"2025-09-11T19:45\">&nbsp;3. CONBCILIACIONES BANCARIAS<span class=\"task-meta\" contenteditable=\"false\"> <span class=\"tag-due\">📅 2025-09-11 19:45</span></span></li>\n<li data-checked=\"false\" data-due=\"2025-09-11T19:45\">&nbsp;4. CAPACITACION BANCOS<span class=\"task-meta\" contenteditable=\"false\"> <span class=\"tag-due\">📅 2025-09-11 19:45</span></span></li>\n</ul>','whatsapp',30,'minutos',0,NULL,'[]','2025-09-10 00:47:32','2025-09-10 00:48:01',NULL),(76,9,NULL,NULL,'HACER EJERCICIOS','2025-09-10 06:00:00','2025-09-10 06:15:00',0,'PERSONAL','#ea4335','','<p>SALIR A CORRER&nbsp;</p>\n<ul class=\"todo-list\">\n<li data-checked=\"false\" data-due=\"2025-09-10T06:00\">&nbsp;1. YESICA<span class=\"task-meta\" contenteditable=\"false\"> <span class=\"tag-due\">📅 2025-09-10 06:00</span></span></li>\n<li data-checked=\"false\" data-due=\"2025-09-10T06:00\">&nbsp;2. EDUARDO<span class=\"task-meta\" contenteditable=\"false\"> <span class=\"tag-due\">📅 2025-09-10 06:00</span></span></li>\n</ul>','whatsapp',30,'minutos',0,NULL,'[]','2025-09-10 00:50:14','2025-09-10 00:50:14',NULL),(77,9,NULL,NULL,'MONEDA DIGITAL BCR','2025-09-10 07:00:00','2025-09-10 07:15:00',0,'PERSONAL','#ea4335','','<p style=\"text-align: center;\"><span style=\"text-decoration: underline;\"><strong>Plan de Integraci&oacute;n de Dinero Digital del BCRP para BIDEX</strong></span></p>\n<p style=\"text-align: center;\">&nbsp;</p>\n<h2 data-start=\"257\" data-end=\"283\">1. <strong data-start=\"263\" data-end=\"283\">An&aacute;lisis inicial</strong></h2>\n<ul data-start=\"284\" data-end=\"569\">\n<li data-start=\"284\" data-end=\"401\">\n<p data-start=\"286\" data-end=\"401\"><strong data-start=\"286\" data-end=\"318\">Revisar los pilotos del BCRP</strong> &rarr; Analizar c&oacute;mo est&aacute; funcionando BiPay y otras billeteras digitales autorizadas.</p>\n</li>\n<li data-start=\"402\" data-end=\"569\">\n<p data-start=\"404\" data-end=\"569\"><strong data-start=\"404\" data-end=\"432\">Identificar casos de uso</strong> &rarr; Ejemplo: un cliente que cambia $100 en ventanilla y recibe el equivalente en soles, pero en <strong data-start=\"527\" data-end=\"550\">dinero digital BCRP</strong> en su billetera.</p>\n</li>\n</ul>\n<p data-start=\"571\" data-end=\"633\">✅ Responsable: Gerencia BIDEX<br data-start=\"600\" data-end=\"603\">✅ Tiempo estimado: 2 semanas</p>\n<hr data-start=\"635\" data-end=\"638\">\n<h2 data-start=\"640\" data-end=\"671\">2. <strong data-start=\"646\" data-end=\"671\">Aspectos regulatorios</strong></h2>\n<ul data-start=\"672\" data-end=\"1007\">\n<li data-start=\"672\" data-end=\"785\">\n<p data-start=\"674\" data-end=\"785\"><strong data-start=\"674\" data-end=\"690\">SBS / SPLAFT</strong> &rarr; Actualizar manuales para incluir operaciones con dinero digital como medio de pago v&aacute;lido.</p>\n</li>\n<li data-start=\"786\" data-end=\"910\">\n<p data-start=\"788\" data-end=\"910\"><strong data-start=\"788\" data-end=\"797\">SUNAT</strong> &rarr; En comprobantes electr&oacute;nicos, agregar campo para especificar que el medio de pago fue &ldquo;Dinero Digital BCRP&rdquo;.</p>\n</li>\n<li data-start=\"911\" data-end=\"1007\">\n<p data-start=\"913\" data-end=\"1007\"><strong data-start=\"913\" data-end=\"926\">Licencias</strong> &rarr; Mantener al d&iacute;a la licencia municipal y el registro SBS como casa de cambio.</p>\n</li>\n</ul>\n<p data-start=\"1009\" data-end=\"1084\">✅ Responsable: &Aacute;rea Legal y Cumplimiento BIDEX<br data-start=\"1055\" data-end=\"1058\">✅ Tiempo estimado: 1 mes</p>\n<hr data-start=\"1086\" data-end=\"1089\">\n<h2 data-start=\"1091\" data-end=\"1122\">3. <strong data-start=\"1097\" data-end=\"1122\">Alianzas estrat&eacute;gicas</strong></h2>\n<ul data-start=\"1123\" data-end=\"1346\">\n<li data-start=\"1123\" data-end=\"1223\">\n<p data-start=\"1125\" data-end=\"1223\"><strong data-start=\"1125\" data-end=\"1173\">Firmar acuerdo con proveedores de billeteras</strong> (BiPay &ndash; Bitel, y las siguientes que se sumen).</p>\n</li>\n<li data-start=\"1224\" data-end=\"1346\">\n<p data-start=\"1226\" data-end=\"1346\"><strong data-start=\"1226\" data-end=\"1263\">Explorar integraci&oacute;n con fintechs</strong> &rarr; Para interoperabilidad de pagos entre bancos, Yape/Plin y dinero digital BCRP.</p>\n</li>\n</ul>\n<p data-start=\"1348\" data-end=\"1416\">✅ Responsable: Gerencia Comercial BIDEX<br data-start=\"1387\" data-end=\"1390\">✅ Tiempo estimado: 1 mes</p>\n<hr data-start=\"1418\" data-end=\"1421\">\n<h2 data-start=\"1423\" data-end=\"1460\">4. <strong data-start=\"1429\" data-end=\"1460\">Infraestructura tecnol&oacute;gica</strong></h2>\n<ul data-start=\"1461\" data-end=\"2084\">\n<li data-start=\"1461\" data-end=\"1760\">\n<p data-start=\"1463\" data-end=\"1491\"><strong data-start=\"1463\" data-end=\"1489\">Backend en PHP (BIDEX)</strong></p>\n<ul data-start=\"1494\" data-end=\"1760\">\n<li data-start=\"1494\" data-end=\"1622\">\n<p data-start=\"1496\" data-end=\"1622\">Crear tabla <code data-start=\"1508\" data-end=\"1531\">operaciones_digitales</code> con: <code data-start=\"1537\" data-end=\"1541\">id</code>, <code data-start=\"1543\" data-end=\"1555\">cliente_id</code>, <code data-start=\"1557\" data-end=\"1564\">monto</code>, <code data-start=\"1566\" data-end=\"1574\">moneda</code>, <code data-start=\"1576\" data-end=\"1587\">wallet_id</code>, <code data-start=\"1589\" data-end=\"1609\">codigo_transaccion</code>, <code data-start=\"1611\" data-end=\"1619\">estado</code>.</p>\n</li>\n<li data-start=\"1625\" data-end=\"1760\">\n<p data-start=\"1627\" data-end=\"1760\">Adaptar m&oacute;dulo de tickets para registrar dinero digital como <strong data-start=\"1688\" data-end=\"1711\">nuevo medio de pago</strong> (igual que efectivo, transferencia o tarjeta).</p>\n</li>\n</ul>\n</li>\n<li data-start=\"1761\" data-end=\"1955\">\n<p data-start=\"1763\" data-end=\"1820\"><strong data-start=\"1763\" data-end=\"1782\">Integraci&oacute;n API</strong> (cuando BCRP lo abra p&uacute;blicamente):</p>\n<ul data-start=\"1823\" data-end=\"1955\">\n<li data-start=\"1823\" data-end=\"1889\">\n<p data-start=\"1825\" data-end=\"1889\">Conexi&oacute;n con endpoint para validar transacci&oacute;n en tiempo real.</p>\n</li>\n<li data-start=\"1892\" data-end=\"1955\">\n<p data-start=\"1894\" data-end=\"1955\">Registro autom&aacute;tico de operaci&oacute;n en la base de datos BIDEX.</p>\n</li>\n</ul>\n</li>\n<li data-start=\"1956\" data-end=\"2084\">\n<p data-start=\"1958\" data-end=\"2084\"><strong data-start=\"1958\" data-end=\"1984\">M&oacute;dulo de conciliaci&oacute;n</strong> &rarr; Mostrar saldos en dinero digital dentro del dashboard de BIDEX, igual que los saldos en bancos.</p>\n</li>\n</ul>\n<p data-start=\"2086\" data-end=\"2156\">✅ Responsable: &Aacute;rea de Sistemas BIDEX<br data-start=\"2123\" data-end=\"2126\">✅ Tiempo estimado: 2&ndash;3 meses</p>\n<hr data-start=\"2158\" data-end=\"2161\">\n<h2 data-start=\"2163\" data-end=\"2195\">5. <strong data-start=\"2169\" data-end=\"2195\">Capacitaci&oacute;n al equipo</strong></h2>\n<ul data-start=\"2196\" data-end=\"2423\">\n<li data-start=\"2196\" data-end=\"2423\">\n<p data-start=\"2198\" data-end=\"2246\">Capacitar al personal de ventanilla y digital:</p>\n<ul data-start=\"2249\" data-end=\"2423\">\n<li data-start=\"2249\" data-end=\"2292\">\n<p data-start=\"2251\" data-end=\"2292\">C&oacute;mo recibir y entregar dinero digital.</p>\n</li>\n<li data-start=\"2295\" data-end=\"2341\">\n<p data-start=\"2297\" data-end=\"2341\">C&oacute;mo verificar operaciones en tiempo real.</p>\n</li>\n<li data-start=\"2344\" data-end=\"2423\">\n<p data-start=\"2346\" data-end=\"2423\">Protocolos ante fallas (ejemplo: cliente sin saldo, transacci&oacute;n pendiente).</p>\n</li>\n</ul>\n</li>\n</ul>\n<p data-start=\"2425\" data-end=\"2495\">✅ Responsable: Recursos Humanos BIDEX<br data-start=\"2462\" data-end=\"2465\">✅ Tiempo estimado: 2 semanas</p>\n<hr data-start=\"2497\" data-end=\"2500\">\n<h2 data-start=\"2502\" data-end=\"2539\">6. <strong data-start=\"2508\" data-end=\"2539\">Lanzamiento piloto en BIDEX</strong></h2>\n<ul data-start=\"2540\" data-end=\"2991\">\n<li data-start=\"2540\" data-end=\"2629\">\n<p data-start=\"2542\" data-end=\"2629\"><strong data-start=\"2542\" data-end=\"2562\">Fase 1 (interno)</strong> &rarr; Hacer pruebas con colaboradores, simulando operaciones reales.</p>\n</li>\n<li data-start=\"2630\" data-end=\"2745\">\n<p data-start=\"2632\" data-end=\"2745\"><strong data-start=\"2632\" data-end=\"2667\">Fase 2 (clientes seleccionados)</strong> &rarr; Ofrecer dinero digital como opci&oacute;n de pago/recepci&oacute;n a un grupo reducido.</p>\n</li>\n<li data-start=\"2746\" data-end=\"2991\">\n<p data-start=\"2748\" data-end=\"2854\"><strong data-start=\"2748\" data-end=\"2777\">Fase 3 (apertura p&uacute;blica)</strong> &rarr; Comunicar oficialmente a los clientes en redes sociales y en ventanilla:</p>\n<blockquote data-start=\"2857\" data-end=\"2991\">\n<p data-start=\"2859\" data-end=\"2991\">&ldquo;Ahora en BIDEX puedes cambiar tus d&oacute;lares/euros y recibir tu dinero en <strong data-start=\"2931\" data-end=\"2958\">Dinero Digital del BCRP</strong>, r&aacute;pido, seguro y sin bancos.&rdquo;</p>\n</blockquote>\n</li>\n</ul>\n<p data-start=\"2993\" data-end=\"3066\">✅ Responsable: Marketing + Operaciones BIDEX<br data-start=\"3037\" data-end=\"3040\">✅ Tiempo estimado: 1 mes</p>\n<hr data-start=\"3068\" data-end=\"3071\">\n<h2 data-start=\"3073\" data-end=\"3104\">7. <strong data-start=\"3079\" data-end=\"3104\">Beneficios para BIDEX</strong></h2>\n<ul data-start=\"3105\" data-end=\"3509\">\n<li data-start=\"3105\" data-end=\"3168\">\n<p data-start=\"3107\" data-end=\"3168\"><strong data-start=\"3107\" data-end=\"3126\">Mayor clientela</strong>: captar usuarios sin cuentas bancarias.</p>\n</li>\n<li data-start=\"3169\" data-end=\"3252\">\n<p data-start=\"3171\" data-end=\"3252\"><strong data-start=\"3171\" data-end=\"3189\">Diferenciaci&oacute;n</strong>: pioneros en el uso de dinero digital en el rubro cambiario.</p>\n</li>\n<li data-start=\"3253\" data-end=\"3334\">\n<p data-start=\"3255\" data-end=\"3334\"><strong data-start=\"3255\" data-end=\"3283\">Seguridad y trazabilidad</strong>: menos riesgo de billetes falsos, m&aacute;s confianza.</p>\n</li>\n<li data-start=\"3335\" data-end=\"3422\">\n<p data-start=\"3337\" data-end=\"3422\"><strong data-start=\"3337\" data-end=\"3353\">Cumplimiento</strong>: operaciones registradas autom&aacute;ticamente en l&iacute;nea con SBS y SUNAT.</p>\n</li>\n<li data-start=\"3423\" data-end=\"3509\">\n<p data-start=\"3425\" data-end=\"3509\"><strong data-start=\"3425\" data-end=\"3439\">Eficiencia</strong>: transferencias inmediatas 24/7 sin depender de horarios bancarios.</p>\n</li>\n</ul>\n<hr data-start=\"3511\" data-end=\"3514\">\n<p data-start=\"3516\" data-end=\"3660\">📌 <strong data-start=\"3519\" data-end=\"3563\">Tiempo total estimado de implementaci&oacute;n:</strong> 4 a 6 meses.<br data-start=\"3576\" data-end=\"3579\">📌 <strong data-start=\"3582\" data-end=\"3606\">Inversi&oacute;n principal:</strong> desarrollo tecnol&oacute;gico y capacitaci&oacute;n del personal.</p>\n<p style=\"text-align: left;\">&nbsp;</p>\n<p>&nbsp;</p>','whatsapp',30,'minutos',0,NULL,'[]','2025-09-10 00:54:02','2025-09-10 00:54:21',NULL),(84,9,NULL,NULL,'COMPRAS MAVINAS','2025-09-05 09:00:00','2025-09-05 09:30:00',0,'BUSINESS DIVISAS','#fdc220','Centro Comercial Plaza Jesús María, 237, Jirón Mariscal Toribio Luzuriaga, Oyague, Jesús María, Lima, Lima Metropolitana, Lima, 15081, Perú','<p>COMPRAS DE MATERIALES DEFENSA CIVIL</p>\n<ul class=\"todo-list\">\n<li data-checked=\"false\" data-due=\"2025-09-05T09:00\" data-task=\"x57p6vdz\">&nbsp;CANALESTAS<span class=\"task-meta\" contenteditable=\"false\"> <span class=\"tag-due\">📅 2025-09-05 09:00</span></span></li>\n<li data-checked=\"false\" data-due=\"2025-09-05T09:00\" data-task=\"z5cppvhp\">&nbsp;TUPASA CABLES CORTADOS<span class=\"task-meta\" contenteditable=\"false\"> <span class=\"tag-due\">📅 2025-09-05 09:00</span></span></li>\n<li data-checked=\"false\" data-due=\"2025-09-05T09:00\" data-task=\"uya6xuwh\">&nbsp;TUBOS DE METAL PARA CORRIENTES<span class=\"task-meta\" contenteditable=\"false\"> <span class=\"tag-due\">📅 2025-09-05 09:00</span></span></li>\n</ul>','whatsapp',30,'minutos',0,NULL,'[]','2025-09-12 10:57:07','2025-09-12 10:58:48',NULL),(85,9,NULL,NULL,'COMPRAS MAVINAS','2025-09-12 09:00:00','2025-09-12 09:30:00',0,'BUSINESS DIVISAS','#0d6efd','Viale, Avenida Arnaldo Márquez, Oyague, Jesús María, Lima, Lima Metropolitana, Lima, 15081, Perú','<p>COMPRAS DE MATERIALES DEFENSA CIVIL</p>\n<ul class=\"todo-list\">\n<li data-checked=\"false\" data-due=\"2025-09-05T09:00\" data-task=\"x57p6vdz\">&nbsp;CANALESTAS<span class=\"task-meta\" contenteditable=\"false\"> <span class=\"tag-due\">📅 2025-09-05 09:00</span></span></li>\n<li data-checked=\"false\" data-due=\"2025-09-05T09:00\" data-task=\"z5cppvhp\">&nbsp;TUPASA CABLES CORTADOS<span class=\"task-meta\" contenteditable=\"false\"> <span class=\"tag-due\">📅 2025-09-05 09:00</span></span></li>\n<li data-checked=\"false\" data-due=\"2025-09-05T09:00\" data-task=\"uya6xuwh\">&nbsp;TUBOS DE METAL PARA CORRIENTES<span class=\"task-meta\" contenteditable=\"false\"> <span class=\"tag-due\">📅 2025-09-05 09:00</span></span></li>\n</ul>','whatsapp',30,'minutos',0,NULL,'[{\"id\":15}]','2025-09-12 10:59:43','2025-09-12 10:59:46',NULL),(86,11,NULL,NULL,'presentación de avances','2025-09-12 06:15:00','2025-09-12 07:00:00',0,'BUSINESS DIVISAS','#FFEDBD','','<p>envios de saldos</p>\n<p>envios de estados de cuenta</p>','whatsapp',30,'minutos',0,NULL,'[{\"id\":9}]','2025-09-12 11:02:57','2025-09-12 11:10:36',NULL),(98,1,NULL,NULL,'COMBATE DE ANGAMOS','2025-10-08 01:00:00','2025-10-08 01:15:00',0,'BUSINESS DIVISAS','#FF6666','Jirón Coronel Pascual Saco Oliveros, Santa Beatriz, Jesús María, Lima, Lima Metropolitana, Lima, 15106, Perú','<ul class=\"todo-list\">\n<li data-checked=\"false\">SUBIR A ESTADO LA MISMA FOTO/VIDEO&nbsp; (1 SEMANA)</li>\n<li data-checked=\"false\">VIDEO</li>\n<li data-checked=\"false\">IMAGE</li>\n</ul>','whatsapp',30,'minutos',0,NULL,'[{\"id\":9}]','2025-09-17 15:19:01','2025-09-17 15:19:01','[]'),(99,1,NULL,NULL,'DIA DE TODOS LOS SANTOS','2025-11-01 01:00:00','2025-11-01 01:30:00',0,'BUSINESS DIVISAS','#FF6666','Jirón Coronel Pascual Saco Oliveros, Santa Beatriz, Jesús María, Lima, Lima Metropolitana, Lima, 15106, Perú','<ul class=\"todo-list\">\n<li data-checked=\"false\">SUBIR A ESTADO LA MISMA FOTO/VIDEO&nbsp; (1 SEMANA)</li>\n<li data-checked=\"false\">VIDEO</li>\n<li data-checked=\"false\">IMAGE</li>\n</ul>','whatsapp',30,'minutos',0,NULL,'[{\"id\":9}]','2025-09-17 15:19:48','2025-09-17 15:19:48','[]'),(100,1,NULL,NULL,'VIRGEN INMACULADA CONCEPCIÓN','2025-12-08 01:00:00','2025-12-08 01:30:00',0,'BUSINESS DIVISAS','#FF6666','Jirón Coronel Pascual Saco Oliveros, Santa Beatriz, Jesús María, Lima, Lima Metropolitana, Lima, 15106, Perú','<ul class=\"todo-list\">\n<li data-checked=\"false\">SUBIR A ESTADO LA MISMA FOTO/VIDEO&nbsp; (1 SEMANA)</li>\n<li data-checked=\"false\">VIDEO</li>\n<li data-checked=\"false\">IMAGE</li>\n</ul>','whatsapp',30,'minutos',0,NULL,'[{\"id\":9}]','2025-09-17 15:20:31','2025-09-17 15:20:31','[]'),(101,1,NULL,NULL,'NAVIDAD','2025-12-25 01:00:00','2025-12-25 01:30:00',0,'BUSINESS DIVISAS','#FF6666','Jirón Coronel Pascual Saco Oliveros, Santa Beatriz, Jesús María, Lima, Lima Metropolitana, Lima, 15106, Perú','<ul class=\"todo-list\">\n<li data-checked=\"false\" data-task=\"rr2xqzht\">SUBIR A ESTADO LA MISMA FOTO/VIDEO&nbsp; (1 SEMANA)</li>\n<li data-checked=\"false\" data-task=\"br6001xd\">VIDEO</li>\n<li data-checked=\"false\" data-task=\"e06sdmfd\">IMAGE</li>\n</ul>','whatsapp',30,'minutos',0,NULL,'[{\"id\":9}]','2025-09-17 15:20:50','2025-09-17 15:20:56','[]'),(102,1,NULL,NULL,'AÑO NUEVO','2026-01-01 01:00:00','2026-01-01 01:30:00',0,'BUSINESS DIVISAS','#FF6666','Jirón Coronel Pascual Saco Oliveros, Santa Beatriz, Jesús María, Lima, Lima Metropolitana, Lima, 15106, Perú','<p>&nbsp;</p>\n<ul class=\"todo-list\">\n<li data-checked=\"false\">SUBIR A ESTADO LA MISMA FOTO/VIDEO&nbsp; (1 SEMANA)</li>\n<li data-checked=\"false\">VIDEO</li>\n<li data-checked=\"false\">IMAGE</li>\n</ul>','whatsapp',30,'minutos',0,NULL,'[{\"id\":9}]','2025-09-17 15:21:14','2025-09-17 15:21:14','[]'),(103,1,NULL,NULL,'HALLOWEEN/CANCION CRIOLLA','2025-10-31 01:00:00','2025-10-31 01:30:00',0,'BUSINESS DIVISAS','#FF6666','Avenida de la Peruanidad, Santa Beatriz, Jesús María, Lima, Lima Metropolitana, Lima, 15083, Perú','<ul class=\"todo-list\">\n<li data-checked=\"false\">SUBIR A ESTADO LA MISMA FOTO/VIDEO&nbsp; (1 SEMANA)</li>\n<li data-checked=\"false\">VIDEO</li>\n<li data-checked=\"false\">IMAGE</li>\n</ul>','whatsapp',30,'minutos',0,NULL,'[{\"id\":9}]','2025-09-18 13:46:02','2025-09-18 13:46:02','[]'),(104,1,NULL,NULL,'JUEVES SANTO','2026-04-02 01:00:00','2026-04-02 01:30:00',0,'BUSINESS DIVISAS','#FF6666','Avenida de la Peruanidad, Santa Beatriz, Jesús María, Lima, Lima Metropolitana, Lima, 15083, Perú','<ul class=\"todo-list\">\n<li data-checked=\"false\">SUBIR A ESTADO LA MISMA FOTO/VIDEO&nbsp; (1 SEMANA)</li>\n<li data-checked=\"false\">VIDEO</li>\n<li data-checked=\"false\">IMAGE</li>\n</ul>','whatsapp',30,'minutos',0,NULL,'[{\"id\":9}]','2025-09-18 13:47:03','2025-09-18 13:47:03','[]'),(105,1,NULL,NULL,'VIERNES SANTO','2026-04-03 01:00:00','2026-04-03 01:30:00',0,'BUSINESS DIVISAS','#FF6666','Avenida de la Peruanidad, Santa Beatriz, Jesús María, Lima, Lima Metropolitana, Lima, 15083, Perú','<ul class=\"todo-list\">\n<li data-checked=\"false\">SUBIR A ESTADO LA MISMA FOTO/VIDEO&nbsp; (1 SEMANA)</li>\n<li data-checked=\"false\">VIDEO</li>\n<li data-checked=\"false\">IMAGE</li>\n</ul>','whatsapp',30,'minutos',0,NULL,'[{\"id\":9}]','2025-09-18 13:47:24','2025-09-18 13:47:24','[]'),(106,1,NULL,NULL,'DIA DEL TRABAJO','2026-05-01 01:00:00','2026-05-01 01:30:00',0,'BUSINESS DIVISAS','#FF6666','Avenida de la Peruanidad, Santa Beatriz, Jesús María, Lima, Lima Metropolitana, Lima, 15083, Perú','<ul class=\"todo-list\">\n<li data-checked=\"false\">SUBIR A ESTADO LA MISMA FOTO/VIDEO&nbsp; (1 SEMANA)</li>\n<li data-checked=\"false\">VIDEO</li>\n<li data-checked=\"false\">IMAGE</li>\n</ul>','whatsapp',30,'minutos',0,NULL,'[{\"id\":9}]','2025-09-18 13:48:08','2025-09-18 13:48:08','[]'),(107,1,NULL,NULL,'SAN PEDRO Y SAN PABLO','2026-06-29 01:00:00','2026-06-29 01:30:00',0,'BUSINESS DIVISAS','#FF6666','Avenida de la Peruanidad, Santa Beatriz, Jesús María, Lima, Lima Metropolitana, Lima, 15083, Perú','<ul class=\"todo-list\">\n<li data-checked=\"false\">SUBIR A ESTADO LA MISMA FOTO/VIDEO&nbsp; (1 SEMANA)</li>\n<li data-checked=\"false\">VIDEO</li>\n<li data-checked=\"false\">IMAGE</li>\n</ul>','whatsapp',30,'minutos',0,NULL,'[{\"id\":9}]','2025-09-18 13:48:42','2025-09-18 13:48:42','[]'),(108,1,NULL,NULL,'FIESTAS PATRIAS - 28','2026-07-28 01:00:00','2026-07-28 01:30:00',0,'BUSINESS DIVISAS','#FF6666','Avenida de la Peruanidad, Santa Beatriz, Jesús María, Lima, Lima Metropolitana, Lima, 15083, Perú','<ul class=\"todo-list\">\n<li data-checked=\"false\">SUBIR A ESTADO LA MISMA FOTO/VIDEO&nbsp; (1 SEMANA)</li>\n<li data-checked=\"false\">VIDEO</li>\n<li data-checked=\"false\">IMAGE</li>\n</ul>','whatsapp',30,'minutos',0,NULL,'[{\"id\":9}]','2025-09-18 13:49:23','2025-09-18 13:49:23','[]'),(109,1,NULL,NULL,'FIESTAS PARTIAS - 29','2026-07-29 01:00:00','2026-07-29 01:30:00',0,'BUSINESS DIVISAS','#FF6666','Avenida de la Peruanidad, Santa Beatriz, Jesús María, Lima, Lima Metropolitana, Lima, 15083, Perú','<ul class=\"todo-list\">\n<li data-checked=\"false\">SUBIR A ESTADO LA MISMA FOTO/VIDEO&nbsp; (1 SEMANA)</li>\n<li data-checked=\"false\">VIDEO</li>\n<li data-checked=\"false\">IMAGE</li>\n</ul>','whatsapp',30,'minutos',0,NULL,'[{\"id\":9}]','2025-09-18 13:49:47','2025-09-18 13:49:47','[]'),(110,1,NULL,NULL,'SANTA ROSA DE LIMA','2026-08-30 01:00:00','2026-08-30 01:30:00',0,'BUSINESS DIVISAS','#FF6666','Avenida de la Peruanidad, Santa Beatriz, Jesús María, Lima, Lima Metropolitana, Lima, 15083, Perú','<ul class=\"todo-list\">\n<li data-checked=\"false\">SUBIR A ESTADO LA MISMA FOTO/VIDEO&nbsp; (1 SEMANA)</li>\n<li data-checked=\"false\">VIDEO</li>\n<li data-checked=\"false\">IMAGE</li>\n</ul>','whatsapp',30,'minutos',0,NULL,'[{\"id\":9}]','2025-09-18 13:50:15','2025-09-18 13:50:15','[]'),(111,1,NULL,NULL,'COMBATE DE ANGAMOS','2026-10-08 01:00:00','2026-10-08 01:30:00',0,'BUSINESS DIVISAS','#FF6666','Avenida de la Peruanidad, Santa Beatriz, Jesús María, Lima, Lima Metropolitana, Lima, 15083, Perú','<ul class=\"todo-list\">\n<li data-checked=\"false\">SUBIR A ESTADO LA MISMA FOTO/VIDEO&nbsp; (1 SEMANA)</li>\n<li data-checked=\"false\">VIDEO</li>\n<li data-checked=\"false\">IMAGE</li>\n</ul>','whatsapp',30,'minutos',0,NULL,'[{\"id\":9}]','2025-09-18 13:50:44','2025-09-18 13:50:44','[]'),(112,1,NULL,NULL,'HALLOWEEN / CANCION CRIOLLA','2026-10-31 01:00:00','2026-10-31 01:30:00',0,'BUSINESS DIVISAS','#FF6666','Avenida de la Peruanidad, Santa Beatriz, Jesús María, Lima, Lima Metropolitana, Lima, 15083, Perú','<ul class=\"todo-list\">\n<li data-checked=\"false\">SUBIR A ESTADO LA MISMA FOTO/VIDEO&nbsp; (1 SEMANA)</li>\n<li data-checked=\"false\">VIDEO</li>\n<li data-checked=\"false\">IMAGE</li>\n</ul>','whatsapp',30,'minutos',0,NULL,'[{\"id\":9}]','2025-09-18 13:51:25','2025-09-18 13:51:25','[]'),(115,1,NULL,NULL,'DIA DE TODOS LOS SANTOS','2026-11-01 01:00:00','2026-11-01 01:30:00',0,'BUSINESS DIVISAS','#FF6666','Avenida de la Peruanidad, Santa Beatriz, Jesús María, Lima, Lima Metropolitana, Lima, 15083, Perú','<ul class=\"todo-list\">\n<li data-checked=\"false\">SUBIR A ESTADO LA MISMA FOTO/VIDEO&nbsp; (1 SEMANA)</li>\n<li data-checked=\"false\">VIDEO</li>\n<li data-checked=\"false\">IMAGE</li>\n</ul>','whatsapp',30,'minutos',0,NULL,'[{\"id\":9}]','2025-09-18 13:53:06','2025-09-18 13:53:06','[]'),(116,1,NULL,NULL,'INMACULADA CONCEPCIÓN','2026-12-08 01:00:00','2026-12-08 01:30:00',0,'BUSINESS DIVISAS','#FF6666','Avenida de la Peruanidad, Santa Beatriz, Jesús María, Lima, Lima Metropolitana, Lima, 15083, Perú','<ul class=\"todo-list\">\n<li data-checked=\"false\">SUBIR A ESTADO LA MISMA FOTO/VIDEO&nbsp; (1 SEMANA)</li>\n<li data-checked=\"false\">VIDEO</li>\n<li data-checked=\"false\">IMAGE</li>\n</ul>','whatsapp',30,'minutos',0,NULL,'[{\"id\":9}]','2025-09-18 13:54:21','2025-09-18 13:54:21','[]'),(117,1,NULL,NULL,'NAVIDAD','2026-12-25 01:00:00','2026-12-25 01:30:00',0,'BUSINESS DIVISAS','#FF6666','Avenida de la Peruanidad, Santa Beatriz, Jesús María, Lima, Lima Metropolitana, Lima, 15083, Perú','<ul class=\"todo-list\">\n<li data-checked=\"false\">SUBIR A ESTADO LA MISMA FOTO/VIDEO&nbsp; (1 SEMANA)</li>\n<li data-checked=\"false\">VIDEO</li>\n<li data-checked=\"false\">IMAGE</li>\n</ul>','whatsapp',30,'minutos',0,NULL,'[{\"id\":9}]','2025-09-18 13:54:42','2025-09-18 13:54:42','[]'),(118,1,NULL,NULL,'AÑO NUEVO','2027-01-01 01:00:00','2027-01-01 01:30:00',0,'BUSINESS DIVISAS','#FF6666','Avenida de la Peruanidad, Santa Beatriz, Jesús María, Lima, Lima Metropolitana, Lima, 15083, Perú','<ul class=\"todo-list\">\n<li data-checked=\"false\">SUBIR A ESTADO LA MISMA FOTO/VIDEO&nbsp; (1 SEMANA)</li>\n<li data-checked=\"false\">VIDEO</li>\n<li data-checked=\"false\">IMAGE</li>\n</ul>','whatsapp',30,'minutos',0,NULL,'[{\"id\":9}]','2025-09-18 13:55:00','2025-09-18 13:55:00','[]'),(119,1,NULL,NULL,'PRUEBAA','2025-09-24 07:00:00','2025-09-24 07:30:00',0,'3TMI','#FF6666','RENIEC, 130 - 132 - 134 Y 136, Jirón Talara, Oyague, Jesús María, Lima, Lima Metropolitana, Lima, 15083, Perú','<p><span class=\"tag-user\" contenteditable=\"false\" data-uid=\"1\">@SOFIA JOSELIN CAJAHUAMAN</span> <span class=\"tag-user\" contenteditable=\"false\" data-uid=\"13\">@Carlos Silva</span>&nbsp;</p>\n<ul class=\"todo-list\">\n<li data-checked=\"false\">TAREA</li>\n</ul>','whatsapp',30,'minutos',0,NULL,'[{\"id\":13}]','2025-09-24 12:05:59','2025-09-24 12:05:59','[{\"key\": \"wr00b56a\", \"done\": 0, \"title\": \"TAREA\", \"due_at\": null, \"assigned_to\": 1}]'),(120,9,NULL,NULL,'Capacitación Sistemas ventas wasap','2025-09-24 08:15:00','2025-09-24 09:00:00',0,'BUSINESS DIVISAS','#fdc220','','<p><span class=\"tag-user\" contenteditable=\"false\" data-uid=\"1\">@SOFIA JOSELIN CAJAHUAMAN</span>&nbsp;</p>\n<ul class=\"todo-list\">\n<li data-checked=\"false\" data-task=\"mgpy0xxg\">​ Grabar&nbsp;</li>\n<li data-checked=\"false\" data-task=\"f48bmpvo\">Realizar PPT</li>\n</ul>\n<p>&nbsp;</p>\n<p><span class=\"tag-user\" contenteditable=\"false\" data-uid=\"13\">@Carlos Silva</span>&nbsp;</p>\n<ul class=\"todo-list\">\n<li data-checked=\"false\" data-task=\"xv8t0ar3\">​Capacitar</li>\n</ul>\n<p><span class=\"tag-user\" contenteditable=\"false\" data-uid=\"18\">@Thania Alexandra Escalante Cardenas</span> <span style=\"text-decoration: underline;\"><strong>Transferencias</strong></span></p>\n<p>&nbsp;</p>\n<p>&nbsp;<span class=\"tag-user\" contenteditable=\"false\" data-uid=\"19\">@Natividad Emilia Ochoa Rumiche</span> <span class=\"tag-user\" contenteditable=\"false\" data-uid=\"15\">@Antuanet Yasuri Mozo Albarez</span> &nbsp;<span style=\"text-decoration: underline;\"><strong>Ventas Wasap 1,2,3</strong></span></p>\n<p><span class=\"tag-user\" contenteditable=\"false\" data-uid=\"11\">@Nayumi Vara Atunca</span>&nbsp;</p>\n<p><span class=\"tag-user\" contenteditable=\"false\" data-uid=\"9\">@GRIMALDO VARA</span>&nbsp;</p>','whatsapp',30,'minutos',0,NULL,'[{\"id\":15},{\"id\":12},{\"id\":13},{\"id\":19},{\"id\":11},{\"id\":1},{\"id\":18}]','2025-09-24 12:08:13','2025-09-24 12:12:02','[{\"key\": \"mgpy0xxg\", \"done\": 0, \"title\": \"​ Grabar\", \"due_at\": null, \"assigned_to\": 1}, {\"key\": \"f48bmpvo\", \"done\": 0, \"title\": \"Realizar PPT\", \"due_at\": null, \"assigned_to\": 1}, {\"key\": \"xv8t0ar3\", \"done\": 0, \"title\": \"​Capacitar\", \"due_at\": null, \"assigned_to\": 13}]'),(121,28,NULL,NULL,'ENTREVISTA - CONSULTA LEGAL','2025-09-28 13:00:00','2025-09-28 14:30:00',0,'PERSONAL','#4285f4','SAN ISIDRO','<p>ENTREVISTA - CONSULTA LEGAL A DOMICILIO</p>','whatsapp',30,'minutos',0,NULL,'[]','2025-09-27 15:36:24','2025-09-27 15:36:33','[]'),(122,9,NULL,NULL,'SALUD','2025-09-29 05:00:00','2025-09-29 05:30:00',0,'PERSONAL','#ea4335','','<p>INSULINA</p>\n<p>ALIMENTACION</p>\n<p>ACTIVIDAD FISICA</p>\n<p>METAS DE PESO</p>\n<p>SUE&Ntilde;O ADECUADO</p>\n<p>LSITA DE EXAMENES&nbsp;</p>','whatsapp',30,'minutos',0,NULL,'[]','2025-09-29 00:42:51','2025-09-29 00:42:54','[]'),(123,9,NULL,NULL,'CLINICAS','2025-09-30 06:30:00','2025-09-30 07:00:00',0,'PERSONAL','#ea4335','','<p><span class=\"tag-user\" contenteditable=\"false\" data-uid=\"12\">@BRENDA XIOMARA BAZALAR MU&Ntilde;OZ</span>&nbsp;</p>\n<p>CLINICAS</p>\n<ul>\n<li>Horario</li>\n<li>costo</li>\n<li>citas</li>\n<li>entrega de resultados&nbsp; ( wasap, Correo, etc)</li>\n</ul>\n<p><strong data-start=\"348\" data-end=\"381\">1) SYNLAB Per&uacute; (red de sedes)</strong> &ndash; hacen OGTT y detallan indicaciones (ayuno 8 h, permanencia 3 h, 75 g glucosa). Ideal si necesitas OGTT. <span class=\"\" data-state=\"closed\"><span class=\"ms-1 inline-flex max-w-full items-center relative top-[-0.094rem] animate-[show_150ms_ease-in]\" data-testid=\"webpage-citation-pill\"><a class=\"flex h-4.5 overflow-hidden rounded-xl px-2 text-[9px] font-medium transition-colors duration-150 ease-in-out text-token-text-secondary! bg-[#F4F4F4]! dark:bg-[#303030]!\" href=\"https://www.synlab.pe/analisis-clinicos/CUS6932-p1762-tolerancia-insulina-y-glucosa-basal-60-120?utm_source=chatgpt.com\" target=\"_blank\" rel=\"noopener\"><span class=\"relative start-0 bottom-0 flex h-full w-full items-center\"><span class=\"flex h-4 w-full items-center justify-between\"><span class=\"max-w-[15ch] grow truncate overflow-hidden text-center\">SYNLAB Per&uacute;</span><span class=\"-me-1 flex h-full items-center rounded-full px-1 text-[#8F8F8F]\">+1</span></span></span></a></span></span></p>\n<p><span class=\"\" data-state=\"closed\">2)&nbsp;<strong data-start=\"956\" data-end=\"1005\"> Cl&iacute;nica Internacional (sede Lima, Cercado)</strong> &ndash; laboratorio con <strong data-start=\"1024\" data-end=\"1044\">amplios horarios</strong>, &uacute;til si buscas centro integral (consulta + an&aacute;lisis). <span class=\"ms-1 inline-flex max-w-full items-center relative top-[-0.094rem] animate-[show_150ms_ease-in]\" data-testid=\"webpage-citation-pill\"><a class=\"flex h-4.5 overflow-hidden rounded-xl px-2 text-[9px] font-medium transition-colors duration-150 ease-in-out text-token-text-secondary! bg-[#F4F4F4]! dark:bg-[#303030]!\" href=\"https://clinicainternacional.com.pe/sede/lima/?utm_source=chatgpt.com\" target=\"_blank\" rel=\"noopener\"><span class=\"relative start-0 bottom-0 flex h-full w-full items-center\"><span class=\"flex h-4 w-full items-center justify-between\"><span class=\"max-w-[15ch] grow truncate overflow-hidden text-center\">Cl&iacute;nica Internacional</span><span class=\"-me-1 flex h-full items-center rounded-full px-1 text-[#8F8F8F]\">+1</span></span></span></a></span></span></p>','whatsapp',30,'minutos',0,NULL,'[{\"id\":12}]','2025-09-30 11:34:03','2025-09-30 14:03:14','[]'),(124,9,NULL,NULL,'INSTALACION DE CAMARAS 212 315','2025-10-08 05:45:00','2025-10-08 06:15:00',0,'BUSINESS DIVISAS','#FFEDBD','Colegio Francisco de Zela, 1658, Jirón Loreto, Nosiglia Etapa Dos, Breña, Lima, Lima Metropolitana, Lima, 15081, Perú','<p>LOCAL 315</p>\n<ul class=\"todo-list\">\n<li data-checked=\"false\" data-task=\"ozx80gwz\">4 CAMARAS DVR 16 (M1)</li>\n</ul>\n<p>OFICINA 212</p>\n<ul class=\"todo-list\">\n<li data-checked=\"false\" data-task=\"f58i28d0\">&nbsp;3 CAMARAS</li>\n</ul>\n<p>&nbsp;</p>','whatsapp',30,'minutos',0,NULL,'[]','2025-10-06 10:59:16','2025-10-06 10:59:45','[]'),(128,12,NULL,24,'NAYUMI AUDITORÍA Y CONTROL INTERNO EMPRESARIAL','2025-11-24 20:00:00','2025-11-24 22:00:00',0,'BUSINESS DIVISAS','#6993FF','','<p>ESPECIALIZACION AUDITOR&Iacute;A Y CONTROL INTERNO&nbsp;EMPRESARIAL</p>','whatsapp',30,'minutos',0,NULL,'[{\"id\":11}]','2025-10-25 16:28:02','2025-10-25 16:30:23','[]'),(130,12,NULL,24,'NAYUMI AUDITORÍA Y CONTROL INTERNO EMPRESARIAL','2025-11-27 20:00:00','2025-11-27 22:00:00',0,'BUSINESS DIVISAS','#6993FF',NULL,'<p>ESPECIALIZACION AUDITORÍA Y CONTROL INTERNO EMPRESARIAL</p>','whatsapp',30,'minutos',0,NULL,'[{\"id\":11}]','2025-10-25 16:37:36','2025-10-25 16:37:36','[]'),(131,12,NULL,24,'NAYUMI AUDITORÍA Y CONTROL INTERNO EMPRESARIAL','2025-12-01 20:00:00','2025-12-01 22:00:00',0,'BUSINESS DIVISAS','#6993FF',NULL,'<p>ESPECIALIZACION AUDITORÍA Y CONTROL INTERNO EMPRESARIAL</p>','whatsapp',30,'minutos',0,NULL,'[{\"id\":11}]','2025-10-25 16:37:36','2025-10-25 16:37:36','[]'),(132,12,NULL,24,'NAYUMI AUDITORÍA Y CONTROL INTERNO EMPRESARIAL','2025-12-04 20:00:00','2025-12-04 22:00:00',0,'BUSINESS DIVISAS','#6993FF',NULL,'<p>ESPECIALIZACION AUDITORÍA Y CONTROL INTERNO EMPRESARIAL</p>','whatsapp',30,'minutos',0,NULL,'[{\"id\":11}]','2025-10-25 16:37:36','2025-10-25 16:37:36','[]'),(133,12,NULL,24,'NAYUMI AUDITORÍA Y CONTROL INTERNO EMPRESARIAL','2025-12-11 20:00:00','2025-12-11 22:00:00',0,'BUSINESS DIVISAS','#6993FF',NULL,'<p>ESPECIALIZACION AUDITORÍA Y CONTROL INTERNO EMPRESARIAL</p>','whatsapp',30,'minutos',0,NULL,'[{\"id\":11}]','2025-10-25 16:37:36','2025-10-25 16:37:36','[]'),(134,12,NULL,24,'NAYUMI AUDITORÍA Y CONTROL INTERNO EMPRESARIAL','2025-12-15 20:00:00','2025-12-15 22:00:00',0,'BUSINESS DIVISAS','#6993FF',NULL,'<p>ESPECIALIZACION AUDITORÍA Y CONTROL INTERNO EMPRESARIAL</p>','whatsapp',30,'minutos',0,NULL,'[{\"id\":11}]','2025-10-25 16:37:36','2025-10-25 16:37:36','[]'),(135,12,NULL,24,'NAYUMI AUDITORÍA Y CONTROL INTERNO EMPRESARIAL','2025-12-18 20:00:00','2025-12-18 22:00:00',0,'BUSINESS DIVISAS','#6993FF',NULL,'<p>ESPECIALIZACION AUDITORÍA Y CONTROL INTERNO EMPRESARIAL</p>','whatsapp',30,'minutos',0,NULL,'[{\"id\":11}]','2025-10-25 16:37:36','2025-10-25 16:37:36','[]'),(136,12,NULL,24,'NAYUMI AUDITORÍA Y CONTROL INTERNO EMPRESARIAL','2026-01-05 20:00:00','2026-01-05 22:00:00',0,'BUSINESS DIVISAS','#6993FF',NULL,'<p>ESPECIALIZACION AUDITORÍA Y CONTROL INTERNO EMPRESARIAL</p>','whatsapp',30,'minutos',0,NULL,'[{\"id\":11}]','2025-10-25 16:37:36','2025-10-25 16:37:36','[]'),(137,12,NULL,24,'NAYUMI AUDITORÍA Y CONTROL INTERNO EMPRESARIAL','2026-01-08 20:00:00','2026-01-08 22:00:00',0,'BUSINESS DIVISAS','#6993FF',NULL,'<p>ESPECIALIZACION AUDITORÍA Y CONTROL INTERNO EMPRESARIAL</p>','whatsapp',30,'minutos',0,NULL,'[{\"id\":11}]','2025-10-25 16:37:36','2025-10-25 16:37:36','[]'),(138,12,NULL,24,'NAYUMI AUDITORÍA Y CONTROL INTERNO EMPRESARIAL','2026-01-12 20:00:00','2026-01-12 22:00:00',0,'BUSINESS DIVISAS','#6993FF',NULL,'<p>ESPECIALIZACION AUDITORÍA Y CONTROL INTERNO EMPRESARIAL</p>','whatsapp',30,'minutos',0,NULL,'[{\"id\":11}]','2025-10-25 16:37:36','2025-10-25 16:37:36','[]'),(139,12,NULL,24,'NAYUMI AUDITORÍA Y CONTROL INTERNO EMPRESARIAL','2026-01-15 20:00:00','2026-01-15 22:00:00',0,'BUSINESS DIVISAS','#6993FF',NULL,'<p>ESPECIALIZACION AUDITORÍA Y CONTROL INTERNO EMPRESARIAL</p>','whatsapp',30,'minutos',0,NULL,'[{\"id\":11}]','2025-10-25 16:37:36','2025-10-25 16:37:36','[]'),(140,12,NULL,24,'NAYUMI AUDITORÍA Y CONTROL INTERNO EMPRESARIAL','2026-01-19 20:00:00','2026-01-19 22:00:00',0,'BUSINESS DIVISAS','#6993FF',NULL,'<p>ESPECIALIZACION AUDITORÍA Y CONTROL INTERNO EMPRESARIAL</p>','whatsapp',30,'minutos',0,NULL,'[{\"id\":11}]','2025-10-25 16:37:36','2025-10-25 16:37:36','[]'),(141,12,NULL,24,'NAYUMI AUDITORÍA Y CONTROL INTERNO EMPRESARIAL','2026-01-22 20:00:00','2026-01-22 22:00:00',0,'BUSINESS DIVISAS','#6993FF',NULL,'<p>ESPECIALIZACION AUDITORÍA Y CONTROL INTERNO EMPRESARIAL</p>','whatsapp',30,'minutos',0,NULL,'[{\"id\":11}]','2025-10-25 16:37:36','2025-10-25 16:37:36','[]'),(142,12,NULL,24,'NAYUMI AUDITORÍA Y CONTROL INTERNO EMPRESARIAL','2026-01-26 20:00:00','2026-01-26 22:00:00',0,'BUSINESS DIVISAS','#6993FF',NULL,'<p>ESPECIALIZACION AUDITORÍA Y CONTROL INTERNO EMPRESARIAL</p>','whatsapp',30,'minutos',0,NULL,'[{\"id\":11}]','2025-10-25 16:37:36','2025-10-25 16:37:36','[]'),(143,12,NULL,24,'NAYUMI AUDITORÍA Y CONTROL INTERNO EMPRESARIAL','2026-01-29 20:00:00','2026-01-29 22:00:00',0,'BUSINESS DIVISAS','#6993FF',NULL,'<p>ESPECIALIZACION AUDITORÍA Y CONTROL INTERNO EMPRESARIAL</p>','whatsapp',30,'minutos',0,NULL,'[{\"id\":11}]','2025-10-25 16:37:36','2025-10-25 16:37:36','[]'),(144,12,NULL,24,'NAYUMI AUDITORÍA Y CONTROL INTERNO EMPRESARIAL','2026-02-02 20:00:00','2026-02-02 22:00:00',0,'BUSINESS DIVISAS','#6993FF',NULL,'<p>ESPECIALIZACION AUDITORÍA Y CONTROL INTERNO EMPRESARIAL</p>','whatsapp',30,'minutos',0,NULL,'[{\"id\":11}]','2025-10-25 16:37:36','2025-10-25 16:37:36','[]'),(145,12,NULL,24,'NAYUMI AUDITORÍA Y CONTROL INTERNO EMPRESARIAL','2026-02-05 20:00:00','2026-02-05 22:00:00',0,'BUSINESS DIVISAS','#6993FF',NULL,'<p>ESPECIALIZACION AUDITORÍA Y CONTROL INTERNO EMPRESARIAL</p>','whatsapp',30,'minutos',0,NULL,'[{\"id\":11}]','2025-10-25 16:37:36','2025-10-25 16:37:36','[]'),(146,12,NULL,24,'NAYUMI AUDITORÍA Y CONTROL INTERNO EMPRESARIAL','2026-02-09 20:00:00','2026-02-09 22:00:00',0,'BUSINESS DIVISAS','#6993FF',NULL,'<p>ESPECIALIZACION AUDITORÍA Y CONTROL INTERNO EMPRESARIAL</p>','whatsapp',30,'minutos',0,NULL,'[{\"id\":11}]','2025-10-25 16:37:36','2025-10-25 16:37:36','[]'),(147,12,NULL,24,'NAYUMI AUDITORÍA Y CONTROL INTERNO EMPRESARIAL','2026-02-12 20:00:00','2026-02-12 22:00:00',0,'BUSINESS DIVISAS','#6993FF',NULL,'<p>ESPECIALIZACION AUDITORÍA Y CONTROL INTERNO EMPRESARIAL</p>','whatsapp',30,'minutos',0,NULL,'[{\"id\":11}]','2025-10-25 16:37:36','2025-10-25 16:37:36','[]'),(148,12,NULL,24,'NAYUMI AUDITORÍA Y CONTROL INTERNO EMPRESARIAL','2026-02-16 20:00:00','2026-02-16 22:00:00',0,'BUSINESS DIVISAS','#6993FF',NULL,'<p>ESPECIALIZACION AUDITORÍA Y CONTROL INTERNO EMPRESARIAL</p>','whatsapp',30,'minutos',0,NULL,'[{\"id\":11}]','2025-10-25 16:37:36','2025-10-25 16:37:36','[]'),(149,12,NULL,24,'NAYUMI AUDITORÍA Y CONTROL INTERNO EMPRESARIAL','2026-02-19 20:00:00','2026-02-19 22:00:00',0,'BUSINESS DIVISAS','#6993FF',NULL,'<p>ESPECIALIZACION AUDITORÍA Y CONTROL INTERNO EMPRESARIAL</p>','whatsapp',30,'minutos',0,NULL,'[{\"id\":11}]','2025-10-25 16:37:36','2025-10-25 16:37:36','[]'),(150,12,NULL,24,'NAYUMI AUDITORÍA Y CONTROL INTERNO EMPRESARIAL','2026-02-23 20:00:00','2026-02-23 22:00:00',0,'BUSINESS DIVISAS','#6993FF',NULL,'<p>ESPECIALIZACION AUDITORÍA Y CONTROL INTERNO EMPRESARIAL</p>','whatsapp',30,'minutos',0,NULL,'[{\"id\":11}]','2025-10-25 16:37:36','2025-10-25 16:37:36','[]'),(151,21,NULL,3,'CAPACITACION SBS','2025-11-04 08:45:00','2025-11-04 09:15:00',0,'BUSINESS DIVISAS','#fdc220','315','<ul>\n<li>PIUNTO PUN</li>\n</ul>\n<p>&nbsp;</p>\n<p>&nbsp;</p>','whatsapp',30,'minutos',0,NULL,'[{\"id\":9}]','2025-11-04 13:52:14','2025-11-04 13:56:04','[]'),(152,11,NULL,NULL,'CAPACITACION DE BENEFICIARIO FINAL','2025-11-15 08:15:00','2025-11-15 08:45:00',0,'BUSINESS DIVISAS','#C4FFBD','','','whatsapp',30,'minutos',0,NULL,'[]','2025-11-14 13:29:03','2025-11-14 13:29:10','[]'),(153,1,NULL,NULL,'ERP- GESTION DE RECURSOS HUMANOS','2026-01-03 11:00:00','2026-01-03 17:00:00',0,'3TMI','#FF6666','','<p dir=\"ltr\"><strong>MODULO 1:</strong></p>\n<ol>\n<li dir=\"ltr\" aria-level=\"1\">\n<p dir=\"ltr\" role=\"presentation\">Empleados (Legajo)</p>\n</li>\n</ol>\n<ul>\n<li dir=\"ltr\" aria-level=\"1\">\n<p dir=\"ltr\" role=\"presentation\">Datos personales, cargo, sede/&aacute;rea, fecha ingreso, estado, documentos.</p>\n</li>\n<li dir=\"ltr\" aria-level=\"1\">\n<p dir=\"ltr\" role=\"presentation\">Historial: cambios de cargo, sueldo, turnos, sanciones.</p>\n</li>\n</ul>\n<ol start=\"2\">\n<li dir=\"ltr\" aria-level=\"1\">\n<p dir=\"ltr\" role=\"presentation\">Asistencia + Horarios</p>\n</li>\n</ol>\n<ul>\n<li dir=\"ltr\" aria-level=\"1\">\n<p dir=\"ltr\" role=\"presentation\">Horarios (plantillas) + detalle por d&iacute;a (hora ingreso/salida, tolerancia).</p>\n</li>\n<li dir=\"ltr\" aria-level=\"1\">\n<p dir=\"ltr\" role=\"presentation\">Registro de marcaciones (manual o importado) y c&aacute;lculo autom&aacute;tico:</p>\n</li>\n<ul>\n<li dir=\"ltr\" aria-level=\"2\">\n<p dir=\"ltr\" role=\"presentation\">tardanza, falta, horas trabajadas, extras (si aplica)</p>\n</li>\n</ul>\n<li dir=\"ltr\" aria-level=\"1\">\n<p dir=\"ltr\" role=\"presentation\">Vista &ldquo;d&iacute;a&rdquo; tipo tablero (todos los empleados y su estado).</p>\n</li>\n</ul>\n<ol start=\"3\">\n<li dir=\"ltr\" aria-level=\"1\">\n<p dir=\"ltr\" role=\"presentation\">Vacaciones y Permisos (workflow)</p>\n</li>\n</ol>\n<ul>\n<li dir=\"ltr\" aria-level=\"1\">\n<p dir=\"ltr\" role=\"presentation\">Solicitud &rarr; aprobaci&oacute;n (jefe) &rarr; validaci&oacute;n RRHH &rarr; registro final.</p>\n</li>\n<li dir=\"ltr\" aria-level=\"1\">\n<p dir=\"ltr\" role=\"presentation\">Adjuntos (sustentos).</p>\n</li>\n<li dir=\"ltr\" aria-level=\"1\">\n<p dir=\"ltr\" role=\"presentation\">C&aacute;lculo de saldo disponible por trabajador/a&ntilde;o.</p>\n</li>\n</ul>\n<ol start=\"4\">\n<li dir=\"ltr\" aria-level=\"1\">\n<p dir=\"ltr\" role=\"presentation\">RBAC + Auditor&iacute;a</p>\n</li>\n</ol>\n<ul>\n<li dir=\"ltr\" aria-level=\"1\">\n<p dir=\"ltr\" role=\"presentation\">Permisos por rol (RRHH, jefe, supervisor, empleado).</p>\n</li>\n<li dir=\"ltr\" aria-level=\"1\">\n<p dir=\"ltr\" role=\"presentation\">Log de acciones (crear/editar/eliminar/aprobar).</p>\n</li>\n</ul>\n<p dir=\"ltr\"><strong>MODULO 2:</strong></p>\n<ol start=\"5\">\n<li dir=\"ltr\" aria-level=\"1\">\n<p dir=\"ltr\" role=\"presentation\">Sanciones / Medidas disciplinarias</p>\n</li>\n</ol>\n<ul>\n<li dir=\"ltr\" aria-level=\"1\">\n<p dir=\"ltr\" role=\"presentation\">Plantillas por tipo (amonestaci&oacute;n, suspensi&oacute;n, etc.)</p>\n</li>\n<li dir=\"ltr\" aria-level=\"1\">\n<p dir=\"ltr\" role=\"presentation\">Enlace a faltas del reglamento interno + evidencias.</p>\n</li>\n<li dir=\"ltr\" aria-level=\"1\">\n<p dir=\"ltr\" role=\"presentation\">Flujo: borrador &rarr; revisi&oacute;n RRHH &rarr; firma/entrega.</p>\n</li>\n</ul>\n<ol start=\"6\">\n<li dir=\"ltr\" aria-level=\"1\">\n<p dir=\"ltr\" role=\"presentation\">Documentos</p>\n</li>\n</ol>\n<ul>\n<li dir=\"ltr\" aria-level=\"1\">\n<p dir=\"ltr\" role=\"presentation\">Repositorio: contratos, adendas, boletas, constancias, cartas.</p>\n</li>\n<li dir=\"ltr\" aria-level=\"1\">\n<p dir=\"ltr\" role=\"presentation\">Vencimientos y alertas (certificados, contrato plazo fijo, etc.)</p>\n</li>\n</ul>\n<p dir=\"ltr\"><strong>MODULO 3:</strong></p>\n<ol start=\"7\">\n<li dir=\"ltr\" aria-level=\"1\">\n<p dir=\"ltr\" role=\"presentation\">Planilla y comisiones (si lo necesitas dentro del sistema)</p>\n</li>\n</ol>\n<ul>\n<li dir=\"ltr\" aria-level=\"1\">\n<p dir=\"ltr\" role=\"presentation\">Variables, comisiones, adelantos, descuentos.</p>\n</li>\n<li dir=\"ltr\" aria-level=\"1\">\n<p dir=\"ltr\" role=\"presentation\">Export para contador (no necesariamente calcular todo al inicio).</p>\n</li>\n</ul>\n<ol start=\"8\">\n<li dir=\"ltr\" aria-level=\"1\">\n<p dir=\"ltr\" role=\"presentation\">Capacitaciones (clave en casa de cambio)</p>\n</li>\n</ol>\n<ul>\n<li dir=\"ltr\" aria-level=\"1\">\n<p dir=\"ltr\" role=\"presentation\">Registro de capacitaciones PLAFT/KYC, seguridad, protecci&oacute;n de datos.</p>\n</li>\n<li dir=\"ltr\" aria-level=\"1\">\n<p dir=\"ltr\" role=\"presentation\">Fechas, asistencia, evidencias (PDF, fotos, firmas).</p>\n</li>\n</ul>\n<p>&nbsp;</p>','whatsapp',30,'minutos',0,NULL,'[{\"id\":9}]','2026-01-03 15:16:48','2026-01-03 15:27:24','[]'),(154,1,NULL,NULL,'ERP- GESTION DE RECURSOS HUMANOS (MODULO 2)','2026-01-03 10:15:00','2026-01-03 10:45:00',0,'3TMI','#FF6666','','<p dir=\"ltr\"><strong>MODULO 2:</strong></p>\n<ol start=\"5\">\n<li dir=\"ltr\" aria-level=\"1\">\n<p dir=\"ltr\" role=\"presentation\">Sanciones / Medidas disciplinarias</p>\n</li>\n</ol>\n<ul>\n<li dir=\"ltr\" aria-level=\"1\">\n<p dir=\"ltr\" role=\"presentation\">Plantillas por tipo (amonestaci&oacute;n, suspensi&oacute;n, etc.)</p>\n</li>\n<li dir=\"ltr\" aria-level=\"1\">FORMATOS:\n<ul>\n<li dir=\"ltr\" aria-level=\"1\">Faltas</li>\n<li dir=\"ltr\" aria-level=\"1\">tardanza</li>\n<li dir=\"ltr\" aria-level=\"1\">por venir en estado embriaguez</li>\n<li dir=\"ltr\" aria-level=\"1\">uso de celular en el horario de trabjao</li>\n<li dir=\"ltr\" aria-level=\"1\">ausentarse sin permiso&nbsp;</li>\n<li dir=\"ltr\" aria-level=\"1\">dormir&nbsp; en horario laboral</li>\n<li dir=\"ltr\" aria-level=\"1\">proporcionar informacion confidencial</li>\n<li dir=\"ltr\" aria-level=\"1\">consumir alimentos durante la joranda</li>\n<li dir=\"ltr\" aria-level=\"1\">por no usar uniforme</li>\n<li dir=\"ltr\" aria-level=\"1\">por conversar</li>\n<li dir=\"ltr\" aria-level=\"1\">+ mas formatos</li>\n</ul>\n</li>\n<li dir=\"ltr\" aria-level=\"1\">\n<p dir=\"ltr\" role=\"presentation\">Enlace a faltas del reglamento interno + evidencias.</p>\n<ul>\n<li dir=\"ltr\" aria-level=\"1\">REAGLAMIENTO INTERNO ( alinear / capacitar / acta de capacitaci&oacute;n )</li>\n</ul>\n</li>\n<li dir=\"ltr\" aria-level=\"1\">\n<p dir=\"ltr\" role=\"presentation\">Flujo: borrador &rarr; revisi&oacute;n RRHH &rarr; firma/entrega.</p>\n</li>\n</ul>\n<ol start=\"6\">\n<li dir=\"ltr\" aria-level=\"1\">\n<p dir=\"ltr\" role=\"presentation\">Documentos</p>\n</li>\n</ol>\n<ul>\n<li dir=\"ltr\" aria-level=\"1\">\n<p dir=\"ltr\" role=\"presentation\">Repositorio: contratos, adendas, boletas, constancias, cartas.</p>\n</li>\n<li dir=\"ltr\" aria-level=\"1\">\n<p dir=\"ltr\" role=\"presentation\">Vencimientos y alertas (certificados, contrato plazo fijo, etc.)</p>\n</li>\n</ul>\n<p>7. FIRMA DIGITAL</p>\n<p>&nbsp;</p>','whatsapp',30,'minutos',0,NULL,'[]','2026-01-03 15:28:17','2026-01-03 19:03:41','[]'),(155,1,NULL,NULL,'ERP- GESTION DE RECURSOS HUMANOS (MODULO 3)','2026-01-10 10:15:00','2026-01-10 10:45:00',0,'3TMI','#FF6666','Túnel San Martín, Rímac, Lima, Lima Metropolitana, Lima, 15093, Perú','<p dir=\"ltr\"><strong>MODULO 3:</strong></p>\n<ol start=\"7\">\n<li dir=\"ltr\" aria-level=\"1\">\n<p dir=\"ltr\" role=\"presentation\">Planilla y comisiones (si lo necesitas dentro del sistema)</p>\n</li>\n</ol>\n<ul>\n<li dir=\"ltr\" aria-level=\"1\">\n<p dir=\"ltr\" role=\"presentation\">Variables, comisiones, adelantos, descuentos.</p>\n</li>\n<li dir=\"ltr\" aria-level=\"1\">\n<p dir=\"ltr\" role=\"presentation\">Export para contador (no necesariamente calcular todo al inicio).</p>\n</li>\n</ul>\n<ol start=\"8\">\n<li dir=\"ltr\" aria-level=\"1\">\n<p dir=\"ltr\" role=\"presentation\">Capacitaciones (clave en casa de cambio)</p>\n</li>\n</ol>\n<ul>\n<li dir=\"ltr\" aria-level=\"1\">\n<p dir=\"ltr\" role=\"presentation\">Registro de capacitaciones PLAFT/KYC, seguridad, protecci&oacute;n de datos.</p>\n</li>\n<li dir=\"ltr\" aria-level=\"1\">\n<p dir=\"ltr\" role=\"presentation\">Fechas, asistencia, evidencias (PDF, fotos, firmas).</p>\n</li>\n</ul>','whatsapp',30,'minutos',0,NULL,'[{\"id\":9}]','2026-01-03 15:29:19','2026-01-03 15:29:19','[]'),(156,1,NULL,NULL,'CAPACITACION SBS - PERSONAL','2026-01-04 08:00:00','2026-01-04 09:00:00',0,'BUSINESS DIVISAS','#FF6666','','<p><strong>ROL Y DESAFIOS DE LOS PRINCIPALES ACTORES EN LA LUCHA CONTRA EL LAVADO DE ACTIVOS:</strong></p>\n<p>Duracion: 55 minutos</p>\n<p>https://drive.google.com/file/d/152wpuT8qsGupDIvOPvRdEeFXqdLFQaLW/view</p>','whatsapp',30,'minutos',0,NULL,'[{\"id\":9}]','2026-01-03 15:39:40','2026-01-03 15:40:53','[]'),(157,1,NULL,NULL,'CAPACITACION SBS - PERSONAL','2026-01-05 08:00:00','2026-01-05 09:00:00',0,'BUSINESS DIVISAS','#FF6666','Túnel San Martín, Rímac, Lima, Lima Metropolitana, Lima, 15093, Perú','<p><strong>La ruta del dinero: Estrategia clave en la lucha contra la criminalidad</strong></p>\n<p>Duracion: 25 minutos</p>\n<p>https://drive.google.com/file/d/1gwiTgcQEyOGKeTNJfPbllj5_D6tgyXQT/view</p>','whatsapp',30,'minutos',0,NULL,'[{\"id\":9}]','2026-01-03 15:46:36','2026-01-03 15:46:36','[]'),(158,1,NULL,NULL,'CAPACITACION SBS - PERSONAL','2026-01-06 10:45:00','2026-01-06 11:15:00',0,'BUSINESS DIVISAS','#FF6666','','<p><strong>Rol y desaf&iacute;os de los principales actores en la lucha contra el Lavado de Activos</strong></p>\n<p>Duracion: 50 minutos<br>https://drive.google.com/file/d/152wpuT8qsGupDIvOPvRdEeFXqdLFQaLW/view<br><br></p>','whatsapp',30,'minutos',0,NULL,'[{\"id\":9}]','2026-01-03 16:12:39','2026-01-03 16:12:39','[]'),(159,1,NULL,NULL,'CAPACITACION SBS - PERSONAL','2026-01-07 11:00:00','2026-01-07 11:30:00',0,'BUSINESS DIVISAS','#FF6666','','<p><strong>Los sujetos obligados: La primera l&iacute;nea de defensa para combatir el Lavado de Activos</strong></p>\n<p>Duracion: 50 minutos</p>\n<p>https://drive.google.com/file/d/1u1mDFya62N2wcnDFgsP6zpvKShZwMpO1/view</p>','whatsapp',30,'minutos',0,NULL,'[{\"id\":9}]','2026-01-03 16:15:54','2026-01-03 16:15:54','[]'),(160,1,NULL,NULL,'CAPACITACION SBS - PERSONAL','2026-01-08 11:15:00','2026-01-08 11:45:00',0,'BUSINESS DIVISAS','#FF6666','','<p><strong>Radiograf&iacute;a de los delitos de extorsi&oacute;n y corrupci&oacute;n en el Per&uacute; y Latinoam&eacute;rica</strong></p>\n<p>Duracion: 55 minutos</p>\n<p>https://drive.google.com/file/d/1Q7CPPgKwbLFhNuV9T5iWE_hXrWgIwedI/view</p>','whatsapp',30,'minutos',0,NULL,'[{\"id\":9}]','2026-01-03 16:24:19','2026-01-03 16:24:19','[]'),(161,1,NULL,NULL,'CAPACITACION SBS - PERSONAL','2026-01-09 08:00:00','2026-01-09 09:00:00',0,'BUSINESS DIVISAS','#FF6666','','<p><strong>Tipolog&iacute;as del lavado de activos provenientes del delito de la extorsi&oacute;n</strong><br>Duraci&oacute;n: 23 mimnutos</p>\n<p>https://drive.google.com/file/d/1yDUIqMNWnkrpyq-Mg8Tj2AEiarIjnQhp/view</p>','whatsapp',30,'minutos',0,NULL,'[{\"id\":9}]','2026-01-03 16:26:01','2026-01-03 16:26:01','[]'),(162,1,NULL,NULL,'CAPACITACION SBS - PERSONAL','2026-01-10 08:00:00','2026-01-10 09:00:00',0,'BUSINESS DIVISAS','#FF6666','','<p><strong>Corrupci&oacute;n y lavado de activos: Dos delitos que socaban la gobernabilidad</strong></p>\n<p>Duraci&oacute;n: 60 minutos</p>\n<p>https://drive.google.com/file/d/12aojPCSvCSqmoVKo4zVANubQdSbdSYeJ/view</p>\n<p>&nbsp;</p>','whatsapp',30,'minutos',0,NULL,'[{\"id\":9}]','2026-01-03 16:27:30','2026-01-03 16:27:30','[]'),(163,1,NULL,NULL,'CAPACITACION SBS - PERSONAL','2026-01-11 08:00:00','2026-01-11 09:00:00',0,'BUSINESS DIVISAS','#FF6666','','<p><strong>Congelamiento de activos: Herramienta clave contra el crimen organizado</strong></p>\n<p>Duracion: 60 minutos</p>\n<p>https://drive.google.com/file/d/1TooiicQoVm0uMREucq8yv7z8-gvo8-c7/view</p>','whatsapp',30,'minutos',0,NULL,'[{\"id\":9}]','2026-01-03 16:31:28','2026-01-03 16:31:28','[]'),(164,1,NULL,NULL,'CAPACITACION SBS - PERSONAL','2026-01-12 08:00:00','2026-01-12 09:00:00',0,'BUSINESS DIVISAS','#FF6666','Túnel San Martín, Rímac, Lima, Lima Metropolitana, Lima, 15093, Perú','<p><strong>Tipolog&iacute;as relacionadas a Lavado de Activos provenientes de Delitos Contra la Administraci&oacute;n P&uacute;blica</strong></p>\n<p>Duraci&oacute;n: 50 minutos</p>\n<p>https://drive.google.com/file/d/1RN_m7cYDVpBvQ44y6Bv3-dqYMSaF927m/view</p>\n<p>&nbsp;</p>','whatsapp',30,'minutos',0,NULL,'[{\"id\":9}]','2026-01-03 16:35:07','2026-01-03 16:35:07','[]'),(165,1,NULL,NULL,'CAPACITACION SBS - PERSONAL','2026-01-13 08:00:00','2026-01-13 09:00:00',0,'BUSINESS DIVISAS','#FF6666','','<p><strong>Uso de las nuevas tecnolog&iacute;as en la criminalidad organizada</strong></p>\n<p>Duraci&oacute;n: 60 minutos</p>\n<p>https://drive.google.com/file/d/1JVJbWp1FUKNkflwbbPY4qvpnzGms4K5h/view</p>\n<p>&nbsp;</p>','whatsapp',30,'minutos',0,NULL,'[{\"id\":9}]','2026-01-03 16:40:32','2026-01-03 16:40:32','[]'),(166,1,NULL,NULL,'CAPACITACION SBS - PERSONAL','2026-01-14 11:30:00','2026-01-14 12:00:00',0,'BUSINESS DIVISAS','#FF6666','','<p><strong>Riesgos de lavado de activos provenientes de los delitos de trata de personas en el Per&uacute; y sus tipolog&iacute;as</strong></p>\n<p>Duraci&oacute;n: 60 minutos</p>\n<p>https://drive.google.com/file/d/1d4bgtiwWFSi5XhasyiXwh_AgJbJH5yy9/view</p>','whatsapp',30,'minutos',0,NULL,'[{\"id\":9}]','2026-01-03 16:42:55','2026-01-03 16:42:55','[]'),(167,1,NULL,NULL,'CAPACITACION SBS - PERSONAL','2026-01-15 08:00:00','2026-01-15 09:00:00',0,'BUSINESS DIVISAS','#FF6666','','<p class=\"MsoListParagraph\" style=\"text-indent: -18.0pt; mso-list: l0 level1 lfo1;\"><!-- [if !supportLists]--><strong><span style=\"mso-bidi-font-family: Aptos; mso-bidi-theme-font: minor-latin;\"><span style=\"mso-list: Ignore;\">1.<span style=\"font: 7.0pt \'Times New Roman\';\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span></span></span></strong><!--[endif]--><strong>Big data y machine learning en la detecci&oacute;n del lavado de activos</strong></p>\n<p class=\"MsoNormal\" style=\"margin-left: 35.4pt;\">Duraci&oacute;n: 60 minutos</p>\n<p class=\"MsoNormal\" style=\"margin-left: 35.4pt;\"><a href=\"https://drive.google.com/file/d/1oA3OM5I2kv9BfIDeVUWqcIjSK_qg77vk/view\">https://drive.google.com/file/d/1oA3OM5I2kv9BfIDeVUWqcIjSK_qg77vk/view</a></p>','whatsapp',30,'minutos',0,NULL,'[{\"id\":9}]','2026-01-03 16:44:27','2026-01-03 17:26:11','[]'),(168,1,NULL,NULL,'CAPACITACION SBS - PERSONAL','2026-01-16 08:00:00','2026-01-16 09:00:00',0,'BUSINESS DIVISAS','#FF6666','','<p><strong>Criptoactivos: Definici&oacute;n, riesgos y medidas de control</strong></p>\n<p>Duraci&oacute;n: 60 minutos</p>\n<p>https://drive.google.com/file/d/1lPIBwzWJJ0U9C-pAEybOjcp8Rxq5oS4b/view</p>','whatsapp',30,'minutos',0,NULL,'[{\"id\":9}]','2026-01-03 16:48:04','2026-01-03 16:48:04','[]'),(169,1,NULL,NULL,'CAPACITACION SBS - PERSONAL','2026-01-17 08:00:00','2026-01-17 09:00:00',0,'BUSINESS DIVISAS','#FF6666','','<p><strong>Casos reales de Lavado de Activos provenientes del ciberdelito&nbsp;</strong></p>\n<p>Duraci&oacute;n: 60 minutos</p>\n<p>https://drive.google.com/file/d/1RX8Bdyp-3AwGT6MjkgAnkBftE89f3aow/view</p>','whatsapp',30,'minutos',0,NULL,'[{\"id\":9}]','2026-01-03 16:55:17','2026-01-03 16:55:17','[]'),(170,1,NULL,NULL,'CAPACITACION SBS - PERSONAL','2026-01-18 08:00:00','2026-01-18 09:00:00',0,'BUSINESS DIVISAS','#FF6666','','<p><strong>Trata de personas y corrupci&oacute;n en el marco de un crimen organizado</strong></p>\n<p>Duraci&oacute;n: 60 minutos</p>\n<p>https://drive.google.com/file/d/156x-0aT0o3kw66iGoDF_aNEoPEpCsXn2/view</p>','whatsapp',30,'minutos',0,NULL,'[{\"id\":9}]','2026-01-03 17:01:21','2026-01-03 17:01:21','[]'),(171,1,NULL,NULL,'CAPACITACION SBS - PERSONAL','2026-01-19 08:00:00','2026-01-19 09:00:00',0,'BUSINESS DIVISAS','#FF6666','','<p><strong>Riesgos de lavado de activos provenientes de los delitos ambientales y sus tipolog&iacute;as</strong></p>\n<p>Duraci&oacute;n: 50 minutos</p>\n<p>https://drive.google.com/file/d/1OglOZk-61MWS-MsyXCejO_sdut1pDDXK/view</p>','whatsapp',30,'minutos',0,NULL,'[{\"id\":9}]','2026-01-03 17:03:17','2026-01-03 17:03:17','[]'),(172,1,NULL,NULL,'CAPACITACION SBS - PERSONAL','2026-01-20 08:00:00','2026-01-20 09:00:00',0,'BUSINESS DIVISAS','#FF6666','','<p><strong>Tipolog&iacute;as de lavado de activos provenientes del cibercrimen</strong></p>\n<p>Duraci&oacute;n: 60 minutos</p>\n<p>https://drive.google.com/file/d/1zFa_J03oNBTh22vzFbFPOw-Fisapfroe/view</p>','whatsapp',30,'minutos',0,NULL,'[{\"id\":9}]','2026-01-03 17:09:32','2026-01-03 17:09:32','[]'),(173,1,NULL,NULL,'CAPACITACION SBS - PERSONAL','2026-01-21 12:00:00','2026-01-21 12:30:00',0,'BUSINESS DIVISAS','#FF6666','','<p><strong>La importancia de las investigaciones financieras paralelas&nbsp;</strong></p>\n<p>Duraci&oacute;n: 45 minutos</p>\n<p>https://drive.google.com/file/d/1lLUtbYCRliBedyjcymN__khLbCYuXV71/view</p>','whatsapp',30,'minutos',0,NULL,'[{\"id\":9}]','2026-01-03 17:11:10','2026-01-03 17:11:10','[]'),(174,1,NULL,NULL,'CAPACITACION SBS - PERSONAL','2026-01-22 08:00:00','2026-01-22 09:00:00',0,'BUSINESS DIVISAS','#FF6666','','<p><strong>El desarrollo de la prueba en los procesos de lavado de activos</strong></p>\n<p>Duraci&oacute;n: 60 minutos</p>\n<p>https://drive.google.com/file/d/101-HXe2CClwjXVBFZ61AcGDNCZIRN9yC/view</p>','whatsapp',30,'minutos',0,NULL,'[{\"id\":9}]','2026-01-03 17:13:21','2026-01-03 17:13:21','[]'),(175,1,NULL,NULL,'CAPACITACION SBS - PERSONAL','2026-01-23 08:00:00','2026-01-23 09:00:00',0,'BUSINESS DIVISAS','#FF6666','','<p><strong>Construyendo confianza en el Sistema de Prevenci&oacute;n de Lavado de Activos y Financiamiento del Terrorismo - SPLAFT:&nbsp; Debida diligencia del conocimiento del cliente&nbsp; &nbsp;</strong></p>\n<p>Duraci&oacute;n: 60 minutos</p>\n<p>https://drive.google.com/file/d/1tz9958Dv3MWuybLTHpVT5aMLUebhXng1/view</p>','whatsapp',30,'minutos',0,NULL,'[{\"id\":9}]','2026-01-03 17:14:56','2026-01-03 17:14:56','[]'),(176,1,NULL,NULL,'CAPACITACION SBS - PERSONAL','2026-01-24 08:00:00','2026-01-24 09:00:00',0,'BUSINESS DIVISAS','#FF6666','','<p><strong>ROS de calidad: El pilar fundamental para la detecci&oacute;n de delitos de lavado de activos</strong></p>\n<p>Duraci&oacute;n: 50 minutos</p>\n<p>https://drive.google.com/file/d/1yTjWqsf863z95OvAzRvA3ySbNn20wTWG/view</p>','whatsapp',30,'minutos',0,NULL,'[{\"id\":9}]','2026-01-03 17:16:56','2026-01-03 17:16:56','[]'),(177,1,NULL,NULL,'CAPACITACION SBS - PERSONAL','2026-01-25 08:00:00','2026-01-25 09:00:00',0,'BUSINESS DIVISAS','#FF6666','','<p><strong>Una mirada al futuro del Per&uacute; en su lucha contra el lavado de activos: Autodiagn&oacute;stico del sistema y Pol&iacute;tica Nacional contra el Lavado de Activos al 2030&nbsp;</strong></p>\n<p>Duraci&oacute;n: 60 minutos</p>\n<p>https://drive.google.com/file/d/1PTcLUSCWcONawgm_kbayw6lmHkGDcq-b/view</p>\n<p>&nbsp;</p>','whatsapp',30,'minutos',0,NULL,'[{\"id\":9}]','2026-01-03 17:18:22','2026-01-03 17:18:22','[]');

--
