def retrieveScoreGardensUrls(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))
#day="Today"
#startdate="2013-12-06"
#enddate="2013-12-06"
#intermediary_id=self.sessionvar['username']
#self.b_id='KTLNTW001'
if day == "Today":
date_int = datetime.date.today()
date_str = "%s" % date_int
elif day == "Yesterday":
#Yesterday
date_int = datetime.date.today() - datetime.timedelta(days=1)
else:
result["message"] = "Error: The option '%s' is invalid" % day
return (json.JSONEncoder().encode(result))
date_str = "%s" % date_int
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 = []
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 = []
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"])
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"])
#image_path="/static/wellnessapp/images/garden/%s/%s_%s.jpeg"%(intermediaries_emails[posn],beneficiary_ids[posn],garden_label)
#file_path=os.path.dirname(os.path.abspath(__file__))
#if not os.path.isfile(image_path):
# file_path="wellnessapp/images/garden/%s/blank.jpeg"%intermediaries_emails[posn]
#else:
file_path = "wellnessapp/images/garden/%s/%s_%s.jpeg" % (
intermediaries_emails[posn], beneficiary_ids[posn],
garden_label)
file_path_alt = "wellnessapp/images/garden/blank.jpeg"
file_name = "%s_%s" % (beneficiary_ids[posn], garden_label)
urls.append(file_path)
myjson = {'FactorId': file_name}
obj = ManageFactors(myjson)
res = obj.retrieveFactorsFromDB()
res = json.loads(res)
trees = int(res["R00"]["TreeFactor"] * 100.0)
flowers = int(res["R00"]["FlowerFactor"] * 67.0)
tree_array.append(trees)
flower_array.append(flowers)
total = trees + flowers
total_plants.append(total)
posn = posn + 1
posn = 0
'''
for beneficiary in beneficiary_ids:
file_path="{{STATIC_URL}}wellnessapp/images/garden/%s/%s_%s"%(intermediaries_emails[posn],beneficiary_ids[posn],garden_label)
file_name="%s_%s"%(beneficiary_ids[posn],garden_label)
urls.append(file_path)
myjson={'FactorId':file_name}
obj=ManageFactors(myjson)
res=obj.retrieveFactorsFromDB()
res=json.loads(res)
trees=int(res["R00"]["TreeFactor"]*100.0)
flowers=int(res["R00"]["FlowerFactor"]*67.0)
tree_array.append(trees)
flower_array.append(flowers)
total=trees+flowers
total_plants.append(total)
posn=posn+1
'''
bubblesort(total_plants, urls, beneficiary_ids, tree_array,
flower_array, intermediary_names)
posn = 0
file_path_alt = "wellnessapp/images/garden/blank.jpeg"
for beneficiary in beneficiary_ids:
urls_tuple = {}
if first_posn < 10:
key1 = "R0"
else:
key1 = "R"
urls_tuple[key2 + "%s" % second_posn] = urls[posn]
second_posn = second_posn + 1
urls_tuple[key2 + "%s" % second_posn] = file_path_alt
second_posn = second_posn + 1
urls_tuple[key2 + "%s" % second_posn] = "%s" % tree_array[posn]
second_posn = second_posn + 1
urls_tuple[key2 + "%s" % second_posn] = "%s" % flower_array[posn]
second_posn = second_posn + 1
urls_tuple[key2 +
"%s" % second_posn] = "%s" % intermediary_names[posn]
second_posn = second_posn + 1
second_posn = 0
result[key1 + "%s" % first_posn] = urls_tuple
first_posn = first_posn + 1
posn = posn + 1
return (json.JSONEncoder().encode(
OrderedDict(sorted(result.items(), key=lambda t: t[0]))))
def retrieveScoreGardensUrls(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))
#day="Today"
#startdate="2013-12-06"
#enddate="2013-12-06"
#intermediary_id=self.sessionvar['username']
#self.b_id='KTLNTW001'
if day=="Today":
date_int=datetime.date.today()
date_str ="%s"%date_int
elif day=="Yesterday":
#Yesterday
date_int=datetime.date.today()-datetime.timedelta(days=1)
else:
result["message"]="Error: The option '%s' is invalid"%day
return (json.JSONEncoder().encode(result))
date_str ="%s"%date_int
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=[]
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=[]
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"])
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"])
#image_path="/static/wellnessapp/images/garden/%s/%s_%s.jpeg"%(intermediaries_emails[posn],beneficiary_ids[posn],garden_label)
#file_path=os.path.dirname(os.path.abspath(__file__))
#if not os.path.isfile(image_path):
# file_path="wellnessapp/images/garden/%s/blank.jpeg"%intermediaries_emails[posn]
#else:
file_path="wellnessapp/images/garden/%s/%s_%s.jpeg"%(intermediaries_emails[posn],beneficiary_ids[posn],garden_label)
file_path_alt="wellnessapp/images/garden/blank.jpeg"
file_name="%s_%s"%(beneficiary_ids[posn],garden_label)
urls.append(file_path)
myjson={'FactorId':file_name}
obj=ManageFactors(myjson)
res=obj.retrieveFactorsFromDB()
res=json.loads(res)
trees=int(res["R00"]["TreeFactor"]*100.0)
flowers=int(res["R00"]["FlowerFactor"]*67.0)
tree_array.append(trees)
flower_array.append(flowers)
total=trees+flowers
total_plants.append(total)
posn=posn+1
posn=0
'''
for beneficiary in beneficiary_ids:
file_path="{{STATIC_URL}}wellnessapp/images/garden/%s/%s_%s"%(intermediaries_emails[posn],beneficiary_ids[posn],garden_label)
file_name="%s_%s"%(beneficiary_ids[posn],garden_label)
urls.append(file_path)
myjson={'FactorId':file_name}
obj=ManageFactors(myjson)
res=obj.retrieveFactorsFromDB()
res=json.loads(res)
trees=int(res["R00"]["TreeFactor"]*100.0)
flowers=int(res["R00"]["FlowerFactor"]*67.0)
tree_array.append(trees)
flower_array.append(flowers)
total=trees+flowers
total_plants.append(total)
posn=posn+1
'''
bubblesort(total_plants,urls,beneficiary_ids,tree_array,flower_array,intermediary_names)
posn=0
file_path_alt="wellnessapp/images/garden/blank.jpeg"
for beneficiary in beneficiary_ids:
urls_tuple={}
if first_posn<10:
key1="R0"
else:
key1="R"
urls_tuple[key2+"%s"%second_posn]=urls[posn]
second_posn=second_posn+1
urls_tuple[key2+"%s"%second_posn]=file_path_alt
second_posn=second_posn+1
urls_tuple[key2+"%s"%second_posn]="%s"%tree_array[posn]
second_posn=second_posn+1
urls_tuple[key2+"%s"%second_posn]="%s"%flower_array[posn]
second_posn=second_posn+1
urls_tuple[key2+"%s"%second_posn]="%s"%intermediary_names[posn]
second_posn=second_posn+1
second_posn=0
result[key1+"%s"%first_posn]=urls_tuple
first_posn=first_posn+1
posn=posn+1
return (json.JSONEncoder().encode(OrderedDict(sorted(result.items(), key=lambda t: t[0]))))
