public function search_all(Request $request)
{
//Inputs
$course_name = Input::get('course_name');
$professor_name = Input::get('professor_name');
$academic_term = Input::get('academic_term');
$year = Input::get('year');
$builder = FileEntry::query();
if (Input::has('course_name')) {
$queryString = Input::get('course_name');
$builder->where('course_name', '=', "{$course_name}");
}
if (Input::has('professor_name')) {
$queryString = Input::get('professor_name');
$builder->where('professor_name', '=', "{$professor_name}");
}
if (Input::has('academic_term')) {
$queryString = Input::get('academic_term');
$builder->where('academic_term', '=', "{$academic_term}");
}
if (Input::has('year')) {
$queryString = Input::get('year');
$builder->where('year', '=', "{$year}");
}
$query = $builder->orderBy('created_at', 'DESC')->get();
$join_get_full_name = DB::table('file_entries')->join('users', 'users.email', '=', 'file_entries.submitting_user_email')->select('users.user_first_name', 'users.user_last_name')->take(1)->get();
return view('browse.search_results_all', ['query' => $query, 'builder' => $builder, 'course_name' => $course_name, 'professor_name' => $professor_name, 'academic_term' => $academic_term, 'year' => $year]);
}
