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