public function uploadPipelineConsignmentsAction() { $this->_helper->layout->disableLayout(); $this->_helper->viewRenderer->setNoRender(TRUE); $type = $this->_request->getPost('type'); if ($this->_request->isPost()) { $em = Zend_Registry::get('doctrine'); $em->getConnection()->beginTransaction(); try { $pipelines = $this->_request->getPost('pipeline'); $receivedqty = $this->_request->getPost('receivedqty'); $vvmstage = $this->_request->getPost('vvmstage'); if (count($pipelines) > 0) { $i = 0; foreach ($pipelines as $row) { if (ABS($receivedqty[$i]) <= 0) { continue; } $str_sql = $this->_em->createQueryBuilder()->select('pc')->from("PipelineConsignments", "pc")->where("pc.pkId = {$row}")->andWhere("pc.status != 'Received'"); $pc = $str_sql->getQuery()->getResult(); $pipeline_consignments = $pc[0]; $locations = array(); if (count($pc) > 0) { $type = $pipeline_consignments->getTransactionType()->getPkId(); $params = array('rec_id' => $pipeline_consignments->getPkId(), 'wh_id' => $pipeline_consignments->getToWarehouse()->getPkId(), 'from_wh_id' => $pipeline_consignments->getFromWarehouse()->getPkId(), 'voucher' => $pipeline_consignments->getVoucherNumber(), 'batch_no' => $pipeline_consignments->getBatchNumber(), 'qty' => $receivedqty[$i], 'trans_type' => $type, 'vvmstage' => $vvmstage[$i]); $p_consignments = new Model_PipelineConsignments(); $p_consignments->form_values = $params; $voucher_number = $p_consignments->uploadPipelineConsignments(); $pipeline_consignments->setReceivedQuantity($receivedqty[$i]); $pipeline_consignments->setStatus("Received"); $this->_em->persist($pipeline_consignments); $this->_em->flush(); } $i++; } } $em->getConnection()->commit(); } catch (Exception $e) { $em->getConnection()->rollback(); $em->close(); } } if ($type == Model_TransactionTypes::TRANSACTION_RECIEVE) { $this->_redirect("stock/search-pipeline-consignments/voucher/{$voucher_number}"); } if ($type == Model_TransactionTypes::TRANSACTION_ISSUE) { $this->_redirect("stock/search-planned-issue/voucher/{$voucher_number}"); } }