date_field = $date_field; $this->inner_sql = $inner_sql; $this->date_components = $date_components; $this->has_nav_bar = false; } function get_display_name() { global $conf; $res = ''; $url = $this->url_base; for ($i=0; $idate_components); $i++) { $res .= $conf['level_separator']; $url .= $this->date_components[$i].'-'; if ( isset($this->date_components[$i+1]) ) { $res .= '' .$this->get_date_component_label($i, $this->date_components[$i]) .''; } else { $res .= '' .$this->get_date_component_label($i, $this->date_components[$i]) .''; } } return $res; } //--------------------------------------------------------- private members --- /** * Returns a display name for a date component optionally using labels */ function get_date_component_label($level, $date_component) { $label = $date_component; if (isset($this->calendar_levels[$level]['labels'][$date_component])) { $label = $this->calendar_levels[$level]['labels'][$date_component]; } elseif ($date_component == 'any' ) { $label = l10n('calendar_any'); } return $label; } /** * Gets a nice display name for a date to be shown in previos/next links. */ function get_date_nice_name($date) { $date_components = explode('-', $date); $res = ''; for ($i=count($date_components)-1; $i>=0; $i--) { if ($date_components[$i]!='any') { $label = $date_components[$i]; if (isset($this->calendar_levels[$i]['labels'][$date_components[$i]])) { $label = $this->calendar_levels[$i]['labels'][$date_components[$i]]; } $res .= $label.' '; } } return $res; } /** * Creates a calendar navigation bar. * * @param string url_base - links start with this root * @param array items - hash of items to put in the bar (e.g. 2005,2006) * @param array selected_item - item currently selected (e.g. 2005) * @param string class_prefix - html class attribute prefix for span elements * @param bool show_any - adds any link to the end of the bar * @param bool show_empty - shows all labels even those without items * @param array labels - optional labels for items (e.g. Jan,Feb,...) * @return string the navigation bar */ function get_nav_bar_from_items($url_base, $items, $selected_item, $class_prefix, $show_any, $show_empty=false, $labels=null) { global $conf; $nav_bar = ''; if ($conf['calendar_show_empty'] and $show_empty and !empty($labels) ) { foreach ($labels as $item => $label) { if ( ! isset($items[$item]) ) { $items[$item] = -1; } } ksort($items); } foreach ($items as $item => $nb_images) { $label = $item; if (isset($labels[$item])) { $label = $labels[$item]; } if (isset($selected_item) and $item == $selected_item) { $nav_bar .= ''; $nav_bar .= $label; } elseif ($nb_images==-1) { $nav_bar .= ''; $nav_bar .= $label; } else { $nav_bar .= ''; $url = $url_base . $item; $nav_bar .= ''; $nav_bar .= $label; $nav_bar .= ''; } if ($nb_images > 0) { $nav_bar .= '('.$nb_images.')'; } $nav_bar.= ''; } if ($conf['calendar_show_any'] and $show_any and count($items) > 1) { $label = l10n('calendar_any'); if (isset($selected_item) and 'any' == $selected_item) { $nav_bar .= ''; $nav_bar .= $label; } else { $nav_bar .= ''; $url = $url_base . 'any'; $nav_bar .= ''; $nav_bar .= $label; $nav_bar .= ''; } $nav_bar.= ''; } return $nav_bar; } /** * Creates a calendar navigation bar for a given level. * * @param int level - the level (0-year,1-month/week,2-day) * @return void */ function build_nav_bar($level, $labels=null) { global $template, $conf; $query = ' SELECT DISTINCT('.$this->calendar_levels[$level]['sql'] .') as period'; $query.= $this->inner_sql; $query.= $this->get_date_where($level); $query.= ' GROUP BY period ;'; $level_items = array(); $result = pwg_query($query); while ($row = mysql_fetch_array($result)) { $level_items[$row['period']] = 0; } if ( count($level_items)==1 and count($this->date_components)calendar_levels)-1) { if ( ! isset($this->date_components[$level]) ) { list($key) = array_keys($level_items); $this->date_components[$level] = (int)$key; if ( $leveldate_components) and $level!=count($this->calendar_levels)-1 ) { return; } } } $url_base = $this->url_base; for ($i=0; $i<$level; $i++) { if (isset($this->date_components[$i])) { $url_base .= $this->date_components[$i].'-'; } } $nav_bar = $this->get_nav_bar_from_items( $url_base, $level_items, null, 'calItem', true, true, isset($labels) ? $labels : $this->calendar_levels[$level]['labels'] ); $template->assign_block_vars( 'calendar.navbar', array( 'BAR' => $nav_bar, ) ); $this->has_nav_bar = true; } /** * Assigns the next/previous link to the template with regards to * the currently choosen date. */ function build_next_prev() { global $template; $prev = $next =null; if ( empty($this->date_components) ) return; $current = ''; $query = 'SELECT CONCAT_WS("-"'; for ($i=0; $idate_components); $i++) { if ( $this->date_components[$i] != 'any' ) { $query .= ','.$this->calendar_levels[$i]['sql']; } else { $query .= ','.'"any"'; } $current .= '-' . $this->date_components[$i]; } $current = substr($current, 1); $query.=') as period' . $this->inner_sql .' AND ' . $this->date_field . ' IS NOT NULL GROUP BY period'; $upper_items = array_from_query( $query, 'period'); usort($upper_items, 'version_compare'); //echo ('

'. var_export($upper_items, true) . '

'); $upper_items_rank = array_flip($upper_items); $current_rank = $upper_items_rank[$current]; if (!$this->has_nav_bar and ($current_rank>0 or $current_rank < count($upper_items)-1 ) ) { $template->assign_block_vars( 'calendar.navbar', array() ); } if ( $current_rank>0 ) { // has previous $prev = $upper_items[$current_rank-1]; $template->assign_block_vars( 'calendar.navbar.prev', array( 'LABEL' => $this->get_date_nice_name($prev), 'URL' => $this->url_base . $prev, ) ); } if ( $current_rank < count($upper_items)-1 ) { // has next $next = $upper_items[$current_rank+1]; $template->assign_block_vars( 'calendar.navbar.next', array( 'LABEL' => $this->get_date_nice_name($next), 'URL' => $this->url_base . $next, ) ); } } } ?>