|
Lines 126-134
sub get_opac_new {
Link Here
|
| 126 |
my ($idnew) = @_; |
126 |
my ($idnew) = @_; |
| 127 |
my $dbh = C4::Context->dbh; |
127 |
my $dbh = C4::Context->dbh; |
| 128 |
my $query = q{ |
128 |
my $query = q{ |
| 129 |
SELECT opac_news.*,branches.branchname |
129 |
SELECT opac_news.*,branches.branchname, |
|
|
130 |
timestamp AS newdate, |
| 131 |
borrowers.title AS author_title, |
| 132 |
borrowers.firstname AS author_firstname, |
| 133 |
borrowers.surname AS author_surname |
| 130 |
FROM opac_news LEFT JOIN branches |
134 |
FROM opac_news LEFT JOIN branches |
| 131 |
ON opac_news.branchcode=branches.branchcode |
135 |
ON opac_news.branchcode=branches.branchcode |
|
|
136 |
LEFT JOIN borrowers on borrowers.borrowernumber = opac_news.borrowernumber |
| 132 |
WHERE opac_news.idnew = ?; |
137 |
WHERE opac_news.idnew = ?; |
| 133 |
}; |
138 |
}; |
| 134 |
my $sth = $dbh->prepare($query); |
139 |
my $sth = $dbh->prepare($query); |
| 135 |
- |
|
|