134:        subject_row = db.get(SubjectLine, cr.generated_subject_id) if cr.generated_subject_id else None
135:        template = db.get(EmailTemplate, cr.generated_template_id) if cr.generated_template_id else None
147:            invoice_number=cr.generated_invoice_number,
148:            amount=cr.generated_amount,
149:            shipping=cr.generated_shipping,
153:            phone=cr.generated_phone or var_cfg.get("company_phone", ""),
156:        rec = _recipient_dict(recipient)
181:                    var_cfg.get("attachment_kind", "invoice"), cr.generated_invoice_number)
289:def _recipient_dict(r) -> dict:
302:def _unsubscribe_url(recipient, campaign) -> str: