1 files changed, 123 insertions, 0 deletions
diff --git a/httemplate/search/sqlradius.html b/httemplate/search/sqlradius.html
new file mode 100644
index 0000000..8c40598
--- /dev/null
+++ b/httemplate/search/sqlradius.html
@@ -0,0 +1,123 @@
+<% include( '/elements/header.html', 'Search RADIUS sessions' ) %>
+
+<FORM NAME="OneTrueForm" ACTION="sqlradius.cgi" METHOD="GET">
+% #include( '/elements/table.html' ) 
+
+<% ntable('#cccccc') %>
+<TR>
+  <TD ALIGN="right">Username: </TD>
+  <TD><INPUT TYPE="text" NAME="username"></TD>
+</TR>
+<TR>
+  <TD></TD>
+  <TD><FONT SIZE="-1"><I>(leave blank to show all users)</I></FONT></TD>
+</TR>
+% my @part_export = qsearch( 'part_export', { 'exporttype' => 'sqlradius' } );
+%   push @part_export,
+%     qsearch( 'part_export', { 'exporttype' => 'sqlradius_withdomain' } );
+%
+% if ( grep { ! $_->option('hide_ip') } @part_export ) { 
+
+  <TR>
+    <TD ALIGN="right">IP address: </TD>
+    <TD><INPUT TYPE="text" NAME="ip"></TD>
+  </TR>
+  <TR>
+    <TD></TD>
+    <TD><FONT SIZE="-1"><I>(leave blank to show all IPs)</I></FONT></TD>
+  </TR>
+% } 
+% if ( grep { $_->option('show_called_station') } @part_export ) { 
+
+  <TR>
+    <TD ALIGN="right">Destination prefix:</TD>
+    <TD><INPUT TYPE="text" NAME="prefix"></TD>
+  </TR>
+  <TR>
+    <TD></TD>
+    <TD><FONT SIZE="-1"><I>(country code or country code and prefix)</I></FONT></TD>
+  </TR>
+  <TR>
+    <TD></TD>
+    <TD><FONT SIZE="-1"><I>(leave blank to show all destinations)</I></FONT></TD>
+  </TR>
+% } 
+
+  <TR>
+    <TD>Show:</TD>
+    <TD>
+      <INPUT TYPE="radio" NAME="open_sessions" VALUE="0" onClick="open_changed(this);" CHECKED>Completed sessions<BR>
+      <INPUT TYPE="radio" NAME="open_sessions" VALUE="1" onClick="open_changed(this);">Open sessions
+    </TD>
+  </TR>
+
+  <TR>
+    <TH COLSPAN=2>Session start</TD>
+  </TR>
+
+  <% include( '/elements/tr-input-beginning_ending.html',
+                'prefix'     => 'starttime',
+                'input_time' => 1,
+            )
+  %>
+
+  <SCRIPT TYPE="text/javascript">
+
+    function open_changed(what) {
+
+      var value=get_open_value(what); 
+      if ( value == '1' ) {
+        what.form.stoptime_beginning_text.disabled = true;
+        what.form.stoptime_ending_text.disabled = true;
+        what.form.stoptime_beginning_text.style.backgroundColor = '#dddddd';
+        what.form.stoptime_ending_text.style.backgroundColor = '#dddddd';
+        what.form.stoptime_beginning_button.style.display = 'none';
+        what.form.stoptime_ending_button.style.display = 'none';
+        what.form.stoptime_beginning_disabled.style.display = '';
+        what.form.stoptime_ending_disabled.style.display = '';
+      } else if ( value == '0' ) {
+        what.form.stoptime_beginning_text.disabled = false;
+        what.form.stoptime_ending_text.disabled = false;
+        what.form.stoptime_beginning_text.style.backgroundColor = '#ffffff';
+        what.form.stoptime_ending_text.style.backgroundColor = '#ffffff';
+        what.form.stoptime_beginning_button.style.display = '';
+        what.form.stoptime_ending_button.style.display = '';
+        what.form.stoptime_beginning_disabled.style.display = 'none';
+        what.form.stoptime_ending_disabled.style.display = 'none';
+      }
+
+    }
+
+    function get_open_value(what) {
+      var rad_val = '';
+      for (var i=0; i < what.form.open_sessions.length; i++) {
+        if (what.form.open_sessions[i].checked) {
+          var rad_val = what.form.open_sessions[i].value;
+        }
+     }
+     return rad_val;
+   }
+
+  </SCRIPT>
+
+  <TR>
+    <TH COLSPAN=2>Session end</TD>
+  </TR>
+
+  <% include( '/elements/tr-input-beginning_ending.html',
+                'prefix'     => 'stoptime',
+                'input_time' => 1,
+            )
+  %>
+
+</TABLE>
+<BR><INPUT TYPE="submit" VALUE="View sessions">
+</FORM>
+
+<% include('/elements/footer.html') %>
+<%init>
+
+die "access denied"
+  unless $FS::CurrentUser::CurrentUser->access_right('List rating data');
+
+</%init>