def listofblockedcustomer():
try:
c, conn = connection()
c.execute("SELECT * from Block")
blocked = []
x = c.fetchall()
conn.commit()
c.close()
gc.collect()
for row in x:
z = {"mobile_number": row[0]}
blocked.append(z)
blockedcustomers = []
for a in blocked:
c, conn = connection()
mobile_number = a['mobile_number']
c.execute("SELECT * from Customer where mobile_number = %s ",
[mobile_number])
y = c.fetchone()
conn.commit()
c.close()
gc.collect()
d = {"full_name": y[0], "mobile_number": y[1]}
blockedcustomers.append(d)
#return json.dumps(blockedcustomers , indent = 0)
return render_template("listofblockedcustomer.html",
blockedcustomers=blockedcustomers)
except Exception as e:
return "error"
def goonline():
username = request.form['username']
latitude = float(request.form['latitude'])
longitude = float(request.form['longitude'])
c, conn =connection()
c.execute("SELECT * from OnlineDriver where username = %s",[username])
x = c.fetchone()
c.close()
conn.commit()
gc.collect()
if x:
c, conn =connection()
c.execute("DELETE from OnlineDriver where username = %s",[username])
c.close()
conn.commit()
gc.collect()
else:
pass
c, conn = connection()
c.execute("""INSERT INTO OnlineDriver (username,longitude,latitude,with_customer) VALUES (%s,%s,%s,%s)""",(username,longitude,latitude,False))
conn.commit()
c.close()
gc.collect()
return "online"
def completedaride():
username = request.form['username']
distance = request.form['distance']
time = request.form['time']
fare = request.form['fare']
c, conn = connection()
c.execute("SELECT * from Ride where username = %s ORDER BY timeofride DESC ",[username])
x=c.fetchone()
c.close()
conn.commit()
gc.collect()
current_customer = x[5]
c,conn = connection()
c.execute("UPDATE Ride set distance = %s , time = %s , fare = %s where username = %s and mobile_number = %s ",(distance,time,fare,username,current_customer))
conn.commit()
c.close()
gc.collect()
c, conn = connection()
c.execute("UPDATE OnlineDriver SET with_costumer = %s WHERE username = %s ",(False, username))
conn.commit()
c.close()
gc.collect()
return "You completed a ride."
def requesttoblock():
username = request.form['username']
mobile_number = request.form['mobile_number']
c, conn = connection()
c.execute("SELECT * from RequestToBlock where mobile_number = %s ",[mobile_number])
x= c.fetchall()
conn.commit()
c.close()
gc.collect()
if len(x) == 4:
c,conn = connection()
c.execute("INSERT into Block (mobile_number) values (%s)",(mobile_number))
conn.commit()
c.close()
gc.collect()
else:
c,conn = connection()
c.execute("INSERT into RequestToBlock (mobile_number, requested_by) values (%s,%s)",(mobile_number,username))
conn.commit()
c.close()
gc.collect()
return "Your request to block "+ mobile_number + "has been considered."
def requesttoblock():
username = request.form['username']
mobile_number = request.form['mobile_number']
c, conn = connection()
c.execute("SELECT * from RequestToBlock where mobile_number = %s ",
[mobile_number])
x = c.fetchall()
conn.commit()
c.close()
gc.collect()
if len(x) == 4:
c, conn = connection()
c.execute("INSERT into Block (mobile_number) values (%s)",
(mobile_number))
conn.commit()
c.close()
gc.collect()
else:
c, conn = connection()
c.execute(
"INSERT into RequestToBlock (mobile_number, requested_by) values (%s,%s)",
(mobile_number, username))
conn.commit()
c.close()
gc.collect()
return "Your request to block " + mobile_number + "has been considered."
def callno():
username = request.form['username']
c, conn = connection()
c.execute(
"SELECT * from Ride where username = %s ORDER BY timeofride DESC ",
[username])
x = c.fetchone()
conn.commit()
c.close()
gc.collect()
username = x[0]
calledtimeofride = x[1]
mobile_number = x[4]
c, conn = connection()
timeofride = str(datetime.datetime.now())
c.execute(
"UPDATE Ride set status = %s WHERE username = %s and mobile_number = %s and timeofride = %s",
("CANCELLED", username, mobile_number, calledtimeofride))
conn.commit()
c.close()
gc.collect()
c, conn = connection()
c.execute(
"""UPDATE OnlineDriver SET with_customer = %s where username = %s""",
(False, username))
c.close()
conn.commit()
return "callNo"
def goonline():
username = request.form['username']
latitude = float(request.form['latitude'])
longitude = float(request.form['longitude'])
c, conn = connection()
c.execute("SELECT * from OnlineDriver where username = %s", [username])
x = c.fetchone()
c.close()
conn.commit()
gc.collect()
if x:
c, conn = connection()
c.execute("DELETE from OnlineDriver where username = %s", [username])
c.close()
conn.commit()
gc.collect()
else:
pass
c, conn = connection()
c.execute(
"""INSERT INTO OnlineDriver (username,longitude,latitude,with_customer) VALUES (%s,%s,%s,%s)""",
(username, longitude, latitude, False))
conn.commit()
c.close()
gc.collect()
return "online"
def completedaride():
username = request.form['username']
distance = request.form['distance']
time = request.form['time']
fare = request.form['fare']
c, conn = connection()
c.execute(
"SELECT * from Ride where username = %s ORDER BY timeofride DESC ",
[username])
x = c.fetchone()
c.close()
conn.commit()
gc.collect()
current_customer = x[5]
c, conn = connection()
c.execute(
"UPDATE Ride set distance = %s , time = %s , fare = %s where username = %s and mobile_number = %s ",
(distance, time, fare, username, current_customer))
conn.commit()
c.close()
gc.collect()
c, conn = connection()
c.execute(
"UPDATE OnlineDriver SET with_costumer = %s WHERE username = %s ",
(False, username))
conn.commit()
c.close()
gc.collect()
return "You completed a ride."
def mydrivers():
mobile_number = request.form['mobile_number']
c, conn = connection()
c.execute("SELECT * FROM Ride where mobile_number = %s)", [mobile_number])
x = c.fetchall()
conn.commit()
c.close()
gc.collect()
driver = []
for row in x:
z = {"username": row[1], "timeofride": row[2]}
driver.append(z)
driversinfo = []
for a in driver:
c, conn = connection()
username = a['username']
c.execute("SELECT * from Driver where username = %s ", [username])
y = c.fetchone()
conn.commit()
c.close()
gc.collect()
d = {
"full_name": y[0],
"mobile_number": y[3],
"taxi_number": y[6],
"timeofride": a['timeofride']
}
driversinfo.append(d)
drivers = {"drivers": driversinfo}
return json.dumps(drivers, indent=0)
def callno():
username = request.form['username']
c, conn = connection()
c.execute("SELECT * from Ride where username = %s ORDER BY timeofride DESC ",[username])
x=c.fetchone()
conn.commit()
c.close()
gc.collect()
username = x[0]
calledtimeofride = x[1]
mobile_number = x[4]
c,conn = connection()
timeofride = str(datetime.datetime.now())
c.execute("UPDATE Ride set status = %s WHERE username = %s and mobile_number = %s and timeofride = %s",("CANCELLED", username,mobile_number , calledtimeofride))
conn.commit()
c.close()
gc.collect()
c,conn = connection()
c.execute("""UPDATE OnlineDriver SET with_customer = %s where username = %s""",(False,username))
c.close()
conn.commit()
return "callNo"
def listofdrivers():
try:
if request.method == "GET":
c, conn = connection()
c.execute("SELECT * from Driver ")
drivers = []
x = c.fetchall()
for row in x:
z = {
"full_name": row[0],
"license_number": row[1],
"address": row[2],
"mobile_number": row[3],
"username": row[4],
"password": row[5],
"taxi_number": row[6]
}
drivers.append(z)
conn.commit()
c.close()
gc.collect()
return render_template("listofdrivers.html", drivers=drivers)
else:
info = request.form['x']
c, conn = connection()
c.execute(
"SELECT * from Driver where full_name = %s or mobile_number = %s or taxi_number = %s or username = %s",
(info, info, info, info))
drivers = []
x = c.fetchall()
for row in x:
z = {
"full_name": row[0],
"license_number": row[1],
"address": row[2],
"mobile_number": row[3],
"username": row[4],
"password": row[5],
"taxi_number": row[6]
}
drivers.append(z)
conn.commit()
c.close()
gc.collect()
return render_template("listofdrivers.html", drivers=drivers)
except Exception as e:
return "error"
def listofdrivers():
try:
if request.method == "GET":
c , conn = connection()
c.execute("SELECT * from Driver ")
drivers = []
x = c.fetchall()
for row in x:
z= {
"full_name": row[0],
"license_number": row[1],
"address": row[2],
"mobile_number": row[3],
"username": row[4],
"password": row[5],
"taxi_number": row[6]
}
drivers.append(z)
conn.commit()
c.close()
gc.collect()
return render_template("listofdrivers.html", drivers = drivers)
else:
info = request.form['x']
c , conn = connection()
c.execute("SELECT * from Driver where full_name = %s or mobile_number = %s or taxi_number = %s or username = %s",(info,info,info,info))
drivers = []
x = c.fetchall()
for row in x:
z= {
"full_name": row[0],
"license_number": row[1],
"address": row[2],
"mobile_number": row[3],
"username": row[4],
"password": row[5],
"taxi_number": row[6]
}
drivers.append(z)
conn.commit()
c.close()
gc.collect()
return render_template("listofdrivers.html", drivers = drivers)
except Exception as e:
return "error"
def update(username):
if request.method == "POST":
entered_license_number = request.form['license_number']
entered_address = request.form['address']
entered_mobile_number = request.form['mobile_number']
entered_password = request.form['password']
entered_taxi_number = request.form['taxi_number']
c, conn = connection()
c.execute("""Select * From Driver where mobile_number = %s""",
[entered_mobile_number])
x = c.fetchone()
c.close()
conn.commit()
gc.collect()
if x:
flash("This Mobile Number is already taken")
return render_template("register.html")
else:
pass
c, conn = connection()
c.execute("""Select * From Driver where taxi_number = %s""",
[entered_taxi_number])
x = c.fetchone()
conn.commit()
c.close()
gc.collect()
if x:
flash("This Taxi Number is already taken")
return render_template("register.html")
else:
pass
c, conn = connection()
c.execute(
"""UPDATE Driver SET license_number = %s , address = %s , mobile_number = %s , password = %s , taxi_number = %s where username = %s""",
(entered_license_number, entered_address, entered_mobile_number,
entered_password, entered_taxi_number, username))
conn.commit()
c.close()
gc.collect()
return redirect(url_for(".details", username=username))
else:
return render_template("update.html", username=username)
def listofcustomers():
try:
if request.method == "GET":
c , conn = connection()
c.execute("SELECT * from Customer")
customers = []
x = c.fetchall()
for row in x:
z= {
"full_name": row[0],
"mobile_number": row[1]
}
customers.append(z)
conn.commit()
c.close()
gc.collect()
return render_template("listofcustomers.html", customers = customers)
else:
info = request.form['x']
c , conn = connection()
c.execute("SELECT * from Customer where full_name = %s or mobile_number = %s",(info,info))
customers = []
x = c.fetchall()
for row in x:
z= {
"full_name": row[0],
"mobile_number": row[1]
}
customers.append(z)
conn.commit()
c.close()
gc.collect()
return render_template("listofcustomers.html", customers = customers)
except Exception as e:
return "error"
def listofrequestedblock():
try:
c , conn = connection()
c.execute("SELECT * from RequestToBlock")
block = []
x = c.fetchall()
conn.commit()
c.close()
gc.collect()
for row in x:
z= {
"mobile_number": row[0],
"username": row[1]
}
block.append(z)
info = []
for a in block:
mobile_number = a['mobile_number']
username = a['username']
c,conn = connection()
c.execute("SELECT * from Customer where mobile_number = %s ",[mobile_number])
y=c.fetchone()
conn.commit()
c.close()
gc.collect()
c,conn = connection()
c.execute("SELECT * from Driver where username = %s ",[username])
z=c.fetchone()
conn.commit()
c.close()
gc.collect()
d={
"full_name": y[0],
"dfull_name": z[0]
}
info.append(d)
#return json.dumps(info , indent = 0)
return render_template("listofrequestedblock.html", info = info)
except Exception as e:
return "error"
def updateme():
username = request.form['username']
latitude = float(request.form['latitude'])
longitude = float(request.form['longitude'])
c, conn =connection()
c.execute("DELETE from OnlineDriver where username = %s",[username])
c.close()
conn.commit()
gc.collect()
c, conn = connection()
c.execute("""UPDATE OnlineDriver SET longitude =%s , latitude =%s , with_costumer = %s WHERE username = %s""",(longitude,latitude,False ,username,))
conn.commit()
c.close()
gc.collect()
return "Your location has been updated."
def showprofile():
try:
username = request.form['username']
c,conn = connection()
c.execute("SELECT * FROM Driver where username = %s",[username])
x= c.fetchone()
driver = []
driver1 = {
"full_name" : x[0],
"license_number" : x[1],
"address" : x[2],
"mobile_number" : x[3],
"taxi_number" : x[6],
"username" : x[4]
}
driver.append(driver1)
jsdriver = {"driver":driver}
conn.commit()
c.close()
gc.collect()
return json.dumps(jsdriver,indent = 0)
except Exception as e:
return e
def login():
if request.method == 'POST':
email_id = request.form['sign-in-email']
c, conn = connection()
c.execute("SELECT * FROM users WHERE email=%s;", tuple([email_id]))
x = c.fetchall()
c.close()
conn.close()
gc.collect()
if len(x) == 0:
flash('Invalid username!')
return redirect(url_for('home'))
else:
if sha256_crypt.verify(request.form['sign-in-password'], x[0][3]):
session['logged_in'] = True
session['email'] = email_id
session['name'] = x[0][1]
session['uid'] = x[0][0]
flash('Welcome, ' + session['name'] +
'! You are now logged in!')
return redirect('/upload-image')
else:
flash('Login failed!')
return redirect(url_for('home'))
else:
return redirect(url_for('home'))
def adminRegisteration():
try:
if request.method == 'POST':
if request.form['regcode'] == 'ss123':
c, conn = connection()
testname = 'users'
c.execute("use %s ;" %testname)
conn.commit()
x = c.execute("select * from users where username = '******'" %(thwart(request.form['username'])))
if int(x) > 0:
flash("Oops!! That username already exists, Try something else")
return render_template("adminregister.html")
else:
databaseReply = userRegistrationInDatabase(testname, request.form['username'], request.form['password'],request.form['emailid'], request.form['name'])
flash(databaseReply)
session['logged_in'] = True
session['username'] = request.form['username']
return redirect(url_for('dashboard'))
else:
flash("Invalid Registeration Code")
return redirect(url_for('adminRegisteration'))
else:
return render_template("adminregister.html")
except Exception as e:
return str(e)
def login():
error=''
try:
form2 = UserRegisteration(request.form)
c,conn = connection()
if request.method =='POST':
if request.args.get('testname'):
reply = userLogin(request.args.get('testname'), request.form['username'], request.form['password'])
if reply:
session['logged_in'] = True
session['username'] = request.form['username']
flash('You are now logged in!')
return redirect(url_for('dashboard'))
else:
flash('Authentication failed')
else:
reply = userLogin("users", request.form['username'], request.form['password'])
if reply is True:
session['logged_in'] = True
session['username'] = request.form['username']
session['admin'] = True
flash('You are now logged in!')
return redirect(url_for('dashboard'))
else:
flash('Authentication failed')
else:
flash("Welcome to login page")
return render_template("login.html", form=form2, testname=request.args.get('testname'))
except Exception as e:
return (str(e))
def signup():
error = None
try:
c,conn = connection()
if request.method == "POST":
name = request.form['name']
email = request.form['email']
password = request.form['password']
x = c.execute("INSERT into users (name,email,password) VALUES (%s,%s,%s)",(thwart(name),thwart(email),thwart(password)))
if x == True:
flash("Successfully registered!")
conn.commit()
conn.close()
gc.collect()
return redirect(u"/Login/")
else:
flash("Error signing up!")
except Exception as e:
flash(e)
return render_template('signup.html')
def accountSettings():
try:
c,conn = connection()
uid = int(session['user_id'])
if request.method == "POST":
newEmail = str(request.form['email'])
newPassword = str(request.form['password'])
# flash(type(newEmail))
# flash(type(newPassword))
c.execute("UPDATE users SET email = %s, password = %s where id = %s",(newEmail,newPassword,uid))
conn.commit()
flash("Update successful!")
gc.collect()
conn.close()
except Exception as e:
flash(e)
return render_template('accountSettings.html')
def update_user_tracking():
try:
completed = str(request.args['completed'])
if completed in str(TOPIC_DICT.values()):
client_name, settings, tracking, rank = userinformation()
if tracking == None:
tracking = completed
else:
if completed not in tracking:
tracking = tracking + "," + completed
c, conn = connection()
c.execute("UPDATE users SET tracking = %s WHERE username = %s",
(thwart(tracking), thwart(client_name)))
conn.commit()
c.close()
conn.close()
client_name, settings, tracking, rank = userinformation()
#flash(str(client_name))
#flash(str(tracking))
else:
pass
except Exception, e:
pass
def login():
try:
error = ""
if request. method == "POST":
c, conn = connection()
c. execute( "SELECT username, uid, password FROM users WHERE username = (%s)", (thwart( request. form[ 'username']), ) )
for row in c:
if sha256_crypt. verify( request. form[ 'password'], row[ 2] ):
session[ 'logged_in'] = True
session[ 'username'] = request. form[ 'username']
flash( "Login Successful!")
gc. collect()
c. close()
conn. close()
return redirect(url_for("dashboard"))
error = "Invalid Credentials"
gc. collect()
c. close()
conn. close()
return render_template( "login.html", error = error)
return render_template( "login.html", error = error)
except Exception as e:
#return( str( e) )
return render_template( "login.html", error = "exceptOccured")
def login():
error = ''
try:
c, conn = connection()
if request.method == "POST":
data = c.execute("SELECT * FROM users where username = '******'" %
(thwart(request.form['username'])))
if (data):
data = c.fetchone()[2]
if sha256_crypt.verify(request.form['password'], data):
session['logged_in'] = True
session['username'] = request.form['username']
flash("You are now logged in...")
return redirect(url_for("dashboard"))
else:
error = "Invalid Credentials, try again."
else:
error = "Invalid Credentials"
gc.collect()
return render_template('login.html', error=error)
except Exception as e:
error = "Invalid Credentials, try again."
return render_template("login.html", error=e)
def showprofile():
try:
username = request.form['username']
c, conn = connection()
c.execute("SELECT * FROM Driver where username = %s", [username])
x = c.fetchone()
driver = []
driver1 = {
"full_name": x[0],
"license_number": x[1],
"address": x[2],
"mobile_number": x[3],
"taxi_number": x[6],
"username": x[4]
}
driver.append(driver1)
jsdriver = {"driver": driver}
conn.commit()
c.close()
gc.collect()
return json.dumps(jsdriver, indent=0)
except Exception as e:
return e
def show_users():
c, conn = connection()
c.execute('SELECT name, email FROM users;')
x = c.fetchall()
for each in x:
flash(str(each[0]) + ' - ' + str(each[1]))
return redirect(url_for('home'))
def driverlogout():
username = request.form['username']
c, conn = connection()
c.execute("DELETE from ForToken where username = %s ", [username])
conn.commit()
c.close()
gc.collect()
return "logged out" + username
def finaldelete(username):
c, conn = connection()
c.execute("DELETE from Driver where username = %s ", [username])
conn.commit()
c.close()
gc.collect()
return redirect(url_for(".listofdrivers"))
def fetchCars(color):
try:
c, conn = connection()
c.execute("SELECT t_cars.cn, t_cars.`name`, t_cars.color FROM t_cars WHERE t_cars.color = %s ORDER BY t_cars.cn ASC", color)
data_list = c.fetchall()
return json.dumps(data_list, default=str, sort_keys=True, ensure_ascii=False)
except Exception as e:
return str(e)
def fetchData():
try:
c, conn = connection()
c.execute("call sp_cars()")
data_list = c.fetchall()
return json.dumps(data_list, default=str, sort_keys=True, ensure_ascii=False)
except Exception as e:
return str(e)
def customerlogout():
mobile_number = request.form['mobile_number']
c, conn = connection()
c.execute("DELETE from ForToken where mobile_number = %s ",[mobile_number])
conn.commit()
c.close()
gc.collect()
return "logged out"
def update(username):
if request.method == "POST":
entered_license_number = request.form['license_number']
entered_address = request.form['address']
entered_mobile_number = request.form['mobile_number']
entered_password = request.form['password']
entered_taxi_number = request.form['taxi_number']
c, conn = connection()
c.execute("""Select * From Driver where mobile_number = %s""",[entered_mobile_number])
x= c.fetchone()
c.close()
conn.commit()
gc.collect()
if x:
flash("This Mobile Number is already taken")
return render_template("register.html")
else:
pass
c, conn = connection()
c.execute("""Select * From Driver where taxi_number = %s""",[entered_taxi_number])
x=c.fetchone()
conn.commit()
c.close()
gc.collect()
if x:
flash("This Taxi Number is already taken")
return render_template("register.html")
else:
pass
c, conn = connection()
c.execute("""UPDATE Driver SET license_number = %s , address = %s , mobile_number = %s , password = %s , taxi_number = %s where username = %s""",(entered_license_number,entered_address,entered_mobile_number,entered_password,entered_taxi_number,username))
conn.commit()
c.close()
gc.collect()
return redirect(url_for(".details", username = username ))
else:
return render_template("update.html", username = username)
def driverlogout():
username = request.form['username']
c, conn = connection()
c.execute("DELETE from ForToken where username = %s ",[username])
conn.commit()
c.close()
gc.collect()
return "logged out" + username
def finaldelete(username):
c,conn = connection()
c.execute("DELETE from Driver where username = %s ",[username])
conn.commit()
c.close()
gc.collect()
return redirect(url_for(".listofdrivers"))
def gotapassenger():
username = request.form['username']
c, conn = connection()
c.execute("UPDATE OnlineDriver SET with_costumer = %s WHERE username = %s ",(True, username))
c.close()
conn.commit()
gc.collect()
return "You have a costumer"
def gooffline():
username = request.form['username']
c, conn = connection()
c.execute("""DELETE FROM OnlineDriver WHERE username = %s""", (username, ))
conn.commit()
c.close()
gc.collect()
return "You went offline."
def delete(username):
c,conn = connection()
c.execute("SELECT * from Driver where username = %s ",[username])
x=c.fetchone()
conn.commit()
c.close()
gc.collect()
return render_template("delete.html", driver = x)
def delete(username):
c, conn = connection()
c.execute("SELECT * from Driver where username = %s ", [username])
x = c.fetchone()
conn.commit()
c.close()
gc.collect()
return render_template("delete.html", driver=x)
def customerlogout():
mobile_number = request.form['mobile_number']
c, conn = connection()
c.execute("DELETE from ForToken where mobile_number = %s ",
[mobile_number])
conn.commit()
c.close()
gc.collect()
return "logged out"
def gooffline():
username = request.form['username']
c, conn = connection()
c.execute("""DELETE FROM OnlineDriver WHERE username = %s""",(username,))
conn.commit()
c.close()
gc.collect()
return "You went offline."
def mycustomers():
username = request.form['username']
c, conn = connection()
c.execute("SELECT * FROM Ride where username = %s", [username])
x = c.fetchall()
conn.commit()
c.close()
gc.collect()
if len(x) == 0:
return "Not a single ride"
else:
pass
customer = []
for row in x:
z = {
"mobile_number": row[4],
"timeofride": str(row[1]),
"status": row[6]
}
customer.append(z)
customersinfo = []
for a in customer:
c, conn = connection()
mobile_number = a['mobile_number']
c.execute("SELECT * from Customer where mobile_number = %s ",
[mobile_number])
y = c.fetchone()
c.close()
conn.commit()
gc.collect()
m = {
"full_name": y[0],
"mobile_number": mobile_number,
"timeofride": a['timeofride'],
"status": a['status']
}
customersinfo.append(m)
customers = {"customers": customersinfo}
return json.dumps(customers, indent=0)
def listofonlinedrivers():
try:
c , conn = connection()
c.execute("SELECT * from OnlineDriver")
onlinedrivers = []
x = c.fetchall()
conn.commit()
c.close()
gc.collect()
for row in x:
z= {
"username": row[0]
}
onlinedrivers.append(z)
#correct upto above line. Any mistakes that will occur will be from below here
onlinedriversinfo = []
for a in onlinedrivers:
c,conn = connection()
username = a['username']
c.execute("SELECT * from Driver where username = %s ",[username])
y=c.fetchone()
conn.commit()
c.close()
gc.collect()
d={
"full_name": y[0],
"mobile_number": y[3],
"license_number": y[1],
"taxi_number": y[6]
}
onlinedriversinfo.append(d)
return render_template("listofonlinedrivers.html", drivers = onlinedriversinfo)
except Exception as e:
return "error"
def details(username):
c, conn = connection()
c.execute("SELECT * from Driver where username = %s ", [username])
x = c.fetchone()
conn.commit()
c.close()
gc.collect()
photo_url = x[7]
return render_template("details.html", driver=x, photo_url=photo_url)
def getmeacode():
mobile_number = request.form['mobile_number']
c, conn = connection()
c.execute("SELECT * from Block where mobile_number = %s", [mobile_number])
x = c.fetchone()
conn.commit()
c.close()
gc.collect()
if x:
return "Your number is in the block list."
else:
c, conn = connection()
c.execute("SELECT * from Customer where mobile_number = %s",
[mobile_number])
x = c.fetchone()
conn.commit()
c.close()
gc.collect()
if x:
full_name = x[0]
return "Your number is already registered in the name of " + full_name
else:
code = randint(10000, 99999)
c = str(code)
sparrow(mobile_number, c)
c, conn = connection()
c.execute("DELETE from ForCode where mobile_number = %s",
[mobile_number])
conn.commit()
c.close()
gc.collect()
c, conn = connection()
c.execute(
"INSERT INTO ForCode (mobile_number, code) VALUES (%s,%s)",
(mobile_number, code))
conn.commit()
c.close()
gc.collect()
return "success"
def callnow():
if request.method == "POST":
mobile_number = request.form['mobile_number']
username = request.form['username']
c, conn = connection()
c.execute(
"""SELECT * FROM OnlineDriver WHERE username = %s and with_customer = %s""",
(username, False))
x = c.fetchone()
conn.commit()
c.close()
c, conn = connection()
c.execute("SELECT * from ForToken where username = %s", [username])
x = c.fetchone()
c.close()
conn.commit()
gc.collect()
registration_id = x[1]
message_title = mobile_number
message_body = "Hi " + username + " Did you get call from " + mobile_number + " ?"
result = push_service.notify_single_device(registration_id=registration_id,
message_title=message_title,
message_body=message_body)
c, conn = connection()
c.execute(
"""UPDATE OnlineDriver SET with_customer = %s where username = %s""",
(True, username))
c.close()
conn.commit()
c, conn = connection()
timeofride = str(datetime.datetime.now())
c.execute(
"INSERT INTO Ride (mobile_number, username, timeofride, status) values (%s,%s,%s,%s)",
(mobile_number, username, timeofride, "UNKNOWN"))
conn.commit()
c.close()
gc.collect()
return "success"
def gotapassenger():
username = request.form['username']
c, conn = connection()
c.execute(
"UPDATE OnlineDriver SET with_costumer = %s WHERE username = %s ",
(True, username))
c.close()
conn.commit()
gc.collect()
return "You have a costumer"
def mycustomers():
username = request.form['username']
c,conn = connection()
c.execute("SELECT * FROM Ride where username = %s",[username])
x = c.fetchall()
conn.commit()
c.close()
gc.collect()
if len(x) == 0:
return "Not a single ride"
else:
pass
customer = []
for row in x:
z= {
"mobile_number": row[4],
"timeofride": str(row[1]),
"status" : row[6]
}
customer.append(z)
customersinfo = []
for a in customer:
c,conn = connection()
mobile_number = a['mobile_number']
c.execute("SELECT * from Customer where mobile_number = %s ",[mobile_number])
y=c.fetchone()
c.close()
conn.commit()
gc.collect()
m={
"full_name" : y[0],
"mobile_number": mobile_number,
"timeofride": a['timeofride'],
"status" : a['status']
}
customersinfo.append(m)
customers = {"customers": customersinfo}
return json.dumps(customers,indent = 0)
def details(username):
c,conn = connection()
c.execute("SELECT * from Driver where username = %s ",[username])
x=c.fetchone()
conn.commit()
c.close()
gc.collect()
photo_url = x[7]
return render_template("details.html", driver = x, photo_url = photo_url)
def listofblockedcustomer():
try:
c , conn = connection()
c.execute("SELECT * from Block")
blocked = []
x = c.fetchall()
conn.commit()
c.close()
gc.collect()
for row in x:
z= {
"mobile_number": row[0]
}
blocked.append(z)
blockedcustomers = []
for a in blocked:
c,conn = connection()
mobile_number = a['mobile_number']
c.execute("SELECT * from Customer where mobile_number = %s ",[mobile_number])
y=c.fetchone()
conn.commit()
c.close()
gc.collect()
d={
"full_name": y[0],
"mobile_number": y[1]
}
blockedcustomers.append(d)
#return json.dumps(blockedcustomers , indent = 0)
return render_template("listofblockedcustomer.html", blockedcustomers = blockedcustomers)
except Exception as e:
return "error"
def driverlogin():
username = request.form['username']
password = request.form['password']
token = request.form['token']
c,conn = connection()
c.execute("SELECT * from Driver where username = %s",[username])
x= c.fetchone()
c.close()
conn.commit()
gc.collect()
if x:
if x[5] == password:
c,conn = connection()
c.execute("SELECT * from ForToken where username =%s",[username])
x= c.fetchone()
c.close()
conn.commit()
gc.collect()
if x:
c,conn = connection()
c.execute("DELETE from ForToken where username =%s",[username])
c.close()
conn.commit()
gc.collect()
c,conn = connection()
c.execute("INSERT into ForToken (username, token) values(%s,%s)",(username,token))
c.close()
conn.commit()
gc.collect()
return "success"
else:
return "failed"
else:
return "Not a registered user"
def registeracustomer():
full_name = request.form['full_name']
mobile_number = request.form['mobile_number']
password = request.form['password']
code = int(request.form['code'])
c,conn = connection()
c.execute("SELECT * from ForCode WHERE mobile_number = %s",[mobile_number])
x = c.fetchone()
conn.commit()
c.close()
gc.collect()
if int(x[1]) == code:
c,conn = connection()
c.execute("INSERT INTO Customer (full_name, mobile_number, password) VALUES (%s, %s, %s)",(full_name , mobile_number ,password) )
conn.commit()
c.close()
gc.collect()
return "success"
else:
return "failed"
def mydrivers():
mobile_number = request.form['mobile_number']
c,conn = connection()
c.execute("SELECT * FROM Ride where mobile_number = %s)",[mobile_number])
x = c.fetchall()
conn.commit()
c.close()
gc.collect()
driver = []
for row in x:
z= {
"username": row[1],
"timeofride": row[2]
}
driver.append(z)
driversinfo = []
for a in driver:
c,conn = connection()
username = a['username']
c.execute("SELECT * from Driver where username = %s ",[username])
y=c.fetchone()
conn.commit()
c.close()
gc.collect()
d={
"full_name": y[0],
"mobile_number": y[3],
"taxi_number": y[6],
"timeofride": a['timeofride']
}
driversinfo.append(d)
drivers = {"drivers": driversinfo}
return json.dumps(drivers,indent = 0)
def getmeacode():
mobile_number = request.form['mobile_number']
c,conn = connection()
c.execute("SELECT * from Block where mobile_number = %s",[mobile_number])
x= c.fetchone()
conn.commit()
c.close()
gc.collect()
if x:
return "Your number is in the block list."
else:
c, conn = connection()
c.execute("SELECT * from Customer where mobile_number = %s",[mobile_number])
x= c.fetchone()
conn.commit()
c.close()
gc.collect()
if x:
full_name = x[0]
return "Your number is already registered in the name of " + full_name
else:
code= randint(10000,99999)
c = str(code)
sparrow(mobile_number , c)
c, conn = connection()
c.execute("DELETE from ForCode where mobile_number = %s",[mobile_number])
conn.commit()
c.close()
gc.collect()
c,conn = connection()
c.execute("INSERT INTO ForCode (mobile_number, code) VALUES (%s,%s)",(mobile_number, code))
conn.commit()
c.close()
gc.collect()
return "success"
def callnow():
if request.method == "POST":
mobile_number = request.form['mobile_number']
username = request.form['username']
c , conn = connection()
c.execute("""SELECT * FROM OnlineDriver WHERE username = %s and with_customer = %s""",(username,False))
x = c.fetchone()
conn.commit()
c.close()
c,conn = connection()
c.execute("SELECT * from ForToken where username = %s",[username])
x=c.fetchone()
c.close()
conn.commit()
gc.collect()
registration_id = x[1]
message_title = mobile_number
message_body = "Hi " + username + " Did you get call from "+ mobile_number + " ?"
result = push_service.notify_single_device(registration_id=registration_id, message_title=message_title, message_body=message_body)
c,conn = connection()
c.execute("""UPDATE OnlineDriver SET with_customer = %s where username = %s""",(True,username))
c.close()
conn.commit()
c,conn = connection()
timeofride = str(datetime.datetime.now())
c.execute("INSERT INTO Ride (mobile_number, username, timeofride, status) values (%s,%s,%s,%s)",(mobile_number, username,timeofride, "UNKNOWN"))
conn.commit()
c.close()
gc.collect()
return "success"
def forgotpassword():
mobile_number = request.form['mobile_number']
c, conn = connection()
c.execute("SELECT * from Customer where mobile_number = %s",[mobile_number])
x= c.fetchone()
conn.commit()
c.close()
gc.collect()
if x:
password = x[2]
sparrow2(mobile_number , password)
return "Password is sent to your mobile number."
else:
return "Your number is not registered."
def driverforgotpassword():
username = request.form['username']
c, conn = connection()
c.execute("SELECT * from Driver where username = %s",[username])
x= c.fetchone()
conn.commit()
c.close()
gc.collect()
if x:
password = x[5]
mobile_number = x[3]
sparrow2(mobile_number , password)
return "Password is sent to your mobile number."
else:
return "Your number is not registered."
def alertcustomer():
username = request.form['username']
c, conn = connection()
c.execute("SELECT * from Ride where username = %s ORDER BY timeofride DESC ",[username])
x=c.fetchone()
conn.commit()
c.close()
gc.collect()
mobile_number = x[4]
#c,conn = connection()
#c.execute("SELECT * from ForCustomerToken where mobile_number = %s",[mobile_number])
#x=c.fetchone()
#conn.commit()
#gc.collect()
#registration_id = x[1]
#message_title = "Driver Arrival!"
#message_body = "The driver you requested has arrived. Have a safe ride !"
#result = push_service.notify_single_device(registration_id=registration_id, message_title=message_title, message_body=message_body)
return mobile_number
def showinformationofride():
mobile_number = request.form['mobile_number']
c, conn = connection()
c.execute("SELECT * from Ride where mobile_number = %s ORDER BY timeofride DESC ",[mobile_number])
x=c.fetchone()
conn.commit()
c.close()
gc.collect()
informationofride2 = []
informationofride1={
"current_driver" : x[0],
"started_time" : x[1],
"distance" : x[2],
"duration_of_ride" : x[3],
"fare" : x[4]
}
informationofride2.append(informationofride1)
informationofride = {"informationofride":informationofride2}
return json.dumps(informationofride,indent = 0)
def findmeataxi():
try:
mobile_number = request.form['mobile_number']
latitude = float(request.form['latitude'])
longitude = float(request.form['longitude'])
c,conn = connection()
c.execute("SELECT * from OnlineCustomer where mobile_number = %s",[mobile_number])
x=c.fetchone()
c.close()
conn.commit()
gc.collect()
if x:
c,conn = connection()
c.execute("DELETE from OnlineCustomer where mobile_number = %s",[mobile_number])
c.close()
conn.commit()
gc.collect()
else:
pass
c,conn = connection()
c.execute("INSERT into OnlineCustomer values(%s,%s,%s)",(mobile_number,latitude,longitude))
c.close()
conn.commit()
gc.collect()
w = latitude + float(0.018087434)
x = latitude - float(0.018087434)
y = longitude + float(0.018087434)
z = longitude - float(0.018087434)
c , conn = connection()
c.execute("""SELECT * FROM OnlineDriver WHERE longitude BETWEEN %s AND %s AND latitude BETWEEN %s AND %s and with_customer = %s """,(z,y,x,w,False))
#c.execute("""SELECT * FROM OnlineDriver where with_customer = %s""",[False])
x = c.fetchall()
conn.commit()
c.close()
gc.collect()
shortest_distance = 10000
if len(x)==0:
return "No Drivers"
else:
pass
for row in x:
d = calculatedistance(longitude,latitude,row[1],row[2])
if d < shortest_distance:
shortest_distance = d
nearest_user = row[0]
else:
pass
c , conn = connection()
c.execute("""SELECT * FROM Driver WHERE username = %s """,[nearest_user])
x = c.fetchone()
conn.commit()
c.close()
gc.collect()
driver1 = []
driver= {
"full_name": x[0],
"license_number": x[1],
"address": x[2],
"mobile_number": x[3],
"taxi_number" : x[6],
"username": x[4]
}
driver1.append(driver)
w= {"driver":driver1}
return json.dumps(w, indent=0)
except Exception as e:
return e
