[Koha] Show suspension days left

Chris Cormack chrisc at catalyst.net.nz
Sat Dec 3 13:43:29 NZDT 2011

* anjoze (joseanjos at gmail.com) wrote:
>    Hi again, When I try to checkout an Item to a suspended Patron I receive
>    the message saying: Patron has had overdue items and is blocked for XX
>    day(s). If I try to checkout again on the next day, it will show the same
>    number of days. Until the end of the suspended period it shows the same
>    number of days! So, if a few days later that Patron ask me how many days
>    left, I can't tell him :( Is there a way to show the suspension remaining
>    days? Or Is it possible to build a report with that info? Thank you very
>    much, JA

If you are running 3.4.x or 3.6.x then yes, you can find that
information in the debarred column in the borrowers table.

It stores the date of when the suspension ends, so you could do a
report like this

SELECT debarred FROM borrowers WHERE cardnumber = <<cardnumber>>

Then when you run it, it will prompt you for a cardnumber if you enter
that you get the date the person is suspended until.

Or you could do something like

SELECT firstname,lastname,cardnumber,debarred FROM borrowers WHERE
debarred IS NOT NULL

Which will get you a list of them all.

Also, you might like to look on http://bugs.koha-community.org and
file an enhancement request to get the date suspended to showing on
the borrower record, if a request doesn't already exist.
Also, I haven't checked the latest version, it may show the date already


>    -------------------------------------------
>    View this message in context: Show suspension days left
>    Sent from the Koha-general mailing list archive at Nabble.com.

> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha

Chris Cormack
Catalyst IT Ltd.
+64 4 803 2238
PO Box 11-053, Manners St, Wellington 6142, New Zealand
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 198 bytes
Desc: Digital signature
URL: <http://lists.katipo.co.nz/pipermail/koha/attachments/20111203/695af974/attachment.pgp>

More information about the Koha mailing list