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 { 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 { $newstudent_session = Application_Model_DbTable_DbGlobal::SessionNavigetor('new-student'); if (empty($newstudent_session->limit)) { $newstudent_session->limit = Application_Form_FrmNavigation::getLimit(); $newstudent_session->lock(); } $limit = $newstudent_session->limit; $start = $this->start(); if ($this->getRequest()->isPost()) { $_data = $this->getRequest()->getPost(); $newstudent_session->unlock(); $newstudent_session->limit = $_data['rows_per_page']; $newstudent_session->lock(); //set value for display $search = array('txtsearch' => $newstudent_session->txtsearch, 'title' => $_data['title'], 'status' => $_data['status_search'], 'subjec_name' => $_data['subjec_name']); $limit = $newstudent_session->limit; } else { $search = ''; } $db = new Foundation_Model_DbTable_DbNewStudent(); $teacher = $db->getAllNewStudent($search, $start, $limit); $record_count = $teacher[1]; $row_num = $start; if (!empty($teacher)) { foreach ($teacher[0] as $i => $rs) { $result[$i] = array('id' => $rs['id'], 'num' => ++$row_num, 'stu_khname' => $rs['stu_khname'], 'stu_enname' => $rs['stu_enname'], 'sex' => $rs['sex'], 'stu_card' => $rs['stu_card'], 'dob' => $rs['dob'], 'phone' => $rs['phone'], 'degree' => Application_Model_DbTable_DbGlobal::getAllDegreeById($rs["degree"]), 'major_id' => $rs["major_name"], 'session' => Application_Model_DbTable_DbGlobal::getSessionById($rs["session"]), 'status' => $this->activelist[$rs["status"]], 'create_date' => $rs["create_date"], 'user_name' => $rs["user_name"]); } } else { $result = Application_Model_DbTable_DbGlobal::getResultWarning(); } $gride = new Application_Form_Frmlist(); $collumn = array("NAME_KH", "NAME_EN", "SEX", "ID_NUMBER", "DOB", "PHONE", "DEGREE", "MAJORS", "SESSION", "STATUS", "CREATED_DATE", "BY_USER"); $this->view->grideview = $gride->grideView(BASE_URL . "/foundation/newstudent/edit-student", "/foundation/newstudent/index", $collumn, @$result, $start, $limit, $record_count); } 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 RsvAcl_Model_DbTable_DbAcl(); $rs_rows = $db->getAllAclList(); if (!empty($rs_rows)) { $glClass = new Application_Model_GlobalClass(); $rs_rows = $glClass->getImgActive($rs_rows, BASE_URL, true); } else { $rs_rows = Application_Model_DbTable_DbGlobal::getResultWarning(); } $list = new Application_Form_Frmtable(); $collumns = array("VIEW", "MODULE_NAME", "CONTROLLER", "ACTION", "STATUS"); $link = array('module' => 'rsvAcl', 'controller' => 'acl', 'action' => 'edit'); if (empty($rs_rows)) { $result = Application_Model_DbTable_DbUserLog::writeMessageError(''); } $this->view->list = $list->getCheckList(0, $collumns, $rs_rows, array('module' => $link, 'controller' => $link, 'action' => $link)); } catch (Exception $e) { $result = Application_Model_DbTable_DbUserLog::writeMessageError(''); } }
public function indexAction() { // action body try { $db_tran = new Application_Model_DbTable_DbGlobal(); $db = new RsvAcl_Model_DbTable_DbUserType(); $result = $db->getAlluserType(); $list = new Application_Form_Frmtable(); if (!empty($result)) { $glClass = new Application_Model_GlobalClass(); $result = $glClass->getImgActive($result, BASE_URL, true); } else { $result = Application_Model_DbTable_DbGlobal::getResultWarning(); } $collumns = array("USER_TYPE", "PARENT", "STATUS"); $link = array('module' => 'rsvAcl', 'controller' => 'userAccess', 'action' => 'view-user-access'); $this->view->list = $list->getCheckList(0, $collumns, $result, array('user_type' => $link, 'title' => $link)); if (empty($result)) { $result = array('err' => 1, 'msg' => 'មិនទាន់មានទិន្នន័យនៅឡើយ!'); } } catch (Exception $e) { $result = Application_Model_DbTable_DbGlobal::getResultWarning(); } }
public function indexAction() { try { if ($this->getRequest()->isPost()) { $_data = $this->getRequest()->getPost(); $search = array('title' => $session_servicetype->txtsearch, 'txtsearch' => $_data['title'], 'status' => $_data['status_search'], 'type' => $_data['type']); $limit = $session_servicetype->limit; } else { $search = ''; } $db = new Accounting_Model_DbTable_DbTuitionFee(); $service = $db->getAllTuitionFee($search); $model = new Application_Model_DbTable_DbGlobal(); $row = 0; $indexterm = 1; $key = 0; if (!empty($service)) { foreach ($service as $i => $rs) { $rows = $db->getFeebyOther($rs['id']); $fee_row = 1; if (!empty($rows)) { foreach ($rows as $payment_tran) { if ($payment_tran['payment_type'] == 1) { $rs_rows[$key] = $this->headAddRecordTuitionFee($rs, $key); $term = $model->getAllPaymentTerm($fee_row); $rs_rows[$key]['quarter'] = $payment_tran['tuition_fee']; $key_old = $key; $key++; } elseif ($payment_tran['payment_type'] == 2) { $term = $model->getAllPaymentTerm($payment_tran['payment_type']); $rs_rows[$key_old]['semester'] = $payment_tran['tuition_fee']; } elseif ($payment_tran['payment_type'] == 3) { $term = $model->getAllPaymentTerm($payment_tran['payment_type']); $rs_rows[$key_old]['year'] = $payment_tran['tuition_fee']; } else { $term = $model->getAllPaymentTerm($payment_tran['payment_type']); $rs_rows[$key_old]['full_fee'] = $payment_tran['tuition_fee']; } if ($rs['degree_type'] == 1) { $rs_rows[$key_old]['faculty_name'] = Application_Model_DbTable_DbGlobal::getAllMention($payment_tran['metion']); } else { $r_facu = $model->getDeptById($payment_tran['metion']); $rs_rows[$key_old]['faculty_name'] = $r_facu['en_name']; } } } } } else { $result = Application_Model_DbTable_DbGlobal::getResultWarning(); } $pay_term = $model->getAllPaymentTerm(); $payment_term = ''; foreach ($pay_term as $value) { $payment_term .= '"' . $value . '",'; } $list = new Application_Form_Frmtable(); $collumns = array("DEGREE", "FACULTY/METION", "BATCH", "STATUS", "QUARTER", "SEMESTER", "YEAR", "FULL_FEE"); $link = array('module' => 'accounting', 'controller' => 'fee', 'action' => 'edit-feetuition'); $urlEdit = BASE_URL . "/product/index/update"; $this->view->list = $list->getCheckList(1, $collumns, $rs_rows, array('degree' => $link)); } catch (Exception $e) { Application_Form_FrmMessage::message("APPLICATION_ERROR"); Application_Model_DbTable_DbUserLog::writeMessageError($e->getMessage()); } $frm = new Global_Form_FrmSearchMajor(); $frm = $frm->frmSearchTutionFee(); Application_Model_Decorator::removeAllDecorator($frm); $this->view->frm_search = $frm; }
public function indexAction() { try { if ($this->getRequest()->isPost()) { $_data = $this->getRequest()->getPost(); print_r($_data); exit; $search = array('txtsearch' => $_data['title'], 'status' => $_data['status_search'], 'type' => $_data['type']); } else { $search = ''; } $db = new Accounting_Model_DbTable_DbServiceCharge(); $service = $db->getAllTuitionFee($search, 2); $model = new Application_Model_DbTable_DbGlobal(); $row = 0; $indexterm = 1; $test = 0; $key = 0; if (!empty($service)) { foreach ($service as $i => $rs) { $rows = $db->getServiceFeebyId($rs['id'], 2); if (empty($rows)) { continue; } $fee_row = 1; if (!empty($rows)) { foreach ($rows as $payment_tran) { echo $payment_tran['pay_type']; if ($payment_tran['pay_type'] == 1) { $rs_rows[$key] = $this->headAddRecordTuitionFee($rs, $key); //if($rs_rows[$key_old]['id']==$rs_rows[$key]['id']){ //} $term = $model->getAllGEPPrgramPayment($fee_row); //$rs_rows[$key]['program_name'].=$payment_tran['level']; //$rs_rows[$key]['level'] = $payment_tran['level']; $rs_rows[$key]['fee'] = $payment_tran['price']; $key_old = $key; $key++; //echo 2; } elseif ($payment_tran['pay_type'] == 2) { $term = $model->getAllGEPPrgramPayment($payment_tran['pay_type']); // $rs_rows[$key]['level'] = $payment_tran['level']; $rs_rows[$key_old]['2term'] = $payment_tran['price']; //echo 3333; } elseif ($payment_tran['pay_type'] == 3) { $term = $model->getAllGEPPrgramPayment($payment_tran['pay_type']); //$rs_rows[$key]['level'] = $payment_tran['level']; $rs_rows[$key_old]['3term'] = $payment_tran['price']; } else { $term = $model->getAllGEPPrgramPayment($payment_tran['pay_type']); //$rs_rows[$key]['level'] = $payment_tran['level']; $rs_rows[$key_old]['full_fee'] = $payment_tran['price']; } } } } } else { $result = Application_Model_DbTable_DbGlobal::getResultWarning(); $rs_rows = array(); } if (empty($rs_rows)) { $rs_rows = ""; } $pay_term = $model->getAllGEPPrgramPayment(); $list = new Application_Form_Frmtable(); $collumns = array("SERVICE_NAME", "TYPE", "STATUS"); $end = end(array_keys($collumns)); $payment_term = ''; $key = 1; //for merch array for collumn foreach ($pay_term as $value) { $collumns[$end + $key] = $value; $key++; } $link = array('module' => 'accounting', 'controller' => 'ProgramCharge', 'action' => 'edit-program-charge'); $this->view->list = $list->getCheckList(1, $collumns, $rs_rows, array('cate_name' => $link, 'program_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->frmSearchServiceChageFee(); Application_Model_Decorator::removeAllDecorator($frm); $this->view->frm_search = $frm; }