prepare("DELETE FROM " . DB_PREFIX . "tasks WHERE id = ?")->execute([$_GET['delete']]); $message = ['type' => 'success', 'text' => 'Задача удалена']; } catch (Exception $e) { $message = ['type' => 'error', 'text' => 'Ошибка']; } } if ($_SERVER['REQUEST_METHOD'] === 'POST') { $id = $_POST['task_id'] ?? null; $data = ['project_id' => $_POST['project_id'] ?? null, 'title' => trim($_POST['title'] ?? ''), 'description' => trim($_POST['description'] ?? ''), 'assigned_to' => $_POST['assigned_to'] ?: null, 'priority' => $_POST['priority'] ?? 'medium', 'status' => $_POST['status'] ?? 'pending', 'due_date' => $_POST['due_date'] ?: null]; if (empty($data['title'])) { $message = ['type' => 'error', 'text' => 'Укажите название задачи']; } else { try { if ($id) { $pdo->prepare("UPDATE " . DB_PREFIX . "tasks SET project_id=?, title=?, description=?, assigned_to=?, priority=?, status=?, due_date=? WHERE id=?")->execute([$data['project_id'], $data['title'], $data['description'], $data['assigned_to'], $data['priority'], $data['status'], $data['due_date'], $id]); $message = ['type' => 'success', 'text' => 'Задача обновлена']; } else { $pdo->prepare("INSERT INTO " . DB_PREFIX . "tasks (project_id, title, description, assigned_to, priority, status, due_date, created_by) VALUES (?, ?, ?, ?, ?, ?, ?, ?)")->execute([$data['project_id'], $data['title'], $data['description'], $data['assigned_to'], $data['priority'], $data['status'], $data['due_date'], $_SESSION['user_id']]); $message = ['type' => 'success', 'text' => 'Задача создана']; } } catch (Exception $e) { $message = ['type' => 'error', 'text' => 'Ошибка']; } } } if (isset($_GET['edit']) && is_numeric($_GET['edit'])) { $stmt = $pdo->prepare("SELECT * FROM " . DB_PREFIX . "tasks WHERE id = ?"); $stmt->execute([$_GET['edit']]); $editTask = $stmt->fetch(); } $stmt = $pdo->query("SELECT id, name FROM " . DB_PREFIX . "projects WHERE status = 'active' ORDER BY name"); $projects = $stmt->fetchAll(); $stmt = $pdo->query("SELECT id, login FROM " . DB_PREFIX . "users WHERE status = 'active' ORDER BY login"); $users = $stmt->fetchAll(); $filter = $_GET['filter'] ?? 'all'; $sql = "SELECT t.*, p.name as project_name, u.login as assigned_name, c.login as creator_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 LEFT JOIN " . DB_PREFIX . "users c ON t.created_by = c.id WHERE 1=1"; $params = []; if ($filter !== 'all') { $sql .= " AND t.status = ?"; $params[] = $filter; } $sql .= " ORDER BY t.due_date IS NULL, t.due_date ASC, t.priority DESC"; $stmt = $pdo->prepare($sql); $stmt->execute($params); $tasks = $stmt->fetchAll(); $priorityColors = ['low' => 'green', 'medium' => 'yellow', 'high' => 'orange', 'urgent' => 'red']; $priorityLabels = ['low' => 'Низкий', 'medium' => 'Средний', 'high' => 'Высокий', 'urgent' => 'Срочный']; ?>

Просрочено

Задач не найдено