Javascript:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 |
d_table = $('#datatable').dataTable( { 'serverSide': true, "ajax": { url: base_url + 'admin/page/all/' + cat_id + '/?' + $.param(params), data: function(d){ d.key = value; } }, "order": sorting, "columnDefs": column_def, "drawCallback": function( settings ) { var api = this.api(); wrap.loaded(settings); } } ); |
Server:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 |
private function datatable_sorting(){ $columns = $this->config->item('adm_page_columns'); $order = $this->input->get('order'); $sort = array(); foreach($order as $key => $item){ $col_index = $item['column']; $dir = $item['dir']; $column = null; $column_key = null; $i = 0; foreach ($columns as $key => $item) { if($i == $col_index){ $column = $item; $column_key = $key; break; } $i++; } $sort[$column_key] = $dir; } return $sort; } public function all($cat_id=0){ $start = $this->input->get('start'); $length = $this->input->get('length'); $search = $this->input->get('search'); $keyword = $search['value']; $sort = $this->datatable_sorting(); //Get total record count $options = array( 'all' => 1, 'cat_id' => $cat_id ); $data = $this->pages_m->get_pages($this->lang_id, $options); if($data == false){ $total = 0; }else{ $total = count($data); } //Get total record count $options['start'] = $start; $options['limit'] = $length; $options['sort'] = $sort; $data = $this->pages_m->get_pages($this->lang_id, $options); $data = $this->pages_m->to_table($data); $this->datatable_response($total, $data); } public function datatable_response($total, $data = array()) { //Output; header('Cache-Control: no-cache, must-revalidate'); header('Content-type: application/json;charset=utf-8'); $out = array(); $out['draw'] = $this->input->get('draw'); $out['recordsTotal'] = $total; $out['recordsFiltered'] = $total; $out['data'] = $data; echo json_encode($out); exit(); } |