| 
      
            Line 0
          
      
      
        Link Here
      
     | 
  
            
               | 
               | 
              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 | 
              =head1 NAME  | 
            
            
              | 19 | 
               | 
            
            
              | 20 | 
              Koha::Database::Columns  | 
            
            
              | 21 | 
               | 
            
            
              | 22 | 
              =head1 SYNOPSIS  | 
            
            
              | 23 | 
               | 
            
            
              | 24 | 
                use Koha::Database::Columns;  | 
            
            
              | 25 | 
               | 
            
            
              | 26 | 
              =head1 FUNCTIONS  | 
            
            
              | 27 | 
               | 
            
            
              | 28 | 
              =cut  | 
            
            
              | 29 | 
               | 
            
            
              | 30 | 
              use Modern::Perl;  | 
            
            
              | 31 | 
              use Koha::I18N qw( __ );  | 
            
            
              | 32 | 
               | 
            
            
              | 33 | 
              sub columns { | 
            
            
              | 34 | 
                  return { | 
            
            
              | 35 | 
                      borrowers => { | 
            
            
              | 36 | 
                          "borrowernumber"      => __("Borrower number"), | 
            
            
              | 37 | 
                          "title"               => __("Salutation"), | 
            
            
              | 38 | 
                          "surname"             => __("Surname"), | 
            
            
              | 39 | 
                          "firstname"           => __("First name"), | 
            
            
              | 40 | 
                          "dateofbirth"         => __("Date of birth"), | 
            
            
              | 41 | 
                          "initials"            => __("Initials"), | 
            
            
              | 42 | 
                          "othernames"          => __("Other name"), | 
            
            
              | 43 | 
                          "sex"                 => __("Gender"), | 
            
            
              | 44 | 
                          "relationship"        => __("Relationship"), | 
            
            
              | 45 | 
                          "streetnumber"        => __("Street number"), | 
            
            
              | 46 | 
                          "streettype"          => __("Street type"), | 
            
            
              | 47 | 
                          "address"             => __("Address"), | 
            
            
              | 48 | 
                          "address2"            => __("Address 2"), | 
            
            
              | 49 | 
                          "city"                => __("City"), | 
            
            
              | 50 | 
                          "state"               => __("State"), | 
            
            
              | 51 | 
                          "zipcode"             => __("ZIP/Postal code"), | 
            
            
              | 52 | 
                          "country"             => __("Country"), | 
            
            
              | 53 | 
                          "phone"               => __("Primary phone"), | 
            
            
              | 54 | 
                          "phonepro"            => __("Secondary phone"), | 
            
            
              | 55 | 
                          "mobile"              => __("Other phone"), | 
            
            
              | 56 | 
                          "email"               => __("Primary email"), | 
            
            
              | 57 | 
                          "emailpro"            => __("Secondary email"), | 
            
            
              | 58 | 
                          "fax"                 => __("Fax"), | 
            
            
              | 59 | 
                          "B_streetnumber"      => __("Alternate address: Street number"), | 
            
            
              | 60 | 
                          "B_streettype"        => __("Alternate address: Street type"), | 
            
            
              | 61 | 
                          "B_address"           => __("Alternate address: Address"), | 
            
            
              | 62 | 
                          "B_address2"          => __("Alternate address: Address 2"), | 
            
            
              | 63 | 
                          "B_city"              => __("Alternate address: City"), | 
            
            
              | 64 | 
                          "B_state"             => __("Alternate address: State"), | 
            
            
              | 65 | 
                          "B_zipcode"           => __("Alternate address: ZIP/Postal code"), | 
            
            
              | 66 | 
                          "B_country"           => __("Alternate address: Country"), | 
            
            
              | 67 | 
                          "B_phone"             => __("Alternate address: Phone"), | 
            
            
              | 68 | 
                          "B_email"             => __("Alternate address: Email"), | 
            
            
              | 69 | 
                          "contactnote"         => __("Alternate contact: Note"), | 
            
            
              | 70 | 
                          "altcontactfirstname" => __("Alternate contact: First name"), | 
            
            
              | 71 | 
                          "altcontactsurname"   => __("Alternate contact: Surname"), | 
            
            
              | 72 | 
                          "altcontactaddress1"  => __("Alternate contact: Address"), | 
            
            
              | 73 | 
                          "altcontactaddress2"  => __("Alternate contact: Address 2"), | 
            
            
              | 74 | 
                          "altcontactaddress3"  => __("Alternate contact: City"), | 
            
            
              | 75 | 
                          "contactname"         => __("Alternate contact: Surname"), | 
            
            
              | 76 | 
                          "contactfirstname"    => __("Alternate contact: First name"), | 
            
            
              | 77 | 
                          "contacttitle"        => __("Alternate contact: Title"), | 
            
            
              | 78 | 
                          "altcontactstate"     => __("Alternate contact: State"), | 
            
            
              | 79 | 
                          "altcontactzipcode"   => __("Alternate contact: ZIP/Postal code"), | 
            
            
              | 80 | 
                          "altcontactcountry"   => __("Alternate contact: Country"), | 
            
            
              | 81 | 
                          "altcontactphone"     => __("Alternate contact: Phone"), | 
            
            
              | 82 | 
                          "cardnumber"          => __("Card number"), | 
            
            
              | 83 | 
                          "branchcode"          => __("Home library"), | 
            
            
              | 84 | 
                          "categorycode"        => __("Patron category"), | 
            
            
              | 85 | 
                          "sort1"               => __("Sort 1"), | 
            
            
              | 86 | 
                          "sort2"               => __("Sort 2"), | 
            
            
              | 87 | 
                          "dateenrolled"        => __("Registration date"), | 
            
            
              | 88 | 
                          "dateexpiry"          => __("Expiry date"), | 
            
            
              | 89 | 
                          "opacnote"            => __("OPAC note"), | 
            
            
              | 90 | 
                          "borrowernotes"       => __("Circulation note"), | 
            
            
              | 91 | 
                          "userid"              => __("Username"), | 
            
            
              | 92 | 
                          "password"            => __("Password"), | 
            
            
              | 93 | 
                          "flags"               => __("System permissions"), | 
            
            
              | 94 | 
                          "gonenoaddress"       => __("Gone no address flag"), | 
            
            
              | 95 | 
                          "lost"                => __("Lost card flag"), | 
            
            
              | 96 | 
                          "debarred"            => __("Restricted [until] flag"), | 
            
            
              | 97 | 
                          "debarredcomment"     => __("Comment"), | 
            
            
              | 98 | 
                          "smsalertnumber"      => __("Mobile phone number"), | 
            
            
              | 99 | 
                          "privacy"             => __("Privacy settings"), | 
            
            
              | 100 | 
                          "autorenew_checkouts" => __("Allow auto-renewals"), | 
            
            
              | 101 | 
                      },  | 
            
            
              | 102 | 
                      items => { | 
            
            
              | 103 | 
                          "itemnumber"           => __("Item number (internal)"), | 
            
            
              | 104 | 
                          "biblionumber"         => __("Biblio number (internal)"), | 
            
            
              | 105 | 
                          "biblioitemnumber"     => __("Biblioitem number (internal)"), | 
            
            
              | 106 | 
                          "barcode"              => __("Barcode"), | 
            
            
              | 107 | 
                          "dateaccessioned"      => __("Date acquired"), | 
            
            
              | 108 | 
                          "booksellerid"         => __("Source of acquisition"), | 
            
            
              | 109 | 
                          "homebranch"           => __("Permanent library"), | 
            
            
              | 110 | 
                          "price"                => __("Price"), | 
            
            
              | 111 | 
                          "replacementprice"     => __("Replacement price"), | 
            
            
              | 112 | 
                          "replacementpricedate" => __("Price effective from"), | 
            
            
              | 113 | 
                          "datelastborrowed"     => __("Date last checked out"), | 
            
            
              | 114 | 
                          "datelastseen"         => __("Date last seen"), | 
            
            
              | 115 | 
                          "stack"                => __("Shelving control number"), | 
            
            
              | 116 | 
                          "onloan"               => __("Due date"), | 
            
            
              | 117 | 
                          "cn_source"            => __("Source of classification / shelving scheme"), | 
            
            
              | 118 | 
                          "cn_sort"              => __("Koha normalized classification for sorting"), | 
            
            
              | 119 | 
                          "notforloan"           => __("Not for loan"), | 
            
            
              | 120 | 
                          "itemlost"             => __("Lost status"), | 
            
            
              | 121 | 
                          "itemlost_on"          => __("Lost on"), | 
            
            
              | 122 | 
                          "withdrawn"            => __("Withdrawn status"), | 
            
            
              | 123 | 
                          "withdrawn_on"         => __("Withdrawn on"), | 
            
            
              | 124 | 
                          "itemcallnumber"       => __("Call number"), | 
            
            
              | 125 | 
                          "issues"               => __("Total checkouts"), | 
            
            
              | 126 | 
                          "renewals"             => __("Total renewals"), | 
            
            
              | 127 | 
                          "reserves"             => __("Total holds"), | 
            
            
              | 128 | 
                          "restricted"           => __("Use restrictions"), | 
            
            
              | 129 | 
                          "itemnotes"            => __("Public note"), | 
            
            
              | 130 | 
                          "itemnotes_nonpublic"  => __("Internal note"), | 
            
            
              | 131 | 
                          "holdingbranch"        => __("Current library"), | 
            
            
              | 132 | 
                          "timestamp"            => __("Timestamp"), | 
            
            
              | 133 | 
                          "location"             => __("Shelving location"), | 
            
            
              | 134 | 
                          "permanent_location"   => __("Permanent shelving location"), | 
            
            
              | 135 | 
                          "ccode"                => __("Collection"), | 
            
            
              | 136 | 
                          "itype"                => __("Koha itemtype"), | 
            
            
              | 137 | 
                          "stocknumber"          => __("Inventory number"), | 
            
            
              | 138 | 
                          "damaged"              => __("Damaged status"), | 
            
            
              | 139 | 
                          "damaged_on"           => __("Damaged on"), | 
            
            
              | 140 | 
                          "materials"            => __("Materials specified"), | 
            
            
              | 141 | 
                          "uri"                  => __("Uniform Resource Identifier"), | 
            
            
              | 142 | 
                          "more_subfields_xml"   => __("Additional subfields (XML)"), | 
            
            
              | 143 | 
                          "enumchron"            => __("Serial enumeraton/chronology"), | 
            
            
              | 144 | 
                          "copynumber"           => __("Copy number"), | 
            
            
              | 145 | 
                          "new_status"           => __("New status"), | 
            
            
              | 146 | 
                      },  | 
            
            
              | 147 | 
                      statistics => { | 
            
            
              | 148 | 
                          "datetime"       => __("Statistics date and time"), | 
            
            
              | 149 | 
                          "branch"         => __("Library"), | 
            
            
              | 150 | 
                          "value"          => __("Value"), | 
            
            
              | 151 | 
                          "type"           => __("Type"), | 
            
            
              | 152 | 
                          "other"          => __(""), | 
            
            
              | 153 | 
                          "itemnumber"     => __("Item number"), | 
            
            
              | 154 | 
                          "itemtype"       => __("Itemtype"), | 
            
            
              | 155 | 
                          "borrowernumber" => __("Borrower number"), | 
            
            
              | 156 | 
                      },  | 
            
            
              | 157 | 
                      biblio => { | 
            
            
              | 158 | 
                          "frameworkcode" => __("Framework code"), | 
            
            
              | 159 | 
                          "author"        => __("Author"), | 
            
            
              | 160 | 
                          "datecreated"   => __("Creation date"), | 
            
            
              | 161 | 
                          "timestamp"     => __("Modification date"), | 
            
            
              | 162 | 
                      },  | 
            
            
              | 163 | 
                      biblioitems => { | 
            
            
              | 164 | 
                          "biblioitemnumber" => __("Biblioitem number"), | 
            
            
              | 165 | 
                          "biblionumber"     => __("Biblio number"), | 
            
            
              | 166 | 
                          "volume"           => __("Volume number"), | 
            
            
              | 167 | 
                          "number"           => __("Number"), | 
            
            
              | 168 | 
                          "classification"   => __("Classification"), | 
            
            
              | 169 | 
                          "itemtype"         => __("Biblio-level item type"), | 
            
            
              | 170 | 
                          "isbn"             => __("ISBN"), | 
            
            
              | 171 | 
                          "issn"             => __("ISSN"), | 
            
            
              | 172 | 
                          "dewey"            => __("Dewey/classification"), | 
            
            
              | 173 | 
                          "subclass"         => __("Sub classification"), | 
            
            
              | 174 | 
                          "publicationyear"  => __("Publication date"), | 
            
            
              | 175 | 
                          "publishercode"    => __("Publisher"), | 
            
            
              | 176 | 
                          "volumedate"       => __("Volume date"), | 
            
            
              | 177 | 
                          "volumedesc"       => __("Volume information"), | 
            
            
              | 178 | 
                          "timestamp"        => __("Timestamp"), | 
            
            
              | 179 | 
                          "illus"            => __("Illustrations"), | 
            
            
              | 180 | 
                          "pages"            => __("Number of pages"), | 
            
            
              | 181 | 
                          "notes"            => __("Notes"), | 
            
            
              | 182 | 
                          "size"             => __("Size"), | 
            
            
              | 183 | 
                          "place"            => __("Place of publication"), | 
            
            
              | 184 | 
                          "lccn"             => __("LCCN"), | 
            
            
              | 185 | 
                          "agerestriction"   => __("Age restriction"), | 
            
            
              | 186 | 
                          "url"              => __("URL"), | 
            
            
              | 187 | 
                          "title"            => __("Title"), | 
            
            
              | 188 | 
                      },  | 
            
            
              | 189 | 
                      subscription => { | 
            
            
              | 190 | 
                          "startdate"   => __("Start date"), | 
            
            
              | 191 | 
                          "enddate"     => __("End date"), | 
            
            
              | 192 | 
                          "periodicity" => __("Periodicity"), | 
            
            
              | 193 | 
                          "callnumber"  => __("Call number"), | 
            
            
              | 194 | 
                          "location"    => __("Location"), | 
            
            
              | 195 | 
                          "branchcode"  => __("Library"), | 
            
            
              | 196 | 
                      },  | 
            
            
              | 197 | 
                      suggestions=> { | 
            
            
              | 198 | 
                          "author"          => __("author"), | 
            
            
              | 199 | 
                          "copyrightdate"   => __("copyrightdate"), | 
            
            
              | 200 | 
                          "isbn"            => __("isbn"), | 
            
            
              | 201 | 
                          "publishercode"   => __("publishercode"), | 
            
            
              | 202 | 
                          "collectiontitle" => __("collectiontitle"), | 
            
            
              | 203 | 
                          "place"           => __("place"), | 
            
            
              | 204 | 
                          "quantity"        => __("quantity"), | 
            
            
              | 205 | 
                          "itemtype"        => __("itemtype"), | 
            
            
              | 206 | 
                          "branchcode"      => __("branchcode"), | 
            
            
              | 207 | 
                          "patronreason"    => __("patronreason"), | 
            
            
              | 208 | 
                          "note"            => __("note"), | 
            
            
              | 209 | 
                      }  | 
            
            
              | 210 | 
                  };  | 
            
            
              | 211 | 
              }  | 
            
            
              | 212 | 
               | 
            
            
              | 213 | 
              1;  |