public function monthlyConsumption3Action()
{
$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->monthlyConsumtion();
$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']);
}
} else {
$arr_combo = array();
$arr_combo[] = array("key" => "", "value" => "Select");
}
$warehouse_name = $this->_em->getRepository("Warehouses")->find($arr_temp['wh_id']);
$warehouse_name = $warehouse_name->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;
//$form->uc->setValue($arr_temp['loc_id']);
}
if ($this->_request->isPost()) {
$data = $this->_request->getPost();
$warehouse_data = new Model_WarehousesData();
$warehouse_data->form_values = $data;
$result = $warehouse_data->addMonthlyConsumption();
if ($result) {
// Open report in edit form after save
$l3m_dt = new DateTime($data['rpt_date']);
$string = "Z" . base64_encode($data['wh_id'] . '|' . $l3m_dt->format('Y-m-') . '01|2');
$this->redirect("/stock/monthly-consumption?do=" . $string);
}
}
//var_dump($this->_request->do);
//exit;
$this->view->form = $form;
$this->view->do = $this->_request->do;
}
