Lines 369-374
sub GetFullSubscription {
Link Here
|
369 |
aqbooksellers.name as aqbooksellername, |
369 |
aqbooksellers.name as aqbooksellername, |
370 |
biblio.title as bibliotitle, |
370 |
biblio.title as bibliotitle, |
371 |
subscription.branchcode AS branchcode, |
371 |
subscription.branchcode AS branchcode, |
|
|
372 |
branches.branchname AS branchname, |
372 |
subscription.subscriptionid AS subscriptionid |; |
373 |
subscription.subscriptionid AS subscriptionid |; |
373 |
if ( C4::Context->preference('IndependantBranches') |
374 |
if ( C4::Context->preference('IndependantBranches') |
374 |
&& C4::Context->userenv |
375 |
&& C4::Context->userenv |
Lines 378-392
sub GetFullSubscription {
Link Here
|
378 |
, ((subscription.branchcode <>\"" . C4::Context->userenv->{'branch'} . "\") and subscription.branchcode <>\"\" and subscription.branchcode IS NOT NULL) as cannotedit "; |
379 |
, ((subscription.branchcode <>\"" . C4::Context->userenv->{'branch'} . "\") and subscription.branchcode <>\"\" and subscription.branchcode IS NOT NULL) as cannotedit "; |
379 |
} |
380 |
} |
380 |
$query .= qq| |
381 |
$query .= qq| |
381 |
FROM serial |
382 |
FROM serial |
382 |
LEFT JOIN subscription ON |
383 |
LEFT JOIN subscription ON |
383 |
(serial.subscriptionid=subscription.subscriptionid ) |
384 |
( serial.subscriptionid = subscription.subscriptionid ) |
384 |
LEFT JOIN aqbooksellers on subscription.aqbooksellerid=aqbooksellers.id |
385 |
LEFT JOIN aqbooksellers ON |
385 |
LEFT JOIN biblio on biblio.biblionumber=subscription.biblionumber |
386 |
( subscription.aqbooksellerid = aqbooksellers.id ) |
386 |
WHERE serial.subscriptionid = ? |
387 |
LEFT JOIN biblio ON |
387 |
ORDER BY year DESC, |
388 |
( biblio.biblionumber = subscription.biblionumber ) |
388 |
IF(serial.publisheddate="00-00-0000",serial.planneddate,serial.publisheddate) DESC, |
389 |
LEFT JOIN branches ON |
389 |
serial.subscriptionid |
390 |
( subscription.branchcode = branches.branchcode ) |
|
|
391 |
WHERE serial.subscriptionid = ? |
392 |
ORDER BY year DESC, |
393 |
IF(serial.publisheddate="00-00-0000",serial.planneddate,serial.publisheddate) DESC, |
394 |
serial.subscriptionid |
390 |
|; |
395 |
|; |
391 |
$debug and warn "GetFullSubscription query: $query"; |
396 |
$debug and warn "GetFullSubscription query: $query"; |
392 |
my $sth = $dbh->prepare($query); |
397 |
my $sth = $dbh->prepare($query); |