Attachment #169209 for bug #35539

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

Lines 288-294 sub to_api_mapping { Link Here

(-)a/Koha/Patron/Category.pm (-1 lines)
288	upperagelimit => 'upper_age_limit',	288	upperagelimit => 'upper_age_limit',
289	dateofbirthrequired => 'lower_age_limit',	289	dateofbirthrequired => 'lower_age_limit',
290	finetype => undef, # Unused	290	finetype => undef, # Unused
291	bulk => undef, # Unused
292	enrolmentfee => 'enrolment_fee',	291	enrolmentfee => 'enrolment_fee',
293	overduenoticerequired => 'overdue_notice_required',	292	overduenoticerequired => 'overdue_notice_required',
294	issuelimit => undef, # Unused	293	issuelimit => undef, # Unused




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

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

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

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

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

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

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

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

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

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

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

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

Lines 1789-1795 CREATE TABLE `categories` ( Link Here

(-)a/installer/data/mysql/kohastructure.sql (-1 lines)
1789	`upperagelimit` smallint(6) DEFAULT NULL COMMENT 'age limit for the patron',	1789	`upperagelimit` smallint(6) DEFAULT NULL COMMENT 'age limit for the patron',
1790	`dateofbirthrequired` tinyint(1) DEFAULT NULL COMMENT 'the minimum age required for the patron category',	1790	`dateofbirthrequired` tinyint(1) DEFAULT NULL COMMENT 'the minimum age required for the patron category',
1791	`finetype` varchar(30) DEFAULT NULL COMMENT 'unused in Koha',	1791	`finetype` varchar(30) DEFAULT NULL COMMENT 'unused in Koha',
1792	`bulk` tinyint(1) DEFAULT NULL,
1793	`enrolmentfee` decimal(28,6) DEFAULT NULL COMMENT 'enrollment fee for the patron',	1792	`enrolmentfee` decimal(28,6) DEFAULT NULL COMMENT 'enrollment fee for the patron',
1794	`overduenoticerequired` tinyint(1) DEFAULT NULL COMMENT 'are overdue notices sent to this patron category (1 for yes, 0 for no)',	1793	`overduenoticerequired` tinyint(1) DEFAULT NULL COMMENT 'are overdue notices sent to this patron category (1 for yes, 0 for no)',
1795	`issuelimit` smallint(6) DEFAULT NULL COMMENT 'unused in Koha',	1794	`issuelimit` smallint(6) DEFAULT NULL COMMENT 'unused in Koha',




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

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

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

Return to bug 35539

Lines 53-59 tables: Link Here

(-)a/installer/data/mysql/en/optional/patron_categories.yml (-12 lines)
53	upperagelimit: 999	53	upperagelimit: 999
54	dateofbirthrequired: 18	54	dateofbirthrequired: 18
55	finetype: ~	55	finetype: ~
56	bulk: ~
57	enrolmentfee: '0.000000'	56	enrolmentfee: '0.000000'
58	overduenoticerequired: 1	57	overduenoticerequired: 1
59	issuelimit: ~	58	issuelimit: ~
Lines 67-73 tables: Link Here
67	upperagelimit: 999	66	upperagelimit: 999
68	dateofbirthrequired: 18	67	dateofbirthrequired: 18
69	finetype: ~	68	finetype: ~
70	bulk: ~
71	enrolmentfee: '0.000000'	69	enrolmentfee: '0.000000'
72	overduenoticerequired: 1	70	overduenoticerequired: 1
73	issuelimit: ~	71	issuelimit: ~
Lines 81-87 tables: Link Here
81	upperagelimit: 999	79	upperagelimit: 999
82	dateofbirthrequired: 18	80	dateofbirthrequired: 18
83	finetype: ~	81	finetype: ~
84	bulk: ~
85	enrolmentfee: '0.000000'	82	enrolmentfee: '0.000000'
86	overduenoticerequired: 1	83	overduenoticerequired: 1
87	issuelimit: ~	84	issuelimit: ~
Lines 96-102 tables: Link Here
96	upperagelimit: 17	93	upperagelimit: 17
97	dateofbirthrequired: 5	94	dateofbirthrequired: 5
98	finetype: ~	95	finetype: ~
99	bulk: ~
100	enrolmentfee: '0.000000'	96	enrolmentfee: '0.000000'
101	overduenoticerequired: 1	97	overduenoticerequired: 1
102	issuelimit: ~	98	issuelimit: ~
Lines 110-116 tables: Link Here
110	upperagelimit: 17	106	upperagelimit: 17
111	dateofbirthrequired: 5	107	dateofbirthrequired: 5
112	finetype: ~	108	finetype: ~
113	bulk: ~
114	enrolmentfee: '0.000000'	109	enrolmentfee: '0.000000'
115	overduenoticerequired: 1	110	overduenoticerequired: 1
116	issuelimit: ~	111	issuelimit: ~
Lines 124-130 tables: Link Here
124	upperagelimit: 17	119	upperagelimit: 17
125	dateofbirthrequired: 5	120	dateofbirthrequired: 5
126	finetype: ~	121	finetype: ~
127	bulk: ~
128	enrolmentfee: '0.000000'	122	enrolmentfee: '0.000000'
129	overduenoticerequired: 1	123	overduenoticerequired: 1
130	issuelimit: ~	124	issuelimit: ~
Lines 139-145 tables: Link Here
139	upperagelimit: 999	133	upperagelimit: 999
140	dateofbirthrequired: 18	134	dateofbirthrequired: 18
141	finetype: ~	135	finetype: ~
142	bulk: ~
143	enrolmentfee: '0.000000'	136	enrolmentfee: '0.000000'
144	overduenoticerequired: 0	137	overduenoticerequired: 0
145	issuelimit: ~	138	issuelimit: ~
Lines 153-159 tables: Link Here
153	upperagelimit: 17	146	upperagelimit: 17
154	dateofbirthrequired: 5	147	dateofbirthrequired: 5
155	finetype: ~	148	finetype: ~
156	bulk: ~
157	enrolmentfee: '0.000000'	149	enrolmentfee: '0.000000'
158	overduenoticerequired: 1	150	overduenoticerequired: 1
159	issuelimit: ~	151	issuelimit: ~
Lines 168-174 tables: Link Here
168	upperagelimit: 999	160	upperagelimit: 999
169	dateofbirthrequired: 18	161	dateofbirthrequired: 18
170	finetype: ~	162	finetype: ~
171	bulk: ~
172	enrolmentfee: '0.000000'	163	enrolmentfee: '0.000000'
173	overduenoticerequired: 1	164	overduenoticerequired: 1
174	issuelimit: ~	165	issuelimit: ~
Lines 182-188 tables: Link Here
182	upperagelimit: 999	173	upperagelimit: 999
183	dateofbirthrequired: 18	174	dateofbirthrequired: 18
184	finetype: ~	175	finetype: ~
185	bulk: ~
186	enrolmentfee: '0.000000'	176	enrolmentfee: '0.000000'
187	overduenoticerequired: 1	177	overduenoticerequired: 1
188	issuelimit: ~	178	issuelimit: ~
Lines 196-202 tables: Link Here
196	upperagelimit: 999	186	upperagelimit: 999
197	dateofbirthrequired: 18	187	dateofbirthrequired: 18
198	finetype: ~	188	finetype: ~
199	bulk: ~
200	enrolmentfee: '0.000000'	189	enrolmentfee: '0.000000'
201	overduenoticerequired: 1	190	overduenoticerequired: 1
202	issuelimit: ~	191	issuelimit: ~
Lines 211-217 tables: Link Here
211	upperagelimit: 999	200	upperagelimit: 999
212	dateofbirthrequired: 18	201	dateofbirthrequired: 18
213	finetype: ~	202	finetype: ~
214	bulk: ~
215	enrolmentfee: '0.000000'	203	enrolmentfee: '0.000000'
216	overduenoticerequired: 0	204	overduenoticerequired: 0
217	issuelimit: ~	205	issuelimit: ~

Lines 80-86 my $samplecat = { Link Here

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