From 06c8ea255f016a06b57ba4093390f7323414edb4 Mon Sep 17 00:00:00 2001 From: David Nind Date: Sun, 4 Dec 2022 01:33:32 +0000 Subject: [PATCH] Bug 32312: Add missing column descriptions to the statistics table This adds missing descriptions to the existing statistics database columns. It also improves some existing descriptions. 1. Go to Reports > Guided reports > Create guided report. 2. Choose 'Circulation' for the module to report on and select 'Next'. 3. Choose 'Tabular' for the type of report and select 'Next'. 4. Scroll down to the statistics table section and note that there are no descriptions for: - statistics.other - statistics.location - statistics.ccode - statistics.categorycode 5. Note that: - the description for statistics.type is 'Type' - the description for statistics.itemtype is 'Item type' 6. Apply the patch. 7. Restart all the things (restart_all). 8. Reload the page. 9. Note that: . there are now descriptions for the columns in step 4 . the description for statistics.type is now 'Transaction type' (to more clearly indicate what it contains) . the description for statistics.itemtype is now 'Koha item type' (consistent with other tables where this is used, such as items) 10. Sign off :D Signed-off-by: David Nind Signed-off-by: Andrew Fuerste-Henry Signed-off-by: Martin Renvoize Signed-off-by: Katrin Fischer Signed-off-by: Tomas Cohen Arazi (cherry picked from commit b0a8372c2f5eec6dd1671c0557bb82e3a71436db) Signed-off-by: Fridolin Somers (cherry picked from commit a530cf3088195da651e4cccd09809e898f9e0ee2) Signed-off-by: Matt Blenkinsop --- Koha/Database/Columns.pm | 83 +++++++++++++++++++++++----------------- 1 file changed, 47 insertions(+), 36 deletions(-) diff --git a/Koha/Database/Columns.pm b/Koha/Database/Columns.pm index 6b46a1bc39..f5c45af5de 100644 --- a/Koha/Database/Columns.pm +++ b/Koha/Database/Columns.pm @@ -197,52 +197,63 @@ sub columns { "zipcode" => __("ZIP/Postal code"), }, items => { - "barcode" => __("Barcode"), "biblioitemnumber" => __("Biblioitem number (internal)"), - "biblionumber" => __("Biblio number (internal)"), - "booksellerid" => __("Source of acquisition"), - "ccode" => __("Collection"), - "cn_sort" => __("Koha normalized classification for sorting"), - "cn_source" => __("Source of classification / shelving scheme"), - "coded_location_qualifier" => __("Coded location qualifier"), - "copynumber" => __("Copy number"), - "damaged_on" => __("Damaged on"), - "damaged" => __("Damaged status"), + "barcode" => __("Barcode"), "dateaccessioned" => __("Date acquired"), + "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"), - "deleted_on" => __("Date of deletion"), - "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_on" => __("Lost on"), + "stack" => __("Shelving control number"), + "notforloan" => __("Not for loan"), + "damaged" => __("Damaged status"), + "damaged_on" => __("Damaged on"), "itemlost" => __("Lost status"), - "itemnotes_nonpublic" => __("Internal note"), + "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"), - "itemnumber" => __("Item number (internal)"), - "itype" => __("Koha item type"), + "itemnotes_nonpublic" => __("Internal note"), + "holdingbranch" => __("Current library"), + "timestamp" => __("Timestamp"), + "deleted_on" => __("Deleted on"), "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)"), - "new_status" => __("New status"), - "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"), + "enumchron" => __("Serial enumeraton/chronology"), + "copynumber" => __("Copy number"), "stocknumber" => __("Inventory number"), - "timestamp" => __("Timestamp"), - "uri" => __("Uniform resource identifier"), - "withdrawn_on" => __("Withdrawn on"), - "withdrawn" => __("Withdrawn status"), + "new_status" => __("New status"), + "exclude_from_local_holds_priority" => __("Exclude from local holds priority"), + }, + statistics => { + "datetime" => __("Statistics date and time"), + "branch" => __("Library"), + "value" => __("Value"), + "type" => __("Transaction type"), + "other" => __("SIP mode"), + "itemnumber" => __("Item number"), + "itemtype" => __("Koha item type"), + "location" => __("Shelving location"), + "borrowernumber" => __("Borrower number"), + "ccode" => __("Collection"), + "categorycode" => __("Patron category"), }, biblio => { "abstract" => __("Abstract"), -- 2.20.1