4 %if ( $cgi->keywords ) {
5 % my($query) = $cgi->keywords;
7 % $rate = qsearchs( 'rate', { 'ratenum' => $1 } );
9 % $rate = new FS::rate {};
11 %my $action = $rate->ratenum ? 'Edit' : 'Add';
18 % '30' => '30 second', # '1/2 minute',
23 %# WHERE 0 < ( SELECT COUNT(*) FROM rate_prefix
24 %# WHERE rate_region.regionnum = rate_prefix.regionnum
25 %# AND countrycode != '1'
32 <% include("/elements/header.html","$action Rate plan", menubar(
34 'View all rate plans' => "${p}browse/rate.cgi",
38 <% include('/elements/progress-init.html',
40 [ 'rate', 'min_', 'sec_' ],
45 <FORM NAME="OneTrueForm">
46 <INPUT TYPE="hidden" NAME="ratenum" VALUE="<% $rate->ratenum %>">
49 <INPUT TYPE="text" NAME="ratename" SIZE=32 VALUE="<% $rate->ratename %>">
56 <TH><FONT SIZE=-1>Included<BR>minutes</FONT></TH>
57 <TH><FONT SIZE=-1>Charge per<BR>minute</FONT></TH>
58 <TH><FONT SIZE=-1>Granularity</FONT></TH>
60 % foreach my $rate_region (
61 % #sort { lc($a->regionname) cmp lc($b->regionname) }
63 % 'table' => 'rate_region',
65 % 'order_by' => 'ORDER BY LOWER(regionname)',
67 % #'select' => 'DISTINCT ON ( regionnum ) rate_region.*',
69 % #'addl_from' => 'INNER JOIN rate_prefix USING ( regionnum )',
70 % #'extra_sql' => "WHERE countrycode != '1'",
72 % # 'ORDER BY regionname'
73 % # ERROR: SELECT DISTINCT ON expressions must
74 % # match initial ORDER BY expressions
75 % # also, DISTINCT ON is a Pg-ism
78 % my $n = $rate_region->regionnum;
80 % $rate->dest_detail($rate_region)
81 % || new FS::rate_detail { 'min_included' => 0,
83 % 'sec_granularity' => '60'
89 <TD><A HREF="<%$p%>edit/rate_region.cgi?<% $rate_region->regionnum %>"><% $rate_region->regionname %></A></TD>
90 <TD><% $rate_region->prefixes_short %></TD>
91 <TD><INPUT TYPE="text" SIZE=5 NAME="min_included<%$n%>" VALUE="<% $cgi->param("min_included$n") || $rate_detail->min_included %>"></TD>
92 <TD>$<INPUT TYPE="text" SIZE=4 NAME="min_charge<%$n%>" VALUE="<% sprintf('%.2f', $cgi->param("min_charge$n") || $rate_detail->min_charge ) %>"></TD>
94 <SELECT NAME="sec_granularity<%$n%>">
95 % foreach my $granularity ( keys %granularity ) {
97 <OPTION VALUE="<%$granularity%>"<% $granularity == ( $cgi->param("sec_granularity$n") || $rate_detail->sec_granularity ) ? ' SELECTED' : '' %>><%$granularity{$granularity}%>
106 <TD COLSPAN=5 ALIGN="center">
107 <A HREF="<%$p%>edit/rate_region.cgi"><I>Add a region</I></A>
113 <BR><INPUT NAME="submit" TYPE="button" VALUE="<%
114 $rate->ratenum ? "Apply changes" : "Add rate plan"
115 %>" onClick="document.OneTrueForm.submit.disabled=true; process();">