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