/** * Display the specified resource. * * @param int $id * @return \Illuminate\Http\Response */ public function show(Request $request) { // get total rows $totalRecords = Package::where('status', '1')->get()->count(); $main_data = array(); if ($totalRecords > 0) { // set unique token into session $unique = $this->getUniqueNo(); Session::set('secure_url', $unique); $main_data['draw'] = 1; $main_data['recordsTotal'] = $totalRecords; $main_data['recordsFiltered'] = $totalRecords; // condition $orderby = 'id'; $dir = 'asc'; // set starting form to lenght record $skip = 0; $take = 10; // query object $query = Package::query(); $query->select('id', 'name', 'price', 'created_at')->where('status', '1'); // get request from database if ($request->has('search')) { $req = $request->only('search', 'order', 'start', 'length', 'draw'); // pre defined filters list $filters = array('name', 'price', 'created_at'); // serarch records if (!empty($req['search']['value'])) { $query->where('name', 'like', '%' . $req['search']['value'] . '%'); } // record get according $orderby = $filters[$req['order'][0]['column']]; $dir = $req['order'][0]['dir']; // serarch records from to len $skip = $req['start']; $take = $req['length']; $main_data['draw'] = $req['draw']; } // get records $records = $query->orderby($orderby, $orderby)->skip($skip)->take($take)->get(); foreach ($records as $key => $value) { $edit = '<a href="' . Config::get("app.url") . 'admin/package/edit/' . $value->id . 'mlm' . $unique . '"><i class="glyphicon glyphicon-edit"></i></a>'; $delete = '<a href="javascript:;" data-id="' . $value->id . $unique . '" data-token="mlm' . $unique . 'ppa" class="package-delete"><i class="glyphicon glyphicon-remove"></i></a>'; $main_data['data'][] = array($value->name, $value->price, date('d M Y H:i:s', strtotime($value->created_at)), $edit, $delete); } } // return response return Response::json($main_data); }