Files
sam-manage/app/Models/Equipment/EquipmentInspectionTemplate.php
김보곤 c84c8894be feat: [database] Equipment 하위 4개 모델 codebridge connection 추가
- EquipmentInspection, EquipmentInspectionDetail, EquipmentInspectionTemplate, EquipmentRepair
- equipments 테이블과 FK 참조 관계 → 동일 DB(codebridge)에서 관리
2026-03-09 20:57:49 +09:00

56 lines
1.2 KiB
PHP

<?php
namespace App\Models\Equipment;
use App\Traits\BelongsToTenant;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\Relations\BelongsTo;
class EquipmentInspectionTemplate extends Model
{
protected $connection = 'codebridge';
use BelongsToTenant;
protected $fillable = [
'tenant_id',
'equipment_id',
'inspection_cycle',
'item_no',
'check_point',
'check_item',
'check_timing',
'check_frequency',
'check_method',
'sort_order',
'is_active',
];
protected $casts = [
'is_active' => 'boolean',
];
public function equipment(): BelongsTo
{
return $this->belongsTo(Equipment::class, 'equipment_id');
}
public function scopeActive($query)
{
return $query->where('is_active', true);
}
public function scopeByCycle($query, string $cycle)
{
return $query->where('inspection_cycle', $cycle);
}
public function getTimingLabelAttribute(): string
{
return match ($this->check_timing) {
'operating' => '가동 중',
'stopped' => '정지 시',
default => $this->check_timing ?? '-',
};
}
}