<?php
  
  namespace FootyRoom\Queries\Article;
  
  use MongoDB\BSON\ObjectId;
  use FootyRoom\Support\AutoMapper;
  use FootyRoom\Support\MongoClient;
  
  class ArticleQuery
  {
      /** @var \FootyRoom\Support\MongoClient */
      protected $mongo;
  
      public function __construct(MongoClient $mongo)
      {
          $this->mongo = $mongo;
      }
  
      /**
       * @return \FootyRoom\Queries\Article\Article[]
       */
      public function find(int $limit, int $offset = 0): array
      {
          return $this->findBy([], $limit, $offset);
      }
  
      /**
       * @return \FootyRoom\Queries\Article\Article[]
       */
      public function findPublished(int $limit, int $offset = 0): array
      {
          return $this->findBy(['status' => 'published'], $limit, $offset);
      }
  
      public function findOne(string $id): ?Article
      {
          $article = $this->mongo->footyroom->articles->findOne(['_id' => new ObjectId($id)]);
  
          if (!$article) {
              return null;
          }
  
          $article->id = (string) $article->_id;
  
          $article = AutoMapper::map($article, Article::class);
  
          return $article;
      }
  
      /**
       * @return \FootyRoom\Queries\Article\Article[]
       */
      private function findBy($query, int $limit, int $offset = 0): array
      {
          $entities = [];
          $articles = $this->mongo->footyroom->articles->find($query, [
              'limit' => $limit,
              'skip' => $offset,
              'sort' => ['isFeatured' => -1, 'createdAt' => -1, '_id' => -1],
          ]);
  
          foreach ($articles as $article) {
              $article->id = (string) $article->_id;
              $entities[] = AutoMapper::map($article, Article::class);
          }
  
          return $entities;
      }
  }