[2025-01-28 07:24:52.701756] production.ERROR: Fallo en el chequeo: App\Services\Checkeos\Chequeos\CDsConPagosSinFechaPago [] []
[2025-01-28 07:24:52.702233] production.INFO: select cd.* from maestro.credito_detalle cd inner join maestro.creditos c on cd.id_credito = c.id where monto_cobrado > 0 and fecha_cobro is null; [] []
[2025-01-28 07:24:52.702289] production.INFO: ------------------------------------------------------- [] []
[2025-01-28 07:24:52.811163] production.ERROR: Fallo en el chequeo: App\Services\Checkeos\Chequeos\CDsSinPagosConFechaPago [] []
[2025-01-28 07:24:52.811267] production.INFO: select cd.* from maestro.credito_detalle cd inner join maestro.creditos c on cd.id_credito = c.id where monto_cobrado = 0 and fecha_cobro is not null; [] []
[2025-01-28 07:24:52.811300] production.INFO: ------------------------------------------------------- [] []
[2025-01-28 07:24:53.551858] production.ERROR: Fallo en el chequeo: App\Services\Checkeos\Chequeos\DiferenciaItemsCd [] []
[2025-01-28 07:24:53.551957] production.INFO: SELECT id_credito_detalle, SUM(monto_inicial) AS suma_monto_inicial, SUM(saldo) AS suma_saldo, cd.monto_cobrar, (SUM(saldo) - cd.monto_cobrar) AS diferencia, cd.monto_cobrado, (cd.monto_cobrar + cd.monto_cobrado) AS total FROM conceptos.`items`, maestro.credito_detalle cd WHERE id_credito_detalle = cd.id GROUP BY id_credito_detalle, cd.monto_cobrar, cd.monto_cobrado HAVING diferencia < -100 OR diferencia > 100 ORDER BY diferencia DESC; [] []
[2025-01-28 07:24:53.551988] production.INFO: ------------------------------------------------------- [] []
[2025-01-28 07:24:55.932531] production.ERROR: Fallo en el chequeo: App\Services\Checkeos\Chequeos\MontoCobradoMenorSumaPagos [] []
[2025-01-28 07:24:55.932631] production.INFO: SELECT credito_detalle.id, credito_detalle.monto_cobrado, SUM(desglose_pago.monto) AS suma_pagos, credito_detalle.monto_cobrar, credito_detalle.estado FROM maestro.credito_detalle, maestro.desglose_pago WHERE maestro.credito_detalle.id = maestro.desglose_pago.id_credito_detalle AND (maestro.credito_detalle.estado IS NULL OR maestro.credito_detalle.estado = 'mora') GROUP BY maestro.credito_detalle.id, credito_detalle.monto_cobrado, credito_detalle.monto_cobrar, credito_detalle.estado HAVING credito_detalle.monto_cobrado < SUM(desglose_pago.monto) AND ABS(credito_detalle.monto_cobrado - SUM(desglose_pago.monto)) / credito_detalle.monto_cobrado > 0.01 ORDER BY credito_detalle.monto_cobrado ASC; [] []
[2025-01-28 07:24:55.932662] production.INFO: ------------------------------------------------------- [] []