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

(-)a/C4/Serials.pm (-2 / +61 lines)
Lines 93-99 sub GetSuppliersWithLateIssues { Link Here
93
    FROM            subscription
93
    FROM            subscription
94
    LEFT JOIN       serial ON serial.subscriptionid=subscription.subscriptionid
94
    LEFT JOIN       serial ON serial.subscriptionid=subscription.subscriptionid
95
    LEFT JOIN aqbooksellers ON subscription.aqbooksellerid = aqbooksellers.id
95
    LEFT JOIN aqbooksellers ON subscription.aqbooksellerid = aqbooksellers.id
96
    WHERE id > 0 AND ((planneddate < now() AND serial.status=1) OR serial.STATUS = 3 OR serial.STATUS = 4) ORDER BY name|;
96
    WHERE id > 0
97
        AND (
98
            (planneddate < now() AND serial.status=1)
99
            OR serial.STATUS = 3 OR serial.STATUS = 4
100
        )
101
        AND subscription.closed = 0
102
    ORDER BY name|;
97
    return $dbh->selectall_arrayref($query, { Slice => {} });
103
    return $dbh->selectall_arrayref($query, { Slice => {} });
98
}
104
}
99
105
Lines 122-127 sub GetLateIssues { Link Here
122
            LEFT JOIN  aqbooksellers ON subscription.aqbooksellerid = aqbooksellers.id
128
            LEFT JOIN  aqbooksellers ON subscription.aqbooksellerid = aqbooksellers.id
123
            WHERE      ((planneddate < now() AND serial.STATUS =1) OR serial.STATUS = 3)
129
            WHERE      ((planneddate < now() AND serial.STATUS =1) OR serial.STATUS = 3)
124
            AND        subscription.aqbooksellerid=?
130
            AND        subscription.aqbooksellerid=?
131
            AND        subscription.closed = 0
125
            ORDER BY   title
132
            ORDER BY   title
126
        |;
133
        |;
127
        $sth = $dbh->prepare($query);
134
        $sth = $dbh->prepare($query);
Lines 134-139 sub GetLateIssues { Link Here
134
            LEFT JOIN  biblio ON biblio.biblionumber = subscription.biblionumber
141
            LEFT JOIN  biblio ON biblio.biblionumber = subscription.biblionumber
135
            LEFT JOIN  aqbooksellers ON subscription.aqbooksellerid = aqbooksellers.id
142
            LEFT JOIN  aqbooksellers ON subscription.aqbooksellerid = aqbooksellers.id
136
            WHERE      ((planneddate < now() AND serial.STATUS =1) OR serial.STATUS = 3)
143
            WHERE      ((planneddate < now() AND serial.STATUS =1) OR serial.STATUS = 3)
144
            AND        subscription.closed = 0
137
            ORDER BY   title
145
            ORDER BY   title
138
        |;
146
        |;
139
        $sth = $dbh->prepare($query);
147
        $sth = $dbh->prepare($query);
Lines 685-691 sub SearchSubscriptions { Link Here
685
        push @where_strs, "subscription.branchcode = ?";
693
        push @where_strs, "subscription.branchcode = ?";
686
        push @where_args, "$args->{branch}";
694
        push @where_args, "$args->{branch}";
687
    }
695
    }
688
696
    if( defined $args->{closed} ){
697
        push @where_strs, "subscription.closed = ?";
698
        push @where_args, "$args->{closed}";
699
    }
689
    if(@where_strs){
700
    if(@where_strs){
690
        $query .= " WHERE " . join(" AND ", @where_strs);
701
        $query .= " WHERE " . join(" AND ", @where_strs);
691
    }
702
    }
Lines 2465-2470 sub is_barcode_in_use { Link Here
2465
    return @{$occurences};
2476
    return @{$occurences};
2466
}
2477
}
2467
2478
2479
=head2 CloseSubscription
2480
Close a subscription given a subscriptionid
2481
=cut
2482
sub CloseSubscription {
2483
    my ( $subscriptionid ) = @_;
2484
    return unless $subscriptionid;
2485
    my $dbh = C4::Context->dbh;
2486
    my $sth = $dbh->prepare( qq{
2487
        UPDATE subscription
2488
        SET closed = 1
2489
        WHERE subscriptionid = ?
2490
    } );
2491
    $sth->execute( $subscriptionid );
2492
2493
    # Set status = missing when status = stopped
2494
    $sth = $dbh->prepare( qq{
2495
        UPDATE serial
2496
        SET status = 8
2497
        WHERE subscriptionid = ?
2498
        AND status = 1
2499
    } );
2500
    $sth->execute( $subscriptionid );
2501
}
2502
2503
=head2 ReopenSubscription
2504
Reopen a subscription given a subscriptionid
2505
=cut
2506
sub ReopenSubscription {
2507
    my ( $subscriptionid ) = @_;
2508
    return unless $subscriptionid;
2509
    my $dbh = C4::Context->dbh;
2510
    my $sth = $dbh->prepare( qq{
2511
        UPDATE subscription
2512
        SET closed = 0
2513
        WHERE subscriptionid = ?
2514
    } );
2515
    $sth->execute( $subscriptionid );
2516
2517
    # Set status = expected when status = stopped
2518
    $sth = $dbh->prepare( qq{
2519
        UPDATE serial
2520
        SET status = 1
2521
        WHERE subscriptionid = ?
2522
        AND status = 8
2523
    } );
2524
    $sth->execute( $subscriptionid );
2525
}
2526
2468
1;
2527
1;
2469
__END__
2528
__END__
2470
2529
(-)a/installer/data/mysql/kohastructure.sql (+1 lines)
Lines 1895-1900 CREATE TABLE `subscription` ( Link Here
1895
  `opacdisplaycount` VARCHAR(10) NULL,
1895
  `opacdisplaycount` VARCHAR(10) NULL,
1896
  `graceperiod` int(11) NOT NULL default '0',
1896
  `graceperiod` int(11) NOT NULL default '0',
1897
  `enddate` date default NULL,
1897
  `enddate` date default NULL,
1898
  `closed ` INT(1) NOT NULL DEFAULT 0,
1898
  PRIMARY KEY  (`subscriptionid`)
1899
  PRIMARY KEY  (`subscriptionid`)
1899
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1900
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1900
1901
(-)a/installer/data/mysql/updatedatabase.pl (+11 lines)
Lines 5795-5800 if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) { Link Here
5795
    SetVersion($DBversion);
5795
    SetVersion($DBversion);
5796
}
5796
}
5797
5797
5798
$DBversion = "3.09.00.XXX";
5799
if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) {
5800
    if ( not column_exists( 'closed', 'subscription' ) ) {
5801
        $dbh->do(qq{
5802
            ALTER TABLE subscription ADD COLUMN closed INT(1) NOT NULL DEFAULT 0 AFTER enddate;
5803
        });
5804
    }
5805
    print "Upgrade to $DBversion done (Add field subscription.closed)\n";
5806
    SetVersion($DBversion);
5807
}
5808
5798
=head1 FUNCTIONS
5809
=head1 FUNCTIONS
5799
5810
5800
=head2 TableExists($table)
5811
=head2 TableExists($table)
(-)a/koha-tmpl/intranet-tmpl/prog/en/includes/serials-menu.inc (+2 lines)
Lines 1-6 Link Here
1
[% IF ( subscriptionid ) %]
1
[% IF ( subscriptionid ) %]
2
<ul>
2
<ul>
3
<li><a href="serials-collection.pl?subscriptionid=[% subscriptionid %]">Serial collection</a></li>
3
<li><a href="serials-collection.pl?subscriptionid=[% subscriptionid %]">Serial collection</a></li>
4
  [% UNLESS closed %]
4
    [% IF ( routing && CAN_user_serials_routing ) %]
5
    [% IF ( routing && CAN_user_serials_routing ) %]
5
        [% IF ( hasRouting ) %]
6
        [% IF ( hasRouting ) %]
6
             <li><a href="/cgi-bin/koha/serials/routing.pl?subscriptionid=[% subscriptionid %]">Edit routing list</a></li>
7
             <li><a href="/cgi-bin/koha/serials/routing.pl?subscriptionid=[% subscriptionid %]">Edit routing list</a></li>
Lines 8-13 Link Here
8
            <li><a href="/cgi-bin/koha/serials/routing.pl?subscriptionid=[% subscriptionid %]&amp;op=new">Create routing list</a></li>
9
            <li><a href="/cgi-bin/koha/serials/routing.pl?subscriptionid=[% subscriptionid %]&amp;op=new">Create routing list</a></li>
9
        [% END %]
10
        [% END %]
10
    [% END %]
11
    [% END %]
12
  [% END %]
11
</ul>
13
</ul>
12
[% END %]
14
[% END %]
13
15
(-)a/koha-tmpl/intranet-tmpl/prog/en/includes/serials-toolbar.inc (-26 / +51 lines)
Lines 1-6 Link Here
1
<div id="toolbar"><script type="text/javascript">
1
<div id="toolbar"><script type="text/javascript">
2
	//<![CDATA[
2
	//<![CDATA[
3
3
4
    function confirm_close() {
5
        var is_confirmed = confirm(_("Are you sure you want to close this subscription?"));
6
        if (is_confirmed) {
7
            window.location="subscription-detail.pl?subscriptionid=[% subscriptionid %]&op=close";
8
        }
9
    }
10
    function confirm_reopen() {
11
        var is_confirmed = confirm(_("Are you sure you want to reopen this subscription?"));
12
        if (is_confirmed) {
13
            window.location="subscription-detail.pl?subscriptionid=[% subscriptionid %]&op=reopen";
14
        }
15
    }
4
	// prepare DOM for YUI Toolbar
16
	// prepare DOM for YUI Toolbar
5
17
6
	 $(document).ready(function() {
18
	 $(document).ready(function() {
Lines 50-55 onclick: {fn:function(){popup([% subscriptionid %])}} Link Here
50
		[% END %]
62
		[% END %]
51
	    new YAHOO.widget.Button("renew");
63
	    new YAHOO.widget.Button("renew");
52
	    new YAHOO.widget.Button("receive");
64
	    new YAHOO.widget.Button("receive");
65
        new YAHOO.widget.Button("close");
66
        new YAHOO.widget.Button("reopen");
53
		[% END %]
67
		[% END %]
54
	}
68
	}
55
69
Lines 57-94 onclick: {fn:function(){popup([% subscriptionid %])}} Link Here
57
	</script>
71
	</script>
58
<ul class="toolbar">
72
<ul class="toolbar">
59
    [% IF ( CAN_user_serials_create_subscription ) %]
73
    [% IF ( CAN_user_serials_create_subscription ) %]
60
	[% IF ( biblionumber_for_new_subscription ) %]
74
        [% IF ( biblionumber_for_new_subscription ) %]
61
        <li><a id="newsubscription" href="/cgi-bin/koha/serials/subscription-add.pl?biblionumber_for_new_subscription=[% biblionumber_for_new_subscription %]">New subscription</a></li>
75
            <li><a id="newsubscription" href="/cgi-bin/koha/serials/subscription-add.pl?biblionumber_for_new_subscription=[% biblionumber_for_new_subscription %]">New subscription</a></li>
62
	[% ELSE %]
76
        [% ELSE %]
63
        <li><a id="newsubscription" href="/cgi-bin/koha/serials/subscription-add.pl">New subscription</a></li>
77
            <li><a id="newsubscription" href="/cgi-bin/koha/serials/subscription-add.pl">New subscription</a></li>
64
	[% END %]
78
        [% END %]
65
    [% END %]
79
    [% END %]
66
80
67
    [% IF ( CAN_user_serials_edit_subscription || CAN_user_serials_create_subscription || CAN_user_serials_delete_subscription ) %]
81
    [% IF ( CAN_user_serials_edit_subscription || CAN_user_serials_create_subscription || CAN_user_serials_delete_subscription ) %]
68
	[% IF ( subscriptionid ) %]
82
        [% IF ( subscriptionid ) %]
69
83
70
	    [% IF ( CAN_user_serials_edit_subscription || CAN_user_serials_create_subscription || CAN_user_serials_delete_subscription ) %]
84
            [% IF ( CAN_user_serials_edit_subscription || CAN_user_serials_create_subscription || CAN_user_serials_delete_subscription ) %]
71
		[% UNLESS ( cannotedit ) %]
85
                [% UNLESS ( cannotedit ) %]
72
		    <li id="editmenuc"><a id="edit" href="/cgi-bin/koha/serials/subscription-add.pl?op=modify&amp;subscriptionid=[% subscriptionid %]">Edit</a></li>
86
                    <li id="editmenuc"><a id="edit" href="/cgi-bin/koha/serials/subscription-add.pl?op=modify&amp;subscriptionid=[% subscriptionid %]">Edit</a></li>
73
		[% END %]
87
                [% END %]
74
	    [% END %]
88
            [% END %]
75
89
76
	    [% IF ( CAN_user_serials_create_subscription ) %]
90
            [% IF ( CAN_user_serials_create_subscription ) %]
77
		<li><a id="duplicate" href="/cgi-bin/koha/serials/subscription-add.pl?op=dup&amp;subscriptionid=[% subscriptionid %]">Duplicate </a></li>
91
                <li><a id="duplicate" href="/cgi-bin/koha/serials/subscription-add.pl?op=dup&amp;subscriptionid=[% subscriptionid %]">Duplicate </a></li>
78
	    [% END %]
92
            [% END %]
79
93
80
	    [% UNLESS ( cannotedit ) %]
94
            [% UNLESS ( cannotedit ) %]
81
		[% IF ( CAN_user_serials_renew_subscription ) %]
95
                [% UNLESS closed %]
82
		    <li id="renewc"><a id="renew" href="#" onclick="popup([% subscriptionid %])">Renew </a></li>
96
                    [% IF ( CAN_user_serials_renew_subscription ) %]
83
		[% END %]
97
                        <li id="renewc"><a id="renew" href="#" onclick="popup([% subscriptionid %])">Renew </a></li>
84
		[% IF ( CAN_user_serials_receive_serials ) %]
98
                    [% END %]
85
		    <li><a id="receive" href="/cgi-bin/koha/serials/serials-edit.pl?subscriptionid=[% subscriptionid %]&amp;serstatus=1,3">Receive</a></li>
99
                [% END %]
86
		[% END %]
100
                [% IF ( CAN_user_serials_receive_serials ) %]
87
		[% IF ( CAN_user_serials_delete_subscription ) %]
101
                    [% UNLESS closed %]
88
		    <li><a id="delete" href="javascript:confirm_deletion()">Delete</a></li>
102
                        <li><a id="receive" href="/cgi-bin/koha/serials/serials-edit.pl?subscriptionid=[% subscriptionid %]&amp;serstatus=1,3">Receive</a></li>
89
		[% END %]
103
                    [% END %]
90
	    [% END %]
104
                [% END %]
91
	[% END %]
105
                [% IF CAN_user_serials_edit_subscription %]
106
                    [% IF closed %]
107
                        <li><a id="reopen" href="javascript:confirm_reopen();">Reopen</a></li>
108
                    [% ELSE %]
109
                        <li><a id="close" href="javascript:confirm_close();">Close</a></li>
110
                    [% END %]
111
                [% END %]
112
                [% IF ( CAN_user_serials_delete_subscription ) %]
113
                    <li><a id="delete" href="javascript:confirm_deletion()">Delete</a></li>
114
                [% END %]
115
            [% END %]
116
        [% END %]
92
    [% END %]
117
    [% END %]
93
</ul>
118
</ul>
94
</div>
119
</div>
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/catalogue/detail.tt (-14 / +10 lines)
Lines 484-503 function verify_images() { Link Here
484
                <tr>
484
                <tr>
485
                    <td>[% latestserial.serialseq %]</td>
485
                    <td>[% latestserial.serialseq %]</td>
486
                    <td>[% latestserial.planneddate %]</td>
486
                    <td>[% latestserial.planneddate %]</td>
487
                    <td>[% IF ( latestserial.status1 ) %]Expected
487
                    <td>
488
                        [% ELSE %]
488
                      [% IF ( latestserial.status1 ) %]Expected[% END %]
489
                            [% IF ( latestserial.status2 ) %]Arrived
489
                      [% IF ( latestserial.status2 ) %]Arrived[% END %]
490
                            [% ELSE %]
490
                      [% IF ( latestserial.status3 ) %]Late[% END %]
491
                                [% IF ( latestserial.status3 ) %]Late
491
                      [% IF ( latestserial.status4 ) %]Missing[% END %]
492
                                [% ELSE %]
492
                      [% IF ( latestserial.status5 ) %]Not issued[% END %]
493
                                    [% IF ( latestserial.status4 ) %]Missing
493
                      [% IF ( latestserial.status6 ) %]Delete[% END %]
494
                                    [% ELSE %]
494
                      [% IF ( latestserial.status7 ) %]Claimed[% END %]
495
                                        [% IF ( latestserial.status5 ) %]Not issued
495
                      [% IF ( latestserial.status8 ) %]Stopped[% END %]
496
                                        [% END %]
496
                    </td>
497
                                    [% END %]
498
                                [% END %]
499
                            [% END %]
500
                        [% END %]</td>
501
                    <td>[% latestserial.notes %]</td>
497
                    <td>[% latestserial.notes %]</td>
502
                </tr>
498
                </tr>
503
            [% END %]
499
            [% END %]
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/serials/claims.tt (+2 lines)
Lines 208-213 Link Here
208
		<option>Late</option>
208
		<option>Late</option>
209
		<option>Missing</option>
209
		<option>Missing</option>
210
		<option>Claimed</option>
210
		<option>Claimed</option>
211
        <option>Stopped</option>
211
	    </select>
212
	    </select>
212
	</li>
213
	</li>
213
	
214
	
Lines 284-289 Link Here
284
                            [% IF ( missingissue.status3 ) %]Late[% END %]
285
                            [% IF ( missingissue.status3 ) %]Late[% END %]
285
                            [% IF ( missingissue.status4 ) %]Missing[% END %]
286
                            [% IF ( missingissue.status4 ) %]Missing[% END %]
286
                            [% IF ( missingissue.status7 ) %]Claimed[% END %]
287
                            [% IF ( missingissue.status7 ) %]Claimed[% END %]
288
                            [% IF ( missingissue.status8 ) %]Stopped[% END %]
287
                        </td>
289
                        </td>
288
                        <td class="planneddate">
290
                        <td class="planneddate">
289
                        [% missingissue.planneddate %]
291
                        [% missingissue.planneddate %]
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/serials/serial-issues-full.tt (-6 / +8 lines)
Lines 68-79 function active(numlayer) Link Here
68
					[% serial.serialseq %]
68
					[% serial.serialseq %]
69
				</td>
69
				</td>
70
				<td>
70
				<td>
71
					[% IF ( serial.status1 ) %]Arrived[% END %]
71
                    [% IF ( serial.status1 ) %]Expected[% END %]
72
					[% IF ( serial.status2 ) %]Expected[% END %]
72
                    [% IF ( serial.status2 ) %]Arrived[% END %]
73
					[% IF ( serial.status3 ) %]Late[% END %]
73
                    [% IF ( serial.status3 ) %]Late[% END %]
74
					[% IF ( serial.status4 ) %]Missing[% END %]
74
                    [% IF ( serial.status4 ) %]Missing[% END %]
75
                    [% IF ( serial.status5 ) %]Not available[% END %]
75
                    [% IF ( serial.status5 ) %]Not issued[% END %]
76
					[% IF ( serial.status7 ) %]Claimed[% END %]
76
                    [% IF ( serial.status6 ) %]Delete[% END %]
77
                    [% IF ( serial.status7 ) %]Claimed[% END %]
78
                    [% IF ( serial.status8 ) %]Stopped[% END %]
77
				</td>
79
				</td>
78
			</tr>
80
			</tr>
79
			[% END %]
81
			[% END %]
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/serials/serials-collection.tt (-11 / +31 lines)
Lines 146-167 $(document).ready(function() { Link Here
146
                [% END %]</td>
146
                [% END %]</td>
147
            <td> [% subscription.branchcode %]</td>
147
            <td> [% subscription.branchcode %]</td>
148
            <td> [% subscription.callnumber %]</td>
148
            <td> [% subscription.callnumber %]</td>
149
        <td> [% subscription.notes %]        [% IF ( subscription.subscriptionexpired ) %]<br /><span class="problem"> Subscription expired</span>
149
        <td> [% subscription.notes %]
150
        [% END %]
150
            [% UNLESS subscription.closed %]
151
                [% IF ( subscription.subscriptionexpired ) %]
152
                    <br /><span class="problem"> Subscription expired</span>
153
                [% END %]
154
            [% ELSE %]
155
                <br /> Subscription closed
156
            [% END %]
151
        </td>
157
        </td>
152
        [% IF ( routing && CAN_user_serials_routing ) %]
158
        [% IF ( routing && CAN_user_serials_routing ) %]
153
        <td>
159
        <td>
154
            <a href="/cgi-bin/koha/serials/routing.pl?subscriptionid=[% subscription.subscriptionid %]">Edit routing list</a>
160
            [% UNLESS subscription.closed %]
161
                <a href="/cgi-bin/koha/serials/routing.pl?subscriptionid=[% subscription.subscriptionid %]">Edit routing list</a>
162
            [% END %]
155
        </td>
163
        </td>
156
        [% END %]
164
        [% END %]
157
        [% IF ( subscription.abouttoexpire ) %]<td class="problem"> <a href="/cgi-bin/koha/serials/subscription-renew.pl?subscriptionid=[% subscription.subscriptionid %]" onclick="popup([% subscription.subscriptionid %]); return false;">Renew</a></td>
165
        [% UNLESS subscription.closed %]
158
        [% ELSE %]
166
            [% IF ( subscription.abouttoexpire ) %]<td class="problem"> <a href="/cgi-bin/koha/serials/subscription-renew.pl?subscriptionid=[% subscription.subscriptionid %]" onclick="popup([% subscription.subscriptionid %]); return false;">Renew</a></td>
159
        [% IF ( subscription.subscriptionexpired ) %]<td class="problem"> <a href="/cgi-bin/koha/serials/subscription-renew.pl?subscriptionid=[% subscription.subscriptionid %]" onclick="popup([% subscription.subscriptionid %]); return false;">Renew</a></td>
167
            [% ELSE %]
168
                [% IF ( subscription.subscriptionexpired ) %]<td class="problem"> <a href="/cgi-bin/koha/serials/subscription-renew.pl?subscriptionid=[% subscription.subscriptionid %]" onclick="popup([% subscription.subscriptionid %]); return false;">Renew</a></td>
169
                [% ELSE %]
170
                    <td> &nbsp;</td>
171
                [% END %]
172
            [% END %]
160
        [% ELSE %]
173
        [% ELSE %]
161
        <td> &nbsp;</td>
174
            <td> &nbsp;</td>
162
        [% END %]
163
        [% END %]
175
        [% END %]
164
165
      </tr>
176
      </tr>
166
[% END %]
177
[% END %]
167
[% IF ( subscr ) %]
178
[% IF ( subscr ) %]
Lines 189-195 $(document).ready(function() { Link Here
189
    [% IF ( CAN_user_serials_receive_serials ) %]
200
    [% IF ( CAN_user_serials_receive_serials ) %]
190
        <p>
201
        <p>
191
            <input type="submit" value="Edit serials" />&nbsp;
202
            <input type="submit" value="Edit serials" />&nbsp;
192
            <input type="button" value="Generate Next" onclick="javascript:generateNext([% subscriptionidlist %])" />
203
            [% UNLESS subscription.closed %]
204
                <input type="button" value="Generate Next" onclick="javascript:generateNext([% subscriptionidlist %])" />
205
            [% END %]
193
        </p>
206
        </p>
194
    [% END %]
207
    [% END %]
195
208
Lines 228-234 $(document).ready(function() { Link Here
228
                    [% serial.serialseq %]
241
                    [% serial.serialseq %]
229
                </td>
242
                </td>
230
                <td>
243
                <td>
231
                    [% IF ( serial.status1 ) %]Expected[% END %][% IF ( serial.status2 ) %]Arrived[% END %][% IF ( serial.status3 ) %]Late[% END %][% IF ( serial.status4 ) %]Missing[% END %][% IF ( serial.status5 ) %]Not Available[% END %][% IF ( serial.status7 ) %]Claimed[% END %]
244
                    [% IF ( latestserial.status1 ) %]Expected[% END %]
245
                    [% IF ( latestserial.status2 ) %]Arrived[% END %]
246
                    [% IF ( latestserial.status3 ) %]Late[% END %]
247
                    [% IF ( latestserial.status4 ) %]Missing[% END %]
248
                    [% IF ( latestserial.status5 ) %]Not issued[% END %]
249
                    [% IF ( latestserial.status6 ) %]Delete[% END %]
250
                    [% IF ( latestserial.status7 ) %]Claimed[% END %]
251
                    [% IF ( latestserial.status8 ) %]Stopped[% END %]
232
                </td>
252
                </td>
233
                <td>
253
                <td>
234
                    [% serial.notes %]
254
                    [% serial.notes %]
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/serials/serials-edit.tt (-53 / +61 lines)
Lines 233-271 $(document).ready(function() { Link Here
233
              <select name="status" size="1" id="status[% serialslis.serialid %]" onchange="if (this.value==2 || this.value==7){changeDate(this, '[% serialslis.arriveddate %]')} else {changeDate(this, '[% serialslis.planneddate %]')}" >
233
              <select name="status" size="1" id="status[% serialslis.serialid %]" onchange="if (this.value==2 || this.value==7){changeDate(this, '[% serialslis.arriveddate %]')} else {changeDate(this, '[% serialslis.planneddate %]')}" >
234
               [% END %] 
234
               [% END %] 
235
            [% END %]
235
            [% END %]
236
  [% IF ( serialslis.status1 ) %]
236
            [% IF ( serialslis.status1 ) %]
237
                    <option value="1" selected="selected">Expected</option>
237
              <option value="1" selected="selected">Expected</option>
238
  [% END %]
238
            [% END %]
239
  [% IF ( serialslis.status2 ) %]
239
            [% IF ( serialslis.status2 ) %]
240
                    <option value="2" selected="selected">Arrived</option>
240
              <option value="2" selected="selected">Arrived</option>
241
  [% ELSE %]
241
            [% ELSE %]
242
                    <option value="2">Arrived</option>
242
              <option value="2">Arrived</option>
243
  [% END %]
243
            [% END %]
244
  [% IF ( serialslis.status3 ) %]
244
            [% IF ( serialslis.status3 ) %]
245
                    <option value="3" selected="selected">Late</option>
245
              <option value="3" selected="selected">Late</option>
246
  [% ELSE %]
246
            [% ELSE %]
247
                    <option value="3">Late</option>
247
              <option value="3">Late</option>
248
  [% END %]
248
            [% END %]
249
  [% IF ( serialslis.status4 ) %]
249
            [% IF ( serialslis.status4 ) %]
250
                    <option value="4" selected="selected">Missing</option>
250
              <option value="4" selected="selected">Missing</option>
251
  [% ELSE %]
251
            [% ELSE %]
252
                    <option value="4">Missing</option>
252
              <option value="4">Missing</option>
253
  [% END %]
253
            [% END %]
254
  [% IF ( serialslis.status7 ) %]
254
            [% IF ( serialslis.status7 ) %]
255
                    <option value="7" selected="selected">Claimed</option>
255
              <option value="7" selected="selected">Claimed</option>
256
  [% ELSE %]
256
            [% ELSE %]
257
                    <option value="7">Claimed</option>
257
              <option value="7">Claimed</option>
258
  [% END %]
258
            [% END %]
259
  [% IF ( serialslis.status5 ) %]
259
            [% IF ( serialslis.status5 ) %]
260
                    <option value="5" selected="selected">Not available</option>
260
              <option value="5" selected="selected">Not available</option>
261
  [% ELSE %]
261
            [% ELSE %]
262
                    <option value="5">Not available</option>
262
              <option value="5">Not available</option>
263
  [% END %]
263
            [% END %]
264
  [% IF ( serialslis.status6 ) %]
264
            [% IF ( serialslis.status6 ) %]
265
                    <option value="6" selected="selected">Delete</option>
265
              <option value="6" selected="selected">Delete</option>
266
  [% ELSE %]
266
            [% ELSE %]
267
                    <option value="6">Delete</option>
267
              <option value="6">Delete</option>
268
  [% END %]
268
            [% END %]
269
            [% IF serialslis.status8 %]
270
              <option value="8" selected="selected">Stopped</option>
271
            [% END %]
269
            </select>
272
            </select>
270
273
271
        </td>
274
        </td>
Lines 338-376 $(document).ready(function() { Link Here
338
            <select name="status" size="1" id="addstatus[% newserialloo.serialid %]" onchange="if (this.value==2){unHideItems('items'+'[% newserialloo.subscriptionid %][% newserialloo.serialid %]','label[% newserialloo.subscriptionid %][% newserialloo.serialid %]','[% newserialloo.serialid %]'); changeDate2('[% newserialloo.arriveddate %]')} else if (this.value==7){changeDate('[% newserialloo.arriveddate %]')} else { HideItems('items'+'[% newserialloo.subscriptionid %]'+[% newserialloo.serialid %],'label[% serialslis.subscriptionid %][% serialslis.serialid %]'); changeDate2('[% serialslis.planneddate %]')}" >
341
            <select name="status" size="1" id="addstatus[% newserialloo.serialid %]" onchange="if (this.value==2){unHideItems('items'+'[% newserialloo.subscriptionid %][% newserialloo.serialid %]','label[% newserialloo.subscriptionid %][% newserialloo.serialid %]','[% newserialloo.serialid %]'); changeDate2('[% newserialloo.arriveddate %]')} else if (this.value==7){changeDate('[% newserialloo.arriveddate %]')} else { HideItems('items'+'[% newserialloo.subscriptionid %]'+[% newserialloo.serialid %],'label[% serialslis.subscriptionid %][% serialslis.serialid %]'); changeDate2('[% serialslis.planneddate %]')}" >
339
342
340
                    <option value="">----</option>
343
                    <option value="">----</option>
341
  [% IF ( newserialloo.status1 ) %]
344
                  [% IF ( newserialloo.status1 ) %]
342
                    <option value="1" selected="selected">Expected</option>
345
                    <option value="1" selected="selected">Expected</option>
343
  [% END %]
346
                  [% END %]
344
  [% IF ( newserialloo.status2 ) %]
347
                  [% IF ( newserialloo.status2 ) %]
345
                    <option value="2" selected="selected">Arrived</option>
348
                    <option value="2" selected="selected">Arrived</option>
346
  [% ELSE %]
349
                  [% ELSE %]
347
                    <option value="2">Arrived</option>
350
                    <option value="2">Arrived</option>
348
  [% END %]
351
                  [% END %]
349
  [% IF ( newserialloo.status3 ) %]
352
                  [% IF ( newserialloo.status3 ) %]
350
                    <option value="3" selected="selected">Late</option>
353
                    <option value="3" selected="selected">Late</option>
351
  [% ELSE %]
354
                  [% ELSE %]
352
                    <option value="3">Late</option>
355
                    <option value="3">Late</option>
353
  [% END %]
356
                  [% END %]
354
  [% IF ( newserialloo.status4 ) %]
357
                  [% IF ( newserialloo.status4 ) %]
355
                    <option value="4" selected="selected">Missing</option>
358
                    <option value="4" selected="selected">Missing</option>
356
  [% ELSE %]
359
                  [% ELSE %]
357
                    <option value="4">Missing</option>
360
                    <option value="4">Missing</option>
358
  [% END %]
361
                  [% END %]
359
  [% IF ( newserialloo.status7 ) %]
362
                  [% IF ( newserialloo.status7 ) %]
360
                    <option value="7" selected="selected">Claimed</option>
363
                    <option value="7" selected="selected">Claimed</option>
361
  [% ELSE %]
364
                  [% ELSE %]
362
                    <option value="7">Claimed</option>
365
                    <option value="7">Claimed</option>
363
  [% END %]
366
                  [% END %]
364
  [% IF ( newserialloo.status5 ) %]
367
                  [% IF ( newserialloo.status5 ) %]
365
                    <option value="5" selected="selected">Not available</option>
368
                    <option value="5" selected="selected">Not available</option>
366
  [% ELSE %]
369
                  [% ELSE %]
367
                    <option value="5">Not available</option>
370
                    <option value="5">Not available</option>
368
  [% END %]
371
                  [% END %]
369
  [% IF ( newserialloo.status6 ) %]
372
                  [% IF ( newserialloo.status6 ) %]
370
                    <option value="6" selected="selected">Delete</option>
373
                    <option value="6" selected="selected">Delete</option>
371
  [% ELSE %]
374
                  [% ELSE %]
372
                    <option value="6">Delete</option>
375
                    <option value="6">Delete</option>
373
  [% END %]
376
                  [% END %]
377
                  [% IF newserialloo.status8 %]
378
                    <option value="8" selected="selected">Stopped</option>
379
                  [% END %]
374
            </select>
380
            </select>
375
381
376
        </td>
382
        </td>
Lines 435-441 $(document).ready(function() { Link Here
435
        <li><a href="serials-collection.pl?subscriptionid=[% subscription.subscriptionid %]" title="serial collection for [% subscription.bibliotitle %]">Serial collection #[% subscription.subscriptionid %]</a></li>
441
        <li><a href="serials-collection.pl?subscriptionid=[% subscription.subscriptionid %]" title="serial collection for [% subscription.bibliotitle %]">Serial collection #[% subscription.subscriptionid %]</a></li>
436
        <li><a href="subscription-detail.pl?subscriptionid=[% subscription.subscriptionid %]" title="detail of the subscription">Subscription #[% subscription.subscriptionid %]</a></li>
442
        <li><a href="subscription-detail.pl?subscriptionid=[% subscription.subscriptionid %]" title="detail of the subscription">Subscription #[% subscription.subscriptionid %]</a></li>
437
        [% IF ( subscription.abouttoexpire ) %]
443
        [% IF ( subscription.abouttoexpire ) %]
444
          [% UNLESS subscription.closed %]
438
            <li><a href="#" onclick="javascript:popup([% subscription.subscriptionid %])">Renew #[% subscription.subscriptionid %]</a></li>
445
            <li><a href="#" onclick="javascript:popup([% subscription.subscriptionid %])">Renew #[% subscription.subscriptionid %]</a></li>
446
          [% END %]
439
        [% END %]
447
        [% END %]
440
    [% END %]
448
    [% END %]
441
    <li><a href="/cgi-bin/koha/catalogue/[% default_bib_view %].pl?biblionumber=[% biblionumber %]" title="go to [% bibliotitle %]">Show biblio</a></li></ul>
449
    <li><a href="/cgi-bin/koha/catalogue/[% default_bib_view %].pl?biblionumber=[% biblionumber %]" title="go to [% bibliotitle %]">Show biblio</a></li></ul>
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/serials/serials-recieve.tt (+3 lines)
Lines 137-142 function barcode_check(){ Link Here
137
					[% ELSE %]
137
					[% ELSE %]
138
						<option value="6">Delete</option>
138
						<option value="6">Delete</option>
139
					[% END %]
139
					[% END %]
140
                    [% IF serialslis.status8 %]
141
                        <option value="8" selected="selected">Stopped</option>
142
                    [% END %]
140
				</select>
143
				</select>
141
			[% IF ( serialslis.serialadditems ) %]
144
			[% IF ( serialslis.serialadditems ) %]
142
				<br /><br />
145
				<br /><br />
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/serials/serials-search.tt (-82 / +167 lines)
Lines 9-22 Link Here
9
<script type="text/javascript">
9
<script type="text/javascript">
10
//<![CDATA[
10
//<![CDATA[
11
 $(document).ready(function() {
11
 $(document).ready(function() {
12
    var srlt = $("#srlt").dataTable($.extend(true, {}, dataTablesDefaults, {
12
    var osrlt = $("#osrlt").dataTable($.extend(true, {}, dataTablesDefaults, {
13
        "aoColumnDefs": [
13
        "aoColumnDefs": [
14
            { "aTargets": [ -1, -2, -3 ], "bSortable": false, "bSearchable": false },
14
            { "aTargets": [ -1, -2, -3 ], "bSortable": false, "bSearchable": false },
15
        ],
15
        ],
16
        "sPaginationType": "four_button"
16
        "sPaginationType": "four_button"
17
    } ) );
17
    } ) );
18
18
19
    srlt.fnAddFilters("filter", 750);
19
    var csrlt = $("#csrlt").dataTable($.extend(true, {}, dataTablesDefaults, {
20
        "aoColumnDefs": [
21
            { "aTargets": [ -1, -2 ], "bSortable": false, "bSearchable": false },
22
        ],
23
        "sPaginationType": "four_button"
24
    } ) );
25
26
    osrlt.fnAddFilters("filter", 750);
27
    csrlt.fnAddFilters("filter", 750);
28
29
    $('#serialstabs').tabs();
30
20
 });
31
 });
21
 //]]>
32
 //]]>
22
</script>
33
</script>
Lines 33-41 Link Here
33
      <div class="yui-b">
44
      <div class="yui-b">
34
      [% INCLUDE 'serials-toolbar.inc' %]
45
      [% INCLUDE 'serials-toolbar.inc' %]
35
46
36
      <h2>Serials subscriptions</h2>
47
      <h2>Serials subscriptions ([% total %] found)</h2>
37
48
38
      <div id="advsearch">
49
      <div id="advsearch" style="padding-bottom:3em;">
39
        <form action="/cgi-bin/koha/serials/serials-search.pl" method="get">
50
        <form action="/cgi-bin/koha/serials/serials-search.pl" method="get">
40
          <fieldset class="rows">
51
          <fieldset class="rows">
41
          <legend onclick="$('#advsearch_form').slideToggle(400);">
52
          <legend onclick="$('#advsearch_form').slideToggle(400);">
Lines 93-178 Link Here
93
      </div>
104
      </div>
94
105
95
      [% IF ( done_searched ) %]
106
      [% IF ( done_searched ) %]
96
        [% IF ( subscriptions ) %]
107
        [% IF ( total ) %]
97
          <table id="srlt">
108
          <div id="serialstabs" class="toptabs" style="clear:both;">
98
            <thead>
109
            <ul class="ui-tabs-nav">
99
              <tr>
110
              <li><a href="#opened">Opened ([% openedsubscriptions.size || 0 %])</a></li>
100
                  <th>ISSN</th>
111
              <li><a href="#closed">Closed ([% closedsubscriptions.size || 0 %])</a></li>
101
                  <th>Title</th>
112
            </ul>
102
                  <th> Notes </th>
113
            <div id="opened">
103
                  <th>Library</th>
114
              [% IF openedsubscriptions %]
104
                  <th>Call number</th>
115
                <table id="osrlt">
105
                  <th>Expiration date</th>
116
                  <thead>
106
                  [% IF ( routing && CAN_user_serials_routing ) %]
117
                    <tr>
107
                    <th>Routing list</th>
118
                        <th>ISSN</th>
108
                  [% END %]
119
                        <th>Title</th>
109
                  <th>&nbsp;</th>
120
                        <th> Notes </th>
110
                  <th>&nbsp;</th>
121
                        <th>Library</th>
111
              </tr>
122
                        <th>Call number</th>
112
            </thead>
123
                        <th>Expiration date</th>
113
            <tfoot>
124
                        [% IF ( routing && CAN_user_serials_routing ) %]
114
              <tr>
125
                          <th>Routing list</th>
115
                <td><input type="text" class="filter" data-column_num="0" placeholder="Search ISSN" /></td>
126
                        [% END %]
116
                <td><input type="text" class="filter" data-column_num="1" placeholder="Search title" /></td>
127
                        <th>&nbsp;</th>
117
                <td><input type="text" class="filter" data-column_num="2" placeholder="Search notes" /></td>
128
                        <th>&nbsp;</th>
118
                <td><input type="text" class="filter" data-column_num="3" placeholder="Search library" /></td>
129
                    </tr>
119
                <td><input type="text" class="filter" data-column_num="4" placeholder="Search callnumber" /></td>
130
                  </thead>
120
                <td><input type="text" class="filter" data-column_num="5" placeholder="Search expiration date" /></td>
131
                  <tfoot>
121
                [% IF ( routing && CAN_user_serials_routing ) %]<td></td>[% END %]
132
                    <tr>
122
                <td></td>
133
                      <td><input type="text" class="filter" data-column_num="0" placeholder="Search ISSN" /></td>
123
                <td></td>
134
                      <td><input type="text" class="filter" data-column_num="1" placeholder="Search title" /></td>
124
              </tr>
135
                      <td><input type="text" class="filter" data-column_num="2" placeholder="Search notes" /></td>
125
            </tfoot>
136
                      <td><input type="text" class="filter" data-column_num="3" placeholder="Search library" /></td>
126
            <tbody>
137
                      <td><input type="text" class="filter" data-column_num="4" placeholder="Search callnumber" /></td>
127
              [% FOREACH subscription IN subscriptions %]
138
                      <td><input type="text" class="filter" data-column_num="5" placeholder="Search expiration date" /></td>
128
                <tr>
139
                      [% IF ( routing && CAN_user_serials_routing ) %]<td></td>[% END %]
129
                  <td>
140
                      <td></td>
130
                  [% IF ( subscription.issn ) %][% subscription.issn %]
141
                      <td></td>
131
                  [% END %]
142
                    </tr>
132
                  </td>
143
                  </tfoot>
133
                  <td><a href="/cgi-bin/koha/serials/subscription-detail.pl?subscriptionid=[% subscription.subscriptionid %]" class="button" title="subscription detail">[% subscription.title |html %]</a>
144
                  <tbody>
134
                  </td>
145
                    [% FOREACH subscription IN openedsubscriptions %]
135
                  <td>[% IF ( subscription.notes ) %][% subscription.notes %][% END %]
146
                      <tr>
136
                  [% IF ( subscription.internalnotes ) %]([% subscription.internalnotes %])[% END %]
147
                        <td>
137
                  </td>
148
                        [% IF ( subscription.issn ) %][% subscription.issn %]
138
                  <td>
149
                        [% END %]
139
                    [% IF ( subscription.branchname ) %][% subscription.branchname %][% END %]
150
                        </td>
140
                  </td>
151
                        <td><a href="/cgi-bin/koha/serials/subscription-detail.pl?subscriptionid=[% subscription.subscriptionid %]" class="button" title="subscription detail">[% subscription.title |html %]</a>
141
                  <td>
152
                        </td>
142
                    [% IF ( subscription.callnumber ) %][% subscription.callnumber %][% END %]
153
                        <td>[% IF ( subscription.notes ) %][% subscription.notes %][% END %]
143
                  </td>
154
                        [% IF ( subscription.internalnotes ) %]([% subscription.internalnotes %])[% END %]
144
                  <td>
155
                        </td>
145
                    [% IF ( subscription.enddate ) %][% subscription.enddate | $KohaDates %][% END %]
156
                        <td>
146
                  </td>
157
                          [% IF ( subscription.branchname ) %][% subscription.branchname %][% END %]
147
                  [% IF ( routing && CAN_user_serials_routing ) %]
158
                        </td>
148
                  <td>
159
                        <td>
149
                    [% IF ( subscription.cannotedit ) %]
160
                          [% IF ( subscription.callnumber ) %][% subscription.callnumber %][% END %]
150
                      &nbsp;
161
                        </td>
151
                    [% ELSE %]
162
                        <td>
152
                      [% IF ( subscription.routingedit ) %]
163
                          [% IF ( subscription.enddate ) %][% subscription.enddate | $KohaDates %][% END %]
153
                        <a href="/cgi-bin/koha/serials/routing.pl?subscriptionid=[% subscription.subscriptionid %]">Edit</a>
164
                        </td>
154
                        ([% subscription.routingedit %])
165
                        [% IF ( routing && CAN_user_serials_routing ) %]
155
                      [% ELSE %]
166
                        <td>
156
                        <a href="/cgi-bin/koha/serials/routing.pl?subscriptionid=[% subscription.subscriptionid %]&amp;op=new">New</a>
167
                          [% IF ( subscription.cannotedit ) %]
157
                      [% END %]
168
                            &nbsp;
169
                          [% ELSE %]
170
                            [% IF ( subscription.routingedit ) %]
171
                              <a href="/cgi-bin/koha/serials/routing.pl?subscriptionid=[% subscription.subscriptionid %]">Edit</a>
172
                              ([% subscription.routingedit %])
173
                            [% ELSE %]
174
                              <a href="/cgi-bin/koha/serials/routing.pl?subscriptionid=[% subscription.subscriptionid %]&amp;op=new">New</a>
175
                            [% END %]
176
                          [% END %]
177
                        </td>
178
                        [% END %]
179
                        <td><a href="/cgi-bin/koha/serials/serials-collection.pl?subscriptionid=[% subscription.subscriptionid %]">Issue history</a>
180
                        </td>
181
                        <td>
182
                        [% IF ( subscription.cannotedit ) %]
183
                          &nbsp;
184
                        [% ELSE %]
185
                          [% IF ( CAN_user_serials_receive_serials ) %]<a href="/cgi-bin/koha/serials/serials-edit.pl?subscriptionid=[% subscription.subscriptionid %]&amp;serstatus=1,3,7">Serial receive</a>[% END %]
186
                        [% END %]
187
                        </td>
188
                      </tr>
189
                    [% END %]
190
                  </tbody>
191
                </table>
192
              [% ELSE %]
193
                There is no opened subscription for your search.
194
              [% END %]
195
            </div>
196
            <div id="closed">
197
              [% IF closedsubscriptions %]
198
                <table id="csrlt">
199
                  <thead>
200
                    <tr>
201
                        <th>ISSN</th>
202
                        <th>Title</th>
203
                        <th> Notes </th>
204
                        <th>Library</th>
205
                        <th>Call number</th>
206
                        <th>&nbsp;</th>
207
                        <th>&nbsp;</th>
208
                    </tr>
209
                  </thead>
210
                  <tfoot>
211
                    <tr>
212
                      <td><input type="text" class="filter" data-column_num="0" placeholder="Search ISSN" /></td>
213
                      <td><input type="text" class="filter" data-column_num="1" placeholder="Search title" /></td>
214
                      <td><input type="text" class="filter" data-column_num="2" placeholder="Search notes" /></td>
215
                      <td><input type="text" class="filter" data-column_num="3" placeholder="Search library" /></td>
216
                      <td><input type="text" class="filter" data-column_num="4" placeholder="Search callnumber" /></td>
217
                      <td></td>
218
                      <td></td>
219
                    </tr>
220
                  </tfoot>
221
                  <tbody>
222
                    [% FOREACH subscription IN closedsubscriptions %]
223
                      <tr>
224
                        <td>
225
                          [% IF ( subscription.issn ) %]
226
                            [% subscription.issn %]
227
                          [% END %]
228
                        </td>
229
                        <td>
230
                          <a href="/cgi-bin/koha/serials/subscription-detail.pl?subscriptionid=[% subscription.subscriptionid %]" class="button" title="subscription detail">[% subscription.title |html %]</a>
231
                        </td>
232
                        <td>
233
                          [% IF ( subscription.notes ) %][% subscription.notes %][% END %]
234
                          [% IF ( subscription.internalnotes ) %]([% subscription.internalnotes %])[% END %]
235
                        </td>
236
                        <td>
237
                          [% IF ( subscription.branchname ) %][% subscription.branchname %][% END %]
238
                        </td>
239
                        <td>
240
                          [% IF ( subscription.callnumber ) %][% subscription.callnumber %][% END %]
241
                        </td>
242
                        <td>
243
                          [% UNLESS subscription.cannotedit %]
244
                            <a href="/cgi-bin/koha/serials/serials-search.pl?subscriptionid=[% subscription.subscriptionid %]&amp;op=reopen&routing=[% subscription.routing %]&amp;searched=1&amp;title_filter=[% title_filter %]&amp;ISSN_filter=[% ISSN_filter %]&amp;EAN_filter=[% EAN_filter %]&amp;published_filter=[% publisher_filter %]&amp;bookseller_filter=[% bookseller_filter %]&amp;branch_filter=[% branch_filter %]" onclick="return confirm(_('Are you sure you want to reopen this subscription?'));">Reopen</a>
245
                          [% ELSE %]
246
                            Cannot edit
247
                          [% END %]
248
                        </td>
249
                        <td>
250
                          <a href="/cgi-bin/koha/serials/serials-collection.pl?subscriptionid=[% subscription.subscriptionid %]">Issue history</a>
251
                        </td>
252
                      </tr>
158
                    [% END %]
253
                    [% END %]
159
                  </td>
254
                  </tbody>
160
                  [% END %]
255
                </table>
161
                  <td><a href="/cgi-bin/koha/serials/serials-collection.pl?subscriptionid=[% subscription.subscriptionid %]">Issue history</a>
256
              [% ELSE %]
162
                  </td>
257
                There is no closed subscription for your search.
163
                  <td>
164
                  [% IF ( subscription.cannotedit ) %]
165
                    &nbsp;
166
                  [% ELSE %]
167
                    [% IF ( CAN_user_serials_receive_serials ) %]<a href="/cgi-bin/koha/serials/serials-edit.pl?subscriptionid=[% subscription.subscriptionid %]&amp;serstatus=1,3,7">Serial receive</a>[% END %]
168
                  [% END %]
169
                  </td>
170
                </tr>
171
              [% END %]
258
              [% END %]
172
            </tbody>
259
            </div>
173
          </table>
260
          </div>
174
        [% ELSE %]
175
          There is no subscription for your search.
176
        [% END %]
261
        [% END %]
177
      [% END %]
262
      [% END %]
178
    </div>
263
    </div>
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/serials/subscription-detail.tt (-23 / +19 lines)
Lines 55-62 $(document).ready(function() { Link Here
55
	<div class="yui-b">
55
	<div class="yui-b">
56
	[% INCLUDE 'serials-toolbar.inc' %]
56
	[% INCLUDE 'serials-toolbar.inc' %]
57
57
58
    <h1>Subscription for [% bibliotitle %] </h1>
58
    <h1>Subscription for [% bibliotitle%] [% IF closed %](closed)[% END %]</h1>
59
    [% IF ( abouttoexpire ) %]<div class="dialog message">Subscription will expire [% enddate %]. <a href="#" id="renewsub">Renew this subscription</a>.</div>[% END %]
59
    [% IF ( abouttoexpire ) %]
60
      [% UNLESS closed %]
61
        <div class="dialog message">Subscription will expire [% enddate %]. <a href="#" id="renewsub">Renew this subscription</a>.</div>
62
      [% END %]
63
    [% END %]
60
    [% IF ( NEEDSCONFIRMATION ) %]
64
    [% IF ( NEEDSCONFIRMATION ) %]
61
    <div id="circ_needsconfirmation" class="dialog alert">
65
    <div id="circ_needsconfirmation" class="dialog alert">
62
			<h3>Please Confirm Subscription deletion</h3>
66
			<h3>Please Confirm Subscription deletion</h3>
Lines 340-366 $(document).ready(function() { Link Here
340
                    [% serialslis.publisheddate %]
344
                    [% serialslis.publisheddate %]
341
                </td>
345
                </td>
342
                <td>
346
                <td>
343
                        [% IF ( serialslis.status1 ) %]
347
                    [% IF ( serialslis.status1 ) %]Expected[% END %]
344
                            Expected
348
                    [% IF ( serialslis.status2 ) %]Arrived[% END %]
345
                        [% END %]
349
                    [% IF ( serialslis.status3 ) %]Late[% END %]
346
                        [% IF ( serialslis.status2 ) %]
350
                    [% IF ( serialslis.status4 ) %]Missing[% END %]
347
                            Arrived
351
                    [% IF ( serialslis.status5 ) %]Not issued[% END %]
348
                        [% END %]
352
                    [% IF ( serialslis.status6 ) %]Delete[% END %]
349
                        [% IF ( serialslis.status3 ) %]
353
                    [% IF ( serialslis.status7 ) %]
350
                            Late
354
                      Claimed
351
                        [% END %]
355
                      [% IF ( serialslis.claimdate ) %]
352
                        [% IF ( serialslis.status4 ) %]
356
                        [% serialslis.claimdate %]
353
                            Missing
357
                      [% END %]
354
                        [% END %]
358
                    [% END %]
355
                        [% IF ( serialslis.status5 ) %]
359
                    [% IF ( serialslis.status8 ) %]Stopped[% END %]
356
                            Not available
357
                        [% END %]
358
                        [% IF ( serialslis.status7 ) %]
359
                            Claimed
360
                             [% IF ( serialslis.claimdate ) %]
361
                             [% serialslis.claimdate %]
362
                             [% END %]
363
                        [% END %]
364
                </td>
360
                </td>
365
            </tr>
361
            </tr>
366
        [% END %]
362
        [% END %]
(-)a/koha-tmpl/opac-tmpl/prog/en/modules/opac-full-serial-issues.tt (-6 / +9 lines)
Lines 200-211 function showlayer(numlayer){ Link Here
200
		    </td>
200
		    </td>
201
		    <td>    [% serial.serialseq %]
201
		    <td>    [% serial.serialseq %]
202
		    </td>
202
		    </td>
203
		    <td>    [% IF ( serial.status1 ) %]Waiting[% END %]
203
		    <td>
204
			[% IF ( serial.status2 ) %]Arrived[% END %]
204
              [% IF ( serial.status1 ) %]Expected[% END %]
205
			[% IF ( serial.status3 ) %]Late[% END %]
205
              [% IF ( serial.status2 ) %]Arrived[% END %]
206
			[% IF ( serial.status4 ) %]Missing[% END %]
206
              [% IF ( serial.status3 ) %]Late[% END %]
207
            [% IF ( serial.status5 ) %]Not available[% END %]
207
              [% IF ( serial.status4 ) %]Missing[% END %]
208
			[% IF ( serial.status7 ) %]Claimed[% END %]
208
              [% IF ( serial.status5 ) %]Not available[% END %]
209
              [% IF ( serial.status6 ) %]Delete[% END %]
210
              [% IF ( serial.status7 ) %]Claimed[% END %]
211
              [% IF ( serial.status8 ) %]Stopped[% END %]
209
		    </td>
212
		    </td>
210
		    <td class="subscriptionidfilterclass">    [% serial.subscriptionid %]
213
		    <td class="subscriptionidfilterclass">    [% serial.subscriptionid %]
211
		    </td>
214
		    </td>
(-)a/misc/cronjobs/serialsUpdate.pl (+1 lines)
Lines 60-65 my $sth = $dbh->prepare(" Link Here
60
     WHERE serial.status = 1 
60
     WHERE serial.status = 1 
61
       AND periodicity <> 32
61
       AND periodicity <> 32
62
       AND DATE_ADD(planneddate, INTERVAL CAST(graceperiod AS SIGNED) DAY) < NOW()
62
       AND DATE_ADD(planneddate, INTERVAL CAST(graceperiod AS SIGNED) DAY) < NOW()
63
       AND subscription.closed = 0
63
     ");
64
     ");
64
$sth->execute();
65
$sth->execute();
65
66
(-)a/reports/serials_stats.pl (-2 / +11 lines)
Lines 96-104 if($do_it){ Link Here
96
    while(my $row = $sth->fetchrow_hashref){
96
    while(my $row = $sth->fetchrow_hashref){
97
        $row->{'enddate'} = format_date(GetExpirationDate($row->{'subscriptionid'}));
97
        $row->{'enddate'} = format_date(GetExpirationDate($row->{'subscriptionid'}));
98
        $row->{'startdate'} = format_date($row->{'startdate'});
98
        $row->{'startdate'} = format_date($row->{'startdate'});
99
        push @datas, $row if ($expired || (not $expired && not HasSubscriptionExpired($row->{subscriptionid})) );
99
        push @datas, $row if (
100
            $expired
101
            or (
102
                not $expired
103
                and (
104
                    not HasSubscriptionExpired($row->{subscriptionid})
105
                    and not $row->{closed}
106
                )
107
            )
108
        );
100
    }
109
    }
101
    
110
102
    if($output eq 'screen'){
111
    if($output eq 'screen'){
103
        $template->param(datas => \@datas,
112
        $template->param(datas => \@datas,
104
                         do_it => 1);
113
                         do_it => 1);
(-)a/serials/checkexpiration.pl (+1 lines)
Lines 79-84 if ($date) { Link Here
79
79
80
        $subscription->{expirationdate} = $expirationdate;
80
        $subscription->{expirationdate} = $expirationdate;
81
        next if $expirationdate !~ /\d{4}-\d{2}-\d{2}/; # next if not in ISO format.
81
        next if $expirationdate !~ /\d{4}-\d{2}-\d{2}/; # next if not in ISO format.
82
        next if $subscription->{closed};
82
        if ( Date_to_Days(split "-",$expirationdate) < Date_to_Days(split "-",$date) &&
83
        if ( Date_to_Days(split "-",$expirationdate) < Date_to_Days(split "-",$date) &&
83
			 Date_to_Days(split "-",$expirationdate) > Date_to_Days(&Today) ) {
84
			 Date_to_Days(split "-",$expirationdate) > Date_to_Days(&Today) ) {
84
            $subscription->{expirationdate}=format_date($subscription->{expirationdate});
85
            $subscription->{expirationdate}=format_date($subscription->{expirationdate});
(-)a/serials/serials-collection.pl (+3 lines)
Lines 97-104 my $subscriptioncount; Link Here
97
my ($location, $callnumber);
97
my ($location, $callnumber);
98
if (@subscriptionid){
98
if (@subscriptionid){
99
   my @subscriptioninformation=();
99
   my @subscriptioninformation=();
100
   my $closed = 0;
100
   foreach my $subscriptionid (@subscriptionid){
101
   foreach my $subscriptionid (@subscriptionid){
101
    my $subs= GetSubscription($subscriptionid);
102
    my $subs= GetSubscription($subscriptionid);
103
    $closed = 1 if $subs->{closed};
102
    $subs->{opacnote}     =~ s/\n/\<br\/\>/g;
104
    $subs->{opacnote}     =~ s/\n/\<br\/\>/g;
103
    $subs->{missinglist}  =~ s/\n/\<br\/\>/g;
105
    $subs->{missinglist}  =~ s/\n/\<br\/\>/g;
104
    $subs->{recievedlist} =~ s/\n/\<br\/\>/g;
106
    $subs->{recievedlist} =~ s/\n/\<br\/\>/g;
Lines 123-128 if (@subscriptionid){ Link Here
123
    my $tmpsubscription= GetFullSubscription($subscriptionid);
125
    my $tmpsubscription= GetFullSubscription($subscriptionid);
124
    @subscriptioninformation=(@$tmpsubscription,@subscriptioninformation);
126
    @subscriptioninformation=(@$tmpsubscription,@subscriptioninformation);
125
  }
127
  }
128
  $template->param(closed => $closed);
126
  $subscriptions=PrepareSerialsData(\@subscriptioninformation);
129
  $subscriptions=PrepareSerialsData(\@subscriptioninformation);
127
  $subscriptioncount = CountSubscriptionFromBiblionumber($subscriptiondescs->[0]{'biblionumber'});
130
  $subscriptioncount = CountSubscriptionFromBiblionumber($subscriptiondescs->[0]{'biblionumber'});
128
} else {
131
} else {
(-)a/serials/serials-search.pl (-1 / +24 lines)
Lines 46-51 my $biblionumber = $query->param('biblionumber') || ''; Link Here
46
my $branch        = $query->param('branch_filter') || '';
46
my $branch        = $query->param('branch_filter') || '';
47
my $routing       = $query->param('routing') || C4::Context->preference("RoutingSerials");
47
my $routing       = $query->param('routing') || C4::Context->preference("RoutingSerials");
48
my $searched      = $query->param('searched') || 0;
48
my $searched      = $query->param('searched') || 0;
49
my @subscriptionids = $query ->param('subscriptionid');
50
my $op            = $query->param('op');
49
51
50
my ( $template, $loggedinuser, $cookie ) = get_template_and_user(
52
my ( $template, $loggedinuser, $cookie ) = get_template_and_user(
51
    {
53
    {
Lines 58-63 my ( $template, $loggedinuser, $cookie ) = get_template_and_user( Link Here
58
    }
60
    }
59
);
61
);
60
62
63
if ( $op and $op eq "close" ) {
64
    for my $subscriptionid ( @subscriptionids ) {
65
        C4::Serials::CloseSubscription( $subscriptionid );
66
    }
67
} elsif ( $op and $op eq "reopen" ) {
68
    for my $subscriptionid ( @subscriptionids ) {
69
        C4::Serials::ReopenSubscription( $subscriptionid );
70
    }
71
}
72
61
my @subscriptions;
73
my @subscriptions;
62
if ($searched){
74
if ($searched){
63
    @subscriptions = SearchSubscriptions(
75
    @subscriptions = SearchSubscriptions(
Lines 81-86 if ($routing) { Link Here
81
    }
93
    }
82
}
94
}
83
95
96
my (@openedsubscriptions, @closedsubscriptions);
97
for my $sub ( @subscriptions ) {
98
    unless ( $sub->{closed} ) {
99
        push @openedsubscriptions, $sub;
100
    } else {
101
        push @closedsubscriptions, $sub;
102
    }
103
}
104
84
my $branches = GetBranches();
105
my $branches = GetBranches();
85
my @branches_loop;
106
my @branches_loop;
86
foreach (sort keys %$branches){
107
foreach (sort keys %$branches){
Lines 94-100 foreach (sort keys %$branches){ Link Here
94
}
115
}
95
116
96
$template->param(
117
$template->param(
97
    subscriptions => \@subscriptions,
118
    openedsubscriptions => \@openedsubscriptions,
119
    closedsubscriptions => \@closedsubscriptions,
120
    total         => @openedsubscriptions + @closedsubscriptions,
98
    title_filter  => $title,
121
    title_filter  => $title,
99
    ISSN_filter   => $ISSN,
122
    ISSN_filter   => $ISSN,
100
    EAN_filter    => $EAN,
123
    EAN_filter    => $EAN,
(-)a/serials/subscription-detail.pl (-1 / +7 lines)
Lines 34-39 my $issueconfirmed = $query->param('issueconfirmed'); Link Here
34
my $dbh = C4::Context->dbh;
34
my $dbh = C4::Context->dbh;
35
my ($template, $loggedinuser, $cookie, $hemisphere);
35
my ($template, $loggedinuser, $cookie, $hemisphere);
36
my $subscriptionid = $query->param('subscriptionid');
36
my $subscriptionid = $query->param('subscriptionid');
37
38
if ( $op and $op eq "close" ) {
39
    C4::Serials::CloseSubscription( $subscriptionid );
40
} elsif ( $op and $op eq "reopen" ) {
41
    C4::Serials::ReopenSubscription( $subscriptionid );
42
}
43
37
my $subs = GetSubscription($subscriptionid);
44
my $subs = GetSubscription($subscriptionid);
38
45
39
$subs->{enddate} = GetExpirationDate($subscriptionid);
46
$subs->{enddate} = GetExpirationDate($subscriptionid);
40
- 

Return to bug 8782