projects
/
freeside.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
add config to display note at top, RT#84990
[freeside.git]
/
FS
/
FS
/
part_pkg
/
sql_external.pm
diff --git
a/FS/FS/part_pkg/sql_external.pm
b/FS/FS/part_pkg/sql_external.pm
index
a3866f3
..
5233c54
100644
(file)
--- a/
FS/FS/part_pkg/sql_external.pm
+++ b/
FS/FS/part_pkg/sql_external.pm
@@
-3,7
+3,7
@@
use base qw( FS::part_pkg::discount_Mixin FS::part_pkg::recur_Common );
use strict;
use vars qw( %info );
use strict;
use vars qw( %info );
-use DBI;
+use
FS::
DBI;
#use FS::Record qw(qsearch qsearchs);
tie our %query_style, 'Tie::IxHash', (
#use FS::Record qw(qsearch qsearchs);
tie our %query_style, 'Tie::IxHash', (
@@
-44,6
+44,7
@@
our @detail_cols = ( qw(amount format duration phonenum accountcode
'default' => '',
},
'query' => { 'name' => 'SQL query',
'default' => '',
},
'query' => { 'name' => 'SQL query',
+ 'type' => 'textarea',
'default' => '',
},
'default' => '',
},
@@
-74,10
+75,10
@@
sub calc_recur {
my $price = 0;
my $quantity; # can be overridden; if not we use the default
my $price = 0;
my $quantity; # can be overridden; if not we use the default
- my $dbh = DBI->connect( map { $self->option($_) }
+ my $dbh =
FS::
DBI->connect( map { $self->option($_) }
qw( datasrc db_username db_password )
)
qw( datasrc db_username db_password )
)
- or die $DBI::errstr;
+ or die $
FS::
DBI::errstr;
my $sth = $dbh->prepare( $self->option('query') )
or die $dbh->errstr;
my $sth = $dbh->prepare( $self->option('query') )
or die $dbh->errstr;