37 |
sub lookup { |
sub lookup { |
38 |
my $self = shift; |
my $self = shift; |
39 |
my $field = shift; |
my $field = shift; |
40 |
|
my $table = shift; |
41 |
|
my $where = ''; |
42 |
|
|
43 |
|
if ( ! $table ) { |
44 |
|
$table = "archive_$field"; |
45 |
|
$where = " and lang = 'hr'"; |
46 |
|
} |
47 |
|
|
48 |
my $sql = qq{ |
my $sql = qq{ |
49 |
SELECT $field |
SELECT $field |
50 |
FROM archive_$field |
FROM $table |
51 |
WHERE eprintid = $id and lang = 'hr' |
WHERE eprintid = $id $where |
52 |
}; |
}; |
53 |
warn "# sql: $sql\n" if $debug; |
warn "# sql: $sql\n" if $debug; |
54 |
my @results = map { _x( $_->{$field} ) } @{ $dbh->selectall_arrayref($sql, { Slice => {} }) }; |
my @results = map { _x( $_->{$field} ) } @{ $dbh->selectall_arrayref($sql, { Slice => {} }) }; |