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