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