<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Property Report — {{ report.address }} — sfpermits.ai</title>
</head>
<body style="margin:0;padding:0;background:#0a0e1a;font-family:-apple-system,BlinkMacSystemFont,'Segoe UI',Roboto,sans-serif;color:#f0f4ff;line-height:1.6;">
<!-- Outer wrapper -->
<table role="presentation" width="100%" cellpadding="0" cellspacing="0" style="background:#0a0e1a;">
<tr>
<td align="center" style="padding:24px 16px;">
<!-- Inner container -->
<table role="presentation" width="600" cellpadding="0" cellspacing="0" style="max-width:600px;width:100%;background:#10182c;border-radius:12px;overflow:hidden;border:1px solid #1e2a3a;">
<!-- Header -->
<tr>
<td style="background:#0a0e1a;padding:20px 28px;border-bottom:1px solid #1e2a3a;">
<a href="{{ report_url }}" style="color:#00d4c8;font-size:1.3rem;font-weight:700;text-decoration:none;">sfpermits<span style="color:#8899aa;font-weight:400;">.ai</span></a>
<span style="float:right;color:#8899aa;font-size:0.85rem;line-height:2;">Property Report</span>
</td>
</tr>
<!-- Title -->
<tr>
<td style="padding:28px 28px 8px;">
<h1 style="margin:0;font-size:1.3rem;color:#f0f4ff;">{{ report.address }}</h1>
<p style="margin:4px 0 0;color:#8899aa;font-size:0.9rem;">
Block {{ report.block }}, Lot {{ report.lot }}
{% if report.links and report.links.parcel %}
· <a href="{{ report.links.parcel }}" style="color:#00d4c8;text-decoration:none;">View parcel</a>
{% endif %}
</p>
</td>
</tr>
{# ===== Personal Message (if shared) ===== #}
{% if personal_message %}
<tr>
<td style="padding:4px 28px 16px;">
<table role="presentation" width="100%" cellpadding="0" cellspacing="0">
<tr>
<td style="padding:14px 18px;border-radius:6px;background:#0a0e1a;border-left:3px solid #00d4c8;border:1px solid #1e2a3a;border-left:3px solid #00d4c8;">
<div style="font-size:0.8rem;color:#8899aa;margin-bottom:4px;">{{ sender_name or "Someone" }} shared this with you:</div>
<div style="font-size:0.9rem;color:#f0f4ff;line-height:1.5;">{{ personal_message }}</div>
</td>
</tr>
</table>
</td>
</tr>
{% endif %}
{# ===== Section 1: Risk Assessment ===== #}
<tr>
<td style="padding:20px 28px 8px;">
<h2 style="margin:0 0 12px;font-size:1rem;color:#00d4c8;border-bottom:1px solid #1e2a3a;padding-bottom:8px;">Risk Assessment</h2>
</td>
</tr>
{% if report.risk_assessment %}
{% for risk in report.risk_assessment %}
<tr>
<td style="padding:0 28px 10px;">
<table role="presentation" width="100%" cellpadding="0" cellspacing="0">
<tr>
<td style="padding:12px 16px;border-radius:6px;border-left:4px solid {% if risk.severity == 'high' %}#f87171{% elif risk.severity == 'moderate' %}#fbbf24{% else %}#00d4c8{% endif %};background:{% if risk.severity == 'high' %}#3d1a1a{% elif risk.severity == 'moderate' %}#2e2200{% else %}#0a1a2e{% endif %};">
<span style="display:inline-block;padding:1px 6px;border-radius:3px;font-size:0.65rem;font-weight:700;text-transform:uppercase;{% if risk.severity == 'high' %}background:#5a2020;color:#f87171;{% elif risk.severity == 'moderate' %}background:#4a3800;color:#fbbf24;{% else %}background:#0e2a4a;color:#00d4c8;{% endif %}">{{ risk.severity }}</span>
<span style="font-weight:600;font-size:0.9rem;margin-left:6px;color:#f0f4ff;">
{% if risk.link %}
<a href="{{ risk.link }}" style="color:#f0f4ff;text-decoration:none;">{{ risk.title }}</a>
{% else %}
{{ risk.title }}
{% endif %}
</span>
<div style="font-size:0.8rem;color:#8899aa;margin-top:4px;">{{ risk.description }}</div>
</td>
</tr>
</table>
</td>
</tr>
{% endfor %}
{% else %}
<tr>
<td style="padding:0 28px 16px;">
<table role="presentation" width="100%" cellpadding="0" cellspacing="0">
<tr>
<td style="padding:12px 16px;border-radius:6px;border-left:4px solid #34d399;background:#0d2e1a;">
<span style="display:inline-block;padding:1px 6px;border-radius:3px;font-size:0.65rem;font-weight:700;text-transform:uppercase;background:#134d2a;color:#34d399;">clear</span>
<span style="font-weight:600;font-size:0.9rem;margin-left:6px;color:#f0f4ff;">No known risks</span>
<div style="font-size:0.8rem;color:#8899aa;margin-top:4px;">No active complaints, violations, or anomalies were found for this property.</div>
</td>
</tr>
</table>
</td>
</tr>
{% endif %}
{# ===== Owner Mode Banner ===== #}
{% if is_owner %}
<tr>
<td style="padding:0 28px 12px;">
<table role="presentation" width="100%" cellpadding="0" cellspacing="0">
<tr>
<td style="padding:10px 14px;border-radius:6px;background:#0a1a2e;border:1px solid #0e2a4a;font-size:0.85rem;color:#00d4c8;">
🏠 You are viewing this report as the property owner. Recommendations are tailored for your situation.
</td>
</tr>
</table>
</td>
</tr>
{% endif %}
{# ===== Section 1.5: Remediation Roadmap (Owner Mode) ===== #}
{% if report.remediation_roadmap %}
<tr>
<td style="padding:12px 28px 4px;">
<h2 style="margin:0 0 12px;font-size:1rem;color:#00d4c8;border-bottom:1px solid #1e2a3a;padding-bottom:8px;">Remediation Roadmap</h2>
</td>
</tr>
{% for card in report.remediation_roadmap %}
<tr>
<td style="padding:0 28px 12px;">
<table role="presentation" width="100%" cellpadding="0" cellspacing="0">
<tr>
<td style="padding:14px 16px;border-radius:6px;border-left:4px solid {% if card.severity == 'high' %}#f87171{% else %}#fbbf24{% endif %};background:{% if card.severity == 'high' %}#3d1a1a{% else %}#2e2200{% endif %};">
<span style="display:inline-block;padding:1px 6px;border-radius:3px;font-size:0.65rem;font-weight:700;text-transform:uppercase;{% if card.severity == 'high' %}background:#5a2020;color:#f87171;{% else %}background:#4a3800;color:#fbbf24;{% endif %}">{{ card.severity }}</span>
<span style="font-weight:600;font-size:0.9rem;margin-left:6px;color:#f0f4ff;">{{ card.title }}</span>
{% if card.what_at_stake %}
<div style="font-size:0.85rem;color:#8899aa;margin-top:8px;padding:8px 10px;background:#0a0e1a;border-radius:4px;border-left:3px solid #fbbf24;">{{ card.what_at_stake }}</div>
{% endif %}
{% for opt in card.options %}
<div style="margin-top:10px;padding:10px 12px;border-radius:6px;border:1px solid {% if opt.effort == 'full_compliance' %}#134d2a{% elif opt.effort == 'least_effort' %}#0e2a4a{% else %}#1e2a3a{% endif %};background:#0a0e1a;">
<strong style="font-size:0.85rem;color:#f0f4ff;">{{ opt.label }}</strong>
{% if opt.cost_range %}<span style="font-size:0.75rem;color:#8899aa;margin-left:6px;">{{ opt.cost_range }}</span>{% endif %}
<div style="font-size:0.8rem;color:#8899aa;margin-top:4px;">{{ opt.description }}</div>
</div>
{% endfor %}
</td>
</tr>
</table>
</td>
</tr>
{% endfor %}
{% endif %}
{# ===== Section 2: Property Profile ===== #}
{% if report.property_profile %}
<tr>
<td style="padding:12px 28px 4px;">
<h2 style="margin:0 0 12px;font-size:1rem;color:#00d4c8;border-bottom:1px solid #1e2a3a;padding-bottom:8px;">Property Profile</h2>
</td>
</tr>
<tr>
<td style="padding:0 28px 20px;">
<table role="presentation" width="100%" cellpadding="0" cellspacing="0">
<tr>
<td style="padding:6px 0;border-bottom:1px solid #1e2a3a;font-size:0.8rem;color:#8899aa;font-weight:600;width:40%;">Zoning</td>
<td style="padding:6px 0;border-bottom:1px solid #1e2a3a;font-size:0.9rem;color:#f0f4ff;">
{% if report.property_profile.zoning %}
<a href="{{ links.planning_code(report.property_profile.zoning) }}" style="color:#00d4c8;text-decoration:none;">{{ report.property_profile.zoning }}</a>
{% else %}—{% endif %}
</td>
</tr>
<tr>
<td style="padding:6px 0;border-bottom:1px solid #1e2a3a;font-size:0.8rem;color:#8899aa;font-weight:600;">Assessed Value</td>
<td style="padding:6px 0;border-bottom:1px solid #1e2a3a;font-size:0.9rem;color:#f0f4ff;">{{ report.property_profile.assessed_value or '—' }}</td>
</tr>
<tr>
<td style="padding:6px 0;border-bottom:1px solid #1e2a3a;font-size:0.8rem;color:#8899aa;font-weight:600;">Property Class</td>
<td style="padding:6px 0;border-bottom:1px solid #1e2a3a;font-size:0.9rem;color:#f0f4ff;">{{ report.property_profile.property_class or '—' }}</td>
</tr>
<tr>
<td style="padding:6px 0;border-bottom:1px solid #1e2a3a;font-size:0.8rem;color:#8899aa;font-weight:600;">Neighborhood</td>
<td style="padding:6px 0;border-bottom:1px solid #1e2a3a;font-size:0.9rem;color:#f0f4ff;">{{ report.property_profile.neighborhood or '—' }}</td>
</tr>
<tr>
<td style="padding:6px 0;border-bottom:1px solid #1e2a3a;font-size:0.8rem;color:#8899aa;font-weight:600;">Year Built</td>
<td style="padding:6px 0;border-bottom:1px solid #1e2a3a;font-size:0.9rem;color:#f0f4ff;">{{ report.property_profile.year_built or '—' }}</td>
</tr>
<tr>
<td style="padding:6px 0;border-bottom:1px solid #1e2a3a;font-size:0.8rem;color:#8899aa;font-weight:600;">Building Area</td>
<td style="padding:6px 0;border-bottom:1px solid #1e2a3a;font-size:0.9rem;color:#f0f4ff;">{{ report.property_profile.building_area or '—' }}</td>
</tr>
<tr>
<td style="padding:6px 0;border-bottom:1px solid #1e2a3a;font-size:0.8rem;color:#8899aa;font-weight:600;">Lot Area</td>
<td style="padding:6px 0;border-bottom:1px solid #1e2a3a;font-size:0.9rem;color:#f0f4ff;">{{ report.property_profile.lot_area or '—' }}</td>
</tr>
<tr>
<td style="padding:6px 0;font-size:0.8rem;color:#8899aa;font-weight:600;">Tax Year</td>
<td style="padding:6px 0;font-size:0.9rem;color:#f0f4ff;">{{ report.property_profile.tax_year or '—' }}</td>
</tr>
</table>
</td>
</tr>
{% endif %}
{# ===== Section 3: Permit History ===== #}
{% if report.permits %}
<tr>
<td style="padding:12px 28px 4px;">
<h2 style="margin:0 0 12px;font-size:1rem;color:#00d4c8;border-bottom:1px solid #1e2a3a;padding-bottom:8px;">Permit History</h2>
</td>
</tr>
<tr>
<td style="padding:0 28px 20px;">
<table role="presentation" width="100%" cellpadding="0" cellspacing="0" style="font-size:0.85rem;">
<tr style="background:#0a0e1a;">
<td style="padding:8px 8px;font-size:0.7rem;font-weight:600;color:#8899aa;text-transform:uppercase;border-bottom:2px solid #1e2a3a;">Permit #</td>
<td style="padding:8px 8px;font-size:0.7rem;font-weight:600;color:#8899aa;text-transform:uppercase;border-bottom:2px solid #1e2a3a;">Type</td>
<td style="padding:8px 8px;font-size:0.7rem;font-weight:600;color:#8899aa;text-transform:uppercase;border-bottom:2px solid #1e2a3a;">Cost</td>
<td style="padding:8px 8px;font-size:0.7rem;font-weight:600;color:#8899aa;text-transform:uppercase;border-bottom:2px solid #1e2a3a;">Status</td>
<td style="padding:8px 8px;font-size:0.7rem;font-weight:600;color:#8899aa;text-transform:uppercase;border-bottom:2px solid #1e2a3a;">Filed</td>
</tr>
{% for p in report.permits[:10] %}
<tr>
<td style="padding:8px 8px;border-bottom:1px solid #1e2a3a;">
<a href="{{ base_url }}{{ links.permit(p.permit_number) }}" style="color:#00d4c8;text-decoration:none;">{{ p.permit_number }}</a>
</td>
<td style="padding:8px 8px;border-bottom:1px solid #1e2a3a;color:#f0f4ff;">{{ p.permit_type_definition or '—' }}</td>
<td style="padding:8px 8px;border-bottom:1px solid #1e2a3a;color:#f0f4ff;">
{% if p.estimated_cost %}${{ '{:,.0f}'.format(p.estimated_cost) }}{% else %}—{% endif %}
</td>
<td style="padding:8px 8px;border-bottom:1px solid #1e2a3a;">
<span style="display:inline-block;padding:2px 6px;border-radius:3px;font-size:0.7rem;font-weight:600;
{% if (p.status or '')|lower in ('approved', 'issued', 'complete', 'completed') %}background:#0d2e1a;color:#34d399;border:1px solid #134d2a;
{% elif (p.status or '')|lower in ('expired', 'cancelled', 'revoked', 'disapproved', 'withdrawn') %}background:#3d1a1a;color:#f87171;border:1px solid #5a2020;
{% else %}background:#0a1a2e;color:#00d4c8;border:1px solid #0e2a4a;{% endif %}">
{{ p.status or 'Unknown' }}
</span>
</td>
<td style="padding:8px 8px;border-bottom:1px solid #1e2a3a;color:#8899aa;">{{ p.filed_date or '—' }}</td>
</tr>
{% if p.description %}
<tr>
<td colspan="5" style="padding:2px 8px 8px;border-bottom:1px solid #1e2a3a;font-size:0.8rem;color:#8899aa;">
{{ p.description }}
</td>
</tr>
{% endif %}
{% endfor %}
{% if report.permits|length > 10 %}
<tr>
<td colspan="5" style="padding:8px;color:#8899aa;font-size:0.8rem;">
+ {{ report.permits|length - 10 }} more permits —
<a href="{{ report_url }}" style="color:#00d4c8;text-decoration:none;">view full report</a>
</td>
</tr>
{% endif %}
</table>
</td>
</tr>
{% endif %}
{# What's Missing cross-reference analysis #}
{% if report.whats_missing %}
<tr>
<td style="padding:4px 28px 4px;">
<div style="font-size:0.85rem;font-weight:600;color:#fbbf24;margin-bottom:8px;">⚠ Cross-Reference Analysis</div>
</td>
</tr>
{% for item in report.whats_missing %}
<tr>
<td style="padding:0 28px 8px;">
<table role="presentation" width="100%" cellpadding="0" cellspacing="0">
<tr>
<td style="padding:10px 14px;border-radius:6px;border-left:4px solid {% if item.severity == 'moderate' %}#fbbf24{% else %}#00d4c8{% endif %};background:{% if item.severity == 'moderate' %}#2e2200{% else %}#0a1a2e{% endif %};">
<span style="display:inline-block;padding:1px 6px;border-radius:3px;font-size:0.65rem;font-weight:700;text-transform:uppercase;{% if item.severity == 'moderate' %}background:#4a3800;color:#fbbf24;{% else %}background:#0e2a4a;color:#00d4c8;{% endif %}">{{ item.severity }}</span>
<span style="font-weight:600;font-size:0.85rem;margin-left:6px;color:#f0f4ff;">{{ item.title }}</span>
<div style="font-size:0.8rem;color:#8899aa;margin-top:4px;">{{ item.description }}</div>
</td>
</tr>
</table>
</td>
</tr>
{% endfor %}
{% endif %}
{# ===== Section 4: Complaints & Violations ===== #}
{% if report.complaints or report.violations %}
<tr>
<td style="padding:12px 28px 4px;">
<h2 style="margin:0 0 12px;font-size:1rem;color:#00d4c8;border-bottom:1px solid #1e2a3a;padding-bottom:8px;">Complaints & Violations</h2>
</td>
</tr>
{% if report.complaints %}
<tr>
<td style="padding:0 28px 4px;">
<div style="font-size:0.85rem;font-weight:600;color:#f0f4ff;margin-bottom:8px;">Complaints</div>
</td>
</tr>
{% for c in report.complaints %}
<tr>
<td style="padding:0 28px 10px;">
<table role="presentation" width="100%" cellpadding="0" cellspacing="0">
<tr>
<td style="padding:10px 14px;background:#0a0e1a;border-radius:6px;border:1px solid #1e2a3a;">
<div style="display:inline;">
<a href="{{ base_url }}{{ links.complaint(c.complaint_number) }}" style="color:#f0f4ff;font-weight:600;text-decoration:none;font-size:0.9rem;">#{{ c.complaint_number }}</a>
<span style="display:inline-block;padding:1px 6px;border-radius:3px;font-size:0.65rem;font-weight:600;margin-left:8px;
{% if (c.status or '')|lower == 'open' %}background:#4a3800;color:#fbbf24;
{% else %}background:#134d2a;color:#34d399;{% endif %}">
{{ c.status or 'Unknown' }}
</span>
</div>
<div style="font-size:0.8rem;color:#8899aa;margin-top:2px;">Filed {{ c.date_filed or 'N/A' }}</div>
{% if c.complaint_description %}
<div style="font-size:0.85rem;color:#f0f4ff;margin-top:4px;">{{ c.complaint_description }}</div>
{% endif %}
</td>
</tr>
</table>
</td>
</tr>
{% endfor %}
{% endif %}
{% if report.violations %}
<tr>
<td style="padding:4px 28px 4px;">
<div style="font-size:0.85rem;font-weight:600;color:#f0f4ff;margin-bottom:8px;">Violations</div>
</td>
</tr>
{% for v in report.violations %}
<tr>
<td style="padding:0 28px 10px;">
<table role="presentation" width="100%" cellpadding="0" cellspacing="0">
<tr>
<td style="padding:10px 14px;background:#0a0e1a;border-radius:6px;border:1px solid #1e2a3a;">
<div style="display:inline;">
{% if v.complaint_number %}
<a href="{{ base_url }}{{ links.complaint(v.complaint_number) }}" style="color:#f0f4ff;font-weight:600;text-decoration:none;font-size:0.9rem;">#{{ v.complaint_number }}</a>
{% else %}
<span style="font-weight:600;font-size:0.9rem;color:#f0f4ff;">Violation</span>
{% endif %}
<span style="display:inline-block;padding:1px 6px;border-radius:3px;font-size:0.65rem;font-weight:600;margin-left:8px;
{% if (v.status or '')|lower == 'open' %}background:#4a3800;color:#fbbf24;
{% else %}background:#134d2a;color:#34d399;{% endif %}">
{{ v.status or 'Unknown' }}
</span>
</div>
<div style="font-size:0.8rem;color:#8899aa;margin-top:2px;">
Filed {{ v.date_filed or 'N/A' }}
{% if v.nov_category_description %} · {{ v.nov_category_description }}{% endif %}
</div>
{% if v.description %}
<div style="font-size:0.85rem;color:#f0f4ff;margin-top:4px;">{{ v.description }}</div>
{% endif %}
</td>
</tr>
</table>
</td>
</tr>
{% endfor %}
{% endif %}
{% endif %}
{# ===== Section 5: Zoning Context ===== #}
{% if report.property_profile and report.property_profile.zoning %}
<tr>
<td style="padding:12px 28px 4px;">
<h2 style="margin:0 0 12px;font-size:1rem;color:#00d4c8;border-bottom:1px solid #1e2a3a;padding-bottom:8px;">Zoning & Regulatory Context</h2>
</td>
</tr>
<tr>
<td style="padding:0 28px 20px;">
<div style="margin-bottom:8px;">
<span style="font-size:0.8rem;color:#8899aa;font-weight:600;">Zoning District:</span>
<a href="{{ links.planning_code(report.property_profile.zoning) }}" style="color:#00d4c8;text-decoration:none;font-weight:600;margin-left:4px;">{{ report.property_profile.zoning }}</a>
</div>
<div style="font-size:0.85rem;color:#8899aa;line-height:1.5;">
{% set zoning = report.property_profile.zoning %}
{% if zoning.startswith('RH-1') %}
RH-1 (Residential, House — One Family) district. Permits involving additional units or building envelope changes may require Planning review.
{% elif zoning.startswith('RH-2') %}
RH-2 (Residential, House — Two Family) district. Up to two dwelling units permitted by right.
{% elif zoning.startswith('RH-3') %}
RH-3 (Residential, House — Three Family) district. Up to three dwelling units permitted.
{% elif zoning.startswith('RM-') %}
Residential Mixed ({{ zoning }}) district. Density limits and height controls apply.
{% elif zoning.startswith('RC-') %}
Residential-Commercial ({{ zoning }}) district. Ground-floor commercial uses may be permitted.
{% elif zoning.startswith('NC-') or zoning.startswith('NCD-') %}
Neighborhood Commercial ({{ zoning }}) district. Permitted uses vary by sub-district.
{% elif zoning.startswith('C-') %}
Commercial ({{ zoning }}) district. Review permitted uses for the specific sub-district.
{% elif zoning.startswith('M-') or zoning.startswith('PDR-') %}
Production/Distribution/Repair ({{ zoning }}) district. PDR use protections apply.
{% else %}
Zoned {{ zoning }}. Review the SF Planning Code for district-specific development standards.
{% endif %}
</div>
</td>
</tr>
{% endif %}
{# ===== Section 6: Nearby Activity ===== #}
{% if report.nearby_activity %}
<tr>
<td style="padding:12px 28px 4px;">
<h2 style="margin:0 0 12px;font-size:1rem;color:#00d4c8;border-bottom:1px solid #1e2a3a;padding-bottom:8px;">Nearby Permit Activity</h2>
</td>
</tr>
<tr>
<td style="padding:0 28px 20px;">
<table role="presentation" width="100%" cellpadding="0" cellspacing="0" style="font-size:0.85rem;">
<tr style="background:#0a0e1a;">
<td style="padding:6px 8px;font-size:0.7rem;font-weight:600;color:#8899aa;text-transform:uppercase;border-bottom:2px solid #1e2a3a;">Address</td>
<td style="padding:6px 8px;font-size:0.7rem;font-weight:600;color:#8899aa;text-transform:uppercase;border-bottom:2px solid #1e2a3a;">Permit #</td>
<td style="padding:6px 8px;font-size:0.7rem;font-weight:600;color:#8899aa;text-transform:uppercase;border-bottom:2px solid #1e2a3a;">Description</td>
<td style="padding:6px 8px;font-size:0.7rem;font-weight:600;color:#8899aa;text-transform:uppercase;border-bottom:2px solid #1e2a3a;">Status</td>
</tr>
{% for n in report.nearby_activity[:6] %}
<tr>
<td style="padding:6px 8px;border-bottom:1px solid #1e2a3a;color:#f0f4ff;">{{ n.street_number }} {{ n.street_name }} {{ n.street_suffix or '' }}</td>
<td style="padding:6px 8px;border-bottom:1px solid #1e2a3a;">
<a href="{{ base_url }}{{ links.permit(n.permit_number) }}" style="color:#00d4c8;text-decoration:none;">{{ n.permit_number }}</a>
</td>
<td style="padding:6px 8px;border-bottom:1px solid #1e2a3a;color:#8899aa;">{{ n.description or '—' }}</td>
<td style="padding:6px 8px;border-bottom:1px solid #1e2a3a;">
<span style="display:inline-block;padding:1px 6px;border-radius:3px;font-size:0.7rem;font-weight:600;
{% if (n.status or '')|lower in ('approved', 'issued', 'complete', 'completed') %}background:#0d2e1a;color:#34d399;border:1px solid #134d2a;
{% elif (n.status or '')|lower in ('expired', 'cancelled') %}background:#3d1a1a;color:#f87171;border:1px solid #5a2020;
{% else %}background:#0a1a2e;color:#00d4c8;border:1px solid #0e2a4a;{% endif %}">
{{ n.status or 'Unknown' }}
</span>
</td>
</tr>
{% endfor %}
{% if report.nearby_activity|length > 6 %}
<tr>
<td colspan="4" style="padding:6px 8px;color:#8899aa;font-size:0.8rem;">
+ {{ report.nearby_activity|length - 6 }} more —
<a href="{{ report_url }}" style="color:#00d4c8;text-decoration:none;">view full report</a>
</td>
</tr>
{% endif %}
</table>
</td>
</tr>
{% endif %}
{# ===== Section 7: Consultant Assessment ===== #}
{% if report.consultant_signal and report.consultant_signal.signal != 'cold' %}
<tr>
<td style="padding:12px 28px 4px;">
<h2 style="margin:0 0 12px;font-size:1rem;color:#00d4c8;border-bottom:1px solid #1e2a3a;padding-bottom:8px;">Consultant Assessment</h2>
</td>
</tr>
<tr>
<td style="padding:0 28px 20px;">
{% set sig = report.consultant_signal %}
<table role="presentation" width="100%" cellpadding="0" cellspacing="0">
<tr>
<td style="padding:14px 16px;border-radius:6px;
{% if sig.signal == 'warm' %}background:#0a1a2e;border:1px solid #0e2a4a;
{% elif sig.signal == 'recommended' %}background:#2e2200;border:1px solid #4a3800;
{% elif sig.signal == 'strongly_recommended' %}background:#3d1a1a;border:1px solid #5a2020;
{% elif sig.signal == 'essential' %}background:#4d0e0e;border:2px solid #f87171;
{% endif %}">
{% if sig.signal == 'warm' %}
<div style="font-size:0.9rem;color:#8899aa;">
Depending on your project scope, a consultant could save time.
</div>
{% elif sig.signal == 'recommended' %}
<div style="font-size:0.9rem;color:#fbbf24;font-weight:500;">
Based on the risk profile, we recommend using a consultant for this property.
</div>
{% elif sig.signal == 'strongly_recommended' %}
<div style="font-size:0.9rem;color:#f87171;font-weight:500;">
{{ sig.message or 'A consultant is strongly advised given the circumstances of this property.' }}
</div>
{% elif sig.signal == 'essential' %}
<div style="font-size:0.9rem;color:#f87171;font-weight:700;">
{{ sig.message or 'An experienced consultant is essential for navigating the permitting process on this property.' }}
</div>
{% endif %}
{% if sig.factors %}
<div style="margin-top:8px;font-size:0.8rem;color:#8899aa;">
{% for f in sig.factors %}
• {{ f }}<br>
{% endfor %}
</div>
{% endif %}
<div style="margin-top:10px;">
<a href="{{ report_url.rsplit('/', 1)[0] if '/' in report_url else report_url }}/../consultants?block={{ report.block }}&lot={{ report.lot }}" style="color:#00d4c8;text-decoration:none;font-weight:600;font-size:0.9rem;">Find a consultant →</a>
</div>
</td>
</tr>
</table>
</td>
</tr>
{% endif %}
<!-- CTA -->
<tr>
<td align="center" style="padding:8px 28px 28px;">
<a href="{{ report_url }}" style="display:inline-block;padding:12px 32px;background:#00d4c8;color:#0a0e1a;text-decoration:none;border-radius:8px;font-weight:600;font-size:0.95rem;">
View Full Report
</a>
</td>
</tr>
<!-- Footer -->
<tr>
<td style="padding:20px 28px;background:#0a0e1a;border-top:1px solid #1e2a3a;">
<p style="margin:0 0 8px;font-size:0.75rem;color:#8899aa;text-align:center;">
Data from <a href="https://data.sfgov.org" style="color:#00d4c8;text-decoration:none;">SF Open Data</a>.
This report was generated automatically and may not reflect the most recent changes.
</p>
<p style="margin:0;font-size:0.75rem;color:#8899aa;text-align:center;">
Sent by <a href="{{ report_url.split('/report')[0] if '/report' in report_url else report_url }}" style="color:#00d4c8;text-decoration:none;">sfpermits.ai</a>
·
<a href="{{ report_url.split('/report')[0] if '/report' in report_url else report_url }}/account" style="color:#00d4c8;text-decoration:none;">Manage preferences</a>
</p>
</td>
</tr>
</table>
</td>
</tr>
</table>
</body>
</html>
