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:

     end_date -> the date when the task has to be completed

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.