<?php

namespace Intexsoft\Controllers\Ajax;

use Intexsoft;
use Psr\Http\Message\ResponseInterface;
use WPEmerge\Requests\Request;

class VacancyFilterController
{

	public function filterOptions(Request $request): ResponseInterface
	{
		$terms_ids = $request->query('terms_ids');

		return Intexsoft::json($this->getFiltersValues($terms_ids ?? []));
	}

	private function getFiltersValues(array $terms_ids = array()): array
	{
		global $wpdb;
		$available_fields_query = '';

		if (empty($terms_ids)) {

			$available_fields_query = <<<SQL
select wp_2_terms.term_id, name, slug, taxonomy, parent
from wp_2_terms
         inner join wp_2_term_taxonomy w2tt on wp_2_terms.term_id = w2tt.term_id;
SQL;

		} else {

			$terms_ids_query = '';

			foreach ($terms_ids as $term_id) {
				if (empty($terms_ids_query)) {
					$terms_ids_query .= sprintf('where w2tr.term_taxonomy_id = %s', $term_id);
				} else {
					$terms_ids_query .= sprintf(' or w2tr.term_taxonomy_id = %s', $term_id);
				}
			}

			$available_fields_query = <<<SQL
select wp_2_terms.term_id, name, slug, taxonomy, parent
from wp_2_term_taxonomy
         inner join wp_2_terms on wp_2_terms.term_id = wp_2_term_taxonomy.term_id
where wp_2_term_taxonomy.term_id in (select wp_2_term_relationships.term_taxonomy_id
                                     from wp_2_term_relationships
                                     where object_id in (select distinct object_id
                                                         from wp_2_term_relationships as w2tr
                                                         $terms_ids_query));
SQL;
		}

		// Translate string to int
		$result = $wpdb->get_results($available_fields_query);
		array_walk($result, static function ($item) {
			$item->term_id = (int)$item->term_id;
			$item->parent = (int)$item->parent;
		});

		// Group by taxonomy
		$filters = [];
		foreach ($result as $item) {
			$filters[$item->taxonomy][$item->term_id] = $item;
		}

		// Make taxonomy structure as tree
		foreach ($filters as &$filter) {
			foreach ($filter as $idx => $term) {
				if ($term->parent !== 0) {
					$filter[$term->parent]->terms[] = $term;
					unset($filter[$idx]);
				}
			}

			$filter = array_values($filter);
		}

		return $filters;
	}
}