httemplate/search/sales_commission.html

   1 % if ( $salesnum ) {
   2 <% $cgi->redirect($sales_link->[0] . $salesnum) %>
   3 % } else {
   4 <& elements/commission.html,
   5   'title'         => $title,
   6   'name_singular' => 'sales person',
   7   'header'        => [ 'Sales person' ],
   8   'fields'        => [ 'salesperson' ],
   9   'links'         => [ '' ],
  10   'align'         => 'l',
  11   'query'         => \%query,
  12   'count_query'   => $count_query,
  13   'disableable'   => 1,
  14   'sales_detail_link'   => $sales_link,
  15   'credit_detail_link'  => $commission_link,
  16 &>
  17 % }
  18 <%init>
  19
  20 die "access denied"
  21   unless $FS::CurrentUser::CurrentUser->access_right('Financial reports');
  22
  23 my $conf = new FS::Conf;
  24
  25 my %query = ( 'table' => 'sales' );
  26 my $count_query = "SELECT COUNT(*) FROM sales";
  27
  28 if ( $cgi->param('agentnum') =~ /^(\d+)$/ ) {
  29   $query{hashref}->{agentnum} = $1;
  30   $count_query .= " WHERE agentnum = $1";
  31 }
  32
  33 my $salesnum = '';
  34 if ( $cgi->param('salesnum') =~ /^(\d+)$/ ) {
  35   $salesnum = $1;
  36 } else {
  37   $cgi->delete('salesnum');
  38 }
  39
  40 my $title = 'Sales person commission';
  41
  42 my $cust_main_sales = $cgi->param('cust_main_sales') eq 'Y' ? 'Y' : '';
  43 $query{'cust_main_sales'} = $cust_main_sales;
  44
  45 my $sales_link = [ 'sales_pkg_class.html?'.
  46                    "cust_main_sales=$cust_main_sales;salesnum=",
  47                    'salesnum'
  48                  ];
  49
  50 my $commission_link = [ 'cust_credit.html?'.
  51                         "cust_main_sales=$cust_main_sales;commission_salesnum=",
  52                         'salesnum'
  53                       ];
  54
  55 </%init>