Bug 25184: (RM follow-up) Make DB update idempotent
[koha.git] / acqui / newordersuggestion.pl
blob54934967abbe5eb90404ad509bead02f33206626
1 #!/usr/bin/perl
3 # Copyright 2006 Biblibre
4 # Parts Copyright 2011 PTFS Europe
6 # This file is part of Koha.
8 # Koha is free software; you can redistribute it and/or modify it
9 # under the terms of the GNU General Public License as published by
10 # the Free Software Foundation; either version 3 of the License, or
11 # (at your option) any later version.
13 # Koha is distributed in the hope that it will be useful, but
14 # WITHOUT ANY WARRANTY; without even the implied warranty of
15 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
16 # GNU General Public License for more details.
18 # You should have received a copy of the GNU General Public License
19 # along with Koha; if not, see <http://www.gnu.org/licenses>.
21 =head1 NAME
23 newordersuggestion.pl
25 =head1 DESCRIPTION
27 this script allow to add an order from a existing suggestion.
28 The suggestion must have 'ACCEPTED' as status.
30 =head1 CGI PARAMETERS
32 =over 4
34 =item basketno
36 the number of this basket.
38 =item booksellerid
40 the bookseller who sells this record.
42 =item title
44 to filter on title when searching among ACCEPTED suggestion.
46 =item author
48 to filter on author when searching among ACCEPTED suggestion.
50 =item note
52 to filter on note when searching among ACCEPTED suggestion.
54 =item copyrightdate
56 =item publishercode
58 =item volumedesc
60 =item publicationyear
62 the publication year of this record.
64 =item place
66 =item isbn
68 the isbn of this suggestion.
70 =item duplicateNumber
72 is the biblionumber to put to the new suggestion.
74 =item suggestionid
76 the id of the suggestion to select.
78 =item op
80 can be equal to
81 * connectDuplicate :
82 then call to the function : ConnectSuggestionAndBiblio.
83 i.e set the biblionumber of this suggestion.
84 * else :
85 is the default value.
87 =back
89 =cut
91 use Modern::Perl;
93 use CGI qw ( -utf8 );
94 use C4::Auth; # get_template_and_user
95 use C4::Output;
96 use C4::Suggestions;
97 use C4::Biblio;
98 use C4::Budgets;
100 use Koha::Acquisition::Booksellers;
102 my $input = new CGI;
104 # getting the CGI params
105 my $basketno = $input->param('basketno');
106 my $booksellerid = $input->param('booksellerid');
107 my $author = $input->param('author');
108 my $title = $input->param('title');
109 my $publishercode = $input->param('publishercode');
110 my $op = $input->param('op');
111 my $suggestionid = $input->param('suggestionid');
112 my $duplicateNumber = $input->param('duplicateNumber');
113 my $uncertainprice = $input->param('uncertainprice');
115 $op = 'else' unless $op;
117 my $dbh = C4::Context->dbh;
118 my ( $template, $borrowernumber, $cookie ) = get_template_and_user(
120 template_name => "acqui/newordersuggestion.tt",
121 type => "intranet",
122 query => $input,
123 flagsrequired => { acquisition => 'order_manage' },
127 if ( $op eq 'connectDuplicate' ) {
128 ConnectSuggestionAndBiblio( $suggestionid, $duplicateNumber );
131 # getting all suggestions.
132 my $suggestions_loop = SearchSuggestion(
134 author => $author,
135 title => $title,
136 publishercode => $publishercode,
137 STATUS => 'ACCEPTED'
141 my $vendor = Koha::Acquisition::Booksellers->find( $booksellerid );
142 $template->param(
143 suggestions_loop => $suggestions_loop,
144 basketno => $basketno,
145 booksellerid => $booksellerid,
146 name => $vendor->name,
147 loggedinuser => $borrowernumber,
148 "op_$op" => 1,
151 output_html_with_http_headers $input, $cookie, $template->output;