vegantech/sims

class Intervention
  def date_user_student_school_grade
    arr=[created_at.to_date, user.to_s]
    if student.present?
      arr += [student.to_s]
      if student.enrollments.present?
        arr += [student.enrollments.first.grade, student.enrollments.first.school.to_s]
      else
        arr += [nil,nil]
      end
    else
      arr +=["No longer in sims",nil, nil]
    end
    arr
  end
end

class StudentComment
  def date_user_student_school_grade
    arr=[created_at.to_date, user.to_s]
    if student.present?
      arr |= [student.to_s, student.enrollments.first.grade, student.enrollments.first.school.to_s]
    else
      arr |=["No longer in sims",nil, nil]
    end

    arr

  end
end






dis = District.find_by_abbrev 'madison'
FasterCSV.open("/home/shawn/mmsd_intervention_summarization.csv", "w") do |csv|
 csv << ["created_on","user","student","grade","school"]
Intervention.find(:all,:include => [:user, {:student=>{:enrollments =>:school}}], :conditions => "users.district_id = #{dis.id}").each do |int|
csv << int.date_user_student_school_grade
end
nil
end


FasterCSV.open("/home/shawn/mmsd_team_note_summarization.csv", "w") do |csv|
 csv << ["created_on","user","student","grade","school"]
StudentComment.find(:all,:include => [:user, {:student=>{:enrollments =>:school}}], :conditions => "users.district_id = #{dis.id}").each do |int|
csv << int.date_user_student_school_grade
end
nil
end