Bugzilla – Attachment 166917 Details for
Bug 32313
Complete database column descriptions for cataloguing module in guided reports
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 32313: Update guided reports column descriptions for items and biblioitems tables
Bug-32313-Update-guided-reports-column-description.patch (text/plain), 14.98 KB, created by
David Nind
on 2024-05-19 03:05:35 UTC
(
hide
)
Description:
Bug 32313: Update guided reports column descriptions for items and biblioitems tables
Filename:
MIME Type:
Creator:
David Nind
Created:
2024-05-19 03:05:35 UTC
Size:
14.98 KB
patch
obsolete
>From f07a34e3c7e954cbc2b4f10d03ac4fcc995422ca Mon Sep 17 00:00:00 2001 >From: David Nind <david@davidnind.com> >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 <david@davidnind.com> >--- > 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
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 32313
:
166917
|
168017
|
168076