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)