calendar redesign: monthly and weekly styles + list/calendar views for monthly

git-svn-id: http://piwigo.org/svn/trunk@1050 68402e56-0260-453c-a942-63ccdbb3a9ee

1 files changed, 309 insertions, 0 deletions

diff --git a/include/calendar_monthly.class.php b/include/calendar_monthly.class.php
new file mode 100644
index 000000000..cc50a6641
--- /dev/null
+++ b/include/calendar_monthly.class.php
@@ -0,0 +1,309 @@
+<?php

+// +-----------------------------------------------------------------------+

+// | PhpWebGallery - a PHP based picture gallery                           |

+// | Copyright (C) 2003-2006 PhpWebGallery Team - http://phpwebgallery.net |

+// +-----------------------------------------------------------------------+

+// | branch        : BSF (Best So Far)

+// | file          : $RCSfile$

+// | last update   : $Date: 2006-01-27 02:11:43 +0100 (ven, 27 jan 2006) $

+// | last modifier : $Author: rvelices $

+// | revision      : $Revision: 1014 $

+// +-----------------------------------------------------------------------+

+// | This program is free software; you can redistribute it and/or modify  |

+// | it under the terms of the GNU General Public License as published by  |

+// | the Free Software Foundation                                          |

+// |                                                                       |

+// | This program is distributed in the hope that it will be useful, but   |

+// | WITHOUT ANY WARRANTY; without even the implied warranty of            |

+// | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU      |

+// | General Public License for more details.                              |

+// |                                                                       |

+// | You should have received a copy of the GNU General Public License     |

+// | along with this program; if not, write to the Free Software           |

+// | Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, |

+// | USA.                                                                  |

+// +-----------------------------------------------------------------------+

+

+include_once(PHPWG_ROOT_PATH.'include/calendar_base.class.php');

+

+/**

+ * Monthly calendar style (composed of years/months and days)

+ */

+class Calendar extends CalendarBase

+{

+

+/**

+ * Generate navigation bars for category page

+ * @return boolean false to indicate that thumbnails

+ * where not included here, true otherwise

+ */

+function generate_category_content($url_base, $view_type, &$requested)

+{

+  global $lang;

+

+  $this->url_base = $url_base;

+

+  if ($view_type==CAL_VIEW_CALENDAR and count($requested)==0)

+  {//case A: no year given - display all years+months

+    if ($this->build_global_calendar($requested))

+      return true;

+  }

+

+  if ($view_type==CAL_VIEW_CALENDAR and count($requested)==1)

+  {//case B: year given - display all days in given year

+    if ($this->build_year_calendar($requested))

+    {

+      $this->build_nav_bar2($view_type, $requested, 0, 'YEAR'); // years

+      return true;

+    }

+  }

+

+  if ($view_type==CAL_VIEW_CALENDAR and count($requested)==2)

+  {//case C: year+month given - display a nice month calendar

+    $this->build_month_calendar($requested);

+    $this->build_nav_bar2(CAL_VIEW_CALENDAR, $requested, 0, 'YEAR'); // years

+    if (count($requested)>0)

+      $this->build_nav_bar2(CAL_VIEW_CALENDAR, $requested, 1, 'MONTH', $lang['month']); // month

+    return true;

+  }

+

+  if ($view_type==CAL_VIEW_LIST or count($requested)==3)

+  {

+    $this->build_nav_bar2($view_type, $requested, 0, 'YEAR'); // years

+    if (count($requested)>0)

+      $this->build_nav_bar2($view_type, $requested, 1, 'MONTH', $lang['month']); // month

+    if (count($requested)>1)

+      $this->build_nav_bar2($view_type, $requested, 2, 'DAY' ); // days

+  }

+  return false;

+}

+

+

+/**

+ * Returns a sql where subquery for the date field

+ * @param array requested selected levels for this calendar

+ * (e.g. 2005,11,5 for 5th of November 2005)

+ * @param int max_levels return the where up to this level

+ * (e.g. 2=only year and month)

+ * @return string

+ */

+function get_date_where($requested, $max_levels=3)

+{

+  while (count($requested)>$max_levels)

+  {

+    array_pop($requested);

+  }

+  $res = '';

+  if (isset($requested[0]) and $requested[0]!='any')

+  {

+    $b = $requested[0] . '-';

+    $e = $requested[0] . '-';

+    if (isset($requested[1]) and $requested[1]!='any')

+    {

+      $b .= $requested[1] . '-';

+      $e .= $requested[1] . '-';

+      if (isset($requested[2]) and $requested[2]!='any')

+      {

+        $b .= $requested[2];

+        $e .= $requested[2];

+      }

+      else

+      {

+        $b .= '01';

+        $e .= '31';

+      }

+    }

+    else

+    {

+      $b .= '01-01';

+      $e .= '12-31';

+      if (isset($requested[1]) and $requested[1]!='any')

+      {

+        $res .= ' AND MONTH('.$this->date_field.')='.$requested[1];

+      }

+      if (isset($requested[2]) and $requested[2]!='any')

+      {

+        $res .= ' AND DAY('.$this->date_field.')='.$requested[2];

+      }

+    }

+    $res = " AND $this->date_field BETWEEN '$b' AND '$e'" . $res;

+  }

+  else

+  {

+    $res = ' AND '.$this->date_field.' IS NOT NULL';

+    if (isset($requested[1]) and $requested[1]!='any')

+    {

+      $res .= ' AND MONTH('.$this->date_field.')='.$requested[1];

+    }

+    if (isset($requested[2]) and $requested[2]!='any')

+    {

+      $res .= ' AND DAY('.$this->date_field.')='.$requested[2];

+    }

+  }

+  return $res;

+}

+

+//--------------------------------------------------------- private members ---

+function build_nav_bar2($view_type, $requested, $level, $sql_func, $labels=null)

+{

+  parent::build_nav_bar($view_type, $requested, $level, $sql_func, '', $labels);

+}

+

+function build_global_calendar(&$requested)

+{

+  $query='SELECT DISTINCT(DATE_FORMAT('.$this->date_field.',"%Y%m")) as period,

+            COUNT(id) as count';

+  $query.= $this->inner_sql;

+  $query.= $this->get_date_where($requested, 0);

+  $query.= '

+  GROUP BY period';

+

+  $result = pwg_query($query);

+  while ($row = mysql_fetch_array($result))

+  {

+    $y = substr($row['period'], 0, 4);

+    $m = (int)substr($row['period'], 4, 2);

+    if ( ! isset($items[$y]) )

+    {

+      $items[$y] = array('nb_images'=>0, 'children'=>array() );

+    }

+    $items[$y]['children'][$m] = $row['count'];

+    $items[$y]['nb_images'] += $row['count'];

+  }

+  //echo ('<pre>'. var_export($items, true) . '</pre>');

+  if (count($items)==1)

+  {// only one year exists so bail out to year view

+    list($y) = array_keys($items);

+    array_push($requested, $y );

+    return false;

+  }

+

+  global $lang, $template;

+  foreach ( $items as $year=>$year_data)

+  {

+    $url_base = $this->url_base .'c-'.$year;

+

+    $nav_bar = '<span class="calCalHead"><a href="'.$url_base.'">'.$year.'</a>';

+    $nav_bar .= ' ('.$year_data['nb_images'].')';

+    $nav_bar .= '</span><br>';

+

+    $url_base .= '-';

+    $nav_bar .= $this->get_nav_bar_from_items( $url_base, $year_data['children'], $requested[0], 'calCal', false, $lang['month'] );

+

+    $template->assign_block_vars( 'calendar.calbar',

+         array( 'BAR' => $nav_bar)

+         );

+  }

+  return true;

+}

+

+function build_year_calendar(&$requested)

+{

+  $query='SELECT DISTINCT(DATE_FORMAT('.$this->date_field.',"%m%d")) as period,

+            COUNT(id) as count';

+  $query.= $this->inner_sql;

+  $query.= $this->get_date_where($requested, 1);

+  $query.= '

+  GROUP BY period';

+

+  $result = pwg_query($query);

+  while ($row = mysql_fetch_array($result))

+  {

+    $m = (int)substr($row['period'], 0, 2);

+    $d = substr($row['period'], 2, 2);

+    if ( ! isset($items[$m]) )

+    {

+      $items[$m] = array('nb_images'=>0, 'children'=>array() );

+    }

+    $items[$m]['children'][$d] = $row['count'];

+    $items[$m]['nb_images'] += $row['count'];

+  }

+  //echo ('<pre>'. var_export($items, true) . '</pre>');

+  if (count($items)==1)

+  { // only one month exists so bail out to month view

+    list($m) = array_keys($items);

+    array_push($requested, $m );

+    if (count($items[$m]['children'])==1)

+    { // or even to day view if everything occured in one day

+      list($d) = array_keys($items[$m]['children']);

+      array_push($requested, $d);

+    }

+    return false;

+  }

+  global $lang, $template;

+  foreach ( $items as $month=>$month_data)

+  {

+    $url_base = $this->url_base.'c-'.$requested[0].'-'.$month;

+

+    $nav_bar = '<span class="calCalHead"><a href="'.$url_base.'">'.$lang['month'][$month].'</a>';

+    $nav_bar .= ' ('.$month_data['nb_images'].')';

+    $nav_bar .= '</span><br>';

+

+    $url_base .= '-';

+    $nav_bar .= $this->get_nav_bar_from_items( $url_base, $month_data['children'], $requested[1], 'calCal', false );

+

+    $template->assign_block_vars( 'calendar.calbar',

+         array( 'BAR' => $nav_bar)

+         );

+  }

+  return true;

+

+}

+

+function build_month_calendar($requested)

+{

+  $query='SELECT DISTINCT(DATE_FORMAT('.$this->date_field.',"%d")) as period,

+            COUNT(id) as count';

+  $query.= $this->inner_sql;

+  $query.= $this->get_date_where($requested, 2);

+  $query.= '

+  GROUP BY period';

+

+  $result = pwg_query($query);

+  while ($row = mysql_fetch_array($result))

+  {

+    $d = $row['period'];

+    $items[$d] = $row['count'];

+  }

+

+  global $lang, $template;

+

+  $template->assign_block_vars('thumbnails', array());

+  $template->assign_block_vars('thumbnails.line', array());

+  foreach ( $items as $day=>$nb_images)

+  {

+    $url_base = $this->url_base.'c-'.$requested[0].'-'.$requested[1].'-'.$day;

+    $requested[2]=$day;

+    $query = '

+SELECT file,tn_ext,path, DAYOFWEEK('.$this->date_field.')-1 as dw';

+    $query.= $this->inner_sql;

+    $query.= $this->get_date_where($requested);

+

+    $row = mysql_fetch_array(pwg_query($query));

+

+    $thumbnail_src = get_thumbnail_src($row['path'], @$row['tn_ext']);

+    $thumbnail_title = $lang['day'][$row['dw']] . ' ' . $day;

+    $name = $thumbnail_title .' ('.$nb_images.')';

+

+    $template->assign_block_vars(

+        'thumbnails.line.thumbnail',

+        array(

+          'IMAGE'=>$thumbnail_src,

+          'IMAGE_ALT'=>$row['file'],

+          'IMAGE_TITLE'=>$thumbnail_title,

+          'U_IMG_LINK'=>$url_base

+         )

+        );

+    $template->assign_block_vars(

+        'thumbnails.line.thumbnail.category_name',

+        array(

+          'NAME' => $name

+          )

+        );

+  }

+  return true;

+}

+

+}

+

+?>
\ No newline at end of file