def organization_position_edit_process_view(request): """ :param request: :return: """ authority_required = {'verified_volunteer'} # admin, verified_volunteer if not voter_has_authority(request, authority_required): return redirect_to_sign_in_page(request, authority_required) google_civic_election_id = convert_to_int(request.POST.get('google_civic_election_id', 0)) organization_id = convert_to_int(request.POST.get('organization_id', 0)) position_id = convert_to_int(request.POST.get('position_id', 0)) candidate_campaign_id = convert_to_int(request.POST.get('candidate_campaign_id', 0)) contest_measure_id = convert_to_int(request.POST.get('contest_measure_id', 0)) stance = request.POST.get('stance', SUPPORT) # Set a default if stance comes in empty statement_text = request.POST.get('statement_text', '') # Set a default if stance comes in empty more_info_url = request.POST.get('more_info_url', '') go_back_to_add_new = False # Make sure this is a valid organization before we try to save a position organization_on_stage_found = False try: organization_query = Organization.objects.filter(id=organization_id) if organization_query.count(): organization_on_stage = organization_query[0] organization_on_stage_found = True except Exception as e: # If we can't retrieve the organization, we cannot proceed handle_record_not_found_exception(e, logger=logger) if not organization_on_stage_found: messages.add_message( request, messages.ERROR, "Could not find the organization when trying to create or edit a new position.") return HttpResponseRedirect(reverse('organization:organization_list', args=())) # Now retrieve the CandidateCampaign or the ContestMeasure so we can save it with the Position # We need either candidate_campaign_id or contest_measure_id if candidate_campaign_id: try: candidate_campaign_on_stage = CandidateCampaign.objects.get(id=candidate_campaign_id) candidate_campaign_on_stage_found = True except CandidateCampaign.MultipleObjectsReturned as e: handle_record_found_more_than_one_exception(e, logger=logger) except CandidateCampaign.DoesNotExist as e: handle_record_not_found_exception(e, logger=logger) if not candidate_campaign_on_stage_found: messages.add_message( request, messages.ERROR, "Could not find Candidate's campaign when trying to create or edit a new position.") if position_id: return HttpResponseRedirect( reverse('organization:organization_position_edit', args=([organization_id], [position_id])) ) else: return HttpResponseRedirect( reverse('organization:organization_position_new', args=([organization_id])) ) elif contest_measure_id: logger.warn("contest_measure_id FOUND. Look for ContestMeasure here.") else: logger.warn("Neither candidate_campaign_id nor contest_measure_id found") messages.add_message( request, messages.ERROR, "Unable to find either Candidate or Measure.") return HttpResponseRedirect( reverse('organization:organization_position_new', args=([organization_id])) + "?google_civic_election_id=" + str(google_civic_election_id) + "&stance=" + stance + "&statement_text=" + statement_text + "&more_info_url=" + more_info_url + "&candidate_not_found=1" ) organization_position_on_stage_found = False logger.info("position_id: {position_id}".format(position_id=position_id)) # Retrieve position from position_id if it exists already if position_id > 0: position_entered_manager = PositionEnteredManager() results = position_entered_manager.retrieve_position_from_id(position_id) if results['position_found']: organization_position_on_stage_found = True organization_position_on_stage = results['position'] organization_position_found_from_new_form = False if not organization_position_on_stage_found: # If not found from position_id # If a position_id hasn't been passed in, then we are trying to create a new position. # Check to make sure a position for this org, candidate and election doesn't already exist position_entered_manager = PositionEnteredManager() results = position_entered_manager.retrieve_organization_candidate_campaign_position( organization_id, candidate_campaign_id, google_civic_election_id) if results['MultipleObjectsReturned']: messages.add_message( request, messages.ERROR, "We found more than one existing positions for this candidate. Please delete all but one position.") return HttpResponseRedirect( reverse('organization:organization_position_list', args=([organization_id])) ) elif results['position_found']: organization_position_on_stage_found = True organization_position_on_stage = results['position'] organization_position_found_from_new_form = True # Now save existing, or create new success = False try: if organization_position_on_stage_found: # Update the position organization_position_on_stage.stance = stance organization_position_on_stage.google_civic_election_id = google_civic_election_id if not organization_position_found_from_new_form or positive_value_exists(more_info_url): # Only update this if we came from update form, or there is a value in the incoming variable organization_position_on_stage.more_info_url = more_info_url if not organization_position_found_from_new_form or positive_value_exists(statement_text): # Only update this if we came from update form, or there is a value in the incoming variable organization_position_on_stage.statement_text = statement_text if not positive_value_exists(organization_position_on_stage.organization_we_vote_id): organization_position_on_stage.organization_we_vote_id = organization_on_stage.we_vote_id if not positive_value_exists(organization_position_on_stage.candidate_campaign_we_vote_id): organization_position_on_stage.candidate_campaign_we_vote_id = candidate_campaign_on_stage.we_vote_id if not positive_value_exists(organization_position_on_stage.google_civic_candidate_name): organization_position_on_stage.google_civic_candidate_name = \ candidate_campaign_on_stage.google_civic_candidate_name organization_position_on_stage.save() success = True messages.add_message( request, messages.INFO, "Position on {candidate_name} updated.".format( candidate_name=candidate_campaign_on_stage.display_candidate_name())) else: # Create new organization_position_on_stage = PositionEntered( organization_id=organization_id, organization_we_vote_id=organization_on_stage.we_vote_id, candidate_campaign_id=candidate_campaign_on_stage.id, candidate_campaign_we_vote_id=candidate_campaign_on_stage.we_vote_id, # Save candidate_campaign_on_stage so we can re-link candidates to positions if we_vote_id is lost google_civic_candidate_name=candidate_campaign_on_stage.google_civic_candidate_name, google_civic_election_id=google_civic_election_id, stance=stance, statement_text=statement_text, more_info_url=more_info_url, ) organization_position_on_stage.save() success = True messages.add_message( request, messages.INFO, "New position on {candidate_name} saved.".format( candidate_name=candidate_campaign_on_stage.display_candidate_name())) go_back_to_add_new = True except Exception as e: handle_record_not_saved_exception(e, logger=logger) logger.error("Problem saving PositionEntered for CandidateCampaign") # If the position was saved, then update the voter_guide entry if success: voter_guide_manager = VoterGuideManager() results = voter_guide_manager.update_or_create_organization_voter_guide_by_election_id( organization_on_stage.we_vote_id, google_civic_election_id) # if results['success']: if go_back_to_add_new: return HttpResponseRedirect( reverse('organization:organization_position_new', args=(organization_on_stage.id,)) + "?google_civic_election_id=" + str(google_civic_election_id)) else: return HttpResponseRedirect( reverse('organization:organization_position_list', args=(organization_on_stage.id,)))
def transfer_vote_smart_ratings_to_positions_for_candidate(candidate_campaign_id): candidate_manager = CandidateCampaignManager() candidate_results = candidate_manager.retrieve_candidate_campaign_from_id(candidate_campaign_id) if candidate_results['candidate_campaign_found']: # Working with Vote Smart data candidate_campaign = candidate_results['candidate_campaign'] if not positive_value_exists(candidate_campaign.vote_smart_id): status = "VOTE_SMART_ID_HAS_NOT_BEEN_RETRIEVED_YET_FOR_THIS_CANDIDATE: " \ "{candidate_campaign_id}".format(candidate_campaign_id=candidate_campaign_id) success = False results = { 'status': status, 'success': success, } return results else: try: rating_list_query = VoteSmartRatingOneCandidate.objects.order_by('-timeSpan') # Desc order rating_list = rating_list_query.filter(candidateId=candidate_campaign.vote_smart_id) except Exception as error_instance: # Catch the error message coming back from Vote Smart and pass it in the status error_message = error_instance.args status = "EXCEPTION_RAISED: {error_message}".format(error_message=error_message) success = False results = { 'status': status, 'success': success, } return results ratings_status = "" position_manager = PositionEnteredManager() special_interest_group_manager = VoteSmartSpecialInterestGroupManager() for one_candidate_rating in rating_list: # Make sure we have all of the required variables if not one_candidate_rating.sigId: ratings_status += "MISSING_SPECIAL_INTEREST_GROUP_ID-{ratingId} * " \ "".format(ratingId=one_candidate_rating.ratingId) continue # Make sure an organization exists and is updated with Vote Smart info update_results = special_interest_group_manager.update_or_create_we_vote_organization( one_candidate_rating.sigId) if not update_results['organization_found']: # TRY AGAIN: Reach out to Vote Smart and try to retrieve this special interest group by sigId one_group_results = retrieve_vote_smart_special_interest_group_into_local_db(one_candidate_rating.sigId) if one_group_results['success']: update_results = special_interest_group_manager.update_or_create_we_vote_organization( one_candidate_rating.sigId) if not update_results['organization_found']: ratings_status += "COULD_NOT_FIND_OR_SAVE_NEW_SIG-{sigId}-{status} * " \ "".format(sigId=one_candidate_rating.sigId, status=update_results['status']) continue else: we_vote_organization = update_results['organization'] # Check to see if a position already exists # TODO DALE Note: we need to consider searching with a time span variable # (in addition to just org and candidate identifiers) since I believe # Google Civic gives a person a new candidate campaign ID each election, # while Vote Smart uses the same candidateId from year to year organization_position_results = position_manager.retrieve_organization_candidate_campaign_position( we_vote_organization.id, candidate_campaign_id) if positive_value_exists(organization_position_results['position_found']): # For now, we only want to create positions that don't exist continue else: position_results = position_manager.update_or_create_position( position_id=0, position_we_vote_id=False, organization_we_vote_id=we_vote_organization.we_vote_id, public_figure_we_vote_id=False, voter_we_vote_id=False, google_civic_election_id=False, ballot_item_display_name=candidate_campaign.candidate_name, office_we_vote_id=False, candidate_we_vote_id=candidate_campaign.we_vote_id, measure_we_vote_id=False, stance=PERCENT_RATING, statement_text=one_candidate_rating.ratingText, statement_html=False, more_info_url=False, vote_smart_time_span=one_candidate_rating.timeSpan, vote_smart_rating_id=one_candidate_rating.ratingId, vote_smart_rating=one_candidate_rating.rating, vote_smart_rating_name=one_candidate_rating.ratingName, ) if not positive_value_exists(position_results['success']): ratings_status += "COULD_NOT_CREATE_POSITION-{sigId}-{status} * " \ "".format(sigId=one_candidate_rating.sigId, status=position_results['status']) success = True status = "TRANSFER_PROCESS_COMPLETED: " + ratings_status results = { 'status': status, 'success': success, } return results
def organization_save_new_or_edit_existing_position_process_form_view(request): """ :param request: :return: """ organization_id = convert_to_int(request.POST['organization_id']) position_id = convert_to_int(request.POST['position_id']) candidate_campaign_id = convert_to_int( request.POST['candidate_campaign_id']) measure_campaign_id = convert_to_int(request.POST['measure_campaign_id']) stance = request.POST.get( 'stance', SUPPORT) # Set a default if stance comes in empty statement_text = request.POST.get( 'statement_text', '') # Set a default if stance comes in empty more_info_url = request.POST.get('more_info_url', '') # Make sure this is a valid organization before we try to save a position organization_on_stage_found = False try: organization_query = Organization.objects.filter(id=organization_id) if len(organization_query): # organization_on_stage = organization_query[0] organization_on_stage_found = True except Exception as e: # If we can't retrieve the organization, we cannot proceed handle_record_not_found_exception(e, logger=logger) if not organization_on_stage_found: messages.add_message( request, messages.ERROR, "Could not find the organization when trying to create or edit a new position." ) return HttpResponseRedirect( reverse('organization:organization_list', args=())) # Now retrieve the CandidateCampaign or the MeasureCampaign so we can save it with the Position # We need either candidate_campaign_id or measure_campaign_id if candidate_campaign_id: try: candidate_campaign_on_stage = CandidateCampaign.objects.get( id=candidate_campaign_id) candidate_campaign_on_stage_found = True except CandidateCampaign.MultipleObjectsReturned as e: handle_record_found_more_than_one_exception(e, logger=logger) except CandidateCampaign.DoesNotExist as e: handle_record_not_found_exception(e, logger=logger) if not candidate_campaign_on_stage_found: messages.add_message( request, messages.ERROR, "Could not find Candidate's campaign when trying to create or edit a new position." ) if position_id: return HttpResponseRedirect( reverse('organization:organization_position_edit', args=([organization_id], [position_id]))) else: return HttpResponseRedirect( reverse('organization:organization_position_new', args=([organization_id]))) elif measure_campaign_id: logger.warn( "measure_campaign_id FOUND. Look for MeasureCampaign here.") else: logger.warn( "Neither candidate_campaign_id nor measure_campaign_id found") messages.add_message(request, messages.ERROR, "Unable to find either Candidate or Measure.") return HttpResponseRedirect( reverse('organization:organization_position_list', args=([organization_id]))) organization_position_on_stage_found = False logger.info("position_id: {position_id}".format(position_id=position_id)) # Retrieve position from position_id if it exists already if position_id > 0: position_entered_manager = PositionEnteredManager() results = position_entered_manager.retrieve_position_from_id( position_id) if results['position_found']: organization_position_on_stage_found = True organization_position_on_stage = results['position'] if not organization_position_on_stage_found: # If a position_id hasn't been passed in, then we are trying to create a new position. # Check to make sure a position for this org and candidate doesn't already exist position_entered_manager = PositionEnteredManager() results = position_entered_manager.retrieve_organization_candidate_campaign_position( organization_id, candidate_campaign_id) if results['MultipleObjectsReturned']: messages.add_message( request, messages.ERROR, "We found more than one existing positions for this candidate. Please delete all but one position." ) return HttpResponseRedirect( reverse('organization:organization_position_list', args=([organization_id]))) elif results['position_found']: organization_position_on_stage_found = True organization_position_on_stage = results['position'] # Now save existing, or create new try: if organization_position_on_stage_found: # Update the position organization_position_on_stage.stance = stance organization_position_on_stage.statement_text = statement_text organization_position_on_stage.more_info_url = more_info_url organization_position_on_stage.save() messages.add_message( request, messages.INFO, "Position on {candidate_name} updated.".format( candidate_name=candidate_campaign_on_stage.candidate_name)) else: # Create new organization_position_on_stage = PositionEntered( organization_id=organization_id, candidate_campaign_id=candidate_campaign_on_stage.id, stance=stance, statement_text=statement_text, more_info_url=more_info_url, ) organization_position_on_stage.save() messages.add_message( request, messages.INFO, "New position on {candidate_name} saved.".format( candidate_name=candidate_campaign_on_stage.candidate_name)) except Exception as e: handle_record_not_saved_exception(e, logger=logger) logger.error("Problem saving PositionEntered for CandidateCampaign") return HttpResponseRedirect( reverse('organization:organization_position_list', args=([organization_id])))
def organization_save_new_or_edit_existing_position_process_form_view(request): """ :param request: :return: """ # If person isn't signed in, we don't want to let them visit this page yet if not request.user.is_authenticated(): return redirect('/admin') organization_id = convert_to_int(request.POST['organization_id']) position_id = convert_to_int(request.POST['position_id']) candidate_campaign_id = convert_to_int(request.POST['candidate_campaign_id']) measure_campaign_id = convert_to_int(request.POST['measure_campaign_id']) stance = request.POST.get('stance', SUPPORT) # Set a default if stance comes in empty statement_text = request.POST.get('statement_text', '') # Set a default if stance comes in empty more_info_url = request.POST.get('more_info_url', '') # Make sure this is a valid organization before we try to save a position organization_on_stage_found = False try: organization_query = Organization.objects.filter(id=organization_id) if len(organization_query): organization_on_stage = organization_query[0] organization_on_stage_found = True except Exception as e: # If we can't retrieve the organization, we cannot proceed handle_record_not_found_exception(e) if not organization_on_stage_found: messages.add_message( request, messages.ERROR, "Could not find the organization when trying to create or edit a new position.") return HttpResponseRedirect(reverse('organization:organization_list', args=())) # Now retrieve the CandidateCampaign or the MeasureCampaign so we can save it with the Position # We need either candidate_campaign_id or measure_campaign_id if candidate_campaign_id: try: candidate_campaign_on_stage = CandidateCampaign.objects.get(id=candidate_campaign_id) candidate_campaign_on_stage_found = True except CandidateCampaign.MultipleObjectsReturned as e: handle_record_found_more_than_one_exception(e) except CandidateCampaign.DoesNotExist as e: handle_record_not_found_exception(e) if not candidate_campaign_on_stage_found: messages.add_message( request, messages.ERROR, "Could not find Candidate's campaign when trying to create or edit a new position.") if position_id: return HttpResponseRedirect( reverse('organization:organization_position_edit', args=([organization_id], [position_id])) ) else: return HttpResponseRedirect( reverse('organization:organization_position_new', args=([organization_id])) ) elif measure_campaign_id: print "measure_campaign_id FOUND. Look for MeasureCampaign here." else: print "Neither candidate_campaign_id nor measure_campaign_id found" messages.add_message( request, messages.ERROR, "Unable to find either Candidate or Measure.") return HttpResponseRedirect( reverse('organization:organization_position_list', args=([organization_id])) ) organization_position_on_stage_found = False print "position_id: {position_id}".format(position_id=position_id) # Retrieve position from position_id if it exists already if position_id > 0: position_entered_manager = PositionEnteredManager() results = position_entered_manager.retrieve_position_from_id(position_id) if results['position_found']: organization_position_on_stage_found = True organization_position_on_stage = results['position'] if not organization_position_on_stage_found: # If a position_id hasn't been passed in, then we are trying to create a new position. # Check to make sure a position for this org and candidate doesn't already exist position_entered_manager = PositionEnteredManager() results = position_entered_manager.retrieve_organization_candidate_campaign_position(organization_id, candidate_campaign_id) if results['MultipleObjectsReturned']: messages.add_message( request, messages.ERROR, "We found more than one existing positions for this candidate. Please delete all but one position.") return HttpResponseRedirect( reverse('organization:organization_position_list', args=([organization_id])) ) elif results['position_found']: organization_position_on_stage_found = True organization_position_on_stage = results['position'] # Now save existing, or create new try: if organization_position_on_stage_found: # Update the position organization_position_on_stage.stance = stance organization_position_on_stage.statement_text = statement_text organization_position_on_stage.more_info_url = more_info_url organization_position_on_stage.save() messages.add_message( request, messages.INFO, "Position on {candidate_name} updated.".format(candidate_name=candidate_campaign_on_stage.candidate_name)) else: # Create new organization_position_on_stage = PositionEntered( organization_id=organization_id, candidate_campaign_id=candidate_campaign_on_stage.id, stance=stance, statement_text=statement_text, more_info_url=more_info_url, ) organization_position_on_stage.save() messages.add_message( request, messages.INFO, "New position on {candidate_name} saved.".format(candidate_name=candidate_campaign_on_stage.candidate_name)) except Exception as e: handle_record_not_saved_exception(e) print "Problem saving PositionEntered for CandidateCampaign" return HttpResponseRedirect(reverse('organization:organization_position_list', args=([organization_id])))
def transfer_vote_smart_ratings_to_positions( candidate_campaign_id, politician_id): # TODO DALE Update for politician we_vote_organizations_created = 0 organization_positions_that_exist = 0 organization_positions_created = 0 candidate_manager = CandidateCampaignManager() candidate_results = candidate_manager.retrieve_candidate_campaign_from_id( candidate_campaign_id) if candidate_results['candidate_campaign_found']: # Working with Vote Smart data candidate_campaign = candidate_results['candidate_campaign'] if not positive_value_exists(candidate_campaign.vote_smart_id): status = "VOTE_SMART_ID_HAS_NOT_BEEN_RETRIEVED_YET_FOR_THIS_CANDIDATE: " \ "{candidate_campaign_id}".format(candidate_campaign_id=candidate_campaign_id) success = False results = { 'status': status, 'success': success, 'we_vote_organizations_created': we_vote_organizations_created, 'organization_positions_that_exist': organization_positions_that_exist, 'organization_positions_created': organization_positions_created, } return results else: try: rating_list_query = VoteSmartRatingOneCandidate.objects.order_by( '-timeSpan') # Desc order rating_list = rating_list_query.filter( candidateId=candidate_campaign.vote_smart_id) except Exception as error_instance: # Catch the error message coming back from Vote Smart and pass it in the status error_message = error_instance.args status = "EXCEPTION_RAISED: {error_message}".format( error_message=error_message) success = False results = { 'status': status, 'success': success, 'we_vote_organizations_created': we_vote_organizations_created, 'organization_positions_that_exist': organization_positions_that_exist, 'organization_positions_created': organization_positions_created, } return results ratings_status = "" position_manager = PositionEnteredManager() special_interest_group_manager = VoteSmartSpecialInterestGroupManager() for one_candidate_rating in rating_list: # Make sure we have all of the required variables if not one_candidate_rating.sigId: ratings_status += "MISSING_SPECIAL_INTEREST_GROUP_ID-{ratingId} * " \ "".format(ratingId=one_candidate_rating.ratingId) continue # Make sure an organization exists and is updated with Vote Smart info update_results = special_interest_group_manager.update_or_create_we_vote_organization( one_candidate_rating.sigId) if not update_results['organization_found']: # TRY AGAIN: Reach out to Vote Smart and try to retrieve this special interest group by sigId one_group_results = retrieve_vote_smart_special_interest_group_into_local_db( one_candidate_rating.sigId) if one_group_results['success']: update_results = special_interest_group_manager.update_or_create_we_vote_organization( one_candidate_rating.sigId) if not update_results['organization_found']: ratings_status += "COULD_NOT_FIND_OR_SAVE_NEW_SIG-{sigId}-{status} * " \ "".format(sigId=one_candidate_rating.sigId, status=update_results['status']) continue else: we_vote_organization = update_results['organization'] if update_results['organization_created']: we_vote_organizations_created += 1 # Check to see if a position already exists # TODO DALE Note: we need to consider searching with a time span variable # (in addition to just org and candidate identifiers) since I believe # Google Civic gives a person a new candidate campaign ID each election, # while Vote Smart uses the same candidateId from year to year organization_position_results = position_manager.retrieve_organization_candidate_campaign_position( we_vote_organization.id, candidate_campaign_id) if positive_value_exists( organization_position_results['position_found']): # For now, we only want to create positions that don't exist organization_positions_that_exist += 1 continue else: position_results = position_manager.update_or_create_position( position_we_vote_id=False, organization_we_vote_id=we_vote_organization.we_vote_id, public_figure_we_vote_id=False, voter_we_vote_id=False, google_civic_election_id=False, ballot_item_display_name=candidate_campaign. display_candidate_name(), office_we_vote_id=False, candidate_we_vote_id=candidate_campaign.we_vote_id, measure_we_vote_id=False, stance=PERCENT_RATING, set_as_public_position=True, statement_text=one_candidate_rating.ratingText, statement_html=False, more_info_url=False, vote_smart_time_span=one_candidate_rating.timeSpan, vote_smart_rating_id=one_candidate_rating.ratingId, vote_smart_rating=one_candidate_rating.rating, vote_smart_rating_name=one_candidate_rating.ratingName, ) if positive_value_exists(position_results['success']): organization_positions_created += 1 else: ratings_status += "COULD_NOT_CREATE_POSITION-{sigId}-{status} * " \ "".format(sigId=one_candidate_rating.sigId, status=position_results['status']) success = True status = "TRANSFER_PROCESS_COMPLETED: " + ratings_status results = { 'status': status, 'success': success, 'we_vote_organizations_created': we_vote_organizations_created, 'organization_positions_that_exist': organization_positions_that_exist, 'organization_positions_created': organization_positions_created, } return results
def organization_save_new_or_edit_existing_position_process_form_view(request): """ :param request: :return: """ authority_required = {'verified_volunteer'} # admin, verified_volunteer if not voter_has_authority(request, authority_required): return redirect_to_sign_in_page(request, authority_required) google_civic_election_id = convert_to_int(request.POST['google_civic_election_id']) organization_id = convert_to_int(request.POST['organization_id']) position_id = convert_to_int(request.POST['position_id']) candidate_campaign_id = convert_to_int(request.POST['candidate_campaign_id']) contest_measure_id = convert_to_int(request.POST['contest_measure_id']) stance = request.POST.get('stance', SUPPORT) # Set a default if stance comes in empty statement_text = request.POST.get('statement_text', '') # Set a default if stance comes in empty more_info_url = request.POST.get('more_info_url', '') # Make sure this is a valid organization before we try to save a position organization_on_stage_found = False try: organization_query = Organization.objects.filter(id=organization_id) if organization_query.count(): organization_on_stage = organization_query[0] organization_on_stage_found = True except Exception as e: # If we can't retrieve the organization, we cannot proceed handle_record_not_found_exception(e, logger=logger) if not organization_on_stage_found: messages.add_message( request, messages.ERROR, "Could not find the organization when trying to create or edit a new position.") return HttpResponseRedirect(reverse('organization:organization_list', args=())) # Now retrieve the CandidateCampaign or the ContestMeasure so we can save it with the Position # We need either candidate_campaign_id or contest_measure_id if candidate_campaign_id: try: candidate_campaign_on_stage = CandidateCampaign.objects.get(id=candidate_campaign_id) candidate_campaign_on_stage_found = True except CandidateCampaign.MultipleObjectsReturned as e: handle_record_found_more_than_one_exception(e, logger=logger) except CandidateCampaign.DoesNotExist as e: handle_record_not_found_exception(e, logger=logger) if not candidate_campaign_on_stage_found: messages.add_message( request, messages.ERROR, "Could not find Candidate's campaign when trying to create or edit a new position.") if position_id: return HttpResponseRedirect( reverse('organization:organization_position_edit', args=([organization_id], [position_id])) ) else: return HttpResponseRedirect( reverse('organization:organization_position_new', args=([organization_id])) ) elif contest_measure_id: logger.warn("contest_measure_id FOUND. Look for ContestMeasure here.") else: logger.warn("Neither candidate_campaign_id nor contest_measure_id found") messages.add_message( request, messages.ERROR, "Unable to find either Candidate or Measure.") return HttpResponseRedirect( reverse('organization:organization_position_list', args=([organization_id])) ) organization_position_on_stage_found = False logger.info("position_id: {position_id}".format(position_id=position_id)) # Retrieve position from position_id if it exists already if position_id > 0: position_entered_manager = PositionEnteredManager() results = position_entered_manager.retrieve_position_from_id(position_id) if results['position_found']: organization_position_on_stage_found = True organization_position_on_stage = results['position'] if not organization_position_on_stage_found: # If a position_id hasn't been passed in, then we are trying to create a new position. # Check to make sure a position for this org and candidate doesn't already exist position_entered_manager = PositionEnteredManager() results = position_entered_manager.retrieve_organization_candidate_campaign_position( organization_id, candidate_campaign_id) if results['MultipleObjectsReturned']: messages.add_message( request, messages.ERROR, "We found more than one existing positions for this candidate. Please delete all but one position.") return HttpResponseRedirect( reverse('organization:organization_position_list', args=([organization_id])) ) elif results['position_found']: organization_position_on_stage_found = True organization_position_on_stage = results['position'] # Now save existing, or create new success = False try: if organization_position_on_stage_found: # Update the position organization_position_on_stage.stance = stance organization_position_on_stage.google_civic_election_id = google_civic_election_id organization_position_on_stage.more_info_url = more_info_url organization_position_on_stage.statement_text = statement_text if not positive_value_exists(organization_position_on_stage.organization_we_vote_id): organization_position_on_stage.organization_we_vote_id = organization_on_stage.we_vote_id if not positive_value_exists(organization_position_on_stage.candidate_campaign_we_vote_id): organization_position_on_stage.candidate_campaign_we_vote_id = candidate_campaign_on_stage.we_vote_id if not positive_value_exists(organization_position_on_stage.google_civic_candidate_name): organization_position_on_stage.google_civic_candidate_name = \ candidate_campaign_on_stage.google_civic_candidate_name organization_position_on_stage.save() success = True messages.add_message( request, messages.INFO, "Position on {candidate_name} updated.".format( candidate_name=candidate_campaign_on_stage.candidate_name)) else: # Create new organization_position_on_stage = PositionEntered( organization_id=organization_id, organization_we_vote_id=organization_on_stage.we_vote_id, candidate_campaign_id=candidate_campaign_on_stage.id, candidate_campaign_we_vote_id=candidate_campaign_on_stage.we_vote_id, # Save candidate_campaign_on_stage so we can re-link candidates to positions if we_vote_id is lost google_civic_candidate_name=candidate_campaign_on_stage.google_civic_candidate_name, google_civic_election_id=google_civic_election_id, stance=stance, statement_text=statement_text, more_info_url=more_info_url, ) organization_position_on_stage.save() success = True messages.add_message( request, messages.INFO, "New position on {candidate_name} saved.".format( candidate_name=candidate_campaign_on_stage.candidate_name)) except Exception as e: handle_record_not_saved_exception(e, logger=logger) logger.error("Problem saving PositionEntered for CandidateCampaign") # If the position was saved, then update the voter_guide entry if success: voter_guide_manager = VoterGuideManager() results = voter_guide_manager.update_or_create_organization_voter_guide_by_election_id( organization_on_stage.we_vote_id, google_civic_election_id) # if results['success']: return HttpResponseRedirect(reverse('organization:organization_position_list', args=(organization_on_stage.id,)))
def organization_position_edit_process_view(request): """ :param request: :return: """ authority_required = {'verified_volunteer'} # admin, verified_volunteer if not voter_has_authority(request, authority_required): return redirect_to_sign_in_page(request, authority_required) google_civic_election_id = convert_to_int(request.POST.get('google_civic_election_id', 0)) organization_id = convert_to_int(request.POST.get('organization_id', 0)) position_we_vote_id = request.POST.get('position_we_vote_id', '') candidate_campaign_id = convert_to_int(request.POST.get('candidate_campaign_id', 0)) contest_measure_id = convert_to_int(request.POST.get('contest_measure_id', 0)) stance = request.POST.get('stance', SUPPORT) # Set a default if stance comes in empty statement_text = request.POST.get('statement_text', '') # Set a default if stance comes in empty more_info_url = request.POST.get('more_info_url', '') go_back_to_add_new = False candidate_campaign_we_vote_id = "" google_civic_candidate_name = "" contest_measure_we_vote_id = "" google_civic_measure_title = "" candidate_campaign_on_stage_found = False contest_measure_on_stage_found = False organization_position_on_stage = PositionEntered() organization_on_stage = Organization() candidate_campaign_on_stage = CandidateCampaign() contest_measure_on_stage = ContestMeasure() state_code = "" position_entered_manager = PositionEnteredManager() # Make sure this is a valid organization before we try to save a position organization_on_stage_found = False organization_we_vote_id = "" try: organization_query = Organization.objects.filter(id=organization_id) if organization_query.count(): organization_on_stage = organization_query[0] organization_we_vote_id = organization_on_stage.we_vote_id organization_on_stage_found = True except Exception as e: # If we can't retrieve the organization, we cannot proceed handle_record_not_found_exception(e, logger=logger) if not organization_on_stage_found: messages.add_message( request, messages.ERROR, "Could not find the organization when trying to create or edit a new position.") return HttpResponseRedirect(reverse('organization:organization_list', args=())) # Now retrieve the CandidateCampaign or the ContestMeasure so we can save it with the Position # We need either candidate_campaign_id or contest_measure_id if candidate_campaign_id: try: candidate_campaign_on_stage = CandidateCampaign.objects.get(id=candidate_campaign_id) candidate_campaign_on_stage_found = True candidate_campaign_we_vote_id = candidate_campaign_on_stage.we_vote_id google_civic_candidate_name = candidate_campaign_on_stage.google_civic_candidate_name state_code = candidate_campaign_on_stage.state_code except CandidateCampaign.MultipleObjectsReturned as e: handle_record_found_more_than_one_exception(e, logger=logger) except CandidateCampaign.DoesNotExist as e: handle_record_not_found_exception(e, logger=logger) if not candidate_campaign_on_stage_found: messages.add_message( request, messages.ERROR, "Could not find Candidate's campaign when trying to create or edit a new position.") if positive_value_exists(position_we_vote_id): return HttpResponseRedirect( reverse('organization:organization_position_edit', args=([organization_id], [position_we_vote_id])) + "?google_civic_election_id=" + str(google_civic_election_id) + "&stance=" + stance + "&statement_text=" + statement_text + "&more_info_url=" + more_info_url + "&candidate_and_measure_not_found=1" ) else: return HttpResponseRedirect( reverse('organization:organization_position_new', args=([organization_id])) + "?google_civic_election_id=" + str(google_civic_election_id) + "&stance=" + stance + "&statement_text=" + statement_text + "&more_info_url=" + more_info_url + "&candidate_and_measure_not_found=1" ) contest_measure_id = 0 elif contest_measure_id: try: contest_measure_on_stage = ContestMeasure.objects.get(id=contest_measure_id) contest_measure_on_stage_found = True contest_measure_we_vote_id = contest_measure_on_stage.we_vote_id google_civic_measure_title = contest_measure_on_stage.google_civic_measure_title state_code = contest_measure_on_stage.state_code except CandidateCampaign.MultipleObjectsReturned as e: handle_record_found_more_than_one_exception(e, logger=logger) except CandidateCampaign.DoesNotExist as e: handle_record_not_found_exception(e, logger=logger) if not contest_measure_on_stage_found: messages.add_message( request, messages.ERROR, "Could not find measure when trying to create or edit a new position.") if positive_value_exists(position_we_vote_id): return HttpResponseRedirect( reverse('organization:organization_position_edit', args=([organization_id], [position_we_vote_id])) + "?google_civic_election_id=" + str(google_civic_election_id) + "&stance=" + stance + "&statement_text=" + statement_text + "&more_info_url=" + more_info_url + "&candidate_and_measure_not_found=1" ) else: return HttpResponseRedirect( reverse('organization:organization_position_new', args=([organization_id])) + "?google_civic_election_id=" + str(google_civic_election_id) + "&stance=" + stance + "&statement_text=" + statement_text + "&more_info_url=" + more_info_url + "&candidate_and_measure_not_found=1" ) candidate_campaign_id = 0 else: messages.add_message( request, messages.ERROR, "Unable to find either Candidate or Measure.") return HttpResponseRedirect( reverse('organization:organization_position_new', args=([organization_id])) + "?google_civic_election_id=" + str(google_civic_election_id) + "&stance=" + stance + "&statement_text=" + statement_text + "&more_info_url=" + more_info_url + "&candidate_and_measure_not_found=1" ) organization_position_on_stage_found = False # Retrieve position from position_we_vote_id if it exists already if positive_value_exists(position_we_vote_id): results = position_entered_manager.retrieve_position_from_we_vote_id(position_we_vote_id) if results['position_found']: organization_position_on_stage_found = True organization_position_on_stage = results['position'] organization_position_found_from_new_form = False if not organization_position_on_stage_found: # Position not found from position_we_vote_id # If a position_we_vote_id hasn't been passed in, then we are trying to create a new position. # Check to make sure a position for this org, candidate and election doesn't already exist if candidate_campaign_id: results = position_entered_manager.retrieve_organization_candidate_campaign_position( organization_id, candidate_campaign_id, google_civic_election_id) elif contest_measure_id: results = position_entered_manager.retrieve_organization_contest_measure_position( organization_id, contest_measure_id, google_civic_election_id) else: messages.add_message( request, messages.ERROR, "Missing both candidate_campaign_id and contest_measure_id.") return HttpResponseRedirect( reverse('organization:organization_position_list', args=([organization_id])) ) if results['MultipleObjectsReturned']: messages.add_message( request, messages.ERROR, "We found more than one existing positions for this candidate. Please delete all but one position.") return HttpResponseRedirect( reverse('organization:organization_position_list', args=([organization_id])) ) elif results['position_found']: organization_position_on_stage_found = True organization_position_on_stage = results['position'] organization_position_found_from_new_form = True # Now save existing, or create new success = False try: if organization_position_on_stage_found: # Update the position organization_position_on_stage.stance = stance organization_position_on_stage.google_civic_election_id = google_civic_election_id if not organization_position_found_from_new_form or positive_value_exists(more_info_url): # Only update this if we came from update form, or there is a value in the incoming variable organization_position_on_stage.more_info_url = more_info_url if not organization_position_found_from_new_form or positive_value_exists(statement_text): # Only update this if we came from update form, or there is a value in the incoming variable organization_position_on_stage.statement_text = statement_text if not positive_value_exists(organization_position_on_stage.organization_we_vote_id): organization_position_on_stage.organization_we_vote_id = organization_on_stage.we_vote_id organization_position_on_stage.candidate_campaign_id = candidate_campaign_id organization_position_on_stage.candidate_campaign_we_vote_id = candidate_campaign_we_vote_id organization_position_on_stage.google_civic_candidate_name = google_civic_candidate_name organization_position_on_stage.contest_measure_id = contest_measure_id organization_position_on_stage.contest_measure_we_vote_id = contest_measure_we_vote_id organization_position_on_stage.google_civic_measure_title = google_civic_measure_title organization_position_on_stage.state_code = state_code organization_position_on_stage.save() organization_position_on_stage = position_entered_manager.refresh_cached_position_info( organization_position_on_stage) success = True if positive_value_exists(candidate_campaign_we_vote_id): messages.add_message( request, messages.INFO, "Position on {candidate_name} updated.".format( candidate_name=candidate_campaign_on_stage.display_candidate_name())) elif positive_value_exists(contest_measure_we_vote_id): messages.add_message( request, messages.INFO, "Position on {measure_title} updated.".format( measure_title=contest_measure_on_stage.measure_title)) else: # Create new # Note that since we are processing a volunteer/admin entry tool, we can always save to the PositionEntered # table, and don't need to worry about PositionForFriends organization_position_on_stage = PositionEntered( organization_id=organization_id, organization_we_vote_id=organization_we_vote_id, candidate_campaign_id=candidate_campaign_id, candidate_campaign_we_vote_id=candidate_campaign_we_vote_id, google_civic_candidate_name=google_civic_candidate_name, contest_measure_id=contest_measure_id, contest_measure_we_vote_id=contest_measure_we_vote_id, google_civic_measure_title=google_civic_measure_title, google_civic_election_id=google_civic_election_id, stance=stance, statement_text=statement_text, more_info_url=more_info_url, state_code=state_code, ) organization_position_on_stage.save() organization_position_on_stage = position_entered_manager.refresh_cached_position_info( organization_position_on_stage) success = True if positive_value_exists(candidate_campaign_we_vote_id): messages.add_message( request, messages.INFO, "New position on {candidate_name} saved.".format( candidate_name=candidate_campaign_on_stage.display_candidate_name())) elif positive_value_exists(contest_measure_we_vote_id): messages.add_message( request, messages.INFO, "New position on {measure_title} saved.".format( measure_title=contest_measure_on_stage.measure_title)) go_back_to_add_new = True except Exception as e: pass # If the position was saved, then update the voter_guide entry if success: voter_guide_manager = VoterGuideManager() results = voter_guide_manager.update_or_create_organization_voter_guide_by_election_id( organization_on_stage.we_vote_id, google_civic_election_id) # if results['success']: if go_back_to_add_new: return HttpResponseRedirect( reverse('organization:organization_position_new', args=(organization_on_stage.id,)) + "?google_civic_election_id=" + str(google_civic_election_id)) else: return HttpResponseRedirect( reverse('organization:organization_position_list', args=(organization_on_stage.id,)))