Class: Manage::DashboardController
- Inherits:
-
ApplicationController
- Object
- ApplicationController
- ApplicationController
- Manage::DashboardController
- Defined in:
- app/controllers/manage/dashboard_controller.rb
Instance Method Summary collapse
- #application_activity_data ⇒ Object
- #application_distribution_data ⇒ Object
- #checkin_activity_data ⇒ Object
- #confirmation_activity_data ⇒ Object
- #index ⇒ Object
- #map_data ⇒ Object
- #schools_applied_data ⇒ Object
- #schools_confirmed_data ⇒ Object
- #todays_activity_data ⇒ Object
- #todays_stats_data ⇒ Object
- #user_distribution_data ⇒ Object
Methods inherited from ApplicationController
#json_request?, #limit_write_access_to_admins, #logged_in, #require_admin_or_limited_admin, #require_admin_or_limited_admin_or_event_tracking, #response_view_or_errors
Instance Method Details
#application_activity_data ⇒ Object
45 46 47 |
# File 'app/controllers/manage/dashboard_controller.rb', line 45 def application_activity_data render json: activity_chart_data(["Non-RIT Applications", "RIT Applications", "Non-Applied Users"], "day", 3.week.ago..Time.zone.now) end |
#application_distribution_data ⇒ Object
59 60 61 62 63 |
# File 'app/controllers/manage/dashboard_controller.rb', line 59 def application_distribution_data counts = Questionnaire.group(:acc_status).count results = Questionnaire::POSSIBLE_ACC_STATUS.map { |acc_status, status_title| [status_title, counts[acc_status] || 0] } render json: results end |
#checkin_activity_data ⇒ Object
33 34 35 |
# File 'app/controllers/manage/dashboard_controller.rb', line 33 def checkin_activity_data render json: activity_chart_data(["Checked In", "Boarded Bus"], "hour", 3.days.ago..Time.zone.now) end |
#confirmation_activity_data ⇒ Object
37 38 39 40 41 42 43 |
# File 'app/controllers/manage/dashboard_controller.rb', line 37 def confirmation_activity_data where_filter = nil if params[:school_id] where_filter = { school_id: params[:school_id] } end render json: activity_chart_data(["Confirmations", "Denials"], "day", 3.week.ago..Time.zone.now, where_filter) end |
#index ⇒ Object
5 6 |
# File 'app/controllers/manage/dashboard_controller.rb', line 5 def index end |
#map_data ⇒ Object
8 9 10 |
# File 'app/controllers/manage/dashboard_controller.rb', line 8 def map_data @schools = School.where("questionnaire_count", 1..Float::INFINITY).select([:city, :state, :questionnaire_count]) end |
#schools_applied_data ⇒ Object
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 |
# File 'app/controllers/manage/dashboard_controller.rb', line 80 def schools_applied_data counted_schools = { "pending" => {}, "denied" => {}, "rsvp_denied" => {}, "late_waitlist" => {}, "waitlist" => {}, "accepted" => {}, "rsvp_confirmed" => {} } # Temporary fix # result = Questionnaire.joins(:school).group(:acc_status, "schools.name").where("schools.questionnaire_count >= 5").order("schools.questionnaire_count DESC").order("schools.name ASC").count query = Questionnaire.joins(:school).group(:acc_status, "schools.name", "schools.questionnaire_count").order("schools.questionnaire_count DESC") if School.where("questionnaire_count >= 5").count > 0 query = query.where("schools.questionnaire_count >= 5") end result = query.count result.each do |group, count| counted_schools[group[0]][group[1]] = count end render json: [ { name: "RSVP Confirmed", data: counted_schools["rsvp_confirmed"] }, { name: "Accepted", data: counted_schools["accepted"] }, { name: "Waitlisted", data: counted_schools["waitlist"] }, { name: "Late Waitlisted", data: counted_schools["late_waitlist"] }, { name: "RSVP Denied", data: counted_schools["rsvp_denied"] }, { name: "Denied", data: counted_schools["denied"] }, { name: "Pending", data: counted_schools["pending"] } ] end |
#schools_confirmed_data ⇒ Object
65 66 67 68 69 70 71 72 73 74 75 76 77 78 |
# File 'app/controllers/manage/dashboard_controller.rb', line 65 def schools_confirmed_data schools = Questionnaire.joins(:school).group('schools.name').where("acc_status = 'rsvp_confirmed'").order("schools.name ASC").count schools_riding = Questionnaire.joins(:school).group('schools.name').where("acc_status = 'rsvp_confirmed' AND bus_list_id").count schools = schools.map do |name, count| bus_count_row = schools_riding.select { |school_bus_name, _| school_bus_name == name } bus_count = bus_count_row ? bus_count_row[name] || 0 : 0 count_without_bus = count - bus_count [name, count_without_bus, bus_count] end render json: [ { name: "Not riding bus", data: schools.sort_by { |_, no_bus, bus| [bus, no_bus] }.reverse }, { name: "Riding bus", data: schools_riding } ] end |
#todays_activity_data ⇒ Object
12 13 14 15 16 17 18 19 20 21 |
# File 'app/controllers/manage/dashboard_controller.rb', line 12 def todays_activity_data where_filter = nil types = ["Applications", "Confirmations", "Denials"] if params[:school_id] where_filter = { school_id: params[:school_id] } else types << "Non-Applied Users" end render json: activity_chart_data(types, "hour", Time.zone.today.beginning_of_day..Time.zone.today.end_of_day, where_filter) end |
#todays_stats_data ⇒ Object
23 24 25 26 27 28 29 30 31 |
# File 'app/controllers/manage/dashboard_controller.rb', line 23 def todays_stats_data date_min = Time.zone.today.beginning_of_day render json: { "Applications" => Questionnaire.where("created_at >= :date_min", date_min: date_min).count, "Confirmations" => Questionnaire.where("acc_status = \"rsvp_confirmed\" AND acc_status_date >= :date_min", date_min: date_min).count, "Denials" => Questionnaire.where("acc_status = \"rsvp_denied\" AND acc_status_date >= :date_min", date_min: date_min).count, "Non-Applied Users" => User.without_questionnaire.where("users.created_at >= :date_min", date_min: date_min).count } end |
#user_distribution_data ⇒ Object
49 50 51 52 53 54 55 56 57 |
# File 'app/controllers/manage/dashboard_controller.rb', line 49 def user_distribution_data total_stats_data = {} total_count = Questionnaire.count rit_count = Questionnaire.where("school_id = \"2304\"").count total_stats_data["Non-Applied Users"] = User.without_questionnaire.count total_stats_data["Non-RIT Applications"] = total_count - rit_count total_stats_data["RIT Applications"] = rit_count render json: total_stats_data end |