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 .= "
";
+
%init>