manyi/script/get_card_recharge_record.py

# coding=utf-8

from base import init_env
init_env(interactive = True)


from apps.web.user.models import CardRechargeRecord, Card

def get_records(cardNo):
    card = Card.objects.get(cardNo=cardNo)

    return CardRechargeRecord.objects.filter(cardId=str(card.id))


def get_data(records):
    dataList = list()
    for record in records:
        data = [
            str(record.money),
            str(record.coins),
            str(record.dateTimeAdded)[:19],
            record.remarks
        ]
        dataList.append(data)

    return dataList


def write_data(dataList, cardNo):
    dataStr = "付款金额\t\t\t\t充值金额\t\t\t\t充值时间\t\t\t\t备注\n"
    for item in dataList:

        tempStr = "\t\t\t\t".join(item) + "\n"

        dataStr += tempStr

    with open("{}.txt".format(cardNo), "w") as f:
        f.write(dataStr)


def main():
    cardNo = "1436087983"
    records = get_records(cardNo)
    dataList = get_data(records)
    write_data(dataList, cardNo)


if __name__ == '__main__':
    main()