From f79377d752c38762833b9ff3982046a31488d0df Mon Sep 17 00:00:00 2001 From: Ivan Kohler Date: Thu, 11 May 2017 09:50:11 -0700 Subject: [PATCH] bulk remove email address, RT#75861 --- bin/remove-cust_main_invoice | 22 ++++++++++++++++++++++ 1 file changed, 22 insertions(+) create mode 100755 bin/remove-cust_main_invoice diff --git a/bin/remove-cust_main_invoice b/bin/remove-cust_main_invoice new file mode 100755 index 000000000..da17a7e29 --- /dev/null +++ b/bin/remove-cust_main_invoice @@ -0,0 +1,22 @@ +#!/usr/bin/perl + +use strict; +use FS::UID qw( adminsuidsetup ); +use FS::Record qw( qsearch ); + +my $user = shift or die &usage; + +my $email = shift or die &usage; + +adminsuidsetup $user; + +foreach my $cust_main_invoice ( + qsearch('cust_main_invoice', { 'dest' => $email } ) +) { + my $error = $cust_main_invoice->delete; + die $error if $error; +} + +sub usage { + "Usage: remove-cust_main_invoice username email\@address"; +} -- 2.11.0