?>
</td>
<td>
<?php
$balance -= $receipt->amount;
echo $balance;
?>
</td>
</tr>
<?php
}
?>
<?php
foreach (SuppliersCredit::model()->findAll(array('order' => 'credited_date', 'condition' => 'supplier_id=:supplier', 'params' => array(':supplier' => $id))) as $receipt) {
?>
<tr>
<td>
</td>
<td>
</td>
<td>
<?php
echo $receipt->credited_date;
?>
</td>
<td>
</td>
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;
}
}
}
?>
</td>
<td>
<?php
echo $model->BillingAddress;
?>
</td>
<td>
<?php
echo CHtml::link(sizeof($model->purchasesInvs), $this->createAbsoluteUrl('PurchasesInvoices/index', array('supplier' => $model->id)));
?>
</td>
<td>
<?php
$supplierCredits = SuppliersCredit::model()->findAll(array('condition' => 'supplier_id=:supplier', 'params' => array(':supplier' => $model->id)));
$credits = 0;
foreach ($supplierCredits as $supplierCredit) {
$credits += $supplierCredit->amount - $supplierCredit->credit_assigned;
}
if ($credits < 0) {
echo '-';
} else {
echo CHtml::link($credits, $this->createAbsoluteUrl('suppliers/viewTransactionCreditType', array('id' => $model->id)));
}
?>
</td>
<td>
<?php
$Invoices = PurchasesInvoices::model()->findAll(array('condition' => 'supplier_id=:supplier', 'params' => array(':supplier' => $model->id)));
?>
</th>
<th><?php
echo $total_credit_customerCredit;
?>
</th>
</tr>
<tr><td colspan="10"></td></tr>
<!----------------------------------customer credit end----------------------------------------------------------->
<tr>
<th colspan="8">Suppliers Credit</th>
</tr>
<?php
$total_credit_suppliersCredit = 0;
$total_debit_suppliersCredit = 0;
foreach (SuppliersCredit::model()->findAll(array('order' => 'credited_date', 'condition' => 'credited_date>=:start_date AND credited_date<=:end_date', 'params' => array(':start_date' => $model->from_date, ':end_date' => $model->to_date))) as $creditRow) {
?>
<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
/**
* Deletes a particular model.
* If deletion is successful, the browser will be redirected to the 'admin' page.
* @param integer $id the ID of the model to be deleted
*/
public function actionDelete($id)
{
$model1 = $this->loadModel($id);
$model1->balance = 0;
$creditModel = SuppliersCredit::model()->find(array('condition' => 'credited_from=:id', 'params' => array(':id' => $id)));
if (isset($creditModel)) {
$creditModel->credit_assigned = 0;
$creditModel->save();
}
$model1->save();
$this->redirect(array('AutomatedTransaction', 'id' => $id, 'mode' => 'delete'));
$model1->delete();
//$this->redirect(array('index'));
// if AJAX request (triggered by deletion via admin grid view), we should not redirect the browser
//if(!isset($_GET['ajax']))
// $this->redirect(isset($_POST['returnUrl']) ? $_POST['returnUrl'] : array('admin'));
}
<?php
echo '-' . $receipt->amount;
?>
</td>
<td>
<?php
$balance -= $receipt->amount;
echo $balance;
?>
</td>
</tr>
<?php
}
?>
<?php
foreach (SuppliersCredit::model()->findAll(array('condition' => 'credited_from=:invoice', 'params' => array(':invoice' => $id))) as $receipt) {
?>
<tr>
<td>
</td>
<td>
</td>
<td>
<?php
echo $receipt->credited_date;
?>
</td>
<td>
</td>
