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