def login(): mysql_conn = pymysql.connect(host='localhost', port=3306, user='******', passwd='0000', db='pms', charset='utf8') mysql_cur = mysql_conn.cursor() if request.method == 'POST': User_ID = request.form.get('User_ID') Password = request.form.get('Password') user = users.query.filter_by(User_ID=User_ID).first() if user is not None and user.check_password(Password): login_user(user) user_action(User_ID, "login") print(current_user.get_privilege()) if current_user.get_privilege() == '1': return redirect(url_for('pms.kanban')) elif current_user.get_privilege() == '2': return redirect(url_for('pms.kanban')) elif current_user.get_privilege() == '3': return redirect(url_for('pms.kanban')) mysql_cur.close() mysql_conn.close() return render_template('login.html')
def index(query=None): page = request.args.get('page', 1, type=int) query = request.args.get('q', '').strip() privi = current_user.get_privilege("公司列表") if query: query = query.replace("'", "") c = (Company.name.like('%{}%'.format(query)), Company.profile.like('%{}%'.format(query))) companys = Company.query.filter(c).order_by(Company.id) companys = Company.query.order_by(Company.id) pagination = companys.paginate(page, current_app.config['POSTS_PER_PAGE'], False) # next_url = url_for('main.user_index', page=pagination.next_num, q=query) if pagination.has_next else None # prev_url = url_for('main.user_index', page=pagination.prev_num, q=query) if pagination.has_prev else None searchform = SearchForm() searchform.q.data = query #print(len(pagination.items)) return render_template('company/index.html', companys=pagination.items, pagination=pagination, title='企业列表', page=page, form=searchform, q=query)
def user_index(query=None): page = request.args.get('page', 1, type=int) query = request.args.get('q', '').strip() privi = current_user.get_privilege("用户列表") c = current_user.can_see_users(privi) if query: query = query.replace("'", "") c = or_(User.name.like('%{}%'.format(query)), User.username.like('%{}%'.format(query))) c = or_(User.position.like('%{}%'.format(query)), c) c = and_(current_user.can_see_users(privi), c) users = User.query.filter(c).order_by(User.id) pagination = users.paginate(page, current_app.config['POSTS_PER_PAGE'], False) # next_url = url_for('main.user_index', page=pagination.next_num, q=query) if pagination.has_next else None # prev_url = url_for('main.user_index', page=pagination.prev_num, q=query) if pagination.has_prev else None searchform = UserSearchForm() searchform.q.data = query return render_template('main/user/index.html', users=pagination.items, pagination=pagination, title='用户列表', page=page, form=searchform, q=query)
def database_log(): user_action(current_user.get_id(), "database_log") return render_template('database_log.html', priviledge=current_user.get_privilege())
def jianyi(): user_action(current_user.get_id(), "jianyi") return render_template('data_assert_manager_jianyi.html', priviledge=current_user.get_privilege())
def sys_manager_privilege(): user_action(current_user.get_id(), "sys_manager_privilege") return render_template('sys_manager_privilege.html', priviledge=current_user.get_privilege())
def youhua(): user_action(current_user.get_id(), "youhua") return render_template('data_assert_manager_youhua.html', priviledge=current_user.get_privilege())
def pj_rongyudu(): user_action(current_user.get_id(), "pj_rongyudu") return render_template('data_assert_manager_pj_rongyudu.html', priviledge=current_user.get_privilege())
def pj_tianchong(): user_action(current_user.get_id(), "pj_tianchong") return render_template('data_assert_manager_pj_tianchong.html', priviledge=current_user.get_privilege())
def pingjia(): user_action(current_user.get_id(), "pingjia") return render_template('data_assert_manager_pingjia.html', priviledge=current_user.get_privilege())
def kanban(): user_action(current_user.get_id(), "kanban") return render_template('data_assert_maneger_kanban.html', priviledge=current_user.get_privilege())