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                                                     left join lata using (latanum)',
   9                                     'hashref'   => {},
  10                                     'order_by' => 'ORDER BY ordernum',
  11                                   },
  12                  'count_query' => $count_query,
  13                  'header'      => $header,
  14                  'fields'      => $fields,
  15                  'links'       => $links,
  16              )
  17 %>
  18 <%init>
  19
  20 die "access denied"
  21   unless $FS::CurrentUser::CurrentUser->access_right('Import');
  22
  23 my $conf = new FS::Conf;
  24 my $date_format = $conf->config('date_format') || '%m/%d/%Y';
  25
  26 my $html_init =
  27   qq!<A HREF="${p}edit/did_order.html"><I>Add a bulk DID order</I></A><BR><BR>!;
  28
  29 my $count_query = 'SELECT COUNT(*) FROM did_order';
  30
  31 my $link = [ $p.'edit/did_order.html?', 'ordernum' ];
  32
  33 my $display_date = sub {
  34     my $date = shift;
  35     return '' unless $date;
  36     time2str($date_format, $date);
  37 };
  38
  39 my $header = [ '#', 'Vendor',' Vendor Order #', 'MSA', 'LATA #', 'LATA',
  40                 'Rate Center', 'State', 'Quantity', 'Submitted', 'Confirmed',
  41                 'Received',
  42             ];
  43 my $links  = [ ];
  44 my $fields = [  sub {
  45                     my $did_order = shift;
  46                     if($did_order->received) {
  47                         push @$links, $link;
  48                     }
  49                     else {
  50                         return $did_order->ordernum;
  51                     }
  52                 }, 'vendorname', 'vendor_order_id', 'msa', 'latanum',
  53                 'description', 'rate_center', 'state', 'quantity',
  54                 sub { &$display_date(shift->submitted); },
  55                 sub { &$display_date(shift->confirmed); },
  56                 sub {
  57                     my $did_order = shift;
  58                     my $ordernum = $did_order->ordernum;
  59                     return &$display_date($did_order->received)
  60                         if $did_order->received;
  61                     "<A HREF='${p}misc/phone_avail-import.html?ordernum=$ordernum'>Upload Received</A>";
  62                 },
  63              ];
  64
  65 </%init>