public function printMonthlyConsumption2Action() { $this->_helper->layout->setLayout('print-consumption2'); $form = new Form_MonthlyConsumption(); $warehouse = new Model_Warehouses(); $warehouses = $warehouse->getWarehouseNames(); $this->view->warehouses = $warehouses; if (isset($this->_request->do) && !empty($this->_request->do)) { $temp = $this->_request->do; // App_Controller_Functions::pr(base64_decode(substr($temp, 1, strlen($temp) - 1))); $warehouse_data = new Model_WarehousesData(); $warehouse_data->temp = $temp; $arr_temp = $warehouse_data->monthlyConsumtionTemp(); $this->view->month = $arr_temp['month']; $this->view->mm = $arr_temp['mm']; $this->view->year = $arr_temp['yy']; $this->view->is_new_report = $arr_temp['is_new_rpt']; $this->view->prev_month_date = $arr_temp['prev_month_date']; $this->view->check_date = $arr_temp['check_date']; $this->view->first_month = Zend_Registry::get('first_month'); $item_pack_sizes = new Model_ItemPackSizes(); $item_pack_sizes->form_values = array('month' => $arr_temp['mm'], 'year' => $arr_temp['yy'], 'wh_id' => $arr_temp['wh_id']); $items = $item_pack_sizes->monthlyConsumtion2(); $items_non_vaccines = $item_pack_sizes->monthlyConsumtion2_non_vaccinces(); $items_tt = $item_pack_sizes->monthlyConsumtion2_tt(); $warehouse_data->form_values = array('warehouse_id' => $arr_temp['wh_id']); $result = $warehouse_data->getMonthYearByWarehouseId(); if ($result != false) { $arr_combo = array(); $arr_combo[] = array("key" => "", "value" => "Select"); foreach ($result as $row) { $loc_id = $row['location_id']; $do = 'Z' . base64_encode($arr_temp['wh_id'] . '|' . $row['report_year'] . '-' . str_pad($row['report_month'], 2, "0", STR_PAD_LEFT) . '-01' . '|2'); $arr_combo[] = array("key" => $do, "value" => $row['report_month'] . '-' . $row['report_year']); } } $warehouse_id = $arr_temp['wh_id']; $wh = $this->_em->getRepository("Warehouses")->find($warehouse_id); $warehouse_name = $wh->getWarehouseName(); // $form->monthly_report->setMultiOptions($arr_combo); // $form->monthly_report->setValue($temp); $this->view->rpt_date = $arr_temp['rpt_date']; $this->view->wh_id = $arr_temp['wh_id']; $this->view->warehouse_name = $warehouse_name; $this->view->locid = $loc_id; $this->view->items = $items; $this->view->items_non_vaccinces = $items_non_vaccines; $this->view->items_tt = $items_tt; if (!empty($warehouse_id)) { $uc = $wh->getLocation()->getPkId(); $district = $wh->getDistrict()->getPkId(); $province = $wh->getProvince()->getPkId(); $uc_tbl = $this->_em->getRepository("Locations")->find($uc); $uc_name = $uc_tbl->getLocationName(); $this->view->uc_name = $uc_name; $tehsil = $uc_tbl->getParent()->getPkId(); $tehsil_tbl = $this->_em->getRepository("Locations")->find($tehsil); $tehsil_name = $tehsil_tbl->getLocationName(); $this->view->tehsil_name = $tehsil_name; $district_tbl = $this->_em->getRepository("Locations")->find($district); $district_name = $district_tbl->getLocationName(); $this->view->district_name = $district_name; $province_tbl = $this->_em->getRepository("Locations")->find($province); $provinc_name = $province_tbl->getLocationName(); $this->view->provinc_name = $provinc_name; } } // $this->view->form = $form; $this->view->do = $this->_request->do; $this->view->username = $this->_identity->getUserName(); $this->view->print_title = "Monthly Consumption Reporting Form (EPI Center)"; }
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; }