From d6edb7f296db6befc54396c001e64e67a79fe40b Mon Sep 17 00:00:00 2001 From: ivan Date: Wed, 16 Nov 2005 13:14:47 +0000 Subject: bulk svcpart change --- httemplate/browse/part_svc.cgi | 70 +++++++++++----------- httemplate/edit/bulk-cust_svc.html | 97 +++++++++++++++++++++++++++++++ httemplate/edit/process/bulk-cust_svc.cgi | 3 + httemplate/index.html | 2 +- 4 files changed, 138 insertions(+), 34 deletions(-) create mode 100644 httemplate/edit/bulk-cust_svc.html create mode 100644 httemplate/edit/process/bulk-cust_svc.cgi (limited to 'httemplate') diff --git a/httemplate/browse/part_svc.cgi b/httemplate/browse/part_svc.cgi index ef0de13cc..a725dc051 100755 --- a/httemplate/browse/part_svc.cgi +++ b/httemplate/browse/part_svc.cgi @@ -1,6 +1,11 @@ - <% +my %flag = ( + 'D' => 'Default', + 'F' => 'Fixed', + '' => '', +); + my %search; if ( $cgi->param('showdisabled') ) { %search = (); @@ -13,18 +18,13 @@ my @part_svc = qsearch('part_svc', \%search ); my $total = scalar(@part_svc); -my %num_active_cust_svc = (); -if ( $cgi->param('active') ) { - my $active_sth = dbh->prepare( - 'SELECT COUNT(*) FROM cust_svc WHERE svcpart = ?' - ) or die dbh->errstr; - foreach my $part_svc ( @part_svc ) { - $active_sth->execute($part_svc->svcpart) or die $active_sth->errstr; - $num_active_cust_svc{$part_svc->svcpart} = - $active_sth->fetchrow_arrayref->[0]; - } +my %num_active_cust_svc = map { $_->svcpart => $_->num_cust_svc } @part_svc; + +if ( $cgi->param('orderby') eq 'active' ) { @part_svc = sort { $num_active_cust_svc{$b->svcpart} <=> $num_active_cust_svc{$a->svcpart} } @part_svc; +} elsif ( $cgi->param('orderby') eq 'svc' ) { + @part_svc = sort { lc($a->svc) cmp lc($b->svc) } @part_svc; } %> @@ -55,21 +55,23 @@ function part_export_areyousure(href) { : do { $cgi->param('showdisabled', 1); '( show disabled services )'; } %> +<% $cgi->param('showdisabled', ( 1 ^ $cgi->param('showdisabled') ) ); %> <%= table() %> - param('showdisabled') ? 2 : 3 %>>Service + # + <% if ( $cgi->param('showdisabled') ) { %> + Status + <% } %> + Service Table -<% if ( $cgi->param('active') ) { %> - Customer
Services -<% } %> + Customer
Services Export Field Modifier <% foreach my $part_svc ( @part_svc ) { - my $hashref = $part_svc->hashref; - my $svcdb = $hashref->{svcdb}; + my $svcdb = $part_svc->svcdb; my $svc_x = "FS::$svcdb"->new( { svcpart => $part_svc->svcpart } ); my @dfields = $svc_x->fields; push @dfields, 'usergroup' if $svcdb eq 'svc_acct'; #kludge @@ -78,25 +80,30 @@ function part_export_areyousure(href) { or $_ ne 'svcnum' && $part_svc->part_svc_column($_)->columnflag } @dfields ; my $rowspan = scalar(@fields) || 1; - my $url = "${p}edit/part_svc.cgi?$hashref->{svcpart}"; + my $url = "${p}edit/part_svc.cgi?". $part_svc->svcpart; %> > - <%= $hashref->{svcpart} %> -<% unless ( $cgi->param('showdisabled') ) { %> + <%= $part_svc->svcpart %> +<% if ( $cgi->param('showdisabled') ) { %> > - <%= $hashref->{disabled} ? 'DISABLED' : '' %> + <%= $part_svc->disabled + ? 'Disabled' + : 'Enabled' + %> + <% } %> > - <%= $hashref->{svc} %> + <%= $part_svc->svc %> > - <%= $hashref->{svcdb} %> -<% if ( $cgi->param('active') ) { %> + <%= $svcdb %> > - <%= $num_active_cust_svc{$hashref->{svcpart}} %> active + <%= $num_active_cust_svc{$part_svc->svcpart} %> active + <% if ( $num_active_cust_svc{$part_svc->svcpart} ) { %> +
[ change ] + <% } %> -<% } %> ><%= itable() %> <% # my @part_export = @@ -115,14 +122,11 @@ map { qsearchs('part_export', { exportnum => $_->exportnum } ) } qsearch('export foreach my $field ( @fields ) { my $flag = $part_svc->part_svc_column($field)->columnflag; %> - <%= $n1 %><%= $field %> + <%= $n1 %> + <%= $field %> + <%= $flag{$flag} %> + <%= $part_svc->part_svc_column($field)->columnvalue%> -<% if ( $flag eq "D" ) { print "Default"; } - elsif ( $flag eq "F" ) { print "Fixed"; } - elsif ( not $flag ) { } - else { print "(Unknown!)"; } -%> - <%= $part_svc->part_svc_column($field)->columnvalue%> <% $n1=""; } %> diff --git a/httemplate/edit/bulk-cust_svc.html b/httemplate/edit/bulk-cust_svc.html new file mode 100644 index 000000000..332b5b67c --- /dev/null +++ b/httemplate/edit/bulk-cust_svc.html @@ -0,0 +1,97 @@ +<%= header( 'Bulk customer service change', + menubar( + 'Main Menu' => $p, + ), + ) +%> + + + + + +<%= include('/elements/progress-init.html', + 'OneTrueForm', + [qw( old_svcpart new_svcpart pkgpart )], + 'process/bulk-cust_svc.cgi', + $p.'browse/part_svc.cgi', + ) +%> + +
+ +<% + $cgi->param('svcpart') =~ /^(\d+)$/ + or die "illegal svcpart: ". $cgi->param('svcpart'); + + my $old_svcpart = $1; + my $src_part_svc = qsearchs('part_svc', { 'svcpart' => $old_svcpart } ) + or die "unknown svcpart: $old_svcpart"; +%> + + +Change + + +
+ +to new service definition + +
+ +
+ + + + + +
+ + + + + + diff --git a/httemplate/edit/process/bulk-cust_svc.cgi b/httemplate/edit/process/bulk-cust_svc.cgi new file mode 100644 index 000000000..dd9d1dbd2 --- /dev/null +++ b/httemplate/edit/process/bulk-cust_svc.cgi @@ -0,0 +1,3 @@ +<% + my $server = new FS::UI::Web::JSRPC 'FS::part_svc::process_bulk_cust_svc', $cgi; +%><%= $server->process %> diff --git a/httemplate/index.html b/httemplate/index.html index b4b85063e..b8f300d2d 100644 --- a/httemplate/index.html +++ b/httemplate/index.html @@ -185,7 +185,7 @@
  • packages (by next bill date range) Package definitions (by number of active packages)

    - Service definitions (by number of active services)

    + Service definitions (by number of active services)

    Customers