Changeset 27164 for extensions/physical2virtual/main.inc.php

Timestamp:

Feb 4, 2014, 4:13:30 PM (10 years ago)

Author:

JanisV

Message:

Set thumbnails for new virtual albums
Make physical albums private
Processing folder structure

File:

• extensions/physical2virtual/main.inc.php (modified) (3 diffs)

extensions/physical2virtual/main.inc.php

@@ -30 +30 @@
 }
 
+function find_or_create_virtual_category($category_name, $parent_id=null, $options=array())
+{
+  if (!is_null($parent_id))
+  {
+    $sub_ids = get_subcat_ids(array($parent_id));
+    foreach ($sub_ids as $id)
+    {
+      $cat_info = get_cat_info($id);
+      if ($cat_info['name'] == $category_name and !$cat_info['dir'])
+        return $cat_info;
+    }
+  }
+
+  return create_virtual_category($category_name, $parent_id, $options);
+}
+
 function physical2virtual_convert()
 {
@@ -35 +51 @@
 
   $query = '
-    SELECT name
-    FROM '.CATEGORIES_TABLE.'
-    WHERE dir IS NULL
-  ;';  // get virtual
-  $virt_cats = array_from_query($query, 'name'); 
-  
-  $query = '
-    SELECT id, name
+    SELECT id, name, id_uppercat
     FROM '.CATEGORIES_TABLE.'
     WHERE dir IS NOT NULL
@@ -50 +59 @@
   {
     $virt_name = $row['name'];
-    $created = false;
-    if (!in_array($virt_name, $virt_cats))
+
+    $parent = isset($conf['physical2virtual']['parent_cat']) ? $conf['physical2virtual']['parent_cat'] : null;
+        
+    if ($conf['physical2virtual']['store_structure'])
     {
-      $parent = isset($conf['physical2virtual']['parent_cat']) ? $conf['physical2virtual']['parent_cat'] : null;
-      $virt_id = create_virtual_category($virt_name, $parent)['id'];
-      $created = true;
-
-      if (isset($conf['physical2virtual']['lock_physical']) and $conf['physical2virtual']['lock_physical'])
+      // get array of physical parents
+      $cat_info = get_cat_info($row['id']);
+      $uppers = $cat_info['upper_names'];
+      array_pop($uppers); // remove themself
+      
+      foreach ($uppers as $upper)
       {
-        $cat_info = get_cat_info($row['id']);
-        if ($cat_info['visible'] == true)
-        {
-          set_cat_visible(array($row['id']), false);
-        }
-      }
-      if (isset($conf['physical2virtual']['private_physical']) and $conf['physical2virtual']['private_physical'])
-      {
-        set_cat_status(array($row['id']), 'private'); 
+        $parent = find_or_create_virtual_category($upper['name'], $parent)['id'];
       }
     }
-    else
+
+    $virt_cat = find_or_create_virtual_category($virt_name, $parent);
+//    $virt_cat = create_virtual_category($virt_name, $parent)['id']; // use this for duplicate folders name
+
+    if (isset($conf['physical2virtual']['lock_physical']) and $conf['physical2virtual']['lock_physical'])
     {
-      // Get existen virt category ID
-      $query = '
-        SELECT id FROM '.CATEGORIES_TABLE.' WHERE dir IS NULL AND name = \''.pwg_db_real_escape_string($virt_name).'\'
-      ;';
-      list($virt_id) = pwg_db_fetch_row(pwg_query($query));
+      $cat_info = get_cat_info($row['id']);
+      if ($cat_info['visible'] == true)
+      {
+        set_cat_visible(array($row['id']), false);
+      }
+    }
+    if (isset($conf['physical2virtual']['private_physical']) and $conf['physical2virtual']['private_physical'])
+    {
+      set_cat_status(array($row['id']), 'private'); 
     }
 
     $query = '
       INSERT IGNORE INTO '.IMAGE_CATEGORY_TABLE.' (category_id, image_id)
-        SELECT '.$virt_id.', image_id FROM '.IMAGE_CATEGORY_TABLE.' WHERE category_id = '.$row['id'].'
+        SELECT '.$virt_cat['id'].', image_id FROM '.IMAGE_CATEGORY_TABLE.' WHERE category_id = '.$row['id'].'
     ;';
     pwg_query($query);
 
-    if ($created)
+    if (!(isset($virt_cat['representative_picture_id']) and $virt_cat['representative_picture_id']))
     {
-      set_random_representant(array($virt_id));
+      set_random_representant(array($virt_cat['id']));
     }
   }