From b326b543f294f794762a2b1d68a614e1168fa39b Mon Sep 17 00:00:00 2001
From: randomdan <randomdan@localhost>
Date: Fri, 30 Jul 2010 20:16:23 +0000
Subject: Check user is logged in before presenting account pages Provide a
 list of currently tracked packages

---
 gentoobrowse/checks/loggedIn.xml        |  6 ++++++
 gentoobrowse/login.xslt                 | 18 +++++++++++++++++-
 gentoobrowse/present/accountHome.xml    |  2 ++
 gentoobrowse/present/accountTracked.xml | 26 ++++++++++++++++++++++++++
 4 files changed, 51 insertions(+), 1 deletion(-)
 create mode 100644 gentoobrowse/checks/loggedIn.xml
 create mode 100644 gentoobrowse/present/accountTracked.xml

diff --git a/gentoobrowse/checks/loggedIn.xml b/gentoobrowse/checks/loggedIn.xml
new file mode 100644
index 0000000..7e83515
--- /dev/null
+++ b/gentoobrowse/checks/loggedIn.xml
@@ -0,0 +1,6 @@
+<?xml version="1.0"?>
+<project2:regexcheck xmlns:project2="http://project2.randomdan.homeip.net" apply-to="%loggedInUserID|" present="login" name="loggedIn">
+	<regex>.</regex>
+	<message>Not logged in</message> 
+</project2:regexcheck>
+
diff --git a/gentoobrowse/login.xslt b/gentoobrowse/login.xslt
index 7849fe4..71265ef 100644
--- a/gentoobrowse/login.xslt
+++ b/gentoobrowse/login.xslt
@@ -8,6 +8,22 @@
     doctype-system="http://www.w3.org/TR/html4/loose.dtd"
     doctype-public="-//W3C//DTD HTML 4.01 Transitional//EN" />
   <xsl:template name="content">
-  	<xsl:apply-templates select="form|para" />
+  	<xsl:apply-templates select="form|para|trackedebuilds" />
+  </xsl:template>
+  <xsl:template match="/gentoo/trackedebuilds">
+  	<h2>Tracked packages</h2>
+	<ul>
+		<xsl:apply-templates select="ebuild" />
+	</ul>
+  </xsl:template>
+  <xsl:template match="/gentoo/trackedebuilds/ebuild">
+  	<li>
+		<a>
+			<xsl:attribute name="href">
+				/package/<xsl:value-of select="catname" />/<xsl:value-of select="pkgname" />
+			</xsl:attribute>
+			<xsl:value-of select="catname" />/<xsl:value-of select="pkgname" />-<xsl:value-of select="latestversion" />
+		</a>
+	</li>
   </xsl:template>
 </xsl:stylesheet>
diff --git a/gentoobrowse/present/accountHome.xml b/gentoobrowse/present/accountHome.xml
index aea6835..8628d8c 100644
--- a/gentoobrowse/present/accountHome.xml
+++ b/gentoobrowse/present/accountHome.xml
@@ -1,8 +1,10 @@
 <?xml version="1.0"?>
 <view name="index" root="gentoo" style="login.xslt" xmlns:xi="http://www.w3.org/2001/XInclude"
 		xmlns:project2="http://project2.randomdan.homeip.net">
+	<xi:include href="../checks/loggedIn.xml" />
 	<project2:rawview>
 		<form caption="Logout" submit="Logout" action="/dologout" method="post" />
+		<para>View my <a href="/accountTracked">tracked packages</a>.</para>
 	</project2:rawview>
 </view>
 
diff --git a/gentoobrowse/present/accountTracked.xml b/gentoobrowse/present/accountTracked.xml
new file mode 100644
index 0000000..89e8da8
--- /dev/null
+++ b/gentoobrowse/present/accountTracked.xml
@@ -0,0 +1,26 @@
+<?xml version="1.0"?>
+<view name="index" root="gentoo" style="login.xslt" xmlns:xi="http://www.w3.org/2001/XInclude"
+		xmlns:project2="http://project2.randomdan.homeip.net">
+	<xi:include href="../datasources/postgres.xml" />
+	<xi:include href="../checks/loggedIn.xml" />
+	<project2:sqlview name="trackedebuilds" recordname="ebuild" datasource="postgres">
+		<sql>
+			SELECT c.name AS catname, p.name AS pkgname, (
+				SELECT e.version
+				FROM ebuilds e
+				WHERE e.packageid = p.packageid
+				ORDER BY e.versioninst
+				DESC LIMIT 1) AS latestversion
+			FROM user_packages up, packages p, categories c
+			WHERE up.packageid = p.packageid
+			AND c.categoryid = p.categoryid
+			AND up.userid = ?
+			ORDER BY c.name, p.name
+		</sql>
+		<parameters>
+			<param bind="0" value="%loggedInUserID|0" />
+		</parameters>
+	</project2:sqlview>
+</view>
+
+
-- 
cgit v1.2.3