def dataRenew():
if request.method == 'POST':
dId = request.form['dataId']
try:
db_session.query(data).filter(data.dataId == dId).update({
'supposedReturnTime':
(datetime.datetime.now() +
datetime.timedelta(15)).strftime('%Y-%m-%d')
})
db_session.commit()
return "<script>alert('恭喜，续借成功！');window.location = '/datasView' </script>"
except Exception, exp:
return str(exp)
def userInfoView():
if 'currentUserId' not in session or session['currentUserId'] == None:
return "<script>window.location = '/userLogin'</script>"
else:
currentUserId = session['currentUserId']
currentUser = db_session.query(user).filter(user.userId == currentUserId).one()
return render_template('userPage/userInfoView.html',title = '个人信息',user = currentUser)
def dataReturn():
if request.method == 'POST':
dId = request.form['dataId']
try:
db_session.query(data).filter(data.dataId == dId).update({
'supposedReturnTime':
None,
'borrowTime':
None,
'borrowStatus':
False,
'borrowerId':
None,
})
db_session.commit()
return "<script>alert('恭喜,还书成功！');window.location = '/datasView' </script>"
except Exception, exp:
return str(exp)
def dataInfo(dataId):
currentData = db_session.query(data).filter(data.dataId == dataId).one()
return render_template(
'dataPage/dataInfo.html',
currentData=currentData,
title=currentData.dataName,
currentDate=datetime.datetime.now().strftime('%Y-%m-%d'),
supposedReturnDate=(datetime.datetime.now() +
datetime.timedelta(15)).strftime('%Y-%m-%d'))
def myMesseges():
if 'currentUserId' not in session or session['currentUserId'] == None:
return '别乱点'
else:
selectedMsgs = db_session.query(msgToUser).filter(
msgToUser.userId == session['currentUserId']).all()
return render_template('userPage/myMesseges.html',
selectedMsgs=selectedMsgs,
title='我的信息')
def myBorrows():
if 'currentUserId' not in session or session['currentUserId'] == None:
return '<script>alert("非法操作");' \
'window.location = "/"' \
'</script>'
else:
datas = db_session.query(data).filter(
data.borrowerId == session['currentUserId']).all()
return render_template('dataPage/datasView.html',
datas=datas,
title='我的借阅')
def messege(messegeId):
selectedMsgs = db_session.query(msgToUser).filter(
msgToUser.msgId == messegeId).all()
if selectedMsgs == []:
return "<script>alert('没这个消息→_→别乱点');window.location='/'</script>"
elif selectedMsgs[0].userId != session['currentUserId'] or session[
'currentUserId'] == None:
return "<script>alert('这消息不是你的→_→别乱看');window.location='/'</script>"
else:
return render_template('userPage/messege.html',
title=selectedMsgs[0].msgTitle,
msg=selectedMsgs[0])
def dataSearch():
if request.args.get('searchContent') != None:
searchContent = str(request.args.get('searchContent'))
print str('%' + searchContent[1:-1] + '%')
"""
前端传来的searchContent为字符串，带双引号，下面[1:-1]是将开头双引号去除
"""
datas = db_session.query(data).filter(
data.dataName.like('%' + searchContent[1:-1] + '%')).all()
return render_template('dataPage/datasView.html',
title=str(searchContent + '的相关搜索'),
datas=datas)
else:
return "<script>alert('非法操作');" \
"window.location='/'</script>"
def reg():
if request.method == 'POST':
registerData = json.loads(request.form.get('data'))
msg = ''
userName_input = registerData['userName']
password_input = registerData['password']
name_input = registerData['name']
users = db_session.query(user).filter(user.userName==userName_input).all()
if users == []:
newUser = user(userName = userName_input,password = password_input,name = name_input)
db_session.add(newUser)
db_session.commit()
db_session.close()
msg = 'success'
else:
msg = '用户名已被注册'
return str(msg)
else:
return '哥们你又乱输网址。。。。。'
def signIn():
if request.method == 'POST':
loginData = json.loads(request.form.get('data'))
msg = ''
userName_input = loginData['userName']
password_input = loginData['password']
users = db_session.query(user).filter(user.userName==userName_input).all()
if users == []:
msg = 'user not exists'
else:
checkedUser = users[0]
if checkedUser.password == password_input:
session['name'] = checkedUser.name
session['currentUserId'] = checkedUser.userId
msg = 'success'
else :
msg = 'passwordError'
return str(msg)
else:
return '哥们你又乱输网址。。。。。'
def datasView():
datas = db_session.query(data).filter().all()
return render_template('dataPage/datasView.html',
title='资料浏览',
datas=datas)
