Vegantech SIMS → August 1

District wanted additional data in export, which doesn't include team notes from users that left district. This is something I should look into (former users and how they are handled) but for now provided a one off zipfile with the content.

de = DistrictExport.new d

us = User.joins(:student_comments).where("username like '#{d.id}%'").select("users.id,district_user_id").uniq;nil de.generate_csv("users","id,district_user_id",us.to_sql)

sc = StudentComment.joins(:user).where("users.username like '#{d.id}%'")
de.generate_csv("student_comments", de.csv_cols(StudentComment),sc.to_sql)

assets = Asset.where(attachable_type: "StudentComment").where(attachable_id: sc.pluck(:id))
de.generate_csv('assets',Asset.column_names.join(","),assets.to_sql)

File.open("former_user_tnotes.list", "w") do |f|
f.puts assets.collect(&:document).compact.collect(&:path).compact.collect{|e| e.split("documents/").last}.join("\n")
end
f.puts

mv former_user_tnotes.list public/system/documents/

zip former_user_tnote_assets.zip -r -@ < former_user_tnotes.list