def periodical_edit():
per_name = request.args['pername']
per_db = ZwMySQL()
per = per_db.select_periodical_with_name(per_name)
return render_template('periodical_edit.html',
url='periodical_edit',
user='******',
per_act='active',
name=per[0][1],
sub=per[0][2],
dec=per[0][3],
issn=per[0][4],
img=per[0][5])
def email():
per_name = request.args['pername']
per_db = ZwMySQL()
per = per_db.select_periodical_with_name(per_name)
per_no = per[0][0]
email_db = ZwMySQL()
rss = email_db.select_email(per_no)
curs = []
for rs in rss:
if rs[4] != '1':
curs.append(rs)
return render_template('email.html',
url=per_name,
curs=curs,
curnum=len(curs),
per_act='active',
user='******',
perno=per_no)
