Passed
Push — scrutinizer-code-quality ( 09f5a1...c4c5fb )
by Adam
56:05 queued 14:08
created

Controller::Controller()   A

Complexity

Conditions 2
Paths 2

Size

Total Lines 10
Code Lines 7

Duplication

Lines 0
Ratio 0 %

Code Coverage

Tests 0
CRAP Score 6

Importance

Changes 1
Bugs 1 Features 1
Metric Value
cc 2
eloc 7
c 1
b 1
f 1
nc 2
nop 0
dl 0
loc 10
ccs 0
cts 10
cp 0
crap 6
rs 9.4285
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){
0 ignored issues
show
Coding Style Best Practice introduced by
It seems like you are loosely comparing two booleans. Considering using the strict comparison === instead.

When comparing two booleans, it is generally considered safer to use the strict comparison operator.

Loading history...
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
?>