(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','admin/uploads/users/36093/contrato.pdf',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),(36097,'Lety','Castellano','castellanolety86@gmail.com','12207607','$2y$10$njPOk98xo9Kpj0.n6EQ9huuJ3Bw6rb4yEsjMMOD7FH.xsaBL1HxaK','+584145658325',NULL,'2025-03-10 18:00:43','globalmarket2',1,'../uploads/users/36097/cedula.jpeg','../uploads/users/36097/rif.jpeg','admin/uploads/users/36097/contrato.pdf',NULL,48),(36098,'Diana','Cordero ','diananorymar@gmail.com','15425503','$2y$10$9F8pOrCRoF8RufVeVA0XM.Tjp0zkkbi1/0fbVDkYIQKEeIs17lrW.','+584245208574',NULL,'2025-03-10 18:05:19','vicenzacell',1,'../uploads/users/36098/cedula.jpeg','../uploads/users/36098/rif.jpeg','admin/uploads/users/36098/contrato.pdf',NULL,129),(36099,'Jesus','Moreno','jesemrecords@gmail.com','28577066','$2y$10$mlqMP4vaNmL6n1VNzmuTGemjvj90TzevvCM7tu1WEAQQm0cAQKgoO','+584120580047',NULL,'2025-03-10 18:06:47',NULL,0,NULL,NULL,NULL,NULL,NULL),(36100,'Rikeily natali','Colmenares isquierdo','rikeilynataly@gmail.com','28673158','$2y$10$ybFy0FofTpv5P8em.EpEzOUAAX3Ln9cMUTh8Yv7r3MaPpJJKiBYj2','+584161787404','','2025-03-10 18:10:14','ivridoscentro',1,'../uploads/users/36100/cedula.jpg','../uploads/users/36100/rif.jpg','admin/uploads/users/36100/contrato.pdf',NULL,272),(36101,'Ligia ','Acosta ','ligiaoperaciones2012@gmail.com','14099088','$2y$10$W7AQGCo/kCV/DqGlU035euOxsu7W2l2GL3xuE/EepAEMhEKXeEsA2','+584120308783',NULL,'2025-03-10 18:10:53',NULL,0,NULL,NULL,NULL,NULL,NULL),(36102,'LUIS ENRIQUE','SUAREZ ESCALONA','ENRRIQUESUAREZ033@GMAIL.COM','11545245','$2y$10$PDA88fMOXZXtSRZxuenZ9.MfwvxA8GdTvPFUjm5Ti.Nk9d..iDSD.','+584262329142','','2025-03-10 18:11:25','digitalcell',1,'../uploads/users/36102/cedula.jpeg','../uploads/users/36102/rif.jpeg','admin/uploads/users/36102/contrato.pdf',NULL,75),(36103,'Juan Diego ','García Matheus ','jdgarciamatheus@gmail.com','30416839','$2y$10$zHnPge5S8HKdSxRKc5bEN.vjfdyWH6FzITp.hxYEjEuo65j.1Kc5.','+584264366508',NULL,'2025-03-10 18:21:19',NULL,0,NULL,NULL,NULL,NULL,NULL),(36104,'Elvis','Garcia','elvisgs95@hotmail.com','23851492','$2y$10$tcmW2ySZwZ1ruXnRt7EBiO1WyQLyCZX2nzXkWXXN8TCX7Xf7ECqoO','+584125103625',NULL,'2025-03-10 18:23:05',NULL,0,NULL,NULL,NULL,NULL,NULL),(36105,'DANY ALEXANDER','CAURO RIERA','jgdisenodigital@gmail.com','19551471','$2y$10$f.e6aU34JKrdkddBcNDwGuCWmIC.l9FkUh6aek66cJPoYzjFdRrOq','+584245969417','','2025-03-10 18:24:43','camovilfix',1,'../uploads/users/36105/cedula.jpeg','../uploads/users/36105/rif.pdf','admin/uploads/users/36105/contrato.pdf',104,172),(36106,'JOSE ANGEL','RAMOS GARCIA','jangelramosg@gmail.com','19619017','$2y$10$xwga1/uGz09oNB9lpqcZ0.xWE5LAxPXqtdO06UsV2ApscEq.k81iu','+584245328916','','2025-03-10 18:26:41','ivridoscentro',1,'../uploads/users/36106/cedula.jpg','../uploads/users/36106/rif.jpg','admin/uploads/users/36106/contrato.pdf',NULL,272),(36107,'Leonel','Briceño','leobricecorao@gmail.com','15914042','$2y$10$O8G3Wad6rIBzw7E7AXzdxObvMZ2KuCGDGMVuf5Y/Jxlyf5WORi00a','+5804245226584',NULL,'2025-03-10 18:42:42','globalmarket2',1,'../uploads/users/36107/cedula.jpeg','../uploads/users/36107/rif.jpeg',NULL,NULL,48),(36108,'Jarvin','Manrrique','jarvincito1828@gmail.com','22657463','$2y$10$ek68U7ILizmRZbxYO4mX7Ot3C5n/tJN76bqJgGod2euFT78aInwba','+584245477532',NULL,'2025-03-10 18:42:51','globalmarket2',1,'../uploads/users/36108/cedula.jpeg','../uploads/users/36108/rif.jpeg',NULL,NULL,48),(36109,'KARLAS ','PEREZ','sarhays2112@gmail.com','15171530','$2y$10$sSLNudRk41AVhipvQ6v8UOO4ktEopuqC60oYwfBvvSsLUQn4jCxzu','+584120737756',NULL,'2025-03-10 18:45:51',NULL,0,NULL,NULL,NULL,NULL,NULL),(36110,'RUBEN GREGORIO','CORDERO PIÑA','diocprez68@gmail.com','9613157','$2y$10$FCRaSeQK8tm1H48vnvfiWeDAzEqy02S5ycrdzNjnDbrE6Aw6hvEsK','+584145747739','04145776986','2025-03-10 18:48:45','tecnoberryca',1,'../uploads/users/36110/cedula.jpg','../uploads/users/36110/rif.jpg','admin/uploads/users/36110/contrato.pdf',62,45),(36111,'FREDDY ALEXI','HURTADO OJEDA','freddyhurtadoojeda1963@gmail.com','8143407','$2y$10$Q8hYg/YO9oGYzMo8UOLwAuvFtRnO0kYtUdzbIi0SkdAl1fM8FM7Ay','+584145340305','','2025-03-10 18:51:04','ivridoscentro',1,'../uploads/users/36111/cedula.jpg','../uploads/users/36111/rif.jpg',NULL,NULL,272);

--
-- 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` */;


