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
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
|
# app/controllers/admin_controller.rb:
# Controller for main admin pages.
#
# Copyright (c) 2007 UK Citizens Online Democracy. All rights reserved.
# Email: hello@mysociety.org; WWW: http://www.mysociety.org/
class AdminGeneralController < AdminController
skip_before_filter :authenticate, :only => :admin_js
def index
# ensure we have a trailing slash
current_uri = request.env['REQUEST_URI']
if params[:suppress_redirect].nil? && !(current_uri =~ /\/$/)
redirect_to admin_general_index_url + "/"
return
end
# Overview counts of things
@public_body_count = PublicBody.count
@info_request_count = InfoRequest.count
@outgoing_message_count = OutgoingMessage.count
@incoming_message_count = IncomingMessage.count
@user_count = User.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")
@error_message_requests = InfoRequest.find(:all, :select => '*, ' + InfoRequest.last_event_time_clause + ' as last_event_time', :conditions => ["described_state = 'error_message'"], :order => "last_event_time")
@attention_requests = InfoRequest.find(:all, :select => '*, ' + InfoRequest.last_event_time_clause + ' as last_event_time', :conditions => ["described_state = 'attention_requested'"], :order => "last_event_time")
@blank_contacts = PublicBody.find(:all, :conditions => ["request_email = ''"], :order => "updated_at")
@old_unclassified = InfoRequest.find_old_unclassified(:limit => 20,
:conditions => ["prominence = 'normal'"])
@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[:hour]
@events_title = "Events in last hour"
date_back_to = Time.now - 1.hour
end
if params[:day]
@events_title = "Events in last day"
date_back_to = Time.now - 1.day
end
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
# Get an array of event attributes within the timespan in the format
# [id, type_of_model, event_timestamp]
# Note that the relevent date for InfoRequestEvents is creation, but
# for PublicBodyVersions is update thoughout
connection = InfoRequestEvent.connection
timestamps = connection.select_rows("SELECT id,'InfoRequestEvent',
created_at AS timestamp
FROM info_request_events
WHERE created_at > '#{date_back_to.getutc}'
UNION
SELECT id, 'PublicBodyVersion',
updated_at AS timestamp
FROM #{PublicBody.versioned_class.table_name}
WHERE updated_at > '#{date_back_to.getutc}'
ORDER by timestamp desc")
@events = WillPaginate::Collection.create((params[:page] or 1), 100) do |pager|
# create a hash for each model type being returned
info_request_event_ids = {}
public_body_version_ids = {}
# get the relevant slice from the paginator
timestamps.slice(pager.offset, pager.per_page).each_with_index do |event, index|
# for each event in the slice, add an item to the hash for the model type
# whose key is the model id, and value is the position in the slice
if event[1] == 'InfoRequestEvent'
info_request_event_ids[event[0].to_i] = index
else
public_body_version_ids[event[0].to_i] = index
end
end
# get all the models in the slice, eagerly loading the associations we use in the view
public_body_versions = PublicBody.versioned_class.find(:all,
:conditions => ['id in (?)', public_body_version_ids.keys],
:include => [ { :public_body => :translations }])
info_request_events = InfoRequestEvent.find(:all,
:conditions => ['id in (?)', info_request_event_ids.keys],
:include => [:info_request])
@events = []
# drop the models into a combined array, ordered by their position in the timestamp slice
public_body_versions.each do |version|
@events[public_body_version_ids[version.id]] = [version, version.updated_at]
end
info_request_events.each do |event|
@events[info_request_event_ids[event.id]] = [event, event.created_at]
end
# inject the result array into the paginated collection:
pager.replace(@events)
# set the total entries for the page to the overall number of results
pager.total_entries = timestamps.size
end
end
def stats
# Overview counts of things
@public_body_count = PublicBody.count
@info_request_count = InfoRequest.count
@outgoing_message_count = OutgoingMessage.count
@incoming_message_count = IncomingMessage.count
@user_count = User.count
@track_thing_count = TrackThing.count
@comment_count = Comment.count
@request_by_state = InfoRequest.count(:group => 'described_state')
@tracks_by_type = TrackThing.count(:group => 'track_type')
end
def debug
@admin_current_user = admin_current_user
@current_commit = `git log -1 --format="%H"`
@current_branch = `git branch | perl -ne 'print $1 if /^\\* (.*)/'`
@current_version = `git describe --always --tags`
repo = `git remote show origin -n | perl -ne 'print $1 if m{Fetch URL: .*github\\.com[:/](.*)\\.git}'`
@github_origin = "https://github.com/#{repo}/tree/"
@request_env = request.env
end
# TODO: Remove this when support for proxy admin interface is removed
def admin_js
render :layout => false, :content_type => "application/javascript"
end
end
|
