public function ajaxRefrigeratorsFreezersUtilizationAction() { $this->_helper->layout->disableLayout(); $ccm_models = new Model_CcmModels(); $form_values['facility_type'] = $this->_request->getParam('facility_type', ''); $form_values['office'] = $this->_request->getParam('office', ''); $form_values['combo1'] = $this->_request->getParam('combo1', ''); $form_values['combo2'] = $this->_request->getParam('combo2', ''); $ccm_models->form_values = $form_values; $data_arr = $ccm_models->refrigeratorFreezersUtilizationGraph(); $main_heading = "Refrigerators/freezers utilization"; $str_sub_heading = ""; $number_prefix = ""; $number_suffix = "%"; $s_number_prefix = ""; $xmlstore = "<?xml version = \"1.0\"?>"; $xmlstore = "<?xml version=\"1.0\"?>"; $xmlstore .= '<chart caption="' . $main_heading . '" numberprefix="' . $number_prefix . '" showvalues="0" exportEnabled="1" rotateValues="1" theme="fint">'; $categories = '<categories>'; $dataset_1 = '<dataset seriesname="In Use" >'; $dataset_2 = '<dataset seriesname="In Store" >'; $dataset_3 = '<dataset seriesname="Not Used" >'; $dataset_4 = '<dataset seriesname="Unknown" >'; $counter = 0; foreach ($data_arr as $sub_arr) { if ($counter >= 10) { break; } $categories .= '<category label="' . $sub_arr['ccm_model_name'] . '" />'; $dataset_1 .= '<set value="' . $sub_arr['inUse'] . '" />'; $dataset_2 .= '<set value="' . $sub_arr['inStore'] . '" />'; $dataset_3 .= '<set value="' . $sub_arr['notUsed'] . '" />'; $dataset_4 .= '<set value="' . $sub_arr['Unknown'] . '" />'; $counter++; } $categories .= '</categories>'; $dataset_1 .= '</dataset>'; $dataset_2 .= '</dataset>'; $dataset_3 .= '</dataset>'; $dataset_4 .= '</dataset>'; $xmlstore .= $categories; $xmlstore .= $dataset_1; $xmlstore .= $dataset_2; $xmlstore .= $dataset_3; $xmlstore .= $dataset_4; $xmlstore .= "</chart>"; $this->view->xmlstore = $xmlstore; $this->view->main_heading = $main_heading; $this->view->str_sub_heading = $str_sub_heading; $this->view->chart_type = 'StackedBar2D'; $this->view->width = '80%'; $this->view->height = '400'; }