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');
}
}
