FS/bin/freeside-count-active-customers

   1 #!/bin/sh
   2
   3 domain=$1
   4
   5 echo "\t
   6 select count(*) from cust_main where
   7           0 < ( SELECT COUNT(*) FROM cust_pkg
   8                        WHERE cust_pkg.custnum = cust_main.custnum
   9                          AND ( cust_pkg.cancel IS NULL
  10                                OR cust_pkg.cancel = 0
  11                              )
  12                    )
  13             OR 0 = ( SELECT COUNT(*) FROM cust_pkg
  14                        WHERE cust_pkg.custnum = cust_main.custnum
  15                    );
  16 " | psql -U freeside -q $domain | head -1
  17