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; }