From 0806f9fdbf2086671c151b3bcb078dc008e96f6c Mon Sep 17 00:00:00 2001 From: Mark Wells Date: Fri, 23 Oct 2015 12:03:24 -0700 Subject: allow a default rate detail for each CDR type, #38633 --- httemplate/browse/part_pkg.cgi | 8 ++++++++ 1 file changed, 8 insertions(+) (limited to 'httemplate/browse/part_pkg.cgi') diff --git a/httemplate/browse/part_pkg.cgi b/httemplate/browse/part_pkg.cgi index 07f104e55..1e8b51030 100755 --- a/httemplate/browse/part_pkg.cgi +++ b/httemplate/browse/part_pkg.cgi @@ -88,6 +88,14 @@ if ( $cgi->param('missing_recur_fee') ) { )"; } +if ( $cgi->param('ratenum') =~ /^(\d+)$/ ) { + push @where, "EXISTS( SELECT 1 FROM part_pkg_option + WHERE optionname LIKE '%ratenum' + AND optionvalue = '$1' + AND part_pkg_option.pkgpart = part_pkg.pkgpart + )"; +} + if ( $cgi->param('family') =~ /^(\d+)$/ ) { $family_pkgpart = $1; push @where, "family_pkgpart = $1"; -- cgit v1.2.1