[OpenbravoERP-commits] devel/pi: 2 new changesets

hg Wed, 23 May 2018 03:53:20 -0700

details:   https://code.openbravo.com/erp/devel/pi/rev/7e3181b595b0
changeset: 34008:7e3181b595b0
user:      Atul Gaware <atul.gaware <at> openbravo.com>
date:      Wed May 16 00:04:54 2018 +0530
summary:   Fixes Issue 38510:Slow updating to 18Q2 on an environment
with high loads of data


In general no of shipment completely invoice are more as compare to
that are not completely invoiced. Hence mddulescript logic is changed
to update iscompletelyinvoiced as No for the applicable shipments.
For rest of the existing shipments flag is set as Yes using
onCreateDefault for iscompletelyinvoiced column of M_Inout table.

details:   https://code.openbravo.com/erp/devel/pi/rev/07860e9e9adc
changeset: 34009:07860e9e9adc
user:      Atul Gaware <atul.gaware <at> openbravo.com>
date:      Wed May 16 14:31:08 2018 +0530
summary:   Related to Issue 38510:Sample data updated in QA testing for
IsCompletelyInvoiced flag in M_Inout

diffstat:

 referencedata/sampledata/QA_Testing/M_INOUT.xml                                
                     |   32 ++++++++++
 src-db/database/model/tables/M_INOUT.xml                                       
                     |    2 +-
 
src-util/modulescript/build/classes/org/openbravo/modulescript/UpdateIsCompletelyInvoicedData.class
 |  Bin 
 
src-util/modulescript/src/org/openbravo/modulescript/UpdateIsCompletelyInvoiced_data.xsql
           |    4 +-
 4 files changed, 35 insertions(+), 3 deletions(-)

diffs (288 lines):

diff -r 0615284678a2 -r 07860e9e9adc 
referencedata/sampledata/QA_Testing/M_INOUT.xml
--- a/referencedata/sampledata/QA_Testing/M_INOUT.xml   Wed May 23 08:58:43 
2018 +0200
+++ b/referencedata/sampledata/QA_Testing/M_INOUT.xml   Wed May 16 14:31:08 
2018 +0530
@@ -41,6 +41,7 @@
   <RM_SHIPMENT_PICKEDIT><![CDATA[N]]></RM_SHIPMENT_PICKEDIT>
   <PROCESS_GOODS_JAVA><![CDATA[CO]]></PROCESS_GOODS_JAVA>
   <ISNETTINGSHIPMENT><![CDATA[N]]></ISNETTINGSHIPMENT>
+  <ISCOMPLETELYINVOICED><![CDATA[N]]></ISCOMPLETELYINVOICED>
 </M_INOUT>
 
 <M_INOUT>
@@ -84,6 +85,7 @@
   <RM_SHIPMENT_PICKEDIT><![CDATA[N]]></RM_SHIPMENT_PICKEDIT>
   <PROCESS_GOODS_JAVA><![CDATA[CO]]></PROCESS_GOODS_JAVA>
   <ISNETTINGSHIPMENT><![CDATA[N]]></ISNETTINGSHIPMENT>
+  <ISCOMPLETELYINVOICED><![CDATA[Y]]></ISCOMPLETELYINVOICED>
 </M_INOUT>
 
 <M_INOUT>
@@ -125,6 +127,7 @@
   <GENERATELINES><![CDATA[N]]></GENERATELINES>
   <PROCESS_GOODS_JAVA><![CDATA[--]]></PROCESS_GOODS_JAVA>
   <ISNETTINGSHIPMENT><![CDATA[N]]></ISNETTINGSHIPMENT>
+  <ISCOMPLETELYINVOICED><![CDATA[N]]></ISCOMPLETELYINVOICED>
 </M_INOUT>
 
 <M_INOUT>
@@ -166,6 +169,7 @@
   <GENERATELINES><![CDATA[N]]></GENERATELINES>
   <PROCESS_GOODS_JAVA><![CDATA[--]]></PROCESS_GOODS_JAVA>
   <ISNETTINGSHIPMENT><![CDATA[N]]></ISNETTINGSHIPMENT>
+  <ISCOMPLETELYINVOICED><![CDATA[N]]></ISCOMPLETELYINVOICED>
 </M_INOUT>
 
 <M_INOUT>
@@ -210,6 +214,7 @@
   <RM_SHIPMENT_PICKEDIT><![CDATA[N]]></RM_SHIPMENT_PICKEDIT>
   <PROCESS_GOODS_JAVA><![CDATA[--]]></PROCESS_GOODS_JAVA>
   <ISNETTINGSHIPMENT><![CDATA[N]]></ISNETTINGSHIPMENT>
+  <ISCOMPLETELYINVOICED><![CDATA[N]]></ISCOMPLETELYINVOICED>
 </M_INOUT>
 
 <M_INOUT>
@@ -251,6 +256,7 @@
   <GENERATELINES><![CDATA[N]]></GENERATELINES>
   <PROCESS_GOODS_JAVA><![CDATA[--]]></PROCESS_GOODS_JAVA>
   <ISNETTINGSHIPMENT><![CDATA[N]]></ISNETTINGSHIPMENT>
+  <ISCOMPLETELYINVOICED><![CDATA[N]]></ISCOMPLETELYINVOICED>
 </M_INOUT>
 
 <M_INOUT>
@@ -296,6 +302,7 @@
   <RM_SHIPMENT_PICKEDIT><![CDATA[N]]></RM_SHIPMENT_PICKEDIT>
   <PROCESS_GOODS_JAVA><![CDATA[--]]></PROCESS_GOODS_JAVA>
   <ISNETTINGSHIPMENT><![CDATA[N]]></ISNETTINGSHIPMENT>
+  <ISCOMPLETELYINVOICED><![CDATA[Y]]></ISCOMPLETELYINVOICED>
 </M_INOUT>
 
 <M_INOUT>
@@ -338,6 +345,7 @@
   <RM_SHIPMENT_PICKEDIT><![CDATA[N]]></RM_SHIPMENT_PICKEDIT>
   <PROCESS_GOODS_JAVA><![CDATA[--]]></PROCESS_GOODS_JAVA>
   <ISNETTINGSHIPMENT><![CDATA[N]]></ISNETTINGSHIPMENT>
+  <ISCOMPLETELYINVOICED><![CDATA[Y]]></ISCOMPLETELYINVOICED>
 </M_INOUT>
 
 <M_INOUT>
@@ -381,6 +389,7 @@
   <RM_SHIPMENT_PICKEDIT><![CDATA[N]]></RM_SHIPMENT_PICKEDIT>
   <PROCESS_GOODS_JAVA><![CDATA[CO]]></PROCESS_GOODS_JAVA>
   <ISNETTINGSHIPMENT><![CDATA[N]]></ISNETTINGSHIPMENT>
+  <ISCOMPLETELYINVOICED><![CDATA[N]]></ISCOMPLETELYINVOICED>
 </M_INOUT>
 
 <M_INOUT>
@@ -423,6 +432,7 @@
   <RM_SHIPMENT_PICKEDIT><![CDATA[N]]></RM_SHIPMENT_PICKEDIT>
   <PROCESS_GOODS_JAVA><![CDATA[--]]></PROCESS_GOODS_JAVA>
   <ISNETTINGSHIPMENT><![CDATA[N]]></ISNETTINGSHIPMENT>
+  <ISCOMPLETELYINVOICED><![CDATA[Y]]></ISCOMPLETELYINVOICED>
 </M_INOUT>
 
 <M_INOUT>
@@ -468,6 +478,7 @@
   <RM_SHIPMENT_PICKEDIT><![CDATA[N]]></RM_SHIPMENT_PICKEDIT>
   <PROCESS_GOODS_JAVA><![CDATA[--]]></PROCESS_GOODS_JAVA>
   <ISNETTINGSHIPMENT><![CDATA[N]]></ISNETTINGSHIPMENT>
+  <ISCOMPLETELYINVOICED><![CDATA[Y]]></ISCOMPLETELYINVOICED>
 </M_INOUT>
 
 <M_INOUT>
@@ -508,6 +519,7 @@
   <GENERATELINES><![CDATA[N]]></GENERATELINES>
   <PROCESS_GOODS_JAVA><![CDATA[--]]></PROCESS_GOODS_JAVA>
   <ISNETTINGSHIPMENT><![CDATA[N]]></ISNETTINGSHIPMENT>
+  <ISCOMPLETELYINVOICED><![CDATA[Y]]></ISCOMPLETELYINVOICED>
 </M_INOUT>
 
 <M_INOUT>
@@ -548,6 +560,7 @@
   <GENERATELINES><![CDATA[N]]></GENERATELINES>
   <PROCESS_GOODS_JAVA><![CDATA[--]]></PROCESS_GOODS_JAVA>
   <ISNETTINGSHIPMENT><![CDATA[N]]></ISNETTINGSHIPMENT>
+  <ISCOMPLETELYINVOICED><![CDATA[N]]></ISCOMPLETELYINVOICED>
 </M_INOUT>
 
 <M_INOUT>
@@ -589,6 +602,7 @@
   <GENERATELINES><![CDATA[N]]></GENERATELINES>
   <PROCESS_GOODS_JAVA><![CDATA[--]]></PROCESS_GOODS_JAVA>
   <ISNETTINGSHIPMENT><![CDATA[N]]></ISNETTINGSHIPMENT>
+  <ISCOMPLETELYINVOICED><![CDATA[N]]></ISCOMPLETELYINVOICED>
 </M_INOUT>
 
 <M_INOUT>
@@ -634,6 +648,7 @@
   <RM_SHIPMENT_PICKEDIT><![CDATA[N]]></RM_SHIPMENT_PICKEDIT>
   <PROCESS_GOODS_JAVA><![CDATA[--]]></PROCESS_GOODS_JAVA>
   <ISNETTINGSHIPMENT><![CDATA[N]]></ISNETTINGSHIPMENT>
+  <ISCOMPLETELYINVOICED><![CDATA[N]]></ISCOMPLETELYINVOICED>
 </M_INOUT>
 
 <M_INOUT>
@@ -677,6 +692,7 @@
   <RM_SHIPMENT_PICKEDIT><![CDATA[N]]></RM_SHIPMENT_PICKEDIT>
   <PROCESS_GOODS_JAVA><![CDATA[--]]></PROCESS_GOODS_JAVA>
   <ISNETTINGSHIPMENT><![CDATA[N]]></ISNETTINGSHIPMENT>
+  <ISCOMPLETELYINVOICED><![CDATA[N]]></ISCOMPLETELYINVOICED>
 </M_INOUT>
 
 <M_INOUT>
@@ -718,6 +734,7 @@
   <GENERATELINES><![CDATA[N]]></GENERATELINES>
   <PROCESS_GOODS_JAVA><![CDATA[--]]></PROCESS_GOODS_JAVA>
   <ISNETTINGSHIPMENT><![CDATA[N]]></ISNETTINGSHIPMENT>
+  <ISCOMPLETELYINVOICED><![CDATA[N]]></ISCOMPLETELYINVOICED>
 </M_INOUT>
 
 <M_INOUT>
@@ -763,6 +780,7 @@
   <RM_SHIPMENT_PICKEDIT><![CDATA[N]]></RM_SHIPMENT_PICKEDIT>
   <PROCESS_GOODS_JAVA><![CDATA[--]]></PROCESS_GOODS_JAVA>
   <ISNETTINGSHIPMENT><![CDATA[N]]></ISNETTINGSHIPMENT>
+  <ISCOMPLETELYINVOICED><![CDATA[N]]></ISCOMPLETELYINVOICED>
 </M_INOUT>
 
 <M_INOUT>
@@ -805,6 +823,7 @@
   <RM_SHIPMENT_PICKEDIT><![CDATA[N]]></RM_SHIPMENT_PICKEDIT>
   <PROCESS_GOODS_JAVA><![CDATA[--]]></PROCESS_GOODS_JAVA>
   <ISNETTINGSHIPMENT><![CDATA[N]]></ISNETTINGSHIPMENT>
+  <ISCOMPLETELYINVOICED><![CDATA[Y]]></ISCOMPLETELYINVOICED>
 </M_INOUT>
 
 <M_INOUT>
@@ -847,6 +866,7 @@
   <GENERATELINES><![CDATA[N]]></GENERATELINES>
   <PROCESS_GOODS_JAVA><![CDATA[--]]></PROCESS_GOODS_JAVA>
   <ISNETTINGSHIPMENT><![CDATA[N]]></ISNETTINGSHIPMENT>
+  <ISCOMPLETELYINVOICED><![CDATA[N]]></ISCOMPLETELYINVOICED>
 </M_INOUT>
 
 <M_INOUT>
@@ -887,6 +907,7 @@
   <GENERATELINES><![CDATA[N]]></GENERATELINES>
   <PROCESS_GOODS_JAVA><![CDATA[--]]></PROCESS_GOODS_JAVA>
   <ISNETTINGSHIPMENT><![CDATA[N]]></ISNETTINGSHIPMENT>
+  <ISCOMPLETELYINVOICED><![CDATA[N]]></ISCOMPLETELYINVOICED>
 </M_INOUT>
 
 <M_INOUT>
@@ -928,6 +949,7 @@
   <GENERATELINES><![CDATA[N]]></GENERATELINES>
   <PROCESS_GOODS_JAVA><![CDATA[--]]></PROCESS_GOODS_JAVA>
   <ISNETTINGSHIPMENT><![CDATA[N]]></ISNETTINGSHIPMENT>
+  <ISCOMPLETELYINVOICED><![CDATA[N]]></ISCOMPLETELYINVOICED>
 </M_INOUT>
 
 <M_INOUT>
@@ -973,6 +995,7 @@
   <RM_SHIPMENT_PICKEDIT><![CDATA[N]]></RM_SHIPMENT_PICKEDIT>
   <PROCESS_GOODS_JAVA><![CDATA[--]]></PROCESS_GOODS_JAVA>
   <ISNETTINGSHIPMENT><![CDATA[N]]></ISNETTINGSHIPMENT>
+  <ISCOMPLETELYINVOICED><![CDATA[N]]></ISCOMPLETELYINVOICED>
 </M_INOUT>
 
 <M_INOUT>
@@ -1014,6 +1037,7 @@
   <GENERATELINES><![CDATA[N]]></GENERATELINES>
   <PROCESS_GOODS_JAVA><![CDATA[--]]></PROCESS_GOODS_JAVA>
   <ISNETTINGSHIPMENT><![CDATA[N]]></ISNETTINGSHIPMENT>
+  <ISCOMPLETELYINVOICED><![CDATA[N]]></ISCOMPLETELYINVOICED>
 </M_INOUT>
 
 <M_INOUT>
@@ -1054,6 +1078,7 @@
   <GENERATELINES><![CDATA[N]]></GENERATELINES>
   <PROCESS_GOODS_JAVA><![CDATA[--]]></PROCESS_GOODS_JAVA>
   <ISNETTINGSHIPMENT><![CDATA[N]]></ISNETTINGSHIPMENT>
+  <ISCOMPLETELYINVOICED><![CDATA[Y]]></ISCOMPLETELYINVOICED>
 </M_INOUT>
 
 <M_INOUT>
@@ -1095,6 +1120,7 @@
   <GENERATELINES><![CDATA[N]]></GENERATELINES>
   <PROCESS_GOODS_JAVA><![CDATA[--]]></PROCESS_GOODS_JAVA>
   <ISNETTINGSHIPMENT><![CDATA[N]]></ISNETTINGSHIPMENT>
+  <ISCOMPLETELYINVOICED><![CDATA[N]]></ISCOMPLETELYINVOICED>
 </M_INOUT>
 
 <M_INOUT>
@@ -1136,6 +1162,7 @@
   <GENERATELINES><![CDATA[N]]></GENERATELINES>
   <PROCESS_GOODS_JAVA><![CDATA[--]]></PROCESS_GOODS_JAVA>
   <ISNETTINGSHIPMENT><![CDATA[N]]></ISNETTINGSHIPMENT>
+  <ISCOMPLETELYINVOICED><![CDATA[N]]></ISCOMPLETELYINVOICED>
 </M_INOUT>
 
 <M_INOUT>
@@ -1181,6 +1208,7 @@
   <RM_SHIPMENT_PICKEDIT><![CDATA[N]]></RM_SHIPMENT_PICKEDIT>
   <PROCESS_GOODS_JAVA><![CDATA[--]]></PROCESS_GOODS_JAVA>
   <ISNETTINGSHIPMENT><![CDATA[N]]></ISNETTINGSHIPMENT>
+  <ISCOMPLETELYINVOICED><![CDATA[Y]]></ISCOMPLETELYINVOICED>
 </M_INOUT>
 
 <M_INOUT>
@@ -1222,6 +1250,7 @@
   <GENERATELINES><![CDATA[N]]></GENERATELINES>
   <PROCESS_GOODS_JAVA><![CDATA[--]]></PROCESS_GOODS_JAVA>
   <ISNETTINGSHIPMENT><![CDATA[N]]></ISNETTINGSHIPMENT>
+  <ISCOMPLETELYINVOICED><![CDATA[N]]></ISCOMPLETELYINVOICED>
 </M_INOUT>
 
 <M_INOUT>
@@ -1267,6 +1296,7 @@
   <RM_SHIPMENT_PICKEDIT><![CDATA[N]]></RM_SHIPMENT_PICKEDIT>
   <PROCESS_GOODS_JAVA><![CDATA[--]]></PROCESS_GOODS_JAVA>
   <ISNETTINGSHIPMENT><![CDATA[N]]></ISNETTINGSHIPMENT>
+  <ISCOMPLETELYINVOICED><![CDATA[N]]></ISCOMPLETELYINVOICED>
 </M_INOUT>
 
 <M_INOUT>
@@ -1309,6 +1339,7 @@
   <RM_SHIPMENT_PICKEDIT><![CDATA[N]]></RM_SHIPMENT_PICKEDIT>
   <PROCESS_GOODS_JAVA><![CDATA[--]]></PROCESS_GOODS_JAVA>
   <ISNETTINGSHIPMENT><![CDATA[N]]></ISNETTINGSHIPMENT>
+  <ISCOMPLETELYINVOICED><![CDATA[Y]]></ISCOMPLETELYINVOICED>
 </M_INOUT>
 
 <M_INOUT>
@@ -1350,6 +1381,7 @@
   <GENERATELINES><![CDATA[N]]></GENERATELINES>
   <PROCESS_GOODS_JAVA><![CDATA[--]]></PROCESS_GOODS_JAVA>
   <ISNETTINGSHIPMENT><![CDATA[N]]></ISNETTINGSHIPMENT>
+  <ISCOMPLETELYINVOICED><![CDATA[N]]></ISCOMPLETELYINVOICED>
 </M_INOUT>
 
 </data>
diff -r 0615284678a2 -r 07860e9e9adc src-db/database/model/tables/M_INOUT.xml
--- a/src-db/database/model/tables/M_INOUT.xml  Wed May 23 08:58:43 2018 +0200
+++ b/src-db/database/model/tables/M_INOUT.xml  Wed May 16 14:31:08 2018 +0530
@@ -263,7 +263,7 @@
       </column>
       <column name="ISCOMPLETELYINVOICED" primaryKey="false" required="true" 
type="CHAR" size="1" autoIncrement="false">
         <default><![CDATA[N]]></default>
-        <onCreateDefault/>
+        <onCreateDefault><![CDATA['Y']]></onCreateDefault>
       </column>
       <foreign-key foreignTable="M_FREIGHTCATEGORY" 
name="M_FREIGHTCATEGORY_M_INOUT">
         <reference local="M_FREIGHTCATEGORY_ID" 
foreign="M_FREIGHTCATEGORY_ID"/>
diff -r 0615284678a2 -r 07860e9e9adc 
src-util/modulescript/build/classes/org/openbravo/modulescript/UpdateIsCompletelyInvoicedData.class
Binary file 
src-util/modulescript/build/classes/org/openbravo/modulescript/UpdateIsCompletelyInvoicedData.class
 has changed
diff -r 0615284678a2 -r 07860e9e9adc 
src-util/modulescript/src/org/openbravo/modulescript/UpdateIsCompletelyInvoiced_data.xsql
--- 
a/src-util/modulescript/src/org/openbravo/modulescript/UpdateIsCompletelyInvoiced_data.xsql
 Wed May 23 08:58:43 2018 +0200
+++ 
b/src-util/modulescript/src/org/openbravo/modulescript/UpdateIsCompletelyInvoiced_data.xsql
 Wed May 16 14:31:08 2018 +0530
@@ -31,9 +31,9 @@
     <Sql>
      <![CDATA[
         UPDATE M_InOut
-        SET iscompletelyinvoiced = 'Y'
+        SET iscompletelyinvoiced = 'N'
         WHERE issotrx = 'Y'
-        AND NOT EXISTS (SELECT 1 FROM M_INOUTLINE l
+        AND EXISTS (SELECT 1 FROM M_INOUTLINE l
                         LEFT JOIN c_invoiceline il ON l.m_inoutline_id = 
il.m_inoutline_id
                         LEFT JOIN c_invoice i ON il.c_invoice_id = 
i.c_invoice_id
                         WHERE l.M_INOUT_ID = M_InOut.M_INOUT_ID

------------------------------------------------------------------------------
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

[OpenbravoERP-commits] devel/pi: 2 new changesets

Reply via email to