[225] | 1 | /** |
---|
| 2 | * Provides a service class for the InventoryItem domain class. |
---|
| 3 | */ |
---|
| 4 | class InventoryItemService { |
---|
| 5 | |
---|
| 6 | boolean transactional = false |
---|
| 7 | |
---|
| 8 | /** |
---|
[425] | 9 | * Prepare a sorted list of possible alternateItems. |
---|
| 10 | */ |
---|
| 11 | def getPossibleAlternateItems(inventoryItemInstance) { |
---|
| 12 | def criteria = inventoryItemInstance.createCriteria() |
---|
| 13 | def possibleAlternateItems = criteria { |
---|
| 14 | and { |
---|
| 15 | eq('isActive', true) |
---|
| 16 | notEqual('id', inventoryItemInstance.id) |
---|
| 17 | } |
---|
| 18 | }.sort { p1, p2 -> p1.name.compareToIgnoreCase(p2.name) } |
---|
| 19 | } |
---|
| 20 | |
---|
| 21 | /** |
---|
[225] | 22 | * Prepare the data for the show view. |
---|
| 23 | * The result can be used to easily construct the model for the show view. |
---|
| 24 | * @param params The incoming params as normally passed to the show view |
---|
| 25 | * primarily including the id of the inventoryItem. |
---|
[405] | 26 | * @returns A map containing result.error, if any error, otherwise result.inventoryItemInstance. |
---|
[225] | 27 | */ |
---|
[405] | 28 | def show(params) { |
---|
[225] | 29 | def result = [:] |
---|
[441] | 30 | |
---|
[405] | 31 | def fail = { Map m -> |
---|
| 32 | result.error = [ code: m.code, args: ["InventoryItem", params.id] ] |
---|
[225] | 33 | return result |
---|
| 34 | } |
---|
| 35 | |
---|
[405] | 36 | result.inventoryItemInstance = InventoryItem.get( params.id ) |
---|
| 37 | |
---|
| 38 | if(!result.inventoryItemInstance) |
---|
| 39 | return fail(code:"default.not.found") |
---|
| 40 | |
---|
[441] | 41 | def p = [:] |
---|
| 42 | |
---|
| 43 | if(params.paginate == "purchases") { |
---|
| 44 | params.showTab = "showPurchasingTab" |
---|
| 45 | p.max = Math.min(params.max?.toInteger() ?: 10, 100) |
---|
| 46 | p.offset = params.offset?.toInteger() ?: 0 |
---|
| 47 | p.sort = params.sort ?: null |
---|
| 48 | p.order = params.order ?: null |
---|
| 49 | } |
---|
| 50 | else { |
---|
| 51 | p.max = 10 |
---|
| 52 | p.offset = 0 |
---|
| 53 | } |
---|
| 54 | |
---|
| 55 | result.inventoryItemPurchasesTotal = InventoryItemPurchase.countByInventoryItem(result.inventoryItemInstance) |
---|
| 56 | |
---|
| 57 | result.inventoryItemPurchases = InventoryItemPurchase.withCriteria { |
---|
| 58 | eq("inventoryItem", result.inventoryItemInstance) |
---|
| 59 | maxResults(p.max) |
---|
| 60 | firstResult(p.offset) |
---|
| 61 | // Sorting: |
---|
| 62 | // Default is to sort by order number then id. |
---|
| 63 | // When a sortable column is clicked then we sort by that. |
---|
| 64 | // If the sortable column clicked is order number then we add id as the second sort. |
---|
| 65 | if(p.sort && p.order) { |
---|
| 66 | order(p.sort, p.order) |
---|
| 67 | if(p.sort == "purchaseOrderNumber") order('id', 'asc') |
---|
| 68 | } |
---|
| 69 | else { |
---|
| 70 | order('purchaseOrderNumber', 'desc') |
---|
| 71 | order('id', 'asc') |
---|
| 72 | } |
---|
| 73 | } |
---|
| 74 | |
---|
[225] | 75 | result.showTab = [:] |
---|
| 76 | switch (params.showTab) { |
---|
| 77 | case "showDetailTab": |
---|
| 78 | result.showTab.detail = new String("true") |
---|
| 79 | break |
---|
| 80 | case "showMovementTab": |
---|
| 81 | result.showTab.movement = new String("true") |
---|
| 82 | break |
---|
[441] | 83 | case "showPurchasingTab": |
---|
| 84 | result.showTab.purchasing = new String("true") |
---|
| 85 | break |
---|
[225] | 86 | default: |
---|
| 87 | result.showTab.inventory = new String("true") |
---|
| 88 | } |
---|
| 89 | |
---|
| 90 | p.max = result.inventoryMovementListMax = 10 |
---|
[441] | 91 | p.offset = 0 |
---|
[225] | 92 | p.order = "desc" |
---|
| 93 | p.sort = "id" |
---|
| 94 | result.inventoryMovementList = InventoryMovement.findAllByInventoryItem(result.inventoryItemInstance, p) |
---|
| 95 | result.inventoryMovementListTotal = InventoryMovement.countByInventoryItem(result.inventoryItemInstance) |
---|
| 96 | |
---|
[441] | 97 | |
---|
[405] | 98 | // Success. |
---|
[225] | 99 | return result |
---|
| 100 | |
---|
[405] | 101 | } // end show() |
---|
[225] | 102 | |
---|
[405] | 103 | def delete(params) { |
---|
[425] | 104 | InventoryItem.withTransaction { status -> |
---|
| 105 | def result = [:] |
---|
[405] | 106 | |
---|
[425] | 107 | def fail = { Map m -> |
---|
| 108 | status.setRollbackOnly() |
---|
| 109 | if(result.inventoryItemInstance && m.field) |
---|
| 110 | result.inventoryItemInstance.errors.rejectValue(m.field, m.code) |
---|
| 111 | result.error = [ code: m.code, args: ["InventoryItem", params.id] ] |
---|
| 112 | return result |
---|
| 113 | } |
---|
[405] | 114 | |
---|
[425] | 115 | result.inventoryItemInstance = InventoryItem.get(params.id) |
---|
[405] | 116 | |
---|
[425] | 117 | if(!result.inventoryItemInstance) |
---|
| 118 | return fail(code:"default.not.found") |
---|
[405] | 119 | |
---|
[425] | 120 | if(result.inventoryItemInstance.inventoryMovements) |
---|
| 121 | return fail(code:"inventoryMovement.still.associated") |
---|
[405] | 122 | |
---|
[425] | 123 | result.inventoryItemInstance.removeReverseAlternateItems() |
---|
| 124 | |
---|
| 125 | try { |
---|
| 126 | result.inventoryItemInstance.delete(flush:true) |
---|
| 127 | return result //Success. |
---|
| 128 | } |
---|
| 129 | catch(org.springframework.dao.DataIntegrityViolationException e) { |
---|
| 130 | return fail(code:"default.delete.failure") |
---|
| 131 | } |
---|
| 132 | |
---|
| 133 | } //end withTransaction |
---|
| 134 | } // end delete() |
---|
| 135 | |
---|
[405] | 136 | def edit(params) { |
---|
| 137 | def result = [:] |
---|
| 138 | def fail = { Map m -> |
---|
| 139 | result.error = [ code: m.code, args: ["InventoryItem", params.id] ] |
---|
| 140 | return result |
---|
| 141 | } |
---|
| 142 | |
---|
| 143 | result.inventoryItemInstance = InventoryItem.get(params.id) |
---|
| 144 | |
---|
| 145 | if(!result.inventoryItemInstance) |
---|
| 146 | return fail(code:"default.not.found") |
---|
| 147 | |
---|
| 148 | // Success. |
---|
| 149 | return result |
---|
| 150 | } |
---|
| 151 | |
---|
| 152 | def update(params) { |
---|
| 153 | InventoryItem.withTransaction { status -> |
---|
| 154 | def result = [:] |
---|
| 155 | |
---|
| 156 | def fail = { Map m -> |
---|
| 157 | status.setRollbackOnly() |
---|
| 158 | if(result.inventoryItemInstance && m.field) |
---|
| 159 | result.inventoryItemInstance.errors.rejectValue(m.field, m.code) |
---|
| 160 | result.error = [ code: m.code, args: ["InventoryItem", params.id] ] |
---|
| 161 | return result |
---|
| 162 | } |
---|
| 163 | |
---|
| 164 | result.inventoryItemInstance = InventoryItem.get(params.id) |
---|
| 165 | |
---|
| 166 | if(!result.inventoryItemInstance) |
---|
| 167 | return fail(code:"default.not.found") |
---|
| 168 | |
---|
| 169 | // Optimistic locking check. |
---|
| 170 | if(params.version) { |
---|
| 171 | if(result.inventoryItemInstance.version > params.version.toLong()) |
---|
| 172 | return fail(field:"version", code:"default.optimistic.locking.failure") |
---|
| 173 | } |
---|
| 174 | |
---|
[425] | 175 | def previousAlternateItems = new ArrayList(result.inventoryItemInstance.alternateItems) |
---|
| 176 | |
---|
[405] | 177 | result.inventoryItemInstance.properties = params |
---|
| 178 | |
---|
| 179 | if(result.inventoryItemInstance.hasErrors() || !result.inventoryItemInstance.save()) |
---|
| 180 | return fail(code:"default.update.failure") |
---|
| 181 | |
---|
[425] | 182 | result.inventoryItemInstance.removeReverseAlternateItems(previousAlternateItems) |
---|
| 183 | result.inventoryItemInstance.addReverseAlternateItems() |
---|
| 184 | |
---|
[405] | 185 | // Success. |
---|
| 186 | return result |
---|
| 187 | |
---|
| 188 | } //end withTransaction |
---|
| 189 | } // end update() |
---|
| 190 | |
---|
| 191 | def create(params) { |
---|
| 192 | def result = [:] |
---|
| 193 | def fail = { Map m -> |
---|
| 194 | result.error = [ code: m.code, args: ["InventoryItem", params.id] ] |
---|
| 195 | return result |
---|
| 196 | } |
---|
| 197 | |
---|
| 198 | result.inventoryItemInstance = new InventoryItem() |
---|
| 199 | result.inventoryItemInstance.properties = params |
---|
| 200 | |
---|
| 201 | // success |
---|
| 202 | return result |
---|
| 203 | } |
---|
| 204 | |
---|
| 205 | def save(params) { |
---|
| 206 | InventoryItem.withTransaction { status -> |
---|
| 207 | def result = [:] |
---|
| 208 | |
---|
| 209 | def fail = { Map m -> |
---|
| 210 | status.setRollbackOnly() |
---|
| 211 | if(result.inventoryItemInstance && m.field) |
---|
| 212 | result.inventoryItemInstance.errors.rejectValue(m.field, m.code) |
---|
| 213 | result.error = [ code: m.code, args: ["InventoryItem", params.id] ] |
---|
| 214 | return result |
---|
| 215 | } |
---|
| 216 | |
---|
| 217 | result.inventoryItemInstance = new InventoryItem(params) |
---|
| 218 | |
---|
| 219 | if(result.inventoryItemInstance.hasErrors() || !result.inventoryItemInstance.save()) |
---|
| 220 | return fail(code:"default.create.failure") |
---|
| 221 | |
---|
| 222 | // success |
---|
| 223 | return result |
---|
| 224 | |
---|
| 225 | } //end withTransaction |
---|
| 226 | } |
---|
| 227 | |
---|
[548] | 228 | /** |
---|
| 229 | * Save an inventory item picture. |
---|
| 230 | * @param pictureSource A supported source to get the picture image from. |
---|
| 231 | * Supported sources: |
---|
| 232 | * HttpServletRequest e.g: 'request' var from controller to run getFile('file') against. |
---|
| 233 | * ServletContextResource e.g: grailsApplication.mainContext.getResource('images/logo.png') |
---|
| 234 | */ |
---|
| 235 | def savePicture(params, pictureSource) { |
---|
| 236 | InventoryItem.withTransaction { status -> |
---|
| 237 | def result = [:] |
---|
| 238 | |
---|
| 239 | def kByteMultiplier = 1000 |
---|
| 240 | |
---|
| 241 | def fail = { Map m -> |
---|
| 242 | status.setRollbackOnly() |
---|
| 243 | if(result.inventoryItemInstance && m.field) |
---|
| 244 | result.inventoryItemInstance.errors.rejectValue(m.field, m.code) |
---|
| 245 | result.error = [ code: m.code, args: m.args ?: ["InventoryItem", params.id] ] |
---|
| 246 | return result |
---|
| 247 | } |
---|
| 248 | |
---|
| 249 | result.inventoryItemInstance = InventoryItem.get(params.id) |
---|
| 250 | |
---|
| 251 | if(!result.inventoryItemInstance) |
---|
| 252 | return fail(code:"default.not.found") |
---|
| 253 | |
---|
| 254 | // Optimistic locking check. |
---|
| 255 | if(params.version) { |
---|
| 256 | if(result.inventoryItemInstance.version > params.version.toLong()) |
---|
| 257 | return fail(field:"version", code:"default.optimistic.locking.failure") |
---|
| 258 | } |
---|
| 259 | |
---|
| 260 | if(result.inventoryItemInstance.picture) |
---|
| 261 | return fail(field:"picture", code:"inventory.item.already.has.picture") |
---|
| 262 | |
---|
[549] | 263 | // Declare some more variables, since we appear to have most of what we need. |
---|
[548] | 264 | def picture = new Picture(inventoryItem: result.inventoryItemInstance) |
---|
| 265 | def imaging = new Imaging() |
---|
| 266 | def images = null |
---|
| 267 | def pictureFile |
---|
| 268 | def pictureFileName = '' |
---|
| 269 | def pictureInputStream |
---|
| 270 | |
---|
[549] | 271 | // Check the supplied pictureSource and get the inputStream. |
---|
[548] | 272 | if(pictureSource instanceof javax.servlet.http.HttpServletRequest) { |
---|
| 273 | def multiPartFile = pictureSource.getFile('file') |
---|
| 274 | pictureFileName = multiPartFile.originalFilename |
---|
| 275 | |
---|
| 276 | if(!multiPartFile || multiPartFile.isEmpty()) |
---|
| 277 | return fail(code: "default.file.not.supplied") |
---|
| 278 | |
---|
| 279 | if (multiPartFile.getSize() > Image.MAX_SIZE) |
---|
| 280 | return fail(code: "default.file.over.max.size", args: [Image.MAX_SIZE/kByteMultiplier, "kB"]) |
---|
| 281 | |
---|
| 282 | pictureInputStream = multiPartFile.inputStream |
---|
| 283 | } |
---|
| 284 | else if(pictureSource instanceof org.springframework.web.context.support.ServletContextResource) { |
---|
| 285 | pictureFile = pictureSource.getFile() |
---|
| 286 | pictureFileName = pictureFile.name |
---|
| 287 | |
---|
| 288 | if ( !pictureFile.isFile() || (pictureFile.length() == 0) ) |
---|
| 289 | return fail(code:"default.file.not.supplied") |
---|
| 290 | |
---|
| 291 | if (pictureFile.length() > Image.MAX_SIZE) |
---|
| 292 | return fail(code:"default.file.over.max.size", args: [Image.MAX_SIZE/kByteMultiplier, "kB"]) |
---|
| 293 | |
---|
| 294 | pictureInputStream = pictureSource.inputStream |
---|
| 295 | } |
---|
| 296 | else { |
---|
[549] | 297 | return fail(code:"inventory.item.picture.source.not.supported") |
---|
[548] | 298 | } |
---|
| 299 | |
---|
[549] | 300 | // Create the Images. |
---|
[548] | 301 | try { |
---|
| 302 | images = imaging.createAll(result.inventoryItemInstance, picture, pictureInputStream) |
---|
[549] | 303 | // Ensure the stream is closed. |
---|
| 304 | pictureInputStream.close() |
---|
[548] | 305 | } |
---|
| 306 | catch(Exception ex) { |
---|
| 307 | log.error("picture save", ex) |
---|
[549] | 308 | // Ensure the stream is closed. |
---|
| 309 | pictureInputStream.close() |
---|
[548] | 310 | return fail(code:"inventory.item.picture.file.unrecognised", args: [pictureFileName]) |
---|
| 311 | } |
---|
| 312 | |
---|
[549] | 313 | // Add images to picture. |
---|
[548] | 314 | images.each { image -> |
---|
| 315 | picture.addToImages(image) |
---|
| 316 | } |
---|
| 317 | |
---|
[549] | 318 | // Save picture. |
---|
[548] | 319 | if(picture.hasErrors() || !picture.save()) |
---|
| 320 | return fail(code:"default.create.failure", args: ["Picture"]) |
---|
| 321 | |
---|
| 322 | result.inventoryItemInstance.picture = picture |
---|
| 323 | |
---|
[549] | 324 | // Save inventoryItem. |
---|
[548] | 325 | if(result.inventoryItemInstance.hasErrors() || !result.inventoryItemInstance.save()) |
---|
| 326 | return fail(code:"default.create.failure") |
---|
| 327 | |
---|
| 328 | // success |
---|
| 329 | return result |
---|
| 330 | |
---|
| 331 | } //end withTransaction |
---|
| 332 | } |
---|
| 333 | |
---|
[225] | 334 | } // end class |
---|