Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Planned Maintenance Module
04-19-2012, 10:21 AM, (This post was last modified: 04-19-2012, 10:22 AM by phil.)
#1
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
Reply


Messages In This Thread
Planned Maintenance Module - by phil - 04-19-2012, 10:21 AM
RE: Planned Maintenance Module - by ojobello - 08-20-2012, 06:39 AM
RE: Planned Maintenance Module - by phil - 08-20-2012, 08:20 AM

Forum Jump:


Users browsing this thread: 1 Guest(s)