public function multipleAdjustmentAction()
{
$stock_master = new Model_StockMaster();
$stock_batch = new Model_StockBatch();
$stock_detail = new Model_StockDetail();
$warehouse_data = new Model_WarehousesData();
$form = new Form_MultipleAdjustment();
$form_values = array();
$temp = array();
$arr_data = array('transaction_number' => "", 'stock_id' => "", 'transaction_date' => date("d/m/Y"), 'warehouse_name' => "", 'success' => $this->_request->success);
$form_values['transaction_type_id'] = 2;
$form_values['adjustment_type'] = 2;
$stock_id = "";
$master_id = "";
if (!empty($this->_request->hdn_stock_id)) {
$stock_id = $this->_request->hdn_stock_id;
}
if (!empty($this->_request->hdn_master_id)) {
$master_id = $this->_request->hdn_master_id;
}
if (!empty($this->_request->warehouse)) {
$warehouse_id = $this->_request->warehouse;
}
if ($this->_request->isPost()) {
$em = Zend_Registry::get('doctrine');
$em->getConnection()->beginTransaction();
try {
if (!empty($master_id)) {
//Start update issue period
$array = $this->_request->getParams();
$stock_master->updateStockPeriod($master_id, $array);
//End update issue period
$transaction_number = $stock_master->updateStockMasterTemp($master_id, $this->_request->comments);
$stock_detail->updateStockDetailTemp($master_id);
//Save Data in warehouse_data table
$warehouse_data->addReport($master_id, 2);
/*
* Auto Receive for 6th level
* $stock_master->autoReceiveData($master_id);
*/
$this->view->msg = 'Stock has been issued successfully. Your voucher number is ';
$this->view->voucher = $transaction_number;
$this->view->master_id = $master_id;
$em->getConnection()->commit();
} elseif ($form->isValid($this->_request->getPost())) {
$editissue = $this->_request->getPost('issueedit');
if ($editissue == "Yes") {
$d_id = $this->_request->getPost('detailid');
$obj_stock_detail = $em->getRepository("StockDetail")->find($d_id);
$old_batch_id = $obj_stock_detail->getStockBatch()->getPkId();
$data = $form->getValues();
$obj_stock_master = $obj_stock_detail->getStockMaster();
$master_update = false;
$arr_date = explode("/", $data['transaction_date']);
if (intval($arr_date[1]) . "-" . intval($arr_date[2]) != intval($obj_stock_detail->getStockMaster()->getTransactionDate()->format("m")) . "-" . intval($obj_stock_detail->getStockMaster()->getTransactionDate()->format("Y"))) {
$trans = $stock_master->getTransactionNumber(2, $data['transaction_date']);
$obj_stock_master->setTransactionNumber($trans['trans_no']);
$obj_stock_master->setTransactionCounter($trans['id']);
$master_update = true;
}
$obj_stock_master->setTransactionDate(new \DateTime(App_Controller_Functions::dateToDbFormat($data['transaction_date'])));
if (!empty($warehouse_id)) {
$to_wh = $em->getRepository("Warehouses")->find($warehouse_id);
$obj_stock_master->setToWarehouse($to_wh);
$master_update = true;
}
if ($master_update) {
$em->persist($obj_stock_master);
$em->flush();
}
$qunty = str_replace(",", "", $data['quantity']);
$obj_stock_detail->setQuantity("-" . $qunty);
$vvms = $this->_em->getRepository("VvmStages")->find($data['vvm_stage']);
$obj_stock_detail->setVvmStage($vvms);
$stock_b = $em->getRepository("StockBatch")->find($data['number']);
$obj_stock_detail->setStockBatch($stock_b);
if (!empty($data['item_unit_id'])) {
$item_unit = $em->getRepository("ItemUnits")->find($data['item_unit_id']);
$obj_stock_detail->setItemUnit($item_unit);
}
$em->persist($obj_stock_detail);
$em->flush();
list($dd, $mm, $yy) = explode("/", $data['transaction_date']);
$item_id = $data['item_id'];
$wh_id = $this->_identity->getWarehouseId();
$user_id = $this->_userid;
$query = "SELECT AdjustQty(" . $data['number'] . "," . $wh_id . ") FROM DUAL";
$str_sql = $em->getConnection()->prepare($query);
$str_sql->execute();
$query = "SELECT AdjustQty(" . $old_batch_id . "," . $wh_id . ") FROM DUAL";
$str_sql = $em->getConnection()->prepare($query);
$str_sql->execute();
$query = "SELECT REPUpdateData({$mm},{$yy},{$item_id},{$wh_id},{$user_id}) FROM DUAL";
$str_sql = $em->getConnection()->prepare($query);
$str_sql->execute();
} else {
$temp = $form->getValues();
$data = array_merge($temp, $form_values);
$data['warehouse'] = $warehouse_id;
if (empty($this->_request->transaction_number)) {
$stock_id = $stock_master->addStockMaster($data);
}
if (isset($data['quantity']) && !empty($data['quantity'])) {
$qty = str_replace(",", "", $data['quantity']);
}
if (isset($data['available_quantity']) && !empty($data['available_quantity'])) {
$ava_qty = str_replace(",", "", $data['available_quantity']);
}
if ((int) $qty > (int) $ava_qty || (int) $qty == (int) $ava_qty) {
$data['quantity'] = $ava_qty;
$autorun = true;
}
list($batch_id, $priority) = explode("|", $this->_request->number);
$form_values['item_unit_id'] = $this->_request->item_unit_id;
$form_values['stock_master_id'] = $stock_id;
$form_values['stock_batch_id'] = $batch_id;
$data = array_merge($temp, $form_values);
$detail_id = $stock_detail->addStockDetail($data);
$stock_batch->adjustQuantityByWarehouse($batch_id);
if ($autorun == true) {
$stock_batch->autoRunningLEFOBatch($form->getValue('item_id'));
$stock_batch->form_values['pk_id'] = $batch_id;
$stock_batch->form_values['status'] = Model_StockBatch::FINISHED;
$stock_batch->changeStatus();
}
/* $placement = new Model_Placements();
$placement->form_values['stock_batch_id'] = $batch_id;
$placement->form_values['quantity'] = $data['quantity'];
$placement->form_values['placement_location_id'] = $data['pick_from'];
$placement->form_values['stock_detail_id'] = $detail_id;
$placement->addPlacement(); */
}
$em->getConnection()->commit();
$this->redirect("/stock/multiple-adjustment");
// For Data Show
$temp_stock_list = $stock_master->getTempStocksList();
if ($temp_stock_list != false) {
// $form->transaction_number->setValue($temp_stock_list[0]['transaction_number']);
$form->transaction_date->setValue(date("d/m/Y h:i A", strtotime($temp_stock_list[0]['transaction_date'])));
$form->warehouse_name->setValue($temp_stock_list[0]['to_warehouse']);
$form->transaction_reference->setValue($temp_stock_list[0]['transaction_reference']);
$form->hdn_to_warehouse_id->setValue($temp_stock_list[0]['to_warehouse_id']);
$form->product->setValue($temp_stock_list[0]['to_warehouse_id']);
$arr_data['warehouse_name'] = $temp_stock_list[0]['to_warehouse'];
// $arr_data['warehouse_name'] = $temp_stock_list[0]['to_warehouse'];
$form->activity_id->setValue($temp_stock_list[0]['activity_id']);
$arr_data['tempstocks'] = $temp_stock_list;
$form->makeFieldReadonly();
} else {
$form->transaction_date->setValue(date("d/m/Y h:i A"));
}
}
} catch (Exception $e) {
$em->getConnection()->rollback();
$em->close();
App_FileLogger::info($e);
switch ($e->getMessage()) {
case 'PLCD_QTY_GREATER_THAN_ISSUE_QTY':
$this->view->status = false;
$this->view->msg = "Issue quantity should not greater than placed quantity!";
break;
}
}
$this->view->form = $form;
$this->view->arr_data = $arr_data;
if ($this->_request->type == 's') {
$this->redirect("/stock/issue-search");
}
}
$stock_master->form_values = $form_values;
$temp_stock = $stock_master->getTempStock();
if ($temp_stock != false) {
$arr_data = array_merge($arr_data, $temp_stock);
}
if (!empty($temp_stock['stock_id'])) {
$form->hdn_stock_id->setValue($temp_stock['stock_id']);
$form->hdn_master_id->setValue($temp_stock['stock_id']);
} elseif (!empty($stockid)) {
$form->hdn_stock_id->setValue($stock_id);
$form->hdn_master_id->setValue($stock_id);
}
$this->view->form = $form;
$base_url = Zend_Registry::get('baseurl');
switch ($this->_user_level) {
case 1:
case 2:
case 3:
$this->view->menu_type = 1;
$this->view->inlineScript()->appendFile($base_url . '/js/all_level_combos.js');
break;
case 4:
case 5:
case 6:
$this->view->menu_type = 2;
$this->view->inlineScript()->appendFile($base_url . '/js/level_combos.js');
break;
}
// Edit Issue Start
if (!empty($this->_request->id)) {
$detail_id = $this->_request->id;
$issue = $this->_em->getRepository("StockDetail")->find($detail_id);
$form->transaction_number->setValue($issue->getStockMaster()->getTransactionNumber());
$form->transaction_date->setValue($issue->getStockMaster()->getTransactionDate()->format("d/m/Y h:i A"));
$form->warehouse_name->setValue($issue->getStockMaster()->getToWarehouse()->getWarehouseName());
$form->transaction_reference->setValue($issue->getStockMaster()->getTransactionReference());
//$form->activity_id->setValue($issue->getStockMaster()->getStakeholderActivity()->getPkId());
$arr_data['warehouse_name'] = $issue->getStockMaster()->getToWarehouse()->getWarehouseName();
$form->item_id->setValue($issue->getStockBatch()->getItemPackSize()->getPkId());
$form->fillBatchCombo($issue->getStockBatch()->getItemPackSize()->getPkId());
$form->number->setValue($issue->getStockBatch()->getPkId());
$form->vvm_stage->setValue($issue->getVvmStage());
$form->quantity->setValue($issue->getQuantity());
$av_qty = $issue->getStockBatch()->getQuantity() + ABS($issue->getQuantity());
$form->available_quantity->setValue($av_qty);
$form->expiry_date->setValue($issue->getStockBatch()->getExpiryDate()->format("d/m/Y"));
$this->view->issueedit = true;
$this->view->detail_id = $this->_request->id;
}
// Edit Issue End
$this->view->arr_data = $arr_data;
$this->view->type = $this->_request->getParam("t", "issue");
$this->view->wh_id = $this->_identity->getWarehouseId();
$this->view->params = array("province" => $this->_identity->getProvinceId(), "district" => $this->_identity->getDistrictId());
$this->view->role = $this->_identity->getRoleId();
}