def INFO_BOX_TPE_INIT():
row_data = read_excel("sells/data/TPE/info/total_rows_TPE.xlsx") # get the excel info
info_boxes = []
for data in row_data:
page = get_web_page(DETAIL_URL + data["url"], urlJumpIp)
info_boxes += get_info_box(page, data["post_id"])
showProgess(__file__)
save(info_boxes, "sells/data/TPE/info/info_box_TPE")
print(str(__file__) + " complete")
def HOUSE_BOX_TPE_INIT():
row_data = read_excel("lease/data/TPE/info/total_rows_TPE.xlsx") # get the excel info
house_boxes = []
for data in row_data:
page = get_web_page(DETAIL_URL + data["url"], urlJumpIp)
house_boxes += get_house_box(page, data["post_id"])
showProgess(__file__)
save(house_boxes, "lease/data/TPE/info/house_box_TPE")
print(str(__file__) + " complete")
def IMG_TPE_INIT():
row_data = read_excel(
"sells/data/TPE/info/total_rows_TPE.xlsx") # get the excel info
dir = "D:/Python/database/sells/images/TPE/"
if os.path.exists(dir): # 先刪除原本的images資料夾
shutil.rmtree(dir, ignore_errors=True)
for data in row_data:
page = get_web_page(DETAIL_URL + data["url"], urlJumpIp)
img_urls = get_images(page)
save(img_urls, data["post_id"], dir)
showProgess(__file__)
print(str(__file__) + " complete")
import googlemaps
import sys
sys.path.append("lib/")
from datetime import datetime
from myio import read_excel, save
def get_geoLoc(row_data):
geo_result = []
for data in row_data:
coordinate = gmaps.geocode(data["addr"])[0]["geometry"]["location"]
print(data["addr"] + ":", coordinate)
geo_result.append({"addr": data["addr"], "coordinate": coordinate})
return geo_result
if __name__ == "__main__":
gmaps = googlemaps.Client(key="AIzaSyDcixkMKgROY2tE_4VLPTioPtDOwbmzfcI")
# data for lease NTC
row_data = read_excel("lease/data/NTC/info/total_rows_NTC.xlsx")
geo_result = get_geoLoc(row_data)
save(geo_result, "lease/data/TPE/geo/coordinate/loc_NTC")
# data for sells NTC
row_data = read_excel("sells/data/NTC/info/total_rows_NTC.xlsx")
geo_result = get_geoLoc(row_data)
save(geo_result, "sells/data/TPE/geo/coordinate/loc_NTC")
def parseSave(totDist, totElev, floorVertex, floorNext, floorRouteCoord,
floorRouteRot):
floorNumber = len(totDist) # len(totDist) gets floor counts
# parse and save each floor as a file for dist and next
"""for i in range(0, floorNumber):
fileDist = "C:/Users/A02wxy/Documents/GitHub/WayFinder/Direction/Route/dist/sf" + str(i + 1) + "f_dist"
dist = [] # for saving dist to each floor from floor[i]
# parsing the dist data
for j in range(0, floorNumber):
for k in range(0, len(totDist[i][j])):
for l in range(0, len(totDist[i][j][k])):
dist.append({
"floor": str(j),
"start": str(k),
"dest": str(l),
"dist": totDist[i][j][k][l],
"Elevator": totElev[i][j][k][l]
})
save(dist, fileDist) # saving using myio function
# parsing the next(middle points) data and save
for i in range(0, floorNumber):
fileNext = "C:/Users/A02wxy/Documents/GitHub/WayFinder/Direction/Route/next/sf" + str(i + 1) + "f_next"
middle = [] # for saving middle points between the route only on floor[i]
for j in range(0, len(floorNext[i])):
for k in range(0, len(floorNext[i][j])):
middle.append({
"start": str(j),
"dest": str(k),
"next": floorNext[i][j][k],
"coordinate": floorRouteCoord[i][j][k],
"rotation": floorRouteRot[i][j][k]
})
save(middle, fileNext) # saving using myio function
#store each floor's vertexes
for i in range(0, floorNumber):
fileName = "C:/Users/A02wxy/Documents/GitHub/WayFinder/Direction/Route/vertex/sf" + str(i + 1) + "f_vertex"
vertexes = []
for vertex in floorVertex[i]:
vertexes.append({
"ID": vertex.getID(),
"_index_": vertex.getIndex(),
"inct": vertex.getInct(),
"coordinate": vertex.getCoordinate(),
"rotation": vertex.getRotation()
})
save(vertexes, fileName)"""
# store each floor's poster
for i in range(0, floorNumber):
fileName = "C:/Users/A02wxy/Documents/GitHub/WayFinder/Direction/Route/poster/sf" + str(
i + 1) + "f_poster"
posters = []
for poster in floorPoster[i]:
posters.append({
"ID": poster.getID(),
"coordinate": poster.getCoordinate(),
"vertex_id": poster.getVertexID(),
"rotation": poster.getRotation()
})
save(posters, fileName)
