5 use FS::Record qw( qsearchs );
9 @ISA = qw( FS::Record );
13 FS::pkg_svc - Object methods for pkg_svc records
19 $record = new FS::pkg_svc \%hash;
20 $record = new FS::pkg_svc { 'column' => 'value' };
22 $error = $record->insert;
24 $error = $new_record->replace($old_record);
26 $error = $record->delete;
28 $error = $record->check;
30 $part_pkg = $record->part_pkg;
32 $part_svc = $record->part_svc;
36 An FS::pkg_svc record links a billing item definition (see L<FS::part_pkg>) to
37 a service definition (see L<FS::part_svc>). FS::pkg_svc inherits from
38 FS::Record. The following fields are currently supported:
42 =item pkgsvcnum - primary key
44 =item pkgpart - Billing item definition (see L<FS::part_pkg>)
46 =item svcpart - Service definition (see L<FS::part_svc>)
48 =item quantity - Quantity of this service definition that this billing item
51 =item primary_svc - primary flag, empty or 'Y'
53 =item hidden - 'Y' to hide this service on invoices, null otherwise.
63 Create a new record. To add the record to the database, see L<"insert">.
67 sub table { 'pkg_svc'; }
71 Adds this record to the database. If there is an error, returns the error,
72 otherwise returns false.
76 Deletes this record from the database. If there is an error, returns the
77 error, otherwise returns false.
79 =item replace OLD_RECORD
81 Replaces OLD_RECORD with this one in the database. If there is an error,
82 returns the error, otherwise returns false.
87 my( $new, $old ) = ( shift, shift );
89 $old = $new->replace_old unless defined($old);
91 return "Can't change pkgpart!" if $old->pkgpart != $new->pkgpart;
92 return "Can't change svcpart!" if $old->svcpart != $new->svcpart;
94 $new->SUPER::replace($old);
99 Checks all fields to make sure this is a valid record. If there is an error,
100 returns the error, otherwise returns false. Called by the insert and replace
110 $self->ut_numbern('pkgsvcnum')
111 || $self->ut_number('pkgpart')
112 || $self->ut_number('svcpart')
113 || $self->ut_number('quantity')
114 || $self->ut_enum('hidden', [ '', 'Y' ] )
116 return $error if $error;
118 return "Unknown pkgpart!" unless $self->part_pkg;
119 return "Unknown svcpart!" unless $self->part_svc;
121 if ( $self->dbdef_table->column('primary_svc') ) {
122 $error = $self->ut_enum('primary_svc', [ '', 'Y' ] );
123 return $error if $error;
131 Returns the FS::part_pkg object (see L<FS::part_pkg>).
137 qsearchs( 'part_pkg', { 'pkgpart' => $self->pkgpart } );
142 Returns the FS::part_svc object (see L<FS::part_svc>).
148 qsearchs( 'part_svc', { 'svcpart' => $self->svcpart } );
157 L<FS::Record>, L<FS::part_pkg>, L<FS::part_svc>, schema.html from the base