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


<?php
# $Id: user_stats.php 2854 2020-07-20 22:08:05Z rexy $
 
require('/etc/freeradius-web/config.php');
require('../lib/functions.php');
require('../lib/sql/nas_list.php');
require_once('../lib/xlat.php');
?>
<!DOCTYPE html>
<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="/css/acc.css">
</head>
<body>
<center>
<b>Could not include SQL library functions. Aborting</b>
</body>
</html>
EOM;
	exit();
}
# Choice of language
$Language = 'en';
if(isset($_SERVER['HTTP_ACCEPT_LANGUAGE'])){
	$Langue		= explode(",",$_SERVER['HTTP_ACCEPT_LANGUAGE']);
	$Language	= strtolower(substr(chop($Langue[0]),0,2)); }
if($Language == 'fr'){
	$l_title		= "Statistiques de connexion des utilisateurs";
	$l_start_date		= "Dates de début";
	$l_end_date		= "Dates de fin";
	$l_number_result	= "Nb. résultat / page";
	$l_order_by		= "Trié par";
	$l_sorted_order		= "Classé par ordre";
	$l_all			= "Tous";
	$l_con_number		= "Nombre de connexions";
	$l_con_length		= "Durée de connexions";
	$l_ascending		= "Croissant";
	$l_descending		= "Décroissant";
	$l_server		= "Sur le serveur";
	$l_user			= "Filtrer pour un utilisateur (laissez vide pour tous)";
	$l_show			= "Montrer";
	$l_from			= "Du";
	$l_to			= "au";
	$l_server		= "Serveur";
	$l_login		= "Identifiant";
	$l_user_edit		= "Éditer l'utilisateur";
} else if($Language == 'es') {
    $l_title		= "Estadísticas de conexiones de los Usuarios";
	$l_start_date		= "Desde fecha";
	$l_end_date		= "Hasta fecha";
	$l_number_result	= "Nro de resultados / páginas";
	$l_order_by		= "Ordenados por";
	$l_sorted_order		= "Ordenar resultados";
	$l_all			= "Todos";
	$l_con_number		= "Números de conexiones";
	$l_con_length		= "Duración de la conexión";
	$l_ascending		= "Ascendente";
	$l_descending		= "Descendente";
	$l_server		= "En el servidor";
	$l_user			= "Filtrar por usuario (en blanco para todos los usuarios)";
	$l_show			= "Mostrar";
	$l_from			= "Desde";
	$l_to			= "hasta";
	$l_server		= "Servidor";
	$l_login		= "Usuario";
	$l_user_edit		= "Modificar usuario";
} else {
	$l_title		= "Statistics of users connexions";
	$l_start_date		= "Start date";
	$l_end_date		= "End date";
	$l_number_result	= "Nb results / page";
	$l_order_by		= "Sorted by";
	$l_sorted_order		= "Sorted order";
	$l_all			= "All";
	$l_con_number		= "Connections number";
	$l_con_length		= "Connection length";
	$l_ascending		= "Ascending";
	$l_descending		= "Descending";
	$l_server		= "On server";
	$l_user			= "Filter for a user (let empty for all)";
	$l_show			= "Show";
	$l_from			= "From";
	$l_to			= "to";
	$l_server		= "Server";
	$l_login		= "Login";
	$l_user_edit		= "Edit user";
}
if (!isset($start) && !isset($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><?php echo "$l_title";?></title>
<link rel="stylesheet" href="/css/acc.css" type="text/css">
</head>
<body>
<div class="panel">
	<div class="panel-header"><?= $l_title ?></div>
	<div class="panel-row">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
 
 
 
 
 
 
<?php
if(isset($pagesize))
{	
	echo <<<EOM
<tr align="center"><td colspan="9">
$l_from $start $l_to $stop
</td></tr>
<tr>
<th>#</th><th>$l_login</th><th>Date</th><th>$l_server</th><th>$l_con_number</th><th>$l_con_length</th><th>Upload</th><th>Download</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=\"$l_user_edit $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>
			</tr>
EOM;
			}
		}
	}
	echo <<<EOM
</table>
<hr>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
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" align="center">
		<td><small><b>$l_start_date</b></small></td><td><small><b>$l_end_date</b></small></td><td><small><b>$l_number_result</b></small></td><td><small><b>$l_order_by</b></small></td><td><small><b>$l_sorted_order</b></small></td></tr>
	<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">$l_all
</select>
</td>
<td>
<select name="sortby">
<option $selected[num] value="num">$l_con_number
<option $selected[time] value="time">$l_con_length
</select>
</td>
<td><select name="order">
<option $selected[asc] value="asc">$l_ascending
<option $selected[desc] value="desc">$l_descending
</select>
</td>
EOM;
?>
	<td><input type="submit" class=button value="<?php echo "$l_show";?>"></td>
</tr>
<tr align="center">
<td><small><b><?php echo "$l_server";?></b></small></td>
<td><small><b><?php echo "$l_user";?></b></small></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>
</form>
</td></tr></table>
	</div>
</div>
</body>
</html>
 

Rev 2817	Rev 2854
1	`<?php`	1	`<?php`
2	`# $Id: user_stats.php 2817 2020-05-09 09:35:56Z rexy $`	2	`# $Id: user_stats.php 2854 2020-07-20 22:08:05Z rexy $`
3		3
4	`require('/etc/freeradius-web/config.php');`	4	`require('/etc/freeradius-web/config.php');`
5	`require('../lib/functions.php');`	5	`require('../lib/functions.php');`
6	`require('../lib/sql/nas_list.php');`	6	`require('../lib/sql/nas_list.php');`
7	`require_once('../lib/xlat.php');`	7	`require_once('../lib/xlat.php');`
8	`?>`	8	`?>`
9	`<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">`	9	`<!DOCTYPE html>`
10	`<html>`	10	`<html>`
11	`<?php`	11	`<?php`
12	`if (is_file("../lib/sql/drivers/$config[sql_type]/functions.php"))`	12	`if (is_file("../lib/sql/drivers/$config[sql_type]/functions.php"))`
13	`include_once("../lib/sql/drivers/$config[sql_type]/functions.php");`	13	`include_once("../lib/sql/drivers/$config[sql_type]/functions.php");`
14	`else{`	14	`else{`
15	`echo <<<EOM`	15	`echo <<<EOM`
16	`<title>Statistiques utilisateurs</title>`	16	`<title>Statistiques utilisateurs</title>`
17	`<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]">`
18	`<link rel="stylesheet" href="/css/acc.css">`	18	`<link rel="stylesheet" href="/css/acc.css">`
19	`</head>`	19	`</head>`
20	`<body>`	20	`<body>`
21	`<center>`	21	`<center>`
22	`<b>Could not include SQL library functions. Aborting</b>`	22	`<b>Could not include SQL library functions. Aborting</b>`
23	`</body>`	23	`</body>`
24	`</html>`	24	`</html>`
25	`EOM;`	25	`EOM;`
26	`exit();`	26	`exit();`
27	`}`	27	`}`
28	`# Choice of language`	28	`# Choice of language`
29	`$Language = 'en';`	29	`$Language = 'en';`
30	`if(isset($_SERVER['HTTP_ACCEPT_LANGUAGE'])){`	30	`if(isset($_SERVER['HTTP_ACCEPT_LANGUAGE'])){`
31	`$Langue = explode(",",$_SERVER['HTTP_ACCEPT_LANGUAGE']);`	31	`$Langue = explode(",",$_SERVER['HTTP_ACCEPT_LANGUAGE']);`
32	`$Language = strtolower(substr(chop($Langue[0]),0,2)); }`	32	`$Language = strtolower(substr(chop($Langue[0]),0,2)); }`
33	`if($Language == 'fr'){`	33	`if($Language == 'fr'){`
34	`$l_title = "Statistiques de connexion des utilisateurs";`	34	`$l_title = "Statistiques de connexion des utilisateurs";`
35	`$l_start_date = "Dates de début";`	35	`$l_start_date = "Dates de début";`
36	`$l_end_date = "Dates de fin";`	36	`$l_end_date = "Dates de fin";`
37	`$l_number_result = "Nb. résultat / page";`	37	`$l_number_result = "Nb. résultat / page";`
38	`$l_order_by = "Trié par";`	38	`$l_order_by = "Trié par";`
39	`$l_sorted_order = "Classé par ordre";`	39	`$l_sorted_order = "Classé par ordre";`
40	`$l_all = "Tous";`	40	`$l_all = "Tous";`
41	`$l_con_number = "Nombre de connexions";`	41	`$l_con_number = "Nombre de connexions";`
42	`$l_con_length = "Durée de connexions";`	42	`$l_con_length = "Durée de connexions";`
43	`$l_ascending = "Croissant";`	43	`$l_ascending = "Croissant";`
44	`$l_descending = "Décroissant";`	44	`$l_descending = "Décroissant";`
45	`$l_server = "Sur le serveur";`	45	`$l_server = "Sur le serveur";`
46	`$l_user = "Filtrer pour un utilisateur (laissez vide pour tous)";`	46	`$l_user = "Filtrer pour un utilisateur (laissez vide pour tous)";`
47	`$l_show = "Montrer";`	47	`$l_show = "Montrer";`
48	`$l_from = "Du";`	48	`$l_from = "Du";`
49	`$l_to = "au";`	49	`$l_to = "au";`
50	`$l_server = "Serveur";`	50	`$l_server = "Serveur";`
51	`$l_login = "Identifiant";`	51	`$l_login = "Identifiant";`
52	`$l_user_edit = "Éditer l'utilisateur";`	52	`$l_user_edit = "Éditer l'utilisateur";`
-		53	`} else if($Language == 'es') {`
-		54	`$l_title = "Estadísticas de conexiones de los Usuarios";`
-		55	`$l_start_date = "Desde fecha";`
-		56	`$l_end_date = "Hasta fecha";`
-		57	`$l_number_result = "Nro de resultados / páginas";`
-		58	`$l_order_by = "Ordenados por";`
-		59	`$l_sorted_order = "Ordenar resultados";`
-		60	`$l_all = "Todos";`
-		61	`$l_con_number = "Números de conexiones";`
-		62	`$l_con_length = "Duración de la conexión";`
-		63	`$l_ascending = "Ascendente";`
-		64	`$l_descending = "Descendente";`
-		65	`$l_server = "En el servidor";`
-		66	`$l_user = "Filtrar por usuario (en blanco para todos los usuarios)";`
-		67	`$l_show = "Mostrar";`
-		68	`$l_from = "Desde";`
-		69	`$l_to = "hasta";`
-		70	`$l_server = "Servidor";`
-		71	`$l_login = "Usuario";`
-		72	`$l_user_edit = "Modificar usuario";`
53	`} else {`	73	`} else {`
54	`$l_title = "Statistics of users connexions";`	74	`$l_title = "Statistics of users connexions";`
55	`$l_start_date = "Start date";`	75	`$l_start_date = "Start date";`
56	`$l_end_date = "End date";`	76	`$l_end_date = "End date";`
57	`$l_number_result = "Nb results / page";`	77	`$l_number_result = "Nb results / page";`
58	`$l_order_by = "Sorted by";`	78	`$l_order_by = "Sorted by";`
59	`$l_sorted_order = "Sorted order";`	79	`$l_sorted_order = "Sorted order";`
60	`$l_all = "All";`	80	`$l_all = "All";`
61	`$l_con_number = "Connections number";`	81	`$l_con_number = "Connections number";`
62	`$l_con_length = "Connection length";`	82	`$l_con_length = "Connection length";`
63	`$l_ascending = "Ascending";`	83	`$l_ascending = "Ascending";`
64	`$l_descending = "Descending";`	84	`$l_descending = "Descending";`
65	`$l_server = "On server";`	85	`$l_server = "On server";`
66	`$l_user = "Filter for a user (let empty for all)";`	86	`$l_user = "Filter for a user (let empty for all)";`
67	`$l_show = "Show";`	87	`$l_show = "Show";`
68	`$l_from = "From";`	88	`$l_from = "From";`
69	`$l_to = "to";`	89	`$l_to = "to";`
70	`$l_server = "Server";`	90	`$l_server = "Server";`
71	`$l_login = "Login";`	91	`$l_login = "Login";`
72	`$l_user_edit = "Edit user";`	92	`$l_user_edit = "Edit user";`
73	`}`	93	`}`
74	`if (!isset($start) && !isset($stop)){`	94	`if (!isset($start) && !isset($stop)){`
75	`$now = time();`	95	`$now = time();`
76	`$stop = date($config['sql_date_format'],$now);`	96	`$stop = date($config['sql_date_format'],$now);`
77	`$now -= 604800;`	97	`$now -= 604800;`
78	`$start = date($config['sql_date_format'],$now);`	98	`$start = date($config['sql_date_format'],$now);`
79	`}`	99	`}`
80	`$start = da_sql_escape_string($link,$start);`	100	`$start = da_sql_escape_string($link,$start);`
81	`$stop = da_sql_escape_string($link,$stop);`	101	`$stop = da_sql_escape_string($link,$stop);`
82	`?>`	102	`?>`
83	`<head>`	103	`<head>`
84	`<title><?php echo "$l_title";?></title>`	104	`<title><?php echo "$l_title";?></title>`
85	`<link rel="stylesheet" href="/css/acc.css" type="text/css">`	105	`<link rel="stylesheet" href="/css/acc.css" type="text/css">`
86	`</head>`	106	`</head>`
87	`<body>`	107	`<body>`
88	`<center>`	108	`<div class="panel">`
-		109	`<div class="panel-header"><?= $l_title ?></div>`
-		110	`<div class="panel-row">`
89	`<table width="100%" border="0" cellspacing="0" cellpadding="0">`	111	`<table width="100%" border="0" cellspacing="0" cellpadding="0">`
90	`<tr><th>`	-
91	`<font color="white"><?echo "$l_title";?></font>`	-
92	`</th></tr>`	-
93	`<tr bgcolor="#FFCC66"><td><img src="/images/pix.gif" width="1" height="2"></td></tr>`	-
94	`</table>`	-
95	`<table width="100%" border="1" cellspacing="0" cellpadding="0">`	-
96	`<?php`	112	`<?php`
97	`if(isset($pagesize))`	113	`if(isset($pagesize))`
98	`{`	114	`{`
99	`echo <<<EOM`	115	`echo <<<EOM`
100	`<tr align="center"><td colspan="9">`	116	`<tr align="center"><td colspan="9">`
101	`$l_from $start $l_to $stop`	117	`$l_from $start $l_to $stop`
102	`</td></tr>`	118	`</td></tr>`
103	`<tr>`	119	`<tr>`
104	`<th>#</th><th>$l_login</th><th>Date</th><th>$l_server</th><th>$l_con_number</th><th>$l_con_length</th><th>Upload</th><th>Download</th>`	120	`<th>#</th><th>$l_login</th><th>Date</th><th>$l_server</th><th>$l_con_number</th><th>$l_con_length</th><th>Upload</th><th>Download</th>`
105	`</tr>`	121	`</tr>`
106	`EOM;`	122	`EOM;`
107	`$pagesize = ($pagesize) ? $pagesize : 10;`	123	`$pagesize = ($pagesize) ? $pagesize : 10;`
108	`$selected[5] = "";`	124	`$selected[5] = "";`
109	`$selected[10] = "";`	125	`$selected[10] = "";`
110	`$selected[15] = "";`	126	`$selected[15] = "";`
111	`$selected[20] = "";`	127	`$selected[20] = "";`
112	`$selected[40] = "";`	128	`$selected[40] = "";`
113	`$selected[80] = "";`	129	`$selected[80] = "";`
114	`$selected['all'] = "";`	130	`$selected['all'] = "";`
115	`$selected['num'] = "";`	131	`$selected['num'] = "";`
116	`$selected['time'] = "";`	132	`$selected['time'] = "";`
117	`$selected['asc'] = "";`	133	`$selected['asc'] = "";`
118	`$selected['desc'] = "";`	134	`$selected['desc'] = "";`
119	`if (!is_numeric($pagesize) && $pagesize != 'all')`	135	`if (!is_numeric($pagesize) && $pagesize != 'all')`
120	`$pagezise = 10;`	136	`$pagezise = 10;`
121	`if ($pagesize > 100)`	137	`if ($pagesize > 100)`
122	`$pagesize = 100;`	138	`$pagesize = 100;`
123	`$limit = ($pagesize == 'all') ? '100' : "$pagesize";`	139	`$limit = ($pagesize == 'all') ? '100' : "$pagesize";`
124	`$selected[$pagesize] = 'selected';`	140	`$selected[$pagesize] = 'selected';`
125	`$order = ($order) ? $order : $config['general_accounting_info_order'];`	141	`$order = ($order) ? $order : $config['general_accounting_info_order'];`
126	`if ($order != 'desc' && $order != 'asc')`	142	`if ($order != 'desc' && $order != 'asc')`
127	`$order = 'desc';`	143	`$order = 'desc';`
128	`if ($sortby != '')`	144	`if ($sortby != '')`
129	`$order_attr = ($sortby == 'num') ? 'connnum' : 'conntotduration';`	145	`$order_attr = ($sortby == 'num') ? 'connnum' : 'conntotduration';`
130	`else`	146	`else`
131	`$order_attr = 'connnum';`	147	`$order_attr = 'connnum';`
132	`if ($server != '' && $server != 'all'){`	148	`if ($server != '' && $server != 'all'){`
133	`$server = da_sql_escape_string($link,$server);`	149	`$server = da_sql_escape_string($link,$server);`
134	`$server_str = "AND nasipaddress = '$server'";`	150	`$server_str = "AND nasipaddress = '$server'";`
135	`}`	151	`}`
136	`else`	152	`else`
137	`{`	153	`{`
138	`$server_str = "";`	154	`$server_str = "";`
139	`}`	155	`}`
140	`$login_str = ($login) ? "AND username = '$login' " : '';`	156	`$login_str = ($login) ? "AND username = '$login' " : '';`
141	`$selected[$order] = 'selected';`	157	`$selected[$order] = 'selected';`
142	`$selected[$sortby] = 'selected';`	158	`$selected[$sortby] = 'selected';`
143	`$sql_extra_query = '';`	159	`$sql_extra_query = '';`
144	`if (isset($config['sql_accounting_extra_query'])){`	160	`if (isset($config['sql_accounting_extra_query'])){`
145	`$sql_extra_query = xlat($config['sql_accounting_extra_query'],$login,$config);`	161	`$sql_extra_query = xlat($config['sql_accounting_extra_query'],$login,$config);`
146	`$sql_extra_query = da_sql_escape_string($link,$sql_extra_query);`	162	`$sql_extra_query = da_sql_escape_string($link,$sql_extra_query);`
147	`}`	163	`}`
148	`unset($da_name_cache);`	164	`unset($da_name_cache);`
149	`if (isset($_SESSION['da_name_cache']))`	165	`if (isset($_SESSION['da_name_cache']))`
150	`$da_name_cache = $_SESSION['da_name_cache'];`	166	`$da_name_cache = $_SESSION['da_name_cache'];`
151	`$link = @da_sql_pconnect($config);`	167	`$link = @da_sql_pconnect($config);`
152	`if ($link){`	168	`if ($link){`
153	`$num = 0;`	169	`$num = 0;`
154	`$search = @da_sql_query($link,$config,`	170	`$search = @da_sql_query($link,$config,`
155	`"SELECT " . da_sql_limit($limit,0,$config) . " * FROM $config[sql_total_accounting_table]`	171	`"SELECT " . da_sql_limit($limit,0,$config) . " * FROM $config[sql_total_accounting_table]`
156	`WHERE acctdate >= '$start' AND acctdate <= '$stop' $server_str $login_str $sql_extra_query " . da_sql_limit($limit,1,$config)`	172	`WHERE acctdate >= '$start' AND acctdate <= '$stop' $server_str $login_str $sql_extra_query " . da_sql_limit($limit,1,$config)`
157	`. " ORDER BY $order_attr $order " . da_sql_limit($limit,2,$config) . " ;");`	173	`. " ORDER BY $order_attr $order " . da_sql_limit($limit,2,$config) . " ;");`
158	`if ($search){`	174	`if ($search){`
159	`while( $row = @da_sql_fetch_array($search,$config) ){`	175	`while( $row = @da_sql_fetch_array($search,$config) ){`
160	`$num++;`	176	`$num++;`
161	`$acct_login = $row['username'];`	177	`$acct_login = $row['username'];`
162	`if ($acct_login == '')`	178	`if ($acct_login == '')`
163	`$acct_login = '-';`	179	`$acct_login = '-';`
164	`else{`	180	`else{`
165	`$Acct_login = urlencode($acct_login);`	181	`$Acct_login = urlencode($acct_login);`
166	`$acct_login = "<a href=\"user_admin.php?login=$Acct_login\" title=\"$l_user_edit $acct_login\">$acct_login</a>";`	182	`$acct_login = "<a href=\"user_admin.php?login=$Acct_login\" title=\"$l_user_edit $acct_login\">$acct_login</a>";`
167	`}`	183	`}`
168	`$acct_time = $row['conntotduration'];`	184	`$acct_time = $row['conntotduration'];`
169	`$acct_time = time2str($acct_time);`	185	`$acct_time = time2str($acct_time);`
170	`$acct_conn_num = $row['connnum'];`	186	`$acct_conn_num = $row['connnum'];`
171	`$acct_date = $row['acctdate'];`	187	`$acct_date = $row['acctdate'];`
172	`$acct_upload = $row['inputoctets'];`	188	`$acct_upload = $row['inputoctets'];`
173	`$acct_download = $row['outputoctets'];`	189	`$acct_download = $row['outputoctets'];`
174	`$acct_upload = bytes2str($acct_upload);`	190	`$acct_upload = bytes2str($acct_upload);`
175	`$acct_download = bytes2str($acct_download);`	191	`$acct_download = bytes2str($acct_download);`
176	`if (!isset($acct_server)){`	192	`if (!isset($acct_server)){`
177	`$acct_server = @gethostbyaddr($row['nasipaddress']);`	193	`$acct_server = @gethostbyaddr($row['nasipaddress']);`
178	`if (!isset($da_name_cache) && $config['general_use_session'] == 'yes'){`	194	`if (!isset($da_name_cache) && $config['general_use_session'] == 'yes'){`
179	`$da_name_cache[$row['nasipaddress']] = $acct_server;`	195	`$da_name_cache[$row['nasipaddress']] = $acct_server;`
180	`session_register('da_name_cache');`	196	`session_register('da_name_cache');`
181	`}`	197	`}`
182	`else`	198	`else`
183	`$da_name_cache[$row['nasipaddress']] = $acct_server;`	199	`$da_name_cache[$row['nasipaddress']] = $acct_server;`
184	`}`	200	`}`
185	`if ($acct_server == '')`	201	`if ($acct_server == '')`
186	`$acct_server = '-';`	202	`$acct_server = '-';`
187	`echo <<<EOM`	203	`echo <<<EOM`
188	`<tr align=center bgcolor="white">`	204	`<tr align=center bgcolor="white">`
189	`<td>$num</td>`	205	`<td>$num</td>`
190	`<td>$acct_login</td>`	206	`<td>$acct_login</td>`
191	`<td>$acct_date</td>`	207	`<td>$acct_date</td>`
192	`<td>$acct_server</td>`	208	`<td>$acct_server</td>`
193	`<td>$acct_conn_num</td>`	209	`<td>$acct_conn_num</td>`
194	`<td>$acct_time</td>`	210	`<td>$acct_time</td>`
195	`<td>$acct_upload</td>`	211	`<td>$acct_upload</td>`
196	`<td>$acct_download</td>`	212	`<td>$acct_download</td>`
197	`</tr>`	213	`</tr>`
198	`EOM;`	214	`EOM;`
199	`}`	215	`}`
200	`}`	216	`}`
201	`}`	217	`}`
202	`echo <<<EOM`	218	`echo <<<EOM`
203	`</table>`	219	`</table>`
204	`<hr>`	220	`<hr>`
205	`<table width="100%" border="1" cellspacing="0" cellpadding="0">`	221	`<table width="100%" border="0" cellspacing="0" cellpadding="0">`
206	`EOM;`	222	`EOM;`
207	`}`	223	`}`
208	`else`	224	`else`
209	`{`	225	`{`
210	`//create dummy selected`	226	`//create dummy selected`
211	`if(!isset($selected))`	227	`if(!isset($selected))`
212	`{`	228	`{`
213	`$selected = array();`	229	`$selected = array();`
214	`$selected[5] = "";`	230	`$selected[5] = "";`
215	`$selected[10] = "";`	231	`$selected[10] = "";`
216	`$selected[15] = "";`	232	`$selected[15] = "";`
217	`$selected[20] = "";`	233	`$selected[20] = "";`
218	`$selected[40] = "";`	234	`$selected[40] = "";`
219	`$selected[80] = "";`	235	`$selected[80] = "";`
220	`$selected['all'] = "";`	236	`$selected['all'] = "";`
221	`$selected['num'] = "";`	237	`$selected['num'] = "";`
222	`$selected['time'] = "";`	238	`$selected['time'] = "";`
223	`$selected['asc'] = "";`	239	`$selected['asc'] = "";`
224	`$selected['desc'] = "";`	240	`$selected['desc'] = "";`
225	`}`	241	`}`
226		242
227		243
228	`}`	244	`}`
229	`echo <<<EOM`	245	`echo <<<EOM`
230	`<tr><td align="left">`	246	`<tr><td align="left">`
231	`<form action="user_stats.php" method="post" name="master">`	247	`<form action="user_stats.php" method="post" name="master">`
232	`<table border="0">`	248	`<table border="0">`
233	`<tr valign="bottom" align="center">`	249	`<tr valign="bottom" align="center">`
234	`<td><small><b>$l_start_date</b></small></td><td><small><b>$l_end_date</b></small></td><td><small><b>$l_number_result</b></small></td><td><small><b>$l_order_by</b></small></td><td><small><b>$l_sorted_order</b></small></td></tr>`	250	`<td><small><b>$l_start_date</b></small></td><td><small><b>$l_end_date</b></small></td><td><small><b>$l_number_result</b></small></td><td><small><b>$l_order_by</b></small></td><td><small><b>$l_sorted_order</b></small></td></tr>`
235	`<tr valign="middle"><td>`	251	`<tr valign="middle"><td>`
236	`<input type="hidden" name="show" value="0">`	252	`<input type="hidden" name="show" value="0">`
237	`<input type="text" name="start" size="11" value="$start"></td>`	253	`<input type="text" name="start" size="11" value="$start"></td>`
238	`<td><input type="text" name="stop" size="11" value="$stop"></td>`	254	`<td><input type="text" name="stop" size="11" value="$stop"></td>`
239	`<td><select name="pagesize">`	255	`<td><select name="pagesize">`
240	`<option $selected[5] value="5" >5`	256	`<option $selected[5] value="5" >5`
241	`<option $selected[10] value="10">10`	257	`<option $selected[10] value="10">10`
242	`<option $selected[15] value="15">15`	258	`<option $selected[15] value="15">15`
243	`<option $selected[20] value="20">20`	259	`<option $selected[20] value="20">20`
244	`<option $selected[40] value="40">40`	260	`<option $selected[40] value="40">40`
245	`<option $selected[80] value="80">80`	261	`<option $selected[80] value="80">80`
246	`<option $selected[all] value="all">$l_all`	262	`<option $selected[all] value="all">$l_all`
247	`</select>`	263	`</select>`
248	`</td>`	264	`</td>`
249	`<td>`	265	`<td>`
250	`<select name="sortby">`	266	`<select name="sortby">`
251	`<option $selected[num] value="num">$l_con_number`	267	`<option $selected[num] value="num">$l_con_number`
252	`<option $selected[time] value="time">$l_con_length`	268	`<option $selected[time] value="time">$l_con_length`
253	`</select>`	269	`</select>`
254	`</td>`	270	`</td>`
255	`<td><select name="order">`	271	`<td><select name="order">`
256	`<option $selected[asc] value="asc">$l_ascending`	272	`<option $selected[asc] value="asc">$l_ascending`
257	`<option $selected[desc] value="desc">$l_descending`	273	`<option $selected[desc] value="desc">$l_descending`
258	`</select>`	274	`</select>`
259	`</td>`	275	`</td>`
260	`EOM;`	276	`EOM;`
261	`?>`	277	`?>`
262	`<td><input type="submit" class=button value="<?php echo "$l_show";?>"></td>`	278	`<td><input type="submit" class=button value="<?php echo "$l_show";?>"></td>`
263	`</tr>`	279	`</tr>`
264	`<tr align="center">`	280	`<tr align="center">`
265	`<td><small><b><?php echo "$l_server";?></b></small></td>`	281	`<td><small><b><?php echo "$l_server";?></b></small></td>`
266	`<td><small><b><?php echo "$l_user";?></b></small></td>`	282	`<td><small><b><?php echo "$l_user";?></b></small></td>`
267	`</tr>`	283	`</tr>`
268	`<tr><td>`	284	`<tr><td>`
269	`<select name="server">`	285	`<select name="server">`
270	`<?php`	286	`<?php`
271	`foreach ($nas_list as $nas){`	287	`foreach ($nas_list as $nas){`
272	`$name = $nas['name'];`	288	`$name = $nas['name'];`
273	`if ($nas['ip'] == '')`	289	`if ($nas['ip'] == '')`
274	`continue;`	290	`continue;`
275	`$servers[$name] = $nas['ip'];`	291	`$servers[$name] = $nas['ip'];`
276	`}`	292	`}`
277	`ksort($servers);`	293	`ksort($servers);`
278	`foreach ($servers as $name => $ip){`	294	`foreach ($servers as $name => $ip){`
279	`if (isset($server) && ($server == $ip))`	295	`if (isset($server) && ($server == $ip))`
280	`echo "<option selected value=\"$ip\">$name\n";`	296	`echo "<option selected value=\"$ip\">$name\n";`
281	`else`	297	`else`
282	`echo "<option value=\"$ip\">$name\n";`	298	`echo "<option value=\"$ip\">$name\n";`
283	`}`	299	`}`
284	`if (isset($server) && ($server == '' \|\| $server == 'all'))`	300	`if (isset($server) && ($server == '' \|\| $server == 'all'))`
285	`echo "<option selected value=\"all\">tous\n";`	301	`echo "<option selected value=\"all\">tous\n";`
286	`else`	302	`else`
287	`echo "<option value=\"all\">tous\n";`	303	`echo "<option value=\"all\">tous\n";`
288	`?>`	304	`?>`
289	`</select>`	305	`</select>`
290	`</td>`	306	`</td>`
291	`<td><input type="text" name="login" size="11" value="<?php if(!isset($login)){echo "";}else{ echo $login;} ?>"></td>`	307	`<td><input type="text" name="login" size="11" value="<?php if(!isset($login)){echo "";}else{ echo $login;} ?>"></td>`
292	`</tr>`	308	`</tr>`
293	`</table>`	309	`</table>`
294	`</form>`	310	`</form>`
295	`</td></tr></table>`	311	`</td></tr></table>`
-		312	`</div>`
-		313	`</div>`
296	`</body>`	314	`</body>`
297	`</html>`	315	`</html>`
298		316

Subversion Repositories ALCASAR

(root)/web/acc/manager/htdocs/user_stats.php @ 2347 – Rev 2817 → 2854