|
Lines 273-279
sub GetAllIssues {
Link Here
|
| 273 |
|
273 |
|
| 274 |
my $dbh = C4::Context->dbh; |
274 |
my $dbh = C4::Context->dbh; |
| 275 |
my $query = |
275 |
my $query = |
| 276 |
'SELECT *, issues.timestamp as issuestimestamp, issues.renewals AS renewals,items.renewals AS totalrenewals,items.timestamp AS itemstimestamp |
276 |
'SELECT issues.*, items.*, biblio.*, biblioitems.*, issues.timestamp as issuestimestamp, issues.renewals AS renewals,items.renewals AS totalrenewals,items.timestamp AS itemstimestamp,borrowers.firstname,borrowers.surname |
| 277 |
FROM issues |
277 |
FROM issues |
| 278 |
LEFT JOIN items on items.itemnumber=issues.itemnumber |
278 |
LEFT JOIN items on items.itemnumber=issues.itemnumber |
| 279 |
LEFT JOIN borrowers on borrowers.borrowernumber=issues.issuer |
279 |
LEFT JOIN borrowers on borrowers.borrowernumber=issues.issuer |
|
Lines 281-287
sub GetAllIssues {
Link Here
|
| 281 |
LEFT JOIN biblioitems ON items.biblioitemnumber=biblioitems.biblioitemnumber |
281 |
LEFT JOIN biblioitems ON items.biblioitemnumber=biblioitems.biblioitemnumber |
| 282 |
WHERE issues.borrowernumber=? |
282 |
WHERE issues.borrowernumber=? |
| 283 |
UNION ALL |
283 |
UNION ALL |
| 284 |
SELECT *, old_issues.timestamp as issuestimestamp, old_issues.renewals AS renewals,items.renewals AS totalrenewals,items.timestamp AS itemstimestamp |
284 |
SELECT old_issues.*, items.*, biblio.*, biblioitems.*, old_issues.timestamp as issuestimestamp, old_issues.renewals AS renewals,items.renewals AS totalrenewals,items.timestamp AS itemstimestamp,borrowers.firstname,borrowers.surname |
| 285 |
FROM old_issues |
285 |
FROM old_issues |
| 286 |
LEFT JOIN items on items.itemnumber=old_issues.itemnumber |
286 |
LEFT JOIN items on items.itemnumber=old_issues.itemnumber |
| 287 |
LEFT JOIN borrowers on borrowers.borrowernumber=old_issues.issuer |
287 |
LEFT JOIN borrowers on borrowers.borrowernumber=old_issues.issuer |
| 288 |
- |
|
|