public function editAction() { $db = new Other_Model_DbTable_DbVillage(); if ($this->getRequest()->isPost()) { $_data = $this->getRequest()->getPost(); try { $db->addVillage($_data); Application_Form_FrmMessage::Sucessfull("ការបញ្ចូលជោគជ័យ !", '/other/Village'); } catch (Exception $e) { Application_Form_FrmMessage::message("ការបញ្ចូលមិនជោគជ័យ"); $err = $e->getMessage(); Application_Model_DbTable_DbUserLog::writeMessageError($err); } } $id = $this->getRequest()->getParam("id"); $row = $db->getVillageById($id); $this->view->row = $row; if (empty($row)) { $this->_redirect('other/Village'); } $fm = new Other_Form_FrmVillage(); $frm = $fm->FrmAddVillage($row); Application_Model_Decorator::removeAllDecorator($frm); $this->view->frm_village = $frm; $db = new Application_Model_DbTable_DbGlobal(); $this->view->district = $db->getAllDistricts(); $this->view->commune_name = $db->getCommune(); }
public function editAction() { $_dbmodel = new Accounting_Model_DbTable_DbGeneraljurnal(); if ($this->getRequest()->isPost()) { $_data = $this->getRequest()->getPost(); try { $_db = new Accounting_Model_DbTable_DbJournal(); $_db->upDateJournal($_data); Application_Form_FrmMessage::Sucessfull("INSERT_SUCCESS", "/accounting/generaljurnal"); } catch (Exception $e) { Application_Form_FrmMessage::message("INSERT_FAIL"); Application_Model_DbTable_DbUserLog::writeMessageError($e->getMessage()); } } $id = $this->getRequest()->getParam('id'); $row = $_dbmodel->getjurnalEntryById($id); $this->view->jdetail = $_dbmodel->getjurnalEntryDetail($id); $fm = new Accounting_Form_FrmGeneraljurnal(); $frm = $fm->FrmGeneraljurnal($row); Application_Model_Decorator::removeAllDecorator($frm); $this->view->frm_fixedasset = $frm; $db = new Accounting_Model_DbTable_DbJournal(); $this->view->row_parents = $db->getAllParrentAccount(1); $this->view->row_accountname = $db->getAllParrentAccount(1, 1); }
function editAction() { if ($this->getRequest()->isPost()) { $data = $this->getRequest()->getPost(); $db_wihtdraw = new Partner_Model_DbTable_DbWithdraw(); try { if ($this->getRequest()->getPost("btn_save_close")) { $db_wihtdraw->updatewithdraw($data); Application_Form_FrmMessage::Sucessfull('ការបញ្ចូលជោគជ័យ', self::REDIRECT_URL); } } catch (Exception $e) { $this->view->msg = 'ការបញ្ចូលមិនជោគជ័យ'; } } $db_wihtdraw = new Partner_Model_DbTable_DbWithdraw(); $id = $this->getRequest()->getParam("id"); $row = $db_wihtdraw->getpartnerById($id); if (empty($row)) { } $this->view->id = $row['id']; $withdraw = new Partner_Form_FrmWithdraw(); $frm = $withdraw->dakMoney($row); Application_Model_Decorator::removeAllDecorator($frm); $this->view->frm = $frm; }
public function editUserTypeAction() { $user_type_id = $this->getRequest()->getParam('id'); if (!$user_type_id) { $user_type_id = 0; } $form = new RsvAcl_Form_FrmUserType(); $db = new RsvAcl_Model_DbTable_DbUserType(); $rs = $db->getUserTypeInfo('SELECT * FROM rsv_acl_user_type where user_type_id=' . $user_type_id); Application_Model_Decorator::setForm($form, $rs); $this->view->form = $form; $this->view->user_id = $user_type_id; $tr = Application_Form_FrmLanguages::getCurrentlanguage(); if ($this->getRequest()->isPost()) { $post = $this->getRequest()->getPost(); if ($rs[0]['user_type'] == $post['user_type']) { Application_Form_FrmMessage::message($tr->translate('ROW_AFFECTED')); $db->updateUserType($post, $rs[0]['user_type_id']); Application_Form_FrmMessage::redirector('/rsvAcl/user-type/index'); } else { if (!$db->isUserTypeExist($post['user_type'])) { $db->updateUserType($post, $rs[0]['user_type_id']); Application_Form_FrmMessage::message($tr->translate('ROW_AFFECTED')); Application_Form_FrmMessage::redirector('/rsvAcl/user-type/index'); } else { Application_Form_FrmMessage::message('User had existed already'); } } } }
public function editAclAction() { $acl_id = $this->getRequest()->getParam('id'); if (!$acl_id) { $acl_id = 0; } $form = new RsvAcl_Form_FrmAcl(); $db = new RsvAcl_Model_DbTable_DbAcl(); $rs = $db->getUserInfo('SELECT * FROM rsv_acl_acl where acl_id=' . $acl_id); Application_Model_Decorator::setForm($form, $rs); $this->view->form = $form; $this->view->acl_id = $acl_id; if ($this->getRequest()->isPost()) { $post = $this->getRequest()->getPost(); if ($rs[0]['action'] == $post['action']) { $db->updateAcl($post, $rs[0]['acl_id']); $tr = Application_Form_FrmLanguages::getCurrentlanguage(); Application_Form_FrmMessage::message($tr->translate('ROW_AFFECTED')); Application_Form_FrmMessage::redirector('/rsvAcl/acl/index'); } else { if (!$db->isActionExist($post['action'])) { $db->updateAcl($post, $rs[0]['acl_id']); $tr = Application_Form_FrmLanguages::getCurrentlanguage(); Application_Form_FrmMessage::message($tr->translate('ROW_AFFECTED')); Application_Form_FrmMessage::redirector('/rsvAcl/acl/index'); } else { Application_Form_FrmMessage::message('Action had existed already'); } } } }
public function editAction() { if ($this->getRequest()->isPost()) { try { $_data = $this->getRequest()->getPost(); $_dbmodel = new Application_Model_DbTable_DbDept(); $_dbmodel->UpdateDepartment($_data); Application_Form_FrmMessage::Sucessfull("ការកៃប្រែដោយជោគជ័យ !", "/global/faculty/index"); //$this->_redirect(""); } catch (Exception $e) { $err = $e->getMessage(); Application_Form_FrmMessage::message("Application Error!"); Application_Model_DbTable_DbUserLog::writeMessageError($err); echo $e->getMessage(); exit; } } $id = $this->getRequest()->getParam("id"); $_db = new Application_Model_DbTable_DbGlobal(); $_row = $_db->getDeptById($id); $frm = new Application_Form_FrmOther(); $frm->FrmAddDept($_row); Application_Model_Decorator::removeAllDecorator($frm); $this->view->frm_dept = $frm; }
public function editAction() { if ($this->getRequest()->isPost()) { $data = $this->getRequest()->getPost(); $db = new Callecterall_Model_DbTable_DbCallecterall(); try { if (isset($data['btn_save'])) { $db->updatcallecterall($data); Application_Form_FrmMessage::message('ការបញ្ចូលជោគជ័យ'); } if (isset($data['btn_save_close'])) { $db->updatcallecterall($data); Application_Form_FrmMessage::message('ការបញ្ចូលជោគជ័យ'); Application_Form_FrmMessage::redirectUrl('/callecterall/Callecterall'); } } catch (Exception $e) { Application_Form_FrmMessage::message("INSERT_FAIL"); $err = $e->getMessage(); Application_Model_DbTable_DbUserLog::writeMessageError($err); } } $id = $this->getRequest()->getParam('id'); $db = new Callecterall_Model_DbTable_DbCallecterall(); $row = $db->getcallecterallbyid($id); $fm = new Callecterall_Form_Frmcallecterall(); $frm = $fm->Frmcallecterall($row); Application_Model_Decorator::removeAllDecorator($frm); $this->view->Form_Frmcallecterall = $frm; }
public function indexAction() { try { $db = new Tellerandexchange_Model_DbTable_DbSpread(); if ($this->getRequest()->isPost()) { $search = $this->getRequest()->getPost(); } else { $search = array('client_id' => -1, 'status' => -1, 'from_date' => date('Y-m-d'), 'to_date' => date('Y-m-d')); } $rs_rows = $db->getAllSpreadList($search); $glClass = new Application_Model_GlobalClass(); $rs_rows = $glClass->getImgActive($rs_rows, BASE_URL, true); $list = new Application_Form_Frmtable(); $collumns = array("ពីប្រាក់", "ទៅប្រាក់", "ទិញចូល", "លក់ចេញ", "អត្រាកណ្តាល", "កាលបរិច្ឆេទ", "STATUS"); $link = array('module' => 'tellerandexchange', 'controller' => 'Spread', 'action' => 'edit'); $this->view->list = $list->getCheckList(0, $collumns, $rs_rows, array('buy_type' => $link, 'sell_type' => $link, 'rate_in' => $link, 'rate_out' => $link)); } catch (Exception $e) { Application_Form_FrmMessage::message("Application Error"); echo $e->getMessage(); Application_Model_DbTable_DbUserLog::writeMessageError($e->getMessage()); } $frm = new Application_Form_FrmAdvanceSearch(); $frm = $frm->AdvanceSearch(); Application_Model_Decorator::removeAllDecorator($frm); $this->view->frm_search = $frm; }
function editAction() { $db = new Other_Model_DbTable_DbHoliday(); //$db->deleteHoliday(); $db = new Other_Model_DbTable_DbHoliday(); if ($this->getRequest()->isPost()) { $_data = $this->getRequest()->getPost(); try { $_major_id = $db->addHoliday($_data); Application_Form_FrmMessage::Sucessfull($this->tr->translate("EDIT_SUCCESS"), self::REDIRECT_URL . '/holiday/index'); } catch (Exception $e) { Application_Form_FrmMessage::message($this->tr->translate("EDIT_FAIL")); $err = $e->getMessage(); Application_Model_DbTable_DbUserLog::writeMessageError($err); } } $id = $this->getRequest()->getParam('id'); $row = $db->getHolidayById($id); if (empty($row)) { $this->_redirect('/other/holiday'); } $frm = new Other_Form_FrmHoliday(); $frm_holiday = $frm->FrmAddHoliday($row); Application_Model_Decorator::removeAllDecorator($frm_holiday); $this->view->frm_holiday = $frm_holiday; }
function addAction() { $_model = new Foundation_Model_DbTable_DbNewStudent(); if ($this->getRequest()->isPost()) { try { $_data = $this->getRequest()->getPost(); $_model->addNewStudent($_data); if (!empty($_data['save_close'])) { Application_Form_FrmMessage::Sucessfull("INSERT_SUCCESS", "/foundation/index"); } Application_Form_FrmMessage::message("INSERT_SUCCESS"); } catch (Exception $e) { Application_Form_FrmMessage::message("INSERT_FAIL"); $err = $e->getMessage(); Application_Model_DbTable_DbUserLog::writeMessageError($err); } } $_frm = new Foundation_Form_FrmStudent(); $_frmstudent = $_frm->FrmStudent(); Application_Model_Decorator::removeAllDecorator($_frmstudent); $this->view->frm_student = $_frmstudent; // $_db = new Application_Model_DbTable_DbGlobal(); // $comp = $_db->getallComposition(); // array_unshift($comp, array ( 'id' => -1, 'name' => 'បន្�ែម​អ្នក​ទទួល​�្មី') ); // $this->view->compo=$comp; // $situation = $_db->getallSituation(); // array_unshift($situation, array ( 'id' => -1, 'name' => 'បន្�ែម​អ្នក​ទទួល​�្មី') ); // $this->view->situation=$situation; // $school = $_db->getAllHighSchool(); // array_unshift($school, array ( 'id' => -1, 'name' => 'បន្�ែម​អ្នក​ទទួល​�្មី','province_id'=>-1) ); // $this->view->highschool=$school; // $scholarship = $_db->getallScholarship(); // array_unshift($scholarship, array ( 'id' => -1, 'name' => 'បន្�ែម​អ្នក​ទទួល​�្មី','province_id'=>-1) ); // $this->view->scholarship=$scholarship; }
public function addAction() { if ($this->getRequest()->isPost()) { $_data = $this->getRequest()->getPost(); $db = new Menu_Model_DbTable_DbItem(); try { if (isset($_data['btnsave'])) { $db->addItem($_data); Application_Form_FrmMessage::Sucessfull('ការបញ្ចូលជោគជ័យ', self::REDIRECT_URL . '/item/add'); } elseif (isset($_data['btnsaveclose'])) { $db->addItem($_data); Application_Form_FrmMessage::Sucessfull('ការបញ្ចូលជោគជ័យ', self::REDIRECT_URL . '/item/index'); } // $db->addItem($_data); // if(!empty($_data['btnsave'])){ // Application_Form_FrmMessage::message('ការបញ្ចូលជោគជ័យ'); // }else{ // Application_Form_FrmMessage::Sucessfull('ការបញ្ចូលជោគជ័យ', self::REDIRECT_URL . '/item/add'); // } } catch (Exception $e) { Application_Form_FrmMessage::message("ការបញ្ចូលមិនជោគជ័យ"); $err = $e->getMessage(); Application_Model_DbTable_DbUserLog::writeMessageError($err); } } $frm = new Menu_Form_FrmMenuItem(); $frm_menuitem = $frm->FrmMenu(); Application_Model_Decorator::removeAllDecorator($frm_menuitem); $this->view->form = $frm_menuitem; }
public function editAction() { $db = new Group_Model_DbTable_DbClient(); if ($this->getRequest()->isPost()) { try { $data = $this->getRequest()->getPost(); $db->addClient($data); Application_Form_FrmMessage::Sucessfull($this->tr->translate('EDIT_SUCCESS'), "/group/client"); } catch (Exception $e) { echo $e->getMessage(); exit; Application_Form_FrmMessage::message("Application Error"); echo $e->getMessage(); Application_Model_DbTable_DbUserLog::writeMessageError($e->getMessage()); } } $id = $this->getRequest()->getParam("id"); $row = $db->getClientById($id); if (empty($row)) { $this->_redirect("/group/client"); } $fm = new Group_Form_FrmClient(); $frm = $fm->FrmAddClient($row); Application_Model_Decorator::removeAllDecorator($frm); $this->view->frm_client = $frm; }
public function indexAction() { try { $db_dept = new Global_Model_DbTable_DbScholarship(); if ($this->getRequest()->isPost()) { $_data = $this->getRequest()->getPost(); $search = array('title' => $_data['title'], 'note' => $_data['note'], 'type' => $_data['type'], 'status' => $_data['status_search']); } else { $search = array('title' => '', 'note' => '', 'type' => '', 'status' => -1); } $db = new Global_Model_DbTable_DbScholarship(); $rs_rows = $db->getAllScholarship(); $glClass = new Application_Model_GlobalClass(); $rs_rows = $glClass->getImgActive($rs_rows, BASE_URL, true); $list = new Application_Form_Frmtable(); $collumns = array("TITLE", "NOTE", "TYPE", "CREATE_DATE", "STATUS", "BY_USER"); $link = array('module' => 'global', 'controller' => 'scholarship', 'action' => 'edit'); $this->view->list = $list->getCheckList(0, $collumns, $rs_rows, array('title' => $link)); } catch (Exception $e) { Application_Form_FrmMessage::message("Application Error"); Application_Model_DbTable_DbUserLog::writeMessageError($e->getMessage()); } $frm = new Global_Form_FrmSearchMajor(); $frms = $frm->FrmsearchScholarship(); Application_Model_Decorator::removeAllDecorator($frms); $this->view->frm_search = $frms; }
public function basicAction() { $pructis = new Salary_Form_FrmSalary(); $frm = $pructis->addSalary(); Application_Model_Decorator::removeAllDecorator($frm); $this->view->frm = $frm; }
function addProgramTypeAction() { $item = new Accounting_Form_Frmitem(); $frm_item = $item->FrmProgramType(); Application_Model_Decorator::removeAllDecorator($frm_item); $this->view->frm_item = $frm_item; }
public function putAction() { $pructis = new Keeping_Form_FrmMoney(); $frm = $pructis->addMoney(); Application_Model_Decorator::removeAllDecorator($frm); $this->view->frm = $frm; }
public function editAction() { $id = $this->getRequest()->getParam('id'); $db = new Other_Model_DbTable_DbCommune(); if ($this->getRequest()->isPost()) { $_data = $this->getRequest()->getPost(); //print_r($_data);exit(); try { $db->addCommune($_data, $id); Application_Form_FrmMessage::Sucessfull($this->tr->translate("EDIT_SUCCESS"), self::REDIRECT_URL . '/commune/'); } catch (Exception $e) { Application_Form_FrmMessage::message($this->tr->translate("EDIT_FAIL")); $err = $e->getMessage(); Application_Model_DbTable_DbUserLog::writeMessageError($err); } } $row = $db->getCommuneById($id); $this->view->row = $row; $fm = new Other_Form_FrmCommune(); $frm = $fm->FrmAddCommune($row); Application_Model_Decorator::removeAllDecorator($frm); $this->view->frm_commune = $frm; $db = new Application_Model_DbTable_DbGlobal(); $this->view->district = $db->getAllDistricts(); }
public function editAction() { $id = $this->getRequest()->getParam("id"); if ($this->getRequest()->isPost()) { try { $data = $this->getRequest()->getPost(); $data["id"] = $id; $db = new Global_Model_DbTable_DbTeacher(); $db->updateTeacher($data); Application_Form_FrmMessage::Sucessfull("EDIT_SUCCESS", "/global/lecturer"); } catch (Exception $e) { Application_Form_FrmMessage::message("EDIT_FAIL"); $err = $e->getMessage(); Application_Model_DbTable_DbUserLog::writeMessageError($err); } } $db = new Global_Model_DbTable_DbTeacher(); $row = $db->getTeacherById($id); $tsub = new Global_Form_FrmTeacher(); $frm_techer = $tsub->FrmTecher($row); Application_Model_Decorator::removeAllDecorator($frm_techer); $this->view->frm_techer = $frm_techer; $dbs = new Application_Model_GlobalClass(); $this->view->subject_opt = $dbs->getsunjectOption(); $this->view->teacher_subject = $db->getallSubjectTeacherById($id); }
public function put1Action() { $pructis = new Money_Form_NewPut(); $frm = $pructis->dakMoney(); Application_Model_Decorator::removeAllDecorator($frm); $this->view->frm = $frm; }
public function addAction() { $fm = new Accounting_Form_FrmGeneraljurnal(); $frm = $fm->FrmGeneraljurnal(); Application_Model_Decorator::removeAllDecorator($frm); $this->view->frm_fixedasset = $frm; }
public function addAction() { if ($this->getRequest()->isPost()) { $data = $this->getRequest()->getPost(); $db = new Menu_Model_DbTable_DbMenuGroup(); try { if (isset($data['btnsave'])) { $db->addMuneGroup($data); Application_Form_FrmMessage::Sucessfull('ការបញ្ចូលជោគជ័យ', self::REDIRECT_URL . '/add'); } else { if (isset($data['btnsaveclose'])) { $db->addMuneGroup($data); Application_Form_FrmMessage::Sucessfull('ការបញ្ចូលជោគជ័យ', self::REDIRECT_URL . '/index'); } } } catch (Exception $e) { Application_Form_FrmMessage::message("ការបញ្ចូលមិនជោគជ័យ"); $err = $e->getMessage(); Application_Model_DbTable_DbUserLog::writeMessageError($err); } } $frm = new Menu_Form_FrmMenuGroup(); $FrmMenu = $frm->FrmMenu(); Application_Model_Decorator::removeAllDecorator($FrmMenu); $this->view->form = $FrmMenu; }
public function addAction() { $fm = new Callecterall_Form_Frmrefundcallecterall(); $frm = $fm->Frmrefundcallecterall(); Application_Model_Decorator::removeAllDecorator($frm); $this->view->Form_Frmcallecterall = $frm; }
function indexAction() { $dbbooking = new Application_Model_DbTable_Dbstuffrental(); $db_globle = new Application_Model_DbTable_DbGlobal(); if ($this->getRequest()->isPost()) { $post = $this->getRequest()->getPost(); if (isset($post["term_condiction"])) { $dbbooking->createSessionStuffBooking($post, 3); //print_r("test");exit(); $this->_redirect("stuffbooking/index"); } elseif (isset($post["confirm_book"])) { $dbbooking->createSessionStuffBooking($post, 4); $this->_redirect("stuffbooking/index"); } } $customer_session = new Zend_Session_Namespace('customer'); $user_session = $customer_session->customer_session; if (!empty($user_session)) { $customer_user_session = $user_session; $customer_user = $customer_session->customer_id; $this->view->user_name = $customer_session->customer_name; $this->view->user_info = $customer_session->user_info; } else { $customer_user_session = 0; } $db = new Application_Model_DbTable_Dbbookingtaxi(); $session = new Zend_Session_Namespace('stuffbooking'); $this->view->bookinginfo = $session; $this->view->producttermcomdiction = $db_globle->getAllParameter('producttermcomdiction'); $frmbooks = new Application_Form_FrmBooking(); $frmbooking = $frmbooks->FromBooking(); Application_Model_Decorator::removeAllDecorator($frmbooking); $this->view->frmbooking = $frmbooking; $this->view->user_session = $customer_user_session; }
function addAction() { if ($this->getRequest()->isPost()) { $_data = $this->getRequest()->getPost(); try { print_r($_data); exit; // $_dbmodel = new Global_Model_DbTable_DbProvince(); // $_dbmodel->addNewProvince($_data); // Application_Form_FrmMessage::Sucessfull("EDIT_SUCCESS","/global/index/subject-list"); } catch (Exception $e) { // Application_Form_FrmMessage::message("INSERT_FAIL"); // $err =$e->getMessage(); // Application_Model_DbTable_DbUserLog::writeMessageError($err); } } // $frm = new Loan_Form_FrmLoan(); // $frm_loan=$frm->FrmAddLoan(); // Application_Model_Decorator::removeAllDecorator($frm_loan); // $this->view->frm_loan = $frm_loan; $frm = new Tellerandexchange_Form_Frmteller(); $frm_teller = $frm->FrmTeller(); Application_Model_Decorator::removeAllDecorator($frm_teller); $this->view->frmteller = $frm_teller; $list = new Application_Form_Frmtable(); $collumns = array("ឈ្មោះមន្ត្រីឥណទាន", "ថ្ងៃបង់ប្រាក់", "ប្រាក់ត្រូវបង់", "ប្រាក់ដើមត្រូវបង់", "អាត្រាការប្រាក់", "ប្រាក់ផាកពិន័យ", "ប្រាក់បានបង់សរុប", "សមតុល្យ", "កំណត់សម្គាល់"); $link = array('module' => 'group', 'controller' => 'Client', 'action' => 'edit'); $this->view->list = $list->getCheckList(0, $collumns, array(), array('client_number' => $link, 'name_kh' => $link, 'name_en' => $link)); }
public function addAction() { //$this->_helper->layout()->disableLayout(); $frm = new inventory_Form_FrmWhereHouse(); $frm = $frm->FrmWhereHouse(); Application_Model_Decorator::removeAllDecorator($frm); $this->view->form = $frm; }
public function addAction() { $frm = new Registrar_Form_FrmRegister(); $frm_request = $frm->FrmStudentRequest(); Application_Model_Decorator::removeAllDecorator($frm_request); $this->view->frm_request = $frm_request; $key = new Application_Model_DbTable_DbKeycode(); $this->view->keycode = $key->getKeyCodeMiniInv(TRUE); }
public function wuReceiptAction() { $frm = new Registrar_Form_FrmRecept(); $frm_recept = $frm->FrmRecept(); Application_Model_Decorator::removeAllDecorator($frm_recept); $this->view->frm_recept = $frm_recept; //$key = new Application_Model_DbTable_DbKeycode(); //$this->view->keycode=$key->getKeyCodeMiniInv(TRUE); }
function addAddAction() { if ($this->getRequest()->isPost()) { } $frm = new Loan_Form_FrmLoan(); $frm_loan = $frm->FrmAddLoan(); Application_Model_Decorator::removeAllDecorator($frm_loan); $this->view->frm_loan = $frm_loan; }
public function init() { //user name $user_type = new Zend_Form_Element_Text('user_type'); $user_type->setAttribs(array('id' => 'user_type')); $this->addElement($user_type); //Main parent of user type $db = new Application_Model_DbTable_DbGlobal(); $rs = $db->getGlobalDb("SELECT ut.user_type_id,ut.user_type FROM rsv_acl_user_type AS ut"); $options = array(); foreach ($rs as $read) { $options[$read['user_type_id']] = $read['user_type']; } $user_type_id = new Zend_Form_Element_Select('user_type_id'); $user_type_id->setMultiOptions($options); $this->addElement($user_type_id); $rs = $db->getGlobalDb("SELECT acl.acl_id, CONCAT(acl.module,'/', acl.controller,'/', acl.action) AS user_access FROM rsv_acl_acl AS acl"); $options = array(); foreach ($rs as $read) { $options[$read['acl_id']] = $read['user_access']; } $user_access_id = new Zend_Form_Element_Select('acl_id'); $user_access_id->setMultiOptions($options); $this->addElement($user_access_id); //Project assignment //Sophen add here to assign project $user_session_id = new Zend_Session_Namespace('auth'); $id = $user_session_id->user_type_id; //echo $user_id;exit; $db_user = new Application_Model_DbTable_DbGlobal(); if ($id == 1) { $sql = "select acl.acl_id,CONCAT(acl.module,'/', acl.controller,'/', acl.action) AS user_access from rsv_acl_acl as acl"; } else { $sql = "SELECT acl.acl_id, CONCAT(acl.module,'/', acl.controller,'/', acl.action) AS user_access, acl.status FROM rsv_acl_user_access AS ua \r\n\t\t INNER JOIN rsv_acl_user_type AS ut ON (ua.user_type_id = ut.parent_id)\r\n\t\t\t INNER JOIN rsv_acl_acl AS acl ON (acl.acl_id = ua.acl_id) WHERE ut.user_type_id =" . $id; } //print_r($sql); exit; $project = $db_user->getGlobalDb($sql); if ($project) { $i = 0; foreach ($project as $read) { //print_r($read);exit; $i++; $check_fund = new Zend_Form_Element_Checkbox('acl_id_' . $i, array('label' => $read['user_access'])); $check_fund->setUncheckedValue('')->setCheckedValue($read['acl_id']); $this->addElement($check_fund); } $this->plus = $i; } //remove decorator Application_Model_Decorator::removeAllDecorator($this); }
public function indexAction() { $formFilter = new Application_Form_Frmsearch(); $this->view->formFilter = $formFilter; Application_Model_Decorator::removeAllDecorator($formFilter); $list = new Application_Form_Frmlist(); $db = new Application_Model_DbTable_DbGlobal(); // $vendor_sql = "SELECT p.order_id, p.order, p.date_order, p.status, v.v_name, p.all_total,u.username // FROM tb_purchase_order AS p , // tb_vendor AS v,rsv_acl_user u // WHERE v.vendor_id=p.vendor_id AND u.user_id = p.user_mod "; $vendor_sql = "SELECT \n\t\t\t\t\t\t\trecieve_id\n\t\t\t\t\t\t\t,ro.recieve_no\n\t\t\t\t\t\t\t,ro.date_recieve\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t,(SELECT v.v_name FROM tb_vendor AS v WHERE v.vendor_id = ro.vendor_id) AS VendorName\n\t\t\t\t\t\t\t,ro.all_total\n\t\t\t\t\t\t\t,(SELECT u.username FROM rsv_acl_user AS u WHERE u.user_id = ro.user_recieve) AS userName\n\t\t\t\t\t\t\n\t\t\t\t\t\tFROM tb_recieve_order AS ro WHERE is_active=1"; $user = $this->GetuserInfoAction(); $str_condition = " AND p.LocationId"; $vendor_sql .= $db->getAccessPermission($user["level"], $str_condition, $user["location_id"]); $this->view->level = $user["level"]; if ($this->getRequest()->isPost()) { $post = $this->getRequest()->getPost(); //echo $post["order"]; if ($post['order'] != '') { $vendor_sql .= " AND ro.recieve_no LIKE '%" . $post['order'] . "%'"; } if ($post['vendor_name'] != '' and $post['vendor_name'] != 0) { $vendor_sql .= " AND ro.user_recieve =" . $post['vendor_name']; } // if($post['phone'] !=''){ // $vendor_sql .= " AND v.phone LIKE '%".$post['phone']."%'"; // } // if($post['status'] !=''){ // $vendor_sql .= " AND ro.status =".$post['status']; // } $start_date = $post['search_start_date']; $end_date = $post['search_end_date']; if ($start_date != "" && $end_date != "" && strtotime($end_date) >= strtotime($start_date)) { $vendor_sql .= " AND ro.date_recieve BETWEEN '{$start_date}' AND '{$end_date}'"; } } //echo $vendor_sql;exit(); $vendor_sql .= " ORDER BY ro.recieve_no DESC"; //************************************** $rows = $db->getGlobalDb($vendor_sql); //print_r($rows);exit(); $glClass = new Application_Model_GlobalClass(); //$rows = $glClass->getStatusType($rows, BASE_URL, true); $columns = array("PURCHASE_ORDER_CAP", "ORDER_DATE_CAP", "VENDOR_NAME_CAP", "TOTAL_CAP_DOLLAR", strtoupper("BY_USER_CAP")); $link = array('module' => 'purchase', 'controller' => 'receive', 'action' => 'detail-purchase-order'); // url link to update purchase order $urlEdit = BASE_URL . "/purchase/index/update-purchase-order-test"; $this->view->list = $list->getCheckList(1, $columns, $rows, array('order' => $link), $urlEdit); }