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