To-do like task manager

Hello, I'm trying to create a task manager aplication for an acountants firm.

I have several regular tasks so I defined the aplication in two tables :

  "task_type"

         name;          time-> montly or every 3 monts;          end_date -> the date when the task has to be completed

   "task"

         task_type_id          task_start_date          state

I need to automaticly create several tasks that will repeat themselfs in a year acording to their "time" (defined in task_type), I can just create an interface that will do this ....

The problem is that I need to have create new task_types every year , I can't just change them because I will need to have the old data available for my users.

How can I create the "task_type" and tasks without user interference ?

HaNNiBaL80 wrote:

Hello, I'm trying to create a task manager aplication for an acountants firm.

I have several regular tasks so I defined the aplication in two tables :

  "task_type"

         name;          time-> montly or every 3 monts;          end_date -> the date when the task has to be completed

   "task"

         task_type_id          task_start_date          state

I need to automaticly create several tasks that will repeat themselfs in a year acording to their "time" (defined in task_type), I can just create an interface that will do this ....

The problem is that I need to have create new task_types every year , I can't just change them because I will need to have the old data available for my users.

How can I create the "task_type" and tasks without user interference ?    I think something like backgroundRb or Cron should be able to schedule a script that will run at defined intervals (every Dec 31st - to create all the tasks for the new year, or every night - to create all tasks that expired today which should be repeated) and insert the new tasks.

Hope this helps.

Cheers, Mohit. 6/23/2007 | 1:11 AM.