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