Passed
Push — feature/job-summary-hr ( 67ecfb )
by Grant
13:42
created

JobPoster::hr_advisors()   A

Complexity

Conditions 1
Paths 1

Size

Total Lines 5
Code Lines 3

Duplication

Lines 0
Ratio 0 %

Importance

Changes 0
Metric Value
eloc 3
dl 0
loc 5
rs 10
c 0
b 0
f 0
cc 1
nc 1
nop 0
1
<?php
2
3
/**
4
 * Created by Reliese Model.
5
 * Date: Thu, 12 Jul 2018 22:39:27 +0000.
6
 */
7
8
namespace App\Models;
9
10
use Astrotomic\Translatable\Translatable;
11
12
use Backpack\CRUD\app\Models\Traits\CrudTrait;
13
14
use Jenssegers\Date\Date;
15
16
use Illuminate\Notifications\Notifiable;
17
use Illuminate\Support\Facades\App;
18
use Illuminate\Support\Facades\Lang;
19
20
use App\Events\JobSaved;
21
22
/**
23
 * Class JobPoster
24
 *
25
 * @property int $id
26
 * @property int $job_term_id
27
 * @property string $chosen_lang
28
 * @property int $term_qty
29
 * @property \Jenssegers\Date\Date $open_date_time
30
 * @property \Jenssegers\Date\Date $close_date_time
31
 * @property \Jenssegers\Date\Date $start_date_time
32
 * @property \Jenssegers\Date\Date $review_requested_at
33
 * @property \Jenssegers\Date\Date $published_at
34
 * @property int $department_id
35
 * @property int $province_id
36
 * @property int $salary_min
37
 * @property int $salary_max
38
 * @property int $noc
39
 * @property int $classification_id
40
 * @property int $classification_level
41
 * @property int $security_clearance_id
42
 * @property int $language_requirement_id
43
 * @property boolean $remote_work_allowed
44
 * @property int $manager_id
45
 * @property boolean $published
46
 * @property int $team_size
47
 * @property array $work_env_features This should be an array of boolean flags for features, ie json of shape {[feature: string]: boolean}
48
 * @property int $fast_vs_steady
49
 * @property int $horizontal_vs_vertical
50
 * @property int $experimental_vs_ongoing
51
 * @property int $citizen_facing_vs_back_office
52
 * @property int $collaborative_vs_independent
53
 * @property int $telework_allowed_frequency_id
54
 * @property int $flexible_hours_frequency_id
55
 * @property int $travel_requirement_id
56
 * @property int $overtime_requirement_id
57
 * @property int $process_number
58
 * @property int $priority_clearance_number
59
 * @property \Jenssegers\Date\Date $loo_issuance_date
60
 * @property \Jenssegers\Date\Date $created_at
61
 * @property \Jenssegers\Date\Date $updated_at
62
 *
63
 * @property int $submitted_applications_count
64
 *
65
 * @property \App\Models\Lookup\Department $department
66
 * @property \App\Models\Lookup\JobTerm $job_term
67
 * @property \App\Models\Lookup\LanguageRequirement $language_requirement
68
 * @property \App\Models\Manager $manager
69
 * @property \App\Models\Lookup\Province $province
70
 * @property \App\Models\Lookup\SecurityClearance $security_clearance
71
 * @property \Illuminate\Database\Eloquent\Collection $criteria
72
 * @property \Illuminate\Database\Eloquent\Collection $job_applications
73
 * @property \Illuminate\Database\Eloquent\Collection $job_poster_key_tasks
74
 * @property \Illuminate\Database\Eloquent\Collection $job_poster_questions
75
 * @property \Illuminate\Database\Eloquent\Collection $job_poster_translations
76
 * @property \Illuminate\Database\Eloquent\Collection $submitted_applications
77
 * @property \Illuminate\Database\Eloquent\Collection $hr_advisors
78
 * @property \App\Models\Lookup\Frequency $telework_allowed_frequency
79
 * @property \App\Models\Lookup\Frequency $flexible_hours_frequency
80
 *
81
 * Localized Properties:
82
 * @property string $city
83
 * @property string $title
84
 * @property string $dept_impact
85
 * @property string $team_impact
86
 * @property string $hire_impact
87
 * @property string $division
88
 * @property string $education
89
 * @property string $work_env_description
90
 * @property string $culture_summary
91
 * @property string $culture_special
92
 *
93
 * Methods
94
 * @method boolean isOpen()
95
 * @method string timeRemaining()
96
 * @method mixed[] toApiArray()
97
 *
98
 * Computed Properties
99
 * @property string|null $classification_code
100
 * @property string|null $classification_message
101
 */
102
class JobPoster extends BaseModel
103
{
104
    use CrudTrait;
0 ignored issues
show
introduced by
The trait Backpack\CRUD\app\Models\Traits\CrudTrait requires some properties which are not provided by App\Models\JobPoster: $Type, $fakeColumns
Loading history...
105
    use Translatable;
0 ignored issues
show
Bug introduced by
The trait Astrotomic\Translatable\Translatable requires the property $each which is not provided by App\Models\JobPoster.
Loading history...
106
    use Notifiable;
0 ignored issues
show
Bug introduced by
The trait Illuminate\Notifications\Notifiable requires the property $email which is not provided by App\Models\JobPoster.
Loading history...
107
108
    const DATE_FORMAT = [
109
        'en' => 'M jS, Y',
110
        'fr' => 'd M Y',
111
    ];
112
    const TIME_FORMAT = [
113
        'en' => 'h:i A T',
114
        'fr' => 'H \h i T',
115
    ];
116
    const TIMEZONE = 'America/Toronto';
117
118
    /**
119
     * @var string[] $translatedAttributes
120
     */
121
    public $translatedAttributes = [
122
        'city',
123
        'title',
124
        'dept_impact',
125
        'team_impact',
126
        'hire_impact',
127
        'division',
128
        'education',
129
        'work_env_description',
130
        'culture_summary',
131
        'culture_special',
132
    ];
133
134
    /**
135
     * @var string[] $casts
136
     */
137
    protected $casts = [
138
        'job_term_id' => 'int',
139
        'department_id' => 'int',
140
        'province_id' => 'int',
141
        'salary_min' => 'int',
142
        'salary_max' => 'int',
143
        'noc' => 'int',
144
        'classification_id' => 'int',
145
        'classification_level' => 'int',
146
        'security_clearance_id' => 'int',
147
        'language_requirement_id' => 'int',
148
        'remote_work_allowed' => 'boolean',
149
        'manager_id' => 'int',
150
        'published' => 'boolean',
151
        'team_size' => 'int',
152
        'work_env_features' => 'array',
153
        'fast_vs_steady' => 'int',
154
        'horizontal_vs_vertical' => 'int',
155
        'experimental_vs_ongoing' => 'int',
156
        'citizen_facing_vs_back_office' => 'int',
157
        'collaborative_vs_independent' => 'int',
158
        'telework_allowed_frequency_id' => 'int',
159
        'flexible_hours_frequency_id' => 'int',
160
        'travel_requirement_id' => 'int',
161
        'overtime_requirement_id' => 'int',
162
    ];
163
164
    /**
165
     * @var string[] $dates
166
     */
167
    protected $dates = [
168
        'open_date_time',
169
        'close_date_time',
170
        'start_date_time',
171
        'review_requested_at',
172
        'published_at',
173
        'loo_issuance_date',
174
    ];
175
176
    /**
177
     * @var string[] $fillable
178
     */
179
    protected $fillable = [
180
        'job_term_id',
181
        'chosen_lang',
182
        'term_qty',
183
        'open_date_time',
184
        'close_date_time',
185
        'start_date_time',
186
        'department_id',
187
        'province_id',
188
        'salary_min',
189
        'salary_max',
190
        'noc',
191
        'security_clearance_id',
192
        'language_requirement_id',
193
        'remote_work_allowed',
194
        'published',
195
        'team_size',
196
        'work_env_features',
197
        'fast_vs_steady',
198
        'horizontal_vs_vertical',
199
        'experimental_vs_ongoing',
200
        'citizen_facing_vs_back_office',
201
        'collaborative_vs_independent',
202
        'telework_allowed_frequency_id',
203
        'flexible_hours_frequency_id',
204
        'travel_requirement_id',
205
        'overtime_requirement_id',
206
        'process_number',
207
        'priority_clearance_number',
208
        'loo_issuance_date',
209
        'classification_id',
210
        'classification_level',
211
    ];
212
213
    /**
214
     * The attributes that should be visible in arrays.
215
     * In this case, it blocks loaded relations from appearing.
216
     *
217
     * @var array
218
     */
219
    protected $visible = [
220
        'id',
221
        'manager_id',
222
        'chosen_lang',
223
        'term_qty',
224
        'open_date_time',
225
        'close_date_time',
226
        'start_date_time',
227
        'department_id',
228
        'province_id',
229
        'salary_min',
230
        'salary_max',
231
        'noc',
232
        'security_clearance_id',
233
        'language_requirement_id',
234
        'remote_work_allowed',
235
        'published_at',
236
        'published',
237
        'review_requested_at',
238
        'team_size',
239
        'work_env_features',
240
        'fast_vs_steady',
241
        'horizontal_vs_vertical',
242
        'experimental_vs_ongoing',
243
        'citizen_facing_vs_back_office',
244
        'collaborative_vs_independent',
245
        'telework_allowed_frequency_id',
246
        'flexible_hours_frequency_id',
247
        'travel_requirement_id',
248
        'overtime_requirement_id',
249
        'process_number',
250
        'priority_clearance_number',
251
        'loo_issuance_date',
252
        'classification_id',
253
        'classification_level'
254
    ];
255
256
    /**
257
     * The accessors to append to the model's array form.
258
     *
259
     * @var string[] $appends
260
     */
261
    protected $appends = [
262
        'classification_code',
263
        'classification_message'
264
    ];
265
266
    /**
267
     * @var mixed[] $dispatchesEvents
268
     */
269
    protected $dispatchesEvents = [
270
        'saved' => JobSaved::class,
271
    ];
272
273
    // @codeCoverageIgnoreStart
274
    public function department() // phpcs:ignore
275
    {
276
        return $this->belongsTo(\App\Models\Lookup\Department::class);
277
    }
278
279
    public function job_term() // phpcs:ignore
280
    {
281
        return $this->belongsTo(\App\Models\Lookup\JobTerm::class);
282
    }
283
284
    public function language_requirement() // phpcs:ignore
285
    {
286
        return $this->belongsTo(\App\Models\Lookup\LanguageRequirement::class);
287
    }
288
289
    public function manager() // phpcs:ignore
290
    {
291
        return $this->belongsTo(\App\Models\Manager::class);
292
    }
293
294
    public function province() // phpcs:ignore
295
    {
296
        return $this->belongsTo(\App\Models\Lookup\Province::class);
297
    }
298
299
    public function security_clearance() // phpcs:ignore
300
    {
301
        return $this->belongsTo(\App\Models\Lookup\SecurityClearance::class);
302
    }
303
304
    public function criteria() // phpcs:ignore
305
    {
306
        return $this->hasMany(\App\Models\Criteria::class);
307
    }
308
309
    public function hr_advisors() // phpcs:ignore
310
    {
311
        return $this->belongsToMany(
312
            \App\Models\HrAdvisor::class,
313
            'claimed_jobs'
314
        );
315
    }
316
317
    public function job_applications() // phpcs:ignore
318
    {
319
        return $this->hasMany(\App\Models\JobApplication::class);
320
    }
321
322
    public function job_poster_key_tasks() // phpcs:ignore
323
    {
324
        return $this->hasMany(\App\Models\JobPosterKeyTask::class);
325
    }
326
327
    public function job_poster_questions() // phpcs:ignore
328
    {
329
        return $this->hasMany(\App\Models\JobPosterQuestion::class);
330
    }
331
332
    public function job_poster_translations() // phpcs:ignore
333
    {
334
        return $this->hasMany(\App\Models\JobPosterTranslation::class);
335
    }
336
337
    public function telework_allowed_frequency() // phpcs:ignore
338
    {
339
        return $this->belongsTo(\App\Models\Lookup\Frequency::class);
340
    }
341
342
    public function flexible_hours_frequency() // phpcs:ignore
343
    {
344
        return $this->belongsTo(\App\Models\Lookup\Frequency::class);
345
    }
346
347
    public function travel_requirement() // phpcs:ignore
348
    {
349
        return $this->belongsTo(\App\Models\Lookup\TravelRequirement::class);
350
    }
351
352
    public function overtime_requirement() // phpcs:ignore
353
    {
354
        return $this->belongsTo(\App\Models\Lookup\OvertimeRequirement::class);
355
    }
356
357
    public function classification() // phpcs:ignore
358
    {
359
        return $this->belongsTo(\App\Models\Classification::class);
360
    }
361
    // @codeCoverageIgnoreEnd
362
    /* Artificial Relations */
363
364
    /**
365
     * Get all of the Job Applications submitted to this
366
     * Job Poster.
367
     *
368
     * @return \Illuminate\Database\Eloquent\Relations\HasMany
369
     */
370
    public function submitted_applications() // phpcs:ignore
371
    {
372
        return $this->hasMany(\App\Models\JobApplication::class)->whereDoesntHave('application_status', function ($query): void {
373
            $query->where('name', 'draft');
374
        });
375
    }
376
377
    /* Overrides */
378
379
    /**
380
     * Retrieve the model for a bound value.
381
     * Seems to be a useful workaround for providing submitted_applications_count
382
     * to any bound routes that receive a jobPoster instance without using the
383
     * withCount property on the model itself.
384
     * See https://github.com/laravel/framework/issues/23957 for more info.
385
     *
386
     * @param mixed $value Value used to retrieve the model instance.
387
     *
388
     * @return \Illuminate\Database\Eloquent\Model|null
389
     */
390
    public function resolveRouteBinding($value) // phpcs:ignore
391
    {
392
        return $this->withCount('submitted_applications')->where('id', $value)->first() ?? abort(404);
393
    }
394
395
    /**
396
     * Intercept setting the "published" attribute, and set the
397
     * "published_at" timestamp if true.
398
     *
399
     * @param mixed $value Incoming value for the 'published' attribute.
400
     *
401
     * @return void
402
     */
403
    public function setPublishedAttribute($value): void
404
    {
405
        if ($value) {
406
            $this->attributes['published_at'] = new Date();
407
        } else {
408
            $this->attributes['published_at'] = null;
409
        }
410
        if ($value === null) {
411
            $value = false;
412
        }
413
        $this->attributes['published'] = $value;
414
    }
415
416
    /* Methods */
417
418
    public function submitted_applications_count() //phpcs:ignore
419
    {
420
        return $this->submitted_applications()->count();
421
    }
422
423
    /**
424
     * Formatted and localized date and time the Job Poster closes.
425
     *
426
     * @return string[]
427
     */
428
    public function applyBy(): array
429
    {
430
        $localCloseDate = new Date($this->close_date_time); // This initializes the date object in UTC time.
431
        $localCloseDate->setTimezone(new \DateTimeZone(self::TIMEZONE)); // Then set the time zone for display.
432
        $displayDate = [
433
            'date' => $localCloseDate->format(self::DATE_FORMAT[App::getLocale()]),
434
            'time' => $localCloseDate->format(self::TIME_FORMAT[App::getLocale()])
435
        ];
436
437
        if (App::isLocale('fr')) {
438
            $displayDate['time'] = str_replace(['EST', 'EDT'], ['HNE', 'HAE'], $displayDate['time']);
439
        }
440
441
        return $displayDate;
442
    }
443
444
    /**
445
     * Return whether the Job is Open or Closed.
446
     * Used by the Admin Portal JobPosterCrudController.
447
     *
448
     * @return string
449
     */
450
    public function displayStatus(): string
451
    {
452
        return $this->isOpen() ? 'Open' : 'Closed';
453
    }
454
455
    /**
456
     * Check if a Job Poster is open for applications.
457
     *
458
     * @return boolean
459
     */
460
    public function isOpen(): bool
461
    {
462
        return $this->published
463
            && $this->open_date_time !== null
464
            && $this->close_date_time !== null
465
            && $this->open_date_time->isPast()
466
            && $this->close_date_time->isFuture();
467
    }
468
469
    /**
470
     * Check if a Job Poster is closed for applications.
471
     *
472
     * @return boolean
473
     */
474
    public function isClosed(): bool
475
    {
476
        return $this->published
477
            && $this->open_date_time !== null
478
            && $this->close_date_time !== null
479
            && $this->open_date_time->isPast()
480
            && $this->close_date_time->isPast();
481
    }
482
483
    /**
484
     * Calculate the remaining time a Job Poster is open.
485
     *
486
     * @return string
487
     */
488
    public function timeRemaining(): string
489
    {
490
        $interval = $this->close_date_time->diff(Date::now());
491
492
        $d = $interval->d;
493
        $h = $interval->h;
494
        $m = $interval->i;
495
        $s = $interval->s;
496
497
        if ($d > 0) {
498
            $unit = 'day';
499
            $count = $d;
500
        } elseif ($h > 0) {
501
            $unit = 'hour';
502
            $count = $h;
503
        } elseif ($m > 0) {
504
            $unit = 'minute';
505
            $count = $m;
506
        } else {
507
            $unit = 'second';
508
            $count = $s;
509
        }
510
511
        $key = "common/time.$unit";
512
513
        return Lang::choice($key, $count);
514
    }
515
516
    /**
517
     * Return the current status for the Job Poster.
518
     * Possible values are "draft", "submitted", "published" and "closed".
519
     *
520
     * @return string
521
     */
522
    public function status(): string
523
    {
524
        $status = 'draft';
525
        if ($this->isOpen()) {
526
            $status = 'published';
527
        } elseif ($this->isClosed()) {
528
            $status = 'closed';
529
        } elseif ($this->review_requested_at !== null) {
530
            $status = 'submitted';
531
        } else {
532
            $status = 'draft';
533
        }
534
535
        return $status;
536
    }
537
538
    /**
539
     * The database model stores a foreign id to the classification table,
540
     * but to simplify the API, this model simply returns the key as classification_code.
541
     *
542
     * @return string|null
543
     */
544
    public function getClassificationCodeAttribute()
0 ignored issues
show
introduced by
Method \App\Models\JobPoster::getClassificationCodeAttribute() does not have native return type hint for its return value but it should be possible to add it based on @return annotation "string|null".
Loading history...
545
    {
546
        if ($this->classification_id !== null) {
547
            return $this->classification->key;
548
        }
549
        return null;
550
    }
551
552
    /**
553
     *
554
     * Get the full government classification message.
555
     *
556
     * @return string|null
557
     */
558
    public function getClassificationMessageAttribute()
0 ignored issues
show
introduced by
Method \App\Models\JobPoster::getClassificationMessageAttribute() does not have native return type hint for its return value but it should be possible to add it based on @return annotation "string|null".
Loading history...
559
    {
560
        if ($this->classification_id !== null && $this->classification_level !== null) {
561
            return $this->classification->key . '-0' . $this->classification_level;
562
        }
563
        return null;
564
    }
565
566
    /**
567
     * Return the array of values used to represent this object in an api response.
568
     * This array should contain no nested objects (besides translations).
569
     *
570
     * @return mixed[]
571
     */
572
    public function toApiArray(): array
573
    {
574
        $jobWithTranslations = array_merge($this->toArray(), $this->getTranslationsArray());
575
        return $jobWithTranslations;
576
    }
577
}
578