public function get_county_ordering_rate_chart() { $district = $this->session->userdata('district'); $county_id = districts::get_county_id($district); $county_name = counties::get_county_name($county_id[0]['county']); $districts_in_this_county = districts::getDistrict($county_name[0]['id']); $category_data = '<categories>'; $orders_made_data = ""; $total_no_of_facilities = ""; $strXML = "<chart stack100Percent='1' showPercentValues='1' palette='2' bgColor='FFFFFF' formatNumberScale='0' showBorder='0' showLabels='1' showvalues='0' numberPrefix='' showSum='1' decimals='0' useRoundEdges='1' legendBorderAlpha='0'>"; foreach ($districts_in_this_county as $chart_data) { $category_data .= "<category label='{$chart_data->district}' />"; $district_data = facilities::get_orders_made_in_district($chart_data->id); $orders_made_data .= "<set value='{$district_data['orders_made_data']}' />"; $bal = $district_data['total_no_of_facilities'] - $district_data['orders_made_data']; $total_no_of_facilities .= "<set value='{$bal}'/>"; } $strXML .= $category_data . "</categories><dataset seriesName='Orders Made' color='659EC7' showValues='0'>{$orders_made_data}</dataset><dataset seriesName='Orders not made' color='E8E8E8' showValues='0'>{$total_no_of_facilities}</dataset></chart>"; echo $strXML; }