diff options
author | ivan <ivan> | 2010-10-22 06:14:24 +0000 |
---|---|---|
committer | ivan <ivan> | 2010-10-22 06:14:24 +0000 |
commit | 3e8635e9b88abdd5da862870184d9318c076933c (patch) | |
tree | f1f43ec3be35e69730c6b0875700fc608696e9c6 /FS/FS/cust_pay_void.pm | |
parent | 6ad040a170f84a5e3d7d7355b2fb00bf2d17b1ef (diff) |
display both original usernum and void usernum vfor voided payments, RT#10280
Diffstat (limited to 'FS/FS/cust_pay_void.pm')
-rw-r--r-- | FS/FS/cust_pay_void.pm | 39 |
1 files changed, 36 insertions, 3 deletions
diff --git a/FS/FS/cust_pay_void.pm b/FS/FS/cust_pay_void.pm index 45287a4..1a298ba 100644 --- a/FS/FS/cust_pay_void.pm +++ b/FS/FS/cust_pay_void.pm @@ -1,12 +1,14 @@ package FS::cust_pay_void; use strict; -use base qw( FS::otaker_Mixin FS::payinfo_Mixin FS::Record ); +use base qw( FS::otaker_Mixin FS::payinfo_Mixin FS::cust_main_Mixin + FS::Record ); use vars qw( @encrypted_fields $otaker_upgrade_kludge ); use Business::CreditCard; use FS::UID qw(getotaker); -use FS::Record qw(qsearchs dbh fields); # qsearch ); +use FS::Record qw(qsearch qsearchs dbh fields); use FS::CurrentUser; +use FS::access_user; use FS::cust_pay; #use FS::cust_bill; #use FS::cust_bill_pay; @@ -219,7 +221,8 @@ sub check { return $error if $error; } - $self->usernum($FS::CurrentUser::CurrentUser->usernum) unless $self->usernum; + $self->void_usernum($FS::CurrentUser::CurrentUser->usernum) + unless $self->void_usernum; $self->SUPER::check; } @@ -235,11 +238,41 @@ sub cust_main { qsearchs( 'cust_main', { 'custnum' => $self->custnum } ); } +=item void_access_user + +Returns the voiding employee object (see L<FS::access_user>). + +=cut + +sub void_access_user { + my $self = shift; + qsearchs('access_user', { 'usernum' => $self->void_usernum } ); +} + # Used by FS::Upgrade to migrate to a new database. sub _upgrade_data { # class method my ($class, %opts) = @_; + + my $sql = "SELECT usernum FROM access_user WHERE username = ( SELECT history_user FROM h_cust_pay_void WHERE paynum = ? AND history_action = 'insert' ) "; + my $sth = dbh->prepare($sql) or die dbh->errstr; + + foreach my $cust_pay_void (qsearch('cust_pay_void', {'void_usernum' => ''})) { + $sth->execute($cust_pay_void->paynum) or die $sth->errstr; + my $usernum = $sth->fetchrow_arrayref->[0] or next; + if ( $usernum ) { + $cust_pay_void->void_usernum($usernum); + my $error = $cust_pay_void->replace; + die $error if $error; + } else { + warn "cust_pay_void upgrade: can't find access_user record for ". $cust_pay_void->paynum. "\n"; + } + } + local($otaker_upgrade_kludge) = 1; $class->_upgrade_otaker(%opts); + + #XXX look for the h_cust_pay delete records and when that's a different + # usernum, set usernum } =back |