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 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 _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')
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')
