diff options
| author | Christopher Burger <burgerc@freeside.biz> | 2018-08-16 20:14:03 -0400 |
|---|---|---|
| committer | Christopher Burger <burgerc@freeside.biz> | 2018-08-16 20:14:03 -0400 |
| commit | 38f5269087720ea350137eca109d63cc423b50f9 (patch) | |
| tree | dc0d274ad71606cb1bce70b0956f1d8e33b4f1df /bin | |
| parent | f81eebbe27a6acc0ae4284fa04b5525a41ae4570 (diff) | |
RT# 78356 - updated script to allow for null values when moving.
Diffstat (limited to 'bin')
| -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}, |