140 lines
3.9 KiB
PHP
140 lines
3.9 KiB
PHP
<?php
|
|
|
|
namespace App\Models;
|
|
|
|
use App\Tenancy\HasTenant;
|
|
use Carbon\Carbon;
|
|
use Illuminate\Database\Eloquent\Factories\HasFactory;
|
|
use Illuminate\Database\Eloquent\Model;
|
|
use Illuminate\Database\Eloquent\Relations\BelongsTo;
|
|
use Illuminate\Database\Eloquent\Relations\HasMany;
|
|
use Illuminate\Database\Eloquent\SoftDeletes;
|
|
use Illuminate\Support\Str;
|
|
use Spatie\Activitylog\LogOptions;
|
|
use Spatie\Activitylog\Traits\LogsActivity;
|
|
|
|
class Trip extends Model
|
|
{
|
|
use HasFactory, HasTenant, LogsActivity, SoftDeletes;
|
|
|
|
public const STATUS_SCHEDULED = 'scheduled';
|
|
|
|
public const STATUS_IN_PROGRESS = 'in_progress';
|
|
|
|
public const STATUS_AT_DUMPSITE = 'at_dumpsite';
|
|
|
|
public const STATUS_COMPLETED = 'completed';
|
|
|
|
public const STATUS_HANDED_OFF = 'handed_off';
|
|
|
|
public const STATUS_CANCELLED = 'cancelled';
|
|
|
|
protected $fillable = [
|
|
'uuid', 'tenant_id', 'trip_number', 'route_id', 'team_id', 'truck_id', 'dumpsite_id',
|
|
'scheduled_date', 'scheduled_start_time',
|
|
'actual_start_time', 'actual_end_time',
|
|
'dumpsite_arrival_time', 'dumpsite_departure_time',
|
|
'status', 'is_detouring', 'total_load_kg', 'current_load_kg', 'notes',
|
|
'created_by_admin_id', 'parent_trip_id', 'end_reason',
|
|
];
|
|
|
|
protected function casts(): array
|
|
{
|
|
return [
|
|
'scheduled_date' => 'date',
|
|
'actual_start_time' => 'datetime',
|
|
'actual_end_time' => 'datetime',
|
|
'dumpsite_arrival_time' => 'datetime',
|
|
'dumpsite_departure_time' => 'datetime',
|
|
'is_detouring' => 'boolean',
|
|
'current_load_kg' => 'integer',
|
|
];
|
|
}
|
|
|
|
public function getRouteKeyName(): string
|
|
{
|
|
return 'uuid';
|
|
}
|
|
|
|
public function getActivitylogOptions(): LogOptions
|
|
{
|
|
return LogOptions::defaults()
|
|
->logOnly(['status', 'team_id', 'truck_id', 'scheduled_date', 'total_load_kg'])
|
|
->logOnlyDirty()
|
|
->dontSubmitEmptyLogs()
|
|
->useLogName('trip');
|
|
}
|
|
|
|
protected static function booted(): void
|
|
{
|
|
static::creating(function (self $t): void {
|
|
if (empty($t->uuid)) {
|
|
$t->uuid = (string) Str::uuid();
|
|
}
|
|
if (empty($t->tenant_id)) {
|
|
if ($t->team_id) {
|
|
$t->tenant_id = $t->team?->tenant_id;
|
|
}
|
|
if (empty($t->tenant_id) && $t->route_id) {
|
|
$t->tenant_id = $t->route?->tenant_id;
|
|
}
|
|
}
|
|
if (empty($t->trip_number)) {
|
|
$date = ($t->scheduled_date ? Carbon::parse($t->scheduled_date) : now())->format('Ymd');
|
|
$seq = self::where('trip_number', 'like', "TRIP-{$date}-%")->count() + 1;
|
|
$t->trip_number = sprintf('TRIP-%s-%03d', $date, $seq);
|
|
}
|
|
});
|
|
}
|
|
|
|
public function route(): BelongsTo
|
|
{
|
|
return $this->belongsTo(Route::class);
|
|
}
|
|
|
|
public function team(): BelongsTo
|
|
{
|
|
return $this->belongsTo(CollectionTeam::class, 'team_id');
|
|
}
|
|
|
|
public function truck(): BelongsTo
|
|
{
|
|
return $this->belongsTo(Truck::class);
|
|
}
|
|
|
|
public function dumpsite(): BelongsTo
|
|
{
|
|
return $this->belongsTo(Dumpsite::class);
|
|
}
|
|
|
|
public function stops(): HasMany
|
|
{
|
|
return $this->hasMany(TripStop::class)->orderBy('sequence');
|
|
}
|
|
|
|
public function timelineEvents(): HasMany
|
|
{
|
|
return $this->hasMany(TripTimelineEvent::class)->orderBy('event_at');
|
|
}
|
|
|
|
public function dumpsiteReleases(): HasMany
|
|
{
|
|
return $this->hasMany(DumpsiteRelease::class);
|
|
}
|
|
|
|
public function collectionLogs(): HasMany
|
|
{
|
|
return $this->hasMany(CollectionLog::class, 'trip_id');
|
|
}
|
|
|
|
public function parentTrip(): BelongsTo
|
|
{
|
|
return $this->belongsTo(Trip::class, 'parent_trip_id');
|
|
}
|
|
|
|
public function continuationTrips(): HasMany
|
|
{
|
|
return $this->hasMany(Trip::class, 'parent_trip_id');
|
|
}
|
|
}
|