def doProvinceCheck(province, wid, mobile, serviceOrderId, feeFlag):
s1 = "select ifnull(msg_count,0) from webowner_province where province2='%s' and wid=%s" % (province, wid)
msgCount = db.getint(s1)
if msgCount == 0:
log.info("province province=%s is 0 .jump it .wid=%s mobile=%s serviceOrderId=%s" % (
province, wid, mobile, serviceOrderId))
sql2 = "update webowner_province set today_count=today_count+1 where wid=%s and province2='%s'" % (
wid, province)
db.execute(sql2)
sql = "update lem_webowner set today_count=today_count+1 where wid=%s" % (wid,)
db.execute(sql)
return feeFlag;
else:
s2 = "select today_count from webowner_province where province2='%s' and wid=%s " % (province, wid)
todayCount = db.getint(s2)
if (todayCount >= msgCount):
log.info(
"province check fail. province=%s is msgCount=%s today=%s .reject it .wid=%s mobile=%s serviceOrderId=%s" % (
province, msgCount, todayCount, wid, mobile, serviceOrderId))
return 0;
sql2 = "update webowner_province set today_count=today_count+1 where wid=%s and province2='%s'" % (
wid, province)
db.execute(sql2)
sql = "update lem_webowner set today_count=today_count+1 where wid=%s" % (wid,)
db.execute(sql)
log.info(
"province add province=%s and wid=%s today_count=%s msg_count=%s mobile=%s serviceOrderId=%s" % (
province, wid, todayCount + 1, msgCount, mobile, serviceOrderId))
return feeFlag
def get(self):
sql = "update lem_webowner set today_count=0";
db.execute(sql);
sql = "update webowner_province set today_count=0";
db.execute(sql);
log.info(" clear data ok.")
def serviceProcess(msg):
try:
pid = 10
wid = 1000
channel = ""
adid = "1000"
servicecode = msg.get('servicecode')
mobile = msg.get('mobile')
feeFlag = 1
adownerCode = getAdownerCode(servicecode)
if adownerCode is None:
log.info("feecenter servicecode is null: " + servicecode + ". adownerDic = " + str(adownerDic))
adownerCode = dict()
pid = adownerCode.get("pid")
gateway = adownerCode.get("gateway")
ordercode = adownerCode.get('ordercode')
orderdest = adownerCode.get('orderdest')
serviceOrderId = msg["serviceOrderId"]
serviceSubTime = lang.now()
if pid == 10:
orderdest = msg.get('orderdest')
webowner = db.get("select i.wid, i.channel,a.adownerid from lem_ivr_info i,lem_adowner_code a where a.servicecode=i.servicecode and i.orderdest = %s", orderdest)
if webowner:
wid = webowner.wid
channel = webowner.channel
adid = webowner.adownerid
elif pid == 11:
webowner = db.get("select i.wid, i.channel,a.adownerid from lem_ivr_info i,lem_adowner_code a where a.servicecode=i.servicecode and i.orderdest = %s", orderdest + ordercode)
if webowner:
wid = webowner.wid
channel = webowner.channel
adid = webowner.adownerid
else:
order = None
try:
order = db.get(
"select * from Lez_sms_orderlog where mobile = ? and servicecode = ? order by subtime desc limit 1",
mobile, servicecode)
if order:
orderid = order.get('id')
db.execute("update sms_order_log set flag = 1 where flag = 0 and id='" + orderid + "'")
except:
log.error("feecenter id error:%s" % lang.trace_back())
if order:
wid = order.get('wid')
channel = order.get('channel')
adid = order.get('adid')
if not isWhiteMobile(mobile) and isWebNeedDeduct(pid, wid):
feeFlag = 0
servicefee = adownerCode.get("servicefee")
ownerfee = adownerCode.get("ownerfee")
totalincome = 0
feeincome = 0
if pid == 10:
starttime = msg.get('starttime')
endtime = msg.get('endtime')
ivrtotal = msg.get('ivrtotal')
records = int(math.ceil(float(ivrtotal) / msg.get('ivrunit', 180)))
totalincome = records * servicefee
feeincome = records * ownerfee
sql = "insert lez_ivr_detail(id,wid,channel,mobile,servicecode,orderdest,starttime,endtime,total,totalincome, feeincome, feeflag, subtime) values('%s',%s,'%s','%s','%s','%s','%s','%s',%s,%s,%s,%s,'%s')" % (
serviceOrderId, wid, channel, mobile, servicecode, orderdest, starttime, endtime, ivrtotal, totalincome,
feeincome, feeFlag, serviceSubTime)
db.execute(sql)
if pid == 11:
totalincome = servicefee
feeincome = ownerfee
# check the msg_count == today_count
province = ''
webownerMsgCount = webownerMsgCountDic[wid]
if webownerMsgCount != 0:
log.info(
"webowner msg_count=%s.do check. wid=%s, servicecode=%s mobile=%s serviceOrderId=%s" % (
webownerMsgCount, wid, servicecode, mobile, serviceOrderId))
sql = "select today_count from lem_webowner where wid='%s'" % (wid,);
today_count = db.getint(sql);
if today_count >= webownerMsgCount:
log.info(
"webowner msg_count fail.reject it. %s 's msg_count=%s, today_count=%s mobile=%s serviceOrderId=%s" % (
wid, webownerMsgCount, today_count, mobile, serviceOrderId))
feeFlag = 0
else:
province = getProvince(mobile)
feeFlag = doProvinceCheck(province, wid, mobile, serviceOrderId, feeFlag)
else:
# log.info("msg_count=0. jump. wid=%s servicecode=%s feeFlag=%s" % (wid, servicecode, feeFlag))
log.info(
"webowner msg_count=0. do check province.wid=%s servicecode=%s mobile=%s serviceOrderId=%s" % (
wid, servicecode, mobile, serviceOrderId))
province = getProvince(mobile)
feeFlag = doProvinceCheck(province, wid, mobile, serviceOrderId, feeFlag)
log.info("wid=%s mobile=%s province=%s feeFlag=%s serviceOrderId=%s" % (
wid, mobile, province, feeFlag, serviceOrderId))
sql = "insert into lez_service_log(id,wid,channel,servicecode,pid,mobile,adid,totalincome,feeincome,status,statusstring,feeflag,gateway,subtime,ordercode,orderdest) values('%s',%s,'%s','%s',%s,'%s','%s',%s,%s,'%s','%s',%s,%s,'%s','%s','%s')" % (
serviceOrderId, wid, channel, servicecode, pid, mobile, adid, totalincome, feeincome, msg.get('status'),
msg.get('statusstring'), feeFlag, gateway, serviceSubTime, ordercode, orderdest)
db.execute(sql)
if feeFlag == 1:
forwardToWebowner(wid, lang.num(channel), serviceOrderId, mobile, orderdest, ordercode, feeincome)
except:
log.error("serviceprocess error:%s" % lang.trace_back())