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 laporan_berkala()
{
$c = new grocery_crud();
$c->set_table('dokumen_skt');
// if($this->glo_jenis_permo != ''){
$c->unset_operations();
$c->columns('id_permohonan', 'no_dokumen', 'mulai_masa_berlaku', 'akhir_masa_berlaku', 'file_dokumen');
$c->where('dokumen_skt.id_perusahaan', $this->session->userdata('id_perusahaan'));
$c->field_type('id_perusahaan', 'hidden', $this->session->userdata('id_perusahaan'));
$c->set_field_upload('file_dokumen', 'assets/uploads/file_skt');
$c->display_as('id_permohonan', 'Bidang Jasa');
$c->add_action('Proses Laporan | ', 'sd', 'perusahaan/proses_laporan/proses', 'ui-icon-plus');
$c->add_action('Update Data | ', 'sd', 'perusahaan/proses_laporan/update', 'ui-icon-plus');
$c->add_action('View Data', 'sd', 'perusahaan/proses_laporan/view', 'ui-icon-plus');
$c->callback_column('id_permohonan', function ($value, $row) {
$ada = NULL;
$data_permohonan = select('*', 'permohonan', array('id_permohonan' => $value));
$bidang_usaha = select('*', 'ref_bidang_usaha', array('id_bidang_usaha' => $data_permohonan->bidang_usaha));
$sub_bidang = select('*', 'ref_sub_bidang', array('id_sub_bidang' => $data_permohonan->sub_bidang));
return $bidang_usaha->bidang_usaha . '/' . $sub_bidang->sub_bidang;
});
//$c->set_relation('id_permohonan', 'ref_bidang_usaha', 'bidang_usaha');
// $c->set_relation('lokasi', 'ref_kota', 'kota', null, 'id_kota');
$output = $c->render();
$this->logs();
$level = $this->session->userdata('level');
if ($level != NULL) {
if ($level == 1) {
$this->load->view('level1/view_list', $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 daftar_pengajuan_skt_perpanjangan_admin_naik()
{
$c = new grocery_crud();
$permohonan = $this->model->select('*', 'permohonan', array('jenis_permohonan' => 'Perpanjangan SKT'));
$c->set_table('disposisi');
$level = $this->session->userdata('level');
if ($level == 5) {
$c->where('status_progress', 9);
$id_per = $this->model->select('id_perusahaan', 'disposisi', array('status_progress' => 9));
} elseif ($level == 4) {
$c->where('status_progress', 11);
$id_per = $this->model->select('id_perusahaan', 'disposisi', array('status_progress' => 11));
} elseif ($level == 3) {
$c->where('status_progress', 12);
$id_per = $this->model->select('id_perusahaan', 'disposisi', array('status_progress' => 12));
} elseif ($level == 2) {
$c->where('status_progress', 13);
$id_per = $this->model->select('id_perusahaan', 'disposisi', array('status_progress' => 13));
}
if ($id_per != NULL) {
$id_per = $id_per->id_perusahaan;
} else {
$id_per = '';
}
$permohonan = $this->model->selects('*', 'permohonan', array('jenis_permohonan' => 'Perpanjangan SKT', 'id_perusahaan' => $id_per));
if ($permohonan != NULL) {
foreach ($permohonan as $key => $value) {
$c->where('id_perusahaan', $value->id_perusahaan);
}
} else {
$c->where('id_perusahaan', '');
}
$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', 'keterangan');
// $c->add_action('Revisi','sR', base_url('all_admin/revisi_pengajuan_skt/').'/');
// $c->add_action('Lanjut','text', base_url('all_admin/pengajuan_skt_diterima/add').'/');
$c->add_action('Detail Evaluasi', 'sd', 'all_admin/detail_evaluasi/perpanjangan_skt');
$c->set_crud_url_path(base_url(strtolower(__CLASS__ . "/" . __FUNCTION__)), base_url(strtolower(__CLASS__ . "/daftar_pengajuan_skt")));
$c->required_fields('nama_perusahaan', 'direktur_utama', 'contact_person', 'email', 'alamat', 'kota', 'provinsi', 'website');
$c->unset_fields('tanggal_member', 'status_user', 'keterangan');
$output = $c->render();
$this->logs();
if ($c->getState() != 'list') {
$this->daftar_pengajuan_skt_admin($output);
} else {
return $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 daftar_register()
{
$c = new grocery_crud();
$this->config->load('grocery_crud');
$this->config->set_item('grocery_crud_dialog_forms', true);
$this->config->set_item('grocery_crud_default_per_page', 10);
$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', 'file_surat_pernyataan');
$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/images/success.png'), base_url('admin/regis_setuju/') . '/');
$c->add_action('Tolak', base_url('assets/images/close.png'), base_url('admin/regis_tolak/') . '/');
// $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 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);
}
}
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();
$c->add_action('Pilih', 'sd', 'perusahaan/pilih/csr', 'ui-icon-plus');
}
$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');
}
}
