Changeset 17002 for trunk/admin/include

Timestamp:

Jul 25, 2012, 12:20:40 PM (12 years ago)

Author:

plg

Message:

merge r17001 from branch 2.4 to trunk

bug 2627 fixed: photos added with the web form or pwg.images.addSimple now have
a correct image_category.rank.

File:

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

trunk/admin/include/functions.php

@@ -1508 +1508 @@
   pwg_query($query);
 
+  $query = '
+SELECT
+    category_id,
+    MAX(rank) AS max_rank
+  FROM '.IMAGE_CATEGORY_TABLE.'
+  WHERE rank IS NOT NULL
+    AND category_id IN ('.implode(',', $categories).')
+  GROUP BY category_id
+;';
+
+  $current_rank_of = simple_hash_from_query(
+    $query,
+    'category_id',
+    'max_rank'
+    );
+
   $inserts = array();
   foreach ($categories as $category_id)
   {
+    if (!isset($current_rank_of[$category_id]))
+    {
+      $current_rank_of[$category_id] = 0;
+    }
+
     foreach ($images as $image_id)
     {
+      $rank = ++$current_rank_of[$category_id];
+
       array_push(
         $inserts,
@@ -1518 +1541 @@
           'image_id' => $image_id,
           'category_id' => $category_id,
+          'rank' => $rank,
           )
         );
@@ -2342 +2366 @@
 function delete_element_derivatives($infos, $type='all')
 {
+file_put_contents('/tmp/pwg24ws.log', "\n==== ".date('c')."\n".__FUNCTION__.' : '.var_export($infos, true)."\n", FILE_APPEND);
   $path = $infos['path'];
   if (!empty($infos['representative_ext']))