<?php
  
  namespace FootyRoom\Queries;
  
  use FootyRoom\Support\MongoClient;
  use Illuminate\Database\DatabaseManager;
  
  class UrlGeneratorQuery
  {
      /**
       * @var \Illuminate\Database\DatabaseManager
       */
      protected $mysql;
  
      /**
       * @var \FootyRoom\Support\MongoClient
       */
      protected $mongo;
  
      /**
       * Constructor.
       *
       * @param \Illuminate\Database\DatabaseManager $mysql
       * @param \FootyRoom\Support\MongoClient $mongo
       */
      public function __construct(DatabaseManager $mysql, MongoClient $mongo)
      {
          $this->mysql = $mysql;
          $this->mongo = $mongo;
      }
  
      /**
       * Finds needed data to build url to a post.
       *
       * Currently this works for many types of "posts" - le mix posts, pages like transfers-center and previews.
       *
       * @param int $id
       *
       * @return object|null Returned object contains id, slug, type, previewMatchId and category.
       */
      public function findPost($id)
      {
          $post = $this->mysql
  
          ->select(
              '
              SELECT
              ID as id,
              post_name as slug,
              post_type as type,
              preview.meta_value as previewMatchId,
              t.slug as category
              FROM wp_posts
              LEFT JOIN wp_postmeta AS preview ON preview.post_id = ID AND preview.meta_key = "match_id_preview"
              LEFT JOIN wp_term_relationships AS tr ON tr.object_id = ID
              LEFT JOIN wp_terms AS t ON t.term_id = tr.term_taxonomy_id
              WHERE ID = ?',
              [$id]
          );
  
          if (!isset($post[0])) {
              return null;
          }
  
          return $post[0];
      }
  
      /**
       * Finds needed data to build url to a match.
       *
       * @param int $id
       *
       * @return object|null Returns homeTeam, awayTeam and matchId from mongo matches collection.
       */
      public function findMatch($id)
      {
          $matchDto = $this->mongo->footyroom->matches->findOne(
              ['matchId' => $id],
              ['projection' => ['homeTeam' => 1, 'awayTeam' => 1, 'matchId' => 1]]
          );
  
          if (!$matchDto) {
              return null;
          }
  
          return $matchDto;
      }
  
      /**
       * Finds needed data to build url to a user profile.
       *
       * @param int $id
       *
       * @return object Returns object with username property.
       */
      public function findUser($id)
      {
          return $this->mongo->footyroom->users->findOne(['userId' => $id], ['projection' => ['username' => 1]]);
      }
  }