X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=httemplate%2Fsearch%2Fsales_commission.html;h=34019547402dbddf511c613eef3f0160d9967ea0;hp=19e11889b2fff3bc8a7db86722514dc270abb00b;hb=3f2a7b01b59902faed5767d81e2959e131bdbdfd;hpb=a9e0bcdce308177b619f1490f58a608f49a69e90 diff --git a/httemplate/search/sales_commission.html b/httemplate/search/sales_commission.html index 19e11889b..340195474 100644 --- a/httemplate/search/sales_commission.html +++ b/httemplate/search/sales_commission.html @@ -1,23 +1,56 @@ -<& elements/search.html, - 'title' => 'Sales person commission report', - 'name_singular' => 'sales person', -# 'redirect' => sub { #my( $sales, $cgi ) = @); -# $saleslink; -# }, - 'header' => [ 'Sales person', 'Sales', 'Commission', ], - 'fields' => [ 'salesperson', sub{'XXX';}, sub{'XXX';}, ], - 'links' => [ '', $saleslink, $commissionlink ], - 'query' => { 'table' => 'sales', }, - 'count_query' => 'SELECT COUNT(*) FROM sales', - 'disableable' => 1, +% if ( $salesnum ) { +% my $url = 'sales_pkg_class.html?' . $cgi->query_string; +<% $cgi->redirect($url) %> +% } else { +<& elements/commission.html, + 'title' => $title, + 'name_singular' => 'sales person', + 'header' => [ 'Sales person' ], + 'fields' => [ 'salesperson' ], + 'links' => [ '' ], + 'align' => 'l', + 'query' => \%query, + 'count_query' => $count_query, + 'disableable' => 1, + 'sales_detail_link' => $sales_link, + 'credit_detail_link' => $commission_link, &> +% } <%init> die "access denied" unless $FS::CurrentUser::CurrentUser->access_right('Financial reports'); -my $saleslink = [ 'sales_pkg_class.html?salesnum=', 'salesnum' ]; +my $conf = new FS::Conf; -my $commissionlink = ''; #XXX +my %query = ( 'table' => 'sales' ); +my $count_query = "SELECT COUNT(*) FROM sales"; + +if ( $cgi->param('agentnum') =~ /^(\d+)$/ ) { + $query{hashref}->{agentnum} = $1; + $count_query .= " WHERE agentnum = $1"; +} + +my $salesnum = ''; +if ( $cgi->param('salesnum') =~ /^(\d+)$/ ) { + $salesnum = $1; +} else { + $cgi->delete('salesnum'); +} + +my $title = 'Sales person commission'; + +my $cust_main_sales = $cgi->param('cust_main_sales') eq 'Y' ? 'Y' : ''; +$query{'cust_main_sales'} = $cust_main_sales; + +my $sales_link = [ 'sales_pkg_class.html?'. + "cust_main_sales=$cust_main_sales;salesnum=", + 'salesnum' + ]; + +my $commission_link = [ 'cust_credit.html?'. + "cust_main_sales=$cust_main_sales;commission_salesnum=", + 'salesnum' + ];