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()