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)