[Koha-bugs] [Bug 12670] Show materials label instead of code

[bugzilla-daemon at bugs.koha-community.org]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12670

--- Comment #13 from Frédéric Demians <frederic at tamil.fr> ---
(In reply to Katrin Fischer from comment #12)
> I was using the default framework. I have a feeling like we should test that
> the routine actually returns an AV, but I haven't taken a closer look.
> 
> The check-in/check-out messages could be fixed in a separate bug, but I
> think we should aim to make this a complete feature.

Looking closely at the code (detail.pl), It seems that code refactoring should
be welcome on the way all AV are decoded... For a lot of fields,
GetKohaAuhtorisedValues/GetAuthValCode are called: location, ccode, copynumber,
itemlost, damaged, etc. We could have a new function doing all the decoding in
once:

  DecodeAuthValues( $item, $fw, qw/ items.location items. ccode / );

And in C4::Koha, authorized values are not cached... So it means that if we
have to display, let say, 30 items, having each 5 AV, 150 SQL queries are sent
to MySQL.

-- 
You are receiving this mail because:
You are watching all bug changes.