function show($year, $month)
{
$calendar = new EventCalendar($month, $year, '+1 year');
$start = $calendar->start();
$end = $calendar->end();
$db = new DbConn();
$results = $db->query('select * from users
where status in ?
and arrivaldate is not null
and departuredate is not null
and ((arrivaldate >= ? and arrivaldate < ?)
or (departuredate >= ? and departuredate < ?))
order by arrivaldate asc', array(STATUS_ACCEPTED, STATUS_CONFIRMED), $start, $end, $start, $end);
while ($user = $results->next()) {
$calendar->addEvent("{$user->firstname} {$user->lastname}", $this->_to_date($user->arrivaldate), $this->_to_date($user->departuredate), site_url("admin/volunteers/show/{$user->id}"), $user->status != STATUS_CONFIRMED);
}
$prev = clone $start;
$prev->modify('-1 year');
$next = clone $start;
$next->modify('+1 year');
$this->load->view('admin/header');
$this->load->view('admin/calendar', array('calendar' => $calendar, 'date' => $this->_make_date($year, $month), 'prev' => $prev, 'next' => $next));
$this->load->view('admin/footer');
}
