def pay_log(): results = dict() results['code'] = RET.OK results['msg'] = MSG.OK limit = request.args.get('limit') page = request.args.get('page') status = request.args.get('status') data = SqlData.search_pay_log(status) if not data: results['msg'] = MSG.NODATA return jsonify(results) info = list(reversed(data)) page_list = list() for i in range(0, len(info), int(limit)): page_list.append(info[i:i + int(limit)]) info_list = page_list[int(page) - 1] # 查询当次充值时的账号总充值金额 new_list = list() for o in info_list: x_time = o.get('ver_time') user_id = o.get('cus_id') sum_money = SqlData.search_time_sum_money(x_time, user_id) o['sum_balance'] = round(sum_money, 2) new_list.append(o) results['data'] = new_list results['count'] = len(data) return jsonify(results)
def top_history(): page = request.args.get('page') limit = request.args.get('limit') acc_name = request.args.get('acc_name') order_num = request.args.get('order_num') time_range = request.args.get('time_range') results = {"code": RET.OK, "msg": MSG.OK, "count": 0, "data": ""} name_sql = "" order_sql = "" time_sql = "" if acc_name: name_sql = "account.name ='" + acc_name + "'" if order_num: order_sql = "top_up.pay_num = '" + order_num + "'" if time_range: min_time = time_range.split(' - ')[0] max_time = time_range.split(' - ')[1] + ' 23:59:59' time_sql = "top_up.time BETWEEN " + "'" + min_time + "'" + " and " + "'" + max_time + "'" if name_sql and time_sql and order_sql: sql_all = "WHERE " + name_sql + " AND " + order_sql + " AND " + time_sql elif name_sql and order_sql: sql_all = "WHERE " + name_sql + " AND " + order_sql elif time_sql and order_sql: sql_all = "WHERE " + time_sql + " AND " + order_sql elif name_sql and time_sql: sql_all = "WHERE " + name_sql + " AND " + time_sql elif name_sql: sql_all = "WHERE " + name_sql elif order_sql: sql_all = "WHERE " + order_sql elif time_range: sql_all = "WHERE " + time_sql else: sql_all = "" task_info = SqlData.search_top_history(sql_all) if len(task_info) == 0: results['MSG'] = MSG.NODATA return jsonify(results) page_list = list() task_info = sorted(task_info, key=operator.itemgetter('time')) task_info = list(reversed(task_info)) for i in range(0, len(task_info), int(limit)): page_list.append(task_info[i:i + int(limit)]) data = page_list[int(page) - 1] # 处理不同充值类型的显示方式(系统, 退款) info_list_1 = list() for n in data: trans_type = n.get('trans_type') # if trans_type == '系统': n['refund'] = '' info_list_1.append(n) """ elif trans_type == '退款': n['refund'] = n.get('money') n['money'] = '' continue info_list_1.append(n) """ # 查询当次充值时的账号总充值金额 info_list = list() for o in info_list_1: x_time = o.get('time') user_id = o.get('user_id') sum_money = SqlData.search_time_sum_money(x_time, user_id) o['sum_balance'] = round(sum_money, 2) info_list.append(o) results['data'] = info_list_1 results['count'] = len(task_info) return jsonify(results)