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
|
# File 'app/controllers/ahoy_panel/visits_controller.rb', line 3
def index
@start_date = params[:start_date].to_date.beginning_of_day
@end_date = params[:end_date].blank? ? nil : params[:end_date].to_date.end_of_day
@page = params[:page]
@filtering_params = JSON.parse(params[:filtering_params], symbolize_names: true)
@date_range = if @end_date.blank?
@start_date..params[:start_date].to_date.end_of_day
else
@start_date..@end_date
end
@visits = ::Ahoy::Visit.where(started_at: @date_range).order(:id)
@filtering_params.each do |key, value|
case key
when :id
@visits = @visits.where(id: value.to_i)
when :user_id
@visits = @visits.where(user_id: value.to_i)
when :user_agent
@visits = @visits.where("user_agent ilike ?", "%#{value}%")
when :referrer
@visits = @visits.where("referrer ilike ?", "%#{value}%")
when :referring_domain
@visits = @visits.where("referring_domain ilike ?", "%#{value}%")
when :landing_page
@visits = @visits.where("landing_page ilike ?", "%#{value}%")
when :browser
@visits = @visits.where("browser ilike ?", "%#{value}%")
when :os
@visits = @visits.where("os ilike ?", "%#{value}%")
when :device_type
@visits = @visits.where("device_type ilike ?", "%#{value}%")
when :country
@visits = @visits.where("country ilike ?", "%#{value}%")
when :city
@visits = @visits.where("city ilike ?", "%#{value}%")
when :region
@visits = @visits.where("region ilike ?", "%#{value}%")
when :utm_source
@visits = @visits.where("utm_source ilike ?", "%#{value}%")
when :utm_medium
@visits = @visits.where("utm_medium ilike ?", "%#{value}%")
when :utm_term
@visits = @visits.where("utm_term ilike ?", "%#{value}%")
when :utm_content
@visits = @visits.where("utm_content ilike ?", "%#{value}%")
when :utm_campaign
@visits = @visits.where("utm_campaign ilike ?", "%#{value}%")
when :app_version
@visits = @visits.where("app_version ilike ?", "%#{value}%")
when :os_version
@visits = @visits.where("os_version ilike ?", "%#{value}%")
when :platform
@visits = @visits.where("platform ilike ?", "%#{value}%")
end
end
if @page.present?
@visits = @visits.page(@page)
end
render json: { visits: @visits, total_count: @page.present? ? @visits.total_count : nil }
end
|