*/ Route::get('/', ['middleware' => 'auth', function () { $estimates = DB::table('estimates')->join('customers', 'customers.id', '=', 'estimates.customer_id')->selectRaw('estimates.*, estimates.id as est_id, customers.*')->orderBy('estimates.id', 'desc')->take(5)->get(); $jobs = DB::table('jobs')->join('estimates', 'estimates.id', '=', 'jobs.estimate_id')->join('customers', 'customers.id', '=', 'estimates.customer_id')->selectRaw('jobs.*, jobs.id as job_id, customers.*')->orderBy('jobs.id', 'desc')->take(5)->get(); return view('dashboard', compact('estimates', 'jobs')); }]); Route::get('/home', ['middleware' => 'auth', function () { return view('dashboard'); }]); /* * * Estimate Create Ajax customer vehicle data call */ Route::get('/ajax-vehicle', function () { $customer_id = Input::get('cust_id'); $vehicles = App\Vehicle::where('customer_id', '=', $customer_id)->get(); return Response::json($vehicles); }); /* * * Estimate Create Ajax item data call */ Route::get('/ajax-item', function () { $item_id = Input::get('item_id'); $item = App\Item::where('id', '=', $item_id)->get(); return Response::json($item); }); /* * * Authentication Route */