function administration() { try { // $this->output->enable_profiler(TRUE); /** * Cargar Roles de Usuarios existentes */ // $user_role = $this->users->users_perfil_get_where(); // $role = array(); // for ($i = 0; $i < count($user_role); $i++) { // $role[$i] = $user_role[$i]->perfil; // } // var_dump($role); $crud = new Grocery_CRUD(); $crud->set_theme('flexigrid'); $crud->set_table('users'); $crud->set_subject('Usuarios'); $crud->set_language('spanish'); $crud->unset_export(); $crud->required_fields('perfil', 'username', 'password'); $crud->add_fields('username', 'password', 'perfil'); $crud->display_as('perfil', 'Perfil')->display_as('username', 'Nombre de usuario')->display_as('password', 'Contraseña'); $crud->set_relation('perfil', 'users_perfil', 'role'); $crud->field_type('password', 'password'); // $crud->edit_fields('password', 'password'); // $crud->field_type('perfil', 'dropdown', array(1 => 'Administrador', 2 => 'Editor')); $output = $crud->render(); $this->load->view('includes/template', $output); } catch (Exception $e) { /* Si algo sale mal cachamos el error y lo mostramos */ show_error($e->getMessage() . ' --- ' . $e->getTraceAsString()); } }
public function irrigationprofile() { $crud = new Grocery_CRUD(); $crud->set_model('crud_model'); $crud->set_table('irr_history')->set_theme('datatables')->columns('irr_id', 'province', 'municipality', 'barangay', 'service_area', 'farmers_served', 'year')->display_as('irr_id', 'Name of Irrigation')->display_as('service_area', 'Area served (ha)')->display_as('farmers_served', 'No. of farmers served')->set_relation('irr_id', 'irrigation', 'irr_name')->unset_read()->fields('irr_id', 'province', 'municipality', 'barangay', 'harvest_fac', 'fm_road', 'year'); $crud->required_fields('irr_id', 'province'); $crud->callback_before_insert(array($this, '_callback_place_id')); $crud->callback_before_update(array($this, '_callback_place_id')); $crud->callback_field('province', array($this, '_callback_province')); $this->dependent_dropdown_place($crud, 'irr_history', 'irrhist_id'); }
public function user_setup() { $crud = new Grocery_CRUD(); $crud->set_table('user')->set_subject('User'); $crud->display_as('user_name', 'User Name')->display_as('user_level', 'User Level')->display_as('cash_register_id', 'Cash Register Name'); $crud->set_relation('cash_register_id', 'cash_register', 'cash_register_name'); $crud->field_type('user_level', 'dropdown', array('admin' => 'Admin', 'manager' => 'Manager', 'user' => 'User')); $crud->field_type('status', 'dropdown', array('active' => 'Active', 'inactive' => 'Inactive')); $crud->required_fields('user_name', 'password', 'user_level', 'cash_register_id', 'status'); $output = $crud->render(); $this->load->view('admin/security_view', $output); }
public function cropprofile() { $crud = new Grocery_CRUD(); $crud->set_model('crud_model'); $crud->set_table('crop_history')->set_theme('datatables')->columns('crop_id', 'province', 'municipality', 'barangay', 'area', 'volume', 'value', 'year')->display_as('crop_id', 'Crops')->display_as('area', 'Area planted or harvested (ha)')->display_as('volume', 'Volume of Production (metric tons)')->display_as('value', 'Value of Production (thousand php)')->set_relation('crop_id', 'crops', 'crop_species')->unset_read(); $crud->fields('place_id', 'crop_id', 'province', 'municipality', 'barangay', 'area', 'volume', 'value'); $crud->field_type('place_id', 'invisible'); $crud->required_fields('province', 'crop_id'); $crud->callback_field('province', array($this, '_callback_province')); $crud->callback_before_insert(array($this, '_callback_place_id')); $crud->callback_before_update(array($this, '_callback_place_id')); $this->dependent_dropdown_place($crud); }
public function waterbodies() { $crud = new Grocery_CRUD(); $crud->set_model('crud_model'); $crud->set_table('water_body')->set_theme('datatables')->columns('water_name', 'water_type', 'province', 'municipality', 'barangay', 'count')->display_as('water_name', 'Name of water body')->display_as('water_type', 'Type / kind of water body')->display_as('area', 'Area planted or harvested (ha)')->display_as('area', 'Area covered (ha)')->unset_read(); $crud->fields('water_id', 'water_name', 'water_type', 'place_id', 'province', 'municipality', 'barangay', 'count'); $crud->field_type('place_id', 'invisible'); $crud->field_type('water_id', 'invisible'); $crud->required_fields('water_type', 'province'); $crud->change_field_type('water_type', 'enum', $this->aquatic_model->get_watertype()); $crud->callback_before_insert(array($this, '_callback_place_id')); $crud->callback_before_update(array($this, '_callback_place_id')); $crud->callback_field('province', array($this, '_callback_province')); $this->dependent_dropdown_place($crud, 'water_body', 'water_id'); }
function placeprofile() { $crud = new Grocery_CRUD(); $crud->set_model('crud_model'); $crud->set_table('place_history'); $crud->columns('province', 'municipality', 'barangay', 'land_area', 'population', 'year'); $crud->unset_read(); $crud->set_theme('datatables'); $crud->fields('place_id', 'province', 'municipality', 'barangay', 'land_area', 'population', 'year'); $crud->field_type('place_id', 'invisible'); $crud->required_fields('province'); $crud->callback_before_insert(array($this, '_callback_place_id')); $crud->callback_before_update(array($this, '_callback_place_id')); $crud->callback_field('province', array($this, '_callback_province')); $this->dependent_dropdown_place($crud); $output = $crud->render(); }