[OpenbravoERP-commits] devel/pi: 2 new changesets
details: https://code.openbravo.com/erp/devel/pi/rev/ad75d3cb1744 changeset: 34772:ad75d3cb1744 user: RM packaging bot openbravo.com> date: Wed Sep 12 19:19:30 2018 + summary: CI: update AD_MODULE to version 34771 details: https://code.openbravo.com/erp/devel/pi/rev/956f70249104 changeset: 34773:956f70249104 user: RM packaging bot openbravo.com> date: Wed Sep 12 19:33:31 2018 + summary: CI: merge back from main diffstat: modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_MODULE.xml | 2 +- modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml | 4 +- modules/org.openbravo.apachejdbcconnectionpool/src-db/database/sourcedata/AD_MODULE.xml | 2 +- modules/org.openbravo.apachejdbcconnectionpool/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml | 2 +- modules/org.openbravo.base.weld/src-db/database/sourcedata/AD_MODULE.xml | 2 +- modules/org.openbravo.base.weld/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml | 2 +- modules/org.openbravo.client.application/src-db/database/sourcedata/AD_MODULE.xml | 2 +- modules/org.openbravo.client.application/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml | 8 +- modules/org.openbravo.client.htmlwidget/src-db/database/sourcedata/AD_MODULE.xml | 2 +- modules/org.openbravo.client.htmlwidget/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml | 2 +- modules/org.openbravo.client.kernel/src-db/database/sourcedata/AD_MODULE.xml | 2 +- modules/org.openbravo.client.kernel/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml | 6 +- modules/org.openbravo.client.myob/src-db/database/sourcedata/AD_MODULE.xml | 2 +- modules/org.openbravo.client.myob/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml | 4 +- modules/org.openbravo.client.querylist/src-db/database/sourcedata/AD_MODULE.xml | 2 +- modules/org.openbravo.client.querylist/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml | 2 +- modules/org.openbravo.client.widgets/src-db/database/sourcedata/AD_MODULE.xml | 2 +- modules/org.openbravo.client.widgets/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml | 2 +- modules/org.openbravo.financial.paymentreport/src-db/database/sourcedata/AD_MODULE.xml | 2 +- modules/org.openbravo.financial.paymentreport/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml | 2 +- modules/org.openbravo.reports.ordersawaitingdelivery/src-db/database/sourcedata/AD_MODULE.xml | 2 +- modules/org.openbravo.reports.ordersawaitingdelivery/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml | 2 +- modules/org.openbravo.service.datasource/src-db/database/sourcedata/AD_MODULE.xml | 2 +- modules/org.openbravo.service.datasource/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml | 10 ++-- modules/org.openbravo.service.integration.google/src-db/database/sourcedata/AD_MODULE.xml | 2 +- modules/org.openbravo.service.integration.google/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml | 4 +- modules/org.openbravo.service.integration.openid/src-db/database/sourcedata/AD_MODULE.xml | 2 +- modules/org.openbravo.service.integration.openid/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml | 2 +- modules/org.openbravo.service.json/src-db/database/sourcedata/AD_MODULE.xml | 2 +- modules/org.openbravo.service.json/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml | 2 +- modules/org.openbravo.userinterface.selector/src-db/database/sourcedata/AD_MODULE.xml | 2 +- modules/org.openbravo.userinterface.selector/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml | 12 ++-- modules/org.openbravo.userinterface.skin.250to300Comp/src-db/database/sourcedata/AD_MODULE.xml | 2 +- modules/org.openbravo.userinterface.skin.250to300Comp/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml | 2 +- modules/org.openbravo.userinterface.smartclient/src-db/database/sourcedata/AD_MODULE.xml | 2 +- modules/org.openbravo.userinterface.smartclient/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml | 6 +- modules/org.openbravo.utility.cleanup.log/src-db/database/sourcedata/AD_MODULE.xml | 2 +- modules/org.openbravo.utility.cleanup.log/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml | 2 +-
[OpenbravoERP-commits] devel/main: 19 new changesets
details: https://code.openbravo.com/erp/devel/main/rev/1cadd83c2d38 changeset: 34754:1cadd83c2d38 user: Asier Martirena openbravo.com> date: Mon Aug 27 13:19:45 2018 +0200 summary: Related to issue 39067: The delivered property is not being correctly set for C If the canceled order was delivered and the associateShipmentToNewReceipt preference is set, the new order will also be delivered. Instead of doing a query, the delivered status is checked to know the previous status. A netting shipment doesn't count as delivered. details: https://code.openbravo.com/erp/devel/main/rev/7cf48543695c changeset: 34755:7cf48543695c user: RM packaging bot openbravo.com> date: Thu Aug 30 16:45:24 2018 + summary: CI: merge back from main details: https://code.openbravo.com/erp/devel/main/rev/3f8e11983f29 changeset: 34756:3f8e11983f29 user: Pablo Lujan openbravo.com date: Fri Aug 31 01:34:21 2018 +0200 summary: Fixes issue 39208 and related to issue 29414: Updated browsers * Chrome: Supported 68, recommended 69 or higher. * Firefox: Supported 52, recommended 60 or higher. * Internet Explorer: Supported 9, recommended 11 or higher. * EdgeHTML (MS Edge): Supported 41, recommended 42 or higher, * Safari: Supported 8, recommended 9 or higher. details: https://code.openbravo.com/erp/devel/main/rev/bc3da89075bb changeset: 34757:bc3da89075bb user: Augusto Mauch openbravo.com> date: Wed Sep 05 18:19:38 2018 +0200 summary: Fixes issue 39230: Removes unneeded reference to COMMERCIAL_TIER column The column was removed in this changeset [1], but some code referencing it programatically was left unremoved. This code was putting the tier info in a map, there is no problem removing it because it was no longer being checked. [1] https://code.openbravo.com/erp/devel/pi/rev/7a4554ef6d4aec661601cddaac3b4212ab8e8371 details: https://code.openbravo.com/erp/devel/main/rev/82f92b9d402a changeset: 34758:82f92b9d402a user: Mark gmail.com> date: Mon Aug 27 21:12:20 2018 -0400 summary: Related to issue 39158: Added missing indexes to improve performance Created new indexes to improve performance. details: https://code.openbravo.com/erp/devel/main/rev/2d2e28bdaba7 changeset: 34759:2d2e28bdaba7 user: Asier Martirena openbravo.com> date: Mon Sep 03 15:32:44 2018 +0200 summary: Related to issue 39067: Change in the isDelivered flag All canceled order have now the isDelivered flag to true (both canceled and cancelling orders). details: https://code.openbravo.com/erp/devel/main/rev/686664db43e1 changeset: 34760:686664db43e1 user: Mark gmail.com> date: Thu Sep 06 10:14:53 2018 +0200 summary: Fixes issue 39168: A payment can be reversed more than once with slow connection Was possible to reverse a payment more than once with slow network connection. It was caused because could be a time between the payment is reversed and the button is hidden where it is possible to execute the process again. As the process of reversing the payment happens in the server-side and the UI delay happens in the Front-End the Reverse Payment button is hidden before setting up the parameters so when the process is executed the second time the payment is already reversed and linked to the reversed payment. To avoid this bug, it is validated that the processing payment is not already reversed. In case it is, then an error message is thrown explaining it is reversed. details: https://code.openbravo.com/erp/devel/main/rev/692305cb1996 changeset: 34761:692305cb1996 user: Asier Lostalé openbravo.com> date: Fri Sep 07 09:51:56 2018 +0200 summary: fixed issue 39229: source path is required to import reference data Reference data is now deployed to WebContent which can be accessed from Tomcat as a resource. details: https://code.openbravo.com/erp/devel/main/rev/038384250ba9 changeset: 34762:038384250ba9 user: Asier Lostalé openbravo.com> date: Fri Sep 07 11:37:29 2018 +0200 summary: fixed issue 39229: source path is required to import Chart Of Accounts Now it is deployed as resource accessible from Tomcat. details: https://code.openbravo.com/erp/devel/main/rev/701d003b887b changeset: 34763:701d003b887b user: Asier Lostalé openbravo.com> date: Fri Sep 07 11:46:19 2018 +0200 summary: fixed issue 39229: do not make publicly available reference data files Reference data and COA files should be internally accessible from Tomcat, but they shouldn't be publicly available to be downloaded. Moved them to the non public WEB-INF directory. details: https://code.openbravo.com/erp/devel/main/rev/9a51de54cd96 changeset: 34764:9a51de54cd96 user: Asier Lostalé openbravo.com> date: Fri Sep 07 11:51:03 2018 +0200 summary: related to issue 39229: removed unneded source.path params details: https://code.openbravo.com/erp/devel/main/rev/3e0f540c5540 changeset: 34765:3e0f540c5540 user: Asier
[OpenbravoERP-commits] devel/pi: 2 new changesets
details: https://code.openbravo.com/erp/devel/pi/rev/6bac4a0d2846 changeset: 34770:6bac4a0d2846 user: Sandra Huguet openbravo.com> date: Tue Sep 04 15:23:34 2018 +0200 summary: Fixes issue 39171 improve reset accounting process performance Improve performance of getTables and getDocbasetypes queries details: https://code.openbravo.com/erp/devel/pi/rev/7671c9b22d7e changeset: 34771:7671c9b22d7e user: Sandra Huguet openbravo.com> date: Tue Sep 11 15:58:39 2018 -0400 summary: Related to 39171: Use ad_periodcontrolallowed_org_id column instead of calling ad_org_getperiodcontrolallow() function to improve performance. The ad_org_getperiodcontrolallow column of each organization stores it period control allowed organization. Using it is more efficient than invoke the ad_org_getperiodcontrolallow() function as this one is recursive and implies extra queries that are unnecesaries as the information is in the requested organizations. diffstat: src-db/database/model/tables/FACT_ACCT.xml | 3 +++ src/org/openbravo/financial/ResetAccounting.java | 12 +--- 2 files changed, 12 insertions(+), 3 deletions(-) diffs (52 lines): diff -r bfd9f58405fa -r 7671c9b22d7e src-db/database/model/tables/FACT_ACCT.xml --- a/src-db/database/model/tables/FACT_ACCT.xmlWed Sep 12 15:02:46 2018 +0200 +++ b/src-db/database/model/tables/FACT_ACCT.xmlTue Sep 11 15:58:39 2018 -0400 @@ -305,6 +305,9 @@ + + + diff -r bfd9f58405fa -r 7671c9b22d7e src/org/openbravo/financial/ResetAccounting.java --- a/src/org/openbravo/financial/ResetAccounting.java Wed Sep 12 15:02:46 2018 +0200 +++ b/src/org/openbravo/financial/ResetAccounting.java Tue Sep 11 15:58:39 2018 -0400 @@ -110,7 +110,7 @@ // period control associated Map organizationPeriodControl = new HashMap<>(); -String myQuery1 = "select ad_org_id, ad_org_getperiodcontrolallow(ad_org_id) from ad_org where ad_org_id in (:orgIds)"; +String myQuery1 = "select ad_org_id, ad_periodcontrolallowed_org_id from ad_org where ad_org_id in (:orgIds)"; @SuppressWarnings("rawtypes") Query query1 = OBDal.getInstance().getSession().createNativeQuery(myQuery1); @@ -418,7 +418,9 @@ accountingTables.add(myTable.getId()); return accountingTables; } - String myQuery = "select distinct e.table.id from FinancialMgmtAccountingFact e where e.table.id <> '145'"; + + String myQuery = "select distinct t.id from ADTable t where t.id <> '145' " + + " and exists (select 1 from FinancialMgmtAccountingFact e where e.table.id=t.id) "; accountingTables = OBDal.getInstance().getSession().createQuery(myQuery).list(); return accountingTables; } finally { @@ -440,10 +442,14 @@ } private static List getDocbasetypes(String clientId, String tableId, String recordId) { -String myQuery = "select distinct e.documentCategory from FinancialMgmtAccountingFact e where e.client.id = :clientId and e.table.id = :tableId "; + +String myQuery = "select distinct d.documentCategory from DocumentType d where d.client.id = :clientId and d.table.id = :tableId" ++ " and exists (select 1 from FinancialMgmtAccountingFact e where e.documentCategory=d.documentCategory "; + if (!"".equals(recordId)) { myQuery = myQuery + "and e.recordID=:recordId"; } +myQuery = myQuery + ")"; Query query = OBDal.getInstance().getSession().createQuery(myQuery, String.class); query.setParameter("clientId", clientId); query.setParameter("tableId", tableId); ___ Openbravo-commits mailing list Openbravo-commits@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/openbravo-commits
[OpenbravoERP-commits] devel/pi: fixed issue 39276: ProcessSchedulingTest fails dependi...
details: https://code.openbravo.com/erp/devel/pi/rev/bfd9f58405fa changeset: 34769:bfd9f58405fa user: Asier Lostalé openbravo.com> date: Wed Sep 12 15:02:46 2018 +0200 summary: fixed issue 39276: ProcessSchedulingTest fails depending on system locale In case VariablesSecureApp is initialized without setting a language, default it to en_US rather than relying on system settings. diffstat: src/org/openbravo/base/secureApp/VariablesSecureApp.java | 5 ++--- 1 files changed, 2 insertions(+), 3 deletions(-) diffs (21 lines): diff -r 0cf455f5e717 -r bfd9f58405fa src/org/openbravo/base/secureApp/VariablesSecureApp.java --- a/src/org/openbravo/base/secureApp/VariablesSecureApp.java Wed Sep 12 13:58:11 2018 +0200 +++ b/src/org/openbravo/base/secureApp/VariablesSecureApp.java Wed Sep 12 15:02:46 2018 +0200 @@ -1,6 +1,6 @@ /* - * Copyright (C) 2001-2017 Openbravo S.L.U. + * Copyright (C) 2001-2018 Openbravo S.L.U. * Licensed under the Apache Software License version 2.0 * You may obtain a copy of the License at http://www.apache.org/licenses/LICENSE-2.0 * Unless required by applicable law or agreed to in writing, software distributed @@ -121,8 +121,7 @@ this.user = strUser; this.role = strRole; if (StringUtils.isEmpty(strLanguage)) { - this.language = System.getProperty("user.language") + "_" - + System.getProperty("user.country"); + this.language = "en_US"; } else { this.language = strLanguage; } ___ Openbravo-commits mailing list Openbravo-commits@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/openbravo-commits
[OpenbravoERP-commits] devel/pi: 2 new changesets
details: https://code.openbravo.com/erp/devel/pi/rev/361d99d453c4 changeset: 34767:361d99d453c4 user: Asier Lostalé openbravo.com> date: Wed Sep 12 13:56:58 2018 +0200 summary: fixed issue 39271: PG 11 - error when updating database PostgreSQL 11 replaces pg_proc.proisagg boolean column with prokind which is a flag for different types of procedures. Created new ModelLoader for PG 11 making use of this new column. details: https://code.openbravo.com/erp/devel/pi/rev/0cf455f5e717 changeset: 34768:0cf455f5e717 user: Asier Lostalé openbravo.com> date: Wed Sep 12 13:58:11 2018 +0200 summary: fixed issue 39273: PG 11 - NPE updating DB Excluded new functions included in pg_trgm extension diffstat: src-db/database/lib/dbsourcemanager.jar | Bin src-db/database/model/excludeFilter.xml |7 ++- 2 files changed, 2 insertions(+), 5 deletions(-) diffs (19 lines): diff -r e5566da8d2a0 -r 0cf455f5e717 src-db/database/lib/dbsourcemanager.jar Binary file src-db/database/lib/dbsourcemanager.jar has changed diff -r e5566da8d2a0 -r 0cf455f5e717 src-db/database/model/excludeFilter.xml --- a/src-db/database/model/excludeFilter.xml Tue Sep 11 17:50:57 2018 +0200 +++ b/src-db/database/model/excludeFilter.xml Wed Sep 12 13:58:11 2018 +0200 @@ -89,11 +89,8 @@ - - - - - + + ___ Openbravo-commits mailing list Openbravo-commits@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/openbravo-commits