httemplate/browse/did_order.html

   1 <% include( 'elements/browse.html',
   2                  'title'       => 'Bulk DID Orders',
   3                  'html_init'   => $html_init,
   4                  'name'        => 'bulk DID orders',
   5                  'disableable' => 0,
   6                  'query'       => { 'table'     => 'did_order',
   7                                     'addl_from' => 'left join did_vendor using (vendornum) ',
   8                                     'hashref'   => {},
   9                                     'order_by' => 'ORDER BY ordernum',
  10                                   },
  11                  'count_query' => $count_query,
  12                  'header'      => $header,
  13                  'fields'      => $fields,
  14                  'links'       => [
  15                                     [ $p.'edit/did_order.html?', 'ordernum' ],
  16                                   ],
  17              )
  18 %>
  19 <%init>
  20
  21 die "access denied"
  22   unless $FS::CurrentUser::CurrentUser->access_right('Import');
  23
  24 my $conf = new FS::Conf;
  25 my $date_format = $conf->config('date_format') || '%m/%d/%Y';
  26
  27 my $html_init =
  28   qq!<A HREF="${p}edit/did_order.html"><I>Add a bulk DID order</I></A><BR><BR>!;
  29
  30 my $count_query = 'SELECT COUNT(*) FROM did_order';
  31
  32 my $display_date = sub {
  33     my $date = shift;
  34     return '' unless $date;
  35     time2str($date_format, $date);
  36 };
  37
  38 my $header = [ '#', 'Vendor',' Vendor Order #',
  39                 'Submitted', 'Confirmed', 'Customer', 'Received',
  40             ];
  41 my $fields = [  sub {
  42                     my $did_order = shift;
  43                     $did_order->ordernum;
  44                 }, 'vendorname', 'vendor_order_id',
  45                 sub { &$display_date(shift->submitted); },
  46                 sub { &$display_date(shift->confirmed); },
  47                 'custnum',
  48                 sub {
  49                     my $did_order = shift;
  50                     my $ordernum = $did_order->ordernum;
  51                     return &$display_date($did_order->received)
  52                         if $did_order->received;
  53                     "<A HREF='${p}misc/phone_avail-import.html?ordernum=$ordernum'>Upload Received</A>";
  54                 },
  55              ];
  56
  57 </%init>