<%
# report = {'name'=> 'Месторасположение супервайзеров', 'format'=>'html'}
@locations = []
records = ActiveRecord::Base.connection.execute("SELECT s.name, ST_X(coordinates::geometry) as longitude, ST_Y(coordinates::geometry) as latitude, l1.timestamp FROM supervisors s INNER JOIN users u ON s.id = u.supervisor_id INNER JOIN (SELECT MAX(id) as id, user_id FROM locations GROUP BY user_id) l ON l.user_id = u.id INNER JOIN locations l1 on l1.id = l.id ORDER BY s.name;")
records.each do |record|
location = {}
location[:name] = record['name']
location[:lat] = record['latitude']
location[:lng] = record['longitude']
location[:title] = record['timestamp']
location[:infowindow] = "#{t(:datetime)}: #{record['timestamp']}
#{t(:latitude)}: #{record['latitude']}
#{t(:longitude)}: #{record['longitude']}
#{t(:manager)}: #{record['name']}"
@locations << location
end
%>
<% content_for :javascripts do %>
<%= javascript_include_tag 'locations' %>
<%= javascript_include_tag 'markerclusterer.min' %>
<% end %>
<%= t(:supervisors_location_report)%>
<%= link_to t(:back), :back, class: 'btn btn-default' %>