PHP VerticalChart::render 예제들

예제 #1

파일: graphs-alltime-users-login.php 프로젝트: JWynegar/daloradius

function yearly()
{
    include 'opendb.php';
    include 'libchart/libchart.php';
    header("Content-type: image/png");
    $chart = new VerticalChart(680, 500);
    $sql = "SELECT count(AcctStartTime), YEAR(AcctStartTime) AS Year from " . $configValues['CONFIG_DB_TBL_RADACCT'] . " group by Year;";
    $res = $dbSocket->query($sql);
    while ($row = $res->fetchRow()) {
        $chart->addPoint(new Point("{$row['1']}", "{$row['0']}"));
    }
    $chart->setTitle("Distribución de ingresos por año");
    $chart->render();
    include 'closedb.php';
}

예제 #2

파일: graphs-overall-users-login.php 프로젝트: fevenor/Dockerfile

function yearly($username)
{
    include 'opendb.php';
    include 'libchart/libchart.php';
    $username = $dbSocket->escapeSimple($username);
    header("Content-type: image/png");
    $chart = new VerticalChart(680, 500);
    $sql = "SELECT UserName, count(AcctStartTime), YEAR(AcctStartTime) AS Year FROM " . $configValues['CONFIG_DB_TBL_RADACCT'] . " WHERE username='******' GROUP BY Year;";
    $res = $dbSocket->query($sql);
    while ($row = $res->fetchRow()) {
        $chart->addPoint(new Point("{$row['2']}", "{$row['1']}"));
    }
    $chart->setTitle("Total Users");
    $chart->render();
    include 'closedb.php';
}

예제 #3

파일: graphs-overall-users-upload.php 프로젝트: fevenor/Dockerfile

function yearly($username)
{
    include 'opendb.php';
    include 'libchart/libchart.php';
    $username = $dbSocket->escapeSimple($username);
    header("Content-type: image/png");
    $chart = new VerticalChart(680, 500);
    $sql = "SELECT UserName, sum(AcctInputOctets) as Uploads, year(AcctStartTime) AS year FROM " . $configValues['CONFIG_DB_TBL_RADACCT'] . " WHERE username='******' GROUP BY year;";
    $res = $dbSocket->query($sql);
    while ($row = $res->fetchRow()) {
        $uploads = floor($row[1] / 1024 / 1024);
        $chart->addPoint(new Point("{$row['2']}", "{$uploads}"));
    }
    $chart->setTitle("Total Uploads based on Yearly distribution");
    $chart->render();
    include 'closedb.php';
}

예제 #4

파일: graphs-reports-new-users.php 프로젝트: fortitudezhang/daloradius

 * along with this program; if not, write to the Free Software
 * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.
 *
 *********************************************************************************************************
 * Description:
 *              this extension creates a pie chart of new users
 *
 * Authors:     Liran Tal <*****@*****.**>
 *              Filippo Maria Del Prete <*****@*****.**>
 *
 *********************************************************************************************************
 */
include 'checklogin.php';
if (isset($_GET['startdate'])) {
    $startdate = $_GET['startdate'];
}
if (isset($_GET['enddate'])) {
    $enddate = $_GET['enddate'];
}
include 'opendb.php';
include 'libchart/libchart.php';
header("Content-type: image/png");
$chart = new VerticalChart(680, 500);
$sql = "SELECT COUNT(*), CONCAT(YEAR(Creationdate),'-',MONTH(Creationdate), '-01') AS Month from " . $configValues['CONFIG_DB_TBL_DALOUSERINFO'] . " WHERE CreationDate >='{$startdate}' AND CreationDate <='{$enddate}' " . " GROUP BY Month ORDER BY Date(Month);";
$res = $dbSocket->query($sql);
while ($row = $res->fetchRow()) {
    $chart->addPoint(new Point("{$row['1']}", "{$row['0']}"));
}
$chart->setTitle("New Users by Month");
$chart->render();
include 'closedb.php';

예제 #5

파일: graphs-alltime-traffic-download.php 프로젝트: JWynegar/daloradius

function yearly()
{
    global $sizeDivision;
    global $size;
    include 'opendb.php';
    include 'libchart/libchart.php';
    header("Content-type: image/png");
    $chart = new VerticalChart(680, 500);
    $sql = "SELECT sum(AcctOutputOctets) as Downloads, year(AcctStartTime) AS year from " . $configValues['CONFIG_DB_TBL_RADACCT'] . " group by year;";
    $res = $dbSocket->query($sql);
    while ($row = $res->fetchRow()) {
        $downloads = floor($row[0] / $sizeDivision);
        $chart->addPoint(new Point("{$row['1']}", "{$downloads}"));
    }
    $chart->setTitle("Distribución de volumen de trafico total anual ({$size})");
    $chart->render();
    include 'closedb.php';
}

예제 #6

파일: graphs-logged_users.php 프로젝트: fevenor/Dockerfile

function graph_month($month, $year)
{
    include 'opendb.php';
    include 'libchart/libchart.php';
    header("Content-type: image/png");
    $chart = new VerticalChart(780, 500);
    $month = month_alpha_to_number($month);
    $lastDay = date("d", mktime(0, 0, 0, $month + 1, 0, date("Y")));
    for ($i = 1; $i <= $lastDay; $i++) {
        $measure[$i]['min'] = 100000;
        $measure[$i]['max'] = 0;
        for ($j = 0; $j < 24; $j++) {
            //24 hours a day
            $date = "{$year}-{$month}-{$i} {$j}:00:00";
            $sql = "select count(radacctid) from radacct where (acctstarttime <= '{$date}' and acctstoptime >= '{$date}') or (acctstarttime <= '{$date}' and acctsessiontime = 0 and acctinputoctets = 0 and acctoutputoctets = 0);";
            $result = $dbSocket->query($sql);
            $row = $result->fetchRow();
            $cnt = $row[0];
            if ($cnt < $measure[$i]['min']) {
                $measure[$i]['min'] = $cnt;
            } else {
                if ($cnt > $measure[$i]['max']) {
                    $measure[$i]['max'] = $cnt;
                }
            }
        }
    }
    for ($i = 1; $i <= $lastDay; $i++) {
        $chart->addPoint(new Point("{$i} - Min", $measure[$i]['min']));
        $chart->addPoint(new Point("{$i} - Max", $measure[$i]['max']));
    }
    $chart->setTitle("Logged users by month");
    $chart->render();
    include 'closedb.php';
}

예제 #7

파일: demo1.php 프로젝트: aydancoskun/octobercms

 * License along with this library; if not, write to the Free Software
 * Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA  02110-1301  USA
 * 
 */
/**
 * Vertical bars demonstration
 *
 */
include "../libchart.php";
$chart = new VerticalChart();
$chart->addPoint(new Point("Jan 2005", 273));
$chart->addPoint(new Point("Feb 2005", 421));
$chart->addPoint(new Point("March 2005", 642));
$chart->addPoint(new Point("April 2005", 800));
$chart->addPoint(new Point("May 2005", 1200));
$chart->addPoint(new Point("June 2005", 1500));
$chart->addPoint(new Point("July 2005", 2600));
$chart->setTitle("Monthly usage for www.example.com");
$chart->render("generated/demo1.png");
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
	<title>Libcharts vertical bars demonstration</title>
	<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-15" />
</head>
<body>
	<img alt="Vertical bars chart" src="generated/demo1.png" style="border: 1px solid gray;"/>
</body>
</html>

예제 #8

파일: graphs-overall-users-download.php 프로젝트: JWynegar/daloradius

function yearly($username)
{
    global $sizeDivision;
    global $size;
    include 'opendb.php';
    include 'libchart/libchart.php';
    $username = $dbSocket->escapeSimple($username);
    header("Content-type: image/png");
    $chart = new VerticalChart(680, 500);
    $sql = "SELECT UserName, sum(AcctOutputOctets) as Downloads, year(AcctStartTime) AS year FROM " . $configValues['CONFIG_DB_TBL_RADACCT'] . " WHERE username='******' GROUP BY year;";
    $res = $dbSocket->query($sql);
    while ($row = $res->fetchRow()) {
        $downloads = $downloads = number_format($row[1] / $sizeDivision, 2, '.', '');
        $chart->addPoint(new Point("{$row['2']}", "{$downloads}"));
    }
    $chart->setTitle("Distribución de la descarga total por año ({$size})");
    $chart->render();
    include 'closedb.php';
}