From b08318cfd95696129661f80321bc62877d5d60e8 Mon Sep 17 00:00:00 2001
From: Marcel Werk <burntime@woltlab.com>
Date: Thu, 7 Nov 2024 13:37:41 +0100
Subject: [PATCH] Add filter for i18n text columns

---
 .../view/grid/filter/I18nTextFilter.class.php | 19 +++++++++++++++++++
 1 file changed, 19 insertions(+)
 create mode 100644 wcfsetup/install/files/lib/system/view/grid/filter/I18nTextFilter.class.php

diff --git a/wcfsetup/install/files/lib/system/view/grid/filter/I18nTextFilter.class.php b/wcfsetup/install/files/lib/system/view/grid/filter/I18nTextFilter.class.php
new file mode 100644
index 0000000000..4802d6fa1d
--- /dev/null
+++ b/wcfsetup/install/files/lib/system/view/grid/filter/I18nTextFilter.class.php
@@ -0,0 +1,19 @@
+<?php
+
+namespace wcf\system\view\grid\filter;
+
+use wcf\data\DatabaseObjectList;
+use wcf\system\WCF;
+
+class I18nTextFilter extends TextFilter
+{
+    #[\Override]
+    public function applyFilter(DatabaseObjectList $list, string $id, string $value): void
+    {
+        $list->getConditionBuilder()->add("($id LIKE ? OR $id IN (SELECT languageItem FROM wcf1_language_item WHERE languageID = ? AND languageItemValue LIKE ?))", [
+            '%' . $value . '%',
+            WCF::getLanguage()->languageID,
+            '%' . $value . '%'
+        ]);
+    }
+}
-- 
2.20.1