Hi,
By implementing a scheduled activity, you can automate the process of creating follow-up tasks for leads that have been stagnant in the 'New' stage for an extended period.
from odoo import fields, models, api, tools
class ScheduledActivity(models.Model):
_name = 'crm.scheduled.activity'
def _check_and_create_activity(self):
three_days_ago = fields.Datetime.now() - timedelta(days=3)
new_leads = self.env['crm.lead'].search([
('stage_id.name', '=', 'New'),
('create_date', '
])
for lead in new_leads:
activity_data = {
'display_name': 'Follow Up: Lead Stuck in New Stage',
'summary': 'This lead has been in the New stage for more than 3 days.',
'date_deadline': fields.Datetime.now(),
'user_id': lead.user_team_id.leader_id.id])]
self.env['mail.activity'].create(activity_data)
def run_scheduled_activity(self):
self._check_and_create_activity()
# Schedule the action to run daily (modify interval as needed)
tools.scheduler.cron.register(
self._name + '.run_scheduled_activity',
self.run_scheduled_activity,
day=1, # Every day
)
Hope this should be helpful!