svn commit: r1749104 - in /ofbiz/trunk/applications/order: groovyScripts/reports/OpenOrderItemsReport.groovy widget/ordermgr/ReportForms.xml

[diveshdutta]

Author: diveshdutta
Date: Sat Jun 18 23:02:14 2016
New Revision: 1749104

URL: http://svn.apache.org/viewvc?rev=1749104&view=rev
Log:
[OFBIZ-7386] Allowing user to select multiple options in Open Order Items report from basic search criterias while generating report. Thanks Mohammad Kathawala for your patch and thanks Swapnil Shah for suggesting the improvment.

Modified:
    ofbiz/trunk/applications/order/groovyScripts/reports/OpenOrderItemsReport.groovy
    ofbiz/trunk/applications/order/widget/ordermgr/ReportForms.xml

Modified: ofbiz/trunk/applications/order/groovyScripts/reports/OpenOrderItemsReport.groovy
URL: http://svn.apache.org/viewvc/ofbiz/trunk/applications/order/groovyScripts/reports/OpenOrderItemsReport.groovy?rev=1749104&r1=1749103&r2=1749104&view=diff
==============================================================================
--- ofbiz/trunk/applications/order/groovyScripts/reports/OpenOrderItemsReport.groovy (original)
+++ ofbiz/trunk/applications/order/groovyScripts/reports/OpenOrderItemsReport.groovy Sat Jun 18 23:02:14 2016
@@ -29,12 +29,13 @@ import org.ofbiz.entity.util.*;
 import org.ofbiz.entity.*;
 import org.ofbiz.base.util.*;
 
-productStoreId = parameters.productStoreId;
-orderTypeId = parameters.orderTypeId;
-orderStatusId = parameters.orderStatusId;
+productStoreId = ObjectType.simpleTypeConvert(parameters.productStoreId, "List", null, null);
+orderTypeId = ObjectType.simpleTypeConvert(parameters.orderTypeId, "List", null, null);
+orderStatusId = ObjectType.simpleTypeConvert(parameters.orderStatusId, "List", null, null);
+
 
 // search by orderTypeId is mandatory
-conditions = [EntityCondition.makeCondition("orderTypeId", EntityOperator.EQUALS, orderTypeId)];
+conditions = [EntityCondition.makeCondition("orderTypeId", EntityOperator.IN, orderTypeId)];
 
 if (fromOrderDate) {
     conditions.add(EntityCondition.makeCondition("orderDate", EntityOperator.GREATER_THAN_EQUAL_TO, fromOrderDate));
@@ -44,7 +45,7 @@ if (thruOrderDate) {
 }
 
 if (productStoreId) {
-    conditions.add(EntityCondition.makeCondition("productStoreId", EntityOperator.EQUALS, productStoreId));
+    conditions.add(EntityCondition.makeCondition("productStoreId", EntityOperator.IN, productStoreId));
     // for generating a title (given product store)
     context.productStore = from("ProductStore").where("productStoreId", productStoreId).cache(true).queryOne();
 } else {
@@ -52,7 +53,7 @@ if (productStoreId) {
     context.productStore = [storeName : "All Stores"];
 }
 if (orderStatusId) {
-    conditions.add(EntityCondition.makeCondition("orderStatusId", EntityOperator.EQUALS, orderStatusId));
+    conditions.add(EntityCondition.makeCondition("orderStatusId", EntityOperator.IN, orderStatusId));
 } else {
     // search all orders that are not completed, cancelled or rejected
     conditions.add(

Modified: ofbiz/trunk/applications/order/widget/ordermgr/ReportForms.xml
URL: http://svn.apache.org/viewvc/ofbiz/trunk/applications/order/widget/ordermgr/ReportForms.xml?rev=1749104&r1=1749103&r2=1749104&view=diff
==============================================================================
--- ofbiz/trunk/applications/order/widget/ordermgr/ReportForms.xml (original)
+++ ofbiz/trunk/applications/order/widget/ordermgr/ReportForms.xml Sat Jun 18 23:02:14 2016
@@ -101,12 +101,12 @@ under the License.
     <form name="OpenOrderItemsReport" type="single" target="OpenOrderItemsReport" title=""
         header-row-style="header-row" default-table-style="basic-table">
         <field name="productStoreId">
-            <drop-down allow-empty="false">
+            <check all-checked="false">
                 <option key="" description="- ${uiLabelMap.CommonSelectAny} -"/>
                 <entity-options entity-name="ProductStore" description="${storeName} [${productStoreId}]">
                     <entity-order-by field-name="storeName"/>
                 </entity-options>
-            </drop-down>
+            </check>
         </field>
         <field name="orderTypeId">
             <drop-down allow-empty="false">
@@ -115,12 +115,12 @@ under the License.
             </drop-down>
         </field>
         <field name="orderStatusId">
-            <drop-down allow-empty="false">
+            <check all-checked="false">
                 <option key="" description="- ${uiLabelMap.CommonSelectAny} -"/>
                 <entity-options entity-name="StatusItem" key-field-name="statusId">
-                    <entity-constraint name="statusTypeId" operator="equals" value="ORDER_STATUS"/>
+                    <entity-constraint name="statusId" operator="in" value="ORDER_APPROVED,ORDER_CREATED,ORDER_HOLD"/>
                 </entity-options>
-            </drop-down>
+            </check>
         </field>
         <field name="fromOrderDate" title="${uiLabelMap.OrderReportFromDate}"><date-time type="timestamp"/></field>
         <field name="thruOrderDate" title="${uiLabelMap.OrderReportThruDate}"><date-time type="timestamp"/></field>