Search in sources :

Example 1 with ElectronicInvoiceItemMapping

use of org.kuali.kfs.module.purap.businessobject.ElectronicInvoiceItemMapping in project cu-kfs by CU-CommunityApps.

the class CuElectronicInvoiceHelperServiceImpl method processElectronicInvoice.

// end KFSUPGRADE_483
// KFSUPGRADE-480/KFSUPGRADE-484
@Transactional
protected boolean processElectronicInvoice(ElectronicInvoiceLoad eInvoiceLoad, File invoiceFile, byte[] xmlAsBytes) {
    // Checks parameter to see if files should be moved to the accept/reject folders after load
    boolean moveFiles = BooleanUtils.toBoolean(parameterService.getParameterValueAsString(ElectronicInvoiceStep.class, PurapParameterConstants.ElectronicInvoiceParameters.FILE_MOVE_AFTER_LOAD_IND));
    ElectronicInvoice eInvoice = null;
    boolean isExtractFailure = false;
    boolean isCompleteFailure = false;
    try {
        eInvoice = loadElectronicInvoice(xmlAsBytes);
    } catch (CxmlParseException e) {
        LOG.info("Error loading file - " + e.getMessage());
        rejectElectronicInvoiceFile(eInvoiceLoad, UNKNOWN_DUNS_IDENTIFIER, invoiceFile, e.getMessage(), PurapConstants.ElectronicInvoice.FILE_FORMAT_INVALID);
        isExtractFailure = true;
        updateSummaryCounts(EXTRACT_FAILURES);
    } catch (IllegalArgumentException iae) {
        LOG.info("Error loading file - " + iae.getMessage());
        // rejectElectronicInvoiceFile(eInvoiceLoad, UNKNOWN_DUNS_IDENTIFIER, invoiceFile, iae.getMessage(), PurapConstants.ElectronicInvoice.FILE_FORMAT_INVALID);
        isExtractFailure = true;
        updateSummaryCounts(EXTRACT_FAILURES);
    }
    if (!isExtractFailure) {
        if (ObjectUtils.isNotNull(eInvoice)) {
            eInvoice.setFileName(invoiceFile.getName());
        }
        isCompleteFailure = checkForCompleteFailure(eInvoiceLoad, eInvoice, invoiceFile);
        if (!isCompleteFailure) {
            setVendorDUNSNumber(eInvoice);
            setVendorDetails(eInvoice);
            // CU also refactored getItemTypeMappings with overlay
            Map<String, ElectronicInvoiceItemMapping> itemTypeMappings = getItemTypeMappings(eInvoice.getVendorHeaderID(), eInvoice.getVendorDetailID());
            Map<String, ItemType> kualiItemTypes = getKualiItemTypes();
            if (LOG.isInfoEnabled()) {
                if (itemTypeMappings != null && itemTypeMappings.size() > 0) {
                    LOG.info("Item mappings found");
                }
            }
            boolean validateHeader = true;
            try {
                // ==== CU Customization: Added patterns to test for special characters and/or whitespace. ====
                Pattern specialCharsPattern = Pattern.compile("[^\\p{Graph}\\p{Space}]");
                Pattern specialCharsOrWhitespacePattern = Pattern.compile("[^\\p{Graph}]");
                for (ElectronicInvoiceOrder order : eInvoice.getInvoiceDetailOrders()) {
                    String poID = order.getOrderReferenceOrderID();
                    PurchaseOrderDocument po = null;
                    if (NumberUtils.isDigits(StringUtils.defaultString(poID)) && !isIntegerTooLarge(poID)) {
                        po = purchaseOrderService.getCurrentPurchaseOrder(new Integer(poID));
                        if (po != null) {
                            order.setInvoicePurchaseOrderID(poID);
                            order.setPurchaseOrderID(po.getPurapDocumentIdentifier());
                            order.setPurchaseOrderCampusCode(po.getDeliveryCampusCode());
                            if (LOG.isInfoEnabled()) {
                                LOG.info("PO matching Document found");
                            }
                        }
                    }
                    // ==== CU Customization: Remove special characters from certain ID and description fields. ====
                    Matcher tempMatcher;
                    if (StringUtils.isNotEmpty(order.getOrderReferenceDocumentRefPayloadID())) {
                        tempMatcher = specialCharsOrWhitespacePattern.matcher(order.getOrderReferenceDocumentRefPayloadID());
                        if (tempMatcher.find()) {
                            LOG.warn("Found document ref payload ID with special or whitespace characters; these will be removed. Order: " + order.getOrderReferenceOrderID());
                            order.setOrderReferenceDocumentRefPayloadID(tempMatcher.replaceAll(KRADConstants.EMPTY_STRING));
                        }
                    }
                    if (StringUtils.isNotEmpty(order.getOrderReferenceOrderID())) {
                        tempMatcher = specialCharsOrWhitespacePattern.matcher(order.getOrderReferenceOrderID());
                        if (tempMatcher.find()) {
                            LOG.warn("Found ref order ID with special or whitespace characters; these will be removed. Order: " + order.getOrderReferenceOrderID());
                            order.setOrderReferenceOrderID(tempMatcher.replaceAll(KRADConstants.EMPTY_STRING));
                        }
                    }
                    for (ElectronicInvoiceItem item : order.getInvoiceItems()) {
                        if (StringUtils.isNotEmpty(item.getReferenceDescription())) {
                            tempMatcher = specialCharsPattern.matcher(item.getReferenceDescription());
                            if (tempMatcher.find()) {
                                LOG.warn("Found item description with special characters; these will be removed. Line number: " + item.getInvoiceLineNumber());
                                item.setReferenceDescription(tempMatcher.replaceAll(KRADConstants.EMPTY_STRING));
                            }
                        }
                    }
                    CuElectronicInvoiceOrderHolder orderHolder = new CuElectronicInvoiceOrderHolder(eInvoice, order, po, itemTypeMappings, kualiItemTypes, validateHeader);
                    matchingService.doMatchingProcess(orderHolder);
                    if (orderHolder.isInvoiceRejected()) {
                        ElectronicInvoiceRejectDocument rejectDocument = createRejectDocument(eInvoice, order, eInvoiceLoad);
                        if (orderHolder.getAccountsPayablePurchasingDocumentLinkIdentifier() != null) {
                            rejectDocument.setAccountsPayablePurchasingDocumentLinkIdentifier(orderHolder.getAccountsPayablePurchasingDocumentLinkIdentifier());
                        }
                        String dunsNumber = StringUtils.isEmpty(eInvoice.getDunsNumber()) ? UNKNOWN_DUNS_IDENTIFIER : eInvoice.getDunsNumber();
                        ElectronicInvoiceLoadSummary loadSummary = getOrCreateLoadSummary(eInvoiceLoad, dunsNumber);
                        loadSummary.addFailedInvoiceOrder(rejectDocument.getTotalAmount(), eInvoice);
                        eInvoiceLoad.insertInvoiceLoadSummary(loadSummary);
                        LOG.info("Saving Load Summary for DUNS '" + dunsNumber + "'");
                        SpringContext.getBean(BusinessObjectService.class).save(loadSummary);
                        updateSummaryCounts(REJECT);
                    } else {
                        PaymentRequestDocument preqDoc = createPaymentRequest(orderHolder);
                        if (orderHolder.isInvoiceRejected()) {
                            /**
                             * This is required. If there is anything in the error map, then it's not possible to route the doc since the rice
                             * is throwing error if errormap is not empty before routing the doc.
                             */
                            GlobalVariables.getMessageMap().clearErrorMessages();
                            ElectronicInvoiceRejectDocument rejectDocument = createRejectDocument(eInvoice, order, eInvoiceLoad);
                            if (orderHolder.getAccountsPayablePurchasingDocumentLinkIdentifier() != null) {
                                rejectDocument.setAccountsPayablePurchasingDocumentLinkIdentifier(orderHolder.getAccountsPayablePurchasingDocumentLinkIdentifier());
                            }
                            ElectronicInvoiceLoadSummary loadSummary = getOrCreateLoadSummary(eInvoiceLoad, eInvoice.getDunsNumber());
                            loadSummary.addFailedInvoiceOrder(rejectDocument.getTotalAmount(), eInvoice);
                            eInvoiceLoad.insertInvoiceLoadSummary(loadSummary);
                            LOG.info("Saving Load Summary for DUNS '" + eInvoice.getDunsNumber() + "'");
                            SpringContext.getBean(BusinessObjectService.class).save(loadSummary);
                            updateSummaryCounts(REJECT);
                        } else {
                            ElectronicInvoiceLoadSummary loadSummary = getOrCreateLoadSummary(eInvoiceLoad, eInvoice.getDunsNumber());
                            loadSummary.addSuccessfulInvoiceOrder(preqDoc.getTotalDollarAmount(), eInvoice);
                            eInvoiceLoad.insertInvoiceLoadSummary(loadSummary);
                            LOG.info("Saving Load Summary for DUNS '" + eInvoice.getDunsNumber() + "'");
                            SpringContext.getBean(BusinessObjectService.class).save(loadSummary);
                            updateSummaryCounts(ACCEPT);
                        }
                    }
                    validateHeader = false;
                }
            } catch (Exception ex) {
                LOG.info("Error parsing file - " + ex.getMessage());
                LOG.info("Exception: " + ex.toString());
                rejectElectronicInvoiceFile(eInvoiceLoad, UNKNOWN_DUNS_IDENTIFIER, invoiceFile, ex.getMessage(), PurapConstants.ElectronicInvoice.FILE_FORMAT_INVALID);
                isExtractFailure = true;
                updateSummaryCounts(EXTRACT_FAILURES);
            }
        }
    }
    // Move files into accept/reject folder as appropriate
    boolean success = true;
    if (moveFiles) {
        if (isExtractFailure) {
            LOG.info(invoiceFile.getName() + " has caused a batch extract failure.");
            success = this.moveFile(invoiceFile, getExtractFailureDirName());
            if (!success) {
                String errorMessage = "File with name '" + invoiceFile.getName() + "' could not be moved";
                throw new PurError(errorMessage);
            }
        } else if (isCompleteFailure || (ObjectUtils.isNotNull(eInvoice) && eInvoice.isFileRejected())) {
            LOG.info(invoiceFile.getName() + " has been rejected.");
            success = this.moveFile(invoiceFile, getRejectDirName());
            if (!success) {
                String errorMessage = "File with name '" + invoiceFile.getName() + "' could not be moved";
                throw new PurError(errorMessage);
            }
        } else {
            LOG.info(invoiceFile.getName() + " has been accepted");
            success = this.moveFile(invoiceFile, getAcceptDirName());
            if (!success) {
                String errorMessage = "File with name '" + invoiceFile.getName() + "' could not be moved";
                throw new PurError(errorMessage);
            }
        }
    } else {
        // Add .processed file to each successfully processed einvoice file if move files is not enabled.
        if (!isExtractFailure) {
            String fullPath = FilenameUtils.getFullPath(invoiceFile.getAbsolutePath());
            String fileName = FilenameUtils.getBaseName(invoiceFile.getAbsolutePath());
            File processedFile = new File(fullPath + File.separator + fileName + ".processed");
            try {
                FileUtils.touch(processedFile);
            } catch (IOException e) {
                throw new RuntimeException(e);
            }
        }
    }
    if (ObjectUtils.isNull(eInvoice)) {
        return true;
    }
    return eInvoice.isFileRejected();
}
Also used : Matcher(java.util.regex.Matcher) ItemType(org.kuali.kfs.module.purap.businessobject.ItemType) ElectronicInvoiceItem(org.kuali.kfs.module.purap.businessobject.ElectronicInvoiceItem) PurchaseOrderDocument(org.kuali.kfs.module.purap.document.PurchaseOrderDocument) Pattern(java.util.regex.Pattern) ElectronicInvoiceStep(org.kuali.kfs.module.purap.batch.ElectronicInvoiceStep) ElectronicInvoiceOrder(org.kuali.kfs.module.purap.businessobject.ElectronicInvoiceOrder) ElectronicInvoiceLoadSummary(org.kuali.kfs.module.purap.businessobject.ElectronicInvoiceLoadSummary) ElectronicInvoiceItemMapping(org.kuali.kfs.module.purap.businessobject.ElectronicInvoiceItemMapping) CuPaymentRequestDocument(edu.cornell.kfs.module.purap.document.CuPaymentRequestDocument) PaymentRequestDocument(org.kuali.kfs.module.purap.document.PaymentRequestDocument) IOException(java.io.IOException) ValidationException(org.kuali.kfs.krad.exception.ValidationException) IOException(java.io.IOException) WorkflowException(org.kuali.rice.kew.api.exception.WorkflowException) FileNotFoundException(java.io.FileNotFoundException) RemoteException(java.rmi.RemoteException) CxmlParseException(org.kuali.kfs.module.purap.exception.CxmlParseException) BusinessObjectService(org.kuali.kfs.krad.service.BusinessObjectService) CxmlParseException(org.kuali.kfs.module.purap.exception.CxmlParseException) ElectronicInvoiceRejectDocument(org.kuali.kfs.module.purap.document.ElectronicInvoiceRejectDocument) CuElectronicInvoiceRejectDocument(edu.cornell.kfs.module.purap.document.CuElectronicInvoiceRejectDocument) PurError(org.kuali.kfs.module.purap.exception.PurError) File(java.io.File) ElectronicInvoice(org.kuali.kfs.module.purap.businessobject.ElectronicInvoice) NonTransactional(org.kuali.kfs.sys.service.NonTransactional) Transactional(org.springframework.transaction.annotation.Transactional)

Aggregations

CuElectronicInvoiceRejectDocument (edu.cornell.kfs.module.purap.document.CuElectronicInvoiceRejectDocument)1 CuPaymentRequestDocument (edu.cornell.kfs.module.purap.document.CuPaymentRequestDocument)1 File (java.io.File)1 FileNotFoundException (java.io.FileNotFoundException)1 IOException (java.io.IOException)1 RemoteException (java.rmi.RemoteException)1 Matcher (java.util.regex.Matcher)1 Pattern (java.util.regex.Pattern)1 ValidationException (org.kuali.kfs.krad.exception.ValidationException)1 BusinessObjectService (org.kuali.kfs.krad.service.BusinessObjectService)1 ElectronicInvoiceStep (org.kuali.kfs.module.purap.batch.ElectronicInvoiceStep)1 ElectronicInvoice (org.kuali.kfs.module.purap.businessobject.ElectronicInvoice)1 ElectronicInvoiceItem (org.kuali.kfs.module.purap.businessobject.ElectronicInvoiceItem)1 ElectronicInvoiceItemMapping (org.kuali.kfs.module.purap.businessobject.ElectronicInvoiceItemMapping)1 ElectronicInvoiceLoadSummary (org.kuali.kfs.module.purap.businessobject.ElectronicInvoiceLoadSummary)1 ElectronicInvoiceOrder (org.kuali.kfs.module.purap.businessobject.ElectronicInvoiceOrder)1 ItemType (org.kuali.kfs.module.purap.businessobject.ItemType)1 ElectronicInvoiceRejectDocument (org.kuali.kfs.module.purap.document.ElectronicInvoiceRejectDocument)1 PaymentRequestDocument (org.kuali.kfs.module.purap.document.PaymentRequestDocument)1 PurchaseOrderDocument (org.kuali.kfs.module.purap.document.PurchaseOrderDocument)1