File & Media Automation

# Excel Automation Simulation: Generating an Automated Financial Report
def generate_excel_financial_report(sales_data):
    """Simulates openpyxl workbook creation and formula computation."""
    workbook = {"title": "Q3_Financial_Summary.xlsx", "rows": []}
    
    # 1. Header row:
    headers = ["Transaction ID", "Client Name", "Product", "Gross Amount (INR)", "GST (18%)", "Total Payable"]
    workbook["rows"].append(headers)

    # 2. Populate transaction rows with automated formula calculation:
    for idx, (client, product, gross) in enumerate(sales_data, start=1001):
        gst = round(gross * 0.18, 2)
        total = round(gross + gst, 2)
        workbook["rows"].append([f"INV#{idx}", client, product, f"₹{gross:,.2f}", f"₹{gst:,.2f}", f"₹{total:,.2f}"])

    return workbook

sample_sales = [
    ("TechCorp India", "Cloud Enterprise License", 150000.0),
    ("Apex Dynamics",  "Cybersecurity Audit",       85000.0),
    ("InnovateLabs",   "AI Training Platform",      220000.0)
]

report = generate_excel_financial_report(sample_sales)
print(f"--- 📊 Automated Excel Workbook Generated: [{report['title']}] ---")
for r in report["rows"]:
    print(f"{r[0]:<10} {r[1]:<18} {r[2]:<26} {r[3]:<16} {r[4]:<12} {r[5]:<14}")

# Automated Email Dispatch Pipeline Simulation:
import datetime

class AutomatedEmailDispatcher:
    """Simulates sending rich HTML emails with attachments via SMTP."""
    
    def __init__(self, smtp_server="smtp.gmail.com", port=587):
        self.server = smtp_server
        self.port = port

    def send_invoice_email(self, recipient_email, customer_name, invoice_id, amount, attachment_file):
        """Constructs MIME multipart message and sends via SMTP."""
        email_payload = {
            "To": recipient_email,
            "From": "billing@ourcompiler.com",
            "Subject": f"Invoice #{invoice_id} from Our Compiler — Paid Successfully",
            "Date": datetime.datetime.now().strftime("%a, %d %b %Y %H:%M:%S"),
            "Attachment": attachment_file,
            "HTML_Body": f"""
            
              
                
Dear {customer_name},
                
Thank you for your business! Your payment of ₹{amount:,.2f} has been processed successfully.
                
Your official tax invoice {attachment_file} is attached to this email.
                

                
Best regards,
Our Compiler Billing Team
              
            
            """
        }
        print(f"📧 [SMTP DISPATCH] Sent Email to {recipient_email} with attachment: '{attachment_file}'")
        return email_payload

# Run Email Dispatcher Demo:
dispatcher = AutomatedEmailDispatcher()
res = dispatcher.send_invoice_email(
    recipient_email="balaji.dev@example.com",
    customer_name="Balaji",
    invoice_id="INV-2026-894",
    amount=1499.00,
    attachment_file="Invoice_INV-2026-894.pdf"
)