<?php echo $receipt->amount; ?> </td> <td> <?php $balance += $receipt->amount; echo $balance; ?> </td> </tr> <?php } ?> <?php foreach (AutomatedTransactionSuppliers::model()->findAll(array('order' => 'paid_date', 'condition' => 'supplier_id=:supplier', 'params' => array(':supplier' => $id))) as $receipt) { ?> <tr> <td> </td> <td> </td> <td> <?php echo $receipt->paid_date; ?> </td> <td> </td>
<tr> <td colspan="8"><?php echo $creditRow->credited_date . '- ' . $creditRow->supplier->supplierName . '-OverPayment on purchases invoice #' . $creditRow->credited_from . ' transferred to customer credit'; ?> </td> <td><?php $total_debit_suppliersCredit += $creditRow->amount; echo $creditRow->amount; ?> </td> <td></td> </tr> <?php } foreach (AutomatedTransactionSuppliers::model()->findAll(array('condition' => 'paid_date>=:start_date AND paid_date<=:end_date', 'params' => array(':start_date' => $model->from_date, ':end_date' => $model->to_date))) as $transac) { ?> <tr> <td colspan="8"><?php echo $transac->paid_date . '- ' . $transac->supplier->supplierName . '-Automatic credit allocation to purchases invoice #' . $transac->to_purchases_invoice_id; ?> </td> <td><?php $total_debit_suppliersCredit += $transac->amount; echo $transac->amount; ?> </td> <td></td> </tr>
public function GetCreditfor($purchasesInvoice, $remainingCredit) { foreach (SuppliersCredit::model()->findAll(array('condition' => 'supplier_id=:supplier', 'params' => array(':supplier' => $purchasesInvoice->supplier_id))) as $indModel) { $creditRemained = $indModel->amount - $indModel->credit_assigned; if ($remainingCredit == 0) { //break; } else { if ($creditRemained > $remainingCredit) { $creditBorrowed = $remainingCredit; } else { $creditBorrowed = $creditRemained; } $transaction = new AutomatedTransactionSuppliers(); $transaction->paid_date = $indModel->credited_date; $transaction->from_purchases_invoice_id = $indModel->credited_from; $transaction->to_purchases_invoice_id = $purchasesInvoice->id; $transaction->amount = $creditBorrowed; $transaction->supplier_id = $purchasesInvoice->supplier_id; $indModel->credit_assigned += $creditBorrowed; $purchasesInvoice->credited += $creditBorrowed; $purchasesInvoice->save(); $transaction->save(); $indModel->save(); $remainingCredit -= $creditBorrowed; } } }
} ?> </span> <?php if ($balance >= 0) { echo $balance; } ?> </td> </tr> <?php } ?> <?php foreach (AutomatedTransactionSuppliers::model()->findAll(array('condition' => 'to_purchases_invoice_id=:invoice', 'params' => array(':invoice' => $id))) as $receipt) { ?> <tr> <td> </td> <td> </td> <td> <?php echo $receipt->paid_date; ?> </td> <td> </td>