(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','admin/uploads/users/36107/contrato.pdf',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','admin/uploads/users/36108/contrato.pdf',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','admin/uploads/users/36111/contrato.pdf',NULL,272),(36112,'VIAGNEIDY ','LADINO','viagneidy20@gmail.com','25140336','$2y$10$6XiwgTz7o1NageB1LOztyu5gAfVq1bhmKNKtmoJzR31myK8YdOwdG','+584145345231',NULL,'2025-03-10 19:00:58','cellucenter',1,'../uploads/users/36112/cedula.jpeg','../uploads/users/36112/rif.jpeg','admin/uploads/users/36112/contrato.pdf',NULL,68),(36113,'Betzabeth ','Rodriguez ','betzabethr91@gmail.com','19693984','$2y$10$PB7/NODgiDHXicjIqGUCXeNsr9ehJ1uTe9w.Joh7ZJzhvHCEMzu7a','+5804245823758',NULL,'2025-03-10 19:09:39',NULL,0,NULL,NULL,NULL,NULL,NULL),(36114,'Ana','Rodriguez ','rodriguezanarosa766@gmail.com','19846073','$2y$10$9/kwlFBAYrxMhji/ZqNffeE6Jw7VJWVQj5yny7tnipxFHQRa8EKym','+584145035317',NULL,'2025-03-10 19:11:02','vicenzacell',1,'../uploads/users/36114/cedula.jpeg','../uploads/users/36114/rif.jpeg','admin/uploads/users/36114/contrato.pdf',NULL,129),(36115,'Alixandra','Rodríguez De Quintero','antoniolagunaq77@gmail.com','11193277','$2y$10$LFHTW2DhXRbzEOuO9Fb8gO2aTCSW4v6HBysnoGmWj8U.1QfHtl6Ym','+5804245013945',NULL,'2025-03-10 19:11:08',NULL,0,NULL,NULL,NULL,NULL,NULL),(36116,'Kelvin Manuel ','Mogollón Duarte ','kmogollom@gmail.com','24148561','$2y$10$FBAJfxFBkU3vhPfhJKMp8.79XCPNU5UG5B6f5hhDTTJdLhAMJdWYa','+584147096088',NULL,'2025-03-10 19:14:59',NULL,0,NULL,NULL,NULL,NULL,NULL),(36117,'SAUL ENRIQUE','COLMENAREZ RONDON','YONATHANPEREZ104@GMAIL.COM','21125614','$2y$10$jPwE4wm.nTzGhiKiR.x7OuMcsHzGpZZaihbAqXhpLclyS0VjJIqTu','+584121218299','','2025-03-10 19:23:38','digitalcell',1,'../uploads/users/36117/cedula.jpeg','../uploads/users/36117/rif.jpeg','admin/uploads/users/36117/contrato.pdf',NULL,75),(36118,'ORLANDO OLMERY ','REYES VARGAS ','olmery05@gmail.com','20351965','$2y$10$Jn8KXUAvZ/ZzBRsaPvXQuuY0X9AHk9e5COpCexVtMej2swgfdcXJO','+584245617726',NULL,'2025-03-10 19:27:36','vicenzacell',1,'../uploads/users/36118/cedula.jpeg','../uploads/users/36118/rif.jpeg','admin/uploads/users/36118/contrato.pdf',NULL,129),(36119,'KRISTEL ELIZABETH','CARRILLO RONDON','carrikristel@gmail.com','18290099','$2y$10$mQGGzksw4gr3mnED7m.xMeGKgaY0nrAHR3iy.hNkGURsQZSKw6tuC','+584245774180','','2025-03-10 19:28:57','ivridoscentro',1,'../uploads/users/36119/cedula.jpg','../uploads/users/36119/rif.jpg','admin/uploads/users/36119/contrato.pdf',NULL,272),(36120,'Emiliannys Celina','Antequera Mujica','mujicamariac31@gmail.com','27217799','$2y$10$0QbBqpP0sE3US2N0LFDHTu7CCvSnWiegz0D9xWMqDF6YqZ1V0RXBu','+584245071538','04126459147','2025-03-10 19:36:05','mayoristascosmos',0,NULL,NULL,NULL,NULL,33),(36121,'Jessica ','Olmedo','olmedojessica2@gmail.com','38259580','$2y$10$3rSOLrTrJMe3DA5aFt./tu4eB9R3mZoJB1r7EoRx1nh1f9ks8K5yC','+598092034403',NULL,'2025-03-10 19:36:18',NULL,0,NULL,NULL,NULL,NULL,NULL),(36122,'DORIS BEATRIZ','CALAO RAMIREZ','calaodoris07@gmail.com','16980172','$2y$10$FicPiRtu4MMqkJSAQvLeI.Yhul3x6vInzur/j4YNKYMe15EvBC9Be','+584143521080','','2025-03-10 19:38:54','ivridos',1,'../uploads/users/36122/cedula.jpg','../uploads/users/36122/rif.jpg','admin/uploads/users/36122/contrato.pdf',NULL,243),(36123,'Gabriel ','Quintero','kcordero129@gmail.com','25399780','$2y$10$zgaKHqBkdVi2JlkcpeTU6uK.BFL5f0gwqvqH1mdZe3bSMzROFSTny','+584141586533',NULL,'2025-03-10 19:39:59','ivridoscentro',1,'../uploads/users/36123/cedula.jpg','../uploads/users/36123/rif.jpg',NULL,NULL,272),(36124,'Rafael Aleanny','Chacon','aleannyschacon@gmail.com','15343286','$2y$10$oeRJ8Tzt1L6YpPdHtwpUtucIUnwyXlr1ty8Q0T/d4fO4cHwdYJiJ6','+584127276335',NULL,'2025-03-10 19:47:55',NULL,0,NULL,NULL,NULL,NULL,NULL),(36125,'William','Von Moltke','w.moltke2@gmail.com','14690823','$2y$10$4grlVWR8J4q5uHLVStNxsewuG1H82gEkkU0puT52JNW4pKfPWxsoK','+584241264530',NULL,'2025-03-10 19:50:44',NULL,0,NULL,NULL,NULL,NULL,NULL),(36126,'Dixon ','Graterol','dixonjgn@gmail.com','25627324','$2y$10$E5mUnmGeslizrradL9kAVOeDoZHGGsXgbyl.X1ejgV9ZKV8O2UuFm','+584129741045',NULL,'2025-03-10 19:51:28',NULL,0,NULL,NULL,NULL,NULL,NULL),(36127,'Yoscar ','Pérez ','iribarrenmonitormsv@gmail.com','30042365','$2y$10$2QHWqAXyDRX/7Qob9q8ar.XDVUbgf8MBNzoXEJW99OuW.ZbD/myUe','+584121362403',NULL,'2025-03-10 19:58:55',NULL,0,NULL,NULL,NULL,NULL,NULL),(36128,'Viviana ','Hernández ','vivianadelvallehernandez@gmail.com','25460572','$2y$10$xUD4skCRLgiQhDtZks8Rc.bdv/x5zF0X0vkxFP.XlAQjp5sQf/9ha','+584245741196',NULL,'2025-03-10 19:59:17',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` */;


