X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=httemplate%2Fview%2Fsvc_forward.cgi;h=487ebb22053bfdb2859ebf0c877a2910f41a29cf;hb=9509e5bfb7f9331303153cac24d7bfecbe2ea9f1;hp=fcc0bc96f4e17668fdc183f86927559c24332e37;hpb=3ce7691203a7737406bf2d4442f7fd84b81f847e;p=freeside.git diff --git a/httemplate/view/svc_forward.cgi b/httemplate/view/svc_forward.cgi index fcc0bc96f..487ebb220 100755 --- a/httemplate/view/svc_forward.cgi +++ b/httemplate/view/svc_forward.cgi @@ -1,12 +1,21 @@ - -% +% die "access denied" +% unless $FS::CurrentUser::CurrentUser->access_right('View customer services') +% || $FS::CurrentUser::CurrentUser->access_right('View customer'); #XXX remove me % %my $conf = new FS::Conf; % %my($query) = $cgi->keywords; %$query =~ /^(\d+)$/; %my $svcnum = $1; -%my $svc_forward = qsearchs('svc_forward',{'svcnum'=>$svcnum}); +%my $svc_forward = qsearchs({ +% 'select' => 'svc_forward.*', +% 'table' => 'svc_forward', +% 'addl_from' => ' LEFT JOIN cust_svc USING ( svcnum ) '. +% ' LEFT JOIN cust_pkg USING ( pkgnum ) '. +% ' LEFT JOIN cust_main USING ( custnum ) ', +% 'hashref' => {'svcnum'=>$svcnum}, +% 'extra_sql' => ' AND '. $FS::CurrentUser::CurrentUser->agentnums_sql, +%}); %die "Unknown svcnum" unless $svc_forward; % %my $cust_svc = qsearchs('cust_svc',{'svcnum'=>$svcnum});