projects
/
freeside.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
RT# 74693 - Added Bulk edit of rates only
[freeside.git]
/
httemplate
/
misc
/
xmlhttp-part_pkg.cgi
diff --git
a/httemplate/misc/xmlhttp-part_pkg.cgi
b/httemplate/misc/xmlhttp-part_pkg.cgi
index
1878330
..
885d346
100644
(file)
--- 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
# 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
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',
my @records = qsearch( {
'table' => 'part_pkg',
+ 'select' => $select,
+ 'addl_from' => $addl_from,
'hashref' => {},
'extra_sql' => $extra_sql,
'order_by' => "ORDER BY pkg",
'hashref' => {},
'extra_sql' => $extra_sql,
'order_by' => "ORDER BY pkg",
@@
-26,6
+32,4
@@
my @return = map {
}
} @records;
}
} @records;
-print STDERR Dumper(\@return);
-
</%init>
</%init>