diff options
| author | cvs2git <cvs2git> | 2010-12-27 00:04:45 +0000 |
|---|---|---|
| committer | cvs2git <cvs2git> | 2010-12-27 00:04:45 +0000 |
| commit | c82d349f864e6bd9f96fd1156903bc1f7193a203 (patch) | |
| tree | e117a87533656110b6acd56fc0ca64289892a9f5 /FS/bin/freeside-count-active-customers | |
| parent | 74e058c8a010ef6feb539248a550d0bb169c1e94 (diff) | |
This commit was manufactured by cvs2svn to create tag 'TORRUS_1_0_9'.TORRUS_1_0_9
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 - |