From f07a34e3c7e954cbc2b4f10d03ac4fcc995422ca Mon Sep 17 00:00:00 2001 From: David Nind Date: Sun, 19 May 2024 02:56:56 +0000 Subject: [PATCH] Bug 32313: Update guided reports column descriptions for items and biblioitems tables This adds missing column descriptions to the items and biblioitems tables (used in guided reports for the Circulation, Catalog, Acquisitions, and Serials modules). It also updates some existing descriptions for consistency, removes biblioitems columns that no longer exist, and sorts items and statistics descriptions in the source file in alphabetical order. Test plan: 1. Go to Reports > Guided reports > Create guided report. 2. Choose 'Catalog' for the module to report on, and then select 'Next'. 3. Choose 'Tabular' for the type of report and select 'Next'. 4. Note that there are no descriptions for these column names (proposed column names shown in brackets): - items.itemnumber (Koha item number (autogenerated)) - items.biblionumber (Biblio number (internal)) - items.bookable (Bookable) - items.localuse (Total local uses) - biblioitems.ean (EAN) - biblioitems.collectiontitle (Series statement) - biblioitems.collectionissn (Series ISSN) - biblioitems.collectionvolume (Series volume) - biblioitems.editionstatement (Edition statement) - biblioitems.editionresponsibility (Edition responsibility) - biblioitems.cn_source (Source of classification or shelving scheme) - biblioitems.cn_class (Classification part) - biblioitems.cn_item (Item part) - biblioitems.cn_suffix (Call number suffix) - biblioitems.cn_sort (Koha normalized classification for sorting) - biblioitems.totalissues (Koha issues (borrowed), all copies) 5. Apply the patch. 6. Restart all the things (restart_all). 7. Reload the page. 8. Note that there are now descriptions for the columns in step 4. 9. Note that the descriptions for these columns are changed (for consistency with other tables, or clarification): - items.itype => Koha item type (previously Koha itemtype) - items.timestamp => Modification date (previously Timestamp) - biblioitems.timestamp => Modification date (previously Timestamp) - biblioitems.illus => Other physical details (previously Illustrations) - biblioitems.biblioitemnumber => Biblio item number (internal) (previously Biblioitem number) - biblioitems.biblionumber (and also acqorders.biblionumber and biblio.biblionumber) => Biblio number (internal) (previously Biblio number) 10. Sign off :D Signed-off-by: David Nind --- Koha/Database/Columns.pm | 146 +++++++++++++++++++++------------------ 1 file changed, 79 insertions(+), 67 deletions(-) diff --git a/Koha/Database/Columns.pm b/Koha/Database/Columns.pm index a7fb1a5e47..8c69f6c334 100644 --- a/Koha/Database/Columns.pm +++ b/Koha/Database/Columns.pm @@ -62,7 +62,7 @@ sub columns { return { aqorders => { "basketno" => __("Basket ID (internal)"), - "biblionumber" => __("Biblionumber (internal)"), + "biblionumber" => __("Biblio number (internal)"), "budget_id" => __("Fund ID (internal)"), "budgetdate" => __("Not used (deprecated)"), "cancellationreason" => __("Cancellation reason"), @@ -197,55 +197,59 @@ sub columns { "zipcode" => __("ZIP/Postal code"), }, items => { - "biblioitemnumber" => __("Biblioitem number (internal)"), "barcode" => __("Barcode"), - "dateaccessioned" => __("Date acquired"), + "biblioitemnumber" => __("Biblio item number (internal)"), + "biblionumber" => __("Biblio number (internal)"), + "bookable" => __("Bookable"), "booksellerid" => __("Source of acquisition"), - "homebranch" => __("Permanent library"), - "price" => __("Price"), - "replacementprice" => __("Replacement price"), - "replacementpricedate" => __("Price effective from"), - "datelastborrowed" => __("Date last checked out"), - "datelastseen" => __("Date last seen"), - "stack" => __("Shelving control number"), - "notforloan" => __("Not for loan"), + "ccode" => __("Collection"), + "cn_sort" => __("Koha normalized classification for sorting"), + "cn_source" => __("Source of classification or shelving scheme"), + "coded_location_qualifier" => __("Coded location qualifier"), + "copynumber" => __("Copy number"), "damaged" => __("Damaged status"), "damaged_on" => __("Damaged on"), + "dateaccessioned" => __("Date acquired"), + "datelastborrowed" => __("Date last checked out"), + "datelastseen" => __("Date last seen"), + "deleted_on" => __("Deleted on"), + "enumchron" => __("Serial enumeraton/chronology"), + "exclude_from_local_holds_priority" => __("Exclude from local holds priority"), + "holdingbranch" => __("Current library"), + "homebranch" => __("Permanent library"), + "issues" => __("Total checkouts"), + "itemcallnumber" => __("Call number"), "itemlost" => __("Lost status"), "itemlost_on" => __("Lost on"), - "withdrawn" => __("Withdrawn status"), - "withdrawn_on" => __("Withdrawn on"), - "itemcallnumber" => __("Call number"), - "coded_location_qualifier" => __("Coded location qualifier"), - "issues" => __("Total checkouts"), - "renewals" => __("Total renewals"), - "reserves" => __("Total holds"), - "restricted" => __("Use restrictions"), "itemnotes" => __("Public note"), "itemnotes_nonpublic" => __("Internal note"), - "holdingbranch" => __("Current library"), - "timestamp" => __("Timestamp"), - "deleted_on" => __("Deleted on"), + "itemnumber" => __("Koha item number (autogenerated)"), + "itype" => __("Koha item type"), + "localuse" => __("Total local uses"), "location" => __("Shelving location"), - "permanent_location" => __("Permanent shelving location"), - "onloan" => __("Due date"), - "cn_source" => __("Source of classification / shelving scheme"), - "cn_sort" => __("Koha normalized classification for sorting"), - "ccode" => __("Collection"), "materials" => __("Materials specified"), - "uri" => __("Uniform Resource Identifier"), - "itype" => __("Koha itemtype"), "more_subfields_xml" => __("Additional subfields (XML)"), - "enumchron" => __("Serial enumeraton/chronology"), - "copynumber" => __("Copy number"), - "stocknumber" => __("Inventory number"), "new_status" => __("New status"), - "exclude_from_local_holds_priority" => __("Exclude from local holds priority"), + "notforloan" => __("Not for loan"), + "onloan" => __("Due date"), + "permanent_location" => __("Permanent shelving location"), + "price" => __("Price"), + "renewals" => __("Total renewals"), + "replacementprice" => __("Replacement price"), + "replacementpricedate" => __("Price effective from"), + "reserves" => __("Total holds"), + "restricted" => __("Use restrictions"), + "stack" => __("Shelving control number"), + "stocknumber" => __("Inventory number"), + "timestamp" => __("Modification date"), + "uri" => __("Uniform Resource Identifier"), + "withdrawn" => __("Withdrawn status"), + "withdrawn_on" => __("Withdrawn on"), }, biblio => { "abstract" => __("Abstract"), "author" => __("Author"), - "biblionumber" => __("Biblio number"), + "biblionumber" => __("Biblio number (internal)"), "copyrightdate" => __("Copyright date"), "datecreated" => __("Creation date"), "frameworkcode" => __("Framework code"), @@ -261,44 +265,52 @@ sub columns { "unititle" => __("Uniform title"), }, biblioitems => { - "agerestriction" => __("Age restriction"), - "biblioitemnumber" => __("Biblioitem number"), - "biblionumber" => __("Biblio number"), - "classification" => __("Classification"), - "dewey" => __("Dewey/classification"), - "illus" => __("Illustrations"), - "isbn" => __("ISBN"), - "issn" => __("ISSN"), - "itemtype" => __("Biblio-level item type"), - "lccn" => __("LCCN"), - "notes" => __("Notes"), - "number" => __("Number"), - "pages" => __("Number of pages"), - "place" => __("Place of publication"), - "publicationyear" => __("Publication date"), - "publishercode" => __("Publisher"), - "size" => __("Size"), - "subclass" => __("Sub classification"), - "timestamp" => __("Timestamp"), - "title" => __("Title"), - "url" => __("URL"), - "volume" => __("Volume number"), - "volumedate" => __("Volume date"), - "volumedesc" => __("Volume information"), + "agerestriction" => __("Age restriction"), + "biblioitemnumber" => __("Biblio item number (internal)"), + "biblionumber" => __("Biblio number (internal)"), + "cn_class" => __("Classification part"), + "cn_item" => __("Item part"), + "cn_sort" => __("Koha normalized classification for sorting"), + "cn_source" => __("Source of classification or shelving scheme"), + "cn_suffix" => __("Call number suffix"), + "collectiontitle" => __("Series statement"), + "collectionissn" => __("Series ISSN"), + "collectionvolume" => __("Series volume"), + "ean" => __("EAN"), + "editionresponsibility" => __("Edition responsibility"), + "editionstatement" => __("Edition statement"), + "illus" => __("Other physical details"), + "isbn" => __("ISBN"), + "issn" => __("ISSN"), + "itemtype" => __("Biblio-level item type"), + "lccn" => __("LCCN"), + "notes" => __("Notes"), + "number" => __("Number"), + "pages" => __("Number of pages"), + "place" => __("Place of publication"), + "publicationyear" => __("Publication date"), + "publishercode" => __("Publisher"), + "size" => __("Size"), + "timestamp" => __("Modification date"), + "totalissues" => __("Koha issues (borrowed), all copies"), + "url" => __("URL"), + "volume" => __("Volume number"), + "volumedate" => __("Volume date"), + "volumedesc" => __("Volume information"), }, statistics => { - "datetime" => __("Statistics date and time"), + "borrowernumber" => __("Borrower number"), "branch" => __("Library"), - "value" => __("Value"), - "type" => __("Transaction type"), - "other" => __("SIP mode"), + "categorycode" => __("Patron category"), + "ccode" => __("Collection"), + "datetime" => __("Statistics date and time"), + "interface" => __("Interface"), "itemnumber" => __("Item number"), "itemtype" => __("Koha item type"), "location" => __("Shelving location"), - "borrowernumber" => __("Borrower number"), - "ccode" => __("Collection"), - "categorycode" => __("Patron category"), - "interface" => __("Interface"), + "other" => __("SIP mode"), + "type" => __("Transaction type"), + "value" => __("Value"), }, subscription => { "branchcode" => __("Library"), @@ -314,7 +326,7 @@ sub columns { "collectiontitle" => __("Collection title"), "copyrightdate" => __("Copyright date"), "isbn" => __("ISBN"), - "itemtype" => __("Item type"), + "itemtype" => __("Koha item type"), "note" => __("Note"), "patronreason" => __("Patron reason"), "place" => __("Place of publication"), -- 2.39.2