diff options
| author | Jonathan Prykop <jonathan@freeside.biz> | 2016-03-08 15:13:00 -0600 |
|---|---|---|
| committer | Jonathan Prykop <jonathan@freeside.biz> | 2016-03-08 15:13:00 -0600 |
| commit | c7e24bc220519d676b3773de4cc693d17664a353 (patch) | |
| tree | 29e46b6b913fd24394138b88c5fd2e1ef76d3a76 /httemplate/misc/xmlhttp-part_pkg.cgi | |
| parent | d4d0595a16d26404adc33acd6c1002d94cf132e4 (diff) | |
RT#21463 Option to show disabled package definitions [recently added select/addl_from defaults copied to xmlhttp]
Diffstat (limited to 'httemplate/misc/xmlhttp-part_pkg.cgi')
| -rw-r--r-- | httemplate/misc/xmlhttp-part_pkg.cgi | 8 |
1 files changed, 6 insertions, 2 deletions
diff --git a/httemplate/misc/xmlhttp-part_pkg.cgi b/httemplate/misc/xmlhttp-part_pkg.cgi index 187833025..885d3460f 100644 --- a/httemplate/misc/xmlhttp-part_pkg.cgi +++ b/httemplate/misc/xmlhttp-part_pkg.cgi @@ -3,6 +3,10 @@ # default returned records must maintain consistency with /elements/select-part_pkg.html +my $select = 'part_pkg.*, setup_option.optionvalue AS _setup_fee, + recur_option.optionvalue AS _recur_fee'; +my $addl_from .= FS::part_pkg->join_options_sql; + my $extra_sql = ' WHERE ' . FS::part_pkg->curuser_pkgs_sql; # equivalent to agent_virt=1 and agent_null=1 in /elements/select-table.html @@ -13,6 +17,8 @@ $extra_sql .= ' AND ' . my @records = qsearch( { 'table' => 'part_pkg', + 'select' => $select, + 'addl_from' => $addl_from, 'hashref' => {}, 'extra_sql' => $extra_sql, 'order_by' => "ORDER BY pkg", @@ -26,6 +32,4 @@ my @return = map { } } @records; -print STDERR Dumper(\@return); - </%init> |