diff options
author | nikrou <nikrou@piwigo.org> | 2009-11-30 20:41:11 +0000 |
---|---|---|
committer | nikrou <nikrou@piwigo.org> | 2009-11-30 20:41:11 +0000 |
commit | f7222bf601fa120a0fa2190cb98325780d75ff24 (patch) | |
tree | 418abf0dc0cf2b6723aa8e8db64a399ee923f071 /include/calendar_base.class.php | |
parent | 2f8800b35b51fb71d8d61b1f809b28a5097c5801 (diff) |
Feature 1255 :
sql functions for calendar (interval, year, month, ...)
git-svn-id: http://piwigo.org/svn/trunk@4398 68402e56-0260-453c-a942-63ccdbb3a9ee
Diffstat (limited to '')
-rw-r--r-- | include/calendar_base.class.php | 26 |
1 files changed, 17 insertions, 9 deletions
diff --git a/include/calendar_base.class.php b/include/calendar_base.class.php index 079da2621..41a15d918 100644 --- a/include/calendar_base.class.php +++ b/include/calendar_base.class.php @@ -215,7 +215,8 @@ SELECT DISTINCT('.$this->calendar_levels[$level]['sql'].') as period, COUNT(DISTINCT id) as nb_images'. $this->inner_sql. $this->get_date_where($level).' - GROUP BY period + GROUP BY period + ORDER BY period ASC ;'; $level_items = simple_hash_from_query($query, 'period', 'nb_images'); @@ -265,27 +266,34 @@ $this->get_date_where($level).' function build_next_prev() { global $template, $page; + $prev = $next =null; if ( empty($page['chronology_date']) ) return; - $query = 'SELECT CONCAT_WS(\'-\''; - for ($i=0; $i<count($page['chronology_date']); $i++) + + $sub_query = ''; + $nb_elements = count($page['chronology_date']); + for ($i=0; $i<$nb_elements; $i++) { if ( 'any' === $page['chronology_date'][$i] ) { - $query .= ','.'"any"'; + $sub_query .= '\'any\''; } else { - $query .= ','.$this->calendar_levels[$i]['sql']; + $sub_query .= pwg_db_cast_to_text($this->calendar_levels[$i]['sql']); + } + if ($i<($nb_elements-1)) + { + $sub_query .= ','; } } - $current = implode('-', $page['chronology_date'] ); - - $query.=') as period' . $this->inner_sql .' + $query = 'SELECT '.pwg_db_concat_ws($sub_query, '-').' AS period'; + $query .= $this->inner_sql .' AND ' . $this->date_field . ' IS NOT NULL GROUP BY period'; - + + $current = implode('-', $page['chronology_date'] ); $upper_items = array_from_query( $query, 'period'); usort($upper_items, 'version_compare'); |