public function route_main(Request $request)
 {
     $reps = Rep::all();
     $routes = DB::select(DB::raw("Select A.*, IFNULL((Select B.rep_name from reps B where B.id = A.id),0) as rep_name from routes A"));
     return view('Management.routes')->with('reps', $reps)->with('routes', $routes);
 }
 public function get_reps(Request $request)
 {
     $reps = Rep::all();
     return response()->json(['count' => count($reps), 'data' => $reps]);
 }