manyi/script/simCard/find_need_charged_card_by_imsi.py

# -*- 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