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 init()
{
$this->tr = Application_Form_FrmLanguages::getCurrentlanguage();
$this->tvalidate = 'dijit.form.ValidationTextBox';
$this->filter = 'dijit.form.FilteringSelect';
$this->t_date = 'dijit.form.DateTextBox';
$this->t_num = 'dijit.form.NumberTextBox';
$this->text = 'dijit.form.TextBox';
$this->_khname = new Zend_Dojo_Form_Element_TextBox('kh_name');
$this->_khname->setAttribs(array('dojoType' => $this->text, 'class' => 'fullside'));
$this->_enname = new Zend_Dojo_Form_Element_TextBox('en_name');
$this->_enname->setAttribs(array('dojoType' => $this->tvalidate, 'required' => 'true', 'class' => 'fullside'));
$this->_dob = new Zend_Dojo_Form_Element_DateTextBox('dob');
$date = date("Y-m-d") - 20;
$this->_dob->setAttribs(array('data-dojo-Type' => "dijit.form.DateTextBox", 'data-dojo-props' => "value:'{$date}','class':'fullside','name':'dob'", 'required' => true));
$this->_dob->setValue($date);
$this->_phone = new Zend_Dojo_Form_Element_TextBox('phone');
$this->_phone->setAttribs(array('data-dojo-Type' => $this->tvalidate, 'data-dojo-props' => "regExp:'[0-9]{9,10}',\r\n\t\t\t\t 'name':'phone',\r\n\t\t\t\t\t'class':'fullside',\r\n\t\t\t\t \t'placeHolder': '012345678',\r\n\t\t\t\t \t'invalidMessage':'មិនមាន ចន្លោះ ឬ សញ្ញាពិសេស រឺលើសចំនួនឡើយ'"));
$this->_degree = new Zend_Dojo_Form_Element_FilteringSelect('degree');
$this->_degree->setAttribs(array('dojoType' => 'dijit.form.FilteringSelect', 'class' => 'fullside', 'onchange' => 'getTuitionFee();'));
$arr_opt = Application_Model_DbTable_DbGlobal::getAllDegreeById();
// $arr_opt = array(
// 1=>$this->tr->translate("ASSOCIATE"),
// 2=>$this->tr->translate("BACHELOR"),
// 3=>$this->tr->translate('MASTER'),
// 4=>$this->tr->translate('DOCTORATE'));
$this->_degree->setMultiOptions($arr_opt);
$this->_batch = new Zend_Dojo_Form_Element_NumberTextBox("batch");
$this->_batch->setAttribs(array('onclick' => 'alert(3)', 'data-dojo-Type' => $this->tvalidate, 'onclick' => 'alert(2)', 'data-dojo-props' => "regExp:'[0-9]{1,2}','required':true,\r\n\t\t\t\t'name':'batch',\r\n\t\t\t\t'onclick':'alert(1)',\r\n\t\t\t\t'class':'fullside',\r\n\t\t\t\t'invalidMessage':'អាចបញ្ជូលពី 1 ដល់ 99'"));
$this->_year = new Zend_Dojo_Form_Element_TextBox("year");
$this->_year->setAttribs(array('data-dojo-Type' => $this->tvalidate, 'data-dojo-props' => "regExp:'[0-5]{1}',\r\n\t\t\t\t'name':'year',\r\n\t\t\t\t'required':true,'class':'fullside',\r\n\t\t\t\t'invalidMessage':'អាចបញ្ជូលពី 1 ដល់ 5'"));
$this->_session = new Zend_Dojo_Form_Element_FilteringSelect("session");
$opt_session = array(1 => $this->tr->translate('MORNING'), 2 => $this->tr->translate('AFTERNOON'), 3 => $this->tr->translate('EVERNING'), 4 => $this->tr->translate('WEEKEND'));
$this->_session->setMultiOptions($opt_session);
$this->_session->setAttribs(array('dojoType' => $this->filter, 'required' => 'true', 'class' => 'fullside'));
// $pay_date = date('Y-m-d', mktime(date('h'), date('i'), date('s'), date('m'), date('d')+45, date('Y')));
$this->_pay_date = new Zend_Dojo_Form_Element_DateTextBox('dob');
$this->_pay_date->setAttribs(array('dojoType' => $this->t_date, 'class' => 'fullside', 'constraints' => '{datePattern:"dd/MM/yyyy"'));
$this->_remark = new Zend_Dojo_Form_Element_TextBox('remark');
$this->_remark->setAttribs(array('dojoType' => $this->text, 'class' => 'fullside'));
$this->_pay_date = new Zend_Dojo_Form_Element_TextBox('pay_date');
$this->_pay_date->setAttribs(array('dojoType' => $this->t_date, 'class' => 'fullside'));
}
public function headAddRecordTuitionFee($rs, $key)
{
$result[$key] = array('id' => $rs['id'], 'degree' => Application_Model_DbTable_DbGlobal::getAllDegreeById($rs['degree']), 'faculty_name' => $rs['faculty_name'], 'batch' => $rs['batch'], 'status' => Application_Model_DbTable_DbGlobal::getAllStatus($rs['status']));
return $result[$key];
}
