def deleteone(): num = request.form['num'] Cnum = request.form['Cnum'] usr = SQL.select('select account from students where Num=\'%s\'' % num)[0]['account'] if user.delcourse(num, Cnum): scores = SQL.select('select * from score where Snum=\'%s\'' % num) return render_template('delete.html', num=num, username=usr, name=user.getname(usr), sex=user.getsex(usr), grade=user.getgrade(usr), classs=user.getclass(usr), age=user.getage(usr), dept=user.getdept(usr), scores=scores, succeed='删除成功!') else: scores = SQL.select('select * from score where Snum=\'%s\'' % num) return render_template('delete.html', num=num, username=usr, name=user.getname(usr), sex=user.getsex(usr), grade=user.getgrade(usr), classs=user.getclass(usr), age=user.getage(usr), dept=user.getdept(usr), scores=scores, succeed='删除失败!')
def currleave(): Sname = user.getname(current_user.id) Snum = user.getnum(current_user.id) LeaveTable = SQL.select('select * from leave where Snum = \'%s\'' % Snum) for table in LeaveTable: Tname = user.getname(user.getaccount(table['Tnum'])) table['Tname'] = Tname return render_template('currleave.html', LeaveTable=LeaveTable, Sname=Sname)
def leavemanagep(): if user.gettype(current_user.id) == 'student': return render_template('return.html', message='学生不能管理请假') Snum = request.form['Snum'] Tnum = user.getnum(current_user.id) try: act = request.form['act'] except Exception: act = '' stats = request.form['status'] if stats == '未批准': if act == '准假': SQL.cur.execute( 'update leave set status=\'未销假\' where status=\'未批准\' and Tnum=\'%s\' and Snum=\'%s\'' % (Tnum, Snum)) SQL.conn.commit() elif act == '驳回': SQL.cur.execute( 'update leave set status=\'已驳回\' where status=\'未批准\' and Tnum=\'%s\' and Snum=\'%s\'' % (Tnum, Snum)) SQL.conn.commit() elif stats == '未销假': SQL.cur.execute( 'update leave set status=\'已销假\' where status=\'未销假\' and Tnum=\'%s\' and Snum=\'%s\'' % (Tnum, Snum)) SQL.conn.commit() LeaveTable = SQL.select('select * from leave where Tnum = \'%s\'' % Tnum) Sname = '' for table in LeaveTable: Sname = user.getname(user.getaccount(table['Snum'])) table['Sname'] = Sname return render_template('leavemanage.html', LeaveTable=LeaveTable, Sname=Sname)
def alter(): usr = '' num = request.form['num'] currtype = current_user.type if num[:3] == 'stu' and user.isExistStu(num): usr = SQL.select('select account from students where Num=\'%s\'' % num)[0]['account'] elif num[:3] == 'tch' and user.isExistTch(num): usr = SQL.select('select account from teachers where num=\'%s\'' % num)[0]['account'] if not user.isExist(usr): return render_template('alter.html', fail='找不到用户') if user.gettype(current_user.id) == 'student': return render_template('return.html', message='教师才能修改其他学生的信息') elif user.gettype(usr) == 'teacher' and current_user.id != usr: return render_template('return.html', message='教师不能修改其他教师的信息') else: return render_template('alterone.html', username=usr, type=user.gettype(usr), num=user.getnum(usr), name=user.getname(usr), sex=user.getsex(usr), grade=user.getgrade(usr), classs=user.getclass(usr), age=user.getage(usr), dept=user.getdept(usr), currtype=currtype)
def leavemanage(): if user.gettype(current_user.id) == 'student': return render_template('return.html', message='学生不能管理请假') Tnum = user.getnum(current_user.id) LeaveTable = SQL.select('select * from leave where Tnum = \'%s\'' % Tnum) if len(LeaveTable) > 0: for table in LeaveTable: Sname = user.getname(user.getaccount(table['Snum'])) table['Sname'] = Sname return render_template('leavemanage.html', LeaveTable=LeaveTable)
def alterself(): if request.method == 'GET': return render_template('alterone.html', currtype='student', username=current_user.id, type=user.gettype(current_user.id), num=user.getnum(current_user.id), name=user.getname(current_user.id), sex=user.getsex(current_user.id), grade=user.getgrade(current_user.id), classs=user.getclass(current_user.id), age=user.getage(current_user.id), dept=user.getdept(current_user.id)) elif request.method == 'POST': usr = request.form['username'] pswnew = request.form['pswnew'] name = request.form['name'] sex = request.form['sex'] age = int(request.form['age']) dept = request.form['dept'] try: grade = int(request.form['grade']) classs = int(request.form['class']) except Exception: grade = 0 classs = 0 if usr != '': user.setStatus(pswnew=pswnew, name=name, sex=sex, age=age, dept=dept, grade=grade, classs=classs, user=usr) else: user.setStatus(pswnew=pswnew, name=name, sex=sex, age=age, dept=dept, grade=grade, classs=classs, user=current_user.id) return render_template('return.html', message='修改成功')
def deletenump(): if user.gettype(current_user.id) == 'student': return render_template('return.html', message='学生不能清除成绩!') else: num = 'stu' + request.form['num'] if user.isExistStu(num): usr = SQL.select('select account from students where Num=\'%s\'' % num)[0]['account'] scores = SQL.select('select * from score where Snum=\'%s\'' % num) return render_template('delete.html', num=num, username=usr, name=user.getname(usr), sex=user.getsex(usr), grade=user.getgrade(usr), classs=user.getclass(usr), age=user.getage(usr), dept=user.getdept(usr), scores=scores) else: return render_template('deletenum.html', fail='找不到用户')