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 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 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 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');
$crud->unset_add()->unset_delete();
$crud->edit_fields('status');
$output = $crud->render();
$this->load->view('manager/security_view', $output);
}
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());
}
}
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('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('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());
}
}
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');
}
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());
}
}
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 render()
{
parent::render();
return $this->post_render();
}
public function getStateInfo()
{
$state_code = $this->getStateCode();
$segment_object = $this->get_state_info_from_url();
$first_parameter = $segment_object->first_parameter;
$second_parameter = $segment_object->second_parameter;
$third_parameter = $segment_object->third_parameter;
$state_info = (object) array();
switch ($state_code) {
case 101:
//ajax_extension
$state_info->target_field_name = $first_parameter;
$state_info->relation_field_on_source_table = $second_parameter;
$state_info->filter_value = $third_parameter;
break;
default:
$state_info = parent::getStateInfo();
}
return $state_info;
}
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 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 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);
}
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();
}
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());
}
}
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);
}
