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; }