public function get_county_drawing_rights_data()
{
$district = $this->session->userdata('district');
$county_id = districts::get_county_id($district);
$county_name = counties::get_county_name($county_id[0]['county']);
$chart_raw_data = facilities::get_county_drawing_rights($county_name[0]['id']);
$category_data = '<categories>';
$allocated_data = "";
$balance_data = "";
$chart_data = '';
$strXML = "<chart palette='3' bgColor='FFFFFF' formatNumberScale='0' showBorder='0' caption='' yAxisName='Units' showValues='0' numVDivLines='10' divLineAlpha='30' useRoundEdges='1' legendBorderAlpha='0'>";
foreach ($chart_raw_data as $chart_data) {
$category_data .= "<category label='{$chart_data['district']}' />";
$allocated_data .= "<set value='{$chart_data['initial_drawing_rights']}' />";
$balance_data .= "<set value='{$chart_data['drawing_rights_balance']}' />";
}
$strXML .= $category_data . "</categories><dataset seriesName='Allocated Drawing ' color='A66EDD' >{$allocated_data}</dataset> <dataset seriesName='Drawing right Bal' color='F6BD0F'>{$balance_data}</dataset>\n\n</chart>";
echo $strXML;
}
