public function day($tool_id, $date)
{
if (empty($date)) {
Event::run('system.404');
}
$date = explode('-', $date);
# strictly need the formated date, else throw page not found.
if (3 != count($date)) {
Event::run('system.404');
}
list($year, $month, $day) = $date;
valid::year($year);
valid::month($month);
valid::day($day);
$events = ORM::factory('calendar_item')->where(array('fk_site' => $this->site_id, 'calendar_id' => $tool_id, 'year' => $year, 'month' => $month, 'day' => $day))->find_all();
$primary = new View('public_calendar/small/day');
$primary->events = $events;
$primary->date = "{$year} {$month} {$day}";
$primary->logged_in = $this->client->can_edit($this->site_id) ? TRUE : FALSE;
return $primary;
}
private function show_archive($tool_id, $value, $value2)
{
$view = new View("public_blog/blogs/archive");
$date_search = false;
# year search
if (!empty($value) and empty($value2)) {
valid::year($value);
$start = $value;
(int) ($end = $value + 1);
$date_search = "AND created >= '{$start}' AND created < '{$end}'";
} elseif (!empty($value) and !empty($value2)) {
valid::year($value);
valid::month($value2);
$month = $value2 + 1;
if (10 > $month) {
$month = "0{$month}";
}
$start = "{$value}-{$value2}";
$end = "{$value}-{$month}";
$date_search = "AND created >= '{$start}' AND created < '{$end}'";
}
$blog_posts = $this->db->query("\n SELECT blog_posts.*, \n DATE_FORMAT(created, '%Y') as year,\n DATE_FORMAT(created, '%M') as month,\n DATE_FORMAT(created, '%e') as day\n FROM blog_posts \n WHERE blog_posts.blog_id = '{$tool_id}' \n AND blog_posts.fk_site = '{$this->site_id}'\n {$date_search}\n ORDER BY created\n LIMIT 0, 10\n ");
$view->blog_posts = $blog_posts;
return $view;
}
/**
* Week view
*
* @param int $year
* @param int $week
*/
public function week($year, $week)
{
$this->tab_id = 'browse';
if (valid::year($year) && valid::week($week)) {
$this->type = 'week';
$this->date->setISODate($year, $week);
// check for new years fix
if ($week == 1) {
$saturday = new DateTime();
$saturday->setISODate($year, $week, 6);
$this->date = $saturday;
}
$this->page_title = text::title(__('Week') . ' ' . $this->date->format('W/Y'));
$this->breadcrumb[] = html::anchor(Router::$routed_uri, html::specialchars($this->page_title));
$this->_build_calendar();
}
}
