Addresses.php
1.96 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
<?php
declare(strict_types=1);
namespace ACA\WC\Search\Order;
use ACA\WC\Type\AddressType;
use ACP\Search\Comparison;
use ACP\Search\Helper\Sql\ComparisonFactory;
use ACP\Search\Operators;
use ACP\Search\Query\Bindings;
use ACP\Search\Value;
class Addresses extends Comparison
{
private $field;
private $address_type;
public function __construct(string $field, AddressType $address_type)
{
parent::__construct(
new Operators([
Operators::CONTAINS,
Operators::EQ,
Operators::NEQ,
Operators::NOT_CONTAINS,
Operators::ENDS_WITH,
Operators::BEGINS_WITH,
Operators::IS_EMPTY,
Operators::NOT_IS_EMPTY,
])
);
$this->field = $field;
$this->address_type = $address_type;
}
protected function create_query_bindings($operator, Value $value)
{
global $wpdb;
$bindings = new Bindings();
$alias = $bindings->get_unique_alias('addresses');
$bindings->join(
sprintf(
"
JOIN {$wpdb->prefix}wc_order_addresses AS $alias
ON {$wpdb->prefix}wc_orders.id = $alias.order_id AND $alias.address_type = '%s'
",
esc_sql((string)$this->address_type)
)
);
$field = sprintf("%s.%s", $alias, esc_sql($this->field));
switch ($operator) {
case Operators::NOT_IS_EMPTY :
$where = sprintf("%s is NOT NULL", $field);
break;
case Operators::IS_EMPTY :
$where = sprintf("%s is NULL", $field);
break;
default :
$where = ComparisonFactory::create(
$field,
$operator,
$value
)->prepare();
}
$bindings->where($where);
return $bindings;
}
}