Soook: /* Question */

2020-06-04T13:10:27Z

‎Question

Soook: /* Question */

2020-06-04T13:06:57Z

‎Question

2020년 6월 4일 (목) 13:05에 Soook님의 편집

2020-06-04T13:05:28Z

2020년 6월 4일 (목) 12:58에 Soook님의 편집

2020-06-04T12:58:49Z

2020년 6월 4일 (목) 12:58에 Soook님의 편집

2020-06-04T12:58:23Z

차이 보기

Soook: 새 문서: =tourSpace01=

 #!/usr/bin/python #-*- coding: utf-8 -*-  import sys import pyodbc import cgi import cgitb  noIconUrl = "http://dh.aks.ac.kr/VR/style/noicon60.png" referenceIconUr...

2020-06-04T12:51:41Z

새 문서: =tourSpace01= <pre> #!/usr/bin/python #-*- coding: utf-8 -*- import sys import pyodbc import cgi import cgitb noIconUrl = "http://dh.aks.ac.kr/VR/style/noicon60.png" referenceIconUr...

새 문서

=tourSpace01=
<pre>
#!/usr/bin/python
#-*- coding: utf-8 -*-

import sys
import pyodbc
import cgi
import cgitb

noIconUrl = "http://dh.aks.ac.kr/VR/style/noicon60.png"
referenceIconUrl = "http://dh.aks.ac.kr/VR/style/text60.png"
networkIconUrl = "http://dh.aks.ac.kr/VR/style/semantic.png"
vrIconUrl = "http://dh.aks.ac.kr/VR/style/vr.png"

def createCZML( poiList ):

for item in poiList:
id = item['id'] # id
label = item['label'] # name
latitude = item['latitude'] # position
longitude = item['longitude'] # position
altitude = item['altitude'] # position
infoUrl = item['infoUrl'] # description
iconUrl = item['iconUrl'] # description
semanticUrl = item['semanticUrl'] # description
vrUrl = item['vrUrl'] # description

descriptionText="<tr height='100px'><td><img width='120' src='{0}'/> <a href='{1}' target='_top'><img width='60' src='{2}'/></a> <a href='{3}' target='_top'><img width='60' src='{4}'/></a> <a href='{5}' target='_top'><img width='60' src='{6}'/></a></td><td>{7}</td></tr>".format( iconUrl, vrUrl, vrIconUrl, infoUrl, referenceIconUrl, semanticUrl, networkIconUrl, label )

print descriptionText

def displayData( database, project, condition ):

server = 'tcp:digerati.aks.ac.kr'
username = 'guest'
password = 'guest'

db = pyodbc.connect('DRIVER={ODBC Driver 17 for SQL Server};SERVER='+server+';DATABASE='+database+';UID='+username+';PWD='+ password)
cur = db.cursor()

geoTable = project +'Space'

comstring = "select id, complex, site, label, latitude, longitude, altitude, infoUrl, iconUrl, vrUrl, semanticUrl from " + geoTable
if condition <> "":
command = comstring + " where {0}".format( condition )
else:
command = comstring

# cur.execute(unicode(command, "utf-8"))

cur.execute( command )

poiList = []

for row in cur.fetchall():

try:
poiList.append( {'id':row[0],'complex':row[1],'site':row[2],'label':row[3],'latitude':row[4],'longitude':row[5],'altitude':row[6],'infoUrl':row[7], 'iconUrl':row[8], 'vrUrl':row[9], 'semanticUrl':row[10] } )
except:
return

cur.close()
db.close()

createCZML( poiList );

def displayResults(template, db, project, condition):

print("Content-type: text/html")
print
f = open(template)
while 1:
line = f.readline()
if not line: break
if( '#YourData' == line.strip()):
displayData( db, project, condition )
else:
print line

f.close()

def main():

reload(sys)
sys.setdefaultencoding('utf8')
cgitb.enable()

form = cgi.FieldStorage()

try:
db = form.getvalue('db', '')
project = form.getvalue('project', '')
key = form.getvalue('key', '')
except:
return

if key <> '' :
condition = "complex='" + key + "'"
else:
condition=''

displayResults("templateTbl.htm", db, project, condition )

main()
</pre>

=tourSpace02_1.py=
<pre>
#!/usr/bin/python
#-*- coding: utf-8 -*-

import sys
import pyodbc
import cgi
import cgitb

noIconUrl = "http://dh.aks.ac.kr/VR/style/photo.png"
referenceIconUrl = "http://dh.aks.ac.kr/VR/style/text60.png"
networkIconUrl = "http://dh.aks.ac.kr/VR/style/semantic.png"
vrIconUrl = "http://dh.aks.ac.kr/VR/style/vr.png"
maxPOI=250

def createMarker( poiList ):

counter = 0
for item in poiList:

latitude = item['latitude']
longitude = item['longitude']
label = item['label']
infoUrl = item['infoUrl']
semanticUrl = item['semanticUrl']
vrUrl = item['vrUrl']
iconUrl = item['iconUrl']

if( iconUrl<>None ):
contentStr = "{0}<br/><img src=\"{1}\" width=120/>".format( label, iconUrl )
else:
contentStr = "{0}<br/><img src=\"{1}\" width=120/>".format( label, noIconUrl )

if( vrUrl <> None):
pavilionStr = "<a href=\"{0}\"><img src=\"{1}\" width=60/></a>".format(vrUrl, vrIconUrl)
contentStr = contentStr + pavilionStr

if( infoUrl <> None ):
infoStr = "<a href=\"{0}\"><img src=\"{1}\" width=60/></a>".format(infoUrl, referenceIconUrl)
contentStr = contentStr + infoStr

if( semanticUrl <> None):
networkStr = "<a href=\"{0}\"><img src=\"{1}\" width=60/></a>".format(semanticUrl, networkIconUrl)
contentStr = contentStr + networkStr

print "var marker{0} = new naver.maps.Marker({{".format(counter)
print " position: new naver.maps.LatLng({0}, {1}),".format(latitude, longitude)
print " map: map"
print "});\n"

print "var htmtxt{:d} = [".format(counter)
print " '<div class=\"iw_inner\">',"
print " '{0}',".format(contentStr)
print " '</div>'"
print "].join('');\n"
counter = counter + 1
if counter > 100:
break;

def addListener( limit ):

counter = 0
while( counter < limit ):
print "naver.maps.Event.addListener(marker{:d}, 'click', function(e) {{".format(counter)
print " if (infowindow.getMap()) {"
print " infowindow.close();"
print " } else {"
print " infowindow.setContent(htmtxt{:d})".format(counter)
print " infowindow.open(map, marker{:d});".format(counter)
print " }"
print "});\n"
counter = counter + 1
if counter > 100:
break;

def displayData( database, project, condition ):

server = 'tcp:digerati.aks.ac.kr'
username = 'guest'
password = 'guest'

db = pyodbc.connect('DRIVER={ODBC Driver 17 for SQL Server};SERVER='+server+';DATABASE='+database+';UID='+username+';PWD='+ password)
cur = db.cursor()

geoTable = project + 'Space'

comstring = "select id, label, latitude, longitude, infoUrl, semanticUrl, vrUrl, iconUrl from " + geoTable
if condition <> "":
command = comstring + " where {0}".format( condition )
else:
command = comstring

cur.execute(unicode(command, "utf-8"))

poiList = []
counter = 0

for row in cur.fetchall():

try:
poiList.append( {'id':row[0],'label':row[1],'latitude':row[2],'longitude':row[3],'infoUrl':row[4], 'semanticUrl':row[5], 'vrUrl':row[6], 'iconUrl':row[7] } )
except:
return

counter = counter + 1;

cur.close()
db.close()

createMarker( poiList )
addListener( counter );

def displayResults(template, db, project, condition):

print("Content-type: text/html")
print
f = open(template)
while 1:
line = f.readline()
if not line: break
if( '#YourData' == line.strip()):
displayData( db, project, condition )
else:
print line

f.close()

def main():

reload(sys)
sys.setdefaultencoding('utf8')
cgitb.enable()

form = cgi.FieldStorage()

try:
db = form.getvalue('db', '')
project = form.getvalue('project', '')
key = form.getvalue('key', '')
except:
return

if key <> '' :
condition = "complex='" + key + "'"
else:
condition=''

displayResults("templateNmap.htm", db, project, condition )

main()

</pre>

=tourSpace02_2.py=
<pre>
</pre>

=templateNmap.htm=
<pre>
<!DOCTYPE html>
<html>
<head>
<title>Naver Map Api</title>
<meta charset="UTF-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0, minimum-scale=1.0, user-scalable=no">
<script type="text/javascript" src="https://openapi.map.naver.com/openapi/v3/maps.js?ncpClientId=tlmos9eset"></script>
<style>
div.iw_inner {
text-align: center;
font-family:함초롬바탕;
}
</style>
</head>
<body>
<div id="map" style="width:100%;height:720px;"></div>

<script>
var map = new naver.maps.Map('map', {
center: new naver.maps.LatLng(37, 127),
zoom: 7,
zoomControl: true
});

var contentString = [
'<div class="iw_inner">',
' <img src=\"/VR/style/photo.png\" width=\"120\"/>',
'</div>'
].join('');

var infowindow = new naver.maps.InfoWindow({
content: contentString,
maxWidth: 460,
backgroundColor: "White",
borderColor: "DarkCyan",
borderWidth: 1,
anchorSize: new naver.maps.Size(10, 10),
anchorSkew: true,
anchorColor: "White",
pixelOffset: new naver.maps.Point(10, -10)
});

#YourData

</script>
</body>
</html>
</pre>

@@ 526번째 줄: / 526번째 줄: @@
 <pre>
 * poiList : Point of interest
-* <div></div> : division
+* <div></div> : division  지도영역/info box부분 표시하는부분 스타일지정
 * fetchone & fetchall
 **fetchone은 하나씩가져오는것-가져올양이 얼만큼인지 불확실할때 한정양을 걸어놓고 & fetchall은 한정양을 알고 있을때 몽땅 부름.
 </pre>

@@ 524번째 줄: / 524번째 줄: @@
 =Question=
 * poiList : Point of interest
 * <div></div> : division
 * fetchone & fetchall
 **fetchone은 하나씩가져오는것-가져올양이 얼만큼인지 불확실할때 한정양을 걸어놓고 & fetchall은 한정양을 알고 있을때 몽땅 부름.

← 이전 판		2020년 6월 4일 (목) 13:05 판
521번째 줄:		521번째 줄:
	</html>		</html>
	</pre>		</pre>
		+
		+
		+	=Question=
		+	* poiList : Point of interest
		+	* <div></div> : division
		+	* fetchone & fetchall
		+	**fetchone은 하나씩가져오는것-가져올양이 얼만큼인지 불확실할때 한정양을 걸어놓고 & fetchall은 한정양을 알고 있을때 몽땅 부름.

@@ 154번째 줄: / 154번째 줄: @@
 </pre>
 =tourSpace02.py+templateNmap.htm=
-===tourSpace02_1.py==
+==tourSpace02_1.py==
 <pre>
 #!/usr/bin/python

인문지식 처리와 프로그래밍2020 6.04 - 편집 역사

Soook: /* Question */

Soook: /* Question */

2020년 6월 4일 (목) 13:05에 Soook님의 편집

2020년 6월 4일 (목) 12:58에 Soook님의 편집

2020년 6월 4일 (목) 12:58에 Soook님의 편집

Soook: 새 문서: =tourSpace01=
#!/usr/bin/python #-- coding: utf-8 -- import sys import pyodbc import cgi import cgitb noIconUrl = "http://dh.aks.ac.kr/VR/style/noicon60.png" referenceIconUr...