prepare("DELETE FROM " . DB_PREFIX . "posts WHERE id = ?")->execute([$_GET['delete']]); $message = ['type' => 'success', 'text' => 'Публикация удалена']; } catch (Exception $e) { $message = ['type' => 'error', 'text' => 'Ошибка']; } } if ($_SERVER['REQUEST_METHOD'] === 'POST') { $id = $_POST['post_id'] ?? null; $data = ['project_id' => $_POST['project_id'] ?? null, 'title' => trim($_POST['title'] ?? ''), 'content' => trim($_POST['content'] ?? ''), 'platform' => $_POST['platform'] ?? 'instagram', 'post_type' => $_POST['post_type'] ?? 'image', 'status' => $_POST['status'] ?? 'draft', 'scheduled_at' => $_POST['scheduled_at'] ?: null]; if (empty($data['title'])) { $message = ['type' => 'error', 'text' => 'Укажите заголовок']; } else { try { if ($id) { $pdo->prepare("UPDATE " . DB_PREFIX . "posts SET project_id=?, title=?, content=?, platform=?, post_type=?, status=?, scheduled_at=? WHERE id=?")->execute([$data['project_id'], $data['title'], $data['content'], $data['platform'], $data['post_type'], $data['status'], $data['scheduled_at'], $id]); $message = ['type' => 'success', 'text' => 'Публикация обновлена']; } else { $pdo->prepare("INSERT INTO " . DB_PREFIX . "posts (project_id, title, content, platform, post_type, status, scheduled_at, created_by) VALUES (?, ?, ?, ?, ?, ?, ?, ?)")->execute([$data['project_id'], $data['title'], $data['content'], $data['platform'], $data['post_type'], $data['status'], $data['scheduled_at'], $_SESSION['user_id']]); $message = ['type' => 'success', 'text' => 'Публикация создана']; } } catch (Exception $e) { $message = ['type' => 'error', 'text' => 'Ошибка: ' . $e->getMessage()]; } } } if (isset($_GET['edit']) && is_numeric($_GET['edit'])) { $stmt = $pdo->prepare("SELECT * FROM " . DB_PREFIX . "posts WHERE id = ?"); $stmt->execute([$_GET['edit']]); $editPost = $stmt->fetch(); } $stmt = $pdo->query("SELECT id, name FROM " . DB_PREFIX . "projects WHERE status = 'active' ORDER BY name"); $projects = $stmt->fetchAll(); $filter = $_GET['filter'] ?? 'all'; $sql = "SELECT p.*, pr.name as project_name, u.login as author FROM " . DB_PREFIX . "posts p LEFT JOIN " . DB_PREFIX . "projects pr ON p.project_id = pr.id LEFT JOIN " . DB_PREFIX . "users u ON p.created_by = u.id WHERE 1=1"; $params = []; if ($filter !== 'all') { $sql .= " AND p.status = ?"; $params[] = $filter; } $sql .= " ORDER BY p.created_at DESC"; $stmt = $pdo->prepare($sql); $stmt->execute($params); $posts = $stmt->fetchAll(); $platforms = ['instagram', 'facebook', 'vk', 'telegram', 'tiktok', 'youtube', 'twitter', 'linkedin']; $postTypes = ['image' => 'Изображение', 'video' => 'Видео', 'carousel' => 'Карусель', 'story' => 'Stories', 'reels' => 'Reels', 'text' => 'Текст']; ?>
Все Черновики Запланировано Опубликовано
ПубликацияПроектПлатформаТипСтатусДатаДействия
60 ? '...' : ''; ?>
Публикаций не найдено