X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=FS%2FFS%2Fpart_referral.pm;h=2df8a757110b7c4fced7654eefcb927c9b978fa1;hp=e1688650d2216252244ee2a61bc23dbb640bf1a0;hb=HEAD;hpb=0a7d9371d3514312edd8661c621876cece4d5221 diff --git a/FS/FS/part_referral.pm b/FS/FS/part_referral.pm index e1688650d..2df8a7571 100644 --- a/FS/FS/part_referral.pm +++ b/FS/FS/part_referral.pm @@ -1,11 +1,12 @@ package FS::part_referral; +use base qw(FS::Record); use strict; -use vars qw( @ISA ); -use FS::Record qw( qsearch qsearchs dbh ); -use FS::agent; +use vars qw( @ISA $setup_hack ); +use FS::Record qw( dbh qsearch ); #qsearchs ); @ISA = qw( FS::Record ); +$setup_hack = 0; =head1 NAME @@ -43,6 +44,9 @@ The following fields are currently supported: =item agentnum - Optional agentnum (see L) +=item title - an optional external string that identifies this +referral source, such as an advertising campaign code. + =back =head1 NOTE @@ -100,7 +104,11 @@ sub check { || $self->ut_text('referral') || $self->ut_enum('disabled', [ '', 'Y' ] ) #|| $self->ut_foreign_keyn('agentnum', 'agent', 'agentnum') - || $self->ut_agentnum_acl('agentnum', 'Edit global advertising sources') + || $self->ut_textn('title') + || ( $setup_hack + ? $self->ut_foreign_keyn('agentnum', 'agent', 'agentnum' ) + : $self->ut_agentnum_acl('agentnum', 'Edit global advertising sources') + ) ; return $error if $error; @@ -111,56 +119,62 @@ sub check { Returns the associated agent for this referral, if any, as an FS::agent object. -=cut - -sub agent { - my $self = shift; - qsearchs('agent', { 'agentnum' => $self->agentnum } ); -} - =back =head1 CLASS METHODS =over 4 -=item acl_agentnum_sql +=item acl_agentnum_sql [ INCLUDE_GLOBAL_BOOL ] Returns an SQL fragment for searching for part_referral records allowed by the current users's agent ACLs (and "Edit global advertising sources" right). +Pass a true value to include global advertising sources (for example, when +simply using rather than editing advertising sources). + =cut sub acl_agentnum_sql { - #my $class = shift; + my $self = shift; my $curuser = $FS::CurrentUser::CurrentUser; my $sql = $curuser->agentnums_sql; $sql = " ( $sql OR agentnum IS NULL ) " - if $curuser->access_right('Edit global advertising sources'); + if $curuser->access_right('Edit global advertising sources') + or defined($_[0]) && $_[0]; $sql; } -=item all_part_referral +=item all_part_referral [ INCLUDE_GLOBAL_BOOL ] Returns all part_referral records allowed by the current users's agent ACLs (and "Edit global advertising sources" right). +Pass a true value to include global advertising sources (for example, when +simply using rather than editing advertising sources). + =cut sub all_part_referral { my $self = shift; + my $global = @_ ? shift : ''; + my $disabled = @_ ? shift : ''; + + my $hashref = $disabled ? {} : { 'disabled' => '' }; + my $and = $disabled ? ' WHERE ' : ' AND '; qsearch({ 'table' => 'part_referral', - 'extra_sql' => ' WHERE '. $self->acl_agentnum_sql. ' ORDER BY refnum ', + 'hashref' => $hashref, + 'extra_sql' => $and. $self->acl_agentnum_sql($global). ' ORDER BY refnum ', }); } -=item num_part_referral +=item num_part_referral [ INCLUDE_GLOBAL_BOOL ] Returns the number of part_referral records allowed by the current users's agent ACLs (and "Edit global advertising sources" right). @@ -171,7 +185,7 @@ sub num_part_referral { my $self = shift; my $sth = dbh->prepare( - 'SELECT COUNT(*) FROM part_referral WHERE '. $self->acl_agentnum_sql + 'SELECT COUNT(*) FROM part_referral WHERE '. $self->acl_agentnum_sql(@_) ) or die dbh->errstr; $sth->execute() or die $sth->errstr; $sth->fetchrow_arrayref->[0];