Investeam

20:11:26.322===========> MarcarPagadoContratoInmobiliario.doIt: query caso P_CargaInicial no
select
a.projectID::integer as c_project_id,
a.saldo_contrato as saldo_contrato, a.saldo_inmueble as saldo_inmueble, (select max(alin.PaymentDate)
from tb_allocationpayschedule al
inner join Tb_ProjectPayScheduleLine alin on alin.tb_allocationpayschedule_ID=al.tb_allocationpayschedule_ID where al.c_project_ID=a.projectID and al.docstatus IN ('CO','CL')) as fechaPago from
(
select
cp.c_project_id::integer as projectID,
saldo_contratototal(cp.c_project_id) as saldo_contrato, saldo_contrato2(cp.c_project_id) as saldo_inmueble
from tb_allocationpayschedule al_pys inner join c_project cp on cp.c_project_ID=al_pys.c_project_ID inner join tb_estadoContrato estado on estado.tb_estadoContrato_ID=cp.tb_estadoContrato_ID
where cp.AD_Client_ID=1000000 and cp.IsPaid='N'
and al_pys.DateTrx::date >='2024-08-22 00:00:00.0'::date and al_pys.DateTrx::date <='2024-08-22 23:59:59.9'::date
and estado.IsValid='Y' and estado.IsSOTrx='Y' AND estado.IsActive='Y'
and cp.tipo_negociacion='V' and al_pys.docstatus IN ('CO', 'CL') )a [103]
20:11:26.333===========> MarcarPagadoContratoInmobiliario.doIt: de fecha inicial 2024-08-22 00:00:00.0 [103]
20:11:26.341===========> MarcarPagadoContratoInmobiliario.doIt: de fecha final 2024-08-22 23:59:59.9 [103]
20:11:26.349===========> MarcarPagadoContratoInmobiliario.doIt: >>VALOR DEL QUERY querySaldo :
select
a.projectID::integer as c_project_id,
a.saldo_contrato as saldo_contrato, a.saldo_inmueble as saldo_inmueble, (select max(alin.PaymentDate)
from tb_allocationpayschedule al
inner join Tb_ProjectPayScheduleLine alin on alin.tb_allocationpayschedule_ID=al.tb_allocationpayschedule_ID where al.c_project_ID=a.projectID and al.docstatus IN ('CO','CL')) as fechaPago from
(
select
cp.c_project_id::integer as projectID,
saldo_contratototal(cp.c_project_id) as saldo_contrato, saldo_contrato2(cp.c_project_id) as saldo_inmueble
from tb_allocationpayschedule al_pys inner join c_project cp on cp.c_project_ID=al_pys.c_project_ID inner join tb_estadoContrato estado on estado.tb_estadoContrato_ID=cp.tb_estadoContrato_ID
where cp.AD_Client_ID=1000000 and cp.IsPaid='N'
and al_pys.DateTrx::date >='2024-08-22 00:00:00.0'::date and al_pys.DateTrx::date <='2024-08-22 23:59:59.9'::date
and estado.IsValid='Y' and estado.IsSOTrx='Y' AND estado.IsActive='Y'
and cp.tipo_negociacion='V' and al_pys.docstatus IN ('CO', 'CL') )a [103]
20:11:28.855===========> MarcarPagadoContratoInmobiliario.doIt: c_projectID 1002844 [103]
20:11:28.866===========> MarcarPagadoContratoInmobiliario.doIt: saldoContrato 76399.35 [103]
20:11:28.875===========> MarcarPagadoContratoInmobiliario.doIt: saldoInmueble 76199.35 [103]
20:11:28.884===========> MarcarPagadoContratoInmobiliario.doIt: fecha 2024-08-21 00:00:00.0 [103]