@@ -54,14 +54,14 @@ discard block |
||
54 | 54 | */ |
55 | 55 | public function create(EE_Base_Class $entity): array |
56 | 56 | { |
57 | - if (! $entity instanceof EE_Datetime) { |
|
57 | + if ( ! $entity instanceof EE_Datetime) { |
|
58 | 58 | throw new InvalidEntityException($entity, 'EE_Datetime'); |
59 | 59 | } |
60 | 60 | $new_tickets = []; |
61 | 61 | $default_tickets = $this->ticket_model->get_all_default_tickets(); |
62 | 62 | if (is_array($default_tickets)) { |
63 | 63 | foreach ($default_tickets as $default_ticket) { |
64 | - if (! $default_ticket instanceof EE_Ticket) { |
|
64 | + if ( ! $default_ticket instanceof EE_Ticket) { |
|
65 | 65 | throw new InvalidEntityException($default_ticket, 'EE_Ticket'); |
66 | 66 | } |
67 | 67 | $existing_default_prices = $default_ticket->prices(); |
@@ -79,7 +79,7 @@ discard block |
||
79 | 79 | } |
80 | 80 | } |
81 | 81 | $this->default_prices->create($default_ticket_clone); |
82 | - $new_tickets[ $default_ticket_clone->ID() ] = $default_ticket_clone; |
|
82 | + $new_tickets[$default_ticket_clone->ID()] = $default_ticket_clone; |
|
83 | 83 | } |
84 | 84 | } |
85 | 85 | return $new_tickets; |
@@ -21,66 +21,66 @@ |
||
21 | 21 | */ |
22 | 22 | class DefaultTickets implements DefaultEntityGeneratorInterface |
23 | 23 | { |
24 | - /** |
|
25 | - * @var DefaultPrices $default_prices |
|
26 | - */ |
|
27 | - protected $default_prices; |
|
24 | + /** |
|
25 | + * @var DefaultPrices $default_prices |
|
26 | + */ |
|
27 | + protected $default_prices; |
|
28 | 28 | |
29 | - /** |
|
30 | - * @var EEM_Ticket $ticket_model |
|
31 | - */ |
|
32 | - protected $ticket_model; |
|
29 | + /** |
|
30 | + * @var EEM_Ticket $ticket_model |
|
31 | + */ |
|
32 | + protected $ticket_model; |
|
33 | 33 | |
34 | 34 | |
35 | - /** |
|
36 | - * @param DefaultPrices $default_prices |
|
37 | - * @param EEM_Ticket $ticket_model |
|
38 | - */ |
|
39 | - public function __construct(DefaultPrices $default_prices, EEM_Ticket $ticket_model) |
|
40 | - { |
|
41 | - $this->default_prices = $default_prices; |
|
42 | - $this->ticket_model = $ticket_model; |
|
43 | - } |
|
35 | + /** |
|
36 | + * @param DefaultPrices $default_prices |
|
37 | + * @param EEM_Ticket $ticket_model |
|
38 | + */ |
|
39 | + public function __construct(DefaultPrices $default_prices, EEM_Ticket $ticket_model) |
|
40 | + { |
|
41 | + $this->default_prices = $default_prices; |
|
42 | + $this->ticket_model = $ticket_model; |
|
43 | + } |
|
44 | 44 | |
45 | 45 | |
46 | - /** |
|
47 | - * @param EE_Datetime|EE_Base_Class $entity |
|
48 | - * @return EE_Ticket[] |
|
49 | - * @throws EE_Error |
|
50 | - * @throws InvalidEntityException |
|
51 | - * @throws ReflectionException |
|
52 | - * @since $VID:$ |
|
53 | - */ |
|
54 | - public function create(EE_Base_Class $entity): array |
|
55 | - { |
|
56 | - if (! $entity instanceof EE_Datetime) { |
|
57 | - throw new InvalidEntityException($entity, 'EE_Datetime'); |
|
58 | - } |
|
59 | - $new_tickets = []; |
|
60 | - $default_tickets = $this->ticket_model->get_all_default_tickets(); |
|
61 | - if (is_array($default_tickets)) { |
|
62 | - foreach ($default_tickets as $default_ticket) { |
|
63 | - if (! $default_ticket instanceof EE_Ticket) { |
|
64 | - throw new InvalidEntityException($default_ticket, 'EE_Ticket'); |
|
65 | - } |
|
66 | - $existing_default_prices = $default_ticket->prices(); |
|
67 | - // clone ticket, strip out ID, then save to get a new ID |
|
68 | - $default_ticket_clone = clone $default_ticket; |
|
69 | - $default_ticket_clone->set('TKT_ID', null); |
|
70 | - $default_ticket_clone->set('TKT_is_default', false); |
|
71 | - $default_ticket_clone->save(); |
|
72 | - $default_ticket_clone->_add_relation_to($entity, 'Datetime'); |
|
73 | - // temporarily adding relations to existing prices, but these will be cloned and removed |
|
74 | - // when passed to DefaultPrices::create() below so that they the clones can be freely mutated |
|
75 | - foreach ($existing_default_prices as $existing_default_price) { |
|
76 | - if ($existing_default_price instanceof EE_Price) { |
|
77 | - $existing_default_price->_add_relation_to($default_ticket_clone, 'Ticket'); |
|
78 | - } |
|
79 | - } |
|
80 | - $this->default_prices->create($default_ticket_clone); |
|
81 | - $new_tickets[ $default_ticket_clone->ID() ] = $default_ticket_clone; |
|
82 | - } |
|
83 | - } |
|
84 | - return $new_tickets; |
|
85 | - } |
|
46 | + /** |
|
47 | + * @param EE_Datetime|EE_Base_Class $entity |
|
48 | + * @return EE_Ticket[] |
|
49 | + * @throws EE_Error |
|
50 | + * @throws InvalidEntityException |
|
51 | + * @throws ReflectionException |
|
52 | + * @since $VID:$ |
|
53 | + */ |
|
54 | + public function create(EE_Base_Class $entity): array |
|
55 | + { |
|
56 | + if (! $entity instanceof EE_Datetime) { |
|
57 | + throw new InvalidEntityException($entity, 'EE_Datetime'); |
|
58 | + } |
|
59 | + $new_tickets = []; |
|
60 | + $default_tickets = $this->ticket_model->get_all_default_tickets(); |
|
61 | + if (is_array($default_tickets)) { |
|
62 | + foreach ($default_tickets as $default_ticket) { |
|
63 | + if (! $default_ticket instanceof EE_Ticket) { |
|
64 | + throw new InvalidEntityException($default_ticket, 'EE_Ticket'); |
|
65 | + } |
|
66 | + $existing_default_prices = $default_ticket->prices(); |
|
67 | + // clone ticket, strip out ID, then save to get a new ID |
|
68 | + $default_ticket_clone = clone $default_ticket; |
|
69 | + $default_ticket_clone->set('TKT_ID', null); |
|
70 | + $default_ticket_clone->set('TKT_is_default', false); |
|
71 | + $default_ticket_clone->save(); |
|
72 | + $default_ticket_clone->_add_relation_to($entity, 'Datetime'); |
|
73 | + // temporarily adding relations to existing prices, but these will be cloned and removed |
|
74 | + // when passed to DefaultPrices::create() below so that they the clones can be freely mutated |
|
75 | + foreach ($existing_default_prices as $existing_default_price) { |
|
76 | + if ($existing_default_price instanceof EE_Price) { |
|
77 | + $existing_default_price->_add_relation_to($default_ticket_clone, 'Ticket'); |
|
78 | + } |
|
79 | + } |
|
80 | + $this->default_prices->create($default_ticket_clone); |
|
81 | + $new_tickets[ $default_ticket_clone->ID() ] = $default_ticket_clone; |
|
82 | + } |
|
83 | + } |
|
84 | + return $new_tickets; |
|
85 | + } |
|
86 | 86 | } |
@@ -80,24 +80,24 @@ discard block |
||
80 | 80 | * Collect the input_fields and sanitize them to prepare them for sending to the Query |
81 | 81 | */ |
82 | 82 | $input_fields = []; |
83 | - if (! empty($this->args['where'])) { |
|
83 | + if ( ! empty($this->args['where'])) { |
|
84 | 84 | $input_fields = $this->sanitizeInputFields($this->args['where']); |
85 | 85 | |
86 | 86 | // Use the proper operator. |
87 | - if (! empty($input_fields['PRC_ID']) && is_array($input_fields['PRC_ID'])) { |
|
87 | + if ( ! empty($input_fields['PRC_ID']) && is_array($input_fields['PRC_ID'])) { |
|
88 | 88 | $input_fields['PRC_ID'] = ['in', $input_fields['PRC_ID']]; |
89 | 89 | } |
90 | - if (! empty($input_fields['Ticket.TKT_ID']) && is_array($input_fields['Ticket.TKT_ID'])) { |
|
90 | + if ( ! empty($input_fields['Ticket.TKT_ID']) && is_array($input_fields['Ticket.TKT_ID'])) { |
|
91 | 91 | $input_fields['Ticket.TKT_ID'] = ['in', $input_fields['Ticket.TKT_ID']]; |
92 | 92 | } |
93 | - if (! empty($input_fields['Price_Type.PBT_ID']) && is_array($input_fields['Price_Type.PBT_ID'])) { |
|
93 | + if ( ! empty($input_fields['Price_Type.PBT_ID']) && is_array($input_fields['Price_Type.PBT_ID'])) { |
|
94 | 94 | $input_fields['Price_Type.PBT_ID'] = ['in', $input_fields['Price_Type.PBT_ID']]; |
95 | 95 | } |
96 | - if (! empty($input_fields['Price_Type.PRT_ID']) && is_array($input_fields['Price_Type.PRT_ID'])) { |
|
96 | + if ( ! empty($input_fields['Price_Type.PRT_ID']) && is_array($input_fields['Price_Type.PRT_ID'])) { |
|
97 | 97 | $input_fields['Price_Type.PRT_ID'] = ['in', $input_fields['Price_Type.PRT_ID']]; |
98 | 98 | } |
99 | 99 | // if event ID is passed but not a ticket ID |
100 | - if (! isset($input_fields['Ticket.TKT_ID']) && isset($input_fields['Event.EVT_ID'])) { |
|
100 | + if ( ! isset($input_fields['Ticket.TKT_ID']) && isset($input_fields['Event.EVT_ID'])) { |
|
101 | 101 | $event_id = $input_fields['Event.EVT_ID']; |
102 | 102 | // Ensure that this doesn't go to the query. |
103 | 103 | // After all there is no DB relation between event and price |
@@ -132,7 +132,7 @@ discard block |
||
132 | 132 | /** |
133 | 133 | * Merge the input_fields with the default query_args |
134 | 134 | */ |
135 | - if (! empty($input_fields)) { |
|
135 | + if ( ! empty($input_fields)) { |
|
136 | 136 | $where_params = array_merge($where_params, $input_fields); |
137 | 137 | } |
138 | 138 | |
@@ -141,7 +141,7 @@ discard block |
||
141 | 141 | $default_prices_params = []; |
142 | 142 | |
143 | 143 | // If default ticket prices should be included. |
144 | - if (! empty($this->args['where']['includeDefaultTicketsPrices'])) { |
|
144 | + if ( ! empty($this->args['where']['includeDefaultTicketsPrices'])) { |
|
145 | 145 | $default_ticket_ids = EEM_Ticket::instance()->get_col([ |
146 | 146 | [ |
147 | 147 | 'TKT_is_default' => 1, |
@@ -150,7 +150,7 @@ discard block |
||
150 | 150 | ]); |
151 | 151 | |
152 | 152 | // if we have default tickets |
153 | - if (! empty($default_ticket_ids)) { |
|
153 | + if ( ! empty($default_ticket_ids)) { |
|
154 | 154 | $default_prices_params['OR'] = [ |
155 | 155 | 'Ticket.TKT_ID' => ['IN', $default_ticket_ids], |
156 | 156 | ]; |
@@ -158,14 +158,14 @@ discard block |
||
158 | 158 | } |
159 | 159 | |
160 | 160 | // If default prices should be included. |
161 | - if (! empty($this->args['where']['includeDefaultPrices'])) { |
|
161 | + if ( ! empty($this->args['where']['includeDefaultPrices'])) { |
|
162 | 162 | $default_prices_params['AND'] = [ |
163 | 163 | 'PRC_deleted' => 0, |
164 | 164 | 'PRC_is_default' => 1, |
165 | 165 | ]; |
166 | 166 | } |
167 | 167 | |
168 | - if (! empty($default_prices_params)) { |
|
168 | + if ( ! empty($default_prices_params)) { |
|
169 | 169 | if (empty($where_params)) { |
170 | 170 | $where_params['OR'] = $default_prices_params; |
171 | 171 | } else { |
@@ -17,219 +17,219 @@ |
||
17 | 17 | */ |
18 | 18 | class PriceConnectionResolver extends AbstractConnectionResolver |
19 | 19 | { |
20 | - // phpcs:ignore PSR1.Methods.CamelCapsMethodName.NotCamelCaps |
|
21 | - public function get_loader_name(): string |
|
22 | - { |
|
23 | - return 'espresso_price'; |
|
24 | - } |
|
25 | - |
|
26 | - /** |
|
27 | - * @return EEM_Price |
|
28 | - * @throws EE_Error |
|
29 | - * @throws InvalidArgumentException |
|
30 | - * @throws InvalidDataTypeException |
|
31 | - * @throws InvalidInterfaceException |
|
32 | - * @throws ReflectionException |
|
33 | - */ |
|
34 | - // phpcs:ignore PSR1.Methods.CamelCapsMethodName.NotCamelCaps |
|
35 | - public function get_query(): EEM_Price |
|
36 | - { |
|
37 | - return EEM_Price::instance(); |
|
38 | - } |
|
39 | - |
|
40 | - |
|
41 | - /** |
|
42 | - * Return an array of item IDs from the query |
|
43 | - * |
|
44 | - * @return array |
|
45 | - */ |
|
46 | - // phpcs:ignore PSR1.Methods.CamelCapsMethodName.NotCamelCaps |
|
47 | - public function get_ids(): array |
|
48 | - { |
|
49 | - $results = $this->query->get_col($this->query_args); |
|
50 | - |
|
51 | - return ! empty($results) ? $results : []; |
|
52 | - } |
|
53 | - |
|
54 | - |
|
55 | - /** |
|
56 | - * Here, we map the args from the input, then we make sure that we're only querying |
|
57 | - * for IDs. The IDs are then passed down the resolve tree, and deferred resolvers |
|
58 | - * handle batch resolution of the posts. |
|
59 | - * |
|
60 | - * @return array |
|
61 | - * @throws EE_Error |
|
62 | - * @throws InvalidArgumentException |
|
63 | - * @throws ReflectionException |
|
64 | - * @throws InvalidDataTypeException |
|
65 | - * @throws InvalidInterfaceException |
|
66 | - */ |
|
67 | - // phpcs:ignore PSR1.Methods.CamelCapsMethodName.NotCamelCaps |
|
68 | - public function get_query_args(): array |
|
69 | - { |
|
70 | - $where_params = []; |
|
71 | - $query_args = []; |
|
72 | - |
|
73 | - $query_args['limit'] = $this->getLimit(); |
|
74 | - |
|
75 | - // Avoid multiple entries by join. |
|
76 | - $query_args['group_by'] = 'PRC_ID'; |
|
77 | - |
|
78 | - $query_args['default_where_conditions'] = 'minimum'; |
|
79 | - |
|
80 | - /** |
|
81 | - * Collect the input_fields and sanitize them to prepare them for sending to the Query |
|
82 | - */ |
|
83 | - $input_fields = []; |
|
84 | - if (! empty($this->args['where'])) { |
|
85 | - $input_fields = $this->sanitizeInputFields($this->args['where']); |
|
86 | - |
|
87 | - // Use the proper operator. |
|
88 | - if (! empty($input_fields['PRC_ID']) && is_array($input_fields['PRC_ID'])) { |
|
89 | - $input_fields['PRC_ID'] = ['in', $input_fields['PRC_ID']]; |
|
90 | - } |
|
91 | - if (! empty($input_fields['Ticket.TKT_ID']) && is_array($input_fields['Ticket.TKT_ID'])) { |
|
92 | - $input_fields['Ticket.TKT_ID'] = ['in', $input_fields['Ticket.TKT_ID']]; |
|
93 | - } |
|
94 | - if (! empty($input_fields['Price_Type.PBT_ID']) && is_array($input_fields['Price_Type.PBT_ID'])) { |
|
95 | - $input_fields['Price_Type.PBT_ID'] = ['in', $input_fields['Price_Type.PBT_ID']]; |
|
96 | - } |
|
97 | - if (! empty($input_fields['Price_Type.PRT_ID']) && is_array($input_fields['Price_Type.PRT_ID'])) { |
|
98 | - $input_fields['Price_Type.PRT_ID'] = ['in', $input_fields['Price_Type.PRT_ID']]; |
|
99 | - } |
|
100 | - // if event ID is passed but not a ticket ID |
|
101 | - if (! isset($input_fields['Ticket.TKT_ID']) && isset($input_fields['Event.EVT_ID'])) { |
|
102 | - $event_id = $input_fields['Event.EVT_ID']; |
|
103 | - // Ensure that this doesn't go to the query. |
|
104 | - // After all there is no DB relation between event and price |
|
105 | - unset($input_fields['Event.EVT_ID']); |
|
106 | - // get all the datetimeIds of the event |
|
107 | - $event_datetime_ids = EEM_Datetime::instance()->get_col([ |
|
108 | - [ |
|
109 | - 'EVT_ID' => $event_id, |
|
110 | - ], |
|
111 | - 'default_where_conditions' => 'minimum' |
|
112 | - ]); |
|
113 | - // get all the related ticket Ids |
|
114 | - $ticket_ids = EEM_Ticket::instance()->get_col([ |
|
115 | - [ |
|
116 | - 'Datetime.DTT_ID' => ['IN', $event_datetime_ids], |
|
117 | - ], |
|
118 | - 'default_where_conditions' => 'minimum' |
|
119 | - ]); |
|
120 | - |
|
121 | - // add tickets relation to the query |
|
122 | - $input_fields['Ticket.TKT_ID'] = ['IN', $ticket_ids]; |
|
123 | - } |
|
124 | - } |
|
125 | - |
|
126 | - /** |
|
127 | - * Determine where we're at in the Graph and adjust the query context appropriately. |
|
128 | - */ |
|
129 | - if ($this->source instanceof EE_Ticket) { |
|
130 | - $where_params['Ticket.TKT_ID'] = $this->source->ID(); |
|
131 | - } |
|
132 | - |
|
133 | - /** |
|
134 | - * Merge the input_fields with the default query_args |
|
135 | - */ |
|
136 | - if (! empty($input_fields)) { |
|
137 | - $where_params = array_merge($where_params, $input_fields); |
|
138 | - } |
|
139 | - |
|
140 | - [$query_args, $where_params] = $this->mapOrderbyInputArgs($query_args, $where_params, 'PRC_ID'); |
|
141 | - |
|
142 | - $default_prices_params = []; |
|
143 | - |
|
144 | - // If default ticket prices should be included. |
|
145 | - if (! empty($this->args['where']['includeDefaultTicketsPrices'])) { |
|
146 | - $default_ticket_ids = EEM_Ticket::instance()->get_col([ |
|
147 | - [ |
|
148 | - 'TKT_is_default' => 1, |
|
149 | - ], |
|
150 | - 'default_where_conditions' => 'minimum' |
|
151 | - ]); |
|
152 | - |
|
153 | - // if we have default tickets |
|
154 | - if (! empty($default_ticket_ids)) { |
|
155 | - $default_prices_params['OR'] = [ |
|
156 | - 'Ticket.TKT_ID' => ['IN', $default_ticket_ids], |
|
157 | - ]; |
|
158 | - } |
|
159 | - } |
|
160 | - |
|
161 | - // If default prices should be included. |
|
162 | - if (! empty($this->args['where']['includeDefaultPrices'])) { |
|
163 | - $default_prices_params['AND'] = [ |
|
164 | - 'PRC_deleted' => 0, |
|
165 | - 'PRC_is_default' => 1, |
|
166 | - ]; |
|
167 | - } |
|
168 | - |
|
169 | - if (! empty($default_prices_params)) { |
|
170 | - if (empty($where_params)) { |
|
171 | - $where_params['OR'] = $default_prices_params; |
|
172 | - } else { |
|
173 | - $where_params = [ |
|
174 | - 'OR' => [ |
|
175 | - 'OR' => $default_prices_params, |
|
176 | - 'AND' => $where_params, |
|
177 | - ], |
|
178 | - ]; |
|
179 | - } |
|
180 | - } |
|
181 | - |
|
182 | - $where_params = apply_filters( |
|
183 | - 'FHEE__EventEspresso_core_domain_services_graphql_connection_resolvers__price_where_params', |
|
184 | - $where_params, |
|
185 | - $this->source, |
|
186 | - $this->args |
|
187 | - ); |
|
188 | - |
|
189 | - $query_args[] = $where_params; |
|
190 | - |
|
191 | - /** |
|
192 | - * Return the $query_args |
|
193 | - */ |
|
194 | - return apply_filters( |
|
195 | - 'FHEE__EventEspresso_core_domain_services_graphql_connection_resolvers__price_query_args', |
|
196 | - $query_args, |
|
197 | - $this->source, |
|
198 | - $this->args |
|
199 | - ); |
|
200 | - } |
|
201 | - |
|
202 | - |
|
203 | - /** |
|
204 | - * This sets up the "allowed" args, and translates the GraphQL-friendly keys to model |
|
205 | - * friendly keys. |
|
206 | - * |
|
207 | - * @param array $where_args |
|
208 | - * @return array |
|
209 | - */ |
|
210 | - public function sanitizeInputFields(array $where_args): array |
|
211 | - { |
|
212 | - $arg_mapping = [ |
|
213 | - 'in' => 'PRC_ID', |
|
214 | - 'idIn' => 'PRC_ID', |
|
215 | - 'isDefault' => 'PRC_is_default', |
|
216 | - 'event' => 'Event.EVT_ID', |
|
217 | - 'eventId' => 'Event.EVT_ID', // priority. |
|
218 | - 'ticket' => 'Ticket.TKT_ID', |
|
219 | - 'ticketIn' => 'Ticket.TKT_ID', |
|
220 | - 'ticketIdIn' => 'Ticket.TKT_ID', |
|
221 | - 'ticketId' => 'Ticket.TKT_ID', // priority. |
|
222 | - 'priceType' => 'Price_Type.PRT_ID', |
|
223 | - 'priceTypeIn' => 'Price_Type.PRT_ID', |
|
224 | - 'priceTypeIdIn' => 'Price_Type.PRT_ID', |
|
225 | - 'priceTypeId' => 'Price_Type.PRT_ID', // priority. |
|
226 | - 'priceBaseType' => 'Price_Type.PBT_ID', |
|
227 | - 'priceBaseTypeIn' => 'Price_Type.PBT_ID', |
|
228 | - ]; |
|
229 | - return $this->sanitizeWhereArgsForInputFields( |
|
230 | - $where_args, |
|
231 | - $arg_mapping, |
|
232 | - ['in', 'event', 'ticket', 'ticketIn', 'priceType', 'priceTypeIn'] |
|
233 | - ); |
|
234 | - } |
|
20 | + // phpcs:ignore PSR1.Methods.CamelCapsMethodName.NotCamelCaps |
|
21 | + public function get_loader_name(): string |
|
22 | + { |
|
23 | + return 'espresso_price'; |
|
24 | + } |
|
25 | + |
|
26 | + /** |
|
27 | + * @return EEM_Price |
|
28 | + * @throws EE_Error |
|
29 | + * @throws InvalidArgumentException |
|
30 | + * @throws InvalidDataTypeException |
|
31 | + * @throws InvalidInterfaceException |
|
32 | + * @throws ReflectionException |
|
33 | + */ |
|
34 | + // phpcs:ignore PSR1.Methods.CamelCapsMethodName.NotCamelCaps |
|
35 | + public function get_query(): EEM_Price |
|
36 | + { |
|
37 | + return EEM_Price::instance(); |
|
38 | + } |
|
39 | + |
|
40 | + |
|
41 | + /** |
|
42 | + * Return an array of item IDs from the query |
|
43 | + * |
|
44 | + * @return array |
|
45 | + */ |
|
46 | + // phpcs:ignore PSR1.Methods.CamelCapsMethodName.NotCamelCaps |
|
47 | + public function get_ids(): array |
|
48 | + { |
|
49 | + $results = $this->query->get_col($this->query_args); |
|
50 | + |
|
51 | + return ! empty($results) ? $results : []; |
|
52 | + } |
|
53 | + |
|
54 | + |
|
55 | + /** |
|
56 | + * Here, we map the args from the input, then we make sure that we're only querying |
|
57 | + * for IDs. The IDs are then passed down the resolve tree, and deferred resolvers |
|
58 | + * handle batch resolution of the posts. |
|
59 | + * |
|
60 | + * @return array |
|
61 | + * @throws EE_Error |
|
62 | + * @throws InvalidArgumentException |
|
63 | + * @throws ReflectionException |
|
64 | + * @throws InvalidDataTypeException |
|
65 | + * @throws InvalidInterfaceException |
|
66 | + */ |
|
67 | + // phpcs:ignore PSR1.Methods.CamelCapsMethodName.NotCamelCaps |
|
68 | + public function get_query_args(): array |
|
69 | + { |
|
70 | + $where_params = []; |
|
71 | + $query_args = []; |
|
72 | + |
|
73 | + $query_args['limit'] = $this->getLimit(); |
|
74 | + |
|
75 | + // Avoid multiple entries by join. |
|
76 | + $query_args['group_by'] = 'PRC_ID'; |
|
77 | + |
|
78 | + $query_args['default_where_conditions'] = 'minimum'; |
|
79 | + |
|
80 | + /** |
|
81 | + * Collect the input_fields and sanitize them to prepare them for sending to the Query |
|
82 | + */ |
|
83 | + $input_fields = []; |
|
84 | + if (! empty($this->args['where'])) { |
|
85 | + $input_fields = $this->sanitizeInputFields($this->args['where']); |
|
86 | + |
|
87 | + // Use the proper operator. |
|
88 | + if (! empty($input_fields['PRC_ID']) && is_array($input_fields['PRC_ID'])) { |
|
89 | + $input_fields['PRC_ID'] = ['in', $input_fields['PRC_ID']]; |
|
90 | + } |
|
91 | + if (! empty($input_fields['Ticket.TKT_ID']) && is_array($input_fields['Ticket.TKT_ID'])) { |
|
92 | + $input_fields['Ticket.TKT_ID'] = ['in', $input_fields['Ticket.TKT_ID']]; |
|
93 | + } |
|
94 | + if (! empty($input_fields['Price_Type.PBT_ID']) && is_array($input_fields['Price_Type.PBT_ID'])) { |
|
95 | + $input_fields['Price_Type.PBT_ID'] = ['in', $input_fields['Price_Type.PBT_ID']]; |
|
96 | + } |
|
97 | + if (! empty($input_fields['Price_Type.PRT_ID']) && is_array($input_fields['Price_Type.PRT_ID'])) { |
|
98 | + $input_fields['Price_Type.PRT_ID'] = ['in', $input_fields['Price_Type.PRT_ID']]; |
|
99 | + } |
|
100 | + // if event ID is passed but not a ticket ID |
|
101 | + if (! isset($input_fields['Ticket.TKT_ID']) && isset($input_fields['Event.EVT_ID'])) { |
|
102 | + $event_id = $input_fields['Event.EVT_ID']; |
|
103 | + // Ensure that this doesn't go to the query. |
|
104 | + // After all there is no DB relation between event and price |
|
105 | + unset($input_fields['Event.EVT_ID']); |
|
106 | + // get all the datetimeIds of the event |
|
107 | + $event_datetime_ids = EEM_Datetime::instance()->get_col([ |
|
108 | + [ |
|
109 | + 'EVT_ID' => $event_id, |
|
110 | + ], |
|
111 | + 'default_where_conditions' => 'minimum' |
|
112 | + ]); |
|
113 | + // get all the related ticket Ids |
|
114 | + $ticket_ids = EEM_Ticket::instance()->get_col([ |
|
115 | + [ |
|
116 | + 'Datetime.DTT_ID' => ['IN', $event_datetime_ids], |
|
117 | + ], |
|
118 | + 'default_where_conditions' => 'minimum' |
|
119 | + ]); |
|
120 | + |
|
121 | + // add tickets relation to the query |
|
122 | + $input_fields['Ticket.TKT_ID'] = ['IN', $ticket_ids]; |
|
123 | + } |
|
124 | + } |
|
125 | + |
|
126 | + /** |
|
127 | + * Determine where we're at in the Graph and adjust the query context appropriately. |
|
128 | + */ |
|
129 | + if ($this->source instanceof EE_Ticket) { |
|
130 | + $where_params['Ticket.TKT_ID'] = $this->source->ID(); |
|
131 | + } |
|
132 | + |
|
133 | + /** |
|
134 | + * Merge the input_fields with the default query_args |
|
135 | + */ |
|
136 | + if (! empty($input_fields)) { |
|
137 | + $where_params = array_merge($where_params, $input_fields); |
|
138 | + } |
|
139 | + |
|
140 | + [$query_args, $where_params] = $this->mapOrderbyInputArgs($query_args, $where_params, 'PRC_ID'); |
|
141 | + |
|
142 | + $default_prices_params = []; |
|
143 | + |
|
144 | + // If default ticket prices should be included. |
|
145 | + if (! empty($this->args['where']['includeDefaultTicketsPrices'])) { |
|
146 | + $default_ticket_ids = EEM_Ticket::instance()->get_col([ |
|
147 | + [ |
|
148 | + 'TKT_is_default' => 1, |
|
149 | + ], |
|
150 | + 'default_where_conditions' => 'minimum' |
|
151 | + ]); |
|
152 | + |
|
153 | + // if we have default tickets |
|
154 | + if (! empty($default_ticket_ids)) { |
|
155 | + $default_prices_params['OR'] = [ |
|
156 | + 'Ticket.TKT_ID' => ['IN', $default_ticket_ids], |
|
157 | + ]; |
|
158 | + } |
|
159 | + } |
|
160 | + |
|
161 | + // If default prices should be included. |
|
162 | + if (! empty($this->args['where']['includeDefaultPrices'])) { |
|
163 | + $default_prices_params['AND'] = [ |
|
164 | + 'PRC_deleted' => 0, |
|
165 | + 'PRC_is_default' => 1, |
|
166 | + ]; |
|
167 | + } |
|
168 | + |
|
169 | + if (! empty($default_prices_params)) { |
|
170 | + if (empty($where_params)) { |
|
171 | + $where_params['OR'] = $default_prices_params; |
|
172 | + } else { |
|
173 | + $where_params = [ |
|
174 | + 'OR' => [ |
|
175 | + 'OR' => $default_prices_params, |
|
176 | + 'AND' => $where_params, |
|
177 | + ], |
|
178 | + ]; |
|
179 | + } |
|
180 | + } |
|
181 | + |
|
182 | + $where_params = apply_filters( |
|
183 | + 'FHEE__EventEspresso_core_domain_services_graphql_connection_resolvers__price_where_params', |
|
184 | + $where_params, |
|
185 | + $this->source, |
|
186 | + $this->args |
|
187 | + ); |
|
188 | + |
|
189 | + $query_args[] = $where_params; |
|
190 | + |
|
191 | + /** |
|
192 | + * Return the $query_args |
|
193 | + */ |
|
194 | + return apply_filters( |
|
195 | + 'FHEE__EventEspresso_core_domain_services_graphql_connection_resolvers__price_query_args', |
|
196 | + $query_args, |
|
197 | + $this->source, |
|
198 | + $this->args |
|
199 | + ); |
|
200 | + } |
|
201 | + |
|
202 | + |
|
203 | + /** |
|
204 | + * This sets up the "allowed" args, and translates the GraphQL-friendly keys to model |
|
205 | + * friendly keys. |
|
206 | + * |
|
207 | + * @param array $where_args |
|
208 | + * @return array |
|
209 | + */ |
|
210 | + public function sanitizeInputFields(array $where_args): array |
|
211 | + { |
|
212 | + $arg_mapping = [ |
|
213 | + 'in' => 'PRC_ID', |
|
214 | + 'idIn' => 'PRC_ID', |
|
215 | + 'isDefault' => 'PRC_is_default', |
|
216 | + 'event' => 'Event.EVT_ID', |
|
217 | + 'eventId' => 'Event.EVT_ID', // priority. |
|
218 | + 'ticket' => 'Ticket.TKT_ID', |
|
219 | + 'ticketIn' => 'Ticket.TKT_ID', |
|
220 | + 'ticketIdIn' => 'Ticket.TKT_ID', |
|
221 | + 'ticketId' => 'Ticket.TKT_ID', // priority. |
|
222 | + 'priceType' => 'Price_Type.PRT_ID', |
|
223 | + 'priceTypeIn' => 'Price_Type.PRT_ID', |
|
224 | + 'priceTypeIdIn' => 'Price_Type.PRT_ID', |
|
225 | + 'priceTypeId' => 'Price_Type.PRT_ID', // priority. |
|
226 | + 'priceBaseType' => 'Price_Type.PBT_ID', |
|
227 | + 'priceBaseTypeIn' => 'Price_Type.PBT_ID', |
|
228 | + ]; |
|
229 | + return $this->sanitizeWhereArgsForInputFields( |
|
230 | + $where_args, |
|
231 | + $arg_mapping, |
|
232 | + ['in', 'event', 'ticket', 'ticketIn', 'priceType', 'priceTypeIn'] |
|
233 | + ); |
|
234 | + } |
|
235 | 235 | } |
@@ -78,14 +78,14 @@ discard block |
||
78 | 78 | * Collect the input_fields and sanitize them to prepare them for sending to the Query |
79 | 79 | */ |
80 | 80 | $input_fields = []; |
81 | - if (! empty($this->args['where'])) { |
|
81 | + if ( ! empty($this->args['where'])) { |
|
82 | 82 | $input_fields = $this->sanitizeInputFields($this->args['where']); |
83 | 83 | |
84 | 84 | // Use the proper operator. |
85 | - if (! empty($input_fields['Datetime.DTT_ID']) && is_array($input_fields['Datetime.DTT_ID'])) { |
|
85 | + if ( ! empty($input_fields['Datetime.DTT_ID']) && is_array($input_fields['Datetime.DTT_ID'])) { |
|
86 | 86 | $input_fields['Datetime.DTT_ID'] = ['IN', $input_fields['Datetime.DTT_ID']]; |
87 | 87 | } |
88 | - if (! empty($input_fields['Datetime.EVT_ID']) && is_array($input_fields['Datetime.EVT_ID'])) { |
|
88 | + if ( ! empty($input_fields['Datetime.EVT_ID']) && is_array($input_fields['Datetime.EVT_ID'])) { |
|
89 | 89 | $input_fields['Datetime.EVT_ID'] = ['IN', $input_fields['Datetime.EVT_ID']]; |
90 | 90 | } |
91 | 91 | } |
@@ -100,7 +100,7 @@ discard block |
||
100 | 100 | /** |
101 | 101 | * Merge the input_fields with the default query_args |
102 | 102 | */ |
103 | - if (! empty($input_fields)) { |
|
103 | + if ( ! empty($input_fields)) { |
|
104 | 104 | $where_params = array_merge($where_params, $input_fields); |
105 | 105 | } |
106 | 106 | |
@@ -108,16 +108,16 @@ discard block |
||
108 | 108 | |
109 | 109 | $search = isset($this->args['where']) ? $this->getSearchKeywords($this->args['where']) : ''; |
110 | 110 | |
111 | - if (! empty($search)) { |
|
111 | + if ( ! empty($search)) { |
|
112 | 112 | // use OR operator to search in any of the fields |
113 | 113 | $where_params['OR'] = array( |
114 | - 'TKT_name' => array('LIKE', '%' . $search . '%'), |
|
115 | - 'TKT_description' => array('LIKE', '%' . $search . '%'), |
|
114 | + 'TKT_name' => array('LIKE', '%'.$search.'%'), |
|
115 | + 'TKT_description' => array('LIKE', '%'.$search.'%'), |
|
116 | 116 | ); |
117 | 117 | } |
118 | 118 | |
119 | 119 | // If default tickets should be included. |
120 | - if (! empty($this->args['where']['includeDefaultTickets'])) { |
|
120 | + if ( ! empty($this->args['where']['includeDefaultTickets'])) { |
|
121 | 121 | /** |
122 | 122 | * We need to get each ticket that |
123 | 123 | * - satisfies $where_params above |
@@ -15,178 +15,178 @@ |
||
15 | 15 | */ |
16 | 16 | class TicketConnectionResolver extends AbstractConnectionResolver |
17 | 17 | { |
18 | - // phpcs:ignore PSR1.Methods.CamelCapsMethodName.NotCamelCaps |
|
19 | - public function get_loader_name(): string |
|
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 | - * @throws ReflectionException |
|
31 | - */ |
|
32 | - // phpcs:ignore PSR1.Methods.CamelCapsMethodName.NotCamelCaps |
|
33 | - public function get_query(): EEM_Ticket |
|
34 | - { |
|
35 | - return EEM_Ticket::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(): array |
|
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(): array |
|
67 | - { |
|
68 | - $where_params = ['TKT_deleted' => ['IN', [true, false]]]; |
|
69 | - $query_args = []; |
|
70 | - |
|
71 | - $query_args['limit'] = $this->getLimit(); |
|
72 | - |
|
73 | - // Avoid multiple entries by join. |
|
74 | - $query_args['group_by'] = 'TKT_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 | - // Use the proper operator. |
|
86 | - if (! empty($input_fields['Datetime.DTT_ID']) && is_array($input_fields['Datetime.DTT_ID'])) { |
|
87 | - $input_fields['Datetime.DTT_ID'] = ['IN', $input_fields['Datetime.DTT_ID']]; |
|
88 | - } |
|
89 | - if (! empty($input_fields['Datetime.EVT_ID']) && is_array($input_fields['Datetime.EVT_ID'])) { |
|
90 | - $input_fields['Datetime.EVT_ID'] = ['IN', $input_fields['Datetime.EVT_ID']]; |
|
91 | - } |
|
92 | - } |
|
93 | - |
|
94 | - /** |
|
95 | - * Determine where we're at in the Graph and adjust the query context appropriately. |
|
96 | - */ |
|
97 | - if ($this->source instanceof EE_Datetime) { |
|
98 | - $where_params['Datetime.DTT_ID'] = $this->source->ID(); |
|
99 | - } |
|
100 | - |
|
101 | - /** |
|
102 | - * Merge the input_fields with the default query_args |
|
103 | - */ |
|
104 | - if (! empty($input_fields)) { |
|
105 | - $where_params = array_merge($where_params, $input_fields); |
|
106 | - } |
|
107 | - |
|
108 | - [$query_args, $where_params] = $this->mapOrderbyInputArgs($query_args, $where_params, 'TKT_ID'); |
|
109 | - |
|
110 | - $search = isset($this->args['where']) ? $this->getSearchKeywords($this->args['where']) : ''; |
|
111 | - |
|
112 | - if (! empty($search)) { |
|
113 | - // use OR operator to search in any of the fields |
|
114 | - $where_params['OR'] = array( |
|
115 | - 'TKT_name' => array('LIKE', '%' . $search . '%'), |
|
116 | - 'TKT_description' => array('LIKE', '%' . $search . '%'), |
|
117 | - ); |
|
118 | - } |
|
119 | - |
|
120 | - // If default tickets should be included. |
|
121 | - if (! empty($this->args['where']['includeDefaultTickets'])) { |
|
122 | - /** |
|
123 | - * We need to get each ticket that |
|
124 | - * - satisfies $where_params above |
|
125 | - * OR |
|
126 | - * - it's a default ticket |
|
127 | - */ |
|
128 | - $where_params = [ |
|
129 | - 'OR' => [ |
|
130 | - // use extra OR instead of AND to avoid it getting overridden |
|
131 | - 'OR' => [ |
|
132 | - 'AND' => [ |
|
133 | - 'TKT_deleted' => ['IN', [true, false]], |
|
134 | - 'TKT_is_default' => 1, |
|
135 | - ] |
|
136 | - ], |
|
137 | - 'AND' => $where_params, |
|
138 | - ], |
|
139 | - ]; |
|
140 | - } |
|
141 | - |
|
142 | - $where_params = apply_filters( |
|
143 | - 'FHEE__EventEspresso_core_domain_services_graphql_connection_resolvers__ticket_where_params', |
|
144 | - $where_params, |
|
145 | - $this->source, |
|
146 | - $this->args |
|
147 | - ); |
|
148 | - |
|
149 | - $query_args[] = $where_params; |
|
150 | - |
|
151 | - /** |
|
152 | - * Return the $query_args |
|
153 | - */ |
|
154 | - return apply_filters( |
|
155 | - 'FHEE__EventEspresso_core_domain_services_graphql_connection_resolvers__ticket_query_args', |
|
156 | - $query_args, |
|
157 | - $this->source, |
|
158 | - $this->args |
|
159 | - ); |
|
160 | - } |
|
161 | - |
|
162 | - |
|
163 | - /** |
|
164 | - * This sets up the "allowed" args, and translates the GraphQL-friendly keys to model |
|
165 | - * friendly keys. |
|
166 | - * |
|
167 | - * @param array $where_args |
|
168 | - * @return array |
|
169 | - */ |
|
170 | - public function sanitizeInputFields(array $where_args): array |
|
171 | - { |
|
172 | - $arg_mapping = [ |
|
173 | - 'event' => 'Datetime.EVT_ID', |
|
174 | - 'eventIn' => 'Datetime.EVT_ID', |
|
175 | - 'eventIdIn' => 'Datetime.EVT_ID', |
|
176 | - 'eventId' => 'Datetime.EVT_ID', // priority. |
|
177 | - 'datetime' => 'Datetime.DTT_ID', |
|
178 | - 'datetimeIn' => 'Datetime.DTT_ID', |
|
179 | - 'datetimeIdIn' => 'Datetime.DTT_ID', |
|
180 | - 'datetimeId' => 'Datetime.DTT_ID', // priority. |
|
181 | - 'isDefault' => 'TKT_is_default', |
|
182 | - 'isRequired' => 'TKT_required', |
|
183 | - 'isTaxable' => 'TKT_taxable', |
|
184 | - 'isTrashed' => 'TKT_deleted', |
|
185 | - ]; |
|
186 | - return $this->sanitizeWhereArgsForInputFields( |
|
187 | - $where_args, |
|
188 | - $arg_mapping, |
|
189 | - ['datetime', 'datetimeIn', 'event', 'eventIn'] |
|
190 | - ); |
|
191 | - } |
|
18 | + // phpcs:ignore PSR1.Methods.CamelCapsMethodName.NotCamelCaps |
|
19 | + public function get_loader_name(): string |
|
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 | + * @throws ReflectionException |
|
31 | + */ |
|
32 | + // phpcs:ignore PSR1.Methods.CamelCapsMethodName.NotCamelCaps |
|
33 | + public function get_query(): EEM_Ticket |
|
34 | + { |
|
35 | + return EEM_Ticket::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(): array |
|
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(): array |
|
67 | + { |
|
68 | + $where_params = ['TKT_deleted' => ['IN', [true, false]]]; |
|
69 | + $query_args = []; |
|
70 | + |
|
71 | + $query_args['limit'] = $this->getLimit(); |
|
72 | + |
|
73 | + // Avoid multiple entries by join. |
|
74 | + $query_args['group_by'] = 'TKT_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 | + // Use the proper operator. |
|
86 | + if (! empty($input_fields['Datetime.DTT_ID']) && is_array($input_fields['Datetime.DTT_ID'])) { |
|
87 | + $input_fields['Datetime.DTT_ID'] = ['IN', $input_fields['Datetime.DTT_ID']]; |
|
88 | + } |
|
89 | + if (! empty($input_fields['Datetime.EVT_ID']) && is_array($input_fields['Datetime.EVT_ID'])) { |
|
90 | + $input_fields['Datetime.EVT_ID'] = ['IN', $input_fields['Datetime.EVT_ID']]; |
|
91 | + } |
|
92 | + } |
|
93 | + |
|
94 | + /** |
|
95 | + * Determine where we're at in the Graph and adjust the query context appropriately. |
|
96 | + */ |
|
97 | + if ($this->source instanceof EE_Datetime) { |
|
98 | + $where_params['Datetime.DTT_ID'] = $this->source->ID(); |
|
99 | + } |
|
100 | + |
|
101 | + /** |
|
102 | + * Merge the input_fields with the default query_args |
|
103 | + */ |
|
104 | + if (! empty($input_fields)) { |
|
105 | + $where_params = array_merge($where_params, $input_fields); |
|
106 | + } |
|
107 | + |
|
108 | + [$query_args, $where_params] = $this->mapOrderbyInputArgs($query_args, $where_params, 'TKT_ID'); |
|
109 | + |
|
110 | + $search = isset($this->args['where']) ? $this->getSearchKeywords($this->args['where']) : ''; |
|
111 | + |
|
112 | + if (! empty($search)) { |
|
113 | + // use OR operator to search in any of the fields |
|
114 | + $where_params['OR'] = array( |
|
115 | + 'TKT_name' => array('LIKE', '%' . $search . '%'), |
|
116 | + 'TKT_description' => array('LIKE', '%' . $search . '%'), |
|
117 | + ); |
|
118 | + } |
|
119 | + |
|
120 | + // If default tickets should be included. |
|
121 | + if (! empty($this->args['where']['includeDefaultTickets'])) { |
|
122 | + /** |
|
123 | + * We need to get each ticket that |
|
124 | + * - satisfies $where_params above |
|
125 | + * OR |
|
126 | + * - it's a default ticket |
|
127 | + */ |
|
128 | + $where_params = [ |
|
129 | + 'OR' => [ |
|
130 | + // use extra OR instead of AND to avoid it getting overridden |
|
131 | + 'OR' => [ |
|
132 | + 'AND' => [ |
|
133 | + 'TKT_deleted' => ['IN', [true, false]], |
|
134 | + 'TKT_is_default' => 1, |
|
135 | + ] |
|
136 | + ], |
|
137 | + 'AND' => $where_params, |
|
138 | + ], |
|
139 | + ]; |
|
140 | + } |
|
141 | + |
|
142 | + $where_params = apply_filters( |
|
143 | + 'FHEE__EventEspresso_core_domain_services_graphql_connection_resolvers__ticket_where_params', |
|
144 | + $where_params, |
|
145 | + $this->source, |
|
146 | + $this->args |
|
147 | + ); |
|
148 | + |
|
149 | + $query_args[] = $where_params; |
|
150 | + |
|
151 | + /** |
|
152 | + * Return the $query_args |
|
153 | + */ |
|
154 | + return apply_filters( |
|
155 | + 'FHEE__EventEspresso_core_domain_services_graphql_connection_resolvers__ticket_query_args', |
|
156 | + $query_args, |
|
157 | + $this->source, |
|
158 | + $this->args |
|
159 | + ); |
|
160 | + } |
|
161 | + |
|
162 | + |
|
163 | + /** |
|
164 | + * This sets up the "allowed" args, and translates the GraphQL-friendly keys to model |
|
165 | + * friendly keys. |
|
166 | + * |
|
167 | + * @param array $where_args |
|
168 | + * @return array |
|
169 | + */ |
|
170 | + public function sanitizeInputFields(array $where_args): array |
|
171 | + { |
|
172 | + $arg_mapping = [ |
|
173 | + 'event' => 'Datetime.EVT_ID', |
|
174 | + 'eventIn' => 'Datetime.EVT_ID', |
|
175 | + 'eventIdIn' => 'Datetime.EVT_ID', |
|
176 | + 'eventId' => 'Datetime.EVT_ID', // priority. |
|
177 | + 'datetime' => 'Datetime.DTT_ID', |
|
178 | + 'datetimeIn' => 'Datetime.DTT_ID', |
|
179 | + 'datetimeIdIn' => 'Datetime.DTT_ID', |
|
180 | + 'datetimeId' => 'Datetime.DTT_ID', // priority. |
|
181 | + 'isDefault' => 'TKT_is_default', |
|
182 | + 'isRequired' => 'TKT_required', |
|
183 | + 'isTaxable' => 'TKT_taxable', |
|
184 | + 'isTrashed' => 'TKT_deleted', |
|
185 | + ]; |
|
186 | + return $this->sanitizeWhereArgsForInputFields( |
|
187 | + $where_args, |
|
188 | + $arg_mapping, |
|
189 | + ['datetime', 'datetimeIn', 'event', 'eventIn'] |
|
190 | + ); |
|
191 | + } |
|
192 | 192 | } |
@@ -56,7 +56,7 @@ discard block |
||
56 | 56 | ]; |
57 | 57 | // Get the IDs of event datetimes. |
58 | 58 | $datetimeIds = $this->datetime_model->get_col([ |
59 | - [ 'EVT_ID' => $eventId ], |
|
59 | + ['EVT_ID' => $eventId], |
|
60 | 60 | 'default_where_conditions' => 'minimum', |
61 | 61 | ]); |
62 | 62 | foreach ($datetimeIds as $datetimeId) { |
@@ -64,10 +64,10 @@ discard block |
||
64 | 64 | foreach ($related_models as $key => $model) { |
65 | 65 | // Get the IDs of related entities for the datetime ID. |
66 | 66 | $Ids = $model->get_col([ |
67 | - [ 'Datetime.DTT_ID' => $datetimeId ], |
|
67 | + ['Datetime.DTT_ID' => $datetimeId], |
|
68 | 68 | 'default_where_conditions' => 'minimum', |
69 | 69 | ]); |
70 | - $this->data['datetimes'][ $GID ][ $key ] = ! empty($Ids) |
|
70 | + $this->data['datetimes'][$GID][$key] = ! empty($Ids) |
|
71 | 71 | ? $this->utilities->convertToGlobalId($model->item_name(), $Ids) |
72 | 72 | : []; |
73 | 73 | } |
@@ -104,10 +104,10 @@ discard block |
||
104 | 104 | foreach ($related_models as $key => $model) { |
105 | 105 | // Get the IDs of related entities for the ticket ID. |
106 | 106 | $Ids = $model->get_col([ |
107 | - [ 'Ticket.TKT_ID' => $ticketId ], |
|
107 | + ['Ticket.TKT_ID' => $ticketId], |
|
108 | 108 | 'default_where_conditions' => 'minimum', |
109 | 109 | ]); |
110 | - $this->data['tickets'][ $GID ][ $key ] = ! empty($Ids) |
|
110 | + $this->data['tickets'][$GID][$key] = ! empty($Ids) |
|
111 | 111 | ? $this->utilities->convertToGlobalId($model->item_name(), $Ids) |
112 | 112 | : []; |
113 | 113 | } |
@@ -149,10 +149,10 @@ discard block |
||
149 | 149 | foreach ($related_models as $key => $model) { |
150 | 150 | // Get the IDs of related entities for the price ID. |
151 | 151 | $Ids = $model->get_col([ |
152 | - [ 'Price.PRC_ID' => $priceId ], |
|
152 | + ['Price.PRC_ID' => $priceId], |
|
153 | 153 | 'default_where_conditions' => 'minimum', |
154 | 154 | ]); |
155 | - $this->data['prices'][ $GID ][ $key ] = ! empty($Ids) |
|
155 | + $this->data['prices'][$GID][$key] = ! empty($Ids) |
|
156 | 156 | ? $this->utilities->convertToGlobalId($model->item_name(), $Ids) |
157 | 157 | : []; |
158 | 158 | } |
@@ -15,146 +15,146 @@ |
||
15 | 15 | */ |
16 | 16 | class EventEntityRelations extends EventEditorData |
17 | 17 | { |
18 | - /** |
|
19 | - * @param array $data |
|
20 | - */ |
|
21 | - private $data; |
|
18 | + /** |
|
19 | + * @param array $data |
|
20 | + */ |
|
21 | + private $data; |
|
22 | 22 | |
23 | - /** |
|
24 | - * @param int $eventId |
|
25 | - * @return array |
|
26 | - * @throws EE_Error |
|
27 | - * @since $VID:$ |
|
28 | - */ |
|
29 | - public function getData(int $eventId) |
|
30 | - { |
|
31 | - $this->data = [ |
|
32 | - 'datetimes' => [], |
|
33 | - 'tickets' => [], |
|
34 | - 'prices' => [], |
|
35 | - ]; |
|
23 | + /** |
|
24 | + * @param int $eventId |
|
25 | + * @return array |
|
26 | + * @throws EE_Error |
|
27 | + * @since $VID:$ |
|
28 | + */ |
|
29 | + public function getData(int $eventId) |
|
30 | + { |
|
31 | + $this->data = [ |
|
32 | + 'datetimes' => [], |
|
33 | + 'tickets' => [], |
|
34 | + 'prices' => [], |
|
35 | + ]; |
|
36 | 36 | |
37 | - $datetimeIds = $this->processDatetimes($eventId); |
|
38 | - $ticketIds = $this->processTickets($datetimeIds); |
|
39 | - $this->processPrices($ticketIds); |
|
37 | + $datetimeIds = $this->processDatetimes($eventId); |
|
38 | + $ticketIds = $this->processTickets($datetimeIds); |
|
39 | + $this->processPrices($ticketIds); |
|
40 | 40 | |
41 | - return $this->data; |
|
42 | - } |
|
41 | + return $this->data; |
|
42 | + } |
|
43 | 43 | |
44 | 44 | |
45 | - /** |
|
46 | - * @param int $eventId |
|
47 | - * @return array |
|
48 | - * @throws EE_Error |
|
49 | - * @since $VID:$ |
|
50 | - */ |
|
51 | - private function processDatetimes(int $eventId) |
|
52 | - { |
|
53 | - $related_models = [ |
|
54 | - 'tickets' => $this->ticket_model, |
|
55 | - ]; |
|
56 | - // Get the IDs of event datetimes. |
|
57 | - $datetimeIds = $this->datetime_model->get_col([ |
|
58 | - [ 'EVT_ID' => $eventId ], |
|
59 | - 'default_where_conditions' => 'minimum', |
|
60 | - ]); |
|
61 | - foreach ($datetimeIds as $datetimeId) { |
|
62 | - $GID = $this->utilities->convertToGlobalId($this->datetime_model->item_name(), $datetimeId); |
|
63 | - foreach ($related_models as $key => $model) { |
|
64 | - // Get the IDs of related entities for the datetime ID. |
|
65 | - $Ids = $model->get_col([ |
|
66 | - [ 'Datetime.DTT_ID' => $datetimeId ], |
|
67 | - 'default_where_conditions' => 'minimum', |
|
68 | - ]); |
|
69 | - $this->data['datetimes'][ $GID ][ $key ] = ! empty($Ids) |
|
70 | - ? $this->utilities->convertToGlobalId($model->item_name(), $Ids) |
|
71 | - : []; |
|
72 | - } |
|
73 | - } |
|
74 | - return $datetimeIds; |
|
75 | - } |
|
45 | + /** |
|
46 | + * @param int $eventId |
|
47 | + * @return array |
|
48 | + * @throws EE_Error |
|
49 | + * @since $VID:$ |
|
50 | + */ |
|
51 | + private function processDatetimes(int $eventId) |
|
52 | + { |
|
53 | + $related_models = [ |
|
54 | + 'tickets' => $this->ticket_model, |
|
55 | + ]; |
|
56 | + // Get the IDs of event datetimes. |
|
57 | + $datetimeIds = $this->datetime_model->get_col([ |
|
58 | + [ 'EVT_ID' => $eventId ], |
|
59 | + 'default_where_conditions' => 'minimum', |
|
60 | + ]); |
|
61 | + foreach ($datetimeIds as $datetimeId) { |
|
62 | + $GID = $this->utilities->convertToGlobalId($this->datetime_model->item_name(), $datetimeId); |
|
63 | + foreach ($related_models as $key => $model) { |
|
64 | + // Get the IDs of related entities for the datetime ID. |
|
65 | + $Ids = $model->get_col([ |
|
66 | + [ 'Datetime.DTT_ID' => $datetimeId ], |
|
67 | + 'default_where_conditions' => 'minimum', |
|
68 | + ]); |
|
69 | + $this->data['datetimes'][ $GID ][ $key ] = ! empty($Ids) |
|
70 | + ? $this->utilities->convertToGlobalId($model->item_name(), $Ids) |
|
71 | + : []; |
|
72 | + } |
|
73 | + } |
|
74 | + return $datetimeIds; |
|
75 | + } |
|
76 | 76 | |
77 | 77 | |
78 | - /** |
|
79 | - * @param array $datetimeIds |
|
80 | - * @return array |
|
81 | - * @throws EE_Error |
|
82 | - * @since $VID:$ |
|
83 | - */ |
|
84 | - private function processTickets(array $datetimeIds) |
|
85 | - { |
|
86 | - $related_models = [ |
|
87 | - 'datetimes' => $this->datetime_model, |
|
88 | - 'prices' => $this->price_model, |
|
89 | - ]; |
|
90 | - // Get the IDs of all datetime tickets. |
|
91 | - $ticketIds = $this->ticket_model->get_col([ |
|
92 | - [ |
|
93 | - 'OR' => [ |
|
94 | - 'Datetime.DTT_ID' => ['IN', $datetimeIds], |
|
95 | - 'TKT_is_default' => 1, |
|
96 | - ] |
|
97 | - ], |
|
98 | - 'default_where_conditions' => 'minimum', |
|
99 | - ]); |
|
100 | - foreach ($ticketIds as $ticketId) { |
|
101 | - $GID = $this->utilities->convertToGlobalId($this->ticket_model->item_name(), $ticketId); |
|
78 | + /** |
|
79 | + * @param array $datetimeIds |
|
80 | + * @return array |
|
81 | + * @throws EE_Error |
|
82 | + * @since $VID:$ |
|
83 | + */ |
|
84 | + private function processTickets(array $datetimeIds) |
|
85 | + { |
|
86 | + $related_models = [ |
|
87 | + 'datetimes' => $this->datetime_model, |
|
88 | + 'prices' => $this->price_model, |
|
89 | + ]; |
|
90 | + // Get the IDs of all datetime tickets. |
|
91 | + $ticketIds = $this->ticket_model->get_col([ |
|
92 | + [ |
|
93 | + 'OR' => [ |
|
94 | + 'Datetime.DTT_ID' => ['IN', $datetimeIds], |
|
95 | + 'TKT_is_default' => 1, |
|
96 | + ] |
|
97 | + ], |
|
98 | + 'default_where_conditions' => 'minimum', |
|
99 | + ]); |
|
100 | + foreach ($ticketIds as $ticketId) { |
|
101 | + $GID = $this->utilities->convertToGlobalId($this->ticket_model->item_name(), $ticketId); |
|
102 | 102 | |
103 | - foreach ($related_models as $key => $model) { |
|
104 | - // Get the IDs of related entities for the ticket ID. |
|
105 | - $Ids = $model->get_col([ |
|
106 | - [ 'Ticket.TKT_ID' => $ticketId ], |
|
107 | - 'default_where_conditions' => 'minimum', |
|
108 | - ]); |
|
109 | - $this->data['tickets'][ $GID ][ $key ] = ! empty($Ids) |
|
110 | - ? $this->utilities->convertToGlobalId($model->item_name(), $Ids) |
|
111 | - : []; |
|
112 | - } |
|
113 | - } |
|
114 | - return $ticketIds; |
|
115 | - } |
|
103 | + foreach ($related_models as $key => $model) { |
|
104 | + // Get the IDs of related entities for the ticket ID. |
|
105 | + $Ids = $model->get_col([ |
|
106 | + [ 'Ticket.TKT_ID' => $ticketId ], |
|
107 | + 'default_where_conditions' => 'minimum', |
|
108 | + ]); |
|
109 | + $this->data['tickets'][ $GID ][ $key ] = ! empty($Ids) |
|
110 | + ? $this->utilities->convertToGlobalId($model->item_name(), $Ids) |
|
111 | + : []; |
|
112 | + } |
|
113 | + } |
|
114 | + return $ticketIds; |
|
115 | + } |
|
116 | 116 | |
117 | 117 | |
118 | - /** |
|
119 | - * @param array $ticketIds |
|
120 | - * @throws EE_Error |
|
121 | - * @since $VID:$ |
|
122 | - */ |
|
123 | - private function processPrices(array $ticketIds) |
|
124 | - { |
|
125 | - $related_models = [ |
|
126 | - 'tickets' => $this->ticket_model, |
|
127 | - 'priceTypes' => $this->price_type_model, |
|
128 | - ]; |
|
129 | - // Get the IDs of all ticket prices and default prices |
|
130 | - $priceIds = $this->price_model->get_col([ |
|
131 | - [ |
|
132 | - 'OR' => [ |
|
133 | - // either the price is related to any of these tickets |
|
134 | - 'Ticket.TKT_ID' => ['IN', $ticketIds], |
|
135 | - // or it's a default price and not trashed |
|
136 | - 'AND' => [ |
|
137 | - 'PRC_deleted' => 0, |
|
138 | - 'PRC_is_default' => 1, |
|
139 | - ], |
|
140 | - ], |
|
141 | - ], |
|
142 | - 'group_by' => 'PRC_ID', |
|
143 | - 'default_where_conditions' => 'minimum', |
|
144 | - ]); |
|
145 | - foreach ($priceIds as $priceId) { |
|
146 | - $GID = $this->utilities->convertToGlobalId($this->price_model->item_name(), $priceId); |
|
118 | + /** |
|
119 | + * @param array $ticketIds |
|
120 | + * @throws EE_Error |
|
121 | + * @since $VID:$ |
|
122 | + */ |
|
123 | + private function processPrices(array $ticketIds) |
|
124 | + { |
|
125 | + $related_models = [ |
|
126 | + 'tickets' => $this->ticket_model, |
|
127 | + 'priceTypes' => $this->price_type_model, |
|
128 | + ]; |
|
129 | + // Get the IDs of all ticket prices and default prices |
|
130 | + $priceIds = $this->price_model->get_col([ |
|
131 | + [ |
|
132 | + 'OR' => [ |
|
133 | + // either the price is related to any of these tickets |
|
134 | + 'Ticket.TKT_ID' => ['IN', $ticketIds], |
|
135 | + // or it's a default price and not trashed |
|
136 | + 'AND' => [ |
|
137 | + 'PRC_deleted' => 0, |
|
138 | + 'PRC_is_default' => 1, |
|
139 | + ], |
|
140 | + ], |
|
141 | + ], |
|
142 | + 'group_by' => 'PRC_ID', |
|
143 | + 'default_where_conditions' => 'minimum', |
|
144 | + ]); |
|
145 | + foreach ($priceIds as $priceId) { |
|
146 | + $GID = $this->utilities->convertToGlobalId($this->price_model->item_name(), $priceId); |
|
147 | 147 | |
148 | - foreach ($related_models as $key => $model) { |
|
149 | - // Get the IDs of related entities for the price ID. |
|
150 | - $Ids = $model->get_col([ |
|
151 | - [ 'Price.PRC_ID' => $priceId ], |
|
152 | - 'default_where_conditions' => 'minimum', |
|
153 | - ]); |
|
154 | - $this->data['prices'][ $GID ][ $key ] = ! empty($Ids) |
|
155 | - ? $this->utilities->convertToGlobalId($model->item_name(), $Ids) |
|
156 | - : []; |
|
157 | - } |
|
158 | - } |
|
159 | - } |
|
148 | + foreach ($related_models as $key => $model) { |
|
149 | + // Get the IDs of related entities for the price ID. |
|
150 | + $Ids = $model->get_col([ |
|
151 | + [ 'Price.PRC_ID' => $priceId ], |
|
152 | + 'default_where_conditions' => 'minimum', |
|
153 | + ]); |
|
154 | + $this->data['prices'][ $GID ][ $key ] = ! empty($Ids) |
|
155 | + ? $this->utilities->convertToGlobalId($model->item_name(), $Ids) |
|
156 | + : []; |
|
157 | + } |
|
158 | + } |
|
159 | + } |
|
160 | 160 | } |
@@ -67,7 +67,7 @@ discard block |
||
67 | 67 | */ |
68 | 68 | public function create(EE_Base_Class $entity): array |
69 | 69 | { |
70 | - if (! $entity instanceof EE_Ticket) { |
|
70 | + if ( ! $entity instanceof EE_Ticket) { |
|
71 | 71 | throw new InvalidEntityException($entity, 'EE_Ticket'); |
72 | 72 | } |
73 | 73 | $is_free = true; |
@@ -91,9 +91,9 @@ discard block |
||
91 | 91 | $has_base_price, |
92 | 92 | $is_free |
93 | 93 | ); |
94 | - if (! $has_base_price) { |
|
94 | + if ( ! $has_base_price) { |
|
95 | 95 | $new_base_price = $this->createNewBasePrice($entity); |
96 | - $this->new_prices[ $new_base_price->ID() ] = $new_base_price; |
|
96 | + $this->new_prices[$new_base_price->ID()] = $new_base_price; |
|
97 | 97 | } |
98 | 98 | $this->applyTaxes($entity, $is_free); |
99 | 99 | $ticket_total = $entity->get_ticket_total_with_taxes(true); |
@@ -113,7 +113,7 @@ discard block |
||
113 | 113 | */ |
114 | 114 | private function applyTaxes(EE_Ticket $ticket, bool $is_free) |
115 | 115 | { |
116 | - if (! $is_free && $ticket->taxable() && ! empty($this->taxes)) { |
|
116 | + if ( ! $is_free && $ticket->taxable() && ! empty($this->taxes)) { |
|
117 | 117 | foreach ($this->taxes as $tax) { |
118 | 118 | // assign taxes but don't duplicate them because they operate globally |
119 | 119 | $ticket->set_taxable(true); |
@@ -162,12 +162,12 @@ discard block |
||
162 | 162 | $is_base_price = $default_price_clone->is_base_price(); |
163 | 163 | // add this price to ticket if it is a regular price modifier, ie: NOT a base price, |
164 | 164 | // OR if it IS a base price but this ticket does NOT already have a base price |
165 | - if (! $is_base_price || ! $has_base_price) { |
|
165 | + if ( ! $is_base_price || ! $has_base_price) { |
|
166 | 166 | $default_price_clone->set('PRC_ID', null); |
167 | 167 | $default_price_clone->set('PRC_is_default', false); |
168 | 168 | $default_price_clone->save(); |
169 | 169 | $default_price_clone->_add_relation_to($ticket, 'Ticket'); |
170 | - $this->new_prices[ $default_price_clone->ID() ] = $default_price_clone; |
|
170 | + $this->new_prices[$default_price_clone->ID()] = $default_price_clone; |
|
171 | 171 | // then recheck that a base price has been set so that we don't add another one |
172 | 172 | $has_base_price = $is_base_price ? true : $has_base_price; |
173 | 173 | } |
@@ -192,7 +192,7 @@ discard block |
||
192 | 192 | ], |
193 | 193 | ] |
194 | 194 | ); |
195 | - if (! $base_price_type instanceof EE_Price_Type) { |
|
195 | + if ( ! $base_price_type instanceof EE_Price_Type) { |
|
196 | 196 | throw new RuntimeException( |
197 | 197 | esc_html__( |
198 | 198 | 'A valid base price type could not be retrieved from the database.', |
@@ -219,15 +219,15 @@ discard block |
||
219 | 219 | $default_prices = []; |
220 | 220 | if (is_array($prices)) { |
221 | 221 | foreach ($prices as $key => $price) { |
222 | - if (! $price instanceof EE_Price) { |
|
222 | + if ( ! $price instanceof EE_Price) { |
|
223 | 223 | throw new InvalidEntityException($price, 'EE_Price'); |
224 | 224 | } |
225 | 225 | // grab any taxes but don't do anything just yet |
226 | 226 | if ($price->is_tax()) { |
227 | - $this->taxes[ $price->ID() ] = $price; |
|
227 | + $this->taxes[$price->ID()] = $price; |
|
228 | 228 | continue; |
229 | 229 | } |
230 | - $default_prices[ $price->ID() ] = $price; |
|
230 | + $default_prices[$price->ID()] = $price; |
|
231 | 231 | } |
232 | 232 | } |
233 | 233 | return $default_prices; |
@@ -24,223 +24,223 @@ |
||
24 | 24 | */ |
25 | 25 | class DefaultPrices implements DefaultEntityGeneratorInterface |
26 | 26 | { |
27 | - /** |
|
28 | - * @var EEM_Price |
|
29 | - */ |
|
30 | - protected $price_model; |
|
31 | - |
|
32 | - /** |
|
33 | - * @var EEM_Price_Type |
|
34 | - */ |
|
35 | - protected $price_type_model; |
|
36 | - |
|
37 | - /** |
|
38 | - * @var EE_Price[] |
|
39 | - */ |
|
40 | - protected $new_prices = []; |
|
41 | - |
|
42 | - /** |
|
43 | - * @var EE_Price[] |
|
44 | - */ |
|
45 | - protected $taxes = []; |
|
46 | - |
|
47 | - |
|
48 | - /** |
|
49 | - * @param EEM_Price $price_model |
|
50 | - * @param EEM_Price_Type $price_type_model |
|
51 | - */ |
|
52 | - public function __construct(EEM_Price $price_model, EEM_Price_Type $price_type_model) |
|
53 | - { |
|
54 | - $this->price_model = $price_model; |
|
55 | - $this->price_type_model = $price_type_model; |
|
56 | - } |
|
57 | - |
|
58 | - |
|
59 | - /** |
|
60 | - * @param EE_Ticket|EE_Base_Class $entity |
|
61 | - * @return EE_Price[] |
|
62 | - * @throws EE_Error |
|
63 | - * @throws InvalidInterfaceException |
|
64 | - * @throws ReflectionException |
|
65 | - * @since $VID:$ |
|
66 | - */ |
|
67 | - public function create(EE_Base_Class $entity): array |
|
68 | - { |
|
69 | - if (! $entity instanceof EE_Ticket) { |
|
70 | - throw new InvalidEntityException($entity, 'EE_Ticket'); |
|
71 | - } |
|
72 | - $is_free = true; |
|
73 | - $has_base_price = false; |
|
74 | - $remove_existing_relations = true; |
|
75 | - // first, let's get all of the default taxes for the site |
|
76 | - $this->taxes = $this->price_model->getAllDefaultTaxes(); |
|
77 | - // then separate taxes from the other prices for the existing default ticket prices |
|
78 | - $default_prices = $this->separateTaxesFromOtherPrices($entity->prices()); |
|
79 | - // but if that's empty, then let's get the default global prices |
|
80 | - if (empty($default_prices)) { |
|
81 | - $default_global_prices = $this->price_model->get_all_default_prices(); |
|
82 | - $default_prices = $this->separateTaxesFromOtherPrices($default_global_prices); |
|
83 | - $remove_existing_relations = false; |
|
84 | - } |
|
85 | - // then clone and apply all of the default prices |
|
86 | - [$has_base_price, $is_free] = $this->cloneDefaultPrices( |
|
87 | - $entity, |
|
88 | - $default_prices, |
|
89 | - $remove_existing_relations, |
|
90 | - $has_base_price, |
|
91 | - $is_free |
|
92 | - ); |
|
93 | - if (! $has_base_price) { |
|
94 | - $new_base_price = $this->createNewBasePrice($entity); |
|
95 | - $this->new_prices[ $new_base_price->ID() ] = $new_base_price; |
|
96 | - } |
|
97 | - $this->applyTaxes($entity, $is_free); |
|
98 | - $ticket_total = $entity->get_ticket_total_with_taxes(true); |
|
99 | - if ($ticket_total !== $entity->ticket_price()) { |
|
100 | - $entity->set_price($ticket_total); |
|
101 | - $entity->save(); |
|
102 | - } |
|
103 | - return $this->new_prices; |
|
104 | - } |
|
105 | - |
|
106 | - |
|
107 | - /** |
|
108 | - * @param EE_Ticket $ticket |
|
109 | - * @param bool $is_free |
|
110 | - * @throws EE_Error |
|
111 | - * @throws ReflectionException |
|
112 | - */ |
|
113 | - private function applyTaxes(EE_Ticket $ticket, bool $is_free) |
|
114 | - { |
|
115 | - if (! $is_free && $ticket->taxable() && ! empty($this->taxes)) { |
|
116 | - foreach ($this->taxes as $tax) { |
|
117 | - // assign taxes but don't duplicate them because they operate globally |
|
118 | - $ticket->set_taxable(true); |
|
119 | - $tax->_add_relation_to($ticket, 'Ticket'); |
|
120 | - } |
|
121 | - } |
|
122 | - } |
|
123 | - |
|
124 | - |
|
125 | - /** |
|
126 | - * @param EE_Ticket $ticket |
|
127 | - * @param EE_Price[] $default_prices |
|
128 | - * @param bool $remove_existing_relations |
|
129 | - * @param bool $has_base_price |
|
130 | - * @param bool $is_free |
|
131 | - * @return bool[] |
|
132 | - * @throws EE_Error |
|
133 | - * @throws ReflectionException |
|
134 | - */ |
|
135 | - private function cloneDefaultPrices( |
|
136 | - EE_Ticket $ticket, |
|
137 | - array $default_prices, |
|
138 | - bool $remove_existing_relations, |
|
139 | - bool $has_base_price, |
|
140 | - bool $is_free |
|
141 | - ): array { |
|
142 | - foreach ($default_prices as $default_price) { |
|
143 | - // duplicate the default price so that it does not get mutated |
|
144 | - $default_price_clone = clone $default_price; |
|
145 | - if ($remove_existing_relations) { |
|
146 | - $ticket->_remove_relation_to($default_price, 'Price'); |
|
147 | - } |
|
148 | - if ( |
|
149 | - ( |
|
150 | - // has non-zero base price |
|
151 | - $default_price_clone->is_base_price() |
|
152 | - && $default_price_clone->amount() > 0 |
|
153 | - ) |
|
154 | - || ( |
|
155 | - // or has fixed amount surcharge |
|
156 | - $default_price_clone->is_surcharge() |
|
157 | - && ! $default_price_clone->is_percent() |
|
158 | - ) |
|
159 | - ) { |
|
160 | - $is_free = false; |
|
161 | - } |
|
162 | - $is_base_price = $default_price_clone->is_base_price(); |
|
163 | - // add this price to ticket if it is a regular price modifier, ie: NOT a base price, |
|
164 | - // OR if it IS a base price but this ticket does NOT already have a base price |
|
165 | - if (! $is_base_price || ! $has_base_price) { |
|
166 | - $default_price_clone->set('PRC_ID', null); |
|
167 | - $default_price_clone->set('PRC_is_default', false); |
|
168 | - |
|
169 | - $order = $default_price_clone->get('PRC_order'); |
|
170 | - |
|
171 | - // enforce base price order to be 1 and 5 if the order is not set for a modifier |
|
172 | - $order = $is_base_price ? 1 : $order; |
|
173 | - $order = $order ?? 5; |
|
174 | - |
|
175 | - $default_price_clone->set('PRC_order', $order); |
|
176 | - |
|
177 | - $default_price_clone->save(); |
|
178 | - $default_price_clone->_add_relation_to($ticket, 'Ticket'); |
|
179 | - $this->new_prices[ $default_price_clone->ID() ] = $default_price_clone; |
|
180 | - // then recheck that a base price has been set so that we don't add another one |
|
181 | - $has_base_price = $is_base_price ? true : $has_base_price; |
|
182 | - } |
|
183 | - } |
|
184 | - return [$has_base_price, $is_free]; |
|
185 | - } |
|
186 | - |
|
187 | - |
|
188 | - /** |
|
189 | - * @param EE_Ticket $ticket |
|
190 | - * @return EE_Price |
|
191 | - * @throws EE_Error |
|
192 | - * @throws ReflectionException |
|
193 | - */ |
|
194 | - private function createNewBasePrice(EE_Ticket $ticket): EE_Price |
|
195 | - { |
|
196 | - $new_base_price = $this->price_model->get_new_price(); |
|
197 | - $base_price_type = $this->price_type_model->get_one( |
|
198 | - [ |
|
199 | - [ |
|
200 | - 'PBT_ID' => EEM_Price_Type::base_type_base_price, |
|
201 | - ], |
|
202 | - ] |
|
203 | - ); |
|
204 | - if (! $base_price_type instanceof EE_Price_Type) { |
|
205 | - throw new RuntimeException( |
|
206 | - esc_html__( |
|
207 | - 'A valid base price type could not be retrieved from the database.', |
|
208 | - 'event_espresso' |
|
209 | - ) |
|
210 | - ); |
|
211 | - } |
|
212 | - $new_base_price->set('PRT_ID', $base_price_type->ID()); |
|
213 | - // set base price order to 1 |
|
214 | - $new_base_price->set('PRC_order', 1); |
|
215 | - $new_base_price->set('PRC_is_default', false); |
|
216 | - $new_base_price->save(); |
|
217 | - $new_base_price->_add_relation_to($ticket, 'Ticket'); |
|
218 | - return $new_base_price; |
|
219 | - } |
|
220 | - |
|
221 | - |
|
222 | - /** |
|
223 | - * @param array $prices |
|
224 | - * @return array |
|
225 | - * @throws EE_Error |
|
226 | - * @throws ReflectionException |
|
227 | - */ |
|
228 | - private function separateTaxesFromOtherPrices(array $prices = []): array |
|
229 | - { |
|
230 | - $default_prices = []; |
|
231 | - if (is_array($prices)) { |
|
232 | - foreach ($prices as $key => $price) { |
|
233 | - if (! $price instanceof EE_Price) { |
|
234 | - throw new InvalidEntityException($price, 'EE_Price'); |
|
235 | - } |
|
236 | - // grab any taxes but don't do anything just yet |
|
237 | - if ($price->is_tax()) { |
|
238 | - $this->taxes[ $price->ID() ] = $price; |
|
239 | - continue; |
|
240 | - } |
|
241 | - $default_prices[ $price->ID() ] = $price; |
|
242 | - } |
|
243 | - } |
|
244 | - return $default_prices; |
|
245 | - } |
|
27 | + /** |
|
28 | + * @var EEM_Price |
|
29 | + */ |
|
30 | + protected $price_model; |
|
31 | + |
|
32 | + /** |
|
33 | + * @var EEM_Price_Type |
|
34 | + */ |
|
35 | + protected $price_type_model; |
|
36 | + |
|
37 | + /** |
|
38 | + * @var EE_Price[] |
|
39 | + */ |
|
40 | + protected $new_prices = []; |
|
41 | + |
|
42 | + /** |
|
43 | + * @var EE_Price[] |
|
44 | + */ |
|
45 | + protected $taxes = []; |
|
46 | + |
|
47 | + |
|
48 | + /** |
|
49 | + * @param EEM_Price $price_model |
|
50 | + * @param EEM_Price_Type $price_type_model |
|
51 | + */ |
|
52 | + public function __construct(EEM_Price $price_model, EEM_Price_Type $price_type_model) |
|
53 | + { |
|
54 | + $this->price_model = $price_model; |
|
55 | + $this->price_type_model = $price_type_model; |
|
56 | + } |
|
57 | + |
|
58 | + |
|
59 | + /** |
|
60 | + * @param EE_Ticket|EE_Base_Class $entity |
|
61 | + * @return EE_Price[] |
|
62 | + * @throws EE_Error |
|
63 | + * @throws InvalidInterfaceException |
|
64 | + * @throws ReflectionException |
|
65 | + * @since $VID:$ |
|
66 | + */ |
|
67 | + public function create(EE_Base_Class $entity): array |
|
68 | + { |
|
69 | + if (! $entity instanceof EE_Ticket) { |
|
70 | + throw new InvalidEntityException($entity, 'EE_Ticket'); |
|
71 | + } |
|
72 | + $is_free = true; |
|
73 | + $has_base_price = false; |
|
74 | + $remove_existing_relations = true; |
|
75 | + // first, let's get all of the default taxes for the site |
|
76 | + $this->taxes = $this->price_model->getAllDefaultTaxes(); |
|
77 | + // then separate taxes from the other prices for the existing default ticket prices |
|
78 | + $default_prices = $this->separateTaxesFromOtherPrices($entity->prices()); |
|
79 | + // but if that's empty, then let's get the default global prices |
|
80 | + if (empty($default_prices)) { |
|
81 | + $default_global_prices = $this->price_model->get_all_default_prices(); |
|
82 | + $default_prices = $this->separateTaxesFromOtherPrices($default_global_prices); |
|
83 | + $remove_existing_relations = false; |
|
84 | + } |
|
85 | + // then clone and apply all of the default prices |
|
86 | + [$has_base_price, $is_free] = $this->cloneDefaultPrices( |
|
87 | + $entity, |
|
88 | + $default_prices, |
|
89 | + $remove_existing_relations, |
|
90 | + $has_base_price, |
|
91 | + $is_free |
|
92 | + ); |
|
93 | + if (! $has_base_price) { |
|
94 | + $new_base_price = $this->createNewBasePrice($entity); |
|
95 | + $this->new_prices[ $new_base_price->ID() ] = $new_base_price; |
|
96 | + } |
|
97 | + $this->applyTaxes($entity, $is_free); |
|
98 | + $ticket_total = $entity->get_ticket_total_with_taxes(true); |
|
99 | + if ($ticket_total !== $entity->ticket_price()) { |
|
100 | + $entity->set_price($ticket_total); |
|
101 | + $entity->save(); |
|
102 | + } |
|
103 | + return $this->new_prices; |
|
104 | + } |
|
105 | + |
|
106 | + |
|
107 | + /** |
|
108 | + * @param EE_Ticket $ticket |
|
109 | + * @param bool $is_free |
|
110 | + * @throws EE_Error |
|
111 | + * @throws ReflectionException |
|
112 | + */ |
|
113 | + private function applyTaxes(EE_Ticket $ticket, bool $is_free) |
|
114 | + { |
|
115 | + if (! $is_free && $ticket->taxable() && ! empty($this->taxes)) { |
|
116 | + foreach ($this->taxes as $tax) { |
|
117 | + // assign taxes but don't duplicate them because they operate globally |
|
118 | + $ticket->set_taxable(true); |
|
119 | + $tax->_add_relation_to($ticket, 'Ticket'); |
|
120 | + } |
|
121 | + } |
|
122 | + } |
|
123 | + |
|
124 | + |
|
125 | + /** |
|
126 | + * @param EE_Ticket $ticket |
|
127 | + * @param EE_Price[] $default_prices |
|
128 | + * @param bool $remove_existing_relations |
|
129 | + * @param bool $has_base_price |
|
130 | + * @param bool $is_free |
|
131 | + * @return bool[] |
|
132 | + * @throws EE_Error |
|
133 | + * @throws ReflectionException |
|
134 | + */ |
|
135 | + private function cloneDefaultPrices( |
|
136 | + EE_Ticket $ticket, |
|
137 | + array $default_prices, |
|
138 | + bool $remove_existing_relations, |
|
139 | + bool $has_base_price, |
|
140 | + bool $is_free |
|
141 | + ): array { |
|
142 | + foreach ($default_prices as $default_price) { |
|
143 | + // duplicate the default price so that it does not get mutated |
|
144 | + $default_price_clone = clone $default_price; |
|
145 | + if ($remove_existing_relations) { |
|
146 | + $ticket->_remove_relation_to($default_price, 'Price'); |
|
147 | + } |
|
148 | + if ( |
|
149 | + ( |
|
150 | + // has non-zero base price |
|
151 | + $default_price_clone->is_base_price() |
|
152 | + && $default_price_clone->amount() > 0 |
|
153 | + ) |
|
154 | + || ( |
|
155 | + // or has fixed amount surcharge |
|
156 | + $default_price_clone->is_surcharge() |
|
157 | + && ! $default_price_clone->is_percent() |
|
158 | + ) |
|
159 | + ) { |
|
160 | + $is_free = false; |
|
161 | + } |
|
162 | + $is_base_price = $default_price_clone->is_base_price(); |
|
163 | + // add this price to ticket if it is a regular price modifier, ie: NOT a base price, |
|
164 | + // OR if it IS a base price but this ticket does NOT already have a base price |
|
165 | + if (! $is_base_price || ! $has_base_price) { |
|
166 | + $default_price_clone->set('PRC_ID', null); |
|
167 | + $default_price_clone->set('PRC_is_default', false); |
|
168 | + |
|
169 | + $order = $default_price_clone->get('PRC_order'); |
|
170 | + |
|
171 | + // enforce base price order to be 1 and 5 if the order is not set for a modifier |
|
172 | + $order = $is_base_price ? 1 : $order; |
|
173 | + $order = $order ?? 5; |
|
174 | + |
|
175 | + $default_price_clone->set('PRC_order', $order); |
|
176 | + |
|
177 | + $default_price_clone->save(); |
|
178 | + $default_price_clone->_add_relation_to($ticket, 'Ticket'); |
|
179 | + $this->new_prices[ $default_price_clone->ID() ] = $default_price_clone; |
|
180 | + // then recheck that a base price has been set so that we don't add another one |
|
181 | + $has_base_price = $is_base_price ? true : $has_base_price; |
|
182 | + } |
|
183 | + } |
|
184 | + return [$has_base_price, $is_free]; |
|
185 | + } |
|
186 | + |
|
187 | + |
|
188 | + /** |
|
189 | + * @param EE_Ticket $ticket |
|
190 | + * @return EE_Price |
|
191 | + * @throws EE_Error |
|
192 | + * @throws ReflectionException |
|
193 | + */ |
|
194 | + private function createNewBasePrice(EE_Ticket $ticket): EE_Price |
|
195 | + { |
|
196 | + $new_base_price = $this->price_model->get_new_price(); |
|
197 | + $base_price_type = $this->price_type_model->get_one( |
|
198 | + [ |
|
199 | + [ |
|
200 | + 'PBT_ID' => EEM_Price_Type::base_type_base_price, |
|
201 | + ], |
|
202 | + ] |
|
203 | + ); |
|
204 | + if (! $base_price_type instanceof EE_Price_Type) { |
|
205 | + throw new RuntimeException( |
|
206 | + esc_html__( |
|
207 | + 'A valid base price type could not be retrieved from the database.', |
|
208 | + 'event_espresso' |
|
209 | + ) |
|
210 | + ); |
|
211 | + } |
|
212 | + $new_base_price->set('PRT_ID', $base_price_type->ID()); |
|
213 | + // set base price order to 1 |
|
214 | + $new_base_price->set('PRC_order', 1); |
|
215 | + $new_base_price->set('PRC_is_default', false); |
|
216 | + $new_base_price->save(); |
|
217 | + $new_base_price->_add_relation_to($ticket, 'Ticket'); |
|
218 | + return $new_base_price; |
|
219 | + } |
|
220 | + |
|
221 | + |
|
222 | + /** |
|
223 | + * @param array $prices |
|
224 | + * @return array |
|
225 | + * @throws EE_Error |
|
226 | + * @throws ReflectionException |
|
227 | + */ |
|
228 | + private function separateTaxesFromOtherPrices(array $prices = []): array |
|
229 | + { |
|
230 | + $default_prices = []; |
|
231 | + if (is_array($prices)) { |
|
232 | + foreach ($prices as $key => $price) { |
|
233 | + if (! $price instanceof EE_Price) { |
|
234 | + throw new InvalidEntityException($price, 'EE_Price'); |
|
235 | + } |
|
236 | + // grab any taxes but don't do anything just yet |
|
237 | + if ($price->is_tax()) { |
|
238 | + $this->taxes[ $price->ID() ] = $price; |
|
239 | + continue; |
|
240 | + } |
|
241 | + $default_prices[ $price->ID() ] = $price; |
|
242 | + } |
|
243 | + } |
|
244 | + return $default_prices; |
|
245 | + } |
|
246 | 246 | } |
@@ -110,13 +110,13 @@ |
||
110 | 110 | 'WP_User' => new EE_Belongs_To_Relation(), |
111 | 111 | ]; |
112 | 112 | // this model is generally available for reading |
113 | - $this->_cap_restriction_generators[ EEM_Base::caps_read ] = |
|
113 | + $this->_cap_restriction_generators[EEM_Base::caps_read] = |
|
114 | 114 | new EE_Restriction_Generator_Public(); |
115 | - $this->_cap_restriction_generators[ EEM_Base::caps_read_admin ] = |
|
115 | + $this->_cap_restriction_generators[EEM_Base::caps_read_admin] = |
|
116 | 116 | new EE_Restriction_Generator_Reg_Form('QSG_system'); |
117 | - $this->_cap_restriction_generators[ EEM_Base::caps_edit ] = |
|
117 | + $this->_cap_restriction_generators[EEM_Base::caps_edit] = |
|
118 | 118 | new EE_Restriction_Generator_Reg_Form('QSG_system'); |
119 | - $this->_cap_restriction_generators[ EEM_Base::caps_delete ] = |
|
119 | + $this->_cap_restriction_generators[EEM_Base::caps_delete] = |
|
120 | 120 | new EE_Restriction_Generator_Reg_Form('QSG_system'); |
121 | 121 | |
122 | 122 | parent::__construct($timezone); |
@@ -9,136 +9,136 @@ |
||
9 | 9 | */ |
10 | 10 | class EEM_Question_Group extends EEM_Soft_Delete_Base |
11 | 11 | { |
12 | - const system_personal = 1; |
|
12 | + const system_personal = 1; |
|
13 | 13 | |
14 | - const system_address = 2; |
|
14 | + const system_address = 2; |
|
15 | 15 | |
16 | - /** |
|
17 | - * private instance of the EEM_Question_Group object |
|
18 | - * |
|
19 | - * @var EEM_Question_Group |
|
20 | - */ |
|
21 | - protected static $_instance = null; |
|
16 | + /** |
|
17 | + * private instance of the EEM_Question_Group object |
|
18 | + * |
|
19 | + * @var EEM_Question_Group |
|
20 | + */ |
|
21 | + protected static $_instance = null; |
|
22 | 22 | |
23 | 23 | |
24 | - /** |
|
25 | - * EEM_Question_Group constructor. |
|
26 | - * |
|
27 | - * @param string|null $timezone |
|
28 | - */ |
|
29 | - protected function __construct($timezone = null) |
|
30 | - { |
|
31 | - $this->singular_item = esc_html__('Question Group', 'event_espresso'); |
|
32 | - $this->plural_item = esc_html__('Question Groups', 'event_espresso'); |
|
24 | + /** |
|
25 | + * EEM_Question_Group constructor. |
|
26 | + * |
|
27 | + * @param string|null $timezone |
|
28 | + */ |
|
29 | + protected function __construct($timezone = null) |
|
30 | + { |
|
31 | + $this->singular_item = esc_html__('Question Group', 'event_espresso'); |
|
32 | + $this->plural_item = esc_html__('Question Groups', 'event_espresso'); |
|
33 | 33 | |
34 | - $this->_tables = [ |
|
35 | - 'Question_Group' => new EE_Primary_Table('esp_question_group', 'QSG_ID'), |
|
36 | - ]; |
|
37 | - $this->_fields = [ |
|
38 | - 'Question_Group' => [ |
|
39 | - 'QSG_ID' => new EE_Primary_Key_Int_Field( |
|
40 | - 'QSG_ID', |
|
41 | - esc_html__('Question Group ID', 'event_espresso') |
|
42 | - ), |
|
43 | - 'QSG_deleted' => new EE_Trashed_Flag_Field( |
|
44 | - 'QSG_deleted', |
|
45 | - esc_html__('Flag indicating this question group was deleted', 'event_espresso'), |
|
46 | - false, |
|
47 | - false |
|
48 | - ), |
|
49 | - 'QSG_desc' => new EE_Post_Content_Field( |
|
50 | - 'QSG_desc', |
|
51 | - esc_html__('Description of Question Group', 'event_espresso'), |
|
52 | - true, |
|
53 | - '' |
|
54 | - ), |
|
55 | - 'QSG_identifier' => new EE_Plain_Text_Field( |
|
56 | - 'QSG_identifier', |
|
57 | - esc_html__('Text ID for question Group', 'event_espresso'), |
|
58 | - false, |
|
59 | - '' |
|
60 | - ), |
|
61 | - 'QSG_name' => new EE_Plain_Text_Field( |
|
62 | - 'QSG_name', |
|
63 | - esc_html__('Question Group Name', 'event_espresso'), |
|
64 | - false, |
|
65 | - '' |
|
66 | - ), |
|
67 | - 'QSG_order' => new EE_Integer_Field( |
|
68 | - 'QSG_order', |
|
69 | - esc_html__('Order in which to show the question group', 'event_espresso'), |
|
70 | - true, |
|
71 | - 0 |
|
72 | - ), |
|
73 | - 'QSG_show_group_desc' => new EE_Boolean_Field( |
|
74 | - 'QSG_show_group_desc', |
|
75 | - esc_html__( |
|
76 | - 'Flag indicating whether to show the group\s description on the registration page', |
|
77 | - 'event_espresso' |
|
78 | - ), |
|
79 | - false, |
|
80 | - false |
|
81 | - ), |
|
82 | - 'QSG_show_group_name' => new EE_Boolean_Field( |
|
83 | - 'QSG_show_group_name', |
|
84 | - esc_html__( |
|
85 | - 'Flag indicating whether to show the group\'s name on the registration page', |
|
86 | - 'event_espresso' |
|
87 | - ), |
|
88 | - false, |
|
89 | - true |
|
90 | - ), |
|
91 | - 'QSG_system' => new EE_Integer_Field( |
|
92 | - 'QSG_system', |
|
93 | - esc_html__( |
|
94 | - 'Indicate IF this is a system group and if it is what system group it corresponds to.', |
|
95 | - 'event_espresso' |
|
96 | - ), |
|
97 | - false, |
|
98 | - 0 |
|
99 | - ), |
|
100 | - 'QSG_wp_user' => new EE_WP_User_Field( |
|
101 | - 'QSG_wp_user', |
|
102 | - esc_html__('Question Group Creator ID', 'event_espresso'), |
|
103 | - false |
|
104 | - ), |
|
105 | - ], |
|
106 | - ]; |
|
107 | - $this->_model_relations = [ |
|
108 | - 'Event' => new EE_HABTM_Relation('Event_Question_Group'), |
|
109 | - 'Event_Question_Group' => new EE_Has_Many_Relation(), |
|
110 | - 'Question' => new EE_HABTM_Relation('Question_Group_Question'), |
|
111 | - 'WP_User' => new EE_Belongs_To_Relation(), |
|
112 | - ]; |
|
113 | - // this model is generally available for reading |
|
114 | - $this->_cap_restriction_generators[ EEM_Base::caps_read ] = |
|
115 | - new EE_Restriction_Generator_Public(); |
|
116 | - $this->_cap_restriction_generators[ EEM_Base::caps_read_admin ] = |
|
117 | - new EE_Restriction_Generator_Reg_Form('QSG_system'); |
|
118 | - $this->_cap_restriction_generators[ EEM_Base::caps_edit ] = |
|
119 | - new EE_Restriction_Generator_Reg_Form('QSG_system'); |
|
120 | - $this->_cap_restriction_generators[ EEM_Base::caps_delete ] = |
|
121 | - new EE_Restriction_Generator_Reg_Form('QSG_system'); |
|
34 | + $this->_tables = [ |
|
35 | + 'Question_Group' => new EE_Primary_Table('esp_question_group', 'QSG_ID'), |
|
36 | + ]; |
|
37 | + $this->_fields = [ |
|
38 | + 'Question_Group' => [ |
|
39 | + 'QSG_ID' => new EE_Primary_Key_Int_Field( |
|
40 | + 'QSG_ID', |
|
41 | + esc_html__('Question Group ID', 'event_espresso') |
|
42 | + ), |
|
43 | + 'QSG_deleted' => new EE_Trashed_Flag_Field( |
|
44 | + 'QSG_deleted', |
|
45 | + esc_html__('Flag indicating this question group was deleted', 'event_espresso'), |
|
46 | + false, |
|
47 | + false |
|
48 | + ), |
|
49 | + 'QSG_desc' => new EE_Post_Content_Field( |
|
50 | + 'QSG_desc', |
|
51 | + esc_html__('Description of Question Group', 'event_espresso'), |
|
52 | + true, |
|
53 | + '' |
|
54 | + ), |
|
55 | + 'QSG_identifier' => new EE_Plain_Text_Field( |
|
56 | + 'QSG_identifier', |
|
57 | + esc_html__('Text ID for question Group', 'event_espresso'), |
|
58 | + false, |
|
59 | + '' |
|
60 | + ), |
|
61 | + 'QSG_name' => new EE_Plain_Text_Field( |
|
62 | + 'QSG_name', |
|
63 | + esc_html__('Question Group Name', 'event_espresso'), |
|
64 | + false, |
|
65 | + '' |
|
66 | + ), |
|
67 | + 'QSG_order' => new EE_Integer_Field( |
|
68 | + 'QSG_order', |
|
69 | + esc_html__('Order in which to show the question group', 'event_espresso'), |
|
70 | + true, |
|
71 | + 0 |
|
72 | + ), |
|
73 | + 'QSG_show_group_desc' => new EE_Boolean_Field( |
|
74 | + 'QSG_show_group_desc', |
|
75 | + esc_html__( |
|
76 | + 'Flag indicating whether to show the group\s description on the registration page', |
|
77 | + 'event_espresso' |
|
78 | + ), |
|
79 | + false, |
|
80 | + false |
|
81 | + ), |
|
82 | + 'QSG_show_group_name' => new EE_Boolean_Field( |
|
83 | + 'QSG_show_group_name', |
|
84 | + esc_html__( |
|
85 | + 'Flag indicating whether to show the group\'s name on the registration page', |
|
86 | + 'event_espresso' |
|
87 | + ), |
|
88 | + false, |
|
89 | + true |
|
90 | + ), |
|
91 | + 'QSG_system' => new EE_Integer_Field( |
|
92 | + 'QSG_system', |
|
93 | + esc_html__( |
|
94 | + 'Indicate IF this is a system group and if it is what system group it corresponds to.', |
|
95 | + 'event_espresso' |
|
96 | + ), |
|
97 | + false, |
|
98 | + 0 |
|
99 | + ), |
|
100 | + 'QSG_wp_user' => new EE_WP_User_Field( |
|
101 | + 'QSG_wp_user', |
|
102 | + esc_html__('Question Group Creator ID', 'event_espresso'), |
|
103 | + false |
|
104 | + ), |
|
105 | + ], |
|
106 | + ]; |
|
107 | + $this->_model_relations = [ |
|
108 | + 'Event' => new EE_HABTM_Relation('Event_Question_Group'), |
|
109 | + 'Event_Question_Group' => new EE_Has_Many_Relation(), |
|
110 | + 'Question' => new EE_HABTM_Relation('Question_Group_Question'), |
|
111 | + 'WP_User' => new EE_Belongs_To_Relation(), |
|
112 | + ]; |
|
113 | + // this model is generally available for reading |
|
114 | + $this->_cap_restriction_generators[ EEM_Base::caps_read ] = |
|
115 | + new EE_Restriction_Generator_Public(); |
|
116 | + $this->_cap_restriction_generators[ EEM_Base::caps_read_admin ] = |
|
117 | + new EE_Restriction_Generator_Reg_Form('QSG_system'); |
|
118 | + $this->_cap_restriction_generators[ EEM_Base::caps_edit ] = |
|
119 | + new EE_Restriction_Generator_Reg_Form('QSG_system'); |
|
120 | + $this->_cap_restriction_generators[ EEM_Base::caps_delete ] = |
|
121 | + new EE_Restriction_Generator_Reg_Form('QSG_system'); |
|
122 | 122 | |
123 | - parent::__construct($timezone); |
|
124 | - } |
|
123 | + parent::__construct($timezone); |
|
124 | + } |
|
125 | 125 | |
126 | 126 | |
127 | - /** |
|
128 | - * searches the db for the question group with the latest question order and returns that value. |
|
129 | - * |
|
130 | - * @return int |
|
131 | - * @throws EE_Error |
|
132 | - */ |
|
133 | - public function get_latest_question_group_order(): int |
|
134 | - { |
|
135 | - $max = $this->_get_all_wpdb_results( |
|
136 | - [], |
|
137 | - ARRAY_A, |
|
138 | - [ |
|
139 | - 'max_order' => ["MAX(QSG_order)", "%d"], |
|
140 | - ] |
|
141 | - ); |
|
142 | - return $max[0]['max_order']; |
|
143 | - } |
|
127 | + /** |
|
128 | + * searches the db for the question group with the latest question order and returns that value. |
|
129 | + * |
|
130 | + * @return int |
|
131 | + * @throws EE_Error |
|
132 | + */ |
|
133 | + public function get_latest_question_group_order(): int |
|
134 | + { |
|
135 | + $max = $this->_get_all_wpdb_results( |
|
136 | + [], |
|
137 | + ARRAY_A, |
|
138 | + [ |
|
139 | + 'max_order' => ["MAX(QSG_order)", "%d"], |
|
140 | + ] |
|
141 | + ); |
|
142 | + return $max[0]['max_order']; |
|
143 | + } |
|
144 | 144 | } |
@@ -74,13 +74,13 @@ |
||
74 | 74 | $this->_model_chain_to_wp_user = 'Question'; |
75 | 75 | |
76 | 76 | // this model is generally available for reading |
77 | - $this->_cap_restriction_generators[ EEM_Base::caps_read ] = |
|
77 | + $this->_cap_restriction_generators[EEM_Base::caps_read] = |
|
78 | 78 | new EE_Restriction_Generator_Public(); |
79 | - $this->_cap_restriction_generators[ EEM_Base::caps_read_admin ] = |
|
79 | + $this->_cap_restriction_generators[EEM_Base::caps_read_admin] = |
|
80 | 80 | new EE_Restriction_Generator_Reg_Form('QSO_system'); |
81 | - $this->_cap_restriction_generators[ EEM_Base::caps_edit ] = |
|
81 | + $this->_cap_restriction_generators[EEM_Base::caps_edit] = |
|
82 | 82 | new EE_Restriction_Generator_Reg_Form('QSO_system'); |
83 | - $this->_cap_restriction_generators[ EEM_Base::caps_delete ] = |
|
83 | + $this->_cap_restriction_generators[EEM_Base::caps_delete] = |
|
84 | 84 | new EE_Restriction_Generator_Reg_Form('QSO_system'); |
85 | 85 | |
86 | 86 | parent::__construct($timezone); |
@@ -9,80 +9,80 @@ |
||
9 | 9 | */ |
10 | 10 | class EEM_Question_Option extends EEM_Soft_Delete_Base |
11 | 11 | { |
12 | - // private instance of the Attendee object |
|
13 | - protected static $_instance = null; |
|
12 | + // private instance of the Attendee object |
|
13 | + protected static $_instance = null; |
|
14 | 14 | |
15 | 15 | |
16 | - protected function __construct($timezone = null) |
|
17 | - { |
|
18 | - $this->singular_item = esc_html__('Question Option', 'event_espresso'); |
|
19 | - $this->plural_item = esc_html__('Question Options', 'event_espresso'); |
|
16 | + protected function __construct($timezone = null) |
|
17 | + { |
|
18 | + $this->singular_item = esc_html__('Question Option', 'event_espresso'); |
|
19 | + $this->plural_item = esc_html__('Question Options', 'event_espresso'); |
|
20 | 20 | |
21 | - $this->_tables = [ |
|
22 | - 'Question_Option' => new EE_Primary_Table('esp_question_option', 'QSO_ID'), |
|
23 | - ]; |
|
24 | - $this->_fields = [ |
|
25 | - 'Question_Option' => [ |
|
26 | - 'QSO_ID' => new EE_Primary_Key_Int_Field( |
|
27 | - 'QSO_ID', |
|
28 | - esc_html__('Question Option ID', 'event_espresso') |
|
29 | - ), |
|
30 | - 'QST_ID' => new EE_Foreign_Key_Int_Field( |
|
31 | - 'QST_ID', |
|
32 | - esc_html__('Question ID', 'event_espresso'), |
|
33 | - false, |
|
34 | - 0, |
|
35 | - 'Question' |
|
36 | - ), |
|
37 | - 'QSO_deleted' => new EE_Trashed_Flag_Field( |
|
38 | - 'QSO_deleted', |
|
39 | - esc_html__('Flag indicating Option was trashed', 'event_espresso'), |
|
40 | - false, |
|
41 | - false |
|
42 | - ), |
|
43 | - 'QSO_desc' => new EE_Post_Content_Field( |
|
44 | - 'QSO_desc', |
|
45 | - esc_html__('Question Option Description', 'event_espresso'), |
|
46 | - false, |
|
47 | - '' |
|
48 | - ), |
|
49 | - 'QSO_order' => new EE_Integer_Field( |
|
50 | - 'QSO_order', |
|
51 | - esc_html__('Question Option Order', 'event_espresso'), |
|
52 | - false, |
|
53 | - 0 |
|
54 | - ), |
|
55 | - 'QSO_system' => new EE_Plain_Text_Field( |
|
56 | - 'QSO_system', |
|
57 | - esc_html__('Internal string ID for question option', 'event_espresso'), |
|
58 | - true, |
|
59 | - null |
|
60 | - ), |
|
61 | - 'QSO_value' => new EE_Plain_Text_Field( |
|
62 | - 'QSO_value', |
|
63 | - esc_html__("Question Option Value", "event_espresso"), |
|
64 | - false, |
|
65 | - '' |
|
66 | - ), |
|
67 | - ], |
|
68 | - ]; |
|
69 | - $this->_model_relations = [ |
|
70 | - 'Question' => new EE_Belongs_To_Relation(), |
|
71 | - ]; |
|
21 | + $this->_tables = [ |
|
22 | + 'Question_Option' => new EE_Primary_Table('esp_question_option', 'QSO_ID'), |
|
23 | + ]; |
|
24 | + $this->_fields = [ |
|
25 | + 'Question_Option' => [ |
|
26 | + 'QSO_ID' => new EE_Primary_Key_Int_Field( |
|
27 | + 'QSO_ID', |
|
28 | + esc_html__('Question Option ID', 'event_espresso') |
|
29 | + ), |
|
30 | + 'QST_ID' => new EE_Foreign_Key_Int_Field( |
|
31 | + 'QST_ID', |
|
32 | + esc_html__('Question ID', 'event_espresso'), |
|
33 | + false, |
|
34 | + 0, |
|
35 | + 'Question' |
|
36 | + ), |
|
37 | + 'QSO_deleted' => new EE_Trashed_Flag_Field( |
|
38 | + 'QSO_deleted', |
|
39 | + esc_html__('Flag indicating Option was trashed', 'event_espresso'), |
|
40 | + false, |
|
41 | + false |
|
42 | + ), |
|
43 | + 'QSO_desc' => new EE_Post_Content_Field( |
|
44 | + 'QSO_desc', |
|
45 | + esc_html__('Question Option Description', 'event_espresso'), |
|
46 | + false, |
|
47 | + '' |
|
48 | + ), |
|
49 | + 'QSO_order' => new EE_Integer_Field( |
|
50 | + 'QSO_order', |
|
51 | + esc_html__('Question Option Order', 'event_espresso'), |
|
52 | + false, |
|
53 | + 0 |
|
54 | + ), |
|
55 | + 'QSO_system' => new EE_Plain_Text_Field( |
|
56 | + 'QSO_system', |
|
57 | + esc_html__('Internal string ID for question option', 'event_espresso'), |
|
58 | + true, |
|
59 | + null |
|
60 | + ), |
|
61 | + 'QSO_value' => new EE_Plain_Text_Field( |
|
62 | + 'QSO_value', |
|
63 | + esc_html__("Question Option Value", "event_espresso"), |
|
64 | + false, |
|
65 | + '' |
|
66 | + ), |
|
67 | + ], |
|
68 | + ]; |
|
69 | + $this->_model_relations = [ |
|
70 | + 'Question' => new EE_Belongs_To_Relation(), |
|
71 | + ]; |
|
72 | 72 | |
73 | - $this->_caps_slug = 'questions'; |
|
74 | - $this->_model_chain_to_wp_user = 'Question'; |
|
73 | + $this->_caps_slug = 'questions'; |
|
74 | + $this->_model_chain_to_wp_user = 'Question'; |
|
75 | 75 | |
76 | - // this model is generally available for reading |
|
77 | - $this->_cap_restriction_generators[ EEM_Base::caps_read ] = |
|
78 | - new EE_Restriction_Generator_Public(); |
|
79 | - $this->_cap_restriction_generators[ EEM_Base::caps_read_admin ] = |
|
80 | - new EE_Restriction_Generator_Reg_Form('QSO_system'); |
|
81 | - $this->_cap_restriction_generators[ EEM_Base::caps_edit ] = |
|
82 | - new EE_Restriction_Generator_Reg_Form('QSO_system'); |
|
83 | - $this->_cap_restriction_generators[ EEM_Base::caps_delete ] = |
|
84 | - new EE_Restriction_Generator_Reg_Form('QSO_system'); |
|
76 | + // this model is generally available for reading |
|
77 | + $this->_cap_restriction_generators[ EEM_Base::caps_read ] = |
|
78 | + new EE_Restriction_Generator_Public(); |
|
79 | + $this->_cap_restriction_generators[ EEM_Base::caps_read_admin ] = |
|
80 | + new EE_Restriction_Generator_Reg_Form('QSO_system'); |
|
81 | + $this->_cap_restriction_generators[ EEM_Base::caps_edit ] = |
|
82 | + new EE_Restriction_Generator_Reg_Form('QSO_system'); |
|
83 | + $this->_cap_restriction_generators[ EEM_Base::caps_delete ] = |
|
84 | + new EE_Restriction_Generator_Reg_Form('QSO_system'); |
|
85 | 85 | |
86 | - parent::__construct($timezone); |
|
87 | - } |
|
86 | + parent::__construct($timezone); |
|
87 | + } |
|
88 | 88 | } |
@@ -61,13 +61,13 @@ |
||
61 | 61 | $this->_model_chain_to_wp_user = 'Question_Group'; |
62 | 62 | |
63 | 63 | // this model is generally available for reading |
64 | - $this->_cap_restriction_generators[ EEM_Base::caps_read ] = |
|
64 | + $this->_cap_restriction_generators[EEM_Base::caps_read] = |
|
65 | 65 | new EE_Restriction_Generator_Public(); |
66 | - $this->_cap_restriction_generators[ EEM_Base::caps_read_admin ] = |
|
66 | + $this->_cap_restriction_generators[EEM_Base::caps_read_admin] = |
|
67 | 67 | new EE_Restriction_Generator_Reg_Form('Question_Group.QSG_system'); |
68 | - $this->_cap_restriction_generators[ EEM_Base::caps_edit ] = |
|
68 | + $this->_cap_restriction_generators[EEM_Base::caps_edit] = |
|
69 | 69 | new EE_Restriction_Generator_Reg_Form('Question_Group.QSG_system'); |
70 | - $this->_cap_restriction_generators[ EEM_Base::caps_delete ] = |
|
70 | + $this->_cap_restriction_generators[EEM_Base::caps_delete] = |
|
71 | 71 | new EE_Restriction_Generator_Reg_Form('Question_Group.QSG_system'); |
72 | 72 | |
73 | 73 | // use the caps for question groups |
@@ -13,64 +13,64 @@ |
||
13 | 13 | */ |
14 | 14 | class EEM_Question_Group_Question extends EEM_Base |
15 | 15 | { |
16 | - // private instance of the Attendee object |
|
17 | - protected static $_instance = null; |
|
16 | + // private instance of the Attendee object |
|
17 | + protected static $_instance = null; |
|
18 | 18 | |
19 | 19 | |
20 | - protected function __construct($timezone = null) |
|
21 | - { |
|
22 | - $this->singular_item = esc_html__('Question Group to Question Link', 'event_espresso'); |
|
23 | - $this->plural_item = esc_html__('Question Group to Question Links', 'event_espresso'); |
|
24 | - $this->_tables = [ |
|
25 | - 'Question_Group_Question' => new EE_Primary_Table('esp_question_group_question', 'QGQ_ID'), |
|
26 | - ]; |
|
27 | - $this->_fields = [ |
|
28 | - 'Question_Group_Question' => [ |
|
29 | - 'QGQ_ID' => new EE_Primary_Key_Int_Field( |
|
30 | - 'QGQ_ID', |
|
31 | - esc_html__('Question Group to Question Link ID', 'event_espresso') |
|
32 | - ), |
|
33 | - 'QSG_ID' => new EE_Foreign_Key_Int_Field( |
|
34 | - 'QSG_ID', |
|
35 | - esc_html__('Question Group ID', 'event_espresso'), |
|
36 | - false, |
|
37 | - 0, |
|
38 | - 'Question_Group' |
|
39 | - ), |
|
40 | - 'QST_ID' => new EE_Foreign_Key_Int_Field( |
|
41 | - 'QST_ID', |
|
42 | - esc_html__('Question Id', 'event_espresso'), |
|
43 | - false, |
|
44 | - 0, |
|
45 | - 'Question' |
|
46 | - ), |
|
47 | - 'QGQ_order' => new EE_Integer_Field( |
|
48 | - 'QGQ_order', |
|
49 | - esc_html__('Question Group Question Order', 'event_espresso'), |
|
50 | - false, |
|
51 | - 0 |
|
52 | - ), |
|
53 | - ], |
|
54 | - ]; |
|
55 | - $this->_model_relations = [ |
|
56 | - 'Question_Group' => new EE_Belongs_To_Relation(), |
|
57 | - 'Question' => new EE_Belongs_To_Relation(), |
|
58 | - ]; |
|
20 | + protected function __construct($timezone = null) |
|
21 | + { |
|
22 | + $this->singular_item = esc_html__('Question Group to Question Link', 'event_espresso'); |
|
23 | + $this->plural_item = esc_html__('Question Group to Question Links', 'event_espresso'); |
|
24 | + $this->_tables = [ |
|
25 | + 'Question_Group_Question' => new EE_Primary_Table('esp_question_group_question', 'QGQ_ID'), |
|
26 | + ]; |
|
27 | + $this->_fields = [ |
|
28 | + 'Question_Group_Question' => [ |
|
29 | + 'QGQ_ID' => new EE_Primary_Key_Int_Field( |
|
30 | + 'QGQ_ID', |
|
31 | + esc_html__('Question Group to Question Link ID', 'event_espresso') |
|
32 | + ), |
|
33 | + 'QSG_ID' => new EE_Foreign_Key_Int_Field( |
|
34 | + 'QSG_ID', |
|
35 | + esc_html__('Question Group ID', 'event_espresso'), |
|
36 | + false, |
|
37 | + 0, |
|
38 | + 'Question_Group' |
|
39 | + ), |
|
40 | + 'QST_ID' => new EE_Foreign_Key_Int_Field( |
|
41 | + 'QST_ID', |
|
42 | + esc_html__('Question Id', 'event_espresso'), |
|
43 | + false, |
|
44 | + 0, |
|
45 | + 'Question' |
|
46 | + ), |
|
47 | + 'QGQ_order' => new EE_Integer_Field( |
|
48 | + 'QGQ_order', |
|
49 | + esc_html__('Question Group Question Order', 'event_espresso'), |
|
50 | + false, |
|
51 | + 0 |
|
52 | + ), |
|
53 | + ], |
|
54 | + ]; |
|
55 | + $this->_model_relations = [ |
|
56 | + 'Question_Group' => new EE_Belongs_To_Relation(), |
|
57 | + 'Question' => new EE_Belongs_To_Relation(), |
|
58 | + ]; |
|
59 | 59 | |
60 | - $this->_model_chain_to_wp_user = 'Question_Group'; |
|
60 | + $this->_model_chain_to_wp_user = 'Question_Group'; |
|
61 | 61 | |
62 | - // this model is generally available for reading |
|
63 | - $this->_cap_restriction_generators[ EEM_Base::caps_read ] = |
|
64 | - new EE_Restriction_Generator_Public(); |
|
65 | - $this->_cap_restriction_generators[ EEM_Base::caps_read_admin ] = |
|
66 | - new EE_Restriction_Generator_Reg_Form('Question_Group.QSG_system'); |
|
67 | - $this->_cap_restriction_generators[ EEM_Base::caps_edit ] = |
|
68 | - new EE_Restriction_Generator_Reg_Form('Question_Group.QSG_system'); |
|
69 | - $this->_cap_restriction_generators[ EEM_Base::caps_delete ] = |
|
70 | - new EE_Restriction_Generator_Reg_Form('Question_Group.QSG_system'); |
|
62 | + // this model is generally available for reading |
|
63 | + $this->_cap_restriction_generators[ EEM_Base::caps_read ] = |
|
64 | + new EE_Restriction_Generator_Public(); |
|
65 | + $this->_cap_restriction_generators[ EEM_Base::caps_read_admin ] = |
|
66 | + new EE_Restriction_Generator_Reg_Form('Question_Group.QSG_system'); |
|
67 | + $this->_cap_restriction_generators[ EEM_Base::caps_edit ] = |
|
68 | + new EE_Restriction_Generator_Reg_Form('Question_Group.QSG_system'); |
|
69 | + $this->_cap_restriction_generators[ EEM_Base::caps_delete ] = |
|
70 | + new EE_Restriction_Generator_Reg_Form('Question_Group.QSG_system'); |
|
71 | 71 | |
72 | - // use the caps for question groups |
|
73 | - $this->_caps_slug = 'question_groups'; |
|
74 | - parent::__construct($timezone); |
|
75 | - } |
|
72 | + // use the caps for question groups |
|
73 | + $this->_caps_slug = 'question_groups'; |
|
74 | + parent::__construct($timezone); |
|
75 | + } |
|
76 | 76 | } |
@@ -132,7 +132,7 @@ discard block |
||
132 | 132 | EEM_Question::QST_type_year => esc_html__('Year', 'event_espresso'), |
133 | 133 | ] |
134 | 134 | ); |
135 | - $this->_question_descriptions = apply_filters( |
|
135 | + $this->_question_descriptions = apply_filters( |
|
136 | 136 | 'FHEE__EEM_Question__construct__question_descriptions', |
137 | 137 | [ |
138 | 138 | EEM_Question::QST_type_checkbox => esc_html__( |
@@ -205,7 +205,7 @@ discard block |
||
205 | 205 | ), |
206 | 206 | ] |
207 | 207 | ); |
208 | - $this->_question_type_categories = (array) apply_filters( |
|
208 | + $this->_question_type_categories = (array) apply_filters( |
|
209 | 209 | 'FHEE__EEM_Question__construct__question_type_categories', |
210 | 210 | [ |
211 | 211 | 'text' => [ |
@@ -326,13 +326,13 @@ discard block |
||
326 | 326 | 'WP_User' => new EE_Belongs_To_Relation(), |
327 | 327 | ]; |
328 | 328 | // this model is generally available for reading |
329 | - $this->_cap_restriction_generators[ EEM_Base::caps_read ] = |
|
329 | + $this->_cap_restriction_generators[EEM_Base::caps_read] = |
|
330 | 330 | new EE_Restriction_Generator_Public(); |
331 | - $this->_cap_restriction_generators[ EEM_Base::caps_read_admin ] = |
|
331 | + $this->_cap_restriction_generators[EEM_Base::caps_read_admin] = |
|
332 | 332 | new EE_Restriction_Generator_Reg_Form('QST_system'); |
333 | - $this->_cap_restriction_generators[ EEM_Base::caps_edit ] = |
|
333 | + $this->_cap_restriction_generators[EEM_Base::caps_edit] = |
|
334 | 334 | new EE_Restriction_Generator_Reg_Form('QST_system'); |
335 | - $this->_cap_restriction_generators[ EEM_Base::caps_delete ] = |
|
335 | + $this->_cap_restriction_generators[EEM_Base::caps_delete] = |
|
336 | 336 | new EE_Restriction_Generator_Reg_Form('QST_system'); |
337 | 337 | |
338 | 338 | parent::__construct($timezone); |
@@ -380,10 +380,10 @@ discard block |
||
380 | 380 | */ |
381 | 381 | public function question_type_is_in_category(string $question_type, string $category): bool |
382 | 382 | { |
383 | - if (! isset($this->_question_type_categories[ $category ])) { |
|
383 | + if ( ! isset($this->_question_type_categories[$category])) { |
|
384 | 384 | return false; |
385 | 385 | } |
386 | - return in_array($question_type, $this->_question_type_categories[ $category ]); |
|
386 | + return in_array($question_type, $this->_question_type_categories[$category]); |
|
387 | 387 | } |
388 | 388 | |
389 | 389 | |
@@ -395,8 +395,8 @@ discard block |
||
395 | 395 | */ |
396 | 396 | public function question_types_in_category(string $category): array |
397 | 397 | { |
398 | - if (isset($this->_question_type_categories[ $category ])) { |
|
399 | - return $this->_question_type_categories[ $category ]; |
|
398 | + if (isset($this->_question_type_categories[$category])) { |
|
399 | + return $this->_question_type_categories[$category]; |
|
400 | 400 | } |
401 | 401 | return []; |
402 | 402 | } |
@@ -560,8 +560,8 @@ discard block |
||
560 | 560 | public function absolute_max_for_system_question(string $system_question_value) |
561 | 561 | { |
562 | 562 | $maxes = $this->system_question_maxes(); |
563 | - return isset($maxes[ $system_question_value ]) ? |
|
564 | - $maxes[ $system_question_value ] |
|
563 | + return isset($maxes[$system_question_value]) ? |
|
564 | + $maxes[$system_question_value] |
|
565 | 565 | : EE_INF; |
566 | 566 | } |
567 | 567 |
@@ -9,578 +9,578 @@ |
||
9 | 9 | */ |
10 | 10 | class EEM_Question extends EEM_Soft_Delete_Base |
11 | 11 | { |
12 | - // constant used to indicate that the question type is CHECKBOX |
|
13 | - const QST_type_checkbox = 'CHECKBOX'; |
|
12 | + // constant used to indicate that the question type is CHECKBOX |
|
13 | + const QST_type_checkbox = 'CHECKBOX'; |
|
14 | 14 | |
15 | - // constant used to indicate that the question type is COUNTRY |
|
16 | - const QST_type_country = 'COUNTRY'; |
|
17 | - |
|
18 | - // constant used to indicate that the question type is DATE |
|
19 | - const QST_type_date = 'DATE'; |
|
20 | - |
|
21 | - // constant used to indicate that the question type is a decimal (float) |
|
22 | - const QST_type_decimal = 'DECIMAL'; |
|
23 | - |
|
24 | - // constant used to indicate that the question type is DROPDOWN |
|
25 | - const QST_type_dropdown = 'DROPDOWN'; |
|
26 | - |
|
27 | - // constant used to indicate that the question type is an email input |
|
28 | - const QST_type_email = 'EMAIL'; |
|
29 | - |
|
30 | - // constant used to indicate that the question type is an email input |
|
31 | - const QST_type_email_confirm = 'EMAIL_CONFIRM'; |
|
32 | - |
|
33 | - // constant used to indicate that the question type is a TEXTAREA that allows simple html |
|
34 | - const QST_type_html_textarea = 'HTML_TEXTAREA'; |
|
35 | - |
|
36 | - // constant used to indicate that the question type is an integer (whole number) |
|
37 | - const QST_type_int = 'INTEGER'; |
|
38 | - |
|
39 | - // constant used to indicate that the question type is a multi-select |
|
40 | - const QST_type_multi_select = 'MULTI_SELECT'; |
|
41 | - |
|
42 | - // constant used to indicate that the question type is RADIO_BTN |
|
43 | - const QST_type_radio = 'RADIO_BTN'; |
|
44 | - |
|
45 | - // constant used to indicate that the question type is STATE |
|
46 | - const QST_type_state = 'STATE'; |
|
47 | - |
|
48 | - // constant used to indicate that the question type is TEXT |
|
49 | - const QST_type_text = 'TEXT'; |
|
50 | - |
|
51 | - // constant used to indicate that the question type is TEXTAREA |
|
52 | - const QST_type_textarea = 'TEXTAREA'; |
|
53 | - |
|
54 | - // constant used to indicate that the question type is a valid URL |
|
55 | - const QST_type_url = 'URL'; |
|
56 | - |
|
57 | - // constant used to indicate that the question type is a US-formatted phone number |
|
58 | - const QST_type_us_phone = 'US_PHONE'; |
|
59 | - |
|
60 | - // constant used to indicate that the question type is a YEAR |
|
61 | - const QST_type_year = 'YEAR'; |
|
62 | - |
|
63 | - /** |
|
64 | - * lists all the question types which should be allowed. Ideally, this will be extensible. |
|
65 | - * |
|
66 | - * @var array $_allowed_question_types |
|
67 | - */ |
|
68 | - protected $_allowed_question_types = []; |
|
69 | - |
|
70 | - |
|
71 | - // private instance of the Attendee object |
|
72 | - protected static $_instance = null; |
|
73 | - |
|
74 | - /** |
|
75 | - * brief descriptions for all the question types |
|
76 | - * |
|
77 | - * @var EEM_Question $_instance |
|
78 | - */ |
|
79 | - protected $_question_descriptions; |
|
80 | - |
|
81 | - /** |
|
82 | - * Question types that are interchangeable, even after answers have been provided for them. |
|
83 | - * Top-level keys are category slugs, next level is an array of question types. If question types |
|
84 | - * aren't in this array, it is assumed they AREN'T interchangeable with any other question types. |
|
85 | - * |
|
86 | - * @var array $_question_type_categories { |
|
87 | - * @type string $text |
|
88 | - * @type string $single -answer-enum |
|
89 | - * @type string $multi -answer-enum |
|
90 | - * } |
|
91 | - */ |
|
92 | - protected $_question_type_categories = []; |
|
93 | - |
|
94 | - |
|
95 | - /** |
|
96 | - * Question types that should have an admin-defined max input length |
|
97 | - * |
|
98 | - * @var array |
|
99 | - */ |
|
100 | - protected $question_types_with_max_length; |
|
101 | - |
|
102 | - |
|
103 | - /** |
|
104 | - * EEM_Question constructor. |
|
105 | - * |
|
106 | - * @param null $timezone |
|
107 | - */ |
|
108 | - protected function __construct($timezone = null) |
|
109 | - { |
|
110 | - $this->singular_item = esc_html__('Question', 'event_espresso'); |
|
111 | - $this->plural_item = esc_html__('Questions', 'event_espresso'); |
|
112 | - $this->_allowed_question_types = apply_filters( |
|
113 | - 'FHEE__EEM_Question__construct__allowed_question_types', |
|
114 | - [ |
|
115 | - EEM_Question::QST_type_checkbox => esc_html__('Checkboxes', 'event_espresso'), |
|
116 | - EEM_Question::QST_type_country => esc_html__('Country Dropdown', 'event_espresso'), |
|
117 | - EEM_Question::QST_type_date => esc_html__('Date Picker', 'event_espresso'), |
|
118 | - EEM_Question::QST_type_decimal => esc_html__('Number', 'event_espresso'), |
|
119 | - EEM_Question::QST_type_dropdown => esc_html__('Dropdown', 'event_espresso'), |
|
120 | - EEM_Question::QST_type_email => esc_html__('Email', 'event_espresso'), |
|
121 | - EEM_Question::QST_type_email_confirm => esc_html__('Confirm Email', 'event_espresso'), |
|
122 | - EEM_Question::QST_type_html_textarea => esc_html__('HTML Textarea', 'event_espresso'), |
|
123 | - EEM_Question::QST_type_int => esc_html__('Whole Number', 'event_espresso'), |
|
124 | - EEM_Question::QST_type_multi_select => esc_html__('Multi Select', 'event_espresso'), |
|
125 | - EEM_Question::QST_type_radio => esc_html__('Radio Buttons', 'event_espresso'), |
|
126 | - EEM_Question::QST_type_state => esc_html__('State/Province Dropdown', 'event_espresso'), |
|
127 | - EEM_Question::QST_type_text => esc_html__('Text', 'event_espresso'), |
|
128 | - EEM_Question::QST_type_textarea => esc_html__('Textarea', 'event_espresso'), |
|
129 | - EEM_Question::QST_type_url => esc_html__('URL', 'event_espresso'), |
|
130 | - EEM_Question::QST_type_us_phone => esc_html__('USA - Format Phone', 'event_espresso'), |
|
131 | - EEM_Question::QST_type_year => esc_html__('Year', 'event_espresso'), |
|
132 | - ] |
|
133 | - ); |
|
134 | - $this->_question_descriptions = apply_filters( |
|
135 | - 'FHEE__EEM_Question__construct__question_descriptions', |
|
136 | - [ |
|
137 | - EEM_Question::QST_type_checkbox => esc_html__( |
|
138 | - 'Allows multiple preset options to be selected', |
|
139 | - 'event_espresso' |
|
140 | - ), |
|
141 | - EEM_Question::QST_type_country => esc_html__( |
|
142 | - 'A dropdown that lists countries', |
|
143 | - 'event_espresso' |
|
144 | - ), |
|
145 | - EEM_Question::QST_type_date => esc_html__( |
|
146 | - 'A popup calendar that allows date selections', |
|
147 | - 'event_espresso' |
|
148 | - ), |
|
149 | - EEM_Question::QST_type_decimal => esc_html__( |
|
150 | - 'A text field that allows number values with decimals', |
|
151 | - 'event_espresso' |
|
152 | - ), |
|
153 | - EEM_Question::QST_type_dropdown => esc_html__( |
|
154 | - 'A dropdown that allows a single selection', |
|
155 | - 'event_espresso' |
|
156 | - ), |
|
157 | - EEM_Question::QST_type_email => esc_html__( |
|
158 | - 'A text field that must contain a valid Email address', |
|
159 | - 'event_espresso' |
|
160 | - ), |
|
161 | - EEM_Question::QST_type_email_confirm => esc_html__( |
|
162 | - 'A text field that must contain a valid Email address and be equal to Email field', |
|
163 | - 'event_espresso' |
|
164 | - ), |
|
165 | - EEM_Question::QST_type_html_textarea => esc_html__( |
|
166 | - 'A multi line text input field that allows HTML', |
|
167 | - 'event_espresso' |
|
168 | - ), |
|
169 | - EEM_Question::QST_type_int => esc_html__( |
|
170 | - 'A text field that only allows whole numbers (no decimals)', |
|
171 | - 'event_espresso' |
|
172 | - ), |
|
173 | - EEM_Question::QST_type_multi_select => esc_html__( |
|
174 | - 'A dropdown that allows multiple selections', |
|
175 | - 'event_espresso' |
|
176 | - ), |
|
177 | - EEM_Question::QST_type_radio => esc_html__( |
|
178 | - 'Allows a single preset option to be selected', |
|
179 | - 'event_espresso' |
|
180 | - ), |
|
181 | - EEM_Question::QST_type_state => esc_html__( |
|
182 | - 'A dropdown that lists states/provinces', |
|
183 | - 'event_espresso' |
|
184 | - ), |
|
185 | - EEM_Question::QST_type_text => esc_html__( |
|
186 | - 'A single line text input field', |
|
187 | - 'event_espresso' |
|
188 | - ), |
|
189 | - EEM_Question::QST_type_textarea => esc_html__( |
|
190 | - 'A multi line text input field', |
|
191 | - 'event_espresso' |
|
192 | - ), |
|
193 | - EEM_Question::QST_type_url => esc_html__( |
|
194 | - 'A text field that must contain a valid URL', |
|
195 | - 'event_espresso' |
|
196 | - ), |
|
197 | - EEM_Question::QST_type_us_phone => esc_html__( |
|
198 | - 'A text field that must contain a valid US phone number', |
|
199 | - 'event_espresso' |
|
200 | - ), |
|
201 | - EEM_Question::QST_type_year => esc_html__( |
|
202 | - 'A dropdown that lists the last 100 years', |
|
203 | - 'event_espresso' |
|
204 | - ), |
|
205 | - ] |
|
206 | - ); |
|
207 | - $this->_question_type_categories = (array) apply_filters( |
|
208 | - 'FHEE__EEM_Question__construct__question_type_categories', |
|
209 | - [ |
|
210 | - 'text' => [ |
|
211 | - EEM_Question::QST_type_date, |
|
212 | - EEM_Question::QST_type_decimal, |
|
213 | - EEM_Question::QST_type_email, |
|
214 | - EEM_Question::QST_type_email_confirm, |
|
215 | - EEM_Question::QST_type_html_textarea, |
|
216 | - EEM_Question::QST_type_int, |
|
217 | - EEM_Question::QST_type_text, |
|
218 | - EEM_Question::QST_type_textarea, |
|
219 | - EEM_Question::QST_type_url, |
|
220 | - EEM_Question::QST_type_us_phone, |
|
221 | - EEM_Question::QST_type_year, |
|
222 | - ], |
|
223 | - 'single-answer-enum' => [ |
|
224 | - EEM_Question::QST_type_dropdown, |
|
225 | - EEM_Question::QST_type_radio, |
|
226 | - ], |
|
227 | - 'multi-answer-enum' => [ |
|
228 | - EEM_Question::QST_type_multi_select, |
|
229 | - EEM_Question::QST_type_checkbox, |
|
230 | - ], |
|
231 | - ] |
|
232 | - ); |
|
233 | - $this->question_types_with_max_length = apply_filters( |
|
234 | - 'FHEE__EEM_Question___construct__question_types_with_max_length', |
|
235 | - [ |
|
236 | - EEM_Question::QST_type_html_textarea, |
|
237 | - EEM_Question::QST_type_text, |
|
238 | - EEM_Question::QST_type_textarea, |
|
239 | - ] |
|
240 | - ); |
|
241 | - |
|
242 | - $this->_tables = [ |
|
243 | - 'Question' => new EE_Primary_Table('esp_question', 'QST_ID'), |
|
244 | - ]; |
|
245 | - $this->_fields = [ |
|
246 | - 'Question' => [ |
|
247 | - 'QST_ID' => new EE_Primary_Key_Int_Field( |
|
248 | - 'QST_ID', |
|
249 | - esc_html__('Question ID', 'event_espresso') |
|
250 | - ), |
|
251 | - 'QST_admin_label' => new EE_Plain_Text_Field( |
|
252 | - 'QST_admin_label', |
|
253 | - esc_html__('Question Label (admin-only)', 'event_espresso'), |
|
254 | - true, |
|
255 | - '' |
|
256 | - ), |
|
257 | - 'QST_admin_only' => new EE_Boolean_Field( |
|
258 | - 'QST_admin_only', |
|
259 | - esc_html__('Admin-Only Question?', 'event_espresso'), |
|
260 | - false, |
|
261 | - false |
|
262 | - ), |
|
263 | - 'QST_deleted' => new EE_Trashed_Flag_Field( |
|
264 | - 'QST_deleted', |
|
265 | - esc_html__('Flag Indicating question was deleted', 'event_espresso'), |
|
266 | - false, |
|
267 | - false |
|
268 | - ), |
|
269 | - 'QST_display_text' => new EE_Post_Content_Field( |
|
270 | - 'QST_display_text', |
|
271 | - esc_html__('Question Text', 'event_espresso'), |
|
272 | - true, |
|
273 | - '' |
|
274 | - ), |
|
275 | - 'QST_max' => new EE_Infinite_Integer_Field( |
|
276 | - 'QST_max', |
|
277 | - esc_html__('Max Size', 'event_espresso'), |
|
278 | - false, |
|
279 | - EE_INF |
|
280 | - ), |
|
281 | - 'QST_order' => new EE_Integer_Field( |
|
282 | - 'QST_order', |
|
283 | - esc_html__('Question Order', 'event_espresso'), |
|
284 | - false, |
|
285 | - 0 |
|
286 | - ), |
|
287 | - 'QST_required' => new EE_Boolean_Field( |
|
288 | - 'QST_required', |
|
289 | - esc_html__('Required Question?', 'event_espresso'), |
|
290 | - false, |
|
291 | - false |
|
292 | - ), |
|
293 | - 'QST_required_text' => new EE_Simple_HTML_Field( |
|
294 | - 'QST_required_text', |
|
295 | - esc_html__('Text to Display if Not Provided', 'event_espresso'), |
|
296 | - true, |
|
297 | - '' |
|
298 | - ), |
|
299 | - 'QST_system' => new EE_Plain_Text_Field( |
|
300 | - 'QST_system', |
|
301 | - esc_html__('Internal string ID for question', 'event_espresso'), |
|
302 | - false, |
|
303 | - '' |
|
304 | - ), |
|
305 | - 'QST_type' => new EE_Enum_Text_Field( |
|
306 | - 'QST_type', |
|
307 | - esc_html__('Question Type', 'event_espresso'), |
|
308 | - false, |
|
309 | - 'TEXT', |
|
310 | - $this->_allowed_question_types |
|
311 | - ), |
|
312 | - 'QST_wp_user' => new EE_WP_User_Field( |
|
313 | - 'QST_wp_user', |
|
314 | - esc_html__('Question Creator ID', 'event_espresso'), |
|
315 | - false |
|
316 | - ), |
|
317 | - ], |
|
318 | - ]; |
|
319 | - $this->_model_relations = [ |
|
320 | - 'Answer' => new EE_Has_Many_Relation(), |
|
321 | - 'Question_Group' => new EE_HABTM_Relation('Question_Group_Question'), |
|
322 | - // for QST_order column |
|
323 | - 'Question_Group_Question' => new EE_Has_Many_Relation(), |
|
324 | - 'Question_Option' => new EE_Has_Many_Relation(), |
|
325 | - 'WP_User' => new EE_Belongs_To_Relation(), |
|
326 | - ]; |
|
327 | - // this model is generally available for reading |
|
328 | - $this->_cap_restriction_generators[ EEM_Base::caps_read ] = |
|
329 | - new EE_Restriction_Generator_Public(); |
|
330 | - $this->_cap_restriction_generators[ EEM_Base::caps_read_admin ] = |
|
331 | - new EE_Restriction_Generator_Reg_Form('QST_system'); |
|
332 | - $this->_cap_restriction_generators[ EEM_Base::caps_edit ] = |
|
333 | - new EE_Restriction_Generator_Reg_Form('QST_system'); |
|
334 | - $this->_cap_restriction_generators[ EEM_Base::caps_delete ] = |
|
335 | - new EE_Restriction_Generator_Reg_Form('QST_system'); |
|
336 | - |
|
337 | - parent::__construct($timezone); |
|
338 | - } |
|
339 | - |
|
340 | - |
|
341 | - /** |
|
342 | - * Returns the list of allowed question types, which are normally: |
|
343 | - * 'TEXT','TEXTAREA','RADIO_BTN','DROPDOWN','CHECKBOX','DATE' but they can be extended |
|
344 | - * |
|
345 | - * @return string[] |
|
346 | - */ |
|
347 | - public function allowed_question_types(): array |
|
348 | - { |
|
349 | - return $this->_allowed_question_types; |
|
350 | - } |
|
351 | - |
|
352 | - |
|
353 | - /** |
|
354 | - * Gets all the question types in the same category |
|
355 | - * |
|
356 | - * @param string $question_type one of EEM_Question::allowed_question_types( |
|
357 | - * @return string[] like EEM_Question::allowed_question_types() |
|
358 | - */ |
|
359 | - public function question_types_in_same_category(string $question_type): array |
|
360 | - { |
|
361 | - $question_types = [$question_type]; |
|
362 | - foreach ($this->_question_type_categories as $category => $question_types_in_category) { |
|
363 | - if (in_array($question_type, $question_types_in_category)) { |
|
364 | - $question_types = $question_types_in_category; |
|
365 | - break; |
|
366 | - } |
|
367 | - } |
|
368 | - |
|
369 | - return array_intersect_key($this->allowed_question_types(), array_flip($question_types)); |
|
370 | - } |
|
371 | - |
|
372 | - |
|
373 | - /** |
|
374 | - * Determines if the given question type is in the given question type category |
|
375 | - * |
|
376 | - * @param string $question_type one of EEM_Question::allowed_question_types() |
|
377 | - * @param string $category one of the top-level keys of EEM_Question::question_type_categories() |
|
378 | - * @return boolean |
|
379 | - */ |
|
380 | - public function question_type_is_in_category(string $question_type, string $category): bool |
|
381 | - { |
|
382 | - if (! isset($this->_question_type_categories[ $category ])) { |
|
383 | - return false; |
|
384 | - } |
|
385 | - return in_array($question_type, $this->_question_type_categories[ $category ]); |
|
386 | - } |
|
387 | - |
|
388 | - |
|
389 | - /** |
|
390 | - * Returns all the question types in the given category |
|
391 | - * |
|
392 | - * @param string $category |
|
393 | - * @return array|mixed |
|
394 | - */ |
|
395 | - public function question_types_in_category(string $category): array |
|
396 | - { |
|
397 | - if (isset($this->_question_type_categories[ $category ])) { |
|
398 | - return $this->_question_type_categories[ $category ]; |
|
399 | - } |
|
400 | - return []; |
|
401 | - } |
|
402 | - |
|
403 | - |
|
404 | - /** |
|
405 | - * Returns all the question types that should have question options |
|
406 | - * |
|
407 | - * @return array |
|
408 | - */ |
|
409 | - public function question_types_with_options(): array |
|
410 | - { |
|
411 | - return array_merge( |
|
412 | - $this->question_types_in_category('single-answer-enum'), |
|
413 | - $this->question_types_in_category('multi-answer-enum') |
|
414 | - ); |
|
415 | - } |
|
416 | - |
|
417 | - |
|
418 | - /** |
|
419 | - * Returns the question type categories 2d array |
|
420 | - * |
|
421 | - * @return array see EEM_Question::_question_type_categories |
|
422 | - */ |
|
423 | - public function question_type_categories(): array |
|
424 | - { |
|
425 | - return $this->_question_type_categories; |
|
426 | - } |
|
427 | - |
|
428 | - |
|
429 | - /** |
|
430 | - * Returns an array of all the QST_system values that can be allowed in the system question group |
|
431 | - * identified by $system_question_group_id |
|
432 | - * |
|
433 | - * @param string $system_question_group_id QSG_system |
|
434 | - * @return array of system question names (QST_system) |
|
435 | - */ |
|
436 | - public function allowed_system_questions_in_system_question_group(string $system_question_group_id): array |
|
437 | - { |
|
438 | - $question_system_ids = []; |
|
439 | - switch ($system_question_group_id) { |
|
440 | - case EEM_Question_Group::system_personal: |
|
441 | - $question_system_ids = [ |
|
442 | - EEM_Attendee::system_question_fname, |
|
443 | - EEM_Attendee::system_question_lname, |
|
444 | - EEM_Attendee::system_question_email, |
|
445 | - EEM_Attendee::system_question_email_confirm, |
|
446 | - EEM_Attendee::system_question_phone, |
|
447 | - ]; |
|
448 | - break; |
|
449 | - case EEM_Question_Group::system_address: |
|
450 | - $question_system_ids = [ |
|
451 | - EEM_Attendee::system_question_address, |
|
452 | - EEM_Attendee::system_question_address2, |
|
453 | - EEM_Attendee::system_question_city, |
|
454 | - EEM_Attendee::system_question_state, |
|
455 | - EEM_Attendee::system_question_country, |
|
456 | - EEM_Attendee::system_question_zip, |
|
457 | - EEM_Attendee::system_question_phone, |
|
458 | - ]; |
|
459 | - break; |
|
460 | - } |
|
461 | - return apply_filters( |
|
462 | - 'FHEE__EEM_Question__system_questions_allowed_in_system_question_group__return', |
|
463 | - $question_system_ids, |
|
464 | - $system_question_group_id |
|
465 | - ); |
|
466 | - } |
|
467 | - |
|
468 | - |
|
469 | - /** |
|
470 | - * Returns an array of all the QST_system values that are required in the system question group |
|
471 | - * identified by $system_question_group_id |
|
472 | - * |
|
473 | - * @param string $system_question_group_id QSG_system |
|
474 | - * @return array of system question names (QST_system) |
|
475 | - */ |
|
476 | - public function required_system_questions_in_system_question_group(string $system_question_group_id): array |
|
477 | - { |
|
478 | - $question_system_ids = null; |
|
479 | - switch ($system_question_group_id) { |
|
480 | - case EEM_Question_Group::system_personal: |
|
481 | - $question_system_ids = [ |
|
482 | - EEM_Attendee::system_question_fname, |
|
483 | - EEM_Attendee::system_question_email, |
|
484 | - ]; |
|
485 | - break; |
|
486 | - default: |
|
487 | - $question_system_ids = []; |
|
488 | - } |
|
489 | - return apply_filters( |
|
490 | - 'FHEE__EEM_Question__system_questions_required_in_system_question_group', |
|
491 | - $question_system_ids, |
|
492 | - $system_question_group_id |
|
493 | - ); |
|
494 | - } |
|
495 | - |
|
496 | - |
|
497 | - /** |
|
498 | - * Gets an array for converting between QST_system and QST_IDs for system questions. Eg, if you want to know |
|
499 | - * which system question QST_ID corresponds to the QST_system 'city', use |
|
500 | - * EEM_Question::instance()->get_Question_ID_from_system_string('city'); |
|
501 | - * |
|
502 | - * @param $QST_system |
|
503 | - * @return int of QST_ID for the question that corresponds to that QST_system |
|
504 | - * @throws EE_Error |
|
505 | - */ |
|
506 | - public function get_Question_ID_from_system_string($QST_system): int |
|
507 | - { |
|
508 | - return $this->get_var([['QST_system' => $QST_system]]); |
|
509 | - } |
|
510 | - |
|
511 | - |
|
512 | - /** |
|
513 | - * searches the db for the question with the latest question order and returns that value. |
|
514 | - * |
|
515 | - * @return int |
|
516 | - * @throws EE_Error |
|
517 | - */ |
|
518 | - public function get_latest_question_order(): int |
|
519 | - { |
|
520 | - $columns_to_select = [ |
|
521 | - 'max_order' => ["MAX(QST_order)", "%d"], |
|
522 | - ]; |
|
523 | - $max = $this->_get_all_wpdb_results([], ARRAY_A, $columns_to_select); |
|
524 | - return isset($max[0], $max[0]['max_order']) ? $max[0]['max_order'] : 0; |
|
525 | - } |
|
526 | - |
|
527 | - |
|
528 | - /** |
|
529 | - * Returns an array where keys are system question QST_system values, |
|
530 | - * and values are the highest question max the admin can set on the question |
|
531 | - * (aka the "max max"; eg, a site admin can change the zip question to have a max |
|
532 | - * of 5, but no larger than 12) |
|
533 | - * |
|
534 | - * @return array |
|
535 | - */ |
|
536 | - public function system_question_maxes(): array |
|
537 | - { |
|
538 | - return [ |
|
539 | - 'fname' => 45, |
|
540 | - 'lname' => 45, |
|
541 | - 'address' => 255, |
|
542 | - 'address2' => 255, |
|
543 | - 'city' => 45, |
|
544 | - 'zip' => 12, |
|
545 | - 'email' => 255, |
|
546 | - 'email_confirm' => 255, |
|
547 | - 'phone' => 45, |
|
548 | - ]; |
|
549 | - } |
|
550 | - |
|
551 | - |
|
552 | - /** |
|
553 | - * Given a QST_system value, gets the question's largest allowable max input. |
|
554 | - * |
|
555 | - * @param string $system_question_value |
|
556 | - * @return int|float |
|
557 | - * @see Registration_Form_Admin_Page::system_question_maxes() |
|
558 | - */ |
|
559 | - public function absolute_max_for_system_question(string $system_question_value) |
|
560 | - { |
|
561 | - $maxes = $this->system_question_maxes(); |
|
562 | - return isset($maxes[ $system_question_value ]) ? |
|
563 | - $maxes[ $system_question_value ] |
|
564 | - : EE_INF; |
|
565 | - } |
|
566 | - |
|
567 | - |
|
568 | - /** |
|
569 | - * @return array |
|
570 | - */ |
|
571 | - public function question_descriptions(): array |
|
572 | - { |
|
573 | - return $this->_question_descriptions; |
|
574 | - } |
|
575 | - |
|
576 | - |
|
577 | - /** |
|
578 | - * Returns all the question types that should have an admin-defined max input length |
|
579 | - * |
|
580 | - * @return array |
|
581 | - */ |
|
582 | - public function questionTypesWithMaxLength(): array |
|
583 | - { |
|
584 | - return (array) $this->question_types_with_max_length; |
|
585 | - } |
|
15 | + // constant used to indicate that the question type is COUNTRY |
|
16 | + const QST_type_country = 'COUNTRY'; |
|
17 | + |
|
18 | + // constant used to indicate that the question type is DATE |
|
19 | + const QST_type_date = 'DATE'; |
|
20 | + |
|
21 | + // constant used to indicate that the question type is a decimal (float) |
|
22 | + const QST_type_decimal = 'DECIMAL'; |
|
23 | + |
|
24 | + // constant used to indicate that the question type is DROPDOWN |
|
25 | + const QST_type_dropdown = 'DROPDOWN'; |
|
26 | + |
|
27 | + // constant used to indicate that the question type is an email input |
|
28 | + const QST_type_email = 'EMAIL'; |
|
29 | + |
|
30 | + // constant used to indicate that the question type is an email input |
|
31 | + const QST_type_email_confirm = 'EMAIL_CONFIRM'; |
|
32 | + |
|
33 | + // constant used to indicate that the question type is a TEXTAREA that allows simple html |
|
34 | + const QST_type_html_textarea = 'HTML_TEXTAREA'; |
|
35 | + |
|
36 | + // constant used to indicate that the question type is an integer (whole number) |
|
37 | + const QST_type_int = 'INTEGER'; |
|
38 | + |
|
39 | + // constant used to indicate that the question type is a multi-select |
|
40 | + const QST_type_multi_select = 'MULTI_SELECT'; |
|
41 | + |
|
42 | + // constant used to indicate that the question type is RADIO_BTN |
|
43 | + const QST_type_radio = 'RADIO_BTN'; |
|
44 | + |
|
45 | + // constant used to indicate that the question type is STATE |
|
46 | + const QST_type_state = 'STATE'; |
|
47 | + |
|
48 | + // constant used to indicate that the question type is TEXT |
|
49 | + const QST_type_text = 'TEXT'; |
|
50 | + |
|
51 | + // constant used to indicate that the question type is TEXTAREA |
|
52 | + const QST_type_textarea = 'TEXTAREA'; |
|
53 | + |
|
54 | + // constant used to indicate that the question type is a valid URL |
|
55 | + const QST_type_url = 'URL'; |
|
56 | + |
|
57 | + // constant used to indicate that the question type is a US-formatted phone number |
|
58 | + const QST_type_us_phone = 'US_PHONE'; |
|
59 | + |
|
60 | + // constant used to indicate that the question type is a YEAR |
|
61 | + const QST_type_year = 'YEAR'; |
|
62 | + |
|
63 | + /** |
|
64 | + * lists all the question types which should be allowed. Ideally, this will be extensible. |
|
65 | + * |
|
66 | + * @var array $_allowed_question_types |
|
67 | + */ |
|
68 | + protected $_allowed_question_types = []; |
|
69 | + |
|
70 | + |
|
71 | + // private instance of the Attendee object |
|
72 | + protected static $_instance = null; |
|
73 | + |
|
74 | + /** |
|
75 | + * brief descriptions for all the question types |
|
76 | + * |
|
77 | + * @var EEM_Question $_instance |
|
78 | + */ |
|
79 | + protected $_question_descriptions; |
|
80 | + |
|
81 | + /** |
|
82 | + * Question types that are interchangeable, even after answers have been provided for them. |
|
83 | + * Top-level keys are category slugs, next level is an array of question types. If question types |
|
84 | + * aren't in this array, it is assumed they AREN'T interchangeable with any other question types. |
|
85 | + * |
|
86 | + * @var array $_question_type_categories { |
|
87 | + * @type string $text |
|
88 | + * @type string $single -answer-enum |
|
89 | + * @type string $multi -answer-enum |
|
90 | + * } |
|
91 | + */ |
|
92 | + protected $_question_type_categories = []; |
|
93 | + |
|
94 | + |
|
95 | + /** |
|
96 | + * Question types that should have an admin-defined max input length |
|
97 | + * |
|
98 | + * @var array |
|
99 | + */ |
|
100 | + protected $question_types_with_max_length; |
|
101 | + |
|
102 | + |
|
103 | + /** |
|
104 | + * EEM_Question constructor. |
|
105 | + * |
|
106 | + * @param null $timezone |
|
107 | + */ |
|
108 | + protected function __construct($timezone = null) |
|
109 | + { |
|
110 | + $this->singular_item = esc_html__('Question', 'event_espresso'); |
|
111 | + $this->plural_item = esc_html__('Questions', 'event_espresso'); |
|
112 | + $this->_allowed_question_types = apply_filters( |
|
113 | + 'FHEE__EEM_Question__construct__allowed_question_types', |
|
114 | + [ |
|
115 | + EEM_Question::QST_type_checkbox => esc_html__('Checkboxes', 'event_espresso'), |
|
116 | + EEM_Question::QST_type_country => esc_html__('Country Dropdown', 'event_espresso'), |
|
117 | + EEM_Question::QST_type_date => esc_html__('Date Picker', 'event_espresso'), |
|
118 | + EEM_Question::QST_type_decimal => esc_html__('Number', 'event_espresso'), |
|
119 | + EEM_Question::QST_type_dropdown => esc_html__('Dropdown', 'event_espresso'), |
|
120 | + EEM_Question::QST_type_email => esc_html__('Email', 'event_espresso'), |
|
121 | + EEM_Question::QST_type_email_confirm => esc_html__('Confirm Email', 'event_espresso'), |
|
122 | + EEM_Question::QST_type_html_textarea => esc_html__('HTML Textarea', 'event_espresso'), |
|
123 | + EEM_Question::QST_type_int => esc_html__('Whole Number', 'event_espresso'), |
|
124 | + EEM_Question::QST_type_multi_select => esc_html__('Multi Select', 'event_espresso'), |
|
125 | + EEM_Question::QST_type_radio => esc_html__('Radio Buttons', 'event_espresso'), |
|
126 | + EEM_Question::QST_type_state => esc_html__('State/Province Dropdown', 'event_espresso'), |
|
127 | + EEM_Question::QST_type_text => esc_html__('Text', 'event_espresso'), |
|
128 | + EEM_Question::QST_type_textarea => esc_html__('Textarea', 'event_espresso'), |
|
129 | + EEM_Question::QST_type_url => esc_html__('URL', 'event_espresso'), |
|
130 | + EEM_Question::QST_type_us_phone => esc_html__('USA - Format Phone', 'event_espresso'), |
|
131 | + EEM_Question::QST_type_year => esc_html__('Year', 'event_espresso'), |
|
132 | + ] |
|
133 | + ); |
|
134 | + $this->_question_descriptions = apply_filters( |
|
135 | + 'FHEE__EEM_Question__construct__question_descriptions', |
|
136 | + [ |
|
137 | + EEM_Question::QST_type_checkbox => esc_html__( |
|
138 | + 'Allows multiple preset options to be selected', |
|
139 | + 'event_espresso' |
|
140 | + ), |
|
141 | + EEM_Question::QST_type_country => esc_html__( |
|
142 | + 'A dropdown that lists countries', |
|
143 | + 'event_espresso' |
|
144 | + ), |
|
145 | + EEM_Question::QST_type_date => esc_html__( |
|
146 | + 'A popup calendar that allows date selections', |
|
147 | + 'event_espresso' |
|
148 | + ), |
|
149 | + EEM_Question::QST_type_decimal => esc_html__( |
|
150 | + 'A text field that allows number values with decimals', |
|
151 | + 'event_espresso' |
|
152 | + ), |
|
153 | + EEM_Question::QST_type_dropdown => esc_html__( |
|
154 | + 'A dropdown that allows a single selection', |
|
155 | + 'event_espresso' |
|
156 | + ), |
|
157 | + EEM_Question::QST_type_email => esc_html__( |
|
158 | + 'A text field that must contain a valid Email address', |
|
159 | + 'event_espresso' |
|
160 | + ), |
|
161 | + EEM_Question::QST_type_email_confirm => esc_html__( |
|
162 | + 'A text field that must contain a valid Email address and be equal to Email field', |
|
163 | + 'event_espresso' |
|
164 | + ), |
|
165 | + EEM_Question::QST_type_html_textarea => esc_html__( |
|
166 | + 'A multi line text input field that allows HTML', |
|
167 | + 'event_espresso' |
|
168 | + ), |
|
169 | + EEM_Question::QST_type_int => esc_html__( |
|
170 | + 'A text field that only allows whole numbers (no decimals)', |
|
171 | + 'event_espresso' |
|
172 | + ), |
|
173 | + EEM_Question::QST_type_multi_select => esc_html__( |
|
174 | + 'A dropdown that allows multiple selections', |
|
175 | + 'event_espresso' |
|
176 | + ), |
|
177 | + EEM_Question::QST_type_radio => esc_html__( |
|
178 | + 'Allows a single preset option to be selected', |
|
179 | + 'event_espresso' |
|
180 | + ), |
|
181 | + EEM_Question::QST_type_state => esc_html__( |
|
182 | + 'A dropdown that lists states/provinces', |
|
183 | + 'event_espresso' |
|
184 | + ), |
|
185 | + EEM_Question::QST_type_text => esc_html__( |
|
186 | + 'A single line text input field', |
|
187 | + 'event_espresso' |
|
188 | + ), |
|
189 | + EEM_Question::QST_type_textarea => esc_html__( |
|
190 | + 'A multi line text input field', |
|
191 | + 'event_espresso' |
|
192 | + ), |
|
193 | + EEM_Question::QST_type_url => esc_html__( |
|
194 | + 'A text field that must contain a valid URL', |
|
195 | + 'event_espresso' |
|
196 | + ), |
|
197 | + EEM_Question::QST_type_us_phone => esc_html__( |
|
198 | + 'A text field that must contain a valid US phone number', |
|
199 | + 'event_espresso' |
|
200 | + ), |
|
201 | + EEM_Question::QST_type_year => esc_html__( |
|
202 | + 'A dropdown that lists the last 100 years', |
|
203 | + 'event_espresso' |
|
204 | + ), |
|
205 | + ] |
|
206 | + ); |
|
207 | + $this->_question_type_categories = (array) apply_filters( |
|
208 | + 'FHEE__EEM_Question__construct__question_type_categories', |
|
209 | + [ |
|
210 | + 'text' => [ |
|
211 | + EEM_Question::QST_type_date, |
|
212 | + EEM_Question::QST_type_decimal, |
|
213 | + EEM_Question::QST_type_email, |
|
214 | + EEM_Question::QST_type_email_confirm, |
|
215 | + EEM_Question::QST_type_html_textarea, |
|
216 | + EEM_Question::QST_type_int, |
|
217 | + EEM_Question::QST_type_text, |
|
218 | + EEM_Question::QST_type_textarea, |
|
219 | + EEM_Question::QST_type_url, |
|
220 | + EEM_Question::QST_type_us_phone, |
|
221 | + EEM_Question::QST_type_year, |
|
222 | + ], |
|
223 | + 'single-answer-enum' => [ |
|
224 | + EEM_Question::QST_type_dropdown, |
|
225 | + EEM_Question::QST_type_radio, |
|
226 | + ], |
|
227 | + 'multi-answer-enum' => [ |
|
228 | + EEM_Question::QST_type_multi_select, |
|
229 | + EEM_Question::QST_type_checkbox, |
|
230 | + ], |
|
231 | + ] |
|
232 | + ); |
|
233 | + $this->question_types_with_max_length = apply_filters( |
|
234 | + 'FHEE__EEM_Question___construct__question_types_with_max_length', |
|
235 | + [ |
|
236 | + EEM_Question::QST_type_html_textarea, |
|
237 | + EEM_Question::QST_type_text, |
|
238 | + EEM_Question::QST_type_textarea, |
|
239 | + ] |
|
240 | + ); |
|
241 | + |
|
242 | + $this->_tables = [ |
|
243 | + 'Question' => new EE_Primary_Table('esp_question', 'QST_ID'), |
|
244 | + ]; |
|
245 | + $this->_fields = [ |
|
246 | + 'Question' => [ |
|
247 | + 'QST_ID' => new EE_Primary_Key_Int_Field( |
|
248 | + 'QST_ID', |
|
249 | + esc_html__('Question ID', 'event_espresso') |
|
250 | + ), |
|
251 | + 'QST_admin_label' => new EE_Plain_Text_Field( |
|
252 | + 'QST_admin_label', |
|
253 | + esc_html__('Question Label (admin-only)', 'event_espresso'), |
|
254 | + true, |
|
255 | + '' |
|
256 | + ), |
|
257 | + 'QST_admin_only' => new EE_Boolean_Field( |
|
258 | + 'QST_admin_only', |
|
259 | + esc_html__('Admin-Only Question?', 'event_espresso'), |
|
260 | + false, |
|
261 | + false |
|
262 | + ), |
|
263 | + 'QST_deleted' => new EE_Trashed_Flag_Field( |
|
264 | + 'QST_deleted', |
|
265 | + esc_html__('Flag Indicating question was deleted', 'event_espresso'), |
|
266 | + false, |
|
267 | + false |
|
268 | + ), |
|
269 | + 'QST_display_text' => new EE_Post_Content_Field( |
|
270 | + 'QST_display_text', |
|
271 | + esc_html__('Question Text', 'event_espresso'), |
|
272 | + true, |
|
273 | + '' |
|
274 | + ), |
|
275 | + 'QST_max' => new EE_Infinite_Integer_Field( |
|
276 | + 'QST_max', |
|
277 | + esc_html__('Max Size', 'event_espresso'), |
|
278 | + false, |
|
279 | + EE_INF |
|
280 | + ), |
|
281 | + 'QST_order' => new EE_Integer_Field( |
|
282 | + 'QST_order', |
|
283 | + esc_html__('Question Order', 'event_espresso'), |
|
284 | + false, |
|
285 | + 0 |
|
286 | + ), |
|
287 | + 'QST_required' => new EE_Boolean_Field( |
|
288 | + 'QST_required', |
|
289 | + esc_html__('Required Question?', 'event_espresso'), |
|
290 | + false, |
|
291 | + false |
|
292 | + ), |
|
293 | + 'QST_required_text' => new EE_Simple_HTML_Field( |
|
294 | + 'QST_required_text', |
|
295 | + esc_html__('Text to Display if Not Provided', 'event_espresso'), |
|
296 | + true, |
|
297 | + '' |
|
298 | + ), |
|
299 | + 'QST_system' => new EE_Plain_Text_Field( |
|
300 | + 'QST_system', |
|
301 | + esc_html__('Internal string ID for question', 'event_espresso'), |
|
302 | + false, |
|
303 | + '' |
|
304 | + ), |
|
305 | + 'QST_type' => new EE_Enum_Text_Field( |
|
306 | + 'QST_type', |
|
307 | + esc_html__('Question Type', 'event_espresso'), |
|
308 | + false, |
|
309 | + 'TEXT', |
|
310 | + $this->_allowed_question_types |
|
311 | + ), |
|
312 | + 'QST_wp_user' => new EE_WP_User_Field( |
|
313 | + 'QST_wp_user', |
|
314 | + esc_html__('Question Creator ID', 'event_espresso'), |
|
315 | + false |
|
316 | + ), |
|
317 | + ], |
|
318 | + ]; |
|
319 | + $this->_model_relations = [ |
|
320 | + 'Answer' => new EE_Has_Many_Relation(), |
|
321 | + 'Question_Group' => new EE_HABTM_Relation('Question_Group_Question'), |
|
322 | + // for QST_order column |
|
323 | + 'Question_Group_Question' => new EE_Has_Many_Relation(), |
|
324 | + 'Question_Option' => new EE_Has_Many_Relation(), |
|
325 | + 'WP_User' => new EE_Belongs_To_Relation(), |
|
326 | + ]; |
|
327 | + // this model is generally available for reading |
|
328 | + $this->_cap_restriction_generators[ EEM_Base::caps_read ] = |
|
329 | + new EE_Restriction_Generator_Public(); |
|
330 | + $this->_cap_restriction_generators[ EEM_Base::caps_read_admin ] = |
|
331 | + new EE_Restriction_Generator_Reg_Form('QST_system'); |
|
332 | + $this->_cap_restriction_generators[ EEM_Base::caps_edit ] = |
|
333 | + new EE_Restriction_Generator_Reg_Form('QST_system'); |
|
334 | + $this->_cap_restriction_generators[ EEM_Base::caps_delete ] = |
|
335 | + new EE_Restriction_Generator_Reg_Form('QST_system'); |
|
336 | + |
|
337 | + parent::__construct($timezone); |
|
338 | + } |
|
339 | + |
|
340 | + |
|
341 | + /** |
|
342 | + * Returns the list of allowed question types, which are normally: |
|
343 | + * 'TEXT','TEXTAREA','RADIO_BTN','DROPDOWN','CHECKBOX','DATE' but they can be extended |
|
344 | + * |
|
345 | + * @return string[] |
|
346 | + */ |
|
347 | + public function allowed_question_types(): array |
|
348 | + { |
|
349 | + return $this->_allowed_question_types; |
|
350 | + } |
|
351 | + |
|
352 | + |
|
353 | + /** |
|
354 | + * Gets all the question types in the same category |
|
355 | + * |
|
356 | + * @param string $question_type one of EEM_Question::allowed_question_types( |
|
357 | + * @return string[] like EEM_Question::allowed_question_types() |
|
358 | + */ |
|
359 | + public function question_types_in_same_category(string $question_type): array |
|
360 | + { |
|
361 | + $question_types = [$question_type]; |
|
362 | + foreach ($this->_question_type_categories as $category => $question_types_in_category) { |
|
363 | + if (in_array($question_type, $question_types_in_category)) { |
|
364 | + $question_types = $question_types_in_category; |
|
365 | + break; |
|
366 | + } |
|
367 | + } |
|
368 | + |
|
369 | + return array_intersect_key($this->allowed_question_types(), array_flip($question_types)); |
|
370 | + } |
|
371 | + |
|
372 | + |
|
373 | + /** |
|
374 | + * Determines if the given question type is in the given question type category |
|
375 | + * |
|
376 | + * @param string $question_type one of EEM_Question::allowed_question_types() |
|
377 | + * @param string $category one of the top-level keys of EEM_Question::question_type_categories() |
|
378 | + * @return boolean |
|
379 | + */ |
|
380 | + public function question_type_is_in_category(string $question_type, string $category): bool |
|
381 | + { |
|
382 | + if (! isset($this->_question_type_categories[ $category ])) { |
|
383 | + return false; |
|
384 | + } |
|
385 | + return in_array($question_type, $this->_question_type_categories[ $category ]); |
|
386 | + } |
|
387 | + |
|
388 | + |
|
389 | + /** |
|
390 | + * Returns all the question types in the given category |
|
391 | + * |
|
392 | + * @param string $category |
|
393 | + * @return array|mixed |
|
394 | + */ |
|
395 | + public function question_types_in_category(string $category): array |
|
396 | + { |
|
397 | + if (isset($this->_question_type_categories[ $category ])) { |
|
398 | + return $this->_question_type_categories[ $category ]; |
|
399 | + } |
|
400 | + return []; |
|
401 | + } |
|
402 | + |
|
403 | + |
|
404 | + /** |
|
405 | + * Returns all the question types that should have question options |
|
406 | + * |
|
407 | + * @return array |
|
408 | + */ |
|
409 | + public function question_types_with_options(): array |
|
410 | + { |
|
411 | + return array_merge( |
|
412 | + $this->question_types_in_category('single-answer-enum'), |
|
413 | + $this->question_types_in_category('multi-answer-enum') |
|
414 | + ); |
|
415 | + } |
|
416 | + |
|
417 | + |
|
418 | + /** |
|
419 | + * Returns the question type categories 2d array |
|
420 | + * |
|
421 | + * @return array see EEM_Question::_question_type_categories |
|
422 | + */ |
|
423 | + public function question_type_categories(): array |
|
424 | + { |
|
425 | + return $this->_question_type_categories; |
|
426 | + } |
|
427 | + |
|
428 | + |
|
429 | + /** |
|
430 | + * Returns an array of all the QST_system values that can be allowed in the system question group |
|
431 | + * identified by $system_question_group_id |
|
432 | + * |
|
433 | + * @param string $system_question_group_id QSG_system |
|
434 | + * @return array of system question names (QST_system) |
|
435 | + */ |
|
436 | + public function allowed_system_questions_in_system_question_group(string $system_question_group_id): array |
|
437 | + { |
|
438 | + $question_system_ids = []; |
|
439 | + switch ($system_question_group_id) { |
|
440 | + case EEM_Question_Group::system_personal: |
|
441 | + $question_system_ids = [ |
|
442 | + EEM_Attendee::system_question_fname, |
|
443 | + EEM_Attendee::system_question_lname, |
|
444 | + EEM_Attendee::system_question_email, |
|
445 | + EEM_Attendee::system_question_email_confirm, |
|
446 | + EEM_Attendee::system_question_phone, |
|
447 | + ]; |
|
448 | + break; |
|
449 | + case EEM_Question_Group::system_address: |
|
450 | + $question_system_ids = [ |
|
451 | + EEM_Attendee::system_question_address, |
|
452 | + EEM_Attendee::system_question_address2, |
|
453 | + EEM_Attendee::system_question_city, |
|
454 | + EEM_Attendee::system_question_state, |
|
455 | + EEM_Attendee::system_question_country, |
|
456 | + EEM_Attendee::system_question_zip, |
|
457 | + EEM_Attendee::system_question_phone, |
|
458 | + ]; |
|
459 | + break; |
|
460 | + } |
|
461 | + return apply_filters( |
|
462 | + 'FHEE__EEM_Question__system_questions_allowed_in_system_question_group__return', |
|
463 | + $question_system_ids, |
|
464 | + $system_question_group_id |
|
465 | + ); |
|
466 | + } |
|
467 | + |
|
468 | + |
|
469 | + /** |
|
470 | + * Returns an array of all the QST_system values that are required in the system question group |
|
471 | + * identified by $system_question_group_id |
|
472 | + * |
|
473 | + * @param string $system_question_group_id QSG_system |
|
474 | + * @return array of system question names (QST_system) |
|
475 | + */ |
|
476 | + public function required_system_questions_in_system_question_group(string $system_question_group_id): array |
|
477 | + { |
|
478 | + $question_system_ids = null; |
|
479 | + switch ($system_question_group_id) { |
|
480 | + case EEM_Question_Group::system_personal: |
|
481 | + $question_system_ids = [ |
|
482 | + EEM_Attendee::system_question_fname, |
|
483 | + EEM_Attendee::system_question_email, |
|
484 | + ]; |
|
485 | + break; |
|
486 | + default: |
|
487 | + $question_system_ids = []; |
|
488 | + } |
|
489 | + return apply_filters( |
|
490 | + 'FHEE__EEM_Question__system_questions_required_in_system_question_group', |
|
491 | + $question_system_ids, |
|
492 | + $system_question_group_id |
|
493 | + ); |
|
494 | + } |
|
495 | + |
|
496 | + |
|
497 | + /** |
|
498 | + * Gets an array for converting between QST_system and QST_IDs for system questions. Eg, if you want to know |
|
499 | + * which system question QST_ID corresponds to the QST_system 'city', use |
|
500 | + * EEM_Question::instance()->get_Question_ID_from_system_string('city'); |
|
501 | + * |
|
502 | + * @param $QST_system |
|
503 | + * @return int of QST_ID for the question that corresponds to that QST_system |
|
504 | + * @throws EE_Error |
|
505 | + */ |
|
506 | + public function get_Question_ID_from_system_string($QST_system): int |
|
507 | + { |
|
508 | + return $this->get_var([['QST_system' => $QST_system]]); |
|
509 | + } |
|
510 | + |
|
511 | + |
|
512 | + /** |
|
513 | + * searches the db for the question with the latest question order and returns that value. |
|
514 | + * |
|
515 | + * @return int |
|
516 | + * @throws EE_Error |
|
517 | + */ |
|
518 | + public function get_latest_question_order(): int |
|
519 | + { |
|
520 | + $columns_to_select = [ |
|
521 | + 'max_order' => ["MAX(QST_order)", "%d"], |
|
522 | + ]; |
|
523 | + $max = $this->_get_all_wpdb_results([], ARRAY_A, $columns_to_select); |
|
524 | + return isset($max[0], $max[0]['max_order']) ? $max[0]['max_order'] : 0; |
|
525 | + } |
|
526 | + |
|
527 | + |
|
528 | + /** |
|
529 | + * Returns an array where keys are system question QST_system values, |
|
530 | + * and values are the highest question max the admin can set on the question |
|
531 | + * (aka the "max max"; eg, a site admin can change the zip question to have a max |
|
532 | + * of 5, but no larger than 12) |
|
533 | + * |
|
534 | + * @return array |
|
535 | + */ |
|
536 | + public function system_question_maxes(): array |
|
537 | + { |
|
538 | + return [ |
|
539 | + 'fname' => 45, |
|
540 | + 'lname' => 45, |
|
541 | + 'address' => 255, |
|
542 | + 'address2' => 255, |
|
543 | + 'city' => 45, |
|
544 | + 'zip' => 12, |
|
545 | + 'email' => 255, |
|
546 | + 'email_confirm' => 255, |
|
547 | + 'phone' => 45, |
|
548 | + ]; |
|
549 | + } |
|
550 | + |
|
551 | + |
|
552 | + /** |
|
553 | + * Given a QST_system value, gets the question's largest allowable max input. |
|
554 | + * |
|
555 | + * @param string $system_question_value |
|
556 | + * @return int|float |
|
557 | + * @see Registration_Form_Admin_Page::system_question_maxes() |
|
558 | + */ |
|
559 | + public function absolute_max_for_system_question(string $system_question_value) |
|
560 | + { |
|
561 | + $maxes = $this->system_question_maxes(); |
|
562 | + return isset($maxes[ $system_question_value ]) ? |
|
563 | + $maxes[ $system_question_value ] |
|
564 | + : EE_INF; |
|
565 | + } |
|
566 | + |
|
567 | + |
|
568 | + /** |
|
569 | + * @return array |
|
570 | + */ |
|
571 | + public function question_descriptions(): array |
|
572 | + { |
|
573 | + return $this->_question_descriptions; |
|
574 | + } |
|
575 | + |
|
576 | + |
|
577 | + /** |
|
578 | + * Returns all the question types that should have an admin-defined max input length |
|
579 | + * |
|
580 | + * @return array |
|
581 | + */ |
|
582 | + public function questionTypesWithMaxLength(): array |
|
583 | + { |
|
584 | + return (array) $this->question_types_with_max_length; |
|
585 | + } |
|
586 | 586 | } |