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