5 use FS::Record qw( qsearch qsearchs fields dbh );
6 use FS::part_svc_column;
12 FS::part_svc - Object methods for part_svc objects
18 $record = new FS::part_svc \%hash
19 $record = new FS::part_svc { 'column' => 'value' };
21 $error = $record->insert;
23 $error = $new_record->replace($old_record);
25 $error = $record->delete;
27 $error = $record->check;
31 An FS::part_svc represents a service definition. FS::part_svc inherits from
32 FS::Record. The following fields are currently supported:
36 =item svcpart - primary key (assigned automatically for new service definitions)
38 =item svc - text name of this service definition
40 =item svcdb - table used for this service. See L<FS::svc_acct>,
41 L<FS::svc_domain>, and L<FS::svc_forward>, among others.
51 Creates a new service definition. To add the service definition to the
52 database, see L<"insert">.
56 sub table { 'part_svc'; }
60 Adds this service definition to the database. If there is an error, returns
61 the error, otherwise returns false.
63 =item I<svcdb>__I<field> - Default or fixed value for I<field> in I<svcdb>.
65 =item I<svcdb>__I<field>_flag - defines I<svcdb>__I<field> action: null, `D' for default, or `F' for fixed
72 local $SIG{HUP} = 'IGNORE';
73 local $SIG{INT} = 'IGNORE';
74 local $SIG{QUIT} = 'IGNORE';
75 local $SIG{TERM} = 'IGNORE';
76 local $SIG{TSTP} = 'IGNORE';
77 local $SIG{PIPE} = 'IGNORE';
79 my $oldAutoCommit = $FS::UID::AutoCommit;
80 local $FS::UID::AutoCommit = 0;
83 my $error = $self->SUPER::insert;
85 $dbh->rollback if $oldAutoCommit;
89 my $svcdb = $self->svcdb;
90 # my @rows = map { /^${svcdb}__(.*)$/; $1 }
96 && defined( $self->getfield($svcdb.'__'.$_.'_flag') )
99 my $part_svc_column = $self->part_svc_column($field);
100 my $previous = qsearchs('part_svc_column', {
101 'svcpart' => $self->svcpart,
102 'columnname' => $field,
105 my $flag = $self->getfield($svcdb.'__'.$field.'_flag');
106 if ( uc($flag) =~ /^([DF])$/ ) {
107 $part_svc_column->setfield('columnflag', $1);
108 $part_svc_column->setfield('columnvalue',
109 $self->getfield($svcdb.'__'.$field)
112 $error = $part_svc_column->replace($previous);
114 $error = $part_svc_column->insert;
117 $error = $previous ? $previous->delete : '';
120 $dbh->rollback if $oldAutoCommit;
126 $dbh->commit or die $dbh->errstr if $oldAutoCommit;
133 Currently unimplemented.
138 return "Can't (yet?) delete service definitions.";
139 # check & make sure the svcpart isn't in cust_svc or pkg_svc (in any packages)?
142 =item replace OLD_RECORD
144 Replaces OLD_RECORD with this one in the database. If there is an error,
145 returns the error, otherwise returns false.
150 my ( $new, $old ) = ( shift, shift );
152 return "Can't change svcdb for an existing service definition!"
153 unless $old->svcdb eq $new->svcdb;
155 local $SIG{HUP} = 'IGNORE';
156 local $SIG{INT} = 'IGNORE';
157 local $SIG{QUIT} = 'IGNORE';
158 local $SIG{TERM} = 'IGNORE';
159 local $SIG{TSTP} = 'IGNORE';
160 local $SIG{PIPE} = 'IGNORE';
162 my $oldAutoCommit = $FS::UID::AutoCommit;
163 local $FS::UID::AutoCommit = 0;
166 my $error = $new->SUPER::replace( $old );
168 $dbh->rollback if $oldAutoCommit;
172 if ( @_ && $_[0] eq '1.3-COMPAT' ) {
173 my $svcdb = $new->svcdb;
175 grep { $_ ne 'svcnum'
176 && defined( $new->getfield($svcdb.'__'.$_.'_flag') )
179 my $part_svc_column = $new->part_svc_column($field);
180 my $previous = qsearchs('part_svc_column', {
181 'svcpart' => $new->svcpart,
182 'columnname' => $field,
185 my $flag = $new->getfield($svcdb.'__'.$field.'_flag');
186 if ( uc($flag) =~ /^([DF])$/ ) {
187 $part_svc_column->setfield('columnflag', $1);
188 $part_svc_column->setfield('columnvalue',
189 $new->getfield($svcdb.'__'.$field)
192 $error = $part_svc_column->replace($previous);
194 $error = $part_svc_column->insert;
197 $error = $previous ? $previous->delete : '';
200 $dbh->rollback if $oldAutoCommit;
205 $dbh->rollback if $oldAutoCommit;
206 return 'non-1.3-COMPAT interface not yet written';
210 $dbh->commit or die $dbh->errstr if $oldAutoCommit;
217 Checks all fields to make sure this is a valid service definition. If there is
218 an error, returns the error, otherwise returns false. Called by the insert
225 my $recref = $self->hashref;
229 $self->ut_numbern('svcpart')
230 || $self->ut_text('svc')
231 || $self->ut_alpha('svcdb')
233 return $error if $error;
235 my @fields = eval { fields( $recref->{svcdb} ) }; #might die
236 return "Unknown svcdb!" unless @fields;
239 # foreach $svcdb ( qw(
240 # svc_acct svc_acct_sm svc_domain
242 # my @rows = map { /^${svcdb}__(.*)$/; $1 }
244 # grep /^${svcdb}__/,
245 # fields('part_svc');
246 # foreach my $row (@rows) {
247 # unless ( $svcdb eq $recref->{svcdb} ) {
248 # $recref->{$svcdb.'__'.$row}='';
249 # $recref->{$svcdb.'__'.$row.'_flag'}='';
252 # $recref->{$svcdb.'__'.$row.'_flag'} =~ /^([DF]?)$/
253 # or return "Illegal flag for $svcdb $row";
254 # $recref->{$svcdb.'__'.$row.'_flag'} = $1;
256 # my $error = $self->ut_anything($svcdb.'__'.$row);
257 # return $error if $error;
265 =item part_svc_column COLUMNNAME
267 Returns the part_svc_column object (see L<FS::part_svc_column>) for the given
268 COLUMNNAME, or a new part_svc_column object if none exists.
272 sub part_svc_column {
274 my $columnname = shift;
275 qsearchs('part_svc_column', {
276 'svcpart' => $self->svcpart,
277 'columnname' => $columnname,
279 ) or new FS::part_svc_column {
280 'svcpart' => $self->svcpart,
281 'columnname' => $columnname,
285 =item all_part_svc_column
289 sub all_part_svc_column {
291 qsearch('part_svc_column', { 'svcpart' => $self->svcpart } );
298 $Id: part_svc.pm,v 1.6 2001-09-12 15:45:01 ivan Exp $
302 Delete is unimplemented.
304 The list of svc_* tables is hardcoded. When svc_acct_pop is renamed, this
309 L<FS::Record>, L<FS::part_pkg>, L<FS::pkg_svc>, L<FS::cust_svc>,
310 L<FS::svc_acct>, L<FS::svc_forward>, L<FS::svc_domain>, schema.html from the