public function ajaxUpdatePhysicalCurrentQuantityAction()
{
$this->_helper->layout->disableLayout();
$this->_helper->viewRenderer->setNoRender(TRUE);
$wh_id = $this->_identity->getWarehouseId();
$data = explode("|", substr($this->_request->data, 0, -1));
$count = count($data);
$physical_quantity = 0;
$current_quantity = 0;
$em = Zend_Registry::get('doctrine');
$em->getConnection()->beginTransaction();
try {
for ($i = 0; $i < $count; $i++) {
$flag = 0;
$placement_physical_summary = $this->_em->getRepository("PhysicalStockTakingDetail")->find($data[$i]);
if ($placement_physical_summary->getStockBatch() != "") {
//$physical_quantity = $placement_physical_summary->getQuantity();
$current_quantity = $placement_physical_summary->getStockBatch()->getQuantity();
$batch_id = $placement_physical_summary->getStockBatch()->getPkId();
$stk_master = new Model_StockMaster();
$physical_quantity = $stk_master->getPhysicalBatchQuantity($batch_id);
/* $already_exists = $this->_em->getRepository("PhysicalStockTakingDetail")->findBy(array("stockBatch" => $batch_id, "warehouse" => $this->_identity->getWarehouseId()));
if (count($already_exists) > 0) {
foreach ($already_exists as $physical_stk) {
if ($physical_stk->getPkId() != $placement_physical_summary->getPkId()) {
$physical_quantity = $physical_quantity + $physical_stk->getQuantity();
}
}
} */
if ($current_quantity > $physical_quantity) {
$quantity = $current_quantity - $physical_quantity;
$type = 13;
$placement_physical_summary->setCurrentQuantity($current_quantity);
$this->_em->persist($placement_physical_summary);
$this->_em->flush();
} else {
if ($current_quantity < $physical_quantity) {
$quantity = $physical_quantity - $current_quantity;
$type = 12;
$placement_physical_summary->setCurrentQuantity($current_quantity);
$this->_em->persist($placement_physical_summary);
$this->_em->flush();
} else {
if ($current_quantity == $physical_quantity) {
$flag = 1;
$stock_detail = null;
}
}
}
} else {
$stock_batch_model = new Model_StockBatch();
$batch_number = $placement_physical_summary->getBatchNumber();
$item_pack_size_id = $placement_physical_summary->getItemPackSize()->getPkId();
//$production_date = ($placement_physical_summary->getProductionDate() != null) ? $placement_physical_summary->getProductionDate()->format("d/m/Y") : '';
$expiry_date = $placement_physical_summary->getExpiryDate()->format("d/m/Y");
$vvm_type_id = 2;
//$manufacturer_id = $this->_em->getRepository("StakeholderItemPackSizes")->findBy(array('itemPackSize' => $placement_physical_summary->getItemPackSize()->getPkId()));
$array = array('number' => $batch_number, 'quantity' => $placement_physical_summary->getQuantity(), 'item_id' => $item_pack_size_id, 'production_date' => '', 'expiry_date' => $expiry_date, 'unit_price' => '0', 'vvm_type_id' => $vvm_type_id, 'manufacturer_id' => $placement_physical_summary->getStakeholderItemPackSize());
$batch_id = $stock_batch_model->createBatch($array);
$type = 12;
$quantity = 0;
$multi_batches = $this->_em->getRepository("PhysicalStockTakingDetail")->findBy(array("batchNumber" => $batch_number, "warehouse" => $this->_identity->getWarehouseId(), "physicalStockTaking" => Model_PhysicalStockTakingDetail::STOCKID));
if (count($multi_batches) > 0) {
foreach ($multi_batches as $add_batch_id) {
$add_batch_id->setCurrentQuantity($current_quantity);
$ba_id01 = $this->_em->getRepository('StockBatch')->find($batch_id);
$add_batch_id->setStockBatch($ba_id01);
$this->_em->persist($add_batch_id);
$this->_em->flush();
$quantity += $add_batch_id->getQuantity();
}
}
}
if ($flag == 0) {
$tranaction_type = new Model_TransactionTypes();
$type_nature = $tranaction_type->findById($type);
$stock_batch_vvm = new StockBatchVvm();
$stock_batch_vvm->setQuantity($type_nature['0']['nature'] . $quantity);
$stock_batch_vvm->setVvmStage($placement_physical_summary->getVvmStage());
$ba_id1 = $this->_em->getRepository('StockBatch')->find($batch_id);
$stock_batch_vvm->setStockBatch($ba_id1);
$this->_em->persist($stock_batch_vvm);
$this->_em->flush();
$stock_batch_vvm_id = $stock_batch_vvm->getPkId();
$stock_batch_vvm_history = new StockBatchVvmHistory();
$stock_batch_vvm_ID = $this->_em->getRepository('StockBatchVvm')->find($stock_batch_vvm_id);
$stock_batch_vvm_history->setStockBatchVvm($stock_batch_vvm_ID);
$stock_batch_vvm_history->setQuantity($type_nature['0']['nature'] . $quantity);
$stock_batch_vvm_history->setVvmStage($placement_physical_summary->getVvmStage());
$ba_id2 = $this->_em->getRepository('StockBatch')->find($batch_id);
$stock_batch_vvm_history->setStockBatch($ba_id2);
$this->_em->persist($stock_batch_vvm_history);
$this->_em->flush();
$stock_master = new StockMaster();
$stock_master->setTransactionDate(new \DateTime(date('Y-m-d')));
$tran_type = $this->_em->getRepository('TransactionTypes')->find($type);
$stock_master->setTransactionType($tran_type);
$warehouse_id = $this->_em->getRepository('Warehouses')->find($wh_id);
$stock_master->setFromWarehouse($warehouse_id);
$stock_master->setToWarehouse($warehouse_id);
$created_by = $this->_em->getRepository('Users')->find($this->_userid);
$stock_master->setCreatedBy($created_by);
$stock_master->setCreatedDate(new \DateTime(date("Y-m-d")));
$adjustment_date = date('d/m/Y');
$sm = new Model_StockMaster();
$trans = $sm->getTransactionNumber($type, $adjustment_date);
$stock_master->setTransactionNumber($trans['trans_no']);
$stock_master->setDraft(0);
$stock_master->setTransactionCounter($trans['id']);
$stock_master->setParentId(0);
$this->_em->persist($stock_master);
$this->_em->flush();
$stock_detail = new StockDetail();
$stock_detail->setStockMaster($stock_master);
$b_id = $this->_em->getRepository('StockBatch')->find($batch_id);
$stock_detail->setStockBatch($b_id);
$stock_detail->setQuantity($type_nature[0]['nature'] . $quantity);
$stock_detail->setAdjustmentType($type);
$stock_detail->setVvmStage($placement_physical_summary->getVvmStage());
$stock_detail->setTemporary(0);
$stock_detail->setItemUnit($placement_physical_summary->getItemPackSize()->getItemUnit());
$this->_em->persist($stock_detail);
$this->_em->flush();
$stock_ID = $stock_master->getPkId();
$stock_batch = new Model_StockBatch();
$warehouse_data = new Model_WarehousesData();
$stock_batch->adjustQuantityBywarehouse($batch_id);
$warehouse_data->addReport($stock_ID, $type);
$placement_physical_summary->setStockMaster($stock_master);
$this->_em->persist($placement_physical_summary);
$this->_em->flush();
}
$already_exists = $this->_em->getRepository("PhysicalStockTakingDetail")->findBy(array("stockBatch" => $batch_id, "warehouse" => $this->_identity->getWarehouseId(), "physicalStockTaking" => Model_PhysicalStockTakingDetail::STOCKID));
if (count($already_exists) > 0) {
foreach ($already_exists as $physical_stk) {
if ($physical_stk->getPlacementLocation() != null && $physical_stk->getQuantity() > 0) {
$placement = new Placements();
$placement->setQuantity($physical_stk->getQuantity());
$placement->setPlacementLocation($physical_stk->getPlacementLocation());
$placement->setStockBatch($physical_stk->getStockBatch());
if ($stock_detail != null) {
$placement->setStockDetail($stock_detail);
}
$type_id = $this->_em->getRepository("ListDetail")->find(114);
$placement->setPlacementTransactionType($type_id);
$created_by = $this->_em->getRepository("Users")->find($this->_userid);
$placement->setCreatedBy($created_by);
$placement->setIsPlaced(1);
$placement->setCreatedDate(new \DateTime(date("Y-m-d")));
$vvm = $physical_stk->getVvmStage();
$placement->setVvmStage($vvm);
$this->_em->persist($placement);
$this->_em->flush();
}
}
}
}
$em->getConnection()->commit();
echo 1;
} catch (Exception $e) {
$em->getConnection()->rollback();
$em->close();
echo 0;
}
}
public function uploadReceiveConsignments()
{
$params = $this->form_values;
$wh_id = $params['wh_id'];
$rec_id = $params['rec_id'];
$batch_no = $params['batch_no'];
$qty = str_replace(",", "", $params['qty']);
$voucher = $params['voucher'];
$consignments_location = $this->_em->getRepository("PipelineConsignmentsPlacements")->findBy(array("pipelineConsignment" => $rec_id));
if (count($consignments_location) > 0) {
foreach ($consignments_location as $cl) {
$location_id[] = $cl->getPlacementLocation()->getPkId();
}
}
$str_qry = $this->_em->createQueryBuilder()->select("pc.masterId")->from("PipelineConsignments", "pc")->where("pc.voucherNumber = '" . $voucher . "'")->andWhere("pc.masterId > 0")->andWhere("pc.toWarehouse = " . $wh_id);
$stock_master_id = $str_qry->getQuery()->getResult();
if (count($stock_master_id) > 0) {
$master_id = $stock_master_id[0]['masterId'];
} else {
$master_id = 0;
}
$pipeline_consignments = $this->_em->getRepository("PipelineConsignments")->find($rec_id);
/**
* Record must exists
*/
if (count($pipeline_consignments) == 0) {
$result_msg = array("message" => "Selected record id {$rec_id} does not exist in pipeline consignments. Please update your data.");
App_FileLogger::info($result_msg['message']);
return $result_msg;
}
/**
* Check if we need to create new voucher or add detail entry in existing voucher
* If 0 then New Voucher
* If greater then 0 then Add in Existing voucher
*/
if ($master_id == 0) {
$tr_date = date("d/m/Y");
$obj_master = new Model_StockMaster();
$trans = $obj_master->getTransactionNumber(1, $tr_date, $wh_id);
$stock_master = new StockMaster();
$stock_master->setTransactionDate(new DateTime());
$stock_master->setTransactionNumber($trans['trans_no']);
$stock_master->setTransactionCounter($trans['id']);
$stock_master->setTransactionReference($pipeline_consignments->getReferenceNumber());
$stock_master->setDraft(0);
$stock_master->setComments($pipeline_consignments->getDescription());
$type = $this->_em->getRepository("TransactionTypes")->find(1);
$stock_master->setTransactionType($type);
$stock_master->setFromWarehouse($pipeline_consignments->getFromWarehouse());
$stock_master->setToWarehouse($pipeline_consignments->getToWarehouse());
$stock_master->setParentId(0);
$stock_master->setStakeholderActivity($pipeline_consignments->getStakeholderActivity());
$stock_master->setCreatedBy($pipeline_consignments->getCreatedBy());
$stock_master->setCreatedDate(new DateTime(date("Y-m-d H:i:s")));
$this->_em->persist($stock_master);
$this->_em->flush();
$master_id = $stock_master->getPkId();
}
$array = array("item_id" => $pipeline_consignments->getItemPackSize()->getPkId(), "number" => $batch_no, "wh_id" => $pipeline_consignments->getToWarehouse()->getPkId());
$batch_id = $this->checkBatch($array);
/**
* Check if Batch exists or not
* If 0 then create new batch
* If greater then 0 then add quantity in existing batch
*/
if ($batch_id === 0) {
$stock_batch = new StockBatch();
$stock_batch->setNumber(strtoupper($batch_no));
$stock_batch->setExpiryDate($pipeline_consignments->getExpiryDate());
$stock_batch->setQuantity($qty);
$stock_batch->setStatus('Stacked');
$stock_batch->setUnitPrice(0);
$stock_batch->setProductionDate($pipeline_consignments->getProductionDate());
$stock_batch->setLastUpdate(new DateTime(date("Y-m-d")));
$stock_batch->setItemPackSize($pipeline_consignments->getItemPackSize());
$vvm_type = $this->_em->getRepository("VvmTypes")->find(2);
$stock_batch->setVvmType($vvm_type);
$stock_batch->setWarehouse($pipeline_consignments->getToWarehouse());
$stock_batch->setStakeholderItemPackSize($pipeline_consignments->getManufacturer());
$this->_em->persist($stock_batch);
$this->_em->flush();
$batch_id = $stock_batch->getPkId();
}
/*
* Add Entry in stock detail against selected master voucher
*/
$stock_detail = new StockDetail();
$stock_detail->setQuantity($qty);
$stock_detail->setTemporary(0);
$vvms = $this->_em->getRepository("VvmStages")->find(1);
$stock_detail->setVvmStage($vvms);
$stock_detail->setIsReceived(1);
$stock_detail->setAdjustmentType(1);
$stock_master = $this->_em->getRepository("StockMaster")->find($master_id);
$stock_detail->setStockMaster($stock_master);
$stock_batch = $this->_em->getRepository("StockBatch")->find($batch_id);
$stock_detail->setStockBatch($stock_batch);
$stock_detail->setItemUnit($pipeline_consignments->getItemPackSize()->getItemUnit());
$this->_em->persist($stock_detail);
$this->_em->flush();
if (count($location_id) > 0) {
foreach ($location_id as $plac_id) {
$plac_loc_id = $this->_em->getRepository("PlacementLocations")->find($plac_id);
/*
* Add entry in Placement table
*/
$placements = new Placements();
$placements->setQuantity($qty);
$vvms = $this->_em->getRepository("VvmStages")->find(1);
$placements->setVvmStage($vvms);
$placements->setIsPlaced(1);
$placements->setPlacementLocation($plac_loc_id);
$placements->setStockBatch($stock_batch);
$placements->setStockDetail($stock_detail);
$trans_type = $this->_em->getRepository("ListDetail")->find(Model_ListDetail::STOCK_PLACEMENT);
$placements->setPlacementTransactionType($trans_type);
$placements->setCreatedBy($pipeline_consignments->getCreatedBy());
$placements->setCreatedDate(new DateTime(date("Y-m-d H:i:s")));
$this->_em->persist($placements);
$this->_em->flush();
}
}
/*
* Update Received Qty in Future Arrivals table
*/
//$update_qty = $pipeline_consignments->getReceivedQuantity() + $qty;
//if ($update_qty <= $pipeline_consignments->getQuantity()) {
$pipeline_consignments->setReceivedQuantity($qty);
$pipeline_consignments->setMasterId($master_id);
$this->_em->persist($pipeline_consignments);
$this->_em->flush();
//}
/*
* Adjust Batch Quantity By Warehouse
*/
$this->adjustQuantityByWarehouse($batch_id, $pipeline_consignments->getToWarehouse()->getPkId());
/*
* Adjust Warehouse data for selected month and item
*/
$warehouse_data = new Model_WarehousesData();
$warehouse_data->form_values = array('report_month' => date("m"), 'report_year' => date("Y"), 'item_id' => $pipeline_consignments->getItemPackSize()->getPkId(), 'warehouse_id' => $pipeline_consignments->getToWarehouse()->getPkId(), 'created_by' => $pipeline_consignments->getCreatedBy()->getPkId());
$warehouse_data->adjustStockReport();
$stock_master = $this->_em->getRepository("StockMaster")->find($master_id);
return "V" . base64_encode($stock_master->getTransactionNumber() . "|" . $stock_master->getPkId());
}
public function addStockMasterTemp($array)
{
// App_Controller_Functions::pr($array);
$to_warehouse_id = $array['hdn_receive_warehouse_id'];
$from_warehouse_id = $this->_identity->getWarehouseId();
$transaction_date = App_Controller_Functions::dateToDbFormat($array['transaction_date']);
$str_qry = "SELECT stock_master.pk_id\n FROM\n stock_master\n where\n stock_master.to_warehouse_id='{$to_warehouse_id}'\n and stock_master.from_warehouse_id = '{$from_warehouse_id}'\n and stock_master.draft=1 and stock_master.transaction_type_id = 2 AND DATE_FORMAT(\n stock_master.transaction_date,\n '%Y-%m-%d'\n ) = '{$transaction_date}' ";
$this->_em = Zend_Registry::get('doctrine');
$row = $this->_em->getConnection()->prepare($str_qry);
$row->execute();
$result = $row->fetchAll();
$stock_master_id = $result[0]['pk_id'];
$detail = $this->_em->getRepository("StockDetail")->findBy(array("stockMaster" => $stock_master_id));
if (count($detail) > 0) {
$master = $detail[0]->getStockMaster();
foreach ($detail as $row) {
$this->_em->remove($row);
}
$this->_em->remove($master);
$this->_em->flush();
}
$stock_master = new StockMaster();
$type = $array['transaction_type_id'];
$time_arr = explode(' ', $array['transaction_date']);
$time = date('H:i:s', strtotime($time_arr[1] . $time_arr[2]));
$stock_master->setTransactionDate(new \DateTime(App_Controller_Functions::dateToDbFormat($time_arr[0]) . '' . $time));
$tran_type = $this->_em->getRepository('TransactionTypes')->find($type);
$stock_master->setTransactionType($tran_type);
$stock_master->setTransactionReference($array['transaction_reference']);
$created_by = $this->_em->getRepository('Users')->find($this->_user_id);
$stock_master->setCreatedBy($created_by);
$stock_master->setModifiedBy($created_by);
$stock_master->setParentId(0);
$stock_master->setCreatedDate(App_Tools_Time::now());
$stock_master->setModifiedDate(App_Tools_Time::now());
$activity_id = $this->_em->getRepository('StakeholderActivities')->find($array['hdn_activity_id']);
$stock_master->setStakeholderActivity($activity_id);
if (!empty($array['campaign_id'])) {
$stock_master->setCampaignId($array['campaign_id']);
}
if (!empty($array['dispatch_by'])) {
$stock_master->setDispatchBy($array['dispatch_by']);
}
//$trans = $this->getTransactionNumber($type, $array['transaction_date']);
if ($type == 1) {
$from_warehouse_id = $this->_em->getRepository('Warehouses')->find($array['from_warehouse_id']);
$stock_master->setFromWarehouse($from_warehouse_id);
$to_warehouse_id = $this->_em->getRepository('Warehouses')->find($this->_identity->getWarehouseId());
$stock_master->setToWarehouse($to_warehouse_id);
} else {
if ($type == 2) {
$from_warehouse_id = $this->_em->getRepository('Warehouses')->find($this->_identity->getWarehouseId());
$stock_master->setFromWarehouse($from_warehouse_id);
$to_warehouse_id = $this->_em->getRepository('Warehouses')->find($array['hdn_receive_warehouse_id']);
$stock_master->setToWarehouse($to_warehouse_id);
}
}
$stock_master->setComments($array['comments']);
$stock_master->setTransactionNumber('TEMP');
$stock_master->setDraft(1);
$this->_em->persist($stock_master);
$this->_em->flush();
$id = $stock_master->getPkId();
//echo $id;
//exit;
return $id;
}
public function setParentId($parentId)
{
$this->__load();
return parent::setParentId($parentId);
}
public function addStockMasterTemp($array)
{
// App_Controller_Functions::pr($array);
$to_warehouse_id = $array['hdn_receive_warehouse_id'];
$from_warehouse_id = $this->_identity->getWarehouseId();
$str_qry_del = "DELETE stock_detail.*,stock_master.*\n FROM\n stock_detail,stock_master\n where\n stock_master.pk_id = stock_detail.stock_master_id\n and stock_master.to_warehouse_id='{$to_warehouse_id}'\n and stock_master.from_warehouse_id = '{$from_warehouse_id}'\n and stock_master.draft=1 and stock_master.transaction_type_id = 2";
$this->_em = Zend_Registry::get('doctrine');
$row = $row = $this->_em->getConnection()->prepare($str_qry_del);
$row->execute();
if (!empty($array['hdn_stock_master_id'])) {
$hdn_stock_master_id = $array['hdn_stock_master_id'];
$str_qry_del = "DELETE stock_detail.*\n FROM\n stock_detail,stock_master\n where\n stock_master.pk_id = stock_detail.stock_master_id\n and stock_master.pk_id='{$hdn_stock_master_id}' ";
$this->_em = Zend_Registry::get('doctrine');
$row = $row = $this->_em->getConnection()->prepare($str_qry_del);
$row->execute();
$stock_master = $this->_em->getRepository("StockMaster")->find($array['hdn_stock_master_id']);
} else {
$stock_master = new StockMaster();
}
$type = $array['transaction_type_id'];
$time_arr = explode(' ', $array['transaction_date']);
$time = date('H:i:s', strtotime($time_arr[1] . $time_arr[2]));
$stock_master->setTransactionDate(new \DateTime(App_Controller_Functions::dateToDbFormat($time_arr[0]) . '' . $time));
$tran_type = $this->_em->getRepository('TransactionTypes')->find($type);
$stock_master->setTransactionType($tran_type);
$stock_master->setTransactionReference($array['transaction_reference']);
$created_by = $this->_em->getRepository('Users')->find($this->_user_id);
$stock_master->setCreatedBy($created_by);
$stock_master->setParentId(0);
$stock_master->setCreatedDate(new \DateTime(date("Y-m-d")));
$activity_id = $this->_em->getRepository('StakeholderActivities')->find($array['hdn_activity_id']);
$stock_master->setStakeholderActivity($activity_id);
if (!empty($array['campaign_id'])) {
$stock_master->setCampaignId($array['campaign_id']);
}
if (!empty($array['dispatch_by'])) {
$stock_master->setDispatchBy($array['dispatch_by']);
}
//$trans = $this->getTransactionNumber($type, $array['transaction_date']);
if ($type == 1) {
$from_warehouse_id = $this->_em->getRepository('Warehouses')->find($array['from_warehouse_id']);
$stock_master->setFromWarehouse($from_warehouse_id);
$to_warehouse_id = $this->_em->getRepository('Warehouses')->find($this->_identity->getWarehouseId());
$stock_master->setToWarehouse($to_warehouse_id);
} else {
if ($type == 2) {
$from_warehouse_id = $this->_em->getRepository('Warehouses')->find($this->_identity->getWarehouseId());
$stock_master->setFromWarehouse($from_warehouse_id);
$to_warehouse_id = $this->_em->getRepository('Warehouses')->find($array['hdn_receive_warehouse_id']);
$stock_master->setToWarehouse($to_warehouse_id);
}
}
$stock_master->setComments($array['comments']);
$stock_master->setTransactionNumber('TEMP');
$stock_master->setDraft(1);
$this->_em->persist($stock_master);
$this->_em->flush();
$id = $stock_master->getPkId();
return $id;
}