fix -C, RT#82943

[freeside.git] / bin / part_pkg-bulk_change

diff --git a/bin/part_pkg-bulk_change b/bin/part_pkg-bulk_change
index 24cf189..5347da6 100755 (executable)
--- a/bin/part_pkg-bulk_change
+++ b/bin/part_pkg-bulk_change
@@ -1,14 +1,14 @@
 #!/usr/bin/perl
 
 use strict;
 #!/usr/bin/perl
 
 use strict;

-use vars qw( $opt_r $opt_m $opt_p $opt_o $opt_v $opt_t $opt_s $opt_S $opt_z $opt_Z );
+use vars qw( $opt_r $opt_m $opt_C $opt_p $opt_o $opt_v $opt_t $opt_s $opt_S $opt_z $opt_Z $opt_e $opt_u );

 use Getopt::Std;
 use FS::UID qw(adminsuidsetup);
 use FS::Record qw(qsearch qsearchs);
 use FS::part_pkg;
 use FS::part_pkg_option;
 
 use Getopt::Std;
 use FS::UID qw(adminsuidsetup);
 use FS::Record qw(qsearch qsearchs);
 use FS::part_pkg;
 use FS::part_pkg_option;
 

-getopts('rm:p:o:v:t:sSzZ');
+getopts('rm:C:p:o:v:t:sSzZe:u:');

 
 my $user = shift or &usage;
 adminsuidsetup $user;
 
 my $user = shift or &usage;
 adminsuidsetup $user;


@@ -17,7 +17,17 @@ my %search = ();
 $search{'plan'} = $opt_p if $opt_p;
 $search{'comment'} = $opt_m if $opt_m;
 
 $search{'plan'} = $opt_p if $opt_p;
 $search{'comment'} = $opt_m if $opt_m;
 

-foreach my $part_pkg ( qsearch('part_pkg',\%search) ) {
+my $extra_sql = '';
+$extra_sql = ( keys(%search) ? 'AND' : 'WHERE' ).
+             " classnum NOT IN ($opt_C)"
+  if $opt_C;
+
+foreach my $part_pkg ( qsearch({ 'table'     => 'part_pkg',
+                                 'hashref'   => \%search,
+                                 'extra_sql' => $extra_sql,
+                              })
+                     )
+{

   next if ! $part_pkg->freq && $opt_r;
 
   if ( $opt_o ) {
   next if ! $part_pkg->freq && $opt_r;
 
   if ( $opt_o ) {


@@ -44,6 +54,40 @@ foreach my $part_pkg ( qsearch('part_pkg',\%search) ) {
 
   }
 
 
   }
 

+  if ( $opt_e ) {
+    my %hash = (
+      'pkgpart'    => $part_pkg->pkgpart,
+      'optionname' => 'setup_fee',
+    );
+
+    my $part_pkg_option = qsearchs('part_pkg_option', \%hash);
+
+    if ( $part_pkg_option ) {
+      $part_pkg_option->optionvalue(
+        sprintf('%.2f', $part_pkg_option->optionvalue * $opt_e)
+      );
+      my $error = $part_pkg_option->replace;
+      die $error if $error;
+    }
+  }
+
+  if ( $opt_u ) {
+    my %hash = (
+      'pkgpart'    => $part_pkg->pkgpart,
+      'optionname' => 'recur_fee',
+    );
+
+    my $part_pkg_option = qsearchs('part_pkg_option', \%hash);
+
+    if ( $part_pkg_option ) {
+      $part_pkg_option->optionvalue(
+        sprintf('%.2f', $part_pkg_option->optionvalue * $opt_u)
+      );
+      my $error = $part_pkg_option->replace;
+      die $error if $error;
+    }
+  }
+

   if ( $opt_t || $opt_s || $opt_S || $opt_z || $opt_Z ) {
 
     $part_pkg->taxclass($opt_t) if $opt_t;
   if ( $opt_t || $opt_s || $opt_S || $opt_z || $opt_Z ) {
 
     $part_pkg->taxclass($opt_t) if $opt_t;


@@ -59,7 +103,7 @@ foreach my $part_pkg ( qsearch('part_pkg',\%search) ) {
 }
 
 sub usage {
 }
 
 sub usage {

-  die "usage: part_pkg-bulk_change [ -r ] [ -p plan ] [ -m comment ] [ -o option_name -v option_value ] [ -t new_taxclass ] [ -s | -S ] [ -z | -Z ] employee_username\n";
+  die "usage: part_pkg-bulk_change [ -r ] [ -p plan ] [ -m comment ] [ -C classnum,classnum ] [ -o option_name -v option_value ] [ -t new_taxclass ] [ -s | -S ] [ -z | -Z ]  [ -e multiplier ] [ -u multiplier ] employee_username\n";

 }
 
 =head1 NAME
 }
 
 =head1 NAME


@@ -68,7 +112,7 @@ cust_main-bulk_change
 
 =head1 SYNOPSIS
 
 
 =head1 SYNOPSIS
 

-  part_pkg-bulk_change [ -r ] [ -p plan ] [ -m comment ] [ -o option_name -v option_value ] [ -t new_taxclass ] [ -s | -S ] [ -z | -Z ] employee_username
+  part_pkg-bulk_change [ -r ] [ -p plan ] [ -m comment ] [ -C classnum,classnum ] [ -o option_name -v option_value ] [ -t new_taxclass ] [ -s | -S ] [ -z | -Z ] [ -e multiplier ] [ -u multiplier ] employee_username

 
 =head1 DESCRIPTION
 
 
 =head1 DESCRIPTION
 


@@ -82,6 +126,8 @@ Search options:
 
 -m: packages with this comment only
 
 
 -m: packages with this comment only
 

+-C: excluding package classnum or classnums (comma-separated list)
+

 Change options:
 
 -o: part_pkg_option optionname
 Change options:
 
 -o: part_pkg_option optionname


@@ -98,6 +144,10 @@ Change options:
 
 -Z: Turn on "Show zero recurring"
 
 
 -Z: Turn on "Show zero recurring"
 

+-e: Multiply setup fee by this value (i.e. 1.05 for a 5% price increase)
+
+-u: Multiply recurring fee by this value (i.e. 1.05 for a 5% price increase)
+

 employee_username
 
 =head1 BUGS
 employee_username
 
 =head1 BUGS