def card_info_all():
try:
limit = request.args.get('limit')
page = request.args.get('page')
field = request.args.get('field')
value = request.args.get('value')
if field == "card_cus":
account_id = SqlData.search_user_field_name('id', value)
sql = "WHERE user_id=" + str(account_id)
elif field:
sql = "WHERE " + field + " LIKE '%" + value + "%'"
else:
# 如果没有搜索条件,则分页查询MYSQL,加快速度
start_index = (int(page) - 1) * int(limit)
sql = 'limit ' + str(start_index) + ", " + limit + ';'
results = dict()
results['code'] = RET.OK
results['msg'] = MSG.OK
info_list = SqlData.search_card_info_admin(sql)
if not info_list:
results['code'] = RET.OK
results['msg'] = MSG.NODATA
return jsonify(results)
results['data'] = info_list
results['count'] = SqlData.search_table_count('card_info')
return jsonify(results)
except Exception as e:
logging.error(str(e))
return jsonify({'code': RET.SERVERERROR, 'msg': MSG.SERVERERROR})
def push_log():
'''
卡交易推送接口
:return:
待解决搜索条件sql组合
'''
try:
page = request.args.get('page')
limit = request.args.get('limit')
range_time = request.args.get('range_time')
card_no = request.args.get('card_no')
if range_time or card_no:
start_time = range_time.split(" - ")[0]
end_time = range_time.split(" - ")[1] + ' 23:59:59'
time_sql = " timestamp BETWEEN '" + start_time + "' AND '" + end_time + "'"
card_sql = ""
if card_no:
card_sql = " card_no LIKE '%" + card_no + "%'"
sql = "WHERE" + time_sql + card_sql
else:
start_index = (int(page) - 1) * int(limit)
sql = 'ORDER BY push_log.id desc limit ' + str(
start_index) + ", " + limit + ';'
results = dict()
results['msg'] = MSG.OK
results['code'] = RET.OK
info = SqlData.search_push(sql)
if not info:
results['msg'] = MSG.NODATA
return jsonify(results)
task_info = info
page_list = list()
if 'limit' in sql:
s = 'push_log'
results['data'] = task_info
else:
# 分页显示
for i in range(0, len(task_info), int(limit)):
page_list.append(task_info[i:i + int(limit)])
results['data'] = page_list[int(page) - 1]
s = 'push_log ' + sql
results['count'] = SqlData.search_table_count(s)
return jsonify(results)
except Exception as e:
print(e)
logging.error('查询卡交易推送失败:' + str(e))
return jsonify({'code': RET.SERVERERROR, 'msg': MSG.SERVERERROR})
