diff options
| author | cvs2git <cvs2git> | 2006-01-05 09:34:30 +0000 |
|---|---|---|
| committer | cvs2git <cvs2git> | 2006-01-05 09:34:30 +0000 |
| commit | 0c525f3ba7b2b6730b8939b950e4d76dd16802a9 (patch) | |
| tree | 9d0c5411f52238759ca3484d5ecc036dc6905414 /FS/bin/freeside-count-active-customers | |
| parent | 8f5c91d6c7a8dc85a8b6768a149b4c7b3e144c38 (diff) | |
This commit was manufactured by cvs2svn to create tag 'SQL_LEDGER_2_4_4'.SQL_LEDGER_2_4_4
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 - |