projects
/
freeside.git
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
|
inline
| side by side (parent:
29e7e36
)
sql num_pkgs conflicting with method...
author
ivan
<ivan>
Sun, 23 Jul 2006 14:23:39 +0000
(14:23 +0000)
committer
ivan
<ivan>
Sun, 23 Jul 2006 14:23:39 +0000
(14:23 +0000)
httemplate/search/report_receivables.cgi
patch
|
blob
|
history
diff --git
a/httemplate/search/report_receivables.cgi
b/httemplate/search/report_receivables.cgi
index
b08fc81
..
3052ea9
100755
(executable)
--- a/
httemplate/search/report_receivables.cgi
+++ b/
httemplate/search/report_receivables.cgi
@@
-70,7
+70,7
@@
END
my $cancelled_sql = FS::cust_pkg->inactive_sql;
my $packages_cols = <<END;
my $cancelled_sql = FS::cust_pkg->inactive_sql;
my $packages_cols = <<END;
- ( $select_count_pkgs ) AS num_pkgs,
+ ( $select_count_pkgs ) AS num_pkgs
_sql
,
( $select_count_pkgs AND $active_sql ) AS active_pkgs,
( $select_count_pkgs AND $inactive_sql ) AS inactive_pkgs,
( $select_count_pkgs AND $suspended_sql ) AS suspended_pkgs,
( $select_count_pkgs AND $active_sql ) AS active_pkgs,
( $select_count_pkgs AND $inactive_sql ) AS inactive_pkgs,
( $select_count_pkgs AND $suspended_sql ) AS suspended_pkgs,
@@
-117,7
+117,7
@@
END
my $row = shift;
my $status = 'unknown';
my $row = shift;
my $status = 'unknown';
- if ( $row->num_pkgs == 0 ) {
+ if ( $row->num_pkgs
_sql
== 0 ) {
$status = 'prospect';
} elsif ( $row->active_pkgs > 0 ) {
$status = 'active';
$status = 'prospect';
} elsif ( $row->active_pkgs > 0 ) {
$status = 'active';