basic initial stats page for see something

3 files changed, 87 insertions, 0 deletions

diff --git a/perllib/FixMyStreet/App/Controller/Admin.pm b/perllib/FixMyStreet/App/Controller/Admin.pm
index 4999d16f2..1bb9c8e4c 100644
--- a/perllib/FixMyStreet/App/Controller/Admin.pm
+++ b/perllib/FixMyStreet/App/Controller/Admin.pm
@@ -925,6 +925,10 @@ sub stats : Path('stats') : Args(0) {
 
     $c->forward('check_page_allowed');
 
+    if ( $c->cobrand->moniker eq 'seesomething' ) {
+        return $c->cobrand->admin_stats( $c );
+    }
+
     $c->forward('set_up_council_details');
 
     if ( $c->req->param('getcounts') ) {
diff --git a/perllib/FixMyStreet/Cobrand/SeeSomething.pm b/perllib/FixMyStreet/Cobrand/SeeSomething.pm
index 629a5ee50..ca7657176 100644
--- a/perllib/FixMyStreet/Cobrand/SeeSomething.pm
+++ b/perllib/FixMyStreet/Cobrand/SeeSomething.pm
@@ -80,5 +80,45 @@ sub allow_anonymous_reports { 1; }
 
 sub anonymous_account { return { name => 'anon user', email => 'anon@example.com' }; }
 
+sub admin_pages {
+    my $self = shift;
+
+    return {
+        'stats' => ['Reports', 0],
+    };
+};
+
+sub admin_stats {
+    my ( $self, $c ) = @_;
+
+    my %filters = ();
+
+    if ( !$c->user_exists || !grep { $_ == $c->user->from_council } @{ $self->council_id } ) {
+        $c->detach( '/page_error_404_not_found' );
+    }
+
+    if ( $c->req->param('category') ) {
+        $filters{category} = $c->req->param('category');
+    }
+
+    if ( $c->req->param('subcategory') ) {
+        $filters{subcategory} = $c->req->param('subcategory');
+    }
+
+    my $p = $c->model('DB::Problem')->search(
+        {
+            confirmed => { not => undef },
+            %filters
+        },
+        {
+                order_by => { -desc=> [ 'confirmed' ] }
+        }
+    );
+
+    $c->stash->{reports} = $p;
+
+    return 1;
+}
+
 1;
 
diff --git a/templates/web/seesomething/admin/stats.html b/templates/web/seesomething/admin/stats.html
new file mode 100644
index 000000000..2ddb3e665
--- /dev/null
+++ b/templates/web/seesomething/admin/stats.html
@@ -0,0 +1,43 @@
+[% INCLUDE 'admin/header.html' title=loc('Reports') %]
+[% PROCESS 'admin/report_blocks.html' %]
+
+<form method="post" action="[% c.uri_for('reports') %]" enctype="application/x-www-form-urlencoded" accept-charset="utf-8">
+    <select name="category">
+        <option value="">Select</option>
+        <option value="Bus">Bus</option>
+        <option value="Metro">Metro</option>
+        <option value="Train">Train</option>
+    </select>
+
+    <select name="subcategory">
+        <option value="">Select</option>
+        <option value="Smoking">Smoking</option>
+    </select>
+
+    <input type="submit" name="getcounts"  size="30" id="getcounts" value="Look Up" />
+</form>
+
+<table>
+    <thead>
+        <tr>
+            <th>ID</th>
+            <th>Description</th>
+            <th>Transport Category</th>
+            <th>Incident Category</th>
+            <th>Submitted</th>
+        </tr>
+    </thead>
+    <tbody>
+        [%- WHILE (report = reports.next) %]
+        <tr>
+            <td>[% report.id %]</td>
+            <td>[% report.detail %]</td>
+            <td>[% report.category %]</td>
+            <td>[% report.subcategory %]</td>
+            <td>[% PROCESS format_time time=report.confirmed %]</td>
+        </tr>
+        [%- END %]
+    </tbody>
+</table>
+
+[% INCLUDE 'admin/footer.html' %]