Changeset 19446 for extensions/SmartAlbums/admin/cat_list.php

Timestamp:

Dec 16, 2012, 3:21:10 PM (11 years ago)

Author:

mistic100

Message:

• add regex for phot name, author
• add dimensions filter
• rewrite javascript algorithms
• add auto update on timeout (default 3 days)
• display photos count on plugin albums list

File:

• extensions/SmartAlbums/admin/cat_list.php (modified) (3 diffs)

extensions/SmartAlbums/admin/cat_list.php

@@ -21 +21 @@
     permalink,
     dir,
-    rank,
-    status
+    smart_update
   FROM '.CATEGORIES_TABLE.' AS cat
   INNER JOIN '.CATEGORY_FILTERS_TABLE.' AS cf
@@ -124 +123 @@
 // +-----------------------------------------------------------------------+
 
-// get the categories containing images directly 
-$categories_with_images = array();
+$categories_count_images = array();
 if ( count($categories) )
 {
   $query = '
-SELECT DISTINCT category_id 
+SELECT 
+    category_id, 
+    COUNT(image_id) AS total_images
   FROM '.IMAGE_CATEGORY_TABLE.'
-  WHERE category_id IN ('.implode(',', array_keys($categories)).')';
-  $categories_with_images = array_flip( array_from_query($query, 'category_id') );
+  WHERE category_id IN ('.implode(',', array_keys($categories)).')
+  GROUP BY category_id
+;';
+  $categories_count_images = simple_hash_from_query($query, 'category_id', 'total_images');
 }
 
@@ -141 +143 @@
   $tpl_cat =
     array(
-      'NAME'       => get_cat_display_name_from_id($category['id'], $base_url.'album-'),
-      'ID'         => $category['id'],
-      'RANK'       => $category['rank']*10,
+      'NAME'        => get_cat_display_name_from_id($category['id'], $base_url.'album-'),
+      'ID'          => $category['id'],
+      'IMG_COUNT'   => !empty($categories_count_images[ $category['id'] ]) ? $categories_count_images[ $category['id'] ] : 0,
+      'LAST_UPDATE' => format_date($category['smart_update'], true),
 
-      'U_JUMPTO'   => make_index_url(
-        array(
-          'category' => $category
-          )
-        ),
-
-      'U_EDIT'     => $base_url.'album-'.$category['id'],
-      'U_DELETE'   => $self_url.'&delete='.$category['id'].'&pwg_token='.get_pwg_token(),
-      'U_SMART'    => $self_url.'&smart_generate='.$category['id'],
+      'U_JUMPTO'    => make_index_url(array('category' => $category)),
+      'U_EDIT'      => SMART_ADMIN.'-album&cat_id='.$category['id'],
+      'U_DELETE'    => $self_url.'&delete='.$category['id'].'&pwg_token='.get_pwg_token(),
+      'U_SMART'     => $self_url.'&smart_generate='.$category['id'],
     );
-
-  if ( array_key_exists($category['id'], $categories_with_images) )
-  {
-    $tpl_cat['U_MANAGE_ELEMENTS'] =
-      $base_url.'batch_manager&cat='.$category['id'];
-  }
   
   $template->append('categories', $tpl_cat);