date_field = $date_field; $this->inner_sql = $inner_sql; $this->date_components = $date_components; } //--------------------------------------------------------- private members --- /** * Returns a display name for a date component optionally using labels */ function get_date_component_label($date_component, $labels=null) { $label = $date_component; if (isset($labels[$date_component])) { $label = $labels[$date_component]; } elseif ($date_component == 'any' ) { $label = l10n('calendar_any'); } return $label; } /** * 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 allow_any - adds any to the end of the bar * @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, $allow_any, $labels=null) { $nav_bar = ''; 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; } else { $nav_bar .= ''; $url = $url_base . $item; $nav_bar .= ''; $nav_bar .= $label; $nav_bar .= ''; } if ($nb_images > 0) { $nav_bar .= '('.$nb_images.')'; } $nav_bar.= ''; } global $conf; if ($conf['calendar_show_any'] and $allow_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 string sql_func - YEAR/MONTH/DAY/WEEK/DAYOFWEEK ... * @param string sql_offset - (e.g. +1 for WEEK - first in year is 1) * @param array labels - optional labels to show in the navigation bar * @return void */ function build_nav_bar($level, $sql_func, $sql_offset='', $labels=null) { global $template; $query = ' SELECT DISTINCT('.$sql_func.'('.$this->date_field.')'.$sql_offset .') 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; } $url_base = $this->url_base; for ($i=0; $i<$level; $i++) { if (isset($this->date_components[$i])) { $url_base .= $this->date_components[$i].'-'; } } $selected = null; if ( isset($this->date_components[$level]) ) { $selected = $this->date_components[$level]; } $nav_bar = $this->get_nav_bar_from_items( $url_base, $level_items, $selected, 'cal', true, $labels ); $template->assign_block_vars( 'calendar.navbar', array( 'BAR' => $nav_bar ) ); } } ?>