from odoo import fields, models, api, _
from datetime import timedelta


class MailMail(models.Model):
    _inherit = 'mail.mail'

    @api.model
    def retry_send_mail(self):
        now = fields.Datetime.now()
        seven_days_ago = now - timedelta(days=7)

        # Filter hanya email gagal dalam 7 hari terakhir
        mails = self.search([
            ('state', 'in', ['exception', 'cancel']),
            ('create_date', '>=', seven_days_ago),
            ('create_date', '<=', now),
        ], limit=250)

        for mail in mails:
            mail.state = 'outgoing'