public function query(Request $request)
 {
     $validator = Validator::make($request->all(), ['currentPage' => 'required', 'items_per_page' => 'required']);
     if ($validator->fails()) {
         return Response::json(array('result' => false, 'data' => 'Some parameter not found.'));
     }
     $status = $request->input('status');
     $order = $request->input('order');
     if ($status != null || $order != null) {
         return $this->search($request);
     }
     $parpage = $request->input('items_per_page');
     $page = $request->input('currentPage');
     $skip = ($page - 1) * $parpage;
     $order = Orders::orderBy('updated_at', 'desc')->skip($skip)->take($parpage)->get();
     foreach ($order as $key => $value) {
         # code...
         $value->member = Member::where('id', $value->members_id)->first();
     }
     //dd($order);
     $count = Orders::count();
     return Response::json(array('result' => true, 'data' => $order, 'count' => $count, 'mode' => 'init', 'skip' => $skip));
 }
Beispiel #2
0
 public function generateOrderId()
 {
     $orders = Orders::orderBy('id', 'desc')->first();
     $newOrderId = $orders->order_id + 1;
     return $newOrderId;
 }