our $no_update_diff = 0;
our $no_history = 0;
-our $qsearch_qualify_columns = 0;
+our $qsearch_qualify_columns = 1;
our $no_check_foreign = 1; #well, not inefficiently in perl by default anymore
# It's either the bill or ship address of the customer as of the
# invoice date-of-insertion. (Not necessarily the invoice date.)
my $date = $h_cust_bill->history_date;
+ local($FS::Record::qsearch_qualify_columns) = 0;
my $h_cust_main = qsearchs('h_cust_main',
{ custnum => $custnum },
FS::h_cust_main->sql_h_searchs($date)
} else {
# (pkgparts really shouldn't change, right?)
+ local($FS::Record::qsearch_qualify_columns) = 0;
my $h_cust_pkg = qsearchs('h_cust_pkg', { pkgnum => $pkgnum },
FS::h_cust_pkg->sql_h_searchs($date)
);
}
if (!exists $pkgpart_taxclass{$pkgpart}) {
+ local($FS::Record::qsearch_qualify_columns) = 0;
my $h_part_pkg = qsearchs('h_part_pkg', { pkgpart => $pkgpart },
FS::h_part_pkg->sql_h_searchs($date)
);
# Get any per-customer taxname exemptions that were in effect.
my %exempt_cust_taxname;
foreach (keys %all_tax_names) {
+ local($FS::Record::qsearch_qualify_columns) = 0;
my $h_exemption = qsearchs('h_cust_main_exemption', {
'custnum' => $custnum,
'taxname' => $_,
if $DEBUG;
my ($end, $start, $mode) = @_;
+
+ local($FS::Record::qsearch_qualify_columns) = 0;
+
my @cust_svc = $self->_sort_cust_svc(
[ qsearch( 'h_cust_svc',
{ 'pkgnum' => $self->pkgnum, },
FS::h_cust_svc->sql_h_search(@_),
) ]
);
+
if ( defined($mode) && $mode eq 'I' ) {
my %hidden_svcpart = map { $_->svcpart => $_->hidden } $self->part_svc;
return grep { !$hidden_svcpart{$_->svcpart} } @cust_svc;
warn "requiring FS/h_$svcdb.pm" if $DEBUG;
require "FS/h_$svcdb.pm";
+ local($FS::Record::qsearch_qualify_columns) = 0;
my $svc_x = qsearchs(
"h_$svcdb",
{ 'svcnum' => $self->svcnum, },
sub h_usergroup {
my $self = shift;
+ local($FS::Record::qsearch_qualify_columns) = 0;
map { $_->groupnum }
qsearch( 'h_radius_usergroup',
{ svcnum => $self->svcnum },
sub svc_domain {
my $self = shift;
+ local($FS::Record::qsearch_qualify_columns) = 0;
qsearchs( 'h_svc_domain',
{ 'svcnum' => $self->domsvc },
FS::h_svc_domain->sql_h_searchs(@_),
sub srcsvc_acct {
my $self = shift;
+
+ local($FS::Record::qsearch_qualify_columns) = 0;
+
my $h_svc_acct = qsearchs(
'h_svc_acct',
{ 'svcnum' => $self->srcsvc },
sub dstsvc_acct {
my $self = shift;
+
+ local($FS::Record::qsearch_qualify_columns) = 0;
+
my $h_svc_acct = qsearchs(
'h_svc_acct',
{ 'svcnum' => $self->dstsvc },
carp 'Called FS::h_svc_www->domain_record on svcnum ' . $self->svcnum if $DEBUG;
+ local($FS::Record::qsearch_qualify_columns) = 0;
my $domain_record = qsearchs(
'h_domain_record',
{ 'recnum' => $self->recnum },
# Find all locations that, as of $date, did not have
# censusyear = the current year. This includes those
# that have no censusyear.
+local($FS::Record::qsearch_qualify_columns) = 0;
my %h_cust_location = map { $_->locationnum => $_ }
qsearch(
'h_cust_location',
my %class = ('classnum' => $classnum) if $classnum;
my @rows = ( map {[ (0) x $numdays ]} @labels);
+local($FS::Record::qsearch_qualify_columns) = 0;
my $opening_balance = scalar(
qsearch('h_inventory_item',
{ 'svcnum' => '',