<?php

namespace App\Models;

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

class MessagesRequests extends Model
{
    use HasFactory;

    protected $fillable = [
        'user_id',
        'job_titles',
        'text',
        'is_rejected',
        'is_sent'
    ];

    public function getJobsAttribute()
    {
        $job_titles_ids = json_decode($this->attributes['job_titles'], true);
        return Job_title::whereIn('id', $job_titles_ids)->get();
    }

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

    public static function send_message($message_request_id)
    {
        $message_request = MessagesRequests::find($message_request_id);
        $job_ids = json_decode($message_request->job_titles);

        if (!empty($job_ids)){
            $workers = Title_worker::select('worker_id')
                ->whereIN('job_title_id', $job_ids)
                ->groupBy('worker_id')
                ->get()
            ;

            if ($workers->count()){
                $message_params = [
                    'text' => $message_request->text
                ];
                foreach ($workers as $worker){
                    Message::add_message(null, $message_request->user_id, $worker->worker_id, $message_params, file_store_path : '/', is_admin_chat: true);
                }
            }
        }

        $message_request->update(['is_sent' => now()]);

        return true;
    }
}