Subversion Repositories cheapmusic

<?php

    include_once ($_SERVER['DOCUMENT_ROOT'] . '/php/dnsexit.php');

    $minDate = 20190101;

    $maxDate = date("Ymd");

    $unique = false;

    $plottype = "bars";

    $startTS = 0;

    $endTS = 0;

    if (!empty($_GET['start']) && filter_var($_GET['start'], FILTER_VALIDATE_INT, array("options" => array("min_range"=>$minDate, "max_range"=>$maxDate)))) {

        $date = $_GET['start'] . " 00:00:00 UTC";

        $dateTime = new DateTime($date);

        $startTS = $dateTime->format('U');

    }

    if (!empty($_GET['end']) && filter_var($_GET['end'], FILTER_VALIDATE_INT, array("options" => array("min_range"=>$minDate, "max_range"=>$maxDate)))) {

        $date = $_GET['end'] . " 23:59:59 UTC";

        $dateTime = new DateTime($date);

        $endTS = $dateTime->format('U');

    }

    if (!empty($_GET['unique']) && ($_GET['unique'] == '0' || $_GET['unique'] == '1')) {

        $unique = ($_GET['unique'] == '1');

    }

    $plottypes = array(

    "area",

    "bars",

    "linepoints",

    "lines",

    "pie",

    "points",

    "squared",

    "squaredarea",

    "stackedarea",

    "stackedbars",

    "stackedsquaredarea",

    "thinbarline");

    if (!empty($_GET['type']) && in_array($_GET['type'], $plottypes)) {

        $plottype = $_GET['type'];

    }

    $height = 1024;

    if (!empty($_GET['height']) && $_GET['height'] > 0) {

        $height = $_GET['height'];

    }

    $width = 768;

    if (!empty($_GET['width']) && $_GET['width'] > 0) {

        $width = $_GET['width'];

    }

    include_once ($_SERVER['DOCUMENT_ROOT'] . '/php/constants.php');

    include_once ($_SERVER['DOCUMENT_ROOT'] . '/php/sessions_db.php');

    include_once ($_SERVER['DOCUMENT_ROOT'] . '/php/cryptor.php');

    require_once $_SERVER['DOCUMENT_ROOT'] . '/php/phplot.php';

    $configFile = parse_ini_file($_SERVER['DOCUMENT_ROOT'] . FCM_CONFIGFILE, true);

    $crypt = Cryptor::getInstance($configFile['cryptor']);

    $tmpSessionTab = (isset($_POST["sessionTab"]) && $_POST["sessionTab"] > 0 ? $_POST["sessionTab"] : null);

    $handler = MySessionHandler::getInstance($tmpSessionTab, $configFile['mysqli']);

    unset($configFile);

    ini_set("session.cookie_httponly", 1);

    ini_set("session.cookie_secure", 1);

    session_set_save_handler($handler, true);

    if (!empty($_COOKIE['PHPSESSID'])) {

        session_id($_COOKIE['PHPSESSID']);

    }

    @session_start();

    $_sess_db = MySessionHandler::getDBSessionId();

    $countSql = ($unique ? "count(distinct(ip))" : "count(*)");

    $whereSql = "";

    if ($startTS > 0 && $endTS > 0) {

        $whereSql .= " where access between " . $startTS . " and " . $endTS;

    } else if ($startTS > 0) {

        $whereSql .= " where access >= " . $startTS;

    } else if ($endTS > 0) {

        $whereSql .= " where access <= " . $endTS;

    }

    $searches = [];

    $sql = "select from_unixtime(access, '%m/%d/%Y') as day, " . $countSql . " as count from searches";

    $sql .= $whereSql;

    $sql .= " group by from_unixtime(access, '%m/%d/%Y') order by access";

    $result = mysqli_query($_sess_db, $sql);

    if (!$result) {

        error_log("Error: " . $sql . " | " . mysqli_error($_sess_db));

    } else {

        if (mysqli_num_rows($result) > 0) {

            while ($row = mysqli_fetch_assoc($result)) {

                $searches[] = array($row["day"], $row["count"]);

            }

        }

    }

    $transfers = [];

    $sql = "select from_unixtime(access, '%m/%d/%Y') as day, " . $countSql . " as count from transfers";

    $sql .= $whereSql;

    $sql .= " group by from_unixtime(access, '%m/%d/%Y') order by access";

    $result = mysqli_query($_sess_db, $sql);

    if (!$result) {

        error_log("Error: " . $sql . " | " . mysqli_error($_sess_db));

    } else {

        if (mysqli_num_rows($result) > 0) {

            while ($row = mysqli_fetch_assoc($result)) {

                $transfers += array($row["day"] => $row["count"]);

            }

        }

    }

    $data = [];

    foreach ($searches as list($k, $v)) {

        $t = (array_key_exists($k, $transfers) ? $transfers[$k] : 0);

        $data[] = array($k, $v, $t);

    }

//echo"<pre>";print_r($data);echo "</pre>";

$plot = new PHPlot($width, $height);

$plot->SetImageBorderType('plain');

$title = 'Find Cheap Music';

if ($startTS || $endTS) {

    $title .= "\n";

    if ($startTS) {

        $title .= "from " . gmdate("m/d/y", $startTS);

    }

    if ($endTS) {

        $title .= " to " . gmdate("m/d/y", $endTS);

    }

}

$plot->SetTitle($title);

$plot->SetPlotType($plottype);

//$plot->SetShading(0);

$plot->SetDataValues($data);

$plot->SetLegend(array('Search', 'Transfer'));

$plot->SetXDataLabelAngle(90);

$plot->SetYTitle(($unique ? "Unique" : "All") .  " Requests");

$plot->SetYTickIncrement(1);

$plot->DrawGraph();