[2025-01-29 07:14:12.191900] production.ERROR: Fallo en el chequeo: App\Services\Checkeos\Chequeos\CDsConPagosSinFechaPago [] []
[2025-01-29 07:14:12.192292] 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-29 07:14:12.192338] production.INFO: ------------------------------------------------------- [] []
[2025-01-29 07:14:12.297064] production.ERROR: Fallo en el chequeo: App\Services\Checkeos\Chequeos\CDsSinPagosConFechaPago [] []
[2025-01-29 07:14:12.297160] 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-29 07:14:12.297190] production.INFO: ------------------------------------------------------- [] []
[2025-01-29 07:14:13.039186] production.ERROR: Fallo en el chequeo: App\Services\Checkeos\Chequeos\DiferenciaItemsCd [] []
[2025-01-29 07:14:13.039299] 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-29 07:14:13.039332] production.INFO: ------------------------------------------------------- [] []
[2025-01-29 07:14:15.418270] production.ERROR: Fallo en el chequeo: App\Services\Checkeos\Chequeos\MontoCobradoMenorSumaPagos [] []
[2025-01-29 07:14:15.418374] 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-29 07:14:15.418404] production.INFO: ------------------------------------------------------- [] []