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

(-)a/Koha/Patron/Category.pm (-1 lines)
Lines 245-251 sub to_api_mapping { Link Here
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
(-)a/installer/data/mysql/en/optional/patron_categories.yml (-12 lines)
Lines 52-58 tables: Link Here
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: ~
(-)a/installer/data/mysql/kohastructure.sql (-1 lines)
Lines 1779-1785 CREATE TABLE `categories` ( Link Here
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',
(-)a/t/db_dependent/Circulation/GetHardDueDate.t (-7 / +5 lines)
Lines 79-85 my $samplecat = { Link Here
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
- 

Return to bug 35539