manyi/script/zbd_utils/liyan_IC_card_fix.py

# -*- coding: utf-8 -*-
#!/usr/bin/env python

import os
import sys
import datetime

PROJECT_ROOT = os.path.join(os.path.abspath(os.path.split(os.path.realpath(__file__))[0] + "/.."), '..')
sys.path.insert(0, PROJECT_ROOT)

# 引入项目环境和日志
from script.base import init_env, get_logger

init_env(interactive=True)
logger = get_logger(__name__)

from apps.web.user.models import RechargeRecord, CardRechargeOrder, ICChargeOperating
from bson.objectid import ObjectId

# 传orderNo
arr = []

for _ in arr:
    r = RechargeRecord.objects(orderNo=_).first()

    if r is None:
        logger.error('invalid orderNo=%s' % _)
        continue

    if r.via != u'chargeCard':
        logger.error('not chargeCard=%s' % _)
        continue

    cardId = r.attachParas['cardId']

    c = CardRechargeOrder.objects(rechargeNo=ObjectId(cardId)).first()

    if c is None:
        logger.error('get orderNo=%s but undefined cardId=%s' % (_, r.attachParas['cardId']))
        continue

    # 1.删
    ics = ICChargeOperating.objects(cardId=cardId)
    for ic in ics:
        ic.delete()

    # 2.改状态
    c.status = u'finishedPay'
    # 3.改时间
    c.dateTimeAdded = datetime.datetime.now()
    c.save()

print 'done!'