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 #', 'Submitted', 'Confirmed',
  39                 'Customer', 'Received', ];
  40 my $fields = [  sub {
  41                     my $did_order = shift;
  42                     $did_order->ordernum;
  43                 }, 'vendorname', 'vendor_order_id',
  44                 sub { &$display_date(shift->submitted); },
  45                 sub {
  46                     my $did_order = shift;
  47                     my $ordernum = $did_order->ordernum;
  48             return &$display_date($did_order->confirmed) if $did_order->confirmed;
  49             include( '/elements/popup_link.html',
  50               { 'action'      => "${p}misc/did_order_confirm.html?ordernum=$ordernum",
  51                 'label'       => 'Confirm&nbsp;Bulk&nbsp;DID&nbsp;Order',
  52                 'actionlabel' => 'Confirm Bulk DID Order',
  53                 'width'       => 480,
  54                 'height'      => 300,
  55               }
  56             )
  57         },
  58         sub {
  59             my $did_order = shift;
  60             my $cust_main = $did_order->cust_main;
  61             return "Stock" unless $cust_main;
  62             "<A HREF='${p}view/cust_main.cgi?".$cust_main->custnum."'>".$cust_main->name."</A>";
  63         },
  64                 sub {
  65                     my $did_order = shift;
  66                     my $ordernum = $did_order->ordernum;
  67                     return &$display_date($did_order->received)
  68                             if $did_order->received;
  69                     "<A HREF='${p}misc/phone_avail-import.html?ordernum=$ordernum'>Upload Received</A>";
  70                 },
  71              ];
  72
  73 </%init>