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