<?php

namespace Webkul\Attribute\Models;

use Illuminate\Database\Eloquent\Factories\Factory;
use Illuminate\Database\Eloquent\Model;
use Webkul\Product\Models\ProductProxy;
use Illuminate\Database\Eloquent\Relations\HasMany;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Webkul\Attribute\Database\Factories\AttributeFamilyFactory;
use Webkul\Attribute\Contracts\AttributeFamily as AttributeFamilyContract;

class AttributeFamily extends Model implements AttributeFamilyContract
{
    use HasFactory;

    public $timestamps = false;

    protected $fillable = [
        'code',
        'name',
    ];

    /**
     * Get all the attributes for the attribute groups.
     */
    public function custom_attributes()
    {
        return (AttributeProxy::modelClass())::join('attribute_group_mappings', 'attributes.id', '=', 'attribute_group_mappings.attribute_id')
                                             ->join('attribute_groups', 'attribute_group_mappings.attribute_group_id', '=', 'attribute_groups.id')
                                             ->join('attribute_families', 'attribute_groups.attribute_family_id', '=', 'attribute_families.id')
                                             ->where('attribute_families.id', $this->id)
                                             ->select('attributes.*');
    }


    /**
     * Get all the comparable attributes which belongs to attribute family.
     */
    public function getComparableAttributesBelongsToFamily()
    {
        return (AttributeProxy::modelClass())::join('attribute_group_mappings', 'attribute_group_mappings.attribute_id', '=', 'attributes.id')
                                             ->select('attributes.*')
                                             ->where('attributes.is_comparable', 1)
                                             ->distinct()
                                             ->get();
    }

    /**
     * Get all the attributes for the attribute groups.
     */
    public function getCustomAttributesAttribute()
    {
        return $this->custom_attributes()
                    ->get();
    }

    /**
     * Get all the attribute groups.
     */
    public function attribute_groups(): HasMany
    {
        return $this->hasMany(AttributeGroupProxy::modelClass())
                    ->orderBy('position');
    }

    /**
     * Get all the attributes for the attribute groups.
     */
    public function getConfigurableAttributesAttribute()
    {
        return $this->custom_attributes()
                    ->where('attributes.is_configurable', 1)
                    ->where('attributes.type', 'select')
                    ->get();
    }

    /**
     * Get all the products.
     */
    public function products(): HasMany
    {
        return $this->hasMany(ProductProxy::modelClass());
    }

    /**
     * Create a new factory instance for the model
     *
     * @return Factory
     */
    protected static function newFactory(): Factory
    {
        return AttributeFamilyFactory::new();
    }
}