def profile():
userInfo = db_manager.getUserInfo(session['osis'])
buddy = ["N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]
if userInfo[4] != "":
buddy = db_manager.getUserInfo(userInfo[4])
locker = db_manager.getLockerInfo(userInfo[2], session['osis'])
transactions=db_manager.getTransactionInfo(session['osis'])
changed=db_manager.ifDissolve(session["osis"])
return render_template("home.html", heading="Profile", userInfo=userInfo, buddy=buddy, locker=locker, transactions=transactions , user=session['osis'], changed=changed)
def bsearch():
query=["","","","","","","","",""]
if request.form.get("searchtype") == "osis":
query[0] = request.form.get("input")
else:
query[1] = request.form.get("input")
query[2] = request.form.get("sports")
query[3] = request.form.get("textbook")
query[4] = request.form.get("grade")
query[5] = request.form.get("gender")
query[6] = request.form.get("floor")
query[7] = request.form.get("location")
query[8] = request.form.get("level")
results = db_manager.filter(query,session["osis"])
length=len(results)
buddy=[]
locker=[]
loop=[]
survey =[]
count = 0
for value in range(len(results)):
info = db_manager.getUserInfo(results[value])
buddy.append(info)
temp=db_manager.getLockerInfo(info[2],info[0])
locker.append(temp)
loop.append(count)
temp=["", ""]
if info[5] != "":
temp = info[5].split("|")
survey.append(temp)
count+=1
to = db_manager.getTransactionTo(session["osis"])
sender = db_manager.getTransactionFrom(session["osis"])
user=session['osis']
return render_template("buddy.html" , query=query,buddy=buddy,locker=locker, to = to, sender = sender, loop=loop, survey=survey, length=length, user=user)
def market():
user = session['osis']
locker = db_manager.getUserInfo(user)[2]
if (locker == ''):
flash("You do not have a locker!", 'danger')
return redirect('/home')
if (db_manager.getLockerInfo(locker,user)[6] == 'TRADING'):
flash("Locker already on market!", 'danger')
return redirect('/home')
db_manager.putOnMarket(locker,user)
return redirect("/home")
def stats():
osis = session["osis"]
grade = db_manager.getUserInfo(osis)[3]
#user registration
userRegistration_grade = db_manager.getColumnInfo("grade", "user")
#locker regisgration
lockerRegistration_floor = db_manager.getColumnInfo("floor", "locker")
lockerRegistration_location = db_manager.getColumnInfo("location", "locker")
#buddies avaiable
buddyAvailable_grade = db_manager.getColumnInfo_Specific("grade", "user", "buddy is null or buddy = '' ")
for user in buddyAvailable_grade:
if user == grade:
buddyAvailable_grade.remove(user)
listOfOsis = db_manager.getColumnInfo_Specific("osis", "user", "buddy is null or buddy = ''")
for user in listOfOsis:
if user == osis:
listOfOsis.remove(user)
temp_floor = []
temp_location = []
buddyAvailable_floor = []
buddyAvailable_location = []
for user in listOfOsis:
temp_floor.append(db_manager.getColumnInfo_Specific("floor", "locker", "owner = " + str(user)))
for list in temp_floor:
if len(list) != 0 and isinstance(list[0], int):
buddyAvailable_floor.append(list[0])
for user in listOfOsis:
temp_location.append(db_manager.getColumnInfo_Specific("location", "locker", "owner = " + str(user)))
for list in temp_location:
if len(list) != 0 and list[0] != '':
buddyAvailable_location.append(list[0])
#lockers available
lockersAvailable_floor = db_manager.getColumnInfo_Specific("floor", "locker", "status = 'TRADING'")
lockersAvailable_location = db_manager.getColumnInfo_Specific("location", "locker", "status = 'TRADING'")
# temp_location = db_manager.getColumnInfo_Specific("locker", "transaction", "status = 1")
# parsed_location = []
# for locker in temp_location:
# if isinstance(locker, int):
# parsed_location.append(locker)
# temp_location1 = db_manager.getColumnInfo_Specific("floor", "transaction", "status = 1")
# parsed_location1 = []
# for floor in temp_location1:
# if isinstance(floor, int):
# parsed_location1.append(floor)
# lockersAvailable_location = []
# index = -1
# for locker in parsed_location:
# index += 1
# lockersAvailable_location.append(db_manager.getColumnInfo_Specific("location", "locker", "locker = " + str(locker) + " AND floor = " + str(parsed_location1[index])))
return render_template("stat.html", title="Stats", userRegistration_grade=userRegistration_grade, lockerRegistration_floor=lockerRegistration_floor, lockerRegistration_location=lockerRegistration_location,
buddyAvailable_grade=buddyAvailable_grade, buddyAvailable_floor=buddyAvailable_floor, buddyAvailable_location=buddyAvailable_location, lockersAvailable_floor=lockersAvailable_floor,
lockersAvailable_location=lockersAvailable_location)
def notifs():
looper=[]
buddy=[]
locker=[]
dissolve = []
all = db_manager.getAllNotifs(session["osis"])
for value in range(len(all)):
looper.append(value)
for value in all:
if(value[4] != "L"):
temp=db_manager.getUserInfo(value[2])
temp[5]=temp[5].split("|")
buddy.append(temp)
if(value[4] == "L"):
them = db_manager.getUserInfo(value[2])
locker.append(db_manager.getLockerInfo(them[2],them[0]))
if(value[4] == "D"):
dissolve.append(db_manager.getDissolveInfo(session['osis']))
open = db_manager.getMess(session["osis"],1)
close = db_manager.getMess(session["osis"],0)
user=session['osis']
return render_template("notifs.html", heading="Notifications", all=all, open=open, close=close, looper=looper, buddy=buddy, locker=locker, dissolve = dissolve, user=user)
def survey():
info=db_manager.getUserInfo(session["osis"])
if(info[4]!=""):
flash("Sorry! You already have a Buddy!",'danger')
return redirect("/home")
sports = ""
books = ""
misc = ""
user = session['osis']
list = db_manager.getSurveyInfo(session["osis"])
if (len(list)>0):
sports = list[0]
books = list[1]
misc = list[2]
return render_template("survey.html", heading = "Locker Buddy Survey", sports = sports, books = books, misc = misc, user=user)