<?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'
                                                                )
                                        ));
                       ?>