<?php

namespace App\Models;

use Carbon\Carbon;
use Illuminate\Database\Eloquent\Model;
use Rmunate\Utilities\SpellNumber;

class EventOrganiser extends Model
{
    protected $table = 'event_organisers';

    protected $with = ['media'];

    protected $guarded = [];

    // protected $appends = ['amount_in_letter', 'cgst_value', 'sgst_value', 'taxable_value'];

    public function getCreatedAtAttribute($value) {
        return Carbon::parse($value)->format('d-m-Y');
    }

    public function getAmountInLetterAttribute() {
        return SpellNumber::value($this->Amount)->locale('en')->toLetters();
    }

    public function getCGSTValueAttribute() {
        return round(($this->Amount*9)/100, 2);
    }

    public function getSGSTValueAttribute() {
        return round(($this->Amount*9)/100, 2);
    }

    public function getTaxableValueAttribute() {
        return $this->Amount - round(($this->Amount*18)/100, 2);
    }

    public function media() {
        return $this->hasOneThrough(
            Media::class,
            MediaMorph::class,
            'related_id',
            'id',
            'id',
            'upload_file_id'
        )
            ->where('related_type', 'event_organisers')
            ->where('field', 'Attachment')
            ->orderBy('order')
            ->select('upload_file_morph.id', 'name', 'url', 'formats');
    }
}