diff options
author | ivan <ivan> | 2011-06-02 21:52:57 +0000 |
---|---|---|
committer | ivan <ivan> | 2011-06-02 21:52:57 +0000 |
commit | 3907da4465b5ca211f9af7556f811eff252fcd23 (patch) | |
tree | 66d26fe92d93c664a1721de37047a1e02e663b1f | |
parent | d632cda4e4c3e77d63ce61aae4096e4c81c29b9d (diff) |
fix svc_port searches
-rw-r--r-- | FS/FS/svc_port.pm | 3 | ||||
-rw-r--r-- | httemplate/search/cust_svc.html | 1 |
2 files changed, 3 insertions, 1 deletions
diff --git a/FS/FS/svc_port.pm b/FS/FS/svc_port.pm index 7dc70f9..a0252b4 100644 --- a/FS/FS/svc_port.pm +++ b/FS/FS/svc_port.pm @@ -80,7 +80,8 @@ sub table_info { 'name' => 'Port', #'name_plural' => 'Ports', #optional, #'longname_plural' => 'Ports', #optional - 'sorts' => [ 'svcnum', 'serviceid' ], # optional sort field (or arrayref of sort fields, main first) + #'sorts' => [ 'svcnum', 'serviceid' ], # optional sort field (or arrayref of sort fields, main first) + 'sorts' => [ 'serviceid' ], # optional sort field (or arrayref of sort fields, main first) 'display_weight' => 75, 'cancel_weight' => 10, 'fields' => { diff --git a/httemplate/search/cust_svc.html b/httemplate/search/cust_svc.html index 72ecb8e..9cf4bbd 100644 --- a/httemplate/search/cust_svc.html +++ b/httemplate/search/cust_svc.html @@ -75,6 +75,7 @@ if ( length( $cgi->param('search_svc') ) ) { $cgi->param('svcdb') =~ /^(svc_\w+)$/ or die "unknown svcdb"; push @extra_sql, "svcdb = '$1'"; + $addl_from .= " LEFT JOIN $1 USING ( svcnum ) "; push @extra_sql, 'pkgnum IS NULL' if $cgi->param('magic') eq 'unlinked'; |