Master2, saya newbie ni mau membuat grafik pie drildown pada dashboard.
Jadi saya membuat kondisi jika sebagai operation lapangan tidak akan melihat grafik, tetapi saya buat gambar banner saya. Tetapi ketika level managemen/admin dapat melihat.
Saya mencoba pakai json untuk membaca database mssql.
<?php
$userId = Yii::app()->user->id;
$clientId = RoleUserClient::model()->findAll(array('condition'=>'userId ='.$userId));
foreach ($clientId as $clientIds)
{
if ($clientIds['clientId']==273)
{
?>
<h1>Dashboard</h1>
<script src="<?php echo Yii::app()->request->baseUrl; ?>/protected/extensions/highchartsOut/highcharts/assets/highcharts.js"></script>
<script src="<?php echo Yii::app()->request->baseUrl; ?>/protected/extensions/highchartsOut/highcharts/assets/modules/drilldown.src.js"></script>
<script src="<?php echo Yii::app()->request->baseUrl; ?>/protected/extensions/highchartsOut/highcharts/assets/modules/exporting.js"></script>
<script>
<?php
$basic=array();
$totalCar = "Total Car Unit Abhitrans ( ".$totalCarCounts." Unit )";
$titletotal = json_encode ($totalCar);
foreach($dataProvider as $a=>$aa){
$basic[$a]=array("name"=>$aa['carYear'],"y"=>(int)$aa['yearTotal'], "drilldown"=>$aa['carYear']);
$data = json_encode($basic);
//$ab[] = array("id"=>$aa['carYear'],"name"=>$aa['carYear'],"data"=>array(array("name"=>$aa['carYear'],"y"=>(int)$aa['yearTotal'])));
//$dataD = json_encode ($ab);
$carBrand = "SElECT Car.carRegistrarId as carRegistrarId , CarBrandDetail.carBrandDetailDesc as carBrandDetailDesc, Car.carBrandDetailId as carBrandDetailId , COUNT (carId) as carTotal
FROM Car
JOIN CarBrandDetail ON Car.carBrandDetailId = CarBrandDetail.carBrandDetailId
where Car.carRegistrarId = 1
AND Car.active = 1
AND Car.onSale = 0
AND Car.carBrandDetailId != 58 AND Car.carBrandDetailId != 59 AND Car.carBrandDetailId != 60 AND Car.carBrandDetailId != 61 AND Car.carBrandDetailId != 62
and Car.carYear=".$aa['carYear']."
GROUP BY Car.carBrandDetailId, Car.carRegistrarId , CarBrandDetail.carBrandDetailDesc";
$brand = Yii::app()->db->createCommand($carBrand)->query()->readAll();
foreach ($brand as $b => $bb){
$ac[$a] = array("name"=>$bb['carBrandDetailDesc'],"y"=>(int)$bb['carTotal']);
}
$brandChart[$a] = array_merge(array("id"=>$aa['carYear'],"name"=>$aa['carYear']), array("data"=>$ac));
$brandDetail = json_encode ($brandChart);
}
?>
$(function () {
// Internationalization
Highcharts.setOptions({
lang: {
drillUpText: '◁ Back to {series.name}'
}
});
var options = {
chart: {
height: 500,
marginRight: 400
},
credits: {
enabled: false
},
title: {
text: '<?php echo $titletotal;?>'
},
xAxis: {
categories: true
},
drilldown: {
series: <?php echo $brandDetail;?>
},
legend: {
enabled: false
},
plotOptions: {
series: {
dataLabels: {
enabled: true
},
shadow: false
},
pie: {
allowPointSelect: true,
cursor: 'pointer',
dataLabels: {
enabled: false
},
showInLegend: true
}
},
legend: {
layout: 'vertical',
align: 'left',
x: 800,
verticalAlign: 'top',
y: 90,
floating: true,
backgroundColor: '#FFFFFF'
},
series: [{
name: 'Total Car',
colorByPoint: true,
data: <?php echo $data;?>
}]
};
// Column chart
//options.chart.renderTo = ‘container1’;
//options.chart.type = ‘column’;
//var chart1 = new Highcharts.Chart(options);
// Pie
options.chart.renderTo = ‘container2’;
options.chart.type = ‘pie’;
var chart2 = new Highcharts.Chart(options);
});
</script>
</head>
<body>
<!–<div id="container1" style="height: 300px"></div>!–>
<div id="container2" style="height: 100%; width: 100%; margin: 0 auto"></div>
<?php
}
else
{
?>
<img src="<?php echo Yii::app()->request->baseUrl; ?>/images/home.jpg" width="300" />
<?php } }?>
[/php]
Saya ingin membuat grapik seperti gambar yang saya lampirkan. Mohon dibantu para suhu ya