public function ucWise3Action() { $this->_helper->layout->setLayout('reports'); $this->view->report_id = 'UCWISE3'; $this->view->actionpage = 'uc-wise3'; $this->view->parameters = 'TS01IP'; $this->view->parameter_width = '100%'; $item_pack_sizes = new Model_ItemPackSizes(); $warehouses_data = new Model_WarehousesData(); $item = $item_pack_sizes->productsReport(); $locations = new Model_Locations(); $this->view->item_id = $item; if (!empty($this->_request->month_sel) && !empty($this->_request->month_sel)) { $this->view->year_sel = $year = $this->_request->year_sel; $this->view->month_sel = $month = $this->_request->month_sel; } else { $year = date("Y"); if (date('d') > 10) { $month = date("m", strtotime("-1")); } else { $month = date("m", strtotime("-2")); } $this->view->year_sel = $year; $this->view->month_sel = $month; } if (!empty($this->_request->prov_sel)) { $prov_sel = $this->_request->prov_sel; $locations->form_values['geo_level_id'] = '4'; $locations->form_values['province_id'] = $prov_sel; $district = $locations->getLocationsByLevelByProvinceConsumption(); $this->view->district = $district; } else { $prov_sel = 2; $locations->form_values['geo_level_id'] = '4'; $locations->form_values['province_id'] = $prov_sel; $district = $locations->getLocationsByLevelByProvinceConsumption(); $this->view->district = $district; } $this->view->prov_sel = $prov_sel; if (isset($this->_request->stk_sel) && !empty($this->_request->stk_sel)) { $this->view->stk_sel = $sel_stk = $this->_request->stk_sel; } else { $this->view->stk_sel = $sel_stk = 1; } if ($this->_request->prov_sel) { $locations->form_values['pk_id'] = $this->_request->prov_sel; $this->view->location_name = $locations->getLocationName(); } else { $this->view->location_name = "Punjab"; } if ($this->_request->dist_id) { $this->view->in_dist = $this->_request->dist_id; $this->view->sel_dist = $this->_request->dist_id; $locations->form_values['dist_id'] = $this->_request->dist_id; $res = $locations->getLocationsForConsumptionReport(); $distrctName = $locations->getLocationForReport(); // App_Controller_Functions::pr($res); } else { $this->view->in_dist = ''; $this->view->sel_dist = ''; } $items = $item_pack_sizes->monthlyConsumtion2Vaccines(); $items_non_vaccines = $item_pack_sizes->monthlyConsumtion2_non_vaccinces(); $items_tt = $item_pack_sizes->monthlyConsumtion2_tt(); $reportingDate = $this->_request->year_sel . '-' . $this->_request->month_sel . '-01'; $fileName = 'UCWise3_' . $distrctName . '_for_' . date('M-Y', strtotime($reportingDate)); $this->view->file_name = $fileName; $this->view->sel_item = $this->_request->prod_sel; $stakeholder = new Model_Stakeholders(); $stk = $stakeholder->nationReport(); $this->view->stk = $stk; $locations = new Model_Locations(); $lct = $locations->conusmptionReportLocations(); $this->view->location = $lct; $this->view->result = $res; $this->view->items = $items; $this->view->items_non_vaccinces = $items_non_vaccines; $this->view->items_tt = $items_tt; }