-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathindex.php
245 lines (210 loc) · 13.3 KB
/
index.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
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
<?php
//Start session
ob_start();
session_start();
define('APP_ROOT', $_SERVER["DOCUMENT_ROOT"] . '/php-teams/');
?>
<!DOCTYPE html>
<html>
<head>
<title>PHP Teams - Main Page</title>
<?php include(APP_ROOT . 'templates/head.php') ?>
</head>
<body>
<?php include(APP_ROOT . 'templates/header.php') ?>
<main class="container">
<?php
//Display project tasks that are about to expire
//Check connection with database
include('config/db_connect.php');
//Check user access
if(isset($_SESSION['$user'])){
//Get user id
$userId = $_SESSION['$userId'];
//Query that searches timed project tasks that are not completed yet
$query = "SELECT t.id AS id, t.name AS task, t.status AS status,
t.date_end AS dateEnd, p.name AS project, p.id AS projectId,
DATEDIFF(t.date_end, now()) as daysEnd
FROM task_table t
INNER JOIN project_table p ON p.id = t.project_id
INNER JOIN user_project_table up ON up.project_id = p.id
WHERE up.user_id = '$userId' AND t.status != 'DONE'
HAVING daysEnd BETWEEN 1 AND 9
ORDER BY daysEnd ASC";
//Execute query
$result = mysqli_query($connection, $query);
//Check result
if($result){
$numRows = mysqli_num_rows($result);
if($numRows > 0){
echo '<section>
<div class="row center-align">
<h4>Reminder for the following tasks that needs to be completed within next days!</h4>
<table id="table-tasks" class="highlight responsive-table centered">
<thead>
<th>Task</th>
<th>Project</th>
<th>Status</th>
<th>Ends in</th>
<th>Expires on</th>
</thead>
<tbody>';
while($row = mysqli_fetch_assoc($result)){
echo '<tr>';
echo '<td>'. $row['task'] . ' - '. $row['id'] .'</td>';
echo '<td>'. $row['project'] . ' - '. $row['projectId'] .'</td>';
echo '<td>'. preg_replace("/_/i", " ", $row['status']) .'</td>';
echo '<td>'. $row['daysEnd'] . ' ' .'day(s)</td>';
$date = strtotime($row['dateEnd']);
echo '<td>' . date("d/m/Y H:i", $date) . '</td>';
echo '</tr>';
}
echo '<div class="row center-align">
<div class="col-md-12 center text-center">
<ul class="pagination pager"></ul>
</div>
</div>';
echo '</tbody></table></div></section>';
}
}
//Display expired project tasks
//Query that searches uncompleted project tasks that have expired
$query = "SELECT t.id AS id, t.name AS task, t.status AS status,
p.name AS project, p.id AS projectId, t.date_end AS dateEnd,
DATEDIFF(t.date_end, now()) as daysEnd
FROM task_table t
INNER JOIN project_table p ON p.id = t.project_id
INNER JOIN user_project_table up ON up.project_id = p.id
WHERE up.user_id = '$userId' AND t.status != 'DONE'
HAVING daysEnd BETWEEN -5 AND 0
ORDER BY daysEnd ASC";
//Execute query
$result = mysqli_query($connection, $query);
//Check result
if($result){
$numRows = mysqli_num_rows($result);
if($numRows > 0){
echo '<section>
<div class="row center-align">
<h4>Reminder for expired tasks that are not completed!</h4>
<table id="table-tasks" class="highlight responsive-table centered">
<thead>
<th>Task</th>
<th>Project</th>
<th>Status</th>
<th>Expired On</th>
</thead>
<tbody>';
while($row = mysqli_fetch_assoc($result)){
echo '<tr>';
echo '<td>'. $row['task'] . ' - '. $row['id'] .'</td>';
echo '<td>'. $row['project'] . ' - '. $row['projectId'] .'</td>';
echo '<td>'. preg_replace("/_/i", " ", $row['status']) .'</td>';
$date = strtotime($row['dateEnd']);
echo '<td>' . date("d/m/Y H:i", $date) . '</td>';
echo '</tr>';
}
echo '<div class="row center-align">
<div class="col-md-12 center text-center">
<ul class="pagination pager"></ul>
</div>
</div>';
echo '</tbody></table></div></section>';
}
}
}
//Close connection
mysqli_close($connection);
?>
<section>
<div class="row">
<div class="slider">
<ul class="slides">
<li>
<img src="/php-teams/resources/img/welcome.jpg">
<div class="caption center-align card">
<div class="card-content">
<h3 span="card-title">Welcome to PHP-Teams!</h3>
<h5 class="light text-lighten-3">Phasellus laoreet leo vitae orci molestie pellentesque. Nulla finibus blandit augue, eget condimentum felis ullamcorper eu. Aliquam erat volutpat..</h5>
</div>
</div>
</li>
<li>
<img src="/php-teams/resources/img/project.png">
<div class="caption left-align card">
<div class="card-content">
<h3 span="card-title">Start your own projects!</h3>
<h5 class="light text-lighten-3">Suspendisse molestie felis et leo consequat dictum. Nulla risus lectus, eleifend eu ligula et, sodales pellentesque nulla. Donec ultrices quis orci quis consectetur.</h5>
</div>
</div>
</li>
<li>
<img src="/php-teams/resources/img/task.jpg">
<div class="caption right-align card">
<div class="card-content">
<h3 span="card-title">Manage your tasks!</h3>
<h5 class="light text-lighten-3"> Nullam tristique lobortis velit vel facilisis. Suspendisse ac tincidunt quam. Curabitur lobortis eleifend metus eu posuere. Proin id pellentesque sem.</h5>
</div>
</div>
</li>
<li>
<img src="/php-teams/resources/img/team.png">
<div class="caption center-align card">
<div class="card-content">
<h3 span="card-title">Find your own team!</h3>
<h5 class="light text-lighten-3">Fusce vulputate lacinia nulla, in fermentum leo bibendum ut. Integer elementum venenatis arcu, a tincidunt risus dictum eget. In a elit id diam congue vehicula sit amet ac lorem. Nunc id iaculis arcu, ut lobortis lorem.</h5>
</div>
</div>
</li>
<li>
<img src="/php-teams/resources/img/start.png">
<div class="caption center-align card">
<div class="card-content">
<h3 span="card-title">Get Started Today!</h3>
<h5 class="light text-lighten-3">Etiam efficitur a mi non sagittis. Etiam eleifend id sapien et viverra. Ut vel ex gravida, egestas sem et, vestibulum nisl.</h5>
</div>
<?php
if(!isset($_SESSION['$user'])){
echo '<div class="card-action">
<a class="modal-trigger waves-effect" href="#modal-register" data-target="modal-user-register">Register</a>
<a class="modal-trigger waves-effect" href="#modal-login" data-target="modal-user-login">Login</a>
</div>';
}
?>
</div>
</li>
</ul>
</div>
</div>
</section>
<section>
<div class="row center-align">
<h4>About PHP-Teams</h4>
<div class="col s12 m4">
<div class="icon-block">
<h2 class="center light-blue-text"><i class="material-icons">flash_on</i></h2>
<h5 class="center">Speeds up development</h5>
<p class="light">Fusce id lacus dapibus, auctor felis et, vehicula sapien. Nullam quis venenatis lorem, vel aliquet quam. Donec nec sapien faucibus, sollicitudin ante eget, aliquam justo. Vestibulum fermentum sit amet dui eu varius. Fusce suscipit luctus finibus. Quisque tincidunt, nisl in pulvinar ultricies, tellus arcu ornare nisi, vel luctus lectus sapien et odio. Proin maximus, dui et interdum tempus, ligula nisl commodo enim, eget mattis libero nisi vel sem. Fusce cursus arcu lorem, nec faucibus neque consequat gravida. Nulla non ex et libero volutpat fermentum. Donec efficitur consequat laoreet. Mauris quis felis varius tellus auctor sagittis.</p>
</div>
</div>
<div class="col s12 m4">
<div class="icon-block">
<h2 class="center light-blue-text"><i class="material-icons">group</i></h2>
<h5 class="center">User Experience Focused</h5>
<p class="light">Fusce id lacus dapibus, auctor felis et, vehicula sapien. Nullam quis venenatis lorem, vel aliquet quam. Donec nec sapien faucibus, sollicitudin ante eget, aliquam justo. Vestibulum fermentum sit amet dui eu varius. Fusce suscipit luctus finibus. Quisque tincidunt, nisl in pulvinar ultricies, tellus arcu ornare nisi, vel luctus lectus sapien et odio. Proin maximus, dui et interdum tempus, ligula nisl commodo enim, eget mattis libero nisi vel sem. Fusce cursus arcu lorem, nec faucibus neque consequat gravida. Nulla non ex et libero volutpat fermentum. Donec efficitur consequat laoreet. Mauris quis felis varius tellus auctor sagittis.</p>
</div>
</div>
<div class="col s12 m4">
<div class="icon-block">
<h2 class="center light-blue-text"><i class="material-icons">settings</i></h2>
<h5 class="center">Easy to work with</h5>
<p class="light">Fusce id lacus dapibus, auctor felis et, vehicula sapien. Nullam quis venenatis lorem, vel aliquet quam. Donec nec sapien faucibus, sollicitudin ante eget, aliquam justo. Vestibulum fermentum sit amet dui eu varius. Fusce suscipit luctus finibus. Quisque tincidunt, nisl in pulvinar ultricies, tellus arcu ornare nisi, vel luctus lectus sapien et odio. Proin maximus, dui et interdum tempus, ligula nisl commodo enim, eget mattis libero nisi vel sem. Fusce cursus arcu lorem, nec faucibus neque consequat gravida. Nulla non ex et libero volutpat fermentum. Donec efficitur consequat laoreet. Mauris quis felis varius tellus auctor sagittis.</p>
</div>
</div>
</div>
</section>
</main>
<?php include(APP_ROOT . 'templates/footer.php') ?>
<script type="module" src="/php-teams/resources/js/other/main.js"></script>
</body>
</html>