X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=FS%2FFS%2Fsvc_dsl.pm;h=8c47f8887e9150eb90805f86abc70ac8fbdca504;hb=573139dbd6c37808697bfa72a3a468bb0980d4dd;hp=da62dc6bb45e38b062d91ae13f34177dc7b3e034;hpb=53b930cc67361258ea40f793ca1eb0b3d976bd9c;p=freeside.git diff --git a/FS/FS/svc_dsl.pm b/FS/FS/svc_dsl.pm index da62dc6bb..8c47f8887 100644 --- a/FS/FS/svc_dsl.pm +++ b/FS/FS/svc_dsl.pm @@ -4,6 +4,9 @@ use strict; use vars qw( @ISA $conf $DEBUG $me ); use FS::Record qw( qsearch qsearchs ); use FS::svc_Common; +use FS::dsl_device; +use FS::dsl_note; +use FS::qual; @ISA = qw( FS::svc_Common ); $DEBUG = 0; @@ -73,12 +76,18 @@ Vendor/telco DSL order status (e.g. (N)ew, (A)ssigned, (R)ejected, (M)revised, =item phonenum - DSL Telephone Number +=item gateway_access_number - Gateway access number, if different + =item loop_type - Loop-type - vendor/telco-specific =item local_voice_provider - Local Voice Provider's name =item circuitnum - Circuit # +=item vpi + +=item vci + =item rate_band - Rate Band =item isp_chg @@ -99,10 +108,6 @@ Ikano-specific fields, do not use otherwise =item last_pull - time of last data pull from vendor/telco -=item notes - -DSL order notes placed by staff or vendor/telco on the vendor/telco order - =back @@ -126,53 +131,56 @@ sub table_info { my %dis2 = ( disable_inventory=>1, disable_select=>1 ); { - 'name' => 'DSL', - 'sorts' => [ 'phonenum' ], - 'display_weight' => 55, - 'cancel_weight' => 75, - 'fields' => { - 'pushed' => { label => 'Pushed', - type => 'disabled' }, - 'desired_due_date' => { label => 'Desired Due Date', %dis2, }, - 'due_date' => { label => 'Due Date', %dis2, }, - 'vendor_order_id' => { label => 'Vendor Order Id', %dis2, }, - 'vendor_qual_id' => { label => 'Vendor Qualification Id', - type => 'disabled' }, - 'vendor_order_type' => { label => 'Vendor Order Type', - disable_inventory => 1, - }, - 'vendor_order_status' => { label => 'Vendor Order Status', - disable_inventory => 1, - }, - 'first' => { label => 'First Name', %dis2, }, - 'last' => { label => 'Last Name', %dis2, }, - 'company' => { label => 'Company Name', %dis2, }, - 'phonenum' => { label => 'Service Telephone Number', }, - 'loop_type' => { label => 'Loop Type', - disable_inventory => 1, - }, - 'local_voice_provider' => { label => 'Local Voice Provider', - disable_inventory => 1, - }, - 'circuitnum' => { label => 'Circuit #', }, - 'rate_band' => { label => 'Rate Band', - disable_inventory => 1, - }, - 'isp_chg' => { label => 'ISP Changing?', - type => 'checkbox', %dis2 }, - 'isp_prev' => { label => 'Current or Previous ISP', - disable_inventory => 1, - }, - 'username' => { label => 'PPPoE Username', - type => 'text', - }, - 'password' => { label => 'PPPoE Password', %dis2 }, - 'staticips' => { label => 'Static IPs', %dis1 }, - 'monitored' => { label => 'Monitored', - type => 'checkbox', %dis2 }, - 'last_pull' => { label => 'Last Pull', type => 'disabled' }, - 'notes' => { label => 'Order Notes', %dis1 }, - }, + 'name' => 'DSL', + 'name_plural' => 'DSLs', + 'lcname_plural' => 'DSLs', + 'sorts' => [ 'phonenum' ], + 'display_weight' => 55, + 'cancel_weight' => 75, + 'ip_field' => 'staticips', + 'fields' => { + 'pushed' => { label => 'Pushed', + type => 'disabled' }, + 'desired_due_date' => { label => 'Desired Due Date', %dis2, }, + 'due_date' => { label => 'Due Date', %dis2, }, + 'vendor_order_id' => { label => 'Vendor Order ID', %dis2, }, + 'vendor_qual_id' => { label => 'Vendor Qualification ID', + type => 'disabled' }, + 'vendor_order_type' => { label => 'Vendor Order Type', + disable_inventory => 1, }, + 'vendor_order_status' => { label => 'Vendor Order Status', + disable_inventory => 1, }, + 'first' => { label => 'First Name', %dis2, }, + 'last' => { label => 'Last Name', %dis2, }, + 'company' => { label => 'Company Name', %dis2, }, + 'phonenum' => { label => 'Service Telephone Number', }, + 'gateway_access_number' => { label => 'Gateway Access Number'. + ' (if different)', }, + 'loop_type' => { label => 'Loop Type', + disable_inventory => 1, }, + 'local_voice_provider' => { label => 'Local Voice Provider', + disable_inventory => 1, }, + 'circuitnum' => { label => 'Circuit #', }, + 'rate_band' => { label => 'Rate Band', + disable_inventory => 1, }, + 'vpi' => { label => 'VPI', + disable_inventory => 1 }, + 'vci' => { label => 'VCI', + disable_inventory => 1 }, + 'isp_chg' => { label => 'ISP Changing?', + type => 'checkbox', + %dis2, }, + 'isp_prev' => { label => 'Current or Previous ISP', + disable_inventory => 1, }, + 'username' => { label => 'PPPoE Username', + type => 'text', }, + 'password' => { label => 'PPPoE Password', %dis2 }, + 'staticips' => { label => 'Static IPs', %dis1 }, + 'monitored' => { label => 'Monitored', + type => 'checkbox', %dis2 }, + 'last_pull' => { label => 'Last Pull', + type => 'disabled' }, + }, }; } @@ -186,6 +194,16 @@ sub label { return $self->svcnum; } +=item notes + +Returns the set of FS::dsl_notes associated with this service + +=cut +sub notes { + my $self = shift; + qsearch( 'dsl_note', { 'svcnum' => $self->svcnum } ); +} + =item insert Adds this record to the database. If there is an error, returns the error, @@ -229,20 +247,23 @@ sub check { my $error = $self->ut_numbern('svcnum') || $self->ut_numbern('pushed') - || $self->ut_number('desired_due_date') + || $self->ut_numbern('desired_due_date') || $self->ut_numbern('due_date') || $self->ut_textn('vendor_order_id') || $self->ut_textn('vendor_qual_id') - || $self->ut_alpha('vendor_order_type') + || $self->ut_alphan('vendor_order_type') || $self->ut_alphan('vendor_order_status') - || $self->ut_text('first') - || $self->ut_text('last') + || $self->ut_textn('first') + || $self->ut_textn('last') || $self->ut_textn('company') || $self->ut_numbern('phonenum') + || $self->ut_numbern('gateway_access_number') || $self->ut_alphasn('loop_type') || $self->ut_textn('local_voice_provider') || $self->ut_textn('circuitnum') || $self->ut_textn('rate_band') + || $self->ut_numbern('vpi') + || $self->ut_numbern('vci') || $self->ut_alphan('isp_chg') || $self->ut_textn('isp_prev') || $self->ut_textn('username') @@ -250,13 +271,57 @@ sub check { || $self->ut_textn('staticips') || $self->ut_enum('monitored', [ '', 'Y' ]) || $self->ut_numbern('last_pull') - || $self->ut_textn('notes') ; return $error if $error; + $self->gateway_access_number('') + if $self->phonenum && $self->phonenum eq $self->gateway_access_number; + $self->SUPER::check; } +=item gateway_access_or_phonenum + +=cut + +sub gateway_access_or_phonenum { + my $self = shift; + $self->gateway_access_number || $self->phonenum; +} + +=item dsl_device + +Returns the MAC addresses associated with this DSL service, as FS::dsl_device +objects. + +=cut + +sub dsl_device { + my $self = shift; + qsearch('dsl_device', { 'svcnum' => $self->svcnum }); +} + +sub predelete_hook_first { + my $self = shift; + my @exports = $self->part_svc->part_export_dsl_pull; + return 'More than one DSL-pulling export attached' if scalar(@exports) > 1; + if ( scalar(@exports) == 1 ) { + my $export = $exports[0]; + return $export->dsl_pull($self); + } + ''; +} + +sub predelete_hook { + my $self = shift; + my @notes = $self->notes; + foreach my $note ( @notes ) { + my $error = $note->delete; + return $error if $error; + } + ''; +} + =back =head1 SEE ALSO