private function get_crud() { $this->data['message'] = $this->session->flashdata('message'); $crud = new grocery_CRUD(); $crud->set_theme(GROCERY_CRUD_THEME); $crud->set_table('usuario'); $crud->set_subject('Usuário'); $crud->unset_columns('id', 'senha', 'senha_anterior1', 'senha_anterior2', 'senha_anterior3', 'ultima_troca', 'cadastro'); $crud->fields('id', 'nome', 'login', 'email', 'grupos', 'tipo_usuario_id', 'situacao_usuario_id', 'senha', 'senha_anterior1', 'senha_anterior2', 'senha_anterior3'); $crud->unset_texteditor('id', 'senha', 'senha_anterior1', 'senha_anterior2', 'senha_anterior3', 'ultima_troca', 'cadastro'); $crud->change_field_type('id', 'invisible'); $crud->change_field_type('senha', 'invisible'); $crud->change_field_type('senha_anterior1', 'invisible'); $crud->change_field_type('senha_anterior2', 'invisible'); $crud->change_field_type('senha_anterior3', 'invisible'); $crud->set_relation('situacao_usuario_id', 'situacao_usuario', 'descricao'); $crud->display_as('situacao_usuario_id', 'Situacao'); $crud->set_relation('tipo_usuario_id', 'tipo_usuario', 'descricao'); $crud->display_as('tipo_usuario_id', 'Tipo de Usuário'); $crud->set_relation_n_n('grupos', 'grupo_usuario_x_usuario', 'grupo_usuario', 'usuario_id', 'grupo_usuario_id', 'descricao'); /* regras e campos obrigatórios */ $crud->required_fields('login', 'grupos', 'tipo_usuario_id', 'situacao_usuario_id'); $crud->set_rules('login', 'Login', 'required|min_length[2]'); $crud->set_rules('grupos', 'Grupos', 'required'); $crud->set_rules('tipo_usuario_id', 'Tipo de Usuário', 'required'); $crud->set_rules('situacao_usuario_id', 'Situação do Usuário', 'required'); $crud->callback_before_insert(array($this, 'checking_new_user')); return $crud->render(); }
public function index() { $bol_del_before_date = $this->m_conndb->dateBeforeDelete(); try { $crud = new grocery_CRUD(); $crud->set_theme('datatables'); $crud->set_table('tempahan'); $crud->set_subject('Booking Room'); $crud->set_relation('m_id', 'masa', 'm_desc'); $crud->set_relation('bm_id', 'bilik_meeting', 'bm_desc'); $crud->display_as('t_datereg', 'Date Reg.')->display_as('t_date', 'Book Date')->display_as('t_day', 'Book Day')->display_as('m_id', 'Time')->display_as('t_perkara', 'Club / Item')->display_as('bm_id', 'Meeting Room')->display_as('t_status', 'Status'); $crud->columns('t_date', 't_day', 'm_id', 't_perkara', 'bm_id'); $crud->fields('t_date', 'm_id', 't_perkara', 'bm_id', 't_datereg', 't_day'); $crud->field_type('t_datereg', 'hidden'); $crud->field_type('t_day', 'hidden'); $crud->required_fields('t_date', 'm_id', 't_perkara', 'bm_id'); $umaq = $this->uri->segment(3); if (!($this->uri->segment(3) && $umaq == 'umaqkacak')) { $crud->unset_delete(); $crud->unset_edit(); } $crud->callback_before_insert(array($this, 'setAutoTempahan')); $output = $crud->render(); $this->viewpage('v_bookroom', $output); } catch (Exception $e) { show_error($e->getMessage() . ' --- ' . $e->getTraceAsString()); } }
public function index($categoryid = 0) { $session_data = $this->session->userdata('logged_in'); $data['username'] = $session_data['username']; $data['cat_id'] = $categoryid; // $form_subject = ($categoryid==0 ? "Category" : "Sub Category"); if ($categoryid == 0) { $form_subject = "Category"; $data['cat_title'] = "Categories"; } else { $this->category->getTitle($categoryid); $data['cat_title'] = $this->category->getTitle($categoryid) . " - Sub Categories"; $form_subject = "Sub Category"; } $crud = new grocery_CRUD(); $crud->set_table('dbx_categories'); $crud->where('pid', $categoryid); $crud->set_subject($form_subject); $crud->required_fields('title'); $crud->columns('title'); $crud->callback_column('title', array($this, 'link_title')); $crud->set_rules('title', 'Title', 'trim|required|xss_clean|is_unique[dbx_categories.title]'); $crud->add_action('Sub Categories', '', '', 'cat-icon', array($this, 'goto_sub')); $crud->fields('title', 'desc', 'published', 'type', 'pid', 'ownerid', 'created_date'); $crud->field_type('pid', 'hidden', $categoryid); $crud->field_type('published', 'dropdown', array('0' => 'No', '1' => 'Yes')); $crud->field_type('type', 'dropdown', array('C' => 'Celebrity', 'M' => 'Movie', 'P' => 'Parent')); $crud->change_field_type('ownerid', 'invisible'); $crud->change_field_type('created_date', 'invisible'); $crud->callback_before_insert(array($this, 'before_insert')); $output = $crud->render($data); $this->load->view('header_view', $data); $this->load->view('categories_view', $output); $this->load->view('footer_view', $data); }
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 index() { $crud = new grocery_CRUD(); $crud->set_theme('bootstrap'); $crud->set_table('user'); $crud->set_subject('Gebruiker'); // hide fields $crud->columns('is_super_user', 'is_active', 'screen_name', 'email', 'gebruikersgroepen'); // new_password and new_password repeat are needed to make formvalidation work // id is needed to make the email unique check work $crud->fields('id', 'is_active', 'screen_name', 'email', 'gebruikersgroepen', 'password', 'new_password', 'new_password_repeat'); $crud->required_fields('email', 'screen_name', 'is_active'); $crud->set_relation_n_n('gebruikersgroepen', 'user_x_user_group', 'user_group', 'user_id', 'user_group_id', 'name'); $crud->field_type('id', 'hidden'); $crud->field_type('new_password_repeat', 'hidden'); $crud->field_type('password', 'hidden'); $crud->display_as('is_active', 'Actief'); $crud->display_as('screen_name', 'Schermnaam'); $crud->display_as('is_super_user', ''); $crud->display_as('new_password', 'Wachtwoord'); if ($crud->getState() == 'read') { $crud->field_type('new_password', 'hidden'); } else { $crud->callback_field('new_password', array($this, 'edit_field_callback_new_password')); } $crud->field_type('is_active', 'dropdown', array('yes' => 'ja', 'no' => 'nee')); $crud->callback_column('is_active', array($this, 'callback_list_is_active')); $crud->callback_column('is_super_user', array($this, 'callback_list_is_super_user')); $crud->callback_before_insert(array($this, 'before_insert_update_callback')); $crud->callback_before_update(array($this, 'before_insert_update_callback')); $crud->callback_after_insert(array($this, 'after_insert_callback')); $crud->callback_after_update(array($this, 'after_update_callback')); if ($crud->getState() === 'update_validation' or $crud->getState() === 'insert_validation') { $crud->set_rules('email', 'E-mail', 'required|valid_email|callback_email_unique_check'); $crud->set_rules('screen_name', 'Schermnaam', 'required'); if ($this->input->post('new_password') != '' or !$this->input->post('id')) { $crud->set_rules('new_password', 'Nieuw wachtwoord', 'required|min_length[10]|matches[new_password_repeat]'); $crud->set_rules('new_password_repeat', 'Herhaal nieuw wachtwoord', ''); } $this->form_validation->set_message('matches', 'De wachtwoorden zijn niet aan elkaar gelijk.'); } // render the crud HTML $crud_output = $crud->render(); //get the needed css and javascript files $this->javascript_files = $crud->get_js_files(); $this->css_files = $crud->get_css_files(); // put the crud content in the right position $this->views['content'] = $crud_output->output; $this->css[] = $this->load->view('admin/user/css/index.css', array(), true); // add javascript and css to make the password generate and change function possible if ($crud->getState() === 'add' or $crud->getState() === 'edit') { $this->css[] = $this->load->view('admin/user/css/edit_user.css', array(), true); $this->javascript[] = $this->load->view('admin/user/js/edit_user.js', array(), true); } // create the layout-HTML and show it to the user $this->_layout(); }
public function usuarios() { $crud = new grocery_CRUD(); $crud->set_table("usuarios"); $crud->required_fields('email', 'clave', 'nombre'); $crud->field_type('clave', 'password'); $crud->set_relation('idrol', 'roles', 'descripcion'); $crud->display_as('idrol', 'Rol'); $crud->callback_before_insert(array($this->User_Model, 'encrypt_password_callback')); $output = $crud->render(); $this->cargarVista($output); }
public function index($categoryid = 0) { $session_data = $this->session->userdata('logged_in'); $data['username'] = $session_data['username']; $data['lo'] = 2; //value used to identify section movie or celebrity $data['categoryid'] = $categoryid; //value used to identify section movie or celebrity if ($categoryid != 0) { $data['cat_id'] = $categoryid; $cat_title = $this->category->getTitle($categoryid); $data['cat_title'] = $cat_title . " - Movies"; $form_subject = $cat_title; $crud = new grocery_CRUD(); $crud->set_table('dbx_movies'); $crud->where('catid', $categoryid); $crud->set_subject('Movie'); $crud->required_fields('title', 'year'); $crud->columns('title'); // $crud->callback_column('name',array($this,'link_title')); // $crud->set_rules('title','Title','trim|required|xss_clean|is_unique[dbx_categories.title]'); $crud->add_action('Large Image', '', '', 'custom_icon limg-icon img_crop', array($this, 'set_imgurl')); $crud->add_action('Small Image', '', '', 'custom_icon simg-icon img_crop', array($this, 'set_imgurl')); $crud->fields('catid', 'title', 'year', 'release_date', 'cast', 'director', 'producer', 'music', 'writer', 'lyrics', 'synopsis', 'seo_url', 'ownerid', 'created_date', 'lastupdate_date'); // $crud->field_type('catid', 'hidden', $categoryid); $crud->set_relation('catid', 'dbx_categories', 'title', array('type' => 'M'), null, $categoryid); $crud->display_as('catid', 'Category'); // $crud->callback_add_field('cast', array($this, 'add_field_cast')); $crud->callback_add_field('synopsis', array($this, 'add_field_synopsis')); $crud->callback_edit_field('cast', array($this, 'edit_field_cast')); $crud->callback_edit_field('synopsis', array($this, 'edit_field_synopsis')); $crud->change_field_type('ownerid', 'invisible'); $crud->change_field_type('created_date', 'invisible'); $crud->change_field_type('seo_url', 'invisible'); $crud->change_field_type('lastupdate_date', 'invisible'); $crud->callback_before_insert(array($this, 'before_insert')); $crud->callback_before_update(array($this, 'before_update')); $crud->callback_after_insert(array($this, 'after_insert')); $crud->unset_jquery(); $state = $crud->getState(); // echo($state); $data['state'] = $state; $output = $crud->render($data); $this->load->view('header_view', $data); $this->load->view('movies_view', $output); $this->load->view('footer_view', $data); } }
public function index() { $crud = new grocery_CRUD(); $crud->set_table('pengumuman'); $crud->columns('isi', 'created_at', 'updated_at', 'status'); $crud->unset_export(); $crud->unset_print(); $crud->unset_texteditor('isi'); $crud->change_field_type('created_at', 'invisible'); $crud->change_field_type('updated_at', 'invisible'); $crud->callback_before_insert(array($this, "_timestamp")); $output = $crud->render(); $output->title = 'Kelola Pengumuman'; $this->template->load('template/template_main', 'admin/pengumuman', $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() { $this->authlibrary->hasPrivilege("announcement"); $crud = new grocery_CRUD(); $crud->set_table('announcement'); $crud->columns('isi', 'created_at', 'updated_at', 'status'); $crud->unset_export(); $crud->unset_print(); $crud->unset_texteditor('isi'); $crud->change_field_type('created_at', 'invisible'); $crud->change_field_type('updated_at', 'invisible'); $crud->callback_before_insert(array($this, "_timestamp")); $output = $crud->render(); $output->menu = "announcement"; $output->title = 'Announcement'; $this->template->load('backend/template', 'backend/grocery_crud_view', $output); }
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); }
function users_management() { $crud = new grocery_CRUD(); $crud->set_table('operarios'); $crud->set_subject('Usuario'); $crud->set_theme('datatables'); $crud->columns('id', 'nombre'); $crud->edit_fields('nombre', 'clave', 'eliminado'); $crud->add_fields('id', 'nombre', 'clave'); $crud->required_fields('id', 'nombre', 'clave'); $crud->change_field_type('clave', 'password'); $crud->callback_before_insert(array($this, '_encrypt_password_callback')); $crud->callback_before_update(array($this, '_encrypt_password_callback')); $crud->unset_delete(); $output = $crud->render(); $this->_output_crud($output, 'Usuarios'); }
function salidas() { if ($this->session->userdata('id')) { try { /* Creamos el objeto */ $crud = new grocery_CRUD(); /* Seleccionamos el tema */ $crud->set_theme('flexigrid'); /* Seleccionmos el nombre de la tabla de nuestra base de datos*/ $crud->set_table('salida'); /* Le asignamos un nombre */ $crud->set_subject('Salidas de productos'); $crud->set_relation('producto', 'productos', 'nombre'); $crud->set_relation('cliente', 'clientes', 'nombre'); //$crud->display_as('proveedor','Proveedor'); //$crud->set_subject('productos'); /* Asignamos el idioma español */ $crud->set_language('spanish'); /* Aqui le decimos a grocery que estos campos son obligatorios */ $crud->required_fields('producto', 'cantidad', 'cliente', 'folio', 'comentarios', 'precio', 'total'); /* Aqui le indicamos que campos deseamos mostrar */ $crud->columns('id', 'producto', 'cantidad', 'cliente', 'folio', 'comentarios', 'precio', 'total'); $crud->callback_column('precio', array($this, 'valuePeso')); $crud->callback_column('total', array($this, 'valuePeso')); $crud->callback_before_insert(array($this, 'checking_post_cantidad')); $crud->unset_delete(); $crud->unset_edit(); $crud->unset_export(); //$crud->add_action('Smileys', 'http://www.grocerycrud.com/assets/uploads/general/smiley.png', 'demo/action_smiley'); //$crud->callback_edit_field('cantidad',array($this,'edit_field_callback_1')); //$crud->callback_add_field('cantidad',array($this,'edit_field_callback_2')); /* Generamos la tabla */ $output = $crud->render(); /* La cargamos en la vista situada en /applications/views/productos/administracion.php */ $this->_example_output($output); } catch (Exception $e) { /* Si algo sale mal cachamos el error y lo mostramos */ show_error($e->getMessage() . ' --- ' . $e->getTraceAsString()); } } else { redirect('Login'); } }
/** * Index Page for CRUD sample controller. */ public function index() { if (!$this->ion_auth->logged_in()) { redirect('auth/login', 'refresh'); } $data['page_title'] = 'Crud sample'; $this->load->library('grocery_CRUD'); $crud = new grocery_CRUD(); $crud->set_table('items'); $crud->fields('name', 'updated', 'description', 'published'); $crud->required_fields('name'); $crud->field_type('updated', 'invisible'); $crud->unset_jquery(); $crud->set_theme('flexigrid-bootstrap3'); $crud->callback_before_update(array($this, '_crud_index_before_insert_or_update')); $crud->callback_before_insert(array($this, '_crud_index_before_insert_or_update')); $data = array_merge($data, (array) $crud->render()); $this->_make_layout('crud', $data); }
public function index() { $crud = new grocery_CRUD(); $crud->set_table('usrmgr'); $crud->change_field_type('password', 'password'); $crud->callback_edit_field('password', array($this, 'decrypt_password_callback')); $crud->columns('username', 'nama_lengkap', 'email', 'level', 'blokir'); $crud->callback_before_insert(array($this, 'encrypt_password_callback')); $crud->callback_before_update(array($this, 'encrypt_password_callback')); $crud->set_subject('Users'); $crud->fields('nama_lengkap', 'username', 'password', 'email', 'level', 'access_control', 'blokir'); $crud->required_fields('nama_lengkap', 'username', 'level', 'blokir'); $crud->set_relation_n_n('access_control', 'usrmgr_access', 'modul', 'id_users', 'id_modul', 'nama_modul', 'priority'); //$crud->set_relation('salesRepEmployeeNumber','employees','lastName'); $output = $crud->render(); $data['subject'] = 'Pengaturan Pengguna'; $data['content'] = $this->load->view('crud.php', $output, true); $this->load->view('base_theme', $data); }
public function index($categoryid = 0) { $session_data = $this->session->userdata('logged_in'); $data['username'] = $session_data['username']; $data['lo'] = 1; //value used to identify section movie or celebrity if ($categoryid != 0) { $data['cat_id'] = $categoryid; $cat_title = $this->category->getTitle($categoryid); $data['cat_title'] = $cat_title . " "; $form_subject = $cat_title; $crud = new grocery_CRUD(); $crud->set_table('dbx_celebrities'); $crud->where('catid', $categoryid); $crud->set_subject($form_subject); $crud->required_fields('name'); $crud->columns('name'); // $crud->callback_column('name',array($this,'link_title')); // $crud->set_rules('title','Title','trim|required|xss_clean|is_unique[dbx_categories.title]'); $crud->add_action('Large Image', '', '', 'custom_icon limg-icon img_crop', array($this, 'set_imgurl')); $crud->add_action('Small Image', '', '', 'custom_icon simg-icon img_crop', array($this, 'set_imgurl')); $crud->fields('catid', 'name', 'alt_name1', 'alt_name2', 'alt_name3', 'alt_name4', 'title', 'desc', 'sign', 'birth_date', 'birth_place', 'first_film', 'awards', 'height', 'weight', 'seo_url', 'ownerid', 'created_date', 'lastupdate_date'); // $crud->field_type('catid', 'hidden', $categoryid); $crud->set_relation('catid', 'dbx_categories', 'title', array('type' => 'C'), null, $categoryid); $crud->display_as('catid', 'Category'); $crud->callback_add_field('desc', array($this, 'add_field_desc')); $crud->callback_add_field('awards', array($this, 'add_field_awards')); $crud->callback_edit_field('desc', array($this, 'edit_field_desc')); $crud->callback_edit_field('awards', array($this, 'edit_field_awards')); $crud->field_type('sign', 'dropdown', array('Aries' => 'Aries', 'Taurus' => 'Taurus', 'Gemini1' => 'Gemini', 'Cancer' => 'Cancer', 'Leo' => 'Leo', 'Virgo' => 'Virgo', 'Libra' => 'Libra', 'Scorpio' => 'Scorpio', 'Sagittarius' => 'Sagittarius', 'Capricorn' => 'Capricorn', 'Aquarius' => 'Aquarius', 'Pisces' => 'Pisces')); $crud->change_field_type('ownerid', 'invisible'); $crud->change_field_type('created_date', 'invisible'); $crud->change_field_type('seo_url', 'invisible'); $crud->change_field_type('lastupdate_date', 'invisible'); $crud->callback_before_insert(array($this, 'before_insert')); $crud->callback_before_update(array($this, 'before_update')); $crud->unset_jquery(); $output = $crud->render($data); $this->load->view('header_view', $data); $this->load->view('celebrities_view', $output); $this->load->view('footer_view', $data); } }
public function data_topic() { $crud = new grocery_CRUD(); // table name $crud->set_table("help_topic"); // displayed columns on list $crud->columns('title', 'group_id', 'content'); // displayed columns on edit operation $crud->edit_fields('title', 'group_id', 'content'); // displayed columns on add operation $crud->add_fields('title', 'url', 'group_id', 'content'); // caption of each columns $crud->display_as('group_id', 'Group')->display_as('title', 'Title')->display_as('content', 'Content'); $crud->change_field_type('url', 'hidden'); $crud->set_relation('group_id', 'help_group', 'name'); $crud->callback_before_insert(array($this, 'before_insert_topic')); // render $output = $crud->render(); $this->view("grocery_CRUD", $output, "help_topic"); }
public function index() { $crud = new grocery_CRUD(); // crud settings $crud->set_theme('bootstrap'); $crud->set_table('user_group'); $crud->set_subject('Gebruikersgroepen'); $crud->columns('name', 'key'); $crud->display_as('name', 'Naam'); $crud->required_fields('name'); $crud->callback_before_insert(array($this, 'before_insert')); $crud->change_field_type('key', 'invisible'); $crud->set_relation_n_n('gebruikers', 'user_x_user_group', 'user', 'user_group_id', 'user_id', 'email'); // render the crud HTML $crud_output = $crud->render(); $this->javascript_files = $crud->get_js_files(); $this->css_files = $crud->get_css_files(); $this->views['content'] = $crud_output->output; $this->_layout(); }
/** * Función para contruir el Grocecy CRUD de la tabla Usuarios */ function abm_usuarios() { //Defino submenu $this->menu['submenuSeleccionado'] = 'Usuarios'; //Creo el objeto crud $crud = new grocery_CRUD(); //Defino Template como datatables. //$crud->set_theme('datatables'); //Defino tabla sobre la que trabajo y tipo de 'Objeto' $crud->set_table('Usuarios'); $crud->set_subject('Usuario'); //Agrego acción para cambiar contraseña. $crud->add_action('Cambiar Contraseña', base_url() . 'assets/grocery_crud/themes/flexigrid/css/images/key.png', 'administracion/usuarios/cambiar_contrasena'); //Un usuario puede tener un idPersonal asociado. $crud->set_relation('idPersonal', 'Personal', 'nombreApellido'); //Relación con los roles. $crud->set_relation_n_n('roles', 'RolesPorUsuario', 'Roles', 'idUsuario', 'idRol', 'descripcion'); //Seteo Reglas para campos $crud->set_rules('contrasena', 'Contraseña', 'required|matches[repetirContrasena]'); $crud->add_fields('nombreUsuario', 'contrasena', 'repetirContrasena', 'roles', 'idPersonal'); $crud->edit_fields('roles', 'idPersonal'); $crud->field_type('contrasena', 'password'); $crud->field_type('repetirContrasena', 'password'); //Seteo campos requeridos $crud->required_fields('nombreUsuario', 'contrasena', 'repetirContrasena', 'roles'); //Defino Columnas a Mostrar $crud->columns('nombreUsuario', 'roles'); //Defino nombres para cada campo. $crud->display_as('nombreUsuario', 'Nombre de Usuario'); $crud->display_as('contrasena', 'Contraseña'); $crud->display_as('repetirContrasena', 'Repetir Contraseña'); $crud->display_as('roles', 'Roles'); $crud->display_as('idPersonal', 'Persona Asociada'); //Hago 'callbacks' para transformar datos antes de inserción/actualización. $crud->callback_before_insert(array($this, '_transformar_datos')); $crud->callback_before_update(array($this, '_transformar_datos_update')); //Genero el ABM $output = $crud->render(); //Llamo a la función encargada de mostrar el ABM. mostrar_crud($output, '', $this->menu, 'administracion/usuarios/abm_usuarios', '', 'administracion/usuarios/abm_usuarios_final'); }
function crud_incidencias() { //creamos objeto crud $crud = new grocery_CRUD(); //Seleccionar la tabla incidencias $crud->set_table('incidencias'); //ocultar numero de incidencias xq se pondra automaticamente $crud->field_type('numero', 'hidden'); $crud->display_as("idtipo", "Tipo de Incidencia"); $crud->field_type('fecha_alta', 'hidden'); $crud->field_type('fecha_fin', 'hidden'); $crud->field_type('idusuario', 'hidden'); //menu despegable para tipo de inciencia $crud->field_type('idtipo', 'dropdown', array('1' => 'INF', '2' => 'MOBIL', '3' => 'OBR', '4' => 'FERR', '5' => 'FUS', '6' => 'ELECT', '7' => 'CRIS', '8' => 'PERS', '9' => 'PINT', '10' => 'CONS', '11' => 'FONT', '12' => 'COMPR')); //this xq esta en el mimso documento $crud->callback_before_insert(array($this, 'insertCallbackIncidencias')); //objetener la info de la tabla en un array, para despues mostrar $output = $crud->render(); //a la vista-backofffice le paso el output(array) $this->load->view('home/index', $output); }
function administracion() { try { /* Creamos el objeto */ $crud = new grocery_CRUD(); /* Seleccionamos el tema */ $crud->set_theme('bootstrap'); /* Seleccionmos el nombre de la tabla de nuestra base de datos*/ $crud->set_table('categorias'); /* Le asignamos un nombre */ $crud->set_subject('Categorias'); /* Asignamos el idioma español */ $crud->set_language('spanish'); /* Aqui le decimos con que campos vamos a trabajar-util para el callback */ $crud->fields('id', 'descripcion', 'creado_en'); /* Aqui le decimos que el campo del timestamp no sea visible */ $crud->change_field_type('creado_en', 'invisible'); /* Aqui le decimos a grocery que estos campos son obligatorios */ $crud->required_fields('descripcion'); /* Aqui definimos que campos seran visibles en el formulario de ingresos d ecategoria nueva */ $crud->add_fields('descripcion'); /* Aqui le indicamos que campos deseamos mostrar al listar */ $crud->columns('id', 'descripcion', 'creado_en'); /*Le cambiamos en nombre al la columna id */ $crud->display_as('id', 'Referencia'); /* llamamos al call_back antes del insert (pone la fecha) */ $crud->callback_before_insert(array($this, 'guardar_fecha')); //$crud->unset_jquery(); /* Generamos la tabla */ $output = $crud->render(); /* La cargamos en la vista situada en /applications/views/productos/administracion.php */ $this->load->view('header'); $this->load->view('categorias/administracion', $output); $this->load->view('footer'); } catch (Exception $e) { /* Si algo sale mal cachamos el error y lo mostramos */ show_error($e->getMessage() . ' --- ' . $e->getTraceAsString()); } }
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); }
/** * function ni digunakan untuk kv urus maklumat kursus kolej pada crud * input: - * author: Mior Mohd Hanif * Date: 28 Jun 2013 * Modification Log: 4 Julai 2013 by Mior - fixed bug insert * 18 Julai 2013 by Mior - fixed bug before insert and update */ function college_course_management() { $user_login = $this->ion_auth->user()->row(); $col_id = $user_login->col_id; $crud = new grocery_CRUD(); $crud->set_theme('flexigrid'); $crud->set_subject('Kursus Kolej'); $crud->set_table('college_course'); $crud->set_relation('cou_id', 'course', '{cou_course_code} - {cou_name}'); $crud->columns('cou_course_code', 'cou_name', 'cou_cluster'); $crud->callback_column('cou_course_code', array($this, '_callback_cou_course_code')); $crud->callback_column('cou_name', array($this, '_callback_cou_name')); $crud->callback_column('cou_cluster', array($this, '_callback_cou_cluster')); $crud->display_as('cou_id', 'Kursus')->display_as('cou_course_code', 'Kod Kursus')->display_as('cou_name', 'Nama Kursus')->display_as('cou_cluster', 'Kluster'); $crud->required_fields('cou_id'); $crud->field_type('col_id', 'invisible'); $crud->callback_before_insert(array($this, 'callback_col_id')); $crud->callback_before_update(array($this, 'callback_col_id')); $crud->where('col_id', $col_id); $output = $crud->render(); $header = "<legend><h4>Penyelenggaraan Kursus Kolej</h4></legend>"; $this->_main_output($output, $header); }
public function user() { $this->load->model('login_model'); if ($this->__check_auth()) { if ($this->login_model->get_access_level() >= 10) { try { // new object $crud = new grocery_CRUD(); // sets table to use $crud->set_table('user'); $crud->set_subject('Utilisateur'); // callbacks for password editing $crud->callback_edit_field('password_hash', array($this, '__clean_field')); $crud->callback_before_insert(array($this, '__password_user_before_insert')); $crud->callback_before_update(array($this, '__password_user_before_update')); // links foreign keys $crud->set_relation('user_type_id', 'user_type', 'name'); $crud->set_relation('user_state_id', 'user_state', 'name'); $crud->set_relation('department_id', 'department', 'name'); // renders the table in output $output = $crud->render(); // sets some text to determine which table is edited $output->current = 'Utilisateur'; // display all $this->_view_output($output); } catch (Exception $e) { show_error($e->getMessage() . ' --- ' . $e->getTraceAsString()); } } else { show_error('L\'utilisateur n\'a pas les privilèges nécessaires.'); die; } } else { // if not authentified send back to login redirect('login'); } }
function users() { $crud = new grocery_CRUD(); $crud->set_theme('datatables'); $crud->set_table('user'); $crud->display_as('login', 'Username'); $crud->display_as('user_name', 'Name'); $crud->set_subject('User'); $crud->columns('login', 'user_type', 'user_name', 'email', 'mobile'); $crud->required_fields('login', 'user_type', 'user_name', 'email', 'mobile'); $crud->set_rules('email', 'Email', 'trim|required|valid_email'); $crud->change_field_type('password', 'password'); // Cripatare password $crud->callback_before_insert(array($this, 'encrypt_password_callback')); $crud->callback_edit_field('password', array($this, 'set_password_input_to_empty')); $crud->callback_before_update(array($this, 'encrypt_password_callback')); //$crud->callback_edit_field('password',array($this,'decrypt_password_callback')); // Realatii baza de date //$crud->set_relation('grup','grup','grup_name'); //$crud->set_field_upload('imagine_monitor','assets/uploads/files'); $crud->field_type('user_type', 'dropdown', array('admin' => 'admin', 'user' => 'user')); $output = $crud->render(); $this->_admin_output($output); }
function toppers_ans_booklets() { $expertid = $this->tank_auth->get_user_id(); $TAB_HOME = "visionias_data/assets/home/resources/toppers_ans_booklets"; $crud = new grocery_CRUD(); $crud->set_theme('datatables'); $crud->set_table('toppers_ans_booklets'); $crud->columns('name', 'rank', 'notification_year', 'res_loc', 'subject_id', 'test_id'); $crud->display_as('res_loc', 'Choose File'); $crud->display_as('subject_id', 'Subject'); $crud->display_as('notification_year', 'CSE Year'); $crud->unset_columns('created_by', 'time_of_creation'); $crud->set_subject("Toppers' Answer Booklets"); $crud->set_relation('subject_id', 'subjects', '{subject_id}-{subject_name}'); $crud->field_type('created_by', 'hidden', $expertid); $crud->field_type('view_count', 'hidden'); $crud->field_type('time_of_creation', 'hidden', date('Y-m-d H:i:s')); $crud->set_field_upload('res_loc', "{$TAB_HOME}"); $crud->callback_before_insert(array($this, 'move_resource_file')); $output = $crud->render(); $this->_example_output($output); }
public function sub_Category() { $crud = new grocery_CRUD('default'); $crud->set_table('subcategories_master'); $crud->set_subject('SubCategory'); $crud->display_as('category', 'SubCategory')->display_as('category_id', 'Select Category'); $crud->unset_add_fields('flag', 'created_date'); $crud->unset_edit_fields('flag', 'created_date'); $crud->callback_before_insert(array($this, 'callback_getmax_app_cat_id')); $crud->unset_columns('applicable_category_id', 'flag', 'created_date'); $crud->set_relation('category_id', 'categories_master', 'category'); $crud->field_type('applicable_category_id', 'invisible'); //$crud->unset_add(); //$crud->unset_edit(); //$crud->unset_delete(); $data = $crud->render(); $this->load->view('admin/crud_view', $data); }
public function widget() { $crud = new grocery_CRUD(); $crud->set_table('cms_widget'); $crud->set_subject('Widget'); $crud->columns('widget_name', 'title', 'active', 'is_static', 'description', 'authorization_id', 'slug', 'groups'); $crud->edit_fields('widget_name', 'title', 'active', 'description', 'index', 'is_static', 'static_content', 'url', 'slug', 'authorization_id', 'groups'); $crud->add_fields('widget_name', 'title', 'active', 'description', 'index', 'is_static', 'static_content', 'url', 'slug', 'authorization_id', 'groups'); $crud->change_field_type('active', 'true_false'); $crud->change_field_type('is_static', 'true_false'); $crud->change_field_type('index', 'integer'); $crud->display_as('widget_name', 'Widget Code')->display_as('title', 'Title (What visitor see)')->display_as('active', 'Active')->display_as('description', 'Description')->display_as('url', 'URL (Where is it point to)')->display_as('index', 'Order')->display_as('is_static', 'Static')->display_as('static_content', 'Static Content')->display_as('slug', 'Slug')->display_as('authorization_id', 'Authorization')->display_as('groups', 'Groups'); $crud->unset_texteditor('static_content'); $crud->unset_texteditor('description'); $crud->set_relation('authorization_id', 'cms_authorization', 'authorization_name'); $crud->set_relation_n_n('groups', 'cms_group_widget', 'cms_group', 'widget_id', 'group_id', 'group_name'); $crud->callback_before_insert(array($this, 'before_insert_widget')); $crud->callback_column('active', array($this, 'column_widget_active')); $output = $crud->render(); $this->view('main/widget', $output, 'main_widget_management'); }
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 comment($article_id = NULL) { $crud = new grocery_CRUD(); $crud->set_table('blog_comment'); if (isset($article_id) && intval($article_id) > 0) { $crud->where('blog_comment.article_id', $article_id); $crud->change_field_type('article_id', 'hidden'); } $crud->columns('article_id', 'content'); $crud->unset_add(); $crud->unset_edit(); $crud->display_as('article_id', 'title'); $crud->set_relation('article_id', 'blog_article', 'article_title'); $crud->callback_before_insert(array($this, 'before_insert_comment')); $output = $crud->render(); $this->view('grocery_CRUD', $output, 'blog_comment'); }