Tue, 10 Oct 2017 13:49:09 +0530Related to Issue 36747:Avoid query more than once in AdvPaymentMngtDao.java
Atul Gaware <atul.gaware@openbravo.com> [Tue, 10 Oct 2017 13:49:09 +0530] rev 32983
Related to Issue 36747:Avoid query more than once in AdvPaymentMngtDao.java

** Use IsEmpty() for list instead if size() > 0
** Use count() to get the size of list instead of size()
** Instead of get(0) for any list, use setMaxResults(1) and uniqueResult()
for OBCriteria

Fri, 06 Oct 2017 11:41:37 +0530Fixes Issue 36747:Avoid query more than once in several classes
Atul Gaware <atul.gaware@openbravo.com> [Fri, 06 Oct 2017 11:41:37 +0530] rev 32982
Fixes Issue 36747:Avoid query more than once in several classes

** In ReportReconciliation.java, method getUnreconciledBankStatmentLinesTotal,
getOutstandingPaymentAndDepositTotal, getTransactionsTotalAfterReconciliationEndDate
executes query only once by avoiding calls to list method multiple times

** Use IsEmpty method instead of size() > 0 to check if the list is not empty

Fri, 10 Nov 2017 11:49:58 +0100related with bug 35838: performance issues in Alert window
Asier Lostalé <asier.lostale@openbravo.com> [Fri, 10 Nov 2017 11:49:58 +0100] rev 32981
related with bug 35838: performance issues in Alert window

Some minor code clean up:
- Format SQL to make it more readable
- Removed clutter + duplicity handling elements in map
- Use parameterized statements instead of string concatenation to generate query
- Prevent expensive debug message generation if it won't be logged

Fri, 10 Nov 2017 10:35:18 +0100Fixed issue 37214: Improved performance in SQL Query manual window
Inigo Sanchez <inigo.sanchez@openbravo.com> [Fri, 10 Nov 2017 10:35:18 +0100] rev 32980
Fixed issue 37214: Improved performance in SQL Query manual window

It was possible to produce a server crash executing on the sql query window a query returning
thousands of records. An OutOfMemoryError error is raised although only 20 records were showed
to the user because in fact, all the records were retrieving from the db instead of the 20 needed
records.

In order to fix the performance problem, now the queries are executed as a Native SQL with OFFSET
(org.hibernate.SQLQuery.setFirstResult) and LIMIT (org.hibernate.SQLQuery.setMaxResults). Now the
performance problem has been fixed.

Fri, 10 Nov 2017 10:34:03 +0100Related to issue 37214: initial code clean-up
Inigo Sanchez <inigo.sanchez@openbravo.com> [Fri, 10 Nov 2017 10:34:03 +0100] rev 32979
Related to issue 37214: initial code clean-up
- Removed commented code.
- The showsErrorMessage method is used to avoids duplicate code.
- The errors now are showed to the user.

Fri, 10 Nov 2017 08:29:38 +0100fixes issue 37267: improve readability of getLabels() method
Carlos Aristu <carlos.aristu@openbravo.com> [Fri, 10 Nov 2017 08:29:38 +0100] rev 32978
fixes issue 37267: improve readability of getLabels() method

Besides improving the readability, not the that the active flag when looking for the translations is now taken into account. Otherwise, translations of deactivated messages were being sent to the client.

Fri, 10 Nov 2017 08:26:33 +0100related to issue 37267: move static js code from ftl to a js file
Carlos Aristu <carlos.aristu@openbravo.com> [Fri, 10 Nov 2017 08:26:33 +0100] rev 32977
related to issue 37267: move static js code from ftl to a js file

Thu, 09 Nov 2017 13:52:00 +0100Related to Issue 36693.
David Miguelez <david.miguelez@openbravo.com> [Thu, 09 Nov 2017 13:52:00 +0100] rev 32976
Related to Issue 36693.

Added Licensing info for new XML file.

Thu, 09 Nov 2017 13:27:01 +0100related to issue 37269: Do not need to limit the query results
Carlos Aristu <carlos.aristu@openbravo.com> [Thu, 09 Nov 2017 13:27:01 +0100] rev 32975
related to issue 37269: Do not need to limit the query results

Is not necessary to limit the query results because the obuiapp_process_trl has a unique constraint based in the obuiapp_process_id and ad_language columns

Thu, 09 Nov 2017 13:05:49 +0100fixes issue 37269: Ability of translating the title of the report result tab
Carlos Aristu <carlos.aristu@openbravo.com> [Thu, 09 Nov 2017 13:05:49 +0100] rev 32974
fixes issue 37269: Ability of translating the title of the report result tab