Lines 496-508
$template->param( 'bad_yaml_prefs' => \@bad_yaml_prefs ) if @bad_yaml_prefs;
Link Here
|
496 |
{ |
496 |
{ |
497 |
my $dbh = C4::Context->dbh; |
497 |
my $dbh = C4::Context->dbh; |
498 |
my ($bad_relationships_count) = $dbh->selectall_arrayref(q{ |
498 |
my ($bad_relationships_count) = $dbh->selectall_arrayref(q{ |
499 |
SELECT COUNT(*) FROM borrower_relationships WHERE relationship='_bad_data' |
499 |
SELECT COUNT(*) |
|
|
500 |
FROM ( |
501 |
SELECT relationship FROM borrower_relationships WHERE relationship='_bad_data' |
500 |
}); |
502 |
}); |
501 |
|
503 |
|
502 |
$bad_relationships_count = $bad_relationships_count->[0]->[0]; |
504 |
$bad_relationships_count = $bad_relationships_count->[0]->[0]; |
503 |
|
505 |
|
504 |
my $existing_relationships = $dbh->selectall_arrayref(q{ |
506 |
my $existing_relationships = $dbh->selectall_arrayref(q{ |
505 |
SELECT DISTINCT(relationship) FROM borrower_relationships WHERE relationship IS NOT NULL |
507 |
SELECT DISTINCT(relationship) |
|
|
508 |
FROM ( |
509 |
SELECT relationship FROM borrower_relationships WHERE relationship IS NOT NULL |
506 |
}); |
510 |
}); |
507 |
|
511 |
|
508 |
my %valid_relationships = map { $_ => 1 } split( /,|\|/, C4::Context->preference('borrowerRelationship') ); |
512 |
my %valid_relationships = map { $_ => 1 } split( /,|\|/, C4::Context->preference('borrowerRelationship') ); |
509 |
- |
|
|