Software: Apache/2.2.3 (CentOS). PHP/5.1.6 uname -a: Linux mx-ll-110-164-51-230.static.3bb.co.th 2.6.18-194.el5PAE #1 SMP Fri Apr 2 15:37:44 uid=48(apache) gid=48(apache) groups=48(apache) Safe-mode: OFF (not secure) /var/www/html/mis/ drwxr-xr-x |
Viewing file: regist-26-02-2562.tar (82 KB) -rw-r--r-- Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) | application/ 0040777 0000000 0000000 00000000000 13435160343 010321 5 ustar 00 application/controllers/ 0040777 0000000 0000000 00000000000 13421311510 012654 5 ustar 00 application/controllers/eregis/ 0040777 0000000 0000000 00000000000 13435160254 014146 5 ustar 00 application/controllers/eregis/rpt_regis.php 0100777 0000000 0000000 00000077237 13435155122 016673 0 ustar 00 <?php include('rg_controller.php'); class Rpt_regis extends Rg_controller { // function __construct() { // parent::__construct(); // } //Rep106----------------------------------------------------------------------------- public function searchRptRis106() { $this->load->model($this->config->item("rg_folder").'mo_rg_term','tm'); $this->load->model($this->config->item("rg_folder").'mo_rg_studyyear','sy'); $tm = $this->tm; $tmOrder = array('tmId' => 'ASC'); $ord_rs_sy = array('syId' => ''); $this->contents['rs_tm'] = $tm->get_options('',$tmOrder,'',''); $this->contents['rs_sy'] = $this->sy->get_options('',$ord_rs_sy,'','N'); $this->contents['tmId'] = $this->session->userdata('tmId'); $this->contents['acY'] = $this->session->userdata('acY'); $this->output($this->config->item("rg_folder")."v_searchRptRis106"); } function cur_popup($id=0) { //popup course and year searchRptRis106 $this->load->model($this->config->item("rg_folder").'mo_rg_curriculum','cur'); $this->load->model($this->config->item("rg_folder").'mo_rg_student','std'); $this->contents['qu_cur'] = $this->cur->get_by_key($id); $this->contents['rs_std'] = $this->std->qryByGenStatusGroupCurIdAndAdY('Y'); $this->output_detail($this->config->item("rg_folder")."v_curAndAdYTable"); } public function showRptRis106() { $this->load->library('form_validation'); $this->form_validation->set_error_delimiters('<div class="error">','</div>'); $this->form_validation->set_rules('curId', ' ', 'trim|required|callback_checkselect');//รหัสหลักสูตร $this->form_validation->set_rules('curName', ' ', '');//ชื่อหลักสูตร $this->form_validation->set_rules('adY', ' ', 'trim|integer|callback_checkAdY|xss_clean');//ปีการศึกษาที่เข้า $this->form_validation->set_rules('acY', ' ', 'trim|integer|callback_checkAcY|xss_clean');//ปีการศึกษา $this->form_validation->set_rules('tmId', ' ', 'callback_checkselect');//ภาคการศึกษา $this->form_validation->set_rules('studentYear',' ','callback_checkselect');//ชั้นปี if($this->form_validation->run() == true) { $curId = $this->input->post('curId'); $curName = $this->input->post('curName'); $adY = $this->input->post('adY'); $acY = $this->input->post('acY'); $tmId = $this->input->post('tmId'); $studentYear = $this->input->post('studentYear'); $tmIdAdmit = $this->input->post('tmIdAdmit'); $syId = $this->input->post('syId'); $this->contents['curId'] = $curId; $this->contents['curName'] = $curName; $this->contents['adY'] = $adY; $this->contents['acY'] = $acY; $this->contents['tmId'] = $tmId; $this->contents['studentYear'] = $studentYear; $this->contents['tmIdAdmit'] = $tmIdAdmit; $this->contents['syId'] = $syId; $this->load->model($this->config->item("rg_folder").'mo_rg_curriculum','cur'); $this->load->model($this->config->item("rg_folder").'mo_rg_student','std'); $this->load->model($this->config->item("rg_folder").'mo_rg_prefix','pre'); $this->load->model($this->config->item("rg_folder").'mo_rg_registfee','reg'); $this->load->model($this->config->item("rg_folder").'mo_rg_payment','pay'); $cur = $this->cur; $std = $this->std; $pre = $this->pre; $reg = $this->reg; $pay = $this->pay; $curCon = array('curId' => $curId); $this->contents['qu_cur'] = $cur->qryCur($curCon,'',''); $stdCon = array('stdCurId' => $curId , 'stdAdY' => $adY); $stdOrder = array('stdCode' => ''); $this->contents['rs_std'] = $std->qryStdJoinPf($stdCon,$stdOrder,''); $this->contents['reg'] = $reg; $this->contents['pay'] = $pay; $this->output($this->config->item("rg_folder")."v_rptRis106"); } else { $this->searchRptRis106(); } } public function printRepRis106($stdId,$acY,$studentYear,$tmId,$curId) { $this->load->model($this->config->item("rg_folder").'mo_rg_student','std'); $this->load->model($this->config->item("rg_folder").'mo_rg_registfee','reg'); $this->load->model($this->config->item("rg_folder").'mo_rg_registdetails','rgd'); $this->load->model($this->config->item("rg_folder").'mo_rg_commonfee','cmf'); $this->load->model($this->config->item("rg_folder").'mo_rg_curriculumfee','cf'); $this->load->model($this->config->item("rg_folder").'mo_rg_coursefee','crf'); $this->load->model($this->config->item("rg_folder").'mo_rg_schedule','sd'); $this->load->model($this->config->item("rg_folder").'mo_rg_curriculum','cur'); $std = $this->std; $reg = $this->reg; $rgd = $this->rgd; $cmf = $this->cmf; $cf = $this->cf; $crf = $this->crf; $sd = $this->sd; $cur = $this->cur; $stdCon = array('stdId' => $stdId); $this->contents['qu_std'] = $std->qryStdJoinPfCurGen($stdCon,'',''); $regCon = array('rfStdId' => $stdId , 'rfAcY' => $acY , 'rfTmId' => $tmId); $this->contents['qu_reg'] = $reg->qryRf($regCon,'',''); $this->contents['rs_rgd'] = $rgd->getRegistDetailsByStdIdAcYTmId($stdId, $acY, $tmId); $cmfCon = array('cmfStdId' => $stdId, 'cmfAcY' => $acY , 'cmfTmId' => $tmId); $this->contents['rs_cmf'] = $cmf->qryCmfJoinFee($cmfCon,'',''); $cfCon = array('cfStdId' => $stdId, 'cfAcY' => $acY , 'cfTmId' => $tmId); $this->contents['rs_cf'] = $cf->qryCfJoinFee($cfCon,'',''); $curCon = array('curId' => $curId); $this->contents['qu_cur'] = $cur->qryCur($curCon,'',''); $this->contents['stdId'] = $stdId; $this->contents['acY'] = $acY; $this->contents['tmId'] = $tmId; $this->contents['studentYear'] = $studentYear; $crfCon = array('crfStdId' => $stdId , 'crfAcY' => $acY , 'crfTmId' => $tmId); $this->contents['sumLcFee'] = $crf->GetSumcrfLecFeeAmtCourseFee($crfCon,''); $this->contents['sumLbFee'] = $crf->GetSumcrfLabFeeAmtCourseFee($crfCon,''); $rgdCon = array('rdStdId' => $stdId , 'rdAcY' => $acY , 'rdTmId' => $tmId); $this->contents['sumRdCredit1'] = $rgd->getSumCr1($rgdCon,''); $this->contents['sumRdCredit2'] = $rgd->getSumCr2($rgdCon,''); $this->contents['sumRdCreditAttempt'] = $rgd->getCreditAttempt($rgdCon,''); $this->contents['sumKssFee'] = $crf->GetSumcrfKssFeeAmtCourseFee($crfCon,'',''); $regCon = array('rfStdId' => $stdId , 'rfAcY' => $acY , 'rfSyId' => $studentYear , 'rfTmId' => $tmId); $this->contents['sumTotalAmt'] = $reg->getSumTotalAmt($regCon,''); $sdCon = array('sdAcY' => $acY , 'sdTmId' => $tmId); $this->contents['qu_sd'] = $sd->qrySd($sdCon,'',''); $this->output_detail($this->config->item("rg_folder")."v_rptRis106popup"); } public function printRepRis106PDF($stdId='', $acY='' ,$studentYear='', $tmId='', $curId='') { $this->load->model($this->config->item("rg_folder").'mo_rg_student','std'); $this->load->model($this->config->item("rg_folder").'mo_rg_registfee','reg'); $this->load->model($this->config->item("rg_folder").'mo_rg_registdetails','rgd'); $this->load->model($this->config->item("rg_folder").'mo_rg_commonfee','cmf'); $this->load->model($this->config->item("rg_folder").'mo_rg_curriculumfee','cf'); $this->load->model($this->config->item("rg_folder").'mo_rg_coursefee','crf'); $this->load->model($this->config->item("rg_folder").'mo_rg_schedule','sd'); $this->load->model($this->config->item("rg_folder").'mo_rg_curriculum','cur'); $std = $this->std; $reg = $this->reg; $rgd = $this->rgd; $cmf = $this->cmf; $cf = $this->cf; $crf = $this->crf; $sd = $this->sd; $cur = $this->cur; $stdId = $this->input->post('stdId') ? $this->input->post('stdId') : $stdId; $acY = $this->input->post('acY') ? $this->input->post('acY') : $acY; $studentYear = $this->input->post('syId') ? $this->input->post('syId') : $studentYear; $tmId = $this->input->post('tmId') ? $this->input->post('tmId') : $tmId; $curId = $this->input->post('curId') ? $this->input->post('curId') : $curId; $stdCon = array('stdId' => $stdId); $this->contents['qu_std'] = $std->qryStdJoinPfCurGen($stdCon); $regCon = array('rfStdId' => $stdId , 'rfAcY' => $acY , 'rfTmId' => $tmId); $this->contents['qu_reg'] = $reg->qryRf($regCon); $this->contents['rs_rgd'] = $rgd->getRegistDetailsByStdIdAcYTmId($stdId, $acY, $tmId); $cmfCon = array('cmfStdId' => $stdId, 'cmfAcY' => $acY , 'cmfTmId' => $tmId); $this->contents['rs_cmf'] = $cmf->qryCmfJoinFee($cmfCon,'',''); $cfCon = array('cfStdId' => $stdId, 'cfAcY' => $acY , 'cfTmId' => $tmId); $this->contents['rs_cf'] = $cf->qryCfJoinFee($cfCon,'',''); $this->contents['stdId'] = $stdId; $this->contents['acY'] = $acY; $this->contents['tmId'] = $tmId; $this->contents['studentYear'] = $studentYear; $curCon = array('curId' => $curId); $this->contents['qu_cur'] = $cur->qryCur($curCon,'',''); $crfCon = array('crfStdId' => $stdId , 'crfAcY' => $acY , 'crfTmId' => $tmId); $this->contents['sumLcFee'] = $crf->GetSumcrfLecFeeAmtCourseFee($crfCon,''); $this->contents['sumLbFee'] = $crf->GetSumcrfLabFeeAmtCourseFee($crfCon,''); $rgdCon = array('rdStdId' => $stdId , 'rdAcY' => $acY , 'rdTmId' => $tmId); $this->contents['sumRdCredit1'] = $rgd->getSumCr1($rgdCon,''); $this->contents['sumRdCredit2'] = $rgd->getSumCr2($rgdCon,''); $this->contents['sumRdCreditAttempt'] = $rgd->getCreditAttempt($rgdCon,''); $this->contents['sumKssFee'] = $crf->GetSumcrfKssFeeAmtCourseFee($crfCon,'',''); $regCon = array('rfStdId' => $stdId , 'rfAcY' => $acY , 'rfSyId' => $studentYear , 'rfTmId' => $tmId); $this->contents['sumTotalAmt'] = $reg->getSumTotalAmt($regCon,''); $sdCon = array('sdAcY' => $acY , 'sdTmId' => $tmId); $this->contents['qu_sd'] = $sd->qrySd($sdCon,'',''); $this->output_detail($this->config->item("rg_folder")."v_rptRis106PDF"); } //Rep109----------------------------------------------------------------------------- public function searchRptRis109() { $this->load->model($this->config->item("rg_folder").'mo_rg_term','tm'); $tm = $this->tm; $ord_rs_tm = array('tmId' => ''); $this->contents['rs_tm'] = $tm->get_options('',$ord_rs_tm,'','N'); $this->contents['tmId'] = $this->session->userdata('tmId'); $this->contents['acY'] = $this->session->userdata('acY'); $this->output($this->config->item("rg_folder")."v_searchRptRis109"); } public function showRptRis109() { $this->load->library('form_validation'); $this->form_validation->set_error_delimiters('<div class="error">','</div>'); $this->form_validation->set_rules('acY', ' ', 'trim|integer|callback_checkAdY|xss_clean'); $this->form_validation->set_rules('tmId', ' ', 'callback_checkselect'); $this->form_validation->set_rules('courseCode', ' ', 'trim|required|xss_clean'); $this->form_validation->set_rules('section', ' ', 'trim|required|integer|xss_clean'); //echo $this->form_validation->run(); if($this->form_validation->run() == true) { $this->load->model($this->config->item("rg_folder").'mo_rg_courseopen','co'); $this->load->model($this->config->item("rg_folder").'mo_rg_courseopenfor','cof'); $this->load->model($this->config->item("rg_folder").'mo_rg_curriculum','cur'); $this->load->model($this->config->item("rg_folder").'mo_rg_timetable','ttb'); $co = $this->co; $cof = $this->cof; $cur = $this->cur; $ttb = $this->ttb; $acY = $this->input->post('acY'); $tmId = $this->input->post('tmId'); $courseCode = $this->input->post('courseCode'); $section = $this->input->post('section'); $this->contents['acY'] = $acY; $this->contents['tmId'] = $tmId; $this->contents['courseCode'] = $courseCode; $this->contents['section'] = $section; $this->contents['rs_co'] = $co->qryCoANDCrsByCourseCodeAndAcYAndTmIdAndSec($courseCode,$acY,$tmId,$section); $this->contents['cof'] = $cof; $this->contents['ttb'] = $ttb; $this->contents['cur'] = $cur; $this->output($this->config->item("rg_folder")."v_rptRis109"); }else{ $this->searchRptRis109(); } } public function RptRis109($coId,$acY,$tmId,$coCurId,$ep) { $this->load->model($this->config->item("rg_folder").'mo_rg_courseopen','co'); $this->load->model($this->config->item("rg_folder").'mo_rg_period','prd'); $this->load->model($this->config->item("rg_folder").'mo_rg_examschedule','es'); $this->load->model($this->config->item("rg_folder").'mo_rg_registdetails','rd'); $this->contents['acY'] = $acY; $this->contents['tmId'] = $tmId; $this->contents['coCurId'] = $coCurId; $this->contents['qu_co'] = $this->co->qryForRis109($coId); $this->contents['prd'] = $this->prd; $this->contents['es'] = $this->es; $rdCon = array('rdCoId' => $coId); $rdOrd = array('stdCode' => 'ASC'); $this->contents['rs_rd'] = $this->rd->qrySstOfStd($rdCon, $rdOrd); if($ep=='E') $this->output_detail($this->config->item("rg_folder")."v_rptRis109Excel"); else $this->output_detail($this->config->item("rg_folder")."v_rptRis109PDF"); } //Rep110----------------------------------------------------------------------------- public function searchRptRis110() { //$this->load->model($this->config->item("rg_folder").'mo_rg_term','tm'); //$this->contents['rs_tm'] = $this->tm->qryOrderId(); //$this->contents['qu_tm'] = $this->tm->get_by_key($this->session->userdata('tmId')); $this->load->model($this->config->item("rg_folder").'mo_rg_term','tm'); $tm = $this->tm; $tmOrder = array('tmId' => ''); $this->contents['rs_tm'] = $tm->get_options('',$tmOrder,'',''); $this->contents['tmId'] = $this->session->userdata('tmId'); $this->contents['acY'] = $this->session->userdata('acY'); $this->output($this->config->item("rg_folder")."v_searchRptRis110"); } public function showRptRis110() { $this->load->library('form_validation'); $this->form_validation->set_error_delimiters('<div class="error">','</div>'); $this->form_validation->set_rules('acY', ' ', 'trim|integer|callback_checkAdY|xss_clean'); $this->form_validation->set_rules('courseCode', ' ', 'trim|required|xss_clean'); $this->form_validation->set_rules('section', ' ', 'trim|integer|callback_checkselect|xss_clean'); if($this->form_validation->run() == true) { $this->contents['acY'] = $this->input->post('acY'); $this->contents['tmId'] = $this->input->post('tmId'); $this->contents['courseCode'] = $this->input->post('courseCode'); $this->contents['section'] = $this->input->post('section'); $this->load->model($this->config->item("rg_folder").'mo_rg_courseopen','co'); $this->contents['rs_co'] = $this->co->qryCoANDCrsByCourseCodeAndAcYAndTmIdAndSec($this->input->post('courseCode'),$this->input->post('acY'),$this->input->post('tmId'),$this->input->post('section')); $this->load->model($this->config->item("rg_folder").'mo_rg_courseopenfor','ocof'); $this->contents['cof'] = &$this->ocof; $this->load->model($this->config->item("rg_folder").'mo_rg_curriculum','ocur'); $this->contents['cur'] = &$this->ocur; $this->load->model($this->config->item("rg_folder").'mo_rg_timetable','ott'); $this->contents['tt'] = &$this->ott; $this->output($this->config->item("rg_folder")."v_rptRis110"); }else{ $this->searchRptRis110(); } } public function RptRis110($coId,$acY,$tmId,$coCurId) { $this->load->model($this->config->item("rg_folder").'mo_rg_courseopen','co'); $this->load->model($this->config->item("rg_folder").'mo_rg_period','prd'); $this->load->model($this->config->item("rg_folder").'mo_rg_examschedule','es'); $this->load->model($this->config->item("rg_folder").'mo_rg_registdetails','rd'); $this->load->model($this->config->item("rg_folder").'mo_rg_grade','gd'); $this->load->model($this->config->item("rg_folder").'mo_rg_courseopenfor','cof'); $this->load->model($this->config->item("rg_folder").'mo_rg_studyyear','sy'); $this->load->model($this->config->item("rg_folder").'mo_rg_term','tm'); $this->contents['acY'] = $acY; $this->contents['tmId'] = $tmId; $this->contents['coCurId'] = $coCurId; $this->contents['co'] = $this->co; $this->contents['cof'] = $this->cof; $this->contents['sy'] = $this->sy; $this->contents['tm'] = $this->tm; $this->contents['qu_co'] = $this->co->qryForRis110($coId); $this->contents['prd'] = $this->prd; $this->contents['es'] = $this->es; $rdCon = array('rdCoId' => $coId); $rdOrd = array('stdCode' => 'ASC'); $this->contents['rs_rd'] = $this->rd->qrySstOfStd($rdCon, $rdOrd); $this->contents['rs_gd'] = $this->gd->qryGtpId($this->contents['qu_co']->row()->crsGtpId); $this->output_detail($this->config->item("rg_folder")."v_rptRis110Excel"); } //Rep116----------------------------------------------------------------------------- public function searchRptRis116() { $this->load->model($this->config->item("rg_folder").'mo_rg_term','tm'); $tm = $this->tm; $tmOrder = array('tmId' => ''); $this->contents['rs_tm'] = $tm->get_options('',$tmOrder,'',''); $this->contents['tmId'] = $this->session->userdata('tmId'); $this->contents['acY'] = $this->session->userdata('acY'); $this->output($this->config->item("rg_folder")."v_searchRptRis116"); } public function showRptRis116() { $this->load->library('form_validation'); $this->form_validation->set_error_delimiters('<div class="error">','</div>'); $this->form_validation->set_rules('acY', ' ', 'trim|integer|callback_checkAdY|xss_clean'); $this->form_validation->set_rules('tmId', ' ', 'callback_checkselect'); if($this->form_validation->run() == true) { $this->contents['acY'] = $this->input->post('acY'); $this->contents['tmId'] = $this->input->post('tmId'); $this->load->model($this->config->item("rg_folder").'mo_rg_schedule','sd'); $sd_cond = array('sdAcY' =>$this->contents['acY'], 'sdTmId' => $this->contents['tmId'] ); $this->contents['qu_sd'] = $this->sd->qrySd($sd_cond,"",""); $this->load->model($this->config->item("rg_folder").'mo_rg_period','prd'); $prd_order = array('prdId' => ''); $this->contents['rs_prd'] = $this->prd->qryPrd("",$prd_order,""); $this->load->model($this->config->item("rg_folder").'mo_rg_day','dy'); $dy_order = array('dyId' => ''); $this->contents['rs_dy'] = $this->dy->qryDy("",$dy_order,""); $this->load->model($this->config->item("rg_folder").'mo_rg_courseopen','co'); $this->contents['co'] = $this->co; $this->load->model($this->config->item("rg_folder").'mo_rg_timetable','tt'); $this->contents['tt'] = $this->tt; $this->output_detail($this->config->item("rg_folder")."v_rptRis116"); }else{ $this->searchRptRis116(); } } //Rep117----------------------------------------------------------------------------- public function searchRptRis117() { $this->load->model($this->config->item("rg_folder").'mo_rg_studyyear','sy'); $this->load->model($this->config->item("rg_folder").'mo_rg_term','tm'); $ord_rs_sy = array('syId' => ''); $this->contents['rs_sy'] = $this->sy->get_options('',$ord_rs_sy,'','---เลือกชั้นปี---'); $ord_rs_tm = array('tmId' => ''); $this->contents['rs_tm'] = $this->tm->get_options('',$ord_rs_tm,'',FALSE); $this->contents['tmId'] = $this->session->userdata('tmId'); $this->contents['acY'] = $this->session->userdata('acY'); $this->output($this->config->item("rg_folder")."v_searchRptRis117"); } public function showRptRis117() { $this->load->library('form_validation'); $this->form_validation->set_error_delimiters('<div class="error">','</div>'); $this->form_validation->set_rules('curId', ' ', 'callback_checkselect'); $this->form_validation->set_rules('curName', ' ', ' '); $this->form_validation->set_rules('adY', ' ', 'trim|integer|callback_checkAdY|xss_clean'); $this->form_validation->set_rules('syId',' ','callback_checkselect'); if($this->form_validation->run() == true) { $this->load->model($this->config->item("rg_folder").'mo_rg_schedule','sd'); $this->load->model($this->config->item("rg_folder").'mo_rg_period','prd'); $this->load->model($this->config->item("rg_folder").'mo_rg_day','dy'); $this->load->model($this->config->item("rg_folder").'mo_rg_courseopen','co'); $this->load->model($this->config->item("rg_folder").'mo_rg_timetable','tt'); $this->sd->sdAcY = $this->contents['acadYear'] = $this->input->post('acadYear'); $this->sd->sdTmId = $this->contents['tmId'] = $this->input->post('tmId'); $this->contents['syId'] = $this->input->post('syId'); $this->contents['curName'] = $this->input->post('curName'); $this->contents['curId'] = $this->input->post('curId'); $this->contents['qu_sd'] = $this->sd->get_by_key(); $ord_prd = array('prdId' => 'ASC'); $this->contents['rs_prd'] = $this->prd->qryPrd("",$ord_prd); $ord_dy = array('dyId' => 'ASC'); $this->contents['rs_dy'] = $this->dy->qryDy("",$ord_dy); $this->contents['co'] = $this->co; $this->contents['tt'] = $this->tt; $this->output_detail($this->config->item("rg_folder")."v_rptRis117"); }else{ $this->searchRptRis117(); } } //Rep133----------------------------------------------------------------------------- public function searchRptRis133() { $this->output($this->config->item("rg_folder")."v_searchRptRis133"); } public function showRptRis133() { $this->load->library('form_validation'); $this->form_validation->set_error_delimiters('<div class="error">','</div>'); $this->form_validation->set_rules('curName', ' ', 'trim|xss_clean'); $this->form_validation->set_rules('curId', ' ', 'trim|required|callback_checkselect|xss_clean'); $this->form_validation->set_rules('adY', ' ', 'trim|integer|callback_checkAdY|xss_clean'); if($this->form_validation->run() == true) { $this->load->model($this->config->item("rg_folder").'mo_rg_realstudyplan','rsp'); $this->load->model($this->config->item("rg_folder").'mo_rg_curriculumstructure','cs'); $this->load->model($this->config->item("rg_folder").'mo_rg_studyyear','sy'); $this->load->model($this->config->item("rg_folder").'mo_rg_term','tm'); $this->load->model($this->config->item("rg_folder").'mo_rg_condition','cd'); $this->load->model($this->config->item("rg_folder").'mo_rg_course','crs'); $this->contents['curName'] = $this->input->post('curName'); $this->contents['curId'] = $this->input->post('curId'); $this->contents['adY'] = $this->input->post('adY'); $this->contents['rsp'] = $this->rsp; $this->contents['cs'] = $this->cs; $this->contents['studyyear'] = $this->sy; $this->contents['term'] = $this->tm; $this->contents['condition'] = $this->cd; $this->contents['course'] = $this->crs; $this->output_detail($this->config->item("rg_folder")."v_rptRis133"); }else{ $this->searchRptRis133(); } } public function curAndAdmitYAndGenStatusIsYTable() { return; } public function searchRptRis305() { $this->load->model($this->config->item("rg_folder").'mo_rg_term','tm'); $this->contents['rs_tm'] = $this->tm->get_options('','','',FALSE); $this->contents['tmId'] = $this->session->userdata('tmId'); $this->contents['acY'] = $this->session->userdata('acY'); $this->output($this->config->item("rg_folder")."v_searchRptRis305"); } public function rptRis305PDF() { $this->load->library('form_validation'); $this->form_validation->set_error_delimiters('<div class="error">','</div>'); $this->form_validation->set_rules('levelName', ' ', 'trim|xss_clean'); $this->form_validation->set_rules('divisorType', ' ', 'trim|xss_clean'); $this->form_validation->set_rules('acY', ' ', 'trim|integer|callback_checkAdY|xss_clean'); $this->form_validation->set_rules('tmId', ' ', 'trim|xss_clean'); if($this->form_validation->run() == true) { $this->load->model($this->config->item("rg_folder").'mo_rg_curriculum','cur'); /* กำหนดตัวหารหน่วยกิต */ if($this->input->post('levelName')=='B' && $this->input->post('divisorType')=='S') { $divisor = 18; $sLevelId = 11; $eLevelId = 11; } else if($this->input->post('levelName')=='B' && $this->input->post('divisorType')=='Y') { $divisor = 36; $sLevelId = 11; $eLevelId = 11; } else if($this->input->post('levelName')=='C' && $this->input->post('divisorType')=='S') { $divisor = 19; $sLevelId = 1; $eLevelId = 10; } else if($this->input->post('levelName')=='C' && $this->input->post('divisorType')=='Y') { $divisor = 38; $sLevelId = 1; $eLevelId = 10; } $this->contents['divisor'] = $divisor; $this->contents['sLevelId'] = $sLevelId; $this->contents['eLevelId'] = $eLevelId; $rs_cur = $this->cur->qryCurForFTESJoinCurElvGen($sLevelId, $eLevelId,$this->input->post('acY')); $this->contents['arr'] = $arr = array(); $i = 1; if($rs_cur->num_rows()) { foreach($rs_cur->result() as $row) { $arr[$i]['curId'] = $row->curId; $arr[$i]['curName'] = $row->curName; $arr[$i]['genId'] = $row->genId; $arr[$i]['genNo'] = $row->genNo; if($this->input->post('divisorType') == 'S') { $this->load->model($this->config->item("rg_folder").'mo_rg_registdetails','rd'); $con_sumCredit1 = array('coCurId' => $row->curId, 'coAcY' => $this->input->post('acY'), 'coTmId' => $this->input->post('tmId'), 'stdAdY' => $row->stdAdY); $sumCredit1 = $this->rd->getSumCreditAttempt($con_sumCredit1,'',''); $con_sumCredit2 = array('coAcY' => $this->input->post('acY'), 'coTmId' => $this->input->post('tmId'), 'cofCurId' => $row->curId, 'stdAdY' => $row->stdAdY); $sumCredit2 = $this->rd->getSumCreditAttemptCurIsNULL($con_sumCredit2,'',''); $sum = $sumCredit1+$sumCredit2; $FTES = $sum / $divisor; $arr[$i]['SCH'] = $sum; $arr[$i]['FTES'] = $FTES; $this->contents['arr'] = $arr; } else if($this->input->post('divisorType') == 'Y') { $this->load->model($this->config->item("rg_folder").'mo_rg_registdetails','rd'); $con_sumCredit1 = array('coCurId' => $row->curId, 'coAcY' => $this->input->post('acY'), 'stdAdY' => $row->stdAdY); $sumCredit1 = $this->rd->getSumCreditAttempt($con_sumCredit1,'',''); $con_sumCredit2 = array('coAcY' => $this->input->post('acY'), 'cofCurId' => $row->curId, 'stdAdY' => $row->stdAdY); $sumCredit2 = $this->rd->getSumCreditAttemptCurIsNULL($con_sumCredit2,'',''); $sum = $sumCredit1+$sumCredit2; $FTES = $sum / $divisor; $arr[$i]['SCH'] = $sum; $arr[$i]['FTES'] = $FTES; $this->contents['arr'] = $arr; } $i++; } } $this->contents['acY'] = $this->input->post('acY'); $this->contents['tmId'] = $this->input->post('tmId'); $this->contents['divisorType'] = $this->input->post('divisorType'); $this->output_pdf($this->config->item("rg_folder")."v_rptRis305"); } else { $this->searchRptRis305(); } } /* ##### รายงานรายชื่อนักศึกษาแยกตามรายวิชา #####*/ public function searchRptRis999() { $this->load->model($this->config->item("rg_folder").'mo_rg_term','tm'); $this->load->model($this->config->item("rg_folder").'mo_rg_courseopen','co'); $this->contents['acY'] = ($this->input->post('acY')) ? $this->input->post('acY') : $this->session->userdata('acY'); $this->contents['tmId'] = ($this->input->post('tmId')) ? $this->input->post('tmId') : $this->session->userdata('tmId'); $arr = array(); if($this->input->post('btnSearch')){ $this->load->library('form_validation'); $this->form_validation->set_error_delimiters('<div class="error">','</div>'); $this->form_validation->set_rules('acY', ' ', 'trim|integer|callback_checkAdY|xss_clean'); $this->form_validation->set_rules('tmId', ' ', 'callback_checkselect'); $this->form_validation->set_rules('crsCode', ' ', 'trim|required|xss_clean'); $this->form_validation->set_rules('crsSection', ' ', 'trim|required|integer|xss_clean'); if($this->form_validation->run() == true) { $con_qu_co = array('coAcY' => $this->input->post('acY'), 'coTmId' => $this->input->post('tmId'), 'crsCode' => '%'.$this->input->post('crsCode').'%', 'coSection' => $this->input->post('crsSection')); $rs_gco = $this->co->qryCoJoinCrs($con_qu_co,'',''); $arr = array(); foreach($rs_gco->result() as $gco) { $arr[$gco->crsId] = array('coId' => $gco->coId, 'crsCode' => $gco->crsCode, 'coCrsId' => $gco->crsId, 'crsName' => $gco->crsName); $cond1 = array('crsId' => $gco->crsId, 'coAcY' => $this->input->post('acY'), 'coTmId' => $this->input->post('tmId'), 'coSection' => $this->input->post('crsSection')); $rs_gcur = $this->co->qryCoJoinCrsCur($cond1); $i = 1; foreach($rs_gcur->result() as $gcur) { $this->load->model($this->config->item("rg_folder").'mo_rg_timetable','tt'); $rs_prs = $this->tt->qryTeacher($gcur->coId); $row_rs_prs = $rs_prs->row(); $arr[$gco->crsId]['cur'.$i] = array('curId' => $gcur->curId, 'curName' => $gcur->curName, 'coSection' => $gcur->coSection, 'prsName' => $row_rs_prs->prsName); $i++; } } } } $this->contents['arr'] = $arr; $this->contents['rs_tm'] = $this->tm->get_options('','','',FALSE); $this->output($this->config->item("rg_folder")."v_showRptRis999"); } public function rptRis999PDF($acY, $tmId, $coId) { $this->load->model($this->config->item("rg_folder").'mo_rg_courseopen','co'); $this->load->model($this->config->item("rg_folder").'mo_rg_course','c'); $this->load->model($this->config->item("rg_folder").'mo_rg_courseopenfor','cof'); $this->load->model($this->config->item("rg_folder").'mo_rg_curriculum','cur'); $this->load->model($this->config->item("rg_folder").'mo_rg_registdetails','rd'); $this->load->model($this->config->item("rg_folder").'mo_rg_grade','grd'); $this->load->model($this->config->item("rg_folder").'mo_rg_person','prs'); $this->co->coId = $coId; $this->co->get_by_key(TRUE); $this->contents['qu_co'] = $this->co; $this->c->crsId = $this->co->coCrsId; $this->c->get_by_key(TRUE); $this->contents['qu_c'] = $this->c; if($this->co->coCurId) { $this->cur->curId = $this->co->coCurId; $this->cur->get_by_key(TRUE); $this->contents['pgNames'] = $this->cur->curName; $curElvId = $this->cur->curElvId; } else { $cond = array('cofCoId' => $coId); $rs_cof = $this->cof->qryCofJoinCur($cond); $k = 1; $pgNames = ''; $curElvId = ''; foreach($rs_cof->result() as $row) { $this->cur->curId = $row->cofCurId; $this->cur->get_by_key(TRUE); if($k == 0) { $pgNames = $row->curName; } else { $pgNames .= ', '.$row->curName; } $curElvId = $row->curElvId; $k++; } $this->contents['pgNames'] = $pgNames; } $this->contents['acY'] = $acY; $this->contents['tmId'] = $tmId; $this->contents['coId'] = $coId; $this->contents['rs_rd'] = $this->rd->RSEnrollItemByClIdAndStudying($coId); $this->contents['rd'] = $this->rd; $cond2 = array('prsId' => $this->co->coPrsId); $this->contents['qu_prs'] = $this->prs->qryPrsJoinPPC($cond2); $this->output_pdf($this->config->item("rg_folder")."v_rptRis999"); } public function ris999() { return; } /* ##### รายงานรายชื่อนักศึกษาแยกตามรายวิชา #####*/ } ?> |