public function addPipelineConsignments()
{
$form_values = $this->form_values;
$end = $form_values['counter'];
$furute_arrival = new Model_PipelineConsignments();
$vouchers = $furute_arrival->getTempraryNumber($form_values['expected_arrival_date'], 1);
$counter = 0;
for ($i = 0; $i < $end; $i++) {
$row = $form_values["rows" . $i];
if (!empty($row['item_pack_size_id']) && !empty($row['batch_number']) && !empty($row['expiry_date']) && !empty($row['quantity'])) {
$farr = new PipelineConsignments();
$farr->setVoucherNumber($vouchers['temp_no']);
$farr->setTransactionCounter($vouchers['id']);
$farr->setExpectedArrivalDate(new \DateTime(App_Controller_Functions::dateToDbFormat($form_values['expected_arrival_date'])));
$farr->setReferenceNumber($form_values['reference_number']);
$activity = $this->_em->getRepository("StakeholderActivities")->find($form_values['stakeholder_activity_id']);
$farr->setStakeholderActivity($activity);
$farr->setDescription($form_values['description']);
$item_pack_size = $this->_em->getRepository("ItemPackSizes")->find($row['item_pack_size_id']);
$farr->setItemPackSize($item_pack_size);
$farr->setBatchNumber($row['batch_number']);
$farr->setProductionDate(new \DateTime(App_Controller_Functions::dateToDbFormat($row['production_date'])));
$farr->setExpiryDate(new \DateTime(App_Controller_Functions::dateToDbFormat($row['expiry_date'])));
$manufacturer = $this->_em->getRepository("StakeholderItemPackSizes")->find($row['manufacturer_id']);
$farr->setManufacturer($manufacturer);
$vvm_type = $this->_em->getRepository("VvmTypes")->find($row['vvm_type_id']);
$farr->setVvmType($vvm_type);
$farr->setUnitPrice($row['unit_price']);
$quantity = str_replace(",", "", $row['quantity']);
$farr->setQuantity($quantity);
$farr->setReceivedQuantity(0);
$from_wh = $this->_em->getRepository("Warehouses")->find($form_values['from_warehouse_id']);
$farr->setFromWarehouse($from_wh);
$to_wh = $this->_em->getRepository("Warehouses")->find($this->_identity->getWarehouseId());
$farr->setToWarehouse($to_wh);
$user = $this->_em->getRepository("Users")->find($this->_user_id);
$farr->setCreatedBy($user);
$farr->setCreatedDate(new \DateTime(App_Controller_Functions::dateToDbFormat(date("d/m/Y"))));
$farr->setMasterId(0);
$farr->setStatus('Planned');
$tr_type = $this->_em->getRepository("TransactionTypes")->find(1);
$farr->setTransactionType($tr_type);
$this->_em->persist($farr);
$counter++;
}
}
$this->_em->flush();
if ($counter >= 1) {
// Delete Draft entries
$rs = $this->_em->getRepository('PipelineConsignmentsDraft')->findBy(array('toWarehouse' => $this->_identity->getWarehouseId()));
foreach ($rs as $ro) {
$this->_em->remove($ro);
}
$this->_em->flush();
return true;
}
return false;
}
