Open access report for ERA

open_access.rb

CSV.open('open_access.csv', 'wb') do |csv|
  csv << ['year', 'count', 'community', 'collection', 'collection url']
  open_access_items = Item.select(:member_of_paths, :created_at)
                          .where(visibility: JupiterCore::VISIBILITY_PUBLIC)
                          .group_by { |item| item.created_at.year }
  open_access_items.each do |year, items|
    items.map(&:member_of_paths).flatten.tally.each do |member_of_path, count|
      community_id, collection_id = member_of_path.split('/')
      csv << [year, count, Community.find(community_id).title, Collection.find(collection_id).title,
              Rails.application.routes.url_helpers.community_collection_url(community_id, collection_id)]
    end
  end
end