1 package FS::banned_pay;
4 use base qw( FS::otaker_Mixin FS::Record );
5 use Digest::MD5 qw(md5_base64);
6 use FS::Record qw( qsearch qsearchs );
11 FS::banned_pay - Object methods for banned_pay records
17 $record = new FS::banned_pay \%hash;
18 $record = new FS::banned_pay { 'column' => 'value' };
20 $error = $record->insert;
22 $error = $new_record->replace($old_record);
24 $error = $record->delete;
26 $error = $record->check;
30 An FS::banned_pay object represents an banned credit card or ACH account.
31 FS::banned_pay inherits from FS::Record. The following fields are currently
36 =item bannum - primary key
38 =item payby - I<CARD> or I<CHEK>
40 =item payinfo - fingerprint of banned card (base64-encoded MD5 digest)
42 =item _date - specified as a UNIX timestamp; see L<perlfunc/"time">. Also see
43 L<Time::Local> and L<Date::Parse> for conversion functions.
45 =item end_date - optional end date, also specified as a UNIX timestamp.
47 =item usernum - order taker (assigned automatically, see L<FS::access_user>)
49 =item bantype - Ban type: "" or null (regular ban), "warn" (warning)
51 =item reason - reason (text)
61 Creates a new ban. To add the ban to the database, see L<"insert">.
63 Note that this stores the hash reference, not a distinct copy of the hash it
64 points to. You can ask the object for a copy with the I<hash> method.
68 # the new method can be inherited from FS::Record, if a table method is defined
70 sub table { 'banned_pay'; }
74 Adds this record to the database. If there is an error, returns the error,
75 otherwise returns false.
79 # the insert method can be inherited from FS::Record
83 Delete this record from the database.
87 # the delete method can be inherited from FS::Record
89 =item replace OLD_RECORD
91 Replaces the OLD_RECORD with this one in the database. If there is an error,
92 returns the error, otherwise returns false.
96 # the replace method can be inherited from FS::Record
100 Checks all fields to make sure this is a valid ban. If there is
101 an error, returns the error, otherwise returns false. Called by the insert
106 # the check method should currently be supplied - FS::Record contains some
107 # data checking routines
113 $self->ut_numbern('bannum')
114 || $self->ut_enum('payby', [ 'CARD', 'CHEK' ] )
115 || $self->ut_text('payinfo')
116 || $self->ut_numbern('_date')
117 || $self->ut_numbern('end_date')
118 || $self->ut_enum('bantype', [ '', 'warn' ] )
119 || $self->ut_textn('reason')
121 return $error if $error;
123 $self->_date(time) unless $self->_date;
125 $self->usernum($FS::CurrentUser::CurrentUser->usernum) unless $self->usernum;
134 =item ban_search OPTION => VALUE ...
136 Takes two parameters: payby and payinfo, and searches for an (un-expired) ban
137 matching those items.
139 Returns the ban, or false if no ban was found.
144 my( $class, %opt ) = @_;
146 'table' => 'banned_pay',
148 'payby' => $opt{payby},
149 'payinfo' => md5_base64($opt{payinfo}),
151 'extra_sql' => 'AND ( end_date IS NULL OR end_date >= '. time. ' ) ',
155 # Used by FS::Upgrade to migrate to a new database.
156 sub _upgrade_data { # class method
157 my ($class, %opts) = @_;
158 $class->_upgrade_otaker(%opts);
167 L<FS::Record>, schema.html from the base documentation.