-
Notifications
You must be signed in to change notification settings - Fork 0
/
application.py
230 lines (174 loc) · 7.14 KB
/
application.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
import sqlite3
from flask import Flask, redirect, render_template, request, session, url_for
from flask_session import Session
from passlib.apps import custom_app_context as pwd_context
from tempfile import mkdtemp
from werkzeug.contrib.fixers import ProxyFix
from helpers import apology, login_required
app = Flask(__name__)
app.wsgi_app = ProxyFix(app.wsgi_app)
if app.config["DEBUG"]:
@app.after_request
def after_request(response):
response.headers["Cache-Control"] = "no-cache, no-store, must-revalidate"
response.headers["Expires"] = 0
response.headers["Pragma"] = "no-cache"
return response
app.config["SESSION_FILE_DIR"] = mkdtemp()
app.config["SESSION_PERMANENT"] = False
app.config["SESSION_TYPE"] = "filesystem"
Session(app)
db = sqlite3.connect("finance.db")
@app.route("/")
@login_required
def index():
return render_template("welcome.html")
@app.route("/exercises")
@login_required
def exercises():
return render_template("exercises.html")
@app.route("/statistics")
@login_required
def statistics():
username = session["user"]
usr = db.cursor()
usr.execute("SELECT * FROM users WHERE username = ?", (username,))
rows = usr.fetchall()
bmi = rows[0][4] / (rows[0][3] * rows[0][3])
age = rows[0][5]
if bmi <= 18.5:
bmiStatement = 'which means you are underweight.'
elif bmi > 18.5 and bmi < 25:
bmiStatement = 'which means you are normal.'
elif bmi > 25 and bmi < 30:
bmiStatement = 'overweight.'
elif bmi > 30:
bmiStatement = 'which means you are obese.'
if rows[0][6] == "male":
BMR = 66.47 + (13.75 * rows[0][4]) + (5.0 * rows[0][3]) - (6.75 * age)
else:
BMR = 665.09 + (9.56 * rows[0][4]) + (1.84 * rows[0][3]) - (4.67 * age)
heightInCm = rows[0][3] * 2.54
idealWeight = int(heightInCm - 101)
usr.execute("SELECT * FROM dailyactivity WHERE user = ?", (username,))
userData = usr.fetchall()
totalWalked = 0
totalSleep = 0
totalJog = 0
totalCaloriesBurned = 0
for data in userData:
totalWalked += data[0]
totalSleep += data[3]
totalJog += data[2]
totalCaloriesBurned += data[7]
return render_template("statistics.html", bmi=round(bmi, 2), bmiStatement=bmiStatement, userData=userData,
totalWalked=totalWalked, BMR=round(BMR, 2), totalSleep=totalSleep, totalJog=totalJog,
currentweight=rows[0][3]
, currentheight=rows[0][4], age=age, idealWeight=idealWeight,
totalCaloriesBurned=totalCaloriesBurned)
@app.route("/diet_plans")
@login_required
def diet_plans():
return render_template("diet_plans.html")
@app.route("/gym_nearby")
@login_required
def gym_nearby():
return redirect("https://www.google.co.in/maps/search/GYM?hl=en&source=opensearch.html", code=302)
@app.route("/yoga")
@login_required
def yoga():
return render_template("yoga.html")
@app.route("/addDetails", methods=["GET", "POST"])
@login_required
def addDetails():
if request.method == "GET":
return render_template("addDetails.html")
elif request.method == "POST":
username = session["user"]
caloriesburn = int((0.42 * int(request.form.get("sleep"))) + (int(request.form.get("jog")) * 100) + (
0.05 * int(request.form.get("steps"))))
if (request.form.get("food") == "chicken"):
caloriesburn += 199
elif (request.form.get("food") == "naan"):
caloriesburn += 137
elif (request.form.get("food") == "palak paneer"):
caloriesburn += 300
elif (request.form.get("food") == "daal"):
caloriesburn += 166
db.execute("INSERT INTO dailyactivity (steps, food, jog, sleep, user, calories) VALUES (?,?,?,?,?,?)"
, (request.form.get("steps")
, request.form.get("food")
, request.form.get("jog")
, request.form.get("sleep")
, username
, caloriesburn))
if request.form.get("weight"):
db.execute("UPDATE users SET weight = (?) WHERE username = (?)"
, (request.form.get("weight")
, username,))
if request.form.get("height"):
db.execute("UPDATE users SET height = (?) WHERE username = (?)"
, (request.form.get("height"), username,))
db.commit()
return render_template("welcome.html")
@app.route("/login", methods=["GET", "POST"])
def login():
"""Log user in."""
# forget any user_id
session.clear()
# if user reached route via POST (as by submitting a form via POST)
if request.method == "POST":
# ensure username was submitted
if not request.form.get("username"):
return apology("must provide username")
# ensure password was submitted
elif not request.form.get("password"):
return apology("must provide password")
# query database for username
username = request.form.get("username")
usr = db.cursor()
usr.execute("SELECT * FROM users WHERE username =?", (username,))
rows = usr.fetchall()
# ensure username exists and password is correct
if len(rows) != 1 or not pwd_context.verify(request.form.get("password"), rows[0][2]):
return apology("invalid username and/or password")
# remember which user has logged in
session["user_id"] = rows[0][0]
session["user"] = request.form.get("username")
# redirect user to home page
return redirect(url_for("index"))
# else if user reached route via GET (as by clicking a link or via redirect)
else:
return render_template("login.html")
@app.route("/logout")
def logout():
"""Log user out."""
# forget any user_id
session.clear()
# redirect user to login form
return redirect(url_for("login"))
@app.route("/register", methods=["GET", "POST"])
def register():
"""Register user."""
if request.method == "POST":
if not request.form.get("username") or not request.form.get("password") or not request.form.get("Re-password"):
return apology("all the feilds are neccessory!")
elif request.form.get("password") != request.form.get("Re-password"):
return apology("pasword do not match!")
usr = db.cursor()
usr.execute("SELECT username FROM users")
rows = usr.fetchall()
for data in rows:
if data == request.form.get("username"):
return apology("User already Registered")
db.execute("INSERT INTO users (username, hash, age, gender, weight, height) VALUES(?,?,?,?,?,?)",
(request.form.get("username"),
pwd_context.hash(request.form.get("password")),
request.form.get("age"),
request.form.get("gender"),
request.form.get("weight"),
request.form.get("height"),))
db.commit()
return render_template("login.html")
else:
return render_template("register.html")