def chooseMechanic(x,y):
db.c.execute("SELECT * FROM monteurs")
monteurs = db.c.fetchall()
monteurs = decrypt(monteurs)
#selecteer alle monteurs
c=[0,0,0,0,0,0]
#maak de dichtsbijzijnde monteur
for i in monteurs:
#door alle monteurs loopen
if(datetime.now().hour+2 > float(i[6]) and datetime.now().hour+2 < float(i[7])):
#test of de monteur nu beschikbaar is
if((float(i[4])-x)**2+(float(i[5])-y)**2 < (float(c[4])-x)**2+(float(c[5])-y)**2):
#test of de monteur dichterbij is dan de huidige monteur
c=i
#maak die monteur de dichtsbijzijnde
return c
def getMLB():
c.execute('SELECT * FROM monteurs')
monteurs = c.fetchall()
monteurs = cry.decrypt(monteurs)
#alle postcodes van de monteurs hierin zetten
#monteurs = cry.decrypt(monteurs)
for i in monteurs:
#door alle postcodes loopen
url = 'https://maps.googleapis.com/maps/api/geocode/json?address=%s' %(str(i[2])[2:-1])
response = requests.get(url)
resp_json_payload = response.json()
#long and lat verkrijgen
mlb.append([resp_json_payload['results'][0]['geometry']['location']['lat'],resp_json_payload['results'][0]['geometry']['location']['lng']])
#long and let toevoegen aan MonteursLengteBreedte (mlb)
return mlb
def route_decrypt():
# artifical sleep to imitate real-world web server
time.sleep(random.random()/4 + .1)
# get cipher
cipher = request.values.get('cipher',None)
if not cipher:
return 'No cipher', 500
# handle binary data encoding
enc = request.values.get('enc',None)
try:
cipher = decode(cipher, enc)
plain = cry.decrypt(cipher, key)
return plain, 200
except Exception:
response = make_response(traceback.format_exc(),500)
response.headers["content-type"] = "text/plain"
return response
