ipa_haller_jan: QFQ-Wiki. refs #15634

ipa_haller_jan: QFQ-Wiki. refs #15634

extension/Classes/Sql/function.sql

@@ -401,3 +401,17 @@ BEGIN
     RETURN @highlighted_text;
 END;
 
+###
+#
+# QMANR(manr)
+# Matrikel-Nr. format: 12-345-567
+#
+DROP FUNCTION IF EXISTS `QMANR`;
+CREATE FUNCTION `QMANR`(manr VARCHAR(255)) RETURNS VARCHAR(255) CHARSET utf8mb4
+    DETERMINISTIC
+    SQL SECURITY INVOKER
+BEGIN
+	DECLARE matrikelNr VARCHAR(255);
+    SET matrikelNr = CONCAT(SUBSTRING(manr,1,2), '-', SUBSTRING(manr,3,3), '-', SUBSTRING(manr,6,3));
+RETURN matrikelNr;
+END;
\ No newline at end of file