72 lines
1.7 KiB
PHP
72 lines
1.7 KiB
PHP
<?php
|
|
|
|
namespace Modules\IndustrialEngineering\Models;
|
|
|
|
use Illuminate\Database\Eloquent\Model;
|
|
use Illuminate\Database\Eloquent\SoftDeletes;
|
|
|
|
class LineTemplate extends Model
|
|
{
|
|
use BelongsToBusiness;
|
|
use SoftDeletes;
|
|
|
|
protected $table = 'ie_line_templates';
|
|
|
|
protected $guarded = ['id'];
|
|
|
|
public function productPlatform()
|
|
{
|
|
return $this->belongsTo(ProductPlatform::class, 'product_platform_id');
|
|
}
|
|
|
|
public function parentTemplate()
|
|
{
|
|
return $this->belongsTo(LineTemplate::class, 'parent_template_id');
|
|
}
|
|
|
|
public function childTemplates()
|
|
{
|
|
return $this->hasMany(LineTemplate::class, 'parent_template_id')->orderBy('sort_order');
|
|
}
|
|
|
|
public function revisions()
|
|
{
|
|
return $this->hasMany(LineRevision::class, 'line_template_id');
|
|
}
|
|
|
|
public function latestRevision()
|
|
{
|
|
return $this->hasOne(LineRevision::class, 'line_template_id')->latestOfMany('id');
|
|
}
|
|
|
|
/**
|
|
* Latest MBOM for this production line (legacy alias: bom).
|
|
*/
|
|
public function bom()
|
|
{
|
|
return $this->hasOneThrough(
|
|
Bom::class,
|
|
LineRevision::class,
|
|
'line_template_id',
|
|
'line_revision_id',
|
|
'id',
|
|
'id'
|
|
)->where('ie_boms.bom_type', 'mbom');
|
|
}
|
|
|
|
public function maintenanceEquipment()
|
|
{
|
|
return $this->belongsTo(\Modules\Maintenance\Models\Equipment::class, 'maintenance_equipment_id');
|
|
}
|
|
|
|
public function scopeProductionLines($query)
|
|
{
|
|
return $query->where('line_type', 'production_line')->whereNull('parent_template_id');
|
|
}
|
|
|
|
public function effectiveCode(): string
|
|
{
|
|
return $this->template_code ?: ($this->auto_code ?? '');
|
|
}
|
|
}
|