src/org/openbravo/erpCommon/modules/ApplyModule_data.xsql
changeset 15522 459c8c6700f5
parent 13016 4f22d41ef45d
--- a/src/org/openbravo/erpCommon/modules/ApplyModule_data.xsql	Thu Feb 16 10:46:50 2012 +0100
+++ b/src/org/openbravo/erpCommon/modules/ApplyModule_data.xsql	Thu Feb 16 12:11:22 2012 +0100
@@ -31,6 +31,16 @@
          AND ISTRANSLATIONMODULE = 'Y'
     ]]></Sql>
   </SqlMethod>
+  <SqlMethod name="selectAllTranslationModules" type="preparedStatement" return="multiple">
+    <SqlMethodComment></SqlMethodComment>
+    <Sql>
+    <![CDATA[
+      SELECT M.JAVAPACKAGE, M.NAME, M.AD_LANGUAGE, L.ISSYSTEMLANGUAGE, '' as DS_NAME, '' AS AD_MODULE_ID
+        FROM AD_MODULE M LEFT JOIN AD_LANGUAGE L
+                           ON L.AD_LANGUAGE = M.AD_LANGUAGE
+       WHERE ISTRANSLATIONMODULE = 'Y'
+    ]]></Sql>
+  </SqlMethod>
   
   <SqlMethod name="selectClientReferenceModules" type="preparedStatement" return="multiple">
     <SqlMethodComment></SqlMethodComment>
@@ -45,6 +55,18 @@
     ]]></Sql>
   </SqlMethod>
   
+  <SqlMethod name="selectAllClientReferenceModules" type="preparedStatement" return="multiple">
+    <SqlMethodComment></SqlMethodComment>
+    <Sql>
+    <![CDATA[
+      SELECT M.JAVAPACKAGE, M.NAME, M.AD_MODULE_ID, D.NAME as DS_NAME
+        FROM AD_MODULE M, AD_DATASET D
+       WHERE M.HASREFERENCEDATA = 'Y'
+         AND D.AD_MODULE_ID = M.AD_MODULE_ID
+         AND D.ACCESSLEVEL = '4'
+    ]]></Sql>
+  </SqlMethod>
+  
   <SqlMethod name="setSystemLanguage" type="preparedStatement" return="rowcount">
     <Sql>
       <![CDATA[