Bugzilla – Attachment 158037 Details for
Bug 32312
Complete database column descriptions for circulation module in guided reports
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 32312: Add missing column descriptions to the statistics table
Bug-32312-Add-missing-column-descriptions-to-the-s.patch (text/plain), 8.63 KB, created by
Katrin Fischer
on 2023-10-29 11:39:33 UTC
(
hide
)
Description:
Bug 32312: Add missing column descriptions to the statistics table
Filename:
MIME Type:
Creator:
Katrin Fischer
Created:
2023-10-29 11:39:33 UTC
Size:
8.63 KB
patch
obsolete
>From e4915643d982050e84c22bf876b9b86f392f1023 Mon Sep 17 00:00:00 2001 >From: David Nind <david@davidnind.com> >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 <david@davidnind.com> >Signed-off-by: Andrew Fuerste-Henry <andrewfh@dubcolib.org> >Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com> >Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de> >--- > 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.30.2
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 32312
:
144415
|
144532
|
145875
| 158037