public function laporan_berkala() { $c = new grocery_crud(); $c->set_table('dokumen_skt'); // if($this->glo_jenis_permo != ''){ $c->unset_operations(); $c->columns('bidang_jasa', 'no_dokumen', 'mulai_masa_berlaku', 'akhir_masa_berlaku', 'file_dokumen', 'pilihan'); $c->set_relation('id_permohonan', 'permohonan', 'id_permohonan'); $c->where('selesai', 2); $c->where('dokumen_skt.id_perusahaan', $this->session->userdata('id_perusahaan')); $c->field_type('id_perusahaan', 'hidden', $this->session->userdata('id_perusahaan')); $c->field_type('id_permohonan', 'hidden', $this->session->userdata('id_perusahaan')); $c->set_field_upload('file_dokumen', 'assets/uploads/file_skt'); $c->display_as('bidang_jasa', 'Bidang Jasa'); //$c->add_action('Proses', 'sd', 'perusahaan/proses_laporan/update','ui-icon-plus'); /* $c->add_action('(2) Buat Laporan', 'sd', 'perusahaan/proses_laporan/view','ui-icon-plus'); $c->add_action('(3) Upload Laporan ', 'sd', 'perusahaan/proses_laporan/proses','ui-icon-plus'); */ $c->callback_column('pilihan', function ($value, $row) { $pelaporan = $this->model->select('*', 'pelaporan_periodik', array('id_permohonan' => $row->id_permohonan, 'status_laporan' => 2), array('id_pelaporan_periodik', 'desc')); if ($pelaporan != NULL) { return '<a href="' . base_url() . 'perusahaan/proses_laporan/update/' . $row->id_permohonan . '">Proses</a> | Revisi <a class="link-pilih" title="Edit data" href="' . base_url() . 'perusahaan/edit_laporan_berkala/' . $row->id_permohonan . '"><img class="mybtn-edit"></a>'; } else { return '<a href="' . base_url() . 'perusahaan/proses_laporan/update/' . $row->id_permohonan . '">Proses</a>'; } }); $c->callback_column('bidang_jasa', function ($value, $row) { $ada = NULL; $data_permohonan = select('*', 'permohonan', array('id_permohonan' => $row->id_permohonan)); $bidang_usaha = select('*', 'ref_bidang_usaha', array('id_bidang_usaha' => $data_permohonan->bidang_usaha)); $sub_bidang = select('*', 'ref_sub_bidang', array('id_sub_bidang' => $data_permohonan->sub_bidang)); return $bidang_usaha->bidang_usaha . '/' . $sub_bidang->sub_bidang; }); $output = $c->render(); $this->logs(); $level = $this->session->userdata('level'); $status = $this->session->userdata('status_lap_periodik'); if ($level != NULL) { if ($level == 1 && $status == 1) { $this->load->view('level1/view_list', $output); } else { redirect('all_users/dashboard'); } } elseif ($level == NULL) { redirect('umum/logout'); } }
public function laporan_berkala() { $c = new grocery_crud(); $c->set_table('dokumen_skt'); // if($this->glo_jenis_permo != ''){ $c->unset_operations(); $c->columns('id_permohonan', 'no_dokumen', 'mulai_masa_berlaku', 'akhir_masa_berlaku', 'file_dokumen'); $c->where('dokumen_skt.id_perusahaan', $this->session->userdata('id_perusahaan')); $c->field_type('id_perusahaan', 'hidden', $this->session->userdata('id_perusahaan')); $c->set_field_upload('file_dokumen', 'assets/uploads/file_skt'); $c->display_as('id_permohonan', 'Bidang Jasa'); $c->add_action('Proses Laporan | ', 'sd', 'perusahaan/proses_laporan/proses', 'ui-icon-plus'); $c->add_action('Update Data | ', 'sd', 'perusahaan/proses_laporan/update', 'ui-icon-plus'); $c->add_action('View Data', 'sd', 'perusahaan/proses_laporan/view', 'ui-icon-plus'); $c->callback_column('id_permohonan', function ($value, $row) { $ada = NULL; $data_permohonan = select('*', 'permohonan', array('id_permohonan' => $value)); $bidang_usaha = select('*', 'ref_bidang_usaha', array('id_bidang_usaha' => $data_permohonan->bidang_usaha)); $sub_bidang = select('*', 'ref_sub_bidang', array('id_sub_bidang' => $data_permohonan->sub_bidang)); return $bidang_usaha->bidang_usaha . '/' . $sub_bidang->sub_bidang; }); //$c->set_relation('id_permohonan', 'ref_bidang_usaha', 'bidang_usaha'); // $c->set_relation('lokasi', 'ref_kota', 'kota', null, 'id_kota'); $output = $c->render(); $this->logs(); $level = $this->session->userdata('level'); if ($level != NULL) { if ($level == 1) { $this->load->view('level1/view_list', $output); } else { redirect('all_users/dashboard'); } } elseif ($level == NULL) { redirect('umum/logout'); } }
public function kotak_keluar() { $level = $this->session->userdata('level'); $c = new grocery_crud(); $c->set_table('disposisi'); $c->unset_operations(); $c->where('user_asal', $this->session->userdata('id_user')); $c->where('catatan_user_asal !=', ''); $c->columns('user_tujuan', 'id_perusahaan', 'tanggal_masuk', 'catatan_user_asal'); $c->set_relation('user_tujuan', 'users', 'nama_lengkap'); $c->set_relation('id_perusahaan', 'biodata_perusahaan', 'nama_perusahaan'); $c->display_as('user_tujuan', 'Untuk'); $c->display_as('id_perusahaan', 'Pengajuan Dari'); $c->display_as('catatan_user_asal', 'Pesan'); $output = $c->render(); if ($level != NULL) { if ($level != 1) { $this->load->view('semua/kotak_pesan', $output); } else { redirect('all_users/dashboard'); } } else { redirect('umum/logout'); } }