34k+
make chart from custome queries using amcharts widget
Revision #2 was created by 
make chart for custome queries using amcharts widget
Tags
amcharts with custome query
Content
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();
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();
[...]