Abonnemente Aktionen

records.set_close()

for line in records.invoice_line_ids.filtered(lambda line: line.product_id.recurring_invoice):
  if line.sale_line_ids:
    end_date = line.sale_line_ids[0].order_id.next_invoice_date - datetime.timedelta(days=1)
    # Get delta in years
    recurrence_id = line.sale_line_ids[0].order_id.recurrence_id
    duration = recurrence_id.duration
    delta = dateutil.relativedelta.relativedelta(years=duration)
    if recurrence_id.unit == "month":
      delta = dateutil.relativedelta.relativedelta(months=duration)
    # Calculate start date from end date
    # raise UserError([end_date, delta_years])
    start_date = end_date - delta + datetime.timedelta(days=1)
    line["subscription_start_date"] = start_date
    line["subscription_end_date"] = end_date

for order in records:
    origin_order_id = order.origin_order_id
    if origin_order_id:
        order.write({
            "plan_id": origin_order_id.plan_id,
            "next_invoice_date": origin_order_id.next_invoice_date,
            "start_date": origin_order_id.start_date,
            "subscription_state": origin_order_id.subscription_state
        })

# Settings
stage1_ref = "__custom__.reminder_stage1"
stage2_ref = "__custom__.reminder_stage2"
stage1_weeks = 6
stage2_weeks = 2

# Get references
stage1_id = env.ref(stage1_ref)
stage2_id = env.ref(stage2_ref)
stage_running_id = env.ref("sale_subscription.sale_subscription_stage_in_progress")

# Get expiring dates
today = datetime.datetime.today()
stage1_date = today + datetime.timedelta(weeks=stage1_weeks)
stage2_date = today + datetime.timedelta(weeks=stage2_weeks)

# Search and move stage 1
stage1_subscriptions = env["sale.order"].search([
   ("is_subscription", "=", True),
   ("stage_id", "=", stage_running_id.id),
   ("next_invoice_date", "<=", stage1_date),
   ("next_invoice_date", ">", stage2_date),
])
# raise UserError(stage1_subscriptions)
stage1_subscriptions.write({"stage_id": stage1_id.id})

# Search and move stage 2
stage2_subscriptions = env["sale.order"].search([
   ("is_subscription", "=", True),
   ("stage_id", "in", [stage1_id.id, stage_running_id.id]),
   ("next_invoice_date", "<=", stage2_date),
   ("next_invoice_date", ">", today),
])
# raise UserError(stage2_subscriptions)
stage2_subscriptions.write({"stage_id": stage2_id.id})

# Settings
weeks_before_invoice_date = 6
mail_template = env.ref("license_ocad_mail.mail_template_extend_subscription")
email_layout = "mail.mail_notification_layout_with_responsible_signature"
default_price_list = "product.list0"

# Get references
pricelist_id = env.ref(default_price_list)
tag_id = env.ref("__custom__.tag_missing_mail")

# Get resellers
reseller_ids = env["res.partner"].search([("grade_id","!=",False)])

# Get extend date
today = datetime.datetime.today()
extend_date = today + datetime.timedelta(weeks=weeks_before_invoice_date)

# Search subscriptions
extend_subscriptions = env["sale.order"].search([
    # ("partner_id", "not in", reseller_ids.ids),
    ("is_subscription", "=", True),
    ("pricelist_id", "=", pricelist_id.id),
    ("subscription_state", "=", "3_progress"),
    ("subscription_child_ids", "=", False),
    ("state", "=", "sale"),
    ("next_invoice_date", "<=", extend_date),
    ("next_invoice_date", ">=", today),
    ("license_count", ">", 0)
])

# raise UserError([extend_subscriptions, extend_date])

# Create and send renewal order
for subscription in extend_subscriptions:
    try:
        res = subscription.prepare_renewal_order()
        res_id = res["res_id"]
        renewal_so = env["sale.order"].browse(res_id)
        composer = env['mail.compose.message'].with_context(
            default_model='sale.order',
            default_res_ids=[renewal_so.id],
            default_template_id=mail_template.id,
            default_composition_mode='comment',
        ).create({})
        composer.action_send_mail()
        renewal_so.action_quotation_sent()
    except:
        renewal_so["tag_ids"] = [tag_id.id]
        env["helpdesk.ticket"].create({
            "name": "Verlängerung: Fehler bei Erneuerung",
            "description": "Das Abonnement " + renewal_so.name + " konnte nicht verlängert werden, es ist ein Fehler entstanden."
        })
        subscription.set_close()

# Settings
weeks_before_validity_date = 2
mail_template = env.ref("__custom__.mail_template_reminder_extend_subscription")
tag = env['crm.tag'].search([('name', '=', "Reminder Sent")], limit=1)

# Get extend date
today = datetime.datetime.today()
remind_date = (today + datetime.timedelta(weeks=weeks_before_validity_date)).date()

# Search subscriptions
remind_subscriptions = env["sale.order"].search([
    ("is_subscription", "=", True),
    ("state", "=", "sent"),
    ("subscription_state", "=", "2_renewal"),
    ("validity_date", "=", remind_date),
    ("license_count", ">", 0),
    ("tag_ids", "not in", [tag.id])
])

# raise UserError([remind_subscriptions.mapped("name"), remind_subscriptions.mapped("validity_date")])

# Create and send renewal order
for subscription in remind_subscriptions:
    try:
        composer = env['mail.compose.message'].with_context(
            default_model='sale.order',
            default_res_ids=[subscription.id],
            default_template_id=mail_template.id,
            default_composition_mode='comment',
        ).create({})
        composer.action_send_mail()
        subscription.write({'tag_ids': [(4, tag.id)]})
    except:
        env["helpdesk.ticket"].create({
            "name": "Reminder: Fehler bei Versand",
            "description": "Beim Versand des Reminder für Abonnement " + renewal_so.name + " ist ein Fehler entstanden."
        })