Planned Maintenance Module
Proposal for additional functionality to the fixed assets module which allows for maintenance tasks to be defined by fixed asset (that is not disposed of) a new table - as follows:
assetid - int
taskid - primary key - int
taskdescription - text
frequencydays - integer
lastcompleted - date
personresponsible - varchar FK www_users.userid
managerresponsible - varchar FK www_users.userid
Emails to be produced to the person responsible (and the manager responsible if one is defined) when the first user logs in for the day - based on the MaintenaceTasksLastRun config date and the lastcompleteddate + frequencydays.
Emails produced daily (when first user logs in) until the task is flagged as completed - by the person responsible.
Forms are required to:
1. Allow input and maintenance of tasks - that updates/inserts/deletes task from the new table
2. Show the outstanding tasks of the logged in user so they can easily update their scheduled jobs - this just updates the lastcompleted date - only the person responsible can do this update.
Appreciate any input into the above spec.... anyone?
Phil Daintree
webERP Admin
Logic Works Ltd
http://www.logicworks.co.nz
|