package emtit.utils
{
import mx.charts.CategoryAxis;
import mx.charts.series.ColumnSeries;
import mx.charts.series.PieSeries;
import mx.collections.ArrayCollection;
/**
* author:黃建文
* data:2008-12-03
* 圖形數據轉換類
*/
public class ChartDataTransform
{
public function ChartDataTransform()
{
}
/**
*高級圖表分析生成，把datagride的數據轉換為適合圖像顯示的數據
* 返回數據格式如下
* [{keyword1:'張三',keyword1:'10',keyword3:11},{keyword1:'李四',keyword1:'10',keyword3:11}]
*
*/
public static function advanced(sourceData:Array,xaxis:String,yfield:Array):ArrayCollection{
var i:int,j:int;
var obj:Object;
var name:String,field:String;
var returnObj:Object = new Object();
var returnArrC:ArrayCollection=new ArrayCollection;
var nowname:*=null;
var isChange:Boolean=false;
sourceData.sortOn(xaxis);
for(i=0;i<sourceData.length;i++){
for(field in sourceData[i]){
name=sourceData[i][xaxis];
if(name!=nowname){
returnObj[name]=new Object;
returnObj[name][xaxis]=sourceData[i][xaxis];
nowname=name;
}
for(j=0;j<yfield.length;j++){
if(field==yfield[j]['data']){
if(returnObj[name][field]==undefined){
returnObj[name][field]=0;
}
returnObj[name][field]=parseInt(returnObj[name][field])+parseInt(sourceData[i][field]);
// trace('把這個字段'+yfield[j]['data']+'的值'+sourceData[i][field]+'放到Y軸的一個數組中');
}
}
}
}
for each(var num:* in returnObj){
returnArrC.addItem(num);
for(var field2:String in num){
trace(num[xaxis]+'要輸出圖的字段:'+field2);
}
}
return returnArrC;
}
/**
*設置柱圖形categoryField
*/
public static function setCategoryAxis(categoryField:String):CategoryAxis{
var ca:CategoryAxis=new CategoryAxis;
ca.categoryField=categoryField;
return ca;
}
/**
* 設置柱形X軸對應柱狀數據
* xy數組必需為xy=array({lable:'分數'，data:'keyword2'},{lable:'只數'，data:'keyword3'})
* displayName要與setCategoryAxis的值對應
*/
public static function setColumnSeries(yFieldArr:Array,xField:String):Array{
var cs:ColumnSeries;
var rsArr:Array=new Array;
for(var i:int=0;i<yFieldArr.length;i++){
cs=new ColumnSeries;
cs.displayName=yFieldArr[i]['lable'];
cs.xField=xField;
cs.yField=yFieldArr[i]['data'];
rsArr.push(cs);
trace('第'+i+'條柱的屬性，displayName:'+cs.displayName+',xField:'+cs.xField+',yField:'+cs.yField);
}
return rsArr;
}
}
}

<?xml version="1.0" encoding="utf-8"?>
<mx:TitleWindow xmlns:mx="http://www.adobe.com/2006/mxml" creationComplete="init()" layout="absolute" width="468" height="514" showCloseButton="true" close="PopUpManager.removePopUp(this)">
<mx:Script>
<![CDATA[
import mx.automation.delegates.charts.ColumnSeriesAutomationImpl;
import mx.controls.Label;
import mx.charts.series.ColumnSeries;
import mx.charts.chartClasses.Series;
import mx.collections.ArrayCollection;
import yes3d.model.MainModel;
import mx.managers.PopUpManager;

private function init():void{
//下面這三句是數據轉換
ch_column.dataProvider=MainModel.chartData;
ch_column.horizontalAxis=ChartDataTransform.setCategoryAxis('xaxis');
ch_column.series=ChartDataTransform.setColumnSeries([{lable:orderby,data:'value'}],'xaxis');
for(var i:int=0;i<ch_column.series.length;i++){
trace('id:'+ch_column.series[i]['id']+',displayName:'+ch_column.series[i]['displayName']+',yfield:'+ch_column.series[i]['yField']+',xfield:'+ch_column.series[i]['xField']);
}
}
]]>
</mx:Script>
<mx:ViewStack x="0" y="0" id="vs_chart" width="100%" height="100%">
<mx:Canvas id="cv_column" label="柱型圖" width="100%" height="100%">
<mx:ColumnChart id="ch_column" showDataTips="true" x="24" y="61" width="399" height="336">
</mx:ColumnChart>
<mx:Legend dataProvider="{ch_column}"/>
</mx:Canvas>
<mx:Canvas id="cv_pie" label="餅型圖" width="100%" height="100%">
<mx:PieChart id="ch_pie" showDataTips="true" dataProvider="{MainModel.chartData}" x="38" y="48" height="394" width="389">
<mx:series>
<mx:PieSeries nameField="xaxis" field="value"/>
</mx:series>
</mx:PieChart>
<mx:Legend dataProvider="{ch_pie}"/>
</mx:Canvas>
</mx:ViewStack>
</mx:TitleWindow>