0040459: Dsicount master refresh is slow with a lot of discounts configured

# HG changeset patch
# User Ranjith S R <ranjith@qualiantech.com>
# Date 1554285733 -19800
#      Wed Apr 03 15:32:13 2019 +0530
# Node ID 4e64a87e881cefe6446d99902f5dbe04e65e7a53
# Parent  15312ae0ca68cafe8ab39e643a8fe4c8b528161d
Related to issue 40459 : Added index for m_offer and m_offer_product

diff -r 15312ae0ca68 -r 4e64a87e881c src-db/database/model/modifiedTables/M_OFFER.xml
--- a/src-db/database/model/modifiedTables/M_OFFER.xml	Wed Apr 03 15:26:41 2019 +0530
+++ b/src-db/database/model/modifiedTables/M_OFFER.xml	Wed Apr 03 15:32:13 2019 +0530
@@ -10,5 +10,9 @@
       <index name="EM_OBPOS_M_OFFER_ORG" unique="false">
         <index-column name="AD_ORG_ID"/>
       </index>
+      <index name="EM_OBPOS_M_OFFER_ORGACTIVE" unique="false">
+        <index-column name="AD_ORG_ID"/>
+        <index-column name="ISACTIVE"/>
+      </index>
     </table>
   </database>
diff -r 15312ae0ca68 -r 4e64a87e881c src-db/database/model/modifiedTables/M_OFFER_PRODUCT.xml
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/src-db/database/model/modifiedTables/M_OFFER_PRODUCT.xml	Wed Apr 03 15:32:13 2019 +0530
@@ -0,0 +1,8 @@
+<?xml version="1.0"?>
+  <database name="MODIFIED TABLE M_OFFER_PRODUCT">
+    <table name="M_OFFER_PRODUCT" primaryKey="M_OFFER_PRODUCT_KEY">
+      <index name="EM_OBPOS_M_OFFERPROD_PRODUCT" unique="false">
+        <index-column name="M_PRODUCT_ID"/>
+      </index>
+    </table>
+  </database>
diff -r 15312ae0ca68 -r 4e64a87e881c src/org/openbravo/retail/posterminal/master/DiscountFilterProduct.java
--- a/src/org/openbravo/retail/posterminal/master/DiscountFilterProduct.java	Wed Apr 03 15:26:41 2019 +0530
+++ b/src/org/openbravo/retail/posterminal/master/DiscountFilterProduct.java	Wed Apr 03 15:32:13 2019 +0530
@@ -1,6 +1,6 @@
 /*
  ************************************************************************************
- * Copyright (C) 2012-2018 Openbravo S.L.U.
+ * Copyright (C) 2012-2019 Openbravo S.L.U.
  * Licensed under the Openbravo Commercial License version 1.0
  * You may obtain a copy of the License at http://www.openbravo.com/legal/obcl.html
  * or in the legal folder of this module distribution.
@@ -39,7 +39,7 @@
         .getPropertyExtensions(extensions);
     String hql = "select" + regularDiscFilProductPropertyExtensionHQLProperties.getHqlSelect();
     hql += " from PricingAdjustmentProduct ap, OBRETCO_Prol_Product ppl ";
-    hql += " where ap.product.id = ppl.product.id and ppl.active = true ";
+    hql += " where ap.product.id = ppl.product.id ";
     hql += " and ppl.obretcoProductlist.id ='" + productList.getId() + "' ";
     hql += " and ((ap.$incrementalUpdateCriteria) " + jsonsent.get("operator")
         + " (ap.priceAdjustment.$incrementalUpdateCriteria) " + jsonsent.get("operator")