Fix #6494 - translations code for reports

[Pman.Core] / mysql / core_translate_lookup.sql

diff --git a/mysql/core_translate_lookup.sql b/mysql/core_translate_lookup.sql
new file mode 100644 (file)
index 0000000..75bc7b4
--- /dev/null
+++ b/mysql/core_translate_lookup.sql
@@ -0,0 +1,46 @@
+
+DROP FUNCTION IF EXISTS core_translate_lookup;
+
+DELIMITER $$
+CREATE FUNCTION core_translate_lookup(
+    in_ontable VARCHAR(128),
+    in_onid INT(11),
+    in_col VARCHAR(128),
+    in_lang VARCHAR(8),
+    in_default TEXT
+)  
+RETURNS TEXT NOT DETERMINISTIC READS SQL DATA 
+    BEGIN
+
+        DECLARE v_ret TEXT;
+        DECLARE v_id INT(11);
+        
+        SET v_id = 0;
+        
+        SELECT
+            id , txt
+            INTO
+            v_id, v_ret
+        FROM
+            core_templatestr
+        WHERE
+            on_id = in_onid
+            AND
+            on_table = in_ontable
+            AND
+            on_col = in_col
+            AND
+            lang = in_lang
+            AND
+            active = 1
+        LIMIT 1;
+            
+        IF v_id < 1 OR LENGTH(v_ret) < 1 THEN
+            RETURN in_default;
+        END IF;
+        
+        RETURN v_ret;
+
+    END $$
+
+DELIMITER ;
\ No newline at end of file