Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public function getUser(Request $request)
- {
- $columns = array(
- 0 => 'auto_num',
- 1 => 'add_time',
- 2 => 'id'
- );
- $totalData = DataTes::count();
- $limit = $request->input('length');
- $start = $request->input('start');
- $order = $columns[$request->input('order.0.column')];
- $dir = $request->input('order.0.dir');
- if(empty($request->input('search.value'))){
- $posts = DataTes::offset($start)
- ->limit($limit)
- ->orderBy($order,$dir)
- ->get();
- $totalFiltered = DataTes::count();
- }else{
- $search = $request->input('search.value');
- $posts = DataTes::where('auto_num', 'like', "%{$search}%")
- ->orWhere('add_time','like',"%{$search}%")
- ->orWhere('id','like',"%{$search}%")
- ->offset($start)
- ->limit($limit)
- ->orderBy($order, $dir)
- ->get();
- $totalFiltered = DataTes::where('auto_num', 'like', "%{$search}%")
- ->orWhere('add_time','like',"%{$search}%")
- ->orWhere('id','like',"%{$search}%")
- ->count();
- }
- $data = array();
- if($posts){
- foreach($posts as $r){
- $nestedData['auto_num'] = $r->auto_num;
- $nestedData['add_time'] = $r->add_time;
- $nestedData['id'] = $r->id;
- $data[] = $nestedData;
- }
- }
- $json_data = array(
- "draw" => intval($request->input('draw')),
- "recordsTotal" => intval($totalData),
- "recordsFiltered" => intval($totalFiltered),
- "data" => $data
- );
- echo json_encode($json_data);
- }
- $('#example1').DataTable( {
- "ordering": true,
- 'autoWidth': true,
- "processing": true,
- "serverSide": true,
- "ajax": {
- "url":"<?= route('dataProcessing') ?>",
- "dataType":"json",
- "type":"POST",
- "data":{"_token":"<?= csrf_token() ?>"}
- },
- "columns":[
- {"data": "auto_num"},
- {"data": "add_time"},
- {"data": "id"}
- ]
- } );
Add Comment
Please, Sign In to add comment