Changeset 28105 for extensions/export_data/admin.php

Timestamp:

Apr 7, 2014, 10:29:14 AM (10 years ago)

Author:

plg

Message:

export photos (with tags list)

File:

• extensions/export_data/admin.php (modified) (3 diffs)

extensions/export_data/admin.php

@@ -32 +32 @@
 // +-----------------------------------------------------------------------+
 
-if (isset($_GET['type']) and 'albums' == $_GET['type'])
+if (isset($_GET['type']))
 {
   // output headers so that the file is downloaded rather than displayed
@@ -40 +40 @@
   // create a file pointer connected to the output stream
   $output = fopen('php://output', 'w');
-  
-  $query = '
+
+  if ('albums' == $_GET['type'])
+  {
+    $query = '
 SELECT
     id,
@@ -49 +51 @@
   ORDER BY id ASC
 ;';
-  $result = pwg_query($query);
+    $result = pwg_query($query);
 
-  set_make_full_url();
-  while ($row = pwg_db_fetch_assoc($result))
+    set_make_full_url();
+    while ($row = pwg_db_fetch_assoc($result))
+    {
+      fputcsv($output, array('url' => make_index_url(array('category' => $row))));
+    }
+  }
+
+  if ('photos' == $_GET['type'])
   {
-    fputcsv($output, array('url' => make_index_url(array('category' => $row))));
+    $query = '
+SELECT
+    i.id,
+    file,
+    date_available,
+    date_creation,
+    i.name AS title,
+    author,
+    hit,
+    filesize,
+    width,
+    height,
+    latitude,
+    longitude,
+    group_concat(t.name) AS tags,
+    comment AS description
+  FROM '.IMAGES_TABLE.' AS i
+    LEFT JOIN '.IMAGE_TAG_TABLE.' ON image_id=i.id
+    LEFT JOIN '.TAGS_TABLE.' AS t ON tag_id=t.id
+  GROUP BY i.id
+  ORDER BY i.id
+;';
+    $result = pwg_query($query);
+
+    $is_first = true;
+    while ($row = pwg_db_fetch_assoc($result))
+    {
+      if ($is_first)
+      {
+        fputcsv($output, array_keys($row));
+        $is_first = false;
+      }
+      
+      fputcsv($output, $row);
+    }
   }
+  
   exit();
 }