def plants_show_user(): result = PlantUser.user_plants(current_user.id) number = Plant.user_plants_number(current_user.id) #replace id of plant with plant object, format the dates for sublist in result: sublist[0] = Plant.query.get(sublist[0]) if sublist[1] != None: sublist[1] = str(sublist[1]) newformat_split_w = sublist[1].split("-") newformat_w = newformat_split_w[2] + "." + newformat_split_w[1] + "." + newformat_split_w[0] sublist[1] = newformat_w else: sublist[1] = "Ei valittua päivää" if sublist[2] != None: sublist[2] = str(sublist[2]) newformat_split_f = sublist[2].split("-") newformat_f = newformat_split_f[2] + "." + newformat_split_f[1] + "." + newformat_split_f[0] sublist[2] = newformat_f else: sublist[2] = "Ei valittua päivää" return render_template("plants/listuser.html", plants = result, lastwateredform = UpdateLastWateredForm(), lastfertilizedform = UpdateLastFertilizedForm(), number = number)
def plant_list(): plants = Plant.query.filter_by(owner_id=current_user.id) plantcount = Plant.count_tags_on_plants(current_user.id) return render_template("plants/plant_list.html", plants=plants, count=plantcount)
def plants_create(): form = PlantForm(request.form) if not form.validate(): return render_template("plants/new.html", form=form) speciesId = request.form.get('species_id', type=int) sp = Species.query.get(speciesId) p = Plant(form.name.data) p.species_id = speciesId p.account_id = current_user.id p.species_name = sp.name db.session().add(p) db.session().commit() return redirect(url_for("plants_index"))
def categories_search_plant(): form = SearchPlantForm(request.form) if not form.validate(): return render_template("categories/manageall.html", form = form) name_fin = form.name_fin.data result = Plant.find_plant_by_name(name_fin = name_fin) if not result: return render_template("plants/noresults.html") results = [] p = Plant(result[1], result[2], result[3], result[4], result[5]) results.append(p) return render_template("categories/searchresults.html", plants = results, plant_id = result[0])
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 plant_new(): if request.method == "GET": return render_template("plants/plant_new.html", form=PlantForm()) form = PlantForm(request.form) if not form.validate(): return render_template("plants/plant_new.html", form=form) name = form.name.data hrs = form.mature_time.data tree = form.is_tree.data # creating the plant p = Plant(name, hrs, tree) p.owner_id = current_user.id db.session().add(p) db.session().commit() return redirect(url_for("plant_list"))
def plants_new(): form = PlantForm(request.form) if not form.validate(): return render_template("plants/new.html", form = form) nameExists = Plant.find_plant_by_name(form.name_fin.data) if nameExists: return render_template("plants/new.html", form = form, error = "Kasvi löytyy jo tietokannasta!") name_fin = form.name_fin.data name_lat = form.name_lat.data water_need = form.water_need.data fertilizer_need = form.fertilizer_need.data light_need = form.light_need.data p = Plant(name_fin, name_lat, water_need, fertilizer_need, light_need) db.session().add(p) db.session().commit() return redirect(url_for("plants_show_all"))
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 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)