def auth_setting_add():
add_form = AddForm()
task_info = ticket_status()
if add_form.validate_on_submit():
user = User(
username=add_form.username.data,
password=add_form.password.data,
alias=add_form.alias.data,
role=add_form.role.data,
cellphone=add_form.cellphone.data,
email=add_form.email.data,
manage=add_form.manage.data
)
add_sql = edit(user, "username", record=False)
add_sql.run('add')
flash(u'用户添加成功')
else:
for th in start_thead:
key = th[2]
if add_form.errors.get(key, None):
flash(add_form.errors[key][0])
break
return render_template('auth/add.html', task_info=task_info, sidebar=sidebar,
add_form=add_form)
def users_delete():
del_id = int(request.form["id"])
user = User.query.filter_by(id=del_id).first()
if user:
delete_sql = edit(current_user.username, user, "username", user.username)
delete_sql.run('delete')
return "OK"
return u"删除失败 没有找到该用户"
def auth_setting_delete():
del_id = int(request.form["id"])
reason = request.form["reason"]
user = User.query.filter_by(id=del_id).first()
if user:
delete_sql = edit(user, "username", reason, record=False)
delete_sql.run('delete')
return "OK"
return u"删除失败 没有找到该用户"
def users_delete():
del_id = int(request.form["id"])
user = User.query.filter_by(id=del_id).first()
if user:
delete_sql = edit(current_user.username, user, "username",
user.username)
delete_sql.run('delete')
return "OK"
return u"删除失败 没有找到该用户"
def users_batch_delete():
list_id = eval(request.form["list_id"])
for id in list_id:
user = User.query.filter_by(id=id).first()
if not user:
return u"删除失败 没有找到这些用户"
for id in list_id:
user = User.query.filter_by(id=id).first()
delete_sql = edit(current_user.username, user, "username", user.username)
delete_sql.run('delete')
return "OK"
def users_batch_delete():
list_id = eval(request.form["list_id"])
for id in list_id:
user = User.query.filter_by(id=id).first()
if not user:
return u"删除失败 没有找到这些用户"
for id in list_id:
user = User.query.filter_by(id=id).first()
delete_sql = edit(current_user.username, user, "username",
user.username)
delete_sql.run('delete')
return "OK"
def auth_setting_batch_delete():
list_id = eval(request.form["list_id"])
reason = request.form["reason"]
for id in list_id:
user = User.query.filter_by(id=id).first()
if not user:
return u"删除失败 没有找到这些用户"
for id in list_id:
user = User.query.filter_by(id=id).first()
delete_sql = edit(user, "username", reason, record=False)
delete_sql.run('delete')
return "OK"
def users_change():
change_id = int(request.form["id"])
item = request.form["item"]
value = request.form['value']
user = User.query.filter_by(id=change_id).first()
if user:
verify = CustomValidator(item,value)
result = verify.validate_return()
if result == "OK":
change_sql = edit(current_user.username, user, item, value)
change_sql.run('change')
return "OK"
return result
return u"更改失败 没有找到该用户"
def users_change():
change_id = int(request.form["id"])
item = request.form["item"]
value = request.form['value']
user = User.query.filter_by(id=change_id).first()
if user:
verify = CustomValidator(item, value)
result = verify.validate_return()
if result == "OK":
change_sql = edit(current_user.username, user, item, value)
change_sql.run('change')
return "OK"
return result
return u"更改失败 没有找到该用户"
def auth_setting_change():
change_id = int(request.form["id"])
item = request.form["item"]
value = request.form['value']
user = User.query.filter_by(id=change_id).first()
if user:
verify = CustomValidator(item,value)
result = verify.validate_return()
if result == "OK":
change_sql = edit(user, item, value, record=False)
change_sql.run('change')
return "OK"
return result
return u"更改失败 没有找到该用户"
def ticket():
ticket_form = TicketForm()
sidebar = copy.deepcopy(start_sidebar)
sidebar = init_sidebar(sidebar, now, 'put_task')
if request.method == "GET":
search_value = request.args.get('search', '')
if search_value:
sidebar = init_sidebar(sidebar, now, "my_task")
page = int(request.args.get('page', 1))
result = search(Task, 'title', search_value)
result = result.search_return()
if result:
pagination = result.paginate(page, 100, False)
items = pagination.items
return render_template('task/ticket.html',
sidebar=sidebar,
ticket_form=ticket_form,
search_value=search_value,
thead=thead,
pagination=pagination,
endpoint=endpoint,
items=items)
if request.method == "POST":
if request.form['action'] == 'put_task':
idebar = init_sidebar(sidebar, now, 'put_task')
if ticket_form.validate_on_submit():
task = Task(author=current_user.username,
title=ticket_form.title.data,
task=ticket_form.task.data,
site=ticket_form.site.data,
body=ticket_form.body.data,
status=u"审核")
add_sql = edit(current_user.username,
task,
"title",
record=False)
add_sql.run('add')
flash(u'任务添加成功 可以继续添加新的任务')
else:
for key in check_field:
if ticket_form.errors.get(key, None):
flash(ticket_form.errors[key][0])
break
return render_template('task/ticket.html',
sidebar=sidebar,
thead=thead,
ticket_form=ticket_form)
def action(id):
task = Task.query.get_or_404(id)
action_form = ActionForm()
if request.method == "POST":
if action_form.validate_on_submit():
reply = Reply(
task_id = task.id,
user = current_user.alias,
body = action_form.body.data
)
add_sql = edit(current_user.username, reply, "task_id", record=False)
add_sql.run('add')
# 回复成功后重定向回改网页
return redirect(url_for('.action', id=post.id))
else:
flash(action_form.errors['body'][0])
return render_template('task/action.html', sidebar=start_sidebar)
def auth_setting_changepassword():
changepassword_form = ChangePasswordForm()
task_info = ticket_status()
if changepassword_form.validate_on_submit():
if current_user.verify_password(changepassword_form.old_password.data):
value = changepassword_form.password.data
change_sql = edit(current_user, "password", value, record=False)
change_sql.run('change')
flash(u'密码更改成功')
else:
flash(u'旧密码错误')
else:
for key in changepassword_form.errors.keys():
flash(changepassword_form.errors[key][0])
return render_template('auth/change.html', task_info=task_info, sidebar=sidebar,
changepassword_form=changepassword_form)
def action(id):
task = Task.query.get_or_404(id)
action_form = ActionForm()
if request.method == "POST":
if action_form.validate_on_submit():
reply = Reply(task_id=task.id,
user=current_user.alias,
body=action_form.body.data)
add_sql = edit(current_user.username,
reply,
"task_id",
record=False)
add_sql.run('add')
# 回复成功后重定向回改网页
return redirect(url_for('.action', id=post.id))
else:
flash(action_form.errors['body'][0])
return render_template('task/action.html', sidebar=start_sidebar)
def ticket():
ticket_form = TicketForm()
sidebar = copy.deepcopy(start_sidebar)
sidebar = init_sidebar(sidebar, now, 'put_task')
if request.method == "GET":
search_value = request.args.get('search', '')
if search_value:
sidebar = init_sidebar(sidebar, now, "my_task")
page = int(request.args.get('page', 1))
result = search(Task, 'title' , search_value)
result = result.search_return()
if result:
pagination = result.paginate(page, 100, False)
items = pagination.items
return render_template(
'task/ticket.html', sidebar=sidebar, ticket_form=ticket_form,
search_value=search_value, thead=thead, pagination=pagination,
endpoint=endpoint, items=items
)
if request.method == "POST":
if request.form['action'] == 'put_task':
idebar = init_sidebar(sidebar, now,'put_task')
if ticket_form.validate_on_submit():
task = Task(
author=current_user.username,
title=ticket_form.title.data,
task=ticket_form.task.data,
site=ticket_form.site.data,
body=ticket_form.body.data,
status=u"审核"
)
add_sql = edit(current_user.username, task, "title", record=False )
add_sql.run('add')
flash(u'任务添加成功 可以继续添加新的任务')
else:
for key in check_field :
if ticket_form.errors.get(key, None):
flash(ticket_form.errors[key][0])
break
return render_template(
'task/ticket.html', sidebar=sidebar, thead=thead, ticket_form=ticket_form
)
def auth_setting_batch_change():
list_id = eval(request.form["list_id"])
item = request.form["item"]
value = request.form["value"]
for id in list_id:
user = User.query.filter_by(id=id).first()
if user:
verify = CustomValidator(item, value)
result = verify.validate_return()
if not result == "OK":
return result
else:
return u"更改失败 没有找到这些用户"
for id in list_id:
user = User.query.filter_by(id=id).first()
change_sql = edit(user, item, value, record=False)
change_sql.run('change')
return "OK"
def users_batch_change():
list_id = eval(request.form["list_id"])
item = request.form["item"]
value = request.form["value"]
for id in list_id:
user = User.query.filter_by(id=id).first()
if user:
verify = CustomValidator(item, value)
result = verify.validate_return()
if not result == "OK":
return result
else:
return u"更改失败 没有找到这些用户"
for id in list_id:
user = User.query.filter_by(id=id).first()
change_sql = edit(current_user.username, sales, item, value)
change_sql.run('change')
return "OK"
def users_batch_change():
list_id = eval(request.form["list_id"])
item = request.form["item"]
value = request.form["value"]
for id in list_id:
user = User.query.filter_by(id=id).first()
if user:
verify = CustomValidator(item, value)
result = verify.validate_return()
if not result == "OK":
return result
else:
return u"更改失败 没有找到这些用户"
for id in list_id:
user = User.query.filter_by(id=id).first()
change_sql = edit(current_user.username, sales, item, value)
change_sql.run('change')
return "OK"
def users_setting():
'''用户设置'''
role_permission = getattr(Permission, current_user.role)
passwd_form = ChangePasswordForm()
register_form = RegistrationForm()
sidebar = copy.deepcopy(start_sidebar)
thead = copy.deepcopy(start_thead)
sidebar = init_sidebar(sidebar, now, 'passwd')
search_value = ''
if request.method == "POST":
# 更改密码
if request.form['action'] == 'passwd':
sidebar = init_sidebar(sidebar, now, 'passwd')
if passwd_form.validate_on_submit():
if current_user.verify_password(passwd_form.old_password.data):
value = passwd_form.password.data
change_sql = edit(current_user.username, current_user,
"password", value)
change_sql.run('change')
flash(u'密码更改成功')
else:
flash(u'旧密码错误')
else:
for key in passwd_form.errors.keys():
flash(passwd_form.errors[key][0])
# 用户注册
if request.form[
'action'] == 'register' and role_permission >= Permission.ADMIN:
sidebar = init_sidebar(sidebar, now, 'register')
if register_form.validate_on_submit():
user = User(username=register_form.username.data,
password=register_form.password.data,
alias=register_form.alias.data,
role=register_form.role.data)
add_sql = edit(current_user.username, user, "username")
add_sql.run('add')
flash(u'用户添加成功')
else:
for thead in start_thead:
key = thead[2]
if register_form.errors.get(key, None):
flash(register_form.errors[key][0])
break
if request.method == "GET":
search_value = request.args.get('search', '')
checkbox = request.args.getlist('hidden') or request.args.get(
'hiddens', '')
if search_value:
# 搜索
thead = init_checkbox(thead, checkbox)
sidebar = init_sidebar(sidebar, now, 'edituser')
page = int(request.args.get('page', 1))
result = search(User, 'username', search_value)
result = result.search_return()
if result:
pagination = result.paginate(page, 100, False)
items = pagination.items
return render_template('auth/setting.html',
sidebar=sidebar,
passwd_form=passwd_form,
register_form=register_form,
search_value=search_value,
checkbox=str(checkbox),
thead=thead,
endpoint=endpoint,
pagination=pagination,
items=items)
return render_template('auth/setting.html',
sidebar=sidebar,
search_value=search_value,
passwd_form=passwd_form,
register_form=register_form,
thead=thead)
def users_setting():
'''用户设置'''
role_permission = getattr(Permission, current_user.role)
passwd_form = ChangePasswordForm()
register_form = RegistrationForm()
sidebar = copy.deepcopy(start_sidebar)
thead = copy.deepcopy(start_thead)
sidebar = init_sidebar(sidebar, now,'passwd')
search_value = ''
if request.method == "POST":
# 更改密码
if request.form['action'] == 'passwd':
sidebar = init_sidebar(sidebar, now,'passwd')
if passwd_form.validate_on_submit():
if current_user.verify_password(passwd_form.old_password.data):
value = passwd_form.password.data
change_sql = edit(current_user.username, current_user, "password", value)
change_sql.run('change')
flash(u'密码更改成功')
else:
flash(u'旧密码错误')
else:
for key in passwd_form.errors.keys():
flash(passwd_form.errors[key][0])
# 用户注册
if request.form['action'] == 'register' and role_permission >= Permission.ADMIN:
sidebar = init_sidebar(sidebar, now,'register')
if register_form.validate_on_submit():
user = User(
username=register_form.username.data,
password=register_form.password.data,
alias=register_form.alias.data,
role=register_form.role.data
)
add_sql = edit(current_user.username, user, "username")
add_sql.run('add')
flash(u'用户添加成功')
else:
for thead in start_thead:
key = thead[2]
if register_form.errors.get(key, None):
flash(register_form.errors[key][0])
break
if request.method == "GET":
search_value = request.args.get('search', '')
checkbox = request.args.getlist('hidden') or request.args.get('hiddens', '')
if search_value:
# 搜索
thead = init_checkbox(thead, checkbox)
sidebar = init_sidebar(sidebar, now,'edituser')
page = int(request.args.get('page', 1))
result = search(User, 'username' , search_value)
result = result.search_return()
if result:
pagination = result.paginate(page, 100, False)
items = pagination.items
return render_template(
'auth/setting.html', sidebar=sidebar, passwd_form=passwd_form,
register_form=register_form, search_value=search_value,
checkbox=str(checkbox), thead=thead, endpoint=endpoint,
pagination=pagination, items=items
)
return render_template(
'auth/setting.html',sidebar=sidebar, search_value=search_value,
passwd_form=passwd_form, register_form=register_form,
thead=thead
)
