public function select($numL = 0)
{
if ($this->input->post('search')) {
$session = array('HRS_ID' => $this->input->post('HRS_ID'), 'FIRST_NAME' => $this->input->post('FIRST_NAME'), 'LAST_NAME' => $this->input->post('LAST_NAME'), 'MEMBER_USERNAME' => $this->input->post('MEMBER_USERNAME'), 'TYPE_ID' => $this->input->post('TYPE_ID'));
$this->session->set_userdata($session);
//สร้างตัวแปร sessio
}
if ($this->session->userdata('dir') == NULL or $this->session->userdata('dir') != $this->dir) {
$session = array('HRS_ID' => '', 'FIRST_NAME' => '', 'LAST_NAME' => '', 'MEMBER_USERNAME' => '', 'TYPE_ID' => '', 'dir' => $this->dir);
$this->session->set_userdata($session);
//สร้างตัวแปร sessio
}
//
$this->gms_member->HRS_ID = $this->session->userdata('HRS_ID');
$this->gms_member->FIRST_NAME = $this->session->userdata('FIRST_NAME');
$this->gms_member->LAST_NAME = $this->session->userdata('LAST_NAME');
$this->gms_member->MEMBER_USERNAME = $this->session->userdata('MEMBER_USERNAME');
$this->gms_member->TYPE_ID = $this->session->userdata('TYPE_ID');
$data['gms_type_list'] = elements_for_dropdown($this->gms_type->_getAllType(), 'TYPE_ID', 'TYPE_SUBJECT', 'ALL');
$numF = 10;
$data['type'] = $this->gms_type->_getAllType();
$data['count'] = $this->gms_member->_selectCountViewMember();
$data['member'] = $this->gms_member->_selectViewMember($numF, $numL);
$this->template->load('D04-ทะเบียนประวัติ', $this->dir . "/_select", $data);
}
public function update_for_member($member_id = 0, $history_id = 0)
{
$page_var = ['form_url' => site_url(['member', $member_id, 'history', 'update', $history_id]), 'form_header' => 'แก้ไขประวัติการปฏิบัติงาน', 'model' => $this->gms_history->find_by_id($history_id), 'gms_type_list' => elements_for_dropdown($this->gms_type->get_all(), 'TYPE_ID', 'TYPE_SUBJECT', 'ANY')];
// Prepare data for dropdown list
// Term
$page_var['gms_term'] = $this->gms_term->find_by_id($page_var['model']['TERM_ID']);
$gms_course = $this->gms_course->get_by_term_id($page_var['gms_term']['TERM_ID']);
$page_var['term_list'] = elements_for_dropdown($this->gms_term->get_data_for_dropdown_term($gms_course[0]['SPORT_ID'], $page_var['gms_term']['TERM_YEAR']), 'TERM_ID', 'TERM_NAME');
// Sport
$gms_sport = $this->gms_sport->find_by_id($gms_course[0]['SPORT_ID']);
$page_var['sport_list'] = elements_for_dropdown($this->gms_sport->get_by_type_id($gms_sport['TYPE_ID']), 'SPORT_ID', 'SPORT_SUBJECT');
$this->breadcrumbs->push($this->config->item('dashboard_icon') . ' Dashboard', 'dashboard');
$this->breadcrumbs->push('ทะเบียนประวัติ', 'd04/updateMember/' . $page_var['model']['MEMBER_ID']);
$this->breadcrumbs->push($page_var['form_header'], 'history/update');
$post_data = $this->input->post(NULL, TRUE);
if (empty($post_data) === TRUE) {
$this->template->load('ประวัติการปฏิบัติงาน', 'gms_history/update', $page_var);
return false;
} else {
$this->form_validation->set_rules($this->config->item('gms_history'));
if ($this->form_validation->run() == FALSE) {
$this->template->load('ประวัติการปฏิบัติงาน', 'gms_history/update', $page_var);
return false;
} else {
if ($this->gms_history->update($history_id, $post_data) === TRUE) {
$this->session->set_flashdata('flash_message', ['message' => 'ดำเนินการสำเร็จ', 'status' => 'success']);
redirect('member/' . $member_id . '/history/update/' . $history_id, 'refresh');
} else {
$this->session->set_flashdata('flash_message', ['message' => 'เกิดข้อผิดพลาด', 'status' => 'error']);
redirect('member/' . $member_id . '/history/update/' . $history_id, 'refresh');
}
}
}
}
public function select($numL = 0)
{
$this->load->view("lib/header");
if ($this->input->post('search')) {
$session = array('TERM_YEAR' => $this->input->post('TERM_YEAR'), 'SPORT_ID' => $this->input->post('SPORT_ID'), 'TYPE_ID' => $this->input->post('TYPE_ID'));
$this->session->set_userdata($session);
//สร้างตัวแปร sessio
}
if ($this->session->userdata('dir') == NULL or $this->session->userdata('dir') != $this->dir) {
$session = array('TERM_YEAR' => '', 'SPORT_ID' => '', 'TYPE_ID' => '', 'dir' => $this->dir);
$this->session->set_userdata($session);
//สร้างตัวแปร sessio
$this->gms_sport->TYPE_ID = 1;
} else {
$this->gms_sport->TYPE_ID = $this->session->userdata('TYPE_ID');
}
$this->gms_term->TERM_YEAR = $this->session->userdata('TERM_YEAR');
$this->gms_term->TYPE_ID = $this->session->userdata('TYPE_ID');
$this->gms_term->SPORT_ID = $this->session->userdata('SPORT_ID');
$data['gms_type_list'] = elements_for_dropdown($this->gms_type->_getAllType(), 'TYPE_ID', 'TYPE_SUBJECT', 'ALL');
$data['gms_sport_list'] = elements_for_dropdown($this->gms_sport->_searchByType(), 'SPORT_ID', 'SPORT_SUBJECT', 'ALL');
$numF = 10;
$data['sport'] = $this->gms_sport->_searchByType();
@($data['count'] = $this->gms_term->_selectCountTerm());
@($data['term'] = $this->gms_term->_selectTerm($numF, $numL));
$this->load->view($this->dir . "/_select", $data);
$this->load->view("lib/footer");
}
public function index()
{
$page_var = [];
$this->breadcrumbs->push($this->config->item('dashboard_icon') . ' Dashboard', 'dashboard');
$this->breadcrumbs->push('รายชื่อผู้ผ่านการฝึกอบรม', 'R02/index');
$page_var['gms_type_list'] = elements_for_dropdown($this->gms_type->get_all(), 'TYPE_ID', 'TYPE_SUBJECT', 'ANY');
$this->template->load('R02-รายชื่อผู้ผ่านการฝึกอบรม', 'r02/index', $page_var);
}
public function index()
{
$page_var = [];
$page_var['page_header'] = 'R06-พิมพ์วุฒิบัตรผู้ผ่านการฝึกอบรม';
$page_var['gms_type_list'] = elements_for_dropdown($this->gms_type->get_all(), 'TYPE_ID', 'TYPE_SUBJECT', 'ANY');
$this->breadcrumbs->push($this->config->item('dashboard_icon') . ' Dashboard', 'dashboard');
$this->breadcrumbs->push($page_var['page_header'], 'R06/index');
$this->template->load($page_var['page_header'], 'r06/index', $page_var);
}
public function update_for_member($member_id = 0, $work_id = 0)
{
$page_var = ['form_url' => site_url(['member', $member_id, 'work', 'update', $work_id]), 'model' => $this->gms_work->find_by_id($work_id), 'form_header' => 'แก้ไขเหตุผลที่ไม่อนุมัติ', 'gms_type_list' => elements_for_dropdown($this->gms_type->get_all(), 'TYPE_ID', 'TYPE_SUBJECT'), 'gms_work_level_list' => elements_for_dropdown($this->gms_work_level->get_all(), 'LEVEL_ID', 'LEVEL_DETAIL'), 'province_list' => elements_for_dropdown($this->province->_getAllProvince(), 'PROV_ID', 'PROV_NAME')];
// Prepare data for dropdown list
if (empty($page_var['model']['SPORT_ID']) === FALSE) {
$type_id = $this->gms_sport->find_by_id($page_var['model']['SPORT_ID'])['TYPE_ID'];
$page_var['sport_list'] = elements_for_dropdown($this->gms_sport->get_by_type_id($type_id), 'SPORT_ID', 'SPORT_SUBJECT');
}
if (empty($page_var['model']['AMPHUR_ID']) === FALSE) {
$this->amphur->PROV_ID = $page_var['model']['PROVINCE_ID'];
$page_var['amphur_list'] = elements_for_dropdown($this->amphur->_getAllAmphur(), 'AMPHUR_ID', 'AMPHUR_NAME');
}
if (empty($page_var['model']['TUMBOL_ID']) === FALSE) {
$this->tumbol->PROV_ID = $page_var['model']['PROVINCE_ID'];
$this->tumbol->AMPHUR_ID = $page_var['model']['AMPHUR_ID'];
$page_var['tumbol_list'] = elements_for_dropdown($this->tumbol->_getAllTumbol(), 'TUMBOL_ID', 'TUMBOL_NAME');
}
// End Prepare data for dropdown list
$this->breadcrumbs->push($this->config->item('dashboard_icon') . ' Dashboard', 'dashboard');
$this->breadcrumbs->push('ทะเบียนประวัติ', 'd04/updateMember/' . $page_var['model']['MEMBER_ID']);
$this->breadcrumbs->push($page_var['form_header'], 'work/update');
$post_data = $this->input->post(NULL, TRUE);
if (empty($post_data) === TRUE) {
$this->template->load('ประวัติการปฏิบัติงาน', 'gms_work/update', $page_var);
return false;
} else {
$this->form_validation->set_rules($this->config->item('gms_work'));
if ($this->form_validation->run() == FALSE) {
$this->template->load('ประวัติการปฏิบัติงาน', 'gms_work/update', $page_var);
return false;
} else {
if ($this->gms_work->update($work_id, $post_data) === TRUE) {
$this->session->set_flashdata('flash_message', ['message' => 'ดำเนินการสำเร็จ', 'status' => 'success']);
redirect('member/' . $member_id . '/work/update/' . $work_id, 'refresh');
} else {
$this->session->set_flashdata('flash_message', ['message' => 'เกิดข้อผิดพลาด', 'status' => 'error']);
redirect('member/' . $member_id . '/work/update/' . $work_id, 'refresh');
}
}
}
}
public function select($numL = 0)
{
$this->load->view("lib/header");
if ($this->input->post('search')) {
$session = array('TERM_YEAR' => $this->input->post('TERM_YEAR'), 'SPORT_ID' => $this->input->post('SPORT_ID'), 'COURSE_ID' => $this->input->post('COURSE_ID'), 'TYPE_ID' => $this->input->post('TYPE_ID'), 'TERM_GEN' => $this->input->post('TERM_GEN'));
$this->session->set_userdata($session);
//สร้างตัวแปร sessio
}
if ($this->session->userdata('dir') == NULL or $this->session->userdata('dir') != $this->dir) {
$session = array('TERM_YEAR' => '', 'SPORT_ID' => '', 'COURSE_ID' => '', 'TYPE_ID' => '', 'TERM_GEN' => '', 'COURSE_ID' => '', 'dir' => $this->dir);
$this->session->set_userdata($session);
//สร้างตัวแปร sessio
$this->gms_sport->TYPE_ID = 1;
} else {
$this->gms_sport->TYPE_ID = $this->session->userdata('TYPE_ID');
}
//
$this->gms_term->TERM_YEAR = $this->session->userdata('TERM_YEAR');
$this->gms_term->COURSE_ID = $this->session->userdata('COURSE_ID');
$this->gms_term->SPORT_ID = $this->session->userdata('SPORT_ID');
$this->gms_term->TYPE_ID = $this->session->userdata('TYPE_ID');
$this->gms_term->TERM_GEN = $this->session->userdata('TERM_GEN');
$this->gms_term->HISTORY_STATUS_REGIS = 1;
// Data for dropdown
$data['gms_type_list'] = elements_for_dropdown($this->gms_type->_getAllType(), 'TYPE_ID', 'TYPE_SUBJECT', 'ALL');
if (!empty($this->gms_term->TYPE_ID) && $this->gms_term->TYPE_ID !== 'all') {
$data['gms_sport_list'] = elements_for_dropdown($this->gms_sport->get_by_type_id($this->gms_term->TYPE_ID), 'SPORT_ID', 'SPORT_SUBJECT', 'ALL');
}
if (!empty($this->gms_term->SPORT_ID) && $this->gms_term->SPORT_ID !== 'all') {
$data['gms_course_list'] = elements_for_dropdown($this->gms_course->get_by_sport_id($this->gms_term->SPORT_ID), 'COURSE_ID', 'COURSE_SUBJECT', 'ALL');
}
$numF = 10;
//$this->gms_term->order_by = '';
$data['type'] = $this->gms_type->_getAllType();
$data['sport'] = $this->gms_sport->_searchByType();
@($data['count'] = $this->gms_term->_selectCountTerm());
@($data['term'] = $this->gms_term->_selectTerm($numF, $numL));
$this->load->view($this->dir . "/_select", $data);
$this->load->view("lib/footer");
}
public function selectCourse($numL = 0)
{
$this->load->helper('pagination');
$this->load->view("lib/header");
$data = array();
$data['search_params'] = $this->uri->uri_to_assoc(4);
if (empty($data['search_params']['TYPE_ID']) === FALSE && $data['search_params']['TYPE_ID'] !== 'all') {
$this->gms_course->TYPE_ID = $data['search_params']['TYPE_ID'];
$data['gms_sport_list'] = elements_for_dropdown($this->gms_sport->_searchByType(), 'SPORT_ID', 'SPORT_SUBJECT', 'ALL');
}
if (empty($data['search_params']['SPORT_ID']) === FALSE && $data['search_params']['SPORT_ID'] !== 'all') {
$this->gms_course->SPORT_ID = $data['search_params']['SPORT_ID'];
}
if (empty($data['search_params']['COURSE_SUBJECT']) === FALSE) {
$this->gms_course->COURSE_SUBJECT = $data['search_params']['COURSE_SUBJECT'];
}
$data['gms_type_list'] = elements_for_dropdown($this->gms_type->_getAllType(), 'TYPE_ID', 'TYPE_SUBJECT', 'ALL');
$data['sport'] = $this->gms_sport->_searchByType();
@($data['pagination'] = init_pagination('/s03/index', $this->gms_course->_selectCountViewCourse(), '/' . $this->uri->assoc_to_uri($data['search_params'])));
@($data['course'] = $this->gms_course->_selectViewCourse($data['pagination']->per_page, $numL));
$this->load->view($this->dir . "/_select", $data);
$this->load->view("lib/footer");
}
public function update($id)
{
$this->breadcrumbs->push($this->config->item('dashboard_icon') . ' Dashboard', 'dashboard');
$this->breadcrumbs->push('ข้อมูลชนิดกีฬา/ชนิดการฝึกอบรม', 'sports/index');
$this->breadcrumbs->push('แก้ไขชนิดกีฬา/ชนิดการฝึกอบรม', 'sports/update' . $id);
$page_var = ['form_url' => site_url('/sports/update/' . $id), 'gms_type_list' => elements_for_dropdown($this->gms_type->get_all(), 'TYPE_ID', 'TYPE_SUBJECT'), 'model' => $this->gms_sport->find_by_id($id)];
$post_data = $this->input->post(NULL, TRUE);
if (empty($post_data) === TRUE) {
$this->template->load('แก้ไขชนิดกีฬา/ชนิดการฝึกอบรม', 'gms_sports/update', $page_var);
return false;
} else {
$this->form_validation->set_rules($this->config->item('gms_sport_validation'));
if ($this->form_validation->run() == FALSE) {
$this->template->load('แก้ไขชนิดกีฬา/ชนิดการฝึกอบรม', 'gms_sports/update', $page_var);
return false;
} else {
if ($_FILES['SPORT_IMAGE']['error'] !== 4) {
$this->load->helper('upload_form');
$result_upload = upload_image('SPORT_IMAGE', 'gms_sport', $id);
if ($result_upload['status'] === FALSE) {
$page_var['upload_error'] = $result_upload['data'];
$this->template->load('เพิ่มชนิดกีฬา/ชนิดการฝึกอบรม', 'gms_sports/update', $page_var);
return;
} else {
$post_data['SPORT_IMAGE'] = $result_upload['data']['file_name'];
}
}
if ($this->gms_sport->update($id, $post_data) === TRUE) {
$this->session->set_flashdata('flash_message', ['message' => 'ดำเนินการสำเร็จ', 'status' => 'success']);
redirect('sports/update/' . $id, 'refresh');
} else {
$this->session->set_flashdata('flash_message', ['message' => 'เกิดข้อผิดพลาด', 'status' => 'error']);
redirect('sports/create', 'refresh');
}
}
}
}
