'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,
+ 'links' => [
+ [ $p.'edit/did_order.html?', 'ordernum' ],
+ ],
)
%>
<%init>
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 $header = [ '#', 'Vendor',' Vendor Order #', 'Submitted', 'Confirmed',
+ 'Customer', 'Received', ];
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',
+ $did_order->ordernum;
+ }, 'vendorname', 'vendor_order_id',
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->confirmed) if $did_order->confirmed;
+ include( '/elements/popup_link.html',
+ { 'action' => "${p}misc/did_order_confirm.html?ordernum=$ordernum",
+ 'label' => 'Confirm Bulk DID Order',
+ '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;
+ "<A HREF='${p}view/cust_main.cgi?".$cust_main->custnum."'>".$cust_main->name."</A>";
+ },
sub {
my $did_order = shift;
my $ordernum = $did_order->ordernum;
return &$display_date($did_order->received)
- if $did_order->received;
+ if $did_order->received;
"<A HREF='${p}misc/phone_avail-import.html?ordernum=$ordernum'>Upload Received</A>";
},
];