Changeset 423

Timestamp:

Mar 2, 2010, 5:22:14 PM (15 years ago)

Author:

gav

Message:

Add Inventory import/export functionality.

Location:

trunk/grails-app

Files:

• controllers/InventoryItemDetailedController.groovy (modified) (2 diffs)
• services/InventoryCsvService.groovy (added)
• views/inventoryItemDetailed/importInventory.gsp (added)
• views/inventoryItemDetailed/search.gsp (modified) (1 diff)

trunk/grails-app/controllers/InventoryItemDetailedController.groovy

@@ -7 +7 @@
     def filterService
     def exportService
+    def inventoryCsvService
     def inventoryItemService
     def inventoryMovementService
@@ -30 +31 @@
         }
         forward(action: 'search', params: params)
+    }
+
+    /**
+    * Disaply the import view.
+    */
+    def importInventory = {
+    }
+
+    /**
+    * Handle the import save.
+    */
+    def importInventorySave = {
+        def result = inventoryCsvService.importInventory(request)
+
+        if(!result.error) {
+            flash.message = g.message(code: "inventory.import.success")
+            redirect(action:search)
+            return
+        }
+
+        flash.errorMessage = g.message(code: result.error.code, args: result.error.args)
+        redirect(action: importInventory)
+    }
+
+    /**
+    * Export a csv template.
+    * NOTE: IE has a 'validating' bug in dev mode that causes the export to take a long time!
+    * This does not appear to be a problem once deployed to Tomcat.
+    */
+    @Secured(['ROLE_AppAdmin', 'ROLE_Manager', 'ROLE_InventoryManager', 'ROLE_InventoryUser'])
+    def exportInventoryTemplate = {
+        response.contentType = ConfigurationHolder.config.grails.mime.types["csv"]
+        response.setHeader("Content-disposition", "attachment; filename=InventoryTemplate.csv")
+        def s = inventoryCsvService.buildInventoryTemplate()
+        render s
+    }
+
+    /**
+    * Export a csv test file.
+    */
+    def exportInventoryExample = {
+        response.contentType = ConfigurationHolder.config.grails.mime.types["csv"]
+        response.setHeader("Content-disposition", "attachment; filename=InventoryExample.csv")
+        def s = inventoryCsvService.buildInventoryExample()
+        render s
+    }
+
+    /**
+    * Export the entire inventory as a csv file.
+    */
+    @Secured(['ROLE_AppAdmin', 'ROLE_Manager', 'ROLE_InventoryManager', 'ROLE_InventoryUser'])
+    def exportInventory = {
+
+        def inventoryItemList = InventoryItem.list()
+
+        response.contentType = ConfigurationHolder.config.grails.mime.types["csv"]
+        response.setHeader("Content-disposition", "attachment; filename=Inventory.csv")
+        def s = inventoryCsvService.buildInventory(inventoryItemList)
+        render s
     }
 

trunk/grails-app/views/inventoryItemDetailed/search.gsp

@@ -55 +55 @@
                                             <g:actionSubmit action="setSearchParamsMax" class="go" value="Update" />
                                         </span>
+                                    </td>
+                                </tr>
+
+                                <tr class="prop">
+                                    <td valign="top" class="name">
+                                        <label for="max">Inventory:</label>
+                                    </td>
+                                    <td valign="top" class="value">
+                                        <g:link action="exportInventory">
+                                            Export
+                                        </g:link>
+                                        /
+                                        <g:link action="exportInventoryTemplate">
+                                            Template
+                                        </g:link>
+                                        /
+                                        <g:link action="exportInventoryExample">
+                                            Example
+                                        </g:link>
+                                        /
+                                        <g:link action="importInventory">
+                                            Import
+                                        </g:link>
                                     </td>
                                 </tr>