""" FLHIP Scraper v3 - Hotel Email Sender Sends weekly hotel lead summary to client """ import smtplib from email.mime.text import MIMEText from email.mime.multipart import MIMEMultipart from datetime import datetime from hotel_config import EMAIL_CONFIG def format_leads_html(leads: list[dict], stats: dict) -> str: """Format hotel leads as HTML email body.""" now = datetime.now().strftime("%B %d, %Y") html = f"""

FLHIP Weekly Hotel Leads

Report generated: {now}

{stats.get('inserted', 0)}

New Hotel Leads

{stats.get('duplicates', 0)}

Duplicates Skipped

{stats.get('total', 0)}

Articles Processed

New Hotel Opening Leads

""" if not leads: html += "

No new hotel leads found this week.

" else: html += """ """ for lead in leads: business = lead.get('business') or lead.get('business_name') or '' html += f""" """ html += "

County	Hotel Name	Address	City	State	Zip	Lat	Long	Phone	Contact Name	Contact E-mail	Info Source	Internet Info	Opening Date	Notes
{lead.get('county') or ''}	{business}	{lead.get('address') or ''}	{lead.get('city') or ''}	{lead.get('state') or ''}	{lead.get('zip') or ''}	{lead.get('lat') or ''}	{lead.get('lng') or ''}	{lead.get('phone') or ''}	{lead.get('contact_name') or ''}	{lead.get('contact_email') or ''}	{lead.get('info_source') or ''}	{lead.get('internet_info') or ''}	{lead.get('opening_date') or ''}	{lead.get('notes') or ''}

" html += f""" """ return html def format_leads_text(leads: list[dict], stats: dict) -> str: """Format hotel leads as plain text email body.""" now = datetime.now().strftime("%B %d, %Y") text = f""" FLHIP Weekly Hotel Leads Report generated: {now} SUMMARY ------- New Hotel Leads: {stats.get('inserted', 0)} Duplicates Skipped: {stats.get('duplicates', 0)} Articles Processed: {stats.get('total', 0)} NEW HOTEL OPENING LEADS ----------------------- """ if not leads: text += "No new hotel leads found this week.\n" else: for i, lead in enumerate(leads, 1): business = lead.get('business') or lead.get('business_name') or '' text += f""" {i}. {business} Address: {lead.get('address') or ''} City: {lead.get('city') or ''}, {lead.get('state') or ''} {lead.get('zip') or ''} Opening Date: {lead.get('opening_date') or ''} Phone: {lead.get('phone') or ''} Contact: {lead.get('contact_name') or ''} Email: {lead.get('contact_email') or ''} Source: {lead.get('info_source') or ''} Notes: {lead.get('notes') or ''} """ text += """ --- Generated by FLHIP Hotel Scraper v3 Owner: Ken Roberts - ken@flhip.com Technical Support: projects@verowebconsulting.com """ return text def send_lead_email(leads: list[dict], stats: dict) -> bool: """Send the weekly hotel lead email.""" if not EMAIL_CONFIG.get("smtp_user") or not EMAIL_CONFIG.get("to_addresses"): print("Email not configured - skipping send") return False try: # Create message msg = MIMEMultipart("alternative") msg["Subject"] = f"FLHIP Weekly Hotel Leads: {stats.get('inserted', 0)} New Hotel Openings" msg["From"] = EMAIL_CONFIG["from_address"] msg["To"] = ", ".join(EMAIL_CONFIG["to_addresses"]) # Attach both plain text and HTML versions text_part = MIMEText(format_leads_text(leads, stats), "plain", "utf-8") html_part = MIMEText(format_leads_html(leads, stats), "html", "utf-8") msg.attach(text_part) msg.attach(html_part) # Send with smtplib.SMTP(EMAIL_CONFIG["smtp_host"], EMAIL_CONFIG["smtp_port"]) as server: server.starttls() server.login(EMAIL_CONFIG["smtp_user"], EMAIL_CONFIG["smtp_password"]) server.send_message(msg) print(f"Hotel email sent to {len(EMAIL_CONFIG['to_addresses'])} recipients") return True except Exception as e: print(f"Email error: {e}") return False if __name__ == "__main__": # Test with sample data sample_leads = [ { "business": "Marriott Downtown", "city": "Austin", "state": "TX", "address": "500 Congress Ave", "zip": "78701", "opening_date": "2026-04-15", "contact_name": "John Smith", "contact_email": "john@marriott.com", "phone": "512-555-0123", "info_source": "https://example.com/article", "internet_info": "https://google.com/alerts/feeds/...", "notes": "250-room hotel with rooftop bar and conference center" } ] sample_stats = { "total": 50, "inserted": 10, "duplicates": 5, "errors": 0 } html = format_leads_html(sample_leads, sample_stats) with open("/tmp/hotel_email_preview.html", "w") as f: f.write(html) print("Hotel email preview saved to /tmp/hotel_email_preview.html") text = format_leads_text(sample_leads, sample_stats) print(text)