Changeset 12118

Timestamp:

Sep 8, 2011, 8:22:27 PM (13 years ago)

Author:

rvelices

Message:

• reoptimize queries for MySql
• week starts on monday/sunday applies also to weekly calendar

Location:

trunk/include

Files:

• calendar_base.class.php (modified) (2 diffs)
• calendar_monthly.class.php (modified) (3 diffs)
• calendar_weekly.class.php (modified) (2 diffs)
• functions_calendar.inc.php (modified) (1 diff)
• functions_tag.inc.php (modified) (1 diff)

trunk/include/calendar_base.class.php

@@ -221 +221 @@
 
     $level_items = simple_hash_from_query($query, 'period', 'nb_images');
-    $level_items = array_to_int($level_items);
 
     if ( count($level_items)==1 and
@@ -293 +292 @@
     $current = implode('-', $page['chronology_date'] );
     $upper_items = array_from_query( $query, 'period');
-    $upper_items = array_to_int($upper_items);
 
     usort($upper_items, 'version_compare');

trunk/include/calendar_monthly.class.php

@@ -225 +225 @@
   assert( count($page['chronology_date']) == 0 );
   $query='
-SELECT '.pwg_db_get_date_YYYYMM($this->date_field).' as period,'
-    .pwg_db_get_year($this->date_field).' as year, '
-    .pwg_db_get_month($this->date_field).' as month, 
-            count(distinct id) as count';
+SELECT '.pwg_db_get_date_YYYYMM($this->date_field).' as period,
+  COUNT(distinct id) as count';
   $query.= $this->inner_sql;
   $query.= $this->get_date_where();
   $query.= '
-  GROUP BY period, year, month
-  ORDER BY year DESC, month ASC';
+  GROUP BY period
+  ORDER BY '.pwg_db_get_year($this->date_field).' DESC, '.pwg_db_get_month($this->date_field).' ASC';
 
   $result = pwg_query($query);
@@ -369 +367 @@
     $items[$day]['height'] = $row['height'];
     $items[$day]['dow'] = $row['dow'];
-
-    if ('sunday' == $conf['week_starts_on'])
-    {
-      $items[$day]['dow']++;
-    }
   }
 
@@ -390 +383 @@
     $wday_labels = $lang['day'];
 
-    // BEGIN - pass now in week starting Monday
-    if ($first_day_dow==0)
-    {
-      $first_day_dow = 6;
-    }
-    else
-    {
-      $first_day_dow -= 1;
-    }
-
     if ('monday' == $conf['week_starts_on'])
     {
+      if ($first_day_dow==0)
+      {
+        $first_day_dow = 6;
+      }
+      else
+      {
+        $first_day_dow -= 1;
+      }
+
       array_push( $wday_labels, array_shift($wday_labels) );
     }
-    // END - pass now in week starting Monday
 
     $cell_width = $conf['calendar_month_cell_width'];

trunk/include/calendar_weekly.class.php

@@ -41 +41 @@
   {
     parent::initialize($inner_sql);
-    global $lang;
+    global $lang, $conf;
     $week_no_labels=array();
     for ($i=1; $i<=53; $i++)
@@ -65 +65 @@
     //Comment next lines for week starting on Sunday or if MySQL version<4.0.17
     //WEEK(date,5) = "0-53 - Week 1=the first week with a Monday in this year"
-    $this->calendar_levels[CWEEK]['sql'] = pwg_db_get_week($this->date_field, 5).'+1';
-    $this->calendar_levels[CDAY]['sql'] = pwg_db_get_weekday($this->date_field);
-    array_push( $this->calendar_levels[CDAY]['labels'],
-                array_shift( $this->calendar_levels[CDAY]['labels'] ) );
+    if ('monday' == $conf['week_starts_on'])
+    {
+      $this->calendar_levels[CWEEK]['sql'] = pwg_db_get_week($this->date_field, 5).'+1';
+      $this->calendar_levels[CDAY]['sql'] = pwg_db_get_weekday($this->date_field);
+      array_push( $this->calendar_levels[CDAY]['labels'],
+                  array_shift( $this->calendar_levels[CDAY]['labels'] ) );
+    }
   }
 

trunk/include/functions_calendar.inc.php

@@ -290 +290 @@
   pwg_debug('end initialize_calendar');
 }
-
-function array_to_int($array)
-{
-  $result = array();
-  foreach ($array as $k => $v)
-  {
-    if ((int)$k==$k)
-    {
-      $key = (int) $k;
-    }
-    else
-    {
-      $key = $k;
-    }
-    if (is_array($v))
-    {
-      $result[$key] = array_to_int($v);
-    }
-    else
-    {
-      if (is_int($v))
-      {
-        $value = (int) $v;
-      }
-      else
-      {
-        $value = $v;
-      }
-      $result[$key] = $value;
-    }
-  }
-  return $result;
-}
 ?>

trunk/include/functions_tag.inc.php

@@ -229 +229 @@
   }
   $query .='
-  GROUP BY tag_id, t.id, t.name, t.url_name';
+  GROUP BY t.id
+  ORDER BY ';
   if ($max_tags>0)
   {
-    $query .= '
-  ORDER BY counter DESC
+    $query .= 'counter DESC
   LIMIT '.$max_tags;
+  }
+  else
+  {
+    $query .= 'NULL';
   }