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)