SELECT #getQueryString()# WHERE salesPayment.idSalesPayment= SELECT #getQueryString()# WHERE salesPayment.idSalesClientUnit= AND salesPayment.idSalesPaymentType= AND ( MONTH(salesPayment.datePayment)= AND YEAR(salesPayment.datePayment)= ) ORDER BY #arguments.orderBy##module.list.orderBy# SELECT #getQueryString()# WHERE 1=1 AND ( salesClient.nameFirst LIKE OR salesClient.nameFirst1 LIKE ) AND ( salesClient.nameLast LIKE OR salesClient.nameLast1 LIKE ) AND salesClientUnit.idProject= AND salesClientUnit.idEmployee= GROUP BY salesPayment.idSalesClientUnit ORDER BY #arguments.orderBy##module.list.orderBy# SELECT salesPayment.idSalesPayment, salesUnit.number, salesUnit.quantity, salesClientUnit.idSalesClient, CONCAT(TRIM(CONCAT(salesClient.nameFirst, ' ', salesClient.nameFirst1)), ' ', TRIM(CONCAT(salesClient.nameLast, ' ', salesClient.nameLast1))) AS nameFull, SUM(salesPayment.amountExpected) AS amountExpected, SUM(salesPayment.amount) AS amount, salesClientUnitPaymentSchema.dateDelivery FROM salesPayment LEFT JOIN salesClientUnit ON salesPayment.idSalesClientUnit=salesClientUnit.idSalesClientUnit LEFT JOIN salesUnit ON salesClientUnit.idSalesUnit=salesUnit.idSalesUnit LEFT JOIN salesClient ON salesClientUnit.idSalesClient=salesClient.idSalesClient LEFT JOIN salesClientUnitPaymentSchema ON salesPayment.idSalesClientUnit=salesClientUnitPaymentSchema.idSalesClientUnit WHERE 1=1 AND salesClientUnit.idProject= GROUP BY salesPayment.idSalesClientUnit ORDER BY salesUnit.number SELECT idSalesPayment FROM salesPayment WHERE salesPayment.idSalesClientUnit= AND salesPayment.idSalesPaymentType= AND salesPayment.datePayment= AND salesPayment.amount= AND salesPayment.idSalesPayment != SELECT SUM(amount) AS amountPayed FROM salesPayment WHERE salesPayment.idSalesClientUnit= AND salesPayment.idSalesPaymentType= AND datePaymentExpected = IS NULL AND CAST(datePayment AS DATE) <= SELECT COUNT(idSalesPayment) AS numberOfPayments FROM salesPayment WHERE salesPayment.idSalesClientUnit= AND salesPayment.idSalesPaymentType= AND datePaymentExpected = IS NULL DELETE FROM salesPayment WHERE idSalesPaymentType= AND idSalesClientUnit= AND datePaymentExpected= IS NULL AND datePayment IS NULL INSERT INTO salesPayment ( dateRegistration, idSalesPaymentType, idSalesClientUnit, idEmployee, datePaymentExpected, datePayment, amountExpected, amount ) VALUES ( , , , , NULL, , , ) ON DUPLICATE KEY UPDATE dateRegistration=, idEmployee=, datePayment=, amount= Details: " & cfcatch.Detail> UPDATE salesPayment SET dateRegistration=, idSalesPaymentType=, idSalesClientUnit=, idEmployee=, datePaymentExpected=NULL, datePayment=, amount= WHERE salesPayment.idSalesPayment= Details: " & cfcatch.Detail> DELETE FROM salesPayment WHERE salesPayment.idSalesPayment= Details: " & cfcatch.Detail>