<?php

declare(strict_types=1);

namespace ACA\EC\Search;

use AC\Helper\Select\Options;
use ACA\GravityForms\Search\Query\Bindings;
use ACP;
use ACP\Search;
use ACP\Search\Operators;
use ACP\Search\Value;

class PastEvents extends Search\Comparison implements Search\Comparison\Values
{
    private string $meta_key;

    public function __construct($meta_key)
    {
        parent::__construct(new Operators([Operators::EQ]));

        $this->meta_key = $meta_key;
    }

    public function format_label(string $value): string
    {
        return $value;
    }

    public function get_values(): Options
    {
        return Options::create_from_array([
            'yes' => __('Has Past Event', 'codepress-admin-columns'),
            'no'  => __('Has No Past Event', 'codepress-admin-columns'),
        ]);
    }

    protected function create_query_bindings(string $operator, Value $value): ACP\Query\Bindings
    {
        global $wpdb;

        $bindings = new Bindings();
        $post_ids = $this->get_related_post_ids();

        if (empty($post_ids)) {
            return $bindings->where('1=0');
        }

        $in_operator = $value->get_value() === 'yes' ? 'IN' : 'NOT IN';

        return $bindings->where("{$wpdb->posts}.ID $in_operator( " . implode(',', $post_ids) . " )");
    }

    public function get_related_post_ids(): array
    {
        global $wpdb;

        $events = tribe_get_events([
            'end_date'       => date('Y-m-d H:i:s'),
            'posts_per_page' => -1,
        ]);

        $event_ids = implode(',', array_map('absint', wp_list_pluck($events, 'ID')));

        if (empty($event_ids)) {
            return [];
        }

        $sql = $wpdb->prepare(
            "SELECT DISTINCT( meta_value )
								FROM {$wpdb->postmeta}
								WHERE meta_key = %s AND post_id IN ( " . $event_ids . ' )',
            $this->meta_key
        );

        return $wpdb->get_col($sql);
    }

}
