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