malatx/sample-dash.php

## sample-dash.php
<?php
// This is sample code to draw some of the charts I blogged about here:
// https://medium.com/ios-os-x-development/keeping-your-wits-as-an-indie-app-developer-3b5b14428e1f
//
// A few disclaimers:
//   1. This assumes you have at least 30 days of sales data in order to draw the Trailing 7 Days Chart
//   2. This assumes you have over 52 consecutive weeks of data in order to draw the Trailing Year Chart
//   3. I don't really know PHP. Everything this does, I had to look it up while writing it. If you actually know PHP, sorry. There are surely better ways.
//
// the results of this PHP script is intended to be drawn using the Flot library.
// be sure to place the Flot files in a folder named 'flot', next to this script. (or change the HTML below)
// see http://www.flotcharts.org

// set these variables to your appfigures credentials
// see https://appfigures.com/developers/keys
$appFiguresUsername = "your@email.com";
$appFiguresPassword = "YourPassword!";
$appFiguresApiKey = "your_api_key";

// set this to the first date for which AppFigures has valid data in your account
$appFiguresFirstDate = new DateTime('2009-07-14');

// be sure the web server user has permission to create, write, and delete files in this cache folder.
// if the cache folder does not exist, no caching will take place (live hits to the API every time).
$cacheFolder = "./sample-cache";

$context = stream_context_create(array(
    'http' => array(
        'header'  => "Authorization: Basic " . base64_encode("$appFiguresUsername:$appFiguresPassword")
    )
));

$revenueDates = getAllRevenueDatesData($context);
$revenueDates = makeTTMFromWeeklyRevenues($revenueDates);

$last30DaysSummary = getLast30DaysSalesData($context);
$t7dDates = makeT7DFromDailyRevenues($last30DaysSummary);

function makeTTMFromWeeklyRevenues($weeklyRevenues)
{
    $ttmPoints = array();
    $numWeeks = count($weeklyRevenues);
    if ($numWeeks >= 52)
    {
        $currentWeek = $numWeeks - 1;

        while (true)
        {
            $startWeek = $currentWeek-52;
            if ($startWeek < 0)
            {
                break;
            }

            $yearSum = 0;
            for ($i=$startWeek;$i < $currentWeek; $i++)
            {
                if ($i < 0)
                {
                    break;
                }
                $yearSum += $weeklyRevenues[$i]["revenue"];
            }

            $ttmPoint["date"] = $weeklyRevenues[$currentWeek]["date"];
            $ttmPoint["revenue"] = $yearSum;
            $ttmPoints[] = $ttmPoint;

            $currentWeek--;
        }
    }

    return $ttmPoints;
}

function makeT7DFromDailyRevenues($dailyRevenues)
{
    $t7dPoints = array();
    $numDays = count($dailyRevenues);
    if ($numDays >= 14)
    {
        $currentDay = $numDays - 1;

        while (true)
        {
            $startDay = $currentDay-7;
            if ($startDay < 0)
            {
                break;
            }

            $weekSum = 0;
            for ($i=$startDay;$i < $currentDay; $i++)
            {
                if ($i < 0)
                {
                    break;
                }
                $weekSum += $dailyRevenues[$i]["revenue"];
            }

            $t7dPoint["date"] = $dailyRevenues[$currentDay]["date"];
            $t7dPoint["revenue"] = $weekSum;
            $t7dPoints[] = $t7dPoint;

            $currentDay--;
        }
    }

    return $t7dPoints;
}

// $products can be an array of appFigures product ID numbers. null means all products.
function getLast30DaysSalesData($context, $products=null)
{
    $currentDate = new DateTime();
    $currentDate->sub(new DateInterval('P1D'));

    $firstDate = clone $currentDate;
    $firstDate->sub(new DateInterval('P30D'));

    $startDate = $firstDate->format('Y-m-d');
    $endDate = $currentDate->format('Y-m-d');

    global $appFiguresApiKey;

    $url = 'https://api.appfigures.com/v2/sales/?start_date=' . $startDate . '&end_date=' . $endDate . '&group_by=date&granularity=daily&client_key=' . $appFiguresApiKey;
    $cacheKeyExtra = "all";
    if ($products != null)
    {
        $cacheKeyExtra = implode('_', $products);
        $url .= "&products=" . implode(';', $products);
    }

    $cacheKey = "$cacheKeyExtra.last30days.$startDate.$endDate";
    $json = getJsonWithCache($context, $cacheKey, $url);

    foreach($json as $item)
    {
        $date = $item["date"];
        $revenue = $item["revenue"];
        if ($revenue == 0)
        {
            bustCache($cacheKey);
            continue;
        }
        $revenuePoint["date"] = $date;
        $revenuePoint["downloads"] = $item["downloads"];
        $revenuePoint["revenue"] = $revenue;
        $result[] = $revenuePoint;
    }

    return $result;
}

function getAllRevenueDatesData($context, $products=null)
{
    $currentDate = new DateTime();
    $currentDate->sub(new DateInterval('P6D'));

    global $appFiguresFirstDate;
    $firstDate = clone $appFiguresFirstDate;
    $exit = false;

    $result = array();

    global $appFiguresApiKey;

    while (!$exit)
    {
        $secondDate = clone $firstDate;
        $secondDate->add(new DateInterval('P365D'));

        if ($secondDate > $currentDate)
        {
            $secondDate = $currentDate;
            $exit = true;
        }

        $startDate = $firstDate->format('Y-m-d');
        $endDate = $secondDate->format('Y-m-d');

        $url = 'https://api.appfigures.com/v2/sales/?start_date=' . $startDate . '&end_date=' . $endDate . '&group_by=dates&granularity=weekly&client_key=' . $appFiguresApiKey;

        $cacheKeyExtra = "all";
        if ($products != null)
        {
            $cacheKeyExtra = implode('_', $products);
            $url .= "&products=" . implode(';', $products);
        }

        $json = getJsonWithCache($context, "$cacheKeyExtra.weekly.$startDate.$endDate", $url);

        foreach($json as $item)
        {
            $date = $item["date"];
            $revenue = $item["revenue"];
            $revenuePoint["date"] = $date;
            $revenuePoint["revenue"] = $revenue;
            $result[] = $revenuePoint;
        }

        $firstDate = $secondDate;
    }

    return $result;
}

function getJson($context, $url)
{
    $response = file_get_contents($url, false, $context);
    $json = json_decode($response, TRUE);

    return $json;
}

function bustCache($cacheKey)
{
    global $cacheFolder;

    unlink("$cacheFolder/$cacheKey.json");
}

function getJsonWithCache($context, $cacheKey, $url)
{
    global $cacheFolder;

    $cacheFile = "$cacheFolder/$cacheKey.json";
    $cacheContent = file_get_contents($cacheFile);
    $response = "";
    if ($cacheContent)
    {
        $response = $cacheContent;
    }
    else
    {
        $response = file_get_contents($url, false, $context);
        file_put_contents($cacheFile, $response);
    }
    $json = json_decode($response, TRUE);

    return $json;
}


?>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
<html>
<head>
    <title>Sample Dashboard</title>
    <style type="text/css">
        * { font-family: Helvetica Neue, Helvetica, Arial, sans-serif;
        }
        .large-chart {width:1000px;height:550px;}
        .half-chart {width:500px;height:350px;}
    </style>
<script language="javascript" type="text/javascript" src="./flot/jquery.min.js"></script>
<script language="javascript" type="text/javascript" src="./flot/jquery.flot.min.js"></script>
<script language="javascript" type="text/javascript" src="./flot/jquery.flot.time.min.js"></script>
<script type="text/javascript">
    $(function() {

        var last_14days = [

<?php
    $last14DaysSummary = array_slice($last30DaysSummary, -14);
    foreach ($last14DaysSummary as $point)
    {
        $dateTime = new DateTime($point["date"]);
        $unixTimestamp = $dateTime->getTimestamp();
        $javascriptTimeStamp = $unixTimestamp *1000;

        print_r('[');
        print_r($javascriptTimeStamp);
        print_r(',');
        print_r($point["revenue"]);
        print_r('],');
    }
?>
        ];

        var all_t7d = [
            <?php
    foreach ($t7dDates as $point)
    {
        $dateTime = new DateTime($point["date"]);
        $unixTimestamp = $dateTime->getTimestamp();
        $javascriptTimeStamp = $unixTimestamp *1000;

        print_r('[');
        print_r($javascriptTimeStamp);
        print_r(',');
        print_r($point["revenue"]);
        print_r('],');
    }
 ?>
        ];

        var all_ttm = [
            <?php
    foreach ($revenueDates as $point)
    {
        $dateTime = new DateTime($point["date"]);
        $unixTimestamp = $dateTime->getTimestamp();
        $javascriptTimeStamp = $unixTimestamp *1000;

        print_r('[');
        print_r($javascriptTimeStamp);
        print_r(',');
        print_r($point["revenue"]);
        print_r('],');
    }
 ?>
        ];

        var options = {
            grid: { hoverable: true, clickable: true, color:"#007AFF" },
            xaxis: { mode: "time", font: { color: "#099eff" } },
            yaxis: { tickDecimals: "2", font: { color: "#099eff" }},
            lines: { show:true },
            legend: { position: "nw" },
            points: {
                radius:2,
                show:true
            },
            colors: ["#FF5E3A","#FF9500","#FFDB4C", "#87FC70", "#007AFF", "#1AD6FD", "#C644FC", "#EF4DB6", "#5856D6" ]
        };

        var rankOptions = {
            grid: { hoverable: true, clickable: true, color:"#007AFF" },
            xaxis: { mode: "time", font: { color: "#099eff" } },
            yaxis: { tickDecimals: "2",
                transform: function (v) { return -v; },
                inverseTransform: function (v) { return -v; },
                font: { color: "#099eff" },
            },
            lines: { show:true },
            legend: { position: "nw", container: $("#flot-top-grossing-legend") },
            points: {
                radius:2,
                show:true
            },
            colors: ["#FF5E3A","#FF9500","#FFDB4C", "#87FC70", "#007AFF", "#1AD6FD", "#C644FC", "#EF4DB6", "#5856D6", "#FF1300" ]
        };


        function showTooltip(x, y, contents) {
            $('<div id="tooltip">' + contents + '</div>').css( {
                position: 'absolute',
                display: 'none',
                top: y + 5,
                left: x + 5,
                border: '1px solid #fdd',
                padding: '2px',
                'background-color': '#fee',
                opacity: 0.80
            }).appendTo("body").fadeIn(200);
        }

        function bindPlotHover(chartId)
        {
            var previousPoint = null;
            $(chartId).bind("plothover", function (event, pos, item) {
                $("#x").text(pos.x.toFixed(2));
                $("#y").text(pos.y.toFixed(2));

                if (item) {
                    if (previousPoint != item.dataIndex) {
                        previousPoint = item.dataIndex;

                        $("#tooltip").remove();
                        var x = item.datapoint[0].toFixed(2),
                            y = item.datapoint[1].toFixed(2);

                        showTooltip(item.pageX, item.pageY,
                            item.series.label + " = " + y);
                    }
                }
                else {
                    $("#tooltip").remove();
                    previousPoint = null;
                }
            });
        }

        bindPlotHover("#flot-last-14days-placeholder");
        bindPlotHover("#flot-all-ttm-placeholder");
        bindPlotHover("#flot-t7d-placeholder");

        $.plot("#flot-last-14days-placeholder", [{label:"$", data:last_14days}], options);
        $.plot("#flot-all-ttm-placeholder", [{label:"$", data:all_ttm}], options);
        $.plot("#flot-t7d-placeholder",[{label:"All", data:all_t7d}], options);
    });
</script>
</head>
<body bgcolor="#FFFFFF">
    <div style="width:50%;float:left">
        <h2>Sales Daily Net Revenue</h2>
        <div id="flot-last-14days-placeholder" class="half-chart"></div>
    </div>
    <br style="clear:both;"/>
    <p></p>
    <h2>Net Revenue Trailing 7 Days</h2>
    <div id="flot-t7d-placeholder" class="large-chart"></div>
    <h2>Revenue Trailing Year</h2>
    <div id="flot-all-ttm-placeholder" class="large-chart"></div>
</body>
</html>
	<?php
	// This is sample code to draw some of the charts I blogged about here:
	// https://medium.com/ios-os-x-development/keeping-your-wits-as-an-indie-app-developer-3b5b14428e1f
	//
	// A few disclaimers:
	// 1. This assumes you have at least 30 days of sales data in order to draw the Trailing 7 Days Chart
	// 2. This assumes you have over 52 consecutive weeks of data in order to draw the Trailing Year Chart
	// 3. I don't really know PHP. Everything this does, I had to look it up while writing it. If you actually know PHP, sorry. There are surely better ways.
	//
	// the results of this PHP script is intended to be drawn using the Flot library.
	// be sure to place the Flot files in a folder named 'flot', next to this script. (or change the HTML below)
	// see http://www.flotcharts.org

	// set these variables to your appfigures credentials
	// see https://appfigures.com/developers/keys
	$appFiguresUsername = "your@email.com";
	$appFiguresPassword = "YourPassword!";
	$appFiguresApiKey = "your_api_key";

	// set this to the first date for which AppFigures has valid data in your account
	$appFiguresFirstDate = new DateTime('2009-07-14');

	// be sure the web server user has permission to create, write, and delete files in this cache folder.
	// if the cache folder does not exist, no caching will take place (live hits to the API every time).
	$cacheFolder = "./sample-cache";

	$context = stream_context_create(array(
	'http' => array(
	'header' => "Authorization: Basic " . base64_encode("$appFiguresUsername:$appFiguresPassword")
	)
	));

	$revenueDates = getAllRevenueDatesData($context);
	$revenueDates = makeTTMFromWeeklyRevenues($revenueDates);

	$last30DaysSummary = getLast30DaysSalesData($context);
	$t7dDates = makeT7DFromDailyRevenues($last30DaysSummary);

	function makeTTMFromWeeklyRevenues($weeklyRevenues)
	{
	$ttmPoints = array();
	$numWeeks = count($weeklyRevenues);
	if ($numWeeks >= 52)
	{
	$currentWeek = $numWeeks - 1;

	while (true)
	{
	$startWeek = $currentWeek-52;
	if ($startWeek < 0)
	{
	break;
	}

	$yearSum = 0;
	for ($i=$startWeek;$i < $currentWeek; $i++)
	{
	if ($i < 0)
	{
	break;
	}
	$yearSum += $weeklyRevenues[$i]["revenue"];
	}

	$ttmPoint["date"] = $weeklyRevenues[$currentWeek]["date"];
	$ttmPoint["revenue"] = $yearSum;
	$ttmPoints[] = $ttmPoint;

	$currentWeek--;
	}
	}

	return $ttmPoints;
	}

	function makeT7DFromDailyRevenues($dailyRevenues)
	{
	$t7dPoints = array();
	$numDays = count($dailyRevenues);
	if ($numDays >= 14)
	{
	$currentDay = $numDays - 1;

	while (true)
	{
	$startDay = $currentDay-7;
	if ($startDay < 0)
	{
	break;
	}

	$weekSum = 0;
	for ($i=$startDay;$i < $currentDay; $i++)
	{
	if ($i < 0)
	{
	break;
	}
	$weekSum += $dailyRevenues[$i]["revenue"];
	}

	$t7dPoint["date"] = $dailyRevenues[$currentDay]["date"];
	$t7dPoint["revenue"] = $weekSum;
	$t7dPoints[] = $t7dPoint;

	$currentDay--;
	}
	}

	return $t7dPoints;
	}

	// $products can be an array of appFigures product ID numbers. null means all products.
	function getLast30DaysSalesData($context, $products=null)
	{
	$currentDate = new DateTime();
	$currentDate->sub(new DateInterval('P1D'));

	$firstDate = clone $currentDate;
	$firstDate->sub(new DateInterval('P30D'));

	$startDate = $firstDate->format('Y-m-d');
	$endDate = $currentDate->format('Y-m-d');

	global $appFiguresApiKey;

	$url = 'https://api.appfigures.com/v2/sales/?start_date=' . $startDate . '&end_date=' . $endDate . '&group_by=date&granularity=daily&client_key=' . $appFiguresApiKey;
	$cacheKeyExtra = "all";
	if ($products != null)
	{
	$cacheKeyExtra = implode('_', $products);
	$url .= "&products=" . implode(';', $products);
	}

	$cacheKey = "$cacheKeyExtra.last30days.$startDate.$endDate";
	$json = getJsonWithCache($context, $cacheKey, $url);

	foreach($json as $item)
	{
	$date = $item["date"];
	$revenue = $item["revenue"];
	if ($revenue == 0)
	{
	bustCache($cacheKey);
	continue;
	}
	$revenuePoint["date"] = $date;
	$revenuePoint["downloads"] = $item["downloads"];
	$revenuePoint["revenue"] = $revenue;
	$result[] = $revenuePoint;
	}

	return $result;
	}

	function getAllRevenueDatesData($context, $products=null)
	{
	$currentDate = new DateTime();
	$currentDate->sub(new DateInterval('P6D'));

	global $appFiguresFirstDate;
	$firstDate = clone $appFiguresFirstDate;
	$exit = false;

	$result = array();

	global $appFiguresApiKey;

	while (!$exit)
	{
	$secondDate = clone $firstDate;
	$secondDate->add(new DateInterval('P365D'));

	if ($secondDate > $currentDate)
	{
	$secondDate = $currentDate;
	$exit = true;
	}

	$startDate = $firstDate->format('Y-m-d');
	$endDate = $secondDate->format('Y-m-d');

	$url = 'https://api.appfigures.com/v2/sales/?start_date=' . $startDate . '&end_date=' . $endDate . '&group_by=dates&granularity=weekly&client_key=' . $appFiguresApiKey;

	$cacheKeyExtra = "all";
	if ($products != null)
	{
	$cacheKeyExtra = implode('_', $products);
	$url .= "&products=" . implode(';', $products);
	}

	$json = getJsonWithCache($context, "$cacheKeyExtra.weekly.$startDate.$endDate", $url);

	foreach($json as $item)
	{
	$date = $item["date"];
	$revenue = $item["revenue"];
	$revenuePoint["date"] = $date;
	$revenuePoint["revenue"] = $revenue;
	$result[] = $revenuePoint;
	}

	$firstDate = $secondDate;
	}

	return $result;
	}

	function getJson($context, $url)
	{
	$response = file_get_contents($url, false, $context);
	$json = json_decode($response, TRUE);

	return $json;
	}

	function bustCache($cacheKey)
	{
	global $cacheFolder;

	unlink("$cacheFolder/$cacheKey.json");
	}

	function getJsonWithCache($context, $cacheKey, $url)
	{
	global $cacheFolder;

	$cacheFile = "$cacheFolder/$cacheKey.json";
	$cacheContent = file_get_contents($cacheFile);
	$response = "";
	if ($cacheContent)
	{
	$response = $cacheContent;
	}
	else
	{
	$response = file_get_contents($url, false, $context);
	file_put_contents($cacheFile, $response);
	}
	$json = json_decode($response, TRUE);

	return $json;
	}







	?>
	<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
	<html>
	<head>
	<title>Sample Dashboard</title>
	<style type="text/css">
	* { font-family: Helvetica Neue, Helvetica, Arial, sans-serif;
	}
	.large-chart {width:1000px;height:550px;}
	.half-chart {width:500px;height:350px;}
	</style>
	<script language="javascript" type="text/javascript" src="./flot/jquery.min.js"></script>
	<script language="javascript" type="text/javascript" src="./flot/jquery.flot.min.js"></script>
	<script language="javascript" type="text/javascript" src="./flot/jquery.flot.time.min.js"></script>
	<script type="text/javascript">
	$(function() {

	var last_14days = [

	<?php
	$last14DaysSummary = array_slice($last30DaysSummary, -14);
	foreach ($last14DaysSummary as $point)
	{
	$dateTime = new DateTime($point["date"]);
	$unixTimestamp = $dateTime->getTimestamp();
	$javascriptTimeStamp = $unixTimestamp *1000;

	print_r('[');
	print_r($javascriptTimeStamp);
	print_r(',');
	print_r($point["revenue"]);
	print_r('],');
	}
	?>
	];

	var all_t7d = [
	<?php
	foreach ($t7dDates as $point)
	{
	$dateTime = new DateTime($point["date"]);
	$unixTimestamp = $dateTime->getTimestamp();
	$javascriptTimeStamp = $unixTimestamp *1000;

	print_r('[');
	print_r($javascriptTimeStamp);
	print_r(',');
	print_r($point["revenue"]);
	print_r('],');
	}
	?>
	];

	var all_ttm = [
	<?php
	foreach ($revenueDates as $point)
	{
	$dateTime = new DateTime($point["date"]);
	$unixTimestamp = $dateTime->getTimestamp();
	$javascriptTimeStamp = $unixTimestamp *1000;

	print_r('[');
	print_r($javascriptTimeStamp);
	print_r(',');
	print_r($point["revenue"]);
	print_r('],');
	}
	?>
	];

	var options = {
	grid: { hoverable: true, clickable: true, color:"#007AFF" },
	xaxis: { mode: "time", font: { color: "#099eff" } },
	yaxis: { tickDecimals: "2", font: { color: "#099eff" }},
	lines: { show:true },
	legend: { position: "nw" },
	points: {
	radius:2,
	show:true
	},
	colors: ["#FF5E3A","#FF9500","#FFDB4C", "#87FC70", "#007AFF", "#1AD6FD", "#C644FC", "#EF4DB6", "#5856D6" ]
	};

	var rankOptions = {
	grid: { hoverable: true, clickable: true, color:"#007AFF" },
	xaxis: { mode: "time", font: { color: "#099eff" } },
	yaxis: { tickDecimals: "2",
	transform: function (v) { return -v; },
	inverseTransform: function (v) { return -v; },
	font: { color: "#099eff" },
	},
	lines: { show:true },
	legend: { position: "nw", container: $("#flot-top-grossing-legend") },
	points: {
	radius:2,
	show:true
	},
	colors: ["#FF5E3A","#FF9500","#FFDB4C", "#87FC70", "#007AFF", "#1AD6FD", "#C644FC", "#EF4DB6", "#5856D6", "#FF1300" ]
	};


	function showTooltip(x, y, contents) {
	$('<div id="tooltip">' + contents + '</div>').css( {
	position: 'absolute',
	display: 'none',
	top: y + 5,
	left: x + 5,
	border: '1px solid #fdd',
	padding: '2px',
	'background-color': '#fee',
	opacity: 0.80
	}).appendTo("body").fadeIn(200);
	}

	function bindPlotHover(chartId)
	{
	var previousPoint = null;
	$(chartId).bind("plothover", function (event, pos, item) {
	$("#x").text(pos.x.toFixed(2));
	$("#y").text(pos.y.toFixed(2));

	if (item) {
	if (previousPoint != item.dataIndex) {
	previousPoint = item.dataIndex;

	$("#tooltip").remove();
	var x = item.datapoint[0].toFixed(2),
	y = item.datapoint[1].toFixed(2);

	showTooltip(item.pageX, item.pageY,
	item.series.label + " = " + y);
	}
	}
	else {
	$("#tooltip").remove();
	previousPoint = null;
	}
	});
	}

	bindPlotHover("#flot-last-14days-placeholder");
	bindPlotHover("#flot-all-ttm-placeholder");
	bindPlotHover("#flot-t7d-placeholder");

	$.plot("#flot-last-14days-placeholder", [{label:"$", data:last_14days}], options);
	$.plot("#flot-all-ttm-placeholder", [{label:"$", data:all_ttm}], options);
	$.plot("#flot-t7d-placeholder",[{label:"All", data:all_t7d}], options);
	});
	</script>
	</head>
	<body bgcolor="#FFFFFF">
	<div style="width:50%;float:left">
	<h2>Sales Daily Net Revenue</h2>
	<div id="flot-last-14days-placeholder" class="half-chart"></div>
	</div>
	<br style="clear:both;"/>
	<p></p>
	<h2>Net Revenue Trailing 7 Days</h2>
	<div id="flot-t7d-placeholder" class="large-chart"></div>
	<h2>Revenue Trailing Year</h2>
	<div id="flot-all-ttm-placeholder" class="large-chart"></div>
	</body>
	</html>