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)