public function indexAction() { try { $db = new Group_Model_DbTable_DbClient(); if ($this->getRequest()->isPost()) { $search = $this->getRequest()->getPost(); } else { $search = array('adv_search' => '', 'status' => -1); } $rs_rows = $db->getAllClients($search); $glClass = new Application_Model_GlobalClass(); $rs_rows = $glClass->getImgActive($rs_rows, BASE_URL, true); $list = new Application_Form_Frmtable(); $collumns = array("Client N.", "NAME_EN", "Name Eng", "Sex", "Phone", "House", "Street", "Village", "Spouse Name", "By", "status"); $link = array('module' => 'group', 'controller' => 'client', 'action' => 'edit'); $this->view->list = $list->getCheckList(0, $collumns, $rs_rows, array('client_number' => $link, 'name_kh' => $link, 'name_en' => $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; }
public function indexAction(){ try{ $db = new Group_Model_DbTable_DbClient(); if($this->getRequest()->isPost()){ $search=$this->getRequest()->getPost(); } else{ $search = array( 'adv_search' => '', 'status' => -1); } $rs_rows= $db->getAllClients($search); $result = array(); foreach ($rs_rows as $key =>$rs){ $result[$key]=array( 'client_id'=>$rs['client_id'], 'client_number'=>$rs['client_number'], 'name_kh'=>$rs['name_kh'], 'name_en'=>$rs['name_en'], 'sex'=>$this->sex[$rs['sex']], 'phone'=>$rs['phone'], 'house'=>$rs['house'], 'street'=>$rs['street'], 'village_name'=>$rs['village_name'], 'spouse_name'=>$rs['spouse_name'], 'user_name'=>$rs['user_name'], 'status'=>$rs['status'], ); } $glClass = new Application_Model_GlobalClass(); $rs_rows = $glClass->getImgActive($result, BASE_URL, true); $list = new Application_Form_Frmtable(); $collumns = array("Client No","Client ID","Client Name(Kh)","Release Amount","Method","Time Collection","Zone","CO Name", "By","status"); $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)); }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; }
public function indexAction() { try { $db = new Group_Model_DbTable_DbClient(); if ($this->getRequest()->isPost()) { $formdata = $this->getRequest()->getPost(); $search = array('title' => $formdata['title'], 'status_search' => $formdata['status_search']); } else { $search = array('title' => '', 'status_search' => -1); } $rs_rows = $db->getAllClients($search); $list = new Application_Form_Frmtable(); $collumns = array("Agent'st ID", "First Name", "Last Name", "Sex", "DOB", "Tel", "POB", "Nationality", "Company Name", "Group No", "Home No", "commune", "District", "Province"); $link = array('module' => 'group', 'controller' => 'index', 'action' => 'edit'); $this->view->list = $list->getCheckList(0, $collumns, $rs_rows, array('customer_code' => $link, 'first_name' => $link, 'last_name' => $link, 'sex' => $link, 'dob' => $link)); } catch (Exception $e) { Application_Form_FrmMessage::message("Application Error"); Application_Model_DbTable_DbUserLog::writeMessageError($e->getMessage()); } $frm = new Location_Form_FrmSearch(); $frm = $frm->search(); Application_Model_Decorator::removeAllDecorator($frm); $this->view->frm_search = $frm; }
public function indexAction(){ try{ $db = new Group_Model_DbTable_DbClient(); if($this->getRequest()->isPost()){ $formdata=$this->getRequest()->getPost(); $search = array( 'adv_search' => $formdata['adv_search'], 'province_id'=>$formdata['province'], 'comm_id'=>$formdata['commune'], 'district_id'=>$formdata['district'], 'village'=>$formdata['village'], 'status'=>$formdata['status'], 'start_date'=> $formdata['start_date'], 'end_date'=>$formdata['end_date'] ); } else{ $search = array( 'adv_search' => '', 'status' => -1, 'province_id'=>0, 'district_id'=>'', 'comm_id'=>'', 'village'=>'', 'start_date'=> date('Y-m-d'), 'end_date'=>date('Y-m-d')); } $rs_rows= $db->getAllClients($search); $glClass = new Application_Model_GlobalClass(); $rs_rows = $glClass->getImgActive($rs_rows, BASE_URL, true); $list = new Application_Form_Frmtable(); $collumns = array("BRANCH_NAME","CUSTOMER_CODE","CLIENTNAME_KH","CLIENTNAME_EN","SEX","PHONE","HOUSE","STREET","VILLAGE","SPOUSE_NAME", "DATE","BY_USER","STATUS"); $link=array( 'module'=>'group','controller'=>'index','action'=>'edit', ); $link1=array( 'module'=>'group','controller'=>'index','action'=>'view', ); $this->view->list=$list->getCheckList(0, $collumns, $rs_rows,array('branch_name'=>$link1,'client_number'=>$link,'name_kh'=>$link,'name_en'=>$link)); }catch (Exception $e){ Application_Form_FrmMessage::message("Application Error"); 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; $fm = new Group_Form_FrmClient(); $frm = $fm->FrmAddClient(); Application_Model_Decorator::removeAllDecorator($frm); $this->view->frm_client = $frm; $db= new Application_Model_DbTable_DbGlobal(); $this->view->district = $db->getAllDistricts(); $this->view->commune_name = $db->getCommune(); $this->view->village_name = $db->getVillage(); $this->view->result=$search; }