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