diff options
| author | Ivan Kohler <ivan@freeside.biz> | 2013-02-07 21:12:22 -0800 |
|---|---|---|
| committer | Ivan Kohler <ivan@freeside.biz> | 2013-02-07 21:12:22 -0800 |
| commit | 737c5d8b82defb7e3e40a14ee33c4f80c64a8f71 (patch) | |
| tree | ed386f7637a7f00d35379cf8dc1d8ec64c2e7931 /httemplate/search/phone_avail.html | |
| parent | 154b0303d425ad2d670dd3ae74fd78d1bbff7f14 (diff) | |
| parent | fed12e8214a8a951377961ccbe7a09171b1e38c2 (diff) | |
Merge branch 'master' of git.freeside.biz:/home/git/freeside
Diffstat (limited to 'httemplate/search/phone_avail.html')
| -rw-r--r-- | httemplate/search/phone_avail.html | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/httemplate/search/phone_avail.html b/httemplate/search/phone_avail.html index 1335379ae..312c84ea9 100644 --- a/httemplate/search/phone_avail.html +++ b/httemplate/search/phone_avail.html @@ -125,9 +125,11 @@ my $search = scalar(@search) my $addl_from = ' LEFT JOIN cust_svc USING ( svcnum ) '. #' LEFT JOIN part_svc USING ( svcpart ) '. ' LEFT JOIN cust_pkg USING ( pkgnum ) '. - ' LEFT JOIN cust_main USING ( custnum ) '; + FS::UI::Web::join_cust_main('cust_pkg', 'cust_pkg'); my $count_query = "SELECT COUNT(*) FROM phone_avail $search"; #$addl_from? +# All of these relationships are left joined in the many-to-one direction, +# so including $addl_from won't affect the count. Logic! my $hashref = {}; $hashref->{'ordernum'} = $1 if $cgi->param('ordernum') =~ /^(\d+)$/; |