def add_wenjuan(): usr = user_model() good = goods() username = session.get('user') family = 'wenjuan' title = request.form['title'] descrip = request.form['descrip'] money = request.form['money'] close_date = request.form['close_date'] people = request.form['people'] error = None usr = user_model() temp = usr.query_userAll_info(username) user_money = int((temp[0])['money']) num = int(people) if user_money < int(money) * num: error = '余额不足,无法发布!' return render_template('add_wenjuan.html', error=error) else: good.add_goods(family, username, title, descrip, money, close_date, people) usr.update_money(username, str(user_money - int(money) * num)) error = '添加成功' return render_template('add_wenjuan.html', error=error)
def regist(): error = None user = user_model() if request.method == 'GET': return render_template("regst.html") username = request.form.get('username') password = request.form.get('password1') repassword = request.form.get('password2') email = request.form.get('email') if request.method == "POST": if password == repassword: user = user_model() user_info = user.query_userAll_info(username) if user_info: error = '用户名重复,请重新输入!' return render_template("regst.html", error=error) else: user.regist(username, password, email) error = '注册成功!' return render_template('login.html', error=error) elif password != repassword: error = "密码不一致,请重新输入!" return render_template("regst.html", error=error) else: return render_template('regst.html', error=error)
def get_password(): error = None username = request.form['username'] if username != '': user = user_model() send_psw = info() password = user.query_user_password(username) if password[0] != '': sender = '*****@*****.**' recipients = user.query_user_email(username) subject = '你好,这是一封系统自动发送的邮件!(请勿回复)' content = 'test' email = (recipients[0])['email'] html = "<b>您的密码是" + (password[0])['password'] + ",请妥善保管</b>" import app app.send_mail(subject, sender, [email], content, html) error = '已发送邮件,请注意查收' return render_template('login.html', error=error) else: error = '请输入正确用户名!' return render_template('contact.html', error=error) else: error = '请输入正确内容!' return render_template('contact.html', error=error)
def post_wenjuan(parm): username = session.get('user') user = user_model() # user_path = user.user_path(username) good = goods() tag_goods = good.query_all_goods(parm) return render_template('wenjuan.html', tag_goods=tag_goods)
def qingqiu(parm): username = parm user = user_model() sender = '*****@*****.**' recipients = user.query_user_email(username) subject = '你好,这是一封自动提醒邮件!(请勿回复)' content = '您已有一份订单被完成,请登陆确认' + + '' html = "<b>" + content + "</b>" print(recipients) email = (recipients[0])['email'] app.send_mail(subject, sender, [email], content, html) return redirect(url_for('user.usercenter'))
def login(): error = None if request.method == 'POST': username = request.form.get('username') password = request.form.get('password') user = user_model(username) rl_password = user.query_user_password(username) new = rl_password[0] if new['password'] == str(password): session['user'] = username return render_template('home.html') else: error = '密码或用户名错误,请重新输入!' return render_template('login.html', error=error) elif request.method == "GET": return render_template('login.html', error=error)
def usercenter2(): username = session.get('user') user = user_model() user_content = info() # user_path = user.user_path(username) userAll_info = user.query_userAll_info(username) userAll_Done_display = user.query_userAll_display((userAll_info[0])['id'], 'done') userAll_undo_display = user.query_userAll_display((userAll_info[0])['id'], 'undo') userAll_display = user.query_userAll(username) chatRoom = user_content.query_TOuser(username) # if user_path: # user_path = "../static/user_head/200.png" return render_template('usercen2.html', chatRoom=chatRoom, userAll_info=userAll_info, userAll_Done_display=userAll_Done_display, userAll_undo_display=userAll_undo_display, userAll_display=userAll_display)
def add_info(to_username): user = user_model() username = session.get('user') content = request.form['info'] tag = '' if tag == 'yes': sender = '*****@*****.**' recipients = [user.query_user_email(to_username)] subject = '你好,这是一封自动提醒邮件!(请勿回复)' html = "<b>" + content + "</b>" infomation = info() email = (recipients[0])['email'] import app app.send_mail(subject, sender, [email], content, html) infomation.insert_info(username, to_username, content) return redirect(url_for('info.show_info')) else: infomation = info() infomation.insert_info(username, to_username, content) return redirect(url_for('info.show_info'))
def home(): username = session.get('user') user = user_model() user_path = user.user_path(username) return render_template('home.html', user_path=user_path)
def shoping(tag): error = None infoma = info() if tag == 'task': error = None username = session.get('user') goods_id = request.form['goods_id'] good = goods() to_username = good.query_goodsByid(goods_id) user = user_model() sender = '*****@*****.**' recipients = user.query_user_email(username) email_temp = user.query_user_email((to_username[0])['username']) email = (email_temp[0])['email'] subject = '你好,这是一封自动提醒邮件!(请勿回复)' to_email = (recipients[0])['email'] content = '注意,您的一份订单已被用户' + email + '关注,请及时联系对方!' html = "<b>" + content + "</b>" import app app.send_mail(subject, sender, [to_email], content, html) error = '已成功向对方发送提醒邮件,请及时与对方联系!' return render_template('user_center.html', error=error) ''' username = session.get('user') goods_id = request.form['goods_id'] usr = user_model() good = goods() temp = usr.query_userAll_info(username) temp1 = good.query_money(goods_id) temp2 = good.query_user(goods_id) user_money = int((temp[0])['money']) goods_money = int((temp1[0])['money']) goods_user = str((temp2[0])['username']) id = int(goods_id) do =infoma.query_tagdo(id) do_tag = (do[0])['tag'] if do_tag == 'done': error = '已成功向对方发送完成提醒邮件,请及时与对方联系!' money=user_money usr.update_money(username, money) return redirect(url_for('user.usercener',error=error)) else: error='订单还未完成,请尽快完成' return redirect(url_for('user.usercener',error=error)) ''' elif tag == 'wenjuan': ''' error = None username = session.get('user') goods_id = request.form['goods_id'] usr = user_model() good = goods() temp = usr.query_userAll_info(username) temp1 = good.query_money(goods_id) temp2 = good.query_user(goods_id) user_money = int((temp[0])['money']) goods_money = int((temp1[0])['money']) goods_user = str((temp2[0])['username']) temp3 = usr.query_userAll_info(goods_user) goods_user_money = int((temp3[0])['money']) if user_money < goods_money: error = '错误,你的余额不足!' return render_template('', error=error) else: money = user_money - goods_money goods_user_money = goods_user_money + goods_money usr.update_money(username, money) usr.update_money(goods_user, goods_user_money) return redirect(url_for('user.usercenter', error=error)) ''' elif tag == 'second': error = None username = session.get('user') goods_id = request.form['goods_id'] good = goods() to_username = good.query_goodsByid(goods_id) user = user_model() sender = '*****@*****.**' recipients = user.query_user_email(username) email_temp = user.query_user_email((to_username[0])['username']) email = (email_temp[0])['email'] subject = '你好,这是一封自动提醒邮件!(请勿回复)' to_email = (recipients[0])['email'] content = '注意,您的一份商品已被用户' + email + '关注,请及时联系对方!' html = "<b>" + content + "</b>" import app app.send_mail(subject, sender, [to_email], content, html) error = '已成功向对方发送提醒邮件,请及时与对方联系!' return render_template('user_center.html', error=error) '''