public function register(Request $request) { $job = new Job(); $job->timestamps = false; $job->jobTitle = $request->input('title'); $job->jobAttributes = $request->input('attributes'); $job->jobDescription = $request->input('description'); $job->jobPublishDate = $request->input("finishDate"); $job->jobFinishDate = $request->input('finishDate'); $job->jobLocation = $request->input('location'); $job->jobNeedPersonal = $request->input('needPersonal'); $job->jobSector = $request->input('sector'); $job->jobPozisyonTip = $request->input('pozisyonTip'); $job->jobDepartment = $request->input('department'); $job->jobLevel = $request->input('level'); $job->jobExperienceLevel = $request->input('experienceLevel'); $job->jobEducationLevel = $request->input('educationLevel'); if ($job->save()) { //Session::set('employeeId', $query->employeeId); $result = array("result" => "success"); } else { $result = array("result" => "failed"); } return \View::make('ajaxResult', $result); }
function refreshComment($id) { $job = new Job(); $job->type = 'refresh_comment'; $job->arguments = json_encode(['id' => $id]); $job->save(); }
private function failJob(Job $job, $msg) { $message = "Job with ID {$job->id} failed: {$msg}"; echo "{$message}\n"; Yii::getLogger()->log($message, Logger::LEVEL_ERROR); $job->status = 'failed'; if (!$job->save()) { Yii::getLogger()->log("Failed to save failure status in the job {$job->id}", Logger::LEVEL_ERROR); } }
/** * Define the application's command schedule. * * @param \Illuminate\Console\Scheduling\Schedule $schedule * @return void */ protected function schedule(Schedule $schedule) { $schedule->command('inspire')->hourly(); $schedule->call(function () { Log::info('attaching new verified skills started'); $skills = Skill::whereNotNull('verified_skill_id')->get(); foreach ($skills as $skill) { $jobs = Job::whereHas('skills', function ($query) use($skill) { $query->where('skill_id', $skill->id); })->whereHas('verifiedSkills', function ($query) use($skill) { $query->where('verified_skill_id', $skill->verified_skill_id); }, '<', 1)->get(); foreach ($jobs as $job) { $job->verifiedSkills()->attach($skill->verified_skill_id); } } })->daily(); $schedule->call(function () { Log::info('HH parsing started'); $hhGrabber = $this->app['App\\Helpers\\HeadHunterGrabber']; $job = $this->app['App\\Models\\Job']; $parser = new Parser([$hhGrabber], $job); $parser->parse(); })->daily(); }
/** * получает массив вакансий за пол года, содержащих хотябы один навык из перечисленных * * @param $skillIds - массив навыков * @param $areaId - регион */ public static function getJobWithSkills($skillIds, $areaId) { $currentDate = new \DateTime(); $halfYear = new \DateInterval('P3M'); $date = $currentDate->sub($halfYear)->format('Y-m-d'); $jobs = Job::with('verifiedSkills')->where('area_id', $areaId)->where('endda', '>=', $date)->whereHas('verifiedSkills', function ($query) use($skillIds) { $query->whereIn('verified_skills.id', $skillIds); })->get(); $groups = []; foreach ($jobs as $job) { $groupElement = $job->toGroupElement($skillIds); if ($groupElement['additional_skills_count'] <= 3) { $groups[$job->getGroupName($skillIds)][] = $groupElement; } } $result = []; foreach ($groups as $groupName => $group) { $groupAggregation = Job::getGroupAggregation($groupName, $group); if ($groupAggregation['aggregation']['actual_count'] > 0) { $result[] = $groupAggregation; } } usort($result, function ($group1, $group2) { $a = $group1['aggregation']['additional_skills_count']; $b = $group2['aggregation']['additional_skills_count']; if ($a === $b) { return 0; } return $a > $b ? 1 : -1; }); return $result; }
/** * Store a newly created resource in storage. * * @param \Illuminate\Http\Request $request * @return \Illuminate\Http\Response */ public function store(Request $request) { $payload['success'] = false; $user = new User(); $updateJob = false; foreach ($request->all() as $key => $value) { if ('jobId' == $key) { $updateJob = $value; } else { $user->{$key} = $value; } } // Update job with user id // @todo - add check on success/failure to save if (false !== $updateJob) { $job = \App\Models\Job::find($updateJob); $job->user = $user->id; $job->save(); } $output = $user->save(); if (false !== $output) { $payload['success'] = true; $payload['contents'] = ['id' => $user->id]; } return response()->json($payload); }
public function attributes() { $allAttr = array_merge(parent::attributes(), ['city.name']); $allAttr = array_merge($allAttr, ['state.name']); $allAttr = array_merge($allAttr, ['jobField.name']); $allAttr = array_merge($allAttr, ['county.name']); return $allAttr; }
/** * Displays a single Organization model. * @param integer $id * @return mixed */ public function actionView($id) { $query = new Query(); $query->from(OrganizationAddress::tableName()); $query->where(['org_id' => $id]); $addressDataProvider = new ActiveDataProvider(['query' => $query]); $jobDataProvider = new ActiveDataProvider(['query' => Job::find()->where(['org_id' => $id]), 'pagination' => ['pageSize' => 5]]); return $this->render('extended_view', ['model' => $this->findModel($id), 'workModel' => OrganizationWork::find()->where(['org_id' => $id])->one(), 'addressDataProvider' => $addressDataProvider, 'jobDataProvider' => $jobDataProvider]); }
/** * Edit Emails Reports * @return Array json Emails */ public function editemails($id) { // Find the emailreport using the email id $email = Emails::find($id); $clientspermissions = ""; $jobspermissions = ""; $clientspermissions = unserialize($email->clients); $jobspermissions = unserialize($email->jobs); Former::populate($email); return View::make('admin.emailnewedit')->with('when', array('Daily' => 'Daily', "Weekly" => "Weekly", "Monthly" => "Monthly"))->with('whenSelected', $email->when)->with('clients', Client::clientSelectBox())->with('clientsSelected', $clientspermissions)->with('jobsSelected', $jobspermissions)->with('jobs', Job::jobSelectBox())->with('emails', $email->emails)->with('id', $email->id); }
/** * Show job * * @param string $urlname [description] * @return Response * @author Ashley Banks <*****@*****.**> */ public function show($urlname = "") { $job = Job::where('urlname', '=', $urlname)->first(); if (false === $job) { throw new Exception("Must provide valid job to display"); } if (false !== Auth::check()) { } // Redirect to another stage return redirect('jobs/user/' . $job->id); }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Job::find(); $dataProvider = new ActiveDataProvider(['query' => $query]); $this->load($params); if (!$this->validate()) { // uncomment the following line if you do not want to return any records when validation fails // $query->where('0=1'); return $dataProvider; } $query->andFilterWhere(['id' => $this->id, 'created_at' => $this->created_at, 'updated_at' => $this->updated_at]); $query->andFilterWhere(['like', 'name', $this->name]); return $dataProvider; }
public static function jobSelectBox($jobsall = null) { // Code to resolve pgsql names $f_Name = 'Name'; $f_JobID = 'JobId'; if (Config::get('database.default') == 'pgsql') { $f_Name = strtolower($f_Name); $f_JobID = strtolower($f_JobID); } if ($jobsall == null) { $jobsall = Job::select($f_JobID, $f_Name)->distinct($f_Name)->orderBy($f_Name, 'asc')->get()->toArray(); } $jobsName = array_fetch($jobsall, $f_Name); $jobsId = array_fetch($jobsall, $f_JobID); $jobsSelectBox = array_unique(array_combine($jobsId, $jobsName)); natsort($jobsSelectBox); return $jobsSelectBox; }
public static function postJob($data) { // Charge Stripe Stripe\Stripe::setApiKey(env('STRIPE_SECRET')); $customer = Stripe\Customer::create(['email' => $data['email'], 'card' => $data['stripe_token']]); $charge = Stripe\Charge::create(['customer' => $customer->id, 'amount' => $data['total'] * 100, 'currency' => 'aud']); if ($charge->status == 'failed') { return false; } // Save Job unset($data['stripe_token']); unset($data['_token']); $data['end_date'] = Carbon::createFromFormat('Y-m-d', $data['start_date'])->addWeeks($data['duration']); $job = Job::create($data); // Email Confirmation / edit link //Mail::queue(); // Return Job Object return $job; }
/** * Edit User * @return Array json Users */ public function edituser($id) { // Find the user using the user id $user = Sentry::getUserProvider()->findById($id); // Get the user groups $groupsOfSelected = $user->getGroups(); foreach ($groupsOfSelected as $group) { $this->groupSelected[$group->id] = $group->id; } $clientspermissions = ""; $jobspermissions = ""; $permissions = Userspermissions::find($id); if ($permissions != null) { $clientspermissions = unserialize($permissions->clients); $jobspermissions = unserialize($permissions->jobs); } Former::populate($user); //LOG::info(User::find($id)); return View::make('admin.usersnewedit')->with('groups', $this->group_array)->with('groupSelected', $this->groupSelected)->with('clients', Client::clientSelectBox())->with('clientsSelected', $clientspermissions)->with('jobsSelected', $jobspermissions)->with('jobs', Job::jobSelectBox())->with('email', $user->email)->with('id', $user->id); }
/** * Execute the email command. * * @return mixed */ public function fire() { $schedule = $this->argument('schedule'); if ($schedule == "DAY") { $schedule = '1 Day'; } elseif ($schedule == "WEEK") { $schedule = '7 Day'; } else { $schedule = '31 Day'; } $emails = Emails::where('when', '=', $schedule)->get(); foreach ($emails as $email) { $tjobs = Job::where('jobstatus', '=', 'T')->where('starttime', '>=', Date::now()->sub($schedule))->where('endtime', '<=', Date::now())->whereIn('clientid', unserialize($email->clients))->get(); $data['table'] = $tjobs; /* sends Email */ Mail::send('emails.report', $data, function ($message, $schedule) { $message->to($email->emails)->subject('Backups Stats ' . $schedule . ' Report'); }); } }
public function actionIndex() { $dataProvider = new ActiveDataProvider(['query' => Job::find(), 'pagination' => ['pageSize' => 1]]); $model = new DynamicModel(['search_keyword', 'search_location', 'search_type']); $model->addRule('search_type', 'integer')->addRule('search_location', 'string', ['max' => 128])->addRule('search_keyword', 'string', ['max' => 128]); if ($model->load(Yii::$app->request->post())) { switch ($model->search_type) { case Lookup::item_code('SearchType', 'Organizations'): return $this->redirect(['organization/index', 'search_keyword' => $model->search_keyword]); break; case Lookup::item_code('SearchType', 'Opportunities'): return $this->redirect(['job/index', 'search_keyword' => $model->search_keyword]); break; default: throw new NotFoundHttpException('Your search:' . $model->search_keyword); break; } } return $this->render('index', ['model' => $model, 'dataProvider' => $dataProvider]); }
/** * Edit Group * @return Array json groups */ public function editgroup($id) { // Find the user using the user id $group = Sentry::getGroupProvider()->findById($id); $users = Sentry::getUserProvider()->findAllInGroup($group); // Get the user groups $userSelected = ""; foreach ($users as $user) { $userSelected[$user->id] = $user->id; } /* Get Groups Permissions */ $clientspermissions = ""; $jobspermissions = ""; $permissions = Groupspermissions::find($id); if ($permissions != null) { $clientspermissions = unserialize($permissions->clients); $jobspermissions = unserialize($permissions->jobs); } // LOG::info( $group->name); Former::populate($group->id); return View::make('admin.groupsnewedit')->with('users', $this->user_array)->with('userSelected', $userSelected)->with('clients', Client::clientSelectBox())->with('clientsSelected', $clientspermissions)->with('jobsSelected', $jobspermissions)->with('jobs', Job::jobSelectBox())->with('groupname', $group->name)->with('id', $group->id); }
/** * @return \yii\db\ActiveQuery */ public function getJob() { return $this->hasOne(Job::className(), ['id' => 'job_id']); }
/** * @return \yii\db\ActiveQuery */ public function getJobs() { return $this->hasMany(Job::className(), ['idCategory' => 'id']); }
/** * Display the specified resource. * * @param int $id * @return \Illuminate\Http\Response */ public function show($id) { return view('jobs.view', ['job' => Job::find($id)]); }
/** * Store a newly created resource in storage. * * @param \Illuminate\Http\Request $request * @return \Illuminate\Http\Response */ public function store(Job $jobModel, Request $request, StoreJobPostRequest $request) { $title = $request->input('title'); $jobModel->create($request->all()); return redirect('/'); }
public function searchByCompany($params) { $company_id = $params['id']; $wherelist1 = ''; $wherelist2 = ''; if (isset($params['from_date']) && !empty($params['from_date'])) { $from_date = $params['from_date']; $wherelist1 = 'job_date >= "' . $from_date . '"'; } if (isset($params['to_date']) && !empty($params['to_date'])) { $to_date = $params['to_date']; $wherelist2 = 'job_date <= "' . $to_date . '"'; } $query = Job::find(); $query->where('company_id=' . $company_id); if ($wherelist1 != "") { $query->andWhere($wherelist1); } if ($wherelist2 != "") { $query->andWhere($wherelist2); } if ($wherelist1 == "" && $wherelist2 == "") { $query->andWhere('job_date BETWEEN CURDATE() AND CURDATE() + INTERVAL 30 DAY'); } // echo $query->createCommand()->getRawSql();exit; $dataProvider = new ActiveDataProvider(['query' => $query, 'sort' => ['defaultOrder' => ['job_date' => SORT_ASC]]]); // $this->load($params); if (!($this->load($params) && $this->validate())) { // uncomment the following line if you do not want to return any records when validation fails // $query->where('0=1'); return $dataProvider; } $query->andFilterWhere(['job_id' => $this->job_id, 'company_id' => $this->company_id, 'job_date' => $this->job_date, 'quota' => $this->quota, 'time_in' => $this->time_in, 'time_out' => $this->time_out, 'close_hour' => $this->close_hour]); $query->andFilterWhere(['like', 'job_order', $this->job_order]); return $dataProvider; }
public function getvolumes() { $tjobs = Job::select(array($this->tables['job'] . '.jobid', 'name', 'starttime', 'endtime', 'level', 'jobbytes', 'jobfiles', 'jobstatus'))->join($this->tables['jobmedia'], $this->tables['jobmedia'] . '.jobid', '=', $this->tables['job'] . '.jobid')->join($this->tables['media'], $this->tables['media'] . '.mediaid', '=', $this->tables['jobmedia'] . '.mediaid')->where($this->tables['media'] . '.mediaid', '=', Input::get('Volume'))->groupby($this->tables['job'] . '.jobid')->groupby('starttime')->groupby('endtime')->groupby('level')->groupby('jobbytes')->groupby('jobfiles')->groupby('jobstatus')->groupby('name')->groupby('volumename'); return Datatables::of($tjobs)->edit_column('name', '{{ link_to_route("jobs", $name ,array("Job" => $jobid)) }} ')->edit_column('jobid', '{{ link_to_route("jobs", $jobid ,array("Job" => $jobid)) }} ')->make(); }
/** * Finds the Job model based on its primary key value. * If the model is not found, a 404 HTTP exception will be thrown. * @param integer $id * @return Job the loaded model * @throws NotFoundHttpException if the model cannot be found */ protected function findModel($id) { if (($model = Job::findOne($id)) !== null) { return $model; } else { throw new NotFoundHttpException('The requested page does not exist.'); } }
public function getclients() { $start = Input::get('start', Date::now()->format('date')); $end = Input::get('end', Date::now()->format('date')); $client = Client::where('clientid', '=', Input::get('Client'))->first(); $tjobs = Job::select(array('jobid', 'name', 'starttime', 'endtime', 'level', 'jobbytes', 'jobfiles', 'jobstatus'))->where('clientid', '=', $client->clientid)->where('starttime', '>=', $start)->where('endtime', '<=', $end); switch (Input::get('type')) { case "terminated": $tjobs->where('jobstatus', '=', 'T'); break; case "running": $tjobs->where('jobstatus', '=', 'R'); break; case "watting": $tjobs->wherein('jobstatus', array('c', 'F', 'j', 'M', 'm', 'p', 's', 't')); break; case "error": $tjobs->wherein('jobstatus', array('e', 'f', 'E')); break; case "cancel": $tjobs->where('jobstatus', '=', 'A'); break; } return Datatables::of($tjobs)->edit_column('name', '{{ link_to_route("jobs", $name ,array("Job" => $jobid)) }} ')->edit_column('jobid', '{{ link_to_route("jobs", $jobid ,array("Job" => $jobid)) }} ')->make(); }
/** * @return \yii\db\ActiveQuery */ public function getJobs() { return $this->hasMany(Job::className(), ['idCompany' => 'idUser']); }
/** * Run the database seeds. * * @return void */ public function run() { Model::unguard(); DB::table('payables')->delete(); DB::table('payable_types')->delete(); DB::table('job_order_jobs')->delete(); DB::table('job_orders')->delete(); DB::table('jobs')->delete(); DB::table('customer_phones')->delete(); DB::table('customers')->delete(); DB::table('users')->delete(); DB::table('companies')->delete(); $companies = []; foreach (range(0, 2) as $x) { $companies[] = \App\Models\Company::create(['name' => "Empresa {$x}", 'email' => "empresa{$x}@teste.com.br", 'cnpj' => '81.748.407/0001-01', 'ie' => '309.639.790.252', 'address' => "Endereço da Empresa {$x}", 'number' => $x, 'district' => "Bairro de Teste {$x}", 'city' => "Cidade de Teste {$x}", 'state' => "Teste", 'zip' => '00000-0' . str_pad($x, 2, '0', STR_PAD_LEFT), 'contact' => "Pessoa de Teste {$x}"]); } $cid = 0; foreach ($companies as $company) { $cid += 1; User::create(['name' => 'Teste', 'email' => "teste{$cid}@teste.com.br", 'password' => Hash::make('teste')])->company()->associate($company)->save(); $jobs = []; foreach (range(0, 15) as $x) { $job = Job::create(['name' => "Serviço de teste {$cid}/{$x}", 'price' => $x * 100, 'description' => "Serviço de teste {$x}"])->company()->associate($company); $job->save(); $jobs[] = $job; } $customers = []; foreach (range(0, 15) as $x) { $customer = Customer::create(['name' => "Cliente {$cid}/{$x}", 'email' => "cliente{$x}@teste.com.br", 'cnpj' => '81.748.407/0001-01', 'ie' => '309.639.790.252', 'address' => "Endereço de Teste {$x}", 'number' => $x, 'district' => "Bairro de Teste {$x}", 'city' => "Cidade de Teste {$x}", 'state' => "Teste", 'zip' => '00000-0' . str_pad($x, 2, '0', STR_PAD_LEFT), 'contact' => "Pessoa de Teste {$x}"])->company()->associate($company); $customer->save(); foreach (range(0, rand(1, 5)) as $y) { $customer->phones()->create(['phone' => "1398765432{$y}"]); } $testJobs = array_pick_index($jobs, array_rand($jobs, 5)); $customerJobOrder = JobOrder::create(['customer_id' => $customer->id, 'note' => "Nota de teste para o cliente {$cid}/{$x}"])->company()->associate($company); $customerJobOrder->save(); $testJobs = array_map(function ($item) { return ['job_id' => $item->id, 'price' => $item->price]; }, $testJobs); $customerJobOrder->jobs()->sync($testJobs); $customerJobOrder->save(); $customers[] = $customer; } $payableTypes = []; foreach (range(0, 15) as $i) { $payableType = PayableType::create(['name' => "Conta de Teste {$cid}/{$i}", 'description' => "Descrição do tipo {$i}"])->company()->associate($company); $payableType->save(); $payableTypes[] = $payableType; } $payables = []; foreach ($customers as $customer) { foreach (range(0, rand(1, 5)) as $x) { $type = current(array_pick_index($payableTypes, array_rand($payableTypes, 5))); $payable = \App\Models\Payable::create(['payable_type_id' => $type->id, 'date' => \Carbon\Carbon::now()->addDays(rand(1, 60)), 'status' => rand(1, 2), 'price' => $x * 100, 'description' => "Descrição de uma conta a pagar {$customer->id}/{$x}"])->company()->associate($company); $payable->save(); $payables[] = $payable; } } } Model::reguard(); }
/** * @return \yii\db\ActiveQuery */ public function getJobs() { return $this->hasMany(Job::className(), ['org_id' => 'id']); }
public function index(Request $request) { return Job::throughCompany()->ngTable($request, null, ['id', 'name'], ['id', 'name']); }
/** * RESTful method for deleting a job * * @param string $id * @return json * @author Ashley Banks <*****@*****.**> */ public function destroy($id = "") { $payload['success'] = false; if (false !== Job::destroy($id)) { $payload['success'] = true; } return response()->json($payload); }