app/controllers/swf_controller.rb

   1 class SwfController < ApplicationController
   2         session :off
   3         before_filter :check_availability
   4
   5 # to log:
   6 # RAILS_DEFAULT_LOGGER.error("Args: #{args[0]}, #{args[1]}, #{args[2]}, #{args[3]}")
   7 # $log.puts Time.new.to_s+','+Time.new.usec.to_s+": started GPS script"
   8 # 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
   9
  10         # ====================================================================
  11         # Public methods
  12
  13         # ---- trackpoints      compile SWF of trackpoints
  14
  15         def trackpoints
  16
  17                 # -     Initialise
  18
  19                 baselong        =params['baselong'].to_f
  20                 basey           =params['basey'].to_f
  21                 masterscale     =params['masterscale'].to_f
  22
  23                 xmin=params['xmin'].to_f; xminr=xmin/0.000001
  24                 xmax=params['xmax'].to_f; xmaxr=xmax/0.000001
  25                 ymin=params['ymin'].to_f; yminr=ymin/0.000001
  26                 ymax=params['ymax'].to_f; ymaxr=ymax/0.000001
  27
  28                 # -     Begin movie
  29
  30                 bounds_left  =0
  31                 bounds_right =320*20
  32                 bounds_bottom=0
  33                 bounds_top   =240*20
  34
  35                 m =''
  36                 m+=swfRecord(9,255.chr + 155.chr + 155.chr)                     #ÊBackground
  37                 absx=0
  38                 absy=0
  39                 xl=yb= 9999999
  40                 xr=yt=-9999999
  41
  42                 # -     Send SQL for GPS tracks
  43
  44                 b=''
  45                 lasttime=0
  46                 lastfile='-1'
  47
  48                 if params['token']
  49                         token=sqlescape(params['token'])
  50                         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 "+
  51                                  " FROM gpx_files,gps_points,users "+
  52                                  "WHERE gpx_files.id=gpx_id "+
  53                                  "  AND gpx_files.user_id=users.id "+
  54                                  "  AND token='#{token}' "+
  55                                  "  AND (gps_points.longitude BETWEEN #{xminr} AND #{xmaxr}) "+
  56                                  "  AND (gps_points.latitude BETWEEN #{yminr} AND #{ymaxr}) "+
  57                                  "  AND (gps_points.timestamp IS NOT NULL) "+
  58                                  "ORDER BY fileid DESC,ts "+
  59                                  "LIMIT 10000"
  60                 else
  61                         sql="SELECT latitude*0.000001 AS lat,longitude*0.000001 AS lon,gpx_id AS fileid,UNIX_TIMESTAMP(timestamp) AS ts "+
  62                                  " FROM gps_points "+
  63                                  "WHERE (longitude BETWEEN #{xminr} AND #{xmaxr}) "+
  64                                  "  AND (latitude  BETWEEN #{yminr} AND #{ymaxr}) "+
  65                                  "  AND (gps_points.timestamp IS NOT NULL) "+
  66                                  "ORDER BY fileid DESC,ts "+
  67                                  "LIMIT 10000"
  68                 end
  69                 gpslist=ActiveRecord::Base.connection.select_all sql
  70
  71                 # - Draw GPS trace lines
  72
  73                 r=startShape()
  74                 gpslist.each do |row|
  75                         xs=(long2coord(row['lon'].to_f,baselong,masterscale)*20).floor
  76                         ys=(lat2coord(row['lat'].to_f ,basey   ,masterscale)*20).floor
  77                         xl=[xs,xl].min; xr=[xs,xr].max
  78                         yb=[ys,yb].min; yt=[ys,yt].max
  79                         if (row['ts'].to_i-lasttime<180 and row['fileid']==lastfile)
  80                                 b+=drawTo(absx,absy,xs,ys)
  81                         else
  82                                 b+=startAndMove(xs,ys,'01')
  83                         end
  84                         absx=xs.floor; absy=ys.floor
  85                         lasttime=row['ts'].to_i
  86                         lastfile=row['fileid']
  87                         while b.length>80 do
  88                                 r+=[b.slice!(0...80)].pack("B*")
  89                         end
  90                 end
  91
  92                 # - Draw unwayed segments
  93
  94                 if params['unwayed']=='true'
  95                         sql="SELECT cn1.latitude AS lat1,cn1.longitude AS lon1,"+
  96                                 "               cn2.latitude AS lat2,cn2.longitude AS lon2 "+
  97                                 "  FROM current_segments "+
  98                                 "       LEFT OUTER JOIN current_way_segments"+
  99                                 "       ON segment_id=current_segments.id,"+
 100                                 "       current_nodes AS cn1,current_nodes AS cn2"+
 101                                 " WHERE (cn1.longitude BETWEEN #{xmin} AND #{xmax})"+
 102                                 "   AND (cn1.latitude  BETWEEN #{ymin} AND #{ymax})"+
 103                                 "   AND segment_id IS NULL"+
 104                                 "   AND current_segments.visible=1"+
 105                                 "   AND cn1.id=node_a AND cn1.visible=1"+
 106                                 "   AND cn2.id=node_b AND cn2.visible=1"
 107                         seglist=ActiveRecord::Base.connection.select_all sql
 108
 109                         seglist.each do |row|
 110                                 xs1=(long2coord(row['lon1'].to_f,baselong,masterscale)*20).floor; ys1=(lat2coord(row['lat1'].to_f,basey,masterscale)*20).floor
 111                                 xs2=(long2coord(row['lon2'].to_f,baselong,masterscale)*20).floor; ys2=(lat2coord(row['lat2'].to_f,basey,masterscale)*20).floor
 112                                 if (xs1==absx and ys1==absy)
 113                                         b+=drawTo(absx,absy,xs2,ys2)
 114                                         absx=xs2; absy=ys2
 115                                 elsif (xs2==absx and ys2==absy)
 116                                         b+=drawTo(absx,absy,xs1,ys1)
 117                                         absx=xs1; absy=ys1
 118                                 else
 119                                         b+=startAndMove(xs1,ys1,'10')
 120                                         b+=drawTo(xs1,ys1,xs2,ys2)
 121                                         absx=xs2; absy=ys2
 122                                 end
 123                                 while b.length>80 do
 124                                         r+=[b.slice!(0...80)].pack("B*")
 125                                 end
 126                         end
 127                 end
 128
 129                 # - Write shape
 130
 131                 b+=endShape()
 132                 r+=[b].pack("B*")
 133                 m+=swfRecord(2,packUI16(1) + packRect(xl,xr,yb,yt) + r)
 134                 m+=swfRecord(4,packUI16(1) + packUI16(1))
 135
 136                 # -     Create Flash header and write to browser
 137
 138                 m+=swfRecord(1,'')                                                                      # Show frame
 139                 m+=swfRecord(0,'')                                                                      # End
 140
 141                 m=packRect(bounds_left,bounds_right,bounds_bottom,bounds_top) + 0.chr + 12.chr + packUI16(1) + m
 142                 m='FWS' + 6.chr + packUI32(m.length+8) + m
 143
 144                 render :text => m, :content_type => "application/x-shockwave-flash"
 145         end
 146
 147         private
 148
 149         # =======================================================================
 150         # SWF functions
 151
 152         # -----------------------------------------------------------------------
 153         # Line-drawing
 154
 155         def startShape
 156                 s =0.chr                                                                                # No fill styles
 157                 s+=2.chr                                                                                # Two line styles
 158                 s+=packUI16(5) + 0.chr + 255.chr + 255.chr              # Width 5, RGB #00FFFF
 159                 s+=packUI16(5) + 255.chr + 0.chr + 255.chr              # Width 5, RGB #FF00FF
 160                 s+=34.chr                                                                               # 2 fill, 2 line index bits
 161                 s
 162         end
 163
 164         def endShape
 165                 '000000'
 166         end
 167
 168         def startAndMove(x,y,col)
 169                 d='001001'                                                                              # Line style change, moveTo
 170                 l =[lengthSB(x),lengthSB(y)].max
 171                 d+=sprintf("%05b%0#{l}b%0#{l}b",l,x,y)
 172                 d+=col                                                                                  # Select line style
 173         end
 174
 175         def drawTo(absx,absy,x,y)
 176                 d='11'                                                                                  # TypeFlag, EdgeFlag
 177                 dx=x-absx
 178                 dy=y-absy
 179
 180                 l =[lengthSB(dx),lengthSB(dy)].max
 181                 d+=sprintf("%04b",l-2)
 182                 d+='1'                                                                                  # GeneralLine
 183                 d+=sprintf("%0#{l}b%0#{l}b",dx,dy)
 184         end
 185
 186         # -----------------------------------------------------------------------
 187         # Specific data types
 188
 189         def swfRecord(id,r)
 190                 if r.length>62
 191                         return packUI16((id<<6)+0x3F) + packUI32(r.length) + r
 192                 else
 193                         return packUI16((id<<6)+r.length) + r
 194                 end
 195         end
 196
 197         def packRect(a,b,c,d)
 198                 l=[lengthSB(a),
 199                    lengthSB(b),
 200                    lengthSB(c),
 201                    lengthSB(d)].max
 202                 n=sprintf("%05b%0#{l}b%0#{l}b%0#{l}b%0#{l}b",l,a,b,c,d)
 203                 [n].pack("B*")
 204         end
 205
 206         # -----------------------------------------------------------------------
 207         # Generic pack functions
 208
 209         def packUI16(n)
 210                 [n.floor].pack("v")
 211         end
 212
 213         def packUI32(n)
 214                 [n.floor].pack("V")
 215         end
 216
 217         # Find number of bits required to store arbitrary-length binary
 218
 219         def lengthSB(n)
 220                 Math.frexp(n+ (n==0?1:0) )[1]+1
 221         end
 222
 223         # ====================================================================
 224         # Co-ordinate conversion
 225         # (this is duplicated from amf_controller, should probably share)
 226
 227         def lat2coord(a,basey,masterscale)
 228                 -(lat2y(a)-basey)*masterscale+250
 229         end
 230
 231         def long2coord(a,baselong,masterscale)
 232                 (a-baselong)*masterscale+350
 233         end
 234
 235         def lat2y(a)
 236                 180/Math::PI * Math.log(Math.tan(Math::PI/4+a*(Math::PI/180)/2))
 237         end
 238
 239         def sqlescape(a)
 240                 a.gsub("'","''").gsub(92.chr,92.chr+92.chr)
 241         end
 242
 243 end