<?php

namespace App\Models\Ekosistem;

use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\SoftDeletes;
use Illuminate\Database\Eloquent\Relations\HasMany;
use Illuminate\Database\Eloquent\Builder;
use Illuminate\Database\Eloquent\Relations\BelongsTo;
use Illuminate\Database\Eloquent\Relations\HasOne;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Casts\Attribute;

use App\Models\Ekosistem\KolomBasisData;
use App\Models\Ekosistem\GroupBasisData;
use App\Models\Ekosistem\RingkasanBasisData;
use App\Models\Ekosistem\FormBasisData;

class TabelBasisData extends Model
{
    use SoftDeletes;

    protected $table = 'ekosistem_basis_data_tabel';

    protected $fillable = [
        'tabel',
        'label',
        'menu',
        'deskripsi',
        'group_id',
        'urutan'

    ];

    protected static function booted()
    {
        static::creating(function ($model) {
            $max = self::where('group_id', $model->group_id)->max('urutan');
            $model->urutan = ($max ?? 0) + 1;
        });
        static::addGlobalScope('order', function (Builder $builder) {
            $builder->orderBy('urutan');
        });
    }

    public function kolom(): HasMany
    {
        return $this->hasMany(KolomBasisData::class, 'tabel_id')->orderBy('urutan');
    }

    public function group(): BelongsTo
    {
        return $this->belongsTo(GroupBasisData::class, 'group_id');
    }

    public function ringkasan(): HasMany
    {
        return $this->hasMany(RingkasanBasisData::class, 'tabel_id')->orderBy('urutan');
    }

    public function form(): HasMany
    {
        return $this->hasMany(FormBasisData::class, 'tabel_id')
            ->whereNull('parent_id')
            ->orderBy('urutan');
    }

    public function renderHtml(string $state, $errors = null, $optionsFK = null, $values = null): string 
    {
        $html = '';
        foreach ($this->form as $form) {
            $html .= $form->renderHtml($state, $errors, $optionsFK, $values);
        }
        return $html;
    }
}