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='找不到用户')
