public function irrigation() { $crud = new Grocery_CRUD(); $crud->set_table('irrigation')->set_theme('datatables')->unset_columns('irr_id')->fields('irr_id', 'irr_name')->display_as('irr_name', 'Irrigation Name')->change_field_type('irr_id', 'invisible')->unset_read()->callback_before_insert(array($this, '_callback_add_irrID')); $output = $crud->render(); $this->displayOutput($output); }
function administration() { try { $crud = new Grocery_CRUD(); $crud->set_theme('flexigrid'); $crud->set_table('banners'); $crud->set_subject('banner'); $crud->set_language('spanish'); $crud->unset_export(); $crud->columns('title', 'category', 'fk_type', 'parent', 'active'); // $crud->set_relation('fk_type', 'types_banner', 'type'); $crud->set_relation_n_n('owner', 'banner_owner', 'owners', 'fk_banner', 'fk_owner', 'name'); $crud->set_relation_n_n('category', 'banner_categories', 'categories', 'fk_banner', 'fk_category', 'category'); $crud->set_relation_n_n('parent', 'banners_parent', 'banners', 'fk_child', 'fk_parent', 'title'); $crud->set_relation_n_n('tags', 'banner_tag', 'tags', 'fk_banner', 'fk_tag', 'tag'); // $crud->set_relation_n_n('text', 'banner_text', 'text', 'fk_banner', 'fk_text', 'text'); $crud->change_field_type('like', 'hidden'); $crud->display_as('title', 'Título')->display_as('sumary', 'Sumario')->display_as('email', 'Correo')->display_as('date_publication', 'Inicio de publicidad')->display_as('published_to_date', 'Fin de publicidad')->display_as('active', 'Estado')->display_as('priority', 'Prioridad')->display_as('category', 'Categoría')->display_as('fk_type', 'Tipo')->display_as('owner', 'Propietario')->display_as('parent', 'Banner padre')->display_as('tags', 'Palabras claves'); // $crud->callback_add_field('text', array($this, 'field_add_text_callback')); // $crud->callback_after_insert(array($this, 'after_insert')); $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()); } }
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 crops() { $crud = new Grocery_CRUD(); //$crud->set_theme('datatables'); $crud->set_table('crops')->set_theme('datatables')->set_subject('Crops')->order_by('crop_species')->unset_columns('crop_id')->unset_read()->display_as('crop_species', 'Crop type')->display_as('crop_type', 'Crop category')->fields('crop_id', 'crop_species', 'crop_type')->required_fields('crop_species', 'crop_type')->change_field_type('crop_id', 'invisible')->change_field_type('crop_type', 'enum', $this->terrestrial_model->get_croptype())->callback_before_insert(array($this, '_callback_add_cropID')); $output = $crud->render(); $this->displayOutput($output); }
public function aquaticresources() { $crud = new Grocery_CRUD(); //$crud->set_theme('twitter-bootstrap'); $crud->set_table('aquatic_rsc')->set_theme('datatables')->set_subject('Aquatic Resources')->order_by('aqua_species')->unset_columns('aqua_id')->unset_read()->display_as('aqua_id', 'Aquatic type')->display_as('aqua_type', 'Aquatic category')->fields('aqua_id', 'aqua_species', 'aqua_type')->required_fields('aqua_species', 'aqua_type')->change_field_type('aqua_id', 'invisible')->change_field_type('aqua_type', 'enum', $this->aquatic_model->get_aquatype())->callback_before_insert(array($this, '_callback_add_aquaID')); $output = $crud->render(); $this->displayOutput($output); }
public function entertainment() { $crud = new Grocery_CRUD(); $crud->set_table('entertainment'); $crud->set_subject('entertainment'); $output = $crud->render(); $this->load->view('admin/transaction_view', $output); }
public function cash_reconciliation_entry() { $crud = new Grocery_CRUD(); $crud->set_table('cash_reconciliation'); $crud->set_subject('Cash Reconciliation'); $crud->unset_add()->unset_edit()->unset_delete(); $output = $crud->render(); $this->load->view('manager/transaction_view', $output); }
public function entertainment_report() { $crud = new Grocery_CRUD(); $crud->set_table('entertainment'); $crud->set_subject('entertainment'); $crud->unset_operations(); $output = $crud->render(); $this->load->view('manager/common_report_view', $output); }
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); }
function administration() { try { $crud = new Grocery_CRUD(); $crud->set_theme('flexigrid'); $crud->set_table('types_banner'); $crud->set_subject('Tipos de banner'); $crud->set_language('spanish'); $crud->unset_export(); $crud->display_as('type', 'Tipo'); $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()); } }
function administration() { try { $crud = new Grocery_CRUD(); $crud->set_theme('flexigrid'); $crud->set_table('sources'); $crud->set_subject('Fuentes'); $crud->set_language('spanish'); $crud->unset_export(); $crud->display_as('name', 'Nombre')->display_as('link', 'Enlace (URL)')->display_as('feed_rss', 'RSS (URL)'); $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()); } }
function administration() { try { $crud = new Grocery_CRUD(); $crud->set_theme('flexigrid'); $crud->set_table('categories_news'); $crud->set_subject('Categorías'); $crud->set_language('spanish'); $crud->unset_export(); $crud->display_as('name', 'Nombre')->display_as('active', 'Activo'); /* Generamos la tabla */ $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()); } }
function administration() { try { $crud = new Grocery_CRUD(); $crud->set_theme('flexigrid'); $crud->set_table('rates_change'); $crud->set_subject('Cambio de Moneda'); $crud->set_language('spanish'); $crud->unset_export(); $crud->set_relation('fk_operation', 'operation', 'operation'); $crud->display_as('coin', 'Moneda')->display_as('change', 'Cambio')->display_as('fk_operation', 'Operación'); $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 render() { $this->pre_render(); $this->state_code = $this->getStateCode(); if ($this->state_code != 0) { $this->state_info = $this->getStateInfo(); } else { throw new Exception('The state is unknown , I don\'t know what I will do with your data!', 4); die; } switch ($this->state_code) { case 2: //add $this->render_relation_dependencies(); $output = parent::render(); break; case 3: //edit $this->render_relation_dependencies(); $output = parent::render(); break; case 6: //update $this->render_relation_dependencies(); $output = parent::render(); break; case 101: //ajax_extension $state_info = $this->getStateInfo(); $ajax_extension_result = $this->ajax_extension($state_info); $ajax_extension_result[""] = ""; echo json_encode($ajax_extension_result); die; break; default: $output = parent::render(); break; } if (empty($output)) { $output = $this->get_layout(); } else { } return $output; }
function administration() { try { $crud = new Grocery_CRUD(); $crud->set_theme('flexigrid'); $crud->set_table('useful_info'); $crud->set_subject('Informaciones Útiles'); $crud->set_language('spanish'); $crud->unset_export(); $crud->columns('question', 'active', 'sites', 'banner'); $crud->set_relation_n_n('sites', 'useful_info_sites', 'sites', 'fk_useful_info', 'fk_site', 'name'); $crud->set_relation_n_n('banner', 'useful_info_banner', 'banners', 'fk_useful_info', 'fk_banner', 'title'); $crud->display_as('question', 'Pregunta')->display_as('active', 'Estado')->display_as('priority', 'Prioridad')->display_as('sites', 'Sitio'); $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()); } }
function administration() { try { $crud = new Grocery_CRUD(); $crud->set_theme('flexigrid'); $crud->set_table('metas'); $crud->set_subject('Meta Datos'); $crud->set_language('spanish'); $crud->unset_export(); // $crud->columns('nombre', 'fk_charset', 'fk_lang', 'active', 'contenido'); $crud->add_fields('nombre', 'contenido', 'activo'); // $crud->set_relation('fk_charset', 'meta_charset', 'charset'); // $crud->set_relation('fk_lang', 'languages', 'language'); $crud->display_as('activo', 'Estado'); $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()); } }
function administration() { try { // $crud = new Grocery_CRUD(); $crud->set_theme('flexigrid'); $crud->set_table('user_log'); $crud->set_subject('Trazas de Usuarios'); $crud->set_language('spanish'); $crud->unset_export(); $crud->unset_add(); $crud->unset_edit(); $crud->unset_delete(); // $crud->unset_operations(); $crud->columns('action', 'user', 'section', 'description', 'date'); $crud->display_as('action', 'Acción')->display_as('user', 'Usuario')->display_as('section', 'Sección')->display_as('description', 'Descripción')->display_as('date', 'Fecha'); $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 view_irrigation() { $crud = new Grocery_CRUD(); $crud->set_model('crud_model'); $crud->set_table('irr_history')->set_theme('datatables')->columns('irr_name', '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')->unset_edit()->unset_read()->unset_delete()->unset_add()->where('irr_history.place_id', $this->place_id); foreach ($this->sub_place as $sub) { $crud->or_where('irr_history.place_id', $sub->place_id); } $output = $crud->render(); $profile = array(); $profile['id'] = "irrigation"; $output->data = $profile; $this->load->view('profile', $output); }
public function barangay() { $crud = new Grocery_CRUD(); //$crud->set_model('crud_model'); $crud->set_table('place')->set_theme('datatables')->where('barangay IS NOT null')->set_subject('Barangays')->order_by('barangay')->columns('barangay', 'municipality', 'province')->fields('province', 'municipality', 'barangay')->unset_read()->unset_delete(); $crud->callback_field('province', array($this, '_callback_province')); $mun = $this->place_model->get_municipality(); foreach ($mun as $row) { $mun_array[$row->municipality] = $row->municipality; } $crud->field_type('municipality', 'dropdown', $mun_array); $crud->required_fields('province', 'municipality'); $output = $crud->render(); $this->display_output($output); }
public function historial() { $crud = new Grocery_CRUD(); $crud->set_table('incidencias'); $crud->columns('numero', 'idtipo', 'descripcion', 'estado', 'fecha_alta', 'idusuario', 'dias'); $crud->callback_column("dias", array($this->User_Model, 'dias_callback')); $crud->display_as('idtipo', 'Tipo'); $output = $crud->render(); $this->cargarVista($output); }
public function invoice_message_entry() { $crud = new Grocery_CRUD(); $crud->set_table('invoice_message')->columns('message')->fields('message')->unset_add()->unset_delete(); $output = $crud->render(); $this->load->view('admin/entry_view', $output); }
public function render() { parent::render(); return $this->post_render(); }