[statistics] Show ID45 size and local caching config in NIC speed hintHEADmaster

1 files changed, 41 insertions, 0 deletions

diff --git a/modules-available/statistics/pages/hints.inc.php b/modules-available/statistics/pages/hints.inc.php
index bfb28c24..18db10fe 100644
--- a/modules-available/statistics/pages/hints.inc.php
+++ b/modules-available/statistics/pages/hints.inc.php
@@ -173,9 +173,11 @@ class SubPage
 			$q->addMachineWhere('locationid', 'IN', $locs);
 		}
 		$q->addMachineWhere('lastseen', '>', strtotime('-60 days'));
+		$q->addMachineColumn('locationid');
 		$q->addMachineColumn('clientip');
 		$q->addMachineColumn('hostname');
 		$q->addMachineColumn('state');
+		$q->addMachineColumn('id45mb');
 		$q->addLocalColumn('nic-speed')->addCondition('<', 1000);
 		$q->addLocalColumn('nic-duplex');
 		foreach ($q->query() as $row) {
@@ -187,6 +189,45 @@ class SubPage
 		}
 		if (empty($list))
 			return;
+		if (Module::get('baseconfig') !== false) {
+			// Reconstruct config tree for each machine, so we can show the ID45 caching setting
+			$machineConfigs = Database::queryKeyValueList("SELECT machineuuid, value FROM setting_machine
+             	WHERE setting = :setting
+             	  AND machineuuid IN (:uuids)", [
+				'uuids' => array_column($list, 'machineuuid'),
+				'setting' => 'SLX_DNBD3_MIN_GB',
+			]);
+			$locationConfigs = Database::queryKeyValueList("SELECT locationid, value FROM setting_location
+					WHERE setting = :setting
+						AND locationid IN (:locationids)", [
+				'locationids' => array_column($list, 'locationid'),
+				'setting' => 'SLX_DNBD3_MIN_GB',
+			]);
+			$default = Database::queryFirst("SELECT value FROM setting_global WHERE setting = :setting",
+				['setting' => 'SLX_DNBD3_MIN_GB']);
+			if ($default !== false) {
+				$default = $default['value'];
+			}
+			foreach ($list as &$row) {
+				$val = null;
+				if (isset($machineConfigs[$row['machineuuid']])) {
+					$val = $machineConfigs[$row['machineuuid']];
+				} elseif ($row['locationid'] !== null) {
+					foreach (Location::getLocationRootChain($row['locationid']) as $lid) {
+						if (isset($locationConfigs[$lid])) {
+							$val = $locationConfigs[$lid];
+							break;
+						}
+					}
+				}
+				$row['id45gb'] = floor($row['id45mb'] / 1024);
+				$row['id45min'] = $val ?? $default;
+				if ($row['id45min'] == 0 || $row['id45min'] * 1024 > $row['id45mb']) {
+					$row['id45class'] = 'danger';
+				}
+			}
+		}
+		//
 		ArrayUtil::sortByColumn($list, 'hostname');
 		Render::addTemplate('hints-nic-speed', ['list' => $list]);
 	}