1
|
|
|
<?php |
2
|
|
|
if(!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point'); |
3
|
|
|
/********************************************************************************* |
4
|
|
|
* SugarCRM Community Edition is a customer relationship management program developed by |
5
|
|
|
* SugarCRM, Inc. Copyright (C) 2004-2013 SugarCRM Inc. |
6
|
|
|
|
7
|
|
|
* SuiteCRM is an extension to SugarCRM Community Edition developed by Salesagility Ltd. |
8
|
|
|
* Copyright (C) 2011 - 2014 Salesagility Ltd. |
9
|
|
|
* |
10
|
|
|
* This program is free software; you can redistribute it and/or modify it under |
11
|
|
|
* the terms of the GNU Affero General Public License version 3 as published by the |
12
|
|
|
* Free Software Foundation with the addition of the following permission added |
13
|
|
|
* to Section 15 as permitted in Section 7(a): FOR ANY PART OF THE COVERED WORK |
14
|
|
|
* IN WHICH THE COPYRIGHT IS OWNED BY SUGARCRM, SUGARCRM DISCLAIMS THE WARRANTY |
15
|
|
|
* OF NON INFRINGEMENT OF THIRD PARTY RIGHTS. |
16
|
|
|
* |
17
|
|
|
* This program is distributed in the hope that it will be useful, but WITHOUT |
18
|
|
|
* ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS |
19
|
|
|
* FOR A PARTICULAR PURPOSE. See the GNU Affero General Public License for more |
20
|
|
|
* details. |
21
|
|
|
* |
22
|
|
|
* You should have received a copy of the GNU Affero General Public License along with |
23
|
|
|
* this program; if not, see http://www.gnu.org/licenses or write to the Free |
24
|
|
|
* Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA |
25
|
|
|
* 02110-1301 USA. |
26
|
|
|
* |
27
|
|
|
* You can contact SugarCRM, Inc. headquarters at 10050 North Wolfe Road, |
28
|
|
|
* SW2-130, Cupertino, CA 95014, USA. or at email address [email protected]. |
29
|
|
|
* |
30
|
|
|
* The interactive user interfaces in modified source and object code versions |
31
|
|
|
* of this program must display Appropriate Legal Notices, as required under |
32
|
|
|
* Section 5 of the GNU Affero General Public License version 3. |
33
|
|
|
* |
34
|
|
|
* In accordance with Section 7(b) of the GNU Affero General Public License version 3, |
35
|
|
|
* these Appropriate Legal Notices must retain the display of the "Powered by |
36
|
|
|
* SugarCRM" logo and "Supercharged by SuiteCRM" logo. If the display of the logos is not |
37
|
|
|
* reasonably feasible for technical reasons, the Appropriate Legal Notices must |
38
|
|
|
* display the words "Powered by SugarCRM" and "Supercharged by SuiteCRM". |
39
|
|
|
********************************************************************************/ |
40
|
|
|
|
41
|
|
|
/********************************************************************************* |
42
|
|
|
|
43
|
|
|
* Description: |
44
|
|
|
********************************************************************************/ |
45
|
|
|
|
46
|
|
|
|
47
|
|
|
|
48
|
|
|
|
49
|
|
|
|
50
|
|
|
|
51
|
|
|
|
52
|
|
|
|
53
|
|
|
class Controller extends SugarBean { |
54
|
|
|
|
55
|
|
|
var $focus; |
56
|
|
|
var $type; //defines id this is a new list order or existing, or delete |
57
|
|
|
// New, Save, Delete |
58
|
|
|
|
59
|
|
|
public function __construct() { |
60
|
|
|
parent::__construct(); |
61
|
|
|
|
62
|
|
|
$this->disable_row_level_security =true; |
63
|
|
|
|
64
|
|
|
} |
65
|
|
|
|
66
|
|
|
/** |
67
|
|
|
* @deprecated deprecated since version 7.6, PHP4 Style Constructors are deprecated and will be remove in 7.8, please update your code, use __construct instead |
68
|
|
|
*/ |
69
|
|
|
public function Controller(){ |
70
|
|
|
$deprecatedMessage = 'PHP4 Style Constructors are deprecated and will be remove in 7.8, please update your code'; |
71
|
|
|
if(isset($GLOBALS['log'])) { |
72
|
|
|
$GLOBALS['log']->deprecated($deprecatedMessage); |
73
|
|
|
} |
74
|
|
|
else { |
75
|
|
|
trigger_error($deprecatedMessage, E_USER_DEPRECATED); |
76
|
|
|
} |
77
|
|
|
self::__construct(); |
78
|
|
|
} |
79
|
|
|
|
80
|
|
|
|
81
|
|
|
function init(& $seed_object, $type){ |
82
|
|
|
|
83
|
|
|
$this->focus = & $seed_object; |
84
|
|
|
$this->type = $type; |
85
|
|
|
|
86
|
|
|
//end function Controller |
87
|
|
|
} |
88
|
|
|
|
89
|
|
|
function change_component_order($magnitude, $direction, $parent_id=""){ |
90
|
|
|
|
91
|
|
|
if(!empty($this->type) && $this->type=="Save"){ |
92
|
|
|
|
93
|
|
|
//safety check |
94
|
|
|
$wall_test = $this->check_wall($magnitude, $direction, $parent_id); |
95
|
|
|
|
96
|
|
|
if($wall_test==false){ |
|
|
|
|
97
|
|
|
return; |
98
|
|
|
} |
99
|
|
|
|
100
|
|
|
|
101
|
|
|
if($direction=="Left"){ |
102
|
|
|
if($this->focus->controller_def['list_x']=="Y"){ |
103
|
|
|
$new_x = $this->focus->list_order_x -1; |
104
|
|
|
$affected_x = $this->focus->list_order_x; |
105
|
|
|
} else { |
106
|
|
|
$new_x = ""; |
107
|
|
|
$affected_x = ""; |
108
|
|
|
} |
109
|
|
|
if($this->focus->controller_def['list_y']=="Y"){ |
110
|
|
|
|
111
|
|
|
$new_y = $this->focus->list_order_y; |
112
|
|
|
$affected_y = $this->focus->list_order_y; |
113
|
|
|
} else { |
114
|
|
|
$new_y = ""; |
115
|
|
|
$affected_y = ""; |
116
|
|
|
} |
117
|
|
|
|
118
|
|
|
$affected_id = $this->get_affected_id($parent_id, $new_x, $new_y); |
119
|
|
|
//end if direction Left |
120
|
|
|
} |
121
|
|
|
if($direction=="Right"){ |
122
|
|
|
|
123
|
|
|
if($this->focus->controller_def['list_x']=="Y"){ |
124
|
|
|
$new_x = $this->focus->list_order_x + 1; |
125
|
|
|
$affected_x = $this->focus->list_order_x; |
126
|
|
|
} else { |
127
|
|
|
$new_x = ""; |
128
|
|
|
$affected_x = ""; |
129
|
|
|
} |
130
|
|
|
if($this->focus->controller_def['list_y']=="Y"){ |
131
|
|
|
$new_y = $this->focus->list_order_y; |
132
|
|
|
$affected_y = $this->focus->list_order_y; |
133
|
|
|
} else { |
134
|
|
|
$new_y = ""; |
135
|
|
|
$affected_y = ""; |
136
|
|
|
} |
137
|
|
|
$affected_id = $this->get_affected_id($parent_id, $new_x, $new_y); |
138
|
|
|
//end if direction Right |
139
|
|
|
} |
140
|
|
|
|
141
|
|
|
if($direction=="Up"){ |
142
|
|
|
if($this->focus->controller_def['list_x']=="Y"){ |
143
|
|
|
$new_x = $this->focus->list_order_x; |
144
|
|
|
$affected_x = $this->focus->list_order_x; |
145
|
|
|
} else { |
146
|
|
|
$new_x = ""; |
147
|
|
|
$affected_x = ""; |
148
|
|
|
} |
149
|
|
|
if($this->focus->controller_def['list_y']=="Y"){ |
150
|
|
|
|
151
|
|
|
$new_y = $this->focus->list_order_y - 1; |
152
|
|
|
$affected_y = $this->focus->list_order_y; |
153
|
|
|
} else { |
154
|
|
|
$new_y = ""; |
155
|
|
|
$affected_y = ""; |
156
|
|
|
} |
157
|
|
|
|
158
|
|
|
$affected_id = $this->get_affected_id($parent_id, $new_x, $new_y); |
159
|
|
|
|
160
|
|
|
//end if direction Up |
161
|
|
|
} |
162
|
|
|
if($direction=="Down"){ |
163
|
|
|
|
164
|
|
|
if($this->focus->controller_def['list_x']=="Y"){ |
165
|
|
|
$new_x = $this->focus->list_order_x; |
166
|
|
|
$affected_x = $this->focus->list_order_x; |
167
|
|
|
} else { |
168
|
|
|
$new_x = ""; |
169
|
|
|
$affected_x = ""; |
170
|
|
|
} |
171
|
|
|
if($this->focus->controller_def['list_y']=="Y"){ |
172
|
|
|
|
173
|
|
|
$new_y = $this->focus->list_order_y + 1; |
174
|
|
|
$affected_y = $this->focus->list_order_y; |
175
|
|
|
} else { |
176
|
|
|
$new_y = ""; |
177
|
|
|
$affected_y = ""; |
178
|
|
|
} |
179
|
|
|
$affected_id = $this->get_affected_id($parent_id, $new_x, $new_y); |
180
|
|
|
//end if direction Down |
181
|
|
|
} |
182
|
|
|
|
183
|
|
|
//This takes care of the component being pushed out of its position |
184
|
|
|
$this->update_affected_order($affected_id, $affected_x, $affected_y); |
185
|
|
|
|
186
|
|
|
//This takes care of the new positions for itself |
187
|
|
|
if($this->focus->controller_def['list_x']=="Y"){ |
188
|
|
|
$this->focus->list_order_x = $new_x; |
189
|
|
|
} |
190
|
|
|
|
191
|
|
|
if($this->focus->controller_def['list_y']=="Y"){ |
192
|
|
|
$this->focus->list_order_y = $new_y; |
193
|
|
|
} |
194
|
|
|
|
195
|
|
|
} else { |
196
|
|
|
//this is a new component, set the x or y value to the max + 1 |
197
|
|
|
|
198
|
|
|
$query = "SELECT MAX(".$this->focus->controller_def['start_var'].") max_start from ".$this->focus->table_name." |
199
|
|
|
WHERE ".$this->focus->controller_def['parent_var']."='$parent_id' |
200
|
|
|
AND ".$this->focus->table_name.".deleted='0' |
201
|
|
|
"; |
202
|
|
|
$result = $this->db->query($query,true," Error capturing max start order: "); |
203
|
|
|
$row = $this->db->fetchByAssoc($result); |
204
|
|
|
|
205
|
|
|
if(!is_null($row['max_start'])){ |
206
|
|
|
|
207
|
|
|
if($this->focus->controller_def['start_axis']=="x") { |
208
|
|
|
$this->focus->list_order_x = $row['max_start'] + 1; |
209
|
|
|
if($this->focus->controller_def['list_y']=="Y") $this->focus->list_order_y = 0; |
210
|
|
|
} |
211
|
|
|
|
212
|
|
|
if($this->focus->controller_def['start_axis']=="y") { |
213
|
|
|
$this->focus->list_order_y = $row['max_start'] + 1; |
214
|
|
|
if($this->focus->controller_def['list_x']=="Y") $this->focus->list_order_x = 0; |
215
|
|
|
} |
216
|
|
|
|
217
|
|
|
} else { |
218
|
|
|
//first row |
219
|
|
|
if($this->focus->controller_def['list_x']=="Y") $this->focus->list_order_x = 0; |
220
|
|
|
if($this->focus->controller_def['list_y']=="Y") $this->focus->list_order_y = 0; |
221
|
|
|
|
222
|
|
|
//end if else to check if this is first entry |
223
|
|
|
} |
224
|
|
|
//end if else on whether this is a new entry |
225
|
|
|
} |
226
|
|
|
//end function change_component_order |
227
|
|
|
} |
228
|
|
|
|
229
|
|
|
function update_affected_order($affected_id, $affected_new_x="", $affected_new_y=""){ |
230
|
|
|
|
231
|
|
|
$query = "UPDATE ".$this->focus->table_name." SET"; |
232
|
|
|
|
233
|
|
|
if($this->focus->controller_def['list_x']=="Y"){ |
234
|
|
|
$query .= " list_order_x='$affected_new_x'"; |
235
|
|
|
} |
236
|
|
|
if($this->focus->controller_def['list_y']=="Y"){ |
237
|
|
|
|
238
|
|
|
if($this->focus->controller_def['list_x']=="Y"){ |
239
|
|
|
$query .= " , "; |
240
|
|
|
} |
241
|
|
|
$query .= " list_order_y='$affected_new_y'"; |
242
|
|
|
} |
243
|
|
|
|
244
|
|
|
$query .= " WHERE id='$affected_id'"; |
245
|
|
|
$query .= " AND ".$this->focus->table_name.".deleted='0'"; |
246
|
|
|
$result = $this->db->query($query,true," Error updating affected order id: "); |
247
|
|
|
//end function update_affected_order |
248
|
|
|
} |
249
|
|
|
|
250
|
|
|
function get_affected_id($parent_id, $list_order_x="", $list_order_y=""){ |
251
|
|
|
|
252
|
|
|
$query = " SELECT id from ".$this->focus->table_name." |
253
|
|
|
WHERE ".$this->focus->controller_def['parent_var']."='$parent_id' |
254
|
|
|
AND ".$this->focus->table_name.".deleted='0' |
255
|
|
|
"; |
256
|
|
|
|
257
|
|
|
if($this->focus->controller_def['list_x']=="Y"){ |
258
|
|
|
$query .= " AND list_order_x='$list_order_x' "; |
259
|
|
|
} |
260
|
|
|
|
261
|
|
|
if($this->focus->controller_def['list_y']=="Y"){ |
262
|
|
|
$query .= " AND list_order_y='$list_order_y' "; |
263
|
|
|
} |
264
|
|
|
|
265
|
|
|
//echo $query."<BR>"; |
266
|
|
|
$result = $this->db->query($query,true," Error capturing affected id: "); |
267
|
|
|
$row = $this->db->fetchByAssoc($result); |
268
|
|
|
|
269
|
|
|
return $row['id']; |
270
|
|
|
|
271
|
|
|
//end function get_affected_id |
272
|
|
|
} |
273
|
|
|
|
274
|
|
|
|
275
|
|
|
/////////////Wall Functions//////////////////// |
276
|
|
|
|
277
|
|
|
|
278
|
|
|
function check_wall($magnitude, $direction, $parent_id){ |
279
|
|
|
|
280
|
|
|
//TODO: jgreen - this is only single axis check_wall mechanism, will need to upgrade this to double axis |
281
|
|
|
//This function determines if you can't move the direction you want, because you are at the edge |
282
|
|
|
|
283
|
|
|
|
284
|
|
|
//If down or Right, then check max list_order value |
285
|
|
|
if($direction=="Down" || $direction =="Right"){ |
286
|
|
|
|
287
|
|
|
$query = "SELECT MAX(".$this->focus->controller_def['start_var'].") max_start from ".$this->focus->table_name." |
288
|
|
|
WHERE ".$this->focus->controller_def['parent_var']."='$parent_id' |
289
|
|
|
AND ".$this->focus->table_name.".deleted='0' |
290
|
|
|
"; |
291
|
|
|
$result = $this->db->query($query,true," Error capturing max start order: "); |
292
|
|
|
$row = $this->db->fetchByAssoc($result); |
293
|
|
|
|
294
|
|
|
if($this->focus->controller_def['start_axis']=="x") { |
295
|
|
|
if($row['max_start'] == $this->focus->list_order_x){ |
296
|
|
|
return false; |
297
|
|
|
} |
298
|
|
|
} |
299
|
|
|
if($this->focus->controller_def['start_axis']=="y") { |
300
|
|
|
if($row['max_start'] == $this->focus->list_order_y){ |
301
|
|
|
return false; |
302
|
|
|
} |
303
|
|
|
} |
304
|
|
|
//end if up or right |
305
|
|
|
} |
306
|
|
|
|
307
|
|
|
//If up or left, then simply check the 0 value |
308
|
|
|
if($direction=="Up" || $direction =="Left"){ |
309
|
|
|
if($this->focus->controller_def['start_axis']=="x") { |
310
|
|
|
if($this->focus->list_order_x==0){ |
311
|
|
|
return false; |
312
|
|
|
} |
313
|
|
|
} |
314
|
|
|
if($this->focus->controller_def['start_axis']=="y") { |
315
|
|
|
if($this->focus->list_order_y==0){ |
316
|
|
|
return false; |
317
|
|
|
} |
318
|
|
|
} |
319
|
|
|
|
320
|
|
|
//end if down or left |
321
|
|
|
} |
322
|
|
|
|
323
|
|
|
//If you get here, then you are not at the wall and can change order |
324
|
|
|
return true; |
325
|
|
|
|
326
|
|
|
//end function check_wall |
327
|
|
|
} |
328
|
|
|
|
329
|
|
|
//End Wall Functions///////////////////////// |
330
|
|
|
|
331
|
|
|
//Delete adjust functions//////////////////// |
332
|
|
|
|
333
|
|
|
|
334
|
|
|
function delete_adjust_order($parent_id){ |
335
|
|
|
|
336
|
|
|
|
337
|
|
|
//Currently handles single axis motion only!!!!!!!!! |
338
|
|
|
//TODO: jgreen - Add dual axis motion |
339
|
|
|
|
340
|
|
|
//adjust along start_axis |
341
|
|
|
$variable_name = $this->focus->controller_def['start_var']; |
342
|
|
|
$current_position = $this->focus->$variable_name; |
343
|
|
|
|
344
|
|
|
$query = "UPDATE ".$this->focus->table_name." "; |
345
|
|
|
$query .= "SET ".$this->focus->controller_def['start_var']." = ".$this->focus->controller_def['start_var']." - 1 "; |
346
|
|
|
$query .= "WHERE ".$this->focus->controller_def['start_var']." > ".$current_position." AND deleted=0 "; |
347
|
|
|
$query .= "AND ".$this->focus->controller_def['parent_var']." = '".$parent_id."'"; |
348
|
|
|
|
349
|
|
|
$result = $this->db->query($query,true," Error updating the delete_adjust_order: "); |
350
|
|
|
//end delete_adjust_order |
351
|
|
|
} |
352
|
|
|
//End Delete Functions///////////////////////// |
353
|
|
|
//end class Controller |
354
|
|
|
} |
355
|
|
|
|
356
|
|
|
?> |
When comparing two booleans, it is generally considered safer to use the strict comparison operator.