Koha/Database/Columns.pm

   1 package Koha::Database::Columns;
   2
   3 # This file is part of Koha.
   4 #
   5 # Koha is free software; you can redistribute it and/or modify it
   6 # under the terms of the GNU General Public License as published by
   7 # the Free Software Foundation; either version 3 of the License, or
   8 # (at your option) any later version.
   9 #
  10 # Koha is distributed in the hope that it will be useful, but
  11 # WITHOUT ANY WARRANTY; without even the implied warranty of
  12 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
  13 # GNU General Public License for more details.
  14 #
  15 # You should have received a copy of the GNU General Public License
  16 # along with Koha; if not, see <http://www.gnu.org/licenses>.
  17
  18 use Modern::Perl;
  19 use Koha::I18N qw( __ );
  20
  21 =head1 NAME
  22
  23 Koha::Database::Columns
  24
  25 =head1 SYNOPSIS
  26
  27   use Koha::Database::Columns;
  28   my $columns = Koha::Database::Columns->columns;
  29
  30 =head1 API
  31
  32 =head2 Methods
  33
  34 =head3 columns
  35
  36 Static method that returns a hashref with mappings from column names
  37 to descriptions, for several tables. Currently
  38
  39 =over
  40
  41 =item biblio
  42
  43 =item biblioitems
  44
  45 =item borrowers
  46
  47 =item items
  48
  49 =item statistics
  50
  51 =item subscription
  52
  53 =item suggestion
  54
  55 =back
  56
  57 =cut
  58
  59 sub columns {
  60     return {
  61         borrowers => {
  62             "borrowernumber"      => __("Borrower number"),
  63             "title"               => __("Salutation"),
  64             "surname"             => __("Surname"),
  65             "firstname"           => __("First name"),
  66             "middle_name"         => __("Middle name"),
  67             "dateofbirth"         => __("Date of birth"),
  68             "initials"            => __("Initials"),
  69             "pronouns"            => __("Pronouns"),
  70             "othernames"          => __("Other name"),
  71             "sex"                 => __("Gender"),
  72             "relationship"        => __("Relationship"),
  73             "streetnumber"        => __("Street number"),
  74             "streettype"          => __("Street type"),
  75             "address"             => __("Address"),
  76             "address2"            => __("Address 2"),
  77             "city"                => __("City"),
  78             "state"               => __("State"),
  79             "zipcode"             => __("ZIP/Postal code"),
  80             "country"             => __("Country"),
  81             "phone"               => __("Primary phone"),
  82             "phonepro"            => __("Secondary phone"),
  83             "mobile"              => __("Other phone"),
  84             "email"               => __("Primary email"),
  85             "emailpro"            => __("Secondary email"),
  86             "fax"                 => __("Fax"),
  87             "B_streetnumber"      => __("Alternate address: Street number"),
  88             "B_streettype"        => __("Alternate address: Street type"),
  89             "B_address"           => __("Alternate address: Address"),
  90             "B_address2"          => __("Alternate address: Address 2"),
  91             "B_city"              => __("Alternate address: City"),
  92             "B_state"             => __("Alternate address: State"),
  93             "B_zipcode"           => __("Alternate address: ZIP/Postal code"),
  94             "B_country"           => __("Alternate address: Country"),
  95             "B_phone"             => __("Alternate address: Phone"),
  96             "B_email"             => __("Alternate address: Email"),
  97             "contactnote"         => __("Alternate contact: Note"),
  98             "altcontactfirstname" => __("Alternate contact: First name"),
  99             "altcontactsurname"   => __("Alternate contact: Surname"),
 100             "altcontactaddress1"  => __("Alternate contact: Address"),
 101             "altcontactaddress2"  => __("Alternate contact: Address 2"),
 102             "altcontactaddress3"  => __("Alternate contact: City"),
 103             "contactname"         => __("Alternate contact: Surname"),
 104             "contactfirstname"    => __("Alternate contact: First name"),
 105             "contacttitle"        => __("Alternate contact: Title"),
 106             "altcontactstate"     => __("Alternate contact: State"),
 107             "altcontactzipcode"   => __("Alternate contact: ZIP/Postal code"),
 108             "altcontactcountry"   => __("Alternate contact: Country"),
 109             "altcontactphone"     => __("Alternate contact: Phone"),
 110             "cardnumber"          => __("Card number"),
 111             "branchcode"          => __("Home library"),
 112             "categorycode"        => __("Patron category"),
 113             "sort1"               => __("Sort 1"),
 114             "sort2"               => __("Sort 2"),
 115             "dateenrolled"        => __("Registration date"),
 116             "dateexpiry"          => __("Expiry date"),
 117             "opacnote"            => __("OPAC note"),
 118             "borrowernotes"       => __("Circulation note"),
 119             "userid"              => __("Username"),
 120             "password"            => __("Password"),
 121             "flags"               => __("System permissions"),
 122             "gonenoaddress"       => __("Gone no address flag"),
 123             "lost"                => __("Lost card flag"),
 124             "debarred"            => __("Restricted [until] flag"),
 125             "debarredcomment"     => __("Comment"),
 126             "smsalertnumber"      => __("Mobile phone number"),
 127             "privacy"             => __("Privacy settings"),
 128             "autorenew_checkouts" => __("Allow auto-renewals"),
 129         },
 130         items => {
 131             "itemnumber"           => __("Item number (internal)"),
 132             "biblionumber"         => __("Biblio number (internal)"),
 133             "biblioitemnumber"     => __("Biblioitem number (internal)"),
 134             "barcode"              => __("Barcode"),
 135             "dateaccessioned"      => __("Date acquired"),
 136             "booksellerid"         => __("Source of acquisition"),
 137             "homebranch"           => __("Permanent library"),
 138             "price"                => __("Price"),
 139             "replacementprice"     => __("Replacement price"),
 140             "replacementpricedate" => __("Price effective from"),
 141             "datelastborrowed"     => __("Date last checked out"),
 142             "datelastseen"         => __("Date last seen"),
 143             "stack"                => __("Shelving control number"),
 144             "onloan"               => __("Due date"),
 145             "cn_source"            => __("Source of classification / shelving scheme"),
 146             "cn_sort"              => __("Koha normalized classification for sorting"),
 147             "notforloan"           => __("Not for loan"),
 148             "itemlost"             => __("Lost status"),
 149             "itemlost_on"          => __("Lost on"),
 150             "withdrawn"            => __("Withdrawn status"),
 151             "withdrawn_on"         => __("Withdrawn on"),
 152             "itemcallnumber"       => __("Call number"),
 153             "issues"               => __("Total checkouts"),
 154             "renewals"             => __("Total renewals"),
 155             "reserves"             => __("Total holds"),
 156             "restricted"           => __("Use restrictions"),
 157             "itemnotes"            => __("Public note"),
 158             "itemnotes_nonpublic"  => __("Internal note"),
 159             "holdingbranch"        => __("Current library"),
 160             "timestamp"            => __("Timestamp"),
 161             "location"             => __("Shelving location"),
 162             "permanent_location"   => __("Permanent shelving location"),
 163             "ccode"                => __("Collection"),
 164             "itype"                => __("Koha itemtype"),
 165             "stocknumber"          => __("Inventory number"),
 166             "damaged"              => __("Damaged status"),
 167             "damaged_on"           => __("Damaged on"),
 168             "materials"            => __("Materials specified"),
 169             "uri"                  => __("Uniform Resource Identifier"),
 170             "more_subfields_xml"   => __("Additional subfields (XML)"),
 171             "enumchron"            => __("Serial enumeraton/chronology"),
 172             "copynumber"           => __("Copy number"),
 173             "new_status"           => __("New status"),
 174         },
 175         statistics => {
 176             "datetime"       => __("Statistics date and time"),
 177             "branch"         => __("Library"),
 178             "value"          => __("Value"),
 179             "type"           => __("Type"),
 180             "other"          => __(""),
 181             "itemnumber"     => __("Item number"),
 182             "itemtype"       => __("Itemtype"),
 183             "borrowernumber" => __("Borrower number"),
 184         },
 185         biblio => {
 186             "frameworkcode" => __("Framework code"),
 187             "author"        => __("Author"),
 188             "datecreated"   => __("Creation date"),
 189             "timestamp"     => __("Modification date"),
 190         },
 191         biblioitems => {
 192             "biblioitemnumber" => __("Biblioitem number"),
 193             "biblionumber"     => __("Biblio number"),
 194             "volume"           => __("Volume number"),
 195             "number"           => __("Number"),
 196             "classification"   => __("Classification"),
 197             "itemtype"         => __("Biblio-level item type"),
 198             "isbn"             => __("ISBN"),
 199             "issn"             => __("ISSN"),
 200             "dewey"            => __("Dewey/classification"),
 201             "subclass"         => __("Sub classification"),
 202             "publicationyear"  => __("Publication date"),
 203             "publishercode"    => __("Publisher"),
 204             "volumedate"       => __("Volume date"),
 205             "volumedesc"       => __("Volume information"),
 206             "timestamp"        => __("Timestamp"),
 207             "illus"            => __("Illustrations"),
 208             "pages"            => __("Number of pages"),
 209             "notes"            => __("Notes"),
 210             "size"             => __("Size"),
 211             "place"            => __("Place of publication"),
 212             "lccn"             => __("LCCN"),
 213             "agerestriction"   => __("Age restriction"),
 214             "url"              => __("URL"),
 215             "title"            => __("Title"),
 216         },
 217         subscription => {
 218             "startdate"   => __("Start date"),
 219             "enddate"     => __("End date"),
 220             "periodicity" => __("Periodicity"),
 221             "callnumber"  => __("Call number"),
 222             "location"    => __("Location"),
 223             "branchcode"  => __("Library"),
 224         },
 225         suggestions=> {
 226             "author"          => __("author"),
 227             "copyrightdate"   => __("copyrightdate"),
 228             "isbn"            => __("isbn"),
 229             "publishercode"   => __("publishercode"),
 230             "collectiontitle" => __("collectiontitle"),
 231             "place"           => __("place"),
 232             "quantity"        => __("quantity"),
 233             "itemtype"        => __("itemtype"),
 234             "branchcode"      => __("branchcode"),
 235             "patronreason"    => __("patronreason"),
 236             "note"            => __("note"),
 237             "title"           => __("title"),
 238         }
 239     };
 240 }
 241
 242 1;