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