/**
* Display a listing of the resource.
*
* @return Response
*/
public function index(Request $request)
{
$login = Login::where('remember_token', '=', $request->header('token'))->where('login_from', '=', $request->ip())->join('members', 'members.id', '=', 'logins.member_id')->where('logins.status', '=', '1')->first();
$stockTypes = StockType::all();
$limitOrders = LimitOrder::all();
if ($login->mtype == 1) {
$stocks = Stock::orderBy('stockTypeId')->get();
if (count($stocks) > 0) {
foreach ($stocks as $stock) {
$clientStocks = ClientStock::where('stockId', '=', $stock->id)->where('status', '=', 0)->get();
$stock->request = $clientStocks;
//$stockProducts = AddProduct::sum('quantity')->where('stockId',$stock->id);
$stock->quantity = AddProduct::where('stockId', $stock->id)->sum('quantity');
$data[] = $stock;
}
} else {
$data = $stocks;
}
$clientStocks = ClientStock::all();
$clientAccounts = Account::all();
} else {
$stocks = Stock::orderBy('stockTypeId')->where('stockTypeId', 3)->get();
if (count($stocks) > 0) {
foreach ($stocks as $stock) {
$stock->quantity = AddProduct::where('stockId', $stock->id)->sum('quantity');
$data[] = $stock;
}
} else {
$data = $stocks;
}
$clientStocks = ClientStock::where('memberId', $login->member_id)->get();
$clientAccounts = Account::where('memberId', $login->member_id)->get();
}
$returnData = array('status' => 'ok', 'stocks' => $data, 'stockTypes' => $stockTypes, 'clientStocks' => $clientStocks, 'limitOrders' => $limitOrders, 'clientAccounts' => $clientAccounts, 'code' => 200);
return $returnData;
}
public function getIndex()
{
$stocks = Stock::orderBy('id', 'DESC')->paginate(15);
return view('Stocks.list', compact('stocks'));
}
public function jsonIndex()
{
return response()->json(Stock::orderBy('date')->select(['id', 'date', 'value'])->get());
}
