mysql_workspaces_compiler::priv_sql_compile() - Code Metrics - Inspection of "adding loader object" - Ariadne-CMS/ariadne - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — tar-fix ( d474e8...0c2e2e )

unknown

created 2020-02-23 21:14 UTC

mysql_workspaces_compiler::priv_sql_compile() F

↳ Parent: mysql_workspaces_compiler

Complexity

Conditions	16
Paths	3584

Size

Total Lines

103

Duplication

Lines	11
Ratio	10.68 %

Code Coverage

Tests	0
CRAP Score	272

Importance

Changes

Metric	Value
cc	16
nc	3584
nop	1
dl	11
loc	103
rs	1.1198
c	0
b	0
f	0
ccs	0
cts	91
cp	0
crap	272

How to fix Long Method Complexity

<?php
  include_once($this->code."stores/modules/mysql_compiler.php");

class mysql_workspaces_compiler extends mysql_compiler {

	public function __construct (&$store, $tbl_prefix="") {
		debug("mysql_workspaces_compiler($tbl_prefix)", "store");
		$this->tbl_prefix=$tbl_prefix;
		$this->store=$store;
	}

	// mysql specific compiler function
	protected function priv_sql_compile($tree) {
		$this->custom_ref = 0;
		$this->custom_id = 0;
		$this->used_tables=array();
		$this->compile_tree($tree);
		$nodes=$this->tbl_prefix."nodes";
		$objects=$this->tbl_prefix."objects";
		$properties=$this->tbl_prefix."prop_";
		$this->used_tables[$nodes]=$nodes;
		$this->used_tables[$objects]=$objects;
		if ($this->join_target_properties) {

			$this->used_tables[$properties."references as target_reference"] = $properties."references as target_reference";
			$this->used_tables["$nodes as target"] = "$nodes as target";
		}
		@reset($this->used_tables);
		while (list($key, $val)=each($this->used_tables)) {
			if ($tables) {
				$tables.=", $key";
function myFunction($a) {
    switch ($a) {
        case 'foo':
            $x = 1;
            break;

        case 'bar':
            $x = 2;
            break;
    }

    // $x is potentially undefined here.
    echo $x;
}
			} else {
				$tables="$key";
			}
			if ($this->select_tables[$key]) {
				if ($this->join_target_properties[$key]) {
					$prop_dep.=" and $val.object=target.object ";
function myFunction($a) {
    switch ($a) {
        case 'foo':
            $x = 1;
            break;

        case 'bar':
            $x = 2;
            break;
    }

    // $x is potentially undefined here.
    echo $x;
}
				} else {
					$prop_dep.=" and $val.object=$objects.id ";
				}
			}
		}

		$join = "";
		if (is_array($this->nls_join)) {
			reset($this->nls_join);
			while (list($key, $value)=each($this->nls_join)) {
<?php

function returnThreeValues() {
    return array('a', 'b', 'c');
}

list($a, $b, $c) = returnThreeValues();

print $a . " - " . $c;
				$join .= $value;
			}
		}



		$query = " where $nodes.object=$objects.id $prop_dep";
		$query .= " and $nodes.path like '".str_replace('_','\\_',AddSlashes($this->path))."%' ";


		$query_string_layers = "";
		$layering = false;
		foreach ($this->layers as $lPath => $lId) {
class MyClass { }

$x = new MyClass();
$x->foo = true;
			if ($lId) {
				$layering = true;
				if ($query_string_layers) {
					$query_string_layers .= " OR ";
				}
				$query_string_layers .= " ( $nodes.path like '".AddSlashes($lPath)."%' and $nodes.layer = ".((int)$lId)." ) ";
			}
		}
		if ($layering) {
			$query .= " and (
								( $query_string_layers )
							OR
								$nodes.layer = 0
								and $nodes.id NOT IN (
									select $nodes.id from $nodes where ( $query_string_layers )
								)
								and $nodes.path NOT IN (
									select $nodes.path from $nodes where ( $query_string_layers )
								)
						)
			";
		} else {
			$query .= " and $nodes.layer = 0 ";
		}

		if ($this->where_s) {
			$query.=" and ( $this->where_s ) ";
		}
		if ($this->where_s_ext) {
			$query .= " and ($this->where_s_ext) ";
		}
		/* do target join */
		if ($this->join_target_properties) {

			$query .= " and $objects.id = target_reference.object ";
			$query .= " and target.path = target_reference.AR_path ";
		}

		if ($this->orderby_s) {
			$orderby = " order by $this->orderby_s, $nodes.parent ASC, $nodes.priority DESC, $nodes.path ASC ";
		} else {
			$orderby = " order by $nodes.parent ASC, $nodes.priority DESC, $nodes.path ASC ";
		}

		$select_query  = "select distinct($nodes.path), $nodes.id as nodeId, $nodes.layer as nodeLayer, $nodes.parent, $nodes.priority, ";
		$select_query .= "$objects.object, $objects.id, $objects.type, $objects.vtype, ";
		$select_query .= "UNIX_TIMESTAMP($objects.lastchanged) as lastchanged  ";
		$select_query .= "from ($tables) $join $query ";
		$select_query .= $orderby." ".$this->limit_s;

		$count_query   = "select count(distinct($objects.id)) as count from $tables ".$query;

		return array(
			"select_query" => $select_query,
			"count_query"  => $count_query
		);
	}

  }


Push — tar-fix ( d474e8...0c2e2e )

mysql_workspaces_compiler::priv_sql_compile() F

Complexity

Size

Duplication

Code Coverage

Importance

How to fix Long Method Complexity

Long Method

Available Fixes

Available Fixes

1		<?php
2		include_once($this->code."stores/modules/mysql_compiler.php");
3
4		class mysql_workspaces_compiler extends mysql_compiler {
5
6		public function __construct (&$store, $tbl_prefix="") {
7		debug("mysql_workspaces_compiler($tbl_prefix)", "store");
8		$this->tbl_prefix=$tbl_prefix;
9		$this->store=$store;
10		}
11
12		// mysql specific compiler function
13		protected function priv_sql_compile($tree) {
14		$this->custom_ref = 0;
15		$this->custom_id = 0;
16		$this->used_tables=array();
17		$this->compile_tree($tree);
18		$nodes=$this->tbl_prefix."nodes";
19		$objects=$this->tbl_prefix."objects";
20		$properties=$this->tbl_prefix."prop_";
21		$this->used_tables[$nodes]=$nodes;
22		$this->used_tables[$objects]=$objects;
23	View Code Duplication	if ($this->join_target_properties) {
		0 ignored issues – show Bug Best Practice introduced 2015-11-26 08:52 UTC by Report Bug Copy Issue Report The expression `$this->join_target_properties` of type `array<*,string>` is implicitly converted to a boolean; are you sure this is intended? If so, consider using `! empty($expr)` instead to make it clear that you intend to check for an array without elements. This check marks implicit conversions of arrays to boolean values in a comparison. While in PHP an empty array is considered to be equal (but not identical) to false, this is not always apparent. Consider making the comparison explicit by using `empty(..)` or `! empty(...)` instead. Loading history...
24		$this->used_tables[$properties."references as target_reference"] = $properties."references as target_reference";
25		$this->used_tables["$nodes as target"] = "$nodes as target";
26		}
27		@reset($this->used_tables);
28		while (list($key, $val)=each($this->used_tables)) {
29		if ($tables) {
30		$tables.=", $key";
		0 ignored issues – show Bug introduced 2015-11-26 08:52 UTC by Report Bug Copy Issue Report The variable `$tables` does not seem to be defined for all execution paths leading up to this point. If you define a variable conditionally, it can happen that it is not defined for all execution paths. Let’s take a look at an example: function myFunction($a) { switch ($a) { case 'foo': $x = 1; break; case 'bar': $x = 2; break; } // $x is potentially undefined here. echo $x; } In the above example, the variable `$x` is defined if you pass “foo” or “bar” as argument for `$a`. However, since the `switch` statement has no default case statement, if you pass any other value, the variable `$x` would be undefined. Available Fixes Check for existence of the variable explicitly: function myFunction($a) { switch ($a) { case 'foo': $x = 1; break; case 'bar': $x = 2; break; } if (isset($x)) { // Make sure it's always set. echo $x; } } Define a default value for the variable: function myFunction($a) { $x = ''; // Set a default which gets overridden for certain paths. switch ($a) { case 'foo': $x = 1; break; case 'bar': $x = 2; break; } echo $x; } Add a value for the missing path: function myFunction($a) { switch ($a) { case 'foo': $x = 1; break; case 'bar': $x = 2; break; // We add support for the missing case. default: $x = ''; break; } echo $x; } Loading history...
31		} else {
32		$tables="$key";
33		}
34	View Code Duplication	if ($this->select_tables[$key]) {
35		if ($this->join_target_properties[$key]) {
36		$prop_dep.=" and $val.object=target.object ";
		0 ignored issues – show Bug introduced 2015-11-26 08:52 UTC by Report Bug Copy Issue Report The variable `$prop_dep` does not seem to be defined for all execution paths leading up to this point. If you define a variable conditionally, it can happen that it is not defined for all execution paths. Let’s take a look at an example: function myFunction($a) { switch ($a) { case 'foo': $x = 1; break; case 'bar': $x = 2; break; } // $x is potentially undefined here. echo $x; } In the above example, the variable `$x` is defined if you pass “foo” or “bar” as argument for `$a`. However, since the `switch` statement has no default case statement, if you pass any other value, the variable `$x` would be undefined. Available Fixes Check for existence of the variable explicitly: function myFunction($a) { switch ($a) { case 'foo': $x = 1; break; case 'bar': $x = 2; break; } if (isset($x)) { // Make sure it's always set. echo $x; } } Define a default value for the variable: function myFunction($a) { $x = ''; // Set a default which gets overridden for certain paths. switch ($a) { case 'foo': $x = 1; break; case 'bar': $x = 2; break; } echo $x; } Add a value for the missing path: function myFunction($a) { switch ($a) { case 'foo': $x = 1; break; case 'bar': $x = 2; break; // We add support for the missing case. default: $x = ''; break; } echo $x; } Loading history...
37		} else {
38		$prop_dep.=" and $val.object=$objects.id ";
39		}
40		}
41		}
42
43		$join = "";
44		if (is_array($this->nls_join)) {
45		reset($this->nls_join);
46		while (list($key, $value)=each($this->nls_join)) {
		0 ignored issues – show Unused Code introduced 2015-11-26 08:52 UTC by Report Bug Copy Issue Report The assignment to `$key` is unused. Consider omitting it like so `list($first,,$third)`. This checks looks for assignemnts to variables using the `list(...)` function, where not all assigned variables are subsequently used. Consider the following code example. <?php function returnThreeValues() { return array('a', 'b', 'c'); } list($a, $b, $c) = returnThreeValues(); print $a . " - " . $c; Only the variables `$a` and `$c` are used. There was no need to assign `$b`. Instead, the list call could have been. list($a,, $c) = returnThreeValues(); Loading history...
47		$join .= $value;
48		}
49		}
50
51
52
53		$query = " where $nodes.object=$objects.id $prop_dep";
54		$query .= " and $nodes.path like '".str_replace('_','\\_',AddSlashes($this->path))."%' ";
55
56
57		$query_string_layers = "";
58		$layering = false;
59		foreach ($this->layers as $lPath => $lId) {
		0 ignored issues – show Bug introduced 2015-11-26 08:52 UTC by Report Bug Copy Issue Report The property `layers` does not exist. Did you maybe forget to declare it? In PHP it is possible to write to properties without declaring them. For example, the following is perfectly valid PHP code: class MyClass { } $x = new MyClass(); $x->foo = true; Generally, it is a good practice to explictly declare properties to avoid accidental typos and provide IDE auto-completion: class MyClass { public $foo; } $x = new MyClass(); $x->foo = true; Loading history...
60		if ($lId) {
61		$layering = true;
62		if ($query_string_layers) {
63		$query_string_layers .= " OR ";
64		}
65		$query_string_layers .= " ( $nodes.path like '".AddSlashes($lPath)."%' and $nodes.layer = ".((int)$lId)." ) ";
66		}
67		}
68		if ($layering) {
69		$query .= " and (
70		( $query_string_layers )
71		OR
72		$nodes.layer = 0
73		and $nodes.id NOT IN (
74		select $nodes.id from $nodes where ( $query_string_layers )
75		)
76		and $nodes.path NOT IN (
77		select $nodes.path from $nodes where ( $query_string_layers )
78		)
79		)
80		";
81		} else {
82		$query .= " and $nodes.layer = 0 ";
83		}
84
85		if ($this->where_s) {
86		$query.=" and ( $this->where_s ) ";
87		}
88		if ($this->where_s_ext) {
89		$query .= " and ($this->where_s_ext) ";
90		}
91		/* do target join */
92		if ($this->join_target_properties) {
		0 ignored issues – show Bug Best Practice introduced 2015-11-26 08:52 UTC by Report Bug Copy Issue Report The expression `$this->join_target_properties` of type `array<*,string>` is implicitly converted to a boolean; are you sure this is intended? If so, consider using `! empty($expr)` instead to make it clear that you intend to check for an array without elements. This check marks implicit conversions of arrays to boolean values in a comparison. While in PHP an empty array is considered to be equal (but not identical) to false, this is not always apparent. Consider making the comparison explicit by using `empty(..)` or `! empty(...)` instead. Loading history...
93		$query .= " and $objects.id = target_reference.object ";
94		$query .= " and target.path = target_reference.AR_path ";
95		}
96
97		if ($this->orderby_s) {
98		$orderby = " order by $this->orderby_s, $nodes.parent ASC, $nodes.priority DESC, $nodes.path ASC ";
99		} else {
100		$orderby = " order by $nodes.parent ASC, $nodes.priority DESC, $nodes.path ASC ";
101		}
102
103		$select_query = "select distinct($nodes.path), $nodes.id as nodeId, $nodes.layer as nodeLayer, $nodes.parent, $nodes.priority, ";
104		$select_query .= "$objects.object, $objects.id, $objects.type, $objects.vtype, ";
105		$select_query .= "UNIX_TIMESTAMP($objects.lastchanged) as lastchanged ";
106		$select_query .= "from ($tables) $join $query ";
107		$select_query .= $orderby." ".$this->limit_s;
108
109		$count_query = "select count(distinct($objects.id)) as count from $tables ".$query;
110
111		return array(
112		"select_query" => $select_query,
113		"count_query" => $count_query
114		);
115		}
116
117		}
118

Ariadne-CMS / ariadne

Push — tar-fix ( d474e8...0c2e2e )

mysql_workspaces_compiler::priv_sql_compile() F

Complexity

Size

Duplication

Code Coverage

Importance

How to fix Long Method Complexity

Long Method

Available Fixes

Available Fixes

Duplication Side-by-Side

Filter issues like