function search() { $this->check_action_permission('search'); $search = $this->input->post('search'); $offset = $this->input->post('offset') ? $this->input->post('offset') : 0; $order_col = $this->input->post('order_col') ? $this->input->post('order_col') : 'name'; $order_dir = $this->input->post('order_dir') ? $this->input->post('order_dir') : 'asc'; $location_search_data = array('offset' => $offset, 'order_col' => $order_col, 'order_dir' => $order_dir, 'search' => $search); $this->session->set_userdata("location_search_data", $location_search_data); $per_page = $this->config->item('number_of_items_per_page') ? (int) $this->config->item('number_of_items_per_page') : 20; $search_data = $this->Location->search($search, $per_page, $this->input->post('offset') ? $this->input->post('offset') : 0, $this->input->post('order_col') ? $this->input->post('order_col') : 'name', $this->input->post('order_dir') ? $this->input->post('order_dir') : 'asc'); $config['base_url'] = site_url('locations/search'); $config['total_rows'] = $this->Location->search_count_all($search); $config['per_page'] = $per_page; $this->pagination->initialize($config); $data['pagination'] = $this->pagination->create_links(); $data['manage_table'] = get_locations_manage_table_data_rows($search_data, $this); echo json_encode(array('manage_table' => $data['manage_table'], 'pagination' => $data['pagination'])); }
public function search() { $search = $this->input->post('search'); $data_rows = get_locations_manage_table_data_rows($this->Location->search($search), $this); echo $data_rows; }
function get_locations_manage_table($locations, $controller) { $CI =& get_instance(); $table = '<table class="table tablesorter table-bordered table-striped table-hover" id="sortable_table">'; $headers = array('<input type="checkbox" id="select_all" />', $CI->lang->line('locations_location_id'), $CI->lang->line('locations_name'), $CI->lang->line('locations_address'), $CI->lang->line('locations_phone'), $CI->lang->line('locations_email'), ' '); $table .= '<thead><tr>'; $count = 0; foreach ($headers as $header) { $count++; if ($count == 1) { $table .= "<th class='leftmost'>{$header}</th>"; } elseif ($count == count($headers)) { $table .= "<th class='rightmost'>{$header}</th>"; } else { $table .= "<th>{$header}</th>"; } } $table .= '</tr></thead><tbody>'; $table .= get_locations_manage_table_data_rows($locations, $controller); $table .= '</tbody></table>'; return $table; }