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