Attachment #160416 for bug #35539

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

Lines 247-253 sub to_api_mapping { Link Here

(-)a/Koha/Patron/Category.pm (-1 lines)
247	dateofbirthrequired => 'lower_age_limit',	247	dateofbirthrequired => 'lower_age_limit',
248	enrolmentfee => 'enrolment_fee',	248	enrolmentfee => 'enrolment_fee',
249	overduenoticerequired => 'overdue_notice_required',	249	overduenoticerequired => 'overdue_notice_required',
250	issuelimit => undef, # Unused
251	reservefee => 'reserve_fee',	250	reservefee => 'reserve_fee',
252	hidelostitems => 'hide_lost_items',	251	hidelostitems => 'hide_lost_items',
253	category_type => 'category_type',	252	category_type => 'category_type',




          dateofbirthrequired: 18
          enrolmentfee: '0.000000'
          overduenoticerequired: 1
          issuelimit: ~
          reservefee: '0.000000'
          category_type: 'A'
          can_be_guarantee: 0

          dateofbirthrequired: 18
          enrolmentfee: '0.000000'
          overduenoticerequired: 1
          issuelimit: ~
          reservefee: '0.000000'
          category_type: 'A'
          can_be_guarantee: 0

          dateofbirthrequired: 18
          enrolmentfee: '0.000000'
          overduenoticerequired: 1
          issuelimit: ~
          reservefee: '0.000000'
          category_type: 'A'
          can_be_guarantee: 0

          dateofbirthrequired: 5
          enrolmentfee: '0.000000'
          overduenoticerequired: 1
          issuelimit: ~
          reservefee: '0.000000'
          category_type: 'C'
          can_be_guarantee: 1

          dateofbirthrequired: 5
          enrolmentfee: '0.000000'
          overduenoticerequired: 1
          issuelimit: ~
          reservefee: '0.000000'
          category_type: 'C'
          can_be_guarantee: 1

          dateofbirthrequired: 5
          enrolmentfee: '0.000000'
          overduenoticerequired: 1
          issuelimit: ~
          reservefee: '0.000000'
          category_type: 'C'
          can_be_guarantee: 1

          dateofbirthrequired: 18
          enrolmentfee: '0.000000'
          overduenoticerequired: 0
          issuelimit: ~
          reservefee: '0.000000'
          category_type: 'P'
          can_be_guarantee: 1

          dateofbirthrequired: 5
          enrolmentfee: '0.000000'
          overduenoticerequired: 1
          issuelimit: ~
          reservefee: '0.000000'
          category_type: 'P'
          can_be_guarantee: 1

          dateofbirthrequired: 18
          enrolmentfee: '0.000000'
          overduenoticerequired: 1
          issuelimit: ~
          reservefee: '0.000000'
          category_type: 'I'
          can_be_guarantee: 0

          dateofbirthrequired: 18
          enrolmentfee: '0.000000'
          overduenoticerequired: 1
          issuelimit: ~
          reservefee: '0.000000'
          category_type: 'I'
          can_be_guarantee: 0

          dateofbirthrequired: 18
          enrolmentfee: '0.000000'
          overduenoticerequired: 1
          issuelimit: ~
          reservefee: '0.000000'
          category_type: 'I'
          can_be_guarantee: 0

          dateofbirthrequired: 18
          enrolmentfee: '0.000000'
          overduenoticerequired: 0
          issuelimit: ~
          reservefee: '0.000000'
          category_type: 'S'
          can_be_guarantee: 0

Lines 1781-1787 CREATE TABLE `categories` ( Link Here

(-)a/installer/data/mysql/kohastructure.sql (-1 lines)
1781	`dateofbirthrequired` tinyint(1) DEFAULT NULL COMMENT 'the minimum age required for the patron category',	1781	`dateofbirthrequired` tinyint(1) DEFAULT NULL COMMENT 'the minimum age required for the patron category',
1782	`enrolmentfee` decimal(28,6) DEFAULT NULL COMMENT 'enrollment fee for the patron',	1782	`enrolmentfee` decimal(28,6) DEFAULT NULL COMMENT 'enrollment fee for the patron',
1783	`overduenoticerequired` tinyint(1) DEFAULT NULL COMMENT 'are overdue notices sent to this patron category (1 for yes, 0 for no)',	1783	`overduenoticerequired` tinyint(1) DEFAULT NULL COMMENT 'are overdue notices sent to this patron category (1 for yes, 0 for no)',
1784	`issuelimit` smallint(6) DEFAULT NULL COMMENT 'unused in Koha',
1785	`reservefee` decimal(28,6) DEFAULT NULL COMMENT 'cost to place holds',	1784	`reservefee` decimal(28,6) DEFAULT NULL COMMENT 'cost to place holds',
1786	`hidelostitems` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'are lost items shown to this category (1 for yes, 0 for no)',	1785	`hidelostitems` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'are lost items shown to this category (1 for yes, 0 for no)',
1787	`category_type` varchar(1) NOT NULL DEFAULT 'A' COMMENT 'type of Koha patron (Adult, Child, Professional, Organizational, Statistical, Staff)',	1786	`category_type` varchar(1) NOT NULL DEFAULT 'A' COMMENT 'type of Koha patron (Adult, Child, Professional, Organizational, Statistical, Staff)',




    dateofbirthrequired   => undef,
    enrolmentfee          => undef,
    overduenoticerequired => undef,
    issuelimit            => undef,
    reservefee            => undef,
    hidelostitems         => 0,
    category_type         => 'A',
};
my $query =
"INSERT INTO categories (categorycode,description,enrolmentperiod,enrolmentperioddate,dateofbirthrequired,enrolmentfee,overduenoticerequired ,reservefee ,hidelostitems ,category_type) VALUES( ?,?,?,?,?,?,?,?,?,?)";
$dbh->do(
    $query, {},
    $samplecat->{categorycode},          $samplecat->{description},
    $samplecat->{enrolmentperiod},       $samplecat->{enrolmentperioddate},
    $samplecat->{dateofbirthrequired},   $samplecat->{enrolmentfee},
    $samplecat->{overduenoticerequired}, $samplecat->{reservefee},
    $samplecat->{hidelostitems},         $samplecat->{category_type}
    $samplecat->{category_type}
);

my $builder = t::lib::TestBuilder->new;
- 

Return to bug 35539

Lines 54-60 tables: Link Here

(-)a/installer/data/mysql/en/optional/patron_categories.yml (-12 lines)
54	dateofbirthrequired: 18	54	dateofbirthrequired: 18
55	enrolmentfee: '0.000000'	55	enrolmentfee: '0.000000'
56	overduenoticerequired: 1	56	overduenoticerequired: 1
57	issuelimit: ~
58	reservefee: '0.000000'	57	reservefee: '0.000000'
59	category_type: 'A'	58	category_type: 'A'
60	can_be_guarantee: 0	59	can_be_guarantee: 0
Lines 66-72 tables: Link Here
66	dateofbirthrequired: 18	65	dateofbirthrequired: 18
67	enrolmentfee: '0.000000'	66	enrolmentfee: '0.000000'
68	overduenoticerequired: 1	67	overduenoticerequired: 1
69	issuelimit: ~
70	reservefee: '0.000000'	68	reservefee: '0.000000'
71	category_type: 'A'	69	category_type: 'A'
72	can_be_guarantee: 0	70	can_be_guarantee: 0
Lines 78-84 tables: Link Here
78	dateofbirthrequired: 18	76	dateofbirthrequired: 18
79	enrolmentfee: '0.000000'	77	enrolmentfee: '0.000000'
80	overduenoticerequired: 1	78	overduenoticerequired: 1
81	issuelimit: ~
82	reservefee: '0.000000'	79	reservefee: '0.000000'
83	category_type: 'A'	80	category_type: 'A'
84	can_be_guarantee: 0	81	can_be_guarantee: 0
Lines 91-97 tables: Link Here
91	dateofbirthrequired: 5	88	dateofbirthrequired: 5
92	enrolmentfee: '0.000000'	89	enrolmentfee: '0.000000'
93	overduenoticerequired: 1	90	overduenoticerequired: 1
94	issuelimit: ~
95	reservefee: '0.000000'	91	reservefee: '0.000000'
96	category_type: 'C'	92	category_type: 'C'
97	can_be_guarantee: 1	93	can_be_guarantee: 1
Lines 103-109 tables: Link Here
103	dateofbirthrequired: 5	99	dateofbirthrequired: 5
104	enrolmentfee: '0.000000'	100	enrolmentfee: '0.000000'
105	overduenoticerequired: 1	101	overduenoticerequired: 1
106	issuelimit: ~
107	reservefee: '0.000000'	102	reservefee: '0.000000'
108	category_type: 'C'	103	category_type: 'C'
109	can_be_guarantee: 1	104	can_be_guarantee: 1
Lines 115-121 tables: Link Here
115	dateofbirthrequired: 5	110	dateofbirthrequired: 5
116	enrolmentfee: '0.000000'	111	enrolmentfee: '0.000000'
117	overduenoticerequired: 1	112	overduenoticerequired: 1
118	issuelimit: ~
119	reservefee: '0.000000'	113	reservefee: '0.000000'
120	category_type: 'C'	114	category_type: 'C'
121	can_be_guarantee: 1	115	can_be_guarantee: 1
Lines 128-134 tables: Link Here
128	dateofbirthrequired: 18	122	dateofbirthrequired: 18
129	enrolmentfee: '0.000000'	123	enrolmentfee: '0.000000'
130	overduenoticerequired: 0	124	overduenoticerequired: 0
131	issuelimit: ~
132	reservefee: '0.000000'	125	reservefee: '0.000000'
133	category_type: 'P'	126	category_type: 'P'
134	can_be_guarantee: 1	127	can_be_guarantee: 1
Lines 140-146 tables: Link Here
140	dateofbirthrequired: 5	133	dateofbirthrequired: 5
141	enrolmentfee: '0.000000'	134	enrolmentfee: '0.000000'
142	overduenoticerequired: 1	135	overduenoticerequired: 1
143	issuelimit: ~
144	reservefee: '0.000000'	136	reservefee: '0.000000'
145	category_type: 'P'	137	category_type: 'P'
146	can_be_guarantee: 1	138	can_be_guarantee: 1
Lines 153-159 tables: Link Here
153	dateofbirthrequired: 18	145	dateofbirthrequired: 18
154	enrolmentfee: '0.000000'	146	enrolmentfee: '0.000000'
155	overduenoticerequired: 1	147	overduenoticerequired: 1
156	issuelimit: ~
157	reservefee: '0.000000'	148	reservefee: '0.000000'
158	category_type: 'I'	149	category_type: 'I'
159	can_be_guarantee: 0	150	can_be_guarantee: 0
Lines 165-171 tables: Link Here
165	dateofbirthrequired: 18	156	dateofbirthrequired: 18
166	enrolmentfee: '0.000000'	157	enrolmentfee: '0.000000'
167	overduenoticerequired: 1	158	overduenoticerequired: 1
168	issuelimit: ~
169	reservefee: '0.000000'	159	reservefee: '0.000000'
170	category_type: 'I'	160	category_type: 'I'
171	can_be_guarantee: 0	161	can_be_guarantee: 0
Lines 177-183 tables: Link Here
177	dateofbirthrequired: 18	167	dateofbirthrequired: 18
178	enrolmentfee: '0.000000'	168	enrolmentfee: '0.000000'
179	overduenoticerequired: 1	169	overduenoticerequired: 1
180	issuelimit: ~
181	reservefee: '0.000000'	170	reservefee: '0.000000'
182	category_type: 'I'	171	category_type: 'I'
183	can_be_guarantee: 0	172	can_be_guarantee: 0
Lines 190-196 tables: Link Here
190	dateofbirthrequired: 18	179	dateofbirthrequired: 18
191	enrolmentfee: '0.000000'	180	enrolmentfee: '0.000000'
192	overduenoticerequired: 0	181	overduenoticerequired: 0
193	issuelimit: ~
194	reservefee: '0.000000'	182	reservefee: '0.000000'
195	category_type: 'S'	183	category_type: 'S'
196	can_be_guarantee: 0	184	can_be_guarantee: 0

Lines 81-101 my $samplecat = { Link Here

(-)a/t/db_dependent/Circulation/GetHardDueDate.t (-9 / +6 lines)
81	dateofbirthrequired => undef,	81	dateofbirthrequired => undef,
82	enrolmentfee => undef,	82	enrolmentfee => undef,
83	overduenoticerequired => undef,	83	overduenoticerequired => undef,
84	issuelimit => undef,
85	reservefee => undef,	84	reservefee => undef,
86	hidelostitems => 0,	85	hidelostitems => 0,
87	category_type => 'A',	86	category_type => 'A',
88	};	87	};
89	my $query =	88	my $query =
90	"INSERT INTO categories (categorycode,description,enrolmentperiod,enrolmentperioddate,dateofbirthrequired,enrolmentfee,overduenoticerequired,issuelimit ,reservefee ,hidelostitems ,category_type) VALUES( ?,?,?,?,?,?,?,?,?,?,?)";	89	"INSERT INTO categories (categorycode,description,enrolmentperiod,enrolmentperioddate,dateofbirthrequired,enrolmentfee,overduenoticerequired ,reservefee ,hidelostitems ,category_type) VALUES( ?,?,?,?,?,?,?,?,?,?)";
91	$dbh->do(	90	$dbh->do(
92	$query, {},	91	$query, {},
93	$samplecat->{categorycode}, $samplecat->{description},	92	$samplecat->{categorycode}, $samplecat->{description},
94	$samplecat->{enrolmentperiod}, $samplecat->{enrolmentperioddate},	93	$samplecat->{enrolmentperiod}, $samplecat->{enrolmentperioddate},
95	$samplecat->{dateofbirthrequired}, $samplecat->{enrolmentfee},	94	$samplecat->{dateofbirthrequired}, $samplecat->{enrolmentfee},
96	$samplecat->{overduenoticerequired}, $samplecat->{issuelimit},	95	$samplecat->{overduenoticerequired}, $samplecat->{reservefee},
97	$samplecat->{reservefee}, $samplecat->{hidelostitems},	96	$samplecat->{hidelostitems}, $samplecat->{category_type}
98	$samplecat->{category_type}
99	);	97	);
100		98
101	my $builder = t::lib::TestBuilder->new;	99	my $builder = t::lib::TestBuilder->new;
102	-