Weekly alert to project managers about zero expected team effort

[rathorevaibhav]

Describe the task There are several projects that have zero expected hours for team members. A weekly alert on Monday 10am should be triggered to every project manager alerting about the project having zero expected effort.

In case a project doesn't have any project manager, skip that project for now. We will send another email to admins with projects not having a project manager.

The email template can be like:

Hello {name},

We found some projects where the expected hours are zero for you or team members where you are assigned as project manager. Please update these projects:
1. Project name
2. Project name

Thanks
Portal Team
ColoredCow

Note: All the project names should be links to their corresponding edit page in the portal.

[rathorevaibhav]

@gautam071 as per discussion with @deepankar-sajwan there is some change in the email recipient.

Instead of project manager, we need to send the emails to key account managers.

So most of the logic remains same, except that we need to alert every key account manager and notify them about team members with zero expected hours in their project.

[gautam071]

hey @rathorevaibhav,

Thanks for sharing, and I will make the following changes and let you know.