package FS::part_event::Condition::cust_bill_past_due; use strict; use FS::cust_bill; use Time::Local 'timelocal'; use base qw( FS::part_event::Condition ); sub description { 'Invoice due date has passed'; } sub eventtable_hashref { { 'cust_main' => 0, 'cust_bill' => 1, 'cust_pkg' => 0, }; } sub option_fields { ( 'delay' => { label => 'Delay additional days', type => 'text', value => '0', }, ); } sub condition { my($self, $cust_bill, %opt) = @_; my $delay = $self->option('delay') || 0; my ($sec,$min,$hour,$mday,$mon,$year) = (localtime($opt{'time'}))[0..5]; my $as_of = timelocal(0,0,0,$mday,$mon,$year) - $delay * 86400; $as_of >= ($cust_bill->due_date || $cust_bill->_date); } #->due_date_sql can't cope with agent-specific invoice_default_terms #sub condition_sql { # my( $class, $table, %opt ) = @_; # return 'true' if $opt{'driver_name'} ne 'Pg'; # my $delay = $class->condition_sql_option_integer('delay', 'Pg'); # my ($sec,$min,$hour,$mday,$mon,$year) = (localtime($opt{'time'}))[0..5]; # my $as_of = timelocal(0,0,0,$mday,$mon,$year) . " - ($delay * 86400)"; # "( $as_of ) >= ".FS::cust_bill->due_date_sql; #} 1;