<?php

namespace Elements\Model;

use Doctrine\Common\Collections\ArrayCollection;
use Doctrine\Common\Collections\Collection;
use Doctrine\DBAL\Schema\Column;
use Doctrine\DBAL\Schema\Table;
use Doctrine\ORM\Mapping\Entity;
use Doctrine\ORM\Mapping\GeneratedValue;
use Doctrine\ORM\Mapping\Id;
use Doctrine\ORM\Mapping\ManyToMany;
use Doctrine\ORM\Mapping\OneToMany;
use Doctrine\ORM\PersistentCollection;
use Elements\DB;

#[Entity]
#[Table(name: 'cards')]
/**
 * @Entity
 * @Table(name="cards")
 */
class Card
{
  #[Id]
  #[Column(type: 'integer')]
  #[GeneratedValue]
  /**
   * @Id
   * @Column(type="integer")
   * @GeneratedValue
   */
  public int $id;

  #[OneToMany(targetEntity: CardMeta::class, mappedBy: 'card')]
  /**
   * @OneToMany(targetEntity="CardMeta", mappedBy="card")
   */
  public Collection|ArrayCollection|PersistentCollection $meta;

  #[OneToMany(targetEntity: Artwork::class, mappedBy: 'card')]
  /**
   * @OneToMany(targetEntity="Artwork", mappedBy="card")
   */
  public Collection|ArrayCollection|PersistentCollection $artworks;

  #[OneToMany(targetEntity: VoteCard::class, mappedBy: 'card')]
  /**
   * @OneToMany(targetEntity="VoteCard", mappedBy="card")
   */
  public Collection|ArrayCollection|PersistentCollection $votes;

  #[ManyToMany(targetEntity: Category::class, inversedBy: 'cards')]
  /**
   * @ManyToMany(targetEntity="Category", inversedBy="cards", cascade={"persist"})
   */
  public Collection|ArrayCollection|PersistentCollection $categories;

  /**
   * Card constructor.
   */
  public function __construct()
  {
    $this->meta = new ArrayCollection();
    $this->artworks = new ArrayCollection();
    $this->votes = new ArrayCollection();
    $this->categories = new ArrayCollection();
  }

  /**
   * @param CardMeta $meta
   */
  public function addMeta(CardMeta $meta)
  {
    $meta->card = $this;
    $this->meta[] = $meta;
  }

  /**
   * @param Artwork $artwork
   */
  public function addArtwork(Artwork $artwork)
  {
    $artwork->card = $this;
    $this->artworks[] = $artwork;
  }

  /**
   * @param VoteCard $vote
   */
  public function addVote(VoteCard $vote)
  {
    $vote->card = $this;
    $this->votes[] = $vote;
  }

  /**
   * @param string $key
   *
   * @return string
   */
  public function getMeta(string $key): ?string
  {
    // if meta is already hydrated
    if ($this->meta->isInitialized()) {
      $meta = $this->meta->unwrap()
	#->findFirst(fn (CardMeta $item) => $item->key === $key);
	->filter(fn ($item) => $item->key === $key)->first();

      return $meta->value ?? null;
    }

    // get directly from db otherwise
    $result = DB::$entityManager
      ->createQuery(
	'SELECT cm.value
	FROM Elements\Model\CardMeta cm
	WHERE cm.key = :key AND cm.card = :card'
      )
      ->setParameter('key', $key)
      ->setParameter('card', $this)
      ->getOneOrNullResult();

      return $result['value'] ?? null;
  }

  /**
   * @return int
   */
  public function getVotesTotal(): int
  {
    $result = DB::$entityManager
      ->createQuery(
	'SELECT sum(v.value) as total
	FROM Elements\Model\VoteCard v
	WHERE v.card = :card'
      )
      ->setParameter('card', $this)
      ->getOneOrNullResult();

      return $result['total'] ?? 0;
  }
}