# HG changeset patch
# User Silambarasan Sekar <silambarasan@qualiantech.com>
# Date 1473849976 -19800
#      Wed Sep 14 16:16:16 2016 +0530
# Node ID a76ef78853209eb0a40579dee2bcf5c364199f2b
# Parent  0152d1ed091fc1d3bf88a3bbfeab634d808615a8
Test case modification with respect to I33963, Insert Statements Fixed

diff -r 0152d1ed091f -r a76ef7885320 src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/discountsandpromotions/I30542_BuyXPayYDiffProd_Average.java
--- a/src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/discountsandpromotions/I30542_BuyXPayYDiffProd_Average.java	Tue Sep 13 16:09:52 2016 +0530
+++ b/src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/discountsandpromotions/I30542_BuyXPayYDiffProd_Average.java	Wed Sep 14 16:16:16 2016 +0530
@@ -491,8 +491,14 @@
   private void changePromotion() {
     final String sql = "UPDATE m_offer SET name = '6 x 4 Descenders', em_obdisc_y = 4, em_obdisc_subtype = 'AVG', em_obdisc_distribute = 'N' where m_offer_id = 'A5190E45A59E4E4DBA19E06A8ED543D5' AND m_offer_type_id = '312D41071ED34BA18B748607CA679F44'";
     new DatabaseHelperInsertUpdateOrDelete().execute(sql, 1);
-    final String sql2 = "insert into m_offer_product VALUES ('BD57E04D50B047A8AD3C8B2338F9124C','39363B0921BB4293B48383844325E84C','67839EEFA49E44AC969BD60093FCC899','Y', "
-        + "now(),'100',now(),'100','A5190E45A59E4E4DBA19E06A8ED543D5','1F72D8EB04C24FC588F1BF0B4E4B2203','N',null,null)";
+    final String sql2 = "insert into m_offer_product(m_offer_product_id, ad_client_id, ad_org_id, isactive, "
+        + "created, createdby, updated, updatedby, "
+        + "m_offer_id, m_product_id, em_obdisc_is_gift, em_obdisc_qty, "
+        + "em_obdisc_gifqty) "
+        + "VALUES ('BD57E04D50B047A8AD3C8B2338F9124C','39363B0921BB4293B48383844325E84C','67839EEFA49E44AC969BD60093FCC899','Y', "
+        + "now(),'100',now(),'100',"
+        + " 'A5190E45A59E4E4DBA19E06A8ED543D5','1F72D8EB04C24FC588F1BF0B4E4B2203','N',null,"
+        + "null)";
     new DatabaseHelperInsertUpdateOrDelete().execute(sql2, 1);
   }
 }
\ No newline at end of file
diff -r 0152d1ed091f -r a76ef7885320 src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/discountsandpromotions/I30542_BuyXPayYDiffProd_Lowest.java
--- a/src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/discountsandpromotions/I30542_BuyXPayYDiffProd_Lowest.java	Tue Sep 13 16:09:52 2016 +0530
+++ b/src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/discountsandpromotions/I30542_BuyXPayYDiffProd_Lowest.java	Wed Sep 14 16:16:16 2016 +0530
@@ -474,8 +474,14 @@
   private void changePromotion() {
     final String sql = "UPDATE m_offer SET name = '6 x 4 Descenders', em_obdisc_y = 4, em_obdisc_subtype = 'CHEAPEST', em_obdisc_distribute = 'N' where m_offer_id = 'A5190E45A59E4E4DBA19E06A8ED543D5' AND m_offer_type_id = '312D41071ED34BA18B748607CA679F44'";
     new DatabaseHelperInsertUpdateOrDelete().execute(sql, 1);
-    final String sql2 = "insert into m_offer_product VALUES ('BD57E04D50B047A8AD3C8B2338F9124C','39363B0921BB4293B48383844325E84C','67839EEFA49E44AC969BD60093FCC899','Y', "
-        + "now(),'100',now(),'100','A5190E45A59E4E4DBA19E06A8ED543D5','1F72D8EB04C24FC588F1BF0B4E4B2203','N',null,null)";
+    final String sql2 = "insert into m_offer_product(m_offer_product_id, ad_client_id, ad_org_id, isactive, "
+        + "created, createdby, updated, updatedby, "
+        + "m_offer_id, m_product_id, em_obdisc_is_gift, em_obdisc_qty, "
+        + "em_obdisc_gifqty) "
+        + "VALUES ('BD57E04D50B047A8AD3C8B2338F9124C','39363B0921BB4293B48383844325E84C','67839EEFA49E44AC969BD60093FCC899','Y', "
+        + "now(),'100',now(),'100', "
+        + "'A5190E45A59E4E4DBA19E06A8ED543D5','1F72D8EB04C24FC588F1BF0B4E4B2203','N',null, "
+        + "null)";
     new DatabaseHelperInsertUpdateOrDelete().execute(sql2, 1);
   }
 }
\ No newline at end of file
diff -r 0152d1ed091f -r a76ef7885320 src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/discountsandpromotions/I30542_BuyXPayYDiffProd_LowestDistrib.java
--- a/src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/discountsandpromotions/I30542_BuyXPayYDiffProd_LowestDistrib.java	Tue Sep 13 16:09:52 2016 +0530
+++ b/src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/discountsandpromotions/I30542_BuyXPayYDiffProd_LowestDistrib.java	Wed Sep 14 16:16:16 2016 +0530
@@ -475,8 +475,14 @@
   private void changePromotion() {
     final String sql = "UPDATE m_offer SET name = '6 x 4 Descenders', em_obdisc_y = 4, em_obdisc_subtype = 'CHEAPEST', em_obdisc_distribute = 'Y' where m_offer_id = 'A5190E45A59E4E4DBA19E06A8ED543D5' AND m_offer_type_id = '312D41071ED34BA18B748607CA679F44'";
     new DatabaseHelperInsertUpdateOrDelete().execute(sql, 1);
-    final String sql2 = "insert into m_offer_product VALUES ('BD57E04D50B047A8AD3C8B2338F9124C','39363B0921BB4293B48383844325E84C','67839EEFA49E44AC969BD60093FCC899','Y', "
-        + "now(),'100',now(),'100','A5190E45A59E4E4DBA19E06A8ED543D5','1F72D8EB04C24FC588F1BF0B4E4B2203','N',null,null)";
+    final String sql2 = "insert into m_offer_product(m_offer_product_id, ad_client_id, ad_org_id, isactive, "
+        + "created, createdby, updated, updatedby, "
+        + "m_offer_id, m_product_id, em_obdisc_is_gift, em_obdisc_qty, "
+        + "em_obdisc_gifqty) "
+        + "VALUES ('BD57E04D50B047A8AD3C8B2338F9124C','39363B0921BB4293B48383844325E84C','67839EEFA49E44AC969BD60093FCC899','Y', "
+        + "now(),'100',now(),'100',"
+        + "'A5190E45A59E4E4DBA19E06A8ED543D5','1F72D8EB04C24FC588F1BF0B4E4B2203','N',null,"
+        + "null)";
     new DatabaseHelperInsertUpdateOrDelete().execute(sql2, 1);
   }
 }
\ No newline at end of file
diff -r 0152d1ed091f -r a76ef7885320 src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/discountsandpromotions/I30542_BuyXPayYDiffProd_MostExpensive.java
--- a/src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/discountsandpromotions/I30542_BuyXPayYDiffProd_MostExpensive.java	Tue Sep 13 16:09:52 2016 +0530
+++ b/src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/discountsandpromotions/I30542_BuyXPayYDiffProd_MostExpensive.java	Wed Sep 14 16:16:16 2016 +0530
@@ -490,8 +490,14 @@
   private void changePromotion() {
     final String sql = "UPDATE m_offer SET name = '6 x 4 Descenders', em_obdisc_y = 4, em_obdisc_subtype = null, em_obdisc_distribute = 'N' where m_offer_id = 'A5190E45A59E4E4DBA19E06A8ED543D5' AND m_offer_type_id = '312D41071ED34BA18B748607CA679F44'";
     new DatabaseHelperInsertUpdateOrDelete().execute(sql, 1);
-    final String sql2 = "insert into m_offer_product VALUES ('BD57E04D50B047A8AD3C8B2338F9124C','39363B0921BB4293B48383844325E84C','67839EEFA49E44AC969BD60093FCC899','Y', "
-        + "now(),'100',now(),'100','A5190E45A59E4E4DBA19E06A8ED543D5','1F72D8EB04C24FC588F1BF0B4E4B2203','N',null,null)";
+    final String sql2 = "insert into m_offer_product(m_offer_product_id, ad_client_id, ad_org_id, isactive, "
+        + "created, createdby, updated, updatedby, "
+        + "m_offer_id, m_product_id, em_obdisc_is_gift, em_obdisc_qty, "
+        + "em_obdisc_gifqty) "
+        + "VALUES ('BD57E04D50B047A8AD3C8B2338F9124C','39363B0921BB4293B48383844325E84C','67839EEFA49E44AC969BD60093FCC899','Y', "
+        + "now(),'100',now(),'100', "
+        + "'A5190E45A59E4E4DBA19E06A8ED543D5','1F72D8EB04C24FC588F1BF0B4E4B2203','N',null, "
+        + "null)";
     new DatabaseHelperInsertUpdateOrDelete().execute(sql2, 1);
   }
 }
\ No newline at end of file