def sendmail(req): if req.method == 'POST': mf = ModifyForm(req.POST) if mf.is_valid(): username = mf.cleaned_data['username'] if User.objects.filter(username=username): a = User.objects.get(username=username) b = a.userinfo_set.all()[0] email = b.email message = ''.join( random.sample(string.ascii_letters + string.digits, 4)) req.session['validate'] = message req.session['username'] = username title = "修改银翼网盘密码验证邮件!." # message = 'Hello! This is a message!' sender = '*****@*****.**' mail_list = [ email, ] send_mail(subject=title, message=message, from_email=sender, recipient_list=mail_list, fail_silently=False, connection=None) return HttpResponseRedirect('/online/validate/') else: error = '该用户名不存在' return render_to_response('modify_new.html', {'error': error}, context_instance=RequestContext(req)) else: mf = ModifyForm() return render_to_response('modify_new.html', context_instance=RequestContext(req))
def modify(todolist_id): form_t = TodoListForm() form_m = ModifyForm() todolist = TodoList.query.get_or_404(todolist_id) if form_m.validate_on_submit(): #???????????????? #此处要用正则才能取得所需数据 # content=re.findall(regex,str(form_m.content))[0] # todolist.content=u'%s' % content #如果使用下面这句代码替代上述2句,提交的结果是一个html标记 #todolist.content = u'%s' % str(form_m.content) #????????????????? todolist.content = request.form['content'] db.session.add(todolist) db.session.commit() return redirect(url_for('index')) #todolists=TodoList.query.all() page_index = request.args.get('page', 1, type=int) query = TodoList.query.order_by(TodoList.create_time.desc()) pagination = query.paginate(page_index, per_page=10, error_out=False) todolists = pagination.items return render_template('index.html', todolists=todolists, form=form_t, form_m=form_m, pagination=pagination)
def change_paste(id): if request.method == "GET": pasteList = PasteText.query.filter_by(id=id).first_or_404() form = ModifyForm() form.content.data = pasteList.content return render_template("modify.html", form=form) else: form = ModifyForm() if form.validate_on_submit(): pasteList = PasteText.query.filter_by(id=id).first_or_404() pasteList.content = form.content.data pasteList.status = form.status.data db.session.commit() flash("You have modify a pasteList") else: flash(form.errors) return redirect(url_for("show_paste_list"))
def erecord(): status = request.args.get('status') allnum = db.session.query(Erecord).count() nsolvenum = db.session.query(Erecord).filter( Erecord.solve == False).count() nverifynum = db.session.query(Erecord).filter( Erecord.verify == False).count() oknum = db.session.query(Erecord).filter(Erecord.verify == True).filter( Erecord.mender != '').filter(Erecord.solve == True).count() nobody = db.session.query(Erecord).filter(Erecord.mender == '').count() print status if status == '2': results = db.session.query(Erecord).filter( Erecord.verify == False).order_by(-Erecord.id) elif status == '3': results = db.session.query(Erecord).filter( Erecord.solve == False).order_by(-Erecord.id) elif status == '4': results = db.session.query(Erecord).filter( Erecord.verify == True).filter(Erecord.mender != '').filter( Erecord.solve == True).order_by(-Erecord.id) elif status == '5': results = db.session.query(Erecord).filter( Erecord.mender == '').order_by(-Erecord.id) else: results = db.session.query(Erecord).order_by(-Erecord.id) form = ModifyForm() if form.validate_on_submit(): return redirect(url_for('admin.emodify', id=form.id.data)) return render_template('admin/erecord.html', results=results, form=form, nsolvenum=nsolvenum, nverifynum=nverifynum, oknum=oknum, allnum=allnum, nobody=nobody)
def record(): results = db.session.query(Record).order_by(-Record.id) form = ModifyForm() if form.validate_on_submit(): return redirect(url_for('admin.modify', id=form.id.data)) return render_template('admin/record.html', results=results, form=form)
def comment(): comment = db.session.query(Comment).order_by(-Comment.id) form = ModifyForm() if form.validate_on_submit(): return redirect(url_for('admin.commentmodify', id=form.id.data)) return render_template('admin/comment.html', form=form, comment=comment)
def admin_modify_user(username): if not session.get('loggedin') or session.get('role') != 0: return redirect(url_for('login')) form = ModifyForm() if request.method == 'POST': #insert email = form.email.data password = form.password.data if password != '': password_hash = generate_password_hash(password, method='sha256') sql_query = '''UPDATE departments SET dept_email = %s, password = %s where dept_name = %s ''' try: cursor = db.cursor() cursor.execute(sql_query, ( email, password_hash, username, )) cursor.close() db.commit() except Exception as e: db.rollback() print("Error while modifying user", e) else: flash(f'Modified user {username}.', 'success') else: sql_query = '''UPDATE departments SET dept_email = %s where dept_name = %s ''' try: cursor = db.cursor() cursor.execute(sql_query, ( email, username, )) cursor.close() db.commit() except Exception as e: db.rollback() print("Error while modifying user", e) else: flash(f'Modified user {username}.', 'success') for dep in dept: if dep[1] == username: dep[2] = email return redirect(url_for('admin_list_users')) cursor = db.cursor() cursor.execute( 'SELECT dept_id,dept_name,dept_email FROM departments where dept_name = %s', (username, )) departments_data = cursor.fetchone() cursor.close() form.username.data = username form.email.data = departments_data[2] return render_template('admin_modify_user.html', form=form, logout=url_for('logout'), back=url_for('admin_list_users'))