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