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@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha