X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=httemplate%2Fbrowse%2Fdid_order.html;fp=httemplate%2Fbrowse%2Fdid_order.html;h=3da8cb1bafc73041202c5a4a0219fb1df216d3e8;hp=363a20108bc3979894eba19a27009117c35f4270;hb=073169e80bea0560b64e468a76121bf837de34f3;hpb=0bce81dcafbe1116a7dcd3254d58ebbebaf18ae9 diff --git a/httemplate/browse/did_order.html b/httemplate/browse/did_order.html index 363a20108..3da8cb1ba 100644 --- a/httemplate/browse/did_order.html +++ b/httemplate/browse/did_order.html @@ -1,14 +1,10 @@ <% include( 'elements/browse.html', 'title' => 'Bulk DID Orders', - 'html_init' => qq!Add a bulk DID order

!, + 'html_init' => $html_init, 'name' => 'bulk DID orders', 'disableable' => 0, - 'query' => { 'table' => 'did_order', - 'addl_from' => 'left join did_vendor using (vendornum) ', - 'hashref' => {}, - 'order_by' => 'ORDER BY ordernum', - }, - 'count_query' => 'SELECT COUNT(*) FROM did_order', + 'query' => $query, + 'count_query' => 'SELECT COUNT(*) FROM did_order', # XXX: this is wrong!? 'header' => [ '#', 'Vendor',' Vendor Order #', 'Submitted', 'Confirmed', 'Customer', 'Received', 'Provision', 'Cancel', @@ -20,7 +16,7 @@ 'vendorname', 'vendor_order_id', sub { &$display_date(shift->submitted); }, - sub { + sub { # Confirmed my $did_order = shift; my $ordernum = $did_order->ordernum; return &$display_date($did_order->confirmed) @@ -34,28 +30,24 @@ } ) }, - sub { + sub { # Customer my $did_order = shift; my $cust_main = $did_order->cust_main; return "Stock" unless $cust_main; "".$cust_main->name.""; }, - sub { + sub { # Received my $did_order = shift; my $ordernum = $did_order->ordernum; - return &$display_date($did_order->received) - if $did_order->received; - "Upload Received"; + return "Upload Received" + unless $did_order->received; + "" + . &$display_date($did_order->received) . ""; }, - sub { + sub { # Provision 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 ', - }); + my @provisioned = $did_order->provisioned; return '' unless $did_order->received && $did_order->custnum @@ -69,7 +61,7 @@ } ) }, - sub { + sub { # Cancel my $did_order = shift; return '' unless !$did_order->received; 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 .= "

"; +