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