Changeset 5743

Timestamp:

Apr 9, 2010, 9:47:29 PM (15 years ago)

Author:

plg

Message:

feature 1591: smarter default categories in upload form. We use the most
recently added photo as reference.

Location:

trunk/admin

Files:

• photos_add_direct.php (modified) (2 diffs)
• themes/default/template/photos_add_direct.tpl (modified) (2 diffs)

trunk/admin/photos_add_direct.php

@@ -380 +380 @@
 }
 
+// categories
+//
+// we need to know the category in which the last photo was added
+$selected_category = array();
+$selected_parent = array();
+
+$query = '
+SELECT
+    category_id,
+    id_uppercat
+  FROM '.IMAGES_TABLE.' AS i
+    JOIN '.IMAGE_CATEGORY_TABLE.' AS ic ON image_id = i.id
+    JOIN '.CATEGORIES_TABLE.' AS c ON category_id = c.id
+  ORDER BY i.id DESC
+  LIMIT 1
+;';
+$result = pwg_query($query);
+if (pwg_db_num_rows($result) > 0)
+{
+  $row = pwg_db_fetch_assoc($result);
+  
+  $selected_category = array($row['category_id']);
+
+  if (!empty($row['id_uppercat']))
+  {
+    $selected_parent = array($row['id_uppercat']);
+  }
+}
+
+// existing category
 $query = '
 SELECT id,name,uppercats,global_rank
@@ -387 +417 @@
 display_select_cat_wrapper(
   $query,
-  array(),
+  $selected_category,
   'category_options'
   );
+
+// new category
+display_select_cat_wrapper(
+  $query,
+  $selected_parent,
+  'category_parent_options'
+  );
+
 
 // image level options

trunk/admin/themes/default/template/photos_add_direct.tpl

@@ -173 +173 @@
       <div id="category_type_existing" style="display:none" class="category_selection">
         <select class="categoryDropDown" name="category">
-          {html_options options=$category_options}
+          {html_options options=$category_options selected=$category_options_selected}
         </select>
       </div>
@@ -184 +184 @@
               <select class="categoryDropDown" name="category_parent">
                 <option value="0">------------</option>
-                {html_options options=$category_options}
+                {html_options options=$category_parent_options selected=$category_parent_options_selected}
               </select>
             </td>