@@ -18,186 +18,186 @@ |
||
| 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 | - * Determine whether the Query should execute. If it's determined that the query should |
|
| 55 | - * not be run based on context such as, but not limited to, who the user is, where in the |
|
| 56 | - * ResolveTree the Query is, the relation to the node the Query is connected to, etc |
|
| 57 | - * |
|
| 58 | - * Return false to prevent the query from executing. |
|
| 59 | - * |
|
| 60 | - * @return bool |
|
| 61 | - */ |
|
| 62 | - // phpcs:ignore PSR1.Methods.CamelCapsMethodName.NotCamelCaps |
|
| 63 | - public function should_execute() |
|
| 64 | - { |
|
| 65 | - if (false === $this->should_execute) { |
|
| 66 | - return false; |
|
| 67 | - } |
|
| 68 | - |
|
| 69 | - return $this->should_execute; |
|
| 70 | - } |
|
| 71 | - |
|
| 72 | - /** |
|
| 73 | - * Here, we map the args from the input, then we make sure that we're only querying |
|
| 74 | - * for IDs. The IDs are then passed down the resolve tree, and deferred resolvers |
|
| 75 | - * handle batch resolution of the posts. |
|
| 76 | - * |
|
| 77 | - * @return array |
|
| 78 | - * @throws EE_Error |
|
| 79 | - * @throws InvalidArgumentException |
|
| 80 | - * @throws InvalidDataTypeException |
|
| 81 | - * @throws InvalidInterfaceException |
|
| 82 | - */ |
|
| 83 | - // phpcs:ignore PSR1.Methods.CamelCapsMethodName.NotCamelCaps |
|
| 84 | - public function get_query_args() |
|
| 85 | - { |
|
| 86 | - $where_params = ['DTT_deleted' => ['IN', [true, false]]]; |
|
| 87 | - $query_args = []; |
|
| 88 | - |
|
| 89 | - $query_args['limit'] = $this->getLimit(); |
|
| 90 | - |
|
| 91 | - // Avoid multiple entries by join. |
|
| 92 | - $query_args['group_by'] = 'DTT_ID'; |
|
| 93 | - |
|
| 94 | - /** |
|
| 95 | - * Collect the input_fields and sanitize them to prepare them for sending to the Query |
|
| 96 | - */ |
|
| 97 | - $input_fields = []; |
|
| 98 | - if (! empty($this->args['where'])) { |
|
| 99 | - $input_fields = $this->sanitizeInputFields($this->args['where']); |
|
| 100 | - |
|
| 101 | - // Use the proper operator. |
|
| 102 | - if (! empty($input_fields['EVT_ID']) && is_array($input_fields['EVT_ID'])) { |
|
| 103 | - $input_fields['EVT_ID'] = ['in', $input_fields['EVT_ID']]; |
|
| 104 | - } |
|
| 105 | - if (! empty($input_fields['Ticket.TKT_ID']) && is_array($input_fields['Ticket.TKT_ID'])) { |
|
| 106 | - $input_fields['Ticket.TKT_ID'] = ['in', $input_fields['Ticket.TKT_ID']]; |
|
| 107 | - } |
|
| 108 | - } |
|
| 109 | - |
|
| 110 | - /** |
|
| 111 | - * Determine where we're at in the Graph and adjust the query context appropriately. |
|
| 112 | - * |
|
| 113 | - * For example, if we're querying for datetime as a field of event query, this will automatically |
|
| 114 | - * set the query to pull datetimes that belong to that event. |
|
| 115 | - * We can set more cases for other source types. |
|
| 116 | - */ |
|
| 117 | - if (is_object($this->source)) { |
|
| 118 | - switch (true) { |
|
| 119 | - // It's surely an event |
|
| 120 | - case $this->source instanceof Post: |
|
| 121 | - $where_params['EVT_ID'] = $this->source->ID; |
|
| 122 | - break; |
|
| 123 | - case $this->source instanceof EE_Event: |
|
| 124 | - $where_params['EVT_ID'] = $this->source->ID(); |
|
| 125 | - break; |
|
| 126 | - case $this->source instanceof EE_Ticket: |
|
| 127 | - $where_params['Ticket.TKT_ID'] = $this->source->ID(); |
|
| 128 | - break; |
|
| 129 | - case $this->source instanceof EE_Checkin: |
|
| 130 | - $where_params['Checkin.CHK_ID'] = $this->source->ID(); |
|
| 131 | - break; |
|
| 132 | - } |
|
| 133 | - } |
|
| 134 | - |
|
| 135 | - /** |
|
| 136 | - * Merge the input_fields with the default query_args |
|
| 137 | - */ |
|
| 138 | - if (! empty($input_fields)) { |
|
| 139 | - $where_params = array_merge($where_params, $input_fields); |
|
| 140 | - } |
|
| 141 | - |
|
| 142 | - list($query_args, $where_params) = $this->mapOrderbyInputArgs($query_args, $where_params, 'DTT_ID'); |
|
| 143 | - |
|
| 144 | - if (! empty($this->args['where']['upcoming'])) { |
|
| 145 | - $where_params['DTT_EVT_start'] = array( |
|
| 146 | - '>', |
|
| 147 | - EEM_Datetime::instance()->current_time_for_query('DTT_EVT_start') |
|
| 148 | - ); |
|
| 149 | - } |
|
| 150 | - |
|
| 151 | - if (! empty($this->args['where']['active'])) { |
|
| 152 | - $where_params['DTT_EVT_start'] = array( |
|
| 153 | - '<', |
|
| 154 | - EEM_Datetime::instance()->current_time_for_query('DTT_EVT_start') |
|
| 155 | - ); |
|
| 156 | - $where_params['DTT_EVT_end'] = array( |
|
| 157 | - '>', |
|
| 158 | - EEM_Datetime::instance()->current_time_for_query('DTT_EVT_end') |
|
| 159 | - ); |
|
| 160 | - } |
|
| 161 | - |
|
| 162 | - if (! empty($this->args['where']['expired'])) { |
|
| 163 | - $where_params['DTT_EVT_end'] = array( |
|
| 164 | - '<', |
|
| 165 | - EEM_Datetime::instance()->current_time_for_query('DTT_EVT_end') |
|
| 166 | - ); |
|
| 167 | - } |
|
| 168 | - |
|
| 169 | - $query_args[] = $where_params; |
|
| 170 | - |
|
| 171 | - /** |
|
| 172 | - * Return the $query_args |
|
| 173 | - */ |
|
| 174 | - return $query_args; |
|
| 175 | - } |
|
| 176 | - |
|
| 177 | - |
|
| 178 | - /** |
|
| 179 | - * This sets up the "allowed" args, and translates the GraphQL-friendly keys to model |
|
| 180 | - * friendly keys. |
|
| 181 | - * |
|
| 182 | - * @param array $where_args |
|
| 183 | - * @return array |
|
| 184 | - */ |
|
| 185 | - public function sanitizeInputFields(array $where_args) |
|
| 186 | - { |
|
| 187 | - $arg_mapping = [ |
|
| 188 | - 'event' => 'EVT_ID', |
|
| 189 | - 'eventIn' => 'EVT_ID', |
|
| 190 | - 'eventId' => 'EVT_ID', |
|
| 191 | - 'eventIdIn' => 'EVT_ID', |
|
| 192 | - 'ticket' => 'Ticket.TKT_ID', |
|
| 193 | - 'ticketIn' => 'Ticket.TKT_ID', |
|
| 194 | - 'ticketId' => 'Ticket.TKT_ID', |
|
| 195 | - 'ticketIdIn' => 'Ticket.TKT_ID', |
|
| 196 | - ]; |
|
| 197 | - return $this->sanitizeWhereArgsForInputFields( |
|
| 198 | - $where_args, |
|
| 199 | - $arg_mapping, |
|
| 200 | - ['event', 'eventIn', 'ticket', 'ticketIn'] |
|
| 201 | - ); |
|
| 202 | - } |
|
| 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 | + * Determine whether the Query should execute. If it's determined that the query should |
|
| 55 | + * not be run based on context such as, but not limited to, who the user is, where in the |
|
| 56 | + * ResolveTree the Query is, the relation to the node the Query is connected to, etc |
|
| 57 | + * |
|
| 58 | + * Return false to prevent the query from executing. |
|
| 59 | + * |
|
| 60 | + * @return bool |
|
| 61 | + */ |
|
| 62 | + // phpcs:ignore PSR1.Methods.CamelCapsMethodName.NotCamelCaps |
|
| 63 | + public function should_execute() |
|
| 64 | + { |
|
| 65 | + if (false === $this->should_execute) { |
|
| 66 | + return false; |
|
| 67 | + } |
|
| 68 | + |
|
| 69 | + return $this->should_execute; |
|
| 70 | + } |
|
| 71 | + |
|
| 72 | + /** |
|
| 73 | + * Here, we map the args from the input, then we make sure that we're only querying |
|
| 74 | + * for IDs. The IDs are then passed down the resolve tree, and deferred resolvers |
|
| 75 | + * handle batch resolution of the posts. |
|
| 76 | + * |
|
| 77 | + * @return array |
|
| 78 | + * @throws EE_Error |
|
| 79 | + * @throws InvalidArgumentException |
|
| 80 | + * @throws InvalidDataTypeException |
|
| 81 | + * @throws InvalidInterfaceException |
|
| 82 | + */ |
|
| 83 | + // phpcs:ignore PSR1.Methods.CamelCapsMethodName.NotCamelCaps |
|
| 84 | + public function get_query_args() |
|
| 85 | + { |
|
| 86 | + $where_params = ['DTT_deleted' => ['IN', [true, false]]]; |
|
| 87 | + $query_args = []; |
|
| 88 | + |
|
| 89 | + $query_args['limit'] = $this->getLimit(); |
|
| 90 | + |
|
| 91 | + // Avoid multiple entries by join. |
|
| 92 | + $query_args['group_by'] = 'DTT_ID'; |
|
| 93 | + |
|
| 94 | + /** |
|
| 95 | + * Collect the input_fields and sanitize them to prepare them for sending to the Query |
|
| 96 | + */ |
|
| 97 | + $input_fields = []; |
|
| 98 | + if (! empty($this->args['where'])) { |
|
| 99 | + $input_fields = $this->sanitizeInputFields($this->args['where']); |
|
| 100 | + |
|
| 101 | + // Use the proper operator. |
|
| 102 | + if (! empty($input_fields['EVT_ID']) && is_array($input_fields['EVT_ID'])) { |
|
| 103 | + $input_fields['EVT_ID'] = ['in', $input_fields['EVT_ID']]; |
|
| 104 | + } |
|
| 105 | + if (! empty($input_fields['Ticket.TKT_ID']) && is_array($input_fields['Ticket.TKT_ID'])) { |
|
| 106 | + $input_fields['Ticket.TKT_ID'] = ['in', $input_fields['Ticket.TKT_ID']]; |
|
| 107 | + } |
|
| 108 | + } |
|
| 109 | + |
|
| 110 | + /** |
|
| 111 | + * Determine where we're at in the Graph and adjust the query context appropriately. |
|
| 112 | + * |
|
| 113 | + * For example, if we're querying for datetime as a field of event query, this will automatically |
|
| 114 | + * set the query to pull datetimes that belong to that event. |
|
| 115 | + * We can set more cases for other source types. |
|
| 116 | + */ |
|
| 117 | + if (is_object($this->source)) { |
|
| 118 | + switch (true) { |
|
| 119 | + // It's surely an event |
|
| 120 | + case $this->source instanceof Post: |
|
| 121 | + $where_params['EVT_ID'] = $this->source->ID; |
|
| 122 | + break; |
|
| 123 | + case $this->source instanceof EE_Event: |
|
| 124 | + $where_params['EVT_ID'] = $this->source->ID(); |
|
| 125 | + break; |
|
| 126 | + case $this->source instanceof EE_Ticket: |
|
| 127 | + $where_params['Ticket.TKT_ID'] = $this->source->ID(); |
|
| 128 | + break; |
|
| 129 | + case $this->source instanceof EE_Checkin: |
|
| 130 | + $where_params['Checkin.CHK_ID'] = $this->source->ID(); |
|
| 131 | + break; |
|
| 132 | + } |
|
| 133 | + } |
|
| 134 | + |
|
| 135 | + /** |
|
| 136 | + * Merge the input_fields with the default query_args |
|
| 137 | + */ |
|
| 138 | + if (! empty($input_fields)) { |
|
| 139 | + $where_params = array_merge($where_params, $input_fields); |
|
| 140 | + } |
|
| 141 | + |
|
| 142 | + list($query_args, $where_params) = $this->mapOrderbyInputArgs($query_args, $where_params, 'DTT_ID'); |
|
| 143 | + |
|
| 144 | + if (! empty($this->args['where']['upcoming'])) { |
|
| 145 | + $where_params['DTT_EVT_start'] = array( |
|
| 146 | + '>', |
|
| 147 | + EEM_Datetime::instance()->current_time_for_query('DTT_EVT_start') |
|
| 148 | + ); |
|
| 149 | + } |
|
| 150 | + |
|
| 151 | + if (! empty($this->args['where']['active'])) { |
|
| 152 | + $where_params['DTT_EVT_start'] = array( |
|
| 153 | + '<', |
|
| 154 | + EEM_Datetime::instance()->current_time_for_query('DTT_EVT_start') |
|
| 155 | + ); |
|
| 156 | + $where_params['DTT_EVT_end'] = array( |
|
| 157 | + '>', |
|
| 158 | + EEM_Datetime::instance()->current_time_for_query('DTT_EVT_end') |
|
| 159 | + ); |
|
| 160 | + } |
|
| 161 | + |
|
| 162 | + if (! empty($this->args['where']['expired'])) { |
|
| 163 | + $where_params['DTT_EVT_end'] = array( |
|
| 164 | + '<', |
|
| 165 | + EEM_Datetime::instance()->current_time_for_query('DTT_EVT_end') |
|
| 166 | + ); |
|
| 167 | + } |
|
| 168 | + |
|
| 169 | + $query_args[] = $where_params; |
|
| 170 | + |
|
| 171 | + /** |
|
| 172 | + * Return the $query_args |
|
| 173 | + */ |
|
| 174 | + return $query_args; |
|
| 175 | + } |
|
| 176 | + |
|
| 177 | + |
|
| 178 | + /** |
|
| 179 | + * This sets up the "allowed" args, and translates the GraphQL-friendly keys to model |
|
| 180 | + * friendly keys. |
|
| 181 | + * |
|
| 182 | + * @param array $where_args |
|
| 183 | + * @return array |
|
| 184 | + */ |
|
| 185 | + public function sanitizeInputFields(array $where_args) |
|
| 186 | + { |
|
| 187 | + $arg_mapping = [ |
|
| 188 | + 'event' => 'EVT_ID', |
|
| 189 | + 'eventIn' => 'EVT_ID', |
|
| 190 | + 'eventId' => 'EVT_ID', |
|
| 191 | + 'eventIdIn' => 'EVT_ID', |
|
| 192 | + 'ticket' => 'Ticket.TKT_ID', |
|
| 193 | + 'ticketIn' => 'Ticket.TKT_ID', |
|
| 194 | + 'ticketId' => 'Ticket.TKT_ID', |
|
| 195 | + 'ticketIdIn' => 'Ticket.TKT_ID', |
|
| 196 | + ]; |
|
| 197 | + return $this->sanitizeWhereArgsForInputFields( |
|
| 198 | + $where_args, |
|
| 199 | + $arg_mapping, |
|
| 200 | + ['event', 'eventIn', 'ticket', 'ticketIn'] |
|
| 201 | + ); |
|
| 202 | + } |
|
| 203 | 203 | } |
@@ -14,85 +14,85 @@ |
||
| 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 | - * Determine whether the Query should execute. If it's determined that the query should |
|
| 53 | - * not be run based on context such as, but not limited to, who the user is, where in the |
|
| 54 | - * ResolveTree the Query is, the relation to the node the Query is connected to, etc |
|
| 55 | - * Return false to prevent the query from executing. |
|
| 56 | - * |
|
| 57 | - * @return bool |
|
| 58 | - */ |
|
| 59 | - // phpcs:ignore PSR1.Methods.CamelCapsMethodName.NotCamelCaps |
|
| 60 | - public function should_execute() |
|
| 61 | - { |
|
| 62 | - if ($this->should_execute === false) { |
|
| 63 | - return false; |
|
| 64 | - } |
|
| 51 | + /** |
|
| 52 | + * Determine whether the Query should execute. If it's determined that the query should |
|
| 53 | + * not be run based on context such as, but not limited to, who the user is, where in the |
|
| 54 | + * ResolveTree the Query is, the relation to the node the Query is connected to, etc |
|
| 55 | + * Return false to prevent the query from executing. |
|
| 56 | + * |
|
| 57 | + * @return bool |
|
| 58 | + */ |
|
| 59 | + // phpcs:ignore PSR1.Methods.CamelCapsMethodName.NotCamelCaps |
|
| 60 | + public function should_execute() |
|
| 61 | + { |
|
| 62 | + if ($this->should_execute === false) { |
|
| 63 | + return false; |
|
| 64 | + } |
|
| 65 | 65 | |
| 66 | - return $this->should_execute; |
|
| 67 | - } |
|
| 66 | + return $this->should_execute; |
|
| 67 | + } |
|
| 68 | 68 | |
| 69 | 69 | |
| 70 | - /** |
|
| 71 | - * Here, we map the args from the input, then we make sure that we're only querying |
|
| 72 | - * for IDs. The IDs are then passed down the resolve tree, and deferred resolvers |
|
| 73 | - * handle batch resolution of the posts. |
|
| 74 | - * |
|
| 75 | - * @return array |
|
| 76 | - * @throws EE_Error |
|
| 77 | - * @throws InvalidArgumentException |
|
| 78 | - * @throws ReflectionException |
|
| 79 | - * @throws InvalidDataTypeException |
|
| 80 | - * @throws InvalidInterfaceException |
|
| 81 | - */ |
|
| 82 | - // phpcs:ignore PSR1.Methods.CamelCapsMethodName.NotCamelCaps |
|
| 83 | - public function get_query_args() |
|
| 84 | - { |
|
| 85 | - $where_params = []; |
|
| 86 | - $query_args = []; |
|
| 70 | + /** |
|
| 71 | + * Here, we map the args from the input, then we make sure that we're only querying |
|
| 72 | + * for IDs. The IDs are then passed down the resolve tree, and deferred resolvers |
|
| 73 | + * handle batch resolution of the posts. |
|
| 74 | + * |
|
| 75 | + * @return array |
|
| 76 | + * @throws EE_Error |
|
| 77 | + * @throws InvalidArgumentException |
|
| 78 | + * @throws ReflectionException |
|
| 79 | + * @throws InvalidDataTypeException |
|
| 80 | + * @throws InvalidInterfaceException |
|
| 81 | + */ |
|
| 82 | + // phpcs:ignore PSR1.Methods.CamelCapsMethodName.NotCamelCaps |
|
| 83 | + public function get_query_args() |
|
| 84 | + { |
|
| 85 | + $where_params = []; |
|
| 86 | + $query_args = []; |
|
| 87 | 87 | |
| 88 | - $query_args['limit'] = $this->getLimit(); |
|
| 88 | + $query_args['limit'] = $this->getLimit(); |
|
| 89 | 89 | |
| 90 | - // Avoid multiple entries by join. |
|
| 91 | - $query_args['group_by'] = 'PRT_ID'; |
|
| 90 | + // Avoid multiple entries by join. |
|
| 91 | + $query_args['group_by'] = 'PRT_ID'; |
|
| 92 | 92 | |
| 93 | - /** |
|
| 94 | - * Return the $query_args |
|
| 95 | - */ |
|
| 96 | - return $query_args; |
|
| 97 | - } |
|
| 93 | + /** |
|
| 94 | + * Return the $query_args |
|
| 95 | + */ |
|
| 96 | + return $query_args; |
|
| 97 | + } |
|
| 98 | 98 | } |
@@ -16,145 +16,145 @@ |
||
| 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 | - * Determine whether the Query should execute. If it's determined that the query should |
|
| 55 | - * not be run based on context such as, but not limited to, who the user is, where in the |
|
| 56 | - * ResolveTree the Query is, the relation to the node the Query is connected to, etc |
|
| 57 | - * Return false to prevent the query from executing. |
|
| 58 | - * |
|
| 59 | - * @return bool |
|
| 60 | - */ |
|
| 61 | - // phpcs:ignore PSR1.Methods.CamelCapsMethodName.NotCamelCaps |
|
| 62 | - public function should_execute() |
|
| 63 | - { |
|
| 64 | - if (false === $this->should_execute) { |
|
| 65 | - return false; |
|
| 66 | - } |
|
| 67 | - |
|
| 68 | - return $this->should_execute; |
|
| 69 | - } |
|
| 70 | - |
|
| 71 | - |
|
| 72 | - /** |
|
| 73 | - * Here, we map the args from the input, then we make sure that we're only querying |
|
| 74 | - * for IDs. The IDs are then passed down the resolve tree, and deferred resolvers |
|
| 75 | - * handle batch resolution of the posts. |
|
| 76 | - * |
|
| 77 | - * @return array |
|
| 78 | - */ |
|
| 79 | - // phpcs:ignore PSR1.Methods.CamelCapsMethodName.NotCamelCaps |
|
| 80 | - public function get_query_args() |
|
| 81 | - { |
|
| 82 | - $query_args = []; |
|
| 83 | - |
|
| 84 | - /** |
|
| 85 | - * Prepare for later use |
|
| 86 | - */ |
|
| 87 | - $last = ! empty($this->args['last']) ? $this->args['last'] : null; |
|
| 88 | - $first = ! empty($this->args['first']) ? $this->args['first'] : null; |
|
| 89 | - |
|
| 90 | - /** |
|
| 91 | - * Set limit the highest value of $first and $last, with a (filterable) max of 100 |
|
| 92 | - */ |
|
| 93 | - $query_args['limit'] = min( |
|
| 94 | - max(absint($first), absint($last), 10), |
|
| 95 | - $this->query_amount |
|
| 96 | - ) + 1; |
|
| 97 | - |
|
| 98 | - /** |
|
| 99 | - * Collect the input_fields and sanitize them to prepare them for sending to the Query |
|
| 100 | - */ |
|
| 101 | - $input_fields = []; |
|
| 102 | - if (! empty($this->args['where'])) { |
|
| 103 | - $input_fields = $this->sanitize_input_fields($this->args['where']); |
|
| 104 | - } |
|
| 105 | - |
|
| 106 | - /** |
|
| 107 | - * Determine where we're at in the Graph and adjust the query context appropriately. |
|
| 108 | - * For example, if we're querying for datetime as a field of event query, this will automatically |
|
| 109 | - * set the query to pull datetimes that belong to that event. |
|
| 110 | - * We can set more cases for other source types. |
|
| 111 | - */ |
|
| 112 | - if (is_object($this->source)) { |
|
| 113 | - switch (true) { |
|
| 114 | - // Assumed to be an event |
|
| 115 | - case $this->source instanceof Post: |
|
| 116 | - $query_args[] = ['Event.EVT_ID' => $this->source->ID]; |
|
| 117 | - break; |
|
| 118 | - case $this->source instanceof EE_Event: |
|
| 119 | - $query_args[] = ['Event.EVT_ID' => $this->source->ID()]; |
|
| 120 | - break; |
|
| 121 | - } |
|
| 122 | - } |
|
| 123 | - |
|
| 124 | - /** |
|
| 125 | - * Merge the input_fields with the default query_args |
|
| 126 | - */ |
|
| 127 | - if (! empty($input_fields)) { |
|
| 128 | - $query_args = array_merge($query_args, $input_fields); |
|
| 129 | - } |
|
| 130 | - |
|
| 131 | - /** |
|
| 132 | - * Return the $query_args |
|
| 133 | - */ |
|
| 134 | - return $query_args; |
|
| 135 | - } |
|
| 136 | - |
|
| 137 | - |
|
| 138 | - /** |
|
| 139 | - * This sets up the "allowed" args, and translates the GraphQL-friendly keys to WP_Query |
|
| 140 | - * friendly keys. There's probably a cleaner/more dynamic way to approach this, but |
|
| 141 | - * this was quick. I'd be down to explore more dynamic ways to map this, but for |
|
| 142 | - * now this gets the job done. |
|
| 143 | - * |
|
| 144 | - * @param array $query_args |
|
| 145 | - * @return array |
|
| 146 | - */ |
|
| 147 | - // phpcs:ignore PSR1.Methods.CamelCapsMethodName.NotCamelCaps |
|
| 148 | - public function sanitize_input_fields(array $query_args) |
|
| 149 | - { |
|
| 150 | - $arg_mapping = [ |
|
| 151 | - 'orderBy' => 'order_by', |
|
| 152 | - 'order' => 'order', |
|
| 153 | - ]; |
|
| 154 | - |
|
| 155 | - /** |
|
| 156 | - * Return the Query Args |
|
| 157 | - */ |
|
| 158 | - return ! empty($query_args) && is_array($query_args) ? $query_args : []; |
|
| 159 | - } |
|
| 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 | + * Determine whether the Query should execute. If it's determined that the query should |
|
| 55 | + * not be run based on context such as, but not limited to, who the user is, where in the |
|
| 56 | + * ResolveTree the Query is, the relation to the node the Query is connected to, etc |
|
| 57 | + * Return false to prevent the query from executing. |
|
| 58 | + * |
|
| 59 | + * @return bool |
|
| 60 | + */ |
|
| 61 | + // phpcs:ignore PSR1.Methods.CamelCapsMethodName.NotCamelCaps |
|
| 62 | + public function should_execute() |
|
| 63 | + { |
|
| 64 | + if (false === $this->should_execute) { |
|
| 65 | + return false; |
|
| 66 | + } |
|
| 67 | + |
|
| 68 | + return $this->should_execute; |
|
| 69 | + } |
|
| 70 | + |
|
| 71 | + |
|
| 72 | + /** |
|
| 73 | + * Here, we map the args from the input, then we make sure that we're only querying |
|
| 74 | + * for IDs. The IDs are then passed down the resolve tree, and deferred resolvers |
|
| 75 | + * handle batch resolution of the posts. |
|
| 76 | + * |
|
| 77 | + * @return array |
|
| 78 | + */ |
|
| 79 | + // phpcs:ignore PSR1.Methods.CamelCapsMethodName.NotCamelCaps |
|
| 80 | + public function get_query_args() |
|
| 81 | + { |
|
| 82 | + $query_args = []; |
|
| 83 | + |
|
| 84 | + /** |
|
| 85 | + * Prepare for later use |
|
| 86 | + */ |
|
| 87 | + $last = ! empty($this->args['last']) ? $this->args['last'] : null; |
|
| 88 | + $first = ! empty($this->args['first']) ? $this->args['first'] : null; |
|
| 89 | + |
|
| 90 | + /** |
|
| 91 | + * Set limit the highest value of $first and $last, with a (filterable) max of 100 |
|
| 92 | + */ |
|
| 93 | + $query_args['limit'] = min( |
|
| 94 | + max(absint($first), absint($last), 10), |
|
| 95 | + $this->query_amount |
|
| 96 | + ) + 1; |
|
| 97 | + |
|
| 98 | + /** |
|
| 99 | + * Collect the input_fields and sanitize them to prepare them for sending to the Query |
|
| 100 | + */ |
|
| 101 | + $input_fields = []; |
|
| 102 | + if (! empty($this->args['where'])) { |
|
| 103 | + $input_fields = $this->sanitize_input_fields($this->args['where']); |
|
| 104 | + } |
|
| 105 | + |
|
| 106 | + /** |
|
| 107 | + * Determine where we're at in the Graph and adjust the query context appropriately. |
|
| 108 | + * For example, if we're querying for datetime as a field of event query, this will automatically |
|
| 109 | + * set the query to pull datetimes that belong to that event. |
|
| 110 | + * We can set more cases for other source types. |
|
| 111 | + */ |
|
| 112 | + if (is_object($this->source)) { |
|
| 113 | + switch (true) { |
|
| 114 | + // Assumed to be an event |
|
| 115 | + case $this->source instanceof Post: |
|
| 116 | + $query_args[] = ['Event.EVT_ID' => $this->source->ID]; |
|
| 117 | + break; |
|
| 118 | + case $this->source instanceof EE_Event: |
|
| 119 | + $query_args[] = ['Event.EVT_ID' => $this->source->ID()]; |
|
| 120 | + break; |
|
| 121 | + } |
|
| 122 | + } |
|
| 123 | + |
|
| 124 | + /** |
|
| 125 | + * Merge the input_fields with the default query_args |
|
| 126 | + */ |
|
| 127 | + if (! empty($input_fields)) { |
|
| 128 | + $query_args = array_merge($query_args, $input_fields); |
|
| 129 | + } |
|
| 130 | + |
|
| 131 | + /** |
|
| 132 | + * Return the $query_args |
|
| 133 | + */ |
|
| 134 | + return $query_args; |
|
| 135 | + } |
|
| 136 | + |
|
| 137 | + |
|
| 138 | + /** |
|
| 139 | + * This sets up the "allowed" args, and translates the GraphQL-friendly keys to WP_Query |
|
| 140 | + * friendly keys. There's probably a cleaner/more dynamic way to approach this, but |
|
| 141 | + * this was quick. I'd be down to explore more dynamic ways to map this, but for |
|
| 142 | + * now this gets the job done. |
|
| 143 | + * |
|
| 144 | + * @param array $query_args |
|
| 145 | + * @return array |
|
| 146 | + */ |
|
| 147 | + // phpcs:ignore PSR1.Methods.CamelCapsMethodName.NotCamelCaps |
|
| 148 | + public function sanitize_input_fields(array $query_args) |
|
| 149 | + { |
|
| 150 | + $arg_mapping = [ |
|
| 151 | + 'orderBy' => 'order_by', |
|
| 152 | + 'order' => 'order', |
|
| 153 | + ]; |
|
| 154 | + |
|
| 155 | + /** |
|
| 156 | + * Return the Query Args |
|
| 157 | + */ |
|
| 158 | + return ! empty($query_args) && is_array($query_args) ? $query_args : []; |
|
| 159 | + } |
|
| 160 | 160 | } |
@@ -9,70 +9,70 @@ |
||
| 9 | 9 | */ |
| 10 | 10 | abstract class AbstractLoader extends AbstractDataLoader |
| 11 | 11 | { |
| 12 | - protected $primaryKey; |
|
| 12 | + protected $primaryKey; |
|
| 13 | 13 | |
| 14 | - /** |
|
| 15 | - * @return EE_Base_Class |
|
| 16 | - * @throws EE_Error |
|
| 17 | - * @throws InvalidArgumentException |
|
| 18 | - * @throws InvalidDataTypeException |
|
| 19 | - * @throws InvalidInterfaceException |
|
| 20 | - */ |
|
| 21 | - abstract protected function getQuery(); |
|
| 14 | + /** |
|
| 15 | + * @return EE_Base_Class |
|
| 16 | + * @throws EE_Error |
|
| 17 | + * @throws InvalidArgumentException |
|
| 18 | + * @throws InvalidDataTypeException |
|
| 19 | + * @throws InvalidInterfaceException |
|
| 20 | + */ |
|
| 21 | + abstract protected function getQuery(); |
|
| 22 | 22 | |
| 23 | - /** |
|
| 24 | - * @param array $keys |
|
| 25 | - * |
|
| 26 | - * @return array |
|
| 27 | - * @throws EE_Error |
|
| 28 | - * @throws InvalidArgumentException |
|
| 29 | - * @throws InvalidDataTypeException |
|
| 30 | - * @throws InvalidInterfaceException |
|
| 31 | - */ |
|
| 32 | - abstract protected function getWhereParams(array $keys); |
|
| 23 | + /** |
|
| 24 | + * @param array $keys |
|
| 25 | + * |
|
| 26 | + * @return array |
|
| 27 | + * @throws EE_Error |
|
| 28 | + * @throws InvalidArgumentException |
|
| 29 | + * @throws InvalidDataTypeException |
|
| 30 | + * @throws InvalidInterfaceException |
|
| 31 | + */ |
|
| 32 | + abstract protected function getWhereParams(array $keys); |
|
| 33 | 33 | |
| 34 | - /** |
|
| 35 | - * Given array of keys, loads and returns a map consisting of keys from `keys` array and loaded |
|
| 36 | - * values |
|
| 37 | - * |
|
| 38 | - * Note that order of returned values must match exactly the order of keys. |
|
| 39 | - * If some entry is not available for given key - it must include null for the missing key. |
|
| 40 | - * |
|
| 41 | - * For example: |
|
| 42 | - * loadKeys(['a', 'b', 'c']) -> ['a' => 'value1, 'b' => null, 'c' => 'value3'] |
|
| 43 | - * |
|
| 44 | - * @param array $keys |
|
| 45 | - * |
|
| 46 | - * @return array |
|
| 47 | - * @throws \Exception |
|
| 48 | - */ |
|
| 49 | - public function loadKeys(array $keys) |
|
| 50 | - { |
|
| 51 | - if (empty($keys)) { |
|
| 52 | - return $keys; |
|
| 53 | - } |
|
| 34 | + /** |
|
| 35 | + * Given array of keys, loads and returns a map consisting of keys from `keys` array and loaded |
|
| 36 | + * values |
|
| 37 | + * |
|
| 38 | + * Note that order of returned values must match exactly the order of keys. |
|
| 39 | + * If some entry is not available for given key - it must include null for the missing key. |
|
| 40 | + * |
|
| 41 | + * For example: |
|
| 42 | + * loadKeys(['a', 'b', 'c']) -> ['a' => 'value1, 'b' => null, 'c' => 'value3'] |
|
| 43 | + * |
|
| 44 | + * @param array $keys |
|
| 45 | + * |
|
| 46 | + * @return array |
|
| 47 | + * @throws \Exception |
|
| 48 | + */ |
|
| 49 | + public function loadKeys(array $keys) |
|
| 50 | + { |
|
| 51 | + if (empty($keys)) { |
|
| 52 | + return $keys; |
|
| 53 | + } |
|
| 54 | 54 | |
| 55 | - $args = [ |
|
| 56 | - $this->getWhereParams($keys), |
|
| 57 | - ]; |
|
| 55 | + $args = [ |
|
| 56 | + $this->getWhereParams($keys), |
|
| 57 | + ]; |
|
| 58 | 58 | |
| 59 | - $query = $this->getQuery(); |
|
| 60 | - $result = $query->get_all($args); |
|
| 59 | + $query = $this->getQuery(); |
|
| 60 | + $result = $query->get_all($args); |
|
| 61 | 61 | |
| 62 | - $loadedItems = []; |
|
| 62 | + $loadedItems = []; |
|
| 63 | 63 | |
| 64 | - /** |
|
| 65 | - * Loop over the items and return an array of loaded items, |
|
| 66 | - * where the key is the ID and the value is the Object passed through |
|
| 67 | - * the model layer. |
|
| 68 | - */ |
|
| 69 | - foreach ($keys as $key) { |
|
| 70 | - if (isset($result[ $key ])) { |
|
| 71 | - $loadedItems[ $key ] = $result[ $key ]; |
|
| 72 | - } else { |
|
| 73 | - $loadedItems[ $key ] = null; |
|
| 74 | - } |
|
| 75 | - } |
|
| 76 | - return $loadedItems; |
|
| 77 | - } |
|
| 64 | + /** |
|
| 65 | + * Loop over the items and return an array of loaded items, |
|
| 66 | + * where the key is the ID and the value is the Object passed through |
|
| 67 | + * the model layer. |
|
| 68 | + */ |
|
| 69 | + foreach ($keys as $key) { |
|
| 70 | + if (isset($result[ $key ])) { |
|
| 71 | + $loadedItems[ $key ] = $result[ $key ]; |
|
| 72 | + } else { |
|
| 73 | + $loadedItems[ $key ] = null; |
|
| 74 | + } |
|
| 75 | + } |
|
| 76 | + return $loadedItems; |
|
| 77 | + } |
|
| 78 | 78 | } |
@@ -67,10 +67,10 @@ |
||
| 67 | 67 | * the model layer. |
| 68 | 68 | */ |
| 69 | 69 | foreach ($keys as $key) { |
| 70 | - if (isset($result[ $key ])) { |
|
| 71 | - $loadedItems[ $key ] = $result[ $key ]; |
|
| 70 | + if (isset($result[$key])) { |
|
| 71 | + $loadedItems[$key] = $result[$key]; |
|
| 72 | 72 | } else { |
| 73 | - $loadedItems[ $key ] = null; |
|
| 73 | + $loadedItems[$key] = null; |
|
| 74 | 74 | } |
| 75 | 75 | } |
| 76 | 76 | return $loadedItems; |
@@ -12,31 +12,31 @@ |
||
| 12 | 12 | */ |
| 13 | 13 | class PriceTypeLoader extends AbstractLoader |
| 14 | 14 | { |
| 15 | - /** |
|
| 16 | - * @return EE_Base_Class |
|
| 17 | - * @throws EE_Error |
|
| 18 | - * @throws InvalidArgumentException |
|
| 19 | - * @throws InvalidDataTypeException |
|
| 20 | - * @throws InvalidInterfaceException |
|
| 21 | - */ |
|
| 22 | - protected function getQuery() |
|
| 23 | - { |
|
| 24 | - return EEM_PriceType::instance(); |
|
| 25 | - } |
|
| 15 | + /** |
|
| 16 | + * @return EE_Base_Class |
|
| 17 | + * @throws EE_Error |
|
| 18 | + * @throws InvalidArgumentException |
|
| 19 | + * @throws InvalidDataTypeException |
|
| 20 | + * @throws InvalidInterfaceException |
|
| 21 | + */ |
|
| 22 | + protected function getQuery() |
|
| 23 | + { |
|
| 24 | + return EEM_PriceType::instance(); |
|
| 25 | + } |
|
| 26 | 26 | |
| 27 | - /** |
|
| 28 | - * @param array $keys |
|
| 29 | - * |
|
| 30 | - * @return array |
|
| 31 | - * @throws EE_Error |
|
| 32 | - * @throws InvalidArgumentException |
|
| 33 | - * @throws InvalidDataTypeException |
|
| 34 | - * @throws InvalidInterfaceException |
|
| 35 | - */ |
|
| 36 | - protected function getWhereParams(array $keys) |
|
| 37 | - { |
|
| 38 | - return [ |
|
| 39 | - 'PRT_ID' => ['IN', $keys], |
|
| 40 | - ]; |
|
| 41 | - } |
|
| 27 | + /** |
|
| 28 | + * @param array $keys |
|
| 29 | + * |
|
| 30 | + * @return array |
|
| 31 | + * @throws EE_Error |
|
| 32 | + * @throws InvalidArgumentException |
|
| 33 | + * @throws InvalidDataTypeException |
|
| 34 | + * @throws InvalidInterfaceException |
|
| 35 | + */ |
|
| 36 | + protected function getWhereParams(array $keys) |
|
| 37 | + { |
|
| 38 | + return [ |
|
| 39 | + 'PRT_ID' => ['IN', $keys], |
|
| 40 | + ]; |
|
| 41 | + } |
|
| 42 | 42 | } |