-
Notifications
You must be signed in to change notification settings - Fork 0
/
tasks_assigned_by_me.php
78 lines (58 loc) · 2.25 KB
/
tasks_assigned_by_me.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
<?php
session_start();
if (!isset($_SESSION['email'])) {
die("User not logged in.");
}
$loggedInUserEmail = $_SESSION['email'];
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "signup";
$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
$sql = "SELECT group_tasks.*, task_status.assignee_email, task_status.completornot, task_status.completed_at
FROM group_tasks
LEFT JOIN task_status ON group_tasks.task_id = task_status.task_id
WHERE group_tasks.assigner_email = '$loggedInUserEmail'";
$result = $conn->query($sql);
$tasks = array();
if ($result->num_rows > 0) {
while($row = $result->fetch_assoc()) {
$task_id = $row['task_id'];
if (!isset($tasks[$task_id])) {
$tasks[$task_id] = $row;
$tasks[$task_id]['assignee_emails'] = array();
$tasks[$task_id]['completed'] = array();
}
if (!empty($row['assignee_email'])) {
$tasks[$task_id]['assignee_emails'][] = $row['assignee_email'];
}
if ($row['completornot'] == 1) {
$tasks[$task_id]['completed'][$row['assignee_email']] = $row['completed_at'];
}
}
foreach ($tasks as $task) {
echo '<div class="task">';
echo '<p class="task-header">Task ID: ' . $task['task_id'] . '</p>';
echo '<p>Assigner: ' . $task['assigner_name'] . '</p>';
echo '<p>Assignees: ' . implode(", ", $task['assignee_emails']) . '</p>';
echo '<p>Description: ' . $task['task_description'] . '</p>';
echo '<p>Given At: ' . $task['assign_date'] . '</p>';
foreach ($task['assignee_emails'] as $assignee_email) {
echo '<p>' . $assignee_email . ' - Completed At: ';
if (isset($task['completed'][$assignee_email])) {
echo $task['completed'][$assignee_email];
} else {
echo 'Not completed';
}
echo '</p>';
}
echo '</div>';
}
} else {
echo "No tasks assigned by you.";
}
$conn->close();
?>