query("SELECT COUNT(*) as count FROM " . DB_PREFIX . "clients WHERE status = 'active'");
$stats['clients'] = $stmt->fetch()['count'];
$stmt = $pdo->query("SELECT COUNT(*) as count FROM " . DB_PREFIX . "projects WHERE status = 'active'");
$stats['projects'] = $stmt->fetch()['count'];
$stmt = $pdo->query("SELECT COUNT(*) as count FROM " . DB_PREFIX . "posts");
$stats['posts'] = $stmt->fetch()['count'];
$stmt = $pdo->query("SELECT COUNT(*) as count FROM " . DB_PREFIX . "posts WHERE status = 'scheduled'");
$stats['scheduled'] = $stmt->fetch()['count'];
$stmt = $pdo->query("SELECT COUNT(*) as count FROM " . DB_PREFIX . "tasks WHERE status IN ('pending', 'in_progress')");
$stats['tasks'] = $stmt->fetch()['count'];
$stmt = $pdo->query("SELECT p.*, pr.name as project_name FROM " . DB_PREFIX . "posts p LEFT JOIN " . DB_PREFIX . "projects pr ON p.project_id = pr.id ORDER BY p.created_at DESC LIMIT 5");
$recentPosts = $stmt->fetchAll();
$stmt = $pdo->query("SELECT t.*, p.name as project_name, u.login as assigned_name FROM " . DB_PREFIX . "tasks t LEFT JOIN " . DB_PREFIX . "projects p ON t.project_id = p.id LEFT JOIN " . DB_PREFIX . "users u ON t.assigned_to = u.id ORDER BY t.created_at DESC LIMIT 5");
$recentTasks = $stmt->fetchAll();
$stmt = $pdo->query("SELECT * FROM " . DB_PREFIX . "calendar_events WHERE event_date >= CURDATE() ORDER BY event_date, event_time LIMIT 5");
$upcomingEvents = $stmt->fetchAll();
$stmt = $pdo->query("SELECT platform, COUNT(*) as count FROM " . DB_PREFIX . "posts GROUP BY platform");
$platformStats = $stmt->fetchAll();
?>
| Проект | Платформа | Тип | Статус | Дата |
|---|
|
|
|
|
|
| Публикаций пока нет |
| Задача | Проект | Исполнитель | Статус | Срок |
|---|
|
|
|
|
|
| Задач пока нет |