public function saveProgrammedPaymentAction()
{
$id = $this->getRequest()->getParam('id');
$paymentStatus = $this->getRequest()->getParam('payment_status');
$folioImport = FolioImportQuery::create()->findByPK($id);
$sapConnector = new SAPConnectorClient();
$redir = $this->getBaseUrl() . '/' . $this->getRequest()->getParam('controller') . '/list';
$programmedPayments = $this->getRequest()->getParam('payment-term');
$date = \Zend_Date::now();
$results = array();
$this->getCatalog('ProgrammedPaymentCatalog')->beginTransaction();
foreach ($programmedPayments as $programmedPayment) {
if (empty($programmedPayment['id_folios_import_programmed_payment'])) {
$supplier = SapSupplierQuery::create()->findByPK($programmedPayment['id_company']);
$servicePurchaseOrder = PurchaseOrderFactory::createFromArray(array('id_purchase_order' => "0", 'id_supplier' => $supplier->getCardCode(), 'purchase_order_date' => $date->get("yyyy-MM-dd"), 'delivery_estimate_date' => $date->get("yyyy-MM-dd"), 'invoice_number' => 'Pending', 'id_currency' => $programmedPayment['id_currency'], 'comments' => "Folio Import Service Purchase Order", 'groupnum' => $supplier->getGroupnum(), 'status' => PurchaseOrder::$Status["NewService"], 'id_courtyard' => -1, 'id_folio_import' => $programmedPayment['id_folio_import']));
$purchaseOrderEntries = new PurchaseOrderEntryCollection();
$linesCount = 0;
$purchaseOrderEntry = PurchaseOrderEntryFactory::createFromArray(array('line' => $linesCount, "vis_order" => $linesCount, "id_product" => $programmedPayment['concept'], "quantity" => 1, "price" => $programmedPayment['ammount'], "id_warehouse_store" => '9999', "tax_code" => 'W3', 'lead_time' => -1, 'status' => PurchaseOrderEntry::$Status["ServiceEntry"], 'base_line' => -1, 'base_entry' => -1));
$purchaseOrderEntries->append($purchaseOrderEntry);
$result = $sapConnector->servicePurchaseOrder($servicePurchaseOrder, $purchaseOrderEntries);
$results[] = array('success' => $result->purchaseOrderResult->success, 'id_purchase_order' => $result->purchaseOrderResult->id, 'id_folio_import' => $id, 'message' => $result->purchaseOrderResult->message);
if ($result->purchaseOrderResult->success) {
$programmedPayment['doc_entry'] = $result->purchaseOrderResult->id;
$idFolioImportProgrammedPayment = $programmedPayment['id_folios_import_programmed_payment'];
if ($idFolioImportProgrammedPayment) {
if ($programmedPayment['status']) {
unset($programmedPayment['status']);
$folioImportProgrammedPayment = FolioImportProgrammedPaymentFactory::createFromArray($programmedPayment);
$folioImportProgrammedPayment->setType(ProgrammedPayment::$TypePayment['Folio']);
$this->getCatalog('FolioImportProgrammedPaymentCatalog')->update($folioImportProgrammedPayment);
}
} else {
$folioImportProgrammedPayment = FolioImportProgrammedPaymentFactory::createFromArray($programmedPayment);
$folioImportProgrammedPayment->setType(ProgrammedPayment::$TypePayment['Folio']);
$folioImportProgrammedPayment->setStatus(ProgrammedPayment::$TypeStatus['Pending']);
$folioImportProgrammedPayment->setIdFolioImport($id);
$folioImportProgrammedPayment->setFolio($folioImport->getFolio());
$this->getCatalog('FolioImportProgrammedPaymentCatalog')->create($folioImportProgrammedPayment);
}
}
}
}
try {
if ($this->setResponseMessage($results) && $paymentStatus == FolioImport::$PaymentStatus['Inactive']) {
$this->setFlash('warning', 'The payments were closed');
$purchaseOrderQuery = PurchaseOrderQuery::create();
$purchaseOrders = $purchaseOrderQuery->whereAdd(PurchaseOrder::ID_FOLIO_IMPORT, $id)->whereAdd(PurchaseOrder::STATUS, PurchaseOrder::$Status['NewService'], PurchaseOrderQuery::NOT_EQUAL)->find();
$result = $sapConnector->createLandedCost($purchaseOrders);
} else {
$this->setFlash('warning', 'The payments were NOT closed');
}
} catch (Exception $e) {
$this->getCatalog("ProgrammedPaymentCatalog")->rollBack();
$this->setFlash('error', $this->i18n->_($e->getMessage()));
}
$this->newLogForPaymentAdded($folioImport);
$this->getCatalog('ProgrammedPaymentCatalog')->commit();
$this->_redirect('folio-import/list');
}
/**
*
* makeBean
* @param array $resultset
* @return \Application\Model\Bean\FolioImportProgrammedPayment
*/
protected function makeBean($resultset)
{
return FolioImportProgrammedPaymentFactory::createFromArray($resultset);
}
