From c8de09c1c19c34eb9384c391b81b90bd0f0ba8a5 Mon Sep 17 00:00:00 2001 From: Christopher Burger Date: Thu, 6 Jun 2019 10:00:26 -0400 Subject: [PATCH] RT# 83251 - removed search for unprovisioned services --- FS/bin/freeside-svcbroadband_update_speeds | 12 ++++++------ 1 file changed, 6 insertions(+), 6 deletions(-) diff --git a/FS/bin/freeside-svcbroadband_update_speeds b/FS/bin/freeside-svcbroadband_update_speeds index b3b257a5a..8a6f33f7d 100755 --- a/FS/bin/freeside-svcbroadband_update_speeds +++ b/FS/bin/freeside-svcbroadband_update_speeds @@ -47,12 +47,12 @@ my @services = qsearch({ }); ### get list of all unprovisioned services -my $ups_extra_sql = "where cust_pkg.cancel is null and pkg_svc.quantity > 0 and pkg_svc.quantity > (select count(1) from cust_svc where cust_svc.pkgnum = cust_pkg.pkgnum and cust_svc.svcpart = pkg_svc.svcpart) and pkg_svc.svcpart = $opt_s"; -my @unprovisioned_services = qsearchs({ - 'table' => 'cust_pkg', - 'addl_from' => 'JOIN pkg_svc using (pkgpart)', - 'extra_sql' => $ups_extra_sql, -}); +#my $ups_extra_sql = "where cust_pkg.cancel is null and pkg_svc.quantity > 0 and pkg_svc.quantity > (select count(1) from cust_svc where cust_svc.pkgnum = cust_pkg.pkgnum and cust_svc.svcpart = pkg_svc.svcpart) and pkg_svc.svcpart = $opt_s"; +#my @unprovisioned_services = qsearch({ +# 'table' => 'cust_pkg', +# 'addl_from' => 'JOIN pkg_svc using (pkgpart)', +# 'extra_sql' => $ups_extra_sql, +#}); my $speed; $speed = 'package' if $opt_p; -- 2.11.0