From c7e24bc220519d676b3773de4cc693d17664a353 Mon Sep 17 00:00:00 2001 From: Jonathan Prykop Date: Tue, 8 Mar 2016 15:13:00 -0600 Subject: [PATCH] RT#21463 Option to show disabled package definitions [recently added select/addl_from defaults copied to xmlhttp] --- httemplate/elements/select-part_pkg.html | 4 ++++ httemplate/misc/xmlhttp-part_pkg.cgi | 8 ++++++-- 2 files changed, 10 insertions(+), 2 deletions(-) diff --git a/httemplate/elements/select-part_pkg.html b/httemplate/elements/select-part_pkg.html index ba1d7b72e..caceb5c34 100644 --- a/httemplate/elements/select-part_pkg.html +++ b/httemplate/elements/select-part_pkg.html @@ -125,6 +125,7 @@ if ($opt{'toggle_disabled'}) { order_by pre_options post_options + select ) ) { die "Cannot use toggle_disabled with $someopt" if exists $opt{$someopt}; @@ -155,6 +156,9 @@ if ( exists($opt{'classnum'}) && defined($opt{'classnum'}) ) { die 'Use of toggle_disabled with classnum has not been implemented' if exists $hash{'classnum'}; +# CAUTION: For proper functioning of toggle_disabled, +# please ensure changes to default options are synced with misc/xmlhttp-part_pkg.cgi + $opt{'select'} = 'part_pkg.*, setup_option.optionvalue AS _setup_fee, recur_option.optionvalue AS _recur_fee' unless $opt{'select'}; 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); - -- 2.11.0