EduSystem/EduSystemServer/Eduadmin/views.py

from django.shortcuts import render

# Create your views here.
from django.http import JsonResponse, HttpResponseBadRequest, HttpResponse
from teacher.models import Teacher
from django.views.decorators.csrf import csrf_exempt
from io import BytesIO
from django.http.multipartparser import MultiPartParser
from django.http import QueryDict
from course.models import Course, SC
from Student.models import Student
from django.db.models import Q
from django.db.models import Subquery, OuterRef
from django.core.exceptions import ObjectDoesNotExist
from ast import literal_eval
from MySQLdb import IntegrityError
from EduSystemServer.utils import ResponseUtil
@csrf_exempt
def teacher_manage(request): # 教师个人信息修改
    if request.method == "POST":
        username = request.POST.get('username')
        password = request.POST.get('password')
        name = request.POST.get('name')
        sex = request.POST.get('sex')
        title = request.POST.get('title')
        education = request.POST.get('education')
        dept = request.POST.get('dept')
        if (username and password and name and sex
                and title and education and dept):
            try:
                teacher = Teacher()
                teacher.username = username
                teacher.password = password
                teacher.name = name
                teacher.sex = sex
                teacher.title = title
                teacher.education = education
                teacher.dept = dept
                teacher.save()
                response = ResponseUtil.ok(teacher.to_dict(), "老师信息插入成功")
                return JsonResponse(response)
            except:
                response = ResponseUtil.error("老师信息插入未成功，用户名重复！")
                return JsonResponse(response)
        else:
            response = ResponseUtil.error("老师信息插入未成功，存在空值，请你仔细检测并上传")
            return JsonResponse(response)

    elif request.method == "GET":
        name = request.GET.get('name')
        sex = request.GET.get('sex')
        title = request.GET.get('title')
        education = request.GET.get('education')
        dept = request.GET.get('dept')
        # 定义空查询条件
        conditions = Q()
        if name:
            conditions &= Q(name=name)
        if sex:
            conditions &= Q(sex=sex)
        if title:
            conditions &= Q(title=title)
        if education:
            conditions &= Q(education=education)
        if dept:
            conditions &= Q(dept=dept)
        # 添加非空查询条件至基本查询集
        query = Teacher.objects.filter(conditions)
        data = query.values()  # 将 QuerySet 对象转换为字典列表
        data = list(data)  # 转换为列表以便序列化为 JSON
        print(query)
        response = ResponseUtil.ok(data, "老师信息查询成功")
        return JsonResponse(response)

    elif request.method == "DELETE":
        # parser = MultiPartParser(request.META, BytesIO(request.body), request.upload_handlers, request.encoding)
        # posdict = parser.parse()
        # print(posdict)
        # tid = int(posdict[0]['tid'])
        # print(tid)
        # try:
        #     info = Teacher.objects.filter(tid=tid).get().to_dict()
        #     Teacher.objects.filter(tid=tid).delete()
        #     response = ResponseUtil.ok(info, "老师信息删除成功")
        #     return JsonResponse(response)
        # except:
        #     response = ResponseUtil.error("删除失败，未找到老师信息！")
        #     return JsonResponse(response)
        parser = MultiPartParser(request.META, BytesIO(request.body), request.upload_handlers, request.encoding)
        posdict = parser.parse()
        # print(posdict)
        tids = posdict[0]['tids']
        # print(tids)
        tids = literal_eval(tids)
        # print(tids)
        try:
            info = Teacher.objects.filter(tid__in=tids).values()
            data = list(info)
            if len(data) > 0:
                Teacher.objects.filter(tid__in=tids).delete()
                response = ResponseUtil.ok(data, "老师信息删除成功")
                return JsonResponse(response)
            else:
                response = ResponseUtil.error("老师未找到")
                return JsonResponse(response)
        except:
            response = ResponseUtil.ok("未查询到老师信息，删除失败")
            return JsonResponse(response)
    elif request.method == 'PUT':
        put = MultiPartParser(request.META, request, request.upload_handlers, request.encoding).parse()
        # request.PUT = put[0]
        print(put)
        tid = put[0]['tid']
        name = put[0]['name']
        sex = put[0]['sex']
        title = put[0]['title']
        education = put[0]['education']
        dept = put[0]['dept']
        if name and sex and title and education and dept:
            Teacher.objects.filter(tid=tid).update(name=name,sex=sex,title=title)
            Teacher.objects.filter(tid=tid).update(education=education,dept=dept)
            data = Teacher.objects.filter(tid=tid)[0].to_dict()
            response = ResponseUtil.ok(data, "修改老师信息成功！")
            return JsonResponse(response)
        else:
            response = ResponseUtil.error("修改信息有误！")
            return JsonResponse(response)

@csrf_exempt
def course_selection(request): # 选课管理
    if request.method == 'POST':
        # 假设需要将 tid 为 1 的老师赋值给某个课程的 tid 字段
        teacher_id = request.POST.get('tid')
        name = request.POST.get('name')
        type = request.POST.get('type')
        credit = request.POST.get('credit')
        if name and type and credit:
            try:
                teacher_id = int(teacher_id)
                course = Course()
                course.name = name
                course.type = type
                course.credit = int(credit)
                course.tid = Teacher.objects.get(tid=teacher_id)  # 将 Teacher 对象赋给 Course.tid 字段
                course.save()
                response = ResponseUtil.ok(course.tid_dict(), "课程信息插入成功")
                return JsonResponse(response)
            except ObjectDoesNotExist:
                response = ResponseUtil.error("找不到 id 为 " + str(teacher_id)+" 的老师")
                return JsonResponse(response)
            except ValueError:
                response = ResponseUtil.error("插入数据失败: tid_id 列不能为 null")
                return JsonResponse(response)
    if request.method == 'GET':
        cid = request.GET.get('cid')
        name = request.GET.get('name')
        type = request.GET.get('type')
        credit = request.GET.get('credit')
        tid = request.GET.get('tid')
        # 定义空查询条件
        conditions = Q()
        if cid:
            conditions &= Q(cid=int(cid))
        if name:
            conditions &= Q(name=name)
        if type:
            conditions &= Q(type=type)
        if credit:
            conditions &= Q(credit=credit)
        if tid:
            tid = int(tid)
            conditions &= Q(tid=tid)
        # 添加非空查询条件至基本查询集
        query = Course.objects.filter(conditions)
        data = query.values()  # 将 QuerySet 对象转换为字典列表
        data = list(data)  # 转换为列表以便序列化为 JSON
        print(query)
        response = ResponseUtil.ok(data, "课程信息查询成功")
        return JsonResponse(response)
    if request.method == 'DELETE':
        parser = MultiPartParser(request.META, BytesIO(request.body), request.upload_handlers, request.encoding)
        posdict = parser.parse()
        cids = posdict[0]['cids']
        cids = literal_eval(cids)
        print(cids)
        try:
            info = Course.objects.filter(cid__in=cids).values()
            data = list(info)
            if len(data)>0:
                Course.objects.filter(cid__in=cids).delete()
                response = ResponseUtil.ok(data, "课程信息删除成功")
                return JsonResponse(response)
            else:
                response = ResponseUtil.error("课程未找到")
                return JsonResponse(response)
        except:
            response = ResponseUtil.ok("未查询到课程，删除失败")
            return JsonResponse(response)
    if request.method == 'PUT':
        put = MultiPartParser(request.META, request, request.upload_handlers, request.encoding).parse()
        # request.PUT = put[0]
        print(put)
        cid = put[0]['cid']
        name = put[0]['name']
        type = put[0]['type']
        credit = put[0]['credit']
        tid = put[0]['tid']
        if cid and name and type and credit and tid:
            Course.objects.filter(cid=cid).update(name=name, type=type, credit=credit)
            Course.objects.filter(cid=cid).update(tid=Teacher.objects.get(tid=tid))
            data = Course.objects.filter(cid=cid)[0].tid_dict()
            response = ResponseUtil.ok(data, "课程信息修改成功")
            return JsonResponse(response)
        else:
            response = ResponseUtil.error("课程信息修改失败，信息不全")
            return JsonResponse(response)