Context Navigation

source: trunk/grails-app/controllers/InventoryItemDetailedController.groovy @ 719

Last change on this file since 719 was 719, checked in by gav, 13 years ago
Domain change: as per ticket #96 - Remove unused fields from InventoryItem?. Removed InventoryItem?.preferredManufacturer and manufacturersPartNumber.
File size: 30.7 KB

Line
1	import org.codehaus.groovy.grails.plugins.springsecurity.Secured
2	import org.codehaus.groovy.grails.commons.ConfigurationHolder
3	import com.zeddware.grails.plugins.filterpane.FilterUtils
4	import org.springframework.web.servlet.support.RequestContextUtils as RCU
5
6	@Secured(['ROLE_AppAdmin', 'ROLE_Manager', 'ROLE_InventoryManager'])
7	class InventoryItemDetailedController extends BaseController {
8
9	def filterService
10	def exportService
11	def inventoryCsvService
12	def inventoryItemService
13	def inventoryItemSearchService
14	def inventoryMovementService
15
16	// the delete, save and update actions only accept POST requests
17	static allowedMethods = [delete:'POST', save:'POST', update:'POST', useInventoryItem:'POST']
18
19	@Secured(['ROLE_AppAdmin', 'ROLE_Manager', 'ROLE_InventoryManager', 'ROLE_InventoryUser'])
20	def index = { redirect(action:search, params:params) }
21
22	/**
23	* Set session.inventoryItemSearchParamsMax
24	*/
25	@Secured(['ROLE_AppAdmin', 'ROLE_Manager', 'ROLE_InventoryManager', 'ROLE_InventoryUser'])
26	def setSearchParamsMax = {
27	def max = 1000
28	if(params.newMax?.isInteger()) {
29	def i = params.newMax.toInteger()
30	if(i > 0 && i <= max)
31	session.inventoryItemSearchParamsMax = params.newMax
32	if(i > max)
33	session.inventoryItemSearchParamsMax = max
34	}
35	forward(action: 'search', params: params)
36	}
37
38	/**
39	* Set session.inventoryItemReorderSearchParamsMax
40	*/
41	@Secured(['ROLE_AppAdmin', 'ROLE_Manager', 'ROLE_InventoryManager', 'ROLE_InventoryUser'])
42	def setReorderSearchParamsMax = {
43	def max = 1000
44	if(params.newMax?.isInteger()) {
45	def i = params.newMax.toInteger()
46	if(i > 0 && i <= max)
47	session.inventoryItemReorderSearchParamsMax = params.newMax
48	if(i > max)
49	session.inventoryItemReorderSearchParamsMax = max
50	}
51	forward(action: 'reorder', params: params)
52	}
53
54	/**
55	* Display the import view.
56	*/
57	def importInventoryItemPictures = {
58	}
59
60	/**
61	* Handle the import save.
62	*/
63	def importInventoryItemPicturesSave = {
64	def result = inventoryItemService.importInventoryItemPictures(request)
65
66	if(!result.error) {
67	def logFileLink = g.link(controller: "appCore", action: "appLog") {"log"}
68	flash.message = g.message(code: "inventoryItemPictures.import.success", args: [logFileLink])
69	redirect(action:search)
70	return
71	}
72
73	flash.errorMessage = g.message(code: result.error.code, args: result.error.args)
74	redirect(action: importInventoryItemPictures)
75	}
76
77	/**
78	* Display the import view.
79	*/
80	def importInventory = {
81	}
82
83	/**
84	* Handle the import save.
85	*/
86	def importInventorySave = {
87	def result = inventoryCsvService.importInventory(request)
88
89	if(!result.error) {
90	flash.message = g.message(code: "inventory.import.success")
91	redirect(action:search)
92	return
93	}
94
95	flash.errorMessage = g.message(code: result.error.code, args: result.error.args)
96	redirect(action: importInventory)
97	}
98
99	/**
100	* Export a csv template.
101	* NOTE: IE has a 'validating' bug in dev mode that causes the export to take a long time!
102	* This does not appear to be a problem once deployed to Tomcat.
103	*/
104	@Secured(['ROLE_AppAdmin', 'ROLE_Manager', 'ROLE_InventoryManager', 'ROLE_InventoryUser'])
105	def exportInventoryTemplate = {
106	response.contentType = ConfigurationHolder.config.grails.mime.types["csv"]
107	response.setHeader("Content-disposition", "attachment; filename=InventoryTemplate.csv")
108	def s = inventoryCsvService.buildInventoryTemplate()
109	render s
110	}
111
112	/**
113	* Export a csv test file.
114	*/
115	def exportInventoryExample = {
116	response.contentType = ConfigurationHolder.config.grails.mime.types["csv"]
117	response.setHeader("Content-disposition", "attachment; filename=InventoryExample.csv")
118	def s = inventoryCsvService.buildInventoryExample()
119	render s
120	}
121
122	/**
123	* Export the entire inventory as a csv file.
124	*/
125	@Secured(['ROLE_AppAdmin', 'ROLE_Manager', 'ROLE_InventoryManager', 'ROLE_InventoryUser'])
126	def exportInventory = {
127
128	def inventoryItemList = InventoryItem.list()
129
130	response.contentType = ConfigurationHolder.config.grails.mime.types["csv"]
131	response.setHeader("Content-disposition", "attachment; filename=Inventory.csv")
132	def s = inventoryCsvService.buildInventory(inventoryItemList)
133	render s
134	}
135
136	/**
137	* Display the import view for purchases.
138	*/
139	def importInventoryItemPurchases = {
140	}
141
142	/**
143	* Handle the inventory purchases import save.
144	*/
145	def importInventoryItemPurchasesSave = {
146	def result = inventoryCsvService.importInventoryItemPurchases(request)
147
148	if(!result.error) {
149	flash.message = g.message(code: "inventory.import.success")
150	redirect(action:search)
151	return
152	}
153
154	flash.errorMessage = g.message(code: result.error.code, args: result.error.args)
155	redirect(action: importInventoryItemPurchases)
156	}
157
158	/**
159	* Search for Inventory items.
160	*/
161	@Secured(['ROLE_AppAdmin', 'ROLE_Manager', 'ROLE_InventoryManager', 'ROLE_InventoryUser'])
162	def search = {
163
164	if(session.inventoryItemSearchParamsMax)
165	params.max = session.inventoryItemSearchParamsMax
166
167	// Protect filterPane.
168	params.max = Math.min( params.max ? params.max.toInteger() : 10, 1000)
169
170	def inventoryItemInstanceList = []
171	def inventoryItemInstanceTotal
172	def filterParams = com.zeddware.grails.plugins.filterpane.FilterUtils.extractFilterParams(params)
173	def isFilterApplied = FilterUtils.isFilterApplied(params)
174
175	// Restore default sort if a new text search is requested
176	if(params.newTextSearch) {
177	params.sort = 'id'
178	params.order = 'desc'
179	}
180
181	// Restore search unless a new search is being requested.
182	if(!params.searchText && !params.quickSearch && !filterParams) {
183	if(session.inventoryItemSearchText) {
184	params.searchText = session.inventoryItemSearchText
185	params.searchName = session.inventoryItemSearchName
186	params.searchDescription = session.inventoryItemSearchDescription
187	params.searchComment = session.inventoryItemSearchComment
188	params.searchLocation = session.inventoryItemSearchLocation
189	params.searchGroup = session.inventoryItemSearchGroup
190	params.searchSpareFor = session.inventoryItemSearchSpareFor
191	}
192	else if(session.inventoryItemQuickSearch) {
193	params.quickSearch = session.inventoryItemQuickSearch
194	if(session.inventoryItemQuickSearchDaysBack)
195	params.daysBack = session.inventoryItemQuickSearchDaysBack.toString()
196	}
197	else if(session.inventoryItemSearchFilterParams) {
198	session.inventoryItemSearchFilterParams.each() { params[it.key] = it.value }
199	params.filter = session.inventoryItemSearchFilter
200	isFilterApplied = FilterUtils.isFilterApplied(params)
201	}
202	}
203
204	// Remember sort if supplied, otherwise try to restore.
205	if(params.sort && params.order) {
206	session.inventoryItemSearchSort = params.sort
207	session.inventoryItemSearchOrder = params.order
208	}
209	else if(session.inventoryItemSearchSort && session.inventoryItemSearchOrder) {
210	params.sort = session.inventoryItemSearchSort
211	params.order = session.inventoryItemSearchOrder
212	}
213
214	if(isFilterApplied) {
215	// filterPane:
216	inventoryItemInstanceList = filterService.filter( params, InventoryItem )
217	inventoryItemInstanceTotal = filterService.count( params, InventoryItem )
218	filterParams = com.zeddware.grails.plugins.filterpane.FilterUtils.extractFilterParams(params)
219	// Remember search.
220	session.inventoryItemSearchFilterParams = new LinkedHashMap(filterParams)
221	session.inventoryItemSearchFilter = new LinkedHashMap(params.filter)
222	// Clear any previous search.
223	session.removeAttribute("inventoryItemSearchText")
224	session.removeAttribute("inventoryItemSearchName")
225	session.removeAttribute("inventoryItemSearchDescription")
226	session.removeAttribute("inventoryItemSearchComment")
227	session.removeAttribute("inventoryItemSearchLocation")
228	session.removeAttribute("inventoryItemSearchGroup")
229	session.removeAttribute("inventoryItemSearchSpareFor")
230	session.removeAttribute("inventoryItemQuickSearch")
231	session.removeAttribute("inventoryItemQuickSearchDaysBack")
232	}
233	else if(params.searchText) {
234	// Text Search:
235	def result = inventoryItemSearchService.getTextSearch(params, RCU.getLocale(request))
236	inventoryItemInstanceList = result.inventoryItemList
237	inventoryItemInstanceTotal = result.inventoryItemList.totalCount
238	params.message = result.message
239	filterParams.searchText = result.searchText
240	// Place limit search selects in filterParams for pagination.
241	if(params.searchName)
242	filterParams.searchName = params.searchName
243	if(params.searchDescription)
244	filterParams.searchDescription = params.searchDescription
245	if(params.searchComment)
246	filterParams.searchComment = params.searchComment
247	if(params.searchLocation)
248	filterParams.searchLocation = params.searchLocation
249	if(params.searchGroup)
250	filterParams.searchGroup = params.searchGroup
251	if(params.searchSpareFor)
252	filterParams.searchSpareFor = params.searchSpareFor
253	// Remember search.
254	session.inventoryItemSearchText = params.searchText
255	session.inventoryItemSearchName = params.searchName
256	session.inventoryItemSearchDescription = params.searchDescription
257	session.inventoryItemSearchComment = params.searchComment
258	session.inventoryItemSearchLocation = params.searchLocation
259	session.inventoryItemSearchGroup = params.searchGroup
260	session.inventoryItemSearchSpareFor = params.searchSpareFor
261	// Clear any previous search.
262	session.removeAttribute("inventoryItemQuickSearch")
263	session.removeAttribute("inventoryItemQuickSearchDaysBack")
264	session.removeAttribute("inventoryItemSearchFilterParams")
265	session.removeAttribute("inventoryItemSearchFilter")
266	}
267	else {
268	// Quick Search Links:
269	if(!params.quickSearch) params.quickSearch = "all"
270	def result = inventoryItemSearchService.getQuickSearch(params, RCU.getLocale(request))
271	inventoryItemInstanceList = result.inventoryItemList
272	inventoryItemInstanceTotal = result.inventoryItemList.totalCount
273	params.message = result.message
274	filterParams.quickSearch = result.quickSearch
275	// Remember search.
276	session.inventoryItemQuickSearch = result.quickSearch
277	if(result.daysBack)
278	session.inventoryItemQuickSearchDaysBack = result.daysBack
279	// Clear any previous search.
280	session.removeAttribute("inventoryItemSearchText")
281	session.removeAttribute("inventoryItemSearchName")
282	session.removeAttribute("inventoryItemSearchDescription")
283	session.removeAttribute("inventoryItemSearchComment")
284	session.removeAttribute("inventoryItemSearchLocation")
285	session.removeAttribute("inventoryItemSearchGroup")
286	session.removeAttribute("inventoryItemSearchSpareFor")
287	session.removeAttribute("inventoryItemSearchFilterParams")
288	session.removeAttribute("inventoryItemSearchFilter")
289	}
290
291	// export plugin:
292	if(params?.format && params.format != "html") {
293
294	def dateFmt = { date ->
295	formatDate(format: "EEE, dd-MMM-yyyy", date: date)
296	}
297
298	String title
299	if(params.quickSearch)
300	title = params.message
301	else
302	title = "Filtered Inventory List."
303
304	response.contentType = ConfigurationHolder.config.grails.mime.types[params.format]
305	response.setHeader("Content-disposition", "attachment; filename=Inventory.${params.extension}")
306	List fields = ["name",
307	"description",
308	"inventoryGroup",
309	"unitsInStock",
310	"reorderPoint",
311	"unitOfMeasure",
312	"inventoryLocation",
313	"inventoryLocation.inventoryStore"]
314	Map labels = ["name": "Name",
315	"description": "Description",
316	"inventoryGroup": "Group",
317	"unitsInStock":"In Stock",
318	"reorderPoint":"Reorder Point",
319	"unitOfMeasure": "UOM",
320	"inventoryLocation": "Location",
321	"inventoryLocation.inventoryStore": "Store"]
322
323	Map formatters = [:]
324	Map parameters = [title: title, separator: ","]
325
326	exportService.export(params.format,
327	response.outputStream,
328	inventoryItemInstanceList.sort { p1, p2 -> p1.name.compareToIgnoreCase(p2.name) },
329	fields,
330	labels,
331	formatters,
332	parameters)
333	}
334
335	// Add some basic params to filterParams.
336	filterParams.max = params.max
337	filterParams.offset = params.offset?.toInteger() ?: 0
338	filterParams.sort = params.sort ?: "name"
339	filterParams.order = params.order ?: "asc"
340
341	// Get some associatedProperty values for filterpane.
342	def associatedPropertyValues = [:]
343	def associatedPropertyMax = 10000
344	associatedPropertyValues.inventoryLocationList = InventoryLocation.findAllByIsActive(true, [max:associatedPropertyMax, sort:'name'])
345	associatedPropertyValues.assetList = Asset.findAllByIsActive(true, [max:associatedPropertyMax, sort:'name'])
346	associatedPropertyValues.supplierList = Supplier.findAllByIsActive(true, [max:associatedPropertyMax, sort:'name'])
347
348	return[ inventoryItemInstanceList: inventoryItemInstanceList,
349	inventoryItemInstanceTotal: inventoryItemInstanceTotal,
350	filterParams: filterParams,
351	params: params,
352	associatedPropertyValues: associatedPropertyValues ]
353	} // end search()
354
355	/**
356	* Simply assigns a passed in task id to a session variable and redirects to search.
357	*/
358	@Secured(['ROLE_AppAdmin', 'ROLE_Manager', 'ROLE_InventoryManager', 'ROLE_InventoryUser'])
359	def findInventoryItemForMovement = {
360	if(!params.task?.id) {
361	flash.message = "No task id supplied, please select a task then the inventory tab."
362	redirect(controller: "taskDetailed", action: "search")
363	return
364	}
365
366	session.inventoryMovementTaskId = params.task.id
367	flash.message = "Please find and then select the inventory item."
368	redirect(action: search)
369	}
370
371	@Secured(['ROLE_AppAdmin', 'ROLE_Manager', 'ROLE_InventoryManager', 'ROLE_InventoryUser'])
372	def show = {
373
374	// In the case of an actionSubmit button, rewrite action name from 'index'.
375	if(params._action_Show)
376	params.action='show'
377
378	def result = inventoryItemService.show(params)
379
380	if(!result.error) {
381
382	def model = [ inventoryItemInstance: result.inventoryItemInstance,
383	inventoryMovementList: result.inventoryMovementList,
384	inventoryMovementListTotal: result.inventoryMovementListTotal,
385	inventoryMovementListMax: result.inventoryMovementListMax,
386	inventoryItemPurchases: result.inventoryItemPurchases,
387	inventoryItemPurchasesTotal: result.inventoryItemPurchasesTotal,
388	showTab: result.showTab]
389
390	if(session.inventoryMovementTaskId) {
391	model.inventoryMovementInstance = new InventoryMovement()
392	model.inventoryMovementInstance.task = Task.get(session.inventoryMovementTaskId)
393	model.inventoryMovementInstance.quantity = 1
394	}
395
396	// Success.
397	return model
398	}
399
400	flash.errorMessage = g.message(code: result.error.code, args: result.error.args)
401	redirect(action:search)
402	}
403
404	def delete = {
405	def result = inventoryItemService.delete(params)
406
407	if(!result.error) {
408	flash.message = g.message(code: "default.delete.success", args: ["InventoryItem", params.id])
409	redirect(action:search)
410	return
411	}
412
413	flash.errorMessage = g.message(code: result.error.code, args: result.error.args)
414
415	if(result.error.code == "default.not.found") {
416	redirect(action:search)
417	return
418	}
419
420	redirect(action:show, id: params.id)
421	}
422
423	def edit = {
424
425	// In the case of an actionSubmit button, rewrite action name from 'index'.
426	if(params._action_Edit)
427	params.action='edit'
428
429	def result = inventoryItemService.edit(params)
430
431	if(!result.error) {
432	def possibleAlternateItems = inventoryItemService.getPossibleAlternateItems(result.inventoryItemInstance)
433	def suppliers = Supplier.findAllByIsActive(true).sort { p1, p2 -> p1.name.compareToIgnoreCase(p2.name) }
434
435	return [ inventoryItemInstance : result.inventoryItemInstance,
436	possibleAlternateItems: possibleAlternateItems,
437	suppliers: suppliers]
438	}
439
440	flash.errorMessage = g.message(code: result.error.code, args: result.error.args)
441	redirect(action:search)
442	}
443
444	def update = {
445	def result = inventoryItemService.update(params)
446
447	if(!result.error) {
448	flash.message = g.message(code: "default.update.success", args: ["InventoryItem", params.id])
449	redirect(action:show, id: params.id)
450	return
451	}
452
453	if(result.error.code == "default.not.found") {
454	flash.errorMessage = g.message(code: result.error.code, args: result.error.args)
455	redirect(action:search)
456	return
457	}
458
459	def possibleAlternateItems = inventoryItemService.getPossibleAlternateItems(result.inventoryItemInstance)
460	def suppliers = Supplier.findAllByIsActive(true).sort { p1, p2 -> p1.name.compareToIgnoreCase(p2.name) }
461	render(view:'edit', model:[inventoryItemInstance: result.inventoryItemInstance.attach(),
462	possibleAlternateItems: possibleAlternateItems,
463	suppliers: suppliers])
464	}
465
466	def create = {
467	def result = inventoryItemService.create(params)
468	def suppliers = Supplier.findAllByIsActive(true).sort { p1, p2 -> p1.name.compareToIgnoreCase(p2.name) }
469
470	if(!result.error)
471	return [inventoryItemInstance: result.inventoryItemInstance,
472	suppliers: suppliers]
473
474	//flash.errorMessage = g.message(code: result.error.code, args: result.error.args)
475	redirect(action: search)
476	}
477
478	def save = {
479	def result = inventoryItemService.save(params)
480
481	if(!result.error) {
482	flash.message = g.message(code: "default.create.success", args: ["InventoryItem", result.inventoryItemInstance.id])
483	redirect(action:show, id: result.inventoryItemInstance.id)
484	return
485	}
486
487	def suppliers = Supplier.findAllByIsActive(true).sort { p1, p2 -> p1.name.compareToIgnoreCase(p2.name) }
488
489	//flash.errorMessage = g.message(code: result.error.code, args: result.error.args)
490	render(view:'create', model:[inventoryItemInstance: result.inventoryItemInstance,
491	suppliers: suppliers])
492	}
493
494	/**
495	* Handles the use inventory item form submit in the show view.
496	*/
497	@Secured(['ROLE_AppAdmin', 'ROLE_Manager', 'ROLE_InventoryManager', 'ROLE_InventoryUser'])
498	def useInventoryItem = {
499
500	params.inventoryMovementType = InventoryMovementType.get(1) // Set type to "Used".
501	def result = inventoryMovementService.move(params)
502
503	if(!result.error) {
504	flash.message = "Inventory Movement for ${result.inventoryMovementInstance.inventoryItem.name.encodeAsHTML()} created."
505	session.inventoryMovementTaskId = null
506	redirect(controller: "taskDetailed",
507	action: "show",
508	id: result.taskId,
509	params: [showTab: "showInventoryTab"])
510	// Success.
511	return
512	}
513
514	// Prepare data for the show view.
515	def p = [:]
516	p.id = result.inventoryMovementInstance.inventoryItem?.id
517	def r = inventoryItemService.show(p)
518
519	// Render show view if data was successfully prepared.
520	if(!r.error) {
521	def model = [ inventoryItemInstance: r.inventoryItemInstance,
522	inventoryMovementList: r.inventoryMovementList,
523	inventoryMovementListTotal: r.inventoryMovementListTotal,
524	inventoryMovementListMax: r.inventoryMovementListMax,
525	inventoryItemPurchases: r.inventoryItemPurchases,
526	inventoryItemPurchasesTotal: r.inventoryItemPurchasesTotal,
527	showTab: r.showTab]
528
529	model.inventoryMovementInstance = result.inventoryMovementInstance // This will pass in the errors.
530
531	render(view: 'show', model: model)
532	return
533	}
534
535	// Could not prepare data for show view so doing the next best thing.
536	flash.errorMessage = g.message(code: r.error.code, args: r.error.args)
537	redirect(action:search)
538
539	} // useInventoryItem
540
541	/**
542	* Clear the use inventory item form in the show view.
543	* Accomplished by clearing the session variable and ajax.
544	*/
545	@Secured(['ROLE_AppAdmin', 'ROLE_Manager', 'ROLE_InventoryManager', 'ROLE_InventoryUser'])
546	def clearUseInventoryItem = {
547	session.inventoryMovementTaskId = null
548	render ''
549	}
550
551	/**
552	* Search for Inventory items that require reorder.
553	*/
554	@Secured(['ROLE_AppAdmin', 'ROLE_Manager', 'ROLE_InventoryManager'])
555	def reorder = {
556
557	// In the case of an actionSubmit button, rewrite action name from 'index'.
558	if(params._action_reorder)
559	params.action='reorder'
560
561	if(session.inventoryItemReorderSearchParamsMax)
562	params.max = session.inventoryItemReorderSearchParamsMax
563
564	def inventoryItemInstanceList = []
565	def inventoryItemInstanceTotal
566	def filterParams = params
567	def suppliers = Supplier.findAllByIsActive(true).sort { p1, p2 -> p1.name.compareToIgnoreCase(p2.name) }
568	def inventoryGroups = InventoryGroup.findAllByIsActive(true)
569
570	if(params.selectedGroups) {
571	if(params.selectedGroups instanceof String)
572	params.selectedGroups = [params.selectedGroups.toLong()]
573	else
574	params.selectedGroups = params.selectedGroups.collect { it.toLong() }
575	}
576	else
577	params.selectedGroups = []
578
579	// Restore search unless a new search is being requested.
580	if(!params.newSearch && !params.quickSearch) {
581	if(session.reorderSearchSelectedGroups) {
582	params.selectedGroups = session.reorderSearchSelectedGroups
583	params.selectedSupplier = session.reorderSearchSelectedSupplier
584	params.includeAlternateSuppliers = session.reorderSearchIncludeAlternateSuppliers
585	params.includeReorderListingDisabled = session.reorderSearchIncludeReorderListingDisabled
586	params.includeOnBackOrder = session.reorderSearchIncludeOnBackOrder
587	}
588	else if(session.inventoryItemReorderQuickSearch) {
589	params.quickSearch = session.inventoryItemReorderQuickSearch
590	if(session.inventoryItemReorderQuickSearchDaysBack)
591	params.daysBack = session.inventoryItemReorderQuickSearchDaysBack.toString()
592	}
593	}
594
595	// Remember sort if supplied, otherwise try to restore.
596	if(params.sort && params.order) {
597	session.inventoryItemReorderSearchSort = params.sort
598	session.inventoryItemReorderSearchOrder = params.order
599	}
600	else if(session.inventoryItemReorderSearchSort && session.inventoryItemReorderSearchOrder) {
601	params.sort = session.inventoryItemReorderSearchSort
602	params.order = session.inventoryItemReorderSearchOrder
603	}
604
605	if(params.quickSearch) {
606	// Quick Search Links:
607	if(!params.quickSearch) params.quickSearch = "inventoryBelowReorder"
608	def result = inventoryItemSearchService.getQuickSearch(params, RCU.getLocale(request))
609	inventoryItemInstanceList = result.inventoryItemList
610	inventoryItemInstanceTotal = result.inventoryItemList.totalCount
611	params.message = result.message
612	filterParams.quickSearch = result.quickSearch
613	// Remember search.
614	session.inventoryItemReorderQuickSearch = result.quickSearch
615	if(result.daysBack)
616	session.inventoryItemReorderQuickSearchDaysBack = result.daysBack
617	// Clear any previous search.
618	session.removeAttribute("reorderSearchSelectedGroups")
619	session.removeAttribute("reorderSearchSelectedSupplier")
620	session.removeAttribute("reorderSearchIncludeAlternateSuppliers")
621	session.removeAttribute("reorderSearchIncludeReorderListingDisabled")
622	session.removeAttribute("reorderSearchIncludeOnBackOrder")
623	}
624	else {
625	// Reorder Search:
626	def result = inventoryItemSearchService.getReorderSearch(params, RCU.getLocale(request))
627	inventoryItemInstanceList = result.inventoryItemList
628	inventoryItemInstanceTotal = result.inventoryItemList.totalCount
629	params.message = result.message
630	// Place limit search selects in filterParams for pagination.
631	if(params.selectedGroups) {
632	filterParams.selectedGroups = params.selectedGroups
633	filterParams.selectedSupplier = params.selectedSupplier
634	filterParams.includeAlternateSuppliers = params.includeAlternateSuppliers
635	filterParams.includeReorderListingDisabled = params.includeReorderListingDisabled
636	filterParams.includeOnBackOrder = params.includeOnBackOrder
637	}
638	// Remember search.
639	session.reorderSearchSelectedGroups = params.selectedGroups
640	session.reorderSearchSelectedSupplier = params.selectedSupplier
641	session.reorderSearchIncludeAlternateSuppliers = params.includeAlternateSuppliers
642	session.reorderSearchIncludeReorderListingDisabled = params.includeReorderListingDisabled
643	session.reorderSearchIncludeOnBackOrder = params.includeOnBackOrder
644	// Clear any previous search.
645	session.removeAttribute("inventoryItemReorderQuickSearch")
646	session.removeAttribute("inventoryItemReorderQuickSearchDaysBack")
647	}
648
649	// export plugin:
650	if(params?.format && params.format != "html") {
651
652	def dateFmt = { date ->
653	formatDate(format: "EEE, dd-MMM-yyyy", date: date)
654	}
655
656	String title
657	if(params.quickSearch)
658	title = params.message
659	else
660	title = "Filtered Inventory List."
661
662	response.contentType = ConfigurationHolder.config.grails.mime.types[params.format]
663	response.setHeader("Content-disposition", "attachment; filename=Inventory.${params.extension}")
664	List fields = ["name",
665	"description",
666	"inventoryGroup",
667	"unitsInStock",
668	"reorderPoint",
669	"unitOfMeasure",
670	"inventoryLocation",
671	"inventoryLocation.inventoryStore"]
672	Map labels = ["name": "Name",
673	"description": "Description",
674	"inventoryGroup": "Group",
675	"unitsInStock":"In Stock",
676	"reorderPoint":"Reorder Point",
677	"unitOfMeasure": "UOM",
678	"inventoryLocation": "Location",
679	"inventoryLocation.inventoryStore": "Store"]
680
681	Map formatters = [:]
682	Map parameters = [title: title, separator: ","]
683
684	exportService.export(params.format,
685	response.outputStream,
686	inventoryItemInstanceList.sort { p1, p2 -> p1.name.compareToIgnoreCase(p2.name) },
687	fields,
688	labels,
689	formatters,
690	parameters)
691	}
692
693	// Add some basic params to filterParams.
694	filterParams.max = params.max
695	filterParams.offset = params.offset?.toInteger() ?: 0
696	filterParams.sort = params.sort ?: "name"
697	filterParams.order = params.order ?: "asc"
698
699	return[ inventoryItemInstanceList: inventoryItemInstanceList,
700	inventoryItemInstanceTotal: inventoryItemInstanceTotal,
701	filterParams: filterParams,
702	params: params,
703	inventoryGroups: inventoryGroups,
704	suppliers: suppliers]
705	} // end reorder()
706
707	} // end of class

Note: See TracBrowser for help on using the repository browser.

Download in other formats: