public function getDmaJobs($dma_code) { $featuredJobs = \App\Job::where('dma_code', $dma_code)->where('featured_flag', 1)->select('id', 'title', 'city', 'state', 'dma_code')->orderBy('updated_at', 'desc')->get(); $jobs = \App\Job::where('dma_code', $dma_code)->where('featured_flag', 0)->select('id', 'title', 'city', 'state', 'dma_code')->orderBy('updated_at', 'desc')->take(10)->get(); $response = ['set' => $jobs, 'list' => $featuredJobs]; return response()->json($response); }
public function getView($id) { $company = Company::where("id", $id)->with(['customers' => function ($q) { $q->whereNull("user_id"); }])->first(); return view("company_profile.company_profile", ["company" => $company, "estimators" => User::where("company_id", $id)->count(), "jobs" => Job::where("company_id", $id)->count(), "customers" => $company->customers->count(), "estimatorz" => User::where("company_id", $id)->get()]); }
/** * Search jobs methods * @param \Illuminate\Http\Request $request * * @return $this */ public function search(Request $request) { $keywords = $request->keywords; $searchJobs = Job::where('title', 'LIKE', '%' . $keywords . '%')->orWhere('type', 'LIKE', '%' . $keywords . '%')->get(); $data = ['searchJobs' => $searchJobs]; return view('search')->with($data); }
public function getEntry(Request $request, $job_number) { $singleObj = Job::where('job_number', $job_number)->first(); $headTitle = '案件に応募'; return view('jobs.entry', ['singleObj' => $singleObj, 'headTitle' => $headTitle]); //echo $_SERVER['DOCUMENT_ROOT']; }
/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index() { $events = Event::where('user_id', $user_id)->get(); $jobs = Job::where('user_id', $user_id)->get(); // return view('members.dashboardpage', ['user' => $user, 'events' => $events, 'jobs' => $jobs]); return view('public.frontpage', ['user' => $user, 'events' => $events, 'jobs' => $jobs]); }
/** * Display a listing of the resource. * * @return Response */ public function index($company_id, Request $request) { // get current company $company = Company::find($company_id); // Sort by if ($request->has('sortby')) { $sort_value = $request->get('sortby'); switch ($sort_value) { case 'job_title': $jobs = Job::where('company_id', '=', $company_id)->where('status_id', '=', 1)->orderBy('job_title', 'desc')->paginate(10); break; case 'exp_date': $jobs = Job::where('company_id', '=', $company_id)->where('status_id', '=', 1)->orderBy('exp_date', 'desc')->paginate(10); break; case 'view_stats': $jobs = Job::where('company_id', '=', $company_id)->where('status_id', '=', 1)->orderBy('exp_date', 'desc')->paginate(10); break; case 'applicants': $jobs = Job::where('company_id', '=', $company_id)->where('status_id', '=', 1)->orderBy(count($company->job_applicants), 'desc')->paginate(10); break; default: $jobs = Job::where('company_id', '=', $company_id)->where('status_id', '=', 1)->orderBy('id', 'desc')->paginate(10); break; } } else { $jobs = Job::where('company_id', '=', $company_id)->where('status_id', '=', 1)->paginate(10); } $baseurl = url(); $jobs->setPath($baseurl . '/companies/' . $company_id . '/jobs'); return view('jobs.index', compact('jobs', 'company')); }
public function edit($id) { $message = Session::get('message'); $quote_request = QuoteRequest::find($id); $job = Job::where('quote_requests_id', $id)->first(); $qris = $quote_request->qris; return view('jobs.edit', compact('quote_request', 'qris', 'job', 'message')); }
/** * Permet de mettre à jour * * @return Response */ public function update(Request $request) { $id = $request->job_id; $resume = $request->resume; $content = $request->content; $fiches = Job::where('id', $id)->update(['resume' => $resume, 'content' => $content]); return redirect(route('admin.metiers.index', compact('fiches'))); }
/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function getEstimations() { if (!Auth::check()) { return Redirect::to("/"); } $id = Auth::user()->id; $customer = Customer::where("user_id", $id)->with("user")->with("jobs")->first(); $total = Job::where("customer_id", $id)->count(); return view("customer.estimations", ["customer" => $customer, "total" => $total]); }
/** * Define the application's command schedule. * * @param \Illuminate\Console\Scheduling\Schedule $schedule * @return void */ protected function schedule(Schedule $schedule) { $schedule->command('export-monster-files test')->cron('00 * * * *')->name('process-feed')->withoutOverlapping(); $schedule->call(function () { $files = \App\FileDeleteQueue::all(); foreach ($files as $file) { $local_file = config('monster.tmp_storage_path') . $file->file_name; if (file_exists($local_file)) { $tmp_is_deleted = unlink(realpath($local_file)); if (!$tmp_is_deleted) { \App\ExportLog::create(['process' => 'deleting local file', 'filename' => $ftp_file, 'message' => 'cannot be deleted from /tmp/ folder']); } else { $file->delete(); } } } })->name('delete-local-files')->twiceDaily(12, 23); $schedule->call(function () { // deleting expired jobs $today = date('Y-m-d', time()); $jobs = \App\Job::where('end_date', '<', $today)->take(1000)->get(); if (!$jobs->isEmpty()) { $i = 0; foreach ($jobs as $j) { $j->delete(); $i++; } \App\ExportLog::create(['process' => 'deleting expired jobs', 'message' => 'Deleted ' . $i . ' jobs']); } })->cron('5 * * * *')->name('delete-expired-jobs-hourly')->withoutOverlapping(); $schedule->call(function () { $today = date('Y-m-d', time() - 3 * 86400); \App\ExportRecordFailure::where('created_at', '<', $today)->take(3000)->delete(); })->cron('5 * * * *')->name('delete-export-record-failures')->withoutOverlapping(); $schedule->call(function () { $queue = \App\CacheQueue::where(['in_process' => 0])->take(10); $records = $queue->get(); if (!$records->isEmpty()) { $queue->update(['in_process' => 1]); foreach ($records as $record) { $run = call_user_func($record->model . '::' . $record->method, $record->args); if ($run) { $record->delete(); } else { $record->in_process = null; $record->save(); } } } })->everyMinute()->name('process-cache-queue-records'); }
private function replyToJobSender($category, $recipient) { $jobs = $this->job->where('deadline', '>=', Carbon::today())->where('category', 'like', '%' . $category . '%')->orderBy('id', 'desc')->take(5)->get(); if (count($jobs) > 0) { foreach ($jobs as $job) { $message = "Job is {$job->jobType}, located at {$job->location}, contact {$job->contact} on {$job->contactName}, positions available {$job->positions}"; $this->send($recipient, $message); Log::debug("msg sent: " . $message); } } else { $message = "Sorry no jobs matching your category, try another category"; $this->send($recipient, $message); } }
/** * Display the specified resource. * * @param int $id * @return \Illuminate\Http\Response */ public function show(Request $request) { $user = $request->user(); $user_id = $user->id; $events = Event::where('user_id', $user_id)->get(); $jobs = Job::where('user_id', $user_id)->get(); // return var_dump($events); // $data = ''; //return(var_dump($user)); //return $user->name; //return view('members.dashboardpage', ['user' => User::findOrFail($id)]); return view('members.dashboardpage', ['user' => $user, 'events' => $events, 'jobs' => $jobs]); // ->withPosts($posts) // ; }
/** * Store a newly created resource in storage. * * @return Response */ public function store(Request $request, $id) { //return ($request->all()); $job = Job::where('job_id', $id)->first(); $applicant = new Applicant($request->all()); $applicant->job_id = $id; //return $applicant; // $a =$job->applicants()->create($request->all()); // $applicant = new $job->applicants($request->all()); $filename = Str::lower(pathinfo($request->file('resume')->getClientOriginalName(), PATHINFO_FILENAME) . '-' . uniqid() . '.' . $request->file('resume')->getClientOriginalExtension()); $applicant->resume = $filename; if ($request->file('resume')->move(base_path() . '/public/images/Resumes/', $filename)) { $applicant->save(); $firstname = $request->first_name; $lastname = $request->last_name; $applyemail = $request->email; $this->sendConfirmation($firstname, $lastname, $applyemail); return redirect('company/careers')->with('success', 'Your application is successfully submitted'); } else { return redirect('company/careers')->with('fail', 'Something went wrong. Try again.'); } }
/** * Show the form for editing the specified resource. * * @param int $id * @return \Illuminate\Http\Response */ public function edit($id) { $job = Job::where('id', $id)->first(); return view('jobs.edit')->with('job', $job); }
/** * Store a newly created resource in storage. * * @return Response */ public function store() { // validate // read more on validation at http://laravel.com/docs/validation $rules = array('judul' => 'required', 'deskripsi' => 'required', 'upah_max' => 'required|numeric', 'upah_min' => 'required|numeric', 'category' => 'required'); $validator = Validator::make(Input::all(), $rules); // process the login if ($validator->fails()) { return Redirect::to('job/create')->withErrors($validator)->withInput(Input::except('password')); // TODO: Check } else { $logged_user_id = Auth::user()->id; // store $new_job = new Job(); $new_job->freelancer_info_id = $logged_user_id; $new_job->judul = Input::get('judul'); $new_job->deskripsi = Input::get('deskripsi'); $new_job->upah_max = Input::get('upah_max'); $new_job->upah_min = Input::get('upah_min'); $new_job->save(); $new_job_cat = new JobCategory(); $new_job_cat->job_id = Job::where('judul', Input::get('judul'))->first()->id; $new_job_cat->category_id = Input::get('category'); $new_job_cat->save(); // redirect //Session::flash('message', 'Successfully created job!'); return Redirect::to('job'); } }
public function getJobs() { $jobs = Job::where("company_id", Auth::getUser()->company_id)->with(["company", "customer"]); return view("jobs", ["jobs" => $jobs]); }
public function randomGenerator() { $id = 'JJ' . mt_rand(1000, 9999); $count = Job::where('job_id', '$id')->count(); if ($count != 0) { randomGenerator(); } return $id; }
/** * Show all job request for the logged-in user * * @return Response */ public function showAllRequest() { // get all his/her job $logged_user_id = Auth::user()->id; $user_info = UserInfo::find($logged_user_id); $freelancer_info = FreelancerInfo::find($user_info->user_id); $jobs = Job::where('freelancer_info_id', $freelancer_info->user_info_id)->get(); $query = "SELECT jr.job_id, jr.seeker_id, j.deskripsi "; $query = $query . "FROM job_request jr, job j "; $query = $query . "WHERE j.freelancer_info_id = " . $freelancer_info->user_info_id . " and j.id = jr.job_id"; $job_requests = DB::select(DB::raw($query)); $job_requests_data = []; foreach ($job_requests as $a_job_req => $value) { # code... $job_id = $value->job_id; $job_deskripsi = $value->deskripsi; $seeker_id = $value->seeker_id; $seeker_email = User::find($seeker_id)->email; $a_job_req_data = array('job_id' => $job_id, 'job_deskripsi' => $job_deskripsi, 'seeker_id' => $seeker_id, 'seeker_email' => $seeker_email); array_push($job_requests_data, $a_job_req_data); } return View::make('job.requests')->with('job_requests_data', $job_requests_data); }
public function show($slug, $id) { $job = Job::where('id', $id)->where('title', $slug)->firstOrFail(); return view('jobs.show', compact('job')); }
public function approveAll(Request $request) { $JobsId = $request->input('SelectedJobs'); if (is_array($JobsId)) { foreach ($JobsId as $job) { $job = Job::where('id', $job)->update(['approved' => 1]); } } $jobs = Job::where('approved', 0)->orderBy('title', 'desc')->get(); Session::flash('success', 'Jobs have been approved'); return view('jobs.approve')->withJobs($jobs); }
public function display(Request $request) { $jobType = $request->input('jobtype', 'all'); switch ($jobType) { case 'fixed': $jobType = 2; break; case 'hourly': $jobType = 3; break; case 'services': $jobType = 1; break; default: $jobType = 0; } $startDate = date('Y-m-d', strtotime('-12 month')); $endDate = date('Y-m-d'); $jobModel = new Job(); $jobCounts = $jobModel->select('jobtype', DB::raw('count(id) as counts'))->where('updated_at', '>=', $startDate)->where('updated_at', '<=', $endDate)->groupBy('jobtype')->get()->toArray(); $chartData = array(); foreach ($jobCounts as $counts) { switch ($counts['jobtype']) { case 1: $label = 'Services'; break; case 2: $label = 'Fixed'; break; case 3: $label = 'Hourly'; break; default: $label = 'All'; } $chartData[] = array('label' => $label, 'value' => (int) $counts['counts']); } $jobStats = $jobModel->select(DB::raw('count(id) as counts'), DB::raw('date(updated_at) as date'))->whereIn('jobtype', array(2, 3))->where('status', 6)->where('updated_at', '>=', $startDate)->where('updated_at', '<=', $endDate)->groupBy('status')->groupBy('updated_at')->get()->toArray(); $statsData = array(); $maxValue = 3; foreach ($jobStats as $stats) { $statsData[strtotime($stats['date'])] = (int) $stats['counts']; $maxValue = $stats['counts'] > $maxValue ? (int) $stats['counts'] : $maxValue; } $xtmp = array(); for ($i = 365; $i >= 0; $i--) { $date = strtotime($endDate . '-' . $i . ' day'); if (isset($statsData[$date])) { $xtmp[] = array('x' => $date, 'y' => $statsData[$date]); } else { $xtmp[] = array('x' => $date, 'y' => 0); } } $tmp[] = array('key' => 'Project completed', 'values' => $xtmp); $totalProjects = $jobModel->where('status', '>', 0)->whereIn('jobtype', array(2, 3))->where('updated_at', '>=', $startDate)->where('updated_at', '<=', $endDate)->count(); $totalPostedProjects = $jobModel->whereIn('jobtype', array(2, 3))->where('updated_at', '>=', $startDate)->where('updated_at', '<=', $endDate)->count(); $projectStats = $jobModel->select('status', DB::raw('count(id) as counts'))->whereIn('jobtype', array(2, 3))->where('status', '>', 0)->where('updated_at', '>=', $startDate)->where('updated_at', '<=', $endDate)->groupBy('status')->lists('counts', 'status'); $serviceStats = $jobModel->select('status', DB::raw('count(id) as counts'))->where('jobtype', 1)->where('updated_at', '>=', $startDate)->where('updated_at', '<=', $endDate)->groupBy('status')->lists('counts', 'status'); $totalPostedServices = array_sum($serviceStats->all()); $services = $jobModel->select('id')->where('jobtype', 1)->lists('id'); $serviceWorkstream = Workstream::select('type_id', DB::raw('count(id) as counts'))->where('type', 0)->whereIn('type_id', $services)->where('status', 11)->where('updated_at', '>=', $startDate)->where('updated_at', '<=', $endDate)->groupBy('type_id')->lists('counts', 'type_id'); $serviceWorkstream = $serviceWorkstream->all(); $totalSold = array_sum($serviceWorkstream); $totalSellingServices = count($serviceWorkstream); if ($jobType != 0) { $jobModel = $jobModel->where('jobtype', $jobType); } $jobs = $jobModel->where('updated_at', '>=', $startDate)->where('updated_at', '<=', $endDate)->orderBy('id', 'desc')->paginate(10); $data = array(); $data['page'] = 'job'; $data['totalPostedProjects'] = $totalPostedProjects; $data['totalProjects'] = $totalProjects; $data['jobs'] = $jobs; $data['chartData'] = $chartData; $data['statsData'] = $tmp; $data['totalCompletedProject'] = isset($projectStats[6]) ? $projectStats[6] : 0; $data['totalPostedServices'] = $totalPostedServices; $data['totalActiveServices'] = isset($serviceStats[2]) ? $serviceStats[2] : 0; $data['totalSellingServices'] = $totalSellingServices; $data['totalSold'] = $totalSold; $data['maxValue'] = $maxValue; //how many jobs are posted and how many are completed //calculate project convertion ratio return view('backend.display')->with($data); }