PHP grocery_CRUD::unset_read方法代码示例

 protected function generate_crud($table, $subject = '')
 {
     // create CRUD object
     $this->load->library('Grocery_CRUD');
     $crud = new grocery_CRUD();
     $crud->set_table($table);
     // auto-generate subject
     if (empty($subject)) {
         $crud->set_subject(humanize(singular($table)));
     }
     // load settings from: application/config/grocery_crud.php
     $this->load->config('grocery_crud');
     $this->mCrudUnsetFields = $this->config->item('grocery_crud_unset_fields');
     if ($this->config->item('grocery_crud_unset_jquery')) {
         $crud->unset_jquery();
     }
     if ($this->config->item('grocery_crud_unset_jquery_ui')) {
         $crud->unset_jquery_ui();
     }
     if ($this->config->item('grocery_crud_unset_print')) {
         $crud->unset_print();
     }
     if ($this->config->item('grocery_crud_unset_export')) {
         $crud->unset_export();
     }
     if ($this->config->item('grocery_crud_unset_read')) {
         $crud->unset_read();
     }
     foreach ($this->config->item('grocery_crud_display_as') as $key => $value) {
         $crud->display_as($key, $value);
     }
     // other custom logic to be done outside
     $this->mCrud = $crud;
     return $crud;
 }

 public function index()
 {
     //        $data = array(
     //            'main_content' => 'clients_wishlist',
     //            'output' => $this->db->get_where('clients_wishlist', array('wish_user' => $this->ion_auth->get_user_id()))->result(),
     //            'pagetitle' => 'Wishlist',
     //            'pagedesc' => 'Wishlist',
     //            'contenttitle' => 'Wishlist  Records',
     //            'left_menu' => 'clients_menu'
     //        );
     //        $this->load->view('gc_client_wrapper', $data);
     $this->load->library('grocery_CRUD');
     //        $this->upload_path = '../assets/uploads/' . 'packages';
     //        $this->wrapper = 'gc_admin_wrapper';
     $this->load->model('generic_model');
     $crud = new grocery_CRUD();
     $crud->set_theme('flexigrid');
     $crud->set_table('clients_wishlist');
     $crud->set_subject('Client Wishlist');
     $crud->unset_add();
     $crud->unset_edit();
     $crud->unset_read();
     $crud->where('wish_user', $this->ion_auth->get_user_id());
     $crud->display_as('wish_title', 'Wish Title');
     $crud->display_as('wish_date', 'Wish Date');
     $crud->callback_column('wish_title', array($this, 'set_change_status'));
     $crud->unset_columns('wish_url', 'wish_user');
     $output = $crud->render();
     $data = array('main_content' => 'list', 'output' => $output, 'pagetitle' => 'Client Wishlist', 'pagedesc' => 'Client Wishlist', 'contenttitle' => 'Wishlist Records', 'left_menu' => 'clients_menu');
     $this->load->view('gc_admin_wrapper', $data);
 }

 public function listarNeumonias()
 {
     $sub = $this->frontend_model->buscarDiresas();
     $subr = array();
     foreach ($sub as $dato) {
         $subr[$dato->codigo] = $dato->nombre;
     }
     $est = $this->frontend_model->listaEstablec();
     $estab = array();
     foreach ($est as $dato) {
         $estab[$dato->cod_est] = $dato->raz_soc;
     }
     $crud = new grocery_CRUD();
     $crud->set_table('neumonias');
     $crud->columns('diresa', 'e_salud', 'apepat', 'apemat', 'nombres', 'sexo', 'fecha_reg', 'fecha_def', 'usuario');
     $crud->set_subject('Ficha');
     $nivelUsuario = $this->session->userdata("nivel");
     switch ($nivelUsuario) {
         case '8':
             $where = array('e_salud' => $this->session->userdata("establecimiento"));
             $crud->where($where);
             break;
         case '7':
             $where = array('microred' => $this->session->userdata("microred"), 'red' => $this->session->userdata("red"), 'diresa' => $this->session->userdata("diresa"));
             $crud->where($where);
             break;
         case '6':
             $where = array('red' => $this->session->userdata("red"), 'diresa' => $this->session->userdata("diresa"));
             $crud->where($where);
             break;
         case '5':
             $where = array('diresa' => $this->session->userdata("diresa"));
             $crud->where($where);
             break;
     }
     $crud->field_type('sexo', 'dropdown', array('M' => 'Masculino', 'F' => 'Femenino'));
     $crud->field_type('diresa', 'dropdown', $subr);
     $crud->field_type('e_salud', 'dropdown', $estab);
     $crud->display_as("apepat", "Apellido Paterno");
     $crud->display_as("apemat", "Apellido Materno");
     $crud->display_as("fecha_reg", "Registro");
     $crud->display_as("fecha_def", "Defunción");
     $crud->display_as("e_salud", "Establecimiento");
     $crud->unset_add();
     $crud->unset_edit();
     $crud->unset_read();
     $crud->unset_export();
     //$crud->unset_print();
     $crud->callback_after_delete(array($this, 'log_usuario_before_delete'));
     $crud->add_action_peru('', '', 'RegfichaNeum', 'add-icon');
     $crud->add_action('Modificar Ficha', '', 'modulos3/ModfichaNeum', 'edit-icon');
     $crud->add_action('Ver Ficha', '', 'modulos3/VerfichaNeum', 'read-icon');
     $output = $crud->render();
     $this->_example_output($output);
 }

 public function listar_transito()
 {
     /*$establecimiento = $this->mantenimiento_transito->listarEstablecimiento();
     
     		foreach($establecimiento as $dato){
     			$est[$dato->cod_est] = $dato->raz_soc;
     		} */
     $crud = new grocery_CRUD();
     //$crud->set_theme('bootstrap');
     $crud->set_table('trans_lesacctra');
     $crud->columns('id', 'ano', 'ap_nm1', 'ap_nm2', 'nom_les', 'edad', 'tipo_edad', 'diresa', 'eess');
     $crud->set_subject('Ficha Transito');
     $nivelUsuario = $this->session->userdata("nivel");
     switch ($nivelUsuario) {
         case '8':
             $where = array('cod_eess' => $this->session->userdata("establecimiento"));
             $crud->where($where);
             break;
         case '7':
             //$where = "where cod_eess in(select cod_est FROM renace where subregion = '$diresa' and red = '$red' and microred = '$microred')";
             $where = array('microred' => $this->session->userdata("microred"), 'red' => $this->session->userdata("red"), 'cod_dir' => $this->session->userdata("diresa"));
             $crud->where($where);
             break;
         case '6':
             //$where = "where cod_eess in(select cod_est FROM renace where subregion = '$diresa' and red = '$red')";
             $where = array('red' => $this->session->userdata("red"), 'cod_dir' => $this->session->userdata("diresa"));
             $crud->where($where);
             break;
         case '5':
             $where = array('cod_dir' => $this->session->userdata("diresa"));
             $crud->where($where);
             break;
     }
     //$crud->field_type('establec', 'dropdown', $est);
     $crud->display_as("id", "ID")->display_as("ano", "AÑO")->display_as("ap_nm1", "APELLIDO PATERNO")->display_as("ap_nm2", "APELLIDO MATERNO")->display_as("nom_les", "NOMBRES")->display_as("edad", "EDAD")->display_as("tipo_edad", "TIPO")->display_as("diresa", "DIRESA")->display_as("eess", "ESTABLECIENTO DE SALUD");
     $crud->unset_add();
     $crud->unset_edit();
     $crud->unset_read();
     $crud->unset_print();
     $crud->unset_export();
     $crud->unset_delete();
     $crud->order_by('id', 'desc');
     $crud->add_action('Eliminar Ficha', base_url() . 'assets/images/close.png', 'modulotransito/borrarFichatransito', 'borrar-icon');
     $crud->add_action('Vista previa', '', 'modulotransito/ver_ficha_transito', 'read-icon');
     $crud->add_action('Editar Ficha Transito', '', 'modulotransito/modificacion_transito', 'edit-icon');
     $output = $crud->render();
     $usuario = $this->session->userdata("usuario");
     $accion = 'Listar Casos Accidentes de Transito';
     $this->login_model->auditoriaOperador($usuario, $accion);
     $this->layout->view('listar_transito', $output);
 }

 public function pengaturan()
 {
     $crud = new grocery_CRUD();
     $crud->set_table('pengaturan');
     $crud->unset_add();
     $crud->unset_delete();
     $crud->unset_read();
     $output = $crud->render();
     //Config Halaman
     $output->judul_besar = 'Pengaturan';
     $output->judul_kecil = 'Manage Pengaturan';
     $output->m_pengaturan = TRUE;
     // echo $this->Absensi_model->get_status_mesin();
     //$this->Absensi_model->get_data_absen();
     $this->_example_output($output);
 }

 private function master()
 {
     $crud = new grocery_CRUD();
     $crud->set_table('contents');
     $crud->unset_columns('jenis', 'slug', 'isi');
     $crud->callback_before_insert(array($this, "_timestamp"));
     $crud->callback_before_update(array($this, "_timestamp"));
     $crud->unset_export();
     $crud->unset_print();
     $crud->unset_read();
     $crud->change_field_type('jenis', 'invisible');
     $crud->change_field_type('slug', 'invisible');
     $crud->change_field_type('created_at', 'invisible');
     $crud->change_field_type('updated_at', 'invisible');
     return $crud;
 }

 public function index()
 {
     $crud = new grocery_CRUD();
     $crud->set_table('admin');
     $crud->columns('nama', 'username', 'email', 'last_login', 'role');
     $crud->unset_export();
     $crud->unset_print();
     $crud->unset_read();
     $crud->unset_edit_fields('password');
     $crud->callback_before_insert(array($this, "_timestamp"));
     $crud->change_field_type('created_at', 'invisible');
     $crud->change_field_type('updated_at', 'invisible');
     $crud->change_field_type('last_login', 'invisible');
     $output = $crud->render();
     $output->title = 'Kelola Admin';
     $this->template->load('template/template_main', 'admin/contents', $output);
 }

 public function index($stat = '')
 {
     try {
         $crud = new grocery_CRUD();
         $crud->set_theme('datatables');
         switch ($stat) {
             case '':
             default:
                 $user_ward_id = $this->session->userdata('nw_id');
                 $crud->set_table('nus_bed');
                 $crud->where('nus_bed.nw_id', $user_ward_id);
                 $crud->columns('nb_bed_no', 'np_pmi_id', 'nbs_id', 'nb_datetime', 'ns_id');
                 $crud->display_as('nb_bed_no', 'Bed No.')->display_as('np_pmi_id', 'Patient Name')->display_as('nbs_id', 'Remarks')->display_as('nb_datetime', 'Date/Time Registered')->display_as('ns_id', 'Nurse');
                 $crud->set_relation('nbs_id', 'nus_bed_status', 'nbs_desc');
                 $crud->set_relation('ns_id', 'nus_staff', 'ns_fullname');
                 $crud->set_relation('np_pmi_id', 'nus_patient', 'np_fullname');
                 //                        $crud->unset_add();
                 //                        $crud->unset_delete();
                 $crud->edit_fields('np_pmi_id', 'nbs_id', 'nb_datetime', 'ns_id');
                 $crud->add_fields('nb_bed_no', 'nw_id', 'nbs_id');
                 $crud->field_type('nw_id', 'hidden');
                 //                        $crud->field_type('nbs_id', 'hidden');
                 $crud->required_fields('nb_bed_no');
                 $crud->unset_read();
                 //                        $crud->change_field_type('nb_bed_no', 'readonly');
                 $crud->change_field_type('ns_id', 'readonly');
                 $crud->callback_before_update(array($this, 'autoRegisterBed'));
                 $crud->callback_before_insert(array($this, 'addBed'));
                 break;
             case 'patient':
                 $crud->set_table('nus_patient');
                 $crud->set_relation('np_gender', 'nus_patient_gender', 'npg_desc');
                 $crud->required_fields('np_pmi_no', 'np_fullname', 'np_ic', 'np_passport', 'np_gender');
                 $crud->fields('np_pmi_id', 'np_fullname', 'np_ic', 'np_passport', 'np_gender');
                 $crud->field_type('np_pmi_id', 'hidden');
                 $crud->display_as('np_pmi_id', 'PMI No.')->display_as('np_fullname', 'Full Name')->display_as('np_ic', 'IC No.')->display_as('np_passport', 'Passport No.')->display_as('np_gender', 'Gender');
                 $crud->callback_before_insert(array($this, 'autoInsertPriKeyPatient'));
                 break;
         }
         $output = $crud->render();
         $this->viewpage('v_mainpage', $output);
     } catch (Exception $e) {
         show_error($e->getMessage() . ' --- ' . $e->getTraceAsString());
     }
 }

 public function mostrar_usuarios()
 {
     $grocery = new grocery_CRUD();
     $grocery->set_theme('bootstrap');
     $grocery->set_table('users');
     $grocery->set_language('spanish');
     $grocery->display_as('username', 'Usuario');
     $grocery->display_as('email', 'E-mail');
     $grocery->fields('username', 'email');
     $grocery->unset_read();
     $grocery->columns('username', 'password', 'email');
     $grocery->field_type('password', 'password');
     $grocery->unset_add();
     $grocery->unset_export();
     $grocery->unset_print();
     $output = $grocery->render();
     $this->_example_output($output);
 }

 public function listarMnp()
 {
     $crud = new grocery_CRUD();
     $crud->set_table('mnp');
     $crud->columns('registroId', 'ape_nom', 'sexo', 'fecha_nac', 'fecha_mte', 'fecha_reg', 'usuario');
     $crud->set_subject('Ficha');
     $nivelUsuario = $this->session->userdata("nivel");
     switch ($nivelUsuario) {
         case '8':
             $where = array('e_salud' => $this->session->userdata("establecimiento"));
             $crud->where($where);
             break;
         case '7':
             $where = array('microred' => $this->session->userdata("microred"), 'red' => $this->session->userdata("red"), 'diresa' => $this->session->userdata("diresa"));
             $crud->where($where);
             break;
         case '6':
             $where = array('red' => $this->session->userdata("red"), 'diresa' => $this->session->userdata("diresa"));
             $crud->where($where);
             break;
         case '5':
             $where = array('diresa' => $this->session->userdata("diresa"));
             $crud->where($where);
             break;
     }
     $crud->field_type('sexo', 'dropdown', array('M' => 'Masculino', 'F' => 'Femenino', 'I' => 'Indeterminado'));
     $crud->display_as("registroId", "Ficha");
     $crud->display_as("ape_nom", "Apellidos y Nombres");
     $crud->display_as("fecha_nac", "Fecha de Nacimiento");
     $crud->display_as("fecha_mte", "Defunción");
     $crud->display_as("fecha_reg", "Fecha de Registro");
     $crud->unset_add();
     $crud->unset_edit();
     $crud->unset_read();
     $crud->unset_export();
     $crud->unset_delete();
     //$crud->unset_print();
     $crud->add_action_peru('', '', 'RegfichaMnp', 'add-icon');
     $crud->add_action('Eliminar Ficha', base_url() . 'assets/images/close.png', 'modulosmnp/delFichaMnp', 'borrar-icon');
     $crud->add_action('Modificar Ficha', '', 'modulosmnp/ModfichaMnp', 'edit-icon');
     $crud->add_action('Ver Ficha', '', 'modulosmnp/VerfichaMnp', 'read-icon');
     $output = $crud->render();
     $this->_example_output($output);
 }

 public function tabelnya()
 {
     $crud = new grocery_CRUD();
     $crud->set_table('pengaduan');
     $crud->set_subject('Daftar Pengaduan');
     $crud->columns('nama', 'pengaduan', 'tglpengaduan');
     $crud->display_as('nama', 'Nama Pengadu');
     $crud->display_as('pengaduan', 'Isi');
     $crud->display_as('tglpengaduan', 'Tanggal Masuk');
     $crud->unset_print();
     $crud->unset_export();
     $crud->unset_add();
     $crud->unset_edit();
     $crud->unset_delete();
     $crud->unset_read();
     $output = $crud->render();
     $this->load->view('home.php');
     $this->load->view('vinfotambahpengaduan.php', $output);
 }

 public function index()
 {
     $crud = new grocery_CRUD();
     $crud->set_crud_url_path(site_url('Barcode/index'));
     $crud->set_table('data');
     //Nama Tabel
     $crud->set_subject('Barcode');
     $crud->unset_read();
     $crud->unset_export();
     $crud->unset_print();
     $crud->add_action('Generate Barcode', '', '', 'barcode-icon', array($this, 'ca_barcode'));
     //Custom Action
     $output = $crud->render();
     //Config Halaman
     $output->judul_besar = 'Barcode';
     $output->judul_kecil = 'Generate Barcode';
     $output->m_barcode = TRUE;
     $this->_example_output($output);
 }

 public function tabelnya()
 {
     $crud = new grocery_CRUD();
     $crud->set_table('busaha');
     $crud->set_subject('Bidang Usaha');
     //$crud->columns('judul');
     //$crud->unset_print();
     //$crud->unset_export();
     //$crud->unset_add();
     //$crud->unset_edit();
     //$crud->unset_delete();
     $crud->unset_read();
     $output = $crud->render();
     $js_files = $output->js_files;
     $css_files = $output->css_files;
     $data['output'] = $output;
     $data['label'] = "Master Bidang Usaha";
     $this->load->view('home.php');
     $this->load->view('vtabel_master.php', array('js_files' => $js_files, 'css_files' => $css_files, 'output' => $data));
 }

 public function index()
 {
     $crud = new grocery_CRUD();
     $crud->set_theme('datatables');
     $crud->set_model('My_Custom_model');
     $crud->set_table('ips_ordertracking', 'ips_productitems');
     $crud->set_subject('Sales Tracking');
     $crud->required_fields('NAME');
     // void set_relation_n_n( string $field_name, string $relation_table, string $selection_table, string $primary_key_alias_to_this_table, string $primary_key_alias_to_selection_table , string $title_field_selection_table [ , string $priority_field_relation ] )
     $crud->set_relation_n_n('orderdetails', 'ips_ordertracking', 'ips_productitems', 'ips_ordertracking', 'ordertrackingid', 'description', 'category');
     // $crud->set_relation('ordertrackingid','ips_productitems','description');
     // $crud->columns('ordertrackingid','fullfillment','orderdate','orderid','returnid','itemrece','caseid','product','status','Action');
     // $crud->display_as('orderdate','Order Date')->display_as('orderid','Order ID')->display_as('returnid','Sales Return ID')->display_as('itemrece','Item Received')->display_as('caseid','Case ID')->display_as('product','Product Condition')->display_as('ordertrackingid','ID');
     $crud->columns('ordertrackingid', 'orderid', 'description', 'category', 'product', 'itemrece', 'cost', 'mrp', 'Action');
     $crud->display_as('orderid', 'Order ID')->display_as('itemrece', 'Item Received')->display_as('product', 'Product Condition')->display_as('ordertrackingid', 'ID')->display_as('description', 'Product Name')->display_as('category', 'Category')->display_as('cost', 'Recovery Min')->display_as('mrp', 'Recovery Max');
     $crud->callback_column('ordertrackingid', array($this, '_callback_webpage_url'));
     $crud->callback_column('orderdate', array($this, '_callback_dateformat'));
     $crud->callback_column('fullfillment', array($this, '_callback_fullfillment'));
     // $crud->callback_column('product',array($this,'_callback_product'));
     $crud->callback_column('status', array($this, '_callback_status'));
     $crud->callback_column('itemrece', array($this, '_callback_itemrece'));
     $crud->callback_column('cost', array($this, '_callback_recovery_min'));
     $crud->callback_column('mrp', array($this, '_callback_recovery_max'));
     $crud->callback_column('Action', array($this, '_callback_viewpage_url'));
     $crud->unset_edit();
     $crud->unset_read();
     $crud->unset_delete();
     // $crud->callback_after_insert(array($this, 'fullfillmentid_generation'));
     $output = $crud->render();
     $state = $crud->getState();
     if ($state == 'add') {
         redirect('store/addtracking');
     }
     if ($state == 'view') {
         redirect('store/viewtracking');
     }
     // $this->grocery_crud->set_table('ips_login');
     // $output = $this->grocery_crud->render();
     $this->_example_output($output);
 }

 public function listarUsuariosAdministradores()
 {
     $adm = $this->usuarios_model->buscarAdministrador($this->session->userdata('usuario'));
     $administrador = array();
     foreach ($adm as $dato) {
         $administrador[$dato->usuario] = $dato->nombres;
     }
     $crud = new grocery_CRUD();
     $crud->set_table('usuarios_backend');
     $crud->columns('usuario', 'nombres', 'dni', 'correo', 'nivel', 'estado', 'codigo', 'autoriza', 'caduca', 'registro');
     $crud->display_as('registroId', 'from usuarios_backend')->display_as('usuario', 'Usuario')->display_as('contrasena', 'Contraseña');
     $crud->change_field_type('clave', 'password');
     $crud->set_subject('Usuario');
     $crud->field_type('nivel', 'dropdown', array('1' => 'Administrador', '2' => 'Operador'));
     $crud->field_type('estado', 'dropdown', array('1' => 'Activo', '2' => 'Inactivo'));
     $crud->field_type('autoriza', 'dropdown', $administrador);
     $crud->callback_before_insert(array($this, 'encrypt_password_callback'));
     $crud->callback_before_update(array($this, 'encrypt_password_callback'));
     $crud->unset_read();
     $output = $crud->render();
     $this->_example_output($output);
 }