public function index($service_id = 1)
{
$this->template->content = new View('admin/reporters');
$this->template->content->title = Kohana::lang('ui_admin.reporters');
$filter = "1=1";
$search_type = "";
$keyword = "";
// Get Search Type (If Any)
if ($service_id) {
$search_type = $service_id;
$filter .= " AND (service_id='" . $service_id . "')";
} else {
$search_type = "0";
}
// Get Search Keywords (If Any)
if (isset($_GET['k']) and !empty($_GET['k'])) {
$keyword = $_GET['k'];
$filter .= " AND (service_account LIKE'%" . $_GET['k'] . "%')";
}
// setup and initialize form field names
$form = array('reporter_id' => '', 'level_id' => '', 'service_name' => '', 'service_account' => '', 'location_id' => '', 'location_name' => '', 'latitude' => '', 'longitude' => '');
// copy the form as errors, so the errors will be stored with keys corresponding to the form field names
$errors = $form;
$form_error = FALSE;
$form_saved = FALSE;
$form_action = "";
// check, has the form been submitted, if so, setup validation
if ($_POST) {
// Instantiate Validation, use $post, so we don't overwrite $_POST fields with our own things
$post = Validation::factory($_POST);
// Add some filters
$post->pre_filter('trim', TRUE);
// Add some rules, the input field, followed by a list of checks, carried out in order
$post->add_rules('action', 'required', 'alpha', 'length[1,1]');
$post->add_rules('reporter_id.*', 'required', 'numeric');
if ($post->action == 'l') {
$post->add_rules('level_id', 'required', 'numeric');
} elseif ($post->action == 'a') {
$post->add_rules('level_id', 'required', 'numeric');
// If any location data is provided, require all location parameters
if ($post->latitude or $post->longitude or $post->location_name) {
$post->add_rules('latitude', 'required', 'between[-90,90]');
// Validate for maximum and minimum latitude values
$post->add_rules('longitude', 'required', 'between[-180,180]');
// Validate for maximum and minimum longitude values
$post->add_rules('location_name', 'required', 'length[3,200]');
}
}
// Test to see if things passed the rule checks
if ($post->validate()) {
if ($post->action == 'd') {
foreach ($post->reporter_id as $item) {
// Delete Reporters Messages
ORM::factory('message')->where('reporter_id', $item)->delete_all();
// Delete Reporter
$reporter = ORM::factory('reporter')->find($item);
$reporter->delete($item);
}
$form_saved = TRUE;
$form_action = strtoupper(Kohana::lang('ui_admin.deleted'));
} elseif ($post->action == 'l') {
foreach ($post->reporter_id as $item) {
// Update Reporter Level
$reporter = ORM::factory('reporter')->find($item);
if ($reporter->loaded) {
$reporter->level_id = $post->level_id;
$reporter->save();
}
}
$form_saved = TRUE;
$form_action = strtoupper(Kohana::lang('ui_admin.modified'));
} else {
if ($post->action == 'a') {
foreach ($post->reporter_id as $item) {
$reporter = ORM::factory('reporter')->find($item);
// SAVE Reporter only if loaded
if ($reporter->loaded) {
$reporter->level_id = $post->level_id;
// SAVE Location if available
if ($post->latitude and $post->longitude) {
$location = new Location_Model($post->location_id);
$location->location_name = $post->location_name;
$location->latitude = $post->latitude;
$location->longitude = $post->longitude;
$location->location_date = date("Y-m-d H:i:s", time());
$location->save();
$reporter->location_id = $location->id;
}
$reporter->save();
$form_saved = TRUE;
$form_action = strtoupper(Kohana::lang('ui_admin.modified'));
}
}
}
}
} else {
// repopulate the form fields
$form = arr::overwrite($form, $post->as_array());
// populate the error fields, if any
$errors = arr::overwrite($errors, $post->errors('reporters'));
$form_error = TRUE;
}
}
// Pagination
$pagination = new Pagination(array('query_string' => 'page', 'items_per_page' => (int) Kohana::config('settings.items_per_page_admin'), 'total_items' => ORM::factory('reporter')->where($filter)->count_all()));
$reporters = ORM::factory('reporter')->where($filter)->orderby('service_account', 'asc')->find_all((int) Kohana::config('settings.items_per_page_admin'), $pagination->sql_offset);
$this->template->content->form = $form;
$this->template->content->errors = $errors;
$this->template->content->form_error = $form_error;
$this->template->content->form_saved = $form_saved;
$this->template->content->form_action = $form_action;
$this->template->content->pagination = $pagination;
$this->template->content->total_items = $pagination->total_items;
$this->template->content->reporters = $reporters;
$this->template->content->service_id = $service_id;
$this->template->content->search_type = $search_type;
$search_type_array = Service_Model::get_array();
$search_type_array[0] = "All";
asort($search_type_array);
$this->template->content->search_type_array = $search_type_array;
$this->template->content->keyword = $keyword;
$levels = ORM::factory('level')->orderby('level_weight')->find_all();
$this->template->content->levels = $levels;
// Level and Service Arrays
$this->template->content->level_array = Level_Model::get_array();
$this->template->content->service_array = Service_Model::get_array();
// Javascript Header
$this->template->map_enabled = TRUE;
$this->template->js = new View('admin/reporters_js');
$this->template->js->default_map = Kohana::config('settings.default_map');
$this->template->js->default_zoom = Kohana::config('settings.default_zoom');
$this->template->js->latitude = Kohana::config('settings.default_lat');
$this->template->js->longitude = Kohana::config('settings.default_lon');
$this->template->js->form_error = $form_error;
}
function reporters()
{
$this->template->content = new View('admin/reporters');
$this->template->content->title = 'Reporters';
// setup and initialize form field names
$form = array('reporter_id' => '', 'service_id' => '', 'service_userid' => '', 'service_account' => '', 'reporter_level' => '', 'reporter_first' => '', 'reporter_last' => '', 'reporter_email' => '', 'reporter_phone' => '', 'reporter_ip' => '', 'reporter_date' => '');
// copy the form as errors, so the errors will be stored with keys corresponding to the form field names
$errors = $form;
$form_error = FALSE;
$form_saved = FALSE;
$form_action = "";
// check, has the form been submitted, if so, setup validation
if ($_POST) {
// Instantiate Validation, use $post, so we don't overwrite $_POST fields with our own things
$post = Validation::factory($_POST);
// Add some filters
$post->pre_filter('trim', TRUE);
if ($post->action == 'a') {
// Add some rules, the input field, followed by a list of checks, carried out in order
$post->add_rules('service_id', 'required');
// we also require either service_userid or service_account, not necessarily both
}
// Test to see if things passed the rule checks
if ($post->validate()) {
$reporter_id = $post->reporter_id;
$reporter = new Reporter_Model($reporter_id);
if ($post->action == 'd') {
$level->delete($level_id);
$form_saved = TRUE;
$form_action = "DELETED";
} else {
if ($post->action == 'a') {
// SAVE Reporter
$reporter->service_id = $post->service_id;
/*$reporter->service_userid = $post->service_userid;
$reporter->service_account = $post->service_account;*/
$reporter->reporter_level = $post->reporter_level;
/*$reporter->reporter_first = $post->reporter_first;
$reporter->reporter_last = $post->reporter_last;
$reporter->reporter_email = $post->reporter_email;
$reporter->reporter_phone = $post->reporter_phone;
$reporter->reporter_ip = $post->reporter_ip;
$reporter->reporter_date = $post->reporter_date;*/
$reporter->save();
$form_saved = TRUE;
$form_action = "ADDED/EDITED";
}
}
} else {
// repopulate the form fields
$form = arr::overwrite($form, $post->as_array());
// populate the error fields, if any
$errors = arr::overwrite($errors, $post->errors('level'));
$form_error = TRUE;
}
}
// Pagination
$pagination = new Pagination(array('query_string' => 'page', 'items_per_page' => (int) Kohana::config('settings.items_per_page_admin'), 'total_items' => ORM::factory('reporter')->count_all()));
$reporters = ORM::factory('reporter')->orderby('reporter_first', 'asc')->find_all((int) Kohana::config('settings.items_per_page_admin'), $pagination->sql_offset);
$this->template->content->form = $form;
$this->template->content->errors = $errors;
$this->template->content->form_error = $form_error;
$this->template->content->form_saved = $form_saved;
$this->template->content->form_action = $form_action;
$this->template->content->pagination = $pagination;
$this->template->content->total_items = $pagination->total_items;
$this->template->content->reporters = $reporters;
// Level and Service Arrays
$this->template->content->level_array = Level_Model::get_array();
$this->template->content->service_array = Service_Model::get_array();
}
