Bug 7688: Change subscription numbering pattern and frequencies

[koha.git] / serials / create-numberpattern.pl

diff --git a/serials/create-numberpattern.pl b/serials/create-numberpattern.pl
new file mode 100755 (executable)
index 0000000..d5e6abf
--- /dev/null
+++ b/serials/create-numberpattern.pl
@@ -0,0 +1,42 @@
+#!/usr/bin/perl
+
+use CGI;
+use C4::Context;
+use C4::Serials::Numberpattern;
+use URI::Escape;
+use strict;
+use warnings;
+
+my $input = new CGI;
+
+my $numberpattern;
+foreach (qw/ numberingmethod label1 label2 label3 add1 add2 add3
+  every1 every2 every3 setto1 setto2 setto3 whenmorethan1 whenmorethan2
+  whenmorethan3 numbering1 numbering2 numbering3 locale /) {
+    $numberpattern->{$_} = $input->param($_);
+}
+# patternname is label in database
+$numberpattern->{'label'} = $input->param('patternname');
+
+# Check if pattern already exist in database
+my $dbh = C4::Context->dbh;
+my $query = qq{
+    SELECT id
+    FROM subscription_numberpatterns
+    WHERE STRCMP(label, ?) = 0
+};
+my $sth = $dbh->prepare($query);
+my $rv = $sth->execute($numberpattern->{'label'});
+my $numberpatternid;
+if($rv == 0) {
+    # Pattern does not exists
+    $numberpatternid = AddSubscriptionNumberpattern($numberpattern);
+} else {
+    ($numberpatternid) = $sth->fetchrow_array;
+    $numberpattern->{'id'} = $numberpatternid;
+    ModSubscriptionNumberpattern($numberpattern);
+}
+
+binmode STDOUT, ":utf8";
+print $input->header(-type => 'text/plain', -charset => 'UTF-8');
+print "{\"numberpatternid\":\"$numberpatternid\"}";