def calc_trip():
trip = request.json["viaje"]
role = json.loads(request.json["role"])
tumsa = Tumsa(dbhost=env_cfg["dbhost"], dbuser=db_user, dbpass=db_pass, dbname=env_cfg["dbname"])
start_date = Utils.format_date(Utils.string_to_date(str(trip["start_date"]).split('.')[0], "%Y-%m-%dT%H:%M:%S"),"%Y-%m-%d")
calcs = tumsa.calc_trip(trip["route"], start_date, role)
return calcs
def create_trips():
m = MZone()
tumsa = Tumsa(dbhost=env_cfg["dbhost"], dbuser=db_user, dbpass=db_pass, dbname=env_cfg["dbname"])
token = request.json["token"]
m.set_token(token)
camiones = request.json["camiones"].split(',')
route = tumsa.get_ruta(request.json["ruta"])
roles = tumsa.get_roles(request.json["ruta"])
delay = int(request.json["delay"])
day = request.json["day"]
if len(roles) == len(camiones):
i = 0
for camion in camiones:
vehicle = m.get_vehicles(extra="description eq '" + camion + "'")
if len(vehicle) > 0:
viaje = {}
print(i)
print(roles[i])
viaje["priority"] = int(roles[i]["priority"])
calc = tumsa.calc_trip(route[0], day, roles[i])
viaje["vehicle"] = json.dumps(vehicle[0])
viaje["start_date"] = str(calc["start_date"])
viaje["end_date"] = str(calc["end_date"])
viaje["trip"] = {"trip": calc["trip"]}
viaje["rounds"] = roles[i]["rounds"]
viaje["start_point"] = calc["start_point"]
viaje["total_time"] = int(calc["total_time"])
viaje["end_point"] = calc["end_point"]
viaje["route"] = json.dumps(route[0])
viaje["comments"] = ""
viaje["delay"] = delay
tumsa.insert_viaje(viaje)
i = i + 1
return json.dumps({"status": "ok"})
else:
return json.dumps({"status": "error"})