def nutrition():
list1.delete(0, END)
cal = 0.0
carb = 0.0
prot = 0.0
fat = 0.0
ingred = ''
row = []
nut = []
q = 0
row = backend.viewrecipe(day.get(), meal.get())
for i in range(0, len(row)):
ingred = row[i][1]
q = int(row[i][2])
nut = backend.nvalue(ingred)
cal += ((float(nut[0][1])) * q)
carb += ((float(nut[0][2])) * q)
prot += ((float(nut[0][3])) * q)
fat += ((float(nut[0][4])) * q)
string = "calories=" + str(cal) + ",carb=" + str(carb) + ",prot=" + str(
prot) + ",fat=" + str(fat)
list1.insert(END, string)
def recipe():
list1.delete(0, END)
list1.insert(END, "Recipeid,name,Cooking-time")
m = []
m = backend.viewrecipe(day.get(), meal.get())[0]
m.pop(1)
m.pop(1)
list1.insert(END, m)
list1.insert(END, "Ingredient,Quantity(g)")
for row in backend.viewrecipe(day.get(), meal.get()):
l = []
l = row
l.pop(0)
l.pop(2)
list1.insert(END, l)
def updatestock():
list1.delete(0,END)
row=backend.viewrecipe(day.get(),meal.get())
for i in range(0,len(row)):
ing=row[i][1]
ing_quantity_required=row[i][2]
tuple=(backend.viewingredient(ing))
ing_quantity_exist=tuple[0][1]
flag=backend.update(ing,ing_quantity_exist-(ing_quantity_required*no.get()))
list1.insert(END,flag)
if(flag=="Done"):
list1.insert(END,backend.viewingredient(ing))
def checkstock():
s = 0
row = backend.viewrecipe(day.get(), meal.get())
for i in range(0, len(row)):
ing = row[i][1]
ing_quantity_required = int(row[i][2])
tuple = (backend.viewingredient(ing))
ing_quantity_exist = int(tuple[0][1])
if (ing_quantity_required * no.get() > ing_quantity_exist):
list1.delete(0, END)
list1.insert(END, "WARNING:Stock is less.Can't prepare the food.")
list1.insert(END, "Please click on 'Shop Detail' button")
s = 1
break
if (s == 0):
list1.delete(0, END)
list1.insert(END, "ALL GOOD:Proceed To Cook.")
list1.insert(END, "Please click on 'Update Stock' Button")
def nutrition():
list1.delete(0,END)
cal=0
carb=0
prot=0
fat=0
ingred=[]
row=[]
nut=[]
q=[]
row=backend.viewrecipe(day.get(),meal.get())
for i in range(0,len(row)):
ingred=row[i][1]
q=row[i][2]
nut=backend.nvalue(ingred)
cal+=(nut[0][1])*q
carb+=(nut[0][2])*q
prot+=(nut[0][3])*q
fat+=(nut[0][4])*q
string="calories="+str(cal)+",carb="+str(carb)+",prot="+str(prot)+",fat="+str(fat)
list1.insert(END,string)