/** * Display a list of all of the products * * @param Request $request * @return Response */ public function index(Request $request) { $stores = Store::orderBy('name')->lists('name', 'id'); $sources = Source::orderBy('name')->lists("name", 'id'); $query = Product::orderBy('name', 'asc'); if ($request->store) { $query->where('store_id', $request->store); } if (isset($request->status) && $request->status != '') { if ($request->status == 3) { $query->where('quantity_sold', '>', 0); } else { $query->where('product_status', $request->status); } } if ($request->source) { $query->where('source_id', $request->source); } if ($request->from_date) { $query->where('updated_at', '>=', date('Y-m-d', strtotime($request->from_date))); } if ($request->to_date) { $query->where('updated_at', '<=', date('Y-m-d', strtotime('+1 day', strtotime($request->to_date)))); } $products = $query->get(); return view('products.index', ['products' => $products, 'statuses' => $this->product_statuses, 'stores' => $stores, 'sources' => $sources]); }
/** * Display a list of all of the purchases * * @param Request $request * @return Response */ public function index(Request $request) { $sources = Source::orderBy('name')->lists('name', 'id'); $query = Purchase::orderBy('purchase_date', 'desc'); if ($request->source) { $query->where('source_id', $request->source); } if ($request->from_date) { $query->where('purchase_date', '>=', date('Y-m-d', strtotime($request->from_date))); } if ($request->to_date) { $query->where('purchase_date', '<=', date('Y-m-d', strtotime($request->to_date))); } $purchases = $query->get(); return view('purchases.index', ['purchases' => $purchases, 'sources' => $sources]); }