<?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>
