def get_user_info():
args_dic = {}
username = request.args.get('username')
userid = request.args.get('uid', type=int)
if username != None:
args_dic['username'] = username
if userid != None:
args_dic['uid'] = userid
official_users = User.get_user(args_dic)
return jsonify({'data': official_users})
def get_user_sta(cls, args_dic):
results = db_app.session().query(cls.User_userID, func.sum(cls.oPrice).label('sums')). \
group_by(cls.User_userID). \
filter(cls.orderID.in_(args_dic['orderid_list'])). \
order_by(db_app.desc('sums'))
result_list = []
for i, res in enumerate(results.all()):
if i >= 10: break
args_dic['uid'] = res[0]
user = User.get_user(args_dic)[0]
user['totalprice'] = (float)(res[1])
result_list.append(user)
return result_list
