def userdata_likes(user_code):
user = User.select_user_by_user_code(user_code)
if user is None:
return redirect(url_for('route.home'))
# ログイン中のユーザーがユーザーページのユーザーをフォローしているかの判定
followed = UserConnect.followed_exists(user.User_id)
follows = UserConnect.select_follows_by_user_id(user.User_id)
good_ratings_count,bad_ratings_count = Rating.select_rate_by_user_id(user.User_id)
# ユーザーが出品した商品
sell_items = Sell.select_sell_by_user_id(user.User_id)
# レコメンドリスト
if current_user.is_authenticated:
r_user_list = u_recommend(user.User_id,current_user.User_id)
else:
r_user_list = u_recommend(user.User_id)
# ユーザーがいいねした商品
items = Likes.likes_join_sell(Sell, user.User_id)
# ログイン中のユーザーが過去にどの商品をいいねしたかを格納しておく
liked_list = []
if current_user.is_authenticated:
for item in items:
liked = Likes.liked_exists(item.Sell_id)
if liked:
liked_list.append(item.Sell_id)
return render_template(
'user/userdata.html', user=user, followed=followed, follows_count=len(follows),
good_ratings_count=good_ratings_count, bad_ratings_count=bad_ratings_count,
items=items, liked_list=liked_list, post_c=len(sell_items), r_user_list=r_user_list
)
def mypage_likes():
# ログイン中のユーザーがユーザーページのユーザーをフォローしているかの判定
followed = UserConnect.followed_exists(current_user.User_id)
follows = UserConnect.select_follows_by_user_id(current_user.User_id)
good_ratings_count, bad_ratings_count = Rating.select_rate_by_user_id(
current_user.User_id)
# 売上金
sales = Sell.select_sales(current_user.User_id)
sales = sales.sumprice
# ユーザーが出品した商品
sell_items = Sell.select_sell_by_user_id(current_user.User_id)
# ユーザーがいいねした商品
items = Likes.likes_join_sell(Sell, current_user.User_id)
# 最近見た本
b_items = BrowsingHistory.b_history_join_sell(Sell, current_user.User_id)
# ログイン中のユーザーが過去にどの商品をいいねしたかを格納しておく
liked_list = []
for item in items:
liked = Likes.liked_exists(item.Sell_id)
if liked:
liked_list.append(item.Sell_id)
for item in b_items:
liked = Likes.liked_exists(item.Sell_id)
if liked:
liked_list.append(item.Sell_id)
return render_template('mypage/mypage.html',
followed=followed,
follows_count=len(follows),
good_ratings_count=good_ratings_count,
bad_ratings_count=bad_ratings_count,
items=items,
liked_list=liked_list,
post_c=len(sell_items),
b_items=b_items,
sales=sales)