[eluser]beben[/eluser]
I want to perform data that have been query in my web database in codeigniter using fusion charts free,, example, i want to show data per month in a year, and in my query when i execute it the data just get january and february..
My purpose is, although march until december is not include in the query result, i still can show it in zero value,, but i don't understand how to do it ?? this is my code.. Thank You..
controller
Code:
function grafikSuratMasuk()
{
$graph_swfFile = base_url().'public/flash/Column3D.swf' ;
$graph_width = '700' ;
$graph_height = '300' ;
//Surat Masuk Eksternal
$query_eks = $this->main_dashboard_model->getTotalSMEksPerBulanTahun();
$total_eks = count($this->main_dashboard_model->getTotalSuratMasukEksternal());
$i = 0 ;
foreach ($query_eks->result() as $p) {
//Konversi Nama Bulan
if($p->bulan=='01'){$p->bulan='Januari';}
else if($p->bulan=='02'){$p->bulan='Februari';}
else if($p->bulan=='03'){$p->bulan='Maret';}
else if($p->bulan=='04'){$p->bulan='April';}
else if($p->bulan=='05'){$p->bulan='Mei';}
else if($p->bulan=='06'){$p->bulan='Juni';}
else if($p->bulan=='07'){$p->bulan='Juli';}
else if($p->bulan=='08'){$p->bulan='Agustus';}
else if($p->bulan=='09'){$p->bulan='September';}
else if($p->bulan=='10'){$p->bulan='Oktober';}
else if($p->bulan=='11'){$p->bulan='Nopember';}
else {$p->bulan='Desember';}
$arrData_eks[$i][1] = $p->bulan;
$arrData_eks[$i][2] = (($p->total_surat_masuk_eksternal/$total_eks)*100);
$i++ ;
}
$strXML = "<graph bgColor='999999,FFFFFF' bgAlpha='50' borderColor='E74759' borderThickness='3' borderAlpha='50' showBorder='1' labelDisplay='Stagger' staggerLines='n' borderThickness='2' borderColor='1D' bgAlpha='100,60,100' caption='' subcaption=''".
"xAxisName='Bulan' yAxisName='Total Surat Masuk Eksternal(%)' outCnvBaseFont='Arial' yAxisMinValue='0' yAxisMaxValue='100' numberSuffix='%' rotateNames='0'".
"formatNumberScale='0' decimalPrecision='2'>";
//Convert data to XML and append
foreach ($arrData_eks as $arSubData_eks) {
$strXML .= "<set name='" . $arSubData_eks[1] . "' value='" . $arSubData_eks[2] . "' color='".getFCColor()."' />";
}
//Close <chart> element
$strXML .= "</graph>";
$data['graph_sm_eks'] = renderChart($graph_swfFile, "surat_masuk_eksternal", $strXML, "sm_eks" , $graph_width, $graph_height,'0', '1');
$data['isicontent']='propinsi/grafik_data/grafik_surat_masuk';
$this->load->view('template/template',$data);
}