diff options
| author | Ivan Kohler <ivan@freeside.biz> | 2016-03-04 11:35:52 -0800 |
|---|---|---|
| committer | Ivan Kohler <ivan@freeside.biz> | 2016-03-04 11:35:52 -0800 |
| commit | f21e3fcff8667f90efcb262e4290937212a21e95 (patch) | |
| tree | 63adbb95d3003f518744382d162c28a5b9eccad6 /httemplate/misc | |
| parent | e75e33aecdc0a432e57d6dd6278a361e0d3bd950 (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 ). |