<?php

namespace App\Models;

use App\Models\Dictionary\Area;
use App\Models\Dictionary\District;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\Relations\BelongsTo;
use Illuminate\Database\Eloquent\Relations\BelongsToMany;
use Illuminate\Support\Facades\DB;

class Order extends Model
{
    const DEFAULT_SORT_BY = 'created_at';

    protected $fillable = [
        'user_id',
        'district_id',
        'area_id',
        'object_address',
        'object_type_id',
        'contract_date',
        'contract_number',
        'comment',
        'installation_date',
        'brigadier_id',
        'order_status_id',
        'tg_group_name',
        'tg_group_link',
    ];

    /**
     * @return BelongsToMany
     */
    public function products(): BelongsToMany
    {
        return $this->belongsToMany(Product::class, 'order_product', 'order_id', 'product_id');
    }

    public function user(): BelongsTo
    {
        return $this->belongsTo(User::class, 'user_id', 'id');
    }

    public function district(): BelongsTo
    {
        return $this->belongsTo(District::class);
    }

    public function area(): BelongsTo
    {
        return $this->belongsTo(Area::class);
    }

    public function objectType(): BelongsTo
    {
        return $this->belongsTo(ObjectType::class);
    }

    public function brigadier(): BelongsTo
    {
        return $this->belongsTo(Brigadier::class);
    }

    public function orderStatus(): BelongsTo
    {
        return $this->belongsTo(OrderStatus::class);
    }
}