UPDATE mantenimientopago SET fechadeentrada = '2022-01-01' WHERE Mes = 'Enero ' AND Ano = '2022'

DELETE FROM mantenimientopagodetalle WHERE Items = 'Mora' AND Condominio = 'Torre RR5' AND Mes = 'Enero' AND Ano = '2024';
DELETE FROM mantenimientopagodetalle WHERE Items = 'Mora';

DELETE FROM mantenimientopagodetalle WHERE Items = 'Mora Ext';

UPDATE mantenimientopago,mantenimientopagodetalle SET mantenimientopago.Cuotabasica = mantenimientopagodetalle.Amount WHERE mantenimientopago.ID = mantenimientopagodetalle.InvID 
AND mantenimientopagodetalle.Items = 'Cuota Basica'


UPDATE mantenimientopago,mantenimientopagodetalle SET mantenimientopago.Totalpagadocuota = mantenimientopagodetalle.Totalpagado WHERE mantenimientopago.ID = mantenimientopagodetalle.InvID
AND mantenimientopagodetalle.Items = 'Cuota Basica'



UPDATE mantenimientopago SET Totalpagadocuota ='0' WHERE Totalpagadocuota IS NULL;


UPDATE condominios SET Intervalonormal ='30' 

UPDATE condominios SET Intervaloext ='30' 


UPDATE mantenimientopago SET Intervalocalculo ='0'

UPDATE mantenimientopago SET Mesmora ='NULL', Anomora = 'NULL'



SELECT * FROM mantenimientopago WHERE Diasmora BETWEEN Tiempomora AND Intervalonormal


SELECT * FROM mantenimientopago WHERE Diasmora BETWEEN Intervalonormal AND Tiempomora



SELECT Porcentajenormal,Condominio,Residencia, SUM(Cuotabasica - Totalpagadocuota) as Totalcuota FROM mantenimientopago WHERE (Mesmora !='Diciembre' OR Mesmora IS NULL ) AND (Anomora !='2023' OR Anomora IS NULL) AND Tipocuota = 'Normal' 
AND Pagostatus = 'No pagado'  AND Intervaloinf ='1' AND Intervalosup = '1' AND Cuotabasica != Totalpagadocuota AND Tiempomora IS NOT NULL GROUP BY Residencia, Condominio


SELECT Porcentajenormal,Condominio,Residencia,Mes,Ano,Intervalosup,Intervaloinf,Diasmora FROM mantenimientopago WHERE (Mesmora !='Diciembre' OR Mesmora IS NULL ) AND (Anomora !='2023' OR Anomora IS NULL) AND Tipocuota = 'Normal' AND Pagostatus = 'No pagado' AND Cuotabasica != Totalpagadocuota AND Tiempomora IS NOT NULL; 


SELECT Porcentajenormal,Condominio,Residencia, SUM(Cuotabasica - Totalpagadocuota) as Totalcuota FROM mantenimientopago WHERE (Mesmora !='Diciembre' OR Mesmora IS NULL ) AND (Anomora !='2023' OR Anomora IS NULL) AND Tipocuota = 'Normal' AND Pagostatus = 'No pagado'  AND Diasmora BETWEEN Intervalonormal AND Tiempomora AND Cuotabasica != Totalpagadocuota AND Tiempomora IS NOT NULL GROUP BY Residencia, Condominio




SELECT Porcentajenormal,Condominio,Residencia, SUM(Cuotabasica - Totalpagadocuota) as Totalcuota FROM mantenimientopago WHERE (Mesmora !='Diciembre' OR Mesmora IS NULL ) AND (Anomora !='2023' OR Anomora IS NULL) AND Tipocuota = 'Normal' AND Pagostatus = 'No pagado' AND (Diasmora BETWEEN Intervalonormal AND Tiempomora OR Diasmora > Tiempomora) AND Cuotabasica != Totalpagadocuota AND Tiempomora IS NOT NULL GROUP BY Residencia, Condominio; 


SELECT Porcentajenormal,Condominio,Residencia, SUM(Cuotabasica - Totalpagadocuota) as Totalcuota FROM mantenimientopago WHERE (Mesmora !='$Mesactual' OR Mesmora IS NULL ) AND (Anomora !='$Anoactual' OR Anomora IS NULL) AND Tipocuota = 'Normal' 
AND Pagostatus = 'No pagado'  AND Diasmora > Intervalonormal AND Condominio = 'TORRE JESHÚA V' AND Residencia = 'PH-C' AND Cuotabasica != Totalpagadocuota AND Tiempomora IS NOT NULL

SELECT * FROM mantenimientopagodetalle WHERE (Amount - IFNULL(Totalpagado,0)) <= 2 AND (Amount - IFNULL(Totalpagado,0)) >= -2 ; between

SELECT * FROM mantenimientopagodetalle WHERE (Amount - IFNULL(Totalpagado,0)) >= 2 OR (Amount - IFNULL(Totalpagado,0)) <= -2; notween


Pagorealizado = InvTotal 


mysqli_query($con, "UPDATE mantenimientopago SET Pagostatus ='Pagado' WHERE (InvTotal - IFNULL(Pagorealizado,0)) <= 2 AND (InvTotal - IFNULL(Pagorealizado,0)) >= -2 AND ID ='$InvID2'");
mysqli_query($con, "UPDATE mantenimientopagodetalle SET Estatus ='Pagado' WHERE (Amount - IFNULL(Totalpagado,0)) <= 2 AND (Amount - IFNULL(Totalpagado,0)) >= -2  AND InvID ='$InvID2'");  



NEW.Pagorestante <= 2 AND NEW.Pagorestante >= -2