Lines 98-104
sub GetClassSources {
Link Here
|
98 |
while (my $source = $sth->fetchrow_hashref) { |
98 |
while (my $source = $sth->fetchrow_hashref) { |
99 |
$class_sources{ $source->{'cn_source'} } = $source; |
99 |
$class_sources{ $source->{'cn_source'} } = $source; |
100 |
} |
100 |
} |
101 |
$sth->finish(); |
|
|
102 |
|
101 |
|
103 |
return \%class_sources; |
102 |
return \%class_sources; |
104 |
|
103 |
|
Lines 120-126
sub AddClassSource {
Link Here
|
120 |
(`cn_source`, `description`, `used`, `class_sort_rule`) |
119 |
(`cn_source`, `description`, `used`, `class_sort_rule`) |
121 |
VALUES (?, ?, ?, ?)"); |
120 |
VALUES (?, ?, ?, ?)"); |
122 |
$sth->execute($cn_source, $description, $used, $class_sort_rule); |
121 |
$sth->execute($cn_source, $description, $used, $class_sort_rule); |
123 |
$sth->finish(); |
|
|
124 |
|
122 |
|
125 |
} |
123 |
} |
126 |
|
124 |
|
Lines 139-145
sub GetClassSource {
Link Here
|
139 |
my $sth = $dbh->prepare_cached("SELECT * FROM `class_sources` WHERE cn_source = ?"); |
137 |
my $sth = $dbh->prepare_cached("SELECT * FROM `class_sources` WHERE cn_source = ?"); |
140 |
$sth->execute($cn_source); |
138 |
$sth->execute($cn_source); |
141 |
my $row = $sth->fetchrow_hashref(); |
139 |
my $row = $sth->fetchrow_hashref(); |
142 |
$sth->finish(); |
|
|
143 |
return $row; |
140 |
return $row; |
144 |
} |
141 |
} |
145 |
|
142 |
|
Lines 161-167
sub ModClassSource {
Link Here
|
161 |
`class_sort_rule` = ? |
158 |
`class_sort_rule` = ? |
162 |
WHERE `cn_source` = ?"); |
159 |
WHERE `cn_source` = ?"); |
163 |
$sth->execute($description, $used, $class_sort_rule, $cn_source); |
160 |
$sth->execute($description, $used, $class_sort_rule, $cn_source); |
164 |
$sth->finish(); |
|
|
165 |
|
161 |
|
166 |
} |
162 |
} |
167 |
|
163 |
|
Lines 179-185
sub DelClassSource {
Link Here
|
179 |
my $dbh = C4::Context->dbh; |
175 |
my $dbh = C4::Context->dbh; |
180 |
my $sth = $dbh->prepare_cached("DELETE FROM `class_sources` WHERE `cn_source` = ?"); |
176 |
my $sth = $dbh->prepare_cached("DELETE FROM `class_sources` WHERE `cn_source` = ?"); |
181 |
$sth->execute($cn_source); |
177 |
$sth->execute($cn_source); |
182 |
$sth->finish(); |
|
|
183 |
|
178 |
|
184 |
} |
179 |
} |
185 |
|
180 |
|
Lines 215-221
sub GetClassSortRules {
Link Here
|
215 |
while (my $sort_rule = $sth->fetchrow_hashref) { |
210 |
while (my $sort_rule = $sth->fetchrow_hashref) { |
216 |
$class_sort_rules{ $sort_rule->{'class_sort_rule'} } = $sort_rule; |
211 |
$class_sort_rules{ $sort_rule->{'class_sort_rule'} } = $sort_rule; |
217 |
} |
212 |
} |
218 |
$sth->finish(); |
|
|
219 |
|
213 |
|
220 |
return \%class_sort_rules; |
214 |
return \%class_sort_rules; |
221 |
|
215 |
|
Lines 237-243
sub AddClassSortRule {
Link Here
|
237 |
(`class_sort_rule`, `description`, `sort_routine`) |
231 |
(`class_sort_rule`, `description`, `sort_routine`) |
238 |
VALUES (?, ?, ?)"); |
232 |
VALUES (?, ?, ?)"); |
239 |
$sth->execute($class_sort_rule, $description, $sort_routine); |
233 |
$sth->execute($class_sort_rule, $description, $sort_routine); |
240 |
$sth->finish(); |
|
|
241 |
|
234 |
|
242 |
} |
235 |
} |
243 |
|
236 |
|
Lines 256-262
sub GetClassSortRule {
Link Here
|
256 |
my $sth = $dbh->prepare_cached("SELECT * FROM `class_sort_rules` WHERE `class_sort_rule` = ?"); |
249 |
my $sth = $dbh->prepare_cached("SELECT * FROM `class_sort_rules` WHERE `class_sort_rule` = ?"); |
257 |
$sth->execute($class_sort_rule); |
250 |
$sth->execute($class_sort_rule); |
258 |
my $row = $sth->fetchrow_hashref(); |
251 |
my $row = $sth->fetchrow_hashref(); |
259 |
$sth->finish(); |
|
|
260 |
return $row; |
252 |
return $row; |
261 |
} |
253 |
} |
262 |
|
254 |
|
Lines 277-283
sub ModClassSortRule {
Link Here
|
277 |
`sort_routine` = ? |
269 |
`sort_routine` = ? |
278 |
WHERE `class_sort_rule` = ?"); |
270 |
WHERE `class_sort_rule` = ?"); |
279 |
$sth->execute($description, $sort_routine, $class_sort_rule); |
271 |
$sth->execute($description, $sort_routine, $class_sort_rule); |
280 |
$sth->finish(); |
|
|
281 |
|
272 |
|
282 |
} |
273 |
} |
283 |
|
274 |
|
Lines 295-301
sub DelClassSortRule {
Link Here
|
295 |
my $dbh = C4::Context->dbh; |
286 |
my $dbh = C4::Context->dbh; |
296 |
my $sth = $dbh->prepare_cached("DELETE FROM `class_sort_rules` WHERE `class_sort_rule` = ?"); |
287 |
my $sth = $dbh->prepare_cached("DELETE FROM `class_sort_rules` WHERE `class_sort_rule` = ?"); |
297 |
$sth->execute($class_sort_rule); |
288 |
$sth->execute($class_sort_rule); |
298 |
$sth->finish(); |
|
|
299 |
|
289 |
|
300 |
} |
290 |
} |
301 |
|
291 |
|
Lines 319-325
sub GetSourcesForSortRule {
Link Here
|
319 |
while (my ($source) = $sth->fetchrow_array()) { |
309 |
while (my ($source) = $sth->fetchrow_array()) { |
320 |
push @sources, $source; |
310 |
push @sources, $source; |
321 |
} |
311 |
} |
322 |
$sth->finish(); |
|
|
323 |
return @sources; |
312 |
return @sources; |
324 |
|
313 |
|
325 |
} |
314 |
} |
326 |
- |
|
|