requireLogin();
// Get brands data
require_once '../config/database.php';
$database = new Database();
$db = $database->getConnection();
$brands = [];
$query = "SELECT * FROM brands ORDER BY created_at DESC";
$stmt = $db->prepare($query);
$stmt->execute();
$brands = $stmt->fetchAll(PDO::FETCH_ASSOC);
// Get content plans
$plans_query = "SELECT cp.*, b.name as brand_name FROM content_plans cp
LEFT JOIN brands b ON cp.brand_id = b.id
ORDER BY cp.created_at DESC LIMIT 10";
$plans_stmt = $db->prepare($plans_query);
$plans_stmt->execute();
$recent_plans = $plans_stmt->fetchAll(PDO::FETCH_ASSOC);
?>
<?php echo t('page_title'); ?>
t('status_active'),
'paused' => t('status_paused'),
'completed' => t('status_completed'),
'draft' => t('article_draft'),
'in_progress' => t('status_active'),
'published' => t('article_published'),
'scheduled' => t('article_scheduled')
];
return $statuses[$status] ?? $status;
}
function getArticleStatusName($status) {
$statuses = [
'draft' => t('article_draft'),
'published' => t('article_published'),
'scheduled' => t('article_scheduled')
];
return $statuses[$status] ?? $status;
}
?>