public function index() { $crud = new grocery_crud(); $crud->set_table('usuario_biblioteca'); $crud->set_subject('Usuarios'); $crud->required_fields('nombre', 'apellidos', 'telefono', 'direccion', 'correo', 'tipo_credencial'); $crud->display_as('nombre', 'Nombre')->display_as('apellidos', 'Apellidos')->display_as('telefono', 'Telefono')->display_as('direccion', 'Direccion')->display_as('correo', 'E-mail')->display_as('tipo_credencial', 'Tipo credencial')->display_as('contrasena', 'Contraseña'); $output = $crud->render(); $this->_example_output($output); }
public function registrasi() { $this->config->load('grocery_crud'); $this->config->set_item('grocery_crud_file_upload_allow_file_types', 'pdf'); $this->config->set_item('grocery_crud_file_upload_max_file_size', '200KB'); $c = new grocery_crud(); $c->set_table('registrasi'); // $c->unset_back_to_list(); $c->unset_edit(); //$c->unset_delete(); $c->unset_read(); $c->unset_list(); if ($this->uri->segment(2) == 'registrasi' && $this->uri->segment(3) == NULL) { redirect($this->router->fetch_class() . '/' . $this->router->fetch_method() . '/add'); } $c->set_rules('email', 'Email', 'required|valid_email'); // unset field // $c->unset_fields('tanggal_member', 'pengajuan', ''); $c->unset_fields('tanggal_member', 'pengajuan', 'file_surat_pernyataan'); $c->field_type('deskripsi_perusahaan', 'text'); $c->field_type('alamat', 'text'); $c->callback_add_field('syarat_ketentuan', function () { return '<input type="radio" maxlength="50" value="1" name="syarat_ketentuan"> Dengan mencetang tanda ini berarti Anda telah menyetujui syarat & ketentuan yang berlaku'; }); $c->display_as('surat_ket_domisili', 'Nomor Surat Keterangan Domisili'); $c->display_as('siup', 'Nomor SIUP/Perizinan Lainnya'); $c->display_as('npwp', 'Nomor NPWP'); $c->display_as('file_siup', 'SIUP/Perizinan Lainnya'); $c->display_as('file_surat_ket_domisili', 'Surat Keterangan Domisili'); $c->unset_texteditor('deskripsi_perusahaan', 'full_text'); $c->unset_texteditor('alamat', 'full_text'); $this->load->config('grocery_crud'); $this->config->set_item('grocery_crud_file_upload_allow_file_types', 'pdf'); $c->set_field_upload('file_surat_ket_domisili', 'assets/uploads/file_register'); $c->set_field_upload('file_siup', 'assets/uploads/file_register'); $c->required_fields('syarat_ketentuan', 'nama_perusahaan', 'direktur_utama', 'contact_person', 'email', 'alamat', 'provinsi', 'kota', 'npwp', 'akte_perusahaan', 'siup', 'file_akte', 'file_siup'); $c->set_relation('kota', 'ref_kota', 'kota'); $c->set_relation('provinsi', 'ref_provinsi', 'provinsi'); $c->callback_field('email', function ($value, $row) { return '<input type="text" value="' . $value . '" name="email" id="field-email"> <span style="color:red; font-size:10px">*) Pastikan alamat email yang Anda masukkan valid</span>'; }); //$c->callback_insert(array($this, 'after_registrasi')); if ($this->uri->segment(3) == 'success') { redirect('umum/after_registrasi'); } $output = $c->render(); $state = $c->getState(); $state_info = $c->getStateInfo(); $this->logs(); $this->load->view('umum/registrasi', $output); }
function admi() { $crud = new grocery_crud(); $crud->set_table('libro'); $crud->set_subject('Libros'); $crud->required_fields('clasificacion', 'titulo', 'autor', 'editorial', 'cantidad'); $crud->columns('clasificacion', 'titulo', 'autor', 'editorial', 'ISBN', 'cantidad', 'cantidadDisponible', 'estado'); $crud->display_as('cantidadDisponible', 'Libros Disponibles')->display_as('cantidad', 'Libros en Biblioteca'); $crud->add_fields('clasificacion', 'titulo', 'autor', 'editorial', 'cantidad', 'ISBN', 'estado'); $crud->edit_fields('clasificacion', 'titulo', 'autor', 'editorial', 'cantidad', 'ISBN', 'estado'); $crud->add_action('Prestamos', 'http://www.fancyicons.com/free-icons/155/quartz/png/16/books_16.png', '', '', array($this, 'just_a_test')); $output = $crud->render(); $this->_example_outputADM($output); }
public function csr() { $c = new grocery_crud(); $c->set_table('csr'); // 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_read(); $c->unset_edit(); } $c->columns('kegiatan', 'waktu', 'lokasi'); $c->callback_column('status', function ($value, $row) { $ada = NULL; $cek_if_has_data_permohonan = select('status_pemakaian', 'csr', array('id_perusahaan' => $this->session->userdata('id_perusahaan'), 'id_csr' => $row->id_csr)); $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/csr/csr', 'ui-icon-plus', function ($primary_key, $row) { $ada = NULL; $cek_if_has_data_permohonan = select('status_pemakaian', 'csr', array('id_perusahaan' => $this->session->userdata('id_perusahaan'), 'id_csr' => $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') . '/csr/csr/' . $primary_key; } else { return base_url('perusahaan/pilih') . '/csr/csr/' . $primary_key; } }); // } $c->where('id_perusahaan', $this->session->userdata('id_perusahaan')); $c->required_fields('kegiatan', 'waktu', 'lokasi'); $c->set_relation('lokasi', 'ref_kota', 'kota', null, 'id_kota'); $c->field_type('id_perusahaan', 'hidden', $this->session->userdata('id_perusahaan')); $c->set_field_upload('file_csr', 'assets/uploads/file_csr'); $c->unset_fields('catatan_petugas', 'status_pemakaian'); //$c->unset_columns('id_perusahaan', 'catatan_petugas', 'status_pemakaian'); $c->display_as('file_csr', 'File CSR'); //$c->unset_delete(); $output = $c->render(); $this->logs(); $level = $this->session->userdata('level'); if ($level != NULL) { if ($level == 1) { $this->load->view('level1/skt_tabel', $output); } else { redirect('all_users/dashboard'); } } elseif ($level == NULL) { redirect('umum/logout'); } }
function tabla() { $fecha = date("Y/m/d"); $crud = new grocery_crud(); $crud->set_table('prestamo'); $crud->set_subject('Prestamos'); $crud->required_fields('Fecha_salida', 'Fecha_entrega'); $crud->display_as('idUsuario', 'Nombre de Usuario')->display_as('idLibro', 'Nombre del libro'); $crud->columns('idLibro', 'idUsuario', 'fecha_salida', 'fecha_entrega'); $crud->add_action('Entrega', 'https://cdn3.iconfinder.com/data/icons/musthave/16/Check.png', '', '', array($this, 'redirigir')); $crud->unset_add(); $crud->unset_edit(); $crud->unset_delete(); $crud->unset_print(); $crud->unset_export(); $crud->set_relation('idLibro', 'libro', 'titulo'); $crud->set_relation('idUsuario', 'usuario_biblioteca', '{nombre} {apellidos}'); $crud->field_type('fecha_salida', 'hidden', $fecha); $output = $crud->render(); $this->_example_output($output); }
public function csr() { $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('csr'); $sl_permohonan = select('*', 'permohonan', array('id_permohonan' => $this->session->userdata('id_permohonan'), 'selesai' => 2)); $c->columns('kegiatan', 'waktu', 'lokasi', 'action'); if (!$this->session->userdata('laporan_berkala') == 'aktif') { $c->unset_delete(); // $c->unset_edit(); $c->unset_read(); } $c->callback_column('action', function ($value, $row) { $ada = NULL; $cek_if_has_data_permohonan = select('status_pemakaian', 'csr', array('id_perusahaan' => $this->session->userdata('id_perusahaan'), 'id_csr' => $row->id_csr)); $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 '<a class="link-pilih" href="' . base_url() . 'perusahaan/ganti/csr/csr/' . $row->id_csr . '" title="Klik untuk merubah"><img class="btn-pilih">Dipilih</a>'; } else { return '<a class="link-pilih" href="' . base_url() . 'perusahaan/pilih/csr/csr/' . $row->id_csr . '" title="Klik untuk merubah"><img class="btn-ganti">Tidak Dipilih</a>'; } }); $c->where('id_perusahaan', $this->session->userdata('id_perusahaan')); $c->required_fields('kegiatan', 'waktu', 'lokasi'); $c->fields('id_perusahaan', 'kegiatan', 'waktu', 'lokasi', 'skrip_waktu'); // $c->set_relation('lokasi', 'ref_kota', 'kota', null, 'id_kota'); $c->field_type('id_perusahaan', 'hidden', $this->session->userdata('id_perusahaan')); $c->set_field_upload('file_csr', 'assets/uploads/file_csr'); //$c->unset_fields('catatan_petugas', 'status_pemakaian'); $c->callback_field('lokasi', array($this, 'callback_daftar_lokasi')); $c->field_type('skrip', 'hidden'); $c->callback_field('skrip_waktu', function ($value, $row) { $output = '<script> $("#skrip_waktu_display_as_box").remove(); $(".ui-dialog-content").dialog( "option", "height", 350 ); $("#skrip_waktu_field_box").remove();$( "#field-waktu" ).datepicker({ yearRange: "' . (date('Y') - 110) . ':' . date('Y') . '", changeMonth: true, changeYear: true });</script>'; return $output; }); //$c->unset_columns('id_perusahaan', 'catatan_petugas', 'status_pemakaian'); $c->display_as('file_csr', 'File CSR'); //$c->unset_delete(); $output = $c->render(); $this->logs(); $level = $this->session->userdata('level'); if ($level != NULL) { if ($level == 1) { if ($c->getState() == 'add') { redirect('perusahaan/csr'); } else { $this->load->view('level1/skt_tabel', $output); } } else { redirect('all_users/dashboard'); } } elseif ($level == NULL) { redirect('umum/logout'); } }
public function no_dokumen_skt($da = NULL, $id = NULL) { // echo $da; $id_per = $this->model->select('id_perusahaan', 'disposisi', array('id_disposisi' => $id)); $c = new grocery_crud(); $c->set_table('dokumen_skt'); // $c->unset_fields('no_dokumen', 'deskripsi', 'mulai_masa_berlaku', 'akhir_masa_berlaku', 'id_permohonan', 'status'); $c->unset_fields('status', 'id_permohonan', 'file_dokumen'); // $c->set_field_upload('file_dokumen','assets/uploads/file_skt'); $c->required_fields('no_dokumen', 'mulai_masa_berlaku', 'akhir_masa_berlaku'); if ($id_per != NULL) { $id_per = $id_per->id_perusahaan; } else { $id_per = ''; } $c->field_type('id_perusahaan', 'hidden', $id_per); $output = $c->render(); $state = $c->getState(); $state_info = $c->getStateInfo(); if ($state == 'success') { redirect(site_url('all_admin/daftar_pengajuan_skt_admin_naik')); } $level_user = $this->session->userdata('level'); $this->load->view('level' . $level_user . '/view_list', $output); }
public function menej_pengumuman() { $c = new grocery_crud(); $c->set_table('pengumuman'); $c->unset_fields('tanggal_terbit'); $c->unset_columns('penulis'); $c->required_fields('judul', 'isi'); $c->order_by('id_pengumuman', 'DESC'); $c->field_type('penulis', 'hidden', $this->session->userdata('nama_user_online')); $output = $c->render(); $this->logs(); $level = $this->session->userdata('level'); if ($level != NULL) { if ($level == 9 || $level == 8) { $this->load->view('level' . $level . '/manage_pengumuman', $output); } else { redirect('all_users/dashboard'); } } elseif ($level == NULL) { redirect('umum/logout'); } }
public function laporan_berkala_kasie() { $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->where('id_kasie', $this->session->userdata('id_user')); $c->where('status_laporan', 1); $c->or_where('id_kasie', NULL); $c->or_where('status_laporan', 2); $c->columns('id_perusahaan', 'no_skt', 'bidang_usaha', 'semester', 'file_pelaporan_periodik', 'catatan_evaluator', 'status_laporan', 'aksi'); $c->field_type('id_permohonan', 'hidden'); $c->field_type('id_kasie', 'hidden', $this->session->userdata('id_user')); $c->set_relation('id_perusahaan', 'biodata_perusahaan', 'nama_perusahaan'); $c->set_relation('id_evaluator', 'users', 'nama_lengkap', array('level' => 6)); $c->fields('file_pelaporan_periodik', 'id_permohonan', 'semester', 'id_perusahaan', 'id_kasie', 'id_evaluator'); $c->required_fields('file_pelaporan_periodik', 'id_permohonan', 'semester', 'id_perusahaan', 'id_kasie', 'id_evaluator'); $c->edit_fields('id_evaluator', 'id_kasie', 'skrip'); $c->set_field_upload('file_pelaporan_periodik', 'assets/uploads/file_pelaporan_periodik'); $c->unset_delete(); //$c->unset_edit(); //$c->unset_read(); $c->unset_add(); $c->unset_export(); $c->unset_print(); $c->callback_field('skrip', function ($value, $row) { return '<script> $("#skrip_display_as_box").remove(); $("div.crud-form div.mDiv div.ftitle").remove(); $(".ptogtitle").remove(); $(".pDiv").css("border", "none"); $(".form-div").css("border", "none"); $(".ui-dialog-content").dialog( "option", "height", 250 ); $(".ui-dialog-content").dialog( "option", "width", 650 ); $("#save-and-go-back-button").attr("value", "Submit"); $("#form-button-save").remove(); $("#cancel-button").remove(); </script>'; }); $c->unset_mytools(); $c->callback_column('aksi', function ($value, $row) { return '<div style="text-align:center; margin: 0px !important"><a class="link-pilih edit-anchor edit_button" title="Lihat Catatan Evaluator" href="' . base_url() . 'all_admin/lihat_catatan_evaluator/read/' . $row->id_pelaporan_periodik . '">Detail Evaluasi</a> | <a class="link-pilih edit-anchor edit_button" title="Tugaskan evaluator" href="' . base_url() . 'all_admin/laporan_berkala_kasie/edit/' . $row->id_pelaporan_periodik . '">Tugaskan</a> | <a class="link-pilih" title="Lihat detail laporan" href="' . base_url() . 'all_admin/detail_perusahaan/laporan_berkala_kasie/' . $row->id_permohonan . '">Lihat detail </a><hr style="margin: 6px 0px 6px 0px; border: 0; border-top: 1px solid #BDC3C7;"/> <a class="link-pilih" title="Revisi laporan" href="' . base_url() . 'all_admin/aksi_kasie/revisi/' . $row->id_pelaporan_periodik . '">Revisi</a> | <a class="link-pilih" title="Terima Laporan" href="' . base_url() . 'all_admin/aksi_kasie/terima/' . $row->id_pelaporan_periodik . '">Terima</a> | <a class="link-pilih" title="Tolak Laporan" href="' . base_url() . 'all_admin/aksi_kasie/tolak/' . $row->id_pelaporan_periodik . '">Tolak</a></div>'; }); $c->callback_column('status_laporan', function ($value, $row) { if ($value == 1 && $row->id_evaluator != NULL && $row->catatan_evaluator == NULL) { return '<span style="background-color:#F7CA18; color:#fff; border-radius:3px; padding: 0px 2px 0px 2px;">Belum Dievaluasi</span>'; } elseif ($value == 1 && $row->id_evaluator != NULL && $row->catatan_evaluator != NULL) { return '<span style="background-color:#3498DB; color:#fff; border-radius:3px; padding: 0px 2px 0px 2px;">Sudah Dievaluasi</span>'; } elseif ($value == 2) { return '<span style="background-color:#6C7A89; color:#fff; border-radius:3px; padding: 0px 2px 0px 2px;">Direvisi</span>'; } }); $c->unset_columns('action', 'pilihan'); $c->callback_column('no_skt', function ($value, $row) { $dok_skt = $this->model->select('*', 'dokumen_skt', array('id_permohonan' => $row->id_permohonan)); return $dok_skt->no_dokumen; }); $c->callback_column('bidang_usaha', function ($value, $row) { $permohonan = $this->model->select('*', 'permohonan', array('id_permohonan' => $row->id_permohonan)); $bidang_usaha = select('*', 'ref_bidang_usaha', array('id_bidang_usaha' => $permohonan->bidang_usaha)); $sub_bidang = select('*', 'ref_sub_bidang', array('id_sub_bidang' => $permohonan->sub_bidang)); return $bidang_usaha->bidang_usaha . ' /<br/>' . $sub_bidang->sub_bidang; }); $c->display_as('id_perusahaan', 'Perusahaan'); $c->display_as('bidang_usaha', 'Bidang & Sub Bidang'); $c->display_as('no_skt', 'No SKT'); $c->display_as('file_pelaporan_periodik', 'File Laporan'); $c->display_as('id_evaluator', 'Nama Evaluator'); $c->display_as('catatan_evaluator', 'Hasil Evaluasi'); $c->set_crud_url_path(base_url(strtolower(__CLASS__ . "/" . __FUNCTION__)), base_url(strtolower(__CLASS__ . "/laporan_berkala_kasie"))); $c->set_lang_string('update_success_message', 'Data Anda berhasil disimpan. <script type="text/javascript"> window.location = "' . site_url(strtolower(__CLASS__) . '/' . strtolower(__FUNCTION__)) . '"; </script> <div style="display:none"> '); $output = $c->render(); $this->logs(); if ($c->getState() != 'read') { $c->fields('file_pelaporan_periodik', 'id_permohonan', 'semester', 'id_perusahaan'); } if ($c->getState() != 'edit' && $c->getState() != 'list') { redirect('all_admin/laporan_berkala_kasie'); } else { $this->load->view('level5/laporan_berkala_kasie', $output); } }
public function csr() { $c = new grocery_crud(); $c->set_table('csr'); $c->where('id_perusahaan', $this->session->userdata('id_perusahaan')); $c->required_fields('kegiatan', 'waktu', 'lokasi'); $c->set_relation('lokasi', 'ref_kota', 'kota', null, 'id_kota'); $c->field_type('id_perusahaan', 'hidden', $this->session->userdata('id_perusahaan')); $c->set_field_upload('file_csr', 'assets/uploads/file_csr'); $c->unset_fields('catatan_petugas', 'status_pemakaian'); $c->unset_columns('id_perusahaan', 'catatan_petugas', 'status_pemakaian'); $c->display_as('file_csr', 'File CSR'); //$c->unset_delete(); $output = $c->render(); $this->logs(); $level = $this->session->userdata('level'); if ($level != NULL) { if ($level == 1) { $this->load->view('level1/skt_tabel', $output); } else { redirect('all_users/dashboard'); } } elseif ($level == NULL) { redirect('umum/logout'); } }
public function csr() { $c = new grocery_crud(); $c->set_table('csr'); $sl_permohonan = select('*', 'permohonan', array('id_permohonan' => $this->session->userdata('id_permohonan'), 'selesai' => 2)); $c->columns('kegiatan', 'waktu', 'lokasi', 'action'); if (!$this->session->userdata('laporan_berkala') == 'aktif') { $c->unset_delete(); // $c->unset_edit(); $c->unset_read(); } $c->callback_column('action', function ($value, $row) { $ada = NULL; $cek_if_has_data_permohonan = select('status_pemakaian', 'csr', array('id_perusahaan' => $this->session->userdata('id_perusahaan'), 'id_csr' => $row->id_csr)); $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 '<a class="link-pilih" href="' . base_url() . 'perusahaan/ganti/csr/csr/' . $row->id_csr . '"><img class="btn-ganti">Ubah</a>'; } else { return '<a class="link-pilih" href="' . base_url() . 'perusahaan/pilih/csr/csr/' . $row->id_csr . '"><img class="btn-pilih">Pilih</a>'; } }); $c->where('id_perusahaan', $this->session->userdata('id_perusahaan')); $c->required_fields('kegiatan', 'waktu', 'lokasi'); // $c->set_relation('lokasi', 'ref_kota', 'kota', null, 'id_kota'); $c->field_type('id_perusahaan', 'hidden', $this->session->userdata('id_perusahaan')); $c->set_field_upload('file_csr', 'assets/uploads/file_csr'); $c->unset_fields('catatan_petugas', 'status_pemakaian'); //$c->unset_columns('id_perusahaan', 'catatan_petugas', 'status_pemakaian'); $c->display_as('file_csr', 'File CSR'); //$c->unset_delete(); $output = $c->render(); $this->logs(); $level = $this->session->userdata('level'); if ($level != NULL) { if ($level == 1) { $this->load->view('level1/skt_tabel', $output); } else { redirect('all_users/dashboard'); } } elseif ($level == NULL) { redirect('umum/logout'); } }
public function daftar_pengajuan_skt_baru_dtlm() { if ($this->session->userdata('level') != 3) { $this->logout(); } $c = new grocery_crud(); $c->set_table('biodata_perusahaan'); $c->where('status_progress', 4); $c->unset_add(); //$c->unset_delete(); $c->unset_edit(); $c->unset_read(); $c->field_type('id_user', 'hidden', $this->session->userdata('id_user')); $c->field_type('alamat', 'text'); $c->unset_columns('id_user', 'status_user', 'contact_person', 'alamat', 'provinsi', 'website', 'deskripsi_perusahaan', 'status_progress', 'tanggal_disetujui'); $c->add_action('Revisi', 'sR', base_url('hal/revisi_pengajuan_skt_dtlm/add') . '/'); $c->add_action('Lanjut', 'text', base_url('hal/pengajuan_skt_diterima_dtlm/add') . '/'); $c->add_action('Detail', 'sd', 'hal/detail_perusahaan/pengajuan_skt'); $c->required_fields('nama_perusahaan', 'direktur_utama', 'contact_person', 'email', 'alamat', 'kota', 'provinsi', 'website'); $c->unset_fields('tanggal_member', 'status_user'); $output = $c->render(); $this->logs(); $level = $this->session->userdata('level'); if ($level != NULL) { $this->load->view('level' . $level . '/view_list', $output); } }