diff options
author | ivan <ivan> | 2008-03-04 21:06:42 +0000 |
---|---|---|
committer | ivan <ivan> | 2008-03-04 21:06:42 +0000 |
commit | 41ed76e0e3625c9f175743d253ad06fc67302d0f (patch) | |
tree | 45d40b635e7450371356594a26213533926dc8e2 /FS | |
parent | acd8edaf5852735359e32c70b78dabfeb7b32a89 (diff) |
fix cust_pay.otaker population
Diffstat (limited to 'FS')
-rw-r--r-- | FS/FS/cust_pay.pm | 9 |
1 files changed, 4 insertions, 5 deletions
diff --git a/FS/FS/cust_pay.pm b/FS/FS/cust_pay.pm index 90a14ea02..acb284429 100644 --- a/FS/FS/cust_pay.pm +++ b/FS/FS/cust_pay.pm @@ -432,8 +432,6 @@ sub check { # " already exists"; # } - $self->otaker(getotaker); - $self->SUPER::check; } @@ -675,8 +673,9 @@ sub _upgrade_data { #class method #not the most efficient, but hey, it only has to run once - my $count_sql = - "SELECT COUNT(*) FROM cust_pay WHERE otaker IS NULL OR otaker = ''"; + my $where = "WHERE otaker IS NULL OR otaker = '' OR otaker = 'ivan' "; + + my $count_sql = "SELECT COUNT(*) FROM cust_pay $where"; my $sth = dbh->prepare($count_sql) or die dbh->errstr; $sth->execute or die $sth->errstr; @@ -691,7 +690,7 @@ sub _upgrade_data { #class method my $cust_pay = qsearchs( { 'table' => 'cust_pay', 'hashref' => {}, - 'extra_sql' => "WHERE otaker IS NULL OR otaker = ''", + 'extra_sql' => $where, 'order_by' => 'ORDER BY paynum LIMIT 1', } ); |