Lines 77-88
sub GetBorrowerAttributes {
Link Here
|
77 |
FROM borrower_attributes |
77 |
FROM borrower_attributes |
78 |
JOIN borrower_attribute_types USING (code) |
78 |
JOIN borrower_attribute_types USING (code) |
79 |
LEFT JOIN authorised_values ON (category = authorised_value_category AND attribute = authorised_value) |
79 |
LEFT JOIN authorised_values ON (category = authorised_value_category AND attribute = authorised_value) |
80 |
WHERE 1"; |
80 |
WHERE borrowernumber = ?"; |
81 |
$query .= "\nAND borrowernumber = ?" if $borrowernumber; |
|
|
82 |
$query .= "\nAND opac_display = 1" if $opac_only; |
81 |
$query .= "\nAND opac_display = 1" if $opac_only; |
83 |
$query .= "\nORDER BY code, attribute"; |
82 |
$query .= "\nORDER BY code, attribute"; |
84 |
my $sth = $dbh->prepare_cached($query); |
83 |
my $sth = $dbh->prepare_cached($query); |
85 |
$sth->execute($borrowernumber ? $borrowernumber : ()); |
84 |
$sth->execute($borrowernumber); |
86 |
my @results = (); |
85 |
my @results = (); |
87 |
while (my $row = $sth->fetchrow_hashref()) { |
86 |
while (my $row = $sth->fetchrow_hashref()) { |
88 |
push @results, { |
87 |
push @results, { |
89 |
- |
|
|