Viewing file:  rpt_student.php (32.09 KB) -rw-r--r--
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");
}
}
?>
|