make chart from custome queries using amcharts widget

You are viewing revision #1 of this wiki article.
This version may not be up to date with the latest version.
You may want to view the differences to the latest version.

next (#2) »

<?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'
                                                                )
                                        ));
                       ?>
0 0
3 followers
Viewed: 8 598 times
Version: Unknown (update)
Category: How-tos
Written by: Narender Negi
Last updated by: trond
Created on: Aug 5, 2013
Last updated: 10 years ago
Update Article

Revisions

View all history