|
Lines 93-104
sub GetClassSources {
Link Here
|
| 93 |
|
93 |
|
| 94 |
my %class_sources = (); |
94 |
my %class_sources = (); |
| 95 |
my $dbh = C4::Context->dbh; |
95 |
my $dbh = C4::Context->dbh; |
| 96 |
my $sth = $dbh->prepare_cached("SELECT * FROM `class_sources`"); |
96 |
my $sth = $dbh->prepare("SELECT * FROM `class_sources`"); |
| 97 |
$sth->execute(); |
97 |
$sth->execute(); |
| 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 116-126
sub AddClassSource {
Link Here
|
| 116 |
|
115 |
|
| 117 |
my ($cn_source, $description, $used, $class_sort_rule) = @_; |
116 |
my ($cn_source, $description, $used, $class_sort_rule) = @_; |
| 118 |
my $dbh = C4::Context->dbh; |
117 |
my $dbh = C4::Context->dbh; |
| 119 |
my $sth = $dbh->prepare_cached("INSERT INTO `class_sources` |
118 |
my $sth = $dbh->prepare("INSERT INTO `class_sources` |
| 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 136-145
sub GetClassSource {
Link Here
|
| 136 |
|
134 |
|
| 137 |
my ($cn_source) = (@_); |
135 |
my ($cn_source) = (@_); |
| 138 |
my $dbh = C4::Context->dbh; |
136 |
my $dbh = C4::Context->dbh; |
| 139 |
my $sth = $dbh->prepare_cached("SELECT * FROM `class_sources` WHERE cn_source = ?"); |
137 |
my $sth = $dbh->prepare("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 155-167
sub ModClassSource {
Link Here
|
| 155 |
|
152 |
|
| 156 |
my ($cn_source, $description, $used, $class_sort_rule) = @_; |
153 |
my ($cn_source, $description, $used, $class_sort_rule) = @_; |
| 157 |
my $dbh = C4::Context->dbh; |
154 |
my $dbh = C4::Context->dbh; |
| 158 |
my $sth = $dbh->prepare_cached("UPDATE `class_sources` |
155 |
my $sth = $dbh->prepare("UPDATE `class_sources` |
| 159 |
SET `description` = ?, |
156 |
SET `description` = ?, |
| 160 |
`used` = ?, |
157 |
`used` = ?, |
| 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 177-185
sub DelClassSource {
Link Here
|
| 177 |
|
173 |
|
| 178 |
my ($cn_source) = @_; |
174 |
my ($cn_source) = @_; |
| 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("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 210-221
sub GetClassSortRules {
Link Here
|
| 210 |
|
205 |
|
| 211 |
my %class_sort_rules = (); |
206 |
my %class_sort_rules = (); |
| 212 |
my $dbh = C4::Context->dbh; |
207 |
my $dbh = C4::Context->dbh; |
| 213 |
my $sth = $dbh->prepare_cached("SELECT * FROM `class_sort_rules`"); |
208 |
my $sth = $dbh->prepare("SELECT * FROM `class_sort_rules`"); |
| 214 |
$sth->execute(); |
209 |
$sth->execute(); |
| 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 233-243
sub AddClassSortRule {
Link Here
|
| 233 |
|
227 |
|
| 234 |
my ($class_sort_rule, $description, $sort_routine) = @_; |
228 |
my ($class_sort_rule, $description, $sort_routine) = @_; |
| 235 |
my $dbh = C4::Context->dbh; |
229 |
my $dbh = C4::Context->dbh; |
| 236 |
my $sth = $dbh->prepare_cached("INSERT INTO `class_sort_rules` |
230 |
my $sth = $dbh->prepare("INSERT INTO `class_sort_rules` |
| 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 253-262
sub GetClassSortRule {
Link Here
|
| 253 |
|
246 |
|
| 254 |
my ($class_sort_rule) = (@_); |
247 |
my ($class_sort_rule) = (@_); |
| 255 |
my $dbh = C4::Context->dbh; |
248 |
my $dbh = C4::Context->dbh; |
| 256 |
my $sth = $dbh->prepare_cached("SELECT * FROM `class_sort_rules` WHERE `class_sort_rule` = ?"); |
249 |
my $sth = $dbh->prepare("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 272-283
sub ModClassSortRule {
Link Here
|
| 272 |
|
264 |
|
| 273 |
my ($class_sort_rule, $description, $sort_routine) = @_; |
265 |
my ($class_sort_rule, $description, $sort_routine) = @_; |
| 274 |
my $dbh = C4::Context->dbh; |
266 |
my $dbh = C4::Context->dbh; |
| 275 |
my $sth = $dbh->prepare_cached("UPDATE `class_sort_rules` |
267 |
my $sth = $dbh->prepare("UPDATE `class_sort_rules` |
| 276 |
SET `description` = ?, |
268 |
SET `description` = ?, |
| 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 293-301
sub DelClassSortRule {
Link Here
|
| 293 |
|
284 |
|
| 294 |
my ($class_sort_rule) = @_; |
285 |
my ($class_sort_rule) = @_; |
| 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("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 313-325
sub GetSourcesForSortRule {
Link Here
|
| 313 |
my ($class_sort_rule) = @_; |
303 |
my ($class_sort_rule) = @_; |
| 314 |
|
304 |
|
| 315 |
my $dbh = C4::Context->dbh; |
305 |
my $dbh = C4::Context->dbh; |
| 316 |
my $sth = $dbh->prepare_cached("SELECT cn_source FROM class_sources WHERE class_sort_rule = ?"); |
306 |
my $sth = $dbh->prepare("SELECT cn_source FROM class_sources WHERE class_sort_rule = ?"); |
| 317 |
$sth->execute($class_sort_rule); |
307 |
$sth->execute($class_sort_rule); |
| 318 |
my @sources = (); |
308 |
my @sources = (); |
| 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 |
- |
|
|