manyi/script/card_refund_and_consume.py

# coding=utf-8

from base import init_env
init_env(interactive = True)

from apps.web.device.models import Device
from apps.web.user.models import Card, CardConsumeRecord, CardRechargeRecord

cardNo = "2774697269"
card = Card.objects.get(cardNo=cardNo)
cardId = str(card.id)

consumeRecords = CardConsumeRecord.objects.filter(cardId=cardId)
rechargeRecords = CardRechargeRecord.objects.filter(cardId=cardId, remarks="退币")

ct = "消费额度\t\t消费时间\t\t消费设备\n\n"
for cRecord in consumeRecords:
    dev = Device.get_dev(cRecord.devNo)
    tempList = [
        str(cRecord.money),
        str(cRecord.dateTimeAdded)[:19],
        dev.logicalCode,
    ]
    tempStr = "\t\t".join(tempList) + "\n\n"
    ct += tempStr

rt = "退币金额\t\t退币时间\n\n"
for rRecord in rechargeRecords:
    tempList = [
        str(rRecord.coins),
        str(rRecord.dateTimeAdded)[:19],
    ]
    tempStr = "\t\t".join(tempList) + "\n\n"
    rt += tempStr


with open("{}.txt".format(cardNo)) as f:
    f.write(ct+rt)