View | Details | Raw Unified | Return to bug 23450
Collapse All | Expand All

(-)a/C4/Serials.pm (-1 / +3 lines)
Lines 539-550 sub SearchSubscriptions { Link Here
539
            biblio.author,
539
            biblio.author,
540
            biblio.biblionumber,
540
            biblio.biblionumber,
541
            aqbooksellers.name AS vendorname,
541
            aqbooksellers.name AS vendorname,
542
            biblioitems.issn
542
            biblioitems.issn,
543
            items.price
543
        FROM subscription
544
        FROM subscription
544
            LEFT JOIN subscriptionhistory USING(subscriptionid)
545
            LEFT JOIN subscriptionhistory USING(subscriptionid)
545
            LEFT JOIN biblio ON biblio.biblionumber = subscription.biblionumber
546
            LEFT JOIN biblio ON biblio.biblionumber = subscription.biblionumber
546
            LEFT JOIN biblioitems ON biblioitems.biblionumber = subscription.biblionumber
547
            LEFT JOIN biblioitems ON biblioitems.biblionumber = subscription.biblionumber
547
            LEFT JOIN aqbooksellers ON subscription.aqbooksellerid = aqbooksellers.id
548
            LEFT JOIN aqbooksellers ON subscription.aqbooksellerid = aqbooksellers.id
549
            LEFT JOIN items ON biblioitems.biblioitemnumber = items.biblioitemnumber
548
    |;
550
    |;
549
    $query .= q| WHERE 1|;
551
    $query .= q| WHERE 1|;
550
    my @where_strs;
552
    my @where_strs;
(-)a/catalogue/detail.pl (+2 lines)
Lines 172-177 my @subscriptions = SearchSubscriptions({ biblionumber => $biblionumber, o Link Here
172
my @subs;
172
my @subs;
173
173
174
foreach my $subscription (@subscriptions) {
174
foreach my $subscription (@subscriptions) {
175
    warn $subscription->{price};
175
    my %cell;
176
    my %cell;
176
    my $serials_to_display;
177
    my $serials_to_display;
177
    $cell{subscriptionid}    = $subscription->{subscriptionid};
178
    $cell{subscriptionid}    = $subscription->{subscriptionid};
Lines 183-188 foreach my $subscription (@subscriptions) { Link Here
183
    $cell{callnumber}        = $subscription->{callnumber};
184
    $cell{callnumber}        = $subscription->{callnumber};
184
    $cell{location}          = $subscription->{location};
185
    $cell{location}          = $subscription->{location};
185
    $cell{closed}            = $subscription->{closed};
186
    $cell{closed}            = $subscription->{closed};
187
    $cell{price}             = $subscription->{price};
186
    #get the three latest serials.
188
    #get the three latest serials.
187
    $serials_to_display = $subscription->{staffdisplaycount};
189
    $serials_to_display = $subscription->{staffdisplaycount};
188
    $serials_to_display = C4::Context->preference('StaffSerialIssueDisplayCount') unless $serials_to_display;
190
    $serials_to_display = C4::Context->preference('StaffSerialIssueDisplayCount') unless $serials_to_display;
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/catalogue/detail.tt (-1 / +2 lines)
Lines 513-518 Link Here
513
                    <th>Date arrived</th>
513
                    <th>Date arrived</th>
514
                    <th>Date published</th>
514
                    <th>Date published</th>
515
                    <th>Status</th>
515
                    <th>Status</th>
516
                    <th>Issue price</th>
516
                    <th>Note</th>
517
                    <th>Note</th>
517
                </tr>
518
                </tr>
518
            [% FOREACH latestserial IN subscription.latestserials %]
519
            [% FOREACH latestserial IN subscription.latestserials %]
Lines 534-539 Link Here
534
                      [% IF ( latestserial.status7 ) %]Claimed[% END %]
535
                      [% IF ( latestserial.status7 ) %]Claimed[% END %]
535
                      [% IF ( latestserial.status8 ) %]Stopped[% END %]
536
                      [% IF ( latestserial.status8 ) %]Stopped[% END %]
536
                    </td>
537
                    </td>
538
                    <td>[% latestserial.price | html %]</td>
537
                    <td>[% latestserial.notes | html %]</td>
539
                    <td>[% latestserial.notes | html %]</td>
538
                </tr>
540
                </tr>
539
            [% END %]
541
            [% END %]
540
- 

Return to bug 23450