Jacek Pyziak
167ced3573
- Added a new field to display the cron URL plan in user settings. - Updated JavaScript to handle the new plan data. refactor: Unify product model and migrate data - Migrated product data from `products_data` to `products` table. - Added new columns to `products` for better data organization. - Created `products_aggregate` table for storing aggregated product metrics. chore: Drop deprecated products_data table - Removed `products_data` table as data is now stored in `products`. feat: Add merchant URL flags to products - Introduced flags for tracking merchant URL status in `products` table. - Normalized product URLs to handle empty or invalid values. feat: Link campaign alerts to specific products - Added `product_id` column to `campaign_alerts` table for better tracking. - Created an index for efficient querying of alerts by product. chore: Add debug scripts for client data inspection - Created debug scripts to inspect client data from local and remote databases. - Included error handling and output formatting for better readability.
36 lines
1.3 KiB
PHP
36 lines
1.3 KiB
PHP
<?php
|
|
error_reporting(E_ALL);
|
|
ini_set('display_errors', '1');
|
|
require 'config.php';
|
|
require 'libraries/medoo/medoo.php';
|
|
|
|
$host = $database['remote_host'];
|
|
try {
|
|
$mdb = new medoo([
|
|
'database_type' => 'mysql',
|
|
'database_name' => $database['name'],
|
|
'server' => $host,
|
|
'username' => $database['user'],
|
|
'password' => $database['password'],
|
|
'charset' => 'utf8'
|
|
]);
|
|
|
|
echo "CONNECTED_REMOTE=" . $host . PHP_EOL;
|
|
|
|
$rows = $mdb->query("SELECT id, name, COALESCE(active,0) AS active, COALESCE(deleted,0) AS deleted, CONCAT('[', COALESCE(google_ads_customer_id,''), ']') AS google_ads_customer_id FROM clients ORDER BY id ASC")->fetchAll(PDO::FETCH_ASSOC);
|
|
echo "CLIENTS_TOTAL=" . count($rows) . PHP_EOL;
|
|
foreach ($rows as $r) {
|
|
echo json_encode($r, JSON_UNESCAPED_UNICODE|JSON_UNESCAPED_SLASHES) . PHP_EOL;
|
|
}
|
|
|
|
$eligible = $mdb->query("SELECT id, name FROM clients WHERE COALESCE(deleted,0)=0 AND COALESCE(active,0)=1 AND TRIM(COALESCE(google_ads_customer_id,''))<>'' ORDER BY id ASC")->fetchAll(PDO::FETCH_ASSOC);
|
|
echo "ELIGIBLE_TOTAL=" . count($eligible) . PHP_EOL;
|
|
foreach ($eligible as $e) {
|
|
echo "ELIGIBLE=" . json_encode($e, JSON_UNESCAPED_UNICODE|JSON_UNESCAPED_SLASHES) . PHP_EOL;
|
|
}
|
|
|
|
} catch (Throwable $e) {
|
|
echo "ERR=" . $e->getMessage() . PHP_EOL;
|
|
}
|
|
?>
|