Changeset 2579

Timestamp:

Sep 24, 2008, 3:27:49 AM (16 years ago)

Author:

rvelices

Message:

• feature admin element set: recently posted images (nice if you forget add to caddie during synchro phase)

Location:

trunk

Files:

• admin.php (modified) (1 diff)
• admin/element_set.php (modified) (8 diffs)
• admin/template/goto/admin.tpl (modified) (1 diff)
• admin/template/goto/theme/roma/themeconf.inc.php (modified) (1 diff)

trunk/admin.php

@@ -88 +88 @@
     'U_RATING'=> $link_start.'rating',
     'U_CADDIE'=> $link_start.'element_set&cat=caddie',
+    'U_RECENT_SET'=> $link_start.'element_set&cat=recent',
     'U_TAGS'=> $link_start.'tags',
     'U_THUMBNAILS'=> $link_start.'thumbnail',

trunk/admin/element_set.php

@@ -25 +25 @@
  * Management of elements set. Elements can belong to a category or to the
  * user caddie.
- * 
+ *
  */
- 
+
 if (!defined('PHPWG_ROOT_PATH'))
 {
@@ -103 +103 @@
 // To element_set_(global|unit).php, we must provide the elements id of the
 // managed category in $page['cat_elements_id'] array.
-
+$page['cat_elements_id'] = array();
 if (is_numeric($_GET['cat']))
 {
@@ -112 +112 @@
       false
       );
-  
+
   $query = '
 SELECT image_id
@@ -123 +123 @@
 {
   $page['title'] = l10n('caddie');
-  
+
   $query = '
 SELECT element_id
@@ -134 +134 @@
 {
   $page['title'] = l10n('Elements_not_linked');
-  
+
   // we are searching elements not linked to any virtual category
   $query = '
@@ -160 +160 @@
     $page['cat_elements_id'] = array_diff($all_elements, $linked_to_virtual);
   }
-  else
-  {
-    $page['cat_elements_id'] = array();
-  }
 }
 else if ('duplicates' == $_GET['cat'])
 {
   $page['title'] = l10n('Duplicates');
-  
+
   // we are searching related elements twice or more to physical categories
   // 1 - Retrieve Files
   $query = '
 SELECT DISTINCT(file)
-  FROM '.IMAGES_TABLE.' 
- GROUP BY file 
-HAVING COUNT(DISTINCT storage_category_id) > 1 
-;';  
+  FROM '.IMAGES_TABLE.'
+ GROUP BY file
+HAVING COUNT(DISTINCT storage_category_id) > 1
+;';
 
   $duplicate_files = array_from_query($query, 'file');
@@ -183 +179 @@
   $query = '
 SELECT id, file
-  FROM '.IMAGES_TABLE.' 
+  FROM '.IMAGES_TABLE.'
 WHERE file IN (\''.implode("','", $duplicate_files).'\')
 ORDER BY file, id
@@ -189 +185 @@
 
   $page['cat_elements_id'] = array_from_query($query, 'id');
-  $page['cat_elements_id'][] = 0;
-}
+}
+elseif ('recent'== $_GET['cat'])
+{
+  $page['title'] = l10n('recent_pics_cat');
+  $query = 'SELECT MAX(date_available) AS date
+  FROM '.IMAGES_TABLE;
+  if ($row=mysql_fetch_array( pwg_query($query) ) )
+  {
+    $query = 'SELECT id
+  FROM '.IMAGES_TABLE.'
+  WHERE date_available BETWEEN DATE_SUB("'.$row['date'].'", INTERVAL 1 DAY) AND "'.$row['date'].'"';
+    $page['cat_elements_id'] = array_from_query($query, 'id');
+  }
+}
+
 // +-----------------------------------------------------------------------+
 // |                       first element to display                        |

trunk/admin/template/goto/admin.tpl

@@ -65 +65 @@
         <li><a href="{$U_TAGS}">{'Tags'|@translate}</a></li>
         <li><a href="{$U_CADDIE}">{'Caddie'|@translate}</a></li>
+        <li><a href="{$U_RECENT_SET}">{'recent_pics_cat'|@translate}</a></li>
       </ul>
     </dd>

trunk/admin/template/goto/theme/roma/themeconf.inc.php

@@ -18 +18 @@
       case 'cat_move':
       case 'cat_options':
-      case 'element_set':
       case 'cat_perm':
       case 'permalinks':
+        return 2;
+      case 'element_set':
+        if (isset($_GET['cat']) and is_numeric($_GET['cat']) ) {
+          return 2;
+        }
       case 'picture_modify':
-        if (isset($_GET['cat']) and $_GET['cat']=='caddie') {
-          return 3;
-        }
-        return 2;
+        return 3;
       case 'comments':
       case 'upload':