public function purchaseAction() { $db = new report_Model_DbTable_DbReport(); $db_global = new Application_Model_DbTable_DbGlobal(); $form = new report_Form_FrmReport(); $itemRows = $db_global->getProductOption(); $this->view->itemsOption = $itemRows; $company_name = $db_global->getSettingByCode(4); $slogan = $db_global->getSettingByCode(5); $address = $db_global->getSettingByCode(2); $tel = $db_global->getSettingByCode(3); $qty_warning = $db_global->getSettingByCode(6); $this->view->company_name = $company_name; $this->view->slogan = $slogan; $this->view->address = $address; $this->view->tel = $tel; if ($this->getRequest()->isPost()) { $data = $this->getRequest()->getPost(); $search = array('txt_search' => $data['txt_search'], 'start_date' => $data['start_date'], 'end_date' => $data['end_date'], 'status' => $data['status'], 'supplier' => $data['supplier'], 'pay_status' => $data['pay_status'], 'purchase_no' => $data['purchase_no']); } else { $search = array('txt_search' => '', 'start_date' => date('Y-m-d'), 'end_date' => date('Y-m-d'), 'status' => -1, 'supplier' => -1, 'pay_status' => -1, 'purchase_no' => -1); } $sale = $db->getPurchase($search); $this->view->sale = $sale; $this->view->frm = $form->FrmSearch(); }
public function FrmSaleOrder($frm = null) { $db = new Application_Model_DbTable_DbGlobal(); $db_table = new saleorder_Model_DbTable_DbSaleOrder(); $rs_table = $db_table->getAllTable(); $option_table = array('0' => $this->tr->translate("CHOOSE_TABLE")); foreach ($rs_table as $row) { $option_table[$row["tab_id"]] = $row["name_en"] . "-" . $row["name_km"]; } $table = new Zend_Form_Element_Select("table"); $table->setAttribs(array('class' => 'select validate[required]', 'style' => 'width:100%')); $table->setMultiOptions($option_table); $c_date = date('Y-m-d'); $date = new Zend_Form_Element_Text('date'); $date->setAttribs(array('id' => 'datepicker', 'style' => 'float:left;width:100%', 'class' => 'form-control')); $date->setValue($c_date); $row_customer = $db->getCustomer(); foreach ($row_customer as $rs_customer) { $option_cu[$rs_customer["customer_id"]] = $rs_customer["name_kh"] . "-" . $rs_customer["name_en"]; } $customer = new Zend_Form_Element_Select("customer"); $customer->setAttribs(array('class' => 'select validate[required]', 'style' => 'width:100%')); $customer->setMultiOptions($option_cu); $saleorder_num = $db_table->getSaleOrderNo(); $saleorder_no = new Zend_Form_Element_Text("saleorder_no"); $saleorder_no->setAttribs(array('class' => 'validate[required]', 'readOnly' => 'readOnly', 'style' => 'color:red')); $saleorder_no->setValue($saleorder_num); $row_currency_setting = $db->getSettingByCode(1); $currency = new Zend_Form_Element_Select("currency"); $currency->setAttribs(array('class' => 'validate[required]', 'style' => 'width:100%', 'onChange' => 'getRate();')); $row_currency = $db->getAllCurrency(); foreach ($row_currency as $rs_currency) { $option_currency[$rs_currency["cu_id"]] = $rs_currency["cu_name_km"] . "-" . $rs_currency["cu_name_en"]; } $currency->setValue($row_currency_setting); $currency->setMultiOptions($option_currency); $grand_total = new Zend_Form_Element_Text("gran_total"); $grand_total->setAttribs(array('class' => 'validate[required]')); $grand_pay = new Zend_Form_Element_Text("gran_pay"); $grand_pay->setAttribs(array('class' => 'validate[required]', 'onChange' => "doBalance();")); $balance = new Zend_Form_Element_Text("balance"); $balance->setAttribs(array('class' => 'validate[required]')); $this->addElements(array($balance, $grand_pay, $grand_total, $currency, $customer, $table, $date, $saleorder_no)); if ($frm != "") { $saleorder_no->setValue($frm["order_no"]); $customer->setValue($frm["customer_id"]); $currency->setValue($frm["currency_id"]); $date->setValue($frm["date"]); } return $this; }
public function poseditAction() { $id = $this->getRequest()->getParam('id'); $db = new saleorder_Model_DbTable_DbSaleOrder(); $db_global = new Application_Model_DbTable_DbGlobal(); $session = $session_user = new Zend_Session_Namespace('auth'); $user_id = $session_user->fullname; $this->view->user = $user_id; $qty_warning = $db_global->getSettingByCode(6); $this->view->qty_warning = $qty_warning; $row_sale_order = $db_global->getSaleOrderById($id); $row_sale_order_detail = $db_global->getSaleOrderDetail($id); $this->view->data_sale_order = $row_sale_order_detail; $form = new saleorder_Form_FrmSaleOrder(); $this->view->frm = $form->FrmSaleOrder($row_sale_order); $currency_setting = $db_global->getSettingByCode(1); $company_name = $db_global->getSettingByCode(4); $slogan = $db_global->getSettingByCode(5); $address = $db_global->getSettingByCode(2); $tel = $db_global->getSettingByCode(3); $this->view->currency_setting = $currency_setting; $this->view->company_name = $company_name; $this->view->slogan = $slogan; $this->view->address = $address; $this->view->tel = $tel; $itemRows = $db->getProductOption(); $this->view->itemsOption = $itemRows; if ($this->getRequest()->isPost()) { $data = $this->getRequest()->getPost(); if (isset($data["save"])) { // print_r($data);exit(); $db->editOrder($data, $id); Application_Form_FrmMessage::redirectUrl('/index/pos'); } elseif (isset($data["km"]) == 2) { $dbs = new Application_Model_DbTable_DbSiteLanguages(); $ids = 2; $lang = $dbs->getbyid($ids); $session_lang = new Zend_Session_Namespace('lang'); $session_lang->unlock(); $session_lang->lang_id = $lang['id']; $session_lang->lang = $lang['language']; //print_r($lang);exit(); } elseif (isset($data["en"]) == 1) { $dbs = new Application_Model_DbTable_DbSiteLanguages(); $ids = 1; $lang = $dbs->getbyid($ids); $session_lang = new Zend_Session_Namespace('lang'); $session_lang->unlock(); $session_lang->lang_id = $lang['id']; $session_lang->lang = $lang['language']; //$this->_redirect('/login'); //exit(); } } }