4 use vars qw( @ISA $DEBUG $me );
6 use DBIx::DBSchema::Table;
7 use DBIx::DBSchema::Column;
8 use FS::Record qw( qsearch qsearchs dbh dbdef );
11 @ISA = qw(FS::Record);
17 FS::reason - Object methods for reason records
23 $record = new FS::reason \%hash;
24 $record = new FS::reason { 'column' => 'value' };
26 $error = $record->insert;
28 $error = $new_record->replace($old_record);
30 $error = $record->delete;
32 $error = $record->check;
36 An FS::reason object represents a reason message. FS::reason inherits from
37 FS::Record. The following fields are currently supported:
41 =item reasonnum - primary key
43 =item reason_type - index into FS::reason_type
45 =item reason - text of the reason
47 =item disabled - 'Y' or ''
49 =item unsuspend_pkgpart - for suspension reasons only, the pkgpart (see
50 L<FS::part_pkg>) of a package to be ordered when the package is unsuspended.
51 Typically this will be some kind of reactivation fee. Attaching it to
52 a suspension reason allows the reactivation fee to be charged for some
53 suspensions but not others.
55 =item unsuspend_hold - 'Y' or ''. If unsuspend_pkgpart is set, this tells
56 whether to bill the unsuspend package immediately ('') or to wait until
57 the customer's next invoice ('Y').
59 =item unused_credit - 'Y' or ''. For suspension reasons only (for now).
60 If enabled, the customer will be credited for their remaining time on
71 Creates a new reason. To add the example to the database, see L<"insert">.
73 Note that this stores the hash reference, not a distinct copy of the hash it
74 points to. You can ask the object for a copy with the I<hash> method.
78 sub table { 'reason'; }
82 Adds this record to the database. If there is an error, returns the error,
83 otherwise returns false.
89 Delete this record from the database.
93 =item replace OLD_RECORD
95 Replaces the OLD_RECORD with this one in the database. If there is an error,
96 returns the error, otherwise returns false.
102 Checks all fields to make sure this is a valid reason. If there is
103 an error, returns the error, otherwise returns false. Called by the insert
112 $self->ut_numbern('reasonnum')
113 || $self->ut_number('reason_type')
114 || $self->ut_foreign_key('reason_type', 'reason_type', 'typenum')
115 || $self->ut_text('reason')
117 return $error if $error;
119 if ( $self->reasontype->class eq 'S' ) {
120 $error = $self->ut_numbern('unsuspend_pkgpart')
121 || $self->ut_foreign_keyn('unsuspend_pkgpart', 'part_pkg', 'pkgpart')
122 || $self->ut_flag('unsuspend_hold')
123 || $self->ut_flag('unused_credit')
125 return $error if $error;
127 foreach (qw(unsuspend_pkgpart unsuspend_hold unused_credit)) {
128 $self->set($_ => '');
137 Returns the reason_type (see L<FS::reason_type>) associated with this reason.
142 qsearchs( 'reason_type', { 'typenum' => shift->reason_type } );
151 =item new_or_existing reason => REASON, type => TYPE, class => CLASS
153 Fetches the reason matching these parameters if there is one. If not,
154 inserts one. Will also insert the reason type if necessary. CLASS must
155 be one of 'C' (cancel reasons), 'R' (credit reasons), or 'S' (suspend reasons).
157 This will die if anything fails.
161 sub new_or_existing {
166 my %hash = ('class' => $opt{'class'}, 'type' => $opt{'type'});
167 my $reason_type = qsearchs('reason_type', \%hash)
168 || FS::reason_type->new(\%hash);
170 $error = $reason_type->insert unless $reason_type->typenum;
171 die "error inserting reason type: $error\n" if $error;
173 %hash = ('reason_type' => $reason_type->typenum, 'reason' => $opt{'reason'});
174 my $reason = qsearchs('reason', \%hash)
175 || FS::reason->new(\%hash);
177 $error = $reason->insert unless $reason->reasonnum;
178 die "error inserting reason: $error\n" if $error;
188 L<FS::Record>, schema.html from the base documentation.