Changeset 13077 for trunk/admin/include/functions.php

Timestamp:

Feb 10, 2012, 11:52:07 AM (12 years ago)

Author:

plg

Message:

feature 2564: redesign on photo administration screen.

• one screen with several tabs (for now: properties + coi)

• double select boxes for album associations and representation have been converted to simple multiple select boxes with jQuery Chosen

• more details about the photo in an introduction text

File:

• trunk/admin/include/functions.php (modified) (2 diffs)

trunk/admin/include/functions.php

@@ -1532 +1532 @@
 
 /**
+ * Disssociate images from all categories except their storage category and
+ * associate to new categories.
+ *
+ * @param array images
+ * @param array categories
+ * @return void
+ */
+function move_images_to_categories($images, $categories)
+{
+  if (count($images) == 0)
+  {
+    return false;
+  }
+  
+  // let's first break links with all albums but their "storage album"
+  $query = '
+DELETE '.IMAGE_CATEGORY_TABLE.'.*
+  FROM '.IMAGE_CATEGORY_TABLE.'
+    JOIN '.IMAGES_TABLE.' ON image_id=id
+  WHERE id IN ('.implode(',', $images).')
+    AND (storage_category_id IS NULL OR storage_category_id != category_id)
+;';
+  pwg_query($query);
+    
+  if (is_array($categories) and count($categories) > 0)
+  {
+    associate_images_to_categories($images, $categories);
+  }
+}
+
+/**
  * Associate images associated to a list of source categories to a list of
  * destination categories.
@@ -1988 +2019 @@
   switch ($menu_page)
   {
+    case 'photo':
     case 'photos_add':
     case 'rating':