src/org/openbravo/erpCommon/modules/ApplyModule_data.xsql
author Antonio Moreno <antonio.moreno@openbravo.com>
Thu, 16 Feb 2012 12:11:22 +0100
changeset 15522 459c8c6700f5
parent 13016 4f22d41ef45d
permissions -rw-r--r--
Fixed issue 13438. Now the import of reference data and translations can be forced with -DforceRefData=true
asier@1929
     1
<?xml version="1.0" encoding="UTF-8" ?>
asier@1929
     2
<!--
asier@1929
     3
 *************************************************************************
asier@1929
     4
 * The contents of this file are subject to the Openbravo  Public  License
priya@9085
     5
 * Version  1.1  (the  "License"),  being   the  Mozilla   Public  License
asier@1929
     6
 * Version 1.1  with a permitted attribution clause; you may not  use this
asier@1929
     7
 * file except in compliance with the License. You  may  obtain  a copy of
asier@1929
     8
 * the License at http://www.openbravo.com/legal/license.html 
asier@1929
     9
 * Software distributed under the License  is  distributed  on  an "AS IS"
asier@1929
    10
 * basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. See the
asier@1929
    11
 * License for the specific  language  governing  rights  and  limitations
asier@1929
    12
 * under the License. 
asier@1929
    13
 * The Original Code is Openbravo ERP. 
ggi@6702
    14
 * The Initial Developer of the Original Code is Openbravo SLU 
gorka@13016
    15
 * All portions are Copyright (C) 2008-2010 Openbravo SLU 
asier@1929
    16
 * All Rights Reserved. 
asier@1929
    17
 * Contributor(s):  ______________________________________.
asier@1929
    18
 ************************************************************************
asier@1929
    19
-->
asier@1929
    20
asier@1929
    21
<SqlClass name="ApplyModuleData" package="org.openbravo.erpCommon.modules">
asier@1929
    22
  <SqlClassComment></SqlClassComment>
asier@1929
    23
  <SqlMethod name="selectTranslationModules" type="preparedStatement" return="multiple">
asier@1929
    24
    <SqlMethodComment></SqlMethodComment>
asier@1929
    25
    <Sql>
asier@1929
    26
    <![CDATA[
gorkaion@5839
    27
      SELECT M.JAVAPACKAGE, M.NAME, M.AD_LANGUAGE, L.ISSYSTEMLANGUAGE, '' as DS_NAME, '' AS AD_MODULE_ID
asier@1929
    28
        FROM AD_MODULE M LEFT JOIN AD_LANGUAGE L
gorkaion@5839
    29
                           ON L.AD_LANGUAGE = M.AD_LANGUAGE
asier@3417
    30
       WHERE (STATUS = 'I' OR STATUS = 'P')
asier@1929
    31
         AND ISTRANSLATIONMODULE = 'Y'
asier@1929
    32
    ]]></Sql>
asier@1929
    33
  </SqlMethod>
antonio@15522
    34
  <SqlMethod name="selectAllTranslationModules" type="preparedStatement" return="multiple">
antonio@15522
    35
    <SqlMethodComment></SqlMethodComment>
antonio@15522
    36
    <Sql>
antonio@15522
    37
    <![CDATA[
antonio@15522
    38
      SELECT M.JAVAPACKAGE, M.NAME, M.AD_LANGUAGE, L.ISSYSTEMLANGUAGE, '' as DS_NAME, '' AS AD_MODULE_ID
antonio@15522
    39
        FROM AD_MODULE M LEFT JOIN AD_LANGUAGE L
antonio@15522
    40
                           ON L.AD_LANGUAGE = M.AD_LANGUAGE
antonio@15522
    41
       WHERE ISTRANSLATIONMODULE = 'Y'
antonio@15522
    42
    ]]></Sql>
antonio@15522
    43
  </SqlMethod>
asier@1929
    44
  
asier@1929
    45
  <SqlMethod name="selectClientReferenceModules" type="preparedStatement" return="multiple">
asier@1929
    46
    <SqlMethodComment></SqlMethodComment>
asier@1929
    47
    <Sql>
asier@1929
    48
    <![CDATA[
asier@4329
    49
      SELECT M.JAVAPACKAGE, M.NAME, M.AD_MODULE_ID, D.NAME as DS_NAME
asier@4329
    50
        FROM AD_MODULE M, AD_DATASET D
asier@4329
    51
       WHERE (M.STATUS = 'I' OR M.STATUS = 'P')
asier@1929
    52
         AND M.HASREFERENCEDATA = 'Y'
asier@4329
    53
         AND D.AD_MODULE_ID = M.AD_MODULE_ID
asier@4329
    54
         AND D.ACCESSLEVEL = '4'
asier@1929
    55
    ]]></Sql>
asier@1929
    56
  </SqlMethod>
asier@1929
    57
  
antonio@15522
    58
  <SqlMethod name="selectAllClientReferenceModules" type="preparedStatement" return="multiple">
antonio@15522
    59
    <SqlMethodComment></SqlMethodComment>
antonio@15522
    60
    <Sql>
antonio@15522
    61
    <![CDATA[
antonio@15522
    62
      SELECT M.JAVAPACKAGE, M.NAME, M.AD_MODULE_ID, D.NAME as DS_NAME
antonio@15522
    63
        FROM AD_MODULE M, AD_DATASET D
antonio@15522
    64
       WHERE M.HASREFERENCEDATA = 'Y'
antonio@15522
    65
         AND D.AD_MODULE_ID = M.AD_MODULE_ID
antonio@15522
    66
         AND D.ACCESSLEVEL = '4'
antonio@15522
    67
    ]]></Sql>
antonio@15522
    68
  </SqlMethod>
antonio@15522
    69
  
asier@1929
    70
  <SqlMethod name="setSystemLanguage" type="preparedStatement" return="rowcount">
asier@1929
    71
    <Sql>
asier@1929
    72
      <![CDATA[
asier@1929
    73
         UPDATE AD_LANGUAGE
asier@1929
    74
            SET ISSYSTEMLANGUAGE='Y'
asier@1929
    75
          WHERE AD_LANGUAGE = ?
asier@1929
    76
      ]]></Sql>
asier@1929
    77
    <Parameter name="lang"/>
asier@1929
    78
  </SqlMethod>
antonio@7539
    79
antonio@7539
    80
  <SqlMethod name="process179" type="callableStatement" return="object" object="ApplyModuleData">
antonio@7539
    81
      <SqlMethodComment>procedure AD_Language_Create</SqlMethodComment>
antonio@7539
    82
      <Sql><![CDATA[
antonio@7539
    83
        CALL AD_Language_Create(?)
antonio@7539
    84
      ]]></Sql>
antonio@7539
    85
      <Parameter name="adPinstanceId"></Parameter>
antonio@7539
    86
   </SqlMethod>
antonio@7539
    87
asier@1929
    88
</SqlClass>