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