def post_question_md():
if request.method == 'GET':
return render_template('post_blog_md.html')
if request.method == 'POST':
try:
cur = db.cursor()
author = session.get('user_id')
title = request.form.get('title')
content = request.form.get('html_content')
print(request.values)
# 如果未登录 则跳转到登录页面
if author is None:
return redirect(url_for('login'))
date = time.strftime("%Y-%m-%d %H:%M:%S")
sql = "select max(bno) from SDWZCS.blog"
db.ping(reconnect=True)
cur.execute(sql)
result = cur.fetchone()[0]
if result is None:
bno = 1
else:
bno = int(result) + 1
sql = "insert into blog(bno, title, content, md_or_fwb, creatTime, author) VALUES ('%s','%s','%s','%s','%s','%s')" % (
bno, title, content, '1', date, author)
db.ping(reconnect=True)
cur.execute(sql)
db.commit()
cur.close()
return redirect(url_for('technology_Blog'))
except Exception as e:
raise e
def login():
if request.method == 'GET':
return render_template('login.html')
if request.method == 'POST':
email = request.form.get('email')
password = request.form.get('password')
if not all([email, password]):
flash("请将信息填写完整！")
return render_template('login.html')
try:
cur = db.cursor()
sql = "select password from UserInformation where email = '%s'" % email
db.ping(reconnect=True)
cur.execute(sql)
result = cur.fetchone()
if result is None:
flash("该用户不存在")
return render_template('login.html')
if check_password_hash(result[0], password):
session['email'] = email
session.permanent = True
cur.close()
return redirect(url_for('index'))
else:
flash("密码错误！")
return render_template('login.html')
except Exception as e:
raise e
def personal_change():
if request.method == 'GET':
cur = db.cursor()
username_get = session.get('user_id')
sql = "select email,nickname,phone from SDWZCS.userInformation where email = '%s'" % username_get
db.ping(reconnect=True)
cur.execute(sql)
userinformation = cur.fetchone()
email = userinformation[0]
phone = userinformation[2]
nickname = userinformation[1]
return render_template('personal_change.html',
email=email,
phone=phone,
nickname=nickname)
else:
cur = db.cursor()
username_get = session.get('user_id')
nickname = request.form.get('nickname')
email = request.form.get('email')
phone = request.form.get('phone')
sql = "update userInformation set SDWZCS.userInformation.nickname = '%s', SDWZCS.userInformation.phone = '%s' where SDWZCS.userInformation.email = '%s'" % (
nickname, phone, username_get)
try:
db.ping(reconnect=True)
cur.execute(sql)
db.commit()
return redirect(url_for('personal'))
except Exception as e:
raise e
def login():
if request.method == 'POST':
email = request.form.get('email')
password = request.form.get('password')
if not all([email, password]):
flash('请填写完整信息')
else:
try:
cur = db.cursor()
sql = "select password from userInformation where email='%s'" % (
email)
db.ping(reconnect=True)
cur.execute(sql)
result = cur.fetchone()
if result is None:
flash('无此用户')
if check_password_hash(result[0], password):
session['user_id'] = email
session.permanent = True
return redirect(url_for('homepage'))
else:
flash('密码错误')
return redirect(url_for('login'))
except Exception as e:
flash('无此用户')
return redirect(url_for('login'))
raise e
return render_template('login.html')
def detail_question():
formula_id = request.values.get('formula_id')
if formula_id is None:
return redirect(url_for('formula'))
if request.method == 'GET':
page = request.values.get('page')
if page is None:
page = int(1)
page = int(page)
try:
cur = db.cursor()
sql = "select max(qno) from question_detail where formula_id = '%s'" % formula_id
db.ping(reconnect=True)
cur.execute(sql)
question = cur.fetchone()[0]
page_num = int(question / 20 + 0.96)
# 防止页码溢出
if page < 1:
page = int(1)
if page > page_num:
page = int(page_num)
cur = db.cursor()
sql = "select title from SDWZCS.formula_post where formula_id = '%s'" % formula_id
db.ping(reconnect=True)
cur.execute(sql)
title = cur.fetchone()[0]
sql = "select formula_id, qno, content, datetime, nickname from question_detail,SDWZCS.userInformation where question_detail.author = userInformation.email and formula_id = '%s'" % formula_id
db.ping(reconnect=True)
cur.execute(sql)
result = cur.fetchall()
return render_template('detail_question.html',
question_inf=result,
title=title,
page=page,
page_num=page_num,
formula_id=formula_id)
except Exception as e:
raise e
if request.method == 'POST':
content = request.form.get('editorValue')
datetime = date = time.strftime("%Y-%m-%d %H:%M:%S")
username = session.get('user_id')
try:
cur = db.cursor()
sql = "select max(qno) from question_detail where formula_id = '%s'" % formula_id
db.ping(reconnect=True)
cur.execute(sql)
qno = int(cur.fetchone()[0]) + 1
sql = "insert into question_detail(formula_id, qno, content, datetime, author) VALUES ('%s','%s','%s','%s','%s')" % (
formula_id, qno, content, datetime, username)
db.ping(reconnect=True)
cur.execute(sql)
db.commit()
cur.close()
return redirect(url_for('detail_question', formula_id=formula_id))
except Exception as e:
raise e
def get_all_users():
cur = db.cursor()
sql = "select email from user"
db.ping(reconnect=True)
cur.execute(sql)
result = cur.fetchall()
db.commit()
cur.close()
return result
def edit_meeting_to_database(sql):
try:
cur = db.cursor()
db.ping(reconnect=True)
cur.execute(sql)
db.commit()
cur.close()
except Exception as e:
print(e)
def get_sponsor(sid):
try:
cur = db.cursor()
db.ping(reconnect=True)
sql = 'SELECT * FROM sponsors WHERE sponsor_id=%s' % sid
cur.execute(sql)
result = cur.fetchone()
return result
except Exception as e:
print(e)
def add_all_staff_to_meeting(id):
users = get_all_users()
sql = "INSERT INTO need_to_meeting (user_email,meeting_id) VALUES"
for email in users:
sql += "('%s',%s)," % (email[0], id)
sql = sql[:-1] + ";"
cur = db.cursor()
db.ping(reconnect=True)
cur.execute(sql)
db.commit()
cur.close()
def list_meeting_of_user(user_email):
try:
cur = db.cursor()
sql = "select N.meeting_id,meeting_title,meeting_date,meeting_location from meeting AS M,need_to_meeting AS N where user_email='%s' and M.meeting_id = N.meeting_id" % user_email
db.ping(reconnect=True)
cur.execute(sql)
result = cur.fetchall()
return result
except Exception as e:
print(e)
def add_leave_to_leave_history(mid, email, processor):
try:
cur = db.cursor()
sql = "INSERT INTO leave_history(user_email, meeting_id, processor) VALUES ('%s',%s,'%s')" % (
email, mid, processor)
db.ping(reconnect=True)
cur.execute(sql)
db.commit()
cur.close()
except Exception as e:
print(e)
def get_all_meeting_id():
try:
cur = db.cursor()
sql = "select meeting_id from meeting"
db.ping(reconnect=True)
cur.execute(sql)
result = cur.fetchall()
return result
except Exception as e:
print(e)
def list_all_sponsors():
try:
cur = db.cursor()
sql = "select * from sponsors"
db.ping(reconnect=True)
cur.execute(sql)
result = cur.fetchall()
return result
except Exception as e:
print(e)
def add_sponsor(sql):
try:
cur = db.cursor()
db.ping(reconnect=True)
cur.execute(sql)
db.commit()
cur.close()
except Exception as e:
print(e)
def show_issue():
if request.method == 'GET':
email = session.get('email')
try:
cur = db.cursor()
sql = "select ino, email, title, issue_time from Issue where email = '%s' order by issue_time desc" % email
db.ping(reconnect=True)
cur.execute(sql)
issue_detail = cur.fetchall()
except Exception as e:
raise e
return render_template('show_issue.html', issue_detail=issue_detail)
def personal():
if request.method == 'GET':
email = session.get('email')
try:
cur = db.cursor()
sql = "select email, nickname, type, create_time, phone from UserInformation where email = '%s'" % email
db.ping(reconnect=True)
cur.execute(sql)
personal_info = cur.fetchone()
except Exception as e:
raise e
return render_template('personal.html', personal_info=personal_info)
def password_reset():
try:
cur = db.cursor()
sql = "update userInformation set SDWZCS.userInformation.password = '******'12321', method="pbkdf2:sha256",
salt_length=8) + "'where email = 'demo1';"
db.ping(reconnect=True)
cur.execute(sql)
db.commit()
cur.close()
except Exception as e:
raise e
def approve_status(mid, email):
try:
cur = db.cursor()
sql = "update meeting_leave set status='Approved' " \
"where meeting_id=%s and user_email='%s'" % (mid, email)
db.ping(reconnect=True)
cur.execute(sql)
db.commit()
cur.close()
except Exception as e:
print(e)
def source():
if request.method == 'GET':
try:
cur = db.cursor()
sql = "select Fno,filename,file_info,file_time,nickname from Files,UserInformation where Files.email = UserInformation.email"
db.ping(reconnect=True)
cur.execute(sql)
files = cur.fetchall()
cur.close()
return render_template('source.html', files=files)
except Exception as e:
raise e
def formula():
if request.method == 'GET':
page = request.values.get('page')
if page is None:
page = int(1)
page = int(page)
try:
cur = db.cursor()
sql = "select count(*) from SDWZCS.formula_post"
db.ping(reconnect=True)
cur.execute(sql)
db.commit()
result = cur.fetchone()[0]
if result is None:
article_nums = 0
else:
article_nums = int(result)
page_num = int(article_nums / 5 + 0.9)
# 防止页码溢出
if page < 1:
page = int(1)
if page > page_num:
page = int(page_num)
if article_nums > 0:
sql = "select formula_id,title,creat_time,nickname from SDWZCS.formula_post, SDWZCS.userInformation where formula_post.author = userInformation.email order by formula_id DESC "
cur.execute(sql)
db.commit()
result = cur.fetchall()
formula_article = []
for iter in result:
sql = "select content from question_detail where formula_id = '%s' and qno = '1'" % iter[
0]
cur.execute(sql)
db.commit()
content = cur.fetchone()[0]
content = (content, )
formula_article.append(iter[:] + content[:])
# print(formula_article)
cur.close()
return render_template('formula.html',
article_nums=article_nums,
formula_article=formula_article,
page=page,
page_num=page_num)
else:
return render_template('formula.html',
article_nums=article_nums,
page=page,
page_num=page_num)
except Exception as e:
raise e
def formula():
if request.method == 'GET':
try:
cur = db.cursor()
sql = "select Issue.Ino, Issue.email,UserInformation.nickname,issue_time,Issue.title,Comment.comment from Issue,UserInformation,Comment where Issue.email = UserInformation.email and Issue.Ino = Comment.Ino and Cno = '1' order by issue_time DESC "
db.ping(reconnect=True)
cur.execute(sql)
issue_information = cur.fetchall()
cur.close()
return render_template('formula.html',
issue_information=issue_information)
except Exception as e:
raise e
def list_leave_apply_of_user(email):
try:
cur = db.cursor()
sql = "SELECT M.meeting_title,M.meeting_date,L.status FROM meeting AS M,meeting_leave AS L " \
"WHERE M.meeting_id =L.meeting_id AND L.user_email='%s'" % email
db.ping(reconnect=True)
cur.execute(sql)
result = cur.fetchall()
db.commit()
cur.close()
return result
except Exception as e:
print(e)
def apply_leave(email, mid, reason):
try:
status = "Processing"
cur = db.cursor()
sql = "INSERT INTO meeting_leave (meeting_id,user_email,reason,status)VALUES (%s,\"%s\",\"%s\",\"%s\")" % (
mid, email, pymysql.escape_string(reason), status)
db.ping(reconnect=True)
cur.execute(sql)
db.commit()
cur.close()
except Exception as e:
print(e)
def list_all_records():
try:
cur = db.cursor()
sql = "SELECT U.Name,M.meeting_title,M.meeting_date,L.processor " \
"FROM user AS U, meeting AS M, leave_history AS L " \
"WHERE M.meeting_id=L.meeting_id AND U.email=L.user_email"
db.ping(reconnect=True)
cur.execute(sql)
result = cur.fetchall()
db.commit()
cur.close()
return result
except Exception as e:
print(e)
def personal():
cur = db.cursor()
usernameGet = session.get('user_id')
sql = "select email, phone, nickname, usertype, creat_time_user from SDWZCS.userInformation where email = '%s'" % usernameGet
db.ping(reconnect=True)
cur.execute(sql)
userInformation = cur.fetchone()
email = userInformation[0]
phone = userInformation[1]
nickname = userInformation[2]
usertype = userInformation[3]
return render_template('personal.html',
email=email,
phone=phone,
nickname=nickname,
usertype=usertype)
def wrapper(*args, **kwargs):
if session.get('user_id'):
try:
cur = db.cursor()
sql = "select usertype from SDWZCS.userInformation where email = '%s'" % session.get(
'user_id')
db.ping(reconnect=True)
cur.execute(sql)
result = cur.fetchone()
if result[0] == 233:
return func(*args, **kwargs)
cur.close()
except Exception as e:
raise e
else:
return redirect(url_for('homepage'))
return func(*args, **kwargs)
def bug_feedback():
if request.method == 'GET':
return render_template('BugFeedback.html')
elif request.method == 'POST':
name = request.form.get('name')
feedback = request.form.get('feedback')
try:
cur = db.cursor()
sql = "INSERT INTO feedback(name,feedback) VALUES ('%s','%s')" % (
name, pymysql.escape_string(feedback))
db.ping(reconnect=True)
cur.execute(sql)
db.commit()
cur.close()
return redirect(url_for('dashbord'))
except Exception as e:
print(e)
def list_all_leave_requests():
try:
cur = db.cursor()
sql = "select L.meeting_id,U.Name,M.meeting_title,M.meeting_date,L.reason,L.user_email,L.status " \
"from meeting_leave as L, meeting as M, user as U " \
"where U.email=L.user_email and M.meeting_id=L.meeting_id"
db.ping(reconnect=True)
cur.execute(sql)
result = cur.fetchall()
db.commit()
cur.close()
leaves = []
for i in result:
if i[6] == 'Processing':
leaves.append(i)
return leaves
except Exception as e:
print(e)
def my_context_processor():
user_id = session.get('user_id')
if user_id:
try:
cur = db.cursor()
sql = "select nickname,usertype from SDWZCS.userInformation where email = '%s'" % user_id
db.ping(reconnect=True)
cur.execute(sql)
result = cur.fetchone()
cur.close()
if result:
return {
'email': user_id,
'nickname': result[0],
'userType': result[1]
}
except Exception as e:
print('sssssssssssssssss')
raise e
return {}
def technology_Blog():
page = request.values.get('page')
if page is None:
page = int(1)
page = int(page)
try:
cur = db.cursor()
sql = "select count(*) from SDWZCS.blog"
db.ping(reconnect=True)
cur.execute(sql)
db.commit()
result = cur.fetchone()[0]
if result is None:
article_nums = 0
else:
article_nums = int(result)
page_num = int(article_nums / 8 + 0.9)
# 防止页码溢出
if page < 1:
page = int(1)
if page > page_num:
page = int(page_num)
if article_nums > 0:
sql = "select bno,title,creatTime,nickname from SDWZCS.blog, SDWZCS.userInformation where blog.author = userInformation.email order by bno DESC "
cur.execute(sql)
db.commit()
result = cur.fetchall()
cur.close()
return render_template('technology_Blog.html',
article_nums=article_nums,
article=result,
page=page,
page_num=page_num)
else:
return render_template('technology_Blog.html',
article_nums=article_nums,
page=page,
page_num=page_num)
except Exception as e:
raise e
