Dear Koha community!
At our school we started working with koha. One challenge is to get the
appropriate overdue report.
For each pupil we have assigned the responsible teacher as the guarator.
What we would like to have is a overdue report like this (modified from
the sql report library):
SELECT p.guarantorid, p.surname, p.firstname,
c.issuedate, c.date_due,
(TO_DAYS(curdate())-TO_DAYS( date_due)) AS 'days overdue',
b.title,
i.barcode
FROM borrowers p
LEFT JOIN issues c ON (p.borrowernumber=c.borrowernumber)
LEFT JOIN items i ON (c.itemnumber=i.itemnumber)
LEFT JOIN biblio b ON (i.biblionumber=b.biblionumber)
WHERE c.branchcode = <<branchcode>> AND
(TO_DAYS(curdate())-TO_DAYS( date_due)) > 0
ORDER BY p.guarantorid ASC, p.surname ASC, c.date_due ASC
but with the guarantor name not the ID number as the first column.
Any hints for me how the proceed.
Thanks in advance
all the best
Marcel
_______________________________________________
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha
