def get_p_uid_list(user_id):
"""
获取父级用户id列表
:param user_id:
:return:
"""
result = []
# 一级
user_profile_info = get_row_by_id(UserProfile, user_id)
if not (user_profile_info and user_profile_info.user_pid):
return result
result.append(user_profile_info.user_pid)
user_id = user_profile_info.user_pid
# 二级
user_profile_info = get_row_by_id(UserProfile, user_id)
if not (user_profile_info and user_profile_info.user_pid):
return result
result.append(user_profile_info.user_pid)
user_id = user_profile_info.user_pid
# 三级
user_profile_info = get_row_by_id(UserProfile, user_id)
if not (user_profile_info and user_profile_info.user_pid):
return result
result.append(user_profile_info.user_pid)
return result
def get_user_auth_row_by_id(user_auth_id):
"""
通过 id 获取用户信息
:param user_auth_id:
:return: None/object
"""
return get_row_by_id(UserAuth, user_auth_id)
def get_user_bank_row_by_id(user_bank_id):
"""
通过 id 获取用户银行信息
:param user_bank_id:
:return: None/object
"""
return get_row_by_id(UserBank, user_bank_id)
def get_scheduling_row_by_id(scheduling_id):
"""
通过 id 获取排单信息
:param scheduling_id:
:return: None/object
"""
return get_row_by_id(Scheduling, scheduling_id)
def get_order_row_by_id(order_id):
"""
通过 id 获取订单信息
:param order_id:
:return: None/object
"""
return get_row_by_id(Order, order_id)
def get_bit_coin_item_row_by_id(bit_coin_item_id):
"""
通过 id 获取钱包信息
:param bit_coin_item_id:
:return: None/object
"""
return get_row_by_id(BitCoinItem, bit_coin_item_id)
def get_user_profile_row_by_id(user_id):
"""
通过 id 获取用户信息
:param user_id:
:return: None/object
"""
return get_row_by_id(UserProfile, user_id)
def get_message_row_by_id(message_id):
"""
通过 id 获取留言信息
:param message_id:
:return: None/object
"""
return get_row_by_id(Message, message_id)
def get_author_row_by_id(author_id):
"""
通过 id 获取博客信息
:param author_id:
:return: None/object
"""
return get_row_by_id(Author, author_id)
def get_score_charity_item_row_by_id(score_charity_item_id):
"""
通过 id 获取积分信息
:param score_charity_item_id:
:return: None/object
"""
return get_row_by_id(ScoreCharityItem, score_charity_item_id)
def get_bit_coin_row_by_id(bit_coin_id):
"""
通过 id 获取数字货币信息
:param bit_coin_id:
:return: None/object
"""
return get_row_by_id(BitCoin, bit_coin_id)
def get_active_item_row_by_id(active_item_id):
"""
通过 id 获取激活信息
:param active_item_id:
:return: None/object
"""
return get_row_by_id(ActiveItem, active_item_id)
def get_apply_get_row_by_id(apply_get_id):
"""
通过 id 获取提现申请信息
:param apply_get_id:
:return: None/object
"""
return get_row_by_id(ApplyGet, apply_get_id)
def get_user_credit_row_by_id(user_credit_id):
"""
通过 id 获取用户声望信息
:param user_credit_id:
:return: None/object
"""
return get_row_by_id(Credit, user_credit_id)
def get_wallet_item_row_by_id(wallet_item_id):
"""
通过 id 获取钱包信息
:param wallet_item_id:
:return: None/object
"""
return get_row_by_id(WalletItem, wallet_item_id)
def get_user_config_row_by_id(user_config_id):
"""
通过 id 获取用户配置信息
:param user_config_id:
:return: None/object
"""
return get_row_by_id(UserConfig, user_config_id)
def get_score_expense_row_by_id(score_expense_id):
"""
通过 id 获取积分信息
:param score_expense_id:
:return: None/object
"""
return get_row_by_id(ScoreExpense, score_expense_id)
def get_blog_row_by_id(blog_id):
"""
通过 id 获取博客信息
:param blog_id:
:return: None/object
"""
return get_row_by_id(Blog, blog_id)
def get_apply_put_row_by_id(apply_put_id):
"""
通过 id 获取投资申请信息
:param apply_put_id:
:return: None/object
"""
return get_row_by_id(ApplyPut, apply_put_id)
def get_complaint_row_by_id(complaint_id):
"""
通过 id 获取投诉信息
:param complaint_id:
:return: None/object
"""
return get_row_by_id(Complaint, complaint_id)
def get_order_bill_row_by_id(order_bill_id):
"""
通过 id 获取订单支付凭证信息
:param order_bill_id:
:return: None/object
"""
return get_row_by_id(OrderBill, order_bill_id)
def get_score_digital_row_by_id(score_digital_id):
"""
通过 id 获取积分信息
:param score_digital_id:
:return: None/object
"""
return get_row_by_id(ScoreDigital, score_digital_id)
def get_user_row_by_id(user_id):
"""
通过 id 获取用户信息
:param user_id:
:return: None/object
"""
return get_row_by_id(LoginUser, user_id)
def get_bonus_item_row_by_id(bonus_item_id):
"""
通过 id 获取奖金信息
:param bonus_item_id:
:return: None/object
"""
return get_row_by_id(BonusItem, bonus_item_id)
def is_active(user_id):
"""
是否激活
:param user_id:
:return:
"""
user_info = get_row_by_id(LoginUser, user_id)
return user_info.status_active if user_info else 0
def load_user(user_id):
"""
如果 user_id 无效，它应该返回 None （ 而不是抛出异常 ）。
:param user_id:
:return:
"""
from app_frontend.login import LoginUser
# return LoginUser.query.get(int(user_id))
return get_row_by_id(LoginUser, int(user_id))
def user_profile_is_complete(user_id):
"""
用户基本信息是否完整
:param user_id:
:return:
"""
user_profile_info = get_row_by_id(UserProfile, user_id)
if not user_profile_info:
return False
if user_profile_info.nickname and user_profile_info.phone and user_profile_info.id_card:
return True
return False
def user_bank_is_complete(user_id):
"""
用户银行信息是否完整
:param user_id:
:return:
"""
user_bank_info = get_row_by_id(UserBank, user_id)
if not user_bank_info:
return False
if user_bank_info.account_name \
and user_bank_info.bank_name \
and user_bank_info.bank_address \
and user_bank_info.bank_account:
return True
return False
