|
Lines 1-7
Link Here
|
| 1 |
#!/usr/bin/perl |
1 |
#!/usr/bin/perl |
| 2 |
# Script that merge source bookseller (-f) into target bookseller (-t). |
|
|
| 3 |
|
2 |
|
| 4 |
use strict; |
3 |
# Copyright 2015 BibLibre |
|
|
4 |
# |
| 5 |
# This file is part of Koha. |
| 6 |
# |
| 7 |
# Koha is free software; you can redistribute it and/or modify it |
| 8 |
# under the terms of the GNU General Public License as published by |
| 9 |
# the Free Software Foundation; either version 3 of the License, or |
| 10 |
# (at your option) any later version. |
| 11 |
# |
| 12 |
# Koha is distributed in the hope that it will be useful, but |
| 13 |
# WITHOUT ANY WARRANTY; without even the implied warranty of |
| 14 |
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the |
| 15 |
# GNU General Public License for more details. |
| 16 |
# |
| 17 |
# You should have received a copy of the GNU General Public License |
| 18 |
# along with Koha; if not, see <http://www.gnu.org/licenses>. |
| 19 |
|
| 20 |
use Modern::Perl; |
| 5 |
|
21 |
|
| 6 |
use Koha::Acquisition::Bookseller; |
22 |
use Koha::Acquisition::Bookseller; |
| 7 |
use C4::Bookseller qw( DelBookseller ); |
23 |
use C4::Bookseller qw( DelBookseller ); |
|
Lines 9-27
use C4::Acquisition;
Link Here
|
| 9 |
use C4::Contract; |
25 |
use C4::Contract; |
| 10 |
|
26 |
|
| 11 |
use Getopt::Long; |
27 |
use Getopt::Long; |
|
|
28 |
use Pod::Usage; |
| 12 |
|
29 |
|
| 13 |
my ($help, $verbose, $mergefrom, $mergeto, $confirm); |
30 |
my ($help, $verbose, $mergefrom, $mergeto, $confirm); |
| 14 |
GetOptions( |
31 |
GetOptions( |
| 15 |
'h' => \$help, |
32 |
'help|h' => \$help, |
| 16 |
'v' => \$verbose, |
33 |
'verbose|v' => \$verbose, |
| 17 |
'f:s' => \$mergefrom, |
34 |
'from|f:s' => \$mergefrom, |
| 18 |
't:s' => \$mergeto, |
35 |
'to|t:s' => \$mergeto, |
| 19 |
'c' => \$confirm, |
36 |
'confirm|c' => \$confirm, |
| 20 |
); |
37 |
) || pod2usage(1); |
| 21 |
|
38 |
|
| 22 |
if ($help || !$mergefrom || !$mergeto) { |
39 |
if ($help || !$mergefrom || !$mergeto) { |
| 23 |
print_usage(); |
40 |
pod2usage(1); |
| 24 |
die; |
41 |
} |
|
|
42 |
|
| 43 |
if ($mergefrom eq $mergeto) { |
| 44 |
pod2usage('Source and target booksellers should be different.'); |
| 25 |
} |
45 |
} |
| 26 |
|
46 |
|
| 27 |
my $from_bookseller = Koha::Acquisition::Bookseller->fetch({id => $mergefrom}); |
47 |
my $from_bookseller = Koha::Acquisition::Bookseller->fetch({id => $mergefrom}); |
|
Lines 31-44
my $to_bookseller = Koha::Acquisition::Bookseller->fetch({id => $mergeto});
Link Here
|
| 31 |
die "Unknown bookseller id ($mergeto)" unless $to_bookseller; |
51 |
die "Unknown bookseller id ($mergeto)" unless $to_bookseller; |
| 32 |
|
52 |
|
| 33 |
my $report; |
53 |
my $report; |
| 34 |
foreach (qw(Aqbasketgroup Aqbasket Aqcontract Aqcontact Aqinvoice)) { |
54 |
foreach my $entity (qw(Aqbasketgroup Aqbasket Aqcontract Aqcontact Aqinvoice Deleteditem Item Subscription)) { |
| 35 |
my $rs = Koha::Database->new()->schema->resultset($_); |
55 |
my $rs = Koha::Database->new()->schema->resultset($entity); |
| 36 |
$rs = $rs->search({booksellerid => $mergefrom }); |
56 |
my $foreign_key = $entity eq 'Subscription' ? 'aqbooksellerid' : 'booksellerid'; |
|
|
57 |
$rs = $rs->search({$foreign_key => $mergefrom }); |
| 37 |
while (my $e = $rs->next) { |
58 |
while (my $e = $rs->next) { |
| 38 |
$e->set_column('booksellerid', $mergeto); |
59 |
$e->set_column('booksellerid', $mergeto); |
| 39 |
print "$_ n° " . $e->id() . " merged into bookseller n° $mergeto\n" if $verbose; |
60 |
print "$entity n° " . $e->id() . " merged into bookseller n° $mergeto\n" if $verbose; |
| 40 |
$e->update() if $confirm; |
61 |
$e->update() if $confirm; |
| 41 |
$report->{$_}++; |
62 |
$report->{$entity}++; |
| 42 |
} |
63 |
} |
| 43 |
} |
64 |
} |
| 44 |
|
65 |
|
|
Lines 48-65
print "\n" if $verbose;
Link Here
|
| 48 |
print_report($report); |
69 |
print_report($report); |
| 49 |
print "Nothing done (test only). Use confirm option to commit changes in database\n" unless $confirm; |
70 |
print "Nothing done (test only). Use confirm option to commit changes in database\n" unless $confirm; |
| 50 |
|
71 |
|
| 51 |
sub print_usage { |
|
|
| 52 |
print <<EOF |
| 53 |
Script to merge a bookselle into another |
| 54 |
parameters : |
| 55 |
\th : this help screen |
| 56 |
\tf : the bookseller id to merge. |
| 57 |
\tt : the bookseller id where to merge |
| 58 |
\tc : Perform changes in database. |
| 59 |
EOF |
| 60 |
; |
| 61 |
} |
| 62 |
|
| 63 |
sub print_report { |
72 |
sub print_report { |
| 64 |
my $report = shift; |
73 |
my $report = shift; |
| 65 |
|
74 |
|
|
Lines 67-69
sub print_report {
Link Here
|
| 67 |
print "$entity merged: $report->{$entity}\n"; |
76 |
print "$entity merged: $report->{$entity}\n"; |
| 68 |
} |
77 |
} |
| 69 |
} |
78 |
} |
| 70 |
- |
79 |
|
|
|
80 |
|
| 81 |
=head1 NAME |
| 82 |
|
| 83 |
merge source bookseller (-f) into target bookseller (-t) |
| 84 |
|
| 85 |
=head1 SYNOPSIS |
| 86 |
|
| 87 |
merge_booksellers.pl [-h|--help] [-v|--verbose] [-c|--confirm] --from=booksellerid --to=booksellerid |
| 88 |
|
| 89 |
=head1 OPTIONS |
| 90 |
|
| 91 |
=over |
| 92 |
|
| 93 |
=item B<-h|--help> |
| 94 |
|
| 95 |
Print a brief help message. |
| 96 |
|
| 97 |
=item B<--verbose> |
| 98 |
|
| 99 |
--verbose Show more information on what is done. |
| 100 |
|
| 101 |
=item B<--confirm> |
| 102 |
|
| 103 |
--confirm Commit the changes in database. Running without this |
| 104 |
parameter is like testing. It is recommanded to run without |
| 105 |
--confirm first to be sure of the changes. |
| 106 |
|
| 107 |
=item B<--from> |
| 108 |
|
| 109 |
--from=<booksellerid> The source bookseller identifier that will be merged in |
| 110 |
target bookseller. |
| 111 |
|
| 112 |
=item B<--to> |
| 113 |
|
| 114 |
--to=<booksellerid> The target bookseller identifier in which merge |
| 115 |
source bookseller. |
| 116 |
|
| 117 |
=back |
| 118 |
|
| 119 |
=cut |