function after()
{
if (class_exists('DebugToolbar')) {
echo DebugToolbar::render();
}
return parent::after();
}
function action_index()
{
$this->request->title = "Schedule Page";
$hourHeight = 50;
$borderWidth = 1;
$db = Database::instance();
$query = DB::Query(Database::SELECT, 'SELECT * FROM eventTypes', 'Model_User');
$result = $query->execute();
$eventTypes = $result->as_array('id');
$query = DB::Query(Database::SELECT, "SELECT UNIX_TIMESTAMP(date(startTime)) as day, max(hour(endTime)) as maxHour, max(minute(endTime)) as maxMin, min(hour(startTime)) as minHour, min(minute(startTime)) as minMin from events group by date(startTime)");
$result = $query->execute();
$hourData = $result->as_array('day');
$query = DB::Query(Database::SELECT, "SELECT e.*,r.name AS roomName,date(e.startTime) as eventDate FROM events e JOIN rooms r ON (e.roomId=r.id)");
$result = $query->execute();
do {
$day = strtotime($result->get('eventDate'));
$startTime = strtotime($result->get('startTime'));
$realEndTime = strtotime($result->get('endTime'));
$endTime = $realEndTime;
do {
$sameDay = date('z', $startTime) == date('z', $endTime);
if (!$sameDay) {
$endTime = strtotime(date('Y-m-d', $startTime) . 'T23:59:59' . date('O', $startTime));
}
$eventData = array('name' => $result->get('name'), 'length' => 1, 'startTime' => $startTime, 'endTime' => $endTime, 'startTimeString' => date('c', $startTime), 'endTimeString' => date('c', $endTime));
foreach (range(1, 4) as $i) {
$eventTypeName = $result->get('eventType' . $i) ? $eventTypes[$result->get('eventType' . $i)]['nameKey'] : 'closed';
$eventData['type'][$eventTypeName] = 1;
}
$eventData['type'] = array_keys($eventData['type']);
$eventData['length'] = (int) floor(($eventData['endTime'] - $eventData['startTime']) / 60 / 30);
$data[$result->get('roomName')][$day][$startTime] = $eventData;
if (!$sameDay) {
$hourData[$day]['maxHour'] = 23;
$hourData[$day]['maxMin'] = 00;
$startTime += 60 * 60 * 24;
/* = 1 day*/
$day += 60 * 60 * 24;
/* = 1 day*/
$startTime = strtotime(date('Y-m-d', $startTime) . 'T00:00:00' . date('O', $startTime));
$endTime = $realEndTime;
$hourData[$day]['minHour'] = 00;
$hourData[$day]['minMin'] = 00;
}
} while (!$sameDay);
} while ($result->next() && $result->valid());
$days = array_keys($hourData);
$rooms = array_keys($data);
sort($rooms);
$this->template->content = View::factory('schedule/index', array('eventTypes' => $eventTypes, 'borderWidth' => $borderWidth, 'days' => $days, 'rooms' => $rooms, 'hourData' => $hourData, 'hourHeight' => $hourHeight, 'data' => $data));
if (class_exists('DebugToolbar')) {
echo DebugToolbar::render();
}
}
echo "<h2>{$heading}</h2>";
}
?>
<?php
if ($subheading) {
echo "<p class='h2'>{$subheading}</p>";
}
?>
<!-- content start -->
<?php
print $content;
?>
<?php
print $profiler;
?>
<!-- content end -->
<br />
</div>
</div>
<?php
if (class_exists('DebugToolbar', TRUE)) {
echo DebugToolbar::render();
}
?>
</body>
</html>
/**
* Return the debug toolbar template.
*
* @return mixed
*/
public function debug_toolbar()
{
if (Kohana::$environment === Kohana::DEVELOPMENT and class_exists('DebugToolbar')) {
return DebugToolbar::render();
}
}
