public static function getAppStats($arrStats, $beginDate, $endDate)
{
//customer acquisition per day
// $ll = new LL_Account();
// $arrw = $ll->getWhere("(macc_acquire_date BETWEEN '$beginDate' AND '$endDate')","macc_acquire_date");
// pr($arrw);
// echo count($arrw);
$data = array();
//for begin date sampai end date day by day
$start = strtotime($beginDate);
$finish = strtotime($endDate);
while ($start < $finish) {
$label = date("d", $start);
$start = strtotime('+1 day', $start);
$xLabels[] = $label;
foreach ($arrStats as $ll => $arrw) {
$data[$ll][$label] = 0;
$data["Transactions Value"][$label] = 0;
}
}
// pr($xLabels);
//manage data
$arrData2 = array();
$colors = array("#00c0ef", "#00a65a", "#f39c12", "#dd4b39");
// pr($arrStats);
foreach ($arrStats as $ll => $arrw) {
foreach ($arrw as $w) {
if ($ll == "Transactions Nr.") {
$curdate = date("d", strtotime($w->TransactionDateTime));
$data[$ll][$curdate]++;
$data["Transactions Value"][$curdate] += $w->Cash_Value / 1000;
}
}
// pr($data);
$arr = array_values($data[$ll]);
// pr($arr);
$c = new Charting();
$c->label = "Nr";
$c->data = $arr;
$c->color = array_pop($colors);
$arrData2[] = $c;
$arr = array_values($data["Transactions Value"]);
// pr($arr);
$c = new Charting();
$c->label = "Value";
$c->data = $arr;
$c->color = array_pop($colors);
$arrData2[] = $c;
}
Charting::chartJSLine("300px", $xLabels, $arrData2, "false", 1, 0, "User Statistic", "info", 1);
// pr($data);
return $data;
}
public static function getAcquire($beginDate, $endDate)
{
//customer acquisition per day
$ll = new LL_Account();
$arrw = $ll->getWhere("(macc_acquire_date BETWEEN '{$beginDate}' AND '{$endDate}')", "macc_acquire_date");
// pr($arrw);
// echo count($arrw);
$data = array();
//for begin date sampai end date day by day
$start = strtotime($beginDate);
$finish = strtotime($endDate);
while ($start <= $finish) {
$label = date("d", $start);
$start = strtotime('+1 day', $start);
$xLabels[] = $label;
$data[$label] = 0;
}
// pr($xLabels);
//manage data
foreach ($arrw as $w) {
$curdate = date("d", strtotime($w->macc_acquire_date));
$data[$curdate]++;
}
// pr($data);
$arr = array_values($data);
// pr($arr);
$c = new Charting();
$c->label = "User Acquisition";
$c->data = $arr;
$c->color = "#AAAAAA";
$arrData2[] = $c;
Charting::chartJSLine("300px", $xLabels, $arrData2, "false", 0, 0, "User Acquisition", "info", 0);
return $arrw;
}
function campaign()
{
$c = new Charting();
$c->color = "#dceade";
$c->label = "enak";
$c->value = 15;
$arrData[] = $c;
$c = new Charting();
$c->color = "#ff0011";
$c->label = "ga enak";
$c->value = 35;
$arrData[] = $c;
$c = new Charting();
$c->color = "#6688aa";
$c->label = "biasa";
$c->value = 75;
$arrData[] = $c;
?>
<div class="col-md-6"><?php
Charting::morrisDonut("300px", $arrData, 1, "Ini morris", "default");
?>
</div>
<div class="col-md-6"><?php
Charting::chartJSPie("300px", $arrData, 50, 1, 1, "Bagan keren");
?>
</div><?php
//for line and area
$xLabels = array("Jan", "Feb", "Mar", "April", "May");
$c = new Charting();
$c->label = "Shoes";
$c->data = array(10, 15, 30, 12, 21);
$c->color = "rgba(255,132,123,0.8)";
$c->strokeColor = "red";
$c->fillColor = "pink";
$c->pointColor = "orange";
$c->pointHighlightStroke = "blue";
$c->pointStrokeColor = "black";
$arrData2[] = $c;
$c = new Charting();
$c->label = "Apparel";
$c->data = array(13, 25, 10, 12, 23);
$c->color = "rgba(255,243,123,0.8)";
$c->strokeColor = "green";
$arrData2[] = $c;
$c = new Charting();
$c->label = "Books";
$c->data = array(11, 15, 16, 13, 33);
$c->color = "rgba(145,255,255,0.8)";
$arrData2[] = $c;
?>
<div class="col-md-6"><?php
Charting::chartJSLine("300px", $xLabels, $arrData2, "false", 1, 1, "data kedua", "info");
?>
</div>
<style>
ul.legend li{
list-style: none;
line-height: 30px;
}
ul.legend li div{
float: left;
margin-top: 10px;
margin-right: 15px;
}
.legend-item{
float: left;
margin: 10px;
line-height: 30px;
margin-right: 20px;
}
.legend-item div{
float: left;
margin-top: 10px;
margin-right: 5px;
}
</style>
<div class="col-md-6">
<?php
Charting::chartJSBar("300px", $xLabels, $arrData2, "false", 1, 1, "data terakhir", "danger");
?>
</div><?php
}
public static function getAppStats($arrStats, $beginDate, $endDate)
{
//customer acquisition per day
// $ll = new LL_Account();
// $arrw = $ll->getWhere("(macc_acquire_date BETWEEN '$beginDate' AND '$endDate')","macc_acquire_date");
// pr($arrw);
// echo count($arrw);
$data = array();
//for begin date sampai end date day by day
$start = strtotime($beginDate);
$finish = strtotime($endDate);
while ($start < $finish) {
$label = date("d", $start);
$start = strtotime('+1 day', $start);
$xLabels[] = $label;
foreach ($arrStats as $ll => $arrw) {
$data[$ll][$label] = 0;
}
}
// pr($xLabels);
//manage data
$arrData2 = array();
$colors = array_reverse(array("#CCCCCC", "#00a65a", "#f39c12", "#dd4b39"));
// pr($arrStats);
foreach ($arrStats as $ll => $arrw) {
foreach ($arrw as $w) {
if ($ll == "Orders") {
$curdate = date("d", strtotime($w->detail_date));
$data[$ll][$curdate] += $w->detail_price_total;
}
if ($ll == "Active Users") {
$curdate = date("d", strtotime($w->log_date));
$data[$ll][$curdate]++;
}
if ($ll == "New Devices") {
$curdate = date("d", strtotime($w->firstlogin));
$data[$ll][$curdate]++;
}
if ($ll == "Active Devices") {
$curdate = date("d", strtotime($w->log_date));
$data[$ll][$curdate]++;
}
}
// pr($data);
$arr = array_values($data[$ll]);
// pr($arr);
$c = new Charting();
$c->label = $ll;
$c->data = $arr;
$c->color = array_pop($colors);
$arrData2[] = $c;
}
// Charting::chartJSLine("300px",$xLabels,$arrData2,"false",1,1);
Charting::chartJSLine("300px", $xLabels, $arrData2, "true", 0, 0, "User Statistic", "info", 1);
// pr($data);
return $data;
}
public static function getAppStats($arrStats, $beginDate, $endDate)
{
//customer acquisition per day
// pr($arrStats);
$data = array();
//for begin date sampai end date day by day
$start = strtotime($beginDate);
$finish = strtotime($endDate);
while ($start < $finish) {
$label = date("d", $start);
$start = strtotime('+1 day', $start);
$xLabels[] = $label;
foreach ($arrStats as $ll => $arrw) {
$data[$ll][$label] = 0;
$data["Transactions Value"][$label] = 0;
}
}
//manage data
$arrData2 = array();
$colors = array("#00c0ef", "#00a65a", "#f39c12", "#dd4b39");
foreach ($arrStats as $ll => $arrw) {
$curdate = date("d", strtotime($arrw->date));
$data["Transactions Value"][$curdate] = $arrw->total_sales / 1000;
$arr = array_values($data["Transactions Value"]);
}
$c = new Charting();
$c->label = "Value";
$c->data = $arr;
$c->color = array_pop($colors);
$arrData2[] = $c;
Charting::chartJSLine("300px", $xLabels, $arrData2, "false", 1, 0, "User Statistic", "info", 1);
// pr($data);
return $data;
}
