You are viewing revision #3 of this wiki article.
This is the latest version of this article.
You may want to see the changes made in this revision.
Use this code in your view,make sure to put EAmChartWidget in your extension folder. here is the url of widget http://www.yiiframework.com/extension/eamchartwidget/
<?php
$query ="SELECT count(*) as totalCalls,prov_destname as destination FROM `calls` WHERE status LIKE 'HUNGUP' AND startdate BETWEEN '$dateFrom' AND '$dateTo' AND customerID ='".Yii::app()->session['customerID']."' GROUP BY prov_destname ORDER BY totalCalls DESC LIMIT 5";
$connection = Yii::app()->db;
$command = $connection->createCommand($query);
$Results = $command->queryAll();
$filedlabel ='This week';
$dataProvider=new CArrayDataProvider($Results,
array( 'keyField' =>'callID') );
$this->widget('ext.amcharts.EAmChartWidget',
array(
'width' => 500,
'height' => 200,
'chart'=>array(
'dataProvider'=>$dataProvider,
'categoryField' =>'destination',
'columnWidth'=>'0.2',
'angle' =>'30',
'depth3D' => '15'
),
'chartType' => "AmSerialChart",
'graphs'=>array(
array(
'valueField' => 'totalCalls',
'title'=>'Call',
'type' => 'column',
'balloonText'=>"[[destination]]: [[totalCalls]] call",
'lineAlpha' => '0',
'fillAlphas'=>'0.8',
'fillColors'=>'#B0DE09',
),
),
'categoryAxis'=>array(
'title'=>ucfirst($filedlabel)
),
'valueAxis'=>array(
'title'=>'Total'
)
));
?>
If you have any questions, please ask in the forum instead.
Signup or Login in order to comment.