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

(-)a/C4/Serials.pm (-2 / +2 lines)
Lines 1863-1869 sub GetLateOrMissingIssues { Link Here
1863
                serialid,      aqbooksellerid,        name,
1863
                serialid,      aqbooksellerid,        name,
1864
                biblio.title,  biblioitems.issn,      planneddate,    serialseq,
1864
                biblio.title,  biblioitems.issn,      planneddate,    serialseq,
1865
                serial.status, serial.subscriptionid, claimdate, claims_count,
1865
                serial.status, serial.subscriptionid, claimdate, claims_count,
1866
                subscription.branchcode
1866
                subscription.branchcode, serial.publisheddate
1867
            FROM      serial
1867
            FROM      serial
1868
                LEFT JOIN subscription  ON serial.subscriptionid=subscription.subscriptionid
1868
                LEFT JOIN subscription  ON serial.subscriptionid=subscription.subscriptionid
1869
                LEFT JOIN biblio        ON subscription.biblionumber=biblio.biblionumber
1869
                LEFT JOIN biblio        ON subscription.biblionumber=biblio.biblionumber
Lines 1881-1887 sub GetLateOrMissingIssues { Link Here
1881
            serialid,      aqbooksellerid,         name,
1881
            serialid,      aqbooksellerid,         name,
1882
            biblio.title,  planneddate,           serialseq,
1882
            biblio.title,  planneddate,           serialseq,
1883
                serial.status, serial.subscriptionid, claimdate, claims_count,
1883
                serial.status, serial.subscriptionid, claimdate, claims_count,
1884
                subscription.branchcode
1884
                subscription.branchcode, serial.publisheddate
1885
            FROM serial
1885
            FROM serial
1886
                LEFT JOIN subscription ON serial.subscriptionid=subscription.subscriptionid
1886
                LEFT JOIN subscription ON serial.subscriptionid=subscription.subscriptionid
1887
                LEFT JOIN biblio ON subscription.biblionumber=biblio.biblionumber
1887
                LEFT JOIN biblio ON subscription.biblionumber=biblio.biblionumber
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/serials/claims.tt (-4 / +9 lines)
Lines 2-7 Link Here
2
[% USE Asset %]
2
[% USE Asset %]
3
[% USE AuthorisedValues %]
3
[% USE AuthorisedValues %]
4
[% USE Branches %]
4
[% USE Branches %]
5
[% USE KohaDates %]
5
[% SET footerjs = 1 %]
6
[% SET footerjs = 1 %]
6
[% INCLUDE 'doc-head-open.inc' %]
7
[% INCLUDE 'doc-head-open.inc' %]
7
    <title>[% IF ( supplierid ) -%] Claims for [% suppliername | html %] [% END %] &rsaquo; Claims &rsaquo; Serials &rsaquo; Koha</title>
8
    <title>[% IF ( supplierid ) -%] Claims for [% suppliername | html %] [% END %] &rsaquo; Claims &rsaquo; Serials &rsaquo; Koha</title>
Lines 117-122 Link Here
117
                        <th>Issue number</th>
118
                        <th>Issue number</th>
118
                        <th>Status</th>
119
                        <th>Status</th>
119
                        <th>Since</th>
120
                        <th>Since</th>
121
                        <th>Published on</th>
120
                        <th>Claims count</th>
122
                        <th>Claims count</th>
121
                        <th>Claim date</th>
123
                        <th>Claim date</th>
122
                        [% FOR field IN additional_fields_for_subscription %]
124
                        [% FOR field IN additional_fields_for_subscription %]
Lines 134-143 Link Here
134
                    <td><input type="text" class="filter" data-column_num="5" placeholder="Search issue number" /></td>
136
                    <td><input type="text" class="filter" data-column_num="5" placeholder="Search issue number" /></td>
135
                    <td><input type="text" class="filter" data-column_num="6" placeholder="Search status" /></td>
137
                    <td><input type="text" class="filter" data-column_num="6" placeholder="Search status" /></td>
136
                    <td><input type="text" class="filter" data-column_num="7" placeholder="Search since" /></td>
138
                    <td><input type="text" class="filter" data-column_num="7" placeholder="Search since" /></td>
137
                    <td><input type="text" class="filter" data-column_num="8" placeholder="Search claim count" /></td>
139
                    <td><input type="text" class="filter" data-column_num="8" placeholder="Search published on" /></td>
138
                    <td><input type="text" class="filter" data-column_num="9" placeholder="Search claim date" /></td>
140
                    <td><input type="text" class="filter" data-column_num="9" placeholder="Search claim count" /></td>
141
                    <td><input type="text" class="filter" data-column_num="10" placeholder="Search claim date" /></td>
139
                    [% FOR field IN additional_fields_for_subscription %]
142
                    [% FOR field IN additional_fields_for_subscription %]
140
                      <td><input type="text" class="filter" data-column_num="[% loop.count + 9 | html %]" placeholder="Search [% field.name | html %]" /></td>
143
                      <td><input type="text" class="filter" data-column_num="[% loop.count + 10 | html %]" placeholder="Search [% field.name | html %]" /></td>
141
                    [% END %]
144
                    [% END %]
142
                  </tr>
145
                  </tr>
143
                </tfoot>
146
                </tfoot>
Lines 170-175 Link Here
170
                        <td class="planneddate" data-order="[% missingissue.planneddateISO | html %]">
173
                        <td class="planneddate" data-order="[% missingissue.planneddateISO | html %]">
171
                            [% missingissue.planneddate | html %]
174
                            [% missingissue.planneddate | html %]
172
                        </td>
175
                        </td>
176
                        <td class="publisheddate" data-order="[% missingissue.publisheddate | html %]">
177
                            [% missingissue.publisheddate | $KohaDates %]
178
                        </td>
173
                        <td>[% missingissue.claims_count | html %]</td>
179
                        <td>[% missingissue.claims_count | html %]</td>
174
                        <td data-order="[% missingissue.claimdateISO | html %]">
180
                        <td data-order="[% missingissue.claimdateISO | html %]">
175
                            [% missingissue.claimdate | html %]
181
                            [% missingissue.claimdate | html %]
176
- 

Return to bug 30039