improve shift rendering

7 files changed, 249 insertions, 14 deletions

diff --git a/includes/model/NeededAngelTypes_model.php b/includes/model/NeededAngelTypes_model.php
index 77a23c3d..47c9626f 100644
--- a/includes/model/NeededAngelTypes_model.php
+++ b/includes/model/NeededAngelTypes_model.php
@@ -65,7 +65,7 @@ function NeededAngelTypes_by_shift($shiftId) {
         ORDER BY `room_id` DESC
         ");
   if ($needed_angeltypes_source === false) {
-    return false;
+    engelsystem_error("Unable to load needed angeltypes.");
   }
   
   // Use settings from room
@@ -80,18 +80,16 @@ function NeededAngelTypes_by_shift($shiftId) {
         ORDER BY `room_id` DESC
         ");
     if ($needed_angeltypes_source === false) {
-      return false;
+      engelsystem_error("Unable to load needed angeltypes.");
     }
   }
   
   $needed_angeltypes = [];
   foreach ($needed_angeltypes_source as $angeltype) {
     $shift_entries = ShiftEntries_by_shift_and_angeltype($shiftId, $angeltype['angel_type_id']);
-    if ($shift_entries === false) {
-      return false;
-    }
     
     $angeltype['taken'] = count($shift_entries);
+    $angeltype['shift_entries'] = $shift_entries;
     $needed_angeltypes[] = $angeltype;
   }
   
diff --git a/includes/model/ShiftEntry_model.php b/includes/model/ShiftEntry_model.php
index 425b92e8..63127bc7 100644
--- a/includes/model/ShiftEntry_model.php
+++ b/includes/model/ShiftEntry_model.php
@@ -110,12 +110,16 @@ function ShiftEntries_finished_by_user($user) {
  * @param int $angeltype_id          
  */
 function ShiftEntries_by_shift_and_angeltype($shift_id, $angeltype_id) {
-  return sql_select("
+  $result = sql_select("
       SELECT *
       FROM `ShiftEntry`
       WHERE `SID`=" . sql_escape($shift_id) . "
       AND `TID`=" . sql_escape($angeltype_id) . "
       ");
+  if ($result === false) {
+    engelsystem_error("Unable to load shift entries.");
+  }
+  return $result;
 }
 
 /**
diff --git a/includes/model/Shifts_model.php b/includes/model/Shifts_model.php
index 5a38abdd..f232360e 100644
--- a/includes/model/Shifts_model.php
+++ b/includes/model/Shifts_model.php
@@ -2,7 +2,7 @@
 use Engelsystem\ShiftsFilter;
 
 function Shifts_by_room($room) {
-  $result = sql_select("SELECT * FROM `Shifts` WHERE `RID`=" . sql_escape($room['RID']));
+  $result = sql_select("SELECT * FROM `Shifts` WHERE `RID`=" . sql_escape($room['RID']) . " ORDER BY `start`");
   if ($result === false) {
     engelsystem_error("Unable to load shifts.");
   }
diff --git a/includes/sys_menu.php b/includes/sys_menu.php
index a5971ace..9d70cf10 100644
--- a/includes/sys_menu.php
+++ b/includes/sys_menu.php
@@ -169,6 +169,10 @@ function make_navigation() {
 function make_room_navigation($menu) {
   global $privileges;
   
+  if (! in_array('view_rooms', $privileges)) {
+    return $menu;
+  }
+  
   $rooms = Rooms();
   $room_menu = [];
   if (in_array('admin_rooms', $privileges)) {
diff --git a/includes/view/Rooms_view.php b/includes/view/Rooms_view.php
index 40ab9480..7afdc67b 100644
--- a/includes/view/Rooms_view.php
+++ b/includes/view/Rooms_view.php
@@ -11,7 +11,7 @@ function Room_view($room, ShiftsFilterRenderer $shiftsFilterRenderer, ShiftCalen
 
 function Room_name_render($room) {
   global $privileges;
-  if (in_array('admin_rooms', $privileges)) {
+  if (in_array('view_rooms', $privileges)) {
     return '<a href="' . room_link($room) . '">' . glyph('map-marker') . $room['Name'] . '</a>';
   }
   return glyph('map-marker') . $room['Name'];
diff --git a/includes/view/ShiftCalendarRenderer.php b/includes/view/ShiftCalendarRenderer.php
index 41cf6f94..04ecdf61 100644
--- a/includes/view/ShiftCalendarRenderer.php
+++ b/includes/view/ShiftCalendarRenderer.php
@@ -9,6 +9,8 @@ class ShiftCalendarRenderer {
    */
   const MINUTES_PER_ROW = 900;
 
+  const EMPTY_CELL = '<td class="empty"></td>';
+
   private $shifts;
 
   private $shiftsFilter;
@@ -20,9 +22,222 @@ class ShiftCalendarRenderer {
 
   public function render() {
     $rooms = $this->rooms();
-    $slotSizes = $this->calcSlotSizes($rooms);
     
-    return '';
+    $first_block_start_time = $this->calcFirstBlockStartTime();
+    $blocks_per_slot = $this->calcBlocksPerSlot($first_block_start_time);
+    
+    $slotSizes = $this->calcSlotSizes($rooms, $first_block_start_time, $blocks_per_slot);
+    
+    return $this->renderTable($rooms, $slotSizes, $first_block_start_time, $blocks_per_slot);
+  }
+
+  private function renderTableHead($rooms, $slotSizes) {
+    $shifts_table = '<thead><tr><th>' . _("Time") . '</th>';
+    foreach ($rooms as $room_id => $room_name) {
+      $colspan = $slotSizes[$room_id];
+      $shifts_table .= "<th" . (($colspan > 1) ? ' colspan="' . $colspan . '"' : '') . ">" . Room_name_render([
+          'RID' => $room_id,
+          'Name' => $room_name 
+      ]) . "</th>\n";
+    }
+    $shifts_table .= "</tr></thead>";
+    return $shifts_table;
+  }
+
+  private function initTableBody($rooms, $slotSizes, $first_block_start_time, $blocks_per_slot) {
+    // Slot sizes plus 1 for the time
+    $columns_needed = array_sum($slotSizes) + 1;
+    $table_line = array_fill(0, $columns_needed, ShiftCalendarRenderer::EMPTY_CELL);
+    $table = array_fill(0, $blocks_per_slot, $table_line);
+    
+    for ($block = 0; $block < $blocks_per_slot; $block ++) {
+      $thistime = $first_block_start_time + ($block * ShiftCalendarRenderer::MINUTES_PER_ROW);
+      if ($thistime % (24 * 60 * 60) == 23 * 60 * 60 && $this->shiftsFilter->getEndTime() - $this->shiftsFilter->getStartTime() > 24 * 60 * 60) {
+        $table[$block][0] = '<th class="row-day">' . date('Y-m-d<b\r />H:i', $thistime) . '</th>';
+      } elseif ($thistime % (60 * 60) == 0) {
+        $table[$block][0] = '<th class="row-hour">' . date('H:i', $thistime) . '</th>';
+      } else {
+        $table[$block][0] = '<th class="empty"></th>';
+      }
+    }
+    
+    return $table;
+  }
+
+  private function calcRoomSlots($rooms, $slotSizes) {
+    $result = [];
+    $slot = 1; // 1 for the time
+    foreach ($rooms as $room_id => $room_name) {
+      $result[$room_id] = $slot;
+      $slot += $slotSizes[$room_id];
+    }
+    
+    return $result;
+  }
+
+  private function collides() {
+    // TODO
+    return false;
+  }
+
+  private function renderShift($shift) {
+    global $privileges, $user;
+    
+    $collides = $this->collides();
+    $is_free = false;
+    $shifts_row = '';
+    $header_buttons = "";
+    if (in_array('admin_shifts', $privileges)) {
+      $header_buttons = '<div class="pull-right">' . table_buttons([
+          button(page_link_to('user_shifts') . '&edit_shift=' . $shift['SID'], glyph('edit'), 'btn-xs'),
+          button(page_link_to('user_shifts') . '&delete_shift=' . $shift['SID'], glyph('trash'), 'btn-xs') 
+      ]) . '</div>';
+    }
+    $info_text = "";
+    if ($shift['title'] != '') {
+      $info_text = glyph('info-sign') . $shift['title'] . '<br>';
+    }
+    
+    $angeltypes = NeededAngelTypes_by_shift($shift['SID']);
+    foreach ($angeltypes as $angeltype) {
+      $entry_list = [];
+      $freeloader = 0;
+      foreach ($angeltype['shift_entries'] as $entry) {
+        $style = '';
+        if ($entry['freeloaded']) {
+          $freeloader ++;
+          $style = " text-decoration: line-through;";
+        }
+        if (in_array('user_shifts_admin', $privileges)) {
+          $entry_list[] = "<span style=\"$style\">" . User_Nick_render(User($entry['UID'])) . ' ' . table_buttons([
+              button(page_link_to('user_shifts') . '&entry_id=' . $entry['id'], glyph('trash'), 'btn-xs') 
+          ]) . '</span>';
+        } else {
+          $entry_list[] = "<span style=\"$style\">" . User_Nick_render(User($entry['UID'])) . "</span>";
+        }
+      }
+      if ($angeltype['count'] - count($angeltype['shift_entries']) - $freeloader > 0) {
+        $inner_text = sprintf(ngettext("%d helper needed", "%d helpers needed", $angeltype['count'] - count($angeltype['shift_entries'])), $angeltype['count'] - count($angeltype['shift_entries']));
+        // is the shift still running or alternatively is the user shift admin?
+        $user_may_join_shift = true;
+        
+        // you cannot join if user alread joined a parallel or this shift
+        $user_may_join_shift &= ! $collides;
+        
+        // you cannot join if user is not of this angel type
+        $user_may_join_shift &= isset($angeltype['user_id']);
+        
+        // you cannot join if you are not confirmed
+        if ($angeltype['restricted'] == 1 && isset($angeltype['user_id'])) {
+          $user_may_join_shift &= isset($angeltype['confirm_user_id']);
+        }
+        
+        // you can only join if the shift is in future or running
+        $user_may_join_shift &= time() < $shift['start'];
+        
+        // User shift admins may join anybody in every shift
+        $user_may_join_shift |= in_array('user_shifts_admin', $privileges);
+        if ($user_may_join_shift) {
+          $entry_list[] = '<a href="' . page_link_to('user_shifts') . '&amp;shift_id=' . $shift['SID'] . '&amp;type_id=' . $angeltype['id'] . '">' . $inner_text . '</a> ' . button(page_link_to('user_shifts') . '&amp;shift_id=' . $shift['SID'] . '&amp;type_id=' . $angeltype['id'], _('Sign up'), 'btn-xs');
+        } else {
+          if (time() > $shift['start']) {
+            $entry_list[] = $inner_text . ' (' . _('ended') . ')';
+          } elseif ($angeltype['restricted'] == 1 && isset($angeltype['user_id']) && ! isset($angeltype['confirm_user_id'])) {
+            $entry_list[] = $inner_text . glyph('lock');
+          } elseif ($angeltype['restricted'] == 1) {
+            $entry_list[] = $inner_text;
+          } elseif ($collides) {
+            $entry_list[] = $inner_text;
+          } else {
+            $entry_list[] = $inner_text . '<br />' . button(page_link_to('user_angeltypes') . '&action=add&angeltype_id=' . $angeltype['id'], sprintf(_('Become %s'), $angeltype['name']), 'btn-xs');
+          }
+        }
+        
+        unset($inner_text);
+        $is_free = true;
+      }
+      
+      $shifts_row .= '<li class="list-group-item">';
+      $shifts_row .= '<strong>' . AngelType_name_render($angeltype) . ':</strong> ';
+      $shifts_row .= join(", ", $entry_list);
+      $shifts_row .= '</li>';
+    }
+    if (in_array('user_shifts_admin', $privileges)) {
+      $shifts_row .= '<li class="list-group-item">' . button(page_link_to('user_shifts') . '&amp;shift_id=' . $shift['SID'] . '&amp;type_id=' . $angeltype['id'], _("Add more angels"), 'btn-xs') . '</li>';
+    }
+    if ($shifts_row != '') {
+      $shifts_row = '<ul class="list-group">' . $shifts_row . '</ul>';
+    }
+    if (isset($shift['own']) && $shift['own'] && ! in_array('user_shifts_admin', $privileges)) {
+      $class = 'primary';
+    } elseif ($collides && ! in_array('user_shifts_admin', $privileges)) {
+      $class = 'default';
+    } elseif ($is_free) {
+      $class = 'danger';
+    } else {
+      $class = 'success';
+    }
+    
+    $blocks = ceil(($shift["end"] - $shift["start"]) / ShiftCalendarRenderer::MINUTES_PER_ROW);
+    if ($blocks < 1) {
+      $blocks = 1;
+    }
+    return [
+        $blocks,
+        '<td class="shift" rowspan="' . $blocks . '">' . div('panel panel-' . $class, [
+            div('panel-heading', [
+                date('H:i', $shift['start']),
+                '&dash;',
+                date('H:i', $shift['end']),
+                '&mdash;',
+                ShiftType($shift['shifttype_id'])['name'],
+                $header_buttons 
+            ]),
+            div('panel-body', [
+                $info_text,
+                Room_name_render([
+                    'RID' => $shift['RID'],
+                    'Name' => $shift['room_name'] 
+                ]) 
+            ]),
+            $shifts_row 
+        ]) . '</td>' 
+    ];
+  }
+
+  private function renderTableBody($rooms, $slotSizes, $first_block_start_time, $blocks_per_slot) {
+    $table = $this->initTableBody($rooms, $slotSizes, $first_block_start_time, $blocks_per_slot);
+    
+    $room_slots = $this->calcRoomSlots($rooms, $slotSizes);
+    
+    foreach ($this->shifts as $shift) {
+      list($blocks, $shift_content) = $this->renderShift($shift);
+      $start_block = floor(($shift['start'] - $first_block_start_time) / ShiftCalendarRenderer::MINUTES_PER_ROW);
+      $slot = $room_slots[$shift['RID']];
+      while ($table[$start_block][$slot] != ShiftCalendarRenderer::EMPTY_CELL) {
+        $slot ++;
+      }
+      $table[$start_block][$slot] = $shift_content;
+      for ($block = 1; $block < $blocks; $block ++) {
+        $table[$start_block + $block][$slot] = '';
+      }
+    }
+    
+    $result = '<tbody>';
+    foreach ($table as $table_line) {
+      $result .= '<tr>' . join('', $table_line) . '</tr>';
+    }
+    $result .= '</tbody>';
+    return $result;
+  }
+
+  private function renderTable($rooms, $slotSizes, $first_block_start_time, $blocks_per_slot) {
+    return div('shifts-table', [
+        '<table id="shifts" class="table scrollable">',
+        $this->renderTableHead($rooms, $slotSizes),
+        $this->renderTableBody($rooms, $slotSizes, $first_block_start_time, $blocks_per_slot),
+        '</table>' 
+    ]);
   }
 
   /**
@@ -38,9 +253,21 @@ class ShiftCalendarRenderer {
     return $rooms;
   }
 
-  private function calcSlotSizes($rooms) {
-    $first_block_start_time = ShiftCalendarRenderer::MINUTES_PER_ROW * floor($this->shiftsFilter->getStartTime() / ShiftCalendarRenderer::MINUTES_PER_ROW);
-    $blocks_per_slot = ceil(($this->shiftsFilter->getEndTime() - $first_block_start_time) / ShiftCalendarRenderer::MINUTES_PER_ROW);
+  private function calcFirstBlockStartTime() {
+    $start_time = $this->shiftsFilter->getEndTime();
+    foreach ($this->shifts as $shift) {
+      if ($shift['start'] < $start_time) {
+        $start_time = $shift['start'];
+      }
+    }
+    return ShiftCalendarRenderer::MINUTES_PER_ROW * floor(($start_time - 60 * 60) / ShiftCalendarRenderer::MINUTES_PER_ROW);
+  }
+
+  private function calcBlocksPerSlot($first_block_start_time) {
+    return ceil(($this->shiftsFilter->getEndTime() - $first_block_start_time) / ShiftCalendarRenderer::MINUTES_PER_ROW);
+  }
+
+  private function calcSlotSizes($rooms, $first_block_start_time, $blocks_per_slot) {
     $parallel_blocks = [];
     
     // initialize $block array
diff --git a/includes/view/ShiftsFilterRenderer.php b/includes/view/ShiftsFilterRenderer.php
index ff9302f7..289ed210 100644
--- a/includes/view/ShiftsFilterRenderer.php
+++ b/includes/view/ShiftsFilterRenderer.php
@@ -46,7 +46,9 @@ class ShiftsFilterRenderer {
       }
       $toolbar[] = toolbar_dropdown('', $selected_day, $day_dropdown_items, 'active');
     }
-    return toolbar_pills($toolbar);
+    return div('form-group', [
+        toolbar_pills($toolbar) 
+    ]);
   }
 
   /**