def edit_course(request):
"""
编辑课程信息
"""
nid = request.GET.get('nid')
if request.method == "GET":
c = CourseList()
sql = "select * from course where id=%s"
result = sqlheper.get_list(sql, [nid, ])
return render(request, 'edit_course.html', {'result': result[0], 'teacher_list': c.teacher_list})
else:
ret = {'status': True, 'message': None}
try:
c = CourseList()
c.edit_check(request.POST)
edit_list = list(request.POST.values())
sql = "update course set course_name=%s,credit=%s,teacher_number=%s where id=%s"
operationlogs.operationlogs(request.COOKIES.get('name'), 'edit', 'course', edit_list[-1],
json.dumps(request.POST))
sqlheper.modify(sql, edit_list)
except Exception as e:
ret['status'] = False
ret['message'] = str(e)
print(e.__traceback__.tb_lineno)
return HttpResponse(json.dumps(ret))
def edit_student(request):
"""
编辑学生信息
"""
if request.method == "GET":
nid = request.GET.get('nid')
sql = "select * from student where id=%s"
result = sqlheper.get_list(sql, [nid, ])
class_list = sqlheper.get_list("select id,title from class", [])
major = sqlheper.get_list('select major_name from major', [])
return render(request, 'edit_student.html', {'result': result[0], 'class_list': class_list, 'major': major})
else:
ret = {'status': True, 'message': None}
try:
s = StudentList()
s.edit_check(request.POST)
stu_dict = list(request.POST.values())
sql = "update student set name=%s,sex=%s,nation=%s,native_place=%s,birth_date=%s,telephone=%s,major_name=%s,class_id=%s where id=%s"
operationlogs.operationlogs(request.COOKIES.get('name'), 'edit', 'student', stu_dict[-1],
json.dumps(request.POST))
sqlheper.modify(sql, stu_dict)
except Exception as e:
ret['status'] = False
ret['message'] = str(e)
return HttpResponse(json.dumps(ret))
def operationlogs(operator, operation, target_table, target_id=None, modify_value=None):
"""
操作日志
:param operator: 操作员
:param operation: 操作
:param target_table: 对象表
:param target_id: 对象id
:param modify_value: 修改值
"""
time1 = datetime.datetime.now()
time = datetime.datetime.strftime(time1, '%Y-%m-%d %H:%M:%S')
if operation == 'edit' and modify_value not in ['开启选课', '关闭选课']:
# 获取实际更新的数据
# 获得修改前的数据
old = sqlheper.get_list(f'select * from {target_table} where id={target_id}', [])[0]
if target_table == 'student':
old.pop('id')
old.pop('student_id')
elif target_table == 'course':
old.pop('id')
old.pop('course_number')
old.pop('status')
new = json.loads(modify_value)
new.pop('nid')
modify_value = {}
for key, value in old.items():
if new[key] != str(value):
modify_value[key] = new[key]
sqlheper.modify(
'insert into operationlogs(operator, operation, target_table, target_id, modify_value,time) values(%s,%s,%s,%s,%s,%s)',
[operator, operation, target_table, target_id, str(modify_value), time]
)
def add_student(request):
"""
添加学生
"""
ret = {'status': True, 'message': None}
try:
name = request.POST.get('name')
s = StudentList()
s.add_check(request.POST) # 校验
print(request.POST)
add_list = list(request.POST.values()) # 待添加的数据
sqlheper.modify("insert into student(name,sex,major_name,class_id) values(%s,%s,%s,%s)", add_list)
# 自动生成学号
sid = sqlheper.get_list("select id from student where name=%s order by id DESC", [name, ])
sid = sid[0].get('id')
year = ['2017', '2018', '2019', '2020'] # 年份
job = ['320', '321', '322'] # 工号
student_id = str(sid).zfill(3) # 序号，三位数
student_id = year[-1] + job[2] + student_id
sqlheper.modify("update student set student_id=%s where id=%s", [student_id, sid])
operationlogs.operationlogs(request.COOKIES.get('name'), 'add', 'student')
except Exception as e:
# 添加失败返回错误信息
ret['status'] = False
ret['message'] = str(e)
return HttpResponse(json.dumps(ret))
def edit_student(request):
if request.method == 'GET':
nid = request.GET.get('nid')
sql1 = 'select id, title from class'
class_list = sqlheper.get_list(sql1, [])
sql2 = 'select id, name, class_id from student where id=%s'
current_student_info = sqlheper.get_one(sql2, [
nid,
])
return render(
request, 'edit_student.html', {
'class_list': class_list,
'current_student_info': current_student_info,
})
else:
nid = request.GET.get('nid')
name = request.POST.get('name')
class_id = request.POST.get('class_id')
print(name, class_id, nid)
sql3 = 'update student set name=%s, class_id=%s where id=%s'
sqlheper.modify(sql3, [
name,
class_id,
nid,
])
return redirect('/students/')
def add_student(request):
if request.method == 'GET':
sql = 'select id,title from class'
class_list = sqlheper.get_list(sql, [])
return render(request, 'add_student.html', {
'class_list': class_list,
})
else:
name = request.POST.get('name')
if len(name) == 0:
sql = 'select id,title from class'
class_list = sqlheper.get_list(sql, [])
return render(request, 'add_student.html', {
'class_list': class_list,
'msg': 'Your submit is None!'
})
else:
class_id = request.POST.get('class_id')
sql2 = 'insert into student(name, class_id) values(%s,%s)'
sqlheper.modify(sql2, [
name,
class_id,
])
return redirect('/students/')
def modal_add_teacher(request):
ret = {'status': True, 'message': None}
try:
name = request.POST.get('teacher_name')
class_id = request.POST.get('class_id')
cid = class_id.split(',')
print(cid)
print(class_id)
if len(name) > 0:
sqlheper.modify("insert into teacher(name) value(%s)", [
name,
])
teacher_id = sqlheper.get_one(
"select id from teacher where name=%s",
[name],
)
tid = teacher_id['id']
print(teacher_id['id'])
for i in cid:
sqlheper.modify(
"insert into teacher2class(teacher_id,class_id) value(%s,%s)",
[tid, i])
else:
ret['status'] = False
ret['message'] = "老师姓名不能为空"
except Exception as e:
ret['status'] = False
ret['message'] = str(e)
return HttpResponse(json.dumps(ret))
def modal_add_class(request):
class_name = request.POST.get('class_name')
if len(class_name) > 0:
sqlheper.modify('insert into t_class(class_name) values(%s)', [class_name, ])
return HttpResponse('ok')
else:
return HttpResponse('班级标题不能为空')
def del_course(request):
"""
删除课程
"""
course_id = request.POST.get('cid')
sqlheper.modify('delete from course where id=%s', [course_id, ])
operationlogs.operationlogs(request.COOKIES.get('name'), 'del', 'course', course_id)
return HttpResponse('ok')
def modal_add_student(request):
student_name = request.POST.get('student_name')
class_id = request.POST.get('class_id')
if len(student_name) > 0:
sqlheper.modify('insert into t_student(student_name,class_id) values(%s,%s)', [student_name, class_id, ])
return HttpResponse('ok')
else:
return HttpResponse('学生名称不能为空')
def del_student(request):
id = request.GET.get('nid')
sql = "delete from student where id=%s"
sqlheper.modify(sql, [
id,
])
return redirect('/students/')
def del_student(request):
"""
删除学生
"""
student_id = request.POST.get('sid')
sqlheper.modify('delete from student where id=%s', [student_id, ])
operationlogs.operationlogs(request.COOKIES.get('name'), 'del', 'student', student_id)
return HttpResponse('ok')
def modal_add_class(request):
title = request.POST.get('title')
if len(title) > 0:
sqlheper.modify('insert into class(title) values(%s)', [
title,
])
return HttpResponse('ok')
else:
return HttpResponse('班级标题不能为空')
def modal_add_class(request):
name = request.POST.get("name")
if len(name) > 0:
sqlheper.modify("insert into class(name) values (%s)", [
name,
])
return HttpResponse("ok")
else:
return HttpResponse('班级标题不能为空')
def del_class(request):
print(request.GET)
id = request.GET.get('nid')
sql = "delete from class where id=%s"
sqlheper.modify(sql, [
id,
])
return redirect('/classes/')
def modal_add_class(request):
title = request.POST.get('title') #获取classes页面中title数据
if len(title) > 0: #判断数据是否为空
sqlheper.modify("insert into myapp_class(title) values(%s)", [
title,
]) #将拿到的数据添加到数据库
return HttpResponse('ok')
#return redirect("/classes/")
else:
return HttpResponse("标题不能为空")
def add_class(request):
if request.method == 'GET':
return render(request, 'add_class.html')
else:
print(request.POST)
value = request.POST.get('class_name')
if len(value) > 0:
sqlheper.modify("insert into t_class(class_name) values(%s)", [value, ])
return redirect('/classes/')
else:
return render(request, 'add_class.html', {'msg': '班级名称不能为空'})
def modal_edit_class(request):
name = request.POST.get("name")
nid = request.POST.get("nid")
if len(name) > 0:
sqlheper.modify("update class set name=%s where id=%s", [
name,
nid,
])
return HttpResponse("ok")
else:
return HttpResponse('班级不能为空')
def edit_class(request):
if request.method == "GET":
nid = request.GET.get('nid')
result = sqlheper.get_one("select id,class_name from t_class where id = %s", [nid, ])
print(result)
return render(request, 'edit_class.html', {'result': result})
else:
nid = request.GET.get('nid')
class_name = request.POST.get('class_name')
sqlheper.modify("update t_class set class_name=%s where id = %s", [class_name, nid, ])
return redirect('/classes/')
def modal_del_student(request):
ret = {'status': True, 'message': None}
try:
student_id = request.POST.get('student_id')
sqlheper.modify("delete from student where id=%s", [
student_id,
])
except Exception as e:
ret['status'] = False
ret['message'] = str(e)
return HttpResponse(json.dumps(ret))
def modal_edit_class(request):
from utils import sqlheper
title = request.POST.get("title")
nid = request.POST.get("nid")
print(nid)
print(title)
if len(title) > 0:
sqlheper.modify("update class set title=%s where id=%s", [title, nid])
return HttpResponse('ok')
else:
return HttpResponse('班级名称不能为空')
def modal_add_class(request):
title = request.POST.get('title')
if len(title) > 0:
sqlheper.modify('insert into login_classtable(title) values(%s)', [
title,
])
# return redirect('/classes')
return HttpResponse('ok')
else:
# 页面不要刷新，提示错误信息
return HttpResponse('班级标题不能为空')
def modal_add_student(request):
name = request.POST.get('name')
title = request.POST.get('title')
if len(title) > 0 and len(name) > 0:
sql = 'insert into student(name, class_id) values(%s, (select class.id from class where class.title=%s));'
sqlheper.modify(sql, [
name,
title,
])
return HttpResponse('ok')
else:
return HttpResponse('ERR：内容不能为空')
def modal_edit_class(request):
ret = {'status': True, 'message':None}
try:
nid = request.POST.get('nid')
content = request.POST.get('content')
print(nid)
print(content)
sqlheper.modify('update t_class set class_name=%s where id=%s', [content, nid, ])
except Exception as e:
ret['status'] = False
ret['message'] = "处理异常"
return HttpResponse(json.dumps(ret))
def modal_del_class(request):
from utils import sqlheper
nid = request.POST.get("nid")
print(nid)
if len(nid) > 0:
sqlheper.modify("delete from class where id=%s", [
nid,
])
return HttpResponse('ok')
else:
return HttpResponse('班级名称不能为空')
def modal_add_class(request):
from utils import sqlheper
title = request.POST.get("title")
print(title)
if len(title) > 0:
sqlheper.modify("insert into class(title) values(%s)", [
title,
])
return HttpResponse('ok')
else:
return HttpResponse('班级名称不能为空')
def model_add_student(request):
ret = {"status": True, "message": None}
try:
name = request.POST.get("sname")
class_id = request.POST.get("class_id")
sqlheper.modify("insert into student(sname,class_id) values (%s,%s)", [
name,
class_id,
])
except Exception as e:
ret["status"] = False
ret["message"] = str(e)
return HttpResponse(json.dumps(ret))
def modal_add_student(request):
ret = {'status': True, 'message': None}
try:
name = request.POST.get('name')
class_id = request.POST.get('class_id')
sqlheper.modify('insert into student(name,class_id) values(%s,%s)', [
name,
class_id,
])
except Exception as e:
ret['status'] = False
ret['message'] = str(e)
return HttpResponse(json.dumps(ret))
def add_student(request):
if request.method == 'GET':
class_list = sqlheper.get_list('select id,class_name from t_class', [])
return render(request, 'add_student.html', {'class_list': class_list})
else:
print(request.POST)
c_id = request.POST.get('class_id')
value = request.POST.get('student_name')
if len(value) > 0:
sqlheper.modify("insert into t_student(student_name,class_id) values(%s,%s)", [value, c_id,])
return redirect('/students/')
else:
return render(request, 'add_student.html', {'msg': '学生名称不能为空'})
def edit_student(request):
if request.method == "GET":
nid = request.GET.get('nid')
class_list = sqlheper.get_list("select id,class_name from t_class", [])
print(class_list)
current_sutdent_info = sqlheper.get_one("select id,student_name,class_id from t_student where id = %s", [nid, ])
print(current_sutdent_info)
return render(request, 'edit_studemt.html', {'class_list': class_list, 'current_sutdent_info': current_sutdent_info})
else:
nid = request.GET.get('nid')
student_name = request.POST.get('student_name')
sqlheper.modify("update t_student set student_name=%s where id = %s", [student_name, nid, ])
return redirect('/students/')
