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> |
Free forum by Nabble | Edit this page |