Merge remote-tracking branch 'upstream/pull/2083'

[rails.git] / app / controllers / swf_controller.rb

diff --git a/app/controllers/swf_controller.rb b/app/controllers/swf_controller.rb
index 4e7e1c8ee85b601ce5fc5954f030eed14e984d2a..96237f029c3eaa075d2137eec7b47bb16142131f 100644 (file)
--- a/app/controllers/swf_controller.rb
+++ b/app/controllers/swf_controller.rb
@@ -1,243 +1,216 @@
 class SwfController < ApplicationController
 class SwfController < ApplicationController

-       session :off
-       before_filter :check_availability
-
-# 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
-       
-               render :text => m, :content_type => "application/x-shockwave-flash"
-       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
+  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
+
+    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
 end