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.