3 # Copyright 2010 BibLibre SARL
5 # This file is part of Koha.
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
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.
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.
29 This plugin is specific to FFZG but could be used as a base for similar operations.
30 It is used for stocknumber computation.
32 If the user send an empty string, we return a simple incremented stocknumber for current year.
33 If a prefix is submited, we look for the highest stocknumber with this prefix, and return it incremented.
34 In this case, a stocknumber has this form : "YEAR-0009678570".
35 - YEAR is numeric 4-digit year, like 2012
37 - digits, without leading zero
39 Required database changes:
41 create unique index item_stocknumer on items(stocknumber) ;
43 create table ffzg_inventarna_knjiga (
44 id int not null auto_increment primary key,
47 biblionumber int not null,
48 last_update timestamp default current_timestamp on update current_timestamp,
49 unique index ffzg_inv_br(year,num)
54 sub plugin_parameters {
57 sub plugin_javascript {
58 my ($dbh,$record,$tagslib,$field_number,$tabloop) = @_;
61 <script type='text/javascript'>
62 function Focus$field_number() {
66 function Blur$field_number() {
70 function Clic$field_number() {
71 var code = document.getElementById('$field_number');
73 if ( ! confirm('Jeste li sigurni da želite dodijeliti novi inventarni broj?') )
76 var url = '../cataloguing/plugin_launcher.pl?plugin_name=ffzg-stocknumber.pl&code=' + code.value;
77 var blurcallbackstocknumber = {
78 success: function(o) {
79 var field = document.getElementById('$field_number');
80 field.value = o.responseText;
84 var transaction = YAHOO.util.Connect.asyncRequest('GET',url, blurcallbackstocknumber, null);
90 return ($field_number,$res);
97 my $code = $input->param('code');
98 my ( $year, $num ) = split(/-/,$code);
101 my $now = DateTime->now;
103 if ( $now->month == 1 && $now->day <= 15 ) {
108 warn "XXX plugin code = $code";
110 my ($template, $loggedinuser, $cookie) = get_template_and_user({
111 template_name => "cataloguing/value_builder/ajax.tmpl",
114 authnotrequired => 0,
115 flagsrequired => {editcatalogue => '*'},
121 my $dbh = C4::Context->dbh;
125 my $sth = $dbh->prepare("select max(num) from ffzg_inventarna_knjiga where year = ?");
126 $sth->execute($year);
128 my $max = $sth->fetchrow; # return null without any data
131 $sth = $dbh->prepare("insert into ffzg_inventarna_knjiga (year,num) values (?,?)");
132 $sth->execute( $year, $max );
141 return => $year . '-' . $num,
144 output_html_with_http_headers $input, $cookie, $template->output;