Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- defined('BASEPATH') OR exit('No direct script access allowed');
- class Pendidikan extends CI_Controller {
- public function __construct()
- {
- parent::__construct();
- $this->load->model('Pendidikan_model','model');
- //Do your magic here
- }
- public function index()
- {
- if (!$this->ion_auth->logged_in())
- {
- redirect('auth', 'refresh');
- }
- $user = $this->ion_auth->user()->row();
- $user_groups = $this->ion_auth->get_users_groups($user->id)->row();
- $this->breadcrumbs->push('<i class="fa fa-home"></i>', '/');
- $this->breadcrumbs->push('Berdasarkan Pendidikan', '/pendidikan');
- $data['breadcrumbs'] = $this->breadcrumbs->show();
- $data['message'] = (validation_errors()) ? validation_errors() : $this->session->flashdata('message');
- $data['title'] = 'Berdasarkan Pendidikan';
- $data['menu_active'] = 'Laporan Pegawai';
- $data['sub_menu_active'] = 'Pegawai Non PNS/BLU';
- $data['sub_sub_menu_active'] = 'Berdasarkan Pendidikan';
- $data['get_instansi'] = $this->Ref_model->get_instansi();
- $this->load->view('header', $data);
- $this->load->view('index', $data);
- }
- public function ajax_list()
- {
- $list = $this->model->get_datatables();
- $data = array();
- $no = @$_POST['start'];
- foreach ($list as $person) {
- // $get_instansi = $this->Ref_model->get_ref_single('tbl_instansi','kd_instansi',$person->kd_instansi);
- // $get_organisasi = $this->Ref_model->get_ref_single('tbl_organisasi','kd_organisasi',$person->kd_organisasi);
- // $get_satuan_organisasi = $this->Ref_model->get_ref_single('tbl_satuan_organisasi','kd_satuan_organisasi',$person->kd_satuan_organisasi);
- // $get_jabatan = $this->Ref_model->get_ref_single('tabel_jabatan','kd_jabatan',$person->kd_jabatan);
- // $get_golongan = $this->Ref_model->get_ref_single('tabel_golongan','kd_golongan',$person->kd_golongan);
- // $get_pendidikan = $this->Ref_model->get_ref_single('tabel_pendidikan','kd_pendidikan',$person->kd_pendidikan);
- // field s3
- $get_s31 = $this->model->get_s3_instansi(@$person->kd_instansi,@$person->kd_organisasi);
- $get_s32 = $this->model->get_s3_organisasi(@$person->kd_instansi,@$person->kd_organisasi,@$person->kd_satuan_organisasi);
- $get_s33 = $this->model->get_s3_satuan_kerja(@$person->kd_instansi,@$person->kd_organisasi,@$person->kd_satuan_organisasi,@$person->kd_unit_organisasi);
- $get_s34 = $this->model->get_s3_satuan_organisasi(@$person->kd_instansi,@$person->kd_organisasi,@$person->kd_satuan_organisasi,@$person->kd_unit_organisasi,@$person->kd_unit_kerja);
- $get_s35 = $this->model->get_s3_unit_organisasi(@$person->kd_instansi,@$person->kd_organisasi,@$person->kd_satuan_organisasi,@$person->kd_unit_organisasi,@$person->kd_unit_kerja,@$kd_unit_seksi);
- // field s2
- $get_s21 = $this->model->get_s2_instansi(@$person->kd_instansi,@$person->kd_organisasi);
- $get_s22 = $this->model->get_s2_organisasi(@$person->kd_instansi,@$person->kd_organisasi,@$person->kd_satuan_organisasi);
- $get_s23 = $this->model->get_s2_satuan_kerja(@$person->kd_instansi,@$person->kd_organisasi,@$person->kd_satuan_organisasi,@$person->kd_unit_organisasi);
- $get_s24 = $this->model->get_s2_satuan_organisasi(@$person->kd_instansi,@$person->kd_organisasi,@$person->kd_satuan_organisasi,@$person->kd_unit_organisasi,@$person->kd_unit_kerja);
- $get_s25 = $this->model->get_s2_unit_organisasi(@$person->kd_instansi,@$person->kd_organisasi,@$person->kd_satuan_organisasi,@$person->kd_unit_organisasi,@$person->kd_unit_kerja,@$kd_unit_seksi);
- // field spesialis
- $get_spesialis1 = $this->model->get_spesialis_instansi(@$person->kd_instansi,@$person->kd_organisasi);
- $get_spesialis2 = $this->model->get_spesialis_organisasi(@$person->kd_instansi,@$person->kd_organisasi,@$person->kd_satuan_organisasi);
- $get_spesialis3 = $this->model->get_spesialis_satuan_kerja(@$person->kd_instansi,@$person->kd_organisasi,@$person->kd_satuan_organisasi,@$person->kd_unit_organisasi);
- $get_spesialis4 = $this->model->get_spesialis_satuan_organisasi(@$person->kd_instansi,@$person->kd_organisasi,@$person->kd_satuan_organisasi,@$person->kd_unit_organisasi,@$person->kd_unit_kerja);
- $get_spesialis5 = $this->model->get_spesialis_unit_organisasi(@$person->kd_instansi,@$person->kd_organisasi,@$person->kd_satuan_organisasi,@$person->kd_unit_organisasi,@$person->kd_unit_kerja,@$kd_unit_seksi);
- // field a4
- $get_a41 = $this->model->get_a4_instansi(@$person->kd_instansi,@$person->kd_organisasi);
- $get_a42 = $this->model->get_a4_organisasi(@$person->kd_instansi,@$person->kd_organisasi,@$person->kd_satuan_organisasi);
- $get_a43 = $this->model->get_a4_satuan_kerja(@$person->kd_instansi,@$person->kd_organisasi,@$person->kd_satuan_organisasi,@$person->kd_unit_organisasi);
- $get_a44 = $this->model->get_a4_satuan_organisasi(@$person->kd_instansi,@$person->kd_organisasi,@$person->kd_satuan_organisasi,@$person->kd_unit_organisasi,@$person->kd_unit_kerja);
- $get_a45 = $this->model->get_a4_unit_organisasi(@$person->kd_instansi,@$person->kd_organisasi,@$person->kd_satuan_organisasi,@$person->kd_unit_organisasi,@$person->kd_unit_kerja,@$kd_unit_seksi);
- // field s1
- $get_s11 = $this->model->get_s1_instansi(@$person->kd_instansi,@$person->kd_organisasi);
- $get_s12 = $this->model->get_s1_organisasi(@$person->kd_instansi,@$person->kd_organisasi,@$person->kd_satuan_organisasi);
- $get_s13 = $this->model->get_s1_satuan_kerja(@$person->kd_instansi,@$person->kd_organisasi,@$person->kd_satuan_organisasi,@$person->kd_unit_organisasi);
- $get_s14 = $this->model->get_s1_satuan_organisasi(@$person->kd_instansi,@$person->kd_organisasi,@$person->kd_satuan_organisasi,@$person->kd_unit_organisasi,@$person->kd_unit_kerja);
- $get_s15 = $this->model->get_s1_unit_organisasi(@$person->kd_instansi,@$person->kd_organisasi,@$person->kd_satuan_organisasi,@$person->kd_unit_organisasi,@$person->kd_unit_kerja,@$kd_unit_seksi);
- // field d4
- $get_d41 = $this->model->get_d4_instansi(@$person->kd_instansi,@$person->kd_organisasi);
- $get_d42 = $this->model->get_d4_organisasi(@$person->kd_instansi,@$person->kd_organisasi,@$person->kd_satuan_organisasi);
- $get_d43 = $this->model->get_d4_satuan_kerja(@$person->kd_instansi,@$person->kd_organisasi,@$person->kd_satuan_organisasi,@$person->kd_unit_organisasi);
- $get_d44 = $this->model->get_d4_satuan_organisasi(@$person->kd_instansi,@$person->kd_organisasi,@$person->kd_satuan_organisasi,@$person->kd_unit_organisasi,@$person->kd_unit_kerja);
- $get_d45 = $this->model->get_d4_unit_organisasi(@$person->kd_instansi,@$person->kd_organisasi,@$person->kd_satuan_organisasi,@$person->kd_unit_organisasi,@$person->kd_unit_kerja,@$kd_unit_seksi);
- // field d3
- $get_d31 = $this->model->get_d3_instansi(@$person->kd_instansi,@$person->kd_organisasi);
- $get_d32 = $this->model->get_d3_organisasi(@$person->kd_instansi,@$person->kd_organisasi,@$person->kd_satuan_organisasi);
- $get_d33 = $this->model->get_d3_satuan_kerja(@$person->kd_instansi,@$person->kd_organisasi,@$person->kd_satuan_organisasi,@$person->kd_unit_organisasi);
- $get_d34 = $this->model->get_d3_satuan_organisasi(@$person->kd_instansi,@$person->kd_organisasi,@$person->kd_satuan_organisasi,@$person->kd_unit_organisasi,@$person->kd_unit_kerja);
- $get_d35 = $this->model->get_d3_unit_organisasi(@$person->kd_instansi,@$person->kd_organisasi,@$person->kd_satuan_organisasi,@$person->kd_unit_organisasi,@$person->kd_unit_kerja,@$kd_unit_seksi);
- // field akademi
- $get_akademi1 = $this->model->get_akademi_instansi(@$person->kd_instansi,@$person->kd_organisasi);
- $get_akademi2 = $this->model->get_akademi_organisasi(@$person->kd_instansi,@$person->kd_organisasi,@$person->kd_satuan_organisasi);
- $get_akademi3 = $this->model->get_akademi_satuan_kerja(@$person->kd_instansi,@$person->kd_organisasi,@$person->kd_satuan_organisasi,@$person->kd_unit_organisasi);
- $get_akademi4 = $this->model->get_akademi_satuan_organisasi(@$person->kd_instansi,@$person->kd_organisasi,@$person->kd_satuan_organisasi,@$person->kd_unit_organisasi,@$person->kd_unit_kerja);
- $get_akademi5 = $this->model->get_akademi_unit_organisasi(@$person->kd_instansi,@$person->kd_organisasi,@$person->kd_satuan_organisasi,@$person->kd_unit_organisasi,@$person->kd_unit_kerja,@$kd_unit_seksi);
- // field sm
- $get_sm1 = $this->model->get_sm_instansi(@$person->kd_instansi,@$person->kd_organisasi);
- $get_sm2 = $this->model->get_sm_organisasi(@$person->kd_instansi,@$person->kd_organisasi,@$person->kd_satuan_organisasi);
- $get_sm3 = $this->model->get_sm_satuan_kerja(@$person->kd_instansi,@$person->kd_organisasi,@$person->kd_satuan_organisasi,@$person->kd_unit_organisasi);
- $get_sm4 = $this->model->get_sm_satuan_organisasi(@$person->kd_instansi,@$person->kd_organisasi,@$person->kd_satuan_organisasi,@$person->kd_unit_organisasi,@$person->kd_unit_kerja);
- $get_sm5 = $this->model->get_sm_unit_organisasi(@$person->kd_instansi,@$person->kd_organisasi,@$person->kd_satuan_organisasi,@$person->kd_unit_organisasi,@$person->kd_unit_kerja,@$kd_unit_seksi);
- // field d2
- $get_d21 = $this->model->get_d2_instansi(@$person->kd_instansi,@$person->kd_organisasi);
- $get_d22 = $this->model->get_d2_organisasi(@$person->kd_instansi,@$person->kd_organisasi,@$person->kd_satuan_organisasi);
- $get_d23 = $this->model->get_d2_satuan_kerja(@$person->kd_instansi,@$person->kd_organisasi,@$person->kd_satuan_organisasi,@$person->kd_unit_organisasi);
- $get_d24 = $this->model->get_d2_satuan_organisasi(@$person->kd_instansi,@$person->kd_organisasi,@$person->kd_satuan_organisasi,@$person->kd_unit_organisasi,@$person->kd_unit_kerja);
- $get_d25 = $this->model->get_d2_unit_organisasi(@$person->kd_instansi,@$person->kd_organisasi,@$person->kd_satuan_organisasi,@$person->kd_unit_organisasi,@$person->kd_unit_kerja,@$kd_unit_seksi);
- // field d1
- $get_d11 = $this->model->get_d1_instansi(@$person->kd_instansi,@$person->kd_organisasi);
- $get_d12 = $this->model->get_d1_organisasi(@$person->kd_instansi,@$person->kd_organisasi,@$person->kd_satuan_organisasi);
- $get_d13 = $this->model->get_d1_satuan_kerja(@$person->kd_instansi,@$person->kd_organisasi,@$person->kd_satuan_organisasi,@$person->kd_unit_organisasi);
- $get_d14 = $this->model->get_d1_satuan_organisasi(@$person->kd_instansi,@$person->kd_organisasi,@$person->kd_satuan_organisasi,@$person->kd_unit_organisasi,@$person->kd_unit_kerja);
- $get_d15 = $this->model->get_d1_unit_organisasi(@$person->kd_instansi,@$person->kd_organisasi,@$person->kd_satuan_organisasi,@$person->kd_unit_organisasi,@$person->kd_unit_kerja,@$kd_unit_seksi);
- // field sma
- $get_sma1 = $this->model->get_sma_instansi(@$person->kd_instansi,@$person->kd_organisasi);
- $get_sma2 = $this->model->get_sma_organisasi(@$person->kd_instansi,@$person->kd_organisasi,@$person->kd_satuan_organisasi);
- $get_sma3 = $this->model->get_sma_satuan_kerja(@$person->kd_instansi,@$person->kd_organisasi,@$person->kd_satuan_organisasi,@$person->kd_unit_organisasi);
- $get_sma4 = $this->model->get_sma_satuan_organisasi(@$person->kd_instansi,@$person->kd_organisasi,@$person->kd_satuan_organisasi,@$person->kd_unit_organisasi,@$person->kd_unit_kerja);
- $get_sma5 = $this->model->get_sma_unit_organisasi(@$person->kd_instansi,@$person->kd_organisasi,@$person->kd_satuan_organisasi,@$person->kd_unit_organisasi,@$person->kd_unit_kerja,@$kd_unit_seksi);
- // field smp
- $get_smp1 = $this->model->get_smp_instansi(@$person->kd_instansi,@$person->kd_organisasi);
- $get_smp2 = $this->model->get_smp_organisasi(@$person->kd_instansi,@$person->kd_organisasi,@$person->kd_satuan_organisasi);
- $get_smp3 = $this->model->get_smp_satuan_kerja(@$person->kd_instansi,@$person->kd_organisasi,@$person->kd_satuan_organisasi,@$person->kd_unit_organisasi);
- $get_smp4 = $this->model->get_smp_satuan_organisasi(@$person->kd_instansi,@$person->kd_organisasi,@$person->kd_satuan_organisasi,@$person->kd_unit_organisasi,@$person->kd_unit_kerja);
- $get_smp5 = $this->model->get_smp_unit_organisasi(@$person->kd_instansi,@$person->kd_organisasi,@$person->kd_satuan_organisasi,@$person->kd_unit_organisasi,@$person->kd_unit_kerja,@$kd_unit_seksi);
- // field sd
- $get_sd1 = $this->model->get_sd_instansi(@$person->kd_instansi,@$person->kd_organisasi);
- $get_sd2 = $this->model->get_sd_organisasi(@$person->kd_instansi,@$person->kd_organisasi,@$person->kd_satuan_organisasi);
- $get_sd3 = $this->model->get_sd_satuan_kerja(@$person->kd_instansi,@$person->kd_organisasi,@$person->kd_satuan_organisasi,@$person->kd_unit_organisasi);
- $get_sd4 = $this->model->get_sd_satuan_organisasi(@$person->kd_instansi,@$person->kd_organisasi,@$person->kd_satuan_organisasi,@$person->kd_unit_organisasi,@$person->kd_unit_kerja);
- $get_sd5 = $this->model->get_sd_unit_organisasi(@$person->kd_instansi,@$person->kd_organisasi,@$person->kd_satuan_organisasi,@$person->kd_unit_organisasi,@$person->kd_unit_kerja,@$kd_unit_seksi);
- // field dokumen tidak lengkap
- $get_dokumen1 = $this->model->get_dokumen_instansi(@$person->kd_instansi,@$person->kd_organisasi);
- $get_dokumen2 = $this->model->get_dokumen_organisasi(@$person->kd_instansi,@$person->kd_organisasi,@$person->kd_satuan_organisasi);
- $get_dokumen3 = $this->model->get_dokumen_satuan_kerja(@$person->kd_instansi,@$person->kd_organisasi,@$person->kd_satuan_organisasi,@$person->kd_unit_organisasi);
- $get_dokumen4 = $this->model->get_dokumen_satuan_organisasi(@$person->kd_instansi,@$person->kd_organisasi,@$person->kd_satuan_organisasi,@$person->kd_unit_organisasi,@$person->kd_unit_kerja);
- $get_dokumen5 = $this->model->get_dokumen_unit_organisasi(@$person->kd_instansi,@$person->kd_organisasi,@$person->kd_satuan_organisasi,@$person->kd_unit_organisasi,@$person->kd_unit_kerja,@$kd_unit_seksi);
- $no++;
- $row = array();
- foreach ($get_s31 as $data_s3)
- {
- $s3 = @$data_s3->JML;
- }
- if($this->input->post('instansi')=='')
- {
- $nama = @$person->nama_organisasi;
- foreach ($get_s31 as $data_s3)
- {
- $s3 = @$data_s3->JML;
- }
- }
- else
- {
- if($this->input->post('instansi'))
- {
- $nama = @$person->nama_organisasi;
- foreach ($get_s31 as $data_s3)
- {
- $s3 = @$data_s3->JML;
- }
- }
- if($this->input->post('organisasi'))
- {
- $nama = @$person->nama_satuan_organisasi;
- foreach ($get_s32 as $data_s3)
- {
- $s3 = @$data_s3->JML;
- }
- }
- if($this->input->post('satuan_kerja'))
- {
- $nama = @$person->nama_unit_organisasi;
- foreach ($get_s33 as $data_s3)
- {
- $s3 = @$data_s3->JML;
- }
- }
- if($this->input->post('satuan_organisasi'))
- {
- $nama = @$person->nama_unit_kerja;
- foreach ($get_s34 as $data_s3)
- {
- $s3 = @$data_s3->JML;
- }
- }
- if($this->input->post('unit_organisasi'))
- {
- $nama = @$person->nama_unit_seksi;
- foreach ($get_s35 as $data_s3)
- {
- $s3 = @$data_s3->JML;
- }
- }
- }
- $row[] = '<center>'.$no.'</center>';
- $row[] = $nama;
- $row[] = $s3; // jumlah
- $row[] = ''; //
- $row[] = ''; //
- $row[] = ''; //
- $row[] = ''; //
- $row[] = ''; //
- $row[] = ''; //
- $row[] = ''; //
- $row[] = ''; //
- $row[] = ''; //
- $row[] = ''; //
- $row[] = ''; //
- $row[] = ''; //
- $row[] = ''; //
- $row[] = ''; //
- $row[] = ''; //
- $data[] = $row;
- }
- $output = array(
- "draw" => @$_POST['draw'],
- "recordsTotal" => $this->model->count_all(),
- "recordsFiltered" => $this->model->count_filtered(),
- "data" => $data,
- );
- //output to json format
- echo json_encode($output);
- }
- public function detail($id=NULL)
- {
- if (!$this->ion_auth->logged_in())
- {
- redirect('auth', 'refresh');
- }
- $user = $this->ion_auth->user()->row();
- $user_groups = $this->ion_auth->get_users_groups($user->id)->row();
- if($user_groups->id == 2)
- {
- $sekolah_id = $user->sekolah_id;
- }
- else
- {
- $sekolah_id = $id;
- }
- $this->breadcrumbs->push('<i class="fa fa-home"></i>', '/');
- $this->breadcrumbs->push('Laporan', '/laporan');
- $this->breadcrumbs->push('Detail', '/detail');
- $data['breadcrumbs'] = $this->breadcrumbs->show();
- $data['message'] = (validation_errors()) ? validation_errors() : $this->session->flashdata('message');
- $data['title'] = 'Laporan';
- $data['menu_active'] = 'Laporan';
- $data['get_data'] = $this->model->get_by_id($sekolah_id);
- $this->load->view('header', $data);
- $this->load->view('detail', $data);
- }
- public function upload_akta()
- {
- $config['upload_path'] = FCPATH.'/uploads/akta/';
- $config['allowed_types'] = 'pdf';
- $this->load->library('upload',$config);
- if($this->upload->do_upload('userfile')){
- $token=$this->input->post('token_foto');
- $nama=$this->upload->data('file_name');
- $this->db->insert('foto',array('nama_foto'=>$nama,'token'=>$token));
- }
- }
- public function set_session_detail($tahun_ajaran)
- {
- $array = array(
- 'id_tahun_ajaran' => $tahun_ajaran
- );
- $this->session->set_userdata( $array );
- redirect('laporan/detail');
- }
- public function load_organisasi_kerja($kd_instansi = null)
- {
- $kd_instansi = $_GET['instansi'];
- $get = $this->Ref_model->get_organisasi($kd_instansi)->result();
- $arr = array();
- foreach ($get as $row) {
- $arr[$row->kd_organisasi] = $row->nama_organisasi;
- }
- $arr[0] = 'Pilih Organisasi Kerja';
- //$get = array('Oke' => 'aja');
- $json = json_encode($arr);
- echo $json;
- }
- public function load_satuan_kerja($kd_organisasi = null)
- {
- $kd_organisasi = $_GET['organisasi'];
- $get = $this->Ref_model->get_satuan_kerja($kd_organisasi)->result();
- $arr = array();
- foreach ($get as $row) {
- $arr[$row->kd_satuan_organisasi] = $row->nama_satuan_organisasi;
- }
- $arr[0] = 'Pilih Satuan Kerja';
- //$get = array('Oke' => 'aja');
- $json = json_encode($arr);
- echo $json;
- }
- public function load_satuan_organisasi($kd_satuan_kerja = null)
- {
- $kd_satuan_kerja = $_GET['satuan_kerja'];
- $get = $this->Ref_model->get_satuan_organisasi($kd_satuan_kerja)->result();
- $arr = array();
- foreach ($get as $row) {
- $arr[$row->kd_unit_organisasi] = $row->nama_unit_organisasi;
- }
- $arr[0] = 'Pilih Satuan Organisasi';
- //$get = array('Oke' => 'aja');
- $json = json_encode($arr);
- echo $json;
- }
- public function load_unit_organisasi($kd_satuan_organisasi = null)
- {
- $kd_satuan_organisasi = $_GET['satuan_organisasi'];
- $get = $this->Ref_model->get_unit_organisasi($kd_satuan_organisasi)->result();
- $arr = array();
- foreach ($get as $row) {
- $arr[$row->kd_unit_kerja] = $row->nama_unit_kerja;
- }
- $arr[0] = 'Pilih Unit Organisasi';
- //$get = array('Oke' => 'aja');
- $json = json_encode($arr);
- echo $json;
- }
- public function load_unit_kerja($kd_unit_organisasi = null)
- {
- $kd_unit_organisasi = $_GET['unit_organisasi'];
- $get = $this->Ref_model->get_unit_kerja($kd_unit_organisasi)->result();
- $arr = array();
- foreach ($get as $row) {
- $arr[$row->kd_unit_seksi] = $row->nama_unit_seksi;
- }
- $arr[0] = 'Pilih Unit Kerja';
- //$get = array('Oke' => 'aja');
- $json = json_encode($arr);
- echo $json;
- }
- public function add()
- {
- if (!$this->ion_auth->logged_in() || !$this->ion_auth->is_admin())
- {
- redirect('auth', 'refresh');
- }
- $user = $this->ion_auth->user()->row();
- $user_data['id_menu'] = 1;
- $user_data['title'] = 'Form Tambah data Pegawai Management';
- $user_data['post_author'] = $user->id;
- $user_data['menu_active'] = 'Pages';
- $this->load->view('form',$user_data);
- }
- }
- /* End of file Beranda.php */
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement