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

(-)a/installer/data/mysql/en/optional/patron_categories.sql (-23 lines)
Lines 1-23 Link Here
1
INSERT INTO `categories` (`categorycode`, `description`, `enrolmentperiod`, `upperagelimit`, `dateofbirthrequired`, `finetype`, `bulk`, `enrolmentfee`, `overduenoticerequired`, `issuelimit`, `reservefee`, `category_type`) VALUES
2
3
-- Adult Patrons
4
('PT','Patron',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','A'),
5
('ST','Student',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','A'),
6
('HB','Home Bound',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','A'),
7
8
-- Children
9
('K','Kid',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C'),
10
('J','Juvenile',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C'),
11
('YA','Young Adult',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C'),
12
13
-- Professionals
14
('T','Teacher',99,999,18,NULL,NULL,'0.000000',0,NULL,'0.000000','P'),
15
('B','Board',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','P'),
16
17
-- Institutional
18
('IL','Inter-Library Loan',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I'),
19
('SC','School',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I'),
20
('L','Library',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I'),
21
22
-- Staff
23
('S','Staff',99,999,18,NULL,NULL,'0.000000',0,NULL,'0.000000','S');
(-)a/installer/data/mysql/en/optional/patron_categories.txt (-21 lines)
Lines 1-21 Link Here
1
Sample patron types and categories. Types are currently hardcoded but you can manage categories after installation from the administration module.
2
3
Adult patron - default patron type
4
                PT  - Patron
5
                ST  - Student
6
                BH  - Homebound
7
8
Child - patron with a guarantor
9
                K   - Kid
10
                J   - Juvenile
11
                YA  - Young Adult
12
13
Organization - patron is an institution, not a person
14
                ILL - Inter-library Loan
15
                SC  - School
16
                L   - Library
17
18
Professional - a member of an organization (organization is guarantor)
19
                T   - Teacher
20
                S   - Staff
21
                B   - Board
(-)a/installer/data/mysql/en/optional/patron_categories.yml (-1 / +209 lines)
Line 0 Link Here
0
- 
1
---
2
#
3
#  Copyright 2020 Koha Development Team
4
#
5
#  This file is part of Koha.
6
#
7
#  Koha is free software; you can redistribute it and/or modify it under the
8
#  terms of the GNU General Public License as published by the Free Software
9
#  Foundation; either version 2 of the License, or (at your option) any later
10
#  version.
11
#
12
#  Koha is distributed in the hope that it will be useful, but WITHOUT ANY
13
#  WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
14
#  A PARTICULAR PURPOSE.  See the GNU General Public License for more details.
15
#
16
#  You should have received a copy of the GNU General Public License along
17
#  with Koha; if not, write to the Free Software Foundation, Inc.,
18
#  51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
19
#
20
21
description:
22
  - "Sample patron types and categories. Types are currently hardcoded but you can manage categories after installation from the administration module."
23
  - ""
24
  - "Adult patron - default patron type"
25
  - "                PT  - Patron"
26
  - "                ST  - Student"
27
  - "                BH  - Homebound"
28
  - ""
29
  - "Child - patron with a guarantor"
30
  - "                K   - Kid"
31
  - "                J   - Juvenile"
32
  - "                YA  - Young Adult"
33
  - ""
34
  - "Organization - patron is an institution, not a person"
35
  - "                ILL - Inter-library Loan"
36
  - "                SC  - School"
37
  - "                L   - Library"
38
  - ""
39
  - "Professional - a member of an organization (organization is guarantor)"
40
  - "                T   - Teacher"
41
  - "                S   - Staff"
42
  - "                B   - Board"
43
44
45
tables:
46
  - categories:
47
      translatable: [ description ]
48
      multiline: []
49
      rows:
50
        #  Adult Patrons
51
        - categorycode: 'PT'
52
          description: 'Patron'
53
          enrolmentperiod: 99
54
          upperagelimit: 999
55
          dateofbirthrequired: 18
56
          finetype: ~
57
          bulk: ~
58
          enrolmentfee: '0.000000'
59
          overduenoticerequired: 1
60
          issuelimit: ~
61
          reservefee: '0.000000'
62
          category_type: 'A'
63
64
        - categorycode: 'ST'
65
          description: 'Student'
66
          enrolmentperiod: 99
67
          upperagelimit: 999
68
          dateofbirthrequired: 18
69
          finetype: ~
70
          bulk: ~
71
          enrolmentfee: '0.000000'
72
          overduenoticerequired: 1
73
          issuelimit: ~
74
          reservefee: '0.000000'
75
          category_type: 'A'
76
77
        - categorycode: 'HB'
78
          description: 'Home Bound'
79
          enrolmentperiod: 99
80
          upperagelimit: 999
81
          dateofbirthrequired: 18
82
          finetype: ~
83
          bulk: ~
84
          enrolmentfee: '0.000000'
85
          overduenoticerequired: 1
86
          issuelimit: ~
87
          reservefee: '0.000000'
88
          category_type: 'A'
89
90
        #  Children
91
        - categorycode: 'K'
92
          description: 'Kid'
93
          enrolmentperiod: 99
94
          upperagelimit: 17
95
          dateofbirthrequired: 5
96
          finetype: ~
97
          bulk: ~
98
          enrolmentfee: '0.000000'
99
          overduenoticerequired: 1
100
          issuelimit: ~
101
          reservefee: '0.000000'
102
          category_type: 'C'
103
104
        - categorycode: 'J'
105
          description: 'Juvenile'
106
          enrolmentperiod: 99
107
          upperagelimit: 17
108
          dateofbirthrequired: 5
109
          finetype: ~
110
          bulk: ~
111
          enrolmentfee: '0.000000'
112
          overduenoticerequired: 1
113
          issuelimit: ~
114
          reservefee: '0.000000'
115
          category_type: 'C'
116
117
        - categorycode: 'YA'
118
          description: 'Young Adult'
119
          enrolmentperiod: 99
120
          upperagelimit: 17
121
          dateofbirthrequired: 5
122
          finetype: ~
123
          bulk: ~
124
          enrolmentfee: '0.000000'
125
          overduenoticerequired: 1
126
          issuelimit: ~
127
          reservefee: '0.000000'
128
          category_type: 'C'
129
130
        #  Professionals
131
        - categorycode: 'T'
132
          description: 'Teacher'
133
          enrolmentperiod: 99
134
          upperagelimit: 999
135
          dateofbirthrequired: 18
136
          finetype: ~
137
          bulk: ~
138
          enrolmentfee: '0.000000'
139
          overduenoticerequired: 0
140
          issuelimit: ~
141
          reservefee: '0.000000'
142
          category_type: 'P'
143
144
        - categorycode: 'B'
145
          description: 'Board'
146
          enrolmentperiod: 99
147
          upperagelimit: 17
148
          dateofbirthrequired: 5
149
          finetype: ~
150
          bulk: ~
151
          enrolmentfee: '0.000000'
152
          overduenoticerequired: 1
153
          issuelimit: ~
154
          reservefee: '0.000000'
155
          category_type: 'P'
156
157
        #  Institutional
158
        - categorycode: 'IL'
159
          description: 'Inter-Library Loan'
160
          enrolmentperiod: 99
161
          upperagelimit: 999
162
          dateofbirthrequired: 18
163
          finetype: ~
164
          bulk: ~
165
          enrolmentfee: '0.000000'
166
          overduenoticerequired: 1
167
          issuelimit: ~
168
          reservefee: '0.000000'
169
          category_type: 'I'
170
171
        - categorycode: 'SC'
172
          description: 'School'
173
          enrolmentperiod: 99
174
          upperagelimit: 999
175
          dateofbirthrequired: 18
176
          finetype: ~
177
          bulk: ~
178
          enrolmentfee: '0.000000'
179
          overduenoticerequired: 1
180
          issuelimit: ~
181
          reservefee: '0.000000'
182
          category_type: 'I'
183
184
        - categorycode: 'L'
185
          description: 'Library'
186
          enrolmentperiod: 99
187
          upperagelimit: 999
188
          dateofbirthrequired: 18
189
          finetype: ~
190
          bulk: ~
191
          enrolmentfee: '0.000000'
192
          overduenoticerequired: 1
193
          issuelimit: ~
194
          reservefee: '0.000000'
195
          category_type: 'I'
196
197
        #  Staff
198
        - categorycode: 'S'
199
          description: 'Staff'
200
          enrolmentperiod: 99
201
          upperagelimit: 999
202
          dateofbirthrequired: 18
203
          finetype: ~
204
          bulk: ~
205
          enrolmentfee: '0.000000'
206
          overduenoticerequired: 0
207
          issuelimit: ~
208
          reservefee: '0.000000'
209
          category_type: 'S'

Return to bug 24584