% if ($error) { <% $cgi->redirect(popurl(2). "timeworked.html?". $cgi->query_string) %> % } else { <% $cgi->redirect(popurl(3). "search/timeworked.html") %> % } <%init> die "access denied" unless $FS::CurrentUser::CurrentUser->access_right('Time queue'); my %multipliers = map { /^custnum(\d+)$/; ($cgi->param("custnum$1") => $cgi->param("multiplier$1")); } grep /^custnum\d+$/, $cgi->param; my @acct_rt_transaction; foreach my $transaction ( map { /^transactionid(\d+)$/; $1; } grep /^transactionid\d+$/, $cgi->param ) { my $seconds = $cgi->param("seconds$transaction"); my %seconds = map { $_ => sprintf("%.0f", $seconds * $multipliers{$_}) } (keys %multipliers); my $sum = 0; my $count = 0; foreach (values %seconds) { $sum += $_; $count++; } #fudge in some time if we're close if (abs($seconds-$sum) <= $count) { my $adjustment = $seconds-$sum; foreach (keys %seconds) { # explicitly choose one? $seconds{$_} += $adjustment; last; } } foreach my $customer ( grep {$seconds{$_}} keys %seconds ) { push @acct_rt_transaction, new FS::acct_rt_transaction { 'custnum' => $customer, 'transaction_id' => $transaction, 'seconds' => $seconds{$customer}, }; } } my $error = FS::acct_rt_transaction->batch_insert(@acct_rt_transaction); $cgi->param('error', $error) if $error;