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