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


<?php
//gestion de la langue
$origine='user_accounting';
if (is_file("../lib/langues.php"))
	include("../lib/langues.php");
require('/etc/freeradius-web/config.php');
 
 
 
require('../lib/functions.php');
require('../lib/sql/functions.php');
require('../lib/attrshow.php');
if (is_file("../lib/$config[general_lib_type]/user_info.php"))
	include("../lib/$config[general_lib_type]/user_info.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
<html>
<head>
<title>$l_title</title>
<meta http-equiv="Content-Type" content="text/html; charset=$config[general_charset]">
<link rel="stylesheet" href="/css/style.css">
</head>
<body>
<center>
<b>Could not include SQL library functions. Aborting</b>
</body>
</html>
EOM;
	exit();
}
 
$now = time();
$now_str = ($now_str != '') ? "$now_str" : date($config[sql_date_format],$now + 86400);
$prev_str = ($prev_str != '') ? "$prev_str" : date($config[sql_date_format], $now - 604800 );
$num = 0;
$pagesize = ($pagesize) ? $pagesize : 10;
if (!is_numeric($pagesize) && $pagesize != 'all')
	$pagesize = 10;
$limit = ($pagesize == 'all') ? '' : "$pagesize";
$selected[$pagesize] = 'selected';
$order = ($order != '') ? $order : $config[general_accounting_info_order];
if ($order != 'desc' && $order != 'asc')
	$order = 'desc';
$selected[$order] = 'selected';
$now_str = mysql_escape_string($now_str);
$prev_str = mysql_escape_string($prev_str);
//$now_str = da_sql_escape_string($now_str);
//$prev_str = da_sql_escape_string($prev_str);
 
unset($da_name_cache);
if (isset($_SESSION['da_name_cache']))
	$da_name_cache = $_SESSION['da_name_cache'];
 
 
echo <<<EOM
<html>
<head>
<title>i$l_title</title>
<meta http-equiv="Content-Type" content="text/html; charset=$config[general_charset]">
<link rel="stylesheet" href="/css/style.css">
</head>
<body>
<TABLE width="100%" border="0" cellspacing="0" cellpadding="0">
<tr><th>$l_frame_top</th></tr>
<tr bgcolor="#FFCC66"><td><img src="/images/pix.gif" width="1" 
height="2"></td></tr>
</TABLE>
<TABLE width="100%" border=0 cellspacing=0 cellpadding=1>
<tr bgcolor="#666666"><td>
<TABLE width="100%" border=0 cellspacing=0 cellpadding=2>
<tr><td valign="middle" align="left">
<center>
 
 
 
 
 
<table border=0 width=400 cellpadding=0 cellspacing=2>
EOM;
 
include("../html/user_toolbar.html.php");
 
print <<<EOM
</table>
<br>
<table border=0 width=840 cellpadding=1 cellspacing=1>
<tr valign=top>
<td width=65%></td>
<td bgcolor="black" width=35%>
	<table border=0 width=100% cellpadding=2 cellspacing=0>
	<tr bgcolor="#907030" align=right valign=top><th>
	<font color="white">$l_user : $login ($cn)</font>
	</th></tr>
	</table>
</td></tr>
<tr bgcolor="black" valign=top><td colspan=2>
	<table border=0 width=100% cellpadding=12 cellspacing=0 bgcolor="#ffffd0" valign=top>
	<tr><td>
Dates : <b>$prev_str</b> to <b>$now_str</b>
EOM;
?>
 
<p>
	<table border=1 bordercolordark=#ffffe0 bordercolorlight=#000000 width=100% cellpadding=2 cellspacing=0 bgcolor="#ffffe0" valign=top>
	<tr bgcolor="#d0ddb0">
	<td><b>#</b></td>
<?php
for($i=1;$i<=9;$i++){
	if (($acct_attrs['ua']["$i"] != '') && ($acct_attrs['ua']["$i"] != 'server') && ($acct_attrs['ua']["$i"] != 'callerid'))
		echo "<td><b>" . $acct_attrs['ua']["$i"] . "</b></td>\n";
}
$sql_extra_query = '';
if ($config[sql_accounting_extra_query] != '')
	$sql_extra_query = xlat($config[sql_accounting_extra_query],$login,$config);
?>
	</tr>
 
<?php
$link = @da_sql_pconnect($config);
if ($link){
	$search = @da_sql_query($link,$config,
	"SELECT " . da_sql_limit($limit,0,$config) . " * FROM $config[sql_accounting_table]
	WHERE username = '$login' AND acctstarttime <= '$now_str'
	AND acctstarttime >= '$prev_str' $sql_extra_query " . da_sql_limit($limit,1,$config) .
	" ORDER BY acctstarttime $order " . da_sql_limit($limit,2,$config). " ;");
	if ($search){
		while( $row = @da_sql_fetch_array($search,$config) ){
 
			$num++;
			$acct_type = "$row[framedprotocol]/$row[nasporttype]";
			if ($acct_type == '')
				$acct_type = '-';
			$acct_logedin = $row[acctstarttime];
			$acct_sessiontime = $row[acctsessiontime];
			$acct_sessiontime_sum += $acct_sessiontime;
			$acct_sessiontime = time2str($acct_sessiontime);
			$acct_ip = $row[framedipaddress];
			if ($acct_ip == '')
				$acct_ip = '-';
			$acct_upload = $row[acctinputoctets];
			$acct_upload_sum += $acct_upload;
			$acct_upload = bytes2str($acct_upload);
			$acct_download = $row[acctoutputoctets];
			$acct_download_sum += $acct_download;
			$acct_download = bytes2str($acct_download);
			$acct_server = $row[nasipaddress];
			if ($acct_server != ''){
				$acct_server = $da_name_cache[$row[nasipaddress]];
				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;
				}
			}
			else
				$acct_server = '-';
			$acct_server = "$acct_server:$row[nasportid]";
			$acct_terminate_cause = "$row[acctterminatecause]";
			if ($acct_terminate_cause == '')
				$acct_terminate_cause = '-';
			if (ereg('Login-Incorrect',$acct_terminate_cause) ||
				ereg('Multiple-Logins', $acct_terminate_cause) || ereg('Invalid-User',$acct_terminate_cause))
 
			$acct_callerid = "$row[callingstationid]";
			if ($acct_callerid == '')
				$acct_callerid = '-';
			echo <<<EOM
			<tr align=center>
				<td>$num</td>
EOM;
				if ($acct_attrs[ua][1] != '') echo "<td>$acct_type</td>\n";
				if ($acct_attrs[ua][2] != '') echo "<td>$acct_logedin</td>\n";
				if ($acct_attrs[ua][3] != '') echo "<td>$acct_sessiontime</td>\n";
				if ($acct_attrs[ua][4] != '') echo "<td>$acct_ip</td>\n";
				if ($acct_attrs[ua][5] != '') echo "<td>$acct_upload</td>\n";
				if ($acct_attrs[ua][6] != '') echo "<td>$acct_download</td>\n";
//				if ($acct_attrs[ua][7] != '') echo "<td>$acct_server</td>\n";
				if ($acct_attrs[ua][8] != '') echo "<td>$acct_terminate_cause</td>\n";
//				if ($acct_attrs[ua][9] != '') echo "<td>$acct_callerid</td>\n";
			echo "</tr>\n";
		}
		$acct_sessiontime_sum = time2str($acct_sessiontime_sum);
		$acct_upload_sum = bytes2str($acct_upload_sum);
		$acct_download_sum = bytes2str($acct_download_sum);
	}
	else
		echo "<b>Database query failed: " . da_sql_error($link,$config) . "</b><br>\n";
}
else
	echo "<b>Could not connect to SQL database</b><br>\n";
$colspan = 3;
if ($acct_attrs[ua][1] == '')
	$colspan--;
if ($acct_attrs[ua][2] == '')
	$colspan--;
echo <<<EOM
			<tr bgcolor="lightyellow" align="center">
			<td colspan=$colspan><b>Total</b></td>
EOM;
				if ($acct_attrs[ua][3] != '') echo "<td><b>$acct_sessiontime_sum</td>\n";
				if ($acct_attrs[ua][4] != '') echo "<td>&nbsp;</td>\n";
				if ($acct_attrs[ua][5] != '') echo "<td><b>$acct_upload_sum</td>\n";
				if ($acct_attrs[ua][6] != '') echo "<td><b>$acct_download_sum</td>\n";
//				if ($acct_attrs[ua][7] != '') echo "<td>&nbsp;</td>\n";
				if ($acct_attrs[ua][8] != '') echo "<td>&nbsp;</td>\n";
//				if ($acct_attrs[ua][9] != '') echo "<td>&nbsp;</td>\n";
?>
				</tr>
	</table>
<tr><td>
<hr>
<tr><td align="center">
	<form action="user_accounting.php" method="get" name="master">
	<table border=0>
		<tr><td colspan=6></td>
		</tr>
		<tr valign="bottom">
		<td><small><b><?php echo "$l_user";?></td><td><small><b>from</td><td><small><b>to</td><td><small><b>nbr./page</td><td><b>order</td>
	<tr valign="middle"><td>
<?php
	echo <<<EOM
<input type="text" name="login" size="11" value="$login"></td>
<td><input type="text" name="prev_str" size="11" value="$prev_str"></td>
<td><input type="text" name="now_str" size="11" value="$now_str"></td>
<td><select name="pagesize">
<option $selected[5] value="5" >05
<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="order">
<option $selected[asc] value="asc">older first
<option $selected[desc] value="desc">recent first
</select>
</td>
EOM;
?>
 
<td><input type="submit" class=button value="show"></td></tr>
</table></td></tr></form>
</table>
</tr>
</table>
</TD></TR>
</TABLE>
</td></tr>
</TABLE>
</body>
</html>
 

Rev 820	Rev 910
1	`<?php`	1	`<?php`
-		2	`//gestion de la langue`
-		3	`$origine='user_accounting';`
-		4	`if (is_file("../lib/langues.php"))`
-		5	`include("../lib/langues.php");`
2	`require('/etc/freeradius-web/config.php');`	6	`require('/etc/freeradius-web/config.php');`
3	`?>`	-
4	`<html>`	-
5	`<?php`	-
6	`require('../lib/functions.php');`	7	`require('../lib/functions.php');`
7	`require('../lib/sql/functions.php');`	8	`require('../lib/sql/functions.php');`
8	`require('../lib/attrshow.php');`	9	`require('../lib/attrshow.php');`
-		10	`if (is_file("../lib/$config[general_lib_type]/user_info.php"))`
-		11	`include("../lib/$config[general_lib_type]/user_info.php");`
9		12
10	`if (is_file("../lib/sql/drivers/$config[sql_type]/functions.php"))`	13	`if (is_file("../lib/sql/drivers/$config[sql_type]/functions.php"))`
11	`include_once("../lib/sql/drivers/$config[sql_type]/functions.php");`	14	`include_once("../lib/sql/drivers/$config[sql_type]/functions.php");`
12	`else{`	15	`else{`
13	`echo <<<EOM`	16	`echo <<<EOM`
-		17	`<html>`
-		18	`<head>`
14	`<title>Analyse pour $login</title>`	19	`<title>$l_title</title>`
15	`<meta http-equiv="Content-Type" content="text/html; charset=$config[general_charset]">`	20	`<meta http-equiv="Content-Type" content="text/html; charset=$config[general_charset]">`
16	`<link rel="stylesheet" href="style.css">`	21	`<link rel="stylesheet" href="/css/style.css">`
17	`</head>`	22	`</head>`
18	`<body>`	23	`<body>`
19	`<center>`	24	`<center>`
20	`<b>Could not include SQL library functions. Aborting</b>`	25	`<b>Could not include SQL library functions. Aborting</b>`
21	`</body>`	26	`</body>`
22	`</html>`	27	`</html>`
23	`EOM;`	28	`EOM;`
24	`exit();`	29	`exit();`
25	`}`	30	`}`
26		31
27	`$now = time();`	32	`$now = time();`
28	`$now_str = ($now_str != '') ? "$now_str" : date($config[sql_date_format],$now + 86400);`	33	`$now_str = ($now_str != '') ? "$now_str" : date($config[sql_date_format],$now + 86400);`
29	`$prev_str = ($prev_str != '') ? "$prev_str" : date($config[sql_date_format], $now - 604800 );`	34	`$prev_str = ($prev_str != '') ? "$prev_str" : date($config[sql_date_format], $now - 604800 );`
30	`$num = 0;`	35	`$num = 0;`
31	`$pagesize = ($pagesize) ? $pagesize : 10;`	36	`$pagesize = ($pagesize) ? $pagesize : 10;`
32	`if (!is_numeric($pagesize) && $pagesize != 'all')`	37	`if (!is_numeric($pagesize) && $pagesize != 'all')`
33	`$pagesize = 10;`	38	`$pagesize = 10;`
34	`$limit = ($pagesize == 'all') ? '' : "$pagesize";`	39	`$limit = ($pagesize == 'all') ? '' : "$pagesize";`
35	`$selected[$pagesize] = 'selected';`	40	`$selected[$pagesize] = 'selected';`
36	`$order = ($order != '') ? $order : $config[general_accounting_info_order];`	41	`$order = ($order != '') ? $order : $config[general_accounting_info_order];`
37	`if ($order != 'desc' && $order != 'asc')`	42	`if ($order != 'desc' && $order != 'asc')`
38	`$order = 'desc';`	43	`$order = 'desc';`
39	`$selected[$order] = 'selected';`	44	`$selected[$order] = 'selected';`
40	`$now_str = mysql_escape_string($now_str);`	45	`$now_str = mysql_escape_string($now_str);`
41	`$prev_str = mysql_escape_string($prev_str);`	46	`$prev_str = mysql_escape_string($prev_str);`
42	`//$now_str = da_sql_escape_string($now_str);`	47	`//$now_str = da_sql_escape_string($now_str);`
43	`//$prev_str = da_sql_escape_string($prev_str);`	48	`//$prev_str = da_sql_escape_string($prev_str);`
44		49
45	`unset($da_name_cache);`	50	`unset($da_name_cache);`
46	`if (isset($_SESSION['da_name_cache']))`	51	`if (isset($_SESSION['da_name_cache']))`
47	`$da_name_cache = $_SESSION['da_name_cache'];`	52	`$da_name_cache = $_SESSION['da_name_cache'];`
48		53
49		54
50	`echo <<<EOM`	55	`echo <<<EOM`
-		56	`<html>`
51	`<head>`	57	`<head>`
52	`<title>Analyse pour $login</title>`	58	`<title>i$l_title</title>`
53	`<meta http-equiv="Content-Type" content="text/html; charset=$config[general_charset]">`	59	`<meta http-equiv="Content-Type" content="text/html; charset=$config[general_charset]">`
54	`<link rel="stylesheet" href="/css/style.css">`	60	`<link rel="stylesheet" href="/css/style.css">`
55	`</head>`	61	`</head>`
56	`<body>`	62	`<body>`
57	`<TABLE width="100%" border="0" cellspacing="0" cellpadding="0">`	63	`<TABLE width="100%" border="0" cellspacing="0" cellpadding="0">`
58	`<tr><th>Statistique des connexions</th></tr>`	64	`<tr><th>$l_frame_top</th></tr>`
59	`<tr bgcolor="#FFCC66"><td><img src="/images/pix.gif" width="1"`	65	`<tr bgcolor="#FFCC66"><td><img src="/images/pix.gif" width="1"`
60	`height="2"></td></tr>`	66	`height="2"></td></tr>`
61	`</TABLE>`	67	`</TABLE>`
62	`<TABLE width="100%" border=0 cellspacing=0 cellpadding=1>`	68	`<TABLE width="100%" border=0 cellspacing=0 cellpadding=1>`
63	`<tr bgcolor="#666666"><td>`	69	`<tr bgcolor="#666666"><td>`
64	`<TABLE width="100%" border=0 cellspacing=0 cellpadding=2>`	70	`<TABLE width="100%" border=0 cellspacing=0 cellpadding=2>`
65	`<tr><td valign="middle" align="left">`	71	`<tr><td valign="middle" align="left">`
66	`<center>`	72	`<center>`
67	`<table border=0 width=550 cellpadding=0 cellspacing=0>`	-
68	`<tr valign=top>`	-
69	`<!--<td align=center><img src="images/title2.gif"></td>-->`	-
70	`</tr>`	-
71	`</table>`	-
72	`<table border=0 width=400 cellpadding=0 cellspacing=2>`	73	`<table border=0 width=400 cellpadding=0 cellspacing=2>`
73	`EOM;`	74	`EOM;`
74		75
75	`include("../html/user_toolbar.html.php");`	76	`include("../html/user_toolbar.html.php");`
76		77
77	`print <<<EOM`	78	`print <<<EOM`
78	`</table>`	79	`</table>`
79	`<br>`	80	`<br>`
80	`<table border=0 width=840 cellpadding=1 cellspacing=1>`	81	`<table border=0 width=840 cellpadding=1 cellspacing=1>`
81	`<tr valign=top>`	82	`<tr valign=top>`
82	`<td width=65%></td>`	83	`<td width=65%></td>`
83	`<td bgcolor="black" width=35%>`	84	`<td bgcolor="black" width=35%>`
84	`<table border=0 width=100% cellpadding=2 cellspacing=0>`	85	`<table border=0 width=100% cellpadding=2 cellspacing=0>`
85	`<tr bgcolor="#907030" align=right valign=top><th>`	86	`<tr bgcolor="#907030" align=right valign=top><th>`
86	`<font color="white">Analyse pour $login</font> `	87	`<font color="white">$l_user : $login ($cn)</font>`
87	`</th></tr>`	88	`</th></tr>`
88	`</table>`	89	`</table>`
89	`</td></tr>`	90	`</td></tr>`
90	`<tr bgcolor="black" valign=top><td colspan=2>`	91	`<tr bgcolor="black" valign=top><td colspan=2>`
91	`<table border=0 width=100% cellpadding=12 cellspacing=0 bgcolor="#ffffd0" valign=top>`	92	`<table border=0 width=100% cellpadding=12 cellspacing=0 bgcolor="#ffffd0" valign=top>`
92	`<tr><td>`	93	`<tr><td>`
93	`Dates du <b>$prev_str</b> au <b>$now_str</b>`	94	`Dates : <b>$prev_str</b> to <b>$now_str</b>`
94	`EOM;`	95	`EOM;`
95	`?>`	96	`?>`
96		-
97	`<p>`	97	`<p>`
98	`<table border=1 bordercolordark=#ffffe0 bordercolorlight=#000000 width=100% cellpadding=2 cellspacing=0 bgcolor="#ffffe0" valign=top>`	98	`<table border=1 bordercolordark=#ffffe0 bordercolorlight=#000000 width=100% cellpadding=2 cellspacing=0 bgcolor="#ffffe0" valign=top>`
99	`<tr bgcolor="#d0ddb0">`	99	`<tr bgcolor="#d0ddb0">`
100	`<th>#</th>`	100	`<td><b>#</b></td>`
101	`<?php`	101	`<?php`
102	`for($i=1;$i<=9;$i++){`	102	`for($i=1;$i<=9;$i++){`
103	`if ($acct_attrs['ua']["$i"] != '')`	103	`if (($acct_attrs['ua']["$i"] != '') && ($acct_attrs['ua']["$i"] != 'server') && ($acct_attrs['ua']["$i"] != 'callerid'))`
104	`echo "<th>" . $acct_attrs['ua']["$i"] . "</th>\n";`	104	`echo "<td><b>" . $acct_attrs['ua']["$i"] . "</b></td>\n";`
105	`}`	105	`}`
106	`$sql_extra_query = '';`	106	`$sql_extra_query = '';`
107	`if ($config[sql_accounting_extra_query] != '')`	107	`if ($config[sql_accounting_extra_query] != '')`
108	`$sql_extra_query = xlat($config[sql_accounting_extra_query],$login,$config);`	108	`$sql_extra_query = xlat($config[sql_accounting_extra_query],$login,$config);`
109	`?>`	109	`?>`
110	`</tr>`	110	`</tr>`
111		111
112	`<?php`	112	`<?php`
113	`$link = @da_sql_pconnect($config);`	113	`$link = @da_sql_pconnect($config);`
114	`if ($link){`	114	`if ($link){`
115	`$search = @da_sql_query($link,$config,`	115	`$search = @da_sql_query($link,$config,`
116	`"SELECT " . da_sql_limit($limit,0,$config) . " * FROM $config[sql_accounting_table]`	116	`"SELECT " . da_sql_limit($limit,0,$config) . " * FROM $config[sql_accounting_table]`
117	`WHERE username = '$login' AND acctstarttime <= '$now_str'`	117	`WHERE username = '$login' AND acctstarttime <= '$now_str'`
118	`AND acctstarttime >= '$prev_str' $sql_extra_query " . da_sql_limit($limit,1,$config) .`	118	`AND acctstarttime >= '$prev_str' $sql_extra_query " . da_sql_limit($limit,1,$config) .`
119	`" ORDER BY acctstarttime $order " . da_sql_limit($limit,2,$config). " ;");`	119	`" ORDER BY acctstarttime $order " . da_sql_limit($limit,2,$config). " ;");`
120	`if ($search){`	120	`if ($search){`
121	`while( $row = @da_sql_fetch_array($search,$config) ){`	121	`while( $row = @da_sql_fetch_array($search,$config) ){`
122	`$tr_color='white';`	-
123	`$num++;`	122	`$num++;`
124	`$acct_type = "$row[framedprotocol]/$row[nasporttype]";`	123	`$acct_type = "$row[framedprotocol]/$row[nasporttype]";`
125	`if ($acct_type == '')`	124	`if ($acct_type == '')`
126	`$acct_type = '-';`	125	`$acct_type = '-';`
127	`$acct_logedin = $row[acctstarttime];`	126	`$acct_logedin = $row[acctstarttime];`
128	`$acct_sessiontime = $row[acctsessiontime];`	127	`$acct_sessiontime = $row[acctsessiontime];`
129	`$acct_sessiontime_sum += $acct_sessiontime;`	128	`$acct_sessiontime_sum += $acct_sessiontime;`
130	`$acct_sessiontime = time2str($acct_sessiontime);`	129	`$acct_sessiontime = time2str($acct_sessiontime);`
131	`$acct_ip = $row[framedipaddress];`	130	`$acct_ip = $row[framedipaddress];`
132	`if ($acct_ip == '')`	131	`if ($acct_ip == '')`
133	`$acct_ip = '-';`	132	`$acct_ip = '-';`
134	`$acct_upload = $row[acctinputoctets];`	133	`$acct_upload = $row[acctinputoctets];`
135	`$acct_upload_sum += $acct_upload;`	134	`$acct_upload_sum += $acct_upload;`
136	`$acct_upload = bytes2str($acct_upload);`	135	`$acct_upload = bytes2str($acct_upload);`
137	`$acct_download = $row[acctoutputoctets];`	136	`$acct_download = $row[acctoutputoctets];`
138	`$acct_download_sum += $acct_download;`	137	`$acct_download_sum += $acct_download;`
139	`$acct_download = bytes2str($acct_download);`	138	`$acct_download = bytes2str($acct_download);`
140	`$acct_server = $row[nasipaddress];`	139	`$acct_server = $row[nasipaddress];`
141	`if ($acct_server != ''){`	140	`if ($acct_server != ''){`
142	`$acct_server = $da_name_cache[$row[nasipaddress]];`	141	`$acct_server = $da_name_cache[$row[nasipaddress]];`
143	`if (!isset($acct_server)){`	142	`if (!isset($acct_server)){`
144	`$acct_server = @gethostbyaddr($row[nasipaddress]);`	143	`$acct_server = @gethostbyaddr($row[nasipaddress]);`
145	`if (!isset($da_name_cache) && $config[general_use_session] == 'yes'){`	144	`if (!isset($da_name_cache) && $config[general_use_session] == 'yes'){`
146	`$da_name_cache[$row[nasipaddress]] = $acct_server;`	145	`$da_name_cache[$row[nasipaddress]] = $acct_server;`
147	`session_register('da_name_cache');`	146	`session_register('da_name_cache');`
148	`}`	147	`}`
149	`else`	148	`else`
150	`$da_name_cache[$row[nasipaddress]] = $acct_server;`	149	`$da_name_cache[$row[nasipaddress]] = $acct_server;`
151	`}`	150	`}`
152	`}`	151	`}`
153	`else`	152	`else`
154	`$acct_server = '-';`	153	`$acct_server = '-';`
155	`$acct_server = "$acct_server:$row[nasportid]";`	154	`$acct_server = "$acct_server:$row[nasportid]";`
156	`$acct_terminate_cause = "$row[acctterminatecause]";`	155	`$acct_terminate_cause = "$row[acctterminatecause]";`
157	`if ($acct_terminate_cause == '')`	156	`if ($acct_terminate_cause == '')`
158	`$acct_terminate_cause = '-';`	157	`$acct_terminate_cause = '-';`
159	`if (ereg('Login-Incorrect',$acct_terminate_cause) \|\|`	158	`if (ereg('Login-Incorrect',$acct_terminate_cause) \|\|`
160	`ereg('Multiple-Logins', $acct_terminate_cause) \|\| ereg('Invalid-User',$acct_terminate_cause))`	159	`ereg('Multiple-Logins', $acct_terminate_cause) \|\| ereg('Invalid-User',$acct_terminate_cause))`
161	`$tr_color='#ffe8e0';`	-
162	`$acct_callerid = "$row[callingstationid]";`	160	`$acct_callerid = "$row[callingstationid]";`
163	`if ($acct_callerid == '')`	161	`if ($acct_callerid == '')`
164	`$acct_callerid = '-';`	162	`$acct_callerid = '-';`
165	`echo <<<EOM`	163	`echo <<<EOM`
166	`<tr align=center bgcolor="$tr_color">`	164	`<tr align=center>`
167	`<td>$num</td>`	165	`<td>$num</td>`
168	`EOM;`	166	`EOM;`
169	`if ($acct_attrs[ua][1] != '') echo "<td>$acct_type</td>\n";`	167	`if ($acct_attrs[ua][1] != '') echo "<td>$acct_type</td>\n";`
170	`if ($acct_attrs[ua][2] != '') echo "<td>$acct_logedin</td>\n";`	168	`if ($acct_attrs[ua][2] != '') echo "<td>$acct_logedin</td>\n";`
171	`if ($acct_attrs[ua][3] != '') echo "<td>$acct_sessiontime</td>\n";`	169	`if ($acct_attrs[ua][3] != '') echo "<td>$acct_sessiontime</td>\n";`
172	`if ($acct_attrs[ua][4] != '') echo "<td>$acct_ip</td>\n";`	170	`if ($acct_attrs[ua][4] != '') echo "<td>$acct_ip</td>\n";`
173	`if ($acct_attrs[ua][5] != '') echo "<td>$acct_upload</td>\n";`	171	`if ($acct_attrs[ua][5] != '') echo "<td>$acct_upload</td>\n";`
174	`if ($acct_attrs[ua][6] != '') echo "<td>$acct_download</td>\n";`	172	`if ($acct_attrs[ua][6] != '') echo "<td>$acct_download</td>\n";`
175	`if ($acct_attrs[ua][7] != '') echo "<td>$acct_server</td>\n";`	173	`// if ($acct_attrs[ua][7] != '') echo "<td>$acct_server</td>\n";`
176	`if ($acct_attrs[ua][8] != '') echo "<td>$acct_terminate_cause</td>\n";`	174	`if ($acct_attrs[ua][8] != '') echo "<td>$acct_terminate_cause</td>\n";`
177	`if ($acct_attrs[ua][9] != '') echo "<td>$acct_callerid</td>\n";`	175	`// if ($acct_attrs[ua][9] != '') echo "<td>$acct_callerid</td>\n";`
178	`echo "</tr>\n";`	176	`echo "</tr>\n";`
179	`}`	177	`}`
180	`$acct_sessiontime_sum = time2str($acct_sessiontime_sum);`	178	`$acct_sessiontime_sum = time2str($acct_sessiontime_sum);`
181	`$acct_upload_sum = bytes2str($acct_upload_sum);`	179	`$acct_upload_sum = bytes2str($acct_upload_sum);`
182	`$acct_download_sum = bytes2str($acct_download_sum);`	180	`$acct_download_sum = bytes2str($acct_download_sum);`
183	`}`	181	`}`
184	`else`	182	`else`
185	`echo "<b>Database query failed: " . da_sql_error($link,$config) . "</b><br>\n";`	183	`echo "<b>Database query failed: " . da_sql_error($link,$config) . "</b><br>\n";`
186	`}`	184	`}`
187	`else`	185	`else`
188	`echo "<b>Could not connect to SQL database</b><br>\n";`	186	`echo "<b>Could not connect to SQL database</b><br>\n";`
189	`$colspan = 3;`	187	`$colspan = 3;`
190	`if ($acct_attrs[ua][1] == '')`	188	`if ($acct_attrs[ua][1] == '')`
191	`$colspan--;`	189	`$colspan--;`
192	`if ($acct_attrs[ua][2] == '')`	190	`if ($acct_attrs[ua][2] == '')`
193	`$colspan--;`	191	`$colspan--;`
194	`echo <<<EOM`	192	`echo <<<EOM`
195	`<tr bgcolor="lightyellow">`	193	`<tr bgcolor="lightyellow" align="center">`
196	`<td colspan=$colspan align="right">Total pages</td>`	194	`<td colspan=$colspan><b>Total</b></td>`
197	`EOM;`	195	`EOM;`
198	`if ($acct_attrs[ua][3] != '') echo "<td align=\"center\"><b>$acct_sessiontime_sum</td>\n";`	196	`if ($acct_attrs[ua][3] != '') echo "<td><b>$acct_sessiontime_sum</td>\n";`
199	`if ($acct_attrs[ua][4] != '') echo "<td> </td>\n";`	197	`if ($acct_attrs[ua][4] != '') echo "<td> </td>\n";`
200	`if ($acct_attrs[ua][5] != '') echo "<td align=\"right\" nowrap><b>$acct_upload_sum</td>\n";`	198	`if ($acct_attrs[ua][5] != '') echo "<td><b>$acct_upload_sum</td>\n";`
201	`if ($acct_attrs[ua][6] != '') echo "<td align=\"right\" nowrap><b>$acct_download_sum</td>\n";`	199	`if ($acct_attrs[ua][6] != '') echo "<td><b>$acct_download_sum</td>\n";`
202	`if ($acct_attrs[ua][7] != '') echo "<td> </td>\n";`	200	`// if ($acct_attrs[ua][7] != '') echo "<td> </td>\n";`
203	`if ($acct_attrs[ua][8] != '') echo "<td> </td>\n";`	201	`if ($acct_attrs[ua][8] != '') echo "<td> </td>\n";`
204	`if ($acct_attrs[ua][9] != '') echo "<td> </td>\n";`	202	`// if ($acct_attrs[ua][9] != '') echo "<td> </td>\n";`
205	`?>`	203	`?>`
206	`</tr>`	204	`</tr>`
207	`</table>`	205	`</table>`
208	`<tr><td>`	206	`<tr><td>`
209	`<hr>`	207	`<hr>`
210	`<tr><td align="center">`	208	`<tr><td align="center">`
211	`<form action="user_accounting.php" method="get" name="master">`	209	`<form action="user_accounting.php" method="get" name="master">`
212	`<table border=0>`	210	`<table border=0>`
213	`<tr><td colspan=6></td>`	211	`<tr><td colspan=6></td>`
214	`</tr>`	212	`</tr>`
215	`<tr valign="bottom">`	213	`<tr valign="bottom">`
216	`<td><small><b>Utilisateur</td><td><small><b>début date</td><td><small><b>fin date</td><td><small><b>nbr./page</td><td><b>classé le</td>`	214	`<td><small><b><?php echo "$l_user";?></td><td><small><b>from</td><td><small><b>to</td><td><small><b>nbr./page</td><td><b>order</td>`
217	`<tr valign="middle"><td>`	215	`<tr valign="middle"><td>`
218	`<?php`	216	`<?php`
219	`echo <<<EOM`	217	`echo <<<EOM`
220	`<input type="text" name="login" size="11" value="$login"></td>`	218	`<input type="text" name="login" size="11" value="$login"></td>`
221	`<td><input type="text" name="prev_str" size="11" value="$prev_str"></td>`	219	`<td><input type="text" name="prev_str" size="11" value="$prev_str"></td>`
222	`<td><input type="text" name="now_str" size="11" value="$now_str"></td>`	220	`<td><input type="text" name="now_str" size="11" value="$now_str"></td>`
223	`<td><select name="pagesize">`	221	`<td><select name="pagesize">`
224	`<option $selected[5] value="5" >05`	222	`<option $selected[5] value="5" >05`
225	`<option $selected[10] value="10">10`	223	`<option $selected[10] value="10">10`
226	`<option $selected[15] value="15">15`	224	`<option $selected[15] value="15">15`
227	`<option $selected[20] value="20">20`	225	`<option $selected[20] value="20">20`
228	`<option $selected[40] value="40">40`	226	`<option $selected[40] value="40">40`
229	`<option $selected[80] value="80">80`	227	`<option $selected[80] value="80">80`
230	`<option $selected[all] value="all">tous`	228	`<option $selected[all] value="all">tous`
231	`</select>`	229	`</select>`
232	`</td>`	230	`</td>`
233	`<td><select name="order">`	231	`<td><select name="order">`
234	`<option $selected[asc] value="asc">plus ancien en premier`	232	`<option $selected[asc] value="asc">older first`
235	`<option $selected[desc] value="desc">plus récent en premier`	233	`<option $selected[desc] value="desc">recent first`
236	`</select>`	234	`</select>`
237	`</td>`	235	`</td>`
238	`EOM;`	236	`EOM;`
239	`?>`	237	`?>`
240		238
241	`<td><input type="submit" class=button value="show"></td></tr>`	239	`<td><input type="submit" class=button value="show"></td></tr>`
242	`</table></td></tr></form>`	240	`</table></td></tr></form>`
243	`</table>`	241	`</table>`
244	`</tr>`	242	`</tr>`
245	`</table>`	243	`</table>`
246	`</TD></TR>`	244	`</TD></TR>`
247	`</TABLE>`	245	`</TABLE>`
248	`</td></tr>`	246	`</td></tr>`
249	`</TABLE>`	247	`</TABLE>`
250	`</body>`	248	`</body>`
251	`</html>`	249	`</html>`
252		250

Subversion Repositories ALCASAR

(root)/web/acc/manager/htdocs/user_accounting.php – Rev 820 → 910