import smtplib
import csv
from datetime import datetime, timedelta
from email.mime.text import MIMEText

def check_overdue_invoices(invoices_file="invoices.csv"):
    overdue = []
    today = datetime.now().date()

    with open(invoices_file) as f:
        reader = csv.DictReader(f)
        for row in reader:
            if row["status"] == "unpaid":
                due_date = datetime.strptime(row["due_date"], "%Y-%m-%d").date()
                days_overdue = (today - due_date).days
                if days_overdue > 7:
                    overdue.append({**row, "days_overdue": days_overdue})
    return overdue

def send_followup(invoice, email_from, email_password):
    body = f"Hi {invoice['client_name']},\n\nFollowing up on invoice #{invoice['invoice_id']} for ${invoice['amount']}.\n\nCould you let me know the payment status?\n\nThanks"
    msg = MIMEText(body)
    msg["Subject"] = f"Follow-up: Invoice #{invoice['invoice_id']} ({invoice['days_overdue']} days overdue)"
    msg["From"] = email_from
    msg["To"] = invoice["client_email"]

    with smtplib.SMTP_SSL("smtp.gmail.com", 465) as server:
        server.login(email_from, email_password)
        server.sendmail(email_from, invoice["client_email"], msg.as_string())
    print(f"Follow-up sent for Invoice #{invoice['invoice_id']}")

overdue = check_overdue_invoices()
for inv in overdue:
    send_followup(inv, "your@email.com", "your-app-password")

from collections import defaultdict
from datetime import datetime, timedelta
import csv

def generate_weekly_report(time_log="time_log.csv"):
    week_ago = datetime.now() - timedelta(days=7)
    client_hours = defaultdict(list)

    with open(time_log) as f:
        for row in csv.DictReader(f):
            date = datetime.strptime(row["date"], "%Y-%m-%d")
            if date >= week_ago:
                client_hours[row["client"]].append({
                    "date": row["date"],
                    "task": row["task"],
                    "hours": float(row["hours"])
                })

    report = f"Weekly Report - Week of {week_ago.strftime('%B %d')}\n"
    report += "=" * 50 + "\n\n"

    for client, entries in client_hours.items():
        total = sum(e["hours"] for e in entries)
        report += f"Client: {client} | Total: {total:.1f} hours\n"
        for e in entries:
            report += f"  {e['date']} - {e['task']} ({e['hours']}h)\n"
        report += "\n"

    filename = f"report_{datetime.now().strftime('%Y%m%d')}.txt"
    with open(filename, "w") as f:
        f.write(report)
    print(f"Report saved to {filename}")

generate_weekly_report()

import csv
from datetime import datetime

def check_pending_proposals(proposals_file="proposals.csv"):
    today = datetime.now().date()

    with open(proposals_file) as f:
        for row in csv.DictReader(f):
            if row["status"] == "sent":
                sent_date = datetime.strptime(row["sent_date"], "%Y-%m-%d").date()
                days_since = (today - sent_date).days

                if days_since in [3, 7, 14]:
                    print(f"\n📧 Follow up on day {days_since}:")
                    print(f"   Client: {row['client']}")
                    print(f"   Project: {row['project']}")
                    print(f"   Value: ${row['amount']}")

check_pending_proposals()

import csv
from datetime import datetime

def daily_earnings(time_log="time_log.csv"):
    today = datetime.now().strftime("%Y-%m-%d")
    total_hours = 0
    total_earned = 0

    with open(time_log) as f:
        for row in csv.DictReader(f):
            if row["date"] == today:
                hours = float(row["hours"])
                rate = float(row.get("rate", 0))
                total_hours += hours
                total_earned += hours * rate

    rate = total_earned / total_hours if total_hours > 0 else 0
    print(f"Today: {total_hours:.1f}h worked | ${total_earned:.2f} earned | ${rate:.2f}/hr")

daily_earnings()

import csv
import smtplib
from datetime import datetime
from email.mime.text import MIMEText

def check_client_occasions(clients_file="clients.csv", email_from="", email_password=""):
    today = datetime.now()

    with open(clients_file) as f:
        for row in csv.DictReader(f):
            if row.get("birthday"):
                bday = datetime.strptime(row["birthday"], "%Y-%m-%d")
                if bday.month == today.month and bday.day == today.day:
                    send_greeting(row, "birthday", email_from, email_password)

def send_greeting(client, occasion, email_from, email_password):
    body = f"Hi {client['name']},\n\nHappy {occasion}! Hope you're having a great day.\n\nBest"
    msg = MIMEText(body)
    msg["Subject"] = f"Happy {occasion.capitalize()}, {client['name']}!"
    msg["From"] = email_from
    msg["To"] = client["email"]

    with smtplib.SMTP_SSL("smtp.gmail.com", 465) as server:
        server.login(email_from, email_password)
        server.sendmail(email_from, client["email"], msg.as_string())

check_client_occasions()

# Every weekday morning at 8am
0 8 * * 1-5 cd ~/scripts && python invoice_followup.py && python weekly_report.py && python proposals.py && python earnings.py && python client_occasions.py