From 06bff0b9b84d47c43f9bc8aff06a29d85ebb7ed0 Mon Sep 17 00:00:00 2001
From: Simon Rettberg
Date: Tue, 14 Nov 2023 14:47:55 +0100
Subject: Add function param/return types, fix a lot more phpstorm complaints

---
 .../statistics/inc/hardwarequery.inc.php           | 40 +++++++++-------------
 1 file changed, 17 insertions(+), 23 deletions(-)

(limited to 'modules-available/statistics/inc/hardwarequery.inc.php')

diff --git a/modules-available/statistics/inc/hardwarequery.inc.php b/modules-available/statistics/inc/hardwarequery.inc.php
index 4f0ec344..6b1b5043 100644
--- a/modules-available/statistics/inc/hardwarequery.inc.php
+++ b/modules-available/statistics/inc/hardwarequery.inc.php
@@ -45,25 +45,23 @@ class HardwareQuery
 	 */
 	public function addForeignJoin(bool $global, string $prop, string $jTable, string $jColumn, string $condColumn = '', $condVal = null)
 	{
-		if (isset($this->columns[$jTable]))
+		if (isset($this->columns["$jTable.$prop"]))
 			return;
-		if (!isset($this->columns[$prop])) {
-			if ($global) {
-				$srcTable = 'shw';
-				$table = 'statistic_hw_prop';
-				$column = 'hwid';
-			} else {
-				$srcTable = 'mxhw';
-				$table = 'machine_x_hw_prop';
-				$column = 'machinehwid';
-			}
-			$tid = $this->id();
-			$pid = $this->id();
-			$this->joins[$prop] = "INNER JOIN $table $tid ON ($srcTable.$column = $tid.$column
-				AND $tid.prop = :$pid)";
-			$this->args[$pid] = $prop;
-			$this->columns[$prop] = "$tid.`value` AS `$prop`";
+		if ($global) {
+			$srcTable = 'shw';
+			$table = 'statistic_hw_prop';
+			$column = 'hwid';
+		} else {
+			$srcTable = 'mxhw';
+			$table = 'machine_x_hw_prop';
+			$column = 'machinehwid';
 		}
+		$tid = $this->id();
+		$pid = $this->id();
+		$this->joins[$prop] = "INNER JOIN $table $tid ON ($srcTable.$column = $tid.$column
+			AND $tid.prop = :$pid)";
+		$this->args[$pid] = $prop;
+		$this->columns[$prop] = "$tid.`value` AS `$prop`";
 		$jtid = $this->id();
 		$cond = '';
 		if (!empty($condColumn)) {
@@ -106,10 +104,8 @@ class HardwareQuery
 
 	/**
 	 * Join the machine table and add the given column from it to the SELECT
-	 * @param string $column
-	 * @return void
 	 */
-	public function addMachineColumn(string $column)
+	public function addMachineColumn(string $column): void
 	{
 		if (isset($this->columns[$column]))
 			return;
@@ -163,13 +159,11 @@ class HardwareQuery
 		} else {
 			$groupBy = '';
 		}
-		$query = 'SELECT ' . implode(', ', $columns)
+		return 'SELECT ' . implode(', ', $columns)
 			. ' FROM statistic_hw shw '
 			. implode(' ', $this->joins)
 			. ' WHERE ' . implode(' AND ', $this->where)
 			. $groupBy;
-		//error_log($query);
-		return $query;
 	}
 
 }
-- 
cgit v1.2.3-55-g7522