<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;

class StatTree extends Model
{

    protected $table = 'stat_tree';
    public $timestamps = false;

    public function getRouteKeyName()
    {
        return 'uid';
    }

    public function pro(){
        return $this->hasOne(Pro::class, 'id', 'pro_id');
    }

    public function lines(){
        return $this->hasMany(StatTreeLine::class, 'stat_tree_id', 'id')->orderBy('id', 'ASC');
    }

    public function rootLines(){
        return $this->hasMany(StatTreeLine::class, 'stat_tree_id', 'id')->whereNull('parent_stat_tree_line_id')->orderBy('tree_order_position_index', 'ASC');
    }
}