diff options
Diffstat (limited to 'httemplate/elements')
| -rw-r--r-- | httemplate/elements/select-part_pkg.html | 5 | ||||
| -rw-r--r-- | httemplate/elements/select-table.html | 1 |
2 files changed, 6 insertions, 0 deletions
diff --git a/httemplate/elements/select-part_pkg.html b/httemplate/elements/select-part_pkg.html index 237d7df0a..22a24bed4 100644 --- a/httemplate/elements/select-part_pkg.html +++ b/httemplate/elements/select-part_pkg.html @@ -43,6 +43,11 @@ if ( exists($opt{'classnum'}) && defined($opt{'classnum'}) ) { } #else -1 or not specified, all classes, so don't set classnum } +$opt{'select'} = 'part_pkg.*, setup_option.optionvalue AS _setup_fee, + recur_option.optionvalue AS _recur_fee' + unless $opt{'select'}; +$opt{'addl_from'} .= FS::part_pkg->join_options_sql; + $opt{'extra_sql'} .= ( keys(%hash) ? ' AND ' : ' WHERE ' ). FS::part_pkg->curuser_pkgs_sql; diff --git a/httemplate/elements/select-table.html b/httemplate/elements/select-table.html index 4b6ddb40e..d7ec015f3 100644 --- a/httemplate/elements/select-table.html +++ b/httemplate/elements/select-table.html @@ -182,6 +182,7 @@ if ( $opt{'records'} ) { unless $opt{'presorted'}; } else { @records = qsearch( { + 'select' => $opt{'select'} || '*', 'table' => $opt{'table'}, 'addl_from' => $opt{'addl_from'}, 'hashref' => $hashref, |