Viewing file:  rpt_misc.php (35.7 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
include('rg_controller.php');
class Rpt_misc extends Rg_controller {
// function __construct() {
// parent::__construct();
// }
public function searchRptRis111() {
$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' => explodeSquare($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_showRptRis111");
}
public function rptRis111($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("ppc_folder").'mo_level','lv');
$this->load->model($this->config->item("rg_folder").'mo_rg_timetable','tt');
$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;
}
// หากลุ่มของเกรด
if(is_null($this->co->coCurId)) {
$cofCurId = $this->cof->getGroupConCofCurId($coId);
$curGtpId = $this->cur->getGroupConCurGtpId($cofCurId);
$this->contents['rs_grd'] = $this->grd->qryInGtpId($curGtpId);
} else {
$curGtpId = $this->cur->getGroupConCurGtpId($this->co->coCurId);
$this->contents['rs_grd'] = $this->grd->qryInGtpId($curGtpId);
}
$this->lv->levelId = $curElvId;
$this->lv->get_by_key(TRUE);
$this->contents['qu_elv'] = $this->lv;
$rs_tt = $this->tt->qryTeacher($coId);
if ($rs_tt->num_rows() >0) {
$row = $rs_tt->row();
$officerNames = $row->prsName;
} else {
$officerNames = "";
}
$this->contents['officerNames'] = $officerNames;
$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_rptRis111");
}
public function searchRptRis112() {
$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_tm'] = $this->tm->get_options("","","","---เลือกภาคการศึกษา---");
$this->contents['rs_cur'] = $this->cur->get_options($con_rs_cur,$ord_rs_cur,'','---เลือกหลักสูตร---');
$this->contents['acY'] = $this->session->userdata('acY');
$this->contents['tmId'] = $this->session->userdata('tmId');
$this->output($this->config->item("rg_folder")."v_searchRptRis112");
}
public function rptRis112() {
$this->load->library('form_validation');
$this->form_validation->set_error_delimiters('<div class="error">','</div>');
if($this->input->post('typeStd')){
$this->form_validation->set_rules('typeStd', ' ', 'trim|xss_clean');
$this->form_validation->set_rules('stdCode', ' ', 'trim|required|xss_clean');
}else{
$this->form_validation->set_rules('acY', ' ', 'trim|integer|required|xss_clean');
$this->form_validation->set_rules('tmId', ' ', 'trim|required|xss_clea');
$this->form_validation->set_rules('curId', ' ', 'trim|required|xss_clean');
$this->form_validation->set_rules('syId', ' ', 'trim|required|integer|xss_clean');
}
$this->form_validation->set_rules('typeLang', ' ', 'trim|required|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_studentsummary','ssm');
$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_term','tm');
$this->contents['acY'] = $this->input->post('acY');
$this->contents['tmId'] = $this->input->post('tmId');
$this->contents['curId'] = $this->input->post('curId');
$this->contents['syId'] = $this->input->post('syId');
$this->contents['typeStd'] = $this->input->post('typeStd');
$this->contents['stdCode'] = $this->input->post('stdCode');
$this->contents['typeLang'] = $this->input->post('typeLang');
$typeRpt = $this->input->post('typeRpt');
$this->contents['bossname'] = $this->input->post('bossname');
$this->contents['bossposition'] = $this->input->post('bossposition');
$this->tm->tmId = $this->input->post('tmId');
$this->contents['tm'] = $this->tm->get_by_key();
if($this->contents['typeStd'] !='Y' && $this->contents['curId'] && $this->contents['syId'] && $this->contents['acY']) {
$cond = array('stdCurId' => $this->contents['curId'],
'stdSyId' => $this->contents['syId'],
//'ssmTmId' => $this->input->post('tmId'),
//'ssmAcY' => $this->input->post('acY')
);
$ord = array('stdCode' => '');
$grp = array( 'stdCode' => 'stdCode');
//$grp = '';
} else if($this->contents['typeStd'] =='Y' && $this->contents['stdCode'] && $this->contents['acY']) {
/*$cond = array('stdCode' => $this->contents['stdCode'],
'ssmTmId' => $this->input->post('tmId'),
'ssmAcY' => $this->input->post('acY'));*/
$ord = '';
//$grp = array( 'stdCode' => 'stdCode');
$cond = array( 'stdCode' => $this->contents['stdCode']);
$grp = array( 'stdCode' => 'stdCode');
} else {
$cond = '';
$ord = '';
$grp = '';
}
$this->contents['rs_std'] = $this->std->qryStdJoinPfSdtCurGenEdu($cond,$ord,$grp);
$this->contents['rd'] = $this->rd;
$this->contents['ssm'] = $this->ssm;
$this->contents['grd'] = $this->grd;
if(!$typeRpt)
$this->output_pdf($this->config->item("rg_folder")."v_rptRis112_v55");
else{
$this->load->model($this->config->item("rg_folder").'mo_rg_config','cfg');
$quCfg = $this->cfg->qryCfg();
$this->contents['cfg'] = $quCfg->row();
$this->output_pdf($this->config->item("rg_folder")."v_rptRis112");
}
}else $this->searchRptRis112();
}
public function searchRptRis113() {
$this->load->model($this->config->item("rg_folder").'mo_rg_term','tm');
$this->load->model($this->config->item("rg_folder").'mo_rg_curriculum','cur');
$this->load->model($this->config->item("rg_folder").'mo_rg_person','pp');
$this->load->model($this->config->item("rg_folder").'mo_rg_acadconfig','ac');
$con_rs_cur = array('curStatus' => 'Y');
$ord_rs_cur = array('curId' => '');
$opt = array();
$rs_tm = $this->tm->qryTm();
if($rs_tm->num_rows()>0){
$opt[''] = 'ทุกภาคการศึกษา';
foreach($rs_tm->result() as $row) {
$opt[$row->tmId] = $row->tmName;
}
}
$this->contents['rs_tm'] = $opt;
$this->contents['rs_cur'] = $this->cur->get_options($con_rs_cur,$ord_rs_cur,'','---เลือกหลักสูตร---');
$this->contents['acY'] = $this->session->userdata('acY');
$this->contents['tmId'] = $this->session->userdata('tmId');
$this->contents['rs_pp'] = $this->pp->get_options("","","","---เลือก---");
$qu_ac = $this->ac->qryAc();
$this->contents['ac'] = $qu_ac->row()->acPrsIdTSRegistrar;
$this->contents['rs_pp'] = $this->pp->get_options("","","","---เลือก---");
$this->output($this->config->item("rg_folder")."v_searchRptRis113");
}
public function rptRis113() {
$this->load->library('form_validation');
$this->form_validation->set_error_delimiters('<div class="error">','</div>');
if($this->input->post('typeStd')){
$this->form_validation->set_rules('typeStd', ' ', 'trim|xss_clean');
$this->form_validation->set_rules('stdCode', ' ', 'trim|required|xss_clean');
}else{
$this->form_validation->set_rules('acY', ' ', 'trim|integer|required|xss_clean');
$this->form_validation->set_rules('tmId', ' ', 'trim|xss_clea');
$this->form_validation->set_rules('curId', ' ', 'trim|required|xss_clean');
$this->form_validation->set_rules('syId', ' ', 'trim|required|integer|xss_clean');
}
$this->form_validation->set_rules('lSignature', ' ', 'trim|xss_clean');
$this->form_validation->set_rules('lPos', ' ', 'trim|xss_clean');
$this->form_validation->set_rules('mSignature', ' ', 'trim|xss_clean');
$this->form_validation->set_rules('mPos', ' ', 'trim|xss_clean');
$this->form_validation->set_rules('rSignature', ' ', 'trim|xss_clean');
$this->form_validation->set_rules('rPos', ' ', 'trim|xss_clean');
$this->form_validation->set_rules('typeLang',' ','trim|xss_clean');
if($this->form_validation->run() == true) {
$this->load->model($this->config->item("rg_folder").'mo_rg_person','pp');
$this->load->model($this->config->item("rg_folder").'mo_rg_student','std');
$this->load->model($this->config->item("rg_folder").'mo_rg_studentsummary','ssm');
$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_term','tm');
$typeLang = $this->input->post('typeLang');
$this->contents['acY'] = $this->input->post('acY');
$this->contents['tmId'] = $this->input->post('tmId');
$this->contents['curId'] = $this->input->post('curId');
$this->contents['syId'] = $this->input->post('syId');
$this->contents['typeStd'] = $this->input->post('typeStd');
$this->contents['stdCode'] = $this->input->post('stdCode');
$this->contents['lSignature'] = $this->input->post('lSignature');
$this->contents['lPos'] = $this->input->post('lPos');
$this->contents['mSignature'] = $this->input->post('mSignature');
$this->contents['mPos'] = $this->input->post('mPos');
$this->contents['rSignature'] = $this->input->post('rSignature');
$this->contents['rPos'] = $this->input->post('rPos');
$this->contents['typeLang'] = $typeLang;
if ($this->contents['lSignature']){
$con_pp = array('prsId' => $this->contents['lSignature']);
$this->pp->qryPrsJoinPPC($con_pp,"","",TRUE);
if($typeLang=='E') {
$this->contents['qu_lSignature'] = strtoupper($this->pp->nameE);
} else {
$this->contents['qu_lSignature'] = $this->pp->name;
}
} else {
$this->contents['qu_lSignature'] = '';
}
if ($this->contents['mSignature']){
$con_pp2 = array('prsId' => $this->contents['mSignature']);
$this->pp->qryPrsJoinPPC($con_pp2,"","",TRUE);
if($typeLang=='E') {
$this->contents['qu_mSignature'] = strtoupper($this->pp->nameE);
} else {
$this->contents['qu_mSignature'] = $this->pp->name;
}
} else {
$this->contents['qu_mSignature'] = '';
}
if ($this->contents['rSignature']){
$con_pp3 = array('prsId' => $this->contents['rSignature']);
$this->pp->qryPrsJoinPPC($con_pp3,"","",TRUE);
if($typeLang=='E') {
$this->contents['qu_rSignature'] = strtoupper($this->pp->nameE);
} else {
$this->contents['qu_rSignature'] = $this->pp->name;
}
} else {
$this->contents['qu_rSignature'] = '';
}
if($this->contents['typeStd'] !='Y' && $this->contents['curId'] && $this->contents['syId'] && $this->contents['acY']) {
$cond = array( 'stdCurId' => $this->contents['curId'],
'stdSyId' => $this->contents['syId'],
'ssmAcY' => $this->contents['acY']);
$grp = array( 'stdCode' => 'stdCode');
} else if($this->contents['typeStd'] =='Y' && $this->contents['stdCode'] && $this->contents['acY']) {
$cond = array( 'stdCode' => $this->contents['stdCode'],'ssmAcY' => $this->contents['acY']);
$grp = array( 'stdCode' => 'stdCode');
} else {
$cond = '';
$grp = '';
}
$this->contents['rs_std'] = $this->std->qryStdJoinPfSdtCurGenEdu($cond,'',$grp);
//echo $this->db->last_query();die();
$this->contents['tm'] = $this->tm;
$this->contents['rd'] = $this->rd;
$this->contents['ssm'] = $this->ssm;
$this->contents['grd'] = $this->grd;
$this->output_pdf($this->config->item("rg_folder")."v_rptRis113");
} else {
$this->searchRptRis113();
}
}
public function searchRptRis119() {
$this->contents['acY'] = $this->session->userdata('acY');
$this->output($this->config->item("rg_folder")."v_searchRptRis119");
}
public function rptRis119() {
$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', ' ', '');
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_student','std');
$this->load->model($this->config->item("rg_folder").'mo_rg_registdetails','rd');
$this->load->model($this->config->item("rg_folder").'mo_rg_studentsummary','ssm');
$this->load->model($this->config->item("rg_folder").'mo_rg_curriculum','cur');
$this->load->model($this->config->item("rg_folder").'mo_rg_studentstatus','sst');
$co = $this->co;
$std = $this->std;
$rd = $this->rd;
$ssm = $this->ssm;
$cur = $this->cur;
$sst = $this->sst;
$curId = $this->input->post("curId");
$acY = $this->input->post("adY"); //ปีการศึกษาที่เข้า
$tmcAcY = $this->input->post("tmcAcY"); //ปีการศึกษาปัจจุบัน
$stY = $this->input->post("studentYear");
$this->contents['co'] = $co;
$this->contents['rd'] = $rd;
$this->contents['ssm'] = $ssm;
$this->contents['std'] = $std;
$this->contents['sst'] = $sst;
$this->contents['curId'] = $curId;
$this->contents['acY'] = $acY;
$this->contents['stY'] = $stY;
$this->contents['tmcAcY'] = $tmcAcY;
// ***** หารุ่นของเด็ก
$stdCon = array('stdCurId' => $curId,'stdAdY' => $acY);
$stdGroup = array('stdGenId' => 'stdGenId');
$this->contents['rs_std'] = $std->qryStdJoinPfSdtCurGen($stdCon,'',$stdGroup);
// ***** หาหลักสูตร
$curCon = array('curId' => $curId);
$this->contents['qu_cur'] = $cur->qryCurJoinOther($curCon);
$this->output_detail($this->config->item("rg_folder")."v_rptRis119");
}else
$this->searchRptRis119();
}
public function curAndAdmitYAndGenStatusIsYTable() {
return;
}
public function searchRptRis123() {
$this->output($this->config->item("rg_folder")."v_searchRptRis123");
}
public function rptRis123() {
$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', ' ', '');
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_eduLevel','edv');
$this->load->model($this->config->item("rg_folder").'mo_rg_student','std');
$this->load->model($this->config->item("rg_folder").'mo_rg_generation','gen');
$this->load->model($this->config->item("rg_folder").'mo_rg_prefix','prf');
$this->load->model($this->config->item("rg_folder").'mo_rg_scholarowner','sch');
$this->load->model($this->config->item("rg_folder").'mo_rg_province','prv');
$this->load->model($this->config->item("rg_folder").'mo_rg_entrytype','ett');
$cur = $this->cur;
$edv = $this->edv;
$std = $this->std;
$gen = $this->gen;
$prf = $this->prf;
$sch = $this->sch;
$prv = $this->prv;
$ett = $this->ett;
$curId = $this->input->post("curId");
$curName = $this->input->post("curName");
$adY = $this->input->post("adY");
$curCon = array('curId' => $curId);
$this->contents['qu_cur'] = $cur->qryCurJoinOther($curCon,'','');
$stdCon = array('stdCurId' => $curId,'stdAdY' => $adY,'stdSstId' => '3','stdGraduateDate' => '0000-00-00','stdGraduateY' => '0');
$stdOrder = array('stdCode' => '');
$this->contents['rs_std'] = $std->qryStdJoinPfSoPrvEt($stdCon,$stdOrder,'');
$this->output_detail($this->config->item("rg_folder")."v_rptRis123");
}else
$this->searchRptRis123();
}
public function searchRptRis124() {
$this->contents['graduateY'] = $this->session->userdata('acY');
$this->output($this->config->item("rg_folder")."v_searchRptRis124");
}
public function rptRis124() {
$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', ' ', '');
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_eduLevel','edv');
$this->load->model($this->config->item("rg_folder").'mo_rg_student','std');
$this->load->model($this->config->item("rg_folder").'mo_rg_generation','gen');
$this->load->model($this->config->item("rg_folder").'mo_rg_prefix','prf');
$this->load->model($this->config->item("rg_folder").'mo_rg_scholarowner','sch');
$this->load->model($this->config->item("rg_folder").'mo_rg_province','prv');
$this->load->model($this->config->item("rg_folder").'mo_rg_entrytype','ett');
$cur = $this->cur;
$edv = $this->edv;
$std = $this->std;
$gen = $this->gen;
$prf = $this->prf;
$sch = $this->sch;
$prv = $this->prv;
$ett = $this->ett;
$curId = $this->input->post("curId");
$curName = $this->input->post("curName");
$adY = $this->input->post("adY");
$graduateY = $this->input->post("graduateY");
$this->contents['curId'] = $curId;
$this->contents['curName'] = $curName;
$this->contents['adY'] = $adY;
$this->contents['graduateY'] = $graduateY;
$this->contents['rs_std'] = $std->qryStdByCurIdAndAdYAndSstIdAndGraduateDateAndGraduateY($curId,$adY);
//echo $this->db->last_query();
$this->output_detail($this->config->item("rg_folder")."v_rptRis124");
}else
$this->searchRptRis124();
}
public function searchRptRis125() {
$this->load->model($this->config->item("rg_folder").'mo_rg_person','pp');
$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,'','y');
$this->contents['rs_pp'] = $this->pp->get_options("","","","");
$this->contents['tmId'] = $this->session->userdata('tmId');
$this->contents['acY'] = $this->session->userdata('acY');
$this->output($this->config->item("rg_folder")."v_searchRptRis125");
}
public function searchRptRis125_original() {
$this->load->model($this->config->item("rg_folder").'mo_rg_person','pp');
$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,'','y');
$this->contents['rs_pp'] = $this->pp->get_options("","","","");
$this->contents['tmId'] = $this->session->userdata('tmId');
$this->contents['acY'] = $this->session->userdata('acY');
$this->output($this->config->item("rg_folder")."v_searchRptRis125_original");
}
public function rptRis125() {
$this->load->library('form_validation');
$this->form_validation->set_error_delimiters('<div class="error">','</div>');
$this->form_validation->set_rules('typeSt', ' ','trim|required|xss_clean');
$this->form_validation->set_rules('beforeApprove', ' ','trim|xss_clean');
$this->form_validation->set_rules('typePaper', ' ','trim|xss_clean');
$this->form_validation->set_rules('typeLang', ' ','trim|xss_clean');
$this->form_validation->set_rules('typeDisplay', ' ','trim|xss_clean');
$this->form_validation->set_rules('lineSpacingEng', ' ','trim|xss_clean');
$this->form_validation->set_rules('showCfgClgLogo', ' ','trim|xss_clean');
$this->form_validation->set_rules('honorMedal', ' ','trim|xss_clean');
$this->form_validation->set_rules('officerId', ' ','trim|xss_clean');
$this->form_validation->set_rules('directorPos', ' ','trim|xss_clean');
$this->form_validation->set_rules('affiliatedTo', ' ','trim|xss_clean');
$this->form_validation->set_rules('affiliatedToName', ' ','trim|xss_clean');
$this->form_validation->set_rules('affiliatedToPos', ' ','trim|xss_clean');
$this->form_validation->set_rules('showStPic', ' ','trim|xss_clean');
if ($this->input->post('typeSt') == 'N') {
$this->form_validation->set_rules('curId', ' ', 'callback_checkselect');
$this->form_validation->set_rules('adY', ' ', 'callback_checkAdY');
} else {
$this->form_validation->set_rules('studentCode', ' ', 'trim|required|is_natural_no_zero|xss_clean');
}
if ($this->input->post('beforeApprove') == 'Y') {
$this->form_validation->set_rules('tmpFinishDate', ' ', 'trim|required|xss_clean');
}
$this->form_validation->set_rules('kuchk', ' ','trim|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_grade','grd');
$this->load->model($this->config->item("rg_folder").'mo_rg_person','pp');
$this->load->model($this->config->item("rg_folder").'mo_rg_studentsummary','ssm');
$this->load->model($this->config->item("rg_folder").'mo_rg_registdetails','rd');
$this->load->model($this->config->item("rg_folder").'mo_rg_curriculumstructure','cs');
$this->load->model($this->config->item("rg_folder").'mo_rg_regist','rg');
$this->load->model($this->config->item("rg_folder").'mo_rg_practicehours','ph');
$this->load->model($this->config->item("rg_folder").'mo_rg_acadconfig','ac');
$con_pp = array('prsId' => $this->input->post('officerId'));
$this->contents['qu_pp'] = $this->pp->qryPrsJoinPPC($con_pp,"","");
$this->contents['qu_ac'] = $this->ac->qryAc();
$this->contents['ssm'] = $this->ssm;
$this->contents['rd'] = $this->rd;
$this->contents['cs'] = $this->cs;
$this->contents['rg'] = $this->rg;
$this->contents['ph'] = $this->ph;
$this->contents['grd'] = $this->grd;
$this->contents['std'] = $this->std;
if ($this->input->post('typeSt') == 'Y') {
$con_std = array('stdCode' => $this->input->post('studentCode'));
} else {
$con_std = array('stdCurId' => $this->input->post('curId'),
'stdAdY' => $this->input->post('adY'));
}
$con_std_order = array('stdCode'=>'ASC');
$this->contents['qu_std'] = $this->std->qryStdJoinAllForRpt($con_std,$con_std_order,"");
$this->contents['showCfgClgLogo'] = $this->input->post('showCfgClgLogo');
$this->contents['honorMedal'] = $this->input->post('honorMedal');
$this->contents['typeLang'] = $this->input->post('typeLang');
$this->contents['beforeApprove'] = $this->input->post('beforeApprove');
$this->contents['affiliatedTo'] = $this->input->post('affiliatedTo');
$this->contents['typePaper'] = $this->input->post('typePaper');
$this->contents['affiliatedToName'] = $this->input->post('affiliatedToName');
$this->contents['affiliatedToPos'] = $this->input->post('affiliatedToPos');
$this->contents['lineSpacingEng'] = $this->input->post('lineSpacingEng');
$this->contents['officerId'] = $this->input->post('officerId');
$this->contents['directorPos'] = $this->input->post('directorPos');
$this->contents['tmpFinishDate'] = $this->input->post('tmpFinishDate');
$this->contents['typeSt'] = $this->input->post('typeSt');
$this->contents['showStPic'] = $this->input->post('showStPic');
$this->contents['typeDisplay'] = $this->input->post('typeDisplay');
if($this->input->post('kuchk') != 'Y' ){
//echo $this->input->post('typeSt'); exit;
if ($this->input->post('typeSt') == 'Y') {
$this->output_pdf($this->config->item("rg_folder")."v_rptRis125");
} else {
$this->output_pdf($this->config->item("rg_folder")."v_rptRis125Cur");
}
}else{
$this->output_pdf($this->config->item("rg_folder")."v_rptRis125_ku");
}
} else {
$this->searchRptRis125();
}
}
public function rptRis125_origin() {
$this->load->library('form_validation');
$this->form_validation->set_error_delimiters('<div class="error">','</div>');
$this->form_validation->set_rules('typeSt', ' ','trim|required|xss_clean');
$this->form_validation->set_rules('beforeApprove', ' ','trim|xss_clean');
$this->form_validation->set_rules('typePaper', ' ','trim|xss_clean');
$this->form_validation->set_rules('typeLang', ' ','trim|xss_clean');
$this->form_validation->set_rules('typeDisplay', ' ','trim|xss_clean');
$this->form_validation->set_rules('lineSpacingEng', ' ','trim|xss_clean');
$this->form_validation->set_rules('showCfgClgLogo', ' ','trim|xss_clean');
$this->form_validation->set_rules('honorMedal', ' ','trim|xss_clean');
$this->form_validation->set_rules('officerId', ' ','trim|xss_clean');
$this->form_validation->set_rules('directorPos', ' ','trim|xss_clean');
$this->form_validation->set_rules('affiliatedTo', ' ','trim|xss_clean');
$this->form_validation->set_rules('affiliatedToName', ' ','trim|xss_clean');
$this->form_validation->set_rules('affiliatedToPos', ' ','trim|xss_clean');
$this->form_validation->set_rules('showStPic', ' ','trim|xss_clean');
if ($this->input->post('typeSt') == 'N') {
$this->form_validation->set_rules('curId', ' ', 'callback_checkselect');
$this->form_validation->set_rules('adY', ' ', 'callback_checkAdY');
} else {
$this->form_validation->set_rules('studentCode', ' ', 'trim|required|is_natural_no_zero|xss_clean');
}
if ($this->input->post('beforeApprove') == 'Y') {
$this->form_validation->set_rules('tmpFinishDate', ' ', 'trim|required|xss_clean');
}
$this->form_validation->set_rules('kuchk', ' ','trim|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_grade','grd');
$this->load->model($this->config->item("rg_folder").'mo_rg_person','pp');
$this->load->model($this->config->item("rg_folder").'mo_rg_studentsummary','ssm');
$this->load->model($this->config->item("rg_folder").'mo_rg_registdetails','rd');
$this->load->model($this->config->item("rg_folder").'mo_rg_curriculumstructure','cs');
$this->load->model($this->config->item("rg_folder").'mo_rg_regist','rg');
$this->load->model($this->config->item("rg_folder").'mo_rg_practicehours','ph');
$this->load->model($this->config->item("rg_folder").'mo_rg_acadconfig','ac');
$con_pp = array('prsId' => $this->input->post('officerId'));
$this->contents['qu_pp'] = $this->pp->qryPrsJoinPPC($con_pp,"","");
$this->contents['qu_ac'] = $this->ac->qryAc();
$this->contents['ssm'] = $this->ssm;
$this->contents['rd'] = $this->rd;
$this->contents['cs'] = $this->cs;
$this->contents['rg'] = $this->rg;
$this->contents['ph'] = $this->ph;
$this->contents['grd'] = $this->grd;
$this->contents['std'] = $this->std;
if ($this->input->post('typeSt') == 'Y') {
$con_std = array('stdCode' => $this->input->post('studentCode'));
} else {
$con_std = array('stdCurId' => $this->input->post('curId'),
'stdAdY' => $this->input->post('adY'));
}
$con_std_order = array('stdCode'=>'ASC');
$this->contents['qu_std'] = $this->std->qryStdJoinAllForRpt($con_std,$con_std_order,"");
$this->contents['showCfgClgLogo'] = $this->input->post('showCfgClgLogo');
$this->contents['honorMedal'] = $this->input->post('honorMedal');
$this->contents['typeLang'] = $this->input->post('typeLang');
$this->contents['beforeApprove'] = $this->input->post('beforeApprove');
$this->contents['affiliatedTo'] = $this->input->post('affiliatedTo');
$this->contents['typePaper'] = $this->input->post('typePaper');
$this->contents['affiliatedToName'] = $this->input->post('affiliatedToName');
$this->contents['affiliatedToPos'] = $this->input->post('affiliatedToPos');
$this->contents['lineSpacingEng'] = $this->input->post('lineSpacingEng');
$this->contents['officerId'] = $this->input->post('officerId');
$this->contents['directorPos'] = $this->input->post('directorPos');
$this->contents['tmpFinishDate'] = $this->input->post('tmpFinishDate');
$this->contents['typeSt'] = $this->input->post('typeSt');
$this->contents['showStPic'] = $this->input->post('showStPic');
$this->contents['typeDisplay'] = $this->input->post('typeDisplay');
if($this->input->post('kuchk') != 'Y' ){
if ($this->input->post('typeSt') == 'Y') {
$this->output_pdf($this->config->item("rg_folder")."v_rptRis125_origin");
} else {
$this->output_pdf($this->config->item("rg_folder")."v_rptRis125Cur_origin");
}
}else{
$this->output_pdf($this->config->item("rg_folder")."v_rptRis125_ku");
}
} else {
$this->searchRptRis125();
}
}
public function searchFSG(){
$this->load->model($this->config->item("rg_folder").'mo_rg_person','pp');
$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,'','y');
$this->contents['rs_pp'] = $this->pp->get_options("","","","");
$this->contents['tmId'] = $this->session->userdata('tmId');
$this->contents['acY'] = $this->session->userdata('acY');
$this->output($this->config->item("rg_folder").'v_searchFSG');
}
public function rptRisFSG(){
$this->load->library('form_validation');
$this->form_validation->set_error_delimiters('<div class="error">','</div>');
$this->form_validation->set_rules('typeSt', ' ','trim|required|xss_clean');
$this->form_validation->set_rules('officerId', ' ','trim|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', ' ', 'callback_checkAdY');
}else {
$this->form_validation->set_rules('studentCode', ' ', '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');
$data['studen'] = $this->std->queryStdGraduateCer($this->input->post('typeSt'),$this->input->post('curId'),$this->input->post('adY'),$this->input->post('studentCode'));
$data['college'] = $this->std->queryCollege();
$con_pp = array('prsId' => $this->input->post('officerId'));
$data['qu_pp'] = $this->pp->qryPrsJoinPPC($con_pp,"","");
$data['directorPos'] = $this->input->post('directorPos');
$data['graduateDate'] = $this->input->post('graduateDate');
$data['graduateDatePicker'] = $this->input->post('graduateDatePicker');
$data['graduateDateY'] = $this->input->post('graduateDateY');
$data['graduateYDatePicker'] = $this->input->post('graduateYDatePicker');
$data['printDate'] = $this->input->post('printDate');
$data['affiliatedTo'] = $this->input->post('affiliatedTo');
$data['typeForm'] = $this->input->post('typeForm');
$data['academicCollage'] =$this->input->post('academicCollage');
$this->load->view($this->config->item("rg_folder").'/v_exportFSG',$data);
}else{
$this->searchFSG();
}
}
public function searchRptRis202() {
$this->contents['graduateY'] = $this->session->userdata('acY');
$this->output($this->config->item("rg_folder")."v_searchRptRis202");
}
public function rptRis202() {
$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_student','std');
$con_cur = array('curStatus' => 'Y');
$qrp_cur = array('curElvId' => 'curElvId');
$this->contents['graduateY'] = $this->input->post('graduateY');
$this->contents['rs_cur'] = $this->cur->qryCurJoinOther($con_cur,'',$qrp_cur);
//$this->contents['cur'] = $this->cur;
$this->contents['std'] = $this->std;
$this->contents['firstDate'] = $this->tmc->getMinToDateByAcY($this->contents['graduateY']);
$this->contents['lastDate'] = $this->tmc->getMaxToDateByAcY($this->contents['graduateY']);
$this->output_pdf($this->config->item("rg_folder")."v_rptRis202");
}
}
?>
|