7 use FS::UID qw(adminsuidsetup driver_name dbh datasrc);
8 use FS::Record qw(qsearch qsearchs);
12 &untaint_argv; #what it sounds like (eww)
13 use vars qw($opt_d $opt_v $opt_p $opt_s $opt_y);
15 my $user = shift or die &usage;
19 $FS::cust_main::Debug = 1 if $opt_v;
22 $search{'payby'} = $opt_p if $opt_p;
25 ? map { qsearchs('cust_main', { custnum => $_, %search } ) } @ARGV
26 : qsearch('cust_main', \%search )
29 #we're at now now (and later).
30 my($time)= $opt_d ? str2time($opt_d) : $^T;
31 $time += $opt_y * 86400 if $opt_y;
34 foreach $cust_main ( @cust_main ) {
36 # $^T not $time because -d is for pre-printing invoices
37 foreach my $cust_pkg (
38 grep { $_->expire && $_->expire <= $^T } $cust_main->ncancelled_pkgs
40 my $error = $cust_pkg->cancel;
41 warn "Error cancelling expired pkg ". $cust_pkg->pkgnum. " for custnum ".
42 $cust_main->custnum. ": $error"
46 my $error = $cust_main->bill( 'time' => $time,
47 'resetup' => $opt_s, );
48 warn "Error billing, custnum ". $cust_main->custnum. ": $error" if $error;
50 $cust_main->apply_payments;
51 $cust_main->apply_credits;
53 $error = $cust_main->collect( 'invoice_time' => $time );
54 warn "Error collecting, custnum". $cust_main->custnum. ": $error" if $error;
58 if ( driver_name eq 'Pg' ) {
59 dbh->{AutoCommit} = 1; #so we can vacuum
60 foreach my $statement ( 'vacuum', 'vacuum analyze' ) {
61 my $sth = dbh->prepare($statement) or die dbh->errstr;
62 $sth->execute or die $sth->errstr;
67 my $conf = new FS::Conf;
68 my $dest = $conf->config('dump-scpdest');
70 datasrc =~ /dbname=([\w\.]+)$/ or die "unparsable datasrc ". datasrc;
72 eval "use Net::SCP qw(scp);";
73 if ( driver_name eq 'Pg' ) {
74 system("pg_dump $database >/var/tmp/$database.sql")
76 die "database dumps not yet supported for ". driver_name;
78 scp("/var/tmp/$database.sql", $dest);
79 unlink "/var/tmp/$database.sql" or die $!;
85 foreach $_ ( $[ .. $#ARGV ) { #untaint @ARGV
86 #$ARGV[$_] =~ /^([\w\-\/]*)$/ || die "Illegal arguement \"$ARGV[$_]\"";
88 $ARGV[$_] =~ /^(.*)$/ || die "Illegal arguement \"$ARGV[$_]\"";
94 die "Usage:\n\n freeside-daily [ -d 'date' ] user [ custnum custnum ... ]\n";
99 freeside-daily - Run daily billing and invoice collection events.
103 freeside-daily [ -d 'date' ] [ -y days ] [ -p 'payby' ] [ -s ] [ -v ] user [ custnum custnum ... ]
107 Bills customers and runs invoice collection events. Should be run from
110 This script replaces freeside-bill from 1.3.1.
112 Bills customers. Searches for customers who are due for billing and calls
113 the bill and collect methods of a cust_main object. See L<FS::cust_main>.
115 -d: Pretend it's 'date'. Date is in any format Date::Parse is happy with,
118 -y: In addition to -d, which specifies an absolute date, the -y switch
119 specifies an offset, in days. For example, "-y 15" would increment the
120 "pretend date" 15 days from whatever was specified by the -d switch
121 (or now, if no -d switch was given).
123 -p: Only process customers with the specified payby (I<CARD>, I<CHEK>, I<BILL>, I<COMP>, I<LECB>)
125 -s: re-charge setup fees
129 user: From the mapsecrets file - see config.html from the base documentation
131 custnum: if one or more customer numbers are specified, only bills those
132 customers. Otherwise, bills all customers.
138 L<FS::cust_main>, config.html from the base documentation