def message_all_volunteers(uuid,radius,search_radius):
v_list_q = """Select id as v_id,mob_number,name, latitude,longitude from volunteers where status=1"""
v_list = pd.read_sql(v_list_q,connections('prod_db_read'))
r_df = request_data_by_uuid(uuid)
r_id = r_df.loc[0,'r_id']
lat = r_df.loc[0,'latitude']
lon = r_df.loc[0,'longitude']
v_list['dist'] = get_haversine_distance(float(lat),float(lon),v_list['latitude'].astype(float).values,v_list['longitude'].astype(float).values)
v_list = v_list.sort_values(by='dist',ascending=True)
v_ids = pd.DataFrame()
df = pd.DataFrame()
df2 = pd.DataFrame()
count=0
orig_link = url_start+"accept/"+uuid
link = url_shortener_fn(orig_link)
print(link)
save_request_sms_url(uuid, 'accept_link', link)
for i in v_list.index:
if(v_list.loc[i,'dist']<radius):
count = count +1
if(count>20):
break
sms_text = nearby_v_sms_text.format(v_name=v_list.loc[i,'name'],link=link)
sms_to = int(v_list.loc[i,'mob_number'])
df = df.append(v_list.loc[i,['v_id']])
if((server_type=='prod')):
send_sms(sms_text,sms_to,sms_type='transactional',send=True)
print('SMS sent')
else:
print('Sending sms:',sms_text,' to ',str(sms_to))
if((v_list.loc[i,'dist']>radius)&(v_list.loc[i,'dist']<search_radius)):
count = count +1
if(count>20):
break
sms_text = far_v_sms_text.format(address=r_df.loc[0,'geoaddress'][0:40],link=link)
sms_to=int(v_list.loc[i,'mob_number'])
df2 = df2.append(v_list.loc[i,['v_id']])
if((server_type=='prod')):
send_sms(sms_text,sms_to,sms_type='transactional',send=True)
print('SMS sent')
else:
print('Sending sms:',sms_text,' to ',str(sms_to))
df['r_id']=r_id
df['status']='pending'
print(v_list)
print(df)
print(df2)
if((server_type=='prod')):
engine = connections('prod_db_write')
df.to_sql(name = 'nearby_volunteers', con = engine, schema='covidsos', if_exists='append', index = False,index_label=None)
mod_sms_text = request_verified_m_sms1.format(r_id=str(r_df.loc[0,'r_id']),name=r_df.loc[0,'name'],geoaddress=r_df.loc[0,'geoaddress'][0:50],mob_number=str(r_df.loc[0,'mob_number']),v_count_1=str(df.shape[0]),v_count_2=str(df2.shape[0]))
str_broadcast = "For request #"+str(r_df.loc[0,'r_id'])+ " "
counter_broadcast = 0
for i in v_list.index:
counter_broadcast = counter_broadcast+1
if((counter_broadcast>10) or (v_list.loc[i,'dist']>search_radius)):
break
str_broadcast = str_broadcast + v_list.loc[i,'name']+" m: wa.me/91"+str(v_list.loc[i,'mob_number'])+" "
link = url_shortener_fn("https://wa.me/918618948661?text="+p.quote(str_broadcast))
save_request_sms_url(uuid, 'broadcast_link', link)
mod_sms_text_2 = request_verified_m_sms2.format(link=link)
moderator_list = get_moderator_list()
for i_number in moderator_list:
if((server_type=='prod')):
send_sms(mod_sms_text,sms_to=int(i_number),sms_type='transactional',send=True)
send_sms(mod_sms_text_2,sms_to=int(i_number),sms_type='transactional',send=True)
print('SMS sent')
else:
print('Sending sms:',mod_sms_text,' to ',str(i_number))
print('Sending sms:',mod_sms_text_2,' to ',str(i_number))
return None
def assign_request_to_volunteer(volunteer_id, request_id, matched_by):
r_df = request_data_by_id(request_id)
v_df = volunteer_data_by_id(volunteer_id)
if (r_df.shape[0] == 0):
return {
'status': False,
'string_response': 'Request ID does not exist.',
'Response': {}
}
if (v_df.shape[0] == 0):
return {
'status': False,
'string_response': 'Volunteer does not exist',
'Response': {}
}
else:
if (r_df.loc[0, 'status'] in ['received', 'verified', 'pending']):
current_time = dt.datetime.utcnow() + dt.timedelta(minutes=330)
req_dict = {
'volunteer_id': [volunteer_id],
'request_id': [r_df.loc[0, 'r_id']],
'matching_by': [matched_by],
'timestamp': [current_time]
}
df = pd.DataFrame(req_dict)
#Add entry in request_matching table
response = request_matching(df)
#Update request status as matched
if response['status'] == True:
volunteers_assigned = get_volunteers_assigned_to_request(
request_id)
if r_df.loc[0, 'volunteers_reqd'] == volunteers_assigned:
response_2 = update_requests_db({'id': request_id},
{'status': 'matched'})
response_3 = update_nearby_volunteers_db(
{'r_id': request_id}, {'status': 'expired'})
#Move to message_templates.py file
#Send to Volunteer
v_sms_text = '[COVID SOS] Thank you agreeing to help. Name:' + r_df.loc[
0, 'name'] + ' Mob:' + str(
r_df.loc[0, 'mob_number']) + ' Request:' + r_df.loc[
0, 'request'] + ' Address:' + r_df.loc[0, 'geoaddress']
send_sms(v_sms_text,
int(v_df.loc[0, 'mob_number']),
sms_type='transactional',
send=True)
#Send to Requestor
r_sms_text = '[COVID SOS] Volunteer ' + v_df.loc[
0, 'name'] + ' will help you. Mob: ' + str(
v_df.loc[0, 'mob_number'])
send_sms(r_sms_text,
int(r_df.loc[0, 'mob_number']),
sms_type='transactional',
send=True)
#Send to Moderator
m_sms_text = '[COVID SOS] Volunteer ' + v_df.loc[
0, 'name'] + ' Mob: ' + str(
v_df.loc[0, 'mob_number']) + ' assigned to ' + r_df.loc[
0, 'name'] + ' Mob:' + str(r_df.loc[0, 'mob_number'])
moderator_list = get_moderator_list()
for i_number in moderator_list:
send_sms(m_sms_text,
int(i_number),
sms_type='transactional',
send=True)
else:
return {
'status': False,
'string_response': 'Request already assigned/closed/completed',
'Response': {}
}
return response
def create_request():
name = request.form.get('name')
mob_number = request.form.get('mob_number')
email_id = request.form.get('email_id', '')
age = request.form.get('age')
address = request.form.get('address')
geoaddress = request.form.get('geoaddress', address)
user_request = request.form.get('request')
latitude = request.form.get('latitude', 0.0)
longitude = request.form.get('longitude', 0.0)
source = request.form.get('source', 'covidsos')
status = request.form.get('status', 'received')
country = request.form.get('country', 'India')
current_time = dt.datetime.utcnow() + dt.timedelta(minutes=330)
uuid = generate_uuid()
req_dict = {
'timestamp': [current_time],
'name': [name],
'mob_number': [mob_number],
'email_id': [email_id],
'country': [country],
'address': [address],
'geoaddress': [geoaddress],
'latitude': [latitude],
'longitude': [longitude],
'source': [source],
'age': [age],
'request': [user_request],
'status': [status],
'uuid': [uuid]
}
df = pd.DataFrame(req_dict)
df['email_id'] = df['email_id'].fillna('')
expected_columns = [
'timestamp', 'name', 'mob_number', 'email_id', 'country', 'address',
'geoaddress', 'latitude', 'longitude', 'source', 'request', 'age',
'status', 'uuid'
]
x, y = add_requests(df)
response = {'Response': {}, 'status': x, 'string_response': y}
if (x):
#Move to message_templates.py file
url = "https://wa.me/918618948661?text=" + urllib.parse.quote_plus(
'Hi')
sms_text = "[COVIDSOS] " + name + ", we have received your request. We will call you soon. If urgent, please click " + url
send_sms(sms_text,
sms_to=int(mob_number),
sms_type='transactional',
send=True)
# mod_url = "https://wa.me/91"+str(mob_number)+"?text="+urllib.parse.quote_plus('Hey')
#Add to message_templates.py
mod_url = "https://covidsos.org/verify/" + str(uuid)
mod_sms_text = 'New query received. Verify lead by clicking here: ' + mod_url
moderator_list = get_moderator_list()
for i_number in moderator_list:
send_sms(mod_sms_text,
sms_to=int(i_number),
sms_type='transactional',
send=True)
#move to async
# volunteer_request.apply_async((latitude,longitude,neighbourhood_radius,search_radius,uuid),countdown=100)
#Move to Async after 5 mins
# sms_text = "[COVIDSOS] "+name+", you can track your request at "+url
# send_sms(sms_text,sms_to=int(mob_number),sms_type='transactional',send=True)
#Send SMS to volunteers via async Task:
#NEEDS REVIEW
# volunteer_sms_countdown = 30
# volunteer_request.apply_async((latitude,longitude,neighbourhood_radius,search_radius,uuid))
# no_volunteer_assigned.apply_async((latitude,longitude,neighbourhood_radius,search_radius,uuid),countdown=volunteer_sms_countdown)
#Schedule message after 30 mins depending on status - Send WhatsApp Link here.
return json.dumps(response)
def message_all_volunteers(uuid, radius, search_radius):
v_list_q = """Select id as v_id,mob_number,name, latitude,longitude from volunteers where status=1"""
v_list = pd.read_sql(v_list_q, connections('prod_db_read'))
r_df = request_data_by_uuid(uuid)
r_id = r_df.loc[0, 'r_id']
lat = r_df.loc[0, 'latitude']
lon = r_df.loc[0, 'longitude']
v_list['dist'] = get_haversine_distance(
float(lat), float(lon), v_list['latitude'].astype(float).values,
v_list['longitude'].astype(float).values)
v_list = v_list.sort_values(by='dist', ascending=True)
v_ids = pd.DataFrame()
df = pd.DataFrame()
df2 = pd.DataFrame()
count = 0
if (server_type == 'prod'):
key_word = 'COVIDSOS'
url_start = "https://covidsos.org/"
else:
key_word = 'TEST'
url_start = "https://stg.covidsos.org/"
for i in v_list.index:
if (v_list.loc[i, 'dist'] < radius):
orig_link = url_start + "accept/" + uuid
link = url_shortener_fn(orig_link)
sms_text = "[" + key_word + "]. Dear " + v_list.loc[
i,
'name'] + ", HELP NEEDED in your area. Click " + link + " to help."
sms_to = int(v_list.loc[i, 'mob_number'])
df = df.append(v_list.loc[i, ['v_id']])
print(link)
if ((server_type == 'prod')):
send_sms(sms_text, sms_to, sms_type='transactional', send=True)
print('SMS sent')
else:
print('Sending sms:', sms_text, ' to ', str(sms_to))
if ((v_list.loc[i, 'dist'] > radius) &
(v_list.loc[i, 'dist'] < search_radius)):
count = count + 1
if (count > 20):
break
orig_link = url_start + "accept/" + uuid
link = url_shortener_fn(orig_link)
print(link)
sms_text = "[" + key_word + "] HELP NEEDED in " + r_df.loc[
0, 'geoaddress'][
0:40] + ".. Click " + link + " to help or refer someone."
sms_to = int(v_list.loc[i, 'mob_number'])
df2 = df2.append(v_list.loc[i, ['v_id']])
if ((server_type == 'prod')):
send_sms(sms_text, sms_to, sms_type='transactional', send=True)
print('SMS sent')
else:
print('Sending sms:', sms_text, ' to ', str(sms_to))
df['r_id'] = r_id
df['status'] = 'pending'
print(v_list)
print(df)
print(df2)
if ((server_type == 'prod')):
engine = connections('prod_db_write')
df.to_sql(name='nearby_volunteers',
con=engine,
schema='covidsos',
if_exists='append',
index=False,
index_label=None)
mod_sms_text = key_word + " New request verified. Sent to " + str(
df.shape[0]) + " nearby Volunteers and " + str(
df2.shape[0]) + " volunteers further away"
mod_sms_text_2 = key_word + " Request #" + str(
r_df.loc[0, 'r_id']
) + " New Request Name: " + r_df.loc[0, 'name'] + " Address: " + r_df.loc[
0, 'geoaddress'][0:50] + " Mob: " + str(
r_df.loc[0, 'mob_number']) + " Req:" + r_df.loc[0, 'request']
str_broadcast = "For request #" + str(r_df.loc[0, 'r_id']) + " "
counter_broadcast = 0
for i in v_list.index:
counter_broadcast = counter_broadcast + 1
if ((counter_broadcast > 10)
or (v_list.loc[i, 'dist'] > search_radius)):
break
str_broadcast = str_broadcast + v_list.loc[
i, 'name'] + " m: wa.me/91" + str(v_list.loc[i,
'mob_number']) + " "
link = url_shortener_fn("https://wa.me/918618948661?text=" +
p.quote(str_broadcast))
mod_sms_text_3 = "Broadcast to volunteers using " + link
moderator_list = get_moderator_list()
for i_number in moderator_list:
if ((server_type == 'prod')):
send_sms(mod_sms_text,
sms_to=int(i_number),
sms_type='transactional',
send=True)
send_sms(mod_sms_text_2,
sms_to=int(i_number),
sms_type='transactional',
send=True)
send_sms(mod_sms_text_3,
sms_to=int(i_number),
sms_type='transactional',
send=True)
print('SMS sent')
else:
print('Sending sms:', mod_sms_text, ' to ', str(i_number))
print('Sending sms:', mod_sms_text_2, ' to ', str(i_number))
print('Sending sms:', mod_sms_text_3, ' to ', str(i_number))
return None