PHP Application_Model_DbTable_DbGlobal::getSettingByCode方法代码示例

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