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)