def get(self, lid=0, group_id=0, student_id=0):
if lid > 0:
return {'LIVRET': getLivret(lid=lid)}, 200
elif group_id > 0 and student_id > 0:
return {
'LIVRET': getLivret(group_id=group_id, student_id=student_id)
}, 200
def put(self, pid):
args = request.get_json(cache=False, force=True)
if not checkParams(['text'], args):
return {"ERROR": "One or more parameters are missing !"}, 400
text = args['text']
user = session.get("user")
mails = []
# On vérifie que la période existe
period = getPeriod(pid)
if period is None:
return {"ERROR": "This period does not exists !"}, 405
# On vérifie que l'utilisateur actuel a le droit de modifier ce livret (étudiant ou tuteur)
livret = getLivret(lid=period["livret_id"])
if user["id"] != livret["etutor_id"]["id"] and user["id"] != livret[
"tutorship_id"]["student_id"]["id"]:
return {"ERROR": "UNAUTHORIZED"}, 401
# Si c'est le commentaire de l'étudiant, on prévient le tuteur
if user["role"] == str(Roles.etudiant):
mail = mailsModels.getMailContent("STUD_COMMENT_ADDED", {
"ETUDIANT": user["name"],
"URL": getParam('OLA_URL')
})
mails.append((user["email"], mail))
query = PERIOD.update().values(student_desc=text).where(
PERIOD.c.id == pid)
else: # Sinon on vérifie que c'est une période d'entreprise
if period["type"] == TypesPeriode.universitaire:
return {
"ERROR": "A tutor can't modify a university period !"
}, 405
mail = mailsModels.getMailContent("ETUTOR_COMMENT_ADDED", {
"TUTEUR": user["name"],
"URL": getParam('OLA_URL')
})
mails.append((user["email"], mail))
query = PERIOD.update().values(etutor_desc=text).where(
PERIOD.c.id == pid)
query.execute()
for m in mails:
addr = m[0]
mail = m[1]
send_mail(mail[0], addr, mail[1])
return {"PID": pid}, 200
def get(self, what, value):
user = session.get("user")
result = []
if what == "periodsOfLivret": # Toutes les périodes associées à un livret
if value > 0:
livret = getLivret(lid=value)
if livret is None:
return {"ERROR": "This livret doesn't exists !"}, 405
query = PERIOD.select(PERIOD.c.livret_id == value)
res = query.execute()
for row in res:
result.append(getPeriod(pid=row.id))
else:
return {'ERROR': 'Unkown parameter :' + str(what)}, 200
return {'RESULT': result}, 200
def post(self):
args = request.get_json(cache=False, force=True)
if not checkParams([
'group_id', 'etutor_id', 'company_name', 'company_address',
'contract_type', 'contract_start', 'contract_end',
'description'
], args):
return {"ERROR": "One or more parameters are missing !"}, 400
user = session.get("user")
group_id = args['group_id']
etutor_id = args['etutor_id']
company_name = args['company_name']
company_address = args['company_address']
contract_type = int(args['contract_type'])
contract_start = datetime.strptime(args['contract_start'], "%d-%m-%Y")
contract_end = datetime.strptime(args['contract_end'], "%d-%m-%Y")
description = args['description']
mails = []
group = getGroup(gid=group_id)
if group is None:
return {
"ERROR":
"This group with id " + str(group_id) + "does not exists !"
}, 405
tutorship = getTutorship(gid=group_id, student=user["id"])
if tutorship is None:
return {
"ERROR":
"The current student is not registered in the group" +
str(group_id) + " !"
}, 405
tutorship_id = tutorship["id"]
livret = getLivret(group_id=group_id, student_id=user["id"])
if livret is not None:
return {"LID": livret["id"]}, 200
# On vérifie que l'utilisateur actuel a le droit de modifier ce livret
if user["id"] != livret["tutorship_id"]["student_id"]:
return {"ERROR": "UNAUTHORIZED"}, 401
user2 = getUser(uid=etutor_id)
if user2 is None:
return {
"ERROR":
"The user with id " + str(etutor_id) + " does not exists !"
}, 400
else:
query = USER.select(USER.c.id == user2["id"])
rows = query.execute()
res = rows.first()
if res.hash is not None and len(res.hash) > 0:
mail = mailsModels.getMailContent(
"NEW_ETUTOR_ADDED", {
"GROUPE": group["name"],
"URL": getParam('OLA_URL') + "registration/" + res.hash
})
else:
mail = mailsModels.getMailContent("ETUTOR_ADDED", {
"GROUPE": group["name"],
"URL": getParam('OLA_URL')
})
mails.append((user2["email"], mail))
if str(Roles.tuteur_entreprise) not in user2['role'].split('-'):
return {
"ERROR":
"The user with id " + str(etutor_id) +
" doesn't have the 'etutor' role (" +
str(Roles.tuteur_entreprise) + ") !"
}, 400
if contract_start > contract_end:
return {
"ERROR": "The contract start can't be after its end !"
}, 400
res_dir = group["ressources_dir"] + "/" + str(user['id']) + "/"
expire = datetime.now() + timedelta(days=365)
query = LIVRET.insert().values(tutorship_id=tutorship_id,
etutor_id=etutor_id,
company_name=company_name,
company_address=company_address,
contract_type=contract_type,
contract_start=contract_start,
contract_end=contract_end,
description=description,
ressources_dir=res_dir,
opened='1',
expire=expire)
res = query.execute()
os.mkdir(res_dir)
for m in mails:
addr = m[0]
mail = m[1]
send_mail(mail[0], addr, mail[1])
return {"LID": res.lastrowid}, 201
def put(self, lid):
args = request.get_json(cache=False, force=True)
if not checkParams([
'etutor_id', 'company_name', 'company_address',
'contract_type', 'contract_start', 'contract_end',
'description'
], args):
return {"ERROR": "One or more parameters are missing !"}, 400
etutor_id = args['etutor_id']
company_name = args['company_name']
company_address = args['company_address']
contract_type = int(args['contract_type'])
contract_start = datetime.strptime(args['contract_start'], "%d-%m-%Y")
contract_end = datetime.strptime(args['contract_end'], "%d-%m-%Y")
description = args['description']
mails = []
livret = getLivret(lid=lid)
if livret is None:
return {"ERROR": "This livret does not exists !"}, 405
# On vérifie que l'utilisateur actuel a le droit de modifier ce livret
user = session.get("user")
if user["id"] != livret["tutorship_id"]["student_id"]:
return {"ERROR": "UNAUTHORIZED"}, 401
user = getUser(uid=etutor_id)
if user is None:
return {
"ERROR":
"The user with id " + str(etutor_id) + " does not exists !"
}, 400
else:
query = USER.select(USER.c.id == user["id"])
rows = query.execute()
res = rows.first()
if res.hash is not None and len(res.hash) > 0:
mail = mailsModels.getMailContent(
"NEW_ETUTOR_ADDED", {
"GROUPE": livret["tutorship_id"]["group_id"]["name"],
"URL": getParam('OLA_URL') + "registration/" + res.hash
})
else:
mail = mailsModels.getMailContent(
"ETUTOR_ADDED", {
"GROUPE": livret["tutorship_id"]["group_id"]["name"],
"URL": getParam('OLA_URL')
})
mails.append((user["email"], mail))
if str(Roles.tuteur_entreprise) not in user['role'].split('-'):
return {
"ERROR":
"The user with id " + str(etutor_id) +
" doesn't have the 'etutor' role (" +
str(Roles.tuteur_entreprise) + ") !"
}, 400
if contract_start > contract_end:
return {
"ERROR": "The contract start can't be after its end !"
}, 400
query = LIVRET.update().values(etutor_id=etutor_id, company_name=company_name,
company_address=company_address, contract_type=contract_type,
contract_start=contract_start, contract_end=contract_end,
description=description) \
.where(LIVRET.c.id == lid)
query.execute()
for m in mails:
addr = m[0]
mail = m[1]
send_mail(mail[0], addr, mail[1])
return {"LID": lid}, 200