ticket,summary,component,version,milestone,type,owner,status,created,_changetime,_description,_reporter
83,New reorder search view should limit back order to a month,gnuMims - application general,trunk,0.8 - Purchasing and Inventory Improvements,defect,,closed,2010-09-24T05:32:21+10:00,2010-09-24T20:18:53+10:00,The reorder search ignores items on back order which is great but anything that has been on back order for more than a month needs looking at again.,Gavin
85,Null pointer bug on inventory report,gnuMims - application general,trunk,0.8 - Purchasing and Inventory Improvements,defect,Gavin,closed,2010-10-09T13:59:57+10:00,2010-10-11T13:05:12+10:00,"Which report is it, Total Value (Overview) and Detailed Value.
",Gavin
98,"Annotation based security is easy to bypass by adding "".html' to the URL",gnuMims - application security,trunk,0.8 - Purchasing and Inventory Improvements,defect,Gavin,closed,2011-04-16T01:14:55+10:00,2011-04-16T01:23:32+10:00,"Upstream security issue, see: http://jira.grails.org/browse/GPACEGI-41
Recommended fix is to set Config.groovy:
grails.mime.file.extensions = false
This did not leave gnuMims completely open to the world since gnuMims was configured with pessimistic security. However a logged in user may access urls that they are not authorised to.",Gavin
105,InventoryItemPurchase's can't be deleted when order quantity = 0,gnuMims - application general,trunk,0.8 - Purchasing and Inventory Improvements,defect,,closed,2011-06-30T17:31:14+10:00,2012-07-19T13:38:26+10:00,"The rollback deletion is failing.
This is working perfectly when ordered quantity > 0 but fails (and allows the order to be deleted) when order quantity = 0.
{{{
java.lang.NullPointerException: Cannot get property 'id' on null object
at InventoryMovementService$_reverseMove_closure1.doCall(InventoryMovementService.groovy:20)
at $Proxy16.doInTransaction(Unknown Source)
at InventoryMovementService.reverseMove(InventoryMovementService.groovy:9)
at InventoryMovementService$reverseMove.call(Unknown Source)
at InventoryPurchaseService$_delete_closure5.doCall(InventoryPurchaseService.groovy:196)
at $Proxy16.doInTransaction(Unknown Source)
at InventoryPurchaseService.delete(InventoryPurchaseService.groovy:125)
at InventoryPurchaseService$delete.call(Unknown Source)
at InventoryItemPurchaseDetailedController$_closure5.doCall(InventoryItemPurchaseDetailedController.groovy:198)
}}}
",Gavin
24,Implement inventory movement.,gnuMims - application general,trunk,0.4 - Functionality and integration,enhancement,Gavin,closed,2009-10-27T14:22:16+10:00,2009-12-09T17:11:17+10:00,"So that Inventory Items may be easily checked out via the task inventory tab.
Movement logic is now possible but user interface still needs to be improved possibly using a webflow.
Turns out a webflow was not suitable due to the way search pane works.
Easy to create our own flow though.
Done in r223, r224, r225, r226.
A task is required for movement type ""Used"" but not for other movement types such as ""Correction"" and ""Purchase Received"".
Movement ""by current user"" should also be recorded.
Done in r217.",Gavin
44,Check for and correct to ${X.encodeAsHtml()} where required.,gnuMims - application security,trunk,0.5 - Functionality and Stability,defect,,closed,2009-11-28T12:33:05+10:00,2009-12-28T01:43:18+10:00,"Anywhere that user input is displayed in a page there is the opportunity for html (or worse javascript?) injection. Using ${X} directly renders the text so a user input of ""
nice | "" would change the layout of the page.
Find and correct all cases to ${X.encodeAsHtml()}.",Gavin
68,Feature request: Improve inventory searching,gnuMims - application general,trunk,0.7.1 - Feature Requests,enhancement,,closed,2010-05-28T17:20:43+10:00,2010-06-07T11:18:43+10:00,"The current advanced inventory search is good for getting very specific but is too complicated for general searching. A quick search with one or two input fields is badly needed.
The input text should be used to search:
* Part name
* Description
* Comment
* Location
* Asset
* !AssetSubItem",Gavin
84,Implement inital purchase order pdf's of inventory reorder and purchases search views.,gnuMims - application general,trunk,0.8 - Purchasing and Inventory Improvements,enhancement,,new,2010-09-24T20:35:55+10:00,2010-10-27T15:01:09+10:00,"The purchases pdf is essentially a purchase order since the supplier, this company (address etc) and items to be purchased are known.
The reorder view can be used to generate a ""Quote Request"" pdf.
These pdf's can be reused later when ticket #30 is implemented.",Gavin
96,Remove unused fields from InventoryItem,gnuMims - application general,trunk,0.8 - Purchasing and Inventory Improvements,enhancement,,closed,2010-11-24T15:39:23+10:00,2010-11-25T09:11:52+10:00,"All the manufacturer*, averageDeliveryTime and alternateItems fields are hardly used and can be removed.
The alternateItems may be removed as the inventory text search is now very good.
Data and fields can simply be dropped.
The spareFor will be retained for now.",Gavin
59,MaintenanceAction and TaskProcedure need more thought and polish,gnuMims - application general,trunk,0.9 - General Improvements,enhancement,,closed,2010-01-15T12:13:06+10:00,2011-04-15T22:38:16+10:00,Maintenance action should not have a step number since this is a procedure step number and can't be set when creating the action from the asset perspective.,Gavin
88,Implement Regulatory Task Completion on Equipmet Register Report OH&S,gnuMims - application general,trunk,0.9 - General Improvements,enhancement,,reopened,2010-10-27T15:45:39+10:00,2010-11-24T15:41:35+10:00,"Regulatory Task Completion needs to be reported for assets that have regulatory requirements.
* This may require a new flag on the asset, also see ticket #22.
* There is a text extended attribute that should be retained.
* Result example: 50% (5/10)
* A date range will now also be required for this report.",Gavin
93,Upgrade to Grails-1.3.7 framework,gnuMims - application general,trunk,0.9 - General Improvements,enhancement,,closed,2010-11-16T10:25:27+10:00,2011-05-01T15:22:53+10:00,"Test thoroughly and upgrade.
Grails-1.3.5 has a bug where the dev war is not generated correctly, this is a blocker for us and we must wait for Grails-1.3.6 to be released.
Grails-1.3.7 now available so going to that.
Checking versions and bug reports in plugins:
* http://jira.grails.org/browse/GPFILTERPANE-5 confirmed as mostly solved in gnuMims (between 2nd date still not).
* http://jira.grails.org/browse/GPACEGI-41 work around applied r887. A Geb regression test might be smart.
Functionality:
* List paginate, sort and max results per page working.
* Reports all working in grails runApp.
* All tests passing.
Issues:
* Reports !JasperController class not found exception for commons-digester (deployed war), fixed in r903
* Need to check all dependencies, fixed in r902 - r906.
* Export plugin is having some issues, fixed in r911.
Schema upgrade:
* alter table image add constraint UN_pictureid_size unique (picture_id, size);",Gavin
15,Implement the Inventory domain,gnuMims - application general,trunk,,enhancement,Gavin,closed,2009-04-10T18:12:06+10:00,2009-05-04T01:07:56+10:00,Improve the ERD design and implement the Inventory domain.,Gavin
16,Implement the Asset domain,gnuMims - application general,trunk,,enhancement,Gavin,closed,2009-04-16T17:13:35+10:00,2009-05-04T01:08:35+10:00,Improve the ERD design and implement the Asset domain. ,Gavin
1,TaskRewrite,gnuMims - application general,,,task,Gavin,closed,2009-03-21T07:24:44+10:00,2009-03-26T23:02:53+10:00,Rewrite the Task domain under /branches/TaskRewrite.,Gavin
2,"Setup Trac, Http access to svn and multiuser ssh access to svn.",Tserver - server admin,,,task,Gavin,closed,2009-03-21T16:54:28+10:00,2009-03-21T16:55:07+10:00,"Done, see wiki for usage.",Gavin
3,"Install tserver, apache, subversion, grails, tomcat5.5, java sdk, 22Jan2009.",Tserver - server admin,,,task,Gavin + Steven,closed,2009-03-22T21:22:21+10:00,2009-03-22T21:45:39+10:00,,Gavin
4,"Create home page for website with CSS layout, 23Jan2009.",Tserver - server admin,,,task,Gavin + Steven,closed,2009-03-22T21:37:41+10:00,2009-03-22T21:46:00+10:00,,Gavin
5,"Setup tomcat5.5 with index.html and deployed app, 25Jan2009.",Tserver - server admin,,,task,Steven,closed,2009-03-22T21:38:45+10:00,2009-03-22T21:42:28+10:00,,Gavin
6,"Deploy gnuMims latest checkout to tomcat. Adjust index.html. Add contact.html, 26Jan2009",Tserver - server admin,,,task,Gavin,closed,2009-03-22T21:40:03+10:00,2009-03-22T21:48:43+10:00,,Gavin
7,Update gnumims.org to include Services and Community links.,gnuMimsOrg - website,,,task,Gavin,closed,2009-03-22T22:59:02+10:00,2009-03-23T01:43:57+10:00,Also update index content.,Gavin
9,Check and set Tserver hardware clock.,Tserver - server admin,,,task,Gavin,closed,2009-03-23T04:50:30+10:00,2009-03-26T22:59:27+10:00,"The command hwclock is not working, so needs to be set via the bios.",Gavin
14,"Tserver scripting, post-commit hooks, dist-upgade, groups and democo.gnumims.com",Tserver - server admin,,,task,,closed,2009-04-08T11:13:50+10:00,2009-04-09T16:30:14+10:00," * Tserver has been upgraded to Lenny and all that goes with that.
* There are now post-commit hooks on /svnrepos/gnumims and /svnrepos/gnumimswebsite. The www.gnumims.org website is automagically updated on commit and the autobuilder user builds gnuMims.war on commit to that.
* The appropriate system groups are required for the obviously associated actions 'ssh', 'gnumimscommit', 'gnumimswebcommit'.
* Super and sudo are used for some scripts in /root/scripto/
* gnumimsappupdate.sh - do 'super gnumimsappupdate' to update the demo with the auto built war
* gnumimswebsiteupdate.sh - automatically called by commiting to svnrepo/gnumimswebsite uses super.
* gnumimsautobuild.sh - automatically called by commiting to svnrepo/gnumims builds the war on commit uses sudo.
* Common user 'svnuser' has been created for svn+ssh access.
* Apache setup has been massaged for new domain democo.gnumims.com",Gavin
17,"Https(ssl), phpmyadmin and split apache2 sites-available into seperate files",Tserver - server admin,,,task,,closed,2009-04-29T15:52:12+10:00,2009-04-29T15:52:41+10:00,Sites can now be enabled/disabled individually thanks to split config files. Https is now available on port 7443. All requests to /phpmyadmin are redirected to https.,Gavin
20,"Create new SVN repo, touchcodepos-test, to hold application tests.",Tserver - server admin,,,task,,closed,2009-06-22T20:57:56+10:00,2009-06-22T21:05:57+10:00,,Gavin
21,"Change ""Assinged to"" in trac tickets into a drop down list",Tserver - server admin,,,task,Gavin,closed,2009-06-24T16:11:27+10:00,2009-06-24T16:12:13+10:00,"Change in all running trac instances.[[BR]]
Set ""restrict_owner = true"". [[BR]]
Then remove un-needed users: ""sqlite3 trac.db""[[BR]]
delete from session where sid = 'userName';[[BR]]
",Gavin
18,"Implement item search page for Task, Inventory and Asset menu dropdowns.",gnuMims - application general,trunk,0.3 - Asset management,task,,closed,2009-05-27T14:31:14+10:00,2009-10-21T17:30:02+10:00,"Each page will have Quick and Advanced.
Quick will have pre-prepared links (Quick Links), the search criteria is mostly hardcoded and simply returns the results in a table view or has a page/requires minimal input like date range.
Example: Tasks where I am lead person, Tasks entered today.
Advanced will have all possible, applicable fields.",Gavin
12,After an update or save sometimes old/stale data/vaules are shown,gnuMims - application general,trunk,0.4 - Functionality and integration,defect,Gavin,closed,2009-04-01T05:10:05+10:00,2009-11-02T15:32:16+10:00,"A browser refresh causes the new data to be shown, so the data is persisted but just not fetched in time to show updated values after redirect.
This is not due to query caching, as previously believed. (Higher level caching is on in the global config but still needs to be turned on for each case where it is wanted).
The solution is to add flush:true to save(), implemented in r178 as per http://jira.codehaus.org/browse/GRAILS-5111",Gavin
13,Implement audit/changelog using TaskModifications domain,gnuMims - application general,trunk,0.4 - Functionality and integration,enhancement,Gavin,closed,2009-04-01T05:12:26+10:00,2009-11-19T21:00:08+10:00," * At least the created modification needs to be implemented and added to the show task view.
* This link may be some help:
http://hartsock.blogspot.com/2008/04/inside-hibernate-events-and-audit.html
As of r180 the following task modifications are now recorded:
* Created
* Started
* Modified
* Completed
* Reopened
* Trashed
* Restored
* Approved
* Renege approval
Complete as of r190.",Gavin
25,Complete recurring task implementation with quartz,gnuMims - application general,trunk,0.4 - Functionality and integration,enhancement,Gavin,closed,2009-10-27T14:24:42+10:00,2009-12-16T12:23:18+10:00,"The core classes and services have been implemented.
Some logic, refactoring, help and testing required.
Done, see r199 through r213.",Gavin
47,Filterpane bug when selecting an operator but not inputting a value for ID and Integer attributes,gnuMims - application general,trunk,0.5 - Functionality and Stability,defect,,closed,2009-12-01T20:43:41+10:00,2010-02-17T16:46:55+10:00,"See bug in grails plugin filterpane:
http://jira.codehaus.org/browse/GRAILSPLUGINS-1717
This upstream bug report has been closed and is due for inclusion in filterpane-0.6.5 which has not been released yet.
Contributed a further improvement (grails plugin rev 59495) so that user input parsing is done in a type safe way. This is now fixed in grails-filterpane-0.6.6-SNAPSHOT
Fixed at r361 by upgrading plugin to the newly release 0.6.6-SNAPSHOT.",Gavin
64,Task search returns duplicate records during pagination in some circumstances,gnuMims - application general,trunk,0.5 - Functionality and Stability,defect,Gavin,closed,2010-04-28T22:47:16+10:00,2010-05-06T17:24:00+10:00,"This only occurs with the following conditions:
1. When not using MySQL or HSQL (i.e. using MSSQL)
1. When hibernate criteria builder is in use.
1. When sorting by the attentionFlag column.
The filterPane plugin and some of the quick searches were using the criteria builder.",Gavin
26,Implement Pictures for inventory items.,gnuMims - application general,trunk,0.5 - Functionality and Stability,enhancement,,closed,2009-10-27T16:21:28+10:00,2009-11-10T17:56:48+10:00,Implemented in at r182,Gavin
35,Adding or removing assigned groups should trigger a modification to be recorded.,gnuMims - application general,trunk,0.5 - Functionality and Stability,enhancement,Gavin,closed,2009-11-17T09:42:25+10:00,2009-12-28T01:14:00+10:00,"A task modification should be recorded for the above.
Implemented in r247, r248, r249 and r251.",Gavin
36,Store configuration settings in database,gnuMims - application general,trunk,0.5 - Functionality and Stability,enhancement,Gavin,closed,2009-11-17T09:54:24+10:00,2009-12-22T13:53:38+10:00,"Create a new !AppConfig class. [[BR]]
The system can record events and configuration settings in this class.
e.g:
{{{
Class AppConfig {
String name
String value
}
}}}
This will be used for recording:
* Base data created, then can be tested to disable double creation.
* Demo data created, then can be tested to disable double creation.
* Date formats.
* and other configuration settings.",Gavin
37,Task should have assigned groups along side assigned persons,gnuMims - application general,trunk,0.5 - Functionality and Stability,enhancement,Gavin,closed,2009-11-17T15:50:31+10:00,2009-12-24T13:45:50+10:00," * Many assignedGroups may be added to a task.
* Many assignedPersons may be added to a task.
* A persons tasks would be every task that they are assigned to and every task that any group that they belong to is assigned to and every task where they are lead person.
* Record changes to assigned groups as modifications see ticjet #35
* Allow a targetStartDate for the assigned group? No this would then be better as a sub task.
* The person groups now have the added benefit of acting as a training/qualification record. Since only persons trained/qualified to be in the group are added to that group.
Implemented in r239, r240, r241, r242, r243, r245.",Gavin
49,Budget status for Tasks,gnuMims - application general,trunk,0.5 - Functionality and Stability,enhancement,,closed,2009-12-18T14:33:42+10:00,2009-12-28T05:01:57+10:00," * Please consider adding budget status to tasks.
* Currently only 2 states but may be more possible.
* Budget plannned and budget unplanned.",Gavin
50,New report or view: Inventory Below Reorder,gnuMims - application general,trunk,0.5 - Functionality and Stability,enhancement,,closed,2009-12-18T14:40:25+10:00,2010-04-13T13:29:26+10:00,"We need a quick way to find, present and print/output all inventory items below reorder point.
Fields:
* Item, Location, last movement, last ordered, quantity in stock, buget info (last used budget category).",Gavin
51,New report or view: Inventory Recently Used,gnuMims - application general,trunk,0.5 - Functionality and Stability,enhancement,,closed,2009-12-18T14:43:00+10:00,2010-05-19T14:11:36+10:00,"We need a quick way to find, present and print/output all inventory items that have been recently used.
Fields:
* Item, Location, last movement, quantity in stock, unit of measure.",Gavin
53,New report or view: Breakdown KPI stats per asset,gnuMims - application general,trunk,0.5 - Functionality and Stability,enhancement,,closed,2009-12-22T14:05:00+10:00,2010-05-28T14:14:43+10:00,"A good key performance indicator (KPI) is the Immediate Callout (breakdown) tasks completed and the associated hours per asset.
Fields:
Asset, !NumberOfBreakdowns(Used to calculate Reliability), !DownTime(Availability).",Gavin
54,New report or view: Breakdown vs Scheduled task ratio,gnuMims - application general,trunk,0.5 - Functionality and Stability,enhancement,,closed,2009-12-22T14:07:53+10:00,2010-05-19T14:15:59+10:00,A good key performance indicator (KPI) is the ratio of completed breakdown vs scheduled tasks.,Gavin
55,Assigned groups and persons should be copied to auto generated sub tasks.,gnuMims - application general,trunk,0.5 - Functionality and Stability,enhancement,Gavin,closed,2009-12-22T17:50:20+10:00,2009-12-24T10:25:02+10:00,Implemented in r243.,Gavin
62,New report or view: Persons total work done hours,gnuMims - application general,trunk,0.5 - Functionality and Stability,enhancement,,closed,2010-03-27T03:36:12+10:00,2010-05-19T14:13:47+10:00,,Gavin
8,Website css needs updating to match application.,gnuMimsOrg - website,,0.5 - Functionality and Stability,task,,closed,2009-03-23T01:46:21+10:00,2009-12-18T17:14:32+10:00,Also add a mailto:contact@gnumims.com link to the footer of each page.,Gavin
63,Upgrade to Grails-1.2.2,gnuMims - application general,trunk,0.5 - Functionality and Stability,task,Gavin,closed,2010-03-27T03:39:05+10:00,2010-03-27T03:39:19+10:00,"Improved stability, speed, dev options GRAILS_OPTS (JAVA_OPTS) and bug fixes and latest plugins.",Gavin
57,Better determine the use of task scheduled and approved features,gnuMims - application general,trunk,0.7 - Deployment preparation,enhancement,,closed,2009-12-24T13:43:12+10:00,2010-06-07T11:14:56+10:00,"Scheduled currently does not do very much but is passed on to sub tasks from recurring parent tasks.
Approved can be set and cleared by the approve and renegeApproval actions. A modification is recored.
The scheduled flag has been removed in r567",Gavin
65,Feature request: Adjust Task Groups,gnuMims - application general,trunk,0.7.1 - Feature Requests,enhancement,,closed,2010-05-28T16:59:00+10:00,2010-06-09T11:44:47+10:00,"To assist filtering during planning.
Instead of simply ""Engineering Activities"", this group could be split up into:
* Electrical Dayshift
* Electrical Nightshift
* Mechanical Dayshift
* Mechanical Nightshift
Existing databases could be updated by an SQL query searching for assingedGroups. Additional shifts could be easily added (e.g 3 shift pattern).
Also if the Task Group and Asset fit on the current Task Search view, or a new view. A planning view that also displays the assignedGroups would also make planning easier.",Gavin
70,Feature request: Add a 'safetyRequirement' and 'mandatoryRegulatory' and 'positiveFault' flags to Task.,gnuMims - application general,trunk,0.7.1 - Feature Requests,enhancement,,closed,2010-05-31T10:22:22+10:00,2010-06-10T12:11:31+10:00,,Gavin
76,Inventory text search stops working sometimes with: Failed to rename index,gnuMims - application general,trunk,0.8 - Purchasing and Inventory Improvements,defect,Gavin,closed,2010-06-28T19:16:43+10:00,2010-07-11T00:30:50+10:00,"Strace: [[BR]]
{{{
org.compass.core.engine.SearchEngineException: Failed to rename index
}}}
This appears to be a Compass issue when the quartz scheduled (hourly) reindex job fires shortly after or while the searchable plugin has cause an index, probably after a user updated a searchable domain object.
Sometimes after a few hours the quartz scheduled rebuild completes successfully but not always.
Problem reported on the internet: [[BR]]
http://markmail.org/message/noaskbbknl3wvwkw [[BR]]
http://issues.compass-project.org/browse/CMP-677 [[BR]]
http://forum.compass-project.org/thread.jspa?threadID=215487&start=0&tstart=0 [[BR]]
Reported to upstream by us: [[BR]]
https://cvs.codehaus.org/browse/GRAILSPLUGINS-2274
Simply using index() instead of reindex() seems to prevent this bug,
gnuMims will also shift to using afterUpdate in appropriate domain classes to fire the quartz index job.",Gavin
91,Purchasing - run order price update when invoice is updated.,gnuMims - application general,trunk,0.8 - Purchasing and Inventory Improvements,defect,,closed,2010-10-27T17:06:36+10:00,2010-11-24T12:58:21+10:00,"The order price is updated when the invoice is created, please ensure this logic also runs when an existing invoice is updated.",Gavin
30,Implement purchase orders,gnuMims - application general,trunk,0.8 - Purchasing and Inventory Improvements,enhancement,,new,2009-11-11T20:42:44+10:00,2009-12-18T15:13:19+10:00,"Each purchase order can only be made out to a single supplier so this could be linked to from inventory items with a 'puchase from this supplier' link. This would then start a purchase order.
On receipt of items they should be easily credited into inventory with automatic creation of inventory movements and a payment approved action is required.
Purchase order events:
* Ordered.
* Received partial.
* Received complete.
* Invoice approved (approved for payment, auto on received complete?)
* Payment made.
Purchase order numbers are supplied in batches eg P10001 - P20000 an interface and logic is required to handle this.
{{{
class PurchaseOrder {
PurchaseOrderNumber purchaseOrderNumber
Integer estimatedTotal
hasMany = [purchaseOrderLineItems: PurchaseOrderLineItem]
}
class PurchaseOrderNumber {
PurcaseOrder purchaseOrder
String value
}
class PurchaseOrderLineItem {
InventoryItem inventoryItem
CostCentre(Department.costCode+SystemSection.costCode?)
CostCode from asset type or asset.
}
}}}",Gavin
39,CostCodes need to have persons authorised to use them,gnuMims - application general,trunk,0.8 - Purchasing and Inventory Improvements,enhancement,,closed,2009-11-24T15:11:47+10:00,2010-07-25T08:29:12+10:00,Each cost code or person needs a relationship and way to authorise management and purchase on that cost code (budget or ledger account).,Gavin
42,Work flow for sharing task numbers,gnuMims - application general,trunk,0.8 - Purchasing and Inventory Improvements,enhancement,,closed,2009-11-24T15:33:23+10:00,2011-02-28T21:57:03+10:00,"With the concept of the maintenance technician entering the task and the production person entering the ""fault entry"" against that task there needs to be a clear work flow for sharing these task numbers.
One way to do this would be to reserve a number of tasks (say 5) for a technician and provide a report with the task numbers and space to write down the details. The technician could then print the report and hand the reserved numbers out to production as work comes up. Using the printed report to record the details in the space provided for later entering the ""work done"" into the task number. The production person would then have a task number to enter their ""fault entry"" against at any time they wish.
Another way to do this would be to make it very easy for the production person to list the ""Immediate Callouts"" for period and production reference. As these would be the only tasks to which this applies. They would then enter faults against these tasks. The constraint on this would be that all tasks must be entered (with descriptions) before the production person came around to wanting to enter their ""fault entries"" to produce their production report.
Some CMMS systems require the production person to create the task or work order and provide this number to the technician. This often fails since:
1. Production personnel don't know the correct asset names, technician or planner then often has to correct or adjust the task details.
1. The production person's world is often a busy one where taking time to enter a fault before calling a technician is simply not possible.
1. The technician should be providing a service to the customer.
* Note: This does not apply to ""Work Requests"" of a low priority where the production person may want to enter the faults or work requests at their leasure, this functionality should still be available.
For production report see ticket #41.",Gavin
71,Remember inventoryItemPurchase search and sort.,gnuMims - application general,trunk,0.8 - Purchasing and Inventory Improvements,enhancement,,closed,2010-06-10T16:50:51+10:00,2010-06-11T08:49:25+10:00,,Gavin
74,InventoryItemPurchase requires unique constraint on purchaseOrderNumber for an InventoryItem,gnuMims - application general,trunk,0.8 - Purchasing and Inventory Improvements,enhancement,,closed,2010-06-18T11:26:47+10:00,2010-06-18T17:01:30+10:00,With the current logic a puchaseOrderNumber may only be used once per inventoryItem. A custom contraint is required to ensure this.,Gavin
75,TODO: rename InventoryItem property 'enableReorder' to 'enableReorderListing',gnuMims - application general,trunk,0.8 - Purchasing and Inventory Improvements,enhancement,,closed,2010-06-22T19:18:05+10:00,2010-06-28T03:00:16+10:00,,Gavin
77,Secure cost codes,gnuMims - application general,trunk,0.8 - Purchasing and Inventory Improvements,enhancement,,closed,2010-07-11T00:30:05+10:00,2010-07-14T14:25:45+10:00,Only the Business Manager may edit and create !CostCode's.,Gavin
86,View required to show total hours scheduled for a date.,gnuMims - application general,trunk,0.8 - Purchasing and Inventory Improvements,enhancement,,closed,2010-10-22T10:35:18+10:00,2010-11-02T09:56:21+10:00,"Using something similar to the work done view. Add Group selection and total hours between target start and target completion date for tasks ""not started"" and ""in progress""",Gavin
87,"Implement ""Order on Hold"" feature on reorder search view.",gnuMims - application general,trunk,0.8 - Purchasing and Inventory Improvements,enhancement,,new,2010-10-27T15:09:27+10:00,2010-10-27T15:09:27+10:00,This allows a purchaser to mark items on reorder list as orderOnHold=true to indicate that this item should not be reordered at this time. The quote request pdf would also not show these items. The only audit requirement at this stage is a person and date stamp.,Gavin
90,Inventory items - recommended reorder,gnuMims - application general,trunk,0.8 - Purchasing and Inventory Improvements,enhancement,,closed,2010-10-27T16:47:54+10:00,2010-11-23T08:18:27+10:00,recommendedReorderPoint is not used and can be renamed to reorderQuantity.,Gavin
97,Drop the entire Manufacturer domain concept,gnuMims - application general,trunk,0.8 - Purchasing and Inventory Improvements,enhancement,,closed,2010-11-25T09:11:22+10:00,2010-11-25T12:08:55+10:00,"Following on from ticket #96, the entire Manufacturer domain class is hardly used and can be removed.",Gavin
106,PM Entry time not being counted in Reactive Ratio report,gnuMims - application general,trunk,0.9 - General Improvements,defect,Gavin,new,2014-06-23T18:48:19+10:00,2014-06-23T18:48:19+10:00,On task with a procedure the PM Entry time is not being counted on the Reactive Ration report.,Ross Challinor
66,Feature request: Calendar view to shown assignedGroup totals,gnuMims - application general,trunk,0.9 - General Improvements,enhancement,,new,2010-05-28T17:08:43+10:00,2010-10-27T15:26:20+10:00,"Currently the task calendar view is not particularly useful due to the shear number of tasks on each day. Even with filtering showing the tasks on the calendar actually provides less information than the list view.
However displaying the assignedGroup and perhaps assignedPerson hh:mm totals on the calendar may prove very usefull.",Gavin
81,Inventory unit price selection requirments need to include kg,gnuMims - application general,trunk,0.9 - General Improvements,enhancement,,closed,2010-07-28T14:01:59+10:00,2010-08-01T20:53:53+10:00,,Ray Smith
82,Ability to select task assets from asset tree,gnuMims - application general,trunk,0.9 - General Improvements,enhancement,,new,2010-08-01T21:06:40+10:00,2010-08-01T21:06:40+10:00,,Gavin
92,Working Shift feature required,gnuMims - application general,trunk,0.9 - General Improvements,enhancement,,new,2010-10-28T14:17:18+10:00,2010-10-28T14:23:35+10:00,"Currently the taskGroup is used as ""Electrical Dayshift"", ""Electrical Nightshift"". This should factored out into a WorkingShift table and a task.workingshift field should then be used for this assignment.
When a person logs in they should be able to select their current shift and see only those logs.
{{{
class WorkingShift {
@indexed // Is auto indexing available?
String ref // A constant used for lookup, e.g: dayshift.
String name // Language free, e.g: Dayshift, Nightshift.
String description = """"
Integer startHour = 0 //24hr format, e.g:06
Integer startMinute = 0 //24hr format
Integer finishHour = 0 //24hr format, e.g:18
Integer finishMinute = 0 //24hr format
Integer startFinishMarginHour = 2 //margin in hours.
}
}}}",Gavin
95,New yellow pendingResolution flag on Tasks,gnuMims - application general,trunk,0.9 - General Improvements,enhancement,,new,2010-11-18T16:32:07+10:00,2010-11-23T08:07:25+10:00,"Currently a red flag is used for attentionFlag, a yellow attention read/noted/hold flag would be nice too. Or another group to put holding flags in.
New modifications will also be required.
New dynamic task search ""New Flag's"" and ""Pending Resolution""
Secondly require a work done entry when clearing flags.",Gavin
102,"Security regression tests for bypass by adding "".html' to the URL",gnuMims - application security,trunk,0.9 - General Improvements,enhancement,,new,2011-05-02T07:19:14+10:00,2011-05-02T07:20:57+10:00,"Add regression functional tests as per ticket #98 and r888.
These include testing GET url's which the logged in user should not have access to, by appending to the url ('index.', 'index.html', 'index.xml', 'index..', 'index.gsp', 'index/index' etc).",Gavin
79,Reminder: Test CSV import functions and stop/start searchable index,gnuMims - application general,trunk,0.x - Future,defect,,new,2010-07-14T15:45:17+10:00,2010-11-25T14:11:10+10:00,"Several changes have happened in the last few milestones that may require small adjustments to the CSV import functions. There is also a new CSV grails plugin that may be of interest. Tests should be written if possible.
Inventory import function improved in r721 - turn off searchable index mirroring during import and manually tested.",Gavin
29,Pictures for online demo and when running in dev mode,gnuMims - application general,trunk,0.x - Future,enhancement,,closed,2009-11-11T20:34:42+10:00,2010-07-10T23:10:42+10:00,WebAlbum does this so look for example there.,Gavin
32,Show only the non-detailed controllers in 'admin' view,gnuMims - application general,trunk,0.x - Future,enhancement,,new,2009-11-11T20:58:31+10:00,2009-12-16T12:12:34+10:00,Should be able to use the grep taglib or a controller regex to do this.,Gavin
33,Fault entries and work requests.,gnuMims - application general,trunk,0.x - Future,enhancement,,new,2009-11-17T09:07:30+10:00,2010-11-24T15:10:15+10:00," * Fault entries are basic entries from the customer reporting a fault.
* This fault or work request would be non-critical otherwise a callout would have occurred instead.
* One way to do this would be to have a standing task that fault reports can be made against. These could then be moved to an appropriate task or a new task created for the fault.
* A better way is to create a task when the fault is entered and populate the task description either from an entry field or the fault.",Gavin
34,Task overdue/warning flag,gnuMims - application general,,0.x - Future,enhancement,,new,2009-11-17T09:30:59+10:00,2010-10-27T15:35:48+10:00,"Concept idea: overdue/warning flag for tasks that are overdue by priority and target start date. This flag should be automatically set by the system.
* Target dates are targetStart and targetCompletion.
* !TaskPriority#overdueIn may be 1=24hr, 2=48hr, 3=72hr (3 shifts), 4=none.
* See also ticket #22 for priority sourced from the primaryAsset.
",Gavin
38,A way to assess and record the condition severity of an asset when performing a preventative maintenance task,gnuMims - application general,trunk,0.x - Future,enhancement,,closed,2009-11-23T16:39:49+10:00,2011-04-16T04:44:25+10:00,"When performing a preventative maintenance task that has a procedure, it would be nice to be able to record the assessed condition of the asset/assembly/component specified in each maintenance action.
In the current configuration a task is the smallest unit that can hold this information.
{{{
class ConditionSeverity {
String code
String recommendation
}
}}}
Base data:
{{{
Code-Recommendation
A - Normal Monitoring
B - Increase Monitoring
C - Replace 2-6 weeks
D - Replace 1-2 weeks
}}}
Possibly a 'recorded condition' domain class could be created and used:
{{{
class ConditionRecord {
MaintenanceAction maintenanceAction
Date dateRecorded
ConditionSeverity conditionSeverity
}
}}}
Recording the condition of each maintenanceAction in the database has been decided against, for now, in favour of recording the worst condition severity against the task. Printing the taskProcedure out and keeping the paper copy will suffice as report and audit trail is supplied by !TaskProcedureRevisions.
'Work Performed', 'Part Changed' and 'Part Repaired' are separate conditions that will be indicated by an inventory item used on the task.
",Gavin
40,Feature to assemble a 'work order' from task,gnuMims - application general,trunk,0.x - Future,enhancement,,new,2009-11-24T15:15:22+10:00,2009-12-18T14:52:53+10:00,"Tasks are great but some work flows are based around work orders.
An pdf button that creates a work order from the task, procedure and sub tasks would be nice to have.",Gavin
41,Production report from fault entries,gnuMims - application general,trunk,0.x - Future,enhancement,,new,2009-11-24T15:33:09+10:00,2011-02-28T21:16:55+10:00,"If a production person entered faults against tasks then these faults could be assembled into a production report simply all tasks with ""Immediate Callout"" and that production reference would be the production report for that production.",Gavin
43,Base type domain classes should have caching enabled,gnuMims - application general,trunk,0.x - Future,enhancement,,new,2009-11-28T11:07:16+10:00,2009-12-18T14:55:07+10:00,"The '*Type' classes that don't change often should have caching enabled to improve performance.
* Period
* !TaskType
* etc
To turn on hibernate second level caching for these classes do something like:
{{{
static mapping = {
cache true
}
or limit caching to non-lazy:
cache usage:'read-write', include:'non-lazy'
}}}
",Gavin
46,Reminder: Check for optimistic locking in edit views,gnuMims - application general,trunk,0.x - Future,enhancement,,new,2009-12-01T01:17:31+10:00,2010-11-24T15:23:33+10:00,Check and ensure that optimistic locking is in the edit views and that it is working.,Gavin
56,An improved way to assign a parent to an existing task is required,gnuMims - application general,trunk,0.x - Future,enhancement,,new,2009-12-24T13:21:35+10:00,2009-12-24T13:58:21+10:00,"Removed/commented out the ability to change the parent task in r246, since this currently just lists all tasks and becomes very slow with larger task numbers.
The ability to assign a parent to an existing task may not be immediately required but certainly would be good to have.
At the very least the !TaskService.possibleParentList needs to be smarter and not return ALL tasks.",Gavin
60,Make the asset tree more flexible by changing Section to self referencing,gnuMims - application general,trunk,0.x - Future,enhancement,,new,2010-03-16T22:28:56+10:00,2010-03-17T09:53:15+10:00,"This is a very good idea and would make the asset tree depth that extra bit more flexible. This could be setup similar to the way an Asset can have as many depths of Sub Items as required.
Example:
* Company
* Region
* Site
* Section
Company and Region are currently not catered for, while Section already has a Department.
This affects:
* Database schema.
* Asset tree taglib as accessed from the tree icon on the main nav.
* The asset tree import and export functions.
* Cascase deletion and updates.
Hence placing in future milestone for now.",Gavin
89,Contractor management,gnuMims - application general,trunk,0.x - Future,enhancement,,new,2010-10-27T15:55:05+10:00,2010-10-27T15:55:54+10:00,There is a Service inventory type and supplier (new service type for supplier?). Service info pack could be added/linked to one of these. The pack would contain audit info on inductions and insurance expiry dates. This info would be used to raise an overdue warning.,Gavin
94,Inventory item audit with expiry,gnuMims - application general,trunk,0.x - Future,enhancement,,new,2010-11-16T13:22:45+10:00,2010-11-16T13:22:45+10:00,"To update inventory item data (e.g. recommended reorder levels).
Currently a continuous cycle of review is used for any inventory item that is accessed.
This could be improved by implementing an Inventory audit with expiry feature. This is most valuable when the reordering is done by administration staff.",Gavin
103,Labour Utilisation reports,gnuMims - application general,trunk,0.x - Future,enhancement,,new,2011-06-30T16:19:22+10:00,2011-06-30T16:19:22+10:00,"Labour Utilisation is very useful management information.
* A report similar to the Reactive Ratio report layout with blue in place of the amber wedge for Non Preventative.
* A report similar to the Reactive Ratio report layout with total Labour Utilisation = Preventative + Scheduled + Unschedulded + Immediate + Project + '''Unused'''",Gavin
19,Investigate CI and testing frameworks,Tserver - server admin,trunk,0.x - Future,task,,new,2009-05-27T15:02:05+10:00,2011-04-06T03:54:44+10:00,"Find, analyse and start to implement a testing framework.
We currently have a script based continuous build on svn commit (this was disabled due to VPS load). The build is now manually triggered using the same scripts.
Try trac-bitten CI as it is now in Debian Squeeze.
http://bitten.edgewall.org/wiki/Documentation/install.html",Steven
58,Reminder: check for and correct to ${X.encodeAsHtml()} where required.,gnuMims - application general,trunk,0.x - Future,task,,new,2009-12-28T01:39:42+10:00,2009-12-28T01:39:42+10:00,"This is a reminder for the original ticket #44.
This reminder is to ensure ongoing vigilance in this area.",Gavin
11,Implement home page view and navigation,gnuMims - application general,trunk,0.3 - Asset management,task,Gavin,closed,2009-03-29T22:17:09+10:00,2009-10-21T17:17:56+10:00,"Implement navigation menus for ""Tasks"", ""Inventory"", ""Assets"" etc
For example ""Tasks"" menu item could have Search, New, Today etc.",Gavin
10,"Beware that unix command names are all lower case ""gnumims"" not ""gnuMims""",gnuMims - application general,trunk,0.4 - Functionality and integration,defect,,closed,2009-03-23T16:02:56+10:00,2009-11-11T20:25:10+10:00,"See here for project names:
http://en.tldp.org/HOWTO/Software-Release-Practice-HOWTO/naming.html
Fancy ""marketing"" names may be ok in documentation but on the command line the are clumsy.
Discussion and comments?
Well gnuMims being a webapp is unlikely to ever have a command line interface and if it did it would simply be gnumims or gnumims-admin like trac and svn. !GnuMims may be written with a starting capital if it starts a sentence otherwise gnuMims is working just great.",Gavin
27,Task filter does not return any tasks when between is used for dates,gnuMims - application general,trunk,0.5 - Functionality and Stability,defect,,closed,2009-11-10T17:54:27+10:00,2010-02-17T16:47:59+10:00,"This is possibly a bug in the upstream filter-pane plugin which is marked as closed but seems to be affecting gnuMims.
http://jira.codehaus.org/browse/GRAILSPLUGINS-1320 (Due for inclusion in filterPane-0.6.5)
http://jira.codehaus.org/browse/GRAILSPLUGINS-985 (old)
Upstream has indeed fixed this, contributed another fix to allow filterpane plugin to work with Grails-1.2.1 and released a snapshot of the plugin.
Fixed at r361 by upgrading plugin to the newly release 0.6.6-SNAPSHOT.
",Gavin
28,When viewing inventory item pictures with Lightbox resize is not always correct in IE,gnuMims - application general,trunk,0.5 - Functionality and Stability,defect,,closed,2009-11-10T18:21:06+10:00,2009-12-03T12:54:16+10:00,"This works 100% in Firefox so is an IE bug and requires a work around.
If the browser is refreshed then Lightbox size is correct.
Possible fix in r189, still requires testing in IE.
Fix tested and works like a charm.",Gavin
31,Remove the auto inserted login credentials and message in production mode.,gnuMims - application general,trunk,0.5 - Functionality and Stability,enhancement,,closed,2009-11-11T20:57:11+10:00,2009-11-20T15:15:13+10:00,"Wrap these in a tag.
",Gavin
67,Feature request: Indication on Task tabs,gnuMims - application general,trunk,0.7.1 - Feature Requests,enhancement,,closed,2010-05-28T17:15:02+10:00,2010-06-07T12:36:51+10:00,"Indicating if a Task tab has something of interest on it would be nice.
The RichUI plugin used for tabs does not have any built-in way of doing this so a patch to upstream or a completely separate way of indicating this is required. The tabs are preloaded so it does not take long to click through them but when doing this on a large number of tasks it can be a little time consuming or details can be missed.",Gavin
69,Feature request: Red banner for obsolete inventory items,gnuMims - application general,trunk,0.7.1 - Feature Requests,enhancement,,closed,2010-05-29T12:01:23+10:00,2010-06-08T18:16:34+10:00,The same banner that appears on the show task view when in trash.,Gavin
72,Add resource numbers to assigned group,gnuMims - application general,trunk,0.8 - Purchasing and Inventory Improvements,enhancement,Gavin,closed,2010-06-11T12:58:31+10:00,2010-11-24T15:28:22+10:00,,Ray Smith
45,Make dataFormat a global in Config.,gnuMims - application general,trunk,0.9 - General Improvements,enhancement,,new,2009-11-28T12:41:43+10:00,2010-08-01T21:01:28+10:00,"In Config.groovy place a global.dateFormat='EEE, dd-MMM-yyyy'.
Then find and replace all cases of the string with the global variable:
* ${grailsApplication.config.global.dateFormat}
* or
* import org.codehaus.groovy.grails.commons.*
* !ConfigurationHolder.config.global.dateFormat",Gavin
73,Change primary/associated assets,gnuMims - application general,trunk,0.9 - General Improvements,enhancement,Gavin,new,2010-06-11T13:01:32+10:00,2010-08-01T21:09:37+10:00,"Only require multiple assets. Multiple assets may be added to a task, primary/associated differentiation not required.",Ray Smith
80,I'm in! very exciting - right the ticket - add ability to filter by person completing work or a date range,gnuMims - application general,trunk,0.9 - General Improvements,enhancement,Gavin,closed,2010-07-27T12:11:43+10:00,2010-11-24T13:47:09+10:00,,Ray Smith
22,Asset priorities and mandatory registration and testing.,gnuMims - application general,,0.x - Future,enhancement,,closed,2009-10-05T10:18:58+10:00,2010-11-16T09:20:25+10:00," * Priority 1 is regulatory compliance.
* Priority 2 – Hidden functions ( critical assets), etc......
For priority 1 assets having a drop down field or a check box where mandatory registration and testing required, registration renewal date can be selected is a feature that we should have. For example, High pressure vessels, cranes, etc would be asset that require distinction. You might wonder why this may be needed? A few reasons, 1 there is a prompt to personnel for regulatory requirements and 2 often audits want a list of assets that require registration.
Also see ticket #34.",Gavin
52,Production reference,gnuMims - application general,trunk,0.x - Future,enhancement,,closed,2009-12-18T15:15:21+10:00,2010-07-14T14:38:58+10:00, * Please consider adding a production reference to tasks or faults.,Gavin
61,Rotable equipment management,gnuMims - application general,trunk,0.x - Future,enhancement,,new,2010-03-27T00:12:28+10:00,2010-11-24T15:20:31+10:00,"Most of the 'big' CMMS systems have rotable equipment/inventory management. This could be as simple as location tracking or include full overhaul reports, repair specs/procedures, history of cost, quote, repair details, failure intervals. ID Tags, stamps, barcodes, data dot and even RF ID chips may be used to id equipment.
This is a wish list item as rotable management is an advanced maintenance practise and even large companies struggle with it, since gnuMims is aimed at mid-size sites, there may be minimal call for this feature.
The most basic implementation is to have a text field where the item it may be entered on breakdown/repair tasks. A more complete implementation would have inventory items of type rotable and the locations tracked in the asset tree.
The current implementation is to place the equipment id in the task description and assign the task to an asset while using a separate inventory item for repaired. This means the task(s) can be found with minimal effort(2 search fields: asset and description) and repaired inventory item failure rates vs new items can be tracked.",Gavin
78,Reminder: Update import functions to stop/start searchable index,gnuMims - application general,trunk,0.x - Future,enhancement,,closed,2010-07-14T15:41:55+10:00,2010-11-25T14:15:07+10:00,Searchable index was added after the import functions were written and importing while searchable index is mirroring is slower than with it off. There are start and stop methods in !CreateDataService.,Gavin
99,Upgrade filterpane plugin to version 2,gnuMims - application general,trunk,0.x - Future,enhancement,,new,2011-04-29T06:30:38+10:00,2011-04-29T06:30:38+10:00,"Many enhancements, upgrade info:
http://www.grails.org/plugin/filterpane",Gavin
100,Upgrade acegi plugin to spring-security-core,gnuMims - application general,trunk,0.x - Future,enhancement,,new,2011-04-29T06:33:27+10:00,2011-04-29T06:33:27+10:00,"Acegi plugin is obsolete.
Upgrade section in docs:
http://www.grails.org/plugin/spring-security-core",Gavin
101,Upgrade jasper plugin,gnuMims - application general,trunk,0.x - Future,enhancement,,new,2011-04-29T06:39:20+10:00,2011-04-29T06:39:20+10:00,"Jasper-1.2.1 plugin uses Grails-1.3.0 > * and Jasper-4.0.0
http://www.grails.org/plugin/jasper
Jasper 4 is a big improvement in the jasperserver but apparently not a major api change for the jasper lib report engine.
Therefore upgrading reports should not be too hard. In the past I have had success with simply opening the report with iReport of the correct version and saving.
",Gavin
104,Best Practise figures should appear next to actuals on reports.,gnuMims - application general,trunk,0.x - Future,enhancement,,new,2011-06-30T16:38:26+10:00,2011-06-30T16:38:26+10:00,"Best Practise figures are well known for many reports.
These can easily be included in reports, along side the actuals.
* Reactive Ratio: 85% Preventative to 15% Reactive(Immediate Callout)
* Utilisation: 20% Unused etc
* Completion Rate.",Gavin
48,The new gnuMims logo has a poor gradient or jaggered appearance in IE,gnuMims - application general,trunk,0.5 - Functionality and Stability,defect,,closed,2009-12-01T22:10:34+10:00,2009-12-01T22:15:50+10:00,"Found that this is due to an IE bug when the PC's dpi is set to 120 instead of 96 or color is 16 bit instead of 32bit. Note that other image programs in windows handle this ok. For more info see:
http://www.wpdfd.com/forums/wpdfd/browsers/poor_quality_images_in_ie/",Gavin