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