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