#!/usr/bin/env python # -*- coding: utf-8 -*- import datetime import os import traceback import simplejson as json from django.core import serializers from django.core.files.storage import FileSystemStorage from django.http import HttpResponse from django.utils import timezone from django.utils.decorators import method_decorator from django.views.decorators.csrf import csrf_exempt from django.views.generic import TemplateView, View from Ansjer.config import SERVER_DOMAIN from Ansjer.settings import BASE_DIR from Model.models import Role, Device_User from Object.ResponseObject import ResponseObject from Object.TokenObject import TokenObject from Service.CommonService import CommonService from Service.ModelService import ModelService # http://192.168.136.40:8077/account/showUserMore?token=test class showUserMoreView(TemplateView): @method_decorator(csrf_exempt) def dispatch(self, *args, **kwargs): return super(showUserMoreView, self).dispatch(*args, **kwargs) def post(self, request, *args, **kwargs): request.encoding = 'utf-8' token = request.POST.get('token', None) return self.ValidationError(token) def get(self, request, *args, **kwargs): request.encoding = 'gb2312' token = request.GET.get('token', None) return self.ValidationError(token) def ValidationError(self, token): response = ResponseObject() if token is not None: tko = TokenObject(token) tko.valid() response.lang = tko.lang if tko.code == 0: userID = tko.userID if userID: return self.showUserMore(userID, response) else: return response.json(309) else: return response.json(tko.code) else: return response.json(800) def showUserMore(self, userID, response): try: User = Device_User.objects.filter(userID=userID) except Exception as e: errorInfo = traceback.format_exc() print('Query Database Error: %s' % errorInfo) return response.json(500, repr(e)) else: if User: sqlJSON = serializers.serialize('json', User) sqlList = json.loads(sqlJSON) sqlDict = dict(zip(["datas"], [sqlList])) for k, v in enumerate(sqlDict["datas"]): sqlDict['datas'][k]['fields'].pop('password') userIconPath = sqlDict['datas'][k]['fields']['userIconPath'] if userIconPath: if userIconPath.find('static/') != -1: userIconPath = userIconPath.replace('static/', '').replace('\\', '/') userIconUrl = SERVER_DOMAIN + '/account/getAvatar/' + userIconPath sqlDict['datas'][k]['fields']['userIconUrl'] = userIconUrl if len(v['fields']['role']): roleName = ModelService.getRole(rid=v['fields']['role'][0]) sqlDict["datas"][k]['fields']['rolename'] = roleName return response.json(0, sqlDict) else: return response.json(113) # http://192.168.136.40:8077/account/perfectUserInfo?token=test&content={"NickName":"333"} class perfectUserInfoView(TemplateView): # 完善个人信息 @method_decorator(csrf_exempt) def dispatch(self, *args, **kwargs): return super(perfectUserInfoView, self).dispatch(*args, **kwargs) def post(self, request, *args, **kwargs): request.encoding = 'utf-8' userContent = request.POST.get('content', None) userIcon = request.FILES.get('userIcon', None) token = request.POST.get('token', None) return self.ValidationError(token, userContent, userIcon) def get(self, request, *args, **kwargs): request.encoding = 'gb2312' userContent = request.GET.get('content', None) userIcon = request.FILES.get('userIcon', None) token = request.GET.get('token', None) return self.ValidationError(token, userContent, userIcon) def ValidationError(self, token, userContent, userIcon): response = ResponseObject() if token is not None: tko = TokenObject(token) tko.valid() response.lang = tko.lang if tko.code == 0: userID = tko.userID if userID: if userIcon != None: # location = 'static/User/Images/' + userID[-11:] + '/' location = 'static/User/Images/' + userID + '/' fss = FileSystemStorage(location=location) if fss.exists(userIcon.name): fss.delete(userIcon.name) filename = fss.save(userIcon.name, userIcon) userIconUrl = fss.url(filename) userIconPath = fss.path(filename).replace('\\', '/') else: userIconPath = None if userContent != None: dataValid = json.loads(userContent) print('userID' and 'password' and 'is_superuser' in dataValid.keys()) if 'userID' and 'password' and 'is_superuser' in dataValid.keys(): return response.json(802) if userIconPath == None and userContent == None: return response.json(800) elif userIconPath == None and userContent != None: return self.perfectUserInfoUpdate(userID, response, userContent=userContent) elif userIconPath != None and userContent == None: return self.perfectUserInfoUpdate(userID, response, userIconPath=userIconPath) else: return self.perfectUserInfoUpdate(userID, response, userIconPath=userIconPath, userContent=userContent) else: return response.json(309) else: return response.json(tko.code) else: return response.json(800) def perfectUserInfoUpdate(slef, userID, response, *args, **kwargs): """ :param username: :param userContent: :param args: :param kwargs: :return: """ try: User = Device_User.objects.filter(userID=userID) except Exception as e: errorInfo = traceback.format_exc() print('查询数据库失败: %s ' % errorInfo) return response.json(500, repr(e)) else: if User: userIconPath = kwargs.get('userIconPath', None) userContent = kwargs.get('userContent', None) if userIconPath is not None: userIconPath = userIconPath[userIconPath.find('static/'):] userIconUrl = SERVER_DOMAIN + '/account/getAvatar/' + userIconPath[7:] if userContent != None: try: UserData = json.loads(userContent) except Exception as e: return response.json(803, repr(e)) try: if userIconPath is not None and userContent is not None: User.update(userIconPath=userIconPath, userIconUrl=userIconUrl, **UserData) elif userIconPath is None and userContent is not None: User.update(**UserData) elif userIconPath is not None and userContent is None: User.update(userIconPath=userIconPath, userIconUrl=userIconUrl) except Exception as e: errorInfo = traceback.format_exc() print('修改设备信息错误: %s ' % errorInfo) return response.json(116, repr(e)) else: sqlJSON = serializers.serialize('json', User) sqlList = json.loads(sqlJSON) print(sqlList, sqlJSON) sqlDict = dict(zip(["datas"], [sqlList])) return response.json(0, sqlDict) else: return response.json(113) class getAvatarView(TemplateView): @method_decorator(csrf_exempt) def dispatch(self, *args, **kwargs): return super(getAvatarView, self).dispatch(*args, **kwargs) def post(self, request, *args, **kwargs): request.encoding = 'utf-8' filePath = kwargs.get('filePath', '') filePath.encode(encoding='utf-8', errors='strict') return self.getAvatar(filePath) def get(self, request, *args, **kwargs): request.encoding = 'gb2312' filePath = kwargs.get('filePath', '') filePath.encode(encoding='gb2312', errors='strict') return self.getAvatar(filePath) def getAvatar(self, filePath): response = ResponseObject() if filePath == '' or filePath == None: return response.json(800) fullPath = os.path.join(BASE_DIR, "static", filePath).replace('\\', '/') if os.path.isfile(fullPath): try: Imagedata = open(fullPath, 'rb').read() return HttpResponse(Imagedata, content_type="image/jpeg") except Exception as e: return response.json(906, repr(e)) else: return response.json(907) @csrf_exempt def delUserInterface(request): if request.method == 'POST': delUserID = request.POST.get('delUserID', None) token = request.POST.get('token', None) elif request.method == 'GET': delUserID = request.GET.get('delUserID', None) token = request.GET.get('token', None) response = ResponseObject() if token is not None and delUserID is not None: tko = TokenObject(token) tko.valid() response.lang = tko.lang if tko.code == 0: userID = tko.userID if userID: try: userValid = Device_User.objects.filter(userID=userID) except Exception as e: errorInfo = traceback.format_exc() print('Query Database Error: %s' % errorInfo) return response.json(500, repr(e)) else: if userValid: own_perm = ModelService.check_permission(userID=userID, permID=10) if userValid[0].is_superuser == 100 or own_perm is True: try: delUser = Device_User.objects.filter(userID=delUserID) except Exception as e: errorInfo = traceback.format_exc() print('Query database error: %s' % errorInfo) return response.json(500, repr(e)) else: if delUser: try: delUser.delete() except Exception as e: errorInfo = traceback.format_exc() print('Query database error: %s' % errorInfo) return response.json(114, repr(e)) else: return response.json(0) else: return response.json(115) else: return response.json(601) else: return response.json(113) else: return response.json(309) else: return response.json(tko.code) else: return response.json(800) def showAllUserPC(userID, line, page, response): try: userValid = Device_User.objects.filter(userID=userID).order_by('-data_joined') except Exception as e: errorInfo = traceback.format_exc() print('Query Database Error:%s' % errorInfo) return response.json(500, repr(e)) else: if userValid: # 管理员查询 own_permission = ModelService.check_permission(userID=userID, permID=30) if own_permission is True: device_user_queryset = Device_User.objects.all() device_user_count = device_user_queryset.count() device_user_res = device_user_queryset.order_by('-data_joined')[(page - 1) * line:page * line] sqlDict = CommonService.qs_to_dict(device_user_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 device_user_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'] = device_user_count return response.json(0, sqlDict) else: return response.json(612) else: return response.json(113) def showAllUser(userID, response): try: userValid = Device_User.objects.filter(userID=userID).order_by('-data_joined') except Exception as e: errorInfo = traceback.format_exc() print('Query Database Error:%s' % errorInfo) return response.json(500, repr(e)) else: if userValid: own_permission = ModelService.check_permission(userID=userID, permID=30) if own_permission is True: sqlJSON = serializers.serialize('json', Device_User.objects.all().order_by('-data_joined')) sqlList = json.loads(sqlJSON) print(sqlList, sqlJSON) sqlDict = dict(zip(["datas"], [sqlList])) return response.json(0, sqlDict) else: return response.json(612) else: return response.json(113) @csrf_exempt def showAllUserInterface(request): if request.method == 'POST': token = request.POST.get('token', None) type = request.POST.get('type', None) elif request.method == 'GET': token = request.GET.get('token', None) type = request.GET.get('type', None) response = ResponseObject() if token is not None: tko = TokenObject(token) tko.valid() response.lang = tko.lang if tko.code == 0: userID = tko.userID if userID: if type == 'PC': line = int(request.POST.get('line', None)) page = int(request.POST.get('page', None)) return showAllUserPC(userID, line, page, response) else: return showAllUser(userID, response) else: return response.json(309) else: return response.json(tko.code) else: return response.json(800) class setUserValidView(View): @method_decorator(csrf_exempt) def dispatch(self, *args, **kwargs): return super(setUserValidView, self).dispatch(*args, **kwargs) def post(self, request, *args, **kwargs): request.encoding = 'utf-8' token = request.POST.get('token', None) eUserID = request.POST.get('userID', None) isValid = request.POST.get('isValid', None) rid = request.POST.get('rid', None) return self.setUserValid(token, eUserID, isValid, rid) def get(self, request, *args, **kwargs): request.encoding = 'gb2312' token = request.GET.get('token', None) eUserID = request.GET.get('userID', None) isValid = request.GET.get('isValid', None) rid = request.GET.get('rid', None) return self.setUserValid(token, eUserID, isValid, rid) def setUserValid(self, token, eUserID, isValid, rid, *args, **kwargs): response = ResponseObject() if token is not None: tko = TokenObject(token) tko.valid() response.lang = tko.lang if tko.code == 0: superID = tko.userID if superID != None and superID != eUserID: if rid == None: return self.UserValidUpdate(superID, eUserID, isValid, response) else: return self.UserValidUpdatePC(superID, eUserID, isValid, rid, response) else: return response.json(150) else: return response.json(tko.code) else: return response.json(800) def UserValidUpdatePC(self, superID, eUserID, isValid, rid, response): try: super = Device_User.objects.filter(userID=superID) eUser = Device_User.objects.filter(userID=eUserID) except Exception as e: errorInfo = traceback.format_exc() print('查询数据库错误: %s' % errorInfo) return response.json(500, repr(e)) else: if not super: return response.json(615) if not eUser: return response.json(616) own_permission = ModelService.check_permission(userID=superID, permID=50) if own_permission is True: try: eUser.update(user_isValid=isValid) device_user_query_set = Device_User.objects.get(userID=eUserID) if device_user_query_set.role.all(): device_user_query_set.role.set([rid]) else: role_user_query_set = Role.objects.get(rid=rid) device_user_query_set.role.add(role_user_query_set) except Exception as e: errorInfo = traceback.format_exc() print('更新数据库错误:%s' % errorInfo) return response.json(501, repr(e)) else: return response.json(0) else: return response.json(602) def UserValidUpdate(self, superID, eUserID, isValid, response): try: super = Device_User.objects.filter(userID=superID) eUser = Device_User.objects.filter(userID=eUserID) except Exception as e: errorInfo = traceback.format_exc() print('查询数据库错误: %s' % errorInfo) return response.json(500, repr(e)) if not super: return response.json(113) if not eUser: return response.json(113) if super[0].is_superuser != 100 or super[0].is_superuser == eUser[0].is_superuser: return response.json(602) try: updateCount = eUser.update(user_isValid=isValid) except Exception as e: errorInfo = traceback.format_exc() print('更新数据库错误: %s' % errorInfo) return response.json(501, repr(e)) return response.json(0) @csrf_exempt def success(request): return HttpResponse(status=200)