summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorJan-Philipp Litza <janphilipp@litza.de>2011-12-27 13:50:07 +0100
committerJan-Philipp Litza <janphilipp@litza.de>2011-12-27 13:50:07 +0100
commitd3b51174b6ba00c06d6e84c13247793744b8c99a (patch)
treeeb5e9ccb557f58df0e8fc8530917340174bac362
parentc925f19a96fc2dcbb058acb91fc5d96ce877d8eb (diff)
performance improvements for displaying shifts
-rw-r--r--includes/pages/user_shifts.php9
1 files changed, 4 insertions, 5 deletions
diff --git a/includes/pages/user_shifts.php b/includes/pages/user_shifts.php
index e0e8b1bc..3088e633 100644
--- a/includes/pages/user_shifts.php
+++ b/includes/pages/user_shifts.php
@@ -210,13 +210,12 @@ function user_shifts() {
'comment' => ""
));
} else {
- $shifts = sql_select("SELECT * FROM `Shifts` ORDER BY `start`");
+ $shifts = sql_select("SELECT COUNT(*) AS `count` FROM `Shifts` ORDER BY `start`");
$days = array ();
$rooms = array ();
- if (count($shifts) > 0) {
- foreach ($shifts as $shift)
- $days[] = date("Y-m-d", $shift['start']);
- $days = array_unique($days);
+ if ($shifts[0]["count"] > 0) {
+ $days = sql_select("SELECT DISTINCT DATE(FROM_UNIXTIME(`start`)) FROM `Shifts`");
+ $days = array_map('array_pop', $days);
$day = $days[0];
if (isset ($_REQUEST['day']))
$day = $_REQUEST['day'];