X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=FS%2FFS%2Fcust_bill_event.pm;h=36afed04043eac3abc75fce6d52d12b996331d4e;hb=dafdfc24616b04a5ff594da31e2cdd03f58634b6;hp=ff383ff9994bafba0f3a4e5577e0ddb7f2635ed6;hpb=af81319b032830fdec2ba0bc51313a469c254aab;p=freeside.git diff --git a/FS/FS/cust_bill_event.pm b/FS/FS/cust_bill_event.pm index ff383ff99..36afed040 100644 --- a/FS/FS/cust_bill_event.pm +++ b/FS/FS/cust_bill_event.pm @@ -38,18 +38,30 @@ currently supported: =over 4 -=item eventnum - primary key +=item eventnum -=item invnum - invoice (see L) +Primary key -=item eventpart - event definition (see L) +=item invnum -=item _date - specified as a UNIX timestamp; see L. Also see +Invoice (see L) + +=item eventpart + +Event definition (see L) + +=item _date + +Specified as a UNIX timestamp; see L. Also see L and L for conversion functions. -=item status - event status: B or B +=item status + +Event status: B or B -=item statustext - additional status detail (i.e. error message) +=item statustext + +Additional status detail (i.e. error message) =back @@ -189,24 +201,42 @@ sub retriable { $self->replace($old); } -=item search_sql HREF +=item search_sql_where HASHREF Class method which returns an SQL WHERE fragment to search for parameters -specified in HREF. Valid parameters are +specified in HASHREF. Valid parameters are =over 4 + =item agentnum -=item beginning - an epoch date setting a lower bound for _date values -=item ending - an epoch date setting a upper bound for _date values -=item failed - limits the search to failed events if true -=item payby - requires that the search be JOIN'd to part_bill_event # Bug? + +=item beginning + +An epoch date setting a lower bound for _date values + +=item ending + +An epoch date setting a upper bound for _date values + +=item failed + +Limits the search to failed events if true + +=item payby + +Requires that the search be JOIN'd to part_bill_event # Bug? + =item invnum -=item currentuser - specifies the user for agent virtualization + +=item currentuser + +Specifies the user for agent virtualization + =back =cut -sub search_sql { +sub search_sql_where { my ($class, $params) = @_; my @search = (); @@ -228,10 +258,9 @@ sub search_sql { push @search, "cust_bill_event.invnum = '". $params->{invnum}. "'" if $params->{invnum}; - if ($params->{CurrentUser}) { - my $access_user = qsearchs('access_user', - {username => $params->{CurrentUser} } - ); + my $currentuser = $params->{currentuser} || $params->{CurrentUser}; + if ($currentuser) { + my $access_user = qsearchs('access_user', { username => $currentuser }); if ($access_user) { push @search, $access_user->agentnums_sql; }else{ @@ -295,7 +324,7 @@ sub process_re_X { sub re_X { my($method, $param, $job) = @_; - my $where = FS::cust_bill_event->search_sql($param); + my $where = FS::cust_bill_event->search_sql_where($param); $where = " WHERE plan LIKE 'send%'". ( $where ? " AND $where" : "" ); my $from = 'LEFT JOIN part_bill_event USING ( eventpart )'.