#!/usr/bin/env python3
"""
Altria pfSense → CRM Integration
Polls pfSense gateway status via REST API and creates CRM tickets/alerts.
Run this on any machine that can reach 192.168.10.2 (your local network).
"""
import os, sys, json, sqlite3, logging, urllib.request, ssl
from datetime import datetime, timezone

def _now():
    return datetime.now(timezone.utc)
from pathlib import Path

BASE_DIR = Path(__file__).parent
ENV_FILE = BASE_DIR / '.env'

def _load_env():
    if not ENV_FILE.exists(): return
    for line in ENV_FILE.read_text().splitlines():
        line = line.strip()
        if line and not line.startswith('#') and '=' in line:
            k, v = line.split('=', 1)
            os.environ.setdefault(k.strip(), v.strip())
_load_env()

PFSENSE_URL        = os.environ.get('PFSENSE_URL', 'https://192.168.10.2/api/v2/status/gateways')
PFSENSE_API_KEY    = os.environ.get('PFSENSE_API_KEY', '')
CRM_WEBHOOK_URL    = os.environ.get('CRM_WEBHOOK_URL', 'https://crm.altriacallcenter.com/api/webhooks/email/')
CRM_WEBHOOK_SECRET = os.environ.get('CRM_WEBHOOK_SECRET', '')
DELAY_ALERT_MS     = float(os.environ.get('PFSENSE_DELAY_ALERT_MS', '200'))
LOSS_ALERT_PCT     = float(os.environ.get('PFSENSE_LOSS_ALERT_PCT', '5'))

STATE_DB = BASE_DIR / 'pfsense_state.db'

def _init_state():
    conn = sqlite3.connect(str(STATE_DB))
    conn.execute('''CREATE TABLE IF NOT EXISTS gw_state
        (name TEXT PRIMARY KEY, last_status TEXT, alerted_at TEXT)''')
    conn.commit()
    return conn

def _get_gw_state(conn, name):
    row = conn.execute('SELECT last_status FROM gw_state WHERE name=?', (name,)).fetchone()
    return row[0] if row else 'online'

def _set_gw_state(conn, name, status):
    conn.execute('INSERT OR REPLACE INTO gw_state VALUES (?,?,?)',
        (name, status, _now().isoformat()))
    conn.commit()

LOG_DIR = BASE_DIR / 'logs'
LOG_DIR.mkdir(exist_ok=True)
logging.basicConfig(
    level=logging.INFO,
    format='%(asctime)s %(levelname)s %(message)s',
    handlers=[
        logging.FileHandler(str(LOG_DIR / 'pfsense_triage.log')),
        logging.StreamHandler(sys.stdout),
    ],
)
log = logging.getLogger(__name__)


def fetch_gateways():
    ctx = ssl.create_default_context()
    ctx.check_hostname = False
    ctx.verify_mode = ssl.CERT_NONE
    req = urllib.request.Request(PFSENSE_URL, headers={'X-API-Key': PFSENSE_API_KEY})
    with urllib.request.urlopen(req, context=ctx, timeout=10) as resp:
        return json.loads(resp.read())['data']


def send_to_crm(action, priority, subject, body, alert_msg=''):
    payload = json.dumps({
        'email_id':          f'pfsense-{_now().strftime("%Y%m%d%H%M%S")}',
        'from':              'pfsense@network.local',
        'from_name':         'pfSense Network Monitor',
        'subject':           subject,
        'body':              body,
        '_ai_action':        action,
        '_ai_priority':      priority,
        '_ai_sentiment':     'neutral',
        '_ai_category':      'technical',
        '_ai_summary':       subject,
        '_ai_alert_message': alert_msg,
        'source':            'pfsense',
    }).encode()
    req = urllib.request.Request(CRM_WEBHOOK_URL, data=payload, method='POST', headers={
        'Content-Type':     'application/json',
        'Content-Length':   str(len(payload)),
        'X-Webhook-Secret': CRM_WEBHOOK_SECRET,
    })
    try:
        ctx = ssl.create_default_context()
        with urllib.request.urlopen(req, context=ctx, timeout=15) as resp:
            log.info("CRM: %s %s", resp.status, resp.read(300).decode(errors='replace'))
            return True
    except Exception as e:
        log.error("CRM error: %s", e)
        return False


def main():
    state = _init_state()
    try:
        gateways = fetch_gateways()
    except Exception as e:
        log.error("pfSense API error: %s", e)
        sys.exit(1)

    log.info("Checking %d gateways", len(gateways))

    for gw in gateways:
        name      = gw['name']
        status    = gw['status']
        delay     = float(gw.get('delay', 0) or 0)
        loss      = float(gw.get('loss', 0) or 0)
        srcip     = gw.get('srcip', '')
        substatus = gw.get('substatus', '')
        prev      = _get_gw_state(state, name)

        log.info("GW %-20s status=%-8s delay=%6.1fms loss=%4.0f%%", name, status, delay, loss)

        # Gateway DOWN
        if status != 'online':
            if prev == 'online':
                log.warning("ALERT: %s is %s", name, status)
                send_to_crm(
                    action='alert', priority='critical',
                    subject=f'[NETWORK DOWN] Gateway {name} is {status.upper()}',
                    body=(
                        f'Gateway:    {name}\n'
                        f'Status:     {status.upper()}\n'
                        f'Substatus:  {substatus}\n'
                        f'Source IP:  {srcip}\n'
                        f'Time:       {_now()} UTC\n\n'
                        f'Internet failover may be active. Immediate attention required.'
                    ),
                    alert_msg=f'Gateway {name} ({srcip}) is {status.upper()}. Internet may be down.',
                )
            _set_gw_state(state, name, status)
            continue

        # Recovery
        if status == 'online' and prev not in ('online',):
            log.info("RECOVERY: %s back online", name)
            send_to_crm(
                action='ticket', priority='medium',
                subject=f'[NETWORK RECOVERED] Gateway {name} is back online',
                body=(
                    f'Gateway:    {name}\n'
                    f'Status:     ONLINE\n'
                    f'Source IP:  {srcip}\n'
                    f'Latency:    {delay:.1f}ms\n'
                    f'Loss:       {loss:.0f}%\n'
                    f'Recovered:  {_now()} UTC'
                ),
            )
            _set_gw_state(state, name, 'online')
            continue

        # High packet loss
        if loss >= LOSS_ALERT_PCT:
            log.warning("HIGH LOSS: %s loss=%.0f%%", name, loss)
            send_to_crm(
                action='alert', priority='high',
                subject=f'[NETWORK DEGRADED] Gateway {name} — {loss:.0f}% packet loss',
                body=(
                    f'Gateway:      {name}\n'
                    f'Packet Loss:  {loss:.0f}%\n'
                    f'Latency:      {delay:.1f}ms\n'
                    f'Source IP:    {srcip}\n'
                    f'Time:         {_now()} UTC'
                ),
                alert_msg=f'Gateway {name} has {loss:.0f}% packet loss. Connection is degraded.',
            )
            _set_gw_state(state, name, 'degraded')
            continue

        # High latency (ticket, not alert)
        if delay >= DELAY_ALERT_MS:
            log.warning("HIGH LATENCY: %s delay=%.1fms", name, delay)
            send_to_crm(
                action='ticket', priority='medium',
                subject=f'[NETWORK SLOW] Gateway {name} — {delay:.0f}ms latency',
                body=(
                    f'Gateway:    {name}\n'
                    f'Latency:    {delay:.1f}ms  (threshold: {DELAY_ALERT_MS:.0f}ms)\n'
                    f'Loss:       {loss:.0f}%\n'
                    f'Source IP:  {srcip}\n'
                    f'Time:       {_now()} UTC'
                ),
            )

        _set_gw_state(state, name, 'online')

    state.close()
    log.info("Done.")


if __name__ == '__main__':
    main()
