function city_management() { $crud = new grocery_CRUD(); $crud->set_table('city_master'); $crud->set_subject('City'); $crud->columns('city', 'state_id', 'status'); $crud->fields('city', 'state_id', 'status'); $crud->required_fields('city', 'state_id'); $crud->display_as('state_id', 'State'); $crud->set_primary_key('state_id', 'state_master'); $crud->set_relation('state_id', 'state_master', 'state_name'); $output = $crud->render(array('name' => 'City Management')); $this->_example_output($output); }
public function createtable($db) { $this->db = $this->load->database($db, true); $crud = new grocery_CRUD(); $crud->set_table('alert_logger'); $crud->set_primary_key('id'); $crud->columns('alert', 'all_alg_data', 'all_alg_file_data', 'toa', 'alert_name', 'status', 'del'); $crud->display_as('alert', 'Alert')->display_as('all_alg_file_data', 'ALG File.')->display_as('all_alg_data', 'ALG Ref.')->display_as('toa', 'Date')->display_as('alert_name', 'Name')->display_as('del', 'Deletion date'); $crud->unset_add(); $crud->unset_edit(); $crud->unset_delete(); $crud->callback_column('status', array($this, '_column_status')); $output = $crud->render(); $this->db->close(); $this->_example_output($output); }
public function suratperunit() { $crud = new grocery_CRUD(); $crud->set_table('distribusi'); $crud->where('id_unit', $this->uri->segment(3)); $crud->set_primary_key('id_unit', 'distribusi'); $crud->set_relation('id_unit', 'unit', 'namaGroup'); $crud->set_relation('id_surat', 'surat', 'nomorSurat'); $crud->columns('id_surat'); $crud->display_as('id_surat', 'nomor surat'); $crud->unset_add(); $crud->unset_edit(); //$crud->columns('nomorSurat','perihal','tanggal'); $output = $crud->render(); $this->_outputs($output); }
public function persutujuan_daftar_user() { try { $crud = new grocery_CRUD(); $state = $crud->getState(); $id_user_penilai = $this->get_user_login(); //echo $id_user_penilai; exit; //$crud->where('user_kategori', 'pegawai'); $crud->where('id_user_penilai', $id_user_penilai); $crud->set_table('view_penilai_user'); $crud->set_primary_key('id_user_pegawai'); $crud->set_subject('Daftar Pegawai'); $crud->fields('nama_depan', 'Users'); $crud->columns('nama', 'nip', 'jenjang_jabatan', 'jenjang_golongan'); $crud->add_action('Daftar Kegiatan', '', 'penilai/persutujuan_daftar_kegiatan', 'fa fa-list'); $crud->display_as("Users", "Pegawai")->display_as("nama_depan", "Tim Penilai"); $crud->order_by('nama', 'asc'); $crud->change_field_type('nama_depan', 'readonly'); $crud->unset_save(); $crud->unset_add(); $crud->unset_edit(); $crud->unset_read(); $crud->unset_delete(); $sitemap = $this->get_sitemap(); $output = $crud->render($sitemap); $this->load->view('theme/theme_pegawai', $output); } catch (Exception $e) { show_error($e->getMessage() . ' --- ' . $e->getTraceAsString()); } }
public function vperusahaan($jenis) { $crud = new grocery_CRUD(); $crud->set_table('vperusahaan'); $crud->columns('npwp', 'nama', 'alamat'); $crud->set_primary_key('id', 'vperusahaan'); $crud->display_as('npwp', 'NPWP Perusahaan'); $crud->display_as('nama', 'Nama Perusahaan'); $crud->add_action('Pilih', '', 'perus', 'sk-icon'); $crud->unset_export(); $crud->unset_add(); $crud->unset_edit(); $crud->unset_delete(); $crud->unset_print(); $crud->unset_read(); $crud->set_crud_url_path(site_url(strtolower(__CLASS__ . "/" . __FUNCTION__)), site_url(strtolower(__CLASS__ . "/" . $jenis))); $output = $crud->render(); return $output; }
public function kegiatan_lama() { $status = $this->input->get("status"); $crud = new grocery_CRUD(); $crud->where("tbl_kegiatan_transaksi.status", "Lama"); $crud->set_table('tbl_kegiatan_transaksi'); $crud->set_subject('Kegiatan Lama'); $crud->set_relation('change_by', 'tbl_user', 'email'); $crud->set_relation('id_user', 'tbl_user', '{nama_depan} {nama_belakang}'); $crud->set_relation('id_kegiatan_butir', 'view_kegiatan_butir', '{unsur} - {subunsur} - {butir}'); $crud->set_primary_key('id_kegiatan_butir', 'view_kegiatan_butir'); $crud->required_fields('tanggal_kegiatan', 'tanggal_kegiatan_selesai'); $crud->fields('id_user', 'id_kegiatan_butir', 'tanggal_kegiatan', 'tanggal_kegiatan_selesai', 'lembur', 'keterangan', 'status', 'change_by', 'change_date'); $crud->columns('id_user', 'id_kegiatan_butir', 'tanggal_kegiatan', 'tanggal_kegiatan_selesai', 'status'); $crud->display_as("id_kegiatan_butir", "Butir Kegiatan")->display_as("tanggal_kegiatan", "Tanggal Mulai")->display_as("tanggal_kegiatan_selesai", "Tanggal Selesai")->display_as("id_user", "Oleh")->display_as("change_date", "Tanggal")->display_as("id_periode", "Periode")->display_as("id_kegiatan_jabatan", "Bertindak Sebagai"); $crud->callback_add_field('id_user', array($this, '_form_get_user_callback')); $crud->callback_edit_field('id_user', array($this, '_form_get_user_callback')); $crud->callback_add_field('status', array($this, '_kegiatan_lama_get_status_callback')); $crud->callback_edit_field('status', array($this, '_kegiatan_lama_get_status_callback')); $crud->callback_before_update(array($this, 'get_change_by_callback')); $crud->callback_before_insert(array($this, 'get_change_by_callback')); $crud->callback_field('change_date', array($this, 'format_date_callback')); $crud->change_field_type('id_user', 'readonly'); $crud->change_field_type('change_by', 'readonly'); $crud->change_field_type('change_date', 'readonly'); $crud->add_action('Unggah Bukti', '', 'pegawai/daftar_kegiatan_berkas', 'fa fa-upload'); $crud->unset_read(); $crud->order_by('id_kegiatan_transaksi', 'desc'); $sitemap = $this->get_sitemap(); $output = $crud->render($sitemap); $this->load->view('theme/theme_pegawai', $output); }
public function search_student1() { $user_login = $this->ion_auth->user()->row(); $colid = $user_login->col_id; $cc_id = $this->m_student_management->get_cc_id_by_col_id($colid); $array_cc_id = ""; foreach ($cc_id as $key) { $array_cc_id .= $key->cc_id . ","; } $array_cc_id = substr($array_cc_id, 0, -1); $nama = $this->input->get('name'); $angka_giliran = $this->input->get('angka_giliran'); $mykad = $this->input->get('mykad'); $course = $this->input->get('kursus'); $result = $this->m_student_management->search_student1($nama, $angka_giliran, $mykad, $course); $crud = new grocery_CRUD(); $crud->set_table('student'); $crud->set_primary_key('cc_id', 'student'); $crud->set_relation_n_n('Course', 'college_course', 'course', 'cc_id', 'cou_id', 'cou_name'); $crud->set_relation_n_n('College', 'college_course', 'college', 'cc_id', "col_ida={$colid}", 'col_name'); // $crud->where('college.col_id',$colid); $crud->columns('stu_mykad', 'stu_name', 'stu_matric_no', 'College', 'Course', 'stu_current_sem'); if ($nama != '') { $crud->or_like('stu_name', $nama, 'both'); } elseif ($angka_giliran != '') { $crud->or_like('stu_matric_no', $angka_giliran, 'both'); } elseif ($mykad != '') { $crud->or_like('stu_mykad', $mykad, 'both'); } elseif ($course != '') { $crud->or_like('cou_name', $course, 'both'); } //Modification Log : 27092013 by Mior - comment 2 line code below because searching not function //$query_where= "temp_cc_id IN ($array_cc_id)"; //$crud -> where($query_where); $crud->callback_column('stu_mykad', array($this, '_callback_webpage_url')); $crud->callback_column('stu_name', array($this, '_callback_webpage_url')); $crud->callback_column('stu_matric_no', array($this, '_callback_webpage_url')); $crud->display_as('stu_mykad', 'MyKad')->display_as('stu_name', 'Nama')->display_as('stu_matric_no', 'Angka Giliran')->display_as('Course', 'Kursus')->display_as('College', 'KV')->display_as('stu_current_sem', 'Semester Sekarang'); $crud->unset_add(); $crud->unset_edit(); $crud->unset_delete(); $output = $crud->render(); echo $this->_empty_output($output); }
public function createtable($db) { $this->db = $this->load->database($db, true); $crud = new grocery_CRUD(); $crud->where('toa<=', date('Y-m-d')); if ($this->session->userdata('role') != 1) { $crud->where('alert_name', $this->session->userdata('user_name')); } $crud->set_table('alert_view'); $crud->set_primary_key('id'); if ($this->session->userdata('role') != 1) { $crud->columns('alert', 'all_alg_data', 'all_alg_file_data', 'toa', 'next_action', 'next_alert', 'alert_date'); } else { $crud->columns('alert', 'all_alg_data', 'all_alg_file_data', 'toa', 'alert_name', 'next_action', 'next_alert', 'alert_date'); } $crud->display_as('alert', 'Alert')->display_as('all_alg_file_data', 'ALG File.')->display_as('all_alg_data', 'ALG Ref.')->display_as('toa', 'Date')->display_as('alert_name', 'Name'); $crud->callback_column('alert', array($this, '_full_text')); $crud->callback_column('all_alg_file_data', array($this, '_full_text1')); $crud->callback_column('alert_name', array($this, '_column_bonus_right_align')); $crud->callback_column('next_action', array($this, '_column_next_action')); $crud->callback_column('next_alert', array($this, '_column_next_alert_action')); $crud->callback_column('alert_date', array($this, '_column_alert_date_action')); $crud->unset_add(); $crud->unset_edit(); $crud->unset_delete(); if ($this->session->userdata('role') == 1) { $crud->add_action('Save', '', '', 'save-icon save-alert hidden', array($this, '_save_alert')); } else { $crud->add_action('Completed', '', '', 'success-icon save-alert hidden', array($this, '_save_alert')); } $output = $crud->render(); $this->db->close(); $this->_example_output($output); }
function pgtoav() { $crud = new grocery_CRUD(); $crud->set_theme('datatables'); $datemonth1 = date('Y-m-d', strtotime("-3 days")); $crud->set_table('pgtoav'); $crud->set_relation('member_id', 'members', 'member_id'); $crud->where('TxnEnd >=', $datemonth1); $crud->columns('merchantTxnID', 'gateway'); $crud->where('status !=', '1'); $crud->set_primary_key('member_id', 'pgtoav'); $crud->set_field_upload('message', 'assets/uploads/files/registration'); $crud->display_as('message', 'Transaction Slip or Message'); $crud->add_action('Activate', '', 'admin/activatepgtoav', 'ui-icon-plus'); $crud->unset_print(); $crud->unset_export(); //$crud->unset_add(); // $crud->unset_edit(); $crud->unset_delete(); $output = $crud->render(); $this->_example_output($output); }
function main() { $user_login = $this->ion_auth->user()->row(); $colid = $user_login->col_id; $userId = $user_login->user_id; $state_id = $user_login->state_id; $user_groups = $this->ion_auth->get_users_groups($userId)->row(); $ul_type = $user_groups->ul_type; $user_id = $this->session->userdata('user_id'); $crud = new grocery_CRUD(); $crud->set_table('announcement'); $crud->set_subject('pengumuman'); $crud->unset_delete(); $crud->callback_delete(array($this, 'delete_ann')); $crud->unset_columns('ann_status_push'); if ($ul_type == 'KV') { $crud->set_primary_key('ann_id', 'announcement_college'); $crud->set_relation('user_id', 'user', 'user_name'); $crud->set_relation('ann_id', 'announcement_college', 'col_id'); $crud->set_relation_n_n('Kolej', 'announcement_college', 'college', 'ann_id', 'col_id', 'col_name'); // $crud->callback_add_field('Kolej',array($this,'add_field_kolej')); $crud->callback_after_insert(array($this, 'insert_announcement_college')); $crud->field_type('ann_open_date', 'date'); $crud->field_type('ann_close_date', 'date'); $crud->field_type('user_id', 'hidden', $userId); $crud->field_type('ann_status_push', 'hidden', 1); $crud->field_type('ann_status', 'dropdown', array('1' => 'Aktif', '0' => 'Tak Aktif')); $crud->display_as('ann_title', 'Perkara')->display_as('ann_id', 'Id')->display_as('ann_content', 'Pengumuman')->display_as('ann_open_date', 'Tarikh Mula')->display_as('ann_close_date', 'Tarikh Akhir')->display_as('ann_status', 'Status Pengumuman')->display_as('user_id', 'Pengguna')->display_as('college', 'Kolej Vokasional'); // $crud->callback_field('ann_title',array($this,'fc_ann_tite')); - FDP // $crud->callback_field('ann_content',array($this,'fc_ann_content')); - FDP // $crud->callback_field('ann_open_date',array($this,'fc_ann_open_date')); - FDP // $crud->callback_field('ann_close_date',array($this,'fc_ann_close_date')); - FDP // $crud->callback_field('ann_status',array($this,'fc_ann_status')); - FDP // $crud->callback_field('college',array($this,'fc_college')); - FDP $crud->where('j7f822d59.col_id', $colid); $crud->unset_fields('Kolej'); $crud->required_fields('ann_title', 'ann_content', 'ann_open_date', 'ann_close_date', 'ann_status'); } elseif ($ul_type == 'LP') { $crud->set_relation('user_id', 'user', 'user_name'); $crud->set_relation_n_n('Kolej', 'announcement_college', 'college', 'ann_id', 'col_id', 'col_name'); $crud->callback_after_insert(array($this, 'insert_announcement_college')); $crud->field_type('ann_open_date', 'date'); $crud->field_type('ann_close_date', 'date'); $crud->field_type('user_id', 'hidden', $user_id); $crud->field_type('ann_status_push', 'hidden', 1); $crud->field_type('ann_status', 'dropdown', array('1' => 'Aktif', '0' => 'Tak Aktif')); $crud->display_as('ann_title', 'Perkara')->display_as('ann_content', 'Pengumuman')->display_as('ann_open_date', 'Tarikh Mula')->display_as('ann_close_date', 'Tarikh Akhir')->display_as('ann_status', 'Status Pengumuman')->display_as('user_id', 'Pengguna')->display_as('college', 'Kolej Vokasional'); // $crud->callback_field('ann_title',array($this,'fc_ann_tite')); - FDP // $crud->callback_field('ann_content',array($this,'fc_ann_content')); - FDP // $crud->callback_field('ann_open_date',array($this,'fc_ann_open_date')); - FDP // $crud->callback_field('ann_close_date',array($this,'fc_ann_close_date')); - FDP // $crud->callback_field('ann_status',array($this,'fc_ann_status')); - FDP // $crud->callback_field('college',array($this,'fc_college')); - FDP $crud->required_fields('ann_title', 'ann_content', 'ann_open_date', 'ann_close_date', 'ann_status'); } $output = $crud->render(); $js = '<script>$(document).ready(function() { $("#addStudent").validationEngine(); });</script>'; $header = $js . "<legend><h3>Penyenggaraan Pengumuman</h3></legend>"; $this->_main_output($output, $header); }
public function daftar_kegiatan_status($status = NULL) { try { $status = $this->uri->segment(3); $id_user = $this->get_user_login(); $crud = new grocery_CRUD(); $state = $crud->getState(); $crud->set_table('view_kegiatan_transaksi'); $crud->set_primary_key('id_kegiatan_transaksi'); $crud->where("id_user", $id_user); $crud->where("status", $status); $crud->set_subject('Daftar Kegiatan'); $crud->columns('subunsur', 'butir', 'satuan_hasil', 'angka_kredit', 'keterangan'); $crud->callback_column('butir', array($this, '_callback_daftar_kegiatan_column')); $crud->callback_column('subunsur', array($this, '_callback_daftar_kegiatan_column')); $crud->callback_column('satuan_hasil', array($this, '_callback_daftar_kegiatan_column')); //$crud->add_action('Edit', '', 'pegawai/daftar_kegiatan_transaksi/edit/','fa fa-pencil'); $crud->unset_delete(); $crud->unset_edit(); $crud->unset_add(); $crud->unset_read(); $sitemap = $this->get_sitemap(); $output = $crud->render($sitemap); $this->load->view('theme/theme_pegawai', $output); } catch (Exception $e) { show_error($e->getMessage() . ' --- ' . $e->getTraceAsString()); } }
function _set_common_report_crud($columns) { $crud = new grocery_CRUD(); // default columns excludes: token address_id simply because FMS/FMS-endpoint doesn't use them $default_columns = array('report_id', 'status', 'requested_datetime', 'updated_datetime', 'expected_datetime', 'priority', 'category_id', 'media_url', 'status_notes', 'description', 'agency_responsible', 'service_notice', 'address', 'postal_code', 'lat', 'long', 'device_id', 'source_client', 'account_id', 'first_name', 'last_name', 'email', 'phone', 'engineer'); $columns = $columns ? $columns : $default_columns; foreach ($columns as &$colname) { if ($colname == 'report_id') { $colname = 'xxx_report_id'; } } $crud->columns($columns); $crud->order_by('requested_datetime', 'desc'); $crud->edit_fields($default_columns); $crud->set_theme('twitter-bootstrap'); $crud->set_table('reports'); $crud->set_subject('Report'); $crud->set_relation('category_id', 'categories', 'category_name', null, 'category_name ASC'); $crud->set_relation('priority', 'priorities', 'prio_name', null, 'prio_value ASC'); $crud->set_relation('status', 'statuses', 'status_name', null, 'status_name ASC'); $crud->set_primary_key('url_slug', 'agencies'); $crud->set_relation('agency_responsible', 'agencies', 'name', null, 'name ASC'); $crud->set_relation('source_client', 'open311_clients', '<a href="admin/open311_clients/{id}">{name}</a>', null, 'name ASC'); $crud->display_as('client_id', 'Client'); $crud->callback_column('media_url', array($this, '_linkify')); $crud->callback_column('external_id', array($this, '_get_external_url')); $crud->callback_edit_field('media_url', array($this, '_text_media_url_field')); $crud->display_as('requested_datetime', 'Received')->display_as('updated_datetime', 'Last Updated')->display_as('expected_datetime', 'Expected')->display_as('category_id', 'Category')->display_as('media_url', 'Media URL'); $external_id_col_name = config_item('external_id_col_name'); $crud->display_as('external_id', empty($external_id_col_name) ? 'External ID' : $external_id_col_name); $crud->unset_texteditor('description', 'address', 'status_notes', 'service_notice'); $crud->add_action('View', site_url('assets/fms-endpoint/images/report.png'), 'admin/report'); $crud->callback_column('xxx_report_id', array($this, '_report_id_link_field')); $crud->callback_column('requested_datetime', array($this, '_report_datetime_field')); $crud->callback_column('updated_datetime', array($this, '_report_datetime_field')); $crud->callback_column('description', array($this, '_report_description_field')); $crud->callback_column($this->unique_field_name('status'), array($this, '_report_status_button')); $crud->callback_column($this->unique_field_name('category_id'), array($this, '_report_category_button')); $crud->display_as('xxx_report_id', 'ID'); $crud->callback_edit_field('xxx_report_id', array($this, '_read_only_report_id_field')); //$crud->fields($default_columns); //$crud->field_type('updated_datetime','invisible'); //$crud->callback_before_update(function($post_array){ // $post_array['updated_datetime'] = date('Y-m-d H:i:s'); // return $post_array; //}); $crud->callback_field('updated_datetime', array($this, '_set_update_time')); $crud->callback_field('requested_datetime', array($this, '_set_requested_datetime')); $crud->field_type('report_id', 'readonly'); $crud->callback_before_update(array($this, '_fix_zero_prio_callback')); $crud->callback_after_update(array($this, '_check_for_status_update_after')); if (!$this->ion_auth->is_admin()) { $crud->unset_delete(); } // If we're not an admin restrict list to reports we have permissions for if (!$this->ion_auth->is_admin()) { return $this->filter_query_permissions($crud); } else { return $crud; } }
public function GroceryCrud() { try { $crud = new grocery_CRUD(); $crud->set_theme('twitter-bootstrap'); $crud->set_table('Employee_Master'); $crud->set_subject('Employee'); $crud->set_primary_key('VEEVA_Employee_ID', 'Employee_Master'); $output = $crud->render(); $data['output'] = $output->output; $data['css_files'] = $output->css_files; $data['js_files'] = $output->js_files; $data = array('title' => 'Profile_Completion', 'content' => 'admin/GroceryCrud', 'view_data' => $data); $this->load->view('template3', $data); } catch (Exception $e) { show_error($e->getMessage() . ' --- ' . $e->getTraceAsString()); } }
public function persutujuan_daftar_kegiatan() { try { $this->load->model("user_m"); $crud = new grocery_CRUD(); $state = $crud->getState(); $id_user = $this->uri->segment(3); $status = $this->uri->segment(4); $data = $this->user_m->detail($id_user); $row = $data[0]; $nama_depan = isset($row->nama_depan) ? $row->nama_depan : ""; $nama_belakang = isset($row->nama_belakang) ? $row->nama_belakang : ""; if ($state == 'edit') { $crud->where('tbl_kegiatan_transaksi.id_user', $id_user); $crud->where('tbl_kegiatan_transaksi.status', $status); $crud->set_table('tbl_kegiatan_transaksi'); } else { $crud->where('view_penguji_daftar_karya_ilmiah.id_user', $id_user); $crud->where('view_penguji_daftar_karya_ilmiah.status', $status); $crud->set_table('view_penguji_daftar_karya_ilmiah'); $crud->set_primary_key('id_kegiatan_transaksi'); } $crud->set_relation('id_user', 'tbl_user', '{nama_depan} {nama_belakang}'); $crud->set_subject('Daftar Kegiatan'); $crud->fields('id_user', 'tanggal_kegiatan', 'tanggal_kegiatan_selesai', 'lembur', 'keterangan', 'status', 'status_deskripsi', 'angka_kredit'); $crud->columns('id_user', 'tanggal_kegiatan', 'tanggal_kegiatan_selesai', 'keterangan', 'status', 'angka_kredit'); $crud->add_action('Daftar Berkas', '', 'penilai/persutujuan_daftar_kegiatan_berkas', 'fa fa-upload'); $crud->display_as("tanggal_kegiatan", "Tanggal Mulai")->display_as("tanggal_kegiatan_selesai", "Tanggal Selesai")->display_as("id_user", "Pegawai"); $crud->order_by('id_kegiatan_transaksi', 'desc'); $crud->change_field_type('tanggal_kegiatan', 'readonly'); $crud->change_field_type('tanggal_kegiatan_selesai', 'readonly'); $crud->change_field_type('id_user', 'readonly'); $crud->change_field_type('lembur', 'readonly'); $crud->change_field_type('keterangan', 'readonly'); $crud->change_field_type('angka_kredit', 'readonly'); $crud->unset_add(); $crud->unset_save(); $crud->unset_read(); $crud->unset_delete(); $sitemap = $this->get_sitemap(); $output = $crud->render($sitemap); $this->load->view('theme/theme_pegawai', $output); } catch (Exception $e) { show_error($e->getMessage() . ' --- ' . $e->getTraceAsString()); } }
public function kenaikan_pangkat() { try { $crud = new grocery_CRUD(); $crud->where('user_kategori', 'pegawai'); $crud->set_table('view_user'); $crud->set_subject('Daftar Pegawai'); $crud->set_primary_key('id_user'); $crud->columns('nip', 'nama_depan', 'nama_belakang', 'status'); $crud->add_action('Detail', '', 'admin/kenaikan_pangkat_daftar', 'fa fa-edit'); //$crud->display_as("id_user", "Penanya"); $crud->unset_save(); $crud->unset_edit(); $crud->unset_delete(); $crud->unset_read(); $crud->unset_add(); $crud->order_by('nip', 'desc'); $sitemap = $this->get_sitemap(); $output = $crud->render($sitemap); $this->load->view('theme/theme_default', $output); } catch (Exception $e) { show_error($e->getMessage() . ' --- ' . $e->getTraceAsString()); } }