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; }