Yii Framework Wiki
Difference between
#1 and
#2 of
make chart from custome queries using amcharts widget
Revision #2 has been created by Narender Negi on Aug 5, 2013, 8:04:08 AM with the memo:
make chart for custome queries using amcharts widget
« previous (#1) next (#3) »
Changes
Title unchanged
make chart from custome queries using amcharts widget
Category unchanged
How-tos
Yii version unchanged
Tags changed
amcharts with custome query
Content changed
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();
[...]
3 followers
Viewed: 8 656 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
Revisions
View all history-
10 years ago by
trond Added formatting
-
10 years ago by
Narender Negi make chart for custome queries using amc...
- 10 years ago by Narender Negi