prepare("DELETE FROM " . DB_PREFIX . "projects WHERE id = ?")->execute([$_GET['delete']]); $message = ['type' => 'success', 'text' => 'Проект удален']; } catch (Exception $e) { $message = ['type' => 'error', 'text' => 'Ошибка']; } } if ($_SERVER['REQUEST_METHOD'] === 'POST') { $id = $_POST['project_id'] ?? null; $platforms = isset($_POST['platforms']) ? json_encode($_POST['platforms']) : null; $data = ['client_id' => $_POST['client_id'] ?? null, 'name' => trim($_POST['name'] ?? ''), 'description' => trim($_POST['description'] ?? ''), 'platforms' => $platforms, 'status' => $_POST['status'] ?? 'active', 'budget' => $_POST['budget'] ?? 0, 'start_date' => $_POST['start_date'] ?: null, 'end_date' => $_POST['end_date'] ?: null]; if (empty($data['name']) || empty($data['client_id'])) { $message = ['type' => 'error', 'text' => 'Укажите название и клиента']; } else { try { if ($id) { $pdo->prepare("UPDATE " . DB_PREFIX . "projects SET client_id=?, name=?, description=?, platforms=?, status=?, budget=?, start_date=?, end_date=? WHERE id=?")->execute([$data['client_id'], $data['name'], $data['description'], $data['platforms'], $data['status'], $data['budget'], $data['start_date'], $data['end_date'], $id]); $message = ['type' => 'success', 'text' => 'Проект обновлен']; } else { $pdo->prepare("INSERT INTO " . DB_PREFIX . "projects (client_id, name, description, platforms, status, budget, start_date, end_date) VALUES (?, ?, ?, ?, ?, ?, ?, ?)")->execute([$data['client_id'], $data['name'], $data['description'], $data['platforms'], $data['status'], $data['budget'], $data['start_date'], $data['end_date']]); $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 . "projects WHERE id = ?"); $stmt->execute([$_GET['edit']]); $editProject = $stmt->fetch(); } $stmt = $pdo->query("SELECT id, name FROM " . DB_PREFIX . "clients WHERE status = 'active' ORDER BY name"); $clients = $stmt->fetchAll(); $stmt = $pdo->query("SELECT p.*, c.name as client_name FROM " . DB_PREFIX . "projects p LEFT JOIN " . DB_PREFIX . "clients c ON p.client_id = c.id ORDER BY p.created_at DESC"); $projects = $stmt->fetchAll(); $platformsList = ['instagram', 'facebook', 'vk', 'telegram', 'tiktok', 'youtube', 'twitter', 'linkedin']; ?>
Проекты
'Активен', 'paused' => 'Приостановлен', 'completed' => 'Завершен', 'cancelled' => 'Отменен']; ?>
0): ?>

Проектов пока нет