public function vendor_delete(Request $request)
{
$vendor = vendor::find($request->input('id'));
$vendor->delete();
}
public function grn()
{
$v = vendor::all();
$products = DB::select(DB::raw("Select A.*, \n (Select B.product_name from products B where B.id = A.pro_id) as product_name\n From sub_products A"));
return view('Stocks.grn')->with('products', $products)->with('vendors', $v);
}
