(36092,'FANNY YUVED','TERAN MORENO','fannyteran50@gmail.com','13501227','$2y$10$NOHGdd9ptgCELFCpIOgtIOyBO1J6MxRv3JHYh6SjO2UunVf2abgY6','+584245573649','','2025-03-10 17:41:36','ivridoscentro',1,'../uploads/users/36092/cedula.jpg','../uploads/users/36092/rif.jpg','admin/uploads/users/36092/contrato.pdf',NULL,272),(36093,'Marielsy','Rodríguez ','marielsyrodriguez46@gmail.com','15425045','$2y$10$I2Jyo.bpgEsW9UoGObYYteX6kfb32SrlmKR99XvKNKE7Lg/zbFPhO','+5804120466262',NULL,'2025-03-10 17:50:28','vicenzacell',1,'../uploads/users/36093/cedula.jpeg','../uploads/users/36093/rif.jpeg',NULL,NULL,129),(36094,'Emilio','Belisario ','belisariofolashade@gmail.com','12470154','$2y$10$IL16ADw6Z84AXigMU3dmAOVdmXCiaI1.6jpo.r8pQjAEndyXyCnwC','+584129863072',NULL,'2025-03-10 17:52:17',NULL,0,NULL,NULL,NULL,NULL,NULL),(36095,'Natasah ','Gomez','eliza3gomez@gmail.com','18118789','$2y$10$AJXaXUuG1xu67hppn4KB7.bs.E7bi2X3l8wEEmIymWL.U1RB1Yqvi','+584161327425',NULL,'2025-03-10 17:52:46',NULL,0,NULL,NULL,NULL,NULL,NULL),(36096,'Gilberto ','Nava ','gilberto.navamelendez@gmail.com','10601717','$2y$10$yZd.vaVH/t84NnuuLxjjR.CKxh7U37dVpICwczOHbDRPGIOHAmfwK','+584123768004',NULL,'2025-03-10 17:57:10',NULL,0,NULL,NULL,NULL,NULL,NULL);

--
-- Temporary view structure for view `pagos_atrasados`
--

/*!50001 DROP VIEW IF EXISTS `pagos_atrasados`*/;
/*!50001 CREATE VIEW `pagos_atrasados` AS SELECT 
 1 AS `Nombre`,
 1 AS `Apellido`,
 1 AS `Cedula`,
 1 AS `Dispositivo`,
 1 AS `Vendedor`,
 1 AS `MontoAdeudado`,
 1 AS `CuotasAtrasadas`,
 1 AS `UltimaFechaAtraso`*/;

--
-- Final view structure for view `pagos_atrasados`
--

/*!50001 DROP VIEW IF EXISTS `pagos_atrasados`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`doadmin`@`%` SQL SECURITY DEFINER */
/*!50001 VIEW `pagos_atrasados` AS select `U`.`Nombre` AS `Nombre`,`U`.`Apellido` AS `Apellido`,`U`.`Cedula` AS `Cedula`,`D`.`modelo` AS `Dispositivo`,`D`.`vendedor` AS `Vendedor`,`F`.`MontoAdeudado` AS `MontoAdeudado`,count(`C`.`ID`) AS `CuotasAtrasadas`,max(`C`.`FechaCuota`) AS `UltimaFechaAtraso` from (((`Financiamiento` `F` join `Usuarios` `U` on((`F`.`UserID` = `U`.`UserID`))) join `Dispositivos` `D` on((`F`.`DeviceID` = `D`.`id`))) join `Cuotas` `C` on((`F`.`ID` = `C`.`IDFinanciamiento`))) where (`C`.`EstadoCuota` = 'Atrasada') group by `U`.`Cedula`,`F`.`ID` */;


