DBExprOrderBySpec::__construct() - Code Metrics - rkrx/php-mysql-query-builder - Measure and Improve Code Quality continuously with Scrutinizer

DBExprOrderBySpec::__construct() B
last analyzed 2025-05-25 17:17 UTC

↳ Parent: DBExprOrderBySpec

Complexity

Conditions	11
Paths	15

Size

Total Lines	25
Code Lines	19

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

Metric	Value
eloc	19
c	1
b	0
f	0
dl	0
loc	25
rs	7.3166
cc	11
nc	15
nop	2

How to fix Complexity

<?php
namespace Kir\MySQL\Builder\Expr;

/**
 * @deprecated
 */
class DBExprOrderBySpec implements OrderBySpecification {
	/** @var array<int, array{string, 'ASC'|'DESC'}> */

	private $fields = [];

	/**
	 * @param array<string|int, string> $spec Can be used to build a order-by-spec based on a key-value array of fields where keys represent an field alias and the value part represents an SQL-expression.
	 * @param array<int, array{string, 'ASC'|'DESC'}> $sortFieldsSpec Key value array where the key represents the field alias and the value is either 'ASC' or 'DESC'

	 */
	public function __construct(array $spec, array $sortFieldsSpec) {
		$expressions = [];
		foreach($spec as $specReference => $dbExpr) {
			if(is_int($specReference)) {
				$specReference = $dbExpr;
			}
			$expressions[$specReference] = $dbExpr;
		}
		foreach($sortFieldsSpec as $sortFieldSpec) {
			if(array_key_exists(0, $sortFieldSpec)) {
				if(array_key_exists($sortFieldSpec[0], $expressions)) {
					$direction = 'ASC';
					if(array_key_exists(1, $sortFieldSpec) && strtoupper($sortFieldSpec[1]) !== 'ASC') {
						$direction = 'DESC';
					}
					$this->fields[] = [
						$expressions[$sortFieldSpec[0]],
						$direction
					];
				}
			} else { // @phpstan-ignore-line
				foreach($sortFieldSpec as $alias => $direction) {
					$direction = strtoupper($direction) === 'DESC' ? 'DESC' : 'ASC';
					if(array_key_exists($alias, $expressions)) {
						$this->fields[] = [$expressions[$alias], $direction];
					}
				}
			}
		}
	}

	/**
	 * Returns an array[], where each value is a [db-expression, sort-direction]
	 * The sort-direction can be either ASC or DESC
	 *
	 * @return array<int, array{string, string&('ASC'|'DESC')}>

	 */
	public function getFields(): array {
		return $this->fields;
	}
}


1			<?php
2			namespace Kir\MySQL\Builder\Expr;
3
4			/**
5			* @deprecated
6			*/
7			class DBExprOrderBySpec implements OrderBySpecification {
8			/** @var array<int, array{string, 'ASC'\|'DESC'}> */
			0 ignored issues – show Documentation Bug introduced 2021-05-06 14:34 UTC by Report Bug Copy Issue Report The doc comment `array<int, array{string, 'ASC'\|'DESC'}>` at position `6` could not be parsed: Expected ':' at position 6, but found 'string'. Loading history...
9			private $fields = [];
10
11			/**
12			* @param array<string\|int, string> $spec Can be used to build a order-by-spec based on a key-value array of fields where keys represent an field alias and the value part represents an SQL-expression.
13			* @param array<int, array{string, 'ASC'\|'DESC'}> $sortFieldsSpec Key value array where the key represents the field alias and the value is either 'ASC' or 'DESC'
			0 ignored issues – show Documentation Bug introduced 2021-05-06 14:34 UTC by Report Bug Copy Issue Report The doc comment `array<int, array{string, 'ASC'\|'DESC'}>` at position `6` could not be parsed: Expected ':' at position 6, but found 'string'. Loading history...
14			*/
15			public function __construct(array $spec, array $sortFieldsSpec) {
16			$expressions = [];
17			foreach($spec as $specReference => $dbExpr) {
18			if(is_int($specReference)) {
19			$specReference = $dbExpr;
20			}
21			$expressions[$specReference] = $dbExpr;
22			}
23			foreach($sortFieldsSpec as $sortFieldSpec) {
24			if(array_key_exists(0, $sortFieldSpec)) {
25			if(array_key_exists($sortFieldSpec[0], $expressions)) {
26			$direction = 'ASC';
27			if(array_key_exists(1, $sortFieldSpec) && strtoupper($sortFieldSpec[1]) !== 'ASC') {
28			$direction = 'DESC';
29			}
30			$this->fields[] = [
31			$expressions[$sortFieldSpec[0]],
32			$direction
33			];
34			}
35			} else { // @phpstan-ignore-line
36			foreach($sortFieldSpec as $alias => $direction) {
37			$direction = strtoupper($direction) === 'DESC' ? 'DESC' : 'ASC';
38			if(array_key_exists($alias, $expressions)) {
39			$this->fields[] = [$expressions[$alias], $direction];
40			}
41			}
42			}
43			}
44			}
45
46			/**
47			* Returns an array[], where each value is a [db-expression, sort-direction]
48			* The sort-direction can be either ASC or DESC
49			*
50			* @return array<int, array{string, string&('ASC'\|'DESC')}>
			0 ignored issues – show Documentation Bug introduced 2021-07-21 22:27 UTC by Report Bug Copy Issue Report The doc comment `array<int, array{string, string&('ASC'\|'DESC')}>` at position `6` could not be parsed: Expected ':' at position 6, but found 'string'. Loading history...
51			*/
52			public function getFields(): array {
53			return $this->fields;
54			}
55			}
56

rkrx / php-mysql-query-builder

DBExprOrderBySpec::__construct() B last analyzed 2025-05-25 17:17 UTC

Complexity

Size

Duplication

Importance

How to fix Complexity

Long Method

Duplication Side-by-Side

Filter issues like

DBExprOrderBySpec::__construct() B
last analyzed 2025-05-25 17:17 UTC