public function getJobs()
 {
     $displayTitle = "Jobs";
     //.$sectorId;
     $sectors = DB::select("EXEC spSectors_Select");
     dd($sectors);
     $job_types = JobAlerts::getJobTypes();
     $locations = DB::select("EXEC spLocations_Select");
     $numOfJobs = 5;
     $pageNumber = Input::get('page') ?: 1;
     $jobs = [];
     $paginator = Paginator::make($jobs, count(DB::select("EXEC spJobSearch_Select @JobTitle = '', @SectorIDs = '{$sectors_get}', @LocationIDs = '{$location_get}', @EmploymentTypeIDs = '{$type_get}'")), $numOfJobs);
     $jobs = DB::select("EXEC spJobSearchPaged_Select @JobTitle = ?, @SectorIDs = '{$sectors}', @LocationIDs = '{$location_get}', @EmploymentTypeIDs = '{$type_get}', @RowsPerPage = {$numOfJobs}, @PageNumber = {$pageNumber}", explode('+', $keywords));
     $recommended = self::getRecommendedJobs();
     return View::make('jobs')->with('jobs', $jobs)->with('reccommended', $reccommended)->with('sectors', $sectors)->with('job_types', $job_types)->with('locations', $locations)->with('displayTitle', $displayTitle)->with('paginator', $paginator);
 }
 public function fire()
 {
     $sectors = JobAlerts::getJobSectors();
     $jobTypes = JobAlerts::getJobTypes();
     $locations = JobAlerts::getJobLocations();
     // loop through all candidates
     Candidates::get()->each(function ($candidate) use($sectors, $jobTypes, $locations) {
         $candidate->jobAlerts->each(function ($jobAlert) use($sectors, $jobTypes, $locations) {
             // select all jobs, query derived from controller
             $jobs = DB::select("\n\t\t\t\t\tEXEC spJobSearch_Select \n\t\t\t\t\t@JobTitle = '', \n\t\t\t\t\t@LocationIDs = '{$jobAlert->location_id}', \n\t\t\t\t\t@SectorIDs = '{$jobAlert->sector_id}', \n\t\t\t\t\t@EmploymentTypeIDs = '{$jobAlert->job_type}'");
             // dispatch mail
             Mail::send('candidate.jobalerts', ['sectors' => $sectors, 'job_types' => $jobTypes, 'locations' => $locations, 'alert' => $jobAlert, 'jobs' => $jobs], function ($message) use($candidate) {
                 $message->to($candidate->email, $candidate->name)->subject('Job Alerts from KDC');
             });
         });
     });
 }
 public function jobAlerts()
 {
     if (!is_null(Session::get('candidate'))) {
         $candidate = Candidate::find(Session::get('candidate')->id);
         $sectors = JobAlerts::getJobSectors();
         $job_types = JobAlerts::getJobTypes();
         $locations = JobAlerts::getJobLocations();
         // Check if there is an alert already
         $jobAlert = JobAlerts::where('candidate_id', $candidate->id)->first();
         if (!is_null($jobAlert)) {
             $alert = $jobAlert;
             // Now we have an alert let check for relevant jobs
             $jobs = DB::select("EXEC spJobSearch_Select @JobTitle = '', @LocationIDs = '{$alert->location_id}', @SectorIDs = '{$alert->sector_id}', @EmploymentTypeIDs = '{$alert->job_type}'");
         } else {
             $alert = [];
             $jobs = [];
         }
         $viewSectors = $viewlocations = [];
         foreach ($sectors as $sector) {
             $viewSectors[$sector->SectorId] = $sector->SectorName;
         }
         foreach ($locations as $location) {
             $viewlocations[$location->LocationId] = $location->Description;
         }
         return View::make('candidate.jobalerts', ['candidate' => $candidate, 'sectors' => $viewSectors, 'job_types' => $job_types, 'locations' => $viewlocations, 'alert' => $alert, 'jobs' => $jobs]);
     } else {
         return Redirect::to('become-a-candidate')->with('info', 'Please login / register to view this page');
     }
 }