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 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; // } }
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 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 daftar_register() { $c = new grocery_crud(); $c->set_table('registrasi'); $c->unset_add(); $c->unset_edit(); // $c->unset_print(); // $c->unset_export(); // //$c->unset_delete(); // unset $c->unset_columns('contact_person', 'kota', 'provinsi', 'web', 'website', 'siup'); $c->columns('nama_perusahaan', 'direktur_utama', 'website', 'npwp', 'file_surat_ket_domisili', 'siup', 'file_siup', 'file_surat_pernyataan', 'surat_ket_domisili', 'tanggal_member'); $c->set_rules('email', 'Email', 'required|valid_email'); $c->unset_fields('tanggal_member', 'status', 'pengajuan'); $c->add_action('Setuju', base_url('assets/img/icon/1.png'), base_url('admin/regis_setuju/') . '/'); // $c->add_action('Tolak', base_url('assets/img/icon/cancel.png'), base_url('all_admin/regis_tolak/').'/'); //display as $c->display_as('siup', 'Nomor SIUP'); $c->display_as('npwp', 'Nomor NPWP'); $c->display_as('file_surat_ket_domisili', 'Surat Keterangan Domisili'); $c->display_as('file_surat_pernyataan', 'Surat Pernyataan'); $c->display_as('file_siup', 'SIUP'); $c->display_as('surat_ket_domisili', 'Nomor Surat Keterangan Domisili'); $c->field_type('deskripsi_perusahaan', 'text'); $c->field_type('alamat', 'text'); $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->set_field_upload('file_surat_permohonan', 'assets/uploads/file_register'); // $c->set_field_upload('file_surat_pernyataan', 'assets/uploads/file_register'); $c->required_fields('nama_perusahaan', 'direktur_utama', 'contact_person', 'email', 'alamat', 'provinsi', 'kota', 'npwp', 'akte_perusahaan', 'siup', 'file_akte', 'file_siup', 'file_surat_permohonan', 'file_surat_pernyataan'); $output = $c->render(); $this->logs(); $level = $this->session->userdata('level'); if ($level != NULL) { $this->load->view('level' . $level . '/view_list', $output); } else { redirect('umum/logout'); } }
public function tambah_user() { $c = new grocery_crud(); $c->set_table('users'); $c->where('level !=', 1); $c->required_fields('username', 'password', 'level', 'nama_lengkap'); $c->fields('username', 'password', 'level', 'nama_lengkap'); $c->set_relation('level', 'ref_level_user', 'level_user'); $c->set_crud_url_path(base_url(strtolower(__CLASS__ . "/" . __FUNCTION__)), base_url(strtolower(__CLASS__ . "/menej_ref"))); //$c->callback_before_insert(array($this,'callback_before_tambah_user')); $c->columns('username', 'level'); $c->field_type('password', 'hidden', 'dmtp2014'); $output = $c->render(); $this->logs(); if ($c->getState() != 'list') { $this->menej_ref($output); } else { return $output; } }
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 data_umum() { $c = new grocery_crud(); $c->set_table('data_umum'); $c->where('id_perusahaan', $this->session->userdata('id_perusahaan')); $c->where('data_umum.jenis_dokumen !=', 12); $this->load->config('grocery_crud'); $this->config->set_item('grocery_crud_file_upload_allow_file_types', 'pdf'); $c->unset_delete(); $c->unset_read(); $c->unset_edit(); $ada = NULL; $cek_if_has_data_permohonan = select('status_pemakaian', 'data_umum', array('id_perusahaan' => $this->session->userdata('id_perusahaan'))); if ($cek_if_has_data_permohonan != NULL) { foreach (explode(',', $cek_if_has_data_permohonan->status_pemakaian) as $key => $status_pemakaian) { if ($status_pemakaian == $this->session->userdata('id_permohonan')) { $ada = 'ada'; } } } if ($ada != NULL) { $c->add_action('Ganti', 'sd', 'perusahaan/ganti/data_umum', 'ui-icon-plus'); } else { $c->add_action('Pilih', 'sd', 'perusahaan/pilih/data_umum', 'ui-icon-plus'); } $c->required_fields('nomor', 'jenis_dokumen', 'penerbit', 'tanggal_terbit', 'akhir_masa_berlaku', 'file_dokumen'); $c->set_field_upload('file_dokumen', 'assets/uploads/files'); $c->set_crud_url_path(base_url(strtolower(__CLASS__ . "/" . __FUNCTION__)), base_url(strtolower(__CLASS__ . "/data_pemohon"))); //field type $c->field_type('id_perusahaan', 'hidden', $this->session->userdata('id_perusahaan')); // unset field $c->unset_fields('status', 'catatan_petugas', 'status_pemakaian'); // unset columns // $c->unset_columns('id_perusahaan', 'status', 'catatan_petugas', 'status_pemakaian'); $c->columns('nomor', 'jenis_dokumen', 'penerbit', 'tanggal_terbit', 'akhir_masa_berlaku', 'file_dokumen'); // set relation $c->set_relation('jenis_dokumen', 'ref_jenis_dokumen', 'jenis_dokumen', array('id_jenis_dokumen !=' => 12)); // display as $c->display_as('jenis_dokumen', 'Dokumen'); $c->display_as('akhir_masa_berlaku', 'Berlaku Hingga Tanggal'); $output = $c->render(); $this->logs(); if ($c->getState() != 'list') { $this->data_pemohon($output); } else { return $output; } }