def check_duplicate(username): conn=create_connection() count=r.db('udio').table('users').filter({'username':username }).count().run(conn) if count > 0: return 1 else: return 0
def check_duplicate(username): conn = create_connection() count = r.db('udio').table('users').filter({ 'username': username }).count().run(conn) if count > 0: return 1 else: return 0
def post(self): username=request.form['username'] password=request.form['password'] print username print password conn=create_connection() user=list(r.db('udio').table('users').filter((r.row['username']==username) & (r.row['password']==password) ).pluck('id').run(conn)) close_connection(conn) print user id={'userid':user} return jsonify(id=id) conn=create_connection() count=r.db('udio').table('users').filter((r.row['username']== username) & (r.row['password']==password) ).count().run(conn) if count > 0: user=list(r.db('udio').table('users').filter((r.row['username']== username) & (r.row['password']==password) ).run(conn)) return { 'user': user} else: return {'error':'user not found'}
def post(self): ride_id=request.form['ride_id'] lon=request.form['lon'] lat=request.form['lat'] conn=create_connection() r.db('udio').table('rides').get(ride_id).update({'cordinates': r.row['cordinates'].append({'lat':lat, 'lon':lon})}).run(conn) print lat print lon close_connection(conn) return 'post'
def select_ride(): from_place=request.form['from'] to_place=request.form['to'] if from_place == to_place: flash ("Selected places are same") return render_template('admin/admin.html') else: conn=create_connection() rides=list(r.db('udio').table('users').filter((r.row['from_place']==from_place)).filter (r.row['to_place']==to_place).order_by(index='date').run(conn)) conn.close() return render_template('admin/rides.html')
def sender_reg(): if request.method=="GET": return render_template('main/snp.html') if request.method == "POST": firstname=request.form['firstname'] lastname=request.form['lastname'] address=request.form['address'] dob=request.form['dob'] licence=request.form['licence'] username=request.form['username'] password=request.form['password'] country=request.form['country'] state=request.form['state'] district=request.form['district'] pin=request.form['pin'] mobile=request.form['mobile'] email=request.form['email'] file=request.files['file_upload'] conn=create_connection() access=check_duplicate(username) if access==1: flash("Username already taken. Please use a different username") return render_template('main/login.html') else: if file and allowed_file(file.filename): filename=username+'.jpg' file.save(os.path.join(app.config['UPLOAD_FOLDER'],filename)) else : return "Error!.Profile image uploaded is incompatible" r.db('udio').table('users').insert([ { 'firstname':firstname, 'lastname':lastname, 'address':address, 'dob':dob, 'licence':licence, 'username':username, 'password':password, 'country':country, 'state':state, 'district':district, 'pin':pin, 'mobile':mobile, 'email':email, 'packages':[], 'rides':[], 'image_path':'static/tmp/'+filename } ]).run(conn) close_connection(conn) return render_template('main/signup.html')
def delivery(): if 'user' in session: name=session['user'][0]['firstname']+session['user'][0]['lastname'] conn=create_connection() rides=list(r.db('udio').table('rides').filter({'rider_id':session['user'][0]['id']}).run(conn,time_format="raw")) sender=list(r.db('udio').table('packages').filter({'sender_id':session['user'][0]['id']}).run(conn,time_format="raw")) #return json.dumps(rides) close_connection(conn) return render_template('admin/reviews.html',name=name,img=session['user'][0]['image_path'],rides=rides,sender=sender) else : flash("You are not logged in ") return redirect(url_for('login.html'))
def select_ride(): from_place = request.form['from'] to_place = request.form['to'] if from_place == to_place: flash("Selected places are same") return render_template('admin/admin.html') else: conn = create_connection() rides = list( r.db('udio').table('users').filter( (r.row['from_place'] == from_place)).filter( r.row['to_place'] == to_place).order_by( index='date').run(conn)) conn.close() return render_template('admin/rides.html')
def tripplan(): if request.method=='GET': if 'user' in session: name=session['user'][0]['firstname']+session['user'][0]['lastname'] return render_template('admin/tripplan.html',name=name,img=session['user'][0]['image_path'],) else: return redirect(url_for('login')) if request.method=='POST': to_place=request.form['to_place'] from_place=request.form['from_place'] date=request.form['date'] vehicle=request.form['vehicle'] time=request.form['time'] conn=create_connection() extra_info=request.form['extra_info'] mobile=session['user'][0]['mobile'] geo=get_location(from_place) geo_from_lat=geo[0] geo_from_lon=geo[1] ride=list(r.db('udio').table('rides').insert([ { 'to_place':to_place, 'licence':session['user'][0]['licence'], 'from_place':from_place, 'date':date, 'time':time, 'vehicle':vehicle, 'extra_info':extra_info, 'availability':0, 'done':0, 'created_date':r.now(), 'rider_id':session['user'][0]['id'], 'email':session['user'][0]['email'], 'name':session['user'][0]['firstname']+session['user'][0]['lastname'], 'review':0, 'image_path':session['user'][0]['image_path'], 'current':1, 'mobile':mobile, 'cordinates':[{'lat':geo_from_lat,'lon':geo_from_lon }], 'sender_id':0 }]).run(g.rdb_conn,time_format="raw")) return render_template('admin/ride_created.html',riders=ride[0],name=session['user'][0]['firstname']+session['user'][0]['lastname'],img=session['user'][0]['image_path'])
def create_ride(sender_id): if request.method=='GET': return "create rider" if request.method=='POST': from_place=request.form['from'] to=request.form['to'] conn=create_connection() data=list(r.db('udio').table('rides').insert([ { 'sender_id':sender_id, 'from_place':from_place, 'to_place':to, 'date':r.now(), 'completed':0, 'rider_id':None }]).run(conn)) print (data[0]['id']) user=r.db('udio').table('users').filter({'id':session['user'][0]['id'] }).prepend(data[0]['id']).run(conn) close_connection(conn) return "rider created"
def create_ride(sender_id): if request.method == 'GET': return "create rider" if request.method == 'POST': from_place = request.form['from'] to = request.form['to'] conn = create_connection() data = list( r.db('udio').table('rides').insert([{ 'sender_id': sender_id, 'from_place': from_place, 'to_place': to, 'date': r.now(), 'completed': 0, 'rider_id': None }]).run(conn)) print(data[0]['id']) user = r.db('udio').table('users').filter({ 'id': session['user'][0]['id'] }).prepend(data[0]['id']).run(conn) close_connection(conn) return "rider created"
def delivery(): if 'user' in session: name = session['user'][0]['firstname'] + session['user'][0]['lastname'] conn = create_connection() rides = list( r.db('udio').table('rides').filter({ 'rider_id': session['user'][0]['id'] }).run(conn, time_format="raw")) sender = list( r.db('udio').table('packages').filter({ 'sender_id': session['user'][0]['id'] }).run(conn, time_format="raw")) #return json.dumps(rides) close_connection(conn) return render_template('admin/reviews.html', name=name, img=session['user'][0]['image_path'], rides=rides, sender=sender) else: flash("You are not logged in ") return redirect(url_for('login.html'))
def sender_reg(): if request.method == "GET": return render_template('main/snp.html') if request.method == "POST": firstname = request.form['firstname'] lastname = request.form['lastname'] address = request.form['address'] dob = request.form['dob'] licence = request.form['licence'] username = request.form['username'] password = request.form['password'] country = request.form['country'] state = request.form['state'] district = request.form['district'] pin = request.form['pin'] mobile = request.form['mobile'] email = request.form['email'] file = request.files['file_upload'] conn = create_connection() access = check_duplicate(username) if access == 1: flash("Username already taken. Please use a different username") return render_template('main/login.html') else: if file and allowed_file(file.filename): filename = username + '.jpg' file.save(os.path.join(app.config['UPLOAD_FOLDER'], filename)) else: return "Error!.Profile image uploaded is incompatible" r.db('udio').table('users').insert([{ 'firstname': firstname, 'lastname': lastname, 'address': address, 'dob': dob, 'licence': licence, 'username': username, 'password': password, 'country': country, 'state': state, 'district': district, 'pin': pin, 'mobile': mobile, 'email': email, 'packages': [], 'rides': [], 'image_path': 'static/tmp/' + filename }]).run(conn) close_connection(conn) return render_template('main/signup.html')
def tripplan(): if request.method == 'GET': if 'user' in session: name = session['user'][0]['firstname'] + session['user'][0][ 'lastname'] return render_template( 'admin/tripplan.html', name=name, img=session['user'][0]['image_path'], ) else: return redirect(url_for('login')) if request.method == 'POST': to_place = request.form['to_place'] from_place = request.form['from_place'] date = request.form['date'] vehicle = request.form['vehicle'] time = request.form['time'] conn = create_connection() extra_info = request.form['extra_info'] mobile = session['user'][0]['mobile'] geo = get_location(from_place) geo_from_lat = geo[0] geo_from_lon = geo[1] ride = list( r.db('udio').table('rides').insert([{ 'to_place': to_place, 'licence': session['user'][0]['licence'], 'from_place': from_place, 'date': date, 'time': time, 'vehicle': vehicle, 'extra_info': extra_info, 'availability': 0, 'done': 0, 'created_date': r.now(), 'rider_id': session['user'][0]['id'], 'email': session['user'][0]['email'], 'name': session['user'][0]['firstname'] + session['user'][0]['lastname'], 'review': 0, 'image_path': session['user'][0]['image_path'], 'current': 1, 'mobile': mobile, 'cordinates': [{ 'lat': geo_from_lat, 'lon': geo_from_lon }], 'sender_id': 0 }]).run(g.rdb_conn, time_format="raw")) return render_template('admin/ride_created.html', riders=ride[0], name=session['user'][0]['firstname'] + session['user'][0]['lastname'], img=session['user'][0]['image_path'])