forked from Gitlink/forgeplus
77 lines
3.2 KiB
Ruby
77 lines
3.2 KiB
Ruby
class Admins::DashboardsController < Admins::BaseController
|
|
def index
|
|
# 用户活跃数
|
|
day_user_ids = CommitLog.where(created_at: today).pluck(:user_id).uniq
|
|
weekly_user_ids = CommitLog.where(created_at: current_week).pluck(:user_id).uniq
|
|
month_user_ids = CommitLog.where(created_at: current_month).pluck(:user_id).uniq
|
|
@active_user_count = User.where(last_login_on: today).or(User.where(id: day_user_ids)).count
|
|
@weekly_active_user_count = User.where(last_login_on: current_week).or(User.where(id: weekly_user_ids)).count
|
|
@month_active_user_count = User.where(last_login_on: current_month).or(User.where(id: month_user_ids)).count
|
|
user_ids = User.where(created_on: pre_week).pluck(:id).uniq
|
|
weekly_keep_user_count = User.where(id: user_ids).where(last_login_on: current_week).count
|
|
@weekly_keep_rate = format("%.2f", user_ids.size > 0 ? weekly_keep_user_count.to_f / user_ids.size : 0)
|
|
|
|
# 新用户注册数
|
|
@day_new_user_count = User.where(created_on: today).count
|
|
@weekly_new_user_count = User.where(created_on: current_week).count
|
|
@month_new_user_count = User.where(created_on: current_month).count
|
|
|
|
# 活跃项目数
|
|
day_project_ids = (CommitLog.where(created_at: today).pluck(:project_id).uniq + Issue.where(created_on: today).pluck(:project_id).uniq).uniq
|
|
weekly_project_ids = (CommitLog.where(created_at: current_week).pluck(:project_id).uniq + Issue.where(created_on: current_week).pluck(:project_id).uniq).uniq
|
|
month_project_ids = (CommitLog.where(created_at: current_month).pluck(:project_id).uniq + Issue.where(created_on: current_month).pluck(:project_id).uniq).uniq
|
|
@day_active_project_count = Project.where(updated_on: today).or(Project.where(id: day_project_ids)).count
|
|
@weekly_active_project_count = Project.where(updated_on: current_week).or(Project.where(id: weekly_project_ids)).count
|
|
@month_active_project_count = Project.where(updated_on: current_month).or(Project.where(id: month_project_ids)).count
|
|
|
|
# 新增项目数
|
|
@day_new_project_count = Project.where(created_on: today).count
|
|
@weekly_new_project_count = Project.where(created_on: current_week).count
|
|
@month_new_project_count = Project.where(created_on: current_month).count
|
|
end
|
|
|
|
def month_active_user
|
|
count = UserExtension.where(created_at: current_month).group(:identity).count
|
|
|
|
data = [
|
|
{ value: count['teacher'].to_i, name: '老师' },
|
|
{ value: count['student'].to_i, name: '学生' },
|
|
{ value: count['professional'].to_i, name: '专业人士' },
|
|
{ value: count[nil].to_i, name: '未选职业' },
|
|
]
|
|
render_ok(data: data)
|
|
end
|
|
|
|
def evaluate
|
|
names = []
|
|
data = []
|
|
|
|
1.upto(7) do |i|
|
|
date = i.days.ago
|
|
names.unshift(date.strftime('%Y-%m-%d'))
|
|
|
|
count = Output.where(created_at: date.beginning_of_day..date.end_of_day).count
|
|
data.unshift(count)
|
|
end
|
|
|
|
render_ok(names: names, data: data)
|
|
end
|
|
|
|
private
|
|
|
|
def today
|
|
Time.now.beginning_of_day..Time.now.end_of_day
|
|
end
|
|
|
|
def current_week
|
|
7.days.ago.end_of_day..Time.now.end_of_day
|
|
end
|
|
|
|
def current_month
|
|
30.days.ago.end_of_day..Time.now.end_of_day
|
|
end
|
|
|
|
def pre_week
|
|
14.days.ago.end_of_day..7.days.ago.end_of_day
|
|
end
|
|
end |