public function manage($model, $service, $request, $params)
{
$data = new stdClass();
if (isset($request->req['rm_field_to_search']) && isset($request->req['rm_value_to_serach']) && (int) $request->req['rm_field_to_search']) {
$field_id = $request->req['rm_field_to_search'];
$field_value = $request->req['rm_value_to_serach'];
} else {
$field_id = null;
$field_value = null;
}
if (isset($request->req['rm_form_id'])) {
$form_id = $request->req['rm_form_id'];
} else {
$form_id = $service->get('FORMS', 1, array('%d'), 'var', 0, 15, $column = 'form_id', null, true);
}
if ((int) $field_id) {
$data->searched = true;
} else {
$data->searched = false;
}
$data->to_search = new stdClass();
$data->to_search->id = $field_id;
$data->to_search->value = $field_value;
$data->form_id = $form_id;
$data->forms = RM_Utilities::get_forms_dropdown($service);
$data->fields = $service->get_all_form_fields($form_id);
//$data->submissions = $service->get('SUBMISSIONS', array('form_id' => $form_id), array('%d'), 'results', 0, 100, '*', $sort_by = null, $descending = true);
$data->interval = isset($request->req['rm_interval']) ? $request->req['rm_interval'] : 'all';
$data->total_entries = count(RM_DBManager::get_results_for_last($data->interval, $form_id, $field_id, $field_value));
//echo "<pre>",var_dump($data->x), die;
$data->rm_slug = $request->req['page'];
//Pagination
$entries_per_page = 10;
$req_page = isset($request->req['rm_reqpage']) && $request->req['rm_reqpage'] > 0 ? $request->req['rm_reqpage'] : 1;
$offset = ($req_page - 1) * $entries_per_page;
$total_entries = $data->total_entries;
$data->total_pages = (int) ($total_entries / $entries_per_page) + ($total_entries % $entries_per_page == 0 ? 0 : 1);
$data->curr_page = $req_page;
$data->submissions = RM_DBManager::get_results_for_last($data->interval, $form_id, $field_id, $field_value, $offset, $entries_per_page, 'submission_id', true);
$view = $this->mv_handler->setView('submissions_manager');
$view->render($data);
}
