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

(-)a/Koha/Patron/Category.pm (-1 lines)
Lines 247-253 sub to_api_mapping { Link Here
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',
(-)a/installer/data/mysql/en/optional/patron_categories.yml (-12 lines)
Lines 54-60 tables: Link Here
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
(-)a/installer/data/mysql/kohastructure.sql (-1 lines)
Lines 1781-1787 CREATE TABLE `categories` ( Link Here
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)',
(-)a/t/db_dependent/Circulation/GetHardDueDate.t (-9 / +6 lines)
Lines 81-101 my $samplecat = { Link Here
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
- 

Return to bug 35539