from flask_sqlalchemy import SQLAlchemy

db = SQLAlchemy()

class User(db.Model):
    __tablename__ = 'user'
    
    id = db.Column(db.Integer, primary_key=True)
    email = db.Column(db.String(120), nullable=False, unique=True)
    username = db.Column(db.String(80), nullable=False)
    # 其他字段...

class CustomerOrder(db.Model):
    __tablename__ = 'customer_order'
    
    id = db.Column(db.Integer, primary_key=True)
    user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)
    tracking_number = db.Column(db.String(50), nullable=False)
    order_number = db.Column(db.String(50), nullable=False)
    # 其他字段...
    
    # 定義與User表的關(guān)系
    user = db.relationship('User', backref='orders')

import smtplib
from email.mime.multipart import MIMEMultipart
from email.mime.text import MIMEText
from email.mime.application import MIMEApplication
import os

def send_email(to_email, subject, body, attachment_path=None):
    """發(fā)送郵件（支持附件）"""
    # 郵件服務(wù)器配置
    smtp_server = "smtp.qq.com"
    smtp_port = 465
    sender_email = "your_email@qq.com"
    password = "your_smtp_password"  # 建議使用環(huán)境變量
    
    # 創(chuàng)建郵件對象
    msg = MIMEMultipart()
    msg['From'] = sender_email
    msg['To'] = to_email
    msg['Subject'] = subject
    
    # 添加正文
    msg.attach(MIMEText(body, 'plain'))
    
    # 添加附件（如果有）
    if attachment_path:
        with open(attachment_path, "rb") as file:
            part = MIMEApplication(file.read(), Name=os.path.basename(attachment_path))
            part['Content-Disposition'] = f'attachment; filename="{os.path.basename(attachment_path)}"'
            msg.attach(part)
    
    # 發(fā)送郵件
    try:
        with smtplib.SMTP_SSL(smtp_server, smtp_port) as server:
            server.login(sender_email, password)
            server.sendmail(sender_email, to_email, msg.as_string())
        return True
    except Exception as e:
        print(f"郵件發(fā)送失敗: {e}")
        return False

def send_email_to_recipients(filepath, receiver_email=None):
    """發(fā)送郵件給指定郵箱和用戶關(guān)聯(lián)郵箱"""
    # 獲取當(dāng)前用戶ID（假設(shè)通過PassportService）
    token, user_id = PassportService.current_user_id()
    
    # 收件人集合（自動去重）
    recipients = set()
    
    # 1. 添加直接指定的郵箱
    if receiver_email:
        recipients.add(receiver_email)
    
    # 2. 查詢用戶關(guān)聯(lián)郵箱
    user = User.query.get(user_id)
    if user and user.email:
        recipients.add(user.email)
    
    if not recipients:
        print("無有效收件人")
        return False
    
    # 發(fā)送郵件（每個郵箱只發(fā)一次）
    success = True
    for email in recipients:
        if not send_email(email, "文件處理結(jié)果", "請查收附件", filepath):
            success = False
    
    return success

recipients = set()
recipients.add("user1@example.com")  # 自動去重

# 優(yōu)化：復(fù)用SMTP連接
with smtplib.SMTP_SSL(smtp_server, smtp_port) as server:
    server.login(sender_email, password)
    for email in recipients:
        server.sendmail(...)

from celery import Celery

celery = Celery('tasks', broker='redis://localhost:6379/0')

@celery.task
def async_send_email(to_email, subject, body, attachment_path=None):
    send_email(to_email, subject, body, attachment_path)

# app.py
from flask import Flask
from flask_sqlalchemy import SQLAlchemy
import smtplib
from email.mime.multipart import MIMEMultipart
from email.mime.text import MIMEText
from email.mime.application import MIMEApplication
import os

app = Flask(__name__)
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///app.db'
db = SQLAlchemy(app)

# 定義User和CustomerOrder模型（略）

def send_email_with_attachment(filepath, receiver_email=None):
    """發(fā)送郵件給指定郵箱和用戶關(guān)聯(lián)郵箱"""
    # 獲取當(dāng)前用戶ID
    token, user_id = PassportService.current_user_id()
    
    # 收件人集合
    recipients = set()
    if receiver_email:
        recipients.add(receiver_email)
    
    user = User.query.get(user_id)
    if user and user.email:
        recipients.add(user.email)
    
    if not recipients:
        return False
    
    # SMTP配置
    smtp_server = "smtp.qq.com"
    smtp_port = 465
    sender_email = "your_email@qq.com"
    password = "your_password"
    
    # 創(chuàng)建郵件內(nèi)容
    msg = MIMEMultipart()
    msg['From'] = sender_email
    msg['Subject'] = "文件處理結(jié)果"
    msg.attach(MIMEText("請查收附件", 'plain'))
    
    # 添加附件
    with open(filepath, "rb") as file:
        part = MIMEApplication(file.read(), Name=os.path.basename(filepath))
        part['Content-Disposition'] = f'attachment; filename="{os.path.basename(filepath)}"'
        msg.attach(part)
    
    # 發(fā)送郵件
    try:
        with smtplib.SMTP_SSL(smtp_server, smtp_port) as server:
            server.login(sender_email, password)
            for email in recipients:
                msg['To'] = email
                server.sendmail(sender_email, email, msg.as_string())
        return True
    except Exception as e:
        print(f"發(fā)送失敗: {e}")
        return False