db = $database->getConnection(); } public function getAllPlatforms() { try { $query = "SELECT * FROM external_platforms ORDER BY region, name"; $stmt = $this->db->prepare($query); $stmt->execute(); return $stmt->fetchAll(); } catch (Exception $e) { error_log("Get all platforms error: " . $e->getMessage()); return []; } } public function updatePlatform($id, $api_key, $username, $password, $is_active) { try { $query = "UPDATE external_platforms SET api_key = :api_key, username = :username, password = :password, is_active = :is_active WHERE id = :id"; $stmt = $this->db->prepare($query); $stmt->bindParam(':id', $id); $stmt->bindParam(':api_key', $api_key); $stmt->bindParam(':username', $username); $stmt->bindParam(':password', $password); $stmt->bindParam(':is_active', $is_active); return $stmt->execute(); } catch (Exception $e) { error_log("Update platform error: " . $e->getMessage()); return false; } } } $platformManager = new PlatformManager(); $publisher = new Publisher(); $message = ''; $error = ''; // Handle form submissions if ($_SERVER['REQUEST_METHOD'] === 'POST') { if (isset($_POST['action'])) { switch ($_POST['action']) { case 'update_platform': $id = (int)$_POST['id']; $api_key = sanitize_input($_POST['api_key']); $username = sanitize_input($_POST['username']); $password = sanitize_input($_POST['password']); $is_active = isset($_POST['is_active']) ? 1 : 0; if ($platformManager->updatePlatform($id, $api_key, $username, $password, $is_active)) { $message = __('platform_updated_successfully') ?? 'Platform updated successfully'; } else { $error = __('platform_update_failed') ?? 'Failed to update platform'; } break; case 'test_publish': $articleId = (int)$_POST['article_id']; $result = $publisher->publishToExternalPlatforms($articleId); if ($result) { $message = __('test_publish_successful') ?? 'Test publishing completed'; } else { $error = __('test_publish_failed') ?? 'Test publishing failed'; } break; case 'retry_failed': $retryCount = $publisher->retryFailedPublishing(); $message = sprintf(__('retry_completed') ?? 'Retried %d failed publications', $retryCount); break; } } } $platforms = $platformManager->getAllPlatforms(); $publishingHistory = $publisher->getPublishingHistory(); // Get recent published articles for testing $article = new Article(); $recentArticles = $article->getAll('external', 5, 0, null, 'published', ''); ?>

'primary', 'europe' => 'success', 'asia' => 'warning', 'global' => 'info' ]; $regionLabels = [ 'america' => 'Americas', 'europe' => 'Europe', 'asia' => 'Asia', 'global' => 'Global' ]; ?>

... -
0 ? round(($successCount / count($publishingHistory)) * 100) : 0; ?>%

:

'Americas', 'europe' => 'Europe', 'asia' => 'Asia', 'global' => 'Global' ]; ?> 'primary', 'europe' => 'success', 'asia' => 'warning', 'global' => 'info' ]; foreach ($regionCounts as $region => $count): ?>
platforms