<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;
use Awobaz\Compoships\Compoships;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Log;
use Illuminate\Support\Facades\Storage;

class ItemVariant extends Model
{
    use HasFactory;
    
    use Compoships;

    protected $table = 'item_variants';
    protected $primaryKey = 'id';

    protected $fillable = [
        'id',
        'code',
        'description',
        'item_id',
        'display_name',
        'is_publish',
        'barcode',
        'variant_name',
    ];

    public function reference()
    {
        return $this->belongsTo(ItemReference::class, ["item_id", "id"], ["item_id", "item_variant_id"]);
    }


    public function variables()
    {
        return $this->belongsToMany(Variant::class, "variant_value")->select("id", "name", "value");
    }

    public function image()
    {
        return $this->hasOne(ItemImage::class)->where('item_id', $this->item_id);
    }

    public function images()
    {
        return $this->hasMany(ItemImage::class)->where('item_id', $this->item_id);
    }
     public function variantValue()
    {
        return $this->hasMany(\App\Models\VariantValue::class, 'item_variant_id');
    }

       public function getImageUrlAttribute()
    {
        $image = $this->images->first()->filename ?? null;


        if (str_contains($image,"http")) {
            return $image;
        }

        return $image ? Storage::disk('wms')->url($image) : null;
    }

    public function item()
    {
        return $this->belongsTo(Items::class, 'item_id');
    }

    public function conversion_value()
    {
        $item = $this->item;

        $convertion = 1;
        if (($item->display_unit != $item->unit) and ($item->display_unit)){
           $convertions =  DB::select("select to_qty / from_qty as conv
           from item_convertions where from_unit = ? and to_unit =  ?",
           [$item->display_unit, $item->unit] );
           $convertion = max((float) @$convertions[0]->conv,1);
        }

        return $convertion;
    }


    public function getDisplayPriceAttribute()
    {
        try {
            $convertion = $this->conversion_value();

            $price = $this->reference->price->price ?? null;
            $price = $price ? $price : $this->item->net_price;


            return (float) $price * $convertion;
        } catch (\Exception $e) {
            Log::info($e);
            return 0;
        }
    }

      public function getDisplayDiscountPriceAttribute()
    {
        try {
            $convertion = $this->conversion_value();

            $discountPrice = @$this->discount->price ?? 0;
            return (float) $discountPrice * $convertion;
        } catch (\Exception $e) {
            return 0;
        }
    }


}