def assignBadges(self):
result={}
try:
day=self.myjson["Day"]
except Exception as e:
#print "Content-type: text/html\n"
result["message"]="Error%s"%e.message
return (json.JSONEncoder().encode(result))
if day is not None:
#if day=="Today":
# today_date=datetime.date.today()
# date_str="%s"%today_date
#else:
date_str="%s"%day
else:
result["message"]="Error: The option '%s' is invalid"%day
return (json.JSONEncoder().encode(result))
try:
myjson={'Fname':'Dummy','Lname':'Dummy','Username':'******'}
obj=RetrieveIntermediary(myjson)
res=obj.retrieveIntermediaryInDB()
intermediaries_tuple=json.loads(res)
intermediaries_emails=[]
intermediary_names=[]
orig_emails=[]
beneficiary_ids=[]
beneficiary_names=[]
intermediary_mobiles=[]
beneficiary_relations=[]
posn=0
gardens=[]
competitors_counter=0
garden_label=date_str.replace("-","_")
first_posn=0
second_posn=0
key2="D"
tree_array=[]
flower_array=[]
total_plants=[]
urls=[]
usage_points=[]
bonus_points=[]
badges=[]
badges_urls=[]
for record in intermediaries_tuple.items():
key,user =record
if(user["D2"]=="None"):
continue
else:
orig_emails.append(user["D1"]) #keep original email addresses
orig_email=user["D1"]
user["D1"]=user["D1"].replace("@","_at_")
user["D1"]=user["D1"].replace(".","_dot_")
intermediaries_emails.append(user["D1"])
intermediary_names.append(user["D0"])
beneficiary_names.append(user["D2"][0:user["D2"].index('.')])# get the name only
beneficiary_relations.append(user["D3"][(user["D3"].index(':')+1):(len(user["D3"]))])
intermediary_mobiles.append(user["D5"][(user["D5"].index(':')+1):(len(user["D5"]))])
myjson={'Fname':'Dummy','Lname':'Dummy','Username':orig_email}
obj=RetrieveIntermediary(myjson)
result2=obj.isAssignedBeneficiary()
beneficiary_tuple=json.loads(result2)
beneficiary_ids.append(beneficiary_tuple["Id"])
file_path="django_facebook/images/garden/%s/%s_%s.jpeg"%(intermediaries_emails[posn],beneficiary_ids[posn],garden_label)
file_name="%s_%s"%(beneficiary_ids[posn],garden_label)
urls.append(file_path)
varmyjson={'Day':day}
clickPointsObj=RetrievePoints(varmyjson,orig_email,1)
resclickpoints=clickPointsObj.retrieveIntermediaryClickPoints()
resclickpoints=json.loads(resclickpoints)
#clickpoints=int(resclickpoints["points"]/resclickpoints["dates_counter"])
clickpoints=int(resclickpoints["points"])
if clickpoints>18:
clickpoints=18
usage_points.append(clickpoints)
ressteps=clickPointsObj.getSteps(beneficiary_tuple["Id"])
ressteps=json.loads(ressteps)
#stepspoints=int(ressteps["steps"]/(100*ressteps["dates_counter"]))
stepspoints=int(ressteps["steps"])
if stepspoints>70000:
stepspoints=70000
bonus_points.append(stepspoints)
#trees=int(stepspoints*100/70000)
#flowers=int(clickpoints*67/18)
#print file_name,trees, flowers
#tree_array.append(trees)
#flower_array.append(flowers)
#total=trees+flowers
#total_plants.append(total)
#Get the current badge of this individual
engine=db
# create a Session
Session = sessionmaker(bind=engine)
session = Session()
#get the current badge
res=session.query(AttainedUserBadges).filter(AttainedUserBadges.intermediary_id==orig_email).filter(AttainedUserBadges.status==1).first()
if res is None:
#this user is not assigned a bagde
currentbadge=0 #start with slave badge
else:
currentbadge=res.badge_id
old_badge=currentbadge
if stepspoints>=10000 and currentbadge==2:
if clickpoints>=18:
badges.append("Queen/King")
badges_urls.append("http://ict4d01.cs.uct.ac.za/static/django_facebook/images/badges/queen.jpeg")
else:
badges.append("No promotion")
elif stepspoints>=9000 and currentbadge==3:
if clickpoints>=16:
badges.append("Princess/Prince")
badges_urls.append("http://ict4d01.cs.uct.ac.za/static/django_facebook/images/badges/princess.jpeg")
else:
badges.append("No promotion")
badges_urls.append("http://ict4d01.cs.uct.ac.za/static/django_facebook/images/badges/duchess.jpeg")
elif stepspoints>=8000 and currentbadge==4:
if clickpoints>=14:
badges.append("Duchess/Duke")
badges_urls.append("http://ict4d01.cs.uct.ac.za/static/django_facebook/images/badges/duchess.jpeg")
else:
badges.append("No promotion")
badges_urls.append("http://ict4d01.cs.uct.ac.za/static/django_facebook/images/badges/grandmaster.jpeg")
elif stepspoints>=7000 and currentbadge==5:
if clickpoints>=12:
badges.append("Grand Master")
badges_urls.append("http://ict4d01.cs.uct.ac.za/static/django_facebook/images/badges/grandmaster.jpeg")
else:
badges.append("No promotion")
badges_urls.append("http://ict4d01.cs.uct.ac.za/static/django_facebook/images/badges/seniormaster.jpeg")
elif stepspoints>=6000 and currentbadge==6:
if clickpoints>=10:
badges.append("Senior Master")
badges_urls.append("http://ict4d01.cs.uct.ac.za/static/django_facebook/images/badges/seniormaster.jpeg")
else:
badges.append("No promotion")
badges_urls.append("http://ict4d01.cs.uct.ac.za/static/django_facebook/images/badges/master.jpeg")
elif stepspoints>=5000 and currentbadge==7:
if clickpoints>=8:
badges.append("Master")
badges_urls.append("http://ict4d01.cs.uct.ac.za/static/django_facebook/images/badges/master.jpeg")
else:
badges.append("No promotion")
badges_urls.append("http://ict4d01.cs.uct.ac.za/static/django_facebook/images/badges/juniormaster.jpeg")
if stepspoints>=4000 and currentbadge==8:
if clickpoints>=4:
badges.append("Junior Master")
badges_urls.append("http://ict4d01.cs.uct.ac.za/static/django_facebook/images/badges/juniormaster.jpeg")
else:
badges.append("No promotion")
badges_urls.append("http://ict4d01.cs.uct.ac.za/static/django_facebook/images/badges/seniorservant.jpeg")
elif stepspoints>=3000 and currentbadge==9:
if clickpoints>=2:
badges.append("Senior Servant")
badges_urls.append("http://ict4d01.cs.uct.ac.za/static/django_facebook/images/badges/seniorservant.jpeg")
else:
badges.append("No Promotion")
badges_urls.append("http://ict4d01.cs.uct.ac.za/static/django_facebook/images/badges/servant.jpeg")
elif stepspoints>=2500 and currentbadge==10:
if clickpoints>=1:
badges.append("Servant")
badges_urls.append("http://ict4d01.cs.uct.ac.za/static/django_facebook/images/badges/servant.jpeg")
else:
badges.append("No promotion")
badges_urls.append("http://ict4d01.cs.uct.ac.za/static/django_facebook/images/badges/slave.jpeg")
else:
badges.append("Slave")
badges_urls.append("http://ict4d01.cs.uct.ac.za/static/django_facebook/images/badges/slave.jpeg")
try:
#get the rank of the badge
if badges[posn] == "No promotion":
print "No Promotion"
else:
#engine=create_engine('mysql://*****:*****@localhost/wellness', echo=False)
engine=db
# create a Session
Session = sessionmaker(bind=engine)
session = Session()
res=session.query(Badges).filter(Badges.badgename==badges[posn]).first()
if res ==None:
rank=0
else:
rank=res.rank #new acquired rank
first_name=intermediary_names[posn][0:(intermediary_names[posn].index(' ')+1)] #
#new_attained_badge
#first get the current badge of this
res=session.query(AttainedUserBadges).filter(AttainedUserBadges.intermediary_id==orig_email).filter(AttainedUserBadges.status==1).first()
if res is None:
#first promotion
#insert a new badge into the database
new_attained_badge=AttainedUserBadges(orig_email,datetime.date.today(),rank)
session.add(new_attained_badge)
session.commit()# Commit this transaction
#first_name=intermediary_names[posn][0:(intermediary_names[posn].index(' ')+1)] #
print "First Promotion"
feedback_message="Hey %s "%first_name
feedback_message=feedback_message+"your team's first badge is %s . You and your %s need to work harder to progress to higher badges. You can only obtain higher badges if you keep on using the app everyday and motivate your %s to walk more steps everyday."%(badges[posn],beneficiary_relations[posn],beneficiary_relations[posn])
myjson2={"recipient":intermediary_mobiles[posn],"message":feedback_message}
obj=QueueFeedback(myjson2)
res=obj.saveFeedbackInDB()
else:
#check if the current badge rank is less than the new badge rank
if rank<res.badge_id:
#promote to new higher badge
res.status=0# make the current badge obsolete
session.commit()
session = Session()#create a new session
#insert a new badge into the database
new_attained_badge=AttainedUserBadges(orig_email,datetime.date.today(),rank)
session.add(new_attained_badge)
session.commit()# Commit this transaction
print "Promoted to new rank"
feedback_message="Hey %s "%first_name
feedback_message=feedback_message+"your team has been promoted to a new badge. Your old badge was %s and now your new badge is %s. Keep on using your app every day and keep on motivating your %s to walk more steps so that your team can continue to shine."%(old_badge,badges[posn],beneficiary_relations[posn])
myjson2={"recipient":intermediary_mobiles[posn],"message":feedback_message}
obj=QueueFeedback(myjson2)
res=obj.saveFeedbackInDB()
#else:
# print "No new promotion"
# #pass# no new promotion
except Exception as e:
print "Exception thrown: %s"%e
return -1
posn=posn+1
except Exception as e:
print "Exception thrown %s "%e
return -1
return 1
def assignBadges(self):
result = {}
try:
day = self.myjson["Day"]
except Exception as e:
#print "Content-type: text/html\n"
result["message"] = "Error%s" % e.message
return (json.JSONEncoder().encode(result))
if day is not None:
#if day=="Today":
# today_date=datetime.date.today()
# date_str="%s"%today_date
#else:
date_str = "%s" % day
else:
result["message"] = "Error: The option '%s' is invalid" % day
return (json.JSONEncoder().encode(result))
try:
myjson = {'Fname': 'Dummy', 'Lname': 'Dummy', 'Username': '******'}
obj = RetrieveIntermediary(myjson)
res = obj.retrieveIntermediaryInDB()
intermediaries_tuple = json.loads(res)
intermediaries_emails = []
intermediary_names = []
orig_emails = []
beneficiary_ids = []
beneficiary_names = []
intermediary_mobiles = []
beneficiary_relations = []
posn = 0
gardens = []
competitors_counter = 0
garden_label = date_str.replace("-", "_")
first_posn = 0
second_posn = 0
key2 = "D"
tree_array = []
flower_array = []
total_plants = []
urls = []
usage_points = []
bonus_points = []
badges = []
badges_urls = []
for record in intermediaries_tuple.items():
key, user = record
if (user["D2"] == "None"):
continue
else:
orig_emails.append(
user["D1"]) #keep original email addresses
orig_email = user["D1"]
user["D1"] = user["D1"].replace("@", "_at_")
user["D1"] = user["D1"].replace(".", "_dot_")
intermediaries_emails.append(user["D1"])
intermediary_names.append(user["D0"])
beneficiary_names.append(
user["D2"]
[0:user["D2"].index('.')]) # get the name only
beneficiary_relations.append(
user["D3"][(user["D3"].index(':') +
1):(len(user["D3"]))])
intermediary_mobiles.append(
user["D5"][(user["D5"].index(':') +
1):(len(user["D5"]))])
myjson = {
'Fname': 'Dummy',
'Lname': 'Dummy',
'Username': orig_email
}
obj = RetrieveIntermediary(myjson)
result2 = obj.isAssignedBeneficiary()
beneficiary_tuple = json.loads(result2)
beneficiary_ids.append(beneficiary_tuple["Id"])
file_path = "django_facebook/images/garden/%s/%s_%s.jpeg" % (
intermediaries_emails[posn], beneficiary_ids[posn],
garden_label)
file_name = "%s_%s" % (beneficiary_ids[posn], garden_label)
urls.append(file_path)
varmyjson = {'Day': day}
clickPointsObj = RetrievePoints(varmyjson, orig_email, 1)
resclickpoints = clickPointsObj.retrieveIntermediaryClickPoints(
)
resclickpoints = json.loads(resclickpoints)
#clickpoints=int(resclickpoints["points"]/resclickpoints["dates_counter"])
clickpoints = int(resclickpoints["points"])
if clickpoints > 18:
clickpoints = 18
usage_points.append(clickpoints)
ressteps = clickPointsObj.getSteps(beneficiary_tuple["Id"])
ressteps = json.loads(ressteps)
#stepspoints=int(ressteps["steps"]/(100*ressteps["dates_counter"]))
stepspoints = int(ressteps["steps"])
if stepspoints > 70000:
stepspoints = 70000
bonus_points.append(stepspoints)
#trees=int(stepspoints*100/70000)
#flowers=int(clickpoints*67/18)
#print file_name,trees, flowers
#tree_array.append(trees)
#flower_array.append(flowers)
#total=trees+flowers
#total_plants.append(total)
#Get the current badge of this individual
engine = db
# create a Session
Session = sessionmaker(bind=engine)
session = Session()
#get the current badge
res = session.query(AttainedUserBadges).filter(
AttainedUserBadges.intermediary_id == orig_email
).filter(AttainedUserBadges.status == 1).first()
if res is None:
#this user is not assigned a bagde
currentbadge = 0 #start with slave badge
else:
currentbadge = res.badge_id
old_badge = currentbadge
if stepspoints >= 10000 and currentbadge == 2:
if clickpoints >= 18:
badges.append("Queen/King")
badges_urls.append(
"http://ict4d01.cs.uct.ac.za/static/django_facebook/images/badges/queen.jpeg"
)
else:
badges.append("No promotion")
elif stepspoints >= 9000 and currentbadge == 3:
if clickpoints >= 16:
badges.append("Princess/Prince")
badges_urls.append(
"http://ict4d01.cs.uct.ac.za/static/django_facebook/images/badges/princess.jpeg"
)
else:
badges.append("No promotion")
badges_urls.append(
"http://ict4d01.cs.uct.ac.za/static/django_facebook/images/badges/duchess.jpeg"
)
elif stepspoints >= 8000 and currentbadge == 4:
if clickpoints >= 14:
badges.append("Duchess/Duke")
badges_urls.append(
"http://ict4d01.cs.uct.ac.za/static/django_facebook/images/badges/duchess.jpeg"
)
else:
badges.append("No promotion")
badges_urls.append(
"http://ict4d01.cs.uct.ac.za/static/django_facebook/images/badges/grandmaster.jpeg"
)
elif stepspoints >= 7000 and currentbadge == 5:
if clickpoints >= 12:
badges.append("Grand Master")
badges_urls.append(
"http://ict4d01.cs.uct.ac.za/static/django_facebook/images/badges/grandmaster.jpeg"
)
else:
badges.append("No promotion")
badges_urls.append(
"http://ict4d01.cs.uct.ac.za/static/django_facebook/images/badges/seniormaster.jpeg"
)
elif stepspoints >= 6000 and currentbadge == 6:
if clickpoints >= 10:
badges.append("Senior Master")
badges_urls.append(
"http://ict4d01.cs.uct.ac.za/static/django_facebook/images/badges/seniormaster.jpeg"
)
else:
badges.append("No promotion")
badges_urls.append(
"http://ict4d01.cs.uct.ac.za/static/django_facebook/images/badges/master.jpeg"
)
elif stepspoints >= 5000 and currentbadge == 7:
if clickpoints >= 8:
badges.append("Master")
badges_urls.append(
"http://ict4d01.cs.uct.ac.za/static/django_facebook/images/badges/master.jpeg"
)
else:
badges.append("No promotion")
badges_urls.append(
"http://ict4d01.cs.uct.ac.za/static/django_facebook/images/badges/juniormaster.jpeg"
)
if stepspoints >= 4000 and currentbadge == 8:
if clickpoints >= 4:
badges.append("Junior Master")
badges_urls.append(
"http://ict4d01.cs.uct.ac.za/static/django_facebook/images/badges/juniormaster.jpeg"
)
else:
badges.append("No promotion")
badges_urls.append(
"http://ict4d01.cs.uct.ac.za/static/django_facebook/images/badges/seniorservant.jpeg"
)
elif stepspoints >= 3000 and currentbadge == 9:
if clickpoints >= 2:
badges.append("Senior Servant")
badges_urls.append(
"http://ict4d01.cs.uct.ac.za/static/django_facebook/images/badges/seniorservant.jpeg"
)
else:
badges.append("No Promotion")
badges_urls.append(
"http://ict4d01.cs.uct.ac.za/static/django_facebook/images/badges/servant.jpeg"
)
elif stepspoints >= 2500 and currentbadge == 10:
if clickpoints >= 1:
badges.append("Servant")
badges_urls.append(
"http://ict4d01.cs.uct.ac.za/static/django_facebook/images/badges/servant.jpeg"
)
else:
badges.append("No promotion")
badges_urls.append(
"http://ict4d01.cs.uct.ac.za/static/django_facebook/images/badges/slave.jpeg"
)
else:
badges.append("Slave")
badges_urls.append(
"http://ict4d01.cs.uct.ac.za/static/django_facebook/images/badges/slave.jpeg"
)
try:
#get the rank of the badge
if badges[posn] == "No promotion":
print "No Promotion"
else:
#engine=create_engine('mysql://*****:*****@localhost/wellness', echo=False)
engine = db
# create a Session
Session = sessionmaker(bind=engine)
session = Session()
res = session.query(Badges).filter(
Badges.badgename == badges[posn]).first()
if res == None:
rank = 0
else:
rank = res.rank #new acquired rank
first_name = intermediary_names[posn][0:(
intermediary_names[posn].index(' ') + 1)] #
#new_attained_badge
#first get the current badge of this
res = session.query(AttainedUserBadges).filter(
AttainedUserBadges.intermediary_id ==
orig_email).filter(
AttainedUserBadges.status == 1).first()
if res is None:
#first promotion
#insert a new badge into the database
new_attained_badge = AttainedUserBadges(
orig_email, datetime.date.today(), rank)
session.add(new_attained_badge)
session.commit() # Commit this transaction
#first_name=intermediary_names[posn][0:(intermediary_names[posn].index(' ')+1)] #
print "First Promotion"
feedback_message = "Hey %s " % first_name
feedback_message = feedback_message + "your team's first badge is %s . You and your %s need to work harder to progress to higher badges. You can only obtain higher badges if you keep on using the app everyday and motivate your %s to walk more steps everyday." % (
badges[posn], beneficiary_relations[posn],
beneficiary_relations[posn])
myjson2 = {
"recipient": intermediary_mobiles[posn],
"message": feedback_message
}
obj = QueueFeedback(myjson2)
res = obj.saveFeedbackInDB()
else:
#check if the current badge rank is less than the new badge rank
if rank < res.badge_id:
#promote to new higher badge
res.status = 0 # make the current badge obsolete
session.commit()
session = Session() #create a new session
#insert a new badge into the database
new_attained_badge = AttainedUserBadges(
orig_email, datetime.date.today(),
rank)
session.add(new_attained_badge)
session.commit() # Commit this transaction
print "Promoted to new rank"
feedback_message = "Hey %s " % first_name
feedback_message = feedback_message + "your team has been promoted to a new badge. Your old badge was %s and now your new badge is %s. Keep on using your app every day and keep on motivating your %s to walk more steps so that your team can continue to shine." % (
old_badge, badges[posn],
beneficiary_relations[posn])
myjson2 = {
"recipient":
intermediary_mobiles[posn],
"message": feedback_message
}
obj = QueueFeedback(myjson2)
res = obj.saveFeedbackInDB()
#else:
# print "No new promotion"
# #pass# no new promotion
except Exception as e:
print "Exception thrown: %s" % e
return -1
posn = posn + 1
except Exception as e:
print "Exception thrown %s " % e
return -1
return 1
def assignBadges(self):
result = {}
try:
day = self.myjson["Day"]
except Exception as e:
#print "Content-type: text/html\n"
result["message"] = "Error%s" % e.message
return (json.JSONEncoder().encode(result))
if day is not None:
#if day=="Today":
# today_date=datetime.date.today()
# date_str="%s"%today_date
#else:
date_str = "%s" % day
else:
result["message"] = "Error: The option '%s' is invalid" % day
return (json.JSONEncoder().encode(result))
try:
myjson = {'Fname': 'Dummy', 'Lname': 'Dummy', 'Username': '******'}
obj = RetrieveIntermediary(myjson)
res = obj.retrieveIntermediaryInDB()
intermediaries_tuple = json.loads(res)
intermediaries_emails = []
intermediary_names = []
orig_emails = []
beneficiary_ids = []
beneficiary_names = []
intermediary_mobiles = []
beneficiary_relations = []
posn = 0
gardens = []
competitors_counter = 0
garden_label = date_str.replace("-", "_")
first_posn = 0
second_posn = 0
key2 = "D"
tree_array = []
flower_array = []
total_plants = []
urls = []
usage_points = []
bonus_points = []
badges = []
badges_urls = []
currentdate = datetime.datetime.today()
#get the date for the first day of this week
day_of_week = currentdate.weekday()
week_start_date = currentdate - datetime.timedelta(
days=day_of_week)
#get the first and end date of last week
previous_week_end_date = week_start_date - datetime.timedelta(
days=1) #go to last sunday
previous_week_start_date = previous_week_end_date - datetime.timedelta(
days=6) #go to last monday
#engine=create_engine('mysql://*****:*****@localhost/wellness', echo=False)
engine = db
# create a Session
Session = sessionmaker(bind=engine)
session = Session()
res2 = session.query(
AttainedUserBadges, Badges, Intermediary).filter(
Intermediary.intermediary_id ==
AttainedUserBadges.intermediary_id).filter(
AttainedUserBadges.status == 1).filter(
AttainedUserBadges.badge_id == Badges.rank).filter(
AttainedUserBadges.date_attained >=
previous_week_start_date).filter(
AttainedUserBadges.date_attained <=
previous_week_end_date).all()
users_with_progress_str = "|"
users_with_progress = 0
for rel1, rel2, rel3 in res2:
users_with_progress_str = users_with_progress_str + rel3.intermediary_fname
users_with_progress_str = users_with_progress_str + " "
#users_with_progress_str=users_with_progress_str+rel3.intermediary_lname
users_with_progress_str = users_with_progress_str + ", Badge:"
users_with_progress_str = users_with_progress_str + rel2.badgename
users_with_progress_str = users_with_progress_str + "|"
users_with_progress = users_with_progress + 1
for record in intermediaries_tuple.items():
key, user = record
if (user["D2"] == "None"):
continue
else:
orig_emails.append(
user["D1"]) #keep original email addresses
orig_email = user["D1"]
user["D1"] = user["D1"].replace("@", "_at_")
user["D1"] = user["D1"].replace(".", "_dot_")
intermediaries_emails.append(user["D1"])
intermediary_names.append(user["D0"])
beneficiary_names.append(
user["D2"]
[0:user["D2"].index('.')]) # get the name only
beneficiary_relations.append(
user["D3"][(user["D3"].index(':') +
1):(len(user["D3"]))])
intermediary_mobiles.append(
user["D5"][(user["D5"].index(':') +
1):(len(user["D5"]))])
first_name = intermediary_names[posn][0:(
intermediary_names[posn].index(' ') + 1)] #
myjson = {
'Fname': 'Dummy',
'Lname': 'Dummy',
'Username': orig_email
}
obj = RetrieveIntermediary(myjson)
result2 = obj.isAssignedBeneficiary()
beneficiary_tuple = json.loads(result2)
beneficiary_ids.append(beneficiary_tuple["Id"])
file_path = "django_facebook/images/garden/%s/%s_%s.jpeg" % (
intermediaries_emails[posn], beneficiary_ids[posn],
garden_label)
file_name = "%s_%s" % (beneficiary_ids[posn], garden_label)
urls.append(file_path)
varmyjson = {'Day': day}
clickPointsObj = RetrievePoints(varmyjson, orig_email, 1)
resclickpoints = clickPointsObj.retrieveIntermediaryClickPoints(
)
resclickpoints = json.loads(resclickpoints)
#clickpoints=int(resclickpoints["points"]/resclickpoints["dates_counter"])
clickpoints = int(resclickpoints["points"])
if clickpoints > 18:
clickpoints = 18
usage_points.append(clickpoints)
ressteps = clickPointsObj.getSteps(beneficiary_tuple["Id"])
ressteps = json.loads(ressteps)
#stepspoints=int(ressteps["steps"]/(100*ressteps["dates_counter"]))
stepspoints = int(ressteps["steps"])
if stepspoints > 70000:
stepspoints = 70000
bonus_points.append(stepspoints)
trees = int(stepspoints * 100 / 70000)
flowers = int(clickpoints * 67 / 18)
#print file_name,trees, flowers
tree_array.append(trees)
flower_array.append(flowers)
total = trees + flowers
total_plants.append(total)
#engine=create_engine('mysql://*****:*****@localhost/wellness', echo=False)
#engine=db
# create a Session
#Session = sessionmaker(bind=engine)
#session = Session()
#check if there a new badge attained in last week
res2 = session.query(AttainedUserBadges, Badges).filter(
AttainedUserBadges.intermediary_id == orig_email
).filter(AttainedUserBadges.status == 1).filter(
AttainedUserBadges.badge_id == Badges.rank).filter(
AttainedUserBadges.date_attained >=
previous_week_start_date).filter(
AttainedUserBadges.date_attained <=
previous_week_end_date).first()
if res2 is None:
# select one message out of five messages
num = randint(0, 4)
message_bank = []
if users_with_progress > 0:
if users_with_progress > 1:
feedback_message = "Hi %s, " % first_name
feedback_message = feedback_message + "these are the people who got new badges last week, %s. If you and your %s work harder this week then you can also attain a new higher badge. To progrees on a new badge you need to login to the app every day and motivate your %s to walk more steps in each day" % (
users_with_progress_str,
beneficiary_relations[posn],
beneficiary_relations[posn])
else:
feedback_message = "Hi %s, " % first_name
feedback_message = feedback_message + "this is the only person who got a new badge last week, %s. If you and your %s work harder this week then you can also attain a new higher badge. To progrees on a new badge you need to login to the app every day and motivate your %s to walk more steps in each day" % (
users_with_progress_str,
beneficiary_relations[posn],
beneficiary_relations[posn])
message_bank.append(feedback_message)
# select one message out of six messages NB: There one additional message from this if statement
num = randint(0, 5)
feedback_message = "Hey %s " % first_name
feedback_message = feedback_message + "your team has not been promoted to a new badge for the past seven days. You and your %s need to work harder to progress to higher badges. You can only obtain higher badges if you keep on using the app everyday and motivate your %s to walk more steps everyday." % (
beneficiary_relations[posn],
beneficiary_relations[posn])
message_bank.append(feedback_message)
feedback_message = "Hallo %s " % first_name
feedback_message = feedback_message + "your team has not progressed to a higher badge for a while. This week you have another chance to progress. You and your %s need to work harder to progress to higher badges. You can only obtain higher badges if you keep on using the app everyday and motivate your %s to walk more steps everyday." % (
beneficiary_relations[posn],
beneficiary_relations[posn])
message_bank.append(feedback_message)
feedback_message = "Molo %s " % first_name
feedback_message = feedback_message + " Your team never got any new badge for the all of last week. You and your %s can attain new higher badges if you keep on using the app everyday and motivate your %s to walk more steps everyday. Log on the app now to check your current badge" % (
beneficiary_relations[posn],
beneficiary_relations[posn])
message_bank.append(feedback_message)
feedback_message = "Kunjani %s ? " % first_name
feedback_message = feedback_message + " It is monday again. Last week your badge never changed. It is time your team get a new badge. Keep on using the app every day and motivate your %s to walk more steps this week so that your team gets higher badges. Log on the app now to check your progress" % beneficiary_relations[
posn]
message_bank.append(feedback_message)
feedback_message = "Heita %s ? " % first_name
feedback_message = feedback_message + " Here is another monday, the week begins. You have been on the same badge for too long. It is time for a change. Keep on using the app every day and motivate your %s to walk more steps this week so that your team gets higher badges. Log on the app now to check your progress" % beneficiary_relations[
posn]
message_bank.append(feedback_message)
print message_bank[num]
myjson2 = {
"recipient": intermediary_mobiles[posn],
"message": message_bank[num]
}
obj = QueueFeedback(myjson2)
res = obj.saveFeedbackInDB()
else:
# select one message out of four messages
num = randint(0, 3)
message_bank = []
if users_with_progress > 0:
if users_with_progress > 1:
feedback_message = "Hi %s. " % first_name
feedback_message = feedback_message + "you are among the people who scored new badges last week.%s. Here is a another week and you have a chance to progress more.You can only obtain higher badges if you keep on using the app everyday and motivate your %s to walk more steps everyday. Login on the app to check steps walked by %s and increase your chance to score higher badges." % (
users_with_progress_str,
beneficiary_relations[posn],
beneficiary_relations[posn])
else:
feedback_message = "Hi %s," % first_name
feedback_message = feedback_message + "you are the only person to attain a new in the past seven days. Big up for that. Here is a another week and you have a chance to progress more.You can only obtain higher badges if you keep on using the app everyday and motivate your %s to walk more steps everyday. Log on the app now to check your current badge " % beneficiary_relations[
posn]
# select one message out of four messages
num = randint(0, 4)
feedback_message = "Holaa %s, " % first_name
feedback_message = feedback_message + " congratulations for achieving a new badge last week. Here is another week. You and your %s have chance to work together to progress to higher badges. You can only obtain higher badges if you keep on using the app everyday and motivate your %s to walk more steps everyday. Log on the app now to check your current badge" % (
beneficiary_relations[posn],
beneficiary_relations[posn])
message_bank.append(feedback_message)
feedback_message = "Molo %s, " % first_name
feedback_message = feedback_message + " big up for getting a new badge last week. It is the begining of a new week. You and your %s can attain higher badges if you keep on using the app everyday and motivate your %s to walk more steps everyday. Log on the app now to check your current badge" % (
beneficiary_relations[posn],
beneficiary_relations[posn])
message_bank.append(feedback_message)
feedback_message = "Kunjani %s ? " % first_name
feedback_message = feedback_message + "Kudos for achieving a new badge in the last week. It is another monday again. Keep on using the app every day and motivate your %s to walk more steps this week so that your team gets higher badges. Log on the app now to check your progress" % (
beneficiary_relations[posn])
message_bank.append(feedback_message)
feedback_message = "Heita %s ? " % first_name
feedback_message = feedback_message + "last week you nailed it by geting a new badge. Here is another monday, the week begins. Keep on using the app every day and motivate your %s to walk more steps this week so that your team gets higher badges. Log on the app now to check your progress" % (
beneficiary_relations[posn])
message_bank.append(feedback_message)
myjson2 = {
"recipient": intermediary_mobiles[posn],
"message": message_bank[num]
}
obj = QueueFeedback(myjson2)
res = obj.saveFeedbackInDB()
'''
try:
old_badge=""
#engine=create_engine('mysql://*****:*****@localhost/wellness', echo=False)
engine=db
# create a Session
Session = sessionmaker(bind=engine)
session = Session()
res=session.query(Badges).filter(Badges.badgename==badges[posn]).first()
if res ==None:
rank=0
else:
old_badge=res.badgename
rank=res.rank
first_name=intermediary_names[posn][0:(intermediary_names[posn].index(' ')+1)] #
#new_attained_badge
#first get the current badge of this
res=session.query(AttainedUserBadges).filter(AttainedUserBadges.intermediary_id==orig_email).filter(AttainedUserBadges.status==1).first()
if res is None:
#first promotion
#insert a new badge into the database
new_attained_badge=AttainedUserBadges(orig_email,datetime.date.today(),rank)
session.add(new_attained_badge)
session.commit()# Commit this transaction
#first_name=intermediary_names[posn][0:(intermediary_names[posn].index(' ')+1)] #
print "First Promotion"
feedback_message="Hey %s "%first_name
feedback_message=feedback_message+"your team's first badge is %s . You and your %s need to work harder to progress to higher badges. You can only obtain higher badges if you keep on using the app everyday and motivate your %s to walk more steps everyday."%(badges[posn],beneficiary_relations[posn],beneficiary_relations[posn])
myjson2={"recipient":intermediary_mobiles[posn],"message":feedback_message}
obj=QueueFeedback(myjson2)
res=obj.saveFeedbackInDB()
else:
#check if the current badge rank is less than the new badge rank
if rank<res.badge_id:
#promote to new higher badge
res.status=0# make the current badge obsolete
session.commit()
session = Session()#create a new session
#insert a new badge into the database
new_attained_badge=AttainedUserBadges(orig_email,datetime.date.today(),rank)
session.add(new_attained_badge)
session.commit()# Commit this transaction
print "Promoted to new rank"
feedback_message="Hey %s "%first_name
feedback_message=feedback_message+"your team has been promoted to a new badge. Your old badge was %s and now your new badge is %. Keep on using your app every day and keep on motivating your %s to walk more steps so that your team can continue to shine."%(old_badge,badges[posn],beneficiary_relations[posn])
myjson2={"recipient":intermediary_mobiles[posn],"message":feedback_message}
obj=QueueFeedback(myjson2)
res=obj.saveFeedbackInDB()
print feedback_message
else:
print "No new promotion"
pass# no new promotion
except Exception as e:
print "Exception thrown: %s"%e
return -1
'''
posn = posn + 1
except Exception as e:
print "Exception thrown %s " % e
return -1
return 1
