def awards_edit(id, awards_id):
contest = Contest.get_by_id(id)
awards = Awards.get_by_id(awards_id)
exist_resources = awards.resources
awards_form = AwardsForm()
# if awards.apply == 3 or awards.apply == 5:
# cid = contest.contest_id
# Awards.set_all_apply_to_zero(cid)
i = 1
if request.method == 'GET':
awards_form.honor.data = awards.honor
awards_form.level.data = awards.level
awards_form.title.data = awards.title
awards_form.type.data = awards.type
# if awards.teachers:
# teacher = awards.teachers[0]
# awards_form.teachers.data = teacher.name
awards_form.teachers.data = [t.name for t in awards.teachers]
awards_form.students.data = [s.stu_no for s in awards.students]
if request.method == 'POST' and awards_form.validate():
ret = Awards.update_awards(awards, awards_form, request.files)
if ret == 'OK':
return redirect(url_for('admin.awards', id=contest.id))
elif ret == 'FAIL':
flash(u'提交失败')
else:
flash(ret)
return render_template('admin/awards_form.html',
title=u'奖项修改',
contest=contest,
awards_form=awards_form,
exist_resources=exist_resources,
awards=awards,
i=i)
def awards_check(id, awards_id):
contest = Contest.get_by_id(id)
awards = Awards.get_by_id(awards_id)
exist_resources = awards.resources
awards_form = AwardsForm()
department = current_user.department if current_user.department != u'教务处' else None
if request.method == 'GET':
awards_form.honor.data = awards.honor
awards_form.level.data = awards.level
awards_form.title.data = awards.title
awards_form.type.data = awards.type
if awards.teachers:
teacher = awards.teachers[0]
awards_form.teachers.data = teacher.name
awards_form.students.data = [s.stu_no for s in awards.students]
if request.method == 'POST' and awards_form.validate():
ret = Awards.update_awards(awards, awards_form, request.files)
if ret == 'OK':
return redirect(url_for('admin.awards', id=contest.id))
elif ret == 'FAIL':
flash(u'提交失败')
else:
flash(ret)
return render_template('admin/awards_form_check.html',
title=u'奖项查看',
contest=contest,
awards_form=awards_form,
awards=awards,
exist_resources=exist_resources,
department=department)
def awards_edit(id, awards_id):
contest = Contest.get_by_id(id)
awards = Awards.get_by_id(awards_id)
exist_resources = awards.resources
awards_form = AwardsForm()
if request.method == 'GET':
awards_form.honor.data = awards.honor
awards_form.level.data = awards.level
awards_form.title.data = awards.title
awards_form.type.data = awards.type
if awards.teachers:
teacher = awards.teachers[0]
awards_form.teachers.data = teacher.name
awards_form.students.data = [s.stu_no for s in awards.students]
if request.method == 'POST' and awards_form.validate():
ret = Awards.update_awards(awards, awards_form, request.files)
if ret == 'OK':
return redirect(url_for('admin.awards', id=contest.id))
elif ret == 'FAIL':
flash(u'提交失败')
else:
flash(ret)
return render_template('admin/awards_form.html',
title = u'奖项修改',
contest = contest,
awards_form = awards_form,
exist_resources = exist_resources)
def awards_del():
awards_id = request.form.get('awards_id', -1)
if awards_id != -1:
awards = Awards.get_by_id(awards_id)
ret = Awards.delete_awards(awards)
else:
ret = u'删除失败'
return jsonify(ret = ret)
def awards_del():
awards_id = request.form.get('awards_id', -1)
if awards_id != -1:
awards = Awards.get_by_id(awards_id)
ret = Awards.delete_awards(awards)
else:
ret = u'删除失败'
return jsonify(ret=ret)
def statistics_form_2():
filter_pass = request.args.get('filter_pass', 0, type=int)
print "%%%%%%%%%%%%%%%%%%%%%%%%%%%%"
print filter_pass
list = [u'球', u'国家', u'省', u'市', u'校']
from datetime import date
year_now = date.today().year
year_select = [str(year) for year in range(year_now - 4, year_now + 1)]
cur_year = request.args.get('year', year_now,
type=int) #获取连接里面的参数的值。year的值
print "#####################"
print cur_year
awards_level = Awards.get_level_by_level()
# 得到国家级省级...
level_list = []
number = []
for l in list:
for a in awards_level:
if l in a and not l in level_list:
level_list.append(l)
if filter_pass != -1:
level_selected = level_list[filter_pass]
else:
level_selected = u'所有'
for l in level_list:
n = 0
for a in awards_level:
if l in a:
n = n + 1
number.append(n)
print level_selected
print cur_year
awards_num = Awards.get_awards_num2(cur_year, level_selected)
department = []
ad = Awards.get_all()
for d in ad:
if not d.department in department:
department.append(d.department)
list_len = len(awards_num) / len(department)
print awards_num
return render_template('admin/statisticsform2.html',
title=u'统计',
filter_pass=filter_pass,
list=list,
year_select=year_select,
awards_level=awards_level,
awards_num=awards_num,
level_list=level_list,
list_len=list_len,
cur_year=cur_year,
department=department,
number=number)
def statistics_form_1():
filter_pass = request.args.get('filter_pass', 0, type=int)
list = [u'球',u'国家',u'省',u'市',u'校']
from datetime import date
year_now = date.today().year
year_select = [str(year) for year in range(year_now-4,year_now+1)]
awards_level = Awards.get_level_by_level()
level_list = []
number = []
if awards_level:
for l in list:
for a in awards_level:
if l in a and not l in level_list:
level_list.append(l)
if filter_pass != -1:
level_selected = level_list[filter_pass]
else:
level_selected = u'所有'
for l in level_list:
n = 0
for a in awards_level:
if l in a:
n = n + 1
number.append(n)
awards_num = Awards.get_awards_num(level_selected)
list_len = len(awards_num) / 5
chart_list = Awards.get_awards_num3(level_selected)
#求和
level_sum = {}
for c in chart_list:
level_sum.setdefault(c)
level_sum[c] = sum(chart_list[c])
else:
awards_num = 0
list_len = 0
chart_list = []
level_sum = 0
return render_template('admin/statisticsform1.html',
title = u'统计',
filter_pass = filter_pass,
list = list,
year_select = year_select,
awards_level = awards_level,
awards_num = awards_num,
level_list = level_list,
list_len = list_len,
number = number,
chart_list = chart_list,
level_sum = level_sum
)
def awards(id):
contest = Contest.get_by_id(id)
page = request.args.get('page', 1, type=int)
per_page = current_app.config['ADMIN_AWARDS_PER_PAGE']
if page == -1:
page = ((Awards.get_count(contest_id=contest.contest_id) - 1) // per_page) + 1
pagination = Awards.get_list_pageable(page, per_page,
contest_id=contest.contest_id)
awards_list = pagination.items
return render_template('admin/awards.html',
title = u'奖项管理',
contest = contest,
awards_list = awards_list,
pagination = pagination,
process = Awards.AwardsProcess)
def awards_required_refuse(cid,id):
# contest = Contest.get_by_id(id)
# cid = contest.contest_id
awards = Awards.get_by_id(id)
awards.apply = int(5)
awards.process = u'申请不通过'
return redirect(url_for('admin.awards',id = cid))
def awards_required_refuse(cid, id):
# contest = Contest.get_by_id(id)
# cid = contest.contest_id
awards = Awards.get_by_id(id)
awards.apply = int(5)
awards.process = u'申请不通过'
return redirect(url_for('admin.awards', id=cid))
def awards_required_through(cid, id):
# contest = Contest.get_by_id(id)
# cid = contest.contest_id
awards = Awards.get_by_id(id)
awards.apply = int(4)
awards.process = u'已审核'
return redirect(url_for('admin.awards', id=cid))
def awards_required_through(cid,id):
# contest = Contest.get_by_id(id)
# cid = contest.contest_id
awards = Awards.get_by_id(id)
awards.apply = int(4)
awards.process = u'已审核'
return redirect(url_for('admin.awards',id = cid))
def statistics():
page=request.args.get('page',1,type=int)
per_page=current_app.config['ADMIN_STATISTICS_PER_PAGE']
if page == -1:
page = ((Awards.get_count() - 1) // per_page) + 1
pagination = Awards.get_list_pageable(page, per_page)
awards_list = pagination.items
awards = Awards.get_stu_awards_list()
count = Awards.get_count()
student_list = Student.get_list_pageable(page,per_page).items
return render_template('admin/statistics.html',
title = u'统计',
awards_list = awards_list,
student_list = student_list,
alist = awards,
count = count,
pagination = pagination)
def awards_check_after_pass(id, awards_id):
contest = Contest.get_by_id(id)
awards = Awards.get_by_id(awards_id)
exist_resources = awards.resources
return render_template('admin/awards_see.html',
title = u'奖项查看1',
contest = contest,
awards = awards,
exist_resources = exist_resources,
)
def awards(id):
contest = Contest.get_by_id(id)
page = request.args.get('page', 1, type=int)
per_page = current_app.config['ADMIN_AWARDS_PER_PAGE']
department = current_user.department if current_user.department != u'教务处' else None
if page == -1:
page = ((Awards.get_count(contest_id=contest.contest_id) - 1) //
per_page) + 1
pagination = Awards.get_list_pageable(page,
per_page,
contest_id=contest.contest_id)
awards_list = pagination.items
return render_template('admin/awards.html',
title=u'奖项管理',
contest=contest,
awards_list=awards_list,
pagination=pagination,
process=Awards.AwardsProcess,
department=department)
def __init__(self, *args, **kwargs):
super(AwardsForm, self).__init__(*args, **kwargs)
cur_year = date.today().year
# self.year.choices = [(year, year) for year in range(cur_year - 1, cur_year + 2)]
self.level.choices = [(v, v) for v in Awards.LevelList()]
self.year.choices = [(str(y), str(y))
for y in range(cur_year - 4, cur_year + 1)]
self.department.choices = [("-1", u"--- 请选择 ---")] + [
(department, department) for department in DepartmentList
]
def awards_check_after_pass(id, awards_id):
contest = Contest.get_by_id(id)
awards = Awards.get_by_id(awards_id)
exist_resources = awards.resources
return render_template(
'admin/awards_see.html',
title=u'奖项查看1',
contest=contest,
awards=awards,
exist_resources=exist_resources,
)
def awards_add(id):
contest = Contest.get_by_id(id)
awards_form = AwardsForm()
if request.method == 'POST' and awards_form.validate():
ret = Awards.create_awards(awards_form, contest, request.files)
if ret == 'OK':
return redirect(url_for('admin.awards', id=contest.id))
elif ret == 'FAIL':
flash(u'提交失败')
else:
flash(ret)
return render_template('admin/awards_form.html',
title = u'奖项录入',
contest = contest,
awards_form = awards_form)
def statistics_form_1():
filter_pass = request.args.get('filter_pass', -1, type=int)
list = [u'球', u'国家', u'省', u'市', u'校']
from datetime import date
year_now = date.today().year
year_select = [str(year) for year in range(year_now - 4, year_now + 1)]
awards_level = Awards.get_level_by_level()
level_list = []
number = []
for l in list:
for a in awards_level:
if l in a and not l in level_list:
level_list.append(l)
if filter_pass != -1:
level_selected = level_list[filter_pass]
else:
level_selected = u'所有'
for l in level_list:
n = 0
for a in awards_level:
if l in a:
n = n + 1
number.append(n)
awards_num = Awards.get_awards_num(level_selected)
list_len = len(awards_num) / 5
return render_template('admin/statisticsform1.html',
title=u'统计',
filter_pass=filter_pass,
list=list,
year_select=year_select,
awards_level=awards_level,
awards_num=awards_num,
level_list=level_list,
list_len=list_len,
number=number)
def statistics_form():
all_contest = Contest.get_alls()
j = 0
department = []
for next_contest in all_contest:
department.append(all_contest[j].department)
j = j + 1
counter = Counter(department)
all_awards = Awards.get_all()
i = 0
level = []
for next_awards in all_awards:
level.append(all_awards[i].level)
i = i + 1
levels = Counter(level)
return render_template('admin/statisticsform.html',
title=u'统计',
counter=counter,
level=levels)
def statistics_form():
all_contest = Contest.get_alls()
j = 0
department = []
for next_contest in all_contest:
department.append(all_contest[j].department)
j = j + 1
counter = Counter(department)
all_awards = Awards.get_all()
i = 0
level = []
for next_awards in all_awards:
level.append(all_awards[i].level)
i = i + 1
levels = Counter(level)
return render_template('admin/statisticsform.html',
title = u'统计',
counter = counter,
level = levels
)
def awards_add(id):
contest = Contest.get_by_id(id)
awards_form = AwardsForm()
i = 0
awards_form.department.data = current_user.department
# cid = contest.contest_id
# Awards.set_new_apply(cid)
request.values.get('StudentList')
if request.method == 'POST' and awards_form.validate():
ret = Awards.create_awards(awards_form, contest, request.files)
if ret == 'OK':
return redirect(url_for('admin.awards', id=contest.id))
elif ret == 'FAIL':
flash(u'提交失败')
else:
flash(ret)
return render_template('admin/awards_form.html',
title=u'奖项录入',
contest=contest,
awards_form=awards_form,
i=i)
def awards_add(id):
contest = Contest.get_by_id(id)
awards_form = AwardsForm()
i =0
awards_form.department.data = current_user.department
# cid = contest.contest_id
# Awards.set_new_apply(cid)
request.values.get('StudentList')
if request.method == 'POST' and awards_form.validate():
ret = Awards.create_awards(awards_form, contest, request.files)
if ret == 'OK':
return redirect(url_for('admin.awards', id=contest.id))
elif ret == 'FAIL':
flash(u'提交失败')
else:
flash(ret)
# Student.remove_student()
return render_template('admin/awards_form.html',
title = u'奖项录入',
contest = contest,
awards_form = awards_form,
i=i
)
def statistics_form_2():
filter_pass = request.args.get('filter_pass', 0, type=int)
list = [u'球',u'国家',u'省',u'市',u'校']
from datetime import date
year_now = date.today().year
year_select = [str(year) for year in range(year_now-4,year_now+1)]
cur_year = request.args.get('year', year_now, type=int) #获取连接里面的参数的值。year的值
awards_level = Awards.get_level_by_level()
# 得到国家级省级...
if awards_level:
level_list = []
number = []
for l in list:
for a in awards_level:
if l in a and not l in level_list:
level_list.append(l)
if filter_pass != -1:
level_selected = level_list[filter_pass]
else:
level_selected = u'所有'
for l in level_list:
n = 0
for a in awards_level:
if l in a:
n = n + 1
number.append(n)
awards_num = Awards.get_awards_num2(cur_year,level_selected)
department = []
ad = Awards.get_all()
for d in ad:
if not d.department in department:
department.append(d.department)
list_len = len(awards_num) / len(department)
dicts = {}
level_sum = {}
y = 0
if filter_pass != -1:
for a in awards_level:
if level_selected in a:
dicts.setdefault(a)
level_sum.setdefault(a)
dicts_list = []
x = y
while x < len(awards_num):
dicts_list.append(awards_num[x])
x = x + list_len
dicts[a] = dicts_list
level_sum[a] = sum(dicts_list)
y = y + 1
else:
for a in awards_level:
dicts.setdefault(a)
level_sum.setdefault(a)
dicts_list = []
x = y
while x < len(awards_num):
dicts_list.append(awards_num[x])
x = x + list_len
dicts[a] = dicts_list
level_sum[a] = sum(dicts_list)
y = y + 1
d = Awards.get_student_num(cur_year,level_selected)
print d
else:
awards_num = 0
level_list = []
list_len = 0
department = []
number = []
dicts = {}
level_sum = 0
return render_template('admin/statisticsform2.html',
title = u'统计',
filter_pass = filter_pass,
list = list,
year_select = year_select,
awards_level = awards_level,
awards_num = awards_num,
level_list = level_list,
list_len = list_len,
cur_year = cur_year,
department = department,
number = number,
dicts = dicts,
level_sum = level_sum
)
def awards_check_pass(id,awards_id):
awards = Awards.get_by_id(awards_id)
awards.apply = 1 #apply表示已审核
awards.process = u'已审核'
awards.save()
return redirect(url_for('admin.awards',id = id))
def awards_check_refuse(id,awards_id):
awards = Awards.get_by_id(awards_id)
awards.apply = 2 #apply表示审核不通过
awards.process = u'审核不通过'
awards.save()
return redirect(url_for('admin.awards',id = id))
def awards_refuse_check(id):
contest = Contest.get_by_id(id)
cid = contest.contest_id
Awards.set_all_apply_refuse(cid)
return redirect(url_for('admin.awards', id=id))
def awards_check_pass(id, awards_id):
awards = Awards.get_by_id(awards_id)
awards.apply = 1 #apply表示已审核
awards.process = u'已审核'
awards.save()
return redirect(url_for('admin.awards', id=id))
def awards_refuse_check(id):
contest = Contest.get_by_id(id)
cid = contest.contest_id
Awards.set_all_apply_refuse(cid)
return redirect(url_for('admin.awards',id = id))
def awards_check_refuse(id, awards_id):
awards = Awards.get_by_id(awards_id)
awards.apply = 2 #apply表示审核不通过
awards.process = u'审核不通过'
awards.save()
return redirect(url_for('admin.awards', id=id))
