echo Yii::t('lang', 'Method');
?>
</th>
<th width="150" class="lb-grid-header"><?php
echo Yii::t('lang', 'Date');
?>
</th>
<th class="lb-grid-header"><?php
echo Yii::t('lang', 'Notes');
?>
</th>
</tr>
</thead>
<tbody>
<?php
$paymentItem = LbPaymentVendorInvoice::model()->findAll('lb_vendor_invoice_id=' . intval($data_invocie->lb_record_primary_key));
foreach ($paymentItem as $data_paymentItem) {
$payment = LbPaymentVendor::model()->findByPk(intval($data_paymentItem->lb_payment_id));
?>
<tr>
<td style="text-align: right"><?php
echo number_format($data_paymentItem->lb_payment_item_amount, 2);
?>
</td>
<td style="text-align: center"><?php
echo $method[$payment->lb_payment_vendor_method];
?>
</td>
<td style="text-align: center"><?php
echo $payment->lb_payment_vendor_date;
?>
function actionAjaxSavePayment()
{
$model = new LbPaymentVendor();
if (isset($_POST['LbPaymentVendor'])) {
$payment_arr = $_POST['LbPaymentVendor'];
$model->lb_payment_vendor_no = LbPaymentVendor::model()->FormatPaymentVendorNo(LbPaymentVendor::model()->getPaymentVendorNextNum());
$model->lb_payment_vendor_customer_id = $_POST['customer_id'];
$model->lb_payment_vendor_method = $payment_arr['lb_payment_vendor_method'];
$model->lb_payment_vendor_total = $_POST['total_payment'];
$date1 = date_create($payment_arr['lb_payment_date']);
$model->lb_payment_vendor_date = date_format($date1, 'Y-m-d');
//$model->lb_invoice_id = $_POST[]
if ($model->insert()) {
//LbPayment::model()->setPaymentNextNum();
// save payment item
$count_payment = count($_POST['payment_check']);
$payment_invoice = $_POST['payment_check'];
$payment_note = $_POST['payment_note'];
$payment_item_amount = $_POST['payment'];
for ($i = 0; $i < $count_payment; $i++) {
if ($payment_item_amount[$i] > 0) {
$paymentItemModel = new LbPaymentVendorInvoice();
$paymentItemModel->lb_payment_id = $model->lb_record_primary_key;
$paymentItemModel->lb_vendor_invoice_id = $payment_invoice[$i];
$paymentItemModel->lb_payment_item_note = $payment_note[$i];
$paymentItemModel->lb_payment_item_amount = $payment_item_amount[$i];
if ($paymentItemModel->save()) {
$invoiceVendor = LbVendorTotal::model()->find('lb_vendor_invoice_id = ' . $paymentItemModel->lb_vendor_invoice_id);
$total = LbPaymentVendorInvoice::model()->calculateInvoicetotalPaid($paymentItemModel->lb_vendor_invoice_id);
$modelVI = LbVendorTotal::model()->findByPk($invoiceVendor['lb_record_primary_key']);
$modelVI->lb_vendor_last_paid = $total;
$modelVI->lb_vendor_last_outstanding = $modelVI->lb_vendor_last_tax - $total;
$modelVI->update();
}
echo '{"status":"success"}';
} else {
echo '{"status":"fail"}';
}
}
}
}
}
public function calculateInvoicetotalPaid($invoice_id)
{
$paymentItem = LbPaymentVendorInvoice::model()->findAll('lb_vendor_invoice_id = ' . intval($invoice_id));
$total_paid = 0;
foreach ($paymentItem as $data) {
$total_paid += $data->lb_payment_item_amount;
}
return $total_paid;
}
