def user_group_manage():
name = request.args.get('name', '')
status = request.args.get('status', '')
page = request.args.get('page', 1, type=int)
user_group_obj = UsersGroup.query.order_by(UsersGroup.create_time.desc())
if name != '':
user_group_obj = user_group_obj.filter(UsersGroup.name == name)
if status != '' and status != 'ALL':
user_group_obj = user_group_obj.filter(UsersGroup.status == status)
paginate = user_group_obj.paginate(page,
per_page=app.config['PAGE_SIZE'],
error_out=True)
groups = paginate.items
data = {
"name": name,
"status": status,
"pagination": paginate,
"fragment": fragment(),
"groups": groups
}
return render_template('admin/group_manage.html', data=data)
def bed_info_list():
title = u'寝室床位'
page = request.args.get('page', 1, type=int)
build_name = request.args.get('build_name', '')
floor_no = request.args.get('floor_no', '')
dorm_no = request.args.get('dorm_no', '')
rows = db.session.query(BedInfo).order_by(BedInfo.build_name.asc(),
BedInfo.floor_no.asc(),
BedInfo.dorm_no.asc(),
BedInfo.bed_no.asc())
if build_name != '':
rows = rows.filter(BedInfo.build_name == build_name)
if floor_no != '':
rows = rows.filter(BedInfo.floor_no == floor_no)
if dorm_no != '':
rows = rows.filter(BedInfo.dorm_no == dorm_no)
paginate = rows.paginate(page,
per_page=app.config['PAGE_SIZE'],
error_out=True)
beds = paginate.items
data = {
"build_name": build_name,
"floor_no": floor_no,
"beds": beds,
"dorm_no": dorm_no,
"pagination": paginate,
"fragment": fragment(),
}
return render_template('admin/enroll/bed_info_list.html',
data=data,
title=title)
def user_manage():
username = request.args.get('username', '')
email = request.args.get('email', '')
page = request.args.get('page', 1, type=int)
user_obj = User.query.order_by(User.create_time.desc())
if username != '':
user_obj = user_obj.filter(User.username == username)
if email != '':
user_obj = user_obj.filter(User.email == email)
paginate = user_obj.paginate(page,
per_page=app.config['PAGE_SIZE'],
error_out=True)
users = paginate.items
user_grops = db.session.query(UsersGroup).all()
data = {
"email": email,
"username": username,
"users": users,
"pagination": paginate,
"fragment": fragment(),
"user_grops": user_grops
}
return render_template('admin/user_manage.html', data=data)
def friend_link():
try:
title = u'链接管理'
page = request.args.get('page', 1, type=int)
link_name = request.args.get('link_name', '')
rows = db.session.query(
FriendLink
).order_by(FriendLink.create_time.desc())
if link_name:
rows = rows.filter(
FriendLink.name.like("%{0}%".format(link_name))
)
paginate = rows.paginate(page, per_page=app.config['PAGE_SIZE'], error_out=True)
items = paginate.items
data = {
"link_name": link_name,
"links": items,
"pagination": paginate,
"fragment": fragment()
}
return render_template('admin/friend_link.html', title=title, data=data)
except Exception, e:
app.logger.info(e)
def article_list():
try:
title = u'文章列表'
article_title = request.args.get('title', '')
category_id = request.args.get('category_id', '')
page = request.args.get('page', 1, type=int)
categorys_data = ArticleCategory.get_category_all()
categorys = []
for category in categorys_data:
cate = {}
cate['id'] = category.id
cate['name'] = category.name
cate['cover_pic'] = category.cover_pic
cate['description'] = category.description
cate['sort'] = category.sort
cate['pid'] = category.parent_id
categorys.append(cate)
categorys_json = json.dumps(categorys)
category_obj = ArticleCategory.get_category(category_id)
rows = db.session.query(
Article.id, ArticleCategory.name.label('category_name'),
Article.title, Article.is_top, Article.is_hot, Article.view_num,
Article.create_time, User.username,
User.nickname).outerjoin(User, Article.author_id == User.id).join(
ArticleCategory, Article.cid == ArticleCategory.id).order_by(
Article.create_time.desc())
if article_title:
rows = rows.filter(
Article.title.like(u'%{0}%'.format(article_title)), )
if category_id:
rows = rows.filter(Article.cid == category_id)
paginate = rows.paginate(page,
per_page=app.config['PAGE_SIZE'],
error_out=True)
articles = paginate.items
data = {
"title": article_title,
"category_id": category_id,
"category_name": category_obj.name if category_obj else '',
"articles": articles,
"pagination": paginate,
"fragment": fragment()
}
return render_template('admin/article_list.html',
data=data,
title=title,
categorys_json=categorys_json)
except Exception, e:
app.logger.info(e)
def article_keywords_list():
try:
title = u'关键词列表'
page = request.args.get('page', 1, type=int)
rows = db.session.query(ArticleKeywords)
paginate = rows.paginate(page,
per_page=app.config['PAGE_SIZE'],
error_out=True)
keywords = paginate.items
data = {
"keywords": keywords,
"pagination": paginate,
"fragment": fragment()
}
return render_template('admin/article_keywords_list.html',
data=data,
title=title)
except Exception, e:
app.logger.info(e)
def student_list():
title = u'学生管理'
page = request.args.get('page', 1, type=int)
student_no = request.args.get('student_no', '')
exam_no = request.args.get('exam_no', '')
id_card_no = request.args.get('id_card_no', '')
rows = db.session.query(Student, Organization).join(
Organization,
Organization.serial_no == Student.org_no).order_by(Student.id.desc())
if student_no != '':
rows = rows.filter(Student.student_no == student_no)
if exam_no != '':
rows = rows.filter(Student.exam_no == exam_no)
if id_card_no != '':
rows = rows.filter(Student.id_card_no == id_card_no)
paginate = rows.paginate(page,
per_page=app.config['PAGE_SIZE'],
error_out=True)
students = paginate.items
academys = db.session.query(Organization.academy).group_by(
Organization.academy).all()
data = {
"student_no": student_no,
"exam_no": exam_no,
"students": students,
"id_card_no": id_card_no,
"pagination": paginate,
"fragment": fragment(),
"academys": academys
}
return render_template('admin/enroll/student_list.html',
data=data,
title=title)
def dorm_rule():
try:
title = u'寝室分配'
page = request.args.get('page', 1, type=int)
academy = request.args.get('academy', '')
major = request.args.get('major', '')
grade = request.args.get('grade', '')
class_name = request.args.get('class_name', '')
rows = db.session.query(Organization).order_by(
Organization.class_name.desc())
if academy != '':
rows = rows.filter(Organization.academy == academy)
if major != '':
rows = rows.filter(Organization.major == major)
if grade != '':
rows = rows.filter(Organization.grade == grade)
if class_name != '':
rows = rows.filter(Organization.class_name == class_name)
paginate = rows.paginate(page,
per_page=app.config['PAGE_SIZE'],
error_out=True)
orgs = paginate.items
data_orgs = []
for org in orgs:
man_room_rule = db.session.query(RoomRule).filter(
RoomRule.org_no == org.serial_no, RoomRule.sex == 1).first()
woman_room_rule = db.session.query(RoomRule).filter(
RoomRule.org_no == org.serial_no, RoomRule.sex == 0).first()
_ = {
"id": org.id,
"serial_no": org.serial_no,
"grade": org.grade,
"academy": org.academy,
"major": org.major,
"class_name": org.class_name,
"man_room_rule": man_room_rule,
"woman_room_rule": woman_room_rule
}
data_orgs.append(_)
data = {
"academy": academy,
"major": major,
"grade": grade,
"class_name": class_name,
"pagination": paginate,
"fragment": fragment(),
"orgs": data_orgs
}
return render_template('admin/enroll/dorm_rule.html',
title=title,
data=data)
except Exception, e:
app.logger.info(e)
return CommonResponse(ResultType.Failed, message=u"寝室规则异常").to_json()
