public function generate_costofordered_chart()
{
$district = $this->session->userdata('district1');
$year = date("Y");
$orderDetails = Ordertbl::get_district_ordertotal($district);
$rowcountname = count($orderDetails);
$arrayQ1 = array();
$arrayQ2 = array();
$arrayQ3 = array();
$arrayQ4 = array();
for ($i = 0; $i < $rowcountname; $i++) {
if ($orderDetails[$i]["month"] >= 1 && $orderDetails[$i]["month"] <= 3) {
$arrayQ2[] = (int) $orderDetails[$i]["OrderTotal"];
} elseif ($orderDetails[$i]["month"] >= 4 && $orderDetails[$i]["month"] <= 6) {
$arrayQ3[] = (int) $orderDetails[$i]["OrderTotal"];
} elseif ($orderDetails[$i]["month"] >= 7 && $orderDetails[$i]["month"] <= 9) {
$arrayQ4[] = (int) $orderDetails[$i]["OrderTotal"];
} else {
$arrayQ1[] = (int) $orderDetails[$i]["OrderTotal"];
}
}
$Q1 = array_sum($arrayQ1);
$Q2 = array_sum($arrayQ2);
$Q3 = array_sum($arrayQ3);
$Q4 = array_sum($arrayQ4);
//exit;
$strXML = "<chart palette='1' lineColor='FF5904' lineAlpha='85' showValues='1' rotateValues='1' valuePosition='auto' xAxisName='Months' yAxisName='Cost of Orders (KES)' yAxisMinValue='15000' showValues='0' useRoundEdges='1' alternateHGridAlpha='20' divLineAlpha='50' canvasBorderColor='666666' canvasBorderAlpha='40' baseFontColor='666666' lineColor='AFD8F8' chartRightMargin = '60' showBorder='0' bgColor='FFFFFF'>\n<set label='Oct-Dec (" . ($year - 1) . ")' value='" . $Q1 . "'/>\n<set label='Jan-Mar (" . $year . ")' value='" . $Q2 . "'/>\n<set label='Apr-Jun (" . $year . ")' value='" . $Q3 . "'/>\n<set label='Jul-Sep (" . $year . ")' value='" . $Q4 . "'/>\n<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;
}
