X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=FS%2FFS%2Fcust_pay_void.pm;h=f1193cd24878f6fa30d33d0ad90115a881450218;hp=de05f710bf5720a0752b61fe71903ef219e43a09;hb=c5588173be7a36ee82a037e3809e6ecc7f14917f;hpb=5e05724a635a22776f1b973f5d7e77989da4e048 diff --git a/FS/FS/cust_pay_void.pm b/FS/FS/cust_pay_void.pm index de05f710b..f1193cd24 100644 --- a/FS/FS/cust_pay_void.pm +++ b/FS/FS/cust_pay_void.pm @@ -1,18 +1,23 @@ package FS::cust_pay_void; + use strict; -use vars qw( @ISA @encrypted_fields ); +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; #use FS::cust_pay_refund; #use FS::cust_main; - -@ISA = qw( FS::Record FS::payinfo_Mixin ); +use FS::cust_pkg; @encrypted_fields = ('payinfo'); +$otaker_upgrade_kludge = 0; =head1 NAME @@ -40,24 +45,48 @@ are currently supported: =over 4 -=item paynum - primary key (assigned automatically for new payments) +=item paynum + +primary key (assigned automatically for new payments) + +=item custnum -=item custnum - customer (see L) +customer (see L) -=item paid - Amount of this payment +=item paid -=item _date - specified as a UNIX timestamp; see L. Also see +Amount of this payment + +=item _date + +specified as a UNIX timestamp; see L. Also see L and L for conversion functions. -=item payby - `CARD' (credit cards), `CHEK' (electronic check/ACH), +=item otaker + +order taker (see L) + +=item payby + +`CARD' (credit cards), `CHEK' (electronic check/ACH), `LECB' (phone bill billing), `BILL' (billing), `CASH' (cash), `WEST' (Western Union), `MCRD' (Manual credit card), or `COMP' (free) -=item payinfo - card number, check #, or comp issuer (4-8 lowercase alphanumerics; think username), respectively +=item payinfo + +card number, check #, or comp issuer (4-8 lowercase alphanumerics; think username), respectively + +=item paybatch + +text field for tracking card processing -=item paybatch - text field for tracking card processing +=item closed -=item closed - books closed flag, empty or `Y' +books closed flag, empty or `Y' + +=item pkgnum + +Desired pkgnum when using experimental package balances. =item void_date @@ -128,15 +157,13 @@ sub unvoid { Deletes this voided payment. You probably don't want to use this directly; see the B method to add the original payment back. -=item replace OLD_RECORD +=item replace [ OLD_RECORD ] -Currently unimplemented. +You can, but probably shouldn't modify voided payments... -=cut - -sub replace { - return "Can't modify voided payments!"; -} +Replaces the OLD_RECORD with this one in the database, or, if OLD_RECORD is not +supplied, replaces this record. If there is an error, returns the error, +otherwise returns false. =item check @@ -156,6 +183,7 @@ sub check { || $self->ut_number('_date') || $self->ut_textn('paybatch') || $self->ut_enum('closed', [ '', 'Y' ]) + || $self->ut_foreign_keyn('pkgnum', 'cust_pkg', 'pkgnum') || $self->ut_numbern('void_date') || $self->ut_textn('reason') ; @@ -179,11 +207,12 @@ sub check { $payinfo =~ s/\D//g; $self->payinfo($payinfo); if ( $self->payinfo ) { - $self->payinfo =~ /^(\d{13,16})$/ + $self->payinfo =~ /^(\d{13,16}|\d{8,9})$/ or return "Illegal (mistyped?) credit card number (payinfo)"; $self->payinfo($1); validate($self->payinfo) or return "Illegal credit card number"; - return "Unknown card type" if cardtype($self->payinfo) eq "Unknown"; + return "Unknown card type" if $self->payinfo !~ /^99\d{14}$/ #token + && cardtype($self->payinfo) eq "Unknown"; } else { $self->payinfo('N/A'); } @@ -193,7 +222,8 @@ sub check { return $error if $error; } - $self->otaker(getotaker); + $self->void_usernum($FS::CurrentUser::CurrentUser->usernum) + unless $self->void_usernum; $self->SUPER::check; } @@ -209,6 +239,44 @@ sub cust_main { qsearchs( 'cust_main', { 'custnum' => $self->custnum } ); } +=item void_access_user + +Returns the voiding employee object (see L). + +=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' ORDER BY history_date LIMIT 1 ) "; + 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 $row = $sth->fetchrow_arrayref; + my $usernum = $row ? $row->[0] : ''; + 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 =head1 BUGS