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})