From 91fd4ea0e91ee9e6717e0b12e01eebb8f8b21322 Mon Sep 17 00:00:00 2001 From: mark Date: Fri, 29 Apr 2011 08:58:19 +0000 Subject: svc_dish and svc_hardware fixes, #11454 --- FS/FS/Schema.pm | 5 ++++- FS/FS/svc_dish.pm | 8 ++++++-- FS/FS/svc_hardware.pm | 4 ++++ 3 files changed, 14 insertions(+), 3 deletions(-) (limited to 'FS') diff --git a/FS/FS/Schema.pm b/FS/FS/Schema.pm index cc0f21f..5d453ac 100644 --- a/FS/FS/Schema.pm +++ b/FS/FS/Schema.pm @@ -2022,6 +2022,7 @@ sub tables_hashref { 'columns' => [ 'svcnum', 'int', '', '', '', '', 'acctnum', 'varchar', '', 16, '', '', + 'installdate', @date_type, '', '', 'note', 'text', 'NULL', '', '', '', ], 'primary_key' => 'svcnum', @@ -2036,7 +2037,8 @@ sub tables_hashref { 'serial', 'varchar', 'NULL', $char_d, '', '', 'ip_addr', 'varchar', 'NULL', 40, '', '', 'hw_addr', 'varchar', 'NULL', 12, '', '', - 'statusnum','int', 'NULL', '', '', '', + 'smartcard','varchar', 'NULL', 30, '', '', + 'statusnum','int', 'NULL', '', '', '', 'note', 'text', 'NULL', '', '', '', ], 'primary_key' => 'svcnum', @@ -2069,6 +2071,7 @@ sub tables_hashref { 'columns' => [ 'statusnum', 'serial', '', '', '', '', 'label' ,'varchar', '', $char_d, '', '', + 'disabled', 'char', 'NULL', 1, '', '', ], 'primary_key' => 'statusnum', 'unique' => [ ], diff --git a/FS/FS/svc_dish.pm b/FS/FS/svc_dish.pm index 5dac4f4..e254bf5 100644 --- a/FS/FS/svc_dish.pm +++ b/FS/FS/svc_dish.pm @@ -36,6 +36,8 @@ The following fields are currently supported: =item acctnum - DISH account number +=item installdate - Installation date (as Unix timestamp) + =item note - Installation notes: location on property, physical access, etc. =back @@ -62,8 +64,9 @@ sub table_info { 'display_weight' => 58, 'cancel_weight' => 85, 'fields' => { - 'svcnum' => { label => 'Service' }, - 'acctnum' => { label => 'DISH account#', %opts }, + 'svcnum' => { label => 'Service' }, + 'acctnum' => { label => 'DISH account#', %opts }, + 'installdate' => { label => 'Install date', %opts }, 'note' => { label => 'Installation notes', %opts }, } } @@ -112,6 +115,7 @@ sub check { my $error = $self->ut_numbern('svcnum') || $self->ut_text('acctnum') + || $self->ut_numbern('installdate') || $self->ut_textn('note') ; return $error if $error; diff --git a/FS/FS/svc_hardware.pm b/FS/FS/svc_hardware.pm index 96a8e76..8f037f7 100644 --- a/FS/FS/svc_hardware.pm +++ b/FS/FS/svc_hardware.pm @@ -45,6 +45,8 @@ The following fields are currently supported: =item serial - Serial number +=item smartcard - Smartcard number, for devices that use a smartcard + =item statusnum - Service status (see L) =item note - Installation notes: location on property, physical access, etc. @@ -82,6 +84,7 @@ sub table_info { 'serial' => { label => 'Serial number', %opts }, 'hw_addr' => { label => 'Hardware address', %opts }, 'ip_addr' => { label => 'IP address', %opts }, + 'smartcard' => { label => 'Smartcard #', %opts }, 'statusnum' => { label => 'Service status', type => 'select', select_table => 'hardware_status', @@ -165,6 +168,7 @@ sub check { || $self->ut_ip46n('ip_addr') || $self->ut_hexn('hw_addr') || $self->ut_alphan('serial') + || $self->ut_alphan('smartcard') || $self->ut_foreign_keyn('statusnum', 'hardware_status', 'statusnum') || $self->ut_textn('note') ; -- cgit v1.1