public function coverageMissedChildrenAction()
 {
     //campaigns 4.3.2
     $this->_helper->layout->setLayout('reports');
     $data_arr = array();
     $search_form = new Form_ReportsSearch();
     $campaign_data = new Model_CampaignData();
     $form_values['campaign'] = $campaign_id = $this->_request->getParam('campaign', '');
     $form_values['office'] = $office = $this->_request->getParam('office', '');
     $form_values['combo1'] = $province = $this->_request->getParam('combo1', '');
     $form_values['combo2'] = $district = $this->_request->getParam('combo2', '');
     if ($this->_request->isPost()) {
         if ($search_form->isValid($this->_request->getPost())) {
             $form_values = array_merge($form_values, $search_form->getValues());
             $campaign_data->form_values = $form_values;
             $data_arr = $campaign_data->getCoverageMissedChildren();
         }
     }
     $xmlstore = "<?xml version=\"1.0\" encoding=\"UTF-8\"?>";
     $xmlstore .= "<rows>";
     foreach ($data_arr as $sub_arr) {
         $xmlstore .= "<row>";
         $xmlstore .= "<cell><![CDATA[" . $sub_arr['location_name'] . "]]></cell>";
         $xmlstore .= "<cell>" . number_format($sub_arr['totalTarget']) . "</cell>";
         $xmlstore .= "<cell>" . number_format($sub_arr['totalCoverage']) . "</cell>";
         $xmlstore .= "<cell>" . $sub_arr['coveragePer'] . "</cell>";
         $xmlstore .= "<cell>" . number_format($sub_arr['NA']) . "</cell>";
         $xmlstore .= "<cell>" . $sub_arr['NAPer'] . "</cell>";
         $xmlstore .= "<cell>" . number_format($sub_arr['refusal']) . "</cell>";
         $xmlstore .= "<cell>" . $sub_arr['refusalPer'] . "</cell>";
         $xmlstore .= "<cell>" . number_format($sub_arr['total']) . "</cell>";
         $xmlstore .= "<cell>" . $sub_arr['totalPer'] . "</cell>";
         $xmlstore .= "</row>";
     }
     $xmlstore .= "</rows>";
     $campaigns = new Model_Campaigns();
     if ($office == 6 && !empty($district)) {
         $campaigns->form_values['districts'] = $district;
         $campaign_data = $campaigns->getCampaignsByDistrictReports();
     } elseif ($office == 2 && !empty($province)) {
         $campaigns->form_values['province_id'] = $province;
         $campaign_data = $campaigns->getCampaignsByProvince();
     } elseif ($office == 1) {
         $campaign_data = $campaigns->getAllCampaignsNational();
     }
     $this->view->main_heading = "Reported Coverage and missed Children";
     $this->view->report_title = "Reported Coverage and missed Children";
     $this->view->headers = 'Province / areas,Total target population of reporting districts,Reported Coverage,#cspan,Reported unvaccinated children,#cspan,#cspan,#cspan,#cspan,#cspan';
     $this->view->headers1 = '#rspan,#rspan,Children vaccinated,#cspan,Children still unvaccinated from recoreded unvaccinated,#cspan,#cspan,#cspan,#cspan,#cspan';
     $this->view->headers2 = '#rspan,#rspan,#rspan,Not available,#cspan,Refusal,#cspan,Total,#cspan';
     $this->view->headers3 = '#rspan,#rspan,n,%,n,% of target,n,% of target,n,% of target';
     $this->view->rspan = '';
     $this->view->cspan = '#cspan,#cspan,#cspan,#cspan,#cspan,#cspan,#cspan,#cspan,#cspan';
     $this->view->width = '*,150,90,90,90,90,90,90,90,90';
     $this->view->ro = 'ro,ro,ro,ro,ro,ro,ro,ro,ro,ro,ro';
     $this->view->xmlstore = $xmlstore;
     $this->view->data = $data_arr;
     $this->view->search_form = $search_form;
     $this->view->form_values = $form_values;
     $this->view->campaign_data = $campaign_data;
     $this->view->campaign = $campaign_id;
     $this->view->inlineScript()->appendFile(Zend_Registry::get('baseurl') . '/js/all_level_area_combo_report_graph.js');
 }
 public function inventoryListOfAllColdChainEquipmentByFacilityAction()
 {
     //ccem proposed list 3.21 (46)
     $this->_helper->layout->setLayout('reports');
     $search_form = new Form_ReportsSearch();
     $refrigerator_list = array();
     $coldroom_list = array();
     $coldbox_list = array();
     $icepack_list = array();
     $voltageregulator_list = array();
     $generator_list = array();
     $cold_chain = new Model_ColdChain();
     $form_values['office'] = $this->_request->getParam('office', '');
     $form_values['combo1'] = $this->_request->getParam('combo1', '');
     $form_values['combo2'] = $this->_request->getParam('combo2', '');
     $form_values['warehouse'] = $this->_request->getParam('warehouse', '');
     if ($this->_request->isPost()) {
         if ($search_form->isValid($this->_request->getPost())) {
             $form_values = array_merge($form_values, $search_form->getValues());
             $cold_chain->form_values = $form_values;
             $refrigerator_list = $cold_chain->getAllNonQuantityRefAsets();
             $coldroom_list = $cold_chain->getAllNonQuantityColdRoomAsets();
             $coldbox_list = $cold_chain->getAllNonQuantityColdBoxAsets();
             $icepack_list = $cold_chain->getAllNonQuantityIcePackAsets();
             $voltageregulator_list = $cold_chain->getAllNonQuantityVoltageRegulatorAsets();
             $generator_list = $cold_chain->getAllNonQuantityGeneratorAsets();
         }
     }
     $this->view->main_heading = "CCEM Reports";
     $this->view->report_title = "Inventory List of All Cold Chain Equipment By Facility";
     $this->view->refrigerator_list = $refrigerator_list;
     $this->view->coldroom_list = $coldroom_list;
     $this->view->coldbox_list = $coldbox_list;
     $this->view->icepack_list = $icepack_list;
     $this->view->voltageregulator_list = $voltageregulator_list;
     $this->view->generator_list = $generator_list;
     $this->view->form_values = $form_values;
     /* switch ($this->_user_level) {
        case 1:
        case 2:
        case 3:
        case 4:
        case 5:
        case 6:
        $this->view->inlineScript()->appendFile(Zend_Registry::get('baseurl') . '/js/all_level_area_combo_all_coldchain_equipment.js');
        break;
        } */
     $this->view->inlineScript()->appendFile(Zend_Registry::get('baseurl') . '/js/all_level_area_combo_all_coldchain_equipment.js');
 }