def committee(request, committee_id):
# grab url query string parameters
cycle = request.GET.get('cycle', None)
redirect_to_previous = False if cycle else True
committee, candidates, cycle = api_caller.load_with_nested(
'committee', committee_id, 'candidates', cycle)
parent = 'data'
cycle = int(cycle)
year = to_date(committee, cycle)
result_type = 'committees'
# Link to current cycle if candidate has a corresponding page, else link
# without cycle query parameter
# See https://github.com/18F/openFEC/issues/1536
for candidate in candidates:
election_years = [
election_year for election_year in candidate['election_years']
if election_year -
election_durations[candidate['office']] < cycle <= election_year
]
candidate['related_cycle'] = max(
election_years) if election_years else None
# add related candidates a level below
financials = api_caller.load_cmte_financials(committee_id, cycle=cycle)
report_type = report_types.get(committee['committee_type'], 'pac-party')
reports = financials['reports']
totals = financials['totals']
context_vars = {
'cycle': cycle,
'timePeriod': str(int(cycle) - 1) + '–' + str(cycle),
'name': committee['name'],
}
template_variables = {
'name': committee['name'],
'committee': committee,
'committee_id': committee_id,
'committee_type_full': committee['committee_type_full'],
'committee_type': committee['committee_type'],
'designation_full': committee['designation_full'],
'street_1': committee['street_1'],
'city': committee['city'],
'state': committee['state'],
'zip': committee['zip'],
'treasurer_name': committee['treasurer_name'],
'parent': parent,
'cycle': cycle,
'cycles': committee['cycles'],
'year': year,
'result_type': result_type,
'report_type': report_type,
'reports': reports,
'totals': totals,
'min_receipt_date': utils.three_days_ago(),
'context_vars': context_vars,
'party_full': committee['party_full']
}
if financials['reports'] and financials['totals']:
# Format the current two-year-period's totals using the process utilities
if committee['committee_type'] == 'I':
# IE-only committees have very little data, so they just get this one
template_variables['ie_summary'] = utils.process_ie_data(
financials['totals'][0])
else:
# All other committees have three tables
template_variables['raising_summary'] = utils.process_raising_data(
financials['totals'][0])
template_variables[
'spending_summary'] = utils.process_spending_data(
financials['totals'][0])
template_variables['cash_summary'] = utils.process_cash_data(
financials['totals'][0])
if redirect_to_previous and not financials['reports']:
# If there's no reports, find the first year with reports and redirect there
for c in sorted(committee['cycles'], reverse=True):
financials = api_caller.load_cmte_financials(
committee['committee_id'], cycle=c)
if financials['reports']:
return redirect(
reverse('committee-by-id',
kwargs={'committee_id': committee['committee_id']})
+ '?cycle=' + str(c))
# If it's not a senate committee and we're in the current cycle
# check if there's any raw filings in the last three days
if committee['committee_type'] != 'S' and cycle == utils.current_cycle():
raw_filings = api_caller._call_api(
'efile',
'filings',
cycle=cycle,
committee_id=committee['committee_id'],
min_receipt_date=template_variables['min_receipt_date'])
if len(raw_filings.get('results')) > 0:
template_variables['has_raw_filings'] = True
else:
template_variables['has_raw_filings'] = False
return render(request, 'committees-single.jinja', template_variables)
def get_committee(committee_id, cycle):
"""
Given a committee_id and cycle, call the API and get the committee
and committee financial data needed to render the committee profile page
"""
committee, all_candidates, cycle = load_committee_history(
committee_id, cycle)
# When there are multiple candidate records of various offices (H, S, P)
# linked to a single committee ID,
# associate the candidate record with the matching committee type
candidates = [
candidate for candidate in all_candidates
if committee["committee_type"] == candidate["office"]
]
parent = "data"
result_type = "committees"
cycle = int(cycle)
year = to_date(committee, cycle)
# Link to current cycle if candidate has a corresponding page, else link
# without cycle query parameter
# See https://github.com/fecgov/openFEC/issues/1536
for candidate in candidates:
election_years = []
for election_year in candidate["election_years"]:
start_of_election_period = (
election_year - election_durations[candidate["office"]])
if start_of_election_period < cycle and cycle <= election_year:
election_years.append(election_year)
# For each candidate, set related_cycle to the candidate's time period
# relative to the selected cycle.
candidate["related_cycle"] = cycle if election_years else None
report_type = report_types.get(committee["committee_type"], "pac-party")
cycle_out_of_range, fallback_cycle, cycles = load_cycle_data(
committee, cycle)
reports, totals = load_reports_and_totals(committee_id, cycle,
cycle_out_of_range,
fallback_cycle)
# Check organization types to determine SSF status
is_ssf = committee.get("organization_type") in [
"W", "C", "L", "V", "M", "T"
]
# if cycles_has_activity's options are more than cycles_has_financial's,
# when clicking back to financial summary/raising/spending,
# reset cycle=fallback_cycle and timePeriod and.
# to make sure missing message page show correct timePeriod.
time_period_js = str(int(cycle) - 1) + "–" + str(cycle)
cycle_js = cycle
if cycle_out_of_range:
cycle_js = fallback_cycle
time_period_js = str(int(cycle_js) - 1) + "–" + str(cycle_js)
context_vars = {
"cycle": cycle_js,
"timePeriod": time_period_js,
"name": committee["name"],
"cycleOutOfRange": cycle_out_of_range,
"lastCycleHasFinancial": fallback_cycle,
}
template_variables = {
"candidates": candidates,
"committee": committee,
"committee_id": committee_id,
"committee_type": committee["committee_type"],
"context_vars": context_vars,
"cycle": cycle,
"cycles": cycles,
"is_SSF": is_ssf,
"cycle_out_of_range": cycle_out_of_range,
"parent": parent,
"result_type": result_type,
"report_type": report_type,
"reports": reports,
"totals": totals,
"min_receipt_date": utils.three_days_ago(),
"context_vars": context_vars,
"party_full": committee["party_full"],
"candidates": candidates,
"social_image_identifier": "data",
"year": year,
"timePeriod": time_period_js,
}
# Format the current two-year-period's totals
if reports and totals:
# IE-only committees
if committee["committee_type"] == "I":
template_variables["ie_summary"] = utils.process_ie_data(totals)
# Inaugural Committees
elif committee["organization_type"] == "I":
template_variables[
"inaugural_summary"] = utils.process_inaugural_data(totals)
# Host Committees that file on Form 4
elif committee["organization_type"] == "H" and reports[
"form_type"] == "F4":
template_variables[
"raising_summary"] = utils.process_host_raising_data(totals)
template_variables[
"spending_summary"] = utils.process_host_spending_data(totals)
template_variables["cash_summary"] = utils.process_cash_data(
totals)
else:
# All other committees have three tables
template_variables["raising_summary"] = utils.process_raising_data(
totals)
template_variables[
"spending_summary"] = utils.process_spending_data(totals)
template_variables["cash_summary"] = utils.process_cash_data(
totals)
# If in the current cycle, check for raw filings in the last three days
if cycle == utils.current_cycle():
# (4)call efile/filings under tag: efiling
path = "/efile/filings/"
filters = {}
filters["cycle"] = cycle
filters["committee_id"] = committee["committee_id"]
filters["min_receipt_date"] = template_variables["min_receipt_date"]
raw_filings = api_caller.load_endpoint_results(path, **filters)
template_variables["has_raw_filings"] = True if raw_filings else False
else:
template_variables["has_raw_filings"] = False
# Needed for filings tab
template_variables["filings_lookup"] = {
"reports": ["F3", "F3X", "F3P", "F3L", "F4", "F5", "F7", "F13"],
"notices": ["F5", "F24", "F6", "F9", "F10", "F11"],
"statements": ["F1"],
"other": ["F1M", "F8", "F99", "F12"],
}
# Call /filings?committee_id=C00693234&form_type=F1
# Get the statements of organization
statement_of_organization = api_caller.load_committee_statement_of_organization(
committee_id)
if statement_of_organization:
statement_of_organization["receipt_date"] = format_receipt_date(
statement_of_organization["receipt_date"])
template_variables["statement_of_organization"] = statement_of_organization
# Add message for a committee that was formerly an authorized candidate committee.
# These committees are now unauthorized committees.
converted_committee_id = None
former_committee_name = None
former_authorized_candidate_id = None
former_authorized_candidate_name = None
if cycle == 2020 and committee_to_candidate_linkage.get(committee_id):
# Call /candidate/{candidate_id}/history/
converted_committee_id = committee.get('committee_id')
former_authorized_candidate_id = committee_to_candidate_linkage.get(
converted_committee_id)
path = "/candidate/" + str(
former_authorized_candidate_id) + "/history/"
filters = {}
filters["per_page"] = 1
candidate = api_caller.load_first_row_data(path, **filters)
# Get the converted committee's former name and candidate name
former_committee_name = former_committee_names.get(
converted_committee_id)
former_authorized_candidate_name = candidate.get('name')
template_variables["former_committee_name"] = former_committee_name
template_variables[
"former_authorized_candidate_name"] = former_authorized_candidate_name
template_variables[
"former_authorized_candidate_id"] = former_authorized_candidate_id
return template_variables