1 package FS::part_event::Condition::cust_bill_hasnt_noauto;
6 use base qw( FS::part_event::Condition );
9 'Invoice eligible for automatic collection';
12 sub eventtable_hashref {
20 #my($self, $cust_bill, %opt) = @_;
21 my($self, $cust_bill) = @_;
23 ! $cust_bill->no_auto;
27 my( $class, $table, %opt ) = @_;
29 # can be made still faster with optimizations?
31 "NOT EXISTS ( SELECT 1 FROM cust_pkg
32 LEFT JOIN part_pkg USING (pkgpart)
33 WHERE ( cust_pkg.no_auto = 'Y' OR part_pkg.no_auto = 'Y' )
34 AND cust_pkg.pkgnum IN
35 ( SELECT DISTINCT cust_bill_pkg.pkgnum
37 WHERE cust_bill_pkg.invnum = cust_bill.invnum
38 AND cust_bill_pkg.pkgnum > 0