public function pelaporan_periodik($permohonan = NULL)
{
# code...
$c = new grocery_crud();
$c->set_table('pelaporan_periodik');
$c->set_field_upload('file_pelaporan_periodik', 'assets/uploads/file_pelaporan_periodik');
$c->columns('semester', 'file_pelaporan_periodik');
$c->fields('semester', 'id_permohonan', 'file_pelaporan_periodik');
$c->field_type('id_permohonan', 'hidden', $permohonan);
$c->where('id_permohonan', $permohonan);
$c->set_relation('semester', 'ref_semester', 'semester');
$output = $c->render();
$this->logs();
view('level1/view_list', $output);
if ($c->getState() != 'add') {
$c->change_field_type('semester', 'readonly');
}
// if ($c->getState() != 'list') {
// // $this->menej_ref($output);
// } else {
// return $output;
// }
}
public function pelaporan_periodik()
{
$c = new grocery_crud();
$c->set_table('pelaporan_periodik');
$permohonan = $this->session->userdata('id_permohonan');
$c->unset_delete();
$c->unset_read();
$c->unset_print();
$c->unset_export();
$c->unset_mytools();
$c->set_field_upload('file_pelaporan_periodik', 'assets/uploads/file_pelaporan_periodik');
$c->columns('semester', 'file_pelaporan_periodik', 'status_laporan');
$c->fields('semester', 'id_permohonan', 'file_pelaporan_periodik', 'id_evaluator', 'id_perusahaan', 'status_laporan', 'create_at', 'catatan_evaluator');
$c->field_type('id_permohonan', 'hidden', $permohonan);
$c->field_type('id_perusahaan', 'hidden', $this->session->userdata('id_perusahaan'));
$c->field_type('status_laporan', 'hidden', '1');
$c->field_type('create_at', 'hidden', strftime('%Y-%m-%d'));
$c->field_type('catatan_evaluator', 'hidden');
$c->callback_after_update(function ($post_array, $primary_key) {
$this->db->update('pelaporan_periodik', array('catatan_evaluator' => NULL), array('id_pelaporan_periodik' => $primary_key));
return TRUE;
});
$c->callback_column('status_laporan', function ($value, $row) {
if ($value == 1) {
return 'Diajukan';
} elseif ($value == 2) {
return 'Revisi | <a class="link-pilih" title="Edit data" href="' . base_url() . 'perusahaan/pelaporan_periodik/edit/' . $row->id_pelaporan_periodik . '"><img class="mybtn-edit"></a>';
} elseif ($value == 3) {
return 'Disetujui';
} elseif ($value == 4) {
return 'Ditolak';
}
});
$c->where('id_permohonan', $permohonan);
$c->set_relation('semester', 'ref_semester', 'semester', array('is_delete' => 0));
$sl_permohonan = select('user_tujuan', 'disposisi', array('id_permohonan' => $permohonan, 'status_progress' => 8), array('id_disposisi', 'DESC'));
$smohon = select('*', 'users', array('id_user' => $sl_permohonan->user_tujuan, 'level' => 6));
//$retVal = ($smohon) ? $smohon->id_user : 0 ;
$c->field_type('id_evaluator', 'hidden', $smohon->id_user);
$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');
}
if ($c->getState() != 'add') {
$c->change_field_type('semester', 'readonly');
if ($c->getState() == 'success') {
redirect('perusahaan/pelaporan_periodik');
}
}
}
public function lihat_catatan_evaluator()
{
$this->config->load('grocery_crud');
$this->config->set_item('grocery_crud_dialog_forms', true);
$this->config->set_item('grocery_crud_default_per_page', 10);
$this->load->config('grocery_crud');
$c = new grocery_crud();
$c->set_table('pelaporan_periodik');
$c->columns('catatan_evaluator', 'id_evaluator');
$c->set_relation('id_evaluator', 'users', 'nama_lengkap');
$c->fields('id_evaluator', 'catatan_evaluator');
$c->display_as('id_evaluator', 'Nama Evaluator');
//$c->field_type('id_evaluator', 'hidden');
$c->callback_field('catatan_evaluator', function ($value, $row) {
$isi = '<script>
$("#catatan_evaluator_display_as_box").remove();
$("div.crud-form div.mDiv div.ftitle").remove();
$("#cancel-button").remove();
$(".pDiv").css("border", "none");
$(".form-div").css("border", "none");
$("#id_evaluator_display_as_box").css({"width":"auto","margin-right":"7px"});
$(".ui-dialog-content").dialog( "option", "height", 430 );
$(".ui-dialog-content").dialog( "option", "width", 650 );';
if ($value != NULL) {
$isi .= 'CKEDITOR.replace( "content_template",
{
removePlugins: "toolbar",
height : 200,
width : 550,
tabSpaces : 4,
readOnly : true
});</script><hr style="margin-top:0px!important"/>
<textarea id="content_template" class="ckeditor">' . $value . '</textarea>';
} else {
$isi .= '</script><hr style="margin-top:0px!important"/><span><b>Tidak ada catatan</b></span>';
}
return $isi;
});
$c->set_crud_url_path(base_url(strtolower(__CLASS__ . "/" . __FUNCTION__)), base_url(strtolower(__CLASS__ . "/laporan_berkala_evaluator")));
$output = $c->render();
if ($c->getState() != 'read') {
redirect('all_admin/laporan_berkala_kasie');
} else {
$this->laporan_berkala_kasie($output);
}
}
public function ref_semester()
{
$c = new grocery_crud();
$c->set_table('ref_semester');
$c->unset_delete();
$c->unset_columns('is_delete');
$c->where('is_delete', 0);
$c->fields('semester');
$c->set_crud_url_path(base_url(strtolower(__CLASS__ . "/" . __FUNCTION__)), base_url(strtolower(__CLASS__ . "/menej_ref")));
$c->add_action('More', '', 'admin/soft_delete', 'delete-icon');
$output = $c->render();
if ($c->getState() != 'list') {
$this->menej_ref($output);
} else {
return $output;
}
}
public function tenaga_kerja()
{
$c = new grocery_crud();
$c->set_table('tenaga_kerja');
$c->where('tenaga_kerja.id_perusahaan', $this->session->userdata('id_perusahaan'));
$this->load->config('grocery_crud');
$this->config->set_item('grocery_crud_file_upload_allow_file_types', 'pdf');
//$c->unset_delete();
//$c->required_fields('nama_lengkap', 'status', 'jabatan', 'jenjang_pendidikan', 'jurusan_pendidikan', 'file_ijazah');
$c->fields('nama_lengkap', 'id_perusahaan', 'status', 'jabatan', 'jenjang_pendidikan', 'jurusan_pendidikan', 'file_ijazah', 'sertifikasi');
$c->set_crud_url_path(base_url(strtolower(__CLASS__ . "/" . __FUNCTION__)), base_url(strtolower(__CLASS__ . "/data_tenaga_kerja")));
//field type
$c->field_type('id_perusahaan', 'hidden', $this->session->userdata('id_perusahaan'));
$c->field_type('status', 'enum', array('Permanen', 'Non Permanen'));
$c->set_field_upload('file_ijazah', 'assets/uploads/file_ijazah_tenaga_ahli');
$c->field_type('id_permohonan', 'hidden', $this->session->userdata('id_permohonan'));
// unset field
$c->unset_fields('id_sub_bidang', 'catatan_petugas', 'status_pemakaian');
// unset columns
$c->unset_columns('id_perusahaan', 'catatan_petugas', 'id_permohonan', 'status_pemakaian', 'sertifikasi');
// set relation
$c->set_relation('jenjang_pendidikan', 'ref_jenjang_pendidikan', 'jenjang_pendidikan', null, 'id_jenjang_pendidikan');
$c->callback_field('sertifikasi', array($this, 'callback_sertifikasi'));
// display as
$c->display_as('jenjang_pendidikan', 'Pendidikan Terakhir');
$c->display_as('jurusan_pendidikan', 'Jurusan');
$c->display_as('jabatan', 'Keahlian');
$c->display_as('status', 'Status Kepegawaian');
$c->callback_after_insert(array($this, 'callback_before_insert_or_update'));
$output = $c->render();
$this->logs();
if ($c->getState() != 'list') {
$this->data_tenaga_kerja($output);
} else {
return $output;
}
}
