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(); } }