public function indexAction()
{
try {
$db = new Other_Model_DbTable_DbZone();
if ($this->getRequest()->isPost()) {
$search = $this->getRequest()->getPost();
} else {
$search = array('adv_search' => '', 'search_status' => -1);
}
$rs_rows = $db->getAllZoneArea($search);
$glClass = new Application_Model_GlobalClass();
$rs_rows = $glClass->getImgActive($rs_rows, BASE_URL, true);
$list = new Application_Form_Frmtable();
$collumns = array("ZONE_NAME", "ZONE_NUMBER", "DATE", "STATUS", "BY");
$link = array('module' => 'other', 'controller' => 'zone', 'action' => 'edit');
$this->view->list = $list->getCheckList(0, $collumns, $rs_rows, array('zone_name' => $link, 'zone_num' => $link));
} catch (Exception $e) {
Application_Form_FrmMessage::message("Application Error");
echo $e->getMessage();
Application_Model_DbTable_DbUserLog::writeMessageError($e->getMessage());
}
$frm = new Other_Form_FrmZone();
$frm_co = $frm->FrmAddZone();
Application_Model_Decorator::removeAllDecorator($frm_co);
$this->view->frm_zone = $frm_co;
$db = new Application_Model_DbTable_DbGlobal();
$this->view->district = $db->getAllDistricts();
$this->view->commune_name = $db->getCommune();
$this->view->result = $search;
}
function rptVillageAction(){
$db = new Report_Model_DbTable_DbParamater();
$this->view->village_list = $db->getAllVillage();
//print_r($db->getAllstaff());
$key = new Application_Model_DbTable_DbKeycode();
$this->view->data=$key->getKeyCodeMiniInv(TRUE);
if($this->getRequest()->isPost()){
$search = $this->getRequest()->getPost();
//
if(isset($search['btn_search'])){
//print_r($search);exit();
$this->view->village_list = $db->getAllVillage($search);
}else{
$collumn = array("vill_id","village_namekh","village_name","displayby","commune_name","district_name","province_en_name","modify_date","status","user_name");
$this->exportFileToExcel('ln_village',$db->getAllVillage(),$collumn);
}
}else {
$search = array('adv_search' => '',
'search_status' => -1,
'province_name'=>0,
'district_name'=>'',
'commune_name'=>'');
}
$frm = new Other_Form_FrmVillage();
$frms = $frm->FrmAddVillage();
Application_Model_Decorator::removeAllDecorator($frms);
$this->view->frm_village= $frms;
$db= new Application_Model_DbTable_DbGlobal();
$this->view->district = $db->getAllDistricts();
$this->view->commune_name = $db->getCommune();
$this->view->result = $search;
}
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()
{
if ($this->getRequest()->isPost()) {
$data = $this->getRequest()->getPost();
$db_partner = new Partner_Model_DbTable_DbPartner();
try {
if ($this->getRequest()->getParam("btn_save_close")) {
//print_r($data);exit();
$db = $db_partner->getupdatePartner($data);
Application_Form_FrmMessage::Sucessfull('ការបញ្ចូលជោគជ័យ', '/partner/');
}
} catch (Exception $e) {
echo $e->getMessage();
$this->view->msg = 'ការបញ្ចូលមិនជោគជ័យ';
}
}
$db_partner = new Partner_Model_DbTable_DbPartner();
$id = $this->getRequest()->getParam('id');
$row = $db_partner->getPartnerById($id);
$this->view->row = $row;
$this->view->photo = $row['photo'];
$pructis = new Partner_Form_FrmPartner();
$frm = $pructis->addPartner($row);
Application_Model_Decorator::removeAllDecorator($frm);
$form = $this->view->frm = $frm;
$db = new Application_Model_DbTable_DbGlobal();
$this->view->district = $db->getAllDistricts();
$this->view->commune_name = $db->getCommune();
$this->view->village_name = $db->getVillage();
}
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();
}
function rptClientAction($table='ln_account_name'){
$key = new Application_Model_DbTable_DbKeycode();
$this->view->data=$key->getKeyCodeMiniInv(TRUE);
if($this->getRequest()->isPost()){
$search = $this->getRequest()->getPost();
}else{
$search = array('adv_search' => '',
'status' => -1,
'branch_id' => 0,
'province'=>0,
'district'=>'',
'commune'=>'',
'village'=>'',
'start_date'=> date('Y-m-d'),
'end_date'=>date('Y-m-d'));
}
$this->view->result=$search;
$db = new Report_Model_DbTable_DbLnClient();
$this->view->client_list =$db->getAllLnClient($search);
$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 = $db->getCommune();
$this->view->village = $db->getVillage();
}
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($this->tr->translate('EDIT_SUCCESS'),self::REDIRECT_URL . '/Village/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->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 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;
}
public function editAction(){
$db = new Group_Model_DbTable_DbClient();
if($this->getRequest()->isPost()){
try{
$data = $this->getRequest()->getPost();
//print_r($data);exit();
$id= $db->addClient($data);
if($data['chackcall']==1){
Application_Form_FrmMessage::message("វានឹងបន្ថែមទ្រព្យបញ្ចាំរបស់អតិថិជនដោយស្វ័យប្រវត្តិ!");
// Application_Form_FrmMessage::redirectUrl("/group/Callteral/add/id/".$id);
}
//Application_Form_FrmMessage::redirectUrl("/group/index");
//$db->addClient($data);
//Application_Form_FrmMessage::Sucessfull('EDIT_SUCCESS',"/group/index");
}catch (Exception $e){
Application_Form_FrmMessage::message("EDIT_FAILE");
echo $e->getMessage();
Application_Model_DbTable_DbUserLog::writeMessageError($e->getMessage());
}
}
$id = $this->getRequest()->getParam("id");
$row = $db->getClientById($id);
$this->view->row=$row;
$this->view->photo = $row['photo_name'];
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;
$db= new Application_Model_DbTable_DbGlobal();
$this->view->district = $db->getAllDistricts();
$this->view->commune_name = $db->getCommune();
$this->view->village_name = $db->getVillage();
}
