Hi Sonia
We have a report that gives us a list of books that a) have been requested and
b) are on loan and due more than 14 days away. The idea is to run this on a
daily basis and notify the borrowers who have the books on loan.
----
SELECT distinct CONCAT(borrowers1.surname, ", ", borrowers1.firstname) as
"Requesting borrower",
biblio.author,
biblio.title,
CONCAT(borrowers2.surname, ", ", borrowers2.firstname) as "Currently
on loan to",
issues.date_due as "Due Date"
FROM reserves, items, issues, biblio, borrowers borrowers1, borrowers borrowers2
WHERE reserves.biblionumber = items.biblionumber
AND reserves.borrowernumber = borrowers1.borrowernumber
AND reserves.itemnumber = issues.itemnumber
AND issues.borrowernumber = borrowers2.borrowernumber
AND items.biblionumber = biblio.biblionumber
AND issues.date_due > (SELECT DATE_ADD(CURDATE(), INTERVAL 14 DAY))
ORDER BY borrowers1.surname, borrowers1.firstname
----
With kind regards from the Dalton McCaughey Library Team
Carlos Lopez
Dalton McCaughey Library | 29 College Crescent, Parkville, VICTORIA 3052
Ph: 03 9340 8888 ext.1 | libr...@dml.vic.edu.au | library.dmlibrary.org.au
-----Original Message-----
From: Koha <koha-boun...@lists.katipo.co.nz> On Behalf Of Bob Birchall
Sent: Thursday, 27 June 2019 11:48 PM
To: BOUIS Sonia <sonia.bo...@univ-lyon3.fr>
Cc: koha@lists.katipo.co.nz
Subject: Re: [Koha] Notify the borrower when a hold is placed
Hi Sonia,
It sounds like you need a recall system.
An attempt has been made:
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19532
It looks like its not ready yet.
I hope I've interpreted your question correctly.
Bob Birchall
*CALYX*
On Fri, 28 Jun 2019 at 01:17, BOUIS Sonia <sonia.bo...@univ-lyon3.fr> wrote:
> Hi,
> We would like to allow our university teacher to have very long loan
> period. We would like to notify them when a hold is placed on a book that
> they have checked out.
> Do you know if it's possible ?
> Thanks
>
> Cheers
>
> Sonia BOUIS
> ------------------------------------------------------
> Responsable du Service des applications documentaires
> Bibliothèques universitaires
> Université Jean Moulin Lyon 3
> ADRESSE GÉOGRAPHIQUE > Manufacture des Tabacs | 6 cours Albert Thomas |
> LYON 8e
> ADRESSE POSTALE > Bibliothèque de la Manufacture | 1C avenue des Frères
> Lumière | CS 78242 - 69372 LYON CEDEX 08
>
> Ligne directe : 33 (0)4 78 78 79 03
>
> http://bu.univ-lyon3.fr<http://bu.univ-lyon3.fr/>| Suivez-nous > Facebook<
> https://www.facebook.com/bulyon3/> | Twitter<https://twitter.com/bulyon3>|
> Instagram<https://www.instagram.com/bu.lyon3/?hl=fr>
> ---------------------------------------------------
> L'Université Jean Moulin est membre de l'Université de Lyon
>
> _______________________________________________
> Koha mailing list http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
_______________________________________________
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha
--
Click here to report this message as spam:
https://console.mailguard.com.au/ras/1VZWOqYKXe/7ePKoRwH96EihN84rnpCvL/3.3
_______________________________________________
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha
