* 391 Notification refactorings (#441) * Refactor notifications to allow easier plugins * Notification refactoring * Formatting * Move news to NewsService; cleanup of events * More refactoring; added send email out for news item and the template * Formatting * Formatting * Fix missing newsRepo (#445) * Refactor and add importer to Installer module #443 (#444) * Refactor and add importer to Installer module #443 * Refactor for finances to use in import * Import groups into roles * Formatting * Formatting * Add interface in installer for import * Notes about importing * Check for installer folder * Formatting * Fix pirep->user mapping * Unused import * Formatting * Replace importer with AJAX powered; better error handling #443 (#447) * Replace importer with AJAX powered; better error handling #443 * Formatting * Fix command line importer * Remove bootstrap cache (#448) * Cleanup the bootstrap/cache directory when packaging * Fix removal of bootstrap cache * Formatting * Stricter checks on ACARS API data (#451) * Stricter checks on ACARS API data * More checks * Fix for flight_number check forcing to exist * Allow nullable on flight_id * Avoid proc_open use #455 (#456) * Use PhpExecutableFinder() closes #457 #458 (#460) * Use DateTimeZone instead of int for creating datetime closes #461 * Fix CSV imports giving Storage class not found #454 (#462) * Fix CSV imports giving Storage class not found #454 * Update yarn files for security alert * Add PHP 7.4 support (#464) * Add PHP 7.4 to build matrix * DB fix * YAML parser fix in test data * Show versions * Package updates * Track used ICAOs * 7.4 METAR parsing fix * METAR parser fix * Formatting * Add meters to response units * Call instance for unit conversion * Return value * Catch exception for unknown quantity * Comment fix * Formatting * METAR parsing fixes on PHP 7.4 * Package updates * More random airport ID * More random airport ID * Properly disable toolbar * Semver written out to version file * Use dev as default identifier * Fix BindingResolutionError when debug toolbar isn't present (#465) * Fix BindingResolutionError when debug toolbar isn't present * Formatting * Split the importer module out from the installer module (#468) * Split the importer module out from the installer module * Cleanup of unused imports * Move updater into separate module #453 * Remove unused imports/formatting * Disable the install and importer modules at the end of the setup * Unused imports; update IJ style * test explicit stage for php+mysql * add more to matrix * Add different MariaDB versions * undo * Cleanup Model doc * Pilots cannot use the dashboard or flights without admin rights (#481) * Use auth middleware instead of specific groups for logged in state * Auth check for admin access * Check user admin access for updates * Formatting * Allow nullable field and calculate distance if nulled for flight import #478 (#482) * Check for no roles being attached #480 (#483) * Return the flight fares if there are no subfleet fares #488 (#489) * Return the flight fares if there are no subfleet fares #488 * Formatting * Formatting * Account for units when entering fuel amounts #493 * Search for ICAO not working properly (#496) * /flights and /flights/search direct to the same endpoint * Properly set the distance/planned_distance on save (#497) * 491 Installation Error (#495) * Disable CSRF token * Add error handling around looking up the theme and set a default * Note about logs in issue template * Formatting * Fix GeoService errors when viewing PIREP #498 (#499) * Add new command to export a specific PIREP for debugging (#501) * Set a default model value for airports on PIREP (#500) * Set a default model value for airports on PIREP * Fix airport icao reference * Default airport models * Catch broader exception writing out config files #491 * style * Add reference to docs on doc site (#502) * Properly create/update rows importing #486 (#503) * Add base Dockerfile for Dockerhub builds (#504) * New subfleet not being attached to an airline on import #479 (#505) * Fix subfleet not being attached to an airline on creation in import #479 * Call airline name with optional() around subfleet * Minor cleanup * Search flights by subfleet #484 (#506) * API level search of flights #484 * Add Subfleet to flights page for search * Make the fuel used optional (#512) * Add make to Docker container * Add getRootDomain() to Utils (#514) * Show admin dropdown for admin-access ability (#515) * Show admin dropdown for admin-access ability closes #509 * Formatting * Check user permissions on the routes #508 (#516) * Check user permissions on the routes #508 * Formatting * Return default value on exception for setting() * Correct text for no subfleets #507 (#518) * Add a public_url() helper #513 (#519) * Reduce number of queries for update check (#520) * Try to clear caches before updating (#522) * Try to clear caches before updating * Add clear-compiled to maintenance cache list * Formatting * Set PIREPs page to public (#526) Set PIREPs page to public * Fix live and route map errors #527 (#528) * Add menu bar for mobile (#529) * Format all blade templates to 2 spaces #530 (#531) * Fix PIREP edit endpoint closes #533 (#534) * Fix import during flight cron #532 (#535) * PIREPS resource except for show (#536) * Use optional() around the airport fields (#537) * Use optional() around the airport fields * Add null-coalesce around full_name * Add link to download ACARS config from profile (#539) * Add link to download ACARS config from profile * Formatting * Update xml config file template (#540)
236 lines
5.6 KiB
PHP
236 lines
5.6 KiB
PHP
<?php
|
|
|
|
namespace App\Models;
|
|
|
|
use App\Contracts\Model;
|
|
use App\Models\Enums\Days;
|
|
use App\Models\Traits\HashIdTrait;
|
|
use App\Support\Units\Distance;
|
|
use Carbon\Carbon;
|
|
use Illuminate\Support\Collection;
|
|
|
|
/**
|
|
* @property string id
|
|
* @property mixed ident
|
|
* @property Airline airline
|
|
* @property int airline_id
|
|
* @property mixed flight_number
|
|
* @property mixed route_code
|
|
* @property int route_leg
|
|
* @property bool has_bid
|
|
* @property Collection field_values
|
|
* @property Collection fares
|
|
* @property Collection subfleets
|
|
* @property int days
|
|
* @property int distance
|
|
* @property int flight_time
|
|
* @property string route
|
|
* @property int level
|
|
* @property Airport dpt_airport
|
|
* @property Airport arr_airport
|
|
* @property Airport alt_airport
|
|
* @property string dpt_airport_id
|
|
* @property string arr_airport_id
|
|
* @property string alt_airport_id
|
|
* @property int active
|
|
* @property Carbon start_date
|
|
* @property Carbon end_date
|
|
*/
|
|
class Flight extends Model
|
|
{
|
|
use HashIdTrait;
|
|
|
|
public $table = 'flights';
|
|
|
|
/** The form wants this */
|
|
public $hours;
|
|
public $minutes;
|
|
|
|
protected $keyType = 'string';
|
|
public $incrementing = false;
|
|
|
|
protected $fillable = [
|
|
'id',
|
|
'airline_id',
|
|
'flight_number',
|
|
'route_code',
|
|
'route_leg',
|
|
'dpt_airport_id',
|
|
'arr_airport_id',
|
|
'alt_airport_id',
|
|
'dpt_time',
|
|
'arr_time',
|
|
'days',
|
|
'level',
|
|
'distance',
|
|
'flight_time',
|
|
'flight_type',
|
|
'route',
|
|
'notes',
|
|
'start_date',
|
|
'end_date',
|
|
'has_bid',
|
|
'active',
|
|
'visible',
|
|
];
|
|
|
|
protected $casts = [
|
|
'flight_number' => 'integer',
|
|
'days' => 'integer',
|
|
'level' => 'integer',
|
|
'distance' => 'float',
|
|
'flight_time' => 'integer',
|
|
'start_date' => 'date',
|
|
'end_date' => 'date',
|
|
'has_bid' => 'boolean',
|
|
'route_leg' => 'integer',
|
|
'active' => 'boolean',
|
|
'visible' => 'boolean',
|
|
];
|
|
|
|
public static $rules = [
|
|
'airline_id' => 'required|exists:airlines,id',
|
|
'flight_number' => 'required',
|
|
'route_code' => 'nullable',
|
|
'route_leg' => 'nullable',
|
|
'dpt_airport_id' => 'required|size:4|exists:airports,id',
|
|
'arr_airport_id' => 'required|size:4|exists:airports,id',
|
|
'level' => 'nullable',
|
|
];
|
|
|
|
/**
|
|
* Return all of the flights on any given day(s) of the week
|
|
* Search using bitmasks
|
|
*
|
|
* @param Days[] $days List of the enumerated values
|
|
*
|
|
* @return Flight
|
|
*/
|
|
public static function findByDays(array $days)
|
|
{
|
|
/** @noinspection DynamicInvocationViaScopeResolutionInspection */
|
|
$flights = self::where('active', true);
|
|
foreach ($days as $day) {
|
|
$flights = $flights->where('days', '&', $day);
|
|
}
|
|
|
|
return $flights;
|
|
}
|
|
|
|
/**
|
|
* Get the flight ident, e.,g JBU1900
|
|
*/
|
|
public function getIdentAttribute(): string
|
|
{
|
|
$flight_id = $this->airline->code;
|
|
$flight_id .= $this->flight_number;
|
|
|
|
if (filled($this->route_code)) {
|
|
$flight_id .= '-'.$this->route_code;
|
|
}
|
|
|
|
if (filled($this->route_leg)) {
|
|
$flight_id .= '-'.$this->route_leg;
|
|
}
|
|
|
|
return $flight_id;
|
|
}
|
|
|
|
/**
|
|
* Set the distance unit, convert to our internal default unit
|
|
*
|
|
* @param $value
|
|
*/
|
|
public function setDistanceAttribute($value): void
|
|
{
|
|
if ($value instanceof Distance) {
|
|
$this->attributes['distance'] = $value->toUnit(
|
|
config('phpvms.internal_units.distance')
|
|
);
|
|
} else {
|
|
$this->attributes['distance'] = $value;
|
|
}
|
|
}
|
|
|
|
/**
|
|
* @param $day
|
|
*
|
|
* @return bool
|
|
*/
|
|
public function on_day($day): bool
|
|
{
|
|
return ($this->days & $day) === $day;
|
|
}
|
|
|
|
/**
|
|
* Return a custom field value
|
|
*
|
|
* @param $field_name
|
|
*
|
|
* @return string
|
|
*/
|
|
public function field($field_name): string
|
|
{
|
|
$field = $this->field_values->where('name', $field_name)->first();
|
|
if ($field) {
|
|
return $field['value'];
|
|
}
|
|
|
|
return '';
|
|
}
|
|
|
|
/**
|
|
* Set the days parameter. If an array is passed, it's
|
|
* AND'd together to create the mask value
|
|
*
|
|
* @param array|int $val
|
|
*/
|
|
public function setDaysAttribute($val): void
|
|
{
|
|
if (\is_array($val)) {
|
|
$val = Days::getDaysMask($val);
|
|
}
|
|
|
|
$this->attributes['days'] = $val;
|
|
}
|
|
|
|
/**
|
|
* Relationship
|
|
*/
|
|
public function airline()
|
|
{
|
|
return $this->belongsTo(Airline::class, 'airline_id');
|
|
}
|
|
|
|
public function dpt_airport()
|
|
{
|
|
return $this->belongsTo(Airport::class, 'dpt_airport_id');
|
|
}
|
|
|
|
public function arr_airport()
|
|
{
|
|
return $this->belongsTo(Airport::class, 'arr_airport_id');
|
|
}
|
|
|
|
public function alt_airport()
|
|
{
|
|
return $this->belongsTo(Airport::class, 'alt_airport_id');
|
|
}
|
|
|
|
public function fares()
|
|
{
|
|
return $this->belongsToMany(Fare::class, 'flight_fare')
|
|
->withPivot('price', 'cost', 'capacity');
|
|
}
|
|
|
|
public function field_values()
|
|
{
|
|
return $this->hasMany(FlightFieldValue::class, 'flight_id');
|
|
}
|
|
|
|
public function subfleets()
|
|
{
|
|
return $this->belongsToMany(Subfleet::class, 'flight_subfleet');
|
|
}
|
|
}
|