X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=httemplate%2Fbrowse%2Fdid_order.html;h=363a20108bc3979894eba19a27009117c35f4270;hb=0a256d5758b5826aeaf7b59ac2e0f8c97ba8b86b;hp=54c2bd3fc6d9fa64fa9180c4ff71a9cb4f001f48;hpb=0fb307c305e4bc2c9c27dc25a3308beae3a4d33c;p=freeside.git diff --git a/httemplate/browse/did_order.html b/httemplate/browse/did_order.html index 54c2bd3fc..363a20108 100644 --- a/httemplate/browse/did_order.html +++ b/httemplate/browse/did_order.html @@ -1,18 +1,93 @@ <% include( 'elements/browse.html', 'title' => 'Bulk DID Orders', - 'html_init' => $html_init, + 'html_init' => qq!Add a bulk DID order

!, 'name' => 'bulk DID orders', 'disableable' => 0, 'query' => { 'table' => 'did_order', - 'addl_from' => 'left join did_vendor using (vendornum) - left join lata using (latanum)', + 'addl_from' => 'left join did_vendor using (vendornum) ', 'hashref' => {}, 'order_by' => 'ORDER BY ordernum', }, - 'count_query' => $count_query, - 'header' => $header, - 'fields' => $fields, - 'links' => $links, + 'count_query' => 'SELECT COUNT(*) FROM did_order', + '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 { + 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 { + my $did_order = shift; + my $cust_main = $did_order->cust_main; + return "Stock" unless $cust_main; + "".$cust_main->name.""; + }, + sub { + my $did_order = shift; + my $ordernum = $did_order->ordernum; + return &$display_date($did_order->received) + if $did_order->received; + "Upload Received"; + }, + sub { + my $did_order = shift; + my $ordernum = $did_order->ordernum; + my @provisioned = + qsearch({ table => 'phone_avail', + hashref => { 'ordernum' => $ordernum, }, + select => 'phone_avail.*', + extra_sql => ' and svcnum is not null ', + }); + 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 { + my $did_order = shift; + return '' unless !$did_order->received; + qq!Cancel! + }, + ], + 'links' => [ + [ $p.'edit/did_order.html?', 'ordernum' ], + ], + 'html_foot' => ' + + ', ) %> <%init> @@ -23,43 +98,10 @@ die "access denied" my $conf = new FS::Conf; my $date_format = $conf->config('date_format') || '%m/%d/%Y'; -my $html_init = - qq!Add a bulk DID order

!; - -my $count_query = 'SELECT COUNT(*) FROM did_order'; - -my $link = [ $p.'edit/did_order.html?', 'ordernum' ]; - my $display_date = sub { my $date = shift; return '' unless $date; time2str($date_format, $date); }; -my $header = [ '#', 'Vendor',' Vendor Order #', 'MSA', 'LATA #', 'LATA', - 'Rate Center', 'State', 'Quantity', 'Submitted', 'Confirmed', - 'Received', - ]; -my $links = [ ]; -my $fields = [ sub { - my $did_order = shift; - if($did_order->received) { - push @$links, $link; - } - else { - return $did_order->ordernum; - } - }, 'vendorname', 'vendor_order_id', 'msa', 'latanum', - 'description', 'rate_center', 'state', 'quantity', - sub { &$display_date(shift->submitted); }, - sub { &$display_date(shift->confirmed); }, - sub { - my $did_order = shift; - my $ordernum = $did_order->ordernum; - return &$display_date($did_order->received) - if $did_order->received; - "Upload Received"; - }, - ]; -