<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;
use Carbon\Carbon;

class Chat extends Model
{
    use HasFactory;

    protected $fillable = [
        'user_id',
        'to_user_id',
        'is_removed',
        'is_fixed',
        'last_message_date',
        'last_message_id',
        'fixed_time'
    ];

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

    public function worker() {
        return $this->belongsTo(Worker::class, 'to_user_id', 'user_id');
    }

    public function employer() {
        return $this->belongsTo(Employer::class, 'to_user_id', 'user_id');
    }

    public function last_message() {
        return $this->belongsTo(Message::class, 'last_message_id');
    }

    public function unread_messages()
    {
        return $this->hasMany(Message::class, 'user_id', 'to_user_id');
    }

    public static function pin_chat(int $chat_id, $fixed)
    {
        return self::where('id', '=', $chat_id)
            ->update([
                'is_fixed' => !empty($fixed) ? 1 : 0,
                'fixation_date' => !empty($fixed) ? Carbon::now() : null
            ]);
    }

    public static function remove_chat(int $chat_id)
    {
        return self::where('id', '=', $chat_id)
            ->update(['is_removed' => 1]);
    }

    public static function get_user_chats(int $user_id){
        return Chat::query()
            ->with('user')
            ->with('worker')
            ->with('employer')
            ->with('last_message')
            ->withCount(['unread_messages' => function ($query) use($user_id) {
                $query->where('to_user_id', '=', $user_id)->where('flag_new', '=', 1);
            }])
            ->where('user_id', '=', $user_id)
            ->where('is_removed', '=', 0)
            ->orderByDesc('is_fixed')
            ->orderByDesc('fixation_date')
            ->orderByDesc('last_message_date')
            ->paginate(5)
        ;
    }

}