# -*- coding: utf-8 -*- #!/usr/bin/env python import os, sys import threading import uuid import xlrd from xlrd import xldate_as_tuple import simplejson as json import datetime from django.conf import settings PROJECT_ROOT = os.path.join(os.path.abspath(os.path.split(os.path.realpath(__file__))[0] + "/.."), '..') sys.path.insert(0, PROJECT_ROOT) os.environ.setdefault('DJANGO_SETTINGS_MODULE', 'configs.production') from script.base import init_env init_env(interactive = False) from apps.web.device.models import SIMCard,Device from apps.web.constant import Const from apilib.utils_datetime import to_datetime from apps.web.user.models import RechargeRecord # 只把那种没有iccid的,但是又充值了的设备,单独找出来 supplier = sys.argv[1] excelFile = sys.argv[2] if supplier not in ['qiben','hezhou','jieyang','tianyu']: print u'卡供应商必须是qiben、hezhou' exit(0) book = xlrd.open_workbook(excelFile) try: sheet = book.sheet_by_name("sheet1") except Exception,e: print 'open excel file error =%s' % e exit(0) nrows = sheet.nrows rows = [] iccids = [] dxIccids = [] # 电信的iccid,不一样哟。设备报上来的比excel的多一位 imsiDict = {} for i in range(1, nrows): row = sheet.row_values(i) try: iccids.append(row[1].replace('\t','').upper()) iccids.append(row[1].replace('\t','').lower()) tempStr = row[3].replace('\t','') if tempStr: imsiDict[tempStr] = row[1].replace('\t','') if row[7] == u'电信': dxIccids.append(row[1].replace('\t','').upper()) dxIccids.append(row[1].replace('\t','').lower()) except Exception,e: print 'some error when update iccid=%s,e=%s' % (row[1],e) devIccids = [] devList= [] count = 0 devObjs = Device.objects.filter(iccid__in = iccids,ownerId__ne = None) for devObj in devObjs: if devObj.simStatus == 'updated': continue print str(devObj.iccid).upper() count = count + 1 # 单独处理电信的数据 dxIccids = list(set(dxIccids)) for iccid in dxIccids: devObj = Device.objects(iccid__in = iccid).first() if devObj is None: continue if devObj.simStatus == 'updated': continue print iccid count = count + 1 print "-----------------------------------------------------------------" devObjs = Device.objects.filter(imsi__in = imsiDict.keys(),ownerId__ne = None) for devObj in devObjs: if devObj.simStatus == 'updated': continue if devObj.iccid : # 如果有iccid,前面就会打印过,这里没有必要再打印 continue print imsiDict[devObj.imsi] count = count + 1 print 'finished. %s' % count