Changeset 1970 for trunk/include/category_cats.inc.php

Timestamp:

Apr 22, 2007, 3:11:56 PM (18 years ago)

Author:

plg

Message:

Feature 660 added: creation date of tthe category images can be displayed
next to category title in subcatify mode. The feature was implemented in a
very simple way that must be improved in display, performance and
recursivity.

File:

• trunk/include/category_cats.inc.php (modified) (3 diffs)

trunk/include/category_cats.inc.php

@@ -78 +78 @@
 $result = pwg_query($query);
 $categories = array();
+$category_ids = array();
 $image_ids = array();
 
@@ -147 +148 @@
     array_push($image_ids, $image_id);
     array_push($categories, $row);
+    array_push($category_ids, $row['id']);
   }
   unset($image_id);
+}
+
+if ($conf['display_fromto'])
+{
+  $dates_of_category = array();
+  if (count($category_ids) > 0)
+  {
+    $query = '
+SELECT
+    category_id,
+    MIN(date_creation) AS date_creation_min,
+    MAX(date_creation) AS date_creation_max
+  FROM '.IMAGE_CATEGORY_TABLE.'
+    INNER JOIN '.IMAGES_TABLE.' ON image_id = id
+  WHERE category_id IN ('.implode(',', $category_ids).') 
+  GROUP BY category_id
+;';
+    $result = pwg_query($query);
+    while ($row = mysql_fetch_array($result))
+    {
+      $dates_of_category[ $row['category_id'] ] = array(
+        'from' => $row['date_creation_min'],
+        'to'   => $row['date_creation_max'],
+        );
+    }
+    // echo '<pre>'; print_r($dates_of_category); echo '</pre>';
+  }
 }
 
@@ -222 +251 @@
           )
         );
+
+      if ($conf['display_fromto'])
+      {
+        if (isset($dates_of_category[ $category['id'] ]))
+        {
+          $from = $dates_of_category[ $category['id'] ]['from'];
+          $to   = $dates_of_category[ $category['id'] ]['to'];
         
+          if (!empty($from))
+          {
+            $info = '';
+          
+            if ($from == $to)
+            {
+              $info = format_date($from);
+            }
+            else
+            {
+              $info = sprintf(
+                l10n('from %s to %s'),
+                format_date($from),
+                format_date($to)
+                );
+            }
+
+            $template->assign_block_vars(
+              'categories.category.dates',
+              array(
+                'INFO' => $info,
+                )
+              );
+          }
+        }
+      }
+
       //plugins need to add/modify sth in this loop ?
       trigger_action('loc_index_category_thumbnail',