1 <& /elements/header-popup.html,
3 'title' => 'Event query - '.$part_event->event,
6 % if ( $objects > 0 ) {
7 <% emt("[quant,_1,$label]", $objects) %>
8 % if ( $part_event->eventtable ne 'cust_main' ) {
9 <% emt("belonging to [quant,_1,customer]", $customers) %>
12 <TABLE class="grid" cellspacing=0 width="100%" style="font-size:80%">
13 <TR style='background-color:#cccccc'>
14 % foreach my $header ('Trigger', @cust_header, @header) {
15 <TH><% $header %></TH>
19 % my @rowcolors = ('ffffff','eeeeee');
21 <TR style="background-color:#<% $rowcolors[$row++ % 2] %>">
22 % foreach my $object (@targets) {
23 % # now works for all eventtables, including cust_pkg
24 % my $link = $p . 'view/' . $part_event->eventtable . '.cgi?' .
26 <TD><A target="_blank" href="<% $link %>">
27 <% ucfirst $label %> #<% $object->$pkey %></A></TD>
29 % my $cust_main = $object->cust_main; # via Mixin
30 % my $i = 0; # hack to avoid messing with cust_aligns/colors/styles
31 % foreach (@cust_fields) {
32 % if ($cust_header[$i] eq 'Cust. Status') {
33 <TD style="text-align:center;
35 color:#<% $cust_main->cust_statuscolor %>"><% $_->($cust_main) %></TD>
38 <TD><% $_->($cust_main) %></TD>
41 % } #foreach @cust_fields
44 <TD><% ref($_) eq 'CODE' ? $_->($object) : $object->$_ %></TD>
54 <% emt("No matching ${label}s found.") %>
57 <& /elements/footer.html &>
59 use List::MoreUtils qw(uniq);
63 my $curuser = $FS::CurrentUser::CurrentUser;
65 unless $curuser->access_right('Edit billing events')
66 || $curuser->access_right('Edit global billing events');
68 my ($eventpart) = $cgi->keywords;
69 $eventpart =~ /^\d+$/ or die 'illegal eventpart';
71 my $part_event = FS::part_event->by_key($eventpart)
72 or die "Event definition $eventpart not found.\n";
73 my @targets = $part_event->targets;
76 # in imitation of search/elements/search-html.html
80 $pkey = dbdef->table($part_event->eventtable)->primary_key;
82 for ($part_event->eventtable) {
84 # very likely to appear in events
85 my %paybys = FS::payby->cust_payby2longname;
86 push @header, 'Balance', 'Payment Method';
87 push @fields, 'balance', sub{ $paybys{$_[0]->payby} };
90 elsif (/^cust_bill$/) {
91 push @header, 'Invoice Date', 'Amount', 'Balance';
92 push @fields, date_format('_date'), 'charged', 'owed';
95 elsif (/^cust_statement$/) {
96 push @header, 'Statement Date', 'Amount', 'Balance';
97 push @fields, date_format('_date'), 'charged', 'owed';
100 elsif (/^cust_pkg$/) {
101 push @header, 'Package', 'Next Bill', 'Frequency';
102 push @fields, sub {$_[0]->part_pkg->pkg}, date_format('bill'),
103 sub {$_[0]->part_pkg->freq_pretty};
106 elsif (/^svc_acct$/) {
107 push @header, 'Username', 'Domain';
108 push @fields, 'username', 'domain';
114 my @cust_header = FS::UI::Web::cust_header();
115 my @cust_fields = FS::UI::Web::cust_fields_subs();
117 my $objects = scalar(@targets);
118 my $customers = uniq(map {$_->cust_main->custnum} @targets);
122 sub { my $obj = shift;
123 my $value = $obj->get($column);
124 $value ? time2str('%b %d %Y', $value) : '';