comparison contrib/app_acct_tools/display_self.php @ 533:4cdf146f11d5

Added a set of example PHP scripts to parse the app_acct.fdx data.
author Sebastien Decugis <sdecugis@nict.go.jp>
date Tue, 07 Sep 2010 16:57:48 +0900
parents
children
comparison
equal deleted inserted replaced
532:4cb8f63a0f67 533:4cdf146f11d5
1 <?php
2
3 # This file is an example wrapper around display_results.php.
4
5 # It relies on clients authentication based on certificate usage
6 # (it must be the same certificate as used during AAA access, so that the User-Name matches).
7 # See your web server documentation for details.
8 # Example for apache2:
9 # (+ detail in http://httpd.apache.org/docs/2.0/ssl/ssl_howto.html#allclients )
10 # - in vhost definition file, refence the CA chain of your users certificates:
11 # SSLCACertificateFile /var/www/conf/ssl.crt/ca.crt
12 # - in vhost file or .htaccess file (adjust Depth to your setup):
13 # <IfModule mod_ssl.c>
14 # SSLVerifyClient require
15 # SSLVerifyDepth 2
16 # </IfModule>
17
18 /* Check the client is correctly SSL authenticated with his server */
19 if (!isset($_SERVER["SSL_CLIENT_VERIFY"]) || $_SERVER["SSL_CLIENT_VERIFY"] != "SUCCESS")
20 die("SSL authentication failed, the webserver is probably not configured correctly.\n");
21
22 /* Force some parameters to integer values */
23 if ($_GET["t_limit"])
24 $_GET["t_limit"] = (int) $_GET["t_limit"];
25 if ($_GET["t_offset"])
26 $_GET["t_offset"] = (int) $_GET["t_offset"];
27
28 /* Default form values */
29 if (!isset($_GET["Submit"])) {
30 $_GET["t_limit"] = 50;
31 $_GET["c_limit"] = 1;
32 $_GET["t_offset"] = 0;
33 }
34
35 /* Output the form */
36 ?>
37 <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
38 <html lang="en-US">
39 <head>
40 <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
41
42 <title>Accounting Data</title>
43 <meta name="description" content="This page gives you access to your personal accounting data.">
44 <meta name="keywords" content="accounting">
45
46 <style type="text/css">
47 body { text-align:center; }
48 table { border-collapse:collapse; margin-left:auto; margin-right:auto; }
49 table, td, th { border:1px solid green; padding-left:.5em; padding-right:.5em;}
50 th { background-color:green; color:white; }
51 </style>
52 </head>
53
54 <body >
55 <h1>Accounting data</h1>
56 <p>Note well: this page displays only data about <em>terminated</em> sessions.</p>
57 <form method="GET">
58 <table>
59 <tr>
60 <th colspan="3">
61 Filtering parameters
62 </th>
63 </tr>
64 <tr>
65 <td><input type="checkbox" name="c_starttime"<?php if (isset($_GET["c_starttime"])) echo " checked"; ?>></td>
66 <td>Show only sessions starting from (<a href="http://www.postgresql.org/docs/8.4/static/datatype-datetime.html">YYYY-MM-DD HH:MM:SS</a>):</td>
67 <td><input type="text" name="t_starttime"<?php if (isset($_GET["t_starttime"])) echo 'value="'.$_GET["t_starttime"].'"'; ?>></td>
68 </tr>
69 <tr>
70 <td><input type="checkbox" name="c_endtime"<?php if (isset($_GET["c_endtime"])) echo " checked"; ?>></td>
71 <td>Show only sessions starting until (<a href="http://www.postgresql.org/docs/8.4/static/datatype-datetime.html">YYYY-MM-DD HH:MM:SS</a>):</td>
72 <td><input type="text" name="t_endtime"<?php if (isset($_GET["t_endtime"])) echo 'value="'.$_GET["t_endtime"].'"'; ?>></td>
73 </tr>
74 <tr>
75 <td><input type="checkbox" name="c_limit"<?php if (isset($_GET["c_limit"])) echo " checked"; ?>></td>
76 <td>Show only this number of records:</td>
77 <td><input type="text" name="t_limit"<?php if (isset($_GET["t_limit"])) echo 'value="'.$_GET["t_limit"].'"'; ?>></td>
78 </tr>
79 <tr>
80 <td><input type="checkbox" name="c_offset"<?php if (isset($_GET["c_offset"])) echo " checked"; ?>></td>
81 <td>Starting from record:</td>
82 <td><input type="text" name="t_offset"<?php if (isset($_GET["t_offset"])) echo 'value="'.$_GET["t_offset"].'"'; ?>></td>
83 </tr>
84 <tr>
85 <th colspan="3">
86 Apply this filter: <input type="submit" name="Submit">
87 </th>
88 </tr>
89 </table>
90 </form>
91
92 <p>
93 Currently displaying user <em><?php echo htmlentities($_SERVER["SSL_CLIENT_S_DN_CN"]); ?></em><?php
94
95 /* Search user by CN or Email since some OS use the later during EAP-TLS authentication */
96 $USERS = array($_SERVER["SSL_CLIENT_S_DN_CN"], $_SERVER["SSL_CLIENT_S_DN_Email"]);
97
98 /* If the start time boundary was specified... */
99 if ($_GET["c_starttime"] && $_GET["t_starttime"]) {
100 $START_TIME=$_GET["t_starttime"];
101 }
102 if ($_GET["c_endtime"] && $_GET["t_endtime"]) {
103 $END_TIME=$_GET["t_endtime"];
104 }
105
106 /* idem with end time */
107 if ($START_TIME && $END_TIME) {
108 echo ", sessions starting between $START_TIME and $END_TIME";
109 } elseif ($START_TIME) {
110 echo ", sessions starting after $START_TIME";
111 } elseif ($END_TIME) {
112 echo ", sessions starting before $END_TIME";
113 }
114
115 /* Pagination */
116 if ($_GET["c_limit"] && $_GET["t_limit"]) {
117 $LIMIT=$_GET["t_limit"];
118 }
119 if ($_GET["c_offset"] && $_GET["t_offset"]) {
120 $LIMIT_OFFSET=$_GET["t_offset"];
121 }
122 if ($LIMIT) {
123 echo ", limited to ".$LIMIT." records";
124 if ($LIMIT_OFFSET)
125 echo " starting at ".$LIMIT_OFFSET;
126 } else if ($LIMIT_OFFSET) {
127 echo " starting at record ".$LIMIT_OFFSET;
128 }
129 echo ".\n";
130 ?>
131 </p>
132
133 <?php
134 /* This file will generate the array of data matching the selection */
135 require("display_results.php");
136
137 ?>
138 </body>
139 </html>
"Welcome to our mercurial repository"