details: https://code.openbravo.com/erp/devel/main/rev/3e5e7ef793d9 changeset: 17615:3e5e7ef793d9 user: David Miguelez <david.miguelez <at> openbravo.com> date: Mon Aug 20 13:40:26 2012 +0200 summary: Fixes issue 21389: Changes onCreateDefault for a moduleScript
details: https://code.openbravo.com/erp/devel/main/rev/1118435fe14a changeset: 17616:1118435fe14a user: David Miguelez <david.miguelez <at> openbravo.com> date: Mon Aug 20 15:18:26 2012 +0200 summary: Fixes issue 0021393: Orders the query properly. details: https://code.openbravo.com/erp/devel/main/rev/02c9be1fdf22 changeset: 17617:02c9be1fdf22 user: Shankar Balachandran <shankar.balachandran <at> openbravo.com> date: Tue Aug 14 17:12:30 2012 +0530 summary: Fixes Issue 21344 : Defaulting Read-Only for Status Bar fields. Set 'Read-Only' flag as 'Y' when 'Show in Status Bar' flag is checked. Removed display logic from 'Read-Only' field details: https://code.openbravo.com/erp/devel/main/rev/b741958ab65c changeset: 17618:b741958ab65c user: Mikel Irurita <mikel.irurita <at> openbravo.com> date: Fri Aug 10 12:14:01 2012 +0200 summary: Fixes issue 21346: Some fields in status bar are editable in grid diffstat: modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_FIELD.xml | 16 +- src-db/database/model/tables/M_TRANSACTION.xml | 2 +- src-db/database/sourcedata/AD_CALLOUT.xml | 10 ++ src-db/database/sourcedata/AD_COLUMN.xml | 1 + src-db/database/sourcedata/AD_FIELD.xml | 19 +-- src-db/database/sourcedata/AD_MODEL_OBJECT.xml | 12 ++ src-db/database/sourcedata/AD_MODEL_OBJECT_MAPPING.xml | 10 ++ src-util/modulescript/build/classes/org/openbravo/modulescript/UpdateMTransactionCostingStatus.class | 0 src-util/modulescript/src/org/openbravo/modulescript/UpdateMTransactionCostingStatus.java | 48 ++++++++++ src/org/openbravo/costing/CostingServer.java | 2 +- src/org/openbravo/erpCommon/ad_callouts/SL_StatusFieldDefaults.java | 45 +++++++++ 11 files changed, 145 insertions(+), 20 deletions(-) diffs (truncated from 367 to 300 lines): diff -r 16ff20ea3c8c -r b741958ab65c modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_FIELD.xml --- a/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_FIELD.xml Fri Aug 10 09:40:23 2012 +0200 +++ b/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_FIELD.xml Fri Aug 10 12:14:01 2012 +0200 @@ -152,7 +152,7 @@ <!--0244498E99414EA6A709CD3D5A7951D1--> <IGNOREINWAD><![CDATA[N]]></IGNOREINWAD> <!--0244498E99414EA6A709CD3D5A7951D1--> <ISDISPLAYED><![CDATA[N]]></ISDISPLAYED> <!--0244498E99414EA6A709CD3D5A7951D1--> <DISPLAYLENGTH><![CDATA[32]]></DISPLAYLENGTH> -<!--0244498E99414EA6A709CD3D5A7951D1--> <ISREADONLY><![CDATA[N]]></ISREADONLY> +<!--0244498E99414EA6A709CD3D5A7951D1--> <ISREADONLY><![CDATA[Y]]></ISREADONLY> <!--0244498E99414EA6A709CD3D5A7951D1--> <SEQNO><![CDATA[10]]></SEQNO> <!--0244498E99414EA6A709CD3D5A7951D1--> <ISSAMELINE><![CDATA[N]]></ISSAMELINE> <!--0244498E99414EA6A709CD3D5A7951D1--> <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY> @@ -3276,7 +3276,7 @@ <!--4C85D478837741C4A3AD74CFF852A470--> <IGNOREINWAD><![CDATA[N]]></IGNOREINWAD> <!--4C85D478837741C4A3AD74CFF852A470--> <ISDISPLAYED><![CDATA[N]]></ISDISPLAYED> <!--4C85D478837741C4A3AD74CFF852A470--> <DISPLAYLENGTH><![CDATA[12]]></DISPLAYLENGTH> -<!--4C85D478837741C4A3AD74CFF852A470--> <ISREADONLY><![CDATA[N]]></ISREADONLY> +<!--4C85D478837741C4A3AD74CFF852A470--> <ISREADONLY><![CDATA[Y]]></ISREADONLY> <!--4C85D478837741C4A3AD74CFF852A470--> <SEQNO><![CDATA[90]]></SEQNO> <!--4C85D478837741C4A3AD74CFF852A470--> <ISSAMELINE><![CDATA[N]]></ISSAMELINE> <!--4C85D478837741C4A3AD74CFF852A470--> <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY> @@ -8647,7 +8647,7 @@ <!--8C679A6AD6294811B5936EE59035CE36--> <IGNOREINWAD><![CDATA[N]]></IGNOREINWAD> <!--8C679A6AD6294811B5936EE59035CE36--> <ISDISPLAYED><![CDATA[N]]></ISDISPLAYED> <!--8C679A6AD6294811B5936EE59035CE36--> <DISPLAYLENGTH><![CDATA[60]]></DISPLAYLENGTH> -<!--8C679A6AD6294811B5936EE59035CE36--> <ISREADONLY><![CDATA[N]]></ISREADONLY> +<!--8C679A6AD6294811B5936EE59035CE36--> <ISREADONLY><![CDATA[Y]]></ISREADONLY> <!--8C679A6AD6294811B5936EE59035CE36--> <SEQNO><![CDATA[110]]></SEQNO> <!--8C679A6AD6294811B5936EE59035CE36--> <ISSAMELINE><![CDATA[N]]></ISSAMELINE> <!--8C679A6AD6294811B5936EE59035CE36--> <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY> @@ -9204,7 +9204,7 @@ <!--9AAFA2F30B80413A9A0B2CEE6B79D896--> <IGNOREINWAD><![CDATA[N]]></IGNOREINWAD> <!--9AAFA2F30B80413A9A0B2CEE6B79D896--> <ISDISPLAYED><![CDATA[N]]></ISDISPLAYED> <!--9AAFA2F30B80413A9A0B2CEE6B79D896--> <DISPLAYLENGTH><![CDATA[12]]></DISPLAYLENGTH> -<!--9AAFA2F30B80413A9A0B2CEE6B79D896--> <ISREADONLY><![CDATA[N]]></ISREADONLY> +<!--9AAFA2F30B80413A9A0B2CEE6B79D896--> <ISREADONLY><![CDATA[Y]]></ISREADONLY> <!--9AAFA2F30B80413A9A0B2CEE6B79D896--> <SEQNO><![CDATA[100]]></SEQNO> <!--9AAFA2F30B80413A9A0B2CEE6B79D896--> <ISSAMELINE><![CDATA[N]]></ISSAMELINE> <!--9AAFA2F30B80413A9A0B2CEE6B79D896--> <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY> @@ -10784,7 +10784,7 @@ <!--A8EFFCB47F294104ACFB133AB0796BDA--> <IGNOREINWAD><![CDATA[N]]></IGNOREINWAD> <!--A8EFFCB47F294104ACFB133AB0796BDA--> <ISDISPLAYED><![CDATA[N]]></ISDISPLAYED> <!--A8EFFCB47F294104ACFB133AB0796BDA--> <DISPLAYLENGTH><![CDATA[2]]></DISPLAYLENGTH> -<!--A8EFFCB47F294104ACFB133AB0796BDA--> <ISREADONLY><![CDATA[N]]></ISREADONLY> +<!--A8EFFCB47F294104ACFB133AB0796BDA--> <ISREADONLY><![CDATA[Y]]></ISREADONLY> <!--A8EFFCB47F294104ACFB133AB0796BDA--> <SEQNO><![CDATA[110]]></SEQNO> <!--A8EFFCB47F294104ACFB133AB0796BDA--> <ISSAMELINE><![CDATA[Y]]></ISSAMELINE> <!--A8EFFCB47F294104ACFB133AB0796BDA--> <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY> @@ -12545,7 +12545,7 @@ <!--BC285AC574F34D17989E36E026B0B7AC--> <IGNOREINWAD><![CDATA[N]]></IGNOREINWAD> <!--BC285AC574F34D17989E36E026B0B7AC--> <ISDISPLAYED><![CDATA[N]]></ISDISPLAYED> <!--BC285AC574F34D17989E36E026B0B7AC--> <DISPLAYLENGTH><![CDATA[32]]></DISPLAYLENGTH> -<!--BC285AC574F34D17989E36E026B0B7AC--> <ISREADONLY><![CDATA[N]]></ISREADONLY> +<!--BC285AC574F34D17989E36E026B0B7AC--> <ISREADONLY><![CDATA[Y]]></ISREADONLY> <!--BC285AC574F34D17989E36E026B0B7AC--> <SEQNO><![CDATA[5]]></SEQNO> <!--BC285AC574F34D17989E36E026B0B7AC--> <ISSAMELINE><![CDATA[N]]></ISSAMELINE> <!--BC285AC574F34D17989E36E026B0B7AC--> <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY> @@ -12656,7 +12656,7 @@ <!--BDB618555E854CF4B8E8E74E871F86D0--> <IGNOREINWAD><![CDATA[N]]></IGNOREINWAD> <!--BDB618555E854CF4B8E8E74E871F86D0--> <ISDISPLAYED><![CDATA[N]]></ISDISPLAYED> <!--BDB618555E854CF4B8E8E74E871F86D0--> <DISPLAYLENGTH><![CDATA[2]]></DISPLAYLENGTH> -<!--BDB618555E854CF4B8E8E74E871F86D0--> <ISREADONLY><![CDATA[N]]></ISREADONLY> +<!--BDB618555E854CF4B8E8E74E871F86D0--> <ISREADONLY><![CDATA[Y]]></ISREADONLY> <!--BDB618555E854CF4B8E8E74E871F86D0--> <SEQNO><![CDATA[100]]></SEQNO> <!--BDB618555E854CF4B8E8E74E871F86D0--> <ISSAMELINE><![CDATA[N]]></ISSAMELINE> <!--BDB618555E854CF4B8E8E74E871F86D0--> <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY> @@ -13621,7 +13621,7 @@ <!--D1B72C2B0B8B4B948E4FFC0165512895--> <IGNOREINWAD><![CDATA[N]]></IGNOREINWAD> <!--D1B72C2B0B8B4B948E4FFC0165512895--> <ISDISPLAYED><![CDATA[N]]></ISDISPLAYED> <!--D1B72C2B0B8B4B948E4FFC0165512895--> <DISPLAYLENGTH><![CDATA[32]]></DISPLAYLENGTH> -<!--D1B72C2B0B8B4B948E4FFC0165512895--> <ISREADONLY><![CDATA[N]]></ISREADONLY> +<!--D1B72C2B0B8B4B948E4FFC0165512895--> <ISREADONLY><![CDATA[Y]]></ISREADONLY> <!--D1B72C2B0B8B4B948E4FFC0165512895--> <SEQNO><![CDATA[90]]></SEQNO> <!--D1B72C2B0B8B4B948E4FFC0165512895--> <ISSAMELINE><![CDATA[N]]></ISSAMELINE> <!--D1B72C2B0B8B4B948E4FFC0165512895--> <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY> diff -r 16ff20ea3c8c -r b741958ab65c src-db/database/model/tables/M_TRANSACTION.xml --- a/src-db/database/model/tables/M_TRANSACTION.xml Fri Aug 10 09:40:23 2012 +0200 +++ b/src-db/database/model/tables/M_TRANSACTION.xml Fri Aug 10 12:14:01 2012 +0200 @@ -115,7 +115,7 @@ </column> <column name="COSTING_STATUS" primaryKey="false" required="true" type="VARCHAR" size="60" autoIncrement="false"> <default><![CDATA[NC]]></default> - <onCreateDefault><![CDATA[CASE WHEN ISCOSTCALCULATED='Y' THEN 'CC' ELSE 'NC' END]]></onCreateDefault> + <onCreateDefault/> </column> <foreign-key foreignTable="M_INTERNAL_CONSUMPTIONLINE" name="M_INTL_CONSUMP_MTRANSACTION"> <reference local="M_INTERNAL_CONSUMPTIONLINE_ID" foreign="M_INTERNAL_CONSUMPTIONLINE_ID"/> diff -r 16ff20ea3c8c -r b741958ab65c src-db/database/sourcedata/AD_CALLOUT.xml --- a/src-db/database/sourcedata/AD_CALLOUT.xml Fri Aug 10 09:40:23 2012 +0200 +++ b/src-db/database/sourcedata/AD_CALLOUT.xml Fri Aug 10 12:14:01 2012 +0200 @@ -999,6 +999,16 @@ <!--DF9F61C8E2274735932F195DCF9CE949--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> <!--DF9F61C8E2274735932F195DCF9CE949--></AD_CALLOUT> +<!--E361D3C5088C46708474F2C6F1EC1EAE--><AD_CALLOUT> +<!--E361D3C5088C46708474F2C6F1EC1EAE--> <AD_CALLOUT_ID><![CDATA[E361D3C5088C46708474F2C6F1EC1EAE]]></AD_CALLOUT_ID> +<!--E361D3C5088C46708474F2C6F1EC1EAE--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--E361D3C5088C46708474F2C6F1EC1EAE--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--E361D3C5088C46708474F2C6F1EC1EAE--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--E361D3C5088C46708474F2C6F1EC1EAE--> <NAME><![CDATA[SL_StatusFieldDefaults]]></NAME> +<!--E361D3C5088C46708474F2C6F1EC1EAE--> <DESCRIPTION><![CDATA[Handles setting 'Read-only' flag when 'Show is Status Bar' flag is checked. ]]></DESCRIPTION> +<!--E361D3C5088C46708474F2C6F1EC1EAE--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> +<!--E361D3C5088C46708474F2C6F1EC1EAE--></AD_CALLOUT> + <!--E533C48595374A57885EF3761173F235--><AD_CALLOUT> <!--E533C48595374A57885EF3761173F235--> <AD_CALLOUT_ID><![CDATA[E533C48595374A57885EF3761173F235]]></AD_CALLOUT_ID> <!--E533C48595374A57885EF3761173F235--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> diff -r 16ff20ea3c8c -r b741958ab65c src-db/database/sourcedata/AD_COLUMN.xml --- a/src-db/database/sourcedata/AD_COLUMN.xml Fri Aug 10 09:40:23 2012 +0200 +++ b/src-db/database/sourcedata/AD_COLUMN.xml Fri Aug 10 12:14:01 2012 +0200 @@ -250525,6 +250525,7 @@ <!--744D56EC1783443EA8499498121C551A--> <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR> <!--744D56EC1783443EA8499498121C551A--> <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY> <!--744D56EC1783443EA8499498121C551A--> <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE> +<!--744D56EC1783443EA8499498121C551A--> <AD_CALLOUT_ID><![CDATA[E361D3C5088C46708474F2C6F1EC1EAE]]></AD_CALLOUT_ID> <!--744D56EC1783443EA8499498121C551A--> <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS> <!--744D56EC1783443EA8499498121C551A--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> <!--744D56EC1783443EA8499498121C551A--> <POSITION><![CDATA[33]]></POSITION> diff -r 16ff20ea3c8c -r b741958ab65c src-db/database/sourcedata/AD_FIELD.xml --- a/src-db/database/sourcedata/AD_FIELD.xml Fri Aug 10 09:40:23 2012 +0200 +++ b/src-db/database/sourcedata/AD_FIELD.xml Fri Aug 10 12:14:01 2012 +0200 @@ -11528,7 +11528,6 @@ <!--924--> <AD_COLUMN_ID><![CDATA[2007]]></AD_COLUMN_ID> <!--924--> <IGNOREINWAD><![CDATA[N]]></IGNOREINWAD> <!--924--> <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED> -<!--924--> <DISPLAYLOGIC><![CDATA[@IsDisplayed@='Y']]></DISPLAYLOGIC> <!--924--> <DISPLAYLENGTH><![CDATA[1]]></DISPLAYLENGTH> <!--924--> <ISREADONLY><![CDATA[N]]></ISREADONLY> <!--924--> <SEQNO><![CDATA[70]]></SEQNO> @@ -29744,7 +29743,7 @@ <!--2428--> <ISDISPLAYED><![CDATA[N]]></ISDISPLAYED> <!--2428--> <DISPLAYLOGIC><![CDATA[@IsCustomer@='Y']]></DISPLAYLOGIC> <!--2428--> <DISPLAYLENGTH><![CDATA[10]]></DISPLAYLENGTH> -<!--2428--> <ISREADONLY><![CDATA[N]]></ISREADONLY> +<!--2428--> <ISREADONLY><![CDATA[Y]]></ISREADONLY> <!--2428--> <SEQNO><![CDATA[160]]></SEQNO> <!--2428--> <ISSAMELINE><![CDATA[Y]]></ISSAMELINE> <!--2428--> <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY> @@ -142014,7 +142013,7 @@ <!--803150--> <ISDISPLAYED><![CDATA[N]]></ISDISPLAYED> <!--803150--> <DISPLAYLOGIC><![CDATA[@IsDepreciated@='Y']]></DISPLAYLOGIC> <!--803150--> <DISPLAYLENGTH><![CDATA[12]]></DISPLAYLENGTH> -<!--803150--> <ISREADONLY><![CDATA[N]]></ISREADONLY> +<!--803150--> <ISREADONLY><![CDATA[Y]]></ISREADONLY> <!--803150--> <SEQNO><![CDATA[250]]></SEQNO> <!--803150--> <ISSAMELINE><![CDATA[Y]]></ISSAMELINE> <!--803150--> <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY> @@ -142044,7 +142043,7 @@ <!--803151--> <ISDISPLAYED><![CDATA[N]]></ISDISPLAYED> <!--803151--> <DISPLAYLOGIC><![CDATA[@IsDepreciated@='Y']]></DISPLAYLOGIC> <!--803151--> <DISPLAYLENGTH><![CDATA[12]]></DISPLAYLENGTH> -<!--803151--> <ISREADONLY><![CDATA[N]]></ISREADONLY> +<!--803151--> <ISREADONLY><![CDATA[Y]]></ISREADONLY> <!--803151--> <SEQNO><![CDATA[260]]></SEQNO> <!--803151--> <ISSAMELINE><![CDATA[N]]></ISSAMELINE> <!--803151--> <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY> @@ -170828,7 +170827,7 @@ <!--1004400096--> <IGNOREINWAD><![CDATA[N]]></IGNOREINWAD> <!--1004400096--> <ISDISPLAYED><![CDATA[N]]></ISDISPLAYED> <!--1004400096--> <DISPLAYLENGTH><![CDATA[1]]></DISPLAYLENGTH> -<!--1004400096--> <ISREADONLY><![CDATA[N]]></ISREADONLY> +<!--1004400096--> <ISREADONLY><![CDATA[Y]]></ISREADONLY> <!--1004400096--> <SEQNO><![CDATA[210]]></SEQNO> <!--1004400096--> <ISSAMELINE><![CDATA[Y]]></ISSAMELINE> <!--1004400096--> <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY> @@ -170857,7 +170856,7 @@ <!--1004400098--> <IGNOREINWAD><![CDATA[N]]></IGNOREINWAD> <!--1004400098--> <ISDISPLAYED><![CDATA[N]]></ISDISPLAYED> <!--1004400098--> <DISPLAYLENGTH><![CDATA[1]]></DISPLAYLENGTH> -<!--1004400098--> <ISREADONLY><![CDATA[N]]></ISREADONLY> +<!--1004400098--> <ISREADONLY><![CDATA[Y]]></ISREADONLY> <!--1004400098--> <SEQNO><![CDATA[220]]></SEQNO> <!--1004400098--> <ISSAMELINE><![CDATA[Y]]></ISSAMELINE> <!--1004400098--> <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY> @@ -180877,7 +180876,7 @@ <!--326B46ABC9644BDFB5358DBC226EA3E3--> <IGNOREINWAD><![CDATA[N]]></IGNOREINWAD> <!--326B46ABC9644BDFB5358DBC226EA3E3--> <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED> <!--326B46ABC9644BDFB5358DBC226EA3E3--> <DISPLAYLENGTH><![CDATA[1]]></DISPLAYLENGTH> -<!--326B46ABC9644BDFB5358DBC226EA3E3--> <ISREADONLY><![CDATA[N]]></ISREADONLY> +<!--326B46ABC9644BDFB5358DBC226EA3E3--> <ISREADONLY><![CDATA[Y]]></ISREADONLY> <!--326B46ABC9644BDFB5358DBC226EA3E3--> <SEQNO><![CDATA[50]]></SEQNO> <!--326B46ABC9644BDFB5358DBC226EA3E3--> <ISSAMELINE><![CDATA[N]]></ISSAMELINE> <!--326B46ABC9644BDFB5358DBC226EA3E3--> <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY> @@ -195189,7 +195188,7 @@ <!--606A112082634E7C91581F1A838D1CF8--> <IGNOREINWAD><![CDATA[N]]></IGNOREINWAD> <!--606A112082634E7C91581F1A838D1CF8--> <ISDISPLAYED><![CDATA[N]]></ISDISPLAYED> <!--606A112082634E7C91581F1A838D1CF8--> <DISPLAYLENGTH><![CDATA[22]]></DISPLAYLENGTH> -<!--606A112082634E7C91581F1A838D1CF8--> <ISREADONLY><![CDATA[N]]></ISREADONLY> +<!--606A112082634E7C91581F1A838D1CF8--> <ISREADONLY><![CDATA[Y]]></ISREADONLY> <!--606A112082634E7C91581F1A838D1CF8--> <SEQNO><![CDATA[160]]></SEQNO> <!--606A112082634E7C91581F1A838D1CF8--> <ISSAMELINE><![CDATA[N]]></ISSAMELINE> <!--606A112082634E7C91581F1A838D1CF8--> <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY> @@ -200327,7 +200326,7 @@ <!--79B4C19CB5A44AEA930E2AE09321CDEF--> <IGNOREINWAD><![CDATA[N]]></IGNOREINWAD> <!--79B4C19CB5A44AEA930E2AE09321CDEF--> <ISDISPLAYED><![CDATA[N]]></ISDISPLAYED> <!--79B4C19CB5A44AEA930E2AE09321CDEF--> <DISPLAYLENGTH><![CDATA[32]]></DISPLAYLENGTH> -<!--79B4C19CB5A44AEA930E2AE09321CDEF--> <ISREADONLY><![CDATA[N]]></ISREADONLY> +<!--79B4C19CB5A44AEA930E2AE09321CDEF--> <ISREADONLY><![CDATA[Y]]></ISREADONLY> <!--79B4C19CB5A44AEA930E2AE09321CDEF--> <SEQNO><![CDATA[170]]></SEQNO> <!--79B4C19CB5A44AEA930E2AE09321CDEF--> <ISSAMELINE><![CDATA[N]]></ISSAMELINE> <!--79B4C19CB5A44AEA930E2AE09321CDEF--> <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY> @@ -206084,7 +206083,7 @@ <!--82F2E8A160EC472CE040007F01005324--> <IGNOREINWAD><![CDATA[N]]></IGNOREINWAD> <!--82F2E8A160EC472CE040007F01005324--> <ISDISPLAYED><![CDATA[N]]></ISDISPLAYED> <!--82F2E8A160EC472CE040007F01005324--> <DISPLAYLENGTH><![CDATA[12]]></DISPLAYLENGTH> -<!--82F2E8A160EC472CE040007F01005324--> <ISREADONLY><![CDATA[N]]></ISREADONLY> +<!--82F2E8A160EC472CE040007F01005324--> <ISREADONLY><![CDATA[Y]]></ISREADONLY> <!--82F2E8A160EC472CE040007F01005324--> <SEQNO><![CDATA[200]]></SEQNO> <!--82F2E8A160EC472CE040007F01005324--> <ISSAMELINE><![CDATA[N]]></ISSAMELINE> <!--82F2E8A160EC472CE040007F01005324--> <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY> diff -r 16ff20ea3c8c -r b741958ab65c src-db/database/sourcedata/AD_MODEL_OBJECT.xml --- a/src-db/database/sourcedata/AD_MODEL_OBJECT.xml Fri Aug 10 09:40:23 2012 +0200 +++ b/src-db/database/sourcedata/AD_MODEL_OBJECT.xml Fri Aug 10 12:14:01 2012 +0200 @@ -3296,6 +3296,18 @@ <!--36A67D2D76A5488491850AF14F83A6FF--> <SEQNO><![CDATA[10]]></SEQNO> <!--36A67D2D76A5488491850AF14F83A6FF--></AD_MODEL_OBJECT> +<!--3C1D6B96736B4E2D9FF327EF4EB38DF6--><AD_MODEL_OBJECT> +<!--3C1D6B96736B4E2D9FF327EF4EB38DF6--> <AD_MODEL_OBJECT_ID><![CDATA[3C1D6B96736B4E2D9FF327EF4EB38DF6]]></AD_MODEL_OBJECT_ID> +<!--3C1D6B96736B4E2D9FF327EF4EB38DF6--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--3C1D6B96736B4E2D9FF327EF4EB38DF6--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--3C1D6B96736B4E2D9FF327EF4EB38DF6--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--3C1D6B96736B4E2D9FF327EF4EB38DF6--> <ACTION><![CDATA[C]]></ACTION> +<!--3C1D6B96736B4E2D9FF327EF4EB38DF6--> <CLASSNAME><![CDATA[org.openbravo.erpCommon.ad_callouts.SL_StatusFieldDefaults]]></CLASSNAME> +<!--3C1D6B96736B4E2D9FF327EF4EB38DF6--> <ISDEFAULT><![CDATA[Y]]></ISDEFAULT> +<!--3C1D6B96736B4E2D9FF327EF4EB38DF6--> <AD_CALLOUT_ID><![CDATA[E361D3C5088C46708474F2C6F1EC1EAE]]></AD_CALLOUT_ID> +<!--3C1D6B96736B4E2D9FF327EF4EB38DF6--> <OBJECT_TYPE><![CDATA[S]]></OBJECT_TYPE> +<!--3C1D6B96736B4E2D9FF327EF4EB38DF6--></AD_MODEL_OBJECT> + <!--3F874173A01B43C0ACEA29111CE98ECE--><AD_MODEL_OBJECT> <!--3F874173A01B43C0ACEA29111CE98ECE--> <AD_MODEL_OBJECT_ID><![CDATA[3F874173A01B43C0ACEA29111CE98ECE]]></AD_MODEL_OBJECT_ID> <!--3F874173A01B43C0ACEA29111CE98ECE--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> diff -r 16ff20ea3c8c -r b741958ab65c src-db/database/sourcedata/AD_MODEL_OBJECT_MAPPING.xml --- a/src-db/database/sourcedata/AD_MODEL_OBJECT_MAPPING.xml Fri Aug 10 09:40:23 2012 +0200 +++ b/src-db/database/sourcedata/AD_MODEL_OBJECT_MAPPING.xml Fri Aug 10 12:14:01 2012 +0200 @@ -3520,6 +3520,16 @@ <!--0F632C9E534842279100F13F314CB602--> <ISDEFAULT><![CDATA[Y]]></ISDEFAULT> <!--0F632C9E534842279100F13F314CB602--></AD_MODEL_OBJECT_MAPPING> +<!--0F63EC624B2F46E89355DEF143BC1BD7--><AD_MODEL_OBJECT_MAPPING> +<!--0F63EC624B2F46E89355DEF143BC1BD7--> <AD_MODEL_OBJECT_MAPPING_ID><![CDATA[0F63EC624B2F46E89355DEF143BC1BD7]]></AD_MODEL_OBJECT_MAPPING_ID> +<!--0F63EC624B2F46E89355DEF143BC1BD7--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--0F63EC624B2F46E89355DEF143BC1BD7--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--0F63EC624B2F46E89355DEF143BC1BD7--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--0F63EC624B2F46E89355DEF143BC1BD7--> <AD_MODEL_OBJECT_ID><![CDATA[3C1D6B96736B4E2D9FF327EF4EB38DF6]]></AD_MODEL_OBJECT_ID> +<!--0F63EC624B2F46E89355DEF143BC1BD7--> <MAPPINGNAME><![CDATA[/ad_callouts/SL_StatusFieldDefaults.html]]></MAPPINGNAME> +<!--0F63EC624B2F46E89355DEF143BC1BD7--> <ISDEFAULT><![CDATA[Y]]></ISDEFAULT> +<!--0F63EC624B2F46E89355DEF143BC1BD7--></AD_MODEL_OBJECT_MAPPING> + <!--0F81258D03F3440CA58B89763EFE1BE5--><AD_MODEL_OBJECT_MAPPING> <!--0F81258D03F3440CA58B89763EFE1BE5--> <AD_MODEL_OBJECT_MAPPING_ID><![CDATA[0F81258D03F3440CA58B89763EFE1BE5]]></AD_MODEL_OBJECT_MAPPING_ID> <!--0F81258D03F3440CA58B89763EFE1BE5--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> diff -r 16ff20ea3c8c -r b741958ab65c src-util/modulescript/build/classes/org/openbravo/modulescript/UpdateMTransactionCostingStatus.class Binary file src-util/modulescript/build/classes/org/openbravo/modulescript/UpdateMTransactionCostingStatus.class has changed diff -r 16ff20ea3c8c -r b741958ab65c src-util/modulescript/src/org/openbravo/modulescript/UpdateMTransactionCostingStatus.java --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/src-util/modulescript/src/org/openbravo/modulescript/UpdateMTransactionCostingStatus.java Fri Aug 10 12:14:01 2012 +0200 @@ -0,0 +1,48 @@ +/* + ************************************************************************* + * The contents of this file are subject to the Openbravo Public License + * Version 1.0 (the "License"), being the Mozilla Public License + * Version 1.1 with a permitted attribution clause; you may not use this + * file except in compliance with the License. You may obtain a copy of + * the License at http://www.openbravo.com/legal/license.html + * Software distributed under the License is distributed on an "AS IS" + * basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. See the + * License for the specific language governing rights and limitations + * under the License. + * The Original Code is Openbravo ERP. + * The Initial Developer of the Original Code is Openbravo SLU + * All portions are Copyright (C) 2012 Openbravo SLU + * All Rights Reserved. + * Contributor(s): ______________________________________. + ************************************************************************* + */ +package org.openbravo.modulescript; + +import java.sql.PreparedStatement; +import java.sql.SQLException; + +import org.openbravo.database.ConnectionProvider; +import org.openbravo.modulescript.ModuleScript; + +public class UpdateMTransactionCostingStatus extends ModuleScript { + + public void execute() { + PreparedStatement ps = null; + try { + ConnectionProvider cp = getConnectionProvider(); + ps = cp + .getPreparedStatement("UPDATE m_transaction SET costing_status = 'CC' WHERE iscostcalculated = 'Y' AND costing_status = 'NC'"); + ps.executeUpdate(); + } catch (Exception e) { + handleError(e); + } finally { + try { + if (!ps.isClosed()) { + ps.close(); + } ------------------------------------------------------------------------------ Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ _______________________________________________ Openbravo-commits mailing list Openbravo-commits@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/openbravo-commits