From: Ivan Kohler <ivan@freeside.biz>
Date: Thu, 11 May 2017 16:50:11 +0000 (-0700)
Subject: bulk remove email address, RT#75861
X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=commitdiff_plain;h=f79377d752c38762833b9ff3982046a31488d0df

bulk remove email address, RT#75861
---

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";
+}