def card_info(): try: limit = request.args.get('limit') page = request.args.get('page') card_num = request.args.get('card_num') label = request.args.get('label') card_status = request.args.get('card_status') results = dict() results['code'] = RET.OK results['msg'] = MSG.OK user_id = g.user_id if card_status == "hide": status = "F" else: status = '' if not card_num and not label: data = SqlData.search_card_info(user_id, status, '', '') if len(data) == 0: results['code'] = RET.SERVERERROR results['msg'] = MSG.NODATA return jsonify(results) data = sorted(data, key=operator.itemgetter('id')) else: card_sql = '' if card_num: card_sql = "AND card_number LIKE '%" + card_num + "%'" label_sql = '' if label: label_sql = "AND label LIKE '%" + label + "%'" data = SqlData.search_card_info(user_id, status, card_sql, label_sql) if len(data) == 0: results['code'] = RET.SERVERERROR results['msg'] = MSG.NODATA return jsonify(results) page_list = list() info = list(reversed(data)) for i in range(0, len(info), int(limit)): page_list.append(info[i:i + int(limit)]) data = page_list[int(page) - 1] results['data'] = data results['count'] = len(info) return jsonify(results) except Exception as e: logging.error(e) return jsonify({'code': RET.SERVERERROR, 'msg': MSG.SERVERERROR})
def card_info(): limit = request.args.get('limit') page = request.args.get('page') user_id = request.args.get('u_id') results = dict() results['code'] = RET.OK results['msg'] = MSG.OK data = SqlData.search_card_info(user_id) if len(data) == 0: results['code'] = RET.SERVERERROR results['msg'] = MSG.NODATA return results data = sorted(data, key=operator.itemgetter('act_time')) page_list = list() data = list(reversed(data)) for i in range(0, len(data), int(limit)): page_list.append(data[i:i + int(limit)]) results['data'] = page_list[int(page) - 1] results['count'] = len(data) return jsonify(results)