<?php

declare(strict_types=1);

namespace ACA\GravityForms\Search\Comparison;

use ACA\GravityForms\Search\Query\Bindings;
use ACP;
use ACP\Search\Comparison;
use ACP\Search\Helper\Sql\ComparisonFactory;
use ACP\Search\Labels;
use ACP\Search\Operators;
use ACP\Search\Value;

abstract class Entry extends Comparison
{

    /**
     * @var string
     */
    protected string $meta_key;

    public function __construct(
        string $meta_key,
        Operators $operators,
        ?string $value_type = null,
        ?Labels $labels = null
    ) {
        parent::__construct($operators, $value_type, $labels);

        $this->meta_key = $meta_key;
    }

    protected function create_query_bindings(string $operator, Value $value): ACP\Query\Bindings
    {
        if (Operators::IS_EMPTY === $operator) {
            return $this->create_empty_query_bindings();
        }

        $bindings = new Bindings();

        $alias = $bindings->get_entry_meta_table_name_alias();
        $where = ComparisonFactory::create(
            $alias . '.meta_value',
            $operator,
            $value
        );

        $bindings->join_entry_meta_table($alias, $this->meta_key)
                 ->where($where->prepare());

        return $bindings;
    }

    private function create_empty_query_bindings(): Bindings
    {
        $bindings = new Bindings();
        $alias = $bindings->get_entry_meta_table_name_alias();

        $where = sprintf('%s.meta_value IS NULL', $alias);

        $bindings->join_entry_meta_table($alias, $this->meta_key, 'LEFT')
                 ->where($where);

        return $bindings;
    }

}