1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
|
# app/controllers/admin_controller.rb:
# Controller for admin interface.
#
# Copyright (c) 2007 UK Citizens Online Democracy. All rights reserved.
# Email: francis@mysociety.org; WWW: http://www.mysociety.org/
#
# $Id: admin_controller.rb,v 1.22 2008-11-17 16:08:22 francis Exp $
class AdminController < ApplicationController
layout "admin"
before_filter :assign_http_auth_user
def index
# Overview counts of things
@user_count = User.count
@public_body_count = PublicBody.count
@info_request_count = InfoRequest.count
@track_thing_count = TrackThing.count
@comment_count = Comment.count
# Tasks to do
@requires_admin_requests = InfoRequest.find(:all, :select => '*, ' + InfoRequest.last_event_time_clause + ' as last_event_time', :conditions => ["described_state = 'requires_admin'"], :order => "last_event_time")
@blank_contacts = PublicBody.find(:all, :conditions => ["request_email = ''"], :order => "updated_at")
@ten_days_old_unclassified = InfoRequest.find(:all, :select => '*, ' + InfoRequest.last_event_time_clause + ' as last_event_time', :conditions => [ "awaiting_description = ? and " + InfoRequest.last_event_time_clause + " < ? and prominence != 'backpage'", true, Time.now() - 10.days ], :order => "last_event_time")
@holding_pen_messages = InfoRequest.holding_pen_request.incoming_messages
end
def timeline
# Recent events
@events_title = "Events in last two days"
date_back_to = Time.now - 2.days
if params[:week]
@events_title = "Events in last week"
date_back_to = Time.now - 1.week
end
if params[:month]
@events_title = "Events in last month"
date_back_to = Time.now - 1.month
end
if params[:all]
@events_title = "Events, all time"
date_back_to = Time.now - 1000.years
end
@events = InfoRequestEvent.find(:all, :order => "created_at desc, id desc",
:conditions => ["created_at > ? ", date_back_to])
@public_body_history = PublicBody.versioned_class.find(:all, :order => "updated_at desc, id desc",
:conditions => ["updated_at > ? ", date_back_to])
for pbh in @public_body_history
pbh.created_at = pbh.updated_at
end
@events += @public_body_history
@events.sort! { |a,b| b.created_at <=> a.created_at }
end
def stats
@request_by_state = InfoRequest.count(:group => 'described_state')
@tracks_by_type = TrackThing.count(:group => 'track_type')
end
def debug
@request_env = request.env
end
end
|
