Viewing file:  alumni.php (20.27 KB) -rwxr-xr-x
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
include('ea_controller.php');
class Alumni extends Ea_controller {
// function __construct() {
// parent::Controller();
// }
function am_input() {
$this->output($this->config->item("ea_folder")."v_searchAlumniForHis");
}
function am_search() {
$this->load->model($this->config->item("ea_folder").'mo_alumnimain','am');
if($this->input->post('studentCode')!="" || $this->input->post('studentName')!="" || $this->input->post('curName')!="" || $this->input->post('admitAcadYear')!="") {
$this->contents['rs_am'] = $this->am->qryAmByLikeNameAndCurAndAdY($this->input->post('studentCode'),$this->input->post('studentName'),$this->input->post('curName'),$this->input->post('admitAcadYear'));
//echo $this->db->last_query();die;
} else if($this->input->post('search'))
$this->contents['err_msg'] = "กรุณาป้อนคำค้นลงในช่องใดช่องหนึ่ง";
$this->output($this->config->item("ea_folder")."v_searchAlumniForHis");
}
/*function tb_1save() {
//$tab = 1;
//$this->binput($tab);
//redirect($this->config->item("ea_folder")."tab/binput");
}
function tb_2save() {
redirect($this->config->item("ea_folder")."tab/binput");
}
function binput($tab=0) {
$this->output($this->config->item("ea_folder")."v_bMain");
}*/
function am_detail($tb=0, $id=0) {
$tab = $this->input->post('tab')=='' ? ($tb==0 ? 1 : $tb) : $this->input->post('tab');
$alumniId = $this->input->post('alumniId')=="" ? $id : $this->input->post('alumniId');
//$studentId = $this->input->post('studentId')=="" ? $id : $this->input->post('studentId');
$data['tab'] = $tab;
$data['alumniId'] = $alumniId;
//$data['studentId'] = $studentId;
if($tab==1) {
$ord_rs_na = array('nationName');
$this->load->model($this->config->item('ea_folder').'mo_nation','na');
$data['rs_na'] = $this->na->get_options('','',$ord_rs_na,'y');
$ord_rs_re = array('religionName');
$this->load->model($this->config->item('ea_folder').'mo_religion','re');
$data['rs_re'] = $this->re->get_options('','',$ord_rs_re,'y');
$con_rs_cur = array("curStatus" => "Y");
$ord_rs_cur = array("curName" => "curName");
$this->load->model($this->config->item('ea_folder').'mo_curriculum','cur');
$data['rs_cur'] = $this->cur->get_options($con_rs_cur,'', $ord_rs_cur,'y');
$con_qu_am = array('am.alumniId' => $this->input->post('alumniId'));
$this->load->model($this->config->item('ea_folder').'mo_alumnimain','am');
$data['qu_am'] = $this->am->qryAmAndAb($con_qu_am);
echo $this->db->last_query();
$this->contents['v'] = $this->load->view($this->config->item('ea_folder').'v_alumniDetail',$data,TRUE);
} else if($tab==2) {
$this->load->model($this->config->item('ea_folder').'mo_alumnibio','ab');
$con_qu_ab_home = array('ab.alumniId' => $this->input->post('alumniId'));
$data['qu_ab_home'] = $this->ab->qryAbAndAddHome($con_qu_ab_home );
$con_qu_ab_curr = array('ab.alumniId' => $this->input->post('alumniId'));
$data['qu_ab_curr'] = $this->ab->qryAbAndAddCurrent($con_qu_ab_curr );
$con_qu_ab_off = array('ab.alumniId' => $this->input->post('alumniId'));
$data['qu_ab_off'] = $this->ab->qryAbAndAddOffice($con_qu_ab_off );
$ord_rs_co = array('countryName');
$this->load->model($this->config->item('ea_folder').'mo_country','co');
$data['rs_co'] = $this->co->get_options('','',$ord_rs_co,'y');
$con_qu_ab = array('ab.alumniId' => $this->input->post('alumniId'));
$this->load->model($this->config->item('ea_folder').'mo_alumnibio','ab');
$data['qu_ab'] = $this->ab->qryAb($con_qu_ab);
//echo $this->db->last_query();
$this->contents['v'] = $this->load->view($this->config->item('ea_folder').'v_alumniAddress',$data,TRUE);
} else if($tab==3) {
//$data['tab'] = $tab;
$this->load->model($this->config->item('ea_folder').'mo_hiswork','hw');
//$con_qu_hw = array('alumniId' => $this->input->post('studentId'));
//$ord_qu_hw = array('seqId');
//$data['qu_hw'] = $this->hw->qryHw($con_qu_hw,$ord_qu_hw);
//echo $this->db->last_query();
$con_rs_hw = array('alumniId' => $this->input->post('alumniId'));
$ord_rs_hw = array('seqId');
$data['rs_hw'] = $this->hw->qryHw($con_rs_hw,'',$ord_rs_hw);
$this->contents['v'] = $this->load->view($this->config->item('ea_folder').'v_alumniWork',$data,TRUE);
} else if($tab==4) {
//$data['tab'] = $tab;
$this->load->model($this->config->item('ea_folder').'mo_hisaward','ha');
$ord_rs_ta = array('taNameT');
$this->load->model($this->config->item('ea_folder').'mo_typeaward','ta');
$data['rs_ta'] = $this->ta->get_options('','',$ord_rs_ta,'y');
$ord_rs_la = array('laNameT');
$this->load->model($this->config->item('ea_folder').'mo_levelaward','la');
$data['rs_la'] = $this->la->get_options('','',$ord_rs_la,'y');
$con_rs_ha = array('alumniId' => $this->input->post('alumniId'));
$ord_rs_ha = array('seqId');
$data['rs_ha'] = $this->ha->qryHa($con_rs_ha,'',$ord_rs_ha);
$this->contents['v'] = $this->load->view($this->config->item('ea_folder').'v_alumniAward',$data,TRUE);
} else if($tab==5) {
//$data['tab'] = $tab;
$ord_rs_ledu = array('leduName');
$this->load->model($this->config->item('ea_folder').'mo_leveledu','ledu');
$data['rs_ledu'] = $this->ledu->get_options('','',$ord_rs_ledu,'y');
$ord_rs_edu = array('eduName');
$this->load->model($this->config->item('ea_folder').'mo_education','edu');
$data['rs_edu'] = $this->edu->get_options('','',$ord_rs_edu,'y');
$ord_rs_medu = array('meduName');
$this->load->model($this->config->item('ea_folder').'mo_majoredu','medu');
$data['rs_medu'] = $this->medu->get_options('','',$ord_rs_medu,'y');
$con_rs_he = array('alumniId' => $this->input->post('alumniId'));
$ord_rs_he = array('seqId');
$this->load->model($this->config->item('ea_folder').'mo_hiseducation','he');
$data['rs_he'] = $this->he->qryHeAndLeEduMedu($con_rs_he,'',$ord_rs_he);
//echo $this->db->last_query();
$this->contents['v'] = $this->load->view($this->config->item('ea_folder').'v_alumniLearn',$data,TRUE);
}
$this->contents['tab'] = $tab;
$this->output($this->config->item("ea_folder")."v_mainAlumni", $this->session->flashdata('msg'));
//$this->output($this->config->item("rg_folder")."v_editStudentMBInfo", $this->session->flashdata('msg'));
}
function learn_delete() {
$this->load->model($this->config->item('ea_folder').'mo_hiseducation','he');
$this->he->seqId = $this->input->post('seqId');
$this->he->delete();
$this->session->set_flashdata('msg', 3);
redirect($this->config->item("ea_folder")."basedata/la_input");
}
function v_alumniDetail() {
$this->load->library('form_validation');
$this->form_validation->set_error_delimiters('<font color="red">','</font>');
$this->form_validation->set_rules('alumniId',' ','trim|required|xss_clean');
$this->form_validation->set_rules('studentId',' ','trim|required|xss_clean');
$this->form_validation->set_rules('tab',' ','trim|required|xss_clean');
$this->form_validation->set_rules('prefixId','คำนำหน้าชื่อ','trim|required|xss_clean');
$this->form_validation->set_rules('studentName','ชื่อ','trim|required|xss_clean');
$this->form_validation->set_rules('studentSurname','นามสกุล','trim|required|xss_clean');
$this->form_validation->set_rules('citizenId','เลขที่บัตรประจำตัวประชาชน','trim|required|xss_clean');
$this->form_validation->set_rules('programId','หลักสูตร','trim|required|xss_clean');
if($this->form_validation->run() == true) {
$this->load->model($this->config->item("ea_folder").'mo_alumnimain','am');
$this->load->model($this->config->item("ea_folder").'mo_alumnibio','ab');
$flgmsg = 0;
$this->db->trans_begin();
$alumniId = $this->input->post('alumniId');
$studentId = $this->input->post('studentId');
$tab = $this->input->post('tab');
$prefixId = $this->input->post('prefixId');
$studentName = $this->input->post('studentName');
$studentSurname = $this->input->post('studentSurname');
$citizenId = $this->input->post('citizenId');
$programId = $this->input->post('programId');
$studentEmail = $this->input->post('studentEmail');
$bloodGroup = $this->input->post('bloodGroup');
$nationId = $this->input->post('nationId');
$religionId = $this->input->post('religionId');
$this->am->alumniId = $alumniId;
$this->am->studentId = $studentId;
$this->am->get_by_key(TRUE);
$this->am->prefixId = $prefixId;
$this->am->studentName = $studentName;
$this->am->studentSurname = $studentSurname;
$this->am->citizenId = $citizenId;
$this->am->programId = $programId;
$this->am->studentEmail = $studentEmail;
$this->am->updateDateTime = date('Y-m-d H:i:s');
$this->am->updateUserId = $this->session->userdata('UsLogin');
$this->am->update();
$this->ab->alumniId = $alumniId;
$this->ab->studentId = $studentId;
$this->ab->get_by_key(TRUE);
$this->ab->bloodGroup = $bloodGroup;
$this->ab->nationId = $nationId;
$this->ab->religionId = $religionId;
$this->ab->update();
//echo $this->db->last_query();
$flgmsg = 10;
if($this->db->trans_status() === false) {
$this->db->trans_rollback();
if($flgmsg)
$this->session->set_flashdata('msg', 0);
} else {
$this->db->trans_commit();
if($flgmsg)
$this->session->set_flashdata('msg', $flgmsg);
}
//redirect($this->config->item("ea_folder")."alumni/am_detail/$tab/$alumniId");
//} else {
//redirect($this->config->item("ea_folder")."alumni/am_detail/$tab/$alumniId");
$this->am_detail();
}
}
function v_alumniAddress() {
//$tab = $this->input->post('tab');
$this->load->library('form_validation');
$this->form_validation->set_error_delimiters('<font color="red">','</font>');
$this->form_validation->set_rules('alumniId',' ','trim|required|xss_clean');
$this->form_validation->set_rules('studentId',' ','trim|required|xss_clean');
$this->form_validation->set_rules('tab',' ','trim|required|xss_clean');
$this->form_validation->set_rules('homeAddress','','trim|required|xss_clean');
$this->form_validation->set_rules('districtId','','trim|required|xss_clean');
$this->form_validation->set_rules('amphurId','','trim|required|xss_clean');
$this->form_validation->set_rules('provinceId','','trim|required|xss_clean');
$this->form_validation->set_rules('homeZipcode','','trim|required|xss_clean');
$this->form_validation->set_rules('homePhoneNo','','trim|required|xss_clean');
if($this->form_validation->run() == true) {
$this->load->model($this->config->item("ea_folder").'mo_alumnibio','ab');
$alumniId = $this->input->post('alumniId');
$studentId = $this->input->post('studentId');
$tab = $this->input->post('tab');
$homeAddress = $this->input->post('homeAddress');
$districtId = $this->input->post('districtId');
$amphurId = $this->input->post('amphurId');
$provinceId = $this->input->post('provinceId');
$homeZipcode = $this->input->post('homeZipcode');
$homePhoneNo = $this->input->post('homePhoneNo');
$officeAddress = $this->input->post('officeAddress');
$offDistrictId = $this->input->post('offDistrictId');
$offAmphurId = $this->input->post('offAmphurId');
$offProvinceId = $this->input->post('offProvinceId');
$officeZipcode = $this->input->post('officeZipcode');
$officePhoneNo = $this->input->post('officePhoneNo');
$currentAddress = $this->input->post('currentAddress');
$curDistrictId = $this->input->post('curDistrictId');
$curAmphurId = $this->input->post('curAmphurId');
$curProvinceId = $this->input->post('curProvinceId');
$currentZipcode = $this->input->post('currentZipcode');
$currentPhoneNo = $this->input->post('currentPhoneNo');
$countryAddress = $this->input->post('countryAddress');
$countryId = $this->input->post('countryId');
$this->ab->alumniId = $alumniId;
$this->ab->studentId = $studentId;
$this->ab->get_by_key(TRUE);
$this->ab->homeAddress = $homeAddress;
$this->ab->homeDistrictId = $districtId;
$this->ab->homeAmphurId = $amphurId ;
$this->ab->homeProvinceId = $provinceId;
$this->ab->homeZipcode = $homeZipcode;
$this->ab->homePhoneNo = $homePhoneNo;
$this->ab->officeAddress = $officeAddress;
$this->ab->officeDistrictId = $offDistrictId;
$this->ab->officeAmphurId = $offAmphurId;
$this->ab->officeProvinceId = $offProvinceId;
$this->ab->officeZipcode = $officeZipcode;
$this->ab->officePhoneNo = $officePhoneNo;
$this->ab->currentAddress = $currentAddress;
$this->ab->currentDistrictId = $curDistrictId ;
$this->ab->currentAmphurId = $curAmphurId;
$this->ab->currentProvinceId = $curProvinceId;
$this->ab->currentZipcode = $currentZipcode;
$this->ab->currentPhoneNo = $currentPhoneNo;
$this->ab->countryAddress = $countryAddress;
$this->ab->countryId = $countryId;
$this->ab->update();
//echo $this->db->last_query();
$this->am_detail();
}
}
function v_alumniWork() {
$tab = $this->input->post('tab');
$alumniId = $this->input->post('alumniId');
$this->load->library('form_validation');
$this->form_validation->set_error_delimiters('<font color="red">','</font>');
$this->form_validation->set_rules('seqId',' ','trim|xss_clean');
$this->form_validation->set_rules('alumniId',' ','trim|xss_clean');
$this->form_validation->set_rules('companyNameT','ชื่อหน่วยงาน (ภาษาไทย)','trim|required|xss_clean');
$this->form_validation->set_rules('companyNameE','ชื่อหน่วยงาน (ภาษาอังกฤษ)','trim|required|xss_clean');
$this->form_validation->set_rules('companyAddr','ที่อยู่ของหน่วยงาน','trim|required|xss_clean');
$this->form_validation->set_rules('companyPosition','ตำแหน่ง','trim|required|xss_clean');
$this->form_validation->set_rules('companyAdmidPosYear',' ','trim|xss_clean');
if($this->form_validation->run() == true) {
$this->load->model($this->config->item("ea_folder").'mo_hiswork','hw');
$con_rs_hw = array('alumniId' => $this->input->post('alumniId'),
'companyNameT' => $this->input->post('companyNameT'),
'companyNameE' => $this->input->post('companyNameE'),
'companyAddr' => $this->input->post('companyAddr'),
'companyPosition' => $this->input->post('companyAddr'),
'companyAdmidPosYear'=> $this->input->post('companyAdmidPosYear'));
$rs_hw = $this->hw->qryHw($con_rs_hw,'','');
$seqId = $this->hw->qryHwByMaxSeqId($this->input->post('alumniId'));
if(!$rs_hw->num_rows()) {
//$tab = $this->input->post('tab');
$this->hw->seqId = $seqId;
$this->hw->alumniId = $this->input->post('alumniId');
$this->hw->companyNameT = $this->input->post('companyNameT');
$this->hw->companyNameE = $this->input->post('companyNameE');
$this->hw->companyAddr = $this->input->post('companyAddr');
$this->hw->companyPosition = $this->input->post('companyPosition');
$this->hw->companyAdmidPosYear = date('Y-m-d');
if($this->input->post('seqId')=='') {
$this->hw->insert();
} else {
$this->hw->seqId = $this->input->post('seqId');
$this->hw->update();
//echo $this->db->last_query();
}
//redirect($this->config->item("ea_folder")."alumni/am_detail/$tab/$alumniId");
}
//} else {
$this->am_detail();
}
}
function alumniWork_delete() {
$this->load->model($this->config->item("ea_folder").'mo_hiswork','hw');
$this->hw->seqId = $this->input->post('seqId');
$this->hw->delete();
redirect($this->config->item("ea_folder")."alumni/v_alumniWork");
}
function v_alumniAward() {
//$tab = $this->input->post('tab');
$this->load->library('form_validation');
$this->form_validation->set_error_delimiters('<font color="red">','</font>');
$this->form_validation->set_rules('seqId',' ','trim|xss_clean');
$this->form_validation->set_rules('alumniId',' ','trim|xss_clean');
$this->form_validation->set_rules('awardNameT','ชื่อรางวัล (ภาษาไทย)','trim|required|xss_clean');
$this->form_validation->set_rules('awardNameE','ชื่อรางวัล (ภาษาอังกฤษ)','trim|required|xss_clean');
$this->form_validation->set_rules('awardCompany','หน่วยงานที่ให้รางวัล','trim|required|xss_clean');
$this->form_validation->set_rules('taId','ประเภทรางวัล','trim|required|xss_clean');
$this->form_validation->set_rules('laId','ระดับการได้รับรางวัล','trim|required|xss_clean');
$this->form_validation->set_rules('awardYear',' ','trim|xss_clean');
if($this->form_validation->run() == true) {
$this->load->model($this->config->item("ea_folder").'mo_hisaward','ha');
$con_rs_ha = array('alumniId' => $this->input->post('alumniId'),
'awardNameT' => $this->input->post('awardNameT'),
'awardNameE' => $this->input->post('awardNameE'),
'awardCompany' => $this->input->post('awardCompany'),
'awardtaId' => $this->input->post('awardtaId'),
'awardlaId' => $this->input->post('awardlaId'),
'awardYear' => $this->input->post('awardYear'));
$rs_ha = $this->ha->qryHa($con_rs_ha,'','');
$seqId = $this->ha->qryHaByMaxSeqId($this->input->post('alumniId'));
//echo $this->db->last_query();
if(!$rs_ha->num_rows()) {
$this->ha->seqId = $seqId;
$this->ha->alumniId = $this->input->post('alumniId');
$this->ha->awardNameT = $this->input->post('awardNameT');
$this->ha->awardNameE = $this->input->post('awardNameE');
$this->ha->awardCompany = $this->input->post('awardCompany');
$this->ha->awardtaId = $this->input->post('taId');
$this->ha->awardlaId = $this->input->post('laId');
$this->ha->awardYear = $this->input->post('awardYear');
if($this->input->post('seqId')=='') {
$this->ha->insert();
//echo $this->db->last_query();
//echo $this->db->last_query();
} else {
$this->ha->seqId = $this->input->post('seqId');
$this->ha->update();
}
}
//redirect($this->config->item("ea_folder")."alumni/v_alumniAward");
//} else {
$this->am_detail();
}
}
function v_alumniLearn() {
//$tab = $this->input->post('tab');
$this->load->library('form_validation');
$this->form_validation->set_error_delimiters('<font color="red">','</font>');
$this->form_validation->set_rules('seqId',' ','trim|xss_clean');
$this->form_validation->set_rules('alumniId',' ','trim|xss_clean');
$this->form_validation->set_rules('heduName','ชื่อปริญญา','trim|required|xss_clean');
$this->form_validation->set_rules('leduId','ระดับ','trim|required|xss_clean');
$this->form_validation->set_rules('eduId','สถาบัน','trim|required|xss_clean');
$this->form_validation->set_rules('meduId','สาขา','trim|required|xss_clean');
$this->form_validation->set_rules('heduSDate',' ','trim|xss_clean');
$this->form_validation->set_rules('heduGDate',' ','trim|xss_clean');
if($this->form_validation->run() == true) {
$this->load->model($this->config->item("ea_folder").'mo_hiseducation','he');
$con_rs_he = array('alumniId' => $this->input->post('alumniId'),
'heduName' => $this->input->post('heduName'),
'heduleduId' => $this->input->post('leduId'),
'hedueduId' => $this->input->post('eduId'),
'hedumeduId' => $this->input->post('meduId'),
'heduSDate' => $this->input->post('heduSDate'),
'heduGDate' => $this->input->post('heduSDate'));
$rs_he = $this->he->qryHe($con_rs_he,'','');
$seqId = $this->he->qryHeByMaxSeqId($this->input->post('alumniId'));
if(!$rs_he->num_rows()) {
$this->he->seqId = $seqId;
$this->he->alumniId = $this->input->post('alumniId');
$this->he->heduName = $this->input->post('heduName');
$this->he->heduleduId = $this->input->post('leduId');
$this->he->hedueduId = $this->input->post('eduId');
$this->he->hedumeduId = $this->input->post('meduId');
$this->he->heduSDate = date('Y-m-d');
$this->he->heduGDate = date('Y-m-d');
if($this->input->post('seqId')=='') {
$this->he->insert();
//echo $this->db->last_query();
} else {
$this->he->seqId = $this->input->post('seqId');
$this->he->update();
}
}
//redirect($this->config->item("ea_folder")."alumni/v_alumniLearn");
//} else {
$this->am_detail();
}
}
}
?>
|