# -*- coding: utf-8 -*- from django.views.decorators.csrf import csrf_exempt from django.views.generic import TemplateView from django.utils.decorators import method_decorator from django.contrib.auth.hashers import make_password # 对密码加密模块 from Model.models import Device_Info,Role from Service.ModelService import ModelService from django.utils import timezone from Model.models import Access_Log,Device_User from django.views.decorators.http import require_http_methods from Object.ResponseObject import ResponseObject from Object.TokenObject import TokenObject from Ansjer.config import OFF_LINE_TIME_DELTA import datetime,simplejson as json from Service.CommonService import CommonService ''' http://192.168.136.40:8077/adminManage/manage?operation=getAllDeviceArea&token=debug http://192.168.136.40:8077/adminManage/manage?operation=getAllUserName&token=debug http://192.168.136.40:8077/adminManage/manage?operation=getAllUID&token=debug http://127.0.0.1:8000/adminManage/manage?operation=getAllOnLine&token=stest http://127.0.0.1:8000/adminManage/manage?operation=getOnLine&token=stest ''' class AdminManage(TemplateView): @method_decorator(csrf_exempt) def dispatch(self, *args, **kwargs): return super(AdminManage, self).dispatch(*args, **kwargs) def get(self, request, *args, **kwargs): request.encoding = 'utf-8' return self.validation(request_dict=request.GET) def post(self, request, *args, **kwargs): request.encoding = 'utf-8' return self.validation(request_dict=request.POST) def validation(self, request_dict, *args, **kwargs): response = ResponseObject() token = request_dict.get('token', None) if token is not None: tko = TokenObject(token) tko.valid() response.lang = tko.lang if tko.code == 0: userID = tko.userID operation = request_dict.get('operation', None) if userID is not None and operation is not None: if operation == 'resetUserPwd': return self.resetUserPwd(request_dict,userID,response) if operation == 'getAllOnLine': return self.getAllOnLine(userID,response) if operation == 'getOnLine': return self.getOnLine(userID,response) if operation == 'getAllUserName': return self.getAllUserName(userID,response) if operation == 'getStatisAccess': return self.getStatisAccess(userID,request_dict,response) if operation == 'getAllUID': return self.getAllUID(userID,response) if operation == 'getAllDeviceArea': return self.getAllDeviceArea(userID,response) else: return response.json(444,'operation') else: return response.json(tko.code) else: return response.json(309) def resetUserPwd(self, request_dict, userID,response): own_permission = ModelService.check_permission(userID=userID, permID=50) if own_permission: duserID = request_dict.get('duserID', None) userPwd = request_dict.get('userPwd', None) if duserID: UserValid = Device_User.objects.filter(userID=duserID) if UserValid: if userPwd is None: userPwd = '123456' is_update = UserValid.update(password=make_password(userPwd)) if is_update: return response.json(0) else: return response.json(106) else: return response.json(444,'duserID') else: return response.json(404) def getAllUserName(self, userID,response): # 权限固定为30 own_permission = ModelService.check_permission(userID=userID, permID=30) if own_permission is True: username_list = Device_User.objects.all().values_list('username', flat=True) if username_list: return response.json(0,{'username_list': list(username_list)}) else: return response.json(0) else: return response.json(404) # 获取全部用户的在线个数 def getAllOnLine(self, userID,response): # 权限固定为30 own_permission = ModelService.check_permission(userID=userID, permID=30) if own_permission is True: allonline = Device_User.objects.all().values('online') # 两个变量,分别是在线,离线 onlinenum = 0 noonlinenum=0 for q in allonline: if q['online'] ==True: onlinenum+=1 else: noonlinenum+=1 print("在线人数:") print(onlinenum) return response.json(0, {"onlinenum": onlinenum, "no_onlinenum": noonlinenum}) else: return response.json(404) # 获取全部用户的在线人数 def getOnLine(self, userID,response): # 权限固定为30 own_permission = ModelService.check_permission(userID=userID, permID=30) if own_permission is True: online_list = Device_User.objects.all().values('online', 'last_login') # 两个变量,分别是在线,离线 onlinenum=0 noonlinenum=0 for q in online_list: # print(q['last_login'] ) # 最后访问时间加5分种 dl_time = q['last_login'] + datetime.timedelta(minutes=OFF_LINE_TIME_DELTA) # print(dl_time) # 当前时间 now_time = timezone.localtime(timezone.now()) # print(now_time) # 如果当前时间大于最后访问的时间 if now_time < dl_time: onlinenum += 1 else: noonlinenum += 1 print("在线人") print(onlinenum) return response.json(0, {"onlinenum": onlinenum,"no_onlinenum": noonlinenum}) else: return response.json(404) # 获取所有设备地区 def getAllDeviceArea(self, userID,response): own_permission = ModelService.check_permission(userID=userID, permID=30) if own_permission is True: qs = Device_Info.objects.all().values('area','UID') uid_area_dict = {} for q in qs: if q['UID'] and q['area']: uid_area_dict[q['UID']]=q['area'] if len(uid_area_dict): area_dict = {} for k,v in uid_area_dict.items(): if v in area_dict: area_dict[v] += 1 else: area_dict[v] = 1 return response.json(0,{'area':area_dict}) else: return response.json(0) else: return response.json(404) ''' 统计一天访问量 http://192.168.136.45:8077/adminManage/manage?token=test&operation=getStatisAccess×tamp=1528773308 ''' def getStatisAccess(self,userID,request_dict,response): own_permission = ModelService.check_permission(userID=userID, permID=30) if own_permission is True: time_stamp = int(request_dict.get('timestamp', None)) times = datetime.datetime.fromtimestamp(time_stamp) time_dict = CommonService.getTimeDict(times) res = {} for k, v in time_dict.items(): start_date = time_dict[k] end_date = time_dict[k] + datetime.timedelta(hours=1) count = Access_Log.objects.filter(time__range=(start_date, end_date)).count() if count: res[k] = count else: res[k] = 0 return response.json(0, {'count': res}) else: return response.json(404) def getAllUID(self,userID,response): own_permission = ModelService.check_permission(userID=userID, permID=30) if own_permission is True: uid_list = Device_Info.objects.all().values_list('UID', flat=True) if uid_list: return response.json(0, {'count': len(uid_list),'uid_list':list(uid_list)}) else: return response.json(404) @require_http_methods(["GET"]) def getUserIds(request): token = request.GET.get('token', None) response = ResponseObject() if token is not None: tko = TokenObject(token) tko.valid() response.lang = tko.lang if tko.code == 0: userID = tko.userID own_perm = ModelService.check_permission(userID,30) if own_perm is True: # userID_list = Device_User.objects.all().values_list('userID', flat=True) dn = Device_User.objects.all().values('userID', 'username') return response.json(0,{"datas":list(dn)}) else: return response.json(404) else: return response.json(tko.code) else: return response.json(309) @csrf_exempt def search_user_by_content(request): if request.method == 'GET': request_dict = request.GET if request.method == 'POST': request_dict = request.POST token = request_dict.get('token', None) page = request_dict.get('page', None) line = request_dict.get('line', None) content = request_dict.get('content', None) rstime = request_dict.get('rstime', None) retime = request_dict.get('retime', None) response = ResponseObject() if page is not None and line is not None: page = int(page) line = int(line) else: return response.json(10,'page,line is none') if token is not None: tko = TokenObject(token) tko.valid() response.lang = tko.lang if tko.code == 0: userID = tko.userID own_perm = ModelService.check_permission(userID,30) if own_perm is True: check_perm = ModelService.check_permission(userID=userID, permID=20) if check_perm is True: try: content = json.loads(content) search_kwargs = CommonService.get_kwargs(data=content) queryset = Device_User.objects.filter(**search_kwargs) except Exception as e: return response.json(444,repr(e)) if rstime is not None and rstime != '' and retime is not None and retime != '': startt = datetime.datetime.fromtimestamp(int(rstime)) rstime = startt.strftime("%Y-%m-%d %H:%M:%S.%f") endt = datetime.datetime.fromtimestamp(int(retime)) retime = endt.strftime("%Y-%m-%d %H:%M:%S.%f") queryset = queryset.filter(data_joined__range=(rstime, retime)) elif rstime is not None and rstime != '': startt = datetime.datetime.fromtimestamp(int(rstime)) rstime = startt.strftime("%Y-%m-%d %H:%M:%S.%f") queryset = queryset.filter(data_joined__gte=rstime) elif retime is not None and retime != '': endt = datetime.datetime.fromtimestamp(int(retime)) retime = endt.strftime("%Y-%m-%d %H:%M:%S.%f") queryset = queryset.filter(data_joined__lte=retime) if queryset.exists(): count = queryset.count() res = queryset[(page - 1) * line:page * line] sqlDict = CommonService.qs_to_dict(res) for k, v in enumerate(sqlDict["datas"]): if len(v['fields']['role']) > 0: role_query_set = Role.objects.get(rid=v['fields']['role'][0]) sqlDict["datas"][k]['fields']['role'].append(role_query_set.roleName) for val in res: if v['pk'] == val.userID: if sqlDict["datas"][k]['fields']['online'] is True: dl_time = val.last_login + datetime.timedelta(minutes=5) now_time = timezone.localtime(timezone.now()) if now_time > dl_time: sqlDict["datas"][k]['fields']['online'] = False sqlDict['count'] = count return response.json(0, sqlDict) return response.json(0, {'datas': [], 'count': 0}) else: return response.json(404) else: return response.json(404) else: return response.json(tko.code) else: return response.json(309)