From c4acac31f7c7d41180338525e800ee78b89dfbd3 Mon Sep 17 00:00:00 2001
From: randomdan <randomdan@localhost>
Date: Thu, 25 Nov 2010 14:09:17 +0000
Subject: Add most popular tracked packages page

---
 gentoobrowse/base.xslt           |  1 +
 gentoobrowse/popular.xslt        | 28 ++++++++++++++++++++++++++++
 gentoobrowse/present/popular.xml |  4 ++++
 gentoobrowse/views/popular.xml   | 16 ++++++++++++++++
 4 files changed, 49 insertions(+)
 create mode 100644 gentoobrowse/popular.xslt
 create mode 100644 gentoobrowse/present/popular.xml
 create mode 100644 gentoobrowse/views/popular.xml

diff --git a/gentoobrowse/base.xslt b/gentoobrowse/base.xslt
index 6653113..0a7efdc 100644
--- a/gentoobrowse/base.xslt
+++ b/gentoobrowse/base.xslt
@@ -28,6 +28,7 @@
 			<div class="tabs">
 				<a href="/">Home</a> |
 				<a href="/categories">Browse</a> |
+				<a href="/popular">Popular</a> |
 				<a href="/search" rel="nofollow">Search</a> |
 				<xsl:if test="count(/gentoo/project2:session/project2:var[@name='loggedInUserID']) = 0">
 					<a href="/login" rel="nofollow">Login</a>
diff --git a/gentoobrowse/popular.xslt b/gentoobrowse/popular.xslt
new file mode 100644
index 0000000..c65b6fa
--- /dev/null
+++ b/gentoobrowse/popular.xslt
@@ -0,0 +1,28 @@
+<?xml version="1.0" encoding="UTF-8" ?>
+<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
+	xmlns:project2="http://project2.randomdan.homeip.net" exclude-result-prefixes="project2" >
+	<xsl:import href="base.xslt" />
+  <xsl:output  encoding="utf-8"  method="html" media-type="text/html" indent="yes"
+    doctype-system="http://www.w3.org/TR/html4/loose.dtd"
+    doctype-public="-//W3C//DTD HTML 4.01 Transitional//EN" />
+  <xsl:template name="head">
+	<title>Popular Package List - Gentoo Browse</title>
+	<meta name="description">
+		<xsl:attribute name="content">List of Gentoo packages track by users</xsl:attribute>
+	</meta>
+	<meta name="keywords">
+		<xsl:attribute name="content">
+			<xsl:for-each select="/gentoo/packages/package/pkgname"><xsl:value-of select="." />, </xsl:for-each>
+		</xsl:attribute>
+	</meta>
+  </xsl:template>
+  <xsl:template name="content">
+	<xsl:apply-templates select="/gentoo/packages" />
+  </xsl:template>
+  <xsl:template match="/gentoo/packages">
+  	<h2>Popular Packages</h2>
+	<ul>
+		<xsl:apply-templates select="/gentoo/packages/package" />
+	</ul>
+  </xsl:template>
+</xsl:stylesheet>
diff --git a/gentoobrowse/present/popular.xml b/gentoobrowse/present/popular.xml
new file mode 100644
index 0000000..8f89d1a
--- /dev/null
+++ b/gentoobrowse/present/popular.xml
@@ -0,0 +1,4 @@
+<?xml version="1.0"?>
+<view name="popular" root="gentoo" style="popular.xslt" xmlns:xi="http://www.w3.org/2001/XInclude">
+	<xi:include href="../views/popular.xml" />
+</view>
diff --git a/gentoobrowse/views/popular.xml b/gentoobrowse/views/popular.xml
new file mode 100644
index 0000000..873805a
--- /dev/null
+++ b/gentoobrowse/views/popular.xml
@@ -0,0 +1,16 @@
+<?xml version="1.0"?>
+<block xmlns:xi="http://www.w3.org/2001/XInclude"
+		xmlns:project2="http://project2.randomdan.homeip.net">
+	<xi:include href="../datasources/postgres-web.xml" />
+	<project2:sqlview name="packages" recordname="package" datasource="postgres-web">
+		<sql>
+			SELECT p.packageid, MIN(c.name) AS catname, MIN(p.name) AS pkgname, MIN(p.description) AS description
+			FROM user_packages up, packages p, categories c
+			WHERE up.packageid = p.packageid
+			AND p.categoryid = c.categoryid
+			GROUP BY p.packageid
+			ORDER BY COUNT(*), MIN(c.name), MIN(p.name)
+			LIMIT 50
+		</sql>
+	</project2:sqlview>
+</block>
-- 
cgit v1.2.3