Bug 25184: (RM follow-up) Make DB update idempotent
[koha.git] / acqui / updatesupplier.pl
blob5b077f171e07e2d7400387f2eac1c26e51cd4101
1 #!/usr/bin/perl
3 #script to show suppliers and orders
4 #written by chris@katipo.co.nz 23/2/2000
7 # Copyright 2000-2002 Katipo Communications
8 # Copyright 2008-2009 BibLibre SARL
10 # This file is part of Koha.
12 # Koha is free software; you can redistribute it and/or modify it
13 # under the terms of the GNU General Public License as published by
14 # the Free Software Foundation; either version 3 of the License, or
15 # (at your option) any later version.
17 # Koha is distributed in the hope that it will be useful, but
18 # WITHOUT ANY WARRANTY; without even the implied warranty of
19 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
20 # GNU General Public License for more details.
22 # You should have received a copy of the GNU General Public License
23 # along with Koha; if not, see <http://www.gnu.org/licenses>.
25 =head1 NAME
27 updatesupplier.pl
29 =head1 DESCRIPTION
31 this script allow to update or create (if id == 0)
32 a supplier. This script is called from acqui/supplier.pl.
34 =head1 CGI PARAMETERS
36 All informations regarding this supplier are listed on input parameter.
37 Here is the list :
39 supplier, id, company, company_postal, physical, company_phone,
40 physical, company_phone, company_fax, website, company_email, notes,
41 status, publishers_imprints, list_currency, gst, list_gst, invoice_gst,
42 discount, tax_rate, contact_name, contact_position, contact_phone,
43 contact_altphone, contact_fax, contact_email, contact_notes,
44 contact_claimacquisition, contact_claimissues, contact_acqprimary,
45 contact_serialsprimary.
47 =cut
49 use Modern::Perl;
50 use List::Util;
51 use C4::Context;
52 use C4::Auth;
54 use C4::Biblio;
55 use C4::Output;
57 use Koha::Acquisition::Bookseller::Contacts;
58 use Koha::Acquisition::Booksellers;
59 use CGI qw ( -utf8 );
61 my $input=new CGI;
63 checkauth( $input, 0, { acquisition => 'vendors_manage' }, 'intranet' );
65 #print $input->header();
66 my $booksellerid=$input->param('booksellerid');
67 #print startpage;
68 my %data;
69 $data{'id'}=$booksellerid;
71 $data{'name'}=$input->param('company');
72 $data{'postal'}=$input->param('company_postal');
73 my $address=$input->param('physical');
74 my @addresses=split('\n',$address);
75 $data{'address1'}=$addresses[0];
76 $data{'address2'}=$addresses[1];
77 $data{'address3'}=$addresses[2];
78 $data{'address4'}=$addresses[3];
79 $data{'phone'}=$input->param('company_phone');
80 $data{'accountnumber'}=$input->param('accountnumber');
81 $data{'fax'}=$input->param('company_fax');
82 $data{'url'}=$input->param('website');
83 # warn "".$data{'contnotes'};
84 $data{'notes'}=$input->param('notes');
85 $data{'active'}=$input->param('status');
87 $data{'listprice'}=$input->param('list_currency');
88 $data{'invoiceprice'}=$input->param('invoice_currency');
89 $data{'gstreg'}=$input->param('gst');
90 $data{'listincgst'}=$input->param('list_gst');
91 $data{'invoiceincgst'}=$input->param('invoice_gst');
92 #have to transform this into fraction so it's easier to use
93 $data{'tax_rate'} = $input->param('tax_rate');
94 $data{'discount'} = $input->param('discount');
95 $data{deliverytime} = $input->param('deliverytime');
96 $data{'active'}=$input->param('status');
97 my @contacts;
98 my %contact_info;
100 foreach (qw(id name position phone altphone fax email notes orderacquisition claimacquisition claimissues acqprimary serialsprimary)) {
101 $contact_info{$_} = [ $input->multi_param('contact_' . $_) ];
104 for my $cnt (0..scalar(@{$contact_info{'id'}})) {
105 my %contact;
106 my $real_contact;
107 foreach (qw(id name position phone altphone fax email notes orderacquisition claimacquisition claimissues acqprimary serialsprimary)) {
108 $contact{$_} = $contact_info{$_}->[$cnt];
109 $real_contact = 1 if $contact{$_};
111 push @contacts, \%contact if $real_contact;
114 if($data{'name'}) {
115 if ( $data{id} ) {
116 # Update
117 my $bookseller = Koha::Acquisition::Booksellers->find( $data{id} )->set(\%data)->store;
118 # Delete existing contacts
119 $bookseller->contacts->delete;
120 } else {
121 # Insert
122 delete $data{id}; # Remove the key if exists
123 my $bookseller = Koha::Acquisition::Bookseller->new( \%data )->store;
124 $data{id} = $bookseller->id;
126 # Insert contacts
127 for my $contact ( @contacts ) {
128 $contact->{booksellerid} = $data{id};
129 Koha::Acquisition::Bookseller::Contact->new( $contact )->store
132 #redirect to booksellers.pl
133 print $input->redirect("booksellers.pl?booksellerid=".$data{id});
134 } else {
135 print $input->redirect("supplier.pl?op=enter"); # fail silently.