Optimize "Customer has a referring customer" condition, RT#74452
[freeside.git] / httemplate / misc / process / cacti_graphs.cgi
1 <% $server->process %>
2
3 <%init>
4 die "access denied"
5   unless $FS::CurrentUser::CurrentUser->access_right('View customer services');
6
7 # false laziness with view/elements/svc_Common.html
8 # only doing this to check agent access, don't actually use $svc_x
9 my %param = $cgi->param('arg');
10 my $svcnum = $param{'svcnum'};
11 my $svc_x = qsearchs({
12   'select'    => 'svc_broadband.*',
13   'table'     => 'svc_broadband',
14   'addl_from' => ' LEFT JOIN cust_svc  USING ( svcnum  ) '.
15                  ' LEFT JOIN cust_pkg  USING ( pkgnum  ) '.
16                  ' LEFT JOIN cust_main USING ( custnum ) ',
17   'hashref'   => { 'svcnum' => $svcnum },
18   'extra_sql' => ' AND '. $FS::CurrentUser::CurrentUser->agentnums_sql(
19                             'null_right' => 'View/link unlinked services'
20                           ),
21 }) or die "Unknown svcnum $svcnum in svc_broadband table\n";
22
23 my $server = FS::UI::Web::JSRPC->new('FS::part_export::cacti::process_graphs', $cgi);
24 </%init>
25