1 <% include( 'elements/browse.html',
2 'title' => 'Bulk DID Orders',
3 'html_init' => $html_init,
4 'name' => 'bulk DID orders',
6 'query' => { 'table' => 'did_order',
7 'addl_from' => 'left join did_vendor using (vendornum)
8 left join lata using (latanum)',
10 'order_by' => 'ORDER BY ordernum',
12 'count_query' => $count_query,
21 unless $FS::CurrentUser::CurrentUser->access_right('Import');
23 my $conf = new FS::Conf;
24 my $date_format = $conf->config('date_format') || '%m/%d/%Y';
27 qq!<A HREF="${p}edit/did_order.html"><I>Add a bulk DID order</I></A><BR><BR>!;
29 my $count_query = 'SELECT COUNT(*) FROM did_order';
31 my $link = [ $p.'edit/did_order.html?', 'ordernum' ];
33 my $display_date = sub {
35 return '' unless $date;
36 time2str($date_format, $date);
39 my $header = [ '#', 'Vendor',' Vendor Order #', 'MSA', 'LATA #', 'LATA',
40 'Rate Center', 'State', 'Quantity', 'Submitted', 'Confirmed',
45 my $did_order = shift;
46 if($did_order->received) {
50 return $did_order->ordernum;
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); },
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>";