def get_students_list(request): students = Student.objects.all().reverse() columnIndexNameMap = { 0: 'id', 1: 'user', 2: 'realname', 3: 'sex', 4: 'theclass', } columnNameIndexMap = dict([[v, k] for k, v in columnIndexNameMap.items()]) updatefilter = { 1: 'user__username', 4: 'theclass__classid', } extrafilters = {'sex': SEX_CHOICES} updateitems = { 1: 'user_id', 4: 'theclass_id', } try: aaData, sEcho, iTotalRecords, iTotalDisplayRecords, sColumns = get_datatables_records(request, students, columnIndexNameMap, None, extrafilters, False, updatefilter, updateitems) except Exception, e: traceback.print_stack() aaData, sEcho, iTotalRecords, iTotalDisplayRecords, sColumns = [], 1, 0, 0, ','.join(columnIndexNameMap.values())
def get_users_list(request): users = User.objects.filter() columnIndexNameMap = { 0: 'id', 1: 'username', 2: 'is_superuser', 3: 'email', 4: 'date_joined', 5: 'last_login', } columnNameIndexMap = dict([[v, k] for k, v in columnIndexNameMap.items()]) updatefilter = { 1: 'username', 2: 'is_superuser', } extrafilters = {'is_superuser': SUPERUSER_CHOISE} updateitems = { 1: 'username', 2: 'is_superuser', } try: aaData, sEcho, iTotalRecords, iTotalDisplayRecords, sColumns = get_datatables_records( request, users, columnIndexNameMap, None, extrafilters, False, updatefilter, updateitems) except Exception, e: traceback.print_stack() aaData, sEcho, iTotalRecords, iTotalDisplayRecords, sColumns = [], 1, 0, 0, ','.join( columnIndexNameMap.values())
def get_alarm_list(request): starttime = time.time() columnIndexNameMap = { 0: 'id', 1:'autoid', 2: 'user_id', 3: 'riskvalue', 4: 'blackdata', 5: 'isfigured', 6: 'insert_time', } columnNameIndexMap = dict([[v,k] for k,v in columnIndexNameMap.items()]) filterdict = dict() if User.objects.get(username = request.user).is_superuser == False: userinfo = Userinfo.objects.get(user=request.user) filterdict["user_id"] =ObjectId(userinfo.id) try: aaData,sEcho,iTotalRecords,iTotalDisplayRecords,sColumns = get_datatables_records(request, AlarmList, columnIndexNameMap, None, filterdict, True, 'insert_time') except Exception,e: traceback.print_exc() aaData,sEcho,iTotalRecords,iTotalDisplayRecords,sColumns = [],1,0,0,columnIndexNameMap.values()
def get_user_list(request): filterdict = dict() filterdict["ifverify"] = True columnIndexNameMap = { 0: 'autoid', 1: 'user_id', 2: 'id', 3: 'realname', 4: 'regtime', 5: 'address', 6: 'mobile', 7: 'email', 8: 'dlcertificate', } columnNameIndexMap = dict([[v,k] for k,v in columnIndexNameMap.items()]) try: aaData,sEcho,iTotalRecords,iTotalDisplayRecords,sColumns = get_datatables_records(request, Userinfo, columnIndexNameMap, None, filterdict, True, 'regtime') except Exception,e: traceback.print_exc() aaData,sEcho,iTotalRecords,iTotalDisplayRecords,sColumns = [],1,0,0,columnIndexNameMap.values()
def ajaxcomperformance_setup(request): comperformances = Comperformance.objects.all().order_by('term') columnIndexNameMap = { 0: 'id', 1: 'term', 2: 'moral', 3: 'behaviorup', 4: 'physical', 5: 'excellent', 6: 'good', 7: 'ordinary', 8: 'development', 9: 'behavior', } try: aaData, sEcho, iTotalRecords, iTotalDisplayRecords, sColumns = get_datatables_records( request, comperformances, columnIndexNameMap, None, {}, False, {}, {}) except Exception, e: traceback.print_stack() traceback.print_exc() print e aaData, sEcho, iTotalRecords, iTotalDisplayRecords, sColumns = [], 1, 0, 0, ','.join( columnIndexNameMap.values())
def get_users_list(request): users = User.objects.filter() columnIndexNameMap = { 0:'id', 1:'username', 2:'is_superuser', 3:'email', 4:'date_joined', 5:'last_login', } columnNameIndexMap = dict([[v,k] for k,v in columnIndexNameMap.items()]) updatefilter = { 1:'username', 2:'is_superuser', } extrafilters = {'is_superuser':SUPERUSER_CHOISE} updateitems = { 1:'username', 2:'is_superuser', } try: aaData,sEcho,iTotalRecords,iTotalDisplayRecords,sColumns = get_datatables_records(request, users, columnIndexNameMap,None,extrafilters,False,updatefilter,updateitems) except Exception,e: traceback.print_stack() aaData,sEcho,iTotalRecords,iTotalDisplayRecords,sColumns = [],1,0,0,','.join(columnIndexNameMap.values())
def get_driver_behaviour_list(request): filterdict = dict() if User.objects.get(username = request.user).is_superuser == False: userinfo = Userinfo.objects.get(user = request.user) filterdict["user_id"] = ObjectId(userinfo.id) # riskdict=dict() # riskdict["$ne"] = -1 # filterdict["riskvalue"] = riskdict # if request.GET.get('riskvalue',False): # try: # filterdict["riskvalue"] = int(request.GET.get('riskvalue',False)) # except Exception,e: # riskdict["$ne"] = -1 # filterdict["riskvalue"] = riskdict # if request.GET.get('blackiptype',False) > '': # for i in request.GET.get('blackiptype').split(','): # if i in dict(TYPE_CHOICES).keys(): # filterdict["iptype"] = i # timeQ = None # timedict = dict() # if request.GET.get('begintime',False): # try: # timedict["$gt"]=datetime.datetime.strptime(request.GET.get('begintime'),'%Y-%m-%d') # except Exception,e: # traceback.print_exc() # if request.GET.get('endtime',False): # try: # timedict["$lt"] = datetime.datetime.strptime(request.GET.get('endtime'),'%Y-%m-%d') # except Exception,e: # timedict["$lt"] = datetime.datetime.now() # if timedict:filterdict["addtime"] = timedict columnIndexNameMap = { 0: 'id', 1: 'autoid', 2: 'user_id', 3: 'driver', 4: 'dritype', 5: 'program', 6: 'flow', 7: 'commnum', 8: 'smscontent', 9: 'datetime', 10: 'riskvalue', } columnNameIndexMap = dict([[v,k] for k,v in columnIndexNameMap.items()])#将columnIndexNameMap的key,value对调 try: aaData,sEcho,iTotalRecords,iTotalDisplayRecords,sColumns = get_datatables_records(request, DriverBehaviour, columnIndexNameMap,None,filterdict,True,'datetime') except Exception,e: traceback.print_exc() aaData,sEcho,iTotalRecords,iTotalDisplayRecords,sColumns = [],1,0,0,columnIndexNameMap.values()
def ajaxdevelopment(request): developments = Development.objects.all().reverse() columnIndexNameMap = {0: 'id', 1: 'parent', 2: 'name'} try: aaData, sEcho, iTotalRecords, iTotalDisplayRecords, sColumns = get_datatables_records( request, developments, columnIndexNameMap, None, {}, False, {}, {}) except Exception, e: traceback.print_stack() traceback.print_exc() print e aaData, sEcho, iTotalRecords, iTotalDisplayRecords, sColumns = [], 1, 0, 0, ','.join( columnIndexNameMap.values())
def get_classes_list(request): classes = Class.objects.all().reverse() columnIndexNameMap = { 0: 'id', 1: 'classid', 2: 'classname', } try: aaData, sEcho, iTotalRecords, iTotalDisplayRecords, sColumns = get_datatables_records(request, classes, columnIndexNameMap, None, {}, False, {}, {}) except Exception, e: traceback.print_stack() aaData, sEcho, iTotalRecords, iTotalDisplayRecords, sColumns = [], 1, 0, 0, ','.join(columnIndexNameMap.values())
def get_classes_list(request): classes = Class.objects.all().reverse() columnIndexNameMap = { 0:'id', 1:'classid', 2:'classname', } try: aaData,sEcho,iTotalRecords,iTotalDisplayRecords,sColumns = get_datatables_records(request, classes, columnIndexNameMap,None,{},False,{},{}) except Exception,e: traceback.print_stack() aaData,sEcho,iTotalRecords,iTotalDisplayRecords,sColumns = [],1,0,0,','.join(columnIndexNameMap.values())
def ajaxdevelopment(request): developments = Development.objects.all().reverse() columnIndexNameMap = { 0: 'id', 1: 'parent', 2: 'name' } try: aaData, sEcho, iTotalRecords, iTotalDisplayRecords, sColumns = get_datatables_records(request, developments, columnIndexNameMap, None, {}, False, {}, {}) except Exception, e: traceback.print_stack() traceback.print_exc() print e aaData, sEcho, iTotalRecords, iTotalDisplayRecords, sColumns = [], 1, 0, 0, ','.join(columnIndexNameMap.values())
def ajaxbehavior(request): behaviors = Behavior.objects.all().reverse() columnIndexNameMap = { 0:'id', 1:'actlevel', 2:'name', } try: aaData,sEcho,iTotalRecords,iTotalDisplayRecords,sColumns = get_datatables_records(request, behaviors, columnIndexNameMap,None,{},False,{},{}) except Exception,e: traceback.print_stack() traceback.print_exc() print e aaData,sEcho,iTotalRecords,iTotalDisplayRecords,sColumns = [],1,0,0,','.join(columnIndexNameMap.values())
def get_assessments_list(request): assessments = Assessment.objects.all().reverse() columnIndexNameMap = { 0:'id', 1:'term', 2:'begindate', 3:'enddate', 4:'excellent', 5:'good', 6:'ordinary', } try: aaData,sEcho,iTotalRecords,iTotalDisplayRecords,sColumns = get_datatables_records(request, assessments, columnIndexNameMap,None,{},False,{},{}) except Exception,e: traceback.print_stack() aaData,sEcho,iTotalRecords,iTotalDisplayRecords,sColumns = [],1,0,0,','.join(columnIndexNameMap.values())
def get_white_ip_list(request): filterdict = dict() if User.objects.get(username = request.user).is_superuser == False: userinfo = Userinfo.objects.get(user=request.user) filterdict["user_id"] =ObjectId(userinfo.id) columnIndexNameMap = { 0: 'id', 1: 'autoid', 2: 'ip', 3: 'addtime', } columnNameIndexMap = dict([[v,k] for k,v in columnIndexNameMap.items()])#将columnIndexNameMap的key,value对调 try: aaData,sEcho,iTotalRecords,iTotalDisplayRecords,sColumns = get_datatables_records(request, WhiteIp,columnIndexNameMap,None,filterdict,True,'addtime') except Exception,e: traceback.print_exc() aaData,sEcho,iTotalRecords,iTotalDisplayRecords,sColumns = [],1,0,0,columnIndexNameMap.values()
def get_assessments_list(request): assessments = Assessment.objects.all().reverse() columnIndexNameMap = { 0: 'id', 1: 'term', 2: 'begindate', 3: 'enddate', 4: 'excellent', 5: 'good', 6: 'ordinary', } try: aaData, sEcho, iTotalRecords, iTotalDisplayRecords, sColumns = get_datatables_records( request, assessments, columnIndexNameMap, None, {}, False, {}, {}) except Exception, e: traceback.print_stack() aaData, sEcho, iTotalRecords, iTotalDisplayRecords, sColumns = [], 1, 0, 0, ','.join( columnIndexNameMap.values())
def ajaxcomperformance_setup(request): comperformances = Comperformance.objects.all().order_by('term') columnIndexNameMap = { 0:'id', 1:'term', 2:'moral', 3:'behaviorup', 4:'physical', 5:'excellent', 6:'good', 7:'ordinary', 8:'development', 9:'behavior', } try: aaData,sEcho,iTotalRecords,iTotalDisplayRecords,sColumns = get_datatables_records(request, comperformances, columnIndexNameMap,None,{},False,{},{}) except Exception,e: traceback.print_stack() traceback.print_exc() print e aaData,sEcho,iTotalRecords,iTotalDisplayRecords,sColumns = [],1,0,0,','.join(columnIndexNameMap.values())
9: 'sendcc', 10: 'sendbcc', 11: 'subject', 12: 'sport', 13: 'dport', 14: 'addtowhite', 15: 'processname', 16: 'processmd5', } columnNameIndexMap = dict([[v,k] for k,v in columnIndexNameMap.items()]) try: aaData,sEcho,iTotalRecords,iTotalDisplayRecords,sColumns = get_datatables_records(request, ResEmail, columnIndexNameMap, None, filterdict, True, 'datetime') except Exception,e: traceback.print_exc() aaData,sEcho,iTotalRecords,iTotalDisplayRecords,sColumns = [],1,0,0,columnIndexNameMap.values() index = int(request.GET.get('iDisplayStart',0))+1 for i in aaData: i.insert(1,index) index = index+1 i[columnNameIndexMap['emailtype']] = dict(RESTYPE_CHOICES)[i[columnNameIndexMap['emailtype']]] i.append("") # i[columnNameIndexMap['user_id']] = Userinfo.objects.get(id=i[columnNameIndexMap['user_id']]).realname response_dict = {}
print "filterdict",filterdict print "test1" columnIndexNameMap = { 0: 'id', 1: 'autoid', 2: 'user_id', 3: 'processname', 4: 'md5', 5: 'description', 6: 'version', 7 : 'addtime', } columnNameIndexMap = dict([[v,k] for k,v in columnIndexNameMap.items()])#将columnIndexNameMap的key,value对调 print "test2" try: aaData,sEcho,iTotalRecords,iTotalDisplayRecords,sColumns = get_datatables_records(request, WhiteProcesss, columnIndexNameMap,None,filterdict,True,'addtime') except Exception,e: traceback.print_exc() aaData,sEcho,iTotalRecords,iTotalDisplayRecords,sColumns = [],1,0,0,columnIndexNameMap.values() index = int(request.GET.get('iDisplayStart',0))+1 print "test3" for i in aaData:#将emailtype和user_id字段在数据库中的存储和界面显示对应 i.insert(1,index) index = index +1 i[columnNameIndexMap['user_id']] = Userinfo.objects.get(id=i[columnNameIndexMap['user_id']]).realname response_dict = {} response_dict.update({'aaData':aaData}) response_dict.update({ 'sEcho': sEcho, 'iTotalRecords': iTotalRecords,