def get(self, year, wwuid_or_username):
wwuid = None
username = None
if len(wwuid_or_username.split(".")) == 1:
wwuid = wwuid_or_username
else:
username = wwuid_or_username
# check if we're looking at current photos or not
if year == self.application.options.current_year:
if wwuid:
profile = mask.query_by_wwuid(mask_model.Profile, wwuid)
else:
profile = mask.people_db.query(mask_model.Profile).filter_by(
username=str(username)).all()
else:
if wwuid:
profile = archive.archive_db.query(
archive_model.get_archive_model(year)).filter_by(
wwuid=str(wwuid)).all()
else:
profile = archive.archive_db.query(archive_model.get_archive_model(year))\
.filter_by(username=str(username)).all()
if len(profile) == 0:
self.write({'error': 'no profile found'})
elif len(profile) > 1:
self.write({'error': 'too many profiles found'})
else:
# now we've got just one profile, return the photo field attached to a known photo URI
profile = profile[0]
self.redirect("https://aswwu.com/media/img-sm/" +
str(profile.photo))
def get(self, wwuid):
user = self.current_user
if user.wwuid == wwuid or 'volunteer' in user.roles:
volunteer = alchemy.query_by_wwuid(volunteer_model.Volunteer, wwuid)
if len(volunteer) == 0:
volunteer = volunteer_model.Volunteer(wwuid=user.wwuid)
volunteer = alchemy.add_or_update(volunteer)
else:
volunteer = volunteer[0]
self.write(volunteer.to_json())
else:
self.write({'error': 'insufficient permissions'})
def post(self, election_id):
# get current user
user = self.current_user
# load request body
body = self.request.body.decode('utf-8')
body_json = json.loads(body)
# validate parameters
required_parameters = ('election', 'position', 'student_id', 'vote')
elections_validator.validate_parameters(body_json, required_parameters)
# get student username from student ID
voter = mask_alchemy.query_by_wwuid(mask_model.User, body_json['student_id'])
if voter == list():
raise exceptions.NotFound404Exception('user with specified student ID not found')
voter = voter[0]
# build proper vote from ballot data and validate it
body_json['election'] = str(election_id)
body_json['username'] = str(voter.username)
body_json['manual_entry'] = str(user.username)
elections_validator.validate_ballot(body_json)
# check for too many votes
specified_election = elections_alchemy.query_election(election_id=body_json['election'])
specified_position = elections_alchemy.query_position(position_id=body_json['position'])
if len(elections_alchemy.query_vote(election_id=specified_election[0].id,
position_id=specified_position[0].id,
username=str(voter.username))) >= specified_election[0].max_votes:
raise exceptions.Forbidden403Exception(
'this user has already cast {} vote/s'.format(str(specified_election[0].max_votes))
)
# create new vote
vote = elections_model.Vote()
for parameter in required_parameters:
if parameter != 'student_id':
setattr(vote, parameter, body_json[parameter])
setattr(vote, 'username', str(voter.username))
setattr(vote, 'manual_entry', str(user.username))
elections_alchemy.add_or_update(vote)
# response
self.set_status(201)
self.write(vote.serialize_ballot())
def __init__(self, wwuid):
self.wwuid = wwuid
profile = mask.query_by_wwuid(mask_model.Profile, wwuid)
user = mask.query_user(wwuid)
if len(profile) == 0:
old_profile = archive.archive_db.query(archives.get_archive_model(get_last_year())).\
filter_by(wwuid=str(wwuid)).all()
new_profile = mask_model.Profile(wwuid=str(wwuid),
username=user.username,
full_name=user.full_name)
if len(old_profile) == 1:
import_profile(new_profile, old_profile[0].export_info())
profile = mask.add_or_update(new_profile)
else:
profile = profile[0]
self.username = user.username
self.full_name = profile.full_name
self.photo = profile.photo
if user.roles:
self.roles = user.roles.split(',')
else:
self.roles = []
self.status = user.status
def post(self):
user = self.current_user
# check permissions
if 'volunteer' not in user.roles:
self.write({'error': 'insufficient permissions'})
else:
cmd = self.get_argument('cmd', None)
logger.debug(cmd)
if cmd == 'set_role':
# let volunteer admins grant permissions for other volutneer admins
username = self.get_argument('username', '').replace(' ', '.').lower()
# .ilike is for case insesitive.
fuser = alchemy.people_db.query(mask_model.User).filter(mask_model.User.username.ilike(username)).all()
if not fuser:
self.write({'error': 'user does not exist'})
else:
fuser = fuser[0]
if fuser.roles is None:
fuser.roles = ''
roles = fuser.roles.split(',')
roles.append('volunteer')
roles = set(roles)
fuser.roles = ','.join(roles)
alchemy.add_or_update(fuser)
self.write({'response': 'success'})
elif cmd == 'search' or cmd == 'viewPrintOut':
# searcheth away!
volunteers = alchemy.people_db.query(volunteer_model.Volunteer)
if self.get_argument('campus_ministries', '') == 'on':
volunteers = volunteers.filter_by(campus_ministries=True)
if self.get_argument('student_missions', '') == 'on':
volunteers = volunteers.filter_by(student_missions=True)
if self.get_argument('aswwu', '') == 'on':
volunteers = volunteers.filter_by(aswwu=True)
if self.get_argument('circle_church', '') == 'on':
volunteers = volunteers.filter_by(circle_church=True)
if self.get_argument('university_church', '') == 'on':
volunteers = volunteers.filter_by(university_church=True)
if self.get_argument('buddy_program', '') == 'on':
volunteers = volunteers.filter_by(buddy_program=True)
if self.get_argument('assist', '') == 'on':
volunteers = volunteers.filter_by(assist=True)
if self.get_argument('lead', '') == 'on':
volunteers = volunteers.filter_by(lead=True)
if self.get_argument('audio_slash_visual', '') == 'on':
volunteers = volunteers.filter_by(audio_slash_visual=True)
if self.get_argument('health_promotion', '') == 'on':
volunteers = volunteers.filter_by(health_promotion=True)
if self.get_argument('construction_experience', '') == 'on':
volunteers = volunteers.filter_by(construction_experience=True)
if self.get_argument('outdoor_slash_camping', '') == 'on':
volunteers = volunteers.filter_by(outdoor_slash_camping=True)
if self.get_argument('concert_assistance', '') == 'on':
volunteers = volunteers.filter_by(concert_assistance=True)
if self.get_argument('event_set_up', '') == 'on':
volunteers = volunteers.filter_by(event_set_up=True)
if self.get_argument('children_ministries', '') == 'on':
volunteers = volunteers.filter_by(children_ministries=True)
if self.get_argument('children_story', '') == 'on':
volunteers = volunteers.filter_by(children_story=True)
if self.get_argument('art_poetry_slash_painting_slash_sculpting', '') == 'on':
volunteers = volunteers.filter_by(art_poetry_slash_painting_slash_sculpting=True)
if self.get_argument('organizing_events', '') == 'on':
volunteers = volunteers.filter_by(organizing_events=True)
if self.get_argument('organizing_worship_opportunities', '') == 'on':
volunteers = volunteers.filter_by(organizing_worship_opportunities=True)
if self.get_argument('organizing_community_outreach', '') == 'on':
volunteers = volunteers.filter_by(organizing_community_outreach=True)
if self.get_argument('bible_study', '') == 'on':
volunteers = volunteers.filter_by(bible_study=True)
if self.get_argument('wycliffe_bible_translator_representative', '') == 'on':
volunteers = volunteers.filter_by(wycliffe_bible_translator_representative=True)
if self.get_argument('food_preparation', '') == 'on':
volunteers = volunteers.filter_by(food_preparation=True)
if self.get_argument('graphic_design', '') == 'on':
volunteers = volunteers.filter_by(graphic_design=True)
if self.get_argument('poems_slash_spoken_word', '') == 'on':
volunteers = volunteers.filter_by(poems_slash_spoken_word=True)
if self.get_argument('prayer_team_slash_prayer_house', '') == 'on':
volunteers = volunteers.filter_by(prayer_team_slash_prayer_house=True)
if self.get_argument('dorm_encouragement_and_assisting_chaplains', '') == 'on':
volunteers = volunteers.filter_by(dorm_encouragement_and_assisting_chaplains=True)
if self.get_argument('scripture_reading', '') == 'on':
volunteers = volunteers.filter_by(scripture_reading=True)
if self.get_argument('speaking', '') == 'on':
volunteers = volunteers.filter_by(speaking=True)
if self.get_argument('videography', '') == 'on':
volunteers = volunteers.filter_by(videography=True)
if self.get_argument('drama', '') == 'on':
volunteers = volunteers.filter_by(drama=True)
if self.get_argument('public_school_outreach', '') == 'on':
volunteers = volunteers.filter_by(public_school_outreach=True)
if self.get_argument('retirement_slash_nursing_home_outreach', '') == 'on':
volunteers = volunteers.filter_by(retirement_slash_nursing_home_outreach=True)
if self.get_argument('helping_the_homeless_slash_disadvantaged', '') == 'on':
volunteers = volunteers.filter_by(helping_the_homeless_slash_disadvantaged=True)
if self.get_argument('working_with_youth', '') == 'on':
volunteers = volunteers.filter_by(working_with_youth=True)
if self.get_argument('working_with_children', '') == 'on':
volunteers = volunteers.filter_by(working_with_children=True)
if self.get_argument('greeting', '') == 'on':
volunteers = volunteers.filter_by(greeting=True)
if self.get_argument('shofar_for_vespers', '') == 'on':
volunteers = volunteers.filter_by(shofar_for_vespers=True)
if self.get_argument('music', '') != '':
volunteers = volunteers.filter(
volunteer_model.Volunteer.music.ilike('%'+str(self.get_argument('music', ''))+'%')
)
if self.get_argument('join_small_groups', '') == 'on':
volunteers = volunteers.filter_by(join_small_groups=True)
if self.get_argument('lead_small_groups', '') == 'on':
volunteers = volunteers.filter_by(lead_small_groups=True)
if self.get_argument('can_transport_things', '') == 'on':
volunteers = volunteers.filter_by(can_transport_things=True)
if self.get_argument('languages', '') != '':
volunteers = volunteers.filter(
volunteer_model.Volunteer.languages.ilike('%'+str(self.get_argument('languages', ''))+'%')
)
if self.get_argument('berean_fellowship', '') != '':
volunteers = volunteers.filter_by(berean_fellowship=True)
if self.get_argument('aswwu_video_extra', '') != '':
volunteers = volunteers.filter_by(aswwu_video_extra=True)
if self.get_argument('global_service_food_fair', '') != '':
volunteers = volunteers.filter_by(global_service_food_fair=True)
if self.get_argument('wants_to_be_involved', '') == 'on':
volunteers = volunteers.filter_by(wants_to_be_involved=True)
# vusers = [{'profile': query_by_wwuid(Profile, v.wwuid)[0], 'volunteer_data': v} for v in volunteers]
vusers = []
for v in volunteers:
vol_result = alchemy.query_by_wwuid(mask_model.Profile, v.wwuid)
if len(vol_result) > 0:
vusers.append({'profile': vol_result[0], 'volunteer_data': v})
# should we return the results as JSON
if cmd == 'search':
self.write({'results': [{'full_name': v['profile'].full_name, 'email': v['profile'].email,
'photo': v['profile'].photo,
'username': v['profile'].username} for v in vusers]})
# or as a full fledged webpage
else:
logger.debug(user)
self.write('<table border="1"><tr>'
'<th>Photo</th><th>Name</th>'
'<th>Class Standing</th><th>Major(s)</th>'
'<th>Email</th><th>Phone</th>'
'<th>Volunteer Data</th></tr>')
for v in vusers:
self.write('<tr><td>' + ('<img src="https://aswwu.com/media/img-xs/'
+ str(v['profile'].photo)+'">'
if str(v['profile'].photo).find(str(v['profile'].wwuid)) > -1 else '')
+ '</td><td>' + str(v['profile'].full_name) + '</td>''<td>'
+ str(v['profile'].class_standing) + '</td><td>' + str(v['profile'].majors)
+ '</td><td>' + str(v['profile'].email) + '</td>''<td>' + str(v['profile'].phone)
+ '</td><td>' + str(v['volunteer_data'].only_true()) + '</td></tr>')
self.write('</table>')
def post(self):
user = self.current_user
volunteer = alchemy.query_by_wwuid(volunteer_model.Volunteer, user.wwuid)[0]
volunteer.campus_ministries = (True if self.get_argument('campus_ministries', 0) == '1' else False)
volunteer.student_missions = (True if self.get_argument('student_missions', 0) == '1' else False)
volunteer.aswwu = (True if self.get_argument('aswwu', 0) == '1' else False)
volunteer.circle_church = (True if self.get_argument('circle_church', 0) == '1' else False)
volunteer.university_church = (True if self.get_argument('university_church', 0) == '1' else False)
volunteer.buddy_program = (True if self.get_argument('buddy_program', 0) == '1' else False)
volunteer.assist = (True if self.get_argument('assist', 0) == '1' else False)
volunteer.lead = (True if self.get_argument('lead', 0) == '1' else False)
volunteer.audio_slash_visual = (True if self.get_argument('audio_slash_visual', 0) == '1' else False)
volunteer.health_promotion = (True if self.get_argument('health_promotion', 0) == '1' else False)
volunteer.construction_experience = (True if self.get_argument('construction_experience', 0) == '1' else False)
volunteer.outdoor_slash_camping = (True if self.get_argument('outdoor_slash_camping', 0) == '1' else False)
volunteer.concert_assistance = (True if self.get_argument('concert_assistance', 0) == '1' else False)
volunteer.event_set_up = (True if self.get_argument('event_set_up', 0) == '1' else False)
volunteer.children_ministries = (True if self.get_argument('children_ministries', 0) == '1' else False)
volunteer.children_story = (True if self.get_argument('children_story', 0) == '1' else False)
volunteer.art_poetry_slash_painting_slash_sculpting = \
(True if self.get_argument('art_poetry_slash_painting_slash_sculpting', 0) == '1' else False)
volunteer.organizing_events = (True if self.get_argument('organizing_events', 0) == '1' else False)
volunteer.organizing_worship_opportunities = \
(True if self.get_argument('organizing_worship_opportunities', 0) == '1' else False)
volunteer.organizing_community_outreach = \
(True if self.get_argument('organizing_community_outreach', 0) == '1' else False)
volunteer.bible_study = (True if self.get_argument('bible_study', 0) == '1' else False)
volunteer.wycliffe_bible_translator_representative = \
(True if self.get_argument('wycliffe_bible_translator_representative', 0) == '1' else False)
volunteer.food_preparation = (True if self.get_argument('food_preparation', 0) == '1' else False)
volunteer.graphic_design = (True if self.get_argument('graphic_design', 0) == '1' else False)
volunteer.poems_slash_spoken_word = (True if self.get_argument('poems_slash_spoken_word', 0) == '1' else False)
volunteer.prayer_team_slash_prayer_house = \
(True if self.get_argument('prayer_team_slash_prayer_house', 0) == '1' else False)
volunteer.dorm_encouragement_and_assisting_chaplains = \
(True if self.get_argument('dorm_encouragement_and_assisting_chaplains', 0) == '1' else False)
volunteer.scripture_reading = (True if self.get_argument('scripture_reading', 0) == '1' else False)
volunteer.speaking = (True if self.get_argument('speaking', 0) == '1' else False)
volunteer.videography = (True if self.get_argument('videography', 0) == '1' else False)
volunteer.drama = (True if self.get_argument('drama', 0) == '1' else False)
volunteer.public_school_outreach = (True if self.get_argument('public_school_outreach', 0) == '1' else False)
volunteer.retirement_slash_nursing_home_outreach = \
(True if self.get_argument('retirement_slash_nursing_home_outreach', 0) == '1' else False)
volunteer.helping_the_homeless_slash_disadvantaged = \
(True if self.get_argument('helping_the_homeless_slash_disadvantaged', 0) == '1' else False)
volunteer.working_with_youth = (True if self.get_argument('working_with_youth', 0) == '1' else False)
volunteer.working_with_children = (True if self.get_argument('working_with_children', 0) == '1' else False)
volunteer.greeting = (True if self.get_argument('greeting', 0) == '1' else False)
volunteer.shofar_for_vespers = (True if self.get_argument('shofar_for_vespers', 0) == '1' else False)
volunteer.music = self.get_argument('music', '')
volunteer.join_small_groups = (True if self.get_argument('join_small_groups', 0) == '1' else False)
volunteer.lead_small_groups = (True if self.get_argument('lead_small_groups', 0) == '1' else False)
volunteer.can_transport_things = (True if self.get_argument('can_transport_things', 0) == '1' else False)
volunteer.languages = self.get_argument('languages', '')
volunteer.berean_fellowship = self.get_argument('berean_fellowship', '')
volunteer.aswwu_video_extra = self.get_argument('aswwu_video_extra', '')
volunteer.global_service_food_fair = self.get_argument('global_service_food_fair', '')
volunteer.wants_to_be_involved = (True if self.get_argument('wants_to_be_involved', 0) == '1' else False)
logger.debug(volunteer.only_true())
alchemy.add_or_update(volunteer)
self.write(json.dumps('success'))