From: Jonathan Prykop <jonathan@freeside.biz> Date: Fri, 23 Jan 2015 19:06:32 +0000 (-0600) Subject: RT 32226, only displaying DID order link if customer has DID order X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=commitdiff_plain;h=0b425dc3033774ab661a348d8ac729a70be7f794 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 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; <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>