function processPaymentExtraAmt($idpaylog) { $q = new sqlQuery($this->getDbCon()); $do_paymentlog = new PaymentLog(); $do_paymentlog->getId($idpaylog); $inv_log_amt = $do_paymentlog->amount; $qry = "Select sum(payment_invoice.amount ) as amount,payment_invoice.idpayment\r\n from payment_invoice \r\n Where payment_invoice.idpayment = " . $idpaylog . " GROUP BY payment_invoice.idpayment "; //echo $qry.'<br />'; $q->query($qry); if ($q->getNumRows()) { $q->fetch(); $total_added_amt = $q->getData("amount"); $diff = $inv_log_amt - $total_added_amt; if ($diff == 0 || $diff == 0.0) { $this->updatePaymentExtraAmount($idpaylog, $diff, "delete"); } elseif ($diff > 0) { $this->updatePaymentExtraAmount($idpaylog, $diff, "update"); } } }