Example #1
0
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})
Example #2
0
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)