PHP Application_Model_DbTable_DbGlobal::getAllDegree方法代码示例

 public function FrmAddCO($_data = null)
 {
     $_co_id = new Zend_Dojo_Form_Element_TextBox('co_id');
     $_co_id->setAttribs(array('dojoType' => $this->tvalidate, 'required' => 'true', 'class' => 'fullside'));
     $_name_kh = new Zend_Dojo_Form_Element_TextBox('name_kh');
     $_name_kh->setAttribs(array('dojoType' => $this->tvalidate, 'required' => 'true', 'class' => 'fullside'));
     $_enname = new Zend_Dojo_Form_Element_TextBox('first_name');
     $_enname->setAttribs(array('dojoType' => $this->tvalidate, 'required' => 'true', 'class' => 'fullside'));
     $_lname = new Zend_Dojo_Form_Element_TextBox('last_name');
     $_lname->setAttribs(array('dojoType' => $this->text, 'class' => 'fullside'));
     $_sex = new Zend_Dojo_Form_Element_FilteringSelect('co_sex');
     $_sex->setAttribs(array('dojoType' => 'dijit.form.FilteringSelect', 'class' => 'fullside'));
     $opt = array(1 => "Male", 2 => "Femail");
     $_sex->setMultiOptions($opt);
     $_tel = new Zend_Dojo_Form_Element_TextBox('tel');
     $_tel->setAttribs(array('dojoType' => $this->tvalidate, 'required' => 'true', 'class' => 'fullside'));
     $_email = new Zend_Dojo_Form_Element_TextBox('email');
     $_email->setAttribs(array('dojoType' => $this->text, 'class' => 'fullside'));
     $_national_id = new Zend_Dojo_Form_Element_TextBox('national_id');
     $_national_id->setAttribs(array('dojoType' => 'dijit.form.NumberTextBox', 'class' => 'fullside'));
     $_address = new Zend_Dojo_Form_Element_TextBox('address');
     $_address->setAttribs(array('dojoType' => $this->text, 'class' => 'fullside'));
     $_pob = new Zend_Dojo_Form_Element_TextBox('pob');
     $_pob->setAttribs(array('dojoType' => $this->text, 'class' => 'fullside'));
     $_status = new Zend_Dojo_Form_Element_FilteringSelect('status');
     $_status->setAttribs(array('dojoType' => $this->filter, 'class' => 'fullside'));
     $_status_opt = array(1 => $this->tr->translate("ACTIVE"), 0 => $this->tr->translate("DACTIVE"));
     $_status->setMultiOptions($_status_opt);
     $_display = new Zend_Dojo_Form_Element_FilteringSelect('display');
     $_display->setAttribs(array('dojoType' => $this->filter, 'class' => 'fullside'));
     $_display_opt = array(1 => $this->tr->translate("NAME_KHMER"), 2 => $this->tr->translate("NAME_ENGLISH"));
     $_display->setMultiOptions($_display_opt);
     $_degree = new Zend_Dojo_Form_Element_FilteringSelect('degree');
     $_degree->setAttribs(array('dojoType' => $this->filter, 'class' => 'fullside'));
     $db = new Application_Model_DbTable_DbGlobal();
     $degree_opt = $db->getAllDegree();
     $_id = new Zend_Form_Element_Hidden('id');
     if (!empty($_data)) {
         $_co_id->setValue($_data['co_code']);
         $_name_kh->setValue($_data['co_khname']);
         $_enname->setValue($_data['co_firstname']);
         $_lname->setValue($_data['co_lastname']);
         $_display->setValue($_data['displayby']);
         $_national_id->setValue($_data['national_id']);
         $_pob->setValue($_data['pob']);
         $_degree->setValue($_data['degree']);
         $_tel->setValue($_data['tel']);
         $_email->setValue($_data['email']);
         $_address->setValue($_data['address']);
         $_status->setValue($_data['status']);
         $_id->setValue($_data['co_id']);
     }
     $this->addElements(array($_id, $_co_id, $_name_kh, $_degree, $_national_id, $_display, $_enname, $_lname, $_sex, $_tel, $_email, $_pob, $_address, $_status));
     return $this;
 }

 public function FrmSetServicePrice($data = null)
 {
     $_db = new Application_Model_DbTable_DbGlobal();
     $_year = $this->_year;
     $_session = $this->_session;
     $_batch = new Zend_Dojo_Form_Element_NumberTextBox("batch");
     $_batch->setAttribs(array('dojoType' => $this->t_num, 'required' => 'true', 'class' => 'fullside'));
     // 		$this->_year->setAttribs(array(
     // 				'data-dojo-Type'=>$this->tvalidate,
     // 				'data-dojo-props'=>"regExp:'[0-5]{1}',
     // 				'required':true,'class':'fullside',
     // 				'invalidMessage':'អាចបញ្ជូលពី 1 ដល់  5'"));
     $_degree = new Zend_Dojo_Form_Element_FilteringSelect('degree');
     $_degree->setAttribs(array('dojoType' => 'dijit.form.FilteringSelect', 'class' => 'fullside', 'Onchange' => 'CheckDegree()'));
     $arr_opt = $_db->getAllDegree();
     $_degree->setMultiOptions($arr_opt);
     $_remark = new Zend_Dojo_Form_Element_TextBox('remark');
     $_remark->setAttribs(array('dojoType' => $this->text, 'class' => 'fullside'));
     $rows = $_db->getAllFecultyName();
     array_unshift($rows, array('dept_id' => -1, 'en_name' => "Add New"));
     $opt = "";
     if (!empty($rows)) {
         foreach ($rows as $row) {
             $opt[$row['dept_id']] = $row['en_name'];
         }
     }
     $_faculty = new Zend_Dojo_Form_Element_FilteringSelect("faculty");
     $_faculty->setMultiOptions($opt);
     $_faculty->setAttribs(array('dojoType' => $this->filter, 'required' => 'true', 'class' => 'fullside', 'onchange' => 'showPopupDept()'));
     $_term = new Zend_Dojo_Form_Element_FilteringSelect("payment_term");
     $opt_term = $_db->getAllPaymentTerm();
     $_term->setMultiOptions($opt_term);
     $_term->setAttribs(array('dojoType' => $this->filter, 'required' => 'true', 'class' => 'fullside'));
     $_create_date = new Zend_Dojo_Form_Element_DateTextBox("create_date");
     $_create_date->setAttribs(array('dojoType' => $this->date, 'required' => 'true', 'class' => 'fullside'));
     $_create_date->setValue(date("Y-m-d"));
     $_rank = new Zend_Dojo_Form_Element_FilteringSelect("rank");
     $opt_rank = $_db->getAllMention();
     $_rank->setMultiOptions($opt_rank);
     $_rank->setAttribs(array('dojoType' => $this->filter, 'required' => 'true', 'class' => 'fullside'));
     $this->addElements(array($_degree, $_faculty, $_batch, $_year, $_session, $_term, $_remark, $_rank, $_create_date));
     return $this;
 }

 public function FrmTecher($_data = null)
 {
     $_enname = new Zend_Dojo_Form_Element_TextBox('en_name');
     $_enname->setAttribs(array('dojoType' => $this->tvalidate, 'required' => 'true', 'class' => 'fullside'));
     $_khname = new Zend_Dojo_Form_Element_TextBox('kh_name');
     $_khname->setAttribs(array('dojoType' => $this->tvalidate, 'required' => 'true', 'class' => 'fullside'));
     $code = new Zend_Dojo_Form_Element_TextBox('code');
     $code->setAttribs(array('dojoType' => $this->text, 'class' => 'fullside', 'readOnly' => 'readOnly'));
     $db = new Application_Model_DbTable_DbGlobal();
     $code_num = $db->getTeacherCode();
     $code->setValue($code_num);
     $phone = new Zend_Dojo_Form_Element_TextBox('phone');
     $phone->setAttribs(array('dojoType' => $this->text, 'class' => 'fullside'));
     $sex = new Zend_Dojo_Form_Element_FilteringSelect('sex');
     $sex->setAttribs(array('dojoType' => $this->filter, 'class' => 'fullside'));
     $options = array(1 => "M", 2 => "F");
     $sex->setMultiOptions($options);
     $dob = new Zend_Dojo_Form_Element_DateTextBox('dob');
     $dob->setAttribs(array('dojoType' => $this->t_date, 'class' => 'fullside'));
     $_adress = new Zend_Dojo_Form_Element_TextBox('address');
     $_adress->setAttribs(array('dojoType' => $this->text, 'class' => 'fullside'));
     $db = new Application_Model_DbTable_DbGlobal();
     $db->getAllProvince();
     $rows = $db->getAllProvince();
     $opt = "";
     if (!empty($rows)) {
         foreach ($rows as $row) {
             $opt[$row['id']] = $row['province_name'];
         }
     }
     $pob = new Zend_Dojo_Form_Element_FilteringSelect('pob');
     $pob->setAttribs(array('dojoType' => $this->filter, 'class' => 'pob', 'class' => 'fullside'));
     $pob->setMultiOptions($opt);
     $_email = new Zend_Dojo_Form_Element_TextBox('email');
     $_email->setAttribs(array('dojoType' => $this->text, 'class' => 'fullside'));
     $_degree = new Zend_Dojo_Form_Element_FilteringSelect('degree');
     $_degree->setAttribs(array('dojoType' => $this->filter, 'class' => 'fullside'));
     $_note = new Zend_Dojo_Form_Element_TextBox('note');
     $_note->setAttribs(array('dojoType' => 'dijit.form.TextBox', 'class' => 'fullside'));
     $_degree = new Zend_Dojo_Form_Element_FilteringSelect('degree');
     $_degree->setAttribs(array('dojoType' => $this->filter, 'class' => 'fullside'));
     $degree_opt = $db->getAllDegree();
     $_degree->setMultiOptions($degree_opt);
     $_photo = new Zend_Form_Element_File('photo');
     $_status = new Zend_Dojo_Form_Element_FilteringSelect('status');
     $_status->setAttribs(array('dojoType' => $this->filter, 'class' => 'fullside'));
     $_status_opt = array(1 => $this->tr->translate("ACTIVE"), 0 => $this->tr->translate("DACTIVE"));
     $_status->setMultiOptions($_status_opt);
     $_submit = new Zend_Dojo_Form_Element_SubmitButton('submit');
     $_submit->setLabel("save");
     $id = new Zend_Form_Element_Hidden('id');
     if (!empty($_data)) {
         $id->setValue($_data['id']);
         $code->setValue($_data['teacher_code']);
         $_enname->setValue($_data['teacher_name_en']);
         $_khname->setValue($_data['teacher_name_kh']);
         $sex->setValue($_data['sex']);
         $phone->setValue($_data['phone']);
         $pob->setValue($_data['pob']);
         $dob->setValue($_data['dob']);
         $_adress->setValue($_data['address']);
         $_email->setValue($_data['email']);
         $_degree->setValue($_data['degree']);
         $_note->setValue($_data['note']);
         $_status->setValue($_data['status']);
     }
     $this->addElements(array($id, $_enname, $_note, $_khname, $pob, $code, $phone, $sex, $dob, $_adress, $_email, $_degree, $_photo, $_status, $_submit));
     return $this;
 }

 public function FrmAddCO($_data = null)
 {
     $request = Zend_Controller_Front::getInstance()->getRequest();
     $_title = new Zend_Dojo_Form_Element_TextBox('adv_search');
     $_title->setAttribs(array('dojoType' => $this->tvalidate, 'onkeyup' => 'this.submit()', 'placeholder' => $this->tr->translate("SEARCH_STAFF_INFO")));
     $_title->setValue($request->getParam("adv_search"));
     $_status_search = new Zend_Dojo_Form_Element_FilteringSelect('status_search');
     $_status_search->setAttribs(array('dojoType' => $this->filter));
     $_status_opt = array(-1 => $this->tr->translate("ALL"), 1 => $this->tr->translate("ACTIVE"), 0 => $this->tr->translate("DACTIVE"));
     $_status_search->setMultiOptions($_status_opt);
     $_status_search->setValue($request->getParam("status_search"));
     $_btn_search = new Zend_Dojo_Form_Element_SubmitButton('btn_search');
     $_btn_search->setAttribs(array('dojoType' => 'dijit.form.Button', 'iconclass' => 'dijitIconSearch'));
     $_co_id = new Zend_Dojo_Form_Element_TextBox('co_id');
     $_co_id->setAttribs(array('dojoType' => $this->tvalidate, 'required' => 'true', 'class' => 'fullside'));
     $_branch_id = new Zend_Dojo_Form_Element_FilteringSelect('branch_id');
     $_branch_id->setAttribs(array('dojoType' => 'dijit.form.FilteringSelect', 'class' => 'fullside', 'required' => 'true'));
     $db = new Application_Model_DbTable_DbGlobal();
     $rows = $db->getAllBranchName();
     $options = '';
     if (!empty($rows)) {
         foreach ($rows as $row) {
             $options[$row['br_id']] = $row['branch_namekh'];
         }
     }
     $_branch_id->setMultiOptions($options);
     $_name_kh = new Zend_Dojo_Form_Element_TextBox('name_kh');
     $_name_kh->setAttribs(array('dojoType' => $this->tvalidate, 'required' => 'true', 'class' => 'fullside'));
     $_enname = new Zend_Dojo_Form_Element_TextBox('first_name');
     $_enname->setAttribs(array('dojoType' => $this->tvalidate, 'required' => 'true', 'class' => 'fullside'));
     $_lname = new Zend_Dojo_Form_Element_TextBox('last_name');
     $_lname->setAttribs(array('dojoType' => $this->text, 'class' => 'fullside'));
     $_sex = new Zend_Dojo_Form_Element_FilteringSelect('co_sex');
     $_sex->setAttribs(array('dojoType' => 'dijit.form.FilteringSelect', 'class' => 'fullside'));
     $opt = array(1 => "Male", 2 => "Femail");
     $_sex->setMultiOptions($opt);
     $_tel = new Zend_Dojo_Form_Element_TextBox('tel');
     $_tel->setAttribs(array('dojoType' => $this->tvalidate, 'class' => 'fullside'));
     $_position = new Zend_Dojo_Form_Element_FilteringSelect('position');
     $_position->setAttribs(array('dojoType' => $this->filter, 'required' => 'true', 'class' => 'fullside'));
     $db = new Application_Model_DbTable_DbGlobal();
     $opt = $db->getAllStaffPosition(null, 1);
     $_position->setMultiOptions($opt);
     $_department = new Zend_Dojo_Form_Element_FilteringSelect('department_id');
     $_department->setAttribs(array('dojoType' => $this->filter, 'required' => 'true', 'class' => 'fullside', 'OnChange' => 'popupDepartment()'));
     $db = new Application_Model_DbTable_DbGlobal();
     $opt = $db->getAllDepartment(null, 1);
     $_department->setMultiOptions($opt);
     $_figer_print_id = new Zend_Dojo_Form_Element_TextBox('figer_print_id');
     $_figer_print_id->setAttribs(array('dojoType' => 'dijit.form.TextBox', 'class' => 'fullside'));
     $_email = new Zend_Dojo_Form_Element_ValidationTextBox('email');
     $_email->setAttribs(array('dojoType' => 'dijit.form.ValidationTextBox', 'class' => 'fullside'));
     // 		$pattern="/^[a-zA-Z]+[a-zA-Z0-9]*@[a-zA-Z]+[a-zA-Z0-9][a-zA-Z]{2,4}([a-zA-Z]{2,4})?$/";
     // 		if(preg_match($pattern,$_email));
     $_national_id = new Zend_Dojo_Form_Element_TextBox('national_id');
     $_national_id->setAttribs(array('dojoType' => 'dijit.form.NumberTextBox', 'class' => 'fullside'));
     $_address = new Zend_Dojo_Form_Element_TextBox('address');
     $_address->setAttribs(array('dojoType' => $this->text, 'class' => 'fullside'));
     $_pob = new Zend_Dojo_Form_Element_TextBox('pob');
     $_pob->setAttribs(array('dojoType' => $this->text, 'class' => 'fullside'));
     $_status = new Zend_Dojo_Form_Element_FilteringSelect('status');
     $_status->setAttribs(array('dojoType' => $this->filter, 'class' => 'fullside'));
     $_status_opt = array(1 => $this->tr->translate("ACTIVE"), 0 => $this->tr->translate("DACTIVE"));
     $_status->setMultiOptions($_status_opt);
     $_display = new Zend_Dojo_Form_Element_FilteringSelect('display');
     $_display->setAttribs(array('dojoType' => $this->filter, 'class' => 'fullside'));
     $_display_opt = array(1 => $this->tr->translate("NAME_KHMER"), 2 => $this->tr->translate("NAME_ENGLISH"));
     $_display->setMultiOptions($_display_opt);
     $_degree = new Zend_Dojo_Form_Element_FilteringSelect('degree');
     $_degree->setAttribs(array('dojoType' => $this->filter, 'class' => 'fullside'));
     $degree_opt = $db->getAllDegree();
     $_degree->setMultiOptions($degree_opt);
     $_degree->setValue($request->getParam('degree'));
     $_basic_salary = new Zend_Dojo_Form_Element_NumberTextBox('basic_salary');
     $_basic_salary->setAttribs(array('dojoType' => 'dijit.form.NumberTextBox', 'class' => 'fullside', 'required' => true));
     $_start_work = new Zend_Dojo_Form_Element_DateTextBox('start_date');
     $_start_work->setAttribs(array('dojoType' => 'dijit.form.DateTextBox', 'class' => 'fullside', 'onchange' => 'calculateDay();'));
     $_start_work->setValue(date('Y-m-d'));
     $_end_work = new Zend_Dojo_Form_Element_DateTextBox('end_date');
     $_end_work->setAttribs(array('dojoType' => 'dijit.form.DateTextBox', 'class' => 'fullside'));
     $_photo = new Zend_Form_Element_File('photo');
     $_end_work->setValue(date('Y-m-d'));
     $_contract = new Zend_Dojo_Form_Element_TextBox('contract_no');
     $_contract->setAttribs(array('dojoType' => 'dijit.form.TextBox', 'class' => 'fullside'));
     $_note = new Zend_Dojo_Form_Element_TextBox('note');
     $_note->setAttribs(array('dojoType' => 'dijit.form.TextBox', 'class' => 'fullside'));
     $opt_shift = array(1 => 'ពេញម៉ោង', 2 => 'ក្រៅម៉ោង');
     $_shift = new Zend_Dojo_Form_Element_FilteringSelect('shift');
     $_shift->setAttribs(array('dojoType' => 'dijit.form.FilteringSelect', 'class' => 'fullside', 'onchange' => 'Checktime(2)'));
     $_shift->setMultiOptions($opt_shift);
     $opt_workingtime = array(1 => 'ពេលព្រឹក និង ពេលល្ងាច​', 2 => 'ពេលព្រឹក', 3 => 'ពេលល្ងាច');
     $_workingtime = new Zend_Dojo_Form_Element_FilteringSelect('workingtime');
     $_workingtime->setAttribs(array('dojoType' => 'dijit.form.FilteringSelect', 'class' => 'fullside', 'onchange' => 'Checktime(1)'));
     $_workingtime->setMultiOptions($opt_workingtime);
     $_annual_lives = new Zend_Dojo_Form_Element_NumberTextBox('annual_lives');
     $_annual_lives->setAttribs(array('dojoType' => 'dijit.form.NumberTextBox', 'class' => 'fullside'));
     $_id = new Zend_Form_Element_Hidden('id');
     if (!empty($_data)) {
         $_co_id->setValue($_data['co_code']);
         $_name_kh->setValue($_data['co_khname']);
//.........这里部分代码省略.........

 function editAction()
 {
     $db = new Global_Model_DbTable_DbGroup();
     if ($this->getRequest()->isPost()) {
         try {
             $data = $this->getRequest()->getPost();
             $db->AddNewGroup($data);
             if (!empty($data['save_close'])) {
                 Application_Form_FrmMessage::Sucessfull("ការ​បញ្ចូល​ជោគ​ជ័យ !", '/global/group');
             }
             Application_Form_FrmMessage::message("ការ​បញ្ចូល​ជោគ​ជ័យ !");
         } catch (Exception $e) {
             Application_Form_FrmMessage::message("ការ​បញ្ចូល​មិន​ជោគ​ជ័យ");
             $err = $e->getMessage();
             Application_Model_DbTable_DbUserLog::writeMessageError($err);
         }
     }
     $id = $this->getRequest()->getParam("id");
     $this->view->row = $db->getGroupById($id);
     $db = new Application_Model_DbTable_DbGlobal();
     $this->view->degree = $db->getAllDegree();
     $faculty = $db->getAllMajor();
     array_unshift($faculty, array('id' => -1, 'name' => 'Add New'));
     $this->view->faculty = $faculty;
     $room = $db->getAllRoom();
     array_unshift($room, array('id' => -1, 'name' => 'Add New'));
     $this->view->room = $room;
     $db = new Application_Model_GlobalClass();
     $this->view->subject_opt = $db->getTeachersunjectOption();
     $tsub = new Global_Form_FrmTeacher();
     $frm_techer = $tsub->FrmTecher();
     Application_Model_Decorator::removeAllDecorator($frm_techer);
     $this->view->frm_techer = $frm_techer;
 }

 public function frmSearchTutionFee($_data = null)
 {
     $request = Zend_Controller_Front::getInstance()->getRequest();
     $_title = new Zend_Dojo_Form_Element_TextBox('fee_code');
     $_title->setAttribs(array('dojoType' => $this->text, 'placeholder' => $this->tr->translate("SEARCH_BY_CODE")));
     $_title->setValue($request->getParam('title'));
     $_batch = new Zend_Dojo_Form_Element_TextBox('batch');
     $_batch->setAttribs(array('dojoType' => $this->text, 'placeholder' => $this->tr->translate("SEARCH_BY_BATCH")));
     $_batch->setValue($request->getParam('title'));
     $_status = new Zend_Dojo_Form_Element_FilteringSelect('status_search');
     $_status->setAttribs(array('dojoType' => $this->filter));
     $_status_opt = array(-1 => $this->tr->translate("ALL_STATUS"), 1 => $this->tr->translate("ACTIVE"), 0 => $this->tr->translate("DACTIVE"));
     $_status->setMultiOptions($_status_opt);
     $_status->setValue($request->getParam("status_search"));
     $db = new Application_Model_DbTable_DbGlobal();
     $rows = $db->getAllFecultyName();
     $opt = array(-1 => $this->tr->translate("CHOOSE"));
     if (!empty($rows)) {
         foreach ($rows as $row) {
             $opt[$row['dept_id']] = $row['en_name'];
         }
     }
     $_faculty = new Zend_Dojo_Form_Element_FilteringSelect('faculty');
     $_faculty->setAttribs(array('dojoType' => $this->filter));
     $_faculty->setMultiOptions($opt);
     $_faculty->setValue($request->getParam("faculty"));
     $row = $db->getAllDegree();
     //$row=array(-1=>$this->tr->translate("CHOOSE"));
     $_degree = new Zend_Dojo_Form_Element_FilteringSelect('degree');
     $_degree->setAttribs(array('dojoType' => $this->filter));
     $_degree->setMultiOptions($row);
     $row = $db->getAllMention();
     array_unshift($row, array(-1 => $this->tr->translate("CHOOSE")));
     $_metion = new Zend_Dojo_Form_Element_FilteringSelect('metion');
     $_metion->setAttribs(array('dojoType' => $this->filter));
     $_metion->setMultiOptions($row);
     $this->addElements(array($_degree, $_batch, $_faculty, $_title, $_status, $_metion));
     if (!empty($_data)) {
     }
     return $this;
 }

 public function getImgActive($rows, $base_url, $case = '', $degree = null, $display = null)
 {
     if ($rows) {
         $imgnone = '<img src="' . $base_url . '/images/icon/cross.png"/>';
         $imgtick = '<img src="' . $base_url . '/images/icon/apply2.png"/>';
         foreach ($rows as $i => $row) {
             if ($degree != null) {
                 $dg = new Application_Model_DbTable_DbGlobal();
                 $rows[$i]['degree'] = $dg->getAllDegree($row['degree']);
             }
             if ($row['status'] == 1) {
                 $rows[$i]['status'] = $imgtick;
             } else {
                 $rows[$i]['status'] = $imgnone;
             }
         }
     }
     return $rows;
 }