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)