WebSVN – ALCASAR – Diff – /web/acc/manager/htdocs/user_stats.php


<?php
# $Id: user_stats.php 2191 2017-04-28 22:00:32Z tom.houdayer $
 
require('/etc/freeradius-web/config.php');
require('../lib/functions.php');
require('../lib/sql/nas_list.php');
require_once('../lib/xlat.php');
?>
<html>
<?php
 
if (is_file("../lib/sql/drivers/$config[sql_type]/functions.php"))
	include_once("../lib/sql/drivers/$config[sql_type]/functions.php");
else{
	echo <<<EOM
<title>Statistiques utilisateurs</title>
<meta http-equiv="Content-Type" content="text/html; charset=$config[general_charset]">
<link rel="stylesheet" href="style.css">
</head>
<body>
<center>
<b>Could not include SQL library functions. Aborting</b>
</body>
</html>
EOM;
	exit();
}
 
if (!isset($start) && !isset($stop)){
//if($start == '' && $stop == ''){
	$now = time();
	$stop = date($config['sql_date_format'],$now);
	$now -= 604800;
	$start = date($config['sql_date_format'],$now);
}
$start = da_sql_escape_string($link,$start);
$stop = da_sql_escape_string($link,$stop);
 
 
?>
 
<head>
<title>Statistiques utilisateurs</title>
<link rel="stylesheet" href="style.css">
</head>
<body>
<center>
<table border=0 width=550 cellpadding=0 cellspacing=0>
<tr valign=top>
<!--<td align=center><img src="images/title2.gif"></td>-->
</tr>
</table>
</table>
<br>
<tr valign=top>
<td width=65%></td>
<td bgcolor="black" width=35%>
<TABLE width="100%" border=1 cellspacing=0 cellpadding=0>
	<tr bgcolor="#666666"align=center><td>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
	<font color="white">Statistiques utilisateurs</font>&nbsp;
	<tr><th></th></tr>
	<tr bgcolor="#FFCC66"><td><img src="/images/pix.gif" width="1" height="2"></td></tr>
</table>
<?php
if(isset($pagesize))
{	
echo <<<EOM
De <b>$start</b> &agrave;  <b>$stop</b>
 
<p>
	<table border=1 bordercolordark=#ffffe0 bordercolorlight=#000000 width=100% cellpadding=2 cellspacing=0 bgcolor="#ffffe0" valign=top>
	<tr bgcolor="#d0ddb0">
	<th>#</th><th>Identifiant</th><th>Date</th><th>Serveur</th><th>Nombres de connections</th><th>Dur&eacute;e des connections</th><th>Upload</th><th>Download</th><th>Serveur</th>
	</tr>
EOM;
 
$pagesize = ($pagesize) ? $pagesize : 10;
 
 
$selected[5] = "";
$selected[10] = "";
$selected[15] = "";
$selected[20] = "";
$selected[40] = "";
$selected[80] = "";
$selected['all'] = "";
$selected['num'] = "";
$selected['time'] = "";
$selected['asc'] = "";
$selected['desc'] = "";
 
if (!is_numeric($pagesize) && $pagesize != 'all')
	$pagezise = 10;
if ($pagesize > 100)
	$pagesize = 100;
$limit = ($pagesize == 'all') ? '100' : "$pagesize";
$selected[$pagesize] = 'selected';
$order = ($order) ? $order : $config['general_accounting_info_order'];
if ($order != 'desc' && $order != 'asc')
	$order = 'desc';
if ($sortby != '')
	$order_attr = ($sortby == 'num') ? 'connnum' : 'conntotduration';
else
	$order_attr = 'connnum';
if ($server != '' && $server != 'all'){
	$server = da_sql_escape_string($link,$server);
	$server_str = "AND nasipaddress = '$server'";
}
else
{
	$server_str = "";
}
$login_str = ($login) ? "AND username = '$login' " : '';
 
$selected[$order] = 'selected';
$selected[$sortby] = 'selected';
 
$sql_extra_query = '';
if (isset($config['sql_accounting_extra_query'])){
	$sql_extra_query = xlat($config['sql_accounting_extra_query'],$login,$config);
	$sql_extra_query = da_sql_escape_string($link,$sql_extra_query);
}
 
unset($da_name_cache);
if (isset($_SESSION['da_name_cache']))
	$da_name_cache = $_SESSION['da_name_cache'];
 
 
 
 
$link = @da_sql_pconnect($config);
if ($link){
	$num = 0;
	$search = @da_sql_query($link,$config,
	"SELECT " . da_sql_limit($limit,0,$config) . " * FROM $config[sql_total_accounting_table]
	WHERE acctdate >= '$start' AND acctdate <= '$stop' $server_str $login_str $sql_extra_query " . da_sql_limit($limit,1,$config)
	. " ORDER BY $order_attr $order " . da_sql_limit($limit,2,$config) . " ;");
 
	if ($search){
		while( $row = @da_sql_fetch_array($search,$config) ){
			$num++;
			$acct_login = $row['username'];
			if ($acct_login == '')
				$acct_login = '-';
			else{
				$Acct_login = urlencode($acct_login);
				$acct_login = "<a href=\"user_admin.php?login=$Acct_login\" title=\"Editer l'utilisateur $acct_login\">$acct_login</a>";
			}
			$acct_time = $row['conntotduration'];
			$acct_time = time2str($acct_time);
			$acct_conn_num = $row['connnum'];
			$acct_date = $row['acctdate'];
			$acct_upload = $row['inputoctets'];
			$acct_download = $row['outputoctets'];
			$acct_upload = bytes2str($acct_upload);
			$acct_download = bytes2str($acct_download);
			if (!isset($acct_server)){
				$acct_server = @gethostbyaddr($row['nasipaddress']);
				if (!isset($da_name_cache) && $config['general_use_session'] == 'yes'){
					$da_name_cache[$row['nasipaddress']] = $acct_server;
					session_register('da_name_cache');
				}
				else
					$da_name_cache[$row['nasipaddress']] = $acct_server;
			}
			if ($acct_server == '')
				$acct_server = '-';
			echo <<<EOM
			<tr align=center bgcolor="white">
				<td>$num</td>
				<td>$acct_login</td>
				<td>$acct_date</td>
				<td>$acct_server</td>
				<td>$acct_conn_num</td>
				<td>$acct_time</td>
				<td>$acct_upload</td>
				<td>$acct_download</td>
				<td>$acct_server</td>
 
			</tr>
EOM;
		}
	}
 
}
echo <<<EOM
	</table>
<tr><td>
<hr>
EOM;
}
else
{
	//create dummy selected
	if(!isset($selected))	
	{
		$selected = array();
		$selected[5] = "";
		$selected[10] = "";
		$selected[15] = "";
		$selected[20] = "";
		$selected[40] = "";
		$selected[80] = "";
		$selected['all'] = "";
		$selected['num'] = "";
		$selected['time'] = "";
		$selected['asc'] = "";
		$selected['desc'] = "";
	}
 
 
}
echo <<<EOM
<tr><td align="left">
	<form action="user_stats.php" method="post" name="master">
	<table border=0>
		<tr valign="bottom">
			<td><small><b>date d&eacute;but</td><td><small><b>date fin</td><td><small><b>nbr./page</td><td><small><b>tri&eacute; par</td><td><small><b>class&eacute; par ordre </td>
	<tr valign="middle"><td>
<input type="hidden" name="show" value="0">
<input type="text" name="start" size="11" value="$start"></td>
<td><input type="text" name="stop" size="11" value="$stop"></td>
<td><select name="pagesize">
 
<option $selected[5] value="5" >5
<option $selected[10] value="10">10
<option $selected[15] value="15">15
<option $selected[20] value="20">20
<option $selected[40] value="40">40
<option $selected[80] value="80">80
<option $selected[all] value="all">tous
</select>
</td>
<td>
<select name="sortby">
<option $selected[num] value="num">Nombre de connexions
<option $selected[time] value="time">Dur&eacute;e des connexions
</select>
</td>
<td><select name="order">
<option $selected[asc] value="asc">croissant
<option $selected[desc] value="desc">d&eacute;croissant
</select>
</td>
EOM;
 
?>
 
<td><input type="submit" class=button value="show"></td></tr>
<tr><td>
<b>Sur le serveur d'acc&egrave;s :</b>
</td>
<td><b>Utilisateur</b></td></tr>
<tr><td>
<select name="server">
<?php
foreach ($nas_list as $nas){
	$name = $nas['name'];
	if ($nas['ip'] == '')
		continue;
	$servers[$name] = $nas['ip'];
}
ksort($servers);
foreach ($servers as $name => $ip){
	if (isset($server) && ($server == $ip))
		echo "<option selected value=\"$ip\">$name\n";
	else
		echo "<option value=\"$ip\">$name\n";
}
if (isset($server) && ($server == '' || $server == 'all'))
	echo "<option selected value=\"all\">tous\n";
else
	echo "<option value=\"all\">tous\n";
?>
</select>
</td>
<td><input type="text" name="login" size="11" value="<?php if(!isset($login)){echo "";}else{ echo $login;} ?>"></td>
</tr>
</table></td></tr></form>
</table>
</tr>
</table>
</body>
</html>
 

Rev 1956	Rev 2191
1	`<?php`	1	`<?php`
-		2	`# $Id: user_stats.php 2191 2017-04-28 22:00:32Z tom.houdayer $`
-		3
2	`require('/etc/freeradius-web/config.php');`	4	`require('/etc/freeradius-web/config.php');`
3	`require('../lib/functions.php');`	5	`require('../lib/functions.php');`
4	`require('../lib/sql/nas_list.php');`	6	`require('../lib/sql/nas_list.php');`
5	`require_once('../lib/xlat.php');`	7	`require_once('../lib/xlat.php');`
6	`?>`	8	`?>`
7	`<html>`	9	`<html>`
8	`<?php`	10	`<?php`
9		11
10	`if (is_file("../lib/sql/drivers/$config[sql_type]/functions.php"))`	12	`if (is_file("../lib/sql/drivers/$config[sql_type]/functions.php"))`
11	`include_once("../lib/sql/drivers/$config[sql_type]/functions.php");`	13	`include_once("../lib/sql/drivers/$config[sql_type]/functions.php");`
12	`else{`	14	`else{`
13	`echo <<<EOM`	15	`echo <<<EOM`
14	`<title>Statistiques utilisateurs</title>`	16	`<title>Statistiques utilisateurs</title>`
15	`<meta http-equiv="Content-Type" content="text/html; charset=$config[general_charset]">`	17	`<meta http-equiv="Content-Type" content="text/html; charset=$config[general_charset]">`
16	`<link rel="stylesheet" href="style.css">`	18	`<link rel="stylesheet" href="style.css">`
17	`</head>`	19	`</head>`
18	`<body>`	20	`<body>`
19	`<center>`	21	`<center>`
20	`<b>Could not include SQL library functions. Aborting</b>`	22	`<b>Could not include SQL library functions. Aborting</b>`
21	`</body>`	23	`</body>`
22	`</html>`	24	`</html>`
23	`EOM;`	25	`EOM;`
24	`exit();`	26	`exit();`
25	`}`	27	`}`
26		28
27	`if (!isset($start) && !isset($stop)){`	29	`if (!isset($start) && !isset($stop)){`
28	`//if($start == '' && $stop == ''){`	30	`//if($start == '' && $stop == ''){`
29	`$now = time();`	31	`$now = time();`
30	`$stop = date($config['sql_date_format'],$now);`	32	`$stop = date($config['sql_date_format'],$now);`
31	`$now -= 604800;`	33	`$now -= 604800;`
32	`$start = date($config['sql_date_format'],$now);`	34	`$start = date($config['sql_date_format'],$now);`
33	`}`	35	`}`
34	`$start = da_sql_escape_string($link,$start);`	36	`$start = da_sql_escape_string($link,$start);`
35	`$stop = da_sql_escape_string($link,$stop);`	37	`$stop = da_sql_escape_string($link,$stop);`
36		38
37		39
38	`?>`	40	`?>`
39		41
40	`<head>`	42	`<head>`
41	`<title>Statistiques utilisateurs</title>`	43	`<title>Statistiques utilisateurs</title>`
42	`<link rel="stylesheet" href="style.css">`	44	`<link rel="stylesheet" href="style.css">`
43	`</head>`	45	`</head>`
44	`<body>`	46	`<body>`
45	`<center>`	47	`<center>`
46	`<table border=0 width=550 cellpadding=0 cellspacing=0>`	48	`<table border=0 width=550 cellpadding=0 cellspacing=0>`
47	`<tr valign=top>`	49	`<tr valign=top>`
48	`<!--<td align=center><img src="images/title2.gif"></td>-->`	50	`<!--<td align=center><img src="images/title2.gif"></td>-->`
49	`</tr>`	51	`</tr>`
50	`</table>`	52	`</table>`
51	`</table>`	53	`</table>`
52	`<br>`	54	`<br>`
53	`<tr valign=top>`	55	`<tr valign=top>`
54	`<td width=65%></td>`	56	`<td width=65%></td>`
55	`<td bgcolor="black" width=35%>`	57	`<td bgcolor="black" width=35%>`
56	`<TABLE width="100%" border=1 cellspacing=0 cellpadding=0>`	58	`<TABLE width="100%" border=1 cellspacing=0 cellpadding=0>`
57	`<tr bgcolor="#666666"align=center><td>`	59	`<tr bgcolor="#666666"align=center><td>`
58	`<table width="100%" border="0" cellspacing="0" cellpadding="0">`	60	`<table width="100%" border="0" cellspacing="0" cellpadding="0">`
59	`<font color="white">Statistiques utilisateurs</font> `	61	`<font color="white">Statistiques utilisateurs</font> `
60	`<tr><th></th></tr>`	62	`<tr><th></th></tr>`
61	`<tr bgcolor="#FFCC66"><td><img src="/images/pix.gif" width="1" height="2"></td></tr>`	63	`<tr bgcolor="#FFCC66"><td><img src="/images/pix.gif" width="1" height="2"></td></tr>`
62	`</table>`	64	`</table>`
63	`<?php`	65	`<?php`
64	`if(isset($pagesize))`	66	`if(isset($pagesize))`
65	`{`	67	`{`
66	`echo <<<EOM`	68	`echo <<<EOM`
67	`De <b>$start</b> à <b>$stop</b>`	69	`De <b>$start</b> à <b>$stop</b>`
68		70
69	`<p>`	71	`<p>`
70	`<table border=1 bordercolordark=#ffffe0 bordercolorlight=#000000 width=100% cellpadding=2 cellspacing=0 bgcolor="#ffffe0" valign=top>`	72	`<table border=1 bordercolordark=#ffffe0 bordercolorlight=#000000 width=100% cellpadding=2 cellspacing=0 bgcolor="#ffffe0" valign=top>`
71	`<tr bgcolor="#d0ddb0">`	73	`<tr bgcolor="#d0ddb0">`
72	`<th>#</th><th>Identifiant</th><th>Date</th><th>Serveur</th><th>Nombres de connections</th><th>Durée des connections</th><th>Upload</th><th>Download</th><th>Serveur</th>`	74	`<th>#</th><th>Identifiant</th><th>Date</th><th>Serveur</th><th>Nombres de connections</th><th>Durée des connections</th><th>Upload</th><th>Download</th><th>Serveur</th>`
73	`</tr>`	75	`</tr>`
74	`EOM;`	76	`EOM;`
75		77
76	`$pagesize = ($pagesize) ? $pagesize : 10;`	78	`$pagesize = ($pagesize) ? $pagesize : 10;`
77		79
78		80
79	`$selected[5] = "";`	81	`$selected[5] = "";`
80	`$selected[10] = "";`	82	`$selected[10] = "";`
81	`$selected[15] = "";`	83	`$selected[15] = "";`
82	`$selected[20] = "";`	84	`$selected[20] = "";`
83	`$selected[40] = "";`	85	`$selected[40] = "";`
84	`$selected[80] = "";`	86	`$selected[80] = "";`
85	`$selected['all'] = "";`	87	`$selected['all'] = "";`
86	`$selected['num'] = "";`	88	`$selected['num'] = "";`
87	`$selected['time'] = "";`	89	`$selected['time'] = "";`
88	`$selected['asc'] = "";`	90	`$selected['asc'] = "";`
89	`$selected['desc'] = "";`	91	`$selected['desc'] = "";`
90		92
91	`if (!is_numeric($pagesize) && $pagesize != 'all')`	93	`if (!is_numeric($pagesize) && $pagesize != 'all')`
92	`$pagezise = 10;`	94	`$pagezise = 10;`
93	`if ($pagesize > 100)`	95	`if ($pagesize > 100)`
94	`$pagesize = 100;`	96	`$pagesize = 100;`
95	`$limit = ($pagesize == 'all') ? '100' : "$pagesize";`	97	`$limit = ($pagesize == 'all') ? '100' : "$pagesize";`
96	`$selected[$pagesize] = 'selected';`	98	`$selected[$pagesize] = 'selected';`
97	`$order = ($order) ? $order : $config['general_accounting_info_order'];`	99	`$order = ($order) ? $order : $config['general_accounting_info_order'];`
98	`if ($order != 'desc' && $order != 'asc')`	100	`if ($order != 'desc' && $order != 'asc')`
99	`$order = 'desc';`	101	`$order = 'desc';`
100	`if ($sortby != '')`	102	`if ($sortby != '')`
101	`$order_attr = ($sortby == 'num') ? 'connnum' : 'conntotduration';`	103	`$order_attr = ($sortby == 'num') ? 'connnum' : 'conntotduration';`
102	`else`	104	`else`
103	`$order_attr = 'connnum';`	105	`$order_attr = 'connnum';`
104	`if ($server != '' && $server != 'all'){`	106	`if ($server != '' && $server != 'all'){`
105	`$server = da_sql_escape_string($link,$server);`	107	`$server = da_sql_escape_string($link,$server);`
106	`$server_str = "AND nasipaddress = '$server'";`	108	`$server_str = "AND nasipaddress = '$server'";`
107	`}`	109	`}`
108	`else`	110	`else`
109	`{`	111	`{`
110	`$server_str = "";`	112	`$server_str = "";`
111	`}`	113	`}`
112	`$login_str = ($login) ? "AND username = '$login' " : '';`	114	`$login_str = ($login) ? "AND username = '$login' " : '';`
113		115
114	`$selected[$order] = 'selected';`	116	`$selected[$order] = 'selected';`
115	`$selected[$sortby] = 'selected';`	117	`$selected[$sortby] = 'selected';`
116		118
117	`$sql_extra_query = '';`	119	`$sql_extra_query = '';`
118	`if (isset($config['sql_accounting_extra_query'])){`	120	`if (isset($config['sql_accounting_extra_query'])){`
119	`$sql_extra_query = xlat($config['sql_accounting_extra_query'],$login,$config);`	121	`$sql_extra_query = xlat($config['sql_accounting_extra_query'],$login,$config);`
120	`$sql_extra_query = da_sql_escape_string($link,$sql_extra_query);`	122	`$sql_extra_query = da_sql_escape_string($link,$sql_extra_query);`
121	`}`	123	`}`
122		124
123	`unset($da_name_cache);`	125	`unset($da_name_cache);`
124	`if (isset($_SESSION['da_name_cache']))`	126	`if (isset($_SESSION['da_name_cache']))`
125	`$da_name_cache = $_SESSION['da_name_cache'];`	127	`$da_name_cache = $_SESSION['da_name_cache'];`
126		128
127		129
128		130
129		131
130	`$link = @da_sql_pconnect($config);`	132	`$link = @da_sql_pconnect($config);`
131	`if ($link){`	133	`if ($link){`
132	`$num = 0;`	134	`$num = 0;`
133	`$search = @da_sql_query($link,$config,`	135	`$search = @da_sql_query($link,$config,`
134	`"SELECT " . da_sql_limit($limit,0,$config) . " * FROM $config[sql_total_accounting_table]`	136	`"SELECT " . da_sql_limit($limit,0,$config) . " * FROM $config[sql_total_accounting_table]`
135	`WHERE acctdate >= '$start' AND acctdate <= '$stop' $server_str $login_str $sql_extra_query " . da_sql_limit($limit,1,$config)`	137	`WHERE acctdate >= '$start' AND acctdate <= '$stop' $server_str $login_str $sql_extra_query " . da_sql_limit($limit,1,$config)`
136	`. " ORDER BY $order_attr $order " . da_sql_limit($limit,2,$config) . " ;");`	138	`. " ORDER BY $order_attr $order " . da_sql_limit($limit,2,$config) . " ;");`
137		139
138	`if ($search){`	140	`if ($search){`
139	`while( $row = @da_sql_fetch_array($search,$config) ){`	141	`while( $row = @da_sql_fetch_array($search,$config) ){`
140	`$num++;`	142	`$num++;`
141	`$acct_login = $row['username'];`	143	`$acct_login = $row['username'];`
142	`if ($acct_login == '')`	144	`if ($acct_login == '')`
143	`$acct_login = '-';`	145	`$acct_login = '-';`
144	`else{`	146	`else{`
145	`$Acct_login = urlencode($acct_login);`	147	`$Acct_login = urlencode($acct_login);`
146	`$acct_login = "<a href=\"user_admin.php?login=$Acct_login\" title=\"Editer l'utilisateur $acct_login\">$acct_login</a>";`	148	`$acct_login = "<a href=\"user_admin.php?login=$Acct_login\" title=\"Editer l'utilisateur $acct_login\">$acct_login</a>";`
147	`}`	149	`}`
148	`$acct_time = $row['conntotduration'];`	150	`$acct_time = $row['conntotduration'];`
149	`$acct_time = time2str($acct_time);`	151	`$acct_time = time2str($acct_time);`
150	`$acct_conn_num = $row['connnum'];`	152	`$acct_conn_num = $row['connnum'];`
151	`$acct_date = $row['acctdate'];`	153	`$acct_date = $row['acctdate'];`
152	`$acct_upload = $row['inputoctets'];`	154	`$acct_upload = $row['inputoctets'];`
153	`$acct_download = $row['outputoctets'];`	155	`$acct_download = $row['outputoctets'];`
154	`$acct_upload = bytes2str($acct_upload);`	156	`$acct_upload = bytes2str($acct_upload);`
155	`$acct_download = bytes2str($acct_download);`	157	`$acct_download = bytes2str($acct_download);`
156	`if (!isset($acct_server)){`	158	`if (!isset($acct_server)){`
157	`$acct_server = @gethostbyaddr($row['nasipaddress']);`	159	`$acct_server = @gethostbyaddr($row['nasipaddress']);`
158	`if (!isset($da_name_cache) && $config['general_use_session'] == 'yes'){`	160	`if (!isset($da_name_cache) && $config['general_use_session'] == 'yes'){`
159	`$da_name_cache[$row['nasipaddress']] = $acct_server;`	161	`$da_name_cache[$row['nasipaddress']] = $acct_server;`
160	`session_register('da_name_cache');`	162	`session_register('da_name_cache');`
161	`}`	163	`}`
162	`else`	164	`else`
163	`$da_name_cache[$row['nasipaddress']] = $acct_server;`	165	`$da_name_cache[$row['nasipaddress']] = $acct_server;`
164	`}`	166	`}`
165	`if ($acct_server == '')`	167	`if ($acct_server == '')`
166	`$acct_server = '-';`	168	`$acct_server = '-';`
167	`echo <<<EOM`	169	`echo <<<EOM`
168	`<tr align=center bgcolor="white">`	170	`<tr align=center bgcolor="white">`
169	`<td>$num</td>`	171	`<td>$num</td>`
170	`<td>$acct_login</td>`	172	`<td>$acct_login</td>`
171	`<td>$acct_date</td>`	173	`<td>$acct_date</td>`
172	`<td>$acct_server</td>`	174	`<td>$acct_server</td>`
173	`<td>$acct_conn_num</td>`	175	`<td>$acct_conn_num</td>`
174	`<td>$acct_time</td>`	176	`<td>$acct_time</td>`
175	`<td>$acct_upload</td>`	177	`<td>$acct_upload</td>`
176	`<td>$acct_download</td>`	178	`<td>$acct_download</td>`
177	`<td>$acct_server</td>`	179	`<td>$acct_server</td>`
178		180
179	`</tr>`	181	`</tr>`
180	`EOM;`	182	`EOM;`
181	`}`	183	`}`
182	`}`	184	`}`
183		185
184	`}`	186	`}`
185	`echo <<<EOM`	187	`echo <<<EOM`
186	`</table>`	188	`</table>`
187	`<tr><td>`	189	`<tr><td>`
188	`<hr>`	190	`<hr>`
189	`EOM;`	191	`EOM;`
190	`}`	192	`}`
191	`else`	193	`else`
192	`{`	194	`{`
193	`//create dummy selected`	195	`//create dummy selected`
194	`if(!isset($selected))`	196	`if(!isset($selected))`
195	`{`	197	`{`
196	`$selected = array();`	198	`$selected = array();`
197	`$selected[5] = "";`	199	`$selected[5] = "";`
198	`$selected[10] = "";`	200	`$selected[10] = "";`
199	`$selected[15] = "";`	201	`$selected[15] = "";`
200	`$selected[20] = "";`	202	`$selected[20] = "";`
201	`$selected[40] = "";`	203	`$selected[40] = "";`
202	`$selected[80] = "";`	204	`$selected[80] = "";`
203	`$selected['all'] = "";`	205	`$selected['all'] = "";`
204	`$selected['num'] = "";`	206	`$selected['num'] = "";`
205	`$selected['time'] = "";`	207	`$selected['time'] = "";`
206	`$selected['asc'] = "";`	208	`$selected['asc'] = "";`
207	`$selected['desc'] = "";`	209	`$selected['desc'] = "";`
208	`}`	210	`}`
209		211
210		212
211	`}`	213	`}`
212	`echo <<<EOM`	214	`echo <<<EOM`
213	`<tr><td align="left">`	215	`<tr><td align="left">`
214	`<form action="user_stats.php" method="post" name="master">`	216	`<form action="user_stats.php" method="post" name="master">`
215	`<table border=0>`	217	`<table border=0>`
216	`<tr valign="bottom">`	218	`<tr valign="bottom">`
217	`<td><small><b>date début</td><td><small><b>date fin</td><td><small><b>nbr./page</td><td><small><b>trié par</td><td><small><b>classé par ordre </td>`	219	`<td><small><b>date début</td><td><small><b>date fin</td><td><small><b>nbr./page</td><td><small><b>trié par</td><td><small><b>classé par ordre </td>`
218	`<tr valign="middle"><td>`	220	`<tr valign="middle"><td>`
219	`<input type="hidden" name="show" value="0">`	221	`<input type="hidden" name="show" value="0">`
220	`<input type="text" name="start" size="11" value="$start"></td>`	222	`<input type="text" name="start" size="11" value="$start"></td>`
221	`<td><input type="text" name="stop" size="11" value="$stop"></td>`	223	`<td><input type="text" name="stop" size="11" value="$stop"></td>`
222	`<td><select name="pagesize">`	224	`<td><select name="pagesize">`
223		225
224	`<option $selected[5] value="5" >5`	226	`<option $selected[5] value="5" >5`
225	`<option $selected[10] value="10">10`	227	`<option $selected[10] value="10">10`
226	`<option $selected[15] value="15">15`	228	`<option $selected[15] value="15">15`
227	`<option $selected[20] value="20">20`	229	`<option $selected[20] value="20">20`
228	`<option $selected[40] value="40">40`	230	`<option $selected[40] value="40">40`
229	`<option $selected[80] value="80">80`	231	`<option $selected[80] value="80">80`
230	`<option $selected[all] value="all">tous`	232	`<option $selected[all] value="all">tous`
231	`</select>`	233	`</select>`
232	`</td>`	234	`</td>`
233	`<td>`	235	`<td>`
234	`<select name="sortby">`	236	`<select name="sortby">`
235	`<option $selected[num] value="num">Nombre de connexions`	237	`<option $selected[num] value="num">Nombre de connexions`
236	`<option $selected[time] value="time">Durée des connexions`	238	`<option $selected[time] value="time">Durée des connexions`
237	`</select>`	239	`</select>`
238	`</td>`	240	`</td>`
239	`<td><select name="order">`	241	`<td><select name="order">`
240	`<option $selected[asc] value="asc">croissant`	242	`<option $selected[asc] value="asc">croissant`
241	`<option $selected[desc] value="desc">décroissant`	243	`<option $selected[desc] value="desc">décroissant`
242	`</select>`	244	`</select>`
243	`</td>`	245	`</td>`
244	`EOM;`	246	`EOM;`
245		247
246	`?>`	248	`?>`
247		249
248	`<td><input type="submit" class=button value="show"></td></tr>`	250	`<td><input type="submit" class=button value="show"></td></tr>`
249	`<tr><td>`	251	`<tr><td>`
250	`<b>Sur le serveur d'accès :</b>`	252	`<b>Sur le serveur d'accès :</b>`
251	`</td>`	253	`</td>`
252	`<td><b>Utilisateur</b></td></tr>`	254	`<td><b>Utilisateur</b></td></tr>`
253	`<tr><td>`	255	`<tr><td>`
254	`<select name="server">`	256	`<select name="server">`
255	`<?php`	257	`<?php`
256	`foreach ($nas_list as $nas){`	258	`foreach ($nas_list as $nas){`
257	`$name = $nas['name'];`	259	`$name = $nas['name'];`
258	`if ($nas['ip'] == '')`	260	`if ($nas['ip'] == '')`
259	`continue;`	261	`continue;`
260	`$servers[$name] = $nas[ip];`	262	`$servers[$name] = $nas['ip'];`
261	`}`	263	`}`
262	`ksort($servers);`	264	`ksort($servers);`
263	`foreach ($servers as $name => $ip){`	265	`foreach ($servers as $name => $ip){`
264	`if ($server == $ip)`	266	`if (isset($server) && ($server == $ip))`
265	`echo "<option selected value=\"$ip\">$name\n";`	267	`echo "<option selected value=\"$ip\">$name\n";`
266	`else`	268	`else`
267	`echo "<option value=\"$ip\">$name\n";`	269	`echo "<option value=\"$ip\">$name\n";`
268	`}`	270	`}`
269	`if (isset($server) && ($server == '' \|\| $server == 'all'))`	271	`if (isset($server) && ($server == '' \|\| $server == 'all'))`
270	`echo "<option selected value=\"all\">tous\n";`	272	`echo "<option selected value=\"all\">tous\n";`
271	`else`	273	`else`
272	`echo "<option value=\"all\">tous\n";`	274	`echo "<option value=\"all\">tous\n";`
273	`?>`	275	`?>`
274	`</select>`	276	`</select>`
275	`</td>`	277	`</td>`
276	`<td><input type="text" name="login" size="11" value="<?php if(!isset($login)){echo "";}else{ echo $login;} ?>"></td>`	278	`<td><input type="text" name="login" size="11" value="<?php if(!isset($login)){echo "";}else{ echo $login;} ?>"></td>`
277	`</tr>`	279	`</tr>`
278	`</table></td></tr></form>`	280	`</table></td></tr></form>`
279	`</table>`	281	`</table>`
280	`</tr>`	282	`</tr>`
281	`</table>`	283	`</table>`
282	`</body>`	284	`</body>`
283	`</html>`	285	`</html>`
284		286

Subversion Repositories ALCASAR

(root)/web/acc/manager/htdocs/user_stats.php @ 2304 – Rev 1956 → 2191