PHP Application_Model_DbTable_DbGlobal::getAllDegreeById方法代码示例

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