https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9599 Alexander Wagner <alexander.wagner@desy.de> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |alexander.wagner@desy.de --- Comment #10 from Alexander Wagner <alexander.wagner@desy.de> --- I worked on this recently as it is required for our internal workflows at the library. My approach (kindly hinted at by @cait ;) uses a report in conjunction with notices and slips. As in the end I want to call it from the intranet catalog, I know the biblio number of the record displayed. This is fed to a report: ```sql SELECT biblio.*, biblioitems.*, items.*, ExtractValue(biblio_metadata.metadata, '//datafield[@tag="035"]/subfield[@code="a"]') AS nsk, ExtractValue(biblio_metadata.metadata, '//datafield[@tag="082"]/subfield[@code="a"]') AS ddc, ExtractValue(biblio_metadata.metadata, '//datafield[@tag="083"]/subfield[@code="a"]') AS oddc FROM items LEFT JOIN biblioitems on (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio on (biblioitems.biblionumber=biblio.biblionumber) LEFT JOIN biblio_metadata on (biblio_metadata.biblionumber=biblio.biblionumber) WHERE biblio.biblionumber IN <<Biblionumber|list>> ``` Then this report is then "run with template" so it displays via some nice slip. The latter consist of a few lines of HTML and CSS, and fills in the required values from the bibliographic record and uses a few form elements like check boxes to mark what has been done already. If it's "good enough" to call up the report, add the biblio numbers (or scan barcodes with a slightly modified sql) and then click through to `run` and then `run with template`, this can be done with just the stuff that exists in Koha already. For us I wanted to have a simple menu, from which we can select the form (we actually have more than one of this kind) so I glued it together with a rather simple (and still a bit rough) plugin that hooks up with `intranet_catalog_biblio_enhancements_toolbar_button`. This allows to have a menu right from the catalogue intranet and call up the work slip from there right up to display in the template. (So it's just one click.) -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.