X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=httemplate%2Fbrowse%2Fpart_pkg.cgi;h=478d4a6d4a8c95e3525f203df6c49a5248e7011c;hb=54e557ff60c8c11f3666c4f6acc33ebe8aa4b8ff;hp=41d86358c5b0a9380202ed4e68c3ae70065a92cc;hpb=2c757d7db4cb6a7b9655de13206fcc84fb7ce61f;p=freeside.git diff --git a/httemplate/browse/part_pkg.cgi b/httemplate/browse/part_pkg.cgi index 41d86358c..478d4a6d4 100755 --- a/httemplate/browse/part_pkg.cgi +++ b/httemplate/browse/part_pkg.cgi @@ -1,11 +1,29 @@ -<% +<% include( 'elements/browse.html', + 'title' => 'Package Definitions', + 'html_init' => $html_init, + 'name' => 'package definitions', + 'disableable' => 1, + 'disabled_statuspos' => 3, + 'agent_virt' => 1, + 'agent_null_right' => 'Edit global package definitions', + 'agent_pos' => 5, + 'query' => { 'select' => $select, + 'table' => 'part_pkg', + 'hashref' => {}, + 'order_by' => "ORDER BY $orderby", + }, + 'count_query' => $count_query, + 'header' => \@header, + 'fields' => \@fields, + 'links' => \@links, + 'align' => $align, + ) +%> +<%init> -my %search = (); -my $search = ''; -unless ( $cgi->param('showdisabled') ) { - %search = ( 'disabled' => '' ); - $search = "( disabled = '' OR disabled IS NULL )"; -} +die "access denied" + unless $FS::CurrentUser::CurrentUser->access_right('Edit package definitions') + || $FS::CurrentUser::CurrentUser->access_right('Edit global package definitions'); my $select = '*'; my $orderby = 'pkgpart'; @@ -37,6 +55,7 @@ if ( $cgi->param('active') ) { my $conf = new FS::Conf; my $taxclasses = $conf->exists('enable_taxclasses'); +my $money_char = $conf->config('money_char') || '$'; my $html_init; #unless ( $cgi->param('active') ) { @@ -49,15 +68,6 @@ my $html_init; !; #} -my $posttotal; -if ( $cgi->param('showdisabled') ) { - $cgi->param('showdisabled', 0); - $posttotal = '( hide disabled packages )'; -} else { - $cgi->param('showdisabled', 1); - $posttotal = '( show disabled packages )'; -} - # ------ my $link = [ $p.'edit/part_pkg.cgi?', 'pkgpart' ]; @@ -66,18 +76,6 @@ my @header = ( '#', 'Package', 'Comment' ); my @fields = ( 'pkgpart', 'pkg', 'comment' ); my $align = 'rll'; my @links = ( $link, $link, '' ); -my @style = ( '', '', '' ); - -unless ( $cgi->param('showdisabled') ) { #its been reversed already - push @header, 'Status'; - push @fields, sub { shift->disabled - ? 'DISABLED' - : 'Active' - }; - push @links, ''; - $align .= 'c'; - push @style, 'b'; -} unless ( 0 ) { #already showing only one class or something? push @header, 'Class'; @@ -85,31 +83,112 @@ unless ( 0 ) { #already showing only one class or something? $align .= 'l'; } +tie my %plans, 'Tie::IxHash', %{ FS::part_pkg::plan_info() }; + +tie my %plan_labels, 'Tie::IxHash', + map { $_ => ( $plans{$_}->{'shortname'} || $plans{$_}->{'name'} ) } + keys %plans; + +push @header, 'Pricing'; +$align .= 'r'; #? +push @fields, sub { + my $part_pkg = shift; + (my $plan = $plan_labels{$part_pkg->plan} ) =~ s/ / /g; + my $is_recur = ( $part_pkg->freq ne '0' ); + + [ + [ + { data =>$plan, + align=>'center', + colspan=>2, + }, + ], + [ + { data =>$money_char. + sprintf('%.2f', $part_pkg->option('setup_fee') ), + align=>'right' + }, + { data => ( $is_recur ? ' setup' : ' one-time' ), + align=>'left', + }, + ], + [ + { data=>( $is_recur + ? $money_char.sprintf('%.2f ', $part_pkg->option('recur_fee') ) + : $part_pkg->freq_pretty + ), + align=> ( $is_recur ? 'right' : 'center' ), + colspan=> ( $is_recur ? 1 : 2 ), + }, + ( $is_recur + ? { data => ( $is_recur ? $part_pkg->freq_pretty : '' ), + align=>'left', + } + : () + ), + ], + ( map { + my $dst_pkg = $_->dst_pkg; + [ + { data => 'Add-on: '.$dst_pkg->pkg_comment, + align=>'center', #? + colspan=>2, + } + ] + } + $part_pkg->bill_part_pkg_link + ), + ]; + +# $plan_labels{$part_pkg->plan}.'
'. +# $money_char.sprintf('%.2f setup
', $part_pkg->option('setup_fee') ). +# ( $part_pkg->freq ne '0' +# ? $money_char.sprintf('%.2f ', $part_pkg->option('recur_fee') ) +# : '' +# ). +# $part_pkg->freq_pretty; #.'
' +}; + #if ( $cgi->param('active') ) { push @header, 'Customer
packages'; my %col = ( - 'active' => '00CC00', - 'suspended' => 'FF9900', - 'cancelled' => 'FF0000', + 'active' => '00CC00', + 'suspended' => 'FF9900', + 'cancelled' => 'FF0000', + #'one-time charge' => '000000', + 'charge' => '000000', ); my $cust_pkg_link = $p. 'search/cust_pkg.cgi?pkgpart='; push @fields, sub { my $part_pkg = shift; [ map { + my $magic = $_; + my $label = $_; + if ( $magic eq 'active' && $part_pkg->freq == 0 ) { + $magic = 'inactive'; + #$label = 'one-time charge', + $label = 'charge', + } + [ { - 'data' => ''. + 'data' => ''. $part_pkg->get("num_$_"). '', 'align' => 'right', }, { - 'data' => $_, + 'data' => $label. + ( $part_pkg->get("num_$_") != 1 + && $label =~ /charge$/ + ? 's' + : '' + ), 'align' => 'left', 'link' => ( $part_pkg->get("num_$_") ? $cust_pkg_link. $part_pkg->pkgpart. - ";magic=$_" + ";magic=$magic" : '' ), }, @@ -119,39 +198,36 @@ unless ( 0 ) { #already showing only one class or something? $align .= 'r'; #} -push @header, 'Frequency'; -push @fields, sub { shift->freq_pretty; }; -$align .= 'l'; - if ( $taxclasses ) { push @header, 'Taxclass'; push @fields, sub { shift->taxclass() || ' '; }; $align .= 'l'; } -push @header, 'Plan', - 'Data', +push @header, 'Plan options', 'Services'; #'Service', 'Quan', 'Primary'; -push @fields, sub { shift->plan || '(legacy)' }, - +push @fields, sub { my $part_pkg = shift; if ( $part_pkg->plan ) { + my %options = $part_pkg->options; + [ map { - /^(\w+)=(.*)$/; #or something; [ - { 'data' => $1, + { 'data' => $_, 'align' => 'right', }, - { 'data' => $2, + { 'data' => $part_pkg->format($_,$options{$_}), 'align' => 'left', }, ]; } - split(/\n/, $part_pkg->plandata) + grep { $options{$_} =~ /\S/ } + grep { $_ !~ /^(setup|recur)_fee$/ } + keys %options ]; } else { @@ -176,7 +252,8 @@ push @fields, sub { shift->plan || '(legacy)' }, sub { my $part_pkg = shift; - [ map { + [ + (map { my $pkg_svc = $_; my $part_svc = $pkg_svc->part_svc; my $svc = $part_svc->svc; @@ -201,8 +278,19 @@ push @fields, sub { shift->plan || '(legacy)' }, sort { $b->primary_svc =~ /^Y/i <=> $a->primary_svc =~ /^Y/i } - $part_pkg->pkg_svc - + $part_pkg->pkg_svc('disable_linked'=>1) + ), + ( map { + my $dst_pkg = $_->dst_pkg; + [ + { data => 'Add-on: '.$dst_pkg->pkg_comment, + align=>'center', #? + colspan=>2, + } + ] + } + $part_pkg->svc_part_pkg_link + ) ]; }; @@ -211,26 +299,9 @@ $align .= 'lrl'; #rr'; # -------- -my $count_query = 'SELECT COUNT(*) FROM part_pkg'; -$count_query .= " WHERE $search" - if $search; - -%><%= include( 'elements/browse.html', - 'title' => 'Package Definitions', - 'menubar' => [ 'Main Menu' => $p ], - 'html_init' => $html_init, - 'html_posttotal' => $posttotal, - 'name' => 'package definitions', - 'query' => { 'select' => $select, - 'table' => 'part_pkg', - 'hashref' => \%search, - 'extra_sql' => "ORDER BY $orderby", - }, - 'count_query' => $count_query, - 'header' => \@header, - 'fields' => \@fields, - 'links' => \@links, - 'align' => $align, - 'style' => \@style, - ) -%> +my $count_query = 'SELECT COUNT(*) FROM part_pkg WHERE '. + $FS::CurrentUser::CurrentUser->agentnums_sql( + 'null_right' => 'Edit global package definitions', + ); + +