add a "project activity report"

This is per:
 https://cards.linaro.org/browse/REQ-651

We have a few people that want a global view of what projects are
most actively contributed to by Linaro. I spent a little time trying
to come up with the most efficient way to query this information.
Ultimately I choose a single query that then filled in the 3
reports we need (12mon, 6mon, 3mon). I was finding any other
approach required me to hit the DB more.

This query runs around 9 seconds at home, but can take up to 20s
in production (i assume slow ec2 disk). Because of this, and the
fact its targeted to a limited one-off type audience, I'm not
exposing the URL any where on our site. ie - users have to know
about the URL to pull up this report.

Change-Id: I9847fc5e33edd5a0652796a209ff799810139ae7

1 files changed, 16 insertions, 0 deletions

diff --git a/templates/patchmetrics/report_project_activity.html b/templates/patchmetrics/report_project_activity.html
new file mode 100644
index 0000000..e734018
--- /dev/null
+++ b/templates/patchmetrics/report_project_activity.html
@@ -0,0 +1,16 @@
+{% extends "base.html" %}
+
+{% block title %}Linaro Reports: Project Activity{% endblock %}
+{% block heading %}Project Activity{% endblock %}
+
+{% block body %}
+
+<h2>Top {{ summary|length}} Linaro Project Contributions</h2>
+<table class="patchlist">
+  <tr><th>Project</th><th>Last year</th><th>6 months</th><th>3 months</th></tr>
+{% for s in summary %}
+  <tr class="{% cycle 'odd' 'even' %}">{% for td in s %}<td>{{td}}</td>{% endfor %}</tr>
+{% endfor %}
+<table>
+
+{% endblock %}