出席集計くん

portal_attendance_count.rb

require 'csv'

meetings = %w[82 85 86 91 92 93 94 87 95 96 88 97 111 98]

attendances = {}
MeetingAttendance.where(meeting_id: meetings).map do |attend|
  if attendances[attend.user.nickname]
    attendances[attend.user.nickname][:count] += 1
  else
    attendances[attend.user.nickname] = {
      kg: GroupUser.where(user: attend.user).first.group.name,
      student_id: LdapCredential.find_by(uid: attend.user.nickname).try(:student_id),
      count: 1
    }
  end
end

attendances = attendances.map do |attendance|
  [attendance[1][:kg], attendance[0], attendance[1][:student_id], attendance[1][:count]]
end

CSV.open('/home/itochan/rg_attendance_2017f.csv', 'w') do |csv|
  attendances.sort.each do |attendance|
    csv << attendance
  end
end