def _getNextBeerlist(): data = request.get_json() print("**************************************") print("******LINE 212***********************") print("list_history. /_getOnTapNextBeerlist") print("**************************************") print("data: {}".format(data)) print("**************************************") print("**************************************") if (current_user.is_authenticated): print("LOGGED IN") print(current_user.id) data['userId'] = current_user.id print(data) beerlist = _getOnTapNextBeerlist(data) # beerlist = _getOnTapNextBeerlist(current_user.id) print(beerlist) elif (data): print("NOT LOGGED IN") print(data['userName']) current_user_id = getVenueId(data['userName']) print("current_user_id: {}".format(current_user_id)) data['userId'] = current_user_id print("data: {}".format(data)) beerlist = _getOnTapNextBeerlist(data) else: print("NOT LOGGED IN AND NO URL INFO") beerlist = {} print("**************************************") print("**************************************") return jsonify(beerlist)
def _getBottleBeerlist(): data = request.get_json() print("**************************************") print("******LINE 103***********************") print("list_history. /_getBottleBeers") print("**************************************") print("data: {}".format(data)) print("**************************************") print("**************************************") if (current_user.is_authenticated): # print("LOGGED IN") # print(current_user.id) data['userId'] = current_user.id print("data: {}".format(data)) bottleBeerlist = _getBottleBeers(data) data = {"beerlist": bottleBeerlist, "venue_db_id": current_user.id} elif (data): current_user_id = getVenueId(data['userName']) data['userId'] = current_user_id # print("NOT LOGGED IN") # print(data['userName']) # print(current_user_id) bottleBeerlist = _getBottleBeers(data) data = {"beerlist": bottleBeerlist, "venue_db_id": current_user_id} else: print("NOT LOGGED IN AND NO URL INFO") data = {} print("**************************************") print("**************************************") return jsonify(data)
def _getTotBeerlist(): data = request.get_json() print("**************************************") print("*********** LINE 147 *****************") print("list_history. /_getTotBeerlist") print("**************************************") print("data: {}".format(data)) print("**************************************") print("**************************************") if (current_user.is_authenticated): print("LOGGED IN") print(current_user.id) beerlist = _getTotalBeerlist(current_user.id) print(beerlist) data = {"beerlist": beerlist, "venue_db_id": current_user.id} elif (data): print("NOT LOGGED IN") current_user_id = getVenueId(data['userName']) print(data['userName']) print(current_user_id) beerlist = _getTotalBeerlist(current_user_id) data = {"beerlist": beerlist, "venue_db_id": current_user_id} else: print("NOT LOGGED IN AND NO URL INFO") data = {} print("**************************************") print("**************************************") return jsonify(data)
def bottle_beers_nologin(venuename, screen_id): print('******************************************************************') print("venuename: {}".format(venuename)) current_user_id = getVenueId(venuename) print("current_user_id: {}".format(current_user_id)) print("screen_id: {}".format(screen_id)) screenData = { "userId": current_user_id, "screenNumber": screen_id, } print('******************************************************************') # user = User.query.filter_by(id=current_user.id).first() # datas = user.beerlist_sort_asc datas = db.session.query( List_history.id, List_history.name, List_history.style, List_history.abv, List_history.ibu, List_history.brewery, List_history.location, List_history.website, List_history.description, List_history.draft_bottle_selection, ).filter(List_history.draft_bottle_selection != "Draft").filter( List_history.venue_db_id == screenData['userId'] # ).filter(List_history.beer_screen_id == screenData['screenNumber'] ).order_by(List_history.name.asc()).all() beers = [] for data in datas: beer = { "id": data.id, "name": data.name, "style": data.style, "abv": data.abv, "ibu": data.ibu, "brewery": data.brewery, "location": data.location, "website": data.website, "description": data.description, "draft_bottle_selection": data.draft_bottle_selection, } beers.append(beer) if len(beers) > 0: jsonify(beers) return render_template('bottle_beers.html', title='Bottle beers list', beers=beers, currentUserId=screenData['userId'], bottleBeersScreenId=screenData['screenNumber']) else: msg = 'No Beers Found!!!' return render_template('bottle_beers.html', title='Bottle beers list', msg=msg, beers=beers, currentUserId=screenData['userId'], bottleBeersScreenId=screenData['screenNumber'])
def _get_event_current_list(): data = request.get_json() print("**************************************") print("**************************************") print("list_history. /_get_event_current_list") print(data) if (current_user.is_authenticated): print("LOGGED IN") print(current_user.id) data['userId'] = current_user.id print("data: {}".format(data)) data = _getEventsSortAsc(data) elif (data): print("NOT LOGGED IN") current_user_id = getVenueId(data['userName']) print(current_user_id) data['userId'] = current_user_id print("data: {}".format(data)) data = _getEventsSortAsc(data) else: print("NOT LOGGED IN AND NO URL INFO") data = {} print("**************************************") print("**************************************") return jsonify(data)
def winelist_menu_nologin(venuename, screen_id): # get user ID from venue name current_user_id = getVenueId(venuename) # query to get types of wine wineTypes = _getWinetypes(current_user_id) # convert wineTypes to usable list wineTypelist = _convertToWinelist(wineTypes) # print(wineTypelist) # turn wineType list into array wineTypelistArr = [] for wine in wineTypelist: print("wineType: {}".format(wine['type'])) wineTypelistArr.append(wine['type']) print("") # get all the wines in the database totalWinelist = _getWine(current_user_id) # print(totalWinelist) # print("") # turn total winelist into usable array totalWinelistArr = [] for wine in totalWinelist: print("wineType: {}".format(wine['type'])) totalWinelistArr.append(wine['type']) print("") print(wineTypelistArr) print(totalWinelistArr) # filter out all the types of wines to use as a heading list to categorize the wines def filterTypes(listTypes): if (listTypes in totalWinelistArr): return True else: return False # filter the type of wines actually being used filteredTypes = filter(filterTypes, wineTypelistArr) print("") print(filteredTypes) print("") # create a list of type of wines actually used typeList = [] for ft in filteredTypes: typeList.append(ft) print(typeList) winelist = totalWinelist return render_template('winelist_menu.html', title='Winelist Menu', wineTypelist=typeList, winelist=winelist, currentUserId=current_user_id)
def winelist_description_nologin(venuename, screen_id): # get user ID from venue name current_user_id = getVenueId(venuename) wineTypes = _getWinetypes(current_user_id) wineTypelist = _convertToWinelist(wineTypes) print(wineTypelist) wineTypelistArr = [] for wine in wineTypelist: print("wineType: {}".format(wine['type'])) wineTypelistArr.append(wine['type']) print("") totalWinelist = _getWine(current_user_id) print(totalWinelist) print("") totalWinelistArr = [] for wine in totalWinelist: print("wineType: {}".format(wine['type'])) totalWinelistArr.append(wine['type']) print("") print(wineTypelistArr) print(totalWinelistArr) def filterTypes(listTypes): if (listTypes in totalWinelistArr): return True else: return False filteredTypes = filter(filterTypes, wineTypelistArr) print("") print(filteredTypes) print("") typeList = [] for ft in filteredTypes: typeList.append(ft) print(typeList) winelist = totalWinelist return render_template('winelist_description.html', title='Winelist Description', wineTypelist=typeList, winelist=winelist, currentUserId=current_user_id)
def draft_beers_nologin(venuename, screen_id): print('\nTHIS IS draft_beers\n') screenData = { "userId": getVenueId(venuename), "screenNumber": screen_id, } beers = _getDraftBeers(screenData) beerlist = [] beerlistBom = [] beerlistCs = [] for beer in beers: print(beer) if not beer.beer_of_month and not beer.coming_soon: beerlist.append(beer) elif beer.beer_of_month and beer.coming_soon: beerlistBom.append(beer) beerlistCs.append(beer) elif beer.beer_of_month: beerlist.append(beer) beerlistBom.append(beer) elif beer.coming_soon: beerlistCs.append(beer) beerlistBomLen = len(beerlistBom) beerlistCsLen = len(beerlistCs) if len(beers) > 0: return render_template('draft_beers.html', title='Beer Print', legend='Beer Print', beers=beers, currentUserId=screenData['userId'], draftBeersScreenId=screenData['screenNumber'], beerlistBomLen=beerlistBomLen, beerlistCsLen=beerlistCsLen) else: msg = 'No Beers Found' return render_template('draft_beers.html', msg=msg, currentUserId=screenData['userId'], draftBeersScreenId=screenData['screenNumber'])
def getTickerInfo(): data = request.get_json() print("**************************************") print("******line 88*************************") print("displays. /_getTickerInfo") print("**************************************") print("data: {}".format(data)) print("**************************************") print("**************************************") if (current_user.is_authenticated): print("LOGGED IN") print(current_user.id) data['userId'] = current_user.id print("data: {}".format(data)) data = _getTickerInfo(data) tickerInfo = {} tickerInfo['id'] = data.id tickerInfo['ticker_text'] = data.ticker_text tickerInfo['ticker_screen_id'] = data.ticker_screen_id tickerInfo['tickery_type'] = data.ticker_type elif (data): print("NOT LOGGED IN") current_user_id = getVenueId(data['userName']) print(current_user_id) data['userId'] = current_user_id print("data: {}".format(data)) data = _getTickerInfo(data) tickerInfo = {} tickerInfo['id'] = data.id tickerInfo['ticker_text'] = data.ticker_text tickerInfo['ticker_screen_id'] = data.ticker_screen_id tickerInfo['tickery_type'] = data.ticker_type else: print("NOT LOGGED IN AND NO URL INFO") tickerInfo = {} print("**************************************") print("**************************************") return jsonify(tickerInfo)
def _logged_in_user_data(): data = request.get_json() print("**************************************") print("******LINE 27************************") print("users. /_logged_in_user_data") print("**************************************") print("data: {}".format(data)) print("**************************************") print("**************************************") if (current_user.is_authenticated): print("LOGGED IN") data['userId'] = current_user.id print("data: {}".format(data)) data = get_user_data(data) elif (data): print("NOT LOGGED IN") print("data: {}".format(data)) # if (hasattr(data, 'userName')): # print("data['userName']: {}".format(data['userName'])) # print("HASATTR") # try: # attr = getattr(data, 'userName') # print(attr) # except AttributeError: # print ("DOESN'T EXIST") # else: # print ("EXISTS") print(data['userName']) current_user_id = getVenueId(data['userName']) print(current_user_id) data['userId'] = current_user_id print("data: {}".format(data)) data = get_user_data(data) else: print("NOT LOGGED IN AND NO URL INFO") data = {} print("**************************************") print("**************************************") return jsonify(data)
def draft_beers_print_nologin(venuename, screen_id): print('\nTHIS IS draft_beers_print\n') screenData = { "userId": getVenueId(venuename), "screenNumber": screen_id, } # query DB for current draft beers for the venue and the screen beers = _getDraftBeers(screenData) for beer in beers: print(beer) if len(beers) > 0: return render_template('draft_beers_print.html', title='Beer Print', legend='Beer Print', beers=beers, currentUserId=screenData['userId']) else: msg = 'No Beers Found' return render_template('draft_beers_print.html', msg=msg, currentUserId=screenData['userId'])
def beers_display_screen_nologin(venuename, screen_id): print('******************************************************************') print("venuename: {}".format(venuename)) current_user_id = getVenueId(venuename) print("current_user_id: {}".format(current_user_id)) print("screen_id: {}".format(screen_id)) screenData = { "userId": current_user_id, "screenNumber": screen_id, } print('******************************************************************') user = User.query.filter_by(id=current_user_id).first() beers = db.session.query( List_current.id, List_history.id, List_history.name, List_history.style, List_history.abv, List_history.ibu, List_history.brewery, List_history.location, List_history.website, List_history.description, List_current.id_dropdown, List_current.beer_of_month, List_current.coming_soon, ).outerjoin(List_current, List_history.id == List_current.id_history).filter( List_current.venue_db_id == current_user_id).filter( List_current.beer_screen_id == screen_id).all() beerlist = [] beerlistBom = [] beerlistCs = [] print("") for beer in beers: if not beer.beer_of_month and not beer.coming_soon: beerlist.append(beer) elif beer.beer_of_month and beer.coming_soon: beerlistBom.append(beer) beerlistCs.append(beer) elif beer.beer_of_month: beerlist.append(beer) beerlistBom.append(beer) elif beer.coming_soon: beerlistCs.append(beer) print("") print("beerlist") for beer in beerlist: print(beer) print("") print("beerlistBom") for beer in beerlistBom: print(beer) print("") print("beerlistCs") for beer in beerlistCs: print(beer) print("") # halflistNum = math.trunc((len(beerlist)/2)) halflistNum = math.ceil((len(beerlist) / 2)) # halflistNum = (len(beerlist)/2) print("halflistNum: {}".format(halflistNum)) beerlistFirstHalf = beerlist[:halflistNum] beerlistSecondHalf = beerlist[halflistNum:] print("") print("beerlistFirstHalf") for beer in beerlistFirstHalf: print(beer) print("") print("beerlistSecondHalf") for beer in beerlistSecondHalf: print(beer) print("*******************************************************") print("*************LINE 668**********************************") print("*******************************************************") tickerText = _getTickerInfo(screenData).ticker_text print(tickerText) if len(beers) > 0: return render_template('beers_display_screen.html', beers=beers, beerlistFirstHalf=beerlistFirstHalf, beerlistSecondHalf=beerlistSecondHalf, beerlistBom=beerlistBom, beerlistCs=beerlistCs, tickerText=tickerText, currentUserId=current_user_id, beerlistScreenId=screen_id) else: msg = 'No Beers Found' return render_template('beers_display_screen.html', msg=msg, currentUserId=current_user_id, beerlistScreenId=screen_id)
def _winemenu_list(): data = request.get_json() print("^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^") print("^^^^^^^line 20 /_winemenu_list_display^^^^^^^") print("^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^") print("data: {}".format(data)) print("**************************************") print("**************************************") if (current_user.is_authenticated): print("LOGGED IN") print(current_user.id) data['userId'] = current_user.id print(data) # query to get types of wine wineTypes = _getWinetypes(current_user.id) # convert wineTypes to usable list wineTypelist = _convertToWinelist(wineTypes) # print(wineTypelist) elif (data): print("NOT LOGGED IN AND URL INFO") print(data['userName']) current_user_id = getVenueId(data['userName']) print("current_user_id: {}".format(current_user_id)) data['userId'] = current_user_id print("data: {}".format(data)) # query to get types of wine wineTypes = _getWinetypes(current_user_id) print(wineTypes) # convert wineTypes to usable list wineTypelist = _convertToWinelist(wineTypes) print(wineTypelist) else: print("NOT LOGGED IN AND NO URL INFO") winelist = {} print("^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^") print("^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^") # turn wineType list into array wineTypelistArr = [] for wine in wineTypelist: # print("wineType: {}".format(wine['type'])) wineTypelistArr.append(wine['type']) # print("") # get all the wines in the database totalWinelist = _getWine(data['userId']) # print(totalWinelist) # print("") # turn total winelist into usable array totalWinelistArr = [] for wine in totalWinelist: # print("wineType: {}".format(wine['type'])) totalWinelistArr.append(wine['type']) # print("") # print(wineTypelistArr) # print(totalWinelistArr) # filter out all the types of wines to use as a heading list to categorize the wines def filterTypes(listTypes): if (listTypes in totalWinelistArr): return True else: return False # filter the type of wines actually being used filteredTypes = filter(filterTypes, wineTypelistArr) # print("") # print(filteredTypes) # print("") # create a list of type of wines actually used typeList = [] for ft in filteredTypes: typeList.append(ft) # print(typeList) winelist = totalWinelist data = { "wineTypelist": typeList, "winelist": winelist, "userData": { "venue_db_id": data['userId'] } } return jsonify(data)
def register(): if current_user.is_authenticated: return redirect(url_for('list_history.beer_dashboard')) form = RegisterForm(request.form) if form.validate_on_submit(): name = form.name.data venuename = form.venuename.data username = form.username.data websiteURL = form.websiteURL.data email = form.email.data password = sha256_crypt.encrypt(str(form.password.data)) user = User(name=name, venue_name=venuename, websiteURL=websiteURL, email=email, username=username, password=password) db.session.add(user) db.session.commit() # init new venue DB for wine tables initListHistory(getVenueId(venuename)) initDrinkSize(getVenueId(venuename)) initDrinkPrice(getVenueId(venuename)) initImagelistHistory(getVenueId(venuename)) initImagelistCurrent(getVenueId(venuename)) initImagescreenSetting(getVenueId(venuename)) initTransition(getVenueId(venuename)) initListCurrent({"id": getVenueId(venuename), "screenId": ""}) initWinelist(getVenueId(venuename)) initWinelistCurrent(getVenueId(venuename)) initWinetype(getVenueId(venuename)) initBeerscreenSetting({"id": getVenueId(venuename), "screenId": ""}) initWinecreenSetting(getVenueId(venuename)) initEventscreenSetting(getVenueId(venuename)) initItemscreenSetting(getVenueId(venuename)) initFontSizeOption(getVenueId(venuename)) # # took out initTemplate cause need to populate DB with pre-build templates # # templates cannot be user defined or added to DB by user # initTemplate(getVenueId(venuename)) # initEvent(getVenueId(venuename)) initItem(getVenueId(venuename)) initTicker(getVenueId(venuename)) initTickerTypeId(getVenueId(venuename)) flash('{}, you are now registered and can log in!'.format(username), 'success') return redirect(url_for('users.login')) return render_template('register.html', title='Register', legend='Register', form=form)