Viewing file: rpt_student.php (32.09 KB) -rwxr-xr-x Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<?php include('rg_controller.php'); class Rpt_student extends Rg_controller { // function __construct() { // parent::__construct(); // }
//**********************************************************// public function searchRptRis101() { $this->load->model($this->config->item("rg_folder").'mo_rg_curriculum','cur'); $this->load->model($this->config->item("rg_folder").'mo_rg_termconfig','tmc'); $this->load->model($this->config->item("rg_folder").'mo_rg_studyyear','sy'); $this->load->model($this->config->item("rg_folder").'mo_rg_term','tm');
$con_rs_cur = array('curStatus' => 'Y'); $ord_rs_cur = array('curId' => ''); $ord_rs_sy = array('syId' => ''); $ord_rs_tm = array('tmId' => ''); $this->contents['rs_cur'] = $this->cur->get_options($con_rs_cur,$ord_rs_cur); $this->contents['rs_sy'] = $this->sy->get_options('',$ord_rs_sy,'','N'); $this->contents['rs_tm'] = $this->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_searchRptRis101"); }
public function rptRis101() { $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('adY',' ','trim|integer|callback_checkAdY|xss_clean'); $this->form_validation->set_rules('syId', ' ', 'callback_checkSyId'); $this->form_validation->set_rules('acY',' ','trim|integer|callback_checkAcY|xss_clean'); $this->form_validation->set_rules('tmId',' ','');
if($this->form_validation->run() == true) { $this->load->model($this->config->item("rg_folder").'mo_rg_curriculum','cur'); $this->load->model($this->config->item("rg_folder").'mo_rg_commonfeetp','cmft'); $this->load->model($this->config->item("rg_folder").'mo_rg_curriculumfeetp','cft');
$this->contents['acY'] = $this->input->post('acY'); $this->cur->curId = $this->input->post('curId'); $this->contents['qu_cur'] = $this->cur->get_by_key();
// เช็คค่าใช้จ่าย สำหรับปี 2552 if($this->input->post('acY') < $this->config->item('reviseY')) { $adY = '0'; $syId = '0'; } else { $adY = $this->input->post('adY'); $syId = $this->input->post('syId'); }
if($this->input->post('adY') && $this->input->post('syId')){ $con_rs_cmft = array('cmftAdY' => $adY, 'cmftSyId' => $syId, 'cmftAcY' => $this->input->post('acY'), 'cmftTmId' => $this->input->post('tmId')); $this->contents['rs_cmft'] = $this->cmft->qryCmftJoinFee($con_rs_cmft,'','');
$con_rs_cft = array('cftCurId' => $this->input->post('curId'), 'cftAdY' => $adY, 'cftSyId' => $syId, 'cftAcY' => $this->input->post('acY'), 'cftTmId' => $this->input->post('tmId')); $this->contents['rs_cft'] = $this->cft->qryCftJoinFee($con_rs_cft,'',''); }
$this->output_detail($this->config->item("rg_folder")."v_rptRis101"); } else $this->searchRptRis101(); }
public function searchRptRis102() { $this->load->model($this->config->item("rg_folder").'mo_rg_curriculum','cur');
$con_rs_cur = array('curStatus' => 'Y'); $ord_rs_cur = array('curName' => ''); $this->contents['rs_cur'] = $this->cur->get_options($con_rs_cur,$ord_rs_cur,'','');
$this->contents['tmId'] = $this->session->userdata('tmId'); $this->contents['acY'] = $this->session->userdata('acY');
$this->output($this->config->item("rg_folder")."v_searchRptRis102"); }
public function rptRis102() { $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('adY', ' ', 'trim|integer|callback_checkAdY|xss_clean'); if($this->form_validation->run() == true) { $this->load->model($this->config->item("rg_folder").'mo_rg_termconfig','tmc'); $this->load->model($this->config->item("rg_folder").'mo_rg_curriculum','cur'); $this->load->model($this->config->item("rg_folder").'mo_rg_student','std');
/* getNowDate เป็นฟังก์ชั่นเรียกวันที่ปัจจุบัน อยู่ในรูปแบบ 0000-00-00 */ $this->cur->curId = $this->input->post('curId'); $con_rs_std = array('stdCurId' => $this->input->post('curId'), 'stdAdY' => $this->input->post('adY')); $ord_rs_std = array('stdName' => '', 'stdSurname' => ''); $this->contents['qu_tmc'] = $this->tmc->getBetweenDateByNowDate(getNowDate()); $this->contents['qu_cur'] = $this->cur->get_by_key(); $this->contents['rs_std'] = $this->std->qryStdJoinPfSoPrvEt($con_rs_std,$ord_rs_std);
$this->contents['curId'] = $this->input->post('curId'); $this->contents['stdAdY'] = $this->input->post('adY');
$this->output_detail($this->config->item("rg_folder")."v_rptRis102"); } else $this->searchRptRis102(); }
public function rptRis102Export() { $this->load->model($this->config->item("rg_folder").'mo_rg_termconfig','tmc'); $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->cur->curId = $this->input->post('curId'); $con_rs_std = array('stdCurId' => $this->input->post('curId'), 'stdAdY' => $this->input->post('adY')); $ord_rs_std = array('stdName' => '', 'stdSurname' => ''); $this->contents['qu_tmc'] = $this->tmc->getBetweenDateByNowDate(getNowDate()); $this->contents['qu_cur'] = $this->cur->get_by_key(); $this->contents['rs_std'] = $this->std->qryStdJoinPfSoPrvEt($con_rs_std,$ord_rs_std);
if(substr_count(strtolower($this->input->post('exportB')), "excel") > 0){ $this->contents['typeShow'] = "E"; $this->output_detail($this->config->item("rg_folder")."v_rptRis102"); } else { $this->output_pdf($this->config->item("rg_folder")."v_rptRis102PDF"); } }
public function searchRptRis103() { $this->load->model($this->config->item("rg_folder").'mo_rg_curriculum','cur'); $con_rs_cur = array('curStatus' => 'Y'); $ord_rs_cur = array('curName' => ''); $this->contents['rs_cur'] = $this->cur->get_options($con_rs_cur,$ord_rs_cur,'',''); $this->contents['tmId'] = $this->session->userdata('tmId'); $this->contents['acY'] = $this->session->userdata('acY');
$this->output($this->config->item("rg_folder")."v_searchRptRis103"); }
public function rptRis103() { $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('adY', ' ', 'trim|integer|callback_checkAdY|xss_clean'); if($this->form_validation->run() == true) { $this->load->model($this->config->item("rg_folder").'mo_rg_termconfig','tmc'); $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->cur->curId = $this->input->post('curId');
/* ต้องหาที่เด็กชั้นปี 1 ภาคการศึกษาที่ 1 และปีการศึกษาตรงกับปีที่เข้าจากตาราง rg_StudentSummary */ /*$con_rs_std = array('stdCurId' => $this->input->post('curId'), 'stdAdY' => $this->input->post('adY'), 'ssmAcY' => $this->input->post('adY'), 'ssmTmId' => 1, 'ssmSyId' => 1); $ord_rs_std = array('stdCode' => 'ASC'); //$this->contents['rs_std'] = $this->std->qryStdAndSstIdISNot6JoinPfSoPrvEt($con_rs_std,$ord_rs_std,'');*/
$this->contents['qu_tmc'] = $this->tmc->getBetweenDateByNowDate(getNowDate()); $this->contents['qu_cur'] = $this->cur->get_by_key();
$this->contents['rs_std'] = $this->std->qryStdByStdSstIdNotIn5JoinPfSoPrvEt($this->input->post('curId'), $this->input->post('adY'));
$this->contents['curId'] = $this->input->post('curId'); $this->contents['stdAdY'] = $this->input->post('adY');
$this->output_detail($this->config->item("rg_folder")."v_rptRis103"); } else $this->searchRptRis103(); }
public function rptRis103Export() { $this->load->model($this->config->item("rg_folder").'mo_rg_termconfig','tmc'); $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->cur->curId = $this->input->post('curId'); $this->contents['qu_tmc'] = $this->tmc->getBetweenDateByNowDate(getNowDate()); $this->contents['qu_cur'] = $this->cur->get_by_key(); $this->contents['rs_std'] = $this->std->qryStdByStdSstIdNotIn5JoinPfSoPrvEt($this->input->post('curId'), $this->input->post('adY'));
if(substr_count(strtolower($this->input->post('exportB')), "excel") > 0){ $this->contents['typeShow'] = "E"; $this->output_detail($this->config->item("rg_folder")."v_rptRis103"); } else { $this->output_pdf($this->config->item("rg_folder")."v_rptRis103PDF"); } }
public function searchRptRis104() { $this->load->model($this->config->item("rg_folder").'mo_rg_curriculum','cur');
$con_rs_cur = array('curStatus' => 'Y'); $ord_rs_cur = array('curName' => ''); $this->contents['rs_cur'] = $this->cur->get_options($con_rs_cur,$ord_rs_cur,'','');
$this->contents['tmId'] = $this->session->userdata('tmId'); $this->contents['acY'] = $this->session->userdata('acY');
$this->output($this->config->item("rg_folder")."v_searchRptRis104"); }
public function rptRis104() {
$this->load->library('form_validation'); $this->form_validation->set_error_delimiters('<div class="error">','</div>'); $this->form_validation->set_rules('typeSt', '', 'callback_checkselect'); $this->form_validation->set_rules('cardIssuedDate', ' ', 'trim|required|xss_clean'); $this->form_validation->set_rules('directorPos', ' ', 'trim|xss_clean'); if ($this->input->post('typeSt')=="N") { $this->form_validation->set_rules('curId', ' ', 'callback_checkselect'); $this->form_validation->set_rules('adY',' ','trim|integer|callback_checkAdY|xss_clean'); $this->form_validation->set_rules('acY',' ','trim|integer|callback_checkAcY|xss_clean'); } else { $this->form_validation->set_rules('studentCode', ' ', 'trim|required|integer|xss_clean'); $this->form_validation->set_rules('cardExpiryDate', ' ', 'trim|required|xss_clean'); }
if($this->form_validation->run() == true) {
$this->load->model($this->config->item("rg_folder").'mo_rg_student','std');
if($this->input->post('typeSt')=="N" && $this->input->post('adY') && $this->input->post('acY')){ if($this->input->post('curId')) $this->contents['rs_std'] = $this->std->qryByCurIdAndStartAdYAndEndAdYJoinPfSdtCurGen($this->input->post('curId'),$this->input->post('adY'),$this->input->post('acY')); else $this->contents['rs_std'] = $this->std->qryByStartAdYAndEndAdYJoinPfSdtCurGen($this->input->post('adY'),$this->input->post('acY')); }else if($this->input->post('typeSt')=="Y" && $this->input->post('studentCode')){ $this->contents['rs_std'] = $this->std->qryByCodeAndGenStatusIsYJoinPfSdtCurGen($this->input->post('studentCode')); }else $this->contents['errMs'] = "Y";
$this->contents['directorPos'] = $this->input->post('directorPos'); $this->contents['cardIssuedDate'] = $this->input->post('cardIssuedDate'); $this->contents['typeSt'] = $this->input->post('typeSt'); $this->contents['startAdY'] = $this->input->post('adY'); $this->contents['endAdY'] = $this->input->post('acY'); $this->contents['cardExpiryDate'] = $this->input->post('cardExpiryDate'); $this->contents['directorPos'] = ($this->input->post('directorPos')) ? $this->input->post('directorPos') : 'ผู้อำนวยการวิทยาลัย'; $this->contents['studentCode'] = $this->input->post('studentCode');
$this->output_pdf($this->config->item("rg_folder")."v_rptRis104"); } else { $this->searchRptRis104(); } }
public function searchRptRis105() { $this->contents['tmId'] = $this->session->userdata('tmId'); $this->contents['acY'] = $this->session->userdata('acY'); $this->output($this->config->item("rg_folder")."v_searchRptRis105"); }
public function rptRis105() { $this->load->library('form_validation'); $this->form_validation->set_error_delimiters('<div class="error">','</div>'); $this->form_validation->set_rules('stdCode', ' ', 'trim|required|is_natural_no_zero|xss_clean'); if($this->form_validation->run() == true) { $this->load->model($this->config->item("rg_folder").'mo_rg_student','std'); /*$con_qu_std = array('stdCode' => $this->input->post('stdCode'), 'stdGenStatus' => 'Y', 'ssmAcY' => 2549, 'ssmTmId' => 1); $this->contents['qu_std'] = $this->std->qryStdJoinPfSdtCurGen($con_qu_std,'','');*/ $con_qu_std = array('stdCode' => $this->input->post('stdCode'), 'stdGenStatus' => 'Y'); $this->contents['qu_std'] = $this->std->qryStdJoinPfSdtCurGen($con_qu_std);
$this->contents['acY'] = $this->input->post('acY'); $this->contents['tmId'] = $this->input->post('tmId');
$this->output_pdf($this->config->item("rg_folder")."v_rptRis105"); } else { $this->searchRptRis105(); } }
public function searchRptRis107() { $this->contents['tmId'] = $this->session->userdata('tmId'); $this->contents['acY'] = $this->session->userdata('acY'); $this->output($this->config->item("rg_folder")."v_searchRptRis107"); }
public function rptRis107() { $this->load->library('form_validation'); $this->form_validation->set_error_delimiters('<div class="error">','</div>'); $this->form_validation->set_rules('stdCode', ' ', 'trim|required|is_natural_no_zero|xss_clean'); if($this->form_validation->run() == true) {
$this->load->model($this->config->item("rg_folder").'mo_rg_student','std'); $this->load->model($this->config->item("rg_folder").'mo_rg_person','pp'); $this->load->model($this->config->item("rg_folder").'mo_rg_adviser','adv');
$con_qu_std = array('stdCode' => $this->input->post('stdCode')); $this->contents['qu_std'] = $this->std->qryStdJoinPfSdtCurGen($con_qu_std,'',''); $this->contents['acY'] = $this->session->userdata('acY'); $this->contents['tmId'] = $this->session->userdata('tmId'); $this->contents['stdCode'] = $this->session->userdata('stdCode');
if($this->contents['qu_std']->num_rows()) { $std = $this->contents['qu_std']->row();
$stdId = $std->stdId; $acY = $this->session->userdata('acY');
$con_rs_adv = array('advStdId' => $stdId, 'advAcY' => $acY); $this->contents['rs_adv'] = $this->adv->qryAdvJoinPrsList($con_rs_adv); }
//$this->contents['pp'] = $this->pp;
$this->output_pdf($this->config->item("rg_folder")."v_rptRis107"); } else { $this->searchRptRis107(); } }
public function searchRptRis108() { $this->load->model($this->config->item("rg_folder").'mo_rg_studyyear','sy');
$ord_rs_sy = array('syId' => ''); $this->contents['rs_sy'] = $this->sy->get_options('',$ord_rs_sy,'',''); $this->contents['tmId'] = $this->session->userdata('tmId'); $this->contents['acY'] = $this->session->userdata('acY');
$this->output($this->config->item("rg_folder")."v_searchRptRis108"); } public function rptRis108() { $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('syId', ' ', 'callback_checkselect'); $this->form_validation->set_rules('adY', ' ', ''); // หลักสูตร ชั้นปี if($this->form_validation->run() == true) { $this->load->model($this->config->item("rg_folder").'mo_rg_student','std'); $this->load->model($this->config->item("rg_folder").'mo_rg_termconfig','tmc'); $this->load->model($this->config->item("rg_folder").'mo_rg_curriculum','cur'); $this->load->model($this->config->item("rg_folder").'mo_rg_generation','gen');
$this->contents['curId'] = $this->input->post('curId'); $this->contents['stdAdY'] = $this->input->post('adY'); $this->contents['syId'] = $this->input->post('syId');
$this->contents['qu_tmc'] = $this->tmc->getBetweenDateByNowDate(getNowDate());
$con_cur = array('curId' => $this->contents['curId']); $this->contents['qu_cur'] = $this->cur->qryCurJoinOther($con_cur); $con_rs_std = array('stdCurId' => $this->contents['curId'], 'stdSyId' => $this->contents['syId'], 'stdAdY' => $this->contents['stdAdY']); $ord_rs_std = array('stdCode' => ''); $this->contents['rs_std'] = $this->std->qryStdJoinPfSoPrvEt($con_rs_std, $ord_rs_std);
$this->output_detail($this->config->item("rg_folder")."v_rptRis108"); } else { $this->searchRptRis108(); } }
public function rptRis108Export() { $this->load->model($this->config->item("rg_folder").'mo_rg_student','std'); $this->load->model($this->config->item("rg_folder").'mo_rg_termconfig','tmc'); $this->load->model($this->config->item("rg_folder").'mo_rg_curriculum','cur'); $this->load->model($this->config->item("rg_folder").'mo_rg_generation','gen');
$this->contents['curId'] = $this->input->post('curId'); $this->contents['stdAdY'] = $this->input->post('adY'); $this->contents['syId'] = $this->input->post('syId');
$this->contents['qu_tmc'] = $this->tmc->getBetweenDateByNowDate(getNowDate()); $con_cur = array('curId' => $this->contents['curId']); $this->contents['qu_cur'] = $this->cur->qryCurJoinOther($con_cur); $con_rs_std = array('stdCurId' => $this->contents['curId'], 'stdSyId' => $this->contents['syId'], 'stdAdY' => $this->contents['stdAdY']); $ord_rs_std = array('stdCode' => ''); $this->contents['rs_std'] = $this->std->qryStdJoinPfSoPrvEt($con_rs_std, $ord_rs_std); $this->contents['syId'] = $this->input->post('syId');
if(substr_count(strtolower($this->input->post('exportB')), "excel") > 0){ $this->contents['typeShow'] = "E"; $this->output_detail($this->config->item("rg_folder")."v_rptRis108"); } else { $this->output_pdf($this->config->item("rg_folder")."v_rptRis108PDF"); } }
public function curAndAdmitYAndGenStatusIsYTable() {
return; }
public function searchRptRis115() { $this->load->model($this->config->item("rg_folder").'mo_rg_curriculum','cur'); $this->load->model($this->config->item("rg_folder").'mo_rg_student','std');
$con_rs_cur = array('curStatus' => 'Y'); $ord_rs_cur = array('curId' => ''); $this->contents['rs_cur'] = $this->cur->get_options($con_rs_cur,$ord_rs_cur,'','');
$this->contents['tmId'] = $this->session->userdata('tmId'); $this->contents['acY'] = $this->session->userdata('acY');
$this->output($this->config->item("rg_folder")."v_searchRptRis115"); }
public function rptRis115() { $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('adY', ' ', 'trim|integer|callback_checkAdY|xss_clean'); if($this->form_validation->run() == true) { $this->load->model($this->config->item("rg_folder").'mo_rg_curriculum','cur'); $this->load->model($this->config->item("rg_folder").'mo_rg_generation','gen'); $this->load->model($this->config->item("rg_folder").'mo_rg_student','std'); $this->load->model($this->config->item("rg_folder").'mo_rg_district','odt'); $con_gen = array('curId' => $this->input->post('curId'), 'genAcY' => $this->input->post('adY') ); $con_cur = array('curId' => $this->input->post('curId')); $this->contents['qu_gen'] = $this->gen->qryGenJoinCur($con_gen); $this->contents['qu_cur'] = $this->cur->qryCur($con_cur); //echo $this->db->last_query();
$con_std = array('stdCurId' => $this->input->post('curId'), 'stdAdY' => $this->input->post('adY') ); $order_std = array('stdCode' => ''); $this->contents['rs_std'] = $this->std->qryStdByCurId($con_std,$order_std); $this->contents['dt'] = $this->odt; $this->output_detail($this->config->item("rg_folder")."v_rptRis115"); } else { $this->searchRptRis115(); } }
public function searchRptRis129() { $this->load->model($this->config->item("ppc_folder").'mo_spc_place','sp');
$opt[''] = ""; $rs_dm = $this->sp->getdomitory(); if($rs_dm->num_rows()) { foreach($rs_dm->result() as $row_dm) { $opt[$row_dm->plHwId] = $row_dm->hwName;
$this->sp->plBuilding = $row_dm->plHwId; $rs_sp = $this->sp->getDmRm(); foreach ($rs_sp->result() as $row_sp) { $opt[$row_sp->plHwId] = " ".$row_sp->plRmNo; } } } $this->contents['rs_dm'] = $opt;
$this->contents['tmId'] = $this->session->userdata('tmId'); $this->contents['acY'] = $this->session->userdata('acY');
$this->output($this->config->item("rg_folder")."v_searchRptRis129"); }
public function rptRis129() { $this->load->library('form_validation'); $this->form_validation->set_error_delimiters('<div class="error">','</div>'); $this->form_validation->set_rules('plHwId', ' ', 'callback_checkselect'); $this->form_validation->set_rules('acY', ' ', 'trim|integer|callback_checkAdY|xss_clean'); if($this->form_validation->run() == true) { $this->load->model($this->config->item("ppc_folder").'mo_spc_place','pl'); $this->load->model($this->config->item("rg_folder").'mo_rg_studentdomitory','sdm');
$this->pl->plHwId = $this->input->post('plHwId'); $this->pl->get_by_key(TRUE);
$this->contents['qu_dm'] = $this->pl;
$con_sdm = array('sdmAcY' => $this->input->post('acY'), 'sdmDmId' => $this->input->post('plHwId')); $order_sdm = array('stdCode'=> '', 'sdmTmId'=> ''); $this->contents['rs_sdm'] = $this->sdm->qrySdmJnStdCur($con_sdm,$order_sdm); $this->contents['acY'] = $this->input->post('acY');
$this->output_pdf($this->config->item("rg_folder")."v_rptRis129"); } else { $this->searchRptRis129(); } }
public function searchRptRis130() { $this->load->model($this->config->item("rg_folder").'mo_rg_term','tm'); $this->load->model($this->config->item("rg_folder").'mo_rg_curriculum','cur');
$con_rs_cur = array('curStatus' => 'Y'); $ord_rs_cur = array('curId' => ''); $this->contents['rs_cur'] = $this->cur->get_options($con_rs_cur,$ord_rs_cur);
$this->contents['rs_tm'] = $this->tm->get_options("","","","");
$this->contents['tmId'] = $this->session->userdata('tmId'); $this->contents['acY'] = $this->session->userdata('acY');
$this->output($this->config->item("rg_folder")."v_searchRptRis130"); }
public function rptRis130() { $this->load->library('form_validation'); $this->form_validation->set_error_delimiters('<div class="error">','</div>'); $this->form_validation->set_rules('curId', ' ', 'trim|required|xss_clean'); $this->form_validation->set_rules('curName', ' ', 'trim|xss_clean'); $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('tmIdAdmit', ' ', 'trim|xss_clean'); //$this->form_validation->set_rules('syId', ' ', 'trim|xss_clean'); $this->form_validation->set_rules('adY', ' ', 'trim|required|xss_clean'); if($this->form_validation->run() == true) { $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['acY'] = $this->input->post('acY'); $this->contents['tmId'] = $this->input->post('tmId'); $this->contents['curId'] = $this->input->post('curId'); $this->contents['adY'] = $this->input->post('adY');
$this->cur->curId = $this->contents['curId']; $this->cur->get_by_key(TRUE); $this->contents['qu_cur'] = $this->cur; $this->contents['rs_std'] = $this->std->qryByCurIdAndAdYAndSbeAcYAndSbeTmIdGroupIdOrderCodeJoinPfSbe($this->contents['curId'],$this->contents['acY'],$this->contents['tmId'],$this->contents['adY']);
$this->output_pdf($this->config->item("rg_folder")."v_rptRis130"); } else { $this->searchRptRis130(); } }
public function searchRptRis() { $this->load->model($this->config->item("rg_folder").'mo_rg_curriculum','cur'); $this->load->model($this->config->item("rg_folder").'mo_rg_studyyear','sy'); $this->load->model($this->config->item("rg_folder").'mo_rg_studentstatus','sst');
$con_rs_cur = array('curStatus' => 'Y'); $ord_rs_cur = array('curId' => ''); $this->contents['rs_cur'] = $this->cur->get_options($con_rs_cur,$ord_rs_cur,'','');
$ord_sy = array('syId' => ''); $this->contents['rs_sy'] = $this->sy->get_options('',$ord_sy); $this->contents['rs_sst'] = $this->sst->qrySst();
$this->contents['tmId'] = $this->session->userdata('tmId'); $this->contents['acY'] = $this->session->userdata('acY');
$this->output($this->config->item("rg_folder")."v_searchRptRis"); }
public function rptRis() { $stStatus = ""; for($i=0; $i<$this->input->post('cntStStatus'); $i++) { if($this->input->post("stStatusArr".$i)) $stStatus .= $this->input->post("stStatusArr".$i).","; } if($this->input->post('curId')!="" && $stStatus != ""){ $this->load->model($this->config->item("rg_folder").'mo_rg_curriculum','cur'); $this->load->model($this->config->item("rg_folder").'mo_rg_student','std');
$stStatus = substr($stStatus, 0, -1); $this->cur->curId = $this->input->post('curId'); $this->cur->get_by_key(TRUE); $this->contents['qu_cur'] = $this->cur;
// if($this->input->post('stdAdY') && $this->input->post('syId')) { // $con_std = array('stdCurId' => $this->input->post('curId'), // 'stdSyId' => $this->input->post('syId'), // 'stdAdY' => $this->input->post('stdAdY'), // 'stdSstId' => $stStatus ); // } else if($this->input->post('stdAdY') && !$this->input->post('syId')) { // $con_std = array('stdCurId' => $this->input->post('curId'), // 'stdAdY' => $this->input->post('stdAdY'), // 'stdSstId' => $stStatus ); // } else if(!$this->input->post('stdAdY') && $this->input->post('syId')) { // $con_std = array('stdCurId' => $this->input->post('curId'), // 'stdSyId' => $this->input->post('syId'), // 'stdSstId' => $stStatus ); // } else { // $con_std = array('stdCurId' => $this->input->post('curId'), // 'stdSstId' => $stStatus ); // } // $order_std = array('stdCode' => '');
$this->contents['rs_std'] = $this->std->qryStdForRepRis($this->input->post('stdAdY'), $this->input->post('syId'), $this->input->post('curId'), $stStatus);
//$this->contents['rs_std'] = $this->std->qryStdJoinSstPfSyEtSoPrvSstFsGtpPaEdu($con_std,$order_std);
$this->contents['stdAdY'] = $this->input->post('stdAdY'); $this->contents['syId'] = $this->input->post('syId'); $this->contents['curId'] = $this->input->post('curId'); $this->contents['stStatus'] = $stStatus;
$fieldNames = array(); for($i=0; $i<$this->input->post('cntFieldNames'); $i++) { $fieldNames[$i] = $this->input->post('fieldNamesArr'.$i); } $this->contents['fieldNames'] = $fieldNames; }else $this->contents['errMs'] = "Y";
$this->output($this->config->item("rg_folder")."v_rptRis"); }
public function ris() { $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_studentsummary','ossm'); $this->load->model($this->config->item("rg_folder").'mo_rg_studentdetails','sdt'); $this->load->model($this->config->item("ppc_folder").'mo_province','prv'); $this->load->model($this->config->item("ppc_folder").'mo_district','dt'); $this->load->model($this->config->item("ppc_folder").'mo_amphur','ap'); $this->load->model($this->config->item("ppc_folder").'mo_nation', 'nt'); $this->load->model($this->config->item("ppc_folder").'mo_religion', 'rlg'); $this->load->model($this->config->item("ppc_folder").'mo_prefix', 'pf');
$this->cur->curId = $this->input->post('curId'); $this->cur->get_by_key(TRUE); $this->contents['qu_cur'] = $this->cur;
// if($this->input->post('stdAdY') && $this->input->post('syId')) { // $con_std = array('stdCurId' => $this->input->post('curId'), // 'stdSyId' => $this->input->post('syId'), // 'stdAdY' => $this->input->post('stdAdY'), // 'stdSstId' => $this->input->post('stStatus')); // } else if($this->input->post('stdAdY') && !$this->input->post('syId')) { // $con_std = array('stdCurId' => $this->input->post('curId'), // 'stdAdY' => $this->input->post('stdAdY'), // 'stdSstId' => $this->input->post('stStatus')); // } else if(!$this->input->post('stdAdY') && $this->input->post('syId')) { // $con_std = array('stdCurId' => $this->input->post('curId'), // 'stdSyId' => $this->input->post('syId'), // 'stdSstId' => $this->input->post('stStatus')); // } else { // $con_std = array('stdCurId' => $this->input->post('curId'), // 'stdSstId' => $this->input->post('stStatus')); // } // // $order_std = array('stdCode' => ''); // $this->contents['rs_std'] = $this->std->qryStdJoinSstPfSyEtSoPrvSstFsGtpPaEdu($con_std,$order_std);
$this->contents['rs_std'] = $this->std->qryStdForRepRis($this->input->post('stdAdY'), $this->input->post('syId'), $this->input->post('curId'), $this->input->post('stStatus'));
$fieldNames = array(); for($i=0; $i<$this->input->post('cntFieldNames'); $i++) { $fieldNames[$i] = $this->input->post('fieldNames'.$i); }
$this->contents['fieldNames'] = $fieldNames; $this->contents['cntFieldNames'] = $this->input->post('cntFieldNames'); $this->contents['dt'] = &$this->dt; $this->contents['ap'] = &$this->ap; $this->contents['prv'] = &$this->prv; $this->contents['ssm'] = &$this->ossm; $this->contents['nt'] = &$this->nt; $this->contents['rlg'] = &$this->rlg; $this->contents['pf'] = &$this->pf; $this->contents['sdt'] = &$this->sdt;
$this->output_detail($this->config->item("rg_folder")."v_ris"); }
public function searchRptRis401() { $this->load->model($this->config->item("rg_folder").'mo_rg_curriculum','cur');
$con_rs_cur = array('curStatus' => 'Y'); $ord_rs_cur = array('curId' => ''); $this->contents['rs_cur'] = $this->cur->get_options($con_rs_cur,$ord_rs_cur,'',''); $this->contents['acY'] = $this->session->userdata('acY');
$this->output($this->config->item("rg_folder")."v_searchRptRis401"); }
public function rptRis401() { $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('adY',' ','trim|integer|callback_checkAdY|xss_clean');
if($this->form_validation->run() == true) { $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->cur->curId = $this->input->post('curId'); $this->contents['qu_cur'] = $this->cur->get_by_key(); $con_rs_std = array('stdCurId' => $this->input->post('curId'), 'stdAdY' => $this->input->post('adY')); $ord_rs_std = array('stdCode' => ''); $this->contents['rs_std'] = $this->std->qryStdByCurId($con_rs_std,$ord_rs_std);
$this->contents['curId'] = $this->input->post('curId'); $this->contents['admitAcY'] = $this->input->post('adY');
$this->output_detail($this->config->item("rg_folder")."v_rptRis401"); } else { $this->searchRptRis401(); } } public function rptRis401Export() { $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->cur->curId = $this->input->post('curId'); $this->contents['qu_cur'] = $this->cur->get_by_key(); $con_rs_std = array('stdCurId' => $this->input->post('curId'), 'stdAdY' => $this->input->post('admitAcY')); $ord_rs_std = array('stdCode' => ''); $this->contents['rs_std'] = $this->std->qryStdByCurId($con_rs_std,$ord_rs_std); $this->contents['typeShow'] = "Y"; $this->contents['admitAcY'] = $this->input->post('admitAcY');
$this->output_detail($this->config->item("rg_folder")."v_rptRis401"); } } ?>
|