def IsNumber(self,num,state):
"""判断一个号码是否属于礼品"""
results = operation_session.query(Market_number).filter(Market_number.number==num).filter(Market_number.state==state).all()
if len(results)==0:
return True
else:
return False
def Getconditionsloginlogs(self, **kwargs):
conditions = "rolename= '" + str(kwargs['rolename']) + "'"
if kwargs['time'] != '-1':
ago = operationdate.getdayofday(-int(kwargs['time']))
conditions += " && date >= '" + str(ago.year) + "-" + str(ago.month) + "-" + str(ago.day) + "'"
if kwargs['elevelname'] != '-1':
conditions += " && elevelname = '" + str(kwargs['elevelname']) + "'"
star = kwargs['rows'] * int(kwargs['pages'])
try:
admin_logs = operation_session.query("username", "rolename", "levelname", "description", "date").from_statement("select * from admin_logs "
"where " + str(conditions) + " order by date desc limit " + str(star) + "," + str(kwargs['rows'])).all()
operation_session.commit()
return admin_logs
except:
operation_session.rollback()
raise
def GetconditionslogsCount(self, **kwargs):
"""根据指定条件返回日志个数"""
conditions = "rolename= '" + str(kwargs['rolename']) + "'"
if kwargs['time'] != '-1':
ago = operationdate.getdayofday(-int(kwargs['time']))
conditions += " && date >= '" + str(ago.year) + "-" + str(ago.month) + "-" + str(ago.day) + "'"
if kwargs['elevelname'] != '-1':
conditions += " && elevelname = '" + str(kwargs['elevelname']) + "'"
try:
admin_logs = operation_session.query("username", "rolename", "levelname", "description", "date").from_statement("select * from admin_logs "
"where " + str(conditions) + " order by date desc").all()
operation_session.commit()
return len(admin_logs)
except:
operation_session.rollback()
return 0
