Controller::get_affected_id() - Code Metrics - adamjakab/SuiteCRM - Measure and Improve Code Quality continuously with Scrutinizer

Controller::get_affected_id() A
last analyzed 2016-05-10 08:39 UTC

↳ Parent: Controller

Complexity

Conditions	3
Paths	4

Size

Total Lines	23
Code Lines	11

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	0
CRAP Score	12

Metric	Value
cc	3
eloc	11
nc	4
nop	3
dl	0
loc	23
ccs	0
cts	15
cp	0
crap	12
rs	9.0856

<?php
if(!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point');
/*********************************************************************************
 * SugarCRM Community Edition is a customer relationship management program developed by
 * SugarCRM, Inc. Copyright (C) 2004-2013 SugarCRM Inc.

 * SuiteCRM is an extension to SugarCRM Community Edition developed by Salesagility Ltd.
 * Copyright (C) 2011 - 2014 Salesagility Ltd.
 *
 * This program is free software; you can redistribute it and/or modify it under
 * the terms of the GNU Affero General Public License version 3 as published by the
 * Free Software Foundation with the addition of the following permission added
 * to Section 15 as permitted in Section 7(a): FOR ANY PART OF THE COVERED WORK
 * IN WHICH THE COPYRIGHT IS OWNED BY SUGARCRM, SUGARCRM DISCLAIMS THE WARRANTY
 * OF NON INFRINGEMENT OF THIRD PARTY RIGHTS.
 *
 * This program is distributed in the hope that it will be useful, but WITHOUT
 * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
 * FOR A PARTICULAR PURPOSE.  See the GNU Affero General Public License for more
 * details.
 *
 * You should have received a copy of the GNU Affero General Public License along with
 * this program; if not, see http://www.gnu.org/licenses or write to the Free
 * Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
 * 02110-1301 USA.
 *
 * You can contact SugarCRM, Inc. headquarters at 10050 North Wolfe Road,
 * SW2-130, Cupertino, CA 95014, USA. or at email address [email protected].
 *
 * The interactive user interfaces in modified source and object code versions
 * of this program must display Appropriate Legal Notices, as required under
 * Section 5 of the GNU Affero General Public License version 3.
 *
 * In accordance with Section 7(b) of the GNU Affero General Public License version 3,
 * these Appropriate Legal Notices must retain the display of the "Powered by
 * SugarCRM" logo and "Supercharged by SuiteCRM" logo. If the display of the logos is not
 * reasonably feasible for  technical reasons, the Appropriate Legal Notices must
 * display the words  "Powered by SugarCRM" and "Supercharged by SuiteCRM".
 ********************************************************************************/

/*********************************************************************************

 * Description:
 ********************************************************************************/








class Controller extends SugarBean {

	var $focus;
	var $type;  //defines id this is a new list order or existing, or delete
				// New, Save, Delete

	public function __construct() {
		parent::__construct();

		$this->disable_row_level_security =true;

	}

    /**
     * @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
     */
    public function Controller(){
        $deprecatedMessage = 'PHP4 Style Constructors are deprecated and will be remove in 7.8, please update your code';
        if(isset($GLOBALS['log'])) {
            $GLOBALS['log']->deprecated($deprecatedMessage);
        }
        else {
            trigger_error($deprecatedMessage, E_USER_DEPRECATED);
        }
        self::__construct();
    }


	function init(& $seed_object, $type){

		$this->focus = & $seed_object;
		$this->type = $type;

	//end function Controller
	}

	function change_component_order($magnitude, $direction, $parent_id=""){

		if(!empty($this->type) && $this->type=="Save"){

			//safety check
			$wall_test = $this->check_wall($magnitude, $direction, $parent_id);

			if($wall_test==false){

				return;
			}


				if($direction=="Left"){
					if($this->focus->controller_def['list_x']=="Y"){
						$new_x = $this->focus->list_order_x -1;
						$affected_x = $this->focus->list_order_x;
					} else {
						$new_x = "";
						$affected_x = "";
					}
					if($this->focus->controller_def['list_y']=="Y"){

						$new_y = $this->focus->list_order_y;
						$affected_y = $this->focus->list_order_y;
					} else {
						$new_y = "";
						$affected_y = "";
					}

					$affected_id = $this->get_affected_id($parent_id, $new_x, $new_y);
				//end if direction Left
				}
				if($direction=="Right"){

					if($this->focus->controller_def['list_x']=="Y"){
						$new_x = $this->focus->list_order_x + 1;
						$affected_x = $this->focus->list_order_x;
					} else {
						$new_x = "";
						$affected_x = "";
					}
					if($this->focus->controller_def['list_y']=="Y"){
						$new_y = $this->focus->list_order_y;
						$affected_y = $this->focus->list_order_y;
					} else {
						$new_y = "";
						$affected_y = "";
					}
					$affected_id = $this->get_affected_id($parent_id, $new_x, $new_y);
				//end if direction Right
				}

				if($direction=="Up"){
					if($this->focus->controller_def['list_x']=="Y"){
						$new_x = $this->focus->list_order_x;
						$affected_x = $this->focus->list_order_x;
					} else {
						$new_x = "";
						$affected_x = "";
					}
					if($this->focus->controller_def['list_y']=="Y"){

					$new_y = $this->focus->list_order_y - 1;
					$affected_y = $this->focus->list_order_y;
					} else {
						$new_y = "";
						$affected_y = "";
					}

					$affected_id = $this->get_affected_id($parent_id, $new_x, $new_y);

				//end if direction Up
				}
				if($direction=="Down"){

					if($this->focus->controller_def['list_x']=="Y"){
						$new_x = $this->focus->list_order_x;
						$affected_x = $this->focus->list_order_x;
					} else {
						$new_x = "";
						$affected_x = "";
					}
					if($this->focus->controller_def['list_y']=="Y"){

						$new_y = $this->focus->list_order_y + 1;
						$affected_y = $this->focus->list_order_y;
					} else {
						$new_y = "";
						$affected_y = "";
					}
					$affected_id = $this->get_affected_id($parent_id, $new_x, $new_y);
				//end if direction Down
				}

			//This takes care of the component being pushed out of its position
			$this->update_affected_order($affected_id, $affected_x, $affected_y);

				//This takes care of the new positions for itself
			if($this->focus->controller_def['list_x']=="Y"){
				$this->focus->list_order_x = $new_x;
			}

			if($this->focus->controller_def['list_y']=="Y"){
				$this->focus->list_order_y = $new_y;
			}

		} else {
		//this is a new component, set the x or y value to the max + 1

				$query = "SELECT MAX(".$this->focus->controller_def['start_var'].") max_start from ".$this->focus->table_name."
						  WHERE ".$this->focus->controller_def['parent_var']."='$parent_id'
						  AND ".$this->focus->table_name.".deleted='0'
						 ";
				$result = $this->db->query($query,true," Error capturing max start order: ");
				$row = $this->db->fetchByAssoc($result);

			if(!is_null($row['max_start'])){

				if($this->focus->controller_def['start_axis']=="x")	{
					$this->focus->list_order_x = $row['max_start'] + 1;
					if($this->focus->controller_def['list_y']=="Y") $this->focus->list_order_y = 0;
				}

				if($this->focus->controller_def['start_axis']=="y")	{
					$this->focus->list_order_y = $row['max_start'] + 1;
					if($this->focus->controller_def['list_x']=="Y") $this->focus->list_order_x = 0;
				}

			} else {
				//first row
				if($this->focus->controller_def['list_x']=="Y") $this->focus->list_order_x = 0;
				if($this->focus->controller_def['list_y']=="Y") $this->focus->list_order_y = 0;

			//end if else to check if this is first entry
			}
		//end if else on whether this is a new entry
		}
	//end function change_component_order
	}

	function update_affected_order($affected_id, $affected_new_x="", $affected_new_y=""){

		$query = 	"UPDATE ".$this->focus->table_name." SET";

		if($this->focus->controller_def['list_x']=="Y"){
				$query .= 	"	 list_order_x='$affected_new_x'";
		}
		if($this->focus->controller_def['list_y']=="Y"){

			if($this->focus->controller_def['list_x']=="Y"){
				$query .= 	"	, ";
			}
			$query .= 	"	list_order_y='$affected_new_y'";
		}

		$query .=	"	WHERE id='$affected_id'";
		$query .=   "	AND ".$this->focus->table_name.".deleted='0'";
		$result = $this->db->query($query,true," Error updating affected order id: ");
	//end function update_affected_order
	}

	function get_affected_id($parent_id, $list_order_x="", $list_order_y=""){

		$query = "	SELECT id from ".$this->focus->table_name."
					WHERE ".$this->focus->controller_def['parent_var']."='$parent_id'
					AND ".$this->focus->table_name.".deleted='0'
					";

		if($this->focus->controller_def['list_x']=="Y"){
			$query .= "	AND list_order_x='$list_order_x' ";
		}

		if($this->focus->controller_def['list_y']=="Y"){
			$query .= "	AND list_order_y='$list_order_y' ";
		}

	//echo $query."<BR>";
		$result = $this->db->query($query,true," Error capturing affected id: ");
		$row = $this->db->fetchByAssoc($result);

		return $row['id'];

	//end function get_affected_id
	}


/////////////Wall Functions////////////////////


function check_wall($magnitude, $direction, $parent_id){

//TODO: jgreen - this is only single axis check_wall mechanism, will need to upgrade this to double axis
//This function determines if you can't move the direction you want, because you are at the edge


//If down or Right, then check max list_order value
	if($direction=="Down" || $direction =="Right"){

		$query = "SELECT MAX(".$this->focus->controller_def['start_var'].") max_start from ".$this->focus->table_name."
				  WHERE ".$this->focus->controller_def['parent_var']."='$parent_id'
				  AND ".$this->focus->table_name.".deleted='0'
						 ";
		$result = $this->db->query($query,true," Error capturing max start order: ");
		$row = $this->db->fetchByAssoc($result);

			if($this->focus->controller_def['start_axis']=="x")	{
				if($row['max_start'] == $this->focus->list_order_x){
					return false;
				}
			}
			if($this->focus->controller_def['start_axis']=="y")	{
				if($row['max_start'] == $this->focus->list_order_y){
					return false;
				}
			}
	//end if up or right
	}

//If up or left, then simply check the 0 value
	if($direction=="Up" || $direction =="Left"){
			if($this->focus->controller_def['start_axis']=="x")	{
				if($this->focus->list_order_x==0){
					return false;
				}
			}
			if($this->focus->controller_def['start_axis']=="y")	{
				if($this->focus->list_order_y==0){
					return false;
				}
			}

	//end if down or left
	}

	//If you get here, then you are not at the wall and can change order
	return true;

//end function check_wall
}

//End Wall Functions/////////////////////////

//Delete adjust functions////////////////////


function delete_adjust_order($parent_id){


	//Currently handles single axis motion only!!!!!!!!!
	//TODO: jgreen - Add dual axis motion

	//adjust along start_axis
	$variable_name = $this->focus->controller_def['start_var'];
	$current_position = $this->focus->$variable_name;

	$query =  "UPDATE ".$this->focus->table_name." ";
	$query .= "SET ".$this->focus->controller_def['start_var']." = ".$this->focus->controller_def['start_var']." - 1 ";
	$query .= "WHERE ".$this->focus->controller_def['start_var']." > ".$current_position." AND deleted=0 ";
	$query .= "AND ".$this->focus->controller_def['parent_var']." = '".$parent_id."'";

	$result = $this->db->query($query,true," Error updating the delete_adjust_order: ");
//end delete_adjust_order
}
//End Delete Functions/////////////////////////
//end class Controller
}

?>

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 2016-03-07 17:58 UTC by Report Bug Copy Issue Report 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			?>

adamjakab / SuiteCRM

Controller::get_affected_id() A last analyzed 2016-05-10 08:39 UTC

Complexity

Size

Duplication

Code Coverage

Duplication Side-by-Side

Filter issues like

Controller::get_affected_id() A
last analyzed 2016-05-10 08:39 UTC