7 use FS::UID qw(adminsuidsetup driver_name dbh);
8 use FS::Record qw(qsearch qsearchs);
11 &untaint_argv; #what it sounds like (eww)
12 use vars qw($opt_d $opt_v);
14 my $user = shift or die &usage;
18 $FS::cust_main::Debug = 1 if $opt_v;
21 ? map { qsearchs('cust_main', { custnum => $_ } ) } @ARGV
22 : qsearch('cust_main', {} )
25 #we're at now now (and later).
26 my($time)= $opt_d ? str2time($opt_d) : $^T;
29 foreach $cust_main ( @cust_main ) {
31 # $^T not $time because -d is for pre-printing invoices
32 foreach my $cust_pkg (
33 grep { $_->expire && $_->expire >= $^T } $cust_main->ncancelled_pkgs
35 my $error = $cust_pkg->cancel;
36 warn "Error cancelling expired pkg ". $cust_pkg->pkgnum. " for custnum ".
37 $cust_main->custnum. ": $error"
41 my $error = $cust_main->bill( 'time' => $time );
42 warn "Error billing, custnum ". $cust_main->custnum. ": $error" if $error;
44 $cust_main->apply_payments;
45 $cust_main->apply_credits;
47 $error = $cust_main->collect( 'invoice_time' => $time );
48 warn "Error collecting, custnum". $cust_main->custnum. ": $error" if $error;
52 if ( driver_name eq 'Pg' ) {
53 foreach my $statement ( 'vacuum', 'vacuum analyze' ) {
54 my $sth = dbh->prepare($statement) or die dbh->errstr;
55 $sth->execute or die $sth->errstr;
62 foreach $_ ( $[ .. $#ARGV ) { #untaint @ARGV
63 #$ARGV[$_] =~ /^([\w\-\/]*)$/ || die "Illegal arguement \"$ARGV[$_]\"";
65 $ARGV[$_] =~ /^(.*)$/ || die "Illegal arguement \"$ARGV[$_]\"";
71 die "Usage:\n\n freeside-daily [ -d 'date' ] user [ custnum custnum ... ]\n";
76 freeside-daily - Run daily billing and invoice collection events.
80 freeside-daily [ -d 'date' ] user [ custnum custnum ... ]
84 Bills customers and runs invoice collection events. Should be run from
87 This script replaces freeside-bill from 1.3.1.
89 Bills customers. Searches for customers who are due for billing and calls
90 the bill and collect methods of a cust_main object. See L<FS::cust_main>.
92 -d: Pretend it's 'date'. Date is in any format Date::Parse is happy with,
95 user: From the mapsecrets file - see config.html from the base documentation
97 custnum: if one or more customer numbers are specified, only bills those
98 customers. Otherwise, bills all customers.
104 L<FS::cust_main>, config.html from the base documentation