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');
}
