Attachment #160415 for bug #35539

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

Lines 245-251 sub to_api_mapping { Link Here

(-)a/Koha/Patron/Category.pm (-1 lines)
245	password_expiry_days => 'password_expiry_days',	245	password_expiry_days => 'password_expiry_days',
246	upperagelimit => 'upper_age_limit',	246	upperagelimit => 'upper_age_limit',
247	dateofbirthrequired => 'lower_age_limit',	247	dateofbirthrequired => 'lower_age_limit',
248	finetype => undef, # Unused
249	enrolmentfee => 'enrolment_fee',	248	enrolmentfee => 'enrolment_fee',
250	overduenoticerequired => 'overdue_notice_required',	249	overduenoticerequired => 'overdue_notice_required',
251	issuelimit => undef, # Unused	250	issuelimit => undef, # Unused




          enrolmentperiod: 99
          upperagelimit: 999
          dateofbirthrequired: 18
          finetype: ~
          enrolmentfee: '0.000000'
          overduenoticerequired: 1
          issuelimit: ~

          enrolmentperiod: 99
          upperagelimit: 999
          dateofbirthrequired: 18
          finetype: ~
          enrolmentfee: '0.000000'
          overduenoticerequired: 1
          issuelimit: ~

          enrolmentperiod: 99
          upperagelimit: 999
          dateofbirthrequired: 18
          finetype: ~
          enrolmentfee: '0.000000'
          overduenoticerequired: 1
          issuelimit: ~

          enrolmentperiod: 99
          upperagelimit: 17
          dateofbirthrequired: 5
          finetype: ~
          enrolmentfee: '0.000000'
          overduenoticerequired: 1
          issuelimit: ~

          enrolmentperiod: 99
          upperagelimit: 17
          dateofbirthrequired: 5
          finetype: ~
          enrolmentfee: '0.000000'
          overduenoticerequired: 1
          issuelimit: ~

          enrolmentperiod: 99
          upperagelimit: 17
          dateofbirthrequired: 5
          finetype: ~
          enrolmentfee: '0.000000'
          overduenoticerequired: 1
          issuelimit: ~

          enrolmentperiod: 99
          upperagelimit: 999
          dateofbirthrequired: 18
          finetype: ~
          enrolmentfee: '0.000000'
          overduenoticerequired: 0
          issuelimit: ~

          enrolmentperiod: 99
          upperagelimit: 17
          dateofbirthrequired: 5
          finetype: ~
          enrolmentfee: '0.000000'
          overduenoticerequired: 1
          issuelimit: ~

          enrolmentperiod: 99
          upperagelimit: 999
          dateofbirthrequired: 18
          finetype: ~
          enrolmentfee: '0.000000'
          overduenoticerequired: 1
          issuelimit: ~

          enrolmentperiod: 99
          upperagelimit: 999
          dateofbirthrequired: 18
          finetype: ~
          enrolmentfee: '0.000000'
          overduenoticerequired: 1
          issuelimit: ~

          enrolmentperiod: 99
          upperagelimit: 999
          dateofbirthrequired: 18
          finetype: ~
          enrolmentfee: '0.000000'
          overduenoticerequired: 1
          issuelimit: ~

          enrolmentperiod: 99
          upperagelimit: 999
          dateofbirthrequired: 18
          finetype: ~
          enrolmentfee: '0.000000'
          overduenoticerequired: 0
          issuelimit: ~

Lines 1779-1785 CREATE TABLE `categories` ( Link Here

(-)a/installer/data/mysql/kohastructure.sql (-1 lines)
1779	`password_expiry_days` smallint(6) DEFAULT NULL COMMENT 'number of days after which the patron must reset their password',	1779	`password_expiry_days` smallint(6) DEFAULT NULL COMMENT 'number of days after which the patron must reset their password',
1780	`upperagelimit` smallint(6) DEFAULT NULL COMMENT 'age limit for the patron',	1780	`upperagelimit` smallint(6) DEFAULT NULL COMMENT 'age limit for the patron',
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	`finetype` varchar(30) DEFAULT NULL COMMENT 'unused in Koha',
1783	`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',
1784	`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)',
1785	`issuelimit` smallint(6) DEFAULT NULL COMMENT 'unused in Koha',	1784	`issuelimit` smallint(6) DEFAULT NULL COMMENT 'unused in Koha',




    enrolmentperiod       => undef,
    enrolmentperioddate   => undef,
    dateofbirthrequired   => undef,
    finetype              => undef,
    enrolmentfee          => undef,
    overduenoticerequired => undef,
    issuelimit            => undef,

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

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

Return to bug 35539

Lines 52-58 tables: Link Here

(-)a/installer/data/mysql/en/optional/patron_categories.yml (-12 lines)
52	enrolmentperiod: 99	52	enrolmentperiod: 99
53	upperagelimit: 999	53	upperagelimit: 999
54	dateofbirthrequired: 18	54	dateofbirthrequired: 18
55	finetype: ~
56	enrolmentfee: '0.000000'	55	enrolmentfee: '0.000000'
57	overduenoticerequired: 1	56	overduenoticerequired: 1
58	issuelimit: ~	57	issuelimit: ~
Lines 65-71 tables: Link Here
65	enrolmentperiod: 99	64	enrolmentperiod: 99
66	upperagelimit: 999	65	upperagelimit: 999
67	dateofbirthrequired: 18	66	dateofbirthrequired: 18
68	finetype: ~
69	enrolmentfee: '0.000000'	67	enrolmentfee: '0.000000'
70	overduenoticerequired: 1	68	overduenoticerequired: 1
71	issuelimit: ~	69	issuelimit: ~
Lines 78-84 tables: Link Here
78	enrolmentperiod: 99	76	enrolmentperiod: 99
79	upperagelimit: 999	77	upperagelimit: 999
80	dateofbirthrequired: 18	78	dateofbirthrequired: 18
81	finetype: ~
82	enrolmentfee: '0.000000'	79	enrolmentfee: '0.000000'
83	overduenoticerequired: 1	80	overduenoticerequired: 1
84	issuelimit: ~	81	issuelimit: ~
Lines 92-98 tables: Link Here
92	enrolmentperiod: 99	89	enrolmentperiod: 99
93	upperagelimit: 17	90	upperagelimit: 17
94	dateofbirthrequired: 5	91	dateofbirthrequired: 5
95	finetype: ~
96	enrolmentfee: '0.000000'	92	enrolmentfee: '0.000000'
97	overduenoticerequired: 1	93	overduenoticerequired: 1
98	issuelimit: ~	94	issuelimit: ~
Lines 105-111 tables: Link Here
105	enrolmentperiod: 99	101	enrolmentperiod: 99
106	upperagelimit: 17	102	upperagelimit: 17
107	dateofbirthrequired: 5	103	dateofbirthrequired: 5
108	finetype: ~
109	enrolmentfee: '0.000000'	104	enrolmentfee: '0.000000'
110	overduenoticerequired: 1	105	overduenoticerequired: 1
111	issuelimit: ~	106	issuelimit: ~
Lines 118-124 tables: Link Here
118	enrolmentperiod: 99	113	enrolmentperiod: 99
119	upperagelimit: 17	114	upperagelimit: 17
120	dateofbirthrequired: 5	115	dateofbirthrequired: 5
121	finetype: ~
122	enrolmentfee: '0.000000'	116	enrolmentfee: '0.000000'
123	overduenoticerequired: 1	117	overduenoticerequired: 1
124	issuelimit: ~	118	issuelimit: ~
Lines 132-138 tables: Link Here
132	enrolmentperiod: 99	126	enrolmentperiod: 99
133	upperagelimit: 999	127	upperagelimit: 999
134	dateofbirthrequired: 18	128	dateofbirthrequired: 18
135	finetype: ~
136	enrolmentfee: '0.000000'	129	enrolmentfee: '0.000000'
137	overduenoticerequired: 0	130	overduenoticerequired: 0
138	issuelimit: ~	131	issuelimit: ~
Lines 145-151 tables: Link Here
145	enrolmentperiod: 99	138	enrolmentperiod: 99
146	upperagelimit: 17	139	upperagelimit: 17
147	dateofbirthrequired: 5	140	dateofbirthrequired: 5
148	finetype: ~
149	enrolmentfee: '0.000000'	141	enrolmentfee: '0.000000'
150	overduenoticerequired: 1	142	overduenoticerequired: 1
151	issuelimit: ~	143	issuelimit: ~
Lines 159-165 tables: Link Here
159	enrolmentperiod: 99	151	enrolmentperiod: 99
160	upperagelimit: 999	152	upperagelimit: 999
161	dateofbirthrequired: 18	153	dateofbirthrequired: 18
162	finetype: ~
163	enrolmentfee: '0.000000'	154	enrolmentfee: '0.000000'
164	overduenoticerequired: 1	155	overduenoticerequired: 1
165	issuelimit: ~	156	issuelimit: ~
Lines 172-178 tables: Link Here
172	enrolmentperiod: 99	163	enrolmentperiod: 99
173	upperagelimit: 999	164	upperagelimit: 999
174	dateofbirthrequired: 18	165	dateofbirthrequired: 18
175	finetype: ~
176	enrolmentfee: '0.000000'	166	enrolmentfee: '0.000000'
177	overduenoticerequired: 1	167	overduenoticerequired: 1
178	issuelimit: ~	168	issuelimit: ~
Lines 185-191 tables: Link Here
185	enrolmentperiod: 99	175	enrolmentperiod: 99
186	upperagelimit: 999	176	upperagelimit: 999
187	dateofbirthrequired: 18	177	dateofbirthrequired: 18
188	finetype: ~
189	enrolmentfee: '0.000000'	178	enrolmentfee: '0.000000'
190	overduenoticerequired: 1	179	overduenoticerequired: 1
191	issuelimit: ~	180	issuelimit: ~
Lines 199-205 tables: Link Here
199	enrolmentperiod: 99	188	enrolmentperiod: 99
200	upperagelimit: 999	189	upperagelimit: 999
201	dateofbirthrequired: 18	190	dateofbirthrequired: 18
202	finetype: ~
203	enrolmentfee: '0.000000'	191	enrolmentfee: '0.000000'
204	overduenoticerequired: 0	192	overduenoticerequired: 0
205	issuelimit: ~	193	issuelimit: ~

Lines 79-85 my $samplecat = { Link Here

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