details: https://code.openbravo.com/erp/devel/pi/rev/757a15bcdfb8 changeset: 32778:757a15bcdfb8 user: Atul Gaware <atul.gaware <at> openbravo.com> date: Thu Sep 21 20:24:21 2017 +0530 summary: Fixes issue 36723: New storage bins are created with Undefined-Overissue status instead of Undefined by default
** Set id of Undefined inventory status as default value for column m_inventorystatus_id in m_locator table as well as tables and columns in application dictionary ** Adapt Initialize Inventory Status modulescript to set Undefined-overdue status to locator of the clients where allow negative stock flag is set as Yes details: https://code.openbravo.com/erp/devel/pi/rev/e2809fc56fee changeset: 32779:e2809fc56fee user: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com> date: Thu Sep 21 18:57:37 2017 +0200 summary: Related to issue 36723: Fix modulescript limits diffstat: src-db/database/model/tables/M_LOCATOR.xml | 2 +- src-db/database/sourcedata/AD_COLUMN.xml | 2 +- src-util/modulescript/build/classes/org/openbravo/modulescript/InitializeInventoryStatus.class | 0 src-util/modulescript/src/org/openbravo/modulescript/InitializeInventoryStatus.java | 25 +++++---- 4 files changed, 16 insertions(+), 13 deletions(-) diffs (77 lines): diff -r f131c363d9be -r e2809fc56fee src-db/database/model/tables/M_LOCATOR.xml --- a/src-db/database/model/tables/M_LOCATOR.xml Thu Sep 21 14:30:09 2017 +0000 +++ b/src-db/database/model/tables/M_LOCATOR.xml Thu Sep 21 18:57:37 2017 +0200 @@ -66,7 +66,7 @@ <onCreateDefault/> </column> <column name="M_INVENTORYSTATUS_ID" primaryKey="false" required="true" type="VARCHAR" size="32" autoIncrement="false"> - <default><![CDATA[0]]></default> + <default><![CDATA[7B3DC15A20234C418D26EECDC5D59003]]></default> <onCreateDefault><![CDATA['0']]></onCreateDefault> </column> <column name="CHANGE_STATUS" primaryKey="false" required="true" type="CHAR" size="1" autoIncrement="false"> diff -r f131c363d9be -r e2809fc56fee src-db/database/sourcedata/AD_COLUMN.xml --- a/src-db/database/sourcedata/AD_COLUMN.xml Thu Sep 21 14:30:09 2017 +0000 +++ b/src-db/database/sourcedata/AD_COLUMN.xml Thu Sep 21 18:57:37 2017 +0200 @@ -368545,7 +368545,7 @@ <!--D7422D1734144D74A852896F6DB8EADA--> <AD_REFERENCE_ID><![CDATA[95E2A8B50A254B2AAE6774B8C2F28120]]></AD_REFERENCE_ID> <!--D7422D1734144D74A852896F6DB8EADA--> <AD_REFERENCE_VALUE_ID><![CDATA[7762716851904CC9AC1CF39787F1FBF4]]></AD_REFERENCE_VALUE_ID> <!--D7422D1734144D74A852896F6DB8EADA--> <FIELDLENGTH><![CDATA[32]]></FIELDLENGTH> -<!--D7422D1734144D74A852896F6DB8EADA--> <DEFAULTVALUE><![CDATA[0]]></DEFAULTVALUE> +<!--D7422D1734144D74A852896F6DB8EADA--> <DEFAULTVALUE><![CDATA[7B3DC15A20234C418D26EECDC5D59003]]></DEFAULTVALUE> <!--D7422D1734144D74A852896F6DB8EADA--> <ISKEY><![CDATA[N]]></ISKEY> <!--D7422D1734144D74A852896F6DB8EADA--> <ISPARENT><![CDATA[N]]></ISPARENT> <!--D7422D1734144D74A852896F6DB8EADA--> <ISMANDATORY><![CDATA[Y]]></ISMANDATORY> diff -r f131c363d9be -r e2809fc56fee src-util/modulescript/build/classes/org/openbravo/modulescript/InitializeInventoryStatus.class Binary file src-util/modulescript/build/classes/org/openbravo/modulescript/InitializeInventoryStatus.class has changed diff -r f131c363d9be -r e2809fc56fee src-util/modulescript/src/org/openbravo/modulescript/InitializeInventoryStatus.java --- a/src-util/modulescript/src/org/openbravo/modulescript/InitializeInventoryStatus.java Thu Sep 21 14:30:09 2017 +0000 +++ b/src-util/modulescript/src/org/openbravo/modulescript/InitializeInventoryStatus.java Thu Sep 21 18:57:37 2017 +0200 @@ -19,33 +19,36 @@ package org.openbravo.modulescript; -import org.apache.log4j.Logger; import org.openbravo.database.ConnectionProvider; -import org.openbravo.utils.FormatUtilities; public class InitializeInventoryStatus extends ModuleScript { - + final static String INVENTORY_STATUS_NO_NEGATIVE_STOCK = "7B3DC15A20234C418D26EECDC5D59003"; + final static String INVENTORY_STATUS_NEGATIVE_STOCK = "0"; @Override - // Initialize the Inventory Status for Clients with allowNegativeStock = 'Y' + // Initialize locators inventory status of clients with allowNegativeStock = 'Y' as + // "Undefined-OverIssue" and with allowNegativeStock = 'N' as "Undefined" public void execute() { try { ConnectionProvider cp = getConnectionProvider(); - InitializeInventoryStatusData [] clients = InitializeInventoryStatusData.getClientIds(cp); - for(int i =0; i< clients.length;i++){ - if (!InitializeInventoryStatusData.isNegativeStockAllowed(cp, clients[i].adClientId)){ - InitializeInventoryStatusData.initializeInventoryStatus(cp, INVENTORY_STATUS_NO_NEGATIVE_STOCK, clients[i].adClientId); + InitializeInventoryStatusData[] clients = InitializeInventoryStatusData.getClientIds(cp); + for (int i = 0; i < clients.length; i++) { + if (!InitializeInventoryStatusData.isNegativeStockAllowed(cp, clients[i].adClientId)) { + InitializeInventoryStatusData.initializeInventoryStatus(cp, + INVENTORY_STATUS_NO_NEGATIVE_STOCK, clients[i].adClientId); + } else { + InitializeInventoryStatusData.initializeInventoryStatus(cp, + INVENTORY_STATUS_NEGATIVE_STOCK, clients[i].adClientId); } } } catch (Exception e) { handleError(e); } } - + @Override protected ModuleScriptExecutionLimits getModuleScriptExecutionLimits() { - return new ModuleScriptExecutionLimits("0", new OpenbravoVersion(3,0,31774), - null); + return new ModuleScriptExecutionLimits("0", null, new OpenbravoVersion(3, 0, 32778)); } } ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot _______________________________________________ Openbravo-commits mailing list Openbravo-commits@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/openbravo-commits
