[statistics/passthrough] Consider group<->location mapping for KCL

1 files changed, 48 insertions, 0 deletions

diff --git a/modules-available/passthrough/hooks/locations-column.inc.php b/modules-available/passthrough/hooks/locations-column.inc.php
new file mode 100644
index 00000000..9757ac50
--- /dev/null
+++ b/modules-available/passthrough/hooks/locations-column.inc.php
@@ -0,0 +1,48 @@
+<?php
+
+if (!User::hasPermission('.passthrough.view')) {
+	return null;
+}
+
+class PassthroughLocationColumn extends AbstractLocationColumn
+{
+
+	private $lookup;
+
+	public function __construct(array $allowedLocationIds)
+	{
+		$this->lookup = Database::queryKeyValueList("SELECT gxl.locationid, GROUP_CONCAT(gxl.groupid SEPARATOR ', ') AS grps
+				FROM passthrough_group_x_location gxl
+				WHERE locationid IN (:allowedLocationIds) GROUP BY locationid", compact('allowedLocationIds'));
+	}
+
+	public function getColumnHtml(int $locationId): string
+	{
+		return htmlspecialchars($this->lookup[$locationId] ?? '');
+	}
+
+	public function getEditUrl(int $locationId): string
+	{
+		if (!User::hasPermission('.passthrough.assign', $locationId))
+			return '';
+		return '?do=passthrough&show=assignlocation&locationid=' . $locationId;
+	}
+
+	public function header(): string
+	{
+		return Dictionary::translateFileModule('passthrough', 'module', 'location-column-header');
+	}
+
+	public function priority(): int
+	{
+		return 4000;
+	}
+
+	public function propagateColumn(): bool
+	{
+		return true;
+	}
+
+}
+
+return new PassthroughLocationColumn($allowedLocationIds);
\ No newline at end of file