def get(self): email = request.args.get('email') LOGGER.debug("Resending verification email to: {}".format(email)) user = user_repository.get_by_email(email, g.organisation.id) if not user: LOGGER.debug( "User not found for email: {} in organisation: {}".format( email, g.organisation.name)) return USER_NOT_FOUND if user.verify_token is None: user.verify_token = make_code() try: db.session.commit() except IntegrityError: LOGGER.error("Adding verify token for {} failed. ".format(email)) return ADD_VERIFY_TOKEN_FAILED email_user('verify-email', template_parameters=dict(system=g.organisation.system_name, organisation=g.organisation.name, host=misc.get_baobab_host(), token=user.verify_token), user=user, subject_parameters=dict(system=g.organisation.system_name)) LOGGER.debug("Resent email verification to: {}".format(email)) return {}, 201
def post(self): req_parser = reqparse.RequestParser() req_parser.add_argument('email', type=str, required=True) args = req_parser.parse_args() LOGGER.debug( "Requesting password reset for email {} and organisation {}". format(args['email'], g.organisation.name)) user = user_repository.get_by_email(args['email'], g.organisation.id) if not user: LOGGER.debug( "No user found for email {} and organisation {}".format( args['email'], g.organisation.name)) return USER_NOT_FOUND password_reset = PasswordReset(user=user) db.session.add(password_reset) db.session.commit() email_user( 'password-reset', template_parameters=dict(system=g.organisation.system_name, organisation=g.organisation.name, host=misc.get_baobab_host(), token=password_reset.code), subject_parameters=dict(system_name=g.organisation.system_name), user=user) return {}, 201
def post(self): args = self.req_parser.parse_args() event_id = args['event_id'] user_id = g.current_user['id'] event = db.session.query(Event).get(event_id) if not event: return EVENT_NOT_FOUND current_user = user_repository.get_by_id(user_id) if not current_user.is_event_admin(event_id): return FORBIDDEN users = user_repository.get_all_without_responses() for user in users: event_name = event.get_name('en') organisation_name = event.organisation.name system_name = event.organisation.system_name deadline = event.application_close.strftime('%A %-d %B %Y') email_user('application-not-started', template_parameters=dict( event=event_name, organisation_name=organisation_name, system_name=system_name, deadline=deadline), event=event, user=user) return {'not_started_responses': len(users)}, 201
def send_confirmation(self, user, questions, answers, confirmed, event): if answers is None: LOGGER.warn( 'Found no answers associated with response with id {response_id}' .format(response_id=user.id)) if questions is None: LOGGER.warn( 'Found no questions associated with application form with id {form_id}' .format(form_id=user.id)) try: # Building the summary, where the summary is a dictionary whose key is the question headline, and the value # is the relevant answer summary = "" for answer in answers: for question in questions: if answer.registration_question_id == question.id: summary += "Question:" + question.headline + "\nAnswer:" + _get_answer_value( answer, question) + "\n" emailer.email_user('registration-with-confirmation' if confirmed else 'registration-pending-confirmation', template_parameters=dict(summary=summary), event=event, user=user) except Exception as e: LOGGER.error( 'Could not send confirmation email for response with id : {response_id}' .format(response_id=user.id))
def delete(self): args = self.del_req_parser.parse_args() current_user_id = g.current_user['id'] response = response_repository.get_by_id(args['id']) if not response: return errors.RESPONSE_NOT_FOUND if response.user_id != current_user_id: return errors.UNAUTHORIZED response.withdraw() response_repository.save(response) try: user = user_repository.get_by_id(current_user_id) event = response.application_form.event organisation = event.organisation emailer.email_user( 'withdrawal', template_parameters=dict( organisation_name=organisation.name ), event=event, user=user ) except: LOGGER.error('Failed to send withdrawal confirmation email for response with ID : {id}, but the response was withdrawn succesfully'.format(id=args['id'])) return {}, 204
def post(self, invitedGuest=False): args = self.req_parser.parse_args() email = args['email'] firstname = args['firstname'] lastname = args['lastname'] user_title = args['user_title'] policy_agreed = args['policy_agreed'] user_primaryLanguage = args['language'] if (invitedGuest): password = self.randomPassword() else: password = args['password'] if (password is None): return MISSING_PASSWORD if not policy_agreed: return POLICY_NOT_AGREED LOGGER.info("Registering email: {}".format(email)) user = AppUser(email=email, firstname=firstname, lastname=lastname, user_title=user_title, password=password, organisation_id=g.organisation.id) user.user_primaryLanguage = user_primaryLanguage db.session.add(user) try: db.session.commit() except IntegrityError: LOGGER.error("email: {} already in use".format(email)) return EMAIL_IN_USE if (not invitedGuest): email_user( 'verify-email', template_parameters=dict(system=g.organisation.system_name, organisation=g.organisation.name, host=misc.get_baobab_host(), token=user.verify_token), user=user, subject_parameters=dict(system=g.organisation.system_name)) LOGGER.debug("Sent verification email to {}".format(user.email)) else: user.verified_email = True try: db.session.commit() except IntegrityError: LOGGER.error("Unable to verify email: {}".format(email)) return VERIFY_EMAIL_INVITED_GUEST return user_info(user, []), 201
def post(self): args = self.req_parser.parse_args() user_id = args['user_id'] event_id = args['event_id'] email_template = args['email_template'] offer_date = datetime.strptime((args['offer_date']), '%Y-%m-%dT%H:%M:%S.%fZ') expiry_date = datetime.strptime((args['expiry_date']), '%Y-%m-%dT%H:%M:%S.%fZ') payment_required = args['payment_required'] travel_award = args['travel_award'] accommodation_award = args['accommodation_award'] user = db.session.query(AppUser).filter(AppUser.id == user_id).first() event = db.session.query(Event).filter(Event.id == event_id).first() event_name = event.get_name('en') event_email_from = event.email_from existing_offer = db.session.query(Offer).filter(Offer.user_id == user_id, Offer.event_id == event_id).first() if existing_offer: return errors.DUPLICATE_OFFER existing_outcome = outcome_repository.get_latest_by_user_for_event(user_id, event_id) if existing_outcome: if existing_outcome.status == Status.REJECTED: return errors.CANDIDATE_REJECTED existing_outcome.reset_latest() new_outcome = Outcome( event_id, user_id, Status.ACCEPTED, g.current_user['id'] ) outcome_repository.add(new_outcome) offer_entity = Offer( user_id=user_id, event_id=event_id, offer_date=offer_date, expiry_date=expiry_date, payment_required=payment_required, travel_award=travel_award, accommodation_award=accommodation_award ) db.session.add(offer_entity) db.session.commit() email_user( 'offer', template_parameters=dict( host=misc.get_baobab_host(), expiry_date=offer_entity.expiry_date.strftime("%Y-%m-%d"), event_email_from=event_email_from ), event=event, user=user) return offer_info(offer_entity), 201
def _send_registration_confirmation_mail(user, event): try: emailer.email_user('registration-confirmed', event=event, user=user) return True except Exception as e: LOGGER.error('Error occured while sending email to {}: {}'.format( user.email, e)) return False
def post(self, send_email=True): args = self.req_parser.parse_args() event_id = args['event_id'] email = args['email'] role = args['role'] user = user_repository.get_by_email(email, g.organisation.id) if not user: return USER_NOT_FOUND event = event_repository.get_by_id(event_id) if not event: return EVENT_NOT_FOUND existingInvitedGuest = db.session.query(InvitedGuest).filter( InvitedGuest.event_id == event_id).filter(InvitedGuest.user_id == user.id).first() if existingInvitedGuest: return INVITED_GUEST_FOR_EVENT_EXISTS invitedGuest = InvitedGuest( event_id=event_id, user_id=user.id, role=role ) db.session.add(invitedGuest) try: db.session.commit() except IntegrityError: LOGGER.error( "Failed to add invited guest: {}".format(email)) return ADD_INVITED_GUEST_FAILED if send_email: try: email_user( 'guest-invitation-with-registration' if event.is_registration_open else 'guest-invitation', template_parameters=dict( role=role, system_name=g.organisation.system_name, host=misc.get_baobab_host(), event_key=event.key ), event=event, user=user) except Exception as e: LOGGER.error('Failed to send email to invited guest with user Id {}, due to {}'.format(user.id, e)) return INVITED_GUEST_EMAIL_FAILED return invitedGuest_info(invitedGuest, user), 201
def post(self): args = self.post_req_parser.parse_args() response_id = args['response_id'] title = args['title'] firstname = args['firstname'] lastname = args['lastname'] relation = args['relation'] email = args['email'] user = user_repository.get_by_id(g.current_user['id']) if not user: return USER_NOT_FOUND event = event_repository.get_event_by_response_id(response_id) if not event: return EVENT_NOT_FOUND response = response_repository.get_by_id(response_id) if not response: return RESPONSE_NOT_FOUND reference_request = ReferenceRequest(response_id=response_id, title=title, firstname=firstname, lastname=lastname, relation=relation, email=email) reference_request_repository.create(reference_request) link = "{host}/reference/{token}".format(host=misc.get_baobab_host(), token=reference_request.token) try: candidate, candidate_firstname, nominator = _get_candidate_nominator( response) except ValueError as e: LOGGER.error(e) return BAD_CONFIGURATION email_user('reference-request-self-nomination' if nominator is None else 'reference-request', template_parameters=dict( candidate=candidate, candidate_firstname=candidate_firstname, nominator=nominator, event_url=event.url, application_close_date=event.application_close, link=link), event=event, user=user) reference_request.set_email_sent(datetime.now()) reference_request_repository.add(reference_request) return reference_request, 201
def post(self, event_id): req_parser = reqparse.RequestParser() req_parser.add_argument('user_id', type=int, required=True) req_parser.add_argument('outcome', type=str, required=True) args = req_parser.parse_args() event = event_repository.get_by_id(event_id) if not event: return errors.EVENT_NOT_FOUND user = user_repository.get_by_id(args['user_id']) if not user: return errors.USER_NOT_FOUND try: status = Status[args['outcome']] except KeyError: return errors.OUTCOME_STATUS_NOT_VALID try: # Set existing outcomes to no longer be the latest outcome existing_outcomes = outcome_repository.get_all_by_user_for_event(args['user_id'], event_id) for existing_outcome in existing_outcomes: existing_outcome.reset_latest() # Add new outcome outcome = Outcome( event_id, args['user_id'], status, g.current_user['id']) outcome_repository.add(outcome) db.session.commit() if status != Status.ACCEPTED: # Email will be sent with offer for accepted candidates email_user( 'outcome-rejected' if status == Status.REJECTED else 'outcome-waitlist', template_parameters=dict( host=misc.get_baobab_host() ), event=event, user=user, ) return outcome, 201 except SQLAlchemyError as e: LOGGER.error("Database error encountered: {}".format(e)) return errors.DB_NOT_AVAILABLE except: LOGGER.error("Encountered unknown error: {}".format(traceback.format_exc())) return errors.DB_NOT_AVAILABLE
def test_email_no_event_english(self, send_mail_fn): """Check email to an English user with no event.""" self.seed_static_data() email_user('template1', template_parameters={'param': 'Blah'}, user=self.english_user) send_mail_fn.assert_called_with( recipient=self.english_user.email, subject='English subject no event', body_text='English template no event Blah', file_name='', file_path='')
def test_email_no_event_french(self, send_mail_fn): """Check email to an French user with no event.""" self.seed_static_data() email_user('template1', template_parameters={'param': 'bleu'}, user=self.french_user) send_mail_fn.assert_called_with( recipient=self.french_user.email, subject='Sujet français sans événement', body_text='Modèle français sans événement bleu', file_name='', file_path='')
def test_email_english_default(self, send_mail_fn): """Check email to use with unsupported language defaults to English.""" self.seed_static_data() email_user('template1', template_parameters={'param': 'Blah'}, user=self.zulu_user) send_mail_fn.assert_called_with( recipient=self.zulu_user.email, subject='English subject no event', body_text='English template no event Blah', file_name='', file_path='')
def post(self, event_id): parser = reqparse.RequestParser() parser.add_argument('response_ids', type=int, required=True, action='append') parser.add_argument('reviewer_email', type=str, required=True) args = parser.parse_args() response_ids = args['response_ids'] reviewer_email = args['reviewer_email'] filtered_response_ids = response_repository.filter_ids_to_event( response_ids, event_id) print('response_ids:', response_ids) print('filtered_response_ids:', filtered_response_ids) if set(filtered_response_ids) != set(response_ids): return FORBIDDEN event = event_repository.get_by_id(event_id) reviewer_user = user_repository.get_by_email(reviewer_email, g.organisation.id) if reviewer_user is None: return USER_NOT_FOUND if not reviewer_user.is_reviewer(event_id): _add_reviewer_role(reviewer_user.id, event_id) response_reviewers = [ ResponseReviewer(response_id, reviewer_user.id) for response_id in response_ids ] db.session.add_all(response_reviewers) db.session.commit() if len(response_ids) > 0: email_user('reviews-assigned', template_parameters=dict( num_reviews=len(response_ids), baobab_host=misc.get_baobab_host(), system_name=g.organisation.system_name, event_key=event.key), event=event, user=reviewer_user) return {}, 201
def test_files(self, send_mail_fn): """Check that file parameters are correctly passed to send_mail function.""" self.seed_static_data() email_user('template1', template_parameters={'param': 'Blah'}, user=self.english_user, file_name='myfile.pdf', file_path='/long/way/home') send_mail_fn.assert_called_with( recipient=self.english_user.email, subject='English subject no event', body_text='English template no event Blah', file_name='myfile.pdf', file_path='/long/way/home')
def send_confirmation(self, user, response): try: answers = response.answers if not answers: LOGGER.warn( 'Found no answers associated with response with id {response_id}' .format(response_id=response.id)) application_form = response.application_form if application_form is None: LOGGER.warn( 'Found no application form with id {form_id}'.format( form_id=response.application_form_id)) event = application_form.event if event is None: LOGGER.warn('Found no event id {event_id}'.format( form_id=application_form.event_id)) except: LOGGER.error( 'Could not connect to the database to retrieve response confirmation email data on response with ID : {response_id}' .format(response_id=response.id)) try: question_answer_summary = strings.build_response_email_body( answers, user.user_primaryLanguage, application_form) if event.has_specific_translation(user.user_primaryLanguage): event_description = event.get_description( user.user_primaryLanguage) else: event_description = event.get_description('en') emailer.email_user( 'confirmation-response-call' if event.event_type == EventType.CALL else 'confirmation-response', template_parameters=dict( event_description=event_description, question_answer_summary=question_answer_summary, ), event=event, user=user) except Exception as e: LOGGER.error( 'Could not send confirmation email for response with id : {response_id} due to: {e}' .format(response_id=response.id, e=e))
def post(self): args = self.post_req_parser.parse_args() user_id = g.current_user['id'] event_id = args['event_id'] reviewer_user_email = args['reviewer_user_email'] num_reviews = args['num_reviews'] event = event_repository.get_by_id(event_id) if not event: return EVENT_NOT_FOUND current_user = user_repository.get_by_id(user_id) if not current_user.is_event_admin(event_id): return FORBIDDEN reviewer_user = user_repository.get_by_email(reviewer_user_email, g.organisation.id) if reviewer_user is None: return USER_NOT_FOUND if not reviewer_user.is_reviewer(event_id): _add_reviewer_role(reviewer_user.id, event_id) config = review_configuration_repository.get_configuration_for_event( event_id) response_ids = self.get_eligible_response_ids( event_id, reviewer_user.id, num_reviews, config.num_reviews_required) response_reviewers = [ ResponseReviewer(response_id, reviewer_user.id) for response_id in response_ids ] db.session.add_all(response_reviewers) db.session.commit() if len(response_ids) > 0: email_user('reviews-assigned', template_parameters=dict( num_reviews=len(response_ids), baobab_host=misc.get_baobab_host(), system_name=g.organisation.system_name, event_key=event.key), event=event, user=reviewer_user) return {}, 201
def put(self): args = self.put_req_parser.parse_args() firstname = args['firstname'] lastname = args['lastname'] user_title = args['user_title'] email = args['email'] user_primaryLanguage = args['language'] user = db.session.query(AppUser).filter( AppUser.id == g.current_user['id']).first() if user.email != email: user.update_email(email) user.firstname = firstname user.lastname = lastname user.user_title = user_title user.user_primaryLanguage = user_primaryLanguage try: db.session.commit() except Exception as e: LOGGER.error("Exception updating user profile - {}".format(e)) return ERROR_UPDATING_USER_PROFILE if not user.verified_email: email_user( 'verify-email', template_parameters=dict( system=g.organisation.system_name, organisation=g.organisation.name, host=misc.get_baobab_host(), token=user.verify_token ), user=user, subject_parameters=dict(system=g.organisation.system_name)) LOGGER.debug("Sent re-verification email to {}".format(user.email)) roles = db.session.query(EventRole).filter( EventRole.user_id == user.id).all() return user_info(user, roles), 200
def post(self): args = self.req_parser.parse_args() user_api = UserAPI.UserAPI() user, status = user_api.post(invitedGuest=True) if status != 201: return user, status invited_guest_api = InvitedGuestAPI() invited_guest_info, status = invited_guest_api.post(send_email=False) if status == 201: event_id = invited_guest_info['event_id'] role = invited_guest_info['role'] user = user_repository.get_by_id(user['id']) event = event_repository.get_by_id(event_id) reset_code = misc.make_code() password_reset=PasswordReset(user=user) db.session.add(password_reset) db.session.commit() try: email_user( 'new-guest-registration' if event.is_registration_open else 'new-guest-no-registration', template_parameters=dict( event_key=event.key, system_name=g.organisation.system_name, host=misc.get_baobab_host(), role=role, reset_code=password_reset.code, ), event=event, user=user ) except Exception as e: LOGGER.error('Failed to send email for invited guest with user Id {} due to: {}'.format(user.id, e)) return INVITED_GUEST_EMAIL_FAILED return invited_guest_info, status
def generate(template_path, event_id, work_address, addressed_to, residential_address, passport_name, passport_no, passport_issued_by, invitation_letter_sent_at, to_date, from_date, country_of_residence, nationality, date_of_birth, email, user_title, firstname, lastname, bringing_poster, expiry_date, user): check_values(template_path, event_id, work_address, addressed_to, residential_address, passport_name, passport_no, passport_issued_by, invitation_letter_sent_at, to_date, from_date, country_of_residence, nationality, date_of_birth, email, user_title, firstname, lastname, bringing_poster, expiry_date) # Path to store the template locally of merged and unmerged template = 'app/invitationletter/template/tmp.docx' template_merged = 'app/invitationletter/template/template.docx' download_blob(bucket_name=GCP_BUCKET_NAME, source_blob_name=template_path, destination_file_name=template) if not os.path.exists(template): return errors.TEMPLATE_NOT_FOUND document = MailMerge(template) LOGGER.debug("merge-fields.... {} .".format(document.get_merge_fields())) document.merge( TITLE=user_title, FIRSTNAME=firstname, LASTNAME=lastname, WORK_ADDRESS=work_address.decode('utf-8'), ADDRESSED_TO=addressed_to.decode('utf-8'), RESIDENTIAL_ADDRESS=residential_address.decode('utf-8'), PASSPORT_NAME=passport_name.decode('utf-8'), PASSPORT_NO=passport_no.decode('utf-8'), ISSUED_BY=passport_issued_by.decode('utf-8'), EXPIRY_DATE=expiry_date, ACCOMODATION_END_DATE=to_date, ACCOMODATION_START_DATE=from_date, COUNTRY_OF_RESIDENCE=country_of_residence.decode('utf-8'), NATIONALITY=nationality, DATE_OF_BIRTH=date_of_birth, INVITATION_LETTER_SENT_AT=invitation_letter_sent_at, BRINGING_POSTER=bringing_poster ) document.write(template_merged) # Conversion template_pdf = 'app/invitationletter/letter/template.pdf' if os.path.exists(template_pdf): os.remove(template_pdf) success = pdfconvertor.convert_to(folder='app/invitationletter/letter', source=template_merged, output=template_pdf) if not success: return errors.CREATING_INVITATION_FAILED event = db.session.query(Event).get(event_id) if not event: return errors.EVENT_NOT_FOUND try: emailer.email_user( 'invitation-letter', event=event, user=user, file_name="InvitationLetter.pdf", file_path=template_pdf ) LOGGER.debug('successfully sent email...') return True except ValueError: LOGGER.debug('Did not send email...') return False return False