public function listingOfColdRoomFacilitiesAndWorkingStatusAction()
{
//ccem proposed list 3.11 (35)
$this->_helper->layout->setLayout('reports');
$data_arr = array();
$search_form = new Form_ReportsSearch();
$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', '');
if ($this->_request->isPost()) {
if ($search_form->isValid($this->_request->getPost())) {
$form_values = array_merge($form_values, $search_form->getValues());
$ccm_models->form_values = $form_values;
$data_arr = $ccm_models->listingOfColdRoomFacilitiesAndWorkingStatus();
}
}
$xmlstore = "<?xml version=\"1.0\" encoding=\"UTF-8\"?>";
$xmlstore .= "<rows>";
foreach ($data_arr as $sub_arr) {
$xmlstore .= "<row>";
$xmlstore .= "<cell><![CDATA[" . $sub_arr['warehouse_type_name'] . "]]></cell>";
$xmlstore .= "<cell><![CDATA[" . $sub_arr['ccm_model_name'] . "]]></cell>";
$xmlstore .= "<cell><![CDATA[" . $sub_arr['ccm_make_name'] . "]]></cell>";
$xmlstore .= "<cell><![CDATA[" . $sub_arr['asset_type_name'] . "]]></cell>";
$xmlstore .= "<cell>" . $sub_arr['serial_number'] . "</cell>";
$xmlstore .= "<cell>" . $sub_arr['total'] . "</cell>";
$xmlstore .= "<cell>" . $sub_arr['working'] . "</cell>";
$xmlstore .= "<cell>" . $sub_arr['working_per'] . "</cell>";
$xmlstore .= "<cell>" . $sub_arr['needs_service'] . "</cell>";
$xmlstore .= "<cell>" . $sub_arr['needs_service_per'] . "</cell>";
$xmlstore .= "<cell>" . $sub_arr['not_working'] . "</cell>";
$xmlstore .= "<cell>" . $sub_arr['not_working_per'] . "</cell>";
$xmlstore .= "</row>";
}
$xmlstore .= "</rows>";
$this->view->main_heading = "CCEM Reports";
$this->view->report_title = "Listing Of Cold Room Facilities And Working Status";
$this->view->headers = 'Facility Type,Model Name,Manufacturer,Equipment Type,Serial No,Total,Working #,Working %,Working Needs Service #,Working Needs Service %,Not Working #,Not Working %';
$this->view->rspan = '';
$this->view->cspan = '#cspan,#cspan,#cspan,#cspan,#cspan,#cspan,#cspan,#cspan,#cspan,#cspan,#cspan';
$this->view->width = '*,*,*,*,*,*,*,*,*,*,*,*';
$this->view->ro = 'ro,ro,ro,ro,ro,ro,ro,ro,ro,ro,ro,ro';
$this->view->xmlstore = $xmlstore;
$this->view->search_form = $search_form;
$this->view->data = $data_arr;
$search_form->facility_type->setValue($form_values['facility_type']);
$this->view->form_values = $form_values;
$this->view->inlineScript()->appendFile(Zend_Registry::get('baseurl') . '/js/all_level_area_combo_report_graph.js');
}
