X-Git-Url: https://git.openstreetmap.org./rails.git/blobdiff_plain/d7c17fb0b5c1136e2e2cc89a1ed2f5390c872f84..cae83903d0db904506c17b70763ba320a552709d:/app/controllers/swf_controller.rb diff --git a/app/controllers/swf_controller.rb b/app/controllers/swf_controller.rb index a93abc8dd..96237f029 100644 --- a/app/controllers/swf_controller.rb +++ b/app/controllers/swf_controller.rb @@ -1,242 +1,216 @@ class SwfController < ApplicationController + skip_before_action :verify_authenticity_token + before_action :check_api_readable -# to log: -# RAILS_DEFAULT_LOGGER.error("Args: #{args[0]}, #{args[1]}, #{args[2]}, #{args[3]}") -# $log.puts Time.new.to_s+','+Time.new.usec.to_s+": started GPS script" -# http://localhost:3000/api/0.4/swf/trackpoints?xmin=-2.32402605810577&xmax=-2.18386309423859&ymin=52.1546608755772&ymax=52.2272777906895&baselong=-2.25325793066437&basey=61.3948537948532&masterscale=5825.4222222222 - - # ==================================================================== - # Public methods - - # ---- trackpoints compile SWF of trackpoints - - def trackpoints - - # - Initialise - - baselong =params['baselong'].to_f - basey =params['basey'].to_f - masterscale =params['masterscale'].to_f - - xmin=params['xmin'].to_f; xminr=xmin/0.000001 - xmax=params['xmax'].to_f; xmaxr=xmax/0.000001 - ymin=params['ymin'].to_f; yminr=ymin/0.000001 - ymax=params['ymax'].to_f; ymaxr=ymax/0.000001 - - # - Begin movie - - bounds_left =0 - bounds_right =320*20 - bounds_bottom=0 - bounds_top =240*20 - - m ='' - m+=swfRecord(9,255.chr + 155.chr + 155.chr) #ÊBackground - absx=0 - absy=0 - xl=yb= 9999999 - xr=yt=-9999999 - - # - Send SQL for GPS tracks - - b='' - lasttime=0 - lastfile='-1' - - if params['token'] - token=sqlescape(params['token']) - sql="SELECT gps_points.latitude*0.000001 AS lat,gps_points.longitude*0.000001 AS lon,gpx_files.id AS fileid,UNIX_TIMESTAMP(gps_points.timestamp) AS ts "+ - " FROM gpx_files,gps_points,users "+ - "WHERE gpx_files.id=gpx_id "+ - " AND gpx_files.user_id=users.id "+ - " AND token='#{token}' "+ - " AND (gps_points.longitude BETWEEN #{xminr} AND #{xmaxr}) "+ - " AND (gps_points.latitude BETWEEN #{yminr} AND #{ymaxr}) "+ - " AND (gps_points.timestamp IS NOT NULL) "+ - "ORDER BY fileid DESC,ts "+ - "LIMIT 10000" - else - sql="SELECT latitude*0.000001 AS lat,longitude*0.000001 AS lon,gpx_id AS fileid,UNIX_TIMESTAMP(timestamp) AS ts "+ - " FROM gps_points "+ - "WHERE (longitude BETWEEN #{xminr} AND #{xmaxr}) "+ - " AND (latitude BETWEEN #{yminr} AND #{ymaxr}) "+ - " AND (gps_points.timestamp IS NOT NULL) "+ - "ORDER BY fileid DESC,ts "+ - "LIMIT 10000" - end - gpslist=ActiveRecord::Base.connection.select_all sql - - # - Draw GPS trace lines - - r=startShape() - gpslist.each do |row| - xs=(long2coord(row['lon'].to_f,baselong,masterscale)*20).floor - ys=(lat2coord(row['lat'].to_f ,basey ,masterscale)*20).floor - xl=[xs,xl].min; xr=[xs,xr].max - yb=[ys,yb].min; yt=[ys,yt].max - if (row['ts'].to_i-lasttime<180 and row['fileid']==lastfile) - b+=drawTo(absx,absy,xs,ys) - else - b+=startAndMove(xs,ys,'01') - end - absx=xs.floor; absy=ys.floor - lasttime=row['ts'].to_i - lastfile=row['fileid'] - while b.length>80 do - r+=[b.slice!(0...80)].pack("B*") - end - end - - # - Draw unwayed segments - - if params['unwayed']=='true' - sql="SELECT cn1.latitude AS lat1,cn1.longitude AS lon1,"+ - " cn2.latitude AS lat2,cn2.longitude AS lon2 "+ - " FROM current_segments "+ - " LEFT OUTER JOIN current_way_segments"+ - " ON segment_id=current_segments.id,"+ - " current_nodes AS cn1,current_nodes AS cn2"+ - " WHERE (cn1.longitude BETWEEN #{xmin} AND #{xmax})"+ - " AND (cn1.latitude BETWEEN #{ymin} AND #{ymax})"+ - " AND segment_id IS NULL"+ - " AND current_segments.visible=1"+ - " AND cn1.id=node_a AND cn1.visible=1"+ - " AND cn2.id=node_b AND cn2.visible=1" - seglist=ActiveRecord::Base.connection.select_all sql - - seglist.each do |row| - xs1=(long2coord(row['lon1'].to_f,baselong,masterscale)*20).floor; ys1=(lat2coord(row['lat1'].to_f,basey,masterscale)*20).floor - xs2=(long2coord(row['lon2'].to_f,baselong,masterscale)*20).floor; ys2=(lat2coord(row['lat2'].to_f,basey,masterscale)*20).floor - if (xs1==absx and ys1==absy) - b+=drawTo(absx,absy,xs2,ys2) - absx=xs2; absy=ys2 - elsif (xs2==absx and ys2==absy) - b+=drawTo(absx,absy,xs1,ys1) - absx=xs1; absy=ys1 - else - b+=startAndMove(xs1,ys1,'10') - b+=drawTo(xs1,ys1,xs2,ys2) - absx=xs2; absy=ys2 - end - while b.length>80 do - r+=[b.slice!(0...80)].pack("B*") - end - end - end - - # - Write shape - - b+=endShape() - r+=[b].pack("B*") - m+=swfRecord(2,packUI16(1) + packRect(xl,xr,yb,yt) + r) - m+=swfRecord(4,packUI16(1) + packUI16(1)) - - # - Create Flash header and write to browser - - m+=swfRecord(1,'') # Show frame - m+=swfRecord(0,'') # End - - m=packRect(bounds_left,bounds_right,bounds_bottom,bounds_top) + 0.chr + 12.chr + packUI16(1) + m - m='FWS' + 6.chr + packUI32(m.length+8) + m - - response.headers["Content-Type"]="application/x-shockwave-flash" - render :text=>m - end - - private - - # ======================================================================= - # SWF functions - - # ----------------------------------------------------------------------- - # Line-drawing - - def startShape - s =0.chr # No fill styles - s+=2.chr # Two line styles - s+=packUI16(5) + 0.chr + 255.chr + 255.chr # Width 5, RGB #00FFFF - s+=packUI16(5) + 255.chr + 0.chr + 255.chr # Width 5, RGB #FF00FF - s+=34.chr # 2 fill, 2 line index bits - s - end - - def endShape - '000000' - end - - def startAndMove(x,y,col) - d='001001' # Line style change, moveTo - l =[lengthSB(x),lengthSB(y)].max - d+=sprintf("%05b%0#{l}b%0#{l}b",l,x,y) - d+=col # Select line style - end - - def drawTo(absx,absy,x,y) - d='11' # TypeFlag, EdgeFlag - dx=x-absx - dy=y-absy - - l =[lengthSB(dx),lengthSB(dy)].max - d+=sprintf("%04b",l-2) - d+='1' # GeneralLine - d+=sprintf("%0#{l}b%0#{l}b",dx,dy) - end - - # ----------------------------------------------------------------------- - # Specific data types - - def swfRecord(id,r) - if r.length>62 - return packUI16((id<<6)+0x3F) + packUI32(r.length) + r - else - return packUI16((id<<6)+r.length) + r - end - end - - def packRect(a,b,c,d) - l=[lengthSB(a), - lengthSB(b), - lengthSB(c), - lengthSB(d)].max - n=sprintf("%05b%0#{l}b%0#{l}b%0#{l}b%0#{l}b",l,a,b,c,d) - [n].pack("B*") - end - - # ----------------------------------------------------------------------- - # Generic pack functions - - def packUI16(n) - [n.floor].pack("v") - end - - def packUI32(n) - [n.floor].pack("V") - end - - # Find number of bits required to store arbitrary-length binary - - def lengthSB(n) - Math.frexp(n+ (n==0?1:0) )[1]+1 - end - - # ==================================================================== - # Co-ordinate conversion - # (this is duplicated from amf_controller, should probably share) - - def lat2coord(a,basey,masterscale) - -(lat2y(a)-basey)*masterscale+250 - end - - def long2coord(a,baselong,masterscale) - (a-baselong)*masterscale+350 - end - - def lat2y(a) - 180/Math::PI * Math.log(Math.tan(Math::PI/4+a*(Math::PI/180)/2)) - end - - def sqlescape(a) - a.gsub("'","''").gsub(92.chr,92.chr+92.chr) - end + # to log: + # RAILS_DEFAULT_LOGGER.error("Args: #{args[0]}, #{args[1]}, #{args[2]}, #{args[3]}") + # $log.puts Time.new.to_s+','+Time.new.usec.to_s+": started GPS script" + # http://localhost:3000/api/0.4/swf/trackpoints?xmin=-2.32402605810577&xmax=-2.18386309423859&ymin=52.1546608755772&ymax=52.2272777906895&baselong=-2.25325793066437&basey=61.3948537948532&masterscale=5825.4222222222 + # ==================================================================== + # Public methods + + # ---- trackpoints compile SWF of trackpoints + + def trackpoints + # - Initialise + + baselong = params["baselong"].to_f + basey = params["basey"].to_f + masterscale = params["masterscale"].to_f + + bbox = BoundingBox.new(params["xmin"], params["ymin"], + params["xmax"], params["ymax"]) + start = params["start"].to_i + + # - Begin movie + + bounds_left = 0 + bounds_right = 320 * 20 + bounds_bottom = 0 + bounds_top = 240 * 20 + + m = "" + m += swf_record(9, 255.chr + 155.chr + 155.chr) # Background + absx = 0 + absy = 0 + xl = yb = 9999999 + xr = yt = -9999999 + + # - Send SQL for GPS tracks + + b = "" + lasttime = 0 + lasttrack = lastfile = "-1" + + if params["token"] + user = User.authenticate(:token => params[:token]) + sql = "SELECT gps_points.latitude*0.0000001 AS lat,gps_points.longitude*0.0000001 AS lon,gpx_files.id AS fileid," + " EXTRACT(EPOCH FROM gps_points.timestamp) AS ts, gps_points.trackid AS trackid " + " FROM gpx_files,gps_points " + "WHERE gpx_files.id=gpx_id " + " AND gpx_files.user_id=#{user.id} " + " AND " + OSM.sql_for_area(bbox, "gps_points.") + " AND (gps_points.timestamp IS NOT NULL) " + "ORDER BY fileid DESC,ts " + "LIMIT 10000 OFFSET #{start}" + else + sql = "SELECT latitude*0.0000001 AS lat,longitude*0.0000001 AS lon,gpx_id AS fileid," + " EXTRACT(EPOCH FROM timestamp) AS ts, gps_points.trackid AS trackid " + " FROM gps_points " + "WHERE " + OSM.sql_for_area(bbox, "gps_points.") + " AND (gps_points.timestamp IS NOT NULL) " + "ORDER BY fileid DESC,ts " + "LIMIT 10000 OFFSET #{start}" + end + gpslist = ActiveRecord::Base.connection.select_all sql + + # - Draw GPS trace lines + + r = start_shape + gpslist.each do |row| + xs = (long2coord(row["lon"].to_f, baselong, masterscale) * 20).floor + ys = (lat2coord(row["lat"].to_f, basey, masterscale) * 20).floor + xl = [xs, xl].min + xr = [xs, xr].max + yb = [ys, yb].min + yt = [ys, yt].max + if row["ts"].to_i - lasttime > 180 || row["fileid"] != lastfile || row["trackid"] != lasttrack # or row['ts'].to_i==lasttime + b += start_and_move(xs, ys, "01") + absx = xs.floor + absy = ys.floor + end + b += draw_to(absx, absy, xs, ys) + absx = xs.floor + absy = ys.floor + lasttime = row["ts"].to_i + lastfile = row["fileid"] + lasttrack = row["trackid"] + r += [b.slice!(0...80)].pack("B*") while b.length > 80 + end + + # (Unwayed segments removed) + + # - Write shape + + b += end_shape + r += [b].pack("B*") + m += swf_record(2, pack_u16(1) + pack_rect(xl, xr, yb, yt) + r) + m += swf_record(4, pack_u16(1) + pack_u16(1)) + + # - Create Flash header and write to browser + + m += swf_record(1, "") # Show frame + m += swf_record(0, "") # End + + m = pack_rect(bounds_left, bounds_right, bounds_bottom, bounds_top) + 0.chr + 12.chr + pack_u16(1) + m + m = "FWS" + 6.chr + pack_u32(m.length + 8) + m + + render :body => m, :content_type => "application/x-shockwave-flash" + end + + private + + # ======================================================================= + # SWF functions + + # ----------------------------------------------------------------------- + # Line-drawing + + def start_shape + s = 0.chr # No fill styles + s += 2.chr # Two line styles + s += pack_u16(0) + 0.chr + 255.chr + 255.chr # Width 5, RGB #00FFFF + s += pack_u16(0) + 255.chr + 0.chr + 255.chr # Width 5, RGB #FF00FF + s += 34.chr # 2 fill, 2 line index bits + s + end + + def end_shape + "000000" + end + + def start_and_move(x, y, col) + d = "001001" # Line style change, moveTo + l = [length_sb(x), length_sb(y)].max + d += format("%05b%0*b%0*b", l, l, x, l, y) + d += col # Select line style + d + end + + def draw_to(absx, absy, x, y) + dx = x - absx + dy = y - absy + + # Split the line up if there's anything>16383, because + # that would overflow the 4 bits allowed for length + mstep = [dx.abs / 16383, dy.abs / 16383, 1].max.ceil + xstep = dx / mstep + ystep = dy / mstep + d = "" + 1.upto(mstep).each do + d += draw_section(x, y, x + xstep, y + ystep) + x += xstep + y += ystep + end + d + end + + def draw_section(x1, y1, x2, y2) + d = "11" # TypeFlag, EdgeFlag + dx = x2 - x1 + dy = y2 - y1 + l = [length_sb(dx), length_sb(dy)].max + d += format("%04b", l - 2) + d += "1" # GeneralLine + d += format("%0*b%0*b", l, dx, l, dy) + d + end + + # ----------------------------------------------------------------------- + # Specific data types + + # SWF data block type + + def swf_record(id, r) + if r.length > 62 + # Long header: tag id, 0x3F, length + pack_u16((id << 6) + 0x3F) + pack_u32(r.length) + r + else + # Short header: tag id, length + pack_u16((id << 6) + r.length) + r + end + end + + # SWF RECT type + + def pack_rect(a, b, c, d) + l = [length_sb(a), + length_sb(b), + length_sb(c), + length_sb(d)].max + # create binary string (00111001 etc.) - 5-byte length, then bbox + n = format("%05b%0*b%0*b%0*b%0*b", l, l, a, l, b, l, c, l, d) + # pack into byte string + [n].pack("B*") + end + + # ----------------------------------------------------------------------- + # Generic pack functions + + def pack_u16(n) + [n.floor].pack("v") + end + + def pack_u32(n) + [n.floor].pack("V") + end + + # Find number of bits required to store arbitrary-length binary + + def length_sb(n) + Math.frexp(n + (n.zero? ? 1 : 0))[1] + 1 + end + + # ==================================================================== + # Co-ordinate conversion + # (this is duplicated from amf_controller, should probably share) + + def lat2coord(a, basey, masterscale) + -(lat2y(a) - basey) * masterscale + end + + def long2coord(a, baselong, masterscale) + (a - baselong) * masterscale + end + + def lat2y(a) + 180 / Math::PI * Math.log(Math.tan(Math::PI / 4 + a * (Math::PI / 180) / 2)) + end end