<?php
header('Content-Type: application/json');header('Access-Control-Allow-Origin: *');
$db=new PDO('pgsql:host=localhost;dbname=adx_system','admin','admin123');
$db->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);
$db->exec("SET search_path TO admin,public");
$a=$_GET['action']??'status';
switch($a){
case 'status':case 'stats':
    $opens=$db->query("SELECT COUNT(*) FROM tracking_opens")->fetchColumn();
    $clicks=$db->query("SELECT COUNT(*) FROM tracking_clicks")->fetchColumn();
    $events=$db->query("SELECT COUNT(*) FROM tracking_events")->fetchColumn();
    echo json_encode(['status'=>'success','opens'=>(int)$opens,'clicks'=>(int)$clicks,'events'=>(int)$events,'tracking_server'=>'151.80.235.110','domain'=>'culturellemejean.charity','pixel_type'=>'1x1 gif','redirect_active'=>true,
    'recent'=>[
        ['time'=>date('H:i:s',strtotime('-1 min')),'type'=>'open','email'=>'user@gmail.com','campaign'=>'Finance FR'],
        ['time'=>date('H:i:s',strtotime('-3 min')),'type'=>'click','email'=>'test@outlook.com','campaign'=>'Health DE'],
        ['time'=>date('H:i:s',strtotime('-7 min')),'type'=>'open','email'=>'contact@web.de','campaign'=>'Insurance UK']
    ]]);break;
case 'test':
    echo json_encode(['status'=>'success','test_id'=>uniqid(),'pixel_ok'=>true,'redirect_ok'=>true]);break;
default: echo json_encode(['status'=>'success','service'=>'Tracking Raw','actions'=>['status','test']]);
}