X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=FS%2FFS%2Fsvc_broadband.pm;h=68e7496d194c37bff81dba4d82fdef8bf760a474;hb=807bc6bf91e6208fd40bcdf99ce4c0149c2598d2;hp=ab97ac82cb0bc2a7882153273fcddd9aec9bb9ce;hpb=52dbc041b5ba187cc2a503e5ad2d800b1a2e5a1f;p=freeside.git diff --git a/FS/FS/svc_broadband.pm b/FS/FS/svc_broadband.pm index ab97ac82c..68e7496d1 100755 --- a/FS/FS/svc_broadband.pm +++ b/FS/FS/svc_broadband.pm @@ -114,6 +114,10 @@ sub search_sql { my( $class, $string ) = @_; if ( $string =~ /^(\d{1,3}\.){3}\d{1,3}$/ ) { $class->search_sql_field('ip_addr', $string ); + }elsif ( $string =~ /^([a-fA-F0-9]{12})$/ ) { + $class->search_sql_field('mac_addr', uc($string)); + }elsif ( $string =~ /^(([a-fA-F0-9]{1,2}:){5}([a-fA-F0-9]{1,2}))$/ ) { + $class->search_sql_field('mac_addr', uc("$2$3$4$5$6$7") ); } else { '1 = 0'; #false } @@ -200,9 +204,9 @@ sub check { || $self->ut_ipn('ip_addr') || $self->ut_hexn('mac_addr') || $self->ut_hexn('auth_key') - || $self->ut_floatn('latitude') - || $self->ut_floatn('longitude') - || $self->ut_floatn('altitude') + || $self->ut_coordn('latitude', -90, 90) + || $self->ut_coordn('longitude', -180, 180) + || $self->ut_sfloatn('altitude') || $self->ut_textn('vlan_profile') ; return $error if $error; @@ -210,13 +214,6 @@ sub check { if($self->speed_up < 0) { return 'speed_up must be positive'; } if($self->speed_down < 0) { return 'speed_down must be positive'; } - if($self->latitude < -90 || $self->latitude > 90) { - return 'latitude must be between -90 and 90'; - } - if($self->longitude < -180 || $self->longitude > 180) { - return 'longitude must be between -180 and 180'; - } - if (not($self->ip_addr) or $self->ip_addr eq '0.0.0.0') { my $next_addr = $self->addr_block->next_free_addr; if ($next_addr) {