qsearch({
'select' => 'cust_bill_pay_pkg.*',
'table' => 'cust_bill_pay_pkg',
- 'addl_from' => ' LEFT JOIN cust_bill_pay USING billpaynum '.
- ' LEFT JOIN cust_bill_pkg USING billpkgnum ',
- 'hashref' => { 'invnum' => $self->invnum,
- 'pkgnum' => $pkgnum,
- },
+ 'addl_from' => ' LEFT JOIN cust_bill_pay USING ( billpaynum ) '.
+ ' LEFT JOIN cust_bill_pkg USING ( billpkgnum ) ',
+ 'extra_sql' => ' WHERE cust_bill_pkg.invnum = '. $self->invnum.
+ " AND cust_bill_pkg.pkgnum = $pkgnum",
});
}
qsearch({
'select' => 'cust_credit_bill_pkg.*',
'table' => 'cust_credit_bill_pkg',
- 'addl_from' => ' LEFT JOIN cust_credit_bill USING creditbillnum '.
- ' LEFT JOIN cust_bill_pkg USING billpkgnum ',
- 'hashref' => { 'invnum' => $self->invnum,
- 'pkgnum' => $pkgnum,
- },
+ 'addl_from' => ' LEFT JOIN cust_credit_bill USING ( creditbillnum ) '.
+ ' LEFT JOIN cust_bill_pkg USING ( billpkgnum ) ',
+ 'extra_sql' => ' WHERE cust_bill_pkg.invnum = '. $self->invnum.
+ " AND cust_bill_pkg.pkgnum = $pkgnum",
});
}