Task Details

Task Details :-

Hi oscar,

i need you to create a cron job that will keep track of the absences each day. this data will be stored in a new table.

this is how it will work:

1. run cron job at 5am bd time.

2. check all employees that did not clock in in last 23 hours.

3. record the date, and total number in teh table

4. but also check the leave table, and check if anyone was on leave in the last 23 hours. you will need to minus this from teh total in point (2).

5. store the total leave count on separate column.

6. show the absence / leave chart from this table on WM dashboard on manager account. it should have 2 line charts. one for leave, one for absence.

the CRON job should do this automatically every day please.

let me know if you ahve any questions.

Task Current Status :-

Task Not Complete