def FreeUserPackageInfo(self):
'''免费套餐用户所属类别ID'''
self.Free_TypeID = 2
self.typeObj = TypeInfo(self.mysql_conn, self.Free_TypeID)
'''免费套餐月规定流量'''
self.Free_Month_Flow = self.typeObj.flow
'''免费套餐结束日期'''
self.Free_EndDate = "0000-00-00"
'''免费套餐规定月数'''
self.Free_Month_Count = 0
'''Write to log file for debug'''
self.logger.debug("Free Package info : \n \
Uid : %s \n \
TypeID : %s \n \
Month_Flow : %s \n \
" %
(self.uid, self.Free_TypeID, self.Free_Month_Flow))
def FreeUserPackageInfo(self):
'''免费套餐用户所属类别ID'''
self.Free_TypeID = 2
self.typeObj = TypeInfo(self.mysql_conn,self.Free_TypeID)
'''免费套餐月规定流量'''
self.Free_Month_Flow = self.typeObj.flow
'''免费套餐结束日期'''
self.Free_EndDate = "0000-00-00"
'''免费套餐规定月数'''
self.Free_Month_Count = 0
'''Write to log file for debug'''
self.logger.debug("Free Package info : \n \
Uid : %s \n \
TypeID : %s \n \
Month_Flow : %s \n \
"%(self.uid,self.Free_TypeID,self.Free_Month_Flow))
class CheckUserPackage():
def __init__(self, uid, logger, datadate, redata, mongoconn, mysql_conn):
self.uid = uid
self.logger = logger
self.today = str(datadate)
self.redata = redata
self.mongoconn = mongoconn
self.mysql_conn = mysql_conn
def UserPackageInfo(self):
self.UidObj = UidInfo(self.mysql_conn, self.mongoconn, self.uid)
flow_info = self.UidObj.get_flow_info(self.uid)
'''用户套餐所属类别ID'''
self.Now_TypeID = flow_info[7]
'''用户email地址'''
self.Email = flow_info[8]
'''用户套餐开始日期'''
self.Now_StartDate = str(flow_info[0])
'''用户套餐结束日期'''
self.Now_EndDate = str(flow_info[1])
'''用户套餐购买月数'''
self.Now_Month_Count = flow_info[2]
'''用户套餐月规定流量'''
self.Now_Month_Flow = flow_info[3]
'''用户该月已用流量'''
self.Now_Month_Used_Flow = flow_info[4]
'''用户该月已超流量'''
self.Now_Month_Advance_Flow = flow_info[5]
'''用户今天消耗流量'''
self.Daily_Flow = self.UidObj.get_daily_flow(self.uid) / 1024
'''截至今天用户该月消耗总流量'''
self.Month_Sum_Flow = self.Now_Month_Used_Flow + self.Now_Month_Advance_Flow + self.Daily_Flow
'''Write to log file for debug'''
self.logger.debug(
"Now Package info : \n \
Uid : %s \n \
TypeID : %s \n \
Email : %s \n \
StartDate : %s \n \
EndDate : %s \n \
Month_Count : %s \n \
Month_Flow : %s \n \
Month_Used_Flow : %s \n \
Month_Advance_Flow : %s \n \
Daily_Flow : %s \n \
Month_Sum_Flow : %s \n \
" %
(self.uid, self.Now_TypeID, self.Email, self.Now_StartDate,
self.Now_EndDate, self.Now_Month_Count, self.Now_Month_Flow,
self.Now_Month_Used_Flow, self.Now_Month_Advance_Flow,
self.Daily_Flow, self.Month_Sum_Flow))
def FreeUserPackageInfo(self):
'''免费套餐用户所属类别ID'''
self.Free_TypeID = 2
self.typeObj = TypeInfo(self.mysql_conn, self.Free_TypeID)
'''免费套餐月规定流量'''
self.Free_Month_Flow = self.typeObj.flow
'''免费套餐结束日期'''
self.Free_EndDate = "0000-00-00"
'''免费套餐规定月数'''
self.Free_Month_Count = 0
'''Write to log file for debug'''
self.logger.debug("Free Package info : \n \
Uid : %s \n \
TypeID : %s \n \
Month_Flow : %s \n \
" %
(self.uid, self.Free_TypeID, self.Free_Month_Flow))
def UserPackageExtInfo(self):
Ext_TypeInfo = self.typeObj.get_ext_typeinfo(self.uid)
'''扩展表开始时间'''
self.old_starttime = str(Ext_TypeInfo[0])
'''扩展表结束时间'''
self.ext_enddate = str(Ext_TypeInfo[1])
'''扩展表月流量限制'''
self.o_mount_flow = Ext_TypeInfo[2]
'''扩展表续费标签'''
self.is_ext = Ext_TypeInfo[3]
'''扩展表月数'''
self.total_mouth = Ext_TypeInfo[4]
'''Write to log file for debug'''
self.logger.debug("Ext Package info : \n \
Uid : %s \n \
old_starttime : %s \n \
ext_enddate : %s \n \
o_mount_flow : %s \n \
is_ext : %s \n \
total_mouth : %s \n \
" %
(self.uid, self.old_starttime, self.ext_enddate,
self.o_mount_flow, self.is_ext, self.total_mouth))
def ExeMysqlCmd(self, sql, param):
'''执行mysql语句'''
SqlCmd = sql % param
try:
cursor = self.mysql_conn.cursor()
self.mysql_conn.select_db('video')
cursor.execute(sql, param)
self.mysql_conn.commit()
except Exception, e:
self.logger.error("Execute sql error : \n %s " % SqlCmd)
finally:
class CheckUserPackage():
def __init__(self,uid,logger,datadate,redata,mongoconn,mysql_conn):
self.uid = uid
self.logger = logger
self.today = str(datadate)
self.redata = redata
self.mongoconn = mongoconn
self.mysql_conn = mysql_conn
def UserPackageInfo(self):
self.UidObj = UidInfo(self.mysql_conn,self.mongoconn,self.uid)
flow_info = self.UidObj.get_flow_info(self.uid)
'''用户套餐所属类别ID'''
self.Now_TypeID = flow_info[7]
'''用户email地址'''
self.Email = flow_info[8]
'''用户套餐开始日期'''
self.Now_StartDate = str(flow_info[0])
'''用户套餐结束日期'''
self.Now_EndDate = str(flow_info[1])
'''用户套餐购买月数'''
self.Now_Month_Count = flow_info[2]
'''用户套餐月规定流量'''
self.Now_Month_Flow = flow_info[3]
'''用户该月已用流量'''
self.Now_Month_Used_Flow = flow_info[4]
'''用户该月已超流量'''
self.Now_Month_Advance_Flow = flow_info[5]
'''用户今天消耗流量'''
self.Daily_Flow = self.UidObj.get_daily_flow(self.uid)/1024
'''截至今天用户该月消耗总流量'''
self.Month_Sum_Flow = self.Now_Month_Used_Flow + self.Now_Month_Advance_Flow + self.Daily_Flow
'''Write to log file for debug'''
self.logger.debug("Now Package info : \n \
Uid : %s \n \
TypeID : %s \n \
Email : %s \n \
StartDate : %s \n \
EndDate : %s \n \
Month_Count : %s \n \
Month_Flow : %s \n \
Month_Used_Flow : %s \n \
Month_Advance_Flow : %s \n \
Daily_Flow : %s \n \
Month_Sum_Flow : %s \n \
"%(self.uid,self.Now_TypeID,self.Email,self.Now_StartDate,self.Now_EndDate,self.Now_Month_Count,self.Now_Month_Flow,self.Now_Month_Used_Flow,self.Now_Month_Advance_Flow,self.Daily_Flow,self.Month_Sum_Flow))
def FreeUserPackageInfo(self):
'''免费套餐用户所属类别ID'''
self.Free_TypeID = 2
self.typeObj = TypeInfo(self.mysql_conn,self.Free_TypeID)
'''免费套餐月规定流量'''
self.Free_Month_Flow = self.typeObj.flow
'''免费套餐结束日期'''
self.Free_EndDate = "0000-00-00"
'''免费套餐规定月数'''
self.Free_Month_Count = 0
'''Write to log file for debug'''
self.logger.debug("Free Package info : \n \
Uid : %s \n \
TypeID : %s \n \
Month_Flow : %s \n \
"%(self.uid,self.Free_TypeID,self.Free_Month_Flow))
def UserPackageExtInfo(self):
Ext_TypeInfo = self.typeObj.get_ext_typeinfo(self.uid)
'''扩展表开始时间'''
self.old_starttime = str(Ext_TypeInfo[0])
'''扩展表结束时间'''
self.ext_enddate = str(Ext_TypeInfo[1])
'''扩展表月流量限制'''
self.o_mount_flow = Ext_TypeInfo[2]
'''扩展表续费标签'''
self.is_ext = Ext_TypeInfo[3]
'''扩展表月数'''
self.total_mouth = Ext_TypeInfo[4]
'''Write to log file for debug'''
self.logger.debug("Ext Package info : \n \
Uid : %s \n \
old_starttime : %s \n \
ext_enddate : %s \n \
o_mount_flow : %s \n \
is_ext : %s \n \
total_mouth : %s \n \
"%(self.uid,self.old_starttime,self.ext_enddate,self.o_mount_flow,self.is_ext,self.total_mouth))
def ExeMysqlCmd(self,sql,param):
'''执行mysql语句'''
SqlCmd = sql%param
try:
cursor = self.mysql_conn.cursor()
self.mysql_conn.select_db('video')
cursor.execute(sql,param)
self.mysql_conn.commit()
except Exception,e:
self.logger.error("Execute sql error : \n %s "%SqlCmd)
finally:
def CheckFlow(UidObj,redisconn,Mail_list):
uid = UidObj.Uid
mysqlconn = UidObj.mysqlconn
cursor = mysqlconn.cursor()
flow_info = UidObj.get_flow_info(uid)
daily_flow = UidObj.get_daily_flow(uid)
daily_flow = daily_flow/1024
#daily_flow = 120
today = datetime.datetime.now().strftime("%Y-%m-%d")
#today = "2013-06-24"
enddate = str(flow_info[1])
begindate = str(flow_info[0])
month_count = flow_info[2]
month_flow = flow_info[3]
if flow_info[4] == None:
month_used_flow = 0
else:
month_used_flow = flow_info[4]
if flow_info[5] == None:
month_advance_flow = 0
else:
month_advance_flow = flow_info[5]
is_flow_alarm = flow_info[6]
typeid = flow_info[7]
if flow_info[8] == None:
user_email = None
else:
user_email = flow_info[8]
#user_email = "*****@*****.**"
begindate_list = get_days_list(begindate,month_count)
if month_count == 0:
last_one_month = "0000-00-00"
else:
last_one_month = begindate_list[-1:]
subject2 = u"流量报警通知！"
text2 = u'''尊敬的天空视频网用户：
由于您本月使用的流量已经超过了购买的套餐月流量上限的90%，未防止你的视频播放中断，请尽快充值。
温馨提示：为了更好的提供我们的视频服务，对于所有的付费套餐用户，如果您未能及时充值，我们将
从您下个月的流量中借用10%来继续本月的流量使用。
祝您使用愉快，如果您有什么建议或其他反馈请联系我们客服。邮箱：[email protected]
'''
subject3 = u"流量超支通知！！！"
text3 = u'''尊敬的用户：
由于你购买的套餐流量已经超过了月流量，你的视频已经中断，请充值。
祝您使用愉快，如果您有什么建议或其他反馈请联系我们客服。邮箱：[email protected]
'''
total_used_flow = month_used_flow + month_advance_flow + daily_flow
typeObj = TypeInfo(mysqlconn,2)
if today == enddate:
print "in the endtate mothed"
ext_typeinfo = typeObj.get_ext_typeinfo(uid)
if ext_typeinfo == []:
"免费用户降级"
data = fall_type(total_used_flow,month_flow,typeObj.flow)
sqlOne = "update uflow set startdate=%s,enddate=%s,month_count=%s,month_flow=%s,month_used_flow=%s,month_advance_flow=%s,is_flow_alarm=%s where uid = %s"
param = (data[0],data[1],data[2],data[3],data[4],data[5],data[6],uid)
cursor.execute(sqlOne,param)
mysqlconn.commit()
redisconn.set("%s_flow"%uid,data[7])
#同时更新uinfo中的套餐类型
sqlTwo = "update uinfo set tid = 2 where uid = %s"
cursor.execute(sqlTwo,uid)
mysqlconn.commit()
subject = u"套餐降级通知！"
text = u'''尊敬的天空视频网用户：
由于你购买的套餐或者充值流量已经到期，所以我们自动将您降级为免费用户，免费用户将有2GB/月的流量使用
和1GB的存储空间。如果您现在所有的视频文件所占用的存储空间超过1GB，我们将在7天后删除您的视频文件
到占用存储空间不超过1GB为止。
祝您使用愉快，如果您有什么建议或其他反馈请联系我们客服。
邮箱：[email protected].
'''
SendMail(Mail_list,user_email,subject,text)
else:
old_starttime = str(ext_typeinfo[0])
ext_enddate = str(ext_typeinfo[1])
o_mount_flow = ext_typeinfo[2]
is_ext = ext_typeinfo[3]
total_mouth = ext_typeinfo[4]
if is_ext == 1 :
#套餐不续费,降级
data = fall_type(total_used_flow,month_flow,typeObj.flow)
sqlOne = "update uflow set startdate=%s,enddate=%s,month_count=%s,month_flow=%s,month_used_flow=%s,month_advance_flow=%s,is_flow_alarm=%s where uid = %s"
param = (data[0],data[1],data[2],data[3],data[4],data[5],data[6],uid)
cursor.execute(sqlOne,param)
mysqlconn.commit()
redisconn.set("%s_flow"%uid,data[7])
#同时更新uinfo中的套餐类型
sqlTwo = "update uinfo set tid = 2 where uid = %s"
cursor.execute(sqlTwo,uid)
mysqlconn.commit()
subject = u"套餐降级通知！"
text = u'''尊敬的天空视频网用户：
由于你购买的套餐或者充值流量已经到期，所以我们自动将您降级为免费用户，免费用户将有2GB/月的流量使用
和1GB的存储空间。如果您现在所有的视频文件所占用的存储空间超过1GB，我们将在7天后删除您的视频文件
到占用存储空间不超过1GB为止。
祝您使用愉快，如果您有什么建议或其他反馈请联系我们客服。
邮箱：[email protected].
'''
SendMail(Mail_list,user_email,subject,text)
else:
#套餐续费
old_starttime_list = old_starttime.split("-")
old_endtime_list = enddate.split('-')
old_starttime_list[0] = str(old_endtime_list[0])
new_starttime = '-'.join(old_starttime_list)
new_enddate = ext_enddate
new_month_count = total_mouth - month_count
sqlNine = "update uflow set startdate=%s,enddate=%s,month_count=%s,month_flow=%s,month_used_flow=%s,month_advance_flow=%s,is_flow_alarm=%s where uid =%s"
now_month_used = total_used_flow - month_flow
if now_month_used >= 0:
now_month_extr = now_month_used - o_mount_flow
if now_month_extr > o_mount_flow*0.1:
new_month_used_flow = o_mount_flow
new_month_advance_flow = now_month_extr
is_flow_alarm = 1
is_write_redis = 0
SendMail(Mail_list,user_email,subject3,text3)
elif 0< now_month_extr <= o_mount_flow*0.1:
new_month_used_flow = o_mount_flow
new_month_advance_flow = now_month_extr
is_flow_alarm = 1
is_write_redis = 1
SendMail(Mail_list,user_email,subject2,text2)
elif -o_mount_flow*0.1 < now_month_extr <=0 :
new_month_used_flow = now_month_used
new_month_advance_flow = 0
is_flow_alarm = 1
is_write_redis = 1
SendMail(Mail_list,user_email,subject2,text2)
else:
new_month_used_flow = now_month_used
new_month_advance_flow = 0
is_flow_alarm = 0
is_write_redis = 1
else:
new_month_used_flow = 0
new_month_advance_flow = 0
is_flow_alarm = 0
is_write_redis = 1
print new_month_used_flow,new_month_advance_flow,is_flow_alarm,is_write_redis
param = (new_starttime,new_enddate,new_month_count,o_mount_flow,new_month_used_flow,new_month_advance_flow,is_flow_alarm,uid)
cursor.execute(sqlNine,param)
mysqlconn.commit()
redisconn.set("%s_flow"%uid,is_write_redis)
#跟新ucurrntetc表，开启续费开关
sqlTen = 'update ucurrenttc set xufei_status=1 where uid = %s'
param = (uid)
cursor.execute(sqlTen,param)
mysqlconn.commit()
elif str(today) in begindate_list:
"月初"
print "in the month begging methed"
if typeid == 2 and month_count == 0:
"免费模式中的月初初始化，送2G流量"
#当日使用流量+月已经使用流量+额外使用流量的值-2G 获得本月初始化后可以使用的流量
if month_advance_flow >0:
pass
else:
sqlThree = "update uflow set month_used_flow=%s,month_advance_flow=%s,is_flow_alarm=%s where uid = %s "
now_month_used = total_used_flow - month_flow
now_month_extr = now_month_used - typeObj.flow
if now_month_used >= 0:
if now_month_extr >= 0:
new_month_used_flow = typeObj.flow
new_month_advance_flow = now_month_extr
is_flow_alarm = 1
is_write_redis = 0
SendMail(Mail_list,user_email,subject3,text3)
elif now_month_extr < -typeObj.flow*0.1:
new_month_used_flow = now_month_used
new_month_advance_flow = 0
is_flow_alarm = 0
is_write_redis = 1
else:
new_month_used_flow = now_month_used
new_month_advance_flow = 0
is_flow_alarm = 1
is_write_redis = 1
SendMail(Mail_list,user_email,subject2,text2)
else:
new_month_used_flow = 0
new_month_advance_flow = 0
is_flow_alarm = 0
is_write_redis =1
param = (new_month_used_flow,new_month_advance_flow,is_flow_alarm,uid)
cursor.execute(sqlThree,param)
mysqlconn.commit()
redisconn.set("%s_flow"%uid,is_write_redis)
elif typeid == 2 and month_count != 0:
now_month_used = total_used_flow - month_flow
sqlFour = "update uflow set month_flow=%s,month_used_flow=%s,month_advance_flow=%s,is_flow_alarm=%s where uid =%s"
if now_month_used > 0:
#降级
data = fall_type(total_used_flow,month_flow,typeObj.flow)
sqlOne = "update uflow set startdate=%s,enddate=%s,month_count=%s,month_flow=%s,month_used_flow=%s,month_advance_flow=%s,is_flow_alarm=%s where uid = %s"
param = (data[0],data[1],data[2],data[3],data[4],data[5],data[6],uid)
cursor.execute(sqlOne,param)
mysqlconn.commit()
redisconn.set("%s_flow"%uid,data[7])
#同时更新uinfo中的套餐类型
sqlTwo = "update uinfo set tid = 2 where uid = %s"
cursor.execute(sqlTwo,uid)
mysqlconn.commit()
subject = u"套餐降级通知！！！"
text = u'''尊敬的天空视频网用户：
由于你购买的套餐或者充值流量已经到期，所以我们自动将您降级为免费用户，免费用户将有2GB/月的流量使用
和1GB的存储空间。如果您现在所有的视频文件所占用的存储空间超过1GB，我们将在7天后删除您的视频文件
到占用存储空间不超过1GB为止。
祝您使用愉快，如果您有什么建议或其他反馈请联系我们客服。
邮箱：[email protected].
'''
SendMail(Mail_list,user_email,subject,text)
elif now_month_used < -month_flow*0.1:
new_month_flow = month_flow
new_month_used_flow = total_used_flow
new_month_advance_flow = 0
is_flow_alarm = 0
is_write_redis = 1
param = (new_month_flow,new_month_used_flow,new_month_advance_flow,is_flow_alarm,uid)
cursor.execute(sqlFour,param)
mysqlconn.commit()
redisconn.set("%s_flow"%uid,is_write_redis)
else:
new_month_flow = month_flow
new_month_used_flow = total_used_flow
new_month_advance_flow = 0
is_flow_alarm = 1
is_write_redis = 1
param = (new_month_flow,new_month_used_flow,new_month_advance_flow,is_flow_alarm,uid)
cursor.execute(sqlFour,param)
mysqlconn.commit()
redisconn.set("%s_flow"%uid,is_write_redis)
SendMail(Mail_list,user_email,subject2,text2)
else:
#套餐用户月初初始化
sqlFive = "update uflow set month_used_flow=%s,month_advance_flow=%s,is_flow_alarm=%s where uid =%s"
now_month_used = total_used_flow - month_flow
if now_month_used >= 0:
now_month_extr = now_month_used - month_flow
if now_month_extr > month_flow*0.1:
new_month_used_flow = month_flow
new_month_advance_flow = now_month_extr
is_flow_alarm = 1
is_write_redis = 0
SendMail(Mail_list,user_email,subject3,text3)
elif 0< now_month_extr <= month_flow*0.1:
new_month_used_flow = month_flow
new_month_advance_flow = now_month_extr
is_flow_alarm = 1
is_write_redis = 1
SendMail(Mail_list,user_email,subject2,text2)
elif -month_flow*0.1 < now_month_extr <=0 :
new_month_used_flow = now_month_used
new_month_advance_flow = 0
is_flow_alarm = 1
is_write_redis = 1
SendMail(Mail_list,user_email,subject2,text2)
else:
new_month_used_flow = now_month_used
new_month_advance_flow = 0
is_flow_alarm = 0
is_write_redis = 1
else:
new_month_used_flow = 0
new_month_advance_flow = 0
is_flow_alarm = 0
is_write_redis = 1
print new_month_used_flow,new_month_advance_flow,is_flow_alarm,is_write_redis
param = (new_month_used_flow,new_month_advance_flow,is_flow_alarm,uid)
cursor.execute(sqlFive,param)
mysqlconn.commit()
redisconn.set("%s_flow"%uid,is_write_redis)
else:
"月中"
print "in the month between beging and end method"
now_month_used = total_used_flow - month_flow
if typeid == 2 and month_count != 0:
if now_month_used >= 0:
#降级
data = fall_type(total_used_flow,month_flow,typeObj.flow)
sqlOne = "update uflow set startdate=%s,enddate=%s,month_count=%s,month_flow=%s,month_used_flow=%s,month_advance_flow=%s,is_flow_alarm=%s where uid = %s"
param = (data[0],data[1],data[2],data[3],data[4],data[5],data[6],uid)
cursor.execute(sqlOne,param)
mysqlconn.commit()
redisconn.set("%s_flow"%uid,data[7])
#同时更新uinfo中的套餐类型
sqlTwo = "update uinfo set tid = 2 where uid = %s"
cursor.execute(sqlTwo,uid)
mysqlconn.commit()
subject = u"套餐降级通知！！！"
text = u'''尊敬的天空视频网用户：
由于你购买的套餐或者充值流量已经到期，所以我们自动将您降级为免费用户，免费用户将有2GB/月的流量使用
和1GB的存储空间。如果您现在所有的视频文件所占用的存储空间超过1GB，我们将在7天后删除您的视频文件
到占用存储空间不超过1GB为止。
祝您使用愉快，如果您有什么建议或其他反馈请联系我们客服。
邮箱：[email protected].
'''
SendMail(Mail_list,user_email,subject,text)
else:
sqlSix = "update uflow set month_used_flow=%s,month_advance_flow=%s,is_flow_alarm=%s where uid =%s"
if total_used_flow > month_flow*0.9 :
new_month_used_flow = total_used_flow
new_month_advance_flow = 0
is_flow_alarm = 1
is_write_redis = 1
SendMail(Mail_list,user_email,subject2,text2)
else:
new_month_used_flow = total_used_flow
new_month_advance_flow = 0
is_flow_alarm = 0
is_write_redis = 1
param = (new_month_used_flow,new_month_advance_flow,is_flow_alarm,uid)
cursor.execute(sqlSix,param)
mysqlconn.commit()
redisconn.set("%s_flow"%uid,is_write_redis)
elif month_count == 0:
sqlSeven = "update uflow set month_used_flow=%s,month_advance_flow=%s,is_flow_alarm=%s where uid =%s"
if now_month_used >= 0:
new_month_used_flow = month_flow
new_month_advance_flow = now_month_used
is_flow_alarm = 1
is_write_redis = 0
SendMail(Mail_list,user_email,subject3,text3)
elif now_month_used < -month_flow*0.1:
new_month_used_flow = total_used_flow
new_month_advance_flow = 0
is_flow_alarm = 0
is_write_redis = 1
else:
new_month_used_flow = total_used_flow
new_month_advance_flow = 0
is_flow_alarm = 1
is_write_redis = 1
SendMail(Mail_list,user_email,subject2,text2)
param = (new_month_used_flow,new_month_advance_flow,is_flow_alarm,uid)
cursor.execute(sqlSeven,param)
mysqlconn.commit()
redisconn.set("%s_flow"%uid,is_write_redis)
else:
sqlEight = "update uflow set month_used_flow=%s,month_advance_flow=%s,is_flow_alarm=%s where uid =%s"
if now_month_used > month_flow*0.1:
new_month_used_flow = month_flow
new_month_advance_flow = now_month_used
is_flow_alarm = 1
is_write_redis = 0
SendMail(Mail_list,user_email,subject3,text3)
elif 0 < now_month_used <= month_flow*0.1:
new_month_used_flow = month_flow
new_month_advance_flow = now_month_used
is_flow_alarm = 1
is_write_redis = 1
SendMail(Mail_list,user_email,subject2,text2)
elif -month_flow*0.1 < now_month_used <=0:
new_month_used_flow = total_used_flow
new_month_advance_flow = 0
is_flow_alarm = 1
is_write_redis = 1
SendMail(Mail_list,user_email,subject2,text2)
else:
new_month_used_flow = total_used_flow
new_month_advance_flow = 0
is_flow_alarm = 0
is_write_redis = 1
param = (new_month_used_flow,new_month_advance_flow,is_flow_alarm,uid)
cursor.execute(sqlEight,param)
mysqlconn.commit()
redisconn.set("%s_flow"%uid,is_write_redis)
