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

GroupByBuilder::groupBy() A
last analyzed 2025-09-30 18:12 UTC

↳ Parent: GroupByBuilder

Complexity

Conditions	4
Paths	4

Size

Total Lines	11
Code Lines	7

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

Metric	Value
eloc	7
dl	0
loc	11
rs	10
c	1
b	0
f	0
cc	4
nc	4
nop	1

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

use Kir\MySQL\Builder;

trait GroupByBuilder {
	use AbstractDB;

	/** @var string[] */
	private array $groupBy = [];

	/**
	 * @param mixed ...$args
	 * @return $this
	 */
	public function groupBy(...$args) {
		foreach($args as $expression) {
			if(is_array($expression)) {
				if(!count($expression)) {
					continue;
				}
				$expression = $this->quoteExpr($expression[0], array_slice($expression, 1));
			}
			$this->groupBy[] = $expression;
		}
		return $this;
	}

	/**
	 * @param string $query
	 * @return string
	 */
	protected function buildGroups(string $query): string {
		if(!count($this->groupBy)) {
			return $query;
		}
		$query .= "GROUP BY\n";
		$arr = [];
		foreach($this->groupBy as $expression) {
			$arr[] = "\t{$expression}";
		}
		return $query.implode(",\n", $arr)."\n";
	}

	/**
	 * @param string $expression
	 * @param array<int, null|int|float|string|array<int, string>|Builder\DBExpr|Builder\Select> $arguments
	 * @return string
	 */
	protected function quoteExpr(string $expression, array $arguments): string {
		return $this->db()->quoteExpression($expression, $arguments);
	}
}


1			<?php
2			namespace Kir\MySQL\Builder\Traits;
3
4			use Kir\MySQL\Builder;
5
6			trait GroupByBuilder {
7			use AbstractDB;
8
9			/** @var string[] */
10			private array $groupBy = [];
11
12			/**
13			* @param mixed ...$args
14			* @return $this
15			*/
16			public function groupBy(...$args) {
17			foreach($args as $expression) {
18			if(is_array($expression)) {
19			if(!count($expression)) {
20			continue;
21			}
22			$expression = $this->quoteExpr($expression[0], array_slice($expression, 1));
23			}
24			$this->groupBy[] = $expression;
25			}
26			return $this;
27			}
28
29			/**
30			* @param string $query
31			* @return string
32			*/
33			protected function buildGroups(string $query): string {
34			if(!count($this->groupBy)) {
35			return $query;
36			}
37			$query .= "GROUP BY\n";
38			$arr = [];
39			foreach($this->groupBy as $expression) {
40			$arr[] = "\t{$expression}";
41			}
42			return $query.implode(",\n", $arr)."\n";
43			}
44
45			/**
46			* @param string $expression
47			* @param array<int, null\|int\|float\|string\|array<int, string>\|Builder\DBExpr\|Builder\Select> $arguments
48			* @return string
49			*/
50			protected function quoteExpr(string $expression, array $arguments): string {
51			return $this->db()->quoteExpression($expression, $arguments);
52			}
53			}
54

rkrx / php-mysql-query-builder

GroupByBuilder::groupBy() A last analyzed 2025-09-30 18:12 UTC

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like

GroupByBuilder::groupBy() A
last analyzed 2025-09-30 18:12 UTC