-=head2 ModClassSource
-
- ModClassSource($cn_source, $description, $used, $class_sort_rule);
-
- Updates a class_sources row.
-
-=cut
-
-sub ModClassSource {
-
- my ($cn_source, $description, $used, $class_sort_rule) = @_;
- my $dbh = C4::Context->dbh;
- my $sth = $dbh->prepare_cached("UPDATE `class_sources`
- SET `description` = ?,
- `used` = ?,
- `class_sort_rule` = ?
- WHERE `cn_source` = ?");
- $sth->execute($description, $used, $class_sort_rule, $cn_source);
- $sth->finish();
-
-}
-
-=head2 DelClassSource
-
- DelClassSource($cn_source);
-
- Deletes class_sources row.
-
-=cut
-
-sub DelClassSource {
-
- my ($cn_source) = @_;
- my $dbh = C4::Context->dbh;
- my $sth = $dbh->prepare_cached("DELETE FROM `class_sources` WHERE `cn_source` = ?");
- $sth->execute($cn_source);
- $sth->finish();
-
-}
-
-=head2 GetClassSortRules
-
- my $sort_rules = GetClassSortRules();
-
-Returns reference to hash of references to
-the class sorting rules, keyed on class_sort_rule
-
-=head3 Example
-
- my $sort_rules = GetClassSortRules();
- my @sort_rules = ();
- foreach my $sort_rule (sort keys %$sort_rules) {
- my $sort_rule = $sort_rules->{$sort_rule};
- push @sort_rules,
- {
- rule => $sort_rule->{'class_sort_rule'},
- description => $sort_rule->{'description'},
- sort_routine => $sort_rule->{'sort_routine'}
- }
- }
-
-=cut
-
-sub GetClassSortRules {
-
- my %class_sort_rules = ();
- my $dbh = C4::Context->dbh;
- my $sth = $dbh->prepare_cached("SELECT * FROM `class_sort_rules`");
- $sth->execute();
- while (my $sort_rule = $sth->fetchrow_hashref) {
- $class_sort_rules{ $sort_rule->{'class_sort_rule'} } = $sort_rule;
- }
- $sth->finish();
-
- return \%class_sort_rules;
-
-}
-
-=head2 AddClassSortRule
-
- AddClassSortRule($class_sort_rule, $description, $sort_routine);
-
- Adds a class_sort_rules row.
-
-=cut
-
-sub AddClassSortRule {
-
- my ($class_sort_rule, $description, $sort_routine) = @_;
- my $dbh = C4::Context->dbh;
- my $sth = $dbh->prepare_cached("INSERT INTO `class_sort_rules`
- (`class_sort_rule`, `description`, `sort_routine`)
- VALUES (?, ?, ?)");
- $sth->execute($class_sort_rule, $description, $sort_routine);
- $sth->finish();
-
-}
-