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());
}
}
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');
}
