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,
