def perform_loanshistoricaloverview(uid, ln=CFG_SITE_LANG):
"""
Display Loans historical overview for user uid.
@param uid: user id
@param ln: language of the page
@return body(html)
"""
invenio_user_email = db.get_invenio_user_email(uid)
is_borrower = db.is_borrower(invenio_user_email)
result = db.get_historical_overview(is_borrower)
body = bibcirculation_templates.tmpl_loanshistoricaloverview(result=result, ln=ln)
return body
def perform_loanshistoricaloverview(uid, ln=CFG_SITE_LANG):
"""
Display Loans historical overview for user uid.
@param uid: user id
@param ln: language of the page
@return body(html)
"""
invenio_user_email = db.get_invenio_user_email(uid)
is_borrower = db.is_borrower(invenio_user_email)
result = db.get_historical_overview(is_borrower)
body = bibcirculation_templates.tmpl_loanshistoricaloverview(result=result,
ln=ln)
return body
def perform_borrower_loans(uid,
barcode,
borrower_id,
request_id,
ln=CFG_SITE_LANG):
"""
Display all the loans and the requests of a given borrower.
@param barcode: identify the item. Primary key of crcITEM.
@type barcode: string
@param borrower_id: identify the borrower. Primary key of crcBORROWER.
@type borrower_id: int
@param request_id: identify the request: Primary key of crcLOANREQUEST
@type request_id: int
@return body(html)
"""
infos = []
is_borrower = db.is_borrower(db.get_invenio_user_email(uid))
loans = db.get_borrower_loans(is_borrower)
requests = db.get_borrower_requests(is_borrower)
tmp_date = datetime.date.today() + datetime.timedelta(days=30)
new_due_date = get_datetext(tmp_date.year, tmp_date.month, tmp_date.day)
#renew loan
if barcode:
recid = db.get_id_bibrec(barcode)
queue = db.get_queue_request(recid)
if len(queue) != 0:
infos.append("It is not possible to renew your loan for " \
"<strong>" + book_title_from_MARC(recid) + "</strong>. Another user " \
"is waiting for this book.")
else:
db.update_due_date(barcode, new_due_date)
infos.append("Your loan has been renewed with sucess.")
#cancel request
if request_id:
db.cancel_request(request_id, 'cancelled')
make_copy_available(request_id)
#renew all loans
elif borrower_id:
list_of_recids = db.get_borrower_recids(borrower_id)
for (recid) in list_of_recids:
queue = db.get_queue_request(recid[0])
#check if there are requests
if len(queue) != 0:
infos.append("It is not possible to renew your loan for " \
"<strong>" + book_title_from_MARC(recid) + "</strong>. Another user" \
" is waiting for this book.")
else:
db.update_due_date_borrower(borrower_id, new_due_date)
infos.append("All loans have been renewed with success.")
body = bibcirculation_templates.tmpl_yourloans(loans=loans,
requests=requests,
borrower_id=is_borrower,
infos=infos,
ln=ln)
return body
def ill_register_request(uid,
title,
authors,
place,
publisher,
year,
edition,
isbn,
period_of_interest_from,
period_of_interest_to,
additional_comments,
conditions,
only_edition,
request_type,
ln=CFG_SITE_LANG):
"""
Register new ILL request. Create new record (collection: ILL Books)
@param uid: user id
@type: int
@param authors: book's authors
@type authors: string
@param place: place of publication
@type place: string
@param publisher: book's publisher
@type publisher: string
@param year: year of publication
@type year: string
@param edition: book's edition
@type edition: string
@param isbn: book's isbn
@type isbn: string
@param period_of_interest_from: period of interest - from(date)
@type period_of_interest_from: string
@param period_of_interest_to: period of interest - to(date)
@type period_of_interest_to: string
@param additional_comments: comments given by the user
@type additional_comments: string
@param conditions: ILL conditions
@type conditions: boolean
@param only_edition: borrower wants only the given edition
@type only_edition: boolean
"""
item_info = (title, authors, place, publisher, year, edition, isbn)
create_ill_record(item_info)
book_info = {
'title': title,
'authors': authors,
'place': place,
'publisher': publisher,
'year': year,
'edition': edition,
'isbn': isbn
}
user = collect_user_info(uid)
is_borrower = db.is_borrower(user['email'])
#Check if borrower is on DB.
if is_borrower != 0:
address = db.get_borrower_address(user['email'])
#Check if borrower has an address.
if address != 0:
#Check if borrower has accepted ILL conditions.
if conditions:
#Register ILL request on crcILLREQUEST.
db.ill_register_request(book_info, is_borrower,
period_of_interest_from,
period_of_interest_to, 'new',
additional_comments, only_edition
or 'False', request_type)
#Display confirmation message.
message = "Your ILL request has been registered and the " \
"document will be sent to you via internal mail."
#Notify librarian about new ILL request.
send_email(fromaddr=CFG_BIBCIRCULATION_LIBRARIAN_EMAIL,
toaddr=CFG_SITE_SUPPORT_EMAIL,
subject='ILL request for books confirmation',
content="",
attempt_times=1,
attempt_sleeptime=10)
#Borrower did not accept ILL conditions.
else:
infos = []
infos.append("You didn't accept the ILL conditions.")
body = bibcirculation_templates.tmpl_display_ill_form(
infos=infos, ln=ln)
#Borrower doesn't have an address.
else:
#If BibCirculation at CERN, use LDAP.
if CFG_CERN_SITE == 1:
email = user['email']
result = get_user_info_from_ldap(email)
try:
ldap_address = result['physicalDeliveryOfficeName'][0]
except KeyError:
ldap_address = None
# verify address
if ldap_address is not None:
db.add_borrower_address(ldap_address, email)
db.ill_register_request(book_info, is_borrower,
period_of_interest_from,
period_of_interest_to, 'new',
additional_comments, only_edition
or 'False', request_type)
message = "Your ILL request has been registered and the document"\
" will be sent to you via internal mail."
send_email(fromaddr=CFG_BIBCIRCULATION_LIBRARIAN_EMAIL,
toaddr=CFG_SITE_SUPPORT_EMAIL,
subject='ILL request for books confirmation',
content="",
attempt_times=1,
attempt_sleeptime=10)
else:
message = "It is not possible to validate your request. "\
"Your office address is not available. "\
"Please contact ... "
else:
# Get information from CERN LDAP
if CFG_CERN_SITE == 1:
result = get_user_info_from_ldap(email=user['email'])
try:
name = result['cn'][0]
except KeyError:
name = None
try:
email = result['mail'][0]
except KeyError:
email = None
try:
phone = result['telephoneNumber'][0]
except KeyError:
phone = None
try:
address = result['physicalDeliveryOfficeName'][0]
except KeyError:
address = None
try:
mailbox = result['postOfficeBox'][0]
except KeyError:
mailbox = None
# verify address
if address is not None:
db.new_borrower(name, email, phone, address, mailbox, '')
is_borrower = db.is_borrower(email)
db.ill_register_request(book_info, is_borrower,
period_of_interest_from,
period_of_interest_to, 'new',
additional_comments, only_edition
or 'False', request_type)
message = "Your ILL request has been registered and the document"\
" will be sent to you via internal mail."
send_email(fromaddr=CFG_BIBCIRCULATION_LIBRARIAN_EMAIL,
toaddr=CFG_SITE_SUPPORT_EMAIL,
subject='ILL request for books confirmation',
content="",
attempt_times=1,
attempt_sleeptime=10)
else:
message = "It is not possible to validate your request. "\
"Your office address is not available."\
" Please contact ... "
body = bibcirculation_templates.tmpl_ill_register_request_with_recid(
message=message, ln=ln)
return body
def ill_register_request_with_recid(recid,
uid,
period_of_interest_from,
period_of_interest_to,
additional_comments,
conditions,
only_edition,
ln=CFG_SITE_LANG):
"""
Register a new ILL request.
@param recid: identify the record. Primary key of bibrec.
@type recid: int
@param uid: user id
@type: int
@param period_of_interest_from: period of interest - from(date)
@type period_of_interest_from: string
@param period_of_interest_to: period of interest - to(date)
@type period_of_interest_to: string
"""
# create a dictionnary
book_info = {'recid': recid}
user = collect_user_info(uid)
is_borrower = db.is_borrower(user['email'])
if is_borrower == 0:
if CFG_CERN_SITE == 1:
result = get_user_info_from_ldap(email=user['email'])
try:
name = result['cn'][0]
except KeyError:
name = None
try:
email = result['mail'][0]
except KeyError:
email = None
try:
phone = result['telephoneNumber'][0]
except KeyError:
phone = None
try:
address = result['physicalDeliveryOfficeName'][0]
except KeyError:
address = None
try:
mailbox = result['postOfficeBox'][0]
except KeyError:
mailbox = None
if address is not None:
db.new_borrower(name, email, phone, address, mailbox, '')
else:
message = bibcirculation_templates.tmpl_message_request_send_fail_cern(
)
else:
message = bibcirculation_templates.tmpl_message_request_send_fail_other(
)
return bibcirculation_templates.tmpl_ill_register_request_with_recid(
message=message, ln=ln)
address = db.get_borrower_address(user['email'])
if address == 0:
if CFG_CERN_SITE == 1:
email = user['email']
result = get_user_info_from_ldap(email)
try:
address = result['physicalDeliveryOfficeName'][0]
except KeyError:
address = None
if address is not None:
db.add_borrower_address(address, email)
else:
message = bibcirculation_templates.tmpl_message_request_send_fail_cern(
)
else:
message = bibcirculation_templates.tmpl_message_request_send_fail_other(
)
return bibcirculation_templates.tmpl_ill_register_request_with_recid(
message=message, ln=ln)
if not conditions:
infos = []
infos.append("You didn't accept the ILL conditions.")
return bibcirculation_templates.tmpl_ill_request_with_recid(
recid, infos=infos, ln=ln)
else:
db.ill_register_request(book_info, is_borrower,
period_of_interest_from, period_of_interest_to,
'new', additional_comments, only_edition
or 'False', 'book')
if CFG_CERN_SITE == 1:
message = bibcirculation_templates.tmpl_message_request_send_ok_cern(
)
else:
message = bibcirculation_templates.tmpl_message_request_send_ok_other(
)
#Notify librarian about new ILL request.
send_email(fromaddr=CFG_BIBCIRCULATION_LIBRARIAN_EMAIL,
toaddr="*****@*****.**",
subject='ILL request for books confirmation',
content=hold_request_mail(recid, is_borrower),
attempt_times=1,
attempt_sleeptime=10)
return bibcirculation_templates.tmpl_ill_register_request_with_recid(
message=message, ln=ln)
def perform_new_request_send(uid,
recid,
period_from,
period_to,
barcode,
ln=CFG_SITE_LANG):
"""
@param recid: recID - Invenio record identifier
@param ln: language of the page
"""
nb_requests = db.get_number_requests_per_copy(barcode)
is_on_loan = db.is_item_on_loan(barcode)
if nb_requests == 0 and is_on_loan is not None:
status = 'waiting'
elif nb_requests == 0 and is_on_loan is None:
status = 'pending'
else:
status = 'waiting'
user = collect_user_info(uid)
is_borrower = db.is_borrower(user['email'])
if is_borrower != 0:
address = db.get_borrower_address(user['email'])
if address != 0:
db.new_hold_request(is_borrower, recid, barcode, period_from,
period_to, status)
is_on_loan = db.is_item_on_loan(barcode)
db.update_item_status('requested', barcode)
if not is_on_loan:
send_email(fromaddr=CFG_BIBCIRCULATION_LIBRARIAN_EMAIL,
toaddr=CFG_SITE_SUPPORT_EMAIL,
subject='Hold request for books confirmation',
content=hold_request_mail(recid, is_borrower),
attempt_times=1,
attempt_sleeptime=10)
if CFG_CERN_SITE == 1:
message = bibcirculation_templates.tmpl_message_request_send_ok_cern(
)
else:
message = bibcirculation_templates.tmpl_message_request_send_ok_other(
)
else:
if CFG_CERN_SITE == 1:
email = user['email']
result = get_user_info_from_ldap(email)
try:
ldap_address = result['physicalDeliveryOfficeName'][0]
except KeyError:
ldap_address = None
if ldap_address is not None:
db.add_borrower_address(ldap_address, email)
db.new_hold_request(is_borrower, recid, barcode,
period_from, period_to, status)
db.update_item_status('requested', barcode)
send_email(fromaddr=CFG_BIBCIRCULATION_LIBRARIAN_EMAIL,
toaddr=CFG_SITE_SUPPORT_EMAIL,
subject='Hold request for books confirmation',
content=hold_request_mail(recid, is_borrower),
attempt_times=1,
attempt_sleeptime=10)
message = bibcirculation_templates.tmpl_message_request_send_ok_cern(
ln=ln)
else:
message = bibcirculation_templates.tmpl_message_request_send_fail_cern(
ln=ln)
else:
message = bibcirculation_templates.tmpl_message_request_send_fail_other(
ln=ln)
else:
if CFG_CERN_SITE == 1:
result = get_user_info_from_ldap(email=user['email'])
try:
name = result['cn'][0]
except KeyError:
name = None
try:
email = result['mail'][0]
except KeyError:
email = None
try:
phone = result['telephoneNumber'][0]
except KeyError:
phone = None
try:
address = result['physicalDeliveryOfficeName'][0]
except KeyError:
address = None
try:
mailbox = result['postOfficeBox'][0]
except KeyError:
mailbox = None
if address is not None:
db.new_borrower(name, email, phone, address, mailbox, '')
is_borrower = db.is_borrower(email)
db.new_hold_request(is_borrower, recid, barcode, period_from,
period_to, status)
db.update_item_status('requested', barcode)
send_email(fromaddr=CFG_BIBCIRCULATION_LIBRARIAN_EMAIL,
toaddr=CFG_BIBCIRCULATION_LIBRARIAN_EMAIL,
subject='Hold request for books confirmation',
content=hold_request_mail(recid, is_borrower),
attempt_times=1,
attempt_sleeptime=10)
message = bibcirculation_templates.tmpl_message_request_send_ok_cern(
)
else:
message = bibcirculation_templates.tmpl_message_request_send_fail_cern(
)
else:
message = bibcirculation_templates.tmpl_message_request_send_ok_other(
)
body = bibcirculation_templates.tmpl_new_request_send(message=message,
ln=ln)
return body
def perform_borrower_loans(uid, barcode, borrower_id,
request_id, ln=CFG_SITE_LANG):
"""
Display all the loans and the requests of a given borrower.
@param barcode: identify the item. Primary key of crcITEM.
@type barcode: string
@param borrower_id: identify the borrower. Primary key of crcBORROWER.
@type borrower_id: int
@param request_id: identify the request: Primary key of crcLOANREQUEST
@type request_id: int
@return body(html)
"""
infos = []
is_borrower = db.is_borrower(db.get_invenio_user_email(uid))
loans = db.get_borrower_loans(is_borrower)
requests = db.get_borrower_requests(is_borrower)
tmp_date = datetime.date.today() + datetime.timedelta(days=30)
new_due_date = get_datetext(tmp_date.year, tmp_date.month, tmp_date.day)
#renew loan
if barcode:
recid = db.get_id_bibrec(barcode)
queue = db.get_queue_request(recid)
if len(queue) != 0:
infos.append("It is not possible to renew your loan for " \
"<strong>" + book_title_from_MARC(recid) + "</strong>. Another user " \
"is waiting for this book.")
else:
db.update_due_date(barcode, new_due_date)
infos.append("Your loan has been renewed with sucess.")
#cancel request
if request_id:
db.cancel_request(request_id, 'cancelled')
make_copy_available(request_id)
#renew all loans
elif borrower_id:
list_of_recids = db.get_borrower_recids(borrower_id)
for (recid) in list_of_recids:
queue = db.get_queue_request(recid[0])
#check if there are requests
if len(queue) != 0:
infos.append("It is not possible to renew your loan for " \
"<strong>" + book_title_from_MARC(recid) + "</strong>. Another user" \
" is waiting for this book.")
else:
db.update_due_date_borrower(borrower_id,
new_due_date)
infos.append("All loans have been renewed with success.")
body = bibcirculation_templates.tmpl_yourloans(loans=loans,
requests=requests,
borrower_id=is_borrower,
infos=infos,
ln=ln)
return body
def ill_register_request(uid, title, authors, place, publisher, year, edition,
isbn, period_of_interest_from, period_of_interest_to,
additional_comments, conditions, only_edition, request_type, ln=CFG_SITE_LANG):
"""
Register new ILL request. Create new record (collection: ILL Books)
@param uid: user id
@type: int
@param authors: book's authors
@type authors: string
@param place: place of publication
@type place: string
@param publisher: book's publisher
@type publisher: string
@param year: year of publication
@type year: string
@param edition: book's edition
@type edition: string
@param isbn: book's isbn
@type isbn: string
@param period_of_interest_from: period of interest - from(date)
@type period_of_interest_from: string
@param period_of_interest_to: period of interest - to(date)
@type period_of_interest_to: string
@param additional_comments: comments given by the user
@type additional_comments: string
@param conditions: ILL conditions
@type conditions: boolean
@param only_edition: borrower wants only the given edition
@type only_edition: boolean
"""
item_info = (title, authors, place, publisher, year, edition, isbn)
create_ill_record(item_info)
book_info = {'title': title, 'authors': authors, 'place': place, 'publisher': publisher,
'year': year, 'edition': edition, 'isbn': isbn}
user = collect_user_info(uid)
is_borrower = db.is_borrower(user['email'])
#Check if borrower is on DB.
if is_borrower != 0:
address = db.get_borrower_address(user['email'])
#Check if borrower has an address.
if address != 0:
#Check if borrower has accepted ILL conditions.
if conditions:
#Register ILL request on crcILLREQUEST.
db.ill_register_request(book_info, is_borrower, period_of_interest_from,
period_of_interest_to, 'new', additional_comments,
only_edition or 'False', request_type)
#Display confirmation message.
message = "Your ILL request has been registered and the " \
"document will be sent to you via internal mail."
#Notify librarian about new ILL request.
send_email(fromaddr=CFG_BIBCIRCULATION_LIBRARIAN_EMAIL,
toaddr=CFG_SITE_SUPPORT_EMAIL,
subject='ILL request for books confirmation',
content="",
attempt_times=1,
attempt_sleeptime=10
)
#Borrower did not accept ILL conditions.
else:
infos = []
infos.append("You didn't accept the ILL conditions.")
body = bibcirculation_templates.tmpl_display_ill_form(infos=infos, ln=ln)
#Borrower doesn't have an address.
else:
#If BibCirculation at CERN, use LDAP.
if CFG_CERN_SITE == 1:
email=user['email']
result = get_user_info_from_ldap(email)
try:
ldap_address = result['physicalDeliveryOfficeName'][0]
except KeyError:
ldap_address = None
# verify address
if ldap_address is not None:
db.add_borrower_address(ldap_address, email)
db.ill_register_request(book_info, is_borrower, period_of_interest_from,
period_of_interest_to, 'new', additional_comments,
only_edition or 'False', request_type)
message = "Your ILL request has been registered and the document"\
" will be sent to you via internal mail."
send_email(fromaddr=CFG_BIBCIRCULATION_LIBRARIAN_EMAIL,
toaddr=CFG_SITE_SUPPORT_EMAIL,
subject='ILL request for books confirmation',
content="",
attempt_times=1,
attempt_sleeptime=10
)
else:
message = "It is not possible to validate your request. "\
"Your office address is not available. "\
"Please contact ... "
else:
# Get information from CERN LDAP
if CFG_CERN_SITE == 1:
result = get_user_info_from_ldap(email=user['email'])
try:
name = result['cn'][0]
except KeyError:
name = None
try:
email = result['mail'][0]
except KeyError:
email = None
try:
phone = result['telephoneNumber'][0]
except KeyError:
phone = None
try:
address = result['physicalDeliveryOfficeName'][0]
except KeyError:
address = None
try:
mailbox = result['postOfficeBox'][0]
except KeyError:
mailbox = None
# verify address
if address is not None:
db.new_borrower(name, email, phone, address, mailbox, '')
is_borrower = db.is_borrower(email)
db.ill_register_request(book_info, is_borrower, period_of_interest_from,
period_of_interest_to, 'new', additional_comments,
only_edition or 'False', request_type)
message = "Your ILL request has been registered and the document"\
" will be sent to you via internal mail."
send_email(fromaddr=CFG_BIBCIRCULATION_LIBRARIAN_EMAIL,
toaddr=CFG_SITE_SUPPORT_EMAIL,
subject='ILL request for books confirmation',
content="",
attempt_times=1,
attempt_sleeptime=10
)
else:
message = "It is not possible to validate your request. "\
"Your office address is not available."\
" Please contact ... "
body = bibcirculation_templates.tmpl_ill_register_request_with_recid(message=message, ln=ln)
return body
def ill_register_request_with_recid(recid, uid, period_of_interest_from,
period_of_interest_to, additional_comments,
conditions, only_edition, ln=CFG_SITE_LANG):
"""
Register a new ILL request.
@param recid: identify the record. Primary key of bibrec.
@type recid: int
@param uid: user id
@type: int
@param period_of_interest_from: period of interest - from(date)
@type period_of_interest_from: string
@param period_of_interest_to: period of interest - to(date)
@type period_of_interest_to: string
"""
# create a dictionnary
book_info = {'recid': recid}
user = collect_user_info(uid)
is_borrower = db.is_borrower(user['email'])
if is_borrower == 0:
if CFG_CERN_SITE == 1:
result = get_user_info_from_ldap(email=user['email'])
try:
name = result['cn'][0]
except KeyError:
name = None
try:
email = result['mail'][0]
except KeyError:
email = None
try:
phone = result['telephoneNumber'][0]
except KeyError:
phone = None
try:
address = result['physicalDeliveryOfficeName'][0]
except KeyError:
address = None
try:
mailbox = result['postOfficeBox'][0]
except KeyError:
mailbox = None
if address is not None:
db.new_borrower(name, email, phone, address, mailbox, '')
else:
message = bibcirculation_templates.tmpl_message_request_send_fail_cern()
else:
message = bibcirculation_templates.tmpl_message_request_send_fail_other()
return bibcirculation_templates.tmpl_ill_register_request_with_recid(message=message, ln=ln)
address = db.get_borrower_address(user['email'])
if address == 0:
if CFG_CERN_SITE == 1:
email=user['email']
result = get_user_info_from_ldap(email)
try:
address = result['physicalDeliveryOfficeName'][0]
except KeyError:
address = None
if address is not None:
db.add_borrower_address(address, email)
else:
message = bibcirculation_templates.tmpl_message_request_send_fail_cern()
else:
message = bibcirculation_templates.tmpl_message_request_send_fail_other()
return bibcirculation_templates.tmpl_ill_register_request_with_recid(message=message, ln=ln)
if not conditions:
infos = []
infos.append("You didn't accept the ILL conditions.")
return bibcirculation_templates.tmpl_ill_request_with_recid(recid, infos=infos, ln=ln)
else:
db.ill_register_request(book_info, is_borrower, period_of_interest_from,
period_of_interest_to, 'new', additional_comments,
only_edition or 'False','book')
if CFG_CERN_SITE == 1:
message = bibcirculation_templates.tmpl_message_request_send_ok_cern()
else:
message = bibcirculation_templates.tmpl_message_request_send_ok_other()
#Notify librarian about new ILL request.
send_email(fromaddr=CFG_BIBCIRCULATION_LIBRARIAN_EMAIL,
toaddr="*****@*****.**",
subject='ILL request for books confirmation',
content=hold_request_mail(recid, is_borrower),
attempt_times=1,
attempt_sleeptime=10)
return bibcirculation_templates.tmpl_ill_register_request_with_recid(message=message, ln=ln)
def perform_new_request_send(uid, recid,
period_from, period_to,
barcode, ln=CFG_SITE_LANG):
"""
@param recid: recID - Invenio record identifier
@param ln: language of the page
"""
nb_requests = db.get_number_requests_per_copy(barcode)
is_on_loan = db.is_item_on_loan(barcode)
if nb_requests == 0 and is_on_loan is not None:
status = 'waiting'
elif nb_requests == 0 and is_on_loan is None:
status = 'pending'
else:
status = 'waiting'
user = collect_user_info(uid)
is_borrower = db.is_borrower(user['email'])
if is_borrower != 0:
address = db.get_borrower_address(user['email'])
if address != 0:
db.new_hold_request(is_borrower, recid, barcode,
period_from, period_to, status)
is_on_loan=db.is_item_on_loan(barcode)
db.update_item_status('requested', barcode)
if not is_on_loan:
send_email(fromaddr=CFG_BIBCIRCULATION_LIBRARIAN_EMAIL,
toaddr=CFG_SITE_SUPPORT_EMAIL,
subject='Hold request for books confirmation',
content=hold_request_mail(recid, is_borrower),
attempt_times=1,
attempt_sleeptime=10
)
if CFG_CERN_SITE == 1:
message = bibcirculation_templates.tmpl_message_request_send_ok_cern()
else:
message = bibcirculation_templates.tmpl_message_request_send_ok_other()
else:
if CFG_CERN_SITE == 1:
email=user['email']
result = get_user_info_from_ldap(email)
try:
ldap_address = result['physicalDeliveryOfficeName'][0]
except KeyError:
ldap_address = None
if ldap_address is not None:
db.add_borrower_address(ldap_address, email)
db.new_hold_request(is_borrower, recid, barcode,
period_from, period_to, status)
db.update_item_status('requested', barcode)
send_email(fromaddr=CFG_BIBCIRCULATION_LIBRARIAN_EMAIL,
toaddr=CFG_SITE_SUPPORT_EMAIL,
subject='Hold request for books confirmation',
content=hold_request_mail(recid, is_borrower),
attempt_times=1,
attempt_sleeptime=10
)
message = bibcirculation_templates.tmpl_message_request_send_ok_cern(ln=ln)
else:
message = bibcirculation_templates.tmpl_message_request_send_fail_cern(ln=ln)
else:
message = bibcirculation_templates.tmpl_message_request_send_fail_other(ln=ln)
else:
if CFG_CERN_SITE == 1:
result = get_user_info_from_ldap(email=user['email'])
try:
name = result['cn'][0]
except KeyError:
name = None
try:
email = result['mail'][0]
except KeyError:
email = None
try:
phone = result['telephoneNumber'][0]
except KeyError:
phone = None
try:
address = result['physicalDeliveryOfficeName'][0]
except KeyError:
address = None
try:
mailbox = result['postOfficeBox'][0]
except KeyError:
mailbox = None
if address is not None:
db.new_borrower(name, email, phone, address, mailbox, '')
is_borrower = db.is_borrower(email)
db.new_hold_request(is_borrower, recid, barcode,
period_from, period_to, status)
db.update_item_status('requested', barcode)
send_email(fromaddr=CFG_BIBCIRCULATION_LIBRARIAN_EMAIL,
toaddr=CFG_BIBCIRCULATION_LIBRARIAN_EMAIL,
subject='Hold request for books confirmation',
content=hold_request_mail(recid, is_borrower),
attempt_times=1,
attempt_sleeptime=10
)
message = bibcirculation_templates.tmpl_message_request_send_ok_cern()
else:
message = bibcirculation_templates.tmpl_message_request_send_fail_cern()
else:
message = bibcirculation_templates.tmpl_message_request_send_ok_other()
body = bibcirculation_templates.tmpl_new_request_send(message=message, ln=ln)
return body
def ill_register_request_with_recid(
recid,
uid,
period_of_interest_from,
period_of_interest_to,
additional_comments,
conditions,
only_edition,
ln=CFG_SITE_LANG,
):
"""
Register a new ILL request.
@param recid: identify the record. Primary key of bibrec.
@type recid: int
@param uid: user id
@type: int
@param period_of_interest_from: period of interest - from(date)
@type period_of_interest_from: string
@param period_of_interest_to: period of interest - to(date)
@type period_of_interest_to: string
"""
# create a dictionnary
book_info = {"recid": recid}
user = collect_user_info(uid)
is_borrower = db.is_borrower(user["email"])
# Check if borrower is on DB.
if is_borrower != 0:
address = db.get_borrower_address(user["email"])
# Check if borrower has an address.
if address != 0:
# Check if borrower has accepted ILL conditions.
if conditions:
# Register ILL request on crcILLREQUEST.
db.ill_register_request(
book_info,
is_borrower,
period_of_interest_from,
period_of_interest_to,
"pending",
additional_comments,
only_edition or "False",
)
# Display confirmation message.
message = (
"Your ILL request has been registered and the " "document will be sent to you via internal mail."
)
# Notify librarian about new ILL request.
send_email(
fromaddr=CFG_BIBCIRCULATION_LIBRARIAN_EMAIL,
toaddr=CFG_SITE_SUPPORT_EMAIL,
subject="ILL request for books confirmation",
content=hold_request_mail(recid, is_borrower),
attempt_times=1,
attempt_sleeptime=10,
)
# Borrower did not accept ILL conditions.
else:
infos = []
infos.append("You didn't accept the ILL conditions.")
body = bibcirculation_templates.tmpl_ill_request_with_recid(recid, infos=infos, ln=ln)
# Borrower doesn't have an address.
else:
# If BibCirculation at CERN, use LDAP.
if CFG_CERN_SITE == 1:
email = user["email"]
result = get_user_info_from_ldap(email)
try:
ldap_address = result["physicalDeliveryOfficeName"][0]
except KeyError:
ldap_address = None
# verify address
if ldap_address is not None:
db.add_borrower_address(ldap_address, email)
db.ill_register_request(
book_info,
is_borrower,
period_of_interest_from,
period_of_interest_to,
additional_comments,
conditions,
only_edition or "False",
)
message = (
"Your ILL request has been registered and the document"
" will be sent to you via internal mail."
)
send_email(
fromaddr=CFG_BIBCIRCULATION_LIBRARIAN_EMAIL,
toaddr=CFG_SITE_SUPPORT_EMAIL,
subject="ILL request for books confirmation",
content=hold_request_mail(recid, is_borrower),
attempt_times=1,
attempt_sleeptime=10,
)
else:
message = (
"It is not possible to validate your request. "
"Your office address is not available. "
"Please contact ... "
)
else:
# Get information from CERN LDAP
if CFG_CERN_SITE == 1:
result = get_user_info_from_ldap(email=user["email"])
try:
name = result["cn"][0]
except KeyError:
name = None
try:
email = result["mail"][0]
except KeyError:
email = None
try:
phone = result["telephoneNumber"][0]
except KeyError:
phone = None
try:
address = result["physicalDeliveryOfficeName"][0]
except KeyError:
address = None
try:
mailbox = result["postOfficeBox"][0]
except KeyError:
mailbox = None
# verify address
if address is not None:
db.new_borrower(name, email, phone, address, mailbox, "")
is_borrower = db.is_borrower(email)
db.ill_register_request(
book_info,
is_borrower,
period_of_interest_from,
period_of_interest_to,
additional_comments,
conditions,
only_edition or "False",
)
message = (
"Your ILL request has been registered and the document" " will be sent to you via internal mail."
)
send_email(
fromaddr=CFG_BIBCIRCULATION_LIBRARIAN_EMAIL,
toaddr=CFG_SITE_SUPPORT_EMAIL,
subject="ILL request for books confirmation",
content=hold_request_mail(recid, is_borrower),
attempt_times=1,
attempt_sleeptime=10,
)
else:
message = (
"It is not possible to validate your request. "
"Your office address is not available."
" Please contact ... "
)
body = bibcirculation_templates.tmpl_ill_register_request_with_recid(message=message, ln=ln)
return body
def perform_new_request_send(
uid, recid, from_year, from_month, from_day, to_year, to_month, to_day, barcode, ln=CFG_SITE_LANG
):
"""
@param recid: recID - CDS Invenio record identifier
@param ln: language of the page
"""
request_from = get_datetext(from_year, from_month, from_day)
request_to = get_datetext(to_year, to_month, to_day)
nb_requests = db.get_number_requests_per_copy(barcode)
is_on_loan = db.is_item_on_loan(barcode)
if nb_requests == 0 and is_on_loan is not None:
status = "waiting"
elif nb_requests == 0 and is_on_loan is None:
status = "pending"
else:
status = "waiting"
user = collect_user_info(uid)
is_borrower = db.is_borrower(user["email"])
if is_borrower != 0:
address = db.get_borrower_address(user["email"])
if address != 0:
db.new_hold_request(is_borrower, recid, barcode, request_from, request_to, status)
db.update_item_status("requested", barcode)
send_email(
fromaddr=CFG_BIBCIRCULATION_LIBRARIAN_EMAIL,
toaddr=CFG_SITE_SUPPORT_EMAIL,
subject="Hold request for books confirmation",
content=hold_request_mail(recid, is_borrower),
attempt_times=1,
attempt_sleeptime=10,
)
if CFG_CERN_SITE == 1:
message = bibcirculation_templates.tmpl_message_request_send_ok_cern(ln=ln)
else:
message = bibcirculation_templates.tmpl_message_request_send_ok_other(ln=ln)
else:
if CFG_CERN_SITE == 1:
email = user["email"]
result = get_user_info_from_ldap(email)
try:
ldap_address = result["physicalDeliveryOfficeName"][0]
except KeyError:
ldap_address = None
if ldap_address is not None:
db.add_borrower_address(ldap_address, email)
db.new_hold_request(is_borrower, recid, barcode, request_from, request_to, status)
db.update_item_status("requested", barcode)
send_email(
fromaddr=CFG_BIBCIRCULATION_LIBRARIAN_EMAIL,
toaddr=CFG_SITE_SUPPORT_EMAIL,
subject="Hold request for books confirmation",
content=hold_request_mail(recid, is_borrower),
attempt_times=1,
attempt_sleeptime=10,
)
message = bibcirculation_templates.tmpl_message_request_send_ok_cern(ln=ln)
else:
message = bibcirculation_templates.tmpl_message_request_send_fail_cern(ln=ln)
else:
message = bibcirculation_templates.tmpl_message_request_send_fail_other(ln=ln)
else:
if CFG_CERN_SITE == 1:
result = get_user_info_from_ldap(email=user["email"])
try:
name = result["cn"][0]
except KeyError:
name = None
try:
email = result["mail"][0]
except KeyError:
email = None
try:
phone = result["telephoneNumber"][0]
except KeyError:
phone = None
try:
address = result["physicalDeliveryOfficeName"][0]
except KeyError:
address = None
try:
mailbox = result["postOfficeBox"][0]
except KeyError:
mailbox = None
if address is not None:
db.new_borrower(name, email, phone, address, mailbox, "")
is_borrower = db.is_borrower(email)
db.new_hold_request(is_borrower, recid, barcode, request_from, request_to, status)
db.update_item_status("requested", barcode)
send_email(
fromaddr=CFG_BIBCIRCULATION_LIBRARIAN_EMAIL,
toaddr=CFG_SITE_SUPPORT_EMAIL,
subject="Hold request for books confirmation",
content=hold_request_mail(recid, is_borrower),
attempt_times=1,
attempt_sleeptime=10,
)
message = bibcirculation_templates.tmpl_message_request_send_ok_cern(ln=ln)
else:
message = bibcirculation_templates.tmpl_message_request_send_fail_cern(ln=ln)
else:
message = bibcirculation_templates.tmpl_message_request_send_ok_other(ln=ln)
body = bibcirculation_templates.tmpl_new_request_send(message=message, ln=ln)
return body
