public function ajaxVaccineStorageCapacityAt2to8Action()
 {
     $this->_helper->layout->disableLayout();
     $ccm_warehouse = new Model_CcmWarehouses();
     $form_values['office'] = $this->_request->getParam('office', '');
     $form_values['combo1'] = $this->_request->getParam('combo1', '');
     $form_values['combo2'] = $this->_request->getParam('combo2', '');
     $ccm_warehouse->form_values = $form_values;
     $data_arr = $ccm_warehouse->vaccineStorageCapacityAt2to8Graph();
     $main_heading = "Vaccine storage capacity at +2C to +8C";
     $str_sub_heading = "";
     $number_prefix = "";
     $number_suffix = "%";
     $s_number_prefix = "";
     $xmlstore = "<?xml version=\"1.0\"?>";
     $xmlstore .= '<chart caption="' . $main_heading . '" numberprefix="' . $number_prefix . '" showvalues="0" showplotborder="1" plotfillalpha="80" showborder="0" exportEnabled="1" rotateValues="1" theme="fint">';
     $categories = '<categories>';
     $dataset_1 = '<dataset seriesname="Surplus > 30%" >';
     //$dataset_2 = '<dataset seriesname="Surplus 10-30%" >';
     $dataset_3 = '<dataset seriesname="Match +/- 30%" >';
     //$dataset_4 = '<dataset seriesname="Shortage 10-30%" >';
     $dataset_5 = '<dataset seriesname="Shortage > 30%" color = "#A80000">';
     $dataset_6 = '<dataset seriesname="Data Not Available" color = "#F5D133">';
     foreach ($data_arr as $sub_arr) {
         $categories .= '<category label="' . $sub_arr['FacilityType'] . '" />';
         $dataset_1 .= '<set value="' . $sub_arr['surplus30'] . '" />';
         //$dataset_2 .= '<set value="' . $sub_arr['surplus1030'] . '" />';
         $dataset_3 .= '<set value="' . ($sub_arr['match10'] + $sub_arr['surplus1030'] + $sub_arr['shortage1030']) . '" />';
         //$dataset_4 .= '<set value="' . $sub_arr['shortage1030'] . '" />';
         $dataset_5 .= '<set value="' . $sub_arr['shortage30'] . '" />';
         $dataset_6 .= '<set value="' . $sub_arr['Unknown'] . '" />';
     }
     $categories .= '</categories>';
     $dataset_1 .= '</dataset>';
     //$dataset_2 .= '</dataset>';
     $dataset_3 .= '</dataset>';
     //$dataset_4 .= '</dataset>';
     $dataset_5 .= '</dataset>';
     $dataset_6 .= '</dataset>';
     $xmlstore .= $categories;
     $xmlstore .= $dataset_1;
     //$xmlstore .= $dataset_2;
     $xmlstore .= $dataset_3;
     //$xmlstore .= $dataset_4;
     $xmlstore .= $dataset_5;
     $xmlstore .= $dataset_6;
     $xmlstore .= "</chart>";
     $this->view->main_heading = $main_heading;
     $this->view->str_sub_heading = $str_sub_heading;
     $this->view->chart_type = "StackedBar2D";
     $this->view->xmlstore = $xmlstore;
     $this->view->width = '100%';
     $this->view->height = '400';
     $this->view->data = $data_arr;
 }
 public function vaccineStorageCapacityAt2to8Action()
 {
     $this->_helper->layout->disableLayout();
     $ccm_warehouse = new Model_CcmWarehouses();
     $form_values['office'] = $this->_request->getParam('level', '');
     $form_values['combo1'] = $this->_request->getParam('province', '');
     $form_values['combo2'] = $this->_request->getParam('district', '');
     $ccm_warehouse->form_values = $form_values;
     $data_arr = $ccm_warehouse->vaccineStorageCapacityAt2to8Graph();
     $main_heading = "Vaccine storage capacity at +2c to +8c";
     $str_sub_heading = "";
     $number_prefix = "";
     $number_suffix = "%";
     $s_number_prefix = "";
     $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="Surplus > 30%" >';
     $dataset_2 = '<dataset seriesname="Surplus 10-30%" >';
     $dataset_3 = '<dataset seriesname="Match +/- 30%" >';
     $dataset_4 = '<dataset seriesname="Shortage 10-30%" >';
     $dataset_5 = '<dataset seriesname="Shortage > 30%" >';
     foreach ($data_arr as $sub_arr) {
         $categories .= '<category label="' . $sub_arr['FacilityType'] . '" />';
         $dataset_1 .= '<set value="' . $sub_arr['surplus30'] . '" />';
         $dataset_2 .= '<set value="' . $sub_arr['surplus1030'] . '" />';
         $dataset_3 .= '<set value="' . $sub_arr['match10'] . '" />';
         $dataset_4 .= '<set value="' . $sub_arr['shortage1030'] . '" />';
         $dataset_5 .= '<set value="' . $sub_arr['shortage30'] . '" />';
     }
     $categories .= '</categories>';
     $dataset_1 .= '</dataset>';
     $dataset_2 .= '</dataset>';
     $dataset_3 .= '</dataset>';
     $dataset_4 .= '</dataset>';
     $dataset_5 .= '</dataset>';
     $xmlstore .= $categories;
     $xmlstore .= $dataset_1;
     $xmlstore .= $dataset_2;
     $xmlstore .= $dataset_3;
     $xmlstore .= $dataset_4;
     $xmlstore .= $dataset_5;
     $xmlstore .= "</chart>";
     $this->view->main_heading = $main_heading;
     $this->view->str_sub_heading = $str_sub_heading;
     $this->view->chart_type = "StackedColumn2DLine";
     $this->view->xmlstore = $xmlstore;
     $this->view->width = '100%';
     $this->view->height = '400';
 }