<?php
  
  namespace FootyRoom\Queries\Category;
  
  use FootyRoom\Support\AutoMapper;
  use Illuminate\Database\Connection;
  
  class CategoryQueryHandler
  {
      /**
       * @var \Illuminate\Database\Connection
       */
      protected $mysql;
  
      /**
       * Constructor.
       *
       * @param \Illuminate\Database\Connection $mysql
       */
      public function __construct(Connection $mysql)
      {
          $this->mysql = $mysql;
      }
  
      /**
       * Query handler.
       *
       * @param \FootyRoom\Queries\Category\OneCategoryQuery $query
       *
       * @return \FootyRoom\Queries\Category\Category|null
       */
      public function findOne(OneCategoryQuery $query)
      {
          $builder = $this->mysql
  
          ->table('wp_term_taxonomy AS taxonomy')
          ->select(
              'terms.name as name',
              'terms.term_id as id',
              'terms.slug as slug',
              'taxonomy.count'
          )
          ->leftJoin('wp_terms as terms', 'terms.term_id', '=', 'taxonomy.term_id')
          ->where('terms.term_group', ForumCategoriesQuery::FORUM_TERM_GROUP);
  
          if ($query->getCategorySlug()) {
              $builder->where('terms.slug', $query->getCategorySlug());
          }
  
          $categoryDto = $builder->first();
  
          if (!$categoryDto) {
              return null;
          }
  
          return AutoMapper::map($categoryDto, Category::class);
      }
  
      /**
       * Query handler.
       *
       * @param \FootyRoom\Queries\Category\ForumCategoriesQuery $query
       *
       * @return \FootyRoom\Queries\Category\Category[]
       */
      public function findForumCategories(ForumCategoriesQuery $query)
      {
          $categories = $this->mysql->select(
              'SELECT 
               terms.name as name,
               terms.term_id as id,
               terms.slug as slug,
               taxonomy.count
               FROM wp_term_taxonomy AS taxonomy
               LEFT JOIN wp_terms AS terms ON terms.term_id = taxonomy.term_id
               WHERE term_group = ?',
              [$query->getForumTermGroup()]
          );
  
          $categoryModels = [];
  
          foreach ($categories as $category) {
              $categoryModels[] = AutoMapper::map($category, Category::class);
          }
  
          return $categoryModels;
      }
  }