/**
* Display a listing of the resource.
*
* @return Response
*/
public function index()
{
$jobs = Job::with('creator')->orderBy('required_date')->paginate(4);
if (Input::has('search')) {
$search = Input::get('search');
$jobs = Job::where('description', 'LIKE', '%' . $search . '%')->paginate(50);
}
$data = array('jobs' => $jobs);
return View::make('temp_jobs.index')->with($data);
}
public function search()
{
if (Auth::check()) {
//do not show jobs that have already been applied to
//to show active jobs that helper has been selected for
$activeJobIds = DB::table('jobs')->join('helpers_jobs_mapping', function ($join) {
$join->on('jobs.id', '=', 'helpers_jobs_mapping.job_id')->where('helpers_jobs_mapping.is_accepted', '=', 1);
})->lists('id');
$activeJobs = [];
if (!empty($activeJobIds)) {
$activeJobs = Job::whereIn('id', $activeJobIds)->get();
}
$appliedQuery = Auth::user()->appliedJobs();
if (!empty($activeJobIds)) {
$appliedQuery->whereNotIn('id', $activeJobIds);
}
$appliedJobs = $appliedQuery->get();
//$jobsIds will hold all the ids in the jobs table
$appliedJobIds = array();
//search all jobs for current job id
foreach (Auth::user()->appliedJobs as $job) {
$appliedJobIds[] = $job->id;
}
$jobQuery = Job::with('creator');
if (count($activeJobIds) > 0) {
$jobQuery->whereNotIn('id', $activeJobIds);
}
if (count($appliedJobIds) > 0) {
$jobQuery->whereNotIn('id', $appliedJobIds);
}
//show all jobs if user has not applied to any
$jobs = $jobQuery->orderBy('required_date')->paginate(5);
$data = array('jobs' => $jobs, 'activeJobs' => $activeJobs, 'appliedJobs' => $appliedJobs);
} else {
$jobs = Job::with('creator')->orderBy('required_date')->paginate(5);
}
if (Input::has('filter')) {
$filter = Input::get('filter');
$jobs = Job::where('category', $filter)->paginate(50);
}
if (Input::has('search')) {
$search = Input::get('search');
$jobs = Job::where('description', 'LIKE', '%' . $search . '%')->paginate(5);
}
$data = array('jobs' => $jobs);
return View::make('pages.search')->with($data);
}
/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return Response
*/
public function edit($id)
{
$review = Job::with('review')->find($id);
return View::make('temp_reviews.create-edit')->with('review', $review);
}
public function dashboard_helper($id)
{
//to show active jobs that helper has been selected for
$activeJobIds = DB::table('jobs')->join('helpers_jobs_mapping', function ($join) {
$join->on('jobs.id', '=', 'helpers_jobs_mapping.job_id')->where('helpers_jobs_mapping.is_accepted', '=', 1);
})->lists('id');
$activeJobs = [];
if (!empty($activeJobIds)) {
$activeJobs = Job::whereIn('id', $activeJobIds)->get();
}
$appliedQuery = Auth::user()->appliedJobs();
if (!empty($activeJobIds)) {
$appliedQuery->whereNotIn('id', $activeJobIds);
}
$appliedJobs = $appliedQuery->get();
//$jobsIds will hold all the ids in the jobs table
$appliedJobIds = array();
//search all jobs for current job id
foreach (Auth::user()->appliedJobs as $job) {
$appliedJobIds[] = $job->id;
}
//do not show jobs that have already been applied to
$jobQuery = Job::with('creator');
if (count($activeJobIds) > 0) {
$jobQuery->whereNotIn('id', $activeJobIds);
}
if (count($appliedJobIds) > 0) {
$jobQuery->whereNotIn('id', $appliedJobIds);
}
//show all jobs if user has not applied to any
$jobs = $jobQuery->orderBy('created_at', 'desc')->paginate(4);
$data = array('jobs' => $jobs, 'activeJobs' => $activeJobs, 'appliedJobs' => $appliedJobs);
return View::make('users.show_account')->with($data);
}
