Attachment #99407 for bug #24584

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

Lines 1-23 Link Here

(-)a/installer/data/mysql/en/optional/patron_categories.sql (-23 lines)
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');




Sample patron types and categories. Types are currently hardcoded but you can manage categories after installation from the administration module.

Adult patron - default patron type
                PT  - Patron
                ST  - Student
                BH  - Homebound

Child - patron with a guarantor
                K   - Kid
                J   - Juvenile
                YA  - Young Adult

Organization - patron is an institution, not a person
                ILL - Inter-library Loan
                SC  - School
                L   - Library

Professional - a member of an organization (organization is guarantor)
                T   - Teacher
                S   - Staff
                B   - Board




---
#
#  Copyright 2020 Koha Development Team
#
#  This file is part of Koha.
#
#  Koha is free software; you can redistribute it and/or modify it under the
#  terms of the GNU General Public License as published by the Free Software
#  Foundation; either version 2 of the License, or (at your option) any later
#  version.
#
#  Koha is distributed in the hope that it will be useful, but WITHOUT ANY
#  WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
#  A PARTICULAR PURPOSE.  See the GNU General Public License for more details.
#
#  You should have received a copy of the GNU General Public License along
#  with Koha; if not, write to the Free Software Foundation, Inc.,
#  51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
#

description:
  - "Sample patron types and categories. Types are currently hardcoded but you can manage categories after installation from the administration module."
  - ""
  - "Adult patron - default patron type"
  - "                PT  - Patron"
  - "                ST  - Student"
  - "                BH  - Homebound"
  - ""
  - "Child - patron with a guarantor"
  - "                K   - Kid"
  - "                J   - Juvenile"
  - "                YA  - Young Adult"
  - ""
  - "Organization - patron is an institution, not a person"
  - "                ILL - Inter-library Loan"
  - "                SC  - School"
  - "                L   - Library"
  - ""
  - "Professional - a member of an organization (organization is guarantor)"
  - "                T   - Teacher"
  - "                S   - Staff"
  - "                B   - Board"


tables:
  - categories:
      translatable: [ description ]
      multiline: []
      rows:
        #  Adult Patrons
        - categorycode: 'PT'
          description: 'Patron'
          enrolmentperiod: 99
          upperagelimit: 999
          dateofbirthrequired: 18
          finetype: ~
          bulk: ~
          enrolmentfee: '0.000000'
          overduenoticerequired: 1
          issuelimit: ~
          reservefee: '0.000000'
          category_type: 'A'

        - categorycode: 'ST'
          description: 'Student'
          enrolmentperiod: 99
          upperagelimit: 999
          dateofbirthrequired: 18
          finetype: ~
          bulk: ~
          enrolmentfee: '0.000000'
          overduenoticerequired: 1
          issuelimit: ~
          reservefee: '0.000000'
          category_type: 'A'

        - categorycode: 'HB'
          description: 'Home Bound'
          enrolmentperiod: 99
          upperagelimit: 999
          dateofbirthrequired: 18
          finetype: ~
          bulk: ~
          enrolmentfee: '0.000000'
          overduenoticerequired: 1
          issuelimit: ~
          reservefee: '0.000000'
          category_type: 'A'

        #  Children
        - categorycode: 'K'
          description: 'Kid'
          enrolmentperiod: 99
          upperagelimit: 17
          dateofbirthrequired: 5
          finetype: ~
          bulk: ~
          enrolmentfee: '0.000000'
          overduenoticerequired: 1
          issuelimit: ~
          reservefee: '0.000000'
          category_type: 'C'

        - categorycode: 'J'
          description: 'Juvenile'
          enrolmentperiod: 99
          upperagelimit: 17
          dateofbirthrequired: 5
          finetype: ~
          bulk: ~
          enrolmentfee: '0.000000'
          overduenoticerequired: 1
          issuelimit: ~
          reservefee: '0.000000'
          category_type: 'C'

        - categorycode: 'YA'
          description: 'Young Adult'
          enrolmentperiod: 99
          upperagelimit: 17
          dateofbirthrequired: 5
          finetype: ~
          bulk: ~
          enrolmentfee: '0.000000'
          overduenoticerequired: 1
          issuelimit: ~
          reservefee: '0.000000'
          category_type: 'C'

        #  Professionals
        - categorycode: 'T'
          description: 'Teacher'
          enrolmentperiod: 99
          upperagelimit: 999
          dateofbirthrequired: 18
          finetype: ~
          bulk: ~
          enrolmentfee: '0.000000'
          overduenoticerequired: 0
          issuelimit: ~
          reservefee: '0.000000'
          category_type: 'P'

        - categorycode: 'B'
          description: 'Board'
          enrolmentperiod: 99
          upperagelimit: 17
          dateofbirthrequired: 5
          finetype: ~
          bulk: ~
          enrolmentfee: '0.000000'
          overduenoticerequired: 1
          issuelimit: ~
          reservefee: '0.000000'
          category_type: 'P'

        #  Institutional
        - categorycode: 'IL'
          description: 'Inter-Library Loan'
          enrolmentperiod: 99
          upperagelimit: 999
          dateofbirthrequired: 18
          finetype: ~
          bulk: ~
          enrolmentfee: '0.000000'
          overduenoticerequired: 1
          issuelimit: ~
          reservefee: '0.000000'
          category_type: 'I'

        - categorycode: 'SC'
          description: 'School'
          enrolmentperiod: 99
          upperagelimit: 999
          dateofbirthrequired: 18
          finetype: ~
          bulk: ~
          enrolmentfee: '0.000000'
          overduenoticerequired: 1
          issuelimit: ~
          reservefee: '0.000000'
          category_type: 'I'

        - categorycode: 'L'
          description: 'Library'
          enrolmentperiod: 99
          upperagelimit: 999
          dateofbirthrequired: 18
          finetype: ~
          bulk: ~
          enrolmentfee: '0.000000'
          overduenoticerequired: 1
          issuelimit: ~
          reservefee: '0.000000'
          category_type: 'I'

        #  Staff
        - categorycode: 'S'
          description: 'Staff'
          enrolmentperiod: 99
          upperagelimit: 999
          dateofbirthrequired: 18
          finetype: ~
          bulk: ~
          enrolmentfee: '0.000000'
          overduenoticerequired: 0
          issuelimit: ~
          reservefee: '0.000000'
          category_type: 'S'

Return to bug 24584

Lines 1-21 Link Here

(-)a/installer/data/mysql/en/optional/patron_categories.txt (-21 lines)
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

Line 0 Link Here

(-)a/installer/data/mysql/en/optional/patron_categories.yml (-1 / +209 lines)
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'