پرامپت ساخت اسکریپت پایتون برای ارسال ایمیل گزارش خودکار

import pandas as pd import matplotlib.pyplot as plt from matplotlib.backends.backend_pdf import PdfPages import smtplib from email.mime.multipart import MIMEMultipart from email.mime.base import MIMEBase from email import encoders from email.mime.text import MIMEText from datetime import datetime, timedelta import os import traceback import schedule import time # Configuration CSV_FILE = 'sales_data.csv' PDF_REPORT = 'weekly_sales_report.pdf' RECIPIENTS = ['recipient1@example.com', 'recipient2@example.com'] SENDER = 'your_email@example.com' SENDER_PASSWORD = 'your_app_password' SMTP_SERVER = 'smtp.gmail.com' SMTP_PORT = 587 # Function to generate the report PDF def generate_report(csv_file, pdf_file): try: # Load CSV df = pd.read_csv(csv_file, parse_dates=['date']) # Filter for last week's data today = datetime.now().date() last_monday = today - timedelta(days=today.weekday()+7) last_sunday = last_monday + timedelta(days=6) df_week = df[(df['date'] >= pd.Timestamp(last_monday)) & (df['date'] <= pd.Timestamp(last_sunday))] # Compute sales summary total_sales = df_week['sales'].sum() sales_by_product = df_week.groupby('product')['sales'].sum() # Create PDF with plots with PdfPages(pdf_file) as pdf: plt.figure(figsize=(8,6)) sales_by_product.plot(kind='bar') plt.title('Weekly Sales by Product') plt.ylabel('Sales') plt.tight_layout() pdf.savefig() plt.close() plt.figure(figsize=(6,4)) plt.axis('off') plt.text(0, 0.5, f"Total sales this week: ${total_sales:,.2f}", fontsize=14) pdf.savefig() plt.close() except Exception as e: print('Error generating report:', e) traceback.print_exc() # Function to send email with attachment def send_email(subject, body, recipients, attachment): try: msg = MIMEMultipart() msg['From'] = SENDER msg['To'] = ', '.join(recipients) msg['Subject'] = subject msg.attach(MIMEText(body, 'plain')) with open(attachment, 'rb') as f: part = MIMEBase('application', 'octet-stream') part.set_payload(f.read()) encoders.encode_base64(part) part.add_header('Content-Disposition', f'attachment; filename="{os.path.basename(attachment)}"') msg.attach(part) with smtplib.SMTP(SMTP_SERVER, SMTP_PORT) as server: server.starttls() server.login(SENDER, SENDER_PASSWORD) server.send_message(msg) print('Email sent successfully!') except Exception as e: print('Error sending email:', e) traceback.print_exc() def job(): generate_report(CSV_FILE, PDF_REPORT) subject = 'Weekly Sales Report' body = 'This is your weekly sales report.' send_email(subject, body, RECIPIENTS, PDF_REPORT) if os.path.exists(PDF_REPORT): os.remove(PDF_REPORT) # Schedule for every Monday at 9am schedule.every().monday.at('09:00').do(job) if __name__ == '__main__': print('Scheduler started. Waiting for Monday 9:00am...') while True: schedule.run_pending() time.sleep(60) # Check every minute