diff options
| author | Christopher Burger <burgerc@freeside.biz> | 2018-08-16 20:14:03 -0400 |
|---|---|---|
| committer | Christopher Burger <burgerc@freeside.biz> | 2018-08-17 07:59:37 -0400 |
| commit | f39e443ac725b70b721fecf6bd53e3df4a502d94 (patch) | |
| tree | 2bac381db70047b2b0af4ed9f44c379daab017d7 | |
| parent | 3bd9ee35ea8ed387984848c3f85c8aea41f0ac4f (diff) | |
RT# 78356 - updated script to allow for null values when moving.
| -rwxr-xr-x[-rw-r--r--] | bin/move_svc_broadband_speeds.pl | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/bin/move_svc_broadband_speeds.pl b/bin/move_svc_broadband_speeds.pl index 8a9af99f2..7d20ef68a 100644..100755 --- a/bin/move_svc_broadband_speeds.pl +++ b/bin/move_svc_broadband_speeds.pl @@ -16,10 +16,10 @@ foreach my $rec (qsearch({ 'table' => 'svc_broadband', 'addl_from' => 'LEFT JOIN cust_svc USING ( svcnum ) LEFT JOIN cust_pkg USING ( pkgnum )', })) { - $rec->{Hash}->{speed_test_up} = $rec->{Hash}->{speed_up}; - $rec->{Hash}->{speed_test_down} = $rec->{Hash}->{speed_down}; - $rec->{Hash}->{speed_up} = $rec->{Hash}->{fcc477_upstream} * 1000; - $rec->{Hash}->{speed_down} = $rec->{Hash}->{fcc477_downstream} * 1000; + $rec->{Hash}->{speed_test_up} = $rec->{Hash}->{speed_up} ? $rec->{Hash}->{speed_up} : "null"; + $rec->{Hash}->{speed_test_down} = $rec->{Hash}->{speed_down} ? $rec->{Hash}->{speed_down} : "null"; + $rec->{Hash}->{speed_up} = $rec->{Hash}->{fcc477_upstream} ? $rec->{Hash}->{fcc477_upstream} * 1000 : "null"; + $rec->{Hash}->{speed_down} = $rec->{Hash}->{fcc477_downstream} ? $rec->{Hash}->{fcc477_downstream} * 1000 : "null"; my $sql = "UPDATE svc_broadband set speed_up = $rec->{Hash}->{speed_up}, |