def AddNumber(self,num,state):
"""添加一个礼品记录
"""
number = Market_number()
number.number = num
number.state = state
operation_session.add(number)
try:
operation_session.commit()
except:
operation_session.rollback()
raise
def AddChannelMarket(self,applyuser,channel,spent_fee):
market = ChannelMarketlogs()
market.applyuser = applyuser
market.channel = channel
market.spent_fee = spent_fee
market.date = datetime.now()
market.type = type
operation_session.add(market)
try:
operation_session.commit()
except:
operation_session.rollback()
raise
def AdddepartmentMarket(self,applyuser,departmentid,spent_fee,type):
try:
market = DepartmentMarketlogs()
market.applyuser = applyuser
market.departmentid = departmentid
market.spent_fee = spent_fee
market.date = datetime.now()
market.type = type
operation_session.add(market)
operation_session.commit()
except:
operation_session.rollback()
raise
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 addadminlogs(self, **kwargs):
"""新增系统日志信息"""
from eisoo.mpsource.interfaces import IUserLocator
locator = getUtility(IUserLocator)
if locator.IsUser(kwargs['username']):
adminlogs = Adminlogs()
adminlogs.username = kwargs['username']
adminlogs.rolename = kwargs['rolename']
adminlogs.levelname = kwargs['levelname']
adminlogs.elevelname = kwargs['elevelname']
adminlogs.description = kwargs['description']
adminlogs.date = kwargs['date']
try:
operation_session.add(adminlogs)
operation_session.commit()
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
