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