Welcome Guest, Not a member yet? Register   Sign In
How to perform data that not include in query result using fusion charts free in codeigniter?
#1

[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);
    }




Theme © iAndrew 2016 - Forum software by © MyBB