<?php

namespace ACA\WC\Search\Order;

use ACA\WC\Search;
use ACP;
use ACP\Search\Operators;
use ACP\Search\Value;

class CustomerNote extends ACP\Search\Comparison
{

    public function __construct()
    {
        parent::__construct(
            new Operators([
                Operators::CONTAINS,
                Operators::NOT_CONTAINS,
            ])
        );
    }

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

        $bindings = new ACP\Search\Query\Bindings();
        $order_table = $wpdb->prefix . 'wc_orders';
        $field = sprintf('%s.%s', $order_table, 'customer_note');

        return $bindings->where(ACP\Search\Helper\Sql\ComparisonFactory::create($field, $operator, $value)());
    }

}