public function actiondropdownJSONCategory($vendor_id = false, $vendor_invoice_id = false) { $vendor_id = isset($_GET['vendor_id']) ? $_GET['vendor_id'] : 0; $quotation_id = isset($_GET['vendor_invoice_id']) ? $_GET['vendor_invoice_id'] : 0; $category_arr = SystemList::model()->getItemsForListCode('expenses_category', LbVendor::LB_QUERY_RETURN_TYPE_DROPDOWN_ARRAY); $category_arr = SystemList::model()->findAll('system_list_code = "expenses_category"'); $ordered_results = array(); $ordered_results[0] = array('value' => '0', 'text' => 'Choose category') + $ordered_results; foreach ($category_arr as $value) { $ordered_results[] = array('value' => $value['system_list_item_id'], 'text' => $value['system_list_item_name']); } LBApplication::renderPlain($this, array('content' => CJSON::encode($ordered_results))); }
function actionajaxDeletePayment() { if (isset($_GET['id'])) { $payment_item_id = $_GET['id']; } //delete payment item $payment = LbPaymentItem::model()->deleteByPk($payment_item_id); $invoice_id = $_GET['invoice_id']; $invoiceTotal = LbInvoiceTotal::model()->getInvoiceTotal($invoice_id); $taxRecord['paid'] = $invoiceTotal->calculateInvoicetotalPaid($invoice_id); $taxRecord['outstanding'] = $invoiceTotal->calculateInvoiceTotalOutstanding(); if ($invoiceTotal->calculateInvoiceTotalOutstanding() <= 0) { $taxRecord['status'] = 'I_PAID'; } else { $taxRecord['status'] = 'Open'; } //update invoice total // if($payment->delete()) // echo 'success'; LBApplication::renderPlain($this, array('content' => CJSON::encode($taxRecord))); }
public function actionupdateComment() { $description = false; if (isset($_POST['id_comment'])) { $id_commment = $_POST['id_comment']; } if (isset($_POST['description'])) { $description = $_POST['description']; } $model = LbComment::model()->findByPk($id_commment); $model->lb_comment_description = $description; $date = date('Y-m-d'); $model->lb_comment_date = $date; if ($model->update()) { $response = array(); $response['success'] = YES; $response['lb_comment_description'] = nl2br($model->lb_comment_description); $response['lb_comment_date'] = $model->lb_comment_date; LBApplication::renderPlain($this, array('content' => CJSON::encode($response))); } }
public function actionCreateBlankTax($id) { $invoiceItem = new LbInvoiceItem(); $result = $invoiceItem->addBlankTax($id); if ($result) { $response = array(); $response['success'] = YES; $response['invoice_item_id'] = $invoiceItem->lb_record_primary_key; LBApplication::renderPlain($this, array('content' => CJSON::encode($response))); } }
public function actionajaxQuickCreateCurrency() { $invoice_id = isset($_REQUEST['invoice_id']) ? $_REQUEST['invoice_id'] : ''; // $model = LbInvoice::model()->findByPk($invoice_id); $model = $this->loadModel($invoice_id); $GeneraModel = new LbGenera(); if (isset($_POST['LbGenera'])) { $GeneraModel->attributes = $_POST['LbGenera']; if ($GeneraModel->save()) { $model->lb_invoice_currency = $GeneraModel->lb_record_primary_key; $model->save(); } LBApplication::renderPlain($this, array('content' => CJSON::encode($GeneraModel))); return true; } LBApplication::renderPartial($this, '_form_currency', array('model' => $model, 'GeneraModel' => $GeneraModel)); }
public function actionAjaxQuickCreateTax($id) { $model = new LbTax(); $submission_type = isset($_GET['form_type']) ? $_GET['form_type'] : 'default'; $quotationModel = LbQuotation::model()->findByPk($id); if (isset($_POST['LbTax'])) { $model->attributes = $_POST['LbTax']; $lbtax_arr = $_POST['LbTax']; if (!LbTax::model()->IsNameTax($lbtax_arr['lb_tax_name'])) { $error['error'] = "Tax Name Exist."; LBApplication::renderPlain($this, array('content' => CJSON::encode($error))); return false; } if ($model->save()) { $result['yes'] = true; if ($submission_type == 'ajax') { // auto add this tax item into this invoice $quotaitonTax = new LbQuotationTax(); if ($quotaitonTax->addTaxToQuotation($id, $model)) { $this->actionAjaxUpdateTaxs($id); } // print json result of this quotation item //LBApplication::renderPlain($this, array('content'=>CJSON::encode($result))); return true; } } } $submission_details = array(); $submission_details["type"] = $submission_type; LBApplication::render($this, '_form_tax', array('model' => $model, 'quotationModel' => $quotationModel, 'submission_details' => $submission_details)); }
public function actionsavePaymentVoucher() { $model = new LbPaymentVoucher(); $pv_no = false; $pv_title = false; $pv_date = false; $pv_description = false; if ($_POST['pv_no']) { $pv_no = $_POST['pv_no']; } $issetPv = LbPaymentVoucher::model()->find('lb_payment_voucher_no = "' . $pv_no . '"'); // if(count($issetPv) > 0) // { // $response = array(); // $response['success'] = NO; // // // LBApplication::renderPlain($this, array('content'=> CJSON::encode($response))); // return; // } if ($_POST['pv_title']) { $pv_title = $_POST['pv_title']; } if ($_POST['pv_date']) { $pv_date = $_POST['pv_date']; } if ($_POST['pv_description']) { $pv_description = $_POST['pv_description']; } $idPv = false; if (isset($_REQUEST['idPv'])) { $idPv = $_REQUEST['idPv']; } //company $id = $model->savePaymentVoucher($pv_no, $pv_title, $pv_date, $pv_description, $idPv); $count = count($_POST['iem_ex_arr']); $expenses_item = $_POST['iem_ex_arr']; for ($i = 0; $i < $count; $i++) { if ($expenses_item[$i] > 0) { $PvExpenses = new LbPvExpenses(); $PvExpenses->lb_expenses_id = $expenses_item[$i]; $PvExpenses->lb_payment_voucher_id = $id; if (LbPvExpenses::model()->getExpensesPV($expenses_item[$i], $id) == false) { $PvExpenses->insert(); } } } if ($id) { $response = array(); $response['success'] = YES; $response['id'] = $id; LBApplication::renderPlain($this, array('content' => CJSON::encode($response))); } }
public function actionCreateDefaultNote() { $model = new LbDefaultNote(); $lastDefaultNote = LbDefaultNote::model()->getFullRecords(); if (count($lastDefaultNote) > 0) { return false; } else { if ($model->save()) { return LBApplication::renderPlain($this, array('content' => CJSON::encode($model))); } } }
/** * json data source for x-editable dropdown to get contacts */ public function actionDropdownJSON() { $allow_add = isset($_GET['allow_add']) ? $_GET['allow_add'] : NO; $invoice_id = isset($_GET['invoice_id']) ? $_GET['invoice_id'] : 0; $quotation_id = isset($_GET['quotation_id']) ? $_GET['quotation_id'] : 0; $vendor_id = isset($_GET['vendor_id']) ? $_GET['vendor_id'] : 0; $vendor_invoice_id = isset($_GET['lb_vendor_invoice_id']) ? $_GET['lb_vendor_invoice_id'] : 0; // override customer id if invoice id is provided if ($vendor_id) { $vendor = LbVendor::model()->findByPk($vendor_id); $customer_id = $vendor->lb_vendor_supplier_id; } if ($vendor_invoice_id) { $vendor_invoice = LbVendorInvoice::model()->findByPk($vendor_invoice_id); $customer_id = $vendor_invoice->lb_vd_invoice_supplier_id; } if ($invoice_id) { $invoice = LbInvoice::model()->findByPk($invoice_id); $customer_id = $invoice->lb_invoice_customer_id; } // override customer id if quotation id is provided if ($quotation_id) { $quotation = LbQuotation::model()->findByPk($quotation_id); $customer_id = $quotation->lb_quotation_customer_id; } // get contacts; $results = LbCustomerContact::model()->getContacts($customer_id, LbCustomerAddress::LB_QUERY_RETURN_TYPE_DROPDOWN_ARRAY); // prepend new address link if allow add new if ($allow_add && $allow_add != 2) { $results = array('0' => 'Choose contact', '-1' => '-- Add new contact --') + $results; } if ($vendor_id || $vendor_invoice_id) { $results = array('0' => 'Choose contact') + $results; } // we want to preserve order $ordered_results = array(); foreach ($results as $key => $text) { $ordered_results[] = array('value' => $key, 'text' => $text); } LBApplication::renderPlain($this, array('content' => CJSON::encode($ordered_results))); }
public function actionExpensesNewCustomer() { // $model = $this->loadModel($id); $expenses_id = isset($_REQUEST['expenses_id']) ? $_REQUEST['expenses_id'] : 0; // $submission_type = isset($_GET['form_type']) ? $_GET['form_type'] : 'default'; $expensesModel = LbExpenses::model()->findByPk($expenses_id); $customerModel = new LbCustomer(); $addressModel = new LbCustomerAddress(); $contactModel = new LbCustomerContact(); $own = false; if (isset($_POST['LbCustomer'])) { $customerModel->attributes = $_POST['LbCustomer']; // $customerModel->lb_customer_is_own_company = 0; if ($customerModel->save()) { // if($submission_type == 'ajax'){ if (isset($expenses_id) && $expenses_id > 0) { $expenses_customer = new LbExpensesCustomer(); $expenses_customer->lb_expenses_id = $expenses_id; $expenses_customer->lb_customer_id = $customerModel->lb_record_primary_key; $expenses_customer->save(); LBApplication::renderPlain($this, array('content' => CJSON::encode($expenses_customer))); } if (isset($_POST['LbCustomerAddress'])) { $addressModel->attributes = $_POST['LbCustomerAddress']; $addressModel->lb_customer_id = $customerModel->lb_record_primary_key; $addressModel->save(); } // save contact if any if (isset($_POST['LbCustomerContact'])) { $contactModel->attributes = $_POST['LbCustomerContact']; $contactModel->lb_customer_id = $customerModel->lb_record_primary_key; if ($contactModel->save()) { // automatically assign this contact to submitted address $contactAddressModel = new LbCustomerAddressContact(); $contactAddressModel->lb_customer_address_id = $addressModel->lb_record_primary_key; $contactAddressModel->lb_customer_contact_id = $contactModel->lb_record_primary_key; $contactAddressModel->save(); } } } } LBApplication::render($this, 'addCustomer', array('expensesModel' => $expensesModel, 'own' => $own, 'customerModel' => $customerModel, 'addressModel' => $addressModel, 'contactModel' => $contactModel)); }