基于django开发的工时管理系统后端源码+sql数据库.zip

import json from django.core import serializers from django.forms import model_to_dict from django.http import JsonResponse, HttpResponse from django.shortcuts import render from django.views.decorators.csrf import csrf_exempt from rest_framework.decorators import api_view, parser_classes from rest_framework.parsers import FormParser from app import models import datetime from datetime import date # Create your views here. def get(response): return JsonResponse({'name': 'pyt'}) def test(request): hello = ('test', 'nice to meet you') # print(request) return JsonResponse({'header': hello}) @csrf_exempt def searchUser(request): global password # print("=======================") # print(request.POST) # print("=======================") print(str(request.POST.get('account')) + " 正在登录......") user = models.Users.objects.filter(account=request.POST.get('account')) # print(user) if user.exists(): for item in user: password = model_to_dict(item).get('password') getToday() if int(request.POST.get('password')) == password: print("登录成功") for i in models.Users.objects.filter(account=request.POST.get('account')): if i.__getattribute__('type') == '0': return HttpResponse(0) elif i.__getattribute__('type') == '2': return HttpResponse(3) else: return HttpResponse(2) else: return HttpResponse(1) else: return HttpResponse(-1) def getToday(): # 获取当前日期 current_date = datetime.date.today() # 输出当前日期 # print("当前日期为：", current_date) # print("第" + str(get_week_num(str(current_date))) + "周") return str(get_week_num(str(current_date))) def get_week_num(date): date = datetime.datetime.strptime(date, '%Y-%m-%d') first_day_of_week = datetime.datetime(2023, 4, 24) week_number = ((date - first_day_of_week).days // 7) + 1 return week_number # 获取今天是第几周 @csrf_exempt def getWeekToday(request): date = '' # print(request.POST) for item in request.POST: date = item # print(getWhatWeek(date)) result = get_week_num(date) # print(result) return HttpResponse(result) @csrf_exempt def userSearchByApartment(request): all = [] # print(request.POST) result = [] for item in request.POST.values(): # print(item) result.append(models.Users.objects.filter(apartment=item)) # print(result) if not request.POST: result.append(models.Users.objects.all()) # print('this is the result:'+str(result)) peoples = [] j = 0 for i in result: # print(i.count()) for j in range(0, i.count()): leader = '' if i.values_list()[j][6] != '': for item in models.Users.objects.filter(id=i.values_list()[j][6]): leader = item.__getattribute__('name') people = {'id': i.values_list()[j][0], 'name': i.values_list()[j][2], 'department': i.values_list()[j][3], 'account': i.values_list()[j][4], 'password': i.values_list()[j][5], 'leader': leader} # print(people) peoples.append(people) leaders = [] for item in models.Users.objects.filter(type=1): leader = { 'label': item.__getattribute__('name'), 'value': item.__getattribute__('name') } leaders.append(leader) all.append(peoples) all.append(leaders) json_data = json.dumps(all) return JsonResponse(json_data, safe=False) @csrf_exempt def getMemoryByAccount(request): all = [] duration = '' status = '' data = json.loads(request.body) # print(data) # print(data.get('account')) weekToday = getToday() # print("weekToday is " + weekToday) account = data.get('account') projectId = [] userId = '' for item in models.Users.objects.filter(account=account): userId = item.__getattribute__('id') for item in models.UserToProject.objects.filter(userId=userId): projectId.append(item.__getattribute__('projectId')) for perProjectId in projectId: for i in models.Project.objects.filter(id=perProjectId): if models.Memory.objects.filter(userAccount=account, projectName=i.__getattribute__('name'), weekNumber=getToday()).exists(): for j in models.Memory.objects.filter(userAccount=account, projectName=i.__getattribute__('name'), weekNumber=getToday()): duration = j.__getattribute__('timeLength') status = j.__getattribute__('status') else: duration = 0 status = '未审核' message = { 'name': i.__getattribute__('name'), 'duration': duration, 'type': i.__getattribute__('type'), 'status': status } all.append(message) for i in models.Memory.objects.filter(userAccount=account, type='其他项目'): message = { 'name': i.__getattribute__('projectName'), 'duration': i.__getattribute__('timeLength'), 'type': i.__getattribute__('type'), 'status': i.__getattribute__('status') } all.append(message) json_data = json.dumps(all) return JsonResponse(json_data, safe=False) @csrf_exempt def newMemory(request): # print('hello') memory = json.loads(request.body) week = getToday() # print(memory) leaderId = '' for i in models.Users.objects.filter(account=memory.get('account')): leaderId = i.__getattribute__('leader') memoryNew = models.Memory(userAccount=memory.get('account'), type=memory.get('type'), timeLength=memory.get('duration'), projectName=memory.get('name'), status=memory.get('status'), weekNumber=week, submitTime=date.today(), leaderId=leaderId) print(memoryNew.save()) return HttpResponse(1) @csrf_exempt def changeMemory(request): change = json.loads(request.body) week = getToday() # print("====================================================================", change) # print(week) if models.Memory.objects.filter(userAccount=change.get('account'), projectName=change.get('name'), weekNumber=week).exists(): models.Memory.objects.filter(userAccount=change.get('account'), projectName=change.get('name'), weekNumber=week).update(timeLength=change.get('duration'), submitTime=date.today(), status='未审核') else: if change.get('type') == '其他项目': leaderId = '' for i in models.Users.objects.filter(account=change.get('account')): leaderId = i.__getattribute__('leader') models.Memory(userAccount=change.get('account'), projectName=change.get('name'), weekNumber=week, submitTime=date.today(), timeLength=change.get('duration'), type=change.get('type'), status=change.get('status'), leaderId=leaderId).save() else: leaderId = '' for i in models.Project.objects.filter(name=change.get('name')): l