"인문지식 처리와 프로그래밍2020 6.04"의 두 판 사이의 차이

soook
이동: 둘러보기, 검색
(새 문서: =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...)
 
1번째 줄: 1번째 줄:
−
=tourSpace01=
+
=tourSpace01+templateTbl.htm=
 +
==tourSpace01==
 
<pre>
 
<pre>
 
#!/usr/bin/python
 
#!/usr/bin/python
111번째 줄: 112번째 줄:
  
  
−
=tourSpace02_1.py=  
+
==templateTbl.htm==
 +
<pre>
 +
<!--Template for displying search results, Center for DH at AKS-->
 +
 
 +
<html>
 +
<head>
 +
<title>Retrieved Data Set</title>
 +
<meta charset="UTF-8"/>
 +
<style>
 +
table {
 +
border:1px solid #444444;
 +
text-align:left;
 +
width:100%;
 +
color:#202020;
 +
font-size:15px;
 +
font-family:함초롬바탕;
 +
}
 +
table th {
 +
background-color:Olive;
 +
color:White;
 +
}
 +
table tr:nth-child(odd) td{
 +
background:#ffffff;
 +
}
 +
table tr:nth-child(even) td{
 +
background:#dfdfdf; 
 +
}
 +
td {
 +
padding: 5px 10px 5px 10px;
 +
}
 +
</style>
 +
</head>
 +
<body>
 +
<table>
 +
#YourData
 +
</table>
 +
</body>
 +
</html>
 +
 
 +
 
 +
</pre>
 +
=tourSpace02.py+templateNmap.htm=
 +
===tourSpace02_1.py==
 
<pre>
 
<pre>
 
#!/usr/bin/python
 
#!/usr/bin/python
269번째 줄: 312번째 줄:
  
  
−
=tourSpace02_2.py=  
+
==tourSpace02_2.py==  
 
<pre>
 
<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"
 +
 +
maxPOIs = 255
 +
 +
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)#위도 경도정보주면서 마커생김 맵마커만들어줘 마커1...100까지 생김
 +
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 > maxPOIs:
 +
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 > maxPOIs:
 +
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>
 
</pre>
  
  
−
=templateNmap.htm=  
+
==templateNmap.htm==  
 
<pre>
 
<pre>
 
<!DOCTYPE html>  
 
<!DOCTYPE html>  

2020년 6월 4일 (목) 21:28 판

tourSpace01+templateTbl.htm

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"
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()


templateTbl.htm

<!--Template for displying search results, Center for DH at AKS-->

<html>
<head>
	<title>Retrieved Data Set</title>
	<meta charset="UTF-8"/>
	<style>
		table {
			border:1px solid #444444;
			text-align:left;
			width:100%;
			color:#202020; 				
			font-size:15px;
			font-family:함초롬바탕;
		}
		table th {
			background-color:Olive;
			color:White;
		}		
		table tr:nth-child(odd) td{
			background:#ffffff; 					
		}
		table tr:nth-child(even) td{
			background:#dfdfdf;  			
		}
		td {
			padding: 5px 10px 5px 10px;
		}
	</style>
</head>
<body>
	<table>
#YourData
	</table>
</body>
</html>

tourSpace02.py+templateNmap.htm

=tourSpace02_1.py

#!/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()


tourSpace02_2.py

#!/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"

maxPOIs = 255

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)#위도 경도정보주면서 마커생김 맵마커만들어줘 마커1...100까지 생김
		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 > maxPOIs:
			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 > maxPOIs:
			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()


templateNmap.htm

<!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>
원본 주소 "http://dh.aks.ac.kr/~soook/wiki/index.php?title=인문지식_처리와_프로그래밍2020_6.04&oldid=836"