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 _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 testing_winelist_editor():
user = User.query.filter_by(id=current_user.id).first()
datas = _getWine(current_user.id)
wines = []
for data in datas:
wine = {
"id": data.id,
"name": data.name,
"varietal": data.varietal,
"location": data.location,
"glass": data.glass,
"bottle": data.bottle,
"description": data.description,
"food_pairings": data.food_pairings,
"website": data.website,
}
wines.append(wine)
for wine in wines:
print(wine)
# wine1select = getDefaultCurrentWinelist('1')
# wine2select = getDefaultCurrentWinelist('2')
# wine3select = getDefaultCurrentWinelist('3')
# wine4select = getDefaultCurrentWinelist('4')
# wine5select = getDefaultCurrentWinelist('5')
# wine6select = getDefaultCurrentWinelist('6')
# wine7select = getDefaultCurrentWinelist('7')
# wine8select = getDefaultCurrentWinelist('8')
# wine9select = getDefaultCurrentWinelist('9')
# wine10select = getDefaultCurrentWinelist('10')
# wine11select = getDefaultCurrentWinelist('11')
# wine12select = getDefaultCurrentWinelist('12')
# wine13select = getDefaultCurrentWinelist('13')
# wine14select = getDefaultCurrentWinelist('14')
# wine15select = getDefaultCurrentWinelist('15')
# wine16select = getDefaultCurrentWinelist('16')
# wine17select = getDefaultCurrentWinelist('17')
# wine18select = getDefaultCurrentWinelist('18')
# wine19select = getDefaultCurrentWinelist('19')
# wine20select = getDefaultCurrentWinelist('20')
# wine21select = getDefaultCurrentWinelist('21')
# wine22select = getDefaultCurrentWinelist('22')
# wine23select = getDefaultCurrentWinelist('23')
# wine24select = getDefaultCurrentWinelist('24')
# wine25select = getDefaultCurrentWinelist('25')
# wine26select = getDefaultCurrentWinelist('26')
# wine27select = getDefaultCurrentWinelist('27')
# wine28select = getDefaultCurrentWinelist('28')
#
# form = CurrentWinelistForm(request.form,
# wine1=wine1select.id_wine,
# wine2=wine2select.id_wine,
# wine3=wine3select.id_wine,
# wine4=wine4select.id_wine,
# wine5=wine5select.id_wine,
# wine6=wine6select.id_wine,
# wine7=wine7select.id_wine,
# wine8=wine8select.id_wine,
# wine9=wine9select.id_wine,
# wine10=wine10select.id_wine,
# wine11=wine11select.id_wine,
# wine12=wine12select.id_wine,
# wine13=wine13select.id_wine,
# wine14=wine14select.id_wine,
# wine15=wine15select.id_wine,
# wine16=wine16select.id_wine,
# wine17=wine17select.id_wine,
# wine18=wine18select.id_wine,
# wine19=wine19select.id_wine,
# wine20=wine20select.id_wine,
# wine21=wine21select.id_wine,
# wine22=wine22select.id_wine,
# wine23=wine23select.id_wine,
# wine24=wine24select.id_wine,
# wine25=wine25select.id_wine,
# wine26=wine26select.id_wine,
# wine27=wine27select.id_wine,
# wine28=wine28select.id_wine
# )
#
# form.wine1.choices = [(wine['id'], wine['name'] + ' - ' + wine['varietal']) for wine in wines]
# form.wine2.choices = [(wine['id'], wine['name'] + ' - ' + wine['varietal']) for wine in wines]
# form.wine3.choices = [(wine['id'], wine['name'] + ' - ' + wine['varietal']) for wine in wines]
# form.wine4.choices = [(wine['id'], wine['name'] + ' - ' + wine['varietal']) for wine in wines]
# form.wine5.choices = [(wine['id'], wine['name'] + ' - ' + wine['varietal']) for wine in wines]
# form.wine6.choices = [(wine['id'], wine['name'] + ' - ' + wine['varietal']) for wine in wines]
# form.wine7.choices = [(wine['id'], wine['name'] + ' - ' + wine['varietal']) for wine in wines]
# form.wine8.choices = [(wine['id'], wine['name'] + ' - ' + wine['varietal']) for wine in wines]
# form.wine9.choices = [(wine['id'], wine['name'] + ' - ' + wine['varietal']) for wine in wines]
# form.wine10.choices = [(wine['id'], wine['name'] + ' - ' + wine['varietal']) for wine in wines]
# form.wine11.choices = [(wine['id'], wine['name'] + ' - ' + wine['varietal']) for wine in wines]
# form.wine12.choices = [(wine['id'], wine['name'] + ' - ' + wine['varietal']) for wine in wines]
# form.wine13.choices = [(wine['id'], wine['name'] + ' - ' + wine['varietal']) for wine in wines]
# form.wine14.choices = [(wine['id'], wine['name'] + ' - ' + wine['varietal']) for wine in wines]
# form.wine15.choices = [(wine['id'], wine['name'] + ' - ' + wine['varietal']) for wine in wines]
# form.wine16.choices = [(wine['id'], wine['name'] + ' - ' + wine['varietal']) for wine in wines]
# form.wine17.choices = [(wine['id'], wine['name'] + ' - ' + wine['varietal']) for wine in wines]
# form.wine18.choices = [(wine['id'], wine['name'] + ' - ' + wine['varietal']) for wine in wines]
# form.wine19.choices = [(wine['id'], wine['name'] + ' - ' + wine['varietal']) for wine in wines]
# form.wine20.choices = [(wine['id'], wine['name'] + ' - ' + wine['varietal']) for wine in wines]
# form.wine21.choices = [(wine['id'], wine['name'] + ' - ' + wine['varietal']) for wine in wines]
# form.wine22.choices = [(wine['id'], wine['name'] + ' - ' + wine['varietal']) for wine in wines]
# form.wine23.choices = [(wine['id'], wine['name'] + ' - ' + wine['varietal']) for wine in wines]
# form.wine24.choices = [(wine['id'], wine['name'] + ' - ' + wine['varietal']) for wine in wines]
# form.wine25.choices = [(wine['id'], wine['name'] + ' - ' + wine['varietal']) for wine in wines]
# form.wine26.choices = [(wine['id'], wine['name'] + ' - ' + wine['varietal']) for wine in wines]
# form.wine27.choices = [(wine['id'], wine['name'] + ' - ' + wine['varietal']) for wine in wines]
# form.wine28.choices = [(wine['id'], wine['name'] + ' - ' + wine['varietal']) for wine in wines]
if request.method == "POST":
for x in range(1, 29, 1):
wine = request.form['wine{}'.format(x)]
wineCandidate = Winelist_current.query.filter_by(
id_dropdown=x, venue_db_id=current_user.id).first()
wineCandidate.id_wine = wine
db.session.commit()
wines = _getWinelistDisplay(current_user.id)
settings = {
"venue_db_id": current_user.id,
"updated": True,
# "winelist": wines
}
# settings = json.dumps(settings)
#######################################
#PUSHER
pusher_client.trigger('wine-event-channel', 'new-wine-event',
{'message': settings})
#PUSHER
#######################################
# Flash success message on the screen
flash('Winelist Updated!!!', 'success')
return redirect(url_for('wine.testing_winelist_editor'))
return render_template('testing_winelist_editor.html',
title='Winelist Editor',
legend='Winelist Editor',
wines=wines)