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

(-)a/Koha/Patron/Category.pm (-1 lines)
Lines 246-252 sub to_api_mapping { Link Here
246
        upperagelimit                     => 'upper_age_limit',
246
        upperagelimit                     => 'upper_age_limit',
247
        dateofbirthrequired               => 'lower_age_limit',
247
        dateofbirthrequired               => 'lower_age_limit',
248
        finetype                          => undef,                                 # Unused
248
        finetype                          => undef,                                 # Unused
249
        bulk                              => undef,                                 # Unused
250
        enrolmentfee                      => 'enrolment_fee',
249
        enrolmentfee                      => 'enrolment_fee',
251
        overduenoticerequired             => 'overdue_notice_required',
250
        overduenoticerequired             => 'overdue_notice_required',
252
        issuelimit                        => undef,                                 # Unused
251
        issuelimit                        => undef,                                 # Unused
(-)a/installer/data/mysql/en/optional/patron_categories.yml (-12 lines)
Lines 53-59 tables: Link Here
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: ~
(-)a/installer/data/mysql/kohastructure.sql (-1 lines)
Lines 1780-1786 CREATE TABLE `categories` ( Link Here
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',
1782
  `finetype` varchar(30) DEFAULT NULL COMMENT 'unused in Koha',
1783
  `bulk` tinyint(1) DEFAULT NULL,
1784
  `enrolmentfee` decimal(28,6) DEFAULT NULL COMMENT 'enrollment fee for the patron',
1783
  `enrolmentfee` decimal(28,6) DEFAULT NULL COMMENT 'enrollment fee for the patron',
1785
  `overduenoticerequired` tinyint(1) DEFAULT NULL COMMENT 'are overdue notices sent to this patron category (1 for yes, 0 for no)',
1784
  `overduenoticerequired` tinyint(1) DEFAULT NULL COMMENT 'are overdue notices sent to this patron category (1 for yes, 0 for no)',
1786
  `issuelimit` smallint(6) DEFAULT NULL COMMENT 'unused in Koha',
1785
  `issuelimit` smallint(6) DEFAULT NULL COMMENT 'unused in Koha',
(-)a/t/db_dependent/Circulation/GetHardDueDate.t (-10 / +7 lines)
Lines 80-86 my $samplecat = { Link Here
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
- 

Return to bug 35539