#!/usr/bin/env python3
"""
Ghost Agency Mockup Generator v2 - Siti ricchi per conversione.
- Foto placeholder reali (Unsplash source)
- Orari, indirizzo, telefono integrati
- Bottone WhatsApp diretto
- Form contatti → webhook Telegram
- Varianti colore per settore
- SEO meta tags
"""
import csv, os, re, subprocess
from pathlib import Path
from jinja2 import Template
CSV_PATH = "leads_raw.csv"
BASE_DIR = Path.cwd()
# Palette colori per settore
SECTOR_COLORS = {
"ristorante": {"primary": "#c0392b", "secondary": "#e74c3c", "accent": "#f39c12", "bg": "#fdf2f2"},
"dentista": {"primary": "#1e3a8a", "secondary": "#3b82f6", "accent": "#06b6d4", "bg": "#eff6ff"},
"palestra": {"primary": "#166534", "secondary": "#22c55e", "accent": "#84cc16", "bg": "#f0fdf4"},
"parrucchiere": {"primary": "#9d174d", "secondary": "#ec4899", "accent": "#f43f5e", "bg": "#fdf2f8"},
"avvocato": {"primary": "#1e293b", "secondary": "#334155", "accent": "#64748b", "bg": "#f8fafc"},
"idraulico": {"primary": "#075985", "secondary": "#0ea5e9", "accent": "#22d3ee", "bg": "#f0f9ff"},
"estetista": {"primary": "#86198f", "secondary": "#d946ef", "accent": "#f0abfc", "bg": "#faf5ff"},
}
DEFAULT_COLORS = {"primary": "#1a1a2e", "secondary": "#333", "accent": "#6366f1", "bg": "#f5f5f5"}
# Foto placeholder per settore (Unsplash source - veloce, no API key)
SECTOR_IMAGES = {
"ristorante": "https://images.unsplash.com/photo-1517248135467-4c7edcad34c4?w=800&q=80",
"dentista": "https://images.unsplash.com/photo-1606811842175-8b5a1c9e2b0e?w=800&q=80",
"palestra": "https://images.unsplash.com/photo-1534438327276-14e5300c3a48?w=800&q=80",
"parrucchiere": "https://images.unsplash.com/photo-1560066984-138dadb4c035?w=800&q=80",
"avvocato": "https://images.unsplash.com/photo-1589829545856-d10d557cf95f?w=800&q=80",
"idraulico": "https://images.unsplash.com/photo-1607472586893-edb57bdc0e39?w=800&q=80",
"estetista": "https://images.unsplash.com/photo-1616394584738-fc6e612e71b9?w=800&q=80",
}
DEFAULT_IMAGE = "https://images.unsplash.com/photo-1497366216548-37526070297c?w=800&q=80"
# Orari standard per settore
SECTOR_HOURS = {
"ristorante": {"lun-ven": "12:00-15:00, 19:00-23:00", "sab": "12:00-15:00, 19:00-23:30", "dom": "Chiuso"},
"dentista": {"lun-ven": "09:00-13:00, 14:30-19:00", "sab": "09:00-13:00", "dom": "Chiuso"},
"palestra": {"lun-ven": "06:00-23:00", "sab": "08:00-20:00", "dom": "09:00-18:00"},
"parrucchiere": {"lun-ven": "09:00-19:00", "sab": "09:00-18:00", "dom": "Chiuso"},
"avvocato": {"lun-ven": "09:00-13:00, 14:30-18:30", "sab": "Su appuntamento", "dom": "Chiuso"},
"idraulico": {"lun-ven": "08:00-18:00", "sab": "08:00-13:00", "dom": "Solo emergenze"},
"estetista": {"lun-ven": "09:00-19:00", "sab": "09:00-18:00", "dom": "Chiuso"},
}
TEMPLATE_HTML = """
{{ name }} - {{ category_title }} a {{ city_display }}
{{ name }}
{{ category_title }} a {{ city_display }}
📍 Contatti e Orari
{% if address %}
{% endif %}
{% if phone %}
{% endif %}
{% if email %}
{% endif %}
Orari di apertura
| Lunedì - Venerdì | {{ hours.lun_ven }} |
| Sabato | {{ hours.sab }} |
| Domenica | {{ hours.dom }} |
Vuoi il sito completo?
Trasformiamo questo mockup in un sito professionale: SEO, prenotazioni online, blog, multilingua.
🔧 Modalità Demo
"""
def slugify(s: str) -> str:
return re.sub(r"[^a-z0-9]+", "-", s.lower()).strip("-")
def get_colors(category: str) -> dict:
return SECTOR_COLORS.get(category.lower(), DEFAULT_COLORS)
def get_hero_image(category: str) -> str:
return SECTOR_IMAGES.get(category.lower(), DEFAULT_IMAGE)
def get_hours(category: str) -> dict:
return SECTOR_HOURS.get(category.lower(), {"lun_ven": "Su appuntamento", "sab": "Su appuntamento", "dom": "Chiuso"})
def normalize_phone(phone: str) -> str:
"""Normalizza telefono per link tel: e wa.me"""
if not phone:
return ""
# Rimuovi tutto tranne numeri e +
cleaned = re.sub(r"[^\d+]", "", phone)
if cleaned.startswith("+39"):
return cleaned[3:]
elif cleaned.startswith("39"):
return cleaned[2:]
return cleaned
def create_site(lead: dict) -> Path:
category = lead.get("category", "").lower()
colors = get_colors(category)
hero_image = get_hero_image(category)
hours = get_hours(category)
phone = lead.get("phone", "")
phone_wa = normalize_phone(phone)
# Dati per il template
template_data = {
**lead,
"colors": colors,
"hero_image": hero_image,
"hours": hours,
"phone_wa": phone_wa,
"category_title": category.capitalize(),
"city_display": lead.get("city") or "Parma",
"meta_description": f"Sito web per {lead.get('name', '')} - {category.capitalize()} a {lead.get('city') or 'Parma'}. Mockup demo gratuito.",
"telegram_bot_token": os.environ.get("TELEGRAM_BOT_TOKEN", "YOUR_BOT_TOKEN"),
"telegram_chat_id": os.environ.get("TELEGRAM_CHAT_ID", "YOUR_CHAT_ID"),
"mockup_url": f"https://{slugify(lead.get('name', ''))}.netlify.app",
"FROM_EMAIL": os.environ.get("FROM_EMAIL", "voipamraj@gmail.com"),
"message_placeholder": "Messaggio del cliente dal form..."
}
folder = BASE_DIR / f"site_{slugify(lead.get('name', ''))}"
folder.mkdir(parents=True, exist_ok=True)
html = Template(TEMPLATE_HTML).render(**template_data)
(folder / "index.html").write_text(html, encoding="utf-8")
return folder
def deploy_to_netlify(site_path: Path):
token = os.environ.get("NETLIFY_TOKEN") or os.environ.get("NETLIFY_AUTH_TOKEN")
if not token:
print("⚠️ NETLIFY_TOKEN/NETLIFY_AUTH_TOKEN non definito, salto deploy")
return
cmd = ["netlify", "deploy", "--prod", "--dir", str(site_path), "--auth", token]
try:
subprocess.run(cmd, check=True, capture_output=True, text=True)
print(f"✅ Deployed {site_path.name} su Netlify")
except subprocess.CalledProcessError as e:
print(f"❌ Deploy failed for {site_path.name}: {e.stderr}")
def main():
if not Path(CSV_PATH).exists():
print(f"❌ {CSV_PATH} non trovato. Esegui prima scraper_maps.py")
return
with open(CSV_PATH, newline="", encoding="utf-8") as f:
leads = list(csv.DictReader(f))
print(f"🔍 Generating rich sites for {len(leads)} leads...")
for lead in leads:
site_path = create_site(lead)
print(f"✅ Created: {site_path.name}")
deploy_to_netlify(site_path)
if __name__ == "__main__":
main()