From c2ccb9dcb2c6440952a41761bd5312a5b9cc7e9d Mon Sep 17 00:00:00 2001
From: Robert Sesek <rsesek@bluestatic.org>
Date: Thu, 7 Dec 2006 01:24:51 +0000
Subject: [PATCH] r1334: Allow the exporting of search results to XML format

---
 docs/changes.txt             |  1 +
 search.php                   | 48 ++++++++++++++++++++++++++++++++++++
 templates/search_results.tpl |  2 ++
 3 files changed, 51 insertions(+)

diff --git a/docs/changes.txt b/docs/changes.txt
index 6109214..6a1f2e0 100644
--- a/docs/changes.txt
+++ b/docs/changes.txt
@@ -2,6 +2,7 @@
 ===============================
 - When a user does not have any favorites in his list, show a message instead of an empty screen
 - Added the ability to show all the users in a paginated list in the admin section (bug://report/55)
+- Can export search results to an XML file (bug://report/41)
 
 1.1.4
 ===============================
diff --git a/search.php b/search.php
index 936f954..bb72ac0 100644
--- a/search.php
+++ b/search.php
@@ -372,6 +372,54 @@ if ($_REQUEST['do'] == 'search')
 
 // ###################################################################
 
+if ($_REQUEST['do'] == 'export')
+{
+	// TODO - allow guests to use the export function too
+	$search = $db->query_first("SELECT * FROM " . TABLE_PREFIX . "search WHERE userid = " . $bugsys->userinfo['userid']);
+	$bugs = $db->query("SELECT * FROM " . TABLE_PREFIX . "bug WHERE bugid IN ($search[ids]) $search[orderby]");
+	
+	$xml = '<?xml version="1.0" encoding="' . $language['charset'] . '"?>
+
+<bugdarExport user="' . $bugsys->unsanitize(construct_user_display($bugsys->userinfo, false)) . '" date="' . $datef->format('r', TIMENOW) . '">';
+
+	while ($bug = $db->fetch_array($bugs))
+	{
+		$xml .= "\n\t<bug>";
+		
+		ProcessBugDataForDisplay(&$bug);
+		
+		$xml .= "\n\t\t<id>" . $bug['bugid'] . "</id>";
+		$xml .= "\n\t\t<dateReported>" . $datef->format('r', $bug['dateline']) . "</dateReported>";
+		if ($bug['userid'])
+		{
+			$xml .= "\n\t\t<reporter>" . construct_user_display($db->query_first("SELECT * FROM " . TABLE_PREFIX . "user WHERE userid = $bug[userid]"), false) . "</reporter>";
+		}
+		$xml .= "\n\t\t<summary>" . $bug['summary'] . "</summary>";
+		$xml .= "\n\t\t<product>" . $bug['product'] . "</product>";
+		if ($bug['component'])
+		{
+			$xml .= "\n\t\t<component>" . $bug['component'] . "</component>";
+		}
+		$xml .= "\n\t\t<version>" . $bug['version'] . "</version>";
+		$xml .= "\n\t\t<status>" . $bug['status'] . "</status>";
+		if ($bug['assignedto'])
+		{
+			$xml .= "\n\t\t<assignedTo>" . construct_user_display($bugsys->datastore['assignto']["$bug[assignedto]"], false) . "</assignedTo>";
+		}
+		$xml .= "\n\t\t<resolution>" . $bug['resolution'] . "</resolution>";
+		$xml .= "\n\t\t<severity>" . $bug['severity'] . "</severity>";
+		$xml .= "\n\t\t<priority>" . $bug['priority'] . "</priority>";
+		
+		$xml .= "\n\t</bug>";
+	}
+	
+	$xml .= "\n</bugdarExport>";
+	
+	$funct->download_file($xml, _('bugdar-search-results.xml'), true);
+}
+
+// ###################################################################
+
 if ($_REQUEST['do'] == 'results')
 {
 	$show['cached'] = false;
diff --git a/templates/search_results.tpl b/templates/search_results.tpl
index 8a780f6..e632f3b 100644
--- a/templates/search_results.tpl
+++ b/templates/search_results.tpl
@@ -27,6 +27,8 @@ $header
 $bugs
 </table>
 
+<div><a href="search.php?do=export">{@"Export results as XML"}</a></div>
+
 <if condition="$show['pagenav']">
 <!-- pagenav -->
 <div align="$stylevar[right]">
-- 
2.22.5