function tablaprestamo($primary_key, $valor, $valor1)
{
global $variableGlobal, $registro;
$variableGlobal = $primary_key;
$registro = urldecode($valor);
$fecha = date("Y/m/d");
$crud = new grocery_crud();
$crud->set_table('prestamo');
$crud->set_subject('Prestamos');
$crud->display_as('datos', 'Datos del libro')->display_as('idUsuario', 'Nombre de Usuario');
$crud->unset_edit();
$crud->unset_delete();
$crud->unset_print();
$crud->unset_export();
$crud->field_type('idLibro', 'hidden', $variableGlobal);
$crud->callback_add_field('datos', array($this, 'recuperaDatos'));
$crud->set_relation('idUsuario', 'usuario_biblioteca', '{nombre} {apellidos}');
$crud->field_type('fecha_entrega', 'hidden', $this->calculaFecha("days", 14, $fecha));
$crud->callback_after_insert(array($this, 'actualizarPrestamo'));
$output = $crud->render();
$this->_example_output($output);
}
public function tenaga_kerja()
{
$c = new grocery_crud();
$c->set_table('tenaga_kerja');
// if($this->glo_jenis_permo != ''){
// $c->unset_delete();
// // $c->unset_read();
// $c->unset_edit();
$sl_permohonan = select('*', 'permohonan', array('id_permohonan' => $this->session->userdata('id_permohonan'), 'selesai' => 2));
if (!$sl_permohonan) {
$c->unset_delete();
$c->unset_edit();
}
$c->columns('nama_lengkap', 'status', 'jabatan', 'jenjang_pendidikan', 'jurusan_pendidikan', 'file_ijazah', 'status_pemakaian');
$c->callback_column('status_pemakaian', function ($value, $row) {
$ada = NULL;
$cek_if_has_data_permohonan = select('status_pemakaian', 'tenaga_kerja', array('id_perusahaan' => $this->session->userdata('id_perusahaan'), 'id_tenaga_kerja' => $row->id_tenaga_kerja));
$temp = explode(',', $cek_if_has_data_permohonan->status_pemakaian);
if ($cek_if_has_data_permohonan != NULL) {
foreach ($temp as $key => $status_pemakaian) {
if ($status_pemakaian == $this->session->userdata('id_permohonan')) {
$ada = 'ada';
}
}
}
if ($ada != NULL) {
return 'Dipilih';
} else {
return '';
}
});
$c->add_action('Pilih', base_url('assets/grocery_crud/themes/flexigrid/css/images/success.png'), 'perusahaan/pilih/data_tenaga_kerja/tenaga_kerja', 'ui-icon-plus', function ($primary_key, $row) {
$ada = NULL;
$cek_if_has_data_permohonan = select('status_pemakaian', 'tenaga_kerja', array('id_perusahaan' => $this->session->userdata('id_perusahaan'), 'id_tenaga_kerja' => $primary_key));
$temp = explode(',', $cek_if_has_data_permohonan->status_pemakaian);
if ($cek_if_has_data_permohonan != NULL) {
foreach ($temp as $key => $status_pemakaian) {
if ($status_pemakaian == $this->session->userdata('id_permohonan')) {
$ada = 'ada';
}
}
}
if ($ada != NULL) {
return base_url('perusahaan/ganti') . '/data_tenaga_kerja/tenaga_kerja/' . $primary_key;
} else {
return base_url('perusahaan/pilih') . '/data_tenaga_kerja/tenaga_kerja/' . $primary_key;
}
});
// }
$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', 'no_imta', 'file_imta', '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->set_field_upload('file_imta', 'assets/uploads/file_imta');
$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', 'Jabatan/Keahlian');
$c->display_as('status', 'Status Kepegawaian');
$c->display_as('status_pemakaian', 'Status');
$c->display_as('no_imta', 'No IMTA *)');
$c->callback_field('no_imta', array($this, 'callback_no_imta'));
$c->display_as('file_imta', 'File IMTA');
$c->callback_after_insert(array($this, 'callback_before_insert_or_update'));
if ($c->getState() == 'read') {
$c->fields('sertifikasi');
$c->callback_field('sertifikasi', array($this, 'callback_read_sertifikasi'));
}
$output = $c->render();
$this->logs();
if ($c->getState() != 'list') {
$this->data_tenaga_kerja($output);
} else {
return $output;
}
}
public function pengajuan_skt_diterima_naik()
{
// merubah status_user menjadi dokumen lengkap
$c = new grocery_crud();
$c->set_table('disposisi');
//$c->unset_delete();
$c->unset_edit();
$last_disposisi = $this->model->select('*', 'disposisi', array('id_disposisi' => $this->uri->segment(4)));
$level = $this->session->userdata('level');
$c->field_type('user_asal', 'hidden', $this->session->userdata('id_user'));
$c->field_type('id_parent', 'hidden', $last_disposisi->id_disposisi);
// /$c->field_type('catatan', 'text');
$c->display_as('id_perusahaan', 'nama perusahaan');
//lagi di level 2 didisposisi ke level 4
if ($level == 6) {
$c->field_type('status_progress', 'hidden', '9');
} elseif ($level == 5) {
# code...
$c->field_type('status_progress', 'hidden', '11');
} elseif ($level == 4) {
$c->field_type('status_progress', 'hidden', '12');
} elseif ($level == 3) {
$c->field_type('status_progress', 'hidden', '13');
}
//untuk polih user tujuan
if ($level == 6) {
$level = 5;
} elseif ($level == 5) {
$level = 4;
} elseif ($level == 4) {
$level = 3;
} elseif ($level == 3) {
$level = 2;
}
$l4 = $this->model->selects('*', 'users', array('level' => $level));
foreach ($l4 as $key => $l4o) {
# code...
$ListUser = array($l4o->id_user => $l4o->nama_lengkap);
}
$c->field_type('user_tujuan', 'dropdown', $ListUser);
$c->set_relation('id_perusahaan', 'biodata_perusahaan', 'nama_perusahaan', array('id_perusahaan' => $last_disposisi->id_perusahaan));
$c->unset_fields('tanggal_masuk', 'tanggal_selesai', 'nilai', 'catatan', 'id_permohonan');
$c->callback_after_insert(array($this, 'update_pengajuan_skt_diterima_naik'));
$output = $c->render();
$state = $c->getState();
$state_info = $c->getStateInfo();
if ($state == 'success') {
$level = $this->session->userdata('level');
if ($level == 6) {
redirect('all_admin/konsep_dokumen_skt/add/' . $this->uri->segment(4));
} elseif ($level == 5) {
redirect('all_admin/no_dokumen_skt/add/' . $this->uri->segment(4));
} else {
redirect(base_url('all_admin/daftar_pengajuan_skt_admin_naik'));
}
}
$level = $this->session->userdata('level');
if ($level != NULL) {
$this->load->view('level' . $level . '/view_list', $output);
} elseif ($level == NULL) {
redirect('umum/logout');
}
}
public function callback_after_insert($callback = null, $override_all = 0)
{
if (!$override_all) {
$this->callback_after_insert_ext[] = $callback;
if ($this->callback_after_insert == null) {
$this->callback_after_insert = array($this, 'extended_callback_after_insert');
}
} else {
parent::callback_after_insert($callback);
}
return $this;
}
public function pengajuan_skp_diterima_naik()
{
// merubah status_user menjadi dokumen lengkap
$c = new grocery_crud();
$c->set_table('disposisi');
//$c->unset_delete();
$c->unset_edit();
$last_disposisi = $this->model->select('*', 'disposisi', array('id_permohonan' => $this->uri->segment(4)), array('id_disposisi', 'desc'));
$level = $this->session->userdata('level');
$c->fields('user_asal', 'id_parent', 'status_progress', 'id_perusahaan', 'user_tujuan', 'id_permohonan', 'catatan_user_asal');
$c->field_type('id_permohonan', 'hidden', $this->uri->segment(4));
$c->field_type('user_asal', 'hidden', $this->session->userdata('id_user'));
$c->field_type('id_parent', 'hidden', $last_disposisi->id_disposisi);
// $c->field_type('catatan', 'text');
$c->required_fields('user_tujuan', 'id_perusahaan');
$c->display_as('catatan_user_asal', 'Catatan');
$c->display_as('id_perusahaan', 'nama perusahaan');
//lagi di level 2 didisposisi ke level 4
if ($level == 6) {
$c->field_type('status_progress', 'hidden', '9');
$tujuan = 5;
} elseif ($level == 5) {
$c->field_type('status_progress', 'hidden', '11');
$tujuan = 4;
} elseif ($level == 4) {
$c->field_type('status_progress', 'hidden', '12');
$tujuan = 3;
} elseif ($level == 3) {
$c->field_type('status_progress', 'hidden', '13');
$tujuan = 7;
}
$c->set_relation('user_tujuan', 'users', 'nama_lengkap', array('level' => $tujuan));
$c->set_relation('id_perusahaan', 'biodata_perusahaan', 'nama_perusahaan', array('id_perusahaan' => $last_disposisi->id_perusahaan));
$c->callback_after_insert(array($this, 'update_pengajuan_skt_diterima_naik'));
$output = $c->render();
$state = $c->getState();
$state_info = $c->getStateInfo();
if ($state == 'success') {
$level = $this->session->userdata('level');
if ($level == 6) {
$dok_pendukung = $this->model->select('*', 'dokumen_pendukung_pjit', array('id_permohonan' => ''));
redirect('all_admin/konsep_dokumen_skp/add/' . $this->uri->segment(4));
} elseif ($level == 5) {
redirect(site_url('all_admin/daftar_pengajuan_skp_admin_naik'));
} elseif ($level == 7) {
$dokumenskt = select('*', 'disposisi', array('id_disposisi' => $this->uri->segment(4)));
$id_dokumenskt = select('*', 'dokumen_skt', array('id_permohonan' => $dokumenskt->id_permohonan));
redirect('all_admin/no_dokumen_skp/edit/' . $id_dokumenskt->id_dokumen);
} else {
redirect(base_url('all_admin/daftar_pengajuan_skp_admin_naik'));
}
}
$level = $this->session->userdata('level');
if ($level != NULL) {
$this->load->view('level' . $level . '/view_list', $output);
} elseif ($level == NULL) {
redirect('umum/logout');
}
}
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;
}
}
public function pengajuan_skt_diterima_dtlm($id_perusahaan = NULL)
{
// merubah status_user menjadi dokumen lengkap
$c = new grocery_crud();
$c->set_table('disposisi');
//$c->unset_delete();
$c->unset_edit();
// $c->field_type('id_perusahaan', 'hidden', $id_perusahaan);
$last_disposisi = $this->model->select('*', 'disposisi', array('id_perusahaan' => $this->uri->segment(4)));
$c->field_type('user_asal', 'hidden', $this->session->userdata('id_user'));
$c->field_type('id_parent', 'hidden', $last_disposisi->id_disposisi);
$c->field_type('catatan', 'text');
$c->display_as('id_perusahaan', 'nama_perusahaan');
$query = $this->db->query('SELECT * FROM users WHERE level=4 AND status=1')->result_array();
foreach ($query as $key => $row) {
$listDtlm = array($row['id_user'] => $row['nama_lengkap']);
}
$c->field_type('user_tujuan', 'dropdown', $listDtlm);
$c->set_relation('id_perusahaan', 'biodata_perusahaan', 'nama_perusahaan', array('id_perusahaan' => $this->uri->segment(4)));
$c->unset_fields('tanggal_masuk', 'tanggal_selesai');
$c->callback_after_insert(array($this, 'update_pengajuan_skt_diterima'));
$output = $c->render();
$state = $c->getState();
$state_info = $c->getStateInfo();
if ($state == 'success') {
redirect(base_url('hal/daftar_pengajuan_skt_baru_admin'));
}
$this->load->view('level2/view_list', $output);
}
