View | Details | Raw Unified | Return to bug 29695
Collapse All | Expand All

(-)a/Koha/Database/Columns.pm (+213 lines)
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;
(-)a/t/Koha/Database/Columns.t (+34 lines)
Line 0 Link Here
1
#!/usr/bin/perl
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 Test::More tests => 1;
20
use Test::MockModule;
21
use FindBin qw($Bin);
22
use Encode;
23
24
use Koha::Database::Columns;
25
26
my $koha_i18n = Test::MockModule->new('Koha::I18N');
27
$koha_i18n->mock('_base_directory', sub { "$Bin/../I18N/po" });
28
29
my $c4_languages = Test::MockModule->new('C4::Languages');
30
$c4_languages->mock('getlanguage', sub { 'xx-XX' });
31
32
my $columns = Koha::Database::Columns->columns;
33
34
is( $columns->{borrowers}->{opacnote}, decode_utf8('OPAC note ✔ ❤ ★') );

Return to bug 29695