public function anyEmployerOpen()
{
$user = Sentry::getUser();
$jobs = Job::where("user_id", '=', $user->id)->where("job_status_id", '=', JobStatus::$OPEN)->where('start_date', '>=', date('Y-m-d'))->orderBy('start_date', 'asc')->get();
$jobs->load('jobApplicants', 'address');
return View::make('jobs.employer_open', compact('jobs'));
}
public static function boot()
{
parent::boot();
static::creating(function ($workerunit) {
// dd($workerunit);
// Inherit type, domain and format
if (empty($workerunit->type) or empty($workerunit->domain) or empty($workerunit->format)) {
$j = Job::where('_id', $workerunit->job_id)->first();
$workerunit->type = $j->type;
$workerunit->domain = $j->domain;
$workerunit->format = $j->format;
}
$workerunit->annotationVector = $workerunit->createAnnotationVector();
// Activity if not exists
if (empty($workerunit->activity_id)) {
try {
$activity = new Activity();
$activity->label = "Workerunit is saved.";
$activity->softwareAgent_id = $workerunit->softwareAgent_id;
$activity->save();
$workerunit->activity_id = $activity->_id;
Log::debug("Saving workerunit {$workerunit->_id} with activity {$workerunit->activity_id}.");
} catch (Exception $e) {
if ($activity) {
$activity->forceDelete();
}
//if($workerunit) $workerunit->forceDelete();
throw new Exception('Error saving activity for workerunit.');
}
}
});
}
/**
* 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);
}
/**
* Execute the console command.
*
* @return void
*/
public function fire()
{
$this->line('Welcome to the job cron.');
$auto_close = Configuration::where('key', 'auto_close')->first();
if ($auto_close['value']) {
$auto_close_time = Configuration::where('key', 'auto_close_time')->first();
$diff_time = date("Y-m-d H:i:s", time() - $auto_close_time['value'] * 60 * 60);
$jobs = Job::where('status', '=', '1')->where('invalid', '=', '0')->where('start_time', '<', $diff_time)->get();
foreach ($jobs as $job) {
Job::where('id', $job->id)->update(array('status' => 2));
}
}
$this->line('Done !');
}
/**
* Execute the console command
*
* @return void
*/
public function fire()
{
$job_name = $this->argument('jobname');
list($collection_uri, $name) = InputController::getParts($job_name);
// Check if the job exists
$job = \Job::where('name', '=', $name)->where('collection_uri', '=', $collection_uri)->first();
if (empty($job)) {
$this->error("The job with identified by: {$job_name} could not be found.\n");
exit;
}
$this->line('The job has been found.');
$job_exec = new JobExecuter($job, $this);
$job_exec->execute();
}
/**
* Execute the console command
*
* @return void
*/
public function fire()
{
// Check for a list option
$list = $this->option('list');
$job_name = $this->argument('jobname');
if (empty($list) && !empty($job_name)) {
$inputController = new InputController();
list($collection_uri, $name) = $inputController->getParts($job_name);
// Check if the job exists
$job = \Job::where('name', '=', $name)->where('collection_uri', '=', $collection_uri)->first();
if (empty($job)) {
$this->error("The job with identified by: {$job_name} could not be found.\n");
exit;
}
$this->info('The job has been found.');
// Configure a log handler if configured
$this->addLogHandler();
$startDate = new Carbon();
$iso8601 = $startDate->toISo8601String();
\Log::info("Executing job {$name} at {$iso8601}");
try {
$job_exec = new JobExecuter($job, $this);
$job_exec->execute();
} catch (\Exception $ex) {
$endDate = new Carbon();
$iso8601 = $endDate->toISO8601String();
\Log::error("The job {$job_name} has failed at {$iso8601}");
\Log::error($ex->getMessage());
\Log::error($ex->getTraceAsString());
}
$endDate = new Carbon();
$iso8601 = $endDate->toISO8601String();
$job->date_executed = time();
$job->added_to_queue = false;
$job->save();
\Log::info("The job has ended at {$iso8601}");
} else {
$jobs = \Job::all(['name', 'collection_uri'])->toArray();
if (!empty($jobs)) {
$this->info("=== Job names ===");
foreach ($jobs as $job) {
$this->info($job['collection_uri'] . '/' . $job['name']);
}
} else {
$this->info("No jobs found.");
}
}
}
public function loadJob($id)
{
$squeeb = Job::where('id', '=', $id)->first();
View::share('squeeb', $squeeb);
view::share('model', 'Job');
//detect device
$detect = new Mobile_Detect();
$deviceType = $detect->isMobile() ? $detect->isTablet() ? 'tablet' : 'phone' : 'computer';
View::share('deviceType', $deviceType);
//update the squeeb table
$this->sqFactor($squeeb);
if (Auth::user()) {
return View::make('member.squeeb');
}
return View::make('guest.squeeb');
}
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);
}
public function index()
{
$query = Job::where('status', '=', Job::APPROVED)->where('closing_date', '>=', \Carbon\Carbon::now())->where('published_date', '<=', \Carbon\Carbon::now());
if (\Input::get('type') && in_array(\Input::get('type'), array(Job::PERMANENT, Job::TEMPORARY))) {
$query->where('type', '=', \Input::get('type'));
}
if (\Input::get('time') && in_array(\Input::get('time'), array(Job::FULL_TIME, Job::PART_TIME))) {
$query->where('time', '=', \Input::get('time'));
}
if (\Input::get('keywords')) {
$keywords = \Input::get('keywords');
if (!empty($keywords)) {
$query->whereRaw("MATCH(title,description,reference,location,search_extra,meta_description,meta_keywords) AGAINST(? IN BOOLEAN MODE)", array($keywords));
}
}
$query->orderby('published_date', \Config::get('laravel-jobs::index_order'));
$jobs = $query->paginate(\Config::get('laravel-jobs::results_per_page'));
return \View::make(\Config::get('laravel-jobs::index_view'))->with(compact('jobs'));
}
if ($payload['exp'] < time()) {
Response::json(array('message' => 'Token has expired'));
}
});
Route::filter('auth.job', function ($route) {
if (!Request::header('Authorization')) {
return Response::json(array('message' => Request::header()), 401);
}
$token = explode(' ', Request::header('Authorization'))[1];
$payloadObject = JWT::decode($token, Config::get('secrets.TOKEN_SECRET'));
$payload = json_decode(json_encode($payloadObject), true);
if ($payload['exp'] < time()) {
Response::json(array('message' => 'Token has expired'));
}
$id = $route->getParameter('id');
$exist = Job::where('id', $id)->where('user_id', userId())->get()->toArray();
if (empty($exist)) {
return Response::json(array('message' => 'You are not allowed access to this record. You have been logged out.'), 401);
}
});
Route::filter('auth.basic', function () {
return Auth::basic();
});
/*
|--------------------------------------------------------------------------
| Guest Filter
|--------------------------------------------------------------------------
|
| The "guest" filter is the counterpart of the authentication filters as
| it simply checks that the current user is not logged in. A redirect
| response will be issued if they are, which you may freely change.
public function getProcesscrowdgames()
{
$gameJobs = Job::where('softwareAgent_id', 'DrDetectiveGamingPlatform')->get();
$activity = new Activity();
$activity->softwareAgent_id = 'DrDetectiveGamingPlatform';
$activity->save();
foreach ($gameJobs as $job) {
// $annotations = Entity::where('jobParents', $job['_id'])->get();
// Create one annotation vector for each image on the game
$images = Entity::where('jobParents', $job['_id'])->distinct('content.task_data')->get();
$annotationsSummary = [];
foreach ($images as $image) {
$imageName = $image[0];
// unpack data
$annotations = Entity::where('jobParents', $job['_id'])->where('content.task_data', $imageName)->get();
$annotations = $annotations->toArray();
// Create an array with all coordinates given for target image.
$coordinates = array_column(array_column(array_column($annotations, 'content'), 'response'), 'Coordinates');
$allCoordinates = [];
foreach ($coordinates as $coords) {
// Flatten to array of coords.
foreach ($coords as $c) {
$allCoordinates[] = $c;
}
}
$aggCoords = static::aggregateCoordinates($allCoordinates);
$annotationsSummary[] = ['image' => $imageName, 'aggregateCoordinates' => $aggCoords];
}
// process annotations for this job into an annotation vector...
$e = new Entity();
$e->jobParents = [$job['_id']];
$e->annotationVector = $annotationsSummary;
$e->documentType = 'annotationVector';
$e->activity_id = $activity->_id;
$e->softwareAgent_id = $job->softwareAgent_id;
$e->project = $job->project;
$e->user_id = $job->user_id;
$e->save();
}
return 'OK -- may need adjustments...';
}
} else {
?>
<p class="flash-message static error"><?php
echo e($this->fatalError);
?>
</p>
<p><a href="<?php
echo Backend::url('gatto/jobs/qualifications');
?>
" class="btn btn-default">Return to Qualifications list</a></p>
<?php
}
?>
This is a query for the front-end, using Laravel query builder:
it retrieves all the appointments for the logged in customer.
<?php
$this['appointments'] = Appointments::where('customer_id', '=', Auth::getUser()->id)->where('gatto_jobs_appointments.id', '=', $app_id)->join('gatto_jobs_jobs', 'gatto_jobs_appointments.job_id', '=', 'gatto_jobs_jobs.id')->join('users', 'gatto_jobs_appointments.customer_id', '=', 'users.id')->join('gatto_jobs_timeslots', 'gatto_jobs_timeslots.id', '=', 'time_slot')->get(['gatto_jobs_appointments.*', 'gatto_jobs_jobs.name as name', 'gatto_jobs_timeslots.name as timeslot', 'users.name as username'])->toArray();
?>
This is a simple Eloquent query to find a Job from an ID:
<?php
$this['selected_job'] = Job::where('id', '=', $this['job_id'])->first()->toArray();
public function index()
{
$jobs = Job::where('user_id', userId())->get()->toArray();
return Response::json(['data' => $jobs], 200);
}
/**
* getReinvalid
*
* @param null $job_id
*
* @return mixed
*/
public function getReinvalid($job_id = NULL)
{
if (is_null($job = Job::where('member_id', '=', Auth::user()->id)->find($job_id))) {
return Redirect::to('ticket')->with('error', '工单不存在');
}
$job->where('id', $job_id)->update(array('invalid' => 0));
return Redirect::to('ticket')->with('success', '工单恢复成功');
}
public static function JobsInterestedIn(StudentInfo $student, $studentAddress = null)
{
if ($studentAddress == null) {
$studentAddress = $student->primaryAddress;
}
$preferredCategories = $student->studentJobPreferences->lists('job_category_id');
return Job::where('job_status_id', '=', JobStatus::$OPEN)->whereIn("jobs.job_category_id", $preferredCategories)->where("jobs.start_date", ">=", date("Y-m-d"))->orderBy('jobs.start_date', 'asc')->select("jobs.*", Address::distanceSelectStatement($studentAddress->latitude, $studentAddress->longitude, 'distance', 'jobs'))->having("distance", "<=", $student->studentProfile->preferred_job_radius)->get();
}
public function getJobsByCategory($id)
{
$jobs = Job::where('category_id', '=', $id)->get();
return json_encode($jobs);
}
/**
* Edit a job
*
* @param string $uri The uri of the job
*
* @return \View
*/
private function editJob($uri)
{
$pieces = explode('/', $uri);
$id = array_pop($pieces);
if (is_numeric($id)) {
$job = \Job::where('id', $id)->with('extractor', 'loader')->first();
if (empty($job)) {
return \Redirect::to('api/admin/jobs');
}
}
$discovery = \App::make('Tdt\\Core\\Definitions\\DiscoveryController');
$discovery = json_decode($discovery->get()->getcontent());
// Get the configuration for the selected ETL
$input_extract_spec = $discovery->resources->input->methods->put->body->extract->parameters->type;
$input_load_spec = $discovery->resources->input->methods->put->body->load->parameters->type;
$extract_type = strtolower($job->extractor->type);
$load_type = strtolower($job->loader->type);
$extract_parameters = $input_extract_spec->{$extract_type}->parameters;
$load_parameters = $input_load_spec->{$load_type}->parameters;
// Fill in list parameters in the provided configurations
foreach ($extract_parameters as $parameter) {
if ($parameter->type == 'list') {
if (strpos($parameter->list, '|')) {
$parameter->list = explode('|', $parameter->list);
} else {
$list = json_decode($this->getDocument($parameter->list));
if (!empty($parameter->list_option)) {
$filtered_list = [];
foreach ($list as $object) {
$object = (array) $object;
$filtered_list[] = $object[$parameter->list_option];
}
$parameter->list = $filtered_list;
} else {
$parameter->list = $list;
}
}
}
}
// Fill in list parameters in the provided configurations
foreach ($load_parameters as $parameter) {
if ($parameter->type == 'list') {
if (strpos($parameter->list, '|')) {
$parameter->list = explode('|', $parameter->list);
} else {
$list = json_decode($this->getDocument($parameter->list));
if (!empty($parameter->list_option)) {
$filtered_list = [];
foreach ($list as $object) {
$object = (array) $object;
$filtered_list[] = $object[$parameter->list_option];
}
$parameter->list = $filtered_list;
} else {
$parameter->list = $list;
}
}
}
}
$job_config = [];
// Job specific settings
$job_config['schedule'] = explode('|', $discovery->resources->input->methods->put->body->schedule->list);
return \View::make('input::ui.jobs.edit')->with('title', 'Edit a job | The Datatank')->with('extract_parameters', $extract_parameters)->with('load_parameters', $load_parameters)->with('job', $job)->with('job_config', $job_config);
}
public function viewArchive($year, $month)
{
$archive_links = array();
$archive_increment = strtotime('2014/08/01');
$archive_end = strtotime('now');
do {
$archive_links[] = array('label' => date('m') . '-' . date('Y'), 'link' => '/job/archive/view/' . date('Y', $archive_increment) . '/' . date('m', $archive_increment));
$archive_increment = strtotime(date('Y/m/d', $archive_increment) . ' + 1 month');
} while ($archive_increment <= $archive_end);
$archive_start_filter = $year . '/' . $month . '/01 00:00:01';
$archive_end_filter = date('Y/m/d H:i:s', strtotime($archive_start_filter . ' + 1 month'));
return View::make('job_archive', array('for' => $year . '-' . $month, 'jobs' => Job::where('status', '=', '0')->where('created_at', '>=', $archive_start_filter)->where('created_at', '<=', $archive_end_filter)->get(), 'archive_links' => $archive_links));
}
public function getUpdatecfdictionaries()
{
foreach (Job::where('softwareAgent_id', 'cf')->get() as $job) {
foreach ($job->workerunits as $ann) {
if (!empty($ann->annotationVector)) {
continue;
}
$ann->type = $job->type;
$ann->annotationVector = $ann->createWorkerunitVector();
$ann->save();
if (is_null($ann->annotationVector)) {
echo ">>>>>{$ann->unit_id}";
} else {
echo "_____{$ann->unit_id}";
}
}
//Queue::push('Queues\UpdateJob', array('job' => serialize($job)));
}
}
public function getEntity($format, $domain, $docType, $incr, $action)
{
try {
$return = array('status' => 'ok');
$id = "entity/{$format}/{$domain}/{$docType}/{$incr}";
switch ($docType) {
case 'job':
$job = Job::where('_id', $id)->first();
if (!$job) {
throw new Exception('Job not found.');
}
if ($job->user_id != Auth::user()->_id) {
throw new Exception('You can only do this with your own job!');
}
//$this->authenticateUser();
switch ($action) {
case 'pause':
$job->pause();
$return['message'] = 'Job paused successfully.';
break;
case 'resume':
$job->resume();
$return['message'] = 'Job resumed successfully.';
break;
case 'cancel':
$job->cancel();
$return['message'] = 'Job canceled successfully.';
break;
case 'order':
$job->order();
$return['message'] = 'Job ordered successfully.';
break;
case 'delete':
$job->cancel();
// TODO SOFT DELETE
$return['message'] = 'Job canceled, soft delete not yet implemented.';
default:
throw new Exception('Action unknown.');
break;
}
break;
default:
throw new Exception("Unknown documenttype '{$docType}'.");
break;
}
} catch (Exception $e) {
//throw $e; // for debugging.
$return['message'] = $e->getMessage();
$return['status'] = 'bad';
}
return $this->returnJson($return);
}
</div>
<p>
暂无站内简讯
</p>
@endif
</div>
{{-- /Text Widget --}}
{{-- Recent Posts Widget --}}
<div class="widget">
<div class="widget-title">
<h4>热门职位</h4>
</div>
<?php
$posts = Job::where('post_status', 'open')->orderBy('comments_count', 'desc')->paginate(4);
?>
@foreach($posts as $post)
<div class="post-box">
<a href="{{ route('timeline.getTimeline', $post->user->id) }}"> <img class="img-rounded" src="{{ $post->user->portrait_large }}" width="50" height="50" alt=""> </a>
<div>
<h5><a href="{{ route('job.show', $post->slug) }}">{{ $post->title }}</a></h5>
<small>{{ date("M d, Y",strtotime($post->created_at)) }}</small>
</div>
</div>
@endforeach
</div>
{{-- /Recent Posts Widget --}}
{{-- Tags Widget --}}
<div class="widget">
public static function edit_job($params)
{
$job = Job::where('id', $params['id'])->update($params);
//find($params['id']);
if ($job) {
return ['status' => 1];
} else {
return ['status' => 0];
}
}
