$_POST['project_id'] ?? null, 'title' => trim($_POST['title'] ?? ''), 'event_type' => $_POST['event_type'] ?? 'post', 'event_date' => $_POST['event_date'] ?? null, 'event_time' => $_POST['event_time'] ?: null, 'description' => trim($_POST['description'] ?? ''), 'color' => $_POST['color'] ?? '#4F46E5'];
if (!empty($data['title']) && $data['event_date']) {
try { $pdo->prepare("INSERT INTO " . DB_PREFIX . "calendar_events (project_id, title, event_type, event_date, event_time, description, color, created_by) VALUES (?, ?, ?, ?, ?, ?, ?, ?)")->execute([$data['project_id'], $data['title'], $data['event_type'], $data['event_date'], $data['event_time'], $data['description'], $data['color'], $_SESSION['user_id']]); $message = ['type' => 'success', 'text' => 'Событие добавлено']; }
catch (Exception $e) { $message = ['type' => 'error', 'text' => 'Ошибка']; }
}
}
if (isset($_GET['delete']) && is_numeric($_GET['delete'])) { try { $pdo->prepare("DELETE FROM " . DB_PREFIX . "calendar_events WHERE id = ?")->execute([$_GET['delete']]); $message = ['type' => 'success', 'text' => 'Событие удалено']; } catch (Exception $e) { $message = ['type' => 'error', 'text' => 'Ошибка']; } }
$stmt = $pdo->query("SELECT id, name FROM " . DB_PREFIX . "projects WHERE status = 'active' ORDER BY name");
$projects = $stmt->fetchAll();
$month = (int)($_GET['month'] ?? date('m'));
$year = (int)($_GET['year'] ?? date('Y'));
$firstDay = mktime(0, 0, 0, $month, 1, $year);
$daysInMonth = date('t', $firstDay);
$startWeekday = date('w', $firstDay) ?: 7;
$monthName = ['', 'Январь', 'Февраль', 'Март', 'Апрель', 'Май', 'Июнь', 'Июль', 'Август', 'Сентябрь', 'Октябрь', 'Ноябрь', 'Декабрь'][$month];
$prevMonth = $month - 1; $prevYear = $year; if ($prevMonth < 1) { $prevMonth = 12; $prevYear--; }
$nextMonth = $month + 1; $nextYear = $year; if ($nextMonth > 12) { $nextMonth = 1; $nextYear++; }
$startDate = "$year-" . str_pad($month, 2, '0', STR_PAD_LEFT) . "-01";
$endDate = "$year-" . str_pad($month, 2, '0', STR_PAD_LEFT) . "-$daysInMonth";
$stmt = $pdo->prepare("SELECT e.*, p.name as project_name FROM " . DB_PREFIX . "calendar_events e LEFT JOIN " . DB_PREFIX . "projects p ON e.project_id = p.id WHERE e.event_date BETWEEN ? AND ? ORDER BY e.event_date, e.event_time");
$stmt->execute([$startDate, $endDate]); $events = $stmt->fetchAll();
$eventsByDay = [];
foreach ($events as $event) { $day = (int)date('j', strtotime($event['event_date'])); if (!isset($eventsByDay[$day])) $eventsByDay[$day] = []; $eventsByDay[$day][] = $event; }
$eventTypes = ['post' => 'Публикация', 'story' => 'Stories', 'campaign' => 'Кампания', 'meeting' => 'Встреча', 'deadline' => 'Дедлайн'];
$eventColors = ['#4F46E5', '#10B981', '#F59E0B', '#EF4444', '#8B5CF6', '#EC4899', '#06B6D4', '#84CC16'];
?>