Completed
Branch FET-8385-datetime-ticket-selec... (ec342c)
by
unknown
45:18 queued 34:32
created
core/db_models/relations/EE_Model_Relation_Base.php 3 patches
Doc Comments   +5 added lines, -5 removed lines patch added patch discarded remove patch
@@ -133,9 +133,9 @@  discard block
 block discarded – undo
133 133
 
134 134
     /**
135 135
      * @param        $other_table
136
-     * @param        $other_table_alias
136
+     * @param        string $other_table_alias
137 137
      * @param        $other_table_column
138
-     * @param        $this_table_alias
138
+     * @param        string $this_table_alias
139 139
      * @param        $this_table_join_column
140 140
      * @param string $extra_join_sql
141 141
      * @return string
@@ -189,7 +189,7 @@  discard block
 block discarded – undo
189 189
      * Alters the $query_params to disable default where conditions, unless otherwise specified
190 190
      *
191 191
      * @param string $query_params
192
-     * @return array
192
+     * @return string
193 193
      */
194 194
     protected function _disable_default_where_conditions_on_query_param($query_params)
195 195
     {
@@ -206,7 +206,7 @@  discard block
 block discarded – undo
206 206
      * Note: If the related model is extends EEM_Soft_Delete_Base, then the related
207 207
      * model objects will only be soft-deleted.
208 208
      *
209
-     * @param EE_Base_Class|int|string $model_object_or_id
209
+     * @param EE_Base_Class|null $model_object_or_id
210 210
      * @param array                    $query_params
211 211
      * @return int of how many related models got deleted
212 212
      * @throws \EE_Error
@@ -237,7 +237,7 @@  discard block
 block discarded – undo
237 237
      * Note: If the related model is extends EEM_Soft_Delete_Base, then the related
238 238
      * model objects will only be soft-deleted.
239 239
      *
240
-     * @param EE_Base_Class|int|string $model_object_or_id
240
+     * @param EE_Base_Class|null $model_object_or_id
241 241
      * @param array                    $query_params
242 242
      * @return int of how many related models got deleted
243 243
      * @throws \EE_Error
Please login to merge, or discard this patch.
Indentation   +374 added lines, -374 removed lines patch added patch discarded remove patch
@@ -14,379 +14,379 @@
 block discarded – undo
14 14
  */
15 15
 abstract class EE_Model_Relation_Base
16 16
 {
17
-    /**
18
-     * The model name of which this relation is a component (ie, the model that called new EE_Model_Relation_Base)
19
-     *
20
-     * @var string eg Event, Question_Group, Registration
21
-     */
22
-    private $_this_model_name;
23
-    /**
24
-     * The model name pointed to by this relation (ie, the model we want to establish a relationship to)
25
-     *
26
-     * @var string eg Event, Question_Group, Registration
27
-     */
28
-    private $_other_model_name;
29
-
30
-    /**
31
-     * this is typically used when calling the relation models to make sure they inherit any set timezone from the
32
-     * initiating model.
33
-     *
34
-     * @var string
35
-     */
36
-    protected $_timezone;
37
-
38
-    /**
39
-     * If you try to delete "this_model", and there are related "other_models",
40
-     * and this isn't null, then abandon the deletion and add this warning.
41
-     * This effectively makes it impossible to delete "this_model" while there are
42
-     * related "other_models" along this relation.
43
-     *
44
-     * @var string (internationalized)
45
-     */
46
-    protected $_blocking_delete_error_message;
47
-
48
-    protected $_blocking_delete = false;
49
-
50
-    /**
51
-     * Object representing the relationship between two models. This knows how to join the models,
52
-     * get related models across the relation, and add-and-remove the relationships.
53
-     *
54
-     * @param boolean $block_deletes                 if there are related models across this relation, block (prevent
55
-     *                                               and add an error) the deletion of this model
56
-     * @param string  $blocking_delete_error_message a customized error message on blocking deletes instead of the
57
-     *                                               default
58
-     */
59
-    public function __construct($block_deletes, $blocking_delete_error_message)
60
-    {
61
-        $this->_blocking_delete               = $block_deletes;
62
-        $this->_blocking_delete_error_message = $blocking_delete_error_message;
63
-    }
64
-
65
-
66
-    /**
67
-     * @param $this_model_name
68
-     * @param $other_model_name
69
-     * @throws EE_Error
70
-     */
71
-    public function _construct_finalize_set_models($this_model_name, $other_model_name)
72
-    {
73
-        $this->_this_model_name  = $this_model_name;
74
-        $this->_other_model_name = $other_model_name;
75
-        if (is_string($this->_blocking_delete)) {
76
-            throw new EE_Error(sprintf(__("When instantiating the relation of type %s from %s to %s, the \$block_deletes argument should be a boolean, not a string (%s)",
77
-                "event_espresso"),
78
-                get_class($this), $this_model_name, $other_model_name, $this->_blocking_delete));
79
-        }
80
-    }
81
-
82
-
83
-    /**
84
-     * Gets the model where this relation is defined.
85
-     *
86
-     * @return EEM_Base
87
-     */
88
-    public function get_this_model()
89
-    {
90
-        return $this->_get_model($this->_this_model_name);
91
-    }
92
-
93
-
94
-    /**
95
-     * Gets the model which this relation establishes the relation TO (ie,
96
-     * this relation object was defined on get_this_model(), get_other_model() is the other one)
97
-     *
98
-     * @return EEM_Base
99
-     */
100
-    public function get_other_model()
101
-    {
102
-        return $this->_get_model($this->_other_model_name);
103
-    }
104
-
105
-
106
-    /**
107
-     * Internally used by get_this_model() and get_other_model()
108
-     *
109
-     * @param string $model_name like Event, Question_Group, etc. omit the EEM_
110
-     * @return EEM_Base
111
-     */
112
-    protected function _get_model($model_name)
113
-    {
114
-        $modelInstance = EE_Registry::instance()->load_model($model_name);
115
-        $modelInstance->set_timezone($this->_timezone);
116
-        return $modelInstance;
117
-    }
118
-
119
-
120
-    /**
121
-     * entirely possible that relations may be called from a model and we need to make sure those relations have their
122
-     * timezone set correctly.
123
-     *
124
-     * @param string $timezone timezone to set.
125
-     */
126
-    public function set_timezone($timezone)
127
-    {
128
-        if ($timezone !== null) {
129
-            $this->_timezone = $timezone;
130
-        }
131
-    }
132
-
133
-
134
-    /**
135
-     * @param        $other_table
136
-     * @param        $other_table_alias
137
-     * @param        $other_table_column
138
-     * @param        $this_table_alias
139
-     * @param        $this_table_join_column
140
-     * @param string $extra_join_sql
141
-     * @return string
142
-     */
143
-    protected function _left_join(
144
-        $other_table,
145
-        $other_table_alias,
146
-        $other_table_column,
147
-        $this_table_alias,
148
-        $this_table_join_column,
149
-        $extra_join_sql = ''
150
-    ) {
151
-        return " LEFT JOIN " . $other_table . " AS " . $other_table_alias . " ON " . $other_table_alias . "." . $other_table_column . "=" . $this_table_alias . "." . $this_table_join_column . ($extra_join_sql ? " AND $extra_join_sql" : '');
152
-    }
153
-
154
-
155
-    /**
156
-     * Gets all the model objects of type of other model related to $model_object,
157
-     * according to this relation. This is the same code for EE_HABTM_Relation and EE_Has_Many_Relation.
158
-     * For both of those child classes, $model_object must be saved so that it has an ID before querying,
159
-     * otherwise an error will be thrown. Note: by default we disable default_where_conditions
160
-     * EE_Belongs_To_Relation doesn't need to be saved before querying.
161
-     *
162
-     * @param EE_Base_Class|int $model_object_or_id                      or the primary key of this model
163
-     * @param array             $query_params                            like EEM_Base::get_all's $query_params
164
-     * @param boolean           $values_already_prepared_by_model_object @deprecated since 4.8.1
165
-     * @return EE_Base_Class[]
166
-     * @throws \EE_Error
167
-     */
168
-    public function get_all_related(
169
-        $model_object_or_id,
170
-        $query_params = array(),
171
-        $values_already_prepared_by_model_object = false
172
-    ) {
173
-        if ($values_already_prepared_by_model_object !== false) {
174
-            EE_Error::doing_it_wrong('EE_Model_Relation_Base::get_all_related',
175
-                __('The argument $values_already_prepared_by_model_object is no longer used.', 'event_espresso'),
176
-                '4.8.1');
177
-        }
178
-        $query_params                                      = $this->_disable_default_where_conditions_on_query_param($query_params);
179
-        $query_param_where_this_model_pk                   = $this->get_this_model()->get_this_model_name()
180
-                                                             . "."
181
-                                                             . $this->get_this_model()->get_primary_key_field()->get_name();
182
-        $model_object_id                                   = $this->_get_model_object_id($model_object_or_id);
183
-        $query_params[0][$query_param_where_this_model_pk] = $model_object_id;
184
-        return $this->get_other_model()->get_all($query_params);
185
-    }
186
-
187
-
188
-    /**
189
-     * Alters the $query_params to disable default where conditions, unless otherwise specified
190
-     *
191
-     * @param string $query_params
192
-     * @return array
193
-     */
194
-    protected function _disable_default_where_conditions_on_query_param($query_params)
195
-    {
196
-        if (! isset($query_params['default_where_conditions'])) {
197
-            $query_params['default_where_conditions'] = 'none';
198
-        }
199
-        return $query_params;
200
-    }
201
-
202
-
203
-    /**
204
-     * Deletes the related model objects which meet the query parameters. If no
205
-     * parameters are specified, then all related model objects will be deleted.
206
-     * Note: If the related model is extends EEM_Soft_Delete_Base, then the related
207
-     * model objects will only be soft-deleted.
208
-     *
209
-     * @param EE_Base_Class|int|string $model_object_or_id
210
-     * @param array                    $query_params
211
-     * @return int of how many related models got deleted
212
-     * @throws \EE_Error
213
-     */
214
-    public function delete_all_related($model_object_or_id, $query_params = array())
215
-    {
216
-        //for each thing we would delete,
217
-        $related_model_objects = $this->get_all_related($model_object_or_id, $query_params);
218
-        //determine if it's blocked by anything else before it can be deleted
219
-        $deleted_count = 0;
220
-        foreach ($related_model_objects as $related_model_object) {
221
-            $delete_is_blocked = $this->get_other_model()->delete_is_blocked_by_related_models($related_model_object,
222
-                $model_object_or_id);
223
-            /* @var $model_object_or_id EE_Base_Class */
224
-            if (! $delete_is_blocked) {
225
-                $this->remove_relation_to($model_object_or_id, $related_model_object);
226
-                $related_model_object->delete();
227
-                $deleted_count++;
228
-            }
229
-        }
230
-        return $deleted_count;
231
-    }
232
-
233
-
234
-    /**
235
-     * Deletes the related model objects which meet the query parameters. If no
236
-     * parameters are specified, then all related model objects will be deleted.
237
-     * Note: If the related model is extends EEM_Soft_Delete_Base, then the related
238
-     * model objects will only be soft-deleted.
239
-     *
240
-     * @param EE_Base_Class|int|string $model_object_or_id
241
-     * @param array                    $query_params
242
-     * @return int of how many related models got deleted
243
-     * @throws \EE_Error
244
-     */
245
-    public function delete_related_permanently($model_object_or_id, $query_params = array())
246
-    {
247
-        //for each thing we would delete,
248
-        $related_model_objects = $this->get_all_related($model_object_or_id, $query_params);
249
-        //determine if it's blocked by anything else before it can be deleted
250
-        $deleted_count = 0;
251
-        foreach ($related_model_objects as $related_model_object) {
252
-            $delete_is_blocked = $this->get_other_model()->delete_is_blocked_by_related_models($related_model_object,
253
-                $model_object_or_id);
254
-            /* @var $model_object_or_id EE_Base_Class */
255
-            if ($related_model_object instanceof EE_Soft_Delete_Base_Class) {
256
-                $this->remove_relation_to($model_object_or_id, $related_model_object);
257
-                $deleted_count++;
258
-                if (! $delete_is_blocked) {
259
-                    $related_model_object->delete_permanently();
260
-                } else {
261
-                    //delete is blocked
262
-                    //brent and darren, in this case, wanted to just soft delete it then
263
-                    $related_model_object->delete();
264
-                }
265
-            } else {
266
-                //its not a soft-deletable thing anyways. do the normal logic.
267
-                if (! $delete_is_blocked) {
268
-                    $this->remove_relation_to($model_object_or_id, $related_model_object);
269
-                    $related_model_object->delete();
270
-                    $deleted_count++;
271
-                }
272
-            }
273
-        }
274
-        return $deleted_count;
275
-    }
276
-
277
-
278
-    /**
279
-     * this just returns a model_object_id for incoming item that could be an object or id.
280
-     *
281
-     * @param  EE_Base_Class|int $model_object_or_id model object or the primary key of this model
282
-     * @throws EE_Error
283
-     * @return int
284
-     */
285
-    protected function _get_model_object_id($model_object_or_id)
286
-    {
287
-        $model_object_id = $model_object_or_id;
288
-        if ($model_object_or_id instanceof EE_Base_Class) {
289
-            $model_object_id = $model_object_or_id->ID();
290
-        }
291
-        if (! $model_object_id) {
292
-            throw new EE_Error(sprintf(__("Sorry, we cant get the related %s model objects to %s model object before it has an ID. You can solve that by just saving it before trying to get its related model objects",
293
-                "event_espresso"), $this->get_other_model()->get_this_model_name(),
294
-                $this->get_this_model()->get_this_model_name()));
295
-        }
296
-        return $model_object_id;
297
-    }
298
-
299
-
300
-    /**
301
-     * Gets the SQL string for performing the join between this model and the other model.
302
-     *
303
-     * @param string $model_relation_chain like 'Event.Event_Venue.Venue'
304
-     * @return string of SQL, eg "LEFT JOIN table_name AS table_alias ON this_model_primary_table.pk =
305
-     *                other_model_primary_table.fk" etc
306
-     */
307
-    abstract public function get_join_statement($model_relation_chain);
308
-
309
-
310
-    /**
311
-     * Adds a relationships between the two model objects provided. Each type of relationship handles this differently
312
-     * (EE_Belongs_To is a slight exception, it should more accurately be called set_relation_to(...), as this
313
-     * relationship only allows this model to be related to a single other model of this type)
314
-     *
315
-     * @param       $this_obj_or_id
316
-     * @param       $other_obj_or_id
317
-     * @param array $extra_join_model_fields_n_values
318
-     * @return \EE_Base_Class the EE_Base_Class which was added as a relation. (Convenient if you only pass an ID for
319
-     *                        $other_obj_or_id)
320
-     */
321
-    abstract public function add_relation_to(
322
-        $this_obj_or_id,
323
-        $other_obj_or_id,
324
-        $extra_join_model_fields_n_values = array()
325
-    );
326
-
327
-
328
-    /**
329
-     * Similar to 'add_relation_to(...)', performs the opposite action of removing the relationship between the two
330
-     * model objects
331
-     *
332
-     * @param       $this_obj_or_id
333
-     * @param       $other_obj_or_id
334
-     * @param array $where_query
335
-     * @return bool
336
-     */
337
-    abstract public function remove_relation_to($this_obj_or_id, $other_obj_or_id, $where_query = array());
338
-
339
-
340
-    /**
341
-     * Removes ALL relation instances for this relation obj
342
-     *
343
-     * @param EE_Base_Class|int $this_obj_or_id
344
-     * @param array             $where_query_param like EEM_Base::get_all's $query_params[0] (where conditions)
345
-     * @return EE_Base_Class[]
346
-     * @throws \EE_Error
347
-     */
348
-    public function remove_relations($this_obj_or_id, $where_query_param = array())
349
-    {
350
-        $related_things = $this->get_all_related($this_obj_or_id, array($where_query_param));
351
-        $objs_removed   = array();
352
-        foreach ($related_things as $related_thing) {
353
-            $objs_removed[] = $this->remove_relation_to($this_obj_or_id, $related_thing);
354
-        }
355
-        return $objs_removed;
356
-    }
357
-
358
-
359
-    /**
360
-     * If you aren't allowed to delete this model when there are related models across this
361
-     * relation object, return true. Otherwise, if you can delete this model even though
362
-     * related objects exist, returns false.
363
-     *
364
-     * @return boolean
365
-     */
366
-    public function block_delete_if_related_models_exist()
367
-    {
368
-        return $this->_blocking_delete;
369
-    }
370
-
371
-
372
-    /**
373
-     * Gets the error message to show
374
-     *
375
-     * @return string
376
-     */
377
-    public function get_deletion_error_message()
378
-    {
379
-        if ($this->_blocking_delete_error_message) {
380
-            return $this->_blocking_delete_error_message;
381
-        } else {
17
+	/**
18
+	 * The model name of which this relation is a component (ie, the model that called new EE_Model_Relation_Base)
19
+	 *
20
+	 * @var string eg Event, Question_Group, Registration
21
+	 */
22
+	private $_this_model_name;
23
+	/**
24
+	 * The model name pointed to by this relation (ie, the model we want to establish a relationship to)
25
+	 *
26
+	 * @var string eg Event, Question_Group, Registration
27
+	 */
28
+	private $_other_model_name;
29
+
30
+	/**
31
+	 * this is typically used when calling the relation models to make sure they inherit any set timezone from the
32
+	 * initiating model.
33
+	 *
34
+	 * @var string
35
+	 */
36
+	protected $_timezone;
37
+
38
+	/**
39
+	 * If you try to delete "this_model", and there are related "other_models",
40
+	 * and this isn't null, then abandon the deletion and add this warning.
41
+	 * This effectively makes it impossible to delete "this_model" while there are
42
+	 * related "other_models" along this relation.
43
+	 *
44
+	 * @var string (internationalized)
45
+	 */
46
+	protected $_blocking_delete_error_message;
47
+
48
+	protected $_blocking_delete = false;
49
+
50
+	/**
51
+	 * Object representing the relationship between two models. This knows how to join the models,
52
+	 * get related models across the relation, and add-and-remove the relationships.
53
+	 *
54
+	 * @param boolean $block_deletes                 if there are related models across this relation, block (prevent
55
+	 *                                               and add an error) the deletion of this model
56
+	 * @param string  $blocking_delete_error_message a customized error message on blocking deletes instead of the
57
+	 *                                               default
58
+	 */
59
+	public function __construct($block_deletes, $blocking_delete_error_message)
60
+	{
61
+		$this->_blocking_delete               = $block_deletes;
62
+		$this->_blocking_delete_error_message = $blocking_delete_error_message;
63
+	}
64
+
65
+
66
+	/**
67
+	 * @param $this_model_name
68
+	 * @param $other_model_name
69
+	 * @throws EE_Error
70
+	 */
71
+	public function _construct_finalize_set_models($this_model_name, $other_model_name)
72
+	{
73
+		$this->_this_model_name  = $this_model_name;
74
+		$this->_other_model_name = $other_model_name;
75
+		if (is_string($this->_blocking_delete)) {
76
+			throw new EE_Error(sprintf(__("When instantiating the relation of type %s from %s to %s, the \$block_deletes argument should be a boolean, not a string (%s)",
77
+				"event_espresso"),
78
+				get_class($this), $this_model_name, $other_model_name, $this->_blocking_delete));
79
+		}
80
+	}
81
+
82
+
83
+	/**
84
+	 * Gets the model where this relation is defined.
85
+	 *
86
+	 * @return EEM_Base
87
+	 */
88
+	public function get_this_model()
89
+	{
90
+		return $this->_get_model($this->_this_model_name);
91
+	}
92
+
93
+
94
+	/**
95
+	 * Gets the model which this relation establishes the relation TO (ie,
96
+	 * this relation object was defined on get_this_model(), get_other_model() is the other one)
97
+	 *
98
+	 * @return EEM_Base
99
+	 */
100
+	public function get_other_model()
101
+	{
102
+		return $this->_get_model($this->_other_model_name);
103
+	}
104
+
105
+
106
+	/**
107
+	 * Internally used by get_this_model() and get_other_model()
108
+	 *
109
+	 * @param string $model_name like Event, Question_Group, etc. omit the EEM_
110
+	 * @return EEM_Base
111
+	 */
112
+	protected function _get_model($model_name)
113
+	{
114
+		$modelInstance = EE_Registry::instance()->load_model($model_name);
115
+		$modelInstance->set_timezone($this->_timezone);
116
+		return $modelInstance;
117
+	}
118
+
119
+
120
+	/**
121
+	 * entirely possible that relations may be called from a model and we need to make sure those relations have their
122
+	 * timezone set correctly.
123
+	 *
124
+	 * @param string $timezone timezone to set.
125
+	 */
126
+	public function set_timezone($timezone)
127
+	{
128
+		if ($timezone !== null) {
129
+			$this->_timezone = $timezone;
130
+		}
131
+	}
132
+
133
+
134
+	/**
135
+	 * @param        $other_table
136
+	 * @param        $other_table_alias
137
+	 * @param        $other_table_column
138
+	 * @param        $this_table_alias
139
+	 * @param        $this_table_join_column
140
+	 * @param string $extra_join_sql
141
+	 * @return string
142
+	 */
143
+	protected function _left_join(
144
+		$other_table,
145
+		$other_table_alias,
146
+		$other_table_column,
147
+		$this_table_alias,
148
+		$this_table_join_column,
149
+		$extra_join_sql = ''
150
+	) {
151
+		return " LEFT JOIN " . $other_table . " AS " . $other_table_alias . " ON " . $other_table_alias . "." . $other_table_column . "=" . $this_table_alias . "." . $this_table_join_column . ($extra_join_sql ? " AND $extra_join_sql" : '');
152
+	}
153
+
154
+
155
+	/**
156
+	 * Gets all the model objects of type of other model related to $model_object,
157
+	 * according to this relation. This is the same code for EE_HABTM_Relation and EE_Has_Many_Relation.
158
+	 * For both of those child classes, $model_object must be saved so that it has an ID before querying,
159
+	 * otherwise an error will be thrown. Note: by default we disable default_where_conditions
160
+	 * EE_Belongs_To_Relation doesn't need to be saved before querying.
161
+	 *
162
+	 * @param EE_Base_Class|int $model_object_or_id                      or the primary key of this model
163
+	 * @param array             $query_params                            like EEM_Base::get_all's $query_params
164
+	 * @param boolean           $values_already_prepared_by_model_object @deprecated since 4.8.1
165
+	 * @return EE_Base_Class[]
166
+	 * @throws \EE_Error
167
+	 */
168
+	public function get_all_related(
169
+		$model_object_or_id,
170
+		$query_params = array(),
171
+		$values_already_prepared_by_model_object = false
172
+	) {
173
+		if ($values_already_prepared_by_model_object !== false) {
174
+			EE_Error::doing_it_wrong('EE_Model_Relation_Base::get_all_related',
175
+				__('The argument $values_already_prepared_by_model_object is no longer used.', 'event_espresso'),
176
+				'4.8.1');
177
+		}
178
+		$query_params                                      = $this->_disable_default_where_conditions_on_query_param($query_params);
179
+		$query_param_where_this_model_pk                   = $this->get_this_model()->get_this_model_name()
180
+															 . "."
181
+															 . $this->get_this_model()->get_primary_key_field()->get_name();
182
+		$model_object_id                                   = $this->_get_model_object_id($model_object_or_id);
183
+		$query_params[0][$query_param_where_this_model_pk] = $model_object_id;
184
+		return $this->get_other_model()->get_all($query_params);
185
+	}
186
+
187
+
188
+	/**
189
+	 * Alters the $query_params to disable default where conditions, unless otherwise specified
190
+	 *
191
+	 * @param string $query_params
192
+	 * @return array
193
+	 */
194
+	protected function _disable_default_where_conditions_on_query_param($query_params)
195
+	{
196
+		if (! isset($query_params['default_where_conditions'])) {
197
+			$query_params['default_where_conditions'] = 'none';
198
+		}
199
+		return $query_params;
200
+	}
201
+
202
+
203
+	/**
204
+	 * Deletes the related model objects which meet the query parameters. If no
205
+	 * parameters are specified, then all related model objects will be deleted.
206
+	 * Note: If the related model is extends EEM_Soft_Delete_Base, then the related
207
+	 * model objects will only be soft-deleted.
208
+	 *
209
+	 * @param EE_Base_Class|int|string $model_object_or_id
210
+	 * @param array                    $query_params
211
+	 * @return int of how many related models got deleted
212
+	 * @throws \EE_Error
213
+	 */
214
+	public function delete_all_related($model_object_or_id, $query_params = array())
215
+	{
216
+		//for each thing we would delete,
217
+		$related_model_objects = $this->get_all_related($model_object_or_id, $query_params);
218
+		//determine if it's blocked by anything else before it can be deleted
219
+		$deleted_count = 0;
220
+		foreach ($related_model_objects as $related_model_object) {
221
+			$delete_is_blocked = $this->get_other_model()->delete_is_blocked_by_related_models($related_model_object,
222
+				$model_object_or_id);
223
+			/* @var $model_object_or_id EE_Base_Class */
224
+			if (! $delete_is_blocked) {
225
+				$this->remove_relation_to($model_object_or_id, $related_model_object);
226
+				$related_model_object->delete();
227
+				$deleted_count++;
228
+			}
229
+		}
230
+		return $deleted_count;
231
+	}
232
+
233
+
234
+	/**
235
+	 * Deletes the related model objects which meet the query parameters. If no
236
+	 * parameters are specified, then all related model objects will be deleted.
237
+	 * Note: If the related model is extends EEM_Soft_Delete_Base, then the related
238
+	 * model objects will only be soft-deleted.
239
+	 *
240
+	 * @param EE_Base_Class|int|string $model_object_or_id
241
+	 * @param array                    $query_params
242
+	 * @return int of how many related models got deleted
243
+	 * @throws \EE_Error
244
+	 */
245
+	public function delete_related_permanently($model_object_or_id, $query_params = array())
246
+	{
247
+		//for each thing we would delete,
248
+		$related_model_objects = $this->get_all_related($model_object_or_id, $query_params);
249
+		//determine if it's blocked by anything else before it can be deleted
250
+		$deleted_count = 0;
251
+		foreach ($related_model_objects as $related_model_object) {
252
+			$delete_is_blocked = $this->get_other_model()->delete_is_blocked_by_related_models($related_model_object,
253
+				$model_object_or_id);
254
+			/* @var $model_object_or_id EE_Base_Class */
255
+			if ($related_model_object instanceof EE_Soft_Delete_Base_Class) {
256
+				$this->remove_relation_to($model_object_or_id, $related_model_object);
257
+				$deleted_count++;
258
+				if (! $delete_is_blocked) {
259
+					$related_model_object->delete_permanently();
260
+				} else {
261
+					//delete is blocked
262
+					//brent and darren, in this case, wanted to just soft delete it then
263
+					$related_model_object->delete();
264
+				}
265
+			} else {
266
+				//its not a soft-deletable thing anyways. do the normal logic.
267
+				if (! $delete_is_blocked) {
268
+					$this->remove_relation_to($model_object_or_id, $related_model_object);
269
+					$related_model_object->delete();
270
+					$deleted_count++;
271
+				}
272
+			}
273
+		}
274
+		return $deleted_count;
275
+	}
276
+
277
+
278
+	/**
279
+	 * this just returns a model_object_id for incoming item that could be an object or id.
280
+	 *
281
+	 * @param  EE_Base_Class|int $model_object_or_id model object or the primary key of this model
282
+	 * @throws EE_Error
283
+	 * @return int
284
+	 */
285
+	protected function _get_model_object_id($model_object_or_id)
286
+	{
287
+		$model_object_id = $model_object_or_id;
288
+		if ($model_object_or_id instanceof EE_Base_Class) {
289
+			$model_object_id = $model_object_or_id->ID();
290
+		}
291
+		if (! $model_object_id) {
292
+			throw new EE_Error(sprintf(__("Sorry, we cant get the related %s model objects to %s model object before it has an ID. You can solve that by just saving it before trying to get its related model objects",
293
+				"event_espresso"), $this->get_other_model()->get_this_model_name(),
294
+				$this->get_this_model()->get_this_model_name()));
295
+		}
296
+		return $model_object_id;
297
+	}
298
+
299
+
300
+	/**
301
+	 * Gets the SQL string for performing the join between this model and the other model.
302
+	 *
303
+	 * @param string $model_relation_chain like 'Event.Event_Venue.Venue'
304
+	 * @return string of SQL, eg "LEFT JOIN table_name AS table_alias ON this_model_primary_table.pk =
305
+	 *                other_model_primary_table.fk" etc
306
+	 */
307
+	abstract public function get_join_statement($model_relation_chain);
308
+
309
+
310
+	/**
311
+	 * Adds a relationships between the two model objects provided. Each type of relationship handles this differently
312
+	 * (EE_Belongs_To is a slight exception, it should more accurately be called set_relation_to(...), as this
313
+	 * relationship only allows this model to be related to a single other model of this type)
314
+	 *
315
+	 * @param       $this_obj_or_id
316
+	 * @param       $other_obj_or_id
317
+	 * @param array $extra_join_model_fields_n_values
318
+	 * @return \EE_Base_Class the EE_Base_Class which was added as a relation. (Convenient if you only pass an ID for
319
+	 *                        $other_obj_or_id)
320
+	 */
321
+	abstract public function add_relation_to(
322
+		$this_obj_or_id,
323
+		$other_obj_or_id,
324
+		$extra_join_model_fields_n_values = array()
325
+	);
326
+
327
+
328
+	/**
329
+	 * Similar to 'add_relation_to(...)', performs the opposite action of removing the relationship between the two
330
+	 * model objects
331
+	 *
332
+	 * @param       $this_obj_or_id
333
+	 * @param       $other_obj_or_id
334
+	 * @param array $where_query
335
+	 * @return bool
336
+	 */
337
+	abstract public function remove_relation_to($this_obj_or_id, $other_obj_or_id, $where_query = array());
338
+
339
+
340
+	/**
341
+	 * Removes ALL relation instances for this relation obj
342
+	 *
343
+	 * @param EE_Base_Class|int $this_obj_or_id
344
+	 * @param array             $where_query_param like EEM_Base::get_all's $query_params[0] (where conditions)
345
+	 * @return EE_Base_Class[]
346
+	 * @throws \EE_Error
347
+	 */
348
+	public function remove_relations($this_obj_or_id, $where_query_param = array())
349
+	{
350
+		$related_things = $this->get_all_related($this_obj_or_id, array($where_query_param));
351
+		$objs_removed   = array();
352
+		foreach ($related_things as $related_thing) {
353
+			$objs_removed[] = $this->remove_relation_to($this_obj_or_id, $related_thing);
354
+		}
355
+		return $objs_removed;
356
+	}
357
+
358
+
359
+	/**
360
+	 * If you aren't allowed to delete this model when there are related models across this
361
+	 * relation object, return true. Otherwise, if you can delete this model even though
362
+	 * related objects exist, returns false.
363
+	 *
364
+	 * @return boolean
365
+	 */
366
+	public function block_delete_if_related_models_exist()
367
+	{
368
+		return $this->_blocking_delete;
369
+	}
370
+
371
+
372
+	/**
373
+	 * Gets the error message to show
374
+	 *
375
+	 * @return string
376
+	 */
377
+	public function get_deletion_error_message()
378
+	{
379
+		if ($this->_blocking_delete_error_message) {
380
+			return $this->_blocking_delete_error_message;
381
+		} else {
382 382
 //			return sprintf(__('Cannot delete %1$s when there are related %2$s', "event_espresso"),$this->get_this_model()->item_name(2),$this->get_other_model()->item_name(2));
383
-            return sprintf(
384
-                __('This %1$s is currently linked to one or more %2$s records. If this %1$s is incorrect, then please remove it from all %3$s before attempting to delete it.',
385
-                    "event_espresso"),
386
-                $this->get_this_model()->item_name(1),
387
-                $this->get_other_model()->item_name(1),
388
-                $this->get_other_model()->item_name(2)
389
-            );
390
-        }
391
-    }
383
+			return sprintf(
384
+				__('This %1$s is currently linked to one or more %2$s records. If this %1$s is incorrect, then please remove it from all %3$s before attempting to delete it.',
385
+					"event_espresso"),
386
+				$this->get_this_model()->item_name(1),
387
+				$this->get_other_model()->item_name(1),
388
+				$this->get_other_model()->item_name(2)
389
+			);
390
+		}
391
+	}
392 392
 }
Please login to merge, or discard this patch.
Spacing   +6 added lines, -6 removed lines patch added patch discarded remove patch
@@ -148,7 +148,7 @@  discard block
 block discarded – undo
148 148
         $this_table_join_column,
149 149
         $extra_join_sql = ''
150 150
     ) {
151
-        return " LEFT JOIN " . $other_table . " AS " . $other_table_alias . " ON " . $other_table_alias . "." . $other_table_column . "=" . $this_table_alias . "." . $this_table_join_column . ($extra_join_sql ? " AND $extra_join_sql" : '');
151
+        return " LEFT JOIN ".$other_table." AS ".$other_table_alias." ON ".$other_table_alias.".".$other_table_column."=".$this_table_alias.".".$this_table_join_column.($extra_join_sql ? " AND $extra_join_sql" : '');
152 152
     }
153 153
 
154 154
 
@@ -193,7 +193,7 @@  discard block
 block discarded – undo
193 193
      */
194 194
     protected function _disable_default_where_conditions_on_query_param($query_params)
195 195
     {
196
-        if (! isset($query_params['default_where_conditions'])) {
196
+        if ( ! isset($query_params['default_where_conditions'])) {
197 197
             $query_params['default_where_conditions'] = 'none';
198 198
         }
199 199
         return $query_params;
@@ -221,7 +221,7 @@  discard block
 block discarded – undo
221 221
             $delete_is_blocked = $this->get_other_model()->delete_is_blocked_by_related_models($related_model_object,
222 222
                 $model_object_or_id);
223 223
             /* @var $model_object_or_id EE_Base_Class */
224
-            if (! $delete_is_blocked) {
224
+            if ( ! $delete_is_blocked) {
225 225
                 $this->remove_relation_to($model_object_or_id, $related_model_object);
226 226
                 $related_model_object->delete();
227 227
                 $deleted_count++;
@@ -255,7 +255,7 @@  discard block
 block discarded – undo
255 255
             if ($related_model_object instanceof EE_Soft_Delete_Base_Class) {
256 256
                 $this->remove_relation_to($model_object_or_id, $related_model_object);
257 257
                 $deleted_count++;
258
-                if (! $delete_is_blocked) {
258
+                if ( ! $delete_is_blocked) {
259 259
                     $related_model_object->delete_permanently();
260 260
                 } else {
261 261
                     //delete is blocked
@@ -264,7 +264,7 @@  discard block
 block discarded – undo
264 264
                 }
265 265
             } else {
266 266
                 //its not a soft-deletable thing anyways. do the normal logic.
267
-                if (! $delete_is_blocked) {
267
+                if ( ! $delete_is_blocked) {
268 268
                     $this->remove_relation_to($model_object_or_id, $related_model_object);
269 269
                     $related_model_object->delete();
270 270
                     $deleted_count++;
@@ -288,7 +288,7 @@  discard block
 block discarded – undo
288 288
         if ($model_object_or_id instanceof EE_Base_Class) {
289 289
             $model_object_id = $model_object_or_id->ID();
290 290
         }
291
-        if (! $model_object_id) {
291
+        if ( ! $model_object_id) {
292 292
             throw new EE_Error(sprintf(__("Sorry, we cant get the related %s model objects to %s model object before it has an ID. You can solve that by just saving it before trying to get its related model objects",
293 293
                 "event_espresso"), $this->get_other_model()->get_this_model_name(),
294 294
                 $this->get_this_model()->get_this_model_name()));
Please login to merge, or discard this patch.
core/db_models/fields/EE_Any_Foreign_Model_Name_Field.php 2 patches
Indentation   +4 added lines, -4 removed lines patch added patch discarded remove patch
@@ -3,8 +3,8 @@
 block discarded – undo
3 3
 
4 4
 class EE_DB_Only_Text_Field extends EE_DB_Only_Field_Base
5 5
 {
6
-    function get_wpdb_data_type()
7
-    {
8
-        return '%s';
9
-    }
6
+	function get_wpdb_data_type()
7
+	{
8
+		return '%s';
9
+	}
10 10
 }
11 11
\ No newline at end of file
Please login to merge, or discard this patch.
Spacing   +1 added lines, -1 removed lines patch added patch discarded remove patch
@@ -1,6 +1,6 @@
 block discarded – undo
1 1
 <?php
2 2
 
3
-require_once(EE_MODELS . 'fields/EE_DB_Only_Field_Base.php');
3
+require_once(EE_MODELS.'fields/EE_DB_Only_Field_Base.php');
4 4
 
5 5
 class EE_DB_Only_Int_Field extends EE_DB_Only_Field_Base
6 6
 {
Please login to merge, or discard this patch.
core/db_models/relations/EE_Has_Many_Relation.php 2 patches
Indentation   +81 added lines, -81 removed lines patch added patch discarded remove patch
@@ -13,93 +13,93 @@
 block discarded – undo
13 13
 class EE_Has_Many_Relation extends EE_Model_Relation_Base
14 14
 {
15 15
 
16
-    /**
17
-     * Object representing the relationship between two models. Has_Many_Relations are where the OTHER model has the
18
-     * foreign key this model. IE, there can be many other model objects related to one of this model's objects (but
19
-     * NOT through a JOIN table, which is the case for EE_HABTM_Relations). This knows how to join the models, get
20
-     * related models across the relation, and add-and-remove the relationships.
21
-     *
22
-     * @param boolean $block_deletes                 For this type of relation, we block by default. If there are
23
-     *                                               related models across this relation, block (prevent and add an
24
-     *                                               error) the deletion of this model
25
-     * @param string  $blocking_delete_error_message a customized error message on blocking deletes instead of the
26
-     *                                               default
27
-     */
28
-    public function __construct($block_deletes = true, $blocking_delete_error_message = null)
29
-    {
30
-        parent::__construct($block_deletes, $blocking_delete_error_message);
31
-    }
16
+	/**
17
+	 * Object representing the relationship between two models. Has_Many_Relations are where the OTHER model has the
18
+	 * foreign key this model. IE, there can be many other model objects related to one of this model's objects (but
19
+	 * NOT through a JOIN table, which is the case for EE_HABTM_Relations). This knows how to join the models, get
20
+	 * related models across the relation, and add-and-remove the relationships.
21
+	 *
22
+	 * @param boolean $block_deletes                 For this type of relation, we block by default. If there are
23
+	 *                                               related models across this relation, block (prevent and add an
24
+	 *                                               error) the deletion of this model
25
+	 * @param string  $blocking_delete_error_message a customized error message on blocking deletes instead of the
26
+	 *                                               default
27
+	 */
28
+	public function __construct($block_deletes = true, $blocking_delete_error_message = null)
29
+	{
30
+		parent::__construct($block_deletes, $blocking_delete_error_message);
31
+	}
32 32
 
33 33
 
34
-    /**
35
-     * Gets the SQL string for performing the join between this model and the other model.
36
-     *
37
-     * @param string $model_relation_chain like 'Event.Event_Venue.Venue'
38
-     * @return string of SQL, eg "LEFT JOIN table_name AS table_alias ON this_model_primary_table.pk =
39
-     *                other_model_primary_table.fk" etc
40
-     * @throws \EE_Error
41
-     */
42
-    public function get_join_statement($model_relation_chain)
43
-    {
44
-        //create the sql string like
45
-        // LEFT JOIN other_table AS table_alias ON this_table_alias.pk = other_table_alias.fk extra_join_conditions
46
-        $this_table_pk_field  = $this->get_this_model()->get_primary_key_field();
47
-        $other_table_fk_field = $this->get_other_model()->get_foreign_key_to($this->get_this_model()->get_this_model_name());
48
-        $pk_table_alias       = EE_Model_Parser::extract_table_alias_model_relation_chain_prefix($model_relation_chain,
49
-                $this->get_this_model()->get_this_model_name()) . $this_table_pk_field->get_table_alias();
50
-        $fk_table_alias       = EE_Model_Parser::extract_table_alias_model_relation_chain_prefix($model_relation_chain,
51
-                $this->get_other_model()->get_this_model_name()) . $other_table_fk_field->get_table_alias();
52
-        $fk_table             = $this->get_other_model()->get_table_for_alias($fk_table_alias);
34
+	/**
35
+	 * Gets the SQL string for performing the join between this model and the other model.
36
+	 *
37
+	 * @param string $model_relation_chain like 'Event.Event_Venue.Venue'
38
+	 * @return string of SQL, eg "LEFT JOIN table_name AS table_alias ON this_model_primary_table.pk =
39
+	 *                other_model_primary_table.fk" etc
40
+	 * @throws \EE_Error
41
+	 */
42
+	public function get_join_statement($model_relation_chain)
43
+	{
44
+		//create the sql string like
45
+		// LEFT JOIN other_table AS table_alias ON this_table_alias.pk = other_table_alias.fk extra_join_conditions
46
+		$this_table_pk_field  = $this->get_this_model()->get_primary_key_field();
47
+		$other_table_fk_field = $this->get_other_model()->get_foreign_key_to($this->get_this_model()->get_this_model_name());
48
+		$pk_table_alias       = EE_Model_Parser::extract_table_alias_model_relation_chain_prefix($model_relation_chain,
49
+				$this->get_this_model()->get_this_model_name()) . $this_table_pk_field->get_table_alias();
50
+		$fk_table_alias       = EE_Model_Parser::extract_table_alias_model_relation_chain_prefix($model_relation_chain,
51
+				$this->get_other_model()->get_this_model_name()) . $other_table_fk_field->get_table_alias();
52
+		$fk_table             = $this->get_other_model()->get_table_for_alias($fk_table_alias);
53 53
 
54
-        return $this->_left_join($fk_table, $fk_table_alias, $other_table_fk_field->get_table_column(), $pk_table_alias,
55
-                $this_table_pk_field->get_table_column()) . $this->get_other_model()->_construct_internal_join_to_table_with_alias($fk_table_alias);
56
-    }
54
+		return $this->_left_join($fk_table, $fk_table_alias, $other_table_fk_field->get_table_column(), $pk_table_alias,
55
+				$this_table_pk_field->get_table_column()) . $this->get_other_model()->_construct_internal_join_to_table_with_alias($fk_table_alias);
56
+	}
57 57
 
58 58
 
59
-    /**
60
-     * Sets the other model object's foreign key to this model object's primary key. Feel free to do this manually if
61
-     * you like.
62
-     *
63
-     * @param EE_Base_Class|int $this_obj_or_id
64
-     * @param EE_Base_Class|int $other_obj_or_id
65
-     * @param array             $extra_join_model_fields_n_values
66
-     * @return \EE_Base_Class
67
-     * @throws \EE_Error
68
-     */
69
-    public function add_relation_to($this_obj_or_id, $other_obj_or_id, $extra_join_model_fields_n_values = array())
70
-    {
71
-        $this_model_obj  = $this->get_this_model()->ensure_is_obj($this_obj_or_id, true);
72
-        $other_model_obj = $this->get_other_model()->ensure_is_obj($other_obj_or_id, true);
59
+	/**
60
+	 * Sets the other model object's foreign key to this model object's primary key. Feel free to do this manually if
61
+	 * you like.
62
+	 *
63
+	 * @param EE_Base_Class|int $this_obj_or_id
64
+	 * @param EE_Base_Class|int $other_obj_or_id
65
+	 * @param array             $extra_join_model_fields_n_values
66
+	 * @return \EE_Base_Class
67
+	 * @throws \EE_Error
68
+	 */
69
+	public function add_relation_to($this_obj_or_id, $other_obj_or_id, $extra_join_model_fields_n_values = array())
70
+	{
71
+		$this_model_obj  = $this->get_this_model()->ensure_is_obj($this_obj_or_id, true);
72
+		$other_model_obj = $this->get_other_model()->ensure_is_obj($other_obj_or_id, true);
73 73
 
74
-        //find the field on the other model which is a foreign key to this model
75
-        $fk_field_on_other_model = $this->get_other_model()->get_foreign_key_to($this->get_this_model()->get_this_model_name());
76
-        if ($other_model_obj->get($fk_field_on_other_model->get_name()) != $this_model_obj->ID()) {
77
-            //set that field on the other model to this model's ID
78
-            $other_model_obj->set($fk_field_on_other_model->get_name(), $this_model_obj->ID());
79
-            $other_model_obj->save();
80
-        }
81
-        return $other_model_obj;
82
-    }
74
+		//find the field on the other model which is a foreign key to this model
75
+		$fk_field_on_other_model = $this->get_other_model()->get_foreign_key_to($this->get_this_model()->get_this_model_name());
76
+		if ($other_model_obj->get($fk_field_on_other_model->get_name()) != $this_model_obj->ID()) {
77
+			//set that field on the other model to this model's ID
78
+			$other_model_obj->set($fk_field_on_other_model->get_name(), $this_model_obj->ID());
79
+			$other_model_obj->save();
80
+		}
81
+		return $other_model_obj;
82
+	}
83 83
 
84 84
 
85
-    /**
86
-     * Sets the other model object's foreign key to its default, instead of pointing to this model object.
87
-     * If $other_obj_or_id doesn't have any other relations, this function is essentially orphaning it
88
-     *
89
-     * @param EE_Base_Class|int $this_obj_or_id
90
-     * @param EE_Base_Class|int $other_obj_or_id
91
-     * @param array             $where_query
92
-     * @return \EE_Base_Class
93
-     * @throws \EE_Error
94
-     */
95
-    public function remove_relation_to($this_obj_or_id, $other_obj_or_id, $where_query = array())
96
-    {
97
-        $other_model_obj = $this->get_other_model()->ensure_is_obj($other_obj_or_id, true);
98
-        //find the field on the other model which is a foreign key to this model
99
-        $fk_field_on_other_model = $this->get_other_model()->get_foreign_key_to($this->get_this_model()->get_this_model_name());
100
-        //set that field on the other model to this model's ID
101
-        $other_model_obj->set($fk_field_on_other_model->get_name(), null, true);
102
-        $other_model_obj->save();
103
-        return $other_model_obj;
104
-    }
85
+	/**
86
+	 * Sets the other model object's foreign key to its default, instead of pointing to this model object.
87
+	 * If $other_obj_or_id doesn't have any other relations, this function is essentially orphaning it
88
+	 *
89
+	 * @param EE_Base_Class|int $this_obj_or_id
90
+	 * @param EE_Base_Class|int $other_obj_or_id
91
+	 * @param array             $where_query
92
+	 * @return \EE_Base_Class
93
+	 * @throws \EE_Error
94
+	 */
95
+	public function remove_relation_to($this_obj_or_id, $other_obj_or_id, $where_query = array())
96
+	{
97
+		$other_model_obj = $this->get_other_model()->ensure_is_obj($other_obj_or_id, true);
98
+		//find the field on the other model which is a foreign key to this model
99
+		$fk_field_on_other_model = $this->get_other_model()->get_foreign_key_to($this->get_this_model()->get_this_model_name());
100
+		//set that field on the other model to this model's ID
101
+		$other_model_obj->set($fk_field_on_other_model->get_name(), null, true);
102
+		$other_model_obj->save();
103
+		return $other_model_obj;
104
+	}
105 105
 }
Please login to merge, or discard this patch.
Spacing   +4 added lines, -4 removed lines patch added patch discarded remove patch
@@ -1,5 +1,5 @@  discard block
 block discarded – undo
1 1
 <?php
2
-require_once(EE_MODELS . 'relations/EE_Model_Relation_Base.php');
2
+require_once(EE_MODELS.'relations/EE_Model_Relation_Base.php');
3 3
 
4 4
 
5 5
 /**
@@ -46,13 +46,13 @@  discard block
 block discarded – undo
46 46
         $this_table_pk_field  = $this->get_this_model()->get_primary_key_field();
47 47
         $other_table_fk_field = $this->get_other_model()->get_foreign_key_to($this->get_this_model()->get_this_model_name());
48 48
         $pk_table_alias       = EE_Model_Parser::extract_table_alias_model_relation_chain_prefix($model_relation_chain,
49
-                $this->get_this_model()->get_this_model_name()) . $this_table_pk_field->get_table_alias();
49
+                $this->get_this_model()->get_this_model_name()).$this_table_pk_field->get_table_alias();
50 50
         $fk_table_alias       = EE_Model_Parser::extract_table_alias_model_relation_chain_prefix($model_relation_chain,
51
-                $this->get_other_model()->get_this_model_name()) . $other_table_fk_field->get_table_alias();
51
+                $this->get_other_model()->get_this_model_name()).$other_table_fk_field->get_table_alias();
52 52
         $fk_table             = $this->get_other_model()->get_table_for_alias($fk_table_alias);
53 53
 
54 54
         return $this->_left_join($fk_table, $fk_table_alias, $other_table_fk_field->get_table_column(), $pk_table_alias,
55
-                $this_table_pk_field->get_table_column()) . $this->get_other_model()->_construct_internal_join_to_table_with_alias($fk_table_alias);
55
+                $this_table_pk_field->get_table_column()).$this->get_other_model()->_construct_internal_join_to_table_with_alias($fk_table_alias);
56 56
     }
57 57
 
58 58
 
Please login to merge, or discard this patch.
core/db_models/relations/EE_Has_Many_Any_Relation.php 2 patches
Indentation   +73 added lines, -73 removed lines patch added patch discarded remove patch
@@ -22,83 +22,83 @@
 block discarded – undo
22 22
 class EE_Has_Many_Any_Relation extends EE_Has_Many_Relation
23 23
 {
24 24
 
25
-    /**
26
-     * Gets the SQL string for performing the join between this model and the other model.
27
-     *
28
-     * @param string $model_relation_chain like 'Event.Event_Venue.Venue'
29
-     * @return string of SQL, eg "LEFT JOIN table_name AS table_alias ON this_model_primary_table.pk =
30
-     *                other_model_primary_table.fk" etc
31
-     * @throws \EE_Error
32
-     */
33
-    public function get_join_statement($model_relation_chain)
34
-    {
35
-        //create the sql string like
36
-        // LEFT JOIN other_table AS table_alias ON this_table_alias.pk = other_table_alias.fk extra_join_conditions
37
-        $this_table_pk_field   = $this->get_this_model()->get_primary_key_field();
38
-        $other_table_fk_field  = $this->get_other_model()->get_foreign_key_to($this->get_this_model()->get_this_model_name());
39
-        $pk_table_alias        = EE_Model_Parser::extract_table_alias_model_relation_chain_prefix($model_relation_chain,
40
-                $this->get_this_model()->get_this_model_name()) . $this_table_pk_field->get_table_alias();
41
-        $fk_table_alias        = EE_Model_Parser::extract_table_alias_model_relation_chain_prefix($model_relation_chain,
42
-                $this->get_other_model()->get_this_model_name()) . $other_table_fk_field->get_table_alias();
43
-        $fk_table              = $this->get_other_model()->get_table_for_alias($fk_table_alias);
44
-        $field_with_model_name = $this->get_other_model()->get_field_containing_related_model_name();
25
+	/**
26
+	 * Gets the SQL string for performing the join between this model and the other model.
27
+	 *
28
+	 * @param string $model_relation_chain like 'Event.Event_Venue.Venue'
29
+	 * @return string of SQL, eg "LEFT JOIN table_name AS table_alias ON this_model_primary_table.pk =
30
+	 *                other_model_primary_table.fk" etc
31
+	 * @throws \EE_Error
32
+	 */
33
+	public function get_join_statement($model_relation_chain)
34
+	{
35
+		//create the sql string like
36
+		// LEFT JOIN other_table AS table_alias ON this_table_alias.pk = other_table_alias.fk extra_join_conditions
37
+		$this_table_pk_field   = $this->get_this_model()->get_primary_key_field();
38
+		$other_table_fk_field  = $this->get_other_model()->get_foreign_key_to($this->get_this_model()->get_this_model_name());
39
+		$pk_table_alias        = EE_Model_Parser::extract_table_alias_model_relation_chain_prefix($model_relation_chain,
40
+				$this->get_this_model()->get_this_model_name()) . $this_table_pk_field->get_table_alias();
41
+		$fk_table_alias        = EE_Model_Parser::extract_table_alias_model_relation_chain_prefix($model_relation_chain,
42
+				$this->get_other_model()->get_this_model_name()) . $other_table_fk_field->get_table_alias();
43
+		$fk_table              = $this->get_other_model()->get_table_for_alias($fk_table_alias);
44
+		$field_with_model_name = $this->get_other_model()->get_field_containing_related_model_name();
45 45
 
46
-        return $this->_left_join($fk_table,
47
-                $fk_table_alias,
48
-                $other_table_fk_field->get_table_column(),
49
-                $pk_table_alias,
50
-                $this_table_pk_field->get_table_column(),
51
-                $fk_table_alias . '.' . $field_with_model_name->get_table_column() . "='" . $this->get_this_model()->get_this_model_name() . "'")
52
-               . $this->get_other_model()->_construct_internal_join_to_table_with_alias($fk_table_alias);
53
-    }
46
+		return $this->_left_join($fk_table,
47
+				$fk_table_alias,
48
+				$other_table_fk_field->get_table_column(),
49
+				$pk_table_alias,
50
+				$this_table_pk_field->get_table_column(),
51
+				$fk_table_alias . '.' . $field_with_model_name->get_table_column() . "='" . $this->get_this_model()->get_this_model_name() . "'")
52
+			   . $this->get_other_model()->_construct_internal_join_to_table_with_alias($fk_table_alias);
53
+	}
54 54
 
55 55
 
56
-    /**
57
-     * Sets the other model object's foreign key to this model object's primary key. Feel free to do this manually if
58
-     * you like.
59
-     *
60
-     * @param EE_Base_Class|int $this_obj_or_id
61
-     * @param EE_Base_Class|int $other_obj_or_id
62
-     * @param array             $extra_join_model_fields_n_values
63
-     * @return \EE_Base_Class
64
-     * @throws \EE_Error
65
-     */
66
-    public function add_relation_to($this_obj_or_id, $other_obj_or_id, $extra_join_model_fields_n_values = array())
67
-    {
68
-        $this_model_obj  = $this->get_this_model()->ensure_is_obj($this_obj_or_id, true);
69
-        $other_model_obj = $this->get_other_model()->ensure_is_obj($other_obj_or_id, true);
56
+	/**
57
+	 * Sets the other model object's foreign key to this model object's primary key. Feel free to do this manually if
58
+	 * you like.
59
+	 *
60
+	 * @param EE_Base_Class|int $this_obj_or_id
61
+	 * @param EE_Base_Class|int $other_obj_or_id
62
+	 * @param array             $extra_join_model_fields_n_values
63
+	 * @return \EE_Base_Class
64
+	 * @throws \EE_Error
65
+	 */
66
+	public function add_relation_to($this_obj_or_id, $other_obj_or_id, $extra_join_model_fields_n_values = array())
67
+	{
68
+		$this_model_obj  = $this->get_this_model()->ensure_is_obj($this_obj_or_id, true);
69
+		$other_model_obj = $this->get_other_model()->ensure_is_obj($other_obj_or_id, true);
70 70
 
71
-        //find the field on the other model which is a foreign key to this model
72
-        $fk_field_on_other_model = $this->get_other_model()->get_foreign_key_to($this->get_this_model()->get_this_model_name());
73
-        //set that field on the other model to this model's ID
74
-        $other_model_obj->set($fk_field_on_other_model->get_name(), $this_model_obj->ID());
75
-        $other_model_obj->set($this->get_other_model()->get_field_containing_related_model_name()->get_name(),
76
-            $this->get_this_model()->get_this_model_name());
77
-        $other_model_obj->save();
78
-        return $other_model_obj;
79
-    }
71
+		//find the field on the other model which is a foreign key to this model
72
+		$fk_field_on_other_model = $this->get_other_model()->get_foreign_key_to($this->get_this_model()->get_this_model_name());
73
+		//set that field on the other model to this model's ID
74
+		$other_model_obj->set($fk_field_on_other_model->get_name(), $this_model_obj->ID());
75
+		$other_model_obj->set($this->get_other_model()->get_field_containing_related_model_name()->get_name(),
76
+			$this->get_this_model()->get_this_model_name());
77
+		$other_model_obj->save();
78
+		return $other_model_obj;
79
+	}
80 80
 
81 81
 
82
-    /**
83
-     * Sets the other model object's foreign key to its default, instead of pointing to this model object.
84
-     * If $other_obj_or_id doesn't have any other relations, this function is essentially orphaning it
85
-     *
86
-     * @param EE_Base_Class|int $this_obj_or_id
87
-     * @param EE_Base_Class|int $other_obj_or_id
88
-     * @param array             $where_query
89
-     * @return \EE_Base_Class
90
-     * @throws \EE_Error
91
-     */
92
-    public function remove_relation_to($this_obj_or_id, $other_obj_or_id, $where_query = array())
93
-    {
94
-        $other_model_obj = $this->get_other_model()->ensure_is_obj($other_obj_or_id, true);
95
-        //find the field on the other model which is a foreign key to this model
96
-        $fk_field_on_other_model = $this->get_other_model()->get_foreign_key_to($this->get_this_model()->get_this_model_name());
97
-        //set that field on the other model to this model's ID
98
-        $other_model_obj->set($fk_field_on_other_model->get_name(), null, true);
99
-        $other_model_obj->set($this->get_other_model()->get_field_containing_related_model_name()->get_name(), null,
100
-            true);
101
-        $other_model_obj->save();
102
-        return $other_model_obj;
103
-    }
82
+	/**
83
+	 * Sets the other model object's foreign key to its default, instead of pointing to this model object.
84
+	 * If $other_obj_or_id doesn't have any other relations, this function is essentially orphaning it
85
+	 *
86
+	 * @param EE_Base_Class|int $this_obj_or_id
87
+	 * @param EE_Base_Class|int $other_obj_or_id
88
+	 * @param array             $where_query
89
+	 * @return \EE_Base_Class
90
+	 * @throws \EE_Error
91
+	 */
92
+	public function remove_relation_to($this_obj_or_id, $other_obj_or_id, $where_query = array())
93
+	{
94
+		$other_model_obj = $this->get_other_model()->ensure_is_obj($other_obj_or_id, true);
95
+		//find the field on the other model which is a foreign key to this model
96
+		$fk_field_on_other_model = $this->get_other_model()->get_foreign_key_to($this->get_this_model()->get_this_model_name());
97
+		//set that field on the other model to this model's ID
98
+		$other_model_obj->set($fk_field_on_other_model->get_name(), null, true);
99
+		$other_model_obj->set($this->get_other_model()->get_field_containing_related_model_name()->get_name(), null,
100
+			true);
101
+		$other_model_obj->save();
102
+		return $other_model_obj;
103
+	}
104 104
 }
Please login to merge, or discard this patch.
Spacing   +4 added lines, -4 removed lines patch added patch discarded remove patch
@@ -4,7 +4,7 @@  discard block
 block discarded – undo
4 4
 /*
5 5
  *
6 6
  */
7
-require_once(EE_MODELS . 'relations/EE_Model_Relation_Base.php');
7
+require_once(EE_MODELS.'relations/EE_Model_Relation_Base.php');
8 8
 
9 9
 
10 10
 /**
@@ -37,9 +37,9 @@  discard block
 block discarded – undo
37 37
         $this_table_pk_field   = $this->get_this_model()->get_primary_key_field();
38 38
         $other_table_fk_field  = $this->get_other_model()->get_foreign_key_to($this->get_this_model()->get_this_model_name());
39 39
         $pk_table_alias        = EE_Model_Parser::extract_table_alias_model_relation_chain_prefix($model_relation_chain,
40
-                $this->get_this_model()->get_this_model_name()) . $this_table_pk_field->get_table_alias();
40
+                $this->get_this_model()->get_this_model_name()).$this_table_pk_field->get_table_alias();
41 41
         $fk_table_alias        = EE_Model_Parser::extract_table_alias_model_relation_chain_prefix($model_relation_chain,
42
-                $this->get_other_model()->get_this_model_name()) . $other_table_fk_field->get_table_alias();
42
+                $this->get_other_model()->get_this_model_name()).$other_table_fk_field->get_table_alias();
43 43
         $fk_table              = $this->get_other_model()->get_table_for_alias($fk_table_alias);
44 44
         $field_with_model_name = $this->get_other_model()->get_field_containing_related_model_name();
45 45
 
@@ -48,7 +48,7 @@  discard block
 block discarded – undo
48 48
                 $other_table_fk_field->get_table_column(),
49 49
                 $pk_table_alias,
50 50
                 $this_table_pk_field->get_table_column(),
51
-                $fk_table_alias . '.' . $field_with_model_name->get_table_column() . "='" . $this->get_this_model()->get_this_model_name() . "'")
51
+                $fk_table_alias.'.'.$field_with_model_name->get_table_column()."='".$this->get_this_model()->get_this_model_name()."'")
52 52
                . $this->get_other_model()->_construct_internal_join_to_table_with_alias($fk_table_alias);
53 53
     }
54 54
 
Please login to merge, or discard this patch.
core/db_models/relations/EE_Has_Many_Revision_Relation.php 2 patches
Indentation   +295 added lines, -295 removed lines patch added patch discarded remove patch
@@ -14,303 +14,303 @@
 block discarded – undo
14 14
 {
15 15
 
16 16
 
17
-    /**
18
-     * The Foreign key on the model that acts as the PRIMARY KEY used in special autosave handling where we query for
19
-     * autosaves (or the Foreign key on other models in relations pointing to this models primary key which is this
20
-     * value).  The _primary_cpt_field is what is equivalent to the post_id field on a cpt join.
21
-     *
22
-     * @var string
23
-     */
24
-    private $_primary_cpt_field;
25
-
26
-
27
-    /**
28
-     * This is what field serves as the "parent" column that is linked with whatever the main model's calling this
29
-     * relation has as a primary key.  In other words EEM_Event has 'Datetime' => new
30
-     * EE_Has_Many_Revision_Relation('EVT_ID', 'DTT_parent').  That means that in the EEM_Datetime model the
31
-     * 'DTT_Parent' field is related to the 'DTT_ID' primary key field (in the same model) because 'DTT_ID' is the
32
-     * primary key in the other model (EEM_Datetime).
33
-     *
34
-     * @var string
35
-     */
36
-    private $_parent_pk_relation_field;
37
-
38
-
39
-    /**
40
-     * Object representing the relationship between two models. Has_Many_Relations are where the OTHER model has the
41
-     * foreign key this model. IE, there can be many other model objects related to one of this model's objects (but
42
-     * NOT through a JOIN table, which is the case for EE_HABTM_Relations). This knows how to join the models, get
43
-     * related models across the relation, and add-and-remove the relationships.
44
-     *
45
-     * @param string  $primary_cpt_field             See property description for details
46
-     * @param string  $parent_pk_relation_field      This is the field that is "connected" to the $primary_cpt_field.
47
-     *                                               See property desc for details.
48
-     * @param boolean $block_deletes                 For this type of relation, we block by default. If there are
49
-     *                                               related models across this relation, block (prevent and add an
50
-     *                                               error) the deletion of this model
51
-     * @param string  $blocking_delete_error_message a customized error message on blocking deletes instead of the
52
-     *                                               default
53
-     */
54
-    public function __construct(
55
-        $primary_cpt_field,
56
-        $parent_pk_relation_field,
57
-        $block_deletes = true,
58
-        $blocking_delete_error_message = null
59
-    ) {
60
-        $this->_primary_cpt_field        = $primary_cpt_field;
61
-        $this->_parent_pk_relation_field = $parent_pk_relation_field;
62
-        parent::__construct($block_deletes, $blocking_delete_error_message);
63
-    }
64
-
65
-
66
-    /**
67
-     * Sets the other model object's foreign key to this model object's primary key. Feel free to do this manually if
68
-     * you like.
69
-     *
70
-     * @param EE_Base_Class|int $this_obj_or_id
71
-     * @param EE_Base_Class|int $other_obj_or_id
72
-     * @param array             $extra_join_model_fields_n_values
73
-     * @return \EE_Base_Class
74
-     * @throws \EE_Error
75
-     */
76
-    public function add_relation_to($this_obj_or_id, $other_obj_or_id, $extra_join_model_fields_n_values = array())
77
-    {
78
-        $this_model_obj  = $this->get_this_model()->ensure_is_obj($this_obj_or_id, true);
79
-        $other_model_obj = $this->get_other_model()->ensure_is_obj($other_obj_or_id);
80
-
81
-        //handle possible revisions
82
-        $other_model_obj = $this->_check_for_revision($this_model_obj, $other_model_obj);
83
-
84
-        //if is array, then we've already done the add_relation so let's get out
85
-        if (is_array($other_model_obj)) {
86
-            return $other_model_obj[0];
87
-        }
88
-        //find the field on the other model which is a foreign key to this model
89
-        $fk_field_on_other_model = $this->get_other_model()->get_foreign_key_to($this->get_this_model()->get_this_model_name());
90
-        //set that field on the other model to this model's ID
91
-        $other_model_obj->set($fk_field_on_other_model->get_name(), $this_model_obj->ID());
92
-        $other_model_obj->save();
93
-        return $other_model_obj;
94
-    }
95
-
96
-
97
-    /**
98
-     * Sets the other model object's foreign key to its default, instead of pointing to this model object
99
-     *
100
-     * @param EE_Base_Class|int $this_obj_or_id
101
-     * @param EE_Base_Class|int $other_obj_or_id
102
-     * @param array             $where_query
103
-     * @return \EE_Base_Class
104
-     * @throws \EE_Error
105
-     */
106
-    public function remove_relation_to($this_obj_or_id, $other_obj_or_id, $where_query = array())
107
-    {
108
-        $this_model_obj  = $this->get_this_model()->ensure_is_obj($this_obj_or_id);
109
-        $other_model_obj = $this->get_other_model()->ensure_is_obj($other_obj_or_id);
110
-        //handle possible revisions
111
-        $other_model_obj = $this->_check_for_revision($this_model_obj, $other_model_obj, true);
112
-
113
-
114
-        //if is array, then we've already done the add_relation so let's get out
115
-        if (is_array($other_model_obj)) {
116
-            return $other_model_obj[0];
117
-        }
118
-
119
-        //find the field on the other model which is a foreign key to this model
120
-        $fk_field_on_other_model = $this->get_other_model()->get_foreign_key_to($this->get_this_model()->get_this_model_name());
121
-
122
-
123
-        //set that field on the other model to this model's ID
124
-        if ($this->_blocking_delete) {
125
-            $other_model_obj->set($fk_field_on_other_model->get_name(), null, true);
126
-            $other_model_obj->save();
127
-        } else {
128
-            $other_model_obj->delete();
129
-            $other_model_obj->set($fk_field_on_other_model->get_name(), null, true);
130
-            return $other_model_obj;
131
-        }
132
-        return $other_model_obj;
133
-    }
134
-
135
-
136
-    /**
137
-     * This is identical to EE_Model_Relation->get_all_related() except we're going handle special autosave conditions
138
-     * in here.
139
-     *
140
-     * @param  EE_Base_Class|int $model_object_or_id
141
-     * @param  array             $query_params                            like EEM_Base::get_all's $query_params
142
-     * @param  boolean           $values_already_prepared_by_model_object @deprecated since 4.8.1
143
-     * @return EE_Base_Class[]
144
-     * @throws \EE_Error
145
-     */
146
-    public function get_all_related(
147
-        $model_object_or_id,
148
-        $query_params = array(),
149
-        $values_already_prepared_by_model_object = false
150
-    ) {
151
-        if ($values_already_prepared_by_model_object !== false) {
152
-            EE_Error::doing_it_wrong('EE_Model_Relation_Base::get_all_related',
153
-                __('The argument $values_already_prepared_by_model_object is no longer used.', 'event_espresso'),
154
-                '4.8.1');
155
-        }
156
-
157
-        //if this is an autosave then we're going to get things differently
158
-        if (defined('DOING_AUTOSAVE') && DOING_AUTOSAVE) {
159
-            return $this->_do_autosave_get_all($model_object_or_id, $query_params);
160
-        }
161
-
162
-        return parent::get_all_related($model_object_or_id, $query_params);
163
-    }
164
-
165
-
166
-    /**
167
-     * If we're in the midst of an autosave then we're going to do things a bit differently than the usual
168
-     * get_all_related (commenting within).  For description of params see the get_all_related() comments
169
-     *
170
-     * @access protected
171
-     * @param      $model_object_or_id
172
-     * @param      $query_params
173
-     * @param bool $deprecated
174
-     * @return \EE_Base_Class[]
175
-     * @throws \EE_Error
176
-     */
177
-    protected function _do_autosave_get_all($model_object_or_id, $query_params, $deprecated = false)
178
-    {
179
-
180
-        //first we check if the post_id for the incoming query is for an autosave.  If it isn't that's what we want!
181
-        $model_object_id = $this->_get_model_object_id($model_object_or_id);
182
-
183
-        $autosave  = wp_get_post_autosave($model_object_id);
184
-        $id_to_use = $autosave ? $autosave->ID : $model_object_id;
185
-
186
-        $autosave_relations = parent::get_all_related($id_to_use, $query_params);
187
-        $parent_ids         = $parents = array();
188
-        $return_objs        = array();
189
-
190
-        //k this is where things differ because NOW what we're going to do is get the PARENTS for the get all related (and we'll also start setting up the return_objs array containing related that DON'T have parent ids, for those that DON'T have parents to merge with our returned objects);
191
-        foreach ($autosave_relations as $a_r) {
192
-            $pid = $a_r->parent();
193
-            if (! empty($pid)) {
194
-                $parent_ids[] = $pid;
195
-            } else {
196
-                $return_objs[] = $a_r;
197
-            }
198
-        }
199
-
200
-        //we have to make sure we also include the ORIGINAL values
201
-        $originals = parent::get_all_related($model_object_or_id, $query_params);
202
-
203
-        //merge $originals with $return_objs
204
-        if ($originals) {
205
-            $return_objs = array_merge($originals, $return_objs);
206
-        }
207
-
208
-        //now we setup the query to get all the parents
209
-        if (! empty($parent_ids)) {
210
-            $query_param_where_this_model_pk                  = $this->get_this_model()->get_this_model_name() . "." . $this->get_this_model()->get_primary_key_field()->get_name();
211
-            $query_param[0][$query_param_where_this_model_pk] = array('IN', $parent_ids);
212
-            $parents                                          = $this->get_other_model()->get_all($query_params);
213
-        }
214
-
215
-        //var_dump($parents);
216
-
217
-
218
-        //now merge parents with our current $return_objs and send back
219
-        return array_merge($parents, $return_objs);
220
-    }
221
-
222
-
223
-    /**
224
-     * Basically this method gets called to verify if the incoming object needs to be manipulated somewhat because it
225
-     * is a revision save.  If so, then we change things before sending back.  We also do verifications when this IS
226
-     * NOT an revision because we always need to make sure that the autosave/revision has parent recorded (which is
227
-     * sometime delayed if the object is created/saved first by the autosave)
228
-     *
229
-     * @param  EE_Base_Class $this_obj
230
-     * @param  EE_Base_Class $other_obj
231
-     * @param  boolean       $remove_relation Indicates whether we're doing a remove_relation or add_relation.
232
-     * @return EE_Base_Class. ($other_obj);
233
-     * @throws \EE_Error
234
-     */
235
-    protected function _check_for_revision($this_obj, $other_obj, $remove_relation = false)
236
-    {
237
-        $pk_on_related_model = $this->get_other_model()->get_primary_key_field()->get_name();
238
-        //now we need to determine if we're in a WP revision save cause if we are we need to do some special handling
239
-        if ($this_obj->post_type() === 'revision') {
240
-            //first if $other_obj fk = this_obj pk then we know that this is a pk object, let's make sure there is a matching set for the autosave if there is then we save over it, if there isn't then we need to create a new one.
241
-            $parent_evt_id = $this_obj->parent();
242
-            /*var_dump($parent_evt_id);
17
+	/**
18
+	 * The Foreign key on the model that acts as the PRIMARY KEY used in special autosave handling where we query for
19
+	 * autosaves (or the Foreign key on other models in relations pointing to this models primary key which is this
20
+	 * value).  The _primary_cpt_field is what is equivalent to the post_id field on a cpt join.
21
+	 *
22
+	 * @var string
23
+	 */
24
+	private $_primary_cpt_field;
25
+
26
+
27
+	/**
28
+	 * This is what field serves as the "parent" column that is linked with whatever the main model's calling this
29
+	 * relation has as a primary key.  In other words EEM_Event has 'Datetime' => new
30
+	 * EE_Has_Many_Revision_Relation('EVT_ID', 'DTT_parent').  That means that in the EEM_Datetime model the
31
+	 * 'DTT_Parent' field is related to the 'DTT_ID' primary key field (in the same model) because 'DTT_ID' is the
32
+	 * primary key in the other model (EEM_Datetime).
33
+	 *
34
+	 * @var string
35
+	 */
36
+	private $_parent_pk_relation_field;
37
+
38
+
39
+	/**
40
+	 * Object representing the relationship between two models. Has_Many_Relations are where the OTHER model has the
41
+	 * foreign key this model. IE, there can be many other model objects related to one of this model's objects (but
42
+	 * NOT through a JOIN table, which is the case for EE_HABTM_Relations). This knows how to join the models, get
43
+	 * related models across the relation, and add-and-remove the relationships.
44
+	 *
45
+	 * @param string  $primary_cpt_field             See property description for details
46
+	 * @param string  $parent_pk_relation_field      This is the field that is "connected" to the $primary_cpt_field.
47
+	 *                                               See property desc for details.
48
+	 * @param boolean $block_deletes                 For this type of relation, we block by default. If there are
49
+	 *                                               related models across this relation, block (prevent and add an
50
+	 *                                               error) the deletion of this model
51
+	 * @param string  $blocking_delete_error_message a customized error message on blocking deletes instead of the
52
+	 *                                               default
53
+	 */
54
+	public function __construct(
55
+		$primary_cpt_field,
56
+		$parent_pk_relation_field,
57
+		$block_deletes = true,
58
+		$blocking_delete_error_message = null
59
+	) {
60
+		$this->_primary_cpt_field        = $primary_cpt_field;
61
+		$this->_parent_pk_relation_field = $parent_pk_relation_field;
62
+		parent::__construct($block_deletes, $blocking_delete_error_message);
63
+	}
64
+
65
+
66
+	/**
67
+	 * Sets the other model object's foreign key to this model object's primary key. Feel free to do this manually if
68
+	 * you like.
69
+	 *
70
+	 * @param EE_Base_Class|int $this_obj_or_id
71
+	 * @param EE_Base_Class|int $other_obj_or_id
72
+	 * @param array             $extra_join_model_fields_n_values
73
+	 * @return \EE_Base_Class
74
+	 * @throws \EE_Error
75
+	 */
76
+	public function add_relation_to($this_obj_or_id, $other_obj_or_id, $extra_join_model_fields_n_values = array())
77
+	{
78
+		$this_model_obj  = $this->get_this_model()->ensure_is_obj($this_obj_or_id, true);
79
+		$other_model_obj = $this->get_other_model()->ensure_is_obj($other_obj_or_id);
80
+
81
+		//handle possible revisions
82
+		$other_model_obj = $this->_check_for_revision($this_model_obj, $other_model_obj);
83
+
84
+		//if is array, then we've already done the add_relation so let's get out
85
+		if (is_array($other_model_obj)) {
86
+			return $other_model_obj[0];
87
+		}
88
+		//find the field on the other model which is a foreign key to this model
89
+		$fk_field_on_other_model = $this->get_other_model()->get_foreign_key_to($this->get_this_model()->get_this_model_name());
90
+		//set that field on the other model to this model's ID
91
+		$other_model_obj->set($fk_field_on_other_model->get_name(), $this_model_obj->ID());
92
+		$other_model_obj->save();
93
+		return $other_model_obj;
94
+	}
95
+
96
+
97
+	/**
98
+	 * Sets the other model object's foreign key to its default, instead of pointing to this model object
99
+	 *
100
+	 * @param EE_Base_Class|int $this_obj_or_id
101
+	 * @param EE_Base_Class|int $other_obj_or_id
102
+	 * @param array             $where_query
103
+	 * @return \EE_Base_Class
104
+	 * @throws \EE_Error
105
+	 */
106
+	public function remove_relation_to($this_obj_or_id, $other_obj_or_id, $where_query = array())
107
+	{
108
+		$this_model_obj  = $this->get_this_model()->ensure_is_obj($this_obj_or_id);
109
+		$other_model_obj = $this->get_other_model()->ensure_is_obj($other_obj_or_id);
110
+		//handle possible revisions
111
+		$other_model_obj = $this->_check_for_revision($this_model_obj, $other_model_obj, true);
112
+
113
+
114
+		//if is array, then we've already done the add_relation so let's get out
115
+		if (is_array($other_model_obj)) {
116
+			return $other_model_obj[0];
117
+		}
118
+
119
+		//find the field on the other model which is a foreign key to this model
120
+		$fk_field_on_other_model = $this->get_other_model()->get_foreign_key_to($this->get_this_model()->get_this_model_name());
121
+
122
+
123
+		//set that field on the other model to this model's ID
124
+		if ($this->_blocking_delete) {
125
+			$other_model_obj->set($fk_field_on_other_model->get_name(), null, true);
126
+			$other_model_obj->save();
127
+		} else {
128
+			$other_model_obj->delete();
129
+			$other_model_obj->set($fk_field_on_other_model->get_name(), null, true);
130
+			return $other_model_obj;
131
+		}
132
+		return $other_model_obj;
133
+	}
134
+
135
+
136
+	/**
137
+	 * This is identical to EE_Model_Relation->get_all_related() except we're going handle special autosave conditions
138
+	 * in here.
139
+	 *
140
+	 * @param  EE_Base_Class|int $model_object_or_id
141
+	 * @param  array             $query_params                            like EEM_Base::get_all's $query_params
142
+	 * @param  boolean           $values_already_prepared_by_model_object @deprecated since 4.8.1
143
+	 * @return EE_Base_Class[]
144
+	 * @throws \EE_Error
145
+	 */
146
+	public function get_all_related(
147
+		$model_object_or_id,
148
+		$query_params = array(),
149
+		$values_already_prepared_by_model_object = false
150
+	) {
151
+		if ($values_already_prepared_by_model_object !== false) {
152
+			EE_Error::doing_it_wrong('EE_Model_Relation_Base::get_all_related',
153
+				__('The argument $values_already_prepared_by_model_object is no longer used.', 'event_espresso'),
154
+				'4.8.1');
155
+		}
156
+
157
+		//if this is an autosave then we're going to get things differently
158
+		if (defined('DOING_AUTOSAVE') && DOING_AUTOSAVE) {
159
+			return $this->_do_autosave_get_all($model_object_or_id, $query_params);
160
+		}
161
+
162
+		return parent::get_all_related($model_object_or_id, $query_params);
163
+	}
164
+
165
+
166
+	/**
167
+	 * If we're in the midst of an autosave then we're going to do things a bit differently than the usual
168
+	 * get_all_related (commenting within).  For description of params see the get_all_related() comments
169
+	 *
170
+	 * @access protected
171
+	 * @param      $model_object_or_id
172
+	 * @param      $query_params
173
+	 * @param bool $deprecated
174
+	 * @return \EE_Base_Class[]
175
+	 * @throws \EE_Error
176
+	 */
177
+	protected function _do_autosave_get_all($model_object_or_id, $query_params, $deprecated = false)
178
+	{
179
+
180
+		//first we check if the post_id for the incoming query is for an autosave.  If it isn't that's what we want!
181
+		$model_object_id = $this->_get_model_object_id($model_object_or_id);
182
+
183
+		$autosave  = wp_get_post_autosave($model_object_id);
184
+		$id_to_use = $autosave ? $autosave->ID : $model_object_id;
185
+
186
+		$autosave_relations = parent::get_all_related($id_to_use, $query_params);
187
+		$parent_ids         = $parents = array();
188
+		$return_objs        = array();
189
+
190
+		//k this is where things differ because NOW what we're going to do is get the PARENTS for the get all related (and we'll also start setting up the return_objs array containing related that DON'T have parent ids, for those that DON'T have parents to merge with our returned objects);
191
+		foreach ($autosave_relations as $a_r) {
192
+			$pid = $a_r->parent();
193
+			if (! empty($pid)) {
194
+				$parent_ids[] = $pid;
195
+			} else {
196
+				$return_objs[] = $a_r;
197
+			}
198
+		}
199
+
200
+		//we have to make sure we also include the ORIGINAL values
201
+		$originals = parent::get_all_related($model_object_or_id, $query_params);
202
+
203
+		//merge $originals with $return_objs
204
+		if ($originals) {
205
+			$return_objs = array_merge($originals, $return_objs);
206
+		}
207
+
208
+		//now we setup the query to get all the parents
209
+		if (! empty($parent_ids)) {
210
+			$query_param_where_this_model_pk                  = $this->get_this_model()->get_this_model_name() . "." . $this->get_this_model()->get_primary_key_field()->get_name();
211
+			$query_param[0][$query_param_where_this_model_pk] = array('IN', $parent_ids);
212
+			$parents                                          = $this->get_other_model()->get_all($query_params);
213
+		}
214
+
215
+		//var_dump($parents);
216
+
217
+
218
+		//now merge parents with our current $return_objs and send back
219
+		return array_merge($parents, $return_objs);
220
+	}
221
+
222
+
223
+	/**
224
+	 * Basically this method gets called to verify if the incoming object needs to be manipulated somewhat because it
225
+	 * is a revision save.  If so, then we change things before sending back.  We also do verifications when this IS
226
+	 * NOT an revision because we always need to make sure that the autosave/revision has parent recorded (which is
227
+	 * sometime delayed if the object is created/saved first by the autosave)
228
+	 *
229
+	 * @param  EE_Base_Class $this_obj
230
+	 * @param  EE_Base_Class $other_obj
231
+	 * @param  boolean       $remove_relation Indicates whether we're doing a remove_relation or add_relation.
232
+	 * @return EE_Base_Class. ($other_obj);
233
+	 * @throws \EE_Error
234
+	 */
235
+	protected function _check_for_revision($this_obj, $other_obj, $remove_relation = false)
236
+	{
237
+		$pk_on_related_model = $this->get_other_model()->get_primary_key_field()->get_name();
238
+		//now we need to determine if we're in a WP revision save cause if we are we need to do some special handling
239
+		if ($this_obj->post_type() === 'revision') {
240
+			//first if $other_obj fk = this_obj pk then we know that this is a pk object, let's make sure there is a matching set for the autosave if there is then we save over it, if there isn't then we need to create a new one.
241
+			$parent_evt_id = $this_obj->parent();
242
+			/*var_dump($parent_evt_id);
243 243
             var_dump($this_obj);
244 244
             var_dump($other_obj);/**/
245 245
 
246
-            if (! empty($parent_evt_id) && $parent_evt_id == $other_obj->get($this->_primary_cpt_field)) {
247
-                //let's do query on this objects model to see if the incoming pk value on the obj matches any parents in this objects table.
248
-                $has_parent_obj = $this->get_other_model()->get_one(array(
249
-                    array(
250
-                        $this->_parent_pk_relation_field => $other_obj->ID(),
251
-                        $this->_primary_cpt_field        => $this_obj->ID(),
252
-                    ),
253
-                ));
254
-
255
-                if ($has_parent_obj) {
256
-                    //this makes sure the update on the current obj happens to the revision's row NOT the parent row.
257
-
258
-                    $other_obj->set($this->_parent_pk_relation_field, $other_obj->ID());
259
-                    $other_obj->set($pk_on_related_model, $has_parent_obj->ID());
260
-                    $other_obj->set($this->_primary_cpt_field, $this_obj->ID());
261
-
262
-                    if (! $remove_relation) {
263
-                        $other_obj->save();
264
-                        return array($other_obj);
265
-                    } elseif ($remove_relation && ! $this->_blocking_delete) {
266
-                        $other_obj->delete();
267
-                        $other_obj->set($this->_parent_pk_relation_field, null, true);
268
-                        return array($other_obj);
269
-                    }
270
-
271
-                } else {
272
-                    $other_obj->set($this->_parent_pk_relation_field, $other_obj->ID());
273
-                    $other_obj->set($this->_primary_cpt_field, $this_obj->ID());
274
-                    $other_obj->set($pk_on_related_model, null,
275
-                        true); //ensure we create a new row for the autosave with parent id the same as the incoming ID.
276
-                    $other_obj->save(); //make sure we insert.
277
-                    return array($other_obj);
278
-                }
279
-            }
280
-
281
-            //var_dump('what makes it here');
282
-            //var_dump($other_obj);
283
-            //the next possible condition is that the incoming other_model obj has a NULL pk which means it just gets saved (which in turn creates it)
284
-
285
-            //the last possible condition on a revision is that the incoming other_model object has a fk that == $this_obj pk which means we just return the $other obj and let it save as normal so we see the return at the bottom of this method.
286
-
287
-        } else {
288
-
289
-            //we only need to do the below IF this is not a remove relation
290
-            if (! $remove_relation) {
291
-                //okay this is is a normal update/save/remove so, let's make sure the other object is not a revision of the current object.
292
-                //the other object will likely NOT have the correct fk on it (which is the primary_cpt_field_mame) so we must retrieve from the db to get that first.
293
-                $existing_other_obj    = $this->get_other_model()->get_one_by_ID($other_obj->ID());
294
-                $potential_revision_id = is_object($existing_other_obj) ? $existing_other_obj->get($this->_primary_cpt_field) : null;
295
-
296
-                if ($parent_this_obj_id = wp_is_post_revision($potential_revision_id)) {
297
-                    //yes the OTHER object is linked to the revision of the parent, not the parent itself. That means we need to make the other_object an attachment of this_obj and then duplicate other_obj for the revision.
298
-                    $other_obj->set($this->_primary_cpt_field, $this_obj->ID());
299
-                    $other_obj->save();
300
-
301
-                    //now create a new other_obj and fill with details from existing object
302
-                    $new_obj = $other_obj;
303
-                    $new_obj->set($this->_primary_cpt_field, $potential_revision_id);
304
-                    $new_obj->set($this->_parent_pk_relation_field, $other_obj->ID());
305
-                    $new_obj->set($pk_on_related_model, null);
306
-                    $new_obj->save();
307
-                    return array($new_obj);
308
-                }
309
-
310
-            }
311
-        }
312
-
313
-        return $other_obj;
314
-    }
246
+			if (! empty($parent_evt_id) && $parent_evt_id == $other_obj->get($this->_primary_cpt_field)) {
247
+				//let's do query on this objects model to see if the incoming pk value on the obj matches any parents in this objects table.
248
+				$has_parent_obj = $this->get_other_model()->get_one(array(
249
+					array(
250
+						$this->_parent_pk_relation_field => $other_obj->ID(),
251
+						$this->_primary_cpt_field        => $this_obj->ID(),
252
+					),
253
+				));
254
+
255
+				if ($has_parent_obj) {
256
+					//this makes sure the update on the current obj happens to the revision's row NOT the parent row.
257
+
258
+					$other_obj->set($this->_parent_pk_relation_field, $other_obj->ID());
259
+					$other_obj->set($pk_on_related_model, $has_parent_obj->ID());
260
+					$other_obj->set($this->_primary_cpt_field, $this_obj->ID());
261
+
262
+					if (! $remove_relation) {
263
+						$other_obj->save();
264
+						return array($other_obj);
265
+					} elseif ($remove_relation && ! $this->_blocking_delete) {
266
+						$other_obj->delete();
267
+						$other_obj->set($this->_parent_pk_relation_field, null, true);
268
+						return array($other_obj);
269
+					}
270
+
271
+				} else {
272
+					$other_obj->set($this->_parent_pk_relation_field, $other_obj->ID());
273
+					$other_obj->set($this->_primary_cpt_field, $this_obj->ID());
274
+					$other_obj->set($pk_on_related_model, null,
275
+						true); //ensure we create a new row for the autosave with parent id the same as the incoming ID.
276
+					$other_obj->save(); //make sure we insert.
277
+					return array($other_obj);
278
+				}
279
+			}
280
+
281
+			//var_dump('what makes it here');
282
+			//var_dump($other_obj);
283
+			//the next possible condition is that the incoming other_model obj has a NULL pk which means it just gets saved (which in turn creates it)
284
+
285
+			//the last possible condition on a revision is that the incoming other_model object has a fk that == $this_obj pk which means we just return the $other obj and let it save as normal so we see the return at the bottom of this method.
286
+
287
+		} else {
288
+
289
+			//we only need to do the below IF this is not a remove relation
290
+			if (! $remove_relation) {
291
+				//okay this is is a normal update/save/remove so, let's make sure the other object is not a revision of the current object.
292
+				//the other object will likely NOT have the correct fk on it (which is the primary_cpt_field_mame) so we must retrieve from the db to get that first.
293
+				$existing_other_obj    = $this->get_other_model()->get_one_by_ID($other_obj->ID());
294
+				$potential_revision_id = is_object($existing_other_obj) ? $existing_other_obj->get($this->_primary_cpt_field) : null;
295
+
296
+				if ($parent_this_obj_id = wp_is_post_revision($potential_revision_id)) {
297
+					//yes the OTHER object is linked to the revision of the parent, not the parent itself. That means we need to make the other_object an attachment of this_obj and then duplicate other_obj for the revision.
298
+					$other_obj->set($this->_primary_cpt_field, $this_obj->ID());
299
+					$other_obj->save();
300
+
301
+					//now create a new other_obj and fill with details from existing object
302
+					$new_obj = $other_obj;
303
+					$new_obj->set($this->_primary_cpt_field, $potential_revision_id);
304
+					$new_obj->set($this->_parent_pk_relation_field, $other_obj->ID());
305
+					$new_obj->set($pk_on_related_model, null);
306
+					$new_obj->save();
307
+					return array($new_obj);
308
+				}
309
+
310
+			}
311
+		}
312
+
313
+		return $other_obj;
314
+	}
315 315
 
316 316
 }
317 317
\ No newline at end of file
Please login to merge, or discard this patch.
Spacing   +7 added lines, -7 removed lines patch added patch discarded remove patch
@@ -1,5 +1,5 @@  discard block
 block discarded – undo
1 1
 <?php
2
-require_once(EE_MODELS . 'relations/EE_Has_Many_Relation.php');
2
+require_once(EE_MODELS.'relations/EE_Has_Many_Relation.php');
3 3
 
4 4
 
5 5
 /**
@@ -190,7 +190,7 @@  discard block
 block discarded – undo
190 190
         //k this is where things differ because NOW what we're going to do is get the PARENTS for the get all related (and we'll also start setting up the return_objs array containing related that DON'T have parent ids, for those that DON'T have parents to merge with our returned objects);
191 191
         foreach ($autosave_relations as $a_r) {
192 192
             $pid = $a_r->parent();
193
-            if (! empty($pid)) {
193
+            if ( ! empty($pid)) {
194 194
                 $parent_ids[] = $pid;
195 195
             } else {
196 196
                 $return_objs[] = $a_r;
@@ -206,8 +206,8 @@  discard block
 block discarded – undo
206 206
         }
207 207
 
208 208
         //now we setup the query to get all the parents
209
-        if (! empty($parent_ids)) {
210
-            $query_param_where_this_model_pk                  = $this->get_this_model()->get_this_model_name() . "." . $this->get_this_model()->get_primary_key_field()->get_name();
209
+        if ( ! empty($parent_ids)) {
210
+            $query_param_where_this_model_pk                  = $this->get_this_model()->get_this_model_name().".".$this->get_this_model()->get_primary_key_field()->get_name();
211 211
             $query_param[0][$query_param_where_this_model_pk] = array('IN', $parent_ids);
212 212
             $parents                                          = $this->get_other_model()->get_all($query_params);
213 213
         }
@@ -243,7 +243,7 @@  discard block
 block discarded – undo
243 243
             var_dump($this_obj);
244 244
             var_dump($other_obj);/**/
245 245
 
246
-            if (! empty($parent_evt_id) && $parent_evt_id == $other_obj->get($this->_primary_cpt_field)) {
246
+            if ( ! empty($parent_evt_id) && $parent_evt_id == $other_obj->get($this->_primary_cpt_field)) {
247 247
                 //let's do query on this objects model to see if the incoming pk value on the obj matches any parents in this objects table.
248 248
                 $has_parent_obj = $this->get_other_model()->get_one(array(
249 249
                     array(
@@ -259,7 +259,7 @@  discard block
 block discarded – undo
259 259
                     $other_obj->set($pk_on_related_model, $has_parent_obj->ID());
260 260
                     $other_obj->set($this->_primary_cpt_field, $this_obj->ID());
261 261
 
262
-                    if (! $remove_relation) {
262
+                    if ( ! $remove_relation) {
263 263
                         $other_obj->save();
264 264
                         return array($other_obj);
265 265
                     } elseif ($remove_relation && ! $this->_blocking_delete) {
@@ -287,7 +287,7 @@  discard block
 block discarded – undo
287 287
         } else {
288 288
 
289 289
             //we only need to do the below IF this is not a remove relation
290
-            if (! $remove_relation) {
290
+            if ( ! $remove_relation) {
291 291
                 //okay this is is a normal update/save/remove so, let's make sure the other object is not a revision of the current object.
292 292
                 //the other object will likely NOT have the correct fk on it (which is the primary_cpt_field_mame) so we must retrieve from the db to get that first.
293 293
                 $existing_other_obj    = $this->get_other_model()->get_one_by_ID($other_obj->ID());
Please login to merge, or discard this patch.
core/db_models/relations/EE_HABTM_Any_Relation.php 2 patches
Indentation   +235 added lines, -235 removed lines patch added patch discarded remove patch
@@ -10,264 +10,264 @@
 block discarded – undo
10 10
  */
11 11
 class EE_HABTM_Any_Relation extends EE_HABTM_Relation
12 12
 {
13
-    /**
14
-     * @var string
15
-     */
16
-    protected $_alphabetically_first_model_name;
13
+	/**
14
+	 * @var string
15
+	 */
16
+	protected $_alphabetically_first_model_name;
17 17
 
18
-    /**
19
-     * Object representing the relationship between two models. HasAndBelongsToMany relations always use a join-table
20
-     * (and an ee joining-model.) This knows how to join the models,
21
-     * get related models across the relation, and add-and-remove the relationships.
22
-     *
23
-     * @param boolean $block_deletes                 for this type of relation, we block by default for now. if there
24
-     *                                               are related models across this relation, block (prevent and add an
25
-     *                                               error) the deletion of this model
26
-     * @param string  $blocking_delete_error_message a customized error message on blocking deletes instead of the
27
-     *                                               default
28
-     */
29
-    public function __construct($block_deletes = true, $blocking_delete_error_message = '')
30
-    {
31
-        parent::__construct('Extra_Join', $block_deletes, $blocking_delete_error_message);
32
-    }
18
+	/**
19
+	 * Object representing the relationship between two models. HasAndBelongsToMany relations always use a join-table
20
+	 * (and an ee joining-model.) This knows how to join the models,
21
+	 * get related models across the relation, and add-and-remove the relationships.
22
+	 *
23
+	 * @param boolean $block_deletes                 for this type of relation, we block by default for now. if there
24
+	 *                                               are related models across this relation, block (prevent and add an
25
+	 *                                               error) the deletion of this model
26
+	 * @param string  $blocking_delete_error_message a customized error message on blocking deletes instead of the
27
+	 *                                               default
28
+	 */
29
+	public function __construct($block_deletes = true, $blocking_delete_error_message = '')
30
+	{
31
+		parent::__construct('Extra_Join', $block_deletes, $blocking_delete_error_message);
32
+	}
33 33
 
34 34
 
35
-    /**
36
-     * @param $this_model_name
37
-     * @param $other_model_name
38
-     * @throws EE_Error
39
-     */
40
-    public function _construct_finalize_set_models($this_model_name, $other_model_name)
41
-    {
42
-        if ($this_model_name < $other_model_name) {
43
-            $this->_alphabetically_first_model_name = $this_model_name;
44
-        } else {
45
-            $this->_alphabetically_first_model_name = $other_model_name;
46
-        }
47
-        parent::_construct_finalize_set_models($this_model_name, $other_model_name);
48
-    }
35
+	/**
36
+	 * @param $this_model_name
37
+	 * @param $other_model_name
38
+	 * @throws EE_Error
39
+	 */
40
+	public function _construct_finalize_set_models($this_model_name, $other_model_name)
41
+	{
42
+		if ($this_model_name < $other_model_name) {
43
+			$this->_alphabetically_first_model_name = $this_model_name;
44
+		} else {
45
+			$this->_alphabetically_first_model_name = $other_model_name;
46
+		}
47
+		parent::_construct_finalize_set_models($this_model_name, $other_model_name);
48
+	}
49 49
 
50 50
 
51
-    /**
52
-     * @param string $model_name
53
-     * @param string $id_or_name_field should be the string 'ID' or 'name' only
54
-     * @return EE_Model_Field_Base
55
-     * @throws \EE_Error
56
-     */
57
-    public function get_join_table_fk_field_to($model_name, $id_or_name_field)
58
-    {
59
-        $order = null;
60
-        if ($model_name === $this->_alphabetically_first_model_name) {
61
-            $order = 'first';
62
-        } else {
63
-            $order = 'second';
64
-        }
65
-        return $this->get_join_model()->field_settings_for('EXJ_' . $order . '_model_' . $id_or_name_field);
66
-    }
51
+	/**
52
+	 * @param string $model_name
53
+	 * @param string $id_or_name_field should be the string 'ID' or 'name' only
54
+	 * @return EE_Model_Field_Base
55
+	 * @throws \EE_Error
56
+	 */
57
+	public function get_join_table_fk_field_to($model_name, $id_or_name_field)
58
+	{
59
+		$order = null;
60
+		if ($model_name === $this->_alphabetically_first_model_name) {
61
+			$order = 'first';
62
+		} else {
63
+			$order = 'second';
64
+		}
65
+		return $this->get_join_model()->field_settings_for('EXJ_' . $order . '_model_' . $id_or_name_field);
66
+	}
67 67
 
68 68
 
69
-    /**
70
-     * Gets the SQL string for joining the main model's table containing the pk to the join table. Eg "LEFT JOIN
71
-     * real_join_table AS join_table_alias ON this_table_alias.pk = join_table_alias.fk_to_this_table"
72
-     *
73
-     * @param string $model_relation_chain like 'Event.Event_Venue.Venue'
74
-     * @return string of SQL
75
-     * @throws \EE_Error
76
-     */
77
-    public function get_join_to_intermediate_model_statement($model_relation_chain)
78
-    {
79
-        //create sql like
80
-        //LEFT JOIN join_table AS join_table_alias ON this_table_alias.this_table_pk = join_table_alias.join_table_fk_to_this
81
-        //LEFT JOIN other_table AS other_table_alias ON join_table_alias.join_table_fk_to_other = other_table_alias.other_table_pk
82
-        //remember the model relation chain to the JOIN model, because we'll
83
-        //need it for get_join_statement()
84
-        $this->_model_relation_chain_to_join_model = $model_relation_chain;
85
-        $this_table_pk_field                       = $this->get_this_model()->get_primary_key_field();
86
-        $join_table_fk_field_to_this_table         = $this->get_join_table_fk_field_to(
87
-            $this->get_this_model()->get_this_model_name(),
88
-            'ID');
89
-        $field_with_model_name                     = $this->get_join_table_fk_field_to(
90
-            $this->get_this_model()->get_this_model_name(),
91
-            'name');
92
-        $this_table_alias                          = EE_Model_Parser::extract_table_alias_model_relation_chain_prefix($model_relation_chain,
93
-                $this->get_this_model()->get_this_model_name()) . $this_table_pk_field->get_table_alias();
94
-        $join_table_alias                          = EE_Model_Parser::extract_table_alias_model_relation_chain_prefix($model_relation_chain,
95
-                $this->get_join_model()->get_this_model_name()) . $join_table_fk_field_to_this_table->get_table_alias();
96
-        $join_table                                = $this->get_join_model()->get_table_for_alias($join_table_alias);
97
-        //phew! ok, we have all the info we need, now we can create the SQL join string
98
-        $SQL = $this->_left_join(
99
-                $join_table,
100
-                $join_table_alias,
101
-                $join_table_fk_field_to_this_table->get_table_column(),
102
-                $this_table_alias,
103
-                $this_table_pk_field->get_table_column(),
104
-                $field_with_model_name->get_qualified_column() . "='" . $this->get_this_model()->get_this_model_name() . "'") .
105
-               $this->get_join_model()->_construct_internal_join_to_table_with_alias($join_table_alias);
69
+	/**
70
+	 * Gets the SQL string for joining the main model's table containing the pk to the join table. Eg "LEFT JOIN
71
+	 * real_join_table AS join_table_alias ON this_table_alias.pk = join_table_alias.fk_to_this_table"
72
+	 *
73
+	 * @param string $model_relation_chain like 'Event.Event_Venue.Venue'
74
+	 * @return string of SQL
75
+	 * @throws \EE_Error
76
+	 */
77
+	public function get_join_to_intermediate_model_statement($model_relation_chain)
78
+	{
79
+		//create sql like
80
+		//LEFT JOIN join_table AS join_table_alias ON this_table_alias.this_table_pk = join_table_alias.join_table_fk_to_this
81
+		//LEFT JOIN other_table AS other_table_alias ON join_table_alias.join_table_fk_to_other = other_table_alias.other_table_pk
82
+		//remember the model relation chain to the JOIN model, because we'll
83
+		//need it for get_join_statement()
84
+		$this->_model_relation_chain_to_join_model = $model_relation_chain;
85
+		$this_table_pk_field                       = $this->get_this_model()->get_primary_key_field();
86
+		$join_table_fk_field_to_this_table         = $this->get_join_table_fk_field_to(
87
+			$this->get_this_model()->get_this_model_name(),
88
+			'ID');
89
+		$field_with_model_name                     = $this->get_join_table_fk_field_to(
90
+			$this->get_this_model()->get_this_model_name(),
91
+			'name');
92
+		$this_table_alias                          = EE_Model_Parser::extract_table_alias_model_relation_chain_prefix($model_relation_chain,
93
+				$this->get_this_model()->get_this_model_name()) . $this_table_pk_field->get_table_alias();
94
+		$join_table_alias                          = EE_Model_Parser::extract_table_alias_model_relation_chain_prefix($model_relation_chain,
95
+				$this->get_join_model()->get_this_model_name()) . $join_table_fk_field_to_this_table->get_table_alias();
96
+		$join_table                                = $this->get_join_model()->get_table_for_alias($join_table_alias);
97
+		//phew! ok, we have all the info we need, now we can create the SQL join string
98
+		$SQL = $this->_left_join(
99
+				$join_table,
100
+				$join_table_alias,
101
+				$join_table_fk_field_to_this_table->get_table_column(),
102
+				$this_table_alias,
103
+				$this_table_pk_field->get_table_column(),
104
+				$field_with_model_name->get_qualified_column() . "='" . $this->get_this_model()->get_this_model_name() . "'") .
105
+			   $this->get_join_model()->_construct_internal_join_to_table_with_alias($join_table_alias);
106 106
 
107
-        return $SQL;
108
-    }
107
+		return $SQL;
108
+	}
109 109
 
110 110
 
111
-    /**
112
-     * Gets the SQL string for joining the join table to the other model's pk's table. Eg "LEFT JOIN real_other_table
113
-     * AS other_table_alias ON join_table_alias.fk_to_other_table = other_table_alias.pk" If you want to join between
114
-     * modelA -> joinModelAB -> modelB (eg, Event -> Event_Question_Group -> Question_Group), you should prepend the
115
-     * result of this function with results from get_join_to_intermediate_model_statement(), so that you join first to
116
-     * the intermediate join table, and then to the other model's pk's table
117
-     *
118
-     * @param string $model_relation_chain like 'Event.Event_Venue.Venue'
119
-     * @return string of SQL
120
-     * @throws \EE_Error
121
-     */
122
-    public function get_join_statement($model_relation_chain)
123
-    {
124
-        if ($this->_model_relation_chain_to_join_model === null) {
125
-            throw new EE_Error(sprintf(__('When using EE_HABTM_Relation to create a join, you must call get_join_to_intermediate_model_statement BEFORE get_join_statement',
126
-                'event_espresso')));
127
-        }
128
-        $join_table_fk_field_to_this_table  = $this->get_join_table_fk_field_to(
129
-            $this->get_this_model()->get_this_model_name(),
130
-            'ID');
131
-        $join_table_fk_field_to_other_table = $this->get_join_table_fk_field_to(
132
-            $this->get_other_model()->get_this_model_name(),
133
-            'ID');
134
-        $field_with_other_model_name        = $this->get_join_table_fk_field_to(
135
-            $this->get_other_model()->get_this_model_name(),
136
-            'name');
111
+	/**
112
+	 * Gets the SQL string for joining the join table to the other model's pk's table. Eg "LEFT JOIN real_other_table
113
+	 * AS other_table_alias ON join_table_alias.fk_to_other_table = other_table_alias.pk" If you want to join between
114
+	 * modelA -> joinModelAB -> modelB (eg, Event -> Event_Question_Group -> Question_Group), you should prepend the
115
+	 * result of this function with results from get_join_to_intermediate_model_statement(), so that you join first to
116
+	 * the intermediate join table, and then to the other model's pk's table
117
+	 *
118
+	 * @param string $model_relation_chain like 'Event.Event_Venue.Venue'
119
+	 * @return string of SQL
120
+	 * @throws \EE_Error
121
+	 */
122
+	public function get_join_statement($model_relation_chain)
123
+	{
124
+		if ($this->_model_relation_chain_to_join_model === null) {
125
+			throw new EE_Error(sprintf(__('When using EE_HABTM_Relation to create a join, you must call get_join_to_intermediate_model_statement BEFORE get_join_statement',
126
+				'event_espresso')));
127
+		}
128
+		$join_table_fk_field_to_this_table  = $this->get_join_table_fk_field_to(
129
+			$this->get_this_model()->get_this_model_name(),
130
+			'ID');
131
+		$join_table_fk_field_to_other_table = $this->get_join_table_fk_field_to(
132
+			$this->get_other_model()->get_this_model_name(),
133
+			'ID');
134
+		$field_with_other_model_name        = $this->get_join_table_fk_field_to(
135
+			$this->get_other_model()->get_this_model_name(),
136
+			'name');
137 137
 
138
-        $join_table_alias = EE_Model_Parser::extract_table_alias_model_relation_chain_prefix($this->_model_relation_chain_to_join_model,
139
-                $this->get_join_model()->get_this_model_name()) . $join_table_fk_field_to_this_table->get_table_alias();
138
+		$join_table_alias = EE_Model_Parser::extract_table_alias_model_relation_chain_prefix($this->_model_relation_chain_to_join_model,
139
+				$this->get_join_model()->get_this_model_name()) . $join_table_fk_field_to_this_table->get_table_alias();
140 140
 
141
-        $other_table_pk_field = $this->get_other_model()->get_primary_key_field();
142
-        $other_table_alias    = EE_Model_Parser::extract_table_alias_model_relation_chain_prefix($model_relation_chain,
143
-                $this->get_other_model()->get_this_model_name()) . $other_table_pk_field->get_table_alias();
144
-        $other_table          = $this->get_other_model()->get_table_for_alias($other_table_alias);
141
+		$other_table_pk_field = $this->get_other_model()->get_primary_key_field();
142
+		$other_table_alias    = EE_Model_Parser::extract_table_alias_model_relation_chain_prefix($model_relation_chain,
143
+				$this->get_other_model()->get_this_model_name()) . $other_table_pk_field->get_table_alias();
144
+		$other_table          = $this->get_other_model()->get_table_for_alias($other_table_alias);
145 145
 
146
-        $SQL = $this->_left_join(
147
-                $other_table,
148
-                $other_table_alias,
149
-                $other_table_pk_field->get_table_column(),
150
-                $join_table_alias,
151
-                $join_table_fk_field_to_other_table->get_table_column(),
152
-                $field_with_other_model_name->get_qualified_column() . "='" . $this->get_other_model()->get_this_model_name() . "'"
153
-            ) .
154
-               $this->get_other_model()->_construct_internal_join_to_table_with_alias($other_table_alias);
155
-        return $SQL;
156
-    }
146
+		$SQL = $this->_left_join(
147
+				$other_table,
148
+				$other_table_alias,
149
+				$other_table_pk_field->get_table_column(),
150
+				$join_table_alias,
151
+				$join_table_fk_field_to_other_table->get_table_column(),
152
+				$field_with_other_model_name->get_qualified_column() . "='" . $this->get_other_model()->get_this_model_name() . "'"
153
+			) .
154
+			   $this->get_other_model()->_construct_internal_join_to_table_with_alias($other_table_alias);
155
+		return $SQL;
156
+	}
157 157
 
158 158
 
159
-    /**
160
-     * Ensures there is an entry in the join table between these two models. Feel free to do this manually if you like.
161
-     *
162
-     * @param EE_Base_Class|int $this_obj_or_id
163
-     * @param EE_Base_Class|int $other_obj_or_id
164
-     * @param array             $extra_join_model_fields_n_values col=>val pairs that are used as extra conditions for
165
-     *                                                            checking existing values and for setting new rows if
166
-     *                                                            no exact matches.
167
-     * @return EE_Base_Class
168
-     * @throws \EE_Error
169
-     */
170
-    public function add_relation_to($this_obj_or_id, $other_obj_or_id, $extra_join_model_fields_n_values = array())
171
-    {
172
-        $this_model_obj  = $this->get_this_model()->ensure_is_obj($this_obj_or_id, true);
173
-        $other_model_obj = $this->get_other_model()->ensure_is_obj($other_obj_or_id, true);
174
-        //check if such a relationship already exists
175
-        $join_model_fk_to_this_model          = $this->get_join_table_fk_field_to(
176
-            $this->get_this_model()->get_this_model_name(),
177
-            'ID');
178
-        $join_model_name_field_to_this_model  = $this->get_join_table_fk_field_to(
179
-            $this->get_this_model()->get_this_model_name(),
180
-            'name');
181
-        $join_model_fk_to_other_model         = $this->get_join_table_fk_field_to(
182
-            $this->get_other_model()->get_this_model_name(),
183
-            'ID');
184
-        $join_model_name_field_to_other_model = $this->get_join_table_fk_field_to(
185
-            $this->get_other_model()->get_this_model_name(),
186
-            'name');
159
+	/**
160
+	 * Ensures there is an entry in the join table between these two models. Feel free to do this manually if you like.
161
+	 *
162
+	 * @param EE_Base_Class|int $this_obj_or_id
163
+	 * @param EE_Base_Class|int $other_obj_or_id
164
+	 * @param array             $extra_join_model_fields_n_values col=>val pairs that are used as extra conditions for
165
+	 *                                                            checking existing values and for setting new rows if
166
+	 *                                                            no exact matches.
167
+	 * @return EE_Base_Class
168
+	 * @throws \EE_Error
169
+	 */
170
+	public function add_relation_to($this_obj_or_id, $other_obj_or_id, $extra_join_model_fields_n_values = array())
171
+	{
172
+		$this_model_obj  = $this->get_this_model()->ensure_is_obj($this_obj_or_id, true);
173
+		$other_model_obj = $this->get_other_model()->ensure_is_obj($other_obj_or_id, true);
174
+		//check if such a relationship already exists
175
+		$join_model_fk_to_this_model          = $this->get_join_table_fk_field_to(
176
+			$this->get_this_model()->get_this_model_name(),
177
+			'ID');
178
+		$join_model_name_field_to_this_model  = $this->get_join_table_fk_field_to(
179
+			$this->get_this_model()->get_this_model_name(),
180
+			'name');
181
+		$join_model_fk_to_other_model         = $this->get_join_table_fk_field_to(
182
+			$this->get_other_model()->get_this_model_name(),
183
+			'ID');
184
+		$join_model_name_field_to_other_model = $this->get_join_table_fk_field_to(
185
+			$this->get_other_model()->get_this_model_name(),
186
+			'name');
187 187
 
188
-        $cols_n_values = array(
189
-            $join_model_fk_to_this_model->get_name()          => $this_model_obj->ID(),
190
-            $join_model_name_field_to_this_model->get_name()  => $this_model_obj->get_model()->get_this_model_name(),
191
-            $join_model_fk_to_other_model->get_name()         => $other_model_obj->ID(),
192
-            $join_model_name_field_to_other_model->get_name() => $other_model_obj->get_model()->get_this_model_name(),
193
-        );
188
+		$cols_n_values = array(
189
+			$join_model_fk_to_this_model->get_name()          => $this_model_obj->ID(),
190
+			$join_model_name_field_to_this_model->get_name()  => $this_model_obj->get_model()->get_this_model_name(),
191
+			$join_model_fk_to_other_model->get_name()         => $other_model_obj->ID(),
192
+			$join_model_name_field_to_other_model->get_name() => $other_model_obj->get_model()->get_this_model_name(),
193
+		);
194 194
 
195
-        //if $where_query exists lets add them to the query_params.
196
-        if (! empty($extra_join_model_fields_n_values)) {
197
-            //make sure we strip any of the join model names from the $where_query cause we don't need that in here (why? because client code may have used the same conditionals for get_all_related which DOES need the join model name)
198
-            //make sure we strip THIS models name from the query param
199
-            $parsed_query = array();
200
-            foreach ($extra_join_model_fields_n_values as $query_param => $val) {
201
-                $query_param                = str_replace($this->get_join_model()->get_this_model_name() . ".", "",
202
-                    $query_param);
203
-                $parsed_query[$query_param] = $val;
204
-            }
205
-            $cols_n_values = array_merge($cols_n_values, $parsed_query);
206
-        }
195
+		//if $where_query exists lets add them to the query_params.
196
+		if (! empty($extra_join_model_fields_n_values)) {
197
+			//make sure we strip any of the join model names from the $where_query cause we don't need that in here (why? because client code may have used the same conditionals for get_all_related which DOES need the join model name)
198
+			//make sure we strip THIS models name from the query param
199
+			$parsed_query = array();
200
+			foreach ($extra_join_model_fields_n_values as $query_param => $val) {
201
+				$query_param                = str_replace($this->get_join_model()->get_this_model_name() . ".", "",
202
+					$query_param);
203
+				$parsed_query[$query_param] = $val;
204
+			}
205
+			$cols_n_values = array_merge($cols_n_values, $parsed_query);
206
+		}
207 207
 
208
-        $query_params = array($cols_n_values);
208
+		$query_params = array($cols_n_values);
209 209
 
210 210
 
211
-        $existing_entry_in_join_table = $this->get_join_model()->get_one($query_params);
212
-        //if there is already an entry in the join table, indicating a relationship, we're done
213
-        //again, if you want more sophisticated logic or insertions (handling more columns than just 2 foreign keys to
214
-        //the other tables, use the joining model directly!
215
-        if (! $existing_entry_in_join_table) {
216
-            $this->get_join_model()->insert($cols_n_values);
217
-        }
218
-        return $other_model_obj;
219
-    }
211
+		$existing_entry_in_join_table = $this->get_join_model()->get_one($query_params);
212
+		//if there is already an entry in the join table, indicating a relationship, we're done
213
+		//again, if you want more sophisticated logic or insertions (handling more columns than just 2 foreign keys to
214
+		//the other tables, use the joining model directly!
215
+		if (! $existing_entry_in_join_table) {
216
+			$this->get_join_model()->insert($cols_n_values);
217
+		}
218
+		return $other_model_obj;
219
+	}
220 220
 
221 221
 
222
-    /**
223
-     * Deletes any rows in the join table that have foreign keys matching the other model objects specified
224
-     *
225
-     * @param EE_Base_Class|int $this_obj_or_id
226
-     * @param EE_Base_Class|int $other_obj_or_id
227
-     * @param array             $where_query col=>val pairs that are used as extra conditions for checking existing
228
-     *                                       values and for removing existing rows if exact matches exist.
229
-     * @return EE_Base_Class
230
-     * @throws \EE_Error
231
-     */
232
-    public function remove_relation_to($this_obj_or_id, $other_obj_or_id, $where_query = array())
233
-    {
234
-        $this_model_obj  = $this->get_this_model()->ensure_is_obj($this_obj_or_id, true);
235
-        $other_model_obj = $this->get_other_model()->ensure_is_obj($other_obj_or_id, true);
236
-        //check if such a relationship already exists
237
-        $join_model_fk_to_this_model          = $this->get_join_table_fk_field_to(
238
-            $this->get_this_model()->get_this_model_name(),
239
-            'ID');
240
-        $join_model_name_field_to_this_model  = $this->get_join_table_fk_field_to(
241
-            $this->get_this_model()->get_this_model_name(),
242
-            'name');
243
-        $join_model_fk_to_other_model         = $this->get_join_table_fk_field_to(
244
-            $this->get_other_model()->get_this_model_name(),
245
-            'ID');
246
-        $join_model_name_field_to_other_model = $this->get_join_table_fk_field_to(
247
-            $this->get_other_model()->get_this_model_name(),
248
-            'name');
222
+	/**
223
+	 * Deletes any rows in the join table that have foreign keys matching the other model objects specified
224
+	 *
225
+	 * @param EE_Base_Class|int $this_obj_or_id
226
+	 * @param EE_Base_Class|int $other_obj_or_id
227
+	 * @param array             $where_query col=>val pairs that are used as extra conditions for checking existing
228
+	 *                                       values and for removing existing rows if exact matches exist.
229
+	 * @return EE_Base_Class
230
+	 * @throws \EE_Error
231
+	 */
232
+	public function remove_relation_to($this_obj_or_id, $other_obj_or_id, $where_query = array())
233
+	{
234
+		$this_model_obj  = $this->get_this_model()->ensure_is_obj($this_obj_or_id, true);
235
+		$other_model_obj = $this->get_other_model()->ensure_is_obj($other_obj_or_id, true);
236
+		//check if such a relationship already exists
237
+		$join_model_fk_to_this_model          = $this->get_join_table_fk_field_to(
238
+			$this->get_this_model()->get_this_model_name(),
239
+			'ID');
240
+		$join_model_name_field_to_this_model  = $this->get_join_table_fk_field_to(
241
+			$this->get_this_model()->get_this_model_name(),
242
+			'name');
243
+		$join_model_fk_to_other_model         = $this->get_join_table_fk_field_to(
244
+			$this->get_other_model()->get_this_model_name(),
245
+			'ID');
246
+		$join_model_name_field_to_other_model = $this->get_join_table_fk_field_to(
247
+			$this->get_other_model()->get_this_model_name(),
248
+			'name');
249 249
 
250
-        $cols_n_values = array(
251
-            $join_model_fk_to_this_model->get_name()          => $this_model_obj->ID(),
252
-            $join_model_name_field_to_this_model->get_name()  => $this_model_obj->get_model()->get_this_model_name(),
253
-            $join_model_fk_to_other_model->get_name()         => $other_model_obj->ID(),
254
-            $join_model_name_field_to_other_model->get_name() => $other_model_obj->get_model()->get_this_model_name(),
255
-        );
250
+		$cols_n_values = array(
251
+			$join_model_fk_to_this_model->get_name()          => $this_model_obj->ID(),
252
+			$join_model_name_field_to_this_model->get_name()  => $this_model_obj->get_model()->get_this_model_name(),
253
+			$join_model_fk_to_other_model->get_name()         => $other_model_obj->ID(),
254
+			$join_model_name_field_to_other_model->get_name() => $other_model_obj->get_model()->get_this_model_name(),
255
+		);
256 256
 
257
-        //if $where_query exists lets add them to the query_params.
258
-        if (! empty($where_query)) {
259
-            //make sure we strip any of the join model names from the $where_query cause we don't need that in here (why? because client code may have used the same conditionals for get_all_related which DOES need the join model name)
260
-            //make sure we strip THIS models name from the query param
261
-            $parsed_query = array();
262
-            foreach ($where_query as $query_param => $val) {
263
-                $query_param                = str_replace($this->get_join_model()->get_this_model_name() . ".", "",
264
-                    $query_param);
265
-                $parsed_query[$query_param] = $val;
266
-            }
267
-            $cols_n_values = array_merge($cols_n_values, $parsed_query);
268
-        }
257
+		//if $where_query exists lets add them to the query_params.
258
+		if (! empty($where_query)) {
259
+			//make sure we strip any of the join model names from the $where_query cause we don't need that in here (why? because client code may have used the same conditionals for get_all_related which DOES need the join model name)
260
+			//make sure we strip THIS models name from the query param
261
+			$parsed_query = array();
262
+			foreach ($where_query as $query_param => $val) {
263
+				$query_param                = str_replace($this->get_join_model()->get_this_model_name() . ".", "",
264
+					$query_param);
265
+				$parsed_query[$query_param] = $val;
266
+			}
267
+			$cols_n_values = array_merge($cols_n_values, $parsed_query);
268
+		}
269 269
 
270
-        $this->get_join_model()->delete(array($cols_n_values));
271
-        return $other_model_obj;
272
-    }
270
+		$this->get_join_model()->delete(array($cols_n_values));
271
+		return $other_model_obj;
272
+	}
273 273
 }
Please login to merge, or discard this patch.
Spacing   +13 added lines, -13 removed lines patch added patch discarded remove patch
@@ -62,7 +62,7 @@  discard block
 block discarded – undo
62 62
         } else {
63 63
             $order = 'second';
64 64
         }
65
-        return $this->get_join_model()->field_settings_for('EXJ_' . $order . '_model_' . $id_or_name_field);
65
+        return $this->get_join_model()->field_settings_for('EXJ_'.$order.'_model_'.$id_or_name_field);
66 66
     }
67 67
 
68 68
 
@@ -90,9 +90,9 @@  discard block
 block discarded – undo
90 90
             $this->get_this_model()->get_this_model_name(),
91 91
             'name');
92 92
         $this_table_alias                          = EE_Model_Parser::extract_table_alias_model_relation_chain_prefix($model_relation_chain,
93
-                $this->get_this_model()->get_this_model_name()) . $this_table_pk_field->get_table_alias();
93
+                $this->get_this_model()->get_this_model_name()).$this_table_pk_field->get_table_alias();
94 94
         $join_table_alias                          = EE_Model_Parser::extract_table_alias_model_relation_chain_prefix($model_relation_chain,
95
-                $this->get_join_model()->get_this_model_name()) . $join_table_fk_field_to_this_table->get_table_alias();
95
+                $this->get_join_model()->get_this_model_name()).$join_table_fk_field_to_this_table->get_table_alias();
96 96
         $join_table                                = $this->get_join_model()->get_table_for_alias($join_table_alias);
97 97
         //phew! ok, we have all the info we need, now we can create the SQL join string
98 98
         $SQL = $this->_left_join(
@@ -101,7 +101,7 @@  discard block
 block discarded – undo
101 101
                 $join_table_fk_field_to_this_table->get_table_column(),
102 102
                 $this_table_alias,
103 103
                 $this_table_pk_field->get_table_column(),
104
-                $field_with_model_name->get_qualified_column() . "='" . $this->get_this_model()->get_this_model_name() . "'") .
104
+                $field_with_model_name->get_qualified_column()."='".$this->get_this_model()->get_this_model_name()."'").
105 105
                $this->get_join_model()->_construct_internal_join_to_table_with_alias($join_table_alias);
106 106
 
107 107
         return $SQL;
@@ -136,11 +136,11 @@  discard block
 block discarded – undo
136 136
             'name');
137 137
 
138 138
         $join_table_alias = EE_Model_Parser::extract_table_alias_model_relation_chain_prefix($this->_model_relation_chain_to_join_model,
139
-                $this->get_join_model()->get_this_model_name()) . $join_table_fk_field_to_this_table->get_table_alias();
139
+                $this->get_join_model()->get_this_model_name()).$join_table_fk_field_to_this_table->get_table_alias();
140 140
 
141 141
         $other_table_pk_field = $this->get_other_model()->get_primary_key_field();
142 142
         $other_table_alias    = EE_Model_Parser::extract_table_alias_model_relation_chain_prefix($model_relation_chain,
143
-                $this->get_other_model()->get_this_model_name()) . $other_table_pk_field->get_table_alias();
143
+                $this->get_other_model()->get_this_model_name()).$other_table_pk_field->get_table_alias();
144 144
         $other_table          = $this->get_other_model()->get_table_for_alias($other_table_alias);
145 145
 
146 146
         $SQL = $this->_left_join(
@@ -149,8 +149,8 @@  discard block
 block discarded – undo
149 149
                 $other_table_pk_field->get_table_column(),
150 150
                 $join_table_alias,
151 151
                 $join_table_fk_field_to_other_table->get_table_column(),
152
-                $field_with_other_model_name->get_qualified_column() . "='" . $this->get_other_model()->get_this_model_name() . "'"
153
-            ) .
152
+                $field_with_other_model_name->get_qualified_column()."='".$this->get_other_model()->get_this_model_name()."'"
153
+            ).
154 154
                $this->get_other_model()->_construct_internal_join_to_table_with_alias($other_table_alias);
155 155
         return $SQL;
156 156
     }
@@ -193,12 +193,12 @@  discard block
 block discarded – undo
193 193
         );
194 194
 
195 195
         //if $where_query exists lets add them to the query_params.
196
-        if (! empty($extra_join_model_fields_n_values)) {
196
+        if ( ! empty($extra_join_model_fields_n_values)) {
197 197
             //make sure we strip any of the join model names from the $where_query cause we don't need that in here (why? because client code may have used the same conditionals for get_all_related which DOES need the join model name)
198 198
             //make sure we strip THIS models name from the query param
199 199
             $parsed_query = array();
200 200
             foreach ($extra_join_model_fields_n_values as $query_param => $val) {
201
-                $query_param                = str_replace($this->get_join_model()->get_this_model_name() . ".", "",
201
+                $query_param                = str_replace($this->get_join_model()->get_this_model_name().".", "",
202 202
                     $query_param);
203 203
                 $parsed_query[$query_param] = $val;
204 204
             }
@@ -212,7 +212,7 @@  discard block
 block discarded – undo
212 212
         //if there is already an entry in the join table, indicating a relationship, we're done
213 213
         //again, if you want more sophisticated logic or insertions (handling more columns than just 2 foreign keys to
214 214
         //the other tables, use the joining model directly!
215
-        if (! $existing_entry_in_join_table) {
215
+        if ( ! $existing_entry_in_join_table) {
216 216
             $this->get_join_model()->insert($cols_n_values);
217 217
         }
218 218
         return $other_model_obj;
@@ -255,12 +255,12 @@  discard block
 block discarded – undo
255 255
         );
256 256
 
257 257
         //if $where_query exists lets add them to the query_params.
258
-        if (! empty($where_query)) {
258
+        if ( ! empty($where_query)) {
259 259
             //make sure we strip any of the join model names from the $where_query cause we don't need that in here (why? because client code may have used the same conditionals for get_all_related which DOES need the join model name)
260 260
             //make sure we strip THIS models name from the query param
261 261
             $parsed_query = array();
262 262
             foreach ($where_query as $query_param => $val) {
263
-                $query_param                = str_replace($this->get_join_model()->get_this_model_name() . ".", "",
263
+                $query_param                = str_replace($this->get_join_model()->get_this_model_name().".", "",
264 264
                     $query_param);
265 265
                 $parsed_query[$query_param] = $val;
266 266
             }
Please login to merge, or discard this patch.
core/db_models/relations/EE_Belongs_To_Any_Relation.php 2 patches
Indentation   +73 added lines, -73 removed lines patch added patch discarded remove patch
@@ -18,83 +18,83 @@
 block discarded – undo
18 18
 {
19 19
 
20 20
 
21
-    /**
22
-     * get_join_statement
23
-     *
24
-     * @param string $model_relation_chain
25
-     * @return string
26
-     * @throws \EE_Error
27
-     */
28
-    public function get_join_statement($model_relation_chain)
29
-    {
30
-        //create the sql string like
31
-        $this_table_fk_field = $this->get_this_model()->get_foreign_key_to($this->get_other_model()->get_this_model_name());
32
-        //ALSO, need to get the field with the model name
33
-        $field_with_model_name = $this->get_this_model()->get_field_containing_related_model_name();
21
+	/**
22
+	 * get_join_statement
23
+	 *
24
+	 * @param string $model_relation_chain
25
+	 * @return string
26
+	 * @throws \EE_Error
27
+	 */
28
+	public function get_join_statement($model_relation_chain)
29
+	{
30
+		//create the sql string like
31
+		$this_table_fk_field = $this->get_this_model()->get_foreign_key_to($this->get_other_model()->get_this_model_name());
32
+		//ALSO, need to get the field with the model name
33
+		$field_with_model_name = $this->get_this_model()->get_field_containing_related_model_name();
34 34
 
35 35
 
36
-        $other_table_pk_field = $this->get_other_model()->get_primary_key_field();
37
-        $this_table_alias     = EE_Model_Parser::extract_table_alias_model_relation_chain_prefix($model_relation_chain,
38
-                $this->get_this_model()->get_this_model_name()) . $this_table_fk_field->get_table_alias();
39
-        $other_table_alias    = EE_Model_Parser::extract_table_alias_model_relation_chain_prefix($model_relation_chain,
40
-                $this->get_other_model()->get_this_model_name()) . $other_table_pk_field->get_table_alias();
41
-        $other_table          = $this->get_other_model()->get_table_for_alias($other_table_alias);
42
-        return $this->_left_join($other_table,
43
-                $other_table_alias,
44
-                $other_table_pk_field->get_table_column(),
45
-                $this_table_alias,
46
-                $this_table_fk_field->get_table_column(),
47
-                $field_with_model_name->get_qualified_column() . "='" . $this->get_other_model()->get_this_model_name() . "'")
48
-               . $this->get_other_model()->_construct_internal_join_to_table_with_alias($other_table_alias);
49
-    }
36
+		$other_table_pk_field = $this->get_other_model()->get_primary_key_field();
37
+		$this_table_alias     = EE_Model_Parser::extract_table_alias_model_relation_chain_prefix($model_relation_chain,
38
+				$this->get_this_model()->get_this_model_name()) . $this_table_fk_field->get_table_alias();
39
+		$other_table_alias    = EE_Model_Parser::extract_table_alias_model_relation_chain_prefix($model_relation_chain,
40
+				$this->get_other_model()->get_this_model_name()) . $other_table_pk_field->get_table_alias();
41
+		$other_table          = $this->get_other_model()->get_table_for_alias($other_table_alias);
42
+		return $this->_left_join($other_table,
43
+				$other_table_alias,
44
+				$other_table_pk_field->get_table_column(),
45
+				$this_table_alias,
46
+				$this_table_fk_field->get_table_column(),
47
+				$field_with_model_name->get_qualified_column() . "='" . $this->get_other_model()->get_this_model_name() . "'")
48
+			   . $this->get_other_model()->_construct_internal_join_to_table_with_alias($other_table_alias);
49
+	}
50 50
 
51 51
 
52
-    /**
53
-     * Sets this model object's foreign key to the other model object's primary key. Feel free to do this manually if
54
-     * you like.
55
-     *
56
-     * @param EE_Base_Class|int $this_obj_or_id
57
-     * @param EE_Base_Class|int $other_obj_or_id
58
-     * @param array             $extra_join_model_fields_n_values
59
-     * @return \EE_Base_Class
60
-     * @throws \EE_Error
61
-     */
62
-    public function add_relation_to($this_obj_or_id, $other_obj_or_id, $extra_join_model_fields_n_values = array())
63
-    {
64
-        $this_model_obj  = $this->get_this_model()->ensure_is_obj($this_obj_or_id, true);
65
-        $other_model_obj = $this->get_other_model()->ensure_is_obj($other_obj_or_id, true);
66
-        //find the field on THIS model which a foreign key to the other model
67
-        $fk_on_this_model = $this->get_this_model()->get_foreign_key_to($this->get_other_model()->get_this_model_name());
68
-        //set that field on the other model to this model's ID
69
-        $this_model_obj->set($fk_on_this_model->get_name(), $other_model_obj->ID());
70
-        //and make sure this model's field with the foreign model name is set to the correct value
71
-        $this_model_obj->set($this->get_this_model()->get_field_containing_related_model_name()->get_name(),
72
-            $this->get_other_model()->get_this_model_name());
73
-        $this_model_obj->save();
74
-        return $other_model_obj;
75
-    }
52
+	/**
53
+	 * Sets this model object's foreign key to the other model object's primary key. Feel free to do this manually if
54
+	 * you like.
55
+	 *
56
+	 * @param EE_Base_Class|int $this_obj_or_id
57
+	 * @param EE_Base_Class|int $other_obj_or_id
58
+	 * @param array             $extra_join_model_fields_n_values
59
+	 * @return \EE_Base_Class
60
+	 * @throws \EE_Error
61
+	 */
62
+	public function add_relation_to($this_obj_or_id, $other_obj_or_id, $extra_join_model_fields_n_values = array())
63
+	{
64
+		$this_model_obj  = $this->get_this_model()->ensure_is_obj($this_obj_or_id, true);
65
+		$other_model_obj = $this->get_other_model()->ensure_is_obj($other_obj_or_id, true);
66
+		//find the field on THIS model which a foreign key to the other model
67
+		$fk_on_this_model = $this->get_this_model()->get_foreign_key_to($this->get_other_model()->get_this_model_name());
68
+		//set that field on the other model to this model's ID
69
+		$this_model_obj->set($fk_on_this_model->get_name(), $other_model_obj->ID());
70
+		//and make sure this model's field with the foreign model name is set to the correct value
71
+		$this_model_obj->set($this->get_this_model()->get_field_containing_related_model_name()->get_name(),
72
+			$this->get_other_model()->get_this_model_name());
73
+		$this_model_obj->save();
74
+		return $other_model_obj;
75
+	}
76 76
 
77 77
 
78
-    /**
79
-     * Sets the this model object's foreign key to its default, instead of pointing to the other model object
80
-     *
81
-     * @param EE_Base_Class|int $this_obj_or_id
82
-     * @param EE_Base_Class|int $other_obj_or_id
83
-     * @param array             $where_query
84
-     * @return \EE_Base_Class
85
-     * @throws \EE_Error
86
-     */
87
-    public function remove_relation_to($this_obj_or_id, $other_obj_or_id, $where_query = array())
88
-    {
89
-        $this_model_obj  = $this->get_this_model()->ensure_is_obj($this_obj_or_id, true);
90
-        $other_model_obj = $this->get_other_model()->ensure_is_obj($other_obj_or_id);
91
-        //find the field on the other model which is a foreign key to this model
92
-        $fk_on_this_model = $this->get_this_model()->get_foreign_key_to($this->get_other_model()->get_this_model_name());
93
-        //set that field on the other model to this model's ID
94
-        $this_model_obj->set($fk_on_this_model->get_name(), null, true);
95
-        $this_model_obj->set($this->get_this_model()->get_field_containing_related_model_name()->get_name(), null,
96
-            true);
97
-        $this_model_obj->save();
98
-        return $other_model_obj;
99
-    }
78
+	/**
79
+	 * Sets the this model object's foreign key to its default, instead of pointing to the other model object
80
+	 *
81
+	 * @param EE_Base_Class|int $this_obj_or_id
82
+	 * @param EE_Base_Class|int $other_obj_or_id
83
+	 * @param array             $where_query
84
+	 * @return \EE_Base_Class
85
+	 * @throws \EE_Error
86
+	 */
87
+	public function remove_relation_to($this_obj_or_id, $other_obj_or_id, $where_query = array())
88
+	{
89
+		$this_model_obj  = $this->get_this_model()->ensure_is_obj($this_obj_or_id, true);
90
+		$other_model_obj = $this->get_other_model()->ensure_is_obj($other_obj_or_id);
91
+		//find the field on the other model which is a foreign key to this model
92
+		$fk_on_this_model = $this->get_this_model()->get_foreign_key_to($this->get_other_model()->get_this_model_name());
93
+		//set that field on the other model to this model's ID
94
+		$this_model_obj->set($fk_on_this_model->get_name(), null, true);
95
+		$this_model_obj->set($this->get_this_model()->get_field_containing_related_model_name()->get_name(), null,
96
+			true);
97
+		$this_model_obj->save();
98
+		return $other_model_obj;
99
+	}
100 100
 }
Please login to merge, or discard this patch.
Spacing   +4 added lines, -4 removed lines patch added patch discarded remove patch
@@ -1,5 +1,5 @@  discard block
 block discarded – undo
1 1
 <?php
2
-require_once(EE_MODELS . 'relations/EE_Belongs_To_Relation.php');
2
+require_once(EE_MODELS.'relations/EE_Belongs_To_Relation.php');
3 3
 
4 4
 
5 5
 /**
@@ -35,16 +35,16 @@  discard block
 block discarded – undo
35 35
 
36 36
         $other_table_pk_field = $this->get_other_model()->get_primary_key_field();
37 37
         $this_table_alias     = EE_Model_Parser::extract_table_alias_model_relation_chain_prefix($model_relation_chain,
38
-                $this->get_this_model()->get_this_model_name()) . $this_table_fk_field->get_table_alias();
38
+                $this->get_this_model()->get_this_model_name()).$this_table_fk_field->get_table_alias();
39 39
         $other_table_alias    = EE_Model_Parser::extract_table_alias_model_relation_chain_prefix($model_relation_chain,
40
-                $this->get_other_model()->get_this_model_name()) . $other_table_pk_field->get_table_alias();
40
+                $this->get_other_model()->get_this_model_name()).$other_table_pk_field->get_table_alias();
41 41
         $other_table          = $this->get_other_model()->get_table_for_alias($other_table_alias);
42 42
         return $this->_left_join($other_table,
43 43
                 $other_table_alias,
44 44
                 $other_table_pk_field->get_table_column(),
45 45
                 $this_table_alias,
46 46
                 $this_table_fk_field->get_table_column(),
47
-                $field_with_model_name->get_qualified_column() . "='" . $this->get_other_model()->get_this_model_name() . "'")
47
+                $field_with_model_name->get_qualified_column()."='".$this->get_other_model()->get_this_model_name()."'")
48 48
                . $this->get_other_model()->_construct_internal_join_to_table_with_alias($other_table_alias);
49 49
     }
50 50
 
Please login to merge, or discard this patch.
core/db_models/relations/EE_HABTM_Relation.php 2 patches
Indentation   +199 added lines, -199 removed lines patch added patch discarded remove patch
@@ -12,203 +12,203 @@
 block discarded – undo
12 12
  */
13 13
 class EE_HABTM_Relation extends EE_Model_Relation_Base
14 14
 {
15
-    /**
16
-     * Model which defines the relation between two other models. Eg, the EE_Event_Question_Group model,
17
-     * which joins EE_Event and EE_Question_Group
18
-     *
19
-     * @var EEM_Base
20
-     */
21
-    protected $_joining_model_name;
22
-
23
-    protected $_model_relation_chain_to_join_model;
24
-
25
-
26
-    /**
27
-     * Object representing the relationship between two models. HasAndBelongsToMany relations always use a join-table
28
-     * (and an ee joining-model.) This knows how to join the models,
29
-     * get related models across the relation, and add-and-remove the relationships.
30
-     *
31
-     * @param bool    $joining_model_name
32
-     * @param boolean $block_deletes                 for this type of relation, we block by default for now. if there
33
-     *                                               are related models across this relation, block (prevent and add an
34
-     *                                               error) the deletion of this model
35
-     * @param string  $blocking_delete_error_message a customized error message on blocking deletes instead of the
36
-     *                                               default
37
-     */
38
-    public function __construct($joining_model_name, $block_deletes = true, $blocking_delete_error_message = '')
39
-    {
40
-        $this->_joining_model_name = $joining_model_name;
41
-        parent::__construct($block_deletes, $blocking_delete_error_message);
42
-    }
43
-
44
-    /**
45
-     * Gets the joining model's object
46
-     *
47
-     * @return EEM_Base
48
-     */
49
-    public function get_join_model()
50
-    {
51
-        return $this->_get_model($this->_joining_model_name);
52
-    }
53
-
54
-
55
-    /**
56
-     * Gets the SQL string for joining the main model's table containing the pk to the join table. Eg "LEFT JOIN
57
-     * real_join_table AS join_table_alias ON this_table_alias.pk = join_table_alias.fk_to_this_table"
58
-     *
59
-     * @param string $model_relation_chain like 'Event.Event_Venue.Venue'
60
-     * @return string of SQL
61
-     * @throws \EE_Error
62
-     */
63
-    public function get_join_to_intermediate_model_statement($model_relation_chain)
64
-    {
65
-        //create sql like
66
-        //LEFT JOIN join_table AS join_table_alias ON this_table_alias.this_table_pk = join_table_alias.join_table_fk_to_this
67
-        //LEFT JOIN other_table AS other_table_alias ON join_table_alias.join_table_fk_to_other = other_table_alias.other_table_pk
68
-        //remember the model relation chain to the JOIN model, because we'll
69
-        //need it for get_join_statement()
70
-        $this->_model_relation_chain_to_join_model = $model_relation_chain;
71
-        $this_table_pk_field                       = $this->get_this_model()->get_primary_key_field();//get_foreign_key_to($this->get_other_model()->get_this_model_name());
72
-        $join_table_fk_field_to_this_table         = $this->get_join_model()->get_foreign_key_to($this->get_this_model()->get_this_model_name());
73
-        $this_table_alias                          = EE_Model_Parser::extract_table_alias_model_relation_chain_prefix($model_relation_chain,
74
-                $this->get_this_model()->get_this_model_name()) . $this_table_pk_field->get_table_alias();
75
-
76
-        $join_table_alias = EE_Model_Parser::extract_table_alias_model_relation_chain_prefix($model_relation_chain,
77
-                $this->get_join_model()->get_this_model_name()) . $join_table_fk_field_to_this_table->get_table_alias();
78
-        $join_table       = $this->get_join_model()->get_table_for_alias($join_table_alias);
79
-        //phew! ok, we have all the info we need, now we can create the SQL join string
80
-        $SQL = $this->_left_join($join_table, $join_table_alias, $join_table_fk_field_to_this_table->get_table_column(),
81
-                $this_table_alias,
82
-                $this_table_pk_field->get_table_column()) . $this->get_join_model()->_construct_internal_join_to_table_with_alias($join_table_alias);
83
-
84
-        return $SQL;
85
-    }
86
-
87
-
88
-    /**
89
-     * Gets the SQL string for joining the join table to the other model's pk's table. Eg "LEFT JOIN real_other_table
90
-     * AS other_table_alias ON join_table_alias.fk_to_other_table = other_table_alias.pk" If you want to join between
91
-     * modelA -> joinModelAB -> modelB (eg, Event -> Event_Question_Group -> Question_Group), you should prepend the
92
-     * result of this function with results from get_join_to_intermediate_model_statement(), so that you join first to
93
-     * the intermediate join table, and then to the other model's pk's table
94
-     *
95
-     * @param string $model_relation_chain like 'Event.Event_Venue.Venue'
96
-     * @return string of SQL
97
-     * @throws \EE_Error
98
-     */
99
-    public function get_join_statement($model_relation_chain)
100
-    {
101
-        if ($this->_model_relation_chain_to_join_model === null) {
102
-            throw new EE_Error(sprintf(__('When using EE_HABTM_Relation to create a join, you must call get_join_to_intermediate_model_statement BEFORE get_join_statement',
103
-                'event_espresso')));
104
-        }
105
-        $join_table_fk_field_to_this_table  = $this->get_join_model()->get_foreign_key_to($this->get_this_model()->get_this_model_name());
106
-        $join_table_alias                   = EE_Model_Parser::extract_table_alias_model_relation_chain_prefix($this->_model_relation_chain_to_join_model,
107
-                $this->get_join_model()->get_this_model_name()) . $join_table_fk_field_to_this_table->get_table_alias();
108
-        $other_table_pk_field               = $this->get_other_model()->get_primary_key_field();
109
-        $join_table_fk_field_to_other_table = $this->get_join_model()->get_foreign_key_to($this->get_other_model()->get_this_model_name());
110
-        $other_table_alias                  = EE_Model_Parser::extract_table_alias_model_relation_chain_prefix($model_relation_chain,
111
-                $this->get_other_model()->get_this_model_name()) . $other_table_pk_field->get_table_alias();
112
-        $other_table                        = $this->get_other_model()->get_table_for_alias($other_table_alias);
113
-
114
-        $SQL = $this->_left_join($other_table, $other_table_alias, $other_table_pk_field->get_table_column(),
115
-                $join_table_alias,
116
-                $join_table_fk_field_to_other_table->get_table_column()) . $this->get_other_model()->_construct_internal_join_to_table_with_alias($other_table_alias);
117
-        return $SQL;
118
-    }
119
-
120
-
121
-    /**
122
-     * Ensures there is an entry in the join table between these two models. Feel free to do this manually if you like.
123
-     * If the join table has additional columns (eg, the Event_Question_Group table has a is_primary column), then
124
-     * you'll want to directly use the EEM_Event_Question_Group model to add the entry to the table and set those extra
125
-     * columns' values
126
-     *
127
-     * @param EE_Base_Class|int $this_obj_or_id
128
-     * @param EE_Base_Class|int $other_obj_or_id
129
-     * @param array             $extra_join_model_fields_n_values col=>val pairs that are used as extra conditions for
130
-     *                                                            checking existing values and for setting new rows if
131
-     *                                                            no exact matches.
132
-     * @return EE_Base_Class
133
-     * @throws \EE_Error
134
-     */
135
-    public function add_relation_to($this_obj_or_id, $other_obj_or_id, $extra_join_model_fields_n_values = array())
136
-    {
137
-        $this_model_obj  = $this->get_this_model()->ensure_is_obj($this_obj_or_id, true);
138
-        $other_model_obj = $this->get_other_model()->ensure_is_obj($other_obj_or_id, true);
139
-        //check if such a relationship already exists
140
-        $join_model_fk_to_this_model  = $this->get_join_model()->get_foreign_key_to($this->get_this_model()->get_this_model_name());
141
-        $join_model_fk_to_other_model = $this->get_join_model()->get_foreign_key_to($this->get_other_model()->get_this_model_name());
142
-
143
-        $cols_n_values = array(
144
-            $join_model_fk_to_this_model->get_name()  => $this_model_obj->ID(),
145
-            $join_model_fk_to_other_model->get_name() => $other_model_obj->ID(),
146
-        );
147
-
148
-        //if $where_query exists lets add them to the query_params.
149
-        if (! empty($extra_join_model_fields_n_values)) {
150
-            //make sure we strip any of the join model names from the $where_query cause we don't need that in here (why? because client code may have used the same conditionals for get_all_related which DOES need the join model name)
151
-            //make sure we strip THIS models name from the query param
152
-            $parsed_query = array();
153
-            foreach ($extra_join_model_fields_n_values as $query_param => $val) {
154
-                $query_param                = str_replace($this->get_join_model()->get_this_model_name() . ".", "",
155
-                    $query_param);
156
-                $parsed_query[$query_param] = $val;
157
-            }
158
-            $cols_n_values = array_merge($cols_n_values, $parsed_query);
159
-        }
160
-
161
-        $query_params = array($cols_n_values);
162
-
163
-
164
-        $existing_entry_in_join_table = $this->get_join_model()->get_one($query_params);
165
-        //if there is already an entry in the join table, indicating a relationship, we're done
166
-        //again, if you want more sophisticated logic or insertions (handling more columns than just 2 foreign keys to
167
-        //the other tables, use the joining model directly!
168
-        if (! $existing_entry_in_join_table) {
169
-            $this->get_join_model()->insert($cols_n_values);
170
-        }
171
-        return $other_model_obj;
172
-    }
173
-
174
-
175
-    /**
176
-     * Deletes any rows in the join table that have foreign keys matching the other model objects specified
177
-     *
178
-     * @param EE_Base_Class|int $this_obj_or_id
179
-     * @param EE_Base_Class|int $other_obj_or_id
180
-     * @param array             $where_query col=>val pairs that are used as extra conditions for checking existing
181
-     *                                       values and for removing existing rows if exact matches exist.
182
-     * @return EE_Base_Class
183
-     * @throws \EE_Error
184
-     */
185
-    public function remove_relation_to($this_obj_or_id, $other_obj_or_id, $where_query = array())
186
-    {
187
-        $this_model_obj  = $this->get_this_model()->ensure_is_obj($this_obj_or_id, true);
188
-        $other_model_obj = $this->get_other_model()->ensure_is_obj($other_obj_or_id, true);
189
-        //check if such a relationship already exists
190
-        $join_model_fk_to_this_model  = $this->get_join_model()->get_foreign_key_to($this->get_this_model()->get_this_model_name());
191
-        $join_model_fk_to_other_model = $this->get_join_model()->get_foreign_key_to($this->get_other_model()->get_this_model_name());
192
-
193
-        $cols_n_values = array(
194
-            $join_model_fk_to_this_model->get_name()  => $this_model_obj->ID(),
195
-            $join_model_fk_to_other_model->get_name() => $other_model_obj->ID(),
196
-        );
197
-
198
-        //if $where_query exists lets add them to the query_params.
199
-        if (! empty($where_query)) {
200
-            //make sure we strip any of the join model names from the $where_query cause we don't need that in here (why? because client code may have used the same conditionals for get_all_related which DOES need the join model name)
201
-            //make sure we strip THIS models name from the query param
202
-            $parsed_query = array();
203
-            foreach ($where_query as $query_param => $val) {
204
-                $query_param                = str_replace($this->get_join_model()->get_this_model_name() . ".", "",
205
-                    $query_param);
206
-                $parsed_query[$query_param] = $val;
207
-            }
208
-            $cols_n_values = array_merge($cols_n_values, $parsed_query);
209
-        }
210
-
211
-        $this->get_join_model()->delete(array($cols_n_values));
212
-        return $other_model_obj;
213
-    }
15
+	/**
16
+	 * Model which defines the relation between two other models. Eg, the EE_Event_Question_Group model,
17
+	 * which joins EE_Event and EE_Question_Group
18
+	 *
19
+	 * @var EEM_Base
20
+	 */
21
+	protected $_joining_model_name;
22
+
23
+	protected $_model_relation_chain_to_join_model;
24
+
25
+
26
+	/**
27
+	 * Object representing the relationship between two models. HasAndBelongsToMany relations always use a join-table
28
+	 * (and an ee joining-model.) This knows how to join the models,
29
+	 * get related models across the relation, and add-and-remove the relationships.
30
+	 *
31
+	 * @param bool    $joining_model_name
32
+	 * @param boolean $block_deletes                 for this type of relation, we block by default for now. if there
33
+	 *                                               are related models across this relation, block (prevent and add an
34
+	 *                                               error) the deletion of this model
35
+	 * @param string  $blocking_delete_error_message a customized error message on blocking deletes instead of the
36
+	 *                                               default
37
+	 */
38
+	public function __construct($joining_model_name, $block_deletes = true, $blocking_delete_error_message = '')
39
+	{
40
+		$this->_joining_model_name = $joining_model_name;
41
+		parent::__construct($block_deletes, $blocking_delete_error_message);
42
+	}
43
+
44
+	/**
45
+	 * Gets the joining model's object
46
+	 *
47
+	 * @return EEM_Base
48
+	 */
49
+	public function get_join_model()
50
+	{
51
+		return $this->_get_model($this->_joining_model_name);
52
+	}
53
+
54
+
55
+	/**
56
+	 * Gets the SQL string for joining the main model's table containing the pk to the join table. Eg "LEFT JOIN
57
+	 * real_join_table AS join_table_alias ON this_table_alias.pk = join_table_alias.fk_to_this_table"
58
+	 *
59
+	 * @param string $model_relation_chain like 'Event.Event_Venue.Venue'
60
+	 * @return string of SQL
61
+	 * @throws \EE_Error
62
+	 */
63
+	public function get_join_to_intermediate_model_statement($model_relation_chain)
64
+	{
65
+		//create sql like
66
+		//LEFT JOIN join_table AS join_table_alias ON this_table_alias.this_table_pk = join_table_alias.join_table_fk_to_this
67
+		//LEFT JOIN other_table AS other_table_alias ON join_table_alias.join_table_fk_to_other = other_table_alias.other_table_pk
68
+		//remember the model relation chain to the JOIN model, because we'll
69
+		//need it for get_join_statement()
70
+		$this->_model_relation_chain_to_join_model = $model_relation_chain;
71
+		$this_table_pk_field                       = $this->get_this_model()->get_primary_key_field();//get_foreign_key_to($this->get_other_model()->get_this_model_name());
72
+		$join_table_fk_field_to_this_table         = $this->get_join_model()->get_foreign_key_to($this->get_this_model()->get_this_model_name());
73
+		$this_table_alias                          = EE_Model_Parser::extract_table_alias_model_relation_chain_prefix($model_relation_chain,
74
+				$this->get_this_model()->get_this_model_name()) . $this_table_pk_field->get_table_alias();
75
+
76
+		$join_table_alias = EE_Model_Parser::extract_table_alias_model_relation_chain_prefix($model_relation_chain,
77
+				$this->get_join_model()->get_this_model_name()) . $join_table_fk_field_to_this_table->get_table_alias();
78
+		$join_table       = $this->get_join_model()->get_table_for_alias($join_table_alias);
79
+		//phew! ok, we have all the info we need, now we can create the SQL join string
80
+		$SQL = $this->_left_join($join_table, $join_table_alias, $join_table_fk_field_to_this_table->get_table_column(),
81
+				$this_table_alias,
82
+				$this_table_pk_field->get_table_column()) . $this->get_join_model()->_construct_internal_join_to_table_with_alias($join_table_alias);
83
+
84
+		return $SQL;
85
+	}
86
+
87
+
88
+	/**
89
+	 * Gets the SQL string for joining the join table to the other model's pk's table. Eg "LEFT JOIN real_other_table
90
+	 * AS other_table_alias ON join_table_alias.fk_to_other_table = other_table_alias.pk" If you want to join between
91
+	 * modelA -> joinModelAB -> modelB (eg, Event -> Event_Question_Group -> Question_Group), you should prepend the
92
+	 * result of this function with results from get_join_to_intermediate_model_statement(), so that you join first to
93
+	 * the intermediate join table, and then to the other model's pk's table
94
+	 *
95
+	 * @param string $model_relation_chain like 'Event.Event_Venue.Venue'
96
+	 * @return string of SQL
97
+	 * @throws \EE_Error
98
+	 */
99
+	public function get_join_statement($model_relation_chain)
100
+	{
101
+		if ($this->_model_relation_chain_to_join_model === null) {
102
+			throw new EE_Error(sprintf(__('When using EE_HABTM_Relation to create a join, you must call get_join_to_intermediate_model_statement BEFORE get_join_statement',
103
+				'event_espresso')));
104
+		}
105
+		$join_table_fk_field_to_this_table  = $this->get_join_model()->get_foreign_key_to($this->get_this_model()->get_this_model_name());
106
+		$join_table_alias                   = EE_Model_Parser::extract_table_alias_model_relation_chain_prefix($this->_model_relation_chain_to_join_model,
107
+				$this->get_join_model()->get_this_model_name()) . $join_table_fk_field_to_this_table->get_table_alias();
108
+		$other_table_pk_field               = $this->get_other_model()->get_primary_key_field();
109
+		$join_table_fk_field_to_other_table = $this->get_join_model()->get_foreign_key_to($this->get_other_model()->get_this_model_name());
110
+		$other_table_alias                  = EE_Model_Parser::extract_table_alias_model_relation_chain_prefix($model_relation_chain,
111
+				$this->get_other_model()->get_this_model_name()) . $other_table_pk_field->get_table_alias();
112
+		$other_table                        = $this->get_other_model()->get_table_for_alias($other_table_alias);
113
+
114
+		$SQL = $this->_left_join($other_table, $other_table_alias, $other_table_pk_field->get_table_column(),
115
+				$join_table_alias,
116
+				$join_table_fk_field_to_other_table->get_table_column()) . $this->get_other_model()->_construct_internal_join_to_table_with_alias($other_table_alias);
117
+		return $SQL;
118
+	}
119
+
120
+
121
+	/**
122
+	 * Ensures there is an entry in the join table between these two models. Feel free to do this manually if you like.
123
+	 * If the join table has additional columns (eg, the Event_Question_Group table has a is_primary column), then
124
+	 * you'll want to directly use the EEM_Event_Question_Group model to add the entry to the table and set those extra
125
+	 * columns' values
126
+	 *
127
+	 * @param EE_Base_Class|int $this_obj_or_id
128
+	 * @param EE_Base_Class|int $other_obj_or_id
129
+	 * @param array             $extra_join_model_fields_n_values col=>val pairs that are used as extra conditions for
130
+	 *                                                            checking existing values and for setting new rows if
131
+	 *                                                            no exact matches.
132
+	 * @return EE_Base_Class
133
+	 * @throws \EE_Error
134
+	 */
135
+	public function add_relation_to($this_obj_or_id, $other_obj_or_id, $extra_join_model_fields_n_values = array())
136
+	{
137
+		$this_model_obj  = $this->get_this_model()->ensure_is_obj($this_obj_or_id, true);
138
+		$other_model_obj = $this->get_other_model()->ensure_is_obj($other_obj_or_id, true);
139
+		//check if such a relationship already exists
140
+		$join_model_fk_to_this_model  = $this->get_join_model()->get_foreign_key_to($this->get_this_model()->get_this_model_name());
141
+		$join_model_fk_to_other_model = $this->get_join_model()->get_foreign_key_to($this->get_other_model()->get_this_model_name());
142
+
143
+		$cols_n_values = array(
144
+			$join_model_fk_to_this_model->get_name()  => $this_model_obj->ID(),
145
+			$join_model_fk_to_other_model->get_name() => $other_model_obj->ID(),
146
+		);
147
+
148
+		//if $where_query exists lets add them to the query_params.
149
+		if (! empty($extra_join_model_fields_n_values)) {
150
+			//make sure we strip any of the join model names from the $where_query cause we don't need that in here (why? because client code may have used the same conditionals for get_all_related which DOES need the join model name)
151
+			//make sure we strip THIS models name from the query param
152
+			$parsed_query = array();
153
+			foreach ($extra_join_model_fields_n_values as $query_param => $val) {
154
+				$query_param                = str_replace($this->get_join_model()->get_this_model_name() . ".", "",
155
+					$query_param);
156
+				$parsed_query[$query_param] = $val;
157
+			}
158
+			$cols_n_values = array_merge($cols_n_values, $parsed_query);
159
+		}
160
+
161
+		$query_params = array($cols_n_values);
162
+
163
+
164
+		$existing_entry_in_join_table = $this->get_join_model()->get_one($query_params);
165
+		//if there is already an entry in the join table, indicating a relationship, we're done
166
+		//again, if you want more sophisticated logic or insertions (handling more columns than just 2 foreign keys to
167
+		//the other tables, use the joining model directly!
168
+		if (! $existing_entry_in_join_table) {
169
+			$this->get_join_model()->insert($cols_n_values);
170
+		}
171
+		return $other_model_obj;
172
+	}
173
+
174
+
175
+	/**
176
+	 * Deletes any rows in the join table that have foreign keys matching the other model objects specified
177
+	 *
178
+	 * @param EE_Base_Class|int $this_obj_or_id
179
+	 * @param EE_Base_Class|int $other_obj_or_id
180
+	 * @param array             $where_query col=>val pairs that are used as extra conditions for checking existing
181
+	 *                                       values and for removing existing rows if exact matches exist.
182
+	 * @return EE_Base_Class
183
+	 * @throws \EE_Error
184
+	 */
185
+	public function remove_relation_to($this_obj_or_id, $other_obj_or_id, $where_query = array())
186
+	{
187
+		$this_model_obj  = $this->get_this_model()->ensure_is_obj($this_obj_or_id, true);
188
+		$other_model_obj = $this->get_other_model()->ensure_is_obj($other_obj_or_id, true);
189
+		//check if such a relationship already exists
190
+		$join_model_fk_to_this_model  = $this->get_join_model()->get_foreign_key_to($this->get_this_model()->get_this_model_name());
191
+		$join_model_fk_to_other_model = $this->get_join_model()->get_foreign_key_to($this->get_other_model()->get_this_model_name());
192
+
193
+		$cols_n_values = array(
194
+			$join_model_fk_to_this_model->get_name()  => $this_model_obj->ID(),
195
+			$join_model_fk_to_other_model->get_name() => $other_model_obj->ID(),
196
+		);
197
+
198
+		//if $where_query exists lets add them to the query_params.
199
+		if (! empty($where_query)) {
200
+			//make sure we strip any of the join model names from the $where_query cause we don't need that in here (why? because client code may have used the same conditionals for get_all_related which DOES need the join model name)
201
+			//make sure we strip THIS models name from the query param
202
+			$parsed_query = array();
203
+			foreach ($where_query as $query_param => $val) {
204
+				$query_param                = str_replace($this->get_join_model()->get_this_model_name() . ".", "",
205
+					$query_param);
206
+				$parsed_query[$query_param] = $val;
207
+			}
208
+			$cols_n_values = array_merge($cols_n_values, $parsed_query);
209
+		}
210
+
211
+		$this->get_join_model()->delete(array($cols_n_values));
212
+		return $other_model_obj;
213
+	}
214 214
 }
Please login to merge, or discard this patch.
Spacing   +13 added lines, -13 removed lines patch added patch discarded remove patch
@@ -1,6 +1,6 @@  discard block
 block discarded – undo
1 1
 <?php
2 2
 
3
-require_once(EE_MODELS . 'relations/EE_Model_Relation_Base.php');
3
+require_once(EE_MODELS.'relations/EE_Model_Relation_Base.php');
4 4
 
5 5
 
6 6
 /**
@@ -68,18 +68,18 @@  discard block
 block discarded – undo
68 68
         //remember the model relation chain to the JOIN model, because we'll
69 69
         //need it for get_join_statement()
70 70
         $this->_model_relation_chain_to_join_model = $model_relation_chain;
71
-        $this_table_pk_field                       = $this->get_this_model()->get_primary_key_field();//get_foreign_key_to($this->get_other_model()->get_this_model_name());
71
+        $this_table_pk_field                       = $this->get_this_model()->get_primary_key_field(); //get_foreign_key_to($this->get_other_model()->get_this_model_name());
72 72
         $join_table_fk_field_to_this_table         = $this->get_join_model()->get_foreign_key_to($this->get_this_model()->get_this_model_name());
73 73
         $this_table_alias                          = EE_Model_Parser::extract_table_alias_model_relation_chain_prefix($model_relation_chain,
74
-                $this->get_this_model()->get_this_model_name()) . $this_table_pk_field->get_table_alias();
74
+                $this->get_this_model()->get_this_model_name()).$this_table_pk_field->get_table_alias();
75 75
 
76 76
         $join_table_alias = EE_Model_Parser::extract_table_alias_model_relation_chain_prefix($model_relation_chain,
77
-                $this->get_join_model()->get_this_model_name()) . $join_table_fk_field_to_this_table->get_table_alias();
77
+                $this->get_join_model()->get_this_model_name()).$join_table_fk_field_to_this_table->get_table_alias();
78 78
         $join_table       = $this->get_join_model()->get_table_for_alias($join_table_alias);
79 79
         //phew! ok, we have all the info we need, now we can create the SQL join string
80 80
         $SQL = $this->_left_join($join_table, $join_table_alias, $join_table_fk_field_to_this_table->get_table_column(),
81 81
                 $this_table_alias,
82
-                $this_table_pk_field->get_table_column()) . $this->get_join_model()->_construct_internal_join_to_table_with_alias($join_table_alias);
82
+                $this_table_pk_field->get_table_column()).$this->get_join_model()->_construct_internal_join_to_table_with_alias($join_table_alias);
83 83
 
84 84
         return $SQL;
85 85
     }
@@ -104,16 +104,16 @@  discard block
 block discarded – undo
104 104
         }
105 105
         $join_table_fk_field_to_this_table  = $this->get_join_model()->get_foreign_key_to($this->get_this_model()->get_this_model_name());
106 106
         $join_table_alias                   = EE_Model_Parser::extract_table_alias_model_relation_chain_prefix($this->_model_relation_chain_to_join_model,
107
-                $this->get_join_model()->get_this_model_name()) . $join_table_fk_field_to_this_table->get_table_alias();
107
+                $this->get_join_model()->get_this_model_name()).$join_table_fk_field_to_this_table->get_table_alias();
108 108
         $other_table_pk_field               = $this->get_other_model()->get_primary_key_field();
109 109
         $join_table_fk_field_to_other_table = $this->get_join_model()->get_foreign_key_to($this->get_other_model()->get_this_model_name());
110 110
         $other_table_alias                  = EE_Model_Parser::extract_table_alias_model_relation_chain_prefix($model_relation_chain,
111
-                $this->get_other_model()->get_this_model_name()) . $other_table_pk_field->get_table_alias();
111
+                $this->get_other_model()->get_this_model_name()).$other_table_pk_field->get_table_alias();
112 112
         $other_table                        = $this->get_other_model()->get_table_for_alias($other_table_alias);
113 113
 
114 114
         $SQL = $this->_left_join($other_table, $other_table_alias, $other_table_pk_field->get_table_column(),
115 115
                 $join_table_alias,
116
-                $join_table_fk_field_to_other_table->get_table_column()) . $this->get_other_model()->_construct_internal_join_to_table_with_alias($other_table_alias);
116
+                $join_table_fk_field_to_other_table->get_table_column()).$this->get_other_model()->_construct_internal_join_to_table_with_alias($other_table_alias);
117 117
         return $SQL;
118 118
     }
119 119
 
@@ -146,12 +146,12 @@  discard block
 block discarded – undo
146 146
         );
147 147
 
148 148
         //if $where_query exists lets add them to the query_params.
149
-        if (! empty($extra_join_model_fields_n_values)) {
149
+        if ( ! empty($extra_join_model_fields_n_values)) {
150 150
             //make sure we strip any of the join model names from the $where_query cause we don't need that in here (why? because client code may have used the same conditionals for get_all_related which DOES need the join model name)
151 151
             //make sure we strip THIS models name from the query param
152 152
             $parsed_query = array();
153 153
             foreach ($extra_join_model_fields_n_values as $query_param => $val) {
154
-                $query_param                = str_replace($this->get_join_model()->get_this_model_name() . ".", "",
154
+                $query_param                = str_replace($this->get_join_model()->get_this_model_name().".", "",
155 155
                     $query_param);
156 156
                 $parsed_query[$query_param] = $val;
157 157
             }
@@ -165,7 +165,7 @@  discard block
 block discarded – undo
165 165
         //if there is already an entry in the join table, indicating a relationship, we're done
166 166
         //again, if you want more sophisticated logic or insertions (handling more columns than just 2 foreign keys to
167 167
         //the other tables, use the joining model directly!
168
-        if (! $existing_entry_in_join_table) {
168
+        if ( ! $existing_entry_in_join_table) {
169 169
             $this->get_join_model()->insert($cols_n_values);
170 170
         }
171 171
         return $other_model_obj;
@@ -196,12 +196,12 @@  discard block
 block discarded – undo
196 196
         );
197 197
 
198 198
         //if $where_query exists lets add them to the query_params.
199
-        if (! empty($where_query)) {
199
+        if ( ! empty($where_query)) {
200 200
             //make sure we strip any of the join model names from the $where_query cause we don't need that in here (why? because client code may have used the same conditionals for get_all_related which DOES need the join model name)
201 201
             //make sure we strip THIS models name from the query param
202 202
             $parsed_query = array();
203 203
             foreach ($where_query as $query_param => $val) {
204
-                $query_param                = str_replace($this->get_join_model()->get_this_model_name() . ".", "",
204
+                $query_param                = str_replace($this->get_join_model()->get_this_model_name().".", "",
205 205
                     $query_param);
206 206
                 $parsed_query[$query_param] = $val;
207 207
             }
Please login to merge, or discard this patch.
core/db_models/relations/EE_Belongs_To_Relation.php 2 patches
Indentation   +113 added lines, -113 removed lines patch added patch discarded remove patch
@@ -13,128 +13,128 @@
 block discarded – undo
13 13
 class EE_Belongs_To_Relation extends EE_Model_Relation_Base
14 14
 {
15 15
 
16
-    /**
17
-     * Object representing the relationship between two models. Belongs_To means that THIS model has the foreign key
18
-     * to the other model. This knows how to join the models,
19
-     * get related models across the relation, and add-and-remove the relationships.
20
-     *
21
-     * @param boolean $block_deletes                                For Belongs_To relations, this is set to FALSE by
22
-     *                                                              default. if there are related models across this
23
-     *                                                              relation, block (prevent and add an error) the
24
-     *                                                              deletion of this model
25
-     * @param string  $related_model_objects_deletion_error_message a customized error message on blocking deletes
26
-     *                                                              instead of the default
27
-     */
28
-    public function __construct($block_deletes = false, $related_model_objects_deletion_error_message = null)
29
-    {
30
-        parent::__construct($block_deletes, $related_model_objects_deletion_error_message);
31
-    }
16
+	/**
17
+	 * Object representing the relationship between two models. Belongs_To means that THIS model has the foreign key
18
+	 * to the other model. This knows how to join the models,
19
+	 * get related models across the relation, and add-and-remove the relationships.
20
+	 *
21
+	 * @param boolean $block_deletes                                For Belongs_To relations, this is set to FALSE by
22
+	 *                                                              default. if there are related models across this
23
+	 *                                                              relation, block (prevent and add an error) the
24
+	 *                                                              deletion of this model
25
+	 * @param string  $related_model_objects_deletion_error_message a customized error message on blocking deletes
26
+	 *                                                              instead of the default
27
+	 */
28
+	public function __construct($block_deletes = false, $related_model_objects_deletion_error_message = null)
29
+	{
30
+		parent::__construct($block_deletes, $related_model_objects_deletion_error_message);
31
+	}
32 32
 
33 33
 
34
-    /**
35
-     * get_join_statement
36
-     *
37
-     * @param string $model_relation_chain
38
-     * @return string
39
-     * @throws \EE_Error
40
-     */
41
-    public function get_join_statement($model_relation_chain)
42
-    {
43
-        //create the sql string like
44
-        $this_table_fk_field  = $this->get_this_model()->get_foreign_key_to($this->get_other_model()->get_this_model_name());
45
-        $other_table_pk_field = $this->get_other_model()->get_primary_key_field();
46
-        $this_table_alias     = EE_Model_Parser::extract_table_alias_model_relation_chain_prefix($model_relation_chain,
47
-                $this->get_this_model()->get_this_model_name()) . $this_table_fk_field->get_table_alias();
48
-        $other_table_alias    = EE_Model_Parser::extract_table_alias_model_relation_chain_prefix($model_relation_chain,
49
-                $this->get_other_model()->get_this_model_name()) . $other_table_pk_field->get_table_alias();
50
-        $other_table          = $this->get_other_model()->get_table_for_alias($other_table_alias);
51
-        return $this->_left_join($other_table, $other_table_alias, $other_table_pk_field->get_table_column(),
52
-                $this_table_alias,
53
-                $this_table_fk_field->get_table_column()) . $this->get_other_model()->_construct_internal_join_to_table_with_alias($other_table_alias);
54
-    }
34
+	/**
35
+	 * get_join_statement
36
+	 *
37
+	 * @param string $model_relation_chain
38
+	 * @return string
39
+	 * @throws \EE_Error
40
+	 */
41
+	public function get_join_statement($model_relation_chain)
42
+	{
43
+		//create the sql string like
44
+		$this_table_fk_field  = $this->get_this_model()->get_foreign_key_to($this->get_other_model()->get_this_model_name());
45
+		$other_table_pk_field = $this->get_other_model()->get_primary_key_field();
46
+		$this_table_alias     = EE_Model_Parser::extract_table_alias_model_relation_chain_prefix($model_relation_chain,
47
+				$this->get_this_model()->get_this_model_name()) . $this_table_fk_field->get_table_alias();
48
+		$other_table_alias    = EE_Model_Parser::extract_table_alias_model_relation_chain_prefix($model_relation_chain,
49
+				$this->get_other_model()->get_this_model_name()) . $other_table_pk_field->get_table_alias();
50
+		$other_table          = $this->get_other_model()->get_table_for_alias($other_table_alias);
51
+		return $this->_left_join($other_table, $other_table_alias, $other_table_pk_field->get_table_column(),
52
+				$this_table_alias,
53
+				$this_table_fk_field->get_table_column()) . $this->get_other_model()->_construct_internal_join_to_table_with_alias($other_table_alias);
54
+	}
55 55
 
56 56
 
57
-    /**
58
-     * Sets this model object's foreign key to the other model object's primary key. Feel free to do this manually if
59
-     * you like.
60
-     *
61
-     * @param EE_Base_Class|int $this_obj_or_id
62
-     * @param EE_Base_Class|int $other_obj_or_id
63
-     * @param array             $extra_join_model_fields_n_values
64
-     * @return \EE_Base_Class
65
-     * @throws \EE_Error
66
-     */
67
-    public function add_relation_to($this_obj_or_id, $other_obj_or_id, $extra_join_model_fields_n_values = array())
68
-    {
69
-        $this_model_obj  = $this->get_this_model()->ensure_is_obj($this_obj_or_id, true);
70
-        $other_model_obj = $this->get_other_model()->ensure_is_obj($other_obj_or_id, true);
71
-        //find the field on the other model which is a foreign key to this model
72
-        $fk_on_this_model = $this->get_this_model()->get_foreign_key_to($this->get_other_model()->get_this_model_name());
73
-        if ($this_model_obj->get($fk_on_this_model->get_name()) != $other_model_obj->ID()) {
74
-            //set that field on the other model to this model's ID
75
-            $this_model_obj->set($fk_on_this_model->get_name(), $other_model_obj->ID());
76
-            $this_model_obj->save();
77
-        }
78
-        return $other_model_obj;
79
-    }
57
+	/**
58
+	 * Sets this model object's foreign key to the other model object's primary key. Feel free to do this manually if
59
+	 * you like.
60
+	 *
61
+	 * @param EE_Base_Class|int $this_obj_or_id
62
+	 * @param EE_Base_Class|int $other_obj_or_id
63
+	 * @param array             $extra_join_model_fields_n_values
64
+	 * @return \EE_Base_Class
65
+	 * @throws \EE_Error
66
+	 */
67
+	public function add_relation_to($this_obj_or_id, $other_obj_or_id, $extra_join_model_fields_n_values = array())
68
+	{
69
+		$this_model_obj  = $this->get_this_model()->ensure_is_obj($this_obj_or_id, true);
70
+		$other_model_obj = $this->get_other_model()->ensure_is_obj($other_obj_or_id, true);
71
+		//find the field on the other model which is a foreign key to this model
72
+		$fk_on_this_model = $this->get_this_model()->get_foreign_key_to($this->get_other_model()->get_this_model_name());
73
+		if ($this_model_obj->get($fk_on_this_model->get_name()) != $other_model_obj->ID()) {
74
+			//set that field on the other model to this model's ID
75
+			$this_model_obj->set($fk_on_this_model->get_name(), $other_model_obj->ID());
76
+			$this_model_obj->save();
77
+		}
78
+		return $other_model_obj;
79
+	}
80 80
 
81 81
 
82
-    /**
83
-     * Sets the this model object's foreign key to its default, instead of pointing to the other model object
84
-     *
85
-     * @param EE_Base_Class|int $this_obj_or_id
86
-     * @param EE_Base_Class|int $other_obj_or_id
87
-     * @param array             $where_query
88
-     * @return \EE_Base_Class
89
-     * @throws \EE_Error
90
-     */
91
-    public function remove_relation_to($this_obj_or_id, $other_obj_or_id, $where_query = array())
92
-    {
93
-        $this_model_obj  = $this->get_this_model()->ensure_is_obj($this_obj_or_id, true);
94
-        $other_model_obj = $this->get_other_model()->ensure_is_obj($other_obj_or_id);
95
-        //find the field on the other model which is a foreign key to this model
96
-        $fk_on_this_model = $this->get_this_model()->get_foreign_key_to($this->get_other_model()->get_this_model_name());
97
-        //set that field on the other model to this model's ID
98
-        $this_model_obj->set($fk_on_this_model->get_name(), null, true);
99
-        $this_model_obj->save();
100
-        return $other_model_obj;
101
-    }
82
+	/**
83
+	 * Sets the this model object's foreign key to its default, instead of pointing to the other model object
84
+	 *
85
+	 * @param EE_Base_Class|int $this_obj_or_id
86
+	 * @param EE_Base_Class|int $other_obj_or_id
87
+	 * @param array             $where_query
88
+	 * @return \EE_Base_Class
89
+	 * @throws \EE_Error
90
+	 */
91
+	public function remove_relation_to($this_obj_or_id, $other_obj_or_id, $where_query = array())
92
+	{
93
+		$this_model_obj  = $this->get_this_model()->ensure_is_obj($this_obj_or_id, true);
94
+		$other_model_obj = $this->get_other_model()->ensure_is_obj($other_obj_or_id);
95
+		//find the field on the other model which is a foreign key to this model
96
+		$fk_on_this_model = $this->get_this_model()->get_foreign_key_to($this->get_other_model()->get_this_model_name());
97
+		//set that field on the other model to this model's ID
98
+		$this_model_obj->set($fk_on_this_model->get_name(), null, true);
99
+		$this_model_obj->save();
100
+		return $other_model_obj;
101
+	}
102 102
 
103 103
 
104
-    /**
105
-     * Overrides parent so that we don't NEED to save the $model_object before getting the related objects.
106
-     *
107
-     * @param EE_Base_Class $model_obj_or_id
108
-     * @param array         $query_params                            like EEM_Base::get_all's $query_params
109
-     * @param boolean       $values_already_prepared_by_model_object @deprecated since 4.8.1
110
-     * @return EE_Base_Class[]
111
-     * @throws \EE_Error
112
-     */
113
-    public function get_all_related(
114
-        $model_obj_or_id,
115
-        $query_params = array(),
116
-        $values_already_prepared_by_model_object = false
117
-    ) {
118
-        if ($values_already_prepared_by_model_object !== false) {
119
-            EE_Error::doing_it_wrong('EE_Model_Relation_Base::get_all_related',
120
-                __('The argument $values_already_prepared_by_model_object is no longer used.', 'event_espresso'),
121
-                '4.8.1');
122
-        }
123
-        //get column on this model object which is a foreign key to the other model
124
-        $fk_field_obj = $this->get_this_model()->get_foreign_key_to($this->get_other_model()->get_this_model_name());
125
-        //get its value
126
-        if ($model_obj_or_id instanceof EE_Base_Class) {
127
-            $model_obj = $model_obj_or_id;
128
-        } else {
129
-            $model_obj = $this->get_this_model()->ensure_is_obj($model_obj_or_id);
130
-        }
131
-        $ID_value_on_other_model = $model_obj->get($fk_field_obj->get_name());
132
-        //get all where their PK matches that value
133
-        $query_params[0][$this->get_other_model()->get_primary_key_field()->get_name()] = $ID_value_on_other_model;
134
-        $query_params                                                                   = $this->_disable_default_where_conditions_on_query_param($query_params);
104
+	/**
105
+	 * Overrides parent so that we don't NEED to save the $model_object before getting the related objects.
106
+	 *
107
+	 * @param EE_Base_Class $model_obj_or_id
108
+	 * @param array         $query_params                            like EEM_Base::get_all's $query_params
109
+	 * @param boolean       $values_already_prepared_by_model_object @deprecated since 4.8.1
110
+	 * @return EE_Base_Class[]
111
+	 * @throws \EE_Error
112
+	 */
113
+	public function get_all_related(
114
+		$model_obj_or_id,
115
+		$query_params = array(),
116
+		$values_already_prepared_by_model_object = false
117
+	) {
118
+		if ($values_already_prepared_by_model_object !== false) {
119
+			EE_Error::doing_it_wrong('EE_Model_Relation_Base::get_all_related',
120
+				__('The argument $values_already_prepared_by_model_object is no longer used.', 'event_espresso'),
121
+				'4.8.1');
122
+		}
123
+		//get column on this model object which is a foreign key to the other model
124
+		$fk_field_obj = $this->get_this_model()->get_foreign_key_to($this->get_other_model()->get_this_model_name());
125
+		//get its value
126
+		if ($model_obj_or_id instanceof EE_Base_Class) {
127
+			$model_obj = $model_obj_or_id;
128
+		} else {
129
+			$model_obj = $this->get_this_model()->ensure_is_obj($model_obj_or_id);
130
+		}
131
+		$ID_value_on_other_model = $model_obj->get($fk_field_obj->get_name());
132
+		//get all where their PK matches that value
133
+		$query_params[0][$this->get_other_model()->get_primary_key_field()->get_name()] = $ID_value_on_other_model;
134
+		$query_params                                                                   = $this->_disable_default_where_conditions_on_query_param($query_params);
135 135
 //		echo '$query_params';
136 136
 //		var_dump($query_params);
137
-        return $this->get_other_model()->get_all($query_params);
138
-    }
137
+		return $this->get_other_model()->get_all($query_params);
138
+	}
139 139
 
140 140
 }
Please login to merge, or discard this patch.
Spacing   +4 added lines, -4 removed lines patch added patch discarded remove patch
@@ -1,5 +1,5 @@  discard block
 block discarded – undo
1 1
 <?php
2
-require_once(EE_MODELS . 'relations/EE_Model_Relation_Base.php');
2
+require_once(EE_MODELS.'relations/EE_Model_Relation_Base.php');
3 3
 
4 4
 /**
5 5
  * Class EE_Belongs_To_Relation
@@ -44,13 +44,13 @@  discard block
 block discarded – undo
44 44
         $this_table_fk_field  = $this->get_this_model()->get_foreign_key_to($this->get_other_model()->get_this_model_name());
45 45
         $other_table_pk_field = $this->get_other_model()->get_primary_key_field();
46 46
         $this_table_alias     = EE_Model_Parser::extract_table_alias_model_relation_chain_prefix($model_relation_chain,
47
-                $this->get_this_model()->get_this_model_name()) . $this_table_fk_field->get_table_alias();
47
+                $this->get_this_model()->get_this_model_name()).$this_table_fk_field->get_table_alias();
48 48
         $other_table_alias    = EE_Model_Parser::extract_table_alias_model_relation_chain_prefix($model_relation_chain,
49
-                $this->get_other_model()->get_this_model_name()) . $other_table_pk_field->get_table_alias();
49
+                $this->get_other_model()->get_this_model_name()).$other_table_pk_field->get_table_alias();
50 50
         $other_table          = $this->get_other_model()->get_table_for_alias($other_table_alias);
51 51
         return $this->_left_join($other_table, $other_table_alias, $other_table_pk_field->get_table_column(),
52 52
                 $this_table_alias,
53
-                $this_table_fk_field->get_table_column()) . $this->get_other_model()->_construct_internal_join_to_table_with_alias($other_table_alias);
53
+                $this_table_fk_field->get_table_column()).$this->get_other_model()->_construct_internal_join_to_table_with_alias($other_table_alias);
54 54
     }
55 55
 
56 56
 
Please login to merge, or discard this patch.