svn commit: r554618 - /ofbiz/trunk/applications/order/webapp/ordermgr/requirement/RequirementForms.xml

[jacopoc]

Author: jacopoc
Date: Mon Jul  9 05:40:27 2007
New Revision: 554618

URL: http://svn.apache.org/viewvc?view=rev&rev=554618
Log:
Added to the requirements list two new columns to provide information about actual qoh in the warehouse and total qoh in all the warehouses.

Modified:
    ofbiz/trunk/applications/order/webapp/ordermgr/requirement/RequirementForms.xml

Modified: ofbiz/trunk/applications/order/webapp/ordermgr/requirement/RequirementForms.xml
URL: http://svn.apache.org/viewvc/ofbiz/trunk/applications/order/webapp/ordermgr/requirement/RequirementForms.xml?view=diff&rev=554618&r1=554617&r2=554618
==============================================================================
--- ofbiz/trunk/applications/order/webapp/ordermgr/requirement/RequirementForms.xml (original)
+++ ofbiz/trunk/applications/order/webapp/ordermgr/requirement/RequirementForms.xml Mon Jul  9 05:40:27 2007
@@ -61,6 +61,19 @@
                 <field-map field-name="orderBy" value="statusId"/>
             </service>
         </actions>
+        <row-actions>
+            <set field="lookupProductId" value="${bsh: (productId == null? &quot;_NA_&quot;: productId);}" type="String"/>
+            <set field="lookupFacilityId" value="${bsh: (facilityIdId == null? &quot;_NA_&quot;: facilityId);}" type="String"/>
+            <service service-name="getInventoryAvailableByFacility" result-map-name="resultQoh">
+                <field-map field-name="productId" env-name="lookupProductId"/>
+                <field-map field-name="facilityId" env-name="lookupFacilityId"/>
+            </service>
+            <service service-name="getProductInventoryAvailable" result-map-name="resultQohTotal">
+                <field-map field-name="productId" env-name="lookupProductId"/>
+            </service>
+            <set field="facilityQuantityOnHandTotal" from-field="resultQoh.quantityOnHandTotal"/>
+            <set field="quantityOnHandTotal" from-field="resultQohTotal.quantityOnHandTotal"/>
+        </row-actions>
         <field name="requirementId" widget-style="buttontext">
             <hyperlink target-type="inter-app" description="${requirementId}" target="/ordermgr/control/EditRequirement?requirementId=${requirementId}"/>
         </field>
@@ -75,6 +88,8 @@
         <field name="requirementStartDate"><display/></field>
         <field name="requiredByDate"><display/></field>
         <field name="quantity" title="${uiLabelMap.CommonQuantity}"><display/></field>
+        <field name="facilityQuantityOnHandTotal"><display/></field>
+        <field name="quantityOnHandTotal"><display/></field>
         <field name="requestsLink" widget-style="buttontext">
             <hyperlink description="${uiLabelMap.OrderRequests}" target="ListRequirementCustRequests?requirementId=${requirementId}"/>
         </field>