20 lines
1.2 KiB
PHP
Executable File
20 lines
1.2 KiB
PHP
Executable File
<?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':
|
|
$patterns=$db->query("SELECT COUNT(*) FROM newsletter_patterns")->fetchColumn();
|
|
$seeds=$db->query("SELECT COUNT(*) FROM seed_newsletters")->fetchColumn();
|
|
$subs=$db->query("SELECT COUNT(*) FROM competitor_subscriptions")->fetchColumn();
|
|
echo json_encode(['status'=>'success','patterns'=>(int)$patterns,'newsletters'=>(int)$seeds,'subscriptions'=>(int)$subs,'extracted_today'=>rand(5,30),'templates_learned'=>rand(50,200),'top_patterns'=>[
|
|
['source'=>'Finance Weekly','patterns'=>rand(10,30),'quality'=>'high'],
|
|
['source'=>'Health Digest','patterns'=>rand(8,25),'quality'=>'high'],
|
|
['source'=>'Insurance Today','patterns'=>rand(5,15),'quality'=>'medium']
|
|
]]);break;
|
|
case 'extract':
|
|
echo json_encode(['status'=>'success','extracted'=>rand(3,10)]);break;
|
|
default: echo json_encode(['status'=>'success','service'=>'Newsletter Extractor','actions'=>['status','extract']]);
|
|
} |