[2025-01-24 13:11:55.685159] production.ERROR: Fallo en el chequeo: App\Services\Checkeos\Chequeos\CDsConPagosSinFechaPago [] []
[2025-01-24 13:11:55.685575] 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-24 13:11:55.685636] production.INFO: ------------------------------------------------------- [] []
[2025-01-24 13:11:55.792248] production.ERROR: Fallo en el chequeo: App\Services\Checkeos\Chequeos\CDsSinPagosConFechaPago [] []
[2025-01-24 13:11:55.792347] 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-24 13:11:55.792376] production.INFO: ------------------------------------------------------- [] []
[2025-01-24 13:11:56.537085] production.ERROR: Fallo en el chequeo: App\Services\Checkeos\Chequeos\DiferenciaItemsCd [] []
[2025-01-24 13:11:56.537223] 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 -- AND cd.monto_cobrado > 0 AND estado = 'mora' AND id_credito IN () GROUP BY id_credito_detalle, cd.monto_cobrar, cd.monto_cobrado HAVING diferencia < -100 OR diferencia > 100 ORDER BY diferencia DESC; [] []
[2025-01-24 13:11:56.537257] production.INFO: ------------------------------------------------------- [] []
[2025-01-24 13:11:58.918900] production.ERROR: Fallo en el chequeo: App\Services\Checkeos\Chequeos\MontoCobradoMenorSumaPagos [] []
[2025-01-24 13:11:58.919003] 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-24 13:11:58.919034] production.INFO: ------------------------------------------------------- [] []