def addComunity():
Comunitytype = request.form.get("addComunity")
mealId = request.form.get("addComunity")
currentUserId = session["user_id"]
community = request.form.get("community")
if isParticipant(mealId, currentUserId) == 0:
mealProcess(mealId, community, currentUserId)
return redirect("listmeal")
def addsug():
if request.method == "POST":
mealName = request.form.get("name")
mealDes = request.form.get("description")
mealDate = request.form.get("date")
mealId = db.execute("select max(id) as maxId from meals")
maxId = mealId[0]["maxId"] + 1
currentUserId = session["maxId"]
community = 1 # Cooker
mealProcess(mealId, community, currentUserId)
file = request.files['image']
f = os.path.join(app.config['UPLOAD_FOLDER'], file.filename)
# add your custom code to check that the uploaded file is a valid image and not a malicious file (out-of-scope for this post)
file.save(f)
suggestion = db.execute("INSERT INTO meals (name, description, date, userId) VALUES (:mName, :mDescription, :mDate ,:user_id)",
mName=mealName, mDescription=mealDes, mDate=mealDate , user_id=session["user_id"] )
Maxidrows = db.execute("SELECT max(id) as id FROM meals ")
Maxid = Maxidrows[0]["id"]
newfilename = UPLOAD_FOLDER+"/"+str(Maxid) +".jpg"
os.rename(f,newfilename)
###########Diaa##########
users = db.execute("SELECT * FROM users")
cook_user = db.execute("SELECT username FROM users where id=:u_id",u_id=session["user_id"])
a_users =[]
allUsers =''
for i in range(len(users)):
allUsers = str(users[i]['eMail'])
print(allUsers)
with mail.connect() as conn:
message = render_template("sug_email.html",mealName=mealName,mealDes=mealDes,mealDate=mealDate,cook=cook_user[0]['username'],newfilename=newfilename)
subject = "hello, %s" % "all"
msg = Message(sender='*****@*****.**',recipients=[allUsers], html=message,subject=subject)
mail.send(msg)
###########Diaa##########
return render_template("materialdetails.html",units = getUnits() ,mealid=Maxid, mealName=mealName,mealDes=mealDes,mealDate=mealDate,cook=cook_user[0]['username'])
else:
return render_template("addsug.html")
def addCleaner():
mealId = request.form.get("addCleaner")
currentUserId = session["user_id"]
community = 3 # Cooker Helper
mealProcess(mealId, community, currentUserId)
return redirect("/")
def addParticipate():
mealId = request.form.get("addParticipate")
currentUserId = session["user_id"]
community = 5 # Cooker Helper
mealProcess(mealId, community, currentUserId)
return redirect("/")