def country_activities(country_code):
p = abprojects.projects(country_code)
country = abprojects.country(country_code)
reporting_orgs = abprojects.reporting_org_activities(country_code)
return render_template("country_activities.html",
projects=p,
country=country,
reporting_orgs=reporting_orgs,
)
def country_settings(country_code, lang="en"):
if request.method == "GET":
country = abprojects.country(country_code)
reporting_orgs = absettings.reporting_orgs()
page_args = request.view_args
page_args.pop("lang")
return render_template(
"country_settings.html",
country=country,
reporting_orgs=reporting_orgs,
lang=lang,
page_endpoint=request.endpoint,
page_args=page_args,
)
elif request.method == "POST":
if "settings" in request.form:
country = abprojects.country(country_code)
country.fiscalyear_modifier = request.form["fiscalyear_modifier"]
db.session.commit()
flash("Updated fiscal year start", "success")
elif "fetch_reporting_org" in request.form:
country = abprojects.country(country_code)
download.download_data(request.form["reporting_org_ref"],
country.code)
flash(
"Retrieved data for {}".format(
request.form["reporting_org_ref"]), "success")
elif "fetch_all_reporting_orgs" in request.form:
orgs = absettings.reporting_orgs()
print ""
print "Download and import data"
for org in orgs:
if org.active == True:
print ""
print """Downloading IATI XML for reporting organisation {}""".format(
org.text_EN)
download.download_data(org.code)
flash("Retrieved data for {}".format(org.text_EN),
"success")
return redirect(
url_for("country_settings", country_code=country_code, lang=lang))
def country_home(country_code):
stats = abstats.country_project_stats(country_code)
functional_stats = abstats.budget_project_stats(country_code, "f")
admin_stats = abstats.budget_project_stats(country_code, "a")
country = abprojects.country(country_code)
reporting_orgs = abprojects.reporting_org_activities(country_code)
return render_template("country.html",
country=country,
reporting_orgs=reporting_orgs,
stats=stats,
functional_stats=functional_stats,
admin_stats=admin_stats,
)
def activities(country_code, iati_identifier, lang="en"):
abmapper.set_lang(lang)
a = abprojects.project(iati_identifier)
country = abprojects.country(country_code)
page_args = request.view_args
page_args.pop("lang")
return render_template(
"project.html",
activity=a,
country=country,
freeze=('FREEZE' in app.config),
lang=lang,
page_endpoint=request.endpoint,
page_args=page_args,
)
def country_activities(country_code, lang="en"):
abmapper.set_lang(lang)
p = abprojects.projects(country_code)
country = abprojects.country(country_code)
reporting_orgs = abprojects.reporting_org_activities(country_code)
page_args = request.view_args
page_args.pop("lang")
return render_template(
"country_activities.html",
projects=p,
country=country,
reporting_orgs=reporting_orgs,
freeze=('FREEZE' in app.config),
lang=lang,
page_endpoint=request.endpoint,
page_args=page_args,
)
def activity_export(country_code, reporting_org=None, lang="en"):
def notNone(value):
if value is not None:
return True
return False
def get_sectors_rows_length(numsectors):
if numsectors > 0:
return numsectors - 1
return 0
def getcs_string(list, col):
return "; ".join(
filter(notNone, map(lambda x: unicode(getattr(x, col)), list)))
def getcs_org(list, col):
return "; ".join(
filter(notNone, map(lambda x: getattr(x.organisation, col), list)))
country = abprojects.country(country_code)
country_name = country.text
font0 = xlwt.Font()
font0.name = 'Times New Roman'
font0.bold = True
styleHeader = xlwt.XFStyle()
styleHeader.font = font0
styleDates = xlwt.XFStyle()
styleDates.num_format_str = 'YYYY-MM-DD'
stylePCT = xlwt.XFStyle()
stylePCT.num_format_str = '0%'
projects = abprojects.projects(country_code, reporting_org)
wb = xlwt.Workbook()
ws = wb.add_sheet('Raw data export')
headers = [
'iati_identifier', 'project_title', 'project_description',
u'pct_{}'.format(country_name), 'sector_code', 'sector_name',
'sector_pct', 'aid_type_code', 'aid_type', 'collaboration_type_code',
'collaboration_type', 'finance_type_code', 'finance_type',
'activity_status_code', 'activity_status', 'date_start', 'date_end',
'capital_spend_pct', 'total_commitments', 'total_disbursements',
'implementing_org'
]
try:
minFY, maxFY = abstats.earliest_latest_disbursements(country_code)
disbFYs_QTRs = [("{} Q1".format(fy), "{} Q2".format(fy),
"{} Q3".format(fy), "{} Q4".format(fy))
for fy in range(minFY, maxFY + 1)]
disbFYs = [item for sublist in disbFYs_QTRs for item in sublist]
headers += map(lambda fy: "%s (D)" % fy, disbFYs)
except ValueError:
disbFYs = []
pass
minFY_fwd, maxFY_fwd = abstats.earliest_latest_forward_data(country_code)
fwdFYs = [fy for fy in range(minFY_fwd, maxFY_fwd + 1)]
headers += map(lambda fy: "MTEF {}".format(fy), fwdFYs)
[ws.write(0, i, h, styleHeader) for i, h in enumerate(headers)]
i = 0
for project in projects:
def remove_deleted_sectors(sector):
return sector.deleted == False
current_sectors = filter(remove_deleted_sectors, project.sectors)
i += 1
numsectors = len(current_sectors)
sectors_rows_length = get_sectors_rows_length(numsectors)
cols_vals = {
0: (project.iati_identifier, None),
1: (getcs_string(project.titles, 'text'), None),
2: (getcs_string(project.descriptions, 'text'), None),
3: (project.country_pcts_float[country.code] / 100.0, stylePCT),
7: (project.aid_type_code, None),
8: (project.aid_type.text, None),
9: (project.collaboration_type.code, None),
10: (project.collaboration_type.text, None),
11: (getcs_string(project.finance_types, 'code'), None),
12: (getcs_string(project.finance_types, 'text'), None),
13: (project.status_code, None),
14: (project.status.text, None),
15: (project.date_start_actual
or project.date_start_planned, styleDates),
16: (project.date_end_actual
or project.date_end_planned, styleDates),
17: (project.capital_exp, None),
18: (project.total_commitments, None),
19: (project.total_disbursements, None),
20: (getcs_org(project.implementing_orgs, 'name'), None),
}
for col, value in cols_vals.items():
if value[1] != None:
ws = wm(ws, i, sectors_rows_length, col, value[0], value[1])
else:
ws = wm(ws, i, sectors_rows_length, col, value[0])
for si, sector in enumerate(current_sectors):
cols_vals_simple = {
4: sector.dacsector.code,
5: sector.dacsector.description,
6: sector.percentage,
}
for col, value in cols_vals_simple.items():
ws = wr(ws, i, col, value)
for col, fy in enumerate(disbFYs, start=21):
fyd = project.FY_disbursements_dict(country).get(str(fy))
if fyd:
value = fyd["value"] * sector.percentage / 100.0
else:
value = 0
ws.write(i, col, value)
for col, fy in enumerate(fwdFYs, start=21 + len(disbFYs)):
fyd = project.FY_forward_spend_dict(country).get(str(fy))
if fyd:
value = fyd["value"] * sector.percentage / 100.0
else:
value = 0
ws.write(i, col, value)
if si + 1 < numsectors:
i += 1
strIOsender = StringIO.StringIO()
wb.save(strIOsender)
strIOsender.seek(0)
reporting_org_obj = absettings.reporting_org_by_id(reporting_org)
if reporting_org:
the_filename = "aidonbudget_%s_%s.xls" % (country_code,
reporting_org_obj.text)
else:
the_filename = "aidonbudget_%s.xls" % (country_code)
return send_file(strIOsender,
attachment_filename=the_filename,
as_attachment=True)