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


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

Subversion Repositories ALCASAR

(root)/web/acc/manager/htdocs/user_stats.php – Rev 2854 → 2856