diff options
| author | Ivan Kohler <ivan@freeside.biz> | 2012-06-12 15:26:57 -0700 |
|---|---|---|
| committer | Ivan Kohler <ivan@freeside.biz> | 2012-06-12 15:26:57 -0700 |
| commit | ab6ecc7f37a2586f7d8f48a929eccf2ea8ed93c1 (patch) | |
| tree | c07443d336d14145b1d766ecf2efd81a05574dec | |
| parent | 7858d152084bc4a7c4c469d9f38a6fedefcbab9a (diff) | |
fix advanced customer report Add package columns under Pg, RT#18092
| -rw-r--r-- | FS/FS/cust_main/Search.pm | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/FS/FS/cust_main/Search.pm b/FS/FS/cust_main/Search.pm index b663c20f8..be4470501 100644 --- a/FS/FS/cust_main/Search.pm +++ b/FS/FS/cust_main/Search.pm @@ -778,6 +778,7 @@ sub search { if ($params->{'flattened_pkgs'}) { #my $pkg_join = ''; + $addl_from .= ' LEFT JOIN cust_pkg USING ( custnum ) '; if ($dbh->{Driver}->{Name} eq 'Pg') { @@ -785,12 +786,11 @@ sub search { } elsif ($dbh->{Driver}->{Name} =~ /^mysql/i) { push @select, "GROUP_CONCAT(part_pkg.pkg SEPARATOR '|') as magic"; - $addl_from .= ' LEFT JOIN cust_pkg USING ( custnum ) '; #Pg too w/flatpkg? $addl_from .= ' LEFT JOIN part_pkg USING ( pkgpart ) '; #$pkg_join .= ' LEFT JOIN part_pkg USING ( pkgpart ) '; } else { warn "warning: unknown database type ". $dbh->{Driver}->{Name}. - "omitting packing information from report."; + "omitting package information from report."; } my $header_query = "SELECT COUNT(cust_pkg.custnum = cust_main.custnum) AS count FROM cust_main $addl_from $extra_sql $pkgwhere group by cust_main.custnum order by count desc limit 1"; |