make chart from custome queries using amcharts widget

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.

« previous (#2)

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

Revisions

View all history