Beispiel #1
0
def index_all():
    id = get_jwt_identity()

    favorites = Favorite.select().join(
        User,
        on=Favorite.user_id).switch(Favorite).where(Favorite.user_id == id)
    excluded_chefs = [c.chef_id for c in favorites]
    recipes = Recipe.select().where((Recipe.user_id != id)
                                    & Recipe.user_id.not_in(excluded_chefs))

    return jsonify({
        "status":
        "success",
        "recipe": [{
            "id": recipe.id,
            "id_owner": recipe.user.id,
            "id_user": str(id),
            "name": recipe.name,
            "photo": recipe.photo,
            "countrys": recipe.countrys,
            "hour": recipe.hour,
            "sec": recipe.sec,
            "directions": recipe.directions,
            "ingredients": recipe.ingredients,
            "time": recipe.time,
            "username": recipe.user.username,
            "user_id": recipe.user.id,
            "user_photo": recipe.user.photo
        } for recipe in recipes]
    }), 200
Beispiel #2
0
def index_number(user_id_param):

    favorites = Favorite.select().join(
        User, on=Favorite.user_id).switch(Favorite).where(
            Favorite.user_id == user_id_param)
    following = len([c.chef_id for c in favorites])

    favorites = Favorite.select().join(
        User, on=Favorite.user_id).switch(Favorite).where(
            Favorite.chef_id == user_id_param)
    followers = len([c.user_id for c in favorites])

    my_recipes = Recipe.select().where(Recipe.user_id == user_id_param)
    recipes = len([c.id for c in my_recipes])

    return jsonify({
        "status": "success",
        "number": {
            "following": following,
            "followers": followers,
            "recipes": recipes,
        }
    }), 200
Beispiel #3
0
def show_search():
    id = get_jwt_identity()
    favorites = Favorite.select().join(
        User,
        on=Favorite.user_id).switch(Favorite).where(Favorite.user_id == id)
    excluded_chefs = [c.chef_id for c in favorites]

    hour = request.args.get('hour')
    sec = request.args.get('sec')
    country = request.args.get('country')
    order = request.args.get('order')

    if order == "Time to prepare":
        ooo = Recipe.prep
    elif order == "":
        ooo = Recipe
    elif order == "Recently":
        ooo = Recipe.created_at.desc()

    prepTime = None
    if sec and hour:
        prepTime = int(hour) + (int(sec) / 100)
    elif sec:
        prepTime = (int(sec) / 100)
    elif hour:
        prepTime = int(hour)

    recipes = False
    if country and prepTime:
        recipes = Recipe.select().where(
            (Recipe.countrys == country) & (Recipe.user_id != id)
            & (Recipe.prep <= prepTime)
            & Recipe.user_id.not_in(excluded_chefs)).order_by(ooo)
    elif country:
        recipes = Recipe.select().where(
            (Recipe.countrys == country) & (Recipe.user_id != id)
            & Recipe.user_id.not_in(excluded_chefs)).order_by(ooo)
    elif prepTime:
        recipes = Recipe.select().where(
            (Recipe.prep <= prepTime) & (Recipe.user_id != id)
            & Recipe.user_id.not_in(excluded_chefs)).order_by(ooo)
    else:
        recipes = Recipe.select().where(
            (Recipe.user_id != id)
            & Recipe.user_id.not_in(excluded_chefs)).order_by(ooo)

    if recipes:
        return jsonify({
            "status":
            "success",
            "recipe": [{
                "id": recipe.id,
                "name": recipe.name,
                "photo": recipe.photo,
                "countrys": recipe.countrys,
                "hour": recipe.hour,
                "sec": recipe.sec,
                "directions": recipe.directions,
                "ingredients": recipe.ingredients,
                "time": recipe.time,
                "username": recipe.user.username,
                "user_id": recipe.user.id,
                "id_owner": recipe.user.id,
                "user_photo": recipe.user.photo
            } for recipe in recipes]
        }), 200
    else:
        return jsonify({"recipe": [], "status": "no recipe"}), 200
Beispiel #4
0
def user_profile(user, params, lang):
    origin_user = user
    uuid = params.get("uuid", "")
    if uuid:
        user = User.select().where(User.uuid == uuid).first()
        if not user:
            return {"error_code": 20002, "msg": "user not exist"}

    profile = user.profile.first()
    languages = []
    ul = UserLanguage.select().where(UserLanguage.user == user)
    for u in ul:
        languages.append(dict(
            language_id=u.id,
            name=u.name,
            level=u.level,
        ))
    out = dict()
    # user self can get private information
    if not uuid:
        out["reg_step"] = user.reg_step
        out["id_number"] = "%s********%s" % (profile.id_number[:6], profile.id_number[14:]) if profile.id_number else ""
        out["alipay"] = profile.alipay
        out["email"] = user.email
        out["phone"] = user.phone

    out["name"] = profile.name
    out["username"] = user.username
    out["avatar"] = widget.avatar(profile.avatar)
    out["completeness"] = profile.completeness
    out["visibility"] = profile.visibility
    out["level"] = profile.level
    out["title"] = profile.title
    out["overview"] = profile.overview
    out["hourly"] = profile.hourly
    out["english"] = profile.english
    out["skills"] = utils.loads(profile.skills) if profile.skills else []
    out["available"] = profile.available
    out["workload"] = profile.workload
    location = {}
    if profile.location_id:
        city = widget.get_location(profile.location_id)
        province = widget.get_location(city.parent_id)

        location["location_id"] = profile.location_id
        location["name"] = utils.lang_map_name(city.name, city.ename, lang)
        location["parent_id"] = province.id
        location["parent_name"] = utils.lang_map_name(province.name, province.ename, lang)
    out["location"] = location
    out["address"] = profile.address
    out["postcode"] = profile.postcode
    out['id'] = user.uuid
    out["languages"] = languages
    out["imid"] = user.id
    if uuid:
        favorites = Favorite.select().where(Favorite.user==origin_user, Favorite.target_id==profile.user_id, Favorite.ftype == 'REQ').first()
        if favorites:
            out["favorite"] = True
        else:
            out["favorite"] = False
    # 开发者的评价数量和平均得分
    score = UserStatistics.select(UserStatistics.eveluate_num, UserStatistics.aver_score).where(UserStatistics.user == user).first()
    out["eveluate_num"] = score.eveluate_num if score else 0
    out["aver_score"] = score.aver_score if score else 0
    return {"error_code": 0, "msg": "ok", "profile": out}
Beispiel #5
0
def user_profile(user, params, lang):
    origin_user = user
    uuid = params.get("uuid", "")
    if uuid:
        user = User.select().where(User.uuid == uuid).first()
        if not user:
            return {"error_code": 20002, "msg": "user not exist"}

    profile = user.profile.first()
    languages = []
    ul = UserLanguage.select().where(UserLanguage.user == user)
    for u in ul:
        languages.append(dict(
            language_id=u.id,
            name=u.name,
            level=u.level,
        ))
    out = dict()
    # user self can get private information
    if not uuid:
        out["reg_step"] = user.reg_step
        out["id_number"] = "%s********%s" % (
            profile.id_number[:6],
            profile.id_number[14:]) if profile.id_number else ""
        out["alipay"] = profile.alipay
        out["email"] = user.email
        out["phone"] = user.phone

    out["name"] = profile.name
    out["username"] = user.username
    out["avatar"] = widget.avatar(profile.avatar)
    out["completeness"] = profile.completeness
    out["visibility"] = profile.visibility
    out["level"] = profile.level
    out["title"] = profile.title
    out["overview"] = profile.overview
    out["hourly"] = profile.hourly
    out["english"] = profile.english
    out["skills"] = utils.loads(profile.skills) if profile.skills else []
    out["available"] = profile.available
    out["workload"] = profile.workload
    location = {}
    if profile.location_id:
        city = widget.get_location(profile.location_id)
        province = widget.get_location(city.parent_id)

        location["location_id"] = profile.location_id
        location["name"] = utils.lang_map_name(city.name, city.ename, lang)
        location["parent_id"] = province.id
        location["parent_name"] = utils.lang_map_name(province.name,
                                                      province.ename, lang)
    out["location"] = location
    out["address"] = profile.address
    out["postcode"] = profile.postcode
    out['id'] = user.uuid
    out["languages"] = languages
    out["imid"] = user.id
    if uuid:
        favorites = Favorite.select().where(
            Favorite.user == origin_user,
            Favorite.target_id == profile.user_id,
            Favorite.ftype == 'REQ').first()
        if favorites:
            out["favorite"] = True
        else:
            out["favorite"] = False
    # 开发者的评价数量和平均得分
    score = UserStatistics.select(
        UserStatistics.eveluate_num,
        UserStatistics.aver_score).where(UserStatistics.user == user).first()
    out["eveluate_num"] = score.eveluate_num if score else 0
    out["aver_score"] = score.aver_score if score else 0
    return {"error_code": 0, "msg": "ok", "profile": out}