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
|
namespace :stats do
desc 'Produce transaction stats'
task :show => :environment do
month_starts = (Date.new(2009, 1)..Date.new(2011, 5)).select { |d| d.day == 1 }
month_starts.each do |month_start|
month_end = month_start.end_of_month
puts "#{month_start}-#{month_end}"
date_conditions = ['created_at >= ?
AND created_at < ?',
month_start, month_end+1]
request_count = InfoRequest.count(:conditions => date_conditions)
puts "Requests sent: #{request_count}"
comment_count = Comment.count(:conditions => date_conditions)
puts "Annotations added: #{comment_count}"
track_conditions = ['track_type = ?
AND track_medium = ?
AND created_at >= ?
AND created_at < ?',
'request_updates', 'email_daily', month_start, month_end+1]
email_request_track_count = TrackThing.count(:conditions => track_conditions)
puts "Track this request email signups: #{email_request_track_count}"
comment_on_own_request_conditions = ['comments.user_id = info_requests.user_id
AND comments.created_at >= ?
AND comments.created_at < ?',
month_start, month_end+1]
comment_on_own_request_count = Comment.count(:conditions => comment_on_own_request_conditions,
:include => :info_request)
followup_conditions = ['message_type = ?
AND created_at >= ?
AND created_at < ?',
'followup', month_start, month_end+1]
follow_up_count = OutgoingMessage.count(:conditions => followup_conditions)
comments_and_followup_count = comment_on_own_request_count.to_i + follow_up_count.to_i
puts "Comments on own requests, follow ups sent: #{comments_and_followup_count}"
end
end
end
|
