Mercurial > hgrepos > hgweb.cgi > skipweb

annotate fujix/check.rb @ 2395:2cf2d4e4604e

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
leaf.rb button add
author FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
date Fri, 28 Nov 2014 18:30:55 +0900
parents
children
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
2395
2cf2d4e4604e leaf.rb button add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
1 #!/usr/bin/env ruby
2cf2d4e4604e leaf.rb button add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
2 #coding:utf-8
2cf2d4e4604e leaf.rb button add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
3
2cf2d4e4604e leaf.rb button add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
4 print"Content-type: text/html charset=UTF-8\n\n"
2cf2d4e4604e leaf.rb button add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
5
2cf2d4e4604e leaf.rb button add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
6 require'sqlite3'
2cf2d4e4604e leaf.rb button add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
7 require'cgi'
2cf2d4e4604e leaf.rb button add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
8 c = CGI.new(:accept_charaset => "UTF-8")
2cf2d4e4604e leaf.rb button add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
9 db = SQLite3::Database.new("sql/test.sq3")
2cf2d4e4604e leaf.rb button add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
10 db.results_as_hash = true
2cf2d4e4604e leaf.rb button add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
11
2cf2d4e4604e leaf.rb button add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
12 data = Hash.new
2cf2d4e4604e leaf.rb button add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
13
2cf2d4e4604e leaf.rb button add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
14 begin
2cf2d4e4604e leaf.rb button add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
15 db.execute("select * from main");
2cf2d4e4604e leaf.rb button add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
16 rescue
2cf2d4e4604e leaf.rb button add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
17 db.execute("create table main(id INTEGER PRIMARY KEY AUTOINCREMENT,name,lon,lat)");
2cf2d4e4604e leaf.rb button add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
18 db.execute("insert into main(name,lon,lat) values('#{name}','#{lon}','#{lat}')");
2cf2d4e4604e leaf.rb button add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
19 end
2cf2d4e4604e leaf.rb button add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
20
2cf2d4e4604e leaf.rb button add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
21 db.execute("select * from main") do |load|
2cf2d4e4604e leaf.rb button add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
22 data[load['id']] = [load['name'],load['lon'],load['lat'],load['sta']]
2cf2d4e4604e leaf.rb button add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
23 end
2cf2d4e4604e leaf.rb button add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
24
2cf2d4e4604e leaf.rb button add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
25 lon = 38.89420
2cf2d4e4604e leaf.rb button add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
26 lat = 139.8187
2cf2d4e4604e leaf.rb button add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
27 redirect = "check.rb"
2cf2d4e4604e leaf.rb button add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
28 image = ["","face","angry","sad"]
2cf2d4e4604e leaf.rb button add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
29
2cf2d4e4604e leaf.rb button add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
30 if ARGV[1] != nil
2cf2d4e4604e leaf.rb button add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
31 lon = ARGV[0].to_f
2cf2d4e4604e leaf.rb button add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
32 lat = ARGV[1].to_f
2cf2d4e4604e leaf.rb button add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
33 redirect += "?" + lon.to_s + "+" + lat.to_s
2cf2d4e4604e leaf.rb button add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
34 end
2cf2d4e4604e leaf.rb button add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
35
2cf2d4e4604e leaf.rb button add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
36 printf(<<_EOS_,redirect,lon.to_f,lat.to_f)
2cf2d4e4604e leaf.rb button add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
37 <!DOCTYPE html>
2cf2d4e4604e leaf.rb button add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
38 <html>
2cf2d4e4604e leaf.rb button add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
39 <head>
2cf2d4e4604e leaf.rb button add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
40 <link rel="stylesheet" type="text/css" href="leaflet/leaflet.css"/>
2cf2d4e4604e leaf.rb button add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
41 <script src="leaflet/leaflet.js"></script>
2cf2d4e4604e leaf.rb button add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
42 <style>
2cf2d4e4604e leaf.rb button add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
43 html,body,#map{
2cf2d4e4604e leaf.rb button add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
44 height: 100%
2cf2d4e4604e leaf.rb button add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
45 }
2cf2d4e4604e leaf.rb button add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
46 body{
2cf2d4e4604e leaf.rb button add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
47 padding: 0;
2cf2d4e4604e leaf.rb button add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
48 margin: 0;
2cf2d4e4604e leaf.rb button add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
49 }
2cf2d4e4604e leaf.rb button add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
50 </style>
2cf2d4e4604e leaf.rb button add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
51 <title>閲覧用ページ</title>
2cf2d4e4604e leaf.rb button add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
52 <!-- <meta http-equiv="refresh" content="20;%s"> -->
2cf2d4e4604e leaf.rb button add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
53 </head>
2cf2d4e4604e leaf.rb button add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
54 <body>
2cf2d4e4604e leaf.rb button add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
55 <div id="map"></div>
2cf2d4e4604e leaf.rb button add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
56 <script type="text/javascript">
2cf2d4e4604e leaf.rb button add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
57 var hmap = L.map('map',{
2cf2d4e4604e leaf.rb button add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
58 center: [%f,%f],
2cf2d4e4604e leaf.rb button add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
59 zoom: 16 //1~18
2cf2d4e4604e leaf.rb button add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
60 });
2cf2d4e4604e leaf.rb button add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
61 L.tileLayer('http://{s}.tile.openstreetmap.org/{z}/{x}/{y}.png',{
2cf2d4e4604e leaf.rb button add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
62 attribution: '&copy; OpenStreetMap contributors'
2cf2d4e4604e leaf.rb button add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
63 }).addTo(hmap);
2cf2d4e4604e leaf.rb button add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
64 _EOS_
2cf2d4e4604e leaf.rb button add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
65
2cf2d4e4604e leaf.rb button add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
66 for id in data.keys
2cf2d4e4604e leaf.rb button add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
67 if data[id][1] == "LON"
2cf2d4e4604e leaf.rb button add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
68 next
2cf2d4e4604e leaf.rb button add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
69 else
2cf2d4e4604e leaf.rb button add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
70 num = data[id][3]
2cf2d4e4604e leaf.rb button add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
71 printf(<<_EOS_,data[id][1].to_f,data[id][2].to_f,image[num],data[id][0])
2cf2d4e4604e leaf.rb button add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
72 L.marker([%f,%f],{
2cf2d4e4604e leaf.rb button add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
73 clickable:true,
2cf2d4e4604e leaf.rb button add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
74 draggable:true,
2cf2d4e4604e leaf.rb button add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
75 icon:L.icon({
2cf2d4e4604e leaf.rb button add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
76 iconUrl: 'leaflet/images/%s.png',
2cf2d4e4604e leaf.rb button add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
77 iconAnchor: [0,0],
2cf2d4e4604e leaf.rb button add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
78 popupAnchor: [10,5]
2cf2d4e4604e leaf.rb button add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
79 })
2cf2d4e4604e leaf.rb button add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
80 })
2cf2d4e4604e leaf.rb button add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
81 .bindPopup('%s')
2cf2d4e4604e leaf.rb button add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
82 .addTo(hmap);
2cf2d4e4604e leaf.rb button add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
83 _EOS_
2cf2d4e4604e leaf.rb button add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
84 end
2cf2d4e4604e leaf.rb button add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
85 end
2cf2d4e4604e leaf.rb button add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
86
2cf2d4e4604e leaf.rb button add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
87 print"
2cf2d4e4604e leaf.rb button add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
88 </script>
2cf2d4e4604e leaf.rb button add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
89 </body>
2cf2d4e4604e leaf.rb button add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
90 </html>\n"
2cf2d4e4604e leaf.rb button add
FUJIKAWA Kosuke <c111126@g.koeki-u.ac.jp>
parents:
diff changeset
91

yatex.org