public function generate_costofexpiries_chart($option = NULL, $location_id = NULL, $year = NULL)
{
$district = $this->session->userdata('district');
$county_id = $this->session->userdata('county_id');
switch ($option) {
case 'county':
$commodity_array = Facility_Stock::get_county_cost_of_exipries($county_id, $year);
$county_name = counties::get_county_name($county_id);
$title = $county_name[0]["county"] . " County";
$detail = $commodity_array;
// print_r($detail);
break;
default:
$commodity_array = Facility_Stock::get_district_cost_of_exipries($district);
$detail = $commodity_array;
break;
}
//exit;
$strXML = "<chart formatNumberScale='0'\n\t lineColor='000000' lineAlpha='40' showValues='1' rotateValues='1' valuePosition='auto'\n\t palette='1' xAxisName='Months' yAxisName='Cost of Commodities (KES)' yAxisMinValue='15000' showValues='0' useRoundEdges='1' alternateHGridAlpha='20' divLineAlpha='50' canvasBorderColor='666666' canvasBorderAlpha='40' baseFontColor='666666' lineColor='AFD8F8' chartRightMargin = '0' showBorder='0' bgColor='FFFFFF'>";
$temp_array = array();
foreach ($detail as $data) {
$temp_array = array_merge($temp_array, array($data["cal_month"] => $data['total']));
}
for ($i = 1; $i < 13; $i++) {
switch ($i) {
case 1:
if (array_key_exists('Jan', $temp_array)) {
$val = $temp_array['Jan'];
$strXML .= "<set label='Jan' value='{$val}' />";
} else {
$val = 0;
$strXML .= "<set label='Jan' value='{$val}' />";
}
break;
case 2:
if (array_key_exists('Feb', $temp_array)) {
$val = $temp_array['Feb'];
} else {
$val = 0;
}
$strXML .= "<set label='Feb' value='{$val}' />";
break;
case 3:
if (array_key_exists('Mar', $temp_array)) {
$val = $temp_array['Mar'];
} else {
$val = 0;
}
$strXML .= "<set label='Mar' value='{$val}' />";
break;
case 4:
if (array_key_exists('Apr', $temp_array)) {
$val = $temp_array['Apr'];
} else {
$val = 0;
}
$strXML .= "<set label='Apr' value='{$val}' />";
break;
case 5:
if (array_key_exists('May', $temp_array)) {
$val = $temp_array['May'];
} else {
$val = 0;
}
$strXML .= "<set label='May' value='{$val}' />";
break;
case 6:
if (array_key_exists('Jun', $temp_array)) {
$val = $temp_array['Jun'];
} else {
$val = 0;
}
$strXML .= "<set label='Jun' value='{$val}' />";
break;
case 7:
if (array_key_exists('Jul', $temp_array)) {
$val = $temp_array['Jul'];
} else {
$val = 0;
}
$strXML .= "<set label='Jul' value='{$val}' />";
break;
case 8:
if (array_key_exists('Aug', $temp_array)) {
$val = $temp_array['Aug'];
} else {
$val = 0;
}
$strXML .= "<set label='Aug' value='{$val}' />";
break;
case 9:
if (array_key_exists('Sep', $temp_array)) {
$val = $temp_array['Sep'];
} else {
$val = 0;
}
$strXML .= "<set label='Sep' value='{$val}' />";
break;
case 10:
if (array_key_exists('Oct', $temp_array)) {
$val = $temp_array['Oct'];
} else {
$val = 0;
}
$strXML .= "<set label='Oct' value='{$val}' />";
break;
case 11:
if (array_key_exists('Nov', $temp_array)) {
$val = $temp_array['Nov'];
} else {
$val = 0;
}
$strXML .= "<set label='Nov' value='{$val}' />";
break;
case 12:
if (array_key_exists('Dec', $temp_array)) {
$val = $temp_array['Dec'];
} else {
$val = 0;
}
$strXML .= "<set label='Dec' value='{$val}' />";
break;
}
}
$strXML .= "<styles>\n<definition>\n<style name='Anim1' type='animation' param='_xscale' start='0' duration='1'/>\n<style name='Anim2' type='animation' param='_alpha' start='0' duration='0.6'/>\n<style name='DataShadow' type='Shadow' alpha='40'/>\n</definition>\n<application>\n<apply toObject='DIVLINES' styles='Anim1'/>\n<apply toObject='HGRID' styles='Anim2'/>\n<apply toObject='DATALABELS' styles='Anim2'/>\n</application>\n</styles>\n</chart>";
echo $strXML;
}
