<?php

namespace FluentBooking\App\Models;

use FluentBooking\App\Models\Model;

class User extends Model
{
    protected $table = 'users';

    protected $guarded = ['ID', 'user_pass', 'user_activation_key'];

    protected $hidden = ['user_pass', 'user_activation_key'];

    protected $appends = ['full_name'];

    protected $primaryKey = 'ID';

    /**
     * @return \FluentBooking\Framework\Database\Orm\Relations\HasMany
     */
    public function calendars()
    {
        return $this->hasMany(Calendar::class, 'user_id');
    }

    /**
     * @return \FluentBooking\Framework\Database\Orm\Relations\BelongsToMany
     */
    public function bookings()
    {
        return $this->belongsToMany(CalendarSlot::class, 'fcal_booking_hosts', 'user_id', 'booking_id')
            ->withPivot('status');
    }

    public function user() {
        return get_user_by('ID', $this->ID);
    }

    public function getFullNameAttribute() {
        $user = $this->user();
        $name =  trim($user->first_name . ' ' . $user->last_name);
        if(!$name) {
            $name = $user->display_name;
        }
        return $name;
    }

    public function staff() {
        return $this->hasOne(Staff::class, 'object_id');
    }

    public function metas()
    {
        return $this->hasMany(Meta::class, 'object_id', 'ID')
            ->where('object_type', 'user_meta');
    }

    public function getMeta($key, $default = null)
    {
        if ($this->relationLoaded('metas')) {
            $meta = $this->metas->firstWhere('key', $key);
        } else {
            $meta = Meta::where('object_type', 'user_meta')
                ->where('object_id', $this->ID)
                ->where('key', $key)
                ->first();
        }

        if (!$meta) {
            return $default;
        }

        return $meta->value;
    }

    public function updateMeta($key, $value)
    {
        $exist = Meta::where('object_type', 'user_meta')
            ->where('object_id', $this->ID)
            ->where('key', $key)
            ->first();

        if ($exist) {
            $exist->value = $value;
            $exist->save();
        } else {
            $exist = Meta::create([
                'object_type' => 'user_meta',
                'object_id'   => $this->ID,
                'key'         => $key,
                'value'       => $value
            ]);
        }

        return $exist;
    }
}