public function sales(Request $request)
 {
     $customers = customer::all();
     $loadMain = loadMain::where('status', 'ACTIVE')->where('vehicle_id', $request->input('id'))->first();
     $id = $loadMain->id;
     $products = DB::select(DB::raw("Select A.*,\n        (Select CONCAT((Select C.product_name FROM `products` C where C.id = X.pro_id),'-',X.sub_name)\n         as name  FROM `sub_products` X where X.id = A.sub_product_id)  as sub_name,\n         (Select B.price From `sub_products` B where B.id = A.sub_product_id ) as price\n\n        from `load_items` A where A.load_main_id   = '{$id}'"));
     return view('Sales.sales')->with('customers', $customers)->with('products', $products)->with('loadid', $id);
 }
 public function history_view(Request $request)
 {
     $id = $request->input('id');
     $loadMain = loadMain::find($id);
     $vehicle = vehicle::find($loadMain->vehicle_id);
     $loadItems = DB::select(DB::raw("Select A.*,\n        (SELECT CONCAT( (SELECT C.product_name FROM `products` C where C.id = B.pro_id), '-',B.sub_name) FROM `sub_products` B where B.id = A.sub_product_id) as pro_name\n        from `load_items` A where A.load_main_id ='{$id}'"));
     return view('LoadUnload.historyview')->with('vehicle', $vehicle)->with('loadMain', $loadMain)->with('loadItems', $loadItems);
 }