diff options
| author | Ivan Kohler <ivan@freeside.biz> | 2016-03-04 11:35:51 -0800 |
|---|---|---|
| committer | Ivan Kohler <ivan@freeside.biz> | 2016-03-04 11:35:51 -0800 |
| commit | d256989a19dd100823d35a11929edb1ae07d9883 (patch) | |
| tree | 6074cd4525de3c2b0f177e1088a86673bba1697b /httemplate/misc | |
| parent | 9000d0d9daea14055bda2c28b3a33c5742930460 (diff) | |
optimize package list on order new package, RT#39822
Diffstat (limited to 'httemplate/misc')
| -rw-r--r-- | httemplate/misc/cust-part_pkg.cgi | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/httemplate/misc/cust-part_pkg.cgi b/httemplate/misc/cust-part_pkg.cgi index dc9ba2af1..8a46c1dd3 100644 --- a/httemplate/misc/cust-part_pkg.cgi +++ b/httemplate/misc/cust-part_pkg.cgi @@ -23,7 +23,10 @@ if ( $classnum > 0 ) { } #else -1, all classes, so don't set classnum my @part_pkg = qsearch({ + 'select' => 'part_pkg.*, setup_option.optionvalue AS _setup_fee, + recur_option.optionvalue AS _recur_fee', 'table' => 'part_pkg', + 'addl_from' => FS::part_pkg->join_options_sql, 'hashref' => \%hash, 'extra_sql' => ' AND '. $FS::CurrentUser::CurrentUser->agentnums_sql( 'null'=>1 ). |