Add "Last Votes by TU" list

This shows a list of all Trusted Users and the vote ID of the last
proposal each of the TUs voted on. This list is sorted by vote ID.

Signed-off-by: Lukas Fleischer <archlinux@cryptocrack.de>

1 files changed, 19 insertions, 0 deletions

diff --git a/web/lib/acctfuncs.inc.php b/web/lib/acctfuncs.inc.php
index 31cdd79..f52dfc3 100644
--- a/web/lib/acctfuncs.inc.php
+++ b/web/lib/acctfuncs.inc.php
@@ -996,6 +996,25 @@ function past_proposal_list($order, $lim) {
 }
 
 /**
+ * Get the vote ID of the last vote of all Trusted Users
+ *
+ * @return array The vote ID of the last vote of each Trusted User
+ */
+function last_votes_list() {
+	$dbh = DB::connect();
+
+	$q = "SELECT UserID, MAX(VoteID) AS LastVote FROM TU_Votes GROUP BY UserID ORDER BY VoteID DESC";
+	$result = $dbh->query($q);
+
+	$details = array();
+	while ($row = $result->fetch(PDO::FETCH_ASSOC)) {
+		$details[] = $row;
+	}
+
+	return $details;
+}
+
+/**
  * Determine the total number of Trusted User proposals
  *
  * @return string The total number of Trusted User proposals