예제 #1
0
 function indexAction()
 {
     try {
         $db = new Keeping_Model_DbTable_DbOutmoney();
         if ($this->getRequest()->isPost()) {
             $search = $this->getRequest()->getPost();
             //print_r($search);exit();
         } else {
             $search = array('adv_search' => '', 'status_search' => -1);
         }
         $rows = $db->getAllwithdrawKeeping($search);
         $list = new Application_Form_Frmtable();
         $collumns = array("លេខដៃគូ", "ថ្ងៃ", "សម្គាល់", "ទូរស័ព្ទអតិថិជន", "ប្រាក់ជាដុល្លា", "ប្រាក់ជាបាត", "ប្រាក់ជារៀល", "ប្រាក់ជាដុល្លា(-)", "ប្រាក់ជាបាត(-)", "ប្រាក់ជារៀល(-)");
         $link = array('module' => 'Keeping', 'controller' => 'outmoney', 'action' => 'edit');
         $this->view->list = $list->getCheckList(0, $collumns, $rows, array('phone' => $link, 'create_date' => $link, 'note' => $link));
     } catch (Exception $e) {
         Application_Form_FrmMessage::message("Application Error");
         echo $e->getMessage();
         Application_Model_DbTable_DbUserLog::writeMessageError($e->getMessage());
     }
     $pructis = new Keeping_Form_FrmOutMoney();
     $frm = $pructis->dokMoney();
     Application_Model_Decorator::removeAllDecorator($frm);
     $form = $this->view->frm_partner = $frm;
 }
예제 #2
0
 public function indexAction()
 {
     try {
         $db = new Accounting_Model_DbTable_DbChartaccount();
         if ($this->getRequest()->isPost()) {
             $search = $this->getRequest()->getPost();
         } else {
             $search = array('adv_search' => '', 'status' => -1);
         }
         $rs_rows = $db->getAllchartaccounts($search);
         $glClass = new Application_Model_GlobalClass();
         $rs_rows = $glClass->getImgActive($rs_rows, BASE_URL, true);
         $list = new Application_Form_Frmtable();
         $collumns = array("ACCOUNT_TYPE", "PARENT", "CATEGORY", "ACCOUNT_CODE", "ACCOUNT_NAME_EN", "ACCOUNT_NAME_KH", "STATUS");
         $link = array('module' => 'accounting', 'controller' => 'chartaccount', 'action' => 'edit');
         $this->view->list = $list->getCheckList(0, $collumns, $rs_rows, array('account_name_en' => $link));
     } catch (Exception $e) {
         Application_Form_FrmMessage::message("Application Error");
         Application_Model_DbTable_DbUserLog::writeMessageError($e->getMessage());
     }
     $fm = new Application_Form_FrmAdvanceSearch();
     $frm = $fm->AdvanceSearch();
     Application_Model_Decorator::removeAllDecorator($frm);
     $this->view->frm_search = $frm;
     $fms = new Accounting_Form_FrmChartaccount();
     $frms = $fms->FrmChartaccount();
     Application_Model_Decorator::removeAllDecorator($frms);
     $this->view->frm_chartaccount = $frms;
 }
예제 #3
0
    function indexAction()
    {
    	try{
    		$db = new Group_Model_DbTable_DbClientBlackList();
    		if($this->getRequest()->isPost()){
    			$search=$this->getRequest()->getPost();
    		}
    		else{
    			$search = array(
    					'adv_search' => '',
    					'status_search' => -1,
    					'start_date'=> date('Y-m-d'),
						'end_date'=>date('Y-m-d'));
    		}
    		$rs_row= $db->getAllBlackListInList($search);//call frome model
    					$glClass = new Application_Model_GlobalClass();
    					$rs_rows = $glClass->getImgActive($rs_row, BASE_URL, true);
    		$list = new Application_Form_Frmtable();
    		$collumns = array("BRANCH_NAME","CUSTOMER_CODE","CUSTOMER_NAME","SEX","SITU_STATUS","NATIONAL_ID","NUMBER","REASON","DATE","STATUS");
    		$link=array(
    				'module'=>'group','controller'=>'Clientblacklist','action'=>'edit',
    		);
    		$this->view->list=$list->getCheckList(0, $collumns,$rs_rows,array('name_kh'=>$link,'name_en'=>$link,'client_number'=>$link));
    	}catch (Exception $e){
    		Application_Form_FrmMessage::message("Application Error");
    		Application_Model_DbTable_DbUserLog::writeMessageError($e->getMessage());
    	}
    	$frm = new Group_Form_FrmClientBlackList();
    	$frm = $frm->FrmClientBlackList();
    	Application_Model_Decorator::removeAllDecorator($frm);
    	$this->view->frm_search = $frm;
    }
예제 #4
0
 public function indexAction()
 {
     try {
         $db = new Other_Model_DbTable_DbCommune();
         if ($this->getRequest()->isPost()) {
             $search = $this->getRequest()->getPost();
         } else {
             $search = array('adv_search' => '', 'status' => -1);
         }
         $rs_rows = $db->getAllCommune($search);
         $glClass = new Application_Model_GlobalClass();
         $rs_rows = $glClass->getImgActive($rs_rows, BASE_URL, true);
         $list = new Application_Form_Frmtable();
         $collumns = array("CommuneName Kh", "CommuneName En", "District Name", "Date", "Status", "By");
         $link = array('module' => 'other', 'controller' => 'Commune', 'action' => 'edit');
         $this->view->list = $list->getCheckList(0, $collumns, $rs_rows, array('commune_namekh' => $link, 'district_name' => $link, 'commune_name' => $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;
 }
예제 #5
0
 public function indexAction()
 {
     try {
         $db = new Accounting_Model_DbTable_DbAsset();
         //     		if($this->getRequest()->isPost()){
         //     			$search=$this->getRequest()->getPost();
         //     		}
         //     		else{
         //     			$search = array(
         //     					'adv_search' => '',
         //     					'status' => -1);
         //     		}
         $rs_rows = $db->getAllAsset($search = null);
         //call frome model
         $glClass = new Application_Model_GlobalClass();
         $rs_rows = $glClass->getImgActive($rs_rows, BASE_URL, true);
         $list = new Application_Form_Frmtable();
         $collumns = array("Branch_id ", "Fixed_Assetname ", "Fixed_Asset_Type", "Asset_Cost", "Usefull_Life", "Salvagevalue", "Payment_method", "Status", "Note");
         $link = array('module' => 'accounting', 'controller' => 'FixedAsset', 'action' => 'edit');
         $this->view->list = $list->getCheckList(0, $collumns, $rs_rows, array('fixed_assetname' => $link, 'fixed_asset_type' => $link, 'asset_cost' => $link));
     } catch (Exception $e) {
         Application_Form_FrmMessage::message("Application Error");
         echo $e->getMessage();
         Application_Model_DbTable_DbUserLog::writeMessageError($e->getMessage());
     }
 }
예제 #6
0
 public function settingAction()
 {
     try {
         $db_dept = new Global_Model_DbTable_DbDept();
         if ($this->getRequest()->isPost()) {
             $_data = $this->getRequest()->getPost();
             $search = array('title' => $_data['title'], 'status' => $_data['status_search']);
             $limit = $dept_session->limit;
         } else {
             $search = '';
         }
         $_db = new Global_Model_DbTable_DbSetting();
         $rs_rows = $_db->getAllSetting($search);
         $list = new Application_Form_Frmtable();
         $collumns = array("KEY_VALUE", "KEY_VALUE", "BY_USER");
         $link = array('module' => 'global', 'controller' => 'index', 'action' => 'setting-edit');
         $this->view->list = $list->getCheckList(0, $collumns, $rs_rows, array('keyvalue' => $link));
     } catch (Exception $e) {
         Application_Form_FrmMessage::message("Application Error");
         Application_Model_DbTable_DbUserLog::writeMessageError($e->getMessage());
     }
     $frm = new Global_Form_FrmSearchMajor();
     $frm = $frm->FrmSetting();
     Application_Model_Decorator::removeAllDecorator($frm);
     $this->view->frm_search = $frm;
 }
예제 #7
0
 public function indexAction()
 {
     try {
         $db = new Other_Model_DbTable_DbDistrict();
         if ($this->getRequest()->isPost()) {
             $search = $this->getRequest()->getPost();
         } else {
             $search = array('adv_search' => '', 'search_status' => -1);
         }
         $rs_rows = $db->getAllDistrict($search);
         $glClass = new Application_Model_GlobalClass();
         $rs_rows = $glClass->getImgActive($rs_rows, BASE_URL, true, null, 1);
         $list = new Application_Form_Frmtable();
         $collumns = array("DISTRICT_KH", "DISTRICT_ENG", "DISPLAY_BY", "PROVINCE", "DATE", "STATUS", "BY");
         $link = array('module' => 'other', 'controller' => 'district', 'action' => 'edit');
         $this->view->list = $list->getCheckList(0, $collumns, $rs_rows, array('district_name' => $link, 'district_namekh' => $link));
     } catch (Exception $e) {
         Application_Form_FrmMessage::message("Application Error");
         echo $e->getMessage();
         Application_Model_DbTable_DbUserLog::writeMessageError($e->getMessage());
     }
     $fm = new Other_Form_FrmDistrict();
     $frm = $fm->FrmAddDistrict();
     Application_Model_Decorator::removeAllDecorator($frm);
     $this->view->frm_district = $frm;
 }
예제 #8
0
 public function indexAction()
 {
     try {
         $db = new Room_Model_DbTable_DbRoom();
         //     		if($this->getRequest()->isPost()){
         //     			$search=$this->getRequest()->getPost();
         //     		}
         //     		else{
         //     			$search = array(
         //     					'adv_search' => '',
         //     					'search_status' => -1,
         //     					'start_date'=> date('Y-m-01'),
         //     					'end_date'=>date('Y-m-d'));
         //     		}
         $rs_rows = $db->getAllRoom();
         $glClass = new Application_Model_GlobalClass();
         $rs_rows = $glClass->getImgActive($rs_rows, BASE_URL, true);
         $list = new Application_Form_Frmtable();
         $collumns = array("ROOM_NO", "ROOM_NUMBER", "ROOM_TYPE", "FLOOR_NAME", "DATE", "BED_NUMBER", "DESCRIPTION", "STATUS");
         $link = array('module' => 'room', 'controller' => 'room', 'action' => 'edit');
         $this->view->list = $list->getCheckList(0, $collumns, $rs_rows, array('room_no' => $link, 'room_number' => $link, 'type_id' => $link, 'floor_id' => $link, 'date' => $link));
     } catch (Exception $e) {
         Application_Form_FrmMessage::message("Application Error");
         Application_Model_DbTable_DbUserLog::writeMessageError($e->getMessage());
     }
 }
예제 #9
0
 public function indexAction()
 {
     try {
         $db = new Other_Model_DbTable_DbBranch();
         if ($this->getRequest()->isPost()) {
             $search = $this->getRequest()->getPost();
         } else {
             $search = array('adv_search' => '', 'status_search' => -1);
         }
         $rs_rows = $db->getAllBranch($search);
         $glClass = new Application_Model_GlobalClass();
         $rs_rowshow = $glClass->getImgActive($rs_rows, BASE_URL, true);
         $list = new Application_Form_Frmtable();
         $collumns = array("BRANCH_KH", "BRANCH_EN", "PREFIX_CODE", "CODE", "ADDRESS", "TEL", "FAX", "DISPLAY", "OTHER", "STATUS");
         $link = array('module' => 'other', 'controller' => 'branch', 'action' => 'edit');
         $this->view->list = $list->getCheckList(0, $collumns, $rs_rowshow, array('branch_namekh' => $link, 'branch_nameen' => $link));
     } catch (Exception $e) {
         Application_Form_FrmMessage::message($this->tr->translate("APPLICATION_ERROR"));
         Application_Model_DbTable_DbUserLog::writeMessageError($e->getMessage());
     }
     $fm = new Other_Form_Frmbranch();
     $frm = $fm->Frmbranch();
     Application_Model_Decorator::removeAllDecorator($frm);
     $this->view->frm_branch = $frm;
 }
예제 #10
0
 public function indexAction()
 {
     $db_user = new Application_Model_DbTable_DbUsers();
     $this->view->activelist = $this->activelist;
     $this->view->user_typelist = $this->user_typelist;
     $this->view->active = -1;
     $_data = array('active' => -1, 'user_type' => -1, 'txtsearch' => '');
     if ($this->getRequest()->isPost()) {
         $_data = $this->getRequest()->getPost();
         print_r($_data);
     }
     $rs_rows = $db_user->getUserList($_data);
     $_rs = array();
     foreach ($rs_rows as $key => $rs) {
         $_rs[$key] = array('id' => $rs['id'], 'name' => $rs['last_name'] . ' ' . $rs['name'], 'user_name' => $rs['user_name'], 'user_type' => $this->user_typelist[$rs['user_type']], 'status' => $rs['status']);
     }
     $list = new Application_Form_Frmtable();
     if (!empty($_rs)) {
         $glClass = new Application_Model_GlobalClass();
         $rs_rows = $glClass->getImgActive($_rs, BASE_URL, true);
     } else {
         $result = Application_Model_DbTable_DbGlobal::getResultWarning();
     }
     $collumns = array("LASTNAME_FIRSTNAME", "USER_NAME", "USER_TYPE", "STATUS");
     $link = array('module' => 'aclAcl', 'controller' => 'user', 'action' => 'edited');
     $this->view->list = $list->getCheckList(0, $collumns, $rs_rows, array('cate_name' => $link, 'title' => $link));
 }
예제 #11
0
 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;
 }
예제 #12
0
 public function indexAction()
 {
     try {
         $db = new Other_Model_DbTable_DbHoliday();
         if ($this->getRequest()->isPost()) {
             $search = $this->getRequest()->getPost();
         } else {
             $search = array('adv_search' => '', 'search_status' => -1, 'start_date' => date('Y-m-01'), 'end_date' => date('Y-m-d'));
         }
         $rs_rows = $db->getAllHoliday($search);
         $glClass = new Application_Model_GlobalClass();
         $rs_rows = $glClass->getImgActive($rs_rows, BASE_URL, true);
         $list = new Application_Form_Frmtable();
         $collumns = array("HOLIDAY_NAME", "Amount Day", "START_DATE", "END_DATE", "NOTE", "STATUS", "BY");
         $link = array('module' => 'other', 'controller' => 'holiday', 'action' => 'edit');
         $this->view->list = $list->getCheckList(0, $collumns, $rs_rows, array('holiday_name' => $link, 'start_date' => $link, 'amount_day' => $link));
     } catch (Exception $e) {
         Application_Form_FrmMessage::message("Application Error");
         Application_Model_DbTable_DbUserLog::writeMessageError($e->getMessage());
     }
     $frm = new Other_Form_FrmHoliday();
     $frm = $frm->FrmAddHoliday();
     Application_Model_Decorator::removeAllDecorator($frm);
     $this->view->frm_holiday = $frm;
 }
예제 #13
0
 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));
 }
예제 #14
0
	public function indexAction(){
		try{
			$db = new Payroll_Model_DbTable_DbDepartment();
			if($this->getRequest()->isPost()){
				$search=$this->getRequest()->getPost();
			}
			else{
				$search = array(
						'adv_search' => '',
						'status_search' => -1);
			}
			$rs_rows= $db->getAllStaffDepartment($search);
			$glClass = new Application_Model_GlobalClass();
			$rs_rows = $glClass->getImgActive($rs_rows, BASE_URL, true);
			$list = new Application_Form_Frmtable();
			$collumns = array("DEPARTMENT_KH","DEPARTMENT_EN","DISPLAY_BY","DATE","STATUS","USER");
			$link=array(
					'module'=>'payroll','controller'=>'department','action'=>'edit',
			);
			$this->view->list=$list->getCheckList(0, $collumns,$rs_rows,array('department_kh'=>$link,'department_en'=>$link));
		}catch (Exception $e){
			Application_Form_FrmMessage::message("Application Error");
			echo $e->getMessage();
			Application_Model_DbTable_DbUserLog::writeMessageError($e->getMessage());
		}
		
		$frm = new Payroll_Form_FrmDepartment();
		 $frm_partment=$frm->FrmAddDepartment();
		 Application_Model_Decorator::removeAllDecorator($frm_partment);
		 $this->view->frm_department = $frm_partment;
	}
예제 #15
0
 public function indexAction()
 {
     try {
         if ($this->getRequest()->isPost()) {
             $_data = $this->getRequest()->getPost();
             $search = array('title' => $_data['title'], 'status' => $_data['status_search']);
         } else {
             $search = array('title' => '', 'status' => -1);
         }
         $db = new Other_Model_DbTable_DbProvince();
         $rs_rows = $db->getAllProvince($search);
         $glClass = new Application_Model_GlobalClass();
         $rs = $glClass->getImgActive($rs_rows, BASE_URL, true, null, 1);
         $list = new Application_Form_Frmtable();
         $collumns = array("EN_PROVINCE", "KH_PROVINCE", "DISPLAY_BY", "MODIFY_DATE", "STATUS", "BY_USER");
         $link = array('module' => 'other', 'controller' => 'province', 'action' => 'edit');
         $this->view->list = $list->getCheckList(0, $collumns, $rs, array('province_kh_name' => $link, 'province_en_name' => $link));
     } catch (Exception $e) {
         Application_Form_FrmMessage::message("Application Error");
         Application_Model_DbTable_DbUserLog::writeMessageError($e->getMessage());
     }
     $frm = new Other_Form_FrmSearch();
     $frm = $frm->searchProvinnce();
     Application_Model_Decorator::removeAllDecorator($frm);
     $this->view->frm_search = $frm;
 }
예제 #16
0
	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);
			$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");
			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;
   			$this->view->result = $search;
	}
예제 #17
0
 public function indexAction()
 {
     try {
         if ($this->getRequest()->isPost()) {
             $_data = $this->getRequest()->getPost();
             $search = array('title' => $_data['title'], 'txtsearch' => $_data['title'], 'status' => $_data['status_search'], 'type' => $_data['type']);
         } else {
             $search = '';
         }
         $db = new Accounting_Model_DbTable_DbServiceType();
         $rs_rows = $db->getAllServicesType($search);
         $list = new Application_Form_Frmtable();
         if (!empty($rs_rows)) {
             $glClass = new Application_Model_GlobalClass();
             $rs_rows = $glClass->getImgActive($rs_rows, BASE_URL, true, 1);
         } else {
             $result = Application_Model_DbTable_DbGlobal::getResultWarning();
         }
         $collumns = array("PROGRAM_TITLE", "DISCRIPTION", "TYPE", "STATUS", "MODIFY_DATE", "BY_USER");
         $link = array('module' => 'accounting', 'controller' => 'services', 'action' => 'edit-service-type');
         $this->view->list = $list->getCheckList(1, $collumns, $rs_rows, array('cate_name' => $link, 'title' => $link));
     } catch (Exception $e) {
         Application_Form_FrmMessage::message("APPLICATION_ERROR");
         Application_Model_DbTable_DbUserLog::writeMessageError($e->getMessage());
     }
     $frm = new Application_Form_FrmOther();
     $this->view->add_major = $frm->FrmAddMajor(null);
     $frm = new Global_Form_FrmSearchMajor();
     $frm = $frm->frmServiceType();
     Application_Model_Decorator::removeAllDecorator($frm);
     $this->view->frm_search = $frm;
 }
예제 #18
0
 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;
 }
예제 #19
0
 public function indexAction()
 {
     try {
         $db = new Group_Model_DbTable_DbChangeCollteral();
         if ($this->getRequest()->isPost()) {
             $search = $this->getRequest()->getPost();
         } else {
             $search = array('adv_search' => '', 'status_search' => -1);
         }
         //print_r($search);exit();
         $rs_rows = $db->getAllChangeCollteral($search);
         //call frome model
         $glClass = new Application_Model_GlobalClass();
         $rs_rows = $glClass->getImgActive($rs_rows, BASE_URL, true);
         $list = new Application_Form_Frmtable();
         $collumns = array("BRANCH", "OWNER_CODE", "OWNER_NAME", "FROM", "TO", "COLLTERAL_TYPE", "NUMBER_CODE", "OWNER", "DATE", "NOTE", "STATUS", "USER_ID");
         $link = array('module' => 'callecterall', 'controller' => 'chengcallecterall', 'action' => 'edit');
         // 			print_r($rs_rows);exit();
         $this->view->list = $list->getCheckList(0, $collumns, $rs_rows, array('branch_id' => $link, 'owner_code_id' => $link, 'owner_id' => $link));
     } catch (Exception $e) {
         Application_Form_FrmMessage::message("Application Error");
         echo $e->getMessage();
         Application_Model_DbTable_DbUserLog::writeMessageError($e->getMessage());
     }
     $fm = new Group_Form_Frmchangecollteral();
     $frm = $fm->FrmChangeCollteral();
     Application_Model_Decorator::removeAllDecorator($frm);
     $this->view->frm_changeCollteral = $frm;
 }
예제 #20
0
	public function indexAction(){
		try{
			$db = new Loan_Model_DbTable_DbLoanIL();
			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->getAllIndividuleLoan($search);
			$glClass = new Application_Model_GlobalClass();
			$rs_rows = $glClass->getImgActive($rs_rows, BASE_URL, true);
			$list = new Application_Form_Frmtable();
			$collumns = array("CLIENT_EN","CLIENT_KH","RELEASE_AMOUNT","INTEREST_RATE","METHOD","TIME_COLLECTION","ZONE","CO",
				"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;
  }
예제 #21
0
 public function indexAction()
 {
     try {
         $db_dept = new Global_Model_DbTable_DbDept();
         if ($this->getRequest()->isPost()) {
             $_data = $this->getRequest()->getPost();
             $search = array('title' => $_data['title'], 'status' => $_data['status_search']);
         } else {
             $search = array('title' => '', 'status' => -1);
         }
         $db = new Global_Model_DbTable_DbRoom();
         $rs_rows = $db->getAllRooms($search);
         $glClass = new Application_Model_GlobalClass();
         $rs_rows = $glClass->getImgActive($rs_rows, BASE_URL, true);
         $list = new Application_Form_Frmtable();
         $collumns = array("ROOM_NAME", "MODIFY_DATE", "STATUS", "BY_USER");
         $link = array('module' => 'global', 'controller' => 'room', 'action' => 'edit');
         $this->view->list = $list->getCheckList(0, $collumns, $rs_rows, array('room_name' => $link));
     } catch (Exception $e) {
         Application_Form_FrmMessage::message("Application Error");
         Application_Model_DbTable_DbUserLog::writeMessageError($e->getMessage());
     }
     $frm = new Global_Form_FrmSearchMajor();
     $frm = $frm->searchRoom();
     Application_Model_Decorator::removeAllDecorator($frm);
     $this->view->frm_search = $frm;
 }
예제 #22
0
 public function indexAction()
 {
 	try{
 		$db = new Callecterall_Model_DbTable_DbCallecterall();
 		if($this->getRequest()->isPost()){
 			$search = $this->getRequest()->getPost();
 		}
 		else{
 			$search = array(
 					'adv_search' => '',
 					'status_search' => -1);
 		}
 		$rs_rows= $db->geteAllid($search);//call frome model
 		$glClass = new Application_Model_GlobalClass();
 		$rs_rows = $glClass->getImgActive($rs_rows, BASE_URL, true);
 		$list = new Application_Form_Frmtable();
 		$collumns = array("NAME_EN","NAME_KH","DATE","STATUS");
 		$link=array(
 				'module'=>'other','controller'=>'callecteralltype','action'=>'edit',
 		);
 		$this->view->list=$list->getCheckList(0, $collumns,$rs_rows,array('title_en'=>$link,'title_kh'=>$link));
 	}catch (Exception $e){
 		Application_Form_FrmMessage::message("Application Error");
 		Application_Model_DbTable_DbUserLog::writeMessageError($e->getMessage());
 	}
 	$frm = new Callecterall_Form_Frmcallecterall();
 	$frm = $frm->Frmcallecterall();
 	Application_Model_Decorator::removeAllDecorator($frm);
 	$this->view->frm_search = $frm;
 }
예제 #23
0
	public function indexAction(){
			try{
				$db = new Group_Model_DbTable_DbCallteral();
			    	if($this->getRequest()->isPost()){
			    		$search=$this->getRequest()->getPost();
			    	}
			    	else{
			    			$search = array(
			    					'adv_search' => '',
			    					'status_search' => -1,
			    					'start_date'=> date('Y-m-d'),
									'end_date'=>date('Y-m-d'));
			    	}
			$rs_rows= $db->geteAllcallteral($search);//call frome model
			$glClass = new Application_Model_GlobalClass();
			$rs_rows = $glClass->getImgActive($rs_rows, BASE_URL, true);
			$list = new Application_Form_Frmtable();
			$collumns = array("BRANCH_NAME","CLIENT_NO","CUSTOMER_NAME","COLLTERAL_CODE","STAFF_NAME","AND_NAME","RELATIVE_WITH","DATE","NOTE","STATUS");
			$link=array(
					'module'=>'group','controller'=>'callteral','action'=>'edit',
			);
			$this->view->list=$list->getCheckList(0, $collumns,$rs_rows,array('branch_name'=>$link,'code_call'=>$link,'co_id'=>$link));
		}catch (Exception $e){
			Application_Form_FrmMessage::message("Application Error");
			Application_Model_DbTable_DbUserLog::writeMessageError($e->getMessage());
		}
		$fm=new Group_Form_Frmcallterals();
		$frm=$fm->FrmCallTeral();
		Application_Model_Decorator::removeAllDecorator($frm);
		$this->view->frm_callteral=$frm;
	}
예제 #24
0
 public function indexAction()
 {
     try {
         if ($this->getRequest()->isPost()) {
             $_data = $this->getRequest()->getPost();
             $search = array('title' => $_data['title']);
         } else {
             $search = array('title' => '');
         }
         $db = new Global_Model_DbTable_DbGroup();
         $rs_rows = $db->getAllGroup($search);
         $list = new Application_Form_Frmtable();
         $collumns = array("GROUP CODE", "DEGREE", "FACULTY", "BATCH", "YEAR", "SEMESTER", "SESSION", "ACADEMIC", "ROOM", "AMOUNT", "STATUS");
         $link = array('module' => 'global', 'controller' => 'group', 'action' => 'edit');
         $this->view->list = $list->getCheckList(0, $collumns, $rs_rows, array('group_code' => $link, 'degree' => $link, 'major_name' => $link));
     } catch (Exception $e) {
         Application_Form_FrmMessage::message("Application Error");
         Application_Model_DbTable_DbUserLog::writeMessageError($e->getMessage());
     }
     $frm = new Application_Form_FrmOther();
     $this->view->add_major = $frm->FrmAddMajor(null);
     $frm = new Global_Form_FrmSearchMajor();
     $frm = $frm->frmSearchTeacher();
     Application_Model_Decorator::removeAllDecorator($frm);
     $this->view->frm_search = $frm;
 }
예제 #25
0
 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;
 }
예제 #26
0
	public function indexAction()
	{
		try{
			if($this->getRequest()->isPost()){
				$search = $this->getRequest()->getPost();
			}else{
				$search = array(
						'branch_name'=>'',
						'co_code'=>'',
						'name_co'=>'',
						'start_date'=> date('Y-m-01'),
						'end_date'=>date('Y-m-d'),
						'txt_search'=>'',
						'status' => '',
						'note'=>''
				);
			}
			$db = new Loan_Model_DbTable_DbTransferCoClient();
			$rs_rows= $db->getAllTransferCO($search);//call frome model
			$list = new Application_Form_Frmtable();
			$collumns = array("BRANCH_NAME","FROM_CO","TO_CO","DATE","NOTE","STATUS",);
			$link=array(
					'module'=>'loan','controller'=>'transferco','action'=>'edit',
			);
			$this->view->list=$list->getCheckList(0, $collumns,$rs_rows,array('loan_number'=>$link,'branch_name'=>$link,'client_name'=>$link,'from_coname'=>$link,'to_coname'=>$link));
		}catch (Exception $e){
			Application_Form_FrmMessage::message("Application Error");
			Application_Model_DbTable_DbUserLog::writeMessageError($e->getMessage());
		}
			$fm = new Loan_Form_FrmTransferCoClient();
			$frm = $fm->FrmTransfer();
			Application_Model_Decorator::removeAllDecorator($frm);
			$this->view->frm_transfer = $frm;
	}
예제 #27
0
 public function indexAction()
 {
     try {
         $db = new Partner_Model_DbTable_DbPartner();
         if ($this->getRequest()->isPost()) {
             $formdata = $this->getRequest()->getPost();
             $search = array('adv_search' => $formdata['adv_search'], 'province_id' => $formdata['province_name'], 'comm_id' => $formdata['commune'], 'district_id' => $formdata['district'], 'village' => $formdata['village'], 'status' => $formdata['status_search'], 'main_branch' => $formdata['main_branch'], 'start_date' => $formdata['start_date'], 'end_date' => $formdata['end_date']);
         } else {
             $search = array('adv_search' => '', 'status' => -1, 'province_id' => -1, 'district_id' => '', 'comm_id' => '', 'village' => '', 'main_branch' => '', 'start_date' => date('Y-m-01'), 'end_date' => date('Y-m-d'));
             //print_r($search);exit();
         }
         $rs_rows = $db->getAllPartner($search);
         // print_r($rs_rows);exit();
         $glClass = new Application_Model_GlobalClass();
         $rs_rows = $glClass->getImgActive($rs_rows, BASE_URL, true, null);
         $list = new Application_Form_Frmtable();
         $collumns = array("ដៃគូមេ", "ឈ្មោះអ្នកគ្រប់គ្រង", "ឈ្មោះដៃគូរសហការណ៏", "លេខគណនេយ្យ", "លេខអត្តសញ្ញាណប័ណ្ណ", "ខេត្ត/ក្រុង", "លេខទូរស័ព្ទ ", "លេខទូរស័ព្ទដៃ", "​ប្រាក់រៀល", "ប្រាក់ដុល្លា", "ប្រាក់បាត", "ថ្ងៃ", "STATUS");
         $link = array('module' => 'partner', 'controller' => 'index', 'action' => 'edit');
         $this->view->list = $list->getCheckList(0, $collumns, $rs_rows, array('main_branch' => $link, 'nation_id' => $link, 'account_no' => $link, 'partner_name' => $link, 'partner_brand' => $link, 'name' => $link, 'address' => $link));
     } catch (Exception $e) {
         Application_Form_FrmMessage::message("Application Error");
         Application_Model_DbTable_DbUserLog::writeMessageError($e->getMessage());
     }
     $pructis = new Partner_Form_FrmPartner();
     $frm = $pructis->addPartner();
     Application_Model_Decorator::removeAllDecorator($frm);
     $form = $this->view->frm_partner = $frm;
     //echo $form;exit();
     $this->view->result = $search;
     $db = new Application_Model_DbTable_DbGlobal();
     $this->view->district = $db->getAllDistricts();
     $this->view->commune_name = $db->getCommune();
     $this->view->village_name = $db->getVillage();
 }
예제 #28
0
 public function indexAction()
 {
     try {
         $db = new Capital_Model_DbTable_DbCapital();
         if ($this->getRequest()->isPost()) {
             $search = $this->getRequest()->getPost();
         } else {
             $search = array('search' => '', 'status' => -1);
         }
         $rs_rows = $db->getAllCapital($search);
         $glClass = new Application_Model_GlobalClass();
         //status
         $rs_rows = $glClass->getImgActive($rs_rows, BASE_URL, true);
         $list = new Application_Form_Frmtable();
         $collumns = array("សាខា", "ថ្ងៃ", "សម្គាល់", "ចំនួនប្រាក់ដុល្លា", "ចំនួនប្រាក់រៀល", "ចំនួនប្រាក់បាត", "ស្ថានភាព");
         $link = array('module' => 'capital', 'controller' => 'capital', 'action' => 'edit');
         $this->view->list = $list->getCheckList(0, $collumns, $rs_rows, array('branch_namekh' => $link));
     } catch (Exception $e) {
         Application_Form_FrmMessage::message("Application Error");
         echo $e->getMessage();
         Application_Model_DbTable_DbUserLog::writeMessageError($e->getMessage());
     }
     $fm = new Capital_Form_FrmCapitale();
     $frm = $fm->frmSearch();
     Application_Model_Decorator::removeAllDecorator($frm);
     $this->view->frm = $frm;
 }
예제 #29
0
	public function indexAction(){
		try{
			$db = new Other_Model_DbTable_DbPosition();
			if($this->getRequest()->isPost()){
				$search=$this->getRequest()->getPost();
			}
			else{
				$search = array(
						'adv_search' => '',
						'status_search' => -1);
			}
			$rs_rows= $db->getAllStaffPosition($search);
			$glClass = new Application_Model_GlobalClass();
			$rs_rows = $glClass->getImgActive($rs_rows, BASE_URL, true);
			$list = new Application_Form_Frmtable();
			$collumns = array("POSITION_EN","POSITION_KH","DISPLAY_BY","STATUS");
			$link=array(
					'module'=>'payroll','controller'=>'position','action'=>'edit',
			);
			$this->view->list=$list->getCheckList(0, $collumns,$rs_rows,array('position_en'=>$link,'position_kh'=>$link));
		}catch (Exception $e){
			Application_Form_FrmMessage::message("Application Error");
			echo $e->getMessage();
			Application_Model_DbTable_DbUserLog::writeMessageError($e->getMessage());
		}
		

		$frm = new Other_Form_FrmPosition();
		 $frm_co=$frm->FrmAddPosition();
		 Application_Model_Decorator::removeAllDecorator($frm_co);
		 $this->view->frm_position = $frm_co;
	}
예제 #30
0
		public function indexAction(){
		try{
			$db = new Payroll_Model_DbTable_DbSalary();
			if($this->getRequest()->isPost()){
				$search=$this->getRequest()->getPost();
			}
			else{
				$search = array(
						'adv_search' => '',
						'status_search' => -1,
						'from_date' =>date('Y-m-d'),
						'to_date' => date('Y-m-d'),
				);
			}
			$rs_rows= $db->getAllSalary($search);
			$glClass = new Application_Model_GlobalClass();//status
			$rs_rows = $glClass->getImgActive($rs_rows, BASE_URL,true);
			$list = new Application_Form_Frmtable();
			$collumns = array("BRANCH","STAFF_NAME","BASIC_SALARY","POSITION","DATE_START_WORK","DATE_OPEN_SALARY","DATE_END_CONTRACT","DATE","USER","STATUS","DETAIL");
			$link=array(
					'module'=>'payroll','controller'=>'salary','action'=>'edit',
			);
			$this->view->list=$list->getCheckList(0,$collumns,$rs_rows,array('branch_name'=>$link,'staff_id'=>$link,'basic_salary'=>$link,'detail'=>array('module'=>'payroll','controller'=>'salary','action'=>'detail')));
		}catch (Exception $e){
			Application_Form_FrmMessage::message("Application Error");
			echo $e->getMessage();
			Application_Model_DbTable_DbUserLog::writeMessageError($e->getMessage());
		}
		$fm=new Payroll_Form_FrmSalary();
		$frm = $fm->frmaddSalary();
		Application_Model_Decorator::removeAllDecorator($frm);
		$this->view->frm=$frm;
	}