X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=FS%2FFS%2FCron%2Fbill.pm;h=2c9468b14fd9840d2c77c364bfd6c660393099d0;hb=0617a36106148efd7884c2f6ccd2a41075f9e5f6;hp=d046930491c33039a5ab603631b7c8810b121f42;hpb=5b95c313db51d90197c76d3d644290c66e80149b;p=freeside.git diff --git a/FS/FS/Cron/bill.pm b/FS/FS/Cron/bill.pm index d04693049..2c9468b14 100644 --- a/FS/FS/Cron/bill.pm +++ b/FS/FS/Cron/bill.pm @@ -100,6 +100,7 @@ sub bill { 'resetup' => ( $opt{'s'} ? $opt{'s'} : 0 ), 'not_pkgpart' => $opt{'g'}, #$not_pkgpart, 'one_recur' => $opt{'o'}, + 'no_prepaid' => 1, ); if ( $opt{'m'} ) { @@ -160,8 +161,6 @@ sub bill { # with today's date, regardless of the pretend date used to pre-generate # the invoices. # -# -p: Only process customers with the specified payby (I, I, I, I, I, I, I) -# # -a: Only process customers with the specified agentnum # # -v: enable debugging @@ -189,8 +188,6 @@ sub bill_where { push @search, "( cust_main.archived != 'Y' OR archived IS NULL )"; #disable? - push @search, "cust_main.payby = '". $opt{'p'}. "'" - if $opt{'p'}; push @search, "cust_main.agentnum IN ( ". $opt{'a'}. " ) " if $opt{'a'}; @@ -209,6 +206,8 @@ sub bill_where { my $conf = new FS::Conf; my $billtime = $conf->exists('next-bill-ignore-time') ? day_end($time) : $time; + # corresponds to perl checks in FS::cust_main::Billing sub bill + # ("bill setup" and "bill recurring fee") # select * from cust_main where my $where_pkg = <<"END"; EXISTS( @@ -217,7 +216,7 @@ sub bill_where { AND ( cancel IS NULL OR cancel = 0 ) AND ( ( ( cust_pkg.setup IS NULL OR cust_pkg.setup = 0 ) AND ( start_date IS NULL OR start_date = 0 - OR ( start_date IS NOT NULL AND start_date <= $^T ) + OR ( start_date IS NOT NULL AND start_date <= $billtime ) ) ) OR ( freq != '0' AND ( bill IS NULL OR bill <= $billtime ) ) @@ -233,7 +232,8 @@ END my $eventtable = $_; # joins and where clauses to test event conditions - my $join = FS::part_event_condition->join_conditions_sql( $eventtable ); + my $join = FS::part_event_condition->join_conditions_sql( $eventtable, + 'time'=>$time ); my $where = FS::part_event_condition->where_conditions_sql( $eventtable, 'time'=>$time, );