public function crud() { $crud = new grocery_CRUD(); $crud->set_theme(THEMA_CRUD); $crud->set_table('quadra'); $crud->set_subject('Quadra'); //@todo$crud->where('situacao_id', 2); //apenas ativos $crud->required_fields('descricao', 'tipo_quadra_id', ''); $crud->columns('id', 'descricao', 'tipo_quadra_id', 'situacao_quadra_id'); $crud->edit_fields('descricao', 'tipo_quadra_id', 'situacao_quadra_id'); $crud->add_fields('descricao', 'tipo_quadra_id', 'situacao_quadra_id'); //relacionamentos $crud->set_relation('situacao_quadra_id', 'situacao_quadra', 'descricao'); $crud->set_relation('tipo_quadra_id', 'tipo_quadra', 'descricao'); $crud->callback_insert(array($this, 'create')); $crud->callback_delete(array($this, 'delete')); $contents = $crud->render(); $this->template->set('titulo', 'Manter Quadra'); $this->template->set('subtitle', 'Quadra'); $this->template->load('template_teste', 'crudpage', $contents); }
public function users() { $crud = new grocery_CRUD(); $crud->set_table('users'); $crud->set_subject('Users'); $crud->columns('username', 'email', 'groups', 'active'); if ($this->uri->segment(3) !== 'read') { $crud->add_fields('username', 'first_name', 'last_name', 'email', 'phone', 'groups', 'password', 'password_confirm'); $crud->edit_fields('username', 'first_name', 'last_name', 'email', 'phone', 'groups', 'last_login', 'old_password', 'new_password'); } else { $crud->set_read_fields('username', 'first_name', 'last_name', 'email', 'phone', 'groups', 'last_login'); } $crud->set_relation_n_n('groups', 'users_groups', 'groups', 'user_id', 'group_id', 'name'); //VALIDATION $crud->required_fields('username', 'first_name', 'last_name', 'email', 'phone', 'password', 'password_confirm'); $crud->set_rules('email', 'E-mail', 'required|valid_email'); $crud->set_rules('phone', 'Phone', 'required|numeric'); $crud->set_rules('password', 'Password', 'required|min_length[' . $this->config->item('min_password_length', 'ion_auth') . ']|max_length[' . $this->config->item('max_password_length', 'ion_auth') . ']|matches[password_confirm]'); $crud->set_rules('new_password', 'New password', 'min_length[' . $this->config->item('min_password_length', 'ion_auth') . ']|max_length[' . $this->config->item('max_password_length', 'ion_auth') . ']'); //FIELD TYPES $crud->change_field_type('last_login', 'readonly'); $crud->change_field_type('password', 'password'); $crud->change_field_type('password_confirm', 'password'); $crud->change_field_type('old_password', 'password'); $crud->change_field_type('new_password', 'password'); //CALLBACKS $crud->callback_insert(array($this, 'create_user_callback')); $crud->callback_update(array($this, 'edit_user_callback')); $crud->callback_field('last_login', array($this, 'last_login_callback')); $crud->callback_column('active', array($this, 'active_callback')); //VIEW $output = $crud->render(); $data['judul'] = 'Users'; $data['crumb'] = array('Users' => ''); $template = 'admin_template'; $view = 'grocery'; $this->outputview->output_admin($view, $template, $data, $output); }
public function crud() { $crud = new grocery_CRUD(); $crud->set_theme(THEMA_CRUD); $crud->set_table('usuario'); $crud->set_subject('Usuarios'); $crud->required_fields('nome', 'login', 'email', 'tipo_usuario_id', 'situacao_id'); $crud->columns('nome', 'login', 'email', 'tipo_usuario_id', 'situacao_id'); $crud->edit_fields('nome', 'login', 'email', 'tipo_usuario_id', 'situacao_id'); $crud->add_fields('nome', 'login', 'email', 'tipo_usuario_id'); $crud->set_relation('tipo_usuario_id', 'tipo_usuario', 'descricao'); $crud->set_relation('situacao_id', 'situacao', 'descricao'); $crud->callback_insert(array($this, 'create')); $crud->callback_delete(array($this, 'delete')); $crud->callback_update(array($this, 'update')); $crud->where('situacao_id', 1); $crud->or_where('situacao_id', 2); $contents = $crud->render(); // $this->load->view('template_crud', $contents); $this->template->set('titulo', 'Manter Usuário'); $this->template->set('subtitle', 'Usuário'); // nome do template , nome da view $this->template->load('template_teste', 'crudpage', $contents); }
function supervisor_management() { $id = $this->ion_auth->user()->row()->id; $this->load->library('grocery_CRUD'); try { $crud = new grocery_CRUD(); $this->load->library('user_agent'); if ($this->agent->is_mobile() && $this->agent->is_tablet() === FALSE) { $crud->set_theme('bootstrap'); $crud->unset_search(); } else { $crud->set_theme('datatables'); //datatables, flexigrid, bootstrap } $crud->set_table('users'); $crud->set_subject('Supervisor'); $crud->columns('username', 'password_visible', 'su_branch_id', 'su_can_uploadhotdeal'); $crud->required_fields('username', 'password_visible', 'su_branch_id'); $crud->fields('username', 'password_visible', 'su_branch_id', 'su_can_uploadhotdeal'); $crud->display_as('password_visible', 'Password'); $crud->display_as('su_branch_id', 'Branch'); $crud->display_as('su_can_uploadhotdeal', 'Able to upload food & beverage'); $crud->callback_add_field('su_branch_id', array($this, '_selected_branch_callback')); //For add page set pre-selected value if got pass in brach id $crud->field_type('su_branch_id', 'dropdown', $this->ion_auth->get_merchant_branch_list($id)); //For view show the branch list text $crud->callback_insert(array($this, 'supervisor_insert_callback')); $crud->callback_update(array($this, 'supervisor_update_callback')); $crud->set_rules('username', 'Username', 'trim|required|callback_supervisor_username_check'); $crud->field_type('su_can_uploadhotdeal', 'true_false'); $controller = 'merchant'; $function = 'profile'; $crud->set_lang_string('insert_success_message', 'Your data has been successfully stored into the database. <script type="text/javascript"> var originallocation = window.location.pathname; if(originallocation.indexOf("/supervisor/add") > -1) { window.location = "' . site_url($controller . '/' . $function) . '"; } </script> <div style="display:none"> '); $crud->set_lang_string('update_success_message', 'Your data has been successfully stored into the database. <script type="text/javascript"> var originallocation = window.location.pathname; if(originallocation.indexOf("/supervisor/edit") > -1) { window.location = "' . site_url($controller . '/' . $function) . '"; } </script> <div style="display:none"> '); $crud->set_lang_string('form_save_and_go_back', 'Save and View Supervisor'); $crud->set_lang_string('form_update_and_go_back', 'Update and View Supervisor'); $crud->unset_export(); $crud->unset_print(); $crud->unset_read(); $state = $crud->getState(); //filter that this is supervisor type user and it is under this merchant $crud->where('su_merchant_id', $id); $crud->where('main_group_id', $this->group_id_supervisor); $output = $crud->render(); return $output; } catch (Exception $e) { show_error($e->getMessage() . ' --- ' . $e->getTraceAsString()); } }
public function notificacionAutoriza() { if ($this->session->userdata('nivel') != 5 or $this->session->userdata('institucion') != 'A') { $this->session->set_flashdata('error', 'Su nivel de usuario no le permite realizar este proceso'); redirect(site_url("index/principal"), 301); } switch ($this->session->userdata('nivel')) { case 5: $anio = array(); for ($i = 2010; $i <= date("Y"); $i++) { $anio[$i] = $i; } $semana = array(); for ($i = 1; $i <= 53; $i++) { $semana[$i] = $i; } $sub = $this->frontend_model->mostrarDiresa($this->session->userdata('diresa')); $subr = array(); foreach ($sub as $dato) { $subr[$dato->codigo] = $dato->nombre; } $tipo = array('1' => 'Autorizado', '2' => 'No autorizado'); $crud = new grocery_CRUD(); $crud->columns('ano', 'semana', 'diresa', 'estado', 'fecha', 'hora', 'usuario'); $crud->set_table('autoriza'); $crud->set_subject('Autorización'); $where = array('diresa' => $this->session->userdata('diresa')); $crud->fields('ano', 'semana', 'diresa', 'estado'); $crud->display_as('ano', 'Año'); $crud->field_type('ano', 'dropdown', $anio); $crud->field_type('semana', 'dropdown', $semana); $crud->field_type('diresa', 'dropdown', $subr); $crud->field_type('estado', 'dropdown', $tipo); $crud->required_fields('diresa', 'ano', 'semana', 'estado'); $crud->where($where); $crud->order_by('ano, semana', 'DESC'); $crud->callback_insert(array($this, 'autorizar')); $output = $crud->render(); $this->_example_output3($output); break; default: $this->session->set_flashdata('error', 'Este proceso no está permitido para su nivel de usuario'); redirect(site_url("index/principal"), 301); break; } }
public function room_residents($primary_key) { $crud = new grocery_CRUD(); $crud->where('room_resident.room_id', $primary_key); $crud->set_subject('Resident'); $crud->set_table('room_resident'); $crud->set_relation('room_id', 'room', '{room_name}'); $crud->set_relation('resident_id', 'resident', '{resident_othernames} {resident_surname}'); $crud->required_fields('resident_id'); $crud->unset_columns('room_resident_priority'); $crud->unset_fields('room_resident_date', 'room_resident_priority', 'room_resident_status', 'room_resident_date_released'); $crud->display_as('room_resident_date', 'Date Added'); $crud->display_as('room_resident_date_released', 'Date Released'); $crud->display_as('resident_id', 'Resident'); $crud->display_as('room_id', 'Room'); $crud->display_as('room_resident_status', 'Status'); $crud->callback_column('room_resident_status', array($this, 'callback_status')); //$crud->add_action('Residents', base_url().'img/icons/icon-48-groups-add.png', 'front_office/room_details/'.$_SESSION['navigation_id'].'/'.$_SESSION['sub_navigation_id']); $crud->callback_insert(array($this, 'check_room_capacity')); $crud->field_type('room_id', 'hidden', $primary_key); $crud->unset_edit(); $output = $crud->render(); $this->_example_output3($output); }