public function national_allocation_chart()
{
$str_xml_body = '';
// $title="";
$strXML = "<chart caption='National Allocation' yAxisName='Allocation' alternateVGridColor='AFD8F8' baseFontColor='114B78' toolTipBorderColor='114B78' toolTipBgColor='E7EFF6' useRoundEdges='1' showBorder='0' bgColor='FFFFFF,FFFFFF'>";
$allocations = rtk_stock_status::get_national_allocation();
$counties = counties::getAllcounties();
foreach ($counties as $counties_data) {
$counties_data_id = $counties_data["id"];
}
$districts = districts::getDistrict(2);
// Gets districts within county id 2
foreach ($districts as $districts_data) {
$districts_data_id = $districts_data["id"];
$districts_data_name = $districts_data["district"];
// echo $districts_data_id;
//echo $districts_data_name."<br /><br />";
$facilities = facilities::getFacilities($districts_data_id);
foreach ($facilities as $facilities_data) {
$facilities_data_id = $facilities_data["id"];
$facilities_data_code = $facilities_data["facility_code"];
$allocations = rtk_stock_status::get_county_allocation($facilities_data_code);
$sum_determine = 0;
$sum_unigold = 0;
$sum_syphillis = 0;
$commodity = "";
foreach ($allocations as $allocations_data) {
if ($allocations_data["commodity_id"] == 1) {
$commodity = "Colloidal";
$sum_unigold += $allocations_data["qty"];
}
if ($allocations_data["commodity_id"] == 2) {
$commodity = "First Response";
$sum_determine += $allocations_data["qty"];
}
if ($allocations_data["commodity_id"] == 3) {
$commodity = "Unigold";
$sum_syphillis += $allocations_data["qty"];
}
$allocations_data_commodity_id = $allocations_data["commodity_id"];
}
}
$str_xml_body .= "<set value='{$sum_determine}' label='Total Determine {$districts_data_name}'/>";
$str_xml_body .= "<set value='{$sum_unigold}' label='Reporting Unigold {$districts_data_name}'/>";
$str_xml_body .= "<set value='{$sum_syphillis}' label='Sum Syphillis {$districts_data_name}'/>";
}
echo $str_xml_body;
$strXML .= "{$str_xml_body}</chart>";
echo $strXML;
}
