106 lines
2.9 KiB
PHP
106 lines
2.9 KiB
PHP
<?php
|
|
|
|
namespace App\Models;
|
|
|
|
use App\Enums\CooperationStatus;
|
|
use Illuminate\Database\Eloquent\Attributes\Scope;
|
|
use Illuminate\Database\Eloquent\Builder;
|
|
use Illuminate\Database\Eloquent\Factories\HasFactory;
|
|
use Illuminate\Database\Eloquent\Model;
|
|
use Illuminate\Database\Eloquent\Relations\BelongsToMany;
|
|
use Illuminate\Database\Eloquent\Relations\HasMany;
|
|
use Illuminate\Database\Eloquent\Relations\HasManyThrough;
|
|
use Illuminate\Database\Eloquent\Relations\HasOne;
|
|
use Illuminate\Database\Eloquent\SoftDeletes;
|
|
use Spatie\MediaLibrary\HasMedia;
|
|
use Spatie\MediaLibrary\InteractsWithMedia;
|
|
use Staudenmeir\EloquentHasManyDeep\HasManyDeep;
|
|
use Staudenmeir\EloquentHasManyDeep\HasRelationships;
|
|
use Swindon\FilamentHashids\Traits\HasHashid;
|
|
|
|
class Cooperation extends Model implements HasMedia
|
|
{
|
|
use HasFactory, HasHashid, HasRelationships, InteractsWithMedia, SoftDeletes;
|
|
|
|
protected $guarded = ['id'];
|
|
|
|
protected function casts(): array
|
|
{
|
|
return [
|
|
'initial_submission_date' => 'date',
|
|
'final_submission_date' => 'date',
|
|
'payment_amount' => 'integer',
|
|
'payment_date' => 'date',
|
|
'completed_at' => 'date',
|
|
'status' => CooperationStatus::class,
|
|
];
|
|
}
|
|
|
|
#[Scope]
|
|
protected function pending(Builder $query): void
|
|
{
|
|
$query->where('status', CooperationStatus::PENDING);
|
|
}
|
|
|
|
#[Scope]
|
|
protected function assignment(Builder $query): void
|
|
{
|
|
$query->where('status', CooperationStatus::ASSIGNMENT);
|
|
}
|
|
|
|
#[Scope]
|
|
protected function payment(Builder $query): void
|
|
{
|
|
$query->where('status', CooperationStatus::PAYMENT);
|
|
}
|
|
|
|
#[Scope]
|
|
protected function completed(Builder $query): void
|
|
{
|
|
$query->where('status', CooperationStatus::COMPLETED);
|
|
}
|
|
|
|
public function cooperationMedia(): HasMany
|
|
{
|
|
return $this->hasMany(CooperationMedia::class);
|
|
}
|
|
|
|
public function partnerMedia(): BelongsToMany
|
|
{
|
|
return $this->belongsToMany(PartnerMedia::class, 'cooperation_media')
|
|
->using(CooperationMedia::class)
|
|
->withPivot(['status'])
|
|
->withTimestamps();
|
|
}
|
|
|
|
public function payments(): HasManyThrough
|
|
{
|
|
return $this->hasManyThrough(
|
|
CooperationPayment::class,
|
|
CooperationMedia::class,
|
|
'cooperation_id',
|
|
'cooperation_media_id'
|
|
);
|
|
}
|
|
|
|
public function proposal(): HasMany
|
|
{
|
|
return $this->hasMany(CooperationProposal::class);
|
|
}
|
|
|
|
public function reports(): HasManyDeep
|
|
{
|
|
return $this->hasManyDeep(
|
|
Report::class,
|
|
[TaskAssignment::class, MediaTaskAssignment::class],
|
|
['cooperation_id', 'task_assignment_id', 'media_task_assignment_id'],
|
|
['id', 'id', 'id']
|
|
);
|
|
}
|
|
|
|
public function taskAssignment(): HasOne
|
|
{
|
|
return $this->hasOne(TaskAssignment::class);
|
|
}
|
|
}
|