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