@@ -18,169 +18,169 @@ |
||
18 | 18 | */ |
19 | 19 | class DatetimeConnectionResolver extends AbstractConnectionResolver |
20 | 20 | { |
21 | - // phpcs:ignore PSR1.Methods.CamelCapsMethodName.NotCamelCaps |
|
22 | - public function get_loader_name() |
|
23 | - { |
|
24 | - return 'espresso_datetime'; |
|
25 | - } |
|
26 | - |
|
27 | - /** |
|
28 | - * @return EEM_Datetime |
|
29 | - * @throws EE_Error |
|
30 | - * @throws InvalidArgumentException |
|
31 | - * @throws InvalidDataTypeException |
|
32 | - * @throws InvalidInterfaceException |
|
33 | - */ |
|
34 | - // phpcs:ignore PSR1.Methods.CamelCapsMethodName.NotCamelCaps |
|
35 | - public function get_query() |
|
36 | - { |
|
37 | - return EEM_Datetime::instance(); |
|
38 | - } |
|
39 | - |
|
40 | - /** |
|
41 | - * Return an array of item IDs from the query |
|
42 | - * |
|
43 | - * @return array |
|
44 | - */ |
|
45 | - // phpcs:ignore PSR1.Methods.CamelCapsMethodName.NotCamelCaps |
|
46 | - public function get_ids() |
|
47 | - { |
|
48 | - $results = $this->query->get_col($this->query_args); |
|
49 | - |
|
50 | - return ! empty($results) ? $results : []; |
|
51 | - } |
|
52 | - |
|
53 | - /** |
|
54 | - * Here, we map the args from the input, then we make sure that we're only querying |
|
55 | - * for IDs. The IDs are then passed down the resolve tree, and deferred resolvers |
|
56 | - * handle batch resolution of the posts. |
|
57 | - * |
|
58 | - * @return array |
|
59 | - * @throws EE_Error |
|
60 | - * @throws InvalidArgumentException |
|
61 | - * @throws InvalidDataTypeException |
|
62 | - * @throws InvalidInterfaceException |
|
63 | - */ |
|
64 | - // phpcs:ignore PSR1.Methods.CamelCapsMethodName.NotCamelCaps |
|
65 | - public function get_query_args() |
|
66 | - { |
|
67 | - $where_params = ['DTT_deleted' => ['IN', [true, false]]]; |
|
68 | - $query_args = []; |
|
69 | - |
|
70 | - $query_args['limit'] = $this->getLimit(); |
|
71 | - |
|
72 | - // Avoid multiple entries by join. |
|
73 | - $query_args['group_by'] = 'DTT_ID'; |
|
74 | - |
|
75 | - $query_args['default_where_conditions'] = 'minimum'; |
|
76 | - |
|
77 | - /** |
|
78 | - * Collect the input_fields and sanitize them to prepare them for sending to the Query |
|
79 | - */ |
|
80 | - $input_fields = []; |
|
81 | - if (! empty($this->args['where'])) { |
|
82 | - $input_fields = $this->sanitizeInputFields($this->args['where']); |
|
83 | - |
|
84 | - // Use the proper operator. |
|
85 | - if (! empty($input_fields['EVT_ID']) && is_array($input_fields['EVT_ID'])) { |
|
86 | - $input_fields['EVT_ID'] = ['in', $input_fields['EVT_ID']]; |
|
87 | - } |
|
88 | - if (! empty($input_fields['Ticket.TKT_ID']) && is_array($input_fields['Ticket.TKT_ID'])) { |
|
89 | - $input_fields['Ticket.TKT_ID'] = ['in', $input_fields['Ticket.TKT_ID']]; |
|
90 | - } |
|
91 | - } |
|
92 | - |
|
93 | - /** |
|
94 | - * Determine where we're at in the Graph and adjust the query context appropriately. |
|
95 | - * |
|
96 | - * For example, if we're querying for datetime as a field of event query, this will automatically |
|
97 | - * set the query to pull datetimes that belong to that event. |
|
98 | - * We can set more cases for other source types. |
|
99 | - */ |
|
100 | - if (is_object($this->source)) { |
|
101 | - switch (true) { |
|
102 | - // It's surely an event |
|
103 | - case $this->source instanceof Post: |
|
104 | - $where_params['EVT_ID'] = $this->source->ID; |
|
105 | - break; |
|
106 | - case $this->source instanceof EE_Event: |
|
107 | - $where_params['EVT_ID'] = $this->source->ID(); |
|
108 | - break; |
|
109 | - case $this->source instanceof EE_Ticket: |
|
110 | - $where_params['Ticket.TKT_ID'] = $this->source->ID(); |
|
111 | - break; |
|
112 | - case $this->source instanceof EE_Checkin: |
|
113 | - $where_params['Checkin.CHK_ID'] = $this->source->ID(); |
|
114 | - break; |
|
115 | - } |
|
116 | - } |
|
117 | - |
|
118 | - /** |
|
119 | - * Merge the input_fields with the default query_args |
|
120 | - */ |
|
121 | - if (! empty($input_fields)) { |
|
122 | - $where_params = array_merge($where_params, $input_fields); |
|
123 | - } |
|
124 | - |
|
125 | - list($query_args, $where_params) = $this->mapOrderbyInputArgs($query_args, $where_params, 'DTT_ID'); |
|
126 | - |
|
127 | - if (! empty($this->args['where']['upcoming'])) { |
|
128 | - $where_params['DTT_EVT_start'] = array( |
|
129 | - '>', |
|
130 | - EEM_Datetime::instance()->current_time_for_query('DTT_EVT_start') |
|
131 | - ); |
|
132 | - } |
|
133 | - |
|
134 | - if (! empty($this->args['where']['active'])) { |
|
135 | - $where_params['DTT_EVT_start'] = array( |
|
136 | - '<', |
|
137 | - EEM_Datetime::instance()->current_time_for_query('DTT_EVT_start') |
|
138 | - ); |
|
139 | - $where_params['DTT_EVT_end'] = array( |
|
140 | - '>', |
|
141 | - EEM_Datetime::instance()->current_time_for_query('DTT_EVT_end') |
|
142 | - ); |
|
143 | - } |
|
144 | - |
|
145 | - if (! empty($this->args['where']['expired'])) { |
|
146 | - $where_params['DTT_EVT_end'] = array( |
|
147 | - '<', |
|
148 | - EEM_Datetime::instance()->current_time_for_query('DTT_EVT_end') |
|
149 | - ); |
|
150 | - } |
|
151 | - |
|
152 | - $query_args[] = $where_params; |
|
153 | - |
|
154 | - /** |
|
155 | - * Return the $query_args |
|
156 | - */ |
|
157 | - return $query_args; |
|
158 | - } |
|
159 | - |
|
160 | - |
|
161 | - /** |
|
162 | - * This sets up the "allowed" args, and translates the GraphQL-friendly keys to model |
|
163 | - * friendly keys. |
|
164 | - * |
|
165 | - * @param array $where_args |
|
166 | - * @return array |
|
167 | - */ |
|
168 | - public function sanitizeInputFields(array $where_args) |
|
169 | - { |
|
170 | - $arg_mapping = [ |
|
171 | - 'event' => 'EVT_ID', |
|
172 | - 'eventIn' => 'EVT_ID', |
|
173 | - 'eventId' => 'EVT_ID', |
|
174 | - 'eventIdIn' => 'EVT_ID', |
|
175 | - 'ticket' => 'Ticket.TKT_ID', |
|
176 | - 'ticketIn' => 'Ticket.TKT_ID', |
|
177 | - 'ticketId' => 'Ticket.TKT_ID', |
|
178 | - 'ticketIdIn' => 'Ticket.TKT_ID', |
|
179 | - ]; |
|
180 | - return $this->sanitizeWhereArgsForInputFields( |
|
181 | - $where_args, |
|
182 | - $arg_mapping, |
|
183 | - ['event', 'eventIn', 'ticket', 'ticketIn'] |
|
184 | - ); |
|
185 | - } |
|
21 | + // phpcs:ignore PSR1.Methods.CamelCapsMethodName.NotCamelCaps |
|
22 | + public function get_loader_name() |
|
23 | + { |
|
24 | + return 'espresso_datetime'; |
|
25 | + } |
|
26 | + |
|
27 | + /** |
|
28 | + * @return EEM_Datetime |
|
29 | + * @throws EE_Error |
|
30 | + * @throws InvalidArgumentException |
|
31 | + * @throws InvalidDataTypeException |
|
32 | + * @throws InvalidInterfaceException |
|
33 | + */ |
|
34 | + // phpcs:ignore PSR1.Methods.CamelCapsMethodName.NotCamelCaps |
|
35 | + public function get_query() |
|
36 | + { |
|
37 | + return EEM_Datetime::instance(); |
|
38 | + } |
|
39 | + |
|
40 | + /** |
|
41 | + * Return an array of item IDs from the query |
|
42 | + * |
|
43 | + * @return array |
|
44 | + */ |
|
45 | + // phpcs:ignore PSR1.Methods.CamelCapsMethodName.NotCamelCaps |
|
46 | + public function get_ids() |
|
47 | + { |
|
48 | + $results = $this->query->get_col($this->query_args); |
|
49 | + |
|
50 | + return ! empty($results) ? $results : []; |
|
51 | + } |
|
52 | + |
|
53 | + /** |
|
54 | + * Here, we map the args from the input, then we make sure that we're only querying |
|
55 | + * for IDs. The IDs are then passed down the resolve tree, and deferred resolvers |
|
56 | + * handle batch resolution of the posts. |
|
57 | + * |
|
58 | + * @return array |
|
59 | + * @throws EE_Error |
|
60 | + * @throws InvalidArgumentException |
|
61 | + * @throws InvalidDataTypeException |
|
62 | + * @throws InvalidInterfaceException |
|
63 | + */ |
|
64 | + // phpcs:ignore PSR1.Methods.CamelCapsMethodName.NotCamelCaps |
|
65 | + public function get_query_args() |
|
66 | + { |
|
67 | + $where_params = ['DTT_deleted' => ['IN', [true, false]]]; |
|
68 | + $query_args = []; |
|
69 | + |
|
70 | + $query_args['limit'] = $this->getLimit(); |
|
71 | + |
|
72 | + // Avoid multiple entries by join. |
|
73 | + $query_args['group_by'] = 'DTT_ID'; |
|
74 | + |
|
75 | + $query_args['default_where_conditions'] = 'minimum'; |
|
76 | + |
|
77 | + /** |
|
78 | + * Collect the input_fields and sanitize them to prepare them for sending to the Query |
|
79 | + */ |
|
80 | + $input_fields = []; |
|
81 | + if (! empty($this->args['where'])) { |
|
82 | + $input_fields = $this->sanitizeInputFields($this->args['where']); |
|
83 | + |
|
84 | + // Use the proper operator. |
|
85 | + if (! empty($input_fields['EVT_ID']) && is_array($input_fields['EVT_ID'])) { |
|
86 | + $input_fields['EVT_ID'] = ['in', $input_fields['EVT_ID']]; |
|
87 | + } |
|
88 | + if (! empty($input_fields['Ticket.TKT_ID']) && is_array($input_fields['Ticket.TKT_ID'])) { |
|
89 | + $input_fields['Ticket.TKT_ID'] = ['in', $input_fields['Ticket.TKT_ID']]; |
|
90 | + } |
|
91 | + } |
|
92 | + |
|
93 | + /** |
|
94 | + * Determine where we're at in the Graph and adjust the query context appropriately. |
|
95 | + * |
|
96 | + * For example, if we're querying for datetime as a field of event query, this will automatically |
|
97 | + * set the query to pull datetimes that belong to that event. |
|
98 | + * We can set more cases for other source types. |
|
99 | + */ |
|
100 | + if (is_object($this->source)) { |
|
101 | + switch (true) { |
|
102 | + // It's surely an event |
|
103 | + case $this->source instanceof Post: |
|
104 | + $where_params['EVT_ID'] = $this->source->ID; |
|
105 | + break; |
|
106 | + case $this->source instanceof EE_Event: |
|
107 | + $where_params['EVT_ID'] = $this->source->ID(); |
|
108 | + break; |
|
109 | + case $this->source instanceof EE_Ticket: |
|
110 | + $where_params['Ticket.TKT_ID'] = $this->source->ID(); |
|
111 | + break; |
|
112 | + case $this->source instanceof EE_Checkin: |
|
113 | + $where_params['Checkin.CHK_ID'] = $this->source->ID(); |
|
114 | + break; |
|
115 | + } |
|
116 | + } |
|
117 | + |
|
118 | + /** |
|
119 | + * Merge the input_fields with the default query_args |
|
120 | + */ |
|
121 | + if (! empty($input_fields)) { |
|
122 | + $where_params = array_merge($where_params, $input_fields); |
|
123 | + } |
|
124 | + |
|
125 | + list($query_args, $where_params) = $this->mapOrderbyInputArgs($query_args, $where_params, 'DTT_ID'); |
|
126 | + |
|
127 | + if (! empty($this->args['where']['upcoming'])) { |
|
128 | + $where_params['DTT_EVT_start'] = array( |
|
129 | + '>', |
|
130 | + EEM_Datetime::instance()->current_time_for_query('DTT_EVT_start') |
|
131 | + ); |
|
132 | + } |
|
133 | + |
|
134 | + if (! empty($this->args['where']['active'])) { |
|
135 | + $where_params['DTT_EVT_start'] = array( |
|
136 | + '<', |
|
137 | + EEM_Datetime::instance()->current_time_for_query('DTT_EVT_start') |
|
138 | + ); |
|
139 | + $where_params['DTT_EVT_end'] = array( |
|
140 | + '>', |
|
141 | + EEM_Datetime::instance()->current_time_for_query('DTT_EVT_end') |
|
142 | + ); |
|
143 | + } |
|
144 | + |
|
145 | + if (! empty($this->args['where']['expired'])) { |
|
146 | + $where_params['DTT_EVT_end'] = array( |
|
147 | + '<', |
|
148 | + EEM_Datetime::instance()->current_time_for_query('DTT_EVT_end') |
|
149 | + ); |
|
150 | + } |
|
151 | + |
|
152 | + $query_args[] = $where_params; |
|
153 | + |
|
154 | + /** |
|
155 | + * Return the $query_args |
|
156 | + */ |
|
157 | + return $query_args; |
|
158 | + } |
|
159 | + |
|
160 | + |
|
161 | + /** |
|
162 | + * This sets up the "allowed" args, and translates the GraphQL-friendly keys to model |
|
163 | + * friendly keys. |
|
164 | + * |
|
165 | + * @param array $where_args |
|
166 | + * @return array |
|
167 | + */ |
|
168 | + public function sanitizeInputFields(array $where_args) |
|
169 | + { |
|
170 | + $arg_mapping = [ |
|
171 | + 'event' => 'EVT_ID', |
|
172 | + 'eventIn' => 'EVT_ID', |
|
173 | + 'eventId' => 'EVT_ID', |
|
174 | + 'eventIdIn' => 'EVT_ID', |
|
175 | + 'ticket' => 'Ticket.TKT_ID', |
|
176 | + 'ticketIn' => 'Ticket.TKT_ID', |
|
177 | + 'ticketId' => 'Ticket.TKT_ID', |
|
178 | + 'ticketIdIn' => 'Ticket.TKT_ID', |
|
179 | + ]; |
|
180 | + return $this->sanitizeWhereArgsForInputFields( |
|
181 | + $where_args, |
|
182 | + $arg_mapping, |
|
183 | + ['event', 'eventIn', 'ticket', 'ticketIn'] |
|
184 | + ); |
|
185 | + } |
|
186 | 186 | } |
@@ -14,66 +14,66 @@ |
||
14 | 14 | */ |
15 | 15 | class PriceTypeConnectionResolver extends AbstractConnectionResolver |
16 | 16 | { |
17 | - // phpcs:ignore PSR1.Methods.CamelCapsMethodName.NotCamelCaps |
|
18 | - public function get_loader_name() |
|
19 | - { |
|
20 | - return 'espresso_priceType'; |
|
21 | - } |
|
17 | + // phpcs:ignore PSR1.Methods.CamelCapsMethodName.NotCamelCaps |
|
18 | + public function get_loader_name() |
|
19 | + { |
|
20 | + return 'espresso_priceType'; |
|
21 | + } |
|
22 | 22 | |
23 | - /** |
|
24 | - * @return EEM_Price_Type |
|
25 | - * @throws EE_Error |
|
26 | - * @throws InvalidArgumentException |
|
27 | - * @throws InvalidDataTypeException |
|
28 | - * @throws InvalidInterfaceException |
|
29 | - */ |
|
30 | - // phpcs:ignore PSR1.Methods.CamelCapsMethodName.NotCamelCaps |
|
31 | - public function get_query() |
|
32 | - { |
|
33 | - return EEM_Price_Type::instance(); |
|
34 | - } |
|
23 | + /** |
|
24 | + * @return EEM_Price_Type |
|
25 | + * @throws EE_Error |
|
26 | + * @throws InvalidArgumentException |
|
27 | + * @throws InvalidDataTypeException |
|
28 | + * @throws InvalidInterfaceException |
|
29 | + */ |
|
30 | + // phpcs:ignore PSR1.Methods.CamelCapsMethodName.NotCamelCaps |
|
31 | + public function get_query() |
|
32 | + { |
|
33 | + return EEM_Price_Type::instance(); |
|
34 | + } |
|
35 | 35 | |
36 | 36 | |
37 | - /** |
|
38 | - * Return an array of item IDs from the query |
|
39 | - * |
|
40 | - * @return array |
|
41 | - */ |
|
42 | - // phpcs:ignore PSR1.Methods.CamelCapsMethodName.NotCamelCaps |
|
43 | - public function get_ids() |
|
44 | - { |
|
45 | - $results = $this->query->get_col($this->query_args); |
|
37 | + /** |
|
38 | + * Return an array of item IDs from the query |
|
39 | + * |
|
40 | + * @return array |
|
41 | + */ |
|
42 | + // phpcs:ignore PSR1.Methods.CamelCapsMethodName.NotCamelCaps |
|
43 | + public function get_ids() |
|
44 | + { |
|
45 | + $results = $this->query->get_col($this->query_args); |
|
46 | 46 | |
47 | - return ! empty($results) ? $results : []; |
|
48 | - } |
|
47 | + return ! empty($results) ? $results : []; |
|
48 | + } |
|
49 | 49 | |
50 | 50 | |
51 | - /** |
|
52 | - * Here, we map the args from the input, then we make sure that we're only querying |
|
53 | - * for IDs. The IDs are then passed down the resolve tree, and deferred resolvers |
|
54 | - * handle batch resolution of the posts. |
|
55 | - * |
|
56 | - * @return array |
|
57 | - * @throws EE_Error |
|
58 | - * @throws InvalidArgumentException |
|
59 | - * @throws ReflectionException |
|
60 | - * @throws InvalidDataTypeException |
|
61 | - * @throws InvalidInterfaceException |
|
62 | - */ |
|
63 | - // phpcs:ignore PSR1.Methods.CamelCapsMethodName.NotCamelCaps |
|
64 | - public function get_query_args() |
|
65 | - { |
|
66 | - $where_params = []; |
|
67 | - $query_args = []; |
|
51 | + /** |
|
52 | + * Here, we map the args from the input, then we make sure that we're only querying |
|
53 | + * for IDs. The IDs are then passed down the resolve tree, and deferred resolvers |
|
54 | + * handle batch resolution of the posts. |
|
55 | + * |
|
56 | + * @return array |
|
57 | + * @throws EE_Error |
|
58 | + * @throws InvalidArgumentException |
|
59 | + * @throws ReflectionException |
|
60 | + * @throws InvalidDataTypeException |
|
61 | + * @throws InvalidInterfaceException |
|
62 | + */ |
|
63 | + // phpcs:ignore PSR1.Methods.CamelCapsMethodName.NotCamelCaps |
|
64 | + public function get_query_args() |
|
65 | + { |
|
66 | + $where_params = []; |
|
67 | + $query_args = []; |
|
68 | 68 | |
69 | - $query_args['limit'] = $this->getLimit(); |
|
69 | + $query_args['limit'] = $this->getLimit(); |
|
70 | 70 | |
71 | - // Avoid multiple entries by join. |
|
72 | - $query_args['group_by'] = 'PRT_ID'; |
|
71 | + // Avoid multiple entries by join. |
|
72 | + $query_args['group_by'] = 'PRT_ID'; |
|
73 | 73 | |
74 | - /** |
|
75 | - * Return the $query_args |
|
76 | - */ |
|
77 | - return $query_args; |
|
78 | - } |
|
74 | + /** |
|
75 | + * Return the $query_args |
|
76 | + */ |
|
77 | + return $query_args; |
|
78 | + } |
|
79 | 79 | } |
@@ -16,126 +16,126 @@ |
||
16 | 16 | */ |
17 | 17 | class VenueConnectionResolver extends AbstractConnectionResolver |
18 | 18 | { |
19 | - // phpcs:ignore PSR1.Methods.CamelCapsMethodName.NotCamelCaps |
|
20 | - public function get_loader_name() |
|
21 | - { |
|
22 | - return 'espresso_venue'; |
|
23 | - } |
|
24 | - |
|
25 | - /** |
|
26 | - * @return EEM_Venue |
|
27 | - * @throws EE_Error |
|
28 | - * @throws InvalidArgumentException |
|
29 | - * @throws InvalidDataTypeException |
|
30 | - * @throws InvalidInterfaceException |
|
31 | - */ |
|
32 | - // phpcs:ignore PSR1.Methods.CamelCapsMethodName.NotCamelCaps |
|
33 | - public function get_query() |
|
34 | - { |
|
35 | - return EEM_Venue::instance(); |
|
36 | - } |
|
37 | - |
|
38 | - |
|
39 | - /** |
|
40 | - * Return an array of item IDs from the query |
|
41 | - * |
|
42 | - * @return array |
|
43 | - */ |
|
44 | - // phpcs:ignore PSR1.Methods.CamelCapsMethodName.NotCamelCaps |
|
45 | - public function get_ids() |
|
46 | - { |
|
47 | - $results = $this->query->get_col($this->query_args); |
|
48 | - |
|
49 | - return ! empty($results) ? $results : []; |
|
50 | - } |
|
51 | - |
|
52 | - |
|
53 | - /** |
|
54 | - * Here, we map the args from the input, then we make sure that we're only querying |
|
55 | - * for IDs. The IDs are then passed down the resolve tree, and deferred resolvers |
|
56 | - * handle batch resolution of the posts. |
|
57 | - * |
|
58 | - * @return array |
|
59 | - */ |
|
60 | - // phpcs:ignore PSR1.Methods.CamelCapsMethodName.NotCamelCaps |
|
61 | - public function get_query_args() |
|
62 | - { |
|
63 | - $query_args = []; |
|
64 | - |
|
65 | - /** |
|
66 | - * Prepare for later use |
|
67 | - */ |
|
68 | - $last = ! empty($this->args['last']) ? $this->args['last'] : null; |
|
69 | - $first = ! empty($this->args['first']) ? $this->args['first'] : null; |
|
70 | - |
|
71 | - /** |
|
72 | - * Set limit the highest value of $first and $last, with a (filterable) max of 100 |
|
73 | - */ |
|
74 | - $query_args['limit'] = min( |
|
75 | - max(absint($first), absint($last), 10), |
|
76 | - $this->query_amount |
|
77 | - ) + 1; |
|
78 | - |
|
79 | - /** |
|
80 | - * Collect the input_fields and sanitize them to prepare them for sending to the Query |
|
81 | - */ |
|
82 | - $input_fields = []; |
|
83 | - if (! empty($this->args['where'])) { |
|
84 | - $input_fields = $this->sanitize_input_fields($this->args['where']); |
|
85 | - } |
|
86 | - |
|
87 | - /** |
|
88 | - * Determine where we're at in the Graph and adjust the query context appropriately. |
|
89 | - * For example, if we're querying for datetime as a field of event query, this will automatically |
|
90 | - * set the query to pull datetimes that belong to that event. |
|
91 | - * We can set more cases for other source types. |
|
92 | - */ |
|
93 | - if (is_object($this->source)) { |
|
94 | - switch (true) { |
|
95 | - // Assumed to be an event |
|
96 | - case $this->source instanceof Post: |
|
97 | - $query_args[] = ['Event.EVT_ID' => $this->source->ID]; |
|
98 | - break; |
|
99 | - case $this->source instanceof EE_Event: |
|
100 | - $query_args[] = ['Event.EVT_ID' => $this->source->ID()]; |
|
101 | - break; |
|
102 | - } |
|
103 | - } |
|
104 | - |
|
105 | - /** |
|
106 | - * Merge the input_fields with the default query_args |
|
107 | - */ |
|
108 | - if (! empty($input_fields)) { |
|
109 | - $query_args = array_merge($query_args, $input_fields); |
|
110 | - } |
|
111 | - |
|
112 | - /** |
|
113 | - * Return the $query_args |
|
114 | - */ |
|
115 | - return $query_args; |
|
116 | - } |
|
117 | - |
|
118 | - |
|
119 | - /** |
|
120 | - * This sets up the "allowed" args, and translates the GraphQL-friendly keys to WP_Query |
|
121 | - * friendly keys. There's probably a cleaner/more dynamic way to approach this, but |
|
122 | - * this was quick. I'd be down to explore more dynamic ways to map this, but for |
|
123 | - * now this gets the job done. |
|
124 | - * |
|
125 | - * @param array $query_args |
|
126 | - * @return array |
|
127 | - */ |
|
128 | - // phpcs:ignore PSR1.Methods.CamelCapsMethodName.NotCamelCaps |
|
129 | - public function sanitize_input_fields(array $query_args) |
|
130 | - { |
|
131 | - $arg_mapping = [ |
|
132 | - 'orderBy' => 'order_by', |
|
133 | - 'order' => 'order', |
|
134 | - ]; |
|
135 | - |
|
136 | - /** |
|
137 | - * Return the Query Args |
|
138 | - */ |
|
139 | - return ! empty($query_args) && is_array($query_args) ? $query_args : []; |
|
140 | - } |
|
19 | + // phpcs:ignore PSR1.Methods.CamelCapsMethodName.NotCamelCaps |
|
20 | + public function get_loader_name() |
|
21 | + { |
|
22 | + return 'espresso_venue'; |
|
23 | + } |
|
24 | + |
|
25 | + /** |
|
26 | + * @return EEM_Venue |
|
27 | + * @throws EE_Error |
|
28 | + * @throws InvalidArgumentException |
|
29 | + * @throws InvalidDataTypeException |
|
30 | + * @throws InvalidInterfaceException |
|
31 | + */ |
|
32 | + // phpcs:ignore PSR1.Methods.CamelCapsMethodName.NotCamelCaps |
|
33 | + public function get_query() |
|
34 | + { |
|
35 | + return EEM_Venue::instance(); |
|
36 | + } |
|
37 | + |
|
38 | + |
|
39 | + /** |
|
40 | + * Return an array of item IDs from the query |
|
41 | + * |
|
42 | + * @return array |
|
43 | + */ |
|
44 | + // phpcs:ignore PSR1.Methods.CamelCapsMethodName.NotCamelCaps |
|
45 | + public function get_ids() |
|
46 | + { |
|
47 | + $results = $this->query->get_col($this->query_args); |
|
48 | + |
|
49 | + return ! empty($results) ? $results : []; |
|
50 | + } |
|
51 | + |
|
52 | + |
|
53 | + /** |
|
54 | + * Here, we map the args from the input, then we make sure that we're only querying |
|
55 | + * for IDs. The IDs are then passed down the resolve tree, and deferred resolvers |
|
56 | + * handle batch resolution of the posts. |
|
57 | + * |
|
58 | + * @return array |
|
59 | + */ |
|
60 | + // phpcs:ignore PSR1.Methods.CamelCapsMethodName.NotCamelCaps |
|
61 | + public function get_query_args() |
|
62 | + { |
|
63 | + $query_args = []; |
|
64 | + |
|
65 | + /** |
|
66 | + * Prepare for later use |
|
67 | + */ |
|
68 | + $last = ! empty($this->args['last']) ? $this->args['last'] : null; |
|
69 | + $first = ! empty($this->args['first']) ? $this->args['first'] : null; |
|
70 | + |
|
71 | + /** |
|
72 | + * Set limit the highest value of $first and $last, with a (filterable) max of 100 |
|
73 | + */ |
|
74 | + $query_args['limit'] = min( |
|
75 | + max(absint($first), absint($last), 10), |
|
76 | + $this->query_amount |
|
77 | + ) + 1; |
|
78 | + |
|
79 | + /** |
|
80 | + * Collect the input_fields and sanitize them to prepare them for sending to the Query |
|
81 | + */ |
|
82 | + $input_fields = []; |
|
83 | + if (! empty($this->args['where'])) { |
|
84 | + $input_fields = $this->sanitize_input_fields($this->args['where']); |
|
85 | + } |
|
86 | + |
|
87 | + /** |
|
88 | + * Determine where we're at in the Graph and adjust the query context appropriately. |
|
89 | + * For example, if we're querying for datetime as a field of event query, this will automatically |
|
90 | + * set the query to pull datetimes that belong to that event. |
|
91 | + * We can set more cases for other source types. |
|
92 | + */ |
|
93 | + if (is_object($this->source)) { |
|
94 | + switch (true) { |
|
95 | + // Assumed to be an event |
|
96 | + case $this->source instanceof Post: |
|
97 | + $query_args[] = ['Event.EVT_ID' => $this->source->ID]; |
|
98 | + break; |
|
99 | + case $this->source instanceof EE_Event: |
|
100 | + $query_args[] = ['Event.EVT_ID' => $this->source->ID()]; |
|
101 | + break; |
|
102 | + } |
|
103 | + } |
|
104 | + |
|
105 | + /** |
|
106 | + * Merge the input_fields with the default query_args |
|
107 | + */ |
|
108 | + if (! empty($input_fields)) { |
|
109 | + $query_args = array_merge($query_args, $input_fields); |
|
110 | + } |
|
111 | + |
|
112 | + /** |
|
113 | + * Return the $query_args |
|
114 | + */ |
|
115 | + return $query_args; |
|
116 | + } |
|
117 | + |
|
118 | + |
|
119 | + /** |
|
120 | + * This sets up the "allowed" args, and translates the GraphQL-friendly keys to WP_Query |
|
121 | + * friendly keys. There's probably a cleaner/more dynamic way to approach this, but |
|
122 | + * this was quick. I'd be down to explore more dynamic ways to map this, but for |
|
123 | + * now this gets the job done. |
|
124 | + * |
|
125 | + * @param array $query_args |
|
126 | + * @return array |
|
127 | + */ |
|
128 | + // phpcs:ignore PSR1.Methods.CamelCapsMethodName.NotCamelCaps |
|
129 | + public function sanitize_input_fields(array $query_args) |
|
130 | + { |
|
131 | + $arg_mapping = [ |
|
132 | + 'orderBy' => 'order_by', |
|
133 | + 'order' => 'order', |
|
134 | + ]; |
|
135 | + |
|
136 | + /** |
|
137 | + * Return the Query Args |
|
138 | + */ |
|
139 | + return ! empty($query_args) && is_array($query_args) ? $query_args : []; |
|
140 | + } |
|
141 | 141 | } |
@@ -16,155 +16,155 @@ |
||
16 | 16 | */ |
17 | 17 | class AttendeeConnectionResolver extends AbstractConnectionResolver |
18 | 18 | { |
19 | - // phpcs:ignore PSR1.Methods.CamelCapsMethodName.NotCamelCaps |
|
20 | - public function get_loader_name() |
|
21 | - { |
|
22 | - return 'espresso_attendee'; |
|
23 | - } |
|
24 | - |
|
25 | - /** |
|
26 | - * @return EEM_Attendee |
|
27 | - * @throws EE_Error |
|
28 | - * @throws InvalidArgumentException |
|
29 | - * @throws InvalidDataTypeException |
|
30 | - * @throws InvalidInterfaceException |
|
31 | - */ |
|
32 | - // phpcs:ignore PSR1.Methods.CamelCapsMethodName.NotCamelCaps |
|
33 | - public function get_query() |
|
34 | - { |
|
35 | - return EEM_Attendee::instance(); |
|
36 | - } |
|
37 | - |
|
38 | - |
|
39 | - /** |
|
40 | - * Return an array of item IDs from the query |
|
41 | - * |
|
42 | - * @return array |
|
43 | - */ |
|
44 | - // phpcs:ignore PSR1.Methods.CamelCapsMethodName.NotCamelCaps |
|
45 | - public function get_ids() |
|
46 | - { |
|
47 | - $results = $this->query->get_col($this->query_args); |
|
48 | - |
|
49 | - return ! empty($results) ? $results : []; |
|
50 | - } |
|
51 | - |
|
52 | - |
|
53 | - /** |
|
54 | - * Here, we map the args from the input, then we make sure that we're only querying |
|
55 | - * for IDs. The IDs are then passed down the resolve tree, and deferred resolvers |
|
56 | - * handle batch resolution of the posts. |
|
57 | - * |
|
58 | - * @return array |
|
59 | - * @throws EE_Error |
|
60 | - * @throws InvalidArgumentException |
|
61 | - * @throws ReflectionException |
|
62 | - * @throws InvalidDataTypeException |
|
63 | - * @throws InvalidInterfaceException |
|
64 | - */ |
|
65 | - // phpcs:ignore PSR1.Methods.CamelCapsMethodName.NotCamelCaps |
|
66 | - public function get_query_args() |
|
67 | - { |
|
68 | - $where_params = []; |
|
69 | - $query_args = []; |
|
70 | - |
|
71 | - $query_args['limit'] = $this->getLimit(); |
|
72 | - |
|
73 | - // Avoid multiple entries by join. |
|
74 | - $query_args['group_by'] = 'ATT_ID'; |
|
75 | - |
|
76 | - $query_args['default_where_conditions'] = 'minimum'; |
|
77 | - |
|
78 | - /** |
|
79 | - * Collect the input_fields and sanitize them to prepare them for sending to the Query |
|
80 | - */ |
|
81 | - $input_fields = []; |
|
82 | - if (! empty($this->args['where'])) { |
|
83 | - $input_fields = $this->sanitizeInputFields($this->args['where']); |
|
84 | - |
|
85 | - // Since we do not have any falsy values in query params |
|
86 | - // Lets get rid of empty values |
|
87 | - $input_fields = array_filter($input_fields); |
|
88 | - |
|
89 | - // Use the proper operator. |
|
90 | - if (! empty($input_fields['Registration.Event.EVT_ID']) && is_array($input_fields['Registration.Event.EVT_ID'])) { |
|
91 | - $input_fields['Registration.Event.EVT_ID'] = ['IN', $input_fields['Registration.Event.EVT_ID']]; |
|
92 | - } |
|
93 | - if (! empty($input_fields['Registration.Ticket.TKT_ID']) && is_array($input_fields['Registration.Ticket.TKT_ID'])) { |
|
94 | - $input_fields['Registration.Ticket.TKT_ID'] = ['IN', $input_fields['Registration.Ticket.TKT_ID']]; |
|
95 | - } |
|
96 | - // If Ticket param is passed, it will have preference over Datetime param |
|
97 | - // So, use Datetime param only if a Ticket param is not passed |
|
98 | - if (! empty($input_fields['Datetime.DTT_ID']) && empty($input_fields['Registration.Ticket.TKT_ID'])) { |
|
99 | - $datetimeIds = $input_fields['Datetime.DTT_ID']; |
|
100 | - // Make sure it's an array, ready for "IN" operator |
|
101 | - $datetimeIds = is_array($datetimeIds) ? $datetimeIds : [$datetimeIds]; |
|
102 | - |
|
103 | - try { |
|
104 | - // Get related ticket IDs for the given dates |
|
105 | - $ticketIds = EEM_Ticket::instance()->get_col([ |
|
106 | - [ |
|
107 | - 'Datetime.DTT_ID' => ['IN', $datetimeIds], |
|
108 | - 'TKT_deleted' => ['IN', [true, false]], |
|
109 | - ], |
|
110 | - 'default_where_conditions' => 'minimum', |
|
111 | - ]); |
|
112 | - } catch (Throwable $th) { |
|
113 | - $ticketIds = []; |
|
114 | - } |
|
115 | - |
|
116 | - if (!empty($ticketIds)) { |
|
117 | - $input_fields['Registration.Ticket.TKT_ID'] = ['IN', $ticketIds]; |
|
118 | - } |
|
119 | - } |
|
120 | - // Since there is no relation between Attendee and Datetime, we need to remove it |
|
121 | - unset($input_fields['Datetime.DTT_ID']); |
|
122 | - } |
|
123 | - |
|
124 | - /** |
|
125 | - * Merge the input_fields with the default query_args |
|
126 | - */ |
|
127 | - if (! empty($input_fields)) { |
|
128 | - $where_params = array_merge($where_params, $input_fields); |
|
129 | - } |
|
130 | - |
|
131 | - list($query_args, $where_params) = $this->mapOrderbyInputArgs($query_args, $where_params, 'ATT_ID'); |
|
132 | - |
|
133 | - $query_args[] = $where_params; |
|
134 | - |
|
135 | - /** |
|
136 | - * Return the $query_args |
|
137 | - */ |
|
138 | - return $query_args; |
|
139 | - } |
|
140 | - |
|
141 | - |
|
142 | - /** |
|
143 | - * This sets up the "allowed" args, and translates the GraphQL-friendly keys to model |
|
144 | - * friendly keys. |
|
145 | - * |
|
146 | - * @param array $where_args |
|
147 | - * @return array |
|
148 | - */ |
|
149 | - public function sanitizeInputFields(array $where_args) |
|
150 | - { |
|
151 | - $arg_mapping = [ |
|
152 | - // There is no direct relation between Attendee and Datetime |
|
153 | - // But we will handle it via Tickets related to given dates |
|
154 | - 'datetime' => 'Datetime.DTT_ID', |
|
155 | - 'datetimeIn' => 'Datetime.DTT_ID', |
|
156 | - 'event' => 'Registration.Event.EVT_ID', |
|
157 | - 'eventIn' => 'Registration.Event.EVT_ID', |
|
158 | - 'regTicket' => 'Registration.Ticket.TKT_ID', |
|
159 | - 'regTicketIn' => 'Registration.Ticket.TKT_ID', |
|
160 | - 'regTicketIdIn' => 'Registration.Ticket.TKT_ID', |
|
161 | - 'regTicketId' => 'Registration.Ticket.TKT_ID', // priority. |
|
162 | - 'regStatus' => 'Registration.Status.STS_ID', |
|
163 | - ]; |
|
164 | - return $this->sanitizeWhereArgsForInputFields( |
|
165 | - $where_args, |
|
166 | - $arg_mapping, |
|
167 | - ['datetime', 'datetimeIn', 'event', 'eventIn', 'regTicket', 'regTicketIn'] |
|
168 | - ); |
|
169 | - } |
|
19 | + // phpcs:ignore PSR1.Methods.CamelCapsMethodName.NotCamelCaps |
|
20 | + public function get_loader_name() |
|
21 | + { |
|
22 | + return 'espresso_attendee'; |
|
23 | + } |
|
24 | + |
|
25 | + /** |
|
26 | + * @return EEM_Attendee |
|
27 | + * @throws EE_Error |
|
28 | + * @throws InvalidArgumentException |
|
29 | + * @throws InvalidDataTypeException |
|
30 | + * @throws InvalidInterfaceException |
|
31 | + */ |
|
32 | + // phpcs:ignore PSR1.Methods.CamelCapsMethodName.NotCamelCaps |
|
33 | + public function get_query() |
|
34 | + { |
|
35 | + return EEM_Attendee::instance(); |
|
36 | + } |
|
37 | + |
|
38 | + |
|
39 | + /** |
|
40 | + * Return an array of item IDs from the query |
|
41 | + * |
|
42 | + * @return array |
|
43 | + */ |
|
44 | + // phpcs:ignore PSR1.Methods.CamelCapsMethodName.NotCamelCaps |
|
45 | + public function get_ids() |
|
46 | + { |
|
47 | + $results = $this->query->get_col($this->query_args); |
|
48 | + |
|
49 | + return ! empty($results) ? $results : []; |
|
50 | + } |
|
51 | + |
|
52 | + |
|
53 | + /** |
|
54 | + * Here, we map the args from the input, then we make sure that we're only querying |
|
55 | + * for IDs. The IDs are then passed down the resolve tree, and deferred resolvers |
|
56 | + * handle batch resolution of the posts. |
|
57 | + * |
|
58 | + * @return array |
|
59 | + * @throws EE_Error |
|
60 | + * @throws InvalidArgumentException |
|
61 | + * @throws ReflectionException |
|
62 | + * @throws InvalidDataTypeException |
|
63 | + * @throws InvalidInterfaceException |
|
64 | + */ |
|
65 | + // phpcs:ignore PSR1.Methods.CamelCapsMethodName.NotCamelCaps |
|
66 | + public function get_query_args() |
|
67 | + { |
|
68 | + $where_params = []; |
|
69 | + $query_args = []; |
|
70 | + |
|
71 | + $query_args['limit'] = $this->getLimit(); |
|
72 | + |
|
73 | + // Avoid multiple entries by join. |
|
74 | + $query_args['group_by'] = 'ATT_ID'; |
|
75 | + |
|
76 | + $query_args['default_where_conditions'] = 'minimum'; |
|
77 | + |
|
78 | + /** |
|
79 | + * Collect the input_fields and sanitize them to prepare them for sending to the Query |
|
80 | + */ |
|
81 | + $input_fields = []; |
|
82 | + if (! empty($this->args['where'])) { |
|
83 | + $input_fields = $this->sanitizeInputFields($this->args['where']); |
|
84 | + |
|
85 | + // Since we do not have any falsy values in query params |
|
86 | + // Lets get rid of empty values |
|
87 | + $input_fields = array_filter($input_fields); |
|
88 | + |
|
89 | + // Use the proper operator. |
|
90 | + if (! empty($input_fields['Registration.Event.EVT_ID']) && is_array($input_fields['Registration.Event.EVT_ID'])) { |
|
91 | + $input_fields['Registration.Event.EVT_ID'] = ['IN', $input_fields['Registration.Event.EVT_ID']]; |
|
92 | + } |
|
93 | + if (! empty($input_fields['Registration.Ticket.TKT_ID']) && is_array($input_fields['Registration.Ticket.TKT_ID'])) { |
|
94 | + $input_fields['Registration.Ticket.TKT_ID'] = ['IN', $input_fields['Registration.Ticket.TKT_ID']]; |
|
95 | + } |
|
96 | + // If Ticket param is passed, it will have preference over Datetime param |
|
97 | + // So, use Datetime param only if a Ticket param is not passed |
|
98 | + if (! empty($input_fields['Datetime.DTT_ID']) && empty($input_fields['Registration.Ticket.TKT_ID'])) { |
|
99 | + $datetimeIds = $input_fields['Datetime.DTT_ID']; |
|
100 | + // Make sure it's an array, ready for "IN" operator |
|
101 | + $datetimeIds = is_array($datetimeIds) ? $datetimeIds : [$datetimeIds]; |
|
102 | + |
|
103 | + try { |
|
104 | + // Get related ticket IDs for the given dates |
|
105 | + $ticketIds = EEM_Ticket::instance()->get_col([ |
|
106 | + [ |
|
107 | + 'Datetime.DTT_ID' => ['IN', $datetimeIds], |
|
108 | + 'TKT_deleted' => ['IN', [true, false]], |
|
109 | + ], |
|
110 | + 'default_where_conditions' => 'minimum', |
|
111 | + ]); |
|
112 | + } catch (Throwable $th) { |
|
113 | + $ticketIds = []; |
|
114 | + } |
|
115 | + |
|
116 | + if (!empty($ticketIds)) { |
|
117 | + $input_fields['Registration.Ticket.TKT_ID'] = ['IN', $ticketIds]; |
|
118 | + } |
|
119 | + } |
|
120 | + // Since there is no relation between Attendee and Datetime, we need to remove it |
|
121 | + unset($input_fields['Datetime.DTT_ID']); |
|
122 | + } |
|
123 | + |
|
124 | + /** |
|
125 | + * Merge the input_fields with the default query_args |
|
126 | + */ |
|
127 | + if (! empty($input_fields)) { |
|
128 | + $where_params = array_merge($where_params, $input_fields); |
|
129 | + } |
|
130 | + |
|
131 | + list($query_args, $where_params) = $this->mapOrderbyInputArgs($query_args, $where_params, 'ATT_ID'); |
|
132 | + |
|
133 | + $query_args[] = $where_params; |
|
134 | + |
|
135 | + /** |
|
136 | + * Return the $query_args |
|
137 | + */ |
|
138 | + return $query_args; |
|
139 | + } |
|
140 | + |
|
141 | + |
|
142 | + /** |
|
143 | + * This sets up the "allowed" args, and translates the GraphQL-friendly keys to model |
|
144 | + * friendly keys. |
|
145 | + * |
|
146 | + * @param array $where_args |
|
147 | + * @return array |
|
148 | + */ |
|
149 | + public function sanitizeInputFields(array $where_args) |
|
150 | + { |
|
151 | + $arg_mapping = [ |
|
152 | + // There is no direct relation between Attendee and Datetime |
|
153 | + // But we will handle it via Tickets related to given dates |
|
154 | + 'datetime' => 'Datetime.DTT_ID', |
|
155 | + 'datetimeIn' => 'Datetime.DTT_ID', |
|
156 | + 'event' => 'Registration.Event.EVT_ID', |
|
157 | + 'eventIn' => 'Registration.Event.EVT_ID', |
|
158 | + 'regTicket' => 'Registration.Ticket.TKT_ID', |
|
159 | + 'regTicketIn' => 'Registration.Ticket.TKT_ID', |
|
160 | + 'regTicketIdIn' => 'Registration.Ticket.TKT_ID', |
|
161 | + 'regTicketId' => 'Registration.Ticket.TKT_ID', // priority. |
|
162 | + 'regStatus' => 'Registration.Status.STS_ID', |
|
163 | + ]; |
|
164 | + return $this->sanitizeWhereArgsForInputFields( |
|
165 | + $where_args, |
|
166 | + $arg_mapping, |
|
167 | + ['datetime', 'datetimeIn', 'event', 'eventIn', 'regTicket', 'regTicketIn'] |
|
168 | + ); |
|
169 | + } |
|
170 | 170 | } |
@@ -15,161 +15,161 @@ |
||
15 | 15 | */ |
16 | 16 | class PriceConnectionResolver extends AbstractConnectionResolver |
17 | 17 | { |
18 | - // phpcs:ignore PSR1.Methods.CamelCapsMethodName.NotCamelCaps |
|
19 | - public function get_loader_name() |
|
20 | - { |
|
21 | - return 'espresso_price'; |
|
22 | - } |
|
23 | - |
|
24 | - /** |
|
25 | - * @return EEM_Price |
|
26 | - * @throws EE_Error |
|
27 | - * @throws InvalidArgumentException |
|
28 | - * @throws InvalidDataTypeException |
|
29 | - * @throws InvalidInterfaceException |
|
30 | - */ |
|
31 | - // phpcs:ignore PSR1.Methods.CamelCapsMethodName.NotCamelCaps |
|
32 | - public function get_query() |
|
33 | - { |
|
34 | - return EEM_Price::instance(); |
|
35 | - } |
|
36 | - |
|
37 | - |
|
38 | - /** |
|
39 | - * Return an array of item IDs from the query |
|
40 | - * |
|
41 | - * @return array |
|
42 | - */ |
|
43 | - // phpcs:ignore PSR1.Methods.CamelCapsMethodName.NotCamelCaps |
|
44 | - public function get_ids() |
|
45 | - { |
|
46 | - $results = $this->query->get_col($this->query_args); |
|
47 | - |
|
48 | - return ! empty($results) ? $results : []; |
|
49 | - } |
|
50 | - |
|
51 | - |
|
52 | - /** |
|
53 | - * Here, we map the args from the input, then we make sure that we're only querying |
|
54 | - * for IDs. The IDs are then passed down the resolve tree, and deferred resolvers |
|
55 | - * handle batch resolution of the posts. |
|
56 | - * |
|
57 | - * @return array |
|
58 | - * @throws EE_Error |
|
59 | - * @throws InvalidArgumentException |
|
60 | - * @throws ReflectionException |
|
61 | - * @throws InvalidDataTypeException |
|
62 | - * @throws InvalidInterfaceException |
|
63 | - */ |
|
64 | - // phpcs:ignore PSR1.Methods.CamelCapsMethodName.NotCamelCaps |
|
65 | - public function get_query_args() |
|
66 | - { |
|
67 | - $where_params = []; |
|
68 | - $query_args = []; |
|
69 | - |
|
70 | - $query_args['limit'] = $this->getLimit(); |
|
71 | - |
|
72 | - // Avoid multiple entries by join. |
|
73 | - $query_args['group_by'] = 'PRC_ID'; |
|
74 | - |
|
75 | - $query_args['default_where_conditions'] = 'minimum'; |
|
76 | - |
|
77 | - /** |
|
78 | - * Collect the input_fields and sanitize them to prepare them for sending to the Query |
|
79 | - */ |
|
80 | - $input_fields = []; |
|
81 | - if (! empty($this->args['where'])) { |
|
82 | - $input_fields = $this->sanitizeInputFields($this->args['where']); |
|
83 | - |
|
84 | - // Use the proper operator. |
|
85 | - if (! empty($input_fields['PRC_ID']) && is_array($input_fields['PRC_ID'])) { |
|
86 | - $input_fields['PRC_ID'] = ['in', $input_fields['PRC_ID']]; |
|
87 | - } |
|
88 | - if (! empty($input_fields['Ticket.TKT_ID']) && is_array($input_fields['Ticket.TKT_ID'])) { |
|
89 | - $input_fields['Ticket.TKT_ID'] = ['in', $input_fields['Ticket.TKT_ID']]; |
|
90 | - } |
|
91 | - if (! empty($input_fields['Price_Type.PBT_ID']) && is_array($input_fields['Price_Type.PBT_ID'])) { |
|
92 | - $input_fields['Price_Type.PBT_ID'] = ['in', $input_fields['Price_Type.PBT_ID']]; |
|
93 | - } |
|
94 | - if (! empty($input_fields['Price_Type.PRT_ID']) && is_array($input_fields['Price_Type.PRT_ID'])) { |
|
95 | - $input_fields['Price_Type.PRT_ID'] = ['in', $input_fields['Price_Type.PRT_ID']]; |
|
96 | - } |
|
97 | - } |
|
98 | - |
|
99 | - /** |
|
100 | - * Determine where we're at in the Graph and adjust the query context appropriately. |
|
101 | - */ |
|
102 | - if ($this->source instanceof EE_Ticket) { |
|
103 | - $where_params['Ticket.TKT_ID'] = $this->source->ID(); |
|
104 | - } |
|
105 | - |
|
106 | - /** |
|
107 | - * Merge the input_fields with the default query_args |
|
108 | - */ |
|
109 | - if (! empty($input_fields)) { |
|
110 | - $where_params = array_merge($where_params, $input_fields); |
|
111 | - } |
|
112 | - |
|
113 | - list($query_args, $where_params) = $this->mapOrderbyInputArgs($query_args, $where_params, 'PRC_ID'); |
|
114 | - |
|
115 | - // If default prices should be included. |
|
116 | - if (! empty($this->args['where']['includeDefaultPrices'])) { |
|
117 | - /** |
|
118 | - * We need to get each price that |
|
119 | - * - satisfies $where_params above |
|
120 | - * OR |
|
121 | - * - it's a default non trashed price |
|
122 | - */ |
|
123 | - $where_params = [ |
|
124 | - 'OR' => [ |
|
125 | - // use extra OR instead of AND to avoid it getting overridden |
|
126 | - 'OR' => [ |
|
127 | - 'AND' => [ |
|
128 | - 'PRC_deleted' => 0, |
|
129 | - 'PRC_is_default' => 1, |
|
130 | - ] |
|
131 | - ], |
|
132 | - 'AND' => $where_params, |
|
133 | - ], |
|
134 | - ]; |
|
135 | - } |
|
136 | - |
|
137 | - $query_args[] = $where_params; |
|
138 | - |
|
139 | - /** |
|
140 | - * Return the $query_args |
|
141 | - */ |
|
142 | - return $query_args; |
|
143 | - } |
|
144 | - |
|
145 | - |
|
146 | - /** |
|
147 | - * This sets up the "allowed" args, and translates the GraphQL-friendly keys to model |
|
148 | - * friendly keys. |
|
149 | - * |
|
150 | - * @param array $where_args |
|
151 | - * @return array |
|
152 | - */ |
|
153 | - public function sanitizeInputFields(array $where_args) |
|
154 | - { |
|
155 | - $arg_mapping = [ |
|
156 | - 'in' => 'PRC_ID', |
|
157 | - 'idIn' => 'PRC_ID', |
|
158 | - 'ticket' => 'Ticket.TKT_ID', |
|
159 | - 'ticketIn' => 'Ticket.TKT_ID', |
|
160 | - 'ticketIdIn' => 'Ticket.TKT_ID', |
|
161 | - 'ticketId' => 'Ticket.TKT_ID', // priority. |
|
162 | - 'priceType' => 'Price_Type.PRT_ID', |
|
163 | - 'priceTypeIn' => 'Price_Type.PRT_ID', |
|
164 | - 'priceTypeIdIn' => 'Price_Type.PRT_ID', |
|
165 | - 'priceTypeId' => 'Price_Type.PRT_ID', // priority. |
|
166 | - 'priceBaseType' => 'Price_Type.PBT_ID', |
|
167 | - 'priceBaseTypeIn' => 'Price_Type.PBT_ID', |
|
168 | - ]; |
|
169 | - return $this->sanitizeWhereArgsForInputFields( |
|
170 | - $where_args, |
|
171 | - $arg_mapping, |
|
172 | - ['in', 'ticket', 'ticketIn', 'priceType', 'priceTypeIn'] |
|
173 | - ); |
|
174 | - } |
|
18 | + // phpcs:ignore PSR1.Methods.CamelCapsMethodName.NotCamelCaps |
|
19 | + public function get_loader_name() |
|
20 | + { |
|
21 | + return 'espresso_price'; |
|
22 | + } |
|
23 | + |
|
24 | + /** |
|
25 | + * @return EEM_Price |
|
26 | + * @throws EE_Error |
|
27 | + * @throws InvalidArgumentException |
|
28 | + * @throws InvalidDataTypeException |
|
29 | + * @throws InvalidInterfaceException |
|
30 | + */ |
|
31 | + // phpcs:ignore PSR1.Methods.CamelCapsMethodName.NotCamelCaps |
|
32 | + public function get_query() |
|
33 | + { |
|
34 | + return EEM_Price::instance(); |
|
35 | + } |
|
36 | + |
|
37 | + |
|
38 | + /** |
|
39 | + * Return an array of item IDs from the query |
|
40 | + * |
|
41 | + * @return array |
|
42 | + */ |
|
43 | + // phpcs:ignore PSR1.Methods.CamelCapsMethodName.NotCamelCaps |
|
44 | + public function get_ids() |
|
45 | + { |
|
46 | + $results = $this->query->get_col($this->query_args); |
|
47 | + |
|
48 | + return ! empty($results) ? $results : []; |
|
49 | + } |
|
50 | + |
|
51 | + |
|
52 | + /** |
|
53 | + * Here, we map the args from the input, then we make sure that we're only querying |
|
54 | + * for IDs. The IDs are then passed down the resolve tree, and deferred resolvers |
|
55 | + * handle batch resolution of the posts. |
|
56 | + * |
|
57 | + * @return array |
|
58 | + * @throws EE_Error |
|
59 | + * @throws InvalidArgumentException |
|
60 | + * @throws ReflectionException |
|
61 | + * @throws InvalidDataTypeException |
|
62 | + * @throws InvalidInterfaceException |
|
63 | + */ |
|
64 | + // phpcs:ignore PSR1.Methods.CamelCapsMethodName.NotCamelCaps |
|
65 | + public function get_query_args() |
|
66 | + { |
|
67 | + $where_params = []; |
|
68 | + $query_args = []; |
|
69 | + |
|
70 | + $query_args['limit'] = $this->getLimit(); |
|
71 | + |
|
72 | + // Avoid multiple entries by join. |
|
73 | + $query_args['group_by'] = 'PRC_ID'; |
|
74 | + |
|
75 | + $query_args['default_where_conditions'] = 'minimum'; |
|
76 | + |
|
77 | + /** |
|
78 | + * Collect the input_fields and sanitize them to prepare them for sending to the Query |
|
79 | + */ |
|
80 | + $input_fields = []; |
|
81 | + if (! empty($this->args['where'])) { |
|
82 | + $input_fields = $this->sanitizeInputFields($this->args['where']); |
|
83 | + |
|
84 | + // Use the proper operator. |
|
85 | + if (! empty($input_fields['PRC_ID']) && is_array($input_fields['PRC_ID'])) { |
|
86 | + $input_fields['PRC_ID'] = ['in', $input_fields['PRC_ID']]; |
|
87 | + } |
|
88 | + if (! empty($input_fields['Ticket.TKT_ID']) && is_array($input_fields['Ticket.TKT_ID'])) { |
|
89 | + $input_fields['Ticket.TKT_ID'] = ['in', $input_fields['Ticket.TKT_ID']]; |
|
90 | + } |
|
91 | + if (! empty($input_fields['Price_Type.PBT_ID']) && is_array($input_fields['Price_Type.PBT_ID'])) { |
|
92 | + $input_fields['Price_Type.PBT_ID'] = ['in', $input_fields['Price_Type.PBT_ID']]; |
|
93 | + } |
|
94 | + if (! empty($input_fields['Price_Type.PRT_ID']) && is_array($input_fields['Price_Type.PRT_ID'])) { |
|
95 | + $input_fields['Price_Type.PRT_ID'] = ['in', $input_fields['Price_Type.PRT_ID']]; |
|
96 | + } |
|
97 | + } |
|
98 | + |
|
99 | + /** |
|
100 | + * Determine where we're at in the Graph and adjust the query context appropriately. |
|
101 | + */ |
|
102 | + if ($this->source instanceof EE_Ticket) { |
|
103 | + $where_params['Ticket.TKT_ID'] = $this->source->ID(); |
|
104 | + } |
|
105 | + |
|
106 | + /** |
|
107 | + * Merge the input_fields with the default query_args |
|
108 | + */ |
|
109 | + if (! empty($input_fields)) { |
|
110 | + $where_params = array_merge($where_params, $input_fields); |
|
111 | + } |
|
112 | + |
|
113 | + list($query_args, $where_params) = $this->mapOrderbyInputArgs($query_args, $where_params, 'PRC_ID'); |
|
114 | + |
|
115 | + // If default prices should be included. |
|
116 | + if (! empty($this->args['where']['includeDefaultPrices'])) { |
|
117 | + /** |
|
118 | + * We need to get each price that |
|
119 | + * - satisfies $where_params above |
|
120 | + * OR |
|
121 | + * - it's a default non trashed price |
|
122 | + */ |
|
123 | + $where_params = [ |
|
124 | + 'OR' => [ |
|
125 | + // use extra OR instead of AND to avoid it getting overridden |
|
126 | + 'OR' => [ |
|
127 | + 'AND' => [ |
|
128 | + 'PRC_deleted' => 0, |
|
129 | + 'PRC_is_default' => 1, |
|
130 | + ] |
|
131 | + ], |
|
132 | + 'AND' => $where_params, |
|
133 | + ], |
|
134 | + ]; |
|
135 | + } |
|
136 | + |
|
137 | + $query_args[] = $where_params; |
|
138 | + |
|
139 | + /** |
|
140 | + * Return the $query_args |
|
141 | + */ |
|
142 | + return $query_args; |
|
143 | + } |
|
144 | + |
|
145 | + |
|
146 | + /** |
|
147 | + * This sets up the "allowed" args, and translates the GraphQL-friendly keys to model |
|
148 | + * friendly keys. |
|
149 | + * |
|
150 | + * @param array $where_args |
|
151 | + * @return array |
|
152 | + */ |
|
153 | + public function sanitizeInputFields(array $where_args) |
|
154 | + { |
|
155 | + $arg_mapping = [ |
|
156 | + 'in' => 'PRC_ID', |
|
157 | + 'idIn' => 'PRC_ID', |
|
158 | + 'ticket' => 'Ticket.TKT_ID', |
|
159 | + 'ticketIn' => 'Ticket.TKT_ID', |
|
160 | + 'ticketIdIn' => 'Ticket.TKT_ID', |
|
161 | + 'ticketId' => 'Ticket.TKT_ID', // priority. |
|
162 | + 'priceType' => 'Price_Type.PRT_ID', |
|
163 | + 'priceTypeIn' => 'Price_Type.PRT_ID', |
|
164 | + 'priceTypeIdIn' => 'Price_Type.PRT_ID', |
|
165 | + 'priceTypeId' => 'Price_Type.PRT_ID', // priority. |
|
166 | + 'priceBaseType' => 'Price_Type.PBT_ID', |
|
167 | + 'priceBaseTypeIn' => 'Price_Type.PBT_ID', |
|
168 | + ]; |
|
169 | + return $this->sanitizeWhereArgsForInputFields( |
|
170 | + $where_args, |
|
171 | + $arg_mapping, |
|
172 | + ['in', 'ticket', 'ticketIn', 'priceType', 'priceTypeIn'] |
|
173 | + ); |
|
174 | + } |
|
175 | 175 | } |
@@ -18,182 +18,182 @@ |
||
18 | 18 | { |
19 | 19 | |
20 | 20 | |
21 | - /** |
|
22 | - * Determine whether the Query should execute. If it's determined that the query should |
|
23 | - * not be run based on context such as, but not limited to, who the user is, where in the |
|
24 | - * ResolveTree the Query is, the relation to the node the Query is connected to, etc |
|
25 | - * Return false to prevent the query from executing. |
|
26 | - * |
|
27 | - * @return bool |
|
28 | - */ |
|
29 | - // phpcs:ignore PSR1.Methods.CamelCapsMethodName.NotCamelCaps |
|
30 | - public function should_execute() |
|
31 | - { |
|
32 | - return $this->should_execute; |
|
33 | - } |
|
34 | - |
|
35 | - /** |
|
36 | - * Set limit the highest value of first and last, with a (filterable) max of 100 |
|
37 | - * |
|
38 | - * @return array |
|
39 | - */ |
|
40 | - protected function getLimit() |
|
41 | - { |
|
42 | - $first = ! empty($this->args['first']) ? absint($this->args['first']) : null; |
|
43 | - $last = ! empty($this->args['last']) ? absint($this->args['last']) : null; |
|
44 | - |
|
45 | - $limit = min( |
|
46 | - max($first, $last, 100), |
|
47 | - $this->query_amount |
|
48 | - ); |
|
49 | - $limit++; |
|
50 | - return $limit; |
|
51 | - } |
|
52 | - |
|
53 | - /** |
|
54 | - * Get_amount_requested |
|
55 | - * |
|
56 | - * This checks the $args to determine the amount requested |
|
57 | - * |
|
58 | - * @return int|null |
|
59 | - * @throws \Exception |
|
60 | - */ |
|
61 | - // phpcs:ignore PSR1.Methods.CamelCapsMethodName.NotCamelCaps |
|
62 | - public function get_amount_requested() |
|
63 | - { |
|
64 | - $amount_requested = parent::get_amount_requested(); |
|
65 | - |
|
66 | - /** |
|
67 | - * If both first & last are used in the input args, throw an exception as that won't |
|
68 | - * work properly |
|
69 | - */ |
|
70 | - if (empty($this->args['first']) && empty($this->args['last']) && $amount_requested === 10) { |
|
71 | - return 100; // default. |
|
72 | - } |
|
73 | - |
|
74 | - return $amount_requested; |
|
75 | - } |
|
76 | - |
|
77 | - /** |
|
78 | - * Determine whether or not the the offset is valid, i.e the entity corresponding to the |
|
79 | - * offset exists. Offset is equivalent to entity ID. So this function is equivalent to |
|
80 | - * checking if the entity with the given ID exists. |
|
81 | - * |
|
82 | - * @access public |
|
83 | - * |
|
84 | - * @param int $offset The ID of the node used for the cursor offset |
|
85 | - * |
|
86 | - * @return bool |
|
87 | - */ |
|
88 | - // phpcs:ignore PSR1.Methods.CamelCapsMethodName.NotCamelCaps |
|
89 | - public function is_valid_offset($offset) |
|
90 | - { |
|
91 | - $entity = $this->get_query()->get_one_by_ID($offset); |
|
21 | + /** |
|
22 | + * Determine whether the Query should execute. If it's determined that the query should |
|
23 | + * not be run based on context such as, but not limited to, who the user is, where in the |
|
24 | + * ResolveTree the Query is, the relation to the node the Query is connected to, etc |
|
25 | + * Return false to prevent the query from executing. |
|
26 | + * |
|
27 | + * @return bool |
|
28 | + */ |
|
29 | + // phpcs:ignore PSR1.Methods.CamelCapsMethodName.NotCamelCaps |
|
30 | + public function should_execute() |
|
31 | + { |
|
32 | + return $this->should_execute; |
|
33 | + } |
|
34 | + |
|
35 | + /** |
|
36 | + * Set limit the highest value of first and last, with a (filterable) max of 100 |
|
37 | + * |
|
38 | + * @return array |
|
39 | + */ |
|
40 | + protected function getLimit() |
|
41 | + { |
|
42 | + $first = ! empty($this->args['first']) ? absint($this->args['first']) : null; |
|
43 | + $last = ! empty($this->args['last']) ? absint($this->args['last']) : null; |
|
44 | + |
|
45 | + $limit = min( |
|
46 | + max($first, $last, 100), |
|
47 | + $this->query_amount |
|
48 | + ); |
|
49 | + $limit++; |
|
50 | + return $limit; |
|
51 | + } |
|
52 | + |
|
53 | + /** |
|
54 | + * Get_amount_requested |
|
55 | + * |
|
56 | + * This checks the $args to determine the amount requested |
|
57 | + * |
|
58 | + * @return int|null |
|
59 | + * @throws \Exception |
|
60 | + */ |
|
61 | + // phpcs:ignore PSR1.Methods.CamelCapsMethodName.NotCamelCaps |
|
62 | + public function get_amount_requested() |
|
63 | + { |
|
64 | + $amount_requested = parent::get_amount_requested(); |
|
65 | + |
|
66 | + /** |
|
67 | + * If both first & last are used in the input args, throw an exception as that won't |
|
68 | + * work properly |
|
69 | + */ |
|
70 | + if (empty($this->args['first']) && empty($this->args['last']) && $amount_requested === 10) { |
|
71 | + return 100; // default. |
|
72 | + } |
|
73 | + |
|
74 | + return $amount_requested; |
|
75 | + } |
|
76 | + |
|
77 | + /** |
|
78 | + * Determine whether or not the the offset is valid, i.e the entity corresponding to the |
|
79 | + * offset exists. Offset is equivalent to entity ID. So this function is equivalent to |
|
80 | + * checking if the entity with the given ID exists. |
|
81 | + * |
|
82 | + * @access public |
|
83 | + * |
|
84 | + * @param int $offset The ID of the node used for the cursor offset |
|
85 | + * |
|
86 | + * @return bool |
|
87 | + */ |
|
88 | + // phpcs:ignore PSR1.Methods.CamelCapsMethodName.NotCamelCaps |
|
89 | + public function is_valid_offset($offset) |
|
90 | + { |
|
91 | + $entity = $this->get_query()->get_one_by_ID($offset); |
|
92 | 92 | |
93 | - return $entity instanceof EE_Base_Class; |
|
94 | - } |
|
95 | - |
|
96 | - /** |
|
97 | - * Validates Model. |
|
98 | - * |
|
99 | - * @param array $entity Entity node. |
|
100 | - * |
|
101 | - * @return bool |
|
102 | - */ |
|
103 | - // phpcs:ignore PSR1.Methods.CamelCapsMethodName.NotCamelCaps |
|
104 | - protected function is_valid_model($entity) |
|
105 | - { |
|
106 | - return $entity instanceof EE_Base_Class; |
|
107 | - } |
|
108 | - |
|
109 | - |
|
110 | - /** |
|
111 | - * This sets up the "allowed" args, and translates the GraphQL-friendly keys to model |
|
112 | - * friendly keys. |
|
113 | - * |
|
114 | - * @param array $query_args |
|
115 | - * @param array $where_params |
|
116 | - * @param string $primary_key |
|
117 | - * @return array |
|
118 | - */ |
|
119 | - protected function mapOrderbyInputArgs(array $query_args, array $where_params, $primary_key) |
|
120 | - { |
|
121 | - // ID of the current offset |
|
122 | - $offset = $this->get_offset(); |
|
123 | - /** |
|
124 | - * Map the orderby inputArgs to the WP_Query |
|
125 | - */ |
|
126 | - if (! empty($this->args['where']['orderby']) && is_array($this->args['where']['orderby'])) { |
|
127 | - $query_args['order_by'] = []; |
|
128 | - foreach ($this->args['where']['orderby'] as $orderby_input) { |
|
129 | - $query_args['order_by'][ $orderby_input['field'] ] = $orderby_input['order']; |
|
130 | - } |
|
131 | - } elseif ($offset) { |
|
132 | - $compare = $this->args['last'] ? '<' : '>'; |
|
133 | - $where_params[ $primary_key ] = [ $compare, $offset ]; |
|
134 | - } |
|
135 | - return [ $query_args, $where_params ]; |
|
136 | - } |
|
137 | - |
|
138 | - |
|
139 | - /** |
|
140 | - * This sets up the "allowed" args, and translates the GraphQL-friendly keys to model |
|
141 | - * friendly keys. |
|
142 | - * |
|
143 | - * @param array $where_args |
|
144 | - * @param array $arg_mapping |
|
145 | - * @param array $id_fields The fields to convert from global IDs to DB IDs. |
|
146 | - * @return array |
|
147 | - */ |
|
148 | - protected function sanitizeWhereArgsForInputFields( |
|
149 | - array $where_args, |
|
150 | - array $arg_mapping, |
|
151 | - array $id_fields |
|
152 | - ) { |
|
153 | - $query_args = []; |
|
154 | - |
|
155 | - foreach ($where_args as $arg => $value) { |
|
156 | - if (! array_key_exists($arg, $arg_mapping)) { |
|
157 | - continue; |
|
158 | - } |
|
159 | - |
|
160 | - if (is_array($value) && ! empty($value)) { |
|
161 | - $value = array_map( |
|
162 | - static function ($value) { |
|
163 | - if (is_string($value)) { |
|
164 | - $value = sanitize_text_field($value); |
|
165 | - } |
|
166 | - return $value; |
|
167 | - }, |
|
168 | - $value |
|
169 | - ); |
|
170 | - } elseif (is_string($value)) { |
|
171 | - $value = sanitize_text_field($value); |
|
172 | - } |
|
173 | - $query_args[ $arg_mapping[ $arg ] ] = in_array($arg, $id_fields, true) |
|
174 | - ? $this->convertGlobalId($value) |
|
175 | - : $value; |
|
176 | - } |
|
177 | - |
|
178 | - /** |
|
179 | - * Return the Query Args |
|
180 | - */ |
|
181 | - return ! empty($query_args) && is_array($query_args) ? $query_args : []; |
|
182 | - } |
|
183 | - |
|
184 | - |
|
185 | - /** |
|
186 | - * Converts global ID to DB ID. |
|
187 | - * |
|
188 | - * @param string|string[] $ID |
|
189 | - * @return mixed |
|
190 | - */ |
|
191 | - protected function convertGlobalId($ID) |
|
192 | - { |
|
193 | - if (is_array($ID)) { |
|
194 | - return array_map([ $this, 'convertGlobalId' ], $ID); |
|
195 | - } |
|
196 | - $parts = Relay::fromGlobalId($ID); |
|
197 | - return ! empty($parts['id']) ? $parts['id'] : null; |
|
198 | - } |
|
93 | + return $entity instanceof EE_Base_Class; |
|
94 | + } |
|
95 | + |
|
96 | + /** |
|
97 | + * Validates Model. |
|
98 | + * |
|
99 | + * @param array $entity Entity node. |
|
100 | + * |
|
101 | + * @return bool |
|
102 | + */ |
|
103 | + // phpcs:ignore PSR1.Methods.CamelCapsMethodName.NotCamelCaps |
|
104 | + protected function is_valid_model($entity) |
|
105 | + { |
|
106 | + return $entity instanceof EE_Base_Class; |
|
107 | + } |
|
108 | + |
|
109 | + |
|
110 | + /** |
|
111 | + * This sets up the "allowed" args, and translates the GraphQL-friendly keys to model |
|
112 | + * friendly keys. |
|
113 | + * |
|
114 | + * @param array $query_args |
|
115 | + * @param array $where_params |
|
116 | + * @param string $primary_key |
|
117 | + * @return array |
|
118 | + */ |
|
119 | + protected function mapOrderbyInputArgs(array $query_args, array $where_params, $primary_key) |
|
120 | + { |
|
121 | + // ID of the current offset |
|
122 | + $offset = $this->get_offset(); |
|
123 | + /** |
|
124 | + * Map the orderby inputArgs to the WP_Query |
|
125 | + */ |
|
126 | + if (! empty($this->args['where']['orderby']) && is_array($this->args['where']['orderby'])) { |
|
127 | + $query_args['order_by'] = []; |
|
128 | + foreach ($this->args['where']['orderby'] as $orderby_input) { |
|
129 | + $query_args['order_by'][ $orderby_input['field'] ] = $orderby_input['order']; |
|
130 | + } |
|
131 | + } elseif ($offset) { |
|
132 | + $compare = $this->args['last'] ? '<' : '>'; |
|
133 | + $where_params[ $primary_key ] = [ $compare, $offset ]; |
|
134 | + } |
|
135 | + return [ $query_args, $where_params ]; |
|
136 | + } |
|
137 | + |
|
138 | + |
|
139 | + /** |
|
140 | + * This sets up the "allowed" args, and translates the GraphQL-friendly keys to model |
|
141 | + * friendly keys. |
|
142 | + * |
|
143 | + * @param array $where_args |
|
144 | + * @param array $arg_mapping |
|
145 | + * @param array $id_fields The fields to convert from global IDs to DB IDs. |
|
146 | + * @return array |
|
147 | + */ |
|
148 | + protected function sanitizeWhereArgsForInputFields( |
|
149 | + array $where_args, |
|
150 | + array $arg_mapping, |
|
151 | + array $id_fields |
|
152 | + ) { |
|
153 | + $query_args = []; |
|
154 | + |
|
155 | + foreach ($where_args as $arg => $value) { |
|
156 | + if (! array_key_exists($arg, $arg_mapping)) { |
|
157 | + continue; |
|
158 | + } |
|
159 | + |
|
160 | + if (is_array($value) && ! empty($value)) { |
|
161 | + $value = array_map( |
|
162 | + static function ($value) { |
|
163 | + if (is_string($value)) { |
|
164 | + $value = sanitize_text_field($value); |
|
165 | + } |
|
166 | + return $value; |
|
167 | + }, |
|
168 | + $value |
|
169 | + ); |
|
170 | + } elseif (is_string($value)) { |
|
171 | + $value = sanitize_text_field($value); |
|
172 | + } |
|
173 | + $query_args[ $arg_mapping[ $arg ] ] = in_array($arg, $id_fields, true) |
|
174 | + ? $this->convertGlobalId($value) |
|
175 | + : $value; |
|
176 | + } |
|
177 | + |
|
178 | + /** |
|
179 | + * Return the Query Args |
|
180 | + */ |
|
181 | + return ! empty($query_args) && is_array($query_args) ? $query_args : []; |
|
182 | + } |
|
183 | + |
|
184 | + |
|
185 | + /** |
|
186 | + * Converts global ID to DB ID. |
|
187 | + * |
|
188 | + * @param string|string[] $ID |
|
189 | + * @return mixed |
|
190 | + */ |
|
191 | + protected function convertGlobalId($ID) |
|
192 | + { |
|
193 | + if (is_array($ID)) { |
|
194 | + return array_map([ $this, 'convertGlobalId' ], $ID); |
|
195 | + } |
|
196 | + $parts = Relay::fromGlobalId($ID); |
|
197 | + return ! empty($parts['id']) ? $parts['id'] : null; |
|
198 | + } |
|
199 | 199 | } |
@@ -15,122 +15,122 @@ |
||
15 | 15 | */ |
16 | 16 | class TicketConnectionResolver extends AbstractConnectionResolver |
17 | 17 | { |
18 | - // phpcs:ignore PSR1.Methods.CamelCapsMethodName.NotCamelCaps |
|
19 | - public function get_loader_name() |
|
20 | - { |
|
21 | - return 'espresso_ticket'; |
|
22 | - } |
|
23 | - |
|
24 | - /** |
|
25 | - * @return EEM_Ticket |
|
26 | - * @throws EE_Error |
|
27 | - * @throws InvalidArgumentException |
|
28 | - * @throws InvalidDataTypeException |
|
29 | - * @throws InvalidInterfaceException |
|
30 | - */ |
|
31 | - // phpcs:ignore PSR1.Methods.CamelCapsMethodName.NotCamelCaps |
|
32 | - public function get_query() |
|
33 | - { |
|
34 | - return EEM_Ticket::instance(); |
|
35 | - } |
|
36 | - |
|
37 | - |
|
38 | - /** |
|
39 | - * Return an array of item IDs from the query |
|
40 | - * |
|
41 | - * @return array |
|
42 | - */ |
|
43 | - // phpcs:ignore PSR1.Methods.CamelCapsMethodName.NotCamelCaps |
|
44 | - public function get_ids() |
|
45 | - { |
|
46 | - $results = $this->query->get_col($this->query_args); |
|
47 | - |
|
48 | - return ! empty($results) ? $results : []; |
|
49 | - } |
|
50 | - |
|
51 | - |
|
52 | - /** |
|
53 | - * Here, we map the args from the input, then we make sure that we're only querying |
|
54 | - * for IDs. The IDs are then passed down the resolve tree, and deferred resolvers |
|
55 | - * handle batch resolution of the posts. |
|
56 | - * |
|
57 | - * @return array |
|
58 | - * @throws EE_Error |
|
59 | - * @throws InvalidArgumentException |
|
60 | - * @throws ReflectionException |
|
61 | - * @throws InvalidDataTypeException |
|
62 | - * @throws InvalidInterfaceException |
|
63 | - */ |
|
64 | - // phpcs:ignore PSR1.Methods.CamelCapsMethodName.NotCamelCaps |
|
65 | - public function get_query_args() |
|
66 | - { |
|
67 | - $where_params = ['TKT_deleted' => ['IN', [true, false]]]; |
|
68 | - $query_args = []; |
|
69 | - |
|
70 | - $query_args['limit'] = $this->getLimit(); |
|
71 | - |
|
72 | - // Avoid multiple entries by join. |
|
73 | - $query_args['group_by'] = 'TKT_ID'; |
|
74 | - |
|
75 | - $query_args['default_where_conditions'] = 'minimum'; |
|
76 | - |
|
77 | - /** |
|
78 | - * Collect the input_fields and sanitize them to prepare them for sending to the Query |
|
79 | - */ |
|
80 | - $input_fields = []; |
|
81 | - if (! empty($this->args['where'])) { |
|
82 | - $input_fields = $this->sanitizeInputFields($this->args['where']); |
|
83 | - |
|
84 | - // Use the proper operator. |
|
85 | - if (! empty($input_fields['Datetime.DTT_ID']) && is_array($input_fields['Datetime.DTT_ID'])) { |
|
86 | - $input_fields['Datetime.DTT_ID'] = ['in', $input_fields['Datetime.DTT_ID']]; |
|
87 | - } |
|
88 | - } |
|
89 | - |
|
90 | - /** |
|
91 | - * Determine where we're at in the Graph and adjust the query context appropriately. |
|
92 | - */ |
|
93 | - if ($this->source instanceof EE_Datetime) { |
|
94 | - $where_params['Datetime.DTT_ID'] = $this->source->ID(); |
|
95 | - } |
|
96 | - |
|
97 | - /** |
|
98 | - * Merge the input_fields with the default query_args |
|
99 | - */ |
|
100 | - if (! empty($input_fields)) { |
|
101 | - $where_params = array_merge($where_params, $input_fields); |
|
102 | - } |
|
103 | - |
|
104 | - list($query_args, $where_params) = $this->mapOrderbyInputArgs($query_args, $where_params, 'TKT_ID'); |
|
105 | - |
|
106 | - $query_args[] = $where_params; |
|
107 | - |
|
108 | - /** |
|
109 | - * Return the $query_args |
|
110 | - */ |
|
111 | - return $query_args; |
|
112 | - } |
|
113 | - |
|
114 | - |
|
115 | - /** |
|
116 | - * This sets up the "allowed" args, and translates the GraphQL-friendly keys to model |
|
117 | - * friendly keys. |
|
118 | - * |
|
119 | - * @param array $where_args |
|
120 | - * @return array |
|
121 | - */ |
|
122 | - public function sanitizeInputFields(array $where_args) |
|
123 | - { |
|
124 | - $arg_mapping = [ |
|
125 | - 'datetime' => 'Datetime.DTT_ID', |
|
126 | - 'datetimeIn' => 'Datetime.DTT_ID', |
|
127 | - 'datetimeIdIn' => 'Datetime.DTT_ID', |
|
128 | - 'datetimeId' => 'Datetime.DTT_ID', // priority. |
|
129 | - ]; |
|
130 | - return $this->sanitizeWhereArgsForInputFields( |
|
131 | - $where_args, |
|
132 | - $arg_mapping, |
|
133 | - ['datetime', 'datetimeIn'] |
|
134 | - ); |
|
135 | - } |
|
18 | + // phpcs:ignore PSR1.Methods.CamelCapsMethodName.NotCamelCaps |
|
19 | + public function get_loader_name() |
|
20 | + { |
|
21 | + return 'espresso_ticket'; |
|
22 | + } |
|
23 | + |
|
24 | + /** |
|
25 | + * @return EEM_Ticket |
|
26 | + * @throws EE_Error |
|
27 | + * @throws InvalidArgumentException |
|
28 | + * @throws InvalidDataTypeException |
|
29 | + * @throws InvalidInterfaceException |
|
30 | + */ |
|
31 | + // phpcs:ignore PSR1.Methods.CamelCapsMethodName.NotCamelCaps |
|
32 | + public function get_query() |
|
33 | + { |
|
34 | + return EEM_Ticket::instance(); |
|
35 | + } |
|
36 | + |
|
37 | + |
|
38 | + /** |
|
39 | + * Return an array of item IDs from the query |
|
40 | + * |
|
41 | + * @return array |
|
42 | + */ |
|
43 | + // phpcs:ignore PSR1.Methods.CamelCapsMethodName.NotCamelCaps |
|
44 | + public function get_ids() |
|
45 | + { |
|
46 | + $results = $this->query->get_col($this->query_args); |
|
47 | + |
|
48 | + return ! empty($results) ? $results : []; |
|
49 | + } |
|
50 | + |
|
51 | + |
|
52 | + /** |
|
53 | + * Here, we map the args from the input, then we make sure that we're only querying |
|
54 | + * for IDs. The IDs are then passed down the resolve tree, and deferred resolvers |
|
55 | + * handle batch resolution of the posts. |
|
56 | + * |
|
57 | + * @return array |
|
58 | + * @throws EE_Error |
|
59 | + * @throws InvalidArgumentException |
|
60 | + * @throws ReflectionException |
|
61 | + * @throws InvalidDataTypeException |
|
62 | + * @throws InvalidInterfaceException |
|
63 | + */ |
|
64 | + // phpcs:ignore PSR1.Methods.CamelCapsMethodName.NotCamelCaps |
|
65 | + public function get_query_args() |
|
66 | + { |
|
67 | + $where_params = ['TKT_deleted' => ['IN', [true, false]]]; |
|
68 | + $query_args = []; |
|
69 | + |
|
70 | + $query_args['limit'] = $this->getLimit(); |
|
71 | + |
|
72 | + // Avoid multiple entries by join. |
|
73 | + $query_args['group_by'] = 'TKT_ID'; |
|
74 | + |
|
75 | + $query_args['default_where_conditions'] = 'minimum'; |
|
76 | + |
|
77 | + /** |
|
78 | + * Collect the input_fields and sanitize them to prepare them for sending to the Query |
|
79 | + */ |
|
80 | + $input_fields = []; |
|
81 | + if (! empty($this->args['where'])) { |
|
82 | + $input_fields = $this->sanitizeInputFields($this->args['where']); |
|
83 | + |
|
84 | + // Use the proper operator. |
|
85 | + if (! empty($input_fields['Datetime.DTT_ID']) && is_array($input_fields['Datetime.DTT_ID'])) { |
|
86 | + $input_fields['Datetime.DTT_ID'] = ['in', $input_fields['Datetime.DTT_ID']]; |
|
87 | + } |
|
88 | + } |
|
89 | + |
|
90 | + /** |
|
91 | + * Determine where we're at in the Graph and adjust the query context appropriately. |
|
92 | + */ |
|
93 | + if ($this->source instanceof EE_Datetime) { |
|
94 | + $where_params['Datetime.DTT_ID'] = $this->source->ID(); |
|
95 | + } |
|
96 | + |
|
97 | + /** |
|
98 | + * Merge the input_fields with the default query_args |
|
99 | + */ |
|
100 | + if (! empty($input_fields)) { |
|
101 | + $where_params = array_merge($where_params, $input_fields); |
|
102 | + } |
|
103 | + |
|
104 | + list($query_args, $where_params) = $this->mapOrderbyInputArgs($query_args, $where_params, 'TKT_ID'); |
|
105 | + |
|
106 | + $query_args[] = $where_params; |
|
107 | + |
|
108 | + /** |
|
109 | + * Return the $query_args |
|
110 | + */ |
|
111 | + return $query_args; |
|
112 | + } |
|
113 | + |
|
114 | + |
|
115 | + /** |
|
116 | + * This sets up the "allowed" args, and translates the GraphQL-friendly keys to model |
|
117 | + * friendly keys. |
|
118 | + * |
|
119 | + * @param array $where_args |
|
120 | + * @return array |
|
121 | + */ |
|
122 | + public function sanitizeInputFields(array $where_args) |
|
123 | + { |
|
124 | + $arg_mapping = [ |
|
125 | + 'datetime' => 'Datetime.DTT_ID', |
|
126 | + 'datetimeIn' => 'Datetime.DTT_ID', |
|
127 | + 'datetimeIdIn' => 'Datetime.DTT_ID', |
|
128 | + 'datetimeId' => 'Datetime.DTT_ID', // priority. |
|
129 | + ]; |
|
130 | + return $this->sanitizeWhereArgsForInputFields( |
|
131 | + $where_args, |
|
132 | + $arg_mapping, |
|
133 | + ['datetime', 'datetimeIn'] |
|
134 | + ); |
|
135 | + } |
|
136 | 136 | } |