public function indexAction(){
try{
$db = new Group_Model_DbTable_DbReturnCollteral();
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'),
'branch_id'=>'');
}//print_r($search);exit();
$rs_rows= $db->getAllReturnCollteral($search);//call frome model
$glClass = new Application_Model_GlobalClass();
$rs_rowss = $glClass->getImgActive($rs_rows, BASE_URL, true);
$list = new Application_Form_Frmtable();
$collumns = array("BRANCH_NAME","CUSTOMER_NAME","GIVER_NAME","RECEIVER_NAME","DATE","NOTE","STATUS","BY_USER");
$link=array(
'module'=>'group','controller'=>'Returncollteral','action'=>'edit',
);
$this->view->list=$list->getCheckList(0, $collumns,$rs_rowss,array('branch_id'=>$link,'client_name'=>$link,'giver_name'=>$link,'receiver_name'=>$link,'date'=>$link));
}catch (Exception $e){
Application_Form_FrmMessage::message("Application Error");
Application_Model_DbTable_DbUserLog::writeMessageError($e->getMessage());
}
$fm = new Group_Form_Frmreturncollteral();
$frm = $fm->FrmReturnCollteral();
Application_Model_Decorator::removeAllDecorator($frm);
$this->view->frm_returnCollteral = $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 indexAction()
{
try {
$db = new Other_Model_DbTable_DbCreditOfficer();
if ($this->getRequest()->isPost()) {
$search = $this->getRequest()->getPost();
} else {
$search = array('adv_search' => '', 'status' => -1);
}
$rs_rows = $db->getAllCreditOfficer($search);
$glClass = new Application_Model_GlobalClass();
$rs_rows = $glClass->getImgActive($rs_rows, BASE_URL, true, 1);
$list = new Application_Form_Frmtable();
$collumns = array("CODE", "Name Khmer", "Name In ENG", "National ID", "Address", "Tel", "Email", "Degree", "Status");
$link = array('module' => 'other', 'controller' => 'co', 'action' => 'edit');
$this->view->list = $list->getCheckList(0, $collumns, $rs_rows, array('co_code' => $link, 'co_khname' => $link, 'co_engname' => $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_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 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;
}
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 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 {
$db = new Tellerandexchange_Model_DbTable_DbClient();
if ($this->getRequest()->isPost()) {
$search = $this->getRequest()->getPost();
} else {
$search = array('adv_search' => '', 'status' => -1);
}
$rs_rows = $db->getAllClients($search);
$result = array();
foreach ($rs_rows as $key => $rs) {
$result[$key] = array('client_id' => $rs['client_id'], 'client_number' => $rs['client_number'], 'name_kh' => $rs['name_kh'], 'name_en' => $rs['name_en'], 'sex' => $this->sex[$rs['sex']], 'phone' => $rs['phone'], 'house' => $rs['house'], 'street' => $rs['street'], 'village_name' => $rs['village_name'], 'spouse_name' => $rs['spouse_name'], 'user_name' => $rs['user_name'], 'status' => $rs['status']);
}
$glClass = new Application_Model_GlobalClass();
$rs_rows = $glClass->getImgActive($result, BASE_URL, true);
$list = new Application_Form_Frmtable();
$collumns = array("Term", "Loan N.", "Date Due", "OS", "Principal", "Interest Rate", "Paid Principal", "Paid Interest Rate", "CO", "By", "status");
$link = array('module' => 'group', 'controller' => 'Client', 'action' => 'edit');
$this->view->list = $list->getCheckList(0, $collumns, array(), array('client_number' => $link, 'name_kh' => $link, 'name_en' => $link));
} catch (Exception $e) {
Application_Form_FrmMessage::message("Application Error");
echo $e->getMessage();
Application_Model_DbTable_DbUserLog::writeMessageError($e->getMessage());
}
$frm = new Application_Form_FrmAdvanceSearch();
$frm = $frm->AdvanceSearch();
Application_Model_Decorator::removeAllDecorator($frm);
$this->view->frm_search = $frm;
}
public function indexAction(){
try{
$db = new 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;
}
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);
$glClass = new Application_Model_GlobalClass();
$rs_rows = $glClass->getImgActive($rs_rows, BASE_URL, true);
$list = new Application_Form_Frmtable();
$collumns = array("BRANCH_NAME ", "FIXED_ASSETNAME ", "FIXED_ASSET_TYPE", "ASSET_COST", "PAY_TYPE", "USEFULL_LIFE", "SALVAGEVALUE", "TOTA_AMOUNT", "PAYMANT_MATHOD", "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());
}
$fm = new Application_Form_FrmAdvanceSearch();
$frm = $fm->AdvanceSearch();
Application_Model_Decorator::removeAllDecorator($frm);
$this->view->frm_search = $frm;
$fms = new Accounting_Form_Frmasset();
$frms = $fms->FrmAsset();
Application_Model_Decorator::removeAllDecorator($frms);
$this->view->frm_fixedasset = $frms;
}
public function indexAction()
{
try {
$db_make = new Vehicle_Model_DbTable_DbVehicle();
if ($this->getRequest()->isPost()) {
$search = $this->getRequest()->getPost();
//print_r($search);exit();
} else {
$search = array('adv_search' => '', 'make' => -1, 'model' => -1, 'submodel' => -1, 'search_status' => -1);
}
$rows = $db_make->getAllVehicle($search);
$glClass = new Application_Model_GlobalClass();
$rows = $glClass->getImgActive($rows, BASE_URL, true);
$list = new Application_Form_Frmtable();
$collumns = array("Vehicle Ref", "Year", "Make", "Model", "Sub Model", "Type", "Color", "Engine No", "Chassis No", "Frame No", "Plate No", "Date", "STATUS");
$link = array('module' => 'vehicle', 'controller' => 'index', 'action' => 'edit');
$this->view->list = $list->getCheckList(0, $collumns, $rows, array('reffer' => $link, 'year' => $link, 'make_id' => $link, 'model_id' => $link, 'sub_model' => $link, 'status' => $link, 'type' => $link));
} catch (Exception $e) {
Application_Form_FrmMessage::message("Application Error");
Application_Model_DbTable_DbUserLog::writeMessageError($e->getMessage());
}
$db = new Application_Model_DbTable_DbGlobal();
$model = $db->getAllMake();
//array_unshift($model, array ( 'id' => -1, 'name' => 'Selected Make') );
$this->view->all_make = $model;
}
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 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 {
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 = 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 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 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()
{
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_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_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{
$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 = 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{
$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 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 Other_Model_DbTable_DbOwner();
// if($this->getRequest()->isPost()){
// $search=$this->getRequest()->getPost();
// }
// else{
// $search = array(
// 'adv_search' => '',
// 'search_status' => -1);
// }
$rs_rows = $db->getAllOwner();
$glClass = new Application_Model_GlobalClass();
$rs_rows = $glClass->getImgActive($rs_rows, BASE_URL, true);
$list = new Application_Form_Frmtable();
$collumns = array("Owner Name", "Position", "ID Card", "Phone", "E-mail", "Insurance Hotline", "Status");
$link = array('module' => 'other', 'controller' => 'ownervehicle', 'action' => 'edit');
$this->view->list = $list->getCheckList(0, $collumns, $rs_rows, array('hand_phone' => $link, 'owner_name' => $link, 'position' => $link, 'id_card' => $link));
} catch (Exception $e) {
Application_Form_FrmMessage::message("Application Error");
echo $e->getMessage();
Application_Model_DbTable_DbUserLog::writeMessageError($e->getMessage());
}
}