def mail_member_del(sender):
''' mail member del '''
tplenv = Environment(loader=FileSystemLoader('./templates/mail'))
template = tplenv.get_template('./base_member_del.html')
team_member_change_db = TeamMemberChangedDB()
awsses = AWSSES(
aws_access_key_id=setting.AWS_ID,
aws_secret_access_key=setting.AWS_KEY,
source=setting.AWS_SES_FROM)
for raw in team_member_change_db.find(
{'done.mail': {'$exists': False}, 'case': 'del'},
sort=(('create_at', 1), )):
team = Team.get(raw['pid'], raw['tid'])
user = User.get_info(uids=(raw['uid'], ))[raw['uid']]
body = template.render(
name=user['profile']['badge_name'],
team_name=team['name'], )
raw_mail = awsses.raw_mail(
to_addresses=(
dict(name=user['profile']['badge_name'], mail=user['oauth']['email']), ),
subject=f"您已被移除 {team['name']} 的組員資格！",
body=body,
)
resp = mail_member_send.apply_async(
kwargs={'raw_mail': raw_mail.as_string(), 'rid': str(raw['_id'])})
logger.info(resp)
def mail_member_waiting(sender):
''' mail member waiting '''
template = Environment(loader=FileSystemLoader(
'./templates/mail')).get_template('./base_member_waiting.html')
team_member_change_db = TeamMemberChangedDB()
awsses = AWSSES(
aws_access_key_id=setting.AWS_ID,
aws_secret_access_key=setting.AWS_KEY,
source=setting.AWS_SES_FROM)
for raw in team_member_change_db.find(
{'done.mail': {'$exists': False}, 'case': 'waiting'},
sort=(('create_at', 1), )):
team = Team.get(raw['pid'], raw['tid'])
uids = []
uids.extend(team['chiefs'])
uids.append(raw['uid'])
users = User.get_info(uids=uids)
mmt = MattermostTools(token=setting.MATTERMOST_BOT_TOKEN,
base_url=setting.MATTERMOST_BASEURL)
for uid in team['chiefs']:
body = template.render(
name=users[uid]['profile']['badge_name'],
uid=raw['uid'],
apply_name=users[raw['uid']]['profile']['badge_name'],
team_name=team['name'], pid=team['pid'], tid=team['tid'], )
raw_mail = awsses.raw_mail(
to_addresses=(dict(
name=users[uid]['profile']['badge_name'], mail=users[uid]['oauth']['email']), ),
subject=f"申請加入通知信 - {users[raw['uid']]['profile']['badge_name']}",
body=body,
)
resp = mail_member_send.apply_async(
kwargs={'raw_mail': raw_mail.as_string(), 'rid': str(raw['_id'])})
logger.info(resp)
mid = mmt.find_possible_mid(uid=uid)
if mid:
channel_info = mmt.create_a_direct_message(
users=(mid, setting.MATTERMOST_BOT_ID)).json()
resp = mmt.posts(
channel_id=channel_info['id'],
message=f"收到 **{users[raw['uid']]['profile']['badge_name']}** 申請加入 **{team['name']}**，前往 [管理組員](https://volunteer.coscup.org/team/{team['pid']}/{team['tid']}/edit_user)", # pylint: disable=line-too-long
)
logger.info(resp.json())
def mail_member_send(sender, **kwargs):
team_member_change_db = TeamMemberChangedDB()
awsses = AWSSES(aws_access_key_id=setting.AWS_ID,
aws_secret_access_key=setting.AWS_KEY,
source=setting.AWS_SES_FROM)
resp = awsses.send_raw_email(data_str=kwargs['raw_mail'])
logger.info(resp)
if resp['ResponseMetadata']['HTTPStatusCode'] != 200:
raise Exception('HTTPStatusCode not `200`, do retry')
team_member_change_db.find_one_and_update({'_id': ObjectId(kwargs['rid'])},
{'$set': {
'done.mail': True
}})
def update_members(pid: str,
tid: str,
add_uids: Optional[list[str]] = None,
del_uids: Optional[list[str]] = None,
make_record: bool = True) -> None:
''' update chiefs
:param list add_uids: add uids
:param list del_uids: del uids
:param bool make_record: make user update record
.. note:: also make user changed record
'''
teamdb = TeamDB(pid, tid)
teamdb.update_users(field='members',
add_uids=add_uids,
del_uids=del_uids)
if make_record:
TeamMemberChangedDB().make_record(pid=pid,
tid=tid,
action={
'add': add_uids,
'del': del_uids
})
def mail_member_add(sender, **kwargs):
TPLENV = Environment(loader=FileSystemLoader('./templates/mail'))
template = TPLENV.get_template('./base_member_add.html')
team_member_change_db = TeamMemberChangedDB()
awsses = AWSSES(aws_access_key_id=setting.AWS_ID,
aws_secret_access_key=setting.AWS_KEY,
source=setting.AWS_SES_FROM)
for raw in team_member_change_db.find(
{
'done.mail': {
'$exists': False
},
'case': 'add'
},
sort=(('create_at', 1), )):
team = Team.get(raw['pid'], raw['tid'])
user = User.get_info(uids=(raw['uid'], ))[raw['uid']]
body = template.render(
name=user['profile']['badge_name'],
team_name=team['name'],
pid=team['pid'],
tid=team['tid'],
)
raw_mail = awsses.raw_mail(
to_addresses=(dict(name=user['profile']['badge_name'],
mail=user['oauth']['email']), ),
subject=u'申請加入 %s 核准' % team['name'],
body=body,
)
r = mail_member_send.apply_async(kwargs={
'raw_mail': raw_mail.as_string(),
'rid': str(raw['_id'])
})
service_sync_mattermost_add_channel.apply_async(kwargs={
'pid': raw['pid'],
'uids': (raw['uid'], )
})
logger.info(r)
def team_join_to(pid, tid):
team, project, _redirect = check_the_team_and_project_are_existed(pid=pid, tid=tid)
if _redirect:
return _redirect
if g.user['account']['_id'] in team['members'] or g.user['account']['_id'] in team['chiefs']:
return redirect(url_for('team.index', pid=pid, tid=tid))
if request.method == 'GET':
is_in_wait = WaitList.is_in_wait(pid=team['pid'], tid=team['tid'], uid=g.user['account']['_id'])
return render_template('./team_join_to.html', project=project, team=team, is_in_wait=is_in_wait)
elif request.method == 'POST':
WaitList.join_to(pid=pid, tid=tid, uid=g.user['account']['_id'], note=request.form['note'].strip())
TeamMemberChangedDB().make_record(pid=pid, tid=tid, waiting_uids=(g.user['account']['_id'], ))
return redirect('/project/%s/' % pid)
def team_edit_user_api(pid, tid):
team, project, _redirect = check_the_team_and_project_are_existed(pid=pid, tid=tid)
if _redirect:
return _redirect
is_admin = (g.user['account']['_id'] in team['chiefs'] or \
g.user['account']['_id'] in team['owners'] or \
g.user['account']['_id'] in project['owners'])
if not is_admin:
return redirect('/')
if request.method == 'GET':
user = User(uid=request.args['uid']).get()
user_waitting = WaitList.list_by_team(pid=pid, tid=tid, uid=user['_id'])
if not user_waitting:
return jsonify({})
users_info = User.get_info([user['_id'], ])
user_data = {
'badge_name': users_info[user['_id']]['profile']['badge_name'],
'picture': users_info[user['_id']]['oauth']['picture'],
'uid': user['_id'],
'note': user_waitting['note'],
'wid': u'%(_id)s' % user_waitting,
}
return jsonify(user_data)
elif request.method == 'POST':
all_members = len(team['members']) + len(team['chiefs'])
if 'headcount' in team and team['headcount'] and all_members >= team['headcount']:
return jsonify({'status': 'fail', 'message': 'over headcount.'}), 406
data = request.json
w = WaitList.make_result(wid=data['wid'], pid=pid, uid=data['uid'], result=data['result'])
if w and 'result' in w:
if w['result'] == 'approval':
Team.update_members(pid=pid, tid=tid, add_uids=[data['uid'], ])
elif w['result'] == 'deny':
TeamMemberChangedDB().make_record(pid=pid, tid=tid, deny_uids=(data['uid'], ))
return jsonify({'status': 'ok'})
def make_index() -> None:
''' Make index for the collection with `index()` '''
BudgetDB().index()
ExpenseDB().index()
FormDB().index()
MailLetterDB().index()
MattermostLinkDB().index()
MattermostUsersDB().index()
OAuthDB().index()
ProjectDB(pid='').index()
SenderReceiverDB().index()
TeamDB(pid='', tid='').index()
TeamMemberChangedDB().index()
TeamMemberTagsDB().index()
TeamPlanDB().index()
TelegramDB().index()
USessionDB().index()
UsersDB().index()
WaitListDB().index()
def team_join_to(pid, tid):
''' Team join to '''
team, project, _redirect = check_the_team_and_project_are_existed(pid=pid,
tid=tid)
if _redirect:
return _redirect
if g.user['account']['_id'] in team['members'] or g.user['account'][
'_id'] in team['chiefs']:
return redirect(url_for('team.index', pid=pid, tid=tid))
if request.method == 'GET':
is_in_wait = WaitList.is_in_wait(pid=team['pid'],
tid=team['tid'],
uid=g.user['account']['_id'])
if not is_in_wait and 'public_desc' in team:
team['public_desc'] = re.sub(
'<a href="javascript:.*"', '<a href="/"',
markdown(html.escape(team['public_desc'])))
return render_template('./team_join_to.html',
project=project,
team=team,
is_in_wait=is_in_wait)
if request.method == 'POST':
WaitList.join_to(pid=pid,
tid=tid,
uid=g.user['account']['_id'],
note=request.form['note'].strip())
TeamMemberChangedDB().make_record(
pid=pid, tid=tid, action={'waiting': (g.user['account']['_id'], )})
return redirect(f'/team/{pid}/{tid}/join_to')
return '', 404
def update_members(pid,
tid,
add_uids=None,
del_uids=None,
make_record=True):
''' update chiefs
:param list add_uids: add uids
:param list del_uids: del uids
:param bool make_record: make user update record
.. note:: also make user changed record
'''
teamdb = TeamDB(pid, tid)
teamdb.update_users(field='members',
add_uids=add_uids,
del_uids=del_uids)
if make_record:
TeamMemberChangedDB().make_record(pid=pid,
tid=tid,
add_uids=add_uids,
del_uids=del_uids)
def service_sync_gsuite_memberchange(sender, **kwargs):
team_member_change_db = TeamMemberChangedDB()
sync_gsuite = None
for raw in team_member_change_db.find(
{
'done.gsuite_team': {
'$exists': False
},
'case': {
'$in': ('add', 'del')
}
},
sort=(('create_at', 1), )):
team = Team.get(raw['pid'], raw['tid'])
if 'mailling' not in team or not team['mailling']:
team_member_change_db.find_one_and_update(
{'_id': raw['_id']}, {'$set': {
'done.gsuite_team': True
}})
continue
if sync_gsuite is None:
sync_gsuite = SyncGSuite(credentialfile=setting.GSUITE_JSON,
with_subject=setting.GSUITE_ADMIN)
user = User(uid=raw['uid']).get()
if raw['case'] == 'add':
sync_gsuite.add_users_into_group(group=team['mailling'],
users=(user['mail'], ))
team_member_change_db.find_one_and_update(
{'_id': raw['_id']}, {'$set': {
'done.gsuite_team': True
}})
elif raw['case'] == 'del':
sync_gsuite.del_users_from_group(group=team['mailling'],
users=(user['mail'], ))
team_member_change_db.find_one_and_update(
{'_id': raw['_id']}, {'$set': {
'done.gsuite_team': True
}})
for raw in team_member_change_db.find(
{
'done.gsuite_staff': {
'$exists': False
},
'case': {
'$in': ('add', 'del')
}
},
sort=(('create_at', 1), )):
project = Project.get(raw['pid'])
if 'mailling_staff' not in project or not project['mailling_staff']:
team_member_change_db.find_one_and_update(
{'_id': raw['_id']}, {'$set': {
'done.gsuite_staff': True
}})
continue
if sync_gsuite is None:
sync_gsuite = SyncGSuite(credentialfile=setting.GSUITE_JSON,
with_subject=setting.GSUITE_ADMIN)
user = User(uid=raw['uid']).get()
if raw['case'] == 'add':
sync_gsuite.add_users_into_group(group=project['mailling_staff'],
users=(user['mail'], ))
team_member_change_db.find_one_and_update(
{'_id': raw['_id']}, {'$set': {
'done.gsuite_staff': True
}})
elif raw['case'] == 'del':
sync_gsuite.del_users_from_group(group=project['mailling_staff'],
users=(user['mail'], ))
team_member_change_db.find_one_and_update(
{'_id': raw['_id']}, {'$set': {
'done.gsuite_staff': True
}})
from models.formdb import FormDB
from models.mailletterdb import MailLetterDB
from models.mattermost_link_db import MattermostLinkDB
from models.mattermostdb import MattermostUsersDB
from models.oauth_db import OAuthDB
from models.projectdb import ProjectDB
from models.senderdb import SenderReceiverDB
from models.teamdb import TeamDB
from models.teamdb import TeamMemberChangedDB
from models.teamdb import TeamMemberTagsDB
from models.teamdb import TeamPlanDB
from models.users_db import UsersDB
from models.usessiondb import USessionDB
from models.waitlistdb import WaitListDB
if __name__ == '__main__':
FormDB().index()
MailLetterDB().index()
MattermostLinkDB().index()
MattermostUsersDB().index()
OAuthDB().index()
ProjectDB(pid=None).index()
SenderReceiverDB().index()
TeamDB(pid=None, tid=None).index()
TeamMemberChangedDB().index()
TeamMemberTagsDB().index()
TeamPlanDB().index()
USessionDB().index()
UsersDB().index()
WaitListDB().index()
def project_edit_create_team_api(pid):
''' Project edit create team API '''
project = Project.get(pid)
if g.user['account']['_id'] not in project['owners']:
return redirect(
url_for('project.team_page',
pid=pid,
_scheme='https',
_external=True))
if request.method == 'GET':
_team = Team.get(pid, request.args['tid'].strip())
team = {}
for k in ('name', 'chiefs', 'members', 'owners', 'tid', 'headcount',
'mailling', 'disabled'):
if k in _team:
team[k] = _team[k]
if 'headcount' not in team:
team['headcount'] = 0
else:
team['headcount'] = max([0, int(team['headcount'])])
return jsonify(team)
if request.method == 'POST':
data = request.json
if data['submittype'] == 'update':
chiefs = data['chiefs']
members = data['members']
if isinstance(data['chiefs'], str):
chiefs = [
_uid.strip() for _uid in data['chiefs'].split(',')
if _uid.strip()
]
if isinstance(data['members'], str):
members = [
_uid.strip() for _uid in data['members'].split(',')
if _uid.strip()
]
new_members = set(chiefs + members)
old_members = set(
Team.get_users(pid=pid, tids=(data['tid'], ))[data['tid']])
TeamMemberChangedDB().make_record(pid=pid,
tid=data['tid'],
action={
'add':
new_members - old_members,
'del':
old_members - new_members
})
Team.update_setting(pid=pid, tid=data['tid'], data=data)
service_sync_mattermost_add_channel.apply_async(
kwargs={
'pid': pid,
'uids': list(new_members)
})
return f'{data}'
if data['submittype'] == 'create':
Team.create(pid=pid,
tid=data['tid'],
name=data['name'],
owners=project['owners'])
return f'{data}'
return '', 404