mysql_compiler::priv_sql_compile() - Code Metrics - Inspection of "Merge pull request #117 from mjrider/artemplate" - Ariadne-CMS/ariadne - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — master ( 7665c8...9af7b9 )

by Robbert

created 2016-05-27 12:28 UTC

mysql_compiler::priv_sql_compile() F

↳ Parent: mysql_compiler

Complexity

Conditions	13
Paths	513

Size

Total Lines	73
Code Lines	50

Duplication

Lines	16
Ratio	21.92 %

Code Coverage

Tests	44
CRAP Score	17.1345

Importance

Changes

Metric	Value
cc	13
eloc	50
c	0
b	0
f	0
nc	513
nop	1
dl	16
loc	73
ccs	44
cts	62
cp	0.7097
crap	17.1345
rs	3.3629

How to fix Long Method Complexity

<?php

  include_once($this->code."stores/modules/sql_compiler.php");

class mysql_compiler extends sql_compiler {
	protected $tbl_prefix;
	protected $store;
	protected $in_orderby;
	protected $nls_join;
	protected $select_tables;
	protected $used_tables;
	protected $custom_id;
	protected $custom_ref;
	protected $used_custom_fields;
	protected $where_s_ext;
	protected $fulltext_expr;
	protected $where_s;
	protected $limit_s;
	protected $orderby_s;


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

	protected function compile_tree(&$node, $arguments=null) {
		if ($arguments) {
			extract($arguments);
		}
		switch ((string)$node["id"]) {
			case 'property':
				$table=$this->tbl_prefix.$node["table"];
				$field=$node["field"];
				$record_id=$node["record_id"];
				if (!$record_id) {
					if ($this->in_orderby && $node["nls"]) {
						/*
							we do a left join so that we will also find non
							matching objects
						*/
						$objects_table = $this->tbl_prefix."objects";
						$aliastable = $table.$node['nls'];
						$this->nls_join[$table.$node['nls']] = "left join $table as order_$aliastable on $objects_table.id=order_$aliastable.object and order_$aliastable.AR_nls='".$node["nls"]."' ";
						$result = " order_$aliastable.$field ";
					} else {
						/*
							if we are parsing 'orderby' properties we have
							to join our tables for the whole query
						*/
						$this->select_tables[$table]=$table;
						$this->used_tables[$table]=$table;
						$result=" $table.$field ";
					}
				} else {
					$this->used_tables["$table as $table$record_id"] = $table.$record_id;
					if (!$this->in_orderby && !$no_context_join) {
						if ($this->join_target_properties[$node["table"]][":$record_id"]) {
							$result=" $table$record_id.object = target.object and $table$record_id.$field ";
						} else {
							$result=" $table$record_id.object = ".$this->tbl_prefix."objects.id and $table$record_id.$field ";
						}
					} else {
						if ($this->join_target_properties[$node["table"]]) {
							$this->join_target_properties["$table as $table$record_id"] = $table.$record_id;
						}
						$this->select_tables["$table as $table$record_id"] = $table.$record_id;
						$result=" $table$record_id.$field ";
					}
				}
			break;
			case 'ident':
				$table=$this->tbl_prefix.$node["table"];
				$field=$node["field"];
				$this->used_tables[$table]=$table;
				$result=" $table.$field ";
			break;
			case 'custom':
				$table = $this->tbl_prefix."prop_custom";
				$field = $node["field"];
				$nls = $node["nls"];
				$record_id = $node["record_id"];
				/*
					when we are compiling orderby properties we always want
					to assign it to a new table alias
				*/
				if ($this->in_orderby) {
					$this->custom_id++;
				}
				$this->custom_ref++;
				if (!$record_id) {
					$this->used_tables[$table." as $table".$this->custom_id] = $table.$this->custom_id;
					$this->select_tables[$table." as $table".$this->custom_id] = 1;

					$this->used_custom_fields[$field] = true;
					$result = " $table".$this->custom_id.".AR_name = '$field' ";
					if ($nls) {
						$result = " $result and $table".$this->custom_id.".AR_nls = '$nls' ";
					}

					if (!$this->in_orderby) {
						$result = " $result and $table".$this->custom_id.".AR_value ";
					} else {
						$this->where_s_ext = $result;
						$result = " $table".$this->custom_id.".AR_value ";
					}
				} else {
					$this->used_tables["$table as $table$record_id"] = $table.$record_id;
					//$this->select_tables[$table." as $table$record_id"] = 1;


					$result = " $table$record_id.AR_name = '$field' ";
					if (!$this->in_orderby && !$no_context_join) {
						if ($this->join_target_properties["prop_my"][":$record_id"]) {
							$result=" $result and $table$record_id.object = target.object and $table$record_id.AR_value ";
						} else {
							$result=" $table$record_id.object = ".$this->tbl_prefix."objects.id and $table$record_id.AR_value ";
						}
					} else {
						if ($this->join_target_properties[$node["table"]]) {
							$this->join_target_properties["$table as $table$record_id"] = $table.$record_id;
						}
						$this->select_tables["$table as $table$record_id"] = $table.$record_id;
						$result=" $table$record_id.AR_value ";
					}
				}
			break;
			case 'string':
				$result = "'".addSlashes($node["value"])."'";
				if ($escape_chars) {
					$result = preg_replace('/([^\\\])_/', '\\1\_', $result);
				}
				return $result;
			break;
			case 'float':
			case 'int':
				$result=$node["value"];
			break;
			case 'and':
				$cr = $this->custom_ref;
				$left=$this->compile_tree($node["left"]);
				if ($this->custom_ref > $cr) {
					$this->custom_id++;
				}

				$right=$this->compile_tree($node["right"]);
				$cr = $this->custom_ref;
				if ($this->custom_ref > $cr) {
					$this->custom_id++;
				}
				$result=" $left and $right ";
			break;
			case 'or':
				$left=$this->compile_tree($node["left"]);
				$right=$this->compile_tree($node["right"]);
				$result=" $left or $right ";
			break;
			case 'cmp':
				$not="";
				switch ($node["operator"]) {
					case '=':
					case '==':
						$operator="=";
					break;
					case '!=':
					case '<=':
					case '>=':
					case '<':
					case '>':
						$operator=$node["operator"];
					break;
					case '!~':
					case '!~~':

						$not="NOT ";
					case '~=':
					case '=~':
					case '=~~':
						$likeOp = true;
						$operator=$not."LIKE";
						/* double tildes indicate case-sensitive */
						if (strlen($operator)==3) {
							$operator.=" BINARY";
						}
					break;
					case '!/':
					case '!//':

						$not="NOT ";
					case '=/':
					case '=//':
						$operator=$not."REGEXP";
						/* double slashes indicate case-sensitive */
						if (strlen($operator)==3) {
							$operator.=" BINARY";
						}
					break;
					case '!*':
					case '!**':

						$not = " not";
					case '=*':
					case '=**':
						if ($node["left"]["id"]!=="implements" && $this->store->is_supported("fulltext")) {
							$left=$this->compile_tree($node["left"], array("no_context_join" => true));
							$right=$this->compile_tree($node["right"]);
							/* fulltext search operators: =*, !*, =**, !** */
							$operator = $node["operator"];
							$query = stripslashes(substr($right,1,-1));
							if (strlen($operator)==3 && $this->store->is_supported("fulltext_boolean")) {
								/* double asterisks indicate boolean mode */
								/* make sure the operators are not formatted_for_fti */
								$storeclass=get_class($this->store);
								$query = preg_replace(
										'%(^|\s)([-+~<>(]*)("([^"]*)"|([^ "*]*))([)*]?)%e',
										"'\\1\\2'.('\\4'?'\"'.$storeclass::format_for_fti('\\4').'\"':$storeclass::format_for_fti('\\5')).'\\6'",
										$query);
								$boolmode = " in boolean mode";
							} else {
								$boolmode = "";
								$query = $this->store->format_for_fti($query);
							}
							$result = "$not match ($left) against ('$query'$boolmode) ";
							$this->fulltext_expr[':'.$node["right"]["record_id"]] = $result;
							return $result;
						}
					break;
				}
				if ($node["left"]["id"]!=="implements") {
					$left=$this->compile_tree($node["left"]);
					if ($likeOp) {
						$right=$this->compile_tree($node["right"], array('escape_chars' => true));
					} else {
						$right=$this->compile_tree($node["right"]);
					}
					/* lastchanged == unixtimestamp -> lastchanged == 200201.. */
					if ($node["left"]["field"]=="lastchanged") {
						$right = date("YmdHis", $right);
					}
					$result=" $left $operator $right ";
				} else {
					$type = $this->compile_tree($node["right"]);
					switch ($operator) {
						case '!=':
							$result=" (".$this->tbl_prefix."objects.type not in (select type from ".$this->tbl_prefix."types where implements = $type )) ";
						break;
						default:
							$result=" ( SUBSTRING_INDEX(".$this->tbl_prefix."objects.vtype, '.', 1) in (select type from ".$this->tbl_prefix."types where implements $operator $type )) ";
						break;
					}
				}
			break;
			case 'group':
				$left=$this->compile_tree($node["left"]);
				if ($left) {
					$result=" ( $left ) ";
				}
			break;

			case 'orderby':
				$result=$this->compile_tree($node["left"]);
				$this->orderby_s=$this->compile_tree($node["right"]);
			break;

			case 'orderbyfield':
				$this->in_orderby = true;
				$left=$this->compile_tree($node["left"]);
				if ( $node["right"]["field"] != "none" ) {
					if ($node["right"]["field"] == 'AR_relevance' && $this->store->is_supported("fulltext")) {
						$right = $this->fulltext_expr[':'.$node["right"]["record_id"]];
					} else {
						$right=$this->compile_tree($node["right"]);
					}
					if ($left) {
						$result=" $left ,  $right ".$node["type"]." ";
					} else {
						$result=" $right ".$node["type"]." ";
					}
				} else {
					$result = "";
					if ($left) {
						$result = " $left ";
					}
					$this->skipDefaultOrderBy = true;
				}
			break;

			case 'limit':
				$this->where_s=$this->compile_tree($node["left"]);
				if ($node["limit"]) {
					$this->limit_s=" limit ".(int)$node["offset"].", ".$node["limit"]." ";
				} else if ($node["offset"]) {
					$this->limit_s=" limit ".(int)$node["offset"]." ";
				} else {
					if ($this->limit) {
						$offset = (int)$this->offset;
						$this->limit_s=" limit $offset, ".(int)$this->limit." ";
					}
				}
			break;
		}
		return $result;
	}

	// 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);

		$prop_dep = '';
		$query = '';
		$orderby = '';

		if ( $this->error ) {
			return null;
		}

		$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";
		}

		$tables = implode(', ',array_keys($this->used_tables));
		foreach ( $this->used_tables as $key => $val){
			if ($this->select_tables[$key]) {
				if ($this->join_target_properties[$key]) {
					$prop_dep.=" and $val.object=target.object ";
				} else {
					$prop_dep.=" and $val.object=$objects.id ";
				}
			}
		}

		$join = "";
		if (is_array($this->nls_join)) {
			$join = implode("", $this->nls_join);
		}

		$query.=" where $nodes.object=$objects.id $prop_dep";
		$query.=" and $nodes.path like '".str_replace('_','\\_',AddSlashes($this->path))."%' ";
		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) {
			if ($this->skipDefaultOrderBy) {
				$orderby = " order by $this->orderby_s ";
			} else {
				$orderby = " order by $this->orderby_s, $nodes.parent ASC, $nodes.priority DESC, $nodes.path ASC ";
			}
		} else if (!$this->skipDefaultOrderBy) {
			$orderby = " order by $nodes.parent ASC, $nodes.priority DESC, $nodes.path ASC ";
		}

		$select_query = "select distinct($nodes.path), $objects.id, $nodes.parent, $nodes.priority, $objects.type, ".
		                " UNIX_TIMESTAMP($objects.lastchanged) as lastchanged, $objects.vtype ";
		$select_query .= "from ($tables) $join $query ";

		$select_query .= $orderby . " $this->limit_s ";
		$count_query = "select count(distinct($nodes.path)) as count from $tables ".$query;

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

  }


1			<?php
			0 ignored issues – show Coding Style Compatibility introduced 2016-02-15 09:55 UTC by Report Bug Copy Issue Report For compatibility and reusability of your code, PSR1 recommends that a file should introduce either new symbols (like classes, functions, etc.) or have side-effects (like outputting something, or including other files), but not both at the same time. The first symbol is defined on line 4 and the first side effect is on line 2. The PSR-1: Basic Coding Standard recommends that a file should either introduce new symbols, that is classes, functions, constants or similar, or have side effects. Side effects are anything that executes logic, like for example printing output, changing ini settings or writing to a file. The idea behind this recommendation is that merely auto-loading a class should not change the state of an application. It also promotes a cleaner style of programming and makes your code less prone to errors, because the logic is not spread out all over the place. To learn more about the PSR-1, please see the PHP-FIG site on the PSR-1. Loading history...
2			include_once($this->code."stores/modules/sql_compiler.php");
3
4			class mysql_compiler extends sql_compiler {
5			protected $tbl_prefix;
6			protected $store;
7			protected $in_orderby;
8			protected $nls_join;
9			protected $select_tables;
10			protected $used_tables;
11			protected $custom_id;
12			protected $custom_ref;
13			protected $used_custom_fields;
14			protected $where_s_ext;
15			protected $fulltext_expr;
16			protected $where_s;
17			protected $limit_s;
18			protected $orderby_s;
19
20
21	54		public function __construct (&$store, $tbl_prefix="") {
22	54		debug("mysql_compiler($tbl_prefix)", "store");
23	54		$this->tbl_prefix=$tbl_prefix;
24	54		$this->store=$store;
25	54		}
26
27	99		protected function compile_tree(&$node, $arguments=null) {
28	99		if ($arguments) {
29			extract($arguments);
30			}
31	99		switch ((string)$node["id"]) {
32	99		case 'property':
33	94		$table=$this->tbl_prefix.$node["table"];
34	94		$field=$node["field"];
35	94		$record_id=$node["record_id"];
36	94		if (!$record_id) {
37	94	View Code Duplication	if ($this->in_orderby && $node["nls"]) {
38			/*
39			we do a left join so that we will also find non
40			matching objects
41			*/
42			$objects_table = $this->tbl_prefix."objects";
43			$aliastable = $table.$node['nls'];
44			$this->nls_join[$table.$node['nls']] = "left join $table as order_$aliastable on $objects_table.id=order_$aliastable.object and order_$aliastable.AR_nls='".$node["nls"]."' ";
45			$result = " order_$aliastable.$field ";
46			} else {
47			/*
48			if we are parsing 'orderby' properties we have
49			to join our tables for the whole query
50			*/
51	94		$this->select_tables[$table]=$table;
52	94		$this->used_tables[$table]=$table;
53	94		$result=" $table.$field ";
54			}
55	94		} else {
56			$this->used_tables["$table as $table$record_id"] = $table.$record_id;
57			if (!$this->in_orderby && !$no_context_join) {
58			if ($this->join_target_properties[$node["table"]][":$record_id"]) {
59			$result=" $table$record_id.object = target.object and $table$record_id.$field ";
60			} else {
61			$result=" $table$record_id.object = ".$this->tbl_prefix."objects.id and $table$record_id.$field ";
62			}
63			} else {
64			if ($this->join_target_properties[$node["table"]]) {
65			$this->join_target_properties["$table as $table$record_id"] = $table.$record_id;
66			}
67			$this->select_tables["$table as $table$record_id"] = $table.$record_id;
68			$result=" $table$record_id.$field ";
69			}
70			}
71	94		break;
72	99	View Code Duplication	case 'ident':
73	3		$table=$this->tbl_prefix.$node["table"];
74	3		$field=$node["field"];
75	3		$this->used_tables[$table]=$table;
76	3		$result=" $table.$field ";
77	3		break;
78	99	View Code Duplication	case 'custom':
79			$table = $this->tbl_prefix."prop_custom";
80			$field = $node["field"];
81			$nls = $node["nls"];
82			$record_id = $node["record_id"];
83			/*
84			when we are compiling orderby properties we always want
85			to assign it to a new table alias
86			*/
87			if ($this->in_orderby) {
88			$this->custom_id++;
89			}
90			$this->custom_ref++;
91			if (!$record_id) {
92			$this->used_tables[$table." as $table".$this->custom_id] = $table.$this->custom_id;
93			$this->select_tables[$table." as $table".$this->custom_id] = 1;
94
95			$this->used_custom_fields[$field] = true;
96			$result = " $table".$this->custom_id.".AR_name = '$field' ";
97			if ($nls) {
98			$result = " $result and $table".$this->custom_id.".AR_nls = '$nls' ";
99			}
100
101			if (!$this->in_orderby) {
102			$result = " $result and $table".$this->custom_id.".AR_value ";
103			} else {
104			$this->where_s_ext = $result;
105			$result = " $table".$this->custom_id.".AR_value ";
106			}
107			} else {
108			$this->used_tables["$table as $table$record_id"] = $table.$record_id;
109			//$this->select_tables[$table." as $table$record_id"] = 1;
			0 ignored issues – show Unused Code Comprehensibility introduced 2016-02-15 09:55 UTC by Report Bug Copy Issue Report `62%` of this comment could be valid code. Did you maybe forget this after debugging? Sometimes obsolete code just ends up commented out instead of removed. In this case it is better to remove the code once you have checked you do not need it. The code might also have been commented out for debugging purposes. In this case it is vital that someone uncomments it again or your project may behave in very unexpected ways in production. This check looks for comments that seem to be mostly valid code and reports them. Loading history...
110
111			$result = " $table$record_id.AR_name = '$field' ";
112			if (!$this->in_orderby && !$no_context_join) {
113			if ($this->join_target_properties["prop_my"][":$record_id"]) {
114			$result=" $result and $table$record_id.object = target.object and $table$record_id.AR_value ";
115			} else {
116			$result=" $table$record_id.object = ".$this->tbl_prefix."objects.id and $table$record_id.AR_value ";
117			}
118			} else {
119			if ($this->join_target_properties[$node["table"]]) {
120			$this->join_target_properties["$table as $table$record_id"] = $table.$record_id;
121			}
122			$this->select_tables["$table as $table$record_id"] = $table.$record_id;
123			$result=" $table$record_id.AR_value ";
124			}
125			}
126			break;
127	99		case 'string':
128	94		$result = "'".addSlashes($node["value"])."'";
129	94		if ($escape_chars) {
130			$result = preg_replace('/([^\\\])_/', '\\1\_', $result);
131			}
132	94		return $result;
133			break;
134	99		case 'float':
135	99		case 'int':
136	2		$result=$node["value"];
137	2		break;
138	99	View Code Duplication	case 'and':
139	92		$cr = $this->custom_ref;
140	92		$left=$this->compile_tree($node["left"]);
141	92		if ($this->custom_ref > $cr) {
142			$this->custom_id++;
143			}
144
145	92		$right=$this->compile_tree($node["right"]);
146	92		$cr = $this->custom_ref;
147	92		if ($this->custom_ref > $cr) {
148			$this->custom_id++;
149			}
150	92		$result=" $left and $right ";
151	92		break;
152	99	View Code Duplication	case 'or':
153			$left=$this->compile_tree($node["left"]);
154			$right=$this->compile_tree($node["right"]);
155			$result=" $left or $right ";
156			break;
157	99		case 'cmp':
158	96		$not="";
159	96		switch ($node["operator"]) {
160	96		case '=':
161	96		case '==':
162	96		$operator="=";
163	96		break;
164			case '!=':
165			case '<=':
166			case '>=':
167			case '<':
168			case '>':
169			$operator=$node["operator"];
170			break;
171			case '!~':
172			case '!~~':
			0 ignored issues – show Coding Style introduced 2015-11-26 08:52 UTC by Report Bug Copy Issue Report There must be a comment when fall-through is intentional in a non-empty case body Loading history...
173			$not="NOT ";
174			case '~=':
175			case '=~':
176			case '=~~':
177			$likeOp = true;
178			$operator=$not."LIKE";
179			/* double tildes indicate case-sensitive */
180			if (strlen($operator)==3) {
181			$operator.=" BINARY";
182			}
183			break;
184			case '!/':
185			case '!//':
			0 ignored issues – show Coding Style introduced 2015-11-26 08:52 UTC by Report Bug Copy Issue Report There must be a comment when fall-through is intentional in a non-empty case body Loading history...
186			$not="NOT ";
187			case '=/':
188			case '=//':
189			$operator=$not."REGEXP";
190			/* double slashes indicate case-sensitive */
191			if (strlen($operator)==3) {
192			$operator.=" BINARY";
193			}
194			break;
195			case '!*':
196			case '!**':
			0 ignored issues – show Coding Style introduced 2015-11-26 08:52 UTC by Report Bug Copy Issue Report There must be a comment when fall-through is intentional in a non-empty case body Loading history...
197			$not = " not";
198			case '=*':
199			case '=**':
200			if ($node["left"]["id"]!=="implements" && $this->store->is_supported("fulltext")) {
201			$left=$this->compile_tree($node["left"], array("no_context_join" => true));
202			$right=$this->compile_tree($node["right"]);
203			/* fulltext search operators: =, !, =, ! */
204			$operator = $node["operator"];
205			$query = stripslashes(substr($right,1,-1));
206			if (strlen($operator)==3 && $this->store->is_supported("fulltext_boolean")) {
207			/* double asterisks indicate boolean mode */
208			/* make sure the operators are not formatted_for_fti */
209			$storeclass=get_class($this->store);
210			$query = preg_replace(
211			'%(^\|\s)([-+~<>(])("([^"])"\|([^ "]))([)*]?)%e',
212			"'\\1\\2'.('\\4'?'\"'.$storeclass::format_for_fti('\\4').'\"':$storeclass::format_for_fti('\\5')).'\\6'",
213			$query);
214			$boolmode = " in boolean mode";
215			} else {
216			$boolmode = "";
217			$query = $this->store->format_for_fti($query);
218			}
219			$result = "$not match ($left) against ('$query'$boolmode) ";
220			$this->fulltext_expr[':'.$node["right"]["record_id"]] = $result;
221			return $result;
222			}
223			break;
224	96		}
225	96		if ($node["left"]["id"]!=="implements") {
226	96		$left=$this->compile_tree($node["left"]);
227	96		if ($likeOp) {
228			$right=$this->compile_tree($node["right"], array('escape_chars' => true));
229			} else {
230	96		$right=$this->compile_tree($node["right"]);
231			}
232			/* lastchanged == unixtimestamp -> lastchanged == 200201.. */
233	96		if ($node["left"]["field"]=="lastchanged") {
234			$right = date("YmdHis", $right);
235			}
236	96		$result=" $left $operator $right ";
237	96		} else {
238	92		$type = $this->compile_tree($node["right"]);
239			switch ($operator) {
240	92	View Code Duplication	case '!=':
241			$result=" (".$this->tbl_prefix."objects.type not in (select type from ".$this->tbl_prefix."types where implements = $type )) ";
242			break;
243	92	View Code Duplication	default:
244	92		$result=" ( SUBSTRING_INDEX(".$this->tbl_prefix."objects.vtype, '.', 1) in (select type from ".$this->tbl_prefix."types where implements $operator $type )) ";
245	92		break;
246	92		}
247			}
248	96		break;
249	99	View Code Duplication	case 'group':
250			$left=$this->compile_tree($node["left"]);
251			if ($left) {
252			$result=" ( $left ) ";
253			}
254			break;
255
256	99	View Code Duplication	case 'orderby':
257	26		$result=$this->compile_tree($node["left"]);
258	26		$this->orderby_s=$this->compile_tree($node["right"]);
259	26		break;
260
261	99		case 'orderbyfield':
262	26		$this->in_orderby = true;
263	26		$left=$this->compile_tree($node["left"]);
264	26		if ( $node["right"]["field"] != "none" ) {
265	1		if ($node["right"]["field"] == 'AR_relevance' && $this->store->is_supported("fulltext")) {
266			$right = $this->fulltext_expr[':'.$node["right"]["record_id"]];
267			} else {
268	1		$right=$this->compile_tree($node["right"]);
269			}
270	1		if ($left) {
271			$result=" $left , $right ".$node["type"]." ";
272			} else {
273	1		$result=" $right ".$node["type"]." ";
274			}
275	1		} else {
276	26		$result = "";
277	26		if ($left) {
278			$result = " $left ";
279			}
280	26		$this->skipDefaultOrderBy = true;
281			}
282	26		break;
283
284	99	View Code Duplication	case 'limit':
285	99		$this->where_s=$this->compile_tree($node["left"]);
286	99		if ($node["limit"]) {
287	99		$this->limit_s=" limit ".(int)$node["offset"].", ".$node["limit"]." ";
288	99		} else if ($node["offset"]) {
289			$this->limit_s=" limit ".(int)$node["offset"]." ";
290			} else {
291	24		if ($this->limit) {
292			$offset = (int)$this->offset;
293			$this->limit_s=" limit $offset, ".(int)$this->limit." ";
294			}
295			}
296	99		break;
297			}
298	99		return $result;
299			}
300
301			// mysql specific compiler function
302	52		protected function priv_sql_compile($tree) {
303	52		$this->custom_ref = 0;
304	52		$this->custom_id = 0;
305	52		$this->used_tables = array();
306	52		$this->compile_tree($tree);
307
308	52		$prop_dep = '';
309	52		$query = '';
310	52		$orderby = '';
311
312	52		if ( $this->error ) {
313			return null;
314			}
315
316	52		$nodes=$this->tbl_prefix."nodes";
317	52		$objects=$this->tbl_prefix."objects";
318	52		$properties=$this->tbl_prefix."prop_";
319	52		$this->used_tables[$nodes]=$nodes;
320	52		$this->used_tables[$objects]=$objects;
321	52	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...
322			$this->used_tables[$properties."references as target_reference"] = $properties."references as target_reference";
323			$this->used_tables["$nodes as target"] = "$nodes as target";
324			}
325
326	52		$tables = implode(', ',array_keys($this->used_tables));
327	52		foreach ( $this->used_tables as $key => $val){
328	52	View Code Duplication	if ($this->select_tables[$key]) {
329	48		if ($this->join_target_properties[$key]) {
330			$prop_dep.=" and $val.object=target.object ";
331			} else {
332	48		$prop_dep.=" and $val.object=$objects.id ";
333			}
334	48		}
335	52		}
336
337	52		$join = "";
338	52		if (is_array($this->nls_join)) {
339			$join = implode("", $this->nls_join);
340			}
341
342	52		$query.=" where $nodes.object=$objects.id $prop_dep";
343	52		$query.=" and $nodes.path like '".str_replace('_','\\_',AddSlashes($this->path))."%' ";
344	52		if ($this->where_s) {
345	49		$query.=" and ( $this->where_s ) ";
346	49		}
347	52		if ($this->where_s_ext) {
348			$query .= " and ($this->where_s_ext) ";
349			}
350			/* do target join */
351	52		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...
352			$query .= " and $objects.id = target_reference.object ";
353			$query .= " and target.path = target_reference.AR_path ";
354			}
355
356	52		if ($this->orderby_s) {
357	1	View Code Duplication	if ($this->skipDefaultOrderBy) {
358	1		$orderby = " order by $this->orderby_s ";
359	1		} else {
360			$orderby = " order by $this->orderby_s, $nodes.parent ASC, $nodes.priority DESC, $nodes.path ASC ";
361			}
362	52		} else if (!$this->skipDefaultOrderBy) {
363	50		$orderby = " order by $nodes.parent ASC, $nodes.priority DESC, $nodes.path ASC ";
364	50		}
365
366	52		$select_query = "select distinct($nodes.path), $objects.id, $nodes.parent, $nodes.priority, $objects.type, ".
367	52		" UNIX_TIMESTAMP($objects.lastchanged) as lastchanged, $objects.vtype ";
368	52		$select_query .= "from ($tables) $join $query ";
369
370	52		$select_query .= $orderby . " $this->limit_s ";
371	52		$count_query = "select count(distinct($nodes.path)) as count from $tables ".$query;
372
373	52		return array("select_query" => $select_query, "count_query" => $count_query);
374			}
375
376			}
377

Ariadne-CMS / ariadne

Push — master ( 7665c8...9af7b9 )

mysql_compiler::priv_sql_compile() F

Complexity

Size

Duplication

Code Coverage

Importance

How to fix Long Method Complexity

Long Method

Duplication Side-by-Side

Filter issues like