diff options
| author | cvs2git <cvs2git> | 2008-03-16 19:58:34 +0000 |
|---|---|---|
| committer | cvs2git <cvs2git> | 2008-03-16 19:58:34 +0000 |
| commit | eb061f5119325e666f0dff40d4089e5c1df58e17 (patch) | |
| tree | d55e8fef5aca62eb13bbc8ad20dbdf941c3bd266 /FS/bin/freeside-count-active-customers | |
| parent | 3a17b276638200475d54201fa62566b7440e819a (diff) | |
This commit was manufactured by cvs2svn to create tag 'TRIXBOX_2_6'.TRIXBOX_2_6
Diffstat (limited to 'FS/bin/freeside-count-active-customers')
| -rwxr-xr-x | FS/bin/freeside-count-active-customers | 17 |
1 files changed, 0 insertions, 17 deletions
diff --git a/FS/bin/freeside-count-active-customers b/FS/bin/freeside-count-active-customers deleted file mode 100755 index 759085a73..000000000 --- a/FS/bin/freeside-count-active-customers +++ /dev/null @@ -1,17 +0,0 @@ -#!/bin/sh - -domain=$1 - -echo "\t -select count(*) from cust_main where - 0 < ( SELECT COUNT(*) FROM cust_pkg - WHERE cust_pkg.custnum = cust_main.custnum - AND ( cust_pkg.cancel IS NULL - OR cust_pkg.cancel = 0 - ) - ) - OR 0 = ( SELECT COUNT(*) FROM cust_pkg - WHERE cust_pkg.custnum = cust_main.custnum - ); -" | psql -U freeside -q $domain | head -1 - |