Kir\MySQL\Builder\Expr\DBExprOrderBySpec::__construct()

Complexity

Conditions	8
Paths	12

Size

Total Lines	21
Code Lines	14

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
	public function __construct($spec, $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) && 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
				];
			}
		}
	}