def categories_manage_one(category_id):
c = Category.query.get(category_id)
number_one = Category.category_plants_number(category_id)
number_all = Plant.all_plants_number()
c_plants = []
allPlants = Plant.query.all()
allInstances = PlantCategory.query.all()
for i in allInstances:
if i.category_id is int(category_id):
p = Plant.query.get(i.plant_id)
c_plants.append(p)
return render_template("/categories/manageone.html", category_id = c.id, name = c.name, c_plants = c_plants, plants = allPlants, number_one = number_one, number_all = number_all)
def plants_search():
form = SearchPlantForm(request.form)
name_fin = form.name_fin.data
result = Plant.find_plant_by_name(name_fin = name_fin)
allPlants = Plant.query.all()
number = Plant.all_plants_number()
if not result:
return render_template("plants/listall.html", plants = allPlants, searchplantform = SearchPlantForm(), searchcategoryform = SearchCategoryForm(), noresult_plant = True, number = number)
results = []
p = Plant(result[1], result[2], result[3], result[4], result[5])
p.id = result[0]
results.append(p)
return render_template("plants/searchresults.html", plants = results, header = "Tulokset haulla " + name_fin, number = 1)
def categories_search():
form = SearchCategoryForm(request.form)
if not form.validate():
return render_template("plants/listall.html", searchcategoryform = form)
c_data = form.category.data
c_plants = []
allPlants = Plant.query.all()
number = Plant.all_plants_number()
allInstances = PlantCategory.query.all()
for i in allInstances:
if i.category_id is int(c_data.id):
p = Plant.query.get(i.plant_id)
c_plants.append(p)
if len(c_plants) == 0:
return render_template("plants/listall.html", plants = allPlants, searchplantform = SearchPlantForm(), searchcategoryform = SearchCategoryForm(), noresult_category = True, number = number)
return render_template("plants/searchresults.html", plants = c_plants, header = "Kategorian " + c_data.name + " kasvit", number = len(c_plants))
def plants_show_all():
allPlants = Plant.query.all()
number = Plant.all_plants_number()
return render_template("plants/listall.html", plants = allPlants, searchplantform = SearchPlantForm(), searchcategoryform = SearchCategoryForm(), number = number)