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/')