use FS::svc_realestate;
use FS::saved_search;
use FS::sector_coverage;
+ use FS::svc_group;
# Sammath Naur
if ( $FS::Mason::addl_handler_use ) {
],
},
- realestate_location => {
+ 'realestate_location' => {
'columns' => [
'realestatelocnum', 'serial', '', '', '', '',
'agentnum', 'int', 'NULL', '', '', '',
- 'location_title', 'varchar', '', $char_d, '', '',
+ 'location_title', 'varchar', '', $char_d, '', '',
'address1', 'varchar', 'NULL', $char_d, '', '',
'address2', 'varchar', 'NULL', $char_d, '', '',
'city', 'varchar', 'NULL', $char_d, '', '',
'zip', 'char', 'NULL', 5, '', '',
'disabled', 'char', 'NULL', 1, '', '',
],
- primary_key => 'realestatelocnum',
- 'unique' => [ ['location_title'] ],
- 'index' => [ ['agentnum'], ['disabled'] ],
+ 'primary_key' => 'realestatelocnum',
+ 'unique' => [ ['location_title'] ],
+ 'index' => [ ['agentnum'], ['disabled'] ],
'foreign_keys' => [
{columns => ['agentnum'], table => 'agent'},
],
},
- svc_realestate => {
- columns => [
+ 'svc_realestate' => {
+ 'columns' => [
'svcnum', 'serial', '', '', '', '',
'realestatenum', 'int', 'NULL', '', '', '',
],
- primary_key => 'svcnum',
- index => [],
+ 'primary_key' => 'svcnum',
+ 'index' => [],
+ },
+
+ 'svc_group' => {
+ 'columns' => [
+ 'svcnum', 'int', '', '', '', '',
+ 'max_accounts', 'int', '', '', '', '',
+ ],
+ 'primary_key' => 'svcnum',
+ 'unique' => [],
+ 'index' => [],
+ 'foreign_keys' => [
+ { columns => [ 'svcnum' ],
+ table => 'cust_svc',
+ },
+ ],
},
+
# name type nullability length default local
#'new_table' => {
--- /dev/null
+package FS::h_svc_group;
+
+use strict;
+use base qw( FS::h_Common FS::svc_group );
+
+sub table { 'h_svc_group' };
+
+=head1 NAME
+
+FS::h_svc_group - Historical installed group service objects
+
+=head1 SYNOPSIS
+
+=head1 DESCRIPTION
+
+An FS::h_svc_group object represents a historical group service.
+FS::h_svc_group inherits from FS::h_Common and FS::svc_group.
+
+=head1 BUGS
+
+=head1 SEE ALSO
+
+L<FS::h_Common>, L<FS::svc_group>, L<FS::Record>, schema.html from the base
+documentation.
+
+=cut
+
+1;
+
--- /dev/null
+package FS::svc_group;
+use base qw( FS::svc_Common );
+
+use strict;
+#use FS::Record qw( qsearch qsearchs );
+#use FS::cust_svc;
+
+=head1 NAME
+
+FS::svc_group - Object methods for svc_group records
+
+=head1 SYNOPSIS
+
+ use FS::svc_group;
+
+ $record = new FS::svc_group \%hash;
+ $record = new FS::svc_group { 'column' => 'value' };
+
+ $error = $record->insert;
+
+ $error = $new_record->replace($old_record);
+
+ $error = $record->delete;
+
+ $error = $record->check;
+
+ $error = $record->suspend;
+
+ $error = $record->unsuspend;
+
+ $error = $record->cancel;
+
+=head1 DESCRIPTION
+
+An FS::svc_group object represents a group. FS::svc_group inherits from
+FS::svc_Common. The following fields are currently supported:
+
+=over 4
+
+=item max_accounts - Maximum number of group members
+
+=back
+
+=head1 METHODS
+
+=over 4
+
+=item new HASHREF
+
+Creates a new group. To add the group to the database, see L<"insert">.
+
+Note that this stores the hash reference, not a distinct copy of the hash it
+points to. You can ask the object for a copy with the I<hash> method.
+
+=cut
+
+sub table { 'svc_group'; }
+
+sub table_info {
+ {
+ 'name' => 'Group',
+ 'name_plural' => 'Groups', #optional,
+ 'longname_plural' => 'Groups', #optional
+ 'sorts' => 'svcnum', # optional sort field (or arrayref of sort fields, main first)
+ 'display_weight' => 100,
+ 'cancel_weight' => 100,
+ 'fields' => {
+ 'svcnum' => { label => 'Service' },
+ 'max_accounts' => {
+ 'label' => 'Maximum number of accounts',
+ 'type' => 'text',
+ 'disable_inventory' => 1,
+ },
+
+ },
+ };
+}
+
+=item search_sql STRING
+
+Class method which returns an SQL fragment to search for the given string.
+
+=cut
+
+#if we only have a quantity, then there's nothing to search on except svcnum
+sub search_sql {
+ my($class, $string) = @_;
+ $class->search_sql_field('svcnum', $string);
+}
+
+
+=item label
+
+Returns a meaningful identifier for this group
+
+=cut
+
+sub label {
+ my $self = shift;
+ $self->svcnum; #i guess?
+}
+
+=item insert
+
+Adds this record to the database. If there is an error, returns the error,
+otherwise returns false.
+
+The additional fields pkgnum and svcpart (see L<FS::cust_svc>) should be
+defined. An FS::cust_svc record will be created and inserted.
+
+=cut
+
+#sub insert {
+# my $self = shift;
+# my $error;
+#
+# $error = $self->SUPER::insert;
+# return $error if $error;
+#
+# '';
+#}
+
+=item delete
+
+Delete this record from the database.
+
+=cut
+
+#sub delete {
+# my $self = shift;
+# my $error;
+#
+# $error = $self->SUPER::delete;
+# return $error if $error;
+#
+# '';
+#}
+
+
+=item replace OLD_RECORD
+
+Replaces the OLD_RECORD with this one in the database. If there is an error,
+returns the error, otherwise returns false.
+
+=cut
+
+#sub replace {
+# my ( $new, $old ) = ( shift, shift );
+# my $error;
+#
+# $error = $new->SUPER::replace($old);
+# return $error if $error;
+#
+# '';
+#}
+
+=item suspend
+
+Called by the suspend method of FS::cust_pkg (see L<FS::cust_pkg>).
+
+=item unsuspend
+
+Called by the unsuspend method of FS::cust_pkg (see L<FS::cust_pkg>).
+
+=item cancel
+
+Called by the cancel method of FS::cust_pkg (see L<FS::cust_pkg>).
+
+=item check
+
+Checks all fields to make sure this is a valid group. If there is
+an error, returns the error, otherwise returns false. Called by the insert
+and repalce methods.
+
+=cut
+
+sub check {
+ my $self = shift;
+
+ my $x = $self->setfixed;
+ return $x unless ref($x);
+ my $part_svc = $x;
+
+ my $error = $self->ut_numbern('svcnum')
+ || $self->ut_number('max_accounts');
+ return $error if $error;
+
+ $self->SUPER::check;
+}
+
+=back
+
+=head1 BUGS
+
+=head1 SEE ALSO
+
+L<FS::svc_Common>, L<FS::Record>, L<FS::cust_svc>, L<FS::part_svc>,
+L<FS::cust_pkg>, schema.html from the base documentation.
+
+=cut
+
+1;
+
t/access_user_session_log.t
FS/access_user_session_log.pm
t/access_user_session_log.t
+FS/svc_group.pm
+FS/h_svc_group.pm
<TH ALIGN="left">Generic</TH>
<TH ALIGN="left">Access</TH>
<TH ALIGN="left">Telephony</TH>
+ <TH ALIGN="left">Video</TH>
<!-- <TH>Hosting</TH>
<TH>Colocation</TH>
-->
<LI><B>svc_acct</B>: Accounts - anything with a username (mailbox, shell, RADIUS, etc.)
<LI><B>svc_hardware</B>: Equipment supplied to customers
<LI><B>svc_external</B>: Externally-tracked service
+ <LI><B>svc_group</B>: Generic group service
</UL>
</TD>
<TD VALIGN="top">
<UL STYLE="margin:0">
<LI><B>svc_dsl</B>: DSL
- <LI><B>svc_broadband</B>: Wireless broadband
+ <LI><B>svc_broadband</B>: Fixed wireless broadband
<LI><B>svc_cable</B>: Cable
- <LI><B>svc_dish</B>: DISH Network
+ <LI><B>svc_fiber</B>: Fiber-to-the-premise service
</UL>
</TD>
<TD VALIGN="top">
<UL STYLE="margin:0">
<LI><B>svc_phone</B>: Customer phone number
<LI><B>svc_pbx</B>: Customer PBX
+ <LI><B>svc_conferencing</B>: Conferencing service
<LI><B>svc_circuit</B>: Phone circuits other than DSL
</UL>
</TD>
+ <TD VALIGN="top">
+ <UL STYLE="margin:0">
+ <LI><B>svc_video</B>: IPTV or video-on-demand service
+ <LI><B>svc_dish</B>: DISH Network
+ </UL>
+ </TD>
</TR>
</TABLE>
<BR>
<TR>
<TH ALIGN="left">Hosting</TH>
<TH ALIGN="left">Colocation</TH>
+ <TH ALIGN="left">Alarm</TH>
<TH ALIGN="left">Real Estate</TH>
</TR>
<TD VALIGN="top">
</TD>
<TD VALIGN="top">
<UL STYLE="margin:0">
+ <LI><B>svc_alarm</B>: Alarm service
+ </UL>
+ </TD>
+ <TD VALIGN="top">
+ <UL STYLE="margin:0">
<LI><B>svc_realestate</B>: Real estate properties
</UL>
</TD>
</TR>
<TABLE>
-<!-- <LI>svc_charge - One-time charges (Partially unimplemented)
- <LI>svc_wo - Work orders (Partially unimplemented)
--->
</BODY>
</HTML>
unless ( $hashref->{svcpart} ) {
$help = ' '.
include('/elements/popup_link.html',
- 'action' => $p.'docs/part_svc-table.html',
- 'label' => 'help',
+ 'action' => $p.'docs/part_svc-table.html',
+ 'label' => 'help',
'actionlabel' => 'Service table help',
- 'width' => 763,
- #'height' => 400,
+ 'width' => 960,
+ 'height' => 400,
);
}
projects / freeside.git / commitdiff