details: https://code.openbravo.com/erp/stable/2.50/rev/dcad918db1b3
changeset: 9661:dcad918db1b3
user: Antonio Moreno <antonio.moreno <at> openbravo.com>
date: Wed Sep 21 09:18:48 2011 +0200
summary: Fixed issue 16954. AD_Language_Create will insert field_trls with
its names translated if possible
diffstat:
src-db/database/model/functions/AD_LANGUAGE_CREATE.xml | 41 ++++++++++++++++++
1 files changed, 41 insertions(+), 0 deletions(-)
diffs (51 lines):
diff -r bf8ce360b2fa -r dcad918db1b3
src-db/database/model/functions/AD_LANGUAGE_CREATE.xml
--- a/src-db/database/model/functions/AD_LANGUAGE_CREATE.xml Tue Sep 20
19:55:22 2011 +0200
+++ b/src-db/database/model/functions/AD_LANGUAGE_CREATE.xml Wed Sep 21
09:18:48 2011 +0200
@@ -125,6 +125,47 @@
v_Created:=v_Created + v_rowcount;
DBMS_OUTPUT.PUT_LINE('- AD_FieldGroup ' || v_rowcount) ;
-- Field
+ -- First field_trls are created from the element_trls
+ INSERT
+ INTO AD_Field_Trl
+ (
+ AD_Field_Trl_ID, AD_Field_ID, AD_Language, Name, Description, Help,
IsTranslated, Createdby, UpdatedBy, AD_Client_ID, AD_Org_ID
+ )
+ SELECT get_uuid(), AD_Field_ID, AD_Language.AD_Language, trl.Name,
trl.Description, trl.Help, 'N', '0', '0', '0','0'
+ FROM AD_Field, AD_Language, AD_Module M, ad_column c
+ left join ad_element_trl trl
+ on trl.ad_element_id=c.ad_element_id
+ WHERE AD_Language.IsActive='Y'
+ and AD_Field.iscentrallymaintained='Y'
+ AND AD_Field.AD_Module_ID = M.AD_Module_ID
+ AND M.AD_Language != AD_Language.AD_Language
+ AND AD_Language.IsSystemLanguage='Y'
+ and c.ad_column_id=AD_Field.ad_column_id
+ and trl.ad_language=AD_Language.AD_Language
+ AND NOT EXISTS (SELECT 1 FROM AD_Field_TRL
+ WHERE AD_Field_ID = AD_Field.AD_Field_ID
+ AND AD_LANGUAGE = AD_Language.AD_Language);
+ -- If there weren't element_trls, field_trls are created from elements
+ INSERT
+ INTO AD_Field_Trl
+ (
+ AD_Field_Trl_ID, AD_Field_ID, AD_Language, Name, Description, Help,
IsTranslated, Createdby, UpdatedBy, AD_Client_ID, AD_Org_ID
+ )
+ SELECT get_uuid(), AD_Field_ID, AD_Language.AD_Language, e.Name,
e.Description, e.Help, 'N', '0', '0', '0','0'
+ FROM AD_Field, AD_Language, AD_Module M, ad_column c,ad_element e,
ad_module modEl
+ WHERE AD_Language.IsActive='Y'
+ and AD_Field.iscentrallymaintained='Y'
+ AND AD_Field.AD_Module_ID = M.AD_Module_ID
+ AND M.AD_Language != AD_Language.AD_Language
+ AND AD_Language.IsSystemLanguage='Y'
+ and c.ad_element_id=e.ad_element_id
+ and c.ad_column_id=AD_Field.ad_column_id
+ and modEl.ad_module_id=e.ad_module_id
+ and modEl.ad_language!=m.ad_language
+ AND NOT EXISTS (SELECT 1 FROM AD_Field_TRL
+ WHERE AD_Field_ID = AD_Field.AD_Field_ID
+ AND AD_LANGUAGE = AD_Language.AD_Language);
+ -- If there were no elements, or element_trls, data is copied from the
ad_field itself
INSERT
INTO AD_Field_Trl
(
------------------------------------------------------------------------------
All the data continuously generated in your IT infrastructure contains a
definitive record of customers, application performance, security
threats, fraudulent activity and more. Splunk takes this data and makes
sense of it. Business sense. IT sense. Common sense.
http://p.sf.net/sfu/splunk-d2dcopy1
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
