<% include( 'elements/browse.html', 'title' => 'Bulk DID Orders', 'html_init' => $html_init, 'name' => 'bulk DID orders', 'disableable' => 0, 'query' => $query, 'count_query' => 'SELECT COUNT(*) FROM did_order', # XXX: this is wrong!? 'header' => [ '#', 'Vendor',' Vendor Order #', 'Submitted', 'Confirmed', 'Customer', 'Received', 'Provision', 'Cancel', ], 'fields' => [ sub { my $did_order = shift; $did_order->ordernum; }, 'vendorname', 'vendor_order_id', sub { &$display_date(shift->submitted); }, sub { # Confirmed my $did_order = shift; my $ordernum = $did_order->ordernum; return &$display_date($did_order->confirmed) if $did_order->confirmed; include( '/elements/popup_link.html', { 'action' => "${p}misc/did_order_confirm.html?ordernum=$ordernum", 'label' => 'Confirm', 'actionlabel' => 'Confirm Bulk DID Order', 'width' => 480, 'height' => 300, } ) }, sub { # Customer my $did_order = shift; my $cust_main = $did_order->cust_main; return "Stock" unless $cust_main; "".$cust_main->name.""; }, sub { # Received my $did_order = shift; my $ordernum = $did_order->ordernum; return "Upload Received" unless $did_order->received; "" . &$display_date($did_order->received) . ""; }, sub { # Provision my $did_order = shift; my $ordernum = $did_order->ordernum; my @provisioned = $did_order->provisioned; return '' unless $did_order->received && $did_order->custnum && !scalar(@provisioned); include( '/elements/popup_link.html', { 'action' => "${p}misc/did_order_provision.html?ordernum=".$did_order->ordernum, 'label' => 'Provision All DIDs', 'actionlabel' => 'Bulk DID order - DID provisioning', 'width' => 520, 'height' => 300, } ) }, sub { # Cancel my $did_order = shift; return '' unless !$did_order->received; qq!Cancel! }, ], 'links' => [ [ $p.'edit/did_order.html?', 'ordernum' ], ], 'html_foot' => ' ', ) %> <%init> die "access denied" unless $FS::CurrentUser::CurrentUser->access_right('Import'); my $conf = new FS::Conf; my $date_format = $conf->config('date_format') || '%m/%d/%Y'; my $display_date = sub { my $date = shift; return '' unless $date; time2str($date_format, $date); }; my $html_init = qq!Add a bulk DID order

!; my $query = { 'table' => 'did_order', 'hashref' => {}, 'addl_from' => 'left join did_vendor using (vendornum) ', 'order_by' => 'ORDER BY ordernum', }; $query->{'hashref'}->{'custnum'} = $1 if $cgi->param('custnum') =~ /^(\d+)$/; if ( $cgi->param('custrcvdunprov') ) { $query->{'hashref'}->{'received'} = { 'op' => '>', 'value' => '0', }; $query->{'hashref'}->{'custnum'} = { 'op' => '>', 'value' => '0', }; $query->{'addl_from'} .= ' left join phone_avail using (ordernum) '; $query->{'extra_sql'} .= ' and svcnum is null '; $html_init .= qq!Browse all DID orders!; } else { $html_init .= qq! Browse all non-stock orders with received unprovisioned DIDs !; } $html_init .= "

";