def add_course_schedule():
if current_user is not None and current_user.is_privileged(UserType.staff):
cid = request.args.get("cid")
name = request.args.get("name")
return render_template("add_course_schedule.html", username=current_user.username, cid=cid, name=name)
else:
abort(403)
def update_order():
if current_user is not None and current_user.is_privileged(UserType.staff):
orderid = request.args.get("orderid", -1)
if int(orderid) == -1:
abort(404)
elif int(orderid) == 0:
abort(404)
order = Orders.query.filter(Orders.orderid == orderid).first()
if order is None:
return render_template("error.html", message="查找不到与之匹配的订单")
order.paytypename = PayType.getName(order.paytype)
order.statusname = OrderStatus.getName(order.status)
return render_template(
"update_order.html",
username=current_user.username,
order=order,
orderStatus=OrderStatus.getAll(),
payTypes=PayType.getAll(),
index=6,
)
else:
abort(403)
def orderpay_feedback():
if current_user is not None and current_user.is_privileged(UserType.registered):
payResult = request.args.get("result")
payOrderID = request.args.get("out_trade_no", -1)
if(payResult == 'success'):
print ' -------------------- pay success '
if(payOrderID <= 0):
print ' -------------------- orderID not exit '
order = Orders.query.filter(Orders.orderid == payOrderID).first()
if order:
print ' -------------------- to do update order ', order
order.status = 2
db.session.add(order)
db.session.commit()
else:
print ' -------------------- order not exit '
else:
print ' -------------------- pay False '
return redirect(url_for('userorders'))
else:
abort(403)
def userorders():
if current_user is not None and current_user.is_privileged(UserType.registered):
page = request.args.get("page", 1)
if page < 1:
page = 1
# 暂时只考虑课程（ptype=1）
data = Users.query.with_entities(Users.username, Users.name, Course.name, Orders.amount, Orders.income, Orders.status, Orders.paytype, Orders.orderid, Orders.operator, CourseSchedule.time)\
.join(Orders, Orders.username == Users.username)\
.filter(Users.uid == current_user.uid)\
.filter(Orders.cid == Course.cid)\
.filter(Orders.csid == CourseSchedule.csid)\
.paginate(int(page), config.PAGE_ITEMS, False)
orderDataList = []
for item in data.items:
orderData = {}
orderData['username'] = item[0]
orderData['name'] = item[1]
orderData['coursename'] = item[2]
orderData['amount'] = item[3]
orderData['income'] = item[4]
orderData['orderstatusname'] = OrderStatus.getName(item[5])
orderData['paytpyename'] = PayType.getName(item[6])
orderData['orderid'] = item[7]
orderData['operator'] = item[8]
orderData['schedulename'] = item[9]
orderDataList.append(orderData)
data.items = orderDataList
return render_template('userorders.html', username=current_user.username, pagination=data)
else:
abort(403)
def create_course():
if current_user is not None and current_user.is_privileged(UserType.staff):
teachers = Teacher.query.order_by(Teacher.tid).all()
print teachers
return render_template(
"create_course.html", username=current_user.username, types=GameType.getAll(), teachers=teachers
)
else:
abort(403)
def add_room():
if current_user is not None and current_user.is_privileged(UserType.staff):
page = request.args.get("page", 1)
if page < 1:
page = 1
paginate = Room.query.paginate(int(page), config.PAGE_ITEMS, False)
return render_template("add_room.html", username=current_user.username, pagination=paginate, index=5)
else:
abort(403)
def update_room():
if current_user is not None and current_user.is_privileged(UserType.staff):
rid = request.args.get("rid", -1)
room = Room.query.filter(Room.rid == rid).first()
if room is None:
return render_template("error.html", message="查找不到与之匹配的教室")
return render_template("update_room.html", username=current_user.username, room=room)
else:
abort(403)
def change_password():
if current_user is not None and current_user.is_privileged(UserType.registered):
username = request.args.get("username")
if not username:
abort(404)
elif current_user.username.lower() != username.lower():
abort(403)
else:
return render_template('change_password.html', username=current_user.username)
else:
abort(403)
def edit_userprofile():
if current_user is not None and current_user.is_privileged(UserType.registered):
username = request.args.get("username")
if not username:
abort(404)
elif current_user.username.lower() != username.lower():
abort(403)
else:
return render_template('edit_userprofile.html', username=current_user.username, user=current_user,
genderName = GenderType.getName(current_user.gender), typeName=UserType.getName(current_user.type), birthStr = current_user.getBirthStr())
else:
abort(403)
def searchorders():
if current_user is not None and current_user.is_privileged(UserType.staff):
page = request.args.get("page", 1)
if page < 1:
page = 1
username = request.args.get("username")
pattern = "%" + username + "%" # 支持模糊查询
data = (
Users.query.with_entities(
Users.username,
Users.name,
Course.name,
Orders.amount,
Orders.income,
Orders.status,
Orders.paytype,
Orders.orderid,
Orders.operator,
CourseSchedule.time,
)
.join(Orders, Orders.username == Users.username)
.join(OrderItem, OrderItem.orderid == Orders.orderid)
.filter(Users.username.like(pattern))
.filter(OrderItem.pid == Course.cid)
.filter(OrderItem.subid == CourseSchedule.csid)
.paginate(int(page), config.PAGE_ITEMS, False)
)
orderDataList = []
for item in data.items:
orderData = {}
orderData["username"] = item[0]
orderData["name"] = item[1]
orderData["coursename"] = item[2]
orderData["amount"] = item[3]
orderData["income"] = item[4]
orderData["orderstatusname"] = OrderStatus.getName(item[5])
orderData["paytpyename"] = PayType.getName(item[6])
orderData["orderid"] = item[7]
orderData["operator"] = item[8]
orderData["schedulename"] = item[9]
orderDataList.append(orderData)
data.items = orderDataList
return render_template("orders.html", username=current_user.username, pagination=data, index=6)
else:
abort(403)
def search_course():
if current_user is not None and current_user.is_privileged(UserType.staff):
name = request.args.get("q")
try:
pattern = "%" + name + "%"
result = Course.query.filter(Course.name.like(pattern)).order_by(Course.cid).all()
for course in result:
schedule_count = db.session.query(CourseSchedule).filter(CourseSchedule.cid == course.cid).count()
course.scount = schedule_count
return render_template("search_course.html", username=current_user.username, courses=result, index=3)
except Exception, e:
print e
return render_template("error.html", message="查询失败")
def search_room():
if current_user is not None and current_user.is_privileged(UserType.staff):
# 由于使用站内搜索功能时结果集一般很少，为简单起见不再支持分页
name = request.args.get("q")
if name == "":
return render_template("error.html", message="请输入查询的教室信息")
try:
pattern = "%" + name + "%" # 支持模糊查询
result = Room.query.filter(Room.name.like(pattern)).order_by(Room.rid).all()
return render_template("search_room.html", username=current_user.username, rooms=result, index=5)
except Exception, e:
# app.logger.error(e)
return render_template("error.html", message="查询失败")
def user():
if current_user is not None and current_user.is_privileged(UserType.staff):
page = request.args.get("page", 1)
if page < 1:
page = 1
paginate = Users.query.order_by(Users.uid).paginate(int(page), config.PAGE_ITEMS, False)
users = []
for user in paginate.items:
user.gender = GenderType.getName(user.gender)
user.type = UserType.getName(user.type)
users.append(user)
return render_template("user.html", username=current_user.username, index=4, pagination=paginate)
else:
abort(403)
def course_userregister():
if current_user is not None and current_user.is_privileged(UserType.registered):
cid = request.args.get('cid', -1)
csid = request.args.get('csid', -1)
if csid < 0:
return render_template('error.html', message='查找不到与之匹配的课程班次')
courseSchedule = CourseSchedule.query.filter(CourseSchedule.csid == csid).first()
if courseSchedule is None:
return render_template('error.html', message='查找不到与之匹配的课程班次')
course = Course.query.filter(Course.cid==cid).first()
if course is None:
return render_template('error.html', message='查找不到与之匹配的课程')
else:
count = CourseStudent.query.filter(CourseStudent.cid==cid, CourseStudent.csid==csid).count()
teachernames = ""
mteacher = Teacher.query.filter(Teacher.tid == courseSchedule.mteacher).first();
muser = Users.query.filter(Users.username==mteacher.username).first()
if muser:
teachernames = muser.getName() #
if(len( teachernames ) > 0):
teachernames += " "
bteacher = Teacher.query.filter(Teacher.tid == courseSchedule.bteacher).first();
if bteacher:
buser = Users.query.filter(Users.username==bteacher.username).first()
if buser:
teachernames += buser.getName()
return render_template('register_usercourse.html',\
username=current_user.username,\
course=course,\
courseSchedule = courseSchedule, \
studentCount=count, \
pays=PayType.getAllSupported(), \
teachernames = teachernames, \
amount = course.charge)
else:
flash(u'您需要登录后才能访问该页面')
return redirect(url_for('login'))
def course():
if current_user is not None and current_user.is_privileged(UserType.staff):
page = request.args.get("page", 1)
if page < 1:
page = 1
paginate = Course.query.order_by(Course.cid).paginate(int(page), config.PAGE_ITEMS, False)
for course in paginate.items:
schedule_count = db.session.query(CourseSchedule).filter(CourseSchedule.cid == course.cid).count()
course.scount = schedule_count
studentCount = db.session.query(CourseStudent).filter(CourseStudent.cid == course.cid).count()
course.studentCount = studentCount
studentIsFull = "已满员" if studentCount >= course.max_student else "未满员"
course.studentIsFull = studentIsFull
return render_template("course.html", index=3, username=current_user.username, pagination=paginate)
else:
abort(403)
def register_course():
if current_user is not None and current_user.is_privileged(UserType.staff):
cid = request.args.get("cid")
username = request.args.get("username")
course = Course.query.filter(Course.cid == cid).first()
user = Users.query.filter(Users.username == username).first()
if course is None:
return render_template("error.html", message="查找不到与之匹配的课程")
elif user is None:
return render_template("error.html", message="查找不到与之匹配的用户")
else:
status = CourseStatus.getName(course.status)
teacher = Teacher.query.filter(Teacher.tid == course.tid).first()
allteachers = Teacher.query.order_by(Teacher.tid).all()
return render_template(
"register_course.html", username=current_user.username, course=course, pays=PayType.getAll()
)
else:
abort(403)
def admin():
if current_user is not None and current_user.is_privileged(UserType.staff):
userCount = Users.query.filter(Users.type >= 1).count()
teacherCount = Teacher.query.count()
courseCount = Course.query.count()
roomCount = Room.query.count()
orderCount = Orders.query.count()
return render_template(
"admin.html",
username=current_user.username,
registeredUserCount=userCount,
teacherCount=teacherCount,
courseCount=courseCount,
roomCount=roomCount,
orderCount=orderCount,
index=1,
)
else:
abort(403)
def update_course():
if current_user is not None and current_user.is_privileged(UserType.staff):
cid = request.args.get("cid")
course = Course.query.filter(Course.cid == cid).first()
print course
if course is None:
return render_template("error.html", message="查找不到与之匹配的课程")
else:
# status = CourseStatus.getName(course.status)
# teacher = Teacher.query.filter(Teacher.tid==course.tid).first()
# allteachers = Teacher.query.order_by(Teacher.tid).all()
gtype = {"type": course.gtype, "name": GameType.getName(course.gtype)}
return render_template(
"update_course.html",
username=current_user.username,
course=course,
gtype=gtype,
types=GameType.getAll(),
)
else:
abort(403)
def update_teacher():
if current_user is not None and current_user.is_privileged(UserType.staff):
tid = request.args.get("tid")
teacher = Teacher.query.filter(Teacher.tid == tid).first()
if teacher is None:
return render_template("error.html", message="查找不到与之匹配的讲师")
else:
user = Users.query.filter(Users.username == teacher.username).first()
if not user:
return render_template("error.html", message="找不到教师的基本用户数据")
else:
return render_template(
"update_teacher.html",
username=current_user.username,
teacher=teacher,
types=GameType.getAll(),
genderName=GenderType.getName(user.gender),
gname=GameType.getName(teacher.gtype),
)
else:
abort(403)
def teacher():
if current_user is not None and current_user.is_privileged(UserType.staff):
page = request.args.get("page", 1)
if page < 1:
page = 1
paginate = Teacher.query.order_by(Teacher.tid).paginate(int(page), config.PAGE_ITEMS, False)
# 需要将相关的常量替换成可读字符串
# 一种办法是使用ORM进行联合查询，这样的坏处是容易造成SQL复杂且不稳定
# 因此直接使用数据后处理进行替换，效率虽低，但安全性和扩展性更好，对于本应用来说是可以接受的
teachers = []
for teacher in paginate.items:
user = Users.query.filter(Users.username == teacher.username).first()
if user:
teacher.name = user.name
teacher.birth = user.birth
teacher.gender = GenderType.getName(user.gender)
teacher.gtypename = GameType.getName(teacher.gtype) # gtypename
teacher.desc = user.desc
teacher.extend = user.extend
return render_template("teacher.html", username=current_user.username, index=2, pagination=paginate)
else:
abort(403)
def search_teacher():
if current_user is not None and current_user.is_privileged(UserType.staff):
# 由于使用站内搜索功能时结果集一般很少，为简单起见不再支持分页
name = request.args.get("username")
if name == "":
return render_template("error.html", message="请输入查询的教师用户名")
try:
pattern = "%" + name + "%" # 支持模糊查询
result = Teacher.query.filter(Teacher.username.like(pattern)).order_by(Teacher.tid).all()
teachers = []
for teacher in result:
user = Users.query.filter(Users.username == teacher.username).first()
teacher.name = user.name
teacher.birth = user.birth
teacher.gender = GenderType.getName(user.gender)
teacher.gtype = GameType.getName(teacher.gtype)
teacher.desc = user.desc
teacher.extend = user.extend
teachers.append(teacher)
return render_template("search_teacher.html", username=current_user.username, teachers=teachers)
except Exception, e:
# app.logger.error(e)
return render_template("error.html", message="查询失败")
def search_user():
if current_user is not None and current_user.is_privileged(UserType.staff):
# 由于使用站内搜索功能时结果集一般很少，为简单起见不再支持分页
name = request.args.get("username")
if name == "":
return render_template("error.html", message="请输入查询的用户名")
try:
pattern = "%" + name + "%" # 支持模糊查询
result = (
Users.query.filter(
or_(Users.username.like(pattern), Users.phone.like(pattern), Users.email.like(pattern))
)
.order_by(Users.uid)
.all()
)
users = []
for user in result:
user.gender = GenderType.getName(user.gender)
user.type = UserType.getName(user.type)
users.append(user)
return render_template("search_user.html", username=current_user.username, users=result, index=4)
except Exception, e:
# app.logger.error(e)
return render_template("error.html", message="查询失败")
def add_teacher():
if current_user is not None and current_user.is_privileged(UserType.staff):
return render_template("add_teacher.html", username=current_user.username, index=2, types=GameType.getAll())
else:
abort(403)
