PHP Application_Form_Frmtable类代码示例

 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;
 }

 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;
 }

    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;
    }

 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;
 }

 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());
     }
 }

 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;
 }

 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;
 }

 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());
     }
 }

 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;
 }

 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));
 }

 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 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;
 }

 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 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;
	}

 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;
 }