public static function getLastOrderDateForStockByBranch($stock_id, $branch_id) { $stock = Stock::findOrFail($stock_id); if ($stock->stockOrders()->where('branch_id', $branch_id)->count() > 0) { return $stock->stockOrders()->where('branch_id', $branch_id)->orderBy('created_at', 'desc')->first()->created_at->format('d/m/Y'); } else { return 'N/A'; } }
public function edit($id) { $branch = array(Auth::user()->branch); if (Auth::user()->role === 'superadmin') { $stock = Stock::findOrFail($id); $product_detail = \DB::select('SELECT s.id, s.cid, s.pid, c.`c_name`, p.`p_name`, p.`buying_price`, p.`selling_price`, s.`quantity`, s.`branch` FROM `stock` s, `product` p, `product_category` c WHERE s.`pid`=p.`pid` AND s.`cid`=c.`cid` AND s.id=' . "'" . $id . "'" . ''); $branch = \DB::table('branch')->whereNotIn('branch_name', $branch)->lists('branch_name', 'branch_name'); return view('stock_transfer.edit', ['stock' => $stock, 'product_detail' => $product_detail, 'branch' => $branch]); } else { return redirect('auth/login'); } }
public function doOrderStockItem(Request $request) { $stock_item = Stock::findOrFail($request->input('item_id')); $password = $request->input('password'); $mode = $request->input('mode'); if (!Hash::check($password, Auth::user()->password) && $mode == 'save') { return redirect()->back()->with('stock-order-add-password-error', true); } else { $stock_item->addOrder(['mode' => $mode, 'amount' => (int) $request->input('amount'), 'branch_id' => $request->input('branch_id'), 'urgent' => $request->input('urgent'), 'required_date' => $request->input('required_date'), 'send_reminder' => $request->input('send_reminder'), 'reminder_days' => $request->input('reminder_days'), 'comments' => $request->input('comments')]); if ($mode == 'save') { return redirect()->back()->with('stock-order-added', true); } else { return redirect()->back()->with('stock-order-saved-for-later', true); } } }
public function show($id) { $stock = Stock::findOrFail($id); return view('stock.show', compact('stock')); }
public function destroy($id) { $data = Stock::findOrFail($id); $data->delete(); return redirect('stock'); }