Exemplo n.º 1
0
 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");
         }
     }
 }