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

(-)a/C4/Serials.pm (-1 / +2 lines)
Lines 2027-2038 sub GetLateOrMissingIssues { Link Here
2027
        $sth = $dbh->prepare(
2027
        $sth = $dbh->prepare(
2028
            "SELECT
2028
            "SELECT
2029
                serialid,      aqbooksellerid,        name,
2029
                serialid,      aqbooksellerid,        name,
2030
                biblio.title,  planneddate,           serialseq,
2030
                biblio.title,  biblioitems.issn,      planneddate,    serialseq,
2031
                serial.status, serial.subscriptionid, claimdate,
2031
                serial.status, serial.subscriptionid, claimdate,
2032
                subscription.branchcode
2032
                subscription.branchcode
2033
            FROM      serial 
2033
            FROM      serial 
2034
                LEFT JOIN subscription  ON serial.subscriptionid=subscription.subscriptionid 
2034
                LEFT JOIN subscription  ON serial.subscriptionid=subscription.subscriptionid 
2035
                LEFT JOIN biblio        ON subscription.biblionumber=biblio.biblionumber
2035
                LEFT JOIN biblio        ON subscription.biblionumber=biblio.biblionumber
2036
                LEFT JOIN biblioitems   ON subscription.biblionumber=biblioitems.biblionumber
2036
                LEFT JOIN aqbooksellers ON subscription.aqbooksellerid = aqbooksellers.id
2037
                LEFT JOIN aqbooksellers ON subscription.aqbooksellerid = aqbooksellers.id
2037
                WHERE subscription.subscriptionid = serial.subscriptionid 
2038
                WHERE subscription.subscriptionid = serial.subscriptionid 
2038
                AND (serial.STATUS IN (4, 41, 42, 43, 44) OR ((planneddate < now() AND serial.STATUS =1) OR serial.STATUS = 3 OR serial.STATUS = 7))
2039
                AND (serial.STATUS IN (4, 41, 42, 43, 44) OR ((planneddate < now() AND serial.STATUS =1) OR serial.STATUS = 3 OR serial.STATUS = 7))
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/serials/claims.tt (-1 / +4 lines)
Lines 263-268 Link Here
263
                    <th>Vendor</th>
263
                    <th>Vendor</th>
264
                    <th>Library</th>
264
                    <th>Library</th>
265
                    <th>Title</th>
265
                    <th>Title</th>
266
                    <th>ISSN</th>
266
                    <th>Issue number</th>
267
                    <th>Issue number</th>
267
                    <th>Status</th>
268
                    <th>Status</th>
268
                    <th>Since</th>
269
                    <th>Since</th>
Lines 283-288 Link Here
283
                        <a href="/cgi-bin/koha/serials/subscription-detail.pl?subscriptionid=[% missingissue.subscriptionid %]">[% missingissue.title |html %]</a>
284
                        <a href="/cgi-bin/koha/serials/subscription-detail.pl?subscriptionid=[% missingissue.subscriptionid %]">[% missingissue.title |html %]</a>
284
                        </td>
285
                        </td>
285
                        <td>
286
                        <td>
287
                          [% missingissue.issn %]
288
                        </td>
289
                        <td>
286
                        [% missingissue.serialseq %]
290
                        [% missingissue.serialseq %]
287
                        </td>
291
                        </td>
288
                        <td>
292
                        <td>
289
- 

Return to bug 11861