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