'order_by' => 'ORDER BY ratenum',
},
'count_query' => $count_query,
- 'header' => [ '#', 'Rate plan', 'Rates' ],
- 'fields' => [ 'ratenum', 'ratename', $rates_sub ],
- 'links' => [ $link, $link, '' ],
+ 'header' => \@header,
+ 'fields' => \@fields,
+ 'links' => \@links,
'agent_virt' => 1,
'agent_pos' => 1,
'agent_null_right' => 'Configuration', #'Edit global CDR rates',
;
}
+my @header = ();
+my @fields = ();
+my @links = ();
+
+if ( FS::Record->scalar_sql('SELECT 1 FROM rate WHERE agent_rateid IS NOT NULL LIMIT 1') ) {
+ push @header, 'Legacy #';
+ push @fields, 'agent_rateid';
+ push @links, $link;
+}
+
+push @header, 'Rate plan', 'Rates';
+push @fields, 'ratename', $rates_sub;
+push @links, $link, '';
+
</%init>
($region->exact_match ? ' <I>(exact match only)</I>' : '');
};
-my @header = ( '#', 'Region', 'Country code', 'Prefixes' );
-my @fields = ( 'regionnum', 'regionname', 'ccode', $sub_prefixes );
-my @links = ( ($link) x 4 );
-my @align = ( 'right', 'left', 'right', 'left' );
-my @xls_format = ( ({ locked=>1, bg_color=>22 }) x 4 );
+my @header = ();
+my @fields = ();
+my @links = ();
+my @align = ();
+my @xls_format = ();
+
+if ( FS::Record->scalar_sql('SELECT 1 FROM rate_region WHERE agent_regionid IS NOT NULL LIMIT 1') ) {
+ push @header, 'Legacy #';
+ push @fields, 'agent_regionid';
+ push @links, $link;
+ push @align, 'right';
+ push @xls_format, { locked=>1, bg_color=>22};
+}
+
+push @header, 'Region', 'Country code', 'Prefixes';
+push @fields, 'regionname', 'ccode', $sub_prefixes;
+push @links, ($link) x 3;
+push @align, 'left', 'right', 'left';
+push @xls_format, ({ locked=>1, bg_color=>22 }) x 3;
my $countrycode_filter_change =
"window.location = '".
empty_label => '(global)',
&>
+% if ( $rate->agent_rateid ) {
+ <TR>
+ <TH ALIGN="right">Legacy #</TH>
+ <TD><% $rate->agent_rateid |h %></TD>
+ </TR>
+% }
+
<TR>
- <TD>Rate plan</TD>
+ <TH>Rate plan</TH>
<TD><INPUT TYPE="text" NAME="ratename" SIZE=32 VALUE="<% $rate->ratename %>"></TD>
</TR>
</TABLE>
%# region info
-<% ntable('#cccccc') %>
+<TABLE CLASS="fsinnerbox">
+
+% if ( $rate_region->agent_regionid ) {
+ <TR>
+ <TH ALIGN="right">Legacy #</TH>
+ <TD><% $rate_region->agent_regionid |h %></TD>
+ </TR>
+% }
<TR>
<TH ALIGN="right">Region name</TH>
</TR>
<TR>
- <TD ALIGN="right">
+ <TH ALIGN="right">
<B>Prefixes</B>
<BR><FONT SIZE="-1">(comma-separated)</FONT>
- </TD>
+ </TH>
<TD>
<TEXTAREA NAME="npa" WRAP=SOFT><% join(', ', map { $_->npa. (length($_->nxx) ? '-'.$_->nxx : '') } @rate_prefix ) %></TEXTAREA>
</TD>