From 0b425dc3033774ab661a348d8ac729a70be7f794 Mon Sep 17 00:00:00 2001 From: Jonathan Prykop Date: Fri, 23 Jan 2015 13:06:32 -0600 Subject: [PATCH] RT 32226, only displaying DID order link if customer has DID order --- httemplate/view/cust_main/packages/services.html | 17 +++++++++++++++-- 1 file changed, 15 insertions(+), 2 deletions(-) diff --git a/httemplate/view/cust_main/packages/services.html b/httemplate/view/cust_main/packages/services.html index 5fe41a38c..fa193d636 100644 --- a/httemplate/view/cust_main/packages/services.html +++ b/httemplate/view/cust_main/packages/services.html @@ -97,9 +97,22 @@ function clearhint_search_cust_svc(obj, str) { % local $opt{'num_avail'} = $part_svc->num_avail;
<% svc_provision_link($cust_pkg, $part_svc, \%opt, $curuser) %> % } -% #XXX if there's orders for this customer { +% if ( +% qsearch({ +% 'table' => 'did_order', +% 'hashref' => { 'custnum' => $cust_pkg->custnum }, +% 'extra_sql' => ' LIMIT 1' +% }) +% || +% qsearch({ +% 'table' => 'did_order_item', +% 'hashref' => { 'custnum' => $cust_pkg->custnum }, +% 'addl_from' => ' INNER JOIN did_order ON did_order_item.ordernum = did_order.ordernum', +% 'extra_sql' => ' LIMIT 1' +% }) +% ) {
<% mt('Browse Received DID Inventory') |h %> -% #} +% } % } -- 2.11.0