RT 32226, only displaying DID order link if customer has DID order

diff --git a/httemplate/view/cust_main/packages/services.html b/httemplate/view/cust_main/packages/services.html
index 5fe41a3..fa193d6 100644 (file)
--- 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;
               <BR><% 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'
+%                       })
+%           ) {
               <BR><A HREF="<%$p%>browse/did_order.html?custnum=<%$cust_pkg->custnum%>"><% mt('Browse Received DID Inventory') |h %></A> 
-%           #}
+%           }
 %       }
         </TD>
       </TR>