课程表管理系统

1.学生/教师用户登录界面

2.首页

3.课程详细

4.保存csv功能

5.管理员登录界面

6.管理员后台界面

7.代码详解

8.项目部署

课程表管理系统

开源地址

/course (github.com)

1.学生/教师用户登录界面

讯享网

2.首页

3.课程详细

点击已有课程，可弹出课程详细数据。

4.保存csv功能

        点击保存csv按钮，可下载当前显示课表的csv格式文档。

5.管理员登录界面

6.管理员后台界面

        管理员通过后台可以对老师、学生、班级等数据表进行增删改查功能，同时管理员后台首页可以实时的对每个班级/老师的课程进行安排，还有简单的筛选搜索功能、导出csv功能、新增/删除/修改课表信息功能。

7.代码详解

• 数据库建模

        根据需求分析，总共建立了老师表、班级表、学生表、教室表、课程总表

• 表之间的关系

        学生表和班级表是一对多的关系，

        课程表和老师表是一对多的关系，

        课程表班级表是一对多的关系，

        课程表教室表是一对多的关系。

#models.py from django.db import models from django.utils import timezone # Create your models here. ​ ​ #老师表 class Teacher(models.Model):    id=models.BigAutoField(primary_key=True,blank=False)    teacher_name = models.CharField(max_length=255,verbose_name='教师姓名')    teacher_num = models.CharField(max_length=255, blank=True, null=True,verbose_name='教师工号')    password=models.CharField(max_length=200,verbose_name='密码')    teacher_level = models.IntegerField(verbose_name='教师等级')    sex = models.IntegerField(verbose_name='性别',help_text='1 男 2 女')    age = models.IntegerField(blank=True, null=True,verbose_name='年龄')    phone = models.CharField(max_length=255,verbose_name='手机号')    birthday = models.CharField(max_length=255, blank=True, null=True,verbose_name='出生年月')    email = models.CharField(max_length=255, blank=True, null=True,verbose_name='教师邮箱')    school = models.CharField(max_length=255, blank=True, null=True,verbose_name='毕业院校')    department = models.CharField(max_length=255, blank=True, null=True,verbose_name='毕业院校院系')    major = models.CharField(max_length=255, blank=True, null=True,verbose_name='毕业院校专业')    education = models.CharField(max_length=255, blank=True, null=True,verbose_name='学历')    def __str__(self):        return self.teacher_name    class Meta:        verbose_name_plural='老师表'        # managed = False        db_table = 'teacher' #班级表 class BasicClass(models.Model):    id=models.BigAutoField(primary_key=True,blank=False)    class_name = models.CharField(max_length=200,verbose_name='班级名')    class_cate = models.IntegerField(blank=True, null=True,verbose_name='班级分类',help_text='0 五天全日制 1 六天全日制 2预科班 3 周末班')    start_time = models.DateTimeField(verbose_name='开班时间')    class_status = models.IntegerField(blank=True, null=True,verbose_name='班级状态',help_text='0 正常 1禁用')    description = models.CharField(max_length=200, blank=True, null=True,verbose_name='备注')    def __str__(self):        return self.class_name    class Meta:        verbose_name_plural='班级表'        # managed = False        db_table = 'basic_class' ​ #学生表 class Student(models.Model):    id=models.BigAutoField(primary_key=True,blank=False)    student_name = models.CharField(max_length=200,verbose_name='学生姓名')    password=models.CharField(max_length=200,verbose_name='密码')    student_num = models.CharField(max_length=255, null=False,verbose_name='学号')    #学生表和班级表是一对多的关系，这里建立外键    Class =models.ForeignKey(BasicClass, verbose_name='班级', on_delete=models.CASCADE)    add_time = models.DateTimeField(verbose_name='加入班级时间')    student_status = models.IntegerField(verbose_name='学生状态',help_text='0正常 1 请假 2 休学 3 退学')    sex = models.IntegerField(blank=True, null=True,verbose_name='性别')    age = models.IntegerField(blank=True, null=True,verbose_name='年龄')    birthday = models.CharField(max_length=200, blank=True, null=True,verbose_name='出生年月日')    student_email = models.CharField(max_length=200, blank=True, null=True,verbose_name='邮箱')    student_school = models.CharField(max_length=200, blank=True, null=True,verbose_name='院校')    student_department = models.CharField(max_length=200, blank=True, null=True,verbose_name='院系')    student_major = models.CharField(max_length=200, blank=True, null=True,verbose_name='专业')    student_school_class = models.CharField(max_length=200, blank=True, null=True,verbose_name='在校班级')    student_education = models.CharField(max_length=200, blank=True, null=True,verbose_name='学历')    phone = models.CharField(max_length=200,verbose_name='手机号')    _number = models.CharField(max_length=200, blank=True, null=True,verbose_name='号')    wechart_number = models.CharField(max_length=200, blank=True, null=True,verbose_name='微信号')    idcard = models.CharField(max_length=200, blank=True, null=True,verbose_name='身份证号')    emergency_name = models.CharField(max_length=200, blank=True, null=True,verbose_name='紧急联系人姓名')    emergency_phone = models.CharField(max_length=200, blank=True, null=True,verbose_name='紧急联系人电话')    family_address = models.CharField(max_length=200, blank=True, null=True,verbose_name='家庭住址')    now_address = models.CharField(max_length=200, blank=True, null=True,verbose_name='现在住址')    guarder = models.CharField(max_length=200, blank=True, null=True,verbose_name='监护人')    guarder_phone = models.CharField(max_length=200, blank=True, null=True,verbose_name='监护人电话')    description = models.CharField(max_length=200, blank=True, null=True,verbose_name='备注')    def __str__(self):        return self.student_name    class Meta:        verbose_name_plural='学生表'        # managed = False        db_table = 'student' #教室表 class Room(models.Model):    id=models.BigAutoField(primary_key=True,blank=False)    room_name = models.CharField(max_length=200,verbose_name='教室名')    room_count = models.IntegerField(blank=True, null=True,verbose_name='教室容量')    room_status = models.IntegerField(blank=True, null=True,verbose_name='教室状态',help_text='0教室空闲 1教室禁用',default=0)    description = models.CharField(max_length=200, blank=True, null=True,verbose_name='描述')    def __str__(self):        return self.room_name    class Meta:        verbose_name_plural='教室表'        # managed = False        db_table = 'rooms' #课程表 class CourseWeekData(models.Model):    id=models.BigAutoField(primary_key=True,blank=False)    week = models.IntegerField(verbose_name="周数",default=0)    Section=models.IntegerField(verbose_name="节次",null=False)    subject=models.CharField(verbose_name="课程名", max_length=50,null=False)    day=models.IntegerField(verbose_name="星期",null=False)    #课程表和老师表、班级表、教室表都是一对多的关系    teacher=models.ForeignKey(Teacher, verbose_name='老师', on_delete=models.CASCADE)    Class=models.ForeignKey(BasicClass, verbose_name='班级', on_delete=models.CASCADE)    room=models.ForeignKey(Room, verbose_name='教室', on_delete=models.CASCADE)    def __str__(self):        return str(self.week)    class Meta:        verbose_name_plural='周课表数据'        db_table='course_weekdata'

• 后台管理

        后台管理使用的Django的第三方ui库simpleui来美化后台界面，参数配置如下。

讯享网#settings.py #后台logo SIMPLEUI_LOGO=r'/static/favicon.ico' #关闭simpleui广告 SIMPLEUI_HOME_INFO = False #后台首页 SIMPLEUI_HOME_PAGE = '/root_index'   ​ ​ INSTALLED_APPS = [    'simpleui',#注册simpleuiAPP，需要放到最前面    'django.contrib.contenttypes',    'django.contrib.admin',    'django.contrib.auth',        'django.contrib.sessions',    'django.contrib.messages',    'django.contrib.staticfiles',    'courseIndex',#注册courseIndexAPP ]

 list_display是后台管理界面需要显示出的字段

search_fields是后台参与搜索的字段

 ordering是参与排序的字段

#admin.py from django.contrib import admin # Register your models here. from .models import * ​ #后台名字 admin.site.site_title = "后台管理" admin.site.site_header = "排课系统" ​ #注册老师表后台管理功能 @admin.register(Teacher) class TeacherAdmin(admin.ModelAdmin):    exclude = []    list_display=['teacher_num','teacher_name']    search_fields=['teacher_name'] #注册课程表后台管理功能     @admin.register(CourseWeekData) class CourseWeekDataAdmin(admin.ModelAdmin):    exclude = []    list_display = ['id','subject','week','teacher','Class','room','day','Section']    ordering=['week','day','Section']    search_fields=['week','teacher'] #注册班级表后台管理功能 @admin.register(BasicClass) class BasicClassAdmin(admin.ModelAdmin):    exclude = []    search_fields=['class_name'] #注册教室表后台管理功能 @admin.register(Room) class RoomAdmin(admin.ModelAdmin):    exclude = []    search_fields=['room_name'] #注册学生表后台管理功能 @admin.register(Student) class StudentAdmin(admin.ModelAdmin):    list_display=['student_num','student_name']    exclude = []    search_fields=['student_name']

• 项目路由

讯享网#course.urls.py #主路由 from django.contrib import admin from django.urls import path,include from django.conf.urls.static import static from django.conf import settings urlpatterns = [    #管理员后台    path('admin/', admin.site.urls,name='admin'),    #拼接courseIndex应用所有路由    path('', include("courseIndex.urls")), ]+ static(settings.MEDIA_URL, document_root = settings.MEDIA_ROOT) ​ #courseIndex路由 #courseIndex.urls.py from django.urls import path from . import views from django.conf.urls import url app_name='courseIndex' ​ urlpatterns = [    #管理员首页    path('root_index', views.root_index,name='root_index'),    #获取当前可带课的老师数据    path('getteacher',views.getteacher,name='getteacher' ),    #获取当前空闲教室数据    path('getroom',views.getroom,name='getroom' ),    #获取当前无课班级数据    path('getclasses',views.getclasses,name='getclasses' ),    #获取当前课表数据    path('getdata',views.getdata,name='getdata' ),    #添加课表详细接口    path('adddata',views.adddata,name='adddata' ),    #删除课表详细接口    path('deldata',views.deldata,name='deldata' ),    #保存当前课表数据    path('savedata',views.savedata,name='savedata' ),    #首页    path('', views.index,name='index'),    #登录页    path('login', views.Login.as_view(),name='login'), ​ ]

• 视图函数 ​

        课程表数据核心代码

#获取课程表数据 def getdata(request): #获取当前周次 week = int(request.GET.get('week', 1)) #筛选条件 cid = request.GET.get('cid', '')#班级id tid = request.GET.get('tid', '')#老师id #初始化课程表 ''' [[[], [], [], [], [], []], [[], [], [], [], [], []], [[], [], [], [], [], []], [[], [], [], [], [], []], [[], [], [], [], [], []], [[], [], [], [], [], []], [[], [], [], [], [], []]] 是一个7行6列的列表，行代表星期，列代表课程节次，最里面的小列表是为了处理一个时间段有多个班级多门课的情况 ''' li = [[[] for j in range(6)] for i in range(7)] #如果传入了老师/班级筛选条件，就进行筛选 if cid == '': courses = CourseWeekData.objects.filter(Q(week=week)) else: courses = CourseWeekData.objects.filter(Q(week=week) & Q(Class_id=cid)) if tid == '': pass else: courses = courses.filter(teacher_id=tid) #将每行里的小列表填上查到的课表数据 for course in courses: li[course.day-1][course.Section-1].append({'id': course.id, 'subject': course.subject, 'teacher': course.teacher.teacher_name, 't_id': course.teacher.id, 'class': course.Class.class_name, 'c_id': course.Class.id, 'room': course.room.room_name, 'r_id': course.room.id, 'week': course.week, 'day': course.day, 'Section': course.Section}) return JsonResponse({"list": li, 'week': week}, json_dumps_params={'ensure_ascii': False}) #保存csv，查询原理同上 def savedata(request): week = int(request.GET.get('week', 1)) cid = request.GET.get('cid', '') cname = '' tid = request.GET.get('tid', '') li = {f'星期{i+1}': ['' for j in range(6)] for i in range(7)} if cid == '': courses = CourseWeekData.objects.filter(Q(week=week)) else: cname = BasicClass.objects.get(id=cid).class_name courses = CourseWeekData.objects.filter(Q(week=week) & Q(Class_id=cid)) if tid == '': pass else: courses = courses.filter(teacher_id=tid) for course in courses: li[f'星期{course.day}'][course.Section-1] += course.subject+'@' + \ course.teacher.teacher_name+'@' + \ course.Class.class_name+'@'+course.room.room_name+'\n' #将查询到的课表数据转换为DataFrame对象 df = pd.DataFrame(li) #改字段名 df.columns = ['星期一', '星期二', '星期三', '星期四', '星期五', '星期六', '星期天'] df.index = [i for i in range(1, 7)] #生成课表名 name = f'{cname}第{week}周课程表_{datetime.datetime.now().timestamp()}.csv' #保存至项目media/csv/目录下 df.to_csv(r'media/csv/'+name) #返回保存路径 return redirect('/media/csv/'+name)

8.项目部署

• 创建虚拟环境

讯享网conda create -n course python=3.8

• 安装项目依赖

#进入项目虚拟环境 conda activate course #进入项目目录 cd xxx #安装依赖 pip install -r requirements.txt

• 修改数据库设置

讯享网#进入项目settings.py，修改数据库配置 DATABASES = {    'default': {        'ENGINE': 'django.db.backends.mysql',        'NAME': '数据库名',        'USER':'用户名',        'PASSWORD':'密码',        'HOST':'127.0.0.1',        'POST':'3306',        'OPTIONS': {'charset': 'utf8mb4'},   } }

• 迁移数据库

#进入项目目录 cd xxx python manage.py makemigrations python manage.py migrate

• 启动项目

讯享网python manage.py runserver