public function index(Request $request)
{
// 获取排序条件
$orderColumn = $request->get('sort_up', $request->get('sort_down', 'created_at'));
$direction = $request->get('sort_up') ? 'asc' : 'desc';
$stores = Store::orderBy($orderColumn, $direction)->paginate(999);
return view('mobile.stores', compact('stores', 'query'));
}
/**
* Edit snapshot
*
* @param Request $request
* @return Response
*/
public function edit(Request $request, Snapshot $snapshot)
{
$stores = Store::orderBy('name')->lists('name', 'id');
return view('snapshots.input', ['stores' => $stores, 'snapshot' => $snapshot]);
}
/**
* 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 listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
$stores = Store::orderBy('store')->get();
return view('store.index', compact('stores'));
}
/**
* Display a list of all of the expenses
*
* @param Request $request
* @return Response
*/
public function index(Request $request)
{
$stores = Store::orderBy('name')->lists('name', 'id');
$query = Expense::orderBy('purchase_date', 'desc');
if ($request->store) {
$query->where('store_id', $request->store);
}
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)));
}
$expenses = $query->get();
return view('expenses.index', ['expenses' => $expenses, 'stores' => $stores]);
}
/**
* Display a list of all of the stores
*
* @param Request $request
* @return Response
*/
public function index(Request $request)
{
$stores = Store::orderBy('name', 'asc')->get();
return view('stores.index', ['stores' => $stores]);
}