You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@ofbiz.apache.org by ap...@apache.org on 2007/10/18 23:13:19 UTC
svn commit: r586139 - in /ofbiz/trunk/applications/product:
config/ProductUiLabels.properties webapp/facility/WEB-INF/controller.xml
webapp/facility/facility/FacilityForms.xml
widget/facility/FacilityScreens.xml
Author: apatel
Date: Thu Oct 18 14:13:18 2007
New Revision: 586139
URL: http://svn.apache.org/viewvc?rev=586139&view=rev
Log:
Adding Export Inventory Item report in CSV format.
Modified:
ofbiz/trunk/applications/product/config/ProductUiLabels.properties
ofbiz/trunk/applications/product/webapp/facility/WEB-INF/controller.xml
ofbiz/trunk/applications/product/webapp/facility/facility/FacilityForms.xml
ofbiz/trunk/applications/product/widget/facility/FacilityScreens.xml
Modified: ofbiz/trunk/applications/product/config/ProductUiLabels.properties
URL: http://svn.apache.org/viewvc/ofbiz/trunk/applications/product/config/ProductUiLabels.properties?rev=586139&r1=586138&r2=586139&view=diff
==============================================================================
--- ofbiz/trunk/applications/product/config/ProductUiLabels.properties (original)
+++ ofbiz/trunk/applications/product/config/ProductUiLabels.properties Thu Oct 18 14:13:18 2007
@@ -711,6 +711,7 @@
ProductInventoryItemsFor=Inventory Items for
ProductInventoryItemsToPick=Inventory Items to Pick
ProductInventoryItemTotals=Inventory Item Totals
+ProductInventoryItemTotalsExport=Export Inventory Item Totals
ProductInventoryItemGrandTotals=Inventory Item Grand Totals
ProductInventoryMessage=Inventory Message
ProductInventoryReceive=Receive Inventory
Modified: ofbiz/trunk/applications/product/webapp/facility/WEB-INF/controller.xml
URL: http://svn.apache.org/viewvc/ofbiz/trunk/applications/product/webapp/facility/WEB-INF/controller.xml?rev=586139&r1=586138&r2=586139&view=diff
==============================================================================
--- ofbiz/trunk/applications/product/webapp/facility/WEB-INF/controller.xml (original)
+++ ofbiz/trunk/applications/product/webapp/facility/WEB-INF/controller.xml Thu Oct 18 14:13:18 2007
@@ -28,6 +28,7 @@
<handler name="bsf" type="request" class="org.ofbiz.webapp.event.BsfEventHandler"/>
<handler name="screenxml" type="view" class="org.ofbiz.widget.screen.ScreenXmlViewHandler"/>
+ <handler name="screentext" type="view" class="org.ofbiz.widget.screen.ScreenTextViewHandler"/>
<!-- Events to run on every request before security (chains exempt) -->
<!--
@@ -1092,6 +1093,10 @@
<security https="true" auth="true"/>
<response name="success" type="view" value="InventoryItemGrandTotals"/>
</request-map>
+ <request-map uri="InventoryItemTotalsExport.csv">
+ <security https="true" auth="true"/>
+ <response name="success" type="view" value="InventoryItemTotalsExport"/>
+ </request-map>
<!-- ================ Lookup Requests ================= -->
<request-map uri="LookupOrderHeaderAndShipInfo"><security https="true" auth="true"/><response name="success" type="view" value="LookupOrderHeaderAndShipInfo"/></request-map>
@@ -1175,6 +1180,7 @@
<view-map name="InventoryReports" type="screen" page="component://product/widget/facility/ReportScreens.xml#InventoryReports"/>
<view-map name="InventoryItemTotals" type="screen" page="component://product/widget/facility/FacilityScreens.xml#InventoryItemTotals"/>
<view-map name="InventoryItemGrandTotals" type="screen" page="component://product/widget/facility/FacilityScreens.xml#InventoryItemGrandTotals"/>
+ <view-map name="InventoryItemTotalsExport" type="screentext" page="component://product/widget/facility/FacilityScreens.xml#InventoryItemTotalsExport" content-type="text/csv" encoding="none"/>
<view-map name="LookupOrderHeaderAndShipInfo" type="screen" page="component://order/widget/ordermgr/LookupScreens.xml#LookupOrderHeaderAndShipInfo"/>
<view-map name="LookupPurchaseOrderHeaderAndShipInfo" type="screen" page="component://order/widget/ordermgr/LookupScreens.xml#LookupPurchaseOrderHeaderAndShipInfo"/>
Modified: ofbiz/trunk/applications/product/webapp/facility/facility/FacilityForms.xml
URL: http://svn.apache.org/viewvc/ofbiz/trunk/applications/product/webapp/facility/facility/FacilityForms.xml?rev=586139&r1=586138&r2=586139&view=diff
==============================================================================
--- ofbiz/trunk/applications/product/webapp/facility/facility/FacilityForms.xml (original)
+++ ofbiz/trunk/applications/product/webapp/facility/facility/FacilityForms.xml Thu Oct 18 14:13:18 2007
@@ -362,4 +362,49 @@
<field name="totalCostPriceGrandTotal" title="${uiLabelMap.CommonTotal} ${uiLabelMap.ProductCostPrice}" widget-area-style="tabletextright"><display/></field>
<field name="totalRetailPriceGrandTotal" title="${uiLabelMap.CommonTotal} ${uiLabelMap.ProductRetailPrice}" widget-area-style="tabletextright"><display/></field>
</form>
+ <form name="InventoryItemTotalsExport" type="list" list-name="inventoryItemTotals">
+
+ <field name="productId" title="${uiLabelMap.ProductProductId}"><display/></field>
+ <field name="separator0" title=","><display description=","/></field>
+ <field name="quot0" title="""><display description="""/></field>
+ <field name="quantityOnHand" title="${uiLabelMap.ProductQoh}"><display/></field>
+ <field name="quot1" title="""><display description="""/></field>
+ <field name="separator1" title=","><display description=","/></field>
+ <field name="quot2" title="""><display description="""/></field>
+ <field name="availableToPromise" title="${uiLabelMap.ProductAtp}"><display/></field>
+ <field name="quot3" title="""><display description="""/></field>
+ <field name="separator2" title=","><display description=","/></field>
+ <field name="quot4" title="""><display description="""/></field>
+ <field name="costPrice" title="${uiLabelMap.ProductCostPrice}"><display/></field>
+ <field name="quot5" title="""><display description="""/></field>
+ <field name="separator3" title=","><display description=","/></field>
+ <field name="quot6" title="""><display description="""/></field>
+ <field name="retailPrice" title="${uiLabelMap.ProductRetailPrice}"><display/></field>
+ <field name="quot7" title="""><display description="""/></field>
+ <field name="separator4" title=","><display description=","/></field>
+ <field name="quot8" title="""><display description="""/></field>
+ <field name="totalCostPrice" title="${uiLabelMap.CommonTotal} ${uiLabelMap.ProductCostPrice}"><display/></field>
+ <field name="quot9" title="""><display description="""/></field>
+ <field name="separator5" title=","><display description=","/></field>
+ <field name="quot10" title="""><display description="""/></field>
+ <field name="totalRetailPrice" title="${uiLabelMap.CommonTotal} ${uiLabelMap.ProductRetailPrice}"><display/></field>
+ <field name="quot11" title="""><display description="""/></field>
+ </form>
+ <form name="InventoryItemGrandTotalsExport" type="list" list-name="inventoryItemGrandTotals">
+ <field name="quot0" title="""><display description="""/></field>
+ <field name="qohGrandTotal" title="${uiLabelMap.ProductQoh} ${uiLabelMap.CommonTotal} ${uiLabelMap.CommonQty}"><display/></field>
+ <field name="quot1" title="""><display description="""/></field>
+ <field name="separator0" title=","><display description=","/></field>
+ <field name="quot2" title="""><display description="""/></field>
+ <field name="atpGrandTotal" title="${uiLabelMap.ProductAtp} ${uiLabelMap.CommonTotal} ${uiLabelMap.CommonQty}"><display/></field>
+ <field name="quot3" title="""><display description="""/></field>
+ <field name="separator1" title=","><display description=","/></field>
+ <field name="quot4" title="""><display description="""/></field>
+ <field name="totalCostPriceGrandTotal" title="${uiLabelMap.CommonTotal} ${uiLabelMap.ProductCostPrice}"><display/></field>
+ <field name="quot5" title="""><display description="""/></field>
+ <field name="separator2" title=","><display description=","/></field>
+ <field name="quot6" title="""><display description="""/></field>
+ <field name="totalRetailPriceGrandTotal" title="${uiLabelMap.CommonTotal} ${uiLabelMap.ProductRetailPrice}"><display/></field>
+ <field name="quot7" title="""><display description="""/></field>
+ </form>
</forms>
Modified: ofbiz/trunk/applications/product/widget/facility/FacilityScreens.xml
URL: http://svn.apache.org/viewvc/ofbiz/trunk/applications/product/widget/facility/FacilityScreens.xml?rev=586139&r1=586138&r2=586139&view=diff
==============================================================================
--- ofbiz/trunk/applications/product/widget/facility/FacilityScreens.xml (original)
+++ ofbiz/trunk/applications/product/widget/facility/FacilityScreens.xml Thu Oct 18 14:13:18 2007
@@ -246,6 +246,17 @@
<link target="ViewFacilityInventoryByProductExport?${searchParameterString}" text="${uiLabelMap.CommonExport}" style="buttontext"/>
<link target="InventoryItemTotals?facilityId=${facilityId}&action=Y" text="${uiLabelMap.ProductInventoryItemTotals}" style="buttontext"/>
<link target="InventoryItemGrandTotals?facilityId=${facilityId}&action=Y" text="${uiLabelMap.ProductInventoryItemGrandTotals}" style="buttontext"/>
+ <section>
+ <actions>
+ <set field="genericLinkName" value="Export"/>
+ <set field="genericLinkText" value="${uiLabelMap.ProductInventoryItemTotalsExport}"/>
+ <set field="genericLinkTarget" value="InventoryItemTotalsExport.csv?action=Y"/>
+ <set field="genericLinkStyle" value="buttontext"/>
+ </actions>
+ <widgets>
+ <include-screen name="genericLink" location="component://common/widget/CommonScreens.xml"/>
+ </widgets>
+ </section>
</container>
<include-form name="FindFacilityInventoryByProduct" location="component://product/webapp/facility/facility/FacilityForms.xml"/>
@@ -412,6 +423,32 @@
<include-form name="ListInventoryItemGrandTotals" location="component://product/webapp/facility/facility/FacilityForms.xml"/>
</decorator-section>
</decorator-screen>
+ </widgets>
+ </section>
+ </screen>
+
+ <screen name="InventoryItemTotalsExport">
+ <section>
+ <actions>
+ <property-map resource="ProductUiLabels" map-name="uiLabelMap" global="true"/>
+ <property-map resource="CommonUiLabels" map-name="uiLabelMap" global="true"/>
+
+ <set field="facilityId" from-field="parameters.facilityId"/>
+ <set field="viewIndex" from-field="parameters.VIEW_INDEX" type="Integer" default-value="0"/>
+ <set field="viewSize" from-field="parameters.VIEW_SIZE" type="Integer" default-value="10000"/>
+
+ <entity-one entity-name="Facility" value-name="facility" use-cache="true"/>
+ <script location="component://product/webapp/facility/WEB-INF/actions/inventory/InventoryItemTotals.bsh"/>
+ </actions>
+ <widgets>
+ <container>
+ <label style="head2" text="${uiLabelMap.ProductInventoryItemTotals} ${uiLabelMap.CommonFor} ${facility.facilityName}"/>
+ </container>
+ <include-form name="InventoryItemTotalsExport" location="component://product/webapp/facility/facility/FacilityForms.xml"/>
+ <container>
+ <label style="head2" text="${uiLabelMap.ProductInventoryItemGrandTotals} ${uiLabelMap.CommonFor} ${facility.facilityName}"/>
+ </container>
+ <include-form name="InventoryItemGrandTotalsExport" location="component://product/webapp/facility/facility/FacilityForms.xml"/>
</widgets>
</section>
</screen>