def cards():
if session.get('user_id') is None:
return redirect(url_for("auth.login"))
if session.get('trello') == "" or session.get('trello') is None:
return redirect(url_for("profiles.profile"))
db = database.Database()
# Header stuff
notifications = main.getNotifications()
messages = main.getMessages()
userData = db.getUser(session.get('user_id'))
users=db.getUsers()
#End header stuff
card_type = request.args.get('card_type', default='', type=str)
cards_return = []
allcards = main.getAllCards()
allcards = main.cardsAssigned(allcards)
if card_type == 'total' :
cards_return = allcards
elif card_type == 'completed' :
cards_return = main.cardsCompletedList(allcards)
elif card_type == 'open' :
cards_return = main.getOpenCards(allcards)
users=db.getUsers()
recentCompletedCards = main.cardsCompletedList(allcards)
weeklycards, dates = main.getWeeklyCards(recentCompletedCards)
return render_template('/main/cards.html', card_type=card_type, users = userData, messages=messages,notifications=notifications, dates=dates, weeklycards=weeklycards, allusers=users, cards=cards_return, username=session.get('user'))
def profile():
db = database.Database()
apps = db.selectall(
"SELECT * from apps"
)
user = db.selectall(
"SELECT * FROM users WHERE id = '{}'".format(session.get('user_id'))
)
tokenlist = {}
for app in apps :
tokenlist[app['app']] =session.get(app['app'])
if request.method == 'POST':
for app in apps :
if request.form[app['app']]:
checkrecord = db.select(
"SELECT 1 FROM user_tokens WHERE app_id='{}' and user_id = '{}'".format(app['id'], session.get('user_id'))
)
if checkrecord is None :
db.insert(
"INSERT INTO user_tokens (token, app_id, user_id) VALUES ('{}', '{}', '{}')".format(request.form[app['app']], app['id'], session.get('user_id'))
)
else :
db.insert(
"UPDATE user_tokens SET token = '{}' WHERE app_id ='{}' and user_id='{}'".format(request.form[app['app']], app['id'], session.get('user_id'))
)
# Header stuff
notifications = main.getNotifications()
messages = main.getMessages()
userData = db.getUser(session.get('user_id'))
users=db.getUsers()
#End header stuff
return render_template('profiles/profile.html',notifications=notifications, messages=messages, users=userData, tokenlist=tokenlist, apps=apps, user=user[0])
def mainRender():
if session.get('user_id') is None:
return redirect(url_for("auth.login"))
if session.get('trello') == "" or session.get('trello') is None:
return redirect(url_for("profiles.profile"))
db = database.Database()
# Header stuff
notifications = main.getNotifications()
messages = main.getMessages()
userData = db.getUser(session.get('user_id'))
users=db.getUsers()
#End header stuff
allcards = main.getAllCards()
cards = main.cardsAssigned(allcards)
completed = main.cardsCompleted(cards)
totalcards = len(cards)
opencards = totalcards-completed
badges = db.userBadges(session.get('user_id'))
points = 0
try :
points = db.getPointsOfUser(session.get('user_id'))
except :
print("")
users=db.getUsers()
recentCompletedCards = main.cardsCompletedList(allcards)
weeklycards, dates = main.getWeeklyCards(recentCompletedCards)
recentCompletedCards.sort(key = lambda recentCompletedCards: recentCompletedCards['dateLastActivity'])
recentCompletedBadges = db.getRecentBadges()
totallist= list(recentCompletedCards) + list(recentCompletedBadges)
totallist.sort(key = lambda totallist: totallist['dateLastActivity'])
feed = []
i = 0
members = main.getAllMembers()
totallist.reverse()
for item in totallist :
i = i + 1
if i > 25 :
break
newitem = []
newitem.append(item['name'])
if 'username' in item :
newitem.append(item['username'])
else :
this_username = ""
for trellomember in item['idMembers'] :
for member in members :
if trellomember == member['id'] :
this_username = this_username + member['username'] +", "
this_username = this_username[:-3]
newitem.append(this_username)
newitem.append(item['dateLastActivity'])
feed.append(newitem)
for index, user in enumerate(users) :
users[index]['rank'] = (index + 1)
return render_template('/main/index.html', users = userData, messages=messages,notifications=notifications, dates=dates, weeklycards=weeklycards,feed=feed,test=totallist, allusers=users, members=members, points = points, badges=badges, cards=cards, completed=completed, totalcards=totalcards, opencards=opencards, username=session.get('user'))
def adminRender():
if session.get('user_id') is None:
return redirect(url_for("auth.login"))
if session.get('trello') == "" or session.get('trello') is None:
return redirect(url_for("profiles.profile"))
user = session.get('user')
if user['admin'] == 0:
return redirect(url_for("profiles.profile"))
db = database.Database()
badges = db.getBadges()
# Header stuff
notifications = main.getNotifications()
messages = main.getMessages()
userData = db.getUser(session.get('user_id'))
users = db.getUsers()
#End header stuff
points = 0
try:
points = db.getPointsOfUser(session.get('user_id'))
except:
print("")
boards = db.getBoards()
lists = main.getLists()
completed_lists = db.getCompletedLists()
points_distribution = []
try:
points_distribution = db.getPointsDistribution()
except:
print("")
currentuser = []
user_id = request.args.get('user_id')
for user in users:
if user_id == str(user['id']):
currentuser = user
return render_template('/admin/admin.html',
messages=messages,
notifications=notifications,
points_distribution=points_distribution,
currentuser=currentuser,
completed_lists=completed_lists,
lists=lists,
boards=boards,
trellousername=session.get('trellousername'),
badges=badges,
users=userData,
allusers=users,
points=points)
def leaderboards() :
if session.get('user_id') is None:
return redirect(url_for("auth.login"))
if session.get('trello') == "" or session.get('trello') is None:
return redirect(url_for("profiles.profile"))
db = database.Database()
# Header stuff
notifications = main.getNotifications()
messages = main.getMessages()
userData = db.getUser(session.get('user_id'))
users=db.getUsers()
#End header stuff
for index, user in enumerate(users) :
users[index]['rank'] = (index + 1)
return render_template('/main/leaderboards.html', users = userData, notifications=notifications, messages=messages, allusers=users)