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

(-)a/C4/Serials.pm (-372 / +576 lines)
Lines 18-31 package C4::Serials; Link Here
18
# with Koha; if not, write to the Free Software Foundation, Inc.,
18
# with Koha; if not, write to the Free Software Foundation, Inc.,
19
# 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
19
# 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
20
20
21
use strict;
21
use Modern::Perl;
22
use warnings;
22
23
use C4::Dates qw(format_date format_date_in_iso);
23
use C4::Dates qw(format_date format_date_in_iso);
24
use Date::Calc qw(:all);
24
use Date::Calc qw(:all);
25
use POSIX qw(strftime);
25
use POSIX qw(strftime setlocale LC_TIME);
26
use C4::Biblio;
26
use C4::Biblio;
27
use C4::Log;    # logaction
27
use C4::Log;    # logaction
28
use C4::Debug;
28
use C4::Debug;
29
use C4::Serials::Frequency;
30
use C4::Serials::Numberpattern;
29
31
30
use vars qw($VERSION @ISA @EXPORT @EXPORT_OK %EXPORT_TAGS);
32
use vars qw($VERSION @ISA @EXPORT @EXPORT_OK %EXPORT_TAGS);
31
33
Lines 39-46 BEGIN { Link Here
39
      &SearchSubscriptions
41
      &SearchSubscriptions
40
      &GetFullSubscriptionsFromBiblionumber   &GetFullSubscription &ModSubscriptionHistory
42
      &GetFullSubscriptionsFromBiblionumber   &GetFullSubscription &ModSubscriptionHistory
41
      &HasSubscriptionStrictlyExpired &HasSubscriptionExpired &GetExpirationDate &abouttoexpire
43
      &HasSubscriptionStrictlyExpired &HasSubscriptionExpired &GetExpirationDate &abouttoexpire
44
      &GetSubscriptionHistoryFromSubscriptionId
42
45
43
      &GetNextSeq         &NewIssue           &ItemizeSerials    &GetSerials
46
      &GetNextSeq &GetSeq &NewIssue           &ItemizeSerials    &GetSerials
44
      &GetLatestSerials   &ModSerialStatus    &GetNextDate       &GetSerials2
47
      &GetLatestSerials   &ModSerialStatus    &GetNextDate       &GetSerials2
45
      &ReNewSubscription  &GetLateIssues      &GetLateOrMissingIssues
48
      &ReNewSubscription  &GetLateIssues      &GetLateOrMissingIssues
46
      &GetSerialInformation                   &AddItem2Serial
49
      &GetSerialInformation                   &AddItem2Serial
Lines 162-181 sub GetLateIssues { Link Here
162
165
163
=head2 GetSubscriptionHistoryFromSubscriptionId
166
=head2 GetSubscriptionHistoryFromSubscriptionId
164
167
165
$sth = GetSubscriptionHistoryFromSubscriptionId()
168
$history = GetSubscriptionHistoryFromSubscriptionId($subscriptionid);
166
this function prepares the SQL request and returns the statement handle
169
167
After this function, don't forget to execute it by using $sth->execute($subscriptionid)
170
This function returns the subscription history as a hashref
168
171
169
=cut
172
=cut
170
173
171
sub GetSubscriptionHistoryFromSubscriptionId {
174
sub GetSubscriptionHistoryFromSubscriptionId {
175
    my ($subscriptionid) = @_;
176
177
    return unless $subscriptionid;
178
172
    my $dbh   = C4::Context->dbh;
179
    my $dbh   = C4::Context->dbh;
173
    my $query = qq|
180
    my $query = qq|
174
        SELECT *
181
        SELECT *
175
        FROM   subscriptionhistory
182
        FROM   subscriptionhistory
176
        WHERE  subscriptionid = ?
183
        WHERE  subscriptionid = ?
177
    |;
184
    |;
178
    return $dbh->prepare($query);
185
    my $sth = $dbh->prepare($query);
186
    $sth->execute($subscriptionid);
187
    my $results = $sth->fetchrow_hashref;
188
    $sth->finish;
189
190
    return $results;
179
}
191
}
180
192
181
=head2 GetSerialStatusFromSerialId
193
=head2 GetSerialStatusFromSerialId
Lines 569-575 sub GetSubscriptions { Link Here
569
    my $dbh = C4::Context->dbh;
581
    my $dbh = C4::Context->dbh;
570
    my $sth;
582
    my $sth;
571
    my $sql = qq(
583
    my $sql = qq(
572
            SELECT subscription.*, subscriptionhistory.*, biblio.title,biblioitems.issn,biblio.biblionumber
584
            SELECT subscriptionhistory.*, subscription.*, biblio.title,biblioitems.issn,biblio.biblionumber
573
            FROM   subscription
585
            FROM   subscription
574
            LEFT JOIN subscriptionhistory USING(subscriptionid)
586
            LEFT JOIN subscriptionhistory USING(subscriptionid)
575
            LEFT JOIN biblio ON biblio.biblionumber = subscription.biblionumber
587
            LEFT JOIN biblio ON biblio.biblionumber = subscription.biblionumber
Lines 885-969 a list containing all the input params updated. Link Here
885
897
886
=cut
898
=cut
887
899
888
# sub GetNextSeq {
889
#     my ($val) =@_;
890
#     my ($calculated,$newlastvalue1,$newlastvalue2,$newlastvalue3,$newinnerloop1,$newinnerloop2,$newinnerloop3);
891
#     $calculated = $val->{numberingmethod};
892
# # calculate the (expected) value of the next issue recieved.
893
#     $newlastvalue1 = $val->{lastvalue1};
894
# # check if we have to increase the new value.
895
#     $newinnerloop1 = $val->{innerloop1}+1;
896
#     $newinnerloop1=0 if ($newinnerloop1 >= $val->{every1});
897
#     $newlastvalue1 += $val->{add1} if ($newinnerloop1<1); # <1 to be true when 0 or empty.
898
#     $newlastvalue1=$val->{setto1} if ($newlastvalue1>$val->{whenmorethan1}); # reset counter if needed.
899
#     $calculated =~ s/\{X\}/$newlastvalue1/g;
900
#
901
#     $newlastvalue2 = $val->{lastvalue2};
902
# # check if we have to increase the new value.
903
#     $newinnerloop2 = $val->{innerloop2}+1;
904
#     $newinnerloop2=0 if ($newinnerloop2 >= $val->{every2});
905
#     $newlastvalue2 += $val->{add2} if ($newinnerloop2<1); # <1 to be true when 0 or empty.
906
#     $newlastvalue2=$val->{setto2} if ($newlastvalue2>$val->{whenmorethan2}); # reset counter if needed.
907
#     $calculated =~ s/\{Y\}/$newlastvalue2/g;
908
#
909
#     $newlastvalue3 = $val->{lastvalue3};
910
# # check if we have to increase the new value.
911
#     $newinnerloop3 = $val->{innerloop3}+1;
912
#     $newinnerloop3=0 if ($newinnerloop3 >= $val->{every3});
913
#     $newlastvalue3 += $val->{add3} if ($newinnerloop3<1); # <1 to be true when 0 or empty.
914
#     $newlastvalue3=$val->{setto3} if ($newlastvalue3>$val->{whenmorethan3}); # reset counter if needed.
915
#     $calculated =~ s/\{Z\}/$newlastvalue3/g;
916
#     return ($calculated,$newlastvalue1,$newlastvalue2,$newlastvalue3,$newinnerloop1,$newinnerloop2,$newinnerloop3);
917
# }
918
919
sub GetNextSeq {
900
sub GetNextSeq {
920
    my ($val) = @_;
901
    my ($val, $planneddate) = @_;
921
    my ( $calculated, $newlastvalue1, $newlastvalue2, $newlastvalue3, $newinnerloop1, $newinnerloop2, $newinnerloop3 );
902
    my ( $calculated, $newlastvalue1, $newlastvalue2, $newlastvalue3,
922
    my $pattern          = $val->{numberpattern};
903
    $newinnerloop1, $newinnerloop2, $newinnerloop3 );
923
    my @seasons          = ( 'nothing', 'Winter', 'Spring', 'Summer', 'Autumn' );
904
    my $count = 1;
924
    my @southern_seasons = ( '', 'Summer', 'Autumn', 'Winter', 'Spring' );
905
925
    $calculated    = $val->{numberingmethod};
906
    if($val->{'skip_serialseq'}) {
926
    $newlastvalue1 = $val->{lastvalue1};
907
        my @irreg = split /;/, $val->{'irregularity'};
927
    $newlastvalue2 = $val->{lastvalue2};
908
        if(@irreg > 0) {
928
    $newlastvalue3 = $val->{lastvalue3};
909
            my $irregularities = {};
929
    $newlastvalue1 = $val->{lastvalue1};
910
            $irregularities->{$_} = 1 foreach(@irreg);
930
911
            my $issueno = GetFictiveIssueNumber($val, $planneddate) + 1;
931
    # check if we have to increase the new value.
912
            while($irregularities->{$issueno}) {
932
    $newinnerloop1 = $val->{innerloop1} + 1;
913
                $count++;
933
    $newinnerloop1 = 0 if ( $newinnerloop1 >= $val->{every1} );
914
                $issueno++;
934
    $newlastvalue1 += $val->{add1} if ( $newinnerloop1 < 1 );    # <1 to be true when 0 or empty.
915
            }
935
    $newlastvalue1 = $val->{setto1} if ( $newlastvalue1 > $val->{whenmorethan1} );    # reset counter if needed.
936
    $calculated =~ s/\{X\}/$newlastvalue1/g;
937
938
    $newlastvalue2 = $val->{lastvalue2};
939
940
    # check if we have to increase the new value.
941
    $newinnerloop2 = $val->{innerloop2} + 1;
942
    $newinnerloop2 = 0 if ( $newinnerloop2 >= $val->{every2} );
943
    $newlastvalue2 += $val->{add2} if ( $newinnerloop2 < 1 );                         # <1 to be true when 0 or empty.
944
    $newlastvalue2 = $val->{setto2} if ( $newlastvalue2 > $val->{whenmorethan2} );    # reset counter if needed.
945
    if ( $pattern == 6 ) {
946
        if ( $val->{hemisphere} == 2 ) {
947
            my $newlastvalue2seq = $southern_seasons[$newlastvalue2];
948
            $calculated =~ s/\{Y\}/$newlastvalue2seq/g;
949
        } else {
950
            my $newlastvalue2seq = $seasons[$newlastvalue2];
951
            $calculated =~ s/\{Y\}/$newlastvalue2seq/g;
952
        }
916
        }
953
    } else {
954
        $calculated =~ s/\{Y\}/$newlastvalue2/g;
955
    }
917
    }
956
918
957
    $newlastvalue3 = $val->{lastvalue3};
919
    my $pattern = $val->{numberpattern};
958
920
    $calculated    = $val->{numberingmethod};
959
    # check if we have to increase the new value.
921
    my $locale = $val->{locale};
960
    $newinnerloop3 = $val->{innerloop3} + 1;
922
    $newlastvalue1 = $val->{lastvalue1} || 0;
961
    $newinnerloop3 = 0 if ( $newinnerloop3 >= $val->{every3} );
923
    $newlastvalue2 = $val->{lastvalue2} || 0;
962
    $newlastvalue3 += $val->{add3} if ( $newinnerloop3 < 1 );    # <1 to be true when 0 or empty.
924
    $newlastvalue3 = $val->{lastvalue3} || 0;
963
    $newlastvalue3 = $val->{setto3} if ( $newlastvalue3 > $val->{whenmorethan3} );    # reset counter if needed.
925
    $newinnerloop1 = $val->{innerloop1} || 0;
964
    $calculated =~ s/\{Z\}/$newlastvalue3/g;
926
    $newinnerloop2 = $val->{innerloop2} || 0;
927
    $newinnerloop3 = $val->{innerloop3} || 0;
928
    my %calc;
929
    foreach(qw/X Y Z/) {
930
        $calc{$_} = 1 if ($val->{'numberingmethod'} =~ /\{$_\}/);
931
    }
932
933
    for(my $i = 0; $i < $count; $i++) {
934
        if($calc{'X'}) {
935
            # check if we have to increase the new value.
936
            $newinnerloop1 += 1;
937
            if ($newinnerloop1 >= $val->{every1}) {
938
                $newinnerloop1  = 0;
939
                $newlastvalue1 += $val->{add1};
940
            }
941
            # reset counter if needed.
942
            $newlastvalue1 = $val->{setto1} if ($newlastvalue1 > $val->{whenmorethan1});
943
        }
944
        if($calc{'Y'}) {
945
            # check if we have to increase the new value.
946
            $newinnerloop2 += 1;
947
            if ($newinnerloop2 >= $val->{every2}) {
948
                $newinnerloop2  = 0;
949
                $newlastvalue2 += $val->{add2};
950
            }
951
            # reset counter if needed.
952
            $newlastvalue2 = $val->{setto2} if ($newlastvalue2 > $val->{whenmorethan2});
953
        }
954
        if($calc{'Z'}) {
955
            # check if we have to increase the new value.
956
            $newinnerloop3 += 1;
957
            if ($newinnerloop3 >= $val->{every3}) {
958
                $newinnerloop3  = 0;
959
                $newlastvalue3 += $val->{add3};
960
            }
961
            # reset counter if needed.
962
            $newlastvalue3 = $val->{setto3} if ($newlastvalue3 > $val->{whenmorethan3});
963
        }
964
    }
965
    if($calc{'X'}) {
966
        my $newlastvalue1string = _numeration( $newlastvalue1, $val->{numbering1}, $locale );
967
        $calculated =~ s/\{X\}/$newlastvalue1string/g;
968
    }
969
    if($calc{'Y'}) {
970
        my $newlastvalue2string = _numeration( $newlastvalue2, $val->{numbering2}, $locale );
971
        $calculated =~ s/\{Y\}/$newlastvalue2string/g;
972
    }
973
    if($calc{'Z'}) {
974
        my $newlastvalue3string = _numeration( $newlastvalue3, $val->{numbering3}, $locale );
975
        $calculated =~ s/\{Z\}/$newlastvalue3string/g;
976
    }
965
977
966
    return ( $calculated, $newlastvalue1, $newlastvalue2, $newlastvalue3, $newinnerloop1, $newinnerloop2, $newinnerloop3 );
978
    return ($calculated,
979
            $newlastvalue1, $newlastvalue2, $newlastvalue3,
980
            $newinnerloop1, $newinnerloop2, $newinnerloop3);
967
}
981
}
968
982
969
=head2 GetSeq
983
=head2 GetSeq
Lines 978-1004 the sequence in integer format Link Here
978
992
979
sub GetSeq {
993
sub GetSeq {
980
    my ($val) = @_;
994
    my ($val) = @_;
995
    my $locale = $val->{locale};
996
981
    my $pattern = $val->{numberpattern};
997
    my $pattern = $val->{numberpattern};
982
    my @seasons          = ( 'nothing', 'Winter', 'Spring', 'Summer', 'Autumn' );
998
    my $calculated = $val->{numberingmethod};
983
    my @southern_seasons = ( '',        'Summer', 'Autumn', 'Winter', 'Spring' );
999
984
    my $calculated       = $val->{numberingmethod};
1000
    my $newlastvalue1 = $val->{'lastvalue1'} || 0;
985
    my $x                = $val->{'lastvalue1'};
1001
    $newlastvalue1 = _numeration($newlastvalue1, $val->{numbering1}, $locale) if ($val->{numbering1}); # reset counter if needed.
986
    $calculated =~ s/\{X\}/$x/g;
1002
    $calculated =~ s/\{X\}/$newlastvalue1/g;
987
    my $newlastvalue2 = $val->{'lastvalue2'};
1003
988
1004
    my $newlastvalue2 = $val->{'lastvalue2'} || 0;
989
    if ( $pattern == 6 ) {
1005
    $newlastvalue2 = _numeration($newlastvalue2, $val->{numbering2}, $locale) if ($val->{numbering2}); # reset counter if needed.
990
        if ( $val->{hemisphere} == 2 ) {
1006
    $calculated =~ s/\{Y\}/$newlastvalue2/g;
991
            my $newlastvalue2seq = $southern_seasons[$newlastvalue2];
1007
992
            $calculated =~ s/\{Y\}/$newlastvalue2seq/g;
1008
    my $newlastvalue3 = $val->{'lastvalue3'} || 0;
993
        } else {
1009
    $newlastvalue3 = _numeration($newlastvalue3, $val->{numbering3}, $locale) if ($val->{numbering3}); # reset counter if needed.
994
            my $newlastvalue2seq = $seasons[$newlastvalue2];
1010
    $calculated =~ s/\{Z\}/$newlastvalue3/g;
995
            $calculated =~ s/\{Y\}/$newlastvalue2seq/g;
996
        }
997
    } else {
998
        $calculated =~ s/\{Y\}/$newlastvalue2/g;
999
    }
1000
    my $z = $val->{'lastvalue3'};
1001
    $calculated =~ s/\{Z\}/$z/g;
1002
    return $calculated;
1011
    return $calculated;
1003
}
1012
}
1004
1013
Lines 1023-1036 sub GetExpirationDate { Link Here
1023
    $enddate = $startdate || $subscription->{startdate};
1032
    $enddate = $startdate || $subscription->{startdate};
1024
    my @date = split( /-/, $enddate );
1033
    my @date = split( /-/, $enddate );
1025
    return if ( scalar(@date) != 3 || not check_date(@date) );
1034
    return if ( scalar(@date) != 3 || not check_date(@date) );
1026
    if ( ( $subscription->{periodicity} % 16 ) > 0 ) {
1035
    my $frequency = C4::Serials::Frequency::GetSubscriptionFrequency($subscription->{periodicity});
1027
1036
    if ( $frequency and $frequency->{unit} ) {
1037
 
1028
        # If Not Irregular
1038
        # If Not Irregular
1029
        if ( my $length = $subscription->{numberlength} ) {
1039
        if ( my $length = $subscription->{numberlength} ) {
1030
1040
1031
            #calculate the date of the last issue.
1041
            #calculate the date of the last issue.
1032
            for ( my $i = 1 ; $i <= $length ; $i++ ) {
1042
            for ( my $i = 1 ; $i <= $length ; $i++ ) {
1033
                $enddate = GetNextDate( $enddate, $subscription );
1043
                $enddate = GetNextDate( $subscription, $enddate );
1034
            }
1044
            }
1035
        } elsif ( $subscription->{monthlength} ) {
1045
        } elsif ( $subscription->{monthlength} ) {
1036
            if ( $$subscription{startdate} ) {
1046
            if ( $$subscription{startdate} ) {
Lines 1043-1052 sub GetExpirationDate { Link Here
1043
                my @enddate = Add_Delta_Days( $date[0], $date[1], $date[2], $subscription->{weeklength} * 7 );
1053
                my @enddate = Add_Delta_Days( $date[0], $date[1], $date[2], $subscription->{weeklength} * 7 );
1044
                $enddate = sprintf( "%04d-%02d-%02d", $enddate[0], $enddate[1], $enddate[2] );
1054
                $enddate = sprintf( "%04d-%02d-%02d", $enddate[0], $enddate[1], $enddate[2] );
1045
            }
1055
            }
1056
        } else {
1057
            $enddate = $subscription->{enddate};
1046
        }
1058
        }
1047
        return $enddate;
1059
        return $enddate;
1048
    } else {
1060
    } else {
1049
        return;
1061
        return $subscription->{enddate};
1050
    }
1062
    }
1051
}
1063
}
1052
1064
Lines 1079-1098 returns the number of rows affected Link Here
1079
=cut
1091
=cut
1080
1092
1081
sub ModSubscriptionHistory {
1093
sub ModSubscriptionHistory {
1082
    my ( $subscriptionid, $histstartdate, $enddate, $recievedlist, $missinglist, $opacnote, $librariannote ) = @_;
1094
    my ( $subscriptionid, $histstartdate, $enddate, $receivedlist, $missinglist, $opacnote, $librariannote ) = @_;
1083
    my $dbh   = C4::Context->dbh;
1095
    my $dbh   = C4::Context->dbh;
1084
    my $query = "UPDATE subscriptionhistory 
1096
    my $query = "UPDATE subscriptionhistory 
1085
                    SET histstartdate=?,histenddate=?,recievedlist=?,missinglist=?,opacnote=?,librariannote=?
1097
                    SET histstartdate=?,histenddate=?,recievedlist=?,missinglist=?,opacnote=?,librariannote=?
1086
                    WHERE subscriptionid=?
1098
                    WHERE subscriptionid=?
1087
                ";
1099
                ";
1088
    my $sth = $dbh->prepare($query);
1100
    my $sth = $dbh->prepare($query);
1089
    $recievedlist =~ s/^; //;
1101
    $receivedlist =~ s/^; // if $receivedlist;
1090
    $missinglist  =~ s/^; //;
1102
    $missinglist  =~ s/^; // if $missinglist;
1091
    $opacnote     =~ s/^; //;
1103
    $opacnote     =~ s/^; // if $opacnote;
1092
    $sth->execute( $histstartdate, $enddate, $recievedlist, $missinglist, $opacnote, $librariannote, $subscriptionid );
1104
    $sth->execute( $histstartdate, $enddate, $receivedlist, $missinglist, $opacnote, $librariannote, $subscriptionid );
1093
    return $sth->rows;
1105
    return $sth->rows;
1094
}
1106
}
1095
1107
1108
# Update missinglist field, used by ModSerialStatus
1109
sub _update_missinglist {
1110
    my $subscriptionid = shift;
1111
1112
    my $dbh = C4::Context->dbh;
1113
    my @missingserials = GetSerials2($subscriptionid, "4,5");
1114
    my $missinglist;
1115
    foreach (@missingserials) {
1116
        if($_->{'status'} == 4) {
1117
            $missinglist .= $_->{'serialseq'} . "; ";
1118
        } elsif($_->{'status'} == 5) {
1119
            $missinglist .= "not issued " . $_->{'serialseq'} . "; ";
1120
        }
1121
    }
1122
    $missinglist =~ s/; $//;
1123
    my $query = qq{
1124
        UPDATE subscriptionhistory
1125
        SET missinglist = ?
1126
        WHERE subscriptionid = ?
1127
    };
1128
    my $sth = $dbh->prepare($query);
1129
    $sth->execute($missinglist, $subscriptionid);
1130
}
1131
1132
# Update recievedlist field, used by ModSerialStatus
1133
sub _update_receivedlist {
1134
    my $subscriptionid = shift;
1135
1136
    my $dbh = C4::Context->dbh;
1137
    my @receivedserials = GetSerials2($subscriptionid, "2");
1138
    my $receivedlist;
1139
    foreach (@receivedserials) {
1140
        $receivedlist .= $_->{'serialseq'} . "; ";
1141
    }
1142
    $receivedlist =~ s/; $//;
1143
    my $query = qq{
1144
        UPDATE subscriptionhistory
1145
        SET recievedlist = ?
1146
        WHERE subscriptionid = ?
1147
    };
1148
    my $sth = $dbh->prepare($query);
1149
    $sth->execute($receivedlist, $subscriptionid);
1150
}
1151
1096
=head2 ModSerialStatus
1152
=head2 ModSerialStatus
1097
1153
1098
ModSerialStatus($serialid,$serialseq, $planneddate,$publisheddate,$status,$notes)
1154
ModSerialStatus($serialid,$serialseq, $planneddate,$publisheddate,$status,$notes)
Lines 1105-1126 Note : if we change from "waited" to something else,then we will have to create Link Here
1105
sub ModSerialStatus {
1161
sub ModSerialStatus {
1106
    my ( $serialid, $serialseq, $planneddate, $publisheddate, $status, $notes ) = @_;
1162
    my ( $serialid, $serialseq, $planneddate, $publisheddate, $status, $notes ) = @_;
1107
1163
1164
1108
    #It is a usual serial
1165
    #It is a usual serial
1109
    # 1st, get previous status :
1166
    # 1st, get previous status :
1110
    my $dbh   = C4::Context->dbh;
1167
    my $dbh   = C4::Context->dbh;
1111
    my $query = "SELECT subscriptionid,status FROM serial WHERE  serialid=?";
1168
    my $query = "SELECT serial.subscriptionid,serial.status,subscription.periodicity
1169
        FROM serial, subscription
1170
        WHERE serial.subscriptionid=subscription.subscriptionid
1171
            AND serialid=?";
1112
    my $sth   = $dbh->prepare($query);
1172
    my $sth   = $dbh->prepare($query);
1113
    $sth->execute($serialid);
1173
    $sth->execute($serialid);
1114
    my ( $subscriptionid, $oldstatus ) = $sth->fetchrow;
1174
    my ( $subscriptionid, $oldstatus, $periodicity ) = $sth->fetchrow;
1175
    my $frequency = GetSubscriptionFrequency($periodicity);
1115
1176
1116
    # change status & update subscriptionhistory
1177
    # change status & update subscriptionhistory
1117
    my $val;
1178
    my $val;
1118
    if ( $status == 6 ) {
1179
    if ( $status == 6 ) {
1119
        DelIssue( {'serialid'=>$serialid, 'subscriptionid'=>$subscriptionid,'serialseq'=>$serialseq} );
1180
        DelIssue( { 'serialid' => $serialid, 'subscriptionid' => $subscriptionid, 'serialseq' => $serialseq } );
1120
    }
1181
    } else {
1121
    else {
1182
1122
        my $query =
1183
        unless ($frequency->{'unit'}) {
1123
'UPDATE serial SET serialseq=?,publisheddate=?,planneddate=?,status=?,notes=? WHERE  serialid = ?';
1184
            if ( not $planneddate or $planneddate eq '0000-00-00' ) { $planneddate = C4::Dates->new()->output('iso') };
1185
            if ( not $publisheddate or $publisheddate eq '0000-00-00' ) { $publisheddate = C4::Dates->new()->output('iso') };
1186
        }
1187
        my $query = 'UPDATE serial SET serialseq=?,publisheddate=?,planneddate=?,status=?,notes=? WHERE  serialid = ?';
1124
        $sth = $dbh->prepare($query);
1188
        $sth = $dbh->prepare($query);
1125
        $sth->execute( $serialseq, $publisheddate, $planneddate, $status, $notes, $serialid );
1189
        $sth->execute( $serialseq, $publisheddate, $planneddate, $status, $notes, $serialid );
1126
        $query = "SELECT * FROM   subscription WHERE  subscriptionid = ?";
1190
        $query = "SELECT * FROM   subscription WHERE  subscriptionid = ?";
Lines 1128-1185 sub ModSerialStatus { Link Here
1128
        $sth->execute($subscriptionid);
1192
        $sth->execute($subscriptionid);
1129
        my $val = $sth->fetchrow_hashref;
1193
        my $val = $sth->fetchrow_hashref;
1130
        unless ( $val->{manualhistory} ) {
1194
        unless ( $val->{manualhistory} ) {
1131
            $query = "SELECT missinglist,recievedlist FROM subscriptionhistory WHERE  subscriptionid=?";
1195
            if ( $status == 2 || ($oldstatus == 2 && $status != 2) ) {
1132
            $sth   = $dbh->prepare($query);
1196
                  _update_receivedlist($subscriptionid);
1133
            $sth->execute($subscriptionid);
1197
            }
1134
            my ( $missinglist, $recievedlist ) = $sth->fetchrow;
1198
            if($status == 4 || $status == 5
1135
            if ( $status == 2 ) {
1199
              || ($oldstatus == 4 && $status != 4)
1136
1200
              || ($oldstatus == 5 && $status != 5)) {
1137
                $recievedlist .= "; $serialseq"
1201
                _update_missinglist($subscriptionid);
1138
                  unless ( index( "$recievedlist", "$serialseq" ) >= 0 );
1139
            }
1202
            }
1140
1141
            #         warn "missinglist : $missinglist serialseq :$serialseq, ".index("$missinglist","$serialseq");
1142
            $missinglist .= "; $serialseq"
1143
              if ( $status == 4
1144
                and not index( "$missinglist", "$serialseq" ) >= 0 );
1145
            $missinglist .= "; not issued $serialseq"
1146
              if ( $status == 5
1147
                and index( "$missinglist", "$serialseq" ) >= 0 );
1148
            $query = "UPDATE subscriptionhistory SET recievedlist=?, missinglist=? WHERE  subscriptionid=?";
1149
            $sth   = $dbh->prepare($query);
1150
            $recievedlist =~ s/^; //;
1151
            $missinglist  =~ s/^; //;
1152
            $sth->execute( $recievedlist, $missinglist, $subscriptionid );
1153
        }
1203
        }
1154
    }
1204
    }
1155
1205
1156
    # create new waited entry if needed (ie : was a "waited" and has changed)
1206
    # create new waited entry if needed (ie : was a "waited" and has changed)
1157
    if ( $oldstatus == 1 && $status != 1 ) {
1207
    if ( $oldstatus == 1 && $status != 1 ) {
1158
        my $query = "SELECT * FROM   subscription WHERE  subscriptionid = ?";
1208
        my $query = qq{
1209
            SELECT subscription.*, subscription_numberpatterns.*,
1210
                   subscription_frequencies.*
1211
            FROM subscription
1212
            LEFT JOIN subscription_numberpatterns ON subscription.numberpattern = subscription_numberpatterns.id
1213
            LEFT JOIN subscription_frequencies ON subscription.periodicity = subscription_frequencies.id
1214
            WHERE subscriptionid = ?
1215
        };
1159
        $sth = $dbh->prepare($query);
1216
        $sth = $dbh->prepare($query);
1160
        $sth->execute($subscriptionid);
1217
        $sth->execute($subscriptionid);
1161
        my $val = $sth->fetchrow_hashref;
1218
        my $val = $sth->fetchrow_hashref;
1162
1219
1163
        # next issue number
1220
        # next issue number
1164
        my (
1221
        my ( $newserialseq, $newlastvalue1, $newlastvalue2, $newlastvalue3, $newinnerloop1, $newinnerloop2, $newinnerloop3 ) = GetNextSeq($val, $publisheddate);
1165
            $newserialseq,  $newlastvalue1, $newlastvalue2, $newlastvalue3,
1166
            $newinnerloop1, $newinnerloop2, $newinnerloop3
1167
        ) = GetNextSeq($val);
1168
1222
1169
        # next date (calculated from actual date & frequency parameters)
1223
        # next date (calculated from actual date & frequency parameters)
1170
        my $nextpublisheddate = GetNextDate( $publisheddate, $val );
1224
        my $nextpublisheddate = GetNextDate($val, $publisheddate, 1);
1171
        NewIssue( $newserialseq, $subscriptionid, $val->{'biblionumber'}, 1, $nextpublisheddate, $nextpublisheddate );
1225
        my $nextpubdate = $nextpublisheddate;
1226
        NewIssue( $newserialseq, $subscriptionid, $val->{'biblionumber'}, 1, $nextpubdate, $nextpubdate );
1172
        $query = "UPDATE subscription SET lastvalue1=?, lastvalue2=?, lastvalue3=?, innerloop1=?, innerloop2=?, innerloop3=?
1227
        $query = "UPDATE subscription SET lastvalue1=?, lastvalue2=?, lastvalue3=?, innerloop1=?, innerloop2=?, innerloop3=?
1173
                    WHERE  subscriptionid = ?";
1228
                    WHERE  subscriptionid = ?";
1174
        $sth = $dbh->prepare($query);
1229
        $sth = $dbh->prepare($query);
1175
        $sth->execute( $newlastvalue1, $newlastvalue2, $newlastvalue3, $newinnerloop1, $newinnerloop2, $newinnerloop3, $subscriptionid );
1230
        $sth->execute( $newlastvalue1, $newlastvalue2, $newlastvalue3, $newinnerloop1, $newinnerloop2, $newinnerloop3, $subscriptionid );
1176
1231
1177
# check if an alert must be sent... (= a letter is defined & status became "arrived"
1232
        # check if an alert must be sent... (= a letter is defined & status became "arrived"
1178
        if ( $val->{letter} && $status == 2 && $oldstatus != 2 ) {
1233
        if ( $val->{letter} && $status == 2 && $oldstatus != 2 ) {
1179
            require C4::Letters;
1234
            require C4::Letters;
1180
            C4::Letters::SendAlerts( 'issue', $val->{subscriptionid}, $val->{letter} );
1235
            C4::Letters::SendAlerts( 'issue', $val->{subscriptionid}, $val->{letter} );
1181
        }
1236
        }
1182
    }
1237
    }
1238
1183
    return;
1239
    return;
1184
}
1240
}
1185
1241
Lines 1193-1223 returns a hashref: Link Here
1193
1249
1194
$nextexepected = {
1250
$nextexepected = {
1195
    serialid => int
1251
    serialid => int
1196
    planneddate => C4::Dates object
1252
    planneddate => ISO date
1197
    }
1253
    }
1198
1254
1199
=cut
1255
=cut
1200
1256
1201
sub GetNextExpected {
1257
sub GetNextExpected {
1202
    my ($subscriptionid) = @_;
1258
    my ($subscriptionid) = @_;
1203
    my $dbh              = C4::Context->dbh;
1259
1204
    my $sth              = $dbh->prepare('SELECT serialid, planneddate FROM serial WHERE subscriptionid=? AND status=?');
1260
    my $dbh = C4::Context->dbh;
1261
    my $query = qq{
1262
        SELECT *
1263
        FROM serial
1264
        WHERE subscriptionid = ?
1265
          AND status = ?
1266
        LIMIT 1
1267
    };
1268
    my $sth = $dbh->prepare($query);
1205
1269
1206
    # Each subscription has only one 'expected' issue, with serial.status==1.
1270
    # Each subscription has only one 'expected' issue, with serial.status==1.
1207
    $sth->execute( $subscriptionid, 1 );
1271
    $sth->execute( $subscriptionid, 1 );
1208
    my ( $nextissue ) = $sth->fetchrow_hashref;
1272
    my $nextissue = $sth->fetchrow_hashref;
1209
    if( !$nextissue){
1273
    if ( !$nextissue ) {
1210
         $sth = $dbh->prepare('SELECT serialid,planneddate FROM serial WHERE subscriptionid  = ? ORDER BY planneddate DESC LIMIT 1');
1274
        $query = qq{
1211
         $sth->execute( $subscriptionid );  
1275
            SELECT *
1212
         $nextissue = $sth->fetchrow_hashref;       
1276
            FROM serial
1277
            WHERE subscriptionid = ?
1278
            ORDER BY planneddate DESC
1279
            LIMIT 1
1280
        };
1281
        $sth = $dbh->prepare($query);
1282
        $sth->execute($subscriptionid);
1283
        $nextissue = $sth->fetchrow_hashref;
1213
    }
1284
    }
1214
    if (!defined $nextissue->{planneddate}) {
1285
    foreach(qw/planneddate publisheddate/) {
1215
        # or should this default to 1st Jan ???
1286
        if ( !defined $nextissue->{$_} ) {
1216
        $nextissue->{planneddate} = strftime('%Y-%m-%d',localtime);
1287
            # or should this default to 1st Jan ???
1288
            $nextissue->{$_} = strftime( '%Y-%m-%d', localtime );
1289
        }
1290
        $nextissue->{$_} = ($nextissue->{$_} ne '0000-00-00')
1291
                         ? $nextissue->{$_}
1292
                         : undef;
1217
    }
1293
    }
1218
    $nextissue->{planneddate} = C4::Dates->new($nextissue->{planneddate},'iso');
1219
    return $nextissue;
1220
1294
1295
    return $nextissue;
1221
}
1296
}
1222
1297
1223
=head2 ModNextExpected
1298
=head2 ModNextExpected
Lines 1227-1233 ModNextExpected($subscriptionid,$date) Link Here
1227
Update the planneddate for the current expected issue of the subscription.
1302
Update the planneddate for the current expected issue of the subscription.
1228
This will modify all future prediction results.  
1303
This will modify all future prediction results.  
1229
1304
1230
C<$date> is a C4::Dates object.
1305
C<$date> is an ISO date.
1231
1306
1232
returns 0
1307
returns 0
1233
1308
Lines 1241-1251 sub ModNextExpected { Link Here
1241
    my $sth = $dbh->prepare('UPDATE serial SET planneddate=?,publisheddate=? WHERE subscriptionid=? AND status=?');
1316
    my $sth = $dbh->prepare('UPDATE serial SET planneddate=?,publisheddate=? WHERE subscriptionid=? AND status=?');
1242
1317
1243
    # Each subscription has only one 'expected' issue, with serial.status==1.
1318
    # Each subscription has only one 'expected' issue, with serial.status==1.
1244
    $sth->execute( $date->output('iso'), $date->output('iso'), $subscriptionid, 1 );
1319
    $sth->execute( $date, $date, $subscriptionid, 1 );
1245
    return 0;
1320
    return 0;
1246
1321
1247
}
1322
}
1248
1323
1324
=head2 GetSubscriptionIrregularities
1325
1326
=over4
1327
1328
=item @irreg = &GetSubscriptionIrregularities($subscriptionid);
1329
get the list of irregularities for a subscription
1330
1331
=back
1332
1333
=cut
1334
1335
sub GetSubscriptionIrregularities {
1336
    my $subscriptionid = shift;
1337
1338
    return undef unless $subscriptionid;
1339
1340
    my $dbh = C4::Context->dbh;
1341
    my $query = qq{
1342
        SELECT irregularity
1343
        FROM subscription
1344
        WHERE subscriptionid = ?
1345
    };
1346
    my $sth = $dbh->prepare($query);
1347
    $sth->execute($subscriptionid);
1348
1349
    my ($result) = $sth->fetchrow_array;
1350
    my @irreg = split /;/, $result;
1351
1352
    return @irreg;
1353
}
1354
1249
=head2 ModSubscription
1355
=head2 ModSubscription
1250
1356
1251
this function modifies a subscription. Put all new values on input args.
1357
this function modifies a subscription. Put all new values on input args.
Lines 1254-1296 returns the number of rows affected Link Here
1254
=cut
1360
=cut
1255
1361
1256
sub ModSubscription {
1362
sub ModSubscription {
1257
    my ($auser,           $branchcode,      $aqbooksellerid,    $cost,             $aqbudgetid,    $startdate,   $periodicity,   $firstacquidate,
1363
    my (
1258
        $dow,             $irregularity,    $numberpattern,     $numberlength,     $weeklength,    $monthlength, $add1,          $every1,
1364
    $auser, $branchcode, $aqbooksellerid, $cost, $aqbudgetid, $startdate,
1259
        $whenmorethan1,   $setto1,          $lastvalue1,        $innerloop1,       $add2,          $every2,      $whenmorethan2, $setto2,
1365
    $periodicity, $firstacquidate, $irregularity, $numberpattern, $locale,
1260
        $lastvalue2,      $innerloop2,      $add3,              $every3,           $whenmorethan3, $setto3,      $lastvalue3,    $innerloop3,
1366
    $numberlength, $weeklength, $monthlength, $lastvalue1, $innerloop1,
1261
        $numberingmethod, $status,          $biblionumber,      $callnumber,       $notes,         $letter,      $hemisphere,    $manualhistory,
1367
    $lastvalue2, $innerloop2, $lastvalue3, $innerloop3, $status,
1262
        $internalnotes,   $serialsadditems, $staffdisplaycount, $opacdisplaycount, $graceperiod,   $location,    $enddate,       $subscriptionid
1368
    $biblionumber, $callnumber, $notes, $letter, $manualhistory,
1369
    $internalnotes, $serialsadditems, $staffdisplaycount, $opacdisplaycount,
1370
    $graceperiod, $location, $enddate, $subscriptionid, $skip_serialseq
1263
    ) = @_;
1371
    ) = @_;
1264
1372
1265
    #     warn $irregularity;
1266
    my $dbh   = C4::Context->dbh;
1373
    my $dbh   = C4::Context->dbh;
1267
    my $query = "UPDATE subscription
1374
    my $query = "UPDATE subscription
1268
                    SET librarian=?, branchcode=?,aqbooksellerid=?,cost=?,aqbudgetid=?,startdate=?,
1375
        SET librarian=?, branchcode=?, aqbooksellerid=?, cost=?, aqbudgetid=?,
1269
                        periodicity=?,firstacquidate=?,dow=?,irregularity=?, numberpattern=?, numberlength=?,weeklength=?,monthlength=?,
1376
            startdate=?, periodicity=?, firstacquidate=?, irregularity=?,
1270
                        add1=?,every1=?,whenmorethan1=?,setto1=?,lastvalue1=?,innerloop1=?,
1377
            numberpattern=?, locale=?, numberlength=?, weeklength=?, monthlength=?,
1271
                        add2=?,every2=?,whenmorethan2=?,setto2=?,lastvalue2=?,innerloop2=?,
1378
            lastvalue1=?, innerloop1=?, lastvalue2=?, innerloop2=?,
1272
                        add3=?,every3=?,whenmorethan3=?,setto3=?,lastvalue3=?,innerloop3=?,
1379
            lastvalue3=?, innerloop3=?, status=?, biblionumber=?,
1273
                        numberingmethod=?, status=?, biblionumber=?, callnumber=?, notes=?, 
1380
            callnumber=?, notes=?, letter=?, manualhistory=?,
1274
						letter=?, hemisphere=?,manualhistory=?,internalnotes=?,serialsadditems=?,
1381
            internalnotes=?, serialsadditems=?, staffdisplaycount=?,
1275
						staffdisplaycount = ?,opacdisplaycount = ?, graceperiod = ?, location = ?
1382
            opacdisplaycount=?, graceperiod=?, location = ?, enddate=?,
1276
						,enddate=?
1383
            skip_serialseq=?
1277
                    WHERE subscriptionid = ?";
1384
        WHERE subscriptionid = ?";
1278
1385
1279
    #warn "query :".$query;
1280
    my $sth = $dbh->prepare($query);
1386
    my $sth = $dbh->prepare($query);
1281
    $sth->execute(
1387
    $sth->execute(
1282
        $auser,           $branchcode,     $aqbooksellerid, $cost,
1388
        $auser,           $branchcode,     $aqbooksellerid, $cost,
1283
        $aqbudgetid,      $startdate,      $periodicity,    $firstacquidate,
1389
        $aqbudgetid,      $startdate,      $periodicity,    $firstacquidate,
1284
        $dow,             "$irregularity", $numberpattern,  $numberlength,
1390
        $irregularity,    $numberpattern,  $locale,         $numberlength,
1285
        $weeklength,      $monthlength,    $add1,           $every1,
1391
        $weeklength,      $monthlength,    $lastvalue1,     $innerloop1,
1286
        $whenmorethan1,   $setto1,         $lastvalue1,     $innerloop1,
1392
        $lastvalue2,      $innerloop2,     $lastvalue3,     $innerloop3,
1287
        $add2,            $every2,         $whenmorethan2,  $setto2,
1393
        $status,          $biblionumber,   $callnumber,     $notes,
1288
        $lastvalue2,      $innerloop2,     $add3,           $every3,
1394
        $letter,          ($manualhistory ? $manualhistory : 0),
1289
        $whenmorethan3,   $setto3,         $lastvalue3,     $innerloop3,
1290
        $numberingmethod, $status,         $biblionumber,   $callnumber,
1291
        $notes, $letter, $hemisphere, ( $manualhistory ? $manualhistory : 0 ),
1292
        $internalnotes, $serialsadditems, $staffdisplaycount, $opacdisplaycount,
1395
        $internalnotes, $serialsadditems, $staffdisplaycount, $opacdisplaycount,
1293
        $graceperiod,   $location,        $enddate,           $subscriptionid
1396
        $graceperiod,     $location,       $enddate,        $skip_serialseq,
1397
        $subscriptionid
1294
    );
1398
    );
1295
    my $rows = $sth->rows;
1399
    my $rows = $sth->rows;
1296
1400
Lines 1302-1312 sub ModSubscription { Link Here
1302
1406
1303
$subscriptionid = &NewSubscription($auser,branchcode,$aqbooksellerid,$cost,$aqbudgetid,$biblionumber,
1407
$subscriptionid = &NewSubscription($auser,branchcode,$aqbooksellerid,$cost,$aqbudgetid,$biblionumber,
1304
    $startdate,$periodicity,$dow,$numberlength,$weeklength,$monthlength,
1408
    $startdate,$periodicity,$dow,$numberlength,$weeklength,$monthlength,
1305
    $add1,$every1,$whenmorethan1,$setto1,$lastvalue1,$innerloop1,
1409
    $lastvalue1,$innerloop1,$lastvalue2,$innerloop2,$lastvalue3,$innerloop3,
1306
    $add2,$every2,$whenmorethan2,$setto2,$lastvalue2,$innerloop2,
1410
    $status, $notes, $letter, $firstacquidate, $irregularity, $numberpattern,
1307
    $add3,$every3,$whenmorethan3,$setto3,$lastvalue3,$innerloop3,
1411
    $callnumber, $hemisphere, $manualhistory, $internalnotes, $serialsadditems,
1308
    $numberingmethod, $status, $notes, $serialsadditems,
1412
    $staffdisplaycount, $opacdisplaycount, $graceperiod, $location, $enddate, $skip_serialseq);
1309
    $staffdisplaycount, $opacdisplaycount, $graceperiod, $location, $enddate);
1310
1413
1311
Create a new subscription with value given on input args.
1414
Create a new subscription with value given on input args.
1312
1415
Lines 1316-1357 the id of this new subscription Link Here
1316
=cut
1419
=cut
1317
1420
1318
sub NewSubscription {
1421
sub NewSubscription {
1319
    my ($auser,         $branchcode,      $aqbooksellerid,    $cost,             $aqbudgetid,    $biblionumber, $startdate,       $periodicity,
1422
    my (
1320
        $dow,           $numberlength,    $weeklength,        $monthlength,      $add1,          $every1,       $whenmorethan1,   $setto1,
1423
    $auser, $branchcode, $aqbooksellerid, $cost, $aqbudgetid, $biblionumber,
1321
        $lastvalue1,    $innerloop1,      $add2,              $every2,           $whenmorethan2, $setto2,       $lastvalue2,      $innerloop2,
1424
    $startdate, $periodicity, $numberlength, $weeklength, $monthlength,
1322
        $add3,          $every3,          $whenmorethan3,     $setto3,           $lastvalue3,    $innerloop3,   $numberingmethod, $status,
1425
    $lastvalue1, $innerloop1, $lastvalue2, $innerloop2, $lastvalue3,
1323
        $notes,         $letter,          $firstacquidate,    $irregularity,     $numberpattern, $callnumber,   $hemisphere,      $manualhistory,
1426
    $innerloop3, $status, $notes, $letter, $firstacquidate, $irregularity,
1324
        $internalnotes, $serialsadditems, $staffdisplaycount, $opacdisplaycount, $graceperiod,   $location,     $enddate
1427
    $numberpattern, $locale, $callnumber, $manualhistory, $internalnotes,
1428
    $serialsadditems, $staffdisplaycount, $opacdisplaycount, $graceperiod,
1429
    $location, $enddate, $skip_serialseq
1325
    ) = @_;
1430
    ) = @_;
1326
    my $dbh = C4::Context->dbh;
1431
    my $dbh = C4::Context->dbh;
1327
1432
1328
    #save subscription (insert into database)
1433
    #save subscription (insert into database)
1329
    my $query = qq|
1434
    my $query = qq|
1330
        INSERT INTO subscription
1435
        INSERT INTO subscription
1331
            (librarian,branchcode,aqbooksellerid,cost,aqbudgetid,biblionumber,
1436
            (librarian, branchcode, aqbooksellerid, cost, aqbudgetid,
1332
            startdate,periodicity,dow,numberlength,weeklength,monthlength,
1437
            biblionumber, startdate, periodicity, numberlength, weeklength,
1333
            add1,every1,whenmorethan1,setto1,lastvalue1,innerloop1,
1438
            monthlength, lastvalue1, innerloop1, lastvalue2, innerloop2,
1334
            add2,every2,whenmorethan2,setto2,lastvalue2,innerloop2,
1439
            lastvalue3, innerloop3, status, notes, letter, firstacquidate,
1335
            add3,every3,whenmorethan3,setto3,lastvalue3,innerloop3,
1440
            irregularity, numberpattern, locale, callnumber,
1336
            numberingmethod, status, notes, letter,firstacquidate,irregularity,
1441
            manualhistory, internalnotes, serialsadditems, staffdisplaycount,
1337
            numberpattern, callnumber, hemisphere,manualhistory,internalnotes,serialsadditems,
1442
            opacdisplaycount, graceperiod, location, enddate, skip_serialseq)
1338
            staffdisplaycount,opacdisplaycount,graceperiod,location,enddate)
1443
        VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
1339
        VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
1340
        |;
1444
        |;
1341
    my $sth = $dbh->prepare($query);
1445
    my $sth = $dbh->prepare($query);
1342
    $sth->execute(
1446
    $sth->execute(
1343
        $auser,         $branchcode,      $aqbooksellerid,    $cost,             $aqbudgetid,    $biblionumber, $startdate,       $periodicity,
1447
        $auser, $branchcode, $aqbooksellerid, $cost, $aqbudgetid, $biblionumber,
1344
        $dow,           $numberlength,    $weeklength,        $monthlength,      $add1,          $every1,       $whenmorethan1,   $setto1,
1448
        $startdate, $periodicity, $numberlength, $weeklength,
1345
        $lastvalue1,    $innerloop1,      $add2,              $every2,           $whenmorethan2, $setto2,       $lastvalue2,      $innerloop2,
1449
        $monthlength, $lastvalue1, $innerloop1, $lastvalue2, $innerloop2,
1346
        $add3,          $every3,          $whenmorethan3,     $setto3,           $lastvalue3,    $innerloop3,   $numberingmethod, "$status",
1450
        $lastvalue3, $innerloop3, $status, $notes, $letter,
1347
        $notes,         $letter,          $firstacquidate,    $irregularity,     $numberpattern, $callnumber,   $hemisphere,      $manualhistory,
1451
        $firstacquidate, $irregularity, $numberpattern, $locale, $callnumber,
1348
        $internalnotes, $serialsadditems, $staffdisplaycount, $opacdisplaycount, $graceperiod,   $location,     $enddate
1452
        $manualhistory, $internalnotes, $serialsadditems, $staffdisplaycount,
1453
        $opacdisplaycount, $graceperiod, $location, $enddate, $skip_serialseq
1349
    );
1454
    );
1350
1455
1351
    my $subscriptionid = $dbh->{'mysql_insertid'};
1456
    my $subscriptionid = $dbh->{'mysql_insertid'};
1352
    unless ($enddate){
1457
    unless ($enddate) {
1353
       $enddate = GetExpirationDate($subscriptionid,$startdate);
1458
        $enddate = GetExpirationDate( $subscriptionid, $startdate );
1354
        $query = q|
1459
        $query = qq|
1355
            UPDATE subscription
1460
            UPDATE subscription
1356
            SET    enddate=?
1461
            SET    enddate=?
1357
            WHERE  subscriptionid=?
1462
            WHERE  subscriptionid=?
Lines 1359-1365 sub NewSubscription { Link Here
1359
        $sth = $dbh->prepare($query);
1464
        $sth = $dbh->prepare($query);
1360
        $sth->execute( $enddate, $subscriptionid );
1465
        $sth->execute( $enddate, $subscriptionid );
1361
    }
1466
    }
1362
    #then create the 1st waited number
1467
1468
    # then create the 1st expected number
1363
    $query = qq(
1469
    $query = qq(
1364
        INSERT INTO subscriptionhistory
1470
        INSERT INTO subscriptionhistory
1365
            (biblionumber, subscriptionid, histstartdate,  opacnote, librariannote)
1471
            (biblionumber, subscriptionid, histstartdate,  opacnote, librariannote)
Lines 1372-1377 sub NewSubscription { Link Here
1372
    $query = qq(
1478
    $query = qq(
1373
        SELECT *
1479
        SELECT *
1374
        FROM   subscription
1480
        FROM   subscription
1481
        LEFT JOIN subscription_numberpatterns ON subscription.numberpattern = subscription_numberpatterns.id
1375
        WHERE  subscriptionid = ?
1482
        WHERE  subscriptionid = ?
1376
    );
1483
    );
1377
    $sth = $dbh->prepare($query);
1484
    $sth = $dbh->prepare($query);
Lines 1392-1398 sub NewSubscription { Link Here
1392
1499
1393
    #set serial flag on biblio if not already set.
1500
    #set serial flag on biblio if not already set.
1394
    my $bib = GetBiblio($biblionumber);
1501
    my $bib = GetBiblio($biblionumber);
1395
    if ( !$bib->{'serial'} ) {
1502
    if ( $bib and !$bib->{'serial'} ) {
1396
        my $record = GetMarcBiblio($biblionumber);
1503
        my $record = GetMarcBiblio($biblionumber);
1397
        my ( $tag, $subf ) = GetMarcFromKohaField( 'biblio.serial', $bib->{'frameworkcode'} );
1504
        my ( $tag, $subf ) = GetMarcFromKohaField( 'biblio.serial', $bib->{'frameworkcode'} );
1398
        if ($tag) {
1505
        if ($tag) {
Lines 1710-1716 sub HasSubscriptionExpired { Link Here
1710
    my ($subscriptionid) = @_;
1817
    my ($subscriptionid) = @_;
1711
    my $dbh              = C4::Context->dbh;
1818
    my $dbh              = C4::Context->dbh;
1712
    my $subscription     = GetSubscription($subscriptionid);
1819
    my $subscription     = GetSubscription($subscriptionid);
1713
    if ( ( $subscription->{periodicity} % 16 ) > 0 ) {
1820
    my $frequency = C4::Serials::Frequency::GetSubscriptionFrequency($subscription->{periodicity});
1821
    if ( $frequency and $frequency->{unit} ) {
1714
        my $expirationdate = $subscription->{enddate} || GetExpirationDate($subscriptionid);
1822
        my $expirationdate = $subscription->{enddate} || GetExpirationDate($subscriptionid);
1715
        if (!defined $expirationdate) {
1823
        if (!defined $expirationdate) {
1716
            $expirationdate = q{};
1824
            $expirationdate = q{};
Lines 1734-1739 sub HasSubscriptionExpired { Link Here
1734
            || ( !$res ) );
1842
            || ( !$res ) );
1735
        return 0;
1843
        return 0;
1736
    } else {
1844
    } else {
1845
        # Irregular
1737
        if ( $subscription->{'numberlength'} ) {
1846
        if ( $subscription->{'numberlength'} ) {
1738
            my $countreceived = countissuesfrom( $subscriptionid, $subscription->{'startdate'} );
1847
            my $countreceived = countissuesfrom( $subscriptionid, $subscription->{'startdate'} );
1739
            return 1 if ( $countreceived > $subscription->{'numberlength'} );
1848
            return 1 if ( $countreceived > $subscription->{'numberlength'} );
Lines 2225-2253 sub abouttoexpire { Link Here
2225
    my $dbh              = C4::Context->dbh;
2334
    my $dbh              = C4::Context->dbh;
2226
    my $subscription     = GetSubscription($subscriptionid);
2335
    my $subscription     = GetSubscription($subscriptionid);
2227
    my $per = $subscription->{'periodicity'};
2336
    my $per = $subscription->{'periodicity'};
2228
    if ($per && $per % 16 > 0){
2337
    my $frequency = C4::Serials::Frequency::GetSubscriptionFrequency($per);
2229
        my $expirationdate   = GetExpirationDate($subscriptionid);
2338
    if ($frequency and $frequency->{unit}){
2339
        my $expirationdate = GetExpirationDate($subscriptionid);
2230
        my ($res) = $dbh->selectrow_array('select max(planneddate) from serial where subscriptionid = ?', undef, $subscriptionid);
2340
        my ($res) = $dbh->selectrow_array('select max(planneddate) from serial where subscriptionid = ?', undef, $subscriptionid);
2231
        my @res;
2341
        my $nextdate = GetNextDate($subscription, $res);
2232
        if (defined $res) {
2342
        if(Date::Calc::Delta_Days(
2233
            @res=split (/-/,$res);
2343
            split( /-/, $nextdate ),
2234
            @res=Date::Calc::Today if ($res[0]*$res[1]==0);
2344
            split( /-/, $expirationdate )
2235
        } else { # default an undefined value
2345
        ) <= 0) {
2236
            @res=Date::Calc::Today;
2346
            return 1;
2237
        }
2347
        }
2238
        my @endofsubscriptiondate=split(/-/,$expirationdate);
2239
        my @per_list = (0, 7, 7, 14, 21, 31, 62, 93, 93, 190, 365, 730, 0, 124, 0, 0);
2240
        my @datebeforeend;
2241
        @datebeforeend = Add_Delta_Days(  $endofsubscriptiondate[0],$endofsubscriptiondate[1],$endofsubscriptiondate[2],
2242
            - (3 * $per_list[$per])) if (@endofsubscriptiondate && $endofsubscriptiondate[0]*$endofsubscriptiondate[1]*$endofsubscriptiondate[2]);
2243
        return 1 if ( @res &&
2244
            (@datebeforeend &&
2245
                Delta_Days($res[0],$res[1],$res[2],
2246
                    $datebeforeend[0],$datebeforeend[1],$datebeforeend[2]) <= 0) &&
2247
            (@endofsubscriptiondate &&
2248
                Delta_Days($res[0],$res[1],$res[2],
2249
                    $endofsubscriptiondate[0],$endofsubscriptiondate[1],$endofsubscriptiondate[2]) >= 0) );
2250
        return 0;
2251
    } elsif ($subscription->{numberlength}>0) {
2348
    } elsif ($subscription->{numberlength}>0) {
2252
        return (countissuesfrom($subscriptionid,$subscription->{'startdate'}) >=$subscription->{numberlength}-1);
2349
        return (countissuesfrom($subscriptionid,$subscription->{'startdate'}) >=$subscription->{numberlength}-1);
2253
    }
2350
    }
Lines 2298-2467 sub GetSubscriptionsFromBorrower { Link Here
2298
    return ( $count, @routinglist );
2395
    return ( $count, @routinglist );
2299
}
2396
}
2300
2397
2301
=head2 GetNextDate
2302
2398
2303
$resultdate = GetNextDate($planneddate,$subscription)
2399
=head2 GetFictiveIssueNumber
2304
2400
2305
this function it takes the planneddate and will return the next issue's date and will skip dates if there
2401
$issueno = GetFictiveIssueNumber($subscription, $publishedate);
2306
exists an irregularity
2307
- eg if periodicity is monthly and $planneddate is 2007-02-10 but if March and April is to be 
2308
skipped then the returned date will be 2007-05-10
2309
2310
return :
2311
$resultdate - then next date in the sequence
2312
2402
2313
Return 0 if periodicity==0
2403
Get the position of the issue published at $publisheddate, considering the
2404
first issue (at firstacquidate) is at position 1, the next is at position 2, etc...
2405
This issuenumber doesn't take into account irregularities, so, for instance, if the 3rd
2406
issue is declared as 'irregular' (will be skipped at receipt), the next issue number
2407
will be 4, not 3. It's why it is called 'fictive'. It is NOT a serial seq, and is not
2408
depending on how many rows are in serial table.
2409
The issue number calculation is based on subscription frequency, first acquisition
2410
date, and $publisheddate.
2314
2411
2315
=cut
2412
=cut
2316
2413
2317
sub GetNextDate {
2414
sub GetFictiveIssueNumber {
2318
    my ( $planneddate, $subscription ) = @_;
2415
    my ($subscription, $publisheddate) = @_;
2319
    my @irreg = split( /\,/, $subscription->{irregularity} );
2416
2417
    my $frequency = GetSubscriptionFrequency($subscription->{'periodicity'});
2418
    my $unit = $frequency->{unit} ? lc $frequency->{'unit'} : undef;
2419
    my $issueno = 0;
2420
2421
    if($unit) {
2422
        my ($year, $month, $day) = split /-/, $publisheddate;
2423
        my ($fa_year, $fa_month, $fa_day) = split /-/, $subscription->{'firstacquidate'};
2424
        my $wkno;
2425
        my $delta;
2426
2427
        if($unit eq 'day') {
2428
            $delta = Delta_Days($fa_year, $fa_month, $fa_day, $year, $month, $day);
2429
        } elsif($unit eq 'week') {
2430
            ($wkno, $year) = Week_of_Year($year, $month, $day);
2431
            my ($fa_wkno, $fa_yr) = Week_of_Year($fa_year, $fa_month, $fa_day);
2432
            $delta = ($fa_yr == $year) ? ($wkno - $fa_wkno) : ( ($year-$fa_yr-1)*52 + (52-$fa_wkno+$wkno) );
2433
        } elsif($unit eq 'month') {
2434
            $delta = ($fa_year == $year)
2435
                   ? ($month - $fa_month)
2436
                   : ( ($year-$fa_year-1)*12 + (12-$fa_month+$month) );
2437
        } elsif($unit eq 'year') {
2438
            $delta = $year - $fa_year;
2439
        }
2440
        if($frequency->{'unitsperissue'} == 1) {
2441
            $issueno = $delta * $frequency->{'issuesperunit'} + $subscription->{'countissuesperunit'};
2442
        } else {
2443
            # Assuming issuesperunit == 1
2444
            $issueno = int( ($delta + $frequency->{'unitsperissue'}) / $frequency->{'unitsperissue'} );
2445
        }
2446
    }
2447
    return $issueno;
2448
}
2320
2449
2321
    #date supposed to be in ISO.
2450
=head2 GetNextDate
2322
2451
2323
    my ( $year, $month, $day ) = split( /-/, $planneddate );
2452
$resultdate = GetNextDate($publisheddate,$subscription)
2324
    $month = 1 unless ($month);
2325
    $day   = 1 unless ($day);
2326
    my @resultdate;
2327
2453
2328
    #       warn "DOW $dayofweek";
2454
this function it takes the publisheddate and will return the next issue's date
2329
    if ( $subscription->{periodicity} % 16 == 0 ) {    # 'without regularity' || 'irregular'
2455
and will skip dates if there exists an irregularity.
2330
        return 0;
2456
$publisheddate has to be an ISO date
2331
    }
2457
$subscription is a hashref containing at least 'periodicity', 'firstacquidate', 'irregularity', and 'countissuesperunit'
2458
$updatecount is a boolean value which, when set to true, update the 'countissuesperunit' in database
2459
- eg if periodicity is monthly and $publisheddate is 2007-02-10 but if March and April is to be
2460
skipped then the returned date will be 2007-05-10
2332
2461
2333
    #   daily : n / week
2462
return :
2334
    #   Since we're interpreting irregularity here as which days of the week to skip an issue,
2463
$resultdate - then next date in the sequence (ISO date)
2335
    #   renaming this pattern from 1/day to " n / week ".
2336
    if ( $subscription->{periodicity} == 1 ) {
2337
        my $dayofweek = eval { Day_of_Week( $year, $month, $day ) };
2338
        if ($@) { warn "year month day : $year $month $day $subscription->{subscriptionid} : $@"; }
2339
        else {
2340
            for ( my $i = 0 ; $i < @irreg ; $i++ ) {
2341
                $dayofweek = 0 if ( $dayofweek == 7 );
2342
                if ( in_array( ( $dayofweek + 1 ), @irreg ) ) {
2343
                    ( $year, $month, $day ) = Add_Delta_Days( $year, $month, $day, 1 );
2344
                    $dayofweek++;
2345
                }
2346
            }
2347
            @resultdate = Add_Delta_Days( $year, $month, $day, 1 );
2348
        }
2349
    }
2350
2464
2351
    #   1  week
2465
Return $publisheddate if subscription is irregular
2352
    if ( $subscription->{periodicity} == 2 ) {
2353
        my ( $wkno, $year ) = eval { Week_of_Year( $year, $month, $day ) };
2354
        if ($@) { warn "year month day : $year $month $day $subscription->{subscriptionid} : $@"; }
2355
        else {
2356
            for ( my $i = 0 ; $i < @irreg ; $i++ ) {
2357
2466
2358
                #FIXME: if two consecutive irreg, do we only skip one?
2467
=cut
2359
                if ( $irreg[$i] == ( ( $wkno != 51 ) ? ( $wkno + 1 ) % 52 : 52 ) ) {
2360
                    ( $year, $month, $day ) = Add_Delta_Days( $year, $month, $day, 7 );
2361
                    $wkno = ( ( $wkno != 51 ) ? ( $wkno + 1 ) % 52 : 52 );
2362
                }
2363
            }
2364
            @resultdate = Add_Delta_Days( $year, $month, $day, 7 );
2365
        }
2366
    }
2367
2468
2368
    #   1 / 2 weeks
2469
sub GetNextDate {
2369
    if ( $subscription->{periodicity} == 3 ) {
2470
    my ( $subscription, $publisheddate, $updatecount ) = @_;
2370
        my ( $wkno, $year ) = eval { Week_of_Year( $year, $month, $day ) };
2471
2371
        if ($@) { warn "year month day : $year $month $day $subscription->{subscriptionid} : $@"; }
2472
    my $freqdata = GetSubscriptionFrequency($subscription->{'periodicity'});
2372
        else {
2473
2373
            for ( my $i = 0 ; $i < @irreg ; $i++ ) {
2474
    if ($freqdata->{'unit'}) {
2374
                if ( $irreg[$i] == ( ( $wkno != 50 ) ? ( $wkno + 2 ) % 52 : 52 ) ) {
2475
        my ( $year, $month, $day ) = split /-/, $publisheddate;
2375
                    ### BUGFIX was previously +1 ^
2476
2376
                    ( $year, $month, $day ) = Add_Delta_Days( $year, $month, $day, 14 );
2477
        # Process an irregularity Hash
2377
                    $wkno = ( ( $wkno != 50 ) ? ( $wkno + 2 ) % 52 : 52 );
2478
        # Suppose that irregularities are stored in a string with this structure
2378
                }
2479
        # irreg1;irreg2;irreg3
2379
            }
2480
        # where irregX is the number of issue which will not be received
2380
            @resultdate = Add_Delta_Days( $year, $month, $day, 14 );
2481
        # (the first issue takes the number 1, the 2nd the number 2 and so on)
2482
        my @irreg = split /;/, $subscription->{'irregularity'} ;
2483
        my %irregularities;
2484
        foreach my $irregularity (@irreg) {
2485
            $irregularities{$irregularity} = 1;
2381
        }
2486
        }
2382
    }
2383
2487
2384
    #   1 / 3 weeks
2488
        # Get the 'fictive' next issue number
2385
    if ( $subscription->{periodicity} == 4 ) {
2489
        # It is used to check if next issue is an irregular issue.
2386
        my ( $wkno, $year ) = eval { Week_of_Year( $year, $month, $day ) };
2490
        my $issueno = GetFictiveIssueNumber($subscription, $publisheddate) + 1;
2387
        if ($@) { warn "année mois jour : $year $month $day $subscription->{subscriptionid} : $@"; }
2491
2388
        else {
2492
        # Then get the next date
2389
            for ( my $i = 0 ; $i < @irreg ; $i++ ) {
2493
        my $unit = lc $freqdata->{'unit'};
2390
                if ( $irreg[$i] == ( ( $wkno != 49 ) ? ( $wkno + 3 ) % 52 : 52 ) ) {
2494
        if ($unit eq 'day') {
2391
                    ( $year, $month, $day ) = Add_Delta_Days( $year, $month, $day, 21 );
2495
            while ($irregularities{$issueno}) {
2392
                    $wkno = ( ( $wkno != 49 ) ? ( $wkno + 3 ) % 52 : 52 );
2496
                if ($subscription->{'countissuesperunit'} + 1 > $freqdata->{'issuesperunit'}){
2497
                    ($year,$month,$day) = Add_Delta_Days($year,$month, $day , $freqdata->{'unitsperissue'} );
2498
                    $subscription->{'countissuesperunit'} = 1;
2499
                } else {
2500
                    $subscription->{'countissuesperunit'}++;
2393
                }
2501
                }
2502
                $issueno++;
2503
            }
2504
            if ($subscription->{'countissuesperunit'} + 1 > $freqdata->{'issuesperunit'}){
2505
                ($year,$month,$day) = Add_Delta_Days($year,$month, $day , $freqdata->{"unitsperissue"} );
2506
                $subscription->{'countissuesperunit'} = 1;
2507
            } else {
2508
                $subscription->{'countissuesperunit'}++;
2394
            }
2509
            }
2395
            @resultdate = Add_Delta_Days( $year, $month, $day, 21 );
2396
        }
2510
        }
2397
    }
2511
        elsif ($unit eq 'week') {
2398
    my $tmpmonth = $month;
2512
            my ($wkno, $yr) = Week_of_Year($year, $month, $day);
2399
    if ( $year && $month && $day ) {
2513
            while ($irregularities{$issueno}) {
2400
        if ( $subscription->{periodicity} == 5 ) {
2514
                if ($subscription->{'countissuesperunit'} + 1 > $freqdata->{'issuesperunit'}){
2401
            for ( my $i = 0 ; $i < @irreg ; $i++ ) {
2515
                    $subscription->{'countissuesperunit'} = 1;
2402
                if ( $irreg[$i] == ( ( $tmpmonth != 11 ) ? ( $tmpmonth + 1 ) % 12 : 12 ) ) {
2516
                    $wkno += $freqdata->{"unitsperissue"};
2403
                    ( $year, $month, $day ) = Add_Delta_YMD( $year, $month, $day, 0, 1, 0 );
2517
                    if($wkno > 52){
2404
                    $tmpmonth = ( ( $tmpmonth != 11 ) ? ( $tmpmonth + 1 ) % 12 : 12 );
2518
                        $wkno = $wkno % 52;
2519
                        $yr++;
2520
                    }
2521
                    my $dow = Day_of_Week($year, $month, $day);
2522
                    ($year,$month,$day) = Monday_of_Week($wkno, $yr);
2523
                    if($freqdata->{'issuesperunit'} == 1) {
2524
                        ($year, $month, $day) = Add_Delta_Days($year, $month, $day, $dow - 1);
2525
                    }
2526
                } else {
2527
                    $subscription->{'countissuesperunit'}++;
2405
                }
2528
                }
2529
                $issueno++;
2406
            }
2530
            }
2407
            @resultdate = Add_Delta_YMD( $year, $month, $day, 0, 1, 0 );
2531
            if ($subscription->{'countissuesperunit'} + 1 > $freqdata->{'issuesperunit'}){
2408
        }
2532
                $subscription->{'countissuesperunit'} = 1;
2409
        if ( $subscription->{periodicity} == 6 ) {
2533
                $wkno += $freqdata->{"unitsperissue"};
2410
            for ( my $i = 0 ; $i < @irreg ; $i++ ) {
2534
                if($wkno > 52){
2411
                if ( $irreg[$i] == ( ( $tmpmonth != 10 ) ? ( $tmpmonth + 2 ) % 12 : 12 ) ) {
2535
                    $wkno = $wkno % 52 ;
2412
                    ( $year, $month, $day ) = Add_Delta_YMD( $year, $month, $day, 0, 2, 0 );
2536
                    $yr++;
2413
                    $tmpmonth = ( ( $tmpmonth != 10 ) ? ( $tmpmonth + 2 ) % 12 : 12 );
2414
                }
2537
                }
2538
                my $dow = Day_of_Week($year, $month, $day);
2539
                ($year,$month,$day) = Monday_of_Week($wkno, $yr);
2540
                if($freqdata->{'issuesperunit'} == 1) {
2541
                    ($year, $month, $day) = Add_Delta_Days($year, $month, $day, $dow - 1);
2542
                }
2543
            } else {
2544
                $subscription->{'countissuesperunit'}++;
2415
            }
2545
            }
2416
            @resultdate = Add_Delta_YMD( $year, $month, $day, 0, 2, 0 );
2417
        }
2546
        }
2418
        if ( $subscription->{periodicity} == 7 ) {
2547
        elsif ($unit eq 'month') {
2419
            for ( my $i = 0 ; $i < @irreg ; $i++ ) {
2548
            while ($irregularities{$issueno}) {
2420
                if ( $irreg[$i] == ( ( $tmpmonth != 9 ) ? ( $tmpmonth + 3 ) % 12 : 12 ) ) {
2549
                if ($subscription->{'countissuesperunit'} + 1 > $freqdata->{'issuesperunit'}){
2421
                    ( $year, $month, $day ) = Add_Delta_YMD( $year, $month, $day, 0, 3, 0 );
2550
                    $subscription->{'countissuesperunit'} = 1;
2422
                    $tmpmonth = ( ( $tmpmonth != 9 ) ? ( $tmpmonth + 3 ) % 12 : 12 );
2551
                    ($year,$month,$day) = Add_Delta_YM($year,$month,$day, 0,$freqdata->{"unitsperissue"});
2552
                    unless($freqdata->{'issuesperunit'} == 1) {
2553
                        $day = 1;   # Jumping to the first day of month, because we don't know what day is expected
2554
                    }
2555
                } else {
2556
                    $subscription->{'countissuesperunit'}++;
2423
                }
2557
                }
2558
                $issueno++;
2424
            }
2559
            }
2425
            @resultdate = Add_Delta_YMD( $year, $month, $day, 0, 3, 0 );
2560
            if ($subscription->{'countissuesperunit'} + 1 > $freqdata->{'issuesperunit'}){
2426
        }
2561
                $subscription->{'countissuesperunit'} = 1;
2427
        if ( $subscription->{periodicity} == 8 ) {
2562
                ($year,$month,$day) = Add_Delta_YM($year,$month,$day, 0,$freqdata->{"unitsperissue"});
2428
            for ( my $i = 0 ; $i < @irreg ; $i++ ) {
2563
                unless($freqdata->{'issuesperunit'} == 1) {
2429
                if ( $irreg[$i] == ( ( $tmpmonth != 9 ) ? ( $tmpmonth + 3 ) % 12 : 12 ) ) {
2564
                    $day = 1;   # Jumping to the first day of month, because we don't know what day is expected
2430
                    ( $year, $month, $day ) = Add_Delta_YMD( $year, $month, $day, 0, 3, 0 );
2431
                    $tmpmonth = ( ( $tmpmonth != 9 ) ? ( $tmpmonth + 3 ) % 12 : 12 );
2432
                }
2565
                }
2566
            } else {
2567
                $subscription->{'countissuesperunit'}++;
2433
            }
2568
            }
2434
            @resultdate = Add_Delta_YMD( $year, $month, $day, 0, 3, 0 );
2435
        }
2569
        }
2436
        if ( $subscription->{periodicity} == 13 ) {
2570
        elsif ($unit eq 'year') {
2437
            for ( my $i = 0 ; $i < @irreg ; $i++ ) {
2571
            while ($irregularities{$issueno}) {
2438
                if ( $irreg[$i] == ( ( $tmpmonth != 8 ) ? ( $tmpmonth + 4 ) % 12 : 12 ) ) {
2572
                if ($subscription->{'countissuesperunit'} + 1 > $freqdata->{'issuesperunit'}){
2439
                    ( $year, $month, $day ) = Add_Delta_YMD( $year, $month, $day, 0, 4, 0 );
2573
                    $subscription->{'countissuesperunit'} = 1;
2440
                    $tmpmonth = ( ( $tmpmonth != 8 ) ? ( $tmpmonth + 4 ) % 12 : 12 );
2574
                    ($year,$month,$day) = Add_Delta_YM($year,$month,$day, $freqdata->{"unitsperissue"},0);
2575
                    unless($freqdata->{'issuesperunit'} == 1) {
2576
                        # Jumping to the first day of year, because we don't know what day is expected
2577
                        $month = 1;
2578
                        $day = 1;
2579
                    }
2580
                } else {
2581
                    $subscription->{'countissuesperunit'}++;
2441
                }
2582
                }
2583
                $issueno++;
2442
            }
2584
            }
2443
            @resultdate = Add_Delta_YMD( $year, $month, $day, 0, 4, 0 );
2585
            if ($subscription->{'countissuesperunit'} + 1 > $freqdata->{'issuesperunit'}){
2444
        }
2586
                $subscription->{'countissuesperunit'} = 1;
2445
        if ( $subscription->{periodicity} == 9 ) {
2587
                ($year,$month,$day) = Add_Delta_YM($year,$month,$day, $freqdata->{"unitsperissue"},0);
2446
            for ( my $i = 0 ; $i < @irreg ; $i++ ) {
2588
                unless($freqdata->{'issuesperunit'} == 1) {
2447
                if ( $irreg[$i] == ( ( $tmpmonth != 9 ) ? ( $tmpmonth + 3 ) % 12 : 12 ) ) {
2589
                    # Jumping to the first day of year, because we don't know what day is expected
2448
                    ### BUFIX Seems to need more Than One ?
2590
                    $month = 1;
2449
                    ( $year, $month, $day ) = Add_Delta_YM( $year, $month, $day, 0, 6 );
2591
                    $day = 1;
2450
                    $tmpmonth = ( ( $tmpmonth != 6 ) ? ( $tmpmonth + 6 ) % 12 : 12 );
2451
                }
2592
                }
2593
            } else {
2594
                $subscription->{'countissuesperunit'}++;
2452
            }
2595
            }
2453
            @resultdate = Add_Delta_YM( $year, $month, $day, 0, 6 );
2454
        }
2596
        }
2455
        if ( $subscription->{periodicity} == 10 ) {
2597
        if ($updatecount){
2456
            @resultdate = Add_Delta_YM( $year, $month, $day, 1, 0 );
2598
            my $dbh = C4::Context->dbh;
2457
        }
2599
            my $query = qq{
2458
        if ( $subscription->{periodicity} == 11 ) {
2600
                UPDATE subscription
2459
            @resultdate = Add_Delta_YM( $year, $month, $day, 2, 0 );
2601
                SET countissuesperunit = ?
2602
                WHERE subscriptionid = ?
2603
            };
2604
            my $sth = $dbh->prepare($query);
2605
            $sth->execute($subscription->{'countissuesperunit'}, $subscription->{'subscriptionid'});
2460
        }
2606
        }
2607
        return sprintf("%04d-%02d-%02d", $year, $month, $day);
2461
    }
2608
    }
2462
    my $resultdate = sprintf( "%04d-%02d-%02d", $resultdate[0], $resultdate[1], $resultdate[2] );
2609
    else {
2610
        return $publisheddate;
2611
    }
2612
}
2463
2613
2464
    return "$resultdate";
2614
=head2 _numeration
2615
2616
  $string = &_numeration($value,$num_type,$locale);
2617
2618
_numeration returns the string corresponding to $value in the num_type
2619
num_type can take :
2620
    -dayname
2621
    -monthname
2622
    -season
2623
=cut
2624
2625
#'
2626
2627
sub _numeration {
2628
    my ($value, $num_type, $locale) = @_;
2629
    $value ||= 0;
2630
    my $initlocale = setlocale(LC_TIME);
2631
    if($locale and $locale ne $initlocale) {
2632
        $locale = setlocale(LC_TIME, $locale);
2633
    }
2634
    $locale ||= $initlocale;
2635
    my $string;
2636
    $num_type //= '';
2637
    given ($num_type) {
2638
        when (/^dayname$/) {
2639
              $value = $value % 7;
2640
              $string = POSIX::strftime("%A",0,0,0,0,0,0,$value);
2641
        }
2642
        when (/^monthname$/) {
2643
              $value = $value % 12;
2644
              $string = POSIX::strftime("%B",0,0,0,1,$value,0,0,0,0);
2645
        }
2646
        when (/^season$/) {
2647
              my $seasonlocale = ($locale)
2648
                               ? (substr $locale,0,2)
2649
                               : "en";
2650
              my %seasons=(
2651
                 "en" =>
2652
                    [qw(Spring Summer Fall Winter)],
2653
                 "fr"=>
2654
                    [qw(Printemps Été Automne Hiver)],
2655
              );
2656
              $value = $value % 4;
2657
              $string = ($seasons{$seasonlocale})
2658
                      ? $seasons{$seasonlocale}->[$value]
2659
                      : $seasons{'en'}->[$value];
2660
        }
2661
        default {
2662
            $string = $value;
2663
        }
2664
    }
2665
    if($locale ne $initlocale) {
2666
        setlocale(LC_TIME, $initlocale);
2667
    }
2668
    return $string;
2465
}
2669
}
2466
2670
2467
=head2 is_barcode_in_use
2671
=head2 is_barcode_in_use
(-)a/C4/Serials/Frequency.pm (+285 lines)
Line 0 Link Here
1
package C4::Serials::Frequency;
2
3
# Copyright 2000-2002 Biblibre SARL
4
#
5
# This file is part of Koha.
6
#
7
# Koha is free software; you can redistribute it and/or modify it under the
8
# terms of the GNU General Public License as published by the Free Software
9
# Foundation; either version 2 of the License, or (at your option) any later
10
# version.
11
#
12
# Koha is distributed in the hope that it will be useful, but WITHOUT ANY
13
# WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
14
# A PARTICULAR PURPOSE.  See the GNU General Public License for more details.
15
#
16
# You should have received a copy of the GNU General Public License along
17
# with Koha; if not, write to the Free Software Foundation, Inc.,
18
# 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
19
20
use strict;
21
use warnings;
22
23
use C4::Context;
24
25
use vars qw($VERSION @ISA @EXPORT);
26
27
BEGIN {
28
    # set the version for version checking
29
    $VERSION = 3.01;
30
    require Exporter;
31
    @ISA    = qw(Exporter);
32
    @EXPORT = qw(
33
      &GetSubscriptionFrequencies
34
      &GetSubscriptionFrequency
35
      &AddSubscriptionFrequency
36
      &ModSubscriptionFrequency
37
      &DelSubscriptionFrequency
38
39
      &GetSubscriptionsWithFrequency
40
    );
41
}
42
43
=head3 GetSubscriptionFrequencies
44
45
=over 4
46
47
=item C<@frequencies> = &GetSubscriptionFrequencies();
48
49
gets frequencies restricted on filters
50
51
=back
52
53
=cut
54
55
sub GetSubscriptionFrequencies {
56
    my $dbh = C4::Context->dbh;
57
    my $query = qq{
58
        SELECT *
59
        FROM subscription_frequencies
60
        ORDER BY displayorder
61
    };
62
    my $sth = $dbh->prepare($query);
63
    $sth->execute();
64
65
    my $results = $sth->fetchall_arrayref( {} );
66
    return @$results;
67
}
68
69
=head3 GetSubscriptionFrequency
70
71
=over 4
72
73
=item $frequency = &GetSubscriptionFrequency($frequencyid);
74
75
gets frequency where $frequencyid is the identifier
76
77
=back
78
79
=cut
80
81
sub GetSubscriptionFrequency {
82
    my ($frequencyid) = @_;
83
84
    my $dbh = C4::Context->dbh;
85
    my $query = qq{
86
        SELECT *
87
        FROM subscription_frequencies
88
        WHERE id = ?
89
    };
90
    my $sth = $dbh->prepare($query);
91
    $sth->execute($frequencyid);
92
93
    return $sth->fetchrow_hashref;
94
}
95
96
=head3 AddSubscriptionFrequency
97
98
=over 4
99
100
=item C<$frequencyid> = &AddSubscriptionFrequency($frequency);
101
102
Add a new frequency
103
104
=item C<$frequency> is a hashref that can contains the following keys
105
106
=over 2
107
108
=item * description
109
110
=item * unit
111
112
=item * issuesperunit
113
114
=item * unitsperissue
115
116
=item * expectedissuesayear
117
118
=item * displayorder
119
120
=back
121
122
Only description is mandatory.
123
124
=back
125
126
=cut
127
128
sub AddSubscriptionFrequency {
129
    my $frequency = shift;
130
131
    unless(ref($frequency) eq 'HASH' && defined $frequency->{'description'} && $frequency->{'description'} ne '') {
132
        return undef;
133
    }
134
135
    my @keys;
136
    my @values;
137
    foreach (qw/ description unit issuesperunit unitsperissue expectedissuesayear displayorder /) {
138
        if(exists $frequency->{$_}) {
139
            push @keys, $_;
140
            push @values, $frequency->{$_};
141
        }
142
    }
143
144
    my $dbh = C4::Context->dbh;
145
    my $query = "INSERT INTO subscription_frequencies";
146
    $query .= '(' . join(',', @keys) . ')';
147
    $query .= ' VALUES (' . ('?,' x (scalar(@keys)-1)) . '?)';
148
    my $sth = $dbh->prepare($query);
149
    my $rv = $sth->execute(@values);
150
151
    if(defined $rv) {
152
        return $dbh->last_insert_id(undef, undef, "subscription_frequencies", undef);
153
    }
154
155
    return $rv;
156
}
157
158
=head3 ModSubscriptionFrequency
159
160
=over 4
161
162
=item &ModSubscriptionFrequency($frequency);
163
164
Modifies a frequency
165
166
=item C<$frequency> is a hashref that can contains the following keys
167
168
=over 2
169
170
=item * id
171
172
=item * description
173
174
=item * unit
175
176
=item * issuesperunit
177
178
=item * unitsperissue
179
180
=item * expectedissuesayear
181
182
=item * displayorder
183
184
=back
185
186
Only id is mandatory.
187
188
=back
189
190
=cut
191
192
sub ModSubscriptionFrequency {
193
    my $frequency = shift;
194
195
    unless(
196
      ref($frequency) eq 'HASH'
197
      && defined $frequency->{'id'} && $frequency->{'id'} > 0
198
      && (
199
        (defined $frequency->{'description'}
200
        && $frequency->{'description'} ne '')
201
        || !defined $frequency->{'description'}
202
      )
203
    ) {
204
        return undef;
205
    }
206
207
    my @keys;
208
    my @values;
209
    foreach (qw/ description unit issuesperunit unitsperissue expectedissuesayear displayorder /) {
210
        if(exists $frequency->{$_}) {
211
            push @keys, $_;
212
            push @values, $frequency->{$_};
213
        }
214
    }
215
216
    my $dbh = C4::Context->dbh;
217
    my $query = "UPDATE subscription_frequencies";
218
    $query .= ' SET ' . join(' = ?,', @keys) . ' = ?';
219
    $query .= ' WHERE id = ?';
220
    my $sth = $dbh->prepare($query);
221
222
    return $sth->execute(@values, $frequency->{'id'});
223
}
224
225
=head3 DelSubscriptionFrequency
226
227
=over 4
228
229
=item &DelSubscriptionFrequency($frequencyid);
230
231
Delete a frequency
232
233
=back
234
235
=cut
236
237
sub DelSubscriptionFrequency {
238
    my $frequencyid = shift;
239
240
    my $dbh = C4::Context->dbh;
241
    my $query = qq{
242
        DELETE FROM subscription_frequencies
243
        WHERE id = ?
244
    };
245
    my $sth = $dbh->prepare($query);
246
    $sth->execute($frequencyid);
247
}
248
249
=head3 GetSubscriptionsWithFrequency
250
251
    my @subs = GetSubscriptionsWithFrequency($frequencyid);
252
253
Returns all subscriptions that are using a particular frequency
254
255
=cut
256
257
sub GetSubscriptionsWithFrequency {
258
    my ($frequencyid) = @_;
259
260
    return unless $frequencyid;
261
262
    my $dbh = C4::Context->dbh;
263
    my $query = qq{
264
        SELECT *
265
        FROM subscription
266
          LEFT JOIN biblio ON subscription.biblionumber = biblio.biblionumber
267
        WHERE periodicity = ?
268
    };
269
    my $sth = $dbh->prepare($query);
270
    my @results;
271
    if ($sth->execute($frequencyid)) {
272
        @results = @{ $sth->fetchall_arrayref({}) };
273
    }
274
    return @results;
275
}
276
277
1;
278
279
__END__
280
281
=head1 AUTHOR
282
283
Koha Developement team <info@koha.org>
284
285
=cut
(-)a/C4/Serials/Numberpattern.pm (+294 lines)
Line 0 Link Here
1
package C4::Serials::Numberpattern;
2
3
# Copyright 2000-2002 Biblibre SARL
4
#
5
# This file is part of Koha.
6
#
7
# Koha is free software; you can redistribute it and/or modify it under the
8
# terms of the GNU General Public License as published by the Free Software
9
# Foundation; either version 2 of the License, or (at your option) any later
10
# version.
11
#
12
# Koha is distributed in the hope that it will be useful, but WITHOUT ANY
13
# WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
14
# A PARTICULAR PURPOSE.  See the GNU General Public License for more details.
15
#
16
# You should have received a copy of the GNU General Public License along
17
# with Koha; if not, write to the Free Software Foundation, Inc.,
18
# 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
19
20
use strict;
21
use warnings;
22
23
use C4::Context;
24
25
use vars qw($VERSION @ISA @EXPORT);
26
27
BEGIN {
28
29
    # set the version for version checking
30
    $VERSION = 3.01;
31
    require Exporter;
32
    @ISA    = qw(Exporter);
33
    @EXPORT = qw(
34
        &GetSubscriptionNumberpatterns
35
        &GetSubscriptionNumberpattern
36
        &GetSubscriptionNumberpatternByName
37
        &AddSubscriptionNumberpattern
38
        &ModSubscriptionNumberpattern
39
        &DelSubscriptionNumberpattern
40
41
        &GetSubscriptionsWithNumberpattern
42
    );
43
}
44
45
=head3 GetSubscriptionNumberpatterns
46
47
=over 4
48
49
@results = GetSubscriptionNumberpatterns;
50
this function get all subscription number patterns entered in table
51
52
=back
53
54
=cut
55
56
sub GetSubscriptionNumberpatterns {
57
    my $dbh = C4::Context->dbh;
58
    my $query = qq{
59
        SELECT *
60
        FROM subscription_numberpatterns
61
        ORDER by displayorder
62
    };
63
    my $sth = $dbh->prepare($query);
64
    $sth->execute;
65
    my $results = $sth->fetchall_arrayref({});
66
67
    return @$results;
68
}
69
70
=head3 GetSubscriptionNumberpattern
71
72
=over 4
73
74
$result = GetSubscriptionNumberpattern($numberpatternid);
75
this function get the data of the subscription numberpatterns which id is $numberpatternid
76
77
=back
78
79
=cut
80
81
sub GetSubscriptionNumberpattern {
82
    my $numberpatternid = shift;
83
    my $dbh = C4::Context->dbh;
84
    my $query = qq(
85
        SELECT *
86
        FROM subscription_numberpatterns
87
        WHERE id = ?
88
    );
89
    my $sth = $dbh->prepare($query);
90
    $sth->execute($numberpatternid);
91
92
    return $sth->fetchrow_hashref;
93
}
94
95
=head3 GetSubscriptionNumberpatternByName
96
97
=over 4
98
99
$result = GetSubscriptionNumberpatternByName($name);
100
this function get the data of the subscription numberpatterns which name is $name
101
102
=back
103
104
=cut
105
106
sub GetSubscriptionNumberpatternByName {
107
    my $name = shift;
108
    my $dbh = C4::Context->dbh;
109
    my $query = qq(
110
        SELECT *
111
        FROM subscription_numberpatterns
112
        WHERE label = ?
113
    );
114
    my $sth = $dbh->prepare($query);
115
    my $rv = $sth->execute($name);
116
117
    return $sth->fetchrow_hashref;
118
}
119
120
=head3 AddSubscriptionNumberpattern
121
122
=over 4
123
124
=item C<$numberpatternid> = &AddSubscriptionNumberpattern($numberpattern)
125
126
Add a new numberpattern
127
128
=item C<$frequency> is a hashref that contains values of the number pattern
129
130
=item Only label and numberingmethod are mandatory
131
132
=back
133
134
=cut
135
136
sub AddSubscriptionNumberpattern {
137
    my $numberpattern = shift;
138
139
    unless(
140
      ref($numberpattern) eq 'HASH'
141
      && defined $numberpattern->{'label'}
142
      && $numberpattern->{'label'} ne ''
143
      && defined $numberpattern->{'numberingmethod'}
144
      && $numberpattern->{'numberingmethod'} ne ''
145
    ) {
146
        return undef;
147
    }
148
149
    my @keys;
150
    my @values;
151
    foreach (qw/ label description numberingmethod displayorder
152
      label1 label2 label3 add1 add2 add3 every1 every2 every3
153
      setto1 setto2 setto3 whenmorethan1 whenmorethan2 whenmorethan3
154
      numbering1 numbering2 numbering3 /) {
155
        if(exists $numberpattern->{$_}) {
156
            push @keys, $_;
157
            push @values, $numberpattern->{$_};
158
        }
159
    }
160
161
    my $dbh = C4::Context->dbh;
162
    my $query = "INSERT INTO subscription_numberpatterns";
163
    $query .= '(' . join(',', @keys) . ')';
164
    $query .= ' VALUES (' . ('?,' x (scalar(@keys)-1)) . '?)';
165
    my $sth = $dbh->prepare($query);
166
    my $rv = $sth->execute(@values);
167
168
    if(defined $rv) {
169
        return $dbh->last_insert_id(undef, undef, "subscription_numberpatterns", undef);
170
    }
171
172
    return $rv;
173
}
174
175
=head3 ModSubscriptionNumberpattern
176
177
=over 4
178
179
=item &ModSubscriptionNumberpattern($numberpattern)
180
181
Modifies a numberpattern
182
183
=item C<$frequency> is a hashref that contains values of the number pattern
184
185
=item Only id is mandatory
186
187
=back
188
189
=cut
190
191
sub ModSubscriptionNumberpattern {
192
    my $numberpattern = shift;
193
194
    unless(
195
      ref($numberpattern) eq 'HASH'
196
      && defined $numberpattern->{'id'}
197
      && $numberpattern->{'id'} > 0
198
      && (
199
        (defined $numberpattern->{'label'}
200
        && $numberpattern->{'label'} ne '')
201
        || !defined $numberpattern->{'label'}
202
      )
203
      && (
204
        (defined $numberpattern->{'numberingmethod'}
205
        && $numberpattern->{'numberingmethod'} ne '')
206
        || !defined $numberpattern->{'numberingmethod'}
207
      )
208
    ) {
209
        return undef;
210
    }
211
212
    my @keys;
213
    my @values;
214
    foreach (qw/ label description numberingmethod displayorder
215
      label1 label2 label3 add1 add2 add3 every1 every2 every3
216
      setto1 setto2 setto3 whenmorethan1 whenmorethan2 whenmorethan3
217
      numbering1 numbering2 numbering3 /) {
218
        if(exists $numberpattern->{$_}) {
219
            push @keys, $_;
220
            push @values, $numberpattern->{$_};
221
        }
222
    }
223
224
    my $dbh = C4::Context->dbh;
225
    my $query = "UPDATE subscription_numberpatterns";
226
    $query .= ' SET ' . join(' = ?,', @keys) . ' = ?';
227
    $query .= ' WHERE id = ?';
228
    my $sth = $dbh->prepare($query);
229
230
    return $sth->execute(@values, $numberpattern->{'id'});
231
}
232
233
=head3 DelSubscriptionNumberpattern
234
235
=over 4
236
237
=item &DelSubscriptionNumberpattern($numberpatternid)
238
239
Delete a number pattern
240
241
=back
242
243
=cut
244
245
sub DelSubscriptionNumberpattern {
246
    my $numberpatternid = shift;
247
248
    my $dbh = C4::Context->dbh;
249
    my $query = qq{
250
        DELETE FROM subscription_numberpatterns
251
        WHERE id = ?
252
    };
253
    my $sth = $dbh->prepare($query);
254
    $sth->execute($numberpatternid);
255
}
256
257
=head3 GetSubscriptionsWithNumberpattern
258
259
    my @subs = GetSubscriptionsWithNumberpattern($numberpatternid);
260
261
Returns all subscriptions that are using a particular numbering pattern
262
263
=cut
264
265
sub GetSubscriptionsWithNumberpattern {
266
    my ($numberpatternid) = @_;
267
268
    return unless $numberpatternid;
269
270
    my $dbh = C4::Context->dbh;
271
    my $query = qq{
272
        SELECT *
273
        FROM subscription
274
          LEFT JOIN biblio ON subscription.biblionumber = biblio.biblionumber
275
        WHERE numberpattern = ?
276
    };
277
    my $sth = $dbh->prepare($query);
278
    my @results;
279
    if ($sth->execute($numberpatternid)) {
280
        @results = @{ $sth->fetchall_arrayref({}) };
281
    }
282
    return @results;
283
}
284
285
286
1;
287
288
__END__
289
290
=head1 AUTHOR
291
292
Koha Developement team <info@koha.org>
293
294
=cut
(-)a/installer/data/mysql/de-DE/optional/sample_frequencies.sql (+16 lines)
Line 0 Link Here
1
INSERT INTO subscription_frequencies
2
    (description, unit, unitsperissue, issuesperunit, displayorder)
3
VALUES
4
    ('2/day', 'day', 1, 2, 1),
5
    ('1/day', 'day', 1, 1, 2),
6
    ('3/week', 'week', 1, 3, 3),
7
    ('1/week', 'week', 1, 1, 4),
8
    ('1/2 weeks', 'week', 2, 1, 5),
9
    ('1/3 weeks', 'week', 3, 1, 6),
10
    ('1/month', 'month', 1, 1, 7),
11
    ('1/2 months', 'month', 2, 1, 8),
12
    ('1/3 months', 'month', 3, 1, 9),
13
    ('2/year', 'month', 6, 1, 10),
14
    ('1/year', 'year', 1, 1, 11),
15
    ('1/2 year', 'year', 2, 1, 12),
16
    ('Irregular', NULL, 1, 1, 13);
(-)a/installer/data/mysql/de-DE/optional/sample_frequencies.txt (+1 lines)
Line 0 Link Here
1
Sample frequencies for subscriptions
(-)a/installer/data/mysql/de-DE/optional/sample_numberpatterns.sql (+25 lines)
Line 0 Link Here
1
INSERT INTO subscription_numberpatterns
2
    (label, displayorder, description, numberingmethod,
3
    label1, add1, every1, whenmorethan1, setto1, numbering1,
4
    label2, add2, every2, whenmorethan2, setto2, numbering2,
5
    label3, add3, every3, whenmorethan3, setto3, numbering3)
6
VALUES
7
    ('Number', 1, 'Simple Numbering method', 'No.{X}',
8
    'Number', 1, 1, 99999, 1, NULL,
9
    NULL, NULL, NULL, NULL, NULL, NULL,
10
    NULL, NULL, NULL, NULL, NULL, NULL),
11
12
    ('Volume, Number, Issue', 2, 'Volume Number Issue 1', 'Vol.{X}, Number {Y}, Issue {Z}',
13
    'Volume', 1, 48, 99999, 1, NULL,
14
    'Number', 1, 4, 12, 1, NULL,
15
    'Issue', 1, 1, 4, 1, NULL),
16
17
    ('Volume, Number', 3, 'Volume Number 1', 'Vol {X}, No {Y}',
18
    'Volume', 1, 12, 99999, 1, NULL,
19
    'Number', 1, 1, 12, 1, NULL,
20
    NULL, NULL, NULL, NULL, NULL, NULL),
21
22
    ('Seasonal', 4, 'Season Year', '{X} {Y}',
23
    'Season', 1, 1, 3, 0, 'season',
24
    'Year', 1, 4, 99999, 1, NULL,
25
    NULL, NULL, NULL, NULL, NULL, NULL);
(-)a/installer/data/mysql/de-DE/optional/sample_numberpatterns.txt (+1 lines)
Line 0 Link Here
1
Sample numbering patterns for subscriptions
(-)a/installer/data/mysql/en/optional/sample_frequencies.sql (+16 lines)
Line 0 Link Here
1
INSERT INTO subscription_frequencies
2
    (description, unit, unitsperissue, issuesperunit, displayorder)
3
VALUES
4
    ('2/day', 'day', 1, 2, 1),
5
    ('1/day', 'day', 1, 1, 2),
6
    ('3/week', 'week', 1, 3, 3),
7
    ('1/week', 'week', 1, 1, 4),
8
    ('1/2 weeks', 'week', 2, 1, 5),
9
    ('1/3 weeks', 'week', 3, 1, 6),
10
    ('1/month', 'month', 1, 1, 7),
11
    ('1/2 months', 'month', 2, 1, 8),
12
    ('1/3 months', 'month', 3, 1, 9),
13
    ('2/year', 'month', 6, 1, 10),
14
    ('1/year', 'year', 1, 1, 11),
15
    ('1/2 year', 'year', 2, 1, 12),
16
    ('Irregular', NULL, 1, 1, 13);
(-)a/installer/data/mysql/en/optional/sample_frequencies.txt (+1 lines)
Line 0 Link Here
1
Sample frequencies for subscriptions
(-)a/installer/data/mysql/en/optional/sample_numberpatterns.sql (+25 lines)
Line 0 Link Here
1
INSERT INTO subscription_numberpatterns
2
    (label, displayorder, description, numberingmethod,
3
    label1, add1, every1, whenmorethan1, setto1, numbering1,
4
    label2, add2, every2, whenmorethan2, setto2, numbering2,
5
    label3, add3, every3, whenmorethan3, setto3, numbering3)
6
VALUES
7
    ('Number', 1, 'Simple Numbering method', 'No.{X}',
8
    'Number', 1, 1, 99999, 1, NULL,
9
    NULL, NULL, NULL, NULL, NULL, NULL,
10
    NULL, NULL, NULL, NULL, NULL, NULL),
11
12
    ('Volume, Number, Issue', 2, 'Volume Number Issue 1', 'Vol.{X}, Number {Y}, Issue {Z}',
13
    'Volume', 1, 48, 99999, 1, NULL,
14
    'Number', 1, 4, 12, 1, NULL,
15
    'Issue', 1, 1, 4, 1, NULL),
16
17
    ('Volume, Number', 3, 'Volume Number 1', 'Vol {X}, No {Y}',
18
    'Volume', 1, 12, 99999, 1, NULL,
19
    'Number', 1, 1, 12, 1, NULL,
20
    NULL, NULL, NULL, NULL, NULL, NULL),
21
22
    ('Seasonal', 4, 'Season Year', '{X} {Y}',
23
    'Season', 1, 1, 3, 0, 'season',
24
    'Year', 1, 4, 99999, 1, NULL,
25
    NULL, NULL, NULL, NULL, NULL, NULL);
(-)a/installer/data/mysql/en/optional/sample_numberpatterns.txt (+1 lines)
Line 0 Link Here
1
Sample numbering patterns for subscriptions
(-)a/installer/data/mysql/es-ES/optional/sample_frequencies.sql (+16 lines)
Line 0 Link Here
1
INSERT INTO subscription_frequencies
2
    (description, unit, unitsperissue, issuesperunit, displayorder)
3
VALUES
4
    ('2/day', 'day', 1, 2, 1),
5
    ('1/day', 'day', 1, 1, 2),
6
    ('3/week', 'week', 1, 3, 3),
7
    ('1/week', 'week', 1, 1, 4),
8
    ('1/2 weeks', 'week', 2, 1, 5),
9
    ('1/3 weeks', 'week', 3, 1, 6),
10
    ('1/month', 'month', 1, 1, 7),
11
    ('1/2 months', 'month', 2, 1, 8),
12
    ('1/3 months', 'month', 3, 1, 9),
13
    ('2/year', 'month', 6, 1, 10),
14
    ('1/year', 'year', 1, 1, 11),
15
    ('1/2 year', 'year', 2, 1, 12),
16
    ('Irregular', NULL, 1, 1, 13);
(-)a/installer/data/mysql/es-ES/optional/sample_frequencies.txt (+1 lines)
Line 0 Link Here
1
Sample frequencies for subscriptions
(-)a/installer/data/mysql/es-ES/optional/sample_numberpatterns.sql (+25 lines)
Line 0 Link Here
1
INSERT INTO subscription_numberpatterns
2
    (label, displayorder, description, numberingmethod,
3
    label1, add1, every1, whenmorethan1, setto1, numbering1,
4
    label2, add2, every2, whenmorethan2, setto2, numbering2,
5
    label3, add3, every3, whenmorethan3, setto3, numbering3)
6
VALUES
7
    ('Number', 1, 'Simple Numbering method', 'No.{X}',
8
    'Number', 1, 1, 99999, 1, NULL,
9
    NULL, NULL, NULL, NULL, NULL, NULL,
10
    NULL, NULL, NULL, NULL, NULL, NULL),
11
12
    ('Volume, Number, Issue', 2, 'Volume Number Issue 1', 'Vol.{X}, Number {Y}, Issue {Z}',
13
    'Volume', 1, 48, 99999, 1, NULL,
14
    'Number', 1, 4, 12, 1, NULL,
15
    'Issue', 1, 1, 4, 1, NULL),
16
17
    ('Volume, Number', 3, 'Volume Number 1', 'Vol {X}, No {Y}',
18
    'Volume', 1, 12, 99999, 1, NULL,
19
    'Number', 1, 1, 12, 1, NULL,
20
    NULL, NULL, NULL, NULL, NULL, NULL),
21
22
    ('Seasonal', 4, 'Season Year', '{X} {Y}',
23
    'Season', 1, 1, 3, 0, 'season',
24
    'Year', 1, 4, 99999, 1, NULL,
25
    NULL, NULL, NULL, NULL, NULL, NULL);
(-)a/installer/data/mysql/es-ES/optional/sample_numberpatterns.txt (+1 lines)
Line 0 Link Here
1
Sample numbering patterns for subscriptions
(-)a/installer/data/mysql/fr-FR/2-Optionel/sample_frequencies.sql (+16 lines)
Line 0 Link Here
1
INSERT INTO subscription_frequencies
2
    (description, unit, unitsperissue, issuesperunit, displayorder)
3
VALUES
4
    ('2/day', 'day', 1, 2, 1),
5
    ('1/day', 'day', 1, 1, 2),
6
    ('3/week', 'week', 1, 3, 3),
7
    ('1/week', 'week', 1, 1, 4),
8
    ('1/2 weeks', 'week', 2, 1, 5),
9
    ('1/3 weeks', 'week', 3, 1, 6),
10
    ('1/month', 'month', 1, 1, 7),
11
    ('1/2 months', 'month', 2, 1, 8),
12
    ('1/3 months', 'month', 3, 1, 9),
13
    ('2/year', 'month', 6, 1, 10),
14
    ('1/year', 'year', 1, 1, 11),
15
    ('1/2 year', 'year', 2, 1, 12),
16
    ('Irregular', NULL, 1, 1, 13);
(-)a/installer/data/mysql/fr-FR/2-Optionel/sample_frequencies.txt (+1 lines)
Line 0 Link Here
1
Sample frequencies for subscriptions
(-)a/installer/data/mysql/fr-FR/2-Optionel/sample_numberpatterns.sql (+25 lines)
Line 0 Link Here
1
INSERT INTO subscription_numberpatterns
2
    (label, displayorder, description, numberingmethod,
3
    label1, add1, every1, whenmorethan1, setto1, numbering1,
4
    label2, add2, every2, whenmorethan2, setto2, numbering2,
5
    label3, add3, every3, whenmorethan3, setto3, numbering3)
6
VALUES
7
    ('Number', 1, 'Simple Numbering method', 'No.{X}',
8
    'Number', 1, 1, 99999, 1, NULL,
9
    NULL, NULL, NULL, NULL, NULL, NULL,
10
    NULL, NULL, NULL, NULL, NULL, NULL),
11
12
    ('Volume, Number, Issue', 2, 'Volume Number Issue 1', 'Vol.{X}, Number {Y}, Issue {Z}',
13
    'Volume', 1, 48, 99999, 1, NULL,
14
    'Number', 1, 4, 12, 1, NULL,
15
    'Issue', 1, 1, 4, 1, NULL),
16
17
    ('Volume, Number', 3, 'Volume Number 1', 'Vol {X}, No {Y}',
18
    'Volume', 1, 12, 99999, 1, NULL,
19
    'Number', 1, 1, 12, 1, NULL,
20
    NULL, NULL, NULL, NULL, NULL, NULL),
21
22
    ('Seasonal', 4, 'Season Year', '{X} {Y}',
23
    'Season', 1, 1, 3, 0, 'season',
24
    'Year', 1, 4, 99999, 1, NULL,
25
    NULL, NULL, NULL, NULL, NULL, NULL);
(-)a/installer/data/mysql/fr-FR/2-Optionel/sample_numberpatterns.txt (+1 lines)
Line 0 Link Here
1
Sample numbering patterns for subscriptions
(-)a/installer/data/mysql/it-IT/optional/sample_frequencies.sql (+16 lines)
Line 0 Link Here
1
INSERT INTO subscription_frequencies
2
    (description, unit, unitsperissue, issuesperunit, displayorder)
3
VALUES
4
    ('2/day', 'day', 1, 2, 1),
5
    ('1/day', 'day', 1, 1, 2),
6
    ('3/week', 'week', 1, 3, 3),
7
    ('1/week', 'week', 1, 1, 4),
8
    ('1/2 weeks', 'week', 2, 1, 5),
9
    ('1/3 weeks', 'week', 3, 1, 6),
10
    ('1/month', 'month', 1, 1, 7),
11
    ('1/2 months', 'month', 2, 1, 8),
12
    ('1/3 months', 'month', 3, 1, 9),
13
    ('2/year', 'month', 6, 1, 10),
14
    ('1/year', 'year', 1, 1, 11),
15
    ('1/2 year', 'year', 2, 1, 12),
16
    ('Irregular', NULL, 1, 1, 13);
(-)a/installer/data/mysql/it-IT/optional/sample_frequencies.txt (+1 lines)
Line 0 Link Here
1
Sample frequencies for subscriptions
(-)a/installer/data/mysql/it-IT/optional/sample_numberpatterns.sql (+25 lines)
Line 0 Link Here
1
INSERT INTO subscription_numberpatterns
2
    (label, displayorder, description, numberingmethod,
3
    label1, add1, every1, whenmorethan1, setto1, numbering1,
4
    label2, add2, every2, whenmorethan2, setto2, numbering2,
5
    label3, add3, every3, whenmorethan3, setto3, numbering3)
6
VALUES
7
    ('Number', 1, 'Simple Numbering method', 'No.{X}',
8
    'Number', 1, 1, 99999, 1, NULL,
9
    NULL, NULL, NULL, NULL, NULL, NULL,
10
    NULL, NULL, NULL, NULL, NULL, NULL),
11
12
    ('Volume, Number, Issue', 2, 'Volume Number Issue 1', 'Vol.{X}, Number {Y}, Issue {Z}',
13
    'Volume', 1, 48, 99999, 1, NULL,
14
    'Number', 1, 4, 12, 1, NULL,
15
    'Issue', 1, 1, 4, 1, NULL),
16
17
    ('Volume, Number', 3, 'Volume Number 1', 'Vol {X}, No {Y}',
18
    'Volume', 1, 12, 99999, 1, NULL,
19
    'Number', 1, 1, 12, 1, NULL,
20
    NULL, NULL, NULL, NULL, NULL, NULL),
21
22
    ('Seasonal', 4, 'Season Year', '{X} {Y}',
23
    'Season', 1, 1, 3, 0, 'season',
24
    'Year', 1, 4, 99999, 1, NULL,
25
    NULL, NULL, NULL, NULL, NULL, NULL);
(-)a/installer/data/mysql/it-IT/optional/sample_numberpatterns.txt (+1 lines)
Line 0 Link Here
1
Sample numbering patterns for subscriptions
(-)a/installer/data/mysql/kohastructure.sql (-19 / +55 lines)
Lines 1864-1869 DROP TABLE IF EXISTS `stopwords`; Link Here
1864
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1864
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1865
1865
1866
--
1866
--
1867
-- Table structure for table subscription_frequencies
1868
--
1869
1870
DROP TABLE IF EXISTS subscription_frequencies;
1871
CREATE TABLE subscription_frequencies (
1872
    id INTEGER NOT NULL AUTO_INCREMENT,
1873
    description TEXT NOT NULL,
1874
    displayorder INT DEFAULT NULL,
1875
    unit ENUM('day','week','month','year') DEFAULT NULL,
1876
    unitsperissue INTEGER NOT NULL DEFAULT '1',
1877
    issuesperunit INTEGER NOT NULL DEFAULT '1',
1878
    PRIMARY KEY (id)
1879
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1880
1881
--
1882
-- Table structure for table subscription_numberpatterns
1883
--
1884
1885
DROP TABLE IF EXISTS subscription_numberpatterns;
1886
CREATE TABLE subscription_numberpatterns (
1887
    id INTEGER NOT NULL AUTO_INCREMENT,
1888
    label VARCHAR(255) NOT NULL,
1889
    displayorder INTEGER DEFAULT NULL,
1890
    description TEXT NOT NULL,
1891
    numberingmethod VARCHAR(255) NOT NULL,
1892
    label1 VARCHAR(255) DEFAULT NULL,
1893
    add1 INTEGER DEFAULT NULL,
1894
    every1 INTEGER DEFAULT NULL,
1895
    whenmorethan1 INTEGER DEFAULT NULL,
1896
    setto1 INTEGER DEFAULT NULL,
1897
    numbering1 VARCHAR(255) DEFAULT NULL,
1898
    label2 VARCHAR(255) DEFAULT NULL,
1899
    add2 INTEGER DEFAULT NULL,
1900
    every2 INTEGER DEFAULT NULL,
1901
    whenmorethan2 INTEGER DEFAULT NULL,
1902
    setto2 INTEGER DEFAULT NULL,
1903
    numbering2 VARCHAR(255) DEFAULT NULL,
1904
    label3 VARCHAR(255) DEFAULT NULL,
1905
    add3 INTEGER DEFAULT NULL,
1906
    every3 INTEGER DEFAULT NULL,
1907
    whenmorethan3 INTEGER DEFAULT NULL,
1908
    setto3 INTEGER DEFAULT NULL,
1909
    numbering3 VARCHAR(255) DEFAULT NULL,
1910
    PRIMARY KEY (id)
1911
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1912
1913
--
1867
-- Table structure for table `subscription`
1914
-- Table structure for table `subscription`
1868
--
1915
--
1869
1916
Lines 1880-1919 CREATE TABLE `subscription` ( Link Here
1880
  `monthlength` int(11) default 0,
1927
  `monthlength` int(11) default 0,
1881
  `numberlength` int(11) default 0,
1928
  `numberlength` int(11) default 0,
1882
  `periodicity` tinyint(4) default 0,
1929
  `periodicity` tinyint(4) default 0,
1883
  `dow` varchar(100) default '',
1930
  countissuesperunit INTEGER NOT NULL DEFAULT 1,
1884
  `numberingmethod` varchar(100) default '',
1885
  `notes` mediumtext,
1931
  `notes` mediumtext,
1886
  `status` varchar(100) NOT NULL default '',
1932
  `status` varchar(100) NOT NULL default '',
1887
  `add1` int(11) default 0,
1888
  `every1` int(11) default 0,
1889
  `whenmorethan1` int(11) default 0,
1890
  `setto1` int(11) default NULL,
1891
  `lastvalue1` int(11) default NULL,
1933
  `lastvalue1` int(11) default NULL,
1892
  `add2` int(11) default 0,
1893
  `every2` int(11) default 0,
1894
  `whenmorethan2` int(11) default 0,
1895
  `setto2` int(11) default NULL,
1896
  `lastvalue2` int(11) default NULL,
1897
  `add3` int(11) default 0,
1898
  `every3` int(11) default 0,
1899
  `innerloop1` int(11) default 0,
1934
  `innerloop1` int(11) default 0,
1935
  `lastvalue2` int(11) default NULL,
1900
  `innerloop2` int(11) default 0,
1936
  `innerloop2` int(11) default 0,
1901
  `innerloop3` int(11) default 0,
1902
  `whenmorethan3` int(11) default 0,
1903
  `setto3` int(11) default NULL,
1904
  `lastvalue3` int(11) default NULL,
1937
  `lastvalue3` int(11) default NULL,
1905
  `issuesatonce` tinyint(3) NOT NULL default 1,
1938
  `innerloop3` int(11) default 0,
1906
  `firstacquidate` date default NULL,
1939
  `firstacquidate` date default NULL,
1907
  `manualhistory` tinyint(1) NOT NULL default 0,
1940
  `manualhistory` tinyint(1) NOT NULL default 0,
1908
  `irregularity` text,
1941
  `irregularity` text,
1942
  skip_serialseq BOOLEAN NOT NULL DEFAULT 0,
1909
  `letter` varchar(20) default NULL,
1943
  `letter` varchar(20) default NULL,
1910
  `numberpattern` tinyint(3) default 0,
1944
  `numberpattern` tinyint(3) default 0,
1945
  locale VARCHAR(80) DEFAULT NULL,
1911
  `distributedto` text,
1946
  `distributedto` text,
1912
  `internalnotes` longtext,
1947
  `internalnotes` longtext,
1913
  `callnumber` text,
1948
  `callnumber` text,
1914
  `location` varchar(80) NULL default '',
1949
  `location` varchar(80) NULL default '',
1915
  `branchcode` varchar(10) NOT NULL default '',
1950
  `branchcode` varchar(10) NOT NULL default '',
1916
  `hemisphere` tinyint(3) default 0,
1917
  `lastbranch` varchar(10),
1951
  `lastbranch` varchar(10),
1918
  `serialsadditems` tinyint(1) NOT NULL default '0',
1952
  `serialsadditems` tinyint(1) NOT NULL default '0',
1919
  `staffdisplaycount` VARCHAR(10) NULL,
1953
  `staffdisplaycount` VARCHAR(10) NULL,
Lines 1921-1927 CREATE TABLE `subscription` ( Link Here
1921
  `graceperiod` int(11) NOT NULL default '0',
1955
  `graceperiod` int(11) NOT NULL default '0',
1922
  `enddate` date default NULL,
1956
  `enddate` date default NULL,
1923
  `closed` INT(1) NOT NULL DEFAULT 0,
1957
  `closed` INT(1) NOT NULL DEFAULT 0,
1924
  PRIMARY KEY  (`subscriptionid`)
1958
  PRIMARY KEY  (`subscriptionid`),
1959
  CONSTRAINT subscription_ibfk_1 FOREIGN KEY (periodicity) REFERENCES subscription_frequencies (id) ON DELETE SET NULL ON UPDATE CASCADE,
1960
  CONSTRAINT subscription_ibfk_2 FOREIGN KEY (numberpattern) REFERENCES subscription_numberpatterns (id) ON DELETE SET NULL ON UPDATE CASCADE
1925
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1961
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1926
1962
1927
--
1963
--
(-)a/installer/data/mysql/nb-NO/2-Valgfritt/sample_frequencies.sql (+16 lines)
Line 0 Link Here
1
INSERT INTO subscription_frequencies
2
    (description, unit, unitsperissue, issuesperunit, displayorder)
3
VALUES
4
    ('2/day', 'day', 1, 2, 1),
5
    ('1/day', 'day', 1, 1, 2),
6
    ('3/week', 'week', 1, 3, 3),
7
    ('1/week', 'week', 1, 1, 4),
8
    ('1/2 weeks', 'week', 2, 1, 5),
9
    ('1/3 weeks', 'week', 3, 1, 6),
10
    ('1/month', 'month', 1, 1, 7),
11
    ('1/2 months', 'month', 2, 1, 8),
12
    ('1/3 months', 'month', 3, 1, 9),
13
    ('2/year', 'month', 6, 1, 10),
14
    ('1/year', 'year', 1, 1, 11),
15
    ('1/2 year', 'year', 2, 1, 12),
16
    ('Irregular', NULL, 1, 1, 13);
(-)a/installer/data/mysql/nb-NO/2-Valgfritt/sample_frequencies.txt (+1 lines)
Line 0 Link Here
1
Sample frequencies for subscriptions
(-)a/installer/data/mysql/nb-NO/2-Valgfritt/sample_numberpatterns.sql (+25 lines)
Line 0 Link Here
1
INSERT INTO subscription_numberpatterns
2
    (label, displayorder, description, numberingmethod,
3
    label1, add1, every1, whenmorethan1, setto1, numbering1,
4
    label2, add2, every2, whenmorethan2, setto2, numbering2,
5
    label3, add3, every3, whenmorethan3, setto3, numbering3)
6
VALUES
7
    ('Number', 1, 'Simple Numbering method', 'No.{X}',
8
    'Number', 1, 1, 99999, 1, NULL,
9
    NULL, NULL, NULL, NULL, NULL, NULL,
10
    NULL, NULL, NULL, NULL, NULL, NULL),
11
12
    ('Volume, Number, Issue', 2, 'Volume Number Issue 1', 'Vol.{X}, Number {Y}, Issue {Z}',
13
    'Volume', 1, 48, 99999, 1, NULL,
14
    'Number', 1, 4, 12, 1, NULL,
15
    'Issue', 1, 1, 4, 1, NULL),
16
17
    ('Volume, Number', 3, 'Volume Number 1', 'Vol {X}, No {Y}',
18
    'Volume', 1, 12, 99999, 1, NULL,
19
    'Number', 1, 1, 12, 1, NULL,
20
    NULL, NULL, NULL, NULL, NULL, NULL),
21
22
    ('Seasonal', 4, 'Season Year', '{X} {Y}',
23
    'Season', 1, 1, 3, 0, 'season',
24
    'Year', 1, 4, 99999, 1, NULL,
25
    NULL, NULL, NULL, NULL, NULL, NULL);
(-)a/installer/data/mysql/nb-NO/2-Valgfritt/sample_numberpatterns.txt (+1 lines)
Line 0 Link Here
1
Sample numbering patterns for subscriptions
(-)a/installer/data/mysql/pl-PL/optional/sample_frequencies.sql (+16 lines)
Line 0 Link Here
1
INSERT INTO subscription_frequencies
2
    (description, unit, unitsperissue, issuesperunit, displayorder)
3
VALUES
4
    ('2/day', 'day', 1, 2, 1),
5
    ('1/day', 'day', 1, 1, 2),
6
    ('3/week', 'week', 1, 3, 3),
7
    ('1/week', 'week', 1, 1, 4),
8
    ('1/2 weeks', 'week', 2, 1, 5),
9
    ('1/3 weeks', 'week', 3, 1, 6),
10
    ('1/month', 'month', 1, 1, 7),
11
    ('1/2 months', 'month', 2, 1, 8),
12
    ('1/3 months', 'month', 3, 1, 9),
13
    ('2/year', 'month', 6, 1, 10),
14
    ('1/year', 'year', 1, 1, 11),
15
    ('1/2 year', 'year', 2, 1, 12),
16
    ('Irregular', NULL, 1, 1, 13);
(-)a/installer/data/mysql/pl-PL/optional/sample_frequencies.txt (+1 lines)
Line 0 Link Here
1
Sample frequencies for subscriptions
(-)a/installer/data/mysql/pl-PL/optional/sample_numberpatterns.sql (+25 lines)
Line 0 Link Here
1
INSERT INTO subscription_numberpatterns
2
    (label, displayorder, description, numberingmethod,
3
    label1, add1, every1, whenmorethan1, setto1, numbering1,
4
    label2, add2, every2, whenmorethan2, setto2, numbering2,
5
    label3, add3, every3, whenmorethan3, setto3, numbering3)
6
VALUES
7
    ('Number', 1, 'Simple Numbering method', 'No.{X}',
8
    'Number', 1, 1, 99999, 1, NULL,
9
    NULL, NULL, NULL, NULL, NULL, NULL,
10
    NULL, NULL, NULL, NULL, NULL, NULL),
11
12
    ('Volume, Number, Issue', 2, 'Volume Number Issue 1', 'Vol.{X}, Number {Y}, Issue {Z}',
13
    'Volume', 1, 48, 99999, 1, NULL,
14
    'Number', 1, 4, 12, 1, NULL,
15
    'Issue', 1, 1, 4, 1, NULL),
16
17
    ('Volume, Number', 3, 'Volume Number 1', 'Vol {X}, No {Y}',
18
    'Volume', 1, 12, 99999, 1, NULL,
19
    'Number', 1, 1, 12, 1, NULL,
20
    NULL, NULL, NULL, NULL, NULL, NULL),
21
22
    ('Seasonal', 4, 'Season Year', '{X} {Y}',
23
    'Season', 1, 1, 3, 0, 'season',
24
    'Year', 1, 4, 99999, 1, NULL,
25
    NULL, NULL, NULL, NULL, NULL, NULL);
(-)a/installer/data/mysql/pl-PL/optional/sample_numberpatterns.txt (+1 lines)
Line 0 Link Here
1
Sample numbering patterns for subscriptions
(-)a/installer/data/mysql/ru-RU/optional/sample_frequencies.sql (+16 lines)
Line 0 Link Here
1
INSERT INTO subscription_frequencies
2
    (description, unit, unitsperissue, issuesperunit, displayorder)
3
VALUES
4
    ('2/day', 'day', 1, 2, 1),
5
    ('1/day', 'day', 1, 1, 2),
6
    ('3/week', 'week', 1, 3, 3),
7
    ('1/week', 'week', 1, 1, 4),
8
    ('1/2 weeks', 'week', 2, 1, 5),
9
    ('1/3 weeks', 'week', 3, 1, 6),
10
    ('1/month', 'month', 1, 1, 7),
11
    ('1/2 months', 'month', 2, 1, 8),
12
    ('1/3 months', 'month', 3, 1, 9),
13
    ('2/year', 'month', 6, 1, 10),
14
    ('1/year', 'year', 1, 1, 11),
15
    ('1/2 year', 'year', 2, 1, 12),
16
    ('Irregular', NULL, 1, 1, 13);
(-)a/installer/data/mysql/ru-RU/optional/sample_frequencies.txt (+1 lines)
Line 0 Link Here
1
Sample frequencies for subscriptions
(-)a/installer/data/mysql/ru-RU/optional/sample_numberpatterns.sql (+25 lines)
Line 0 Link Here
1
INSERT INTO subscription_numberpatterns
2
    (label, displayorder, description, numberingmethod,
3
    label1, add1, every1, whenmorethan1, setto1, numbering1,
4
    label2, add2, every2, whenmorethan2, setto2, numbering2,
5
    label3, add3, every3, whenmorethan3, setto3, numbering3)
6
VALUES
7
    ('Number', 1, 'Simple Numbering method', 'No.{X}',
8
    'Number', 1, 1, 99999, 1, NULL,
9
    NULL, NULL, NULL, NULL, NULL, NULL,
10
    NULL, NULL, NULL, NULL, NULL, NULL),
11
12
    ('Volume, Number, Issue', 2, 'Volume Number Issue 1', 'Vol.{X}, Number {Y}, Issue {Z}',
13
    'Volume', 1, 48, 99999, 1, NULL,
14
    'Number', 1, 4, 12, 1, NULL,
15
    'Issue', 1, 1, 4, 1, NULL),
16
17
    ('Volume, Number', 3, 'Volume Number 1', 'Vol {X}, No {Y}',
18
    'Volume', 1, 12, 99999, 1, NULL,
19
    'Number', 1, 1, 12, 1, NULL,
20
    NULL, NULL, NULL, NULL, NULL, NULL),
21
22
    ('Seasonal', 4, 'Season Year', '{X} {Y}',
23
    'Season', 1, 1, 3, 0, 'season',
24
    'Year', 1, 4, 99999, 1, NULL,
25
    NULL, NULL, NULL, NULL, NULL, NULL);
(-)a/installer/data/mysql/ru-RU/optional/sample_numberpatterns.txt (+1 lines)
Line 0 Link Here
1
Sample numbering patterns for subscriptions
(-)a/installer/data/mysql/uk-UA/optional/sample_frequencies.sql (+16 lines)
Line 0 Link Here
1
INSERT INTO subscription_frequencies
2
    (description, unit, unitsperissue, issuesperunit, displayorder)
3
VALUES
4
    ('2/day', 'day', 1, 2, 1),
5
    ('1/day', 'day', 1, 1, 2),
6
    ('3/week', 'week', 1, 3, 3),
7
    ('1/week', 'week', 1, 1, 4),
8
    ('1/2 weeks', 'week', 2, 1, 5),
9
    ('1/3 weeks', 'week', 3, 1, 6),
10
    ('1/month', 'month', 1, 1, 7),
11
    ('1/2 months', 'month', 2, 1, 8),
12
    ('1/3 months', 'month', 3, 1, 9),
13
    ('2/year', 'month', 6, 1, 10),
14
    ('1/year', 'year', 1, 1, 11),
15
    ('1/2 year', 'year', 2, 1, 12),
16
    ('Irregular', NULL, 1, 1, 13);
(-)a/installer/data/mysql/uk-UA/optional/sample_frequencies.txt (+1 lines)
Line 0 Link Here
1
Sample frequencies for subscriptions
(-)a/installer/data/mysql/uk-UA/optional/sample_numberpatterns.sql (+25 lines)
Line 0 Link Here
1
INSERT INTO subscription_numberpatterns
2
    (label, displayorder, description, numberingmethod,
3
    label1, add1, every1, whenmorethan1, setto1, numbering1,
4
    label2, add2, every2, whenmorethan2, setto2, numbering2,
5
    label3, add3, every3, whenmorethan3, setto3, numbering3)
6
VALUES
7
    ('Number', 1, 'Simple Numbering method', 'No.{X}',
8
    'Number', 1, 1, 99999, 1, NULL,
9
    NULL, NULL, NULL, NULL, NULL, NULL,
10
    NULL, NULL, NULL, NULL, NULL, NULL),
11
12
    ('Volume, Number, Issue', 2, 'Volume Number Issue 1', 'Vol.{X}, Number {Y}, Issue {Z}',
13
    'Volume', 1, 48, 99999, 1, NULL,
14
    'Number', 1, 4, 12, 1, NULL,
15
    'Issue', 1, 1, 4, 1, NULL),
16
17
    ('Volume, Number', 3, 'Volume Number 1', 'Vol {X}, No {Y}',
18
    'Volume', 1, 12, 99999, 1, NULL,
19
    'Number', 1, 1, 12, 1, NULL,
20
    NULL, NULL, NULL, NULL, NULL, NULL),
21
22
    ('Seasonal', 4, 'Season Year', '{X} {Y}',
23
    'Season', 1, 1, 3, 0, 'season',
24
    'Year', 1, 4, 99999, 1, NULL,
25
    NULL, NULL, NULL, NULL, NULL, NULL);
(-)a/installer/data/mysql/uk-UA/optional/sample_numberpatterns.txt (+1 lines)
Line 0 Link Here
1
Sample numbering patterns for subscriptions
(-)a/installer/data/mysql/updatedatabase.pl (+221 lines)
Lines 6181-6186 if (C4::Context->preference("Version") < TransformToNum($DBversion)) { Link Here
6181
    SetVersion ($DBversion);
6181
    SetVersion ($DBversion);
6182
}
6182
}
6183
6183
6184
$DBversion = "XXX";
6185
if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) {
6186
    $dbh->do(qq|
6187
        DROP TABLE IF EXISTS subscription_frequencies
6188
    |);
6189
    $dbh->do(qq|
6190
        CREATE TABLE subscription_frequencies (
6191
            id INTEGER NOT NULL AUTO_INCREMENT,
6192
            description TEXT NOT NULL,
6193
            displayorder INT DEFAULT NULL,
6194
            unit ENUM('day','week','month','year') DEFAULT NULL,
6195
            unitsperissue INTEGER NOT NULL DEFAULT '1',
6196
            issuesperunit INTEGER NOT NULL DEFAULT '1',
6197
            PRIMARY KEY (id)
6198
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8
6199
    |);
6200
6201
    $dbh->do(qq|
6202
        DROP TABLE IF EXISTS subscription_numberpatterns
6203
    |);
6204
    $dbh->do(qq|
6205
        CREATE TABLE subscription_numberpatterns (
6206
            id INTEGER NOT NULL AUTO_INCREMENT,
6207
            label VARCHAR(255) NOT NULL,
6208
            displayorder INTEGER DEFAULT NULL,
6209
            description TEXT NOT NULL,
6210
            numberingmethod VARCHAR(255) NOT NULL,
6211
            label1 VARCHAR(255) DEFAULT NULL,
6212
            add1 INTEGER DEFAULT NULL,
6213
            every1 INTEGER DEFAULT NULL,
6214
            whenmorethan1 INTEGER DEFAULT NULL,
6215
            setto1 INTEGER DEFAULT NULL,
6216
            numbering1 VARCHAR(255) DEFAULT NULL,
6217
            label2 VARCHAR(255) DEFAULT NULL,
6218
            add2 INTEGER DEFAULT NULL,
6219
            every2 INTEGER DEFAULT NULL,
6220
            whenmorethan2 INTEGER DEFAULT NULL,
6221
            setto2 INTEGER DEFAULT NULL,
6222
            numbering2 VARCHAR(255) DEFAULT NULL,
6223
            label3 VARCHAR(255) DEFAULT NULL,
6224
            add3 INTEGER DEFAULT NULL,
6225
            every3 INTEGER DEFAULT NULL,
6226
            whenmorethan3 INTEGER DEFAULT NULL,
6227
            setto3 INTEGER DEFAULT NULL,
6228
            numbering3 VARCHAR(255) DEFAULT NULL,
6229
            PRIMARY KEY (id)
6230
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8
6231
    |);
6232
6233
    $dbh->do(qq|
6234
        INSERT INTO subscription_frequencies (description, unit, unitsperissue, issuesperunit, displayorder)
6235
        VALUES
6236
            ('2/day', 'day', 1, 2, 1),
6237
            ('1/day', 'day', 1, 1, 2),
6238
            ('3/week', 'week', 1, 3, 3),
6239
            ('1/week', 'week', 1, 1, 4),
6240
            ('1/2 weeks', 'week', 2, 1, 5),
6241
            ('1/3 weeks', 'week', 3, 1, 6),
6242
            ('1/month', 'month', 1, 1, 7),
6243
            ('1/2 months', 'month', 2, 1, 8),
6244
            ('1/3 months', 'month', 3, 1, 9),
6245
            ('2/year', 'month', 6, 1, 10),
6246
            ('1/year', 'year', 1, 1, 11),
6247
            ('1/2 year', 'year', 2, 1, 12),
6248
            ('Irregular', NULL, 1, 1, 13)
6249
    |);
6250
6251
    # Used to link existing subscription to newly created frequencies
6252
    my $frequencies_mapping = {     # keys are old frequency numbers, values are the new ones
6253
        1 => 2,     # daily (n/week)
6254
        2 => 4,     # 1/week
6255
        3 => 5,     # 1/2 weeks
6256
        4 => 6,     # 1/3 weeks
6257
        5 => 7,     # 1/month
6258
        6 => 8,     # 1/2 months (6/year)
6259
        7 => 9,     # 1/3 months (1/quarter)
6260
        8 => 9,    # 1/quarter (seasonal)
6261
        9 => 10,    # 2/year
6262
        10 => 11,   # 1/year
6263
        11 => 12,   # 1/2 years
6264
        12 => 1,    # 2/day
6265
        16 => 13,   # Without periodicity
6266
        32 => 13,   # Irregular
6267
        48 => 13    # Unknown
6268
    };
6269
6270
    $dbh->do(qq|
6271
        INSERT INTO subscription_numberpatterns
6272
            (label, displayorder, description, numberingmethod,
6273
            label1, add1, every1, whenmorethan1, setto1, numbering1,
6274
            label2, add2, every2, whenmorethan2, setto2, numbering2,
6275
            label3, add3, every3, whenmorethan3, setto3, numbering3)
6276
        VALUES
6277
            ('Number', 1, 'Simple Numbering method', 'No.{X}',
6278
            'Number', 1, 1, 99999, 1, NULL,
6279
            NULL, NULL, NULL, NULL, NULL, NULL,
6280
            NULL, NULL, NULL, NULL, NULL, NULL),
6281
6282
            ('Volume, Number, Issue', 2, 'Volume Number Issue 1', 'Vol.{X}, Number {Y}, Issue {Z}',
6283
            'Volume', 1, 48, 99999, 1, NULL,
6284
            'Number', 1, 4, 12, 1, NULL,
6285
            'Issue', 1, 1, 4, 1, NULL),
6286
6287
            ('Volume, Number', 3, 'Volume Number 1', 'Vol {X}, No {Y}',
6288
            'Volume', 1, 12, 99999, 1, NULL,
6289
            'Number', 1, 1, 12, 1, NULL,
6290
            NULL, NULL, NULL, NULL, NULL, NULL),
6291
6292
            ('Seasonal', 4, 'Season Year', '{X} {Y}',
6293
            'Season', 1, 1, 3, 0, 'season',
6294
            'Year', 1, 4, 99999, 1, NULL,
6295
            NULL, NULL, NULL, NULL, NULL, NULL)
6296
    |);
6297
6298
    $dbh->do(qq|
6299
        ALTER TABLE subscription
6300
        MODIFY COLUMN numberpattern INTEGER DEFAULT NULL,
6301
        MODIFY COLUMN periodicity INTEGER DEFAULT NULL
6302
    |);
6303
6304
    # Update existing subscriptions
6305
6306
    my $query = qq|
6307
        SELECT subscriptionid, periodicity, numberingmethod,
6308
            add1, every1, whenmorethan1, setto1,
6309
            add2, every2, whenmorethan2, setto2,
6310
            add3, every3, whenmorethan3, setto3
6311
        FROM subscription
6312
        ORDER BY subscriptionid
6313
    |;
6314
    my $sth = $dbh->prepare($query);
6315
    $sth->execute;
6316
    my $insert_numberpatterns_sth = $dbh->prepare(qq|
6317
        INSERT INTO subscription_numberpatterns
6318
             (label, displayorder, description, numberingmethod,
6319
            label1, add1, every1, whenmorethan1, setto1, numbering1,
6320
            label2, add2, every2, whenmorethan2, setto2, numbering2,
6321
            label3, add3, every3, whenmorethan3, setto3, numbering3)
6322
        VALUES
6323
            (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
6324
    |);
6325
    my $check_numberpatterns_sth = $dbh->prepare(qq|
6326
        SELECT * FROM subscription_numberpatterns
6327
        WHERE add1 = ? AND add2 = ? AND add3 = ?
6328
          AND every1 = ? AND every2 = ? AND every3 = ?
6329
          AND whenmorethan1 = ? AND whenmorethan2 = ? AND whenmorethan3 = ?
6330
          AND setto1 = ? AND setto2 = ? AND setto3 = ?
6331
          AND numberingmethod = ?
6332
        LIMIT 1
6333
    |);
6334
    my $update_subscription_sth = $dbh->prepare(qq|
6335
        UPDATE subscription
6336
        SET numberpattern = ?,
6337
            periodicity = ?
6338
        WHERE subscriptionid = ?
6339
    |);
6340
6341
    my $i = 1;
6342
    while(my $sub = $sth->fetchrow_hashref) {
6343
        $check_numberpatterns_sth->execute(
6344
            $sub->{add1}, $sub->{add2}, $sub->{add3},
6345
            $sub->{every1}, $sub->{every2}, $sub->{every3},
6346
            $sub->{whenmorethan1}, $sub->{whenmorethan2}, $sub->{whenmorethan3},
6347
            $sub->{setto1}, $sub->{setto2}, $sub->{setto3},
6348
            $sub->{numberingmethod}
6349
        );
6350
        my $p = $check_numberpatterns_sth->fetchrow_hashref;
6351
        if (defined $p) {
6352
            # Pattern already exists, link to it
6353
            $update_subscription_sth->execute($p->{id},
6354
                $frequencies_mapping->{$sub->{periodicity}},
6355
                $sub->{subscriptionid});
6356
        } else {
6357
            # Create a new numbering pattern for this subscription
6358
            my $ok = $insert_numberpatterns_sth->execute(
6359
                "Backup pattern $i", 4+$i, "Automatically created pattern by updatedatabase", $sub->{numberingmethod},
6360
                "X", $sub->{add1}, $sub->{every1}, $sub->{whenmorethan1}, $sub->{setto1}, undef,
6361
                "Y", $sub->{add2}, $sub->{every2}, $sub->{whenmorethan2}, $sub->{setto2}, undef,
6362
                "Z", $sub->{add3}, $sub->{every3}, $sub->{whenmorethan3}, $sub->{setto3}, undef
6363
            );
6364
            if($ok) {
6365
                my $id = $dbh->last_insert_id(undef, undef, 'subscription_numberpatterns', undef);
6366
                # Link to subscription_numberpatterns and subscription_frequencies
6367
                $update_subscription_sth->execute($id,
6368
                    $frequencies_mapping->{$sub->{periodicity}},
6369
                    $sub->{subscriptionid});
6370
            }
6371
            $i++;
6372
        }
6373
    }
6374
6375
    # Remove now useless columns
6376
    $dbh->do(qq|
6377
        ALTER TABLE subscription
6378
        DROP COLUMN numberingmethod,
6379
        DROP COLUMN add1,
6380
        DROP COLUMN every1,
6381
        DROP COLUMN whenmorethan1,
6382
        DROP COLUMN setto1,
6383
        DROP COLUMN add2,
6384
        DROP COLUMN every2,
6385
        DROP COLUMN whenmorethan2,
6386
        DROP COLUMN setto2,
6387
        DROP COLUMN add3,
6388
        DROP COLUMN every3,
6389
        DROP COLUMN whenmorethan3,
6390
        DROP COLUMN setto3,
6391
        DROP COLUMN dow,
6392
        DROP COLUMN issuesatonce,
6393
        DROP COLUMN hemisphere,
6394
        ADD COLUMN countissuesperunit INTEGER NOT NULL DEFAULT 1 AFTER periodicity,
6395
        ADD COLUMN skip_serialseq BOOLEAN NOT NULL DEFAULT 0 AFTER irregularity,
6396
        ADD COLUMN locale VARCHAR(80) DEFAULT NULL AFTER numberpattern,
6397
        ADD CONSTRAINT subscription_ibfk_1 FOREIGN KEY (periodicity) REFERENCES subscription_frequencies (id) ON DELETE SET NULL ON UPDATE CASCADE,
6398
        ADD CONSTRAINT subscription_ibfk_2 FOREIGN KEY (numberpattern) REFERENCES subscription_numberpatterns (id) ON DELETE SET NULL ON UPDATE CASCADE
6399
    |);
6400
6401
    print "Upgrade to $DBversion done (Add subscription_frequencies and subscription_numberpatterns tables)\n";
6402
    SetVersion($DBversion);
6403
}
6404
6184
=head1 FUNCTIONS
6405
=head1 FUNCTIONS
6185
6406
6186
=head2 TableExists($table)
6407
=head2 TableExists($table)
(-)a/koha-tmpl/intranet-tmpl/prog/en/includes/serials-menu.inc (+10 lines)
Lines 20-23 Link Here
20
    [% IF ( CAN_user_serials_check_expiration ) %]
20
    [% IF ( CAN_user_serials_check_expiration ) %]
21
	<li><a href="/cgi-bin/koha/serials/checkexpiration.pl">Check expiration</a></li>
21
	<li><a href="/cgi-bin/koha/serials/checkexpiration.pl">Check expiration</a></li>
22
    [% END %]
22
    [% END %]
23
    <li>
24
        <a href="/cgi-bin/koha/serials/subscription-frequencies.pl">
25
            Manage frequencies
26
        </a>
27
    </li>
28
    <li>
29
        <a href="/cgi-bin/koha/serials/subscription-numberpatterns.pl">
30
            Manage numbering patterns
31
        </a>
32
    </li>
23
</ul>
33
</ul>
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/serials/serials-collection.tt (-58 / +5 lines)
Lines 118-181 $(document).ready(function() { Link Here
118
</tr>
118
</tr>
119
[% FOREACH subscription IN subscriptions %]
119
[% FOREACH subscription IN subscriptions %]
120
    [% UNLESS ( loop.odd ) %]<tr class="highlight">[% ELSE %]<tr>[% END %]
120
    [% UNLESS ( loop.odd ) %]<tr class="highlight">[% ELSE %]<tr>[% END %]
121
      <td><a href="subscription-detail.pl?subscriptionid=[% subscription.subscriptionid %]"># [% subscription.subscriptionid %]</a> </td>
121
        <td><a href="subscription-detail.pl?subscriptionid=[% subscription.subscriptionid %]"># [% subscription.subscriptionid %]</a> </td>
122
      <td>         [% IF ( subscription.periodicity1 ) %]
122
        <td>[% subscription.frequency.description %]</td>
123
                        1/day
123
        <td>[% subscription.numberpattern.label %]</td>
124
                [% END %]
124
        <td> [% subscription.branchcode %]</td>
125
                [% IF ( subscription.periodicity2 ) %]
125
        <td> [% subscription.callnumber %]</td>
126
                        1/week
127
                [% END %]
128
                [% IF ( subscription.periodicity3 ) %]
129
                        1/2 weeks
130
                [% END %]
131
                [% IF ( subscription.periodicity4 ) %]
132
                        1/3 weeks
133
                [% END %]
134
                [% IF ( subscription.periodicity5 ) %]
135
                        1/Month
136
                [% END %]
137
                [% IF ( subscription.periodicity6 ) %]
138
                        1/2 Months (6/year)
139
                [% END %]
140
                [% IF ( subscription.periodicity7 ) %]
141
                        1/quarter
142
                [% END %]
143
                [% IF ( subscription.periodicity8 ) %]
144
                        1/quarter
145
                [% END %]
146
                [% IF ( subscription.periodicity9 ) %]
147
                        2/year
148
                [% END %]
149
                [% IF ( subscription.periodicity10 ) %]
150
                        1/year
151
                [% END %]
152
                [% IF ( subscription.periodicity11 ) %]
153
                        1/2 years
154
                [% END %]</td>
155
           <td>
156
                [% IF ( subscription.numberpattern1 ) %]
157
                    Number
158
                [% END %]
159
                [% IF ( subscription.numberpattern2 ) %]
160
                    Volume, number, issue
161
                [% END %]
162
                [% IF ( subscription.numberpattern3 ) %]
163
                    Volume, number
164
                [% END %]
165
                [% IF ( subscription.numberpattern4 ) %]
166
                    Volume, issue
167
                [% END %]
168
                [% IF ( subscription.numberpattern5 ) %]
169
                    Number, issue
170
                [% END %]
171
                [% IF ( subscription.numberpattern6 ) %]
172
                    Seasonal only
173
                [% END %]
174
                [% IF ( subscription.numberpattern7 ) %]
175
                    None of the above
176
                [% END %]</td>
177
            <td> [% subscription.branchcode %]</td>
178
            <td> [% subscription.callnumber %]</td>
179
        <td> [% subscription.notes %]
126
        <td> [% subscription.notes %]
180
            [% UNLESS subscription.closed %]
127
            [% UNLESS subscription.closed %]
181
                [% IF ( subscription.subscriptionexpired ) %]
128
                [% IF ( subscription.subscriptionexpired ) %]
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/serials/showpredictionpattern.tt (+83 lines)
Line 0 Link Here
1
[% USE KohaDates %]
2
3
<h2>Prediction pattern</h1>
4
[% IF (not_consistent_end_date) %]
5
  <p><em>End date is not consistent with subscription length.</em></p>
6
[% END %]
7
[% IF (ask_for_irregularities) %]
8
    <p><em>Please check issues that are NOT published (irregularities)</em></p>
9
    [% IF (daily_options) %]
10
        <script type="text/javascript">
11
        //<![CDATA[
12
        function Check_boxes(dow) {
13
            if($(":checkbox[data-dow='"+dow+"']:first").attr("checked") == 'checked') {
14
                $("#predictionst :checkbox[data-dow='"+dow+"']").each(function(){
15
                    $(this).attr('checked', true);
16
                });
17
            } else {
18
                $("#predictionst :checkbox[data-dow='"+dow+"']").each(function(){
19
                    $(this).attr('checked', false);
20
                });
21
            }
22
        }
23
        //]]>
24
        </script>
25
        <p><em>
26
            If there is a day (or more) in the week where issues are never
27
            published, you can check corresponding boxes below.
28
        </em></p>
29
        <input type="checkbox" id="monday" data-dow="1" onchange="Check_boxes(1);" />
30
        <label for="monday">Monday</label>
31
        <input type="checkbox" id="tuesday" data-dow="2" onchange="Check_boxes(2);" />
32
        <label for="tuesday">Tuesday</label>
33
        <input type="checkbox" id="wednesday" data-dow="3" onchange="Check_boxes(3);" />
34
        <label for="wednesday">Wednesday</label>
35
        <input type="checkbox" id="thursday" data-dow="4" onchange="Check_boxes(4);" />
36
        <label for="thursday">Thursday</label>
37
        <input type="checkbox" id="friday" data-dow="5" onchange="Check_boxes(5);" />
38
        <label for="friday">Friday</label>
39
        <input type="checkbox" id="saturday" data-dow="6" onchange="Check_boxes(6);" />
40
        <label for="saturday">Saturday</label>
41
        <input type="checkbox" id="sunday" data-dow="7" onchange="Check_boxes(7);" />
42
        <label for="sunday">Sunday</label>
43
    [% END %]
44
[% END %]
45
[% IF (predictions_loop) %]
46
<table id="predictionst">
47
  <thead>
48
    <tr>
49
      <th>Number</th>
50
      <th>Publication Date</th>
51
      [% IF (ask_for_irregularities) %]
52
      <th>Not published</th>
53
      [% END %]
54
    </tr>
55
  </thead>
56
  <tbody>
57
    [% FOREACH prediction IN predictions_loop %]
58
      <tr>
59
        <td>[% prediction.number %]</td>
60
        <td>
61
          [% IF (prediction.publicationdate) %]
62
            [% prediction.publicationdate | $KohaDates %]
63
          [% ELSE %]
64
            unknown
65
          [% END %]
66
        </td>
67
        [% IF (ask_for_irregularities) %]
68
         <td style="text-align:center">
69
         [% UNLESS (loop.first) %]
70
          [% IF (prediction.not_published) %]
71
            <input type="checkbox" name="irregularity" value="[% prediction.issuenumber %]" data-dow="[% prediction.dow %]" checked="checked" />
72
          [% ELSE %]
73
            <input type="checkbox" name="irregularity" value="[% prediction.issuenumber %]" data-dow="[% prediction.dow %]" />
74
          [% END %]
75
         </td>
76
         [% END %]
77
        [% END %]
78
      </tr>
79
    [% END %]
80
  </tbody>
81
</table>
82
[% END %]
83
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/serials/subscription-add.tt (-1278 / +724 lines)
Lines 1-3 Link Here
1
[% USE KohaDates %]
2
1
[% INCLUDE 'doc-head-open.inc' %]
3
[% INCLUDE 'doc-head-open.inc' %]
2
<title>Koha &rsaquo; Serials &rsaquo; [% IF ( modify ) %][% bibliotitle |html %] &rsaquo; Modify subscription[% ELSE %]New subscription[% END %]</title>
4
<title>Koha &rsaquo; Serials &rsaquo; [% IF ( modify ) %][% bibliotitle |html %] &rsaquo; Modify subscription[% ELSE %]New subscription[% END %]</title>
3
[% INCLUDE 'doc-head-close.inc' %]
5
[% INCLUDE 'doc-head-close.inc' %]
Lines 11-963 fieldset.rows li.radio { width: 100%; } /* override staff-global.css */ Link Here
11
<script type="text/javascript">
13
<script type="text/javascript">
12
//<![CDATA[
14
//<![CDATA[
13
15
14
// the english words used in display purposes
16
var globalnumpatterndata;
15
var text = new Array(_("Number"),_("Volume"),_("Issue"),_("Month"),_("Week"),_("Starting with:"),_("Rollover at:"),_("Choose Hemisphere:"),_("Northern"),_("Southern"),
17
var globalfreqdata;
16
_("Autumn"),_("Winter"),_("Spring"),_("Summer"),_("Fall"),_("Season"),_("Year"));
18
var advancedpatternlocked;
17
var weekno_label = _("Week # ");
19
var patternneedtobetested = 0;
18
var is_season = 0;
20
19
var is_hemisphere = 1;
21
function check_issues(){
20
var irregular_issues;   // will hold irregularity object.
22
    if (globalfreqdata.unit.length >0) {
21
23
        if (document.f.subtype.value == globalfreqdata.unit){
22
function formatDate(myDate) {
24
            document.f.issuelengthcount.value=(document.f.sublength.value*globalfreqdata.issuesperunit)/globalfreqdata.unitsperissue;
23
    var d = new Array( myDate.getFullYear(), myDate.getMonth() + 1 ,myDate.getDate());
25
        } else if (document.f.subtype.value != "issues"){
24
    if(d[1].toString().length == 1) { d[1] = '0'+d[1] };
26
            alert(_("Frequency and subscription length provided doesn't combine well. Please consider entering an issue count rather than a time period."));
25
    if(d[2].toString().length == 1) { d[2] = '0'+d[2] };
27
        }
26
    [% IF ( dateformat_us ) %]
27
        return(d[1] + '/' + d[2] + '/' + d[0]) ;
28
    [% ELSIF ( dateformat_metric ) %]
29
        return(d[2] + '/' + d[1] + '/' + d[0]) ;
30
    [% ELSE %]
31
        return(''+d[0] + '-' + d[1] + '-' + d[2]) ;
32
    [% END %]    
33
}
34
35
Date.prototype.addDays = function(days) {
36
    this.setDate(this.getDate()+days);
37
}
38
39
function getWeeksArray(startDate,periodicity) {
40
// returns an array of syspref-formatted dates starting at the first day of startDate's year.
41
// This prediction method will not accurately predict irregularites beyond the first year.
42
// FIXME : Should replace with ajax query to get the first Monday of the year so that week numbers have correct dates.
43
    var incr=1;
44
    if(periodicity==3) {  // 1/2 wks
45
        incr=2;
46
    } else if(periodicity == 4) { // 1/3 wks
47
        incr=3;
48
    }
49
    var weeksArray = new Array;
50
    var jan01 = new Date();
51
    jan01.setDate(1);
52
    jan01.setMonth(0);
53
    jan01.setFullYear(startDate.getFullYear());
54
    for(var i=0;i<52;i++) {
55
        weeksArray[i] = formatDate(jan01) + ' ' + weekno_label + (i + 1);
56
        jan01.addDays( 7 ); 
57
    }
28
    }
58
    return weeksArray;
59
}
29
}
60
30
61
function YMDaToYWDa(S) {
31
function addbiblioPopup(biblionumber) {
62
    with (new Date(Date.UTC(S[0], S[1] - 1, S[2]))) {
32
    var destination = "/cgi-bin/koha/cataloguing/addbiblio.pl?mode=popup";
63
        var DoW = getUTCDay();
33
    if(biblionumber){
64
        setUTCDate(getUTCDate() - (DoW + 6) % 7 + 3);
34
        destination += "&biblionumber="+biblionumber;
65
        var ms = valueOf();
66
        setUTCMonth(0, 4);
67
        var WN = Math.round((ms - valueOf()) / 604800000) + 1;
68
        return [getUTCFullYear(), WN, DoW == 0 ? 7 : DoW];
69
    }
35
    }
36
    window.open(destination,'AddBiblioPopup','width=1024,height=768,toolbar=no,scrollbars=yes');
70
}
37
}
71
function dayofyear(d) { // d is a Date object
72
var yn = d.getFullYear();
73
var mn = d.getMonth();
74
var dn = d.getDate();
75
var d1 = new Date(yn,0,1,12,0,0); // noon on Jan. 1
76
var d2 = new Date(yn,mn,dn,12,0,0); // noon on input date
77
var ddiff = Math.round((d2-d1)/864e5);
78
return ddiff+1;
79
}
80
81
38
82
// create irregularity object.
39
function Plugin(f)
83
function IrregularPattern() {
40
{
84
	this.months = new Array(_("January"),_("February"),_("March"),_("April"),_("May"),_("June"),_("July"),_("August"),_("September"),_("October"),_("November"),_("December"));
41
    window.open('subscription-bib-search.pl','FindABibIndex','width=800,height=400,toolbar=no,scrollbars=yes');
85
	this.seasons = new Array(_("Autumn"),_("Winter"),_("Spring"),_("Summer"),_("Fall"));
86
    this.daynames = new Array(_("Monday"),_("Tuesday"),_("Wednesday"),_("Thursday"),_("Friday"),_("Saturday"),_("Sunday"));
87
    // create weeks irregularity selection array:
88
    this.firstissue = new Date();
89
    this.firstissue.setDate(1);
90
    this.firstissue.setMonth(0);
91
    [% IF ( firstacquiyear ) %] // it's a mod, we already have a start date.
92
        this.firstissue.setFullYear( [% firstacquiyear %] );
93
    [% END %]
94
   	this.weeks = getWeeksArray(this.firstissue); 
95
96
    this.numskipped = 0;
97
    // init:
98
	var irregular = '[% irregularity %]';
99
    this.skipped = irregular.split(',');
100
}
42
}
101
43
102
IrregularPattern.prototype.update = function() {
44
function FindAcqui(f)
103
		this.skipped= new Array;
45
{
104
		var cnt = 0;
46
    window.open('acqui-search.pl','FindASupplier','width=800,height=400,toolbar=no,scrollbars=yes');
105
		// daily periodicity, we interpret irregular array as which days of week to skip.
106
		// else if weekly periodicity, week numbers (starting from 01 Jan) to skip.
107
        // else  irregular array is list of issues to skip
108
		var summary_str = '';
109
		this.numskipped = 0;
110
        if(document.f.irregularity_select) {
111
            //$("#irregularity_select option:selected").each(...); //jquery can combine both conditionals and the for loop
112
            for( var i in document.f.irregularity_select.options ) {
113
                if( document.f.irregularity_select.options[i].selected ) {
114
                    this.skipped[cnt] = document.f.irregularity_select.options[i].value ;
115
                    summary_str += document.f.irregularity_select.options[i].text + "\n" ;
116
				    cnt++;
117
				    this.numskipped++;
118
			    }
119
		    }
120
		    var summary = document.getElementById("irregularity_summary");
121
		    if(summary) {
122
			    summary.value = summary_str;
123
			    summary.rows= ( cnt > 6 ) ? cnt : 6 ; // textarea will bre resized, but not more than 6 lines will show.
124
		    }
125
        }
126
}
47
}
127
48
128
IrregularPattern.prototype.irregular = function(index) { 
49
function Find_ISSN(f)
129
	for( var i in this.skipped) {
50
{
130
			if( this.skipped[i] == index) {
51
    window.open('issn-search.pl','FindABibIndex','width=800,height=400,toolbar=no,scrollbars=yes');
131
				return true;
132
			}
133
	}
134
	return false;
135
}
52
}
136
53
137
function init_pattern() {
54
function Clear(id) {
138
	irregular_issues = new IrregularPattern();
55
    $("#"+id).val('');
139
}
140
function reset_pattern() {
141
	document.getElementById("numberpattern").value = '';
142
    document.getElementById("irregularity").innerHTML = '';
143
	init_pattern();
144
	reset_num_pattern();
145
}
56
}
146
57
147
// common pre defined number patterns
58
function Check_page1() {
148
function reset_num_pattern() {
59
    if ( $("#aqbooksellerid").val().length == 0) {
149
var patternchoice = document.getElementById("numberpattern").value;
60
        input_box = confirm(_("If you wish to claim late or missing issues you must link this subscription to a vendor. Click OK to ignore or Cancel to return and enter a vendor"));
150
    switch(patternchoice){
61
        if (input_box==false) {
151
    case "2":
62
            return false;
152
        document.f.add1.value=1;
63
        }
153
        document.f.add2.value=1;
64
    }
154
        document.f.add3.value=1;
65
    if ($("#biblionumber").val().length == 0) {
155
        document.f.every1.value=12;
66
        alert(_("You must choose or create a biblio"));
156
        document.f.every2.value=1;
67
        return false;
157
        document.f.every3.value=1;
158
        document.f.whenmorethan1.value=9999999;
159
        document.f.whenmorethan2.value=12;
160
        document.f.whenmorethan3.value=4;
161
        document.f.setto1.value=0;
162
        document.f.setto2.value=1;
163
        document.f.setto3.value=1;
164
        document.f.lastvalue1.value=1;
165
        document.f.lastvalue2.value=1;
166
        document.f.lastvalue3.value=1;
167
        document.f.numberingmethod.value=_("Vol {X}, No {Y}, Issue {Z}");
168
        moreoptions(text[1],text[0],text[2]);
169
        display_table(0); // toggle info box on (1) or off (0)
170
        break;
171
    case "3":
172
        document.f.add1.value=1;
173
        document.f.add2.value=1;
174
        document.f.add3.value='';
175
        document.f.every1.value=12;
176
        document.f.every2.value=1;
177
        document.f.every3.value='';
178
        document.f.whenmorethan1.value=9999999;
179
        document.f.whenmorethan2.value=12;
180
        document.f.whenmorethan3.value='';
181
        document.f.setto1.value=0;
182
        document.f.setto2.value=1;
183
        document.f.setto3.value='';
184
        document.f.lastvalue1.value=1;
185
        document.f.lastvalue2.value=1;
186
        document.f.lastvalue3.value='';
187
        document.f.numberingmethod.value=_("Vol {X}, No {Y}");
188
        moreoptions(text[1],text[0]);
189
        display_table(0);
190
        break;
191
    case "4":
192
        document.f.add1.value=1;
193
        document.f.add2.value=1;
194
        document.f.add3.value='';
195
        document.f.every1.value=12;
196
        document.f.every2.value=1;
197
        document.f.every3.value='';
198
        document.f.whenmorethan1.value=9999999;
199
        document.f.whenmorethan2.value=12;
200
        document.f.whenmorethan3.value='';
201
        document.f.setto1.value=0;
202
        document.f.setto2.value=1;
203
        document.f.setto3.value='';
204
        document.f.lastvalue1.value=1;
205
        document.f.lastvalue2.value=1;
206
        document.f.lastvalue3.value='';
207
        document.f.numberingmethod.value=_("Vol {X}, Issue {Y}");
208
        moreoptions(text[1],text[2]);
209
        display_table(0);
210
        break;
211
    case "5":
212
//        var d = new Date(document.f.firstacquidate.value);
213
//        var smonth = d.getMonth();
214
        document.f.add1.value=1;
215
        document.f.add2.value=1;
216
        document.f.add3.value='';
217
        document.f.every1.value=12;
218
        document.f.every2.value=1;
219
        document.f.every3.value='';
220
        document.f.whenmorethan1.value=9999999;
221
        document.f.whenmorethan2.value=12;
222
        document.f.whenmorethan3.value='';
223
        document.f.setto1.value=0;
224
        document.f.setto2.value=1;
225
        document.f.setto3.value='';
226
        document.f.numberingmethod.value=_("No {X}, Issue {Y}");
227
        moreoptions(text[0],text[2]);
228
        display_table(0);
229
        break;
230
    case "6":
231
        var d = new Date(document.f.firstacquidate.value);
232
        var sYear = d.getFullYear();
233
        moreoptions_seasons(text[15],sYear);
234
        var d = new Date(document.f.firstacquidate.value);
235
        var sYear = d.getFullYear();
236
        document.f.add1.value=1;
237
        document.f.add2.value='1';
238
        document.f.add3.value='';
239
        document.f.every1.value=4;
240
        document.f.every2.value='1';
241
        document.f.every3.value='';
242
        document.f.whenmorethan1.value=9999999;
243
        document.f.whenmorethan2.value='4';
244
        document.f.whenmorethan3.value='';
245
        document.f.setto1.value=0;
246
        document.f.setto2.value='1';
247
        document.f.setto3.value='';
248
        document.f.periodicity.value='8';
249
        document.f.numberingmethod.value=_("{Y} {X}");
250
        moreoptions_seasons(text[15],sYear);
251
        document.f.lastvalue1temp.value=document.f.lastvalue1.value=sYear;
252
        display_table(0);
253
        is_season = 1;
254
        break;
255
    case "7":
256
        display_table(1);
257
        document.getElementById("more_options").innerHTML = '';
258
        document.f.irreg_check.value=1; 
259
        break;
260
    case "8":  // Year/Number
261
        var d = (document.f.firstacquidate.value) ? new Date( document.f.firstacquidate.value) : new Date() ;
262
        var sYear = d.getFullYear();
263
        document.f.add1.value=1;
264
        document.f.add2.value=1;
265
        document.f.add3.value='';
266
        document.f.every1.value=12;
267
        document.f.every2.value=1;
268
        document.f.every3.value='';
269
        document.f.whenmorethan1.value=9999999;
270
        document.f.whenmorethan2.value=12;
271
        document.f.whenmorethan3.value='';
272
        document.f.setto1.value=0;
273
        document.f.setto2.value=1;
274
        document.f.setto3.value='';
275
        document.f.lastvalue1.value=sYear;
276
          switch (document.f.periodicity.value){
277
            case 1:              
278
              var doy = dayofyear(d);
279
              document.f.lastvalue2.value=doy; 
280
              document.f.whenmorethan2.value=365; 
281
              break;      
282
            case 12:     
283
              var doy = dayofyear(d);
284
              document.f.lastvalue2.value=doy*2; 
285
              document.f.whenmorethan2.value=730; 
286
              break;      
287
            case 2:
288
            case 3:
289
            case 4:
290
              var YWDa = YMDaToYWDa(d);
291
              document.f.lastvalue2.value=YWDA[1]/(document.f.periodicity.value-1); 
292
              break;      
293
            case 5:
294
              var smonth = d.getMonth();
295
              document.f.lastvalue2.value=smonth;
296
              break;      
297
            case 6:
298
              var smonth = d.getMonth();
299
              document.f.lastvalue2.value=smonth/2;
300
              document.f.whenmorethan2.value=6;
301
              break;      
302
            case 7:
303
            case 8:      
304
              var smonth = d.getMonth();
305
              document.f.lastvalue2.value=smonth/3;
306
              document.f.whenmorethan2.value=4;
307
              break;      
308
            case 9:                        
309
              var smonth = d.getMonth();
310
              document.f.lastvalue2.value=smonth/6;
311
              document.f.whenmorethan2.value=2;
312
              break;      
313
            default:
314
          } 
315
        document.f.lastvalue3.value='';
316
        document.f.numberingmethod.value=_("{X} / {Y}");
317
        moreoptions(text[16],text[0]);
318
     //   document.f.lastvalue1temp.value=sYear;
319
     //   document.f.lastvalue2temp.value=document.f.lastvalue2.value;
320
        display_table(0);
321
        break;
322
    default:
323
        document.f.add1.value=1;
324
        document.f.add2.value='';
325
        document.f.add3.value='';
326
        document.f.every1.value=1;
327
        document.f.every2.value='';
328
        document.f.every3.value='';
329
        document.f.whenmorethan1.value=9999999;
330
        document.f.whenmorethan2.value='';
331
        document.f.whenmorethan3.value='';
332
        document.f.setto1.value=0;
333
        document.f.setto2.value='';
334
        document.f.setto3.value='';
335
        document.f.lastvalue1.value=1;
336
        document.f.lastvalue2.value='';
337
        document.f.lastvalue3.value='';
338
        document.f.numberingmethod.value='{X}';
339
//        moreoptions_daily_check(text[0]);
340
        moreoptions(text[0]);
341
        document.f.irreg_check.value=1;
342
        display_table(0);
343
        break;
344
    }
68
    }
345
}
346
69
347
function display_table(n) {
70
    return true;
348
    if(n==1){
349
        document.getElementById("basetable").style.display = 'block';
350
    } else if(n==0){
351
        document.getElementById("basetable").style.display = 'none';
352
    } else {
353
		var disp_val = ( document.getElementById("basetable").style.display == 'none' ) ? 'block' : 'none' ;
354
			document.getElementById("basetable").style.display = disp_val;
355
	}
356
}
71
}
357
72
358
function set_num_pattern_from_template_vars() {
73
function Check_page2(){
359
	if(!document.getElementById("numberpattern")){ return false; }
74
    [% UNLESS (more_than_one_serial) %]
360
    document.getElementById("numberpattern").value = '[% numberpattern %]';
75
      if($("#acqui_date").val().length == 0){
361
    reset_num_pattern();
76
          alert(_("You must choose a first publication date"));
362
    
77
          return false;
363
    document.f.add1.value='[% add1 %]';
78
      }
364
    document.f.add2.value='[% add2 %]';
365
    document.f.add3.value='[% add3 %]';
366
    document.f.every1.value='[% every1 %]';
367
    document.f.every2.value='[% every2 %]';
368
    document.f.every3.value='[% every3 %]';
369
    document.f.whenmorethan1.value='[% whenmorethan1 %]';
370
    document.f.whenmorethan2.value='[% whenmorethan2 %]';
371
    document.f.whenmorethan3.value='[% whenmorethan3 %]';
372
    document.f.setto1.value='[% setto1 %]';
373
    document.f.setto2.value='[% setto2 %]';
374
    document.f.setto3.value='[% setto3 %]';
375
    document.f.lastvalue1.value='[% lastvalue1 %]';
376
    document.f.lastvalue2.value='[% lastvalue2 %]';
377
    document.f.lastvalue3.value='[% lastvalue3 %]';
378
    document.f.numberingmethod.value='[% numberingmethod %]';
379
380
    var more_strY;
381
    var more_strZ;
382
    [% IF ( add2 ) %]
383
    if([% add2 %] > 0){
384
        more_strY="Y";
385
    }
386
    [% END %]
79
    [% END %]
387
    [% IF ( add3 ) %]
80
    if($("#frequency").val().length == 0){
388
    if([% add3 %] > 0){
81
        alert(_("You must choose a frequency"));
389
        more_strZ="Z";
82
        return false;
390
    }
83
    }
391
    [% END %]
84
    if($("input[name='startdate']").val().length == 0){
392
    document.f.lastvalue1temp.value='[% lastvalue1 %]';
85
        alert(_("You must choose a start date"));
393
    if(more_strY){
86
        return false;
394
        document.f.lastvalue2temp.value='[% lastvalue2 %]';
395
    document.f.whenmorethan2temp.value='[% whenmorethan2 %]';
396
    }
87
    }
397
    if(more_strZ){
88
    if($("#sublength").val().length == 0 && $("input[name='enddate']").val().length == 0){
398
        document.f.lastvalue3temp.value='[% lastvalue3 %]';
89
        alert(_("You must choose a subscription length or an end date."));
399
    document.f.whenmorethan3temp.value='[% whenmorethan3 %]';
90
        return false;
400
    }
91
    }
401
}
92
    if($("#numberpattern").val().length == 0){
402
93
        alert(_("You must choose a numbering pattern"));
403
// a pre check with more options to see if 'number' and '1/day' are chosen
94
        return false;
404
function moreoptions_daily_check(x) {
405
    var periodicity = document.f.periodicity.value;
406
    var errortext='';
407
    if(periodicity == 1){ // i.e. daily
408
        document.getElementById("irregularity").innerHTML = '';
409
        errortext =_("Please indicate which days of the week you DO NOT expect to receive issues.")+"<br \/>";
410
        for(var j=0;j<irregular_issues.daynames.length;j++){
411
            errortext +="<input type='checkbox' name='irregular' id='irregular"+(j+1)+"' value='"+(j+1)+"' />"+irregular_issues.daynames[j]+" &nbsp; ";
412
        }
413
        var error = errortext;
414
        moreoptions(x);
415
        document.getElementById("irregularity").innerHTML = error;
416
    } else {
417
        document.getElementById("irregularity").innerHTML = '';
418
        document.getElementById("more_options").innerHTML = '';
419
        moreoptions(x);
420
    }
95
    }
421
}
96
    if(advancedpatternlocked == 0){
422
97
        alert(_("You have modified the advanced prediction pattern. Please save your work or cancel modifications."));
423
// to dispaly the more options section
98
        return false;
424
function moreoptions(x,y,z){
425
document.getElementById("irregularity").innerHTML = '';
426
document.getElementById("more_options").innerHTML = '';
427
var textbox = '';
428
    // alert("X: "+x+"Y: "+y+"Z: "+z);
429
    if(x){
430
        textbox +="<table id='irregularity_table'>\n<tr><th>&nbsp;<\/th><th>"+x+"<\/th>";
431
        if(y){
432
            textbox +="<th>"+y+"<\/th>";
433
            if(z){
434
                textbox +="<th>"+z+"<\/th>";
435
            }
436
        }
437
        textbox +="<\/tr>\n";
438
        textbox +="<tr><th scope=\"row\">"+text[5]+"<\/td><td><input type='text' name='lastvalue1temp' id='lastvalue1temp' size='4' onkeyup='moreoptionsupdate(this)' value=\"" + document.f.lastvalue1.value +  "\" /><\/td>\n";
439
        if(y){
440
            textbox +="<td><input type=\"text\" name=\"lastvalue2temp\" id=\"lastvalue2temp\" size=\"4\" onkeyup=\"moreoptionsupdate(this)\" value=\"" + document.f.lastvalue2.value + "\" /><\/td>\n";
441
            if(z){
442
                textbox +="<td><input type=\"text\" name=\"lastvalue3temp\" id=\"lastvalue3temp\" size=\"4\" onkeyup=\"moreoptionsupdate(this)\" value=\"" + document.f.lastvalue3.value + "\" /><\/td>\n";
443
            }
444
        }
445
        textbox +="<\/tr>\n";
446
        if(y){
447
            textbox +="<tr><th scope=\"row\">"+text[6]+"<\/th>";
448
            textbox +="<td>&nbsp;<\/td>\n";
449
            textbox +="<td><input type=\"text\" name=\"whenmorethan2temp\" id=\"whenmorethan2temp\" size=\"4\" onkeyup=\"moreoptionsupdate(this,1)\"><\/td>\n";
450
            if(z){
451
                textbox +="<td><input type=\"text\" name=\"whenmorethan3temp\" id=\"whenmorethan3temp\" size=\"4\" onkeyup=\"moreoptionsupdate(this,1)\"><\/td>\n";
452
            }
453
            textbox +="<\/tr>";
454
        } else {
455
          textbox +="<tr> <td>"+_("issues expected")+"<\/td><td><input type=\"text\" name=\"issuesexpected1temp\" id=\"issuesexpected1temp\" size=\"4\" onkeyup=\"moreoptionsupdate(this,0)\" value=\"" + document.f.issuesexpected1.value + "\" ><\/td><\/tr>";
456
        }
457
        textbox +="<\/table>\n";
458
    }
99
    }
459
    document.getElementById("more_options").innerHTML = textbox;
100
    if(patternneedtobetested){
460
}
101
        alert(_("Please click on 'Test prediction pattern' before saving subscription."));
461
102
        return false;
462
function hemispheres(chosen){
463
var selbox = document.getElementById("season1");
464
    if(selbox){
465
    var selboxselected = selbox.options[selbox.selectedIndex].value;
466
    selbox.options.length = 0;
467
468
    if ( (chosen == "1") || ( ! (chosen) && is_hemisphere == 1 )) {
469
        selbox.options[selbox.options.length] = new Option(text[11],'1');
470
        selbox.options[selbox.options.length] = new Option(text[12],'2');
471
        selbox.options[selbox.options.length] = new Option(text[13],'3');
472
        selbox.options[selbox.options.length] = new Option(text[14],'4');
473
        is_hemisphere = 1;
474
        selbox.options[selboxselected-1].selected = true;
475
    }
103
    }
476
104
477
    if ( (chosen == "2") || ( ! (chosen) && is_hemisphere == 2 )) {
105
    return true;
478
        selbox.options[selbox.options.length] = new Option(text[13],'1');
479
        selbox.options[selbox.options.length] = new Option(text[10],'2');
480
        selbox.options[selbox.options.length] = new Option(text[11],'3');
481
        selbox.options[selbox.options.length] = new Option(text[12],'4');
482
        is_hemisphere = 2;
483
        selbox.options[selboxselected-1].selected = true;
484
    }
485
    }
486
}
106
}
487
107
488
// to display the more options section for seasons
108
function frequencyload(){
489
function moreoptions_seasons(x,y){
109
    $.getJSON("subscription-frequency.pl",{"frequency_id":document.f.frequency.value,ajax:'true'},
490
// x = 'Season'.  y = 'Year'.
110
        function(freqdata){
491
document.getElementById("irregularity").innerHTML = '';
111
            globalfreqdata=freqdata;
492
document.getElementById("more_options").innerHTML = '';
112
            if ( globalfreqdata.unit.length == 0 ) {
493
var textbox = '';
113
                var option = $("#subtype option[value='issues']");
494
    //alert("X: "+x+"Year: "+y);
114
                $(option).attr('selected', 'selected');
495
    if(x){
115
                $("#subtype option[value!='issues']").attr('disabled', 'disabled')
496
        var hemi_select = parseInt('[% hemisphere %]');
116
            } else {
497
        textbox +="<li><label for=\"hemisphere\">"+ text[7]  +"<\/label><select name=\"hemisphere\" id=\"hemisphere\" onchange=\"hemispheres(this.options[this.selectedIndex].value)\">";
117
                $("#subtype option").attr('disabled', false)
498
        for(var i = 1; i <= 2; i++){
499
            textbox +="<option value='"+i+"'";
500
            if(i == hemi_select){
501
                textbox += " selected "
502
            }
118
            }
503
            textbox +=">"+text[i+7]+"<\/option>";
504
        }
505
        textbox +="<\/li>\n";
506
        textbox +="<table id=\"seasonal_irregularity\"><tr><th>&nbsp;<\/th><th>"+x+"<\/th>";
507
        textbox +="<th>"+text[16]+"<\/th>";
508
        textbox +="<\/tr>\n";
509
        textbox +="<tr><th scope=\"row\">"+text[5]+"<\/th><td><select name=\"lastvalue2temp\" id=\"lastvalue2temp\" id=\"season1\" onchange=\"moreoptionsupdate(this)\">";
510
        for(var j = 1; j <= 4; j++){
511
            textbox +="<option value='"+j+"'>"+text[j+9]+"<\/option>";
512
        }
119
        }
513
        textbox +="<\/select><\/td>";
120
    )
514
        var isyr = irregular_issues.firstissue;
515
        textbox += "<td>" + irregular_issues.firstissue.getFullYear() + "<\/td><\/tr>\n";
516
        textbox +="<tr><th scope=\"row\">"+text[6]+"<\/th>";
517
        textbox +="<td><input type=\"text\" name=\"whenmorethan2temp\" id=\"whenmorethan2temp\" size=\"4\" onkeyup=\"moreoptionsupdate(this,1)\"><\/td>\n";
518
        textbox +="<\/tr><\/table>\n";
519
    }
520
    document.getElementById("more_options").innerHTML = textbox;
521
}
121
}
522
122
523
function irregularity_check(){
123
function numberpatternload(){
524
    document.f.irreg_check.value = 1; // Irregularity button now pushed
124
    $.getJSON("subscription-numberpattern.pl",{"numberpattern_id":document.f.numbering_pattern.value,ajax:'true'},
525
    var periodicity = document.f.periodicity.value;
125
        function(numpatterndata){
526
	var rollover = document.f.issuesexpected1.value;
126
            globalnumpatterndata=numpatterndata;
527
    if( (document.f.whenmorethan2) && ( document.f.whenmorethan2.value > 0) ){
127
            if (globalnumpatterndata==undefined){
528
      rollover = document.f.whenmorethan2.value;
128
                return false;
529
    }
129
            }
530
    if((document.f.whenmorethan3) && document.f.whenmorethan3.value > 0 ){
130
            displaymoreoptions();
531
        // FIXME: Irregularity check assumes that the full prediction pattern repeats each year.
131
            restoreAdvancedPattern();
532
		//  In cases where the outermost periodicity is > 1 year,  
533
		//  e.g. where a volume spans two years, the irregularity check will be incorrect, 
534
        // but you can safely ignore the check, submit the form, and the prediction pattern should be correct.
535
		//  a way to distinguish between these two cases is needed.
536
		rollover = document.f.whenmorethan3.value * document.f.whenmorethan2.value;
537
    }
538
    var error='';
539
    var toobig;
540
    var expected; 
541
    var errortext = "<b>"+_("Warning irregularity detected")+"</b><br \/>";
542
    switch(periodicity){
543
    case "12":
544
        if(rollover < 730) expected =730;
545
        if(rollover > 730) {
546
            expectedover=730;
547
            toobig=1;
548
        }
549
        break;
550
    case "1":
551
        if(rollover < 365) expected =365;
552
        if(rollover > 365) {
553
            expectedover=365;
554
            toobig=1;
555
        }
556
        break;
557
    case "2":
558
        if(rollover < 52) expected =52;
559
        if(rollover > 52){
560
            expectedover=52;
561
            toobig=1;
562
        }
563
        break;
564
    case "3":
565
        if(rollover < 26) expected =26;
566
        if(rollover > 26){
567
            expectedover=26;
568
            toobig=1;
569
        }
570
        break;
571
    case "4":
572
        if(rollover < 17) expected =17;
573
        if(rollover > 17){
574
            expectedover=17;
575
            toobig=1;
576
        }
577
        break;
578
    case "5":
579
        if(rollover < 12) expected =12;
580
        if(rollover > 12){
581
            expectedover=12;
582
            toobig=1;
583
        }
584
        break;
585
    case "6":
586
        if(rollover < 6) expected =6;
587
        if(rollover > 6){
588
            expectedover=6;
589
            toobig=1;
590
        }
591
        break;
592
    case "7":
593
        if(rollover < 4) expected =4;
594
        if(rollover > 4){
595
            expectedover=4;
596
            toobig=1;
597
        }
598
        break;
599
    case "8":
600
        if(rollover < 4) expected =4;
601
        if(rollover > 4){
602
            expectedover=4;
603
            toobig=1;
604
        }
605
        break;
606
    case "9":
607
        if(rollover < 2) expected =2;
608
        if(rollover > 2){
609
            expectedover=2;
610
            toobig=1;
611
        }
612
        break;
613
    case "10":
614
        if(rollover < 1) expected =1;
615
        if(rollover > 1){
616
            expectedover=1;
617
            toobig=1;
618
        }
132
        }
619
        break;
133
    );
620
    default:
621
        break;
622
    }
623
    if(expected){
624
        if(expected == 365 || expected==730){  // what about leap years ?
625
			// FIXME:  We interpret irregularity as which days per week for periodicity==1.
626
			//  We need two cases: one in which we're published n days/week, in which case irregularity should be per week,
627
			//  and a regular daily pub, where irregularity should be per year.
628
            errortext += _("Please indicate which days of the week you DO NOT expect to receive issues.")+"<br \/>";
629
        } else {
630
            errortext +=expected+_(" issues expected, ")+rollover+_(" were entered.")+"<br \/>"+_("Please indicate which date(s) an issue is not expected")+"<br \/>";
631
            irregular_issues.numskipped = expected - rollover;
632
		}
633
        errortext +="<select multiple id=\"irregularity_select\" name=\"irregularity_select\" onchange=\"irregular_issues.update();\">\n";
634
		errortext +=irregular_options(periodicity);
635
		errortext += "<\/select>\n <textarea rows=\"6\" width=\"18\" id=\"irregularity_summary\" name=\"irregularity_summary\" value=\"foo\"><\/textarea>";
636
        error=errortext;
637
    }
638
    if(toobig){
639
        errortext +=expectedover+_(" issues expected, ")+rollover+_(" were entered")+"<p class=\"warning\">"+_("You seem to have indicated more issues per year than expected.<\/p>");
640
        error=errortext;
641
    }
642
    if(error.length ==0){
643
        error=_("No irregularities noticed");
644
    }
645
	display_example(expected);
646
    document.getElementById("irregularity").innerHTML = error;
647
	irregular_issues.update();
648
}
134
}
649
135
650
function irregular_options(periodicity){
136
function displaymoreoptions() {
651
    var titles;
137
    if(globalnumpatterndata == undefined){
652
    var count;
138
        $("#moreoptionst").hide();
653
    var errortext='';
139
        return false;
654
    var numberpattern = document.getElementById('numberpattern').value;
655
    if(periodicity == 1) {
656
        expected = 7;
657
        titles = irregular_issues.daynames;
658
        count = 1;
659
    }
140
    }
660
    if(periodicity == 2 || periodicity == 3 || periodicity == 4) { 
141
661
        titles = irregular_issues.weeks;
142
    var X = 0, Y = 0, Z = 0;
662
		count = 1;
143
    var numberingmethod = unescape(globalnumpatterndata.numberingmethod);
663
        if(periodicity==3) {  // 1/2 wks
144
    if(numberingmethod.match(/{X}/)) X = 1;
664
            expected = 26;
145
    if(numberingmethod.match(/{Y}/)) Y = 1;
665
        } else if(periodicity == 4) { // 1/3 wks
146
    if(numberingmethod.match(/{Z}/)) Z = 1;
666
            expected = 17;
147
148
    if(X || Y || Z) {
149
        $("#moreoptionst").show();
150
    } else {
151
        $("#moreoptionst").hide();
152
    }
153
154
    if(X) {
155
        if(globalnumpatterndata.label1) {
156
            $("#headerX").html(unescape(globalnumpatterndata.label1));
667
        } else {
157
        } else {
668
            expected = 52;
158
            $("#headerX").html("X");
669
        }
159
        }
160
        $("#headerX").show();
161
        $("#beginsX").show();
162
        $("#innerX").show();
163
    } else {
164
        $("#headerX").hide();
165
        $("#beginsX").hide();
166
        $("#innerX").hide();
167
        $("#lastvaluetemp1").val('');
168
        $("#innerlooptemp1").val('');
670
    }
169
    }
671
    if(periodicity == 5 || periodicity == 6 || periodicity == 7 || periodicity == 8 || periodicity == 9) {
170
    if(Y) {
672
        if(periodicity == 8 && numberpattern==8) {
171
        if(globalnumpatterndata.label2) {
673
            is_season = 1; // setting up from edit page
172
            $("#headerY").html(unescape(globalnumpatterndata.label2));
674
        } 
675
        if(is_season){
676
            titles = irregular_issues.seasons;
677
            expected = 4;
678
            if(is_hemisphere == 2){
679
                count = 2;
680
            } else {
681
                count = 1;
682
            }
683
        } else {
173
        } else {
684
            titles = irregular_issues.months;
174
            $("#headerY").html("Y");
685
            expected = 12;
686
            count = 1;
687
        }
175
        }
176
        $("#headerY").show();
177
        $("#beginsY").show();
178
        $("#innerY").show();
179
    } else {
180
        $("#headerY").hide();
181
        $("#beginsY").hide();
182
        $("#innerY").hide();
183
        $("#lastvaluetemp2").val('');
184
        $("#innerlooptemp2").val('');
688
    }
185
    }
689
	if( !expected) {
186
    if(Z) {
690
		return '';   // don't know how to deal with irregularity.
187
        if(globalnumpatterndata.label3) {
691
	} 	
188
            $("#headerZ").html(unescape(globalnumpatterndata.label3));
692
    for(var j=0;j<expected;j++){   // rch - changed frrom (1..expected).
189
        } else {
693
        if(isArray(titles)){
190
            $("#headerZ").html("Z");
694
            if(count>expected){
695
                count = count-expected;
696
            }
697
            if(is_season && is_hemisphere == 1){
698
                errortext +="<option value='"+((count*3)-2)+"'>"+titles[j]+"<\/option>\n";
699
// alert("value: "+((count*3)-2)+" title: "+titles[j]);
700
            } else if(is_season && is_hemisphere == 2){
701
                errortext +="<option value='"+((count*3)-2)+"'>"+titles[j-1]+"<\/option>\n";
702
// alert("value: "+((count*3)-2)+" title: "+titles[j-1]);
703
            } else {  // all non-seasonal periodicities:
704
                var incr=1; // multiplier for ( 1/n weeks)  patterns; in this case the irreg calc relies on the week# , not the issue#.
705
                if(periodicity==3) {  // 1/2 wks
706
                    incr=2;
707
                } else if(periodicity == 4) { // 1/3 wks
708
                    incr=3;
709
                }
710
                errortext += "<option value='" + (1+j*incr) ;  
711
				if(irregular_issues.irregular(1+incr*j)) {
712
					errortext += "' selected='selected" ;
713
				}
714
				errortext += "'>"+titles[incr*j]+"<\/option>\n";
715
            }
716
            count++;
717
        } else { 
718
            errortext +="<option value='"+j+"'>"+titles+" "+j+"<\/option>\n";
719
        }
191
        }
192
        $("#headerZ").show();
193
        $("#beginsZ").show();
194
        $("#innerZ").show();
195
    } else {
196
        $("#headerZ").hide();
197
        $("#beginsZ").hide();
198
        $("#innerZ").hide();
199
        $("#lastvaluetemp3").val('');
200
        $("#innerlooptemp3").val('');
720
    }
201
    }
721
    return errortext;
722
}
202
}
723
203
204
function toggleAdvancedPattern() {
205
    $("#advancedpredictionpattern").toggle();
206
}
724
207
725
function display_example(expected){
208
function modifyAdvancedPattern() {
726
    var startfrom1 = parseInt(document.f.lastvalue1.value);
209
    $("#patternname").attr("readonly", false).val('');
727
    var startfrom2 = parseInt(document.f.lastvalue2.value);
210
    $("#numberingmethod").attr("readonly", false);
728
    var startfrom3 = parseInt(document.f.lastvalue3.value);
729
    var every1 = parseInt(document.f.every1.value);
730
    var every2 = parseInt(document.f.every2.value);
731
    var every3 = parseInt(document.f.every3.value);
732
    var numberpattern = document.f.numberingmethod.value;
733
    var whenmorethan2 = parseInt(document.f.whenmorethan2.value);
734
    var whenmorethan3 = parseInt(document.f.whenmorethan3.value);
735
    var setto2 = parseInt(document.f.setto2.value);
736
    var setto3 = parseInt(document.f.setto3.value);
737
    var displaytext = _("Based on the information entered, the Numbering Pattern will look like this: ") + "<br \/><ul class=\"numpattern_preview\">";
738
    if(startfrom3>0){
739
        var count=startfrom3-1;
740
        var count2=startfrom2;
741
        for(var i = 0 ; i < 12; i++){
742
            if(count>=whenmorethan3){
743
                count=setto3;
744
                if(count2>=whenmorethan2){
745
                    startfrom1++;
746
                    count2=setto2;
747
                } else {
748
                    count2++;
749
                }
750
            } else {
751
                count++;
752
            }
753
            displaytext += '<li>' + numberpattern.replace(/{Z}/,count) + '<\/li>\n';
754
            displaytext = displaytext.replace(/{Y}/,count2);
755
            displaytext = displaytext.replace(/{X}/,startfrom1);
756
211
757
        }
212
    $("#advancedpredictionpatternt input").each(function() {
758
    }
213
        $(this).attr("readonly", false);
759
    if(startfrom2>0 && !startfrom3){
214
    });
760
        var count=startfrom2-1;
215
    $("#advancedpredictionpatternt select").each(function() {
761
        for(var i=0;i<12;i++){
216
        $(this).attr("disabled", false);
762
            if(count>=whenmorethan2){
217
    });
763
                startfrom1++;
764
                count=setto2;
765
            } else {
766
                count++;
767
            }
768
218
769
            if(is_season){
219
    $("#restoreadvancedpatternbutton").show();
770
                if(is_hemisphere == 2){
220
    $("#saveadvancedpatternbutton").show();
771
                    if(count == 1) {
221
    $("#modifyadvancedpatternbutton").hide();
772
                        displaytext += numberpattern.replace(/{Y}/,text[count+12])+'\n';
222
773
                    } else {
223
    advancedpatternlocked = 0;
774
                        displaytext += numberpattern.replace(/{Y}/,text[count+8])+'\n';
224
}
775
                    }
225
776
                } else {
226
function restoreAdvancedPattern() {
777
                displaytext += numberpattern.replace(/{Y}/,text[count+10])+'\n';
227
    $("#patternname").attr("readonly", true).val(unescape(globalnumpatterndata.label));
778
                }
228
    $("#numberingmethod").attr("readonly", true).val(unescape(globalnumpatterndata.numberingmethod));
779
            } else {
229
780
                displaytext += numberpattern.replace(/{Y}/,count)+'\n';
230
    $("#advancedpredictionpatternt input").each(function() {
781
            }
231
        $(this).attr("readonly", true);
782
            displaytext = displaytext.replace(/{X}/,startfrom1)+'<br \/>\n';
232
        var id = $(this).attr('id');
233
        if(id.match(/lastvalue/) || id.match(/innerloop/)) {
234
            var tempid = id.replace(/(\d)/, "temp$1");
235
            $(this).val($("#"+tempid).val());
236
        } else {
237
            $(this).val(unescape(globalnumpatterndata[id]));
783
        }
238
        }
239
    });
240
    $("#advancedpredictionpatternt select").each(function() {
241
        $(this).attr("disabled", true);
242
        var id = $(this).attr('id');
243
        $(this).val(unescape(globalnumpatterndata[id]));
244
    });
245
246
    $("#restoreadvancedpatternbutton").hide();
247
    $("#saveadvancedpatternbutton").hide();
248
    $("#modifyadvancedpatternbutton").show();
249
250
    advancedpatternlocked = 1;
251
}
252
253
function testPredictionPattern() {
254
    var frequencyid = $("#frequency").val();
255
    var acquidate;
256
    var error = 0;
257
    var error_msg = "";
258
    if(frequencyid == undefined || frequencyid == ""){
259
        error_msg += _("- Frequency is not defined\n");
260
        error ++;
784
    }
261
    }
785
    if(startfrom1>0 && !startfrom2 && !startfrom3){
262
    acquidate = $("#acqui_date").val();
786
        var offset=eval(document.f.issuesexpected1.value);
263
    if(acquidate == undefined || acquidate == ""){
787
        if (!offset){
264
        error_msg += _("- First publication date is not defined\n");
788
            offset = 12 
265
        error ++;
789
        }
790
        for(var i=startfrom1;i<(startfrom1+offset);i+=every1){
791
            displaytext += numberpattern.replace(/{X}/,i)+'<br \/>\n';
792
        }
793
    }
266
    }
794
   //  displaytext = "<div style='padding: 5px; background-color: #CCCCCC'>"+displaytext+"<\/div>";
267
    [% IF (more_than_one_serial) %]
795
    document.getElementById("displayexample").innerHTML = displaytext;
268
      var nextacquidate = $("#nextacquidate").val();
796
}
269
      if(nextacquidate == undefined || nextacquidate == ""){
270
        error_msg += _("- Next issue publication date is not defined\n");
271
        error ++;
272
      }
273
    [% END %]
797
274
798
function isArray(obj) {
275
    if(error){
799
if (obj.constructor.toString().indexOf("Array") == -1)
276
        alert(_("Cannot test prediction pattern for the following reason(s):\n\n")
800
    return false;
277
            + error_msg);
801
else
278
        return false;
802
    return true;
279
    }
803
}
804
280
805
function moreoptionsupdate(inputfield,rollover){
281
    var custompattern = 0;
806
    fieldname = inputfield.name;
282
    if(advancedpatternlocked == 0) {
807
    // find parent element in base table by stripping 'temp' from element name.
283
        custompattern = 1;
808
    basefield = document.getElementById(fieldname.slice(0,-4));
284
    }
809
    var fieldnumber = fieldname.slice(-5,-4);
810
285
811
    basefield.value = inputfield.value;
286
    var ajaxData = {
812
    var patternchoice = document.getElementById("numberpattern").value;
287
        'custompattern': custompattern,
813
    switch(patternchoice){
288
        [% IF (subscriptionid) %]
814
    case "2":
289
            'subscriptionid': [% subscriptionid %],
815
    case "4":
290
        [% END %]
816
    case "5":
291
        [% IF (more_than_one_serial) %]
817
    case "8": // Year, Number.  -- Why not just use Vol, Number withvol==year??
292
          'nextacquidate': nextacquidate,
818
                //  FIXME: this my conflict with innerloop calc below.
293
        [% END %]
819
       if (document.f.lastvalue2temp.value > 0){document.f.innerloop1.value = document.f.lastvalue2temp.value - 1;}
294
        'firstacquidate': acquidate
820
      break;   
295
    };
821
    }  
296
    var ajaxParams = [
822
    if(basefield.name.slice(0,-1) == 'lastvalue' || 'whenmorethan' ) {
297
        'to', 'subtype', 'sublength', 'frequency', 'numberingmethod',
823
        // The enumeration string is held in a positional numeral notation with three positions, X,Y,Z.
298
        'lastvalue1', 'lastvalue2', 'lastvalue3', 'add1', 'add2', 'add3',
824
        // The last values lastvalue1, lastvalue2,lastvalue3 should match the last received serial's X,Y,Z enumeration.
299
        'every1', 'every2', 'every3', 'innerloop1', 'innerloop2', 'innerloop3',
825
        // make array indexes start with 1 for consistency with variable names.
300
        'setto1', 'setto2', 'setto3', 'numbering1', 'numbering2', 'numbering3',
826
        var innerloop = new Array( undefined, document.getElementById('innerloop1'), document.getElementById('innerloop2'), document.getElementById('innerloop3') );
301
        'whenmorethan1', 'whenmorethan2', 'whenmorethan3', 'locale'
827
        var lastvalue = new Array( undefined, document.getElementById('lastvalue1').value *1 , document.getElementById('lastvalue2').value *1 , document.getElementById('lastvalue3').value *1  );
302
    ];
828
        var every = new Array( undefined, document.getElementById('every1').value *1 , document.getElementById('every2').value *1 , document.getElementById('every3').value *1  );
303
    for(i in ajaxParams) {
829
        var add = new Array( undefined, document.getElementById('add1').value *1 , document.getElementById('add2').value *1 , document.getElementById('add3').value *1  );
304
        var param = ajaxParams[i];
830
        var whenmorethan = new Array( undefined, document.getElementById('whenmorethan1').value *1 , document.getElementById('whenmorethan2').value *1 , document.getElementById('whenmorethan3').value *1  );
305
        var value = $("#"+param).val();
831
        
306
        if(value.length > 0)
832
       if(rollover){
307
            ajaxData[param] = value;
833
       // calculate rollover  for higher level of periodicity.
834
       // if there are two levels of periodicity, (e.g. vol{X},num{Y},issue{Z}, then every1=every2*whenmorethan2 / add2 .
835
          for(var N=3;N>1;N--){
836
            if( add[N] > 0){
837
                var addN = (add[N]) ? add[N] : 1 ;
838
                var everyN = (document.getElementById('every'+N)) ? document.getElementById('every'+N).value : 1 ;
839
                document.getElementById('every'+(N-1)).value = whenmorethan[N] * everyN / addN ;
840
            }
841
          }
842
        }
843
        innerloop[3].value = ( every[3] > 1 ) ? lastvalue[3] % every[3] : 0 ;
844
        innerloop[2].value = ( every[2] > 1 ) ? lastvalue[3] - 1 : 0 ;
845
        innerloop[1].value = ( every[1] > 1 ) ? 
846
                                    ( whenmorethan[3] > 0 ) ?  (lastvalue[2] - 1) * every[2] + 1* innerloop[2].value 
847
                                                            : lastvalue[2] - 1
848
                                               : 0 ;
849
    }
308
    }
850
     //FIXME : add checks for innerloop || lastvalue .gt. rollover  
309
310
    $.ajax({
311
        url:"/cgi-bin/koha/serials/showpredictionpattern.pl",
312
        data: ajaxData,
313
        success: function(data) {
314
            $("#displayexample").html(data);
315
            patternneedtobetested = 0;
316
        }
317
    });
851
}
318
}
852
319
320
function saveAdvancedPattern() {
321
    if ($("#patternname").val().length == 0) {
322
        alert(_("Please enter a name for this pattern"));
323
        return false;
324
    }
853
325
854
function check_input(e){
326
    // Check if patternname already exists, and modify pattern
855
    var unicode=e.charCode? e.charCode : e.keyCode
327
    // instead of creating it if so
856
    if (unicode!=8 && unicode !=46 && unicode!=9 && unicode !=13){ // if key isn't backspace or delete
328
    var found = 0;
857
        if (unicode<48||unicode>57) { // if not a number
329
    $("#numberpattern option").each(function(){
858
            alert(_("Needs to be entered in digit form -eg 10"));
330
        if($(this).text() == $("#patternname").val()){
859
            return false // disable key press
331
            found = 1;
332
            return false;
860
        }
333
        }
334
    });
335
    var cnfrm = 1;
336
    if(found){
337
        var msg = _("This pattern name already exists. Do you want to modify it?")
338
            + "\n" + _("Warning: it will modify the pattern for all subscriptions")
339
            + _("that are using it.");
340
        cnfrm = confirm(msg);
861
    }
341
    }
862
}
863
342
864
function addbiblioPopup(biblionumber) {
343
    if(cnfrm) {
865
	var destination = "/cgi-bin/koha/cataloguing/addbiblio.pl?mode=popup";
344
        var ajaxData = {};
866
	if(biblionumber){ destination += "&biblionumber="+biblionumber; }
345
        var ajaxParams = [
867
 window.open(destination,'AddBiblioPopup','width=1024,height=768,toolbar=no,scrollbars=yes');
346
            'patternname', 'numberingmethod', 'label1', 'label2', 'label3',
868
}
347
            'add1', 'add2', 'add3', 'every1', 'every2', 'every3',
348
            'setto1', 'setto2', 'setto3', 'numbering1', 'numbering2', 'numbering3',
349
            'whenmorethan1', 'whenmorethan2', 'whenmorethan3', 'locale'
350
        ];
351
        for(i in ajaxParams) {
352
            var param = ajaxParams[i];
353
            var value = $("#"+param).val();
354
            if(value.length > 0)
355
                ajaxData[param] = value;
356
        }
869
357
870
function Plugin(f)
358
        $.getJSON(
871
{
359
            "/cgi-bin/koha/serials/create-numberpattern.pl",
872
	 window.open('subscription-bib-search.pl','FindABibIndex','width=800,height=400,toolbar=no,scrollbars=yes');
360
            ajaxData,
361
            function(data){
362
                if (data.numberpatternid) {
363
                    if(found == 0){
364
                        $("#numberpattern").append("<option value=\""+data.numberpatternid+"\">"+$("#patternname").val()+"</option>");
365
                    }
366
                    $("#numberpattern").val(data.numberpatternid);
367
                    numberpatternload();
368
                } else {
369
                    alert(_("Something went wrong. Unable to create a new numbering pattern."));
370
                }
371
            }
372
        );
373
    }
873
}
374
}
874
375
875
function FindAcqui(f)
376
function show_page_1() {
876
{
377
    $("#page_1").show();
877
	 window.open('acqui-search.pl','FindASupplier','width=800,height=400,toolbar=no,scrollbars=yes');
378
    $("#page_2").hide();
379
    $("#page_number").text("1/2");
878
}
380
}
879
381
880
function Find_ISSN(f)
382
function show_page_2() {
881
{
383
    $("#page_1").hide();
882
	 window.open('issn-search.pl','FindABibIndex','width=800,height=400,toolbar=no,scrollbars=yes');
384
    $("#page_2").show();
385
    $("#page_number").text("2/2");
386
    displaymoreoptions();
883
}
387
}
884
388
885
389
886
function Check(f) {
887
    if (f.aqbooksellerid.value.length==0) {
888
        input_box = confirm(_("If you wish to claim late or missing issues you must link this subscription to a vendor. Click OK to ignore or Cancel to return and enter a vendor"));
889
		if (input_box==true) {
890
		}
891
		else {
892
			return false;
893
		}
894
    }
895
	if (f.biblionumber.value.length==0) {
896
        alert(_("You must choose or create a biblio"));
897
    } else if(f.startdate.value.length != 0 && f.sublength.value > 0) {
898
        if (f.irreg_check.value == 1) {
899
            document.f.submit();
900
        } else {
901
            if(f.numbering_pattern.value == ''){
902
                alert(_("Please choose a numbering pattern"));
903
            } else {
904
                alert(_("Please check for irregularity by clicking 'Test Prediction Pattern'"));
905
            }
906
        }
907
    } else {
908
        alert(_("You must choose a start date and a subscription length"));
909
    }
910
	if(irregular_issues.numskipped < irregular_issues.skipped.length ) {
911
		alert(_("You have not accounted for all missing issues."));
912
	}
913
    return false;
914
}
915
916
$(document).ready(function() {
390
$(document).ready(function() {
917
    init_pattern();
391
    $("select#frequency").change(function(){
918
    // http://jqueryui.com/demos/datepicker/#date-range
392
        patternneedtobetested = 1;
919
    var dates = $( "#histstartdate, #histenddate" ).datepicker({
393
        $("input[name='enddate']").val('');
920
        changeMonth: true,
394
        frequencyload();
921
        numberOfMonths: 1,
395
    });
922
        onSelect: function( selectedDate ) {
396
    $("select#numberpattern").change(function(){
923
            var option = this.id == "histstartdate" ? "minDate" : "maxDate",
397
        patternneedtobetested = 1;
924
                instance = $( this ).data( "datepicker" );
398
        numberpatternload();
925
                date = $.datepicker.parseDate(
399
    });
926
                    instance.settings.dateFormat ||
400
    $("#subtype").change(function(){
927
                    $.datepicker._defaults.dateFormat,
401
        $("input[name='enddate']").val('');
928
                    selectedDate, instance.settings );
402
    });
929
            dates.not( this ).datepicker( "option", option, date );
403
    $("#sublength").change(function(){
930
        }
404
        $("input[name='enddate']").val('');
405
    });
406
    $("#lastvaluetemp1").keyup(function(){
407
        $("#lastvalue1").val($(this).val());
408
    });
409
    $("#lastvaluetemp2").keyup(function(){
410
        $("#lastvalue2").val($(this).val());
411
    });
412
    $("#lastvaluetemp3").keyup(function(){
413
        $("#lastvalue3").val($(this).val());
414
    });
415
    $("#lastvalue1").keyup(function(){
416
        $("#lastvaluetemp1").val($(this).val());
417
    });
418
    $("#lastvalue2").keyup(function(){
419
        $("#lastvaluetemp2").val($(this).val());
420
    });
421
    $("#lastvalue3").keyup(function(){
422
        $("#lastvaluetemp3").val($(this).val());
931
    });
423
    });
932
424
933
	[% IF ( history ) %] $("#subscription_form_history").show();[% END %]
425
    $("#innerlooptemp1").keyup(function(){
934
	$("#cancel_manual_history").click(function(){
426
        $("#innerloop1").val($(this).val());
935
		$("#subscription_form_history").hide();
427
    });
936
        $("#manuallist").removeAttr("checked");
428
    $("#innerlooptemp2").keyup(function(){
937
	});
429
        $("#innerloop2").val($(this).val());
938
   	$("#manuallist").click( function(){
430
    });
939
		if($(this).attr("checked")){
431
    $("#innerlooptemp3").keyup(function(){
940
			$("#subscription_form_history").show();
432
        $("#innerloop3").val($(this).val());
941
		} else {
433
    });
942
			$("#subscription_form_history").hide();
434
    $("#innerloop1").keyup(function(){
943
		}
435
        $("#innerlooptemp1").val($(this).val());
944
	}
436
    });
945
	);
437
    $("#innerloop2").keyup(function(){
946
   //  $(".widelabel").attr("width", "300px");  // labels stay skinny in IE7 anyway.
438
        $("#innerlooptemp2").val($(this).val());
947
[% IF ( modify ) %]
439
    });
948
    set_num_pattern_from_template_vars();
440
    $("#innerloop3").keyup(function(){
949
    [% IF ( hemisphere ) %]
441
        $("#innerlooptemp3").val($(this).val());
950
	is_hemisphere = [% hemisphere %] ;
951
    hemispheres();
952
    [% END %]
953
[% END %]
954
[% IF ( irregularity ) %]
955
    irregularity_check();
956
[% END %]
957
    $('#numberpattern').change( function() { 
958
        reset_num_pattern(); 
959
    });
442
    });
960
443
444
    if($("#frequency").val() != ""){
445
        frequencyload();
446
    }
447
    if($("#numberpattern").val() != ""){
448
        numberpatternload();
449
    }
450
961
    var node;
451
    var node;
962
    [% FOREACH field IN dont_export_field_loop %]
452
    [% FOREACH field IN dont_export_field_loop %]
963
        node = $("#[% field.fieldid %]");
453
        node = $("#[% field.fieldid %]");
Lines 967-972 $(document).ready(function() { Link Here
967
            $(node).find("option:first").attr('selected','selected');
457
            $(node).find("option:first").attr('selected','selected');
968
        }
458
        }
969
    [% END %]
459
    [% END %]
460
461
    show_page_1();
970
});
462
});
971
//]]>
463
//]]>
972
</script>
464
</script>
Lines 978-1392 $(document).ready(function() { Link Here
978
<div id="breadcrumbs"><a href="/cgi-bin/koha/mainpage.pl">Home</a> &rsaquo; <a href="/cgi-bin/koha/serials/serials-home.pl">Serials</a> &rsaquo; [% IF ( modify ) %]<a href="/cgi-bin/koha/serials/subscription-detail.pl?subscriptionid=[% subscriptionid %]"><i>[% bibliotitle |html %]</i></a> &rsaquo; Modify subscription[% ELSE %]New subscription[% END %]</div>
470
<div id="breadcrumbs"><a href="/cgi-bin/koha/mainpage.pl">Home</a> &rsaquo; <a href="/cgi-bin/koha/serials/serials-home.pl">Serials</a> &rsaquo; [% IF ( modify ) %]<a href="/cgi-bin/koha/serials/subscription-detail.pl?subscriptionid=[% subscriptionid %]"><i>[% bibliotitle |html %]</i></a> &rsaquo; Modify subscription[% ELSE %]New subscription[% END %]</div>
979
471
980
<div id="doc3" class="yui-t7">
472
<div id="doc3" class="yui-t7">
981
   
473
    <div id="bd">
982
   <div id="bd">
474
        <div class="yui-g">
983
<h1>[% IF ( modify ) %] Modify subscription for <i>[% bibliotitle |html %]</i>[% ELSE %]Add a new subscription[% END %]</h1>
475
            <h1>[% IF ( modify ) %] Modify subscription for <i>[% bibliotitle |html %]</i>[% ELSE %]Add a new subscription[% END %] (<span id="page_number">1/2</span>)</h1>
984
   <div class="yui-g">
476
            <form method="post" name="f" action="/cgi-bin/koha/serials/subscription-add.pl">
985
    <form method="post" name="f" action="/cgi-bin/koha/serials/subscription-add.pl">
477
                [% IF ( modify ) %]
986
[% IF ( modify ) %]
478
                    <input type="hidden" name="op" value="modsubscription" />
987
        <input type="hidden" name="op" value="modsubscription" />
479
                    <input type="hidden" name="subscriptionid" value="[% subscriptionid %]" />
988
        <input type="hidden" name="subscriptionid" value="[% subscriptionid %]" />
989
[% ELSE %]
990
        <input type="hidden" name="op" value="addsubscription" />
991
[% END %]
992
<input type="hidden" name="user" value="[% loggedinusername %]" />
993
<input type="hidden" name="irreg_check" value="0" />
994
<input type="hidden" name="issuesexpected1" id="issuesexpected1" value="0" />
995
996
	<div class="yui-u first">
997
    <fieldset id="subscription_add_information" class="rows">
998
	<legend>Subscription details</legend>
999
	<ol>
1000
	    [% IF ( subscriptionid ) %]
1001
        <li><span class="label">Subscription #</span> [% subscriptionid %]</li>
1002
        [% END %]
1003
        <li>
1004
            <label for="aqbooksellerid">Vendor: </label>
1005
            <input type="text" name="aqbooksellerid" id="aqbooksellerid" value="[% aqbooksellerid %]" size="8" /> (<input type="text" name="aqbooksellername" value="[% aqbooksellername %]" disabled="disabled" readonly="readonly" />) <a href="#" onclick="FindAcqui(f)">Search for a vendor</a>
1006
        </li>
1007
        <li>
1008
            <label for="biblionumber" class="required" title="Subscriptions must be associated with a bibliographic record">Biblio:</label>
1009
            
1010
                <input type="text" name="biblionumber" id="biblionumber" value="[% bibnum %]" size="8" /> 
1011
                (<input type="text" name="title" value="[% bibliotitle %]" disabled="disabled" readonly="readonly" />) <span class="required" title="Subscriptions must be associated with a bibliographic record">Required</span>
1012
               <div class="inputnote"> <a href="#" onclick="Plugin(f)">Search for Biblio</a>
1013
		    [% IF ( CAN_user_editcatalogue ) %] 
1014
		       [% IF ( modify ) %]
1015
		       | <a href="#" onclick="addbiblioPopup([% bibnum %]); return false;">Edit biblio</a>
1016
		       [% ELSE %]
1017
		       | <a href="#" onclick="addbiblioPopup(); return false;">Create Biblio</a>
1018
		       [% END %]
1019
		    [% END %]
1020
	       </div>
1021
            
1022
        </li>
1023
        <li class="radio">
1024
            [% IF ( serialsadditems ) %]
1025
                <p><input type="radio" id="serialsadditems-yes" name="serialsadditems" value="1" checked="checked" /><label class="widelabel" for="serialsadditems-yes">create an item record when receiving this serial</label></p>
1026
                <p><input type="radio" id="serialsadditems-no" name="serialsadditems" value="0" /><label class="widelabel" for="serialsadditems-no">do not create an item record when receiving this serial </label></p>
1027
            [% ELSE %]
1028
                <p><input type="radio" id="serialsadditems-yes" name="serialsadditems" value="1"/><label class="widelabel" for="serialsadditems-yes">create an item record when receiving this serial</label></p>
1029
                <p><input type="radio" id="serialsadditems-no" name="serialsadditems" value="0" checked="checked" /><label class="widelabel" for="serialsadditems-no">do not create an item record when receiving this serial</label></p>
1030
            [% END %]
1031
        </li>
1032
        <li>
1033
            <label for="branchcode">Library:</label>
1034
            
1035
                <select name="branchcode" id="branchcode" style="width: 20em;">
1036
                    [% UNLESS ( Independantbranches ) %]<option value="">None</option>[% END %]
1037
                    [% FOREACH branchloo IN branchloop %][% IF ( branchloo.selected ) %]<option value="[% branchloo.value %]" selected="selected">[% branchloo.branchname %]</option>
1038
				[% ELSE %]
1039
				<option value="[% branchloo.value %]">[% branchloo.branchname %]</option>
1040
				[% END %]
1041
                    [% END %]
1042
                </select> (select a library)
1043
            
1044
        </li>
1045
        <li>
1046
            <label for="location">Location:</label>
1047
            <select name="location" id="location">
1048
                <option value="">None</option>
1049
                [% FOREACH locations_loo IN locations_loop %][% IF ( locations_loo.selected ) %]<option value="[% locations_loo.authorised_value %]" selected="selected">[% locations_loo.lib %]</option>[% ELSE %]<option value="[% locations_loo.authorised_value %]">[% locations_loo.lib %]</option>[% END %][% END %]
1050
            </select>
1051
        </li>
1052
         <li>
1053
            <label for="callnumber">Call number:</label>
1054
            <input type="text" name="callnumber" id="callnumber" value="[% callnumber %]" size="20" />
1055
        </li>
1056
        <li>
1057
            <label for="graceperiod">Grace period:</label> <input type="text" name="graceperiod" id="graceperiod" value="[% graceperiod %]" size="5"/> day(s)
1058
        </li>
1059
        <li>
1060
            <label for="notes">OPAC note:</label>
1061
            <textarea name="notes" id="notes" cols="30" rows="2">[% notes %]</textarea>
1062
        </li>
1063
        <li>
1064
            <label for="internalnotes">Nonpublic note:</label>
1065
            <textarea name="internalnotes" id="internalnotes" cols="30" rows="2">[% internalnotes %]</textarea>
1066
        </li>
1067
        <li>
1068
            
1069
               [% IF ( letterloop ) %]
1070
            <label for="letter">Patron notification: </label>
1071
			   <select name="letter" id="letter">
1072
                    <option value="">None</option>
1073
                [% FOREACH letterloo IN letterloop %]
1074
				[% IF ( letterloo.selected ) %]
1075
                    <option value="[% letterloo.value %]" selected="selected">[% letterloo.lettername %]</option>
1076
[% ELSE %]
1077
                    <option value="[% letterloo.value %]">[% letterloo.lettername %]</option>
1078
[% END %]
1079
                [% END %]
1080
                </select> 
1081
                <div class="hint">Select a notice and subscribers will be notified when new issues are received.</div>
1082
            	[% ELSE %]
1083
            <span class="label">Patron notification: </span>
1084
				<div class="hint">To notify patrons of new serial issues, you must <a href="/cgi-bin/koha/tools/letter.pl">define a notice</a>.</div>
1085
				[% END %]
1086
        </li>
1087
		<li>
1088
			 <label class="widelabel" for="staffdisplaycount">Number of issues to display to staff: </label>
1089
			 <input type="text" name="staffdisplaycount" id="staffdisplaycount" value="[% staffdisplaycount %]" size="4"/>
1090
		 </li>
1091
		 <li>
1092
            <label class="widelabel" for="opacdisplaycount">Number of issues to display in OPAC: </label>
1093
			<input type="text" name="opacdisplaycount" id="opacdisplaycount" value="[% opacdisplaycount %]" size="4"/>
1094
		</li>
1095
	</ol>
1096
	</fieldset>
1097
	</div>
1098
	
1099
<div class="yui-u">
1100
<div id="subscription_form_history" style="display:none"><h3 style="display:inline">Subscription history</h3> <a href="#" id="cancel_manual_history">[cancel manual history]</a>
1101
        <p>Hint: you can update the serial history manually. This can be useful for an old subscription or to clean the existing history. Modify these fields with care, as future serial receive will continue to update them automatically.</p>
1102
        <fieldset class="rows">
1103
            <ol>
1104
                <li>
1105
                <label for="histstartdate">Subscription start date</label>
1106
                <input type="text" name="histstartdate" id="histstartdate" value="[% histstartdate %]" /><div class="hint"> (start date of the 1st subscription)</div>
1107
                </li>
1108
                <li>
1109
                <label for="histenddate">Subscription end date</label>
1110
                <input type="text" name="histenddate" id="histenddate" value="[% histenddate %]" /> <div class="hint">(if empty, subscription is still active)</div>
1111
                </li>
1112
                <li>
1113
                <label for="recievedlist">Received issues</label>
1114
                <textarea name="recievedlist" id="recievedlist" cols="60" rows="5">[% recievedlist %]</textarea>
1115
                </li>
1116
                <li>
1117
                <label for="missinglist">Missing issues</label>
1118
                <textarea name="missinglist" id="missinglist" cols="60" rows="5">[% missinglist %]</textarea>
1119
                </li>
1120
                <li>
1121
                <label for="opacnote">Note for OPAC</label>
1122
                <textarea name="opacnote" id="opacnote" cols="60" rows="5">[% opacnote %]</textarea>
1123
                </li>
1124
                <li>
1125
                <label for="librariannote">Note for staff</label>
1126
                <textarea name="librariannote" id="librariannote" cols="60" rows="5">[% librariannote %]</textarea>
1127
                </li>
1128
            </ol>
1129
        </fieldset>
1130
    <fieldset class="action"><input type="submit" value="Save subscription history"  /></fieldset>
1131
</div>
1132
1133
<div id="subscription_form_planning">
1134
	<fieldset class="rows">
1135
	<legend>Serials planning</legend>
1136
    <ol>
1137
        <li>
1138
           <label for="acqui_date"> First issue publication date:</label>
1139
                [% IF ( modify ) %]<input type="text" name="firstacquidate" value="[% firstacquidate %]"  size="13" maxlength="10" id="acqui_date" disabled="disabled" />
1140
                [% ELSE %]<input type="text" name="firstacquidate" value="[% firstacquidate %]"  size="13" maxlength="10" id="acqui_date" class="datepicker" />[% END %]
1141
        </li>
1142
           [% IF ( modify ) %]<li><label for="next_acqui_date"> Next issue publication date:</label>
1143
                <input type="text" name="nextacquidate" value="[% nextacquidate %]" size="13" maxlength="10" id="next_acqui_date" class="datepicker" />
1144
                </li>[% END %]
1145
                
1146
        <li>
1147
            <label for="periodicity" class="required">Frequency:</label>
1148
                <select name="periodicity" size="1" id="periodicity" onchange="javascript:document.getElementsByName('manualhist')[0].checked=(this.value==1); reset_num_pattern();">
1149
                <option value="" selected="selected">-- please choose --</option>
1150
                [% IF ( periodicity16 ) %]
1151
                <option value="16" selected="selected">Without periodicity</option>
1152
                [% ELSE %]
1153
                    <option value="16">Without periodicity</option>
1154
                [% END %]
1155
                [% IF ( periodicity48 ) %]
1156
                <option value="48" selected="selected">Unknown</option>
1157
                [% ELSE %]
1158
                <option value="48">Unknown</option>
1159
                [% END %]
1160
                [% IF ( periodicity32 ) %]
1161
                <option value="32" selected="selected">Irregular</option>
1162
                [% ELSE %]
1163
                    <option value="32">Irregular</option>
1164
                [% END %]
1165
1166
                [% IF ( periodicity12 ) %]
1167
                    <option value="12" selected="selected">2/day</option>
1168
                [% ELSE %]
1169
                    <option value="12">2/day</option>
1170
                [% END %]
1171
                [% IF ( periodicity1 ) %]
1172
                    <option value="1" selected="selected">daily (n/week)</option>
1173
                [% ELSE %]
1174
                    <option value="1">daily (n/week)</option>
1175
                [% END %]
1176
                [% IF ( periodicity2 ) %]
1177
                    <option value="2" selected="selected">1/week</option>
1178
                [% ELSE %]
480
                [% ELSE %]
1179
                    <option value="2">1/week</option>
481
                        <input type="hidden" name="op" value="addsubscription" />
1180
                [% END %]
482
                [% END %]
1181
                [% IF ( periodicity3 ) %]
483
                <input type="hidden" name="user" value="[% loggedinusername %]" />
1182
                    <option value="3" selected="selected">1/2 weeks </option>
484
                <input type="hidden" name="irreg_check" value="0" />
1183
                [% ELSE %]
485
1184
                    <option value="3">1/2 weeks </option>
486
                <div id="page_1">
1185
                [% END %]
487
                    <div class="yui-u first">
1186
                [% IF ( periodicity4 ) %]
488
                        <fieldset id="subscription_add_information" class="rows">
1187
                    <option value="4" selected="selected">1/3 weeks</option>
489
                            <legend>Subscription details</legend>
1188
                [% ELSE %]
490
                            <ol>
1189
                    <option value="4">1/3 weeks</option>
491
                                [% IF ( subscriptionid ) %]
1190
                [% END %]
492
                                    <li><span class="label">Subscription #</span> [% subscriptionid %]</li>
1191
                [% IF ( periodicity5 ) %]
493
                                [% END %]
1192
                    <option value="5" selected="selected">1/month</option>
494
                                <li>
1193
                [% ELSE %]
495
                                    <label for="aqbooksellerid">Vendor: </label>
1194
                    <option value="5">1/month</option>
496
                                    <input type="text" name="aqbooksellerid" id="aqbooksellerid" value="[% aqbooksellerid %]" size="8" /> (<input type="text" name="aqbooksellername" value="[% aqbooksellername %]" disabled="disabled" readonly="readonly" />) <a href="#" onclick="FindAcqui(f)">Search for a vendor</a>
1195
                [% END %]
497
                                </li>
1196
                [% IF ( periodicity6 ) %]
498
                                <li>
1197
                    <option value="6" selected="selected">1/2 months (6/year)</option>
499
                                    <label for="biblionumber" class="required" title="Subscriptions must be associated with a bibliographic record">Biblio:</label>
1198
                [% ELSE %]
500
                                    <input type="text" name="biblionumber" id="biblionumber" value="[% bibnum %]" size="8" /> 
1199
                    <option value="6">1/2 months (6/year)</option>
501
                                    (<input type="text" name="title" value="[% bibliotitle %]" disabled="disabled" readonly="readonly" />) <span class="required" title="Subscriptions must be associated with a bibliographic record">Required</span>
1200
                [% END %]
502
                                    <div class="inputnote"> <a href="#" onclick="Plugin(f)">Search for Biblio</a>
1201
                [% IF ( periodicity7 ) %]
503
                                        [% IF ( CAN_user_editcatalogue ) %] 
1202
                    <option value="7" selected="selected">1/3 months (1/quarter)</option>
504
                                            [% IF ( modify ) %]
1203
                [% ELSE %]
505
                                            | <a href="#" onclick="addbiblioPopup([% bibnum %]); return false;">Edit biblio</a>
1204
                    <option value="7">1/3 months (1/quarter)</option>
506
                                            [% ELSE %]
1205
                [% END %]
507
                                            | <a href="#" onclick="addbiblioPopup(); return false;">Create Biblio</a>
1206
                <!-- periodicity8 is 1/quarter, exactly like periodicity7 but will use it for seasonal option -->
508
                                            [% END %]
1207
                [% IF ( periodicity8 ) %]
509
                                        [% END %]
1208
                    <option value="8" selected="selected">1/quarter (seasonal)</option>
510
                                    </div>
1209
                [% ELSE %]
511
                                </li>
1210
                    <option value="8">1/quarter (seasonal)</option>
512
                                <li class="radio">
1211
                [% END %]
513
                                    [% IF ( serialsadditems ) %]
1212
                [% IF ( periodicity13 ) %]
514
                                        <p><input type="radio" id="serialsadditems-yes" name="serialsadditems" value="1" checked="checked" /><label class="widelabel" for="serialsadditems-yes">create an item record when receiving this serial</label></p>
1213
                    <option value="13" selected="selected">1/4 months (3/year)</option>
515
                                        <p><input type="radio" id="serialsadditems-no" name="serialsadditems" value="0" /><label class="widelabel" for="serialsadditems-no">do not create an item record when receiving this serial </label></p>
1214
                [% ELSE %]
516
                                    [% ELSE %]
1215
                    <option value="13">1/4 months (3/year)</option>
517
                                        <p><input type="radio" id="serialsadditems-yes" name="serialsadditems" value="1"/><label class="widelabel" for="serialsadditems-yes">create an item record when receiving this serial</label></p>
1216
                [% END %]
518
                                        <p><input type="radio" id="serialsadditems-no" name="serialsadditems" value="0" checked="checked" /><label class="widelabel" for="serialsadditems-no">do not create an item record when receiving this serial</label></p>
1217
519
                                    [% END %]
1218
                [% IF ( periodicity9 ) %]
520
                                </li>
1219
                    <option value="9" selected="selected">2/years</option>
521
                                <li class="radio">
1220
                [% ELSE %]
522
                                  <p>When there is an irregular issue:</p>
1221
                    <option value="9">2/year</option>
523
                                  [% IF (skip_serialseq) %]
1222
                [% END %]
524
                                    <p>
1223
                [% IF ( periodicity10 ) %]
525
                                      <input type="radio" id="skip_serialseq_yes" name="skip_serialseq" value="1" checked="checked" />
1224
                    <option value="10" selected="selected">1/year</option>
526
                                      <label for="skip_serialseq_yes">Skip issue number</label>
1225
                [% ELSE %]
527
                                    </p>
1226
                    <option value="10">1/year</option>
528
                                    <p>
1227
                [% END %]
529
                                      <input type="radio" id="skip_serialseq_no" name="skip_serialseq" value="0" />
1228
                [% IF ( periodicity11 ) %]
530
                                      <label for="skip_serialseq_no">Keep issue number</label>
1229
                    <option value="11" selected="selected">1/2 years</option>
531
                                    </p>
1230
                [% ELSE %]
532
                                  [% ELSE %]
1231
                    <option value="11">1/2 years</option>
533
                                    <p>
1232
                [% END %]
534
                                      <input type="radio" id="skip_serialseq_yes" name="skip_serialseq" value="1" />
1233
                </select> <span class="required">Required</span></li>
535
                                      <label for="skip_serialseq_yes">Skip issue number</label>
1234
                <li>
536
                                    </p>
1235
                    <label for="manuallist"> Manual history:</label>
537
                                    <p>
1236
                    [% IF ( manualhistory ) %]
538
                                      <input type="radio" id="skip_serialseq_no" name="skip_serialseq" value="0" checked="checked" />
1237
                        <input type="checkbox" name="manualhist" id="manuallist" value="1" checked="checked" />
539
                                      <label for="skip_serialseq_no">Keep issue number</label>
1238
                    [% ELSE %]
540
                                    </p>
1239
                        <input type="checkbox" name="manualhist" id="manuallist" value="1" />
541
                                  [% END %]
1240
                    [% END %]
542
                                </li>
1241
                </li>
543
                                <li>
1242
        <li>
544
                                    <label for="manualhistory">Manual history</label>
1243
           <label for="numberpattern"> Numbering pattern:</label>
545
                                    [% IF (manualhistory) %]
1244
            
546
                                        <input type="checkbox" id="manualhistory" name="manualhist" checked="checked" />
1245
                <select name="numbering_pattern" size="1" id="numberpattern" >
547
                                    [% ELSE %]
1246
                    <option value="" selected="selected">-- please choose --</option>
548
                                        <input type="checkbox" id="manualhistory" name="manualhist" />
1247
                    [% IF ( numberpattern1 ) %]
549
                                    [% END %]
1248
                        <option value="1" selected="selected">Number</option>
550
                                </li>
1249
                    [% ELSE %]
551
                                <li>
1250
                        <option value="1">Number</option>
552
                                    <label for="callnumber">Call number</label>
1251
                    [% END %]
553
                                    <input type="text" name="callnumber" id="callnumber" value="[% callnumber %]" size="20" />
1252
                    [% IF ( numberpattern2 ) %]
554
                                </li>
1253
                        <option value="2" selected="selected">Volume, number, issue</option>
555
                                <li>
1254
                    [% ELSE %]
556
                                    <label for="branchcode">Library:</label>
1255
                        <option value="2">Volume, number, issue</option>
557
                                    <select name="branchcode" id="branchcode" style="width: 20em;">
1256
                    [% END %]
558
                                        [% UNLESS ( Independantbranches ) %]
1257
                    [% IF ( numberpattern3 ) %]
559
                                            <option value="">None</option>
1258
                        <option value="3" selected="selected">Volume, number</option>
560
                                        [% END %]
1259
                    [% ELSE %]
561
                                        [% FOREACH branchloo IN branchloop %]
1260
                        <option value="3">Volume, number</option>
562
                                            [% IF ( branchloo.selected ) %]
1261
                    [% END %]
563
                                                <option value="[% branchloo.value %]" selected="selected">[% branchloo.branchname %]</option>
1262
                    [% IF ( numberpattern4 ) %]
564
                                            [% ELSE %]
1263
                        <option value="4" selected="selected">Volume, issue</option>
565
                                                <option value="[% branchloo.value %]">[% branchloo.branchname %]</option>
1264
                    [% ELSE %]
566
                                            [% END %]
1265
                        <option value="4">Volume, issue</option>
567
                                        [% END %]
1266
                    [% END %]
568
                                    </select> (select a library)
1267
                    [% IF ( numberpattern5 ) %]
569
                                </li>
1268
                        <option value="5" selected="selected">Number, issue</option>
570
                                <li>
1269
                    [% ELSE %]
571
                                    <label for="notes">Public note:</label>
1270
                        <option value="5">Number, issue</option>
572
                                    <textarea name="notes" id="notes" cols="30" rows="2">[% notes %]</textarea>
1271
                    [% END %]
573
                                </li>
1272
                    [% IF ( numberpattern6 ) %]
574
                                <li>
1273
                        <option value="6" selected="selected">Seasonal only</option>
575
                                    <label for="internalnotes">Nonpublic note:</label>
1274
                    [% ELSE %]
576
                                    <textarea name="internalnotes" id="internalnotes" cols="30" rows="2">[% internalnotes %]</textarea>
1275
                        <option value="6">Seasonal only</option>
577
                                </li>
1276
                    [% END %]
578
                                <li>
1277
                    [% IF ( numberpattern8 ) %]
579
                                    [% IF ( letterloop ) %]
1278
                        <option value="8" selected="selected">Year/Number</option>
580
                                        <label for="letter">Patron notification: </label>
1279
                    [% ELSE %]
581
                                        <select name="letter" id="letter">
1280
                        <option value="8">Year/Number</option>
582
                                            <option value="">None</option>
1281
                    [% END %]          
583
                                            [% FOREACH letterloo IN letterloop %]
1282
                    [% IF ( numberpattern7 ) %]
584
                                                [% IF ( letterloo.selected ) %]
1283
                        <option value="7" selected="selected">None of the above</option>
585
                                                    <option value="[% letterloo.value %]" selected="selected">[% letterloo.lettername %]</option>
1284
                    [% ELSE %]
586
                                                [% ELSE %]
1285
                        <option value="7">None of the above</option>
587
                                                    <option value="[% letterloo.value %]">[% letterloo.lettername %]</option>
1286
                    [% END %]
588
                                                [% END %]
1287
                </select>
589
                                            [% END %]
1288
        </li>
590
                                        </select>
1289
                <li id="more_options"></li>
591
                                        <div class="hint">Select a notice and patrons on the routing list will be notified when new issues are received.</div>
1290
                <li id="irregularity"></li>
592
                                    [% ELSE %]
1291
   	           <li id="displayexample"></li>
593
                                        <span class="label">Patron notification: </span>
1292
        <li>
594
                                        <div class="hint">To notify patrons of new serial issues, you must <a href="/cgi-bin/koha/tools/letter.pl">define a notice</a>.</div>
1293
           <label for="from" class="required"> Subscription start date:</label>
595
                                    [% END %]
1294
                <input type="text" name="startdate" value="[% startdate %]" size="13" maxlength="10" id="from" class="datepickerfrom" />
596
                                </li>
1295
            <span class="required">Required</span>
597
                                <li>
1296
        </li>
598
                                    <label for="location">Location:</label>
1297
        <li>
599
                                    <select name="location" id="location">
1298
            <label for="subtype" class="required">Subscription length:</label>
600
                                        <option value="">None</option>
1299
            
601
                                        [% FOREACH locations_loo IN locations_loop %]
1300
                <select name="subtype" id="subtype">
602
                                            [% IF ( locations_loo.selected ) %]
1301
                    [% IF ( subtype_monthlength ) %]<option value="monthlength" selected="selected">[% ELSE %]<option value="monthlength">[% END %] Number of months</option>
603
                                                <option value="[% locations_loo.authorised_value %]" selected="selected">[% locations_loo.lib %]</option>
1302
                    [% IF ( subtype_numberlength ) %]<option value="numberlength" selected="selected">[% ELSE %]<option value="numberlength">[% END %] Number of issues</option>
604
                                            [% ELSE %]
1303
                    [% IF ( subtype_weeklength ) %]<option value="weeklength" selected="selected">[% ELSE %]<option value="weeklength">[% END %] Number of weeks</option>
605
                                                <option value="[% locations_loo.authorised_value %]">[% locations_loo.lib %]</option>
1304
                </select>
606
                                            [% END %]
1305
                <input type="text" id="numberlength" name="sublength" value="[% sublength %]" size="3" onkeypress="return check_input(event)" /> (enter amount in numerals)
607
                                        [% END %]
1306
            <span class="required">Required</span>
608
                                    </select>
1307
        </li>
609
                                </li>
1308
        <li>
610
                                <li>
1309
           <label for="to"> Subscription end date:</label>
611
                                    <label for="graceperiod">Grace period:</label>
1310
                <input type="text" name="enddate" value="[% enddate %]" size="13" maxlength="10" id="to" class="datepickerto" />
612
                                    <input type="text" name="graceperiod" id="graceperiod" value="[% graceperiod %]" size="5"/> day(s)
1311
        </li>
613
                                </li>
1312
    <li><label for="numberingmethod">Numbering formula:</label> <input type="text" name="numberingmethod" id="numberingmethod" value="[% numberingmethod %]" />
614
                                <li>
1313
    </li>
615
                                     <label class="widelabel" for="staffdisplaycount">Number of issues to display to staff: </label>
1314
    </ol>
616
                                     <input type="text" name="staffdisplaycount" id="staffdisplaycount" value="[% staffdisplaycount %]" size="4"/>
1315
	</fieldset>
617
                                 </li>
1316
618
                                 <li>
1317
	<fieldset class="action">
619
                                    <label class="widelabel" for="opacdisplaycount">Number of issues to display to the public: </label>
1318
    <input type="button" class="action_test" value="Test prediction pattern" onclick="javascript:irregularity_check()" />
620
                                    <input type="text" name="opacdisplaycount" id="opacdisplaycount" value="[% opacdisplaycount %]" size="4"/>
1319
    <input type="button" class="action_reset" value="Reset pattern" onclick="javascript:reset_pattern()" />
621
                                </li>
1320
    <input type="button" class="action_save"  value="Save subscription" onclick="Check(this.form)" accesskey="w" />
622
                            </ol>
1321
	</fieldset>
623
                        </fieldset>
1322
    <fieldset class="action">
624
                        <fieldset class="action">
1323
    <input type="button" class="action_advanced" value="Show/Hide advanced pattern" onclick="javascript:display_table()" />
625
                            <input type="button" value="Next >>" onclick="if ( Check_page1() ) show_page_2();" style="float:right;" />
1324
    </fieldset>
626
                        </fieldset>
1325
           <div id="basetable"  style="display: none;">
627
                    </div>
1326
            <table class="small">
628
                </div>
1327
                <tr><th colspan="4">Advanced prediction pattern</th></tr>
629
1328
				<tr>
630
                <div id="page_2">
1329
                    <th>&nbsp;</th>
631
                    <div class="yui-u first">
1330
                    <th>X</th>
632
                        <div id="subscription_form_planning">
1331
                    <th>Y</th>
633
                            <fieldset class="rows">
1332
                    <th>Z</th>
634
                                <legend>Serials planning</legend>
1333
                </tr>
635
                                <ol>
1334
                <tr>
636
                                    <li>
1335
                    <td>Add</td>
637
                                        <label for="firstacquidate">First issue publication date: (*)</label>
1336
                    <td>
638
                                        [% UNLESS (more_than_one_serial) %]
1337
                        <input type="text" name="add1" id="add1" value="[% add1 %]" />
639
                                          <input type="text" size="10" id="acqui_date" name="firstacquidate" value="[% firstacquidate | $KohaDates %]" class="datepicker" readonly="readonly"/>
1338
                    </td>
640
                                        [% ELSE %]
1339
                    <td>
641
                                          [% firstacquidate | $KohaDates %]
1340
                        <input type="text" name="add2" id="add2" value="[% add2 %]" />
642
                                          <input type="hidden" size="10" id="acqui_date" name="firstacquidate" value="[% firstacquidate | $KohaDates %]"/>
1341
                    </td>
643
                                        [% END %]
1342
                    <td>
644
                                    </li>
1343
                        <input type="text" name="add3" id="add3" value="[% add3 %]" />
645
                                    [% IF (more_than_one_serial) %]
1344
                    </td>
646
                                      <li>
1345
                </tr>
647
                                        <label for="nextacquidate">Next issue publication date:</label>
1346
                <tr>
648
                                        <input type="text" size="10" id="nextacquidate" name="nextacquidate" value="[% nextacquidate | $KohaDates %]" class="datepicker" readonly="readonly"/>
1347
                    <td>once every</td>
649
                                      </li>
1348
                    <td><input type="text" name="every1" id="every1" value="[% every1 %]" /></td>
650
                                    [% END %]
1349
                    <td><input type="text" name="every2" id="every2" value="[% every2 %]" /></td>
651
                                    <li>
1350
                    <td><input type="text" name="every3" id="every3" value="[% every3 %]" /></td>
652
                                        <label for="frequency">Frequency: (*)</label>
1351
                </tr>
653
                                        <select name="frequency" size="1" id="frequency">
1352
                <tr>
654
                                            <option value="">-- please choose --</option>
1353
                    <td>When more than</td>
655
                                            [% FOREACH frequency IN frequencies %]
1354
                    <td><input type="text" name="whenmorethan1" id="whenmorethan1" value="[% whenmorethan1 %]" /></td>
656
                                                <option value="[% frequency.id %]" [% IF (frequency.selected) %] selected="selected" [% END %]>
1355
                    <td><input type="text" name="whenmorethan2" id="whenmorethan2" value="[% whenmorethan2 %]" /></td>
657
                                                    [% frequency.label %]
1356
                    <td><input type="text" name="whenmorethan3" id="whenmorethan3" value="[% whenmorethan3 %]" /></td>
658
                                                </option>
1357
                </tr>
659
                                            [% END %]
1358
                <tr>
660
                                        </select>
1359
                    <td>inner counter</td>
661
                                    </li>
1360
                    <td><input type="text" name="innerloop1" id="innerloop1" value="[% innerloop1 %]" /></td>
662
                                    <li>
1361
                    <td><input type="text" name="innerloop2" id="innerloop2" value="[% innerloop2 %]" /></td>
663
                                        <label for="subtype">Subscription length:</label>
1362
                    <td><input type="text" name="innerloop3" id="innerloop3" value="[% innerloop3 %]" /></td>
664
                                        <select name="subtype" id="subtype">
1363
                </tr>
665
                                            [% FOREACH subt IN subtype %]
1364
                <tr>
666
                                                <option value="[% subt.name %]" [% IF (subt.selected) %] selected="selected" [% END %] >
1365
                    <td>Set back to</td>
667
                                                    [% subt.name %]
1366
                    <td><input type="text" name="setto1" id="setto1" value="[% setto1 %]" /></td>
668
                                                </option>
1367
                    <td><input type="text" name="setto2" id="setto2" value="[% setto2 %]" /></td>
669
                                            [% END %]
1368
                    <td><input type="text" name="setto3" id="setto3" value="[% setto3 %]" /></td>
670
                                        </select>
1369
                </tr>
671
                                        <input type="text" name="sublength" id="sublength" value="[% sublength %]" size="3" /> (enter amount in numerals)
1370
                <tr>
672
                                        <input type="hidden" name="issuelengthcount">
1371
                    <td>
673
                                    </li>
1372
                        [% IF ( modify ) %]
674
                                    <li>
1373
                            Last value
675
                                        <label for="startdate"> Subscription start date: (*)</label>
1374
                        [% ELSE %]
676
                                        <input type="text" size="10" id="from" name="startdate" value="[% startdate | $KohaDates %]" class="datepickerfrom" readonly="readonly"/>
1375
                            Begins with
677
                                    </li>
1376
                        [% END %]
678
                                    <li>
1377
                    </td>
679
                                        <label for="enddate">Subscription end date:</label>
1378
                    <td><input type="text" name="lastvalue1" id="lastvalue1" value="[% lastvalue1 %]" /></td>
680
                                        <input type="text" size="10" id="to" name="enddate" value="[% enddate | $KohaDates %]" class="datepickerto" readonly="readonly"/>
1379
                    <td><input type="text" name="lastvalue2" id="lastvalue2" value="[% lastvalue2 %]" /></td>
681
                                    </li>
1380
                    <td><input type="text" name="lastvalue3" id="lastvalue3" value="[% lastvalue3 %]" /></td>
682
                                    <li>
1381
                </tr>
683
                                        <label for="numberpattern">Numbering pattern:</label>
1382
            </table>
684
                                        <select name="numbering_pattern" size="1" id="numberpattern">
685
                                            <option value="">-- please choose --</option>
686
                                            [% FOREACH numberpattern IN numberpatterns %]
687
                                                <option value="[% numberpattern.id %]" [% IF (numberpattern.selected) %] selected="selected" [% END %]>[% numberpattern.label %]</option>
688
                                            [% END %]
689
                                        </select>
690
                                    </li>
691
                                    <li>
692
                                        <label for="locale">Locale</label>
693
                                        <select id="locale" name="locale">
694
                                            <option value=""></option>
695
                                            [% FOREACH locale IN locales %]
696
                                                <option value="[% locale %]">
697
                                                    [% locale %]
698
                                                </option>
699
                                            [% END %]
700
                                        </select>
701
                                        <span class="hint">If empty, system locale is used</span>
702
                                    </li>
703
                                    <li id="more_options">
704
                                        <table id="moreoptionst">
705
                                            <thead>
706
                                                <tr>
707
                                                    <th>&nbsp;</th>
708
                                                    <th id="headerX">&nbsp;</th>
709
                                                    <th id="headerY">&nbsp;</th>
710
                                                    <th id="headerZ">&nbsp;</th>
711
                                                </tr>
712
                                            </thead>
713
                                            <tbody>
714
                                                <tr>
715
                                                    <td>
716
                                                      [% IF (more_than_one_serial) %]
717
                                                        Last value
718
                                                      [% ELSE %]
719
                                                        Begins with
720
                                                      [% END %]
721
                                                    </td>
722
                                                    <td id="beginsX"><input type="text" id="lastvaluetemp1" name="lastvaluetemp1" value="[% lastvalue1 %]" /></td>
723
                                                    <td id="beginsY"><input type="text" id="lastvaluetemp2" name="lastvaluetemp2" value="[% lastvalue2 %]" /></td>
724
                                                    <td id="beginsZ"><input type="text" id="lastvaluetemp3" name="lastvaluetemp3" value="[% lastvalue3 %]" /></td>
725
                                                </tr>
726
                                                <tr>
727
                                                    <td>Inner counter</td>
728
                                                    <td id="innerX"><input type="text" id="innerlooptemp1" name="innerlooptemp1" value="[% innerloop1 %]" /></td>
729
                                                    <td id="innerY"><input type="text" id="innerlooptemp2" name="innerlooptemp2" value="[% innerloop2 %]" /></td>
730
                                                    <td id="innerZ"><input type="text" id="innerlooptemp3" name="innerlooptemp3" value="[% innerloop3 %]" /></td>
731
                                                </tr>
732
                                            </tbody>
733
                                        </table>
734
                                    </li>
735
                                    <li><a style="cursor:pointer" onclick="toggleAdvancedPattern();">Show/Hide advanced pattern</a></li>
736
                                    <div id="advancedpredictionpattern" style="display:none">
737
                                      <li>
738
                                        <label for="patternname">Pattern name: (*)</label>
739
                                        <input id="patternname" name="patternname" type="text" readonly="readonly" />
740
                                      </li>
741
                                      <li>
742
                                        <label for="numberingmethod">Numbering formula:</label>
743
                                        <input readonly="readonly" type="text" name="numberingmethod" id="numberingmethod" size="50" value="[% numberingmethod %]" />
744
                                      </li>
745
                                        <table id="advancedpredictionpatternt">
746
                                            <thead>
747
                                                <tr>
748
                                                    <th colspan="4">Advanced prediction pattern</td>
749
                                                </tr>
750
                                                <tr>
751
                                                    <th>&nbsp;</th>
752
                                                    <th>X</th>
753
                                                    <th>Y</th>
754
                                                    <th>Z</th>
755
                                                </tr>
756
                                            </thead>
757
                                            <tbody>
758
                                                <tr>
759
                                                    <td>Label</td>
760
                                                    <td><input type="text" readonly="readonly" id="label1" name="label1" /></td>
761
                                                    <td><input type="text" readonly="readonly" id="label2" name="label2" /></td>
762
                                                    <td><input type="text" readonly="readonly" id="label3" name="label3" /></td>
763
                                                </tr>
764
                                                <tr>
765
                                                    <td>Begins with</td>
766
                                                    <td><input type="text" readonly="readonly" id="lastvalue1" name="lastvalue1" /></td>
767
                                                    <td><input type="text" readonly="readonly" id="lastvalue2" name="lastvalue2" /></td>
768
                                                    <td><input type="text" readonly="readonly" id="lastvalue3" name="lastvalue3" /></td>
769
                                                </tr>
770
                                                <tr>
771
                                                    <td>Add</td>
772
                                                    <td><input type="text" readonly="readonly" id="add1" name="add1" /></td>
773
                                                    <td><input type="text" readonly="readonly" id="add2" name="add2" /></td>
774
                                                    <td><input type="text" readonly="readonly" id="add3" name="add3" /></td>
775
                                                </tr>
776
                                                <tr>
777
                                                    <td>Every</td>
778
                                                    <td><input type="text" readonly="readonly" id="every1" name="every1" /></td>
779
                                                    <td><input type="text" readonly="readonly" id="every2" name="every2" /></td>
780
                                                    <td><input type="text" readonly="readonly" id="every3" name="every3" /></td>
781
                                                </tr>
782
                                                <tr>
783
                                                    <td>Set back to</td>
784
                                                    <td><input type="text" readonly="readonly" id="setto1" name="setto1" /></td>
785
                                                    <td><input type="text" readonly="readonly" id="setto2" name="setto2" /></td>
786
                                                    <td><input type="text" readonly="readonly" id="setto3" name="setto3" /></td>
787
                                                </tr>
788
                                                <tr>
789
                                                    <td>When more than</td>
790
                                                    <td><input type="text" readonly="readonly" id="whenmorethan1" name="whenmorethan1" /></td>
791
                                                    <td><input type="text" readonly="readonly" id="whenmorethan2" name="whenmorethan2" /></td>
792
                                                    <td><input type="text" readonly="readonly" id="whenmorethan3" name="whenmorethan3" /></td>
793
                                                </tr>
794
                                                <tr>
795
                                                    <td>Inner counter</td>
796
                                                    <td><input type="text" readonly="readonly" id="innerloop1" name="innerloop1" /></td>
797
                                                    <td><input type="text" readonly="readonly" id="innerloop2" name="innerloop2" /></td>
798
                                                    <td><input type="text" readonly="readonly" id="innerloop3" name="innerloop3" /></td>
799
                                                </tr>
800
                                                <tr>
801
                                                    [% BLOCK numbering_select %]
802
                                                        <select disabled="disabled" id="[% name %]" name="[% name %]" />
803
                                                            <option value=""></option>
804
                                                            <option value="dayname">Name of day</option>
805
                                                            <option value="monthname">Name of month</option>
806
                                                            <option value="season">Name of season</option>
807
                                                        </select>
808
                                                    [% END %]
809
                                                    <td>Formatting</td>
810
                                                    <td>[% PROCESS numbering_select name="numbering1" %]</td>
811
                                                    <td>[% PROCESS numbering_select name="numbering2" %]</td>
812
                                                    <td>[% PROCESS numbering_select name="numbering3" %]</td>
813
                                                </tr>
814
                                            </tbody>
815
                                        </table>
816
                                        <input id="modifyadvancedpatternbutton" type="button" value="Modify pattern" onclick="modifyAdvancedPattern();" />
817
                                        <input id="restoreadvancedpatternbutton" type="button" value="Cancel modifications" onclick="restoreAdvancedPattern();" style="display:none" />
818
                                        <input id="saveadvancedpatternbutton" type="button" value="Save as new pattern" onclick="saveAdvancedPattern();" style="display:none" />
819
                                    </div>
820
                                </ol>
821
                            </fieldset>
822
                            <fieldset class="action">
823
                                <input type="button" value="<< Previous" onclick="show_page_1();" style="float:left;"/>
824
                                <input id="testpatternbutton" type="button" value="Test prediction pattern" onclick="testPredictionPattern();" />
825
                                <input type="button" value="Save subscription" onclick="if (Check_page2()) submit();" style="float:right;" accesskey="w" />
826
                            </fieldset>
827
                        </div>
828
                    </div>
829
                    <div class="yui-u">
830
                        <li id="displayexample"></li>
831
                    </div>
832
                </div>
833
            </form>
1383
        </div>
834
        </div>
1384
835
    </div>
1385
</div>
1386
</div>
1387
</form>
1388
</div>
1389
1390
</div>
836
</div>
1391
837
1392
[% INCLUDE 'intranet-bottom.inc' %]
838
[% INCLUDE 'intranet-bottom.inc' %]
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/serials/subscription-detail.tt (-113 / +32 lines)
Lines 8-28 var text = new Array(_("Number"),_("Volume"),_("Issue"),_("Month"),_("Week"),_(" Link Here
8
"Autumn"),_("Winter"),_("Spring"),_("Summer"),_("Fall"),_("Season"),_("Year"));
8
"Autumn"),_("Winter"),_("Spring"),_("Summer"),_("Fall"),_("Season"),_("Year"));
9
9
10
10
11
// to display the options section
12
function options(x,y,z){
13
var textbox = '';
14
    // alert("X: "+x+"Y: "+y+"Z: "+z);
15
    if(x){
16
        document.f.xfield.value = x;
17
        if(y){
18
            document.f.yfield.value = y;
19
            if(z){
20
                document.f.zfield.value = z;
21
            }
22
        }
23
    }
24
}
25
26
function confirm_deletion() {
11
function confirm_deletion() {
27
    var is_confirmed = confirm(_("Are you sure you want to delete this subscription?"));
12
    var is_confirmed = confirm(_("Are you sure you want to delete this subscription?"));
28
    if (is_confirmed) {
13
    if (is_confirmed) {
Lines 107-112 $(document).ready(function() { Link Here
107
        [% ELSE %]
92
        [% ELSE %]
108
            <li><span class="label">Items:</span> Serial receipt does not create an item record.</li>
93
            <li><span class="label">Items:</span> Serial receipt does not create an item record.</li>
109
        [% END %]
94
        [% END %]
95
        <li>
96
            <span class="label">Serial number:</span>
97
            [% IF skip_serialseq %]
98
                Serial number is skipped when an irregularity is found.
99
            [% ELSE %]
100
                Serial number is kept when an irregularity is found.
101
            [% END %]
102
        </li>
110
        <li><span class="label">Grace period:</span> [% graceperiod %]</li>
103
        <li><span class="label">Grace period:</span> [% graceperiod %]</li>
111
        </ol>
104
        </ol>
112
    </div>
105
    </div>
Lines 170-287 $(document).ready(function() { Link Here
170
        <ol>
163
        <ol>
171
            <li><span class="label">Beginning date:</span> [% startdate %]
164
            <li><span class="label">Beginning date:</span> [% startdate %]
172
            </li>
165
            </li>
173
            <li><span class="label">Frequency (*):</span>
166
            <li><span class="label">Frequency:</span>
174
                [% IF ( periodicity16 ) %]
167
                [% frequency.description %]
175
                        Without regularity
176
                [% END %]
177
                [% IF ( periodicity32 ) %]
178
                        Irregular
179
                [% END %]
180
                [% IF ( periodicity0 ) %]
181
                        Unknown
182
                [% END %]
183
                [% IF ( periodicity12 ) %]
184
                        2/day
185
                [% END %]
186
                [% IF ( periodicity1 ) %]
187
                        1/day
188
                [% END %]
189
                [% IF ( periodicity13 ) %]
190
                        1/4 months (3/year)
191
                [% END %]
192
                [% IF ( periodicity2 ) %]
193
                        1/week
194
                [% END %]
195
                [% IF ( periodicity3 ) %]
196
                        1/2 weeks
197
                [% END %]
198
                [% IF ( periodicity4 ) %]
199
                        1/3 weeks
200
                [% END %]
201
                [% IF ( periodicity5 ) %]
202
                        1/month
203
                [% END %]
204
                [% IF ( periodicity6 ) %]
205
                        1/2 months (6/year)
206
                [% END %]
207
                [% IF ( periodicity7 ) %]
208
                        1/quarter
209
                [% END %]
210
                [% IF ( periodicity8 ) %]
211
                        1/quarter
212
                [% END %]
213
                [% IF ( periodicity9 ) %]
214
                        2/year
215
                [% END %]
216
                [% IF ( periodicity10 ) %]
217
                        1/year
218
                [% END %]
219
                [% IF ( periodicity11 ) %]
220
                        1/2 years
221
                [% END %]
222
            </li>
168
            </li>
223
            <li>
169
            <li>
224
              <span class="label">Manual history: </span>
170
              <span class="label">Manual history: </span>
225
                [% IF ( manualhistory ) %]
171
                [% IF ( manualhistory ) %]
226
                    Disabled
172
                    Enabled <a href="/cgi-bin/koha/serials/subscription-history.pl?subscriptionid=[% subscriptionid %]">Edit history</a>
227
                [% ELSE %]
173
                [% ELSE %]
228
                    Enabled
174
                    Disabled
229
                [% END %]
175
                [% END %]
230
            </li>
176
            </li>
231
            <li><span class="label">Number pattern:</span>
177
            <li><span class="label">Number pattern:</span>
232
                [% IF ( numberpattern1 ) %]
178
                [% numberpattern.label %]
233
                    Number only
179
            </li>
234
                [% END %]
180
            <li><table>
235
                [% IF ( numberpattern2 ) %]
181
            <tr>
236
                    Volume, number, issue
182
                <td>Starting with:</td>
237
                [% END %]
183
                [% IF (has_X) %]
238
                [% IF ( numberpattern3 ) %]
184
                    <td align="center">[% lastvalue1 %]</td>
239
                    Volume, number
240
                [% END %]
185
                [% END %]
241
                [% IF ( numberpattern4 ) %]
186
                [% IF (has_Y) %]
242
                    Volume, issue
187
                    <td align="center">[% lastvalue2 %]</td>
243
                [% END %]
188
                [% END %]
244
                [% IF ( numberpattern5 ) %]
189
                [% IF (has_Z) %]
245
                    Number, issue
190
                    <td align="center">[% lastvalue3 %]</td>
246
                [% END %]
191
                [% END %]
247
                [% IF ( numberpattern8 ) %]
192
            </tr>
248
                    Year/Number
193
            <tr>
194
                <td>Rollover:</td>
195
                [% IF (has_X) %]
196
                    <td align="center">[% numberpattern.whenmorethan1 %]</td>
249
                [% END %]
197
                [% END %]
250
                [% IF ( numberpattern6 ) %]
198
                [% IF (has_Y) %]
251
                    Seasonal only
199
                    <td align="center">[% numberpattern.whenmorethan2 %]</td>
252
                [% END %]
200
                [% END %]
253
                [% IF ( numberpattern7 ) %]
201
                [% IF (has_Z) %]
254
                    None of the above
202
                    <td align="center">[% numberpattern.whenmorethan3 %]</td>
255
                [% END %]
203
                [% END %]
256
            </li>
257
            <li><table>
258
            <tr><td>Starting with:</td>
259
                <td align="center">[% lastvalue1 %]</td>
260
            [% IF ( lastvalue2 ) %]
261
                <td align="center">&nbsp; 
262
                    [% lastvalue2 %]
263
                </td>
264
            [% END %]
265
            [% IF ( lastvalue3 ) %]
266
                <td align="center">&nbsp; 
267
                    [% lastvalue3 %]
268
                </td>
269
            [% END %]
270
            </tr>
271
            <tr><td>Rollover:</td>
272
                <td align="center">
273
                    [% IF ( whenmorethan1 < 9999999 ) %][% whenmorethan1 %][% ELSE %]Never[% END %]
274
                </td>
275
            [% IF ( whenmorethan2 ) %]
276
                <td align="center">&nbsp;
277
                    [% IF ( whenmorethan2 < 9999999 ) %][% whenmorethan2 %][% ELSE %]Never[% END %]
278
                </td>
279
            [% END %]
280
            [% IF ( whenmorethan3 ) %]
281
                <td align="center">&nbsp;
282
                    [% IF ( whenmorethan3 < 9999999 ) %][% whenmorethan3 %][% ELSE %]Never[% END %]
283
                </td>
284
            [% END %]
285
            </tr>
204
            </tr>
286
            </table></li>
205
            </table></li>
287
            [% IF ( irregular_issues ) %]
206
            [% IF ( irregular_issues ) %]
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/serials/subscription-frequencies.tt (+215 lines)
Line 0 Link Here
1
[% INCLUDE 'doc-head-open.inc' %]
2
<title>Koha &rsaquo; Serials &rsaquo; Frequencies</title>
3
[% INCLUDE 'doc-head-close.inc' %]
4
<script type="text/javascript">
5
//<![CDATA[
6
function confirmDelete() {
7
  return confirm(_("Are you sure you want to delete this subscription frequency?"));
8
}
9
10
function check_form() {
11
    var description = $("#description").val();
12
    var unit = $("#unit").val();
13
    var issuesperunit = $("#issuesperunit").val();
14
    var unitsperissue = $("#unitsperissue").val();
15
    var alert_msg = _("Some fields are not valid:") + "\n";
16
    var errors = 0;
17
18
    if(description.length == 0) {
19
        alert_msg += "\t - " + _("Description is required");
20
        errors ++;
21
    }
22
    if(unit.length > 0) {
23
        if(isNaN(issuesperunit) || issuesperunit == 0) {
24
            alert_msg += "\n\t - " + _("Issues per unit is required")
25
                + " " + _("(must be a number greater than 0)");
26
            errors ++;
27
        }
28
        if(isNaN(unitsperissue) || unitsperissue == 0) {
29
            alert_msg += "\n\t - " + _("Units per issue is required")
30
                + " " + _("(must be a number greater than 0)");
31
            errors ++;
32
        }
33
        if(issuesperunit > 1 && unitsperissue > 1) {
34
            alert_msg += "\n\t - " + _("One of 'issues per unit' and 'units per issue' must be equal to 1");
35
            errors ++;
36
        }
37
    }
38
39
    if(errors == 0) {
40
        return true;
41
    }
42
43
    alert(alert_msg);
44
    return false;
45
}
46
47
function show_blocking_subs() {
48
    $("#blocking_subs").show();
49
}
50
51
$(document).ready(function() {
52
    $("#issuesperunit").change(function() {
53
        var value = $(this).val();
54
        if(!isNaN(value) && value > 1) {
55
            $("#unitsperissue").val(1);
56
        }
57
    });
58
    $("#unitsperissue").change(function() {
59
        var value = $(this).val();
60
        if(!isNaN(value) && value > 1) {
61
            $("#issuesperunit").val(1);
62
        }
63
    });
64
});
65
//]]>
66
</script>
67
</head>
68
69
<body>
70
[% INCLUDE 'header.inc' %]
71
[% INCLUDE 'serials-search.inc' %]
72
73
<div id="breadcrumbs">
74
    <a href="/cgi-bin/koha/mainpage.pl">Home</a> &rsaquo;
75
    <a href="/cgi-bin/koha/serials/serials-home.pl">Serials</a> &rsaquo;
76
    <a href="/cgi-bin/koha/serials/subscription-frequencies.pl">Frequencies</a>
77
</div>
78
79
<div id="doc3" class="yui-t2">
80
81
<div id="bd">
82
  <div id="yui-main">
83
    <div class="yui-b">
84
      [% IF (new or modify) %]
85
        [% IF (new) %]
86
          <h1>New frequency</h1>
87
        [% ELSE %]
88
          <h1>Modify frequency: [% description %]</h1>
89
        [% END %]
90
        <form action="/cgi-bin/koha/serials/subscription-frequencies.pl" method="post" onsubmit="return check_form();">
91
          [% IF (modify) %]
92
            <input type="hidden" name="id" value="[% id %]" />
93
            <input type="hidden" name="op" value="savemod" />
94
          [% ELSE %]
95
            <input type="hidden" name="op" value="savenew" />
96
          [% END %]
97
          <fieldset class="rows">
98
            <ol>
99
              <li>
100
                <label for="description">Description:</label>
101
                <input type="text" id="description" name="description" value="[% description %]" />
102
              </li>
103
              <li>
104
                <label for="unit">Unit</label>
105
                <select id="unit" name="unit">
106
                  <option value="">None</option>
107
                  [% FOREACH unit IN units_loop %]
108
                    [% IF (unit.selected) %]
109
                      <option selected="selected" value="[% unit.val %]">
110
                    [% ELSE %]
111
                      <option value="[% unit.val %]">
112
                    [% END %]
113
                      [% unit.val %]
114
                    </option>
115
                  [% END %]
116
                </select>
117
              </li>
118
              <li><span class="hint">Note: one of the two following fields must be equal to 1</span></li>
119
              <li>
120
                <label for="issuesperunit">Issues per unit</label>
121
                [% IF (new) %]
122
                  <input type="text" id="issuesperunit" name="issuesperunit" value="1" size="3" />
123
                [% ELSE %]
124
                  <input type="text" id="issuesperunit" name="issuesperunit" value="[% issuesperunit %]" size="3" />
125
                [% END %]
126
              </li>
127
              <li>
128
                <label for="unitsperissue">Units per issue</label>
129
                [% IF (new) %]
130
                  <input type="text" id="unitsperissue" name="unitsperissue" value="1" size="3" />
131
                [% ELSE %]
132
                  <input type="text" id="unitsperissue" name="unitsperissue" value="[% unitsperissue %]" size="3" />
133
                [% END %]
134
              </li>
135
              <li>
136
                <label for="displayorder">Display order</label>
137
                <input type="text" id="displayorder" name="displayorder" value="[% displayorder %]" size="3" />
138
              </li>
139
            </ol>
140
          </fieldset>
141
          <fieldset class="action">
142
            <input type="submit" value="Save" />
143
            <input type="button" value="Cancel" onclick="window.location='/cgi-bin/koha/serials/subscription-frequencies.pl'" />
144
          </fieldset>
145
        </form>
146
      [% ELSE %]
147
        <h1>Frequencies</h1>
148
        [% IF still_used %]
149
            <div class="dialog">
150
                <p>
151
                    This frequency is still used by [% subscriptions.size %]
152
                    subscription(s). Do you still want to delete it?
153
                </p>
154
                <p><a href="#" onclick="show_blocking_subs(); return false;">Show subscriptions</a></p>
155
                <ul id="blocking_subs" style="display:none">
156
                    [% FOREACH sub IN subscriptions %]
157
                        <li style="list-style-type:none">
158
                            <a href="/cgi-bin/koha/serials/subscription-detail.pl?subscriptionid=[% sub.subscriptionid %]">[% sub.title %]</a>
159
                        </li>
160
                    [% END %]
161
                </ul>
162
163
                <form action="" method="get">
164
                    <input type="hidden" name="op" value="del" />
165
                    <input type="hidden" name="confirm" value="1" />
166
                    <input type="hidden" name="frequencyid" value="[% frequencyid %]" />
167
                    <input type="submit" class="approve" value="Yes, delete" />
168
                </form>
169
                <form action="" method="get">
170
                    <input type="submit" class="deny" value="No, don't delete" />
171
                </form>
172
            </div>
173
        [% END %]
174
        <a href="/cgi-bin/koha/serials/subscription-frequencies.pl?op=new">New frenquency</a>
175
176
        [% IF (frequencies_loop.size) %]
177
          <table id="frequenciest">
178
            <thead>
179
              <tr>
180
                <th>Description</th>
181
                <th>Unit</th>
182
                <th>Issues per unit</th>
183
                <th>Units per issue</th>
184
                <th>Display order</th>
185
                <th>&nbsp;</th>
186
              </tr>
187
            </thead>
188
            <tbody>
189
              [% FOREACH frequency IN frequencies_loop %]
190
                <tr>
191
                  <td>[% frequency.description %]</td>
192
                  <td>[% frequency.unit %]</td>
193
                  <td>[% frequency.issuesperunit %]</td>
194
                  <td>[% frequency.unitsperissue %]</td>
195
                  <td>[% frequency.displayorder %]</td>
196
                  <td>
197
                    <a href="/cgi-bin/koha/serials/subscription-frequencies.pl?op=modify&frequencyid=[% frequency.id %]">Modify</a> |
198
                    <a href="/cgi-bin/koha/serials/subscription-frequencies.pl?op=del&frequencyid=[% frequency.id %]">Delete</a>
199
                  </td>
200
                </tr>
201
              [% END %]
202
            </tbody>
203
          </table>
204
        [% ELSE %]
205
          <p>There is no defined frequency.</p>
206
        [% END %]
207
      [% END %]
208
209
    </div>
210
  </div>
211
  <div class="yui-b">
212
    [% INCLUDE 'serials-menu.inc' %]
213
  </div>
214
</div>
215
[% INCLUDE 'intranet-bottom.inc' %]
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/serials/subscription-history.tt (+60 lines)
Line 0 Link Here
1
[% USE KohaDates %]
2
3
[% INCLUDE 'doc-head-open.inc' %]
4
<title>Koha &rsaquo; Serials &rsaquo; Subscription history</title>
5
[% INCLUDE 'doc-head-close.inc' %]
6
</head>
7
8
<body>
9
[% INCLUDE 'header.inc' %]
10
[% INCLUDE 'serials-search.inc' %]
11
12
<div id="breadcrumbs"><a href="/cgi-bin/koha/mainpage.pl">Home</a> &rsaquo; <a href="/cgi-bin/koha/serials/serials-home.pl">Serials</a> &rsaquo; Subscription history</div>
13
14
<div id="doc3" class="yui-t2">
15
16
<div id="bd">
17
  <div id="yui-main">
18
    <div class="yui-b">
19
      <h1>Subscription history for [% title %]</h1>
20
        <div id="subscription_form_history">
21
          <form method="post" action="/cgi-bin/koha/serials/subscription-history.pl">
22
            <input type="hidden" name="op" value="mod" />
23
            <input type="hidden" name="subscriptionid" value="[% subscriptionid %]" />
24
            <p>Hint : you can update the serial history manually. This can be useful for an old subscription or to clean the existing history. Modify those fields with care, as future serial recieve will continue to update them automatically.</p>
25
            <table>
26
              <tr>
27
                <td>Subscription start date</td>
28
                <td><input type="text" name="histstartdate" value="[% histstartdate | $KohaDates %]" /> (start date of the 1st subscription)</td>
29
              </tr>
30
              <tr>
31
                <td>Subscription end date</td>
32
                <td><input type="text" name="histenddate" value="[% histenddate | $KohaDates %]" />(if empty, subscription is still active)</td>
33
              </tr>
34
              <tr>
35
                <td>Received issues</td>
36
                <td><textarea name="receivedlist" cols="60" rows="5">[% receivedlist %]</textarea></td>
37
              </tr>
38
              <tr>
39
                <td>Missing issues</td>
40
                <td><textarea name="missinglist" cols="60" rows="5">[% missinglist %]</textarea></td>
41
              </tr>
42
              <tr>
43
                <td>Note for OPAC</td>
44
                <td><textarea name="opacnote" cols="60" rows="5">[% opacnote %]</textarea></td>
45
              </tr>
46
              <tr>
47
                <td>Note for staff</td>
48
                <td><textarea name="librariannote" cols="60" rows="5">[% librariannote %]</textarea></td>
49
              </tr>
50
            </table>
51
            <input type="submit" value="Save subscription history"  />
52
          </form>
53
        </div>
54
    </div>
55
  </div>
56
  <div class="yui-b">
57
    [% INCLUDE 'serials-menu.inc' %]
58
  </div>
59
</div>
60
[% INCLUDE 'intranet-bottom.inc' %]
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/serials/subscription-numberpatterns.tt (+333 lines)
Line 0 Link Here
1
[% INCLUDE 'doc-head-open.inc' %]
2
<title>Koha &rsaquo; Serials &rsaquo; Number patterns</title>
3
[% INCLUDE 'doc-head-close.inc' %]
4
[% INCLUDE 'calendar.inc' %]
5
<script type="text/javascript">
6
//<![CDATA[
7
[% IF (new or modify) %]
8
  function testPattern() {
9
      var frequencyid = $("#frequency").val();
10
      var firstacquidate = $("#firstacquidate").val();
11
      var error = 0;
12
      var error_msg = "";
13
      if(frequencyid == undefined || frequencyid == "") {
14
          error_msg += _("- Frequency is not defined\n");
15
          error ++;
16
      }
17
      if(firstacquidate == undefined || firstacquidate == "") {
18
          error_msg += _("- First publication date is not defined\n");
19
          error ++;
20
      }
21
22
      if(error){
23
          alert(_("Cannot test prediction pattern for the following reason(s):\n\n")
24
              + error_msg);
25
          return false;
26
      }
27
28
      var ajaxData = {
29
          'custompattern': true,
30
      };
31
      var ajaxParams = [
32
          'firstacquidate', 'subtype', 'sublength', 'frequency', 'numberingmethod',
33
          'lastvalue1', 'lastvalue2', 'lastvalue3', 'add1', 'add2', 'add3',
34
          'every1', 'every2', 'every3', 'innerloop1', 'innerloop2', 'innerloop3',
35
          'setto1', 'setto2', 'setto3', 'numbering1', 'numbering2', 'numbering3',
36
          'whenmorethan1', 'whenmorethan2', 'whenmorethan3', 'locale'
37
      ];
38
      for(i in ajaxParams) {
39
          var param = ajaxParams[i];
40
          var value = $("#"+param).val();
41
          if(value.length > 0)
42
              ajaxData[param] = value;
43
      }
44
45
      $.ajax({
46
          url: "/cgi-bin/koha/serials/showpredictionpattern.pl",
47
          data: ajaxData,
48
          async: false,
49
          dataType: "text",
50
          success: function(data) {
51
              $("#predictionpattern").html(data);
52
          }
53
      });
54
  }
55
[% END %]
56
57
function show_blocking_subs() {
58
    $("#blocking_subs").show();
59
}
60
//]]>
61
</script>
62
</head>
63
64
<body>
65
[% INCLUDE 'header.inc' %]
66
[% INCLUDE 'serials-search.inc' %]
67
68
<div id="breadcrumbs">
69
    <a href="/cgi-bin/koha/mainpage.pl">Home</a> &rsaquo;
70
    <a href="/cgi-bin/koha/serials/serials-home.pl">Serials</a> &rsaquo;
71
    <a href="/cgi-bin/koha/serials/subscription-numberpatterns.pl">Numbering patterns</a>
72
</div>
73
74
<div id="doc3" class="yui-t2">
75
76
<div id="bd">
77
  <div id="yui-main">
78
    <div class="yui-b">
79
      [% IF (new or modify) %]
80
        <div class="yui-g">
81
          [% IF (new) %]
82
            <h1>New number pattern</h1>
83
            [% IF (error_existing_numberpattern) %]
84
              <div class="dialog">
85
                <p>A pattern with this name already exists.</p>
86
              </div>
87
            [% END %]
88
          [% ELSE %]
89
            <h1>Modify pattern: [% label %]</h1>
90
            [% IF (error_existing_numberpattern) %]
91
              <div class="dialog">
92
                <p>Another pattern with this name already exists.</p>
93
              </div>
94
            [% END %]
95
          [% END %]
96
        </div>
97
        <div class="yui-g">
98
          <form action="/cgi-bin/koha/serials/subscription-numberpatterns.pl" method="post">
99
            [% IF (new) %]
100
              <input type="hidden" name="op" value="savenew" />
101
            [% ELSE %]
102
              <input type="hidden" name="op" value="savemod" />
103
              <input type="hidden" name="id" value="[% id %]" />
104
            [% END %]
105
            <fieldset class="rows">
106
              <ol>
107
                <li>
108
                  <label for="label">Name:</label>
109
                  <input type="text" id="label" name="label" value="[% label %]" />
110
                </li>
111
                <li>
112
                  <label for="description">Description:</label>
113
                  <input type="text" id="description" name="description" value="[% description %]" />
114
                </li>
115
                <li>
116
                  <label for="numberingmethod">Numbering formula:</label>
117
                  <input type="text" id="numberingmethod" name="numberingmethod" value="[% numberingmethod %]" />
118
                </li>
119
                <li>
120
                  <label for="displayorder">Display order:</label>
121
                  <input type="text" id="displayorder" name="displayorder" value="[% displayorder %]" />
122
                </li>
123
              </ol>
124
              <table>
125
                <thead>
126
                  <tr>
127
                    <th>&nbsp;</th>
128
                    <th>X</th>
129
                    <th>Y</th>
130
                    <th>Z</th>
131
                  </tr>
132
                </thead>
133
                <tbody>
134
                  <tr>
135
                    <td>Label</td>
136
                    <td><input type="text" id="label1" name="label1" value="[% label1 %]" /></td>
137
                    <td><input type="text" id="label2" name="label2" value="[% label2 %]" /></td>
138
                    <td><input type="text" id="label3" name="label3" value="[% label3 %]" /></td>
139
                  </tr>
140
                  <tr>
141
                    <td>Add</td>
142
                    <td><input type="text" id="add1" name="add1" value="[% add1 %]" /></td>
143
                    <td><input type="text" id="add2" name="add2" value="[% add2 %]" /></td>
144
                    <td><input type="text" id="add3" name="add3" value="[% add3 %]" /></td>
145
                  </tr>
146
                  <tr>
147
                    <td>Every</td>
148
                    <td><input type="text" id="every1" name="every1" value="[% every1 %]" /></td>
149
                    <td><input type="text" id="every2" name="every2" value="[% every2 %]" /></td>
150
                    <td><input type="text" id="every3" name="every3" value="[% every3 %]" /></td>
151
                  </tr>
152
                  <tr>
153
                    <td>Set back to</td>
154
                    <td><input type="text" id="setto1" name="setto1" value="[% setto1 %]" /></td>
155
                    <td><input type="text" id="setto2" name="setto2" value="[% setto2 %]" /></td>
156
                    <td><input type="text" id="setto3" name="setto3" value="[% setto3 %]" /></td>
157
                  </tr>
158
                  <tr>
159
                    <td>When more than</td>
160
                    <td><input type="text" id="whenmorethan1" name="whenmorethan1" value="[% whenmorethan1 %]" /></td>
161
                    <td><input type="text" id="whenmorethan2" name="whenmorethan2" value="[% whenmorethan2 %]" /></td>
162
                    <td><input type="text" id="whenmorethan3" name="whenmorethan3" value="[% whenmorethan3 %]" /></td>
163
                  </tr>
164
                  <tr>
165
                    [% BLOCK numbering_select %]
166
                      <select id="[% name %]" name="[% name %]" />
167
                        <option value=""></option>
168
                        [% IF (value == "dayname") %]
169
                            <option selected="selected" value="dayname">Name of day</option>
170
                        [% ELSE %]
171
                            <option value="dayname">Name of day</option>
172
                        [% END %]
173
                        [% IF (value == "monthname") %]
174
                            <option selected="selected" value="monthname">Name of month</option>
175
                        [% ELSE %]
176
                            <option value="monthname">Name of month</option>
177
                        [% END %]
178
                        [% IF (value == "season") %]
179
                            <option selected="selected" value="season">Name of season</option>
180
                        [% ELSE %]
181
                            <option value="season">Name of season</option>
182
                        [% END %]
183
                      </select>
184
                    [% END %]
185
                    <td>Fromatting</td>
186
                    <td>[% PROCESS numbering_select name="numbering1" value=numbering1 %]</td>
187
                    <td>[% PROCESS numbering_select name="numbering2" value=numbering2 %]</td>
188
                    <td>[% PROCESS numbering_select name="numbering3" value=numbering3 %]</td>
189
                  </tr>
190
                </tbody>
191
              </table>
192
            </fieldset>
193
            <fieldset class="action">
194
              <input type="submit" value="Save" />
195
              <input type="reset" value="Reset" />
196
              <input type="button" value="Cancel" onclick="window.location = '/cgi-bin/koha/serials/subscription-numberpatterns.pl';" />
197
            </fieldset>
198
          </form>
199
        </div>
200
        <div class="yui-g">
201
          <form>
202
            <fieldset class="rows">
203
              <legend>Test prediction pattern</legend>
204
              <ol>
205
                <li>
206
                  <label for="frequency">Frequency:</label>
207
                  <select id="frequency">
208
                    [% FOREACH frequency IN frequencies_loop %]
209
                      <option value="[% frequency.id %]">[% frequency.description %]</option>
210
                    [% END %]
211
                  </select>
212
                </li>
213
                <li>
214
                  <label for="firstacquidate">First issue publication date</label>
215
                  <input type="text" id="firstacquidate" class="datepicker" size="10" />
216
                </li>
217
                <li>
218
                  <label for="sublength">Subscription length:</label>
219
                  <select id="subtype">
220
                    [% FOREACH subtype IN subtypes_loop %]
221
                      <option value="[% subtype.value %]">[% subtype.value %]</option>
222
                    [% END %]
223
                  </select>
224
                  <input type="text" id="sublength" size="3" />
225
                </li>
226
                <li>
227
                  <label for="locale">Locale:</label>
228
                  <select id="locale" name="locale">
229
                      <option value=""></option>
230
                      [% FOREACH locale IN locales %]
231
                        <option value="[% locale %]">[% locale %]</option>
232
                      [% END %]
233
                    </select>
234
                  <span class="hint">If empty, system locale is used</span>
235
                </li>
236
              </ol>
237
              <table>
238
                <thead>
239
                  <tr>
240
                    <th>&nbsp;</th>
241
                    <th>X</th>
242
                    <th>Y</th>
243
                    <th>Z</th>
244
                  </tr>
245
                </thead>
246
                <tbody>
247
                  <tr>
248
                    <td>Begins with</td>
249
                    <td><input type="text" id="lastvalue1" name="lastvalue1" value="[% lastvalue1 %]" /></td>
250
                    <td><input type="text" id="lastvalue2" name="lastvalue2" value="[% lastvalue2 %]" /></td>
251
                    <td><input type="text" id="lastvalue3" name="lastvalue3" value="[% lastvalue3 %]" /></td>
252
                  </tr>
253
                  <tr>
254
                    <td>Inner counter</td>
255
                    <td><input type="text" id="innerloop1" name="innerloop1" value="[% innerloop1 %]" /></td>
256
                    <td><input type="text" id="innerloop2" name="innerloop2" value="[% innerloop2 %]" /></td>
257
                    <td><input type="text" id="innerloop3" name="innerloop3" value="[% innerloop3 %]" /></td>
258
                  </tr>
259
                </tbody>
260
              </table>
261
              <fieldset class="action">
262
              <input type="button" value="Test pattern" onclick="testPattern();" />
263
              </fieldset>
264
              <div id="predictionpattern"></div>
265
            </fieldset>
266
          </form>
267
        </div>
268
      [% ELSE %]
269
        <h1>Number patterns</h1>
270
        [% IF still_used %]
271
            <div class="dialog">
272
                <p>
273
                    This pattern is still used by [% subscriptions.size %]
274
                    subscription(s). Do you still want to delete it?
275
                </p>
276
                <p><a href="#" onclick="show_blocking_subs(); return false;">Show subscriptions</a></p>
277
                <ul id="blocking_subs" style="display:none">
278
                    [% FOREACH sub IN subscriptions %]
279
                        <li style="list-style-type:none">
280
                            <a href="/cgi-bin/koha/serials/subscription-detail.pl?subscriptionid=[% sub.subscriptionid %]">[% sub.title %]</a>
281
                        </li>
282
                    [% END %]
283
                </ul>
284
285
                <form action="" method="get">
286
                    <input type="hidden" name="op" value="del" />
287
                    <input type="hidden" name="confirm" value="1" />
288
                    <input type="hidden" name="id" value="[% id %]" />
289
                    <input type="submit" class="approve" value="Yes, delete" />
290
                </form>
291
                <form action="" method="get">
292
                    <input type="submit" class="deny" value="No, don't delete" />
293
                </form>
294
            </div>
295
        [% END %]
296
        <a href="/cgi-bin/koha/serials/subscription-numberpatterns.pl?op=new">New numbering pattern</a>
297
        [% IF (numberpatterns_loop.size) %]
298
          <table id="numberpatternst">
299
            <thead>
300
              <tr>
301
                <th>Name</th>
302
                <th>Description</th>
303
                <th>Numbering formula</th>
304
                <th>Display order</th>
305
                <th>&nbsp;</th>
306
              </tr>
307
            </thead>
308
            <tbody>
309
              [% FOREACH numberpattern IN numberpatterns_loop %]
310
                <tr>
311
                  <td>[% numberpattern.label %]</td>
312
                  <td>[% numberpattern.description %]</td>
313
                  <td>[% numberpattern.numberingmethod %]</td>
314
                  <td>[% numberpattern.displayorder %]</td>
315
                  <td>
316
                    <a href="/cgi-bin/koha/serials/subscription-numberpatterns.pl?op=modify&id=[% numberpattern.id %]">Edit</a> |
317
                    <a href="/cgi-bin/koha/serials/subscription-numberpatterns.pl?op=del&id=[% numberpattern.id %]">Delete</a>
318
                  </td>
319
                </tr>
320
              [% END %]
321
            </tbody>
322
          </table>
323
        [% ELSE %]
324
          <p>There is no existing patterns.</p>
325
        [% END %]
326
      [% END %]
327
    </div>
328
  </div>
329
  <div class="yui-b">
330
    [% INCLUDE 'serials-menu.inc' %]
331
  </div>
332
</div>
333
[% INCLUDE 'intranet-bottom.inc' %]
(-)a/serials/create-numberpattern.pl (+42 lines)
Line 0 Link Here
1
#!/usr/bin/perl
2
3
use CGI;
4
use C4::Context;
5
use C4::Serials::Numberpattern;
6
use URI::Escape;
7
use strict;
8
use warnings;
9
10
my $input = new CGI;
11
12
my $numberpattern;
13
foreach (qw/ numberingmethod label1 label2 label3 add1 add2 add3
14
  every1 every2 every3 setto1 setto2 setto3 whenmorethan1 whenmorethan2
15
  whenmorethan3 numbering1 numbering2 numbering3 locale /) {
16
    $numberpattern->{$_} = $input->param($_);
17
}
18
# patternname is label in database
19
$numberpattern->{'label'} = $input->param('patternname');
20
21
# Check if pattern already exist in database
22