FMS Usage Report

gistfile1.txt

out = []
Facility.find_each do |facility|
  if facility.send(:belong_to_billable_company?) && facility.facility_map.geometric_objects.count > 10
    out << "#{facility.company.name}, #{facility.name} has #{facility.facility_map.geometric_objects.count} objects"
  end
end

facilities_receiving_texts = SMSReceivedEvent.pluck(:facility_id).uniq.length
facilities_sending_texts = SMSSentEvent.pluck(:facility_id).uniq.length
sms_received = SMSReceivedEvent.count
sms_sent = SMSSentEvent.count
ap "#{out.length} facilities are using maps"
ap "#{sms_received} SMS Sent by  #{facilities_receiving_texts} facilities"
ap "#{sms_sent} SMS Sent by  #{facilities_sending_texts} facilities"