/**
* 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);
}
