<?php
  
  namespace App\Models;
  
  use Illuminate\Database\Eloquent\Factories\HasFactory;
  use Illuminate\Database\Eloquent\Model;

  use Illuminate\Http\Request;
  use Illuminate\Support\Facades\Validator;

  use mysql_xdevapi\Collection;

  
  class Message extends Model
  {
      use HasFactory;

      protected $fillable = [
          'user_id',
          'to_user_id',

          'title',

          'text',
          'file',

          'flag_new',
          'ad_employer_id',

          'job_title_id',
          'chat_id_from',
          'chat_id_to',
          'reply_message_id',

      ];

      /*
       * Связь таблицы Message с таблицей User (Отправитель)
      */
      public function user_from() {
          return $this->belongsTo(User::class, 'user_id');
      }
  
      /*
       * Связь таблицы Message с таблицей User (Получатель)
      */
      public function user_to() {
          return $this->belongsTo(User::class, 'to_user_id');
      }

      // Связь модели Сообщения (Message) с моделью Вакансии (Ad_employer)
      public function vacancies() {

          return $this->belongsTo(Ad_employer::class, 'ad_employer_id', 'id');

      }

  
      public static function add_message(

          ?Request $request,

          int $user_id,
          int $to_user_id,
          array $message_params,

          string $file_store_path = '/',
          bool $is_admin_chat = false

      ) {
          $message_params['user_id'] = $user_id;
          $message_params['to_user_id'] = $to_user_id;

          if ($request && $request->has('file')) {

              $message_params['file'] = $request->file('file')->store($file_store_path, 'public');
          }

          $chat_form = Chat::firstOrCreate([
              'user_id' => $is_admin_chat ? 0 : $user_id,
              'to_user_id' => $to_user_id,
              'is_removed' => 0,
              'is_admin_chat' => $is_admin_chat ? 1 : 0,
          ]);
          $message_params[$is_admin_chat ? 'chat_id_to' : 'chat_id_from'] = $chat_form->id;
  
          if (!$is_admin_chat) {
              $chat_to = Chat::firstOrCreate([
                  'user_id' => $to_user_id,
                  'to_user_id' => $user_id,
                  'is_removed' => 0
              ]);
              $message_params['chat_id_to'] = $chat_to->id;
          }

          $new_message = Message::create($message_params);
  
          if (!empty($new_message->id)) {

              $chat_form->update(['last_message_date' => date("Y-m-d H:i:s"), 'last_message_id' => $new_message->id]);
  
              if (!$is_admin_chat) {
                  $chat_to->update(['last_message_date' => date("Y-m-d H:i:s"), 'last_message_id' => $new_message->id]);
              }

          }

          return $new_message ?? false;
      }
  
      public function getReplyMessageAttribute()
      {
          $reply_message = false;
          if ($this->attributes['reply_message_id']){
              $reply_message = self::find($this->attributes['reply_message_id']);
          }

          return $reply_message;

      }

  }