public function FrmSaleOrderUpdate($frm = null)
{
$db = new saleorder_Model_DbTable_DbSaleOrder();
$rs_table = $db->getAllTable();
$option_table = array('0' => $this->tr->translate("CHOOSE_TABLE"));
foreach ($rs_table as $row) {
$option_table[$row["tab_id"]] = $row["code"] . ":" . $row["name_en"] . "-" . $row["name_km"];
}
$table = new Zend_Form_Element_Select("tables");
$table->setAttribs(array('class' => 'select validate[required]', 'style' => 'width:100%'));
$table->setMultiOptions($option_table);
$rs_product = $db->getAllProduct();
$option_product = array(0 => $this->tr->translate('CHOOSE_PRODUCT'));
foreach ($rs_product as $row) {
$option_product[$row["pro_id"]] = $row["item_code"] . '-' . $row["name_kh"] . '-' . $row["name_en"];
}
$product = new Zend_Form_Element_Select("product");
$product->setAttribs(array('class' => 'select form-control', 'style' => 'width:100%'));
$product->setMultiOptions($option_product);
$c_date = date('Y-m-d');
$date = new Zend_Form_Element_Text('dates');
$date->setAttribs(array('id' => 'dates', 'style' => 'float:left;width:100%', 'class' => 'form-control validate[required]'));
//$date->setValue($c_date);
$saleorder_num = $db->getSaleOrderNo();
$saleorder_no = new Zend_Form_Element_Text("saleorder_nos");
$saleorder_no->setAttribs(array('class' => 'validate[required]', 'readOnly' => 'readOnly', 'style' => 'color:red'));
$saleorder_no->setValue($saleorder_num);
$this->addElements(array($product, $table, $date, $saleorder_no));
if ($frm != "") {
$saleorder_no->setValue($frm["saleorder_no"]);
$table->setValue($frm["tab_id"]);
$date->setValue($frm["date"]);
}
return $this;
}
public function getSaleOrderByIdAction()
{
if ($this->getRequest()->IsPost()) {
$data = $this->getRequest()->getPost();
$db = new saleorder_Model_DbTable_DbSaleOrder();
$row = $db->getSaleOrderById($data);
echo Zend_Json::encode($row);
exit;
}
}
public function adjustAction()
{
$db = new product_Model_DbTable_DbProduct();
$db_global = new saleorder_Model_DbTable_DbSaleOrder();
$itemRows = $db_global->getProductOption();
$this->view->itemsOption = $itemRows;
if ($this->getRequest()->isPost()) {
$data = $this->getRequest()->getPost();
//print_r($data);exit();
if (isset($data['search'])) {
$search = array('advance_search' => $data['txt_search'], 'pro_id' => $data['add_item'], 'cate_id' => $data['cat_id'], 'brand' => $data['brand']);
} elseif (isset($data['update'])) {
$db->adjust($data);
$this->_redirect("/product/index/adjust");
} 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();
}
} else {
$search = array('advance_search' => '', 'pro_id' => -1, 'cate_id' => -1, 'brand' => -1);
}
$datas = $db->getProductAdjust($search);
$this->view->getdata = $datas;
$frm = new product_Form_Frmproduct();
$this->view->frmSearch = $frm->frmSearch();
}
