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'))
