- my $rep_id = 2; #XXX find the one matching the timeframe
- #SELECT id FROM WHERE reportname = 'MonthlyUsage' AND rep_date = ''
+ my @sdate = localtime($$sdate);
+ #sdate is next bill date, but we want the report from last month
+ my($m, $y) = ($sdate[4], $sdate[5]+1900);
+ if ( $m == 0 ) { $m=12; $y--; }
+ $m = "0$m" if length($m) == 1;
+ my $rep_date = "$y-$m-01";
+ warn "searching for MonthlyUsage report for $rep_date\n" if $DEBUG;
+ my $rep_sql = "
+ SELECT id FROM reports WHERE rep_date = ?
+ AND reportname = 'MonthlyUsage' and iscomplete = 1
+ ";
+ my $rep_id = $self->scalar_sql($rep_sql, $rep_date) or return 0;
+ warn "report id $rep_id found\n" if $DEBUG;