def search():
formsearch = RecipeSearchForm()
form = PostFormHungryFor()
formNormalText = PostForm()
formCurrent = PostFormCurrentlyEating()
if request.method == 'POST':
minmax = request.form['minmax']
minmax = minmax.replace('-', '')
minmax = minmax.replace('$', '').split()
calories = request.form['calories']
calories = calories.replace('-', '')
calories = calories.replace('$', '').split()
if formsearch.validate_on_submit():
if is_filled(formsearch.keyWord.data):
keywords = parser_first_round(formsearch.keyWord.data)
keywords_sufix = parser_search_sufix(formsearch.keyWord.data)
print(keywords_sufix)
print(keywords)
recipes = db.engine.execute("SELECT * FROM (SELECT * FROM rec WHERE (minPrice <= %s AND maxprice >= %s) AND ( calories >= %s AND calories <= %s ) AND \
((MATCH (rec_name, rec_description, rec_instruction, ings, tags) \
AGAINST (%s IN BOOLEAN MODE)))) as b left join (select id as useridd, username from users) as a on b.user_id = a.useridd \
UNION \
SELECT * FROM (SELECT * FROM rec where rec_name LIKE %s) as b left join (select id as useridd, username from users) as a on b.user_id = a.useridd \
", minmax[1], minmax[0], calories[0], calories[1], keywords, keywords_sufix )
return render_template('homepage.html', form5=formsearch, form=form, form2=formNormalText, form3=formCurrent, recipes=recipes)
else:
recipes = db.engine.execute("SELECT * FROM rec WHERE (minPrice <= %s AND maxprice >= %s) AND ( calories >= %s AND calories <= %s )", minmax[1], minmax[0], calories[0], calories[1])
return render_template('homepage.html', form5=formsearch, form=form, form2=formNormalText, form3=formCurrent, recipes=recipes)
return render_template('homepage.html', form5=formsearch, form=form, form2=formNormalText, form3=formCurrent)
def advancedsearch():
formsearch = RecipeSearchForm()
print(formsearch.keyWord.data)
if formsearch.validate_on_submit():
print(formsearch.keyWord.data)
return render_template("advancedsearchpage.html", form5=formsearch)