<?php

namespace App\Models;

use App\Database;
use Matrix\Enums\EventType;
use Matrix\Events\ClientEvent;
use Matrix\Events\StateEvent;

class RoomEvent
{
  public function __construct(
    private ClientEvent $event,
  )
  {}

  /**
   * @param array<string, mixed> $row
   */
  public static function transformEvent(array $row): ClientEvent
  {
    return new ClientEvent(
      content: json_decode($row["content"], true),
      eventId: $row["id"],
      originServerTimestamp: new \DateTime($row["origin_server_timestamp"])->getTimestamp(),
      roomId: $row["room_id"],
      sender: $row["sender"],
      type: EventType::from($row["type"]),
      unsigned: json_decode($row["unsigned"], true),
    );
  }

  public function insert(): bool
  {
    if ($this->event instanceof StateEvent) {
      return !! Database::getInstance()->query(<<<SQL
        insert into room_events (id, content, type, sender, origin_server_timestamp, room_id, unsigned, state_key)
        values (:id, :content, :type, :sender, to_timestamp(:origin_server_timestamp), :room_id, :unsigned, :state_key)
      SQL, [
        "id" => $this->event->getId(),
        "content" => json_encode($this->event->getContent()),
        "type" => $this->event->getType()->value,
        "sender" => $this->event->getSender(),
        "origin_server_timestamp" => \DateTime::createFromTimestamp($this->event->getOriginServerTimestamp())->format("U.v"),
        "room_id" => $this->event->getRoomId(),
        "unsigned" => json_encode($this->event->getUnsigned()),
        "state_key" => $this->event->getStateKey(),
      ]);
    }

    return !! Database::getInstance()->query(<<<SQL
      insert into room_events (id, content, type, sender, origin_server_timestamp, room_id, unsigned)
      values (:id, :content, :type, :sender, to_timestamp(:origin_server_timestamp), :room_id, :unsigned)
    SQL, [
      "id" => $this->event->getId(),
      "content" => json_encode($this->event->getContent()),
      "type" => $this->event->getType()->value,
      "sender" => $this->event->getSender(),
      "origin_server_timestamp" => \DateTime::createFromTimestamp($this->event->getOriginServerTimestamp())->format("U.v"),
      "room_id" => $this->event->getRoomId(),
      "unsigned" => json_encode($this->event->getUnsigned()),
    ]);
  }
}