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'])
