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)