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


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

Subversion Repositories ALCASAR

(root)/web/acc/manager/htdocs/user_accounting.php – Rev 2817 → 2968