Me too.
I have also built a report generator, into the management system I
built.
I can provide snippets, but not the whole source until I get
authorization.
Here is a little snippet that allows the PHP output to be
automatically opened in a spreadsheet :
---begin---
// $output contains tab ["\t"] delimited fields
// and linefeed ["\n"] delimited records
$size_in_bytes = strlen($output);
if(strstr($_SERVER['HTTP_USER_AGENT'],'Safari') != false){
// User Agent is Safari = Broken
// Document must be opend and saved with a text editor
// before excel can open it
header("Content-type: application/vnd.ms-excel");
header("Content-disposition: attachment; filename=report-" .
$_SESSION['report'] . "-" . $syear . $smonth . "_" . $eyear . $emonth .
"-" . $gmatch . "_" . $umatch . "-" . date("Y-m-d") . ".txt; size=
$size_in_bytes");
} else {
header("Content-type: application/vnd.ms-excel");
header("Content-disposition: attachment; filename=report-" .
$_SESSION['report'] . "-" . $syear . $smonth . "_" . $eyear . $emonth .
"-" . $gmatch . "_" . $umatch . "-" . date("Y-m-d") . ".tab; size=
$size_in_bytes");
}
echo $output ;
---End---
Note: When this works, the web page does not change since the data
is output as the attachment.
On Thu, 2006-08-24 at 11:04 -0600, Scott Miller wrote:
> I've also created a report generator - but mine does not require you to
> input the IP address. It just authenticates the user, asks for the month
> they want to display, and if they want a summary report or a detailed
> report. It is actually an old ICRadius script (written in PHP) that I found
> and modified to fit my needs. I'm willing to share this one as well if
> anyone is interested.
>
> Scott
>
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]
> On Behalf Of Sean
> Sent: Wednesday, August 23, 2006 1:58 PM
> To: freeradius-users@lists.freeradius.org
> Subject: Report Generator
>
> Hi,
>
> Ive written a report generator in PHP and HTML that will allow your
> clients to generate usage reports from the FreeRadius log files. When
> the user logs in he/she is asked for their IP address and the Month that
> they want to display. If anyone wants a copy let me know. If there is
> enough interest I'll make it available for public download.
>
> Regards,
>
> Sean Bracken
>
> http://swarmhotspots.com
> -
> List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html
>
>
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
