60 lines
2.1 KiB
PHP
60 lines
2.1 KiB
PHP
<?php
|
|
session_start();
|
|
require_once 'db/config.php';
|
|
|
|
if (!isset($_SESSION['user_id'])) {
|
|
header("Location: login.php");
|
|
exit();
|
|
}
|
|
|
|
$userId = $_SESSION['user_id'];
|
|
|
|
try {
|
|
$pdo = db();
|
|
$stmt = $pdo->prepare(
|
|
'SELECT id, title, description, status, created_at
|
|
FROM tasks
|
|
WHERE user_id = :user_id
|
|
ORDER BY created_at DESC'
|
|
);
|
|
$stmt->bindParam(':user_id', $userId, PDO::PARAM_INT);
|
|
$stmt->execute();
|
|
$tasks = $stmt->fetchAll(PDO::FETCH_ASSOC);
|
|
} catch (PDOException $e) {
|
|
die("Database error: Could not retrieve your tasks.");
|
|
}
|
|
|
|
$pageTitle = __('manage_tasks_title');
|
|
include 'shared/header.php';
|
|
?>
|
|
|
|
<div class="container">
|
|
<div class="page-header">
|
|
<h1><?= __('manage_tasks_title') ?></h1>
|
|
<p><?= __('manage_tasks_description') ?></p>
|
|
</div>
|
|
|
|
<?php if (empty($tasks)): ?>
|
|
<div class="alert alert-info"><?= __('no_posted_tasks_link') ?></div>
|
|
<?php else: ?>
|
|
<div class="tasks-list">
|
|
<?php foreach ($tasks as $task): ?>
|
|
<div class="task-manage-card">
|
|
<div class="task-info">
|
|
<h2><a href="manage-task.php?id=<?php echo $task['id']; ?>"><?php echo htmlspecialchars($task['title']); ?></a></h2>
|
|
<p><?php echo htmlspecialchars(substr($task['description'], 0, 100)); ?>...</p>
|
|
</div>
|
|
<div class="task-status-manage">
|
|
<?= __('task_status_label') ?>: <span class="status-badge status-<?php echo strtolower(htmlspecialchars($task['status'])); ?>"><?php echo htmlspecialchars($task['status']); ?></span>
|
|
</div>
|
|
<div class="task-actions">
|
|
<a href="delete-task.php?id=<?php echo $task['id']; ?>" class="btn btn-danger btn-sm" onclick="return confirm('<?= __('delete_task_confirm') ?>');"><?= __('delete') ?></a>
|
|
</div>
|
|
</div>
|
|
<?php endforeach; ?>
|
|
</div>
|
|
<?php endif; ?>
|
|
</div>
|
|
|
|
<?php include 'shared/footer.php'; ?>
|