[Koha] Checkout limit by household

[Katrin]

Hi,

not a complete solution, but maybe an idea for one way to do it:

If you add relationships between the members of one household (guarantor 
and guarantees), you should be able to see in the staff client what the 
other members of the household have checked out when you are in the 
patron account.

Some information about this can be found here:

https://koha-community.org/manual/16.11/html/ch04.html#addnewpatron

Hope this helps,

Katrin

On 20.01.2017 20:56, Mark Alexander wrote:
> Our library (running Mandarin currently) has a limit of two DVDs
> per household.  Mandarin doesn't enforce this limit; the librarian
> knows pretty much everybody in this little town and has the data
> in her head.  But we volunteers don't have that brainpower.
>
> I have been working on a Koha upgrade for our library for some months,
> and am pretty close to having everything working.  But this household
> limit has me a bit stumped.  For one thing, our patron database is a
> bit inconsistent, so if we define "household" as being "all borrowers
> with the same address", we're in trouble because the same address
> might be spelled several different ways.  (For example, Route can be
> RT or RTE or Rte. or Rt. or Rt)
>
> But leaving aside the consistency problem, Koha doesn't seem to have
> a way to do this kind of check.  I can cobble together some SQL that
> looks like this:
>
>    select count(issue_id) from issues
>      left join borrowers on issues.borrowernumber = borrowers.borrowernumber
>      left join items on issues.itemnumber = items.itemnumber
>      where borrowers.address = '123 Main Street'
>      and city = 'Podunk'
>      and state = 'VT'
>      and items.itype = 'DVD';
>
> and then check this result against configurable checkout limits for
> particular item types.  This sounds like a fair amount of work in the
> Koha codebase itself, so I was wondering if anybody else had looked
> into this and had other ideas.
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha