def edit(meeting_id, person_id=None): meeting = sugar.get_object_or_404(models.Meeting, id=meeting_id) if person_id is None: person = models.Person() person_meeting = None template = 'participant/edit/create.html' subject = 'add-participant' event_form = EventCitesForm(meeting_model=meeting) person_data_as_attributes = None else: person = sugar.get_person_or_404(meeting_id, person_id) person_meeting = sugar.get_object_or_404(models.PersonMeeting, person=person_id, meeting=meeting_id) event_form = EventCitesForm(meeting_model=meeting, person=person) template = 'participant/edit/cites_edit.html' subject = 'edit-participant' person_data_as_attributes = person.data_as_attributes(meeting_id) ParticipantForm = get_participant_form(meeting.data['info_type']) form = ParticipantForm(meeting=meeting, obj=person_data_as_attributes) if flask.request.method == 'POST': if form.validate(): form.save(meeting, person, person_meeting) event_form.save(person) sugar.activity(meeting_id, subject, person.name, person.id) flask.flash('Person information saved', 'success') view_url = flask.url_for('participant.view', meeting_id=meeting.id, person_id=person.id) return flask.redirect(view_url) else: flask.flash('Errors in person information', 'error') return { 'template': template, 'form': form, 'event_form': event_form, 'person': person, 'person_id': person_id, 'meeting': meeting, }
def participants(meeting_id): meeting = get_object_or_404(Meeting, id=meeting_id) fields = [R('t1.id', 'id'), R('t1.data', 'data'), R('t2.data', 'meeting_data')] persons = (Person.select(fields).join(PersonMeeting) .where(meeting=meeting_id)) events = [(i.id, i.decoded_data['description_E']) for i in meeting.get_events()] questions = [(i.id, i.decoded_data['title_E']) for i in meeting.get_questions()] ParticipantForm = get_participant_form(meeting.data['info_type']) form = ParticipantForm(meeting=meeting) columns = [ 'personal_name_title', 'personal_last_name', 'personal_first_name', 'category', 'personal_badge_name', 'personal_address', 'personal_place', 'personal_country', 'personal_phone', 'personal_cellular', 'personal_fax', 'personal_email', 'representing_country', 'representing_organization', 'personal_language', 'representing_region', ] if isinstance(form, CMSParticipantForm): columns.extend([ 'birth_date', 'nationality', 'passport_number', 'passport_expiration_date', 'functional_title', 'special_diet' ]) columns.extend([ 'meeting_flags_attended', 'meeting_flags_sponsored', 'meeting_flags_credentials', 'meeting_flags_approval', 'meeting_flags_invitation', 'meeting_flags_verified', 'meeting_flags_statute' ]) if isinstance(form, CMSParticipantForm): columns.extend(['request_funding', 'request_letter', 'funding_accepted']) header = [] for k in columns: if form._fields.get(k): header.append(str(form._fields[k].label.text)) else: header.append(k.replace('_', ' ').capitalize()) header.extend([i[1] for i in events]) header.extend([i[1] for i in questions]) rows = [] for p in persons: data = dict(p.decoded_data) category_id = p.category_id(meeting_id=meeting_id) category = get_person_category_or_None(meeting_id, category_id) data['category'] = category.get_verbose_name() data['representing_country'] = (p.representing_country and unicode(p.representing_country)) data['personal_country'] = (p.personal_country and unicode(p.personal_country)) data['representing_region'] = p.region data['personal_language'] = p.language() data['meeting_flags_attended'] = p.meeting_data.get( 'meeting_flags_attended') and '*' data['meeting_flags_sponsored'] = p.meeting_data.get( 'meeting_flags_sponsored') and '*' data['meeting_flags_credentials'] = p.meeting_data.get( 'meeting_flags_credentials') and '*' data['meeting_flags_approval'] = p.meeting_data.get( 'meeting_flags_approval') and '*' data['meeting_flags_invitation'] = p.meeting_data.get( 'meeting_flags_invitation') and '*' data['meeting_flags_verified'] = p.meeting_data.get( 'meeting_flags_verified') and '*' data['meeting_flags_statute'] = p.meeting_data.get( 'meeting_flags_statute') and '*' data['personal_fee'] = p.meeting_data.get( 'personal_fee') and '*' if 'request_funding' in columns: data['request_funding'] = p.meeting_data.get( 'request_funding') and '*' if 'funding_accepted' in columns: data['funding_accepted'] = p.meeting_data.get( 'funding_accepted') and '*' if 'request_letter' in columns: data['request_letter'] = p.meeting_data.get( 'request_letter') and '*' for e in events: if (PersonEvent.select().where(person=p.id, event=e[0]) .count() > 0): data[e[1]] = '*' for q in questions: if (PersonQuestion.select().where(person=p.id, question=q[0]) .count() > 0): data[q[1]] = '*' for key in data.keys(): if key in EXCLUDE_PARTICIPANT_FIELDS: data.pop(key, None) rows.append([data.get(k) or '' for k in columns] + [data.get(i[1]) or '' for i in events] + [data.get(i[1]) or '' for i in questions]) return Response( generate_excel(header, rows), mimetype='application/vnd.ms-excel', headers={'Content-Disposition': 'attachment; filename=%s.xls' % 'registration'})