def _process(self): event_principal_query = (EventPrincipal.query.with_parent(self.event) .filter(EventPrincipal.type == PrincipalType.email, EventPrincipal.has_management_role('submit'))) contrib_principal_query = (ContributionPrincipal.find(Contribution.event == self.event, ContributionPrincipal.type == PrincipalType.email, ContributionPrincipal.has_management_role('submit')) .join(Contribution) .options(contains_eager('contribution'))) session_principal_query = (SessionPrincipal.find(Session.event == self.event, SessionPrincipal.type == PrincipalType.email, SessionPrincipal.has_management_role()) .join(Session).options(joinedload('session').joinedload('acl_entries'))) persons = self.get_persons() person_list = sorted(persons.viewvalues(), key=lambda x: x['person'].display_full_name.lower()) num_no_account = 0 for principal in itertools.chain(event_principal_query, contrib_principal_query, session_principal_query): if principal.email not in persons: continue if not persons[principal.email].get('no_account'): persons[principal.email]['roles']['no_account'] = True num_no_account += 1 return WPManagePersons.render_template('management/person_list.html', self.event, persons=person_list, num_no_account=num_no_account)
def _process(self): event_principal_query = (EventPrincipal.query.with_parent(self.event) .filter(EventPrincipal.type == PrincipalType.email, EventPrincipal.has_management_permission('submit'))) contrib_principal_query = (ContributionPrincipal.find(Contribution.event == self.event, ContributionPrincipal.type == PrincipalType.email, ContributionPrincipal.has_management_permission('submit')) .join(Contribution) .options(contains_eager('contribution'))) session_principal_query = (SessionPrincipal.find(Session.event == self.event, SessionPrincipal.type == PrincipalType.email, SessionPrincipal.has_management_permission()) .join(Session).options(joinedload('session').joinedload('acl_entries'))) persons = self.get_persons() person_list = sorted(persons.values(), key=lambda x: x['person'].display_full_name.lower()) num_no_account = 0 for principal in itertools.chain(event_principal_query, contrib_principal_query, session_principal_query): if principal.email not in persons: continue if not persons[principal.email].get('no_account'): persons[principal.email]['roles']['no_account'] = True num_no_account += 1 custom_roles = {f'custom_{r.id}': {'name': r.name, 'code': r.code, 'color': r.color} for r in self.event.roles} return WPManagePersons.render_template('management/person_list.html', self.event, persons=person_list, num_no_account=num_no_account, builtin_roles=BUILTIN_ROLES, custom_roles=custom_roles)
def _associate_users_by_email(self, event): # link objects to users by email where possible # event principals emails = [p.email for p in EventPrincipal.query.with_parent(event).filter_by(type=PrincipalType.email)] for user in User.query.filter(~User.is_deleted, User.all_emails.in_(emails)): EventPrincipal.replace_email_with_user(user, 'event') # session principals query = (SessionPrincipal.query .filter(SessionPrincipal.session.has(Session.event == event), SessionPrincipal.type == PrincipalType.email)) emails = [p.email for p in query] for user in User.query.filter(~User.is_deleted, User.all_emails.in_(emails)): SessionPrincipal.replace_email_with_user(user, 'session') # contribution principals query = (ContributionPrincipal.query .filter(ContributionPrincipal.contribution.has(Contribution.event == event), ContributionPrincipal.type == PrincipalType.email)) emails = [p.email for p in query] for user in User.query.filter(~User.is_deleted, User.all_emails.in_(emails)): ContributionPrincipal.replace_email_with_user(user, 'contribution') # event persons query = EventPerson.query.with_parent(event).filter(EventPerson.user_id.is_(None), EventPerson.email != '') for person in query: person.user = get_user_by_email(person.email) # registrations for registration in Registration.query.with_parent(event).filter(Registration.user_id.is_(None)): registration.user = get_user_by_email(registration.email)
def _process(self): event_principal_query = (EventPrincipal.query.with_parent(self.event_new) .filter(EventPrincipal.type == PrincipalType.email, EventPrincipal.has_management_role('submit'))) contrib_principal_query = (ContributionPrincipal.find(Contribution.event_new == self.event_new, ContributionPrincipal.type == PrincipalType.email, ContributionPrincipal.has_management_role('submit')) .join(Contribution) .options(contains_eager('contribution'))) session_principal_query = (SessionPrincipal.find(Session.event_new == self.event_new, SessionPrincipal.type == PrincipalType.email, SessionPrincipal.has_management_role()) .join(Session).options(joinedload('session').joinedload('acl_entries'))) persons = self.get_persons() person_list = sorted(persons.viewvalues(), key=lambda x: x['person'].get_full_name(last_name_first=True).lower()) num_no_account = 0 for principal in itertools.chain(event_principal_query, contrib_principal_query, session_principal_query): if principal.email not in persons: continue if not persons[principal.email].get('no_account'): persons[principal.email]['roles']['no_account'] = True num_no_account += 1 return WPManagePersons.render_template('management/person_list.html', self._conf, event=self.event_new, persons=person_list, num_no_account=num_no_account)
def get_contributions_with_user_as_submitter(event, user): """Get a list of contributions in which the `user` has submission rights""" contribs = (Contribution.query.with_parent(event) .options(joinedload('acl_entries')) .filter(Contribution.acl_entries.any(ContributionPrincipal.has_management_role('submit'))) .all()) return {c for c in contribs if any(user in entry.principal for entry in iter_acl(c.acl_entries))}
def _convert_email_principals(user, **kwargs): from indico.modules.events.contributions.models.principals import ContributionPrincipal contributions = ContributionPrincipal.replace_email_with_user(user, 'contribution') if contributions: num = len(contributions) flash(ngettext("You have been granted manager/submission privileges for a contribution.", "You have been granted manager/submission privileges for {} contributions.", num).format(num), 'info')
def _query_contributions_with_user_paper_submission_rights(event, user): criteria = [ Contribution.abstract.has(Abstract.submitter_id == user.id), Contribution.acl_entries.any( db.and_(ContributionPrincipal.user == user, ContributionPrincipal.has_management_permission('submit'))) ] return Contribution.query.with_parent(event).filter(db.or_(*criteria))
def _query_contributions_with_user_as_submitter(event, user): return (Contribution.query.with_parent(event).filter( Contribution.acl_entries.any( db.and_(ContributionPrincipal.has_management_permission('submit'), ContributionPrincipal.user == user))))
def _query_contributions_with_user_as_submitter(event, user): return (Contribution.query.with_parent(event) .filter(Contribution.acl_entries.any(db.and_(ContributionPrincipal.has_management_role('submit'), ContributionPrincipal.user == user))))
def _process(self): contribution_strategy = joinedload('contribution_links') contribution_strategy.joinedload('contribution') contribution_strategy.joinedload('person').joinedload('user') subcontribution_strategy = joinedload('subcontribution_links') subcontribution_strategy.joinedload('subcontribution') subcontribution_strategy.joinedload('person').joinedload('user') session_block_strategy = joinedload('session_block_links') session_block_strategy.joinedload('session_block') session_block_strategy.joinedload('person').joinedload('user') event_strategy = joinedload('event_links') event_strategy.joinedload('person').joinedload('user') event_persons_query = (self.event_new.persons.options(event_strategy, contribution_strategy, subcontribution_strategy, session_block_strategy) .all()) persons = defaultdict(lambda: {'session_blocks': defaultdict(dict), 'contributions': defaultdict(dict), 'subcontributions': defaultdict(dict), 'roles': defaultdict(dict)}) event_principal_query = (EventPrincipal.query.with_parent(self.event_new) .filter(EventPrincipal.type == PrincipalType.email, EventPrincipal.has_management_role('submit'))) contrib_principal_query = (ContributionPrincipal.find(Contribution.event_new == self.event_new, ContributionPrincipal.type == PrincipalType.email, ContributionPrincipal.has_management_role('submit')) .join(Contribution) .options(contains_eager('contribution'))) session_principal_query = (SessionPrincipal.find(Session.event_new == self.event_new, SessionPrincipal.type == PrincipalType.email, SessionPrincipal.has_management_role()) .join(Session).options(joinedload('session').joinedload('acl_entries'))) chairpersons = {link.person for link in self.event_new.person_links} for event_person in event_persons_query: data = persons[event_person.email or event_person.id] data['person'] = event_person data['roles']['chairperson'] = event_person in chairpersons for person_link in event_person.session_block_links: if person_link.session_block.session.is_deleted: continue data['session_blocks'][person_link.session_block_id] = {'title': person_link.session_block.full_title} data['roles']['convener'] = True for person_link in event_person.contribution_links: if not person_link.is_speaker: continue contrib = person_link.contribution if contrib.is_deleted: continue url = url_for('contributions.manage_contributions', self.event_new, selected=contrib.friendly_id) data['contributions'][contrib.id] = {'title': contrib.title, 'url': url} data['roles']['speaker'] = True for person_link in event_person.subcontribution_links: subcontrib = person_link.subcontribution contrib = subcontrib.contribution if subcontrib.is_deleted or contrib.is_deleted: continue url = url_for('contributions.manage_contributions', self.event_new, selected=contrib.friendly_id) data['subcontributions'][subcontrib.id] = {'title': '{} ({})'.format(contrib.title, subcontrib.title), 'url': url} data['roles']['speaker'] = True # Some EventPersons will have no roles since they were connected to deleted things persons = {email: data for email, data in persons.viewitems() if any(data['roles'].viewvalues())} num_no_account = 0 for principal in itertools.chain(event_principal_query, contrib_principal_query, session_principal_query): if principal.email not in persons: continue if not persons[principal.email].get('no_account'): persons[principal.email]['roles']['no_account'] = True num_no_account += 1 person_list = sorted(persons.viewvalues(), key=lambda x: x['person'].get_full_name(last_name_first=True).lower()) return WPManagePersons.render_template('management/person_list.html', self._conf, event=self.event_new, persons=person_list, num_no_account=num_no_account)
def _merge_users(target, source, **kwargs): from indico.modules.events.contributions.models.principals import ContributionPrincipal ContributionPrincipal.merge_users(target, source, 'contribution')